20170322021028_add_lowercase_index_to_accounts.rb 298 B

123456789
  1. class AddLowercaseIndexToAccounts < ActiveRecord::Migration[5.0]
  2. def up
  3. execute 'CREATE INDEX index_accounts_on_username_and_domain_lower ON accounts (lower(username), lower(domain))'
  4. end
  5. def down
  6. remove_index :accounts, name: 'index_accounts_on_username_and_domain_lower'
  7. end
  8. end