diamondrajoor

Hi, I'm trying to create a table, however it seems the syntax is incorrect. Am I missing something obvious?

Code:

DROP TABLE IF EXISTS `jos_keyword_stats`; CREATE TABLE `jos_keyword_stats` ( `KeyID` INT NOT NULL , `Date` DATE NOT NULL , `Time` TIME NOT NULL , `Location` MEDIUMTEXT NOT NULL , `UserIP` TEXT NOT NULL , `UserAgent` TEXT NOT NULL , `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ) ENGINE = MYISAM;