@@ -, +, @@ borrowers and deletedborrowers table - 16.06.00.027 - 16.05.00.002 - 3.22.08.001 DBD::mysql::db do failed: Duplicate column name 'updated_on' --- installer/data/mysql/updatedatabase.pl | 26 ++++++++++++++------------ 1 file changed, 14 insertions(+), 12 deletions(-) --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -12669,18 +12669,20 @@ if ( CheckVersion($DBversion) ) { $DBversion = "16.06.00.002"; if ( CheckVersion($DBversion) ) { - $dbh->do(q{ - ALTER TABLE borrowers - ADD COLUMN updated_on timestamp NULL DEFAULT CURRENT_TIMESTAMP - ON UPDATE CURRENT_TIMESTAMP - AFTER privacy_guarantor_checkouts; - }); - $dbh->do(q{ - ALTER TABLE deletedborrowers - ADD COLUMN updated_on timestamp NULL DEFAULT CURRENT_TIMESTAMP - ON UPDATE CURRENT_TIMESTAMP - AFTER privacy_guarantor_checkouts; - }); + unless ( column_exists('borrowers', 'updated_on') ) { + $dbh->do(q{ + ALTER TABLE borrowers + ADD COLUMN updated_on timestamp NULL DEFAULT CURRENT_TIMESTAMP + ON UPDATE CURRENT_TIMESTAMP + AFTER privacy_guarantor_checkouts; + }); + $dbh->do(q{ + ALTER TABLE deletedborrowers + ADD COLUMN updated_on timestamp NULL DEFAULT CURRENT_TIMESTAMP + ON UPDATE CURRENT_TIMESTAMP + AFTER privacy_guarantor_checkouts; + }); + } print "Upgrade to $DBversion done (Bug 10459 - borrowers should have a timestamp)\n"; SetVersion($DBversion); --