rendered paste bodypmtext | 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