rename admin schema to xssbook

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