Commit 511a27f

mo khan <mo@mokhan.ca>
2015-05-31 03:19:47
add timestamps to users table and migrate existing users.
1 parent e2d6534
db/migrate/20150530181053_add_timestamps_to_users.rb
@@ -1,7 +1,21 @@
 class AddTimestampsToUsers < ActiveRecord::Migration
-  def change
+  def up
     change_table :users do |t|
-      t.timestamps null: false, default: DateTime.now.utc
+      t.timestamps null: true
     end
+    User.reset_column_information
+
+    User.find_each do |user|
+      user.created_at = user.updated_at = DateTime.now.utc
+      user.save!
+    end
+
+    change_column :users, :created_at, :datetime, null: false
+    change_column :users, :updated_at, :datetime, null: false
+  end
+
+  def down
+    remove_column :users, :created_at
+    remove_column :users, :updated_at
   end
 end
db/schema.rb
@@ -62,11 +62,11 @@ ActiveRecord::Schema.define(version: 20150530181053) do
   add_index "training_sessions", ["user_id"], name: "index_training_sessions_on_user_id", using: :btree
 
   create_table "users", id: :uuid, default: "uuid_generate_v4()", force: :cascade do |t|
-    t.string   "username",                                        null: false
-    t.string   "email",                                           null: false
+    t.string   "username",        null: false
+    t.string   "email",           null: false
     t.string   "password_digest"
-    t.datetime "created_at",      default: '2015-05-30 18:13:17', null: false
-    t.datetime "updated_at",      default: '2015-05-30 18:13:17', null: false
+    t.datetime "created_at",      null: false
+    t.datetime "updated_at",      null: false
   end
 
   create_table "workouts", id: :uuid, default: "uuid_generate_v4()", force: :cascade do |t|