queries

type ClearScenePerformerAliasParams struct {
	PerformerID uuid.UUID `db:"performer_id" json:"performer_id"`
	As          *string   `db:"as" json:"as"`
}

type CountNotificationsByUserParams struct {
	UserID     uuid.UUID            `db:"user_id" json:"user_id"`
	UnreadOnly bool                 `db:"unread_only" json:"unread_only"`
	Type       NullNotificationType `db:"type" json:"type"`
}

type CountUserEditsByStatusRow struct {
	Status string `db:"status" json:"status"`
	Count  int64  `db:"count" json:"count"`
}

type CountVotesByTypeRow struct {
	Vote  string `db:"vote" json:"vote"`
	Count int64  `db:"count" json:"count"`
}

type CreateDraftParams struct {
	ID     uuid.UUID       `db:"id" json:"id"`
	UserID uuid.UUID       `db:"user_id" json:"user_id"`
	Type   string          `db:"type" json:"type"`
	Data   json.RawMessage `db:"data" json:"data"`
}

type CreateEditCommentParams struct {
	ID     uuid.UUID     `db:"id" json:"id"`
	EditID uuid.UUID     `db:"edit_id" json:"edit_id"`
	UserID uuid.NullUUID `db:"user_id" json:"user_id"`
	Text   string        `db:"text" json:"text"`
}

type CreateEditParams struct {
	ID         uuid.UUID     `db:"id" json:"id"`
	UserID     uuid.NullUUID `db:"user_id" json:"user_id"`
	TargetType string        `db:"target_type" json:"target_type"`
	Operation  string        `db:"operation" json:"operation"`
	Data       []byte        `db:"data" json:"data"`
	Votes      int           `db:"votes" json:"votes"`
	Status     string        `db:"status" json:"status"`
	Applied    bool          `db:"applied" json:"applied"`
	Bot        bool          `db:"bot" json:"bot"`
}

type CreateEditVoteParams struct {
	EditID uuid.UUID `db:"edit_id" json:"edit_id"`
	UserID uuid.UUID `db:"user_id" json:"user_id"`
	Vote   string    `db:"vote" json:"vote"`
}

type CreateFingerprintParams struct {
	Hash      string `db:"hash" json:"hash"`
	Algorithm string `db:"algorithm" json:"algorithm"`
}

type CreateImageParams struct {
	ID       uuid.UUID `db:"id" json:"id"`
	Url      *string   `db:"url" json:"url"`
	Width    int       `db:"width" json:"width"`
	Height   int       `db:"height" json:"height"`
	Checksum string    `db:"checksum" json:"checksum"`
}

type CreateInviteKeyParams struct {
	ID          uuid.UUID  `db:"id" json:"id"`
	GeneratedBy uuid.UUID  `db:"generated_by" json:"generated_by"`
	Uses        *int       `db:"uses" json:"uses"`
	ExpireTime  *time.Time `db:"expire_time" json:"expire_time"`
}

type CreateOrReplaceFingerprintParams struct {
	FingerprintID int       `db:"fingerprint_id" json:"fingerprint_id"`
	SceneID       uuid.UUID `db:"scene_id" json:"scene_id"`
	UserID        uuid.UUID `db:"user_id" json:"user_id"`
	Duration      int       `db:"duration" json:"duration"`
	Vote          int16     `db:"vote" json:"vote"`
}

type CreatePerformerAliasesParams struct {
	PerformerID uuid.UUID `db:"performer_id" json:"performer_id"`
	Alias       string    `db:"alias" json:"alias"`
}

type CreatePerformerEditParams struct {
	EditID      uuid.UUID `db:"edit_id" json:"edit_id"`
	PerformerID uuid.UUID `db:"performer_id" json:"performer_id"`
}

type CreatePerformerFavoriteParams struct {
	PerformerID uuid.UUID `db:"performer_id" json:"performer_id"`
	UserID      uuid.UUID `db:"user_id" json:"user_id"`
}

type CreatePerformerImagesParams struct {
	PerformerID uuid.UUID `db:"performer_id" json:"performer_id"`
	ImageID     uuid.UUID `db:"image_id" json:"image_id"`
}

type CreatePerformerParams struct {
	ID              uuid.UUID              `db:"id" json:"id"`
	Name            string                 `db:"name" json:"name"`
	Disambiguation  *string                `db:"disambiguation" json:"disambiguation"`
	Gender          *models.GenderEnum     `db:"gender" json:"gender"`
	Birthdate       *string                `db:"birthdate" json:"birthdate"`
	Ethnicity       *models.EthnicityEnum  `db:"ethnicity" json:"ethnicity"`
	Country         *string                `db:"country" json:"country"`
	EyeColor        *models.EyeColorEnum   `db:"eye_color" json:"eye_color"`
	HairColor       *models.HairColorEnum  `db:"hair_color" json:"hair_color"`
	Height          *int                   `db:"height" json:"height"`
	CupSize         *string                `db:"cup_size" json:"cup_size"`
	BandSize        *int                   `db:"band_size" json:"band_size"`
	HipSize         *int                   `db:"hip_size" json:"hip_size"`
	WaistSize       *int                   `db:"waist_size" json:"waist_size"`
	BreastType      *models.BreastTypeEnum `db:"breast_type" json:"breast_type"`
	CareerStartYear *int                   `db:"career_start_year" json:"career_start_year"`
	CareerEndYear   *int                   `db:"career_end_year" json:"career_end_year"`
	Deathdate       *string                `db:"deathdate" json:"deathdate"`
}

type CreatePerformerPiercingsParams struct {
	PerformerID uuid.UUID `db:"performer_id" json:"performer_id"`
	Location    *string   `db:"location" json:"location"`
	Description *string   `db:"description" json:"description"`
}

type CreatePerformerRedirectParams struct {
	SourceID uuid.UUID `db:"source_id" json:"source_id"`
	TargetID uuid.UUID `db:"target_id" json:"target_id"`
}

type CreatePerformerTattoosParams struct {
	PerformerID uuid.UUID `db:"performer_id" json:"performer_id"`
	Location    *string   `db:"location" json:"location"`
	Description *string   `db:"description" json:"description"`
}

type CreatePerformerURLsParams struct {
	PerformerID uuid.UUID `db:"performer_id" json:"performer_id"`
	Url         string    `db:"url" json:"url"`
	SiteID      uuid.UUID `db:"site_id" json:"site_id"`
}

type CreateSceneEditParams struct {
	EditID  uuid.UUID `db:"edit_id" json:"edit_id"`
	SceneID uuid.UUID `db:"scene_id" json:"scene_id"`
}

type CreateSceneFingerprintsParams struct {
	FingerprintID int       `db:"fingerprint_id" json:"fingerprint_id"`
	SceneID       uuid.UUID `db:"scene_id" json:"scene_id"`
	UserID        uuid.UUID `db:"user_id" json:"user_id"`
	Duration      int       `db:"duration" json:"duration"`
}

type CreateSceneImagesParams struct {
	SceneID uuid.UUID `db:"scene_id" json:"scene_id"`
	ImageID uuid.UUID `db:"image_id" json:"image_id"`
}

type CreateSceneParams struct {
	ID             uuid.UUID     `db:"id" json:"id"`
	Title          *string       `db:"title" json:"title"`
	Details        *string       `db:"details" json:"details"`
	Date           *string       `db:"date" json:"date"`
	ProductionDate *string       `db:"production_date" json:"production_date"`
	StudioID       uuid.NullUUID `db:"studio_id" json:"studio_id"`
	Duration       *int          `db:"duration" json:"duration"`
	Director       *string       `db:"director" json:"director"`
	Code           *string       `db:"code" json:"code"`
}

type CreateScenePerformersParams struct {
	SceneID     uuid.UUID `db:"scene_id" json:"scene_id"`
	PerformerID uuid.UUID `db:"performer_id" json:"performer_id"`
	As          *string   `db:"as" json:"as"`
}

type CreateSceneRedirectParams struct {
	SourceID uuid.UUID `db:"source_id" json:"source_id"`
	TargetID uuid.UUID `db:"target_id" json:"target_id"`
}

type CreateSceneTagsParams struct {
	SceneID uuid.UUID `db:"scene_id" json:"scene_id"`
	TagID   uuid.UUID `db:"tag_id" json:"tag_id"`
}

type CreateSceneURLsParams struct {
	SceneID uuid.UUID `db:"scene_id" json:"scene_id"`
	Url     string    `db:"url" json:"url"`
	SiteID  uuid.UUID `db:"site_id" json:"site_id"`
}

type CreateSiteParams struct {
	ID          uuid.UUID `db:"id" json:"id"`
	Name        string    `db:"name" json:"name"`
	Description *string   `db:"description" json:"description"`
	Url         *string   `db:"url" json:"url"`
	Regex       *string   `db:"regex" json:"regex"`
	ValidTypes  []string  `db:"valid_types" json:"valid_types"`
}

type CreateStudioAliasesParams struct {
	StudioID uuid.UUID `db:"studio_id" json:"studio_id"`
	Alias    string    `db:"alias" json:"alias"`
}

type CreateStudioEditParams struct {
	EditID   uuid.UUID `db:"edit_id" json:"edit_id"`
	StudioID uuid.UUID `db:"studio_id" json:"studio_id"`
}

type CreateStudioFavoriteParams struct {
	StudioID uuid.UUID `db:"studio_id" json:"studio_id"`
	UserID   uuid.UUID `db:"user_id" json:"user_id"`
}

type CreateStudioImagesParams struct {
	StudioID uuid.UUID `db:"studio_id" json:"studio_id"`
	ImageID  uuid.UUID `db:"image_id" json:"image_id"`
}

type CreateStudioParams struct {
	ID             uuid.UUID     `db:"id" json:"id"`
	Name           string        `db:"name" json:"name"`
	ParentStudioID uuid.NullUUID `db:"parent_studio_id" json:"parent_studio_id"`
}

type CreateStudioRedirectParams struct {
	SourceID uuid.UUID `db:"source_id" json:"source_id"`
	TargetID uuid.UUID `db:"target_id" json:"target_id"`
}

type CreateStudioURLsParams struct {
	StudioID uuid.UUID `db:"studio_id" json:"studio_id"`
	Url      string    `db:"url" json:"url"`
	SiteID   uuid.UUID `db:"site_id" json:"site_id"`
}

type CreateTagAliasesParams struct {
	TagID uuid.UUID `db:"tag_id" json:"tag_id"`
	Alias string    `db:"alias" json:"alias"`
}

type CreateTagCategoryParams struct {
	ID          uuid.UUID `db:"id" json:"id"`
	Group       string    `db:"group" json:"group"`
	Name        string    `db:"name" json:"name"`
	Description *string   `db:"description" json:"description"`
}

type CreateTagEditParams struct {
	EditID uuid.UUID `db:"edit_id" json:"edit_id"`
	TagID  uuid.UUID `db:"tag_id" json:"tag_id"`
}

type CreateTagParams struct {
	ID          uuid.UUID     `db:"id" json:"id"`
	Name        string        `db:"name" json:"name"`
	CategoryID  uuid.NullUUID `db:"category_id" json:"category_id"`
	Description *string       `db:"description" json:"description"`
}

type CreateTagRedirectParams struct {
	SourceID uuid.UUID `db:"source_id" json:"source_id"`
	TargetID uuid.UUID `db:"target_id" json:"target_id"`
}

type CreateUserNotificationSubscriptionsParams struct {
	UserID uuid.UUID        `db:"user_id" json:"user_id"`
	Type   NotificationType `db:"type" json:"type"`
}

type CreateUserParams struct {
	ID           uuid.UUID     `db:"id" json:"id"`
	Name         string        `db:"name" json:"name"`
	PasswordHash string        `db:"password_hash" json:"password_hash"`
	Email        string        `db:"email" json:"email"`
	ApiKey       string        `db:"api_key" json:"api_key"`
	ApiCalls     *int          `db:"api_calls" json:"api_calls"`
	InviteTokens int           `db:"invite_tokens" json:"invite_tokens"`
	InvitedBy    uuid.NullUUID `db:"invited_by" json:"invited_by"`
}

type CreateUserRolesParams struct {
	UserID uuid.UUID `db:"user_id" json:"user_id"`
	Role   string    `db:"role" json:"role"`
}

type CreateUserTokenParams struct {
	ID        uuid.UUID `db:"id" json:"id"`
	Data      []byte    `db:"data" json:"data"`
	Type      string    `db:"type" json:"type"`
	CreatedAt time.Time `db:"created_at" json:"created_at"`
	ExpiresAt time.Time `db:"expires_at" json:"expires_at"`
}

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
	CopyFrom(ctx context.Context, tableName pgx.Identifier, columnNames []string, rowSrc pgx.CopyFromSource) (int64, error)
}

type DeletePerformerFavoriteParams struct {
	PerformerID uuid.UUID `db:"performer_id" json:"performer_id"`
	UserID      uuid.UUID `db:"user_id" json:"user_id"`
}

type DeleteSceneFingerprintParams struct {
	Hash      string    `db:"hash" json:"hash"`
	Algorithm string    `db:"algorithm" json:"algorithm"`
	UserID    uuid.UUID `db:"user_id" json:"user_id"`
	SceneID   uuid.UUID `db:"scene_id" json:"scene_id"`
}

type DeleteStudioFavoriteParams struct {
	StudioID uuid.UUID `db:"studio_id" json:"studio_id"`
	UserID   uuid.UUID `db:"user_id" json:"user_id"`
}

type DeleteTagAliasesByNamesParams struct {
	TagID   uuid.UUID `db:"tag_id" json:"tag_id"`
	Column2 []string  `db:"column_2" json:"column_2"`
}

type Draft struct {
	ID        uuid.UUID       `db:"id" json:"id"`
	UserID    uuid.UUID       `db:"user_id" json:"user_id"`
	Type      string          `db:"type" json:"type"`
	Data      json.RawMessage `db:"data" json:"data"`
	CreatedAt time.Time       `db:"created_at" json:"created_at"`
}

type Edit struct {
	ID          uuid.UUID     `db:"id" json:"id"`
	UserID      uuid.NullUUID `db:"user_id" json:"user_id"`
	Operation   string        `db:"operation" json:"operation"`
	TargetType  string        `db:"target_type" json:"target_type"`
	Data        []byte        `db:"data" json:"data"`
	Votes       int           `db:"votes" json:"votes"`
	Status      string        `db:"status" json:"status"`
	Applied     bool          `db:"applied" json:"applied"`
	CreatedAt   time.Time     `db:"created_at" json:"created_at"`
	UpdatedAt   *time.Time    `db:"updated_at" json:"updated_at"`
	ClosedAt    *time.Time    `db:"closed_at" json:"closed_at"`
	Bot         bool          `db:"bot" json:"bot"`
	UpdateCount int           `db:"update_count" json:"update_count"`
}

type EditComment struct {
	ID        uuid.UUID     `db:"id" json:"id"`
	EditID    uuid.UUID     `db:"edit_id" json:"edit_id"`
	UserID    uuid.NullUUID `db:"user_id" json:"user_id"`
	CreatedAt time.Time     `db:"created_at" json:"created_at"`
	Text      string        `db:"text" json:"text"`
}

type EditVote struct {
	EditID    uuid.UUID `db:"edit_id" json:"edit_id"`
	UserID    uuid.UUID `db:"user_id" json:"user_id"`
	CreatedAt time.Time `db:"created_at" json:"created_at"`
	Vote      string    `db:"vote" json:"vote"`
}

type FindCompletedEditsParams struct {
	VotingPeriod        interface{} `db:"voting_period" json:"voting_period"`
	MinimumVotes        int         `db:"minimum_votes" json:"minimum_votes"`
	MinimumVotingPeriod interface{} `db:"minimum_voting_period" json:"minimum_voting_period"`
}

type FindExistingPerformersParams struct {
	Name           *string  `db:"name" json:"name"`
	Disambiguation *string  `db:"disambiguation" json:"disambiguation"`
	Urls           []string `db:"urls" json:"urls"`
}

type FindExistingScenesParams struct {
	Title    *string       `db:"title" json:"title"`
	StudioID uuid.NullUUID `db:"studio_id" json:"studio_id"`
	Hashes   []string      `db:"hashes" json:"hashes"`
}

type FindMergeIDsByPerformerIdsRow struct {
	PerformerID uuid.UUID `db:"performer_id" json:"performer_id"`
	MergeID     uuid.UUID `db:"merge_id" json:"merge_id"`
}

type FindMergeIDsBySourcePerformerIdsRow struct {
	PerformerID uuid.UUID `db:"performer_id" json:"performer_id"`
	MergeID     uuid.UUID `db:"merge_id" json:"merge_id"`
}

type FindNotificationsByUserParams struct {
	UserID uuid.UUID            `db:"user_id" json:"user_id"`
	Limit  int32                `db:"limit" json:"limit"`
	Offset int32                `db:"offset" json:"offset"`
	Type   NullNotificationType `db:"type" json:"type"`
}

type FindPendingPerformerCreationParams struct {
	Name *string  `db:"name" json:"name"`
	Urls []string `db:"urls" json:"urls"`
}

type FindPendingSceneCreationParams struct {
	Title    *string       `db:"title" json:"title"`
	StudioID uuid.NullUUID `db:"studio_id" json:"studio_id"`
	Hashes   []string      `db:"hashes" json:"hashes"`
}

type FindPerformerFavoritesByIdsParams struct {
	PerformerIds []uuid.UUID `db:"performer_ids" json:"performer_ids"`
	UserID       uuid.UUID   `db:"user_id" json:"user_id"`
}

type FindPerformerFavoritesByIdsRow struct {
	PerformerID uuid.UUID `db:"performer_id" json:"performer_id"`
	IsFavorite  bool      `db:"is_favorite" json:"is_favorite"`
}

type FindPerformersByURLParams struct {
	Url   *string `db:"url" json:"url"`
	Limit int32   `db:"limit" json:"limit"`
}

type FindSceneAppearancesByIdsRow struct {
	SceneID     uuid.UUID `db:"scene_id" json:"scene_id"`
	PerformerID uuid.UUID `db:"performer_id" json:"performer_id"`
	As          *string   `db:"as" json:"as"`
}

type FindSceneByURLParams struct {
	Url   *string `db:"url" json:"url"`
	Limit int32   `db:"limit" json:"limit"`
}

type FindScenesByFingerprintParams struct {
	Hash      string `db:"hash" json:"hash"`
	Algorithm string `db:"algorithm" json:"algorithm"`
}

type FindScenesByFullFingerprintsParams struct {
	Phashes  []int64  `db:"phashes" json:"phashes"`
	Distance int      `db:"distance" json:"distance"`
	Hashes   []string `db:"hashes" json:"hashes"`
}

type FindScenesByFullFingerprintsWithHashParams struct {
	Phashes  []int64  `db:"phashes" json:"phashes"`
	Distance int      `db:"distance" json:"distance"`
	Hashes   []string `db:"hashes" json:"hashes"`
}

type FindScenesByFullFingerprintsWithHashRow struct {
	Scene Scene  `db:"scene" json:"scene"`
	Hash  string `db:"hash" json:"hash"`
}

type FindStudioFavoritesByIdsParams struct {
	StudioIds []uuid.UUID `db:"studio_ids" json:"studio_ids"`
	UserID    uuid.UUID   `db:"user_id" json:"user_id"`
}

type FindStudioFavoritesByIdsRow struct {
	StudioID   uuid.UUID `db:"studio_id" json:"studio_id"`
	IsFavorite bool      `db:"is_favorite" json:"is_favorite"`
}

type FindUnreadNotificationsByUserParams struct {
	UserID uuid.UUID            `db:"user_id" json:"user_id"`
	Limit  int32                `db:"limit" json:"limit"`
	Offset int32                `db:"offset" json:"offset"`
	Type   NullNotificationType `db:"type" json:"type"`
}

type Fingerprint struct {
	ID        int    `db:"id" json:"id"`
	Hash      string `db:"hash" json:"hash"`
	Algorithm string `db:"algorithm" json:"algorithm"`
}

type GetAllFingerprintsParams struct {
	CurrentUserID uuid.UUID     `db:"current_user_id" json:"current_user_id"`
	SceneIds      []uuid.UUID   `db:"scene_ids" json:"scene_ids"`
	FilterUserID  uuid.NullUUID `db:"filter_user_id" json:"filter_user_id"`
}

type GetAllFingerprintsRow struct {
	SceneID        uuid.UUID `db:"scene_id" json:"scene_id"`
	Hash           string    `db:"hash" json:"hash"`
	Algorithm      string    `db:"algorithm" json:"algorithm"`
	Duration       int       `db:"duration" json:"duration"`
	Submissions    int64     `db:"submissions" json:"submissions"`
	Reports        int64     `db:"reports" json:"reports"`
	NetSubmissions int64     `db:"net_submissions" json:"net_submissions"`
	CreatedAt      time.Time `db:"created_at" json:"created_at"`
	UpdatedAt      time.Time `db:"updated_at" json:"updated_at"`
	UserSubmitted  bool      `db:"user_submitted" json:"user_submitted"`
	UserReported   bool      `db:"user_reported" json:"user_reported"`
}

type GetAllSceneFingerprintsRow struct {
	Algorithm string    `db:"algorithm" json:"algorithm"`
	Hash      string    `db:"hash" json:"hash"`
	Duration  int       `db:"duration" json:"duration"`
	CreatedAt time.Time `db:"created_at" json:"created_at"`
	UserID    uuid.UUID `db:"user_id" json:"user_id"`
}

type GetEditPerformerPiercingsRow struct {
	Location    *string `db:"location" json:"location"`
	Description *string `db:"description" json:"description"`
}

type GetEditPerformerTattoosRow struct {
	Location    *string `db:"location" json:"location"`
	Description *string `db:"description" json:"description"`
}

type GetEditTargetIDRow struct {
	ID         uuid.UUID `db:"id" json:"id"`
	TargetType string    `db:"target_type" json:"target_type"`
}

type GetFingerprintParams struct {
	Hash      string `db:"hash" json:"hash"`
	Algorithm string `db:"algorithm" json:"algorithm"`
}

type GetMergedPerformersForEditRow struct {
	Performer Performer `db:"performer" json:"performer"`
	As        *string   `db:"as" json:"as"`
}

type GetMergedURLsForEditRow struct {
	Url    string    `db:"url" json:"url"`
	SiteID uuid.UUID `db:"site_id" json:"site_id"`
}

type GetPerformerPiercingsRow struct {
	Location    *string `db:"location" json:"location"`
	Description *string `db:"description" json:"description"`
}

type GetPerformerTattoosRow struct {
	Location    *string `db:"location" json:"location"`
	Description *string `db:"description" json:"description"`
}

type GetPerformerURLsRow struct {
	Url    string    `db:"url" json:"url"`
	SiteID uuid.UUID `db:"site_id" json:"site_id"`
}

type GetScenePerformersRow struct {
	Performer Performer `db:"performer" json:"performer"`
	As        *string   `db:"as" json:"as"`
}

type GetSceneURLsRow struct {
	Url    string    `db:"url" json:"url"`
	SiteID uuid.UUID `db:"site_id" json:"site_id"`
}

type GetStudiosByPerformerRow struct {
	Studio     Studio `db:"studio" json:"studio"`
	SceneCount int64  `db:"scene_count" json:"scene_count"`
}

type Image struct {
	ID       uuid.UUID `db:"id" json:"id"`
	Url      *string   `db:"url" json:"url"`
	Width    int       `db:"width" json:"width"`
	Height   int       `db:"height" json:"height"`
	Checksum string    `db:"checksum" json:"checksum"`
}

type InviteKey struct {
	ID          uuid.UUID  `db:"id" json:"id"`
	GeneratedBy uuid.UUID  `db:"generated_by" json:"generated_by"`
	GeneratedAt time.Time  `db:"generated_at" json:"generated_at"`
	Uses        *int       `db:"uses" json:"uses"`
	ExpireTime  *time.Time `db:"expire_time" json:"expire_time"`
}

type MarkNotificationReadParams struct {
	UserID uuid.UUID        `db:"user_id" json:"user_id"`
	Type   NotificationType `db:"type" json:"type"`
	ID     uuid.UUID        `db:"id" json:"id"`
}

type Notification struct {
	UserID    uuid.UUID        `db:"user_id" json:"user_id"`
	Type      NotificationType `db:"type" json:"type"`
	ID        uuid.UUID        `db:"id" json:"id"`
	CreatedAt time.Time        `db:"created_at" json:"created_at"`
	ReadAt    *time.Time       `db:"read_at" json:"read_at"`
}

type NotificationType string

type NullNotificationType struct {
	NotificationType NotificationType `json:"notification_type"`
	Valid            bool             `json:"valid"` // Valid is true if NotificationType is not NULL
}

type Performer struct {
	ID              uuid.UUID              `db:"id" json:"id"`
	Name            string                 `db:"name" json:"name"`
	Disambiguation  *string                `db:"disambiguation" json:"disambiguation"`
	Gender          *models.GenderEnum     `db:"gender" json:"gender"`
	Ethnicity       *models.EthnicityEnum  `db:"ethnicity" json:"ethnicity"`
	Country         *string                `db:"country" json:"country"`
	EyeColor        *models.EyeColorEnum   `db:"eye_color" json:"eye_color"`
	HairColor       *models.HairColorEnum  `db:"hair_color" json:"hair_color"`
	Height          *int                   `db:"height" json:"height"`
	CupSize         *string                `db:"cup_size" json:"cup_size"`
	BandSize        *int                   `db:"band_size" json:"band_size"`
	HipSize         *int                   `db:"hip_size" json:"hip_size"`
	WaistSize       *int                   `db:"waist_size" json:"waist_size"`
	BreastType      *models.BreastTypeEnum `db:"breast_type" json:"breast_type"`
	CareerStartYear *int                   `db:"career_start_year" json:"career_start_year"`
	CareerEndYear   *int                   `db:"career_end_year" json:"career_end_year"`
	CreatedAt       time.Time              `db:"created_at" json:"created_at"`
	UpdatedAt       time.Time              `db:"updated_at" json:"updated_at"`
	Deleted         bool                   `db:"deleted" json:"deleted"`
	Birthdate       *string                `db:"birthdate" json:"birthdate"`
	Deathdate       *string                `db:"deathdate" json:"deathdate"`
}

type PerformerAlias struct {
	PerformerID uuid.UUID `db:"performer_id" json:"performer_id"`
	Alias       string    `db:"alias" json:"alias"`
}

type PerformerEdit struct {
	EditID      uuid.UUID `db:"edit_id" json:"edit_id"`
	PerformerID uuid.UUID `db:"performer_id" json:"performer_id"`
}

type PerformerFavorite struct {
	PerformerID uuid.UUID  `db:"performer_id" json:"performer_id"`
	UserID      uuid.UUID  `db:"user_id" json:"user_id"`
	CreatedAt   *time.Time `db:"created_at" json:"created_at"`
}

type PerformerImage struct {
	PerformerID uuid.UUID `db:"performer_id" json:"performer_id"`
	ImageID     uuid.UUID `db:"image_id" json:"image_id"`
}

type PerformerPiercing struct {
	PerformerID uuid.UUID `db:"performer_id" json:"performer_id"`
	Location    *string   `db:"location" json:"location"`
	Description *string   `db:"description" json:"description"`
}

type PerformerRedirect struct {
	SourceID uuid.UUID `db:"source_id" json:"source_id"`
	TargetID uuid.UUID `db:"target_id" json:"target_id"`
}

type PerformerTattoo struct {
	PerformerID uuid.UUID `db:"performer_id" json:"performer_id"`
	Location    *string   `db:"location" json:"location"`
	Description *string   `db:"description" json:"description"`
}

type PerformerUrl struct {
	PerformerID uuid.UUID `db:"performer_id" json:"performer_id"`
	Url         string    `db:"url" json:"url"`
	SiteID      uuid.UUID `db:"site_id" json:"site_id"`
}

type Querier interface {
	CancelUserEdits(ctx context.Context, userID uuid.NullUUID) error
	ClearScenePerformerAlias(ctx context.Context, arg ClearScenePerformerAliasParams) error
	CountNotificationsByUser(ctx context.Context, arg CountNotificationsByUserParams) (int64, error)
	CountScenesByPerformer(ctx context.Context, performerID uuid.UUID) (int64, error)
	CountUserEditsByStatus(ctx context.Context, userID uuid.NullUUID) ([]CountUserEditsByStatusRow, error)
	CountUsers(ctx context.Context) (int64, error)
	CountVotesByType(ctx context.Context, userID uuid.UUID) ([]CountVotesByTypeRow, error)
	// Draft queries
	CreateDraft(ctx context.Context, arg CreateDraftParams) (Draft, error)
	// Edit queries
	CreateEdit(ctx context.Context, arg CreateEditParams) (Edit, error)
	// Edit comments
	CreateEditComment(ctx context.Context, arg CreateEditCommentParams) (EditComment, error)
	// Edit votes
	CreateEditVote(ctx context.Context, arg CreateEditVoteParams) error
	// Fingerprint queries (normalized schema)
	CreateFingerprint(ctx context.Context, arg CreateFingerprintParams) (Fingerprint, error)
	// Image queries
	CreateImage(ctx context.Context, arg CreateImageParams) (Image, error)
	// Invite key queries
	CreateInviteKey(ctx context.Context, arg CreateInviteKeyParams) (InviteKey, error)
	CreateOrReplaceFingerprint(ctx context.Context, arg CreateOrReplaceFingerprintParams) error
	// Performer queries
	CreatePerformer(ctx context.Context, arg CreatePerformerParams) (Performer, error)
	CreatePerformerAliases(ctx context.Context, arg []CreatePerformerAliasesParams) (int64, error)
	CreatePerformerEdit(ctx context.Context, arg CreatePerformerEditParams) error
	CreatePerformerFavorite(ctx context.Context, arg CreatePerformerFavoriteParams) error
	CreatePerformerImages(ctx context.Context, arg []CreatePerformerImagesParams) (int64, error)
	CreatePerformerPiercings(ctx context.Context, arg []CreatePerformerPiercingsParams) (int64, error)
	// Performer redirects
	CreatePerformerRedirect(ctx context.Context, arg CreatePerformerRedirectParams) error
	CreatePerformerTattoos(ctx context.Context, arg []CreatePerformerTattoosParams) (int64, error)
	CreatePerformerURLs(ctx context.Context, arg []CreatePerformerURLsParams) (int64, error)
	// Scene queries
	CreateScene(ctx context.Context, arg CreateSceneParams) (Scene, error)
	CreateSceneEdit(ctx context.Context, arg CreateSceneEditParams) error
	CreateSceneFingerprints(ctx context.Context, arg []CreateSceneFingerprintsParams) (int64, error)
	CreateSceneImages(ctx context.Context, arg []CreateSceneImagesParams) (int64, error)
	// Scene performers
	CreateScenePerformers(ctx context.Context, arg []CreateScenePerformersParams) (int64, error)
	// Scene redirects
	CreateSceneRedirect(ctx context.Context, arg CreateSceneRedirectParams) error
	// Scene tags management
	CreateSceneTags(ctx context.Context, arg []CreateSceneTagsParams) (int64, error)
	// Scene URLs
	CreateSceneURLs(ctx context.Context, arg []CreateSceneURLsParams) (int64, error)
	// Site queries
	CreateSite(ctx context.Context, arg CreateSiteParams) (Site, error)
	// Studio queries
	CreateStudio(ctx context.Context, arg CreateStudioParams) (Studio, error)
	// Studio aliases
	CreateStudioAliases(ctx context.Context, arg []CreateStudioAliasesParams) (int64, error)
	CreateStudioEdit(ctx context.Context, arg CreateStudioEditParams) error
	// Studio favorites
	CreateStudioFavorite(ctx context.Context, arg CreateStudioFavoriteParams) error
	// Studio images
	CreateStudioImages(ctx context.Context, arg []CreateStudioImagesParams) (int64, error)
	// Studio redirects
	CreateStudioRedirect(ctx context.Context, arg CreateStudioRedirectParams) error
	// Studio URLs
	CreateStudioURLs(ctx context.Context, arg []CreateStudioURLsParams) (int64, error)
	// Tag queries
	CreateTag(ctx context.Context, arg CreateTagParams) (Tag, error)
	// Tag aliases
	CreateTagAliases(ctx context.Context, arg []CreateTagAliasesParams) (int64, error)
	// Tag category queries
	CreateTagCategory(ctx context.Context, arg CreateTagCategoryParams) (TagCategory, error)
	CreateTagEdit(ctx context.Context, arg CreateTagEditParams) error
	// Tag redirects
	CreateTagRedirect(ctx context.Context, arg CreateTagRedirectParams) error
	// User queries
	CreateUser(ctx context.Context, arg CreateUserParams) (User, error)
	// User notification subscriptions
	CreateUserNotificationSubscriptions(ctx context.Context, arg []CreateUserNotificationSubscriptionsParams) (int64, error)
	// User roles
	CreateUserRoles(ctx context.Context, arg []CreateUserRolesParams) (int64, error)
	// User token queries
	CreateUserToken(ctx context.Context, arg CreateUserTokenParams) (UserToken, error)
	DeleteDraft(ctx context.Context, id uuid.UUID) error
	DeleteEdit(ctx context.Context, id uuid.UUID) error
	DeleteExpiredDrafts(ctx context.Context, dollar_1 interface{}) error
	DeleteExpiredUserTokens(ctx context.Context) error
	DeleteImage(ctx context.Context, id uuid.UUID) error
	DeleteInviteKey(ctx context.Context, id uuid.UUID) error
	DeletePerformer(ctx context.Context, id uuid.UUID) error
	// Performer aliases
	DeletePerformerAliases(ctx context.Context, performerID uuid.UUID) error
	DeletePerformerFavorite(ctx context.Context, arg DeletePerformerFavoriteParams) error
	// Performer favorites
	DeletePerformerFavorites(ctx context.Context, performerID uuid.UUID) error
	DeletePerformerImages(ctx context.Context, performerID uuid.UUID) error
	// Performer piercings
	DeletePerformerPiercings(ctx context.Context, performerID uuid.UUID) error
	DeletePerformerScenes(ctx context.Context, performerID uuid.UUID) error
	// Performer tattoos
	DeletePerformerTattoos(ctx context.Context, performerID uuid.UUID) error
	// Performer URLs
	DeletePerformerURLs(ctx context.Context, performerID uuid.UUID) error
	DeleteScene(ctx context.Context, id uuid.UUID) error
	DeleteSceneFingerprint(ctx context.Context, arg DeleteSceneFingerprintParams) error
	DeleteSceneFingerprintsByScene(ctx context.Context, sceneID uuid.UUID) error
	// Scene images
	DeleteSceneImages(ctx context.Context, sceneID uuid.UUID) error
	DeleteScenePerformers(ctx context.Context, sceneID uuid.UUID) error
	DeleteSceneStudios(ctx context.Context, studioID uuid.NullUUID) error
	DeleteSceneTagsByScene(ctx context.Context, sceneID uuid.UUID) error
	DeleteSceneTagsByTag(ctx context.Context, tagID uuid.UUID) error
	DeleteSceneURLs(ctx context.Context, sceneID uuid.UUID) error
	DeleteSite(ctx context.Context, id uuid.UUID) error
	DeleteStudio(ctx context.Context, id uuid.UUID) error
	DeleteStudioAliases(ctx context.Context, studioID uuid.UUID) error
	DeleteStudioFavorite(ctx context.Context, arg DeleteStudioFavoriteParams) error
	DeleteStudioFavorites(ctx context.Context, studioID uuid.UUID) error
	DeleteStudioImages(ctx context.Context, studioID uuid.UUID) error
	DeleteStudioURLs(ctx context.Context, studioID uuid.UUID) error
	DeleteTag(ctx context.Context, id uuid.UUID) error
	DeleteTagAliases(ctx context.Context, tagID uuid.UUID) error
	DeleteTagAliasesByNames(ctx context.Context, arg DeleteTagAliasesByNamesParams) error
	DeleteTagCategory(ctx context.Context, id uuid.UUID) error
	DeleteUser(ctx context.Context, id uuid.UUID) error
	DeleteUserNotificationSubscriptions(ctx context.Context, userID uuid.UUID) error
	DeleteUserRoles(ctx context.Context, userID uuid.UUID) error
	DeleteUserToken(ctx context.Context, id uuid.UUID) error
	DestroyExpiredInvites(ctx context.Context) error
	DestroyExpiredNotifications(ctx context.Context) error
	FindActiveInviteKeysForUser(ctx context.Context, generatedBy uuid.UUID) ([]InviteKey, error)
	// Returns pending edits that fulfill one of the criteria for being closed:
	// * The full voting period has passed
	// * The minimum voting period has passed, and the number of votes has crossed the voting threshold.
	// The latter only applies for destructive edits. Non-destructive edits get auto-applied when sufficient votes are cast.
	FindCompletedEdits(ctx context.Context, arg FindCompletedEditsParams) ([]Edit, error)
	FindDraft(ctx context.Context, id uuid.UUID) (Draft, error)
	FindDraftsByUser(ctx context.Context, userID uuid.UUID) ([]Draft, error)
	FindEdit(ctx context.Context, id uuid.UUID) (Edit, error)
	FindExistingPerformers(ctx context.Context, arg FindExistingPerformersParams) ([]Performer, error)
	FindExistingScenes(ctx context.Context, arg FindExistingScenesParams) ([]Scene, error)
	FindImage(ctx context.Context, id uuid.UUID) (Image, error)
	FindImageByChecksum(ctx context.Context, checksum string) (Image, error)
	FindImageIdsByPerformerIds(ctx context.Context, dollar_1 []uuid.UUID) ([]PerformerImage, error)
	FindImageIdsBySceneIds(ctx context.Context, dollar_1 []uuid.UUID) ([]SceneImage, error)
	FindImageIdsByStudioIds(ctx context.Context, dollar_1 []uuid.UUID) ([]StudioImage, error)
	FindImagesByIds(ctx context.Context, dollar_1 []uuid.UUID) ([]Image, error)
	FindImagesBySceneID(ctx context.Context, id uuid.UUID) ([]Image, error)
	FindImagesByStudioID(ctx context.Context, id uuid.UUID) ([]Image, error)
	FindInviteKey(ctx context.Context, id uuid.UUID) (InviteKey, error)
	// Find merge target IDs for performers (for merges where these are sources)
	FindMergeIDsByPerformerIds(ctx context.Context, performerIds []uuid.UUID) ([]FindMergeIDsByPerformerIdsRow, error)
	// Find merge source IDs for performers (for merges where these are targets)
	FindMergeIDsBySourcePerformerIds(ctx context.Context, performerIds []uuid.UUID) ([]FindMergeIDsBySourcePerformerIdsRow, error)
	// Notification queries
	FindNotificationsByUser(ctx context.Context, arg FindNotificationsByUserParams) ([]Notification, error)
	FindPendingPerformerCreation(ctx context.Context, arg FindPendingPerformerCreationParams) ([]Edit, error)
	FindPendingSceneCreation(ctx context.Context, arg FindPendingSceneCreationParams) ([]Edit, error)
	FindPerformer(ctx context.Context, id uuid.UUID) (Performer, error)
	// Get aliases for multiple performers
	FindPerformerAliasesByIds(ctx context.Context, performerIds []uuid.UUID) ([]PerformerAlias, error)
	FindPerformerByAlias(ctx context.Context, upper interface{}) (Performer, error)
	FindPerformerByName(ctx context.Context, upper interface{}) (Performer, error)
	// Check favorite status for multiple performers for a specific user
	FindPerformerFavoritesByIds(ctx context.Context, arg FindPerformerFavoritesByIdsParams) ([]FindPerformerFavoritesByIdsRow, error)
	// Get piercings for multiple performers
	FindPerformerPiercingsByIds(ctx context.Context, performerIds []uuid.UUID) ([]PerformerPiercing, error)
	// Get tattoos for multiple performers
	FindPerformerTattoosByIds(ctx context.Context, performerIds []uuid.UUID) ([]PerformerTattoo, error)
	// Get URLs for multiple performers
	FindPerformerUrlsByIds(ctx context.Context, performerIds []uuid.UUID) ([]PerformerUrl, error)
	FindPerformerWithRedirect(ctx context.Context, id uuid.UUID) ([]Performer, error)
	FindPerformersByIds(ctx context.Context, dollar_1 []uuid.UUID) ([]Performer, error)
	FindPerformersByURL(ctx context.Context, arg FindPerformersByURLParams) ([]Performer, error)
	FindScene(ctx context.Context, id uuid.UUID) (Scene, error)
	// Get performer appearances for multiple scenes
	FindSceneAppearancesByIds(ctx context.Context, sceneIds []uuid.UUID) ([]FindSceneAppearancesByIdsRow, error)
	FindSceneByURL(ctx context.Context, arg FindSceneByURLParams) ([]Scene, error)
	// Get URLs for multiple scenes
	FindSceneUrlsByIds(ctx context.Context, sceneIds []uuid.UUID) ([]SceneUrl, error)
	FindScenesByFingerprint(ctx context.Context, arg FindScenesByFingerprintParams) ([]Scene, error)
	// Scene fingerprints (use fingerprint.sql for most fingerprint operations)
	FindScenesByFingerprints(ctx context.Context, fingerprints []string) ([]Scene, error)
	FindScenesByFullFingerprints(ctx context.Context, arg FindScenesByFullFingerprintsParams) ([]Scene, error)
	FindScenesByFullFingerprintsWithHash(ctx context.Context, arg FindScenesByFullFingerprintsWithHashParams) ([]FindScenesByFullFingerprintsWithHashRow, error)
	FindSitesByIds(ctx context.Context, dollar_1 []uuid.UUID) ([]Site, error)
	FindStudio(ctx context.Context, id uuid.UUID) (Studio, error)
	// Get aliases for multiple studios
	FindStudioAliasesByIds(ctx context.Context, studioIds []uuid.UUID) ([]StudioAlias, error)
	FindStudioByAlias(ctx context.Context, upper interface{}) (Studio, error)
	FindStudioByName(ctx context.Context, upper interface{}) (Studio, error)
	// Check favorite status for multiple studios for a specific user
	FindStudioFavoritesByIds(ctx context.Context, arg FindStudioFavoritesByIdsParams) ([]FindStudioFavoritesByIdsRow, error)
	// Get URLs for multiple studios
	FindStudioUrlsByIds(ctx context.Context, studioIds []uuid.UUID) ([]StudioUrl, error)
	FindStudioWithRedirect(ctx context.Context, id uuid.UUID) (Studio, error)
	FindTag(ctx context.Context, id uuid.UUID) (Tag, error)
	FindTagByAlias(ctx context.Context, upper interface{}) (Tag, error)
	FindTagByName(ctx context.Context, upper interface{}) (Tag, error)
	FindTagByNameOrAlias(ctx context.Context, lower string) (Tag, error)
	FindTagCategory(ctx context.Context, id uuid.UUID) (TagCategory, error)
	// Bulk query to find tag IDs for multiple scene IDs
	FindTagIdsBySceneIds(ctx context.Context, sceneIds []uuid.UUID) ([]SceneTag, error)
	FindTagWithRedirect(ctx context.Context, id uuid.UUID) ([]Tag, error)
	FindTagsByIds(ctx context.Context, dollar_1 []uuid.UUID) ([]Tag, error)
	FindTagsBySceneID(ctx context.Context, sceneID uuid.UUID) ([]Tag, error)
	FindUnreadNotificationsByUser(ctx context.Context, arg FindUnreadNotificationsByUserParams) ([]Notification, error)
	FindUnusedImages(ctx context.Context) ([]Image, error)
	FindUser(ctx context.Context, id uuid.UUID) (User, error)
	FindUserByEmail(ctx context.Context, upper interface{}) (User, error)
	FindUserByName(ctx context.Context, name string) (User, error)
	FindUserToken(ctx context.Context, id uuid.UUID) (UserToken, error)
	FindUserTokensByEmail(ctx context.Context, dollar_1 string) ([]UserToken, error)
	FindUserTokensByInviteKey(ctx context.Context, dollar_1 uuid.UUID) ([]UserToken, error)
	// Get all fingerprints for multiple scenes with aggregated vote data
	// When onlySubmitted is true, pass the actual user ID, when false pass NULL
	GetAllFingerprints(ctx context.Context, arg GetAllFingerprintsParams) ([]GetAllFingerprintsRow, error)
	GetAllSceneFingerprints(ctx context.Context, sceneID uuid.UUID) ([]GetAllSceneFingerprintsRow, error)
	GetAllTagCategories(ctx context.Context) ([]TagCategory, error)
	GetChildStudios(ctx context.Context, parentStudioID uuid.NullUUID) ([]Studio, error)
	GetEditComments(ctx context.Context, editID uuid.UUID) ([]EditComment, error)
	GetEditCommentsByIds(ctx context.Context, dollar_1 []uuid.UUID) ([]EditComment, error)
	GetEditPerformerAliases(ctx context.Context, id uuid.UUID) ([]string, error)
	GetEditPerformerPiercings(ctx context.Context, id uuid.UUID) ([]GetEditPerformerPiercingsRow, error)
	GetEditPerformerTattoos(ctx context.Context, id uuid.UUID) ([]GetEditPerformerTattoosRow, error)
	GetEditTargetID(ctx context.Context, id uuid.UUID) (GetEditTargetIDRow, error)
	GetEditVotes(ctx context.Context, editID uuid.UUID) ([]EditVote, error)
	GetEditsByIds(ctx context.Context, dollar_1 []uuid.UUID) ([]Edit, error)
	GetEditsByPerformer(ctx context.Context, performerID uuid.UUID) ([]Edit, error)
	GetEditsByScene(ctx context.Context, sceneID uuid.UUID) ([]Edit, error)
	GetEditsByStudio(ctx context.Context, studioID uuid.UUID) ([]Edit, error)
	GetEditsByTag(ctx context.Context, tagID uuid.UUID) ([]Edit, error)
	GetFingerprint(ctx context.Context, arg GetFingerprintParams) (Fingerprint, error)
	// Gets current images for target entity and merges with edit's added_images/removed_images
	GetImagesForEdit(ctx context.Context, id uuid.UUID) ([]Image, error)
	// Gets current performers for target entity and merges with edit's added_performers/removed_performers
	GetMergedPerformersForEdit(ctx context.Context, id uuid.UUID) ([]GetMergedPerformersForEditRow, error)
	// Gets current aliases for target studio entity and merges with edit's added_aliases/removed_aliases
	GetMergedStudioAliasesForEdit(ctx context.Context, id uuid.UUID) ([]string, error)
	// Gets current aliases for target tag entity and merges with edit's added_aliases/removed_aliases
	GetMergedTagAliasesForEdit(ctx context.Context, id uuid.UUID) ([]string, error)
	// Gets current tags for target entity and merges with edit's added_tags/removed_tags
	GetMergedTagsForEdit(ctx context.Context, id uuid.UUID) ([]Tag, error)
	// URL merging queries for edits
	// result: URL
	// Gets current URLs for target entity and merges with edit's added_urls/removed_urls
	GetMergedURLsForEdit(ctx context.Context, id uuid.UUID) ([]GetMergedURLsForEditRow, error)
	GetPerformerAliases(ctx context.Context, performerID uuid.UUID) ([]string, error)
	// Performer images
	GetPerformerImages(ctx context.Context, performerID uuid.UUID) ([]Image, error)
	GetPerformerPiercings(ctx context.Context, performerID uuid.UUID) ([]GetPerformerPiercingsRow, error)
	GetPerformerTattoos(ctx context.Context, performerID uuid.UUID) ([]GetPerformerTattoosRow, error)
	GetPerformerURLs(ctx context.Context, performerID uuid.UUID) ([]GetPerformerURLsRow, error)
	GetScenePerformers(ctx context.Context, sceneID uuid.UUID) ([]GetScenePerformersRow, error)
	GetSceneTags(ctx context.Context, sceneID uuid.UUID) ([]Tag, error)
	GetSceneURLs(ctx context.Context, sceneID uuid.UUID) ([]GetSceneURLsRow, error)
	GetScenes(ctx context.Context, dollar_1 []uuid.UUID) ([]Scene, error)
	GetSite(ctx context.Context, id uuid.UUID) (Site, error)
	GetStudioAliases(ctx context.Context, studioID uuid.UUID) ([]string, error)
	GetStudioImages(ctx context.Context, studioID uuid.UUID) ([]uuid.UUID, error)
	GetStudioURLs(ctx context.Context, studioID uuid.UUID) ([]StudioUrl, error)
	GetStudios(ctx context.Context, dollar_1 []uuid.UUID) ([]Studio, error)
	GetStudiosByPerformer(ctx context.Context, performerID uuid.UUID) ([]GetStudiosByPerformerRow, error)
	GetTagAliases(ctx context.Context, tagID uuid.UUID) ([]string, error)
	GetTagCategoriesByIds(ctx context.Context, dollar_1 []uuid.UUID) ([]TagCategory, error)
	GetUserNotificationSubscriptions(ctx context.Context, userID uuid.UUID) ([]NotificationType, error)
	GetUserRoles(ctx context.Context, userID uuid.UUID) ([]string, error)
	InviteKeyUsed(ctx context.Context, id uuid.UUID) (*int, error)
	IsImageUnused(ctx context.Context, id uuid.UUID) (bool, error)
	MarkAllNotificationsRead(ctx context.Context, userID uuid.UUID) error
	MarkNotificationRead(ctx context.Context, arg MarkNotificationReadParams) error
	ReassignPerformerAliases(ctx context.Context, arg ReassignPerformerAliasesParams) error
	ReassignPerformerFavorites(ctx context.Context, arg ReassignPerformerFavoritesParams) error
	ReassignStudioFavorites(ctx context.Context, arg ReassignStudioFavoritesParams) error
	ResetVotes(ctx context.Context, editID uuid.UUID) error
	SearchPerformers(ctx context.Context, arg SearchPerformersParams) ([]Performer, error)
	SearchScenes(ctx context.Context, arg SearchScenesParams) ([]Scene, error)
	SearchStudios(ctx context.Context, arg SearchStudiosParams) ([]Studio, error)
	SearchTags(ctx context.Context, arg SearchTagsParams) ([]Tag, error)
	SetScenePerformerAlias(ctx context.Context, arg SetScenePerformerAliasParams) error
	SoftDeletePerformer(ctx context.Context, id uuid.UUID) (Performer, error)
	SoftDeleteScene(ctx context.Context, id uuid.UUID) (Scene, error)
	SoftDeleteStudio(ctx context.Context, id uuid.UUID) (Studio, error)
	SoftDeleteTag(ctx context.Context, id uuid.UUID) (Tag, error)
	SubmittedHashExists(ctx context.Context, arg SubmittedHashExistsParams) (bool, error)
	TriggerDownvoteEditNotifications(ctx context.Context, id uuid.UUID) error
	TriggerEditCommentNotifications(ctx context.Context, id uuid.UUID) error
	TriggerFailedEditNotifications(ctx context.Context, id uuid.UUID) error
	TriggerPerformerEditNotifications(ctx context.Context, id uuid.UUID) error
	TriggerSceneCreationNotifications(ctx context.Context, id uuid.UUID) error
	TriggerSceneEditNotifications(ctx context.Context, id uuid.UUID) error
	TriggerStudioEditNotifications(ctx context.Context, id uuid.UUID) error
	TriggerUpdatedEditNotifications(ctx context.Context, id uuid.UUID) error
	UpdateEdit(ctx context.Context, arg UpdateEditParams) (Edit, error)
	UpdatePerformer(ctx context.Context, arg UpdatePerformerParams) (Performer, error)
	UpdatePerformerRedirects(ctx context.Context, arg UpdatePerformerRedirectsParams) error
	UpdateScene(ctx context.Context, arg UpdateSceneParams) (Scene, error)
	UpdateSceneRedirects(ctx context.Context, arg UpdateSceneRedirectsParams) error
	UpdateSceneStudios(ctx context.Context, arg UpdateSceneStudiosParams) error
	UpdateSceneTagsForMerge(ctx context.Context, arg UpdateSceneTagsForMergeParams) error
	UpdateSite(ctx context.Context, arg UpdateSiteParams) (Site, error)
	UpdateStudio(ctx context.Context, arg UpdateStudioParams) (Studio, error)
	UpdateStudioRedirects(ctx context.Context, arg UpdateStudioRedirectsParams) error
	UpdateTag(ctx context.Context, arg UpdateTagParams) (Tag, error)
	UpdateTagCategory(ctx context.Context, arg UpdateTagCategoryParams) (TagCategory, error)
	UpdateTagRedirects(ctx context.Context, arg UpdateTagRedirectsParams) error
	UpdateUser(ctx context.Context, arg UpdateUserParams) (User, error)
	UpdateUserAPIKey(ctx context.Context, arg UpdateUserAPIKeyParams) error
	UpdateUserEmail(ctx context.Context, arg UpdateUserEmailParams) error
	UpdateUserInviteTokenCount(ctx context.Context, arg UpdateUserInviteTokenCountParams) error
	UpdateUserPassword(ctx context.Context, arg UpdateUserPasswordParams) error
}

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

type ReassignPerformerAliasesParams struct {
	NewPerformerID uuid.UUID `db:"new_performer_id" json:"new_performer_id"`
	OldPerformerID uuid.UUID `db:"old_performer_id" json:"old_performer_id"`
}

type ReassignPerformerFavoritesParams struct {
	NewPerformerID uuid.UUID `db:"new_performer_id" json:"new_performer_id"`
	OldPerformerID uuid.UUID `db:"old_performer_id" json:"old_performer_id"`
}

type ReassignStudioFavoritesParams struct {
	NewStudioID uuid.UUID `db:"new_studio_id" json:"new_studio_id"`
	OldStudioID uuid.UUID `db:"old_studio_id" json:"old_studio_id"`
}

type Scene struct {
	ID             uuid.UUID     `db:"id" json:"id"`
	Title          *string       `db:"title" json:"title"`
	Details        *string       `db:"details" json:"details"`
	StudioID       uuid.NullUUID `db:"studio_id" json:"studio_id"`
	CreatedAt      time.Time     `db:"created_at" json:"created_at"`
	UpdatedAt      time.Time     `db:"updated_at" json:"updated_at"`
	Duration       *int          `db:"duration" json:"duration"`
	Director       *string       `db:"director" json:"director"`
	Deleted        bool          `db:"deleted" json:"deleted"`
	Code           *string       `db:"code" json:"code"`
	Date           *string       `db:"date" json:"date"`
	ProductionDate *string       `db:"production_date" json:"production_date"`
}

type SceneEdit struct {
	EditID  uuid.UUID `db:"edit_id" json:"edit_id"`
	SceneID uuid.UUID `db:"scene_id" json:"scene_id"`
}

type SceneFingerprint struct {
	FingerprintID int       `db:"fingerprint_id" json:"fingerprint_id"`
	SceneID       uuid.UUID `db:"scene_id" json:"scene_id"`
	UserID        uuid.UUID `db:"user_id" json:"user_id"`
	Duration      int       `db:"duration" json:"duration"`
	CreatedAt     time.Time `db:"created_at" json:"created_at"`
	Vote          int16     `db:"vote" json:"vote"`
}

type SceneImage struct {
	SceneID uuid.UUID `db:"scene_id" json:"scene_id"`
	ImageID uuid.UUID `db:"image_id" json:"image_id"`
}

type ScenePerformer struct {
	SceneID     uuid.UUID `db:"scene_id" json:"scene_id"`
	As          *string   `db:"as" json:"as"`
	PerformerID uuid.UUID `db:"performer_id" json:"performer_id"`
}

type SceneRedirect struct {
	SourceID uuid.UUID `db:"source_id" json:"source_id"`
	TargetID uuid.UUID `db:"target_id" json:"target_id"`
}

type SceneSearch struct {
	SceneID        uuid.UUID   `db:"scene_id" json:"scene_id"`
	SceneTitle     string      `db:"scene_title" json:"scene_title"`
	SceneDate      string      `db:"scene_date" json:"scene_date"`
	StudioName     interface{} `db:"studio_name" json:"studio_name"`
	PerformerNames interface{} `db:"performer_names" json:"performer_names"`
	SceneCode      *string     `db:"scene_code" json:"scene_code"`
}

type SceneTag struct {
	SceneID uuid.UUID `db:"scene_id" json:"scene_id"`
	TagID   uuid.UUID `db:"tag_id" json:"tag_id"`
}

type SceneUrl struct {
	SceneID uuid.UUID `db:"scene_id" json:"scene_id"`
	Url     string    `db:"url" json:"url"`
	SiteID  uuid.UUID `db:"site_id" json:"site_id"`
}