5 replies

Rename "user" table to "account"

I know this might seem like a crazy request, but I'm trying to integrate BetterAuth into an existing database where the table where my users are stored is already called "account". I thought I had everything set up correctly, but I'm getting the following error when I try to sign someone in.

[app] 2025-05-22T22:28:24.667Z ERROR [Better Auth]: Better auth was unable to query your database.
[app] Error: Error: Field email not found in model account

my settings:

export const auth = betterAuth({
    database: new Pool({ connectionString: env.DATABASE_URL }),
    user: { modelName: "account" },
    account: { modelName: "oauth_account" },
...

export const auth = betterAuth({
    database: new Pool({ connectionString: env.DATABASE_URL }),
    user: { modelName: "account" },
    account: { modelName: "oauth_account" },
...

Better Auth•9mo ago•

5 replies

Eric

Rename "user" table to "account"

export const auth = betterAuth({
    database: new Pool({ connectionString: env.DATABASE_URL }),
    user: { modelName: "account" },
    account: { modelName: "oauth_account" },
...

export const auth = betterAuth({
    database: new Pool({ connectionString: env.DATABASE_URL }),
    user: { modelName: "account" },
    account: { modelName: "oauth_account" },
...

Rename "user" table to "account"

Similar Threads

Rename "user" table to "account"

Similar Threads

Similar Threads

Similar Threads