From: Gabriel Ebner <gabriel@svn.openstreetmap.org>
Date: Mon, 24 Sep 2007 13:31:11 +0000 (+0000)
Subject: rails_port_0.5: Add the index before loading the data as suggested by Tom Hughes.
X-Git-Tag: live~8121^2~12
X-Git-Url: https://git.openstreetmap.org/rails.git/commitdiff_plain/b66ae59f334084e25d1c1ce12e7fa2ed33433160?hp=1ac9ea1f06e66cac4ef2557b95660fdcfa2fd176

rails_port_0.5: Add the index before loading the data as suggested by Tom Hughes.
---

diff --git a/db/migrate/008_remove_segments.rb b/db/migrate/008_remove_segments.rb
index 8c049b62a..16968edad 100644
--- a/db/migrate/008_remove_segments.rb
+++ b/db/migrate/008_remove_segments.rb
@@ -44,6 +44,7 @@ class RemoveSegments < ActiveRecord::Migration
       t.column :sequence_id, :bigint, :limit => 11, :null => false
     end
     add_primary_key :current_way_nodes, [:id, :sequence_id]
+    add_index :current_way_nodes, [:node_id], :name => "current_way_nodes_node_idx"
 
     execute "TRUNCATE way_tags"
     execute "TRUNCATE ways"
@@ -65,9 +66,6 @@ class RemoveSegments < ActiveRecord::Migration
       execute "INSERT INTO current_way_tags SELECT id, k, v FROM way_tags"
     end
 
-    # and then readd the index
-    add_index :current_way_nodes, [:node_id], :name => "current_way_nodes_node_idx"
-
     if have_segs
       execute "LOAD DATA INFILE '#{relations}' INTO TABLE relations #{csvopts} (id, user_id, timestamp) SET visible = 1, version = 1"
       execute "LOAD DATA INFILE '#{relation_members}' INTO TABLE relation_members #{csvopts} (id, member_type, member_id, member_role) SET version = 1"