From 627175b8c9ba0666dab76305131398190b114c32 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 5 May 2025 13:59:54 +0200 Subject: [PATCH] Bug 38689: Correctly place edifact_errors in kohastructure.sql --- installer/data/mysql/kohastructure.sql | 38 +++++++++++++------------- 1 file changed, 19 insertions(+), 19 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 795aaee4881..48a50b5f5b7 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2897,6 +2897,25 @@ CREATE TABLE `edifact_ean` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `edifact_errors` +-- + +DROP TABLE IF EXISTS `edifact_errors`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `edifact_errors` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `message_id` int(11) NOT NULL, + `date` date DEFAULT NULL, + `section` mediumtext DEFAULT NULL, + `details` mediumtext DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `messageid` (`message_id`), + CONSTRAINT `emfk_message` FOREIGN KEY (`message_id`) REFERENCES `edifact_messages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `edifact_messages` -- @@ -2925,25 +2944,6 @@ CREATE TABLE `edifact_messages` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; --- --- Table structure for table `edifact_errors` --- - -DROP TABLE IF EXISTS `edifact_errors`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `edifact_errors` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `message_id` int(11) NOT NULL, - `date` date DEFAULT NULL, - `section` mediumtext DEFAULT NULL, - `details` mediumtext DEFAULT NULL, - PRIMARY KEY (`id`), - KEY `messageid` (`message_id`), - CONSTRAINT `emfk_message` FOREIGN KEY (`message_id`) REFERENCES `edifact_messages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -/*!40101 SET character_set_client = @saved_cs_client */; - -- -- Table structure for table `erm_agreement_licenses` -- -- 2.34.1