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"
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_devfailed. - Drift detected: Your database schema is not in sync with your migration history.
It should be understood as the set of changes to get from the expected schema to the actual schema.
[] Changed the
User table[] Altered column
credits (default changed from Some(Value(Int(3))) to 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)
