We need to reset our Flyway history due to major DB refactoring. All changes would be squashed into a single that creates a base schema to be able to recreate database from scratch.
But we don't want conflicts with existing tables in production.
There are a lot of questions in DB and SQL topic. I put here some simple and tricky ones.