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

bug: defaultValue in additionalFields does not work for drizzle #1213

New Issue
Closed
opened 2026-03-13 08:28:32 -05:00 by GiteaMirror · 3 comments
GiteaMirror commented 2026-03-13 08:28:32 -05:00
Owner
Copy Link
Copy Source

Originally created by @eyadfareh on GitHub (May 16, 2025).

Is this suited for github?

  • Yes, this is suited for github

To Reproduce

  1. define user and set an additional fields with a default value for drizzle
  2. npx @better-auth/cli generate
  3. the generated schema doesn't put the default value inside a string
  4. it results in invalid drizzle schema
    the schema it produces:
export const user = sqliteTable("user", {
					id: text('id').primaryKey(),
					name: text('name').notNull(),
 email: text('email').notNull().unique(),
 emailVerified: integer('email_verified', { mode: 'boolean' }).$defaultFn(() => false).notNull(),
 image: text('image'),
 createdAt: integer('created_at', { mode: 'timestamp' }).$defaultFn(() => /* @__PURE__ */ new Date()).notNull(),
 updatedAt: integer('updated_at', { mode: 'timestamp' }).$defaultFn(() => /* @__PURE__ */ new Date()).notNull(),
 role: text('role').default(user).notNull()
				});

instead of

role: text('role').default("user").notNull()

Current vs. Expected behavior

the default value should be a string, but instead it is an identifier.

What version of Better Auth are you using?

1.2.7

Provide environment information

- OS: Linux

Which area(s) are affected? (Select all that apply)

Backend, Types

Auth config (if applicable)

export const auth = betterAuth({
  database: drizzleAdapter(db, {
    provider: "sqlite",
    schema
  }), 
  emailAndPassword: {  
    enabled: true
  },
  user: {
    additionalFields: {
      role: {
        type: "string",
        input: false,
        required: true,
        defaultValue: "user",
      },
    }
  }
})

Additional context

No response

Originally created by @eyadfareh on GitHub (May 16, 2025). ### Is this suited for github? - [x] Yes, this is suited for github ### To Reproduce 1. define user and set an additional fields with a default value for drizzle 2. `npx @better-auth/cli generate` 3. the generated schema doesn't put the default value inside a string 4. it results in invalid drizzle schema the schema it produces: ```ts export const user = sqliteTable("user", { id: text('id').primaryKey(), name: text('name').notNull(), email: text('email').notNull().unique(), emailVerified: integer('email_verified', { mode: 'boolean' }).$defaultFn(() => false).notNull(), image: text('image'), createdAt: integer('created_at', { mode: 'timestamp' }).$defaultFn(() => /* @__PURE__ */ new Date()).notNull(), updatedAt: integer('updated_at', { mode: 'timestamp' }).$defaultFn(() => /* @__PURE__ */ new Date()).notNull(), role: text('role').default(user).notNull() }); ``` instead of ```ts role: text('role').default("user").notNull() ``` ### Current vs. Expected behavior the default value should be a string, but instead it is an identifier. ### What version of Better Auth are you using? 1.2.7 ### Provide environment information ```bash - OS: Linux ``` ### Which area(s) are affected? (Select all that apply) Backend, Types ### Auth config (if applicable) ```typescript export const auth = betterAuth({ database: drizzleAdapter(db, { provider: "sqlite", schema }), emailAndPassword: { enabled: true }, user: { additionalFields: { role: { type: "string", input: false, required: true, defaultValue: "user", }, } } }) ``` ### Additional context _No response_
GiteaMirror commented 2026-03-13 08:28:35 -05:00
Author
Owner
Copy Link
Copy Source

@devallibus commented on GitHub (May 18, 2025):

Can confirm this is also happening to me. Can fix manually by editing the schema, but not ideal.

@devallibus commented on GitHub (May 18, 2025): Can confirm this is also happening to me. Can fix manually by editing the schema, but not ideal.
GiteaMirror commented 2026-03-13 08:28:36 -05:00
Author
Owner
Copy Link
Copy Source

@Kinfe123 commented on GitHub (May 28, 2025):

it is already fixed will be up in upcoming releases! till then you can use the beta version for that

@Kinfe123 commented on GitHub (May 28, 2025): it is already fixed will be up in upcoming releases! till then you can use the beta version for that
GiteaMirror commented 2026-03-13 08:28:37 -05:00
Author
Owner
Copy Link
Copy Source

@bookercodes commented on GitHub (Jun 3, 2025):

I just ran into this issue. Great to learn it's been fixed already in the newest (beta) version!

@bookercodes commented on GitHub (Jun 3, 2025): I just ran into this issue. Great to learn it's been fixed already in the newest (beta) version!
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 labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
GiteaMirror ninjasurge (Kaehlen Rog)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/better-auth#1213