Attachment 86229 Details for Bug 21683 – Bug 21683: (QA follow-up) Drop statistics.proccode

[patch] Bug 21683: (QA follow-up) Drop statistics.proccode

Bug-21683-QA-follow-up-Drop-statisticsproccode.patch (text/plain), 1.29 KB, created by Martin Renvoize (ashimema) on 2019-03-07 08:14:21 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Martin Renvoize (ashimema)

Created: 2019-03-07 08:14:21 UTC

Size: 1.29 KB

patch

obsolete

>From b14cd9125f961c34bbd0d3aede795c3ae5b83cb6 Mon Sep 17 00:00:00 2001
>From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>Date: Thu, 7 Mar 2019 08:12:30 +0000
>Subject: [PATCH] Bug 21683: (QA follow-up) Drop statistics.proccode
>
>Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>---
> .../atomicupdate/bug_21683_remove_column_accountno.perl     | 6 +++++-
> 1 file changed, 5 insertions(+), 1 deletion(-)
>
>diff --git a/installer/data/mysql/atomicupdate/bug_21683_remove_column_accountno.perl b/installer/data/mysql/atomicupdate/bug_21683_remove_column_accountno.perl
>index 02073805ba..4d044c838c 100644
>--- a/installer/data/mysql/atomicupdate/bug_21683_remove_column_accountno.perl
>+++ b/installer/data/mysql/atomicupdate/bug_21683_remove_column_accountno.perl
>@@ -5,7 +5,11 @@ if( CheckVersion( $DBversion ) ) {
>         $dbh->do( "ALTER TABLE accountlines DROP COLUMN accountno" );
>     }
> 
>+    if( column_exists( 'statistics', 'proccode' ) ) {
>+        $dbh->do( "ALTER TABLE statistics DROP COLUMN proccode" );
>+    }
>+
>     # Always end with this (adjust the bug info)
>     SetVersion( $DBversion );
>-    print "Upgrade to $DBversion done (Bug XXXXX - description)\n";
>+    print "Upgrade to $DBversion done (Bug 21683 - Remove accountlines.accountno and statistics.proccode fields)\n";
> }
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 21683: 81281 | 81282 | 81283 | 82183 | 82184 | 82185 | 82188 | 85531 | 85532 | 85533 | 85534 | 85535 | 85536 | 85537 | 85538 | 86221 | 86222 | 86223 | 86224 | 86225 | 86226 | 86227 | 86228 | 86229 | 86230 | 86231 | 86232 | 86233 | 86234 | 86336 | 86470 | 86471 | 86472 | 86473 | 86474 | 86475