1 wakarimasu Nov 06, 2005 01:38
3 the_engineer Nov 06, 2005 17:53
This should do it
CREATE TABLE `evo_hitlog` (
`visitID` bigint(11) NOT NULL auto_increment,
`visitTime` timestamp(14) NOT NULL,
`visitURL` varchar(250) default NULL,
`hit_ignore` enum('no','invalid','badchar','blacklist','rss','robot','search') NOT NULL default 'no',
`referingURL` varchar(250) default NULL,
`baseDomain` varchar(250) default NULL,
`hit_blog_ID` int(11) NOT NULL default '0',
`hit_remote_addr` varchar(40) default NULL,
`hit_user_agent` varchar(250) default NULL,
PRIMARY KEY (`visitID`),
KEY `hit_ignore` (`hit_ignore`),
KEY `baseDomain` (`baseDomain`),
KEY `hit_blog_ID` (`hit_blog_ID`),
KEY `hit_user_agent` (`hit_user_agent`)
) TYPE=MyISAM AUTO_INCREMENT=6320 ;
Jon
4 wakarimasu Nov 06, 2005 23:57
Ah! that worked!
Thanks!
--Nick
Download b2evolution again and you should find the sql code for that table in the install files.