mirror of
https://github.com/block/buzz.git
synced 2026-08-18 06:50:31 +02:00
Canonical O4 slice: 04_protected_authority Final-tree source: e45553ea65b66631771c16908513f983d3c0b881 Signed-off-by: Cea Stapleton Cordasco <261786559+cea-block@users.noreply.github.com>
8 lines
468 B
SQL
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'));
|