diff options
Diffstat (limited to '')
| -rw-r--r-- | src/db/rest/user/api_user.sql (renamed from db/rest/user/api_user.sql) | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/db/rest/user/api_user.sql b/src/db/rest/user/api_user.sql index e45768a..6735775 100644 --- a/db/rest/user/api_user.sql +++ b/src/db/rest/user/api_user.sql @@ -9,13 +9,15 @@ CREATE VIEW api.user AS u.middle_name, u.email, u.gender, - u.join_date, u.birth_date, - u.profile_avatar, - u.profile_banner, - u.profile_bio + u.profile_bio, + u.created, + u.modified, + u.seen FROM - admin.user u; + admin.user u + WHERE + u.deleted <> TRUE; GRANT SELECT ON TABLE api.user TO rest_anon, rest_user; |