EVOLUTION-NINJA

Edit File: ppv.sql

-- phpMyAdmin SQL Dump
-- version 3.1.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 07, 2011 at 09:42 AM
-- Server version: 5.1.32
-- PHP Version: 5.2.9-1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `ppv`
--

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

--
-- Table structure for table `file_details`
--

CREATE TABLE IF NOT EXISTS `file_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `path` varchar(300) NOT NULL,
  `filename` varchar(200) NOT NULL,
  `size` varchar(200) NOT NULL,
  `version` varchar(100) NOT NULL,
  `uploadtime` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `file_details`
--

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

--
-- Table structure for table `pd_aff_campaigns`
--

CREATE TABLE IF NOT EXISTS `pd_aff_campaigns` (
  `aff_campaign_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `aff_campaign_id_public` int(10) unsigned NOT NULL,
  `user_id` mediumint(8) unsigned NOT NULL,
  `aff_network_id` mediumint(8) unsigned NOT NULL,
  `aff_campaign_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `aff_campaign_name` varchar(50) NOT NULL,
  `aff_campaign_url` text NOT NULL,
  `aff_campaign_url_2` text NOT NULL,
  `aff_campaign_url_3` text NOT NULL,
  `aff_campaign_url_4` text NOT NULL,
  `aff_campaign_url_5` text NOT NULL,
  `aff_campaign_payout` decimal(5,2) NOT NULL,
  `aff_campaign_cloaking` tinyint(1) NOT NULL DEFAULT '0',
  `aff_campaign_time` int(10) unsigned NOT NULL,
  `aff_campaign_rotate` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`aff_campaign_id`),
  KEY `aff_network_id` (`aff_network_id`),
  KEY `aff_campaign_deleted` (`aff_campaign_deleted`),
  KEY `user_id` (`user_id`),
  KEY `aff_campaign_name` (`aff_campaign_name`(5)),
  KEY `aff_campaign_id_public` (`aff_campaign_id_public`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_aff_campaigns`
--

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

--
-- Table structure for table `pd_aff_networks`
--

CREATE TABLE IF NOT EXISTS `pd_aff_networks` (
  `aff_network_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` mediumint(8) unsigned NOT NULL,
  `niche_id` int(10) NOT NULL,
  `aff_network_name` varchar(50) NOT NULL,
  `aff_network_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `aff_network_time` int(10) unsigned NOT NULL,
  PRIMARY KEY (`aff_network_id`),
  KEY `user_id` (`user_id`),
  KEY `aff_network_deleted` (`aff_network_deleted`),
  KEY `aff_network_name` (`aff_network_name`(5))
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_aff_networks`
--

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

--
-- Table structure for table `pd_browsers`
--

CREATE TABLE IF NOT EXISTS `pd_browsers` (
  `browser_id` tinyint(1) unsigned NOT NULL AUTO_INCREMENT,
  `browser_name` varchar(50) NOT NULL,
  PRIMARY KEY (`browser_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_browsers`
--

INSERT INTO `pd_browsers` (`browser_id`, `browser_name`) VALUES
(1, 'Internet Explorer'),
(2, 'Firefox'),
(3, 'Konqueror'),
(4, 'Netscape'),
(5, 'OmniWeb'),
(6, 'Opera'),
(7, 'Safari'),
(8, 'AOL'),
(9, 'Chrome'),
(10, 'Mobile'),
(11, 'Console');

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

--
-- Table structure for table `pd_camp_overview`
--

CREATE TABLE IF NOT EXISTS `pd_camp_overview` (
  `camp_overview_id` int(11) NOT NULL AUTO_INCREMENT,
  `aff_campaign_name` varchar(30) NOT NULL,
  `niche_id` int(11) NOT NULL,
  `aff_network_id` int(11) NOT NULL,
  `ppv_network_id` int(11) NOT NULL,
  `cost_per_view` varchar(25) NOT NULL,
  `target` int(11) NOT NULL DEFAULT '1',
  `aff_campaign_payout` varchar(25) NOT NULL,
  `aff_campaign_cloaking` varchar(25) NOT NULL,
  `method_of_promotion` varchar(20) NOT NULL,
  `aff_campaign_url` varchar(200) NOT NULL,
  `offer1` int(30) NOT NULL,
  `offer2` int(11) NOT NULL,
  `offer3` int(11) NOT NULL,
  `ppv_account_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `rotate_offers` varchar(25) NOT NULL,
  `landing_pg_id` int(11) NOT NULL,
  `id_track` int(11) NOT NULL,
  `camp_status` int(11) NOT NULL DEFAULT '1',
  `rotate_land` varchar(20) NOT NULL,
  `land1` int(11) NOT NULL,
  `land2` int(11) NOT NULL,
  `land3` int(11) NOT NULL,
  `lock_land` INT NOT NULL,
  PRIMARY KEY (`camp_overview_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_camp_overview`
--

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

--
-- Table structure for table `pd_charts`
--

CREATE TABLE IF NOT EXISTS `pd_charts` (
  `chart_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `chart_xml` mediumtext NOT NULL,
  PRIMARY KEY (`chart_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_charts`
--

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

--
-- Table structure for table `pd_clicks`
--

CREATE TABLE IF NOT EXISTS `pd_clicks` (
  `click_id` bigint(20) unsigned NOT NULL,
  `user_id` mediumint(8) unsigned NOT NULL,
  `aff_campaign_id` mediumint(8) unsigned NOT NULL,
  `landing_page_id` mediumint(8) unsigned NOT NULL,
  `ppv_account_id` mediumint(8) unsigned NOT NULL,
  `click_cpc` decimal(7,5) NOT NULL,
  `click_payout` decimal(6,2) NOT NULL,
  `click_lead` tinyint(1) NOT NULL DEFAULT '0',
  `click_filtered` tinyint(1) NOT NULL DEFAULT '0',
  `click_alp` tinyint(1) NOT NULL DEFAULT '0',
  `click_time` int(10) unsigned NOT NULL,
  `trackers_id` varchar(100) NOT NULL,
  `payout` varchar(100) NOT NULL DEFAULT '0',
  `offer_id` int(11) NOT NULL,
  KEY `aff_campaign_id` (`aff_campaign_id`),
  KEY `ppc_account_id` (`ppv_account_id`),
  KEY `click_lead` (`click_lead`),
  KEY `click_filtered` (`click_filtered`),
  KEY `click_id` (`click_id`),
  KEY `overview_index` (`user_id`,`click_filtered`,`aff_campaign_id`,`ppv_account_id`),
  KEY `user_id` (`user_id`,`click_lead`),
  KEY `click_alp` (`click_alp`),
  KEY `landing_page_id` (`landing_page_id`),
  KEY `overview_index2` (`user_id`,`click_filtered`,`landing_page_id`,`aff_campaign_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_clicks`
--

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

--
-- Table structure for table `pd_clicks_advance`
--

CREATE TABLE IF NOT EXISTS `pd_clicks_advance` (
  `click_id` bigint(20) unsigned NOT NULL,
  `text_ad_id` mediumint(8) unsigned NOT NULL,
  `keyword_id` bigint(20) unsigned NOT NULL,
  `ip_id` bigint(20) unsigned NOT NULL,
  `platform_id` tinyint(1) unsigned NOT NULL,
  `browser_id` tinyint(1) unsigned NOT NULL,
  PRIMARY KEY (`click_id`),
  KEY `text_ad_id` (`text_ad_id`),
  KEY `keyword_id` (`keyword_id`),
  KEY `ip_id` (`ip_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_clicks_advance`
--

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

--
-- Table structure for table `pd_clicks_counter`
--

CREATE TABLE IF NOT EXISTS `pd_clicks_counter` (
  `click_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`click_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_clicks_counter`
--

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

--
-- Table structure for table `pd_clicks_record`
--

CREATE TABLE IF NOT EXISTS `pd_clicks_record` (
  `click_id` bigint(20) unsigned NOT NULL,
  `click_id_public` bigint(20) unsigned NOT NULL,
  `click_cloaking` tinyint(1) NOT NULL DEFAULT '0',
  `click_in` tinyint(1) NOT NULL DEFAULT '0',
  `click_out` tinyint(1) NOT NULL DEFAULT '0',
  `click_reviewed` tinyint(1) NOT NULL DEFAULT '0',
  `land_id` int(11) NOT NULL,
  `offer_id` int(11) NOT NULL,
  KEY `click_id_public` (`click_id_public`),
  KEY `click_in` (`click_in`),
  KEY `click_out` (`click_out`),
  KEY `click_cloak` (`click_cloaking`),
  KEY `click_reviewed` (`click_reviewed`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_clicks_record`
--

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

--
-- Table structure for table `pd_clicks_site`
--

CREATE TABLE IF NOT EXISTS `pd_clicks_site` (
  `click_id` bigint(20) unsigned NOT NULL,
  `click_referer_site_url_id` bigint(20) unsigned NOT NULL,
  `click_landing_site_url_id` bigint(20) unsigned NOT NULL,
  `click_outbound_site_url_id` bigint(20) unsigned NOT NULL,
  `click_cloaking_site_url_id` bigint(20) unsigned NOT NULL,
  `click_redirect_site_url_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`click_id`),
  KEY `click_referer_site_url_id` (`click_referer_site_url_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_clicks_site`
--

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

--
-- Table structure for table `pd_get_links`
--

CREATE TABLE IF NOT EXISTS `pd_get_links` (
  `user_id` int(11) NOT NULL,
  `get_links_id` int(11) NOT NULL AUTO_INCREMENT,
  `tracker_type` int(11) NOT NULL,
  `affiliate_network` int(11) NOT NULL,
  `campaign` int(11) NOT NULL,
  `landing_page` int(11) NOT NULL,
  `ad_copy` varchar(20) NOT NULL,
  `ad_preview` varchar(20) NOT NULL,
  `cloaking` varchar(20) NOT NULL,
  `ppc_network` varchar(20) NOT NULL,
  `ppc_account` varchar(20) NOT NULL,
  `cpc_dollars` int(11) NOT NULL,
  `cpc_cents` int(11) NOT NULL,
  `tracking_id_c1` varchar(20) NOT NULL,
  `tracking_id_c2` varchar(20) NOT NULL,
  `tracking_id_c3` varchar(20) NOT NULL,
  `tracking_id_c4` varchar(20) NOT NULL,
  PRIMARY KEY (`get_links_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_get_links`
--

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

--
-- Table structure for table `pd_ips`
--

CREATE TABLE IF NOT EXISTS `pd_ips` (
  `ip_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ip_address` varchar(15) NOT NULL,
  `location_id` mediumint(8) unsigned NOT NULL,
  PRIMARY KEY (`ip_id`),
  KEY `ip_address` (`ip_address`),
  KEY `location_id` (`location_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_ips`
--

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

--
-- Table structure for table `pd_keywords`
--

CREATE TABLE IF NOT EXISTS `pd_keywords` (
  `keyword_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `keyword` varchar(50) NOT NULL,
  PRIMARY KEY (`keyword_id`),
  KEY `keyword` (`keyword`(10))
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_keywords`
--

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

--
-- Table structure for table `pd_land`
--

CREATE TABLE IF NOT EXISTS `pd_land` (
  `land_id` int(11) NOT NULL AUTO_INCREMENT,
  `landing_page_name` varchar(30) NOT NULL,
  `landing_page_type` varchar(25) NOT NULL,
  `niche` int(30) NOT NULL,
  `landing_url` varchar(500) NOT NULL,
  `user_id` int(11) NOT NULL,
  `destination_url` varchar(500) NOT NULL,
  `id_track` int(11) NOT NULL,
  `landing_page_id_public` int(11) NOT NULL,
  `landing_page_time` int(20) NOT NULL,
  `script_url` varchar(500) NOT NULL,
  PRIMARY KEY (`land_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_land`
--

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

--
-- Table structure for table `pd_landing_pages`
--

CREATE TABLE IF NOT EXISTS `pd_landing_pages` (
  `landing_page_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` mediumint(8) unsigned NOT NULL,
  `landing_page_id_public` int(10) unsigned NOT NULL,
  `aff_campaign_id` mediumint(8) unsigned NOT NULL,
  `aff_network_id` int(11) NOT NULL,
  `landing_page_nickname` varchar(50) NOT NULL,
  `landing_page_url` varchar(255) NOT NULL,
  `landing_page_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `landing_page_time` int(10) unsigned NOT NULL,
  `landing_page_type` tinyint(1) NOT NULL DEFAULT '0',
  `niche_id` int(11) NOT NULL,
  PRIMARY KEY (`landing_page_id`),
  KEY `landing_page_id_public` (`landing_page_id_public`),
  KEY `aff_campaign_id` (`aff_campaign_id`),
  KEY `landing_page_deleted` (`landing_page_deleted`),
  KEY `user_id` (`user_id`),
  KEY `landing_page_type` (`landing_page_type`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_landing_pages`
--

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

--
-- Table structure for table `pd_land_track`
--

CREATE TABLE IF NOT EXISTS `pd_land_track` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `land_id` int(11) NOT NULL,
  `track_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_land_track`
--

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

--
-- Table structure for table `pd_last_ips`
--

CREATE TABLE IF NOT EXISTS `pd_last_ips` (
  `user_id` mediumint(9) NOT NULL,
  `ip_id` bigint(20) NOT NULL,
  `time` int(10) unsigned NOT NULL,
  KEY `ip_index` (`user_id`,`ip_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_last_ips`
--

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

--
-- Table structure for table `pd_logo_status`
--

CREATE TABLE IF NOT EXISTS `pd_logo_status` (
  `id` int(10) NOT NULL,
  `hide_logo` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_logo_status`
--

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

--
-- Table structure for table `pd_niche`
--

CREATE TABLE IF NOT EXISTS `pd_niche` (
  `niche_id` int(10) NOT NULL AUTO_INCREMENT,
  `niche_name` varchar(100) NOT NULL,
  `user_id` int(10) NOT NULL,
  `aff_campaign_id` int(10) NOT NULL,
  PRIMARY KEY (`niche_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_niche`
--

INSERT INTO `pd_niche` (`niche_id`, `niche_name`, `user_id`, `aff_campaign_id`) VALUES
(1, 'Biz Ops', 1, 0),
(2, 'Health', 1, 0),
(3, 'Financial', 1, 0),
(4, 'Insurance', 1, 0),
(5, 'Dating', 1, 0),
(6, 'Beauty', 1, 0),
(7, 'Real Estate', 1, 0),
(8, 'Weight Loss', 1, 0),
(9, 'Legal', 1, 0),
(10, 'Fitness', 1, 0),
(11, 'Electronics', 1, 0),
(12, 'Gaming', 1, 0),
(13, 'Holidays', 1, 0),
(14, 'Gambling', 1, 0),
(15, 'Credit / Debit', 1, 0);

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

--
-- Table structure for table `pd_offers`
--

CREATE TABLE IF NOT EXISTS `pd_offers` (
  `offer_id` int(10) NOT NULL AUTO_INCREMENT,
  `offer_name` varchar(100) NOT NULL,
  `aff_network_id` int(10) NOT NULL,
  `offer_link` varchar(500) NOT NULL,
  `payout` varchar(100) NOT NULL,
  `pays_on` varchar(100) NOT NULL,
  `niche_id` int(10) NOT NULL,
  `user_id` int(10) NOT NULL,
  PRIMARY KEY (`offer_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_offers`
--

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

--
-- Table structure for table `pd_platforms`
--

CREATE TABLE IF NOT EXISTS `pd_platforms` (
  `platform_id` tinyint(1) unsigned NOT NULL AUTO_INCREMENT,
  `platform_name` varchar(50) NOT NULL,
  PRIMARY KEY (`platform_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
INSERT INTO `pd_platforms` (`platform_id`, `platform_name`) VALUES
(1, 'Windows'),
(2, 'Macintosh'),
(3, 'Linux'),
(4, 'OS/2'),
(5, 'BeOS');

--
-- Dumping data for table `pd_platforms`
--

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

--
-- Table structure for table `pd_ppv_accounts`
--

CREATE TABLE IF NOT EXISTS `pd_ppv_accounts` (
  `ppv_account_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` mediumint(8) unsigned NOT NULL,
  `ppv_network_id` mediumint(8) unsigned NOT NULL,
  `ppv_account_name` varchar(50) NOT NULL,
  `ppv_account_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `ppv_account_time` int(10) unsigned NOT NULL,
  `aff_campaign_id` int(11) NOT NULL,
  `niche_id` int(11) NOT NULL,
  `keyword` varchar(100) NOT NULL,
  `keyword_check` int(11) NOT NULL,
  PRIMARY KEY (`ppv_account_id`),
  KEY `ppc_network_id` (`ppv_network_id`),
  KEY `ppc_account_deleted` (`ppv_account_deleted`),
  KEY `user_id` (`user_id`),
  KEY `ppc_account_name` (`ppv_account_name`(5))
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `pd_ppv_networks`
--

CREATE TABLE IF NOT EXISTS `pd_ppv_networks` (
  `ppv_network_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` mediumint(8) unsigned NOT NULL,
  `aff_campaign_id` int(10) NOT NULL,
  `ppv_network_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `ppv_network_name` varchar(50) NOT NULL,
  `ppv_network_time` int(10) unsigned NOT NULL,
  `niche_id` int(11) NOT NULL,
  PRIMARY KEY (`ppv_network_id`),
  KEY `user_id` (`user_id`),
  KEY `ppc_network_deleted` (`ppv_network_deleted`),
  KEY `ppc_network_name` (`ppv_network_name`(5))
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `pd_sample_lp`
--

CREATE TABLE IF NOT EXISTS `pd_sample_lp` (
  `lp_id` int(10) NOT NULL AUTO_INCREMENT,
  `lp_name` varchar(100) NOT NULL,
  `lp_code` text NOT NULL,
  PRIMARY KEY (`lp_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_sample_lp`
--

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

--
-- Table structure for table `pd_site_domains`
--

CREATE TABLE IF NOT EXISTS `pd_site_domains` (
  `site_domain_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `site_domain_host` varchar(100) NOT NULL,
  PRIMARY KEY (`site_domain_id`),
  KEY `site_domain_host` (`site_domain_host`(10))
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_site_domains`
--

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

--
-- Table structure for table `pd_site_urls`
--

CREATE TABLE IF NOT EXISTS `pd_site_urls` (
  `site_url_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `site_domain_id` bigint(20) unsigned NOT NULL,
  `site_url_address` text NOT NULL,
  PRIMARY KEY (`site_url_id`),
  KEY `site_domain_id` (`site_domain_id`),
  KEY `site_url_address` (`site_url_address`(75))
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_site_urls`
--

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

--
-- Table structure for table `pd_sort_breakdowns`
--

CREATE TABLE IF NOT EXISTS `pd_sort_breakdowns` (
  `sort_breakdown_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sort_breakdown_from` int(10) unsigned NOT NULL,
  `sort_breakdown_to` int(10) unsigned NOT NULL,
  `user_id` mediumint(8) unsigned NOT NULL,
  `sort_breakdown_clicks` mediumint(8) unsigned NOT NULL,
  `sort_breakdown_leads` mediumint(8) unsigned NOT NULL,
  `sort_breakdown_su_ratio` decimal(10,2) NOT NULL,
  `sort_breakdown_payout` decimal(6,2) NOT NULL,
  `sort_breakdown_epc` decimal(10,2) NOT NULL,
  `sort_breakdown_avg_cpc` decimal(7,5) NOT NULL,
  `sort_breakdown_income` decimal(10,2) NOT NULL,
  `sort_breakdown_cost` decimal(13,5) NOT NULL,
  `sort_breakdown_net` decimal(13,5) NOT NULL,
  `sort_breakdown_roi` decimal(10,2) NOT NULL,
  PRIMARY KEY (`sort_breakdown_id`),
  KEY `user_id` (`user_id`),
  KEY `sort_keyword_clicks` (`sort_breakdown_clicks`),
  KEY `sort_keyword_leads` (`sort_breakdown_leads`),
  KEY `sort_keyword_signup_ratio` (`sort_breakdown_su_ratio`),
  KEY `sort_keyword_payout` (`sort_breakdown_payout`),
  KEY `sort_keyword_epc` (`sort_breakdown_epc`),
  KEY `sort_keyword_cpc` (`sort_breakdown_avg_cpc`),
  KEY `sort_keyword_income` (`sort_breakdown_income`),
  KEY `sort_keyword_cost` (`sort_breakdown_cost`),
  KEY `sort_keyword_net` (`sort_breakdown_net`),
  KEY `sort_keyword_roi` (`sort_breakdown_roi`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_sort_breakdowns`
--

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

--
-- Table structure for table `pd_sort_campaign`
--

CREATE TABLE IF NOT EXISTS `pd_sort_campaign` (
  `sort_campaign_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `sort_campaign_clicks` DOUBLE NOT NULL,
  `sort_campaign_leads` DOUBLE NOT NULL,
  `sort_campaign_su_ratio` DOUBLE NOT NULL,
  `sort_campaign_payout` DOUBLE NOT NULL,
  `sort_campaign_epc` DOUBLE NOT NULL,
  `sort_campaign_avg_cpc` DOUBLE NOT NULL,
  `sort_campaign_income` DOUBLE NOT NULL,
  `sort_campaign_cost` DOUBLE NOT NULL,
  `sort_campaign_net` DOUBLE NOT NULL,
  `sort_campaign_roi` DOUBLE NOT NULL,
  `campaign_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_sort_campaign`
--

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

--
-- Table structure for table `pd_sort_ips`
--

CREATE TABLE IF NOT EXISTS `pd_sort_ips` (
  `sort_ip_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` mediumint(8) unsigned NOT NULL,
  `ip_id` bigint(20) unsigned NOT NULL,
  `sort_ip_clicks` mediumint(8) unsigned NOT NULL,
  `sort_ip_leads` mediumint(8) unsigned NOT NULL,
  `sort_ip_su_ratio` decimal(10,2) NOT NULL,
  `sort_ip_payout` decimal(6,2) NOT NULL,
  `sort_ip_epc` decimal(10,2) NOT NULL,
  `sort_ip_avg_cpc` decimal(7,5) NOT NULL,
  `sort_ip_income` decimal(10,2) NOT NULL,
  `sort_ip_cost` decimal(13,5) NOT NULL,
  `sort_ip_net` decimal(13,5) NOT NULL,
  `sort_ip_roi` decimal(10,2) NOT NULL,
  PRIMARY KEY (`sort_ip_id`),
  KEY `user_id` (`user_id`),
  KEY `keyword_id` (`ip_id`),
  KEY `sort_keyword_clicks` (`sort_ip_clicks`),
  KEY `sort_keyword_leads` (`sort_ip_leads`),
  KEY `sort_keyword_signup_ratio` (`sort_ip_su_ratio`),
  KEY `sort_keyword_payout` (`sort_ip_payout`),
  KEY `sort_keyword_epc` (`sort_ip_epc`),
  KEY `sort_keyword_cpc` (`sort_ip_avg_cpc`),
  KEY `sort_keyword_income` (`sort_ip_income`),
  KEY `sort_keyword_cost` (`sort_ip_cost`),
  KEY `sort_keyword_net` (`sort_ip_net`),
  KEY `sort_keyword_roi` (`sort_ip_roi`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_sort_ips`
--

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

--
-- Table structure for table `pd_sort_keywords`
--

CREATE TABLE IF NOT EXISTS `pd_sort_keywords` (
  `sort_keyword_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` mediumint(8) unsigned NOT NULL,
  `keyword_id` bigint(20) unsigned NOT NULL,
  `sort_keyword_clicks` mediumint(8) unsigned NOT NULL,
  `sort_keyword_leads` mediumint(8) unsigned NOT NULL,
  `sort_keyword_su_ratio` decimal(10,2) NOT NULL,
  `sort_keyword_payout` decimal(6,2) NOT NULL,
  `sort_keyword_epc` decimal(10,2) NOT NULL,
  `sort_keyword_avg_cpc` decimal(7,5) NOT NULL,
  `sort_keyword_income` decimal(10,2) NOT NULL,
  `sort_keyword_cost` decimal(13,5) NOT NULL,
  `sort_keyword_net` decimal(13,5) NOT NULL,
  `sort_keyword_roi` decimal(10,2) NOT NULL,
  PRIMARY KEY (`sort_keyword_id`),
  KEY `user_id` (`user_id`),
  KEY `keyword_id` (`keyword_id`),
  KEY `sort_keyword_clicks` (`sort_keyword_clicks`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_sort_keywords`
--

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

--
-- Table structure for table `pd_sort_keywords_lpctr`
--

CREATE TABLE IF NOT EXISTS `pd_sort_keywords_lpctr` (
  `sort_keyword_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` mediumint(8) unsigned NOT NULL,
  `keyword_id` bigint(20) unsigned NOT NULL,
  `sort_keyword_clicks` mediumint(8) unsigned NOT NULL,
  `sort_keyword_click_throughs` mediumint(8) unsigned NOT NULL,
  `sort_keyword_ctr` decimal(10,2) NOT NULL,
  `sort_keyword_leads` mediumint(8) unsigned NOT NULL,
  `sort_keyword_su_ratio` decimal(10,2) NOT NULL,
  `sort_keyword_payout` decimal(6,2) NOT NULL,
  `sort_keyword_epc` decimal(10,2) NOT NULL,
  `sort_keyword_avg_cpc` decimal(7,5) NOT NULL,
  `sort_keyword_income` decimal(10,2) NOT NULL,
  `sort_keyword_cost` decimal(13,5) NOT NULL,
  `sort_keyword_net` decimal(13,5) NOT NULL,
  `sort_keyword_roi` decimal(10,2) NOT NULL,
  PRIMARY KEY (`sort_keyword_id`),
  KEY `user_id` (`user_id`),
  KEY `keyword_id` (`keyword_id`),
  KEY `sort_keyword_clicks` (`sort_keyword_clicks`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_sort_keywords_lpctr`
--

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

--
-- Table structure for table `pd_sort_landing_pages`
--

CREATE TABLE IF NOT EXISTS `pd_sort_landing_pages` (
  `sort_landing_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` mediumint(8) unsigned NOT NULL,
  `landing_page_id` mediumint(8) unsigned NOT NULL,
  `sort_landing_page_clicks` mediumint(8) unsigned NOT NULL,
  `sort_landing_page_click_throughs` mediumint(8) unsigned NOT NULL,
  `sort_landing_page_ctr` decimal(10,2) NOT NULL,
  `sort_landing_page_leads` mediumint(8) unsigned NOT NULL,
  `sort_landing_page_su_ratio` decimal(10,2) NOT NULL,
  `sort_landing_page_payout` decimal(6,2) NOT NULL,
  `sort_landing_page_epc` decimal(10,2) NOT NULL,
  `sort_landing_page_avg_cpc` decimal(7,5) NOT NULL,
  `sort_landing_page_income` decimal(10,2) NOT NULL,
  `sort_landing_page_cost` decimal(13,5) NOT NULL,
  `sort_landing_page_net` decimal(13,5) NOT NULL,
  `sort_landing_page_roi` decimal(10,2) NOT NULL,
  PRIMARY KEY (`sort_landing_id`),
  KEY `user_id` (`user_id`),
  KEY `landing_page_id` (`landing_page_id`),
  KEY `sort_landing_page_clicks` (`sort_landing_page_clicks`),
  KEY `sort_landing_page_click_throughs` (`sort_landing_page_click_throughs`),
  KEY `sort_landing_page_ctr` (`sort_landing_page_ctr`),
  KEY `sort_landing_page_leads` (`sort_landing_page_leads`),
  KEY `sort_landing_page_su_ratio` (`sort_landing_page_su_ratio`),
  KEY `sort_landing_page_payout` (`sort_landing_page_payout`),
  KEY `sort_landing_page_epc` (`sort_landing_page_epc`),
  KEY `sort_landing_page_avg_cpc` (`sort_landing_page_avg_cpc`),
  KEY `sort_landing_page_income` (`sort_landing_page_income`),
  KEY `sort_landing_page_cost` (`sort_landing_page_cost`),
  KEY `sort_landing_page_net` (`sort_landing_page_net`),
  KEY `sort_landing_page_roi` (`sort_landing_page_roi`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_sort_landing_pages`
--

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

--
-- Table structure for table `pd_sort_offer_overview`
--

CREATE TABLE IF NOT EXISTS `pd_sort_offer_overview` (
  `sort_offer_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` mediumint(8) unsigned NOT NULL,
  `campaign_id` mediumint(8) unsigned NOT NULL,
  `sort_offer_clicks` mediumint(8) unsigned NOT NULL,
  `sort_offer_leads` mediumint(8) unsigned NOT NULL,
  `sort_offer_su_ratio` decimal(10,2) NOT NULL,
  `sort_offer_payout` decimal(6,2) NOT NULL,
  `sort_offer_epc` decimal(10,2) NOT NULL,
  `sort_offer_avg_cpc` decimal(7,5) NOT NULL,
  `sort_offer_income` decimal(10,2) NOT NULL,
  `sort_offer_cost` decimal(13,5) NOT NULL,
  `sort_offer_net` decimal(13,5) NOT NULL,
  `sort_offer_roi` decimal(10,2) NOT NULL,
  PRIMARY KEY (`sort_offer_id`),
  KEY `user_id` (`user_id`),
  KEY `landing_page_id` (`campaign_id`),
  KEY `sort_landing_page_clicks` (`sort_offer_clicks`),
  KEY `sort_landing_page_leads` (`sort_offer_leads`),
  KEY `sort_landing_page_su_ratio` (`sort_offer_su_ratio`),
  KEY `sort_landing_page_payout` (`sort_offer_payout`),
  KEY `sort_landing_page_epc` (`sort_offer_epc`),
  KEY `sort_landing_page_avg_cpc` (`sort_offer_avg_cpc`),
  KEY `sort_landing_page_income` (`sort_offer_income`),
  KEY `sort_landing_page_cost` (`sort_offer_cost`),
  KEY `sort_landing_page_net` (`sort_offer_net`),
  KEY `sort_landing_page_roi` (`sort_offer_roi`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_sort_offer_overview`
--

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

--
-- Table structure for table `pd_sort_referers_lpctr`
--

CREATE TABLE IF NOT EXISTS `pd_sort_referers_lpctr` (
  `sort_referer_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` mediumint(8) unsigned NOT NULL,
  `referer_id` bigint(20) unsigned NOT NULL,
  `sort_referer_clicks` mediumint(8) unsigned NOT NULL,
  `sort_referer_click_throughs` mediumint(8) unsigned NOT NULL,
  `sort_referer_ctr` decimal(10,2) NOT NULL,
  `sort_referer_leads` mediumint(8) unsigned NOT NULL,
  `sort_referer_su_ratio` decimal(10,2) NOT NULL,
  `sort_referer_payout` decimal(6,2) NOT NULL,
  `sort_referer_epc` decimal(10,2) NOT NULL,
  `sort_referer_avg_cpc` decimal(7,5) NOT NULL,
  `sort_referer_income` decimal(10,2) NOT NULL,
  `sort_referer_cost` decimal(13,5) NOT NULL,
  `sort_referer_net` decimal(13,5) NOT NULL,
  `sort_referer_roi` decimal(10,2) NOT NULL,
  PRIMARY KEY (`sort_referer_id`),
  KEY `user_id` (`user_id`),
  KEY `keyword_id` (`referer_id`),
  KEY `sort_keyword_clicks` (`sort_referer_clicks`),
  KEY `sort_keyword_leads` (`sort_referer_leads`),
  KEY `sort_keyword_signup_ratio` (`sort_referer_su_ratio`),
  KEY `sort_keyword_payout` (`sort_referer_payout`),
  KEY `sort_keyword_epc` (`sort_referer_epc`),
  KEY `sort_keyword_cpc` (`sort_referer_avg_cpc`),
  KEY `sort_keyword_income` (`sort_referer_income`),
  KEY `sort_keyword_cost` (`sort_referer_cost`),
  KEY `sort_keyword_net` (`sort_referer_net`),
  KEY `sort_keyword_roi` (`sort_referer_roi`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_sort_referers_lpctr`
--

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

--
-- Table structure for table `pd_sort_visitors`
--

CREATE TABLE IF NOT EXISTS `pd_sort_visitors` (
  `visitor_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `visitor_click_id` int(11) NOT NULL,
  `visitor_click_time` varchar(200) NOT NULL,
  `visitor_browser_id` VARCHAR(200) NOT NULL,
  `visitor_platform_id` VARCHAR(200) NOT NULL,
  `visitor_ip_address` varchar(100) NOT NULL,
  `visitor_aff_campaign_name` varchar(100) NOT NULL,
  `visitor_referer` varchar(100) NOT NULL,
  `visitor_referer_host` varchar(100) NOT NULL,
  `visitor_outbound` varchar(100) NOT NULL,
  `visitor_redirect` varchar(100) NOT NULL,
  `visitor_keyword` varchar(100) NOT NULL,
  `click_filtered` int(11) NOT NULL,
  `click_lead` int(11) NOT NULL,
  PRIMARY KEY (`visitor_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_sort_visitors`
--

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

--
-- Table structure for table `pd_summary_overview`
--

CREATE TABLE IF NOT EXISTS `pd_summary_overview` (
  `user_id` mediumint(8) unsigned NOT NULL,
  `aff_campaign_id` mediumint(8) unsigned NOT NULL,
  `landing_page_id` mediumint(8) unsigned NOT NULL,
  `ppv_account_id` mediumint(8) unsigned NOT NULL,
  `click_time` int(10) unsigned NOT NULL,
  `trackers_id` varchar(100) NOT NULL,
  `offer_id` int(10) NOT NULL,
  `click_id` int(11) NOT NULL,
  KEY `aff_campaign_id` (`aff_campaign_id`),
  KEY `user_id` (`user_id`),
  KEY `ppc_account_id` (`ppv_account_id`),
  KEY `landing_page_id` (`landing_page_id`),
  KEY `click_time` (`click_time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_summary_overview`
--

CREATE TABLE IF NOT EXISTS `pd_land_values` (
  `land_id` int(11) NOT NULL,
  `querystring` longtext NOT NULL,
  PRIMARY KEY (`land_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `pd_template`
--

CREATE TABLE IF NOT EXISTS `pd_template` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `template_id` int(11) NOT NULL,
  `blue` varchar(20) NOT NULL,
  `orange` varchar(100) NOT NULL,
  `headers` varchar(100) NOT NULL,
  `title` varchar(100) NOT NULL,
  `bullet1` varchar(50) NOT NULL,
  `bullet2` varchar(50) NOT NULL,
  `bullet3` varchar(50) NOT NULL,
  `bullet4` varchar(50) NOT NULL,
  `bullet5` varchar(50) NOT NULL,
  `content1` longtext NOT NULL,
  `content2` longtext NOT NULL,
  `content3` longtext NOT NULL,
  `subtitle` varchar(150) NOT NULL,
  `content` varchar(2000) NOT NULL,
  `image` varchar(35) NOT NULL,
  `land_id` int(11) NOT NULL,
  `pg_title` varchar(500) NOT NULL,
  `button1` varchar(500) NOT NULL,
  `button_color` varchar(100) NOT NULL,
  `title_color` varchar(100) NOT NULL,
  `bullet_color` varchar(100) NOT NULL,
  `sub_color` varchar(100) NOT NULL,
  `header_color` varchar(100) NOT NULL,
  `content_color` varchar(100) NOT NULL,
  `img_default` varchar(100) NOT NULL,
  `btn_txt_color` varchar(100) NOT NULL,
  `content_color1` varchar(100) NOT NULL,
  `content_color2` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_template`
--

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

--
-- Table structure for table `pd_text_adds`
--

CREATE TABLE IF NOT EXISTS `pd_text_adds` (
  `text_adds_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `text_ad_for` int(11) NOT NULL,
  `aff_campaign_id` int(11) NOT NULL,
  `niche_id` int(11) NOT NULL,
  `aff_network_id` int(11) NOT NULL,
  `landing_page_id` int(11) NOT NULL,
  `ad_nickname` varchar(25) NOT NULL,
  `ad_headline` varchar(25) NOT NULL,
  `ad_des` varchar(25) NOT NULL,
  `display_urls` varchar(25) NOT NULL,
  PRIMARY KEY (`text_adds_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_text_adds`
--

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

--
-- Table structure for table `pd_trackers`
--

CREATE TABLE IF NOT EXISTS `pd_trackers` (
  `tracker_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` mediumint(8) unsigned NOT NULL,
  `tracker_id_public` bigint(20) unsigned NOT NULL,
  `aff_campaign_id` mediumint(8) unsigned NOT NULL,
  `text_ad_id` mediumint(8) unsigned NOT NULL,
  `ppv_account_id` mediumint(8) unsigned NOT NULL,
  `landing_page_id` mediumint(8) unsigned NOT NULL,
  `click_cpc` decimal(7,5) NOT NULL,
  `click_cloaking` tinyint(1) NOT NULL,
  `tracker_time` int(10) unsigned NOT NULL,
  `tracker_status` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`tracker_id`),
  KEY `tracker_id_public` (`tracker_id_public`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_trackers`
--

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

--
-- Table structure for table `pd_users`
--

CREATE TABLE IF NOT EXISTS `pd_users` (
  `user_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `user_name` varchar(50) NOT NULL,
  `user_pass` char(100) NOT NULL,
  `user_email` varchar(100) NOT NULL,
  `user_timezone` varchar(100) NOT NULL DEFAULT '-8',
  `user_time_register` int(10) unsigned NOT NULL,
  `user_pass_key` varchar(255) NOT NULL,
  `user_pass_time` int(10) unsigned NOT NULL,
  `user_api_key` varchar(255) NOT NULL,
  `user_stats202_app_key` varchar(255) NOT NULL,
  `user_last_login_ip_id` bigint(20) unsigned NOT NULL,
  `user_subid` int(10) NOT NULL,
  `daylight` varchar(20) NOT NULL,
  `ent_license` int(11) NOT NULL,
  `lp_license` int(11) NOT NULL,
  `admin` int(11) NOT NULL,
  `license_key` VARCHAR(200) NOT NULL,
  `ent_license_key` varchar(200) NOT NULL,
  `lp_license_key` varchar(200) NOT NULL,
  `license_date` varchar(200) NOT NULL,
  `ent_license_date` varchar(200) NOT NULL,
  `thrice_a_week` varchar(200) NOT NULL,
  `active` int(11) NOT NULL DEFAULT '1',
  `weekly` varchar(200) NOT NULL,
  `license_status` varchar(200) NOT NULL,
  `log_count` int(11) NOT NULL,
  PRIMARY KEY (`user_id`),
  KEY `user_name` (`user_name`,`user_pass`),
  KEY `user_pass_key` (`user_pass_key`(5)),
  KEY `user_last_login_ip_id` (`user_last_login_ip_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_users`
--

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

--
-- Table structure for table `pd_users_pref`
--

CREATE TABLE IF NOT EXISTS `pd_users_pref` (
  `user_id` mediumint(8) unsigned NOT NULL,
  `user_pref_limit` tinyint(3) unsigned NOT NULL DEFAULT '50',
  `user_pref_show` varchar(25) NOT NULL,
  `user_pref_time_from` int(10) unsigned NOT NULL,
  `user_pref_time_to` int(10) unsigned NOT NULL,
  `user_pref_time_predefined` varchar(25) NOT NULL DEFAULT 'today',
  `user_pref_adv` tinyint(1) NOT NULL,
  `user_pref_ppc_network_id` mediumint(8) unsigned NOT NULL,
  `user_pref_ppc_account_id` mediumint(8) unsigned NOT NULL,
  `user_pref_aff_network_id` mediumint(8) unsigned NOT NULL,
  `user_pref_aff_campaign_id` mediumint(8) unsigned NOT NULL,
  `user_pref_niche` int(10) NOT NULL,
  `user_pref_text_ad_id` mediumint(8) unsigned NOT NULL,
  `user_pref_method_of_promotion` varchar(25) NOT NULL,
  `user_pref_landing_page_id` mediumint(8) unsigned NOT NULL,
  `user_pref_country_id` tinyint(3) unsigned NOT NULL,
  `user_pref_ip` varchar(100) NOT NULL,
  `user_pref_referer` varchar(100) NOT NULL,
  `user_pref_keyword` varchar(100) NOT NULL,
  `user_pref_breakdown` varchar(100) NOT NULL DEFAULT 'day',
  `user_pref_chart` varchar(255) NOT NULL DEFAULT 'net',
  `user_cpc_or_cpv` char(3) NOT NULL DEFAULT 'cpc',
  `user_keyword_searched_or_bidded` varchar(255) NOT NULL DEFAULT 'searched',
  `user_tracking_domain` varchar(255) NOT NULL DEFAULT '',
  `user_pref_group_2` tinyint(3) NOT NULL,
  `user_pref_group_3` tinyint(3) NOT NULL,
  `user_pref_group_4` tinyint(3) NOT NULL,
  `user_pref_group_1` tinyint(3) NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pd_users_pref`
--

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

--
-- Table structure for table `plugins`
--

CREATE TABLE IF NOT EXISTS `plugins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Enterprise_License` varchar(200) NOT NULL,
  `LP_EZInsert_License` varchar(200) NOT NULL,
  `user_id` int(11) NOT NULL,
  `base_url` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `plugins`
--

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

--
-- Table structure for table `timezone`
--

CREATE TABLE IF NOT EXISTS `timezone` (
  `timezoneid` int(11) NOT NULL DEFAULT '0',
  `gmt_offset` double DEFAULT '0',
  `dst_offset` double DEFAULT NULL,
  `timezone_code` varchar(4) DEFAULT NULL,
  PRIMARY KEY (`timezoneid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `timezone`
--

INSERT INTO `timezone` (`timezoneid`, `gmt_offset`, `dst_offset`, `timezone_code`) VALUES
(1, -12, 0, NULL),
(2, -11, 0, NULL),
(3, -10, 0, 'H'),
(4, -9, 1, 'AK'),
(5, -8, 1, 'P'),
(6, -7, 0, 'M'),
(7, -7, 1, NULL),
(8, -7, 1, 'M'),
(9, -6, 0, NULL),
(10, -6, 1, 'C'),
(11, -6, 1, NULL),
(12, -6, 0, 'C'),
(13, -5, 0, NULL),
(14, -5, 1, 'E'),
(15, -5, 0, 'E'),
(16, -4, 1, 'A'),
(17, -4, 0, NULL),
(18, -4, 1, NULL),
(19, -3.5, 1, 'N'),
(20, -3, 1, NULL),
(21, -3, 0, NULL),
(22, -3, 1, NULL),
(23, -2, 1, NULL),
(24, -1, 1, NULL),
(25, -1, 0, NULL),
(26, 0, 0, NULL),
(27, 0, 1, NULL),
(28, 1, 1, NULL),
(29, 1, 1, NULL),
(30, 1, 1, NULL),
(31, 1, 1, NULL),
(32, 1, 0, NULL),
(33, 2, 1, NULL),
(34, 2, 1, NULL),
(35, 2, 1, NULL),
(36, 2, 0, NULL),
(37, 2, 1, NULL),
(38, 2, 0, NULL),
(39, 3, 1, NULL),
(40, 3, 0, NULL),
(41, 3, 1, NULL),
(42, 3, 0, NULL),
(43, 3.5, 1, NULL),
(44, 4, 0, NULL),
(45, 4, 1, NULL),
(46, 4.5, 0, NULL),
(47, 5, 1, NULL),
(48, 5, 0, NULL),
(49, 5.5, 0, NULL),
(50, 5.75, 0, NULL),
(51, 6, 1, NULL),
(52, 6, 0, NULL),
(53, 6, 0, NULL),
(54, 6.5, 0, NULL),
(55, 7, 0, NULL),
(56, 7, 1, NULL),
(57, 8, 0, NULL),
(58, 8, 1, NULL),
(59, 8, 0, NULL),
(60, 8, 0, NULL),
(61, 8, 0, NULL),
(62, 9, 0, NULL),
(63, 9, 0, NULL),
(64, 9, 1, NULL),
(65, 9.5, 1, NULL),
(66, 9.5, 0, NULL),
(67, 10, 0, NULL),
(68, 10, 1, NULL),
(69, 10, 0, NULL),
(70, 10, 1, NULL),
(71, 10, 1, NULL),
(72, 11, 0, NULL),
(73, 12, 1, NULL),
(74, 12, 0, NULL),
(75, 13, 0, NULL);

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

--
-- Table structure for table `version`
--

CREATE TABLE IF NOT EXISTS `version` (
  `v_id` int(11) NOT NULL AUTO_INCREMENT,
  `v_date` varchar(30) NOT NULL,
  `version` varchar(30) NOT NULL,
  `date` varchar(30) NOT NULL,
  PRIMARY KEY (`v_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `version`
--