@@ -, +, @@ --- ...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 --- a/installer/data/mysql/atomicupdate/bug_16787_add_noReservesAllowed_to_club_holds.perl +++ a/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"; +} --- a/installer/data/mysql/kohastructure.sql +++ a/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`), --