Best practice: How to modify flyway migration script after it has been used

The first rule is don’t.

The second one is do it very carefully and use Flyway.repair() to realign the checksums in the DB with the ones on disk.