Attachment 86672 Details for Bug 22518 – Bug 22518: Add database update 'just in case'

[patch] Bug 22518: Add database update 'just in case'

Bug-22518-Add-database-update-just-in-case.patch (text/plain), 1.30 KB, created by Martin Renvoize (ashimema) on 2019-03-15 13:46:46 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Martin Renvoize (ashimema)

Created: 2019-03-15 13:46:46 UTC

Size: 1.30 KB

patch

obsolete

>From 0ecdb503217e4c04c58f5943119bde32fde5f607 Mon Sep 17 00:00:00 2001
>From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>Date: Fri, 15 Mar 2019 13:43:03 +0000
>Subject: [PATCH] Bug 22518: Add database update 'just in case'
>
>All cases I could find where 'O' was referenced it was referenced
>alongside 'FU'.. as such I've written this DB update to case any last
>cases of 'O' and update them to 'FU' "just in case"
>
>Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>---
> installer/data/mysql/atomicupdate/bug_22518.perl | 16 ++++++++++++++++
> 1 file changed, 16 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_22518.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_22518.perl b/installer/data/mysql/atomicupdate/bug_22518.perl
>new file mode 100644
>index 0000000000..4d975d9b62
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_22518.perl
>@@ -0,0 +1,16 @@
>+$DBversion = 'XXX';    # will be replaced by the RM
>+if ( CheckVersion($DBversion) ) {
>+
>+        $dbh->do(
>+            qq{
>+            UPDATE `accountlines`
>+            SET
>+              `accounttype` = 'FU'
>+            WHERE
>+              `accounttype` = 'O'
>+          }
>+        );
>+
>+    SetVersion($DBversion);
>+    print "Upgrade to $DBversion done (Bug 22518 - Fix accounttype 'O' to 'FU')\n";
>+}
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 22518: 86671 | 86672 | 87019 | 87020 | 87171 | 87172 | 87174 | 87186