summaryrefslogtreecommitdiffhomepage
path: root/cloud/core/src/schema/key.sql.ts
blob: 200e829cb00e23678033169fac3b92215a570003 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
import { text, mysqlTable, varchar, uniqueIndex } from "drizzle-orm/mysql-core"
import { timestamps, utc, workspaceColumns } from "../drizzle/types"
import { workspaceIndexes } from "./workspace.sql"

export const KeyTable = mysqlTable(
  "key",
  {
    ...workspaceColumns,
    ...timestamps,
    userID: text("user_id").notNull(),
    name: varchar("name", { length: 255 }).notNull(),
    key: varchar("key", { length: 255 }).notNull(),
    timeUsed: utc("time_used"),
  },
  (table) => [...workspaceIndexes(table), uniqueIndex("global_key").on(table.key)],
)