api06: Fix the version-numbers-on-current-tables migration: We want the rows

in the current table to have the same version number as the latest one in the
history table (the latest version is kept in both the current and the history
tables.)

diff --git a/db/migrate/014_move_to_innodb.rb b/db/migrate/014_move_to_innodb.rb
index 57065a594fa303a891147b5e16045f4bc468f5a9..da6442daba1fc334be9cffe675927b715ce53261 100644 (file)
--- a/db/migrate/014_move_to_innodb.rb
+++ b/db/migrate/014_move_to_innodb.rb
@@ -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