microservices/sql/update/20230926170541_alert_role_menu.sql

-- 删除多余权限数据
SET FOREIGN_KEY_CHECKS = 0;

DELETE
FROM `sys_role_menu`
WHERE `role_id` = 5
  AND `menu_id` = 2087;

DELETE
FROM `sys_role_menu`
WHERE `role_id` = 5
  AND `menu_id` = 2177;

DELETE
FROM `sys_role_menu`
WHERE `role_id` = 8
  AND `menu_id` = 2203;

SET FOREIGN_KEY_CHECKS = 1;