20081205134756_add_product_fields.rb

class AddProductFields < ActiveRecord::Migration
  def self.up
    add_column :products, :cline_price, :decimal, :precision => 8, :scale => 2
    add_column :products, :cost, :decimal, :precision => 8, :scale => 2
    add_column :products, :manufacturers_sku, :string
    add_column :products, :code, :string
    
    add_column :variants, :cline_price, :decimal, :precision => 8, :scale => 2
    add_column :variants, :cost, :decimal, :precision => 8, :scale => 2
    add_column :variants, :manufacturers_sku, :string
    add_column :variants, :code, :string
  end

  def self.down
    remove_column :products, :cline_price
    remove_column :products, :cost
    remove_column :products, :manufacturers_sku
    remove_column :products, :code
    
    remove_column :variants, :cline_price
    remove_column :variants, :cost
    remove_column :variants, :manufacturers_sku
    remove_column :variants, :code
  end
end