From 942aac691225f4895c159a0260890ad2c576e0c9 Mon Sep 17 00:00:00 2001
From: MohamedBassem <me@mbassem.com>
Date: Thu, 22 Feb 2024 15:32:40 +0000
Subject: feature: Add support for credentials registration and sign in

---
 .../migration.sql                                  |  2 ++
 .../migration.sql                                  | 23 ++++++++++++++++++++++
 packages/db/prisma/schema.prisma                   |  5 +++--
 3 files changed, 28 insertions(+), 2 deletions(-)
 create mode 100644 packages/db/prisma/migrations/20240221104430_add_password_support/migration.sql
 create mode 100644 packages/db/prisma/migrations/20240222152033_name_and_email_required/migration.sql

(limited to 'packages/db')

diff --git a/packages/db/prisma/migrations/20240221104430_add_password_support/migration.sql b/packages/db/prisma/migrations/20240221104430_add_password_support/migration.sql
new file mode 100644
index 00000000..4c9b7b00
--- /dev/null
+++ b/packages/db/prisma/migrations/20240221104430_add_password_support/migration.sql
@@ -0,0 +1,2 @@
+-- AlterTable
+ALTER TABLE "User" ADD COLUMN "password" TEXT;
diff --git a/packages/db/prisma/migrations/20240222152033_name_and_email_required/migration.sql b/packages/db/prisma/migrations/20240222152033_name_and_email_required/migration.sql
new file mode 100644
index 00000000..fa73b56e
--- /dev/null
+++ b/packages/db/prisma/migrations/20240222152033_name_and_email_required/migration.sql
@@ -0,0 +1,23 @@
+/*
+  Warnings:
+
+  - Made the column `email` on table `User` required. This step will fail if there are existing NULL values in that column.
+  - Made the column `name` on table `User` required. This step will fail if there are existing NULL values in that column.
+
+*/
+-- RedefineTables
+PRAGMA foreign_keys=OFF;
+CREATE TABLE "new_User" (
+    "id" TEXT NOT NULL PRIMARY KEY,
+    "name" TEXT NOT NULL,
+    "email" TEXT NOT NULL,
+    "emailVerified" DATETIME,
+    "password" TEXT,
+    "image" TEXT
+);
+INSERT INTO "new_User" ("email", "emailVerified", "id", "image", "name", "password") SELECT "email", "emailVerified", "id", "image", "name", "password" FROM "User";
+DROP TABLE "User";
+ALTER TABLE "new_User" RENAME TO "User";
+CREATE UNIQUE INDEX "User_email_key" ON "User"("email");
+PRAGMA foreign_key_check;
+PRAGMA foreign_keys=ON;
diff --git a/packages/db/prisma/schema.prisma b/packages/db/prisma/schema.prisma
index 8a681a0b..3b6063a3 100644
--- a/packages/db/prisma/schema.prisma
+++ b/packages/db/prisma/schema.prisma
@@ -39,9 +39,10 @@ model Session {
 
 model User {
   id            String         @id @default(cuid())
-  name          String?
-  email         String?        @unique
+  name          String
+  email         String         @unique
   emailVerified DateTime?
+  password      String?
   image         String?
   accounts      Account[]
   sessions      Session[]
-- 
cgit v1.2.3-70-g09d2