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/workspace.sql.ts | 25 +++++++++++++++++++++++++ 1 file changed, 25 insertions(+) create mode 100644 cloud/core/src/schema/workspace.sql.ts (limited to 'cloud/core/src/schema/workspace.sql.ts') diff --git a/cloud/core/src/schema/workspace.sql.ts b/cloud/core/src/schema/workspace.sql.ts new file mode 100644 index 000000000..3e9379e1f --- /dev/null +++ b/cloud/core/src/schema/workspace.sql.ts @@ -0,0 +1,25 @@ +import { primaryKey, foreignKey, pgTable, uniqueIndex, varchar } from "drizzle-orm/pg-core" +import { timestamps, ulid } from "../drizzle/types" + +export const WorkspaceTable = pgTable( + "workspace", + { + id: ulid("id").notNull().primaryKey(), + slug: varchar("slug", { length: 255 }), + name: varchar("name", { length: 255 }), + ...timestamps, + }, + (table) => [uniqueIndex("slug").on(table.slug)], +) + +export function workspaceIndexes(table: any) { + return [ + primaryKey({ + columns: [table.workspaceID, table.id], + }), + foreignKey({ + foreignColumns: [WorkspaceTable.id], + columns: [table.workspaceID], + }), + ] +} -- cgit v1.2.3