30 lines
1.7 KiB
SQL
30 lines
1.7 KiB
SQL
-- ============================================
|
||
-- 轮播图管理 - 菜单数据插入（可独立执行）
|
||
-- 使用方法: 直接在数据库中运行此 SQL
|
||
-- ============================================
|
||
|
||
-- 轮播图管理菜单项（顶级菜单 parent_id=0）
|
||
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, menu_type, perms, component, status, created_at, updated_at)
|
||
SELECT 19, '轮播图管理', 0, 8, 'C', 'system:banner:list', 'banner/index', 1, NOW(), NOW()
|
||
WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE id = 19);
|
||
|
||
-- 按钮权限
|
||
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, menu_type, perms, component, status, created_at, updated_at)
|
||
SELECT 191, '轮播图查询', 19, 1, 'F', 'system:banner:query', NULL, 1, NOW(), NOW()
|
||
WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE id = 191);
|
||
|
||
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, menu_type, perms, component, status, created_at, updated_at)
|
||
SELECT 192, '轮播图新增', 19, 2, 'F', 'system:banner:add', NULL, 1, NOW(), NOW()
|
||
WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE id = 192);
|
||
|
||
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, menu_type, perms, component, status, created_at, updated_at)
|
||
SELECT 193, '轮播图修改', 19, 3, 'F', 'system:banner:edit', NULL, 1, NOW(), NOW()
|
||
WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE id = 193);
|
||
|
||
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, menu_type, perms, component, status, created_at, updated_at)
|
||
SELECT 194, '轮播图删除', 19, 4, 'F', 'system:banner:remove', NULL, 1, NOW(), NOW()
|
||
WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE id = 194);
|
||
|
||
-- 重置序列
|
||
SELECT setval('sys_menu_id_seq', (SELECT COALESCE(MAX(id), 1) FROM sys_menu));
|