add creations counter_cache

1 files changed, 13 insertions, 0 deletions

diff --git a/db/migrate/20130706103848_add_creations_count_to_users.rb b/db/migrate/20130706103848_add_creations_count_to_users.rb
new file mode 100644
index 00000000..e7f7b048
--- /dev/null
+++ b/db/migrate/20130706103848_add_creations_count_to_users.rb
@@ -0,0 +1,13 @@
+class AddCreationsCountToUsers < ActiveRecord::Migration
+  def up
+    add_column :users, :creations_count, :integer, :default => 0
+    User.reset_column_information
+    User.find_each do |user|
+      User.reset_counters user.id, :creations
+    end
+  end
+
+  def down
+    remove_column :users, :creations_count
+  end
+end