Quote:
Originally Posted by dede1
No this error:
Error
SQL-Befehl :
CREATE TABLE " . TABLE_PREFIX . "vbgarage_images(
`vbgarageid` smallint( 6 ) unsigned NOT NULL AUTO_INCREMENT ,
`userid` int( 10 ) unsigned NOT NULL default '0',
`name` varchar( 50 ) NOT NULL default '',
`data` longblob NOT NULL ,
`type` varchar( 50 ) NOT NULL default '',
PRIMARY KEY ( `vbgarageid` )
) TYPE = MYISAM AUTO_INCREMENT = 1
MySQL meldet:
#1064 - You have an error in your SQL syntax near '" . TABLE_PREFIX . "vbgarage_images( `vbgarageid` smallint( 6 ) unsigned NOT ' at line 1
|
Errr.. if you're running this in phpmyadmin, or from mysqladmin, etc.. remove the " . TABLE_PREFIX . "
[SQL]
CREATE TABLE vbgarage_images (
`vbgarageid` smallint(6) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
`data` longblob NOT NULL,
`type` varchar(50) NOT NULL default '',
PRIMARY KEY (`vbgarageid`)
) TYPE=MyISAM AUTO_INCREMENT=1;
[/SQL]