// Better Auth's tables. Comments and the editor's sessions add their own to this database (see wrangler.jsonc). import { sql } from "drizzle-orm"; import { index, integer, sqliteTable, text } from "drizzle-orm/sqlite-core"; import { authSqliteSchema } from "vite-hub/auth/schema"; import { defineDatabase } from "vite-hub/database"; const now = sql`(cast(unixepoch('subsecond') * 1000 as integer))`; export const user = sqliteTable("user", { id: text("id").primaryKey(), name: text("name").notNull(), email: text("email").notNull().unique(), emailVerified: integer("email_verified", { mode: "boolean" }).default(false).notNull(), image: text("image"), // The GitHub login, which server/auth.ts sets at every sign-in and no request can change. login: text("login"), createdAt: integer("created_at", { mode: "timestamp_ms" }).default(now).notNull(), updatedAt: integer("updated_at", { mode: "timestamp_ms" }) .default(now) .$onUpdate(() => new Date()) .notNull(), }); export const session = sqliteTable( "session", { id: text("id").primaryKey(), expiresAt: integer("expires_at", { mode: "timestamp_ms" }).notNull(), token: text("token").notNull().unique(), createdAt: integer("created_at", { mode: "timestamp_ms" }).default(now).notNull(), updatedAt: integer("updated_at", { mode: "timestamp_ms" }) .$onUpdate(() => new Date()) .notNull(), ipAddress: text("ip_address"), userAgent: text("user_agent"), userId: text("user_id") .notNull() .references(() => user.id, { onDelete: "cascade" }), }, (table) => [index("session_userId_idx").on(table.userId)], ); export const account = sqliteTable( "account", { id: text("id").primaryKey(), accountId: text("account_id").notNull(), providerId: text("provider_id").notNull(), userId: text("user_id") .notNull() .references(() => user.id, { onDelete: "cascade" }), accessToken: text("access_token"), refreshToken: text("refresh_token"), idToken: text("id_token"), accessTokenExpiresAt: integer("access_token_expires_at", { mode: "timestamp_ms" }), refreshTokenExpiresAt: integer("refresh_token_expires_at", { mode: "timestamp_ms" }), scope: text("scope"), password: text("password"), createdAt: integer("created_at", { mode: "timestamp_ms" }).default(now).notNull(), updatedAt: integer("updated_at", { mode: "timestamp_ms" }) .$onUpdate(() => new Date()) .notNull(), }, (table) => [index("account_userId_idx").on(table.userId)], ); export const verification = sqliteTable( "verification", { id: text("id").primaryKey(), identifier: text("identifier").notNull(), value: text("value").notNull(), expiresAt: integer("expires_at", { mode: "timestamp_ms" }).notNull(), createdAt: integer("created_at", { mode: "timestamp_ms" }).default(now).notNull(), updatedAt: integer("updated_at", { mode: "timestamp_ms" }) .default(now) .$onUpdate(() => new Date()) .notNull(), }, (table) => [index("verification_identifier_idx").on(table.identifier)], ); // The tables of consoleMcpOAuth(), with which console.vitehub.dev signed in here before the Console signed its own calls. // Nothing uses them now. They stay until the Console's signed calls have run in production, so the Worker before them // can still be rolled back to; a later migration drops them. export const { jwks, oauthAccessToken, oauthClient, oauthClientAssertion, oauthClientResource, oauthConsent, oauthRefreshToken, oauthResource, } = authSqliteSchema; // Where the database lives is in nuxt.config.ts, under `vitehub.database`. export default defineDatabase({ schema: { user, session, account, verification, jwks, oauthAccessToken, oauthClient, oauthClientAssertion, oauthClientResource, oauthConsent, oauthRefreshToken, oauthResource, }, });