shanxia2.0/docs/sql/migrate_void_cancel_reason_20260930.sql

-- 作废/取消可选原因独立字段（void-cancel-reason-required）
-- 2026-09-30
-- 原因可空；作废成功时仍写 time/by

-- CRM 报价单
ALTER TABLE `crm_quote`
  ADD COLUMN `invalid_reason` varchar(500) DEFAULT NULL COMMENT '作废原因' AFTER `version_no`,
  ADD COLUMN `invalid_time` datetime DEFAULT NULL COMMENT '作废时间' AFTER `invalid_reason`,
  ADD COLUMN `invalid_by` varchar(64) DEFAULT NULL COMMENT '作废人ID' AFTER `invalid_time`;

-- 运输计划
ALTER TABLE `pl_plan`
  ADD COLUMN `cancel_reason` varchar(500) DEFAULT NULL COMMENT '作废原因' AFTER `erp_entered`,
  ADD COLUMN `cancel_time` datetime DEFAULT NULL COMMENT '作废时间' AFTER `cancel_reason`,
  ADD COLUMN `cancel_by` varchar(64) DEFAULT NULL COMMENT '作废人ID' AFTER `cancel_time`;

-- 加油登记
ALTER TABLE `pl_vehicle_fuel_register`
  ADD COLUMN `cancel_reason` varchar(500) DEFAULT NULL COMMENT '作废原因' AFTER `status`,
  ADD COLUMN `cancel_time` datetime DEFAULT NULL COMMENT '作废时间' AFTER `cancel_reason`,
  ADD COLUMN `cancel_by` varchar(64) DEFAULT NULL COMMENT '作废人ID' AFTER `cancel_time`;

-- 充值申请
ALTER TABLE `pl_vehicle_recharge_apply`
  ADD COLUMN `cancel_reason` varchar(500) DEFAULT NULL COMMENT '作废原因' AFTER `status`,
  ADD COLUMN `cancel_time` datetime DEFAULT NULL COMMENT '作废时间' AFTER `cancel_reason`,
  ADD COLUMN `cancel_by` varchar(64) DEFAULT NULL COMMENT '作废人ID' AFTER `cancel_time`;

-- 维保申请
ALTER TABLE `pl_vehicle_maintenance_apply`
  ADD COLUMN `cancel_reason` varchar(500) DEFAULT NULL COMMENT '作废原因' AFTER `status`,
  ADD COLUMN `cancel_time` datetime DEFAULT NULL COMMENT '作废时间' AFTER `cancel_reason`,
  ADD COLUMN `cancel_by` varchar(64) DEFAULT NULL COMMENT '作废人ID' AFTER `cancel_time`;

-- 尿素申请
ALTER TABLE `pl_vehicle_urea_apply`
  ADD COLUMN `cancel_reason` varchar(500) DEFAULT NULL COMMENT '作废原因' AFTER `status`,
  ADD COLUMN `cancel_time` datetime DEFAULT NULL COMMENT '作废时间' AFTER `cancel_reason`,
  ADD COLUMN `cancel_by` varchar(64) DEFAULT NULL COMMENT '作废人ID' AFTER `cancel_time`;

-- 运费结算
ALTER TABLE `pl_freight_settlement`
  ADD COLUMN `cancel_reason` varchar(500) DEFAULT NULL COMMENT '作废原因' AFTER `settlement_status`,
  ADD COLUMN `cancel_time` datetime DEFAULT NULL COMMENT '作废时间' AFTER `cancel_reason`,
  ADD COLUMN `cancel_by` varchar(64) DEFAULT NULL COMMENT '作废人ID' AFTER `cancel_time`;

-- 地磅单
ALTER TABLE `db_weighing_slip`
  ADD COLUMN `void_reason` varchar(500) DEFAULT NULL COMMENT '作废原因' AFTER `is_voided`,
  ADD COLUMN `void_time` datetime DEFAULT NULL COMMENT '作废时间' AFTER `void_reason`,
  ADD COLUMN `void_by` varchar(64) DEFAULT NULL COMMENT '作废人ID' AFTER `void_time`;