|
|
Posted by ulyx on 12/13/06 12:12
Thank you for your time and help.
I have read links that u have posted and tryed this:
CREATE TABLE `ae_gallery` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(64) character set utf8 NOT NULL,
`ext` varchar(8) character set utf8 NOT NULL,
`image_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
ON UPDATE CURRENT_TIMESTAMP,
`data` mediumblob NOT NULL,
PRIMARY KEY (`id`)
);
and i get the same error ( i get just #1064 and text description ).
If i remove DEFAULT CURRENT_TIMESTAMP
ON UPDATE CURRENT_TIMESTAMP
everything is working perfect.
How to add/change this field manualy ?
Navigation:
[Reply to this message]
|