# 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 => 20080603035014) do
 
  create_table "avatars", :force => true do |t|
    t.integer  "parent_id"
    t.string   "content_type"
    t.string   "filename"
    t.string   "thumbnail"
    t.integer  "size"
    t.integer  "width"
    t.integer  "height"
    t.integer  "user_id"
    t.integer  "current_user_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end
 
  create_table "categories", :force => true do |t|
    t.string  "name"
    t.integer "position", :limit => 255, :default => 0
  end
 
  create_table "events", :force => true do |t|
    t.string   "title"
    t.text     "description"
    t.datetime "date"
    t.boolean  "reminder",    :default => false
    t.integer  "user_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end
 
  add_index "events", ["date"], :name => "index_events_on_date"
 
  create_table "forums", :force => true do |t|
    t.integer "category_id"
    t.string  "name"
    t.text    "description"
    t.integer "topics_count", :default => 0
    t.integer "posts_count",  :default => 0
    t.integer "position",     :default => 0
  end
 
  create_table "headers", :force => true do |t|
    t.integer  "parent_id"
    t.string   "content_type"
    t.string   "filename"
    t.string   "thumbnail"
    t.integer  "size"
    t.integer  "width"
    t.integer  "height"
    t.text     "description"
    t.integer  "user_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "votes",        :default => 0
  end
 
  create_table "logged_exceptions", :force => true do |t|
    t.string   "exception_class"
    t.string   "controller_name"
    t.string   "action_name"
    t.text     "message"
    t.text     "backtrace"
    t.text     "environment"
    t.text     "request"
    t.datetime "created_at"
  end
 
  create_table "messages", :force => true do |t|
    t.integer  "user_id"
    t.text     "body"
    t.datetime "created_at"
  end
 
  add_index "messages", ["created_at"], :name => "index_messages_on_created_at"
 
  create_table "posts", :force => true do |t|
    t.integer  "user_id"
    t.integer  "topic_id"
    t.text     "body"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "updated_by"
  end
 
  add_index "posts", ["user_id", "created_at"], :name => "index_posts_on_user_id"
  add_index "posts", ["topic_id", "created_at"], :name => "index_posts_on_topic_id_and_created_at"
 
  create_table "ranks", :force => true do |t|
    t.string  "title"
    t.integer "min_posts"
  end
 
  create_table "settings", :force => true do |t|
    t.string  "title"
    t.string  "tagline"
    t.text    "announcement"
    t.text    "footer"
    t.string  "theme"
    t.string  "favicon"
    t.string  "time_zone"
    t.boolean "private",       :default => false
    t.string  "login_message"
  end
 
  create_table "subscriptions", :force => true do |t|
    t.integer "user_id"
    t.integer "topic_id"
  end
 
  create_table "themes", :force => true do |t|
    t.integer  "parent_id"
    t.string   "content_type"
    t.string   "filename"
    t.string   "thumbnail"
    t.integer  "size"
    t.integer  "width"
    t.integer  "height"
    t.integer  "user_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end
 
  create_table "topics", :force => true do |t|
    t.integer  "user_id"
    t.string   "title"
    t.datetime "created_at"
    t.integer  "views",        :default => 0
    t.integer  "posts_count",  :default => 0
    t.integer  "last_post_id"
    t.datetime "last_post_at"
    t.integer  "last_post_by"
    t.boolean  "locked",       :default => false
    t.boolean  "sticky",       :default => false
    t.integer  "forum_id"
  end
 
  add_index "topics", ["forum_id", "last_post_at"], :name => "index_topics_on_forum_id_and_last_post_at"
  add_index "topics", ["forum_id", "sticky", "last_post_at"], :name => "index_topics_on_sticky_and_last_post_at"
 
  create_table "uploads", :force => true do |t|
    t.integer  "parent_id"
    t.string   "content_type"
    t.string   "filename"
    t.string   "thumbnail"
    t.integer  "size"
    t.integer  "width"
    t.integer  "height"
    t.integer  "user_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end
 
  create_table "users", :force => true do |t|
    t.string   "login"
    t.string   "email"
    t.string   "password_hash"
    t.datetime "created_at"
    t.boolean  "admin",              :default => false
    t.integer  "posts_count",        :default => 0
    t.string   "signature"
    t.text     "bio"
    t.datetime "profile_updated_at"
    t.datetime "online_at"
    t.string   "avatar"
    t.string   "auth_token"
    t.datetime "auth_token_exp"
    t.string   "time_zone"
    t.string   "ban_message"
    t.datetime "banned_until"
    t.datetime "chatting_at"
    t.boolean  "logged_out",         :default => false
  end
 
  add_index "users", ["chatting_at"], :name => "index_users_on_chatting_at"
 
end