Lines 2707-2712
DROP TABLE IF EXISTS `accountlines`;
Link Here
|
2707 |
CREATE TABLE `accountlines` ( |
2707 |
CREATE TABLE `accountlines` ( |
2708 |
`accountlines_id` int(11) NOT NULL AUTO_INCREMENT, |
2708 |
`accountlines_id` int(11) NOT NULL AUTO_INCREMENT, |
2709 |
`issue_id` int(11) NULL DEFAULT NULL, |
2709 |
`issue_id` int(11) NULL DEFAULT NULL, |
|
|
2710 |
`old_issue_id` int(11) NULL DEFAULT NULL, |
2710 |
`borrowernumber` int(11) DEFAULT NULL, |
2711 |
`borrowernumber` int(11) DEFAULT NULL, |
2711 |
`accountno` smallint(6) NOT NULL default 0, |
2712 |
`accountno` smallint(6) NOT NULL default 0, |
2712 |
`itemnumber` int(11) default NULL, |
2713 |
`itemnumber` int(11) default NULL, |
Lines 2726-2734
CREATE TABLE `accountlines` (
Link Here
|
2726 |
KEY `timeidx` (`timestamp`), |
2727 |
KEY `timeidx` (`timestamp`), |
2727 |
KEY `itemnumber` (`itemnumber`), |
2728 |
KEY `itemnumber` (`itemnumber`), |
2728 |
KEY `branchcode` (`branchcode`), |
2729 |
KEY `branchcode` (`branchcode`), |
|
|
2730 |
KEY `issue_id` (`issue_id`), |
2731 |
KEY `old_issue_id` (`old_issue_id`), |
2729 |
KEY `manager_id` (`manager_id`), |
2732 |
KEY `manager_id` (`manager_id`), |
2730 |
CONSTRAINT `accountlines_ibfk_borrowers` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
2733 |
CONSTRAINT `accountlines_ibfk_borrowers` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
2731 |
CONSTRAINT `accountlines_ibfk_items` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
2734 |
CONSTRAINT `accountlines_ibfk_items` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
|
|
2735 |
CONSTRAINT `accountlines_ibfk_issues` FOREIGN KEY (`issue_id`) REFERENCES `issues` (`issue_id`) ON DELETE SET NULL ON UPDATE CASCADE, |
2736 |
CONSTRAINT `accountlines_ibfk_old_issues` FOREIGN KEY (`old_issue_id`) REFERENCES `old_issues` (`issue_id`) ON DELETE SET NULL ON UPDATE CASCADE, |
2732 |
CONSTRAINT `accountlines_ibfk_borrowers_2` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
2737 |
CONSTRAINT `accountlines_ibfk_borrowers_2` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
2733 |
CONSTRAINT `accountlines_ibfk_branches` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE |
2738 |
CONSTRAINT `accountlines_ibfk_branches` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE |
2734 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2739 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2735 |
- |
|
|