Lines 1681-1687
CREATE TABLE `issues` ( -- information related to check outs or issues
Link Here
|
1681 |
KEY `branchcode_idx` (`branchcode`), |
1681 |
KEY `branchcode_idx` (`branchcode`), |
1682 |
KEY `bordate` (`borrowernumber`,`timestamp`), |
1682 |
KEY `bordate` (`borrowernumber`,`timestamp`), |
1683 |
CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE RESTRICT ON UPDATE CASCADE, |
1683 |
CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE RESTRICT ON UPDATE CASCADE, |
1684 |
CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE RESTRICT ON UPDATE CASCADE |
1684 |
CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE RESTRICT ON UPDATE CASCADE, |
|
|
1685 |
CONSTRAINT `issues_ibfk_3` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE RESTRICT ON UPDATE CASCADE |
1685 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1686 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1686 |
|
1687 |
|
1687 |
-- |
1688 |
-- |
Lines 1711-1720
CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
Link Here
|
1711 |
KEY `old_issuesitemidx` (`itemnumber`), |
1712 |
KEY `old_issuesitemidx` (`itemnumber`), |
1712 |
KEY `branchcode_idx` (`branchcode`), |
1713 |
KEY `branchcode_idx` (`branchcode`), |
1713 |
KEY `old_bordate` (`borrowernumber`,`timestamp`), |
1714 |
KEY `old_bordate` (`borrowernumber`,`timestamp`), |
1714 |
CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) |
1715 |
CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL, |
1715 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1716 |
CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL, |
1716 |
CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) |
1717 |
CONSTRAINT `old_issues_ibfk_3` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE RESTRICT ON UPDATE CASCADE |
1717 |
ON DELETE SET NULL ON UPDATE SET NULL |
|
|
1718 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1718 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1719 |
|
1719 |
|
1720 |
-- |
1720 |
-- |
1721 |
- |
|
|