The current_way_nodes table is already an InnoDB table.

[rails.git] / db / migrate / 014_move_to_innodb.rb

diff --git a/db/migrate/014_move_to_innodb.rb b/db/migrate/014_move_to_innodb.rb
index 57065a594fa303a891147b5e16045f4bc468f5a9..c551b0ef812cb3ee09e3d9fa27ea336f2ad16000 100644 (file)
--- a/db/migrate/014_move_to_innodb.rb
+++ b/db/migrate/014_move_to_innodb.rb
@@ -1,6 +1,6 @@
 class MoveToInnodb < ActiveRecord::Migration
   @@conv_tables = ['nodes', 'ways', 'way_tags', 'way_nodes',
 class MoveToInnodb < ActiveRecord::Migration
   @@conv_tables = ['nodes', 'ways', 'way_tags', 'way_nodes',

-    'current_way_nodes', 'current_way_tags', 'relation_members',
+    'current_way_tags', 'relation_members',

     'relations', 'relation_tags', 'current_relation_tags']
 
   @@ver_tbl = ['nodes', 'ways', 'relations']
     'relations', 'relation_tags', 'current_relation_tags']
 
   @@ver_tbl = ['nodes', 'ways', 'relations']


@@ -20,7 +20,7 @@ class MoveToInnodb < ActiveRecord::Migration
     @@ver_tbl.each { |tbl|
       add_column "current_#{tbl}", "version", :bigint, :limit => 20, :null => false
       execute "UPDATE current_#{tbl} SET version = " +
     @@ver_tbl.each { |tbl|
       add_column "current_#{tbl}", "version", :bigint, :limit => 20, :null => false
       execute "UPDATE current_#{tbl} SET version = " +

-       "(SELECT max(version)+1 FROM #{tbl} WHERE #{tbl}.id = current_#{tbl}.id)"
+       "(SELECT max(version) FROM #{tbl} WHERE #{tbl}.id = current_#{tbl}.id)"

     }
   end
 
     }
   end