title: FlywaySqlException: Unable to insert row for version `11` in Schema History table `schema_version`: Field `version_rank` doesn't have a default value
body: <p>I'm getting this error when running my Spring Boot app with a new migration. It has worked for 10 migrations so far. The field does indeed not have a default value. There shouldn't be a need for a default because Flyway should be inserting the value 11 in that field. </p>
  
  <pre><code>Caused by: org.flywaydb.core.internal.exception.FlywaySqlException:
  Unable to insert row for version '11' in Schema History table `app`.`schema_version`
  --------------------------------------------------------------------------------------------
  SQL State  : HY000
  Error Code : 1364
  Message    : Field 'version_rank' doesn't have a default value
  
      at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.doAddAppliedMigration(JdbcTableSchemaHistory.java:174) ~[flyway-core-5.1.4.jar:na]
      at org.flywaydb.core.internal.schemahistory.SchemaHistory.addAppliedMigration(SchemaHistory.java:170) ~[flyway-core-5.1.4.jar:na]
      at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:299) ~[flyway-core-5.1.4.jar:na]
      at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:244) ~[flyway-core-5.1.4.jar:na]
      at org.flywaydb.core.internal.command.DbMigrate.access$100(DbMigrate.java:53) ~[flyway-core-5.1.4.jar:na]
      at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:163) ~[flyway-core-5.1.4.jar:na]
      at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:160) ~[flyway-core-5.1.4.jar:na]
      at org.flywaydb.core.internal.database.mysql.MySQLNamedLockTemplate.execute(MySQLNamedLockTemplate.java:60) ~[flyway-core-5.1.4.jar:na]
      at org.flywaydb.core.internal.database.mysql.MySQLConnection.lock(MySQLConnection.java:80) ~[flyway-core-5.1.4.jar:na]
      at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:150) ~[flyway-core-5.1.4.jar:na]
  </code></pre>
  
  <code>pom.xml</code>
  
  <pre><code>&lt;dependency&gt;
    &lt;groupId&gt;org.flywaydb&lt;/groupId&gt;
    &lt;artifactId&gt;flyway-core&lt;/artifactId&gt;
    &lt;version&gt;5.1.4&lt;/version&gt;&lt;!--$NO-MVN-MAN-VER$--&gt;
  &lt;/dependency&gt;
  </code></pre>
  
  <code>application.properties</code>
  
  <pre><code># Prevent complaints when starting migrations with existing tables.
  flyway.baselineOnMigrate = true
  flyway.table=schema_version
  </code></pre>
  
  <code>schema_version</code>
  
  <pre><code>| Field          | Type          | Null | Key | Default           | Extra |
  +----------------+---------------+------+-----+-------------------+-------+
  | version_rank   | int(11)       | NO   | MUL | NULL              |       |
  | installed_rank | int(11)       | NO   | MUL | NULL              |       |
  | version        | varchar(50)   | NO   | PRI | NULL              |       |
  | description    | varchar(200)  | NO   |     | NULL              |       |
  | type           | varchar(20)   | NO   |     | NULL              |       |
  | script         | varchar(1000) | NO   |     | NULL              |       |
  | checksum       | int(11)       | YES  |     | NULL              |       |
  | installed_by   | varchar(100)  | NO   |     | NULL              |       |
  | installed_on   | timestamp     | NO   |     | CURRENT_TIMESTAMP |       |
  | execution_time | int(11)       | NO   |     | NULL              |       |
  | success        | tinyint(1)    | NO   | MUL | NULL              |       |
  </code></pre>
  
  <p>How am I going to create a migration to add a default value if the migrations don't even work?</p>
  
  <p>Flyway 5.1.4, Spring Boot 5.1.13, mysql  Ver 15.1 Distrib 10.1.30-MariaDB, for CYGWIN (i686)</p>