diff options
| author | Yorhel <git@yorhel.nl> | 2019-09-23 14:54:12 +0200 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2019-09-23 14:54:13 +0200 |
| commit | aa27b54fa3245a4f4763502db0007a3eeb47ec47 (patch) | |
| tree | 88d6cb242481ae89801998b430c9ed05b87c3bda /util | |
| parent | 20516593d730bebc46634ee748213151d6e10913 (diff) | |
Add 4 new languages
https://vndb.org/t12897.6
Diffstat (limited to 'util')
| -rw-r--r-- | util/sql/schema.sql | 2 | ||||
| -rw-r--r-- | util/updates/update_20190923.sql | 4 |
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'; |