diff options
Diffstat (limited to 'db/rest/comment/api_comment.sql')
| -rw-r--r-- | db/rest/comment/api_comment.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/db/rest/comment/api_comment.sql b/db/rest/comment/api_comment.sql new file mode 100644 index 0000000..e50ca2f --- /dev/null +++ b/db/rest/comment/api_comment.sql @@ -0,0 +1,15 @@ +CREATE VIEW api.comment AS + SELECT + c.id, + c.user_id, + c.post_id, + c.content, + c.date + FROM + admin.comment c + ORDER BY id ASC; + +GRANT SELECT ON TABLE api.comment + TO rest_anon, rest_user; +GRANT SELECT ON TABLE admin.comment + TO rest_anon, rest_user; |