--
-- Host: bolookat.com    Database: bolookat_db_new
-- ------------------------------------------------------


--
-- 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 & Humanities','','folder.gif','','1',14,'','','0','0','','',0,'',0,0,0,0,0),(2,0,'Automobile industry','','folder.gif','','1',37,'','','0','0','','',0,'',0,0,0,0,0),(3,0,'Business & Economy','','folder.gif','','1',137,'','','0','0','','',0,'',0,0,0,0,0),(4,0,'Careers','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(5,0,'Clothing & Fashion','','folder.gif','','1',10,'','','0','0','','',0,'',0,0,0,0,0),(6,0,'Mass Communications','','folder.gif','','1',24,'','','0','0','','',0,'',0,0,0,0,0),(7,0,'Computers & IT','','folder.gif','','1',19,'','','0','0','','',0,'',0,0,0,0,0),(8,0,'Construction Services','','folder.gif','','1',74,'','','0','0','','',0,'',0,0,0,0,0),(9,0,'Dental Health','','folder.gif','','1',31,'','','0','0','','',0,'',0,0,0,0,0),(10,0,'Education & Training','','folder.gif','','1',22,'','','0','0','','',0,'',0,0,0,0,0),(11,0,'Employment & Recruitment','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(12,0,'Gifts & Novelties','','folder.gif','','1',22,'','','0','0','','',0,'',0,0,0,0,0),(13,0,'Software & Hardware','','folder.gif','','1',11,'','','0','0','','',0,'',0,0,0,0,0),(14,0,'Health Services','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(15,0,'Healthcare Industry','','folder.gif','','1',169,'','','0','0','','',0,'',0,0,0,0,0),(16,0,'Heating and Air Conditioning','','folder.gif','','1',61,'','','0','0','','',0,'',0,0,0,0,0),(17,0,'Home & Garden','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(18,0,'Home Improvement','','folder.gif','','1',292,'','','0','0','','',0,'',0,0,0,0,0),(19,0,'Hotels & Motels','','folder.gif','','1',55,'','','0','0','','',0,'',0,0,0,0,0),(20,0,'Insurance','','folder.gif','','1',33,'','','0','0','','',0,'',0,0,0,0,0),(21,0,'Law & Politics','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(22,0,'Lawyers','','folder.gif','','1',165,'','','0','0','','',0,'',0,0,0,0,0),(23,0,'Lifestyle & Relationships','','folder.gif','','1',3,'','','0','0','','',0,'',0,0,0,0,0),(24,0,'Medicine','','folder.gif','','1',12,'','','0','0','','',0,'',0,0,0,0,0),(25,0,'Money & Finance','','folder.gif','','1',16,'','','0','0','','',0,'',0,0,0,0,0),(26,0,'News & Issues','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(27,0,'Plumbing','','folder.gif','','1',38,'','','0','0','','',0,'',0,0,0,0,0),(28,0,'Real Estate','','folder.gif','','1',29,'','','0','0','','',0,'',0,0,0,0,0),(29,0,'Science & Technology','','folder.gif','','1',13,'','','0','0','','',0,'',0,0,0,0,0),(30,0,'SEO & SMO','','folder.gif','','1',23,'','','0','0','','',0,'',0,0,0,0,0),(31,0,'Shopping','','folder.gif','','1',52,'','','0','0','','',0,'',0,0,0,0,0),(32,0,'Sports & Games','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(33,0,'Transportation and Logistics','','folder.gif','','1',38,'','','0','0','','',0,'',0,0,0,0,0),(34,0,'Travel','','folder.gif','','1',16,'','','0','0','','',0,'',0,0,0,0,0),(35,0,'Wedding','','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 & Humanities','<a href=\"http://bolookat.com/arts-humanities/\" name=\"cat_1\" style=\"\">Arts & Humanities</a>',';0;'),(2,'Automobile industry','<a href=\"http://bolookat.com/automobile-industry/\" name=\"cat_2\" style=\"\">Automobile industry</a>',';0;'),(3,'Business & Economy','<a href=\"http://bolookat.com/business-economy/\" name=\"cat_3\" style=\"\">Business & Economy</a>',';0;'),(4,'Careers','<a href=\"http://bolookat.com/careers/\" name=\"cat_4\" style=\"\">Careers</a>',';0;'),(5,'Clothing & Fashion','<a href=\"http://bolookat.com/clothing-fashion/\" name=\"cat_5\" style=\"\">Clothing & Fashion</a>',';0;'),(6,'Mass Communications','<a href=\"http://bolookat.com/mass-communications/\" name=\"cat_6\" style=\"\">Mass Communications</a>',';0;'),(7,'Computers & IT','<a href=\"http://bolookat.com/computers-it/\" name=\"cat_7\" style=\"\">Computers & IT</a>',';0;'),(8,'Construction Services','<a href=\"http://bolookat.com/construction-services/\" name=\"cat_8\" style=\"\">Construction Services</a>',';0;'),(9,'Dental Health','<a href=\"http://bolookat.com/dental-health/\" name=\"cat_9\" style=\"\">Dental Health</a>',';0;'),(10,'Education & Training','<a href=\"http://bolookat.com/education-training/\" name=\"cat_10\" style=\"\">Education & Training</a>',';0;'),(11,'Employment & Recruitment','<a href=\"http://bolookat.com/employment-recruitment/\" name=\"cat_11\" style=\"\">Employment & Recruitment</a>',';0;'),(12,'Gifts & Novelties','<a href=\"http://bolookat.com/gifts-novelties/\" name=\"cat_12\" style=\"\">Gifts & Novelties</a>',';0;'),(13,'Software & Hardware','<a href=\"http://bolookat.com/software-hardware/\" name=\"cat_13\" style=\"\">Software & Hardware</a>',';0;'),(14,'Health Services','<a href=\"http://bolookat.com/health-services/\" name=\"cat_14\" style=\"\">Health Services</a>',';0;'),(15,'Healthcare Industry','<a href=\"http://bolookat.com/healthcare-industry/\" name=\"cat_15\" style=\"\">Healthcare Industry</a>',';0;'),(16,'Heating and Air Conditioning','<a href=\"http://bolookat.com/heating-and-air-conditioning/\" name=\"cat_16\" style=\"\">Heating and Air Conditioning</a>',';0;'),(17,'Home & Garden','<a href=\"http://bolookat.com/home-garden/\" name=\"cat_17\" style=\"\">Home & Garden</a>',';0;'),(18,'Home Improvement','<a href=\"http://bolookat.com/home-improvement/\" name=\"cat_18\" style=\"\">Home Improvement</a>',';0;'),(19,'Hotels & Motels','<a href=\"http://bolookat.com/hotels-motels/\" name=\"cat_19\" style=\"\">Hotels & Motels</a>',';0;'),(20,'Insurance','<a href=\"http://bolookat.com/insurance/\" name=\"cat_20\" style=\"\">Insurance</a>',';0;'),(21,'Law & Politics','<a href=\"http://bolookat.com/law-politics/\" name=\"cat_21\" style=\"\">Law & Politics</a>',';0;'),(22,'Lawyers','<a href=\"http://bolookat.com/lawyers/\" name=\"cat_22\" style=\"\">Lawyers</a>',';0;'),(23,'Lifestyle & Relationships','<a href=\"http://bolookat.com/lifestyle-relationships/\" name=\"cat_23\" style=\"\">Lifestyle & Relationships</a>',';0;'),(24,'Medicine','<a href=\"http://bolookat.com/medicine/\" name=\"cat_24\" style=\"\">Medicine</a>',';0;'),(25,'Money & Finance','<a href=\"http://bolookat.com/money-finance/\" name=\"cat_25\" style=\"\">Money & Finance</a>',';0;'),(26,'News & Issues','<a href=\"http://bolookat.com/news-issues/\" name=\"cat_26\" style=\"\">News & Issues</a>',';0;'),(27,'Plumbing','<a href=\"http://bolookat.com/plumbing/\" name=\"cat_27\" style=\"\">Plumbing</a>',';0;'),(28,'Real Estate','<a href=\"http://bolookat.com/real-estate/\" name=\"cat_28\" style=\"\">Real Estate</a>',';0;'),(29,'Science & Technology','<a href=\"http://bolookat.com/science-technology/\" name=\"cat_29\" style=\"\">Science & Technology</a>',';0;'),(30,'SEO & SMO','<a href=\"http://bolookat.com/seo-smo/\" name=\"cat_30\" style=\"\">SEO & SMO</a>',';0;'),(31,'Shopping','<a href=\"http://bolookat.com/shopping/\" name=\"cat_31\" style=\"\">Shopping</a>',';0;'),(32,'Sports & Games','<a href=\"http://bolookat.com/sports-games/\" name=\"cat_32\" style=\"\">Sports & Games</a>',';0;'),(33,'Transportation and Logistics','<a href=\"http://bolookat.com/transportation-and-logistics/\" name=\"cat_33\" style=\"\">Transportation and Logistics</a>',';0;'),(34,'Travel','<a href=\"http://bolookat.com/travel/\" name=\"cat_34\" style=\"\">Travel</a>',';0;'),(35,'Wedding','<a href=\"http://bolookat.com/wedding/\" name=\"cat_35\" style=\"\">Wedding</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=2 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_category_suggession` VALUES (1,7,'directories','web directories','2011-12-16 12:32:08');

--
-- 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=3 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_favorites` VALUES (1,'deangelokenta89n33','2011-10-19','My Favorites',NULL),(2,'staceynolanh36a91','2011-10-31','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 (2,'g',0,'2011-12-22'),(1,'g',0,'2011-10-24'),(4,'g',0,'2012-01-26'),(7,'g',0,'2012-02-06'),(3,'g',0,'2011-12-29'),(8,'g',0,'2011-11-16'),(5,'g',0,'2011-12-29'),(6,'g',0,'2011-11-20'),(561,'g',0,'2011-11-28'),(559,'g',0,'2011-11-28'),(248,'g',0,'2011-11-28'),(677,'g',0,'2011-11-28'),(562,'g',0,'2011-11-28'),(257,'g',0,'2011-11-28'),(600,'g',0,'2011-11-28'),(489,'g',0,'2011-11-28'),(70,'g',0,'2011-11-29'),(72,'g',0,'2011-11-29'),(221,'g',0,'2011-11-29'),(271,'g',0,'2011-11-29'),(206,'g',0,'2011-11-29'),(202,'g',0,'2011-11-29'),(334,'g',0,'2011-11-29'),(443,'g',0,'2011-11-29'),(138,'g',0,'2011-11-29'),(412,'g',0,'2011-11-29'),(112,'g',0,'2011-12-01'),(142,'g',0,'2011-12-01'),(122,'g',0,'2011-12-01'),(140,'g',0,'2011-12-01'),(167,'g',0,'2011-12-01'),(155,'g',0,'2011-12-01'),(231,'g',0,'2011-12-01'),(146,'g',0,'2011-12-01'),(113,'g',0,'2011-12-01'),(576,'g',0,'2011-12-01'),(601,'g',0,'2011-12-01'),(846,'g',0,'2011-12-01'),(623,'g',0,'2011-12-01'),(856,'g',0,'2011-12-01'),(874,'g',0,'2011-12-01'),(847,'g',0,'2011-12-01'),(1258,'g',0,'2011-12-01'),(1259,'g',0,'2011-12-01'),(1298,'g',0,'2011-12-01'),(1311,'g',0,'2011-12-01'),(1310,'g',0,'2011-12-01'),(1302,'g',0,'2011-12-01'),(1335,'g',0,'2011-12-01'),(1336,'g',0,'2011-12-01'),(1350,'g',0,'2011-12-01'),(602,'g',0,'2011-12-01'),(616,'g',0,'2011-12-01'),(577,'g',0,'2011-12-01'),(1299,'g',0,'2011-12-01'),(986,'g',0,'2011-12-01'),(252,'g',0,'2011-12-01'),(982,'g',0,'2011-12-03'),(26,'g',0,'2011-12-04'),(47,'g',0,'2011-12-04'),(64,'g',0,'2011-12-04'),(22,'g',0,'2011-12-04'),(19,'g',0,'2011-12-04'),(27,'g',0,'2011-12-04'),(14,'g',0,'2011-12-04'),(63,'g',0,'2011-12-04'),(20,'g',0,'2011-12-04'),(46,'g',0,'2011-12-04'),(71,'g',0,'2011-12-04'),(620,'g',0,'2011-12-04'),(135,'g',0,'2011-12-04'),(247,'g',0,'2011-12-04'),(255,'g',0,'2011-12-04'),(229,'g',0,'2011-12-04'),(259,'g',0,'2011-12-04'),(182,'g',0,'2011-12-04'),(805,'g',0,'2011-12-04'),(123,'g',0,'2011-12-04'),(373,'g',0,'2011-12-05'),(365,'g',0,'2011-12-05'),(58,'g',0,'2011-12-05'),(55,'g',0,'2011-12-05'),(39,'g',0,'2011-12-05'),(964,'g',0,'2011-12-05'),(18,'g',0,'2011-12-05'),(235,'g',0,'2011-12-05'),(180,'g',0,'2011-12-05'),(67,'g',0,'2011-12-05'),(462,'g',0,'2011-12-05'),(134,'g',0,'2011-12-05'),(103,'g',0,'2011-12-05'),(127,'g',0,'2011-12-05'),(547,'g',0,'2011-12-05'),(611,'g',0,'2011-12-05'),(10,'g',0,'2011-12-05'),(368,'g',0,'2011-12-05'),(209,'g',0,'2011-12-05'),(363,'g',0,'2011-12-05'),(131,'g',0,'2011-12-05'),(15,'g',0,'2011-12-05'),(29,'g',0,'2011-12-05'),(518,'g',0,'2011-12-05'),(50,'g',0,'2011-12-05'),(977,'g',0,'2011-12-05'),(370,'g',0,'2011-12-05'),(56,'g',0,'2011-12-05'),(84,'g',0,'2011-12-05'),(448,'g',0,'2011-12-05'),(330,'g',0,'2011-12-05'),(94,'g',0,'2011-12-05'),(60,'g',0,'2011-12-05'),(487,'g',0,'2011-12-05'),(52,'g',0,'2011-12-05'),(743,'g',0,'2011-12-05'),(430,'g',0,'2011-12-05'),(101,'g',0,'2011-12-05'),(175,'g',0,'2011-12-05'),(325,'g',0,'2011-12-05'),(513,'g',0,'2011-12-05'),(13,'g',0,'2011-12-05'),(899,'g',0,'2011-12-05'),(580,'g',0,'2011-12-05'),(109,'g',0,'2011-12-05'),(772,'g',0,'2011-12-05'),(463,'g',0,'2011-12-05'),(92,'g',0,'2011-12-05'),(87,'g',0,'2011-12-05'),(144,'g',0,'2011-12-05'),(451,'g',0,'2011-12-05'),(9,'g',0,'2011-12-05'),(31,'g',0,'2011-12-05'),(439,'g',0,'2011-12-05'),(45,'g',0,'2011-12-05'),(88,'g',0,'2011-12-05'),(2168,'g',0,'2011-12-05'),(44,'g',0,'2011-12-05'),(216,'g',0,'2011-12-05'),(104,'g',0,'2011-12-05'),(969,'g',0,'2011-12-05'),(372,'g',0,'2011-12-05'),(590,'g',0,'2011-12-05'),(12,'g',0,'2011-12-05'),(128,'g',0,'2011-12-05'),(91,'g',0,'2011-12-05'),(261,'g',0,'2011-12-05'),(48,'g',0,'2011-12-05'),(409,'g',0,'2011-12-05'),(73,'g',0,'2011-12-05'),(272,'g',0,'2011-12-05'),(76,'g',0,'2011-12-05'),(133,'g',0,'2011-12-05'),(647,'g',0,'2011-12-05'),(1381,'g',0,'2011-12-05'),(224,'g',0,'2011-12-05'),(386,'g',0,'2011-12-05'),(16,'g',0,'2011-12-05'),(517,'g',0,'2011-12-05'),(28,'g',0,'2011-12-05'),(57,'g',0,'2011-12-05'),(220,'g',0,'2011-12-05'),(156,'g',0,'2011-12-05'),(586,'g',0,'2011-12-05'),(593,'g',0,'2011-12-05'),(230,'g',0,'2011-12-05'),(173,'g',0,'2011-12-05'),(170,'g',0,'2011-12-05'),(75,'g',0,'2011-12-05'),(401,'g',0,'2011-12-05'),(35,'g',0,'2011-12-05'),(420,'g',0,'2011-12-05'),(62,'g',0,'2011-12-05'),(1926,'g',0,'2011-12-05'),(100,'g',0,'2011-12-05'),(500,'g',0,'2011-12-05'),(419,'g',0,'2011-12-05'),(638,'g',0,'2011-12-05'),(280,'g',0,'2011-12-05'),(322,'g',0,'2011-12-05'),(1185,'g',0,'2011-12-05'),(11,'g',0,'2011-12-05'),(305,'g',0,'2011-12-05'),(256,'g',0,'2011-12-05'),(598,'g',0,'2011-12-05'),(159,'g',0,'2011-12-05'),(77,'g',0,'2011-12-05'),(680,'g',0,'2011-12-05'),(205,'g',0,'2011-12-05'),(428,'g',0,'2011-12-05'),(402,'g',0,'2011-12-05'),(435,'g',0,'2011-12-05'),(80,'g',0,'2011-12-05'),(41,'g',0,'2011-12-05'),(61,'g',0,'2011-12-05'),(54,'g',0,'2011-12-05'),(421,'g',0,'2011-12-05'),(387,'g',0,'2011-12-05'),(1169,'g',0,'2011-12-05'),(274,'g',0,'2011-12-05'),(589,'g',0,'2011-12-05'),(348,'g',0,'2011-12-05'),(21,'g',0,'2011-12-05'),(788,'g',0,'2011-12-05'),(356,'g',0,'2011-12-05'),(297,'g',0,'2011-12-05'),(418,'g',0,'2011-12-05'),(111,'g',0,'2011-12-05'),(391,'g',0,'2011-12-05'),(43,'g',0,'2011-12-05'),(444,'g',0,'2011-12-05'),(480,'g',0,'2011-12-05'),(467,'g',0,'2011-12-05'),(549,'g',0,'2011-12-05'),(509,'g',0,'2011-12-05'),(32,'g',0,'2011-12-05'),(106,'g',0,'2011-12-05'),(415,'g',0,'2011-12-05'),(165,'g',0,'2011-12-05'),(778,'g',0,'2011-12-05'),(33,'g',0,'2011-12-05'),(164,'g',0,'2011-12-05'),(1006,'g',0,'2011-12-05'),(1278,'g',0,'2011-12-05'),(86,'g',0,'2011-12-05'),(540,'g',0,'2011-12-05'),(588,'g',0,'2011-12-05'),(96,'g',0,'2011-12-05'),(51,'g',0,'2011-12-05'),(329,'g',0,'2011-12-05'),(544,'g',0,'2011-12-05'),(1414,'g',0,'2011-12-05'),(154,'g',0,'2011-12-05'),(130,'g',0,'2011-12-05'),(624,'g',0,'2011-12-05'),(543,'g',0,'2011-12-05'),(36,'g',0,'2011-12-05'),(2130,'g',0,'2011-12-05'),(243,'g',0,'2011-12-05'),(65,'g',0,'2011-12-05'),(25,'g',0,'2011-12-05'),(34,'g',0,'2011-12-05'),(447,'g',0,'2011-12-05'),(1412,'g',0,'2011-12-05'),(587,'g',0,'2011-12-05'),(59,'g',0,'2011-12-05'),(143,'g',0,'2011-12-05'),(338,'g',0,'2011-12-05'),(367,'g',0,'2011-12-05'),(40,'g',0,'2011-12-05'),(49,'g',0,'2011-12-05'),(184,'g',0,'2011-12-05'),(97,'g',0,'2011-12-05'),(179,'g',0,'2011-12-05'),(276,'g',0,'2011-12-05'),(1372,'g',0,'2011-12-05'),(42,'g',0,'2011-12-05'),(74,'g',0,'2011-12-05'),(161,'g',0,'2011-12-05'),(475,'g',0,'2011-12-05'),(1705,'g',0,'2011-12-05'),(38,'g',0,'2011-12-05'),(539,'g',0,'2011-12-05'),(794,'g',0,'2011-12-05'),(37,'g',0,'2011-12-05'),(81,'g',0,'2011-12-05'),(678,'g',0,'2011-12-05'),(449,'g',0,'2011-12-05'),(246,'g',0,'2011-12-05'),(541,'g',0,'2011-12-05'),(676,'g',0,'2011-12-05'),(197,'g',0,'2011-12-05'),(1214,'g',0,'2011-12-05'),(427,'g',0,'2011-12-05'),(393,'g',0,'2011-12-05'),(53,'g',0,'2011-12-05'),(17,'g',0,'2011-12-05'),(98,'g',0,'2011-12-05'),(30,'g',0,'2011-12-05'),(555,'g',0,'2011-12-05'),(494,'g',0,'2011-12-05'),(108,'g',0,'2011-12-05'),(267,'g',0,'2011-12-05'),(1727,'g',0,'2011-12-05'),(110,'g',0,'2011-12-05'),(1135,'g',0,'2011-12-05'),(397,'g',0,'2011-12-05'),(377,'g',0,'2011-12-05'),(820,'g',0,'2011-12-05'),(2319,'g',0,'2011-12-06'),(1555,'g',0,'2011-12-08'),(814,'g',0,'2011-12-08'),(3246,'g',0,'2011-12-08'),(2385,'g',0,'2011-12-08'),(24,'g',0,'2011-12-09'),(23,'g',0,'2011-12-09'),(265,'g',0,'2011-12-09'),(414,'g',0,'2011-12-09'),(465,'g',0,'2011-12-09'),(464,'g',0,'2011-12-09'),(118,'g',0,'2011-12-09'),(429,'g',0,'2011-12-09'),(119,'g',0,'2011-12-09'),(452,'g',0,'2011-12-09'),(69,'g',0,'2011-12-09'),(83,'g',0,'2011-12-09'),(116,'g',0,'2011-12-09'),(126,'g',0,'2011-12-09'),(105,'g',0,'2011-12-09'),(132,'g',0,'2011-12-09'),(102,'g',0,'2011-12-09'),(176,'g',0,'2011-12-09'),(158,'g',0,'2011-12-09'),(3418,'g',0,'2011-12-10'),(2557,'g',0,'2011-12-10'),(4169,'g',0,'2011-12-11'),(4174,'g',0,'2011-12-11'),(4091,'g',0,'2011-12-11'),(4103,'g',0,'2011-12-11'),(4074,'g',0,'2011-12-11'),(4214,'g',0,'2011-12-11'),(4135,'g',0,'2011-12-11'),(4058,'g',0,'2011-12-11'),(4205,'g',0,'2011-12-11'),(4271,'g',0,'2012-02-06'),(4487,'g',0,'2011-12-13'),(4077,'g',0,'2011-12-13'),(4396,'g',0,'2012-02-14'),(4202,'g',0,'2011-12-13'),(4246,'g',0,'2011-12-13'),(4427,'g',0,'2012-02-14'),(4455,'g',0,'2012-02-14'),(4220,'g',0,'2011-12-13'),(4225,'g',0,'2011-12-13'),(4200,'g',0,'2011-12-13'),(4287,'g',0,'2011-12-14'),(4633,'g',0,'2011-12-14'),(4067,'g',0,'2011-12-14'),(4197,'g',0,'2011-12-14'),(4100,'g',0,'2011-12-14'),(4426,'g',0,'2011-12-14'),(4081,'g',0,'2011-12-14'),(4089,'g',0,'2011-12-14'),(4549,'g',0,'2011-12-14'),(4534,'g',0,'2011-12-14'),(4502,'g',0,'2011-12-14'),(4654,'g',0,'2011-12-14'),(4713,'g',0,'2011-12-14'),(4370,'g',0,'2011-12-14'),(4449,'g',0,'2011-12-14'),(4697,'g',0,'2011-12-14'),(4694,'g',0,'2011-12-14'),(4488,'g',0,'2011-12-14'),(4702,'g',0,'2011-12-14'),(4587,'g',0,'2011-12-14'),(4489,'g',0,'2011-12-14'),(4603,'g',0,'2011-12-14'),(4530,'g',0,'2011-12-14'),(4513,'g',0,'2011-12-14'),(4467,'g',0,'2011-12-14'),(4615,'g',0,'2011-12-14'),(4596,'g',0,'2011-12-14'),(4542,'g',0,'2011-12-14'),(4736,'g',0,'2011-12-14'),(4752,'g',0,'2011-12-14'),(4208,'g',0,'2011-12-14'),(4272,'g',0,'2011-12-14'),(4154,'g',0,'2011-12-14'),(4181,'g',0,'2011-12-14'),(4153,'g',0,'2011-12-14'),(4183,'g',0,'2011-12-14'),(4187,'g',0,'2011-12-14'),(4196,'g',0,'2011-12-14'),(4163,'g',0,'2011-12-14'),(4699,'g',0,'2012-02-29'),(4835,'g',0,'2011-12-14'),(4734,'g',0,'2011-12-14'),(4930,'g',0,'2011-12-14'),(4794,'g',0,'2011-12-14'),(4676,'g',0,'2011-12-14'),(4733,'g',0,'2011-12-14'),(4723,'g',0,'2011-12-14'),(4742,'g',0,'2011-12-14'),(4381,'g',0,'2011-12-14'),(4411,'g',0,'2012-02-21'),(4379,'g',0,'2011-12-14'),(4377,'g',0,'2011-12-14'),(4386,'g',0,'2011-12-14'),(4380,'g',0,'2011-12-14'),(4382,'g',0,'2011-12-14'),(4402,'g',0,'2011-12-14'),(4344,'g',0,'2011-12-14'),(4598,'g',0,'2011-12-14'),(4645,'g',0,'2011-12-14'),(4607,'g',0,'2011-12-14'),(4510,'g',0,'2011-12-14'),(4490,'g',0,'2011-12-14'),(4593,'g',0,'2011-12-14'),(4446,'g',0,'2011-12-14'),(4668,'g',0,'2011-12-14'),(4578,'g',0,'2011-12-14'),(4343,'g',0,'2011-12-14'),(4432,'g',0,'2011-12-14'),(4620,'g',0,'2011-12-15'),(4760,'g',0,'2011-12-15'),(4916,'g',0,'2011-12-15'),(4479,'g',0,'2011-12-15'),(4583,'g',0,'2011-12-15'),(4320,'g',0,'2012-02-06'),(4751,'g',0,'2011-12-15'),(4051,'g',0,'2012-02-06'),(4312,'g',0,'2012-02-06'),(4431,'g',0,'2012-02-06'),(4761,'g',0,'2011-12-15'),(4289,'g',0,'2012-02-21'),(4297,'g',0,'2012-02-23'),(4640,'g',0,'2012-01-24'),(4529,'g',0,'2012-02-23'),(4602,'g',0,'2012-02-23'),(4599,'g',0,'2012-02-23'),(4748,'g',0,'2011-12-15'),(4601,'g',0,'2012-02-23'),(4986,'g',0,'2011-12-16'),(4941,'g',0,'2011-12-16'),(4935,'g',0,'2011-12-16'),(4963,'g',0,'2011-12-16'),(4955,'g',0,'2011-12-16'),(4956,'g',0,'2011-12-16'),(4056,'g',0,'2012-02-10'),(4099,'g',0,'2012-02-06'),(4947,'g',0,'2011-12-16'),(4132,'g',0,'2012-02-06'),(4172,'g',0,'2011-12-16'),(4417,'g',0,'2011-12-16'),(4057,'g',0,'2012-02-06'),(4982,'g',0,'2012-02-06'),(4090,'g',0,'2012-02-06'),(4175,'g',0,'2011-12-16'),(4152,'g',0,'2012-02-06'),(4952,'g',0,'2011-12-16'),(4171,'g',0,'2011-12-16'),(4221,'g',0,'2011-12-16'),(4948,'g',0,'2011-12-16'),(4975,'g',0,'2011-12-16'),(4984,'g',0,'2011-12-16'),(4168,'g',0,'2011-12-16'),(4083,'g',0,'2011-12-16'),(4953,'g',0,'2011-12-16'),(4934,'g',0,'2011-12-16'),(4945,'g',0,'2011-12-17'),(4362,'g',0,'2011-12-17'),(4388,'g',0,'2011-12-17'),(4378,'g',0,'2011-12-17'),(4073,'g',0,'2012-02-06'),(4092,'g',0,'2012-02-06'),(4459,'g',0,'2011-12-17'),(4980,'g',0,'2012-02-06'),(4458,'g',0,'2011-12-17'),(4433,'g',0,'2011-12-17'),(4284,'g',0,'2011-12-17'),(4626,'g',0,'2011-12-17'),(5016,'g',0,'2011-12-17'),(4558,'g',0,'2011-12-17'),(4673,'g',0,'2011-12-17'),(4557,'g',0,'2011-12-17'),(4520,'g',0,'2011-12-17'),(4276,'g',0,'2011-12-17'),(5006,'g',0,'2011-12-17'),(4969,'g',0,'2011-12-17'),(5017,'g',0,'2011-12-17'),(4990,'g',0,'2011-12-17'),(4996,'g',0,'2011-12-17'),(4987,'g',0,'2011-12-17'),(4936,'g',0,'2011-12-17'),(5002,'g',0,'2011-12-17'),(4978,'g',0,'2011-12-17'),(4957,'g',0,'2011-12-17'),(4491,'g',0,'2012-02-06'),(4749,'g',0,'2011-12-17'),(4410,'g',0,'2011-12-17'),(4408,'g',0,'2011-12-17'),(4403,'g',0,'2012-01-26'),(4054,'g',0,'2012-01-26'),(4407,'g',0,'2012-01-26'),(4413,'g',0,'2011-12-17'),(4412,'g',0,'2011-12-17'),(4301,'g',0,'2012-01-26'),(4052,'g',0,'2012-01-26'),(4405,'g',0,'2012-01-26'),(5020,'g',0,'2011-12-18'),(5000,'g',0,'2011-12-18'),(4979,'g',0,'2011-12-18'),(5013,'g',0,'2011-12-18'),(4989,'g',0,'2011-12-18'),(4977,'g',0,'2011-12-18'),(4968,'g',0,'2011-12-18'),(4951,'g',0,'2011-12-18'),(4938,'g',0,'2011-12-18'),(4944,'g',0,'2011-12-18'),(4111,'g',0,'2011-12-18'),(4973,'g',0,'2011-12-18'),(4113,'g',0,'2011-12-18'),(5008,'g',0,'2011-12-18'),(4374,'g',0,'2011-12-18'),(4179,'g',0,'2011-12-18'),(4247,'g',0,'2011-12-18'),(4311,'g',0,'2011-12-18'),(4262,'g',0,'2011-12-18'),(4243,'g',0,'2011-12-18'),(4992,'g',0,'2011-12-18'),(4993,'g',0,'2011-12-18'),(4961,'g',0,'2011-12-18'),(5012,'g',0,'2011-12-18'),(5018,'g',0,'2011-12-18'),(4972,'g',0,'2011-12-18'),(5001,'g',0,'2011-12-18'),(5007,'g',0,'2011-12-18'),(5003,'g',0,'2011-12-18'),(5015,'g',0,'2011-12-18'),(5005,'g',0,'2011-12-18'),(5011,'g',0,'2011-12-18'),(4985,'g',0,'2011-12-18'),(5027,'g',0,'2011-12-18'),(4474,'g',0,'2011-12-18'),(4463,'g',0,'2011-12-18'),(4462,'g',0,'2011-12-18'),(4460,'g',0,'2011-12-18'),(4461,'g',0,'2011-12-18'),(4943,'g',0,'2011-12-18'),(4967,'g',0,'2012-02-10'),(4055,'g',0,'2012-02-06'),(4082,'g',0,'2012-02-06'),(4102,'g',0,'2012-02-06'),(4145,'g',0,'2011-12-18'),(4468,'g',0,'2011-12-18'),(4484,'g',0,'2011-12-18'),(4063,'g',0,'2012-02-06'),(4138,'g',0,'2011-12-18'),(4337,'g',0,'2011-12-18'),(4060,'g',0,'2011-12-18'),(4988,'g',0,'2011-12-18'),(5019,'g',0,'2011-12-18'),(5021,'g',0,'2011-12-18'),(4964,'g',0,'2011-12-18'),(4071,'g',0,'2011-12-18'),(4070,'g',0,'2011-12-18'),(4059,'g',0,'2011-12-18'),(5004,'g',0,'2012-02-23'),(5039,'g',0,'2012-02-10'),(5028,'g',0,'2012-02-10'),(4999,'g',0,'2011-12-20'),(4965,'g',0,'2011-12-20'),(4143,'g',0,'2011-12-20'),(5014,'g',0,'2011-12-20'),(4974,'g',0,'2011-12-20'),(4110,'g',0,'2011-12-20'),(4976,'g',0,'2011-12-20'),(4124,'g',0,'2011-12-20'),(4108,'g',0,'2012-02-01'),(4144,'g',0,'2012-02-01'),(4106,'g',0,'2012-02-01'),(4257,'g',0,'2012-02-01'),(4265,'g',0,'2012-02-01'),(4211,'g',0,'2012-02-01'),(4307,'g',0,'2012-02-01'),(4316,'g',0,'2012-02-01'),(4261,'g',0,'2011-12-20'),(4250,'g',0,'2012-02-01'),(4950,'g',0,'2011-12-21'),(5048,'g',0,'2011-12-21'),(5045,'g',0,'2011-12-21'),(5009,'g',0,'2011-12-21'),(4983,'g',0,'2011-12-21'),(4958,'g',0,'2011-12-21'),(4970,'g',0,'2011-12-21'),(4971,'g',0,'2011-12-21'),(5029,'g',0,'2011-12-21'),(5010,'g',0,'2011-12-21'),(5053,'g',0,'2011-12-21'),(5049,'g',0,'2012-02-06'),(4160,'g',0,'2012-02-06'),(4305,'g',0,'2012-02-06'),(4504,'g',0,'2011-12-22'),(4066,'g',0,'2012-02-06'),(4505,'g',0,'2011-12-22'),(4492,'g',0,'2011-12-22'),(4454,'g',0,'2011-12-22'),(4159,'g',0,'2012-02-06'),(4065,'g',0,'2012-02-06'),(4469,'g',0,'2011-12-22'),(5051,'g',0,'2011-12-22'),(5060,'g',0,'2011-12-23'),(4995,'g',0,'2011-12-23'),(4503,'g',0,'2011-12-23'),(4991,'g',0,'2011-12-23'),(4470,'g',0,'2011-12-23'),(4994,'g',0,'2011-12-23'),(4690,'g',0,'2012-02-06'),(4441,'g',0,'2012-02-06'),(4475,'g',0,'2012-02-06'),(4747,'g',0,'2011-12-23'),(4584,'g',0,'2012-02-06'),(4579,'g',0,'2011-12-23'),(5033,'g',0,'2012-02-06'),(5050,'g',0,'2012-02-06'),(4437,'g',0,'2011-12-23'),(4442,'g',0,'2011-12-25'),(5042,'g',0,'2011-12-25'),(4095,'g',0,'2012-02-06'),(4264,'g',0,'2011-12-26'),(4232,'g',0,'2011-12-26'),(4240,'g',0,'2011-12-26'),(4218,'g',0,'2011-12-26'),(4267,'g',0,'2011-12-26'),(4296,'g',0,'2012-02-06'),(4646,'g',0,'2011-12-26'),(4685,'g',0,'2011-12-26'),(4223,'g',0,'2012-02-06'),(4704,'g',0,'2011-12-26'),(4695,'g',0,'2011-12-26'),(4683,'g',0,'2011-12-26'),(4707,'g',0,'2011-12-26'),(4706,'g',0,'2011-12-26'),(4609,'g',0,'2011-12-26'),(4696,'g',0,'2011-12-26'),(4709,'g',0,'2011-12-26'),(4288,'g',0,'2012-02-06'),(4295,'g',0,'2012-02-06'),(5032,'g',0,'2011-12-26'),(4101,'g',0,'2012-02-06'),(4085,'g',0,'2012-02-06'),(4299,'g',0,'2011-12-26'),(4164,'g',0,'2012-02-06'),(4270,'g',0,'2012-02-06'),(4112,'g',0,'2012-02-06'),(4349,'g',0,'2011-12-26'),(4471,'g',0,'2011-12-26'),(4281,'g',0,'2011-12-26'),(4376,'g',0,'2011-12-26'),(4422,'g',0,'2011-12-26'),(4472,'g',0,'2011-12-26'),(4334,'g',0,'2011-12-26'),(4176,'g',0,'2011-12-26'),(5059,'g',0,'2011-12-26'),(4998,'g',0,'2011-12-26'),(4737,'g',0,'2011-12-26'),(4755,'g',0,'2011-12-26'),(4836,'g',0,'2011-12-26'),(4837,'g',0,'2011-12-26'),(4759,'g',0,'2011-12-26'),(4727,'g',0,'2011-12-26'),(4721,'g',0,'2011-12-26'),(4920,'g',0,'2011-12-26'),(4876,'g',0,'2011-12-26'),(4925,'g',0,'2011-12-26'),(4875,'g',0,'2011-12-26'),(4080,'g',0,'2012-02-06'),(5118,'g',0,'2011-12-27'),(5090,'g',0,'2011-12-27'),(5034,'g',0,'2011-12-27'),(5120,'g',0,'2011-12-27'),(5046,'g',0,'2011-12-27'),(5035,'g',0,'2011-12-27'),(5109,'g',0,'2011-12-27'),(5115,'g',0,'2011-12-27'),(4669,'g',0,'2011-12-27'),(5112,'g',0,'2011-12-27'),(5110,'g',0,'2012-02-23'),(5117,'g',0,'2011-12-27'),(5094,'g',0,'2011-12-27'),(5095,'g',0,'2011-12-27'),(5096,'g',0,'2011-12-27'),(5125,'g',0,'2011-12-28'),(5119,'g',0,'2011-12-28'),(5104,'g',0,'2011-12-28'),(5122,'g',0,'2011-12-28'),(5113,'g',0,'2011-12-28'),(5055,'g',0,'2011-12-28'),(5056,'g',0,'2011-12-28'),(5088,'g',0,'2011-12-28'),(4206,'g',0,'2011-12-28'),(4553,'g',0,'2011-12-28'),(4515,'g',0,'2012-02-06'),(4527,'g',0,'2011-12-28'),(4981,'g',0,'2012-02-06'),(4638,'g',0,'2011-12-28'),(5116,'g',0,'2011-12-28'),(5040,'g',0,'2011-12-28'),(4540,'g',0,'2011-12-28'),(4127,'g',0,'2012-02-06'),(4507,'g',0,'2012-02-06'),(5106,'g',0,'2011-12-28'),(5108,'g',0,'2011-12-28'),(5130,'g',0,'2011-12-28'),(5128,'g',0,'2011-12-28'),(4129,'g',0,'2011-12-29'),(5098,'g',0,'2011-12-29'),(5107,'g',0,'2011-12-29'),(4128,'g',0,'2011-12-29'),(4133,'g',0,'2011-12-29'),(4115,'g',0,'2011-12-29'),(4962,'g',0,'2011-12-29'),(4997,'g',0,'2011-12-29'),(4086,'g',0,'2011-12-29'),(4151,'g',0,'2011-12-29'),(5123,'g',0,'2011-12-29'),(5036,'g',0,'2011-12-29'),(5131,'g',0,'2012-02-06'),(5057,'g',0,'2011-12-29'),(5092,'g',0,'2012-02-06'),(5054,'g',0,'2012-02-06'),(5041,'g',0,'2012-02-06'),(5100,'g',0,'2011-12-31'),(5047,'g',0,'2011-12-31'),(5126,'g',0,'2011-12-31'),(5105,'g',0,'2011-12-31'),(5052,'g',0,'2011-12-31'),(5089,'g',0,'2011-12-31'),(5093,'g',0,'2012-01-01'),(5091,'g',0,'2012-01-01'),(5086,'g',0,'2012-01-01'),(5058,'g',0,'2012-01-01'),(5111,'g',0,'2012-01-01'),(4931,'g',0,'2012-01-01'),(4212,'g',0,'2012-01-01'),(5043,'g',0,'2012-02-06'),(4346,'g',0,'2012-01-01'),(5129,'g',0,'2012-01-01'),(4960,'g',0,'2012-01-01'),(4137,'g',0,'2012-01-01'),(4294,'g',0,'2012-01-01'),(4834,'g',0,'2012-01-01'),(4364,'g',0,'2012-01-01'),(4399,'g',0,'2012-01-01'),(4352,'g',0,'2012-01-01'),(4518,'g',0,'2012-01-01'),(4533,'g',0,'2012-01-01'),(4508,'g',0,'2012-01-01'),(4482,'g',0,'2012-01-01'),(4438,'g',0,'2012-01-01'),(4555,'g',0,'2012-01-01'),(4499,'g',0,'2012-01-01'),(4439,'g',0,'2012-01-01'),(4500,'g',0,'2012-01-01'),(4464,'g',0,'2012-01-01'),(4356,'g',0,'2012-01-01'),(4298,'g',0,'2012-01-01'),(4292,'g',0,'2012-01-01'),(4348,'g',0,'2012-01-01'),(4291,'g',0,'2012-01-01'),(4414,'g',0,'2012-01-01'),(4310,'g',0,'2012-01-01'),(4372,'g',0,'2012-01-01'),(4400,'g',0,'2012-01-01'),(4279,'g',0,'2012-01-01'),(4398,'g',0,'2012-01-01'),(4367,'g',0,'2012-01-01'),(4409,'g',0,'2012-01-01'),(4401,'g',0,'2012-01-01'),(4954,'g',0,'2012-01-01'),(4194,'g',0,'2012-01-01'),(4397,'g',0,'2012-01-01'),(4190,'g',0,'2012-01-01'),(4188,'g',0,'2012-01-01'),(4192,'g',0,'2012-01-01'),(4207,'g',0,'2012-01-01'),(4193,'g',0,'2012-01-01'),(4758,'g',0,'2012-01-01'),(4204,'g',0,'2012-01-01'),(4219,'g',0,'2012-01-01'),(4189,'g',0,'2012-01-01'),(4725,'g',0,'2012-01-01'),(4877,'g',0,'2012-01-01'),(4842,'g',0,'2012-01-01'),(4726,'g',0,'2012-01-01'),(4141,'g',0,'2012-01-01'),(4139,'g',0,'2012-01-01'),(5121,'g',0,'2012-01-01'),(4254,'g',0,'2012-01-01'),(4235,'g',0,'2012-01-01'),(4277,'g',0,'2012-01-01'),(4251,'g',0,'2012-01-01'),(4274,'g',0,'2012-01-01'),(4966,'g',0,'2012-01-01'),(4229,'g',0,'2012-01-01'),(4738,'g',0,'2012-01-01'),(4273,'g',0,'2012-01-01'),(4253,'g',0,'2012-01-01'),(4258,'g',0,'2012-01-01'),(4255,'g',0,'2012-01-01'),(4142,'g',0,'2012-01-01'),(4595,'g',0,'2012-01-01'),(4701,'g',0,'2012-01-01'),(4365,'g',0,'2012-01-01'),(4687,'g',0,'2012-01-01'),(4147,'g',0,'2012-01-01'),(4238,'g',0,'2012-01-01'),(4589,'g',0,'2012-01-01'),(4670,'g',0,'2012-01-01'),(4314,'g',0,'2012-01-01'),(5103,'g',0,'2012-01-01'),(5097,'g',0,'2012-01-01'),(5085,'g',0,'2012-01-01'),(5140,'g',0,'2012-01-02'),(5087,'g',0,'2012-01-03'),(5164,'g',0,'2012-02-06'),(5171,'g',0,'2012-02-10'),(5147,'g',0,'2012-01-05'),(5169,'g',0,'2012-01-05'),(5134,'g',0,'2012-01-05'),(5133,'g',0,'2012-01-05'),(4928,'g',0,'2012-01-05'),(4684,'g',0,'2012-01-05'),(4740,'g',0,'2012-01-05'),(4671,'g',0,'2012-01-05'),(5159,'g',0,'2012-01-06'),(5149,'g',0,'2012-01-06'),(5177,'g',0,'2012-01-06'),(5180,'g',0,'2012-01-06'),(5143,'g',0,'2012-01-06'),(5174,'g',0,'2012-01-06'),(5139,'g',0,'2012-01-06'),(5150,'g',0,'2012-01-06'),(5136,'g',0,'2012-02-06'),(5194,'g',0,'2012-02-06'),(5135,'g',0,'2012-02-06'),(5099,'g',0,'2012-02-06'),(5181,'g',0,'2012-01-08'),(5155,'g',0,'2012-01-08'),(5172,'g',0,'2012-01-08'),(5141,'g',0,'2012-01-08'),(5160,'g',0,'2012-01-08'),(5138,'g',0,'2012-01-08'),(5152,'g',0,'2012-01-08'),(5151,'g',0,'2012-01-08'),(5168,'g',0,'2012-01-08'),(5148,'g',0,'2012-01-09'),(5102,'g',0,'2012-01-09'),(5137,'g',0,'2012-02-22'),(5178,'g',0,'2012-01-09'),(5187,'g',0,'2012-01-09'),(5192,'g',0,'2012-01-09'),(5196,'g',0,'2012-01-09'),(5179,'g',0,'2012-01-09'),(5203,'g',0,'2012-01-09'),(5162,'g',0,'2012-01-09'),(5215,'g',0,'2012-03-02'),(5213,'g',0,'2012-01-09'),(5156,'g',0,'2012-01-10'),(5144,'g',0,'2012-01-10'),(5201,'g',0,'2012-01-10'),(5200,'g',0,'2012-01-10'),(5167,'g',0,'2012-01-10'),(5158,'g',0,'2012-01-10'),(5132,'g',0,'2012-01-10'),(5238,'g',0,'2012-01-10'),(5127,'g',0,'2012-01-10'),(5175,'g',0,'2012-01-10'),(5212,'g',0,'2012-01-10'),(5225,'g',0,'2012-01-10'),(5228,'g',0,'2012-01-10'),(5236,'g',0,'2012-01-10'),(5202,'g',0,'2012-01-10'),(5210,'g',0,'2012-01-10'),(5239,'g',0,'2012-01-10'),(5157,'g',0,'2012-01-10'),(5170,'g',0,'2012-01-10'),(5227,'g',0,'2012-01-11'),(5189,'g',0,'2012-01-11'),(5211,'g',0,'2012-01-11'),(5193,'g',0,'2012-01-11'),(5240,'g',0,'2012-01-11'),(5220,'g',0,'2012-01-11'),(5219,'g',0,'2012-01-11'),(5195,'g',0,'2012-01-11'),(5235,'g',0,'2012-01-11'),(5031,'g',0,'2012-01-12'),(5163,'g',0,'2012-01-12'),(5114,'g',0,'2012-01-12'),(5030,'g',0,'2012-01-12'),(5184,'g',0,'2012-01-13'),(5222,'g',0,'2012-01-13'),(5244,'g',0,'2012-03-04'),(5161,'g',0,'2012-01-13'),(5185,'g',0,'2012-01-13'),(5191,'g',0,'2012-01-14'),(5198,'g',0,'2012-01-14'),(5197,'g',0,'2012-01-14'),(5176,'g',0,'2012-01-14'),(5183,'g',0,'2012-01-14'),(5269,'g',0,'2012-02-14'),(5234,'g',0,'2012-01-15'),(5233,'g',0,'2012-01-15'),(5166,'g',0,'2012-03-04'),(5146,'g',0,'2012-03-04'),(5231,'g',0,'2012-01-15'),(5207,'g',0,'2012-01-15'),(5204,'g',0,'2012-01-15'),(5165,'g',0,'2012-01-15'),(5186,'g',0,'2012-01-16'),(5230,'g',0,'2012-01-16'),(5259,'g',0,'2012-01-16'),(5208,'g',0,'2012-01-16'),(5232,'g',0,'2012-01-16'),(5214,'g',0,'2012-01-16'),(5229,'g',0,'2012-01-16'),(5263,'g',0,'2012-01-16'),(5247,'g',0,'2012-01-16'),(5246,'g',0,'2012-01-16'),(5242,'g',0,'2012-01-16'),(5250,'g',0,'2012-01-16'),(5268,'g',0,'2012-01-16'),(5101,'g',0,'2012-01-16'),(5284,'g',0,'2012-01-16'),(5325,'g',0,'2012-03-04'),(5282,'g',0,'2012-01-17'),(5218,'g',0,'2012-01-19'),(5173,'g',0,'2012-01-19'),(5153,'g',0,'2012-01-19'),(5303,'g',0,'2012-01-20'),(5323,'g',0,'2012-01-20'),(5291,'g',0,'2012-01-20'),(5309,'g',0,'2012-01-20'),(5292,'g',0,'2012-01-20'),(5321,'g',0,'2012-01-20'),(5296,'g',0,'2012-01-20'),(5310,'g',0,'2012-01-20'),(5324,'g',0,'2012-01-20'),(5286,'g',0,'2012-01-20'),(5294,'g',0,'2012-01-20'),(5312,'g',0,'2012-01-20'),(5311,'g',0,'2012-01-21'),(5190,'g',0,'2012-01-21'),(5188,'g',0,'2012-01-21'),(5182,'g',0,'2012-01-21'),(5300,'g',0,'2012-02-22'),(5290,'g',0,'2012-01-21'),(5287,'g',0,'2012-01-21'),(5299,'g',0,'2012-01-21'),(5327,'g',0,'2012-01-21'),(5288,'g',0,'2012-01-21'),(5338,'g',0,'2012-01-21'),(5302,'g',0,'2012-01-21'),(5335,'g',0,'2012-01-21'),(5320,'g',0,'2012-01-21'),(5304,'g',0,'2012-01-21'),(5262,'g',0,'2012-01-22'),(5199,'g',0,'2012-01-22'),(5241,'g',0,'2012-01-22'),(5251,'g',0,'2012-01-22'),(5340,'g',0,'2012-01-22'),(5330,'g',0,'2012-01-22'),(5255,'g',0,'2012-01-22'),(5205,'g',0,'2012-01-22'),(5305,'g',0,'2012-01-22'),(5293,'g',0,'2012-01-22'),(5267,'g',0,'2012-01-22'),(5264,'g',0,'2012-01-22'),(5266,'g',0,'2012-01-22'),(5265,'g',0,'2012-01-22'),(5257,'g',0,'2012-01-22'),(5289,'g',0,'2012-01-22'),(5216,'g',0,'2012-01-22'),(5224,'g',0,'2012-01-22'),(5295,'g',0,'2012-01-22'),(5248,'g',0,'2012-01-22'),(5209,'g',0,'2012-01-22'),(5306,'g',0,'2012-01-22'),(5308,'g',0,'2012-01-22'),(5217,'g',0,'2012-01-22'),(5245,'g',0,'2012-01-22'),(5285,'g',0,'2012-01-22'),(5298,'g',0,'2012-01-22'),(5315,'g',0,'2012-01-23'),(5314,'g',0,'2012-01-23'),(5339,'g',0,'2012-01-23'),(5297,'g',0,'2012-01-23'),(5313,'g',0,'2012-01-23'),(5318,'g',0,'2012-01-23'),(5316,'g',0,'2012-01-23'),(5322,'g',0,'2012-01-23'),(5336,'g',0,'2012-01-23'),(5317,'g',0,'2012-01-23'),(5329,'g',0,'2012-03-02'),(5307,'g',0,'2012-03-02'),(5301,'g',0,'2012-01-24'),(5223,'g',0,'2012-03-02'),(5243,'g',0,'2012-03-02'),(5319,'g',0,'2012-01-25'),(5362,'g',0,'2012-01-25'),(5367,'g',0,'2012-01-26'),(5331,'g',0,'2012-01-26'),(5326,'g',0,'2012-01-26'),(5360,'g',0,'2012-01-26'),(4592,'g',0,'2012-01-26'),(4658,'g',0,'2012-01-26'),(4619,'g',0,'2012-01-26'),(4622,'g',0,'2012-01-26'),(4576,'g',0,'2012-01-26'),(4632,'g',0,'2012-01-26'),(4548,'g',0,'2012-01-26'),(4659,'g',0,'2012-01-26'),(4618,'g',0,'2012-01-26'),(4610,'g',0,'2012-01-26'),(5037,'g',0,'2012-01-26'),(4084,'g',0,'2012-01-26'),(4076,'g',0,'2012-01-26'),(5343,'g',0,'2012-01-26'),(4290,'g',0,'2012-01-26'),(4215,'g',0,'2012-01-26'),(4286,'g',0,'2012-01-26'),(4245,'g',0,'2012-01-26'),(4304,'g',0,'2012-01-26'),(4300,'g',0,'2012-01-26'),(4227,'g',0,'2012-01-26'),(4302,'g',0,'2012-01-26'),(4266,'g',0,'2012-01-26'),(4249,'g',0,'2012-01-26'),(4832,'g',0,'2012-01-26'),(4831,'g',0,'2012-01-26'),(4824,'g',0,'2012-01-26'),(4922,'g',0,'2012-01-26'),(4805,'g',0,'2012-01-26'),(4771,'g',0,'2012-01-26'),(4830,'g',0,'2012-01-26'),(4769,'g',0,'2012-01-26'),(4756,'g',0,'2012-01-26'),(4750,'g',0,'2012-01-26'),(4714,'g',0,'2012-01-26'),(4667,'g',0,'2012-01-26'),(4689,'g',0,'2012-01-26'),(4660,'g',0,'2012-01-26'),(4692,'g',0,'2012-01-26'),(4675,'g',0,'2012-01-26'),(4711,'g',0,'2012-01-26'),(4677,'g',0,'2012-01-26'),(4130,'g',0,'2012-01-26'),(4180,'g',0,'2012-01-26'),(4136,'g',0,'2012-01-26'),(4170,'g',0,'2012-01-26'),(4213,'g',0,'2012-01-26'),(4125,'g',0,'2012-01-26'),(4134,'g',0,'2012-01-26'),(4121,'g',0,'2012-01-26'),(4191,'g',0,'2012-01-26'),(4126,'g',0,'2012-01-26'),(5341,'g',0,'2012-01-26'),(5373,'g',0,'2012-01-26'),(5368,'g',0,'2012-01-26'),(5361,'g',0,'2012-01-27'),(5344,'g',0,'2012-01-27'),(5372,'g',0,'2012-01-27'),(5359,'g',0,'2012-01-27'),(4338,'g',0,'2012-01-27'),(4340,'g',0,'2012-01-27'),(4336,'g',0,'2012-01-27'),(4308,'g',0,'2012-01-27'),(4333,'g',0,'2012-01-27'),(4347,'g',0,'2012-01-27'),(4341,'g',0,'2012-01-27'),(4339,'g',0,'2012-01-27'),(4322,'g',0,'2012-01-27'),(4335,'g',0,'2012-01-27'),(4547,'g',0,'2012-01-27'),(4528,'g',0,'2012-01-27'),(4545,'g',0,'2012-01-27'),(4453,'g',0,'2012-01-27'),(4466,'g',0,'2012-01-27'),(4477,'g',0,'2012-01-27'),(4498,'g',0,'2012-01-27'),(4522,'g',0,'2012-01-27'),(4494,'g',0,'2012-01-27'),(4519,'g',0,'2012-01-27'),(4450,'g',0,'2012-01-27'),(4419,'g',0,'2012-01-27'),(4350,'g',0,'2012-01-27'),(4395,'g',0,'2012-01-27'),(4368,'g',0,'2012-01-27'),(4434,'g',0,'2012-01-27'),(4406,'g',0,'2012-01-27'),(4428,'g',0,'2012-01-27'),(4371,'g',0,'2012-01-27'),(4444,'g',0,'2012-01-27'),(5364,'g',0,'2012-01-27'),(5337,'g',0,'2012-01-27'),(5366,'g',0,'2012-01-27'),(5363,'g',0,'2012-01-28'),(5389,'g',0,'2012-01-28'),(5384,'g',0,'2012-01-28'),(5380,'g',0,'2012-01-28'),(5365,'g',0,'2012-01-28'),(5369,'g',0,'2012-03-02'),(5342,'g',0,'2012-03-02'),(5379,'g',0,'2012-01-29'),(5400,'g',0,'2012-01-29'),(5377,'g',0,'2012-01-29'),(5388,'g',0,'2012-01-29'),(5350,'g',0,'2012-01-30'),(5351,'g',0,'2012-01-30'),(5358,'g',0,'2012-01-30'),(5403,'g',0,'2012-03-04'),(5422,'g',0,'2012-03-04'),(5353,'g',0,'2012-01-30'),(5354,'g',0,'2012-01-31'),(5356,'g',0,'2012-01-31'),(5357,'g',0,'2012-01-31'),(5352,'g',0,'2012-01-31'),(5437,'g',0,'2012-01-31'),(5438,'g',0,'2012-01-31'),(5412,'g',0,'2012-01-31'),(5429,'g',0,'2012-01-31'),(5355,'g',0,'2012-01-31'),(5371,'g',0,'2012-01-31'),(5405,'g',0,'2012-02-01'),(5374,'g',0,'2012-02-01'),(5414,'g',0,'2012-02-01'),(5370,'g',0,'2012-02-01'),(5426,'g',0,'2012-02-01'),(5432,'g',0,'2012-02-01'),(5431,'g',0,'2012-02-01'),(5448,'g',0,'2012-02-01'),(5376,'g',0,'2012-02-01'),(5375,'g',0,'2012-02-02'),(5445,'g',0,'2012-02-02'),(5401,'g',0,'2012-02-02'),(5407,'g',0,'2012-02-03'),(5459,'g',0,'2012-02-04'),(5452,'g',0,'2012-02-04'),(5423,'g',0,'2012-02-04'),(5425,'g',0,'2012-02-04'),(5430,'g',0,'2012-02-04'),(5410,'g',0,'2012-02-05'),(5435,'g',0,'2012-02-05'),(5420,'g',0,'2012-02-05'),(5440,'g',0,'2012-02-05'),(5465,'g',0,'2012-02-05'),(5402,'g',0,'2012-02-05'),(5444,'g',0,'2012-02-05'),(5453,'g',0,'2012-02-05'),(5455,'g',0,'2012-02-05'),(5415,'g',0,'2012-02-05'),(5408,'g',0,'2012-02-06'),(5454,'g',0,'2012-02-06'),(5427,'g',0,'2012-02-06'),(5451,'g',0,'2012-02-06'),(5433,'g',0,'2012-02-06'),(5424,'g',0,'2012-02-06'),(5409,'g',0,'2012-02-06'),(5447,'g',0,'2012-02-06'),(5406,'g',0,'2012-02-06'),(5436,'g',0,'2012-02-07'),(5416,'g',0,'2012-02-07'),(5428,'g',0,'2012-02-07'),(5411,'g',0,'2012-02-07'),(5493,'g',0,'2012-02-07'),(5468,'g',0,'2012-02-07'),(5496,'g',0,'2012-02-07'),(5464,'g',0,'2012-02-07'),(5484,'g',0,'2012-02-07'),(5498,'g',0,'2012-02-07'),(5456,'g',0,'2012-02-08'),(5488,'g',0,'2012-02-08'),(5461,'g',0,'2012-02-08'),(5458,'g',0,'2012-02-08'),(5490,'g',0,'2012-02-08'),(5528,'g',0,'2012-02-08'),(5469,'g',0,'2012-02-08'),(5467,'g',0,'2012-02-08'),(5471,'g',0,'2012-02-08'),(5527,'g',0,'2012-02-08'),(5494,'g',0,'2012-02-08'),(5462,'g',0,'2012-02-08'),(5486,'g',0,'2012-02-08'),(5518,'g',0,'2012-02-08'),(5519,'g',0,'2012-02-08'),(5517,'g',0,'2012-02-08'),(5516,'g',0,'2012-02-08'),(5514,'g',0,'2012-02-08'),(5525,'g',0,'2012-02-08'),(5515,'g',0,'2012-02-08'),(5520,'g',0,'2012-02-08'),(5404,'g',0,'2012-02-08'),(5463,'g',0,'2012-02-08'),(5491,'g',0,'2012-02-08'),(5441,'g',0,'2012-02-08'),(5492,'g',0,'2012-02-08'),(5470,'g',0,'2012-02-08'),(5450,'g',0,'2012-02-08'),(5442,'g',0,'2012-02-08'),(5487,'g',0,'2012-02-08'),(5443,'g',0,'2012-02-08'),(5522,'g',0,'2012-02-08'),(5460,'g',0,'2012-02-08'),(5521,'g',0,'2012-02-08'),(5489,'g',0,'2012-02-08'),(5449,'g',0,'2012-02-08'),(5485,'g',0,'2012-02-09'),(5497,'g',0,'2012-02-09'),(5499,'g',0,'2012-02-09'),(5495,'g',0,'2012-02-09'),(5544,'g',0,'2012-02-09'),(5256,'g',0,'2012-02-09'),(5253,'g',0,'2012-02-09'),(5260,'g',0,'2012-02-09'),(5283,'g',0,'2012-02-09'),(5254,'g',0,'2012-02-09'),(5532,'g',0,'2012-02-10'),(5545,'g',0,'2012-02-10'),(4456,'g',0,'2012-02-11'),(4424,'g',0,'2012-02-11'),(4392,'g',0,'2012-02-11'),(4391,'g',0,'2012-02-11'),(4465,'g',0,'2012-02-11'),(4509,'g',0,'2012-02-11'),(4457,'g',0,'2012-02-11'),(4478,'g',0,'2012-02-11'),(4390,'g',0,'2012-02-11'),(4393,'g',0,'2012-02-11'),(5541,'g',0,'2012-02-12'),(5535,'g',0,'2012-02-12'),(5539,'g',0,'2012-02-12'),(5543,'g',0,'2012-02-12'),(5536,'g',0,'2012-02-12'),(5534,'g',0,'2012-02-12'),(5537,'g',0,'2012-02-12'),(5540,'g',0,'2012-02-12'),(5542,'g',0,'2012-02-12'),(5538,'g',0,'2012-02-12'),(5531,'g',0,'2012-02-12'),(5529,'g',0,'2012-02-12'),(5510,'g',0,'2012-02-12'),(5524,'g',0,'2012-02-12'),(5523,'g',0,'2012-02-12'),(4927,'g',0,'2012-02-13'),(5413,'g',0,'2012-02-13'),(5546,'g',0,'2012-02-13'),(5569,'g',0,'2012-02-13'),(5439,'g',0,'2012-02-13'),(5558,'g',0,'2012-02-14'),(5568,'g',0,'2012-02-14'),(4625,'g',0,'2012-02-14'),(4521,'g',0,'2012-02-14'),(4544,'g',0,'2012-02-14'),(4929,'g',0,'2012-02-14'),(4662,'g',0,'2012-02-14'),(4698,'g',0,'2012-02-14'),(5530,'g',0,'2012-02-14'),(5565,'g',0,'2012-02-14'),(5560,'g',0,'2012-02-15'),(5526,'g',0,'2012-02-15'),(5555,'g',0,'2012-02-16'),(5124,'g',0,'2012-02-16'),(4567,'g',0,'2012-02-18'),(4538,'g',0,'2012-02-18'),(4486,'g',0,'2012-02-18'),(5584,'g',0,'2012-02-20'),(5038,'g',0,'2012-02-21'),(5346,'g',0,'2012-02-21'),(5345,'g',0,'2012-02-21'),(5347,'g',0,'2012-02-21'),(5466,'g',0,'2012-02-21'),(5349,'g',0,'2012-02-21'),(5434,'g',0,'2012-02-21'),(5418,'g',0,'2012-02-21'),(5421,'g',0,'2012-02-21'),(5419,'g',0,'2012-02-21'),(5348,'g',0,'2012-02-21'),(5417,'g',0,'2012-02-21'),(4628,'g',0,'2012-02-21'),(4627,'g',0,'2012-02-21'),(4581,'g',0,'2012-02-21'),(4630,'g',0,'2012-02-21'),(4629,'g',0,'2012-02-21'),(4580,'g',0,'2012-02-21'),(4330,'g',0,'2012-02-22'),(4325,'g',0,'2012-02-22'),(4361,'g',0,'2012-02-22'),(4328,'g',0,'2012-02-22'),(4326,'g',0,'2012-02-22'),(4327,'g',0,'2012-02-22'),(4329,'g',0,'2012-02-22'),(4358,'g',0,'2012-02-22'),(4387,'g',0,'2012-02-22'),(4359,'g',0,'2012-02-22'),(4354,'g',0,'2012-02-22'),(4331,'g',0,'2012-02-22'),(4357,'g',0,'2012-02-22'),(4360,'g',0,'2012-02-22'),(4639,'g',0,'2012-02-22'),(4817,'g',0,'2012-02-22'),(4635,'g',0,'2012-02-22'),(4118,'g',0,'2012-02-22'),(4315,'g',0,'2012-02-22'),(5573,'g',0,'2012-02-22'),(4122,'g',0,'2012-02-22'),(4216,'g',0,'2012-02-22'),(4256,'g',0,'2012-02-22'),(4306,'g',0,'2012-02-22'),(4184,'g',0,'2012-02-22'),(5550,'g',0,'2012-02-22'),(5578,'g',0,'2012-02-22'),(4244,'g',0,'2012-02-22'),(4309,'g',0,'2012-02-22'),(4252,'g',0,'2012-02-22'),(4317,'g',0,'2012-02-22'),(4195,'g',0,'2012-02-22'),(4278,'g',0,'2012-02-22'),(4150,'g',0,'2012-02-22'),(4149,'g',0,'2012-02-22'),(4293,'g',0,'2012-02-22'),(4383,'g',0,'2012-02-22'),(4324,'g',0,'2012-02-22'),(4363,'g',0,'2012-02-22'),(4384,'g',0,'2012-02-22'),(5571,'g',0,'2012-02-23'),(5589,'g',0,'2012-02-26'),(4731,'g',0,'2012-02-26'),(4744,'g',0,'2012-02-26'),(4732,'g',0,'2012-02-26'),(4806,'g',0,'2012-02-26'),(4757,'g',0,'2012-02-26'),(4833,'g',0,'2012-02-26'),(5044,'g',0,'2012-02-26'),(4064,'g',0,'2012-02-26'),(5583,'g',0,'2012-02-26'),(4808,'g',0,'2012-02-26'),(4878,'g',0,'2012-02-26'),(4924,'g',0,'2012-02-26'),(4722,'g',0,'2012-02-26'),(4839,'g',0,'2012-02-26'),(4724,'g',0,'2012-02-26'),(4715,'g',0,'2012-02-26'),(4061,'g',0,'2012-02-26'),(5332,'g',0,'2012-02-26'),(4765,'g',0,'2012-02-26'),(4767,'g',0,'2012-02-26'),(4062,'g',0,'2012-02-26'),(5548,'g',0,'2012-02-26'),(4552,'g',0,'2012-02-26'),(4551,'g',0,'2012-02-26'),(4485,'g',0,'2012-02-26'),(4546,'g',0,'2012-02-26'),(4282,'g',0,'2012-02-26'),(4476,'g',0,'2012-02-26'),(4445,'g',0,'2012-02-26'),(4280,'g',0,'2012-02-26'),(5561,'g',0,'2012-02-26'),(4564,'g',0,'2012-02-26'),(4435,'g',0,'2012-02-26'),(4514,'g',0,'2012-02-26'),(4550,'g',0,'2012-02-26'),(4303,'g',0,'2012-02-26'),(4497,'g',0,'2012-02-26'),(5334,'g',0,'2012-02-26'),(4512,'g',0,'2012-02-26'),(4436,'g',0,'2012-02-26'),(4421,'g',0,'2012-02-26'),(4423,'g',0,'2012-02-26'),(4418,'g',0,'2012-02-26'),(5556,'g',0,'2012-02-27'),(5509,'g',0,'2012-02-27'),(5475,'g',0,'2012-02-27'),(5502,'g',0,'2012-02-27'),(5478,'g',0,'2012-02-27'),(5483,'g',0,'2012-02-27'),(5506,'g',0,'2012-02-27'),(5501,'g',0,'2012-02-27'),(4425,'g',0,'2012-02-27'),(5508,'g',0,'2012-02-27'),(5553,'g',0,'2012-02-27'),(5511,'g',0,'2012-02-27'),(5472,'g',0,'2012-02-27'),(5503,'g',0,'2012-02-27'),(5500,'g',0,'2012-02-27'),(5221,'g',0,'2012-02-27'),(5457,'g',0,'2012-02-27'),(4452,'g',0,'2012-02-27'),(4568,'g',0,'2012-02-27'),(4921,'g',0,'2012-02-27'),(4656,'g',0,'2012-02-27'),(4655,'g',0,'2012-02-27'),(4483,'g',0,'2012-02-27'),(5567,'g',0,'2012-02-27'),(4473,'g',0,'2012-02-27'),(4729,'g',0,'2012-02-27'),(4373,'g',0,'2012-02-27'),(4536,'g',0,'2012-02-27'),(4242,'g',0,'2012-02-27'),(4236,'g',0,'2012-02-27'),(4173,'g',0,'2012-02-27'),(4239,'g',0,'2012-02-27'),(4157,'g',0,'2012-02-27'),(4233,'g',0,'2012-02-27'),(4664,'g',0,'2012-02-27'),(4146,'g',0,'2012-02-27'),(4537,'g',0,'2012-02-27'),(4710,'g',0,'2012-02-27'),(4260,'g',0,'2012-02-27'),(4919,'g',0,'2012-02-27'),(4228,'g',0,'2012-02-27'),(4226,'g',0,'2012-02-27'),(4926,'g',0,'2012-02-27'),(4594,'g',0,'2012-02-27'),(4443,'g',0,'2012-02-27'),(4231,'g',0,'2012-02-27'),(4416,'g',0,'2012-02-27'),(4313,'g',0,'2012-02-27'),(5477,'g',0,'2012-02-27'),(5507,'g',0,'2012-02-27'),(5504,'g',0,'2012-02-27'),(5513,'g',0,'2012-02-27'),(5533,'g',0,'2012-02-27'),(5512,'g',0,'2012-02-27'),(5206,'g',0,'2012-02-27'),(5557,'g',0,'2012-02-27'),(5476,'g',0,'2012-02-27'),(5252,'g',0,'2012-02-27'),(4554,'g',0,'2012-02-27'),(4480,'g',0,'2012-02-27'),(4404,'g',0,'2012-02-27'),(4167,'g',0,'2012-02-27'),(4739,'g',0,'2012-02-27'),(4224,'g',0,'2012-02-27'),(4237,'g',0,'2012-02-27'),(4716,'g',0,'2012-02-27'),(4217,'g',0,'2012-02-27'),(4743,'g',0,'2012-02-27'),(5566,'g',0,'2012-02-27'),(5154,'g',0,'2012-02-27'),(4069,'g',0,'2012-02-27'),(5270,'g',0,'2012-02-27'),(4109,'g',0,'2012-02-27'),(4087,'g',0,'2012-02-27'),(4120,'g',0,'2012-02-27'),(4178,'g',0,'2012-02-27'),(5261,'g',0,'2012-02-27'),(4156,'g',0,'2012-02-27'),(5258,'g',0,'2012-02-27'),(4068,'g',0,'2012-02-27'),(5142,'g',0,'2012-02-27'),(4107,'g',0,'2012-02-27'),(5576,'g',0,'2012-02-27'),(4105,'g',0,'2012-02-27'),(4165,'g',0,'2012-02-27'),(4140,'g',0,'2012-02-27'),(5249,'g',0,'2012-02-27'),(4119,'g',0,'2012-02-27'),(4415,'g',0,'2012-02-27'),(5480,'g',0,'2012-02-27'),(5482,'g',0,'2012-02-27'),(5505,'g',0,'2012-02-27'),(5474,'g',0,'2012-02-27'),(5473,'g',0,'2012-02-27'),(5479,'g',0,'2012-02-27'),(5564,'g',0,'2012-02-27'),(4234,'g',0,'2012-02-27'),(4268,'g',0,'2012-02-27'),(4148,'g',0,'2012-02-27'),(5572,'g',0,'2012-02-27'),(4186,'g',0,'2012-02-27'),(4104,'g',0,'2012-02-27'),(5145,'g',0,'2012-02-27'),(4657,'g',0,'2012-02-27'),(4591,'g',0,'2012-02-27'),(4652,'g',0,'2012-02-27'),(4663,'g',0,'2012-02-27'),(4678,'g',0,'2012-02-27'),(4653,'g',0,'2012-02-27'),(4712,'g',0,'2012-02-27'),(4597,'g',0,'2012-02-27'),(4708,'g',0,'2012-02-27'),(4644,'g',0,'2012-02-27'),(5481,'g',0,'2012-02-27'),(4241,'g',0,'2012-02-27'),(5554,'g',0,'2012-02-28'),(5610,'g',0,'2012-02-28'),(4611,'g',0,'2012-02-28'),(5603,'g',0,'2012-02-28'),(4624,'g',0,'2012-02-28'),(5606,'g',0,'2012-02-28'),(5617,'g',0,'2012-02-28'),(4810,'g',0,'2012-02-28'),(4613,'g',0,'2012-02-28'),(5612,'g',0,'2012-02-28'),(5607,'g',0,'2012-02-28'),(4728,'g',0,'2012-02-28'),(4614,'g',0,'2012-02-28'),(5613,'g',0,'2012-02-28'),(4562,'g',0,'2012-02-28'),(4649,'g',0,'2012-02-28'),(5615,'g',0,'2012-02-28'),(5602,'g',0,'2012-02-28'),(5608,'g',0,'2012-02-29'),(5574,'g',0,'2012-02-29'),(4535,'g',0,'2012-02-29'),(4809,'g',0,'2012-02-29'),(4811,'g',0,'2012-02-29'),(4776,'g',0,'2012-02-29'),(4634,'g',0,'2012-02-29'),(4762,'g',0,'2012-02-29'),(5587,'g',0,'2012-02-29'),(4531,'g',0,'2012-02-29'),(4525,'g',0,'2012-02-29'),(4775,'g',0,'2012-02-29'),(4636,'g',0,'2012-02-29'),(4516,'g',0,'2012-02-29'),(4735,'g',0,'2012-02-29'),(4569,'g',0,'2012-02-29'),(4623,'g',0,'2012-02-29'),(4621,'g',0,'2012-02-29'),(5614,'g',0,'2012-02-29'),(5604,'g',0,'2012-02-29'),(4541,'g',0,'2012-02-29'),(4813,'g',0,'2012-02-29'),(4763,'g',0,'2012-02-29'),(4637,'g',0,'2012-02-29'),(4814,'g',0,'2012-02-29'),(4774,'g',0,'2012-02-29'),(4526,'g',0,'2012-02-29'),(5595,'g',0,'2012-02-29'),(4815,'g',0,'2012-02-29'),(4606,'g',0,'2012-02-29'),(5619,'g',0,'2012-02-29'),(4332,'g',0,'2012-02-29'),(5609,'g',0,'2012-02-29'),(5632,'g',0,'2012-03-02'),(5605,'g',0,'2012-03-05'),(5622,'g',0,'2012-03-05'),(5652,'g',0,'2012-03-06'),(5656,'g',0,'2012-03-06'),(5650,'g',0,'2012-03-06'),(5658,'g',0,'2012-03-07'),(5653,'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 AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_review` VALUES (1,4458,'Professionel and diligent',4,'2012-01-03','Reviews','1','','Euro Lights','renfred.morris@gmail.com'),(2,4458,'Excellent',3,'2012-01-03','Reviews','1','','ketan','gilroy.stevens@gmail.com'),(3,4459,'Everything was OK',4,'2012-01-03','Reviews','1','','Shopper','renfred.morris@gmail.com'),(4,4459,'You are all very attentive thus far. I appreciate the service! I have found my SEO team to work with in the foreseen future! Thanks again! ',5,'2012-01-03','Reviews','1','','Shopper','gilroy.stevens@gmail.com'),(5,4460,'Very very good.',3,'2012-01-03','Reviews','1','','Jake','renfred.morris@gmail.com'),(6,4460,'excellent ',3,'2012-01-03','Reviews','1','','Shopper','gilroy.stevens@gmail.com'),(7,4460,'Fast, convenient',4,'2012-01-03','Reviews','1','','Shopper','gilroy.stevens@gmail.com'),(8,4461,'I have utilized their SEO services in the past and have had great results. My web Master reccommended them and she has multiple ongoing projects with them ',5,'2012-01-03','Reviews','1','','michaelD','renfred.morris@gmail.com'),(9,4461,'Overall experience was great. I would buy again',3,'2012-01-03','Reviews','1','','Hanif','gilroy.stevens@gmail.com'),(10,4461,'Overall experience was great. I would buy again',3,'2012-01-03','Reviews','1','','Hanif','gilroy.stevens@gmail.com'),(11,4462,'Worked with them for 3 years. Great service. ',4,'2012-01-03','Reviews','1','','Moj','gilroy.stevens@gmail.com'),(12,4462,'excellent. the team was very pleasant to work with; i did not have any issues whatsoever. they were always ready to help and make sure i was happy',5,'2012-01-03','Reviews','1','','DD','gilroy.stevens@gmail.com'),(13,5123,'Ebrandz gets results. They optimize your site and generate traffic. We have had better success with their deluxe plans. Minimal plans do not show the same results. Service reps are pretty responsive, but don\'t always full address our concerns. Language barrier exists. But for the money, they were the very best SEO we found. ',4,'2012-01-03','Reviews','1','','LampsUSA.com','gilroy.stevens@gmail.com'),(14,5123,'This is an ongoing service (website SEO) but so far I have been very impressed. They have done everything that they said they would do. ',3,'2012-01-03','Reviews','1','','Shopper','gilroy.stevens@gmail.com');

--
-- 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','bolookat.com'),(5,'site_url','http://bolookat.com'),(6,'email_address','diane.brugman@gmail.com'),(7,'language_code','en_US'),(8,'theme_path','/home/bolookat/public_html/themes/'),(9,'admin_template_path','/home/bolookat/public_html/admin_tpl/'),(10,'plugin_path','/home/bolookat/public_html/plugin/'),(12,'active_theme','_bolookat'),(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`
--

INSERT INTO `idx_votes` VALUES (4458,'203.92.47.195',5),(4459,'203.92.47.195',5),(4460,'203.92.47.195',5),(4461,'203.92.47.195',5),(4462,'203.92.47.195',5),(5123,'203.92.47.195',5);


