Re: Question on add-to-blacklist

[Jari Fredriksson]

> On Tuesday 02 June 2009, Michael Scheidell wrote:
> What "optional" fields are you refering to?
> 
> I have seen this, on the spamassassin WIKI:
> 
> CREATE TABLE awl (
>  username varchar(100) NOT NULL default '',
>  email varchar(200) NOT NULL default '',
>  ip varchar(10) NOT NULL default '',
>  count int(11) default '0',
>  totscore float default '0',
>  PRIMARY KEY  (username,email,ip)
> ) TYPE=MyISAM;
> 
> Is there a better reference?

 CREATE TABLE `awl` (
  `username` varchar(100) NOT NULL DEFAULT '',
  `email` varchar(200) NOT NULL DEFAULT '',
  `ip` varchar(10) NOT NULL DEFAULT '',
  `count` int(11) DEFAULT '0',
  `totscore` float DEFAULT '0',
  `lastupdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE 
CURRENT_TIMESTAMP,
  PRIMARY KEY (`username`,`email`,`ip`)
) ENGINE=InnoDB ;