25 lines
503 B
Markdown
25 lines
503 B
Markdown
# Core DB Migrations
|
|
|
|
This folder contains SQL migrations for core MVP services:
|
|
- `auth-service`
|
|
- `customer-service`
|
|
- `interaction-service`
|
|
- `routing-service`
|
|
|
|
## Files
|
|
- `sql/0001_core_sqlite.sql`
|
|
- `sql/0001_core_postgres.sql`
|
|
- `sql/0002_stage3_sqlite.sql`
|
|
- `sql/0002_stage3_postgres.sql`
|
|
|
|
## Apply
|
|
|
|
```bash
|
|
python scripts/migrate_core_db.py
|
|
```
|
|
|
|
The runner:
|
|
- detects dialect from `DATABASE_URL`
|
|
- applies all `*_{dialect}.sql` migrations in order
|
|
- tracks applied files in `schema_migrations`
|