CREATE TABLE `wp_Counterize` (
  `id` int(11) NOT NULL auto_increment,
  `IP` varchar(16) NOT NULL default 'unknown',
  `timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `pageID` int(11) NOT NULL,
  `refererID` int(11) NOT NULL,
  `agentID` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
);


CREATE TABLE `wp_Counterize_Keywords` (
  `keywordID` int(11) NOT NULL auto_increment,
  `keyword` varchar(255) NOT NULL,
  `count` int(11) NOT NULL,
  PRIMARY KEY  (`keywordID`),
  KEY `keyword` (`keyword`)
);

CREATE TABLE `wp_Counterize_Pages` (
  `pageID` int(11) NOT NULL auto_increment,
  `url` varchar(255) NOT NULL,
  `count` int(11) NOT NULL default '1',
  `postID` bigint(20) default NULL,
  PRIMARY KEY  (`pageID`),
  KEY `url` (`url`),
  KEY `count` (`count`)
);


CREATE TABLE `wp_Counterize_Referers` (
  `refererID` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `count` int(11) NOT NULL default '1',
  `keywordID` int(11) NOT NULL,
  PRIMARY KEY  (`refererID`),
  KEY `name` (`name`),
  KEY `count` (`count`)
);


CREATE TABLE `wp_Counterize_UserAgents` (
  `agentID` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `count` int(11) NOT NULL default '1',
  `browserName` varchar(255) NOT NULL,
  `browserCode` varchar(255) NOT NULL,
  `browserVersion` varchar(255) NOT NULL,
  `osName` varchar(255) NOT NULL,
  `osCode` varchar(255) NOT NULL,
  `osVersion` varchar(255) NOT NULL,
  PRIMARY KEY  (`agentID`),
  KEY `name` (`name`),
  KEY `count` (`count`)
);