veza/veza-backend-api/migrations/000_mark_consolidated.sql

9 lines
458 B
MySQL
Raw Permalink Normal View History

-- Mark existing database as consolidated (v0→v0.803 migrations already applied).
-- Run manually on DBs that have been migrated with migrations 001_..122_.
-- Usage: psql $DATABASE_URL -f veza-backend-api/migrations/000_mark_consolidated.sql
-- See docs/MIGRATION_CONSOLIDATION.md for full procedure.
INSERT INTO schema_migrations (version)
SELECT '000_consolidated'
WHERE NOT EXISTS (SELECT 1 FROM schema_migrations WHERE version = '000_consolidated');