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

(-)a/installer/data/mysql/atomicupdate/cancellation_reason.perl (+16 lines)
Line 0 Link Here
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
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 1760-1765 CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha Link Here
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
- 

Return to bug 25534