|
Lines 4256-4265
DROP TABLE IF EXISTS `items_last_borrower`;
Link Here
|
| 4256 |
CREATE TABLE `items_last_borrower` ( |
4256 |
CREATE TABLE `items_last_borrower` ( |
| 4257 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
4257 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
| 4258 |
`itemnumber` int(11) NOT NULL, |
4258 |
`itemnumber` int(11) NOT NULL, |
| 4259 |
`borrowernumber` int(11) NULL, |
4259 |
`borrowernumber` int(11) DEFAULT NULL, |
| 4260 |
`created_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), |
4260 |
`created_on` timestamp NOT NULL DEFAULT current_timestamp(), |
| 4261 |
PRIMARY KEY (`id`), |
4261 |
PRIMARY KEY (`id`), |
| 4262 |
KEY `borrowernumber` (`borrowernumber`), |
4262 |
KEY `borrowernumber` (`borrowernumber`), |
|
|
4263 |
KEY `items_last_borrower_ibfk_1` (`itemnumber`), |
| 4263 |
CONSTRAINT `items_last_borrower_ibfk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
4264 |
CONSTRAINT `items_last_borrower_ibfk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 4264 |
CONSTRAINT `items_last_borrower_ibfk_2` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE |
4265 |
CONSTRAINT `items_last_borrower_ibfk_2` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE |
| 4265 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4266 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4266 |
- |
|
|