On Sat, July 4, 2009 20:50, Michelle Konzack wrote: > Goog evening Jari, > > Am 2009-07-04 13:46:45, schrieb Jari Fredriksson: >> http://wiki.apache.org/spamassassin/BetterDocumentation/SqlReadmeAwl > > Thankyou for the link, but if I understand it right, spamassassin is > then using ONE Database/Table for ALL users... This mean, the Database > will grow more then 10.000 ROW's a day... > > Is in spamassassin something like an autoexpire? > > Most spams I get are with UNIQUE From: header. I allready collect this > infos using procmail recipes... And since 2002 I have collectedt over > 27 million different E-Mails
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 DEFAULT CHARSET=utf8; CREATE TABLE `bayes_seen` ( `id` int(11) NOT NULL default '0', `msgid` varchar(200) character set utf8 collate utf8_bin NOT NULL default '', `flag` char(1) NOT NULL default '', `lastupdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`id`,`msgid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; all the rest expire natively in sa, the above 2 tables can now expire in a cron, how to do this is upto others to deside :) -- xpoint
