summaryrefslogtreecommitdiff
path: root/util/updates/update_20191003.sql
blob: ee17363c47c2f24e494e84a19a84b22917af9b55 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
ALTER TABLE users ADD COLUMN skin            text NOT NULL DEFAULT '';
ALTER TABLE users ADD COLUMN customcss       text NOT NULL DEFAULT '';
ALTER TABLE users ADD COLUMN filter_vn       text NOT NULL DEFAULT '';
ALTER TABLE users ADD COLUMN filter_release  text NOT NULL DEFAULT '';
ALTER TABLE users ADD COLUMN show_nsfw       boolean NOT NULL DEFAULT FALSE;
ALTER TABLE users ADD COLUMN hide_list       boolean NOT NULL DEFAULT FALSE;
ALTER TABLE users ADD COLUMN notify_dbedit   boolean NOT NULL DEFAULT TRUE;
ALTER TABLE users ADD COLUMN notify_announce boolean NOT NULL DEFAULT FALSE;
ALTER TABLE users ADD COLUMN vn_list_own     boolean NOT NULL DEFAULT FALSE;
ALTER TABLE users ADD COLUMN vn_list_wish    boolean NOT NULL DEFAULT FALSE;
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 traits_sexual   boolean NOT NULL DEFAULT FALSE;

UPDATE users SET
    skin            = COALESCE((SELECT value FROM users_prefs WHERE uid = id AND key = 'skin'           ), ''),
    customcss       = COALESCE((SELECT value FROM users_prefs WHERE uid = id AND key = 'customcss'      ), ''),
    filter_vn       = COALESCE((SELECT value FROM users_prefs WHERE uid = id AND key = 'filter_vn'      ), ''),
    filter_release  = COALESCE((SELECT value FROM users_prefs WHERE uid = id AND key = 'filter_release' ), ''),
    show_nsfw       = COALESCE((SELECT TRUE  FROM users_prefs WHERE uid = id AND key = 'show_nsfw'      ), FALSE),
    hide_list       = COALESCE((SELECT TRUE  FROM users_prefs WHERE uid = id AND key = 'hide_list'      ), FALSE),
    notify_dbedit   = COALESCE((SELECT FALSE FROM users_prefs WHERE uid = id AND key = 'notify_nodbedit'), TRUE), -- NOTE: Inverted
    notify_announce = COALESCE((SELECT TRUE  FROM users_prefs WHERE uid = id AND key = 'notify_announce'), FALSE),
    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),
    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),
    tags_tech       = COALESCE((SELECT value LIKE '%tech%' FROM users_prefs WHERE uid = id AND key = 'tags_cat'), TRUE);

\i util/sql/func.sql
\i util/sql/perms.sql

DROP TABLE users_prefs;
DROP TYPE prefs_key;