Bug 22563: (QA follow-up) Correction to DB update
authorMartin Renvoize <martin.renvoize@ptfs-europe.com>
Mon, 17 Jun 2019 14:01:11 +0000 (15:01 +0100)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Mon, 15 Jul 2019 10:28:03 +0000 (11:28 +0100)
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>

installer/data/mysql/atomicupdate/bug_22563.perl

index 1c27e04..e8176f7 100644 (file)
@@ -51,7 +51,7 @@ if ( CheckVersion($DBversion) ) {
         UPDATE
           accountlines
         SET
-          accounttype = 'LOST',
+          accounttype = 'LOST'
         WHERE
           accounttype = 'L';
     });
@@ -60,7 +60,7 @@ if ( CheckVersion($DBversion) ) {
         UPDATE
           accountlines
         SET
-          accounttype = 'LOST_RETURNED',
+          accounttype = 'LOST_RETURNED'
         WHERE
           accounttype = 'CR';
     });