Mission 0.5 Blockers Fix Report

Session: S142 | Date: 2026-03-28 | Executor: Claude Code CLI (Opus 4.6) Source: council-claude-code-review-dieu26-v3-round2.md (S141 Round 2)

Summary

3 critical blockers fixed. 8/8 contract tests PASS. birth_registry has status field.

Blockers Fixed

B1: TRUNCATE Permission (CRITICAL) - FIXED

GRANT TRUNCATE ON v_registry_counts, v_registry_summary TO directus (via workflow_admin superuser)

B2: count_material Missing (HIGH) - FIXED

Added count_material to refresh_registry_counts() INSERT INTO v_registry_summary

B3: Code File Drift (HIGH) - FIXED

dot-pg-views-ensure v12->v13.0.0: synced with deployed PG (9 differences resolved)

birth_registry status field - DONE

ALTER TABLE birth_registry ADD COLUMN IF NOT EXISTS status varchar(50) DEFAULT 'born'

Contract Tests: 8/8 PASS

T1-T8 all PASS. total_atoms=20336, total_types=23, count_atom=19923, count_molecule=343, count_compound=15, count_material=0

Pre-fix vs Post-fix

T1: FAIL (4 mismatches) -> PASS T5: FAIL (849 vs 1021) -> PASS TRUNCATE: false/false -> true/true count_material: always 0 -> populated Code drift: 9 diffs -> synced