db/migrate/20170402231018_remove_index_for_users_current_sign_in_at.rb


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

# See http://doc.gitlab.com/ce/development/migration_style_guide.html
# for more information on how to write migrations for GitLab.

# rubocop:disable RemoveIndex
class RemoveIndexForUsersCurrentSignInAt < ActiveRecord::Migration
  include Gitlab::Database::MigrationHelpers

  # Set this constant to true if this migration requires downtime.
  DOWNTIME = false

  disable_ddl_transaction!

  def up
    if index_exists? :users, :current_sign_in_at
      if Gitlab::Database.postgresql?
        execute 'DROP INDEX CONCURRENTLY index_users_on_current_sign_in_at;'
      else
        remove_concurrent_index :users, :current_sign_in_at
      end
    end
  end

  def down
    add_concurrent_index :users, :current_sign_in_at
  end
end