From b14cd9125f961c34bbd0d3aede795c3ae5b83cb6 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Thu, 7 Mar 2019 08:12:30 +0000 Subject: [PATCH] Bug 21683: (QA follow-up) Drop statistics.proccode Signed-off-by: Martin Renvoize --- .../atomicupdate/bug_21683_remove_column_accountno.perl | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/bug_21683_remove_column_accountno.perl b/installer/data/mysql/atomicupdate/bug_21683_remove_column_accountno.perl index 02073805ba..4d044c838c 100644 --- a/installer/data/mysql/atomicupdate/bug_21683_remove_column_accountno.perl +++ b/installer/data/mysql/atomicupdate/bug_21683_remove_column_accountno.perl @@ -5,7 +5,11 @@ if( CheckVersion( $DBversion ) ) { $dbh->do( "ALTER TABLE accountlines DROP COLUMN accountno" ); } + if( column_exists( 'statistics', 'proccode' ) ) { + $dbh->do( "ALTER TABLE statistics DROP COLUMN proccode" ); + } + # Always end with this (adjust the bug info) SetVersion( $DBversion ); - print "Upgrade to $DBversion done (Bug XXXXX - description)\n"; + print "Upgrade to $DBversion done (Bug 21683 - Remove accountlines.accountno and statistics.proccode fields)\n"; } -- 2.20.1