-- A job's artifacts (OxygenFlow spec §5.2): each kept as a blob of the

-- run's repository, with its size and the BLAKE3 of its bytes, which is

-- how a release asset finds the receipt that built it.

CREATE TABLE flow_artifacts (

    job_id INTEGER NOT NULL REFERENCES flow_jobs(id) ON DELETE CASCADE,

    name TEXT NOT NULL,

    path TEXT NOT NULL,

    blob TEXT NOT NULL,

    size INTEGER NOT NULL,

    content TEXT NOT NULL,

    created_ms INTEGER NOT NULL,

    PRIMARY KEY (job_id, name)

);

CREATE INDEX flow_artifacts_content ON flow_artifacts(content);