--
-- Host: webhitz.us    Database: webhitz_indexu
-- ------------------------------------------------------


--
-- 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',15,'','','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',139,'','','0','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',10,'','','0','0','','',0,'',0,0,0,0,0),(6,0,'Communications','','folder.gif','','1',23,'','','0','0','','',0,'',0,0,0,0,0),(7,0,'Computer & Internet','','folder.gif','','1',19,'','','0','0','','',0,'',0,0,0,0,0),(8,0,'Construction and Maintenance','','folder.gif','','1',71,'','','0','0','','',0,'',0,0,0,0,0),(9,0,'Dental Care','','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',25,'','','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',0,'','','0','0','','',0,'',0,0,0,0,0),(15,0,'Healthcare','','folder.gif','','1',172,'','','0','0','','',0,'',0,0,0,0,0),(16,0,'Heating, Ventilating and Air Conditioning','','folder.gif','','1',58,'','','0','0','','',0,'',0,0,0,0,0),(17,0,'Home & Garden Making','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(18,0,'Home Improvement & Appliances','','folder.gif','','1',294,'','','0','0','','',0,'',0,0,0,0,0),(19,0,'Hotels','','folder.gif','','1',55,'','','0','0','','',0,'',0,0,0,0,0),(20,0,'Insurance Providers','','folder.gif','','1',33,'','','0','0','','',0,'',0,0,0,0,0),(21,0,'Law & Legal','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(22,0,'Lawyers & Attorneys','','folder.gif','','1',165,'','','0','0','','',0,'',0,0,0,0,0),(23,0,'Lifestyle & Society','','folder.gif','','1',4,'','','0','0','','',0,'',0,0,0,0,0),(24,0,'Medicine & Surgery','','folder.gif','','1',12,'','','0','0','','',0,'',0,0,0,0,0),(25,0,'Finance & Investment','','folder.gif','','1',17,'','','0','0','','',0,'',0,0,0,0,0),(26,0,'News & Media','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(27,0,'Plumbing Contractors','','folder.gif','','1',38,'','','0','0','','',0,'',0,0,0,0,0),(28,0,'Real Estate & Property','','folder.gif','','1',30,'','','0','0','','',0,'',0,0,0,0,0),(29,0,'Science','','folder.gif','','1',12,'','','0','0','','',0,'',0,0,0,0,0),(30,0,'Shopping and Sales','','folder.gif','','1',54,'','','0','0','','',0,'',0,0,0,0,0),(31,0,'Sports & Recreation','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(32,0,'Transportation Services','','folder.gif','','1',42,'','','0','0','','',0,'',0,0,0,0,0),(33,0,'Travel & Tour','','folder.gif','','1',16,'','','0','0','','',0,'',0,0,0,0,0),(34,0,'Weddings','','folder.gif','','1',6,'','','0','0','','',0,'',0,0,0,0,0),(35,0,'SEO Services','','folder.gif','','1',21,'','','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://webhitz.us/arts-entertainment/\" name=\"cat_1\" style=\"\">Arts & Entertainment</a>',';0;'),(2,'Automotive','<a href=\"http://webhitz.us/automotive/\" name=\"cat_2\" style=\"\">Automotive</a>',';0;'),(3,'Business','<a href=\"http://webhitz.us/business/\" name=\"cat_3\" style=\"\">Business</a>',';0;'),(4,'Careers & Jobs','<a href=\"http://webhitz.us/careers-jobs/\" name=\"cat_4\" style=\"\">Careers & Jobs</a>',';0;'),(5,'Clothing','<a href=\"http://webhitz.us/clothing/\" name=\"cat_5\" style=\"\">Clothing</a>',';0;'),(6,'Communications','<a href=\"http://webhitz.us/communications/\" name=\"cat_6\" style=\"\">Communications</a>',';0;'),(7,'Computer & Internet','<a href=\"http://webhitz.us/computer-internet/\" name=\"cat_7\" style=\"\">Computer & Internet</a>',';0;'),(8,'Construction and Maintenance','<a href=\"http://webhitz.us/construction-and-maintenance/\" name=\"cat_8\" style=\"\">Construction and Maintenance</a>',';0;'),(9,'Dental Care','<a href=\"http://webhitz.us/dental-care/\" name=\"cat_9\" style=\"\">Dental Care</a>',';0;'),(10,'Education','<a href=\"http://webhitz.us/education/\" name=\"cat_10\" style=\"\">Education</a>',';0;'),(11,'Employment','<a href=\"http://webhitz.us/employment/\" name=\"cat_11\" style=\"\">Employment</a>',';0;'),(12,'Gifts','<a href=\"http://webhitz.us/gifts/\" name=\"cat_12\" style=\"\">Gifts</a>',';0;'),(13,'Hardware & Software','<a href=\"http://webhitz.us/hardware-software/\" name=\"cat_13\" style=\"\">Hardware & Software</a>',';0;'),(14,'Health & fitness','<a href=\"http://webhitz.us/health-fitness/\" name=\"cat_14\" style=\"\">Health & fitness</a>',';0;'),(15,'Healthcare','<a href=\"http://webhitz.us/healthcare/\" name=\"cat_15\" style=\"\">Healthcare</a>',';0;'),(16,'Heating, Ventilating and Air Conditioning','<a href=\"http://webhitz.us/heating-ventilating-and-air-conditioning/\" name=\"cat_16\" style=\"\">Heating, Ventilating and Air Conditioning</a>',';0;'),(17,'Home & Garden Making','<a href=\"http://webhitz.us/home-garden-making/\" name=\"cat_17\" style=\"\">Home & Garden Making</a>',';0;'),(18,'Home Improvement & Appliances','<a href=\"http://webhitz.us/home-improvement-appliances/\" name=\"cat_18\" style=\"\">Home Improvement & Appliances</a>',';0;'),(19,'Hotels','<a href=\"http://webhitz.us/hotels/\" name=\"cat_19\" style=\"\">Hotels</a>',';0;'),(20,'Insurance Providers','<a href=\"http://webhitz.us/insurance-providers/\" name=\"cat_20\" style=\"\">Insurance Providers</a>',';0;'),(21,'Law & Legal','<a href=\"http://webhitz.us/law-legal/\" name=\"cat_21\" style=\"\">Law & Legal</a>',';0;'),(22,'Lawyers & Attorneys','<a href=\"http://webhitz.us/lawyers-attorneys/\" name=\"cat_22\" style=\"\">Lawyers & Attorneys</a>',';0;'),(23,'Lifestyle & Society','<a href=\"http://webhitz.us/lifestyle-society/\" name=\"cat_23\" style=\"\">Lifestyle & Society</a>',';0;'),(24,'Medicine & Surgery','<a href=\"http://webhitz.us/medicine-surgery/\" name=\"cat_24\" style=\"\">Medicine & Surgery</a>',';0;'),(25,'Finance & Investment','<a href=\"http://webhitz.us/finance-investment/\" name=\"cat_25\" style=\"\">Finance & Investment</a>',';0;'),(26,'News & Media','<a href=\"http://webhitz.us/news-media/\" name=\"cat_26\" style=\"\">News & Media</a>',';0;'),(27,'Plumbing Contractors','<a href=\"http://webhitz.us/plumbing-contractors/\" name=\"cat_27\" style=\"\">Plumbing Contractors</a>',';0;'),(28,'Real Estate & Property','<a href=\"http://webhitz.us/real-estate-property/\" name=\"cat_28\" style=\"\">Real Estate & Property</a>',';0;'),(29,'Science','<a href=\"http://webhitz.us/science/\" name=\"cat_29\" style=\"\">Science</a>',';0;'),(30,'Shopping and Sales','<a href=\"http://webhitz.us/shopping-and-sales/\" name=\"cat_30\" style=\"\">Shopping and Sales</a>',';0;'),(31,'Sports & Recreation','<a href=\"http://webhitz.us/sports-recreation/\" name=\"cat_31\" style=\"\">Sports & Recreation</a>',';0;'),(32,'Transportation Services','<a href=\"http://webhitz.us/transportation-services/\" name=\"cat_32\" style=\"\">Transportation Services</a>',';0;'),(33,'Travel & Tour','<a href=\"http://webhitz.us/travel-tour/\" name=\"cat_33\" style=\"\">Travel & Tour</a>',';0;'),(34,'Weddings','<a href=\"http://webhitz.us/weddings/\" name=\"cat_34\" style=\"\">Weddings</a>',';0;'),(35,'SEO Services','<a href=\"http://webhitz.us/seo-services/\" name=\"cat_35\" style=\"\">SEO Services</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 DEFAULT CHARSET=latin1;

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


--
-- 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,'jackiebenjamq15b35','2011-10-18','My Favorites',NULL),(2,'hymanwadeh56c59','2011-10-19','My Favorites',NULL),(3,'ellisbeaut21u33','2011-10-31','My Favorites',NULL),(4,'daleparkerh59l35','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 (4,'g',0,'2012-01-26'),(1,'g',0,'2012-01-09'),(2,'g',0,'2011-10-29'),(3,'g',0,'2012-02-25'),(5,'g',0,'2012-01-06'),(6,'g',0,'2012-01-26'),(7,'g',0,'2011-11-17'),(111,'g',0,'2011-11-28'),(465,'g',0,'2011-11-28'),(527,'g',0,'2011-11-28'),(530,'g',0,'2011-11-28'),(531,'g',0,'2011-11-28'),(254,'g',0,'2011-11-28'),(113,'g',0,'2011-11-28'),(263,'g',0,'2011-11-28'),(564,'g',0,'2011-11-28'),(102,'g',0,'2011-11-29'),(35,'g',0,'2011-11-29'),(100,'g',0,'2011-11-29'),(204,'g',0,'2011-11-29'),(192,'g',0,'2011-11-29'),(106,'g',0,'2011-11-29'),(187,'g',0,'2011-11-29'),(112,'g',0,'2011-11-29'),(431,'g',0,'2011-11-29'),(332,'g',0,'2011-11-29'),(212,'g',0,'2011-11-29'),(518,'g',0,'2011-11-29'),(105,'g',0,'2011-11-29'),(280,'g',0,'2011-11-29'),(167,'g',0,'2011-11-29'),(400,'g',0,'2011-11-29'),(169,'g',0,'2011-11-29'),(371,'g',0,'2011-11-29'),(331,'g',0,'2011-11-29'),(359,'g',0,'2011-11-29'),(249,'g',0,'2011-11-29'),(492,'g',0,'2011-11-29'),(456,'g',0,'2011-11-29'),(600,'g',0,'2011-11-29'),(554,'g',0,'2011-11-29'),(493,'g',0,'2011-11-29'),(241,'g',0,'2011-11-29'),(342,'g',0,'2011-11-29'),(8,'g',0,'2011-11-29'),(70,'g',0,'2011-11-29'),(85,'g',0,'2011-11-29'),(13,'g',0,'2011-11-29'),(166,'g',0,'2011-11-29'),(133,'g',0,'2011-11-29'),(123,'g',0,'2011-11-29'),(110,'g',0,'2011-11-29'),(141,'g',0,'2011-11-29'),(107,'g',0,'2011-11-29'),(97,'g',0,'2011-11-29'),(10,'g',0,'2011-11-29'),(98,'g',0,'2011-11-29'),(120,'g',0,'2011-11-29'),(150,'g',0,'2011-11-29'),(129,'g',0,'2011-11-29'),(140,'g',0,'2011-11-29'),(119,'g',0,'2011-11-29'),(148,'g',0,'2011-11-29'),(139,'g',0,'2011-11-29'),(74,'g',0,'2011-11-30'),(84,'g',0,'2011-11-30'),(76,'g',0,'2011-11-30'),(57,'g',0,'2011-11-30'),(54,'g',0,'2011-11-30'),(58,'g',0,'2011-11-30'),(33,'g',0,'2011-11-30'),(77,'g',0,'2011-11-30'),(56,'g',0,'2011-11-30'),(78,'g',0,'2011-11-30'),(9,'g',0,'2011-11-30'),(86,'g',0,'2011-11-30'),(34,'g',0,'2011-11-30'),(91,'g',0,'2011-11-30'),(87,'g',0,'2011-11-30'),(28,'g',0,'2011-11-30'),(82,'g',0,'2011-11-30'),(45,'g',0,'2011-11-30'),(29,'g',0,'2011-11-30'),(88,'g',0,'2011-11-30'),(817,'g',0,'2011-11-30'),(902,'g',0,'2011-11-30'),(475,'g',0,'2011-11-30'),(978,'g',0,'2011-11-30'),(463,'g',0,'2011-11-30'),(173,'g',0,'2011-11-30'),(444,'g',0,'2011-11-30'),(487,'g',0,'2011-11-30'),(562,'g',0,'2011-11-30'),(970,'g',0,'2011-11-30'),(451,'g',0,'2011-11-30'),(75,'g',0,'2011-11-30'),(89,'g',0,'2011-11-30'),(90,'g',0,'2011-11-30'),(47,'g',0,'2011-11-30'),(94,'g',0,'2011-11-30'),(42,'g',0,'2011-11-30'),(152,'g',0,'2011-11-30'),(336,'g',0,'2011-11-30'),(117,'g',0,'2011-11-30'),(311,'g',0,'2011-11-30'),(21,'g',0,'2011-12-01'),(27,'g',0,'2011-12-01'),(48,'g',0,'2011-12-01'),(20,'g',0,'2011-12-01'),(49,'g',0,'2011-12-01'),(23,'g',0,'2011-12-01'),(26,'g',0,'2011-12-01'),(14,'g',0,'2011-12-01'),(424,'g',0,'2011-12-01'),(278,'g',0,'2011-12-01'),(678,'g',0,'2011-12-01'),(373,'g',0,'2011-12-01'),(669,'g',0,'2011-12-01'),(286,'g',0,'2011-12-01'),(513,'g',0,'2011-12-01'),(549,'g',0,'2011-12-01'),(1007,'g',0,'2011-12-01'),(71,'g',0,'2011-12-01'),(73,'g',0,'2011-12-01'),(559,'g',0,'2011-12-01'),(577,'g',0,'2011-12-01'),(563,'g',0,'2011-12-01'),(415,'g',0,'2011-12-01'),(579,'g',0,'2011-12-01'),(580,'g',0,'2011-12-01'),(735,'g',0,'2011-12-01'),(578,'g',0,'2011-12-01'),(576,'g',0,'2011-12-01'),(381,'g',0,'2011-12-01'),(146,'g',0,'2011-12-01'),(209,'g',0,'2011-12-01'),(395,'g',0,'2011-12-01'),(488,'g',0,'2011-12-01'),(477,'g',0,'2011-12-02'),(277,'g',0,'2011-12-02'),(228,'g',0,'2011-12-02'),(213,'g',0,'2011-12-02'),(37,'g',0,'2011-12-02'),(59,'g',0,'2011-12-02'),(36,'g',0,'2011-12-02'),(51,'g',0,'2011-12-02'),(433,'g',0,'2011-12-02'),(412,'g',0,'2011-12-02'),(143,'g',0,'2011-12-02'),(258,'g',0,'2011-12-02'),(987,'g',0,'2011-12-02'),(503,'g',0,'2011-12-02'),(72,'g',0,'2011-12-02'),(1232,'g',0,'2011-12-02'),(235,'g',0,'2011-12-02'),(801,'g',0,'2011-12-02'),(265,'g',0,'2011-12-02'),(144,'g',0,'2011-12-02'),(261,'g',0,'2011-12-02'),(597,'g',0,'2011-12-02'),(190,'g',0,'2011-12-02'),(130,'g',0,'2011-12-02'),(253,'g',0,'2011-12-02'),(138,'g',0,'2011-12-02'),(366,'g',0,'2011-12-02'),(118,'g',0,'2011-12-02'),(18,'g',0,'2011-12-03'),(16,'g',0,'2011-12-03'),(12,'g',0,'2011-12-03'),(145,'g',0,'2011-12-03'),(741,'g',0,'2011-12-03'),(418,'g',0,'2011-12-03'),(647,'g',0,'2011-12-03'),(425,'g',0,'2011-12-03'),(267,'g',0,'2011-12-03'),(648,'g',0,'2011-12-03'),(1354,'g',0,'2011-12-03'),(625,'g',0,'2011-12-03'),(68,'g',0,'2011-12-03'),(66,'g',0,'2011-12-03'),(282,'g',0,'2011-12-03'),(108,'g',0,'2011-12-03'),(273,'g',0,'2011-12-03'),(227,'g',0,'2011-12-03'),(178,'g',0,'2011-12-03'),(309,'g',0,'2011-12-03'),(223,'g',0,'2011-12-03'),(216,'g',0,'2011-12-03'),(404,'g',0,'2011-12-05'),(53,'g',0,'2011-12-05'),(31,'g',0,'2011-12-05'),(352,'g',0,'2011-12-05'),(403,'g',0,'2011-12-05'),(328,'g',0,'2011-12-05'),(377,'g',0,'2011-12-05'),(405,'g',0,'2011-12-05'),(345,'g',0,'2011-12-05'),(406,'g',0,'2011-12-05'),(44,'g',0,'2011-12-05'),(337,'g',0,'2011-12-05'),(443,'g',0,'2011-12-05'),(137,'g',0,'2011-12-05'),(432,'g',0,'2011-12-05'),(392,'g',0,'2011-12-05'),(188,'g',0,'2011-12-05'),(358,'g',0,'2011-12-05'),(343,'g',0,'2011-12-05'),(134,'g',0,'2011-12-05'),(40,'g',0,'2011-12-05'),(30,'g',0,'2011-12-05'),(15,'g',0,'2011-12-05'),(43,'g',0,'2011-12-05'),(83,'g',0,'2011-12-05'),(79,'g',0,'2011-12-05'),(151,'g',0,'2011-12-05'),(116,'g',0,'2011-12-05'),(104,'g',0,'2011-12-05'),(115,'g',0,'2011-12-05'),(61,'g',0,'2011-12-05'),(46,'g',0,'2011-12-05'),(55,'g',0,'2011-12-05'),(546,'g',0,'2011-12-05'),(790,'g',0,'2011-12-05'),(262,'g',0,'2011-12-05'),(385,'g',0,'2011-12-05'),(991,'g',0,'2011-12-05'),(784,'g',0,'2011-12-05'),(775,'g',0,'2011-12-05'),(435,'g',0,'2011-12-06'),(667,'g',0,'2011-12-06'),(2797,'g',0,'2011-12-06'),(1164,'g',0,'2011-12-06'),(1402,'g',0,'2011-12-06'),(3051,'g',0,'2011-12-06'),(1919,'g',0,'2011-12-06'),(2164,'g',0,'2011-12-06'),(19,'g',0,'2011-12-07'),(32,'g',0,'2011-12-07'),(96,'g',0,'2011-12-07'),(1737,'g',0,'2011-12-07'),(2873,'g',0,'2011-12-07'),(1988,'g',0,'2011-12-07'),(2595,'g',0,'2011-12-07'),(52,'g',0,'2011-12-07'),(63,'g',0,'2011-12-07'),(142,'g',0,'2011-12-07'),(172,'g',0,'2011-12-07'),(181,'g',0,'2011-12-07'),(135,'g',0,'2011-12-07'),(616,'g',0,'2011-12-07'),(384,'g',0,'2011-12-07'),(514,'g',0,'2011-12-07'),(665,'g',0,'2011-12-07'),(420,'g',0,'2011-12-07'),(1400,'g',0,'2011-12-07'),(1149,'g',0,'2011-12-07'),(1243,'g',0,'2011-12-07'),(1345,'g',0,'2011-12-07'),(1113,'g',0,'2011-12-07'),(413,'g',0,'2011-12-08'),(581,'g',0,'2011-12-08'),(710,'g',0,'2011-12-08'),(494,'g',0,'2011-12-08'),(720,'g',0,'2011-12-08'),(721,'g',0,'2011-12-08'),(722,'g',0,'2011-12-08'),(727,'g',0,'2011-12-08'),(158,'g',0,'2011-12-08'),(811,'g',0,'2011-12-08'),(1561,'g',0,'2011-12-08'),(3353,'g',0,'2011-12-08'),(2419,'g',0,'2011-12-08'),(41,'g',0,'2011-12-08'),(17,'g',0,'2011-12-08'),(39,'g',0,'2011-12-08'),(62,'g',0,'2011-12-08'),(11,'g',0,'2011-12-08'),(38,'g',0,'2011-12-08'),(22,'g',0,'2011-12-08'),(303,'g',0,'2011-12-08'),(101,'g',0,'2011-12-08'),(109,'g',0,'2011-12-08'),(635,'g',0,'2011-12-08'),(650,'g',0,'2011-12-08'),(748,'g',0,'2011-12-08'),(761,'g',0,'2011-12-08'),(652,'g',0,'2011-12-08'),(632,'g',0,'2011-12-08'),(633,'g',0,'2011-12-08'),(673,'g',0,'2011-12-08'),(677,'g',0,'2011-12-08'),(630,'g',0,'2011-12-08'),(50,'g',0,'2011-12-09'),(60,'g',0,'2011-12-09'),(370,'g',0,'2011-12-09'),(466,'g',0,'2011-12-09'),(557,'g',0,'2011-12-09'),(483,'g',0,'2011-12-09'),(252,'g',0,'2011-12-09'),(469,'g',0,'2011-12-09'),(453,'g',0,'2011-12-09'),(164,'g',0,'2011-12-09'),(965,'g',0,'2011-12-10'),(236,'g',0,'2011-12-10'),(1715,'g',0,'2011-12-10'),(4024,'g',0,'2011-12-10'),(3507,'g',0,'2011-12-10'),(3085,'g',0,'2011-12-10'),(1431,'g',0,'2011-12-10'),(4461,'g',0,'2011-12-10'),(2573,'g',0,'2011-12-10'),(2198,'g',0,'2011-12-10'),(3731,'g',0,'2011-12-10'),(3990,'g',0,'2011-12-10'),(4566,'g',0,'2011-12-12'),(4714,'g',0,'2011-12-12'),(4466,'g',0,'2011-12-12'),(4752,'g',0,'2011-12-12'),(4813,'g',0,'2011-12-12'),(4474,'g',0,'2011-12-12'),(4751,'g',0,'2011-12-12'),(4861,'g',0,'2011-12-12'),(4309,'g',0,'2011-12-12'),(4299,'g',0,'2011-12-12'),(4283,'g',0,'2011-12-12'),(4303,'g',0,'2011-12-12'),(4279,'g',0,'2011-12-12'),(4259,'g',0,'2011-12-12'),(4281,'g',0,'2011-12-12'),(4282,'g',0,'2011-12-12'),(4302,'g',0,'2011-12-12'),(4301,'g',0,'2011-12-12'),(4336,'g',0,'2012-03-03'),(4823,'g',0,'2011-12-12'),(4487,'g',0,'2012-03-03'),(4942,'g',0,'2011-12-12'),(4723,'g',0,'2012-03-03'),(4790,'g',0,'2011-12-12'),(4479,'g',0,'2012-03-03'),(4338,'g',0,'2012-03-03'),(4786,'g',0,'2012-01-24'),(4789,'g',0,'2012-01-24'),(4685,'g',0,'2011-12-12'),(4250,'g',0,'2011-12-12'),(4662,'g',0,'2011-12-12'),(4495,'g',0,'2011-12-12'),(4697,'g',0,'2011-12-12'),(4350,'g',0,'2011-12-12'),(4251,'g',0,'2011-12-12'),(4647,'g',0,'2011-12-12'),(4698,'g',0,'2011-12-12'),(4351,'g',0,'2011-12-12'),(4682,'g',0,'2011-12-12'),(4263,'g',0,'2011-12-12'),(4284,'g',0,'2011-12-12'),(4276,'g',0,'2011-12-12'),(4660,'g',0,'2011-12-12'),(4343,'g',0,'2011-12-12'),(4262,'g',0,'2011-12-12'),(4363,'g',0,'2011-12-12'),(4609,'g',0,'2011-12-12'),(4368,'g',0,'2011-12-12'),(4977,'g',0,'2011-12-12'),(4335,'g',0,'2011-12-12'),(4332,'g',0,'2011-12-12'),(4358,'g',0,'2011-12-12'),(4310,'g',0,'2011-12-12'),(4239,'g',0,'2011-12-12'),(4366,'g',0,'2011-12-12'),(4348,'g',0,'2011-12-12'),(4234,'g',0,'2011-12-12'),(4295,'g',0,'2011-12-12'),(4391,'g',0,'2011-12-12'),(4567,'g',0,'2011-12-12'),(4359,'g',0,'2011-12-12'),(4269,'g',0,'2011-12-12'),(4640,'g',0,'2011-12-12'),(4681,'g',0,'2011-12-12'),(4695,'g',0,'2011-12-12'),(4561,'g',0,'2011-12-12'),(4587,'g',0,'2011-12-12'),(4413,'g',0,'2011-12-12'),(4362,'g',0,'2011-12-12'),(4734,'g',0,'2012-03-06'),(4313,'g',0,'2012-03-06'),(4709,'g',0,'2012-03-06'),(4746,'g',0,'2011-12-12'),(4398,'g',0,'2011-12-12'),(4821,'g',0,'2011-12-12'),(4721,'g',0,'2012-03-06'),(4700,'g',0,'2012-03-06'),(4599,'g',0,'2011-12-12'),(4244,'g',0,'2012-01-12'),(4491,'g',0,'2012-01-12'),(4595,'g',0,'2012-01-12'),(4596,'g',0,'2012-01-12'),(4370,'g',0,'2012-01-12'),(4238,'g',0,'2012-01-12'),(4242,'g',0,'2012-01-12'),(4601,'g',0,'2011-12-12'),(4598,'g',0,'2012-01-12'),(5217,'g',0,'2011-12-12'),(4304,'g',0,'2011-12-12'),(4268,'g',0,'2011-12-12'),(4241,'g',0,'2011-12-12'),(4266,'g',0,'2011-12-12'),(4256,'g',0,'2011-12-12'),(4329,'g',0,'2011-12-12'),(5227,'g',0,'2011-12-12'),(4340,'g',0,'2011-12-12'),(4308,'g',0,'2011-12-12'),(4438,'g',0,'2012-02-13'),(4298,'g',0,'2012-02-13'),(4643,'g',0,'2011-12-12'),(5229,'g',0,'2011-12-12'),(4434,'g',0,'2011-12-12'),(4676,'g',0,'2011-12-12'),(4501,'g',0,'2011-12-12'),(4453,'g',0,'2011-12-12'),(4371,'g',0,'2012-02-18'),(4296,'g',0,'2012-02-18'),(5214,'g',0,'2011-12-13'),(4954,'g',0,'2011-12-13'),(4772,'g',0,'2011-12-13'),(4808,'g',0,'2011-12-13'),(4622,'g',0,'2011-12-13'),(4510,'g',0,'2012-01-25'),(4620,'g',0,'2012-01-25'),(4945,'g',0,'2011-12-13'),(4502,'g',0,'2012-01-25'),(4672,'g',0,'2011-12-13'),(5228,'g',0,'2011-12-13'),(5224,'g',0,'2011-12-13'),(5226,'g',0,'2011-12-13'),(5222,'g',0,'2011-12-13'),(5236,'g',0,'2011-12-13'),(5215,'g',0,'2011-12-13'),(5232,'g',0,'2011-12-13'),(5212,'g',0,'2011-12-13'),(4325,'g',0,'2011-12-13'),(5233,'g',0,'2011-12-13'),(4560,'g',0,'2011-12-13'),(4315,'g',0,'2012-02-18'),(4319,'g',0,'2012-02-18'),(4314,'g',0,'2012-02-18'),(4342,'g',0,'2012-02-18'),(5218,'g',0,'2011-12-13'),(4535,'g',0,'2012-02-18'),(4300,'g',0,'2012-02-13'),(4377,'g',0,'2012-02-18'),(4272,'g',0,'2012-02-13'),(4392,'g',0,'2012-02-18'),(5219,'g',0,'2011-12-13'),(4588,'g',0,'2011-12-13'),(4412,'g',0,'2012-02-18'),(4648,'g',0,'2011-12-13'),(4394,'g',0,'2012-02-13'),(4261,'g',0,'2012-02-13'),(4417,'g',0,'2011-12-13'),(4437,'g',0,'2011-12-13'),(4618,'g',0,'2011-12-13'),(5225,'g',0,'2011-12-13'),(4254,'g',0,'2011-12-13'),(4270,'g',0,'2011-12-13'),(4255,'g',0,'2011-12-13'),(5273,'g',0,'2011-12-13'),(5238,'g',0,'2011-12-13'),(4235,'g',0,'2011-12-13'),(4311,'g',0,'2011-12-13'),(4307,'g',0,'2011-12-13'),(4260,'g',0,'2011-12-13'),(4887,'g',0,'2011-12-13'),(5231,'g',0,'2011-12-14'),(5265,'g',0,'2011-12-14'),(4240,'g',0,'2011-12-14'),(5213,'g',0,'2011-12-14'),(4246,'g',0,'2011-12-14'),(5266,'g',0,'2011-12-14'),(5230,'g',0,'2011-12-14'),(5244,'g',0,'2011-12-14'),(4943,'g',0,'2011-12-14'),(4684,'g',0,'2011-12-14'),(4354,'g',0,'2011-12-14'),(4236,'g',0,'2011-12-14'),(4365,'g',0,'2011-12-14'),(4345,'g',0,'2011-12-14'),(4323,'g',0,'2011-12-14'),(4364,'g',0,'2011-12-14'),(4375,'g',0,'2011-12-14'),(4344,'g',0,'2011-12-14'),(4322,'g',0,'2011-12-14'),(4373,'g',0,'2011-12-14'),(4728,'g',0,'2011-12-15'),(4275,'g',0,'2011-12-15'),(4724,'g',0,'2011-12-15'),(4389,'g',0,'2011-12-15'),(4477,'g',0,'2011-12-15'),(4742,'g',0,'2011-12-15'),(4285,'g',0,'2011-12-15'),(4711,'g',0,'2011-12-15'),(4617,'g',0,'2011-12-15'),(4816,'g',0,'2011-12-15'),(5150,'g',0,'2011-12-15'),(5276,'g',0,'2011-12-15'),(4486,'g',0,'2012-01-15'),(4286,'g',0,'2012-01-15'),(4271,'g',0,'2012-01-15'),(4280,'g',0,'2012-01-15'),(4805,'g',0,'2012-01-15'),(4633,'g',0,'2012-01-15'),(4941,'g',0,'2011-12-15'),(4668,'g',0,'2011-12-15'),(4773,'g',0,'2011-12-15'),(4632,'g',0,'2011-12-15'),(4878,'g',0,'2011-12-15'),(5275,'g',0,'2011-12-15'),(4890,'g',0,'2011-12-15'),(4924,'g',0,'2011-12-15'),(4885,'g',0,'2011-12-15'),(4901,'g',0,'2011-12-15'),(4843,'g',0,'2011-12-15'),(4776,'g',0,'2011-12-15'),(4946,'g',0,'2011-12-15'),(4882,'g',0,'2011-12-15'),(4293,'g',0,'2012-03-05'),(5245,'g',0,'2011-12-16'),(4333,'g',0,'2012-03-05'),(5258,'g',0,'2012-03-05'),(4441,'g',0,'2012-03-05'),(5251,'g',0,'2012-03-05'),(5223,'g',0,'2011-12-16'),(5216,'g',0,'2011-12-16'),(4403,'g',0,'2012-03-05'),(4291,'g',0,'2012-03-05'),(5270,'g',0,'2011-12-16'),(5272,'g',0,'2012-02-13'),(5255,'g',0,'2011-12-16'),(5237,'g',0,'2011-12-16'),(5220,'g',0,'2011-12-16'),(5235,'g',0,'2011-12-16'),(4651,'g',0,'2011-12-16'),(4653,'g',0,'2011-12-16'),(4552,'g',0,'2012-01-29'),(4278,'g',0,'2012-01-29'),(4654,'g',0,'2011-12-16'),(4762,'g',0,'2011-12-16'),(4652,'g',0,'2011-12-16'),(4580,'g',0,'2011-12-16'),(4625,'g',0,'2011-12-16'),(4257,'g',0,'2012-01-29'),(4571,'g',0,'2011-12-16'),(5260,'g',0,'2012-03-03'),(5293,'g',0,'2012-02-18'),(5221,'g',0,'2011-12-17'),(5287,'g',0,'2012-02-13'),(5298,'g',0,'2012-02-18'),(5239,'g',0,'2011-12-17'),(5247,'g',0,'2011-12-17'),(5294,'g',0,'2012-02-18'),(5269,'g',0,'2012-02-18'),(5256,'g',0,'2012-02-18'),(5234,'g',0,'2011-12-17'),(5288,'g',0,'2012-02-13'),(5268,'g',0,'2012-02-19'),(5263,'g',0,'2011-12-17'),(5261,'g',0,'2011-12-17'),(5257,'g',0,'2011-12-17'),(5271,'g',0,'2012-02-18'),(5292,'g',0,'2011-12-17'),(5259,'g',0,'2011-12-17'),(5278,'g',0,'2012-02-18'),(5277,'g',0,'2012-02-18'),(5267,'g',0,'2011-12-17'),(4369,'g',0,'2012-01-30'),(4297,'g',0,'2012-01-30'),(4415,'g',0,'2012-01-30'),(4858,'g',0,'2011-12-17'),(4489,'g',0,'2011-12-17'),(4904,'g',0,'2011-12-17'),(5106,'g',0,'2011-12-17'),(4936,'g',0,'2011-12-17'),(5149,'g',0,'2011-12-17'),(5289,'g',0,'2011-12-17'),(5098,'g',0,'2011-12-17'),(4928,'g',0,'2011-12-17'),(5104,'g',0,'2011-12-17'),(4914,'g',0,'2011-12-17'),(5151,'g',0,'2011-12-17'),(4478,'g',0,'2012-01-30'),(4485,'g',0,'2012-01-30'),(5305,'g',0,'2011-12-18'),(5280,'g',0,'2012-02-18'),(5254,'g',0,'2012-02-18'),(4527,'g',0,'2011-12-18'),(4243,'g',0,'2011-12-18'),(4264,'g',0,'2011-12-18'),(4265,'g',0,'2011-12-18'),(4248,'g',0,'2011-12-18'),(4287,'g',0,'2011-12-18'),(4334,'g',0,'2011-12-18'),(4237,'g',0,'2011-12-18'),(4326,'g',0,'2011-12-18'),(4267,'g',0,'2011-12-18'),(5290,'g',0,'2011-12-18'),(5246,'g',0,'2011-12-18'),(5262,'g',0,'2011-12-18'),(5299,'g',0,'2011-12-18'),(5252,'g',0,'2011-12-18'),(5279,'g',0,'2011-12-18'),(5307,'g',0,'2011-12-18'),(5285,'g',0,'2011-12-18'),(4355,'g',0,'2012-01-30'),(4460,'g',0,'2012-01-30'),(5253,'g',0,'2012-02-18'),(5053,'g',0,'2011-12-19'),(5105,'g',0,'2011-12-19'),(5064,'g',0,'2011-12-19'),(5049,'g',0,'2011-12-19'),(5102,'g',0,'2011-12-19'),(5147,'g',0,'2011-12-19'),(4952,'g',0,'2011-12-19'),(4883,'g',0,'2011-12-21'),(4873,'g',0,'2011-12-21'),(4892,'g',0,'2011-12-21'),(4895,'g',0,'2011-12-21'),(4897,'g',0,'2011-12-21'),(4916,'g',0,'2011-12-21'),(4912,'g',0,'2011-12-21'),(4894,'g',0,'2011-12-21'),(4884,'g',0,'2011-12-21'),(4925,'g',0,'2011-12-21'),(4360,'g',0,'2011-12-21'),(5248,'g',0,'2011-12-21'),(4321,'g',0,'2011-12-21'),(4245,'g',0,'2011-12-21'),(4367,'g',0,'2011-12-21'),(4258,'g',0,'2011-12-21'),(5297,'g',0,'2011-12-21'),(4288,'g',0,'2011-12-21'),(4277,'g',0,'2011-12-21'),(5296,'g',0,'2012-02-02'),(5249,'g',0,'2012-02-03'),(5318,'g',0,'2012-02-02'),(5325,'g',0,'2012-02-02'),(5302,'g',0,'2012-02-18'),(5295,'g',0,'2012-02-18'),(5312,'g',0,'2011-12-22'),(5315,'g',0,'2012-02-13'),(5313,'g',0,'2011-12-22'),(5324,'g',0,'2012-02-13'),(5316,'g',0,'2012-02-18'),(5331,'g',0,'2012-02-18'),(5337,'g',0,'2011-12-22'),(5317,'g',0,'2011-12-22'),(4452,'g',0,'2011-12-23'),(4448,'g',0,'2012-03-05'),(5338,'g',0,'2012-02-13'),(5322,'g',0,'2012-01-29'),(5321,'g',0,'2012-01-29'),(5274,'g',0,'2012-01-28'),(5341,'g',0,'2011-12-24'),(5335,'g',0,'2012-02-03'),(5264,'g',0,'2012-02-02'),(5333,'g',0,'2011-12-27'),(5357,'g',0,'2012-01-30'),(5323,'g',0,'2011-12-27'),(5355,'g',0,'2012-01-29'),(5326,'g',0,'2011-12-27'),(5314,'g',0,'2011-12-27'),(5330,'g',0,'2011-12-28'),(5365,'g',0,'2011-12-28'),(5381,'g',0,'2011-12-28'),(5329,'g',0,'2011-12-28'),(5334,'g',0,'2011-12-28'),(5301,'g',0,'2011-12-28'),(5358,'g',0,'2011-12-28'),(5332,'g',0,'2011-12-28'),(5366,'g',0,'2011-12-28'),(5379,'g',0,'2011-12-28'),(5369,'g',0,'2011-12-28'),(5376,'g',0,'2011-12-28'),(5385,'g',0,'2011-12-28'),(5351,'g',0,'2011-12-28'),(5368,'g',0,'2011-12-28'),(5350,'g',0,'2012-03-06'),(5388,'g',0,'2011-12-28'),(5397,'g',0,'2011-12-28'),(5352,'g',0,'2011-12-28'),(5380,'g',0,'2011-12-28'),(5384,'g',0,'2012-01-29'),(5346,'g',0,'2012-02-18'),(5362,'g',0,'2012-02-18'),(5375,'g',0,'2012-02-13'),(5371,'g',0,'2011-12-29'),(5240,'g',0,'2012-02-18'),(5394,'g',0,'2012-01-30'),(5374,'g',0,'2012-01-30'),(5387,'g',0,'2012-01-30'),(5361,'g',0,'2012-02-13'),(5347,'g',0,'2011-12-30'),(5386,'g',0,'2012-02-13'),(5360,'g',0,'2012-02-13'),(5389,'g',0,'2011-12-30'),(5398,'g',0,'2011-12-30'),(5390,'g',0,'2011-12-30'),(5393,'g',0,'2011-12-30'),(5377,'g',0,'2012-02-18'),(5367,'g',0,'2012-02-13'),(5410,'g',0,'2011-12-30'),(5383,'g',0,'2011-12-30'),(5354,'g',0,'2012-02-13'),(5378,'g',0,'2012-02-23'),(5402,'g',0,'2011-12-30'),(5363,'g',0,'2011-12-30'),(5392,'g',0,'2011-12-30'),(5370,'g',0,'2011-12-30'),(5401,'g',0,'2011-12-30'),(5399,'g',0,'2011-12-30'),(5395,'g',0,'2011-12-30'),(4663,'g',0,'2012-02-13'),(5284,'g',0,'2012-02-13'),(5344,'g',0,'2012-02-02'),(5396,'g',0,'2012-02-02'),(5408,'g',0,'2012-02-02'),(5359,'g',0,'2012-02-02'),(4629,'g',0,'2012-02-13'),(5336,'g',0,'2012-02-03'),(5281,'g',0,'2012-02-18'),(4696,'g',0,'2012-02-13'),(5353,'g',0,'2012-02-02'),(5348,'g',0,'2012-02-02'),(5404,'g',0,'2012-01-02'),(5372,'g',0,'2012-01-02'),(5282,'g',0,'2012-02-18'),(5429,'g',0,'2012-01-03'),(5373,'g',0,'2012-01-03'),(5431,'g',0,'2012-01-03'),(5241,'g',0,'2012-02-13'),(5343,'g',0,'2012-01-03'),(5411,'g',0,'2012-01-03'),(5242,'g',0,'2012-02-18'),(5283,'g',0,'2012-02-18'),(5412,'g',0,'2012-01-03'),(5425,'g',0,'2012-01-03'),(5433,'g',0,'2012-02-15'),(5391,'g',0,'2012-01-04'),(5413,'g',0,'2012-01-04'),(5417,'g',0,'2012-02-13'),(5439,'g',0,'2012-01-04'),(5438,'g',0,'2012-01-04'),(5441,'g',0,'2012-01-04'),(5446,'g',0,'2012-01-05'),(4471,'g',0,'2012-01-05'),(4457,'g',0,'2012-01-05'),(4934,'g',0,'2012-01-05'),(4539,'g',0,'2012-01-05'),(4664,'g',0,'2012-01-06'),(4642,'g',0,'2012-01-06'),(4665,'g',0,'2012-01-06'),(5056,'g',0,'2012-01-06'),(4953,'g',0,'2012-01-06'),(4931,'g',0,'2012-01-06'),(4614,'g',0,'2012-01-06'),(5055,'g',0,'2012-01-06'),(4949,'g',0,'2012-01-06'),(4569,'g',0,'2012-01-06'),(4679,'g',0,'2012-01-06'),(4524,'g',0,'2012-01-06'),(5466,'g',0,'2012-01-06'),(5452,'g',0,'2012-01-06'),(5464,'g',0,'2012-01-06'),(5463,'g',0,'2012-01-06'),(5400,'g',0,'2012-01-06'),(5406,'g',0,'2012-01-06'),(5364,'g',0,'2012-01-06'),(5356,'g',0,'2012-01-06'),(5419,'g',0,'2012-01-06'),(5467,'g',0,'2012-01-06'),(5468,'g',0,'2012-01-06'),(5457,'g',0,'2012-02-18'),(5455,'g',0,'2012-01-07'),(5458,'g',0,'2012-01-07'),(5461,'g',0,'2012-01-07'),(5428,'g',0,'2012-01-07'),(5469,'g',0,'2012-01-07'),(5432,'g',0,'2012-01-07'),(5414,'g',0,'2012-01-07'),(5426,'g',0,'2012-01-07'),(5422,'g',0,'2012-01-07'),(5454,'g',0,'2012-01-07'),(5449,'g',0,'2012-01-07'),(5450,'g',0,'2012-01-07'),(5459,'g',0,'2012-01-07'),(5456,'g',0,'2012-01-07'),(5416,'g',0,'2012-01-07'),(5470,'g',0,'2012-01-07'),(5462,'g',0,'2012-01-07'),(4410,'g',0,'2012-01-07'),(4455,'g',0,'2012-01-07'),(4406,'g',0,'2012-01-07'),(4424,'g',0,'2012-01-07'),(4431,'g',0,'2012-01-08'),(4397,'g',0,'2012-01-08'),(5382,'g',0,'2012-02-18'),(5430,'g',0,'2012-01-08'),(5421,'g',0,'2012-01-08'),(5465,'g',0,'2012-01-08'),(5443,'g',0,'2012-01-08'),(5435,'g',0,'2012-01-08'),(5472,'g',0,'2012-01-08'),(4732,'g',0,'2012-01-09'),(4797,'g',0,'2012-01-09'),(4760,'g',0,'2012-01-09'),(4871,'g',0,'2012-01-09'),(5436,'g',0,'2012-01-09'),(5423,'g',0,'2012-02-21'),(5447,'g',0,'2012-01-09'),(5445,'g',0,'2012-01-09'),(5060,'g',0,'2012-01-09'),(5481,'g',0,'2012-01-09'),(5500,'g',0,'2012-01-09'),(5475,'g',0,'2012-01-09'),(5476,'g',0,'2012-01-09'),(5448,'g',0,'2012-01-09'),(5499,'g',0,'2012-01-09'),(5493,'g',0,'2012-01-09'),(5434,'g',0,'2012-01-09'),(5427,'g',0,'2012-01-09'),(5442,'g',0,'2012-01-09'),(5418,'g',0,'2012-01-10'),(5494,'g',0,'2012-02-16'),(5451,'g',0,'2012-02-16'),(5100,'g',0,'2012-01-10'),(5424,'g',0,'2012-01-10'),(5190,'g',0,'2012-01-10'),(5497,'g',0,'2012-01-10'),(5486,'g',0,'2012-01-10'),(5501,'g',0,'2012-01-10'),(5409,'g',0,'2012-01-10'),(5484,'g',0,'2012-01-10'),(5407,'g',0,'2012-01-10'),(5101,'g',0,'2012-01-11'),(5504,'g',0,'2012-01-11'),(5477,'g',0,'2012-01-11'),(5503,'g',0,'2012-01-11'),(5508,'g',0,'2012-01-11'),(5453,'g',0,'2012-01-11'),(5474,'g',0,'2012-01-11'),(5488,'g',0,'2012-01-11'),(5507,'g',0,'2012-01-11'),(5498,'g',0,'2012-01-11'),(5483,'g',0,'2012-01-11'),(5482,'g',0,'2012-01-11'),(5515,'g',0,'2012-01-12'),(5511,'g',0,'2012-01-12'),(5529,'g',0,'2012-01-12'),(5522,'g',0,'2012-01-12'),(5528,'g',0,'2012-01-12'),(5521,'g',0,'2012-01-12'),(5518,'g',0,'2012-01-12'),(5505,'g',0,'2012-01-13'),(5537,'g',0,'2012-01-13'),(5491,'g',0,'2012-02-15'),(5460,'g',0,'2012-02-15'),(5489,'g',0,'2012-02-15'),(5506,'g',0,'2012-02-15'),(5492,'g',0,'2012-02-15'),(5496,'g',0,'2012-02-15'),(5509,'g',0,'2012-01-13'),(5471,'g',0,'2012-02-15'),(5523,'g',0,'2012-02-15'),(5490,'g',0,'2012-02-15'),(5513,'g',0,'2012-02-28'),(5519,'g',0,'2012-01-15'),(5517,'g',0,'2012-01-15'),(5525,'g',0,'2012-01-15'),(5542,'g',0,'2012-01-15'),(5527,'g',0,'2012-01-15'),(5514,'g',0,'2012-01-15'),(5485,'g',0,'2012-01-16'),(5536,'g',0,'2012-01-16'),(5541,'g',0,'2012-01-16'),(5533,'g',0,'2012-01-16'),(5487,'g',0,'2012-03-06'),(5549,'g',0,'2012-01-16'),(5551,'g',0,'2012-01-16'),(5520,'g',0,'2012-01-16'),(5437,'g',0,'2012-03-06'),(4782,'g',0,'2012-01-16'),(4898,'g',0,'2012-01-16'),(4634,'g',0,'2012-01-17'),(4854,'g',0,'2012-01-17'),(5535,'g',0,'2012-01-17'),(5547,'g',0,'2012-01-17'),(5545,'g',0,'2012-01-17'),(5550,'g',0,'2012-01-17'),(4886,'g',0,'2012-01-19'),(4851,'g',0,'2012-01-19'),(5194,'g',0,'2012-01-19'),(5200,'g',0,'2012-01-19'),(5206,'g',0,'2012-01-19'),(5207,'g',0,'2012-01-19'),(5540,'g',0,'2012-01-19'),(5524,'g',0,'2012-01-19'),(5512,'g',0,'2012-01-19'),(5444,'g',0,'2012-01-19'),(5480,'g',0,'2012-01-19'),(5440,'g',0,'2012-01-19'),(5530,'g',0,'2012-01-20'),(5568,'g',0,'2012-01-20'),(5576,'g',0,'2012-01-20'),(5532,'g',0,'2012-01-21'),(4777,'g',0,'2012-01-21'),(5575,'g',0,'2012-01-21'),(5573,'g',0,'2012-01-21'),(5581,'g',0,'2012-01-21'),(4875,'g',0,'2012-01-21'),(5479,'g',0,'2012-01-21'),(5548,'g',0,'2012-01-21'),(4870,'g',0,'2012-01-22'),(5539,'g',0,'2012-01-22'),(5538,'g',0,'2012-01-22'),(5531,'g',0,'2012-01-22'),(5516,'g',0,'2012-01-22'),(4497,'g',0,'2012-03-05'),(4929,'g',0,'2012-01-22'),(4889,'g',0,'2012-01-22'),(5534,'g',0,'2012-01-22'),(5478,'g',0,'2012-01-22'),(5495,'g',0,'2012-01-22'),(5526,'g',0,'2012-01-23'),(5546,'g',0,'2012-01-23'),(5571,'g',0,'2012-02-22'),(5243,'g',0,'2012-01-24'),(5250,'g',0,'2012-01-24'),(5591,'g',0,'2012-01-24'),(5565,'g',0,'2012-01-24'),(5610,'g',0,'2012-01-24'),(5564,'g',0,'2012-01-24'),(5567,'g',0,'2012-01-24'),(5607,'g',0,'2012-01-24'),(5574,'g',0,'2012-01-24'),(5587,'g',0,'2012-01-24'),(5608,'g',0,'2012-01-24'),(5609,'g',0,'2012-01-24'),(4512,'g',0,'2012-01-25'),(4529,'g',0,'2012-01-25'),(4528,'g',0,'2012-01-25'),(4530,'g',0,'2012-01-25'),(4523,'g',0,'2012-01-25'),(4525,'g',0,'2012-01-25'),(4526,'g',0,'2012-01-25'),(4531,'g',0,'2012-01-25'),(4537,'g',0,'2012-01-25'),(4540,'g',0,'2012-01-25'),(5597,'g',0,'2012-01-25'),(4722,'g',0,'2012-01-25'),(4708,'g',0,'2012-01-25'),(4670,'g',0,'2012-01-25'),(4687,'g',0,'2012-01-25'),(4691,'g',0,'2012-01-25'),(4659,'g',0,'2012-01-25'),(4740,'g',0,'2012-01-25'),(4713,'g',0,'2012-01-25'),(4716,'g',0,'2012-01-25'),(4738,'g',0,'2012-01-25'),(4956,'g',0,'2012-01-25'),(4586,'g',0,'2012-01-25'),(4645,'g',0,'2012-01-25'),(4562,'g',0,'2012-01-25'),(4635,'g',0,'2012-01-25'),(4641,'g',0,'2012-01-25'),(4611,'g',0,'2012-01-25'),(4626,'g',0,'2012-01-25'),(4600,'g',0,'2012-01-25'),(4597,'g',0,'2012-01-25'),(4559,'g',0,'2012-01-25'),(5621,'g',0,'2012-01-25'),(5616,'g',0,'2012-01-26'),(5612,'g',0,'2012-01-26'),(5619,'g',0,'2012-01-26'),(4848,'g',0,'2012-01-26'),(4807,'g',0,'2012-01-26'),(4815,'g',0,'2012-01-26'),(4741,'g',0,'2012-01-26'),(4798,'g',0,'2012-01-26'),(4769,'g',0,'2012-01-26'),(4810,'g',0,'2012-01-26'),(4806,'g',0,'2012-01-26'),(4847,'g',0,'2012-01-26'),(4780,'g',0,'2012-01-26'),(4425,'g',0,'2012-01-26'),(4416,'g',0,'2012-01-26'),(4418,'g',0,'2012-01-26'),(4426,'g',0,'2012-01-26'),(4428,'g',0,'2012-01-26'),(4420,'g',0,'2012-01-26'),(4423,'g',0,'2012-01-26'),(4409,'g',0,'2012-01-26'),(4433,'g',0,'2012-01-26'),(4430,'g',0,'2012-01-26'),(4432,'g',0,'2012-01-26'),(4624,'g',0,'2012-01-26'),(4503,'g',0,'2012-01-26'),(4451,'g',0,'2012-01-26'),(4541,'g',0,'2012-01-26'),(4564,'g',0,'2012-01-26'),(4522,'g',0,'2012-01-26'),(4458,'g',0,'2012-01-26'),(4472,'g',0,'2012-01-26'),(4462,'g',0,'2012-01-26'),(4388,'g',0,'2012-01-26'),(4493,'g',0,'2012-01-26'),(4470,'g',0,'2012-01-26'),(4627,'g',0,'2012-01-26'),(4379,'g',0,'2012-01-26'),(4400,'g',0,'2012-01-26'),(4739,'g',0,'2012-01-26'),(4743,'g',0,'2012-01-26'),(4744,'g',0,'2012-01-26'),(4636,'g',0,'2012-01-26'),(4628,'g',0,'2012-01-26'),(4729,'g',0,'2012-01-26'),(4678,'g',0,'2012-01-26'),(4690,'g',0,'2012-01-26'),(4669,'g',0,'2012-01-26'),(4707,'g',0,'2012-01-26'),(5598,'g',0,'2012-01-26'),(5599,'g',0,'2012-01-26'),(5600,'g',0,'2012-01-26'),(4630,'g',0,'2012-01-26'),(4781,'g',0,'2012-01-26'),(4644,'g',0,'2012-01-26'),(4637,'g',0,'2012-01-26'),(4602,'g',0,'2012-01-26'),(4770,'g',0,'2012-01-26'),(4702,'g',0,'2012-01-26'),(4623,'g',0,'2012-01-26'),(4704,'g',0,'2012-01-26'),(4683,'g',0,'2012-01-26'),(5054,'g',0,'2012-01-26'),(4922,'g',0,'2012-01-26'),(4857,'g',0,'2012-01-26'),(4926,'g',0,'2012-01-26'),(5099,'g',0,'2012-01-26'),(5004,'g',0,'2012-01-26'),(4785,'g',0,'2012-01-26'),(4795,'g',0,'2012-01-26'),(4828,'g',0,'2012-01-26'),(4933,'g',0,'2012-01-26'),(4506,'g',0,'2012-03-05'),(4572,'g',0,'2012-01-26'),(4570,'g',0,'2012-01-26'),(4534,'g',0,'2012-01-26'),(4573,'g',0,'2012-01-26'),(4578,'g',0,'2012-01-26'),(4594,'g',0,'2012-01-26'),(4533,'g',0,'2012-01-26'),(4575,'g',0,'2012-01-26'),(4574,'g',0,'2012-01-26'),(5580,'g',0,'2012-01-27'),(5586,'g',0,'2012-01-27'),(5595,'g',0,'2012-01-27'),(5583,'g',0,'2012-01-27'),(5572,'g',0,'2012-01-27'),(5552,'g',0,'2012-01-27'),(5631,'g',0,'2012-01-27'),(5636,'g',0,'2012-01-27'),(5640,'g',0,'2012-01-27'),(5592,'g',0,'2012-01-27'),(5569,'g',0,'2012-03-02'),(5638,'g',0,'2012-01-28'),(5566,'g',0,'2012-01-28'),(5582,'g',0,'2012-01-28'),(5613,'g',0,'2012-01-28'),(5593,'g',0,'2012-01-28'),(5637,'g',0,'2012-01-28'),(5570,'g',0,'2012-03-02'),(5588,'g',0,'2012-01-28'),(5602,'g',0,'2012-01-28'),(5584,'g',0,'2012-01-28'),(5620,'g',0,'2012-01-28'),(5618,'g',0,'2012-01-28'),(5630,'g',0,'2012-01-28'),(5623,'g',0,'2012-01-28'),(5626,'g',0,'2012-01-28'),(5594,'g',0,'2012-01-29'),(5601,'g',0,'2012-01-29'),(5635,'g',0,'2012-01-29'),(5641,'g',0,'2012-01-29'),(5590,'g',0,'2012-01-29'),(5585,'g',0,'2012-01-29'),(5606,'g',0,'2012-01-29'),(5628,'g',0,'2012-01-29'),(5624,'g',0,'2012-01-29'),(5611,'g',0,'2012-01-29'),(5627,'g',0,'2012-01-29'),(5625,'g',0,'2012-01-29'),(5639,'g',0,'2012-01-29'),(5596,'g',0,'2012-01-29'),(5644,'g',0,'2012-01-29'),(5617,'g',0,'2012-01-29'),(5614,'g',0,'2012-01-30'),(5604,'g',0,'2012-01-30'),(5673,'g',0,'2012-01-30'),(5659,'g',0,'2012-01-30'),(5682,'g',0,'2012-01-30'),(5655,'g',0,'2012-01-30'),(5695,'g',0,'2012-01-30'),(5669,'g',0,'2012-01-30'),(5589,'g',0,'2012-01-30'),(5605,'g',0,'2012-01-31'),(5692,'g',0,'2012-01-31'),(5689,'g',0,'2012-01-31'),(5670,'g',0,'2012-01-31'),(5671,'g',0,'2012-01-31'),(5674,'g',0,'2012-02-01'),(5666,'g',0,'2012-02-01'),(5684,'g',0,'2012-02-02'),(5687,'g',0,'2012-02-02'),(5693,'g',0,'2012-02-02'),(5676,'g',0,'2012-02-02'),(5698,'g',0,'2012-02-02'),(5647,'g',0,'2012-02-02'),(5690,'g',0,'2012-02-02'),(5699,'g',0,'2012-02-02'),(5685,'g',0,'2012-02-02'),(5688,'g',0,'2012-02-02'),(5680,'g',0,'2012-02-05'),(5709,'g',0,'2012-02-05'),(5710,'g',0,'2012-02-05'),(5683,'g',0,'2012-02-06'),(5603,'g',0,'2012-02-06'),(5645,'g',0,'2012-02-07'),(5667,'g',0,'2012-02-07'),(5713,'g',0,'2012-02-07'),(5681,'g',0,'2012-02-07'),(5738,'g',0,'2012-02-07'),(5679,'g',0,'2012-02-07'),(5708,'g',0,'2012-02-07'),(5663,'g',0,'2012-02-07'),(5672,'g',0,'2012-02-07'),(5615,'g',0,'2012-02-07'),(5703,'g',0,'2012-02-07'),(5677,'g',0,'2012-02-08'),(5697,'g',0,'2012-02-08'),(5661,'g',0,'2012-02-08'),(5702,'g',0,'2012-02-08'),(5656,'g',0,'2012-02-08'),(5675,'g',0,'2012-02-08'),(5700,'g',0,'2012-02-08'),(5705,'g',0,'2012-02-08'),(5694,'g',0,'2012-02-08'),(5701,'g',0,'2012-02-08'),(5678,'g',0,'2012-02-08'),(5706,'g',0,'2012-02-08'),(5737,'g',0,'2012-02-08'),(5657,'g',0,'2012-02-09'),(5660,'g',0,'2012-02-09'),(5742,'g',0,'2012-02-09'),(5686,'g',0,'2012-02-09'),(5740,'g',0,'2012-02-09'),(5662,'g',0,'2012-02-09'),(5658,'g',0,'2012-02-09'),(5691,'g',0,'2012-02-09'),(5668,'g',0,'2012-02-09'),(5712,'g',0,'2012-02-10'),(5711,'g',0,'2012-02-12'),(5704,'g',0,'2012-02-12'),(5707,'g',0,'2012-02-12'),(5766,'g',0,'2012-02-13'),(5654,'g',0,'2012-02-14'),(5757,'g',0,'2012-02-14'),(5714,'g',0,'2012-02-14'),(5735,'g',0,'2012-02-14'),(5739,'g',0,'2012-02-15'),(5741,'g',0,'2012-02-15'),(5732,'g',0,'2012-02-15'),(5736,'g',0,'2012-02-15'),(5729,'g',0,'2012-02-15'),(5734,'g',0,'2012-02-15'),(5774,'g',0,'2012-02-15'),(5767,'g',0,'2012-02-15'),(5730,'g',0,'2012-02-15'),(5733,'g',0,'2012-02-15'),(5731,'g',0,'2012-02-15'),(5192,'g',0,'2012-02-21'),(5193,'g',0,'2012-02-21'),(4880,'g',0,'2012-02-21'),(4899,'g',0,'2012-02-21'),(4974,'g',0,'2012-02-21'),(4950,'g',0,'2012-02-21'),(5047,'g',0,'2012-02-21'),(5041,'g',0,'2012-02-21'),(5051,'g',0,'2012-02-21'),(4864,'g',0,'2012-02-21'),(4902,'g',0,'2012-02-21'),(5097,'g',0,'2012-02-21'),(5050,'g',0,'2012-02-21'),(5061,'g',0,'2012-02-21'),(5157,'g',0,'2012-02-21'),(4972,'g',0,'2012-02-21'),(5764,'g',0,'2012-02-21'),(5015,'g',0,'2012-02-21'),(4944,'g',0,'2012-02-21'),(4877,'g',0,'2012-02-21'),(4849,'g',0,'2012-02-21'),(4863,'g',0,'2012-02-21'),(4856,'g',0,'2012-02-21'),(5789,'g',0,'2012-02-22'),(5781,'g',0,'2012-02-23'),(5763,'g',0,'2012-02-25'),(5030,'g',0,'2012-02-26'),(5715,'g',0,'2012-02-26'),(5719,'g',0,'2012-02-26'),(5724,'g',0,'2012-02-26'),(5723,'g',0,'2012-02-26'),(5727,'g',0,'2012-02-26'),(5728,'g',0,'2012-02-26'),(5725,'g',0,'2012-02-26'),(5720,'g',0,'2012-02-26'),(5721,'g',0,'2012-02-26'),(5722,'g',0,'2012-02-26'),(5726,'g',0,'2012-02-26'),(5762,'g',0,'2012-02-26'),(5745,'g',0,'2012-02-26'),(5747,'g',0,'2012-02-26'),(4568,'g',0,'2012-02-26'),(4840,'g',0,'2012-02-26'),(4800,'g',0,'2012-02-26'),(5059,'g',0,'2012-02-26'),(4814,'g',0,'2012-02-26'),(4868,'g',0,'2012-02-26'),(5023,'g',0,'2012-02-26'),(4940,'g',0,'2012-02-26'),(4869,'g',0,'2012-02-26'),(4317,'g',0,'2012-02-26'),(4349,'g',0,'2012-02-26'),(4357,'g',0,'2012-02-26'),(4346,'g',0,'2012-02-26'),(4390,'g',0,'2012-02-26'),(4352,'g',0,'2012-02-26'),(4353,'g',0,'2012-02-26'),(4393,'g',0,'2012-02-26'),(4401,'g',0,'2012-02-26'),(4395,'g',0,'2012-02-26'),(4555,'g',0,'2012-02-27'),(5405,'g',0,'2012-02-27'),(4498,'g',0,'2012-02-27'),(4456,'g',0,'2012-02-27'),(5752,'g',0,'2012-02-27'),(4565,'g',0,'2012-02-27'),(4504,'g',0,'2012-02-27'),(4337,'g',0,'2012-02-27'),(5791,'g',0,'2012-02-27'),(5403,'g',0,'2012-02-27'),(4490,'g',0,'2012-02-27'),(5775,'g',0,'2012-02-27'),(5696,'g',0,'2012-02-27'),(5716,'g',0,'2012-02-27'),(5750,'g',0,'2012-02-27'),(5754,'g',0,'2012-02-27'),(5748,'g',0,'2012-02-27'),(4414,'g',0,'2012-02-27'),(4429,'g',0,'2012-02-27'),(4476,'g',0,'2012-02-27'),(4419,'g',0,'2012-02-27'),(4439,'g',0,'2012-02-27'),(5718,'g',0,'2012-02-27'),(5653,'g',0,'2012-02-27'),(5420,'g',0,'2012-02-27'),(4459,'g',0,'2012-02-27'),(4450,'g',0,'2012-02-27'),(5755,'g',0,'2012-02-27'),(5717,'g',0,'2012-02-27'),(4492,'g',0,'2012-02-27'),(4440,'g',0,'2012-02-27'),(4480,'g',0,'2012-02-28'),(5646,'g',0,'2012-02-28'),(5751,'g',0,'2012-02-28'),(5744,'g',0,'2012-02-28'),(5665,'g',0,'2012-02-28'),(4402,'g',0,'2012-02-28'),(5759,'g',0,'2012-02-28'),(5319,'g',0,'2012-02-28'),(4327,'g',0,'2012-02-28'),(4436,'g',0,'2012-02-28'),(5815,'g',0,'2012-02-28'),(4383,'g',0,'2012-02-28'),(5753,'g',0,'2012-02-28'),(5286,'g',0,'2012-02-28'),(4312,'g',0,'2012-02-28'),(4361,'g',0,'2012-02-28'),(5320,'g',0,'2012-02-28'),(5790,'g',0,'2012-02-28'),(4320,'g',0,'2012-02-28'),(5327,'g',0,'2012-02-28'),(4324,'g',0,'2012-02-28'),(4407,'g',0,'2012-02-28'),(5805,'g',0,'2012-02-29'),(5291,'g',0,'2012-02-29'),(4793,'g',0,'2012-02-29'),(4792,'g',0,'2012-02-29'),(4758,'g',0,'2012-02-29'),(4804,'g',0,'2012-02-29'),(4824,'g',0,'2012-02-29'),(4796,'g',0,'2012-02-29'),(4748,'g',0,'2012-02-29'),(4745,'g',0,'2012-02-29'),(4802,'g',0,'2012-02-29'),(5415,'g',0,'2012-02-29'),(5743,'g',0,'2012-02-29'),(4381,'g',0,'2012-02-29'),(4404,'g',0,'2012-02-29'),(4386,'g',0,'2012-02-29'),(4385,'g',0,'2012-02-29'),(4384,'g',0,'2012-02-29'),(4382,'g',0,'2012-02-29'),(4411,'g',0,'2012-02-29'),(4396,'g',0,'2012-02-29'),(4399,'g',0,'2012-02-29'),(4380,'g',0,'2012-02-29'),(4292,'g',0,'2012-03-01'),(4289,'g',0,'2012-03-01'),(4253,'g',0,'2012-03-01'),(4252,'g',0,'2012-03-01'),(4249,'g',0,'2012-03-01'),(4247,'g',0,'2012-03-01'),(4290,'g',0,'2012-03-01'),(4273,'g',0,'2012-03-01'),(4481,'g',0,'2012-03-01'),(4449,'g',0,'2012-03-01'),(4469,'g',0,'2012-03-01'),(4445,'g',0,'2012-03-01'),(4484,'g',0,'2012-03-01'),(4446,'g',0,'2012-03-01'),(4463,'g',0,'2012-03-01'),(4421,'g',0,'2012-03-01'),(4442,'g',0,'2012-03-01'),(4444,'g',0,'2012-03-01'),(5808,'g',0,'2012-03-02'),(5811,'g',0,'2012-03-02'),(5785,'g',0,'2012-03-02'),(4841,'g',0,'2012-03-03'),(5830,'g',0,'2012-03-05'),(5840,'g',0,'2012-03-06'),(5844,'g',0,'2012-03-06'),(5821,'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_pl_sociable`
--

CREATE TABLE `idx_pl_sociable` (
  `sb_id` int(11) NOT NULL AUTO_INCREMENT,
  `sb_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `sb_url` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `sb_icon` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `sb_enable` char(1) CHARACTER SET utf8 DEFAULT '0',
  PRIMARY KEY (`sb_id`)
) ENGINE=MyISAM AUTO_INCREMENT=90 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_pl_sociable`
--

INSERT INTO `idx_pl_sociable` VALUES (1,'BarraPunto','http://barrapunto.com/submit.pl?subj=TITLE&amp;story=PERMALINK','barrapunto.png','0'),(2,'Bitacoras.com','http://bitacoras.com/anotaciones/PERMALINK','bitacoras.png','0'),(3,'BlinkList','http://www.blinklist.com/index.php?Action=Blink/addblink.php&amp;Url=PERMALINK&amp;Title=TITLE','blinklist.png','0'),(4,'blogmarks','http://blogmarks.net/my/new.php?mini=1&amp;simple=1&amp;url=PERMALINK&amp;title=TITLE','blogmarks.png','0'),(5,'Blogosphere News','http://www.blogospherenews.com/submit.php?url=PERMALINK&amp;title=TITLE','blogospherenews.png','0'),(6,'blogtercimlap','http://cimlap.blogter.hu/index.php?action=suggest_link&amp;title=TITLE&amp;url=PERMALINK','blogter.png','0'),(7,'Faves','http://faves.com/Authoring.aspx?u=PERMALINK&amp;title=TITLE','bluedot.png','0'),(8,'connotea','http://www.connotea.org/addpopup?continue=confirm&amp;uri=PERMALINK&amp;title=TITLE&amp;description=EXCERPT','connotea.png','0'),(9,'Current','http://current.com/clipper.htm?url=PERMALINK&amp;title=TITLE','current.png','0'),(10,'del.icio.us','http://delicious.com/post?url=PERMALINK&amp;title=TITLE&amp;notes=EXCERPT','delicious.png','0'),(11,'Digg','http://digg.com/submit?phase=2&amp;url=PERMALINK&amp;title=TITLE&amp;bodytext=EXCERPT','digg.png','1'),(12,'Diigo','http://www.diigo.com/post?url=PERMALINK&amp;title=TITLE','diigo.png','0'),(13,'DotNetKicks','http://www.dotnetkicks.com/kick/?url=PERMALINK&amp;title=TITLE','dotnetkicks.png','0'),(14,'DZone','http://www.dzone.com/links/add.html?url=PERMALINK&amp;title=TITLE','dzone.png','0'),(15,'eKudos','http://www.ekudos.nl/artikel/nieuw?url=PERMALINK&amp;title=TITLE&amp;desc=EXCERPT','ekudos.png','0'),(16,'email','mailto:?subject=TITLE&amp;body=PERMALINK','email_link.png','0'),(17,'Facebook','http://www.facebook.com/share.php?u=PERMALINK&amp;t=TITLE','facebook.png','1'),(18,'Fark','http://cgi.fark.com/cgi/fark/farkit.pl?h=TITLE&amp;u=PERMALINK','fark.png','0'),(19,'Fleck','http://beta3.fleck.com/bookmarklet.php?url=PERMALINK&amp;title=TITLE','fleck.png','0'),(20,'FriendFeed','http://www.friendfeed.com/share?title=TITLE&amp;link=PERMALINK','friendfeed.png','0'),(21,'FSDaily','http://www.fsdaily.com/submit?url=PERMALINK&amp;title=TITLE','fsdaily.png','0'),(22,'Global Grind','http://globalgrind.com/submission/submit.aspx?url=PERMALINK&amp;type=Article&amp;title=TITLE','globalgrind.png','0'),(23,'Google','http://www.google.com/bookmarks/mark?op=edit&amp;bkmk=PERMALINK&amp;title=TITLE&amp;annotation=EXCERPT','googlebookmark.png','0'),(24,'Gwar','http://www.gwar.pl/DodajGwar.html?u=PERMALINK','gwar.png','0'),(25,'HackerNews','http://news.ycombinator.com/submitlink?u=PERMALINK&amp;t=TITLE','hackernews.png','0'),(26,'Haohao','http://www.haohaoreport.com/submit.php?url=PERMALINK&amp;title=TITLE','haohao.png','0'),(27,'HealthRanker','http://healthranker.com/submit.php?url=PERMALINK&amp;title=TITLE','healthranker.png','0'),(28,'HelloTxt','http://hellotxt.com/?status=TITLE+PERMALINK','hellotxt.png','0'),(29,'Hemidemi','http://www.hemidemi.com/user_bookmark/new?title=TITLE&amp;url=PERMALINK','hemidemi.png','0'),(30,'Hyves','http://www.hyves.nl/profilemanage/add/tips/?name=TITLE&amp;text=EXCERPT+PERMALINK&amp;rating=5','hyves.png','0'),(31,'Identi.ca','http://identi.ca/notice/new?status_textarea=PERMALINK','identica.png','0'),(32,'IndianPad','http://www.indianpad.com/submit.php?url=PERMALINK','indianpad.png','0'),(33,'Internetmedia','http://internetmedia.hu/submit.php?url=PERMALINK','im.png','0'),(34,'Kirtsy','http://www.kirtsy.com/submit.php?url=PERMALINK&amp;title=TITLE','kirtsy.png','0'),(35,'laaik.it','http://laaik.it/NewStoryCompact.aspx?uri=PERMALINK&amp;headline=TITLE&amp;cat=5e082fcc-8a3b-47e2-acec-fdf64ff19d12','laaikit.png','0'),(36,'LinkArena','http://linkarena.com/bookmarks/addlink/?url=PERMALINK&amp;title=TITLE','linkarena.png','0'),(37,'LinkaGoGo','http://www.linkagogo.com/go/AddNoPopup?url=PERMALINK&amp;title=TITLE','linkagogo.png','0'),(38,'LinkedIn','http://www.linkedin.com/shareArticle?mini=true&amp;url=PERMALINK&amp;title=TITLE&amp;source=BLOGNAME&amp;summary=EXCERPT','linkedin.png','0'),(39,'Linkter','http://www.linkter.hu/index.php?action=suggest_link&amp;url=PERMALINK&amp;title=TITLE','linkter.png','0'),(40,'Live','https://favorites.live.com/quickadd.aspx?marklet=1&amp;url=PERMALINK&amp;title=TITLE','live.png','0'),(41,'Meneame','http://meneame.net/submit.php?url=PERMALINK','meneame.png','0'),(42,'MisterWong','http://www.mister-wong.com/addurl/?bm_url=PERMALINK&amp;bm_description=TITLE&amp;plugin=soc','misterwong.png','0'),(43,'MisterWong.DE','http://www.mister-wong.de/addurl/?bm_url=PERMALINK&amp;bm_description=TITLE&amp;plugin=soc','misterwong.png','0'),(44,'Mixx','http://www.mixx.com/submit?page_url=PERMALINK&amp;title=TITLE','mixx.png','0'),(45,'muti','http://www.muti.co.za/submit?url=PERMALINK&amp;title=TITLE','muti.png','0'),(46,'MyShare','http://myshare.url.com.tw/index.php?func=newurl&amp;url=PERMALINK&amp;desc=TITLE','myshare.png','0'),(47,'MySpace','http://www.myspace.com/Modules/PostTo/Pages/?u=PERMALINK&amp;t=TITLE','myspace.png','0'),(48,'MSNReporter','http://reporter.nl.msn.com/?fn=contribute&amp;Title=TITLE&amp;URL=PERMALINK&amp;cat_id=6&amp;tag_id=31&amp;Remark=EXCERPT','msnreporter.png','0'),(49,'N4G','http://www.n4g.com/tips.aspx?url=PERMALINK&amp;title=TITLE','n4g.png','0'),(50,'Netvibes','http://www.netvibes.com/share?title=TITLE&amp;url=PERMALINK','netvibes.png','0'),(51,'NewsVine','http://www.newsvine.com/_tools/seed&amp;save?u=PERMALINK&amp;h=TITLE','newsvine.png','0'),(52,'Netvouz','http://www.netvouz.com/action/submitBookmark?url=PERMALINK&amp;title=TITLE&amp;popup=no','netvouz.png','0'),(53,'NuJIJ','http://nujij.nl/jij.lynkx?t=TITLE&amp;u=PERMALINK&amp;b=EXCERPT','nujij.png','0'),(54,'Ping.fm','http://ping.fm/ref/?link=PERMALINK&amp;title=TITLE&amp;body=EXCERPT','ping.png','0'),(55,'Posterous','http://posterous.com/share?linkto=PERMALINK&amp;title=TITLE&amp;selection=EXCERPT','posterous.png','0'),(56,'PDF','http://www.printfriendly.com/print?url=PERMALINK&amp;partner=sociable','pdf.png','0'),(57,'Print','http://www.printfriendly.com/print?url=PERMALINK&amp;partner=sociable','printfriendly.png','0'),(58,'Propeller','http://www.propeller.com/submit/?url=PERMALINK','propeller.png','0'),(59,'Ratimarks','http://ratimarks.org/bookmarks.php/?action=add&address=PERMALINK&amp;title=TITLE','ratimarks.png','0'),(60,'Rec6','http://rec6.via6.com/link.php?url=PERMALINK&amp;=TITLE','rec6.png','0'),(61,'Reddit','http://reddit.com/submit?url=PERMALINK&amp;title=TITLE','reddit.png','0'),(62,'RSS','FEEDLINK','rss.png','0'),(63,'Scoopeo','http://www.scoopeo.com/scoop/new?newurl=PERMALINK&amp;title=TITLE','scoopeo.png','0'),(64,'Segnalo','http://segnalo.alice.it/post.html.php?url=PERMALINK&amp;title=TITLE','segnalo.png','0'),(65,'Simpy','http://www.simpy.com/simpy/LinkAdd.do?href=PERMALINK&amp;title=TITLE','simpy.png','0'),(66,'Slashdot','http://slashdot.org/bookmark.pl?title=TITLE&amp;url=PERMALINK','slashdot.png','0'),(67,'Socialogs','http://socialogs.com/add_story.php?story_url=PERMALINK&amp;story_title=TITLE','socialogs.png','0'),(68,'SphereIt','http://www.sphere.com/search?q=sphereit:PERMALINK&amp;title=TITLE','sphere.png','0'),(69,'Sphinn','http://sphinn.com/index.php?c=post&amp;m=submit&amp;link=PERMALINK','sphinn.png','0'),(70,'StumbleUpon','http://www.stumbleupon.com/submit?url=PERMALINK&amp;title=TITLE','stumbleupon.png','0'),(71,'Techmeme','http://twitter.com/home/?status=tip%20@Techmeme%20PERMALINK%20TITLE','techmeme.png','0'),(72,'Technorati','http://technorati.com/faves?add=PERMALINK','technorati.png','1'),(73,'ThisNext','http://www.thisnext.com/pick/new/submit/sociable/?url=PERMALINK&amp;name=TITLE','thisnext.png','0'),(74,'Tipd','http://tipd.com/submit.php?url=PERMALINK','tipd.png','0'),(75,'Tumblr','http://www.tumblr.com/share?v=3&amp;u=PERMALINK&amp;t=TITLE&amp;s=EXCERPT','tumblr.png','0'),(76,'Twitter','http://twitter.com/home?status=TITLE%20-%20PERMALINK','twitter.png','1'),(77,'Upnews','http://www.upnews.it/submit?url=PERMALINK&amp;title=TITLE','upnews.png','0'),(78,'Webnews.de','http://www.webnews.de/einstellen?url=PERMALINK&amp;title=TITLE','webnews.png','0'),(79,'Webride','http://webride.org/discuss/split.php?uri=PERMALINK&amp;title=TITLE','webride.png','0'),(80,'Wikio','http://www.wikio.com/vote?url=PERMALINK','wikio.png','0'),(81,'Wikio FR','http://www.wikio.fr/vote?url=PERMALINK','wikio.png','0'),(82,'Wikio IT','http://www.wikio.it/vote?url=PERMALINK','wikio.png','0'),(83,'Wists','http://wists.com/s.php?c=&amp;r=PERMALINK&amp;title=TITLE','wists.png','0'),(84,'Wykop','http://www.wykop.pl/dodaj?url=PERMALINK','wykop.png','0'),(85,'Xerpi','http://www.xerpi.com/block/add_link_from_extension?url=PERMALINK&amp;title=TITLE','xerpi.png','0'),(86,'YahooBuzz','http://buzz.yahoo.com/submit/?submitUrl=PERMALINK&amp;submitHeadline=TITLE&amp;submitSummary=EXCERPT&amp;submitCategory=science&amp;submitAssetType=text','yahoobuzz.png','0'),(87,'Yahoo! Bookmarks','http://bookmarks.yahoo.com/toolbar/savebm?u=PERMALINK&amp;t=TITLE&opener=bm&amp;ei=UTF-8&amp;d=EXCERPT','yahoomyweb.png','0'),(88,'Yigg','http://yigg.de/neu?exturl=PERMALINK&amp;exttitle=TITLE','yiggit.png','0'),(89,'Blogplay','http://blogplay.com','blogplay.png','0');

--
-- Table structure for table `idx_pl_twitter_account`
--

CREATE TABLE `idx_pl_twitter_account` (
  `ck` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `cs` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `at` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `ats` varchar(255) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_pl_twitter_account`
--

INSERT INTO `idx_pl_twitter_account` VALUES ('NSN7AvmIIiOA16FwgU91Q','AADufUavLMmhjqSMZ0tTAhdS13DUN9DdwRVnFDbhk','356947649-xz1JIvNWHKgt35lKxkCSfRMQx0gIBRS42JtnZE5y','UWMDCUcmIOPDbhZm4A6yfCmI2hutdJt8i5ibh9FJoc');

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

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

INSERT INTO `idx_plugin` VALUES (1,'Sociable','sociable/sociable.php','1',NULL),(2,'AutoTweet','twitter_auto_tweet/twitter_auto_tweet.php','1',NULL);

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



