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/key.sql.ts | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) create mode 100644 packages/console/core/src/schema/key.sql.ts (limited to 'packages/console/core/src/schema/key.sql.ts') diff --git a/packages/console/core/src/schema/key.sql.ts b/packages/console/core/src/schema/key.sql.ts new file mode 100644 index 000000000..98b99c788 --- /dev/null +++ b/packages/console/core/src/schema/key.sql.ts @@ -0,0 +1,22 @@ +import { mysqlTable, varchar, uniqueIndex, json } from "drizzle-orm/mysql-core" +import { timestamps, utc, workspaceColumns } from "../drizzle/types" +import { workspaceIndexes } from "./workspace.sql" +import { Actor } from "../actor" + +export const KeyTable = mysqlTable( + "key", + { + ...workspaceColumns, + ...timestamps, + actor: json("actor").$type(), + name: varchar("name", { length: 255 }).notNull(), + oldName: varchar("old_name", { length: 255 }), + key: varchar("key", { length: 255 }).notNull(), + timeUsed: utc("time_used"), + }, + (table) => [ + ...workspaceIndexes(table), + uniqueIndex("global_key").on(table.key), + uniqueIndex("name").on(table.workspaceID, table.name), + ], +) -- cgit v1.2.3