blob: 619fd326d7a7787a4dd7119f42bc5a917c6022b4 (
plain)
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
27
28
29
|
# frozen_string_literal: true
class RemoveUnusedMergeRequestJiraIndexes < Gitlab::Database::Migration[2.1]
TITLE_INDEX = {
name: 'index_merge_requests_on_target_project_id_and_iid_jira_title',
where: "((title)::text ~ '[A-Z][A-Z_0-9]+-\d+'::text)"
}.freeze
DESCRIPTION_INDEX = {
name: 'index_merge_requests_on_target_project_id_iid_jira_description',
where: "(description ~ '[A-Z][A-Z_0-9]+-\d+'::text)"
}.freeze
disable_ddl_transaction!
def up
remove_concurrent_index_by_name :merge_requests, name: TITLE_INDEX[:name]
remove_concurrent_index_by_name :merge_requests, name: DESCRIPTION_INDEX[:name]
end
def down
add_concurrent_index :merge_requests, [:target_project_id, :iid],
where: TITLE_INDEX[:where],
name: TITLE_INDEX[:name]
add_concurrent_index :merge_requests, [:target_project_id, :iid],
where: DESCRIPTION_INDEX[:where],
name: DESCRIPTION_INDEX[:name]
end
end
|