summaryrefslogtreecommitdiff
path: root/src/db/rest/like/api_like.sql
blob: 6588b432f039a78cb395c492eafbbdb73ea0ab60 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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;