From c97dbe784ed7127648cdd578d75e66837f09b4d7 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期五, 04 九月 2026 15:53:20 +0800
Subject: [PATCH] docs(database): 添加数据库初始化与配置导出维护规则文档

---
 docs/sql/config_export_all_20260904.sql |  190 ++++++++++++++++++++++++++++++++--------------
 1 files changed, 131 insertions(+), 59 deletions(-)

diff --git a/docs/sql/config_export_20260904.sql b/docs/sql/config_export_all_20260904.sql
similarity index 98%
rename from docs/sql/config_export_20260904.sql
rename to docs/sql/config_export_all_20260904.sql
index 801a0ae..5591b57 100644
--- a/docs/sql/config_export_20260904.sql
+++ b/docs/sql/config_export_all_20260904.sql
@@ -1,11 +1,11 @@
 -- =======================================================================
--- 鏂囦欢锛歝onfig_export_20260904.sql
+-- 鏂囦欢锛歝onfig_export_20260904.sql.sql
 -- 鐢ㄩ�旓細ruoyi-vue-pro銆屽叏搴撹〃缁撴瀯 + 6 绫婚厤缃暟鎹�嶅鍑猴紝渚涘悓缁撴瀯鍏ㄦ柊搴撳垵濮嬪寲
 -- 鏉ユ簮搴擄細ruoyi-vue-pro
--- 瀵煎嚭鏃堕棿锛�2026-09-04T06:56:33.860Z
+-- 瀵煎嚭鏃堕棿锛�2026-09-04T07:14:22.064Z
 -- 鑼冨洿锛氬叏搴� BASE TABLE 鍏� 413 寮狅紝鍏ㄩ儴杈撳嚭 CREATE TABLE锛�
 --       浠呬互涓嬮厤缃被琛ㄥ甫鏁版嵁(INSERT)锛屽叾浣欎笟鍔�/绯荤粺/杩愯鍘嗗彶琛ㄥ彧淇濈暀绌鸿〃缁撴瀯锛�
---     鈶� 鍗忓悓瀹℃壒娴佺▼锛堝紩鎿庡畾涔夛紝浠呮縺娲绘祦绋嬶紝鍓斿巻鍙�/杩愯/韬唤锛夛細act_ge_property銆乤ct_re_procdef銆乤ct_re_deployment銆乤ct_ge_bytearray銆乤ct_re_model銆乥pm_process_definition_info
+--     鈶� 鍗忓悓瀹℃壒娴佺▼锛堝紩鎿庡厓鏁版嵁+瀹氫箟锛屼粎婵�娲绘祦绋嬶紝鍓斿巻鍙�/杩愯/韬唤锛夛細act_ge_property銆乤ct_id_property銆乤ct_re_procdef銆乤ct_re_deployment銆乤ct_ge_bytearray銆乤ct_re_model銆乥pm_process_definition_info
 --     鈶� 鍗忓悓锛堜笟鍔￠檮浠堕厤缃� + 鍒嗙被 + 琛ㄥ崟 + 鎵╁睍閰嶇疆锛夛細bpm_business_attach銆乥pm_category銆乥pm_form銆乥pm_user_group銆乥pm_process_listener銆乥pm_process_expression
 --     鈶� BI 鍐崇瓥澶у睆 / go-view锛歜i_dashboard銆乥i_chart_config銆乥i_data_source_config銆乥i_warehouse_coordinate銆乺eport_go_view_project
 --     鈶� MES 缂栫爜瑙勫垯锛堝墧娴佹按璁板綍锛夛細mes_md_auto_code_rule銆乵es_md_auto_code_part
@@ -23,7 +23,7 @@
 
 
 -- ***********************************************************************
--- 鈶� 鍗忓悓瀹℃壒娴佺▼锛堝紩鎿庡畾涔夛紝浠呮縺娲绘祦绋嬶紝鍓斿巻鍙�/杩愯/韬唤锛夛紙DDL + 鏁版嵁锛�
+-- 鈶� 鍗忓悓瀹℃壒娴佺▼锛堝紩鎿庡厓鏁版嵁+瀹氫箟锛屼粎婵�娲绘祦绋嬶紝鍓斿巻鍙�/杩愯/韬唤锛夛紙DDL + 鏁版嵁锛�
 -- ***********************************************************************
 
 -- ============ 琛細act_ge_property锛堝鍑� 7 琛岋級 ============
@@ -42,6 +42,17 @@
 ('next.dbid', '1', '1'),
 ('schema.history', 'upgrade(7.2.0.2->8.0.0.0)', '2'),
 ('schema.version', '8.0.0.0', '2');
+
+-- ============ 琛細act_id_property锛堝鍑� 1 琛岋級 ============
+DROP TABLE IF EXISTS `act_id_property`;
+CREATE TABLE `act_id_property` (
+  `NAME_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
+  `VALUE_` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
+  `REV_` int DEFAULT NULL,
+  PRIMARY KEY (`NAME_`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin ROW_FORMAT=DYNAMIC;
+INSERT INTO `act_id_property` (`NAME_`, `VALUE_`, `REV_`) VALUES
+('schema.version', '8.0.0.0', '1');
 
 -- ============ 琛細act_re_procdef锛堝鍑� 20 琛岋級 ============
 DROP TABLE IF EXISTS `act_re_procdef`;
@@ -2539,7 +2550,7 @@
 ) ENGINE=InnoDB AUTO_INCREMENT=2880 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='浠ｇ爜鐢熸垚琛ㄥ瓧娈靛畾涔�';
 
 -- ***********************************************************************
--- 鍏朵綑 381 寮犺〃锛堜粎琛ㄧ粨鏋勶紝鏃犳暟鎹級
+-- 鍏朵綑 380 寮犺〃锛堜粎琛ㄧ粨鏋勶紝鏃犳暟鎹級
 -- ***********************************************************************
 
 -- ============ 琛細act_evt_log锛堜粎 DDL锛屾棤鏁版嵁锛� ============
@@ -2889,15 +2900,6 @@
   KEY `ACT_IDX_PRIV_USER` (`USER_ID_`) USING BTREE,
   KEY `ACT_IDX_PRIV_GROUP` (`GROUP_ID_`) USING BTREE,
   CONSTRAINT `ACT_FK_PRIV_MAPPING` FOREIGN KEY (`PRIV_ID_`) REFERENCES `act_id_priv` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin ROW_FORMAT=DYNAMIC;
-
--- ============ 琛細act_id_property锛堜粎 DDL锛屾棤鏁版嵁锛� ============
-DROP TABLE IF EXISTS `act_id_property`;
-CREATE TABLE `act_id_property` (
-  `NAME_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
-  `VALUE_` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
-  `REV_` int DEFAULT NULL,
-  PRIMARY KEY (`NAME_`) USING BTREE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin ROW_FORMAT=DYNAMIC;
 
 -- ============ 琛細act_id_token锛堜粎 DDL锛屾棤鏁版嵁锛� ============
@@ -4037,7 +4039,7 @@
   `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`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='娴佺▼鎶勯�佽〃';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='娴佺▼鎶勯�佽〃';
 
 -- ============ 琛細crm_business锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `crm_business`;
@@ -4066,7 +4068,7 @@
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�',
   `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '鏄惁鍒犻櫎',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='CRM 鍟嗘満琛�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='CRM 鍟嗘満琛�';
 
 -- ============ 琛細crm_business_product锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `crm_business_product`;
@@ -4085,7 +4087,7 @@
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�',
   `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '鏄惁鍒犻櫎',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='CRM 鍟嗘満浜у搧鍏宠仈琛�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='CRM 鍟嗘満浜у搧鍏宠仈琛�';
 
 -- ============ 琛細crm_business_status锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `crm_business_status`;
@@ -4146,7 +4148,7 @@
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�',
   `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '鏄惁鍒犻櫎',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='CRM 绾跨储琛�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='CRM 绾跨储琛�';
 
 -- ============ 琛細crm_contact锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `crm_contact`;
@@ -4222,7 +4224,7 @@
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�',
   `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '鏄惁鍒犻櫎',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='CRM 鍚堝悓琛�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='CRM 鍚堝悓琛�';
 
 -- ============ 琛細crm_contract_config锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `crm_contract_config`;
@@ -4365,7 +4367,7 @@
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�',
   `deleted` tinyint NOT NULL DEFAULT '0' COMMENT '鏄惁鍒犻櫎',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='CRM 寮�绁�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='CRM 寮�绁�';
 
 -- ============ 琛細crm_permission锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `crm_permission`;
@@ -4381,7 +4383,7 @@
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�',
   `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '鏄惁鍒犻櫎',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='CRM 鏁版嵁鏉冮檺琛�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='CRM 鏁版嵁鏉冮檺琛�';
 
 -- ============ 琛細crm_receivable锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `crm_receivable`;
@@ -4519,7 +4521,7 @@
   KEY `idx_period` (`period_type`,`period_value`) USING BTREE,
   KEY `idx_dimension` (`target_dimension`,`target_user_id`,`target_dept_id`,`target_item_id`) USING BTREE,
   KEY `idx_status` (`status`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='CRM 閿�鍞洰鏍�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='CRM 閿�鍞洰鏍�';
 
 -- ============ 琛細erp_account锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `erp_account`;
@@ -4643,7 +4645,7 @@
   `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`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='閲囪喘鏉ョエ';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='閲囪喘鏉ョエ';
 
 -- ============ 琛細erp_purchase_order锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `erp_purchase_order`;
@@ -4790,7 +4792,7 @@
   `production_status` tinyint DEFAULT '0' COMMENT '鐢熶骇鐘舵�侊細0-鏈畬鎴愶紝1-宸插畬鎴�',
   `production_finish_time` datetime DEFAULT NULL COMMENT '鐢熶骇瀹屾垚鏃堕棿',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='ERP 閿�鍞鍗�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='ERP 閿�鍞鍗�';
 
 -- ============ 琛細erp_sale_order_items锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `erp_sale_order_items`;
@@ -4814,7 +4816,7 @@
   `need_production` tinyint DEFAULT '0' COMMENT '鏄惁闇�瑕佺敓浜э紙0=鍚� 1=鏄級',
   `mps_id` bigint DEFAULT NULL COMMENT '鍏宠仈鐨凪PS缂栧彿',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='ERP 閿�鍞鍗曢」';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='ERP 閿�鍞鍗曢」';
 
 -- ============ 琛細erp_supplier锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `erp_supplier`;
@@ -5008,7 +5010,7 @@
   UNIQUE KEY `uk_user_date` (`user_id`,`date`) USING BTREE,
   KEY `idx_dept_date` (`dept_id`,`date`) USING BTREE,
   KEY `idx_create_time` (`create_time`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='HRM鑰冨嫟鎵撳崱璁板綍琛�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='HRM鑰冨嫟鎵撳崱璁板綍琛�';
 
 -- ============ 琛細hrm_attendance_rule锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `hrm_attendance_rule`;
@@ -5290,7 +5292,7 @@
   UNIQUE KEY `uk_no` (`no`) USING BTREE,
   KEY `idx_user_status` (`user_id`,`status`) USING BTREE,
   KEY `idx_dept_time` (`dept_id`,`start_time`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='HRM璇峰亣鐢宠琛�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='HRM璇峰亣鐢宠琛�';
 
 -- ============ 琛細hrm_leave_type_config锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `hrm_leave_type_config`;
@@ -6082,7 +6084,7 @@
   `tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '绉熸埛缂栧彿',
   PRIMARY KEY (`id`) USING BTREE,
   KEY `idx_create_time` (`create_time`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='绯荤粺寮傚父鏃ュ織';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='绯荤粺寮傚父鏃ュ織';
 
 -- ============ 琛細infra_file锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `infra_file`;
@@ -6678,7 +6680,7 @@
   UNIQUE KEY `uk_check_code` (`check_code`) USING BTREE,
   KEY `idx_metering_id` (`metering_id`) USING BTREE,
   KEY `idx_check_date` (`check_date`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 璁￠噺妫�娴嬭褰�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 璁￠噺妫�娴嬭褰�';
 
 -- ============ 琛細mes_dv_repair锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `mes_dv_repair`;
@@ -6757,7 +6759,7 @@
   `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`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 缂栫爜鐢熸垚璁板綍';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 缂栫爜鐢熸垚璁板綍';
 
 -- ============ 琛細mes_md_item锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `mes_md_item`;
@@ -7166,7 +7168,7 @@
   `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
   `tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '绉熸埛缂栧彿',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='MES 璁捐椤圭洰';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='MES 璁捐椤圭洰';
 
 -- ============ 琛細mes_pro_andon_config锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `mes_pro_andon_config`;
@@ -7444,7 +7446,7 @@
   KEY `idx_product_id` (`product_id`) USING BTREE,
   KEY `idx_status` (`status`) USING BTREE,
   KEY `idx_merge_batch_no` (`merge_batch_no`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='MES 鐢熶骇涓昏鍒�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='MES 鐢熶骇涓昏鍒�';
 
 -- ============ 琛細mes_pro_mps_merge_item锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `mes_pro_mps_merge_item`;
@@ -7658,7 +7660,7 @@
   `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
   PRIMARY KEY (`id`) USING BTREE,
   KEY `idx_work_order_process` (`work_order_id`,`process_id`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 鐢熶骇浠诲姟';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 鐢熶骇浠诲姟';
 
 -- ============ 琛細mes_pro_task_assignee锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `mes_pro_task_assignee`;
@@ -7759,7 +7761,7 @@
   `process_definition_key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'BPM 娴佺▼瀹氫箟 Key',
   `feedback_role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鎶ュ伐瑙掕壊 (澶氫釜瑙掕壊浠ラ�楀彿鍒嗛殧)',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 鐢熶骇宸ュ崟';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 鐢熶骇宸ュ崟';
 
 -- ============ 琛細mes_pro_work_order_bom锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `mes_pro_work_order_bom`;
@@ -7847,7 +7849,7 @@
   `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
   PRIMARY KEY (`id`) USING BTREE,
   KEY `idx_work_order_id` (`work_order_id`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='MES 鐢熶骇宸ュ崟宸ュ簭';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='MES 鐢熶骇宸ュ崟宸ュ簭';
 
 -- ============ 琛細mes_pro_work_record锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `mes_pro_work_record`;
@@ -7865,7 +7867,7 @@
   `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`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 鐢ㄦ埛宸ヤ綔绔欑粦瀹氬叧绯�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 鐢ㄦ埛宸ヤ綔绔欑粦瀹氬叧绯�';
 
 -- ============ 琛細mes_pro_work_record_log锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `mes_pro_work_record_log`;
@@ -7881,7 +7883,7 @@
   `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`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 涓婁笅宸ヨ褰曟祦姘�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 涓婁笅宸ヨ褰曟祦姘�';
 
 -- ============ 琛細mes_qc_defect锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `mes_qc_defect`;
@@ -7954,7 +7956,7 @@
   `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`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 妫�楠岀粨鏋滆褰�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 妫�楠岀粨鏋滆褰�';
 
 -- ============ 琛細mes_qc_indicator_result_detail锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `mes_qc_indicator_result_detail`;
@@ -7970,7 +7972,7 @@
   `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`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 妫�楠岀粨鏋滄槑缁嗚褰�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 妫�楠岀粨鏋滄槑缁嗚褰�';
 
 -- ============ 琛細mes_qc_ipqc锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `mes_qc_ipqc`;
@@ -8074,7 +8076,7 @@
   `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`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 鏉ユ枡妫�楠屽崟';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 鏉ユ枡妫�楠屽崟';
 
 -- ============ 琛細mes_qc_iqc_line锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `mes_qc_iqc_line`;
@@ -8098,7 +8100,7 @@
   `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`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 鏉ユ枡妫�楠屽崟琛�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 鏉ユ枡妫�楠屽崟琛�';
 
 -- ============ 琛細mes_qc_ncr锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `mes_qc_ncr`;
@@ -8139,7 +8141,7 @@
   KEY `idx_qc_type_id` (`qc_type`,`qc_id`) USING BTREE,
   KEY `idx_status` (`status`) USING BTREE,
   KEY `idx_item_id` (`item_id`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 涓嶅悎鏍煎搧澶勭悊鍗�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 涓嶅悎鏍煎搧澶勭悊鍗�';
 
 -- ============ 琛細mes_qc_oqc锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `mes_qc_oqc`;
@@ -8179,7 +8181,7 @@
   `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`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 鍑鸿揣妫�楠屽崟';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 鍑鸿揣妫�楠屽崟';
 
 -- ============ 琛細mes_qc_oqc_line锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `mes_qc_oqc_line`;
@@ -8203,7 +8205,7 @@
   `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`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 鍑鸿揣妫�楠屽崟琛�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 鍑鸿揣妫�楠屽崟琛�';
 
 -- ============ 琛細mes_qc_rqc锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `mes_qc_rqc`;
@@ -8479,7 +8481,7 @@
   `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`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 鎵规';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 鎵规';
 
 -- ============ 琛細mes_wm_item_consume锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `mes_wm_item_consume`;
@@ -8642,7 +8644,7 @@
   `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`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 搴撳瓨璁板綍';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 搴撳瓨璁板綍';
 
 -- ============ 琛細mes_wm_misc_issue锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `mes_wm_misc_issue`;
@@ -9620,7 +9622,7 @@
   `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`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 搴撳瓨浜嬪姟娴佹按';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 搴撳瓨浜嬪姟娴佹按';
 
 -- ============ 琛細mes_wm_transfer锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `mes_wm_transfer`;
@@ -10191,7 +10193,7 @@
   UNIQUE KEY `uk_apply_no` (`apply_no`) USING BTREE,
   KEY `idx_supplier_id` (`supplier_id`) USING BTREE,
   KEY `idx_apply_status` (`apply_status`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='渚涘簲鍟嗗噯鍏ョ敵璇疯〃';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='渚涘簲鍟嗗噯鍏ョ敵璇疯〃';
 
 -- ============ 琛細srm_supplier_category锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `srm_supplier_category`;
@@ -10480,7 +10482,7 @@
   PRIMARY KEY (`id`) USING BTREE,
   KEY `idx_username` (`username`) USING BTREE,
   KEY `idx_create_time` (`create_time`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='绯荤粺璁块棶璁板綍';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='绯荤粺璁块棶璁板綍';
 
 -- ============ 琛細system_mail_account锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `system_mail_account`;
@@ -10658,7 +10660,7 @@
   PRIMARY KEY (`id`) USING BTREE,
   KEY `idx_access_token` (`access_token`) USING BTREE,
   KEY `idx_refresh_token` (`refresh_token`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=231 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='OAuth2 璁块棶浠ょ墝';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='OAuth2 璁块棶浠ょ墝';
 
 -- ============ 琛細system_oauth2_approve锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `system_oauth2_approve`;
@@ -10748,7 +10750,7 @@
   `tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '绉熸埛缂栧彿',
   PRIMARY KEY (`id`) USING BTREE,
   KEY `idx_refresh_token` (`refresh_token`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='OAuth2 鍒锋柊浠ょ墝';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='OAuth2 鍒锋柊浠ょ墝';
 
 -- ============ 琛細system_operate_log锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `system_operate_log`;
@@ -10776,7 +10778,7 @@
   PRIMARY KEY (`id`) USING BTREE,
   KEY `idx_user_id` (`user_id`) USING BTREE,
   KEY `idx_create_time` (`create_time`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='鎿嶄綔鏃ュ織璁板綍 V2 鐗堟湰';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='鎿嶄綔鏃ュ織璁板綍 V2 鐗堟湰';
 
 -- ============ 琛細system_post锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `system_post`;
@@ -11008,7 +11010,7 @@
   PRIMARY KEY (`id`) USING BTREE,
   KEY `idx_record` (`record_type`,`record_id`) USING BTREE,
   KEY `idx_blob_id` (`storage_blob_id`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='鏂囦欢鍏宠仈琛�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='鏂囦欢鍏宠仈琛�';
 
 -- ============ 琛細system_storage_blob锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `system_storage_blob`;
@@ -11028,7 +11030,7 @@
   PRIMARY KEY (`id`) USING BTREE,
   UNIQUE KEY `uk_uid_filename` (`uid_filename`) USING BTREE,
   KEY `idx_resource_key` (`resource_key`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='鏂囦欢琛�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='鏂囦欢琛�';
 
 -- ============ 琛細system_user_post锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `system_user_post`;
@@ -11107,7 +11109,7 @@
   `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
   `tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '绉熸埛缂栧彿',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='绀轰緥鑱旂郴浜鸿〃';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='绀轰緥鑱旂郴浜鸿〃';
 
 -- ============ 琛細yudao_demo02_category锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `yudao_demo02_category`;
@@ -11122,7 +11124,7 @@
   `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
   `tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '绉熸埛缂栧彿',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='绀轰緥鍒嗙被琛�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='绀轰緥鍒嗙被琛�';
 
 -- ============ 琛細yudao_demo03_course锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `yudao_demo03_course`;
@@ -11138,7 +11140,7 @@
   `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
   `tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '绉熸埛缂栧彿',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='瀛︾敓璇剧▼琛�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='瀛︾敓璇剧▼琛�';
 
 -- ============ 琛細yudao_demo03_grade锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `yudao_demo03_grade`;
@@ -11154,7 +11156,7 @@
   `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
   `tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '绉熸埛缂栧彿',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='瀛︾敓鐝骇琛�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='瀛︾敓鐝骇琛�';
 
 -- ============ 琛細yudao_demo03_student锛堜粎 DDL锛屾棤鏁版嵁锛� ============
 DROP TABLE IF EXISTS `yudao_demo03_student`;
@@ -11171,7 +11173,77 @@
   `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
   `tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '绉熸埛缂栧彿',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='瀛︾敓琛�';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='瀛︾敓琛�';
 
 SET FOREIGN_KEY_CHECKS = 1;
 SET SQL_MODE = @OLD_SQL_MODE;
+
+
+-- =======================================================================
+-- 闃舵浜岋細琛ュ韬唤/鑿滃崟/OAuth2锛堝師 test_identity_seed_20260904.sql 鍚堝苟浜庢锛�
+-- =======================================================================
+
+-- =======================================================================
+-- 鏂囦欢锛歵est_identity_seed_20260904.sql
+-- 鐢ㄩ�旓細缁� test 搴撹ˉ榻�"韬唤 + 鑿滃崟"鏈�灏忓彲鐧诲綍鏁版嵁锛堣秴绠★級锛屾暟鎹簮锛歳uoyi-vue-pro
+-- 鍓嶆彁锛歵est 搴撳凡鎵ц杩� config_export_20260904.sql锛堝叏琛ㄧ粨鏋勫凡瀛樺湪锛屽瓧鍏稿凡瀵硷級锛�
+--       鏈剼鏈』鍦ㄢ�滃悓鏃跺瓨鍦� ruoyi-vue-pro 涓� test鈥濈殑鍚屼竴 MySQL 瀹炰緥涓婃墽琛屻��
+-- 瑕嗙洊锛�
+--   鈶� system_menu        鍏ㄩ儴鏈夋晥鑿滃崟锛堣秴绠＄櫥褰曞悗鐢变唬鐮佺洿鎺ヨ繑鍥炲叏閮ㄨ彍鍗曪紝鏁呬笉闇�瑕� role_menu 琛岋級
+--   鈶� system_dept / post 婧愬簱鏈垹闄ょ殑鏈夋晥閮ㄩ棬/宀椾綅琛�
+--   鈶� system_role        瓒呯瑙掕壊 super_admin
+--   鈶� system_users       admin 瓒呯璐﹀彿锛堝瘑鐮佸搱甯屼竴骞舵嫹璐濓紝鐧诲綍瀵嗙爜鍚屾簮搴擄級
+--   鈶� system_user_role   admin 鈫� super_admin 鍏宠仈
+--   鈶� system_oauth2_client  榛樿 OAuth2 瀹㈡埛绔紙鐧诲綍/鍒锋柊浠ょ墝蹇呴渶锛宑lient_id='default'锛�
+-- 瀛楀吀 system_dict_type / system_dict_data锛歝onfig_export 宸插鍏ワ紙test 鐜颁负 241/1157锛夛紝姝ゅ涓嶉噸澶嶅鐞嗐��
+-- 骞傜瓑锛氭瘡寮犺〃鍏� DELETE 鍐� INSERT锛屽彲閲嶅鎵ц锛涗笉褰卞搷鍏跺畠琛ㄣ��
+-- 鈿� 浠呬綔鐢ㄤ簬涓婅堪鍒楀嚭鐨勮〃锛屼笉浼氭竻绌哄叾瀹冭〃鏁版嵁銆�
+-- 鈿� 婧愬簱 ruoyi-vue-pro 鐨� system_dept / system_post 鍚緝澶氳蒋鍒犻櫎琛岋紝姝ゅ浠呮嫹璐濇湭鍒犻櫎(deleted=0)鐨勩��
+-- =======================================================================
+
+SET NAMES utf8mb4;
+SET FOREIGN_KEY_CHECKS = 0;
+SET @OLD_SQL_MODE = @@SQL_MODE, SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';
+
+-- 鈶� 鑿滃崟锛堝叏閲忔湁鏁堬級
+DELETE FROM `system_menu`;
+INSERT INTO `system_menu`
+SELECT * FROM `ruoyi-vue-pro`.`system_menu`
+WHERE `deleted` = b'0';
+
+-- 鈶燽 OAuth2 瀹㈡埛绔紙鐧诲綍蹇呴渶锛宑lient_id='default'锛�
+DELETE FROM `system_oauth2_client`;
+INSERT INTO `system_oauth2_client`
+SELECT * FROM `ruoyi-vue-pro`.`system_oauth2_client`
+WHERE `deleted` = b'0';
+
+-- 鈶� 閮ㄩ棬 / 宀椾綅锛堜粎鏈垹闄ょ殑鏈夋晥琛岋級
+DELETE FROM `system_dept`;
+INSERT INTO `system_dept`
+SELECT * FROM `ruoyi-vue-pro`.`system_dept`
+WHERE `deleted` = b'0';
+
+DELETE FROM `system_post`;
+INSERT INTO `system_post`
+SELECT * FROM `ruoyi-vue-pro`.`system_post`
+WHERE `deleted` = b'0';
+
+-- 鈶� 瓒呯瑙掕壊锛坰uper_admin锛�
+DELETE FROM `system_role`;
+INSERT INTO `system_role`
+SELECT * FROM `ruoyi-vue-pro`.`system_role`
+WHERE `code` = 'super_admin' AND `deleted` = b'0';
+
+-- 鈶� 瓒呯璐﹀彿 admin
+DELETE FROM `system_users`;
+INSERT INTO `system_users`
+SELECT * FROM `ruoyi-vue-pro`.`system_users`
+WHERE `username` = 'admin' AND `deleted` = b'0';
+
+-- 鈶� 鐢ㄦ埛-瑙掕壊鍏宠仈锛坅dmin 鎷ユ湁鐨勮鑹诧級
+DELETE FROM `system_user_role`;
+INSERT INTO `system_user_role`
+SELECT * FROM `ruoyi-vue-pro`.`system_user_role`
+WHERE `user_id` = (SELECT `id` FROM `system_users` WHERE `username` = 'admin' LIMIT 1);
+
+SET FOREIGN_KEY_CHECKS = 1;

--
Gitblit v1.9.3