migrations

This repo stores the SQL migrations used by the ORY Hydra (login system) database.

Development

Logic

This uses flyway for managing SQL migrations.

Running

Set the following environment variables in the .env file:

• POSTGRES_URL
• POSTGRES_LOGIN_DB: ORY Hydra database.
• POSTGRES_USER
• POSTGRES_PASSWORD

And then run the Docker file:

docker build -t migrations . && docker run --rm --env-file .env --name migrations-standalone migrations

This will run all migrations in the target database. In case the database is up to date no migrations will be executed. In case the database was updated manually since the last migration you will need to update the checksum of the latest migration in the flyway_schema_history to match the checksum flyway is expecting.