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

(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 1757-1763 CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha Link Here
1757
  `reminderdate` date default NULL, -- currently unused
1757
  `reminderdate` date default NULL, -- currently unused
1758
  `cancellationdate` date default NULL, -- the date this hold was cancelled
1758
  `cancellationdate` date default NULL, -- the date this hold was cancelled
1759
  `reservenotes` LONGTEXT, -- notes related to this hold
1759
  `reservenotes` LONGTEXT, -- notes related to this hold
1760
  `priority` smallint(6) NOT NULL, -- where in the queue the patron sits
1760
  `priority` smallint(6) NOT NULL DEFAULT 1, -- where in the queue the patron sits
1761
  `found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed
1761
  `found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed
1762
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this hold was last updated
1762
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this hold was last updated
1763
  `itemnumber` int(11) default NULL, -- foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with
1763
  `itemnumber` int(11) default NULL, -- foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with
Lines 1797-1803 CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b Link Here
1797
  `reminderdate` date default NULL, -- currently unused
1797
  `reminderdate` date default NULL, -- currently unused
1798
  `cancellationdate` date default NULL, -- the date this hold was cancelled
1798
  `cancellationdate` date default NULL, -- the date this hold was cancelled
1799
  `reservenotes` LONGTEXT, -- notes related to this hold
1799
  `reservenotes` LONGTEXT, -- notes related to this hold
1800
  `priority` smallint(6) NOT NULL, -- where in the queue the patron sits
1800
  `priority` smallint(6) NOT NULL DEFAULT 1, -- where in the queue the patron sits
1801
  `found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed
1801
  `found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed
1802
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this hold was last updated
1802
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this hold was last updated
1803
  `itemnumber` int(11) default NULL, -- foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with
1803
  `itemnumber` int(11) default NULL, -- foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with
(-)a/installer/data/mysql/updatedatabase.pl (-3 / +2 lines)
Lines 21109-21115 if( CheckVersion( $DBversion ) ) { Link Here
21109
    |);
21109
    |);
21110
21110
21111
    $dbh->do(q|
21111
    $dbh->do(q|
21112
        ALTER TABLE reserves MODIFY priority SMALLINT(6) NOT NULL
21112
        ALTER TABLE reserves MODIFY priority SMALLINT(6) NOT NULL DEFAULT 1
21113
    |);
21113
    |);
21114
21114
21115
    $dbh->do(q|
21115
    $dbh->do(q|
Lines 21117-21123 if( CheckVersion( $DBversion ) ) { Link Here
21117
    |);
21117
    |);
21118
21118
21119
    $dbh->do(q|
21119
    $dbh->do(q|
21120
        ALTER TABLE old_reserves MODIFY priority SMALLINT(6) NOT NULL
21120
        ALTER TABLE old_reserves MODIFY priority SMALLINT(6) NOT NULL DEFAULT 1
21121
    |);
21121
    |);
21122
21122
21123
    SetVersion( $DBversion );
21123
    SetVersion( $DBversion );
21124
- 

Return to bug 24722