Attachment 105147 Details for Bug 25534 – Bug 25534: Update database

[patch] Bug 25534: Update database

Bug-25534-Update-database.patch (text/plain), 3.01 KB, created by ByWater Sandboxes on 2020-05-20 14:24:19 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: ByWater Sandboxes

Created: 2020-05-20 14:24:19 UTC

Size: 3.01 KB

patch

obsolete

>From 6d7c5f17376e0c0a6a1638b701f208a9db475220 Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Mon, 18 May 2020 13:32:21 -0400
>Subject: [PATCH] Bug 25534: Update database
>
>Signed-off-by: Andrew Fuerste-Henry <andrew@bywatersolutions.com>
>
>Signed-off-by: Rebecca Coert <rcoert@arlingtonva.us>
>---
> .../data/mysql/atomicupdate/cancellation_reason.perl     | 16 ++++++++++++++++
> installer/data/mysql/kohastructure.sql                   |  2 ++
> 2 files changed, 18 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/cancellation_reason.perl
>
>diff --git a/installer/data/mysql/atomicupdate/cancellation_reason.perl b/installer/data/mysql/atomicupdate/cancellation_reason.perl
>new file mode 100644
>index 0000000000..cd73a1803b
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/cancellation_reason.perl
>@@ -0,0 +1,16 @@
>+$DBversion = 'XXX'; # will be replaced by the RM
>+if ( CheckVersion( $DBversion ) ) {
>+    if ( !column_exists( 'reserves', 'cancellation_reason' ) ) {
>+        $dbh->do(q{
>+            ALTER TABLE reserves ADD COLUMN `cancellation_reason` varchar(80) default NULL AFTER cancellationdate;
>+        });
>+    }
>+
>+    if ( !column_exists( 'old_reserves', 'cancellation_reason' ) ) {
>+        $dbh->do(q{
>+            ALTER TABLE old_reserves ADD COLUMN `cancellation_reason` varchar(80) default NULL AFTER cancellationdate;
>+        });
>+    }
>+
>+    NewVersion( $DBversion, 25534, "Add ability to send an email specifying a reason when canceling a hold");
>+}
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index c5a3879662..4335d69895 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -1752,6 +1752,7 @@ CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
>   `notificationdate` date default NULL, -- currently unused
>   `reminderdate` date default NULL, -- currently unused
>   `cancellationdate` date default NULL, -- the date this hold was cancelled
>+  `cancellation_reason` varchar(80) default NULL, -- optional authorised value CANCELLATION_REASON
>   `reservenotes` LONGTEXT, -- notes related to this hold
>   `priority` smallint(6) NOT NULL DEFAULT 1, -- where in the queue the patron sits
>   `found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed
>@@ -1792,6 +1793,7 @@ CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
>   `notificationdate` date default NULL, -- currently unused
>   `reminderdate` date default NULL, -- currently unused
>   `cancellationdate` date default NULL, -- the date this hold was cancelled
>+  `cancellation_reason` varchar(80) default NULL, -- optional authorised value CANCELLATION_REASON
>   `reservenotes` LONGTEXT, -- notes related to this hold
>   `priority` smallint(6) NOT NULL DEFAULT 1, -- where in the queue the patron sits
>   `found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 25534: 105034 | 105035 | 105036 | 105077 | 105078 | 105079 | 105105 | 105106 | 105108 | 105109 | 105110 | 105111 | 105112 | 105113 | 105114 | 105115 | 105116 | 105117 | 105118 | 105119 | 105120 | 105121 | 105122 | 105147 | 105148 | 105149 | 105150 | 105151 | 108476 | 108477 | 108478 | 108479 | 108480 | 108481 | 108746 | 108747 | 108748 | 108749 | 108750 | 108751 | 108752 | 108753 | 108754 | 108755 | 108756 | 108757 | 108805 | 108806 | 108891 | 108892 | 108893 | 108894 | 108895 | 108896 | 108897 | 108898 | 108899 | 108900 | 108901 | 108902 | 108903 | 108904 | 108977 | 108985 | 108986 | 108990 | 114026 | 114027 | 114788