What tables to create for using SQL capability of MailScanner conf.

[Jeremy McSpadden]

Try looking at mailwatch ... Maybe their SQL will point you in the right direction. 


--
Jeremy McSpadden

On Mar 28, 2012, at 5:43 AM, "Tomáš Kurinec" <tomb.stoney at gmail.com> wrote:

> Hi all,
> 
> I'm trying to use mailscanner sql configuration capabilities mainly
> for custom rulesets and spamassassin, but I can't find out how should
> the tables looks like.
> Could you be so kind and provide me SQL like this:
> CREATE TABLE mailscanner_config (
>  id int(11) NOT NULL auto_increment,
>  hostname varchar(100) NOT NULL,
>  value varchar(100) NOT NULL,
>  external varchar(100) NOT NULL,
>  options varchar(100) NOT NULL,
>  PRIMARY KEY (id)
> ) ENGINE=MyISAM
> 
> I don't know if this is a good table for such a purpose, but you
> probably get the idea.
> 
> Thank you very much!
> 
> Tom
> -- 
> MailScanner mailing list
> mailscanner at lists.mailscanner.info
> http://lists.mailscanner.info/mailman/listinfo/mailscanner
> 
> Before posting, read http://wiki.mailscanner.info/posting
> 
> Support MailScanner development - buy the book off the website! 
>