Skip to content

db/06 fresh-init mirror is missing station.schedule_special (db/36)Β #618

Description

@genwave-radio

Found during the T345 House Voice wire proof (2026-08-23): grep schedule_special db/06-station-settings-migration.sh β†’ 0 hits; only db/36-schedule-special-migration.sh creates the table.

πŸ•³οΈ The gap

The house convention mirrors every station-schema migration's DDL into db/06 so fresh inits are whole without the migration pass (db/37–db/40 all comply; the MediaLibrary.Tests InitialSchema machinery + Story305/Story346 facts exist to keep it that way). db/36 predates or slipped that net: an init-scripts-only boot (the test fixture; any fresh compose start before migrate.sh) lacks station.schedule_special. Masked in production because launch runs migrate.sh; observed as OnAirPersonaAccessor degrading gracefully (WARN, persona-less) in the T345 fixture.

βœ… Wanted

Mirror db/36's DDL into db/06 (byte-consistent, the db/40 shape) + whatever InitialSchema-style fact makes the NEXT dropped mirror red β€” the Story305 net apparently has a blind spot for pre-existing gaps; check whether it pins per-table or only per-fact-that-someone-wrote.

Pre-existing on main since the dayparting epic (db/36, 2026-08-10); unrelated to the House Voice branch.

https://claude.ai/code/session_01N5rw6TJinqPMkFqPtidHE2

Metadata

Metadata

Assignees

No one assigned

    Labels

    P3Low prioritybugSomething isn't working

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions