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.
Log in as a user and post a work
Log in as an admin and observe the IP address on the work
Have a database admin run the task
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.