diff options
Diffstat (limited to 'packages/console/core/src/schema/auth.sql.ts')
| -rw-r--r-- | packages/console/core/src/schema/auth.sql.ts | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/packages/console/core/src/schema/auth.sql.ts b/packages/console/core/src/schema/auth.sql.ts index be2244ef3..1e12f98d4 100644 --- a/packages/console/core/src/schema/auth.sql.ts +++ b/packages/console/core/src/schema/auth.sql.ts @@ -1,4 +1,4 @@ -import { mysqlEnum, mysqlTable, uniqueIndex, varchar } from "drizzle-orm/mysql-core" +import { index, mysqlEnum, mysqlTable, 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,5 @@ export const AuthTable = mysqlTable( subject: varchar("subject", { length: 255 }).notNull(), accountID: ulid("account_id").notNull(), }, - (table) => [uniqueIndex("provider").on(table.provider, table.subject)], + (table) => [uniqueIndex("provider").on(table.provider, table.subject), index("account_id").on(table.accountID)], ) |