Mine

-- ---------------------------------------------------------- -- Table structure for table `click_views`-- CREATE TABLE `click_views` (  `id` int(11) NOT NULL auto_increment,  `ip` varchar(16) collate utf8_unicode_ci default NULL,  `af_id` int(11) NOT NULL default '0',  `campaign_id` int(11) NOT NULL default '0',  `url_id` int(11) default NULL,  `date` datetime NOT NULL default '0000-00-00 00:00:00',  `banner_id` mediumint(9) NOT NULL default '0',  `planID` mediumint(9) NOT NULL default '0',  `view_type` enum('v','c') collate utf8_unicode_ci NOT NULL default 'v',  `site_id` tinyint(4) NOT NULL default '0',  `redirect_id` int(11) NOT NULL default '0',  PRIMARY KEY  (`id`),  KEY `redirect_id` (`redirect_id`),  KEY `ip` (`ip`),  KEY `site_id` (`site_id`),  KEY `campaign_id` (`campaign_id`),  KEY `view_type` (`view_type`),  KEY `date` (`date`),  KEY `af_id` (`af_id`)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12123842 ;-- ---------------------------------------------------------- -- Table structure for table `payouts`-- CREATE TABLE `payouts` (  `id` bigint(20) NOT NULL auto_increment,  `af_id` bigint(20) default '0',  `plan_id` bigint(20) default '4',  `date` datetime NOT NULL default '0000-00-00 00:00:00',  `site_id` int(5) NOT NULL default '0',  `mt_reference_number` varchar(20) collate utf8_unicode_ci default NULL,  `payout_amount` float default '0',  `ip` varchar(18) collate utf8_unicode_ci default '0',  `revenue` float default '0',  `subscription_id` bigint(20) default NULL,  `click_views_id` bigint(15) default NULL,  `sub_afil` int(8) default NULL,  `is_rebill` enum('TRUE','FALSE') collate utf8_unicode_ci NOT NULL default 'FALSE',  `is_free` enum('TRUE','FALSE') collate utf8_unicode_ci NOT NULL default 'FALSE',  `memberID` int(10) default '0',  PRIMARY KEY  (`id`),  UNIQUE KEY `mt_reference_number` (`mt_reference_number`),  KEY `af_id` (`af_id`,`date`,`site_id`),  KEY `ip` (`ip`),  KEY ` subscription_id` (`subscription_id`),  KEY `click_views_id` (`click_views_id`),  KEY `sub_afil` (`sub_afil`)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7011 ;