Bugzilla – Attachment 38297 Details for
Bug 14030
Add Georgian language and fix Kannada language code
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 14030: Add Georgian language and fix Kannada language code
Bug-14030-Add-Georgian-language-and-fix-Kannada-la.patch (text/plain), 4.79 KB, created by
Mark Tompsett
on 2015-04-22 02:35:26 UTC
(
hide
)
Description:
Bug 14030: Add Georgian language and fix Kannada language code
Filename:
MIME Type:
Creator:
Mark Tompsett
Created:
2015-04-22 02:35:26 UTC
Size:
4.79 KB
patch
obsolete
>From 390f304256004f8b4421dbeef7caac772864aba1 Mon Sep 17 00:00:00 2001 >From: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> >Date: Mon, 20 Apr 2015 21:34:05 -0300 >Subject: [PATCH] Bug 14030: Add Georgian language and fix Kannada language > code > >This patch adds Georgian language and a fix wrong language code > >Language added: Georgian - ka - geo >I selected 'geo' for ISO639-2 instead of 'kat' because it's the >same code form http://www.loc.gov/marc/languages/language_code.html > >Also a fix is needed to Kannada ISO639-1 code, from 'ka' to 'kn' > >To test: >1) Apply the patch >2) Run updatedatabase.pl (once) >3) Check language, e.g. go to staff > search > More options > Limits >and search for Georgian on language list > >I only added language code 'ka', not script 'Geor' nor country 'GE', >the plan is to name translation files 'ka-*', but can ammend the patch >if needed. > >Signed-off-by: Mark Tompsett <mtompset@hotmail.com> >--- > .../bug_14030-Add_Georgian_fix_Kannada_code.sql | 21 +++++++++++++++ > installer/data/mysql/mandatory/subtag_registry.sql | 30 +++++++++++++++++++--- > 2 files changed, 47 insertions(+), 4 deletions(-) > create mode 100644 installer/data/mysql/atomicupdate/bug_14030-Add_Georgian_fix_Kannada_code.sql > >diff --git a/installer/data/mysql/atomicupdate/bug_14030-Add_Georgian_fix_Kannada_code.sql b/installer/data/mysql/atomicupdate/bug_14030-Add_Georgian_fix_Kannada_code.sql >new file mode 100644 >index 0000000..d07503e >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_14030-Add_Georgian_fix_Kannada_code.sql >@@ -0,0 +1,21 @@ >+UPDATE language_subtag_registry SET subtag = 'kn' WHERE subtag = 'ka' AND description = 'Kannada'; >+ >+UPDATE language_rfc4646_to_iso639 SET rfc4646_subtag = 'kn' WHERE rfc4646_subtag = 'ka' AND iso639_2_code = 'kan'; >+ >+UPDATE language_descriptions SET subtag = 'kn', lang = 'kn' WHERE subtag = 'ka' AND lang = 'ka' AND description = 'à²à²¨à³à²¨à²¡'; >+ >+UPDATE language_descriptions SET subtag = 'kn' WHERE subtag = 'ka' AND description = 'Kannada'; >+ >+INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ka', 'language', 'Georgian','2015-04-20'); >+ >+INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ka', 'geo'); >+ >+INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'ka', 'á¥áá áá£áá'); >+ >+INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'en', 'Georgian'); >+ >+INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'fr', 'Géorgien'); >+ >+INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'de', 'Georgische'); >+ >+INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'es', 'Georgiano'); >diff --git a/installer/data/mysql/mandatory/subtag_registry.sql b/installer/data/mysql/mandatory/subtag_registry.sql >index 6001fff..bdf2631 100755 >--- a/installer/data/mysql/mandatory/subtag_registry.sql >+++ b/installer/data/mysql/mandatory/subtag_registry.sql >@@ -537,18 +537,40 @@ VALUES ( 'ja', 'language', 'fr', 'Japonais'); > INSERT INTO language_descriptions(subtag, type, lang, description) > VALUES ( 'ja', 'language', 'de', 'Japanisch'); > >+-- Georgian >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'ka', 'language', 'Georgian','2015-04-20'); >+ >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'ka', 'geo'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'ka', 'language', 'ka', 'á¥áá áá£áá'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'ka', 'language', 'en', 'Georgian'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'ka', 'language', 'fr', 'Géorgien'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'ka', 'language', 'de', 'Georgische'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'ka', 'language', 'es', 'Georgiano'); >+ > -- Kannada > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'ka', 'language', 'Kannada','2014-10-30'); >+VALUES ( 'kn', 'language', 'Kannada','2014-10-30'); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES ( 'ka','kan'); >+VALUES ( 'kn', 'kan'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES ( 'ka', 'language', 'ka', 'à²à²¨à³à²¨à²¡'); >+VALUES ( 'kn', 'language', 'kn', 'à²à²¨à³à²¨à²¡'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES ( 'ka', 'language', 'en', 'Kannada'); >+VALUES ( 'kn', 'language', 'en', 'Kannada'); > > -- Khmer > INSERT INTO language_subtag_registry( subtag, type, description, added) >-- >1.9.1
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 14030
:
38224
|
38296
|
38297
|
38298
|
38344
|
38356
|
38357