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

(-)a/installer/data/mysql/kohastructure.sql (-4 / +3 lines)
Lines 1464-1472 CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b Link Here
1464
  `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
1464
  `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
1465
  `waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library
1465
  `waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library
1466
  `expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date)
1466
  `expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date)
1467
  `lowestPriority` tinyint(1) NOT NULL,
1467
  `lowestPriority` tinyint(1) NOT NULL, -- has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no)
1468
  `suspend` BOOLEAN NOT NULL DEFAULT 0,
1468
  `suspend` BOOLEAN NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no)
1469
  `suspend_until` DATETIME NULL DEFAULT NULL,
1469
  `suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely)
1470
  PRIMARY KEY (`reserve_id`),
1470
  PRIMARY KEY (`reserve_id`),
1471
  KEY `old_reserves_borrowernumber` (`borrowernumber`),
1471
  KEY `old_reserves_borrowernumber` (`borrowernumber`),
1472
  KEY `old_reserves_biblionumber` (`biblionumber`),
1472
  KEY `old_reserves_biblionumber` (`biblionumber`),
1473
- 

Return to bug 6716