Lines 1780-1786
CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
Link Here
|
1780 |
CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) |
1780 |
CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) |
1781 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1781 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1782 |
CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) |
1782 |
CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) |
1783 |
ON DELETE SET NULL ON UPDATE SET NULL |
1783 |
ON DELETE SET NULL ON UPDATE SET NULL, |
|
|
1784 |
CONSTRAINT `old_reserves_ibfk_5` FOREIGN KEY (reserve_group_id) REFERENCES reserve_group (reserve_group_id) |
1785 |
ON DELETE SET NULL ON UPDATE CASCADE |
1784 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1786 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1785 |
|
1787 |
|
1786 |
-- |
1788 |
-- |
Lines 1933-1938
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
1933 |
`suspend` BOOLEAN NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no) |
1935 |
`suspend` BOOLEAN NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no) |
1934 |
`suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely) |
1936 |
`suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely) |
1935 |
`itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting |
1937 |
`itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting |
|
|
1938 |
`reserve_group_id` int unsigned NULL DEFAULT NULL, -- The id of a group of titles reservations fulfilled when one title is picked |
1936 |
PRIMARY KEY (`reserve_id`), |
1939 |
PRIMARY KEY (`reserve_id`), |
1937 |
KEY `old_reserves_borrowernumber` (`borrowernumber`), |
1940 |
KEY `old_reserves_borrowernumber` (`borrowernumber`), |
1938 |
KEY `old_reserves_biblionumber` (`biblionumber`), |
1941 |
KEY `old_reserves_biblionumber` (`biblionumber`), |
1939 |
- |
|
|