Lines 2723-2730
CREATE TABLE `accountlines` (
Link Here
|
2723 |
KEY `acctsborridx` (`borrowernumber`), |
2723 |
KEY `acctsborridx` (`borrowernumber`), |
2724 |
KEY `timeidx` (`timestamp`), |
2724 |
KEY `timeidx` (`timestamp`), |
2725 |
KEY `itemnumber` (`itemnumber`), |
2725 |
KEY `itemnumber` (`itemnumber`), |
|
|
2726 |
KEY `branchcode` (`branchcode`), |
2726 |
CONSTRAINT `accountlines_ibfk_borrowers` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
2727 |
CONSTRAINT `accountlines_ibfk_borrowers` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
2727 |
CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL |
2728 |
CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL, |
|
|
2729 |
CONSTRAINT `accountlines_ibfk_branches` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE SET CASCADE |
2728 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2730 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2729 |
|
2731 |
|
2730 |
-- |
2732 |
-- |
2731 |
- |
|
|