-- STEP A — OWNERSHIP SEED COMMIT (CLONE ONLY, PERSISTENT) -- Target DB: directus_gov_test_20260602 -- sha256: 07c7dda62a260486812d9ab36b91882c68f56bb409ee17c6cf71a71304fbf305 -- Clone twin of production commit_ready_f6_ownership_seed.sql. Removes ONLY the -- sovereign gate (ospa>=1) because the clone is an isolated disposable test DB -- explicitly authorized for test commits; keeps all STRUCTURAL guards. \set ON_ERROR_STOP on \pset pager off \echo ENTRY_BASELINE SELECT count() AS own_entry FROM governance_object_ownership; SELECT count() AS gap_entry FROM v_object_owner_gap; SELECT count() AS conflict_entry FROM v_object_owner_conflict; SELECT current_database() AS db; BEGIN; DO $$ DECLARE v_gap int; v_own int; v_conf int; v_db text; BEGIN SELECT current_database() INTO v_db; IF v_db NOT LIKE 'directus_gov_test_%' THEN RAISE EXCEPTION 'WRONG DB: % not a clone. ABORT.', v_db; END IF; SELECT count() INTO v_gap FROM v_object_owner_gap; SELECT count() INTO v_own FROM governance_object_ownership; SELECT count() INTO v_conf FROM v_object_owner_conflict; IF v_gap <> 210 THEN RAISE EXCEPTION 'PREFLIGHT DRIFT: gap=%. ABORT.', v_gap; END IF; IF v_own <> 0 THEN RAISE EXCEPTION 'NOT CLEAN: own=%. ABORT.', v_own; END IF; IF v_conf <> 0 THEN RAISE EXCEPTION 'CONFLICT: %. ABORT.', v_conf; END IF; RAISE NOTICE 'CLONE GATE OPEN: db=% gap=% own=% conflict=%.', v_db, v_gap, v_own, v_conf; END $$; INSERT INTO governance_object_ownership (object_type, object_ref, scope, owner_kind, owner_gov_code, is_inherited_anchor, lifecycle_status, approval_ref, source_design_ref, created_by) SELECT 'group', g.code, s.scope_code, 'accountable', g.owner, true, 'active', 'CLONE-TEST-NO-RATIFICATION', 'F6-anchor-clone-test', 'CLONE_TEST_F6_SEED' FROM (VALUES ('GRP-GOVERNANCE','GOV-COUNCIL'),('GRP-REGISTRY','GOV-KG-SYS'),('GRP-AI','GOV-DOT'),('GRP-BUSINESS','GOV-MOIT'),('GRP-WORKFLOW','GOV-DOT')) g(code, owner) CROSS JOIN governance_responsibility_scope s WHERE s.status='active'; DO $$ DECLARE v_new int; v_gap int; v_conf int; BEGIN SELECT count() INTO v_new FROM governance_object_ownership WHERE created_by='CLONE_TEST_F6_SEED'; SELECT count() INTO v_gap FROM v_object_owner_gap; SELECT count() INTO v_conf FROM v_object_owner_conflict; IF v_new <> 30 THEN RAISE EXCEPTION 'EXPECTED 30, got %. ABORT.', v_new; END IF; IF v_gap <> 0 THEN RAISE EXCEPTION 'EXPECTED gap 0, got %. ABORT.', v_gap; END IF; IF v_conf <> 0 THEN RAISE EXCEPTION 'EXPECTED conflict 0, got %. ABORT.', v_conf; END IF; RAISE NOTICE 'PRE-COMMIT OK: new=30 gap=0 conflict=0.'; END $$; COMMIT; \echo POST_COMMIT_VERIFY SELECT count() AS own_after FROM governance_object_ownership; SELECT count() AS gap_after FROM v_object_owner_gap; SELECT count() AS conflict_after FROM v_object_owner_conflict; SELECT count(*) AS govemit_after FROM event_outbox WHERE event_domain='governance'; -- RESULT: own=30 gap=0 conflict=0 gov_emit=0 (PASS)