Final DB/Migration/Seed Audit — Subagent C
Historical snapshot
A dated migration and seed-data audit. Its conclusions describe the database schema and test environment examined then.
Use the current migration index and fresh-database tests before modifying data; never run recovery or reset commands without authorization.
| Problem | Verdict |
|---|---|
| 001_init vs 001_projects dup | CONFIRMED — breaks fresh migrations apply (index on missing seller_id) |
| 008 demo data | CONFIRMED (seller_beta INSERT in schema migration) |
| Axum MIGRATIONS stops at 008 | CONFIRMED (009-011 unregistered; test enshrines gap) |
| Local seed→remote staging | CONFIRMED (script always --remote) |
| Demo fixed admin password | CONFIRMED (demo1234 on staging) |
| BOOTSTRAP-PENDING | CONFIRMED — account can never login |
| Seed vs seller mismatch | CONFIRMED (demo.sql never creates seller rows; onboarding doesn't either) |
| Fresh D1 reproducibility | CONFIRMED (no migrations apply; prod manual ALTERs) |