summaryrefslogtreecommitdiff
path: root/src/db/rest/comment
diff options
context:
space:
mode:
Diffstat (limited to 'src/db/rest/comment')
-rw-r--r--src/db/rest/comment/api_comment.sql8
-rw-r--r--src/db/rest/comment/api_comment_delete.sql4
-rw-r--r--src/db/rest/comment/api_comment_insert.sql6
-rw-r--r--src/db/rest/comment/api_comment_update.sql4
4 files changed, 11 insertions, 11 deletions
diff --git a/src/db/rest/comment/api_comment.sql b/src/db/rest/comment/api_comment.sql
index c8a0e19..36db10c 100644
--- a/src/db/rest/comment/api_comment.sql
+++ b/src/db/rest/comment/api_comment.sql
@@ -7,13 +7,13 @@ CREATE VIEW api.comment AS
c.created,
c.modified
FROM
- admin.comment c
+ xssbook.comment c
LEFT JOIN
- admin.post p
+ xssbook.post p
ON
p.id = c.post_id
LEFT JOIN
- admin.user u
+ xssbook.user u
ON
u.id = c.user_id
WHERE
@@ -25,5 +25,5 @@ CREATE VIEW api.comment AS
GRANT SELECT ON TABLE api.comment
TO rest_anon, rest_user;
-GRANT SELECT ON TABLE admin.comment
+GRANT SELECT ON TABLE xssbook.comment
TO rest_anon, rest_user;
diff --git a/src/db/rest/comment/api_comment_delete.sql b/src/db/rest/comment/api_comment_delete.sql
index 262b2ed..9762562 100644
--- a/src/db/rest/comment/api_comment_delete.sql
+++ b/src/db/rest/comment/api_comment_delete.sql
@@ -11,7 +11,7 @@ BEGIN
PERFORM _api.raise_deny();
END IF;
- UPDATE admin.comment SET
+ UPDATE xssbook.comment SET
deleted = TRUE,
modified = clock_timestamp()
WHERE id = OLD.id;
@@ -22,7 +22,7 @@ GRANT EXECUTE ON FUNCTION _api.comment_delete()
TO rest_user;
GRANT DELETE ON TABLE api.comment
TO rest_user;
-GRANT UPDATE ON TABLE admin.comment
+GRANT UPDATE ON TABLE xssbook.comment
TO rest_user;
CREATE TRIGGER api_comment_delete_trgr
diff --git a/src/db/rest/comment/api_comment_insert.sql b/src/db/rest/comment/api_comment_insert.sql
index 990beef..f3c78aa 100644
--- a/src/db/rest/comment/api_comment_insert.sql
+++ b/src/db/rest/comment/api_comment_insert.sql
@@ -16,7 +16,7 @@ BEGIN
);
PERFORM TRUE
- FROM admin.post
+ FROM xssbook.post
WHERE id = NEW.post_id;
IF NOT FOUND THEN
@@ -26,7 +26,7 @@ BEGIN
);
END IF;
- INSERT INTO admin.comment (
+ INSERT INTO xssbook.comment (
user_id,
post_id,
content
@@ -46,7 +46,7 @@ GRANT EXECUTE ON FUNCTION _api.comment_insert()
TO rest_user;
GRANT INSERT ON TABLE api.comment
TO rest_user;
-GRANT INSERT ON TABLE admin.comment
+GRANT INSERT ON TABLE xssbook.comment
TO rest_user;
GRANT UPDATE ON TABLE sys.comment_id_seq
TO rest_user;
diff --git a/src/db/rest/comment/api_comment_update.sql b/src/db/rest/comment/api_comment_update.sql
index b8fc16d..856cd26 100644
--- a/src/db/rest/comment/api_comment_update.sql
+++ b/src/db/rest/comment/api_comment_update.sql
@@ -27,7 +27,7 @@ BEGIN
END IF;
IF _changed THEN
- UPDATE admin.comment SET
+ UPDATE xssbook.comment SET
content = NEW.content,
modified = clock_timestamp()
WHERE id = OLD.id;
@@ -41,7 +41,7 @@ GRANT EXECUTE ON FUNCTION _api.comment_update()
TO rest_user;
GRANT UPDATE ON TABLE api.comment
TO rest_user;
-GRANT UPDATE ON TABLE admin.comment
+GRANT UPDATE ON TABLE xssbook.comment
TO rest_user;
CREATE TRIGGER api_comment_update_trgr