Add Hindu & Urdu languages

5 files changed, 5 insertions, 1 deletions

diff --git a/data/icons/lang/hi.png b/data/icons/lang/hi.png
new file mode 100644
index 00000000..3ee25fad
--- /dev/null
+++ b/data/icons/lang/hi.png
diff --git a/data/icons/lang/ur.png b/data/icons/lang/ur.png
new file mode 100644
index 00000000..1ff90dbb
--- /dev/null
+++ b/data/icons/lang/ur.png
diff --git a/lib/VNDB/Types.pm b/lib/VNDB/Types.pm
index 274c84d8..b73d1891 100644
--- a/lib/VNDB/Types.pm
+++ b/lib/VNDB/Types.pm
@@ -32,6 +32,7 @@ hash LANGUAGE =>
     ga => 'Irish',
     gd => 'Scottish Gaelic',
     he => 'Hebrew',
+    hi => 'Hindu',
     hr => 'Croatian',
     hu => 'Hungarian',
     id => 'Indonesian',
@@ -57,6 +58,7 @@ hash LANGUAGE =>
     th => 'Thai',
     tr => 'Turkish',
     uk => 'Ukrainian',
+    ur => 'Urdu',
     vi => 'Vietnamese',
     zh => 'Chinese';
 
diff --git a/sql/schema.sql b/sql/schema.sql
index 2e0b0b3f..d47a6b76 100644
--- a/sql/schema.sql
+++ b/sql/schema.sql
@@ -61,7 +61,7 @@ CREATE TYPE credit_type       AS ENUM ('scenario', 'chardesign', 'art', 'music',
 CREATE TYPE cup_size          AS ENUM ('', 'AAA', 'AA', 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z');
 CREATE TYPE dbentry_type      AS ENUM ('v', 'r', 'p', 'c', 's', 'd');
 CREATE TYPE gender            AS ENUM ('unknown', 'm', 'f', 'b');
-CREATE TYPE language          AS ENUM ('ar', 'bg', 'ca', 'cs', 'da', 'de', 'el', 'en', 'eo', 'es', 'fa', 'fi', 'fr', 'ga', 'gd', 'he', 'hr', 'hu', 'id', 'it', 'ja', 'ko', 'mk', 'ms', 'la', 'lt', 'lv', 'nl', 'no', 'pl', 'pt-pt', 'pt-br', 'ro', 'ru', 'sk', 'sl', 'sv', 'ta', 'th', 'tr', 'uk', 'vi', 'zh');
+CREATE TYPE language          AS ENUM ('ar', 'bg', 'ca', 'cs', 'da', 'de', 'el', 'en', 'eo', 'es', 'fa', 'fi', 'fr', 'ga', 'gd', 'he', 'hi', 'hr', 'hu', 'id', 'it', 'ja', 'ko', 'mk', 'ms', 'la', 'lt', 'lv', 'nl', 'no', 'pl', 'pt-pt', 'pt-br', 'ro', 'ru', 'sk', 'sl', 'sv', 'ta', 'th', 'tr', 'uk', 'ur', 'vi', 'zh');
 CREATE TYPE medium            AS ENUM ('cd', 'dvd', 'gdr', 'blr', 'flp', 'cas', 'mrt', 'mem', 'umd', 'nod', 'in', 'otc');
 CREATE TYPE notification_ntype AS ENUM ('pm', 'dbdel', 'listdel', 'dbedit', 'announce', 'post', 'comment', 'subpost', 'subedit', 'subreview', 'subapply');
 CREATE TYPE platform          AS ENUM ('win', 'dos', 'lin', 'mac', 'ios', 'and', 'dvd', 'bdp', 'fm7', 'fm8', 'fmt', 'gba', 'gbc', 'msx', 'nds', 'nes', 'p88', 'p98', 'pce', 'pcf', 'psp', 'ps1', 'ps2', 'ps3', 'ps4', 'ps5', 'psv', 'drc', 'smd', 'scd', 'sat', 'sfc', 'swi', 'wii', 'wiu', 'n3d', 'vnd', 'x1s', 'x68', 'xb1', 'xb3', 'xbo', 'xxs', 'web', 'tdo', 'mob', 'oth');
diff --git a/util/updates/2021-06-22-indi-urdu-languages.sql b/util/updates/2021-06-22-indi-urdu-languages.sql
new file mode 100644
index 00000000..9de77172
--- /dev/null
+++ b/util/updates/2021-06-22-indi-urdu-languages.sql
@@ -0,0 +1,2 @@
+ALTER TYPE language ADD VALUE 'hi' AFTER 'he';
+ALTER TYPE language ADD VALUE 'ur' AFTER 'uk';