From aa27b54fa3245a4f4763502db0007a3eeb47ec47 Mon Sep 17 00:00:00 2001
From: Yorhel <git@yorhel.nl>
Date: Mon, 23 Sep 2019 14:54:12 +0200
Subject: Add 4 new languages

https://vndb.org/t12897.6
---
 data/icons/lang/lt.png           | Bin 0 -> 100 bytes
 data/icons/lang/lv.png           | Bin 0 -> 88 bytes
 data/icons/lang/mk.png           | Bin 0 -> 313 bytes
 data/icons/lang/sl.png           | Bin 0 -> 169 bytes
 lib/VNDB/Types.pm                |   4 ++++
 util/sql/schema.sql              |   2 +-
 util/updates/update_20190923.sql |   4 ++++
 7 files changed, 9 insertions(+), 1 deletion(-)
 create mode 100644 data/icons/lang/lt.png
 create mode 100644 data/icons/lang/lv.png
 create mode 100644 data/icons/lang/mk.png
 create mode 100644 data/icons/lang/sl.png
 create mode 100644 util/updates/update_20190923.sql

diff --git a/data/icons/lang/lt.png b/data/icons/lang/lt.png
new file mode 100644
index 00000000..eb50db98
Binary files /dev/null and b/data/icons/lang/lt.png differ
diff --git a/data/icons/lang/lv.png b/data/icons/lang/lv.png
new file mode 100644
index 00000000..e5d45b33
Binary files /dev/null and b/data/icons/lang/lv.png differ
diff --git a/data/icons/lang/mk.png b/data/icons/lang/mk.png
new file mode 100644
index 00000000..e3fd792d
Binary files /dev/null and b/data/icons/lang/mk.png differ
diff --git a/data/icons/lang/sl.png b/data/icons/lang/sl.png
new file mode 100644
index 00000000..0f096cee
Binary files /dev/null and b/data/icons/lang/sl.png differ
diff --git a/lib/VNDB/Types.pm b/lib/VNDB/Types.pm
index 77271c6f..ea57c79a 100644
--- a/lib/VNDB/Types.pm
+++ b/lib/VNDB/Types.pm
@@ -35,6 +35,9 @@ hash LANGUAGE =>
     it => 'Italian',
     ja => 'Japanese',
     ko => 'Korean',
+    mk => 'Macedonian',
+    lt => 'Lithuanian',
+    lv => 'Latvian',
     nl => 'Dutch',
     no => 'Norwegian',
     pl => 'Polish',
@@ -43,6 +46,7 @@ hash LANGUAGE =>
     ro => 'Romanian',
     ru => 'Russian',
     sk => 'Slovak',
+    sl => 'Slovene',
     sv => 'Swedish',
     ta => 'Tagalog',
     th => 'Thai',
diff --git a/util/sql/schema.sql b/util/sql/schema.sql
index 1450196a..fc2e56ae 100644
--- a/util/sql/schema.sql
+++ b/util/sql/schema.sql
@@ -54,7 +54,7 @@ CREATE TYPE credit_type       AS ENUM ('scenario', 'chardesign', 'art', 'music',
 CREATE TYPE dbentry_type      AS ENUM ('v', 'r', 'p', 'c', 's', 'd');
 CREATE TYPE edit_rettype      AS (itemid integer, chid integer, rev integer);
 CREATE TYPE gender            AS ENUM ('unknown', 'm', 'f', 'b');
-CREATE TYPE language          AS ENUM ('ar', 'bg', 'ca', 'cs', 'da', 'de', 'el', 'en', 'eo', 'es', 'fi', 'fr', 'he', 'hr', 'hu', 'id', 'it', 'ja', 'ko', 'nl', 'no', 'pl', 'pt-pt', 'pt-br', 'ro', 'ru', 'sk', 'sv', 'ta', 'th', 'tr', 'uk', 'vi', 'zh');
+CREATE TYPE language          AS ENUM ('ar', 'bg', 'ca', 'cs', 'da', 'de', 'el', 'en', 'eo', 'es', 'fi', 'fr', 'he', 'hr', 'hu', 'id', 'it', 'ja', 'ko', 'mk', 'lt', 'lv', 'nl', 'no', 'pl', 'pt-pt', 'pt-br', 'ro', 'ru', 'sk', 'sl', 'sv', 'ta', 'th', 'tr', 'uk', 'vi', 'zh');
 CREATE TYPE medium            AS ENUM ('cd', 'dvd', 'gdr', 'blr', 'flp', 'mrt', 'mem', 'umd', 'nod', 'in', 'otc');
 CREATE TYPE notification_ntype AS ENUM ('pm', 'dbdel', 'listdel', 'dbedit', 'announce');
 CREATE TYPE notification_ltype AS ENUM ('v', 'r', 'p', 'c', 't', 's', 'd');
diff --git a/util/updates/update_20190923.sql b/util/updates/update_20190923.sql
new file mode 100644
index 00000000..3404519e
--- /dev/null
+++ b/util/updates/update_20190923.sql
@@ -0,0 +1,4 @@
+ALTER TYPE language ADD VALUE 'mk' AFTER 'ko';
+ALTER TYPE language ADD VALUE 'lt' AFTER 'mk';
+ALTER TYPE language ADD VALUE 'lv' AFTER 'lt';
+ALTER TYPE language ADD VALUE 'sl' AFTER 'sk';
-- 
cgit v1.2.3