Recent Topics

1 Nov 06, 2005 01:38    

Hey... does anyone know the fields needed to create the table evo_hitlog?

My host nuked the table's file and I need to recreate it, but I don't know the fields, much less their types...

--Nick

2 Nov 06, 2005 17:50

Download b2evolution again and you should find the sql code for that table in the install files.

3 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 Nov 06, 2005 23:57

Ah! that worked!

Thanks!

--Nick


Form is loading...