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