blob: cf90e88f8cdfdecb0d9e52e6a976cc5c9435aa5a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
# frozen_string_literal: true
class AddIndexCustomEmailVerificationsOnTriggeredAtAndStateStarted < Gitlab::Database::Migration[2.1]
disable_ddl_transaction!
INDEX_NAME = 'i_custom_email_verifications_on_triggered_at_and_state_started'
def up
add_concurrent_index :service_desk_custom_email_verifications, :triggered_at,
where: 'state = 0',
name: INDEX_NAME
end
def down
remove_concurrent_index_by_name :service_desk_custom_email_verifications, INDEX_NAME
end
end
|