diff options
Diffstat (limited to 'db/rest/comment/api_comment.sql')
| -rw-r--r-- | db/rest/comment/api_comment.sql | 15 |
1 files changed, 0 insertions, 15 deletions
diff --git a/db/rest/comment/api_comment.sql b/db/rest/comment/api_comment.sql deleted file mode 100644 index e50ca2f..0000000 --- a/db/rest/comment/api_comment.sql +++ /dev/null @@ -1,15 +0,0 @@ -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; |