diff options
Diffstat (limited to 'db/migrate/20200512195442_update_index_on_name_type_eq_ci_build_to_ci_builds.rb')
-rw-r--r-- | db/migrate/20200512195442_update_index_on_name_type_eq_ci_build_to_ci_builds.rb | 36 |
1 files changed, 0 insertions, 36 deletions
diff --git a/db/migrate/20200512195442_update_index_on_name_type_eq_ci_build_to_ci_builds.rb b/db/migrate/20200512195442_update_index_on_name_type_eq_ci_build_to_ci_builds.rb deleted file mode 100644 index f1334afb89d..00000000000 --- a/db/migrate/20200512195442_update_index_on_name_type_eq_ci_build_to_ci_builds.rb +++ /dev/null @@ -1,36 +0,0 @@ -# frozen_string_literal: true - -class UpdateIndexOnNameTypeEqCiBuildToCiBuilds < ActiveRecord::Migration[6.0] - include Gitlab::Database::MigrationHelpers - - DOWNTIME = false - disable_ddl_transaction! - - OLD_INDEX_NAME = 'index_ci_builds_on_name_and_security_type_eq_ci_build' - NEW_INDEX_NAME = 'index_security_ci_builds_on_name_and_id' - - OLD_CLAUSE = "((name)::text = ANY (ARRAY[('container_scanning'::character varying)::text, - ('dast'::character varying)::text, - ('dependency_scanning'::character varying)::text, - ('license_management'::character varying)::text, - ('sast'::character varying)::text, - ('license_scanning'::character varying)::text])) AND ((type)::text = 'Ci::Build'::text)" - - NEW_CLAUSE = "((name)::text = ANY (ARRAY[('container_scanning'::character varying)::text, - ('dast'::character varying)::text, - ('dependency_scanning'::character varying)::text, - ('license_management'::character varying)::text, - ('sast'::character varying)::text, - ('secret_detection'::character varying)::text, - ('license_scanning'::character varying)::text])) AND ((type)::text = 'Ci::Build'::text)" - - def up - add_concurrent_index :ci_builds, [:name, :id], name: NEW_INDEX_NAME, where: NEW_CLAUSE - remove_concurrent_index_by_name :ci_builds, OLD_INDEX_NAME - end - - def down - add_concurrent_index :ci_builds, [:name, :id], name: OLD_INDEX_NAME, where: OLD_CLAUSE - remove_concurrent_index_by_name :ci_builds, NEW_INDEX_NAME - end -end |