Try:
Code:
CREATE TABLE `tmnt_announcements` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`announcement` text NOT NULL,
`userid` int(10) NOT NULL,
`time` int(10) NOT NULL,
`ip` varchar(50) NOT NULL,
`le_userid` int(10) NOT NULL,
`le_time` int(10) NOT NULL,
`le_ip` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
If that works, you are going to have to do that for all tables created in the modification where the engine type is specified.