-- ============================================================================ -- F_prod_00 — PRODUCTION PREFLIGHT (READ-ONLY; safe to run anytime / unattended) -- Target DB: directus (PRODUCTION) -- Channel: ssh contabo -> docker exec -i postgres psql -U workflow_admin -d directus -f - -- Exit non-zero (\set ON_ERROR_STOP) if any precondition is not met. NO changes. -- ============================================================================ \set ON_ERROR_STOP on \pset pager off

DO $$ DECLARE v_db text; v_ospa int; v_gap int; v_own int; v_conf int; v_inv int; v_scopes int; BEGIN SELECT current_database() INTO v_db; IF v_db <> 'directus' THEN RAISE EXCEPTION 'WRONG DB: % (expected production directus).', v_db; END IF; SELECT count() INTO v_ospa FROM os_proposal_approvals; 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; SELECT count() INTO v_inv FROM v_governance_object_inventory WHERE requires_owner AND born; SELECT count() INTO v_scopes FROM governance_responsibility_scope WHERE status='active'; RAISE NOTICE 'PREFLIGHT: db=% ospa=% gap=% own=% conflict=% inventory=% scopes=%', v_db, v_ospa, v_gap, v_own, v_conf, v_inv, v_scopes; IF v_ospa < 1 THEN RAISE EXCEPTION 'GATE CLOSED: os_proposal_approvals=% (<1). Human L2/L4 ratification not enacted. NO-GO.', v_ospa; END IF; IF v_own <> 0 THEN RAISE EXCEPTION 'NOT A CLEAN SEED: ownership=% (expected 0). NO-GO.', v_own; END IF; IF v_gap <> 210 THEN RAISE EXCEPTION 'GAP DRIFT: gap=% (expected 210). NO-GO.', v_gap; END IF; IF v_conf <> 0 THEN RAISE EXCEPTION 'PRE-EXISTING CONFLICT: %. NO-GO.', v_conf; END IF; IF v_inv <> 35 THEN RAISE EXCEPTION 'INVENTORY DRIFT: %=expected 35. NO-GO.', v_inv; END IF; IF v_scopes <> 6 THEN RAISE EXCEPTION 'SCOPE DRIFT: %=expected 6. NO-GO.', v_scopes; END IF; RAISE NOTICE 'PREFLIGHT GO: gate open, baseline clean. Proceed to F_prod_01 seed commit.'; END $$;