#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=InnoDB'

[Ryan Ward]

Hello All, Recently tried to most to a new hosting service for an old database, and well I set up the mysql database 4.1 and uploaded the imported old database.

I then recieved this error:

Error
SQL query:

CREATE TABLE race_skill_bonus(

race_id INTEGER NOT NULL ,
skill_category VARCHAR( 15 ) NOT NULL ,
skill_bonus_amount TINYINT UNSIGNED NOT NULL ,
INDEX ( race_id ) ,
FOREIGN KEY ( race_id ) REFERENCES races( race_id ) ,
PRIMARY KEY ( race_id, skill_category ) ,

) TYPE = InnoDB;



MySQL said:

#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=InnoDB' at line 9


Any clue why this is coming up?