phpmyadmin

[caytre]

Proszę pomóc mi znaleźć błąd, oto cały kod wraz z podpowiedzią miejsca błędu :

Kod: Zaznacz cały

`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`type` ENUM NOT NULL ,
`username` VARCHAR( 30 ) NOT NULL ,
`email` VARCHAR( 80 ) NOT NULL ,
`pass` VARBINARY( 32 ) NOT NULL ,
`first_name` VARCHAR( 30 ) NOT NULL ,
`last_name` VARCHAR( 50 ) NOT NULL ,
`date_expires` DATE NOT NULL ,
`date_created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
`date_modified` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
UNIQUE (
`username` ,
`email`
)
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_polish_ci;

Kod: Zaznacz cały

MySQL zwrócił komunikat:
#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 'NOT NULL, `username` VARCHAR(30) NOT NULL, `email` VARCHAR(80) NOT NULL, `pass` ' at line 1