perchè quando cerco a creare una tabella di questo tipo mi da i sequenti errori?help


DT localhost
Errore

SQL-inchiesta :

CREATE TABLE `tz_members` (

`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`usr` varchar( 32 ) COLLATE utf8_unicode_ci NOT NULL default '',
`pass` varchar( 32 ) COLLATE utf8_unicode_ci NOT NULL default '',
`email` varchar( 255 ) COLLATE utf8_unicode_ci NOT NULL default '',
`regIP` varchar( 15 ) COLLATE utf8_unicode_ci NOT NULL default '',
`dt` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `usr` ( `usr` )
)ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci

Risposta MySQL:


#1064 - You have an error in your SQL syntax near 'COLLATE utf8_unicode_ci NOT NULL default '',
`pass` varchar( 32 ) COLLATE u' at line 2