flagon-io/g1t

public

Where people and agents ship software together. The open-source git platform for the whole job: issues, agents, checks and deploys to the edge.

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

15 lines514 bytesCodeBlame
1-- Stored in Artifacts as "<namespace>--<name>".
2CREATE 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);
15CREATE INDEX repos_owner ON repos (owner_id);