Bugzilla – Attachment 94702 Details for
Bug 20307
Language overlay for authorized values
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 20307: Update the localization unique key
Bug-20307-Update-the-localization-unique-key.patch (text/plain), 1.68 KB, created by
Michal Denar
on 2019-10-24 21:44:15 UTC
(
hide
)
Description:
Bug 20307: Update the localization unique key
Filename:
MIME Type:
Creator:
Michal Denar
Created:
2019-10-24 21:44:15 UTC
Size:
1.68 KB
patch
obsolete
>From 1b44dfc89297c29450343a79ca1a9f23a9aec58b Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Wed, 28 Feb 2018 11:22:15 -0300 >Subject: [PATCH] Bug 20307: Update the localization unique key > >Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> > >Signed-off-by: Michal Denar <black23@gmail.com> >--- > installer/data/mysql/atomicupdate/bug_20307.sql | 2 ++ > installer/data/mysql/kohastructure.sql | 2 +- > 2 files changed, 3 insertions(+), 1 deletion(-) > >diff --git a/installer/data/mysql/atomicupdate/bug_20307.sql b/installer/data/mysql/atomicupdate/bug_20307.sql >index 0655e771b8..05ad215edf 100644 >--- a/installer/data/mysql/atomicupdate/bug_20307.sql >+++ b/installer/data/mysql/atomicupdate/bug_20307.sql >@@ -1 +1,3 @@ > alter table localization add column interface varchar(30) default null after entity; >+alter table localization drop constraint entity_code_lang; >+alter table localization add unique key entity_code_interface_lang (entity, code, interface, lang); >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index f0687711bb..81b98abe9d 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -3738,7 +3738,7 @@ CREATE TABLE `localization` ( > lang varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL, -- could be a foreign key > translation MEDIUMTEXT COLLATE utf8mb4_unicode_ci, > PRIMARY KEY (localization_id), >- UNIQUE KEY `entity_code_lang` (`entity`,`code`,`lang`) >+ UNIQUE KEY `entity_code_interface_lang` (`entity`,`code`,`interface`,`lang`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > > -- >-- >2.11.0
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 20307
:
86622
|
86623
|
86624
|
86625
|
86626
|
86627
|
89538
|
91645
|
91646
|
91647
|
91648
|
91649
|
91650
|
91651
|
91653
|
92192
|
92193
|
92359
|
92360
|
92361
|
94245
|
94246
|
94247
|
94248
|
94249
|
94250
|
94251
|
94252
|
94253
|
94254
|
94255
|
94256
|
94700
|
94701
|
94702
|
94703
|
94704
|
94705
|
94706
|
94707
|
94708
|
94709
|
94710
|
94711
|
97074
|
97075
|
98863
|
98864
|
98865
|
98866
|
98867
|
98868
|
98869
|
98870
|
98871
|
98872
|
98873
|
98874
|
98875
|
98876
|
101070
|
101450