5 files changed, 19 insertions, 23 deletions
diff --git a/cloud/core/src/schema/account.sql.ts b/cloud/core/src/schema/account.sql.ts
index 1733f0a15..4d9937114 100644
--- a/cloud/core/src/schema/account.sql.ts
+++ b/cloud/core/src/schema/account.sql.ts
@@ -1,7 +1,7 @@
-import { pgTable, uniqueIndex, varchar } from "drizzle-orm/pg-core"
+import { mysqlTable, uniqueIndex, varchar } from "drizzle-orm/mysql-core"
 import { id, timestamps } from "../drizzle/types"
 
-export const AccountTable = pgTable(
+export const AccountTable = mysqlTable(
   "account",
   {
     id: id(),
diff --git a/cloud/core/src/schema/billing.sql.ts b/cloud/core/src/schema/billing.sql.ts
index 96b29f5de..eff1f6550 100644
--- a/cloud/core/src/schema/billing.sql.ts
+++ b/cloud/core/src/schema/billing.sql.ts
@@ -1,8 +1,8 @@
-import { bigint, boolean, integer, pgTable, varchar } from "drizzle-orm/pg-core"
+import { bigint, boolean, int, mysqlTable, varchar } from "drizzle-orm/mysql-core"
 import { timestamps, workspaceColumns } from "../drizzle/types"
 import { workspaceIndexes } from "./workspace.sql"
 
-export const BillingTable = pgTable(
+export const BillingTable = mysqlTable(
   "billing",
   {
     ...workspaceColumns,
@@ -16,7 +16,7 @@ export const BillingTable = pgTable(
   (table) => [...workspaceIndexes(table)],
 )
 
-export const PaymentTable = pgTable(
+export const PaymentTable = mysqlTable(
   "payment",
   {
     ...workspaceColumns,
@@ -28,17 +28,17 @@ export const PaymentTable = pgTable(
   (table) => [...workspaceIndexes(table)],
 )
 
-export const UsageTable = pgTable(
+export const UsageTable = mysqlTable(
   "usage",
   {
     ...workspaceColumns,
     ...timestamps,
     model: varchar("model", { length: 255 }).notNull(),
-    inputTokens: integer("input_tokens").notNull(),
-    outputTokens: integer("output_tokens").notNull(),
-    reasoningTokens: integer("reasoning_tokens"),
-    cacheReadTokens: integer("cache_read_tokens"),
-    cacheWriteTokens: integer("cache_write_tokens"),
+    inputTokens: int("input_tokens").notNull(),
+    outputTokens: int("output_tokens").notNull(),
+    reasoningTokens: int("reasoning_tokens"),
+    cacheReadTokens: int("cache_read_tokens"),
+    cacheWriteTokens: int("cache_write_tokens"),
     cost: bigint("cost", { mode: "number" }).notNull(),
   },
   (table) => [...workspaceIndexes(table)],
diff --git a/cloud/core/src/schema/key.sql.ts b/cloud/core/src/schema/key.sql.ts
index 240736b86..200e829cb 100644
--- a/cloud/core/src/schema/key.sql.ts
+++ b/cloud/core/src/schema/key.sql.ts
@@ -1,8 +1,8 @@
-import { text, pgTable, varchar, uniqueIndex } from "drizzle-orm/pg-core"
+import { text, mysqlTable, varchar, uniqueIndex } from "drizzle-orm/mysql-core"
 import { timestamps, utc, workspaceColumns } from "../drizzle/types"
 import { workspaceIndexes } from "./workspace.sql"
 
-export const KeyTable = pgTable(
+export const KeyTable = mysqlTable(
   "key",
   {
     ...workspaceColumns,
diff --git a/cloud/core/src/schema/user.sql.ts b/cloud/core/src/schema/user.sql.ts
index 34cbd6beb..00c372d1a 100644
--- a/cloud/core/src/schema/user.sql.ts
+++ b/cloud/core/src/schema/user.sql.ts
@@ -1,16 +1,16 @@
-import { text, pgTable, uniqueIndex, varchar, integer } from "drizzle-orm/pg-core"
+import { text, mysqlTable, uniqueIndex, varchar, int } from "drizzle-orm/mysql-core"
 import { timestamps, utc, workspaceColumns } from "../drizzle/types"
 import { workspaceIndexes } from "./workspace.sql"
 
-export const UserTable = pgTable(
+export const UserTable = mysqlTable(
   "user",
   {
     ...workspaceColumns,
     ...timestamps,
-    email: text("email").notNull(),
+    email: varchar("email", { length: 255 }).notNull(),
     name: varchar("name", { length: 255 }).notNull(),
     timeSeen: utc("time_seen"),
-    color: integer("color"),
+    color: int("color"),
   },
   (table) => [...workspaceIndexes(table), uniqueIndex("user_email").on(table.workspaceID, table.email)],
 )
diff --git a/cloud/core/src/schema/workspace.sql.ts b/cloud/core/src/schema/workspace.sql.ts
index 3e9379e1f..979255428 100644
--- a/cloud/core/src/schema/workspace.sql.ts
+++ b/cloud/core/src/schema/workspace.sql.ts
@@ -1,7 +1,7 @@
-import { primaryKey, foreignKey, pgTable, uniqueIndex, varchar } from "drizzle-orm/pg-core"
+import { primaryKey, mysqlTable, uniqueIndex, varchar } from "drizzle-orm/mysql-core"
 import { timestamps, ulid } from "../drizzle/types"
 
-export const WorkspaceTable = pgTable(
+export const WorkspaceTable = mysqlTable(
   "workspace",
   {
     id: ulid("id").notNull().primaryKey(),
@@ -17,9 +17,5 @@ export function workspaceIndexes(table: any) {
     primaryKey({
       columns: [table.workspaceID, table.id],
     }),
-    foreignKey({
-      foreignColumns: [WorkspaceTable.id],
-      columns: [table.workspaceID],
-    }),
   ]
 }