MYSQL Create Table Syntax

Schweppesale · #1 (**permalink**) 06-29-09, 10:35

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;

guelphdad · #2 (**permalink**) 06-29-09, 11:49

Nothing incorrect with that syntax. I'd say TEXT is overkill for an IP address field, but other than that the table creates just fine.

how are you trying to create this? via mysql client or a front end application?

Schweppesale · #3 (**permalink**) 06-29-09, 12:00

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.

Schweppesale · #4 (**permalink**) 06-29-09, 15:41

wish there was a way to mark this as solved. Thanks for your help though.

Internet Services

Web Development

Digital Marketing

Consumer Tech