Attachment 132510 Details for Bug 24975 – Bug 24975: Fix l10n_source definition in kohastructure.sql

[patch] Bug 24975: Fix l10n_source definition in kohastructure.sql

Bug-24975-Fix-l10nsource-definition-in-kohastructu.patch (text/plain), 1.22 KB, created by Martin Renvoize (ashimema) on 2022-03-30 06:37:45 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Martin Renvoize (ashimema)

Created: 2022-03-30 06:37:45 UTC

Size: 1.22 KB

patch

obsolete

>From 621c99a90858736f447f9689981f8a3d2a0bf769 Mon Sep 17 00:00:00 2001
>From: Julian Maurice <julian.maurice@biblibre.com>
>Date: Fri, 10 Apr 2020 11:29:10 +0200
>Subject: [PATCH] Bug 24975: Fix l10n_source definition in kohastructure.sql
>
>https://bugs.koha-community.org/show_bug.cgi?id=24875
>---
> installer/data/mysql/kohastructure.sql | 8 +++++---
> 1 file changed, 5 insertions(+), 3 deletions(-)
>
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 9cf2214776..70c59b5812 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -3207,10 +3207,12 @@ CREATE TABLE `keyboard_shortcuts` (
> DROP TABLE IF EXISTS l10n_source;
> CREATE TABLE l10n_source (
>     l10n_source_id INT(11) NOT NULL AUTO_INCREMENT,
>-    context VARCHAR(100) NULL DEFAULT NULL,
>-    source TEXT NOT NULL,
>+    `group` VARCHAR(100) NULL DEFAULT NULL,
>+    `key` VARCHAR(100) NOT NULL,
>+    `text` TEXT NOT NULL,
>     PRIMARY KEY (l10n_source_id),
>-    KEY context_source (context, source(60))
>+    UNIQUE KEY group_key (`group`, `key`),
>+    KEY group_text (`group`, `text`(60))
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
> 
> DROP TABLE IF EXISTS l10n_target;
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 24975: 101703 | 101786 | 102387 | 102388 | 102513 | 102514 | 102688 | 102701 | 132388 | 132508 | 132509 | 132510 | 132511 | 132512 | 132513 | 132514 | 132515 | 132516 | 132517 | 132518 | 132519 | 132520 | 132521 | 132522 | 132523 | 132524 | 132525 | 132526 | 132527 | 132528 | 132529 | 132530 | 132531 | 132532 | 132533 | 132546 | 132562 | 132563 | 132564 | 132565 | 132566 | 132567 | 132568 | 132569 | 132570 | 132571 | 132572 | 132573 | 132574 | 132575 | 149941 | 149942 | 149943 | 149944 | 149945 | 149946 | 149947 | 149948 | 149949 | 149950 | 149951 | 149952 | 149953 | 149954 | 149956 | 149957 | 150015 | 150033 | 150034