Re: [AMaViS-user] SQL question

2009-07-24 Thread Benedict White
Message: 6 Date: Fri, 24 Jul 2009 09:09:23 -0500 From: Luis Daniel Lucio Quiroz Subject: Re: [AMaViS-user] SQL question To: amavis-user@lists.sourceforge.net Message-ID: <200907240909.23376.luis.daniel.lu...@gmail.com> Content-Type: Text/Plain; charset="

Re: [AMaViS-user] SQL question

2009-07-24 Thread Luis Daniel Lucio Quiroz
Le vendredi 24 juillet 2009 03:44:54, Benedict White a écrit : > > 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/ > > >

Re: [AMaViS-user] SQL question

2009-07-24 Thread Mikael Bak
Luis Daniel Lucio Quiroz wrote: > > Hi Benedic, > > I've done a diagraman with all Amavisd Relationships as far as I know. > > Where I can send it? > Hi, Maybe you have the possibility to put in online somewhere? Mikael ---

Re: [AMaViS-user] SQL question

2009-07-24 Thread Benedict White
> 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/ >Hi Benedic, > >I've done a diagraman with all Amavisd Relationships as far as

Re: [AMaViS-user] SQL question

2009-07-23 Thread Luis Daniel Lucio Quiroz
Le vendredi 3 juillet 2009 05:06:25, Benedict White a écrit : > 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" addre

Re: [AMaViS-user] SQL question

2009-07-06 Thread Mark Martinec
> Is there some more documentation on the SQL look ups side of things? README.lookups, search for "SQL". The SQL clause is user-configurable, the default for $sql_clause{sel_policy} is a: SELECT *,users.id'. FROM users LEFT JOIN policy ON users.policy_id=policy.id WHERE users.email IN (%k) ORD

Re: [AMaViS-user] SQL question

2009-07-06 Thread Uwe Kiewel
On Mon, July 6, 2009 11:17 am, Benedict White wrote: > > Uwe Kiewel schrieb: >>> Benedict White schrieb: 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. >>> >>> ftp://centos.kiewel-on

Re: [AMaViS-user] SQL question

2009-07-06 Thread Benedict White
Uwe Kiewel schrieb: >> Benedict White schrieb: >>> 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. >> >> ftp://centos.kiewel-online.ch/pub/amavisd-new/er-amavisd-new.jpeg > >jpeg deleted >

Re: [AMaViS-user] SQL question

2009-07-04 Thread Uwe Kiewel
Uwe Kiewel schrieb: > Benedict White schrieb: >> 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. > > ftp://centos.kiewel-online.ch/pub/amavisd-new/er-amavisd-new.jpeg jpeg deleted gif adde

Re: [AMaViS-user] SQL question

2009-07-03 Thread Uwe Kiewel
Benedict White schrieb: > 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. ftp://centos.kiewel-online.ch/pub/amavisd-new/er-amavisd-new.jpeg Have fun! Uwe -

Re: [AMaViS-user] SQL question

2009-07-03 Thread Uwe Kiewel
Benedict White schrieb: >> 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 q

Re: [AMaViS-user] SQL question

2009-07-03 Thread Benedict White
>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" addres

Re: [AMaViS-user] SQL question

2009-07-03 Thread Uwe Kiewel
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 stor

[AMaViS-user] SQL question

2009-07-03 Thread Benedict White
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? Kind Regards Benedi