From 5ef38f263df2cec25d44cb35d1486c2d4d59bc2a Mon Sep 17 00:00:00 2001
From: iximeow <me@iximeow.net>
Date: Mon, 23 Mar 2026 03:16:30 +0000
Subject: initial

---
 init.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)
 create mode 100644 init.sql

(limited to 'init.sql')

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);
-- 
cgit v1.1

