View | Details | Raw Unified | Return to bug 16787
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_16787_add_noReservesAllowed_to_club_holds.perl (+16 lines)
Line 0 Link Here
1
$DBversion = 'XXX';
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do(q{
4
        ALTER TABLE club_holds_to_patron_holds
5
        MODIFY COLUMN error_code
6
        ENUM ( 'damaged', 'ageRestricted', 'itemAlreadyOnHold',
7
            'tooManyHoldsForThisRecord', 'tooManyReservesToday',
8
            'tooManyReserves', 'notReservable', 'cannotReserveFromOtherBranches',
9
            'libraryNotFound', 'libraryNotPickupLocation', 'cannotBeTransferred',
10
            'noReservesAllowed'
11
        )
12
    });
13
14
    SetVersion( $DBversion );
15
    print "Upgrade to $DBversion done (Bug 16787: Add noReservesAllowed to club holds error codes)\n";
16
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 1853-1859 CREATE TABLE `club_holds_to_patron_holds` ( Link Here
1853
  `club_hold_id` int(11) NOT NULL,
1853
  `club_hold_id` int(11) NOT NULL,
1854
  `patron_id` int(11) NOT NULL,
1854
  `patron_id` int(11) NOT NULL,
1855
  `hold_id` int(11) DEFAULT NULL,
1855
  `hold_id` int(11) DEFAULT NULL,
1856
  `error_code` enum('damaged','ageRestricted','itemAlreadyOnHold','tooManyHoldsForThisRecord','tooManyReservesToday','tooManyReserves','notReservable','cannotReserveFromOtherBranches','libraryNotFound','libraryNotPickupLocation','cannotBeTransferred') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1856
  `error_code` enum('damaged','ageRestricted','itemAlreadyOnHold','tooManyHoldsForThisRecord','tooManyReservesToday','tooManyReserves','notReservable','cannotReserveFromOtherBranches','libraryNotFound','libraryNotPickupLocation','cannotBeTransferred','noReservesAllowed') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1857
  `error_message` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1857
  `error_message` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1858
  PRIMARY KEY (`id`),
1858
  PRIMARY KEY (`id`),
1859
  KEY `clubs_holds_paton_holds_ibfk_1` (`club_hold_id`),
1859
  KEY `clubs_holds_paton_holds_ibfk_1` (`club_hold_id`),
1860
- 

Return to bug 16787