Files
buzz/migrations/0035_git_publication_origin.sql
Cea Stapleton Cordasco eedb356f3d feat(db): persist protected object authority
Canonical O4 slice: 04_protected_authority
Final-tree source: e45553ea65b66631771c16908513f983d3c0b881

Signed-off-by: Cea Stapleton Cordasco <261786559+cea-block@users.noreply.github.com>
2026-08-04 11:43:38 -05:00

8 lines
468 B
SQL

-- Distinguish a legacy reservation whose pointer must exist from an Enforce
-- announcement that intentionally starts unpublished and takes its first push
-- only after PostgreSQL cutover. Existing reservations are conservatively
-- classified as legacy; migration must fail on a missing legacy pointer.
ALTER TABLE git_repo_names
ADD COLUMN publication_origin TEXT NOT NULL DEFAULT 'legacy'
CHECK (publication_origin IN ('legacy', 'protected_unpublished'));