--
-- Host: linkxx.us    Database: linkxx_link
-- ------------------------------------------------------


--
-- Table structure for table `directory_save_data`
--

CREATE TABLE `directory_save_data` (
  `id` bigint(100) NOT NULL AUTO_INCREMENT,
  `schedule_id` bigint(100) NOT NULL,
  `project_id` bigint(100) NOT NULL,
  `link_id` bigint(100) NOT NULL,
  `confirm_link` text NOT NULL,
  `category_id` int(10) NOT NULL,
  `category_name` varchar(150) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `directory_save_data`
--


--
-- Table structure for table `idx_admin_menu`
--

CREATE TABLE `idx_admin_menu` (
  `menu_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `menu_title` varchar(255) DEFAULT NULL,
  `menu_url` varchar(255) DEFAULT NULL,
  `order_number` int(11) DEFAULT NULL,
  PRIMARY KEY (`menu_id`)
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_admin_menu`
--



--
-- Table structure for table `idx_bad_link`
--

CREATE TABLE `idx_bad_link` (
  `bad_link_id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `link_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `name` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(50) NOT NULL DEFAULT '',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`bad_link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_bad_link`
--


--
-- Table structure for table `idx_badwords`
--

CREATE TABLE `idx_badwords` (
  `word` varchar(100) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_badwords`
--


--
-- Table structure for table `idx_blocked_domain`
--

CREATE TABLE `idx_blocked_domain` (
  `blocked_id` int(11) NOT NULL AUTO_INCREMENT,
  `blocked` varchar(255) DEFAULT NULL,
  `type` enum('domain','ip') DEFAULT NULL,
  PRIMARY KEY (`blocked_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_blocked_domain`
--

INSERT INTO `idx_blocked_domain` VALUES (1,'buydomains.com','domain'),(2,'this-domain-for-sale.com ','domain'),(3,'oversee.net','domain'),(4,'eNom','domain'),(5,'sedoparking.com','domain');

--
-- Table structure for table `idx_category`
--

CREATE TABLE `idx_category` (
  `category_id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `name` varchar(100) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `image` varchar(100) DEFAULT NULL,
  `content` text,
  `visible` char(1) DEFAULT NULL,
  `links` mediumint(9) DEFAULT NULL,
  `meta_keyword` text,
  `meta_description` text,
  `permission` char(2) DEFAULT NULL,
  `registered_only` char(1) DEFAULT NULL,
  `header` text NOT NULL,
  `footer` text NOT NULL,
  `related` mediumint(6) NOT NULL DEFAULT '0',
  `page_title` varchar(200) NOT NULL DEFAULT '',
  `hits` int(11) NOT NULL DEFAULT '0',
  `order_num` smallint(6) NOT NULL DEFAULT '0',
  `basic_price` double unsigned NOT NULL DEFAULT '0',
  `premium_price` double unsigned NOT NULL DEFAULT '0',
  `sponsored_price` double unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_category`
--

INSERT INTO `idx_category` VALUES (1,0,'Arts & Entertainment','','folder.gif','','1',13,'','','0','0','','',0,'',0,0,0,0,0),(2,0,'Automotive','','folder.gif','','1',38,'','','0','0','','',0,'',0,0,0,0,0),(3,0,'Business','','folder.gif','','1',137,'','','1','0','','',0,'',0,0,0,0,0),(4,0,'Careers & Jobs','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(5,0,'Clothing','','folder.gif','','1',11,'','','0','0','','',0,'',0,0,0,0,0),(6,0,'Communications','','folder.gif','','1',24,'','','0','0','','',0,'',0,0,0,0,0),(7,0,'Computer & Internet','','folder.gif','','1',20,'','','0','0','','',0,'',0,0,0,0,0),(8,0,'Construction and Maintenance','','folder.gif','','1',73,'','','0','0','','',0,'',0,0,0,0,0),(9,0,'Dental','','folder.gif','','1',34,'','','0','0','','',0,'',0,0,0,0,0),(10,0,'Education','','folder.gif','','1',22,'','','0','0','','',0,'',0,0,0,0,0),(11,0,'Employment','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(12,0,'Gifts','','folder.gif','','1',23,'','','0','0','','',0,'',0,0,0,0,0),(13,0,'Hardware & Software','','folder.gif','','1',11,'','','0','0','','',0,'',0,0,0,0,0),(14,0,'Health & fitness','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(15,0,'Healthcare','','folder.gif','','1',168,'','','0','0','','',0,'',0,0,0,0,0),(16,0,'Heating and Air Conditioning Contractors','','folder.gif','','1',59,'','','0','0','','',0,'',0,0,0,0,0),(17,0,'Home & Family','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(18,0,'Home Improvement & Decor','','folder.gif','','1',293,'','','0','0','','',0,'',0,0,0,0,0),(19,0,'Hotels & Accomadation','','folder.gif','','1',56,'','','0','0','','',0,'',0,0,0,0,0),(20,0,'Insurance Companies','','folder.gif','','1',34,'','','0','0','','',0,'',0,0,0,0,0),(21,0,'Law','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(22,0,'Lawyers & Judges','','folder.gif','','1',162,'','','0','0','','',0,'',0,0,0,0,0),(23,0,'Dating & Relationships','','folder.gif','','1',3,'','','0','0','','',0,'',0,0,0,0,0),(24,0,'Medicine & Hospitals','','folder.gif','','1',12,'','','0','0','','',0,'',0,0,0,0,0),(25,0,'Finance & Investment Services','','folder.gif','','1',16,'','','0','0','','',0,'',0,0,0,0,0),(26,0,'News & Magazines','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(27,0,'Plumbing Services','','folder.gif','','1',38,'','','0','0','','',0,'',0,0,0,0,0),(28,0,'Real Estate Development','','folder.gif','','1',30,'','','0','0','','',0,'',0,0,0,0,0),(29,0,'Energy & Science','','folder.gif','','1',12,'','','0','0','','',0,'',0,0,0,0,0),(30,0,'SEO ,SMO & PPC','','folder.gif','','1',22,'','','0','0','','',0,'',0,0,0,0,0),(31,0,'Shopping and Retail','','folder.gif','','1',52,'','','0','0','','',0,'',0,0,0,0,0),(32,0,'Recreation & Sports','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(33,0,'Transport & Moving Services','','folder.gif','','1',38,'','','0','0','','',0,'',0,0,0,0,0),(34,0,'Travel Industry','','folder.gif','','1',16,'','','0','0','','',0,'',0,0,0,0,0),(35,0,'Wedding & Events','','folder.gif','','1',6,'','','0','0','','',0,'',0,0,0,0,0);

--
-- Table structure for table `idx_category_path`
--

CREATE TABLE `idx_category_path` (
  `category_id` mediumint(9) NOT NULL DEFAULT '0',
  `path` text,
  `path_with_url` text,
  `parents` text,
  PRIMARY KEY (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_category_path`
--

INSERT INTO `idx_category_path` VALUES (1,'Arts & Entertainment','<a href=\"http://linkxx.us/arts-entertainment/\" name=\"cat_1\" style=\"\">Arts & Entertainment</a>',';0;'),(2,'Automotive','<a href=\"http://linkxx.us/automotive/\" name=\"cat_2\" style=\"\">Automotive</a>',';0;'),(3,'Business','<a href=\"http://linkxx.us/business/\" name=\"cat_3\" style=\"\">Business</a>',';0;'),(4,'Careers & Jobs','<a href=\"http://linkxx.us/careers-jobs/\" name=\"cat_4\" style=\"\">Careers & Jobs</a>',';0;'),(5,'Clothing','<a href=\"http://linkxx.us/clothing/\" name=\"cat_5\" style=\"\">Clothing</a>',';0;'),(6,'Communications','<a href=\"http://linkxx.us/communications/\" name=\"cat_6\" style=\"\">Communications</a>',';0;'),(7,'Computer & Internet','<a href=\"http://linkxx.us/computer-internet/\" name=\"cat_7\" style=\"\">Computer & Internet</a>',';0;'),(8,'Construction and Maintenance','<a href=\"http://linkxx.us/construction-and-maintenance/\" name=\"cat_8\" style=\"\">Construction and Maintenance</a>',';0;'),(9,'Dental','<a href=\"http://linkxx.us/dental/\" name=\"cat_9\" style=\"\">Dental</a>',';0;'),(10,'Education','<a href=\"http://linkxx.us/education/\" name=\"cat_10\" style=\"\">Education</a>',';0;'),(11,'Employment','<a href=\"http://linkxx.us/employment/\" name=\"cat_11\" style=\"\">Employment</a>',';0;'),(12,'Gifts','<a href=\"http://linkxx.us/gifts/\" name=\"cat_12\" style=\"\">Gifts</a>',';0;'),(13,'Hardware & Software','<a href=\"http://linkxx.us/hardware-software/\" name=\"cat_13\" style=\"\">Hardware & Software</a>',';0;'),(14,'Health & fitness','<a href=\"http://linkxx.us/health-fitness/\" name=\"cat_14\" style=\"\">Health & fitness</a>',';0;'),(15,'Healthcare','<a href=\"http://linkxx.us/healthcare/\" name=\"cat_15\" style=\"\">Healthcare</a>',';0;'),(16,'Heating and Air Conditioning Contractors','<a href=\"http://linkxx.us/heating-and-air-conditioning-contractors/\" name=\"cat_16\" style=\"\">Heating and Air Conditioning Contractors</a>',';0;'),(17,'Home & Family','<a href=\"http://linkxx.us/home-family/\" name=\"cat_17\" style=\"\">Home & Family</a>',';0;'),(18,'Home Improvement & Decor','<a href=\"http://linkxx.us/home-improvement-decor/\" name=\"cat_18\" style=\"\">Home Improvement & Decor</a>',';0;'),(19,'Hotels & Accomadation','<a href=\"http://linkxx.us/hotels-accomadation/\" name=\"cat_19\" style=\"\">Hotels & Accomadation</a>',';0;'),(20,'Insurance Companies','<a href=\"http://linkxx.us/insurance-companies/\" name=\"cat_20\" style=\"\">Insurance Companies</a>',';0;'),(21,'Law','<a href=\"http://linkxx.us/law/\" name=\"cat_21\" style=\"\">Law</a>',';0;'),(22,'Lawyers & Judges','<a href=\"http://linkxx.us/lawyers-judges/\" name=\"cat_22\" style=\"\">Lawyers & Judges</a>',';0;'),(23,'Dating & Relationships','<a href=\"http://linkxx.us/dating-relationships/\" name=\"cat_23\" style=\"\">Dating & Relationships</a>',';0;'),(24,'Medicine & Hospitals','<a href=\"http://linkxx.us/medicine-hospitals/\" name=\"cat_24\" style=\"\">Medicine & Hospitals</a>',';0;'),(25,'Finance & Investment Services','<a href=\"http://linkxx.us/finance-investment-services/\" name=\"cat_25\" style=\"\">Finance & Investment Services</a>',';0;'),(26,'News & Magazines','<a href=\"http://linkxx.us/news-magazines/\" name=\"cat_26\" style=\"\">News & Magazines</a>',';0;'),(27,'Plumbing Services','<a href=\"http://linkxx.us/plumbing-services/\" name=\"cat_27\" style=\"\">Plumbing Services</a>',';0;'),(28,'Real Estate Development','<a href=\"http://linkxx.us/real-estate-development/\" name=\"cat_28\" style=\"\">Real Estate Development</a>',';0;'),(29,'Energy & Science','<a href=\"http://linkxx.us/energy-science/\" name=\"cat_29\" style=\"\">Energy & Science</a>',';0;'),(30,'SEO ,SMO & PPC','<a href=\"http://linkxx.us/seo-smo-ppc/\" name=\"cat_30\" style=\"\">SEO ,SMO & PPC</a>',';0;'),(31,'Shopping and Retail','<a href=\"http://linkxx.us/shopping-and-retail/\" name=\"cat_31\" style=\"\">Shopping and Retail</a>',';0;'),(32,'Recreation & Sports','<a href=\"http://linkxx.us/recreation-sports/\" name=\"cat_32\" style=\"\">Recreation & Sports</a>',';0;'),(33,'Transport & Moving Services','<a href=\"http://linkxx.us/transport-moving-services/\" name=\"cat_33\" style=\"\">Transport & Moving Services</a>',';0;'),(34,'Travel Industry','<a href=\"http://linkxx.us/travel-industry/\" name=\"cat_34\" style=\"\">Travel Industry</a>',';0;'),(35,'Wedding & Events','<a href=\"http://linkxx.us/wedding-events/\" name=\"cat_35\" style=\"\">Wedding & Events</a>',';0;');

--
-- Table structure for table `idx_category_suggession`
--

CREATE TABLE `idx_category_suggession` (
  `id_cat_suggession` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `category_description` text,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id_cat_suggession`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_category_suggession`
--

INSERT INTO `idx_category_suggession` VALUES (1,31,'Electronicks','Voltage Transformer - Buy certified voltage converter, Voltage Transformers, Power Converter,  Voltage Transformer, Voltage Power Converter from voltage-converter-transformers.com','2012-01-19 01:38:18'),(2,9,'Dentist Leesburg VA','LCI Dentistry provides comprehensive dental care in the Leesburg VA area as well as the surrounding communities in Loudoun County. Focusing on cosmetic and general dentistry as well as providing an on-site oral surgeon to create the most comfortable and convenient environment for our patients. Call 703-729-1818','2012-01-24 15:22:38');

--
-- Table structure for table `idx_checkurl`
--

CREATE TABLE `idx_checkurl` (
  `link_id` mediumint(9) NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  `live` char(1) NOT NULL DEFAULT '',
  `reciprocal_found` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_checkurl`
--


--
-- Table structure for table `idx_cronjobs`
--

CREATE TABLE `idx_cronjobs` (
  `cronjobs_id` int(11) NOT NULL AUTO_INCREMENT,
  `cronjobs_name` varchar(255) DEFAULT NULL,
  `filename` varchar(255) NOT NULL,
  `schedule` varchar(255) NOT NULL,
  `time` datetime NOT NULL,
  `execution` varchar(1) NOT NULL,
  PRIMARY KEY (`cronjobs_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_cronjobs`
--

INSERT INTO `idx_cronjobs` VALUES (1,NULL,'clear_templates_c.php','1,*,*,*,*','0000-00-00 00:00:00',''),(2,NULL,'update_tag_cloud.php','*,24,*,*,*','0000-00-00 00:00:00',''),(3,NULL,'clear_rss_cache.php','*,24,*,*,*','0000-00-00 00:00:00','');

--
-- Table structure for table `idx_custom_field`
--

CREATE TABLE `idx_custom_field` (
  `field_name` varchar(32) NOT NULL DEFAULT '',
  `field_text` varchar(64) NOT NULL DEFAULT '',
  `field_type` enum('TEXT','TEXTAREA','SELECT','MULTISELECT','CHECKBOX','RADIO','FILE','IMAGE','DATE','DATETIME','RICHEDITOR') NOT NULL DEFAULT 'TEXT',
  `field_option` text NOT NULL,
  `field_img_width` int(10) unsigned NOT NULL DEFAULT '0',
  `field_img_height` int(10) unsigned NOT NULL DEFAULT '0',
  `field_file_size` int(10) unsigned NOT NULL DEFAULT '0',
  `field_file_extension` varchar(64) NOT NULL DEFAULT '',
  `required` char(1) NOT NULL DEFAULT '0',
  `searchable` char(1) NOT NULL DEFAULT '1',
  `permission` char(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_custom_field`
--

INSERT INTO `idx_custom_field` VALUES ('image','Image','IMAGE','',0,0,0,'','0','0','2'),('address','Address','TEXT','',0,0,0,'','0','0','0'),('city','City','TEXT','',0,0,0,'','0','0','0'),('state','State','TEXT','',0,0,0,'','0','0','0'),('country','Country','TEXT','',0,0,0,'','0','0','0'),('zip','Zip','TEXT','',0,0,0,'','0','0','0'),('phone','Phone','TEXT','',0,0,0,'','0','0','0'),('fax','Fax','TEXT','',0,0,0,'','0','0','0');

--
-- Table structure for table `idx_default_field`
--

CREATE TABLE `idx_default_field` (
  `field_name` varchar(64) NOT NULL,
  `required` char(1) NOT NULL,
  `visible` char(1) NOT NULL DEFAULT '1',
  `searchable` char(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_default_field`
--

INSERT INTO `idx_default_field` VALUES ('title','1','1','1'),('url','1','1','1'),('description','1','1','1'),('keywords','1','1','0'),('contact_name','1','1','1'),('email','1','1','1'),('reciprocal_url','0','0','1');

--
-- Table structure for table `idx_discount_coupon`
--

CREATE TABLE `idx_discount_coupon` (
  `coupon_id` int(11) NOT NULL AUTO_INCREMENT,
  `coupon_code` varchar(255) DEFAULT NULL,
  `coupon_value` varchar(50) DEFAULT NULL,
  `link_type` varchar(255) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `expired_date` date DEFAULT NULL,
  `expired_usage` int(11) DEFAULT NULL,
  `usage_count` int(11) DEFAULT NULL,
  PRIMARY KEY (`coupon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_discount_coupon`
--


--
-- Table structure for table `idx_editor`
--

CREATE TABLE `idx_editor` (
  `username` varchar(20) DEFAULT NULL,
  `category_id` mediumint(9) DEFAULT NULL,
  `category` char(1) DEFAULT NULL,
  `link` char(1) DEFAULT NULL,
  `review` char(1) DEFAULT NULL,
  `pick` char(1) DEFAULT NULL,
  `status` char(1) DEFAULT NULL,
  `date` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_editor`
--


--
-- Table structure for table `idx_email_template`
--

CREATE TABLE `idx_email_template` (
  `email_template_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `body` text,
  `altbody` text,
  PRIMARY KEY (`email_template_id`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_email_template`
--



--
-- Table structure for table `idx_favorites`
--

CREATE TABLE `idx_favorites` (
  `favorite_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`favorite_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_favorites`
--

INSERT INTO `idx_favorites` VALUES (1,'stanleydevini86n10','2011-10-18','My Favorites',NULL),(2,'seymourmaurid82b78','2011-10-19','My Favorites',NULL),(3,'ramonlazarov72d98','2011-10-31','My Favorites',NULL),(4,'brooksfrancii97o18','2011-11-02','My Favorites',NULL);

--
-- Table structure for table `idx_favorites_detail`
--

CREATE TABLE `idx_favorites_detail` (
  `favorite_id` int(11) DEFAULT NULL,
  `link_id` mediumint(9) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_favorites_detail`
--


--
-- Table structure for table `idx_hook_place`
--

CREATE TABLE `idx_hook_place` (
  `hook_place_id` int(11) NOT NULL AUTO_INCREMENT,
  `filename` varchar(255) DEFAULT NULL,
  `hookname` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`hook_place_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_hook_place`
--


--
-- Table structure for table `idx_invoice`
--

CREATE TABLE `idx_invoice` (
  `invoice_id` varchar(10) NOT NULL DEFAULT '',
  `invoice_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `invoiced_to` text,
  `service` varchar(255) DEFAULT NULL,
  `description` text,
  `total` double(8,2) DEFAULT NULL,
  `comment` text,
  `paid` char(1) DEFAULT NULL,
  `paid_date` date DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`invoice_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_invoice`
--


--
-- Table structure for table `idx_invoice_config`
--

CREATE TABLE `idx_invoice_config` (
  `company` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `address` text,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `currency_symbol` varchar(255) DEFAULT '$',
  `currency_code` varchar(255) DEFAULT 'USD'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_invoice_config`
--

INSERT INTO `idx_invoice_config` VALUES ('Your website / Company','Billing Department','Your address','Your phone #','Billing<name@yourdomain.com>','$','USD');

--
-- Table structure for table `idx_link_temp`
--

CREATE TABLE `idx_link_temp` (
  `vid` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `spam` char(1) NOT NULL DEFAULT '0',
  `link_id` mediumint(9) DEFAULT NULL,
  `category_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `title` varchar(100) NOT NULL DEFAULT '',
  `url` text NOT NULL,
  `description` text NOT NULL,
  `contact_name` varchar(100) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
  `hits` mediumint(9) DEFAULT NULL,
  `votes` smallint(6) DEFAULT NULL,
  `rating` float(4,2) DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `bid` smallint(6) NOT NULL DEFAULT '0',
  `new` char(1) DEFAULT NULL,
  `hot` char(1) DEFAULT NULL,
  `top_rated` char(1) DEFAULT NULL,
  `pick` char(1) DEFAULT NULL,
  `password` varchar(20) DEFAULT NULL,
  `updated` char(1) DEFAULT NULL,
  `reviews` smallint(6) DEFAULT NULL,
  `avg_review` float(4,2) DEFAULT NULL,
  `last_updated` datetime DEFAULT NULL,
  `official_review` text,
  `keywords` varchar(255) DEFAULT NULL,
  `cat1` mediumint(6) NOT NULL DEFAULT '0',
  `cat2` mediumint(6) NOT NULL DEFAULT '0',
  `suspended` char(1) NOT NULL DEFAULT '0',
  `reciprocal_url` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `zip` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `fax` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_link_temp`
--


--
-- Table structure for table `idx_link_temp_user`
--

CREATE TABLE `idx_link_temp_user` (
  `vid` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `username` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_link_temp_user`
--


--
-- Table structure for table `idx_link_user`
--

CREATE TABLE `idx_link_user` (
  `link_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `username` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_link_user`
--


--
-- Table structure for table `idx_mailing_list`
--

CREATE TABLE `idx_mailing_list` (
  `email` varchar(50) NOT NULL DEFAULT '',
  `code` varchar(4) DEFAULT NULL,
  `status` char(1) DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_mailing_list`
--


--
-- Table structure for table `idx_message`
--

CREATE TABLE `idx_message` (
  `message_id` smallint(6) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `body` text,
  `subject` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_message`
--


--
-- Table structure for table `idx_notification`
--

CREATE TABLE `idx_notification` (
  `username` varchar(20) NOT NULL DEFAULT '',
  `category_id` mediumint(9) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_notification`
--


--
-- Table structure for table `idx_pagerank`
--

CREATE TABLE `idx_pagerank` (
  `link_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `engine` char(1) NOT NULL DEFAULT '',
  `rank` tinyint(4) NOT NULL DEFAULT '0',
  `last_update` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`link_id`,`engine`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_pagerank`
--

INSERT INTO `idx_pagerank` VALUES (1,'g',0,'2012-02-23'),(4,'g',0,'2012-02-23'),(6,'g',0,'2011-10-16'),(2,'g',0,'2012-02-23'),(12,'g',0,'2012-02-23'),(7,'g',0,'2012-02-23'),(11,'g',0,'2011-10-29'),(8,'g',0,'2012-01-15'),(10,'g',0,'2012-01-15'),(9,'g',0,'2011-12-11'),(3,'g',0,'2012-02-29'),(5,'g',0,'2011-12-11'),(13,'g',0,'2011-11-10'),(47,'g',0,'2011-11-28'),(415,'g',0,'2011-11-28'),(337,'g',0,'2011-11-28'),(455,'g',0,'2011-11-28'),(135,'g',0,'2011-11-28'),(552,'g',0,'2011-11-28'),(343,'g',0,'2011-11-28'),(187,'g',0,'2011-11-28'),(469,'g',0,'2011-11-28'),(138,'g',0,'2011-11-28'),(115,'g',0,'2011-11-28'),(564,'g',0,'2011-11-28'),(264,'g',0,'2011-11-28'),(496,'g',0,'2011-11-28'),(605,'g',0,'2011-11-28'),(565,'g',0,'2011-11-28'),(255,'g',0,'2011-11-28'),(701,'g',0,'2011-11-28'),(278,'g',0,'2011-11-29'),(450,'g',0,'2011-11-29'),(77,'g',0,'2011-11-29'),(118,'g',0,'2011-11-29'),(88,'g',0,'2011-11-29'),(18,'g',0,'2011-11-29'),(259,'g',0,'2011-11-29'),(141,'g',0,'2011-11-29'),(171,'g',0,'2011-11-29'),(229,'g',0,'2011-11-29'),(213,'g',0,'2011-11-29'),(366,'g',0,'2011-11-29'),(206,'g',0,'2011-11-29'),(332,'g',0,'2011-11-29'),(422,'g',0,'2011-11-29'),(168,'g',0,'2011-11-29'),(108,'g',0,'2011-11-29'),(401,'g',0,'2011-11-29'),(426,'g',0,'2011-11-29'),(425,'g',0,'2011-11-29'),(329,'g',0,'2011-11-29'),(186,'g',0,'2011-11-29'),(114,'g',0,'2011-11-29'),(56,'g',0,'2011-11-29'),(103,'g',0,'2011-11-29'),(42,'g',0,'2011-11-29'),(394,'g',0,'2011-11-29'),(454,'g',0,'2011-11-29'),(416,'g',0,'2011-11-29'),(105,'g',0,'2011-11-29'),(281,'g',0,'2011-11-29'),(38,'g',0,'2011-11-29'),(661,'g',0,'2011-11-29'),(191,'g',0,'2011-11-29'),(1384,'g',0,'2011-11-29'),(151,'g',0,'2011-11-29'),(109,'g',0,'2011-11-29'),(166,'g',0,'2011-11-29'),(358,'g',0,'2011-11-30'),(349,'g',0,'2011-11-30'),(55,'g',0,'2011-11-30'),(210,'g',0,'2011-11-30'),(428,'g',0,'2011-11-30'),(101,'g',0,'2011-11-30'),(559,'g',0,'2011-11-30'),(553,'g',0,'2011-11-30'),(117,'g',0,'2011-11-30'),(39,'g',0,'2011-11-30'),(136,'g',0,'2011-11-30'),(107,'g',0,'2011-11-30'),(427,'g',0,'2011-11-30'),(161,'g',0,'2011-11-30'),(180,'g',0,'2011-11-30'),(26,'g',0,'2011-11-30'),(341,'g',0,'2011-11-30'),(67,'g',0,'2011-11-30'),(418,'g',0,'2011-11-30'),(33,'g',0,'2011-11-30'),(75,'g',0,'2011-11-30'),(214,'g',0,'2011-11-30'),(146,'g',0,'2011-11-30'),(1447,'g',0,'2011-11-30'),(723,'g',0,'2011-11-30'),(959,'g',0,'2011-11-30'),(237,'g',0,'2011-11-30'),(336,'g',0,'2011-11-30'),(119,'g',0,'2011-11-30'),(80,'g',0,'2011-11-30'),(165,'g',0,'2011-11-30'),(110,'g',0,'2011-11-30'),(140,'g',0,'2011-11-30'),(58,'g',0,'2011-11-30'),(40,'g',0,'2011-11-30'),(89,'g',0,'2011-11-30'),(152,'g',0,'2011-11-30'),(81,'g',0,'2011-11-30'),(124,'g',0,'2011-11-30'),(134,'g',0,'2011-11-30'),(113,'g',0,'2011-11-30'),(79,'g',0,'2011-11-30'),(312,'g',0,'2011-11-30'),(93,'g',0,'2011-11-30'),(43,'g',0,'2011-11-30'),(60,'g',0,'2011-11-30'),(61,'g',0,'2011-12-01'),(62,'g',0,'2011-12-01'),(98,'g',0,'2011-12-01'),(74,'g',0,'2011-12-01'),(50,'g',0,'2011-12-01'),(82,'g',0,'2011-12-01'),(94,'g',0,'2011-12-01'),(16,'g',0,'2011-12-02'),(19,'g',0,'2011-12-02'),(376,'g',0,'2011-12-02'),(144,'g',0,'2011-12-02'),(268,'g',0,'2011-12-02'),(372,'g',0,'2011-12-02'),(379,'g',0,'2011-12-02'),(377,'g',0,'2011-12-02'),(373,'g',0,'2011-12-02'),(375,'g',0,'2011-12-02'),(23,'g',0,'2011-12-02'),(21,'g',0,'2011-12-02'),(421,'g',0,'2011-12-02'),(472,'g',0,'2011-12-02'),(51,'g',0,'2011-12-02'),(549,'g',0,'2011-12-02'),(272,'g',0,'2011-12-02'),(1130,'g',0,'2011-12-02'),(436,'g',0,'2011-12-02'),(32,'g',0,'2011-12-02'),(471,'g',0,'2011-12-02'),(52,'g',0,'2011-12-02'),(837,'g',0,'2011-12-02'),(1164,'g',0,'2011-12-02'),(35,'g',0,'2011-12-02'),(1423,'g',0,'2011-12-02'),(652,'g',0,'2011-12-02'),(459,'g',0,'2011-12-02'),(17,'g',0,'2011-12-02'),(30,'g',0,'2011-12-02'),(700,'g',0,'2011-12-02'),(31,'g',0,'2011-12-02'),(408,'g',0,'2011-12-02'),(28,'g',0,'2011-12-02'),(127,'g',0,'2011-12-02'),(34,'g',0,'2011-12-02'),(442,'g',0,'2011-12-02'),(27,'g',0,'2011-12-02'),(126,'g',0,'2011-12-02'),(1375,'g',0,'2011-12-02'),(1271,'g',0,'2011-12-02'),(595,'g',0,'2011-12-03'),(545,'g',0,'2011-12-03'),(593,'g',0,'2011-12-03'),(594,'g',0,'2011-12-03'),(470,'g',0,'2011-12-03'),(405,'g',0,'2011-12-03'),(437,'g',0,'2011-12-03'),(546,'g',0,'2011-12-03'),(592,'g',0,'2011-12-03'),(547,'g',0,'2011-12-03'),(736,'g',0,'2011-12-03'),(78,'g',0,'2011-12-03'),(57,'g',0,'2011-12-03'),(37,'g',0,'2011-12-03'),(36,'g',0,'2011-12-03'),(25,'g',0,'2011-12-03'),(704,'g',0,'2011-12-03'),(279,'g',0,'2011-12-03'),(14,'g',0,'2011-12-03'),(713,'g',0,'2011-12-03'),(1001,'g',0,'2011-12-03'),(585,'g',0,'2011-12-03'),(287,'g',0,'2011-12-03'),(45,'g',0,'2011-12-03'),(399,'g',0,'2011-12-03'),(48,'g',0,'2011-12-03'),(446,'g',0,'2011-12-03'),(41,'g',0,'2011-12-03'),(150,'g',0,'2011-12-03'),(603,'g',0,'2011-12-03'),(189,'g',0,'2011-12-03'),(143,'g',0,'2011-12-03'),(172,'g',0,'2011-12-03'),(121,'g',0,'2011-12-03'),(154,'g',0,'2011-12-03'),(518,'g',0,'2011-12-03'),(254,'g',0,'2011-12-03'),(46,'g',0,'2011-12-03'),(744,'g',0,'2011-12-03'),(76,'g',0,'2011-12-03'),(120,'g',0,'2011-12-03'),(304,'g',0,'2011-12-03'),(798,'g',0,'2011-12-03'),(112,'g',0,'2011-12-03'),(262,'g',0,'2011-12-03'),(174,'g',0,'2011-12-03'),(236,'g',0,'2011-12-03'),(632,'g',0,'2011-12-03'),(506,'g',0,'2011-12-03'),(130,'g',0,'2011-12-03'),(435,'g',0,'2011-12-03'),(494,'g',0,'2011-12-03'),(84,'g',0,'2011-12-03'),(44,'g',0,'2011-12-03'),(131,'g',0,'2011-12-03'),(15,'g',0,'2011-12-03'),(66,'g',0,'2011-12-03'),(22,'g',0,'2011-12-03'),(20,'g',0,'2011-12-03'),(474,'g',0,'2011-12-03'),(148,'g',0,'2011-12-03'),(266,'g',0,'2011-12-03'),(814,'g',0,'2011-12-03'),(29,'g',0,'2011-12-03'),(92,'g',0,'2011-12-03'),(162,'g',0,'2011-12-03'),(104,'g',0,'2011-12-03'),(525,'g',0,'2011-12-03'),(964,'g',0,'2011-12-03'),(524,'g',0,'2011-12-03'),(342,'g',0,'2011-12-03'),(242,'g',0,'2011-12-03'),(487,'g',0,'2011-12-03'),(250,'g',0,'2011-12-03'),(591,'g',0,'2011-12-03'),(972,'g',0,'2011-12-03'),(636,'g',0,'2011-12-03'),(53,'g',0,'2011-12-04'),(497,'g',0,'2011-12-04'),(64,'g',0,'2011-12-04'),(253,'g',0,'2011-12-04'),(393,'g',0,'2011-12-04'),(514,'g',0,'2011-12-04'),(484,'g',0,'2011-12-04'),(598,'g',0,'2011-12-04'),(502,'g',0,'2011-12-04'),(163,'g',0,'2011-12-04'),(100,'g',0,'2011-12-05'),(224,'g',0,'2011-12-05'),(72,'g',0,'2011-12-05'),(217,'g',0,'2011-12-05'),(63,'g',0,'2011-12-05'),(24,'g',0,'2011-12-05'),(54,'g',0,'2011-12-05'),(480,'g',0,'2011-12-05'),(434,'g',0,'2011-12-05'),(142,'g',0,'2011-12-05'),(498,'g',0,'2011-12-05'),(456,'g',0,'2011-12-05'),(139,'g',0,'2011-12-05'),(384,'g',0,'2011-12-05'),(228,'g',0,'2011-12-05'),(232,'g',0,'2011-12-05'),(177,'g',0,'2011-12-05'),(70,'g',0,'2011-12-05'),(111,'g',0,'2011-12-05'),(274,'g',0,'2011-12-05'),(781,'g',0,'2011-12-06'),(2271,'g',0,'2011-12-06'),(2901,'g',0,'2011-12-06'),(582,'g',0,'2011-12-06'),(409,'g',0,'2011-12-06'),(65,'g',0,'2011-12-06'),(49,'g',0,'2011-12-06'),(985,'g',0,'2011-12-06'),(787,'g',0,'2011-12-06'),(263,'g',0,'2011-12-06'),(59,'g',0,'2011-12-06'),(771,'g',0,'2011-12-06'),(87,'g',0,'2011-12-08'),(809,'g',0,'2011-12-08'),(3166,'g',0,'2011-12-08'),(2337,'g',0,'2011-12-08'),(1537,'g',0,'2011-12-08'),(3730,'g',0,'2011-12-08'),(3100,'g',0,'2011-12-08'),(1180,'g',0,'2011-12-10'),(3538,'g',0,'2011-12-10'),(702,'g',0,'2011-12-10'),(2974,'g',0,'2011-12-10'),(3805,'g',0,'2011-12-10'),(2709,'g',0,'2011-12-10'),(981,'g',0,'2011-12-10'),(1709,'g',0,'2011-12-10'),(3338,'g',0,'2011-12-10'),(2509,'g',0,'2011-12-10'),(1425,'g',0,'2011-12-10'),(1909,'g',0,'2011-12-10'),(2174,'g',0,'2011-12-10'),(458,'g',0,'2011-12-11'),(346,'g',0,'2011-12-11'),(523,'g',0,'2011-12-11'),(468,'g',0,'2011-12-11'),(499,'g',0,'2011-12-11'),(528,'g',0,'2011-12-11'),(530,'g',0,'2011-12-11'),(463,'g',0,'2011-12-11'),(526,'g',0,'2011-12-11'),(505,'g',0,'2011-12-11'),(527,'g',0,'2011-12-11'),(500,'g',0,'2011-12-11'),(96,'g',0,'2011-12-11'),(128,'g',0,'2011-12-11'),(145,'g',0,'2011-12-11'),(167,'g',0,'2011-12-11'),(122,'g',0,'2011-12-11'),(125,'g',0,'2011-12-11'),(133,'g',0,'2011-12-11'),(164,'g',0,'2011-12-11'),(129,'g',0,'2011-12-11'),(169,'g',0,'2011-12-11'),(215,'g',0,'2011-12-11'),(249,'g',0,'2011-12-11'),(251,'g',0,'2011-12-11'),(226,'g',0,'2011-12-11'),(188,'g',0,'2011-12-11'),(309,'g',0,'2011-12-11'),(235,'g',0,'2011-12-11'),(175,'g',0,'2011-12-11'),(320,'g',0,'2011-12-11'),(176,'g',0,'2011-12-11'),(1640,'g',0,'2011-12-11'),(1574,'g',0,'2011-12-11'),(1584,'g',0,'2011-12-11'),(1615,'g',0,'2011-12-11'),(1633,'g',0,'2011-12-11'),(1398,'g',0,'2011-12-11'),(1563,'g',0,'2011-12-11'),(1524,'g',0,'2011-12-11'),(1590,'g',0,'2011-12-11'),(1560,'g',0,'2011-12-11'),(925,'g',0,'2011-12-11'),(919,'g',0,'2011-12-11'),(917,'g',0,'2011-12-11'),(923,'g',0,'2011-12-11'),(921,'g',0,'2011-12-11'),(927,'g',0,'2011-12-11'),(924,'g',0,'2011-12-11'),(914,'g',0,'2011-12-11'),(912,'g',0,'2011-12-11'),(916,'g',0,'2011-12-11'),(930,'g',0,'2011-12-11'),(949,'g',0,'2011-12-11'),(931,'g',0,'2011-12-11'),(956,'g',0,'2011-12-11'),(1395,'g',0,'2011-12-11'),(1002,'g',0,'2011-12-11'),(1040,'g',0,'2011-12-11'),(1021,'g',0,'2011-12-11'),(1062,'g',0,'2011-12-11'),(1280,'g',0,'2011-12-11'),(4431,'g',0,'2011-12-11'),(4304,'g',0,'2011-12-11'),(4371,'g',0,'2011-12-11'),(4403,'g',0,'2011-12-11'),(4380,'g',0,'2011-12-11'),(4341,'g',0,'2011-12-11'),(4443,'g',0,'2011-12-11'),(4445,'g',0,'2011-12-11'),(4396,'g',0,'2011-12-11'),(4379,'g',0,'2011-12-11'),(4774,'g',0,'2011-12-11'),(4775,'g',0,'2011-12-11'),(4766,'g',0,'2011-12-11'),(4773,'g',0,'2011-12-11'),(4768,'g',0,'2011-12-11'),(4769,'g',0,'2011-12-11'),(4772,'g',0,'2011-12-11'),(4770,'g',0,'2011-12-11'),(4776,'g',0,'2011-12-11'),(4771,'g',0,'2011-12-11'),(4524,'g',0,'2011-12-11'),(4645,'g',0,'2011-12-11'),(4650,'g',0,'2011-12-11'),(4546,'g',0,'2011-12-11'),(4526,'g',0,'2011-12-11'),(4627,'g',0,'2011-12-11'),(4643,'g',0,'2011-12-11'),(4635,'g',0,'2011-12-11'),(4597,'g',0,'2011-12-11'),(4636,'g',0,'2012-02-07'),(4477,'g',0,'2012-02-13'),(4501,'g',0,'2012-02-13'),(4586,'g',0,'2011-12-11'),(4457,'g',0,'2012-02-13'),(4075,'g',0,'2012-02-13'),(4155,'g',0,'2011-12-11'),(4005,'g',0,'2012-02-13'),(4489,'g',0,'2012-02-13'),(3997,'g',0,'2011-12-12'),(4895,'g',0,'2011-12-12'),(4724,'g',0,'2011-12-12'),(4429,'g',0,'2011-12-12'),(4261,'g',0,'2011-12-12'),(4715,'g',0,'2011-12-12'),(4382,'g',0,'2011-12-12'),(4269,'g',0,'2011-12-12'),(4568,'g',0,'2011-12-12'),(4529,'g',0,'2011-12-12'),(4420,'g',0,'2011-12-12'),(4576,'g',0,'2011-12-12'),(4577,'g',0,'2011-12-12'),(4388,'g',0,'2011-12-12'),(4528,'g',0,'2011-12-12'),(4578,'g',0,'2011-12-12'),(4453,'g',0,'2011-12-12'),(4575,'g',0,'2011-12-12'),(4530,'g',0,'2011-12-12'),(4687,'g',0,'2011-12-12'),(4674,'g',0,'2011-12-12'),(4676,'g',0,'2011-12-12'),(4660,'g',0,'2011-12-12'),(4662,'g',0,'2011-12-12'),(4758,'g',0,'2011-12-12'),(4759,'g',0,'2011-12-12'),(4757,'g',0,'2011-12-12'),(4751,'g',0,'2011-12-12'),(4752,'g',0,'2011-12-12'),(4756,'g',0,'2011-12-12'),(4760,'g',0,'2011-12-12'),(4753,'g',0,'2011-12-12'),(4754,'g',0,'2011-12-12'),(4755,'g',0,'2011-12-12'),(4637,'g',0,'2011-12-12'),(4638,'g',0,'2011-12-12'),(4710,'g',0,'2011-12-12'),(4579,'g',0,'2011-12-12'),(4912,'g',0,'2011-12-12'),(4787,'g',0,'2011-12-12'),(4604,'g',0,'2011-12-12'),(4558,'g',0,'2011-12-12'),(4346,'g',0,'2011-12-12'),(4390,'g',0,'2011-12-12'),(4735,'g',0,'2011-12-12'),(4718,'g',0,'2011-12-12'),(4750,'g',0,'2011-12-12'),(4745,'g',0,'2011-12-12'),(4742,'g',0,'2011-12-12'),(4732,'g',0,'2011-12-12'),(4725,'g',0,'2011-12-12'),(4703,'g',0,'2011-12-12'),(4737,'g',0,'2011-12-12'),(4739,'g',0,'2011-12-12'),(4244,'g',0,'2011-12-13'),(4172,'g',0,'2011-12-13'),(4114,'g',0,'2011-12-13'),(4160,'g',0,'2012-01-24'),(4094,'g',0,'2012-01-24'),(4083,'g',0,'2012-01-24'),(4207,'g',0,'2012-01-24'),(4055,'g',0,'2012-01-24'),(4053,'g',0,'2012-01-24'),(4200,'g',0,'2012-01-24'),(4256,'g',0,'2012-01-24'),(4215,'g',0,'2012-01-24'),(4211,'g',0,'2011-12-14'),(4966,'g',0,'2011-12-14'),(4376,'g',0,'2011-12-14'),(4938,'g',0,'2011-12-14'),(4036,'g',0,'2011-12-14'),(4467,'g',0,'2011-12-14'),(4047,'g',0,'2011-12-14'),(4146,'g',0,'2011-12-14'),(4485,'g',0,'2011-12-14'),(4480,'g',0,'2011-12-14'),(4236,'g',0,'2011-12-14'),(4626,'g',0,'2012-02-28'),(4225,'g',0,'2012-01-29'),(4324,'g',0,'2012-02-28'),(4574,'g',0,'2012-02-28'),(4508,'g',0,'2012-02-28'),(4233,'g',0,'2012-02-28'),(4507,'g',0,'2012-02-28'),(4470,'g',0,'2012-02-28'),(4948,'g',0,'2011-12-14'),(4929,'g',0,'2011-12-14'),(4000,'g',0,'2011-12-14'),(4928,'g',0,'2011-12-14'),(4004,'g',0,'2012-02-07'),(4956,'g',0,'2011-12-14'),(4970,'g',0,'2011-12-14'),(4006,'g',0,'2011-12-14'),(4922,'g',0,'2011-12-14'),(4957,'g',0,'2011-12-14'),(4993,'g',0,'2011-12-15'),(4994,'g',0,'2011-12-15'),(4029,'g',0,'2012-03-07'),(4003,'g',0,'2012-03-02'),(3998,'g',0,'2011-12-16'),(4049,'g',0,'2012-03-03'),(4418,'g',0,'2011-12-16'),(4095,'g',0,'2011-12-16'),(4087,'g',0,'2012-03-03'),(4012,'g',0,'2012-03-02'),(4286,'g',0,'2011-12-16'),(4027,'g',0,'2011-12-16'),(4479,'g',0,'2012-03-03'),(4246,'g',0,'2012-03-03'),(4988,'g',0,'2012-03-03'),(4588,'g',0,'2012-03-03'),(4547,'g',0,'2012-03-03'),(4548,'g',0,'2012-03-03'),(4098,'g',0,'2012-03-03'),(4712,'g',0,'2011-12-16'),(4238,'g',0,'2012-03-03'),(4726,'g',0,'2011-12-16'),(4971,'g',0,'2011-12-17'),(4008,'g',0,'2011-12-17'),(4019,'g',0,'2011-12-17'),(5007,'g',0,'2011-12-17'),(4942,'g',0,'2011-12-17'),(5005,'g',0,'2011-12-17'),(4978,'g',0,'2011-12-17'),(5002,'g',0,'2011-12-17'),(4063,'g',0,'2011-12-17'),(4081,'g',0,'2011-12-17'),(4033,'g',0,'2011-12-17'),(4981,'g',0,'2011-12-17'),(4076,'g',0,'2011-12-17'),(4135,'g',0,'2011-12-17'),(4318,'g',0,'2011-12-17'),(4294,'g',0,'2011-12-17'),(4077,'g',0,'2011-12-17'),(4102,'g',0,'2011-12-17'),(4946,'g',0,'2011-12-17'),(4121,'g',0,'2011-12-17'),(4972,'g',0,'2011-12-17'),(4933,'g',0,'2011-12-17'),(4319,'g',0,'2011-12-17'),(4920,'g',0,'2011-12-17'),(4170,'g',0,'2011-12-17'),(4030,'g',0,'2011-12-17'),(4118,'g',0,'2011-12-17'),(4961,'g',0,'2011-12-17'),(4945,'g',0,'2011-12-18'),(4965,'g',0,'2011-12-18'),(4963,'g',0,'2011-12-18'),(4954,'g',0,'2011-12-18'),(4919,'g',0,'2011-12-18'),(4935,'g',0,'2011-12-18'),(4944,'g',0,'2011-12-18'),(4020,'g',0,'2011-12-18'),(4951,'g',0,'2011-12-18'),(4962,'g',0,'2011-12-18'),(4934,'g',0,'2011-12-18'),(4953,'g',0,'2012-02-07'),(4125,'g',0,'2012-01-24'),(4969,'g',0,'2012-01-24'),(4007,'g',0,'2012-01-24'),(4046,'g',0,'2012-01-24'),(4367,'g',0,'2012-01-24'),(4122,'g',0,'2012-01-24'),(4417,'g',0,'2012-01-24'),(4932,'g',0,'2011-12-18'),(4439,'g',0,'2012-01-24'),(4941,'g',0,'2011-12-18'),(4037,'g',0,'2012-01-24'),(4960,'g',0,'2011-12-18'),(4937,'g',0,'2011-12-18'),(4926,'g',0,'2011-12-18'),(4918,'g',0,'2011-12-18'),(4220,'g',0,'2011-12-18'),(4743,'g',0,'2011-12-18'),(4925,'g',0,'2011-12-18'),(4024,'g',0,'2011-12-18'),(4058,'g',0,'2011-12-18'),(4193,'g',0,'2011-12-18'),(4129,'g',0,'2011-12-18'),(4197,'g',0,'2011-12-18'),(4060,'g',0,'2011-12-18'),(4959,'g',0,'2011-12-18'),(4992,'g',0,'2011-12-18'),(4212,'g',0,'2011-12-18'),(4931,'g',0,'2011-12-18'),(4260,'g',0,'2011-12-18'),(5008,'g',0,'2011-12-18'),(4392,'g',0,'2012-02-07'),(4245,'g',0,'2012-02-07'),(4048,'g',0,'2012-02-07'),(4032,'g',0,'2012-02-07'),(4042,'g',0,'2012-02-07'),(4565,'g',0,'2012-02-07'),(4633,'g',0,'2012-02-07'),(5015,'g',0,'2011-12-20'),(4196,'g',0,'2011-12-20'),(4025,'g',0,'2011-12-20'),(4174,'g',0,'2011-12-20'),(4169,'g',0,'2011-12-20'),(4405,'g',0,'2011-12-20'),(4349,'g',0,'2011-12-20'),(4151,'g',0,'2011-12-20'),(4149,'g',0,'2011-12-20'),(4982,'g',0,'2011-12-20'),(4377,'g',0,'2011-12-20'),(4656,'g',0,'2011-12-20'),(5014,'g',0,'2012-02-07'),(4441,'g',0,'2012-02-12'),(4713,'g',0,'2012-02-12'),(4039,'g',0,'2012-02-13'),(4409,'g',0,'2011-12-22'),(4384,'g',0,'2011-12-22'),(4979,'g',0,'2012-02-13'),(4399,'g',0,'2011-12-22'),(4331,'g',0,'2011-12-22'),(4311,'g',0,'2011-12-22'),(4968,'g',0,'2012-02-13'),(4340,'g',0,'2011-12-22'),(4408,'g',0,'2011-12-22'),(4067,'g',0,'2011-12-22'),(4145,'g',0,'2011-12-22'),(4974,'g',0,'2011-12-22'),(4131,'g',0,'2011-12-22'),(4104,'g',0,'2011-12-22'),(4133,'g',0,'2011-12-22'),(4103,'g',0,'2011-12-22'),(4113,'g',0,'2011-12-22'),(4137,'g',0,'2011-12-22'),(4463,'g',0,'2011-12-22'),(5034,'g',0,'2011-12-22'),(5012,'g',0,'2011-12-22'),(5022,'g',0,'2011-12-22'),(4038,'g',0,'2011-12-23'),(5000,'g',0,'2011-12-23'),(4947,'g',0,'2011-12-23'),(4022,'g',0,'2011-12-23'),(5001,'g',0,'2011-12-23'),(4050,'g',0,'2011-12-23'),(5029,'g',0,'2011-12-23'),(4084,'g',0,'2011-12-23'),(4254,'g',0,'2012-01-28'),(4109,'g',0,'2012-01-28'),(4442,'g',0,'2012-01-28'),(4014,'g',0,'2012-01-28'),(4419,'g',0,'2012-01-28'),(4404,'g',0,'2012-01-28'),(4454,'g',0,'2011-12-23'),(4015,'g',0,'2012-01-28'),(5043,'g',0,'2011-12-23'),(4110,'g',0,'2012-01-28'),(4425,'g',0,'2012-03-04'),(4391,'g',0,'2012-03-04'),(4647,'g',0,'2012-03-04'),(4711,'g',0,'2011-12-23'),(4532,'g',0,'2012-03-04'),(5025,'g',0,'2011-12-24'),(4998,'g',0,'2011-12-24'),(4983,'g',0,'2011-12-24'),(5027,'g',0,'2012-02-07'),(5019,'g',0,'2011-12-25'),(5003,'g',0,'2012-01-29'),(4976,'g',0,'2011-12-25'),(5017,'g',0,'2011-12-25'),(4659,'g',0,'2011-12-25'),(4438,'g',0,'2011-12-25'),(4535,'g',0,'2011-12-25'),(4607,'g',0,'2011-12-25'),(4654,'g',0,'2011-12-25'),(4348,'g',0,'2011-12-25'),(4651,'g',0,'2011-12-25'),(4398,'g',0,'2011-12-25'),(4670,'g',0,'2011-12-25'),(4452,'g',0,'2011-12-25'),(4543,'g',0,'2011-12-26'),(4481,'g',0,'2011-12-26'),(4490,'g',0,'2011-12-26'),(4550,'g',0,'2011-12-26'),(4561,'g',0,'2011-12-26'),(4549,'g',0,'2011-12-26'),(4984,'g',0,'2011-12-26'),(4985,'g',0,'2011-12-26'),(4999,'g',0,'2011-12-26'),(4973,'g',0,'2011-12-26'),(4967,'g',0,'2011-12-26'),(4991,'g',0,'2011-12-26'),(4987,'g',0,'2011-12-26'),(5024,'g',0,'2011-12-26'),(4996,'g',0,'2011-12-26'),(4989,'g',0,'2011-12-26'),(4023,'g',0,'2011-12-26'),(4995,'g',0,'2011-12-26'),(4997,'g',0,'2011-12-26'),(4239,'g',0,'2011-12-26'),(4199,'g',0,'2011-12-26'),(4195,'g',0,'2011-12-26'),(4570,'g',0,'2011-12-26'),(4668,'g',0,'2011-12-26'),(4288,'g',0,'2011-12-26'),(4416,'g',0,'2011-12-26'),(4082,'g',0,'2011-12-26'),(4493,'g',0,'2011-12-26'),(4496,'g',0,'2011-12-26'),(4085,'g',0,'2011-12-26'),(4235,'g',0,'2011-12-26'),(4402,'g',0,'2011-12-26'),(5018,'g',0,'2011-12-26'),(4556,'g',0,'2011-12-26'),(4525,'g',0,'2011-12-26'),(4120,'g',0,'2011-12-26'),(4070,'g',0,'2011-12-26'),(4073,'g',0,'2011-12-26'),(4074,'g',0,'2011-12-26'),(4040,'g',0,'2011-12-26'),(4130,'g',0,'2011-12-26'),(4444,'g',0,'2011-12-26'),(4061,'g',0,'2011-12-26'),(4465,'g',0,'2011-12-26'),(4078,'g',0,'2011-12-26'),(4448,'g',0,'2011-12-26'),(4469,'g',0,'2011-12-26'),(4478,'g',0,'2011-12-26'),(4472,'g',0,'2011-12-26'),(4427,'g',0,'2011-12-26'),(4284,'g',0,'2011-12-26'),(4271,'g',0,'2011-12-26'),(4287,'g',0,'2011-12-26'),(4290,'g',0,'2011-12-26'),(4628,'g',0,'2011-12-26'),(4285,'g',0,'2011-12-26'),(4289,'g',0,'2011-12-26'),(4257,'g',0,'2011-12-26'),(5016,'g',0,'2011-12-26'),(4630,'g',0,'2011-12-26'),(4296,'g',0,'2011-12-26'),(4679,'g',0,'2011-12-26'),(4370,'g',0,'2011-12-26'),(4649,'g',0,'2011-12-26'),(4612,'g',0,'2011-12-26'),(4282,'g',0,'2011-12-26'),(4646,'g',0,'2011-12-26'),(4320,'g',0,'2011-12-26'),(4613,'g',0,'2011-12-26'),(4714,'g',0,'2011-12-26'),(4620,'g',0,'2011-12-26'),(4031,'g',0,'2011-12-26'),(4028,'g',0,'2011-12-26'),(4299,'g',0,'2011-12-26'),(4317,'g',0,'2011-12-26'),(4378,'g',0,'2011-12-26'),(4400,'g',0,'2011-12-26'),(4347,'g',0,'2011-12-26'),(4385,'g',0,'2011-12-26'),(4357,'g',0,'2011-12-26'),(4567,'g',0,'2011-12-26'),(4251,'g',0,'2011-12-26'),(4539,'g',0,'2011-12-26'),(4495,'g',0,'2011-12-26'),(4393,'g',0,'2011-12-26'),(4580,'g',0,'2011-12-26'),(4162,'g',0,'2011-12-26'),(4176,'g',0,'2011-12-26'),(4253,'g',0,'2011-12-26'),(4611,'g',0,'2011-12-26'),(4249,'g',0,'2011-12-26'),(4566,'g',0,'2011-12-26'),(4164,'g',0,'2011-12-26'),(4216,'g',0,'2011-12-26'),(4163,'g',0,'2011-12-26'),(4124,'g',0,'2011-12-26'),(4167,'g',0,'2011-12-26'),(4214,'g',0,'2011-12-26'),(4183,'g',0,'2011-12-26'),(4190,'g',0,'2011-12-26'),(4119,'g',0,'2011-12-26'),(4154,'g',0,'2011-12-26'),(5020,'g',0,'2011-12-26'),(5023,'g',0,'2011-12-27'),(4806,'g',0,'2011-12-27'),(4850,'g',0,'2011-12-27'),(4805,'g',0,'2011-12-27'),(4720,'g',0,'2011-12-27'),(4894,'g',0,'2011-12-27'),(4738,'g',0,'2011-12-27'),(4740,'g',0,'2011-12-27'),(4799,'g',0,'2011-12-27'),(4779,'g',0,'2011-12-27'),(4814,'g',0,'2011-12-27'),(4915,'g',0,'2011-12-27'),(4916,'g',0,'2011-12-27'),(5011,'g',0,'2011-12-27'),(5067,'g',0,'2011-12-27'),(5072,'g',0,'2011-12-27'),(4595,'g',0,'2011-12-28'),(4456,'g',0,'2011-12-28'),(4455,'g',0,'2011-12-28'),(4323,'g',0,'2011-12-28'),(4619,'g',0,'2011-12-28'),(4502,'g',0,'2011-12-28'),(4433,'g',0,'2011-12-28'),(4517,'g',0,'2011-12-28'),(4608,'g',0,'2011-12-28'),(4741,'g',0,'2011-12-28'),(4228,'g',0,'2011-12-28'),(4563,'g',0,'2011-12-28'),(4401,'g',0,'2011-12-28'),(4491,'g',0,'2011-12-28'),(4204,'g',0,'2011-12-28'),(4609,'g',0,'2011-12-28'),(4148,'g',0,'2011-12-28'),(4175,'g',0,'2011-12-28'),(4117,'g',0,'2011-12-28'),(4057,'g',0,'2011-12-28'),(4173,'g',0,'2011-12-28'),(4123,'g',0,'2011-12-28'),(4096,'g',0,'2011-12-28'),(4107,'g',0,'2011-12-28'),(4093,'g',0,'2011-12-28'),(4166,'g',0,'2011-12-28'),(4471,'g',0,'2011-12-28'),(4655,'g',0,'2011-12-28'),(4615,'g',0,'2011-12-28'),(4573,'g',0,'2011-12-28'),(4437,'g',0,'2011-12-28'),(4900,'g',0,'2011-12-28'),(4492,'g',0,'2011-12-28'),(4728,'g',0,'2011-12-28'),(4729,'g',0,'2011-12-28'),(4731,'g',0,'2011-12-28'),(4730,'g',0,'2011-12-28'),(4598,'g',0,'2011-12-28'),(4572,'g',0,'2011-12-28'),(4727,'g',0,'2011-12-28'),(4734,'g',0,'2011-12-28'),(4688,'g',0,'2011-12-28'),(4694,'g',0,'2011-12-28'),(4194,'g',0,'2011-12-28'),(4354,'g',0,'2011-12-28'),(4165,'g',0,'2011-12-28'),(4389,'g',0,'2011-12-28'),(4351,'g',0,'2011-12-28'),(4369,'g',0,'2011-12-28'),(4192,'g',0,'2011-12-28'),(4191,'g',0,'2011-12-28'),(4186,'g',0,'2011-12-28'),(4180,'g',0,'2011-12-28'),(4182,'g',0,'2011-12-28'),(4188,'g',0,'2011-12-28'),(4177,'g',0,'2011-12-28'),(4184,'g',0,'2011-12-28'),(4185,'g',0,'2011-12-28'),(4178,'g',0,'2011-12-28'),(4353,'g',0,'2011-12-29'),(4202,'g',0,'2011-12-29'),(4090,'g',0,'2011-12-29'),(4241,'g',0,'2011-12-29'),(4071,'g',0,'2011-12-29'),(4364,'g',0,'2011-12-29'),(4553,'g',0,'2011-12-29'),(4144,'g',0,'2011-12-29'),(4226,'g',0,'2011-12-29'),(4459,'g',0,'2011-12-29'),(4476,'g',0,'2011-12-29'),(4205,'g',0,'2011-12-29'),(4487,'g',0,'2011-12-29'),(4352,'g',0,'2011-12-29'),(4397,'g',0,'2011-12-29'),(4301,'g',0,'2011-12-29'),(4313,'g',0,'2011-12-29'),(4136,'g',0,'2011-12-29'),(4259,'g',0,'2011-12-29'),(4101,'g',0,'2011-12-29'),(4247,'g',0,'2011-12-29'),(4321,'g',0,'2011-12-29'),(4134,'g',0,'2011-12-29'),(4140,'g',0,'2011-12-29'),(4297,'g',0,'2011-12-29'),(4115,'g',0,'2011-12-29'),(4099,'g',0,'2011-12-29'),(4350,'g',0,'2011-12-29'),(4106,'g',0,'2011-12-29'),(4181,'g',0,'2011-12-29'),(4100,'g',0,'2011-12-29'),(4089,'g',0,'2011-12-29'),(4138,'g',0,'2011-12-29'),(4327,'g',0,'2011-12-29'),(4223,'g',0,'2011-12-29'),(4132,'g',0,'2011-12-29'),(4461,'g',0,'2011-12-29'),(4582,'g',0,'2011-12-29'),(4203,'g',0,'2011-12-29'),(4475,'g',0,'2011-12-29'),(4139,'g',0,'2011-12-29'),(4316,'g',0,'2011-12-29'),(4243,'g',0,'2011-12-29'),(4295,'g',0,'2011-12-29'),(4474,'g',0,'2011-12-29'),(4080,'g',0,'2011-12-29'),(4305,'g',0,'2011-12-29'),(4240,'g',0,'2011-12-29'),(4208,'g',0,'2011-12-29'),(4222,'g',0,'2011-12-29'),(4473,'g',0,'2011-12-29'),(4312,'g',0,'2011-12-29'),(4013,'g',0,'2011-12-29'),(4017,'g',0,'2011-12-29'),(4310,'g',0,'2011-12-29'),(5010,'g',0,'2011-12-29'),(4309,'g',0,'2011-12-29'),(4306,'g',0,'2011-12-29'),(4307,'g',0,'2011-12-29'),(4303,'g',0,'2011-12-29'),(4280,'g',0,'2011-12-29'),(4010,'g',0,'2011-12-29'),(4412,'g',0,'2011-12-29'),(4424,'g',0,'2011-12-29'),(4413,'g',0,'2011-12-29'),(4411,'g',0,'2011-12-29'),(4410,'g',0,'2011-12-29'),(4336,'g',0,'2011-12-29'),(4168,'g',0,'2011-12-29'),(4161,'g',0,'2011-12-29'),(4156,'g',0,'2011-12-29'),(4011,'g',0,'2011-12-29'),(4308,'g',0,'2011-12-29'),(4143,'g',0,'2011-12-29'),(4201,'g',0,'2011-12-29'),(4142,'g',0,'2011-12-29'),(4187,'g',0,'2011-12-29'),(4153,'g',0,'2011-12-29'),(4179,'g',0,'2011-12-29'),(4141,'g',0,'2011-12-29'),(5060,'g',0,'2011-12-29'),(5093,'g',0,'2011-12-29'),(5061,'g',0,'2011-12-29'),(5096,'g',0,'2011-12-29'),(5080,'g',0,'2012-02-23'),(5103,'g',0,'2011-12-29'),(5058,'g',0,'2011-12-29'),(5107,'g',0,'2011-12-29'),(5059,'g',0,'2011-12-29'),(4263,'g',0,'2011-12-29'),(4086,'g',0,'2011-12-29'),(4958,'g',0,'2011-12-29'),(4088,'g',0,'2011-12-29'),(4952,'g',0,'2011-12-29'),(4189,'g',0,'2011-12-29'),(4092,'g',0,'2011-12-29'),(4314,'g',0,'2011-12-29'),(4091,'g',0,'2011-12-29'),(4097,'g',0,'2011-12-29'),(5056,'g',0,'2011-12-29'),(5081,'g',0,'2011-12-29'),(4664,'g',0,'2011-12-29'),(4640,'g',0,'2011-12-29'),(4680,'g',0,'2011-12-29'),(4661,'g',0,'2011-12-30'),(4653,'g',0,'2011-12-30'),(4594,'g',0,'2011-12-30'),(4652,'g',0,'2011-12-30'),(4666,'g',0,'2011-12-30'),(4663,'g',0,'2011-12-30'),(4642,'g',0,'2011-12-30'),(4641,'g',0,'2011-12-30'),(4624,'g',0,'2011-12-30'),(4497,'g',0,'2011-12-30'),(4581,'g',0,'2011-12-30'),(4702,'g',0,'2011-12-30'),(4571,'g',0,'2011-12-30'),(4521,'g',0,'2011-12-30'),(4537,'g',0,'2011-12-30'),(4520,'g',0,'2011-12-30'),(4339,'g',0,'2011-12-30'),(4519,'g',0,'2011-12-30'),(4414,'g',0,'2011-12-30'),(4428,'g',0,'2011-12-30'),(4343,'g',0,'2011-12-30'),(4484,'g',0,'2011-12-30'),(4407,'g',0,'2011-12-30'),(4523,'g',0,'2011-12-30'),(4406,'g',0,'2011-12-30'),(4522,'g',0,'2011-12-30'),(4534,'g',0,'2011-12-30'),(4432,'g',0,'2011-12-30'),(4449,'g',0,'2011-12-30'),(4531,'g',0,'2011-12-30'),(4342,'g',0,'2011-12-30'),(4344,'g',0,'2011-12-30'),(4544,'g',0,'2011-12-30'),(4505,'g',0,'2011-12-30'),(4592,'g',0,'2011-12-30'),(4458,'g',0,'2011-12-30'),(4450,'g',0,'2011-12-30'),(4538,'g',0,'2011-12-30'),(4515,'g',0,'2011-12-30'),(4533,'g',0,'2011-12-30'),(4415,'g',0,'2011-12-30'),(4345,'g',0,'2011-12-30'),(5100,'g',0,'2011-12-30'),(5110,'g',0,'2011-12-30'),(5106,'g',0,'2011-12-30'),(5066,'g',0,'2011-12-30'),(5076,'g',0,'2011-12-30'),(5104,'g',0,'2011-12-30'),(5101,'g',0,'2011-12-30'),(4557,'g',0,'2011-12-30'),(4569,'g',0,'2011-12-30'),(4560,'g',0,'2011-12-30'),(4434,'g',0,'2011-12-30'),(4518,'g',0,'2011-12-30'),(4466,'g',0,'2011-12-30'),(4512,'g',0,'2011-12-30'),(4559,'g',0,'2011-12-30'),(4066,'g',0,'2011-12-30'),(4052,'g',0,'2011-12-30'),(4337,'g',0,'2011-12-30'),(4068,'g',0,'2011-12-30'),(4054,'g',0,'2011-12-30'),(4069,'g',0,'2011-12-30'),(4051,'g',0,'2011-12-30'),(4035,'g',0,'2011-12-30'),(4034,'g',0,'2011-12-30'),(4018,'g',0,'2011-12-30'),(4056,'g',0,'2011-12-30'),(4950,'g',0,'2011-12-30'),(4980,'g',0,'2011-12-30'),(4977,'g',0,'2011-12-30'),(5063,'g',0,'2011-12-30'),(4748,'g',0,'2011-12-30'),(5062,'g',0,'2012-02-13'),(4744,'g',0,'2011-12-30'),(4784,'g',0,'2011-12-30'),(4255,'g',0,'2011-12-30'),(5028,'g',0,'2011-12-31'),(4362,'g',0,'2011-12-31'),(4359,'g',0,'2011-12-31'),(4789,'g',0,'2011-12-31'),(4786,'g',0,'2011-12-31'),(4242,'g',0,'2011-12-31'),(4355,'g',0,'2011-12-31'),(5026,'g',0,'2011-12-31'),(4360,'g',0,'2011-12-31'),(5099,'g',0,'2011-12-31'),(5097,'g',0,'2011-12-31'),(4746,'g',0,'2011-12-31'),(4667,'g',0,'2011-12-31'),(4964,'g',0,'2011-12-31'),(4264,'g',0,'2011-12-31'),(4829,'g',0,'2011-12-31'),(4836,'g',0,'2011-12-31'),(4356,'g',0,'2011-12-31'),(5075,'g',0,'2011-12-31'),(5071,'g',0,'2012-03-02'),(5085,'g',0,'2011-12-31'),(4262,'g',0,'2011-12-31'),(4281,'g',0,'2011-12-31'),(4300,'g',0,'2011-12-31'),(4373,'g',0,'2011-12-31'),(4224,'g',0,'2011-12-31'),(4279,'g',0,'2011-12-31'),(4267,'g',0,'2011-12-31'),(4021,'g',0,'2011-12-31'),(4009,'g',0,'2011-12-31'),(4777,'g',0,'2011-12-31'),(4818,'g',0,'2011-12-31'),(3999,'g',0,'2011-12-31'),(5109,'g',0,'2011-12-31'),(4210,'g',0,'2011-12-31'),(4785,'g',0,'2012-01-01'),(4016,'g',0,'2012-01-01'),(4955,'g',0,'2012-01-01'),(4812,'g',0,'2012-01-01'),(4795,'g',0,'2012-01-01'),(4797,'g',0,'2012-01-01'),(4832,'g',0,'2012-01-01'),(4833,'g',0,'2012-01-01'),(4835,'g',0,'2012-01-01'),(4885,'g',0,'2012-01-01'),(4250,'g',0,'2012-01-01'),(4127,'g',0,'2012-01-01'),(4002,'g',0,'2012-01-01'),(4358,'g',0,'2012-01-01'),(5083,'g',0,'2012-01-01'),(4436,'g',0,'2012-01-01'),(4672,'g',0,'2012-01-01'),(4555,'g',0,'2012-01-01'),(4277,'g',0,'2012-01-01'),(4274,'g',0,'2012-01-01'),(4276,'g',0,'2012-01-01'),(5069,'g',0,'2012-01-01'),(4815,'g',0,'2012-01-01'),(4794,'g',0,'2012-01-01'),(4834,'g',0,'2012-01-01'),(5082,'g',0,'2012-01-01'),(5055,'g',0,'2012-01-01'),(4541,'g',0,'2012-01-01'),(4227,'g',0,'2012-01-01'),(4828,'g',0,'2012-01-01'),(4801,'g',0,'2012-01-01'),(4886,'g',0,'2012-01-01'),(4883,'g',0,'2012-01-01'),(5094,'g',0,'2012-01-01'),(5090,'g',0,'2012-01-01'),(4283,'g',0,'2012-01-01'),(4788,'g',0,'2012-01-01'),(4206,'g',0,'2012-01-01'),(4278,'g',0,'2012-01-01'),(4266,'g',0,'2012-01-01'),(4820,'g',0,'2012-01-01'),(4826,'g',0,'2012-01-01'),(4816,'g',0,'2012-01-01'),(4831,'g',0,'2012-01-01'),(4877,'g',0,'2012-01-01'),(4881,'g',0,'2012-01-01'),(4879,'g',0,'2012-01-01'),(4837,'g',0,'2012-01-01'),(5088,'g',0,'2012-01-01'),(5087,'g',0,'2012-01-01'),(5064,'g',0,'2012-01-02'),(4217,'g',0,'2012-01-02'),(4258,'g',0,'2012-01-02'),(4275,'g',0,'2012-01-02'),(4001,'g',0,'2012-01-02'),(4270,'g',0,'2012-01-02'),(4268,'g',0,'2012-01-02'),(4781,'g',0,'2012-01-02'),(4802,'g',0,'2012-01-02'),(4800,'g',0,'2012-01-02'),(4861,'g',0,'2012-01-02'),(4838,'g',0,'2012-01-02'),(4882,'g',0,'2012-01-02'),(4856,'g',0,'2012-01-02'),(5095,'g',0,'2012-01-02'),(4298,'g',0,'2012-01-02'),(4749,'g',0,'2012-01-02'),(4796,'g',0,'2012-01-02'),(4857,'g',0,'2012-01-02'),(4858,'g',0,'2012-01-02'),(4880,'g',0,'2012-01-02'),(4867,'g',0,'2012-01-02'),(4865,'g',0,'2012-01-02'),(4884,'g',0,'2012-01-02'),(5013,'g',0,'2012-01-02'),(4617,'g',0,'2012-01-02'),(4322,'g',0,'2012-01-02'),(4421,'g',0,'2012-01-02'),(4949,'g',0,'2012-01-02'),(4827,'g',0,'2012-01-02'),(4821,'g',0,'2012-01-02'),(4843,'g',0,'2012-01-02'),(4871,'g',0,'2012-01-02'),(4849,'g',0,'2012-01-02'),(4866,'g',0,'2012-01-02'),(4863,'g',0,'2012-01-02'),(4859,'g',0,'2012-01-02'),(4868,'g',0,'2012-01-02'),(5112,'g',0,'2012-01-02'),(5084,'g',0,'2012-01-02'),(5054,'g',0,'2012-01-02'),(4329,'g',0,'2012-01-02'),(4764,'g',0,'2012-01-02'),(4803,'g',0,'2012-01-02'),(4765,'g',0,'2012-01-02'),(4869,'g',0,'2012-01-02'),(4903,'g',0,'2012-01-02'),(4872,'g',0,'2012-01-02'),(4830,'g',0,'2012-01-02'),(4841,'g',0,'2012-01-02'),(4889,'g',0,'2012-01-02'),(4847,'g',0,'2012-01-02'),(4896,'g',0,'2012-01-02'),(4890,'g',0,'2012-01-02'),(4891,'g',0,'2012-01-02'),(4887,'g',0,'2012-01-02'),(4862,'g',0,'2012-01-02'),(5078,'g',0,'2012-01-02'),(5070,'g',0,'2012-02-08'),(4516,'g',0,'2012-01-03'),(4798,'g',0,'2012-01-03'),(4762,'g',0,'2012-01-03'),(4825,'g',0,'2012-01-03'),(4848,'g',0,'2012-01-03'),(4860,'g',0,'2012-01-03'),(4845,'g',0,'2012-01-03'),(4842,'g',0,'2012-01-03'),(4840,'g',0,'2012-01-03'),(4888,'g',0,'2012-01-03'),(4870,'g',0,'2012-01-03'),(4878,'g',0,'2012-01-03'),(4844,'g',0,'2012-01-03'),(5086,'g',0,'2012-01-03'),(4230,'g',0,'2012-01-03'),(4747,'g',0,'2012-01-03'),(4273,'g',0,'2012-01-03'),(4763,'g',0,'2012-01-03'),(4819,'g',0,'2012-01-03'),(4864,'g',0,'2012-01-03'),(4897,'g',0,'2012-01-03'),(4793,'g',0,'2012-01-03'),(4422,'g',0,'2012-01-03'),(4824,'g',0,'2012-01-03'),(4873,'g',0,'2012-01-03'),(4846,'g',0,'2012-01-03'),(5091,'g',0,'2012-01-03'),(4272,'g',0,'2012-01-03'),(4823,'g',0,'2012-01-03'),(4822,'g',0,'2012-01-03'),(4839,'g',0,'2012-01-03'),(4876,'g',0,'2012-01-03'),(5136,'g',0,'2012-01-03'),(5130,'g',0,'2012-01-04'),(5124,'g',0,'2012-01-04'),(5135,'g',0,'2012-02-16'),(5143,'g',0,'2012-02-07'),(5134,'g',0,'2012-01-04'),(5128,'g',0,'2012-01-04'),(5142,'g',0,'2012-01-04'),(5113,'g',0,'2012-01-05'),(5108,'g',0,'2012-01-05'),(5118,'g',0,'2012-02-21'),(5068,'g',0,'2012-01-05'),(5065,'g',0,'2012-01-05'),(5057,'g',0,'2012-01-05'),(5098,'g',0,'2012-01-05'),(5105,'g',0,'2012-01-05'),(5146,'g',0,'2012-01-06'),(5133,'g',0,'2012-01-06'),(5131,'g',0,'2012-01-07'),(5148,'g',0,'2012-01-07'),(5137,'g',0,'2012-01-07'),(5149,'g',0,'2012-01-07'),(5153,'g',0,'2012-01-07'),(5079,'g',0,'2012-01-07'),(5074,'g',0,'2012-01-07'),(5073,'g',0,'2012-01-08'),(5154,'g',0,'2012-01-08'),(5156,'g',0,'2012-01-08'),(5102,'g',0,'2012-02-08'),(5193,'g',0,'2012-01-09'),(5189,'g',0,'2012-02-21'),(5192,'g',0,'2012-01-09'),(5169,'g',0,'2012-01-09'),(5170,'g',0,'2012-01-09'),(5181,'g',0,'2012-01-11'),(5207,'g',0,'2012-01-11'),(5182,'g',0,'2012-01-11'),(5117,'g',0,'2012-01-11'),(5129,'g',0,'2012-01-11'),(4265,'g',0,'2012-01-13'),(5195,'g',0,'2012-01-13'),(5198,'g',0,'2012-01-13'),(5221,'g',0,'2012-01-13'),(5147,'g',0,'2012-01-13'),(5183,'g',0,'2012-01-13'),(5155,'g',0,'2012-01-13'),(5150,'g',0,'2012-01-13'),(5191,'g',0,'2012-01-13'),(5176,'g',0,'2012-01-13'),(5172,'g',0,'2012-01-13'),(5187,'g',0,'2012-01-14'),(5223,'g',0,'2012-01-14'),(5171,'g',0,'2012-01-14'),(5163,'g',0,'2012-01-14'),(5174,'g',0,'2012-01-14'),(5225,'g',0,'2012-01-14'),(5208,'g',0,'2012-01-14'),(5184,'g',0,'2012-01-14'),(5212,'g',0,'2012-01-14'),(5157,'g',0,'2012-03-07'),(5173,'g',0,'2012-01-14'),(5166,'g',0,'2012-01-14'),(5234,'g',0,'2012-01-15'),(5228,'g',0,'2012-03-02'),(5202,'g',0,'2012-01-15'),(5203,'g',0,'2012-03-02'),(5092,'g',0,'2012-01-15'),(5132,'g',0,'2012-01-16'),(5138,'g',0,'2012-01-16'),(5077,'g',0,'2012-01-16'),(5021,'g',0,'2012-01-16'),(5167,'g',0,'2012-01-16'),(5141,'g',0,'2012-01-16'),(5179,'g',0,'2012-01-16'),(5165,'g',0,'2012-01-16'),(5123,'g',0,'2012-01-16'),(5126,'g',0,'2012-01-16'),(5116,'g',0,'2012-01-16'),(5194,'g',0,'2012-01-16'),(5115,'g',0,'2012-01-16'),(5200,'g',0,'2012-01-17'),(5185,'g',0,'2012-01-17'),(5140,'g',0,'2012-01-17'),(5168,'g',0,'2012-01-17'),(5122,'g',0,'2012-01-17'),(5178,'g',0,'2012-01-17'),(5211,'g',0,'2012-03-04'),(5177,'g',0,'2012-01-17'),(5111,'g',0,'2012-01-17'),(5214,'g',0,'2012-01-17'),(5180,'g',0,'2012-01-17'),(5287,'g',0,'2012-01-19'),(5209,'g',0,'2012-01-19'),(5224,'g',0,'2012-01-19'),(5188,'g',0,'2012-01-19'),(5151,'g',0,'2012-01-19'),(5186,'g',0,'2012-01-19'),(5190,'g',0,'2012-01-19'),(5159,'g',0,'2012-01-19'),(5266,'g',0,'2012-01-19'),(5265,'g',0,'2012-01-19'),(5269,'g',0,'2012-01-19'),(5267,'g',0,'2012-01-19'),(5248,'g',0,'2012-01-19'),(5237,'g',0,'2012-01-19'),(5264,'g',0,'2012-01-19'),(5268,'g',0,'2012-01-19'),(5273,'g',0,'2012-01-19'),(5286,'g',0,'2012-01-19'),(5205,'g',0,'2012-01-19'),(5219,'g',0,'2012-01-19'),(5204,'g',0,'2012-01-19'),(5164,'g',0,'2012-01-19'),(5161,'g',0,'2012-01-19'),(5236,'g',0,'2012-01-19'),(5278,'g',0,'2012-01-19'),(5139,'g',0,'2012-01-19'),(5162,'g',0,'2012-01-19'),(5160,'g',0,'2012-01-19'),(5175,'g',0,'2012-01-19'),(5258,'g',0,'2012-02-21'),(5210,'g',0,'2012-02-21'),(5201,'g',0,'2012-02-21'),(5152,'g',0,'2012-01-20'),(5239,'g',0,'2012-01-20'),(5206,'g',0,'2012-01-20'),(5213,'g',0,'2012-01-21'),(5270,'g',0,'2012-01-21'),(5262,'g',0,'2012-01-21'),(5256,'g',0,'2012-01-22'),(5244,'g',0,'2012-01-22'),(5285,'g',0,'2012-01-22'),(5263,'g',0,'2012-01-22'),(5277,'g',0,'2012-01-22'),(5254,'g',0,'2012-01-22'),(5243,'g',0,'2012-01-22'),(5275,'g',0,'2012-01-22'),(5272,'g',0,'2012-01-22'),(5261,'g',0,'2012-01-22'),(5247,'g',0,'2012-01-22'),(5260,'g',0,'2012-01-22'),(5304,'g',0,'2012-01-22'),(5283,'g',0,'2012-01-22'),(5280,'g',0,'2012-01-22'),(5220,'g',0,'2012-02-21'),(5276,'g',0,'2012-01-22'),(5251,'g',0,'2012-01-22'),(5306,'g',0,'2012-03-02'),(5259,'g',0,'2012-03-02'),(5284,'g',0,'2012-03-03'),(5279,'g',0,'2012-03-03'),(5281,'g',0,'2012-03-02'),(5249,'g',0,'2012-03-03'),(5246,'g',0,'2012-03-03'),(5257,'g',0,'2012-01-23'),(5318,'g',0,'2012-01-23'),(5310,'g',0,'2012-01-23'),(5282,'g',0,'2012-02-23'),(5245,'g',0,'2012-02-23'),(5238,'g',0,'2012-01-24'),(5216,'g',0,'2012-01-24'),(5218,'g',0,'2012-01-24'),(5271,'g',0,'2012-01-24'),(5229,'g',0,'2012-01-24'),(5217,'g',0,'2012-01-24'),(5252,'g',0,'2012-01-24'),(5222,'g',0,'2012-01-24'),(5226,'g',0,'2012-01-24'),(5255,'g',0,'2012-01-24'),(5307,'g',0,'2012-03-07'),(5215,'g',0,'2012-01-24'),(5305,'g',0,'2012-01-24'),(4917,'g',0,'2012-01-24'),(4719,'g',0,'2012-01-24'),(4851,'g',0,'2012-01-24'),(4898,'g',0,'2012-01-24'),(4811,'g',0,'2012-01-24'),(4913,'g',0,'2012-01-24'),(4852,'g',0,'2012-01-24'),(4810,'g',0,'2012-01-24'),(4723,'g',0,'2012-01-24'),(4695,'g',0,'2012-01-24'),(4975,'g',0,'2012-01-24'),(4716,'g',0,'2012-01-24'),(4704,'g',0,'2012-01-24'),(4686,'g',0,'2012-01-24'),(4696,'g',0,'2012-01-24'),(5320,'g',0,'2012-01-25'),(5323,'g',0,'2012-01-25'),(5321,'g',0,'2012-01-25'),(5311,'g',0,'2012-01-25'),(5326,'g',0,'2012-01-25'),(5144,'g',0,'2012-02-25'),(5314,'g',0,'2012-01-26'),(5324,'g',0,'2012-01-26'),(5328,'g',0,'2012-01-27'),(5330,'g',0,'2012-01-27'),(5339,'g',0,'2012-01-27'),(5344,'g',0,'2012-01-27'),(5335,'g',0,'2012-01-28'),(5241,'g',0,'2012-01-28'),(5309,'g',0,'2012-01-28'),(5347,'g',0,'2012-01-28'),(5250,'g',0,'2012-01-28'),(5274,'g',0,'2012-01-28'),(5312,'g',0,'2012-01-28'),(5253,'g',0,'2012-01-28'),(5342,'g',0,'2012-01-28'),(5343,'g',0,'2012-01-28'),(5331,'g',0,'2012-01-28'),(5357,'g',0,'2012-01-28'),(5358,'g',0,'2012-01-28'),(5355,'g',0,'2012-01-29'),(5333,'g',0,'2012-01-29'),(5351,'g',0,'2012-01-29'),(5303,'g',0,'2012-01-29'),(5332,'g',0,'2012-01-29'),(5317,'g',0,'2012-01-29'),(5353,'g',0,'2012-01-29'),(5349,'g',0,'2012-01-29'),(5316,'g',0,'2012-01-29'),(5301,'g',0,'2012-01-29'),(5350,'g',0,'2012-01-29'),(5352,'g',0,'2012-01-29'),(5302,'g',0,'2012-01-29'),(5288,'g',0,'2012-01-29'),(4761,'g',0,'2012-01-29'),(5319,'g',0,'2012-01-30'),(5315,'g',0,'2012-01-30'),(5365,'g',0,'2012-01-30'),(5373,'g',0,'2012-01-31'),(5376,'g',0,'2012-01-31'),(5327,'g',0,'2012-01-31'),(5400,'g',0,'2012-01-31'),(5391,'g',0,'2012-01-31'),(5308,'g',0,'2012-01-31'),(5377,'g',0,'2012-01-31'),(5374,'g',0,'2012-01-31'),(5387,'g',0,'2012-01-31'),(5402,'g',0,'2012-02-01'),(5362,'g',0,'2012-02-01'),(5404,'g',0,'2012-02-01'),(5390,'g',0,'2012-02-01'),(5396,'g',0,'2012-02-01'),(5322,'g',0,'2012-02-01'),(5395,'g',0,'2012-02-01'),(5393,'g',0,'2012-02-01'),(5366,'g',0,'2012-02-01'),(5385,'g',0,'2012-02-01'),(5329,'g',0,'2012-02-01'),(5313,'g',0,'2012-02-01'),(5401,'g',0,'2012-02-01'),(5408,'g',0,'2012-02-01'),(5359,'g',0,'2012-02-01'),(5392,'g',0,'2012-02-01'),(5417,'g',0,'2012-02-03'),(5386,'g',0,'2012-02-03'),(5394,'g',0,'2012-02-03'),(5381,'g',0,'2012-02-03'),(5399,'g',0,'2012-02-03'),(5384,'g',0,'2012-02-03'),(5410,'g',0,'2012-02-03'),(5432,'g',0,'2012-02-05'),(5407,'g',0,'2012-02-05'),(5368,'g',0,'2012-02-05'),(5416,'g',0,'2012-02-05'),(5367,'g',0,'2012-02-05'),(5413,'g',0,'2012-02-05'),(5434,'g',0,'2012-02-05'),(5412,'g',0,'2012-02-05'),(5383,'g',0,'2012-02-05'),(5372,'g',0,'2012-02-05'),(5364,'g',0,'2012-02-05'),(5360,'g',0,'2012-02-05'),(5398,'g',0,'2012-02-05'),(5431,'g',0,'2012-02-05'),(5403,'g',0,'2012-02-05'),(5411,'g',0,'2012-02-05'),(5415,'g',0,'2012-02-05'),(5397,'g',0,'2012-02-05'),(5430,'g',0,'2012-02-05'),(5370,'g',0,'2012-02-05'),(5388,'g',0,'2012-02-05'),(5363,'g',0,'2012-02-05'),(5458,'g',0,'2012-02-05'),(5460,'g',0,'2012-02-05'),(5462,'g',0,'2012-02-05'),(5459,'g',0,'2012-02-05'),(5463,'g',0,'2012-02-05'),(5455,'g',0,'2012-02-05'),(5456,'g',0,'2012-02-05'),(5457,'g',0,'2012-02-05'),(5464,'g',0,'2012-02-05'),(5461,'g',0,'2012-02-05'),(5389,'g',0,'2012-02-05'),(5433,'g',0,'2012-02-06'),(5371,'g',0,'2012-02-06'),(5429,'g',0,'2012-02-06'),(5375,'g',0,'2012-02-06'),(5414,'g',0,'2012-02-06'),(5325,'g',0,'2012-02-06'),(5409,'g',0,'2012-02-06'),(5492,'g',0,'2012-02-06'),(5453,'g',0,'2012-02-06'),(5435,'g',0,'2012-02-07'),(5428,'g',0,'2012-02-07'),(5369,'g',0,'2012-02-07'),(5497,'g',0,'2012-02-08'),(5422,'g',0,'2012-02-09'),(5420,'g',0,'2012-02-09'),(5418,'g',0,'2012-02-09'),(5424,'g',0,'2012-02-09'),(5423,'g',0,'2012-02-09'),(5419,'g',0,'2012-02-09'),(5421,'g',0,'2012-02-09'),(4700,'g',0,'2012-02-09'),(4706,'g',0,'2012-02-09'),(4907,'g',0,'2012-02-09'),(4914,'g',0,'2012-02-09'),(4692,'g',0,'2012-02-09'),(4904,'g',0,'2012-02-09'),(4855,'g',0,'2012-02-09'),(5494,'g',0,'2012-02-10'),(5487,'g',0,'2012-02-10'),(5486,'g',0,'2012-02-10'),(5485,'g',0,'2012-02-10'),(5481,'g',0,'2012-02-10'),(5484,'g',0,'2012-02-10'),(5482,'g',0,'2012-02-10'),(5483,'g',0,'2012-02-10'),(5489,'g',0,'2012-02-10'),(5480,'g',0,'2012-02-10'),(5469,'g',0,'2012-02-11'),(5467,'g',0,'2012-02-11'),(5468,'g',0,'2012-02-11'),(5466,'g',0,'2012-02-11'),(5488,'g',0,'2012-02-11'),(5490,'g',0,'2012-02-11'),(5493,'g',0,'2012-02-12'),(5495,'g',0,'2012-02-12'),(5510,'g',0,'2012-02-12'),(5470,'g',0,'2012-02-12'),(5491,'g',0,'2012-02-12'),(5465,'g',0,'2012-02-12'),(5496,'g',0,'2012-02-14'),(5498,'g',0,'2012-02-15'),(5515,'g',0,'2012-02-15'),(5519,'g',0,'2012-02-16'),(4293,'g',0,'2012-02-18'),(5523,'g',0,'2012-02-18'),(5527,'g',0,'2012-02-20'),(4292,'g',0,'2012-02-20'),(4361,'g',0,'2012-02-21'),(4906,'g',0,'2012-02-23'),(4158,'g',0,'2012-02-24'),(4041,'g',0,'2012-02-24'),(5500,'g',0,'2012-02-24'),(4079,'g',0,'2012-02-25'),(4045,'g',0,'2012-02-25'),(4152,'g',0,'2012-02-25'),(4108,'g',0,'2012-02-25'),(4044,'g',0,'2012-02-25'),(4064,'g',0,'2012-02-25'),(4043,'g',0,'2012-02-25'),(4111,'g',0,'2012-02-25'),(4112,'g',0,'2012-02-25'),(4616,'g',0,'2012-02-25'),(4682,'g',0,'2012-02-25'),(4621,'g',0,'2012-02-25'),(4383,'g',0,'2012-02-25'),(4395,'g',0,'2012-02-25'),(4554,'g',0,'2012-02-25'),(4333,'g',0,'2012-02-25'),(4767,'g',0,'2012-02-25'),(5290,'g',0,'2012-02-25'),(4147,'g',0,'2012-02-25'),(4171,'g',0,'2012-02-25'),(4698,'g',0,'2012-02-25'),(4338,'g',0,'2012-02-25'),(4330,'g',0,'2012-02-25'),(4460,'g',0,'2012-02-25'),(4332,'g',0,'2012-02-25'),(4335,'g',0,'2012-02-25'),(5506,'g',0,'2012-02-25'),(4326,'g',0,'2012-02-25'),(4302,'g',0,'2012-02-25'),(4116,'g',0,'2012-02-25'),(4232,'g',0,'2012-02-25'),(4105,'g',0,'2012-02-25'),(4198,'g',0,'2012-02-25'),(4234,'g',0,'2012-02-25'),(4209,'g',0,'2012-02-25'),(4065,'g',0,'2012-02-25'),(4488,'g',0,'2012-02-25'),(4483,'g',0,'2012-02-25'),(5539,'g',0,'2012-02-25'),(5517,'g',0,'2012-02-25'),(4809,'g',0,'2012-02-25'),(4540,'g',0,'2012-02-25'),(4482,'g',0,'2012-02-25'),(4159,'g',0,'2012-02-25'),(5089,'g',0,'2012-02-25'),(4150,'g',0,'2012-02-25'),(4451,'g',0,'2012-02-25'),(5512,'g',0,'2012-02-25'),(4691,'g',0,'2012-02-26'),(4334,'g',0,'2012-02-26'),(4446,'g',0,'2012-02-26'),(4908,'g',0,'2012-02-26'),(4291,'g',0,'2012-02-26'),(4218,'g',0,'2012-02-26'),(4062,'g',0,'2012-02-26'),(4527,'g',0,'2012-02-26'),(4506,'g',0,'2012-02-26'),(5532,'g',0,'2012-02-26'),(4693,'g',0,'2012-02-26'),(4778,'g',0,'2012-02-26'),(4513,'g',0,'2012-02-26'),(4511,'g',0,'2012-02-26'),(5547,'g',0,'2012-02-27'),(5573,'g',0,'2012-02-28'),(5475,'g',0,'2012-03-01'),(5472,'g',0,'2012-03-01'),(5477,'g',0,'2012-03-01'),(5473,'g',0,'2012-03-01'),(5476,'g',0,'2012-03-01'),(5454,'g',0,'2012-03-01'),(5474,'g',0,'2012-03-01'),(5471,'g',0,'2012-03-01'),(5479,'g',0,'2012-03-01'),(5478,'g',0,'2012-03-01'),(5439,'g',0,'2012-03-01'),(5425,'g',0,'2012-03-01'),(5427,'g',0,'2012-03-01'),(5438,'g',0,'2012-03-01'),(5441,'g',0,'2012-03-01'),(5440,'g',0,'2012-03-01'),(5442,'g',0,'2012-03-01'),(5436,'g',0,'2012-03-01'),(5426,'g',0,'2012-03-01'),(5437,'g',0,'2012-03-01'),(5199,'g',0,'2012-03-01'),(5513,'g',0,'2012-03-01'),(5448,'g',0,'2012-03-01'),(5450,'g',0,'2012-03-01'),(5449,'g',0,'2012-03-01'),(5452,'g',0,'2012-03-01'),(5451,'g',0,'2012-03-01'),(5444,'g',0,'2012-03-01'),(5447,'g',0,'2012-03-01'),(5446,'g',0,'2012-03-01'),(5443,'g',0,'2012-03-01'),(5445,'g',0,'2012-03-01'),(5566,'g',0,'2012-03-03'),(5580,'g',0,'2012-03-03'),(5574,'g',0,'2012-03-04'),(5591,'g',0,'2012-03-05'),(5608,'g',0,'2012-03-06'),(5595,'g',0,'2012-03-06'),(5610,'g',0,'2012-03-06'),(5602,'g',0,'2012-03-06'),(5603,'g',0,'2012-03-07'),(5605,'g',0,'2012-03-07'),(5600,'g',0,'2012-03-07'),(5607,'g',0,'2012-03-07'),(5604,'g',0,'2012-03-07'),(5606,'g',0,'2012-03-07'),(5594,'g',0,'2012-03-07'),(5601,'g',0,'2012-03-07');

--
-- Table structure for table `idx_paid_listing`
--

CREATE TABLE `idx_paid_listing` (
  `link_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `premium` char(1) DEFAULT NULL,
  `sponsored` char(1) DEFAULT NULL,
  `expire` datetime DEFAULT NULL,
  `paid` char(1) DEFAULT NULL,
  PRIMARY KEY (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_paid_listing`
--


--
-- Table structure for table `idx_payment_gateway`
--

CREATE TABLE `idx_payment_gateway` (
  `payment_gateway_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `enable` char(1) DEFAULT NULL,
  `setting` text,
  `invoice_html` text,
  PRIMARY KEY (`payment_gateway_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_payment_gateway`
--

INSERT INTO `idx_payment_gateway` VALUES (1,'paypal','1','a:2:{s:13:\"payment_email\";s:0:\"\";s:21:\"enable_paypal_sandbox\";s:1:\"0\";}','<p> \r\n	<a href=\'paynow.php?id={$invoice_id}&m=paypal\'><img src=\'http://www.paypal.com/images/x-click-but02.gif\' border=\'0\' alt=\'Make payments with PayPal - it is fast, free and secure!\' /></a> \r\n</p>\r\n'),(2,'2co','0','a:6:{s:6:\"co_sid\";s:5:\"84932\";s:9:\"co_secret\";s:5:\"tango\";s:12:\"co_recurring\";s:1:\"0\";s:9:\"co_prod_1\";s:6:\"100.00\";s:9:\"co_prod_2\";s:6:\"250.00\";s:9:\"co_prod_3\";s:6:\"400.00\";}','<p>\r\n<a href=\'paynow.php?id={$invoice_id}&m=2co\'><img src=\'http://www.2checkout.com/images/overview/btns/25.jpg\' alt=\'Pay Now with 2checkout...\' border=\'0\' /></a> \r\n</p>'),(3,'authorizenet','0','a:2:{s:21:\"authorizenet_login_id\";s:0:\"\";s:21:\"authorizenet_tran_key\";s:0:\"\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=authorizenet\'><img src=\'http://www.authorize.net/upload/images/Images/Header/authorizenet_logo.gif\' alt=\'Pay Now with Authorize.Net...\' width=\'99\' height=\'39\' style=\'{border : 1px solid #c0c0c0;}\' /></a>\r\n</p>'),(4,'egold','0','a:2:{s:19:\"egold_payee_account\";s:0:\"\";s:16:\"egold_payee_name\";s:0:\"\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=egold\'>\r\n<img src=\'http://www.e-gold.com/gif/paywith.gif\' border=\'0\' alt=\'Pay Now with e-gold...\' />\r\n</a>\r\n</p>'),(5,'moneybookers','0','a:1:{s:18:\"moneybookers_email\";s:0:\"\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=paypal\'><img src=\'http://www.moneybookers.com/images/banners/88_en_mb.gif\' border=\'0\' alt=\'Make payments with Moneybookers - it is fast, free and secure!\' /></a> \r\n</p>'),(6,'paypal-subscriptions','0','a:2:{s:13:\"payment_email\";s:0:\"\";s:21:\"enable_paypal_sandbox\";s:1:\"0\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=paypal\'><img src=\'https://www.paypal.com/en_US/i/btn/x-click-but20.gif\' border=\'0\' alt=\'Make payments with PayPal - it is fast, free and secure!\' /></a> \r\n</p>'),(7,'alertpay','0','a:2:{s:14:\"alertpay_email\";s:0:\"\";s:23:\"enable_alertpay_sandbox\";s:1:\"0\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=alertpay\'>\r\n<img src=\'https://www.alertpay.com/Images/BuyNow/pay_now_3.gif\' border=\'0\' alt=\'Make payments with PayPal - it is fast, free and secure!\' /></a> \r\n</p>'),(8,'alertpay-subcriptions','0','a:2:{s:14:\"alertpay_email\";s:0:\"\";s:23:\"enable_alertpay_sandbox\";s:1:\"0\";}','<p>\r\n<a href=\'paynow.php?id={$invoice_id}&m=alertpay-subcriptions\'>\r\n<img src=\'https://www.alertpay.com/Images/BuyNow/subscribe_now_15.gif\' border=\'0\' alt=\'Make payments with Alert Pay - it is fast, free and secure!\' /></a> \r\n</p>');

--
-- Table structure for table `idx_payment_history`
--

CREATE TABLE `idx_payment_history` (
  `payment_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `contact_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `detail` text,
  `amount` double DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `invoice_id` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`payment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_payment_history`
--


--
-- Table structure for table `idx_plugin`
--

CREATE TABLE `idx_plugin` (
  `plugin_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `plugin_file` varchar(255) DEFAULT NULL,
  `status` enum('0','1') DEFAULT NULL,
  `option_plugin` text,
  PRIMARY KEY (`plugin_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_plugin`
--


--
-- Table structure for table `idx_review`
--

CREATE TABLE `idx_review` (
  `review_id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `link_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `review` text NOT NULL,
  `rating` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  `subject` varchar(100) DEFAULT NULL,
  `status` char(1) DEFAULT NULL,
  `username` varchar(20) DEFAULT NULL,
  `name` varchar(20) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`review_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_review`
--


--
-- Table structure for table `idx_searchlog`
--

CREATE TABLE `idx_searchlog` (
  `keyword` varchar(100) NOT NULL DEFAULT '',
  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `result` mediumint(9) unsigned DEFAULT NULL,
  `ip` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_searchlog`
--


--
-- Table structure for table `idx_set_hook_place`
--

CREATE TABLE `idx_set_hook_place` (
  `set_hook_place_id` int(11) NOT NULL AUTO_INCREMENT,
  `plugin` varchar(255) DEFAULT NULL,
  `set_hook_place` text,
  PRIMARY KEY (`set_hook_place_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_set_hook_place`
--


--
-- Table structure for table `idx_setting`
--

CREATE TABLE `idx_setting` (
  `setting_id` int(11) NOT NULL AUTO_INCREMENT,
  `setting_name` varchar(255) DEFAULT NULL,
  `setting_value` text,
  PRIMARY KEY (`setting_id`)
) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_setting`
--

INSERT INTO `idx_setting` VALUES (4,'site_name','linkxx.us'),(5,'site_url','http://linkxx.us'),(6,'email_address','diamond.livernois@gmail.com'),(7,'language_code','en_US'),(8,'theme_path','/home/linkxx/public_html/themes/'),(9,'admin_template_path','/home/linkxx/public_html/admin_tpl/'),(10,'plugin_path','/home/linkxx/public_html/plugin/'),(12,'active_theme','_linkxx'),(14,'spam_proof','1'),(15,'enable_user_validation','1'),(16,'allowed_file_extension','gif,jpg,png,pdf,zip,doc'),(17,'yahoo_appid',''),(18,'whosonline','600'),(19,'reciprocal_check','0'),(20,'urlcheck_limit','1'),(21,'pagerank_cache','30'),(22,'max_image_width','1024'),(23,'max_image_height','756'),(24,'max_file_size','500'),(25,'only_registered_can_add_link','0'),(26,'only_registered_can_add_review','0'),(27,'db_use_persistent','0'),(28,'paid_link_day_period','30,60,90,180'),(29,'paid_link_price_factor','1,1.5,2,3'),(30,'enable_html_tag','1'),(31,'allowed_html_tag','<b>,<strong>,<i>,<em>,<u>,<pre>,<blockquote>,<ol>,<ul>,<li>,<p>,<span>,<div>,<table>,<tr>,<td>'),(32,'enable_page_compression','0'),(33,'enable_category_ajax','1'),(34,'require_visit_category','0'),(35,'additional_category_price','0.5'),(36,'enable_rating_ajax','1'),(37,'service_nicecoder_avail','1'),(38,'enable_recaptcha','0'),(39,'recaptcha_publickey',''),(40,'recaptcha_privatekey',''),(41,'enable_bidding','0'),(42,'minimum_bid','5'),(43,'bid_increament','1'),(44,'charset','utf-8'),(45,'mailer','mail'),(46,'smtp_auth','0'),(47,'smtp_host',''),(48,'smtp_username',''),(49,'smtp_password',''),(50,'smtp_port','25'),(51,'emailbody_as_html','0'),(52,'indexu_version','2.4'),(53,'tos',''),(54,'submission_guidelines','');

--
-- Table structure for table `idx_tags`
--

CREATE TABLE `idx_tags` (
  `tag` varchar(64) NOT NULL DEFAULT '',
  `category_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `total` int(11) NOT NULL DEFAULT '0',
  `tag_path` varchar(64) NOT NULL,
  PRIMARY KEY (`tag`,`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_tags`
--


--
-- Table structure for table `idx_unavailable`
--

CREATE TABLE `idx_unavailable` (
  `idx_unavailable` int(11) NOT NULL AUTO_INCREMENT,
  `link_id` int(11) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `who_is` varchar(255) DEFAULT NULL,
  `note` text,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`idx_unavailable`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_unavailable`
--


--
-- Table structure for table `idx_unavailable_latest`
--

CREATE TABLE `idx_unavailable_latest` (
  `idx_link` int(11) DEFAULT NULL,
  `record_execution` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_unavailable_latest`
--


--
-- Table structure for table `idx_votes`
--

CREATE TABLE `idx_votes` (
  `link_id` mediumint(9) NOT NULL DEFAULT '0',
  `ip` varchar(100) DEFAULT NULL,
  `value` tinyint(4) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_votes`
--



