|
Lines 2582-2589
CREATE TABLE `message_transports` (
Link Here
|
| 2582 |
KEY `message_transport_type` (`message_transport_type`), |
2582 |
KEY `message_transport_type` (`message_transport_type`), |
| 2583 |
KEY `letter_module` (`letter_module`,`letter_code`), |
2583 |
KEY `letter_module` (`letter_module`,`letter_code`), |
| 2584 |
CONSTRAINT `message_transports_ibfk_1` FOREIGN KEY (`message_attribute_id`) REFERENCES `message_attributes` (`message_attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
2584 |
CONSTRAINT `message_transports_ibfk_1` FOREIGN KEY (`message_attribute_id`) REFERENCES `message_attributes` (`message_attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 2585 |
CONSTRAINT `message_transports_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE, |
2585 |
CONSTRAINT `message_transports_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE |
| 2586 |
CONSTRAINT `message_transports_ibfk_3` FOREIGN KEY (`letter_module`, `letter_code`, `branchcode`) REFERENCES `letter` (`module`, `code`, `branchcode`) ON DELETE CASCADE ON UPDATE CASCADE |
|
|
| 2587 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2586 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2588 |
|
2587 |
|
| 2589 |
-- |
2588 |
-- |
| 2590 |
- |
|
|