From 9274a6010a03bbccdeb471cea5e0be319bb735c7 Mon Sep 17 00:00:00 2001 From: Gabriel Ebner Date: Sun, 4 May 2008 10:04:07 +0000 Subject: [PATCH] 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.) --- db/migrate/014_move_to_innodb.rb | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/db/migrate/014_move_to_innodb.rb b/db/migrate/014_move_to_innodb.rb index 57065a594..da6442dab 100644 --- 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 = " + - "(SELECT max(version)+1 FROM #{tbl} WHERE #{tbl}.id = current_#{tbl}.id)" + "(SELECT max(version) FROM #{tbl} WHERE #{tbl}.id = current_#{tbl}.id)" } end -- 2.39.5