Attachment 91071 Details for Bug 23151 – Bug 23151: Modifiy database structure

[patch] Bug 23151: Modifiy database structure

Bug-23151-Modifiy-database-structure.patch (text/plain), 1.99 KB, created by Kyle M Hall (khall) on 2019-06-28 14:21:01 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2019-06-28 14:21:01 UTC

Size: 1.99 KB

patch

obsolete

>From 26e6ebda22ccfcdb253d5ed3ba0e7d3240866636 Mon Sep 17 00:00:00 2001
>From: Mark Tompsett <mtompset@hotmail.com>
>Date: Wed, 19 Jun 2019 16:28:44 +0000
>Subject: [PATCH] Bug 23151: Modifiy database structure
>
>This modifies a fresh install structure, and provides
>an atomic update.
>
>Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
>---
> installer/data/mysql/atomicupdate/bug_23151.perl | 13 +++++++++++++
> installer/data/mysql/kohastructure.sql           |  1 +
> 2 files changed, 14 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_23151.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_23151.perl b/installer/data/mysql/atomicupdate/bug_23151.perl
>new file mode 100644
>index 0000000000..fc8a54bb21
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_23151.perl
>@@ -0,0 +1,13 @@
>+use C4::Installer;
>+
>+my $DBVersion = 'XXX';
>+if ( CheckVersion( $DBversion ) ) {
>+    print "Running... ";
>+    unless ( column_exists( 'borrower_modifications', 'changed_fields' ) ) {
>+        print "Running... ";
>+        $dbh->do("ALTER TABLE borrower_modifications ADD changed_fields MEDIUMTEXT AFTER verification_token;");
>+    }
>+    print "Ran\n";
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug 23151 - Add borrower_modifications.changed_fields column)\n";
>+}
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 79a03c6f66..acc0445bc6 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -3397,6 +3397,7 @@ CREATE TABLE borrower_attribute_types_branches( -- association table between bor
> CREATE TABLE IF NOT EXISTS `borrower_modifications` (
>   `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
>   `verification_token` varchar(255) NOT NULL DEFAULT '',
>+  `changed_fields` MEDIUMTEXT NOT NULL DEFAULT '',
>   `borrowernumber` int(11) NOT NULL DEFAULT '0',
>   `cardnumber` varchar(32) DEFAULT NULL,
>   `surname` LONGTEXT,
>-- 
>2.20.1 (Apple Git-117)

Actions: View | Diff | Splinter Review

Attachments on bug 23151: 90764 | 90769 | 90795 | 90796 | 90797 | 90798 | 90799 | 90805 | 90806 | 90807 | 90808 | 90809 | 91070 | 91071 | 91072 | 91073 | 91074 | 91075 | 91076 | 91614 | 91615 | 91616 | 91617 | 91618 | 91619 | 91620