pr_01m47d15m3e54sn21z27rpy5n9/services/repos/migrations/0001_init.sql
| 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); |