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