summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2020-01-04 15:06:22 +0100
committerYorhel <git@yorhel.nl>2020-01-04 15:06:22 +0100
commit02cef019d30233603dd71cc837f382923cfd699a (patch)
tree4350c7907abbcb23b085bd40db8a9d580e750f81 /util
parent8620f71c6180e06164b2b51f930d94acaa439036 (diff)
ulist: Add ability to save views as default
Diffstat (limited to 'util')
-rw-r--r--util/sql/perms.sql6
-rw-r--r--util/sql/schema.sql5
-rw-r--r--util/updates/2020-01-04-ulist-saved-views.sql4
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