Bugzilla – Attachment 176373 Details for
Bug 38689
EDIFACT errors should log to a staff accessible location
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 38689: Add edifact_errors table
Bug-38689-Add-edifacterrors-table.patch (text/plain), 1.56 KB, created by
Kyle M Hall (khall)
on 2025-01-10 17:24:23 UTC
(
hide
)
Description:
Bug 38689: Add edifact_errors table
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2025-01-10 17:24:23 UTC
Size:
1.56 KB
patch
obsolete
>From baf60c86150d4ab0ac62dcef6bf51c21b499e404 Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Date: Thu, 19 Dec 2024 16:55:40 +0000 >Subject: [PATCH] Bug 38689: Add edifact_errors table > >Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> >--- > 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.39.2
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 38689
:
175788
|
175789
|
175790
|
175793
|
175794
|
175795
|
175796
|
175797
|
175809
|
175810
|
175811
|
175812
|
175813
|
175814
|
175815
|
175816
|
175817
|
176127
|
176128
|
176129
|
176130
|
176131
|
176132
|
176133
|
176134
|
176173
|
176174
|
176175
|
176176
|
176177
|
176178
|
176179
|
176180
|
176181
|
176182
|
176183
|
176373
|
176374
|
176375
|
176376
|
176377
|
176378
|
176379
|
176380
|
176381
|
176382
|
176524
|
176525
|
176526
|
176527
|
176528
|
176529
|
176530
|
176531
|
176532
|
176533
|
176605
|
176606
|
176607
|
176608
|
176609
|
176610
|
176611
|
176612
|
176613
|
176614