db/migrate/20200907195410_add_index_to_users_username.rb


1
2
3
4
5
6
7
8

class AddIndexToUsersUsername < ActiveRecord::Migration[5.2]
  disable_ddl_transaction!

  def change
    add_index :users, :username, unique: true, algorithm: :concurrently
    add_index :users, 'lower(username)', unique: true, algorithm: :concurrently, name: 'index_on_users_username_lowercase'
  end
end