debian-mirror-gitlab/db/migrate/20220413075921_update_index_on_packages_build_infos.rb
2022-06-21 17:19:12 +05:30

23 lines
764 B
Ruby

# frozen_string_literal: true
class UpdateIndexOnPackagesBuildInfos < Gitlab::Database::Migration[1.0]
disable_ddl_transaction!
NEW_INDEX_NAME = 'index_packages_build_infos_package_id_pipeline_id_id'
OLD_INDEX_NAME = 'index_packages_build_infos_package_id_pipeline_id'
def up
add_concurrent_index :packages_build_infos,
[:package_id, :pipeline_id, :id],
name: NEW_INDEX_NAME
remove_concurrent_index_by_name :packages_build_infos, OLD_INDEX_NAME
end
def down
add_concurrent_index :packages_build_infos,
[:package_id, :pipeline_id],
name: OLD_INDEX_NAME
remove_concurrent_index_by_name :packages_build_infos, NEW_INDEX_NAME
end
end