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"`
	RefCount  int
	Storage   string `gorm:"default:sqlite"`
}

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"`
	SessionVersion int64  `gorm:"not null;default:0"`
	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 `gorm:"index"`
	PasswordResetCodeExpiresAt     *time.Time
	PlcOperationCode               *string
	PlcOperationCodeExpiresAt      *time.Time
	AccountDeleteCode              *string
	AccountDeleteCodeExpiresAt     *time.Time
	Password                       string
	SessionVersion                 int64 `gorm:"not null;default:0"`
	SigningKey                     []byte
	// KemKey is the account's #atproto_kem P-256 private key, with which it
	// establishes shared secrets for space repo MACs. Nil until created.
	KemKey      []byte
	Rev         string
	Root        []byte
	Preferences []byte
	Deactivated bool
	// TakedownRef marks an account taken down. Space data of a taken-down
	// account is neither served nor written.
	TakedownRef            *string
	TwoFactorCode          *string
	TwoFactorCodeExpiresAt *time.Time
	TwoFactorType          TwoFactorType `gorm:"default:none"`
	// Failed second-factor attempts since the last success, and the time
	// until which further attempts are refused once too many have failed.
	TwoFactorFailedAttempts int `gorm:"not null;default:0"`
	TwoFactorLockedUntil    *time.Time
}

type RepoActor struct {
	Repo
	Actor
}

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

type RevokedSpaceCredential struct {
	Space     string `gorm:"primaryKey"`
	Jti       string `gorm:"primaryKey"`
	ExpiresAt string `gorm:"not null;index"`
}

type SimplespaceConfig struct {
	Did              string `gorm:"primaryKey"`
	Uri              string `gorm:"primaryKey"`
	ReadPolicy       string `gorm:"not null"`
	ReadManagingApp  *string
	WritePolicy      string `gorm:"not null"`
	WriteManagingApp *string
	AppAccessType    string `gorm:"not null"`
	AppAllowed       string `gorm:"not null"` // JSON array of client IDs
}

type SimplespaceMember struct {
	Did       string `gorm:"primaryKey"`
	Space     string `gorm:"primaryKey"`
	MemberDid string `gorm:"primaryKey"`
	Read      bool   `gorm:"not null"`
	Write     bool   `gorm:"not null"`
}

type Space struct {
	Did       string `gorm:"primaryKey"`
	Uri       string `gorm:"primaryKey"`
	Authority string `gorm:"not null;index"`
	Type      string `gorm:"not null"`
	CreatedAt string `gorm:"not null"`
	DeletedAt *string
}

type SpaceCredentialRecipient struct {
	Did             string `gorm:"primaryKey"`
	Space           string `gorm:"primaryKey"`
	ServiceDid      string `gorm:"primaryKey"`
	ServiceEndpoint string `gorm:"not null"`
	ExpiresAt       string `gorm:"not null"`
}

type SpaceDeletedNotificationRetry struct {
	Space     string `gorm:"primaryKey"`
	Service   string `gorm:"primaryKey"`
	Attempts  int    `gorm:"not null"`
	RetryAt   int64  `gorm:"not null;index"`
	ExpiresAt int64  `gorm:"not null"`
}

type SpaceNotificationRetry struct {
	Repo    string `gorm:"primaryKey"`
	Space   string `gorm:"primaryKey"`
	RepoRev string `gorm:"not null"`
	// Data is the commit data to notify. The column keeps its name from
	// before the protocol renamed the field from hash.
	Data      []byte `gorm:"column:hash;not null"`
	Attempts  int    `gorm:"not null"`
	RetryAt   int64  `gorm:"not null;index"`
	ExpiresAt int64  `gorm:"not null"`
}

type SpaceRecord struct {
	Uri        string `gorm:"primaryKey"`
	Did        string `gorm:"not null;uniqueIndex:idx_space_record_path,priority:1;index:idx_space_record_rev,priority:1"`
	Space      string `gorm:"not null;uniqueIndex:idx_space_record_path,priority:2;index:idx_space_record_rev,priority:2"`
	Collection string `gorm:"not null;uniqueIndex:idx_space_record_path,priority:3"`
	Rkey       string `gorm:"not null;uniqueIndex:idx_space_record_path,priority:4"`
	Cid        string `gorm:"not null"`
	Value      []byte `gorm:"not null"`
	RepoRev    string `gorm:"not null;index:idx_space_record_rev,priority:3"`
	IndexedAt  string `gorm:"not null"`
}

type SpaceRecordBlob struct {
	Did       string `gorm:"not null;index"`
	BlobCid   string `gorm:"primaryKey"`
	RecordUri string `gorm:"primaryKey;index"`
}

type SpaceRecordOplog struct {
	Did        string `gorm:"primaryKey"`
	Space      string `gorm:"primaryKey"`
	Rev        string `gorm:"primaryKey"`
	Idx        int    `gorm:"primaryKey;autoIncrement:false"`
	Action     string `gorm:"not null"`
	Uri        string `gorm:"not null"`
	Collection string `gorm:"not null"`
	Rkey       string `gorm:"not null"`
	Cid        *string
	Prev       *string
}

type SpaceRepo struct {
	Did     string `gorm:"primaryKey"`
	Space   string `gorm:"primaryKey"`
	SetHash []byte
	Rev     *string
}

type SpaceUsedJti struct {
	Namespace string `gorm:"primaryKey"`
	Jti       string `gorm:"primaryKey"`
	ExpiresAt int64  `gorm:"not null;index"`
}

type SpaceWriter struct {
	Did       string `gorm:"primaryKey"`
	Space     string `gorm:"primaryKey;index:idx_space_writer_space_rev,priority:1"`
	WriterDid string `gorm:"primaryKey"`
	RepoRev   string `gorm:"not null"`
	SpaceRev  string `gorm:"not null;index:idx_space_writer_space_rev,priority:2"`
	// Data is the commit data (the set hash digest) last reported. The column
	// keeps its name from before the protocol renamed the field from hash.
	Data []byte `gorm:"column:hash;not null"`
}

type Token struct {
	Token          string `gorm:"primaryKey"`
	Did            string `gorm:"index"`
	SessionVersion int64  `gorm:"not null;default:0"`
	RefreshToken   string `gorm:"index"`
	CreatedAt      time.Time
	ExpiresAt      time.Time `gorm:"index:,sort:asc"`
}

type TwoFactorBackupCode struct {
	ID        uint   `gorm:"primaryKey"`
	Did       string `gorm:"index;not null"`
	CodeHash  []byte
	CreatedAt time.Time
	UsedAt    *time.Time
}

type TwoFactorCredential struct {
	ID        uint   `gorm:"primaryKey"`
	Did       string `gorm:"index;not null"`
	Type      TwoFactorCredentialType
	Name      string
	CreatedAt time.Time
	// TOTP shared secret, or the YubiKey slot's AES-128 key. Empty for a
	// YubiKey registered as it came from the factory, whose OTPs are checked
	// with Yubico's YubiCloud service instead (see UsesYubiCloud).
	Secret []byte
	// Yubico OTP only: the modhex public identity typed before each OTP, and
	// the 6-byte private identity found inside the encrypted block.
	PublicID  string `gorm:"index"`
	PrivateID []byte
	// Replay protection. TOTP stores the last accepted time step; Yubico OTP
	// stores the last accepted (session counter, session use) pair.
	LastStep    int64 `gorm:"not null;default:0"`
	LastCounter int   `gorm:"not null;default:0"`
	LastUse     int   `gorm:"not null;default:0"`
	LastUsedAt  *time.Time
}

type TwoFactorCredentialType string

type TwoFactorType string