resetting database data

[ClauWeb69]

Bug description

every time I do npx prisma migrate dev even without having made any changes of any kind, without even inserting records into the database, it asks me to reset the database

Drift detected: Your database schema is not in sync with your migration history.

The following is a summary of the differences between the expected database schema given your migrations files, and the actual schema of the database.

It should be understood as the set of changes to get from the expected schema to the actual schema.

[*] Changed the course table
[-] Removed foreign key on columns (course_CategoryId)
[-] Removed foreign key on columns (creatorId)
[-] Removed foreign key on columns (teacherId)

[*] Changed the course_module table
[-] Removed foreign key on columns (courseId)

[*] Changed the course_resources table
[-] Removed foreign key on columns (courseId)

[*] Changed the team_company table
[-] Removed foreign key on columns (teamManagerId)

[*] Changed the team_member table
[-] Removed foreign key on columns (teamId)
[-] Removed foreign key on columns (userId)

[*] Changed the ticket table
[-] Removed foreign key on columns (createdByUserId)
[-] Removed foreign key on columns (recipientId)

[*] Changed the ticket_message table
[-] Removed foreign key on columns (senderId)
[-] Removed foreign key on columns (ticketId)

[*] Changed the transactions table
[-] Removed foreign key on columns (userId)

[*] Changed the user_course_module_progression table
[-] Removed foreign key on columns (moduleId)
[-] Removed foreign key on columns (userId)

[*] Changed the user_subsciption table
[-] Removed foreign key on columns (subscriptionId)
[-] Removed foreign key on columns (userId)

? We need to reset the MySQL database "...." at "localhost:3306"
Do you want to continue? All data will be lost. » (y/N)

How to reproduce

<--- npx prisma migrate dev --->

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "mysql"
  url      = env("DATABASE_URL")
}

model User {
  id                             Int                              @id @default(autoincrement())
  email                          String                           @unique
  username                       String                           @unique
  firstname                      String?
  lastname                       String?
  avatar                         String?
  role                           Role                             @default(USER)
  ban                            Boolean                          @default(false)
  ticketsCreatedByUser           Ticket[]                         @relation("CreatedByUser")
  ticketsReceivedByUser          Ticket[]                         @relation("ReceivedByUser")
  User_Course_Module_Progression User_Course_Module_Progression[]
  User_Subsciption               User_Subsciption[]
  Transactions                   Transactions[]
  Ticket_Message                 Ticket_Message[]
  CourseCreator                  Course[]                         @relation("Creator")
  CourseTeacher                  Course[]                         @relation("Teacher")
  Team_Company                   Team_Company[]                   @relation("TeamManager")
  TeamMember                     Team_Member[]                    @relation("TeamMember")
}

model User_Course_Module_Progression {
  id       Int           @id @default(autoincrement())
  userId   Int
  moduleId Int
  dataOpen DateTime      @default(now()) @db.Timestamp(0)
  module   User          @relation(fields: [userId], references: [id])
  user     Course_Module @relation(fields: [moduleId], references: [id])
}

model User_Subsciption {
  id             Int           @id @default(autoincrement())
  userId         Int
  startDate      DateTime      @default(now()) @db.Timestamp(0)
  expireDate     DateTime      @db.Timestamp(0)
  User           User          @relation(fields: [userId], references: [id])
  Subscription   Subscription? @relation(fields: [subscriptionId], references: [id])
  subscriptionId Int?
}

model Subscription {
  id               Int                @id @default(autoincrement())
  name             String             @default("Free")
  level            Int                @default(0)
  User_Subsciption User_Subsciption[]
}

model Course {
  id                Int                @id @default(autoincrement())
  title             String?
  description       Json?
  caption           String?
  image             String?
  creation_date     DateTime           @default(now()) @db.Timestamp(0)
  type              CourseType         @default(ASYNC)
  linkMeet          String?
  modules           Course_Module[]
  teacherId         Int?
  creatorId         Int?
  Teacher           User?              @relation("Teacher", fields: [teacherId], references: [id])
  Creator           User?              @relation("Creator", fields: [creatorId], references: [id])
  Course_Category   Course_Category?   @relation(fields: [course_CategoryId], references: [id])
  course_CategoryId Int?
  Certificate       String?
  Course_Resources  Course_Resources[]
}

model Course_Resources {
  id       Int     @id @default(autoincrement())
  courseId Int
  name     String?
  path     String?
  type     String?
  Course   Course  @relation(fields: [courseId], references: [id])
}

model Team_Company {
  id            Int           @id @default(autoincrement())
  name          String
  teamManagerId Int
  TeamManager   User?         @relation("TeamManager", fields: [teamManagerId], references: [id])
  Team_Member   Team_Member[]
}

model Team_Member {
  id          Int           @id @default(autoincrement())
  userId      Int
  teamId      Int
  TeamCompany Team_Company? @relation(fields: [teamId], references: [id])
  TeamMember  User?         @relation("TeamMember", fields: [userId], references: [id])
}

model Course_Category {
  id     Int      @id @default(autoincrement())
  title  String
  Course Course[]
}

model Course_Module {
  id                             Int                              @id @default(autoincrement())
  courseId                       Int
  title                          String?
  content                        Json?
  order                          Int?
  type                           ModulesType?
  Course                         Course                           @relation(fields: [courseId], references: [id])
  User_Course_Module_Progression User_Course_Module_Progression[]
}

model Transactions {
  id            Int         @id @default(autoincrement())
  userId        Int
  amount        Float
  creation_date DateTime    @default(now()) @db.Timestamp(0)
  serviceId     Int
  typeId        ServiceType
  User          User        @relation(fields: [userId], references: [id])
}

model Ticket {
  id              Int              @id @default(autoincrement())
  createdByUserId Int
  recipientId     Int
  creation_date   DateTime         @default(now()) @db.Timestamp(0)
  createdByUser   User             @relation("CreatedByUser", fields: [createdByUserId], references: [id])
  recipient       User             @relation("ReceivedByUser", fields: [recipientId], references: [id])
  userId          Int?
  Ticket_Message  Ticket_Message[]
}

model Ticket_Message {
  id            Int      @id @default(autoincrement())
  ticketId      Int
  senderId      Int
  creation_date DateTime @default(now()) @db.Timestamp(0)
  message       String   @db.Text()
  Ticket        Ticket   @relation(fields: [ticketId], references: [id])
  Sender        User     @relation(fields: [senderId], references: [id])
}

enum CourseType {
  SYNC
  ASYNC
}

enum ServiceType {
  SUBSCRIPTION
  LIVECOURSE
}

enum ModulesType {
  VIDEO
  QUIZ
  SLIDE
}

enum Role {
  USER
  TEAMMANAGER
  TEACHER
  ADMIN
}

Environment & setup

Database Mysql locahost

Prisma Version

5.14.0

[ludralph]

Hi @ClauWeb69 👋

Thank you for raising this question.

If no changes was made in the schema or the database since the last use of the command npx prisma migrate dev there should be no need to reset the database. To help debug this, can you please enable debugging and post the logs to see if we can get more information with to help us figure this out.

[ClauWeb69]

`npx prisma migrate dev
prisma:engines binaries to download libquery-engine, schema-engine +325ms
prisma:getSchema Trying package.json... +438ms
prisma:getSchema prismaConfig {
"packagePath": "D:\Lavoro\ - Group\elearning\-Elearning\package.json"
} +2ms
prisma:getSchema package.json resolved to null +1ms
prisma:getSchema Trying relative... +0ms
prisma:getSchema Checking existence of D:\Lavoro\ - Group\elearning-Elearning\schema.prisma +0ms
prisma:getSchema Checking existence of D:\Lavoro\ - Group\elearning-Elearning\prisma\schema.prisma +0ms
prisma:getSchema Found schema at prisma\schema.prisma +1ms
prisma:getSchema relative resolved to prisma\schema.prisma +0ms
prisma:getSchema Reading schema from single file D:\Lavoro\ - Group\elearning-Elearning\prisma\schema.prisma +0ms
prisma:loadEnv project root found at D:\Lavoro\ - Group\elearning-Elearning\package.json +1ms
prisma:tryLoadEnv Environment variables loaded from D:\Lavoro\ - Group\elearning-Elearning.env +1ms
prisma:getConfig Using getConfig Wasm +2ms
prisma:getConfig config data retrieved without errors in getConfig Wasm +13ms
prisma:loadEnv project root found at D:\Lavoro\ - Group\elearning-Elearning\package.json +1ms
prisma:tryLoadEnv Environment variables loaded from D:\Lavoro\ - Group\elearning-Elearning.env +1ms
Environment variables loaded from .env
prisma:getSchema Reading schema from single file D:\Lavoro\ - Group\elearning-Elearning\prisma\schema.prisma +1ms
Prisma schema loaded from prisma\schema.prisma
prisma:getSchema Reading schema from single file D:\Lavoro\ - Group\elearning-Elearning\prisma\schema.prisma +1ms
prisma:getConfig Using getConfig Wasm +0ms
prisma:getConfig config data retrieved without errors in getConfig Wasm +2ms
Datasource "db": MySQL database "Elearning" at "localhost:3306"

prisma:validate Using validate Wasm +2ms
prisma:getConfig Using getConfig Wasm +14ms
prisma:getConfig config data retrieved without errors in getConfig Wasm +2ms
prisma:getSchema Reading schema from single file D:\Lavoro\ - Group\elearning-Elearning\prisma\schema.prisma +0ms
prisma:getConfig Using getConfig Wasm +1ms
prisma:getConfig config data retrieved without errors in getConfig Wasm +2ms
prisma:schemaEngine:rpc starting Schema engine with binary: D:\Lavoro\ - Group\elearning-Elearning\node_modules@prisma\engines\schema-engine-windows.exe +42ms
prisma:schemaEngine:rpc SENDING RPC CALL {"id":1,"jsonrpc":"2.0","method":"devDiagnostic","params":{"migrationsDirectoryPath":"D:\Lavoro\ - Group\elearning\-Elearning\prisma\migrations"}} +7ms
prisma:schemaEngine:stderr {"timestamp":"2024-05-17T16:50:20.5181198Z","level":"INFO","fields":{"message":"Starting schema engine RPC server","git_hash":"e9771e62de70f79a5e1c604a2d7c8e2a0a874b48"},"target":"schema_engine"} +10ms
prisma:migrate:dev {
"devDiagnostic": "{\n "action": {\n "tag": "reset",\n "reason": "Drift detected: Your database schema is not in sync with your migration history.\n\nThe following is a summary of the differences between the expected database schema given your migrations files, and the actual schema of the database.\n\nIt should be understood as the set of changes to get from the expected schema to the actual schema.\n\n[] Changed the course table\n [-] Removed foreign key on columns (course_CategoryId)\n [-] Removed foreign key on columns (creatorId)\n [-] Removed foreign key on columns (teacherId)\n\n[] Changed the course_module table\n [-] Removed foreign key on columns (courseId)\n\n[] Changed the course_resources table\n [-] Removed foreign key on columns (courseId)\n\n[] Changed the team_company table\n [-] Removed foreign key on columns (teamManagerId)\n\n[] Changed the team_member table\n [-] Removed foreign key on columns (teamId)\n [-] Removed foreign key on columns (userId)\n\n[] Changed the ticket table\n [-] Removed foreign key on columns (createdByUserId)\n [-] Removed foreign key on columns (recipientId)\n\n[] Changed the ticket_message table\n [-] Removed foreign key on columns (senderId)\n [-] Removed foreign key on columns (ticketId)\n\n[] Changed the transactions table\n [-] Removed foreign key on columns (userId)\n\n[] Changed the user_course_module_progression table\n [-] Removed foreign key on columns (moduleId)\n [-] Removed foreign key on columns (userId)\n\n[] Changed the user_subsciption table\n [-] Removed foreign key on columns (subscriptionId)\n [-] Removed foreign key on columns (userId)\n"\n }\n}"
} +5283ms
Drift detected: Your database schema is not in sync with your migration history.

The following is a summary of the differences between the expected database schema given your migrations files, and the actual schema of the database.

It should be understood as the set of changes to get from the expected schema to the actual schema.

[*] Changed the course table
[-] Removed foreign key on columns (course_CategoryId)
[-] Removed foreign key on columns (creatorId)
[-] Removed foreign key on columns (teacherId)

[*] Changed the course_module table
[-] Removed foreign key on columns (courseId)

[*] Changed the course_resources table
[-] Removed foreign key on columns (courseId)

[*] Changed the team_company table
[-] Removed foreign key on columns (teamManagerId)

[*] Changed the team_member table
[-] Removed foreign key on columns (teamId)
[-] Removed foreign key on columns (userId)

[*] Changed the ticket table
[-] Removed foreign key on columns (createdByUserId)
[-] Removed foreign key on columns (recipientId)

[*] Changed the ticket_message table
[-] Removed foreign key on columns (senderId)
[-] Removed foreign key on columns (ticketId)

[*] Changed the transactions table
[-] Removed foreign key on columns (userId)

[*] Changed the user_course_module_progression table
[-] Removed foreign key on columns (moduleId)
[-] Removed foreign key on columns (userId)

[*] Changed the user_subsciption table
[-] Removed foreign key on columns (subscriptionId)
[-] Removed foreign key on columns (userId)

Do you want to continue? All data will be lost. ... yes

prisma:schemaEngine:rpc SENDING RPC CALL {"id":2,"jsonrpc":"2.0","method":"reset"} +1005104ms
prisma:schemaEngine:rpc SENDING RPC CALL {"id":3,"jsonrpc":"2.0","method":"applyMigrations","params":{"migrationsDirectoryPath":"D:\Lavoro\ - Group\elearning\-Elearning\prisma\migrations"}} +388ms
prisma:schemaEngine:stderr {"timestamp":"2024-05-17T17:07:11.3292428Z","level":"INFO","fields":{"message":"Analysis run in 35ms","analysis_duration_ms":35},"target":"schema_core::commands::apply_migrations","span":{"name":"ApplyMigrations"},"spans":[{"name":"ApplyMigrations"}]} +36ms
prisma:schemaEngine:stderr {"timestamp":"2024-05-17T17:07:11.3293696Z","level":"INFO","fields":{"message":"Applying 20240515224430_","script":"-- CreateTable\nCREATE TABLE User (\n id INTEGER NOT NULL AUTO_INCREMENT,\n email VARCHAR(191) NOT NULL,\n username VARCHAR(191) NOT NULL,\n firstname VARCHAR(191) NULL,\n lastname VARCHAR(191) NULL,\n avatar VARCHAR(191) NULL,\n role ENUM('USER', 'TEAMMANAGER', 'TEACHER', 'ADMIN') NOT NULL DEFAULT 'USER',\n ban BOOLEAN NOT NULL DEFAULT false,\n\n UNIQUE INDEX User_email_key(email),\n UNIQUE INDEX User_username_key(username),\n PRIMARY KEY (id)\n) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\n\n-- CreateTable\nCREATE TABLE User_Course_Module_Progression (\n id INTEGER NOT NULL AUTO_INCREMENT,\n userId INTEGER NOT NULL,\n moduleId INTEGER NOT NULL,\n dataOpen TIMESTAMP(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),\n\n PRIMARY KEY (id)\n) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\n\n-- CreateTable\nCREATE TABLE User_Subsciption (\n id INTEGER NOT NULL AUTO_INCREMENT,\n userId INTEGER NOT NULL,\n startDate TIMESTAMP(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),\n expireDate TIMESTAMP(0) NOT NULL,\n subscriptionId INTEGER NULL,\n\n PRIMARY KEY (id)\n) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\n\n-- CreateTable\nCREATE TABLE Subscription (\n id INTEGER NOT NULL AUTO_INCREMENT,\n name VARCHAR(191) NOT NULL DEFAULT 'Free',\n level INTEGER NOT NULL DEFAULT 0,\n\n PRIMARY KEY (id)\n) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\n\n-- CreateTable\nCREATE TABLE Course (\n id INTEGER NOT NULL AUTO_INCREMENT,\n title VARCHAR(191) NULL,\n description JSON NULL,\n image VARCHAR(191) NULL,\n creation_date TIMESTAMP(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),\n type ENUM('SYNC', 'ASYNC') NOT NULL DEFAULT 'ASYNC',\n linkMeet VARCHAR(191) NULL,\n teacherId INTEGER NULL,\n creatorId INTEGER NULL,\n course_CategoryId INTEGER NULL,\n Certificate VARCHAR(191) NULL,\n\n PRIMARY KEY (id)\n) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\n\n-- CreateTable\nCREATE TABLE Course_Resources (\n id INTEGER NOT NULL AUTO_INCREMENT,\n courseId INTEGER NOT NULL,\n name VARCHAR(191) NULL,\n path VARCHAR(191) NULL,\n type VARCHAR(191) NULL,\n\n PRIMARY KEY (id)\n) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\n\n-- CreateTable\nCREATE TABLE Team_Company (\n id INTEGER NOT NULL AUTO_INCREMENT,\n name VARCHAR(191) NOT NULL,\n teamManagerId INTEGER NOT NULL,\n\n PRIMARY KEY (id)\n) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\n\n-- CreateTable\nCREATE TABLE Team_Member (\n id INTEGER NOT NULL AUTO_INCREMENT,\n userId INTEGER NOT NULL,\n teamId INTEGER NOT NULL,\n\n PRIMARY KEY (id)\n) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\n\n-- CreateTable\nCREATE TABLE Course_Category (\n id INTEGER NOT NULL AUTO_INCREMENT,\n title VARCHAR(191) NOT NULL,\n\n PRIMARY KEY (id)\n) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\n\n-- CreateTable\nCREATE TABLE Course_Module (\n id INTEGER NOT NULL AUTO_INCREMENT,\n courseId INTEGER NOT NULL,\n title VARCHAR(191) NULL,\n content JSON NULL,\n order INTEGER NULL,\n type ENUM('VIDEO', 'QUIZ', 'SLIDE') NULL,\n\n PRIMARY KEY (id)\n) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\n\n-- CreateTable\nCREATE TABLE Transactions (\n id INTEGER NOT NULL AUTO_INCREMENT,\n userId INTEGER NOT NULL,\n amount DOUBLE NOT NULL,\n creation_date TIMESTAMP(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),\n serviceId INTEGER NOT NULL,\n typeId ENUM('SUBSCRIPTION', 'LIVECOURSE') NOT NULL,\n\n PRIMARY KEY (id)\n) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\n\n-- CreateTable\nCREATE TABLE Ticket (\n id INTEGER NOT NULL AUTO_INCREMENT,\n createdByUserId INTEGER NOT NULL,\n recipientId INTEGER NOT NULL,\n creation_date TIMESTAMP(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),\n userId INTEGER NULL,\n\n PRIMARY KEY (id)\n) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\n\n-- CreateTable\nCREATE TABLE Ticket_Message (\n id INTEGER NOT NULL AUTO_INCREMENT,\n ticketId INTEGER NOT NULL,\n senderId INTEGER NOT NULL,\n creation_date TIMESTAMP(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),\n message TEXT NOT NULL,\n\n PRIMARY KEY (id)\n) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\n\n-- AddForeignKey\nALTER TABLE User_Course_Module_Progression ADD CONSTRAINT User_Course_Module_Progression_userId_fkey FOREIGN KEY (userId) REFERENCES User(id) ON DELETE RESTRICT ON UPDATE CASCADE;\n\n-- AddForeignKey\nALTER TABLE User_Course_Module_Progression ADD CONSTRAINT User_Course_Module_Progression_moduleId_fkey FOREIGN KEY (moduleId) REFERENCES Course_Module(id) ON DELETE RESTRICT ON UPDATE CASCADE;\n\n-- AddForeignKey\nALTER TABLE User_Subsciption ADD CONSTRAINT User_Subsciption_userId_fkey FOREIGN KEY (userId) REFERENCES User(id) ON DELETE RESTRICT ON UPDATE CASCADE;\n\n-- AddForeignKey\nALTER TABLE User_Subsciption ADD CONSTRAINT User_Subsciption_subscriptionId_fkey FOREIGN KEY (subscriptionId) REFERENCES Subscription(id) ON DELETE SET NULL ON UPDATE CASCADE;\n\n-- AddForeignKey\nALTER TABLE Course ADD CONSTRAINT Course_teacherId_fkey FOREIGN KEY (teacherId) REFERENCES User(id) ON DELETE SET NULL ON UPDATE CASCADE;\n\n-- AddForeignKey\nALTER TABLE Course ADD CONSTRAINT Course_creatorId_fkey FOREIGN KEY (creatorId) REFERENCES User(id) ON DELETE SET NULL ON UPDATE CASCADE;\n\n-- AddForeignKey\nALTER TABLE Course ADD CONSTRAINT Course_course_CategoryId_fkey FOREIGN KEY (course_CategoryId) REFERENCES Course_Category(id) ON DELETE SET NULL ON UPDATE CASCADE;\n\n-- AddForeignKey\nALTER TABLE Course_Resources ADD CONSTRAINT Course_Resources_courseId_fkey FOREIGN KEY (courseId) REFERENCES Course(id) ON DELETE RESTRICT ON UPDATE CASCADE;\n\n-- AddForeignKey\nALTER TABLE Team_Company ADD CONSTRAINT Team_Company_teamManagerId_fkey FOREIGN KEY (teamManagerId) REFERENCES User(id) ON DELETE RESTRICT ON UPDATE CASCADE;\n\n-- AddForeignKey\nALTER TABLE Team_Member ADD CONSTRAINT Team_Member_teamId_fkey FOREIGN KEY (teamId) REFERENCES Team_Company(id) ON DELETE RESTRICT ON UPDATE CASCADE;\n\n-- AddForeignKey\nALTER TABLE Team_Member ADD CONSTRAINT Team_Member_userId_fkey FOREIGN KEY (userId) REFERENCES User(id) ON DELETE RESTRICT ON UPDATE CASCADE;\n\n-- AddForeignKey\nALTER TABLE Course_Module ADD CONSTRAINT Course_Module_courseId_fkey FOREIGN KEY (courseId) REFERENCES Course(id) ON DELETE RESTRICT ON UPDATE CASCADE;\n\n-- AddForeignKey\nALTER TABLE Transactions ADD CONSTRAINT Transactions_userId_fkey FOREIGN KEY (userId) REFERENCES User(id) ON DELETE RESTRICT ON UPDATE CASCADE;\n\n-- AddForeignKey\nALTER TABLE Ticket ADD CONSTRAINT Ticket_createdByUserId_fkey FOREIGN KEY (createdByUserId) REFERENCES User(id) ON DELETE RESTRICT ON UPDATE CASCADE;\n\n-- AddForeignKey\nALTER TABLE Ticket ADD CONSTRAINT Ticket_recipientId_fkey FOREIGN KEY (recipientId) REFERENCES User(id) ON DELETE RESTRICT ON UPDATE CASCADE;\n\n-- AddForeignKey\nALTER TABLE Ticket_Message ADD CONSTRAINT Ticket_Message_ticketId_fkey FOREIGN KEY (ticketId) REFERENCES Ticket(id) ON DELETE RESTRICT ON UPDATE CASCADE;\n\n-- AddForeignKey\nALTER TABLE Ticket_Message ADD CONSTRAINT Ticket_Message_senderId_fkey FOREIGN KEY (senderId) REFERENCES User(id) ON DELETE RESTRICT ON UPDATE CASCADE;\n"},"target":"schema_core::commands::apply_migrations","span":{"migration_name":"20240515224430_","name":"Applying migration"},"spans":[{"name":"ApplyMigrations"},{"migration_name":"20240515224430_","name":"Applying migration"}]} +1ms
Applying migration 20240515224430_
prisma:schemaEngine:stderr {"timestamp":"2024-05-17T17:07:13.3218588Z","level":"INFO","fields":{"message":"Applying 20240515225034_","script":"-- AlterTable\nALTER TABLE course ADD COLUMN caption VARCHAR(191) NULL;\n"},"target":"schema_core::commands::apply_migrations","span":{"migration_name":"20240515225034_","name":"Applying migration"},"spans":[{"name":"ApplyMigrations"},{"migration_name":"20240515225034_","name":"Applying migration"}]} +1992ms
Applying migration 20240515225034_
prisma:schemaEngine:stderr {"timestamp":"2024-05-17T17:07:13.3684158Z","level":"INFO","fields":{"message":"Applying 20240517165014_","script":"-- AlterTable\nALTER TABLE course_module ADD COLUMN caption VARCHAR(191) NULL,\n ADD COLUMN lockFreemium BOOLEAN NOT NULL DEFAULT false;\n"},"target":"schema_core::commands::apply_migrations","span":{"migration_name":"20240517165014_","name":"Applying migration"},"spans":[{"name":"ApplyMigrations"},{"migration_name":"20240517165014_","name":"Applying migration"}]} +46ms
Applying migration 20240517165014_

The following migration(s) have been applied:

migrations/
└─ 20240515224430_/
└─ migration.sql
└─ 20240515225034_/
└─ migration.sql
└─ 20240517165014_/
└─ migration.sql
prisma:schemaEngine:rpc SENDING RPC CALL {"id":4,"jsonrpc":"2.0","method":"evaluateDataLoss","params":{"migrationsDirectoryPath":"D:\Lavoro\ - Group\elearning\-Elearning\prisma\migrations","prismaSchema":"// This is your Prisma schema file,\n// learn more about it in the docs: https://pris.ly/d/prisma-schema\n\n// Looking for ways to speed up your queries, or scale easily with your serverless or edge functions?\n// Try Prisma Accelerate: https://pris.ly/cli/accelerate-init\n\ngenerator client {\n provider = "prisma-client-js"\n}\n\ndatasource db {\n provider = "mysql"\n url = env("DATABASE_URL")\n}\n\nmodel User {\n id Int
@id @default(autoincrement())\n email String @unique\n username String @unique\n firstname String?\n lastname String?\n avatar String?\n role Role
@default(USER)\n ban Boolean @default(false)\n ticketsCreatedByUser Ticket[] @relation("CreatedByUser")\n ticketsReceivedByUser Ticket[] @relation("ReceivedByUser")\n User_Course_Module_Progression User_Course_Module_Progression[]\n User_Subsciption User_Subsciption[]\n Transactions Transactions[]\n Ticket_Message Ticket_Message[]\n CourseCreator Course[] @relation("Creator")\n CourseTeacher Course[] @relation("Teacher")\n Team_Company Team_Company[] @relation("TeamManager")\n TeamMember Team_Member[] @relation("TeamMember")\n}\n\nmodel User_Course_Module_Progression {\n id Int @id @default(autoincrement())\n userId Int\n moduleId Int\n dataOpen DateTime @default(now()) @db.Timestamp(0)\n module User @relation(fields: [userId], references: [id])\n user Course_Module @relation(fields: [moduleId], references: [id])\n}\n\nmodel User_Subsciption {\n id Int @id @default(autoincrement())\n userId Int\n startDate DateTime @default(now()) @db.Timestamp(0)\n expireDate DateTime @db.Timestamp(0)\n User User @relation(fields: [userId], references: [id])\n Subscription Subscription? @relation(fields: [subscriptionId], references: [id])\n subscriptionId Int?\n}\n\nmodel Subscription {\n id Int @id @default(autoincrement())\n name String @default("Free")\n level Int @default(0)\n User_Subsciption User_Subsciption[]\n}\n\nmodel Course {\n id Int @id @default(autoincrement())\n title String?\n description Json?\n caption String?\n image String?\n creation_date DateTime @default(now()) @db.Timestamp(0)\n type CourseType @default(ASYNC)\n linkMeet String?\n modules Course_Module[]\n teacherId Int?\n creatorId Int?\n Teacher User? @relation("Teacher", fields: [teacherId], references: [id])\n Creator User? @relation("Creator", fields: [creatorId], references: [id])\n Course_Category Course_Category? @relation(fields: [course_CategoryId], references: [id])\n course_CategoryId Int?\n Certificate String?\n Course_Resources Course_Resources[]\n}\n\nmodel Course_Resources {\n id Int @id @default(autoincrement())\n courseId Int\n name String?\n path String?\n type String?\n Course Course @relation(fields: [courseId], references: [id])\n}\n\nmodel Team_Company {\n id Int @id @default(autoincrement())\n name String\n teamManagerId Int\n TeamManager User? @relation("TeamManager", fields: [teamManagerId], references: [id])\n Team_Member Team_Member[]\n}\n\nmodel Team_Member {\n id Int @id @default(autoincrement())\n userId Int\n teamId Int\n TeamCompany Team_Company? @relation(fields: [teamId], references: [id])\n TeamMember User? @relation("TeamMember", fields: [userId], references: [id])\n}\n\nmodel Course_Category {\n id Int @id @default(autoincrement())\n title String\n Course Course[]\n}\n\nmodel Course_Module {\n id Int @id @default(autoincrement())\n courseId Int\n title String?\n content Json?\n caption String?\n order Int?\n lockFreemium
Boolean @default(false)\n type ModulesType?\n Course Course @relation(fields: [courseId], references: [id])\n User_Course_Module_Progression User_Course_Module_Progression[]\n}\n\nmodel Transactions {\n id Int @id @default(autoincrement())\n userId Int\n amount Float\n creation_date DateTime @default(now()) @db.Timestamp(0)\n serviceId Int\n typeId ServiceType\n User User @relation(fields: [userId], references: [id])\n}\n\nmodel Ticket {\n id Int @id @default(autoincrement())\n createdByUserId Int\n recipientId Int\n creation_date DateTime @default(now()) @db.Timestamp(0)\n createdByUser User @relation("CreatedByUser", fields: [createdByUserId], references: [id])\n recipient User @relation("ReceivedByUser", fields: [recipientId], references: [id])\n userId Int?\n Ticket_Message Ticket_Message[]\n}\n\nmodel Ticket_Message {\n id Int @id @default(autoincrement())\n ticketId Int\n senderId Int\n creation_date DateTime @default(now()) @db.Timestamp(0)\n message String @db.Text()\n Ticket Ticket @relation(fields: [ticketId], references: [id])\n Sender User @relation(fields: [senderId], references: [id])\n}\n\nenum CourseType {\n SYNC\n ASYNC\n}\n\nenum ServiceType {\n SUBSCRIPTION\n LIVECOURSE\n}\n\nenum ModulesType {\n VIDEO\n QUIZ\n SLIDE\n}\n\nenum Role {\n USER\n TEAMMANAGER\n TEACHER\n ADMIN\n}\n"}} +43ms
prisma:migrate:dev {
"evaluateDataLossResult": {
"migrationSteps": 0,
"unexecutableSteps": [],
"warnings": []
}
} +7528ms
prisma:schemaEngine:rpc SENDING RPC CALL {"id":5,"jsonrpc":"2.0","method":"createMigration","params":{"migrationsDirectoryPath":"D:\Lavoro\ - Group\elearning\-Elearning\prisma\migrations","migrationName":"","draft":false,"prismaSchema":"// This is your Prisma schema file,\n// learn more about it in the docs: https://pris.ly/d/prisma-schema\n\n// Looking for ways to speed up your queries, or scale easily with your serverless or edge functions?\n// Try Prisma Accelerate: https://pris.ly/cli/accelerate-init\n\ngenerator client {\n provider = "prisma-client-js"\n}\n\ndatasource db {\n provider = "mysql"\n url = env("DATABASE_URL")\n}\n\nmodel User {\n id
Int @id @default(autoincrement())\n email String @unique\n username String @unique\n firstname String?\n lastname String?\n avatar String?\n role
Role @default(USER)\n ban Boolean @default(false)\n ticketsCreatedByUser Ticket[] @relation("CreatedByUser")\n ticketsReceivedByUser Ticket[] @relation("ReceivedByUser")\n User_Course_Module_Progression User_Course_Module_Progression[]\n User_Subsciption User_Subsciption[]\n Transactions Transactions[]\n Ticket_Message Ticket_Message[]\n CourseCreator Course[] @relation("Creator")\n CourseTeacher Course[] @relation("Teacher")\n Team_Company Team_Company[] @relation("TeamManager")\n TeamMember Team_Member[] @relation("TeamMember")\n}\n\nmodel User_Course_Module_Progression {\n id Int @id @default(autoincrement())\n userId Int\n moduleId Int\n dataOpen DateTime @default(now()) @db.Timestamp(0)\n module User @relation(fields: [userId], references: [id])\n user Course_Module @relation(fields: [moduleId], references: [id])\n}\n\nmodel User_Subsciption {\n id Int @id @default(autoincrement())\n userId Int\n startDate DateTime @default(now()) @db.Timestamp(0)\n expireDate DateTime @db.Timestamp(0)\n User User @relation(fields: [userId], references: [id])\n Subscription Subscription? @relation(fields: [subscriptionId], references: [id])\n subscriptionId Int?\n}\n\nmodel Subscription {\n id Int @id @default(autoincrement())\n name String
@default("Free")\n level Int @default(0)\n User_Subsciption User_Subsciption[]\n}\n\nmodel Course {\n id Int @id @default(autoincrement())\n title String?\n description Json?\n caption String?\n image String?\n creation_date DateTime @default(now()) @db.Timestamp(0)\n type CourseType @default(ASYNC)\n linkMeet String?\n modules Course_Module[]\n teacherId Int?\n creatorId Int?\n Teacher User? @relation("Teacher", fields: [teacherId], references: [id])\n Creator User? @relation("Creator", fields: [creatorId], references: [id])\n Course_Category Course_Category? @relation(fields: [course_CategoryId], references: [id])\n course_CategoryId Int?\n Certificate String?\n Course_Resources Course_Resources[]\n}\n\nmodel Course_Resources {\n id Int @id @default(autoincrement())\n courseId Int\n name String?\n path String?\n type String?\n Course Course @relation(fields: [courseId], references: [id])\n}\n\nmodel Team_Company {\n id Int @id @default(autoincrement())\n name String\n teamManagerId Int\n TeamManager User? @relation("TeamManager", fields: [teamManagerId], references: [id])\n Team_Member Team_Member[]\n}\n\nmodel Team_Member {\n id Int @id @default(autoincrement())\n userId Int\n teamId Int\n TeamCompany Team_Company? @relation(fields: [teamId], references: [id])\n TeamMember User? @relation("TeamMember", fields: [userId], references: [id])\n}\n\nmodel Course_Category {\n id Int @id @default(autoincrement())\n title String\n Course Course[]\n}\n\nmodel Course_Module {\n id Int @id @default(autoincrement())\n courseId Int\n title String?\n content Json?\n caption String?\n order
Int?\n lockFreemium Boolean @default(false)\n type ModulesType?\n Course Course @relation(fields: [courseId], references: [id])\n User_Course_Module_Progression User_Course_Module_Progression[]\n}\n\nmodel Transactions {\n id
Int @id @default(autoincrement())\n userId Int\n amount Float\n creation_date DateTime @default(now()) @db.Timestamp(0)\n serviceId Int\n typeId ServiceType\n User User @relation(fields: [userId], references: [id])\n}\n\nmodel Ticket {\n id Int @id @default(autoincrement())\n createdByUserId Int\n recipientId Int\n creation_date DateTime @default(now()) @db.Timestamp(0)\n createdByUser User @relation("CreatedByUser", fields: [createdByUserId], references: [id])\n recipient User @relation("ReceivedByUser", fields: [recipientId], references: [id])\n userId Int?\n Ticket_Message Ticket_Message[]\n}\n\nmodel Ticket_Message {\n id Int @id @default(autoincrement())\n ticketId Int\n senderId Int\n creation_date DateTime @default(now()) @db.Timestamp(0)\n message String @db.Text()\n Ticket Ticket @relation(fields: [ticketId], references: [id])\n Sender User @relation(fields: [senderId], references: [id])\n}\n\nenum CourseType {\n SYNC\n ASYNC\n}\n\nenum ServiceType {\n SUBSCRIPTION\n LIVECOURSE\n}\n\nenum ModulesType {\n VIDEO\n QUIZ\n SLIDE\n}\n\nenum Role {\n USER\n TEAMMANAGER\n TEACHER\n ADMIN\n}\n"}} +1ms
prisma:schemaEngine:stderr {"timestamp":"2024-05-17T17:07:24.0529498Z","level":"INFO","fields":{"message":"Database is up-to-date, returning without creating new migration."},"target":"schema_core::commands::create_migration","span":{"draft":false,"migration_name":"","name":"CreateMigration"},"spans":[{"draft":false,"migration_name":"","name":"CreateMigration"}]} +3113ms
prisma:migrate:dev {
"createMigrationResult": {
"generatedMigrationName": null
}
} +0ms
prisma:schemaEngine:rpc SENDING RPC CALL {"id":6,"jsonrpc":"2.0","method":"applyMigrations","params":{"migrationsDirectoryPath":"D:\Lavoro\ - Group\elearning\-Elearning\prisma\migrations"}} +1ms
prisma:schemaEngine:stderr {"timestamp":"2024-05-17T17:07:24.056386Z","level":"INFO","fields":{"message":"Analysis run in 2ms","analysis_duration_ms":2},"target":"schema_core::commands::apply_migrations","span":{"name":"ApplyMigrations"},"spans":[{"name":"ApplyMigrations"}]} +2ms

Your database is now in sync with your schema.

Running generate... (Use --skip-generate to skip the generators)
prisma:getSchema Reading schema from single file D:\Lavoro\ - Group\elearning-Elearning\prisma\schema.prisma +3ms
prisma:getConfig Using getConfig Wasm +81ms
prisma:getConfig config data retrieved without errors in getConfig Wasm +1ms
prisma:getDMMF Using getDmmf Wasm +1ms
prisma:getDMMF Using given datamodel +0ms
prisma:getDMMF dmmf data retrieved without errors in getDmmf Wasm +55ms
prisma:generator prismaCLIDir D:\Lavoro\ - Group\elearning-Elearning\node_modules\prisma +7ms
prisma:generator prismaClientDir D:\Lavoro\ - Group\elearning-Elearning\node_modules@prisma\client +0ms
prisma:generator baseDir D:\Lavoro\ - Group\elearning-Elearning\prisma +0ms
prisma:generator typescriptPath D:\Lavoro\ - Group\elearning-Elearning\node_modules\typescript +4ms
prisma:GeneratorProcess prisma:client:generator requiredEngine: libqueryEngine +67ms +123ms
prisma:mergeSchemas Using mergeSchemas Wasm +0ms
prisma:getGenerators neededVersions {
"e9771e62de70f79a5e1c604a2d7c8e2a0a874b48": {
"engines": [
"libqueryEngine"
],
"binaryTargets": [
{
"fromEnvVar": null,
"value": "windows",
"native": true
}
]
}
} +4ms
prisma:getGenerators {
"generatorBinaryPaths": {
"libqueryEngine": {
"windows": "D:\Lavoro\ - Group\elearning\-Elearning\node_modules\prisma\query_engine-windows.dll.node"
}
}
Running generate... - Prisma Client
prisma:GeneratorProcess prisma:loadEnv project root found at D:\Lavoro\ - Group\elearning-Elearning\node_modules.prisma\client\package.json +112ms +24ms
✔ Generated Prisma Client (v5.14.0) to .\node_modules@prisma\client in 107ms

prisma:migrate:seed {
"prismaConfig": {
"packagePath": "D:\Lavoro\ - Group\elearning\-Elearning\package.json"
}
} +23ms
prisma:getSchema Reading schema from single file D:\Lavoro\ - Group\elearning-Elearning\prisma\schema.prisma +0ms
prisma:migrate:seed {
"detected": {
"seedPath": "prisma\seed.",
"numberOfSeedFiles": 0,
"js": "",
"ts": "",
"sh": ""
}
} +1ms
prisma:cli:bin Execution time for executing "await cli.parse(commandArray)": 1024227.5717000067 ms +1ms

prisma:getSchema Trying package.json... +0ms
prisma:getSchema Trying package.json... +1ms
prisma:getSchema prismaConfig {
"packagePath": "D:\Lavoro\ - Group\elearning\-Elearning\package.json"
} +0ms
prisma:getSchema package.json resolved to null +0ms
prisma:getSchema Trying relative... +0ms
prisma:getSchema Checking existence of D:\Lavoro\ - Group\elearning-Elearning\schema.prisma +1ms
prisma:getSchema prismaConfig {
"packagePath": "D:\Lavoro\ - Group\elearning\-Elearning\package.json"
} +0ms
prisma:getSchema package.json resolved to null +0ms
prisma:getSchema Trying relative... +0ms
prisma:getSchema Checking existence of D:\Lavoro\ - Group\elearning-Elearning\schema.prisma +0ms
prisma:getSchema Checking existence of D:\Lavoro\ - Group\elearning-Elearning\prisma\schema.prisma +0ms
prisma:GeneratorProcess child exited with code null on signal SIGTERM +0ms
prisma:getSchema Checking existence of D:\Lavoro\ - Group\elearning-Elearning\prisma\schema.prisma +1ms
prisma:getSchema Found schema at prisma\schema.prisma +0ms
prisma:getSchema relative resolved to prisma\schema.prisma +0ms
prisma:getSchema Reading schema from single file D:\Lavoro\ - Group\elearning-Elearning\prisma\schema.prisma +0ms
prisma:getSchema Found schema at prisma\schema.prisma +0ms
prisma:getSchema relative resolved to prisma\schema.prisma +0ms
prisma:getSchema Reading schema from single file D:\Lavoro\ - Group\elearning-Elearning\prisma\schema.prisma +0ms
prisma:getConfig Using getConfig Wasm +1ms
prisma:getConfig config data retrieved without errors in getConfig Wasm +1ms
prisma:cli:checkpoint runCheckpointClientCheck(): Execution time for getting info: 5.031399995088577 ms +0ms
prisma:cli:checkpoint runCheckpointClientCheck(): Execution time for "await checkpoint.check(data)": 21.062600016593933 ms +22ms

`