diff options
Diffstat (limited to 'src/db/rest/comment/api_comment_update.sql')
| -rw-r--r-- | src/db/rest/comment/api_comment_update.sql | 4 |
1 files changed, 2 insertions, 2 deletions
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 |