AkurAI-Build / migrations/003_workers.sql

Latest change 30e6b8c347048d64c2c048dfd05a8ded219d37f6 - Host authenticated Git repositories over Smart HTTP with repo host/sync CLI by Ólafur Búi Ólafsson

CREATE TABLE workers (
    id TEXT PRIMARY KEY CHECK (length(id) BETWEEN 1 AND 64),
    host TEXT NOT NULL CHECK (length(host) BETWEEN 1 AND 128),
    capabilities TEXT NOT NULL,
    status TEXT NOT NULL CHECK (status IN ('starting', 'idle', 'running', 'offline')),
    capacity INTEGER NOT NULL CHECK (capacity BETWEEN 1 AND 16),
    current_run_id INTEGER,
    started_at INTEGER NOT NULL,
    heartbeat_at INTEGER NOT NULL,
    completed_runs INTEGER NOT NULL DEFAULT 0 CHECK (completed_runs >= 0)
) STRICT;

CREATE INDEX workers_heartbeat ON workers(heartbeat_at);
PRAGMA user_version = 3;