A desktop coding agent with free access to frontier models.
TypeScript
import * as crypto from "node:crypto"
import { sql } from "drizzle-orm"
import { bigint, boolean, index, int, json, mysqlTable, text, timestamp, uniqueIndex, varchar } from "drizzle-orm/mysql-core"
import { denTypeIdColumn, encryptedTextColumn } from "../columns"
export const AuthUserTable = mysqlTable(
"user",
{
id: denTypeIdColumn("user", "id").notNull().primaryKey(),
name: varchar("name", { length: 255 }).notNull(),
email: varchar("email", { length: 255 }).notNull(),
emailVerified: boolean("email_verified").notNull().default(false),
image: text("image"),
createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
updatedAt: timestamp("updated_at", { fsp: 3 })
.notNull()
.default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`),
},
(table) => [uniqueIndex("user_email").on(table.email), index("user_created_at_id").on(table.createdAt, table.id)],
)
export const AuthSessionTable = mysqlTable(
"session",
{
id: denTypeIdColumn("session", "id").notNull().primaryKey(),
userId: denTypeIdColumn("user", "user_id").notNull(),
activeOrganizationId: denTypeIdColumn("organization", "active_organization_id"),
activeTeamId: denTypeIdColumn("team", "active_team_id"),
token: varchar("token", { length: 255 }).notNull(),
expiresAt: timestamp("expires_at", { fsp: 3 }).notNull(),
ipAddress: text("ip_address"),
userAgent: text("user_agent"),
createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
updatedAt: timestamp("updated_at", { fsp: 3 })
.notNull()
.default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`),
},
(table) => [uniqueIndex("session_token").on(table.token), index("session_user_id").on(table.userId)],
)
export const AuthAccountTable = mysqlTable(
"account",
{
id: denTypeIdColumn("account", "id").notNull().primaryKey(),
userId: denTypeIdColumn("user", "user_id").notNull(),
accountId: text("account_id").notNull(),
providerId: text("provider_id").notNull(),
accessToken: text("access_token"),
refreshToken: text("refresh_token"),
accessTokenExpiresAt: timestamp("access_token_expires_at", { fsp: 3 }),
refreshTokenExpiresAt: timestamp("refresh_token_expires_at", { fsp: 3 }),
scope: text("scope"),
idToken: text("id_token"),
password: text("password"),
createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
updatedAt: timestamp("updated_at", { fsp: 3 })
.notNull()
.default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`),
},
(table) => [
index("account_user_id").on(table.userId),
index("account_account_id_provider_id").on(sql`${table.accountId}(191)`, sql`${table.providerId}(191)`),
],
)
export const AuthVerificationTable = mysqlTable(
"verification",
{
// Better Auth uses both generated IDs and deterministic 43-character
// SHA-256 reservations here (for example, SAML assertion replay guards).
id: varchar("id", { length: 64 }).notNull().primaryKey(),
identifier: varchar("identifier", { length: 255 }).notNull(),
value: text("value").notNull(),
expiresAt: timestamp("expires_at", { fsp: 3 }).notNull(),
createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
updatedAt: timestamp("updated_at", { fsp: 3 })
.notNull()
.default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`),
},
(table) => [index("verification_identifier").on(table.identifier)],
)
export const AuthApiKeyTable = mysqlTable(
"apikey",
{
id: varchar("id", { length: 64 }).notNull().primaryKey(),
configId: varchar("config_id", { length: 255 }).notNull().default("default"),
name: varchar("name", { length: 255 }),
start: varchar("start", { length: 32 }),
prefix: varchar("prefix", { length: 255 }),
key: varchar("key", { length: 255 }).notNull(),
referenceId: varchar("reference_id", { length: 64 }).notNull(),
refillInterval: bigint("refill_interval", { mode: "number" }),
refillAmount: int("refill_amount"),
lastRefillAt: timestamp("last_refill_at", { fsp: 3 }),
enabled: boolean("enabled").notNull().default(true),
rateLimitEnabled: boolean("rate_limit_enabled").notNull().default(true),
rateLimitTimeWindow: bigint("rate_limit_time_window", { mode: "number" }),
rateLimitMax: int("rate_limit_max"),
requestCount: int("request_count").default(0),
remaining: int("remaining"),
lastRequest: timestamp("last_request", { fsp: 3 }),
expiresAt: timestamp("expires_at", { fsp: 3 }),
createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
updatedAt: timestamp("updated_at", { fsp: 3 })
.notNull()
.default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`),
permissions: text("permissions"),
metadata: text("metadata"),
},
(table) => [
index("apikey_config_id").on(table.configId),
index("apikey_reference_id").on(table.referenceId),
index("apikey_key").on(table.key),
],
)
export const AuthJwksTable = mysqlTable("jwks", {
id: varchar("id", { length: 64 })
.notNull()
.$defaultFn(() => crypto.randomUUID())
.primaryKey(),
publicKey: text("public_key").notNull(),
privateKey: text("private_key").notNull(),
createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
expiresAt: timestamp("expires_at", { fsp: 3 }),
alg: varchar("alg", { length: 32 }),
crv: varchar("crv", { length: 32 }),
})
export const OAuthClientTable = mysqlTable(
"oauthClient",
{
id: denTypeIdColumn("oauthClient", "id").notNull().primaryKey(),
clientId: varchar("client_id", { length: 255 }).notNull(),
clientSecret: text("client_secret"),
disabled: boolean("disabled").default(false),
skipConsent: boolean("skip_consent"),
enableEndSession: boolean("enable_end_session"),
subjectType: varchar("subject_type", { length: 64 }),
scopes: text("scopes"),
userId: denTypeIdColumn("user", "user_id"),
createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
updatedAt: timestamp("updated_at", { fsp: 3 })
.notNull()
.default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`),
name: varchar("name", { length: 255 }),
uri: text("uri"),
icon: text("icon"),
contacts: text("contacts"),
tos: text("tos"),
policy: text("policy"),
softwareId: varchar("software_id", { length: 255 }),
softwareVersion: varchar("software_version", { length: 255 }),
softwareStatement: text("software_statement"),
redirectUris: text("redirect_uris").notNull(),
postLogoutRedirectUris: text("post_logout_redirect_uris"),
tokenEndpointAuthMethod: varchar("token_endpoint_auth_method", { length: 128 }),
grantTypes: text("grant_types"),
responseTypes: text("response_types"),
public: boolean("public"),
type: varchar("type", { length: 64 }),
requirePKCE: boolean("require_pkce"),
referenceId: varchar("reference_id", { length: 64 }),
metadata: text("metadata"),
backchannelLogoutUri: text("backchannel_logout_uri"),
backchannelLogoutSessionRequired: boolean("backchannel_logout_session_required"),
jwks: text("jwks"),
jwksUri: text("jwks_uri"),
dpopBoundAccessTokens: boolean("dpop_bound_access_tokens"),
},
(table) => [
uniqueIndex("oauth_client_client_id").on(table.clientId),
index("oauth_client_user_id").on(table.userId),
index("oauth_client_reference_id").on(table.referenceId),
],
)
export const OAuthRefreshTokenTable = mysqlTable(
"oauthRefreshToken",
{
id: denTypeIdColumn("oauthRefreshToken", "id").notNull().primaryKey(),
token: text("token").notNull(),
clientId: varchar("client_id", { length: 255 }).notNull(),
sessionId: denTypeIdColumn("session", "session_id"),
userId: denTypeIdColumn("user", "user_id").notNull(),
referenceId: varchar("reference_id", { length: 64 }),
expiresAt: timestamp("expires_at", { fsp: 3 }).notNull(),
createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
revoked: timestamp("revoked", { fsp: 3 }),
authTime: timestamp("auth_time", { fsp: 3 }),
scopes: text("scopes").notNull(),
authorizationCodeId: varchar("authorization_code_id", { length: 64 }),
resources: text("resources"),
requestedUserInfoClaims: text("requested_user_info_claims"),
rotatedAt: timestamp("rotated_at", { fsp: 3 }),
rotationReplayResponse: text("rotation_replay_response"),
rotationReplayExpiresAt: timestamp("rotation_replay_expires_at", { fsp: 3 }),
confirmation: text("confirmation"),
},
(table) => [
index("oauth_refresh_token_token").on(sql`${table.token}(191)`),
index("oauth_refresh_token_client_id").on(table.clientId),
index("oauth_refresh_token_session_id").on(table.sessionId),
index("oauth_refresh_token_user_id").on(table.userId),
index("oauth_refresh_token_reference_id").on(table.referenceId),
],
)
export const OAuthAccessTokenTable = mysqlTable(
"oauthAccessToken",
{
id: denTypeIdColumn("oauthAccessToken", "id").notNull().primaryKey(),
token: text("token").notNull(),
clientId: varchar("client_id", { length: 255 }).notNull(),
sessionId: denTypeIdColumn("session", "session_id"),
userId: denTypeIdColumn("user", "user_id"),
referenceId: varchar("reference_id", { length: 64 }),
refreshId: denTypeIdColumn("oauthRefreshToken", "refresh_id"),
expiresAt: timestamp("expires_at", { fsp: 3 }).notNull(),
createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
scopes: text("scopes").notNull(),
authorizationCodeId: varchar("authorization_code_id", { length: 64 }),
resources: text("resources"),
requestedUserInfoClaims: text("requested_user_info_claims"),
revoked: timestamp("revoked", { fsp: 3 }),
confirmation: text("confirmation"),
},
(table) => [
index("oauth_access_token_token").on(sql`${table.token}(191)`),
index("oauth_access_token_client_id").on(table.clientId),
index("oauth_access_token_session_id").on(table.sessionId),
index("oauth_access_token_user_id").on(table.userId),
index("oauth_access_token_reference_id").on(table.referenceId),
index("oauth_access_token_refresh_id").on(table.refreshId),
],
)
export const OAuthConsentTable = mysqlTable(
"oauthConsent",
{
id: denTypeIdColumn("oauthConsent", "id").notNull().primaryKey(),
clientId: varchar("client_id", { length: 255 }).notNull(),
userId: denTypeIdColumn("user", "user_id"),
referenceId: varchar("reference_id", { length: 64 }),
scopes: text("scopes").notNull(),
resources: text("resources"),
requestedUserInfoClaims: text("requested_user_info_claims"),
createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
updatedAt: timestamp("updated_at", { fsp: 3 })
.notNull()
.default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`),
},
(table) => [
index("oauth_consent_client_id").on(table.clientId),
index("oauth_consent_user_id").on(table.userId),
index("oauth_consent_reference_id").on(table.referenceId),
],
)
export const OAuthResourceTable = mysqlTable(
"oauthResource",
{
id: varchar("id", { length: 64 }).notNull().primaryKey(),
identifier: varchar("identifier", { length: 255 }).notNull(),
name: varchar("name", { length: 255 }).notNull(),
accessTokenTtl: int("access_token_ttl"),
refreshTokenTtl: int("refresh_token_ttl"),
signingAlgorithm: varchar("signing_algorithm", { length: 64 }),
signingKeyId: varchar("signing_key_id", { length: 255 }),
allowedScopes: text("allowed_scopes"),
customClaims: text("custom_claims"),
dpopBoundAccessTokensRequired: boolean("dpop_bound_access_tokens_required"),
disabled: boolean("disabled"),
policyVersion: int("policy_version"),
metadata: text("metadata"),
createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
updatedAt: timestamp("updated_at", { fsp: 3 })
.notNull()
.default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`),
},
(table) => [uniqueIndex("oauth_resource_identifier").on(table.identifier)],
)
// `id` is `${client_id}::${resource identifier}`, built by the oauth-provider
// plugin so the primary key enforces composite client/resource uniqueness.
export const OAuthClientResourceTable = mysqlTable(
"oauthClientResource",
{
id: varchar("id", { length: 512 }).notNull().primaryKey(),
clientId: varchar("client_id", { length: 255 }).notNull(),
resourceId: varchar("resource_id", { length: 255 }).notNull(),
metadata: text("metadata"),
createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
},
(table) => [
index("oauth_client_resource_client_id").on(table.clientId),
index("oauth_client_resource_resource_id").on(table.resourceId),
],
)
// JTI replay cache for private_key_jwt client assertions; `id` is a truncated
// base64url SHA-256 digest supplied by the oauth-provider plugin.
export const OAuthClientAssertionTable = mysqlTable("oauthClientAssertion", {
id: varchar("id", { length: 64 }).notNull().primaryKey(),
expiresAt: timestamp("expires_at", { fsp: 3 }).notNull(),
})
export const ScimProviderTable = mysqlTable(
"scim_provider",
{
id: denTypeIdColumn("scimProvider", "id").notNull().primaryKey(),
providerId: varchar("provider_id", { length: 255 }).notNull(),
scimToken: encryptedTextColumn("scim_token").notNull(),
organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
userId: denTypeIdColumn("user", "user_id"),
groupMappingMode: varchar("group_mapping_mode", { length: 32 }).notNull().default("metadata_only"),
createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
updatedAt: timestamp("updated_at", { fsp: 3 })
.notNull()
.default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`),
},
(table) => [
uniqueIndex("scim_provider_provider_id").on(table.providerId),
uniqueIndex("scim_provider_organization_id").on(table.organizationId),
],
)
export const ScimSyncEventTable = mysqlTable(
"scim_sync_event",
{
id: denTypeIdColumn("scimSyncEvent", "id").notNull().primaryKey(),
organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
providerId: varchar("provider_id", { length: 255 }).notNull(),
userId: denTypeIdColumn("user", "user_id"),
action: varchar("action", { length: 64 }).notNull(),
status: varchar("status", { length: 32 }).notNull().default("pending"),
attempts: int("attempts").notNull().default(0),
lastError: text("last_error"),
payloadJson: json("payload_json").$type<Record<string, unknown> | null>(),
nextRetryAt: timestamp("next_retry_at", { fsp: 3 }),
resolvedAt: timestamp("resolved_at", { fsp: 3 }),
createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
updatedAt: timestamp("updated_at", { fsp: 3 })
.notNull()
.default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`),
},
(table) => [
index("scim_sync_event_org_status").on(table.organizationId, table.status),
index("scim_sync_event_provider_status").on(table.providerId, table.status),
index("scim_sync_event_next_retry").on(table.nextRetryAt),
index("scim_sync_event_user").on(table.userId),
],
)
export const SsoProviderTable = mysqlTable(
"sso_provider",
{
id: denTypeIdColumn("ssoProvider", "id").notNull().primaryKey(),
issuer: varchar("issuer", { length: 2048 }).notNull(),
domain: varchar("domain", { length: 255 }).notNull(),
oidcConfig: encryptedTextColumn("oidc_config"),
samlConfig: encryptedTextColumn("saml_config"),
userId: denTypeIdColumn("user", "user_id").notNull(),
providerId: varchar("provider_id", { length: 255 }).notNull(),
organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
domainVerified: boolean("domain_verified").notNull().default(false),
createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
updatedAt: timestamp("updated_at", { fsp: 3 })
.notNull()
.default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`),
},
(table) => [
uniqueIndex("sso_provider_provider_id").on(table.providerId),
index("sso_provider_domain").on(table.domain),
index("sso_provider_organization_id").on(table.organizationId),
index("sso_provider_user_id").on(table.userId),
],
)
export const SsoConnectionTable = mysqlTable(
"sso_connection",
{
id: denTypeIdColumn("ssoConnection", "id").notNull().primaryKey(),
organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
providerId: varchar("provider_id", { length: 255 }).notNull(),
kind: varchar("kind", { length: 16 }).notNull(),
issuer: varchar("issuer", { length: 2048 }).notNull(),
domain: varchar("domain", { length: 255 }).notNull(),
status: varchar("status", { length: 32 }).notNull().default("disabled"),
signInPath: varchar("sign_in_path", { length: 2048 }).notNull(),
configRevision: varchar("config_revision", { length: 64 }).notNull().default(""),
testStatus: varchar("test_status", { length: 32 }).notNull().default("untested"),
lastTestedAt: timestamp("last_tested_at", { fsp: 3 }),
lastTestedRevision: varchar("last_tested_revision", { length: 64 }),
lastError: text("last_error"),
domainVerificationToken: varchar("domain_verification_token", { length: 255 }),
activeTestIntentId: varchar("active_test_intent_id", { length: 64 }),
activeTestUserId: denTypeIdColumn("user", "active_test_user_id"),
activeTestProviderId: varchar("active_test_provider_id", { length: 255 }),
activeTestConfigRevision: varchar("active_test_config_revision", { length: 64 }),
activeTestExpiresAt: timestamp("active_test_expires_at", { fsp: 3 }),
activeTestStartedAt: timestamp("active_test_started_at", { fsp: 3 }),
createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
updatedAt: timestamp("updated_at", { fsp: 3 })
.notNull()
.default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`),
},
(table) => [
uniqueIndex("sso_connection_organization_id").on(table.organizationId),
uniqueIndex("sso_connection_provider_id").on(table.providerId),
index("sso_connection_domain").on(table.domain),
],
)
export const ExternalIdentityTable = mysqlTable(
"external_identity",
{
id: denTypeIdColumn("externalIdentity", "id").notNull().primaryKey(),
organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
userId: denTypeIdColumn("user", "user_id").notNull(),
source: varchar("source", { length: 32 }).notNull(),
scimProviderId: varchar("scim_provider_id", { length: 255 }),
ssoProviderId: varchar("sso_provider_id", { length: 255 }),
remoteId: varchar("remote_id", { length: 191 }),
externalId: varchar("external_id", { length: 191 }),
userName: varchar("user_name", { length: 191 }),
email: varchar("email", { length: 191 }),
displayName: varchar("display_name", { length: 191 }),
nameJson: json("name_json").$type<Record<string, unknown> | null>(),
emailsJson: json("emails_json").$type<unknown[] | null>(),
attributesJson: json("attributes_json").$type<Record<string, unknown> | null>(),
active: boolean("active").notNull().default(true),
lastScimSyncAt: timestamp("last_scim_sync_at", { fsp: 3 }),
lastSsoLoginAt: timestamp("last_sso_login_at", { fsp: 3 }),
createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
updatedAt: timestamp("updated_at", { fsp: 3 })
.notNull()
.default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`),
},
(table) => [
uniqueIndex("external_identity_org_user").on(table.organizationId, table.userId),
uniqueIndex("external_identity_org_sso_remote").on(table.organizationId, table.ssoProviderId, table.remoteId),
uniqueIndex("external_identity_org_scim_external").on(table.organizationId, table.scimProviderId, table.externalId),
index("external_identity_org_email").on(table.organizationId, table.email),
index("external_identity_sso_provider").on(table.ssoProviderId),
index("external_identity_scim_provider").on(table.scimProviderId),
],
)
export const user = AuthUserTable
export const session = AuthSessionTable
export const account = AuthAccountTable
export const verification = AuthVerificationTable
export const apikey = AuthApiKeyTable
export const jwks = AuthJwksTable
export const oauthClient = OAuthClientTable
export const oauthRefreshToken = OAuthRefreshTokenTable
export const oauthAccessToken = OAuthAccessTokenTable
export const oauthConsent = OAuthConsentTable
export const oauthResource = OAuthResourceTable
export const oauthClientResource = OAuthClientResourceTable
export const oauthClientAssertion = OAuthClientAssertionTable
export const scimProvider = ScimProviderTable
export const scimSyncEvent = ScimSyncEventTable
export const ssoProvider = SsoProviderTable
export const ssoConnection = SsoConnectionTable
export const externalIdentity = ExternalIdentityTable