From e6138728fe13f02b4f297d5ffd4fe97bc3416a98 Mon Sep 17 00:00:00 2001
From: Tomas Cohen Arazi <tomascohen@theke.io>
Date: Mon, 29 Nov 2021 18:35:46 -0300
Subject: [PATCH] Bug 29596: Add Yiddish language
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

This patch adds the Yiddish language to Koha. The language codes were
taken from https://www.loc.gov/standards/iso639-2/php/code_list.php

Sponsored-by: Universidad Nacional de San Martín

Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
Signed-off-by: David Nind <david@davidnind.com>
---
 .../data/mysql/atomicupdate/bug_29596.pl      | 51 +++++++++++++++++++
 .../data/mysql/mandatory/subtag_registry.sql  | 26 ++++++++++
 2 files changed, 77 insertions(+)
 create mode 100755 installer/data/mysql/atomicupdate/bug_29596.pl

diff --git a/installer/data/mysql/atomicupdate/bug_29596.pl b/installer/data/mysql/atomicupdate/bug_29596.pl
new file mode 100755
index 0000000000..95b032b95a
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_29596.pl
@@ -0,0 +1,51 @@
+use Modern::Perl;
+
+return {
+    bug_number  => "29596",
+    description => "Add Yiddish language",
+    up => sub {
+        my ($args) = @_;
+        my ($dbh, $out) = @$args{qw(dbh out)};
+
+
+        $dbh->do(q{
+            INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added)
+            VALUES ( 'yi', 'language', 'Yiddish', NOW() );
+        });
+
+        $dbh->do(q{
+            INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
+            VALUES ( 'yi','yid');
+        });
+
+        $dbh->do(q{
+            INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
+            VALUES ( 'yi', 'language', 'de', 'Jiddisch');
+        });
+
+        $dbh->do(q{
+            INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
+            VALUES ( 'yi', 'language', 'en', 'Yiddish');
+        });
+
+        $dbh->do(q{
+            INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
+            VALUES ( 'yi', 'language', 'es', 'Yidis');
+        });
+
+        $dbh->do(q{
+            INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
+            VALUES ( 'yi', 'language', 'fr', 'Yiddish');
+        });
+
+        $dbh->do(q{
+            INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
+            VALUES ( 'yi', 'language', 'yi', 'יידיש');
+        });
+
+        $dbh->do(q{
+            INSERT IGNORE INTO language_script_mapping(language_subtag,script_subtag)
+            VALUES ( 'yi', 'Hebr');
+        });
+    },
+}
diff --git a/installer/data/mysql/mandatory/subtag_registry.sql b/installer/data/mysql/mandatory/subtag_registry.sql
index 08761d9256..25ad884d10 100644
--- a/installer/data/mysql/mandatory/subtag_registry.sql
+++ b/installer/data/mysql/mandatory/subtag_registry.sql
@@ -1874,3 +1874,29 @@ VALUES ('ik', 'language', 'Inupiaq', now());
 
 INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
 VALUES ('ik', 'ipk');
+
+-- Yiddish
+
+INSERT INTO language_subtag_registry( subtag, type, description, added)
+VALUES ( 'yi', 'language', 'Yiddish', NOW() );
+
+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
+VALUES ( 'yi','yid');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES ( 'yi', 'language', 'de', 'Jiddisch');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES ( 'yi', 'language', 'en', 'Yiddish');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES ( 'yi', 'language', 'es', 'Yidis');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES ( 'yi', 'language', 'fr', 'Yiddish');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES ( 'yi', 'language', 'yi', 'יידיש');
+
+INSERT INTO language_script_mapping(language_subtag,script_subtag)
+VALUES ( 'yi', 'Hebr');
-- 
2.32.0