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

Return to bug 25534