Paolo, > Attempting a self-reply > > Which SQL query would allow me to differentiate quarantine length > > according to content type? > DELETE FROM msgs WHERE time_num < UNIX_TIMESTAMP() - 15*24*60*60 AND > CONTENT = 'V'; > [viruses don't live in quarantine longer than 15 days] > DELETE FROM msgs WHERE time_num < UNIX_TIMESTAMP() - 15*24*60*60 AND > spam_level > 20; > [score > 20 doesn't live in quarantine longer than 15 days] > > Am I missing something? Would these queries achieve what I need? If so, > perhaps they can go in the official docs?
Thanks, makes sense, see the updated: http://www.ijs.si/software/amavisd/README.sql.txt Mark ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
