class RolifyCreateRoles < ActiveRecord::Migration[5.0]
  def change
    create_table :roles, options: 'ROW_FORMAT=DYNAMIC' do |t|
      t.string :name
      t.references :resource, polymorphic: true

      t.timestamps
    end

    create_table :users_roles, id: false, options: 'ROW_FORMAT=DYNAMIC' do |t|
      t.references :user
      t.references :role
    end

    add_index :roles, :name
    add_index :roles, [:name, :resource_type, :resource_id]
    add_index :users_roles, [:user_id, :role_id]
  end
end

class RolifyCreateRoles < ActiveRecord::Migration[5.0]
  def change
    create_table :roles, options: 'DEFAULT CHARSET=utf8' do |t|
      t.string :name
      t.references :resource, polymorphic: true

      t.timestamps
    end

    create_table :users_roles, id: false, options: 'DEFAULT CHARSET=utf8' do |t|
      t.references :user
      t.references :role
    end

    add_index :roles, :name
    add_index :roles, [:name, :resource_type, :resource_id]
    add_index :users_roles, [:user_id, :role_id]
  end
end

Fix mysql issue when creating tables
Fix mysql issue when creating tables
