Setting the "Expire" field to "true" or "1" causes SpamFilter to purge that record (and the binary data associated with that email stored in the tblMsg) during the next database cleanup. This by default occurs every 60 minutes, when SpamFilter removes from the database old emails.

Another field of interest is the "Deliver" field. Setting the value to "true" or "1" for a record causes SpamFilter to force the delivery of that email within 5 seconds.

We do not have any official documentation for the database structure, as it is relatively straightforward. The forums will contain a lot of info, and you can always contact our email support to have further answer.

If the "expire" field is set to "1", this marks the message to be deleted the next time SpamFilter performs a database purge. The "purge" removes from the database all messages that are older than your retention period (the "number of days to store quarantine rejected emails" value in the database configuration tab in SpamFilter). The database purge occurs by default every 60 minutes.