Hi Diva I basically redid sql statement like you said in the first place. The only thing I didn't do was take out the engine part. Thank You for pointing that out.

I did some reserch on MyISAM vs InnoDB and found out With the release of MySQL 5.5, InnoDB has become the default storage engine so thank you again. This will maybe cause others not to have the error when installing this module.
And thanks for the other 2 links for the sql errors.
Yes you did, but I we decided to remove them just in case others might not have understood what that was for.
Bookmarks