08 — Objective G: Production Rollout Automation — PASS (packaged, NOT executed)

Production rollout is gated and was not executed. Files validated on the clone (structure DDL byte-identical to clone-proven objects).

Rollout files

• G_prod_00_preflight.sql (gate): aborts unless db=directus, ospa≥1, base substrate present, gov types inactive; prints baseline. MUTATES NOTHING.
• G_prod_10_structure.sql (Tier-1 inert): 4 tables + 21 views + fn_governance_scan. Idempotent. Validated on clone (no errors).
• G_prod_20_promotion_GATED.sql (Tier-2 accountability): vocab map seed + value/ownership promotion. Requires -v approval_ref=APR-XXXX and re-asserts ospa≥1.
• G_prod_90_verify.sql: object counts + inert checks + reconcile + dashboard.
• G_prod_99_rollback.sql: drops only this macro's layer; base substrate untouched. Validated (ROLLBACK kept clone intact).

Classification

Tier-1 (structure) runnable immediately after ospa≥1 + base substrate present — inert (views read 0 rows, scanner 0, emit closed; no accountability assertion). Tier-2 (promotion) must remain gated beyond ospa≥1 — value activation and especially axis_object_ownership seeding assert sovereign accountability (the human L2/L4 act); each ownership row binds to a ratified approval_ref. No blanket auto-activation.

Dependency on base substrate

Layers on the base axis substrate (absent on prod). G_prod_00 aborts at STOP-GATE 2 until the prior base-substrate rollout runs. Order: base-substrate rollout → G_prod_00 → G_prod_10 → (gate) → G_prod_20.

Expected deltas

After G_prod_10: +4 tables, +21 views, +1 function; ownership/gap/ospa/emit unchanged; drift≈0, gov_emit=0, gov_active=0. After G_prod_20 (only when authorized): map rows + ratified value/ownership; gap decreases per ratified ownership.

Stop gates

1 ospa<1 abort. 2 base substrate missing abort. 3 any gov event type active abort. 4 Tier-2 without supplied ratified approval_ref abort.

Relation to ratification

Single long-standing blocker (human L2/L4 with ospa≥1) unchanged. Tier-1 inert/ratification-independent; Tier-2 promotion is the exact accountability act ratification authorizes. No production activation is GO.

Verdict

PASS (packaged & validated). NOT executed; production byte-unchanged.