db/schema.rb in parlement-0.3 vs db/schema.rb in parlement-0.4
- old
+ new
@@ -1,50 +1,55 @@
# 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
+ActiveRecord::Schema.define(:version => 0) 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 "created_on", :datetime, :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
+ t.column "created_on", :datetime, :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 "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, :default => Tue Feb 07 10:25:26 CET 2006, :null => false
+ t.column "created_on", :datetime, :null => false
t.column "person_id", :text
t.column "subject", :text
t.column "body", :text
end
+ 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 "people", :force => true do |t|
- t.column "created_on", :datetime, :default => Tue Feb 07 10:25:26 CET 2006, :null => false
+ t.column "created_on", :datetime, :null => false
t.column "name", :text
t.column "email", :text
end
add_index "people", ["name"], :name => "people_name_key", :unique => true
@@ -53,19 +58,22 @@
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 "login", :string, :limit => 80, :default => "", :null => false
+ t.column "salted_password", :string, :limit => 40, :default => "", :null => false
+ t.column "email", :string, :limit => 60, :default => "", :null => false
t.column "firstname", :string, :limit => 40
t.column "lastname", :string, :limit => 40
- t.column "salt", :string, :limit => 40, :null => false
+ t.column "salt", :string, :limit => 40, :default => "", :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 "created_at", :datetime
+ t.column "updated_at", :datetime
+ t.column "logged_in_at", :datetime
t.column "deleted", :integer, :default => 0
t.column "delete_after", :datetime
end
create_table "usersold", :force => true do |t|