[myexperiment-hackers] [2418] trunk/db/migrate/085_add_index_to_profiles_table.rb: Add index for user_id on profiles.

[noreply]

Revision

2418

Author

dtm

Date

2010-05-27 08:50:49 -0400 (Thu, 27 May 2010)

Log Message

Add index for user_id on profiles.

Added Paths

• trunk/db/migrate/085_add_index_to_profiles_table.rb

Diff

Added: trunk/db/migrate/085_add_index_to_profiles_table.rb (0 => 2418)

--- trunk/db/migrate/085_add_index_to_profiles_table.rb	                        (rev 0)
+++ trunk/db/migrate/085_add_index_to_profiles_table.rb	2010-05-27 12:50:49 UTC (rev 2418)
@@ -0,0 +1,13 @@
+class AddIndexToProfilesTable < ActiveRecord::Migration
+  def self.up
+
+    add_index :profiles, ["user_id"], :name => "index_profiles_on_user_id"
+
+  end
+
+  def self.down
+
+    remove_index :profiles, :name => "index_profiles_on_user_id"
+
+  end
+end