-- --------------------------------------------------------

-- 
-- 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 ;