gistfile1.rb

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

  create_table "activities", :force => true do |t|
    t.string   "action"
    t.integer  "subject_id"
    t.string   "subject_type"
    t.integer  "user_profile_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "group_id"
    t.integer  "appl_id"
    t.string   "title",              :limit => 4000
    t.string   "body",               :limit => 4000
    t.integer  "external_id"
    t.integer  "priority"
    t.string   "stream_favicon_url"
    t.string   "stream_source_url"
    t.string   "stream_title",       :limit => 4000
    t.string   "stream_url"
    t.string   "url"
  end

  add_index "activities", ["appl_id"], :name => "activities_appl"
  add_index "activities", ["created_at"], :name => "activities_created_at"

  create_table "appl_persistences", :force => true do |t|
    t.integer  "user_profile_id"
    t.integer  "appl_id"
    t.string   "type"
    t.string   "instance_id"
    t.string   "key"
    t.string   "value"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "appl_user_preferences", :force => true do |t|
    t.integer  "user_profile_id"
    t.integer  "appl_id"
    t.string   "key"
    t.string   "value"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "appls", :force => true do |t|
    t.string   "name"
    t.string   "contact_email"
    t.string   "support_email"
    t.string   "application_url",           :limit => 4000
    t.boolean  "published_ever"
    t.integer  "author_id"
    t.integer  "user_count",                                                               :default => 0
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "home_default",                                                             :default => 0,     :null => false
    t.integer  "profile_default",                                                          :default => 0,     :null => false
    t.integer  "private",                                                                  :default => 0,     :null => false
    t.integer  "internal",                                                                 :default => 0,     :null => false
    t.integer  "appls_user_profiles_count",                                                :default => 0
    t.string   "description",               :limit => 4000
    t.string   "developers",                :limit => 4000
    t.string   "status",                    :limit => 30,                                  :default => "new", :null => false
    t.string   "logo_file_name"
    t.string   "logo_content_type"
    t.integer  "logo_file_size"
    t.string   "logo_url"
    t.integer  "ratings_count",                                                            :default => 0
    t.integer  "ratings_average",           :limit => 10,   :precision => 10, :scale => 0, :default => 0
    t.datetime "publish_date"
    t.string   "screenshot_file_name"
    t.string   "screenshot_content_type"
    t.integer  "screenshot_file_size"
    t.string   "screenshot_url"
  end

  add_index "appls", ["author_id"], :name => "appls_author"
  add_index "appls", ["created_at"], :name => "appls_created_at"
  add_index "appls", ["name"], :name => "appls_name"
  add_index "appls", ["status"], :name => "appls_status"
  add_index "appls", ["updated_at"], :name => "appls_updated_at"

  create_table "appls_user_profiles", :force => true do |t|
    t.integer "appl_id"
    t.integer "user_profile_id"
    t.integer "app_rank",                                  :default => 0
    t.boolean "can_email_me",                              :default => true
    t.boolean "show_icon_below_picture",                   :default => true
    t.boolean "show_in_leftside",                          :default => false
    t.boolean "show_activity_in_newsfeed",                 :default => true
    t.boolean "show_activity_in_myfeed",                   :default => true
    t.integer "home_display",                              :default => 1,     :null => false
    t.integer "home_maximize",                             :default => 1,     :null => false
    t.integer "home_column",                               :default => 1,     :null => false
    t.integer "home_row",                                  :default => 1,     :null => false
    t.integer "profile_display",                           :default => 1,     :null => false
    t.integer "profile_maximize",                          :default => 1,     :null => false
    t.integer "profile_column",                            :default => 1,     :null => false
    t.integer "profile_row",                               :default => 1,     :null => false
    t.string  "who_can_see",               :limit => 4000
    t.boolean "home_expanded",                             :default => true
    t.boolean "profile_expanded",                          :default => true
    t.integer "menu_order",                                :default => 1,     :null => false
  end

  create_table "chat_attendees", :force => true do |t|
    t.integer  "chat_id"
    t.integer  "user_profile_id"
    t.boolean  "in_panel",        :default => false
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "token"
    t.boolean  "participated"
  end

  create_table "chat_invitations", :force => true do |t|
    t.integer  "chat_id"
    t.integer  "invited_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "inviter_id"
  end

  create_table "chat_messages", :force => true do |t|
    t.string   "body",            :limit => 4000
    t.integer  "user_profile_id"
    t.boolean  "private",                         :default => false
    t.integer  "chat_id"
    t.string   "state",                           :default => "asked"
    t.string   "event"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "chat_messages", ["chat_id", "updated_at"], :name => "idx_chat_id_updated"
  add_index "chat_messages", ["private", "state", "user_profile_id"], :name => "idx_private_state_user"

  create_table "chats", :force => true do |t|
    t.string   "name"
    t.text     "description"
    t.integer  "group_id"
    t.integer  "active_user_id"
    t.integer  "active_message_id"
    t.integer  "creator_id"
    t.datetime "start_at"
    t.datetime "end_at"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "seed"
  end

  add_index "chats", ["group_id", "start_at", "end_at"], :name => "idx_group_start_end"

  create_table "clobs", :force => true do |t|
    t.integer "post_id", :null => false
    t.text    "body"
  end

  add_index "clobs", ["post_id"], :name => "clobs_post"

  create_table "comatose_page_versions", :force => true do |t|
    t.integer  "comatose_page_id"
    t.integer  "version"
    t.integer  "parent_id"
    t.text     "full_path"
    t.string   "title"
    t.string   "slug"
    t.string   "keywords"
    t.text     "body"
    t.string   "filter_type",      :limit => 25, :default => "Textile"
    t.string   "author"
    t.integer  "position",                       :default => 0
    t.datetime "updated_on"
    t.datetime "created_on"
  end

  create_table "comatose_pages", :force => true do |t|
    t.integer  "parent_id"
    t.text     "full_path"
    t.string   "title"
    t.string   "slug"
    t.string   "keywords"
    t.text     "body"
    t.string   "filter_type", :limit => 25, :default => "Textile"
    t.string   "author"
    t.integer  "position",                  :default => 0
    t.integer  "version"
    t.datetime "updated_on"
    t.datetime "created_on"
  end

  create_table "connect_import_info", :force => true do |t|
    t.datetime "imported_at"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "direct_messages", :force => true do |t|
    t.string   "subject"
    t.string   "content",         :limit => 4000
    t.integer  "sender_id"
    t.integer  "receiver_id"
    t.boolean  "receiver_read"
    t.datetime "created_at"
    t.integer  "thread_id"
    t.integer  "replies_count",                   :default => 0
    t.datetime "replied_at"
    t.boolean  "sender_read",                     :default => true
    t.boolean  "replied",                         :default => false
    t.boolean  "sender_hidden",                   :default => false
    t.boolean  "receiver_hidden",                 :default => false
  end

  add_index "direct_messages", ["sender_id"], :name => "idx_sender"
  add_index "direct_messages", ["thread_id", "sender_id", "receiver_id"], :name => "idx_thread"

  create_table "domains", :force => true do |t|
    t.string "name"
  end

  create_table "emails", :force => true do |t|
    t.string   "from"
    t.string   "to"
    t.integer  "last_send_attempt", :default => 0
    t.text     "mail"
    t.datetime "created_on"
  end

  create_table "favorites", :force => true do |t|
    t.integer  "user_profile_id"
    t.integer  "idea_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "favorites", ["user_profile_id", "idea_id"], :name => "fui_u", :unique => true

  create_table "flags", :force => true do |t|
    t.integer  "user_id"
    t.integer  "flaggable_id"
    t.string   "flaggable_type"
    t.integer  "flaggable_user_id"
    t.string   "reason"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "child_class"
  end

  create_table "group_invitations", :force => true do |t|
    t.integer  "group_id"
    t.integer  "user_profile_id"
    t.string   "key"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "inviter_id"
  end

  create_table "group_join_requests", :force => true do |t|
    t.integer  "user_profile_id"
    t.integer  "group_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "group_join_requests", ["user_profile_id", "group_id"], :name => "gjr_u", :unique => true

  create_table "groups", :force => true do |t|
    t.text     "description"
    t.string   "name"
    t.integer  "owner_id"
    t.boolean  "private"
    t.integer  "members_count",     :default => 0, :null => false
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "icon_file_name"
    t.string   "icon_content_type"
    t.integer  "icon_file_size"
    t.integer  "cache_version"
  end

  create_table "groups_posts", :force => true do |t|
    t.integer "group_id"
    t.integer "post_id"
  end

  add_index "groups_posts", ["group_id", "post_id"], :name => "gp_u", :unique => true

  create_table "groups_products", :id => false, :force => true do |t|
    t.integer "group_id"
    t.integer "product_id"
  end

  create_table "groups_user_profiles", :force => true do |t|
    t.integer "group_id"
    t.integer "user_profile_id"
    t.string  "role",            :limit => 15, :default => "member", :null => false
  end

  add_index "groups_user_profiles", ["group_id"], :name => "gup_gid"
  add_index "groups_user_profiles", ["user_profile_id", "group_id"], :name => "gup_u", :unique => true

  create_table "images", :force => true do |t|
    t.integer  "parent_id"
    t.string   "content_type"
    t.string   "filename"
    t.string   "thumbnail"
    t.integer  "file_size"
    t.integer  "width"
    t.integer  "height"
    t.integer  "imaged_resource_id"
    t.string   "imaged_resource_type"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "v1_image_id"
    t.integer  "v1_parent_id"
    t.string   "v1_full_path"
  end

  add_index "images", ["v1_image_id"], :name => "images_v1_image"

  create_table "invitations", :force => true do |t|
    t.integer  "from_id"
    t.integer  "to_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "locations", :force => true do |t|
    t.integer  "user_profile_id"
    t.string   "address"
    t.float    "lat"
    t.float    "lng"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "messages", :force => true do |t|
    t.integer  "group_id",        :null => false
    t.integer  "user_profile_id", :null => false
    t.string   "title",           :null => false
    t.text     "body"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "network_user_profiles", :id => false, :force => true do |t|
    t.integer "user_profile_id"
    t.integer "contact_id"
  end

  add_index "network_user_profiles", ["user_profile_id", "contact_id"], :name => "index_network_user_profiles", :unique => true

  create_table "new_products", :force => true do |t|
    t.string  "name"
    t.integer "parent_id"
    t.integer "lft"
    t.integer "rgt"
  end

  create_table "page_versions", :force => true do |t|
    t.integer  "page_id"
    t.integer  "version"
    t.integer  "parent_id",   :limit => 8
    t.string   "full_path",                 :default => ""
    t.string   "title"
    t.string   "slug"
    t.string   "keywords"
    t.text     "body"
    t.string   "filter_type", :limit => 25, :default => "Textile"
    t.string   "author"
    t.integer  "position",    :limit => 8,  :default => 0
    t.datetime "updated_on"
    t.datetime "created_on"
  end

  create_table "pages", :force => true do |t|
    t.string   "title"
    t.string   "wiki_title"
    t.text     "body"
    t.text     "body_html"
    t.integer  "user_profile_id"
    t.string   "author_type"
    t.integer  "author_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "posts", :force => true do |t|
    t.integer  "parent_id"
    t.string   "permalink"
    t.string   "summary"
    t.string   "type",                               :null => false
    t.integer  "user_profile_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "comments_count",  :default => 0
    t.integer  "ratings_count",   :default => 0
    t.boolean  "private",         :default => false
    t.integer  "v1_post_id"
    t.string   "format"
    t.boolean  "listens",         :default => false
    t.boolean  "expert"
    t.string   "sha1"
    t.boolean  "expert_replied"
  end

  add_index "posts", ["parent_id"], :name => "posts_v1_post_parent"
  add_index "posts", ["permalink"], :name => "index_posts_on_permalink"
  add_index "posts", ["user_profile_id"], :name => "posts_user_profile"
  add_index "posts", ["v1_post_id"], :name => "posts_v1_post"

  create_table "posts_products", :id => false, :force => true do |t|
    t.integer "post_id"
    t.integer "product_id"
    t.integer "new_product_id"
  end

  create_table "products", :force => true do |t|
    t.string  "name"
    t.integer "parent_id"
    t.integer "lft"
    t.integer "rgt"
  end

  create_table "products_user_profiles", :id => false, :force => true do |t|
    t.integer "user_profile_id"
    t.integer "product_id"
    t.integer "new_product_id"
  end

  create_table "profile_statuses", :force => true do |t|
    t.string   "status"
    t.integer  "user_profile_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "profile_statuses", ["user_profile_id"], :name => "profiles_status_user"

  create_table "ratings", :force => true do |t|
    t.integer  "rating",                        :default => 1
    t.string   "rateable_type",   :limit => 15, :default => "", :null => false
    t.integer  "rateable_id",                   :default => 0,  :null => false
    t.integer  "user_profile_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "ratings", ["user_profile_id", "rateable_type", "rateable_id"], :name => "validates_uniqueness", :unique => true
  add_index "ratings", ["user_profile_id"], :name => "fk_ratings_user"

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

  add_index "sessions", ["session_id"], :name => "sessions_ix1"
  add_index "sessions", ["updated_at"], :name => "sessions_ix2"

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

  add_index "taggings", ["tag_id"], :name => "fk_taggings_tag"
  add_index "taggings", ["taggable_id", "taggable_type"], :name => "taggings_ix1"

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

  create_table "user_profiles", :force => true do |t|
    t.boolean  "admin",                                       :default => false
    t.boolean  "active",                                      :default => false
    t.boolean  "new_user",                                    :default => true
    t.boolean  "oracle_employee",                             :default => false
    t.string   "city"
    t.string   "country"
    t.string   "dn"
    t.string   "given_name"
    t.string   "guid"
    t.string   "industry"
    t.string   "key"
    t.string   "login"
    t.string   "organization"
    t.string   "permalink"
    t.string   "surname"
    t.string   "title",                        :limit => 500
    t.datetime "created_at"
    t.datetime "updated_at"
    t.boolean  "email_confirmed",                             :default => false
    t.string   "email"
    t.string   "work_phone"
    t.string   "mobile_phone"
    t.string   "other"
    t.string   "protection",                                  :default => "network only", :null => false
    t.integer  "unread_direct_messages_count",                :default => 0
    t.boolean  "skip_dm_notifications",                       :default => false
    t.datetime "last_digest"
    t.string   "digest_type",                                 :default => "instantly"
    t.integer  "v1_user_id"
    t.integer  "v1_person_id"
    t.integer  "v1_manager_id"
    t.integer  "manager_id"
    t.string   "work_floor"
    t.string   "work_office"
    t.string   "work_address1"
    t.string   "work_address2"
    t.string   "work_address3"
    t.string   "work_city"
    t.string   "work_state"
    t.string   "work_zip"
    t.string   "work_country"
    t.string   "work_county"
    t.string   "cost_center"
    t.string   "userid"
    t.integer  "directs"
    t.integer  "total_reports"
    t.string   "manager_name"
    t.integer  "personid"
    t.string   "phone_home_office"
    t.string   "phone_mobile"
    t.string   "phone_fax"
    t.string   "phone_other"
    t.string   "im_yahoo"
    t.string   "im_aol"
    t.string   "im_google"
    t.string   "im_microsoft"
    t.string   "im_jabber"
    t.string   "im_icq"
    t.string   "webpage"
    t.string   "im_skype"
    t.string   "avatar_file_name"
    t.string   "avatar_content_type"
    t.integer  "avatar_file_size"
    t.string   "default_activity_scope"
    t.boolean  "expert"
    t.string   "address"
    t.float    "lat"
    t.float    "lng"
  end

  add_index "user_profiles", ["dn"], :name => "user_profiles_idx3"
  add_index "user_profiles", ["email"], :name => "profiles_email"
  add_index "user_profiles", ["guid"], :name => "user_profiles_idx2"
  add_index "user_profiles", ["login"], :name => "index_user_profiles_on_login", :unique => true
  add_index "user_profiles", ["manager_id"], :name => "profiles_manager"
  add_index "user_profiles", ["organization"], :name => "user_profiles_idx4"
  add_index "user_profiles", ["personid"], :name => "profiles_person_id"
  add_index "user_profiles", ["v1_manager_id"], :name => "profiles_v1_manager"
  add_index "user_profiles", ["v1_person_id"], :name => "profiles_v1_person"
  add_index "user_profiles", ["v1_user_id"], :name => "profiles_v1_user"

end