class AddIndexesForIssues < ActiveRecord::Migration
	def self.up
    add_index :issues, :user_id
    add_index :issues, [:reportable_id, :reportable_type]
    add_index :reports, :issue_id
    add_index :reports, :user_id
  	add_index :issue_comments, :user_id
  	add_index :issue_comments, :issue_id
  end

  def self.down
    remove_index :issues, :user_id
    remove_index :issues, [:reportable_id, :reportable_type]
    remove_index :reports, :issue_id
    remove_index :reports, :user_id
  	remove_index :issue_comments, :user_id
  	remove_index :issue_comments, :issue_id
  end
end