-- Migration 60_alter_partner_checks_add_return.sql
-- Add return columns and returned status support to partner_checks table

ALTER TABLE `partner_checks`
  ADD COLUMN `return_reason` VARCHAR(500) DEFAULT NULL AFTER `status_notes`,
  ADD COLUMN `returned_at` DATETIME DEFAULT NULL AFTER `processed_at`,
  ADD COLUMN `returned_by` INT UNSIGNED DEFAULT NULL AFTER `processed_by`,
  ADD COLUMN `return_voucher_id` CHAR(36) DEFAULT NULL AFTER `returned_by`;

ALTER TABLE `partner_checks`
  ADD KEY `idx_partner_checks_returned_at` (`returned_at`),
  ADD KEY `idx_partner_checks_return_voucher` (`return_voucher_id`);
