|
Lines 2897-2902
CREATE TABLE `edifact_ean` (
Link Here
|
| 2897 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2897 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2898 |
/*!40101 SET character_set_client = @saved_cs_client */; |
2898 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 2899 |
|
2899 |
|
|
|
2900 |
-- |
| 2901 |
-- Table structure for table `edifact_errors` |
| 2902 |
-- |
| 2903 |
|
| 2904 |
DROP TABLE IF EXISTS `edifact_errors`; |
| 2905 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 2906 |
/*!40101 SET character_set_client = utf8 */; |
| 2907 |
CREATE TABLE `edifact_errors` ( |
| 2908 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
| 2909 |
`message_id` int(11) NOT NULL, |
| 2910 |
`date` date DEFAULT NULL, |
| 2911 |
`section` mediumtext DEFAULT NULL, |
| 2912 |
`details` mediumtext DEFAULT NULL, |
| 2913 |
PRIMARY KEY (`id`), |
| 2914 |
KEY `messageid` (`message_id`), |
| 2915 |
CONSTRAINT `emfk_message` FOREIGN KEY (`message_id`) REFERENCES `edifact_messages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 2916 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2917 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 2918 |
|
| 2900 |
-- |
2919 |
-- |
| 2901 |
-- Table structure for table `edifact_messages` |
2920 |
-- Table structure for table `edifact_messages` |
| 2902 |
-- |
2921 |
-- |
|
Lines 2925-2949
CREATE TABLE `edifact_messages` (
Link Here
|
| 2925 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2944 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2926 |
/*!40101 SET character_set_client = @saved_cs_client */; |
2945 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 2927 |
|
2946 |
|
| 2928 |
-- |
|
|
| 2929 |
-- Table structure for table `edifact_errors` |
| 2930 |
-- |
| 2931 |
|
| 2932 |
DROP TABLE IF EXISTS `edifact_errors`; |
| 2933 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 2934 |
/*!40101 SET character_set_client = utf8 */; |
| 2935 |
CREATE TABLE `edifact_errors` ( |
| 2936 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
| 2937 |
`message_id` int(11) NOT NULL, |
| 2938 |
`date` date DEFAULT NULL, |
| 2939 |
`section` mediumtext DEFAULT NULL, |
| 2940 |
`details` mediumtext DEFAULT NULL, |
| 2941 |
PRIMARY KEY (`id`), |
| 2942 |
KEY `messageid` (`message_id`), |
| 2943 |
CONSTRAINT `emfk_message` FOREIGN KEY (`message_id`) REFERENCES `edifact_messages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 2944 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2945 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 2946 |
|
| 2947 |
-- |
2947 |
-- |
| 2948 |
-- Table structure for table `erm_agreement_licenses` |
2948 |
-- Table structure for table `erm_agreement_licenses` |
| 2949 |
-- |
2949 |
-- |
| 2950 |
- |
|
|