From f47d68e85a846fec53e0d5b335ee019b3d5bd054 Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期六, 24 十月 2026 23:19:00 +0800
Subject: [PATCH] fix(mes): 补充赋能管理追溯权限
---
sql/mysql/xgdl_enablement_menu_fix_20261024.sql | 17 +++++++++++++++++
1 files changed, 17 insertions(+), 0 deletions(-)
diff --git a/sql/mysql/xgdl_enablement_menu_fix_20261024.sql b/sql/mysql/xgdl_enablement_menu_fix_20261024.sql
index 2a37173..268d4f0 100644
--- a/sql/mysql/xgdl_enablement_menu_fix_20261024.sql
+++ b/sql/mysql/xgdl_enablement_menu_fix_20261024.sql
@@ -12,3 +12,20 @@
`update_time` = NOW()
WHERE `id` = 5906
AND `deleted` = b'0';
+
+-- 宸叉湁鈥滆祴鑳界鐞嗏�濇潈闄愮殑瑙掕壊鑷姩琛ュ厖鈥滄壒娆¤拷婧煡璇⑩�濇潈闄愶紝
+-- 鍚﹀垯椤甸潰涓殑鈥滃叏閾捐矾杩芥函鈥濇寜閽細琚潈闄愭帶鍒堕殣钘忋��
+INSERT INTO `system_role_menu`
+ (`role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`)
+SELECT source_role.`role_id`, 5967, '1', NOW(), '1', NOW(), b'0', source_role.`tenant_id`
+FROM `system_role_menu` source_role
+WHERE source_role.`menu_id` = 5911
+ AND source_role.`deleted` = b'0'
+ AND NOT EXISTS (
+ SELECT 1
+ FROM `system_role_menu` target_role
+ WHERE target_role.`role_id` = source_role.`role_id`
+ AND target_role.`menu_id` = 5967
+ AND target_role.`tenant_id` = source_role.`tenant_id`
+ AND target_role.`deleted` = b'0'
+ );
--
Gitblit v1.9.3