supabase/migrations/20260628_add_progress_step.sql

-- Add progress_step to submissions for user-facing pipeline tracking.
-- Values: 1=Submitted, 2=Reading your paper, 3=Researching the literature,
--         4=Drafting review, 5=Review ready
ALTER TABLE submissions
  ADD COLUMN IF NOT EXISTS progress_step smallint DEFAULT 1;