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 ++++++++++++++++++++++++++-----------
 .claude/rules/sql-config-export-init.md |   56 +++++++++++
 2 files changed, 187 insertions(+), 59 deletions(-)

diff --git a/.claude/rules/sql-config-export-init.md b/.claude/rules/sql-config-export-init.md
new file mode 100644
index 0000000..535b4c8
--- /dev/null
+++ b/.claude/rules/sql-config-export-init.md
@@ -0,0 +1,56 @@
+# 鏁版嵁搴撳垵濮嬪寲涓庨厤缃鍑虹淮鎶よ鍒�
+
+## 瑙勫垯
+
+- 鍏ㄥ簱鍒濆鍖栧彧鐢�**涓�浠藉悎骞惰剼鏈�**锛歚docs/sql/config_export_all_<鏃ユ湡>.sql`锛堝缓缁撴瀯 + 琛ラ厤缃� + 琛ヨ韩浠戒竴娆℃�у畬鎴愶級銆�
+- **浠讳綍涓氬姟/閰嶇疆琛ㄧ粨鏋勩�侀厤缃暟鎹�佺郴缁熻韩浠�/鏉冮檺鏁版嵁鏈夊彉鏇�**锛岄兘鍙噸鏂扮敓鎴愯繖涓�浠芥枃浠讹紝淇濊瘉鍏跺缁堟槸鏈�鏂板彲涓�閿墽琛岀殑鐗堟湰銆�
+- 鍙淮鎶ゅ悎骞舵枃浠讹紱`config_export_<鏃ユ湡>.sql`銆乣test_identity_seed_<鏃ユ湡>.sql` 鍙槸鐢熸垚瀹冪殑涓棿浣擄紝涓嶅啀鍗曠嫭鎻愪氦缁存姢銆�
+- 杩濆弽瑙嗕负閬楁紡锛氭柊搴撳垵濮嬪寲鍑烘潵缂鸿〃 / 缂鸿彍鍗� / 鐧讳笉涓婏紝灞炰簬鏈寜鏈鍒欏悓姝ャ��
+
+## 鏁版嵁搴撶幆澧�
+
+| 搴� | 瑙掕壊 | 璇存槑 |
+|------|------|------|
+| `ruoyi-vue-pro` | **婧愬簱 / 杩愯搴� / 鏉冨▉** | dev/test/jhhg/yzfx 绛夐厤缃寚鍚戝畠锛涜繍琛屽悗绔紙48080锛夎鍙栵紱绯荤粺韬唤 / 鏉冮檺 / 鑿滃崟鐨勬潈濞佹暟鎹簮銆傜敓鎴愬悎骞惰剼鏈椂鐨勬暟鎹潵婧愩�� |
+| `test`锛堟垨鍏跺畠绌哄簱锛� | **鍒濆鍖栫洰鏍�** | 鏈湴 application-local 绛夋寚鍚戠殑绌虹櫧搴擄紱鎵ц鍚堝苟鑴氭湰鍦ㄦ寤虹粨鏋� + 琛ラ厤缃� + 琛ヨ韩浠姐�� |
+| 鍏朵粬 | 鎷疯礉 | 涓庢簮搴撳悓缁撴瀯鍚屽悕鎷疯礉锛屼笉鍙備笌鏈伐浣滄祦銆� |
+
+> 鐢熸垚/鎵ц鍚堝苟鑴氭湰闇�鍦�**鍚屾椂瀛樺湪 `ruoyi-vue-pro` 涓庣洰鏍囧簱鐨勫悓涓� MySQL 瀹炰緥**涓婃墽琛岋紙闃舵浜岀敤璺ㄥ簱 `INSERT..SELECT`锛夈�傚簱鍚嶅惈 `-` 鏃� SQL 閲岃鍔犲弽寮曞彿锛堝 `` `ruoyi-vue-pro` ``锛夈��
+
+## 鍞竴缁存姢鏂囦欢
+
+**`docs/sql/config_export_all_20260904.sql`**锛�11249 琛岋紝鍚堝苟鐗堬級锛屽唴閮ㄤ袱涓樁娈碉細
+
+| 闃舵 | 鍐呭 | 鏁版嵁鏉ユ簮 |
+|------|------|----------|
+| 闃舵涓�锛堝師 config_export锛� | 鍏ㄥ簱 413 寮犺〃 `CREATE TABLE` + 6 绫婚厤缃暟鎹細鈶犲崗鍚屽鎵规祦绋嬶紙act_*/bpm 婵�娲绘祦绋嬪厓鏁版嵁+瀹氫箟锛夆憽鍗忓悓涓氬姟閰嶇疆锛坆pm 闄勪欢/鍒嗙被/琛ㄥ崟/鐢ㄦ埛缁�/鐩戝惉/琛ㄨ揪寮忥級鈶I 澶у睆/go-view 鈶ES 缂栫爜瑙勫垯 鈶ょ郴缁熼厤缃富鏁版嵁锛坰ystem_dict_type/data銆乼enant銆乧ompany_config锛夆懃AI/鍩虹璁炬柦閰嶇疆銆�**鍒绘剰鎺掗櫎韬唤(users)/鑿滃崟/鏃ュ織/娴佹按**銆� | ruoyi-vue-pro 瀛楅潰閲忓鍑猴紙鑷寘鍚級 |
+| 闃舵浜岋紙鍘� test_identity_seed锛� | 琛ヨ韩浠� + 鑿滃崟鏈�灏忓彲鐧诲綍鏁版嵁锛氣憼`system_menu` 鍏ㄩ儴鏈夋晥鑿滃崟 鈶system_dept`/`post`锛堜粎 deleted=0锛夆憿`system_role` 瓒呯 super_admin 鈶system_users` admin 鈶system_user_role` 鈶system_oauth2_client`锛坈lient_id='default'锛夈�傚箓绛夛細鍏� `DELETE` 鍐� `INSERT`銆� | ruoyi-vue-pro 璺ㄥ簱 `INSERT..SELECT` |
+
+鏃ュ父鍒濆鍖栵細鍙渶鍦ㄧ洰鏍囩┖搴撴墽琛� `config_export_all_20260904.sql` 杩欎竴浠姐��
+
+## 鍚勫彉鏇村綊灞為樁娈碉紙鍏堝垽鏂�"璇ユ斁鍝"锛�
+
+| 鏁版嵁绫诲埆 | 鏀捐繘鍚堝苟鏂囦欢鐨勫摢涓樁娈� |
+|----------|-----------|
+| 鏂颁笟鍔¤〃缁撴瀯锛堝叏搴撲换鎰� CREATE TABLE锛� | 闃舵涓�锛堢粨鏋勶級 |
+| 鏂板/鏀瑰姩鐨勯厤缃被鏁版嵁锛堝瓧鍏搞�丅PM 琛ㄥ崟/娴佺▼銆佺紪鐮佽鍒欍�丅I銆丄I銆佸叕鍙搁厤缃瓑锛� | 闃舵涓�锛堟暟鎹級 |
+| 鑿滃崟 / 閮ㄩ棬 / 宀椾綅 / 瑙掕壊 / 鐢ㄦ埛 / 鐢ㄦ埛瑙掕壊 / OAuth2 瀹㈡埛绔� | **闃舵浜�**锛堜笉杩涢樁娈典竴锛� |
+| 涓氬姟涓绘暟鎹� / 鍗曟嵁 / 娴佹按锛堢墿鏂欍�佸伐鍗曘�佹楠屽崟绛夎繍琛屾暟鎹級 | 閮戒笉杩涳紙浠呭缓绌虹粨鏋勶級锛涗笟鍔℃暟鎹敱鍚勮嚜杩佺Щ鑴氭湰璐熻矗 |
+
+## 缁存姢娓呭崟锛堟湁鍙樻洿鏃舵寜搴忔墽琛岋級
+
+1. 鍒ゆ柇鍙樻洿灞炰簬"琛ㄧ粨鏋� / 閰嶇疆鏁版嵁"杩樻槸"韬唤 / 鏉冮檺"锛岀‘瀹氬畠搴旇惤鍦ㄩ樁娈典竴杩樻槸闃舵浜屻��
+2. **閲嶆柊鐢熸垚鍚堝苟鏂囦欢** `config_export_all_<鏃ユ湡>.sql`锛堢敤褰撳ぉ鏃ユ湡鍛藉悕鏂扮増鏈紝鏃х増淇濈暀澶囨煡锛夛細
+   - 闃舵涓�锛氫粠 `ruoyi-vue-pro` 瀵煎嚭鍏ㄥ簱缁撴瀯 + 6 绫婚厤缃暟鎹��
+   - 闃舵浜岋細鏇存柊韬唤/鑿滃崟/OAuth2 琛ュ娈碉紙濡傚姞鏂拌彍鍗曘�佹柊榛樿瑙掕壊锛夈��
+   - 灏嗕袱娈靛唴瀹规寜銆岄樁娈典竴 鈫� 鍒嗛殧娉ㄩ噴闃舵浜� 鈫� 闃舵浜屻�嶆嫾鎺ユ垚涓�浠藉畬鏁存枃浠躲��
+3. 鍏ㄥ簱缁撴瀯鍙樺寲鍚庯紝鏍稿 Mapper/DO 鏄惁涓庤〃缁撴瀯涓�鑷达紙`mvn compile -q` 涓嶅彈琛ㄧ粨鏋勫奖鍝嶏紝浣嗛渶浜哄伐鏍稿锛夈��
+
+## 鍏抽敭绾︽潫涓庡潙锛堥伩鍏嶈俯锛�
+
+- 鈿� 闃舵涓�鍚�**鍏ㄥ簱 `DROP TABLE IF EXISTS`**锛屼細娓呯┖闈炲叾寤鸿〃鐨勬墍鏈夎〃鏁版嵁锛�**鍙兘鍦ㄥ叏鏂�/鍙鐩栫┖搴撴墽琛�**锛岀姝㈠湪杩愯搴撶洿鎺ヨ窇銆�
+- 鈿� 瓒呯 `super_admin` 鐧诲綍鍚庣敱浠ｇ爜**鐩存帴杩斿洖鍏ㄩ儴鑿滃崟**锛屾晠**涓嶉渶瑕� `system_role_menu` 琛�**锛涗絾 `system_menu` 琛ㄥ繀椤绘湁鏁版嵁銆傝嫢鏈潵瑕佹敮鎸佹櫘閫氳鑹茬櫥褰曪紝鍒欓渶琛ヨ瑙掕壊 鈫� `system_role_menu` 鈫� `system_user_role` 鍏ㄩ摼璺��
+- 鈿� 鐧诲綍/鍒锋柊浠ょ墝**蹇呴』**鏈� `system_oauth2_client` 涓� `client_id='default'` 鐨勮褰曪紝鍚﹀垯 `validOAuthClientFromCache` 鎶ラ敊鐧讳笉涓娿��
+- 瀛楀吀 `system_dict_type`/`system_dict_data` 鐢遍樁娈典竴瀵煎叆锛岄樁娈典簩涓嶉噸澶嶅鐞嗐��
+- 婧愬簱 `system_dept`/`system_post` 鍚緝澶氳蒋鍒犻櫎琛岋紝闃舵浜屼粎鎷疯礉 `deleted=0` 鐨勬湁鏁堣銆�
+- 闃舵涓�鑷寘鍚紙瀛楅潰閲� INSERT锛夛紝涓嶄緷璧栨簮搴撳湪绾匡紱闃舵浜屼緷璧栨簮搴撳湪绾垮仛璺ㄥ簱鎷疯礉銆�
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