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

  create_table "attachments", :force => true do |t|
    t.column "elt_id",       :text,     :null => false
    t.column "created_on",   :datetime, :null => false
    t.column "content_type", :text
    t.column "file",         :text
  end

  create_table "choices", :force => true do |t|
    t.column "elt_id",     :string,                  :null => false
    t.column "person_id",  :string
    t.column "created_on", :datetime,                :null => false
    t.column "value",      :integer,  :default => 1, :null => false
  end

  add_index "choices", ["elt_id", "person_id"], :name => "elt_person_key", :unique => true

  create_table "delegations", :force => true do |t|
    t.column "elt_id",      :text,                        :null => false
    t.column "person_id",   :text,                        :null => false
    t.column "created_on",  :datetime,                    :null => false
    t.column "temporary",   :boolean,  :default => false, :null => false
    t.column "delegate_to", :text,                        :null => false
  end

  create_table "elts", :force => true do |t|
    t.column "parent_id",     :text
    t.column "position",      :float
    t.column "created_on",    :datetime,                :null => false
    t.column "person_id",     :text
    t.column "subject",       :text
    t.column "body",          :text
    t.column "lft",           :integer
    t.column "rgt",           :integer
    t.column "elts_count",    :integer,  :default => 0
    t.column "last_activity", :datetime
  end

  add_index "elts", ["parent_id"], :name => "elts_parent"
  add_index "elts", ["parent_id"], :name => "elts_parent_key"
  add_index "elts", ["lft"], :name => "lft"
  add_index "elts", ["rgt"], :name => "rgt"

  create_table "engine_schema_info", :id => false, :force => true do |t|
    t.column "engine_name", :string
    t.column "version",     :integer
  end

  create_table "mails", :force => true do |t|
    t.column "elt_id",       :text, :null => false
    t.column "message",      :text
    t.column "mail_parents", :text
    t.column "file",         :text
  end

  create_table "old_visits", :force => true do |t|
    t.column "person_id",  :string
    t.column "elt_id",     :string,                  :null => false
    t.column "created_on", :datetime,                :null => false
    t.column "updated_on", :datetime
    t.column "filter",     :integer,  :default => 0
  end

  add_index "old_visits", ["person_id", "elt_id"], :name => "old_visits_elt_person_key", :unique => true

  create_table "people", :force => true do |t|
    t.column "created_on", :datetime, :null => false
    t.column "name",       :text
    t.column "email",      :text
    t.column "image",      :text
    t.column "last_login", :datetime
  end

  add_index "people", ["name"], :name => "people_name_key", :unique => true

  create_table "person_mails", :force => true do |t|
    t.column "mail_id",    :string,   :null => false
    t.column "person_id",  :string
    t.column "created_on", :datetime, :null => false
  end

  create_table "subscriptions", :force => true do |t|
    t.column "elt_id",     :text,                    :null => false
    t.column "person_id",  :text,                    :null => false
    t.column "filter",     :integer,  :default => 0
    t.column "created_on", :datetime,                :null => false
  end

  create_table "users", :force => true do |t|
    t.column "login",           :text,                                  :null => false
    t.column "salted_password", :string,   :limit => 40,                :null => false
    t.column "email",           :string,   :limit => 60
    t.column "firstname",       :string,   :limit => 40
    t.column "lastname",        :string,   :limit => 40
    t.column "salt",            :string,   :limit => 40,                :null => false
    t.column "verified",        :integer,                :default => 0
    t.column "role",            :string,   :limit => 40
    t.column "security_token",  :string,   :limit => 40
    t.column "token_expiry",    :datetime
    t.column "deleted",         :integer,                :default => 0
    t.column "delete_after",    :datetime
  end

  create_table "usersold", :force => true do |t|
    t.column "person_id",       :text,                   :null => false
    t.column "salted_password", :text
    t.column "salt",            :text
    t.column "verified",        :integer, :default => 0
    t.column "new_email",       :text
    t.column "security_token",  :text
  end

  add_index "usersold", ["person_id"], :name => "usersold_person_id_key", :unique => true

  create_table "visits", :force => true do |t|
    t.column "person_id",  :string
    t.column "elt_id",     :string,                  :null => false
    t.column "created_on", :datetime,                :null => false
    t.column "updated_on", :datetime
    t.column "filter",     :integer,  :default => 0
  end

  add_index "visits", ["person_id", "elt_id"], :name => "visits_elt_person_key", :unique => true

end