From 9d5ff3a521f83d94f9104bda68755449e272a93f Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期五, 16 十月 2026 18:00:39 +0800
Subject: [PATCH] chore(sql): 新增种子质检三类型数据库升级脚本
---
sql/mysql/mes_seed_quality_multitype_upgrade.sql | 235 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 235 insertions(+), 0 deletions(-)
diff --git a/sql/mysql/mes_seed_quality_multitype_upgrade.sql b/sql/mysql/mes_seed_quality_multitype_upgrade.sql
new file mode 100644
index 0000000..e90098d
--- /dev/null
+++ b/sql/mysql/mes_seed_quality_multitype_upgrade.sql
@@ -0,0 +1,235 @@
+-- =====================================================================
+-- 绉嶅瓙璐ㄦ銆岃鐮� / 鎵樼洏鐮� / 鎵规鐮併�嶄笁绉嶆壂鐮佺被鍨� 鈥斺�� 鏁版嵁搴撳崌绾ф�昏剼鏈�
+--
+-- 鐢ㄩ�旓細鎶娿�岀瀛愯川妫�涓夌被鍨� + 鐢熶骇绾挎壂鐮佸叆搴撲笁绫诲瀷銆嶆墍闇�鐨勫簱缁撴瀯涓�娆℃�у榻愩��
+-- 鍏ㄩ儴 DDL 甯﹀瓨鍦ㄦ�у垽鏂紝鍙鍚屼竴鐜閲嶅鎵ц锛屽凡瀛樺湪鐨勫垪/绱㈠紩/琛�/
+-- 鑿滃崟/浠撳簱鏁版嵁浼氳烦杩囷紝涓嶅啀鎶� 1060 Duplicate column name銆�
+--
+-- 鐢ㄦ硶锛氬繀椤诲厛閫夋嫨鏁版嵁搴擄紙use <搴撳悕>锛夊啀鏁翠唤鎵ц锛�
+-- mysql -u<user> -p <搴撳悕> < mes_seed_quality_multitype_upgrade.sql
+-- 鎴栧湪瀹㈡埛绔噷鍏� use <搴撳悕>銆�
+-- 鑻ユ湭閫夊簱锛岀 0 姝ヤ細鏄庣‘鎶ュ嚭锛屼笖鎵�鏈� DDL 涓�寰嬭烦杩囷紙涓嶄細璇敼缁撴瀯锛夈��
+--
+-- 鍓嶇疆琛紙缂哄け璇存槑鐜杩囨棫锛岄渶鍏堣窇瀵瑰簲鍩虹鑴氭湰锛夛細
+-- mes_pro_bag_code / mes_pro_pallet / mes_pro_batch / mes_pro_scan_event
+-- mes_wm_warehouse / mes_wm_warehouse_location / mes_wm_warehouse_area
+-- mes_qc_seed_quality / system_menu
+-- 鍏朵腑 mes_pro_scan_event 鐢� sql/mes_scan_event_inbound.sql 鍒涘缓
+--
+-- 鏈剼鏈笉鍚换浣� DELETE锛屼篃涓嶅仛鏁版嵁鎼縼锛屽彲瀹夊叏鍦ㄧ敓浜у簱鎵ц銆�
+-- 鎻愰啋锛歮es_wm_qualified_warehouse.sql 閲岀殑銆岃櫄鎷熶粨搴撳悎鏍煎簱瀛樻惉杩併�嶆槸鐮村潖鎬�
+-- 鏁版嵁杩佺Щ锛堝厛鍚堝苟鍐嶅垹婧愯褰曪級锛屼笉鍦ㄦ湰鑴氭湰鍐咃紝闇�瑕佹椂鍗曠嫭璇勪及鍚庢墽琛屻��
+-- 鏈剼鏈笉浣跨敤澶氱鎴凤紝鏃� tenant_id 瀛楁銆�
+-- =====================================================================
+
+-- ---------------------------------------------------------------------
+-- 0. 鐩爣搴撶‘璁わ紙鏈�夊簱鏃舵墍鏈� DDL 浼氳璺宠繃锛屽彧鎶ユ彁绀猴級
+-- ---------------------------------------------------------------------
+SET @db = DATABASE();
+SELECT IF(@db IS NULL OR @db = '',
+ '鏈�夋嫨鏁版嵁搴擄細璇峰厛 use <搴撳悕> 鍐嶆墽琛屾湰鑴氭湰锛屾湰娆℃湭鍋氫换浣曠粨鏋勫彉鏇�',
+ CONCAT('鐩爣搴擄細', @db)) AS db_check;
+
+-- ---------------------------------------------------------------------
+-- 1. 姣忚璐ㄦ鐘舵�侊細璐ㄦ鎸夎绮掑害娴佽浆銆侀攢鍞嚭搴撴牎楠岀殑渚濇嵁
+-- ---------------------------------------------------------------------
+SET @exists = (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = @db AND table_name = 'mes_pro_bag_code' AND column_name = 'qc_status');
+SET @sql = IF(@db IS NOT NULL AND @exists = 0,
+ 'ALTER TABLE `mes_pro_bag_code` ADD COLUMN `qc_status` TINYINT NOT NULL DEFAULT 10 COMMENT ''璐ㄦ鐘舵�侊紙10鏈川妫� 20璐ㄦ鍚堟牸 30璐ㄦ涓嶅悎鏍硷級'' AFTER `status`',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 瀛橀噺鍥炲～锛氭寜宸叉湁绉嶅瓙璐ㄦ璁板綍鍚屾琚嬬爜璐ㄦ鐘舵�侊紙骞傜瓑锛屼粎鏀逛笉涓�鑷寸殑琛岋級
+UPDATE `mes_pro_bag_code` b
+ JOIN `mes_qc_seed_quality` q ON b.code = q.code AND b.deleted = 0
+SET b.qc_status = IF(q.result = 1, 20, 30), b.update_time = NOW()
+WHERE b.qc_status <> IF(q.result = 1, 20, 30);
+
+-- ---------------------------------------------------------------------
+-- 2. 鍗曡鍏ュ簱鏍囪锛歳esolve 鐨� inbound 鍒ゆ柇銆乻ubmit-group 鐨�
+-- 銆屾湁鏁堣鐮佸繀椤诲叏閮ㄥ叆搴撱�嶆牎楠岄兘渚濊禆璇ュ垪
+-- ---------------------------------------------------------------------
+SET @exists = (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = @db AND table_name = 'mes_pro_bag_code' AND column_name = 'inbound_event_id');
+SET @sql = IF(@db IS NOT NULL AND @exists = 0,
+ 'ALTER TABLE `mes_pro_bag_code` ADD COLUMN `inbound_event_id` BIGINT NULL COMMENT ''鍏ュ簱浜嬩欢ID''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- ---------------------------------------------------------------------
+-- 3. 涓変釜鍐呴儴涓氬姟鐮侊細鎵樼洏鐮� / 鎵规鐮佽瘑鍒椂涓庤拷婧爜閿佸畾鍚屼竴瀵硅薄锛岄槻姝㈤噸澶嶈川妫�
+-- ---------------------------------------------------------------------
+SET @exists = (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = @db AND table_name = 'mes_pro_bag_code' AND column_name = 'business_code');
+SET @sql = IF(@db IS NOT NULL AND @exists = 0,
+ 'ALTER TABLE `mes_pro_bag_code` ADD COLUMN `business_code` VARCHAR(16) DEFAULT NULL COMMENT ''鍐呴儴鍑哄叆搴撲笟鍔＄爜锛�16浣嶆暟瀛楋級'' AFTER `code`',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @exists = (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = @db AND table_name = 'mes_pro_pallet' AND column_name = 'business_code');
+SET @sql = IF(@db IS NOT NULL AND @exists = 0,
+ 'ALTER TABLE `mes_pro_pallet` ADD COLUMN `business_code` VARCHAR(16) DEFAULT NULL COMMENT ''鍐呴儴鍑哄叆搴撲笟鍔＄爜锛�16浣嶆暟瀛楋級'' AFTER `code`',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @exists = (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = @db AND table_name = 'mes_pro_batch' AND column_name = 'business_code');
+SET @sql = IF(@db IS NOT NULL AND @exists = 0,
+ 'ALTER TABLE `mes_pro_batch` ADD COLUMN `business_code` VARCHAR(16) DEFAULT NULL COMMENT ''鍐呴儴鍑哄叆搴撲笟鍔＄爜锛�16浣嶆暟瀛楋級'' AFTER `code`',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @exists = (SELECT COUNT(*) FROM information_schema.statistics
+ WHERE table_schema = @db AND table_name = 'mes_pro_bag_code' AND index_name = 'uk_business_code');
+SET @sql = IF(@db IS NOT NULL AND @exists = 0,
+ 'ALTER TABLE `mes_pro_bag_code` ADD UNIQUE KEY `uk_business_code` (`business_code`)', 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @exists = (SELECT COUNT(*) FROM information_schema.statistics
+ WHERE table_schema = @db AND table_name = 'mes_pro_pallet' AND index_name = 'uk_business_code');
+SET @sql = IF(@db IS NOT NULL AND @exists = 0,
+ 'ALTER TABLE `mes_pro_pallet` ADD UNIQUE KEY `uk_business_code` (`business_code`)', 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @exists = (SELECT COUNT(*) FROM information_schema.statistics
+ WHERE table_schema = @db AND table_name = 'mes_pro_batch' AND index_name = 'uk_business_code');
+SET @sql = IF(@db IS NOT NULL AND @exists = 0,
+ 'ALTER TABLE `mes_pro_batch` ADD UNIQUE KEY `uk_business_code` (`business_code`)', 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 鍘嗗彶鏁版嵁涓嶇敱鑴氭湰澶嶅埗杩芥函鐮侊紝閬垮厤涓氬姟鐮佷笌杩芥函鐮侀噸澶嶏紱鍦ㄣ�岃鐮佸垪琛ㄣ�嶉〉闈㈠嬀閫夎ˉ鐢熸垚銆�
+
+-- ---------------------------------------------------------------------
+-- 4. 鐢熶骇绾挎壂鐮佸叆搴擄細涓夌鎵爜绫诲瀷 + 璁惧缂栫爜闈炲繀濉� + 鏁存墭鍏ュ簱鍘婚噸鏍囪
+-- ---------------------------------------------------------------------
+SET @exists = (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = @db AND table_name = 'mes_pro_scan_event' AND column_name = 'scan_type');
+SET @sql = IF(@db IS NOT NULL AND @exists = 0,
+ 'ALTER TABLE `mes_pro_scan_event` ADD COLUMN `scan_type` VARCHAR(16) NULL COMMENT ''鎵爜绫诲瀷锛圔AG琚嬬爜/PALLET鎵樼洏鐮�/BATCH鎵规鐮侊級'' AFTER `bag_code`',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 璁惧缂栫爜鏀逛负闈炲繀濉紙鍓嶇宸插幓鎺夎褰曞叆椤癸紝鍘嗗彶鍒椾繚鎸佸吋瀹癸級銆�
+-- MODIFY 鏈韩鍙噸澶嶆墽琛岋紱琛ㄤ笉瀛樺湪鏃朵細鎶ラ敊锛屽睘棰勬湡锛堣鏄庢湭璺戝熀纭�鑴氭湰锛夈��
+ALTER TABLE `mes_pro_scan_event`
+ MODIFY COLUMN `device_code` VARCHAR(64) NULL DEFAULT NULL COMMENT '璁惧缂栫爜锛堜笉鍐嶅繀濉級';
+
+SET @exists = (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = @db AND table_name = 'mes_pro_pallet' AND column_name = 'inbound_event_id');
+SET @sql = IF(@db IS NOT NULL AND @exists = 0,
+ 'ALTER TABLE `mes_pro_pallet` ADD COLUMN `inbound_event_id` BIGINT NULL COMMENT ''鏈�杩戝叆搴撴壂鐮佷簨浠剁紪鍙�'' AFTER `bag_count`',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @exists = (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = @db AND table_name = 'mes_pro_pallet' AND column_name = 'inbound_time');
+SET @sql = IF(@db IS NOT NULL AND @exists = 0,
+ 'ALTER TABLE `mes_pro_pallet` ADD COLUMN `inbound_time` DATETIME NULL COMMENT ''鏈�杩戝叆搴撴椂闂�'' AFTER `inbound_event_id`',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 鍘嗗彶鎵爜浜嬩欢鎸夎鐮佸鐞�
+UPDATE `mes_pro_scan_event` SET `scan_type` = 'BAG' WHERE `scan_type` IS NULL;
+
+-- ---------------------------------------------------------------------
+-- 5. 浠撳簱绫诲瀷 + 鍚堟牸搴撴暟鎹�
+-- 璐ㄦ椤点�屽叆搴撳悎鏍煎簱銆嶄笅鎷夊彧鍒� type=20 涓旀湭鍐荤粨鐨勪粨搴擄紝缂轰簡鏃犳硶鎻愪氦璐ㄦ
+-- ---------------------------------------------------------------------
+SET @exists = (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = @db AND table_name = 'mes_wm_warehouse' AND column_name = 'type');
+SET @sql = IF(@db IS NOT NULL AND @exists = 0,
+ 'ALTER TABLE `mes_wm_warehouse` ADD COLUMN `type` TINYINT NOT NULL DEFAULT 10 COMMENT ''浠撳簱绫诲瀷锛�10鏆傚瓨搴擄紝20鍚堟牸搴�'' AFTER `frozen`',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 鐜版湁浠撳簱褰掔被锛氳櫄鎷熺嚎杈逛粨搴�=鏆傚瓨搴擄紱浜у搧搴�/鐗╂枡搴�=鍚堟牸搴�
+UPDATE `mes_wm_warehouse` SET `type` = 10 WHERE `code` = 'WIP_VIRTUAL_WAREHOUSE' AND `deleted` = 0;
+UPDATE `mes_wm_warehouse` SET `type` = 20 WHERE `code` IN ('1212', 'WHS000001') AND `deleted` = 0;
+
+-- 鏂板缓銆屾垚鍝佸悎鏍煎簱銆�+ 搴撳尯 + 搴撲綅锛堝箓绛夛級
+INSERT INTO `mes_wm_warehouse` (`code`, `name`, `frozen`, `type`, `remark`)
+SELECT 'FG_QUALIFIED_WH', '鎴愬搧鍚堟牸搴�', 0, 20, '璐ㄦ鍚堟牸鐩存帴鍏ュ簱鐨勭洰鏍囦粨搴擄紙type=20 鍚堟牸搴擄級'
+WHERE NOT EXISTS (SELECT 1 FROM `mes_wm_warehouse` WHERE `code` = 'FG_QUALIFIED_WH' AND `deleted` = 0);
+SET @wh_id = (SELECT `id` FROM `mes_wm_warehouse` WHERE `code` = 'FG_QUALIFIED_WH' AND `deleted` = 0 LIMIT 1);
+
+INSERT INTO `mes_wm_warehouse_location` (`code`, `name`, `warehouse_id`, `frozen`, `remark`)
+SELECT 'FG_QUALIFIED_WH_LOC', '鎴愬搧鍚堟牸搴撳尯', @wh_id, 0, '璐ㄦ鍚堟牸鍏ュ簱榛樿搴撳尯'
+WHERE NOT EXISTS (SELECT 1 FROM `mes_wm_warehouse_location` WHERE `code` = 'FG_QUALIFIED_WH_LOC' AND `deleted` = 0);
+SET @loc_id = (SELECT `id` FROM `mes_wm_warehouse_location` WHERE `code` = 'FG_QUALIFIED_WH_LOC' AND `deleted` = 0 LIMIT 1);
+
+INSERT INTO `mes_wm_warehouse_area` (`code`, `name`, `location_id`, `frozen`, `remark`)
+SELECT 'FG_QUALIFIED_WH_AREA', '鎴愬搧鍚堟牸搴撲綅', @loc_id, 0, '璐ㄦ鍚堟牸鍏ュ簱榛樿搴撲綅'
+WHERE NOT EXISTS (SELECT 1 FROM `mes_wm_warehouse_area` WHERE `code` = 'FG_QUALIFIED_WH_AREA' AND `deleted` = 0);
+
+-- ---------------------------------------------------------------------
+-- 6. 鎸夎搴撳瓨鏄庣粏琛細璐ㄦ鍚堟牸 / 涓嶅悎鏍兼寜琚嬫墸鏆傚瓨銆佸叆鍚堟牸搴�
+-- ---------------------------------------------------------------------
+CREATE TABLE IF NOT EXISTS `mes_wm_material_stock_bag` (
+ `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `material_stock_id` BIGINT NOT NULL COMMENT '搴撳瓨姹囨�昏褰旾D',
+ `bag_code_id` BIGINT NOT NULL COMMENT '鐢熶骇琚嬬爜ID',
+ `bag_code` VARCHAR(64) NOT NULL COMMENT '琚嬬爜',
+ `item_id` BIGINT NOT NULL COMMENT '鐗╂枡ID',
+ `batch_id` BIGINT NULL COMMENT '浠撳簱鎵规ID',
+ `batch_code` VARCHAR(64) NULL COMMENT '鎵规鍙�',
+ `vendor_id` BIGINT NULL COMMENT '渚涘簲鍟咺D',
+ `warehouse_id` BIGINT NOT NULL COMMENT '浠撳簱ID',
+ `location_id` BIGINT NULL COMMENT '搴撳尯ID',
+ `area_id` BIGINT NULL COMMENT '搴撲綅ID',
+ `stock_state` TINYINT NOT NULL COMMENT '搴撳瓨鐘舵�侊細10鏆傚瓨锛�20鍚堟牸锛�30宸插嚭搴擄紝40鎶ュ簾',
+ `status` TINYINT NOT NULL DEFAULT 1 COMMENT '鏄庣粏鐘舵�侊細1鍦ㄥ簱锛�2宸插嚭搴擄紝3宸叉姤搴�',
+ `quantity` DECIMAL(18, 6) NOT NULL DEFAULT 1 COMMENT '琚嬬爜搴撳瓨鏁伴噺',
+ `frozen` BIT NOT NULL DEFAULT 0 COMMENT '鏄惁鍐荤粨',
+ `last_transaction_id` BIGINT NULL COMMENT '鏈�杩戝簱瀛樹簨鍔D',
+ `inbound_time` DATETIME NULL COMMENT '鍏ュ簱鏃堕棿',
+ `outbound_time` DATETIME NULL COMMENT '鍑哄簱鏃堕棿',
+ `creator` VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�',
+ `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ `updater` VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�',
+ `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+ `deleted` BIT NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `uk_bag_code` (`bag_code`),
+ KEY `idx_material_stock` (`material_stock_id`),
+ KEY `idx_batch_state` (`batch_id`, `stock_state`, `status`),
+ KEY `idx_location_state` (`warehouse_id`, `location_id`, `area_id`, `stock_state`, `status`),
+ KEY `idx_bag_code_id` (`bag_code_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='MES搴撳瓨琚嬬爜鏄庣粏';
+
+-- ---------------------------------------------------------------------
+-- 7. 璐ㄦ璁板綍鐙珛鑿滃崟锛堟寕鍦ㄣ�岃川閲忕鐞嗐��5500 涓嬶級
+-- ---------------------------------------------------------------------
+INSERT INTO `system_menu`
+(`id`, `name`, `parent_id`, `type`, `sort`, `status`, `path`, `icon`, `component`, `component_name`, `permission`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+SELECT 1065224, '璐ㄦ璁板綍', 5500, 2, 95, 0, 'seed-quality-record', 'ep:list', 'mes/qc/seedQuality/record', 'MesQcSeedQualityRecord', '', b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL
+WHERE NOT EXISTS (SELECT 1 FROM `system_menu` WHERE `id` = 1065224 AND `deleted` = b'0');
+
+-- ---------------------------------------------------------------------
+-- 8. 鎵ц鍚庤嚜妫�锛氭瘡椤� present=1 涓哄氨缁紱鏈�鍚庝竴椤瑰簲 >= 1
+-- 鑻ュ叏閮ㄤ负 0锛屽鍗婃槸绗� 0 姝ユ姤鐨勩�屾湭閫夋嫨鏁版嵁搴撱��
+-- ---------------------------------------------------------------------
+SELECT 'mes_pro_bag_code.qc_status' AS item, COUNT(*) AS present FROM information_schema.columns
+ WHERE table_schema = @db AND table_name = 'mes_pro_bag_code' AND column_name = 'qc_status'
+UNION ALL SELECT 'mes_pro_bag_code.inbound_event_id', COUNT(*) FROM information_schema.columns
+ WHERE table_schema = @db AND table_name = 'mes_pro_bag_code' AND column_name = 'inbound_event_id'
+UNION ALL SELECT 'mes_pro_bag_code.business_code', COUNT(*) FROM information_schema.columns
+ WHERE table_schema = @db AND table_name = 'mes_pro_bag_code' AND column_name = 'business_code'
+UNION ALL SELECT 'mes_pro_pallet.business_code', COUNT(*) FROM information_schema.columns
+ WHERE table_schema = @db AND table_name = 'mes_pro_pallet' AND column_name = 'business_code'
+UNION ALL SELECT 'mes_pro_batch.business_code', COUNT(*) FROM information_schema.columns
+ WHERE table_schema = @db AND table_name = 'mes_pro_batch' AND column_name = 'business_code'
+UNION ALL SELECT 'mes_pro_scan_event.scan_type', COUNT(*) FROM information_schema.columns
+ WHERE table_schema = @db AND table_name = 'mes_pro_scan_event' AND column_name = 'scan_type'
+UNION ALL SELECT 'mes_pro_pallet.inbound_event_id', COUNT(*) FROM information_schema.columns
+ WHERE table_schema = @db AND table_name = 'mes_pro_pallet' AND column_name = 'inbound_event_id'
+UNION ALL SELECT 'mes_pro_pallet.inbound_time', COUNT(*) FROM information_schema.columns
+ WHERE table_schema = @db AND table_name = 'mes_pro_pallet' AND column_name = 'inbound_time'
+UNION ALL SELECT 'mes_wm_warehouse.type', COUNT(*) FROM information_schema.columns
+ WHERE table_schema = @db AND table_name = 'mes_wm_warehouse' AND column_name = 'type'
+UNION ALL SELECT 'TABLE mes_wm_material_stock_bag', COUNT(*) FROM information_schema.tables
+ WHERE table_schema = @db AND table_name = 'mes_wm_material_stock_bag'
+UNION ALL SELECT 'MENU 璐ㄦ璁板綍 1065224', COUNT(*) FROM `system_menu` WHERE `id` = 1065224 AND `deleted` = b'0'
+UNION ALL SELECT 'DATA type=20 鏈喕缁撲粨搴�', COUNT(*) FROM `mes_wm_warehouse` WHERE `type` = 20 AND `frozen` = 0 AND `deleted` = 0;
--
Gitblit v1.9.3