[WildcardX]

It is the table create SQL statement that determines what storage engine MySQL will use for a given table. For example:

CREATE TABLE  `pets` (
  `type` varchar(64) NOT NULL default '',
  `npcID` int(11) NOT NULL default '0',
  `temp` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Notice the "Engine=" statement? That requests a particular storage engine from MySQL. In MySQL 4.1 or older, you will see a "TYPE=" statement instead of "ENGINE=". MySQL deprecated the "TYPE" keyword in MySQL 5.0.