# This file is autogenerated. Instead of editing this file, please use the
# migrations feature of ActiveRecord to incrementally modify your database, and
# then regenerate this schema definition.

ActiveRecord::Schema.define(:version => 4) do

  create_table "challenges", :force => true do |t|
    t.column "description", :text
    t.column "created_at",  :datetime
    t.column "updated_at",  :datetime
    t.column "finishes_at", :datetime
    t.column "store",       :string
    t.column "user_id",     :integer
  end

  add_index "challenges", ["user_id"], :name => "index_challenges_on_user_id"

  create_table "entries", :force => true do |t|
    t.column "title",           :string
    t.column "artist",          :string
    t.column "album",           :string
    t.column "url",             :string
    t.column "preview_url",     :string
    t.column "small_image_url", :string
    t.column "large_image_url", :string
    t.column "user_id",         :integer
    t.column "challenge_id",    :integer
    t.column "created_at",      :datetime
    t.column "updated_at",      :datetime
  end

  add_index "entries", ["user_id"], :name => "index_entries_on_user_id"
  add_index "entries", ["challenge_id"], :name => "index_entries_on_challenge_id"

  create_table "users", :force => true do |t|
    t.column "name",        :string
    t.column "facebook_id", :string
    t.column "created_at",  :datetime
    t.column "updated_at",  :datetime
  end

  create_table "winning_choices", :force => true do |t|
    t.column "challenge_id", :integer
    t.column "entry_id",     :integer
    t.column "comment",      :text
    t.column "created_at",   :datetime
    t.column "updated_at",   :datetime
  end

  add_index "winning_choices", ["challenge_id"], :name => "index_winning_choices_on_challenge_id"
  add_index "winning_choices", ["entry_id"], :name => "index_winning_choices_on_entry_id"

end