3 files changed, 45 insertions, 2 deletions
diff --git a/db/migrate/010_remove_public_body_id_from_outgoing_messages.rb b/db/migrate/010_remove_public_body_id_from_outgoing_messages.rb
index d39cb4e70..da5ffc87e 100644
--- a/db/migrate/010_remove_public_body_id_from_outgoing_messages.rb
+++ b/db/migrate/010_remove_public_body_id_from_outgoing_messages.rb
@@ -4,6 +4,6 @@ class RemovePublicBodyIdFromOutgoingMessages < ActiveRecord::Migration
   end
 
   def self.down
-    add_column :ourgoing_messages, :public_body_id, :integer
+    add_column :outgoing_messages, :public_body_id, :integer
   end
 end
diff --git a/db/migrate/011_add_created_updated_fields.rb b/db/migrate/011_add_created_updated_fields.rb
new file mode 100644
index 000000000..47bb27b78
--- /dev/null
+++ b/db/migrate/011_add_created_updated_fields.rb
@@ -0,0 +1,36 @@
+class AddCreatedUpdatedFields < ActiveRecord::Migration
+  def self.up
+    # InfoRequest
+    add_column :info_requests, :created_at, :datetime
+    add_column :info_requests, :updated_at, :datetime
+
+    # Outgoing Message already has it
+    
+    # PublicBody
+    add_column :public_bodies, :created_at, :datetime
+    add_column :public_bodies, :updated_at, :datetime
+
+    # PublicBodyVersion doesn't need it
+
+    # Session
+    add_column :sessions, :created_at, :datetime
+
+    # Users
+    add_column :users, :created_at, :datetime
+    add_column :users, :updated_at, :datetime
+
+  end
+
+  def self.down
+    remove_column :info_requests, :created_at
+    remove_column :info_requests, :updated_at
+
+    remove_column :public_bodies, :created_at
+    remove_column :public_bodies, :updated_at
+
+    remove_column :sessions, :created_at
+
+    remove_column :users, :created_at
+    remove_column :users, :updated_at
+   end
+end
diff --git a/db/schema.rb b/db/schema.rb
index e3fdbce13..04f4a49fd 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -2,12 +2,14 @@
 # migrations feature of ActiveRecord to incrementally modify your database, and
 # then regenerate this schema definition.
 
-ActiveRecord::Schema.define(:version => 10) do
+ActiveRecord::Schema.define(:version => 11) do
 
   create_table "info_requests", :force => true do |t|
     t.column "title",          :text
     t.column "user_id",        :integer
     t.column "public_body_id", :integer
+    t.column "created_at",     :datetime
+    t.column "updated_at",     :datetime
   end
 
   create_table "outgoing_messages", :force => true do |t|
@@ -27,6 +29,8 @@ ActiveRecord::Schema.define(:version => 10) do
     t.column "version",           :integer
     t.column "last_edit_editor",  :string
     t.column "last_edit_comment", :string
+    t.column "created_at",        :datetime
+    t.column "updated_at",        :datetime
   end
 
   create_table "public_body_versions", :force => true do |t|
@@ -45,6 +49,7 @@ ActiveRecord::Schema.define(:version => 10) do
     t.column "session_id", :string
     t.column "data",       :text
     t.column "updated_at", :datetime
+    t.column "created_at", :datetime
   end
 
   add_index "sessions", ["session_id"], :name => "index_sessions_on_session_id"
@@ -55,6 +60,8 @@ ActiveRecord::Schema.define(:version => 10) do
     t.column "name",            :string
     t.column "hashed_password", :string
     t.column "salt",            :string
+    t.column "created_at",      :datetime
+    t.column "updated_at",      :datetime
   end
 
 end