We are using Flyway for DB migration as part of CI/CD process.
We are creating a new file with latest version number while merging with main branch. There will be a conflict when other developer uses the same version there will be a conflict and second person need to create a new file with updated Version number and merge with main branch.
Is there a better process (automated process) to assign unique version number?