diff options
author | Yorhel <git@yorhel.nl> | 2019-12-03 13:28:09 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2019-12-03 13:28:13 +0100 |
commit | b26fb3e1b488f1e8b7ee2496b7a6e274953a30af (patch) | |
tree | da6250666c22c476419f1dc8b0e67865dd6e464f /util | |
parent | 4b258b5b35af5fc7676507b3bf09e285bf722b0d (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.sql | 4 |
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; |