From 38b7137fe3c5e88b0551c536aa1087a0b32145f4 Mon Sep 17 00:00:00 2001
From: Tom Hughes <tom@compton.nu>
Date: Mon, 7 Jan 2008 00:30:44 +0000
Subject: [PATCH] Add migration to add an index on node_id to way_nodes. This
 index was added to the live database a month or so back to support rollback
 in Potlatch.

---
 db/migrate/009_way_nodes_node_idx.rb | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 db/migrate/009_way_nodes_node_idx.rb

diff --git a/db/migrate/009_way_nodes_node_idx.rb b/db/migrate/009_way_nodes_node_idx.rb
new file mode 100644
index 000000000..41b7c9fcd
--- /dev/null
+++ b/db/migrate/009_way_nodes_node_idx.rb
@@ -0,0 +1,9 @@
+class WayNodesNodeIdx  < ActiveRecord::Migration
+  def self.up
+    add_index "way_nodes", ["node_id"], :name => "way_nodes_node_idx"
+  end
+
+  def self.down
+    remove_index "way_nodes", :name => "way_nodes_node_idx"
+  end
+end
-- 
2.43.2