models

type Album struct {
	ID           uint           `gorm:"primaryKey" json:"id"`
	UserID       uint           `gorm:"index" json:"user_id"`
	User         User           `gorm:"foreignKey:UserID" json:"user,omitempty"`
	Title        string         `gorm:"type:varchar(255);not null" json:"title" validate:"required,min=3,max=255"`
	Description  string         `gorm:"type:text" json:"description"`
	CoverImageID uint           `json:"cover_image_id"`
	IsPublic     bool           `gorm:"default:false" json:"is_public"`
	ShareLink    string         `gorm:"type:char(36) CHARACTER SET utf8 COLLATE utf8_bin;uniqueIndex;not null" json:"share_link"`
	ViewCount    int            `gorm:"default:0" json:"view_count"`
	Images       []Image        `gorm:"many2many:album_images;" json:"images,omitempty"`
	CreatedAt    time.Time      `gorm:"autoCreateTime" json:"created_at"`
	UpdatedAt    time.Time      `gorm:"autoUpdateTime" json:"updated_at"`
	DeletedAt    gorm.DeletedAt `gorm:"index" json:"-"`
}

type AlbumImage struct {
	AlbumID   uint      `gorm:"primaryKey;autoIncrement:false" json:"album_id"`
	ImageID   uint      `gorm:"primaryKey;autoIncrement:false" json:"image_id"`
	CreatedAt time.Time `gorm:"autoCreateTime" json:"created_at"`
}

type AppSettings struct {
	SiteTitle                    string `json:"site_title" validate:"required,min=1,max=255"`
	SiteDescription              string `json:"site_description" validate:"max=500"`
	ImageUploadEnabled           bool   `json:"image_upload_enabled"`
	DirectUploadEnabled          bool   `json:"direct_upload_enabled"`
	UploadRateLimitPerMinute     int    `json:"upload_rate_limit_per_minute" validate:"min=0,max=100000"`
	UploadUserRateLimitPerMinute int    `json:"upload_user_rate_limit_per_minute" validate:"min=0,max=100000"`
	// Thumbnail format settings
	ThumbnailOriginalEnabled bool `json:"thumbnail_original_enabled"`
	ThumbnailWebPEnabled     bool `json:"thumbnail_webp_enabled"`
	ThumbnailAVIFEnabled     bool `json:"thumbnail_avif_enabled"`
	// S3 Backup settings
	S3BackupEnabled       bool `json:"s3_backup_enabled"`
	S3BackupDelayMinutes  int  `json:"s3_backup_delay_minutes" validate:"min=0,max=43200"` // Max 30 days (43200 minutes)
	S3BackupCheckInterval int  `json:"s3_backup_check_interval" validate:"min=1,max=60"`   // How often to check for delayed backups (1-60 minutes)
	S3RetryInterval       int  `json:"s3_retry_interval" validate:"min=1,max=60"`          // How often to retry failed backups (1-60 minutes)
	JobQueueWorkerCount   int  `json:"job_queue_worker_count" validate:"min=1,max=20"`     // Number of job queue workers (1-20)
	// API rate limiting
	APIRateLimitPerMinute int `json:"api_rate_limit_per_minute" validate:"min=0,max=100000"` // Global API limiter for /api routes (0 = unlimited)
	// Replication/Storage settings
	ReplicationRequireChecksum bool `json:"replication_require_checksum"`
	// contains filtered or unexported fields
}

type BackupProvider string

type BackupStatus string

type Comment struct {
	ID        uint           `gorm:"primaryKey" json:"id"`
	UserID    uint           `gorm:"index" json:"user_id"`
	User      User           `gorm:"foreignKey:UserID" json:"user,omitempty"`
	ImageID   uint           `gorm:"index" json:"image_id"`
	Image     Image          `gorm:"foreignKey:ImageID" json:"image,omitempty"`
	Content   string         `gorm:"type:text" json:"content" validate:"required,min=1"`
	CreatedAt time.Time      `gorm:"autoCreateTime" json:"created_at"`
	UpdatedAt time.Time      `gorm:"autoUpdateTime" json:"updated_at"`
	DeletedAt gorm.DeletedAt `gorm:"index" json:"-"`
}

type DailyStats struct {
	Date  string `json:"date"`
	Count int    `json:"count"`
}

type Image struct {
	ID            uint         `gorm:"primaryKey" json:"id"`
	UUID          string       `gorm:"type:char(36) CHARACTER SET utf8 COLLATE utf8_bin;uniqueIndex;not null" json:"uuid"`
	UserID        uint         `gorm:"index;index:idx_user_file_hash,composite" json:"user_id"`
	User          User         `gorm:"foreignKey:UserID" json:"user,omitempty"`
	Title         string       `gorm:"type:varchar(255)" json:"title"`
	Description   string       `gorm:"type:text" json:"description"`
	FilePath      string       `gorm:"type:varchar(255);not null" json:"file_path"`
	FileName      string       `gorm:"type:varchar(255);not null" json:"file_name"`
	FileSize      int64        `gorm:"type:bigint" json:"file_size"`
	FileType      string       `gorm:"type:varchar(50)" json:"file_type"`
	Width         int          `gorm:"type:int" json:"width"`
	Height        int          `gorm:"type:int" json:"height"`
	ShareLink     string       `gorm:"type:varchar(255) CHARACTER SET utf8 COLLATE utf8_bin;uniqueIndex" json:"share_link"`
	IsPublic      bool         `gorm:"default:false" json:"is_public"`
	ViewCount     int          `gorm:"default:0" json:"view_count"`
	DownloadCount int          `gorm:"default:0" json:"download_count"`
	IPv4          string       `gorm:"type:varchar(15);default:null" json:"-"`                                                   // IPv4 address of the uploader
	IPv6          string       `gorm:"type:varchar(45);default:null" json:"-"`                                                   // IPv6 address of the uploader
	FileHash      string       `gorm:"type:varchar(64);not null;default:'';index:idx_user_file_hash,composite" json:"file_hash"` // SHA-256 hash for duplicate detection
	StoragePoolID uint         `gorm:"index;default:null" json:"storage_pool_id"`                                                // Reference to storage pool
	StoragePool   *StoragePool `gorm:"foreignKey:StoragePoolID" json:"storage_pool,omitempty"`
	// relations
	Metadata  *ImageMetadata `gorm:"foreignKey:ImageID" json:"metadata,omitempty"`
	Tags      []Tag          `gorm:"many2many:image_tags;" json:"tags,omitempty"`
	Comments  []Comment      `gorm:"foreignKey:ImageID" json:"comments,omitempty"`
	Likes     []Like         `gorm:"foreignKey:ImageID" json:"likes,omitempty"`
	Albums    []Album        `gorm:"many2many:album_images;" json:"albums,omitempty"`
	CreatedAt time.Time      `gorm:"autoCreateTime" json:"created_at"`
	UpdatedAt time.Time      `gorm:"autoUpdateTime" json:"updated_at"`
	DeletedAt gorm.DeletedAt `gorm:"index" json:"-"`
}

type ImageBackup struct {
	ID           uint           `gorm:"primaryKey" json:"id"`
	ImageID      uint           `gorm:"not null;index:idx_image_id" json:"image_id"`
	Image        Image          `gorm:"foreignKey:ImageID;constraint:OnUpdate:CASCADE,OnDelete:CASCADE" json:"image,omitempty"`
	Provider     BackupProvider `gorm:"type:varchar(20);not null;default:'s3';index:idx_provider" json:"provider"`
	Status       BackupStatus   `gorm:"type:varchar(20);not null;default:'pending';index:idx_status" json:"status"`
	BucketName   string         `gorm:"type:varchar(100)" json:"bucket_name"`
	ObjectKey    string         `gorm:"type:varchar(500)" json:"object_key"`
	BackupSize   int64          `gorm:"type:bigint unsigned" json:"backup_size"`
	BackupDate   *time.Time     `json:"backup_date"`
	ErrorMessage string         `gorm:"type:text" json:"error_message"`
	RetryCount   int            `gorm:"type:int unsigned;default:0" json:"retry_count"`
	CreatedAt    time.Time      `gorm:"autoCreateTime;index:idx_created_at" json:"created_at"`
	UpdatedAt    time.Time      `gorm:"autoUpdateTime" json:"updated_at"`
}

type ImageMetadata struct {
	ID           uint           `gorm:"primaryKey" json:"id"`
	ImageID      uint           `gorm:"index;not null" json:"image_id"`
	CameraModel  *string        `gorm:"type:varchar(255)" json:"camera_model"`
	TakenAt      *time.Time     `gorm:"type:datetime" json:"taken_at"`
	Latitude     *float64       `gorm:"type:decimal(10,8)" json:"latitude"`
	Longitude    *float64       `gorm:"type:decimal(11,8)" json:"longitude"`
	ExposureTime *string        `gorm:"type:varchar(50)" json:"exposure_time"`
	Aperture     *string        `gorm:"type:varchar(20)" json:"aperture"`
	ISO          *int           `gorm:"type:int" json:"iso"`
	FocalLength  *string        `gorm:"type:varchar(20)" json:"focal_length"`
	Metadata     *JSON          `gorm:"type:json" json:"metadata"`
	CreatedAt    time.Time      `gorm:"autoCreateTime" json:"created_at"`
	UpdatedAt    time.Time      `gorm:"autoUpdateTime" json:"updated_at"`
	DeletedAt    gorm.DeletedAt `gorm:"index" json:"-"`
}

type ImageReport struct {
	ID           uint           `gorm:"primaryKey" json:"id"`
	ImageID      uint           `gorm:"index;not null" json:"image_id"`
	Image        *Image         `gorm:"foreignKey:ImageID" json:"image,omitempty"`
	ReporterID   *uint          `gorm:"index" json:"reporter_id,omitempty"`
	Reporter     *User          `gorm:"foreignKey:ReporterID" json:"reporter,omitempty"`
	Reason       string         `gorm:"type:varchar(50);not null" json:"reason"`
	Details      string         `gorm:"type:text" json:"details"`
	Status       string         `gorm:"type:varchar(20);default:'open'" json:"status"`
	ReporterIPv4 string         `gorm:"type:varchar(15);default:null" json:"-"`
	ReporterIPv6 string         `gorm:"type:varchar(45);default:null" json:"-"`
	ResolvedByID *uint          `gorm:"index" json:"resolved_by_id,omitempty"`
	ResolvedBy   *User          `gorm:"foreignKey:ResolvedByID" json:"resolved_by,omitempty"`
	ResolvedAt   *time.Time     `json:"resolved_at,omitempty"`
	CreatedAt    time.Time      `gorm:"autoCreateTime" json:"created_at"`
	UpdatedAt    time.Time      `gorm:"autoUpdateTime" json:"updated_at"`
	DeletedAt    gorm.DeletedAt `gorm:"index" json:"-"`
}

type ImageTag struct {
	ImageID   uint      `gorm:"primaryKey;autoIncrement:false" json:"image_id"`
	TagID     uint      `gorm:"primaryKey;autoIncrement:false" json:"tag_id"`
	CreatedAt time.Time `gorm:"autoCreateTime" json:"created_at"`
}

type ImageVariant struct {
	ID            uint           `gorm:"primaryKey" json:"id"`
	ImageID       uint           `gorm:"index;not null" json:"image_id"`
	Image         Image          `gorm:"foreignKey:ImageID" json:"image,omitempty"`
	VariantType   string         `gorm:"type:varchar(50);not null" json:"variant_type"` // thumbnail_small_webp, thumbnail_medium_webp, thumbnail_small_avif, thumbnail_medium_avif, webp, avif
	FilePath      string         `gorm:"type:varchar(255);not null" json:"file_path"`
	FileName      string         `gorm:"type:varchar(255);not null" json:"file_name"`
	FileType      string         `gorm:"type:varchar(50);not null" json:"file_type"`
	FileSize      int64          `gorm:"type:bigint;not null" json:"file_size"`
	Width         int            `gorm:"type:int" json:"width"`
	Height        int            `gorm:"type:int" json:"height"`
	Quality       int            `gorm:"type:int" json:"quality"`                   // Compression quality for formats that support it
	StoragePoolID uint           `gorm:"index;default:null" json:"storage_pool_id"` // Reference to storage pool
	StoragePool   *StoragePool   `gorm:"foreignKey:StoragePoolID" json:"storage_pool,omitempty"`
	CreatedAt     time.Time      `gorm:"autoCreateTime" json:"created_at"`
	UpdatedAt     time.Time      `gorm:"autoUpdateTime" json:"updated_at"`
	DeletedAt     gorm.DeletedAt `gorm:"index" json:"-"`
}

type JSON json.RawMessage

type Like struct {
	ID        uint           `gorm:"primaryKey" json:"id"`
	UserID    uint           `gorm:"index" json:"user_id"`
	User      User           `gorm:"foreignKey:UserID" json:"user,omitempty"`
	ImageID   uint           `gorm:"index" json:"image_id"`
	Image     Image          `gorm:"foreignKey:ImageID" json:"image,omitempty"`
	CreatedAt time.Time      `gorm:"autoCreateTime" json:"created_at"`
	DeletedAt gorm.DeletedAt `gorm:"index" json:"-"`
}

type News struct {
	ID        uint64         `gorm:"primaryKey" json:"id"`
	Title     string         `gorm:"type:varchar(255)" json:"title" validate:"required,min=3,max=255"`
	Content   string         `gorm:"type:text" json:"content" validate:"required"`
	Slug      string         `gorm:"uniqueIndex;type:varchar(255)" json:"slug" validate:"required,min=3,max=255"`
	Published bool           `gorm:"type:tinyint(1);default:0" json:"published"`
	UserID    uint64         `gorm:"index" json:"user_id"`
	User      User           `gorm:"foreignKey:UserID" json:"user"`
	CreatedAt time.Time      `gorm:"autoCreateTime" json:"created_at"`
	UpdatedAt time.Time      `gorm:"autoUpdateTime" json:"updated_at"`
	DeletedAt gorm.DeletedAt `gorm:"index" json:"-"`
}

type Notification struct {
	ID          uint           `gorm:"primaryKey" json:"id"`
	UserID      uint           `gorm:"index" json:"user_id"`
	User        User           `gorm:"foreignKey:UserID" json:"user,omitempty"`
	Type        string         `gorm:"type:varchar(50)" json:"type" validate:"oneof=like comment follow system"`
	Content     string         `gorm:"type:text" json:"content"`
	IsRead      bool           `gorm:"default:false" json:"is_read"`
	ReferenceID uint           `json:"reference_id"` // ID des Objekts, auf das sich die Benachrichtigung bezieht
	CreatedAt   time.Time      `gorm:"autoCreateTime" json:"created_at"`
	UpdatedAt   time.Time      `gorm:"autoUpdateTime" json:"updated_at"`
	DeletedAt   gorm.DeletedAt `gorm:"index" json:"-"`
}

type Page struct {
	ID        uint           `gorm:"primaryKey" json:"id"`
	Title     string         `gorm:"type:varchar(255);not null" json:"title" validate:"required,min=1,max=255"`
	Slug      string         `gorm:"type:varchar(255);uniqueIndex;not null" json:"slug" validate:"required,min=1,max=255"`
	Content   string         `gorm:"type:longtext;not null" json:"content" validate:"required,min=1"`
	IsActive  bool           `gorm:"default:true" json:"is_active"`
	CreatedAt time.Time      `gorm:"autoCreateTime" json:"created_at"`
	UpdatedAt time.Time      `gorm:"autoUpdateTime" json:"updated_at"`
	DeletedAt gorm.DeletedAt `gorm:"index" json:"-"`
}

type ProviderAccount struct {
	ID             uint       `gorm:"primaryKey" json:"id"`
	UserID         uint       `gorm:"index" json:"user_id"`
	Provider       string     `gorm:"index:provider_uid,unique;type:varchar(50)" json:"provider"`
	ProviderUserID string     `gorm:"index:provider_uid,unique;type:varchar(191)" json:"provider_user_id"`
	AccessToken    string     `gorm:"type:text" json:"-"`
	RefreshToken   string     `gorm:"type:text" json:"-"`
	ExpiresAt      *time.Time `gorm:"type:timestamp;default:null" json:"expires_at,omitempty"`
	CreatedAt      time.Time  `gorm:"autoCreateTime" json:"created_at"`
	UpdatedAt      time.Time  `gorm:"autoUpdateTime" json:"updated_at"`
}

type Setting struct {
	ID        uint      `gorm:"primaryKey" json:"id"`
	Key       string    `gorm:"column:setting_key;size:255;not null;uniqueIndex" json:"key" validate:"required,min=1,max=255"`
	Value     string    `gorm:"type:text" json:"value"`
	Type      string    `gorm:"size:50;not null" json:"type" validate:"required"` // string, boolean, integer, float
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

type StoragePool struct {
	ID             uint   `gorm:"primaryKey" json:"id"`
	Name           string `gorm:"type:varchar(100);not null;uniqueIndex" json:"name"`
	BasePath       string `gorm:"type:varchar(500);not null" json:"base_path"`
	MaxSize        int64  `gorm:"type:bigint;not null" json:"max_size"`                 // Maximum size in bytes
	UsedSize       int64  `gorm:"type:bigint;default:0" json:"used_size"`               // Currently used size in bytes
	IsActive       bool   `gorm:"default:true" json:"is_active"`                        // Whether this pool is available for new files
	IsDefault      bool   `gorm:"default:false" json:"is_default"`                      // Whether this is the default fallback pool
	IsBackupTarget bool   `gorm:"default:false" json:"is_backup_target"`                // If true, S3 backups prefer this pool
	Priority       int    `gorm:"default:100" json:"priority"`                          // Lower number = higher priority
	StorageType    string `gorm:"type:varchar(50);default:'local'" json:"storage_type"` // local, nfs, s3, etc.
	StorageTier    string ``                                                            // hot, warm, cold, archive
	/* 135-byte string literal not displayed */
	Description string `gorm:"type:text" json:"description"` // Optional description

	// S3-specific configuration fields (only used when StorageType = 's3')
	// Note: These credentials should be encrypted at rest in production
	S3AccessKeyID     *string `gorm:"type:varchar(255)" json:"s3_access_key_id,omitempty"`          // S3 Access Key ID (nullable for security)
	S3SecretAccessKey *string `gorm:"type:varchar(500)" json:"-"`                                   // S3 Secret Key (excluded from JSON for security)
	S3Region          *string `gorm:"type:varchar(100)" json:"s3_region,omitempty"`                 // S3 Region (e.g., us-west-2, us-west-001 for Backblaze B2)
	S3BucketName      *string `gorm:"type:varchar(255)" json:"s3_bucket_name,omitempty"`            // S3 Bucket name
	S3EndpointURL     *string `gorm:"type:varchar(500)" json:"s3_endpoint_url,omitempty"`           // S3 Endpoint URL (for S3-compatible services like Backblaze B2, MinIO)
	S3PathPrefix      *string `gorm:"type:varchar(500);default:''" json:"s3_path_prefix,omitempty"` // Optional path prefix within bucket for organizing files

	// Node-aware multi-VPS fields
	PublicBaseURL string `gorm:"type:varchar(500);default:''" json:"public_base_url,omitempty"` // Public base URL for serving files, e.g. https://s01.pixelfox.cc
	UploadAPIURL  string `gorm:"type:varchar(500);default:''" json:"upload_api_url,omitempty"`  // Internal/public upload API endpoint for direct-to-storage
	NodeID        string `gorm:"type:varchar(100);default:'';index" json:"node_id,omitempty"`   // Logical node identifier, e.g. s01

	CreatedAt time.Time `gorm:"autoCreateTime" json:"created_at"`
	UpdatedAt time.Time `gorm:"autoUpdateTime" json:"updated_at"`
}

type StoragePoolStats struct {
	ID              uint      `json:"id"`
	Name            string    `json:"name"`
	UsedSize        int64     `json:"used_size"`
	MaxSize         int64     `json:"max_size"`
	AvailableSize   int64     `json:"available_size"`
	UsagePercentage float64   `json:"usage_percentage"`
	ImageCount      int64     `json:"image_count"`
	VariantCount    int64     `json:"variant_count"`
	IsHealthy       bool      `json:"is_healthy"`
	LastHealthCheck time.Time `json:"last_health_check"`
}

type Tag struct {
	ID        uint           `gorm:"primaryKey" json:"id"`
	Name      string         `gorm:"type:varchar(100) CHARACTER SET utf8 COLLATE utf8_bin;uniqueIndex" json:"name" validate:"required,min=2,max=100"`
	Images    []Image        `gorm:"many2many:image_tags;" json:"images,omitempty"`
	CreatedAt time.Time      `gorm:"autoCreateTime" json:"created_at"`
	UpdatedAt time.Time      `gorm:"autoUpdateTime" json:"updated_at"`
	DeletedAt gorm.DeletedAt `gorm:"index" json:"-"`
}

type User struct {
	ID                uint              `gorm:"primaryKey" json:"id"`
	Name              string            `gorm:"type:varchar(150)" json:"name" validate:"required,min=3,max=150"`
	Email             string            `gorm:"uniqueIndex;type:varchar(200) CHARACTER SET utf8 COLLATE utf8_bin" json:"email" validate:"required,email,min=5,max=200"`
	Password          string            `gorm:"type:text" json:"-" validate:"required,min=6"`
	Role              string            `gorm:"type:varchar(50);default:'user'" json:"role" validate:"oneof=user admin"`
	Status            string            `gorm:"type:varchar(50);default:'active'" json:"status" validate:"oneof=active inactive disabled"`
	Bio               string            `gorm:"type:text;default:null" json:"bio" validate:"max=1000"`
	AvatarURL         string            `gorm:"type:varchar(255);default:null" json:"avatar_url" validate:"max=255"`
	IPv4              string            `gorm:"type:varchar(15);default:null" json:"-"`
	IPv6              string            `gorm:"type:varchar(45);default:null" json:"-"`
	ActivationToken   string            `gorm:"type:varchar(100);index" json:"-"`
	ActivationSentAt  *time.Time        `gorm:"type:timestamp;default:null" json:"-"`
	PendingEmail      string            `gorm:"type:varchar(200);default:null" json:"-"`       // New email waiting for verification
	EmailChangeToken  string            `gorm:"type:varchar(100);default:null;index" json:"-"` // Token for email change verification
	EmailChangeSentAt *time.Time        `gorm:"type:timestamp;default:null" json:"-"`          // When email change token was sent
	LastLoginAt       *time.Time        `gorm:"type:timestamp;default:null" json:"last_login_at"`
	CreatedAt         time.Time         `gorm:"autoCreateTime" json:"created_at"`
	UpdatedAt         time.Time         `gorm:"autoUpdateTime" json:"updated_at"`
	DeletedAt         gorm.DeletedAt    `gorm:"index" json:"-"`
	Accounts          []ProviderAccount `gorm:"foreignKey:UserID" json:"accounts,omitempty"`
}

type UserSettings struct {
	ID                uint           `gorm:"primaryKey" json:"id"`
	UserID            uint           `gorm:"uniqueIndex" json:"user_id"`
	Plan              string         `gorm:"type:varchar(50);default:'free'" json:"plan"`
	PrefThumbOriginal bool           `gorm:"default:true" json:"pref_thumb_original"`
	PrefThumbWebP     bool           `gorm:"default:false" json:"pref_thumb_webp"`
	PrefThumbAVIF     bool           `gorm:"default:false" json:"pref_thumb_avif"`
	CreatedAt         time.Time      `json:"created_at"`
	UpdatedAt         time.Time      `json:"updated_at"`
	DeletedAt         gorm.DeletedAt `gorm:"index" json:"-"`
}