debian-mirror-gitlab/db/post_migrate/20220530082653_add_traversal_id_type_group_index.rb
2022-07-23 20:15:48 +02:00

16 lines
404 B
Ruby

# frozen_string_literal: true
class AddTraversalIdTypeGroupIndex < Gitlab::Database::Migration[2.0]
INDEX_NAME = 'index_namespaces_on_traversal_ids_for_groups_btree'
disable_ddl_transaction!
def up
add_concurrent_index :namespaces, :traversal_ids, using: :btree, where: "type='Group'", name: INDEX_NAME
end
def down
remove_concurrent_index_by_name :namespaces, INDEX_NAME
end
end