summaryrefslogtreecommitdiff
path: root/util/updates/update_2.27.sql
blob: 35e7b4af8e6e472e8f3ea888f9ebba13b86151fd (plain)
1
2
3
4
5
6
7
8
9
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';