| .. | ||
| 20260328_010000_add_household_store_available_items.sql | ||
| 20260329_010000_add_household_store_items.sql | ||
| 20260329_020000_fix_household_item_classification_upsert.sql | ||
| add_display_name_column.sql | ||
| add_image_columns.sql | ||
| add_modified_on_column.sql | ||
| add_notes_column.sql | ||
| create_item_classification_table.sql | ||
| create_sessions_table.sql | ||
| multi_household_architecture.sql | ||
| README.md | ||
| stale-files.json | ||
| zz_group_invites_and_join_policies.sql | ||
Migration Directory
This directory is the canonical location for SQL migrations.
- Use
npm run db:migrateto apply pending migrations. - Use
npm run db:migrate:statusto view applied/pending migrations. - Use
npm run db:migrate:verifyto fail when pending migrations exist. - Use
npm run db:migrate:new -- <migration-name>to create a new migration file.
Do not place new canonical migrations under backend/migrations.
Stale baseline
stale-files.jsonlists canonical SQL files intentionally treated as stale.- Files listed there are skipped by migration commands by default.
- Add only genuinely new migration files when schema changes are required.