From 58aa1baf60fd9cff10b0396dbba4308ceeeb4a34 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Thu, 19 Dec 2024 16:55:40 +0000 Subject: [PATCH] Bug 38689: Add edifact_errors table --- installer/data/mysql/kohastructure.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 3bf15c1007d..cfc81124192 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2903,6 +2903,25 @@ 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.47.1