github-starred/better-auth
2
0
Fork 0
mirror of https://github.com/better-auth/better-auth.git synced 2026-05-23 23:52:05 -05:00
Code Issues 2.5k Packages Projects Releases 112 Wiki Activity

Improve generated SQL schema #1425

New Issue
Closed
opened 2026-03-13 08:39:34 -05:00 by GiteaMirror · 9 comments
GiteaMirror commented 2026-03-13 08:39:34 -05:00
Owner
Copy Link

Originally created by @rebasecase on GitHub (Jun 27, 2025).

create table "user" ("id" text not null primary key, "name" text not null, "email" text not null unique, "emailVerified" boolean not null, "image" text, "createdAt" timestamp not null, "updatedAt" timestamp not null);

create table "session" ("id" text not null primary key, "expiresAt" timestamp not null, "token" text not null unique, "createdAt" timestamp not null, "updatedAt" timestamp not null, "ipAddress" text, "userAgent" text, "userId" text not null references "user" ("id"));

create table "account" ("id" text not null primary key, "accountId" text not null, "providerId" text not null, "userId" text not null references "user" ("id"), "accessToken" text, "refreshToken" text, "idToken" text, "accessTokenExpiresAt" timestamp, "refreshTokenExpiresAt" timestamp, "scope" text, "password" text, "createdAt" timestamp not null, "updatedAt" timestamp not null);

create table "verification" ("id" text not null primary key, "identifier" text not null, "value" text not null, "expiresAt" timestamp not null, "createdAt" timestamp, "updatedAt" timestamp);

Everything is text, there’s no UUIDs, no defaults on timestamps, no foreign key behaviour, no indexing (besides PK), no constraints for updates/deletes.

Optionally provide comprehensive documentation on using own schema. See below.

Originally created by @rebasecase on GitHub (Jun 27, 2025). ```sql create table "user" ("id" text not null primary key, "name" text not null, "email" text not null unique, "emailVerified" boolean not null, "image" text, "createdAt" timestamp not null, "updatedAt" timestamp not null); create table "session" ("id" text not null primary key, "expiresAt" timestamp not null, "token" text not null unique, "createdAt" timestamp not null, "updatedAt" timestamp not null, "ipAddress" text, "userAgent" text, "userId" text not null references "user" ("id")); create table "account" ("id" text not null primary key, "accountId" text not null, "providerId" text not null, "userId" text not null references "user" ("id"), "accessToken" text, "refreshToken" text, "idToken" text, "accessTokenExpiresAt" timestamp, "refreshTokenExpiresAt" timestamp, "scope" text, "password" text, "createdAt" timestamp not null, "updatedAt" timestamp not null); create table "verification" ("id" text not null primary key, "identifier" text not null, "value" text not null, "expiresAt" timestamp not null, "createdAt" timestamp, "updatedAt" timestamp); ``` Everything is text, there’s no UUIDs, no defaults on timestamps, no foreign key behaviour, no indexing (besides PK), no constraints for updates/deletes. ~Optionally provide comprehensive documentation on using own schema.~ See below.
GiteaMirror commented 2026-03-13 08:39:35 -05:00
Author
Owner
Copy Link

@rebasecase commented on GitHub (Jun 27, 2025):

Something like this

import type { Kysely } from 'kysely';

export async function up(db: Kysely<any>): Promise<void> {
  /*
    Table Name: user

    Field Name	Type	Key	Description
    id	string	PK	Unique identifier for each user
    name	string	-	User's chosen display name
    email	string	-	User's email address for communication and login
    emailVerified	boolean	-	Whether the user's email is verified
    image	string	?	User's image url
    createdAt	Date	-	Timestamp of when the user account was created
    updatedAt	Date	-	Timestamp of the last update to the user's information
  */
  await db.schema
    .createTable('user')
    .addColumn('id', 'uuid', (col) => col.primaryKey())
    .addColumn('name', 'varchar', (col) => col.notNull())
    .addColumn('email', 'varchar', (col) => col.notNull().unique())
    .addColumn('email_verified', 'boolean', (col) => col.notNull().defaultTo(false))
    .addColumn('image', 'varchar')
    .addColumn('created_at', 'timestamp', (col) => col.notNull())
    .addColumn('updated_at', 'timestamp', (col) => col.notNull())
    .execute();

  /*
    Table Name: session

    Field Name	Type	Key	Description
    id	string	PK	Unique identifier for each session
    userId	string	FK	The ID of the user
    token	string	-	The unique session token
    expiresAt	Date	-	The time when the session expires
    ipAddress	string	?	The IP address of the device
    userAgent	string	?	The user agent information of the device
    createdAt	Date	-	Timestamp of when the session was created
    updatedAt	Date	-	Timestamp of when the session was updated
  */
  await db.schema
    .createTable('session')
    .addColumn('id', 'uuid', (col) => col.primaryKey())
    .addColumn('user_id', 'uuid', (col) => col.references('user.id').notNull().onDelete('cascade'))
    .addColumn('token', 'varchar', (col) => col.notNull().unique())
    .addColumn('expires_at', 'timestamp', (col) => col.notNull())
    .addColumn('ip_address', 'varchar')
    .addColumn('user_agent', 'varchar')
    .addColumn('created_at', 'timestamp', (col) => col.notNull())
    .addColumn('updated_at', 'timestamp', (col) => col.notNull())
    .execute();

  /*
    Table Name: account

    Field Name	Type	Key	Description
    id	string	PK	Unique identifier for each account
    userId	string	FK	The ID of the user
    accountId	string	-	The ID of the account as provided by the SSO or equal to userId for credential accounts
    providerId	string	-	The ID of the provider
    accessToken	string	?	The access token of the account. Returned by the provider
    refreshToken	string	?	The refresh token of the account. Returned by the provider
    accessTokenExpiresAt	Date	?	The time when the access token expires
    refreshTokenExpiresAt	Date	?	The time when the refresh token expires
    scope	string	?	The scope of the account. Returned by the provider
    idToken	string	?	The ID token returned from the provider
    password	string	?	The password of the account. Mainly used for email and password authentication
    createdAt	Date	-	Timestamp of when the account was created
    updatedAt	Date	-	Timestamp of when the account was updated
  */
  await db.schema
    .createTable('account')
    .addColumn('id', 'uuid', (col) => col.primaryKey())
    .addColumn('user_id', 'uuid', (col) => col.references('user.id').notNull().onDelete('cascade'))
    .addColumn('account_id', 'varchar', (col) => col.notNull())
    .addColumn('provider_id', 'varchar', (col) => col.notNull())
    .addColumn('access_token', 'varchar')
    .addColumn('refresh_token', 'varchar')
    .addColumn('access_token_expires_at', 'timestamp')
    .addColumn('refresh_token_expires_at', 'timestamp')
    .addColumn('scope', 'varchar')
    .addColumn('id_token', 'varchar')
    .addColumn('password', 'varchar')
    .addColumn('created_at', 'timestamp', (col) => col.notNull())
    .addColumn('updated_at', 'timestamp', (col) => col.notNull())
    .execute();

  /*
    Table Name: verification

    Field Name	Type	Key	Description
    id	string	PK	Unique identifier for each verification
    identifier	string	-	The identifier for the verification request
    value	string	-	The value to be verified
    expiresAt	Date	-	The time when the verification request expires
    createdAt	Date	-	Timestamp of when the verification request was created
    updatedAt	Date	-	Timestamp of when the verification request was updated
  */
  await db.schema
    .createTable('verification')
    .addColumn('id', 'uuid', (col) => col.primaryKey())
    .addColumn('identifier', 'varchar', (col) => col.notNull())
    .addColumn('value', 'varchar', (col) => col.notNull())
    .addColumn('expires_at', 'timestamp', (col) => col.notNull())
    .addColumn('created_at', 'timestamp', (col) => col.notNull())
    .addColumn('updated_at', 'timestamp', (col) => col.notNull())
    .execute();
}

export async function down(db: Kysely<any>): Promise<void> {
  db.schema.dropTable('verification').ifExists().execute();
  db.schema.dropTable('account').ifExists().execute();
  db.schema.dropTable('session').ifExists().execute();
  db.schema.dropTable('user').ifExists().execute();
}

import { CamelCasePlugin, Kysely, PostgresDialect, type Generated } from 'kysely';
import { Pool } from 'pg';

export interface Database {
  user: UserTable;
}

export interface UserTable {
  id: Generated<string>;
  name: string;
  email: string;
  emailVerified: boolean;
  image?: string;
  createdAt: Date;
  updatedAt: Date;
}

export interface SessionTable {
  id: Generated<string>;
  userId: string;
  token: string;
  expiresAt: Date;
  ipAddress?: string;
  userAgent?: string;
  createdAt: Date;
  updatedAt: Date;
}

export interface AccountTable {
  id: Generated<string>;
  userId: string;
  accountId: string;
  providerId: string;
  accessToken?: string;
  refreshToken?: string;
  accessTokenExpiresAt?: Date;
  refreshTokenExpiresAt?: Date;
  scope?: string;
  idToken?: string;
  password?: string;
  createdAt: Date;
  updatedAt: Date;
}

export interface VerificationTable {
  id: Generated<string>;
  identifier: string;
  value: string;
  expiresAt: Date;
  createdAt: Date;
  updatedAt: Date;
}

const dialect = new PostgresDialect({
  pool: new Pool({
    connectionString: process.env.DATABASE_URL,
    max: 10
  })
});

export const db = new Kysely<Database>({
  dialect,
  plugins: [new CamelCasePlugin({ underscoreBeforeDigits: true })]
});

export const auth = betterAuth({
  database: {
    db,
    type: 'postgres'
  },
  user: {
    fields: {
      name: 'name',
      email: 'email',
      emailVerified: 'email_verified',
      image: 'image',
      createdAt: 'created_at',
      updatedAt: 'updated_at'
    }
  },
  account: {
    fields: {
      userId: 'user_id',
      accountId: 'account_id',
      providerId: 'provider_id',
      accessToken: 'access_token',
      refreshToken: 'refresh_token',
      accessTokenExpiresAt: 'access_token_expires_at',
      refreshTokenExpiresAt: 'refresh_token_expires_at',
      scope: 'scope',
      idToken: 'id_token',
      password: 'password',
      createdAt: 'created_at',
      updatedAt: 'updated_at'
    }
  },
  session: {
    fields: {
      userId: 'user_id',
      token: 'token',
      expiresAt: 'expires_at',
      ipAddress: 'ip_address',
      userAgent: 'user_agent',
      createdAt: 'created_at',
      updatedAt: 'updated_at'
    }
  },
  verification: {
    fields: {
      identifier: 'identifier',
      value: 'value',
      expiresAt: 'expires_at',
      createdAt: 'created_at',
      updatedAt: 'updated_at'
    }
  },
  advanced: {
    database: {
      generateId: () => uuidv7()
    }
  },
  emailAndPassword: {
    enabled: true
  }
});

npx @better-auth/cli@latest generate should return INFO [Better Auth]: Your schema is already up to date.

@rebasecase commented on GitHub (Jun 27, 2025): Something like this ```ts import type { Kysely } from 'kysely'; export async function up(db: Kysely<any>): Promise<void> { /* Table Name: user Field Name Type Key Description id string PK Unique identifier for each user name string - User's chosen display name email string - User's email address for communication and login emailVerified boolean - Whether the user's email is verified image string ? User's image url createdAt Date - Timestamp of when the user account was created updatedAt Date - Timestamp of the last update to the user's information */ await db.schema .createTable('user') .addColumn('id', 'uuid', (col) => col.primaryKey()) .addColumn('name', 'varchar', (col) => col.notNull()) .addColumn('email', 'varchar', (col) => col.notNull().unique()) .addColumn('email_verified', 'boolean', (col) => col.notNull().defaultTo(false)) .addColumn('image', 'varchar') .addColumn('created_at', 'timestamp', (col) => col.notNull()) .addColumn('updated_at', 'timestamp', (col) => col.notNull()) .execute(); /* Table Name: session Field Name Type Key Description id string PK Unique identifier for each session userId string FK The ID of the user token string - The unique session token expiresAt Date - The time when the session expires ipAddress string ? The IP address of the device userAgent string ? The user agent information of the device createdAt Date - Timestamp of when the session was created updatedAt Date - Timestamp of when the session was updated */ await db.schema .createTable('session') .addColumn('id', 'uuid', (col) => col.primaryKey()) .addColumn('user_id', 'uuid', (col) => col.references('user.id').notNull().onDelete('cascade')) .addColumn('token', 'varchar', (col) => col.notNull().unique()) .addColumn('expires_at', 'timestamp', (col) => col.notNull()) .addColumn('ip_address', 'varchar') .addColumn('user_agent', 'varchar') .addColumn('created_at', 'timestamp', (col) => col.notNull()) .addColumn('updated_at', 'timestamp', (col) => col.notNull()) .execute(); /* Table Name: account Field Name Type Key Description id string PK Unique identifier for each account userId string FK The ID of the user accountId string - The ID of the account as provided by the SSO or equal to userId for credential accounts providerId string - The ID of the provider accessToken string ? The access token of the account. Returned by the provider refreshToken string ? The refresh token of the account. Returned by the provider accessTokenExpiresAt Date ? The time when the access token expires refreshTokenExpiresAt Date ? The time when the refresh token expires scope string ? The scope of the account. Returned by the provider idToken string ? The ID token returned from the provider password string ? The password of the account. Mainly used for email and password authentication createdAt Date - Timestamp of when the account was created updatedAt Date - Timestamp of when the account was updated */ await db.schema .createTable('account') .addColumn('id', 'uuid', (col) => col.primaryKey()) .addColumn('user_id', 'uuid', (col) => col.references('user.id').notNull().onDelete('cascade')) .addColumn('account_id', 'varchar', (col) => col.notNull()) .addColumn('provider_id', 'varchar', (col) => col.notNull()) .addColumn('access_token', 'varchar') .addColumn('refresh_token', 'varchar') .addColumn('access_token_expires_at', 'timestamp') .addColumn('refresh_token_expires_at', 'timestamp') .addColumn('scope', 'varchar') .addColumn('id_token', 'varchar') .addColumn('password', 'varchar') .addColumn('created_at', 'timestamp', (col) => col.notNull()) .addColumn('updated_at', 'timestamp', (col) => col.notNull()) .execute(); /* Table Name: verification Field Name Type Key Description id string PK Unique identifier for each verification identifier string - The identifier for the verification request value string - The value to be verified expiresAt Date - The time when the verification request expires createdAt Date - Timestamp of when the verification request was created updatedAt Date - Timestamp of when the verification request was updated */ await db.schema .createTable('verification') .addColumn('id', 'uuid', (col) => col.primaryKey()) .addColumn('identifier', 'varchar', (col) => col.notNull()) .addColumn('value', 'varchar', (col) => col.notNull()) .addColumn('expires_at', 'timestamp', (col) => col.notNull()) .addColumn('created_at', 'timestamp', (col) => col.notNull()) .addColumn('updated_at', 'timestamp', (col) => col.notNull()) .execute(); } export async function down(db: Kysely<any>): Promise<void> { db.schema.dropTable('verification').ifExists().execute(); db.schema.dropTable('account').ifExists().execute(); db.schema.dropTable('session').ifExists().execute(); db.schema.dropTable('user').ifExists().execute(); } ``` ```ts import { CamelCasePlugin, Kysely, PostgresDialect, type Generated } from 'kysely'; import { Pool } from 'pg'; export interface Database { user: UserTable; } export interface UserTable { id: Generated<string>; name: string; email: string; emailVerified: boolean; image?: string; createdAt: Date; updatedAt: Date; } export interface SessionTable { id: Generated<string>; userId: string; token: string; expiresAt: Date; ipAddress?: string; userAgent?: string; createdAt: Date; updatedAt: Date; } export interface AccountTable { id: Generated<string>; userId: string; accountId: string; providerId: string; accessToken?: string; refreshToken?: string; accessTokenExpiresAt?: Date; refreshTokenExpiresAt?: Date; scope?: string; idToken?: string; password?: string; createdAt: Date; updatedAt: Date; } export interface VerificationTable { id: Generated<string>; identifier: string; value: string; expiresAt: Date; createdAt: Date; updatedAt: Date; } const dialect = new PostgresDialect({ pool: new Pool({ connectionString: process.env.DATABASE_URL, max: 10 }) }); export const db = new Kysely<Database>({ dialect, plugins: [new CamelCasePlugin({ underscoreBeforeDigits: true })] }); ``` ```ts export const auth = betterAuth({ database: { db, type: 'postgres' }, user: { fields: { name: 'name', email: 'email', emailVerified: 'email_verified', image: 'image', createdAt: 'created_at', updatedAt: 'updated_at' } }, account: { fields: { userId: 'user_id', accountId: 'account_id', providerId: 'provider_id', accessToken: 'access_token', refreshToken: 'refresh_token', accessTokenExpiresAt: 'access_token_expires_at', refreshTokenExpiresAt: 'refresh_token_expires_at', scope: 'scope', idToken: 'id_token', password: 'password', createdAt: 'created_at', updatedAt: 'updated_at' } }, session: { fields: { userId: 'user_id', token: 'token', expiresAt: 'expires_at', ipAddress: 'ip_address', userAgent: 'user_agent', createdAt: 'created_at', updatedAt: 'updated_at' } }, verification: { fields: { identifier: 'identifier', value: 'value', expiresAt: 'expires_at', createdAt: 'created_at', updatedAt: 'updated_at' } }, advanced: { database: { generateId: () => uuidv7() } }, emailAndPassword: { enabled: true } }); ``` ` npx @better-auth/cli@latest generate ` should return `INFO [Better Auth]: Your schema is already up to date.`
GiteaMirror commented 2026-03-13 08:39:35 -05:00
Author
Owner
Copy Link

@dosubot[bot] commented on GitHub (Jun 27, 2025):

Your Kysely migration and schema mapping approach is fully supported by better-auth. The CLI checks your schema—including types, keys, constraints, and field mappings—against its expected structure. As long as your schema matches (UUIDs for PKs, correct types, constraints, and mapped fields), running npx @better-auth/cli@latest generate will return INFO [Better Auth]: Your schema is already up to date.

Custom field names and types are handled via the fields mapping in your betterAuth config, and recent updates ensure that custom adapters (like Kysely) are supported for schema validation and generation as long as they implement the required methods. There’s no evidence of extra undocumented requirements or caveats for your use case—your setup aligns with the intended usage and internal schema definitions of better-auth. However, there isn’t comprehensive documentation specifically for custom Kysely schemas, but the codebase and recent issues confirm this workflow is supported and stable for production use (source, source, source, source).

To reply, just mention @dosu.

How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other  Join Discord Share on X

@dosubot[bot] commented on GitHub (Jun 27, 2025): <!-- Answer --> Your Kysely migration and schema mapping approach is fully supported by better-auth. The CLI checks your schema—including types, keys, constraints, and field mappings—against its expected structure. As long as your schema matches (UUIDs for PKs, correct types, constraints, and mapped fields), running `npx @better-auth/cli@latest generate` will return `INFO [Better Auth]: Your schema is already up to date.` Custom field names and types are handled via the `fields` mapping in your betterAuth config, and recent updates ensure that custom adapters (like Kysely) are supported for schema validation and generation as long as they implement the required methods. There’s no evidence of extra undocumented requirements or caveats for your use case—your setup aligns with the intended usage and internal schema definitions of better-auth. However, there isn’t comprehensive documentation specifically for custom Kysely schemas, but the codebase and recent issues confirm this workflow is supported and stable for production use ([source](https://github.com/better-auth/better-auth/issues/3003), [source](https://github.com/better-auth/better-auth/blob/0679ebed3eb12fc86a1c4224b841027e07673638/packages/cli/src/commands/generate.ts), [source](https://github.com/better-auth/better-auth/blob/0679ebed3eb12fc86a1c4224b841027e07673638/packages/better-auth/src/db/schema.ts), [source](https://github.com/better-auth/better-auth/pull/3006)). <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/a4bc1855-ace8-4c07-a71a-e0cd99c107cb?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/a4bc1855-ace8-4c07-a71a-e0cd99c107cb?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/a4bc1855-ace8-4c07-a71a-e0cd99c107cb?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/a4bc1855-ace8-4c07-a71a-e0cd99c107cb?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/a4bc1855-ace8-4c07-a71a-e0cd99c107cb?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/a4bc1855-ace8-4c07-a71a-e0cd99c107cb?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/a4bc1855-ace8-4c07-a71a-e0cd99c107cb?feedback_type=other)</sup>&nbsp;&nbsp;[![Join Discord](https://img.shields.io/badge/join-5865F2?logo=discord&logoColor=white&label=)](https://go.dosu.dev/discord-bot)&nbsp;[![Share on X](https://img.shields.io/badge/X-share-black)](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/better-auth/better-auth/issues/3191)
GiteaMirror commented 2026-03-13 08:39:36 -05:00
Author
Owner
Copy Link

@rebasecase commented on GitHub (Jun 28, 2025):

This is broken, see linked issue

@rebasecase commented on GitHub (Jun 28, 2025): This is broken, see linked issue
GiteaMirror commented 2026-03-13 08:39:36 -05:00
Author
Owner
Copy Link

@KazimirPodolski commented on GitHub (Jul 7, 2025):

@Bekacru @Kinfe123 @ping-maxwell dear sirs, can this issue get some traction please? Current generated SQL schema is awful.

@KazimirPodolski commented on GitHub (Jul 7, 2025): @Bekacru @Kinfe123 @ping-maxwell dear sirs, can this issue get some traction please? Current generated SQL schema is **awful**.
GiteaMirror commented 2026-03-13 08:39:37 -05:00
Author
Owner
Copy Link

@KazimirPodolski commented on GitHub (Jul 7, 2025):

Also all timestamps must be timestamptz, not timestamp.

Field names should ideally be in shake_case.

@KazimirPodolski commented on GitHub (Jul 7, 2025): Also all timestamps must be [`timestamptz`, not `timestamp`](https://wiki.postgresql.org/wiki/Don't_Do_This#Don.27t_use_timestamp_.28without_time_zone.29). Field names should ideally be in shake_case.
GiteaMirror commented 2026-03-13 08:39:37 -05:00
Author
Owner
Copy Link

@rebasecase commented on GitHub (Jul 7, 2025):

~~sHaKe_CaSe!~~

I ended up writing my own schema, yes the generated one is not great but development efforts are probably spent better elsewhere. Those who care about databases are probably competent enough to do their own schema

@rebasecase commented on GitHub (Jul 7, 2025): > \~\~sHaKe_CaSe!\~\~ I ended up writing my own schema, yes the generated one is not great but development efforts are probably spent better elsewhere. Those who care about databases are probably competent enough to do their own schema
GiteaMirror commented 2026-03-13 08:39:37 -05:00
Author
Owner
Copy Link

@Kinfe123 commented on GitHub (Jul 7, 2025):

I will make sure to fix that.

@Kinfe123 commented on GitHub (Jul 7, 2025): I will make sure to fix that.
GiteaMirror commented 2026-03-13 08:39:38 -05:00
Author
Owner
Copy Link

@Kinfe123 commented on GitHub (Aug 14, 2025):

Should be fixed by now.

@Kinfe123 commented on GitHub (Aug 14, 2025): Should be fixed by now.
GiteaMirror commented 2026-03-13 08:39:38 -05:00
Author
Owner
Copy Link

@bestickley commented on GitHub (Aug 20, 2025):

I don't see this fixed in main. Here is my fixed drizzle postgres schema. I noticed updatedAt had incorrect $defaultFn instead of $onUpdateFn too.

import { text, timestamp, boolean, index, pgTable } from "drizzle-orm/pg-core";

export const user = pgTable(
  "user",
  {
    id: text().primaryKey(),
    name: text().notNull(),
    email: text().notNull().unique(),
    emailVerified: boolean()
      .$defaultFn(() => false)
      .notNull(),
    image: text("image"),
    createdAt: timestamp({ withTimezone: true })
      .notNull()
      .$defaultFn(() => new Date()),
    updatedAt: timestamp({ withTimezone: true })
      .notNull()
      .$onUpdateFn(() => new Date()),
    // required by Anonymous Plugin. See: https://www.better-auth.com/docs/plugins/anonymous#schema
    isAnonymous: boolean(),
  },
  (table) => [index().on(table.email)],
);

export const account = pgTable(
  "account",
  {
    id: text().primaryKey(),
    accountId: text().notNull(),
    providerId: text().notNull(),
    userId: text()
      .notNull()
      .references(() => user.id, { onDelete: "cascade" }),
    accessToken: text(),
    refreshToken: text(),
    idToken: text(),
    accessTokenExpiresAt: timestamp({ withTimezone: true }),
    refreshTokenExpiresAt: timestamp({ withTimezone: true }),
    scope: text(),
    password: text(),
    createdAt: timestamp({ withTimezone: true })
      .notNull()
      .$defaultFn(() => new Date()),
    updatedAt: timestamp({ withTimezone: true })
      .notNull()
      .$onUpdateFn(() => new Date()),
  },
  (table) => [index().on(table.userId)],
);

export const verification = pgTable(
  "verification",
  {
    id: text().primaryKey(),
    identifier: text().notNull(),
    value: text("value").notNull(),
    expiresAt: timestamp({ withTimezone: true }).notNull(),
    createdAt: timestamp({ withTimezone: true }).$defaultFn(() => new Date()),
    updatedAt: timestamp({ withTimezone: true }).$onUpdateFn(() => new Date()),
  },
  (table) => [index().on(table.identifier)],
);
@bestickley commented on GitHub (Aug 20, 2025): I don't see this fixed in main. Here is my fixed drizzle postgres schema. I noticed `updatedAt` had incorrect `$defaultFn` instead of `$onUpdateFn` too. ```ts import { text, timestamp, boolean, index, pgTable } from "drizzle-orm/pg-core"; export const user = pgTable( "user", { id: text().primaryKey(), name: text().notNull(), email: text().notNull().unique(), emailVerified: boolean() .$defaultFn(() => false) .notNull(), image: text("image"), createdAt: timestamp({ withTimezone: true }) .notNull() .$defaultFn(() => new Date()), updatedAt: timestamp({ withTimezone: true }) .notNull() .$onUpdateFn(() => new Date()), // required by Anonymous Plugin. See: https://www.better-auth.com/docs/plugins/anonymous#schema isAnonymous: boolean(), }, (table) => [index().on(table.email)], ); export const account = pgTable( "account", { id: text().primaryKey(), accountId: text().notNull(), providerId: text().notNull(), userId: text() .notNull() .references(() => user.id, { onDelete: "cascade" }), accessToken: text(), refreshToken: text(), idToken: text(), accessTokenExpiresAt: timestamp({ withTimezone: true }), refreshTokenExpiresAt: timestamp({ withTimezone: true }), scope: text(), password: text(), createdAt: timestamp({ withTimezone: true }) .notNull() .$defaultFn(() => new Date()), updatedAt: timestamp({ withTimezone: true }) .notNull() .$onUpdateFn(() => new Date()), }, (table) => [index().on(table.userId)], ); export const verification = pgTable( "verification", { id: text().primaryKey(), identifier: text().notNull(), value: text("value").notNull(), expiresAt: timestamp({ withTimezone: true }).notNull(), createdAt: timestamp({ withTimezone: true }).$defaultFn(() => new Date()), updatedAt: timestamp({ withTimezone: true }).$onUpdateFn(() => new Date()), }, (table) => [index().on(table.identifier)], ); ```
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
adapter
astro
awaiting external contributor
blocked
breaking
breaking change
bug
c-devops
core
credentials
database
dependencies
devops
devtools
docs
documentation
duplicate
elysia
enhancement
enterprise
expo
express
fastify
good first issue
help wanted
hono
identity
infra
integration
invalid
javascript
locked
maintenance
need-more-information
needs: info
needs: repro
nextjs
nuxt
oauth
organization
P0
payments
perf
platform
plugin
pull-request
Mirrored from GitHub Pull Request
 question
ready
regression
remix
security
social-provider
solid
stale
svelte
tanstack-start
tracking
version-bump
vue
wontfix
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/better-auth#1425
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?