MySQL syntax error when importing from mysql_db_struct.sql

[Migrated From Jforum.net]

I've received this same error using the installation wizard, attempting a manual import via SQLyog and through the MySQL CLI. The error is as follows follows:

Query:
CREATE TABLE jforum_banlist (
banlist_id INT NOT NULL auto_increment,
user_id INT,
banlist_ip varchar(15),
banlist_email varchar(255),
PRIMARY KEY (banlist_id),
INDEX idx_user (user_id),
INDEX (banlist_ip),
INDEX (banlist_email)
) TYPE=InnoDB

Error occured at:2008-01-14 13:47:14
Line no.:14
Error Code: 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 10

MySQL v5.1

I'm somewhat of a SQL newbie, but I don't see any syntax errors here.

Any help or insight would be much appreciated. Thanks!
[originally posted on jforum.net by evelmike]

[Migrated From Jforum.net]

After a bit of digging and help from the guys over at mysql.com, I found that TYPE was a synonym for ENGINE as of MySQL 5.0, but that support appears to have been dropped in MySQL 5.1.

heh, easy fix. Replace TYPE with ENGINE. ;)
[originally posted on jforum.net by evelmike]