Query
CREATE TABLE jobs (
id TEXT PRIMARY KEY,
job_type TEXT NOT NULL,
params TEXT,
status TEXT NOT NULL CHECK (status IN ('queued','leased','running','done','failed','dead')),
run_at TEXT NOT NULL,
lease_expires_at TEXT,
attempts INTEGER DEFAULT 0,
max_attempts INTEGER DEFAULT 5,
last_error TEXT,
created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now'))
)