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