summaryrefslogtreecommitdiff
path: root/src/db/rest/post
diff options
context:
space:
mode:
Diffstat (limited to 'src/db/rest/post')
-rw-r--r--src/db/rest/post/api_post.sql10
-rw-r--r--src/db/rest/post/api_post_delete.sql4
-rw-r--r--src/db/rest/post/api_post_insert.sql4
-rw-r--r--src/db/rest/post/api_post_update.sql4
4 files changed, 11 insertions, 11 deletions
diff --git a/src/db/rest/post/api_post.sql b/src/db/rest/post/api_post.sql
index b5c42a8..5796a19 100644
--- a/src/db/rest/post/api_post.sql
+++ b/src/db/rest/post/api_post.sql
@@ -10,13 +10,13 @@ CREATE VIEW api.post AS
COALESCE(l.lc, 0)
AS like_count
FROM
- admin.post p
+ xssbook.post p
LEFT JOIN (
SELECT
COUNT(c.id) as cc,
c.post_id
FROM
- admin.comment c
+ xssbook.comment c
GROUP BY
c.post_id
) c
@@ -27,14 +27,14 @@ CREATE VIEW api.post AS
COUNT(l.id) as lc,
l.post_id
FROM
- admin.like l
+ xssbook.like l
GROUP BY
l.post_id
) l
ON
p.id = l.post_id
LEFT JOIN
- admin.user u
+ xssbook.user u
ON
u.id = p.user_id
WHERE
@@ -46,5 +46,5 @@ CREATE VIEW api.post AS
GRANT SELECT ON TABLE api.post
TO rest_anon, rest_user;
-GRANT SELECT ON TABLE admin.post
+GRANT SELECT ON TABLE xssbook.post
TO rest_anon, rest_user;
diff --git a/src/db/rest/post/api_post_delete.sql b/src/db/rest/post/api_post_delete.sql
index 8f26b40..5c2a014 100644
--- a/src/db/rest/post/api_post_delete.sql
+++ b/src/db/rest/post/api_post_delete.sql
@@ -11,7 +11,7 @@ BEGIN
PERFORM _api.raise_deny();
END IF;
- UPDATE admin.post SET
+ UPDATE xssbook.post SET
deleted = TRUE,
modified = clock_timestamp()
WHERE id = OLD.id;
@@ -22,7 +22,7 @@ GRANT EXECUTE ON FUNCTION _api.post_delete()
TO rest_user;
GRANT DELETE ON TABLE api.post
TO rest_user;
-GRANT UPDATE ON TABLE admin.post
+GRANT UPDATE ON TABLE xssbook.post
TO rest_user;
CREATE TRIGGER api_post_delete_trgr
diff --git a/src/db/rest/post/api_post_insert.sql b/src/db/rest/post/api_post_insert.sql
index e0594dc..c71eb01 100644
--- a/src/db/rest/post/api_post_insert.sql
+++ b/src/db/rest/post/api_post_insert.sql
@@ -16,7 +16,7 @@ BEGIN
_max => 4096
);
- INSERT INTO admin.post (
+ INSERT INTO xssbook.post (
user_id,
content
) VALUES (
@@ -34,7 +34,7 @@ GRANT EXECUTE ON FUNCTION _api.post_insert()
TO rest_user;
GRANT INSERT ON TABLE api.post
TO rest_user;
-GRANT INSERT ON TABLE admin.post
+GRANT INSERT ON TABLE xssbook.post
TO rest_user;
GRANT UPDATE ON TABLE sys.post_id_seq
TO rest_user;
diff --git a/src/db/rest/post/api_post_update.sql b/src/db/rest/post/api_post_update.sql
index 7b4360d..351a698 100644
--- a/src/db/rest/post/api_post_update.sql
+++ b/src/db/rest/post/api_post_update.sql
@@ -27,7 +27,7 @@ BEGIN
END IF;
IF _changed THEN
- UPDATE admin.post SET
+ UPDATE xssbook.post SET
content = NEW.content,
modified = clock_timestamp()
WHERE id = OLD.id;
@@ -41,7 +41,7 @@ GRANT EXECUTE ON FUNCTION _api.post_update()
TO rest_user;
GRANT UPDATE ON TABLE api.post
TO rest_user;
-GRANT UPDATE ON TABLE admin.post
+GRANT UPDATE ON TABLE xssbook.post
TO rest_user;
CREATE TRIGGER api_post_update_trgr