Purge IP addresses from works after a configurable number of days

Description

When a user posts or edits a work (but not when they post or edit chapters), their IP address is logged for spam and abuse prevention. The IP address is stored in the database and visible to admins in the work meta.

We would like a Scheduler task that will run daily and set the work IP addresses older than 30 days to nil. The number should be configurable; 30 is only an example.

It will be purging a lot of data the first time it runs – the initial clean-up may warrant a different approach than the daily task.

Testing

  1. Log in as a user and post a work

  2. Log in as an admin and observe the IP address on the work

  3. Have a database admin run the task

  4. Log in as an admin and make sure the work says "No address recorded"

For bonus fun, log in as the user, edit the work, and then log in as an admin to make sure the IP address appears on the work again.

Assignee

Unassigned

Reporter

Sarken

Roadmap

Works

Priority

High

Affects versions

Fix versions

None

Components

BackEnd

Difficulty

Medium

Required Access Level

Admin

Epic Link

Milestone

Internal 0.9