sqxp/docs/sql/migration_20260408_biz_order_cancel_status.sql

-- 取消审核流程字段（阶段D收尾）
-- 新增字段：cancel_status

ALTER TABLE `biz_order`
  ADD COLUMN `cancel_status` varchar(20) NOT NULL DEFAULT 'none'
  COMMENT '取消审核状态: none/pending_review/approved/rejected'
  AFTER `pay_status`;

ALTER TABLE `biz_order_his`
  ADD COLUMN `cancel_status` varchar(20) NOT NULL DEFAULT 'none'
  COMMENT '取消审核状态: none/pending_review/approved/rejected'
  AFTER `pay_status`;

-- 可选回填：将历史 pending_review_cancel 映射为 pending_review
-- UPDATE `biz_order`
-- SET `cancel_status` = CASE WHEN `status` = 'pending_review_cancel' THEN 'pending_review' ELSE 'none' END;