|
|
Posted by Norman Peelman on 12/13/06 12:50
"ulyx" <new_one@hotmail.com> wrote in message
news:eloqn9$ad5$1@ss408.t-com.hr...
> 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 ?
>
>
Have you tried:
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 ON UPDATE CURRENT_TIMESTAMP,
`data` MEDIUMBLOB,
PRIMARY KEY (`id`)
);
Norm
--
FREE Avatar hosting at www.easyavatar.com
Navigation:
[Reply to this message]
|