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 (file)
--- 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);
     });