summaryrefslogtreecommitdiff
path: root/schema.sql
diff options
context:
space:
mode:
authorTor Andersson <tor@ccxvii.net>2022-08-02 12:20:00 +0200
committerTor Andersson <tor@ccxvii.net>2022-08-02 12:57:55 +0200
commit5c1d5d9c2a74502e40f67ef47337a97349be0d0d (patch)
treeccbc75c0511484708955b5a8772c14b8d24f4c89 /schema.sql
parentcaa863f358209117260911b88dca65a95948605d (diff)
downloadserver-5c1d5d9c2a74502e40f67ef47337a97349be0d0d.tar.gz
Moderation tools for admin user.
Ban and unban users. Delete forum posts and threads.
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/schema.sql b/schema.sql
index f3d5d02..ca86e67 100644
--- a/schema.sql
+++ b/schema.sql
@@ -91,7 +91,7 @@ create view user_login_view as
drop view if exists user_profile_view;
create view user_profile_view as
select
- user_id, name, mail, notify, ctime, atime, about
+ user_id, name, mail, notify, ctime, atime, about, is_banned
from
users
natural left join user_last_seen