Hi, I'm trying to create a table, however it seems the syntax is incorrect. Am I missing something obvious?
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;
actually I've just created my first Joomla component. In order to finalize it I need to include a "install.sql" file which create all necessary tables. I continue to receive the following error message though:
Component Install: SQL error or missing or unreadable SQL file. DB function reports no errors
Install Component Error
I was pretty sure that the problem was in the MYSQL statement, however I guess that's not the case.