From: Tom Hughes <tom@compton.nu>
Date: Fri, 12 Dec 2008 15:43:02 +0000 (+0000)
Subject: Add some extra indexes.
X-Git-Tag: live~7654
X-Git-Url: https://git.openstreetmap.org/rails.git/commitdiff_plain/66a2558e65ff6d2b786ce9673639d74b985c934f

Add some extra indexes.
---

diff --git a/db/migrate/017_add_gpx_indexes.rb b/db/migrate/017_add_gpx_indexes.rb
new file mode 100644
index 000000000..1778dcc75
--- /dev/null
+++ b/db/migrate/017_add_gpx_indexes.rb
@@ -0,0 +1,11 @@
+class AddGpxIndexes < ActiveRecord::Migration
+  def self.up
+    add_index "gpx_files", ["user_id"], :name => "gpx_files_user_id_idx"
+    add_index "gpx_file_tags", ["tag"], :name => "gpx_file_tags_tag_idx"
+  end
+
+  def self.down
+    remove_index "gpx_file_tags", :name => "gpx_file_tags_tag_idx"
+    remove_index "gpx_files", :name => "gpx_files_user_id_idx"
+  end
+end