# 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 to check this file into your version control system.

ActiveRecord::Schema.define(:version => 20150901074551) do

  create_table "access_contact_attrs", :force => true do |t|
    t.integer "count"
    t.integer "service_access_contact_id"
  end

  create_table "active_admin_comments", :force => true do |t|
    t.string   "resource_id",   :null => false
    t.string   "resource_type", :null => false
    t.integer  "author_id"
    t.string   "author_type"
    t.text     "body"
    t.datetime "created_at",    :null => false
    t.datetime "updated_at",    :null => false
    t.string   "namespace"
  end

  add_index "active_admin_comments", ["author_type", "author_id"], :name => "index_active_admin_comments_on_author_type_and_author_id"
  add_index "active_admin_comments", ["namespace"], :name => "index_active_admin_comments_on_namespace"
  add_index "active_admin_comments", ["resource_type", "resource_id"], :name => "index_admin_notes_on_resource_type_and_resource_id"

  create_table "admin_users", :force => true do |t|
    t.string   "email",                  :default => "", :null => false
    t.string   "encrypted_password",     :default => "", :null => false
    t.string   "reset_password_token"
    t.datetime "reset_password_sent_at"
    t.datetime "remember_created_at"
    t.integer  "sign_in_count",          :default => 0
    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   "username"
    t.datetime "created_at",                             :null => false
    t.datetime "updated_at",                             :null => false
    t.string   "role"
    t.string   "token"
  end

  add_index "admin_users", ["email"], :name => "index_admin_users_on_email", :unique => true
  add_index "admin_users", ["reset_password_token"], :name => "index_admin_users_on_reset_password_token", :unique => true

  create_table "app_votes", :force => true do |t|
    t.integer  "app_id"
    t.integer  "user_id"
    t.string   "email"
    t.string   "ip"
    t.datetime "created_at",           :null => false
    t.datetime "updated_at",           :null => false
    t.string   "token"
    t.datetime "confirmed_at"
    t.datetime "confirmation_sent_at"
  end

  add_index "app_votes", ["app_id"], :name => "index_app_votes_on_app_id"

  create_table "apps", :force => true do |t|
    t.string   "title"
    t.string   "description"
    t.string   "link_to_app"
    t.string   "logo_file_name"
    t.string   "logo_content_type"
    t.integer  "logo_file_size"
    t.datetime "logo_updated_at"
    t.datetime "created_at",        :null => false
    t.datetime "updated_at",        :null => false
  end

  create_table "banner_service_requests", :force => true do |t|
    t.integer  "user_id"
    t.integer  "banner_id"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
    t.string   "state"
  end

  add_index "banner_service_requests", ["banner_id"], :name => "index_banner_service_requests_on_banner_id"
  add_index "banner_service_requests", ["user_id"], :name => "index_banner_service_requests_on_user_id"

  create_table "banners", :force => true do |t|
    t.text     "description"
    t.string   "size"
    t.string   "location"
    t.integer  "monthly_price"
    t.integer  "daily_price"
    t.datetime "created_at",    :null => false
    t.datetime "updated_at",    :null => false
    t.string   "note"
  end

  create_table "blogs", :force => true do |t|
    t.string   "title"
    t.string   "type_blog"
    t.text     "overview"
    t.integer  "user_id"
    t.integer  "company_id"
    t.boolean  "promote"
    t.datetime "created_at",                  :null => false
    t.datetime "updated_at",                  :null => false
    t.string   "slug"
    t.float    "rating",     :default => 0.0
  end

  add_index "blogs", ["slug"], :name => "index_blogs_on_slug", :unique => true

  create_table "browsings", :force => true do |t|
    t.integer  "user_id"
    t.integer  "browsinable_id"
    t.string   "browsinable_type"
    t.datetime "created_at",       :null => false
    t.datetime "updated_at",       :null => false
  end

  add_index "browsings", ["browsinable_id", "browsinable_type"], :name => "index_browsings_on_browsinable_id_and_browsinable_type"

  create_table "browsitems", :force => true do |t|
    t.string   "browsitemable_type"
    t.integer  "browsitemable_id"
    t.integer  "promo_view"
    t.integer  "promo_click"
    t.integer  "four_view"
    t.integer  "four_click"
    t.integer  "actual_review_view"
    t.integer  "actual_review_click"
    t.datetime "created_at",          :null => false
    t.datetime "updated_at",          :null => false
  end

  add_index "browsitems", ["browsitemable_type", "browsitemable_id"], :name => "index_browsitems_on_browsitemable_type_and_browsitemable_id"

  create_table "categories_faqs", :force => true do |t|
    t.string   "title"
    t.string   "slug"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  add_index "categories_faqs", ["slug"], :name => "index_categories_faqs_on_slug"

  create_table "cities", :force => true do |t|
    t.integer  "country_id", :limit => 3, :null => false
    t.string   "title"
    t.datetime "updated_at",              :null => false
    t.datetime "created_at",              :null => false
    t.boolean  "published"
  end

  add_index "cities", ["country_id"], :name => "id_country"

  create_table "ckeditor_assets", :force => true do |t|
    t.string   "data_file_name",                  :null => false
    t.string   "data_content_type"
    t.integer  "data_file_size"
    t.integer  "assetable_id"
    t.string   "assetable_type",    :limit => 30
    t.string   "type",              :limit => 30
    t.datetime "created_at",                      :null => false
    t.datetime "updated_at",                      :null => false
  end

  add_index "ckeditor_assets", ["assetable_type", "assetable_id"], :name => "idx_ckeditor_assetable"
  add_index "ckeditor_assets", ["assetable_type", "type", "assetable_id"], :name => "idx_ckeditor_assetable_type"

  create_table "clicks", :force => true do |t|
    t.integer  "clickable_id"
    t.string   "clickable_type"
    t.integer  "user_id"
    t.datetime "created_at",     :null => false
    t.datetime "updated_at",     :null => false
  end

  add_index "clicks", ["clickable_id", "clickable_type"], :name => "index_clicks_on_clickable_id_and_clickable_type"

  create_table "comments", :force => true do |t|
    t.integer  "commentable_id",    :default => 0
    t.string   "commentable_type",  :default => ""
    t.string   "title",             :default => ""
    t.text     "body"
    t.string   "subject",           :default => ""
    t.integer  "user_id",           :default => 0,  :null => false
    t.integer  "parent_id"
    t.integer  "lft"
    t.integer  "rgt"
    t.boolean  "official_response"
    t.datetime "created_at",                        :null => false
    t.datetime "updated_at",                        :null => false
    t.integer  "comments_count",    :default => 0
  end

  add_index "comments", ["commentable_id"], :name => "index_comments_on_commentable_id"
  add_index "comments", ["commentable_type", "commentable_id"], :name => "index_comments_on_commentable_type_and_commentable_id"
  add_index "comments", ["parent_id"], :name => "index_comments_on_parent_id"
  add_index "comments", ["user_id"], :name => "index_comments_on_user_id"

  create_table "companies", :force => true do |t|
    t.string   "title"
    t.string   "subdomain"
    t.integer  "browsings"
    t.string   "realname"
    t.string   "homepage"
    t.text     "overview"
    t.integer  "user_id"
    t.integer  "year_of_foundation"
    t.string   "basic_email"
    t.boolean  "moderate"
    t.integer  "awg_employees"
    t.float    "summary_rating"
    t.float    "change_summary_rating"
    t.integer  "plan_id",                       :default => 1
    t.date     "plan_start"
    t.date     "plan_end"
    t.integer  "nid"
    t.string   "logo_file_name"
    t.string   "logo_content_type"
    t.integer  "logo_file_size"
    t.datetime "logo_updated_at"
    t.datetime "created_at",                                       :null => false
    t.datetime "updated_at",                                       :null => false
    t.string   "phone"
    t.string   "slug"
    t.boolean  "archive",                       :default => false
    t.integer  "comments_count",                :default => 0
    t.integer  "browsings_count",               :default => 0
    t.text     "small_overview"
    t.string   "monochrome_logo_file_name"
    t.string   "monochrome_logo_content_type"
    t.integer  "monochrome_logo_file_size"
    t.datetime "monochrome_logo_updated_at"
    t.string   "background_image_file_name"
    t.string   "background_image_content_type"
    t.integer  "background_image_file_size"
    t.datetime "background_image_updated_at"
  end

  add_index "companies", ["realname"], :name => "index_companies_on_realname"
  add_index "companies", ["slug"], :name => "index_companies_on_slug"
  add_index "companies", ["subdomain"], :name => "index_companies_on_subdomain"
  add_index "companies", ["user_id"], :name => "index_companies_on_user_id"

  create_table "company_addresses", :force => true do |t|
    t.string   "title"
    t.integer  "city_id"
    t.string   "address"
    t.string   "email"
    t.boolean  "basic_office"
    t.integer  "company_id"
    t.datetime "created_at",   :null => false
    t.datetime "updated_at",   :null => false
  end

  create_table "company_awards", :force => true do |t|
    t.string   "title"
    t.string   "link"
    t.integer  "company_id"
    t.datetime "created_at",         :null => false
    t.datetime "updated_at",         :null => false
    t.string   "image_file_name"
    t.string   "image_content_type"
    t.integer  "image_file_size"
    t.datetime "image_updated_at"
  end

  add_index "company_awards", ["company_id"], :name => "index_company_awards_on_company_id"

  create_table "company_certificates", :force => true do |t|
    t.string   "title"
    t.string   "link"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
    t.integer  "company_id"
  end

  create_table "company_foreign_jobs", :force => true do |t|
    t.string   "title"
    t.string   "url"
    t.integer  "company_id"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  add_index "company_foreign_jobs", ["company_id"], :name => "index_company_foreign_jobs_on_company_id"

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

  add_index "company_hrs", ["company_id"], :name => "index_company_hrs_on_company_id"
  add_index "company_hrs", ["user_id"], :name => "index_company_hrs_on_user_id"

  create_table "company_organizations", :force => true do |t|
    t.string   "title"
    t.string   "link"
    t.integer  "company_id"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  add_index "company_organizations", ["company_id"], :name => "index_company_organizations_on_company_id"

  create_table "company_phones", :force => true do |t|
    t.string   "phone"
    t.integer  "company_address_id"
    t.datetime "created_at",         :null => false
    t.datetime "updated_at",         :null => false
  end

  add_index "company_phones", ["company_address_id"], :name => "index_company_phones_on_company_address_id"

  create_table "company_projects", :force => true do |t|
    t.string   "title"
    t.text     "overview"
    t.integer  "company_id"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  create_table "company_specializations", :force => true do |t|
    t.integer  "company_id"
    t.integer  "specialization_id"
    t.datetime "created_at",        :null => false
    t.datetime "updated_at",        :null => false
  end

  add_index "company_specializations", ["company_id"], :name => "index_company_specializations_on_company_id"
  add_index "company_specializations", ["specialization_id"], :name => "index_company_specializations_on_specialization_id"

  create_table "company_spotlight_attrs", :force => true do |t|
    t.date    "date_start"
    t.date    "date_end"
    t.integer "service_company_spotlight_id"
    t.integer "browsings_count",              :default => 0
    t.integer "clicks_count",                 :default => 0
  end

  add_index "company_spotlight_attrs", ["service_company_spotlight_id"], :name => "index_company_spotlight_attrs_on_service_company_spotlight_id"

  create_table "complains", :force => true do |t|
    t.integer  "user_id"
    t.integer  "complain_id"
    t.string   "complain_type"
    t.text     "body"
    t.datetime "created_at",    :null => false
    t.datetime "updated_at",    :null => false
  end

  create_table "content_configs", :force => true do |t|
    t.integer  "bigboard_items"
    t.integer  "material_items_tab"
    t.integer  "material_items_load"
    t.integer  "company_widget_items"
    t.integer  "reviews_items"
    t.integer  "blogs_widget_items"
    t.datetime "created_at",           :null => false
    t.datetime "updated_at",           :null => false
  end

  create_table "countries", :force => true do |t|
    t.string   "title",      :limit => 50, :null => false
    t.datetime "updated_at",               :null => false
    t.datetime "created_at",               :null => false
  end

  create_table "delivery_jobs", :force => true do |t|
    t.integer  "job_id"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
    t.integer  "company_id"
    t.boolean  "status"
  end

  add_index "delivery_jobs", ["job_id"], :name => "index_delivery_jobs_on_job_id"

  create_table "dev_by_settings", :force => true do |t|
    t.integer  "employee_range"
    t.integer  "review_min"
    t.datetime "created_at",     :null => false
    t.datetime "updated_at",     :null => false
  end

  create_table "epam_links", :force => true do |t|
    t.string   "link"
    t.string   "title"
    t.integer  "weight"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

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

  create_table "event_companies", :force => true do |t|
    t.integer  "event_id"
    t.integer  "company_id"
    t.string   "title"
    t.text     "overview"
    t.string   "logo_file_name"
    t.string   "logo_content_type"
    t.integer  "logo_file_size"
    t.datetime "logo_updated_at"
  end

  create_table "event_registrations", :force => true do |t|
    t.integer "event_id"
    t.boolean "user_name"
    t.boolean "position"
    t.boolean "level_skill"
    t.boolean "experience"
    t.boolean "company"
    t.boolean "phone"
    t.boolean "email"
    t.boolean "questions"
  end

  create_table "events", :force => true do |t|
    t.string   "title"
    t.integer  "user_id"
    t.datetime "date_start"
    t.datetime "date_end"
    t.string   "email"
    t.text     "overview"
    t.integer  "event_category_id"
    t.integer  "city_id"
    t.string   "address"
    t.float    "longitude"
    t.float    "latitude"
    t.string   "www"
    t.string   "price"
    t.boolean  "registration",            :default => false
    t.boolean  "published",               :default => false
    t.integer  "browsings",               :default => 0
    t.datetime "created_at",                                 :null => false
    t.datetime "updated_at",                                 :null => false
    t.string   "slug"
    t.string   "phone"
    t.boolean  "popular"
    t.boolean  "hot"
    t.boolean  "notification",            :default => false
    t.integer  "comments_count",          :default => 0
    t.string   "hot_teaser_file_name"
    t.string   "hot_teaser_content_type"
    t.integer  "hot_teaser_file_size"
    t.datetime "hot_teaser_updated_at"
  end

  add_index "events", ["slug"], :name => "index_events_on_slug", :unique => true
  add_index "events", ["title"], :name => "index_events_on_title"
  add_index "events", ["user_id"], :name => "index_events_on_user_id"

  create_table "faqs", :force => true do |t|
    t.integer  "category_id"
    t.string   "title"
    t.text     "content"
    t.datetime "created_at",  :null => false
    t.datetime "updated_at",  :null => false
  end

  create_table "favorites", :force => true do |t|
    t.integer  "favoritetable_id"
    t.string   "favoritetable_type"
    t.integer  "user_id"
    t.datetime "created_at",         :null => false
    t.datetime "updated_at",         :null => false
  end

  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 => 40
    t.datetime "created_at"
  end

  add_index "friendly_id_slugs", ["slug", "sluggable_type"], :name => "index_friendly_id_slugs_on_slug_and_sluggable_type", :unique => true
  add_index "friendly_id_slugs", ["sluggable_id"], :name => "index_friendly_id_slugs_on_sluggable_id"
  add_index "friendly_id_slugs", ["sluggable_type"], :name => "index_friendly_id_slugs_on_sluggable_type"

  create_table "galleries", :force => true do |t|
    t.integer  "user_id"
    t.integer  "company_id"
    t.boolean  "published"
    t.string   "title"
    t.integer  "count_views"
    t.string   "source_file_name"
    t.string   "source_content_type"
    t.integer  "source_file_size"
    t.datetime "source_updated_at"
    t.datetime "created_at",          :null => false
    t.datetime "updated_at",          :null => false
  end

  add_index "galleries", ["company_id"], :name => "index_galleries_on_company_id"
  add_index "galleries", ["user_id"], :name => "index_galleries_on_user_id"

  create_table "hackaton_apps", :force => true do |t|
    t.string   "title"
    t.text     "content"
    t.datetime "created_at",         :null => false
    t.datetime "updated_at",         :null => false
    t.string   "image_file_name"
    t.string   "image_content_type"
    t.integer  "image_file_size"
    t.datetime "image_updated_at"
    t.string   "link"
  end

  create_table "hakaton_registraions", :force => true do |t|
    t.string   "email"
    t.string   "name"
    t.boolean  "published"
    t.datetime "created_at",  :null => false
    t.datetime "updated_at",  :null => false
    t.string   "company"
    t.integer  "position_id"
    t.string   "level_skill"
  end

  create_table "imworkinghere_projects", :force => true do |t|
    t.string   "title"
    t.string   "position"
    t.string   "overview"
    t.string   "responsibility"
    t.string   "use_technologies"
    t.integer  "imworkinghere_id"
    t.datetime "created_at",       :null => false
    t.datetime "updated_at",       :null => false
  end

  create_table "imworkingheres", :force => true do |t|
    t.integer  "user_id"
    t.integer  "company_id"
    t.string   "position"
    t.date     "date_start"
    t.date     "date_end"
    t.boolean  "save_profile"
    t.string   "prof_level_position"
    t.integer  "prof_level_year"
    t.integer  "user_type_of_activity_id"
    t.integer  "resume_id"
    t.datetime "created_at",                                  :null => false
    t.datetime "updated_at",                                  :null => false
    t.boolean  "work_currently",           :default => false
    t.string   "company_title"
  end

  add_index "imworkingheres", ["company_id"], :name => "index_imworkingheres_on_company_id"
  add_index "imworkingheres", ["position"], :name => "index_imworkingheres_on_position"
  add_index "imworkingheres", ["resume_id"], :name => "index_imworkingheres_on_resume_id"
  add_index "imworkingheres", ["user_id"], :name => "index_imworkingheres_on_user_id"
  add_index "imworkingheres", ["user_type_of_activity_id"], :name => "index_imworkingheres_on_user_type_of_activity_id"

  create_table "ironmen", :force => true do |t|
    t.string   "email"
    t.string   "token"
    t.datetime "confirmation_at"
    t.string   "user_ip"
    t.datetime "created_at",      :null => false
    t.datetime "updated_at",      :null => false
    t.boolean  "with_email"
  end

  create_table "job_applications", :force => true do |t|
    t.string   "name"
    t.string   "email"
    t.text     "message"
    t.string   "confirmation_token"
    t.string   "resume_file_name"
    t.string   "resume_content_type"
    t.integer  "resume_file_size"
    t.datetime "resume_updated_at"
    t.datetime "created_at",          :null => false
    t.datetime "updated_at",          :null => false
    t.integer  "job_id"
  end

  add_index "job_applications", ["confirmation_token"], :name => "index_job_applications_on_confirmation_token"

  create_table "job_langs", :force => true do |t|
    t.integer  "job_id"
    t.integer  "language_id"
    t.integer  "language_level"
    t.datetime "created_at",     :null => false
    t.datetime "updated_at",     :null => false
  end

  create_table "job_responses", :force => true do |t|
    t.integer  "job_id"
    t.integer  "resume_id"
    t.integer  "pm_id"
    t.string   "resume_type"
    t.integer  "company_id"
    t.datetime "created_at",                     :null => false
    t.datetime "updated_at",                     :null => false
    t.integer  "browsings_count", :default => 0
  end

  add_index "job_responses", ["job_id"], :name => "index_job_responses_on_job_id"

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

  create_table "job_ups", :force => true do |t|
    t.integer  "company_id"
    t.integer  "user_id"
    t.integer  "job_id"
    t.datetime "created_at",     :null => false
    t.datetime "updated_at",     :null => false
    t.integer  "tariff_plan_id"
  end

  create_table "jobs", :force => true do |t|
    t.string   "title"
    t.integer  "user_type_of_activity_id"
    t.text     "overview"
    t.integer  "company_id"
    t.integer  "browsings"
    t.boolean  "status"
    t.integer  "user_id"
    t.boolean  "job_in_search"
    t.boolean  "job_in_premium",             :default => false
    t.boolean  "job_in_ads"
    t.integer  "salary_value"
    t.boolean  "bonus_and_premium"
    t.text     "bonus_and_premium_overview"
    t.boolean  "benefits_package"
    t.text     "benefits_package_overview"
    t.integer  "job_type_id"
    t.integer  "jobs"
    t.integer  "city_id"
    t.boolean  "move_to_other_place"
    t.date     "date_start"
    t.date     "date_end"
    t.integer  "experience"
    t.integer  "user_level_skill_id"
    t.integer  "education_id"
    t.boolean  "duty_journey"
    t.boolean  "published",                  :default => false
    t.integer  "project_id"
    t.datetime "created_at",                                    :null => false
    t.datetime "updated_at",                                    :null => false
    t.integer  "nid"
    t.datetime "sorted_up"
    t.integer  "views_in_widget_top"
    t.integer  "views_in_widget_side",       :default => 1
    t.float    "view_k",                     :default => 1.0
    t.boolean  "delivery"
    t.boolean  "twitter"
    t.boolean  "company_page"
    t.integer  "comments_count",             :default => 0
    t.integer  "browsings_count",            :default => 0
    t.boolean  "track_views",                :default => false
  end

  add_index "jobs", ["company_id", "status"], :name => "index_jobs_on_company_id_and_status"
  add_index "jobs", ["user_id"], :name => "index_jobs_on_user_id"
  add_index "jobs", ["user_type_of_activity_id"], :name => "index_jobs_on_user_type_of_activity_id"

  create_table "language_refs", :force => true do |t|
    t.string   "languagetable_tyle"
    t.integer  "languagetable_id"
    t.integer  "language_id"
    t.integer  "language_level_id"
    t.datetime "created_at",         :null => false
    t.datetime "updated_at",         :null => false
  end

  add_index "language_refs", ["language_id"], :name => "index_language_refs_on_language_id"

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

  create_table "logged_updates", :force => true do |t|
    t.integer  "logged_id"
    t.string   "logged_type"
    t.string   "reason"
    t.integer  "user_id"
    t.datetime "created_at",  :null => false
    t.datetime "updated_at",  :null => false
  end

  create_table "logged_views", :force => true do |t|
    t.integer  "object_id"
    t.string   "model_name"
    t.integer  "user_id"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  create_table "mo2013_tickets", :force => true do |t|
    t.integer  "count_tickets"
    t.datetime "created_at",    :null => false
    t.datetime "updated_at",    :null => false
    t.integer  "rate"
    t.string   "constanta"
    t.string   "tickets_text"
  end

  create_table "new_company_widgets", :force => true do |t|
    t.integer  "company_id"
    t.text     "preview"
    t.boolean  "published"
    t.datetime "date_start"
    t.datetime "date_end"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  add_index "new_company_widgets", ["company_id"], :name => "index_new_company_widgets_on_company_id"

  create_table "news", :force => true do |t|
    t.string   "title"
    t.text     "content"
    t.integer  "user_id"
    t.boolean  "published"
    t.string   "slug"
    t.datetime "created_at",                    :null => false
    t.datetime "updated_at",                    :null => false
    t.integer  "browsings"
    t.boolean  "important"
    t.integer  "nid"
    t.string   "source"
    t.string   "source_title"
    t.integer  "comments_count", :default => 0
    t.integer  "rubric_id"
  end

  add_index "news", ["slug"], :name => "index_news_on_slug", :unique => true
  add_index "news", ["user_id"], :name => "index_news_on_admin_user_id"

  create_table "pms", :force => true do |t|
    t.text     "message"
    t.integer  "sender_id"
    t.integer  "recipient_id"
    t.datetime "created_at",   :null => false
    t.datetime "updated_at",   :null => false
    t.boolean  "read"
    t.boolean  "response"
    t.boolean  "offer"
  end

  create_table "rails_admin_histories", :force => true do |t|
    t.text     "message"
    t.string   "username"
    t.integer  "item"
    t.string   "table"
    t.integer  "month",      :limit => 2
    t.integer  "year",       :limit => 8
    t.datetime "created_at",              :null => false
    t.datetime "updated_at",              :null => false
  end

  add_index "rails_admin_histories", ["item", "table", "month", "year"], :name => "index_rails_admin_histories"

  create_table "rates", :force => true do |t|
    t.boolean  "value"
    t.integer  "rateable_id"
    t.string   "rateable_type"
    t.integer  "user_id"
    t.datetime "created_at",    :null => false
    t.datetime "updated_at",    :null => false
  end

  add_index "rates", ["rateable_id", "rateable_type"], :name => "index_rates_on_rateable_id_and_rateable_type"
  add_index "rates", ["user_id"], :name => "index_rates_on_user_id"
  add_index "rates", ["value", "rateable_id", "rateable_type"], :name => "index_rates_on_value_and_rateable_id_and_rateable_type"
  add_index "rates", ["value"], :name => "index_rates_on_value"

  create_table "resume_educations", :force => true do |t|
    t.string   "specialization"
    t.date     "date_start"
    t.date     "date_end"
    t.string   "organization"
    t.integer  "city_id"
    t.integer  "resume_id"
    t.datetime "created_at",     :null => false
    t.datetime "updated_at",     :null => false
  end

  add_index "resume_educations", ["resume_id"], :name => "index_resume_educations_on_resume_id"

  create_table "resume_files", :force => true do |t|
    t.string   "title"
    t.integer  "language_id"
    t.integer  "status"
    t.integer  "default"
    t.integer  "user_id"
    t.string   "source_file_name"
    t.string   "source_content_type"
    t.integer  "source_file_size"
    t.datetime "source_updated_at"
    t.integer  "browsings"
    t.datetime "created_at",          :null => false
    t.datetime "updated_at",          :null => false
  end

  add_index "resume_files", ["user_id"], :name => "index_resume_files_on_user_id"

  create_table "resume_languages", :force => true do |t|
    t.integer  "language_id"
    t.string   "level_prof"
    t.integer  "level_year"
    t.integer  "resume_id"
    t.datetime "created_at",  :null => false
    t.datetime "updated_at",  :null => false
  end

  create_table "resume_technologies", :force => true do |t|
    t.integer  "resume_id"
    t.string   "technology"
    t.string   "level_prof"
    t.integer  "level_year"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  add_index "resume_technologies", ["resume_id"], :name => "index_resume_technologies_on_resume_id"

  create_table "resumes", :force => true do |t|
    t.string   "title"
    t.integer  "user_id"
    t.string   "language"
    t.text     "about_me"
    t.integer  "user_type_of_activity_id"
    t.integer  "user_level_skill_id"
    t.integer  "status"
    t.boolean  "hrm_can_find",                     :default => true
    t.boolean  "default"
    t.date     "birthday"
    t.integer  "experience"
    t.integer  "language_id"
    t.integer  "integer"
    t.integer  "city_id"
    t.integer  "user_contact_id"
    t.integer  "imworkinghere_id"
    t.integer  "resume_education_id"
    t.integer  "resume_sertificate_and_awards_id"
    t.integer  "browsings"
    t.datetime "created_at",                                         :null => false
    t.datetime "updated_at",                                         :null => false
  end

  create_table "reviews", :force => true do |t|
    t.integer  "company_id"
    t.integer  "user_id"
    t.text     "overview"
    t.text     "negative"
    t.text     "positive"
    t.integer  "communication_with_management"
    t.integer  "advise_the_company"
    t.integer  "proud_of_the_work"
    t.integer  "productivity"
    t.integer  "recognition_and_praise"
    t.integer  "opportunities_for_growth"
    t.integer  "promotion"
    t.integer  "competence"
    t.integer  "benefits"
    t.integer  "exchange_of_knowledge"
    t.float    "rate_sum"
    t.boolean  "published"
    t.datetime "created_at",                                   :null => false
    t.datetime "updated_at",                                   :null => false
    t.integer  "response_user_id"
    t.text     "response_body"
    t.datetime "response_created_at"
    t.integer  "comments_count",                :default => 0
    t.boolean  "show_on_homepage"
    t.boolean  "show_on_widget_company"
  end

  add_index "reviews", ["company_id"], :name => "index_reviews_on_company_id"
  add_index "reviews", ["user_id"], :name => "index_reviews_on_user_id"

  create_table "revisions", :force => true do |t|
    t.string   "model_name"
    t.integer  "user_id"
    t.text     "data_clone"
    t.boolean  "need_moderate"
    t.boolean  "current_version"
    t.integer  "object_id"
    t.text     "data_clone_addresses"
    t.text     "data_clone_organizations"
    t.text     "data_clone_awards"
    t.datetime "created_at",               :null => false
    t.datetime "updated_at",               :null => false
    t.string   "file_file_name"
    t.string   "file_content_type"
    t.integer  "file_file_size"
    t.datetime "file_updated_at"
  end

  create_table "rubrics", :force => true do |t|
    t.string   "title"
    t.boolean  "published"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  create_table "salaries", :force => true do |t|
    t.integer  "salary_position_id"
    t.integer  "salary_dev_language_id"
    t.integer  "salary_city_id"
    t.integer  "salary_value"
    t.integer  "length_of_work"
    t.boolean  "published"
    t.datetime "created_at",             :null => false
    t.datetime "updated_at",             :null => false
  end

  add_index "salaries", ["salary_city_id"], :name => "index_salaries_on_salary_city_id"
  add_index "salaries", ["salary_dev_language_id"], :name => "index_salaries_on_salary_dev_language_id"
  add_index "salaries", ["salary_position_id"], :name => "index_salaries_on_salary_position_id"

  create_table "salary_cities", :force => true do |t|
    t.string   "title"
    t.boolean  "published"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  create_table "salary_dev_languages", :force => true do |t|
    t.string   "title"
    t.boolean  "published"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  create_table "salary_positions", :force => true do |t|
    t.string   "title"
    t.boolean  "published"
    t.datetime "created_at",                    :null => false
    t.datetime "updated_at",                    :null => false
    t.integer  "status"
    t.boolean  "development", :default => true
  end

  create_table "service_requests", :force => true do |t|
    t.integer  "user_id"
    t.text     "content"
    t.integer  "service_id"
    t.integer  "servicetable_id"
    t.string   "servicetable_type"
    t.datetime "created_at",                           :null => false
    t.datetime "updated_at",                           :null => false
    t.boolean  "published",         :default => false
    t.integer  "company_id"
    t.text     "request_params"
    t.string   "type"
  end

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

  add_index "services", ["slug"], :name => "index_services_on_slug", :unique => true

  create_table "specializations", :force => true do |t|
    t.string   "title"
    t.integer  "older_id"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  create_table "static_pages", :force => true do |t|
    t.string   "title"
    t.text     "content"
    t.integer  "user_id"
    t.string   "slug"
    t.datetime "created_at",        :null => false
    t.datetime "updated_at",        :null => false
    t.integer  "browsings"
    t.string   "file_file_name"
    t.string   "file_content_type"
    t.integer  "file_file_size"
    t.datetime "file_updated_at"
  end

  add_index "static_pages", ["slug"], :name => "index_static_pages_on_slug", :unique => true
  add_index "static_pages", ["user_id"], :name => "index_static_pages_on_user_id"

  create_table "taggings", :force => true do |t|
    t.integer  "tag_id"
    t.integer  "taggable_id"
    t.string   "taggable_type"
    t.integer  "tagger_id"
    t.string   "tagger_type"
    t.string   "context",       :limit => 128
    t.datetime "created_at"
  end

  add_index "taggings", ["tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type"], :name => "taggings_idx", :unique => true
  add_index "taggings", ["taggable_id", "taggable_type", "context"], :name => "index_taggings_on_taggable_id_and_taggable_type_and_context"

  create_table "tags", :force => true do |t|
    t.string  "name"
    t.integer "taggings_count", :default => 0
  end

  add_index "tags", ["name"], :name => "index_tags_on_name"

  create_table "tariff_change_logs", :force => true do |t|
    t.integer  "company_id"
    t.integer  "admin_user_id"
    t.integer  "old_plan_id"
    t.integer  "new_plan_id"
    t.date     "date_start"
    t.date     "date_end"
    t.datetime "created_at",     :null => false
    t.datetime "updated_at",     :null => false
    t.date     "old_plan_start"
    t.date     "old_plan_end"
  end

  add_index "tariff_change_logs", ["admin_user_id"], :name => "index_tariff_change_logs_on_admin_user_id"
  add_index "tariff_change_logs", ["company_id"], :name => "index_tariff_change_logs_on_company_id"

  create_table "tariff_plan_requests", :force => true do |t|
    t.integer  "company_id"
    t.integer  "user_id"
    t.integer  "old_plan_id"
    t.string   "new_plan_id"
    t.text     "comment"
    t.datetime "created_at",  :null => false
    t.datetime "updated_at",  :null => false
    t.boolean  "published"
    t.date     "plan_start"
    t.date     "plan_end"
  end

  create_table "tariff_plans", :force => true do |t|
    t.string   "title"
    t.decimal  "price_per_month",           :precision => 10, :scale => 0
    t.boolean  "search_resume"
    t.integer  "show_contact_resume"
    t.boolean  "customization_company"
    t.boolean  "hidden_ads_company"
    t.boolean  "promo_page_company"
    t.boolean  "company_logo_ads_jobs"
    t.integer  "spotlight_company"
    t.boolean  "premium_service_company"
    t.string   "preview_text"
    t.integer  "jobs_add"
    t.boolean  "jobs_add_without_moderate"
    t.integer  "promo_jobs"
    t.integer  "premium_jobs"
    t.boolean  "day_jobs"
    t.integer  "subscription_jobs",                                        :default => 0
    t.integer  "twitter_jobs"
    t.datetime "created_at",                                                              :null => false
    t.datetime "updated_at",                                                              :null => false
    t.integer  "up_job_in_search"
    t.integer  "job_in_company_profile"
    t.text     "description"
  end

  create_table "topics", :force => true do |t|
    t.string   "title"
    t.integer  "user_id"
    t.text     "content",                          :limit => 2147483647
    t.integer  "blog_id"
    t.boolean  "published"
    t.integer  "nid"
    t.string   "slug"
    t.datetime "created_at",                                                                :null => false
    t.datetime "updated_at",                                                                :null => false
    t.integer  "browsings"
    t.boolean  "status"
    t.boolean  "as_advertising"
    t.boolean  "show_in_main_page",                                      :default => true
    t.integer  "comments_count",                                         :default => 0
    t.boolean  "uncommentable",                                          :default => false
    t.string   "teaser_file_name"
    t.string   "teaser_content_type"
    t.integer  "teaser_file_size"
    t.datetime "teaser_updated_at"
    t.text     "lead"
    t.boolean  "bigboard"
    t.boolean  "promo_block_four"
    t.integer  "rubric_id"
    t.string   "teaser_middle_file_name"
    t.string   "teaser_middle_content_type"
    t.integer  "teaser_middle_file_size"
    t.datetime "teaser_middle_updated_at"
    t.string   "teaser_big_file_name"
    t.string   "teaser_big_content_type"
    t.integer  "teaser_big_file_size"
    t.datetime "teaser_big_updated_at"
    t.integer  "article_type",                                           :default => 1
    t.boolean  "important",                                              :default => false
    t.string   "source"
    t.string   "source_title"
    t.string   "teaser_for_facebook_file_name"
    t.string   "teaser_for_facebook_content_type"
    t.integer  "teaser_for_facebook_file_size"
    t.datetime "teaser_for_facebook_updated_at"
    t.integer  "time_in_minutes_for_reading"
    t.boolean  "badge",                                                  :default => false
    t.boolean  "ban_from_yandex_news",                                   :default => false
  end

  add_index "topics", ["article_type"], :name => "index_topics_on_article_type"
  add_index "topics", ["blog_id"], :name => "index_topics_on_blog_id"
  add_index "topics", ["slug"], :name => "index_topics_on_slug", :unique => true
  add_index "topics", ["user_id"], :name => "index_topics_on_user_id"

  create_table "twitter_jobs", :force => true do |t|
    t.integer  "company_id"
    t.text     "twitter_link"
    t.datetime "created_at",   :null => false
    t.datetime "updated_at",   :null => false
    t.integer  "job_id"
  end

  create_table "unidentified_service_requests", :force => true do |t|
    t.string   "name"
    t.string   "position"
    t.string   "company_name"
    t.string   "email"
    t.string   "phone_number"
    t.integer  "service_id"
    t.datetime "created_at",   :null => false
    t.datetime "updated_at",   :null => false
    t.string   "state"
    t.integer  "banner_id"
  end

  create_table "unidentified_tariff_plan_requests", :force => true do |t|
    t.string   "name"
    t.string   "position"
    t.string   "company_name"
    t.string   "email"
    t.string   "phone_number"
    t.integer  "tariff_plan_id"
    t.string   "state"
    t.datetime "created_at",     :null => false
    t.datetime "updated_at",     :null => false
  end

  add_index "unidentified_tariff_plan_requests", ["tariff_plan_id"], :name => "index_unidentified_tariff_plan_requests_on_tariff_plan_id"

  create_table "user_broadcasts", :force => true do |t|
    t.integer  "user_id"
    t.boolean  "twitter_allow_company"
    t.boolean  "twitter_allow_review"
    t.boolean  "facebook_allow_company"
    t.boolean  "facebook_allow_review"
    t.string   "twitter_uid"
    t.string   "facebook_token"
    t.string   "twitter_token"
    t.string   "twitter_secret"
    t.boolean  "follow_news",               :default => true
    t.boolean  "follow_events",             :default => true
    t.boolean  "follow_answer_my_comments", :default => true
    t.boolean  "follow_comments_my_topic",  :default => true
    t.datetime "created_at",                                  :null => false
    t.datetime "updated_at",                                  :null => false
  end

  add_index "user_broadcasts", ["user_id"], :name => "index_user_broadcasts_on_user_id"

  create_table "user_certificate_and_awards", :force => true do |t|
    t.integer  "user_id"
    t.string   "title"
    t.integer  "year"
    t.string   "link"
    t.integer  "resume_id"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  create_table "user_contacts", :force => true do |t|
    t.integer  "user_id"
    t.integer  "user_type_contact_id"
    t.string   "value"
    t.integer  "resume_id"
    t.datetime "created_at",           :null => false
    t.datetime "updated_at",           :null => false
  end

  add_index "user_contacts", ["user_id"], :name => "index_user_contacts_on_user_id"
  add_index "user_contacts", ["user_type_contact_id"], :name => "index_user_contacts_on_user_type_contact_id"

  create_table "user_follow_companies", :force => true do |t|
    t.integer  "user_id"
    t.integer  "company_id"
    t.boolean  "follow_review"
    t.datetime "created_at",    :null => false
    t.datetime "updated_at",    :null => false
  end

  add_index "user_follow_companies", ["company_id"], :name => "index_user_follow_companies_on_company_id"
  add_index "user_follow_companies", ["user_id"], :name => "index_user_follow_companies_on_user_id"

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

  create_table "user_registration_on_events", :force => true do |t|
    t.integer  "user_id"
    t.integer  "event_id"
    t.datetime "created_at",          :null => false
    t.datetime "updated_at",          :null => false
    t.string   "user_name"
    t.string   "salary_position_id"
    t.integer  "user_level_skill_id"
    t.integer  "experience"
    t.integer  "company"
    t.integer  "phone"
    t.string   "email"
    t.text     "questions"
    t.string   "session_id"
  end

  add_index "user_registration_on_events", ["event_id"], :name => "index_user_registration_on_events_on_event_id"
  add_index "user_registration_on_events", ["user_id"], :name => "index_user_registration_on_events_on_user_id"

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

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

  create_table "users", :force => true do |t|
    t.string   "email",                     :default => "",    :null => false
    t.string   "username",                  :default => "",    :null => false
    t.string   "encrypted_password",        :default => "",    :null => false
    t.integer  "uid"
    t.string   "first_name"
    t.string   "last_name"
    t.boolean  "gender"
    t.text     "about_me"
    t.boolean  "visibility_realname",       :default => false
    t.boolean  "open_for_contact",          :default => false
    t.integer  "experience"
    t.integer  "city_id"
    t.boolean  "i_am_hr",                   :default => false
    t.date     "birthday"
    t.integer  "user_level_skill_id"
    t.integer  "user_type_of_activity_id"
    t.string   "avatar_file_name"
    t.string   "avatar_content_type"
    t.integer  "avatar_file_size"
    t.datetime "avatar_updated_at"
    t.integer  "position_id"
    t.integer  "dev_language_id"
    t.datetime "requested_at"
    t.string   "role"
    t.date     "last_filled_salary"
    t.boolean  "email_send_for_salary"
    t.string   "reset_password_token"
    t.datetime "reset_password_sent_at"
    t.datetime "remember_created_at"
    t.integer  "sign_in_count",             :default => 0
    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   "confirmation_token"
    t.datetime "confirmed_at"
    t.datetime "confirmation_sent_at"
    t.string   "unconfirmed_email"
    t.integer  "failed_attempts",           :default => 0
    t.string   "unlock_token"
    t.datetime "locked_at"
    t.integer  "sum_rate"
    t.datetime "created_at",                                   :null => false
    t.datetime "updated_at",                                   :null => false
    t.integer  "pos_rate"
    t.integer  "neg_rate"
    t.string   "slug"
    t.boolean  "banned"
    t.string   "banned_comment"
    t.integer  "contact_visibility_status", :default => 2
    t.integer  "comments_count",            :default => 0
    t.string   "provider"
    t.string   "social_uid"
    t.string   "token"
  end

  add_index "users", ["confirmation_token"], :name => "index_users_on_confirmation_token", :unique => true
  add_index "users", ["email"], :name => "index_users_on_email", :unique => true
  add_index "users", ["reset_password_token"], :name => "index_users_on_reset_password_token", :unique => true
  add_index "users", ["slug"], :name => "index_users_on_slug", :unique => true
  add_index "users", ["unlock_token"], :name => "index_users_on_unlock_token", :unique => true
  add_index "users", ["user_level_skill_id"], :name => "index_users_on_user_level_skill_id"
  add_index "users", ["user_type_of_activity_id"], :name => "index_users_on_user_type_of_activity_id"

  create_table "wanted_orders", :force => true do |t|
    t.integer  "count"
    t.decimal  "experience",     :precision => 10, :scale => 0
    t.text     "folio"
    t.text     "recomendations"
    t.text     "resume"
    t.string   "email"
    t.datetime "created_at",                                    :null => false
    t.datetime "updated_at",                                    :null => false
    t.string   "order_type"
  end

  create_table "widget_sberbank_jobs", :force => true do |t|
    t.string   "title"
    t.text     "descr"
    t.text     "manager"
    t.text     "contact"
    t.string   "link"
    t.integer  "weight"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  create_table "windows_app_authors", :force => true do |t|
    t.string   "surname"
    t.string   "name"
    t.string   "email"
    t.string   "city"
    t.string   "position"
    t.boolean  "student"
    t.integer  "windows_app_id"
    t.datetime "created_at",     :null => false
    t.datetime "updated_at",     :null => false
  end

  create_table "windows_apps", :force => true do |t|
    t.string   "name_app"
    t.integer  "category"
    t.string   "address"
    t.string   "link_demo"
    t.string   "address_win_phone"
    t.boolean  "azure"
    t.datetime "created_at",        :null => false
    t.datetime "updated_at",        :null => false
    t.string   "spam"
    t.boolean  "published"
  end

  create_table "with_the_support_widgets", :force => true do |t|
    t.integer  "company_id"
    t.datetime "created_at",                     :null => false
    t.datetime "updated_at",                     :null => false
    t.date     "date_end"
    t.date     "date_start"
    t.string   "link"
    t.integer  "weight"
    t.integer  "browsings_count", :default => 0
  end

end