1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
| -- HTTP 审计规则菜单（系统管理下，与 HTTP接口审计 同级）；执行前请确认 id 393-397 未被占用
| SET NAMES utf8mb4;
|
| INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`)
| SELECT 393, 'menu.httpAuditRule', 1, 'menu.system', '1,393', 'menu.httpAuditRule', '/system/httpAuditRule', 'httpAuditRule', NULL, NULL, 0, NULL, 'Rule', 7, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL
| FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `sys_menu` WHERE `id` = 393);
|
| INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`)
| SELECT 394, 'Query HttpAuditRule', 393, '', '1,393,394', NULL, NULL, NULL, NULL, NULL, 1, 'system:httpAuditRule:list', NULL, 0, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL
| FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `sys_menu` WHERE `id` = 394);
|
| INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`)
| SELECT 395, 'Save HttpAuditRule', 393, '', '1,393,395', NULL, NULL, NULL, NULL, NULL, 1, 'system:httpAuditRule:save', NULL, 1, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL
| FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `sys_menu` WHERE `id` = 395);
|
| INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`)
| SELECT 396, 'Update HttpAuditRule', 393, '', '1,393,396', NULL, NULL, NULL, NULL, NULL, 1, 'system:httpAuditRule:update', NULL, 2, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL
| FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `sys_menu` WHERE `id` = 396);
|
| INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`)
| SELECT 397, 'Delete HttpAuditRule', 393, '', '1,393,397', NULL, NULL, NULL, NULL, NULL, 1, 'system:httpAuditRule:remove', NULL, 3, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL
| FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `sys_menu` WHERE `id` = 397);
|
| INSERT INTO `sys_role_menu` (`role_id`, `menu_id`)
| SELECT 1, 393 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `sys_role_menu` WHERE `role_id` = 1 AND `menu_id` = 393);
| INSERT INTO `sys_role_menu` (`role_id`, `menu_id`)
| SELECT 1, 394 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `sys_role_menu` WHERE `role_id` = 1 AND `menu_id` = 394);
| INSERT INTO `sys_role_menu` (`role_id`, `menu_id`)
| SELECT 1, 395 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `sys_role_menu` WHERE `role_id` = 1 AND `menu_id` = 395);
| INSERT INTO `sys_role_menu` (`role_id`, `menu_id`)
| SELECT 1, 396 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `sys_role_menu` WHERE `role_id` = 1 AND `menu_id` = 396);
| INSERT INTO `sys_role_menu` (`role_id`, `menu_id`)
| SELECT 1, 397 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `sys_role_menu` WHERE `role_id` = 1 AND `menu_id` = 397);
|
|
