From fe8a360ce6dececb8bf29ab31b7833af740170ec Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期五, 30 十月 2026 19:27:26 +0800
Subject: [PATCH] chore(sql): 新增生产库 mom-kyzn 结构修复脚本

---
 sql/mysql/fix_prod_mom_kyzn_20261030.sql |  545 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 545 insertions(+), 0 deletions(-)

diff --git a/sql/mysql/fix_prod_mom_kyzn_20261030.sql b/sql/mysql/fix_prod_mom_kyzn_20261030.sql
new file mode 100644
index 0000000..90d13c5
--- /dev/null
+++ b/sql/mysql/fix_prod_mom_kyzn_20261030.sql
@@ -0,0 +1,545 @@
+-- ============================================================================
+-- 搴锋剰鏅鸿兘 mom-kyzn 鐢熶骇搴撲慨澶嶈剼鏈紙2026-10-30锛�
+-- 鐢熸垚鏂瑰紡锛氳В鏋� 359 涓� DO 瀹炰綋锛屼笌鐢熶骇搴� actual schema 閫愪竴姣斿鍙栧樊闆�
+-- 鍐呭锛�41 涓己澶卞垪 + 14 寮犵己澶辫〃 + mes_wm_return_issue.type 绫诲瀷淇
+-- 鐗规�э細骞傜瓑锛屽彲閲嶅鎵ц
+-- ============================================================================
+
+SET NAMES utf8mb4;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- ---------------------------------------------------------------------------
+-- 涓�銆佽ˉ榻愮己澶卞垪锛�41 涓級
+-- ---------------------------------------------------------------------------
+
+-- ---------- 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_accuracy');
+SET @sql := IF(@exists = 0, "ALTER TABLE `hrm_attendance_record` ADD COLUMN `clock_in_accuracy` 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_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_in_latitude');
+SET @sql := IF(@exists = 0, "ALTER TABLE `hrm_attendance_record` ADD COLUMN `clock_in_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_record'
+                  AND column_name = 'clock_in_longitude');
+SET @sql := IF(@exists = 0, "ALTER TABLE `hrm_attendance_record` ADD COLUMN `clock_in_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_record'
+                  AND column_name = 'clock_out_accuracy');
+SET @sql := IF(@exists = 0, "ALTER TABLE `hrm_attendance_record` ADD COLUMN `clock_out_accuracy` 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;
+
+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(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_longitude');
+SET @sql := IF(@exists = 0, "ALTER TABLE `hrm_attendance_record` ADD COLUMN `clock_out_longitude` 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_address');
+SET @sql := IF(@exists = 0, "ALTER TABLE `hrm_attendance_rule` ADD COLUMN `location_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_rule'
+                  AND column_name = 'location_name');
+SET @sql := IF(@exists = 0, "ALTER TABLE `hrm_attendance_rule` ADD COLUMN `location_name` 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 = '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_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_outsource_issue_line ----------
+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", "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_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", "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 = 'batch_code');
+SET @sql := IF(@exists = 0, "ALTER TABLE `mes_wm_outsource_receipt_line` ADD COLUMN `batch_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_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", "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 = '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;
+
+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", "SELECT 1");
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- ---------- mes_wm_package_line ----------
+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", "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_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", "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 = 'taking_date');
+SET @sql := IF(@exists = 0, "ALTER TABLE `mes_wm_stock_taking_task` ADD COLUMN `taking_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_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", "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 = 'batch_code');
+SET @sql := IF(@exists = 0, "ALTER TABLE `mes_wm_stock_taking_task_line` ADD COLUMN `batch_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_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;
+
+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", "SELECT 1");
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- ---------- mes_wm_stock_taking_task_result ----------
+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(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_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", "SELECT 1");
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- ---------------------------------------------------------------------------
+-- 浜屻�佷慨姝� mes_wm_return_issue.type锛歷archar(255) -> int
+--     鍘嗗彶鏁版嵁瀛樼殑鏄腑鏂囷紝鍏堣浆鎹负鏋氫妇鍊� 1/2/3
+-- ---------------------------------------------------------------------------
+SET @is_varchar := (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(@is_varchar > 0,
+    "UPDATE `mes_wm_return_issue` SET `type` = CASE `type`
+        WHEN '浣欐枡閫�鏂�' THEN '1'
+        WHEN '涓嶈壇閫�鏂�' THEN '2'
+        WHEN '鍏朵粬閫�鏂�' THEN '3'
+        WHEN '' THEN NULL
+        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 @is_varchar := (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(@is_varchar > 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;
+
+-- ---------------------------------------------------------------------------
+-- 涓夈�佸垱寤虹己澶辫〃锛�14 寮狅紝鎸� DO 瀹炰綋鐢熸垚锛�
+-- ---------------------------------------------------------------------------
+
+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='绀句繚閰嶇疆';
+
+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 `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';
+
+SET FOREIGN_KEY_CHECKS = 1;

--
Gitblit v1.9.3