-- Runners (hub spec §13.2): registered from the UI with a one-time token,

-- or configured with a hub.toml token (tracked here from their first

-- claim). A runner signs receipts with one key: bound at registration, or

-- on the first signed receipt of a configured runner.

CREATE TABLE flow_runners (

    id INTEGER PRIMARY KEY,

    name TEXT NOT NULL,

    token_hash TEXT NOT NULL UNIQUE,

    -- 'registered' or 'config'

    source TEXT NOT NULL,

    key TEXT NOT NULL DEFAULT '',

    key_name TEXT NOT NULL DEFAULT '',

    arch TEXT NOT NULL DEFAULT '',

    os TEXT NOT NULL DEFAULT '',

    version TEXT NOT NULL DEFAULT '',

    -- comma-separated

    labels TEXT NOT NULL DEFAULT '',

    max_jobs INTEGER NOT NULL DEFAULT 1,

    memory_mib INTEGER,

    cpus INTEGER,

    -- 'active', 'draining' (finishes its jobs, claims no more) or 'disabled'

    state TEXT NOT NULL DEFAULT 'active',

    created_ms INTEGER NOT NULL,

    created_by TEXT NOT NULL DEFAULT '',

    last_seen_ms INTEGER

);

-- Keys already bound to configured runners move over.

INSERT INTO flow_runners (name, token_hash, source, key, key_name, created_ms)

    SELECT name, token_hash, 'config', key, name, first_ms FROM flow_runner_keys;

CREATE TABLE flow_runner_registrations (

    token_hash TEXT PRIMARY KEY,

    created_by TEXT NOT NULL,

    created_ms INTEGER NOT NULL,

    expires_ms INTEGER NOT NULL,

    used_ms INTEGER,

    runner_id INTEGER

);

ALTER TABLE flow_jobs ADD COLUMN runner_id INTEGER;

CREATE INDEX flow_jobs_runner ON flow_jobs(runner_id);