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