Skip to content
8 linesCodeBlameRaw
1-- The agent run a task handed to a self-hosted runner belongs to, so the
2-- Runners page can link a runner's agent work to it and leave it out of
3-- what runs on g1t's cloud. Null for tasks handed over before this.
4ALTER TABLE runner_tasks ADD COLUMN run_id TEXT;
5
6-- What runs in g1t's sandboxes for a workspace now, for the Runners page:
7-- jobs without labels, by the lowercased workspace and status.
8CREATE INDEX IF NOT EXISTS jobs_cloud_lower ON jobs (lower(namespace), status) WHERE labels IS NULL;