mod/src/main/kotlin/moe/nea/ledger/database/DBLogEntry.kt


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

package moe.nea.ledger.database

import moe.nea.ledger.ItemChange
import moe.nea.ledger.ItemId
import moe.nea.ledger.TransactionType
import moe.nea.ledger.database.columns.DBDouble
import moe.nea.ledger.database.columns.DBEnum
import moe.nea.ledger.database.columns.DBString
import moe.nea.ledger.database.columns.DBUlid
import moe.nea.ledger.database.columns.DBUuid

object DBLogEntry : Table("LogEntry") {
	val transactionId = column("transactionId", DBUlid)
	val type = column("type", DBEnum<TransactionType>())
	val profileId = column("profileId", DBUuid)
	val playerId = column("playerId", DBUuid)
}

object DBItemEntry : Table("ItemEntry") {
	val transactionId = column("transactionId", DBUlid) // TODO: add foreign keys
	val mode = column("mode", DBEnum<ItemChange.ChangeDirection>())
	val itemId = column("item", DBString.mapped(ItemId::string, ::ItemId))
	val size = column("size", DBDouble)
}