From 0cc6de48784e1fd8d00737168a1704584b1daf81 Mon Sep 17 00:00:00 2001
From: tuqin <tuqin@tuqin.cn>
Date: 星期一, 02 十一月 2026 10:18:20 +0800
Subject: [PATCH] feat(bpm): 所有流程定义的流程管理员统一设置为超级管理员

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

diff --git a/sql/mysql/bpm_set_process_manager_to_admin.sql b/sql/mysql/bpm_set_process_manager_to_admin.sql
new file mode 100644
index 0000000..8294226
--- /dev/null
+++ b/sql/mysql/bpm_set_process_manager_to_admin.sql
@@ -0,0 +1,40 @@
+-- =====================================================================
+-- 灏嗘墍鏈夋祦绋嬪畾涔夌殑銆屾祦绋嬬鐞嗗憳銆嶇粺涓�璁剧疆涓鸿秴绾х鐞嗗憳
+--
+-- 鑳屾櫙锛歜pm_process_definition_info.manager_user_ids 璁板綍姣忎釜娴佺▼鐨勭鐞嗗憳鐢ㄦ埛缂栧彿鏁扮粍
+--       锛堥�楀彿鍒嗛殧锛夈�傚師鍏堝ぇ閮ㄥ垎娴佺▼璇ュ瓧娈典负 NULL锛屽皯閮ㄥ垎鎸囧悜鍏蜂綋鍛樺伐锛堝 142锛夛紝
+--       瀵艰嚧娴佺▼妯″瀷/娴佺▼瀹氫箟鐨勭鐞嗗叆鍙e彧鏈夐浂鏄熷嚑涓汉鑳界湅鍒般��
+--
+-- 澶勭悊锛氱粺涓�鏀逛负 1锛堣秴绾х鐞嗗憳 admin 鐨勭敤鎴风紪鍙凤級锛屼繚璇佽秴绠¤兘鐪嬪埌骞剁鐞嗗叏閮ㄦ祦绋嬨��
+--
+-- 鐗规�э細鍙噸澶嶆墽琛�
+-- =====================================================================
+
+-- ---------------------------------------------------------------------
+-- 1. 鎵ц鍓嶇幇鐘�
+-- ---------------------------------------------------------------------
+SELECT id,
+       process_definition_id,
+       manager_user_ids AS before_manager
+FROM bpm_process_definition_info
+WHERE deleted = b'0'
+ORDER BY id;
+
+-- ---------------------------------------------------------------------
+-- 2. 鍏ㄩ儴璁句负瓒呯骇绠$悊鍛�
+-- ---------------------------------------------------------------------
+UPDATE bpm_process_definition_info
+SET manager_user_ids = '1',
+    updater          = '1',
+    update_time      = NOW()
+WHERE deleted = b'0';
+
+-- ---------------------------------------------------------------------
+-- 3. 鎵ц鍚庣‘璁わ紙搴斿叏閮ㄤ负 1锛�
+-- ---------------------------------------------------------------------
+SELECT id,
+       process_definition_id,
+       manager_user_ids AS after_manager
+FROM bpm_process_definition_info
+WHERE deleted = b'0'
+ORDER BY id;

--
Gitblit v1.9.3