models

type Actor struct {
	Did    string `gorm:"primaryKey"`
	Handle string `gorm:"uniqueIndex"`
}

type Blob struct {
	ID        uint
	CreatedAt string `gorm:"index"`
	Did       string `gorm:"index;index:idx_blob_did_cid"`
	Cid       []byte `gorm:"index;index:idx_blob_did_cid"`
	MimeType  string
	Size      int64
	RefCount  int
	Storage   string `gorm:"default:sqlite"`
	// Bucket and ObjectKey are immutable S3 identity for this blob generation.
	// Empty ObjectKey is retained for legacy rows, which resolve to the original
	// blobs/{did}/{cid} location at read/deletion time.
	Bucket    string
	ObjectKey string
}

type BlobDeletion struct {
	ID             uint   `gorm:"primaryKey"`
	IdempotencyKey string `gorm:"uniqueIndex"`
	Bucket         string
	ObjectKey      string
	Status         string `gorm:"index:idx_blob_deletions_status"`
	AttemptCount   int
	NextAttemptAt  *time.Time `gorm:"index"`
	LastError      string
	DeletedAt      *time.Time
	CreatedAt      time.Time
	UpdatedAt      time.Time
}

type BlobPart struct {
	Blob   Blob
	BlobID uint `gorm:"primaryKey"`
	Idx    int  `gorm:"primaryKey"`
	Data   []byte
}

type Block struct {
	Did   string `gorm:"primaryKey;index:idx_blocks_by_rev"`
	Cid   []byte `gorm:"primaryKey"`
	Rev   string `gorm:"index:idx_blocks_by_rev,sort:desc"`
	Value []byte
}

type EventRecord struct {
	Seq       int64 `gorm:"primaryKey;autoIncrement:false"`
	CreatedAt time.Time
	Did       string `gorm:"index"`
	Type      string
	Data      []byte
}

type InviteCode struct {
	Code              string `gorm:"primaryKey"`
	Did               string `gorm:"index"`
	RemainingUseCount int
}

type Record struct {
	Did       string `gorm:"primaryKey:idx_record_did_created_at;index:idx_record_did_nsid"`
	CreatedAt string `gorm:"index;index:idx_record_did_created_at,sort:desc"`
	Nsid      string `gorm:"primaryKey;index:idx_record_did_nsid"`
	Rkey      string `gorm:"primaryKey"`
	Cid       string
	Value     []byte
}

type RefreshToken struct {
	Token     string `gorm:"primaryKey"`
	Did       string `gorm:"index"`
	CreatedAt time.Time
	ExpiresAt time.Time `gorm:"index:,sort:asc"`
}

type Repo struct {
	Did                            string `gorm:"primaryKey"`
	CreatedAt                      time.Time
	Email                          string `gorm:"uniqueIndex"`
	EmailConfirmedAt               *time.Time
	EmailVerificationCode          *string
	EmailVerificationCodeExpiresAt *time.Time
	EmailUpdateCode                *string
	EmailUpdateCodeExpiresAt       *time.Time
	PasswordResetCode              *string
	PasswordResetCodeExpiresAt     *time.Time
	PlcOperationCode               *string
	PlcOperationCodeExpiresAt      *time.Time
	AccountDeleteCode              *string
	AccountDeleteCodeExpiresAt     *time.Time
	Password                       string
	SigningKey                     []byte
	Rev                            string
	Root                           []byte
	Preferences                    []byte
	Deactivated                    bool
	Suspended                      bool
	Takendown                      bool
	TwoFactorCode                  *string
	TwoFactorCodeExpiresAt         *time.Time
	TwoFactorType                  TwoFactorType `gorm:"default:none"`
}

type RepoActor struct {
	Repo
	Actor
}

type ReservedKey struct {
	KeyDid     string  `gorm:"primaryKey"`
	Did        *string `gorm:"index"`
	PrivateKey []byte
	CreatedAt  time.Time `gorm:"index"`
}

type SimpleSpace struct {
	URI              string `gorm:"primaryKey"`
	OwnerDID         string `gorm:"column:owner_did;index:idx_simple_spaces_owner"`
	Type             string
	SKey             string
	Policy           string
	ManagingApp      *string
	AppAccess        string
	AllowedClientIDs []byte

	Deleted   bool       `gorm:"index:idx_simple_spaces_deleted"`
	DeletedAt *time.Time `gorm:"index"`
	CreatedAt time.Time
	UpdatedAt time.Time
}

type SimpleSpaceMember struct {
	Space string `gorm:"primaryKey;index:idx_simple_space_members_space"`
	DID   string `gorm:"column:did;primaryKey;index:idx_simple_space_members_did"`

	CreatedAt time.Time
	UpdatedAt time.Time
	RemovedAt *time.Time `gorm:"index"`
}

type SpaceBlobRef struct {
	Space      string `gorm:"primaryKey;index:idx_space_blob_refs_record;index:idx_space_blob_refs_space_author_cid"`
	Author     string `gorm:"primaryKey;index:idx_space_blob_refs_record;index:idx_space_blob_refs_space_author_cid"`
	Collection string `gorm:"primaryKey;index:idx_space_blob_refs_record"`
	Rkey       string `gorm:"primaryKey;index:idx_space_blob_refs_record"`
	CID        string `gorm:"column:cid;primaryKey;index:idx_space_blob_refs_cid;index:idx_space_blob_refs_space_author_cid"`

	CreatedAt time.Time
	UpdatedAt time.Time
}

type SpaceNotifyDelivery struct {
	ID             uint   `gorm:"primaryKey"`
	IdempotencyKey string `gorm:"uniqueIndex"`
	Kind           string `gorm:"index:idx_space_notify_deliveries_kind"`

	Space   string `gorm:"index:idx_space_notify_deliveries_space"`
	Service string `gorm:"index:idx_space_notify_deliveries_service"`
	Author  string
	Rev     string
	Hash    []byte
	Deleted bool
	Payload []byte

	Status        string `gorm:"index:idx_space_notify_deliveries_status"`
	AttemptCount  int
	NextAttemptAt *time.Time `gorm:"index"`
	ExpiresAt     time.Time  `gorm:"index"`
	DeliveredAt   *time.Time
	LastError     string
	CreatedAt     time.Time
	UpdatedAt     time.Time
}

type SpaceNotifyRegistration struct {
	Space   string `gorm:"primaryKey;index:idx_space_notify_registrations_space"`
	Service string `gorm:"primaryKey;index:idx_space_notify_registrations_space"`

	ExpiresAt time.Time `gorm:"index"`
	CreatedAt time.Time
	UpdatedAt time.Time
}

type SpaceRecord struct {
	Space         string `gorm:"primaryKey;index:idx_space_records_space_author"`
	Author        string `gorm:"primaryKey;index:idx_space_records_space_author"`
	Collection    string `gorm:"primaryKey;index:idx_space_records_record"`
	Rkey          string `gorm:"primaryKey;index:idx_space_records_record"`
	CID           string `gorm:"column:cid"`
	CanonicalCBOR []byte
	CreatedAt     time.Time
	UpdatedAt     time.Time
}

type SpaceReplay = SpaceReplayJTI

type SpaceReplayJTI struct {
	JTI       string    `gorm:"primaryKey"`
	TokenType string    `gorm:"index:idx_space_replay_jtis_type"`
	ExpiresAt time.Time `gorm:"index"`
	CreatedAt time.Time
}

type SpaceRepo struct {
	Space  string `gorm:"primaryKey;index:idx_space_repos_space_author"`
	Author string `gorm:"primaryKey;index:idx_space_repos_space_author"`

	Rev    string `gorm:"index:idx_space_repos_rev,sort:desc"`
	LtHash []byte `gorm:"not null"`

	Status    string     `gorm:"index:idx_space_repos_status"`
	Deleted   bool       `gorm:"index:idx_space_repos_deleted"`
	DeletedAt *time.Time `gorm:"index"`
	CreatedAt time.Time
	UpdatedAt time.Time
}

type SpaceRepoOp struct {
	Space  string `gorm:"primaryKey;index:idx_space_repo_ops_repo"`
	Author string `gorm:"primaryKey;index:idx_space_repo_ops_repo"`
	Rev    string `gorm:"primaryKey;index:idx_space_repo_ops_repo,sort:asc"`
	Idx    int    `gorm:"primaryKey;index:idx_space_repo_ops_repo,sort:asc"`

	Collection  string
	Rkey        string
	CurrentCID  *string `gorm:"column:current_cid"`
	PreviousCID *string `gorm:"column:previous_cid"`
	CreatedAt   time.Time
}

type SpaceTombstone struct {
	Space              string `gorm:"primaryKey"`
	OwnerDID           string `gorm:"column:owner_did"`
	SourceDID          string `gorm:"column:source_did"`
	SourceNotification string
	DeletedAt          time.Time `gorm:"index"`
	CreatedAt          time.Time
}

type SpaceWriter struct {
	Space  string `gorm:"primaryKey;index:idx_space_writers_space"`
	Author string `gorm:"primaryKey;index:idx_space_writers_space"`

	Host           string
	Rev            string
	Hash           []byte
	LastNotifiedAt *time.Time `gorm:"index"`
	Status         string     `gorm:"index:idx_space_writers_status"`
	DeletedAt      *time.Time `gorm:"index"`
	CreatedAt      time.Time
	UpdatedAt      time.Time
}

type Token struct {
	Token        string `gorm:"primaryKey"`
	Did          string `gorm:"index"`
	RefreshToken string `gorm:"index"`
	CreatedAt    time.Time
	ExpiresAt    time.Time `gorm:"index:,sort:asc"`
}

type TwoFactorType string