From 9afc808f62d21b0f40278dc9202b4841269aac44 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Wed, 24 Apr 2019 11:15:33 +0100 Subject: [PATCH] Bug 6759: Update existing accountlines for 'A' Signed-off-by: Martin Renvoize Signed-off-by: Maryse Simard Signed-off-by: Tomas Cohen Arazi --- installer/data/mysql/atomicupdate/bug_6759.perl | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_6759.perl diff --git a/installer/data/mysql/atomicupdate/bug_6759.perl b/installer/data/mysql/atomicupdate/bug_6759.perl new file mode 100644 index 0000000000..afd417e8d1 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_6759.perl @@ -0,0 +1,15 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if ( CheckVersion($DBversion) ) { + + $dbh->do(qq{ + UPDATE + accountlines + SET + accounttype = 'ACCOUNT' + WHERE + accounttype = 'A'; + }); + + SetVersion($DBversion); + print "Upgrade to $DBversion done (Bug 11573 - Fix accounttypes for 'A')\n"; +} -- 2.23.0