|
Lines 2915-2925
DROP TABLE IF EXISTS `edifact_errors`;
Link Here
|
| 2915 |
CREATE TABLE `edifact_errors` ( |
2915 |
CREATE TABLE `edifact_errors` ( |
| 2916 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2916 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
| 2917 |
`message_id` int(11) NOT NULL, |
2917 |
`message_id` int(11) NOT NULL, |
|
|
2918 |
`invoicenumber` varchar(48) DEFAULT NULL, |
| 2918 |
`date` date DEFAULT NULL, |
2919 |
`date` date DEFAULT NULL, |
| 2919 |
`section` mediumtext DEFAULT NULL, |
2920 |
`section` mediumtext DEFAULT NULL, |
| 2920 |
`details` mediumtext DEFAULT NULL, |
2921 |
`details` mediumtext DEFAULT NULL, |
| 2921 |
PRIMARY KEY (`id`), |
2922 |
PRIMARY KEY (`id`), |
| 2922 |
KEY `messageid` (`message_id`), |
2923 |
KEY `messageid` (`message_id`), |
|
|
2924 |
KEY `message_id_invoicenumber` (`message_id`, `invoicenumber`), |
| 2923 |
CONSTRAINT `emfk_message` FOREIGN KEY (`message_id`) REFERENCES `edifact_messages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
2925 |
CONSTRAINT `emfk_message` FOREIGN KEY (`message_id`) REFERENCES `edifact_messages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 2924 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2926 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2925 |
/*!40101 SET character_set_client = @saved_cs_client */; |
2927 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 2926 |
- |
|
|