From 88a01b5b9a7ab4b02d82aa2b174f0255c2a317e4 Mon Sep 17 00:00:00 2001 From: Dobrica Pavlinusic Date: Thu, 24 Jul 2014 14:28:31 +0200 Subject: [PATCH] Bug 12649 - Add Croatian language --- .../data/mysql/de-DE/mandatory/subtag_registry.sql | 19 +++++++++++++++++++ .../data/mysql/en/mandatory/subtag_registry.sql | 19 +++++++++++++++++++ .../data/mysql/es-ES/mandatory/subtag_registry.sql | 20 ++++++++++++++++++++ .../data/mysql/pl-PL/mandatory/subtag_registry.sql | 20 ++++++++++++++++++++ .../data/mysql/ru-RU/mandatory/subtag_registry.sql | 20 ++++++++++++++++++++ .../data/mysql/uk-UA/mandatory/subtag_registry.sql | 20 ++++++++++++++++++++ installer/data/mysql/updatedatabase.pl | 14 +++++++++++++- 7 files changed, 131 insertions(+), 1 deletions(-) diff --git a/installer/data/mysql/de-DE/mandatory/subtag_registry.sql b/installer/data/mysql/de-DE/mandatory/subtag_registry.sql index ceaae46..1e642c0 100755 --- a/installer/data/mysql/de-DE/mandatory/subtag_registry.sql +++ b/installer/data/mysql/de-DE/mandatory/subtag_registry.sql @@ -887,6 +887,25 @@ VALUES( 'Laoo', 'script', 'en', 'Lao'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'Laoo', 'script', 'de', 'Laotisch'); +-- Croatian +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'hr', 'language', 'Croatian','2014-07-24' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'hr','hrv'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'hr', 'Hrvatski'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'en', 'Croatian'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'fr', 'Croate'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'de', 'Kroatisch'); + -- REGIONS -- Canada diff --git a/installer/data/mysql/en/mandatory/subtag_registry.sql b/installer/data/mysql/en/mandatory/subtag_registry.sql index ceaae46..1e642c0 100755 --- a/installer/data/mysql/en/mandatory/subtag_registry.sql +++ b/installer/data/mysql/en/mandatory/subtag_registry.sql @@ -887,6 +887,25 @@ VALUES( 'Laoo', 'script', 'en', 'Lao'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'Laoo', 'script', 'de', 'Laotisch'); +-- Croatian +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'hr', 'language', 'Croatian','2014-07-24' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'hr','hrv'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'hr', 'Hrvatski'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'en', 'Croatian'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'fr', 'Croate'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'de', 'Kroatisch'); + -- REGIONS -- Canada diff --git a/installer/data/mysql/es-ES/mandatory/subtag_registry.sql b/installer/data/mysql/es-ES/mandatory/subtag_registry.sql index 49ad7ab..62b97ab 100644 --- a/installer/data/mysql/es-ES/mandatory/subtag_registry.sql +++ b/installer/data/mysql/es-ES/mandatory/subtag_registry.sql @@ -731,6 +731,26 @@ VALUES ( 'Laoo', 'script', 'lo', 'Lao'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'Laoo', 'script', 'en', 'Lao'); +-- Croatian +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'hr', 'language', 'Croatian','2014-07-24' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'hr','hrv'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'hr', 'Hrvatski'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'en', 'Croatian'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'fr', 'Croate'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'de', 'Kroatisch'); + + -- REGIONS -- Canada INSERT INTO language_subtag_registry( subtag, type, description, added) diff --git a/installer/data/mysql/pl-PL/mandatory/subtag_registry.sql b/installer/data/mysql/pl-PL/mandatory/subtag_registry.sql index 09561a9..d62b007 100644 --- a/installer/data/mysql/pl-PL/mandatory/subtag_registry.sql +++ b/installer/data/mysql/pl-PL/mandatory/subtag_registry.sql @@ -719,6 +719,26 @@ VALUES ( 'Laoo', 'script', 'lo', 'Lao'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'Laoo', 'script', 'en', 'Lao'); +-- Croatian +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'hr', 'language', 'Croatian','2014-07-24' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'hr','hrv'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'hr', 'Hrvatski'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'en', 'Croatian'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'fr', 'Croate'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'de', 'Kroatisch'); + + -- REGIONS -- Canada INSERT INTO language_subtag_registry( subtag, type, description, added) diff --git a/installer/data/mysql/ru-RU/mandatory/subtag_registry.sql b/installer/data/mysql/ru-RU/mandatory/subtag_registry.sql index 3403d0f..5e3b60f 100644 --- a/installer/data/mysql/ru-RU/mandatory/subtag_registry.sql +++ b/installer/data/mysql/ru-RU/mandatory/subtag_registry.sql @@ -719,6 +719,26 @@ VALUES ( 'Laoo', 'script', 'lo', 'Lao'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'Laoo', 'script', 'en', 'Lao'); +-- Croatian +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'hr', 'language', 'Croatian','2014-07-24' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'hr','hrv'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'hr', 'Hrvatski'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'en', 'Croatian'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'fr', 'Croate'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'de', 'Kroatisch'); + + -- REGIONS -- Canada INSERT INTO language_subtag_registry( subtag, type, description, added) diff --git a/installer/data/mysql/uk-UA/mandatory/subtag_registry.sql b/installer/data/mysql/uk-UA/mandatory/subtag_registry.sql index 3403d0f..5e3b60f 100644 --- a/installer/data/mysql/uk-UA/mandatory/subtag_registry.sql +++ b/installer/data/mysql/uk-UA/mandatory/subtag_registry.sql @@ -719,6 +719,26 @@ VALUES ( 'Laoo', 'script', 'lo', 'Lao'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'Laoo', 'script', 'en', 'Lao'); +-- Croatian +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'hr', 'language', 'Croatian','2014-07-24' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'hr','hrv'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'hr', 'Hrvatski'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'en', 'Croatian'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'fr', 'Croate'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hr', 'language', 'de', 'Kroatisch'); + + -- REGIONS -- Canada INSERT INTO language_subtag_registry( subtag, type, description, added) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 94bb4ff..ccd0031 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -8548,7 +8548,7 @@ $DBversion = "3.17.00.007"; if (CheckVersion($DBversion)) { $dbh->do("INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES('UpdateNotForLoanStatusOnCheckin', '', 'NULL', 'This is a list of value pairs. When an item is checked in, if the not for loan value on the left matches the items not for loan value it will be updated to the right-hand value. E.g. ''-1: 0'' will cause an item that was set to ''Ordered'' to now be available for loan. Each pair of values should be on a separate line.', 'Free');"); print "Upgrade to $DBversion done (Bug 11629 - Add ability to update not for loan status on checkin)\n"; - SetVersion($DBversion); + SetVersion($DBversion; } $DBversion = "3.17.00.008"; @@ -8577,6 +8577,18 @@ if ( CheckVersion($DBversion) ) { SetVersion ($DBversion); } +$DBversion = "3.17.00.XXX"; +if ( CheckVersion($DBversion) ) { + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'hr', 'language', 'Croatian','2014-07-24' )"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES( 'hr','hrv')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'hr', 'language', 'hr', 'Hrvatski')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'hr', 'language', 'en', 'Croatian')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'hr', 'language', 'fr', 'Croate')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'hr', 'language', 'de', 'Kroatisch')"); + print "Upgrade to $DBversion done (Bug 12649: Add Croatian laguage)\n"; + SetVersion ($DBversion); +} + =head1 FUNCTIONS =head2 TableExists($table) -- 1.7.2.5