[Kevorkian]

i receive an error with the second query Errore

query SQL :

CREATE TABLE `banneradmin` (

`event` smallint( 5 ) unsigned NOT NULL auto_increment,
`storehack` SMALLINT( 6 ) DEFAULT0 NOT NULL ,
`storecredit` smallint( 5 ) DEFAULT0 NOT NULL ,
`serverpath` varchar( 100 ) NOT NULL ,
`guestsfromserver` smallint( 5 ) DEFAULT0 NOT NULL ,
`guestsspecial` smallint( 5 ) DEFAULT0 NOT NULL ,
`alttext` varchar( 100 ) NOT NULL ,
`linktext` varchar( 100 ) NOT NULL NOT NULL ,
`bannerimg` varchar( 100 ) NOT NULL NOT NULL ,
`welcometext` mediumtext NOT NULL NOT NULL ,
`guestclicks` smallint( 6 ) DEFAULT0 NOT NULL ,
`membersfromserver` smallint( 5 ) DEFAULT1 NOT NULL ,
`membersspecial` smallint( 5 ) DEFAULT1 NOT NULL ,
`memberalttext` varchar( 100 ) NOT NULL ,
`membersclicks` smallint( 5 ) DEFAULT0 NOT NULL ,
PRIMARY KEY ( `event` )
)

Messaggio di MySQL:

You have an error in your SQL syntax near 'DEFAULT0 NOT NULL , `storecredit` smallint( 5 ) DEFAULT0 NOT NULL , `server' at line 1
Indietro