diff options
Diffstat (limited to 'src/db/rest/user/api_user.sql')
| -rw-r--r-- | src/db/rest/user/api_user.sql | 18 |
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; |