summaryrefslogtreecommitdiff
path: root/src/db/rest/like/api_like.sql
blob: f3d8e8591408c01cba386e9f81310f255b2c7a5f (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
		xssbook.like l;

GRANT SELECT ON TABLE api.like
	TO rest_anon, rest_user;
GRANT SELECT ON TABLE xssbook.like
	TO rest_anon, rest_user;