Migrations should never create the dirty flag in the schema_migrations table

[timbastin]

I already spent some time on this one. I was actually sure, that this is fixed already.

Nevertheles, minutes ago I did a devguard deployment which failed because of the dirty flag in schema_migrations table.

Reproduce:

• Create a new migration which is WRONG - syntax error or something like this
• Use go run ./cmd/devguard-cli migrate or just make migrate
  • The migration should fail
  • Do exactly the same again, it should try it again and it should not stop with the error: "Cant migrate because schema is dirty"