How can you create a table that has two unique constraints? I've found this issue: https://github.com/JetBrains/Exposed/issues/239 And after updating the code to the newer Exposed version... it works on PostgreSQL (yay!) but it fails on SQLite with the following error:

Exception in thread "main" org.jetbrains.exposed.exceptions.UnsupportedByDialectException: Auto-increment could be applied only to primary key column, dialect: sqlite.

Here's the table:

object Abc : LongIdTable() {
    val user = long("user")
    val user2 = long("user2")

    override val primaryKey = PrimaryKey(id, user, user2)
}

So... is that an Exposed issue? Because I have no idea why it thinks it is a auto increment column. The only auto increment column is the "id" but it is also being included as a PrimaryKey

Sqlite have hidden column with autoinc primary key, called RAWID

what I ended up doing was using H2 instead of SQLite ^-^