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

  create_table "addresses", :force => true do |t|
    t.column "address",    :text
    t.column "category",   :string
    t.column "default",    :boolean
    t.column "contact_id", :integer
  end

  create_table "contact_data", :force => true do |t|
    t.column "category",   :string,  :limit => 20
    t.column "is_default", :boolean
    t.column "name",       :string
    t.column "value",      :text
    t.column "type",       :string,  :limit => 20
    t.column "contact_id", :integer
  end

  create_table "contacts", :force => true do |t|
    t.column "name",            :string
    t.column "handle",          :string
    t.column "title",           :string
    t.column "birthday",        :date
    t.column "last_viewed",     :datetime
    t.column "updated_at",      :datetime
    t.column "organization_id", :integer
    t.column "source",          :string
    t.column "user_id",         :integer
  end

  create_table "contacts_organizations", :id => false, :force => true do |t|
    t.column "contact_id",      :integer
    t.column "organization_id", :integer
  end

  create_table "emails", :force => true do |t|
    t.column "email",      :string
    t.column "category",   :string
    t.column "main",       :boolean
    t.column "contact_id", :integer
  end

  create_table "instant_messages", :force => true do |t|
  end

  create_table "open_id_authentication_associations", :force => true do |t|
    t.column "server_url", :binary
    t.column "handle",     :string
    t.column "secret",     :binary
    t.column "issued",     :integer
    t.column "lifetime",   :integer
    t.column "assoc_type", :string
  end

  create_table "open_id_authentication_nonces", :force => true do |t|
    t.column "nonce",   :string
    t.column "created", :integer
  end

  create_table "open_id_authentication_settings", :force => true do |t|
    t.column "setting", :string
    t.column "value",   :binary
  end

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

  create_table "phones", :force => true do |t|
    t.column "number",     :string
    t.column "category",   :string
    t.column "main",       :boolean
    t.column "contact_id", :integer
  end

  create_table "photos", :force => true do |t|
    t.column "contact_id",   :integer
    t.column "path",         :string
    t.column "content_type", :string,   :limit => 40
    t.column "created_at",   :datetime
    t.column "updated_at",   :datetime
  end

  create_table "taggings", :force => true do |t|
    t.column "tag_id",        :integer,                 :null => false
    t.column "taggable_id",   :integer,                 :null => false
    t.column "taggable_type", :string,  :default => "", :null => false
  end

  add_index "taggings", ["tag_id", "taggable_id", "taggable_type"], :name => "index_taggings_on_tag_id_and_taggable_id_and_taggable_type", :unique => true

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

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

  create_table "urls", :force => true do |t|
    t.column "url",        :string
    t.column "label",      :string
    t.column "contact_id", :integer
  end

  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 "updated_at",           :datetime
    t.column "details_id",           :integer
    t.column "login_key",            :string
    t.column "login_key_expires_at", :datetime
    t.column "activated",            :boolean,  :default => false
    t.column "identity_url",         :string
  end

end