costco-grocery-list/packages/db/migrations
Nico 77ae5be445
All checks were successful
Build & Deploy Costco Grocery List / build (push) Successful in 1m10s
Build & Deploy Costco Grocery List / verify-images (push) Successful in 3s
Build & Deploy Costco Grocery List / deploy (push) Successful in 11s
Build & Deploy Costco Grocery List / notify (push) Successful in 1s
refactor
2026-02-22 01:27:03 -08:00
..
add_display_name_column.sql chore: establish governance baseline and migration workflow 2026-02-16 01:09:13 -08:00
add_image_columns.sql refactor 2026-02-22 01:27:03 -08:00
add_modified_on_column.sql chore: establish governance baseline and migration workflow 2026-02-16 01:09:13 -08:00
add_notes_column.sql chore: establish governance baseline and migration workflow 2026-02-16 01:09:13 -08:00
create_item_classification_table.sql chore: establish governance baseline and migration workflow 2026-02-16 01:09:13 -08:00
create_sessions_table.sql feat: add db migration for session storage 2026-02-16 01:40:18 -08:00
multi_household_architecture.sql chore: establish governance baseline and migration workflow 2026-02-16 01:09:13 -08:00
README.md refactor 2026-02-22 01:27:03 -08:00
stale-files.json refactor 2026-02-22 01:27:03 -08:00
zz_group_invites_and_join_policies.sql refactor 2026-02-22 01:27:03 -08:00

Migration Directory

This directory is the canonical location for SQL migrations.

  • Use npm run db:migrate to apply pending migrations.
  • Use npm run db:migrate:status to view applied/pending migrations.
  • Use npm run db:migrate:verify to 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.json lists 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.