migration_20260414_sys_menu_remove_order_adjust.sql 688 B

1234567891011121314151617181920212223242526272829
  1. -- 下线「订单调整」菜单:由订单详情弹窗内调整替代
  2. -- 影响菜单:sys_menu.code = 'order_adjust'(id: 10000000000000000000000000000022)
  3. -- 执行后效果:菜单不再展示,不再参与可用菜单数据
  4. START TRANSACTION;
  5. UPDATE `sys_menu`
  6. SET
  7. `is_del` = 1,
  8. `is_active` = 0,
  9. `is_visible` = 0,
  10. `update_at` = NOW(),
  11. `update_by` = 'system'
  12. WHERE `code` = 'order_adjust'
  13. AND `is_del` = 0;
  14. COMMIT;
  15. -- 回滚 SQL(按需执行)
  16. -- START TRANSACTION;
  17. -- UPDATE `sys_menu`
  18. -- SET
  19. -- `is_del` = 0,
  20. -- `is_active` = 1,
  21. -- `is_visible` = 1,
  22. -- `update_at` = NOW(),
  23. -- `update_by` = 'system'
  24. -- WHERE `code` = 'order_adjust';
  25. -- COMMIT;