# 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 => 20081015154949) do create_table "accounts", :force => true do |t| t.string "login" t.string "email" t.string "crypted_password", :limit => 40 t.string "salt", :limit => 40 t.datetime "created_at" t.datetime "updated_at" t.string "remember_token" t.datetime "remember_token_expires_at" t.string "activation_code", :limit => 40 t.datetime "activated_at" t.string "state", :default => "passive" t.datetime "deleted_at" end create_table "announcements", :force => true do |t| t.string "title" t.text "body" t.datetime "created_at" t.datetime "updated_at" t.datetime "display_until" t.boolean "is_active", :default => true t.integer "location_id" end create_table "categories", :force => true do |t| t.string "name" t.datetime "created_at" t.datetime "updated_at" end create_table "comments", :force => true do |t| t.integer "post_id" t.text "body" t.integer "user_id" t.string "status" t.datetime "created_at" t.datetime "updated_at" end create_table "flatpages", :force => true do |t| t.string "title" t.string "url" t.text "body" t.boolean "is_active", :default => true t.datetime "created_at" t.datetime "updated_at" t.string "template" end create_table "locations", :force => true do |t| t.string "name" t.boolean "is_active", :default => true t.datetime "created_at" t.datetime "updated_at" t.string "address1" t.string "address2" t.string "city" t.string "state_province" t.string "postal_code" t.string "country" t.string "phone" t.string "email" t.float "lat" t.float "lng" t.string "jackrabbit_id" t.text "about_text" t.text "analytics_code" t.text "birthday_text" end create_table "locations_programs", :force => true do |t| t.integer "location_id" t.integer "program_id" end create_table "locations_users", :id => false, :force => true do |t| t.integer "location_id" t.integer "user_id" end create_table "post_versions", :force => true do |t| t.integer "post_id" t.integer "version" t.string "title" t.text "body" t.string "status" t.datetime "updated_at" t.boolean "allow_comments" t.string "permalink" end create_table "posts", :force => true do |t| t.string "title" t.text "body" t.string "status" t.datetime "created_at" t.datetime "updated_at" t.boolean "allow_comments" t.integer "version" t.string "permalink" end create_table "programs", :force => true do |t| t.string "name" t.text "description" t.decimal "starting_age_years", :precision => 4, :scale => 2 t.decimal "starting_age_months", :precision => 4, :scale => 2 t.decimal "ending_age_years", :precision => 4, :scale => 2 t.decimal "ending_age_months", :precision => 4, :scale => 2 t.string "program_type" t.boolean "is_active", :default => true t.datetime "created_at" t.datetime "updated_at" end create_table "resources", :force => true do |t| t.integer "parent_id" t.integer "size" t.integer "width" t.integer "height" t.string "content_type" t.string "filename" t.string "thumbnail" t.datetime "created_at" t.datetime "updated_at" t.integer "category_id" t.string "name" end create_table "schedules", :force => true do |t| t.integer "program_id" t.integer "session_id" t.string "day" t.time "start_time" t.time "end_time" t.datetime "created_at" t.datetime "updated_at" end create_table "sessions", :force => true do |t| t.string "name" t.integer "location_id" t.date "start_date" t.date "end_date" t.boolean "is_active", :default => true t.datetime "created_at" t.datetime "updated_at" t.string "jackrabbit_session_name" end create_table "users", :force => true do |t| t.string "login", :limit => 40 t.string "name", :limit => 100, :default => "" t.string "email", :limit => 100 t.string "access" t.boolean "is_active" t.string "crypted_password", :limit => 40 t.string "salt", :limit => 40 t.datetime "created_at" t.datetime "updated_at" t.string "remember_token", :limit => 40 t.datetime "remember_token_expires_at" end add_index "users", ["login"], :name => "index_users_on_login", :unique => true end