Using MYSQL enum in ecto migrations

Questions & Help Questions
,
2

I figure out a workaround for this. After creating a table with ecto migration. I executed SQL command to alter the table and add the enum column like this:

create table(:users) do
  add(:business_id, :string, null: false, default: "")
end

execute "ALTER TABLE users
   ADD role ENUM('owner', 'worker', 'manager', 'pending_approval');"