-- =====================================================================
-- Migration: Appeal Scenario Metadata
-- Date: 2026-08-23
-- Description: Adds a `metadata` JSON column to the Appeal table to support
--              scenario-based appeals (BUYER_PAYMENT_ISSUE,
--              SELLER_PAYMENT_NOT_RECEIVED, BALANCE_DEDUCTION_DISPUTE,
--              REFERRAL_FREEZE_DISPUTE, OTHER) and suspicious-pattern flags.
-- =====================================================================

ALTER TABLE `Appeal` ADD COLUMN IF NOT EXISTS `metadata` JSON NULL AFTER `admin_message`;

CREATE INDEX IF NOT EXISTS `idx_appeal_metadata` ON `Appeal` (`metadata`);