From 808fb2679bb4c3574589486546d61e0d392c8368 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=utf8
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>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
---
 .../data/mysql/atomicupdate/bug_29596.pl      | 51 +++++++++++++++++++
 1 file changed, 51 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');
+        });
+    },
+}
-- 
2.39.5