-- Approval gates (oxygenflow#57): a job whose pipeline asks for approval

-- waits ('waiting') until someone with the role approves it ('approved');

-- '' for a job that needs none. Who and when are kept on the job.

ALTER TABLE flow_jobs ADD COLUMN approval TEXT NOT NULL DEFAULT '';

ALTER TABLE flow_jobs ADD COLUMN approved_by TEXT NOT NULL DEFAULT '';

ALTER TABLE flow_jobs ADD COLUMN approved_ms INTEGER;