Attachment #108477 for bug #25534

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




$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");
}

Return to bug 25534

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/cancellation_reason.perl (+16 lines)
	1	$DBversion = 'XXX'; # will be replaced by the RM
	2	if ( CheckVersion( $DBversion ) ) {
	3	if ( !column_exists( 'reserves', 'cancellation_reason' ) ) {
	4	$dbh->do(q{
	5	ALTER TABLE reserves ADD COLUMN `cancellation_reason` varchar(80) default NULL AFTER cancellationdate;
	6	});
	7	}
	8
	9	if ( !column_exists( 'old_reserves', 'cancellation_reason' ) ) {
	10	$dbh->do(q{
	11	ALTER TABLE old_reserves ADD COLUMN `cancellation_reason` varchar(80) default NULL AFTER cancellationdate;
	12	});
	13	}
	14
	15	NewVersion( $DBversion, 25534, "Add ability to send an email specifying a reason when canceling a hold");
	16	}

Lines 1760-1765 CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
1760	`notificationdate` date default NULL, -- currently unused	1760	`notificationdate` date default NULL, -- currently unused
1761	`reminderdate` date default NULL, -- currently unused	1761	`reminderdate` date default NULL, -- currently unused
1762	`cancellationdate` date default NULL, -- the date this hold was cancelled	1762	`cancellationdate` date default NULL, -- the date this hold was cancelled
		1763	`cancellation_reason` varchar(80) default NULL, -- optional authorised value CANCELLATION_REASON
1763	`reservenotes` LONGTEXT, -- notes related to this hold	1764	`reservenotes` LONGTEXT, -- notes related to this hold
1764	`priority` smallint(6) NOT NULL DEFAULT 1, -- where in the queue the patron sits	1765	`priority` smallint(6) NOT NULL DEFAULT 1, -- where in the queue the patron sits
1765	`found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed	1766	`found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed
Lines 1800-1805 CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b Link Here
1800	`notificationdate` date default NULL, -- currently unused	1801	`notificationdate` date default NULL, -- currently unused
1801	`reminderdate` date default NULL, -- currently unused	1802	`reminderdate` date default NULL, -- currently unused
1802	`cancellationdate` date default NULL, -- the date this hold was cancelled	1803	`cancellationdate` date default NULL, -- the date this hold was cancelled
		1804	`cancellation_reason` varchar(80) default NULL, -- optional authorised value CANCELLATION_REASON
1803	`reservenotes` LONGTEXT, -- notes related to this hold	1805	`reservenotes` LONGTEXT, -- notes related to this hold
1804	`priority` smallint(6) NOT NULL DEFAULT 1, -- where in the queue the patron sits	1806	`priority` smallint(6) NOT NULL DEFAULT 1, -- where in the queue the patron sits
1805	`found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed	1807	`found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed
1806	-