sql

type AuthProvider struct {
	ID string
}

type AuthProviderRequest struct {
	ID      uuid.UUID
	Options []byte
}

type AuthRefreshToken struct {
	ID               uuid.UUID
	CreatedAt        pgtype.Timestamptz
	ExpiresAt        pgtype.Timestamptz
	UserID           uuid.UUID
	Metadata         []byte
	Type             RefreshTokenType
	RefreshTokenHash pgtype.Text
}

type AuthRefreshTokenType struct {
	Value   string
	Comment pgtype.Text
}

type AuthRole struct {
	Role string
}

type AuthSchemaMigration struct {
	Version int64
	Dirty   bool
}

type AuthUser struct {
	ID                       uuid.UUID
	CreatedAt                pgtype.Timestamptz
	UpdatedAt                pgtype.Timestamptz
	LastSeen                 pgtype.Timestamptz
	Disabled                 bool
	DisplayName              string
	AvatarUrl                string
	Locale                   string
	Email                    pgtype.Text
	PhoneNumber              pgtype.Text
	PasswordHash             pgtype.Text
	EmailVerified            bool
	PhoneNumberVerified      bool
	NewEmail                 pgtype.Text
	OtpMethodLastUsed        pgtype.Text
	OtpHash                  pgtype.Text
	OtpHashExpiresAt         pgtype.Timestamptz
	DefaultRole              string
	IsAnonymous              bool
	TotpSecret               pgtype.Text
	ActiveMfaType            pgtype.Text
	Ticket                   pgtype.Text
	TicketExpiresAt          pgtype.Timestamptz
	Metadata                 []byte
	WebauthnCurrentChallenge pgtype.Text
}

type AuthUserProvider struct {
	ID             uuid.UUID
	CreatedAt      pgtype.Timestamptz
	UpdatedAt      pgtype.Timestamptz
	UserID         uuid.UUID
	AccessToken    string
	RefreshToken   pgtype.Text
	ProviderID     string
	ProviderUserID string
}

type AuthUserRole struct {
	ID        uuid.UUID
	CreatedAt pgtype.Timestamptz
	UserID    uuid.UUID
	Role      string
}

type AuthUserSecurityKey struct {
	ID                  uuid.UUID
	UserID              uuid.UUID
	CredentialID        string
	CredentialPublicKey []byte
	Counter             int64
	Transports          string
	Nickname            pgtype.Text
}

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type FindUserProviderByProviderIdParams struct {
	ProviderUserID string
	ProviderID     string
}

type GetUserByEmailAndTicketParams struct {
	Email  pgtype.Text
	Ticket pgtype.Text
}

type GetUserByPhoneNumberAndOTPParams struct {
	PhoneNumber pgtype.Text
	Otp         string
}

type GetUserByProviderIDParams struct {
	ProviderUserID string
	ProviderID     string
}

type GetUserByRefreshTokenHashParams struct {
	RefreshTokenHash pgtype.Text
	Type             RefreshTokenType
}

type InsertRefreshtokenParams struct {
	UserID           uuid.UUID
	RefreshTokenHash pgtype.Text
	ExpiresAt        pgtype.Timestamptz
	Type             RefreshTokenType
	Metadata         []byte
}

type InsertSecurityKeyParams struct {
	UserID              uuid.UUID
	CredentialID        string
	CredentialPublicKey []byte
	Nickname            pgtype.Text
}

type InsertUserParams struct {
	ID                uuid.UUID
	Disabled          bool
	DisplayName       string
	AvatarUrl         string
	PhoneNumber       pgtype.Text
	Roles             []string
	Otp               string
	OtpMethodLastUsed pgtype.Text
	Email             pgtype.Text
	PasswordHash      pgtype.Text
	Ticket            pgtype.Text
	TicketExpiresAt   pgtype.Timestamptz
	EmailVerified     bool
	Locale            string
	DefaultRole       string
	Metadata          []byte
	OtpHashExpiresAt  pgtype.Timestamptz
}

type InsertUserProviderParams struct {
	UserID         uuid.UUID
	ProviderID     string
	ProviderUserID string
}

type InsertUserRow struct {
	UserID    uuid.UUID
	CreatedAt pgtype.Timestamptz
}

type InsertUserWithRefreshTokenParams struct {
	Disabled              bool
	DisplayName           string
	AvatarUrl             string
	Email                 pgtype.Text
	PasswordHash          pgtype.Text
	Ticket                pgtype.Text
	TicketExpiresAt       pgtype.Timestamptz
	EmailVerified         bool
	Locale                string
	DefaultRole           string
	IsAnonymous           bool
	Metadata              []byte
	RefreshTokenHash      pgtype.Text
	RefreshTokenExpiresAt pgtype.Timestamptz
	Roles                 []string
}

type InsertUserWithRefreshTokenRow struct {
	ID             uuid.UUID
	RefreshTokenID uuid.UUID
}

type InsertUserWithSecurityKeyAndRefreshTokenParams struct {
	ID                    uuid.UUID
	Disabled              bool
	DisplayName           string
	AvatarUrl             string
	Email                 pgtype.Text
	Ticket                pgtype.Text
	TicketExpiresAt       pgtype.Timestamptz
	EmailVerified         bool
	Locale                string
	DefaultRole           string
	Metadata              []byte
	RefreshTokenHash      pgtype.Text
	RefreshTokenExpiresAt pgtype.Timestamptz
	CredentialID          string
	CredentialPublicKey   []byte
	Nickname              pgtype.Text
	Roles                 []string
}

type InsertUserWithSecurityKeyAndRefreshTokenRow struct {
	ID             uuid.UUID
	RefreshTokenID uuid.UUID
}

type InsertUserWithSecurityKeyParams struct {
	ID                  uuid.UUID
	Disabled            bool
	DisplayName         string
	AvatarUrl           string
	Email               pgtype.Text
	Ticket              pgtype.Text
	TicketExpiresAt     pgtype.Timestamptz
	EmailVerified       bool
	Locale              string
	DefaultRole         string
	Metadata            []byte
	Roles               []string
	CredentialID        string
	CredentialPublicKey []byte
	Nickname            pgtype.Text
}

type InsertUserWithUserProviderAndRefreshTokenParams struct {
	ID                    uuid.UUID
	Disabled              bool
	DisplayName           string
	AvatarUrl             string
	Email                 pgtype.Text
	Ticket                pgtype.Text
	TicketExpiresAt       pgtype.Timestamptz
	EmailVerified         bool
	Locale                string
	DefaultRole           string
	Metadata              []byte
	RefreshTokenHash      pgtype.Text
	RefreshTokenExpiresAt pgtype.Timestamptz
	ProviderID            string
	ProviderUserID        string
	Roles                 []string
}

type InsertUserWithUserProviderAndRefreshTokenRow struct {
	ID             uuid.UUID
	RefreshTokenID uuid.UUID
}

type InsertUserWithUserProviderParams struct {
	ID              uuid.UUID
	Disabled        bool
	DisplayName     string
	AvatarUrl       string
	Email           pgtype.Text
	Ticket          pgtype.Text
	TicketExpiresAt pgtype.Timestamptz
	EmailVerified   bool
	Locale          string
	DefaultRole     string
	Metadata        []byte
	Roles           []string
	ProviderID      string
	ProviderUserID  string
}

type Queries struct {
	// contains filtered or unexported fields
}

type RefreshTokenAndGetUserRolesParams struct {
	NewRefreshTokenHash pgtype.Text
	ExpiresAt           pgtype.Timestamptz
	OldRefreshTokenHash pgtype.Text
}

type RefreshTokenAndGetUserRolesRow struct {
	RefreshTokenID uuid.UUID
	Role           pgtype.Text
}

type RefreshTokenType string

type UpdateUserActiveMFATypeParams struct {
	ID            uuid.UUID
	ActiveMfaType pgtype.Text
}

type UpdateUserChangeEmailParams struct {
	ID              uuid.UUID
	Ticket          pgtype.Text
	TicketExpiresAt pgtype.Timestamptz
	NewEmail        pgtype.Text
}

type UpdateUserChangePasswordParams struct {
	ID           uuid.UUID
	PasswordHash pgtype.Text
}

type UpdateUserDeanonymizeParams struct {
	Roles           []string
	Email           interface{}
	DefaultRole     pgtype.Text
	DisplayName     pgtype.Text
	Locale          pgtype.Text
	Metadata        []byte
	PasswordHash    pgtype.Text
	Ticket          pgtype.Text
	TicketExpiresAt pgtype.Timestamptz
	ID              pgtype.UUID
}

type UpdateUserOTPHashParams struct {
	ID                uuid.UUID
	Otp               string
	OtpHashExpiresAt  pgtype.Timestamptz
	OtpMethodLastUsed pgtype.Text
}

type UpdateUserTicketParams struct {
	ID              uuid.UUID
	Ticket          pgtype.Text
	TicketExpiresAt pgtype.Timestamptz
}

type UpdateUserTotpSecretParams struct {
	ID         uuid.UUID
	TotpSecret pgtype.Text
}