summaryrefslogtreecommitdiff
path: root/src/db/rest/like/api_like.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/db/rest/like/api_like.sql')
-rw-r--r--src/db/rest/like/api_like.sql16
1 files changed, 16 insertions, 0 deletions
diff --git a/src/db/rest/like/api_like.sql b/src/db/rest/like/api_like.sql
new file mode 100644
index 0000000..6588b43
--- /dev/null
+++ b/src/db/rest/like/api_like.sql
@@ -0,0 +1,16 @@
+CREATE VIEW api.like AS
+ SELECT
+ l.id,
+ l.user_id,
+ l.post_id,
+ l.comment_id,
+ l.value,
+ l.created,
+ l.modified
+ FROM
+ admin.like l;
+
+GRANT SELECT ON TABLE api.like
+ TO rest_anon, rest_user;
+GRANT SELECT ON TABLE admin.like
+ TO rest_anon, rest_user;