migrations

Overview ¶

Package migrations holds the store's schema migrations, one set per SQL dialect, embedded into the binary and applied by goose.

The sets are numbered alike: a change is one file in each, under the same version, so the version a database reports means the same schema on either. SQLite's set is the store's history from 0001; Postgres's starts at the baseline 0023, the SQLite schema as of 0023 with tenant isolation added (MAI-150), since no Postgres database predates it. A file must never be renumbered or removed once released: goose knows a migration by its number alone.