From: Tom Hughes <tom@compton.nu>
Date: Thu, 13 May 2010 17:16:31 +0000 (+0100)
Subject: Add user_id + created_at index to changesets
X-Git-Tag: live~6324^2~2
X-Git-Url: https://git.openstreetmap.org/rails.git/commitdiff_plain/594960dc63f1e627efbdd24e1a3d3d6203655a68?hp=c81b5ab1ac321d383d01b3c795f911a9727d54d3

Add user_id + created_at index to changesets

Browsing changesets for a user will be much faster if we can get the
user's changesets in date order.
---

diff --git a/db/migrate/20100513171259_add_user_date_index_to_changeset.rb b/db/migrate/20100513171259_add_user_date_index_to_changeset.rb
new file mode 100644
index 000000000..22e1f08fb
--- /dev/null
+++ b/db/migrate/20100513171259_add_user_date_index_to_changeset.rb
@@ -0,0 +1,9 @@
+class AddUserDateIndexToChangeset < ActiveRecord::Migration
+  def self.up
+    add_index :changesets, [:user_id, :created_at], :name => "changesets_user_id_created_at_idx"
+  end
+
+  def self.down
+    remove_index :changesets, [:user_id, :created_at], :name => "changesets_user_id_created_at_idx"
+  end
+end