From: Josef Moravec <josef.moravec@gmail.com>
Date: Sun, 12 Jan 2020 18:41:30 +0000 (+0000)
Subject: Bug 23354: (QA follow-up) Make db update idempotent
X-Git-Url: http://git.equinoxoli.org/?p=koha-equinox.git;a=commitdiff_plain;h=ade421e89634b99f6e08f4c8c3e98f358c8621d0

Bug 23354: (QA follow-up) Make db update idempotent

Signed-off-by: Josef Moravec <josef.moravec@gmail.com>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
---

diff --git a/installer/data/mysql/atomicupdate/bug_23354.perl b/installer/data/mysql/atomicupdate/bug_23354.perl
index 717eaa5..cec1fdc 100644
--- a/installer/data/mysql/atomicupdate/bug_23354.perl
+++ b/installer/data/mysql/atomicupdate/bug_23354.perl
@@ -6,7 +6,7 @@ if( CheckVersion( $DBversion ) ) {
     });
 
     $dbh->do(q{
-        INSERT INTO account_credit_types ( code, description, can_be_added_manually, is_system )
+        INSERT IGNORE INTO account_credit_types ( code, description, can_be_added_manually, is_system )
         VALUES ('PURCHASE', 'Purchase', 0, 1);
     });