# encoding: UTF-8
# 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 that you check this file into your version control system.

ActiveRecord::Schema.define(version: 20150420024128) do

  # These are extensions that must be enabled in order to support this database
  enable_extension "plpgsql"

  create_table "agent_steps", force: true do |t|
    t.integer  "mission_agent_id"
    t.integer  "step"
    t.string   "title"
    t.text     "description"
    t.boolean  "completed"
    t.datetime "completed_date"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "step_submissions_id"
    t.integer  "step_validations_id"
    t.integer  "position"
  end

  add_index "agent_steps", ["mission_agent_id"], name: "index_agent_steps_on_mission_agent_id", using: :btree
  add_index "agent_steps", ["step_submissions_id"], name: "index_agent_steps_on_step_submissions_id", using: :btree
  add_index "agent_steps", ["step_validations_id"], name: "index_agent_steps_on_step_validations_id", using: :btree

  create_table "blog_posts", force: true do |t|
    t.string   "title"
    t.string   "slug"
    t.text     "content"
    t.boolean  "published"
    t.integer  "author_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "description"
    t.string   "image"
    t.string   "image_tmp"
    t.boolean  "image_processing", default: false, null: false
  end

  add_index "blog_posts", ["author_id"], name: "index_blog_posts_on_author_id", using: :btree
  add_index "blog_posts", ["slug"], name: "index_blog_posts_on_slug", unique: true, using: :btree

  create_table "contact_messages", force: true do |t|
    t.string   "title"
    t.string   "email"
    t.text     "content"
    t.boolean  "unread"
    t.integer  "user_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "contact_messages", ["user_id"], name: "index_contact_messages_on_user_id", using: :btree

  create_table "friendly_id_slugs", force: true do |t|
    t.string   "slug",                      null: false
    t.integer  "sluggable_id",              null: false
    t.string   "sluggable_type", limit: 50
    t.string   "scope"
    t.datetime "created_at"
  end

  add_index "friendly_id_slugs", ["slug", "sluggable_type", "scope"], name: "index_friendly_id_slugs_on_slug_and_sluggable_type_and_scope", unique: true, using: :btree
  add_index "friendly_id_slugs", ["slug", "sluggable_type"], name: "index_friendly_id_slugs_on_slug_and_sluggable_type", using: :btree
  add_index "friendly_id_slugs", ["sluggable_id"], name: "index_friendly_id_slugs_on_sluggable_id", using: :btree
  add_index "friendly_id_slugs", ["sluggable_type"], name: "index_friendly_id_slugs_on_sluggable_type", using: :btree

  create_table "infos", force: true do |t|
    t.string   "website_name"
    t.string   "tagline"
    t.string   "logo"
    t.string   "contact_email"
    t.string   "default_language"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.boolean  "maintenance_mode"
    t.string   "maintenance_title"
    t.text     "maintenance_message"
    t.string   "website_link"
    t.string   "server_email"
    t.boolean  "open_for_signup"
    t.boolean  "open_for_invites"
    t.boolean  "open_for_public"
  end

  create_table "invites", force: true do |t|
    t.string   "email"
    t.text     "message"
    t.integer  "user_id"
    t.boolean  "invited"
    t.string   "invitations_sent"
    t.datetime "last_invitation_sent_date"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "token"
    t.integer  "new_user_id"
  end

  add_index "invites", ["user_id"], name: "index_invites_on_user_id", using: :btree

  create_table "mission_agents", force: true do |t|
    t.integer  "mission_id"
    t.integer  "agent_steps_id"
    t.integer  "mission_candidates_id"
    t.string   "objective"
    t.text     "briefing"
    t.string   "role"
    t.text     "description"
    t.integer  "user_id"
    t.integer  "agent_number"
    t.text     "debriefing"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "slug"
    t.integer  "rewards_id"
  end

  add_index "mission_agents", ["agent_steps_id"], name: "index_mission_agents_on_agent_steps_id", using: :btree
  add_index "mission_agents", ["mission_candidates_id"], name: "index_mission_agents_on_mission_candidates_id", using: :btree
  add_index "mission_agents", ["mission_id"], name: "index_mission_agents_on_mission_id", using: :btree
  add_index "mission_agents", ["rewards_id"], name: "index_mission_agents_on_rewards_id", using: :btree
  add_index "mission_agents", ["user_id"], name: "index_mission_agents_on_user_id", using: :btree

  create_table "mission_agents_rewards", id: false, force: true do |t|
    t.integer "mission_agent_id"
    t.integer "reward_id"
  end

  add_index "mission_agents_rewards", ["mission_agent_id"], name: "index_mission_agents_rewards_on_mission_agent_id", using: :btree
  add_index "mission_agents_rewards", ["reward_id"], name: "index_mission_agents_rewards_on_reward_id", using: :btree

  create_table "mission_candidates", force: true do |t|
    t.integer  "user_id"
    t.integer  "mission_agent_id"
    t.integer  "status"
    t.string   "mode"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "mission_candidates", ["mission_agent_id"], name: "index_mission_candidates_on_mission_agent_id", using: :btree
  add_index "mission_candidates", ["user_id"], name: "index_mission_candidates_on_user_id", using: :btree

  create_table "missions", force: true do |t|
    t.integer  "mission_agents_id"
    t.string   "title"
    t.string   "objective"
    t.text     "briefing"
    t.integer  "owner_id"
    t.integer  "status",            default: 1
    t.boolean  "launched"
    t.string   "language"
    t.string   "cover_img"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "slug"
    t.datetime "end_date"
    t.integer  "rewards_id"
    t.string   "duration_scale"
    t.integer  "duration_number"
    t.datetime "launch_date"
    t.string   "video"
  end

  add_index "missions", ["mission_agents_id"], name: "index_missions_on_mission_agents_id", using: :btree
  add_index "missions", ["owner_id"], name: "index_missions_on_owner_id", using: :btree
  add_index "missions", ["rewards_id"], name: "index_missions_on_rewards_id", using: :btree

  create_table "rewards", force: true do |t|
    t.integer  "mission_id"
    t.integer  "mission_agents_id"
    t.string   "title"
    t.text     "description"
    t.string   "img"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "rewards", ["mission_agents_id"], name: "index_rewards_on_mission_agents_id", using: :btree
  add_index "rewards", ["mission_id"], name: "index_rewards_on_mission_id", using: :btree

  create_table "step_submissions", force: true do |t|
    t.integer  "agent_step_id"
    t.integer  "submission_contents_id"
    t.boolean  "validated"
    t.integer  "validated_by_id"
    t.datetime "date_validated"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "step_submissions", ["agent_step_id"], name: "index_step_submissions_on_agent_step_id", using: :btree
  add_index "step_submissions", ["submission_contents_id"], name: "index_step_submissions_on_submission_contents_id", using: :btree
  add_index "step_submissions", ["validated_by_id"], name: "index_step_submissions_on_validated_by_id", using: :btree

  create_table "step_validations", force: true do |t|
    t.integer  "agent_step_id"
    t.integer  "validation_id"
    t.string   "validation_type"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "step_validations", ["agent_step_id"], name: "index_step_validations_on_agent_step_id", using: :btree

  create_table "submission_contents", force: true do |t|
    t.integer  "submission_id"
    t.string   "submission_type"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "step_submission_id"
  end

  add_index "submission_contents", ["step_submission_id"], name: "index_submission_contents_on_step_submission_id", using: :btree

  create_table "submission_texts", force: true do |t|
    t.integer  "submission_content_id"
    t.string   "content"
    t.boolean  "accepted"
    t.integer  "validation_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "submission_texts", ["submission_content_id"], name: "index_submission_texts_on_submission_content_id", using: :btree
  add_index "submission_texts", ["validation_id"], name: "index_submission_texts_on_validation_id", using: :btree

  create_table "subscriptions", force: true do |t|
    t.string   "first_name"
    t.string   "last_name"
    t.string   "email"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "language"
    t.boolean  "registered_user"
  end

  create_table "uploads", force: true do |t|
    t.string   "title"
    t.string   "file"
    t.text     "description"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "file_tmp"
    t.boolean  "file_processing", default: false, null: false
  end

  create_table "user_rewards", force: true do |t|
    t.integer  "reward_id"
    t.integer  "user_id"
    t.boolean  "received"
    t.datetime "date_received"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "user_rewards", ["reward_id"], name: "index_user_rewards_on_reward_id", using: :btree
  add_index "user_rewards", ["user_id"], name: "index_user_rewards_on_user_id", using: :btree

  create_table "users", force: true do |t|
    t.string   "email",                  default: "",    null: false
    t.string   "encrypted_password",     default: ""
    t.string   "reset_password_token"
    t.datetime "reset_password_sent_at"
    t.datetime "remember_created_at"
    t.integer  "sign_in_count",          default: 0,     null: false
    t.datetime "current_sign_in_at"
    t.datetime "last_sign_in_at"
    t.string   "current_sign_in_ip"
    t.string   "last_sign_in_ip"
    t.string   "first_name"
    t.string   "last_name"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.boolean  "admin"
    t.string   "avatar"
    t.string   "avatar_tmp"
    t.boolean  "avatar_processing",      default: false, null: false
    t.string   "bio"
    t.string   "language"
    t.string   "invitation_token"
    t.datetime "invitation_created_at"
    t.datetime "invitation_sent_at"
    t.datetime "invitation_accepted_at"
    t.integer  "invitation_limit"
    t.integer  "invited_by_id"
    t.string   "invited_by_type"
    t.integer  "invitations_count",      default: 0
  end

  add_index "users", ["email"], name: "index_users_on_email", unique: true, using: :btree
  add_index "users", ["invitation_token"], name: "index_users_on_invitation_token", unique: true, using: :btree
  add_index "users", ["invitations_count"], name: "index_users_on_invitations_count", using: :btree
  add_index "users", ["invited_by_id"], name: "index_users_on_invited_by_id", using: :btree
  add_index "users", ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true, using: :btree

  create_table "validation_texts", force: true do |t|
    t.integer  "step_validation_id"
    t.integer  "submission_text_id"
    t.string   "description"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "validation_texts", ["step_validation_id"], name: "index_validation_texts_on_step_validation_id", using: :btree
  add_index "validation_texts", ["submission_text_id"], name: "index_validation_texts_on_submission_text_id", using: :btree

end