Hi! I'm getting this very annoying exception:

Caused by: java.sql.SQLException: Multiple primary key defined
Query is: ALTER TABLE Clans MODIFY COLUMN id INT AUTO_INCREMENT PRIMARY KEY

Does anyone know why this is happening? This happens everytime I run

SchemaUtils.createMissingTablesAndColumns(Clans)

with Clans or with any other table.

Could you show your table definition and on which database you run that code?

Running in MariaDB (so basically MySQL syntax). This is the table defenition:

object Clans: IntIdTable() {
    val name = varchar("name", MAX_VARCHAR_LENGTH).uniqueIndex()
    val owner = reference("owner", Players).uniqueIndex()
    val open = bool("open").default(false)
    val timestamp = timestamp()
}

There is still no full support for MariaDB. I think that it should be easy to implement it, so going to look for it next week.