Lines 2331-2337
CREATE TABLE `message_queue` (
Link Here
|
2331 |
`from_address` mediumtext, |
2331 |
`from_address` mediumtext, |
2332 |
`content_type` text, |
2332 |
`content_type` text, |
2333 |
PRIMARY KEY (`message_id`), |
2333 |
PRIMARY KEY (`message_id`), |
2334 |
KEY `message_id` (`message_id`), |
|
|
2335 |
KEY `borrowernumber` (`borrowernumber`), |
2334 |
KEY `borrowernumber` (`borrowernumber`), |
2336 |
KEY `message_transport_type` (`message_transport_type`), |
2335 |
KEY `message_transport_type` (`message_transport_type`), |
2337 |
CONSTRAINT `messageq_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
2336 |
CONSTRAINT `messageq_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |