ALTER TABLE antaiwuliu.platform_group
MODIFY COLUMN START_TIME varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作开始时间（HH:mm）' AFTER SORTNUM,
MODIFY COLUMN END_TIME varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作结束时间（HH:mm）' AFTER START_TIME,
ADD COLUMN AUTO_CALL int NULL COMMENT '是否自动叫号 0否 1是' AFTER WAIT_CALL_TIME,
ADD COLUMN IS_VIRTUAL int NULL COMMENT '是否虚拟月台 0否 1是' AFTER AUTO_CALL,
ADD COLUMN AUTO_CALL_START_TIME varchar(100) NULL COMMENT '自动叫号截止时间（HH:mm）' AFTER IS_VIRTUAL,
ADD COLUMN AUTO_CALL_END_TIME varchar(100) NULL COMMENT '自动叫号截止时间（HH:mm）' AFTER AUTO_CALL_START_TIME;

ALTER TABLE antaiwuliu.platform
ADD COLUMN TYPE int NULL COMMENT '类型 0整托盘 1散件' AFTER LED_CONTENT,
ADD COLUMN CALL_READY_NUM varchar(100) NULL COMMENT '同时准备作业数量' AFTER TYPE;

ALTER TABLE antaiwuliu.platform_job
ADD COLUMN TAG_VIRTUAL int NULL COMMENT '是否更换月台组 0否 1是' AFTER ORIGIN,
ADD COLUMN TAG_VIRTUAL_TIME datetime NULL COMMENT '更换月台组时间' AFTER TAG_VIRTUAL,
ADD COLUMN TAG_VIRTUAL_USER int NULL COMMENT '更换月台组人员编码' AFTER TAG_VIRTUAL_TIME,
ADD COLUMN CALL_WAY int NULL COMMENT '叫号方式 0手动叫号 1自动叫号' AFTER TAG_VIRTUAL_USER,
ADD COLUMN URGE_TIME datetime(0) NULL DEFAULT NULL COMMENT '加急时间' AFTER CALL_WAY,
ADD COLUMN URGE_USER int NULL DEFAULT NULL COMMENT '加急人员编码' AFTER URGE_TIME;

update platform_group set IS_VIRTUAL=0;
update platform_job set CALL_WAY=0 where CALL_DATE is not null;