Query Problem

[adriandaz]

Please can someone tell me whats wrong with this:

CREATE TABLE tmplt_users (
index bigint(20) NOT NULL auto_increment,
email text NOT NULL,
name text NOT NULL,
PRIMARY KEY (index)
) TYPE=MyISAM;

I get this error:

MySQL said:

You have an error in your SQL syntax near 'bigint(20) NOT NULL auto_increment,

email text NOT NULL,

name text NOT NUL' at line 2

:bored: