Table structure problem

[Pieterjan Lansbergen]

I wonder if anybody is willing to help a perfect newbie with this (perhaps simple) problem.

I have tried to checkout a new package for a photoselling web site which I found but loading the tables structure into MySQL database the server returns the following error:

"#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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1' at line 10 "

And here is the first query causing the message

SQL-query :

CREATE TABLE `carts` (

`id` INT( 8 ) NOT NULL AUTO_INCREMENT ,
`visitor_id` VARCHAR( 26 ) NOT NULL DEFAULT '',
`photo_id` VARCHAR( 7 ) NOT NULL DEFAULT '',
`added` VARCHAR( 14 ) NOT NULL DEFAULT '',
`ptype` CHAR( 1 ) NOT NULL DEFAULT '',
`prid` INT( 10 ) NOT NULL DEFAULT '0',
`quantity` INT( 10 ) NOT NULL DEFAULT '1',
UNIQUE KEY `id` ( `id` )
)ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =1

Looks like Engine=MyISAM is the problem.

To the best of your knowledge, is this a problem related to the mysql version running on my host or something else?

Thanking in advance whoever is willing to help.. :-)

/P