class ConvertEncodingToUtf8 < ActiveRecord::Migration[6.0]
  def change
    execute('ALTER DATABASE kidows CHARACTER SET utf8 COLLATE utf8_general_ci;')
    execute('ALTER TABLE audits CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;')

    execute <<-SQL
      ALTER TABLE additional_names CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    SQL

    execute <<-SQL
      ALTER TABLE Students CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci,
        MODIFY NickName VARCHAR(36) CHARACTER SET utf8 COLLATE utf8_general_ci;
    SQL
  end
end