i can't find any next_auth verification token

[y-71]

Describe the bug

when using nextauth with the xata adapter, i can't find any next_auth verification token on the table,

I've followed the xata adapter docs for nextauth https://authjs.dev/reference/adapter/xata

Expected behavior
next_auth verification token

Software version

(base) ➜  ~ xata --version
@xata.io/cli/0.13.4 darwin-arm64 node-v18.14.0

"dependencies": {
    "@next-auth/xata-adapter": "^0.2.2",
    "@t3-oss/env-nextjs": "^0.3.1",
    "@xata.io/client": "^0.25.2",
    "next": "^13.4.2",
    "next-auth": "^4.22.4",
    "react": "18.2.0",
    "react-dom": "18.2.0",
    "zod": "^3.21.4"
  },

Additional context

[alexfrancoeur]

@SferaDev when you have a moment, any chance you could dig into this? It looks like our adapter may be broken.

[y-71]

@alexfrancoeur is all of your product open source? i can try to file a PR for this

[y-71]

@alexfrancoeur and @SferaDev i've opensourced a xata-auth sample for you to test it,

my question is, does the nextauth_verificationTokens table still make sense knowing that there is a sessionToken field in the nextauth_sessions table

i've also found this PR by @SferaDev about adding oauth and it's still on draft, i'm using google auth solely for this project at this level, not sure if it's relevant since it looks like it's just for the cli
#1122

https://github.com/y-71/xata-auth

[SferaDev]

@y-71 Verification tokens are only for email sign-in to build magic links, if you are using google auth that table will always be empty. If you find any other problem feel free to open a new issue 😄

i've also found this PR by @SferaDev about adding oauth and it's still on draft, i'm using google auth solely for this project at this level, not sure if it's relevant since it looks like it's just for the cli

This is unrelated to next-auth and will add a new way to log in to the CLI.