summaryrefslogtreecommitdiff
path: root/src/db/rest/like
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--src/db/rest/like/api_like.sql4
-rw-r--r--src/db/rest/like/api_like_delete.sql4
-rw-r--r--src/db/rest/like/api_like_insert.sql4
-rw-r--r--src/db/rest/like/api_like_update.sql4
4 files changed, 8 insertions, 8 deletions
diff --git a/src/db/rest/like/api_like.sql b/src/db/rest/like/api_like.sql
index 6588b43..f3d8e85 100644
--- a/src/db/rest/like/api_like.sql
+++ b/src/db/rest/like/api_like.sql
@@ -8,9 +8,9 @@ CREATE VIEW api.like AS
l.created,
l.modified
FROM
- admin.like l;
+ xssbook.like l;
GRANT SELECT ON TABLE api.like
TO rest_anon, rest_user;
-GRANT SELECT ON TABLE admin.like
+GRANT SELECT ON TABLE xssbook.like
TO rest_anon, rest_user;
diff --git a/src/db/rest/like/api_like_delete.sql b/src/db/rest/like/api_like_delete.sql
index 7209a40..b8231b7 100644
--- a/src/db/rest/like/api_like_delete.sql
+++ b/src/db/rest/like/api_like_delete.sql
@@ -11,7 +11,7 @@ BEGIN
PERFORM _api.raise_deny();
END IF;
- UPDATE admin.like SET
+ UPDATE xssbook.like SET
value = FALSE,
modified = clock_timestamp()
WHERE id = OLD.id;
@@ -22,7 +22,7 @@ GRANT EXECUTE ON FUNCTION _api.like_delete()
TO rest_user;
GRANT DELETE ON TABLE api.like
TO rest_user;
-GRANT UPDATE ON TABLE admin.like
+GRANT UPDATE ON TABLE xssbook.like
TO rest_user;
CREATE TRIGGER api_like_delete_trgr
diff --git a/src/db/rest/like/api_like_insert.sql b/src/db/rest/like/api_like_insert.sql
index a02ad4e..1c8bc8a 100644
--- a/src/db/rest/like/api_like_insert.sql
+++ b/src/db/rest/like/api_like_insert.sql
@@ -17,7 +17,7 @@ BEGIN
NEW.value := COALESCE(NEW.value, TRUE);
- INSERT INTO admin.like (
+ INSERT INTO xssbook.like (
user_id,
post_id,
comment_id,
@@ -39,7 +39,7 @@ GRANT EXECUTE ON FUNCTION _api.like_insert()
TO rest_user;
GRANT INSERT ON TABLE api.like
TO rest_user;
-GRANT INSERT ON TABLE admin.like
+GRANT INSERT ON TABLE xssbook.like
TO rest_user;
GRANT UPDATE ON TABLE sys.like_id_seq
TO rest_user;
diff --git a/src/db/rest/like/api_like_update.sql b/src/db/rest/like/api_like_update.sql
index 76db73a..1aab8cb 100644
--- a/src/db/rest/like/api_like_update.sql
+++ b/src/db/rest/like/api_like_update.sql
@@ -20,7 +20,7 @@ BEGIN
END IF;
IF _changed THEN
- UPDATE admin.like SET
+ UPDATE xssbook.like SET
value = NEW.value,
modified = clock_timestamp()
WHERE id = OLD.id;
@@ -34,7 +34,7 @@ GRANT EXECUTE ON FUNCTION _api.like_update()
TO rest_user;
GRANT UPDATE ON TABLE api.like
TO rest_user;
-GRANT UPDATE ON TABLE admin.like
+GRANT UPDATE ON TABLE xssbook.like
TO rest_user;
CREATE TRIGGER api_like_update_trgr