-- 0099_repo_ext.sql
-- Reference DDL for repo table extensions added by lib/repo.
-- This file is documentation only; it is NOT executed by the SeaORM migration runner
-- per project policy ("数据库就不要动了"). Apply manually when DBA window allows.
--
-- Adds five columns mirroring the Rust fields declared in lib/db/repo/repos.rs:
--   allow_rebase          : bool  default true
--   allow_rebase_explicit : bool  default false
--   allow_squash_merge    : bool  default true
--   allow_merge_commits   : bool  default true
--   object_format         : text  default 'sha1'

ALTER TABLE repos
    ADD COLUMN IF NOT EXISTS allow_rebase          boolean NOT NULL DEFAULT true,
    ADD COLUMN IF NOT EXISTS allow_rebase_explicit boolean NOT NULL DEFAULT false,
    ADD COLUMN IF NOT EXISTS allow_squash_merge    boolean NOT NULL DEFAULT true,
    ADD COLUMN IF NOT EXISTS allow_merge_commits   boolean NOT NULL DEFAULT true,
    ADD COLUMN IF NOT EXISTS object_format         text    NOT NULL DEFAULT 'sha1';