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 / +2 lines)
Lines 4181-4187 CREATE TABLE IF NOT EXISTS club_holds_to_patron_holds ( Link Here
4181
    error_code      ENUM ( 'damaged', 'ageRestricted', 'itemAlreadyOnHold',
4181
    error_code      ENUM ( 'damaged', 'ageRestricted', 'itemAlreadyOnHold',
4182
                        'tooManyHoldsForThisRecord', 'tooManyReservesToday',
4182
                        'tooManyHoldsForThisRecord', 'tooManyReservesToday',
4183
                        'tooManyReserves', 'notReservable', 'cannotReserveFromOtherBranches',
4183
                        'tooManyReserves', 'notReservable', 'cannotReserveFromOtherBranches',
4184
                        'libraryNotFound', 'libraryNotPickupLocation', 'cannotBeTransferred'
4184
                        'libraryNotFound', 'libraryNotPickupLocation', 'cannotBeTransferred',
4185
                        'noReservesAllowed'
4185
                    ) NULL DEFAULT NULL,
4186
                    ) NULL DEFAULT NULL,
4186
    error_message   varchar(100) NULL DEFAULT NULL,
4187
    error_message   varchar(100) NULL DEFAULT NULL,
4187
    PRIMARY KEY (id),
4188
    PRIMARY KEY (id),
4188
- 

Return to bug 16787