Bug 15685: (QA follow-up) Address QA issues

[koha.git] / installer / data / mysql / atomicupdate / bug15685.perl

diff --git a/installer/data/mysql/atomicupdate/bug15685.perl b/installer/data/mysql/atomicupdate/bug15685.perl
index 8c66878..7721df5 100644 (file)
--- a/installer/data/mysql/atomicupdate/bug15685.perl
+++ b/installer/data/mysql/atomicupdate/bug15685.perl
@@ -1,10 +1,12 @@
 $DBversion = 'XXX';  # will be replaced by the RM
 if( CheckVersion( $DBversion ) ) {
 
-    $dbh->do(q{
-        ALTER TABLE aqbasket
-            ADD COLUMN create_items ENUM('ordering', 'receiving', 'cataloguing') default NULL
-    });
+    unless( column_exists('aqbasket','create_items') ){
+        $dbh->do(q{
+            ALTER TABLE aqbasket
+                ADD COLUMN create_items ENUM('ordering', 'receiving', 'cataloguing') default NULL
+        });
+    }
 
     SetVersion( $DBversion );
     print "Upgrade to $DBversion done (Bug 15685: Allow creation of items (AcqCreateItem) to be customizable per-basket)\n";