PrismaP
Prisma•8mo ago•
4 replies
Uncle

Changing Enum types

Hello I have an Enum that I need to change. The enum was 
enum PaymentType {
  STRIPE
  CASH
  CHECK
}

and I need it to be 
enum PaymentType {
  CREDIT
  CASH
  CHECK
}

When I do pnpm prisma db push I get an error: 
Error: ERROR: invalid input value for enum "PaymentType_new": "STRIPE"
   0: sql_schema_connector::apply_migration::migration_step
           with step=AlterEnum(AlterEnum { id: MigrationPair { previous: EnumId(0), next: EnumId(0) }, created_variants: ["CREDIT"], dropped_variants: ["STRIPE"], previous_usages_as_default: [] })
             at schema-engine/connectors/sql-schema-connector/src/apply_migration.rs:28
   1: sql_schema_connector::apply_migration::apply_migration
             at schema-engine/connectors/sql-schema-connector/src/apply_migration.rs:11
   2: schema_core::state::SchemaPush
             at schema-engine/core/src/state.rs:502

I also can't seed the database. How do I reset the database so I can change the Enum?
Was this page helpful?