[openstreetmap/openstreetmap-website] Mark the reason why a user was suspended/deleted (Issue #6544)

[Pablo Brasero]

pablobm created an issue (openstreetmap/openstreetmap-website#6544)

### Problem

I order to build better spam detection mechanisms, we want the ability to easily reference past spam content.

However currently we can only do this approximately as, currently, when a user is suspended we do not store the reason for this in DB. When later we want to get metrics on how many accounts were suspended for spam, we have to resort to heuristics.

Similarly it's not possible to know if a user was self-deleted or was deleted for a different reason.

### Description

Proposal: store the cause of suspension/deletion in DB.

Details:
- On the DB table `users` add new columns `suspension_reason character varying` and `deletion_reason character varying`.
- When an admin clicks "Hide this User", show an interface asking for the reason.
	- Free text, not required.
	- Include some sort of shortcut for the values `spam` and `abuse`.
- Similar for "Delete this User".
	- QUESTION: what should be the shortcut values?
- When a user self-deletes, automatically fill out `deletion_reason` with the value `self-deleted`.

### Screenshots

_No response_

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/issues/6544
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/openstreetmap-website/issues/6544 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20251119/307997dd/attachment.htm>