[pLog-svn] r5440 - plog/trunk/install

Jon Daley plogworld at jon.limedaley.com
Thu May 24 07:47:26 EDT 2007


 	I'd be in favor of killing this.  It hasn't gotten me in a long 
time, but it is a pain if you don't remember to set date=date in your sql 
query.  It makes sense for the modification_date, and maybe now that we 
are using it, we could put it just for that column.

On Thu, 24 May 2007, Ahmad Saleh wrote:

> why you are update the date field to be CURRENT_TIMESTAMP on each update
> operation on
> lt_articles table?
>
> CREATE TABLE `lt_articles` (
> `id` int(10) unsigned NOT NULL auto_increment,
> `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update
> CURRENT_TIMESTAMP, ...
>
> Regards,
>    Ahmad
>

-- 
Jon Daley
http://jon.limedaley.com/

Don't take life too seriously that you lose the value of it.
-- Dr. Richard Farmer


More information about the pLog-svn mailing list