-- Flow priorities (oxygenhub#244): a repository's and an organisation's

-- level ('' to inherit: low, normal, high), and a run's own, set only by

-- expediting it (urgent), with who did it and why.

ALTER TABLE repositories ADD COLUMN flow_priority TEXT NOT NULL DEFAULT '';

ALTER TABLE organisations ADD COLUMN flow_priority TEXT NOT NULL DEFAULT '';

ALTER TABLE flow_runs ADD COLUMN priority TEXT NOT NULL DEFAULT '';

ALTER TABLE flow_runs ADD COLUMN priority_note TEXT NOT NULL DEFAULT '';