From 3be1f9b67ec754a1180ddb4de4586f43beb69043 Mon Sep 17 00:00:00 2001 From: Frank Date: Thu, 2 Oct 2025 18:42:52 -0400 Subject: wip: zen --- packages/console/core/src/schema/user.sql.ts | 10 +++------- 1 file changed, 3 insertions(+), 7 deletions(-) (limited to 'packages/console/core/src/schema/user.sql.ts') diff --git a/packages/console/core/src/schema/user.sql.ts b/packages/console/core/src/schema/user.sql.ts index 861c14b47..cce0cb986 100644 --- a/packages/console/core/src/schema/user.sql.ts +++ b/packages/console/core/src/schema/user.sql.ts @@ -1,7 +1,6 @@ -import { mysqlTable, uniqueIndex, varchar, int, mysqlEnum, foreignKey } from "drizzle-orm/mysql-core" +import { mysqlTable, uniqueIndex, varchar, int, mysqlEnum, index } from "drizzle-orm/mysql-core" import { timestamps, ulid, utc, workspaceColumns } from "../drizzle/types" import { workspaceIndexes } from "./workspace.sql" -import { AccountTable } from "./account.sql" export const UserRole = ["admin", "member"] as const @@ -23,10 +22,7 @@ export const UserTable = mysqlTable( ...workspaceIndexes(table), uniqueIndex("user_account_id").on(table.workspaceID, table.accountID), uniqueIndex("user_email").on(table.workspaceID, table.email), - foreignKey({ - columns: [table.accountID], - foreignColumns: [AccountTable.id], - name: "global_account_id", - }), + index("global_account_id").on(table.accountID), + index("global_email").on(table.email), ], ) -- cgit v1.2.3