KB-7E33
dot-iu-cutter v0.2 — Phase α Dry-Run Artefact Index (2026-05-16)
8 min read Revision 1
dieu44-trien-khaidot-iu-cutterv0.2phase-alphadry-runartefact-indexsha2562026-05-15
dot-iu-cutter v0.2 — Phase α Dry-Run Artefact Index
document_path: knowledge/dev/laws/dieu44-trien-khai/v0.2-dry-run/dot-iu-cutter-v0.2-phase-alpha-dry-run-artefact-index-2026-05-15.md
revision: r1
executed_utc: 2026-05-16
artefact_dir: /opt/incomex/backups/dieu44_phase_alpha_2026-05-16/ (on VPS 38.242.240.89)
manifest: /opt/incomex/backups/dieu44_phase_alpha_2026-05-16/SHA256SUMS
dry_run_env: pg-dry-run-v0.2-phase-alpha-2026-05-16 (postgres:16; isolated; no published host port; volume pg-dry-run-v0.2-phase-alpha-2026-05-16-data)
§1 — Key Artefacts
| Role | Path (under artefact_dir) | SHA256 |
|---|---|---|
| Fresh production baseline dump | phase_alpha_baseline_20260516T014848Z.dump |
455fea54bfee615c7ac351bf6546cae23cbaa88aeb54191eb820a1a9b20d6bec |
| Roles dump | schema/roles_dump.sql |
5601c92a486514a37db5bbaa367ec6c0b6ebeb12717b39255fb12393e0e6995a |
| Frozen executable r2 SQL | sql/dot-iu-cutter-v0.2-phase-alpha-r2.sql |
65533e0564ee45625b43bff383252ec03f20e284a5cc506d78e1079d6f893fe3 |
| Rollback variant (COMMIT→ROLLBACK) | sql/dot-iu-cutter-v0.2-phase-alpha-r2-ROLLBACK-variant.sql |
6376ec6b5f7a7bf8cb4a8af2138b6f2ae1b1cc0ca35b57703ca2a3c9c180c096 |
| Verification SQL | sql/verify_alpha.sql |
46296d19fc6a7a15f053957c43e86ef3981a9534f0313973377791efd7ae6074 |
| State probe SQL | sql/state_probe.sql |
2b795223e15d034501738f379da21348bddf2a6e7134ca6f84f416ec56ba308b |
| Script 01 restore roles+DB | scripts/01_restore_roles_and_db.sh |
c4392b57d88facda00bf6bc5ae46354fe18173206967dd5bfaa740d592bab79b |
| Script 02 preflight+snapshot | scripts/02_preflight_and_snapshot.sh |
038b68ad2cba04ffa18073eaa430a9e40267afaf817896aa89b52108e903c191 |
| Script 03 rollback test | scripts/03_rollback_test.sh |
2d239f58eab13f37f1e700dd5684248ca95b1cc8eb48c24aebf61165d390ffe1 |
| Script 04 execute+verify | scripts/04_execute_and_verify.sh |
52213bdd8458b34dd19ef845ba0b0abd0eea53e3540d1b0ddf0ee58bb0d4e8c7 |
| Pre-DDL schema snapshot | schema/predll_schema_dryrun_20260516T020054Z.sql |
42441c5dc0278feb565906c0a710b3245fda5bcbaec5a26500ab719b16e9156b |
| Post-DDL schema snapshot | schema/postddl_schema_dryrun_20260516T020437Z.sql |
7508dd1385937119b11f074072837e813b7f289a7e7b6ef1782b4f546e65fdb8 |
| Post-rollback schema snapshot | schema/post_rollback_schema_dryrun_20260516T020203Z.sql |
df580ea5a3a123ddf8667f6eebd60d02d69643d520e70b1feb521bf1f480affc |
| Pre-DDL updated_at baseline (preflight) | schema/predll_tac_updated_at_20260516T020054Z.csv |
07454b1d076e4b6ad5498d280a7fd6f70df4889f1fad2980265d8ca94989b3ad |
| Pre-DDL updated_at (exec) | schema/exec_pre_updated_at_20260516T020437Z.csv |
07454b1d076e4b6ad5498d280a7fd6f70df4889f1fad2980265d8ca94989b3ad |
| Post-DDL updated_at (exec) | schema/exec_post_updated_at_20260516T020437Z.csv |
2008494b3d00162dd251362b6036ca1260e1de72d5a0da3c210cd1f400db05b8 |
| Verification results | logs/04_verification_results_20260516T020437Z.txt |
cdbfd2dcb910a93c28c1ae3530505f2d046406730cf91262cb2dd59ef87472fc |
| DDL exec output | logs/04_ddl_exec_output_20260516T020437Z.txt |
b0576f20a42a7f4b6a338eae3d4e9c3c92061f7684920814b994c7aa56555675 |
| V-α-16 diff detail | logs/04_valpha16_diff_20260516T020437Z.txt |
948672c081dc6c1cd220aedaa1db63c67d59c7fa2f42a0d53a54fe75df8942d2 |
(schema/03_schema_diff is the EMPTY rollback diff — sha256 e3b0c442…b855 = empty-file hash, i.e. zero schema delta.)
§2 — Full SHA256 Manifest (verbatim from artefact_dir/SHA256SUMS)
864bc0e3de9b86eaed254125f4942e8708145394c8de9ad56efcf0f6a7373915 ./logs/01_restore_20260516T015616Z.log
09fdf600e614b56daa924fe524b895fe8051102b1d8937e082e9b6b3909b3c68 ./logs/02_preflight_20260516T020054Z.log
9c6a72fd228c2ae64f1db2c1d80f5822d78290ba3102c76044140b1c6b85c417 ./logs/03_rollback_test_20260516T020203Z.log
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855 ./logs/03_schema_diff_20260516T020203Z.txt
b0576f20a42a7f4b6a338eae3d4e9c3c92061f7684920814b994c7aa56555675 ./logs/04_ddl_exec_output_20260516T020437Z.txt
bc9dcd47f8f199032aece664e82d2fd955d216ca93e9f218e4acc44f1ff82768 ./logs/04_execute_verify_20260516T020437Z.log
948672c081dc6c1cd220aedaa1db63c67d59c7fa2f42a0d53a54fe75df8942d2 ./logs/04_valpha16_diff_20260516T020437Z.txt
cdbfd2dcb910a93c28c1ae3530505f2d046406730cf91262cb2dd59ef87472fc ./logs/04_verification_results_20260516T020437Z.txt
455fea54bfee615c7ac351bf6546cae23cbaa88aeb54191eb820a1a9b20d6bec ./phase_alpha_baseline_20260516T014848Z.dump
2008494b3d00162dd251362b6036ca1260e1de72d5a0da3c210cd1f400db05b8 ./schema/exec_post_updated_at_20260516T020437Z.csv
07454b1d076e4b6ad5498d280a7fd6f70df4889f1fad2980265d8ca94989b3ad ./schema/exec_pre_updated_at_20260516T020437Z.csv
df580ea5a3a123ddf8667f6eebd60d02d69643d520e70b1feb521bf1f480affc ./schema/post_rollback_schema_dryrun_20260516T020203Z.sql
7508dd1385937119b11f074072837e813b7f289a7e7b6ef1782b4f546e65fdb8 ./schema/postddl_schema_dryrun_20260516T020437Z.sql
42441c5dc0278feb565906c0a710b3245fda5bcbaec5a26500ab719b16e9156b ./schema/predll_schema_dryrun_20260516T020054Z.sql
07454b1d076e4b6ad5498d280a7fd6f70df4889f1fad2980265d8ca94989b3ad ./schema/predll_tac_updated_at_20260516T020054Z.csv
5601c92a486514a37db5bbaa367ec6c0b6ebeb12717b39255fb12393e0e6995a ./schema/roles_dump.sql
c4392b57d88facda00bf6bc5ae46354fe18173206967dd5bfaa740d592bab79b ./scripts/01_restore_roles_and_db.sh
038b68ad2cba04ffa18073eaa430a9e40267afaf817896aa89b52108e903c191 ./scripts/02_preflight_and_snapshot.sh
2d239f58eab13f37f1e700dd5684248ca95b1cc8eb48c24aebf61165d390ffe1 ./scripts/03_rollback_test.sh
52213bdd8458b34dd19ef845ba0b0abd0eea53e3540d1b0ddf0ee58bb0d4e8c7 ./scripts/04_execute_and_verify.sh
6376ec6b5f7a7bf8cb4a8af2138b6f2ae1b1cc0ca35b57703ca2a3c9c180c096 ./sql/dot-iu-cutter-v0.2-phase-alpha-r2-ROLLBACK-variant.sql
65533e0564ee45625b43bff383252ec03f20e284a5cc506d78e1079d6f893fe3 ./sql/dot-iu-cutter-v0.2-phase-alpha-r2.sql
2b795223e15d034501738f379da21348bddf2a6e7134ca6f84f416ec56ba308b ./sql/state_probe.sql
46296d19fc6a7a15f053957c43e86ef3981a9534f0313973377791efd7ae6074 ./sql/verify_alpha.sql
§3 — Provenance Chain
r2 source doc (revision 2, GPT PASS):
knowledge/.../v0.2-ddl-authoring/dot-iu-cutter-v0.2-phase-alpha-ddl-draft-2026-05-15.sql.md
└─ §2 body extracted verbatim →
sql/dot-iu-cutter-v0.2-phase-alpha-r2.sql sha256 65533e05…3fe3 (FROZEN; used for dry-run; lock through production)
production 'postgres' (read-only pg_dump, workflow_admin) →
phase_alpha_baseline_20260516T014848Z.dump sha256 455fea54…d6bec →
restored into pg-dry-run-v0.2-phase-alpha-2026-05-16 ONLY
r1 DDL: superseded, never extracted, never executed.
§4 — Reproduction Order
scripts/01_restore_roles_and_db.sh → fresh dry-run env + baseline restore (PASS)
scripts/02_preflight_and_snapshot.sh → preflight + Q-CHK + pre-DDL snapshots (PASS)
scripts/03_rollback_test.sh → in-transaction ROLLBACK test (PASS; schema diff EMPTY)
scripts/04_execute_and_verify.sh → commit r2 DDL + V-α-1..16 + updated_at bump (PASS_WITH_NOTES)
All scripts contain set -euo pipefail, identity guards (DRY var exact-match, ≠ production container, no published host port), and write timestamped logs to logs/.
§5 — Status
phase_alpha_dry_run_status: PASS_WITH_NOTES
production_status: FORBIDDEN (dry-run PASS does NOT authorize production)
companion_docs:
- dot-iu-cutter-v0.2-phase-alpha-dry-run-execution-report-2026-05-15.md
- dot-iu-cutter-v0.2-phase-alpha-dry-run-verification-results-2026-05-15.md
End of Phase α dry-run artefact index.