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