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