models

type AssetPackages struct {
	Id               int64     `xorm:"'id' pk autoincr notnull"`
	AssetID          string    `xorm:"'asset_id' not null index(par_ind) VARCHAR(50)"`
	AssetApiKey      string    `xorm:"'asset_apikey' unique VARCHAR(30)"`
	AssetName        string    `xorm:"'asset_name' VARCHAR(75)"`
	AssetVersion     string    `xorm:"'asset_version' VARCHAR(75)"`
	AssetReplaced    bool      `xorm:"'asset_replaced' NOT NULL DEFAULT 0"`
	AssetReplaceDate time.Time `xorm:"'asset_replace_date'"`
	Purdate          time.Time `xorm:"'purdate'"`
	Verifydate       time.Time `xorm:"'verifydate' created"`
}

type AssetPackagesDataAccessObject struct{}

type AvailableRoles struct {
	Roles discordgo.Roles
}

type DiscordRoles struct {
	Id       int64
	RoleID   string `xorm:"'role_id' not null index(par_ind) VARCHAR(50)"`
	RoleName string `xorm:"'role_name' unique VARCHAR(30)"`
}

type InvoiceDataAccessObject struct{}

type Invoices struct {
	PriceExvat   string    `json:"price_exvat"`
	Downloaded   string    `json:"downloaded"`
	Date         time.Time `json:"date"`
	Quantity     string    `json:"quantity"`
	Reason       string    `json:"reason"`
	OtherLicense string    `json:"other_license"`
	Package      string    `json:"package"`
	Currency     string    `json:"currency"`
	Refunded     string    `json:"refunded"`
	Invoice      string    `json:"invoice"`
}

type PermissionDataAccessObject struct{}

type UserPackages struct {
	Id         int64     `xorm:"'id' index(fk_verified_users_id_idx) INT(10)"`
	Username   string    `xorm:"'username' not null index(par_ind) VARCHAR(50)"`
	Invoice    string    `xorm:"'invoice' unique VARCHAR(15)"`
	Packages   string    `xorm:"'packages' VARCHAR(75)"`
	Purdate    time.Time `xorm:"'purdate'"`
	Verifydate time.Time `xorm:"'verifydate' created"`
}

type UserPackagesDataAccessObject struct{}

type UserPackagesDetail struct {
	VerifiedUsers `xorm:"extends"`
	UserPackages  `xorm:"extends"`
}

type VerifiedUserDataAccessObject struct{}

type VerifiedUsers struct {
	Id       int64
	Username string `xorm:"'username' not null index VARCHAR(50)"`
	Email    string `xorm:"'email' VARCHAR(75)"`
}