source/sphenixprod/add_qa_job_columns.sql

0001 -- Apply to existing production_jobs before submitting rules with qadbtag.
0002 ALTER TABLE production_jobs ADD COLUMN IF NOT EXISTS qa_tag TEXT;
0003 ALTER TABLE production_jobs ADD COLUMN IF NOT EXISTS qa_filename TEXT;
0004 ALTER TABLE production_jobs ADD COLUMN IF NOT EXISTS qa_status TEXT;
0005 ALTER TABLE production_jobs ADD COLUMN IF NOT EXISTS qa_exit_code INT;
0006 ALTER TABLE production_jobs DROP CONSTRAINT IF EXISTS production_jobs_qa_status_check;
0007 ALTER TABLE production_jobs ADD CONSTRAINT production_jobs_qa_status_check
0008     CHECK (qa_status IN ('pending', 'succeeded', 'failed', 'missing')) NOT VALID;
0009
0010 -- Run separately during a suitable window if a validated constraint is desired:
0011 -- ALTER TABLE production_jobs VALIDATE CONSTRAINT production_jobs_qa_status_check;