From 24369ea574d42106dac74fd16dabb9a24ef481c0 Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期五, 30 十月 2026 20:28:27 +0800
Subject: [PATCH] chore(sql): 新增接口 500 修复的合并版脚本
---
sql/mysql/fix_api_500_schema_20261030_all.sql | 1247 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 1,247 insertions(+), 0 deletions(-)
diff --git a/sql/mysql/fix_api_500_schema_20261030_all.sql b/sql/mysql/fix_api_500_schema_20261030_all.sql
new file mode 100644
index 0000000..1c27724
--- /dev/null
+++ b/sql/mysql/fix_api_500_schema_20261030_all.sql
@@ -0,0 +1,1247 @@
+-- ============================================================================
+-- 搴锋剰鏅鸿兘 mom-kyzn 鏁版嵁搴撲慨澶嶆�昏剼鏈�
+-- 鐢熸垚鏃ユ湡锛�2026-10-30
+--
+-- 鐢ㄩ�旓細淇鍏ㄩ噺鎺ュ彛娴嬭瘯鍙戠幇鐨� 500 绯荤粺寮傚父鎵�渚濊禆鐨勬暟鎹簱缁撴瀯缂哄け
+-- 鍐呭锛�
+-- 绗竴鎵� 缂哄け琛�/鍒� + mes_wm_return_issue.type 绫诲瀷淇
+-- 绗簩鎵� 17 涓己澶卞垪
+-- 绗笁鎵� 29 涓己澶卞垪锛堟寜 DO 瀹炰綋鑷姩姣斿鐢熸垚锛�
+-- 绗洓鎵� 16 寮犵己澶辫〃 + tenant_id
+--
+-- 鐗规�э細鍏ㄩ儴璇彞骞傜瓑锛圛F NOT EXISTS / information_schema 鍒ゆ柇锛夛紝鍙噸澶嶆墽琛�
+-- 鍓嶆彁锛歁ySQL 8.x锛屽簱鍚� mom-kyzn
+-- 娉ㄦ剰锛氬寘鍚� ALTER TABLE / CREATE TABLE锛岃鍏堝浠斤紝涓氬姟浣庡嘲鏈熸墽琛�
+-- ============================================================================
+
+SET NAMES utf8mb4;
+SET FOREIGN_KEY_CHECKS = 0;
+
+
+-- ############################################################################
+-- ## 鏉ユ簮鏂囦欢锛歠ix_api_500_schema_20261030.sql
+-- ############################################################################
+-- ============================================================================
+-- 鎺ュ彛 500 淇锛氳ˉ榻愮己澶辫〃 / 缂哄け鍒� / 绫诲瀷涓嶄竴鑷�
+--
+-- 鑳屾櫙锛氬叏閲忔帴鍙f帰娴嬪彂鐜� 60 涓帴鍙h繑鍥� code=500锛屾牴鍥犲垎涓夌被锛�
+-- 1. 琛ㄤ笉瀛樺湪锛坢ember_* 9 寮犮�乭rm_social_security_config锛�
+-- 2. 鍒椾笉瀛樺湪锛堢洏鐐广�佽�冨嫟銆佸鍗忋�佽绠辩瓑锛�
+-- 3. 鍒楃被鍨嬩笌瀹炰綋涓嶅尮閰嶏紙mes_wm_return_issue.type 涓� varchar锛屽疄浣撴槸 Integer锛�
+--
+-- 鐗规�э細骞傜瓑銆傚彲閲嶅鎵ц锛屽凡瀛樺湪鐨勮〃/鍒椾笉浼氭姤閿欍��
+-- 閫傜敤锛歁ySQL 8.x锛堝簱鍚� mom-kyzn锛�
+-- ============================================================================
+
+-- ---------------------------------------------------------------------------
+-- 涓�銆佽ˉ榻愮己澶辩殑鍒�
+-- ---------------------------------------------------------------------------
+
+-- 1.1 MES 鐩樼偣浠诲姟锛氱己 taking_date
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_stock_taking_task'
+ AND column_name = 'taking_date');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `mes_wm_stock_taking_task` ADD COLUMN `taking_date` date DEFAULT NULL COMMENT ''鐩樼偣鏃ユ湡'' AFTER `name`',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 1.2 MES 鐩樼偣浠诲姟琛岋細缂� batch_code
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_stock_taking_task_line'
+ AND column_name = 'batch_code');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `mes_wm_stock_taking_task_line` ADD COLUMN `batch_code` varchar(64) DEFAULT NULL COMMENT ''鎵规鍙�'' AFTER `batch_id`',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 1.3 MES 鐩樼偣缁撴灉锛氱己 batch_code
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_stock_taking_task_result'
+ AND column_name = 'batch_code');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `mes_wm_stock_taking_task_result` ADD COLUMN `batch_code` varchar(64) DEFAULT NULL COMMENT ''鎵规鍙�'' AFTER `batch_id`',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 1.4 HRM 鑰冨嫟瑙勫垯锛氱己 location_name
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'hrm_attendance_rule'
+ AND column_name = 'location_name');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `hrm_attendance_rule` ADD COLUMN `location_name` varchar(200) DEFAULT NULL COMMENT ''鎵撳崱鍦扮偣鍚嶇О''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 1.5 HRM 鑰冨嫟璁板綍锛氱己鎵撳崱缁忕含搴�
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'hrm_attendance_record'
+ AND column_name = 'clock_in_longitude');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `hrm_attendance_record` ADD COLUMN `clock_in_longitude` decimal(10,6) DEFAULT NULL COMMENT ''涓婄彮鎵撳崱缁忓害''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'hrm_attendance_record'
+ AND column_name = 'clock_in_latitude');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `hrm_attendance_record` ADD COLUMN `clock_in_latitude` decimal(10,6) DEFAULT NULL COMMENT ''涓婄彮鎵撳崱绾害''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'hrm_attendance_record'
+ AND column_name = 'clock_out_longitude');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `hrm_attendance_record` ADD COLUMN `clock_out_longitude` decimal(10,6) DEFAULT NULL COMMENT ''涓嬬彮鎵撳崱缁忓害''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'hrm_attendance_record'
+ AND column_name = 'clock_out_latitude');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `hrm_attendance_record` ADD COLUMN `clock_out_latitude` decimal(10,6) DEFAULT NULL COMMENT ''涓嬬彮鎵撳崱绾害''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 1.6 MES 澶栧崗鍙戞枡琛岋細缂� material_stock_id
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_outsource_issue_line'
+ AND column_name = 'material_stock_id');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `mes_wm_outsource_issue_line` ADD COLUMN `material_stock_id` bigint DEFAULT NULL COMMENT ''搴撳瓨璁板綍缂栧彿''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 1.7 MES 澶栧崗鍏ュ簱琛岋細缂� batch_id / batch_code
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_outsource_receipt_line'
+ AND column_name = 'batch_id');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `mes_wm_outsource_receipt_line` ADD COLUMN `batch_id` bigint DEFAULT NULL COMMENT ''鎵规缂栧彿''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_outsource_receipt_line'
+ AND column_name = 'batch_code');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `mes_wm_outsource_receipt_line` ADD COLUMN `batch_code` varchar(64) DEFAULT NULL COMMENT ''鎵规鍙�'' AFTER `batch_id`',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 1.8 MES 瑁呯鏄庣粏锛氱己 work_order_id
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_package_line'
+ AND column_name = 'work_order_id');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `mes_wm_package_line` ADD COLUMN `work_order_id` bigint DEFAULT NULL COMMENT ''鐢熶骇宸ュ崟缂栧彿''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- ---------------------------------------------------------------------------
+-- 浜屻�佷慨姝g被鍨嬩笉涓�鑷达細mes_wm_return_issue.type
+-- 寤鸿〃鏃朵负 varchar(255)锛屽疄浣撲负 Integer锛屽巻鍙叉暟鎹瓨浜嗕腑鏂囷紝璇诲彇鏃舵姤
+-- "Cannot determine value type from string"
+-- ---------------------------------------------------------------------------
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_return_issue'
+ AND column_name = 'type' AND data_type IN ('varchar', 'char', 'text'));
+SET @sql := IF(@exists > 0,
+ 'UPDATE `mes_wm_return_issue` SET `type` = CASE `type`
+ WHEN ''浣欐枡閫�鏂�'' THEN ''1''
+ WHEN ''涓嶈壇閫�鏂�'' THEN ''2''
+ WHEN ''鍏朵粬閫�鏂�'' THEN ''3''
+ ELSE `type` END
+ WHERE `type` IS NOT NULL AND `type` NOT REGEXP ''^[0-9]+$''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_return_issue'
+ AND column_name = 'type' AND data_type IN ('varchar', 'char', 'text'));
+SET @sql := IF(@exists > 0,
+ 'ALTER TABLE `mes_wm_return_issue` MODIFY COLUMN `type` int DEFAULT NULL COMMENT ''閫�鏂欑被鍨嬶細1-浣欐枡閫�鏂� 2-涓嶈壇閫�鏂� 3-鍏朵粬閫�鏂�''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- ---------------------------------------------------------------------------
+-- 涓夈�佽ˉ榻愮己澶辩殑琛紙member 妯″潡 9 寮� + HRM 绀句繚閰嶇疆 1 寮狅級
+-- ---------------------------------------------------------------------------
+
+CREATE TABLE IF NOT EXISTS `member_user` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `mobile` varchar(11) NOT NULL COMMENT '鎵嬫満鍙�',
+ `email` varchar(50) DEFAULT NULL COMMENT '閭',
+ `password` varchar(100) NOT NULL DEFAULT '' COMMENT '瀵嗙爜',
+ `status` tinyint NOT NULL COMMENT '鐘舵��',
+ `register_ip` varchar(32) NOT NULL COMMENT '娉ㄥ唽 IP',
+ `register_terminal` int DEFAULT NULL COMMENT '娉ㄥ唽缁堢',
+ `login_ip` varchar(50) DEFAULT '' COMMENT '鏈�鍚庣櫥褰旾P',
+ `login_date` datetime DEFAULT NULL COMMENT '鏈�鍚庣櫥褰曟椂闂�',
+ `nickname` varchar(30) NOT NULL DEFAULT '' COMMENT '鐢ㄦ埛鏄电О',
+ `avatar` varchar(512) NOT NULL DEFAULT '' COMMENT '澶村儚',
+ `name` varchar(30) DEFAULT NULL COMMENT '鐪熷疄鍚嶅瓧',
+ `sex` tinyint DEFAULT NULL COMMENT '鎬у埆',
+ `birthday` datetime DEFAULT NULL COMMENT '鍑虹敓鏃ユ湡',
+ `area_id` int DEFAULT NULL COMMENT '鎵�鍦ㄥ湴',
+ `mark` varchar(255) DEFAULT NULL COMMENT '鐢ㄦ埛澶囨敞',
+ `point` int DEFAULT 0 COMMENT '绉垎',
+ `tag_ids` varchar(255) DEFAULT NULL COMMENT '鐢ㄦ埛鏍囩缂栧彿鍒楄〃锛岄�楀彿鍒嗛殧',
+ `level_id` bigint DEFAULT NULL COMMENT '绛夌骇缂栧彿',
+ `experience` int DEFAULT NULL COMMENT '缁忛獙',
+ `group_id` bigint DEFAULT 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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`),
+ KEY `idx_mobile` (`mobile`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='浼氬憳鐢ㄦ埛';
+
+CREATE TABLE IF NOT EXISTS `member_tag` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `name` varchar(30) NOT 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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='浼氬憳鏍囩';
+
+CREATE TABLE IF NOT EXISTS `member_level` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `name` varchar(30) NOT NULL COMMENT '绛夌骇鍚嶇О',
+ `level` int NOT NULL COMMENT '绛夌骇',
+ `experience` int NOT NULL COMMENT '鍗囩骇缁忛獙',
+ `discount_percent` int NOT NULL COMMENT '鎶樻墸鐧惧垎姣�',
+ `icon` varchar(255) NOT NULL COMMENT '鍥炬爣',
+ `background_url` varchar(255) NOT NULL COMMENT '鑳屾櫙鍥�',
+ `status` tinyint NOT NULL DEFAULT 0 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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='浼氬憳绛夌骇';
+
+CREATE TABLE IF NOT EXISTS `member_group` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `name` varchar(30) NOT NULL COMMENT '鍒嗙粍鍚嶇О',
+ `remark` varchar(255) DEFAULT NULL COMMENT '澶囨敞',
+ `status` tinyint NOT NULL DEFAULT 0 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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='浼氬憳鍒嗙粍';
+
+CREATE TABLE IF NOT EXISTS `member_config` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `point_trade_deduct_enable` bit(1) NOT NULL DEFAULT b'0' COMMENT '绉垎鎶垫墸寮�鍏�',
+ `point_trade_deduct_unit_price` int DEFAULT NULL COMMENT '绉垎鎶垫墸鍗曚环',
+ `point_trade_deduct_max_price` int DEFAULT NULL COMMENT '绉垎鎶垫墸鏈�澶ч噾棰�',
+ `point_trade_give_point` int DEFAULT 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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='浼氬憳閰嶇疆';
+
+CREATE TABLE IF NOT EXISTS `member_experience_record` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿',
+ `biz_type` int NOT NULL COMMENT '涓氬姟绫诲瀷',
+ `biz_id` varchar(64) NOT NULL COMMENT '涓氬姟缂栧彿',
+ `title` varchar(255) NOT NULL COMMENT '鏍囬',
+ `description` varchar(255) NOT NULL COMMENT '鎻忚堪',
+ `experience` int NOT NULL COMMENT '缁忛獙',
+ `total_experience` int NOT 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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`),
+ KEY `idx_user_id` (`user_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='浼氬憳缁忛獙璁板綍';
+
+CREATE TABLE IF NOT EXISTS `member_level_record` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿',
+ `level_id` bigint NOT NULL COMMENT '绛夌骇缂栧彿',
+ `level` int NOT NULL COMMENT '绛夌骇',
+ `discount_percent` int NOT NULL COMMENT '鎶樻墸鐧惧垎姣�',
+ `experience` int NOT NULL COMMENT '缁忛獙',
+ `user_experience` int NOT NULL COMMENT '鐢ㄦ埛缁忛獙',
+ `remark` varchar(255) DEFAULT NULL COMMENT '澶囨敞',
+ `description` varchar(255) DEFAULT 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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`),
+ KEY `idx_user_id` (`user_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='浼氬憳绛夌骇璁板綍';
+
+CREATE TABLE IF NOT EXISTS `member_point_record` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿',
+ `biz_id` varchar(64) NOT NULL COMMENT '涓氬姟缂栧彿',
+ `biz_type` int NOT NULL COMMENT '涓氬姟绫诲瀷',
+ `title` varchar(255) NOT NULL COMMENT '鏍囬',
+ `description` varchar(255) NOT NULL COMMENT '鎻忚堪',
+ `point` int NOT NULL COMMENT '绉垎',
+ `total_point` int NOT 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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`),
+ KEY `idx_user_id` (`user_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='浼氬憳绉垎璁板綍';
+
+CREATE TABLE IF NOT EXISTS `member_sign_in_config` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `day` int NOT NULL COMMENT '绗嚑澶�',
+ `point` int NOT NULL COMMENT '璧犻�佺Н鍒�',
+ `experience` int NOT NULL COMMENT '璧犻�佺粡楠�',
+ `status` tinyint NOT NULL DEFAULT 0 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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='绛惧埌閰嶇疆';
+
+CREATE TABLE IF NOT EXISTS `member_sign_in_record` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿',
+ `day` int NOT NULL COMMENT '绗嚑澶�',
+ `point` int NOT NULL COMMENT '璧犻�佺Н鍒�',
+ `experience` int NOT 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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`),
+ KEY `idx_user_id` (`user_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='绛惧埌璁板綍';
+
+CREATE TABLE IF NOT EXISTS `hrm_social_security_config` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `name` varchar(100) NOT NULL COMMENT '鏂规鍚嶇О',
+ `effective_date` date DEFAULT NULL COMMENT '鐢熸晥鏃ユ湡',
+ `pension_company_ratio` decimal(10,4) DEFAULT NULL COMMENT '鍏昏��-鍏徃姣斾緥',
+ `pension_personal_ratio` decimal(10,4) DEFAULT NULL COMMENT '鍏昏��-涓汉姣斾緥',
+ `medical_company_ratio` decimal(10,4) DEFAULT NULL COMMENT '鍖荤枟-鍏徃姣斾緥',
+ `medical_personal_ratio` decimal(10,4) DEFAULT NULL COMMENT '鍖荤枟-涓汉姣斾緥',
+ `unemployment_company_ratio` decimal(10,4) DEFAULT NULL COMMENT '澶变笟-鍏徃姣斾緥',
+ `unemployment_personal_ratio` decimal(10,4) DEFAULT NULL COMMENT '澶变笟-涓汉姣斾緥',
+ `work_injury_ratio` decimal(10,4) DEFAULT NULL COMMENT '宸ヤ激-鍏徃姣斾緥',
+ `maternity_ratio` decimal(10,4) DEFAULT NULL COMMENT '鐢熻偛-鍏徃姣斾緥',
+ `housing_fund_company_ratio` decimal(10,4) DEFAULT NULL COMMENT '鍏Н閲�-鍏徃姣斾緥',
+ `housing_fund_personal_ratio` decimal(10,4) DEFAULT NULL COMMENT '鍏Н閲�-涓汉姣斾緥',
+ `social_security_base_min` decimal(12,2) DEFAULT NULL COMMENT '绀句繚鍩烘暟涓嬮檺',
+ `social_security_base_max` decimal(12,2) DEFAULT NULL COMMENT '绀句繚鍩烘暟涓婇檺',
+ `housing_fund_base_min` decimal(12,2) DEFAULT NULL COMMENT '鍏Н閲戝熀鏁颁笅闄�',
+ `housing_fund_base_max` decimal(12,2) DEFAULT NULL COMMENT '鍏Н閲戝熀鏁颁笂闄�',
+ `status` int DEFAULT NULL COMMENT '鐘舵��',
+ `remark` varchar(255) DEFAULT 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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='绀句繚閰嶇疆';
+
+-- ############################################################################
+-- ## 鏉ユ簮鏂囦欢锛歠ix_api_500_schema_20261030_part2.sql
+-- ############################################################################
+-- ============================================================================
+-- 鎺ュ彛 500 淇锛堢浜屾壒锛夛細琛ラ綈浠g爜鏂板浣嗗簱涓己澶辩殑鍒�
+--
+-- 鑳屾櫙锛氭湰鍦板叏閲忔帴鍙f祴璇曪紙1992 涓帴鍙o級鍚庢湁 77 涓粛杩斿洖 500锛�
+-- 鍏朵腑 17 涓槸"鍒椾笉瀛樺湪"鈥斺�斿綋鍓嶄唬鐮佺殑 DO 宸叉柊澧炲瓧娈碉紝
+-- 浣嗗叏搴撳垵濮嬪寲鑴氭湰 config_export_all_20260928.sql 鏈悓姝ャ��
+--
+-- 鐗规�э細骞傜瓑锛屽彲閲嶅鎵ц銆�
+-- 渚濊禆锛氬湪 fix_api_500_schema_20261030.sql 涔嬪悗鎵ц銆�
+-- ============================================================================
+
+-- ---------------------------------------------------------------------------
+-- 涓�銆丮ES 浠撳簱妯″潡
+-- ---------------------------------------------------------------------------
+
+-- 1.1 鏉傞」鏀舵枡鍗曡锛歜atch_code
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_misc_receipt_line'
+ AND column_name = 'batch_code');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `mes_wm_misc_receipt_line` ADD COLUMN `batch_code` varchar(64) DEFAULT NULL COMMENT ''鎵规鍙�''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 1.2 鏉傞」鏀舵枡鍗曪細type
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_misc_receipt'
+ AND column_name = 'type');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `mes_wm_misc_receipt` ADD COLUMN `type` int DEFAULT NULL COMMENT ''鏀舵枡绫诲瀷''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 1.3 澶栧崗鍙戞枡鍗曡锛歜atch_id
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_outsource_issue_line'
+ AND column_name = 'batch_id');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `mes_wm_outsource_issue_line` ADD COLUMN `batch_id` bigint DEFAULT NULL COMMENT ''鎵规缂栧彿''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 1.4 澶栧崗鍏ュ簱鍗曡锛歱roduction_date
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_outsource_receipt_line'
+ AND column_name = 'production_date');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `mes_wm_outsource_receipt_line` ADD COLUMN `production_date` datetime DEFAULT NULL COMMENT ''鐢熶骇鏃ユ湡''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 1.5 瑁呯鏄庣粏锛歟xpire_date
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_package_line'
+ AND column_name = 'expire_date');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `mes_wm_package_line` ADD COLUMN `expire_date` datetime DEFAULT NULL COMMENT ''鏈夋晥鏈�''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 1.6 鐩樼偣浠诲姟锛歵ype锛堥��鏂欑被鍨�/鐩樼偣绫诲瀷锛�
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_stock_taking_task'
+ AND column_name = 'type');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `mes_wm_stock_taking_task` ADD COLUMN `type` int DEFAULT NULL COMMENT ''鐩樼偣绫诲瀷''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 1.7 鐩樼偣浠诲姟琛岋細taking_quantity
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_stock_taking_task_line'
+ AND column_name = 'taking_quantity');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `mes_wm_stock_taking_task_line` ADD COLUMN `taking_quantity` decimal(24,6) DEFAULT NULL COMMENT ''瀹炵洏鏁伴噺''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 1.8 鐩樼偣缁撴灉锛歵aking_quantity
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_stock_taking_task_result'
+ AND column_name = 'taking_quantity');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `mes_wm_stock_taking_task_result` ADD COLUMN `taking_quantity` decimal(24,6) DEFAULT NULL COMMENT ''瀹炵洏鏁伴噺''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- ---------------------------------------------------------------------------
+-- 浜屻�丮ES 鐢熶骇 / 璁惧 / 璐ㄦ
+-- ---------------------------------------------------------------------------
+
+-- 2.1 鐢熶骇鎶ュ伐锛歮achinery_ids
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_pro_feedback'
+ AND column_name = 'machinery_ids');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `mes_pro_feedback` ADD COLUMN `machinery_ids` varchar(500) DEFAULT NULL COMMENT ''璁惧缂栧彿鍒楄〃锛岄�楀彿鍒嗛殧''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 2.2 璁惧鍙拌处锛歝ollect_device_code
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_dv_machinery'
+ AND column_name = 'collect_device_code');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `mes_dv_machinery` ADD COLUMN `collect_device_code` varchar(64) DEFAULT NULL COMMENT ''鏁伴噰璁惧缂栧彿''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 2.3 璁¢噺鏍¢獙锛歝heck_user_name
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_dv_metering_check'
+ AND column_name = 'check_user_name');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `mes_dv_metering_check` ADD COLUMN `check_user_name` varchar(64) DEFAULT NULL COMMENT ''鏍¢獙浜哄鍚�''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 2.4 鏉ユ枡妫�楠岋細vendor_name
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_qc_iqc'
+ AND column_name = 'vendor_name');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `mes_qc_iqc` ADD COLUMN `vendor_name` varchar(128) DEFAULT NULL COMMENT ''渚涘簲鍟嗗悕绉�''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 2.5 宸ヨ壓璺嚎宸ュ簭 / 宸ュ崟宸ュ簭锛歽ield_rate
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_pro_route_process'
+ AND column_name = 'yield_rate');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `mes_pro_route_process` ADD COLUMN `yield_rate` decimal(10,4) DEFAULT NULL COMMENT ''鑹巼''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_pro_work_order_process'
+ AND column_name = 'yield_rate');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `mes_pro_work_order_process` ADD COLUMN `yield_rate` decimal(10,4) DEFAULT NULL COMMENT ''鑹巼''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- ---------------------------------------------------------------------------
+-- 涓夈�丠RM 鑰冨嫟
+-- ---------------------------------------------------------------------------
+
+-- 3.1 鑰冨嫟瑙勫垯锛歭ocation_address
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'hrm_attendance_rule'
+ AND column_name = 'location_address');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `hrm_attendance_rule` ADD COLUMN `location_address` varchar(500) DEFAULT NULL COMMENT ''鎵撳崱鍦扮偣鍦板潃''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 3.2 鑰冨嫟璁板綍锛歝lock_in_accuracy
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'hrm_attendance_record'
+ AND column_name = 'clock_in_accuracy');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `hrm_attendance_record` ADD COLUMN `clock_in_accuracy` decimal(10,2) DEFAULT NULL COMMENT ''涓婄彮鎵撳崱瀹氫綅绮惧害锛堢背锛�''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'hrm_attendance_record'
+ AND column_name = 'clock_out_accuracy');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `hrm_attendance_record` ADD COLUMN `clock_out_accuracy` decimal(10,2) DEFAULT NULL COMMENT ''涓嬬彮鎵撳崱瀹氫綅绮惧害锛堢背锛�''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 3.3 鑰冨嫟鑺傚亣鏃ワ細start_date / end_date
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'hrm_attendance_holiday'
+ AND column_name = 'start_date');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `hrm_attendance_holiday` ADD COLUMN `start_date` date DEFAULT NULL COMMENT ''寮�濮嬫棩鏈�''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'hrm_attendance_holiday'
+ AND column_name = 'end_date');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `hrm_attendance_holiday` ADD COLUMN `end_date` date DEFAULT NULL COMMENT ''缁撴潫鏃ユ湡''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- ---------------------------------------------------------------------------
+-- 鍥涖�丆RM 瀹㈡埛
+-- ---------------------------------------------------------------------------
+
+-- 4.1 瀹㈡埛锛歛uto_pool_enabled
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'crm_customer'
+ AND column_name = 'auto_pool_enabled');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `crm_customer` ADD COLUMN `auto_pool_enabled` bit(1) NOT NULL DEFAULT b''1'' COMMENT ''鏄惁寮�鍚嚜鍔ㄨ繘鍏ュ叕娴�''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- ---------------------------------------------------------------------------
+-- 浜斻�佷細鍛樼敤鎴凤細tenant_id锛堝疄浣撶户鎵� TenantBaseDO锛�
+-- ---------------------------------------------------------------------------
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'member_user'
+ AND column_name = 'tenant_id');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `member_user` ADD COLUMN `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT ''绉熸埛缂栧彿''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 鍏朵綑 member_* 琛ㄥ悓鏍疯ˉ tenant_id锛屼繚璇佷笌 TenantBaseDO 涓�鑷�
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'member_tag'
+ AND column_name = 'tenant_id');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `member_tag` ADD COLUMN `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT ''绉熸埛缂栧彿''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'member_level'
+ AND column_name = 'tenant_id');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `member_level` ADD COLUMN `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT ''绉熸埛缂栧彿''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'member_group'
+ AND column_name = 'tenant_id');
+SET @sql := IF(@exists = 0,
+ 'ALTER TABLE `member_group` ADD COLUMN `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT ''绉熸埛缂栧彿''',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- ############################################################################
+-- ## 鏉ユ簮鏂囦欢锛歠ix_api_500_schema_20261030_part3.sql
+-- ############################################################################
+-- ============================================================================
+-- 鎺ュ彛 500 淇锛堢涓夋壒锛夛細鎸� DO 瀹炰綋鑷姩姣斿琛ラ綈鎵�鏈夌己澶卞垪
+-- 鐢熸垚鏂瑰紡锛氳В鏋� 359 涓� DO 鐨� @TableName + 瀛楁锛屼笌 mom-kyzn 瀹為檯鍒楁瘮瀵瑰彇宸泦
+-- 鐗规�э細骞傜瓑锛屽彲閲嶅鎵ц
+-- ============================================================================
+
+-- ---------- after_sale_visit ----------
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'after_sale_visit'
+ AND column_name = 'recurred');
+SET @sql := IF(@exists = 0, "ALTER TABLE `after_sale_visit` ADD COLUMN `recurred` bit(1) DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'after_sale_visit'
+ AND column_name = 'satisfied');
+SET @sql := IF(@exists = 0, "ALTER TABLE `after_sale_visit` ADD COLUMN `satisfied` bit(1) DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+-- ---------- hrm_attendance_record ----------
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'hrm_attendance_record'
+ AND column_name = 'clock_in_address');
+SET @sql := IF(@exists = 0, "ALTER TABLE `hrm_attendance_record` ADD COLUMN `clock_in_address` varchar(255) DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'hrm_attendance_record'
+ AND column_name = 'clock_in_distance');
+SET @sql := IF(@exists = 0, "ALTER TABLE `hrm_attendance_record` ADD COLUMN `clock_in_distance` decimal(24,6) DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'hrm_attendance_record'
+ AND column_name = 'clock_out_address');
+SET @sql := IF(@exists = 0, "ALTER TABLE `hrm_attendance_record` ADD COLUMN `clock_out_address` varchar(255) DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'hrm_attendance_record'
+ AND column_name = 'clock_out_distance');
+SET @sql := IF(@exists = 0, "ALTER TABLE `hrm_attendance_record` ADD COLUMN `clock_out_distance` decimal(24,6) DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+-- ---------- hrm_attendance_rule ----------
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'hrm_attendance_rule'
+ AND column_name = 'coordinate_system');
+SET @sql := IF(@exists = 0, "ALTER TABLE `hrm_attendance_rule` ADD COLUMN `coordinate_system` varchar(255) DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'hrm_attendance_rule'
+ AND column_name = 'latitude');
+SET @sql := IF(@exists = 0, "ALTER TABLE `hrm_attendance_rule` ADD COLUMN `latitude` decimal(24,6) DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'hrm_attendance_rule'
+ AND column_name = 'location_required');
+SET @sql := IF(@exists = 0, "ALTER TABLE `hrm_attendance_rule` ADD COLUMN `location_required` bit(1) DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'hrm_attendance_rule'
+ AND column_name = 'longitude');
+SET @sql := IF(@exists = 0, "ALTER TABLE `hrm_attendance_rule` ADD COLUMN `longitude` decimal(24,6) DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'hrm_attendance_rule'
+ AND column_name = 'radius_meters');
+SET @sql := IF(@exists = 0, "ALTER TABLE `hrm_attendance_rule` ADD COLUMN `radius_meters` int DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+-- ---------- mes_dv_machinery ----------
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_dv_machinery'
+ AND column_name = 'collect_enabled');
+SET @sql := IF(@exists = 0, "ALTER TABLE `mes_dv_machinery` ADD COLUMN `collect_enabled` bit(1) DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+-- ---------- mes_pro_work_order ----------
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_pro_work_order'
+ AND column_name = 'feedback_approve');
+SET @sql := IF(@exists = 0, "ALTER TABLE `mes_pro_work_order` ADD COLUMN `feedback_approve` bit(1) DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+-- ---------- mes_wm_misc_receipt ----------
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_misc_receipt'
+ AND column_name = 'source_doc_code');
+SET @sql := IF(@exists = 0, "ALTER TABLE `mes_wm_misc_receipt` ADD COLUMN `source_doc_code` varchar(255) DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_misc_receipt'
+ AND column_name = 'source_doc_id');
+SET @sql := IF(@exists = 0, "ALTER TABLE `mes_wm_misc_receipt` ADD COLUMN `source_doc_id` bigint DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_misc_receipt'
+ AND column_name = 'source_doc_type');
+SET @sql := IF(@exists = 0, "ALTER TABLE `mes_wm_misc_receipt` ADD COLUMN `source_doc_type` varchar(255) DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+-- ---------- mes_wm_misc_receipt_detail ----------
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_misc_receipt_detail'
+ AND column_name = 'batch_code');
+SET @sql := IF(@exists = 0, "ALTER TABLE `mes_wm_misc_receipt_detail` ADD COLUMN `batch_code` varchar(255) DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+-- ---------- mes_wm_misc_receipt_line ----------
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_misc_receipt_line'
+ AND column_name = 'area_id');
+SET @sql := IF(@exists = 0, "ALTER TABLE `mes_wm_misc_receipt_line` ADD COLUMN `area_id` bigint DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_misc_receipt_line'
+ AND column_name = 'location_id');
+SET @sql := IF(@exists = 0, "ALTER TABLE `mes_wm_misc_receipt_line` ADD COLUMN `location_id` bigint DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_misc_receipt_line'
+ AND column_name = 'warehouse_id');
+SET @sql := IF(@exists = 0, "ALTER TABLE `mes_wm_misc_receipt_line` ADD COLUMN `warehouse_id` bigint DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+-- ---------- mes_wm_outsource_receipt_line ----------
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_outsource_receipt_line'
+ AND column_name = 'expire_date');
+SET @sql := IF(@exists = 0, "ALTER TABLE `mes_wm_outsource_receipt_line` ADD COLUMN `expire_date` datetime DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_outsource_receipt_line'
+ AND column_name = 'lot_number');
+SET @sql := IF(@exists = 0, "ALTER TABLE `mes_wm_outsource_receipt_line` ADD COLUMN `lot_number` varchar(255) DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+-- ---------- mes_wm_stock_taking_task ----------
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_stock_taking_task'
+ AND column_name = 'blind_flag');
+SET @sql := IF(@exists = 0, "ALTER TABLE `mes_wm_stock_taking_task` ADD COLUMN `blind_flag` bit(1) DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_stock_taking_task'
+ AND column_name = 'end_time');
+SET @sql := IF(@exists = 0, "ALTER TABLE `mes_wm_stock_taking_task` ADD COLUMN `end_time` datetime DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_stock_taking_task'
+ AND column_name = 'frozen');
+SET @sql := IF(@exists = 0, "ALTER TABLE `mes_wm_stock_taking_task` ADD COLUMN `frozen` bit(1) DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_stock_taking_task'
+ AND column_name = 'start_time');
+SET @sql := IF(@exists = 0, "ALTER TABLE `mes_wm_stock_taking_task` ADD COLUMN `start_time` datetime DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_stock_taking_task'
+ AND column_name = 'user_id');
+SET @sql := IF(@exists = 0, "ALTER TABLE `mes_wm_stock_taking_task` ADD COLUMN `user_id` bigint DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+-- ---------- mes_wm_stock_taking_task_line ----------
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_stock_taking_task_line'
+ AND column_name = 'status');
+SET @sql := IF(@exists = 0, "ALTER TABLE `mes_wm_stock_taking_task_line` ADD COLUMN `status` int DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+-- ---------- qc_report_template_version ----------
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'qc_report_template_version'
+ AND column_name = 'schema');
+SET @sql := IF(@exists = 0, "ALTER TABLE `qc_report_template_version` ADD COLUMN `schema` varchar(255) DEFAULT NULL", "SELECT 1");
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+-- ############################################################################
+-- ## 鏉ユ簮鏂囦欢锛歠ix_api_500_schema_20261030_part4.sql
+-- ############################################################################
+-- ============================================================================
+-- 鎺ュ彛 500 淇锛堢鍥涙壒锛夛細琛ラ綈缂哄け鐨勮〃锛堟寜 DO 瀹炰綋鐢熸垚锛�
+-- 鐗规�э細IF NOT EXISTS锛屽箓绛�
+-- ============================================================================
+
+CREATE TABLE IF NOT EXISTS `hrm_user_handover` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `from_user_id` bigint NULL COMMENT '/',
+ `to_user_id` bigint NULL COMMENT '/',
+ `resignation_id` bigint NULL COMMENT '/',
+ `handover_status` int NULL COMMENT '/',
+ `handover_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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='hrm_user_handover';
+
+CREATE TABLE IF NOT EXISTS `member_address` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `user_id` bigint NULL COMMENT '/',
+ `name` varchar(255) NULL COMMENT '/',
+ `mobile` varchar(255) NULL COMMENT '/',
+ `area_id` bigint NULL COMMENT '/',
+ `detail_address` varchar(255) NULL COMMENT '/',
+ `default_status` bit(1) NOT NULL DEFAULT b'0' 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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='member_address';
+
+CREATE TABLE IF NOT EXISTS `mes_collect_alarm` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `machinery_id` bigint NULL COMMENT 'private Long id;',
+ `device_code` varchar(255) NULL COMMENT 'private Long machineryId;',
+ `task_id` bigint NULL COMMENT 'private String deviceCode;',
+ `work_order_id` bigint NULL COMMENT 'private Long taskId;',
+ `wm_id` int NULL COMMENT 'private Long workOrderId;',
+ `wm_msg` varchar(255) NULL COMMENT 'private Integer wmId;',
+ `wm_time` datetime NULL COMMENT 'private String wmMsg;',
+ `status` int NULL COMMENT 'private LocalDateTime wmTime;',
+ `clear_time` datetime NULL COMMENT 'private Integer status;',
+ `collect_time` datetime NULL COMMENT 'private LocalDateTime clearTime;',
+ `data_json` varchar(255) NULL COMMENT 'private LocalDateTime collectTime;',
+ `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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='mes_collect_alarm';
+
+CREATE TABLE IF NOT EXISTS `mes_collect_cycle` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `machinery_id` bigint NULL COMMENT 'private Long id;',
+ `device_code` varchar(255) NULL COMMENT 'private Long machineryId;',
+ `task_id` bigint NULL COMMENT 'private String deviceCode;',
+ `work_order_id` bigint NULL COMMENT 'private Long taskId;',
+ `cycle_no` bigint NULL COMMENT 'private Long workOrderId;',
+ `collect_time` datetime NULL COMMENT 'private Long cycleNo;',
+ `ecyct` decimal(24,6) NULL COMMENT 'private LocalDateTime collectTime;',
+ `eiss` decimal(24,6) NULL COMMENT 'private BigDecimal ecyct;',
+ `eivm` decimal(24,6) NULL COMMENT 'private BigDecimal eiss;',
+ `eipm` decimal(24,6) NULL COMMENT 'private BigDecimal eivm;',
+ `esipt` decimal(24,6) NULL COMMENT 'private BigDecimal eipm;',
+ `esipp` decimal(24,6) NULL COMMENT 'private BigDecimal esipt;',
+ `esips` decimal(24,6) NULL COMMENT 'private BigDecimal esipp;',
+ `eipt` decimal(24,6) NULL COMMENT 'private BigDecimal esips;',
+ `eipse` decimal(24,6) NULL COMMENT 'private BigDecimal eipt;',
+ `eplst` decimal(24,6) NULL COMMENT 'private BigDecimal eipse;',
+ `eplsse` decimal(24,6) NULL COMMENT 'private BigDecimal eplst;',
+ `eplspm` decimal(24,6) NULL COMMENT 'private BigDecimal eplsse;',
+ `et_temps` varchar(255) NULL COMMENT 'private BigDecimal eplspm;',
+ `data_json` varchar(255) NULL COMMENT 'private String etTemps;',
+ `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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='mes_collect_cycle';
+
+CREATE TABLE IF NOT EXISTS `mes_collect_message` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `machinery_id` bigint NULL COMMENT 'private Long id;',
+ `device_code` varchar(255) NULL COMMENT 'private Long machineryId;',
+ `mqtt_topic` varchar(255) NULL COMMENT 'private String deviceCode;',
+ `msg_type` varchar(255) NULL COMMENT 'private String mqttTopic;',
+ `event_time` datetime NULL COMMENT 'private String msgType;',
+ `raw_payload` varchar(255) NULL COMMENT 'private LocalDateTime eventTime;',
+ `process_status` int NULL COMMENT 'private String rawPayload;',
+ `error_msg` varchar(255) NULL COMMENT 'private Integer processStatus;',
+ `receive_time` datetime NULL COMMENT 'private String errorMsg;',
+ `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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='mes_collect_message';
+
+CREATE TABLE IF NOT EXISTS `mes_collect_operate_log` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `machinery_id` bigint NULL COMMENT 'private Long id;',
+ `device_code` varchar(255) NULL COMMENT 'private Long machineryId;',
+ `task_id` bigint NULL COMMENT 'private String deviceCode;',
+ `work_order_id` bigint NULL COMMENT 'private Long taskId;',
+ `var_id` varchar(255) NULL COMMENT 'private Long workOrderId;',
+ `old_value` varchar(255) NULL COMMENT 'private String varId;',
+ `new_value` varchar(255) NULL COMMENT 'private String oldValue;',
+ `modify_time` datetime NULL COMMENT 'private String newValue;',
+ `collect_time` datetime NULL COMMENT 'private LocalDateTime modifyTime;',
+ `data_json` varchar(255) NULL COMMENT 'private LocalDateTime collectTime;',
+ `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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='mes_collect_operate_log';
+
+CREATE TABLE IF NOT EXISTS `mes_collect_realtime` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `machinery_id` bigint NULL COMMENT 'private Long id;',
+ `device_code` varchar(255) NULL COMMENT 'private Long machineryId;',
+ `task_id` bigint NULL COMMENT 'private String deviceCode;',
+ `work_order_id` bigint NULL COMMENT 'private Long taskId;',
+ `collect_time` datetime NULL COMMENT 'private Long workOrderId;',
+ `sts` int NULL COMMENT 'private LocalDateTime collectTime;',
+ `opm` int NULL COMMENT 'private Integer sts;',
+ `asts` int NULL COMMENT 'private Integer opm;',
+ `ot` decimal(24,6) NULL COMMENT 'private Integer asts;',
+ `temps` varchar(255) NULL COMMENT 'private BigDecimal ot;',
+ `data_json` varchar(255) NULL COMMENT 'private String temps;',
+ `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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='mes_collect_realtime';
+
+CREATE TABLE IF NOT EXISTS `mes_collect_realtime_history` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `machinery_id` bigint NULL COMMENT 'private Long id;',
+ `device_code` varchar(255) NULL COMMENT 'private Long machineryId;',
+ `task_id` bigint NULL COMMENT 'private String deviceCode;',
+ `work_order_id` bigint NULL COMMENT 'private Long taskId;',
+ `collect_time` datetime NULL COMMENT 'private Long workOrderId;',
+ `sts` int NULL COMMENT 'private LocalDateTime collectTime;',
+ `opm` int NULL COMMENT 'private Integer sts;',
+ `asts` int NULL COMMENT 'private Integer opm;',
+ `ot` decimal(24,6) NULL COMMENT 'private Integer asts;',
+ `temps` varchar(255) NULL COMMENT 'private BigDecimal ot;',
+ `data_json` varchar(255) NULL COMMENT 'private String temps;',
+ `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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='mes_collect_realtime_history';
+
+CREATE TABLE IF NOT EXISTS `mes_collect_tech` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `machinery_id` bigint NULL COMMENT 'private Long id;',
+ `device_code` varchar(255) NULL COMMENT 'private Long machineryId;',
+ `task_id` bigint NULL COMMENT 'private String deviceCode;',
+ `work_order_id` bigint NULL COMMENT 'private Long taskId;',
+ `collect_time` datetime NULL COMMENT 'private Long workOrderId;',
+ `data_json` varchar(255) NULL COMMENT 'private LocalDateTime collectTime;',
+ `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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='mes_collect_tech';
+
+CREATE TABLE IF NOT EXISTS `mes_dv_spare_movement` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `request_key` varchar(255) NULL COMMENT 'public class MesDvSpareMovementDO extends BaseDO {',
+ `spare_part_id` bigint NULL COMMENT 'private String requestKey;',
+ `spare_part_code` varchar(255) NULL COMMENT 'private Long sparePartId;',
+ `spare_part_name` varchar(255) NULL COMMENT 'private String sparePartCode;',
+ `specification` varchar(255) NULL COMMENT 'private String sparePartName;',
+ `unit` varchar(255) NULL COMMENT 'private String specification;',
+ `type` int NULL COMMENT '/** 1 鍒濆搴撳瓨锛�2 鍏ュ簱锛�3 缁翠慨棰嗙敤锛�4 閫�鍥� */',
+ `quantity` decimal(24,6) NULL COMMENT 'private Integer type;',
+ `before_quantity` decimal(24,6) NULL COMMENT 'private BigDecimal quantity;',
+ `after_quantity` decimal(24,6) NULL COMMENT 'private BigDecimal beforeQuantity;',
+ `repair_id` bigint NULL COMMENT 'private BigDecimal afterQuantity;',
+ `repair_code` varchar(255) NULL COMMENT 'private Long repairId;',
+ `machinery_id` bigint NULL COMMENT 'private String repairCode;',
+ `machinery_name` varchar(255) NULL COMMENT 'private Long machineryId;',
+ `original_id` bigint NULL COMMENT 'private String machineryName;',
+ `receiver_user_id` bigint NULL COMMENT 'private Long originalId;',
+ `receiver_name` varchar(255) NULL COMMENT 'private Long receiverUserId;',
+ `operator_user_id` bigint NULL COMMENT 'private String receiverName;',
+ `remark` varchar(255) NULL COMMENT 'private Long operatorUserId;',
+ `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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='mes_dv_spare_movement';
+
+CREATE TABLE IF NOT EXISTS `mes_dv_spare_part` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `code` varchar(255) NULL COMMENT 'public class MesDvSparePartDO extends BaseDO {',
+ `name` varchar(255) NULL COMMENT 'private String code;',
+ `specification` varchar(255) NULL COMMENT 'private String name;',
+ `unit` varchar(255) NULL COMMENT 'private String specification;',
+ `location` varchar(255) NULL COMMENT 'private String unit;',
+ `stock_quantity` decimal(24,6) NULL COMMENT 'private String location;',
+ `safety_quantity` decimal(24,6) NULL COMMENT 'private BigDecimal stockQuantity;',
+ `status` int NULL COMMENT 'private BigDecimal safetyQuantity;',
+ `remark` varchar(255) NULL COMMENT 'private Integer status;',
+ `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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='mes_dv_spare_part';
+
+CREATE TABLE IF NOT EXISTS `mes_energy_alert_log` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `rule_id` bigint NULL COMMENT 'public class EnergyAlertLogDO extends TenantBaseDO {',
+ `rule_name` varchar(255) NULL COMMENT 'private Long ruleId;',
+ `record_date` date NULL COMMENT 'private String ruleName;',
+ `period_type` varchar(255) NULL COMMENT 'private LocalDate recordDate;',
+ `energy_type` varchar(255) NULL COMMENT 'private String periodType;',
+ `scope` varchar(255) NULL COMMENT 'private String energyType;',
+ `metric` varchar(255) NULL COMMENT 'private String scope;',
+ `actual_value` decimal(24,6) NULL COMMENT 'private String metric;',
+ `threshold` decimal(24,6) NULL COMMENT 'private BigDecimal actualValue;',
+ `recipient_id` bigint NULL COMMENT 'private BigDecimal threshold;',
+ `recipient_name` varchar(255) NULL COMMENT 'private Long recipientId;',
+ `message_id` bigint NULL COMMENT 'private String recipientName;',
+ `status` varchar(255) NULL COMMENT 'private Long messageId;',
+ `error_message` varchar(255) NULL COMMENT 'private String status;',
+ `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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='mes_energy_alert_log';
+
+CREATE TABLE IF NOT EXISTS `mes_energy_alert_rule` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `name` varchar(255) NULL COMMENT 'public class EnergyAlertRuleDO extends TenantBaseDO {',
+ `energy_type` varchar(255) NULL COMMENT 'private String name;',
+ `usage_area` varchar(255) NULL COMMENT 'private String energyType;',
+ `product_category` varchar(255) NULL COMMENT 'private String usageArea;',
+ `metric` varchar(255) NULL COMMENT 'private String productCategory;',
+ `threshold` decimal(24,6) NULL COMMENT 'private String metric;',
+ `enabled` bit(1) NOT NULL DEFAULT b'0' COMMENT 'private BigDecimal threshold;',
+ `recipient_ids` varchar(255) NULL COMMENT '/** Comma-separated validated administrator IDs, at most 50. */',
+ `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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='mes_energy_alert_rule';
+
+CREATE TABLE IF NOT EXISTS `mes_energy_record` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `record_date` date NULL COMMENT 'private Long id;',
+ `energy_type` varchar(255) NULL COMMENT '/** WATER / ELECTRICITY / STEAM锛屽崟浣嶅垎鍒负 m鲁 / kWh / t銆� */',
+ `usage_area` varchar(255) NULL COMMENT 'private String energyType;',
+ `product_category` varchar(255) NULL COMMENT 'private String usageArea;',
+ `usage_purpose` varchar(255) NULL COMMENT 'private String productCategory;',
+ `quantity` decimal(24,6) NULL COMMENT 'private String usagePurpose;',
+ `unit_price` decimal(24,6) NULL COMMENT 'private BigDecimal quantity;',
+ `amount` decimal(24,6) NULL COMMENT 'private BigDecimal unitPrice;',
+ `recorder` varchar(255) NULL COMMENT 'private BigDecimal amount;',
+ `remark` varchar(255) NULL COMMENT 'private String recorder;',
+ `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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='mes_energy_record';
+
+CREATE TABLE IF NOT EXISTS `mes_safety_record` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `record_type` varchar(255) NULL COMMENT 'public class SafetyRecordDO extends BaseDO {',
+ `title` varchar(255) NULL COMMENT 'private String recordType;',
+ `category` varchar(255) NULL COMMENT 'private String title;',
+ `area` varchar(255) NULL COMMENT 'private String category;',
+ `risk_level` varchar(255) NULL COMMENT 'private String area;',
+ `status` varchar(255) NULL COMMENT 'private String riskLevel;',
+ `responsible_person` varchar(255) NULL COMMENT 'private String status;',
+ `inspector` varchar(255) NULL COMMENT 'private String responsiblePerson;',
+ `planned_date` date NULL COMMENT 'private String inspector;',
+ `deadline` date NULL COMMENT 'private LocalDate plannedDate;',
+ `completed_time` datetime NULL COMMENT 'private LocalDate deadline;',
+ `description` varchar(255) NULL COMMENT 'private LocalDateTime completedTime;',
+ `result` varchar(255) NULL COMMENT 'private String description;',
+ `certificate_no` varchar(255) NULL COMMENT 'private String result;',
+ `expiry_date` date NULL COMMENT 'private String certificateNo;',
+ `temperature` decimal(24,6) NULL COMMENT 'private LocalDate expiryDate;',
+ `leakage_current` decimal(24,6) NULL COMMENT 'private BigDecimal temperature;',
+ `attachment_urls` varchar(255) NULL COMMENT 'private BigDecimal leakageCurrent;',
+ `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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='mes_safety_record';
+
+CREATE TABLE IF NOT EXISTS `wms_warehouse_approval_config` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `warehouse_id` bigint NULL COMMENT '/',
+ `biz_type` varchar(255) NULL COMMENT '/',
+ `approval_enabled` bit(1) NOT NULL DEFAULT b'0' COMMENT '/',
+ `process_definition_key` varchar(255) NULL COMMENT '/',
+ `category_code` varchar(255) 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(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='wms_warehouse_approval_config';
+
+-- ---------------------------------------------------------------------------
+-- 琛ュ厖锛氭柊寤鸿〃缂哄皯 TenantBaseDO 蹇呴渶鐨� tenant_id 鍒�
+-- ---------------------------------------------------------------------------
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_energy_record'
+ AND column_name = 'tenant_id');
+SET @sql := IF(@exists = 0,
+ "ALTER TABLE `mes_energy_record` ADD COLUMN `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '绉熸埛缂栧彿'",
+ "SELECT 1");
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_energy_alert_log'
+ AND column_name = 'tenant_id');
+SET @sql := IF(@exists = 0,
+ "ALTER TABLE `mes_energy_alert_log` ADD COLUMN `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '绉熸埛缂栧彿'",
+ "SELECT 1");
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_energy_alert_rule'
+ AND column_name = 'tenant_id');
+SET @sql := IF(@exists = 0,
+ "ALTER TABLE `mes_energy_alert_rule` ADD COLUMN `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '绉熸埛缂栧彿'",
+ "SELECT 1");
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @exists := (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_safety_record'
+ AND column_name = 'tenant_id');
+SET @sql := IF(@exists = 0,
+ "ALTER TABLE `mes_safety_record` ADD COLUMN `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '绉熸埛缂栧彿'",
+ "SELECT 1");
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET FOREIGN_KEY_CHECKS = 1;
+
+-- ============================================================================
+-- 鎵ц瀹屾瘯
+-- ============================================================================
--
Gitblit v1.9.3