CREATE TABLE IF NOT EXISTS `visitormessage` (
  `vmid` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `postuserid` int(10) unsigned NOT NULL default '0',
  `postusername` varchar(100) collate latin1_general_ci NOT NULL default '',
  `dateline` int(10) unsigned NOT NULL default '0',
  `state` enum('visible','moderation','deleted') collate latin1_general_ci NOT NULL default 'visible',
  `title` varchar(255) collate latin1_general_ci NOT NULL default '',
  `pagetext` mediumtext collate latin1_general_ci,
  `ipaddress` int(10) unsigned NOT NULL default '0',
  `allowsmilie` smallint(5) unsigned NOT NULL default '0',
  `reportthreadid` int(10) unsigned NOT NULL default '0',
  `messageread` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`vmid`),
  KEY `postuserid` (`postuserid`,`userid`,`state`),
  KEY `userid` (`userid`,`dateline`,`state`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;