From 3a82baec9d793edf81ac2b151b0f4d4159641375 Mon Sep 17 00:00:00 2001 From: Freya Murphy Date: Mon, 1 Apr 2024 11:09:25 -0400 Subject: login and register, liking on homepage --- db/rest/user/api_user.sql | 23 ----------------------- 1 file changed, 23 deletions(-) delete mode 100644 db/rest/user/api_user.sql (limited to 'db/rest/user/api_user.sql') diff --git a/db/rest/user/api_user.sql b/db/rest/user/api_user.sql deleted file mode 100644 index e45768a..0000000 --- a/db/rest/user/api_user.sql +++ /dev/null @@ -1,23 +0,0 @@ -CREATE VIEW api.user AS - SELECT - u.id, - u.username, - NULL AS password, - u.role, - u.first_name, - u.last_name, - u.middle_name, - u.email, - u.gender, - u.join_date, - u.birth_date, - u.profile_avatar, - u.profile_banner, - u.profile_bio - FROM - admin.user u; - -GRANT SELECT ON TABLE api.user - TO rest_anon, rest_user; -GRANT SELECT ON TABLE admin.user - TO rest_anon, rest_user; -- cgit v1.2.3-freya