# Migrations

SQL migrations for the PYRE PostgreSQL database.

**Empty for now** (skeleton). Migration files and a runner will be added here.

## Convention (TODO)

- One forward migration per file, ordered/timestamped (e.g.
  `0001_init.sql`, `0002_<change>.sql`).
- The first migration creates the initial MVP tables listed in the package
  README (§15): `wallet_scans`, `token_accounts`, `cleanup_receipts`,
  `prometheus_generations`, `spawn_records`.
- A migration runner (in `@pyre/db`) applies pending migrations against
  `DATABASE_URL`.