models

type Activity struct {
	gorm.Model
	Message       string `gorm:"type:varchar(160);not null"`
	GameAccount   *GameAccount
	GameAccountID int
	Session       *Session
	SessionID     int
}

type GameAccount struct {
	gorm.Model
	UID        int `gorm:"type:varchar(69);not null;unique;unique_index;primary_key"`
	Level      int `gorm:"type:varchar(6);not null"`
	LastActive int
	User       *User `gorm:"not null"`
	UserID     int
	Banned     bool
	Activities []*Activity `gorm:"many2many:game_activities;"`
}

type Serial struct {
	gorm.Model
	Code                 string `gorm:"type:varchar(69);not null;unique;unique_index;primary_key"`
	ExpireAt             int64  `gorm:"not null"`
	SubscriptionDuration int    `gorm:"default:30;not null"`
	Used                 bool   `gorm:"default:false;not null"`
	User                 *User
	UserID               int
}

type Session struct {
	gorm.Model
	SessionID    string `gorm:"type:varchar(69);not null;unique;unique_index;primary_key"`
	LastActive   int    `gorm:"default:0;not null"`
	UserAgent    string `gorm:"type:varchar(180);not null"`
	User         *User  `gorm:"not null"`
	UserID       int
	Expired      bool
	Activities   []*Activity    `gorm:"many2many:session_activities;"`
	GameAccounts []*GameAccount `gorm:"many2many:session_accounts;"`
}

type Setting struct {
	gorm.Model
	Name   string `gorm:"type:varchar(16);not null"`
	User   *User  `gorm:"not null"`
	UserID int
}

type User struct {
	gorm.Model
	Username     string         `gorm:"type:varchar(32);not null;unique;unique_index;primary_key"`
	Email        string         `gorm:"type:varchar(69);not null;unique;"`
	Password     string         `gorm:"not null"`
	Subscription int64          `gorm:"default:0"`
	Role         string         `gorm:"type:varchar(16);default:'Member';not null;"`
	GameAccounts []*GameAccount `gorm:"many2many:user_accounts;"`
	Settings     []*Setting
	Sessions     []*Session
}