summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--data/global.pl3
-rw-r--r--data/icons/lang/bg.pngbin0 -> 107 bytes
-rw-r--r--data/icons/plat/swi.pngbin0 -> 129 bytes
-rw-r--r--data/icons/plat/wiu.pngbin0 -> 116 bytes
-rw-r--r--util/sql/all.sql4
-rw-r--r--util/updates/update_2.27.sql7
6 files changed, 12 insertions, 2 deletions
diff --git a/data/global.pl b/data/global.pl
index b4805e64..187d5720 100644
--- a/data/global.pl
+++ b/data/global.pl
@@ -50,6 +50,7 @@ our %S;
default_tags_cat=> 'cont,tech',
languages => ordhash(grep !/^ *$/, split /[\s\r\n]*([^ ]+) +(.+)/, q{
ar Arabic
+ bg Bulgarian
ca Catalan
cs Czech
da Danish
@@ -171,7 +172,9 @@ our %S;
drc Dreamcast
sat Sega Saturn
sfc Super Nintendo
+ swi Nintendo Switch
wii Nintendo Wii
+ wiu Nintendo Wii U
n3d Nintendo 3DS
x68 X68000
xb1 Xbox
diff --git a/data/icons/lang/bg.png b/data/icons/lang/bg.png
new file mode 100644
index 00000000..c115806a
--- /dev/null
+++ b/data/icons/lang/bg.png
Binary files differ
diff --git a/data/icons/plat/swi.png b/data/icons/plat/swi.png
new file mode 100644
index 00000000..06f258ce
--- /dev/null
+++ b/data/icons/plat/swi.png
Binary files differ
diff --git a/data/icons/plat/wiu.png b/data/icons/plat/wiu.png
new file mode 100644
index 00000000..3d8a7b82
--- /dev/null
+++ b/data/icons/plat/wiu.png
Binary files differ
diff --git a/util/sql/all.sql b/util/sql/all.sql
index 12852221..587f7440 100644
--- a/util/sql/all.sql
+++ b/util/sql/all.sql
@@ -11,11 +11,11 @@ CREATE TYPE credit_type AS ENUM ('scenario', 'chardesign', 'art', 'music',
CREATE TYPE dbentry_type AS ENUM ('v', 'r', 'p', 'c', 's');
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', 'ca', 'cs', 'da', 'de', 'en', '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', 'en', '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 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');
-CREATE TYPE platform AS ENUM ('win', 'dos', 'lin', 'mac', 'ios', 'and', 'dvd', 'bdp', 'fmt', 'gba', 'gbc', 'msx', 'nds', 'nes', 'p88', 'p98', 'pce', 'pcf', 'psp', 'ps1', 'ps2', 'ps3', 'ps4', 'psv', 'drc', 'sat', 'sfc', 'wii', 'n3d', 'x68', 'xb1', 'xb3', 'xbo', 'web', 'oth');
+CREATE TYPE platform AS ENUM ('win', 'dos', 'lin', 'mac', 'ios', 'and', 'dvd', 'bdp', 'fmt', 'gba', 'gbc', 'msx', 'nds', 'nes', 'p88', 'p98', 'pce', 'pcf', 'psp', 'ps1', 'ps2', 'ps3', 'ps4', 'psv', 'drc', 'sat', 'sfc', 'swi', 'wii', 'wiu', 'n3d', 'x68', 'xb1', 'xb3', 'xbo', 'web', 'oth');
CREATE TYPE prefs_key AS ENUM ('l10n', 'skin', 'customcss', 'filter_vn', 'filter_release', 'show_nsfw', 'hide_list', 'notify_nodbedit', 'notify_announce', 'vn_list_own', 'vn_list_wish', 'tags_all', 'tags_cat', 'spoilers', 'traits_sexual');
CREATE TYPE producer_type AS ENUM ('co', 'in', 'ng');
CREATE TYPE producer_relation AS ENUM ('old', 'new', 'sub', 'par', 'imp', 'ipa', 'spa', 'ori');
diff --git a/util/updates/update_2.27.sql b/util/updates/update_2.27.sql
index 773b9716..35e7b4af 100644
--- a/util/updates/update_2.27.sql
+++ b/util/updates/update_2.27.sql
@@ -1,3 +1,10 @@
-- Added 1366x768 resolution
UPDATE releases SET resolution = 15 WHERE resolution = 14 AND NOT EXISTS(SELECT 1 FROM releases WHERE resolution = 15);
UPDATE releases_hist SET resolution = 15 WHERE resolution = 14 AND NOT EXISTS(SELECT 1 FROM releases_hist WHERE resolution = 15);
+
+-- Nintendo Switch & Wii U
+ALTER TYPE platform ADD VALUE 'swi' BEFORE 'wii';
+ALTER TYPE platform ADD VALUE 'wiu' BEFORE 'n3d';
+
+-- Bulgarian
+ALTER TYPE language ADD VALUE 'bg' BEFORE 'ca';