12 — SQL Manifest & KB Publication

SQL artifacts (on disk: /Users/nmhuyen/one-roof-clone-finalization-2026-06-03/sql/)

file	purpose	applied
A_reconcile_decision.sql	decision register + facet-aware reconcile views	COMMIT (clone)
B_kg_ratification.sql	kg-domain-x candidate→active ratification	COMMIT (clone)
B2_lifecycle_rehearsal.sql	candidate→active→deprecate/merge/split	ROLLBACK-only (clone)
B3_kg_projection.sql	kg-domain-x → taxonomy projection	COMMIT (clone)
C_containment_activation.sql	coverage_rule + 35 assign + 35 own	COMMIT (clone)
C2_containment_failclosed.sql	5 fail-closed negatives	ROLLBACK-only (clone)
D_projection_lag_timing.sql	timestamp projection-lag detector + drift_finding	COMMIT (clone)
E_regression.sql	full read-only regression suite	READ-only (clone)
Z_rollback_finalization.sql	reverse A/B/B3/C/D	authored, NOT run (KEEP)
G_prod_00_preflight.sql	prod gate (db+ospa≥1)	authored, NOT run (prod NO-GO)
G_prod_20_containment_seed_GATED.sql	Tier-3 containment seed	authored, gated
G_prod_30_topic_finalization_GATED.sql	Tier-4 decisions + kg ratify	authored, gated
G_prod_60_finalization_structure.sql	Tier-6 structure manifest	authored
G_prod_90_verify.sql	post-rollout verify	authored
G_prod_99_rollback.sql	prod rollback tiers 3/4/6	authored
_clone_defs.txt	archived verbatim original view/fn bodies	reference

KB publication

13 docs (00–12) published to knowledge/dev/reports/architecture/one-roof-nonprod-clone-governance-finalization-production-rehearsal-2026-06-02/. Verified via list_documents (count), get_document (read), search_knowledge (semantic).

Channels

Clone snapshot: /tmp/clone_finalized_2026-06-03.dump (92 MB, postgres container). Clone read/write: ssh contabo docker exec -i postgres psql -d directus_gov_test_20260602. Production read-only: query_pg(database='directus').