summaryrefslogtreecommitdiff
path: root/db/migrate/20200131140428_create_index_on_auto_stop_in.rb
blob: 526e7dcfe3006f954b316344d129e1ed58655e8f (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
# 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