class CreateResults < ActiveRecord::Migration
  def change
    create_table :results do |t|
      t.integer :event_id
      t.date :date
      t.string :venue
      t.string :event
      t.string :w_team
      t.string :l_team
      t.integer :w_points
      t.integer :l_points
      t.boolean :ot
      t.string :note
      t.integer :w_id
      t.integer :l_id
      t.integer :ot_id

      t.timestamps
    end
  end
end