Artifacts manifest + SQL

manifest.sha256

docs/00-readme-first.md                        bab0c2567d99ccac8a10f5ac0aa0dfac6a0c56ea58d3bfbc4e33c3242d68ecfc
docs/01-state-recovery-and-live-preflight.md   c1baa41111a95b8ac15f91c0fe1d2be2568aabb71907437dcac14307ed4389e0
docs/02-dot-update-tool-design-and-implementation.md 6cbba7505afdbed22e52fb75442e17d4efb25d75ddd0dbed80491a595d67e804
docs/03-dot-registration-or-staging.md         03be70f9e34584101c487593ed98e7688c868bf2b2b2a81bf3553b7babf96d66
docs/04-clone-or-rollback-rehearsal.md         0814e799a52877afa6a756e9c1d0790dfaf7d55c462bfd2c693fbdbc3f0558a9
docs/05-deterministic-cleanup-execution-or-blocker.md 0d18dc3ab982fab18f83da83674057035b3a362c0026ccd78b13e819c9c4f4f1
docs/06-naming-and-retire-action-packets.md    def8d8e67ef86b71cf5beca767f03a446e2ad894e6a1651912d1a3c778a290fd
docs/07-antidrift-health-and-guardrail.md      ec3e2b3eb582f5094e6cbd4d53b4aeed19032dfb0b37e13a92e28168d3366e8d
docs/08-ui-api-handoff.md                      93d5c71949b29a35938aefa41542ecf499723a8d5ce632a04f80db796b657faa
docs/09-rp-roadmap-after-cleanup.md            ff66b4e21c40cc7be1fb03b6bd98cb20bd8c562cc7fa4472dbf25fe29f2c0b14
docs/10-final-go-nogo.md                       ec0ae1c8bca8dcaffe1b24ae47c3525ff651b6e86b1b3e291a38c8935d209ba9
docs/11-self-review.md                         a58aed28368e6b851fdb9a9891bd8763a51f96b3e5dce1ad3a09d4930f31c694
artifacts/dot-pivot-update                     3313c057caaf1c72e30465354ee9cff0866e0dc3e7205a2c84c3c849284effc5
artifacts/apply_composition_fixes.sh           7796b058b84cfb73b48625527d08e8031ea98e33da2aa4cecfa3471ff3a8aee1
artifacts/register_and_commit_packet.sh        56d913d5707dd7712fc082bb12668a9d40ef675ef9ed22b9e22e257b1016404e
artifacts/rehearsal_log.txt                    5a89ded8e6e7337dbac8c93c904e3141ca6f4371cd5987abe35a6672ed7dedb1
sql/v_rp_classification_health.sql             dc4330101ea5170fe80f96ee5ec6abfad304ba99da7110c450ca5fa54df7a8ce
sql/verify_classification.sql                  0d160c7cde5dd1f6e79163617e987b0c9e8a0415dcb794037cb0b6592c59d363

Local SQL: one-roof-clone-finalization-2026-06-03/sql/rp_dot_pivot_update/.

verify_classification.sql (read-only — run before/after commit)

Checks: (1) pivot_definitions fingerprint + active split; (2) mapping view rows=37 + composition_status breakdown; (3) the 3 mismatch rows (expect 3 before, 0 after); (4) species orphan = 0.

v_rp_classification_health.sql (paste-ready, NOT applied)

One-row anti-drift view: ad1 literal-species-bug=0, ad2 missing-species-active=2 (matrix), ad3 invalid-species=0, ad4 composition-mismatch=3→0, ad5 unknown-registry_group=0, ad6 provisional-fac02=6, ad7 l2-false-claim=false, ad8 parity 37==37, ad9 island=0.

rehearsal_log.txt (key lines)

ENTRY md5=70d6df05501a7de91e24b848168c5b03; 3 dry-run fixes all → composition_status match; 10/10 rejection battery correct; bug found+fixed (inactive boolean guard); EXIT md5 identical.