IU Core Production DDL — 03 Apply + post-apply verification

Date: 2026-05-21 · Production directus DDL apply under sovereign gate.

Final pre-apply drift re-check

Immediately before apply: iu-core tables 0, views 0, functions 0; information_unit=158, unit_version=165. No drift since the survey.

Apply

Each file piped to docker exec -i postgres psql -U directus -d directus -v ON_ERROR_STOP=1 (hardened — no -1; each file self-transacts). Exit code checked per file; a non-zero would have stopped the run.

File	Result
001_iu_sql_link.sql	OK — 1 table, 3 indexes, BEGIN…COMMIT
002_iu_event_routes.sql	OK — 3 tables, 5 indexes, BEGIN…COMMIT
003_parent_child_constraints.sql	OK — 1 table, 3 indexes, view v_iu_tree, BEGIN…COMMIT
004_structure_ops_lineage.sql	OK — 2 tables, 6 indexes, BEGIN…COMMIT
005_trigger_contracts_and_guards.sql	OK — 7 functions, view v_iu_sql_link_resolved, BEGIN…COMMIT

All 5 files: 0 errors. The live event triggers evt_trigger_guard_ddl (ddl_command_end) and evt_trigger_guard_drop (sql_drop) are enabled and permitted the iu-core DDL.

Post-apply verification

Check	Expected	Got
iu-core tables	7	7
iu-core views	2	2
iu-core functions	7	7
indexes on iu-core tables	—	30
triggers attached to iu-core tables	0	0
rows in each of the 7 iu-core tables	0	0
information_unit	unchanged	158
unit_version	unchanged	165
fn_iu_core_routes_enabled()	false	f (fail-closed)
v_iu_tree rows / min depth	resolves	158 rows / depth 0
v_iu_sql_link_resolved rows	0	0

Every line of the SSOT report-10 "Expected counts" table matched exactly.

Outcome

Production DDL apply PASS. The iu-core substrate is live on directus and fully inert (master gate closed, no trigger attached, no route enabled, 0 rows). No seed, no route enable, no trigger attach, no deploy/restart, no execution_enabled flip were performed.