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