Attachment 92591 Details for Bug 23539 – Bug 23539: accountlines.accounttype should match authorised_values.authorised_value in size

[patch] Bug 23539: accountlines.accounttype should match authorised_values.authorised_value in size

Bug-23539-accountlinesaccounttype-should-match-aut.patch (text/plain), 1.73 KB, created by Kyle M Hall (khall) on 2019-09-04 17:49:31 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2019-09-04 17:49:31 UTC

Size: 1.73 KB

patch

obsolete

>From e2cc419996f830815ad5c396681556be4786a198 Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Wed, 4 Sep 2019 13:48:41 -0400
>Subject: [PATCH] Bug 23539: accountlines.accounttype should match
> authorised_values.authorised_value in size
>
>---
> installer/data/mysql/atomicupdate/bug_23439.perl | 7 +++++++
> installer/data/mysql/kohastructure.sql           | 2 +-
> 2 files changed, 8 insertions(+), 1 deletion(-)
> create mode 100644 installer/data/mysql/atomicupdate/bug_23439.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_23439.perl b/installer/data/mysql/atomicupdate/bug_23439.perl
>new file mode 100644
>index 0000000000..3ce88f30ca
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_23439.perl
>@@ -0,0 +1,7 @@
>+$DBversion = 'XXX'; # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+    $dbh->do(q{ALTER TABLE accountlines CHANGE COLUMN accounttype accounttype varchar(80) default NULL});
>+
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug 23539 - accountlines.accounttype should match authorised_values.authorised_value in size)\n";
>+}
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index cd7d7dfbcc..673f83ee57 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -2611,7 +2611,7 @@ CREATE TABLE `accountlines` (
>   `date` date default NULL,
>   `amount` decimal(28,6) default NULL,
>   `description` LONGTEXT,
>-  `accounttype` varchar(16) default NULL,
>+  `accounttype` varchar(80) default NULL,
>   `status` varchar(16) default NULL,
>   `payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE
>   `amountoutstanding` decimal(28,6) default NULL,
>-- 
>2.20.1 (Apple Git-117)

Actions: View | Diff | Splinter Review

Attachments on bug 23539: 92591 | 92605 | 92614