summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2022-11-11 16:17:29 +0100
committerYorhel <git@yorhel.nl>2022-11-11 16:17:43 +0100
commit33c83c7d94857df03b4872388b570cf3a04dad7c (patch)
tree555214f9ce1280495a60f97dfad453e90efbf569
parentf6635383ace7d846eb99ed5cbc6c8291ff9f0640 (diff)
Add Serbian language
-rw-r--r--data/icons/lang/sr.pngbin0 -> 262 bytes
-rw-r--r--lib/VNDB/Types.pm1
-rw-r--r--sql/schema.sql2
-rw-r--r--util/updates/2022-11-11-serbian-language.sql1
4 files changed, 3 insertions, 1 deletions
diff --git a/data/icons/lang/sr.png b/data/icons/lang/sr.png
new file mode 100644
index 00000000..1d44d8f7
--- /dev/null
+++ b/data/icons/lang/sr.png
Binary files differ
diff --git a/lib/VNDB/Types.pm b/lib/VNDB/Types.pm
index fd129992..f1df90ea 100644
--- a/lib/VNDB/Types.pm
+++ b/lib/VNDB/Types.pm
@@ -55,6 +55,7 @@ hash LANGUAGE =>
ru => 'Russian',
sk => 'Slovak',
sl => 'Slovene',
+ sr => 'Serbian',
sv => 'Swedish',
ta => 'Tagalog',
th => 'Thai',
diff --git a/sql/schema.sql b/sql/schema.sql
index 8d5010ee..8cbcc815 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', 'eu', 'fa', 'fi', 'fr', 'ga', 'gd', 'he', 'hi', 'hr', 'hu', 'id', 'it', 'iu', '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', 'zh-Hans', 'zh-Hant');
+CREATE TYPE language AS ENUM ('ar', 'bg', 'ca', 'cs', 'da', 'de', 'el', 'en', 'eo', 'es', 'eu', 'fa', 'fi', 'fr', 'ga', 'gd', 'he', 'hi', 'hr', 'hu', 'id', 'it', 'iu', 'ja', 'ko', 'mk', 'ms', 'la', 'lt', 'lv', 'nl', 'no', 'pl', 'pt-pt', 'pt-br', 'ro', 'ru', 'sk', 'sl', 'sr', 'sv', 'ta', 'th', 'tr', 'uk', 'ur', 'vi', 'zh', 'zh-Hans', 'zh-Hant');
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/2022-11-11-serbian-language.sql b/util/updates/2022-11-11-serbian-language.sql
new file mode 100644
index 00000000..48cda88e
--- /dev/null
+++ b/util/updates/2022-11-11-serbian-language.sql
@@ -0,0 +1 @@
+ALTER TYPE language ADD VALUE 'sr' AFTER 'sl';