From: Tom Hughes <tom@compton.nu>
Date: Mon, 3 Aug 2009 23:04:41 +0000 (+0000)
Subject: Add an index on message sender.
X-Git-Tag: live~6805
X-Git-Url: https://git.openstreetmap.org/rails.git/commitdiff_plain/72402ebc3e6a75748e208758017f5aa95c9ff680

Add an index on message sender.
---

diff --git a/db/migrate/038_add_message_sender_index.rb b/db/migrate/038_add_message_sender_index.rb
new file mode 100644
index 000000000..2b9b134cd
--- /dev/null
+++ b/db/migrate/038_add_message_sender_index.rb
@@ -0,0 +1,9 @@
+class AddMessageSenderIndex < ActiveRecord::Migration
+  def self.up
+    add_index :messages, [:from_user_id], :name=> "messages_from_user_id_idx"
+  end
+
+  def self.down
+    drop_index :messages, :name=> "messages_from_user_id_idx"
+  end
+end