From: Josef Moravec <josef.moravec@gmail.com>
Date: Wed, 20 Mar 2019 15:26:38 +0000 (+0000)
Subject: Bug 13795: Make database update idempotent
X-Git-Url: http://git.equinoxoli.org/?p=koha-equinox.git;a=commitdiff_plain;h=c90329fbe5c65c25908001383f24009811104240

Bug 13795: Make database update idempotent

Signed-off-by: Michal Denar <black23@gmail.com>

Signed-off-by: Michal Denar <black23@gmail.com>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
---

diff --git a/installer/data/mysql/atomicupdate/Bug13795_Remove_unused_columns.perl b/installer/data/mysql/atomicupdate/Bug13795_Remove_unused_columns.perl
index 51e223e..71c7604 100644
--- a/installer/data/mysql/atomicupdate/Bug13795_Remove_unused_columns.perl
+++ b/installer/data/mysql/atomicupdate/Bug13795_Remove_unused_columns.perl
@@ -1,12 +1,12 @@
 $DBversion = 'XXX'; # will be replaced by the RM
 if( CheckVersion( $DBversion ) ) {
-    $dbh->do(q{
-        ALTER TABLE statistics
-         DROP COLUMN associatedborrower
-         DROP COLUMN usercode
-    });
+    if( column_exists('statistics', 'associatedborrower') ) {
+        $dbh->do(q{ ALTER TABLE statistics DROP COLUMN associatedborrower });
+    }
+    if( column_exists('statistics', 'usercode') ) {
+        $dbh->do(q{ ALTER TABLE statistics DROP COLUMN usercode });
+    }
 
     SetVersion($DBversion);
-
     print "Upgrade to $DBversion done (Bug 13795 - Delete unused fields from statistics table)\n";
 }