-- Variables for OxygenFlow jobs (hub spec §13.2, #102), per level: the

-- site (scope_id 0), an organisation or a repository. A job gets its

-- repository's effective set, inner levels overriding outer. Not secrets:

-- those are mounted by Flow (OxygenFlow spec §9), never put in the

-- environment.

CREATE TABLE flow_variables (

    scope       TEXT NOT NULL CHECK (scope IN ('site', 'org', 'repo')),

    scope_id    INTEGER NOT NULL DEFAULT 0,

    name        TEXT NOT NULL,

    value       TEXT NOT NULL,

    updated_ms  INTEGER NOT NULL,

    PRIMARY KEY (scope, scope_id, name)

);