From f7b42c9c6308040dd0b224e68d288cff533f076a Mon Sep 17 00:00:00 2001 From: gaoluyang <2820782392@qq.com> Date: 星期一, 02 十一月 2026 11:48:59 +0800 Subject: [PATCH] fix(sql): 恢复诚发五金库中被误删的查询按钮权限 --- docs/sql/cfwj_restore_query_permissions.sql | 23 +++++++++++++++++++++++ 1 files changed, 23 insertions(+), 0 deletions(-) diff --git a/docs/sql/cfwj_restore_query_permissions.sql b/docs/sql/cfwj_restore_query_permissions.sql new file mode 100644 index 0000000..ca621be --- /dev/null +++ b/docs/sql/cfwj_restore_query_permissions.sql @@ -0,0 +1,23 @@ +-- ============================================================ +-- 璇氬彂浜旈噾锛氭仮澶嶈璇垹鐨勩�屾煡璇€�嶆寜閽潈闄� +-- 鑳屾櫙锛氬簱鍐� 78 涓綊灞炴湁鏁堣彍鍗曠殑 xxx:query 鎸夐挳琚蒋鍒犻櫎锛坉eleted=1锛夛紝 +-- 鍓嶇鍒楄〃椤电殑銆岃鎯呫�嶃�屾墦鍗般�嶇瓑鎸夐挳浠� xxx:query 浣滀负鏄鹃殣鏉冮檺锛� +-- 鏉冮檺鐮佺己澶卞悗鎸夐挳涓嶅啀娓叉煋锛堜緥濡傞噰璐鍗曞垪琛ㄥ彧鍓┿�岀‘璁ゆ敹璐�/鍒犻櫎銆嶏級锛� +-- 鐢ㄦ埛鏃犳硶鏌ョ湅閲囪喘璁㈠崟璇︽儏銆傝彍鍗曟湰韬湭琚垹闄わ紝瑙掕壊涔熶粛鐒朵繚鐣欑潃 +-- 杩欎簺鎸夐挳鐨勬巿鏉冿紝璇存槑鏄寜閽琚鍒犺�岄潪涓氬姟涓婁笉瑕佽鏉冮檺銆� +-- 鐩爣搴擄細璇氬彂浜旈噾瀹㈡埛搴擄紙鏈湴涓� CFWJ锛夛紝璇锋寜瀹為檯搴撳悕鎵ц鎴栧厛 USE銆� +-- 骞傜瓑锛氬彧鎶娿�岀埗鑿滃崟浠嶆湁鏁堛�嶇殑杞垹闄� :query 鎸夐挳鎭㈠锛屽彲閲嶅鎵ц銆� +-- 娉ㄦ剰锛氭湰鑴氭湰涓嶅惈 tenant_id锛堝崟绉熸埛锛夈�� +-- ============================================================ + +UPDATE `system_menu` m +JOIN `system_menu` p ON p.`id` = m.`parent_id` AND p.`deleted` = b'0' +SET m.`deleted` = b'0', m.`update_time` = NOW() +WHERE m.`deleted` = b'1' + AND m.`type` = 3 + AND m.`permission` LIKE '%:query'; + +-- 楠岃瘉锛氫互涓嬪簲杩斿洖 0锛堢埗鑿滃崟鏈夋晥鏃讹紝涓嶅啀鏈夎鍒犻櫎鐨勬煡璇㈡寜閽級 +-- SELECT COUNT(*) FROM system_menu m +-- JOIN system_menu p ON p.id = m.parent_id AND p.deleted = b'0' +-- WHERE m.deleted = b'1' AND m.type = 3 AND m.permission LIKE '%:query'; -- Gitblit v1.9.3