From 4ceabdffa07b1af8d99eb73622a4d549d99ec6d2 Mon Sep 17 00:00:00 2001 From: Frank Date: Thu, 18 Sep 2025 10:59:01 -0400 Subject: wip: zen --- packages/console/core/src/schema/workspace.sql.ts | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 packages/console/core/src/schema/workspace.sql.ts (limited to 'packages/console/core/src/schema/workspace.sql.ts') diff --git a/packages/console/core/src/schema/workspace.sql.ts b/packages/console/core/src/schema/workspace.sql.ts new file mode 100644 index 000000000..979255428 --- /dev/null +++ b/packages/console/core/src/schema/workspace.sql.ts @@ -0,0 +1,21 @@ +import { primaryKey, mysqlTable, uniqueIndex, varchar } from "drizzle-orm/mysql-core" +import { timestamps, ulid } from "../drizzle/types" + +export const WorkspaceTable = mysqlTable( + "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], + }), + ] +} -- cgit v1.2.3