From 606535251ddf9fb585ffc97c3651b383c2db1224 Mon Sep 17 00:00:00 2001
From: yangys <y_ys79@sina.com>
Date: 星期三, 20 八月 2025 14:25:14 +0800
Subject: [PATCH] 导入工控网，附件改名

---
 doc/sql/mdm/mdm.mysql.cleandata.sql |   59 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 doc/mdm/divisiontemplate.xlsx       |    0 
 2 files changed, 59 insertions(+), 0 deletions(-)

diff --git a/doc/mdm/divisiontemplate.xlsx b/doc/mdm/divisiontemplate.xlsx
new file mode 100644
index 0000000..669d77b
--- /dev/null
+++ b/doc/mdm/divisiontemplate.xlsx
Binary files differ
diff --git a/doc/sql/mdm/mdm.mysql.cleandata.sql b/doc/sql/mdm/mdm.mysql.cleandata.sql
new file mode 100644
index 0000000..9327e2f
--- /dev/null
+++ b/doc/sql/mdm/mdm.mysql.cleandata.sql
@@ -0,0 +1,59 @@
+--娓呯┖涓氬姟鏁版嵁锛屼笉鍚厤缃暟鎹�
+delete from mdm_nc_node;
+delete from mdm_dnc_back_file;
+delete from mdm_program_seq;
+delete from mdm_flow_program_file;
+delete from mdm_task_dispatch;
+delete from mdm_approve_record;
+delete from mdm_approve_record;
+delete from mdm_nc_program_approved;
+
+--娓呯┖flowable娴佺▼瀹炰緥鏁版嵁
+
+-- 娓呯┖杩愯鏃舵暟鎹�
+DELETE FROM ACT_RU_TASK;
+DELETE FROM ACT_RU_IDENTITYLINK;
+DELETE FROM ACT_RU_VARIABLE;
+DELETE FROM ACT_RU_EXECUTION;
+DELETE FROM ACT_RU_EVENT_SUBSCR;
+DELETE FROM ACT_RU_JOB;
+DELETE FROM ACT_RU_DEADLETTER_JOB;
+DELETE FROM ACT_RU_SUSPENDED_JOB;
+DELETE FROM ACT_RU_TIMER_JOB;
+DELETE FROM ACT_RU_HISTORY_JOB;
+
+-- 娓呯┖鍘嗗彶鏁版嵁
+DELETE FROM ACT_HI_TASKINST;
+DELETE FROM ACT_HI_TSK_LOG;
+DELETE FROM ACT_HI_PROCINST;
+DELETE FROM ACT_HI_IDENTITYLINK;
+DELETE FROM ACT_HI_DETAIL;
+DELETE FROM ACT_HI_VARINST;
+DELETE FROM ACT_HI_ACTINST;
+DELETE FROM ACT_HI_COMMENT;
+DELETE FROM ACT_HI_ATTACHMENT;
+DELETE FROM ACT_HI_INCIDENT;
+DELETE FROM ACT_HI_JOB_LOG;
+DELETE FROM ACT_HI_BATCH;
+
+-- 娓呯┖韬唤鏁版嵁
+DELETE FROM ACT_ID_USER;
+DELETE FROM ACT_ID_INFO;
+DELETE FROM ACT_ID_GROUP;
+DELETE FROM ACT_ID_MEMBERSHIP;
+DELETE FROM ACT_ID_PRIV;
+DELETE FROM ACT_ID_PRIV_MAPPING;
+
+-- 娓呯┖閮ㄧ讲鏁版嵁
+-- DELETE FROM ACT_RE_DEPLOYMENT;
+-- DELETE FROM ACT_RE_PROCDEF;
+-- DELETE FROM ACT_RE_MODEL;
+-- DELETE FROM ACT_RE_DECISION_DEF;
+-- DELETE FROM ACT_RE_CASE_DEF;
+-- DELETE FROM ACT_RE_DECISION_REQ_DEF;
+
+-- 娓呯┖鍏朵粬琛�
+DELETE FROM ACT_EVT_LOG;
+DELETE FROM ACT_PROCDEF_INFO;
+DELETE FROM ACT_CMMN_DATABASECHANGELOG;
+DELETE FROM ACT_DMN_DATABASECHANGELOG;
\ No newline at end of file

--
Gitblit v1.9.3