-- 管理后台菜单：系统管理 → 操作日志。日志仅允许查询，默认授予超级管理员。
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';