reposdb

type AuthAuditLog struct {
	ID         int64
	ActorID    pgtype.Int8
	Action     string
	TargetType string
	TargetID   pgtype.Int8
	Meta       []byte
	CreatedAt  pgtype.Timestamptz
}

type AuthThrottle struct {
	ID              int64
	Scope           string
	Identifier      string
	Hits            int32
	WindowStartedAt pgtype.Timestamptz
}

type BranchProtectionRule struct {
	ID                             int64
	RepoID                         int64
	Pattern                        string
	PreventForcePush               bool
	PreventDeletion                bool
	RequirePrForPush               bool
	AllowedPusherUserIds           []int64
	RequireSignedCommits           bool
	StatusChecksRequired           []string
	CreatedAt                      pgtype.Timestamptz
	UpdatedAt                      pgtype.Timestamptz
	CreatedByUserID                pgtype.Int8
	RequiredReviewCount            int32
	DismissStaleReviewsOnPush      bool
	RequireCodeOwnerReview         bool
	DismissStaleStatusChecksOnPush bool
}

type CheckConclusion string

type CheckRun struct {
	ID          int64
	SuiteID     int64
	RepoID      int64
	HeadSha     string
	Name        string
	Status      CheckStatus
	Conclusion  NullCheckConclusion
	StartedAt   pgtype.Timestamptz
	CompletedAt pgtype.Timestamptz
	DetailsUrl  string
	Output      []byte
	ExternalID  pgtype.Text
	CreatedAt   pgtype.Timestamptz
	UpdatedAt   pgtype.Timestamptz
}

type CheckStatus string

type CheckSuite struct {
	ID         int64
	RepoID     int64
	HeadSha    string
	AppSlug    string
	Status     CheckStatus
	Conclusion NullCheckConclusion
	CreatedAt  pgtype.Timestamptz
	UpdatedAt  pgtype.Timestamptz
}

type CodeSearchContent struct {
	RepoID      int64
	RefName     string
	Path        string
	ContentTsv  interface{}
	ContentTrgm string
}

type CodeSearchPath struct {
	RepoID  int64
	RefName string
	Path    string
	Tsv     interface{}
}

type CollabRole string

type CreateForkRepoParams struct {
	OwnerUserID   pgtype.Int8
	OwnerOrgID    pgtype.Int8
	Name          string
	Description   string
	Visibility    RepoVisibility
	DefaultBranch string
	ForkOfRepoID  pgtype.Int8
}

type CreateRepoParams struct {
	OwnerUserID     pgtype.Int8
	OwnerOrgID      pgtype.Int8
	Name            string
	Description     string
	Visibility      RepoVisibility
	DefaultBranch   string
	LicenseKey      pgtype.Text
	PrimaryLanguage pgtype.Text
}

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

type DeleteRedirectByUserOwnerOldNameParams struct {
	RepoID         int64
	OldOwnerUserID pgtype.Int8
	OldName        string
}

type DomainEvent struct {
	ID          int64
	ActorUserID pgtype.Int8
	Kind        string
	RepoID      pgtype.Int8
	SourceKind  string
	SourceID    int64
	Public      bool
	Payload     []byte
	CreatedAt   pgtype.Timestamptz
}

type DomainEventsProcessed struct {
	Consumer    string
	LastEventID int64
	UpdatedAt   pgtype.Timestamptz
}

type EmailVerification struct {
	ID          int64
	UserEmailID int64
	TokenHash   []byte
	ExpiresAt   pgtype.Timestamptz
	UsedAt      pgtype.Timestamptz
	CreatedAt   pgtype.Timestamptz
}

type ExistsRepoForOwnerOrgParams struct {
	OwnerOrgID pgtype.Int8
	Name       string
}

type ExistsRepoForOwnerUserParams struct {
	OwnerUserID pgtype.Int8
	Name        string
}

type GetRepoByOwnerOrgAndNameParams struct {
	OwnerOrgID pgtype.Int8
	Name       string
}

type GetRepoByOwnerUserAndNameParams struct {
	OwnerUserID pgtype.Int8
	Name        string
}

type GetRepoOwnerUsernameByIDRow struct {
	OwnerUsername string
	RepoName      string
}

type InsertRepoRedirectParams struct {
	OldName        string
	RepoID         int64
	OldOwnerUserID pgtype.Int8
	OldOwnerOrgID  pgtype.Int8
}

type InsertRepoTopicParams struct {
	RepoID int64
	Topic  string
}

type InsertTransferRequestParams struct {
	RepoID          int64
	FromUserID      int64
	ToPrincipalKind TransferPrincipalKind
	ToPrincipalID   int64
	CreatedBy       int64
	ExpiresAt       pgtype.Timestamptz
}

type Issue struct {
	ID                int64
	RepoID            int64
	Number            int64
	Kind              IssueKind
	Title             string
	Body              string
	BodyHtmlCached    pgtype.Text
	MdPipelineVersion int32
	AuthorUserID      pgtype.Int8
	State             IssueState
	StateReason       NullIssueStateReason
	Locked            bool
	LockReason        pgtype.Text
	MilestoneID       pgtype.Int8
	CreatedAt         pgtype.Timestamptz
	UpdatedAt         pgtype.Timestamptz
	EditedAt          pgtype.Timestamptz
	ClosedAt          pgtype.Timestamptz
	ClosedByUserID    pgtype.Int8
}

type IssueAssignee struct {
	IssueID          int64
	UserID           int64
	AssignedAt       pgtype.Timestamptz
	AssignedByUserID pgtype.Int8
}

type IssueComment struct {
	ID                int64
	IssueID           int64
	AuthorUserID      pgtype.Int8
	Body              string
	BodyHtmlCached    pgtype.Text
	MdPipelineVersion int32
	CreatedAt         pgtype.Timestamptz
	UpdatedAt         pgtype.Timestamptz
	EditedAt          pgtype.Timestamptz
}

type IssueEvent struct {
	ID          int64
	IssueID     int64
	ActorUserID pgtype.Int8
	Kind        string
	Meta        []byte
	RefTargetID pgtype.Int8
	CreatedAt   pgtype.Timestamptz
}

type IssueKind string

type IssueLabel struct {
	IssueID         int64
	LabelID         int64
	AppliedAt       pgtype.Timestamptz
	AppliedByUserID pgtype.Int8
}

type IssueRefSource string

type IssueReference struct {
	ID             int64
	SourceIssueID  pgtype.Int8
	TargetIssueID  int64
	SourceKind     IssueRefSource
	SourceObjectID pgtype.Int8
	CreatedAt      pgtype.Timestamptz
}

type IssueState string

type IssueStateReason string

type IssuesSearch struct {
	IssueID      int64
	RepoID       int64
	Kind         IssueKind
	State        IssueState
	AuthorUserID pgtype.Int8
	Tsv          interface{}
}

type Job struct {
	ID          int64
	Kind        string
	Payload     []byte
	RunAt       pgtype.Timestamptz
	Attempts    int32
	MaxAttempts int32
	LastError   pgtype.Text
	LockedBy    pgtype.Text
	LockedAt    pgtype.Timestamptz
	CompletedAt pgtype.Timestamptz
	FailedAt    pgtype.Timestamptz
	CreatedAt   pgtype.Timestamptz
}

type Label struct {
	ID          int64
	RepoID      int64
	Name        string
	Color       string
	Description string
	CreatedAt   pgtype.Timestamptz
}

type ListAllRepoFullNamesRow struct {
	ID            int64
	Name          string
	OwnerUsername string
}

type ListForksOfRepoForRepackRow struct {
	ID            int64
	Name          string
	OwnerUsername string
}

type ListForksOfRepoParams struct {
	ForkOfRepoID pgtype.Int8
	Limit        int32
	Offset       int32
}

type ListForksOfRepoRow struct {
	ID               int64
	Name             string
	Description      string
	Visibility       RepoVisibility
	CreatedAt        pgtype.Timestamptz
	StarCount        int64
	ForkCount        int64
	InitStatus       RepoInitStatus
	OwnerUsername    string
	OwnerDisplayName string
}

type ListReposNeedingReindexRow struct {
	ID               int64
	Name             string
	DefaultBranch    string
	DefaultBranchOid pgtype.Text
}

type ListSoftDeletedReposForOwnerRow struct {
	ID          int64
	OwnerUserID pgtype.Int8
	Name        string
	DeletedAt   pgtype.Timestamptz
}

type LookupRedirectByUserOwnerParams struct {
	OldOwnerUserID pgtype.Int8
	OldName        string
}

type Meta struct {
	Key       string
	Value     []byte
	UpdatedAt pgtype.Timestamptz
}

type Milestone struct {
	ID          int64
	RepoID      int64
	Title       string
	Description string
	State       MilestoneState
	DueOn       pgtype.Timestamptz
	CreatedAt   pgtype.Timestamptz
	ClosedAt    pgtype.Timestamptz
}

type MilestoneState string

type Notification struct {
	ID              int64
	RecipientUserID int64
	Kind            string
	Reason          string
	RepoID          pgtype.Int8
	ThreadKind      NullNotificationThreadKind
	ThreadID        pgtype.Int8
	SourceEventID   pgtype.Int8
	Unread          bool
	LastEventAt     pgtype.Timestamptz
	LastActorUserID pgtype.Int8
	Summary         []byte
	CreatedAt       pgtype.Timestamptz
	UpdatedAt       pgtype.Timestamptz
}

type NotificationEmailLog struct {
	ID              int64
	RecipientUserID int64
	NotificationID  pgtype.Int8
	ThreadKind      NullNotificationThreadKind
	ThreadID        pgtype.Int8
	SentAt          pgtype.Timestamptz
	MessageID       pgtype.Text
}

type NotificationThread struct {
	RecipientUserID int64
	ThreadKind      NotificationThreadKind
	ThreadID        int64
	Subscribed      bool
	Reason          string
	UpdatedAt       pgtype.Timestamptz
}

type NotificationThreadKind string

type NullCheckConclusion struct {
	CheckConclusion CheckConclusion
	Valid           bool // Valid is true if CheckConclusion is not NULL
}

type NullCheckStatus struct {
	CheckStatus CheckStatus
	Valid       bool // Valid is true if CheckStatus is not NULL
}

type NullCollabRole struct {
	CollabRole CollabRole
	Valid      bool // Valid is true if CollabRole is not NULL
}

type NullIssueKind struct {
	IssueKind IssueKind
	Valid     bool // Valid is true if IssueKind is not NULL
}

type NullIssueRefSource struct {
	IssueRefSource IssueRefSource
	Valid          bool // Valid is true if IssueRefSource is not NULL
}

type NullIssueState struct {
	IssueState IssueState
	Valid      bool // Valid is true if IssueState is not NULL
}

type NullIssueStateReason struct {
	IssueStateReason IssueStateReason
	Valid            bool // Valid is true if IssueStateReason is not NULL
}

type NullMilestoneState struct {
	MilestoneState MilestoneState
	Valid          bool // Valid is true if MilestoneState is not NULL
}

type NullNotificationThreadKind struct {
	NotificationThreadKind NotificationThreadKind
	Valid                  bool // Valid is true if NotificationThreadKind is not NULL
}

type NullOrgPlan struct {
	OrgPlan OrgPlan
	Valid   bool // Valid is true if OrgPlan is not NULL
}

type NullOrgRole struct {
	OrgRole OrgRole
	Valid   bool // Valid is true if OrgRole is not NULL
}

type NullPrFileStatus struct {
	PrFileStatus PrFileStatus
	Valid        bool // Valid is true if PrFileStatus is not NULL
}

type NullPrMergeMethod struct {
	PrMergeMethod PrMergeMethod
	Valid         bool // Valid is true if PrMergeMethod is not NULL
}

type NullPrMergeableState struct {
	PrMergeableState PrMergeableState
	Valid            bool // Valid is true if PrMergeableState is not NULL
}

type NullPrReviewSide struct {
	PrReviewSide PrReviewSide
	Valid        bool // Valid is true if PrReviewSide is not NULL
}

type NullPrReviewState struct {
	PrReviewState PrReviewState
	Valid         bool // Valid is true if PrReviewState is not NULL
}

type NullPrincipalKind struct {
	PrincipalKind PrincipalKind
	Valid         bool // Valid is true if PrincipalKind is not NULL
}

type NullRepoInitStatus struct {
	RepoInitStatus RepoInitStatus
	Valid          bool // Valid is true if RepoInitStatus is not NULL
}

type NullRepoVisibility struct {
	RepoVisibility RepoVisibility
	Valid          bool // Valid is true if RepoVisibility is not NULL
}

type NullTeamPrivacy struct {
	TeamPrivacy TeamPrivacy
	Valid       bool // Valid is true if TeamPrivacy is not NULL
}

type NullTeamRepoRole struct {
	TeamRepoRole TeamRepoRole
	Valid        bool // Valid is true if TeamRepoRole is not NULL
}

type NullTeamRole struct {
	TeamRole TeamRole
	Valid    bool // Valid is true if TeamRole is not NULL
}

type NullTransactionalEmailStatus struct {
	TransactionalEmailStatus TransactionalEmailStatus
	Valid                    bool // Valid is true if TransactionalEmailStatus is not NULL
}

type NullTransferPrincipalKind struct {
	TransferPrincipalKind TransferPrincipalKind
	Valid                 bool // Valid is true if TransferPrincipalKind is not NULL
}

type NullTransferStatus struct {
	TransferStatus TransferStatus
	Valid          bool // Valid is true if TransferStatus is not NULL
}

type NullWatchLevel struct {
	WatchLevel WatchLevel
	Valid      bool // Valid is true if WatchLevel is not NULL
}

type NullWebhookContentType struct {
	WebhookContentType WebhookContentType
	Valid              bool // Valid is true if WebhookContentType is not NULL
}

type NullWebhookDeliveryStatus struct {
	WebhookDeliveryStatus WebhookDeliveryStatus
	Valid                 bool // Valid is true if WebhookDeliveryStatus is not NULL
}

type NullWebhookOwnerKind struct {
	WebhookOwnerKind WebhookOwnerKind
	Valid            bool // Valid is true if WebhookOwnerKind is not NULL
}

type Org struct {
	ID                    int64
	Slug                  string
	DisplayName           string
	Description           string
	AvatarObjectKey       pgtype.Text
	Location              string
	Website               string
	BillingEmail          string
	Plan                  OrgPlan
	AllowMemberRepoCreate bool
	CreatedByUserID       pgtype.Int8
	SuspendedAt           pgtype.Timestamptz
	SuspendedReason       pgtype.Text
	DeletedAt             pgtype.Timestamptz
	CreatedAt             pgtype.Timestamptz
	UpdatedAt             pgtype.Timestamptz
}

type OrgInvitation struct {
	ID              int64
	OrgID           int64
	InvitedByUserID pgtype.Int8
	TargetUserID    pgtype.Int8
	TargetEmail     pgtype.Text
	Role            OrgRole
	TokenHash       []byte
	ExpiresAt       pgtype.Timestamptz
	AcceptedAt      pgtype.Timestamptz
	DeclinedAt      pgtype.Timestamptz
	CanceledAt      pgtype.Timestamptz
	CreatedAt       pgtype.Timestamptz
}

type OrgMember struct {
	OrgID           int64
	UserID          int64
	Role            OrgRole
	InvitedByUserID pgtype.Int8
	JoinedAt        pgtype.Timestamptz
}

type OrgPlan string

type OrgRole string

type PasswordReset struct {
	ID        int64
	UserID    int64
	TokenHash []byte
	ExpiresAt pgtype.Timestamptz
	UsedAt    pgtype.Timestamptz
	CreatedAt pgtype.Timestamptz
}

type PrFileStatus string

type PrMergeMethod string

type PrMergeableState string

type PrReview struct {
	ID                int64
	PrIssueID         int64
	AuthorUserID      pgtype.Int8
	State             PrReviewState
	Body              string
	BodyHtmlCached    pgtype.Text
	SubmittedAt       pgtype.Timestamptz
	DismissedAt       pgtype.Timestamptz
	DismissedByUserID pgtype.Int8
	DismissalReason   string
}

type PrReviewComment struct {
	ID                int64
	PrIssueID         int64
	ReviewID          pgtype.Int8
	AuthorUserID      pgtype.Int8
	FilePath          string
	Side              PrReviewSide
	OriginalCommitSha string
	OriginalLine      int32
	OriginalPosition  int32
	CurrentPosition   pgtype.Int4
	Body              string
	BodyHtmlCached    pgtype.Text
	InReplyToID       pgtype.Int8
	Pending           bool
	ResolvedAt        pgtype.Timestamptz
	ResolvedByUserID  pgtype.Int8
	CreatedAt         pgtype.Timestamptz
	UpdatedAt         pgtype.Timestamptz
	EditedAt          pgtype.Timestamptz
}

type PrReviewRequest struct {
	ID                  int64
	PrIssueID           int64
	RequestedUserID     pgtype.Int8
	RequestedTeamID     pgtype.Int8
	RequestedByUserID   pgtype.Int8
	RequestedAt         pgtype.Timestamptz
	DismissedAt         pgtype.Timestamptz
	SatisfiedByReviewID pgtype.Int8
}

type PrReviewSide string

type PrReviewState string

type Principal struct {
	Slug string
	Kind PrincipalKind
	ID   int64
}

type PrincipalKind string

type PullRequest struct {
	IssueID            int64
	BaseRef            string
	HeadRef            string
	HeadRepoID         int64
	BaseOid            string
	HeadOid            string
	Draft              bool
	Mergeable          pgtype.Bool
	MergeableState     PrMergeableState
	MergeCommitSha     pgtype.Text
	MergedAt           pgtype.Timestamptz
	MergedByUserID     pgtype.Int8
	MergeMethod        NullPrMergeMethod
	BaseOidAtMerge     pgtype.Text
	HeadOidAtMerge     pgtype.Text
	LastSynchronizedAt pgtype.Timestamptz
}

type PullRequestCommit struct {
	PrID           int64
	Sha            string
	Position       int32
	AuthorName     string
	AuthorEmail    string
	CommitterName  string
	CommitterEmail string
	Subject        string
	Body           string
	AuthoredAt     pgtype.Timestamptz
	CommittedAt    pgtype.Timestamptz
}

type PullRequestFile struct {
	PrID      int64
	Path      string
	Status    PrFileStatus
	OldPath   pgtype.Text
	Additions int32
	Deletions int32
	Changes   int32
}

type PushEvent struct {
	ID           int64
	RepoID       int64
	PusherUserID pgtype.Int8
	BeforeSha    string
	AfterSha     string
	Ref          string
	Protocol     string
	RequestID    string
	ProcessedAt  pgtype.Timestamptz
	CreatedAt    pgtype.Timestamptz
}

type Querier interface {
	AcceptTransferRequest(ctx context.Context, db DBTX, id int64) error
	ArchiveRepo(ctx context.Context, db DBTX, id int64) error
	CancelTransferRequest(ctx context.Context, db DBTX, id int64) error
	CountForksOfRepo(ctx context.Context, db DBTX, forkOfRepoID pgtype.Int8) (int64, error)
	// ─── rename rate limit support ─────────────────────────────────────────
	// Used to enforce the 5-per-30-days rename rate limit. The redirect
	// row is the audit trail for renames; counting them per repo gives a
	// reliable cap.
	CountRecentRedirectsForRepo(ctx context.Context, db DBTX, repoID int64) (int32, error)
	CountReposForOwnerUser(ctx context.Context, db DBTX, ownerUserID pgtype.Int8) (int64, error)
	// ─── S27 forks ─────────────────────────────────────────────────────
	// Insert a fork shell. Distinct from CreateRepo because forks set
	// `fork_of_repo_id` (which fires the fork_count trigger) and start
	// at init_status='init_pending' so the worker job can flip them to
	// 'initialized' once `git clone --bare --shared` finishes.
	CreateForkRepo(ctx context.Context, db DBTX, arg CreateForkRepoParams) (Repo, error)
	// SPDX-License-Identifier: AGPL-3.0-or-later
	CreateRepo(ctx context.Context, db DBTX, arg CreateRepoParams) (Repo, error)
	DeclineTransferRequest(ctx context.Context, db DBTX, id int64) error
	DeleteBranchProtectionRule(ctx context.Context, db DBTX, id int64) error
	// Used by the rename compensator: drop a single redirect row when
	// the rename has to be rolled back due to a filesystem failure. We
	// avoided raw SQL here at the audit's request (S00-S25, M).
	DeleteRedirectByUserOwnerOldName(ctx context.Context, db DBTX, arg DeleteRedirectByUserOwnerOldNameParams) error
	// Used by hard-delete: drop the redirect rows pointing at this repo
	// (they would dangle once the repos row is gone; the FK ON DELETE
	// CASCADE would handle it, but explicit is auditable).
	DeleteRedirectsForRepo(ctx context.Context, db DBTX, repoID int64) error
	ExistsRepoForOwnerOrg(ctx context.Context, db DBTX, arg ExistsRepoForOwnerOrgParams) (bool, error)
	ExistsRepoForOwnerUser(ctx context.Context, db DBTX, arg ExistsRepoForOwnerUserParams) (bool, error)
	// Called by the periodic worker (transfers:expire) — flips pending
	// offers past their expires_at to the expired terminal state.
	ExpirePendingTransfers(ctx context.Context, db DBTX) (int64, error)
	GetBranchProtectionRule(ctx context.Context, db DBTX, id int64) (BranchProtectionRule, error)
	GetRepoByID(ctx context.Context, db DBTX, id int64) (Repo, error)
	// S30: org-owner mirror of GetRepoByOwnerUserAndName. The (owner_org_id,
	// name) partial unique index from 0017 backs this lookup with the same
	// O(1) cost the user-side path enjoys.
	GetRepoByOwnerOrgAndName(ctx context.Context, db DBTX, arg GetRepoByOwnerOrgAndNameParams) (Repo, error)
	GetRepoByOwnerUserAndName(ctx context.Context, db DBTX, arg GetRepoByOwnerUserAndNameParams) (Repo, error)
	// Returns the owner_username for a repo. Used by size-recalc and other
	// jobs that need to derive the bare-repo on-disk path without round-
	// tripping through the full user row.
	GetRepoOwnerUsernameByID(ctx context.Context, db DBTX, id int64) (GetRepoOwnerUsernameByIDRow, error)
	GetTransferRequest(ctx context.Context, db DBTX, id int64) (RepoTransferRequest, error)
	HardDeleteRepo(ctx context.Context, db DBTX, id int64) error
	// ─── redirects ─────────────────────────────────────────────────────────
	// Both old-owner FKs are nullable; pass exactly one. The CHECK
	// constraint on the table enforces the xor shape.
	InsertRepoRedirect(ctx context.Context, db DBTX, arg InsertRepoRedirectParams) error
	InsertRepoTopic(ctx context.Context, db DBTX, arg InsertRepoTopicParams) error
	// ─── transfer requests ─────────────────────────────────────────────────
	InsertTransferRequest(ctx context.Context, db DBTX, arg InsertTransferRequestParams) (RepoTransferRequest, error)
	// Used by `shithubd hooks reinstall --all` to enumerate every active
	// bare repo on disk and re-link its hooks.
	ListAllRepoFullNames(ctx context.Context, db DBTX) ([]ListAllRepoFullNamesRow, error)
	// SPDX-License-Identifier: AGPL-3.0-or-later
	ListBranchProtectionRules(ctx context.Context, db DBTX, repoID int64) ([]BranchProtectionRule, error)
	// Forks of a given source repo, paginated, recency-sorted. Joined
	// with users for the owner display name. Excludes soft-deleted.
	ListForksOfRepo(ctx context.Context, db DBTX, arg ListForksOfRepoParams) ([]ListForksOfRepoRow, error)
	// Used by S16's hard-delete cascade (S27 amendment): before deleting
	// a source repo, every fork must `git repack -a -d --no-shared` so
	// it has its own copy of the objects. Returns just enough to locate
	// the bare repo on disk.
	ListForksOfRepoForRepack(ctx context.Context, db DBTX, forkOfRepoID pgtype.Int8) ([]ListForksOfRepoForRepackRow, error)
	// Inbox view: pending offers a user can act on.
	ListPendingTransfersForUser(ctx context.Context, db DBTX, toPrincipalID int64) ([]RepoTransferRequest, error)
	// ─── soft-delete sweep query ───────────────────────────────────────────
	// The repo:hard_delete enqueuer queries this to find rows ready for
	// destruction. The 7-day grace is hard-coded here; if we add a config
	// knob later, change this to a parameter.
	ListRepoIDsPastSoftDeleteGrace(ctx context.Context, db DBTX) ([]int64, error)
	// ─── repo_topics (S32) ─────────────────────────────────────────────
	ListRepoTopics(ctx context.Context, db DBTX, repoID int64) ([]string, error)
	ListReposForOwnerOrg(ctx context.Context, db DBTX, ownerOrgID pgtype.Int8) ([]Repo, error)
	ListReposForOwnerUser(ctx context.Context, db DBTX, ownerUserID pgtype.Int8) ([]Repo, error)
	// S28 code-search reconciler: returns repos whose default_branch_oid
	// has advanced past last_indexed_oid (or last_indexed_oid is NULL
	// and a default exists). Limited so a single tick of the cron
	// doesn't try to re-index the whole world.
	ListReposNeedingReindex(ctx context.Context, db DBTX, limit int32) ([]ListReposNeedingReindexRow, error)
	// /settings/repositories/restore page lists these.
	ListSoftDeletedReposForOwner(ctx context.Context, db DBTX, ownerUserID pgtype.Int8) ([]ListSoftDeletedReposForOwnerRow, error)
	// Sender / repo-settings view.
	ListTransfersForRepo(ctx context.Context, db DBTX, repoID int64) ([]RepoTransferRequest, error)
	// Returns the current repo_id when (old_owner_user_id, old_name) hits
	// a redirect row.
	LookupRedirectByUserOwner(ctx context.Context, db DBTX, arg LookupRedirectByUserOwnerParams) (int64, error)
	// ─── fork-anchor cleanup on hard delete ────────────────────────────────
	// Children pointing at this repo lose their fork-of pointer. Mirrors
	// GitHub's behavior when an upstream is deleted.
	OrphanForksOf(ctx context.Context, db DBTX, forkOfRepoID pgtype.Int8) (int64, error)
	// SPDX-License-Identifier: AGPL-3.0-or-later
	//
	// S16 lifecycle queries. Kept in a separate file from repos.sql so the
	// mainline CRUD stays easy to read.
	// ─── repo mutations ────────────────────────────────────────────────────
	// Same-owner rename. The handler validates the new name shape and the
	// redirect row is INSERTed in the same tx.
	RenameRepo(ctx context.Context, db DBTX, arg RenameRepoParams) error
	// Atomic full-replace: callers compose the new topic set in Go,
	// then replace the existing rows in one tx (DELETE + INSERT). The
	// caller's tx wraps both calls for atomicity.
	ReplaceRepoTopics(ctx context.Context, db DBTX, repoID int64) error
	RestoreRepo(ctx context.Context, db DBTX, id int64) error
	// S28 code-search: the worker writes the OID it finished indexing
	// so the reconciler can detect drift (default_branch_oid moved but
	// last_indexed_oid lagged).
	SetLastIndexedOID(ctx context.Context, db DBTX, arg SetLastIndexedOIDParams) error
	// Promotes a fork from init_pending to initialized (or init_failed).
	// The DB row is created up-front so the URL resolves immediately and
	// the user sees a "preparing your fork" placeholder while the worker
	// runs `git clone --bare --shared`.
	SetRepoInitStatus(ctx context.Context, db DBTX, arg SetRepoInitStatusParams) error
	SetRepoVisibility(ctx context.Context, db DBTX, arg SetRepoVisibilityParams) error
	SoftDeleteRepo(ctx context.Context, db DBTX, id int64) error
	// Distinct name from S11's SoftDeleteRepo so future code that wants to
	// preserve the lifecycle audit-emission shape can find this one.
	SoftDeleteRepoLifecycle(ctx context.Context, db DBTX, id int64) error
	// Sets owner_user_id (or owner_org_id post-S31) on accept. The xor
	// check on the table enforces the shape. Also clears the other side
	// so a user→org transfer flips both columns atomically.
	TransferRepoOwner(ctx context.Context, db DBTX, arg TransferRepoOwnerParams) error
	UnarchiveRepo(ctx context.Context, db DBTX, id int64) error
	// S24 surface for the required-status-check knobs. Branch-protection
	// edit handler calls this alongside UpdateBranchProtectionRule.
	UpdateBranchProtectionCheckSettings(ctx context.Context, db DBTX, arg UpdateBranchProtectionCheckSettingsParams) error
	// S23 surface for the review-related knobs. Branch-protection edit
	// handler calls this alongside UpdateBranchProtectionRule.
	UpdateBranchProtectionReviewSettings(ctx context.Context, db DBTX, arg UpdateBranchProtectionReviewSettingsParams) error
	UpdateBranchProtectionRule(ctx context.Context, db DBTX, arg UpdateBranchProtectionRuleParams) error
	// Used by the default-branch settings handler. The on-disk HEAD update
	// is a separate step done via `git symbolic-ref` from the orchestrator.
	UpdateRepoDefaultBranch(ctx context.Context, db DBTX, arg UpdateRepoDefaultBranchParams) error
	// Set when push:process detects a commit on the repo's default branch.
	// Pass NULL to clear (e.g. when the branch is force-deleted in a future
	// sprint). The repo home view reads this to decide between empty and
	// populated layouts.
	UpdateRepoDefaultBranchOID(ctx context.Context, db DBTX, arg UpdateRepoDefaultBranchOIDParams) error
	UpdateRepoDiskUsed(ctx context.Context, db DBTX, arg UpdateRepoDiskUsedParams) error
	// S32: General-tab settings persist via this single query so each
	// form post is one round-trip. The merge-method toggles are kept
	// separate from the repo create flow because they're admin-only.
	UpdateRepoGeneralSettings(ctx context.Context, db DBTX, arg UpdateRepoGeneralSettingsParams) error
	UpdateRepoMergeSettings(ctx context.Context, db DBTX, arg UpdateRepoMergeSettingsParams) error
	UpsertBranchProtectionRule(ctx context.Context, db DBTX, arg UpsertBranchProtectionRuleParams) (int64, error)
}

type Queries struct {
}

type RateLimit struct {
	Scope           string
	Key             string
	Hits            int32
	WindowStartedAt pgtype.Timestamptz
}

type RenameRepoParams struct {
	ID   int64
	Name string
}

type Repo struct {
	ID                 int64
	OwnerUserID        pgtype.Int8
	OwnerOrgID         pgtype.Int8
	Name               string
	Description        string
	Visibility         RepoVisibility
	DefaultBranch      string
	IsArchived         bool
	ArchivedAt         pgtype.Timestamptz
	DeletedAt          pgtype.Timestamptz
	DiskUsedBytes      int64
	ForkOfRepoID       pgtype.Int8
	LicenseKey         pgtype.Text
	PrimaryLanguage    pgtype.Text
	HasIssues          bool
	HasPulls           bool
	CreatedAt          pgtype.Timestamptz
	UpdatedAt          pgtype.Timestamptz
	DefaultBranchOid   pgtype.Text
	AllowSquashMerge   bool
	AllowRebaseMerge   bool
	AllowMergeCommit   bool
	DefaultMergeMethod PrMergeMethod
	StarCount          int64
	WatcherCount       int64
	ForkCount          int64
	InitStatus         RepoInitStatus
	LastIndexedOid     pgtype.Text
}

type RepoCollaborator struct {
	RepoID        int64
	UserID        int64
	Role          CollabRole
	AddedAt       pgtype.Timestamptz
	AddedByUserID pgtype.Int8
}

type RepoInitStatus string

type RepoIssueCounter struct {
	RepoID     int64
	NextNumber int64
}

type RepoRedirect struct {
	OldOwnerUserID pgtype.Int8
	OldOwnerOrgID  pgtype.Int8
	OldName        string
	RepoID         int64
	RedirectedAt   pgtype.Timestamptz
}

type RepoTopic struct {
	RepoID    int64
	Topic     string
	CreatedAt pgtype.Timestamptz
}

type RepoTransferRequest struct {
	ID              int64
	RepoID          int64
	FromUserID      int64
	ToPrincipalKind TransferPrincipalKind
	ToPrincipalID   int64
	CreatedBy       int64
	CreatedAt       pgtype.Timestamptz
	ExpiresAt       pgtype.Timestamptz
	Status          TransferStatus
	AcceptedAt      pgtype.Timestamptz
	DeclinedAt      pgtype.Timestamptz
	CanceledAt      pgtype.Timestamptz
}

type RepoVisibility string

type ReposSearch struct {
	RepoID int64
	Tsv    interface{}
}

type SetLastIndexedOIDParams struct {
	ID             int64
	LastIndexedOid pgtype.Text
}

type SetRepoInitStatusParams struct {
	ID         int64
	InitStatus RepoInitStatus
}

type SetRepoVisibilityParams struct {
	ID         int64
	Visibility RepoVisibility
}

type SignupIpThrottle struct {
	Cidr            netip.Addr
	Hits            int32
	WindowStartedAt pgtype.Timestamptz
}

type Star struct {
	UserID    int64
	RepoID    int64
	StarredAt pgtype.Timestamptz
}

type Team struct {
	ID              int64
	OrgID           int64
	Slug            string
	DisplayName     string
	Description     string
	ParentTeamID    pgtype.Int8
	Privacy         TeamPrivacy
	CreatedByUserID pgtype.Int8
	CreatedAt       pgtype.Timestamptz
	UpdatedAt       pgtype.Timestamptz
}

type TeamMember struct {
	TeamID        int64
	UserID        int64
	Role          TeamRole
	AddedByUserID pgtype.Int8
	AddedAt       pgtype.Timestamptz
}

type TeamPrivacy string

type TeamRepoAccess struct {
	TeamID        int64
	RepoID        int64
	Role          TeamRepoRole
	AddedByUserID pgtype.Int8
	AddedAt       pgtype.Timestamptz
}

type TeamRepoRole string

type TeamRole string

type TransactionalEmailLog struct {
	ID              int64
	RecipientUserID pgtype.Int8
	RecipientEmail  string
	Kind            string
	Subject         string
	ProviderID      string
	Status          TransactionalEmailStatus
	ErrorSummary    pgtype.Text
	SentAt          pgtype.Timestamptz
	DeliveredAt     pgtype.Timestamptz
}

type TransactionalEmailStatus string

type TransferPrincipalKind string

type TransferRepoOwnerParams struct {
	ID          int64
	Name        string
	OwnerUserID pgtype.Int8
	OwnerOrgID  pgtype.Int8
}

type TransferStatus string

type UpdateBranchProtectionCheckSettingsParams struct {
	ID                             int64
	StatusChecksRequired           []string
	DismissStaleStatusChecksOnPush bool
}

type UpdateBranchProtectionReviewSettingsParams struct {
	ID                        int64
	RequiredReviewCount       int32
	DismissStaleReviewsOnPush bool
	RequireCodeOwnerReview    bool
}

type UpdateBranchProtectionRuleParams struct {
	ID                   int64
	Pattern              string
	PreventForcePush     bool
	PreventDeletion      bool
	RequirePrForPush     bool
	AllowedPusherUserIds []int64
}

type UpdateRepoDefaultBranchOIDParams struct {
	ID               int64
	DefaultBranchOid pgtype.Text
}

type UpdateRepoDefaultBranchParams struct {
	ID            int64
	DefaultBranch string
}

type UpdateRepoDiskUsedParams struct {
	ID            int64
	DiskUsedBytes int64
}

type UpdateRepoGeneralSettingsParams struct {
	ID          int64
	Description string
	HasIssues   bool
	HasPulls    bool
}

type UpdateRepoMergeSettingsParams struct {
	ID                 int64
	AllowMergeCommit   bool
	AllowSquashMerge   bool
	AllowRebaseMerge   bool
	DefaultMergeMethod PrMergeMethod
}

type UpsertBranchProtectionRuleParams struct {
	RepoID               int64
	Pattern              string
	PreventForcePush     bool
	PreventDeletion      bool
	RequirePrForPush     bool
	AllowedPusherUserIds []int64
	CreatedByUserID      pgtype.Int8
}

type User struct {
	ID                int64
	Username          string
	DisplayName       string
	PrimaryEmailID    pgtype.Int8
	PasswordHash      string
	PasswordAlgo      string
	PasswordUpdatedAt pgtype.Timestamptz
	EmailVerified     bool
	LastLoginAt       pgtype.Timestamptz
	SuspendedAt       pgtype.Timestamptz
	SuspendedReason   pgtype.Text
	DeletedAt         pgtype.Timestamptz
	CreatedAt         pgtype.Timestamptz
	UpdatedAt         pgtype.Timestamptz
	Bio               string
	Location          string
	Website           string
	Company           string
	Pronouns          string
	AvatarObjectKey   pgtype.Text
	Theme             string
	SessionEpoch      int32
	IsSiteAdmin       bool
}

type UserEmail struct {
	ID                    int64
	UserID                int64
	Email                 string
	IsPrimary             bool
	Verified              bool
	VerificationTokenHash []byte
	VerificationSentAt    pgtype.Timestamptz
	VerifiedAt            pgtype.Timestamptz
	CreatedAt             pgtype.Timestamptz
}

type UserNotificationPref struct {
	UserID    int64
	Key       string
	Value     []byte
	UpdatedAt pgtype.Timestamptz
}

type UserRecoveryCode struct {
	ID          int64
	UserID      int64
	CodeHash    []byte
	UsedAt      pgtype.Timestamptz
	GeneratedAt pgtype.Timestamptz
	CreatedAt   pgtype.Timestamptz
}

type UserSshKey struct {
	ID                int64
	UserID            int64
	Title             string
	FingerprintSha256 string
	KeyType           string
	KeyBits           int32
	PublicKey         string
	LastUsedAt        pgtype.Timestamptz
	LastUsedIp        *netip.Addr
	CreatedAt         pgtype.Timestamptz
}

type UserToken struct {
	ID          int64
	UserID      int64
	Name        string
	TokenHash   []byte
	TokenPrefix string
	Scopes      []string
	ExpiresAt   pgtype.Timestamptz
	LastUsedAt  pgtype.Timestamptz
	LastUsedIp  *netip.Addr
	RevokedAt   pgtype.Timestamptz
	CreatedAt   pgtype.Timestamptz
}

type UserTotp struct {
	ID              int64
	UserID          int64
	SecretEncrypted []byte
	SecretNonce     []byte
	ConfirmedAt     pgtype.Timestamptz
	LastUsedCounter int64
	CreatedAt       pgtype.Timestamptz
	UpdatedAt       pgtype.Timestamptz
}

type UsernameRedirect struct {
	OldUsername string
	UserID      int64
	ChangedAt   pgtype.Timestamptz
}

type UsersSearch struct {
	UserID int64
	Tsv    interface{}
}

type Watch struct {
	UserID    int64
	RepoID    int64
	Level     WatchLevel
	UpdatedAt pgtype.Timestamptz
}

type WatchLevel string

type Webhook struct {
	ID                   int64
	OwnerKind            WebhookOwnerKind
	OwnerID              int64
	Url                  string
	ContentType          WebhookContentType
	Events               []string
	SecretCiphertext     []byte
	SecretNonce          []byte
	Active               bool
	SslVerification      bool
	ConsecutiveFailures  int32
	AutoDisableThreshold int32
	DisabledAt           pgtype.Timestamptz
	DisabledReason       pgtype.Text
	LastSuccessAt        pgtype.Timestamptz
	LastFailureAt        pgtype.Timestamptz
	CreatedByUserID      pgtype.Int8
	CreatedAt            pgtype.Timestamptz
	UpdatedAt            pgtype.Timestamptz
}

type WebhookContentType string

type WebhookDelivery struct {
	ID                int64
	WebhookID         int64
	EventKind         string
	EventID           pgtype.Int8
	DeliveryUuid      pgtype.UUID
	Payload           []byte
	RequestHeaders    []byte
	RequestBody       []byte
	ResponseStatus    pgtype.Int4
	ResponseHeaders   []byte
	ResponseBody      []byte
	ResponseTruncated bool
	StartedAt         pgtype.Timestamptz
	CompletedAt       pgtype.Timestamptz
	Attempt           int32
	MaxAttempts       int32
	NextRetryAt       pgtype.Timestamptz
	Status            WebhookDeliveryStatus
	IdempotencyKey    string
	ErrorSummary      pgtype.Text
	RedeliverOf       pgtype.Int8
}

type WebhookDeliveryStatus string

type WebhookEventsPending struct {
	ID        int64
	RepoID    int64
	EventKind string
	Payload   []byte
	CreatedAt pgtype.Timestamptz
}

type WebhookOwnerKind string