how to add a column to my database in production without wiping database (prisma x mysql)

I want to add a column to my current user table
I want to add a column called verified and defaults to false
But we are currently in production with large users i can't afford data lose any ideas?

Fflorida-dev This section of the Prisma docs shows you how to make the change in prisma. http...

LopenOP•3/18/23, 11:52 AM

Prisma docs on this is actually very confusing but i figured it out though

LopenOP•3/18/23, 11:52 AM

Create a new dummy database so you can generate a new migration on it
Go to your production database and delete everything in _prisma_migration
Delete everything in your migration folder on your project
Connect to your dummy database and run the command npx prisma migrate dev --name init_state
While still connected to your dummy database edit you scheme.prisma and all the changes you want then run the command npx prisma migrate dev --name add_new_things
Connect back to your production database and run npx prisma migrate resolve --applied the_name_of_the_migration_folder_applied_before this is to mark all the migrations you have applied before
Finally run npx prisma migrate deploy this will apply the latest migrations yet to be applied

Ssean_j_roberts Just a warning that adding a new field with a default value in MySQL can be a re...

LopenOP•3/18/23, 11:53 AM

Does it also affect it if i use PostgreSQL?

Ssean_j_roberts Just a warning that adding a new field with a default value in MySQL can be a re...

LopenOP•3/18/23, 11:56 AM

When you say job can't i do it in prisma and maybe do it in loop inside a seed file?

So i do something like Prisma.user.findmany()
Then loop through all and update them accordingly?

LopenOP•3/18/23, 11:56 AM

Also how bad is the performance issue
Because i have actually done that in production and gone live already