summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2018-10-06 15:07:22 +0200
committerYorhel <git@yorhel.nl>2018-10-06 15:07:24 +0200
commita69d8c88c0fdcd771a86227768a4acfdf7af9db1 (patch)
treea559a5f425230994113c3a1b4afb31c749b2c33d
parent3754ea24d296b74de5315789b74a7db2b7bacad9 (diff)
Add 960x640 resolution
https://vndb.org/t950.514
-rw-r--r--data/global.pl1
-rw-r--r--util/sql/all.sql2
-rw-r--r--util/updates/update_20181006.sql1
3 files changed, 3 insertions, 1 deletions
diff --git a/data/global.pl b/data/global.pl
index 18e128ad..e7896558 100644
--- a/data/global.pl
+++ b/data/global.pl
@@ -207,6 +207,7 @@ our %S;
'1600x1200' => [ '1600x1200', '4:3' ],
'640x400' => [ '640x400', 'widescreen' ],
'960x600' => [ '960x600', 'widescreen' ],
+ '960x640' => [ '960x640', 'widescreen' ],
'1024x576' => [ '1024x576', 'widescreen' ],
'1024x600' => [ '1024x600', 'widescreen' ],
'1024x640' => [ '1024x640', 'widescreen' ],
diff --git a/util/sql/all.sql b/util/sql/all.sql
index b96c1020..7b50c485 100644
--- a/util/sql/all.sql
+++ b/util/sql/all.sql
@@ -22,7 +22,7 @@ CREATE TYPE producer_relation AS ENUM ('old', 'new', 'sub', 'par', 'imp', 'ipa',
CREATE TYPE release_type AS ENUM ('complete', 'partial', 'trial');
CREATE TYPE tag_category AS ENUM('cont', 'ero', 'tech');
CREATE TYPE vn_relation AS ENUM ('seq', 'preq', 'set', 'alt', 'char', 'side', 'par', 'ser', 'fan', 'orig');
-CREATE TYPE resolution AS ENUM ('unknown', 'nonstandard', '640x480', '800x600', '1024x768', '1280x960', '1600x1200', '640x400', '960x600', '1024x576', '1024x600', '1024x640', '1280x720', '1280x800', '1366x768', '1600x900', '1920x1080');
+CREATE TYPE resolution AS ENUM ('unknown', 'nonstandard', '640x480', '800x600', '1024x768', '1280x960', '1600x1200', '640x400', '960x600', '960x640', '1024x576', '1024x600', '1024x640', '1280x720', '1280x800', '1366x768', '1600x900', '1920x1080');
-- schema
diff --git a/util/updates/update_20181006.sql b/util/updates/update_20181006.sql
new file mode 100644
index 00000000..1aa3b756
--- /dev/null
+++ b/util/updates/update_20181006.sql
@@ -0,0 +1 @@
+ALTER TYPE resolution ADD VALUE '960x640' AFTER '960x600';