
08-27-2007, 03:10 AM
|
|
|
Join Date: Sep 2006
Posts: 205
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
I tried to run the query and here's the error that I've received from phpmyadmin:
Quote:
Error
SQL query:
CREATE TABLE `vbnow` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`itimestamp` int( 11 ) NOT NULL ,
`message` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`url` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`updated` int( 11 ) NOT NULL default '0',
`utimestamp` int( 11 ) NOT NULL ,
`userid` int( 11 ) NOT NULL ,
`views` int( 11 ) NOT NULL ,
`archived` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `id` ) ,
KEY `updated` ( `updated` , `userid` , `url` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =2
MySQL said:
#1064 - 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 'character set utf8 collate utf8_unicode_ci NOT NULL,
`url` v
|
|