Bug 9519: fix code for Italian language search limiter

[srvgit] / installer / data / mysql / it-IT / necessari / subtag_registry.sql

diff --git a/installer/data/mysql/it-IT/necessari/subtag_registry.sql b/installer/data/mysql/it-IT/necessari/subtag_registry.sql
index 48f4f6b..43e5a14 100644 (file)
--- a/installer/data/mysql/it-IT/necessari/subtag_registry.sql
+++ b/installer/data/mysql/it-IT/necessari/subtag_registry.sql
@@ -314,7 +314,7 @@ INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'it', 'language', 'Italian','2005-10-16' );
 
 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
-VALUES( 'it','ind');
+VALUES( 'it','ita');
 
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'it', 'language', 'it', 'Italiano');
@@ -387,21 +387,43 @@ VALUES( 'gl', 'language', 'gl', 'Galego');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'gl', 'language', 'en', 'Galician');
 
--- Norwegian
+-- Norwegian (bokmål)
 INSERT INTO language_subtag_registry( subtag, type, description, added)
-VALUES ( 'nb', 'language', 'Norwegian','2005-10-16' );
+VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' );
 
 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
 VALUES( 'nb','nor');
 
+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
+VALUES( 'nb','nob');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'nb', 'language', 'nb', 'Norsk bokmål');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'nb', 'language', 'en', 'Norwegian bokmål');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål');
+
+-- Norwegian (nynorsk)
+INSERT INTO language_subtag_registry( subtag, type, description, added)
+VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' );
+
+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
+VALUES( 'nn','nno');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk');
+
 INSERT INTO language_descriptions(subtag, type, lang, description)
-VALUES( 'nb', 'language', 'nb', 'Norsk');
+VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk');
 
 INSERT INTO language_descriptions(subtag, type, lang, description)
-VALUES( 'nb', 'language', 'en', 'Norwegian');
+VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk');
 
 INSERT INTO language_descriptions(subtag, type, lang, description)
-VALUES( 'nb', 'language', 'fr', 'Norvégien');
+VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk');
 
 -- Persian
 INSERT INTO language_subtag_registry( subtag, type, description, added)
@@ -509,6 +531,28 @@ VALUES( 'es', 'language', 'en', 'Spanish');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'es', 'language', 'fr', 'Espagnol');
 
+-- Spanish, Catalan
+INSERT INTO language_subtag_registry( subtag, type, description, added)
+VALUES ( 'ca', 'language', 'Catalan','2013-01-12' );
+
+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
+VALUES( 'ca','cat');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'ca', 'language', 'es', 'Catalán');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'ca', 'language', 'en', 'Catalan');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'ca', 'language', 'fr', 'Catalan');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'ca', 'language', 'ca', 'Català');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'ca', 'language', 'de', 'Katalanisch');
+
 -- Swedish
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );