From dd581e8577c7345c98e38e90f54b359560da74e1 Mon Sep 17 00:00:00 2001 From: Frank Date: Thu, 16 Oct 2025 23:16:23 -0400 Subject: wip: zen --- packages/console/core/src/schema/auth.sql.ts | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) (limited to 'packages/console/core/src/schema/auth.sql.ts') diff --git a/packages/console/core/src/schema/auth.sql.ts b/packages/console/core/src/schema/auth.sql.ts index 1e12f98d4..27c926d6f 100644 --- a/packages/console/core/src/schema/auth.sql.ts +++ b/packages/console/core/src/schema/auth.sql.ts @@ -1,4 +1,4 @@ -import { index, mysqlEnum, mysqlTable, uniqueIndex, varchar } from "drizzle-orm/mysql-core" +import { index, mysqlEnum, mysqlTable, primaryKey, uniqueIndex, varchar } from "drizzle-orm/mysql-core" import { id, timestamps, ulid } from "../drizzle/types" export const AuthProvider = ["email", "github", "google"] as const @@ -12,5 +12,9 @@ export const AuthTable = mysqlTable( subject: varchar("subject", { length: 255 }).notNull(), accountID: ulid("account_id").notNull(), }, - (table) => [uniqueIndex("provider").on(table.provider, table.subject), index("account_id").on(table.accountID)], + (table) => [ + primaryKey({ columns: [table.id] }), + uniqueIndex("provider").on(table.provider, table.subject), + index("account_id").on(table.accountID), + ], ) -- cgit v1.2.3