store

type AnalyticsStore interface {
	RecordPageView(ctx context.Context, siteID, path, referrer, country, deviceType, browser, os, sessionHash string) error
	GetPageViewStats(ctx context.Context, siteID string, since time.Time) (totalViews int64, uniqueSessions int64, err error)
	GetPageViewStatsExtended(ctx context.Context, siteID string, since time.Time) (totalViews, uniqueSessions int64, avgDuration float64, err error)
	UpdatePageViewDuration(ctx context.Context, siteID, path, sessionHash string, duration int) error
	UpdatePageViewDurationAndBounce(ctx context.Context, siteID, path, sessionHash string, duration int, isBounce *bool) error
	GetBounceRate(ctx context.Context, siteID string, since time.Time) (float64, error)
	GetTopPages(ctx context.Context, siteID string, since time.Time, limit int) ([]struct {
		Path  string
		Views int64
	}, error)
	GetTrafficSources(ctx context.Context, siteID string, since time.Time, limit int) ([]TrafficSource, error)
	GetDailyViews(ctx context.Context, siteID string, days int) ([]DailyViewCount, error)
}

type AuditLog struct {
	ID         string
	SiteID     string
	UserID     sql.NullString
	UserEmail  string
	Action     string
	EntityType string
	EntityID   sql.NullString
	EntityName sql.NullString
	Details    sql.NullString
	IPAddress  sql.NullString
	UserAgent  sql.NullString
	CreatedAt  string
}

type AuditLogStats struct {
	Total    int
	Today    int
	ThisWeek int
}

type AuditStore interface {
	CreateAuditLog(ctx context.Context, id, siteID, userID, userEmail, action, entityType, entityID, entityName, details, ipAddress, userAgent string) error
	ListAuditLogs(ctx context.Context, siteID, action, entityType string, limit, offset int) ([]AuditLog, int, error)
	GetAuditLogStats(ctx context.Context, siteID string) (*AuditLogStats, error)
	GetAuditLogEntityTypes(ctx context.Context, siteID string) ([]string, error)
}

type BlogComment struct {
	ID          string
	SiteID      string
	PostID      string
	ParentID    sql.NullString
	AuthorName  string
	AuthorEmail string
	Content     string
	Status      string
	IPAddress   sql.NullString
	UserAgent   sql.NullString
	CreatedAt   string
	ModeratedAt sql.NullString
	ModeratedBy sql.NullString
	// Joined fields
	ModeratorName sql.NullString
	Replies       []BlogComment
}

type BlogPost struct {
	ID            string         `json:"id"`
	SiteID        string         `json:"site_id"`
	AuthorID      sql.NullString `json:"author_id"`
	Slug          string         `json:"slug"`
	Title         string         `json:"title"`
	Description   sql.NullString `json:"description"`
	Content       string         `json:"content"`
	FeaturedImage sql.NullString `json:"featured_image"`
	Tags          string         `json:"tags"`
	Category      sql.NullString `json:"category"`
	Status        string         `json:"status"`
	Visibility    string         `json:"visibility"`
	PublishedAt   sql.NullString `json:"published_at"`
	ScheduledAt   sql.NullString `json:"scheduled_at"`
	CreatedAt     string         `json:"created_at"`
	UpdatedAt     string         `json:"updated_at"`
	AuthorName    sql.NullString `json:"author_name"`
	AuthorEmail   sql.NullString `json:"author_email"`
}

type BlogStore interface {
	CreateBlogPost(ctx context.Context, id, siteID, authorID, slug, title, description, content, featuredImage, tags, category, visibility string) (*BlogPost, error)
	GetBlogPostByID(ctx context.Context, id string) (*BlogPost, error)
	GetBlogPostBySlug(ctx context.Context, siteID, slug string) (*BlogPost, error)
	UpdateBlogPost(ctx context.Context, id, slug, title, description, content, featuredImage, tags, category, visibility string) error
	DeleteBlogPost(ctx context.Context, id string) error
	ListBlogPosts(ctx context.Context, siteID string, status string, limit, offset int) ([]BlogPost, error)
	ListPublishedBlogPosts(ctx context.Context, siteID string, limit, offset int) ([]BlogPost, error)
	ListPublishedBlogPostsFiltered(ctx context.Context, siteID, category, tag, search string, limit, offset int) ([]BlogPost, int64, error)
	GetRelatedPosts(ctx context.Context, siteID, excludeID, category, tags string, limit int) ([]BlogPost, error)
	GetBlogPostStats(ctx context.Context, siteID string) (total, published, draft int64, err error)
	PublishBlogPost(ctx context.Context, id string) error
	UnpublishBlogPost(ctx context.Context, id string) error
	ScheduleBlogPost(ctx context.Context, id, scheduledAt string) error
	ClearSchedule(ctx context.Context, id string) error
	GetScheduledPosts(ctx context.Context) ([]BlogPost, error)
	PublishScheduledPosts(ctx context.Context) (int64, error)

	// Comments
	CreateBlogComment(ctx context.Context, id, siteID, postID, parentID, authorName, authorEmail, content, ipAddress, userAgent string) (*BlogComment, error)
	GetBlogCommentByID(ctx context.Context, id string) (*BlogComment, error)
	ListBlogComments(ctx context.Context, siteID string, status string, limit, offset int) ([]BlogComment, error)
	ListApprovedComments(ctx context.Context, postID string, limit, offset int) ([]BlogComment, error)
	ListPendingComments(ctx context.Context, siteID string, limit, offset int) ([]BlogComment, error)
	ModerateComment(ctx context.Context, id, status, moderatorID string) error
	DeleteBlogComment(ctx context.Context, id string) error
	GetCommentStats(ctx context.Context, siteID string) (total, pending, approved int64, err error)
}

type DB struct {
	*sql.DB
	// contains filtered or unexported fields
}

type DailyViewCount struct {
	Date  string
	Views int64
}

type DocAccess struct {
	ID           string
	SiteID       string
	PathPattern  string
	RequiredRole string
	Description  sql.NullString
	CreatedAt    string
	UpdatedAt    string
}

type DocsStore interface {
	CreateDocAccess(ctx context.Context, id, siteID, pathPattern, requiredRole, description string) (*DocAccess, error)
	GetDocAccessByID(ctx context.Context, id string) (*DocAccess, error)
	ListDocAccess(ctx context.Context, siteID string) ([]DocAccess, error)
	UpdateDocAccess(ctx context.Context, id, pathPattern, requiredRole, description string) error
	DeleteDocAccess(ctx context.Context, id string) error
	CheckDocAccess(ctx context.Context, siteID, path string) (*DocAccess, error)
}

type Event struct {
	ID          int64
	SiteID      string
	Name        string
	Category    sql.NullString
	Path        sql.NullString
	Value       sql.NullString
	SessionHash sql.NullString
	CreatedAt   string
}

type EventStat struct {
	Name  string
	Count int64
}

type EventStore interface {
	RecordEvent(ctx context.Context, siteID, name, category, path, value, sessionHash string) error
	GetEventStats(ctx context.Context, siteID string, since time.Time) ([]EventStat, error)
	GetEventsByName(ctx context.Context, siteID, name string, limit, offset int) ([]Event, error)
	ListRecentEvents(ctx context.Context, siteID string, limit int) ([]Event, error)
	GetTotalEventCount(ctx context.Context, siteID string, since time.Time) (int64, error)
	GetUniqueEventNames(ctx context.Context, siteID string, since time.Time) (int64, error)
}

type FeedbackStore interface {
	RecordRating(ctx context.Context, siteID, path string, rating int, feedback, sessionHash string) error
	GetRatingStats(ctx context.Context, siteID string) (avgRating float64, totalRatings int64, err error)
	GetRatingStatsExtended(ctx context.Context, siteID string) (avgRating float64, totalRatings, withComments, thisWeek int64, err error)
	GetRatingsByPath(ctx context.Context, siteID, path string) (avgRating float64, count int64, err error)
	ListRatings(ctx context.Context, siteID string, limit, offset int) ([]Rating, error)
}

type ForumBadge struct {
	ID          string
	SiteID      string
	Slug        string
	Name        string
	Description sql.NullString
	Icon        sql.NullString
	Color       sql.NullString
	Criteria    sql.NullString
	Tier        string
	IsManual    bool
	CreatedAt   string
}

type ForumBan struct {
	ID          string
	SiteID      string
	UserID      string
	BannedBy    sql.NullString
	Reason      string
	ExpiresAt   sql.NullString
	IsPermanent bool
	CreatedAt   string
	// Joined fields
	UserName   sql.NullString
	UserEmail  sql.NullString
	BannerName sql.NullString
}

type ForumBookmark struct {
	ID        string
	SiteID    string
	UserID    string
	TopicID   string
	CreatedAt string
	// Joined fields
	TopicTitle sql.NullString
	TopicSlug  sql.NullString
}

type ForumCategory struct {
	ID          string
	SiteID      string
	ParentID    sql.NullString
	Slug        string
	Name        string
	Description sql.NullString
	Color       sql.NullString
	Icon        sql.NullString
	Position    int
	IsLocked    bool
	CreatedAt   string
	UpdatedAt   string
	// Joined/computed fields
	TopicCount int64
	PostCount  int64
	Children   []ForumCategory
}

type ForumFlag struct {
	ID             string
	SiteID         string
	ReporterID     sql.NullString
	TopicID        sql.NullString
	PostID         sql.NullString
	Reason         string
	Description    sql.NullString
	Status         string
	ResolvedBy     sql.NullString
	ResolvedAt     sql.NullString
	ResolutionNote sql.NullString
	CreatedAt      string
	// Joined fields
	ReporterName sql.NullString
	ResolverName sql.NullString
	TopicTitle   sql.NullString
	PostContent  sql.NullString
}

type ForumLike struct {
	ID        string
	SiteID    string
	UserID    string
	TopicID   sql.NullString
	PostID    sql.NullString
	CreatedAt string
}

type ForumMention struct {
	ID          string
	SiteID      string
	UserID      string
	MentionedBy string
	TopicID     sql.NullString
	PostID      sql.NullString
	IsRead      bool
	CreatedAt   string
	// Joined fields
	MentionerName sql.NullString
	TopicTitle    sql.NullString
}

type ForumNotification struct {
	ID        string
	SiteID    string
	UserID    string
	Type      string
	Title     string
	Message   sql.NullString
	TopicID   sql.NullString
	PostID    sql.NullString
	ActorID   sql.NullString
	IsRead    bool
	CreatedAt string
	// Joined fields
	ActorName   sql.NullString
	ActorAvatar sql.NullString
	TopicSlug   sql.NullString
}

type ForumPost struct {
	ID         string
	SiteID     string
	TopicID    string
	ParentID   sql.NullString
	AuthorID   sql.NullString
	Content    string
	LikeCount  int64
	IsSolution bool
	EditedAt   sql.NullString
	EditedBy   sql.NullString
	CreatedAt  string
	UpdatedAt  string
	// Joined fields
	AuthorName   sql.NullString
	AuthorEmail  sql.NullString
	AuthorAvatar sql.NullString
	EditorName   sql.NullString
	IsLiked      bool
	Replies      []ForumPost
}

type ForumReputationLog struct {
	ID        string
	SiteID    string
	UserID    string
	Action    string
	Points    int
	TopicID   sql.NullString
	PostID    sql.NullString
	BadgeID   sql.NullString
	Note      sql.NullString
	CreatedAt string
}

type ForumStore interface {
	// Categories
	CreateForumCategory(ctx context.Context, id, siteID, parentID, slug, name, description, color, icon string, position int) (*ForumCategory, error)
	GetForumCategoryByID(ctx context.Context, id string) (*ForumCategory, error)
	GetForumCategoryBySlug(ctx context.Context, siteID, slug string) (*ForumCategory, error)
	ListForumCategories(ctx context.Context, siteID string) ([]ForumCategory, error)
	UpdateForumCategory(ctx context.Context, id, slug, name, description, color, icon string, position int, isLocked bool) error
	DeleteForumCategory(ctx context.Context, id string) error

	// Topics
	CreateForumTopic(ctx context.Context, id, siteID, categoryID, authorID, slug, title, content, status string) (*ForumTopic, error)
	GetForumTopicByID(ctx context.Context, id string) (*ForumTopic, error)
	GetForumTopicBySlug(ctx context.Context, siteID, slug string) (*ForumTopic, error)
	ListForumTopics(ctx context.Context, siteID, categoryID, status, search string, limit, offset int) ([]ForumTopic, int64, error)
	ListForumTopicsByTag(ctx context.Context, siteID, tagID string, limit, offset int) ([]ForumTopic, int64, error)
	UpdateForumTopic(ctx context.Context, id, title, content string) error
	UpdateForumTopicStatus(ctx context.Context, id, status string) error
	PinForumTopic(ctx context.Context, id string, pinned bool) error
	IncrementForumTopicViews(ctx context.Context, id string) error
	DeleteForumTopic(ctx context.Context, id string) error

	// Posts
	CreateForumPost(ctx context.Context, id, siteID, topicID, parentID, authorID, content string) (*ForumPost, error)
	GetForumPostByID(ctx context.Context, id string) (*ForumPost, error)
	ListForumPosts(ctx context.Context, topicID string, limit, offset int) ([]ForumPost, int64, error)
	UpdateForumPost(ctx context.Context, id, content, editorID string) error
	MarkPostAsSolution(ctx context.Context, postID, topicID string) error
	DeleteForumPost(ctx context.Context, id string) error

	// Tags
	CreateForumTag(ctx context.Context, id, siteID, slug, name, description, color string) (*ForumTag, error)
	GetForumTagByID(ctx context.Context, id string) (*ForumTag, error)
	GetForumTagBySlug(ctx context.Context, siteID, slug string) (*ForumTag, error)
	ListForumTags(ctx context.Context, siteID string) ([]ForumTag, error)
	UpdateForumTag(ctx context.Context, id, slug, name, description, color string) error
	DeleteForumTag(ctx context.Context, id string) error
	AddTagToTopic(ctx context.Context, topicID, tagID string) error
	RemoveTagFromTopic(ctx context.Context, topicID, tagID string) error
	GetTopicTags(ctx context.Context, topicID string) ([]ForumTag, error)

	// Likes
	LikeForumTopic(ctx context.Context, id, siteID, userID, topicID string) error
	UnlikeForumTopic(ctx context.Context, userID, topicID string) error
	LikeForumPost(ctx context.Context, id, siteID, userID, postID string) error
	UnlikeForumPost(ctx context.Context, userID, postID string) error
	HasUserLikedTopic(ctx context.Context, userID, topicID string) (bool, error)
	HasUserLikedPost(ctx context.Context, userID, postID string) (bool, error)

	// Bookmarks
	CreateForumBookmark(ctx context.Context, id, siteID, userID, topicID string) error
	DeleteForumBookmark(ctx context.Context, userID, topicID string) error
	HasUserBookmarkedTopic(ctx context.Context, userID, topicID string) (bool, error)
	ListUserBookmarks(ctx context.Context, userID string, limit, offset int) ([]ForumBookmark, error)

	// Subscriptions
	CreateForumSubscription(ctx context.Context, id, siteID, userID, topicID, categoryID, level string) error
	UpdateForumSubscription(ctx context.Context, userID, topicID, categoryID, level string) error
	DeleteForumSubscription(ctx context.Context, userID, topicID, categoryID string) error
	GetTopicSubscribers(ctx context.Context, topicID string) ([]string, error)

	// Notifications
	CreateForumNotification(ctx context.Context, id, siteID, userID, notifType, title, message, topicID, postID, actorID string) error
	ListForumNotifications(ctx context.Context, userID string, unreadOnly bool, limit, offset int) ([]ForumNotification, error)
	MarkNotificationRead(ctx context.Context, id string) error
	MarkAllNotificationsRead(ctx context.Context, userID string) error
	GetUnreadNotificationCount(ctx context.Context, userID string) (int64, error)

	// Flags
	CreateForumFlag(ctx context.Context, id, siteID, reporterID, topicID, postID, reason, description string) error
	GetForumFlagByID(ctx context.Context, id string) (*ForumFlag, error)
	ListForumFlags(ctx context.Context, siteID, status string, limit, offset int) ([]ForumFlag, int64, error)
	ResolveForumFlag(ctx context.Context, id, status, resolverID, resolutionNote string) error

	// Bans
	CreateForumBan(ctx context.Context, id, siteID, userID, bannedBy, reason, expiresAt string, isPermanent bool) error
	GetForumBan(ctx context.Context, siteID, userID string) (*ForumBan, error)
	IsUserBanned(ctx context.Context, siteID, userID string) (bool, error)
	ListForumBans(ctx context.Context, siteID string, limit, offset int) ([]ForumBan, int64, error)
	DeleteForumBan(ctx context.Context, siteID, userID string) error

	// User stats
	GetOrCreateForumUserStats(ctx context.Context, id, siteID, userID string) (*ForumUserStats, error)
	UpdateForumUserLastSeen(ctx context.Context, siteID, userID string) error
	IncrementForumUserStats(ctx context.Context, siteID, userID, field string, delta int) error
	GetForumLeaderboard(ctx context.Context, siteID string, limit int) ([]ForumUserStats, error)

	// Badges
	CreateForumBadge(ctx context.Context, id, siteID, slug, name, description, icon, color, criteria, tier string, isManual bool) (*ForumBadge, error)
	GetForumBadgeByID(ctx context.Context, id string) (*ForumBadge, error)
	ListForumBadges(ctx context.Context, siteID string) ([]ForumBadge, error)
	UpdateForumBadge(ctx context.Context, id, slug, name, description, icon, color, criteria, tier string, isManual bool) error
	DeleteForumBadge(ctx context.Context, id string) error
	AwardBadge(ctx context.Context, id, siteID, userID, badgeID, awardedBy string) error
	RevokeBadge(ctx context.Context, userID, badgeID string) error
	HasUserBadge(ctx context.Context, userID, badgeID string) (bool, error)
	GetUserBadges(ctx context.Context, userID string) ([]ForumUserBadge, error)

	// Reputation
	LogReputationChange(ctx context.Context, id, siteID, userID, action string, points int, topicID, postID, badgeID, note string) error
	GetReputationHistory(ctx context.Context, userID string, limit, offset int) ([]ForumReputationLog, error)

	// Stats and search
	GetForumStats(ctx context.Context, siteID string) (categories, topics, posts, users int64, err error)
	SearchForum(ctx context.Context, siteID, query string, limit, offset int) ([]ForumTopic, int64, error)
	CountUserTopicsToday(ctx context.Context, siteID, userID string) (int64, error)
	CountUserApprovedTopics(ctx context.Context, siteID, userID string) (int64, error)
	CountUserPostsToday(ctx context.Context, siteID, userID string) (int64, error)
}

type ForumSubscription struct {
	ID         string
	SiteID     string
	UserID     string
	TopicID    sql.NullString
	CategoryID sql.NullString
	Level      string
	CreatedAt  string
}

type ForumTag struct {
	ID          string
	SiteID      string
	Slug        string
	Name        string
	Description sql.NullString
	Color       sql.NullString
	UsageCount  int64
	CreatedAt   string
}

type ForumTopic struct {
	ID             string
	SiteID         string
	CategoryID     sql.NullString
	AuthorID       sql.NullString
	Slug           string
	Title          string
	Content        string
	Status         string
	IsPinned       bool
	IsSolved       bool
	SolutionPostID sql.NullString
	ViewCount      int64
	LikeCount      int64
	PostCount      int64
	LastPostAt     sql.NullString
	LastPostBy     sql.NullString
	CreatedAt      string
	UpdatedAt      string
	// Joined fields
	AuthorName     sql.NullString
	AuthorEmail    sql.NullString
	AuthorAvatar   sql.NullString
	CategoryName   sql.NullString
	CategorySlug   sql.NullString
	LastPostAuthor sql.NullString
	Tags           []ForumTag
	IsLiked        bool
	IsBookmarked   bool
}

type ForumUserBadge struct {
	ID        string
	SiteID    string
	UserID    string
	BadgeID   string
	AwardedBy sql.NullString
	AwardedAt string
	// Joined fields
	BadgeName  sql.NullString
	BadgeIcon  sql.NullString
	BadgeColor sql.NullString
	BadgeTier  sql.NullString
}

type ForumUserStats struct {
	ID                string
	SiteID            string
	UserID            string
	Reputation        int64
	TopicCount        int64
	PostCount         int64
	LikeReceivedCount int64
	LikeGivenCount    int64
	SolutionCount     int64
	LastSeenAt        sql.NullString
	CreatedAt         string
	UpdatedAt         string
	// Joined fields
	UserName   sql.NullString
	UserEmail  sql.NullString
	UserAvatar sql.NullString
	Badges     []ForumUserBadge
}

type NewsletterStore interface {
	CreateSubscriber(ctx context.Context, id, siteID, email, verifyToken string) error
	CreateVerifiedSubscriber(ctx context.Context, id, siteID, email, provider, displayName string) error
	GetSubscriberByEmail(ctx context.Context, siteID, email string) (*Subscriber, error)
	GetSubscriberByToken(ctx context.Context, siteID, token string) (*Subscriber, error)
	VerifySubscriber(ctx context.Context, siteID, token string) error
	UnsubscribeByEmail(ctx context.Context, siteID, email string) error
	ListSubscribers(ctx context.Context, siteID string, verifiedOnly bool) ([]Subscriber, error)
	CountSubscribers(ctx context.Context, siteID string, verifiedOnly bool) (int64, error)
	GetSubscriberStatsExtended(ctx context.Context, siteID string) (total, verified, pending, thisMonth int64, err error)
}

type PageView struct {
	ID          int64
	SiteID      string
	Path        string
	Referrer    sql.NullString
	Country     sql.NullString
	DeviceType  sql.NullString
	Browser     sql.NullString
	OS          sql.NullString
	SessionHash sql.NullString
	CreatedAt   string
}

type Rating struct {
	ID          int64
	SiteID      string
	Path        string
	Rating      int
	Feedback    sql.NullString
	SessionHash sql.NullString
	CreatedAt   string
}

type Session struct {
	ID        string
	UserID    string
	TokenHash string
	IPAddress sql.NullString
	UserAgent sql.NullString
	ExpiresAt string
	CreatedAt string
}

type SessionStore interface {
	CreateSession(ctx context.Context, id, userID, tokenHash, ipAddress, userAgent string, expiresAt time.Time) error
	GetSessionByToken(ctx context.Context, tokenHash string) (*Session, error)
	DeleteSession(ctx context.Context, tokenHash string) error
	DeleteUserSessions(ctx context.Context, userID string) error
	CleanExpiredSessions(ctx context.Context) (int64, error)
}

type Site struct {
	ID        string
	Name      string
	Domain    sql.NullString
	APIKey    string
	Config    string
	CreatedAt string // SQLite returns string
	UpdatedAt string
}

type SiteStore interface {
	CreateSite(ctx context.Context, id, name, domain, apiKeyHash string) (*Site, error)
	GetSiteByID(ctx context.Context, id string) (*Site, error)
	GetSiteByAPIKey(ctx context.Context, apiKeyHash string) (*Site, error)
	ListSites(ctx context.Context) ([]Site, error)
	UpdateSite(ctx context.Context, id, name, domain string) error
	UpdateSiteAPIKey(ctx context.Context, siteID, newAPIKeyHash string) error
	DeleteSite(ctx context.Context, id string) error
}

type Store interface {
	AnalyticsStore
	AuditStore
	BlogStore
	DocsStore
	EventStore
	FeedbackStore
	ForumStore
	NewsletterStore
	SessionStore
	SiteStore
	UploadStore
	UserStore

	// Core methods
	Ping(ctx context.Context) error
	Driver() string
	Close() error
}

type Subscriber struct {
	ID               string
	SiteID           string
	Email            string
	Verified         bool
	VerifyToken      sql.NullString
	VerifySentAt     sql.NullString
	SubscribedAt     string
	UnsubscribedAt   sql.NullString
	OAuthProvider    string
	OAuthDisplayName string
	VerifiedVia      string
}

type TrafficSource struct {
	Source string
	Visits int64
}

type Upload struct {
	ID          string
	SiteID      string
	UserID      string
	Filename    string
	MimeType    string
	SizeBytes   int64
	StoragePath string
	URL         string
	CreatedAt   string
}

type UploadStore interface {
	CreateUpload(ctx context.Context, id, siteID, userID, filename, mimeType string, sizeBytes int64, storagePath, url string) (*Upload, error)
	GetUpload(ctx context.Context, id string) (*Upload, error)
	DeleteUpload(ctx context.Context, id string) error
	ListUploads(ctx context.Context, siteID, userID string, limit, offset int) ([]Upload, error)
}

type User struct {
	ID            string
	SiteID        string
	Email         string
	PasswordHash  sql.NullString
	Role          string
	OAuthProvider sql.NullString
	OAuthID       sql.NullString
	Name          sql.NullString
	AvatarURL     sql.NullString
	EmailVerified bool
	VerifyToken   sql.NullString
	CreatedAt     string
	UpdatedAt     string
	LastLoginAt   sql.NullString
}

type UserStore interface {
	CreateUser(ctx context.Context, id, siteID, email, passwordHash, role, name string) (*User, error)
	GetUserByID(ctx context.Context, id string) (*User, error)
	GetUserByEmail(ctx context.Context, siteID, email string) (*User, error)
	GetUserByOAuth(ctx context.Context, provider, providerID string) (*User, error)
	ListUsers(ctx context.Context, siteID string) ([]User, error)
	UpdateUserLastLogin(ctx context.Context, userID string) error
	DeleteUser(ctx context.Context, id string) error
	UpdateUser(ctx context.Context, id, email, role, name string) error
	UpdateUserPassword(ctx context.Context, id, passwordHash string) error
	CountUsers(ctx context.Context, siteID string) (int, error)
	CountUsersByRole(ctx context.Context, siteID, role string) (int, error)
	CreateUserWithVerification(ctx context.Context, id, siteID, email, passwordHash, role, name, verifyToken string) (*User, error)
	GetUserByVerifyToken(ctx context.Context, token string) (*User, error)
	VerifyUserEmail(ctx context.Context, userID string) error
	CreateUserWithOAuth(ctx context.Context, id, siteID, email, oauthProvider, oauthID, name, avatarURL, role string) (*User, error)
	LinkOAuthToUser(ctx context.Context, userID, oauthProvider, oauthID string) error
}