debian-mirror-gitlab/db/post_migrate/20230110172751_add_partial_index_on_group_path_id.rb
2023-03-17 16:20:25 +05:30

16 lines
365 B
Ruby

# frozen_string_literal: true
class AddPartialIndexOnGroupPathId < Gitlab::Database::Migration[2.1]
disable_ddl_transaction!
INDEX_NAME = :index_groups_on_path_and_id
def up
add_concurrent_index :namespaces, [:path, :id], where: "type = 'Group'", name: INDEX_NAME
end
def down
remove_concurrent_index_by_name :namespaces, INDEX_NAME
end
end