From 2f2347d1dc116aab8fe0b1363d9f92e56a9ea062 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期六, 07 十二月 2024 10:05:19 +0800
Subject: [PATCH] 1
---
docker-compose/mysql/initdb/se_cloud_20241204.sql | 46 ++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 46 insertions(+), 0 deletions(-)
diff --git a/docker-compose/mysql/initdb/se_cloud_20241204.sql b/docker-compose/mysql/initdb/se_cloud_20241204.sql
index 96764e5..531f55e 100644
--- a/docker-compose/mysql/initdb/se_cloud_20241204.sql
+++ b/docker-compose/mysql/initdb/se_cloud_20241204.sql
@@ -29,7 +29,30 @@
) engine=innodb auto_increment=1 comment = '鍒嗙郴缁熶换鍔℃帶鍒惰〃';
select * from sys_task_ctrl order by task_id;
+-- 鑿滃崟 SQL
+insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
+values('鍒嗙郴缁熶换鍔℃帶鍒�', '1', '10', 'taskCtrl', 'system/taskCtrl/index', 1, 0, 'C', '0', '0', 'system:taskCtrl:list', '#', 'admin', sysdate(), '', null, '鍒嗙郴缁熶换鍔℃帶鍒惰彍鍗�');
+-- 鎸夐挳鐖惰彍鍗旾D
+SELECT @parentId := LAST_INSERT_ID();
+
+-- 鎸夐挳 SQL
+insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
+values('鍒嗙郴缁熶换鍔℃帶鍒舵煡璇�', @parentId, '1', '#', '', 1, 0, 'F', '0', '0', 'system:taskCtrl:query', '#', 'admin', sysdate(), '', null, '');
+
+insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
+values('鍒嗙郴缁熶换鍔℃帶鍒舵柊澧�', @parentId, '2', '#', '', 1, 0, 'F', '0', '0', 'system:taskCtrl:add', '#', 'admin', sysdate(), '', null, '');
+
+insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
+values('鍒嗙郴缁熶换鍔℃帶鍒朵慨鏀�', @parentId, '3', '#', '', 1, 0, 'F', '0', '0', 'system:taskCtrl:edit', '#', 'admin', sysdate(), '', null, '');
+
+insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
+values('鍒嗙郴缁熶换鍔℃帶鍒跺垹闄�', @parentId, '4', '#', '', 1, 0, 'F', '0', '0', 'system:taskCtrl:remove', '#', 'admin', sysdate(), '', null, '');
+
+insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
+values('鍒嗙郴缁熶换鍔℃帶鍒跺鍑�', @parentId, '5', '#', '', 1, 0, 'F', '0', '0', 'system:taskCtrl:export', '#', 'admin', sysdate(), '', null, '');
+
+update sys_menu set mark = 'sys' where menu_id >= @parentId;
-- ----------------------------
-- 02銆佺郴缁熺姸鎬佺洃鎺ц〃
-- ----------------------------
@@ -53,6 +76,29 @@
insert into sys_status_ctrl (sys_name, ip, url, method, order_num) values ('鍒嗙郴缁�01', '127.0.0.1', 'http://localhost:8080/system/health', 'GET', 1);
+-- 鑿滃崟 SQL
+insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
+values('绯荤粺鐘舵�佺洃鎺�', '1', '9', 'statusCtrl', 'system/statusCtrl/index', 1, 0, 'C', '0', '0', 'system:statusCtrl:list', '#', 'admin', sysdate(), '', null, '绯荤粺鐘舵�佺洃鎺ц彍鍗�');
+-- 鎸夐挳鐖惰彍鍗旾D
+SELECT @parentId := LAST_INSERT_ID();
+
+-- 鎸夐挳 SQL
+insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
+values('绯荤粺鐘舵�佺洃鎺ф煡璇�', @parentId, '1', '#', '', 1, 0, 'F', '0', '0', 'system:statusCtrl:query', '#', 'admin', sysdate(), '', null, '');
+
+insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
+values('绯荤粺鐘舵�佺洃鎺ф柊澧�', @parentId, '2', '#', '', 1, 0, 'F', '0', '0', 'system:statusCtrl:add', '#', 'admin', sysdate(), '', null, '');
+
+insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
+values('绯荤粺鐘舵�佺洃鎺т慨鏀�', @parentId, '3', '#', '', 1, 0, 'F', '0', '0', 'system:statusCtrl:edit', '#', 'admin', sysdate(), '', null, '');
+
+insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
+values('绯荤粺鐘舵�佺洃鎺у垹闄�', @parentId, '4', '#', '', 1, 0, 'F', '0', '0', 'system:statusCtrl:remove', '#', 'admin', sysdate(), '', null, '');
+
+insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
+values('绯荤粺鐘舵�佺洃鎺у鍑�', @parentId, '5', '#', '', 1, 0, 'F', '0', '0', 'system:statusCtrl:export', '#', 'admin', sysdate(), '', null, '');
+
+update sys_menu set mark = 'sys' where menu_id >= @parentId;
-- ----------------------------
--
Gitblit v1.9.3