-- Images by hash (oxygenflow#39, Jetstream): rootfs images this hub keeps

-- for runners to fetch, as chunks under <data>/images and a manifest each.

CREATE TABLE jet_images (

    hash        TEXT PRIMARY KEY,

    size        INTEGER NOT NULL,

    arch        TEXT NOT NULL,

    chunks      INTEGER NOT NULL,

    uploader    TEXT NOT NULL,

    created_ms  INTEGER NOT NULL

);

-- Whether a runner fetches a job's image it lacks from the hub, as its

-- claims say; the placement pass counts the hub's images as its own then.

ALTER TABLE flow_runners ADD COLUMN fetches_images INTEGER NOT NULL DEFAULT 0;