AkurAI-Build / migrations/007_branch_protection.sql

Latest change cd8019fddc46769e797dc54194decfd9d4a98f2d - OLI-270: branch protection — rules per branch, pre-receive check, merge gate by Óli

CREATE TABLE branch_protection (
    repository_id INTEGER NOT NULL REFERENCES repositories(id) ON DELETE CASCADE,
    branch TEXT NOT NULL CHECK (length(branch) BETWEEN 1 AND 200),
    allow_force_push INTEGER NOT NULL DEFAULT 0 CHECK (allow_force_push IN (0, 1)),
    allow_delete INTEGER NOT NULL DEFAULT 0 CHECK (allow_delete IN (0, 1)),
    require_green INTEGER NOT NULL DEFAULT 0 CHECK (require_green IN (0, 1)),
    require_review INTEGER NOT NULL DEFAULT 0 CHECK (require_review IN (0, 1)),
    created_at INTEGER NOT NULL DEFAULT (unixepoch()),
    PRIMARY KEY (repository_id, branch)
) STRICT;