-- 分账订单「已结案(线下处理)」：停止重试、后台与核验脚本可识别
-- 执行前请将 fa_ 替换为实际表前缀

ALTER TABLE `fa_shopro_split_order`
  MODIFY COLUMN `status` tinyint(1) NOT NULL DEFAULT 0
    COMMENT '0=待分账,1=分账中,2=成功,3=部分成功,4=失败,5=已结案(线下处理)';

ALTER TABLE `fa_shopro_split_order`
  ADD COLUMN `close_reason` varchar(255) DEFAULT NULL COMMENT '结案原因' AFTER `wx_result`,
  ADD COLUMN `close_admin_id` int(11) NOT NULL DEFAULT 0 COMMENT '结案操作管理员' AFTER `close_reason`,
  ADD COLUMN `closetime` int(10) DEFAULT NULL COMMENT '结案时间' AFTER `close_admin_id`;

ALTER TABLE `fa_shopro_split_manual_log`
  MODIFY COLUMN `action` enum('create','update','clear','retry','close') NOT NULL DEFAULT 'update' COMMENT '操作类型';