g1t/services/repos/migrations/0001_init.sql
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.
| Initial g1t: services, event bus, intents and attempts | 1 | -- Stored in Artifacts as "<namespace>--<name>". |
| 2 | CREATE TABLE repos ( | |
| 3 | id TEXT PRIMARY KEY, | |
| 4 | namespace TEXT NOT NULL, | |
| 5 | name TEXT NOT NULL, | |
| 6 | description TEXT, | |
| 7 | is_private INTEGER NOT NULL DEFAULT 0, | |
| 8 | owner_id TEXT NOT NULL, | |
| 9 | default_branch TEXT NOT NULL DEFAULT 'main', | |
| 10 | -- Set on an attempt's working copy; those are hidden from listings. | |
| 11 | fork_of TEXT REFERENCES repos (id), | |
| 12 | created_at INTEGER NOT NULL DEFAULT (unixepoch()), | |
| 13 | UNIQUE (namespace, name) | |
| 14 | ); | |
| 15 | CREATE INDEX repos_owner ON repos (owner_id); |