diff options
| -rw-r--r-- | util/sql/schema.sql | 2 | ||||
| -rw-r--r-- | util/updates/update_20191003.sql | 4 |
2 files changed, 3 insertions, 3 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql index fa18937f..aa64289a 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -734,7 +734,7 @@ CREATE TABLE users ( tags_cont boolean NOT NULL DEFAULT TRUE, tags_ero boolean NOT NULL DEFAULT FALSE, tags_tech boolean NOT NULL DEFAULT TRUE, - spoilers boolean NOT NULL DEFAULT FALSE, + spoilers smallint NOT NULL DEFAULT 0, traits_sexual boolean NOT NULL DEFAULT FALSE ); diff --git a/util/updates/update_20191003.sql b/util/updates/update_20191003.sql index ee17363c..28e0ddf3 100644 --- a/util/updates/update_20191003.sql +++ b/util/updates/update_20191003.sql @@ -12,7 +12,7 @@ ALTER TABLE users ADD COLUMN tags_all boolean NOT NULL DEFAULT FALSE; ALTER TABLE users ADD COLUMN tags_cont boolean NOT NULL DEFAULT TRUE; ALTER TABLE users ADD COLUMN tags_ero boolean NOT NULL DEFAULT FALSE; ALTER TABLE users ADD COLUMN tags_tech boolean NOT NULL DEFAULT TRUE; -ALTER TABLE users ADD COLUMN spoilers boolean NOT NULL DEFAULT FALSE; +ALTER TABLE users ADD COLUMN spoilers smallint NOT NULL DEFAULT 0; ALTER TABLE users ADD COLUMN traits_sexual boolean NOT NULL DEFAULT FALSE; UPDATE users SET @@ -27,7 +27,7 @@ UPDATE users SET vn_list_own = COALESCE((SELECT TRUE FROM users_prefs WHERE uid = id AND key = 'vn_list_own' ), FALSE), vn_list_wish = COALESCE((SELECT TRUE FROM users_prefs WHERE uid = id AND key = 'vn_list_wish' ), FALSE), tags_all = COALESCE((SELECT TRUE FROM users_prefs WHERE uid = id AND key = 'tags_all' ), FALSE), - spoilers = COALESCE((SELECT TRUE FROM users_prefs WHERE uid = id AND key = 'spoilers' ), FALSE), + spoilers = COALESCE((SELECT value::smallint FROM users_prefs WHERE uid = id AND key = 'spoilers'), 0), traits_sexual = COALESCE((SELECT TRUE FROM users_prefs WHERE uid = id AND key = 'traits_sexual' ), FALSE), tags_cont = COALESCE((SELECT value LIKE '%cont%' FROM users_prefs WHERE uid = id AND key = 'tags_cat'), TRUE), tags_ero = COALESCE((SELECT value LIKE '%ero%' FROM users_prefs WHERE uid = id AND key = 'tags_cat'), FALSE), |