Necesito que me ayuden con mi MySQL

[kani46]

Estoy creando una base de datos y me sale el error:

MySQL ha dicho:

#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 'TYPE = myisam CHARACTER SET utf8 COLLATE utf8_spanish_ci COMMENT = 'clientes'' at line 1

Para que lo puedan ver.

consulta SQL:

CREATE TABLE `clientes` (

`NICK` VARCHAR( 15 ) NOT NULL ,
`CLAVE` INT( 8 ) UNSIGNED NOT NULL ,
`NOMBRE` VARCHAR( 20 ) NOT NULL ,
`APELLIDOS` VARCHAR( 30 ) NOT NULL ,
`DIRECCION` VARCHAR( 40 ) NOT NULL ,
`LOCALIDAD` VARCHAR( 30 ) NOT NULL ,
`CP` MEDIUMINT( 5 ) UNSIGNED NOT NULL ,
`EMAIL` VARCHAR( 50 ) NOT NULL ,
`TELEFONO` BIGINT( 9 ) UNSIGNED NOT NULL ,
PRIMARY KEY ( `NOMBRE` ) ,
UNIQUE (
`NICK`
)
) TYPE = MYISAM CHARACTER SET utf8 COLLATE utf8_spanish_ci COMMENT = 'clientes'