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

16 lines
392 B
Ruby

# frozen_string_literal: true
class AddIndexForGroupActivityEvents < Gitlab::Database::Migration[2.1]
disable_ddl_transaction!
INDEX_NAME = 'index_events_for_group_activity'
def up
add_concurrent_index :events, %i[group_id target_type action id], name: INDEX_NAME, where: 'group_id IS NOT NULL'
end
def down
remove_concurrent_index_by_name :events, INDEX_NAME
end
end