class AddColumnsToReports < ActiveRecord::Migration
  def self.up
    add_column :reports, :disp_wage,    :decimal, :precision => 10, :scale => 2
    add_column :reports, :bonus_manager,    :decimal, :precision => 10, :scale => 2
    add_column :reports, :manager_id,    :integer
    add_column :reports, :bonus_sale,    :decimal, :precision => 10, :scale => 2
    add_column :reports, :clearing,    :boolean
  end

  def self.down
    remove_column :reports, :disp_wage
    remove_column :reports, :bonus_manager
    remove_column :reports, :manager_id
    remove_column :reports, :bonus_sale
    remove_column :reports, :clearing
  end
end