CREATE TABLE IF NOT EXISTS blocked_packages (
    id         INTEGER  PRIMARY KEY AUTOINCREMENT,
    repo_id    INTEGER  NOT NULL REFERENCES repos(id) ON DELETE CASCADE,
    location   TEXT     NOT NULL,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    UNIQUE(repo_id, location)
);