--up
ALTER TABLE projects ADD COLUMN superseded_by integer REFERENCES projects(id);

--down
ALTER TABLE projects DROP COLUMN superseded_by;
