Bugzilla – Attachment 181908 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: Correctly place edifact_errors in kohastructure.sql
Bug-38689-Correctly-place-edifacterrors-in-kohastr.patch (text/plain), 2.51 KB, created by
Jonathan Druart
on 2025-05-05 12:00:13 UTC
(
hide
)
Description:
Bug 38689: Correctly place edifact_errors in kohastructure.sql
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2025-05-05 12:00:13 UTC
Size:
2.51 KB
patch
obsolete
>From 627175b8c9ba0666dab76305131398190b114c32 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >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
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
|
178359
|
178360
|
178361
|
178362
|
178363
|
178364
|
178365
|
178366
|
178367
|
178368
|
178492
|
178493
|
178494
|
178495
|
178496
|
178497
|
178498
|
178499
|
178500
|
178501
|
178719
| 181908