-- Forks (hub spec §4): the repository a fork was made from.

ALTER TABLE repositories ADD COLUMN forked_from INTEGER REFERENCES repositories(id) ON DELETE SET NULL;

CREATE INDEX repositories_forks ON repositories (forked_from) WHERE forked_from IS NOT NULL;