diff options
author | Yorhel <git@yorhel.nl> | 2020-01-04 15:06:22 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2020-01-04 15:06:22 +0100 |
commit | 02cef019d30233603dd71cc837f382923cfd699a (patch) | |
tree | 4350c7907abbcb23b085bd40db8a9d580e750f81 /util | |
parent | 8620f71c6180e06164b2b51f930d94acaa439036 (diff) |
ulist: Add ability to save views as default
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/perms.sql | 6 | ||||
-rw-r--r-- | util/sql/schema.sql | 5 | ||||
-rw-r--r-- | util/updates/2020-01-04-ulist-saved-views.sql | 4 |
3 files changed, 11 insertions, 4 deletions
diff --git a/util/sql/perms.sql b/util/sql/perms.sql index e649526f..b4833a60 100644 --- a/util/sql/perms.sql +++ b/util/sql/perms.sql @@ -67,9 +67,9 @@ GRANT SELECT, INSERT, UPDATE, DELETE ON ulist_vns_labels TO vndb_site; -- users table is special; The 'perm', 'passwd' and 'mail' columns are -- protected and can only be accessed through the user_* functions. -GRANT SELECT (id, username, registered, perm, c_votes, c_changes, ip, c_tags, ign_votes, email_confirmed, skin, customcss, filter_vn, filter_release, show_nsfw, hide_list, notify_dbedit, notify_announce, vn_list_own, vn_list_wish, tags_all, tags_cont, tags_ero, tags_tech, spoilers, traits_sexual, nodistract_can, nodistract_noads, nodistract_nofancy, support_can, support_enabled, uniname_can, uniname, pubskin_can, pubskin_enabled, c_vns, c_wish), - INSERT (id, username, mail, registered, c_votes, c_changes, ip, c_tags, ign_votes, email_confirmed, skin, customcss, filter_vn, filter_release, show_nsfw, hide_list, notify_dbedit, notify_announce, vn_list_own, vn_list_wish, tags_all, tags_cont, tags_ero, tags_tech, spoilers, traits_sexual, nodistract_can, nodistract_noads, nodistract_nofancy, support_can, support_enabled, uniname_can, uniname, pubskin_can, pubskin_enabled, c_vns, c_wish), - UPDATE ( username, registered, c_votes, c_changes, ip, c_tags, ign_votes, email_confirmed, skin, customcss, filter_vn, filter_release, show_nsfw, hide_list, notify_dbedit, notify_announce, vn_list_own, vn_list_wish, tags_all, tags_cont, tags_ero, tags_tech, spoilers, traits_sexual, nodistract_can, nodistract_noads, nodistract_nofancy, support_can, support_enabled, uniname_can, uniname, pubskin_can, pubskin_enabled, c_vns, c_wish) ON users TO vndb_site; +GRANT SELECT (id, username, registered, perm, c_votes, c_changes, ip, c_tags, ign_votes, email_confirmed, skin, customcss, filter_vn, filter_release, show_nsfw, hide_list, notify_dbedit, notify_announce, vn_list_own, vn_list_wish, tags_all, tags_cont, tags_ero, tags_tech, spoilers, traits_sexual, nodistract_can, nodistract_noads, nodistract_nofancy, support_can, support_enabled, uniname_can, uniname, pubskin_can, pubskin_enabled, c_vns, c_wish, ulist_votes, ulist_vnlist, ulist_wish), + INSERT (id, username, mail, registered, c_votes, c_changes, ip, c_tags, ign_votes, email_confirmed, skin, customcss, filter_vn, filter_release, show_nsfw, hide_list, notify_dbedit, notify_announce, vn_list_own, vn_list_wish, tags_all, tags_cont, tags_ero, tags_tech, spoilers, traits_sexual, nodistract_can, nodistract_noads, nodistract_nofancy, support_can, support_enabled, uniname_can, uniname, pubskin_can, pubskin_enabled, c_vns, c_wish, ulist_votes, ulist_vnlist, ulist_wish), + UPDATE ( username, registered, c_votes, c_changes, ip, c_tags, ign_votes, email_confirmed, skin, customcss, filter_vn, filter_release, show_nsfw, hide_list, notify_dbedit, notify_announce, vn_list_own, vn_list_wish, tags_all, tags_cont, tags_ero, tags_tech, spoilers, traits_sexual, nodistract_can, nodistract_noads, nodistract_nofancy, support_can, support_enabled, uniname_can, uniname, pubskin_can, pubskin_enabled, c_vns, c_wish, ulist_votes, ulist_vnlist, ulist_wish) ON users TO vndb_site; GRANT SELECT, INSERT, UPDATE ON vn TO vndb_site; GRANT SELECT, INSERT, DELETE ON vn_anime TO vndb_site; diff --git a/util/sql/schema.sql b/util/sql/schema.sql index 3bc27c77..f2cc611c 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -782,7 +782,10 @@ CREATE TABLE users ( pubskin_can boolean NOT NULL DEFAULT FALSE, pubskin_enabled boolean NOT NULL DEFAULT FALSE, c_vns integer NOT NULL DEFAULT 0, - c_wish integer NOT NULL DEFAULT 0 + c_wish integer NOT NULL DEFAULT 0, + ulist_votes jsonb, + ulist_vnlist jsonb, + ulist_wish jsonb ); -- vn diff --git a/util/updates/2020-01-04-ulist-saved-views.sql b/util/updates/2020-01-04-ulist-saved-views.sql new file mode 100644 index 00000000..14926ba6 --- /dev/null +++ b/util/updates/2020-01-04-ulist-saved-views.sql @@ -0,0 +1,4 @@ +ALTER TABLE users ADD COLUMN ulist_votes jsonb; +ALTER TABLE users ADD COLUMN ulist_vnlist jsonb; +ALTER TABLE users ADD COLUMN ulist_wish jsonb; +\i util/sql/perms.sql |