class CreateTrades < ActiveRecord::Migration
  def self.up
    create_table "trades", :force => true do |t|
      t.column "market_id", :integer
      t.column "user_id", :integer
      t.column "created_on", :datetime
      t.column "shares", :float
      t.column "cost", :float
    end

    add_index "trades", ["market_id"], :name => "market_id"
    add_index "trades", ["user_id"], :name => "user_id"
  end

  def self.down
    drop_table :trades
  end
end