touchskyer/dw-billfighter

1-- BillFighter DAT Upgrade: Case tracking migration2-- Run AFTER the base migration.sql3 4-- Add case tracking columns to fight_results5ALTER TABLE public.fight_results6  ADD COLUMN IF NOT EXISTS recipient_email TEXT,7  ADD COLUMN IF NOT EXISTS case_status TEXT DEFAULT 'draft',  -- draft | sent | waiting | resolved8  ADD COLUMN IF NOT EXISTS resolution TEXT,  -- won | partial | denied | pending9  ADD COLUMN IF NOT EXISTS savings NUMERIC(10,2),10  ADD COLUMN IF NOT EXISTS sent_at TIMESTAMPTZ,11  ADD COLUMN IF NOT EXISTS resolved_at TIMESTAMPTZ,12  ADD COLUMN IF NOT EXISTS updated_at TIMESTAMPTZ DEFAULT now();13 14-- Add updated_at trigger15DROP TRIGGER IF EXISTS set_updated_at_fight_results ON public.fight_results;16CREATE TRIGGER set_updated_at_fight_results17  BEFORE UPDATE ON public.fight_results18  FOR EACH ROW EXECUTE FUNCTION public.update_updated_at();19 20-- Index for case status queries21CREATE INDEX IF NOT EXISTS idx_fight_results_status ON public.fight_results(user_id, case_status);22 23-- Allow backend (service key) to update fight_results for case status changes24-- RLS already blocks direct anon writes25