5 files changed, 20 insertions, 20 deletions

diff --git a/src/db/rest/user/api_update_password.sql b/src/db/rest/user/api_update_password.sql
index 34cc1ac..acc53de 100644
--- a/src/db/rest/user/api_update_password.sql
+++ b/src/db/rest/user/api_update_password.sql
@@ -20,7 +20,7 @@ BEGIN
 
 	SELECT password
 		INTO _real_password
-		FROM admin.user
+		FROM xssbook.user
 		WHERE id = _user_id;
 
 	IF _real_password <> current_password THEN
@@ -30,7 +30,7 @@ BEGIN
 	END IF;
 
 	UPDATE
-		admin.user
+		xssbook.user
 	SET
 		"password" = new_password
 	WHERE
@@ -40,5 +40,5 @@ $BODY$;
 
 GRANT EXECUTE ON FUNCTION api.update_password(TEXT, TEXT)
 	TO rest_user;
-GRANT SELECT, UPDATE ON TABLE admin.user
+GRANT SELECT, UPDATE ON TABLE xssbook.user
 	TO rest_user;
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;
diff --git a/src/db/rest/user/api_user_delete.sql b/src/db/rest/user/api_user_delete.sql
index 4389fa0..fbcf719 100644
--- a/src/db/rest/user/api_user_delete.sql
+++ b/src/db/rest/user/api_user_delete.sql
@@ -11,7 +11,7 @@ BEGIN
 		PERFORM _api.raise_deny();
 	END IF;
 
-	UPDATE admin.user SET
+	UPDATE xssbook.user SET
 		deleted = TRUE,
 		modified = clock_timestamp()
 		WHERE id = _user_id;
@@ -22,7 +22,7 @@ GRANT EXECUTE ON FUNCTION _api.user_delete()
 	TO rest_user;
 GRANT DELETE ON TABLE api.user
 	TO rest_user;
-GRANT UPDATE ON TABLE admin.user
+GRANT UPDATE ON TABLE xssbook.user
 	TO rest_user;
 
 CREATE TRIGGER api_user_delete_trgr
diff --git a/src/db/rest/user/api_user_insert.sql b/src/db/rest/user/api_user_insert.sql
index 1a6ef7c..cf70a8a 100644
--- a/src/db/rest/user/api_user_insert.sql
+++ b/src/db/rest/user/api_user_insert.sql
@@ -22,7 +22,7 @@ BEGIN
 		_max => 24
 	);
 
-	PERFORM TRUE FROM admin.user
+	PERFORM TRUE FROM xssbook.user
 		WHERE username = NEW.username;
 
 	IF FOUND THEN
@@ -84,7 +84,7 @@ BEGIN
 	);
 	NEW.profile_bio = COALESCE(NEW.profile_bio, ''::text);
 
-	INSERT INTO admin.user (
+	INSERT INTO xssbook.user (
 		username,
 		password,
 		first_name,
@@ -118,7 +118,7 @@ GRANT EXECUTE ON FUNCTION _api.user_insert()
 	TO rest_anon, rest_user;
 GRANT INSERT ON TABLE api.user
 	TO rest_anon, rest_user;
-GRANT INSERT ON TABLE admin.user
+GRANT INSERT ON TABLE xssbook.user
 	TO rest_anon, rest_user;
 GRANT UPDATE ON TABLE sys.user_id_seq
 	TO rest_anon, rest_user;
diff --git a/src/db/rest/user/api_user_update.sql b/src/db/rest/user/api_user_update.sql
index c26c680..27b9042 100644
--- a/src/db/rest/user/api_user_update.sql
+++ b/src/db/rest/user/api_user_update.sql
@@ -24,7 +24,7 @@ BEGIN
 	);
 
 	IF NEW.username IS DISTINCT FROM OLD.username THEN
-		PERFORM TRUE FROM admin.user
+		PERFORM TRUE FROM xssbook.user
 			WHERE username = NEW.username;
 		IF FOUND THEN
 			PERFORM _api.raise_unique('username');
@@ -117,7 +117,7 @@ BEGIN
 	END IF;
 
 	IF _changed THEN
-		UPDATE admin.user SET
+		UPDATE xssbook.user SET
 			username = NEW.username,
 			first_name = NEW.first_name,
 			last_name = NEW.last_name,
@@ -138,7 +138,7 @@ GRANT EXECUTE ON FUNCTION _api.user_update()
 	TO rest_user;
 GRANT UPDATE ON TABLE api.user
 	TO rest_user;
-GRANT UPDATE ON TABLE admin.user
+GRANT UPDATE ON TABLE xssbook.user
 	TO rest_user;
 
 CREATE TRIGGER api_user_update_trgr