how can i use array of enums at prisma2 schema for mysql? if not possible what is the workaround for it? i want something like this: roles Roles[] @default([USER])

@prisma-chobo 👋 Adding a

@default

to array of enums is not supported yet. One workaround would be to append it in your application logic. It would be great if you could create a feature request here for the same so that we can look into this 🙂

@prisma-chobo first create an enum on

prisma schema

enum Roles {
  admin
  user
}

#then add it to the model

model Users {
  id    Int    @id @default(autoincrement()) 
  roles Roles
  ...
}

but this is not list isnt it?

It works fine. Are you facing any issue?

yes my connector is mysql and its complaning about it does not support list enums :(

Ahh, it’s only supported for Postgres at the moment. There’s a request for MySQL that you can follow here and add a 👍 as well.

thank you again ryan!!