From 101b19d25dffc9bef8436bd58f5d6cacb9a30502 Mon Sep 17 00:00:00 2001 From: MrShi <1878285526@qq.com> Date: 星期一, 08 十二月 2025 16:21:27 +0800 Subject: [PATCH] 优化 --- server/doc/月台自动加号数据库变动脚本.md | 14 ++++++++------ 1 files changed, 8 insertions(+), 6 deletions(-) diff --git "a/server/doc/\346\234\210\345\217\260\350\207\252\345\212\250\345\212\240\345\217\267\346\225\260\346\215\256\345\272\223\345\217\230\345\212\250\350\204\232\346\234\254.md" "b/server/doc/\346\234\210\345\217\260\350\207\252\345\212\250\345\212\240\345\217\267\346\225\260\346\215\256\345\272\223\345\217\230\345\212\250\350\204\232\346\234\254.md" index acae40f..e46d7b3 100644 --- "a/server/doc/\346\234\210\345\217\260\350\207\252\345\212\250\345\212\240\345\217\267\346\225\260\346\215\256\345\272\223\345\217\230\345\212\250\350\204\232\346\234\254.md" +++ "b/server/doc/\346\234\210\345\217\260\350\207\252\345\212\250\345\212\240\345\217\267\346\225\260\346\215\256\345\272\223\345\217\230\345\212\250\350\204\232\346\234\254.md" @@ -8,16 +8,18 @@ ADD COLUMN `AUTO_CALL_END_TIME` varchar(100) NULL COMMENT '鑷姩鍙彿鎴鏃堕棿锛圚H:mm锛�' AFTER `AUTO_CALL_START_TIME`; ALTER TABLE `antaiwuliu`.`platform` -ADD COLUMN `TYPE` int NULL COMMENT '绫诲瀷 0鏁存墭鐩� 1鏁ｄ欢' AFTER `LED_CONTENT`; - +ADD COLUMN `TYPE` int NULL COMMENT '绫诲瀷 0鏁存墭鐩� 1鏁ｄ欢' AFTER `LED_CONTENT`, +ADD COLUMN `CALL_READY_NUM` int 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 `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; \ No newline at end of file +update platform_job set CALL_WAY=0 where CALL_DATE is not null; + +INSERT INTO `system_dict_data`( `DICT_ID`, `CODE`, `LABEL`, `SORT`, `DISABLED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`, `REMARK`) VALUES ( 1, '02', 'IN_REPERTOTY_CODE', 1, 0, 0, '2023-04-03 10:23:54', NULL, '2024-04-30 11:04:25', 0, '鑷姩鍙彿鍙戣揣鍦扮紪鍙�'); \ No newline at end of file -- Gitblit v1.9.3