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);