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_20241119.sql | 25 +++++++++++++++++++++++++ 1 files changed, 25 insertions(+), 0 deletions(-) diff --git a/docker-compose/mysql/initdb/se_cloud_20241119.sql b/docker-compose/mysql/initdb/se_cloud_20241119.sql index 3ffedee..c9d6c1a 100644 --- a/docker-compose/mysql/initdb/se_cloud_20241119.sql +++ b/docker-compose/mysql/initdb/se_cloud_20241119.sql @@ -33,6 +33,31 @@ insert into sys_soft (name, type, args) values ('se-system', 4, 'se-system'); insert into sys_soft (name, type, args) values ('se-wgcloud', 4, 'se-wgcloud'); + +-- 鑿滃崟 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', '8', 'soft', 'system/soft/index', 1, 0, 'C', '0', '0', 'system:soft: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:soft: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:soft: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:soft: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:soft: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:soft:export', '#', 'admin', sysdate(), '', null, ''); + +update sys_menu set mark = 'sys' where menu_id >= @parentId; -- ---------------------------- -- 02銆佺‖浠惰〃 -- ---------------------------- -- Gitblit v1.9.3