-- ── Feature 2: Order Refund/Cancel ──────────────────────────
ALTER TABLE `shop_orders`
  ADD COLUMN IF NOT EXISTS `refund_note` VARCHAR(255) DEFAULT NULL AFTER `sms_sent`,
  ADD COLUMN IF NOT EXISTS `refunded_at` TIMESTAMP NULL DEFAULT NULL AFTER `refund_note`;