# -*- coding: utf-8 -*-
class AddPriceFromStoreToDoneMaterials < ActiveRecord::Migration
  def self.up
    add_column :done_materials, :price_from_store, :decimal
    ActiveRecord::Base.connection.execute("UPDATE done_materials dm SET dm.price_from_store = dm.bonus_sale WHERE department='private' AND bonus_sale > 0 ")
    ActiveRecord::Base.connection.execute("UPDATE done_materials dm SET dm.bonus_sale = '' WHERE department='private' AND bonus_sale > 0 ")
  end

  def self.down
    remove_column :done_materials, :price_from_store
  end
end