class AddIndex < ActiveRecord::Migration
  def self.up
    add_index :reports, [:date, :department, :name]
    add_index :reports, :date
    add_index :done_employees, [:report_id, :empl_id]
    add_index :done_materials, [:report_id, :employee_id]
    add_index :done_materials, [:date]
  end

  def self.down
  remove_index :reports, [:date, :department, :name]
    remove_index :reports, [:date]
    remove_index :done_employees, [:report_id, :empl_id]
    remove_index :done_materials, [:report_id, :employee_id]
    remove_index :done_materials, [:date]
  end
end