|
Mysql Question
I'm trying to re-import a mysql dump, however it keeps giving me errors at this particular table:
CREATE TABLE `phpads_images` (
`filename` varchar(128) NOT NULL default '',
`contents` mediumblob NOT NULL,
`t_stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`filename`)
) ENGINE=INNODB DEFAULT CHARSET=latin1;
The error I'm receiving is:
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'defaultCURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY "
Anybody have any ideas?
Cheers
|