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

APIKey Table schema generation is incorrect #1057

New Issue
Closed
opened 2026-03-13 08:20:42 -05:00 by GiteaMirror · 6 comments
GiteaMirror commented 2026-03-13 08:20:42 -05:00
Owner
Copy Link

Originally created by @djt on GitHub (Apr 16, 2025).

Originally assigned to: @ping-maxwell on GitHub.

Is this suited for github?

  • Yes, this is suited for github

To Reproduce

  1. Create backend
  2. Add apiKey plugin
  3. Add custom modelName for user table in config:
    export const auth = betterAuth({ ... user: { modelName: 'users' }, ... });
  4. npx @better-auth/cli generate

The reference for the user Id will reference the default table name of user.

userId: text('user_id').notNull().references(()=> user.id, { onDelete: 'cascade' }),

Current vs. Expected behavior

Current:
userId: text('user_id').notNull().references(()=> user.id, { onDelete: 'cascade' }),
Expected:
userId: text('user_id').notNull().references(()=> users.id, { onDelete: 'cascade' }),

What version of Better Auth are you using?

1.2.7

Provide environment information

- OS: Mac OSX
- Browser: Chrome

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

Backend

Auth config (if applicable)

import { betterAuth } from "better-auth"
export const auth = betterAuth({
  user: {  
    modelName: 'users'
  },
});

Additional context

No response

Originally created by @djt on GitHub (Apr 16, 2025). Originally assigned to: @ping-maxwell on GitHub. ### Is this suited for github? - [x] Yes, this is suited for github ### To Reproduce 1. Create backend 2. Add apiKey plugin 3. Add custom modelName for user table in config: ` export const auth = betterAuth({ ... user: { modelName: 'users' }, ... }); ` 4. npx @better-auth/cli generate The reference for the user Id will reference the default table name of user. ` userId: text('user_id').notNull().references(()=> user.id, { onDelete: 'cascade' }), ` ### Current vs. Expected behavior Current: ` userId: text('user_id').notNull().references(()=> user.id, { onDelete: 'cascade' }), ` Expected: ` userId: text('user_id').notNull().references(()=> users.id, { onDelete: 'cascade' }), ` ### What version of Better Auth are you using? 1.2.7 ### Provide environment information ```bash - OS: Mac OSX - Browser: Chrome ``` ### Which area(s) are affected? (Select all that apply) Backend ### Auth config (if applicable) ```typescript import { betterAuth } from "better-auth" export const auth = betterAuth({ user: { modelName: 'users' }, }); ``` ### Additional context _No response_
GiteaMirror added the adapterbug labels 2026-03-13 08:20:42 -05:00
GiteaMirror commented 2026-03-13 08:20:43 -05:00
Author
Owner
Copy Link

@ping-maxwell commented on GitHub (Apr 20, 2025):

@djt if you update to latest, do you still run into this issue?

@ping-maxwell commented on GitHub (Apr 20, 2025): @djt if you update to latest, do you still run into this issue?
GiteaMirror commented 2026-03-13 08:20:43 -05:00
Author
Owner
Copy Link

@johnrjj commented on GitHub (Apr 22, 2025):

Happening to me as well

@johnrjj commented on GitHub (Apr 22, 2025): Happening to me as well
GiteaMirror commented 2026-03-13 08:20:44 -05:00
Author
Owner
Copy Link

@ping-maxwell commented on GitHub (Aug 11, 2025):

What version are you on @johnrjj ?

@ping-maxwell commented on GitHub (Aug 11, 2025): What version are you on @johnrjj ?
GiteaMirror commented 2026-03-13 08:20:44 -05:00
Author
Owner
Copy Link

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

What version are you on @johnrjj ?

@ping-maxwell Currently using version 1.3.7 and this issue persists

@bunday commented on GitHub (Aug 20, 2025): > What version are you on [@johnrjj](https://github.com/johnrjj) ? @ping-maxwell Currently using version `1.3.7` and this issue persists
GiteaMirror commented 2026-03-13 08:20:45 -05:00
Author
Owner
Copy Link

@ping-maxwell commented on GitHub (Aug 20, 2025):

@bunday Which adapter are you using? Drizzle?
The schema generation runs off our CLI, are you sure you're not using a cached/old version of our CLI?

@ping-maxwell commented on GitHub (Aug 20, 2025): @bunday Which adapter are you using? Drizzle? The schema generation runs off our CLI, are you sure you're not using a cached/old version of our CLI?
GiteaMirror commented 2026-03-13 08:20:45 -05:00
Author
Owner
Copy Link

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

@ping-maxwell Currently using Drizzle adapter and the cli i have is this @better-auth/cli@1.3.7. Are you not able to reproduce this schema generation with the wrong table name reference?

@bunday commented on GitHub (Aug 20, 2025): @ping-maxwell Currently using Drizzle adapter and the cli i have is this `@better-auth/cli@1.3.7`. Are you not able to reproduce this schema generation with the wrong table name reference?
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 adapter bug
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#1057
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?