database migration error
when I updated prisma, it needs to do db migration, but every time it needs to erease everything, is there a way that only update what has been changed instead of recreate the whole db?
Environment variables loaded from .env
Prisma schema loaded from ../db/schema.prisma
Datasource "db": PostgreSQL database "postgres", schema "public" at "xx.xx.xx.xx:5432"
- The migration
- 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
[] Altered column
? We need to reset the "public" schema at "xx.xx.xx.xx:5432"
Do you want to continue? All data will be lost. ? (y/N)
@miho @Vinny (@Wasp)
Environment variables loaded from .env
Prisma schema loaded from ../db/schema.prisma
Datasource "db": PostgreSQL database "postgres", schema "public" at "xx.xx.xx.xx:5432"
- The migration
20240514212711_dev- 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
User[] Altered column
creditsSome(Value(Int(3)))Some(Value(Int(1)))? We need to reset the "public" schema at "xx.xx.xx.xx:5432"
Do you want to continue? All data will be lost. ? (y/N)
@miho @Vinny (@Wasp)
