Add language: Bulgarian and Platforms: Nintendo Switch & Wii U

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
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
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
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';