1
2
3
4
5
6
7
8
9
10
11
12
13
| -- 管理后台菜单：系统管理 → 操作日志。日志仅允许查询，默认授予超级管理员。
| INSERT INTO `sys_menu` (`code`, `pcode`, `pcodes`, `name`, `icon`, `url`, `num`, `levels`, `ismenu`, `tips`, `status`, `isopen`)
| SELECT 'accountAuditLog', 'system', '[0],[system],', '操作日志', 'fa-list-alt', '/accountAuditLog', 998, 2, 1, '统一账号操作审计日志查询', 1, 1
| WHERE NOT EXISTS (SELECT 1 FROM `sys_menu` WHERE `code` = 'accountAuditLog');
|
| INSERT INTO `sys_relation` (`menuid`, `roleid`)
| SELECT m.id, 1 FROM `sys_menu` m
| WHERE m.code = 'accountAuditLog'
| AND NOT EXISTS (SELECT 1 FROM `sys_relation` r WHERE r.menuid = m.id AND r.roleid = 1);
|
| -- 回滚：
| -- DELETE r FROM `sys_relation` r INNER JOIN `sys_menu` m ON r.menuid = m.id WHERE m.code = 'accountAuditLog';
| -- DELETE FROM `sys_menu` WHERE `code` = 'accountAuditLog';
|
|
