# 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 => 49) do

  create_table "blacklists", :force => true do |t|
    t.column "list",       :text, :default => ""
    t.column "title_list", :text, :default => ""
  end

  create_table "forums", :force => true do |t|
    t.column "name",             :string
    t.column "description",      :string
    t.column "topics_count",     :integer, :default => 0
    t.column "posts_count",      :integer, :default => 0
    t.column "position",         :integer
    t.column "description_html", :text
  end

  create_table "logged_exceptions", :force => true do |t|
    t.column "exception_class", :string
    t.column "controller_name", :string
    t.column "action_name",     :string
    t.column "message",         :string
    t.column "backtrace",       :text
    t.column "environment",     :text
    t.column "request",         :text
    t.column "created_at",      :datetime
  end

  create_table "moderatorships", :force => true do |t|
    t.column "forum_id", :integer
    t.column "user_id",  :integer
  end

  add_index "moderatorships", ["forum_id"], :name => "index_moderatorships_on_forum_id"

  create_table "monitorships", :force => true do |t|
    t.column "topic_id", :integer
    t.column "user_id",  :integer
    t.column "active",   :boolean, :default => true
  end

  create_table "posts", :force => true do |t|
    t.column "user_id",    :integer
    t.column "topic_id",   :integer
    t.column "body",       :text
    t.column "created_at", :datetime
    t.column "updated_at", :datetime
    t.column "forum_id",   :integer
    t.column "body_html",  :text
  end

  add_index "posts", ["created_at", "forum_id"], :name => "index_posts_on_forum_id"
  add_index "posts", ["user_id", "created_at"], :name => "index_posts_on_user_id"

  create_table "sessions", :force => true do |t|
    t.column "session_id", :string
    t.column "data",       :text
    t.column "updated_at", :datetime
    t.column "user_id",    :integer
  end

  add_index "sessions", ["session_id"], :name => "index_sessions_on_session_id"

  create_table "topics", :force => true do |t|
    t.column "forum_id",     :integer
    t.column "user_id",      :integer
    t.column "title",        :string
    t.column "created_at",   :datetime
    t.column "updated_at",   :datetime
    t.column "hits",         :integer,  :default => 0
    t.column "posts_count",  :integer,  :default => 0
    t.column "replied_at",   :datetime
    t.column "sticky",       :integer,  :default => 0
    t.column "locked",       :boolean,  :default => false
    t.column "replied_by",   :integer
    t.column "last_post_id", :integer
  end

  add_index "topics", ["forum_id"], :name => "index_topics_on_forum_id"
  add_index "topics", ["forum_id", "replied_at", "sticky"], :name => "index_topics_on_sticky_and_replied_at"

  create_table "users", :force => true do |t|
    t.column "login",                :string
    t.column "email",                :string
    t.column "password_hash",        :string
    t.column "created_at",           :datetime
    t.column "last_login_at",        :datetime
    t.column "admin",                :boolean
    t.column "posts_count",          :integer,  :default => 0
    t.column "last_seen_at",         :datetime
    t.column "display_name",         :string
    t.column "updated_at",           :datetime
    t.column "website",              :string
    t.column "login_key",            :string
    t.column "login_key_expires_at", :datetime
    t.column "activated",            :boolean,  :default => false
    t.column "bio",                  :string
    t.column "bio_html",             :text
  end

  add_index "users", ["last_seen_at"], :name => "index_users_on_last_seen_at"

end