OXYGENHUB
# 794ff94f194a oxygenhub / crates / hub / migrations / 0043_flow_declines.sql
967 B · SQL · last changed Runners decline, and the queue says why a job waits 1 month ago source blame history raw
4d2e44d7 Andy McCall ↶ 1 
-- Placement you can see (OxygenFlow spec §11.4–11.5, oxygenflow#36): what
2 
-- each runner offers at its last claim, the jobs runners handed back with
3 
-- a reason, and why a queued job waits.
4 
ALTER TABLE flow_runners ADD COLUMN tiers TEXT NOT NULL DEFAULT '';
5 
-- JSON array of image hashes; empty when the runner did not say.
6 
ALTER TABLE flow_runners ADD COLUMN images TEXT NOT NULL DEFAULT '';
7 
-- BLAKE3 of what it offers: a decline holds until this changes.
8 
ALTER TABLE flow_runners ADD COLUMN profile TEXT NOT NULL DEFAULT '';
9 
ALTER TABLE flow_jobs ADD COLUMN waiting TEXT NOT NULL DEFAULT '';
10 
CREATE TABLE flow_declines (
11 
    job_id     INTEGER NOT NULL REFERENCES flow_jobs(id) ON DELETE CASCADE,
12 
    runner_id  INTEGER NOT NULL,
13 
    runner     TEXT NOT NULL,
14 
    profile    TEXT NOT NULL,
15 
    reason     TEXT NOT NULL,
16 
    ms         INTEGER NOT NULL,
17 
    PRIMARY KEY (job_id, runner_id)
18 
);
19 
CREATE INDEX flow_declines_runner ON flow_declines (runner_id, ms);