Lines 2717-2729
CREATE TABLE `accountlines` (
Link Here
|
2717 |
`lastincrement` decimal(28,6) default NULL, |
2717 |
`lastincrement` decimal(28,6) default NULL, |
2718 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
2718 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
2719 |
`note` MEDIUMTEXT NULL default NULL, |
2719 |
`note` MEDIUMTEXT NULL default NULL, |
2720 |
`manager_id` int(11) NULL, |
2720 |
`manager_id` int(11) NULL DEFAULT NULL, |
2721 |
PRIMARY KEY (`accountlines_id`), |
2721 |
PRIMARY KEY (`accountlines_id`), |
2722 |
KEY `acctsborridx` (`borrowernumber`), |
2722 |
KEY `acctsborridx` (`borrowernumber`), |
2723 |
KEY `timeidx` (`timestamp`), |
2723 |
KEY `timeidx` (`timestamp`), |
2724 |
KEY `itemnumber` (`itemnumber`), |
2724 |
KEY `itemnumber` (`itemnumber`), |
|
|
2725 |
KEY `issue_id` (`issue_id`), |
2726 |
KEY `manager_id` (`manager_id`), |
2725 |
CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
2727 |
CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
2726 |
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 CASCADE, |
|
|
2729 |
CONSTRAINT `accountlines_ibfk_issues` FOREIGN KEY (`issue_id`) REFERENCES `issues` (`issue_id`) ON DELETE SET NULL ON UPDATE CASCADE, |
2730 |
CONSTRAINT `accountlines_ibfk_borrowers_m` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE |
2727 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2731 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2728 |
|
2732 |
|
2729 |
-- |
2733 |
-- |
2730 |
- |
|
|