Add created_at and updated_at fields to appropriate models.

1 files changed, 36 insertions, 0 deletions

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