Lines 1700-1705
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
1700 |
`lowestPriority` tinyint(1) NOT NULL, -- has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no) |
1700 |
`lowestPriority` tinyint(1) NOT NULL, -- has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no) |
1701 |
`suspend` BOOLEAN NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no) |
1701 |
`suspend` BOOLEAN NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no) |
1702 |
`suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely) |
1702 |
`suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely) |
|
|
1703 |
reserve_group_id int unsigned NULL DEFAULT NULL, |
1703 |
PRIMARY KEY (`reserve_id`), |
1704 |
PRIMARY KEY (`reserve_id`), |
1704 |
KEY `old_reserves_borrowernumber` (`borrowernumber`), |
1705 |
KEY `old_reserves_borrowernumber` (`borrowernumber`), |
1705 |
KEY `old_reserves_biblionumber` (`biblionumber`), |
1706 |
KEY `old_reserves_biblionumber` (`biblionumber`), |
Lines 1711-1716
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
1711 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1712 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1712 |
CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) |
1713 |
CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) |
1713 |
ON DELETE SET NULL ON UPDATE SET NULL |
1714 |
ON DELETE SET NULL ON UPDATE SET NULL |
|
|
1715 |
CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (reserve_group_id) REFERENCES reserve_group (reserve_group_id) |
1716 |
ON DELETE SET NULL ON UPDATE CASCADE |
1714 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
1717 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
1715 |
|
1718 |
|
1716 |
-- |
1719 |
-- |
1717 |
- |
|
|