2026-09-12-pl-vehicle-recharge-etc-only.sql 842 B

12345678910111213141516171819202122232425
  1. -- 车辆充值模块收窄为仅 ETC:菜单改名 + 加油字典软停用(不删业务数据)
  2. -- Spec: docs/superpowers/specs/2026-09-12-pl-vehicle-recharge-etc-only-design.md
  3. UPDATE sys_menu
  4. SET menu_name = 'ETC充值申请',
  5. update_time = NOW()
  6. WHERE id = 'PL_VEH_RECHARGE_APPLY'
  7. AND del_flag = 0;
  8. UPDATE sys_menu
  9. SET menu_name = 'ETC充值发放登记',
  10. update_time = NOW()
  11. WHERE id = 'PL_VEH_RECHARGE_RECORD'
  12. AND del_flag = 0;
  13. UPDATE sys_dict_data
  14. SET del_flag = 1,
  15. remark = 'ETC模块收窄:加油选项停用,业务数据保留待新加油模块',
  16. update_time = NOW()
  17. WHERE id = 'PL_RECHARGE_TYPE_FUEL'
  18. AND del_flag = 0;
  19. -- 可选知情统计(只读,不写入变更):
  20. -- SELECT COUNT(*) FROM pl_vehicle_recharge_apply
  21. -- WHERE del_flag = 0 AND recharge_type = 'fuel' AND status = 'pending';