diff options
Diffstat (limited to 'db/migrate/20220824082427_remove_tmp_idx_vulnerability_occurrences_on_id_and_scanner_id.rb')
| -rw-r--r-- | db/migrate/20220824082427_remove_tmp_idx_vulnerability_occurrences_on_id_and_scanner_id.rb | 20 |
1 files changed, 0 insertions, 20 deletions
diff --git a/db/migrate/20220824082427_remove_tmp_idx_vulnerability_occurrences_on_id_and_scanner_id.rb b/db/migrate/20220824082427_remove_tmp_idx_vulnerability_occurrences_on_id_and_scanner_id.rb deleted file mode 100644 index ebb90df569b..00000000000 --- a/db/migrate/20220824082427_remove_tmp_idx_vulnerability_occurrences_on_id_and_scanner_id.rb +++ /dev/null @@ -1,20 +0,0 @@ -# frozen_string_literal: true - -class RemoveTmpIdxVulnerabilityOccurrencesOnIdAndScannerId < Gitlab::Database::Migration[2.0] - INDEX_NAME = 'tmp_index_vulnerability_occurrences_on_id_and_scanner_id' - REPORT_TYPES = { cluster_image_scanning: 7, generic: 99 }.freeze - CLAUSE = "report_type IN (#{REPORT_TYPES.values.join(',')})" - - disable_ddl_transaction! - - def up - remove_concurrent_index_by_name :vulnerability_occurrences, INDEX_NAME - end - - def down - add_concurrent_index :vulnerability_occurrences, - [:id, :scanner_id], - where: CLAUSE, - name: INDEX_NAME - end -end |