20170918222253_reorganize_deployments_indexes.rb 904 Bytes
Newer Older
1 2 3
# See http://doc.gitlab.com/ce/development/migration_style_guide.html
# for more information on how to write migrations for GitLab.

4
class ReorganizeDeploymentsIndexes < ActiveRecord::Migration[4.2]
5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
  include Gitlab::Database::MigrationHelpers

  DOWNTIME = false

  disable_ddl_transaction!

  def up
    add_index_if_not_exists :deployments, [:environment_id, :iid, :project_id]
    remove_index_if_exists :deployments, [:project_id, :environment_id, :iid]
  end

  def down
    add_index_if_not_exists :deployments, [:project_id, :environment_id, :iid]
    remove_index_if_exists :deployments, [:environment_id, :iid, :project_id]
  end

  def add_index_if_not_exists(table, columns)
    add_concurrent_index(table, columns) unless index_exists?(table, columns)
  end

  def remove_index_if_exists(table, columns)
    remove_concurrent_index(table, columns) if index_exists?(table, columns)
  end
end