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_dashboard_init.sql | 4 ++--
sql/mysql/mes_safety_hazard_init.sql | 6 +++---
sql/mysql/mes_safety_training_init.sql | 6 +++---
sql/mysql/mes_safety_ticket_init.sql | 6 +++---
sql/mysql/mes_safety_statistics_init.sql | 6 +++---
5 files changed, 14 insertions(+), 14 deletions(-)
diff --git a/sql/mysql/mes_safety_dashboard_init.sql b/sql/mysql/mes_safety_dashboard_init.sql
index 12b992b..4d0fc7c 100644
--- a/sql/mysql/mes_safety_dashboard_init.sql
+++ b/sql/mysql/mes_safety_dashboard_init.sql
@@ -9,9 +9,9 @@
-- 鐗规�э細鍙噸澶嶆墽琛�
-- =====================================================================
-DELETE FROM system_role_menu WHERE menu_id BETWEEN 1065961 AND 1065970;
+DELETE FROM system_role_menu WHERE menu_id BETWEEN 1065961 AND 1065962;
-DELETE FROM system_menu WHERE id BETWEEN 1065961 AND 1065970;
+DELETE FROM system_menu WHERE id BETWEEN 1065961 AND 1065962;
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon,
component, component_name, status, visible, keep_alive, always_show,
diff --git a/sql/mysql/mes_safety_hazard_init.sql b/sql/mysql/mes_safety_hazard_init.sql
index c595e9c..a49ad9e 100644
--- a/sql/mysql/mes_safety_hazard_init.sql
+++ b/sql/mysql/mes_safety_hazard_init.sql
@@ -101,9 +101,9 @@
-- ---------------------------------------------------------------------
-- 3. 鑿滃崟锛堟寕鍦� 1065910 瀹夊叏鐢熶骇涓嬶級
-- ---------------------------------------------------------------------
-DELETE FROM system_role_menu WHERE menu_id BETWEEN 1065927 AND 1065940;
+DELETE FROM system_role_menu WHERE menu_id BETWEEN 1065927 AND 1065933;
-DELETE FROM system_menu WHERE id BETWEEN 1065927 AND 1065940;
+DELETE FROM system_menu WHERE id BETWEEN 1065927 AND 1065933;
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon,
component, component_name, status, visible, keep_alive, always_show,
@@ -124,7 +124,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 1065927 AND 1065940;
+WHERE m.id BETWEEN 1065927 AND 1065933;
-- ---------------------------------------------------------------------
-- 5. 楠岃瘉
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;
-- ---------------------------------------------------------------------
-- 楠岃瘉锛氬畨鍏ㄧ敓浜х洰褰曚笅鐨勫畬鏁磋彍鍗曠粨鏋�
diff --git a/sql/mysql/mes_safety_ticket_init.sql b/sql/mysql/mes_safety_ticket_init.sql
index d7daeec..60a9b1d 100644
--- a/sql/mysql/mes_safety_ticket_init.sql
+++ b/sql/mysql/mes_safety_ticket_init.sql
@@ -118,9 +118,9 @@
-- ---------------------------------------------------------------------
-- 鑿滃崟锛堟寕鍦� 1065910 瀹夊叏鐢熶骇涓嬶級
-- ---------------------------------------------------------------------
-DELETE FROM system_role_menu WHERE menu_id BETWEEN 1065934 AND 1065950;
+DELETE FROM system_role_menu WHERE menu_id BETWEEN 1065934 AND 1065940;
-DELETE FROM system_menu WHERE id BETWEEN 1065934 AND 1065950;
+DELETE FROM system_menu WHERE id BETWEEN 1065934 AND 1065940;
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon,
component, component_name, status, visible, keep_alive, always_show,
@@ -138,7 +138,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 1065934 AND 1065950;
+WHERE m.id BETWEEN 1065934 AND 1065940;
-- ---------------------------------------------------------------------
-- 楠岃瘉
diff --git a/sql/mysql/mes_safety_training_init.sql b/sql/mysql/mes_safety_training_init.sql
index dd170bf..564cabc 100644
--- a/sql/mysql/mes_safety_training_init.sql
+++ b/sql/mysql/mes_safety_training_init.sql
@@ -161,9 +161,9 @@
-- ---------------------------------------------------------------------
-- 5. 鑿滃崟锛堟寕鍦� 1065910 瀹夊叏鐢熶骇涓嬶級
-- ---------------------------------------------------------------------
-DELETE FROM system_role_menu WHERE menu_id BETWEEN 1065941 AND 1065960;
+DELETE FROM system_role_menu WHERE menu_id BETWEEN 1065941 AND 1065951;
-DELETE FROM system_menu WHERE id BETWEEN 1065941 AND 1065960;
+DELETE FROM system_menu WHERE id BETWEEN 1065941 AND 1065951;
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon,
component, component_name, status, visible, keep_alive, always_show,
@@ -188,7 +188,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 1065941 AND 1065960;
+WHERE m.id BETWEEN 1065941 AND 1065951;
-- ---------------------------------------------------------------------
-- 6. 楠岃瘉
--
Gitblit v1.9.3