X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/6ae23bed90f249ed943cc43f1bad0e40852f04bb..e7e5ae7aaab85222b0cc6677d483b8027a47844f:/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 38c741cca..c551b0ef8 100644 --- a/db/migrate/014_move_to_innodb.rb +++ b/db/migrate/014_move_to_innodb.rb @@ -1,7 +1,7 @@ class MoveToInnodb < ActiveRecord::Migration @@conv_tables = ['nodes', 'ways', 'way_tags', 'way_nodes', - 'current_way_nodes', 'relation_members', 'relations', - 'relation_tags', 'current_relation_tags'] + 'current_way_tags', 'relation_members', + 'relations', 'relation_tags', 'current_relation_tags'] @@ver_tbl = ['nodes', 'ways', 'relations'] @@ -20,10 +20,11 @@ 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 def self.down + raise IrreversibleMigration.new end end