class SportDb::Market::CreateDb

Public Instance Methods

down() click to toggle source
# File lib/sportdb/market/schema.rb, line 46
def down
  raise ActiveRecord::IrreversibleMigration
end
up() click to toggle source
# File lib/sportdb/market/schema.rb, line 8
  def up

create_table :services do |t|  # quote service (e.g. tipp3,tipico,etc.)
  t.string     :title,  :null => false
  t.string     :key,    :null => false
  t.timestamps
end

create_table :quotes do |t|
  t.references :service, :null => false   # quote service (e.g. tipp3,tipico,etc.)
  t.references :game,    :null => false
  t.decimal    :odds1,   :null => false
  t.decimal    :oddsx,   :null => false
  t.decimal    :odds2,   :null => false
  t.string     :comments
  t.timestamps
end

create_table :event_quotes do |t|
  t.references  :service, :null => false   # quote service (e.g. tipp3,tipico,etc.)
  t.references  :event,   :null => false
  t.references  :team,    :null => false
  t.decimal     :odds,    :null => false   # winner odds (e.g. 3,5 or 90 etc.)
  t.string      :comments
  t.timestamps
end

create_table :group_quotes do |t|
  t.references  :service, :null => false   # quote service (e.g. tipp3,tipico,etc.)
  t.references  :group,   :null => false
  t.references  :team,    :null => false
  t.decimal     :odds,    :null => false   # winner odds (e.g. 3,5 or 90 etc.)
  t.string      :comments
  t.timestamps
end

  end