Къде е грешката при изпълнението на сял

[manq4et0]

DROP TABLE IF EXISTS `highscores`;

CREATE TABLE `highscores` (
  `HighScoreNumber` int(11) NOT NULL auto_increment,
  `TableName` mediumtext NOT NULL,
  `UserNumber` int(11) NOT NULL default '0',
  `QuestionsAnswered` int(11) NOT NULL default '0',
  `QuestionsCorrect` int(11) NOT NULL default '0',
  `CurrentStreak` int(11) NOT NULL default '0',
  `BestStreak` int(11) NOT NULL default '0',
  PRIMARY KEY  (`HighScoreNumber`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

Когато го пусна да се запише в дб-то ми дава грешка

#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=MyISAM AUTO_INCREMENT=1' at line 10

 

[Radko]

DROP TABLE IF EXISTS `highscores`;

CREATE TABLE `highscores` (
  `HighScoreNumber` int(11) NOT NULL auto_increment,
  `TableName` mediumtext NOT NULL,
  `UserNumber` int(11) NOT NULL default '0',
  `QuestionsAnswered` int(11) NOT NULL default '0',
  `QuestionsCorrect` int(11) NOT NULL default '0',
  `CurrentStreak` int(11) NOT NULL default '0',
  `BestStreak` int(11) NOT NULL default '0',
  PRIMARY KEY  (`HighScoreNumber`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

Ето така е правилно, не е TYPE, а ENGINE.