Re: Reduce Bayes DB

[Jari Fredriksson]

> On Mon, June 16, 2008 15:04, furban wrote:
> 
>> Chang the database
>> ALTER TABLE `awl` ADD `lastupdate` TIMESTAMP NOT NULL ;
>> So I thing I can do the same with bayes_seen.
> 
> yes same can be done with bayes_seen, no problem, just
> dont expire one day old seens, i keep 6 month backlogs
> 

What good is that definion (without default value)?

    ALTER TABLE `awl` ADD `lastupdate` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT 
NULL;

It works.