diff options
| author | Freya Murphy <freya@freyacat.org> | 2024-03-30 16:36:54 -0400 |
|---|---|---|
| committer | Freya Murphy <freya@freyacat.org> | 2024-03-30 16:36:54 -0400 |
| commit | 1f647374a8cdf3bc5c2d29ff8be277b027925c8c (patch) | |
| tree | 9fdf42d250edb941de13ecd1aab9185ba2b30b00 /db/rest/comment/api_comment.sql | |
| parent | rename views to _views (diff) | |
| download | xssbook2-1f647374a8cdf3bc5c2d29ff8be277b027925c8c.tar.gz xssbook2-1f647374a8cdf3bc5c2d29ff8be277b027925c8c.tar.bz2 xssbook2-1f647374a8cdf3bc5c2d29ff8be277b027925c8c.zip | |
post comments, refactor post loading, hide load more btn
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; |