Added: trunk/db/migrate/087_add_indexes_to_viewings_downloads.rb (0 => 2469)
--- trunk/db/migrate/087_add_indexes_to_viewings_downloads.rb (rev 0)
+++ trunk/db/migrate/087_add_indexes_to_viewings_downloads.rb 2010-07-12 12:09:35 UTC (rev 2469)
@@ -0,0 +1,15 @@
+class AddIndexesToViewingsDownloads < ActiveRecord::Migration
+ def self.up
+
+ add_index :viewings, ["contribution_id"]
+ add_index :downloads, ["contribution_id"]
+
+ end
+
+ def self.down
+
+ remove_index :viewings, ["contribution_id"]
+ remove_index :downloads, ["contribution_id"]
+
+ end
+end