-- Advanced settings (hub spec §6, #108): a repository can be archived

-- (read-only, with a reason) and transferred to another owner; the old

-- name redirects on the web and still resolves for oxy remotes.

ALTER TABLE repositories ADD COLUMN archived INTEGER NOT NULL DEFAULT 0;

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

CREATE TABLE repo_redirects (

    old_owner   TEXT NOT NULL,

    old_name    TEXT NOT NULL,

    repo_id     INTEGER NOT NULL REFERENCES repositories(id) ON DELETE CASCADE,

    moved_ms    INTEGER NOT NULL,

    PRIMARY KEY (old_owner, old_name)

);