From 26854910bb2fb50daa74a46fa32004dba564f04e Mon Sep 17 00:00:00 2001
From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Date: Thu, 20 Jul 2023 16:31:40 +0100
Subject: [PATCH] Bug 34328: Add Scottish Gaelic to languages

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
(cherry picked from commit 44aa68c3dfa2b067b317cdb1c6578e517e115d46)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
---
 .../data/mysql/atomicupdate/bug_34328.pl      | 46 +++++++++++++++++++
 .../data/mysql/mandatory/subtag_registry.sql  | 23 ++++++++++
 2 files changed, 69 insertions(+)
 create mode 100755 installer/data/mysql/atomicupdate/bug_34328.pl

diff --git a/installer/data/mysql/atomicupdate/bug_34328.pl b/installer/data/mysql/atomicupdate/bug_34328.pl
new file mode 100755
index 0000000000..50794c67d1
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_34328.pl
@@ -0,0 +1,46 @@
+use Modern::Perl;
+
+return {
+    bug_number  => "34328",
+    description => "Add Scottish Gaelic to recognised languages",
+    up          => sub {
+        my ($args) = @_;
+        my ( $dbh, $out ) = @$args{qw(dbh out)};
+        $dbh->do(q{
+            INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
+            VALUES ( 'gd','gla' )
+        });
+
+        $dbh->do(q{
+            INSERT INTO language_subtag_registry( subtag, type, description, added)
+            VALUES ( 'gd', 'language', 'Scottish Gaelic', NOW() )
+        });
+
+        $dbh->do(q{
+            INSERT INTO language_descriptions(subtag, type, lang, description)
+            VALUES ( 'gd', 'language', 'en', 'Scottish Gaelic')
+        });
+
+        $dbh->do(q{
+            INSERT INTO language_descriptions(subtag, type, lang, description)
+            VALUES ( 'gd', 'language', 'gd', 'Gàidhlig')
+        });
+
+        $dbh->do(q{
+            INSERT INTO language_descriptions(subtag, type, lang, description)
+            VALUES ( 'gd', 'language', 'fr', 'Gaélique écossais')
+        });
+
+        $dbh->do(q{
+            INSERT INTO language_descriptions(subtag, type, lang, description)
+            VALUES ( 'gd', 'language', 'de', 'Schottisch-Gälisch')
+        });
+
+        $dbh->do(q{
+            INSERT INTO language_descriptions(subtag, type, lang, description)
+            VALUES ( 'gd', 'language', 'pl', 'Język szkocki gaelicki')
+        });
+
+        say $out "Added new language 'Scottish Gaelic'";
+    },
+};
diff --git a/installer/data/mysql/mandatory/subtag_registry.sql b/installer/data/mysql/mandatory/subtag_registry.sql
index f0e2d33308..c27789b6d7 100644
--- a/installer/data/mysql/mandatory/subtag_registry.sql
+++ b/installer/data/mysql/mandatory/subtag_registry.sql
@@ -425,6 +425,29 @@ VALUES ( 'fr', 'language', 'de', 'Französisch');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES ( 'fr', 'language', 'pl', 'Francuski');
 
+-- Scottish Gaelic
+
+INSERT INTO language_subtag_registry( subtag, type, description, added)
+VALUES ( 'gd', 'language', 'Scottish Gaelic', NOW() );
+
+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
+VALUES ( 'gd','gla');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES ( 'gd', 'language', 'en', 'Scottish Gaelic');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES ( 'gd', 'language', 'gd', 'Gàidhlig');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES ( 'gd', 'language', 'fr', 'Gaélique écossais');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES ( 'gd', 'language', 'de', 'Schottisch-Gälisch');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES ( 'gd', 'language', 'pl', 'Język szkocki gaelicki');
+
 -- Galician
 INSERT INTO language_subtag_registry( subtag, type, description, added)
 VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
-- 
2.39.5