-- migration-version: 20260908_151000_RECLASSIFY_LEGACY_PARTIAL_REFUNDS
USE `tour_guide`;

-- 旧逻辑会将任意成功退款标记为全额退款；按实付金额纠正历史部分退款订单。
UPDATE `tour_order`
SET `refund_status` = 'PARTIAL',
    `status` = 'CANCELLED'
WHERE (`status` = 'REFUNDED' OR `refund_status` = 'REFUNDED')
  AND `payment_time` IS NOT NULL
  AND `refunded_amount` < COALESCE(`payment_amount`, `amount`, 0);

INSERT INTO `sys_schema_migration` (`version`, `description`)
VALUES ('20260908_151000_RECLASSIFY_LEGACY_PARTIAL_REFUNDS', 'reclassify legacy partial refunds marked as fully refunded');