Hi! I'm getting this very annoying exception: ``` Caused by: java.sql.SQLException: Multiple primary...

# exposed

[wouterdoeland]

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.

[tapac]

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

[wouterdoeland]

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()
}

[tapac]

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.