1 files changed, 16 insertions, 0 deletions
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)],
+)