| 1234567891011121314151617181920212223242526272829 |
- -- 下线「订单调整」菜单:由订单详情弹窗内调整替代
- -- 影响菜单:sys_menu.code = 'order_adjust'(id: 10000000000000000000000000000022)
- -- 执行后效果:菜单不再展示,不再参与可用菜单数据
- START TRANSACTION;
- UPDATE `sys_menu`
- SET
- `is_del` = 1,
- `is_active` = 0,
- `is_visible` = 0,
- `update_at` = NOW(),
- `update_by` = 'system'
- WHERE `code` = 'order_adjust'
- AND `is_del` = 0;
- COMMIT;
- -- 回滚 SQL(按需执行)
- -- START TRANSACTION;
- -- UPDATE `sys_menu`
- -- SET
- -- `is_del` = 0,
- -- `is_active` = 1,
- -- `is_visible` = 1,
- -- `update_at` = NOW(),
- -- `update_by` = 'system'
- -- WHERE `code` = 'order_adjust';
- -- COMMIT;
|