diff options
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/schema.sql | 1 | ||||
-rw-r--r-- | util/updates/update_2.16.sql | 3 |
2 files changed, 3 insertions, 1 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql index 8826a01e..638191c3 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -266,7 +266,6 @@ CREATE TABLE users ( rank smallint NOT NULL DEFAULT 3, passwd bytea NOT NULL DEFAULT '', registered timestamptz NOT NULL DEFAULT NOW(), - show_list boolean NOT NULL DEFAULT TRUE, c_votes integer NOT NULL DEFAULT 0, c_changes integer NOT NULL DEFAULT 0, ip inet NOT NULL DEFAULT '0.0.0.0', diff --git a/util/updates/update_2.16.sql b/util/updates/update_2.16.sql index a0678fd3..b401a7a4 100644 --- a/util/updates/update_2.16.sql +++ b/util/updates/update_2.16.sql @@ -65,8 +65,11 @@ INSERT INTO users_prefs (uid, key, value) SELECT id, 'customcss', customcss FROM users WHERE customcss <> ''; UNION SELECT id, 'show_nsfw'::prefs_key, '1' FROM users WHERE show_nsfw; + UNION + SELECT id, 'hide_list'::prefs_key, '1' FROM users WHERE NOT show_list; ALTER TABLE users DROP COLUMN skin; ALTER TABLE users DROP COLUMN customcss; ALTER TABLE users DROP COLUMN show_nsfw; +ALTER TABLE users DROP COLUMN show_list; |