Sign in

pulls/pr_01m47d15m3e54sn21z27rpy5n9

public

pr_01m47d15m3e54sn21z27rpy5n9/services/actions/migrations/0001_init.sql

138 lines4,410 bytesCodeBlame
1-- GitHub Actions workflows on g1t: the workflows on each repository's
2-- default branch, their runs and jobs, the jobs' logs, and the secrets and
3-- variables they read. Every timestamp is RFC 3339 UTC.
4
5-- Workflows as they are on the default branch: for listing, schedules and
6-- manual runs. Runs for pushes and pull requests read the file at their
7-- own commit.
8CREATE TABLE workflows (
9 id TEXT PRIMARY KEY,
10 repo_id TEXT NOT NULL,
11 -- owner/name.
12 repo TEXT NOT NULL,
13 -- .github/workflows/ci.yml
14 path TEXT NOT NULL,
15 name TEXT NOT NULL,
16 source TEXT NOT NULL,
17 -- The events that start it, as a JSON array.
18 events TEXT NOT NULL,
19 -- Its schedules' cron lines, as a JSON array.
20 crons TEXT NOT NULL DEFAULT '[]',
21 error TEXT,
22 -- active or disabled; kept when the file changes.
23 state TEXT NOT NULL DEFAULT 'active',
24 -- How many runs it has had, for run numbers.
25 run_count INTEGER NOT NULL DEFAULT 0,
26 updated_at TEXT NOT NULL,
27 UNIQUE (repo_id, path)
28);
29CREATE INDEX workflows_scheduled ON workflows (state, crons);
30
31CREATE TABLE synced (
32 repo_id TEXT PRIMARY KEY,
33 at TEXT NOT NULL
34);
35
36CREATE TABLE runs (
37 id TEXT PRIMARY KEY,
38 workflow_id TEXT NOT NULL,
39 repo_id TEXT NOT NULL,
40 repo TEXT NOT NULL,
41 path TEXT NOT NULL,
42 name TEXT NOT NULL,
43 title TEXT NOT NULL,
44 number INTEGER NOT NULL,
45 attempt INTEGER NOT NULL DEFAULT 1,
46 -- The GitHub event and activity type.
47 event TEXT NOT NULL,
48 action TEXT,
49 git_ref TEXT NOT NULL,
50 sha TEXT NOT NULL,
51 pull INTEGER,
52 -- pending (waiting for its concurrency group), queued, in_progress, completed.
53 status TEXT NOT NULL,
54 conclusion TEXT,
55 -- Why the run could not start, such as a workflow file that does not read.
56 error TEXT,
57 actor TEXT,
58 actor_id TEXT,
59 -- The workflow file as of the run's commit.
60 source TEXT NOT NULL,
61 -- The github context's fields and the event's payload (RunInfo).
62 info TEXT NOT NULL,
63 -- workflow_dispatch inputs, as JSON.
64 inputs TEXT NOT NULL DEFAULT '{}',
65 -- 0 for a pull request from outside the workspace: its jobs get no
66 -- secrets and no token that can write.
67 trusted INTEGER NOT NULL DEFAULT 1,
68 concurrency_group TEXT,
69 -- What started it, so an event starts each workflow once.
70 event_key TEXT NOT NULL,
71 created_at TEXT NOT NULL,
72 started_at TEXT,
73 finished_at TEXT,
74 UNIQUE (repo_id, path, event_key)
75);
76CREATE INDEX runs_by_repo ON runs (repo_id, id);
77CREATE INDEX runs_by_workflow ON runs (workflow_id, id);
78CREATE INDEX runs_by_status ON runs (status);
79CREATE INDEX runs_by_group ON runs (repo_id, concurrency_group, status);
80CREATE INDEX runs_by_sha ON runs (repo_id, sha);
81
82CREATE TABLE jobs (
83 id TEXT PRIMARY KEY,
84 run_id TEXT NOT NULL,
85 repo_id TEXT NOT NULL,
86 -- The workspace, for its limit on jobs running at once.
87 namespace TEXT NOT NULL,
88 -- Its key under jobs:, and which matrix combination it is (0 without one).
89 key TEXT NOT NULL,
90 ordinal INTEGER NOT NULL DEFAULT 0,
91 name TEXT NOT NULL,
92 needs TEXT NOT NULL DEFAULT '[]',
93 -- The matrix combination, as JSON; null until it is expanded.
94 matrix TEXT,
95 -- waiting (for its needs), queued, in_progress, completed.
96 status TEXT NOT NULL,
97 conclusion TEXT,
98 steps TEXT NOT NULL DEFAULT '[]',
99 annotations TEXT NOT NULL DEFAULT '[]',
100 outputs TEXT NOT NULL DEFAULT '{}',
101 reason TEXT,
102 token_hash TEXT,
103 timeout_minutes INTEGER NOT NULL DEFAULT 60,
104 -- continue-on-error: a failure that does not fail the run.
105 continue_on_error INTEGER NOT NULL DEFAULT 0,
106 -- strategy.max-parallel: how many of its matrix may run at once.
107 max_parallel INTEGER,
108 -- The last time its sandbox reported anything.
109 seen_at TEXT,
110 started_at TEXT,
111 finished_at TEXT
112);
113CREATE INDEX jobs_by_run ON jobs (run_id, key, ordinal);
114CREATE INDEX jobs_by_status ON jobs (status, namespace);
115
116CREATE TABLE logs (
117 job_id TEXT NOT NULL,
118 seq INTEGER NOT NULL,
119 step INTEGER NOT NULL,
120 text TEXT NOT NULL,
121 PRIMARY KEY (job_id, seq)
122);
123
124-- Secrets and variables, a repository's or a workspace's. A secret's value
125-- is sealed, bound to its row's id.
126CREATE TABLE settings (
127 id TEXT PRIMARY KEY,
128 -- repository or workspace.
129 scope TEXT NOT NULL,
130 -- The repository's id, or the workspace's slug.
131 owner TEXT NOT NULL,
132 -- secret or variable.
133 kind TEXT NOT NULL,
134 name TEXT NOT NULL,
135 value TEXT NOT NULL,
136 updated_at TEXT NOT NULL,
137 UNIQUE (owner, kind, name)
138);