summaryrefslogtreecommitdiff
path: root/util
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 /util
parent20516593d730bebc46634ee748213151d6e10913 (diff)
Add 4 new languages
https://vndb.org/t12897.6
Diffstat (limited to 'util')
-rw-r--r--util/sql/schema.sql2
-rw-r--r--util/updates/update_20190923.sql4
2 files changed, 5 insertions, 1 deletions
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';