Lines 2684-2698
CREATE TABLE `accountlines` (
Link Here
|
2684 |
`lastincrement` decimal(28,6) default NULL, |
2684 |
`lastincrement` decimal(28,6) default NULL, |
2685 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
2685 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
2686 |
`note` MEDIUMTEXT NULL default NULL, |
2686 |
`note` MEDIUMTEXT NULL default NULL, |
2687 |
`manager_id` int(11) NULL, |
2687 |
`manager_id` int(11) NULL DEFAULT NULL, |
2688 |
`branchcode` VARCHAR( 10 ) NULL DEFAULT NULL, -- the branchcode of the library where a payment was made, a manual invoice created, etc. |
2688 |
`branchcode` VARCHAR( 10 ) NULL DEFAULT NULL, -- the branchcode of the library where a payment was made, a manual invoice created, etc. |
2689 |
PRIMARY KEY (`accountlines_id`), |
2689 |
PRIMARY KEY (`accountlines_id`), |
2690 |
KEY `acctsborridx` (`borrowernumber`), |
2690 |
KEY `acctsborridx` (`borrowernumber`), |
2691 |
KEY `timeidx` (`timestamp`), |
2691 |
KEY `timeidx` (`timestamp`), |
2692 |
KEY `itemnumber` (`itemnumber`), |
2692 |
KEY `itemnumber` (`itemnumber`), |
2693 |
KEY `branchcode` (`branchcode`), |
2693 |
KEY `branchcode` (`branchcode`), |
|
|
2694 |
KEY `manager_id` (`manager_id`), |
2694 |
CONSTRAINT `accountlines_ibfk_borrowers` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
2695 |
CONSTRAINT `accountlines_ibfk_borrowers` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
2695 |
CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL, |
2696 |
CONSTRAINT `accountlines_ibfk_items` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
|
|
2697 |
CONSTRAINT `accountlines_ibfk_borrowers_2` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
2696 |
CONSTRAINT `accountlines_ibfk_branches` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE |
2698 |
CONSTRAINT `accountlines_ibfk_branches` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE |
2697 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2699 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2698 |
|
2700 |
|
2699 |
- |
|
|