diff options
Diffstat (limited to 'db/post_migrate/20230104220137_reindex_vuln_reads_on_default_branch_with_common_query.rb')
-rw-r--r-- | db/post_migrate/20230104220137_reindex_vuln_reads_on_default_branch_with_common_query.rb | 26 |
1 files changed, 0 insertions, 26 deletions
diff --git a/db/post_migrate/20230104220137_reindex_vuln_reads_on_default_branch_with_common_query.rb b/db/post_migrate/20230104220137_reindex_vuln_reads_on_default_branch_with_common_query.rb deleted file mode 100644 index 114a1a84fa0..00000000000 --- a/db/post_migrate/20230104220137_reindex_vuln_reads_on_default_branch_with_common_query.rb +++ /dev/null @@ -1,26 +0,0 @@ -# frozen_string_literal: true - -class ReindexVulnReadsOnDefaultBranchWithCommonQuery < Gitlab::Database::Migration[2.1] - INDEX_NAME = 'index_vuln_reads_common_query_on_resolved_on_default_branch' - - COLUMNS = %i[project_id state report_type vulnerability_id] - - disable_ddl_transaction! - - def up - add_concurrent_index( - :vulnerability_reads, - COLUMNS, - name: INDEX_NAME, - where: 'resolved_on_default_branch IS TRUE', - order: { vulnerability_id: :desc } - ) - end - - def down - remove_concurrent_index_by_name( - :vulnerability_reads, - INDEX_NAME - ) - end -end |