Bug 14285: Bengali locale needs to be re-defined

This patch renames translation files for Bengali
language, from ben-* to bn-IN-*.
Also adds India as region

To test:
1) Apply the patch
2) Run updatedatabase
3) Install Bengali language
cd misc/translator
perl translate install bn-IN
enable

Check correct description

4) Create and install a fake Bengali variant
cd misc/translator
perl translate create bn-XX
perl translate install bn-XX
enable both variants

Check correct rendering of region

Results comply with expected test plan outcome. Signed off for bn-IN
Signed-off-by: Indranil Das Gupta (L2C2 Technologies) <indradg@gmail.com>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Tomas Cohen Arazi <tomascohen@gmail.com>

diff --git a/installer/data/mysql/atomicupdate/bug-14285.sql b/installer/data/mysql/atomicupdate/bug-14285.sql
new file mode 100644 (file)
index 0000000..9c71a9e
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug-14285.sql
@@ -0,0 +1,29 @@
+INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added)
+VALUES ( 'IN', 'region', 'India','2015-05-28');
+
+INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
+VALUES ( 'IN', 'region', 'en', 'India');
+
+INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
+VALUES ( 'IN', 'region', 'bn', 'ভারত');
+
+-- $DBversion = "3.21.00.XXX";
+-- if ( CheckVersion($DBversion) ) {
+--     $dbh->do(q|
+--         INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added)
+--         VALUES ( 'IN', 'region', 'India','2015-05-28');
+--     |);
+--
+--     $dbh->do(q|
+--         INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
+--         VALUES ( 'IN', 'region', 'en', 'India');
+--     |);
+--
+--     $dbh->do(q|
+--         INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
+--         VALUES ( 'IN', 'region', 'bn', 'ভারত');
+--     |);
+--
+--     print "Upgrade to $DBversion done (Bug 14285: Add new region India)\n";
+--     SetVersion ($DBversion);
+-- }

diff --git a/installer/data/mysql/mandatory/subtag_registry.sql b/installer/data/mysql/mandatory/subtag_registry.sql
index aee0e9b..5dc2af2 100755 (executable)
--- a/installer/data/mysql/mandatory/subtag_registry.sql
+++ b/installer/data/mysql/mandatory/subtag_registry.sql
@@ -1515,6 +1515,16 @@ VALUES ( 'ID', 'region', 'en', 'Indonesia');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES ( 'ID', 'region', 'id', 'Indonesia');
 
+-- India
+INSERT INTO language_subtag_registry( subtag, type, description, added)
+VALUES ( 'IN', 'region', 'India','2015-05-28');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES ( 'IN', 'region', 'en', 'India');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES ( 'IN', 'region', 'bn', 'ভারত');
+
 -- Iceland
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'IS', 'region', 'Iceland','2014-10-30');

diff --git a/misc/translator/po/ben-marc-MARC21.po b/misc/translator/po/bn-IN-marc-MARC21.po
similarity index 100%
rename from misc/translator/po/ben-marc-MARC21.po
rename to misc/translator/po/bn-IN-marc-MARC21.po

diff --git a/misc/translator/po/ben-marc-NORMARC.po b/misc/translator/po/bn-IN-marc-NORMARC.po
similarity index 100%
rename from misc/translator/po/ben-marc-NORMARC.po
rename to misc/translator/po/bn-IN-marc-NORMARC.po

diff --git a/misc/translator/po/ben-marc-UNIMARC.po b/misc/translator/po/bn-IN-marc-UNIMARC.po
similarity index 100%
rename from misc/translator/po/ben-marc-UNIMARC.po
rename to misc/translator/po/bn-IN-marc-UNIMARC.po

diff --git a/misc/translator/po/ben-opac-bootstrap.po b/misc/translator/po/bn-IN-opac-bootstrap.po
similarity index 100%
rename from misc/translator/po/ben-opac-bootstrap.po
rename to misc/translator/po/bn-IN-opac-bootstrap.po

diff --git a/misc/translator/po/ben-pref.po b/misc/translator/po/bn-IN-pref.po
similarity index 100%
rename from misc/translator/po/ben-pref.po
rename to misc/translator/po/bn-IN-pref.po

diff --git a/misc/translator/po/ben-staff-help.po b/misc/translator/po/bn-IN-staff-help.po
similarity index 100%
rename from misc/translator/po/ben-staff-help.po
rename to misc/translator/po/bn-IN-staff-help.po

diff --git a/misc/translator/po/ben-staff-prog.po b/misc/translator/po/bn-IN-staff-prog.po
similarity index 100%
rename from misc/translator/po/ben-staff-prog.po
rename to misc/translator/po/bn-IN-staff-prog.po