From 621c99a90858736f447f9689981f8a3d2a0bf769 Mon Sep 17 00:00:00 2001 From: Julian Maurice 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