-- Pushing without a run (oxygenhub#284): `[skip flow]`, `[skip ci]` or

-- `[ci skip]` in the newest pushed change's message records a skipped run

-- instead of starting jobs. Where a maintainer allows it: `any` bookmark

-- (the default), `others` than the default bookmark, or `never`.

ALTER TABLE repositories ADD COLUMN flow_skip TEXT NOT NULL DEFAULT 'any';

-- A skipped run is recorded with status `skipped`.

ALTER TABLE flow_runs DROP CONSTRAINT flow_runs_status_check;

ALTER TABLE flow_runs ADD CONSTRAINT flow_runs_status_check

    CHECK (status IN ('queued', 'running', 'passed', 'failed', 'error', 'cancelled', 'skipped'));