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

  create_table "answers", :force => true do |t|
    t.text     "content",     :default => "",    :null => false
    t.boolean  "approved",    :default => false
    t.boolean  "reference",   :default => false
    t.string   "feedback",    :default => ""
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "question_id",                    :null => false
    t.integer  "owner_id"
    t.boolean  "correct"
    t.string   "type"
  end

  add_index "answers", ["owner_id"], :name => "index_answers_on_owner_id"
  add_index "answers", ["question_id"], :name => "index_answers_on_question_id"
  add_index "answers", ["type"], :name => "index_answers_on_type"

  create_table "categories", :force => true do |t|
    t.string   "name",       :null => false
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "comments", :force => true do |t|
    t.text     "content",    :null => false
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "answer_id",  :null => false
    t.integer  "owner_id"
  end

  add_index "comments", ["answer_id"], :name => "index_comments_on_answer_id"
  add_index "comments", ["owner_id"], :name => "index_comments_on_owner_id"

  create_table "delayed_jobs", :force => true do |t|
    t.integer  "priority",   :default => 0
    t.integer  "attempts",   :default => 0
    t.text     "handler"
    t.string   "last_error"
    t.datetime "run_at"
    t.datetime "locked_at"
    t.datetime "failed_at"
    t.string   "locked_by"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "options", :force => true do |t|
    t.string   "content",           :null => false
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "option_owner_id",   :null => false
    t.string   "option_owner_type", :null => false
  end

  add_index "options", ["option_owner_type", "option_owner_id"], :name => "index_options_on_option_owner_type_and_option_owner_id"

  create_table "project_acceptances", :force => true do |t|
    t.string   "accepting_nick",                    :null => false
    t.boolean  "accepted",       :default => false
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "user_id",                           :null => false
  end

  add_index "project_acceptances", ["user_id"], :name => "index_project_acceptances_on_user_id"

  create_table "question_categories", :force => true do |t|
    t.integer "question_id", :null => false
    t.integer "category_id", :null => false
  end

  add_index "question_categories", ["question_id", "category_id"], :name => "index_question_categories_on_question_id_and_category_id", :unique => true

  create_table "question_content_emails", :force => true do |t|
    t.text     "requirements", :default => "", :null => false
    t.text     "description"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "question_id",                  :null => false
  end

  add_index "question_content_emails", ["question_id"], :name => "index_question_content_emails_on_question_id"

  create_table "question_content_multiple_choices", :force => true do |t|
    t.text     "content",     :null => false
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "question_id", :null => false
  end

  add_index "question_content_multiple_choices", ["question_id"], :name => "index_question_content_multiple_choices_on_question_id"

  create_table "question_content_texts", :force => true do |t|
    t.text     "content",     :null => false
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "question_id", :null => false
  end

  add_index "question_content_texts", ["question_id"], :name => "index_question_content_texts_on_question_id"

  create_table "question_groups", :force => true do |t|
    t.string   "name",        :null => false
    t.text     "description", :null => false
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "questions", :force => true do |t|
    t.string   "title",                                :null => false
    t.string   "documentation"
    t.boolean  "approved",          :default => false
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "user_id"
    t.integer  "question_group_id"
  end

  add_index "questions", ["question_group_id"], :name => "index_questions_on_question_group_id"
  add_index "questions", ["user_id"], :name => "index_questions_on_user_id"

  create_table "user_categories", :force => true do |t|
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "user_id",     :null => false
    t.integer  "category_id", :null => false
  end

  add_index "user_categories", ["category_id"], :name => "index_user_categories_on_category_id"
  add_index "user_categories", ["user_id"], :name => "index_user_categories_on_user_id"

  create_table "user_question_groups", :force => true do |t|
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "user_id",     :null => false
    t.integer  "question_id", :null => false
  end

  add_index "user_question_groups", ["question_id"], :name => "index_user_question_groups_on_question_id"
  add_index "user_question_groups", ["user_id"], :name => "index_user_question_groups_on_user_id"

  create_table "users", :force => true do |t|
    t.string   "crypted_password",          :limit => 40
    t.string   "salt",                      :limit => 40
    t.string   "remember_token"
    t.datetime "remember_token_expires_at"
    t.string   "name"
    t.string   "email_address"
    t.boolean  "administrator",                           :default => false
    t.string   "role",                                    :default => "recruit"
    t.string   "nick"
    t.string   "openid"
    t.text     "contributions"
    t.boolean  "project_lead",                            :default => false
    t.string   "token"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "mentor_id"
    t.string   "state",                                   :default => "active"
    t.datetime "key_timestamp"
  end

  add_index "users", ["mentor_id"], :name => "index_users_on_mentor_id"
  add_index "users", ["state"], :name => "index_users_on_state"

end