DEDECMS Import Data USING btree) Engine=myisam DEFAULT charset= Error

Import error prompts the following error

SQL query:

-- --------------------------------------------------------
--
--The structure of the table ' Xjz_purview '
--
CREATE TABLE IF not EXISTS ' Xjz_purview ' (

' Mid ' mediumint (8) DEFAULT ' 0 ',
' typeID ' SMALLINT (5) DEFAULT ' 0 ',
' Rank ' SMALLINT (6) DEFAULT NULL,
' Pkey ' VARCHAR CHARACTER SET latin1 not NULL,
' Pvalue ' TEXT not NULL,
KEY ' Pkey ' (' Pkey ') USING btree
) ENGINE = MYISAM DEFAULT CHARSET = UTF8;

MySQL return:

#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 ' USING btree
) Engine=myisam DEFAULT Charset=utf8 ' at line 7

On the Internet to check the error is said to be KEY ' pkey ' (' Pkey ') using btree This sentence has a problem, I Notepad opened found not to find, and then directly using DW to find and then search and then find the key ' Pkey ' (' Pkey ') using Btree line, first take a look.

And then I found another problem with the import.

#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 ') Engine=myisam DEFAULT C Harset=utf8 ' at line 7

Check again to find the following instructions

Type=myisam and Engine=myisam are all statements that set up the database storage engine
(The old version of MySQL uses type instead of engine (for example, type = MYISAM).
MySQL 5.1 supports this syntax for backward compatibility, but type is now slighted and engine is the first use.
Generally, the ENGINE option is not necessary; MyISAM is the default storage engine unless the default has been changed.

Find the information above, my database is mysql5.5.8, change the type to engine on the OK