zammad/db/migrate/20181123000000_issue_2368_add_indices_to_histories_and_tickets.rb

class Issue2368AddIndicesToHistoriesAndTickets < ActiveRecord::Migration[5.1]
  def up
    return if !Setting.find_by(name: 'system_init_done')

    add_index :histories, :related_o_id if !index_exists?(:histories, :related_o_id)
    add_index :histories, :related_history_object_id if !index_exists?(:histories, :related_history_object_id)
    add_index :histories, %i[o_id history_object_id related_o_id] if !index_exists?(:histories, %i[o_id history_object_id related_o_id])
    add_index :tickets, %i[group_id state_id] if !index_exists?(:tickets, %i[group_id state_id])
    add_index :tickets, %i[group_id state_id owner_id] if !index_exists?(:tickets, %i[group_id state_id owner_id])
  end
end