-- Drops (oxygenhub#279): a drop is a small repository of its own, named

-- `drops/ID` under its owner, that no repository list shows; `kind` tells

-- it from a repository and `title` is its name on the Drops page (the

-- description column holds its description). A secret drop is private to

-- every list and readable by anyone with its address.

ALTER TABLE repositories ADD COLUMN kind TEXT NOT NULL DEFAULT 'repo';

ALTER TABLE repositories ADD COLUMN title TEXT NOT NULL DEFAULT '';

CREATE INDEX repositories_kind_owner ON repositories(kind, owner);