https://kotlinlang.org logo
#exposed
Title
# exposed
w

wouterdoeland

02/23/2018, 8:20 AM
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

tapac

02/23/2018, 4:52 PM
Could you show your table definition and on which database you run that code?
w

wouterdoeland

02/24/2018, 10:16 AM
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

tapac

02/24/2018, 6:42 PM
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.
3 Views