Lines 4647-4652
CREATE TABLE `message_queue` (
Link Here
|
4647 |
KEY `borrowernumber` (`borrowernumber`), |
4647 |
KEY `borrowernumber` (`borrowernumber`), |
4648 |
KEY `message_transport_type` (`message_transport_type`), |
4648 |
KEY `message_transport_type` (`message_transport_type`), |
4649 |
KEY `letter_fk` (`letter_id`), |
4649 |
KEY `letter_fk` (`letter_id`), |
|
|
4650 |
INDEX idx_mq_status (`status`), |
4650 |
CONSTRAINT `letter_fk` FOREIGN KEY (`letter_id`) REFERENCES `letter` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, |
4651 |
CONSTRAINT `letter_fk` FOREIGN KEY (`letter_id`) REFERENCES `letter` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, |
4651 |
CONSTRAINT `messageq_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
4652 |
CONSTRAINT `messageq_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
4652 |
CONSTRAINT `messageq_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON UPDATE CASCADE |
4653 |
CONSTRAINT `messageq_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON UPDATE CASCADE |
4653 |
- |
|
|