Change User table primary key name

Hi everyone, is it possible to change user table primary key? This is what i've dont but it doesnt seem to work for primary key field:

export const auth = betterAuth({
    database: prismaAdapter(prisma, {
        provider: "mysql",
    }),
    emailAndPassword: {
        enabled: true
    },
    socialProviders: {
        google: {
            clientId: process.env.OAUTH_GOOGLE_ID,
            clientSecret: process.env.OAUTH_GOOGLE_SECRET,
        }
    },
    user: {
        modelName: "users",
        fields: {
            id: "user_pid",
            email: "email",
            name: "username",
            emailVerified: "emailVerified",
            image: "image",
        },
    },
})
Was this page helpful?