summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2019-09-23 14:54:12 +0200
committerYorhel <git@yorhel.nl>2019-09-23 14:54:13 +0200
commitaa27b54fa3245a4f4763502db0007a3eeb47ec47 (patch)
tree88d6cb242481ae89801998b430c9ed05b87c3bda
parent20516593d730bebc46634ee748213151d6e10913 (diff)
Add 4 new languages
https://vndb.org/t12897.6
-rw-r--r--data/icons/lang/lt.pngbin0 -> 100 bytes
-rw-r--r--data/icons/lang/lv.pngbin0 -> 88 bytes
-rw-r--r--data/icons/lang/mk.pngbin0 -> 313 bytes
-rw-r--r--data/icons/lang/sl.pngbin0 -> 169 bytes
-rw-r--r--lib/VNDB/Types.pm4
-rw-r--r--util/sql/schema.sql2
-rw-r--r--util/updates/update_20190923.sql4
7 files changed, 9 insertions, 1 deletions
diff --git a/data/icons/lang/lt.png b/data/icons/lang/lt.png
new file mode 100644
index 00000000..eb50db98
--- /dev/null
+++ b/data/icons/lang/lt.png
Binary files differ
diff --git a/data/icons/lang/lv.png b/data/icons/lang/lv.png
new file mode 100644
index 00000000..e5d45b33
--- /dev/null
+++ b/data/icons/lang/lv.png
Binary files differ
diff --git a/data/icons/lang/mk.png b/data/icons/lang/mk.png
new file mode 100644
index 00000000..e3fd792d
--- /dev/null
+++ b/data/icons/lang/mk.png
Binary files differ
diff --git a/data/icons/lang/sl.png b/data/icons/lang/sl.png
new file mode 100644
index 00000000..0f096cee
--- /dev/null
+++ b/data/icons/lang/sl.png
Binary files 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';