X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/4424cd5b947432848fe7f5bc7518fd1b718ecf6c..e7e5ae7aaab85222b0cc6677d483b8027a47844f:/db/migrate/014_move_to_innodb.rb?ds=sidebyside diff --git a/db/migrate/014_move_to_innodb.rb b/db/migrate/014_move_to_innodb.rb index 57065a594..c551b0ef8 100644 --- 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', - 'current_way_nodes', 'current_way_tags', 'relation_members', + 'current_way_tags', 'relation_members', '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 = " + - "(SELECT max(version)+1 FROM #{tbl} WHERE #{tbl}.id = current_#{tbl}.id)" + "(SELECT max(version) FROM #{tbl} WHERE #{tbl}.id = current_#{tbl}.id)" } end