From 1ab25bf83b598fa31d398caea99c700ae8d3bcda 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 --- 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 e785c12ca1..c2790a3e9e 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3715,10 +3715,12 @@ CREATE TABLE `additional_field_values` ( 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