Attachment 91663 Details for Bug 6759 – Bug 6759: Update existing accountlines for 'A'

[patch] Bug 6759: Update existing accountlines for 'A'

Bug-6759-Update-existing-accountlines-for-A.patch (text/plain), 1.12 KB, created by Maryse Simard on 2019-07-19 19:06:26 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Maryse Simard

Created: 2019-07-19 19:06:26 UTC

Size: 1.12 KB

patch

obsolete

>From 3ede027aa6b676819cef5b4a57b7f54b15a4e027 Mon Sep 17 00:00:00 2001
>From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>Date: Wed, 24 Apr 2019 11:15:33 +0100
>Subject: [PATCH] Bug 6759: Update existing accountlines for 'A'
>
>Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>Signed-off-by: Maryse Simard <maryse.simard@inlibro.com>
>---
> 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 0000000..afd417e
>--- /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.7.4

Actions: View | Diff | Splinter Review

Attachments on bug 6759: 88614 | 88615 | 88731 | 88732 | 91533 | 91534 | 91662 | 91663 | 92765 | 92766 | 92767