Attachment 74147 Details for Bug 18786 – Bug 18786: Update database

[patch] Bug 18786: Update database

Bug-18786-Update-database.patch (text/plain), 1.87 KB, created by Josef Moravec on 2018-04-13 09:50:33 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Josef Moravec

Created: 2018-04-13 09:50:33 UTC

Size: 1.87 KB

patch

obsolete

>From cf5646b3b21f1c9ee06b7194824484c6420372f0 Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Mon, 12 Jun 2017 10:07:53 -0400
>Subject: [PATCH] Bug 18786: Update database
>MIME-Version: 1.0
>Content-Type: text/plain; charset=UTF-8
>Content-Transfer-Encoding: 8bit
>
>Signed-off-by: Marc VÃ©ron <veron@veron.ch>
>
>Signed-off-by: Josef Moravec <josef.moravec@gmail.com>
>---
> installer/data/mysql/atomicupdate/bug_18786.perl | 10 ++++++++++
> installer/data/mysql/kohastructure.sql           |  1 +
> 2 files changed, 11 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_18786.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_18786.perl b/installer/data/mysql/atomicupdate/bug_18786.perl
>new file mode 100644
>index 0000000..7617bc5
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_18786.perl
>@@ -0,0 +1,10 @@
>+$DBversion = 'XXX';  # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+
>+    if ( !column_exists( 'accountlines', 'payment_type' ) ) {
>+        $dbh->do( "ALTER TABLE accountlines ADD `payment_type` varchar(80) default NULL AFTER accounttype" );
>+    }
>+
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug 18786 - Add ability to create custom payment types)\n";
>+}
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 6842eb5..b689db3 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -2685,6 +2685,7 @@ CREATE TABLE `accountlines` (
>   `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,
>   `lastincrement` decimal(28,6) default NULL,
>   `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
>-- 
>2.1.4

Actions: View | Diff | Splinter Review

Attachments on bug 18786: 64202 | 64203 | 64204 | 64288 | 64300 | 64301 | 64302 | 67476 | 67477 | 69155 | 69156 | 69157 | 71020 | 71021 | 72015 | 72016 | 72114 | 72115 | 72282 | 73628 | 74147 | 74148 | 74149 | 74172 | 74436 | 75401