-
Notifications
You must be signed in to change notification settings - Fork 1.5k
Replies: 1 comment · 1 reply
-
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 |
Beta Was this translation helpful? Give feedback.
All reactions
-
`npx prisma migrate dev prisma:validate Using validate Wasm +2ms 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 [*] Changed the [*] Changed the [*] Changed the [*] Changed the [*] Changed the [*] Changed the [*] Changed the [*] Changed the [*] Changed the 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 The following migration(s) have been applied: migrations/ Your database is now in sync with your schema. Running generate... (Use --skip-generate to skip the generators) prisma:migrate:seed { prisma:getSchema Trying package.json... +0ms ` |
Beta Was this translation helpful? Give feedback.
All reactions
This discussion was converted from issue #24215 on May 16, 2024 08:33.
-
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 --->
Environment & setup
Database Mysql locahost
Prisma Version
5.14.0
Beta Was this translation helpful? Give feedback.
All reactions