wip: zen

1 files changed, 6 insertions, 1 deletions

diff --git a/packages/console/core/src/schema/user.sql.ts b/packages/console/core/src/schema/user.sql.ts
index 00c372d1a..7f051a614 100644
--- a/packages/console/core/src/schema/user.sql.ts
+++ b/packages/console/core/src/schema/user.sql.ts
@@ -1,7 +1,10 @@
-import { text, mysqlTable, uniqueIndex, varchar, int } from "drizzle-orm/mysql-core"
+import { mysqlTable, uniqueIndex, varchar, int, mysqlEnum } from "drizzle-orm/mysql-core"
 import { timestamps, utc, workspaceColumns } from "../drizzle/types"
 import { workspaceIndexes } from "./workspace.sql"
 
+const UserRole = ["admin", "member"] as const
+export type UserRole = (typeof UserRole)[number]
+
 export const UserTable = mysqlTable(
   "user",
   {
@@ -10,7 +13,9 @@ export const UserTable = mysqlTable(
     email: varchar("email", { length: 255 }).notNull(),
     name: varchar("name", { length: 255 }).notNull(),
     timeSeen: utc("time_seen"),
+    timeJoined: utc("time_joined"),
     color: int("color"),
+    role: mysqlEnum("role", ["admin", "member"]),
   },
   (table) => [...workspaceIndexes(table), uniqueIndex("user_email").on(table.workspaceID, table.email)],
 )