Passing Custom Value in DB during Oauth Login

[radioac7iv3]

So i was tying to pass an additional parameter(role_id) to my DB during an oauth login but i am constantly getting :
[auth][cause]: NeonDbError: null value in column "role_id" of relation "user" violates not-null constraint
so my user schema is:

user = pgTable('user', {
id: text('id')
.primaryKey()
.$defaultFn(() => crypto.randomUUID()),
name: text('name'),
email: text('email'),
password: text('password'),
emailVerified: timestamp('emailVerified', { mode: 'date' }),
image: text('image'),
roleId: uuid('role_id')
.references(() => roles.roleId)
.notNull(),
});
and roles is:
export const roles = pgTable('roles', {
roleId: uuid('role_id').defaultRandom().primaryKey(),
roleName: rolesEnum('role_name').notNull().default('USER'),
});

and my provider is:
Google({
clientId: process.env.GOOGLE_CLIENT_ID,
clientSecret: process.env.GOOGLE_CLIENT_SECRET,
async profile(profile) {

        return {
            role_id: 'acdf60c4-c9e6-43b8-8995-bb277a5315e8', // SOME UUID 
            ...profile,
        };
    },
}),

Expected behavior
auth.js should have passed this role_id to db during creation of user(during login?).

[radioac7iv3]

For people facing similar issue, I just Figured it out, Looks like in my auth.ts file I had specify the table that i am using :

adapter: DrizzleAdapter(db, {
        usersTable: user,
        accountsTable: accounts,
    }),

and then it worked like a charm.

Edit Pass your values like this inside your ouath provider:

Google({
           clientId: process.env.GOOGLE_CLIENT_ID,
           clientSecret: process.env.GOOGLE_CLIENT_SECRET,

           profile(profile) {
               return {
                   id: '2e5929c1-f9a7-484b-af0b-e701f9443038',
                   name: 'Test user',
                   email: '[email protected]',
                   image: 'https://someURL',
                   emailVerified: null,
                   customField: 'customValue', //Key name as per drizzle schema config
               };
           },
       }),