-- 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`. SQLite cannot change a

-- CHECK constraint in place, so flow_runs is rebuilt as in 0033 (with

-- foreign keys off during migrations, its jobs and reports stay).

CREATE TABLE flow_runs_new (

    id            INTEGER PRIMARY KEY,

    repo_id       INTEGER NOT NULL REFERENCES repositories(id) ON DELETE CASCADE,

    bookmark      TEXT NOT NULL,

    -- The bookmark's state hash (checks are keyed by it) and its heads, joined with '+'.

    state         TEXT NOT NULL,

    heads         TEXT NOT NULL,

    pipeline_hash TEXT NOT NULL DEFAULT '',

    status        TEXT NOT NULL CHECK (status IN ('queued', 'running', 'passed', 'failed', 'error', 'cancelled', 'skipped')),

    -- Pipeline problems, one per line, for a run in error; why, for a skipped one.

    error         TEXT NOT NULL DEFAULT '',

    actor         TEXT NOT NULL DEFAULT '',

    created_ms    INTEGER NOT NULL,

    finished_ms   INTEGER,

    number        INTEGER NOT NULL DEFAULT 0,

    trigger       TEXT NOT NULL DEFAULT 'push',

    priority      TEXT NOT NULL DEFAULT '',

    priority_note TEXT NOT NULL DEFAULT ''

);

INSERT INTO flow_runs_new (id, repo_id, bookmark, state, heads, pipeline_hash, status, error, actor, created_ms, finished_ms, number, trigger, priority, priority_note)

    SELECT id, repo_id, bookmark, state, heads, pipeline_hash, status, error, actor, created_ms, finished_ms, number, trigger, priority, priority_note FROM flow_runs;

DROP TABLE flow_runs;

ALTER TABLE flow_runs_new RENAME TO flow_runs;

CREATE INDEX flow_runs_by_repo ON flow_runs (repo_id, id DESC);

CREATE UNIQUE INDEX flow_runs_number ON flow_runs (repo_id, number);