Updating Schema History table for Flyway

The default version history table for Flyway has been changed to {schemaname}.flyway_schema_history from Flyway 7.0 onwards. However, for backwards compatibility, we need to set it to fallback to the previous table name {schemaname}.schema_version.

Steps to update

1. Go the the flyway configuration file.
2. On MacOS, it can be found under the following directory – ‘usr/local/Cellar/flyway/7.2.0/libexec/conf/flyway.conf‘.
3. Find the code block flyway.table and assign the name schema_version to it.
4. Save the file and run flyway.