From 14f23d488ac120c89a3ef4ed5dfac6f66cd48b3e Mon Sep 17 00:00:00 2001
From: tuqin <tuqin@tuqin.cn>
Date: 星期一, 02 十一月 2026 13:19:41 +0800
Subject: [PATCH] fix(safety): 修正各期 SQL 的菜单 id 清理范围重叠问题
---
sql/mysql/mes_safety_statistics_init.sql | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/sql/mysql/mes_safety_statistics_init.sql b/sql/mysql/mes_safety_statistics_init.sql
index cf759b1..9bdcbfe 100644
--- a/sql/mysql/mes_safety_statistics_init.sql
+++ b/sql/mysql/mes_safety_statistics_init.sql
@@ -13,9 +13,9 @@
-- 鐗规�э細鍙噸澶嶆墽琛�
-- =====================================================================
-DELETE FROM system_role_menu WHERE menu_id BETWEEN 1065963 AND 1065970;
+DELETE FROM system_role_menu WHERE menu_id BETWEEN 1065963 AND 1065965;
-DELETE FROM system_menu WHERE id BETWEEN 1065963 AND 1065970;
+DELETE FROM system_menu WHERE id BETWEEN 1065963 AND 1065965;
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon,
component, component_name, status, visible, keep_alive, always_show,
@@ -29,7 +29,7 @@
INSERT INTO system_role_menu (role_id, menu_id, creator, create_time, updater, update_time, deleted)
SELECT 1, m.id, '1', NOW(), '1', NOW(), b'0'
FROM system_menu m
-WHERE m.id BETWEEN 1065963 AND 1065970;
+WHERE m.id BETWEEN 1065963 AND 1065965;
-- ---------------------------------------------------------------------
-- 楠岃瘉锛氬畨鍏ㄧ敓浜х洰褰曚笅鐨勫畬鏁磋彍鍗曠粨鏋�
--
Gitblit v1.9.3