Attachment 78893 Details for Bug 20777 – Bug 20777: Remove unused accountlines.dispute field

[patch] Bug 20777: Remove unused accountlines.dispute field

Bug-20777-Remove-unused-accountlinesdispute-field.patch (text/plain), 1.92 KB, created by Jonathan Druart on 2018-09-15 20:55:34 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2018-09-15 20:55:34 UTC

Size: 1.92 KB

patch

obsolete

>From 6e04cadef0ce4d8ffe693dfd236cf4a64ca78f11 Mon Sep 17 00:00:00 2001
>From: Tomas Cohen Arazi <tomascohen@theke.io>
>Date: Thu, 17 May 2018 10:53:55 -0300
>Subject: [PATCH] Bug 20777: Remove unused accountlines.dispute field
>
>Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
>
>Signed-off-by: Mark Tompsett <mtompset@hotmail.com>
>
>Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>---
> .../mysql/atomicupdate/bug_20777_accountlines_dispute.perl  | 13 +++++++++++++
> installer/data/mysql/kohastructure.sql                      |  1 -
> 2 files changed, 13 insertions(+), 1 deletion(-)
> create mode 100644 installer/data/mysql/atomicupdate/bug_20777_accountlines_dispute.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_20777_accountlines_dispute.perl b/installer/data/mysql/atomicupdate/bug_20777_accountlines_dispute.perl
>new file mode 100644
>index 0000000000..4317603ea3
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_20777_accountlines_dispute.perl
>@@ -0,0 +1,13 @@
>+$DBversion = 'XXX';
>+if( CheckVersion( $DBversion ) ) {
>+
>+    if ( column_exists( 'accountlines', 'dispute' ) ) {
>+        $dbh->do(q{
>+            ALTER TABLE `accountlines`
>+                DROP COLUMN `dispute`
>+        });
>+    }
>+
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug 20777 - Remove unused field accountlines.dispute)\n";
>+}
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 3048ade972..f348931082 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -2679,7 +2679,6 @@ CREATE TABLE `accountlines` (
>   `date` date default NULL,
>   `amount` decimal(28,6) default NULL,
>   `description` LONGTEXT,
>-  `dispute` LONGTEXT,
>   `accounttype` varchar(5) default NULL,
>   `payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE
>   `amountoutstanding` decimal(28,6) default NULL,
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 20777: 75397 | 75398 | 78665 | 78671 | 78672 | 78673 | 78893 | 78894 | 78895