1
2
3
4
5
6
7
8
9
10
11
12
| -- Ticket10 修订：接收状态改为测试级轮询开关；旧区间表保留为历史数据，不再由业务读写。
| SET @stop_menu_id := (SELECT COALESCE(MAX(menu_id), 0) + 1 FROM sys_menu);
| INSERT INTO sys_menu
| (menu_id, menu_name, parent_id, order_num, path, component, query, route_name,
| is_frame, is_cache, menu_type, visible, status, perms, icon,
| create_by, create_time, update_by, update_time, remark)
| SELECT @stop_menu_id, '停止测试', menu_id, 9, '', NULL, NULL, '', 1, 0, 'F', '0', '0',
| 'system:test:stop', '#', 'admin', NOW(), '', NULL, '测试停止权限'
| FROM sys_menu
| WHERE perms = 'system:test:list'
| AND NOT EXISTS (SELECT 1 FROM sys_menu existing WHERE existing.perms = 'system:test:stop')
| LIMIT 1;
|
|
