~cytrogen/masto-fe

ref: bb98d970e3f3333f85d454bc1fd26a1b582b14d2 masto-fe/db/migrate/20170322021028_add_lowercase_index_to_accounts.rb -rw-r--r-- 329 bytes
bb98d970 — Claire Merge pull request #2291 from ClearlyClaire/glitch-soc/merge-upstream 2 years ago
                                                                                
1
2
3
4
5
6
7
8
9
10
11
# frozen_string_literal: true

class AddLowercaseIndexToAccounts < ActiveRecord::Migration[5.0]
  def up
    execute 'CREATE INDEX index_accounts_on_username_and_domain_lower ON accounts (lower(username), lower(domain))'
  end

  def down
    remove_index :accounts, name: 'index_accounts_on_username_and_domain_lower'
  end
end