From 6774e2d2a4442cc8485d60ff34f76fcf1496f5c7 Mon Sep 17 00:00:00 2001 From: liu <2021943741@qq.com> Date: 星期三, 30 九月 2026 15:26:17 +0800 Subject: [PATCH] docs(wxcp): 补 wxcp_user 默认角色的建角色/授权 SQL 与部署说明 --- docs/sql/config_export_all_20260929.sql | 65 ++++++++++++++++++++++++++++++++ 1 files changed, 65 insertions(+), 0 deletions(-) diff --git a/docs/sql/config_export_all_20260929.sql b/docs/sql/config_export_all_20260929.sql index 7f1cc1e..921f8a9 100644 --- a/docs/sql/config_export_all_20260929.sql +++ b/docs/sql/config_export_all_20260929.sql @@ -11634,4 +11634,69 @@ -- WHERE `r`.`id` IN (1, 160, 2) -- 杩藉姞缁欍�屾櫘閫氳鑹层�� -- ============================================================ +-- ============================================================ +-- 浼佷笟寰俊鎵爜鑷姩娉ㄥ唽璐﹀彿鐨勯粯璁よ鑹诧細wxcp_user +-- 锛堜笌 docs/sql/wxcp_menu.sql 鏈熬鍚屼竴娈碉紝淇濇寔鍚屾锛� +-- +-- 蹇呴』鏀惧湪鏈枃浠堕樁娈典簩鐨� `DELETE FROM system_role` 涔嬪悗鎵ц锛� +-- 鍚﹀垯瑙掕壊浼氳闃舵浜屼粠婧愬簱閲嶆嫹鏃舵竻鎺� 鈥斺�� 杩欎篃鏄畠钀藉湪闃舵涓夋湯灏剧殑鍘熷洜銆� +-- +-- 鑳屾櫙锛氫紒涓氬井淇￠娆℃壂鐮佽蛋銆岃嚜鍔ㄦ敞鍐屻�嶅缓鍙凤紝寤哄畬鎸夈�岃鑹茬紪鐮併�嶆煡鏈寤哄嚭鏉ョ殑 +-- 杩欎釜瑙掕壊骞剁粦瀹氥�備唬鐮佸父閲忚 AdminAuthServiceImpl.WXCP_DEFAULT_ROLE_CODE銆� +-- 瑙掕壊涓嶅瓨鍦ㄦ椂浠ｇ爜鍙墦 warn 鏃ュ織銆佷笉闃绘柇鐧诲綍 鈥斺�� 璐﹀彿鑳借繘浣嗕竴涓彍鍗曢兘娌℃湁锛� +-- 灞炰簬銆岃兘鐧诲綍鍗翠粈涔堥兘鐪嬩笉鍒般�嶇殑闈欓粯鏁呴殰銆� +-- +-- 鎺堜簣鑼冨洿锛氫粎銆屼細鍛樼鐞嗐�嶆暣妫靛瓙鏍戯紙鏍硅彍鍗曠紪鍙� 1075490锛屽畾涔夎 ums_module.sql锛夈�� +-- 棣栭〉鏄墠绔潤鎬佽矾鐢便�佷笉渚濊禆鑿滃崟琛紝浠讳綍璐﹀彿閮界湅寰楀埌锛屾棤闇�鎺堟潈銆� +-- +-- 骞傜瓑锛氳鑹插厛鏌ュ悗鎻掞紱瑙掕壊鑿滃崟鍏宠仈鍏堝垹鍚庢彃锛屽彲閲嶅鎵ц銆� +-- ============================================================ + +-- 1) 寤鸿鑹� +INSERT INTO `system_role` + (`name`, `code`, `sort`, `data_scope`, `data_scope_dept_ids`, `status`, `type`, `remark`, `creator`, `updater`) +SELECT '浼佷笟寰俊鎵爜鐢ㄦ埛', 'wxcp_user', 100, 1, '', 0, 2, + '浼佷笟寰俊棣栨鎵爜鑷姩娉ㄥ唽鐨勮处鍙烽粯璁よ鑹诧紝浠呮巿浜堛�屼細鍛樼鐞嗐�嶆ā鍧�', + 'admin', 'admin' +FROM DUAL +WHERE NOT EXISTS ( + SELECT 1 FROM (SELECT `id` FROM `system_role` + WHERE `code` = 'wxcp_user' AND `deleted` = b'0') `t`); + +-- 2) 鍙栬鑹茬紪鍙凤紙鏂板缓鐨勪笌宸插瓨鍦ㄧ殑閮藉彇寰楀埌锛涘彇涓嶅埌鏃朵负 NULL锛屼笅闈袱鍙ヨ嚜鐒朵笉鐢熸晥锛� +SET @wxcp_role_id = (SELECT `id` FROM `system_role` + WHERE `code` = 'wxcp_user' AND `deleted` = b'0' LIMIT 1); + +-- 3) 鎺堟潈锛氫細鍛樼鐞嗘牴鑿滃崟(1075490) + 瀛愯彍鍗� + 瀛欒彍鍗曪紝涓夌骇瑕嗙洊鏁存５瀛愭爲 +DELETE FROM `system_role_menu` WHERE `role_id` = @wxcp_role_id; + +INSERT INTO `system_role_menu` (`role_id`, `menu_id`, `creator`, `updater`) +SELECT @wxcp_role_id, `m`.`id`, 'admin', 'admin' +FROM `system_menu` `m` +LEFT JOIN `system_menu` `p1` ON `p1`.`id` = `m`.`parent_id` +LEFT JOIN `system_menu` `p2` ON `p2`.`id` = `p1`.`parent_id` +WHERE `m`.`deleted` = b'0' + AND (`m`.`id` = 1075490 OR `p1`.`id` = 1075490 OR `p2`.`id` = 1075490) + AND @wxcp_role_id IS NOT NULL; + +-- 4) 鍥炲～锛氱粰鏈鎵ц鍓嶅氨宸插瓨鍦ㄧ殑鑷姩娉ㄥ唽璐﹀彿琛ヤ笂榛樿瑙掕壊 +-- +-- 涓轰粈涔堝繀椤绘湁杩欎竴姝ワ細璐﹀彿涓�鏃﹀啓杩� system_social_user_bind锛屽啀娆℃壂鐮佽蛋鐨勬槸 +-- 銆屽凡缁戝畾銆嶅垎鏀紝涓嶄細鍐嶈繘鑷姩娉ㄥ唽閫昏緫 鈥斺�� 涓嶈ˉ鐨勮瘽杩欐壒鑰佽处鍙锋案杩滄病鏈夎彍鍗曘�� +-- +-- 鍙鑷姩娉ㄥ唽鐨勭敤鎴峰悕鍓嶇紑锛坵x_ + 8 浣嶅崄鍏繘鍒讹紝涓� AdminAuthServiceImpl 鐢熸垚瑙勫垯涓�鑷达級锛� +-- 鐢� ESCAPE 鏄惧紡澹版槑杞箟绗︼紝閬垮厤 `_` 琚� LIKE 褰撴垚鍗曞瓧绗﹂�氶厤銆� +-- system_user_role 娌℃湁 (user_id, role_id) 鍞竴绾︽潫锛屾墍浠ョ敤 NOT EXISTS 鍏滃箓绛夈�� +INSERT INTO `system_user_role` (`user_id`, `role_id`, `creator`, `updater`) +SELECT `u`.`id`, @wxcp_role_id, 'admin', 'admin' +FROM `system_users` `u` +WHERE `u`.`deleted` = b'0' + AND `u`.`username` LIKE 'wx!_%' ESCAPE '!' + AND @wxcp_role_id IS NOT NULL + AND NOT EXISTS ( + SELECT 1 FROM (SELECT `user_id` FROM `system_user_role` + WHERE `role_id` = @wxcp_role_id + AND `deleted` = b'0') `t` + WHERE `t`.`user_id` = `u`.`id`); + SET FOREIGN_KEY_CHECKS = 1; -- Gitblit v1.9.3