summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2019-12-03 13:28:09 +0100
committerYorhel <git@yorhel.nl>2019-12-03 13:28:13 +0100
commitb26fb3e1b488f1e8b7ee2496b7a6e274953a30af (patch)
treeda6250666c22c476419f1dc8b0e67865dd6e464f /util
parent4b258b5b35af5fc7676507b3bf09e285bf722b0d (diff)
API: Add "get ulist-labels" and "get ulist"
To directly query the new list feature. I'll migrate the old vnlist/wishlist/votelist APIs later to query the 'ulist' tables.
Diffstat (limited to 'util')
-rw-r--r--util/updates/update_wip_lists.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/util/updates/update_wip_lists.sql b/util/updates/update_wip_lists.sql
index 32b7c9fd..b453a406 100644
--- a/util/updates/update_wip_lists.sql
+++ b/util/updates/update_wip_lists.sql
@@ -150,3 +150,7 @@ CREATE TRIGGER ulist_voted_label AFTER INSERT OR UPDATE ON ulist_vns FOR EACH RO
GRANT SELECT, INSERT, UPDATE, DELETE ON ulist_vns TO vndb_site;
GRANT SELECT, INSERT, UPDATE, DELETE ON ulist_labels TO vndb_site;
GRANT SELECT, INSERT, UPDATE, DELETE ON ulist_vns_labels TO vndb_site;
+
+GRANT SELECT, INSERT, UPDATE, DELETE ON ulist_vns TO vndb_multi;
+GRANT SELECT, INSERT, UPDATE, DELETE ON ulist_labels TO vndb_multi;
+GRANT SELECT, INSERT, UPDATE, DELETE ON ulist_vns_labels TO vndb_multi;