diff options
Diffstat (limited to 'packages/console/core/src/schema/user.sql.ts')
| -rw-r--r-- | packages/console/core/src/schema/user.sql.ts | 7 |
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)], ) |