engine_databaselisted

# engine_database — inspect and repair the control plane Admin only. The boot `ENGINE MAINTENANCE` block names the active engine floor and private instance-state directory. Resolve the canonical database again before any repair: ```bash python3 .super-coder/scripts/instance_state.py active-database .super-coder ``` Require the printed absolute path to sit under the boot's private instance state. The private directory owns the live `shell_db.db` plus WAL/SHM sidecars, local control-plane snapshot, verified backups, relocation receipt, maintenance lease, and DB-generation evidence. The repository catalogue remains a separate map store; a product database remains the fork application's concern. ## Source and rebuild model In the Subfloor source repository, `.super-coder/schema.sql` is the current baseline and `.super-coder/migrations/*.sql` are ordered, ledger-tracked deltas. Installed downstream floors materialize the same engine source. `sc rebuild` creates a candidate from that source plus the private instance snapshot, verifies it, and publishes only through the maintenance cutover. Load `engine_migrations` before changing the baseline or migrations and `snapshot` before serializing instance content. ## Data model | Surface | Storage | |---|---| | Shell core | `shells` — role, flavor, mandate, system prompt, current state, active session/archive identity | | Seed and L&S | `shell_identity_entries` — capped identity entries with retirement | | Decisions | `shell_decisi