# This file is auto-generated from the current state of the database. Instead of editing this file, 
# please use the migrations feature of Active Record to incrementally modify your database, and
# then regenerate this schema definition.
#
# Note that this schema.rb definition is the authoritative source for your database schema. If you need
# to create the application database on another system, you should be using db:schema:load, not running
# all the migrations from scratch. The latter is a flawed and unsustainable approach (the more migrations
# you'll amass, the slower it'll run and the greater likelihood for issues).
#
# It's strongly recommended to check this file into your version control system.

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

  create_table "eventable_categories_events", :force => true do |t|
    t.integer "event_id"
    t.integer "category_id"
  end

  add_index "eventable_categories_events", ["category_id"], :name => "index_eventable_categories_events_on_category_id"
  add_index "eventable_categories_events", ["event_id"], :name => "index_eventable_categories_events_on_event_id"

  create_table "eventable_opening_periods", :force => true do |t|
    t.integer  "event_id"
    t.datetime "start_at"
    t.datetime "end_at"
  end

  add_index "eventable_opening_periods", ["event_id"], :name => "index_eventable_opening_periods_on_event_id"
  add_index "eventable_opening_periods", ["start_at", "end_at"], :name => "index_eventable_opening_periods_on_start_at_and_end_at"

  create_table "eventable_opening_times", :force => true do |t|
    t.integer  "period_id"
    t.integer  "day_of_week"
    t.datetime "minutes_start"
    t.datetime "minutes_end"
  end

  add_index "eventable_opening_times", ["period_id", "day_of_week"], :name => "index_eventable_opening_times_on_period_id_and_day_of_week"

  create_table "eventable_prices", :force => true do |t|
    t.integer "event_id"
    t.text    "text"
    t.decimal "price",    :precision => 6, :scale => 2
  end

  add_index "eventable_prices", ["event_id"], :name => "index_eventable_prices_on_event_id"

  create_table "eventable_program_items", :force => true do |t|
    t.integer  "event_id"
    t.integer  "user_id"
    t.datetime "start_at"
    t.datetime "end_at"
  end

  add_index "eventable_program_items", ["event_id"], :name => "index_eventable_program_items_on_event_id"
  add_index "eventable_program_items", ["user_id"], :name => "index_eventable_program_items_on_user_id"

  create_table "eventable_reviews", :force => true do |t|
    t.integer "program_item_id"
    t.float   "review"
    t.text    "text"
  end

  add_index "eventable_reviews", ["program_item_id"], :name => "index_eventable_reviews_on_program_item_id"

  create_table "events", :force => true do |t|
    t.string "name"
    t.text   "description"
  end

end