[openstreetmap/openstreetmap-website] Store IP addresses of users suspended for spam reasons (Issue #6545)

[Pablo Brasero]

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

### Problem

Depends on https://github.com/openstreetmap/openstreetmap-website/issues/6544

As part of upcoming spam detection mechanisms, we want to be able to refer to IP addresses that, in the past, have been sources of spam.

### Description

Proposal: when a user is suspended for the reason of `spam`, automatically store their IP address in DB.

Details:
- Add a new table to DB: `abuse_ips`, with columns:
	- `address inet`.
	- `created_at timestamp without time zone NOT NULL`
- When a user is suspended with `suspension_reason=spam`, add their `creation_time` to `abuse_ips`.

### Screenshots

_No response_

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

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