Run this sq:
Code:
DROP TABLE IF EXISTS `supertracker`;
CREATE TABLE `supertracker` (
`tracking_id` bigint(32) NOT NULL auto_increment,
`ip_address` varchar(15) NOT NULL default '',
`browser_string` varchar(255) NOT NULL default '',
`country_code` char(2) NOT NULL default '',
`country_name` varchar(100) NOT NULL default '',
`customer_id` int(11) NOT NULL default '0',
`order_id` int(11) NOT NULL default '0',
`referrer` varchar(255) NOT NULL default '',
`referrer_query_string` varchar(255) NOT NULL default '',
`landing_page` varchar(255) NOT NULL default '',
`landing_page_name` varchar(255) NOT NULL,
`exit_page` varchar(255) default NULL,
`exit_page_name` varchar(255) NOT NULL,
`time_arrived` datetime NOT NULL default '0000-00-00 00:00:00',
`last_click` datetime NOT NULL default '0000-00-00 00:00:00',
`num_clicks` int(11) NOT NULL default '1',
`added_cart` varchar(5) NOT NULL default 'false',
`completed_purchase` varchar(5) NOT NULL default 'false',
`categories_viewed` varchar(255) NOT NULL default '',
`products_viewed` varchar(255) NOT NULL default '',
`cart_contents` mediumtext NOT NULL,
`cart_total` int(11) NOT NULL default '0',
PRIMARY KEY (`tracking_id`),
KEY `ip_address` (`ip_address`),
KEY `last_click` (`last_click`),
KEY `customer_id` (`customer_id`),
KEY `browser_string` (`browser_string`),
KEY `cart_total` (`cart_total`)
) ENGINE=MyISAM;
Bookmarks