Attachment #105147 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 1752-1757 CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
1752	`notificationdate` date default NULL, -- currently unused	1752	`notificationdate` date default NULL, -- currently unused
1753	`reminderdate` date default NULL, -- currently unused	1753	`reminderdate` date default NULL, -- currently unused
1754	`cancellationdate` date default NULL, -- the date this hold was cancelled	1754	`cancellationdate` date default NULL, -- the date this hold was cancelled
		1755	`cancellation_reason` varchar(80) default NULL, -- optional authorised value CANCELLATION_REASON
1755	`reservenotes` LONGTEXT, -- notes related to this hold	1756	`reservenotes` LONGTEXT, -- notes related to this hold
1756	`priority` smallint(6) NOT NULL DEFAULT 1, -- where in the queue the patron sits	1757	`priority` smallint(6) NOT NULL DEFAULT 1, -- where in the queue the patron sits
1757	`found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed	1758	`found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed
Lines 1792-1797 CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b Link Here
1792	`notificationdate` date default NULL, -- currently unused	1793	`notificationdate` date default NULL, -- currently unused
1793	`reminderdate` date default NULL, -- currently unused	1794	`reminderdate` date default NULL, -- currently unused
1794	`cancellationdate` date default NULL, -- the date this hold was cancelled	1795	`cancellationdate` date default NULL, -- the date this hold was cancelled
		1796	`cancellation_reason` varchar(80) default NULL, -- optional authorised value CANCELLATION_REASON
1795	`reservenotes` LONGTEXT, -- notes related to this hold	1797	`reservenotes` LONGTEXT, -- notes related to this hold
1796	`priority` smallint(6) NOT NULL DEFAULT 1, -- where in the queue the patron sits	1798	`priority` smallint(6) NOT NULL DEFAULT 1, -- where in the queue the patron sits
1797	`found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed	1799	`found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed
1798	-