pmtext | CREATE TABLE `pmtext` ( `pmtextid` int(10) unsigned NOT NULL auto_increment, `fromuserid` int(10) unsigned NOT NULL default '0', `fromusername` varchar(100) NOT NULL default '', `title` varchar(250) NOT NULL default '', `message` mediumtext, `touserarray` mediumtext, `iconid` smallint(5) unsigned NOT NULL default '0', `dateline` int(10) unsigned NOT NULL default '0', `showsignature` smallint(5) unsigned NOT NULL default '0', `allowsmilie` smallint(5) unsigned NOT NULL default '1', PRIMARY KEY (`pmtextid`), KEY `fromuserid` (`fromuserid`,`dateline`) ) ENGINE=MyISAM AUTO_INCREMENT=1289 DEFAULT CHARSET=latin1 pm | CREATE TABLE `pm` ( `pmid` int(10) unsigned NOT NULL auto_increment, `pmtextid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `folderid` smallint(6) NOT NULL default '0', `messageread` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`pmid`), KEY `pmtextid` (`pmtextid`), KEY `userid` (`userid`,`folderid`) ) ENGINE=MyISAM AUTO_INCREMENT=2577 DEFAULT CHARSET=latin1