delimiter $$

CREATE TABLE `adtracker` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `splay` int(11) DEFAULT NULL,
  `timestamp` decimal(4,2) DEFAULT NULL,
  `affid` varchar(20) DEFAULT NULL,
  `src` varchar(20) DEFAULT NULL,
  `site` varchar(45) DEFAULT NULL,
  `countryCode` varchar(45) DEFAULT NULL,
  `timehour` int(11) DEFAULT NULL,
  `daytimestamp` datetime DEFAULT NULL,
  `adstatus` int(4) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `SITE` (`site`,`timehour`)
) ENGINE=MyISAM AUTO_INCREMENT=17637955 DEFAULT CHARSET=latin1$$