diff options
Diffstat (limited to 'util/sql')
-rw-r--r-- | util/sql/all.sql | 1 | ||||
-rw-r--r-- | util/sql/schema.sql | 4 |
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, |