OXYGENHUB
# e5b97ac399e7 oxygenhub / crates / hub / migrations / 0070_flow_approvals.sql
409 B · SQL · last changed Approval gates: a job waits for a person with the role 20 days ago source blame history raw
1 
-- Approval gates (oxygenflow#57): a job whose pipeline asks for approval
2 
-- waits ('waiting') until someone with the role approves it ('approved');
3 
-- '' for a job that needs none. Who and when are kept on the job.
4 
ALTER TABLE flow_jobs ADD COLUMN approval TEXT NOT NULL DEFAULT '';
5 
ALTER TABLE flow_jobs ADD COLUMN approved_by TEXT NOT NULL DEFAULT '';
6 
ALTER TABLE flow_jobs ADD COLUMN approved_ms INTEGER;