12 — SQL Artifact Index

All SQL committed/validated against clone directus_gov_test_20260602. Local artifact dir: one-roof-topic-promotion-2026-06-03/sql/.

file	objective	action on clone	reversible
A_topic_promotion.sql	A	COMMIT: containment active; +3 topic values (3 provenance lanes); split; merge; ownership ratify; gap 2→1	Z_rollback_A.sql
Z_rollback_A.sql	A	rollback by tag TEST_CLONE_topic_promo_2026-06-03	—
B_reconcile.sql	B	COMMIT: topic_taxonomy_map (6 seed) + 6 v_reconcile_* views	drop views + table
C_drift_detectors.sql	C	COMMIT: 4 new v_drift_* + keystone v_drift_finding + v_drift_summary	drop views
D_scanner.sql	D	initial scanner (superseded by fix)	—
D_scanner_fix.sql	D	COMMIT: governance_scan_run + governance_drift_state + fn_governance_scan (axis_code key fix); 3-pass idempotency	drop tables+fn
E_issue_event.sql	E	COMMIT: v_drift_event_map + v_drift_issue_payload + governance_event_log (41 logged, 0 emitted)	drop views+table
F_ui_api.sql	F	COMMIT: 7 v_ui_* views; live JSON proven	drop views
G_prod_00_preflight.sql	G	PROD gate (ospa≥1, base substrate, gov inactive); no mutation	—
G_prod_10_structure.sql	G	PROD Tier-1 DDL: 4 tables + 21 views + fn (clone-validated, idempotent)	G_prod_99_rollback.sql
G_prod_20_promotion_GATED.sql	G	PROD Tier-2 (gated, requires approval_ref + ospa≥1)	by approval_ref
G_prod_90_verify.sql	G	PROD post-rollout verification (read-only)	—
G_prod_99_rollback.sql	G	PROD rollback of macro layer (base untouched; clone-validated)	—

Clone object inventory added by this macro

Tables: topic_taxonomy_map, governance_scan_run, governance_drift_state, governance_event_log. Views (21): 6 v_reconcile_, 8 v_drift_ (incl. keystone v_drift_finding), 7 v_ui_*. Function: fn_governance_scan(text,text).

Production rollout order

base-substrate rollout (prior package) → G_prod_00 → G_prod_10 → [human gate ospa≥1] → G_prod_20 → G_prod_90. Rollback: G_prod_99.