diff options
Diffstat (limited to 'db/post_migrate/20221121181627_drop_index_on_vulnerabilities_state_case_id_desc.rb')
-rw-r--r-- | db/post_migrate/20221121181627_drop_index_on_vulnerabilities_state_case_id_desc.rb | 20 |
1 files changed, 0 insertions, 20 deletions
diff --git a/db/post_migrate/20221121181627_drop_index_on_vulnerabilities_state_case_id_desc.rb b/db/post_migrate/20221121181627_drop_index_on_vulnerabilities_state_case_id_desc.rb deleted file mode 100644 index 712343bc7b0..00000000000 --- a/db/post_migrate/20221121181627_drop_index_on_vulnerabilities_state_case_id_desc.rb +++ /dev/null @@ -1,20 +0,0 @@ -# frozen_string_literal: true - -class DropIndexOnVulnerabilitiesStateCaseIdDesc < Gitlab::Database::Migration[2.0] - INDEX_NAME = "index_vulnerabilities_on_state_case_id_desc" - disable_ddl_transaction! - - def up - remove_concurrent_index_by_name( - :vulnerabilities, - INDEX_NAME - ) - end - - def down - execute <<~SQL - CREATE INDEX CONCURRENTLY index_vulnerabilities_on_state_case_id_desc ON vulnerabilities - USING btree (array_position(ARRAY[(1)::smallint, (4)::smallint, (3)::smallint, (2)::smallint], state) DESC, id DESC); - SQL - end -end |