class CreateProject < ActiveRecord::Migration[5.0]
  def change
    create_table :match do |t|
      t.string  :local, null: false
      t.string  :visit, null: false
      t.date    :date, null: false
      t.integer :score_local
      t.integer :score_visit
      t.integer :result
      t.integer :pool_id, null: false
    end

    create_table :pool do |t|
      t.string    :name, null: false
      t.datetime  :editable_until, null: false
      t.boolean   :active
    end

    create_table :bet do |t|
      t.integer   :match_id, null: false
      t.integer   :user_id, null: false 
      t.integer   :score_local, null: false
      t.integer   :score_visit, null: false
      t.integer   :result
      t.integer   :points
    end
  end
end