Add option to track when ($YEAR-$MONTH) a list was "last active"
People told, that they would like to see Schleuder being able to track, when, as in YEAR-
MONTH, a list was "last active", that is, Schleuder handled a mail that was sent to the list by a human, that is, not "automated", either by a subscriber or someone outside. This could be achieved via a new boolean list-option, off by default, and a new date
column last_active
in the lists
database table. If this option would be enabled, Schleuder would update the date, whenever a mail as described before is handled.
-
last_active
is probably not really descriptive, and too generic. Something more specific might make sense. - The database
date
type handles formats such asYYYY-MM-DD
. Tracking onlyYYYY-MM
is probably enough, soDD
could be hardcoded to01
.
The use case would be the following: imagine a provider offering Schleuder list hosting. Lists are regularly created. The assumption is that at least some of them are not in use anymore after a certain amount of time. Some of the lists get abandoned, still, the provider holds PII and private keys. To cleanup such data, the database could then be regularly queried and relevant lists deleted.