Cannot query the database

Debug Mode
File: /mnt/web006/a2/11/57209911/htdocs/Lousana/assets/s2dimysql.php
Line: 107
SLQ: CREATE TABLE IF NOT EXISTS `w2d7_main_affiliate` (`id` varchar(32) NOT NULL,`date` date NOT NULL,`hits` int(11) NOT NULL,PRIMARY KEY (`id`,`date`)) TYPE=MyISAM;
Error: 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' at line 1