diff options
Diffstat (limited to 'db/migrate/20190222051615_add_indexes_for_merge_request_diffs_query.rb')
-rw-r--r-- | db/migrate/20190222051615_add_indexes_for_merge_request_diffs_query.rb | 42 |
1 files changed, 0 insertions, 42 deletions
diff --git a/db/migrate/20190222051615_add_indexes_for_merge_request_diffs_query.rb b/db/migrate/20190222051615_add_indexes_for_merge_request_diffs_query.rb deleted file mode 100644 index bf7f7b44dec..00000000000 --- a/db/migrate/20190222051615_add_indexes_for_merge_request_diffs_query.rb +++ /dev/null @@ -1,42 +0,0 @@ -# frozen_string_literal: true - -class AddIndexesForMergeRequestDiffsQuery < ActiveRecord::Migration[5.0] - include Gitlab::Database::MigrationHelpers - - DOWNTIME = false - - INDEX_SPECS = [ - [ - :merge_request_metrics, - :latest_closed_at, - { where: 'latest_closed_at IS NOT NULL' } - ], - [ - :merge_request_metrics, - [:merge_request_id, :merged_at], - { where: 'merged_at IS NOT NULL' } - ], - [ - :merge_request_diffs, - [:merge_request_id, :id], - { - name: 'index_merge_request_diffs_on_merge_request_id_and_id_partial', - where: 'NOT stored_externally OR stored_externally IS NULL' - } - ] - ].freeze - - disable_ddl_transaction! - - def up - INDEX_SPECS.each do |spec| - add_concurrent_index(*spec) - end - end - - def down - INDEX_SPECS.reverse_each do |spec| - remove_concurrent_index(*spec) - end - end -end |