# 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() do

  create_table "attachments", :force => true do |t|
    t.column "elt_id", :text, :null => false
    t.column "created_on", :datetime, :default => Tue Feb 07 10:25:26 CET 2006, :null => false
    t.column "content_type", :text
    t.column "file", :text
  end

  create_table "choices", :id => false, :force => true do |t|
    t.column "elt_id", :text, :null => false
    t.column "person_id", :text, :null => false
    t.column "created_on", :datetime, :default => Tue Feb 07 10:25:26 CET 2006, :null => false
  end

  create_table "delegations", :id => false, :force => true do |t|
    t.column "elt_id", :text, :null => false
    t.column "person_id", :text, :null => false
    t.column "created_on", :datetime, :default => Tue Feb 07 10:25:26 CET 2006, :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, :default => Tue Feb 07 10:25:26 CET 2006, :null => false
    t.column "person_id", :text
    t.column "subject", :text
    t.column "body", :text
  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 "people", :force => true do |t|
    t.column "created_on", :datetime, :default => Tue Feb 07 10:25:26 CET 2006, :null => false
    t.column "name", :text
    t.column "email", :text
  end

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

  create_table "subscribers", :id => false, :force => true do |t|
    t.column "elt_id", :text, :null => false
    t.column "person_id", :text, :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

end