@@ -, +, @@ --- 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 --- a/installer/data/mysql/atomicupdate/bug_21953.perl +++ a/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"; +} --- a/installer/data/mysql/atomicupdate/bug_21953.sql +++ a/installer/data/mysql/atomicupdate/bug_21953.sql @@ -1, +0,0 @@ -UPDATE accountlines SET description=REGEXP_REPLACE(description, '^Lost Item ', '') WHERE accounttype="PF"; --