Add some indexes to help IncomingMessage.fully_destroy find records more efficiently by info_request_event_id

2 files changed, 18 insertions, 0 deletions

diff --git a/db/migrate/20120913080807_add_info_request_event_index_to_track_things_sent_emails.rb b/db/migrate/20120913080807_add_info_request_event_index_to_track_things_sent_emails.rb
new file mode 100644
index 000000000..d119f55b3
--- /dev/null
+++ b/db/migrate/20120913080807_add_info_request_event_index_to_track_things_sent_emails.rb
@@ -0,0 +1,9 @@
+class AddInfoRequestEventIndexToTrackThingsSentEmails < ActiveRecord::Migration
+  def self.up
+      add_index :track_things_sent_emails, :info_request_event_id
+  end
+
+  def self.down
+      remove_index :track_things_sent_emails, :info_request_event_id
+  end
+end
diff --git a/db/migrate/20120913081136_add_info_request_event_index_to_user_info_request_sent_alerts.rb b/db/migrate/20120913081136_add_info_request_event_index_to_user_info_request_sent_alerts.rb
new file mode 100644
index 000000000..aa9f404f7
--- /dev/null
+++ b/db/migrate/20120913081136_add_info_request_event_index_to_user_info_request_sent_alerts.rb
@@ -0,0 +1,9 @@
+class AddInfoRequestEventIndexToUserInfoRequestSentAlerts < ActiveRecord::Migration
+  def self.up
+      add_index :user_info_request_sent_alerts, :info_request_event_id
+  end
+
+  def self.down
+      remove_index :user_info_request_sent_alerts, :info_request_event_id
+  end
+end