Cannot query the database

Debug Mode
File: /var/www/vhosts/web295.c12.hostmaschine.de/Bonsai.bpo-service.de/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 MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 1