Bug 9381: Add Catalan language

[koha.git] / installer / data / mysql / en / mandatory / subtag_registry.sql

diff --git a/installer/data/mysql/en/mandatory/subtag_registry.sql b/installer/data/mysql/en/mandatory/subtag_registry.sql
old mode 100644 (file)
new mode 100755 (executable)
index 90a3bed..b9cbd3c
--- a/installer/data/mysql/en/mandatory/subtag_registry.sql
+++ b/installer/data/mysql/en/mandatory/subtag_registry.sql
@@ -63,6 +63,9 @@ VALUES( 'ar', 'language', 'en', 'Arabic');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'ar', 'language', 'fr', 'Arabe');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'ar', 'language', 'de', 'Arabisch');
+
 -- Armenian
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'hy', 'language', 'Armenian','2005-10-16');
@@ -79,6 +82,9 @@ VALUES( 'hy', 'language', 'en', 'Armenian');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'hy', 'language', 'fr', 'Armenian');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'hy', 'language', 'de', 'Armenisch');
+
 -- Bulgarian
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16');
@@ -95,6 +101,9 @@ VALUES( 'bg', 'language', 'en', 'Bulgarian');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'bg', 'language', 'fr', 'Bulgare');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'bg', 'language', 'de', 'Bulgarisch');
+
 -- Chinese
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
@@ -111,6 +120,9 @@ VALUES( 'zh', 'language', 'en', 'Chinese');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'zh', 'language', 'fr', 'Chinois');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'zh', 'language', 'de', 'Chinesisch');
+
 -- Czech
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'cs', 'language', 'Czech','2005-10-16' );
@@ -127,6 +139,9 @@ VALUES( 'cs', 'language', 'en', 'Czech');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'cs', 'language', 'fr', 'Tchèque');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'cs', 'language', 'de', 'Tschechisch');
+
 -- Danish
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'da', 'language', 'Danish','2005-10-16' );
@@ -143,6 +158,9 @@ VALUES( 'da', 'language', 'en', 'Danish');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'da', 'language', 'fr', 'Danois');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'da', 'language', 'de', 'Dänisch');
+
 -- Dutch, Flemish
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'nl', 'language', 'Dutch','2005-10-16' );
@@ -159,6 +177,9 @@ VALUES( 'nl', 'language', 'en', 'Dutch');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'nl', 'language', 'fr', 'Néerlandais');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'nl', 'language', 'de', 'Niederländisch');
+
 -- English
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'en', 'language', 'English','2005-10-16' );
@@ -172,6 +193,9 @@ VALUES( 'en', 'language', 'en', 'English');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'en', 'language', 'fr', 'Anglais');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'en', 'language', 'de', 'Englisch');
+
 -- Finnish
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'fi', 'language', 'Finnish','2005-10-16' );
@@ -185,6 +209,9 @@ VALUES( 'fi', 'language', 'fi', 'suomi');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'fi', 'language', 'en', 'Finnish');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'fi', 'language', 'de', 'Finnisch');
+
 -- French
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'fr', 'language', 'French','2005-10-16' );
@@ -198,6 +225,9 @@ VALUES( 'fr', 'language', 'en', 'French');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'fr', 'language', 'fr', 'Français');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'fr', 'language', 'de', 'Französisch');
+
 -- INSERT INTO language_descriptions(subtag, type, lang, description)
 -- VALUES( 'fr-CA', 'language', 'fr-CA', 'français');
 
@@ -214,6 +244,12 @@ VALUES( 'lo', 'language', 'lo', 'ພາສາລາ&#375
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'lo', 'language', 'en', 'Lao');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'lo', 'language', 'fr', 'Laotien');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'lo', 'language', 'de', 'Laotisch');
+
 -- German
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'de', 'language', 'German','2005-10-16' );
@@ -246,6 +282,9 @@ VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'el', 'language', 'de', 'Griechisch (Nach 1453)');
+
 -- Hebrew
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'he', 'language', 'Hebrew','2005-10-16');
@@ -262,6 +301,9 @@ VALUES( 'he', 'language', 'en', 'Hebrew');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'he', 'language', 'fr', 'Hébreu');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'he', 'language', 'de', 'Hebräisch');
+
 -- Hindi
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'hi', 'language', 'Hindi','2005-10-16');
@@ -278,6 +320,9 @@ VALUES( 'hi', 'language', 'en', 'Hindi');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'hi', 'language', 'fr', 'Hindi');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'hi', 'language', 'de', 'Hindi');
+
 -- Hungarian
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' );
@@ -294,6 +339,9 @@ VALUES( 'hu', 'language', 'en', 'Hungarian');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'hu', 'language', 'fr', 'Hongrois');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'hu', 'language', 'de', 'Ungarisch');
+
 -- Indonesian
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'id', 'language', 'Indonesian','2005-10-16' );
@@ -310,6 +358,9 @@ VALUES( 'id', 'language', 'en', 'Indonesian');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'id', 'language', 'fr', 'Indonésien');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'id', 'language', 'de', 'Indonesisch');
+
 -- Italian
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'it', 'language', 'Italian','2005-10-16' );
@@ -326,6 +377,9 @@ VALUES( 'it', 'language', 'en', 'Italian');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'it', 'language', 'fr', 'Italien');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'it', 'language', 'de', 'Italienisch');
+
 -- Japanese
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'ja', 'language', 'Japanese','2005-10-16');
@@ -342,6 +396,9 @@ VALUES( 'ja', 'language', 'en', 'Japanese');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'ja', 'language', 'fr', 'Japonais');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'ja', 'language', 'de', 'Japanisch');
+
 -- Korean
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'ko', 'language', 'Korean','2005-10-16');
@@ -358,6 +415,9 @@ VALUES( 'ko', 'language', 'en', 'Korean');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'ko', 'language', 'fr', 'Coréen');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'ko', 'language', 'de', 'Koreanisch');
+
 -- Latin
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'la', 'language', 'Latin','2005-10-16' );
@@ -374,6 +434,9 @@ VALUES( 'la', 'language', 'en', 'Latin');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'la', 'language', 'fr', 'Latin');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'la', 'language', 'de', 'Latein');
+
 -- Galician
 
 INSERT INTO language_subtag_registry( subtag, type, description, added)
@@ -388,6 +451,9 @@ VALUES( 'gl', 'language', 'gl', 'Galego');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'gl', 'language', 'en', 'Galician');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'gl', 'language', 'fr', 'Galicien');
+
 -- Norwegian (bokmål)
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' );
@@ -407,6 +473,9 @@ VALUES( 'nb', 'language', 'en', 'Norwegian bokmål');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'nb', 'language', 'de', 'Norwegisch bokmål');
+
 -- Norwegian (nynorsk)
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' );
@@ -426,6 +495,9 @@ VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'nn', 'language', 'de', 'Norwegisch nynorsk');
+
 -- Persian
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'fa', 'language', 'Persian','2005-10-16');
@@ -442,6 +514,9 @@ VALUES( 'fa', 'language', 'en', 'Persian');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'fa', 'language', 'fr', 'Persan');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'fa', 'language', 'de', 'Persisch');
+
 -- Polish
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'pl', 'language', 'Polish','2005-10-16' );
@@ -458,6 +533,9 @@ VALUES( 'pl', 'language', 'en', 'Polish');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'pl', 'language', 'fr', 'Polonais');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'pl', 'language', 'de', 'Polnisch');
+
 -- Portuguese
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
@@ -474,6 +552,9 @@ VALUES( 'pt', 'language', 'en', 'Portuguese');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'pt', 'language', 'fr', 'Portugais');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'pt', 'language', 'de', 'Portugiesisch');
+
 -- Romanian
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
@@ -490,6 +571,9 @@ VALUES( 'ro', 'language', 'en', 'Romanian');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'ro', 'language', 'fr', 'Roumain');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'ro', 'language', 'de', 'Rumänisch');
+
 -- Russian
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'ru', 'language', 'Russian','2005-10-16');
@@ -506,6 +590,9 @@ VALUES( 'ru', 'language', 'en', 'Russian');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'ru', 'language', 'fr', 'Russe');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'ru', 'language', 'de', 'Russisch');
+
 -- Serbian
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'sr', 'language', 'Serbian','2005-10-16' );
@@ -519,6 +606,12 @@ VALUES( 'sr', 'language', 'sr', 'српски');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'sr', 'language', 'en', 'Serbian');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'sr', 'language', 'fr', 'Serbe');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'sr', 'language', 'de', 'Serbisch');
+
 -- Spanish, Castilian
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'es', 'language', 'Spanish','2005-10-16' );
@@ -535,6 +628,28 @@ VALUES( 'es', 'language', 'en', 'Spanish');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'es', 'language', 'fr', 'Espagnol');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'es', 'language', 'de', 'Spanisch');
+
+-- 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à');
+
 -- Swedish
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
@@ -551,6 +666,9 @@ VALUES( 'sv', 'language', 'en', 'Swedish');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'sv', 'language', 'fr', 'Suédois');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'sv', 'language', 'de', 'Schwedisch');
+
 -- Tetum
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'tet', 'language', 'Tetum','2005-10-16' );
@@ -564,6 +682,12 @@ VALUES( 'tet', 'language', 'tet', 'tetun');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'tet', 'language', 'en', 'Tetum');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'tet', 'language', 'fr', 'Tétoum');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'tet', 'language', 'de', 'Tetum');
+
 -- Thai
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'th', 'language', 'Thai','2005-10-16');
@@ -580,6 +704,9 @@ VALUES( 'th', 'language', 'en', 'Thai');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'th', 'language', 'fr', 'Thaï');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'th', 'language', 'de', 'Thailändisch');
+
 -- Turkish
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'tr', 'language', 'Turkish','2005-10-16' );
@@ -596,6 +723,8 @@ VALUES( 'tr', 'language', 'en', 'Turkish');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'tr', 'language', 'fr', 'Turc');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'tr', 'language', 'de', 'Türkisch');
 
 -- Ukranian
 INSERT INTO language_subtag_registry( subtag, type, description, added)
@@ -613,6 +742,9 @@ VALUES( 'uk', 'language', 'en', 'Ukranian');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'uk', 'language', 'fr', 'Ukrainien');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'uk', 'language', 'de', 'Ukrainisch');
+
 -- Urdu
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'ur', 'language', 'Urdu','2005-10-16' );
@@ -626,6 +758,12 @@ VALUES( 'ur', 'language', 'en', 'Urdu');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'ur', 'language', 'ur', 'اردو');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'ur', 'language', 'fr', 'Ourdou');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'ur', 'language', 'de', 'Urdu');
+
 -- SCRIPTS
 -- Arabic
 INSERT INTO language_subtag_registry( subtag, type, description, added)