wip: zen

1 files changed, 14 insertions, 0 deletions

diff --git a/packages/console/core/src/schema/provider.sql.ts b/packages/console/core/src/schema/provider.sql.ts
new file mode 100644
index 000000000..11be5b4d7
--- /dev/null
+++ b/packages/console/core/src/schema/provider.sql.ts
@@ -0,0 +1,14 @@
+import { mysqlTable, text, uniqueIndex, varchar } from "drizzle-orm/mysql-core"
+import { timestamps, workspaceColumns } from "../drizzle/types"
+import { workspaceIndexes } from "./workspace.sql"
+
+export const ProviderTable = mysqlTable(
+  "provider",
+  {
+    ...workspaceColumns,
+    ...timestamps,
+    provider: varchar("provider", { length: 64 }).notNull(),
+    credentials: text("credentials").notNull(),
+  },
+  (table) => [...workspaceIndexes(table), uniqueIndex("workspace_provider").on(table.workspaceID, table.provider)],
+)