Hi! I'm getting this very annoying exception: ``` ...
# exposed
w
Hi! I'm getting this very annoying exception:
Copy code
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.
t
Could you show your table definition and on which database you run that code?
w
Running in MariaDB (so basically MySQL syntax). This is the table defenition:
Copy code
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()
}
t
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.