Attachment 85535 Details for Bug 21683 – Bug 21683: Database update

[patch] Bug 21683: Database update

Bug-21683-Database-update.patch (text/plain), 1.78 KB, created by Martin Renvoize (ashimema) on 2019-02-22 14:36:43 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Martin Renvoize (ashimema)

Created: 2019-02-22 14:36:43 UTC

Size: 1.78 KB

patch

obsolete

>From 21ca918e9c434155d4dbf7811ed3b860b99700b5 Mon Sep 17 00:00:00 2001
>From: Josef Moravec <josef.moravec@gmail.com>
>Date: Fri, 26 Oct 2018 11:02:58 +0000
>Subject: [PATCH] Bug 21683: Database update
>
>Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>---
> .../bug_21683_remove_column_accountno.perl            | 11 +++++++++++
> installer/data/mysql/kohastructure.sql                |  1 -
> 2 files changed, 11 insertions(+), 1 deletion(-)
> create mode 100644 installer/data/mysql/atomicupdate/bug_21683_remove_column_accountno.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_21683_remove_column_accountno.perl b/installer/data/mysql/atomicupdate/bug_21683_remove_column_accountno.perl
>new file mode 100644
>index 0000000000..02073805ba
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_21683_remove_column_accountno.perl
>@@ -0,0 +1,11 @@
>+$DBversion = 'XXX';  # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+
>+    if( column_exists( 'accountlines', 'accountno' ) ) {
>+        $dbh->do( "ALTER TABLE accountlines DROP COLUMN accountno" );
>+    }
>+
>+    # Always end with this (adjust the bug info)
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug XXXXX - description)\n";
>+}
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index fa5044e9fe..abdf421457 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -2708,7 +2708,6 @@ CREATE TABLE `accountlines` (
>   `accountlines_id` int(11) NOT NULL AUTO_INCREMENT,
>   `issue_id` int(11) NULL DEFAULT NULL,
>   `borrowernumber` int(11) DEFAULT NULL,
>-  `accountno` smallint(6) NOT NULL default 0,
>   `itemnumber` int(11) default NULL,
>   `date` date default NULL,
>   `amount` decimal(28,6) default NULL,
>-- 
>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