-- Coverage uploaded from a workstation (oxygenhub#136): a report with no

-- Flow run or job behind it, made by `oh coverage upload`, naming who

-- uploaded it, so a runner's figure and an upload's cannot be mistaken

-- for each other. SQLite cannot drop NOT NULL, so both tables are rebuilt

-- (migrations run with foreign keys off).

CREATE TABLE coverage_reports_new (

    id               INTEGER PRIMARY KEY,

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

    run_id           INTEGER REFERENCES flow_runs(id) ON DELETE CASCADE,

    job_id           INTEGER UNIQUE,

    job              TEXT NOT NULL,

    run_number       INTEGER NOT NULL,

    bookmark         TEXT NOT NULL,

    state            TEXT NOT NULL,

    heads            TEXT NOT NULL,

    blob             TEXT NOT NULL,

    format           TEXT NOT NULL,

    lines_found      INTEGER NOT NULL,

    lines_hit        INTEGER NOT NULL,

    functions_found  INTEGER NOT NULL,

    functions_hit    INTEGER NOT NULL,

    branches_found   INTEGER NOT NULL,

    branches_hit     INTEGER NOT NULL,

    hits             INTEGER NOT NULL DEFAULT 0,

    files            INTEGER NOT NULL,

    dropped          INTEGER NOT NULL,

    created_ms       INTEGER NOT NULL,

    -- Who uploaded it; empty for a Flow job's report.

    uploader         TEXT NOT NULL DEFAULT ''

);

INSERT INTO coverage_reports_new (id, repo_id, run_id, job_id, job, run_number, bookmark, state, heads, blob, format,

    lines_found, lines_hit, functions_found, functions_hit, branches_found, branches_hit, hits, files, dropped, created_ms)

SELECT id, repo_id, run_id, job_id, job, run_number, bookmark, state, heads, blob, format,

    lines_found, lines_hit, functions_found, functions_hit, branches_found, branches_hit, hits, files, dropped, created_ms

FROM coverage_reports;

CREATE TABLE coverage_files_new (

    report_id        INTEGER NOT NULL REFERENCES coverage_reports_new(id) ON DELETE CASCADE,

    path             TEXT NOT NULL,

    lines_found      INTEGER NOT NULL,

    lines_hit        INTEGER NOT NULL,

    functions_found  INTEGER NOT NULL,

    functions_hit    INTEGER NOT NULL,

    branches_found   INTEGER NOT NULL,

    branches_hit     INTEGER NOT NULL,

    PRIMARY KEY (report_id, path)

);

INSERT INTO coverage_files_new SELECT * FROM coverage_files;

DROP TABLE coverage_files;

DROP TABLE coverage_reports;

ALTER TABLE coverage_reports_new RENAME TO coverage_reports;

ALTER TABLE coverage_files_new RENAME TO coverage_files;

CREATE INDEX coverage_reports_bookmark ON coverage_reports (repo_id, bookmark, created_ms);