debian-mirror-gitlab/db/post_migrate/20230309103016_drop_id_partition_id_index_from_p_ci_build_metadata.rb
2023-05-27 22:25:52 +05:30

19 lines
507 B
Ruby

# frozen_string_literal: true
class DropIdPartitionIdIndexFromPCiBuildMetadata < Gitlab::Database::Migration[2.1]
include Gitlab::Database::PartitioningMigrationHelpers
disable_ddl_transaction!
TABLE_NAME = :p_ci_builds_metadata
INDEX_NAME = :p_ci_builds_metadata_id_partition_id_idx
def up
remove_concurrent_partitioned_index_by_name(TABLE_NAME, INDEX_NAME)
end
def down
add_concurrent_partitioned_index(TABLE_NAME, %i[id partition_id], unique: true, name: INDEX_NAME)
end
end