summaryrefslogtreecommitdiff
path: root/util/sql
diff options
context:
space:
mode:
Diffstat (limited to 'util/sql')
-rw-r--r--util/sql/all.sql1
-rw-r--r--util/sql/schema.sql4
2 files changed, 3 insertions, 2 deletions
diff --git a/util/sql/all.sql b/util/sql/all.sql
index 12f16b11..b96c1020 100644
--- a/util/sql/all.sql
+++ b/util/sql/all.sql
@@ -22,6 +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');
-- schema
diff --git a/util/sql/schema.sql b/util/sql/schema.sql
index 6c2d785b..9b031ae6 100644
--- a/util/sql/schema.sql
+++ b/util/sql/schema.sql
@@ -262,7 +262,7 @@ CREATE TABLE releases ( -- dbentry_type=r
patch boolean NOT NULL DEFAULT FALSE,
freeware boolean NOT NULL DEFAULT FALSE,
doujin boolean NOT NULL DEFAULT FALSE,
- resolution smallint NOT NULL DEFAULT 0,
+ resolution resolution NOT NULL DEFAULT 'unknown',
voiced smallint NOT NULL DEFAULT 0,
ani_story smallint NOT NULL DEFAULT 0,
ani_ero smallint NOT NULL DEFAULT 0,
@@ -284,7 +284,7 @@ CREATE TABLE releases_hist (
patch boolean NOT NULL DEFAULT FALSE,
freeware boolean NOT NULL DEFAULT FALSE,
doujin boolean NOT NULL DEFAULT FALSE,
- resolution smallint NOT NULL DEFAULT 0,
+ resolution resolution NOT NULL DEFAULT 'unknown',
voiced smallint NOT NULL DEFAULT 0,
ani_story smallint NOT NULL DEFAULT 0,
ani_ero smallint NOT NULL DEFAULT 0,