summaryrefslogtreecommitdiffhomepage
path: root/packages/console/core/src/schema/provider.sql.ts
blob: 04d11e2e58346254858484802a73d0a7d840badd (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
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),
  ],
)