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
------------------------------------------------------------------------------
_______________________________________________
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/
