rename admin schema to xssbook

1 files changed, 9 insertions, 9 deletions

diff --git a/src/db/rest/user/api_user.sql b/src/db/rest/user/api_user.sql
index 0660f42..2087ab9 100644
--- a/src/db/rest/user/api_user.sql
+++ b/src/db/rest/user/api_user.sql
@@ -29,13 +29,13 @@ CREATE VIEW api.user AS
 		mb.mime
 			AS banner_mime
 	FROM
-		admin.user u
+		xssbook.user u
 	LEFT JOIN (
 		SELECT
 			COUNT(f.id) as fc,
 			f.followee_id
 		FROM
-			admin.follow f
+			xssbook.follow f
 		GROUP BY
 			f.followee_id
 	) f
@@ -46,7 +46,7 @@ CREATE VIEW api.user AS
 			COUNT(fl.id) as fc,
 			fl.follower_id
 		FROM
-			admin.follow fl
+			xssbook.follow fl
 		GROUP BY
 			fl.follower_id
 	) fl
@@ -57,7 +57,7 @@ CREATE VIEW api.user AS
 			COUNT(c.id) as cc,
 			c.user_id
 		FROM
-			admin.comment c
+			xssbook.comment c
 		GROUP BY
 			c.user_id
 	) c
@@ -68,7 +68,7 @@ CREATE VIEW api.user AS
 			COUNT(p.id) as pc,
 			p.user_id
 		FROM
-			admin.post p
+			xssbook.post p
 		GROUP BY
 			p.user_id
 	) p
@@ -79,7 +79,7 @@ CREATE VIEW api.user AS
 			COUNT(l.id) as lc,
 			l.user_id
 		FROM
-			admin.like l
+			xssbook.like l
 		GROUP BY
 			l.user_id
 	) l
@@ -90,7 +90,7 @@ CREATE VIEW api.user AS
 			ma.mime,
 			ma.user_id
 		FROM
-			admin.user_media ma
+			xssbook.user_media ma
 		WHERE
 			ma.type = 'avatar'
 	) ma
@@ -101,7 +101,7 @@ CREATE VIEW api.user AS
 			mb.mime,
 			mb.user_id
 		FROM
-			admin.user_media mb
+			xssbook.user_media mb
 		WHERE
 			mb.type = 'banner'
 	) mb
@@ -112,5 +112,5 @@ CREATE VIEW api.user AS
 
 GRANT SELECT ON TABLE api.user
 	TO rest_anon, rest_user;
-GRANT SELECT ON TABLE admin.user
+GRANT SELECT ON TABLE xssbook.user
 	TO rest_anon, rest_user;