Hi all, > Probably the cleanest way would be to provide a separate > SQL table with two fields: mail_id and virus_name, > to let it be JOINed with table msgs.
Cleaner would be to have a table mapping virus_id to virus_name and then having a join table that maps msg_id to virus_ids. Might save a bit of disk space when the OouluuhaguuaVariant3/Win32 breaks out ;) Otoh that requires a bit more management overhead, unless amavis supports only database systems for this that can work with triggers (e.g. sqlite, mysql >= 5, postgres). Regs, Sven ------------------------------------------------------- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf _______________________________________________ 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/
