RE: [AMaViS-user] Store virus names in SQL - feature request

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=20
amavis supports only database systems for this that can work with=20
triggers (e.g. sqlite, mysql >=3D 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
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/...fo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/