Sign in

flagon-io/g1t

public

g1t/services/work/migrations/0001_init.sql

91 lines2,641 bytesCodeBlame

Pick any line to see why it is the way it is: the commit, the pull request and issue it came from, and what the agent was thinking.

Issues and pull requests replace intents and attempts1-- Issues, pull requests, comments and sessions.
2-- Every timestamp is RFC 3339 UTC text.
3
4-- Issues and pull requests share one sequence of numbers per repository.
5CREATE TABLE counters (
6 repo_id TEXT PRIMARY KEY,
7 last INTEGER NOT NULL
8);
9
10CREATE TABLE issues (
Initial g1t: services, event bus, intents and attempts11 id TEXT PRIMARY KEY,
12 repo_id TEXT NOT NULL,
13 number INTEGER NOT NULL,
14 title TEXT NOT NULL,
Issues and pull requests replace intents and attempts15 body TEXT NOT NULL,
16 -- JSON array of label names.
17 labels TEXT NOT NULL DEFAULT '[]',
Initial g1t: services, event bus, intents and attempts18 -- JSON array of commands.
19 checks TEXT NOT NULL DEFAULT '[]',
Issues and pull requests replace intents and attempts20 state TEXT NOT NULL DEFAULT 'open',
21 -- Why it was closed: completed or not_planned.
22 reason TEXT,
23 -- The number of the pull request whose merge closed it.
24 resolved_by INTEGER,
Initial g1t: services, event bus, intents and attempts25 author_id TEXT NOT NULL,
26 author_name TEXT NOT NULL,
Issues and pull requests replace intents and attempts27 created_at TEXT NOT NULL,
28 updated_at TEXT NOT NULL,
29 closed_at TEXT,
Initial g1t: services, event bus, intents and attempts30 UNIQUE (repo_id, number)
31);
Issues and pull requests replace intents and attempts32CREATE INDEX issues_by_state ON issues (repo_id, state, number);
Initial g1t: services, event bus, intents and attempts33
Issues and pull requests replace intents and attempts34CREATE TABLE pulls (
Initial g1t: services, event bus, intents and attempts35 id TEXT PRIMARY KEY,
36 repo_id TEXT NOT NULL,
37 number INTEGER NOT NULL,
Issues and pull requests replace intents and attempts38 -- The issue it is for, if any, and that issue's number.
39 issue_id TEXT REFERENCES issues (id),
40 issue_number INTEGER,
41 title TEXT NOT NULL,
42 body TEXT,
Initial g1t: services, event bus, intents and attempts43 agent TEXT NOT NULL,
44 runtime TEXT NOT NULL,
Issues and pull requests replace intents and attempts45 status TEXT NOT NULL DEFAULT 'draft',
Pull requests from branches46 -- Where the change is: a fork made for the pull request, or a branch of
47 -- the repository itself.
48 fork_repo_id TEXT UNIQUE,
49 fork_namespace TEXT,
50 fork_name TEXT,
51 source_branch TEXT,
Initial g1t: services, event bus, intents and attempts52 head_commit TEXT,
Issues and pull requests replace intents and attempts53 -- What the branch pointed to before a merged pull request landed.
54 merge_base TEXT,
55 merged_by TEXT,
56 merged_at TEXT,
57 -- The pull request merged instead of this one.
58 superseded_by INTEGER,
59 author_id TEXT NOT NULL,
60 author_name TEXT NOT NULL,
61 created_at TEXT NOT NULL,
62 updated_at TEXT NOT NULL,
63 UNIQUE (repo_id, number)
Initial g1t: services, event bus, intents and attempts64);
Issues and pull requests replace intents and attempts65CREATE INDEX pulls_by_status ON pulls (repo_id, status, number);
66CREATE INDEX pulls_by_issue ON pulls (issue_id);
67CREATE INDEX pulls_by_author ON pulls (author_id, status);
Initial g1t: services, event bus, intents and attempts68
Issues and pull requests replace intents and attempts69-- On an issue or a pull request: the two share numbers.
70CREATE TABLE comments (
71 id TEXT PRIMARY KEY,
72 repo_id TEXT NOT NULL,
73 number INTEGER NOT NULL,
74 author_id TEXT NOT NULL,
75 author_name TEXT NOT NULL,
76 body TEXT NOT NULL,
77 created_at TEXT NOT NULL
78);
79CREATE INDEX comments_by_subject ON comments (repo_id, number, id);
80
Initial g1t: services, event bus, intents and attempts81CREATE TABLE session_entries (
Issues and pull requests replace intents and attempts82 pull_id TEXT NOT NULL REFERENCES pulls (id),
Initial g1t: services, event bus, intents and attempts83 seq INTEGER NOT NULL,
84 kind TEXT NOT NULL,
85 text TEXT NOT NULL,
86 tool TEXT,
87 -- The fork's head when the entry was recorded: links reasoning to code.
88 "commit" TEXT,
Issues and pull requests replace intents and attempts89 at TEXT NOT NULL,
90 PRIMARY KEY (pull_id, seq)
Initial g1t: services, event bus, intents and attempts91);