Attachment 129160 Details for Bug 29605 – Bug 29605: language_script_mapping.language_subtag cannot be null

[patch] Bug 29605: language_script_mapping.language_subtag cannot be null

Bug-29605-languagescriptmappinglanguagesubtag-cann.patch (text/plain), 1.24 KB, created by Nick Clemens (kidclamp) on 2022-01-07 13:16:33 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Nick Clemens (kidclamp)

Created: 2022-01-07 13:16:33 UTC

Size: 1.24 KB

patch

obsolete

>From 2c12104f710dea733f465c0d5cf41faffffae30a Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Thu, 2 Dec 2021 12:48:28 +0100
>Subject: [PATCH] Bug 29605: language_script_mapping.language_subtag cannot be
> null
>
>It's a PK now
>
>Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
>
>Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
>---
> installer/data/mysql/kohastructure.sql | 2 +-
> 1 file changed, 1 insertion(+), 1 deletion(-)
>
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 8a2c488ac1..43a5a04acf 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -3259,7 +3259,7 @@ DROP TABLE IF EXISTS `language_script_mapping`;
> /*!40101 SET @saved_cs_client     = @@character_set_client */;
> /*!40101 SET character_set_client = utf8 */;
> CREATE TABLE `language_script_mapping` (
>-  `language_subtag` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
>+  `language_subtag` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL,
>   `script_subtag` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
>   PRIMARY KEY `language_subtag` (`language_subtag`)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>-- 
>2.30.2

Actions: View | Diff | Splinter Review

Attachments on bug 29605: 128113 | 128114 | 128152 | 128153 | 128154 | 128155 | 128156 | 128157 | 128158 | 128239 | 128313 | 128314 | 128437 | 128438 | 128439 | 128440 | 128441 | 128442 | 128443 | 128444 | 128445 | 128483 | 129153 | 129154 | 129155 | 129156 | 129157 | 129158 | 129159 | 129160 | 129161