7 files changed, 24 insertions, 24 deletions
diff --git a/src/db/rest/media/_api_serve_system_media.sql b/src/db/rest/media/_api_serve_system_media.sql
index 5cd87c2..7e38949 100644
--- a/src/db/rest/media/_api_serve_system_media.sql
+++ b/src/db/rest/media/_api_serve_system_media.sql
@@ -13,12 +13,12 @@ BEGIN
        '{"Content-Disposition": "inline; filename=\"%s\""},'
        '{"Cache-Control": "max-age=259200"}]'
       ,	m.mime, m.name)
-	FROM admin.media m
+	FROM xssbook.media m
 	WHERE m.id = _media_id
 	INTO _headers;
 
 	SELECT m.content
-	FROM admin.media m
+	FROM xssbook.media m
 	WHERE m.id = _media_id
 	INTO _data;
 
@@ -33,5 +33,5 @@ $BODY$;
 
 GRANT EXECUTE ON FUNCTION _api.serve_system_media(INTEGER)
 	TO rest_anon, rest_user;
-GRANT SELECT ON TABLE admin.media
+GRANT SELECT ON TABLE xssbook.media
 	TO rest_anon, rest_user;
diff --git a/src/db/rest/media/_api_serve_user_media.sql b/src/db/rest/media/_api_serve_user_media.sql
index 3487493..c5942f1 100644
--- a/src/db/rest/media/_api_serve_user_media.sql
+++ b/src/db/rest/media/_api_serve_user_media.sql
@@ -13,12 +13,12 @@ BEGIN
        '{"Content-Disposition": "inline"},'
        '{"Cache-Control": "max-age=259200"}]'
       ,	m.mime)
-	FROM admin.user_media m
+	FROM xssbook.user_media m
 	WHERE m.id = _media_id
 	INTO _headers;
 
 	SELECT m.content
-	FROM admin.user_media m
+	FROM xssbook.user_media m
 	WHERE m.id = _media_id
 	INTO _data;
 
@@ -33,5 +33,5 @@ $BODY$;
 
 GRANT EXECUTE ON FUNCTION _api.serve_user_media(INTEGER)
 	TO rest_anon, rest_user;
-GRANT SELECT ON TABLE admin.user_media
+GRANT SELECT ON TABLE xssbook.user_media
 	TO rest_anon, rest_user;
diff --git a/src/db/rest/media/_api_serve_user_or_default_media.sql b/src/db/rest/media/_api_serve_user_or_default_media.sql
index c079ba9..08f6483 100644
--- a/src/db/rest/media/_api_serve_user_or_default_media.sql
+++ b/src/db/rest/media/_api_serve_user_or_default_media.sql
@@ -1,6 +1,6 @@
 CREATE FUNCTION _api.serve_user_or_default_media(
 	_user_id INTEGER,
-	_type admin.user_media_type,
+	_type xssbook.user_media_type,
 	_default TEXT
 )
 RETURNS sys."*/*"
@@ -11,7 +11,7 @@ DECLARE
 BEGIN
 
 	SELECT id
-	FROM admin.user_media m
+	FROM xssbook.user_media m
 	WHERE m.type = _type
 	AND m.user_id = _user_id
 	INTO _media_id;
@@ -21,7 +21,7 @@ BEGIN
 	END IF;
 
 	SELECT id
-	FROM admin.media m
+	FROM xssbook.media m
 	WHERE m.name = _default
 	INTO _media_id;
 
@@ -33,9 +33,9 @@ BEGIN
 END
 $BODY$;
 
-GRANT EXECUTE ON FUNCTION _api.serve_user_or_default_media(INTEGER, admin.user_media_type, TEXT)
+GRANT EXECUTE ON FUNCTION _api.serve_user_or_default_media(INTEGER, xssbook.user_media_type, TEXT)
 	TO rest_anon, rest_user;
-GRANT SELECT ON TABLE admin.user_media
+GRANT SELECT ON TABLE xssbook.user_media
 	TO rest_anon, rest_user;
-GRANT SELECT ON TABLE admin.media
+GRANT SELECT ON TABLE xssbook.media
 	TO rest_anon, rest_user;
diff --git a/src/db/rest/media/api_delete_user_media.sql b/src/db/rest/media/api_delete_user_media.sql
index d9a4529..4db4540 100644
--- a/src/db/rest/media/api_delete_user_media.sql
+++ b/src/db/rest/media/api_delete_user_media.sql
@@ -1,5 +1,5 @@
 CREATE FUNCTION api.delete_user_media(
-	media_type admin.user_media_type
+	media_type xssbook.user_media_type
 )
 RETURNS void
 LANGUAGE plpgsql VOLATILE
@@ -11,16 +11,16 @@ BEGIN
 	_user_id = _api.get_user_id();
 
 	DELETE FROM
-		admin.user_media
+		xssbook.user_media
 	WHERE
 		"type" = media_type AND
 		"user_id" = _user_id;
 END
 $BODY$;
 
-GRANT EXECUTE ON FUNCTION api.delete_user_media(admin.user_media_type)
+GRANT EXECUTE ON FUNCTION api.delete_user_media(xssbook.user_media_type)
 	TO rest_user;
-GRANT DELETE ON TABLE admin.user_media
+GRANT DELETE ON TABLE xssbook.user_media
 	TO rest_user;
 GRANT UPDATE ON TABLE sys.user_media_id_seq
 	TO rest_user;
diff --git a/src/db/rest/media/api_profile_avatar.sql b/src/db/rest/media/api_profile_avatar.sql
index b3e456c..0bcd4ab 100644
--- a/src/db/rest/media/api_profile_avatar.sql
+++ b/src/db/rest/media/api_profile_avatar.sql
@@ -10,7 +10,7 @@ BEGIN
 	_default := 'default_avatar_' || MOD(user_id, 25) || '.png';
 	RETURN _api.serve_user_or_default_media(
 		user_id,
-		'avatar'::admin.user_media_type,
+		'avatar'::xssbook.user_media_type,
 		_default
 	);
 END
diff --git a/src/db/rest/media/api_profile_banner.sql b/src/db/rest/media/api_profile_banner.sql
index d98f553..cdadaf4 100644
--- a/src/db/rest/media/api_profile_banner.sql
+++ b/src/db/rest/media/api_profile_banner.sql
@@ -10,7 +10,7 @@ BEGIN
 	_default := 'default_banner_' || MOD(user_id, 25) || '.png';
 	RETURN _api.serve_user_or_default_media(
 		user_id,
-		'banner'::admin.user_media_type,
+		'banner'::xssbook.user_media_type,
 		_default
 	);
 END
@@ -18,7 +18,7 @@ $BODY$;
 
 GRANT EXECUTE ON FUNCTION api.profile_banner(INTEGER)
 	TO rest_anon, rest_user;
-GRANT SELECT ON TABLE admin.user_media
+GRANT SELECT ON TABLE xssbook.user_media
 	TO rest_anon, rest_user;
-GRANT SELECT ON TABLE admin.media
+GRANT SELECT ON TABLE xssbook.media
 	TO rest_anon, rest_user;
diff --git a/src/db/rest/media/api_update_user_media.sql b/src/db/rest/media/api_update_user_media.sql
index be8835a..a2d8f5c 100644
--- a/src/db/rest/media/api_update_user_media.sql
+++ b/src/db/rest/media/api_update_user_media.sql
@@ -1,5 +1,5 @@
 CREATE FUNCTION api.update_user_media(
-	media_type admin.user_media_type,
+	media_type xssbook.user_media_type,
 	mime TEXT,
 	content TEXT
 )
@@ -13,7 +13,7 @@ BEGIN
 	_user_id = _api.get_user_id();
 	_data = decode(content, 'base64');
 
-	INSERT INTO admin.user_media (
+	INSERT INTO xssbook.user_media (
 		user_id,
 		content,
 		mime,
@@ -33,9 +33,9 @@ BEGIN
 END
 $BODY$;
 
-GRANT EXECUTE ON FUNCTION api.update_user_media(admin.user_media_type, TEXT, TEXT)
+GRANT EXECUTE ON FUNCTION api.update_user_media(xssbook.user_media_type, TEXT, TEXT)
 	TO rest_user;
-GRANT INSERT, UPDATE ON TABLE admin.user_media
+GRANT INSERT, UPDATE ON TABLE xssbook.user_media
 	TO rest_user;
 GRANT UPDATE ON TABLE sys.user_media_id_seq
 	TO rest_user;