1
2
3
4
5
6
7
8
9
10
11
12
13
14
| -- 管理后台已下线充值记录及储值管理：移除角色权限关联并禁用对应菜单。
| -- 菜单配置数据仍予以保留，便于未来恢复。
| DELETE FROM `sys_relation`
| WHERE `menuid` IN (248, 260);
|
| UPDATE `sys_menu`
| SET `status` = 0
| WHERE `id` IN (248, 260)
| OR `url` IN ('/finance/rechargeRecords', '/storeValueConfig');
|
| -- 回滚：
| -- UPDATE `sys_menu` SET `status` = 1 WHERE `id` IN (248, 260)
| -- OR `url` IN ('/finance/rechargeRecords', '/storeValueConfig');
| -- INSERT IGNORE INTO `sys_relation` (`menuid`, `roleid`) VALUES (248, 1), (260, 1);
|
|
