Contents

# frozen_string_literal: true

class ChangeEmailToCitext < ActiveRecord::Migration[7.0]
  def up
    enable_extension "citext"
    %i[users invites].each do |t|
      change_column t, :email, :citext
      add_index t, :email, unique: true, name: "index_#{t}_on_email"
    end
  end

  def down
    %i[users invites].each do |t|
      change_column t, :email, :string
      remove_index t, name: "index_#{t}_on_email"
    end
  end
end

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
pages_core-3.15.5	db/migrate/20240131140700_change_email_to_citext.rb
pages_core-3.15.4	db/migrate/20240131140700_change_email_to_citext.rb
pages_core-3.15.3	db/migrate/20240131140700_change_email_to_citext.rb
pages_core-3.15.2	db/migrate/20240131140700_change_email_to_citext.rb
pages_core-3.15.1	db/migrate/20240131140700_change_email_to_citext.rb