From: Tom Hughes <tom@compton.nu>
Date: Mon, 20 Apr 2009 13:39:20 +0000 (+0000)
Subject: Add changeset indexes to nodes, ways and relations.
X-Git-Tag: live~7610
X-Git-Url: https://git.openstreetmap.org/rails.git/commitdiff_plain/7c791f302c68be7110deabe73d7c8db97d1d13ef

Add changeset indexes to nodes, ways and relations.
---

diff --git a/db/migrate/027_add_changeset_indexes.rb b/db/migrate/027_add_changeset_indexes.rb
new file mode 100644
index 000000000..0d4bba0e8
--- /dev/null
+++ b/db/migrate/027_add_changeset_indexes.rb
@@ -0,0 +1,13 @@
+class AddChangesetIndexes < ActiveRecord::Migration
+  def self.up
+    add_index "nodes", ["changeset_id"], :name => "nodes_changeset_id_idx"
+    add_index "ways", ["changeset_id"], :name => "ways_changeset_id_idx"
+    add_index "relations", ["changeset_id"], :name => "relations_changeset_id_idx"
+  end
+
+  def self.down
+    remove_index "relations", :name => "relations_changeset_id_idx"
+    remove_index "ways", :name => "ways_changeset_id_idx"
+    remove_index "nodes", :name => "nodes_changeset_id_idx"
+  end
+end