summaryrefslogtreecommitdiff
path: root/util/updates
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2017-11-26 08:34:25 +0100
committerYorhel <git@yorhel.nl>2017-11-26 08:37:24 +0100
commit489603502533761684d3f098f4efc8fa3a92b3ff (patch)
treed0efee480f8406ddb1291e0b6b8e18ffa16f20b5 /util/updates
parent305f7c37359e85d881586de542af856092a230ab (diff)
Add language: Bulgarian and Platforms: Nintendo Switch & Wii U
Diffstat (limited to 'util/updates')
-rw-r--r--util/updates/update_2.27.sql7
1 files changed, 7 insertions, 0 deletions
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';