CREATE TABLE `mavisce_4ncontact` (
`cfid` int(11) NOT NULL auto_increment,
`username` varchar(100) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`url` varchar(255) default NULL,
`icq` int(11) default NULL,
`organisation` varchar(100) default NULL,
`location` varchar(100) default NULL,
`message` text NOT NULL,
`dateandtime` varchar(50) default NULL,
`adminname` varchar(30) NOT NULL default '',
`httpuseragent` varchar(255) default NULL,
`status` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`cfid`),
UNIQUE KEY `cfid` (`cfid`),
KEY `cfid_2` (`cfid`,`adminname`,`status`)
);