20200131140428_create_index_on_auto_stop_in.rb

# frozen_string_literal: true

class CreateIndexOnAutoStopIn < ActiveRecord::Migration[6.0]
  include Gitlab::Database::MigrationHelpers

  DOWNTIME = false

  disable_ddl_transaction!

  def up
    add_concurrent_index :environments, %i[state auto_stop_at], where: "auto_stop_at IS NOT NULL AND state = 'available'"
  end

  def down
    remove_concurrent_index :environments, %i[state auto_stop_at]
  end
end