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;