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.

Even better:

    mysql> ALTER TABLE `bayes_seen` ADD `lastupdate` TIMESTAMP DEFAULT 
CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL;