>On Fri, July 3, 2009 12:06 pm, Benedict White wrote: >> Is there some more ducumentation on the SQL look ups side of things? >> >> In particular it would be nice to see a diagram making the >> relationship between tables clear. >> >> Also, when an email is quaranteened in sql, are the "to" addresses >> stored in a way that can be easily look up? >> >. >I assume you know the mail_id: > > db2 "select email from maddr > join msgrcpt on maddr.id=msgrcpt.rid > join quarantine on msgrcpt.mail_id = quarantine.mail_id > where quarantine.mail_id='q6T3XSeFPJTz'" > >I'am running amavisd-new on a IBM DB2 backend, so it's DB2 syntax. > >HTH, > Uwe
>> It does, and yes I could pick through all the code looking for the sql, I was just wondering if there was an entity relationship diagram or similar. I am looking to hack together a front end for the mysql bit. Kind Regards Benedict White Tel: 01444 238070 Tech: 01444 238080 Fax: 01444 238099 Web: http://www.cse-ltd.co.uk Registered in England and Wales No: 3066242 27 Victoria Gardens, Burgess Hill, West Sussex, RH15 9NB ------------------------------------------------------------------------------ _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/