aboutsummaryrefslogtreecommitdiff
path: root/init.sql
diff options
context:
space:
mode:
authoriximeow <me@iximeow.net>2026-03-23 03:16:30 +0000
committeriximeow <me@iximeow.net>2026-04-26 05:19:05 +0000
commit5ef38f263df2cec25d44cb35d1486c2d4d59bc2a (patch)
tree61706a5096440b9f91b0b715eb54ca8afab08979 /init.sql
Diffstat (limited to 'init.sql')
-rw-r--r--init.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/init.sql b/init.sql
new file mode 100644
index 0000000..6381f6d
--- /dev/null
+++ b/init.sql
@@ -0,0 +1,10 @@
+CREATE TABLE projects (
+ id INTEGER PRIMARY KEY AUTOINCREMENT,
+ name TEXT UNIQUE NOT NULL,
+ dir BLOB NOT NULL,
+ host TEXT,
+ info TEXT,
+ upstream TEXT
+);
+
+CREATE INDEX projname on projects(name);