On Fri, Oct 24, 2003 at 11:27:59AM +0200, Ilja Booij wrote: > It also changes all the use of the status field in messages table to > be through the following #defines: > [...] > #define STATUS_DELETE 2 > #define STATUS_PURGE 3
These are a bit confusing because rather than giving a status they describe what action is likely to be taken next on the message. It also doesn't correspond to the dbmail-maintenance documentation, in which status 3 is described as the DELETE status. -p purge messages have the DELETE status set -d set DELETE status for deleted messages The fact that imap has the concept of expunging messages adds further confusion. I suggest changing 2 to DELETED or perhaps EXPUNGED. Status 3 should also be changed from a verb to an adjective. I can't think of a single word description, but something along the lines of PENDING_PURGE makes sense. Personally, I don't see much value to status 3 and would recommend deleting records in status 2 based on an timestamp field in the messages table. xn