diff options
| author | Freya Murphy <freya@freyacat.org> | 2024-05-20 17:11:38 -0400 |
|---|---|---|
| committer | Freya Murphy <freya@freyacat.org> | 2024-05-20 17:11:38 -0400 |
| commit | 708594d32ffe779cf547c816fa7cdd19d095be2e (patch) | |
| tree | 30d28553316db02bc027664e17b76d58f2e352ff /src/db/rest/user/api_user.sql | |
| parent | add en_CAT makefile and use ucfirst/ucwords (diff) | |
| download | xssbook2-708594d32ffe779cf547c816fa7cdd19d095be2e.tar.gz xssbook2-708594d32ffe779cf547c816fa7cdd19d095be2e.tar.bz2 xssbook2-708594d32ffe779cf547c816fa7cdd19d095be2e.zip | |
v2 done
Diffstat (limited to 'src/db/rest/user/api_user.sql')
| -rw-r--r-- | src/db/rest/user/api_user.sql | 28 |
1 files changed, 27 insertions, 1 deletions
diff --git a/src/db/rest/user/api_user.sql b/src/db/rest/user/api_user.sql index d71fd1b..0660f42 100644 --- a/src/db/rest/user/api_user.sql +++ b/src/db/rest/user/api_user.sql @@ -23,7 +23,11 @@ CREATE VIEW api.user AS COALESCE(p.pc, 0) AS post_count, COALESCE(l.lc, 0) - AS like_count + AS like_count, + ma.mime + AS avatar_mime, + mb.mime + AS banner_mime FROM admin.user u LEFT JOIN ( @@ -81,6 +85,28 @@ CREATE VIEW api.user AS ) l ON u.id = l.user_id + LEFT JOIN ( + SELECT + ma.mime, + ma.user_id + FROM + admin.user_media ma + WHERE + ma.type = 'avatar' + ) ma + ON + u.id = ma.user_id + LEFT JOIN ( + SELECT + mb.mime, + mb.user_id + FROM + admin.user_media mb + WHERE + mb.type = 'banner' + ) mb + ON + u.id = mb.user_id WHERE u.deleted <> TRUE; |