diff options
Diffstat (limited to 'packages/db')
3 files changed, 28 insertions, 2 deletions
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[] |