From 729ad1cb75bb4518ab83f6784d63f69b75626f58 Mon Sep 17 00:00:00 2001 From: Frank Date: Thu, 16 Oct 2025 17:50:30 -0400 Subject: wip: zen --- packages/console/core/src/schema/auth.sql.ts | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 packages/console/core/src/schema/auth.sql.ts (limited to 'packages/console/core/src/schema/auth.sql.ts') diff --git a/packages/console/core/src/schema/auth.sql.ts b/packages/console/core/src/schema/auth.sql.ts new file mode 100644 index 000000000..be2244ef3 --- /dev/null +++ b/packages/console/core/src/schema/auth.sql.ts @@ -0,0 +1,16 @@ +import { mysqlEnum, mysqlTable, uniqueIndex, varchar } from "drizzle-orm/mysql-core" +import { id, timestamps, ulid } from "../drizzle/types" + +export const AuthProvider = ["email", "github", "google"] as const + +export const AuthTable = mysqlTable( + "auth", + { + id: id(), + ...timestamps, + provider: mysqlEnum("provider", AuthProvider).notNull(), + subject: varchar("subject", { length: 255 }).notNull(), + accountID: ulid("account_id").notNull(), + }, + (table) => [uniqueIndex("provider").on(table.provider, table.subject)], +) -- cgit v1.2.3