CREATE TABLE `archive` (
  `YahooMessageID` int(11) NOT NULL default '0',
  `FromUser` varchar(255) default NULL,
  `FromEmail` varchar(255) default NULL,
  `Subject` varchar(255) default NULL,
  `SubjectSrt` varchar(255) default NULL,
  `RecDate` datetime default NULL,
  `Message` mediumtext,
  `AttCount` int(11) default NULL,
  `NewMsgFlag` tinyint(1) default NULL,
  `DelMsgFlag` tinyint(1) default NULL,
  `FavMsgFlag` tinyint(1) default NULL,
  PRIMARY KEY  (`YahooMessageID`),
  FULLTEXT KEY `IdxMessage` (`Message`),
  FULLTEXT KEY `IdxSubject` (`Subject`)
) TYPE=MyISAM;