[myexperiment-hackers] [2175] branches/event_logging/db/migrate/ 075_add_indexes_to_activity_log_table.rb: Added indexes on the activity logs table.

[noreply]

Revision

2175

Author

dtm

Date

2009-04-22 08:29:31 -0400 (Wed, 22 Apr 2009)

Log Message

Added indexes on the activity logs table.

Added Paths

• branches/event_logging/db/migrate/075_add_indexes_to_activity_log_table.rb

Diff

Added: branches/event_logging/db/migrate/075_add_indexes_to_activity_log_table.rb (0 => 2175)

--- branches/event_logging/db/migrate/075_add_indexes_to_activity_log_table.rb	                        (rev 0)
+++ branches/event_logging/db/migrate/075_add_indexes_to_activity_log_table.rb	2009-04-22 12:29:31 UTC (rev 2175)
@@ -0,0 +1,17 @@
+class AddIndexesToActivityLogTable < ActiveRecord::Migration
+  def self.up
+
+    add_index :activity_logs, ["activity_loggable_id","activity_loggable_type"], :name => "activity_logs_activity_loggable_index"
+    add_index :activity_logs, ["referenced_id","referenced_type"], :name     => "activity_logs_referenced_index"
+    add_index :activity_logs, ["culprit_id","culprit_type"], :name =>     "activity_logs_culprit_index"
+
+  end
+
+  def self.down
+
+    remove_index :activity_logs, :name => "activity_logs_activity_loggable_index"
+    remove_index :activity_logs, :name => "activity_logs_referenced_index"
+    remove_index :activity_logs, :name => "activity_logs_culprit_index"
+
+  end
+end