From 94f6100490d7f99a6ef397427d448dc971205f67 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Tue, 9 Apr 2019 12:00:16 +0100 Subject: [PATCH] Bug 21953: (QA follow-up) Corrections to DB Update Signed-off-by: Martin Renvoize --- installer/data/mysql/atomicupdate/bug_21953.perl | 6 ++++++ installer/data/mysql/atomicupdate/bug_21953.sql | 1 - 2 files changed, 6 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_21953.perl delete mode 100644 installer/data/mysql/atomicupdate/bug_21953.sql diff --git a/installer/data/mysql/atomicupdate/bug_21953.perl b/installer/data/mysql/atomicupdate/bug_21953.perl new file mode 100644 index 0000000000..4cbd2b382f --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_21953.perl @@ -0,0 +1,6 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if ( CheckVersion($DBversion) ) { + $dbh->do("UPDATE accountlines SET description = REPLACE(description, '^Lost Item ', '') WHERE description LIKE 'Lost Item %'"); + SetVersion($DBversion); + print "Upgrade to $DBversion done (Bug 21953 - Remove 'Lost Item' text from accountlines description)\n"; +} diff --git a/installer/data/mysql/atomicupdate/bug_21953.sql b/installer/data/mysql/atomicupdate/bug_21953.sql deleted file mode 100644 index 8a18635bd6..0000000000 --- a/installer/data/mysql/atomicupdate/bug_21953.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE accountlines SET description=REGEXP_REPLACE(description, '^Lost Item ', '') WHERE accounttype="PF"; -- 2.20.1