|
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 |
- |
|
|