OXYGENHUB
# fbd7c8551932 oxygenhub / crates / hub / migrations-pg / 0073_flow_priority.sql
493 B · SQL · last changed Flow priorities: site, organisation and repository levels, and expediting a run 19 days ago source blame history raw
107eaba5 Andy McCall ↶ 1 
-- Flow priorities (oxygenhub#244): a repository's and an organisation's
2 
-- level ('' to inherit: low, normal, high), and a run's own, set only by
3 
-- expediting it (urgent), with who did it and why.
4 
ALTER TABLE repositories ADD COLUMN flow_priority TEXT NOT NULL DEFAULT '';
5 
ALTER TABLE organisations ADD COLUMN flow_priority TEXT NOT NULL DEFAULT '';
6 
ALTER TABLE flow_runs ADD COLUMN priority TEXT NOT NULL DEFAULT '';
7 
ALTER TABLE flow_runs ADD COLUMN priority_note TEXT NOT NULL DEFAULT '';