Hi,

I was recently forced to go back to 4.0 and I'm having a problem with a
timestamp column that gets updated whenever the row gets modified. I
want the timestamp to only carry the value for when the row is created
in the db here is my current table creation statement:

CREATE TABLE `wall_data` (
`id` int(11) NOT NULL auto_increment,
`origin` varchar(60) default NULL,
`poster` varchar(60) default NULL,
`votes` varchar(60) default '0',
`message` varchar(140) default NULL,
`posted` timestamp default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;

Thanks!

Dan