From 2a9a78782c6aaecb2f80faf51e7529f330c8a8f4 Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Mon, 2 Mar 2020 16:49:16 +0000 Subject: [PATCH] Bug 16787: Add noReservesAllowed to club holds Signed-off-by: Owen Leonard Signed-off-by: Martin Renvoize --- ...6787_add_noReservesAllowed_to_club_holds.perl | 16 ++++++++++++++++ installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 17 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_16787_add_noReservesAllowed_to_club_holds.perl diff --git a/installer/data/mysql/atomicupdate/bug_16787_add_noReservesAllowed_to_club_holds.perl b/installer/data/mysql/atomicupdate/bug_16787_add_noReservesAllowed_to_club_holds.perl new file mode 100644 index 0000000000..7cd3fc669a --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_16787_add_noReservesAllowed_to_club_holds.perl @@ -0,0 +1,16 @@ +$DBversion = 'XXX'; +if( CheckVersion( $DBversion ) ) { + $dbh->do(q{ + ALTER TABLE club_holds_to_patron_holds + MODIFY COLUMN error_code + ENUM ( 'damaged', 'ageRestricted', 'itemAlreadyOnHold', + 'tooManyHoldsForThisRecord', 'tooManyReservesToday', + 'tooManyReserves', 'notReservable', 'cannotReserveFromOtherBranches', + 'libraryNotFound', 'libraryNotPickupLocation', 'cannotBeTransferred', + 'noReservesAllowed' + ) + }); + + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 16787: Add noReservesAllowed to club holds error codes)\n"; +} diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index d391665136..f2dce203da 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1853,7 +1853,7 @@ CREATE TABLE `club_holds_to_patron_holds` ( `club_hold_id` int(11) NOT NULL, `patron_id` int(11) NOT NULL, `hold_id` int(11) DEFAULT NULL, - `error_code` enum('damaged','ageRestricted','itemAlreadyOnHold','tooManyHoldsForThisRecord','tooManyReservesToday','tooManyReserves','notReservable','cannotReserveFromOtherBranches','libraryNotFound','libraryNotPickupLocation','cannotBeTransferred') COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `error_code` enum('damaged','ageRestricted','itemAlreadyOnHold','tooManyHoldsForThisRecord','tooManyReservesToday','tooManyReserves','notReservable','cannotReserveFromOtherBranches','libraryNotFound','libraryNotPickupLocation','cannotBeTransferred','noReservesAllowed') COLLATE utf8mb4_unicode_ci DEFAULT NULL, `error_message` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `clubs_holds_paton_holds_ibfk_1` (`club_hold_id`), -- 2.20.1