-- 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;