# Sprint 25.2 Status

## Trigger

Sprint 25.1 failed on MariaDB 10.11 while creating `policy_register` with error 121 because the foreign-key constraint name `fk_pr_creator` had already been used by `permissions_and_releases` in Migration 002.

## Changes

1. Assigned the unique constraint name `fk_policy_register_creator` to `policy_register.created_by`.
2. Added schema-wide duplicate foreign-key constraint detection to both release validators.
3. Added database character-set and collation validation to preflight.

## Required staging proof

- Clean empty `utf8mb4` database.
- Preflight PASS with no errors.
- First database installation exit code 0.
- Second database installation exit code 0 with no SQL files reapplied.
- First administrator creation succeeds.
- Health and browser smoke tests pass.