call-center/migrations/README.md

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

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