From 7ca7bb13c3bd79a82b73bdd631399e25fdf6fe81 Mon Sep 17 00:00:00 2001 From: Yorhel Date: Sun, 12 Aug 2018 12:22:21 +0200 Subject: Add 1600x900 resolution https://vndb.org/t950.481 Also, the resolution should really be stored as an ENUM in the database, this integer thing is waay too fragile. --- data/global.pl | 1 + util/updates/update_20180812.sql | 3 +++ 2 files changed, 4 insertions(+) create mode 100644 util/updates/update_20180812.sql diff --git a/data/global.pl b/data/global.pl index ddebe436..7624be77 100644 --- a/data/global.pl +++ b/data/global.pl @@ -213,6 +213,7 @@ our %S; [ '1280x720', 'widescreen' ], [ '1280x800', 'widescreen' ], [ '1366x768', 'widescreen' ], + [ '1600x900', 'widescreen' ], [ '1920x1080', 'widescreen' ], ], tag_categories => ordhash( diff --git a/util/updates/update_20180812.sql b/util/updates/update_20180812.sql new file mode 100644 index 00000000..2e5bbe2c --- /dev/null +++ b/util/updates/update_20180812.sql @@ -0,0 +1,3 @@ +-- New resolution before 1920x1080 +UPDATE releases SET resolution = 16 WHERE resolution = 15; +UPDATE releases_hist SET resolution = 16 WHERE resolution = 15; -- cgit v1.2.3