init.sql


1
2
3
4
5
6
7
8
9
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);