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

16 lines
451 B
Ruby

# frozen_string_literal: true
class AddUserIdAndSourceIdAndSourceTypeAndMemberRoleIdIndexToMembers < Gitlab::Database::Migration[2.1]
disable_ddl_transaction!
INDEX_NAME = 'idx_members_on_user_and_source_and_source_type_and_member_role'
def up
add_concurrent_index :members, [:user_id, :source_id, :source_type, :member_role_id], name: INDEX_NAME
end
def down
remove_concurrent_index_by_name :members, name: INDEX_NAME
end
end