Lines 2697-2708
CREATE TABLE `accountlines` (
Link Here
|
2697 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
2697 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
2698 |
`note` MEDIUMTEXT NULL default NULL, |
2698 |
`note` MEDIUMTEXT NULL default NULL, |
2699 |
`manager_id` int(11) NULL, |
2699 |
`manager_id` int(11) NULL, |
|
|
2700 |
`branchcode` varchar(10) default NULL, -- library where the accountline was created |
2700 |
PRIMARY KEY (`accountlines_id`), |
2701 |
PRIMARY KEY (`accountlines_id`), |
2701 |
KEY `acctsborridx` (`borrowernumber`), |
2702 |
KEY `acctsborridx` (`borrowernumber`), |
2702 |
KEY `timeidx` (`timestamp`), |
2703 |
KEY `timeidx` (`timestamp`), |
2703 |
KEY `itemnumber` (`itemnumber`), |
2704 |
KEY `itemnumber` (`itemnumber`), |
2704 |
CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
2705 |
CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
2705 |
CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL |
2706 |
CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL, |
|
|
2707 |
CONSTRAINT `accountlines_ibfk_3` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE |
2706 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2708 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2707 |
|
2709 |
|
2708 |
-- |
2710 |
-- |
2709 |
- |
|
|