Lines 1704-1710
CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
Link Here
|
1704 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1704 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1705 |
CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) |
1705 |
CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) |
1706 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1706 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1707 |
CONSTRAINT `old_issues_ibfk_borrowers_borrowernumber` FOREIGN KEY (`issuer_id`) REFERENCES `borrowers` (`borrowernumber`), |
1707 |
CONSTRAINT `old_issues_ibfk_borrowers_borrowernumber` FOREIGN KEY (`issuer_id`) REFERENCES `borrowers` (`borrowernumber`) |
1708 |
ON DELETE SET NULL ON UPDATE CASCADE |
1708 |
ON DELETE SET NULL ON UPDATE CASCADE |
1709 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1709 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1710 |
|
1710 |
|
Lines 1838-1844
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
Link Here
|
1838 |
CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
1838 |
CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
1839 |
CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE, |
1839 |
CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE, |
1840 |
CONSTRAINT `reserves_ibfk_6` FOREIGN KEY (`desk_id`) REFERENCES `desks` (`desk_id`) ON DELETE SET NULL ON UPDATE CASCADE, |
1840 |
CONSTRAINT `reserves_ibfk_6` FOREIGN KEY (`desk_id`) REFERENCES `desks` (`desk_id`) ON DELETE SET NULL ON UPDATE CASCADE, |
1841 |
CONSTRAINT `reserves_ibfk_7` FOREIGN KEY (`hold_group_id`) REFERENCES `hold_group` (`hold_group_id`) ON DELETE SET NULL ON UPDATE CASCADE |
1841 |
CONSTRAINT `reserves_ibfk_hold_group` FOREIGN KEY (`hold_group_id`) REFERENCES `hold_group` (`hold_group_id`) ON DELETE SET NULL ON UPDATE CASCADE |
1842 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1842 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1843 |
|
1843 |
|
1844 |
-- |
1844 |
-- |
Lines 1885-1891
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
1885 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1885 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1886 |
CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) |
1886 |
CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) |
1887 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1887 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1888 |
CONSTRAINT `old_reserves_ibfk_5` FOREIGN KEY (`hold_group_id`) REFERENCES `hold_group` (`hold_group_id`) |
1888 |
CONSTRAINT `old_reserves_ibfk_hold_group` FOREIGN KEY (`hold_group_id`) REFERENCES `hold_group` (`hold_group_id`) |
1889 |
ON DELETE SET NULL ON UPDATE CASCADE |
1889 |
ON DELETE SET NULL ON UPDATE CASCADE |
1890 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1890 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1891 |
|
1891 |
|
1892 |
- |
|
|