From 183e0911b76025a1f2a82e979d9834fec2131d0e Mon Sep 17 00:00:00 2001 From: Frank Date: Fri, 8 Aug 2025 13:22:54 -0400 Subject: wip: gateway --- cloud/core/src/schema/user.sql.ts | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 cloud/core/src/schema/user.sql.ts (limited to 'cloud/core/src/schema/user.sql.ts') diff --git a/cloud/core/src/schema/user.sql.ts b/cloud/core/src/schema/user.sql.ts new file mode 100644 index 000000000..34cbd6beb --- /dev/null +++ b/cloud/core/src/schema/user.sql.ts @@ -0,0 +1,16 @@ +import { text, pgTable, uniqueIndex, varchar, integer } from "drizzle-orm/pg-core" +import { timestamps, utc, workspaceColumns } from "../drizzle/types" +import { workspaceIndexes } from "./workspace.sql" + +export const UserTable = pgTable( + "user", + { + ...workspaceColumns, + ...timestamps, + email: text("email").notNull(), + name: varchar("name", { length: 255 }).notNull(), + timeSeen: utc("time_seen"), + color: integer("color"), + }, + (table) => [...workspaceIndexes(table), uniqueIndex("user_email").on(table.workspaceID, table.email)], +) -- cgit v1.2.3