--
-- Host: hoba.us    Database: hoba_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=37 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_category` VALUES (1,0,'Arts and Entertainment','','folder.gif','','1',2,'','','0','0','','',0,'',2,0,0,0,0),(2,0,'Arts','','folder.gif','','1',13,'','','0','0','','',0,'',0,0,0,0,0),(3,0,'Automotive Services','','folder.gif','','1',43,'','','0','0','','',0,'',0,0,0,0,0),(4,0,'Business Services','','folder.gif','','1',152,'','','0','0','','',0,'',0,0,0,0,0),(5,0,'Jobs & Careers','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(6,0,'Clothing & Style','','folder.gif','','1',12,'','','0','0','','',0,'',1,0,0,0,0),(7,0,'Communication & Technology','','folder.gif','','1',24,'','','0','0','','',0,'',0,0,0,0,0),(8,0,'Internet & computer Services','','folder.gif','','1',19,'','','0','0','','',0,'',0,0,0,0,0),(9,0,'Construction and Contractors','','folder.gif','','1',75,'','','0','0','','',0,'',0,0,0,0,0),(10,0,'Dental Care','','folder.gif','','1',54,'','','0','0','','',0,'',0,0,0,0,0),(11,0,'Education & Research','','folder.gif','','1',27,'','','0','0','','',0,'',0,0,0,0,0),(12,0,'Employment Services','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(13,0,'Gift Baskets','','folder.gif','','1',25,'','','0','0','','',0,'',1,0,0,0,0),(14,0,'Hardware & Software Services','','folder.gif','','1',9,'','','0','0','','',0,'',0,0,0,0,0),(15,0,'Health & Medical','','folder.gif','','1',3,'','','0','0','','',0,'',0,0,0,0,0),(16,0,'Healthcare Related','','folder.gif','','1',164,'','','0','0','','',0,'',0,0,0,0,0),(17,0,'Air Conditioning & Heating','','folder.gif','','1',71,'','','0','0','','',0,'',6,0,0,0,0),(18,0,'Home Decor & Garden','','folder.gif','','1',208,'','','0','0','','',0,'',0,0,0,0,0),(19,0,'Home Improvement & Decor','','folder.gif','','1',118,'','','0','0','','',0,'',0,0,0,0,0),(20,0,'Hotels & Accomadation','','folder.gif','','1',61,'','','0','0','','',0,'',0,0,0,0,0),(21,0,'Insurance Companies','','folder.gif','','1',34,'','','0','0','','',0,'',0,0,0,0,0),(22,0,'Law','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(23,0,'Lawyers & Judges','','folder.gif','','1',181,'','','0','0','','',0,'',1,0,0,0,0),(24,0,'Dating & Relationships','','folder.gif','','1',6,'','','0','0','','',0,'',0,0,0,0,0),(25,0,'Medicine & Hospitals','','folder.gif','','1',13,'','','0','0','','',0,'',0,0,0,0,0),(26,0,'Finance & Investment Services','','folder.gif','','1',20,'','','0','0','','',0,'',0,0,0,0,0),(27,0,'News & Magazines','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(28,0,'Plumbing Services','','folder.gif','','1',43,'','','0','0','','',0,'',0,0,0,0,0),(29,0,'Real Estate Development','','folder.gif','','1',41,'','','0','0','','',0,'',0,0,0,0,0),(30,0,'Energy & Science','','folder.gif','','1',12,'','','0','0','','',0,'',0,0,0,0,0),(31,0,'SEO ,SMO & PPC','','folder.gif','','1',21,'','','0','0','','',0,'',0,0,0,0,0),(32,0,'Shopping and Retail','','folder.gif','','1',62,'','','0','0','','',0,'',0,0,0,0,0),(33,0,'Recreation & Sports','','folder.gif','','1',4,'','','0','0','','',0,'',0,0,0,0,0),(34,0,'Transport & Moving Services','','folder.gif','','1',39,'','','0','0','','',0,'',0,0,0,0,0),(35,0,'Travel Industry','','folder.gif','','1',23,'','','0','0','','',0,'',1,0,0,0,0),(36,0,'Wedding & Events','','folder.gif','','1',8,'','','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 and Entertainment','<a href=\"http://hoba.us/arts-and-entertainment/\" name=\"cat_1\" style=\"\">Arts and Entertainment</a>',';0;'),(2,'Arts','<a href=\"http://hoba.us/arts/\" name=\"cat_2\" style=\"\">Arts</a>',';0;'),(3,'Automotive Services','<a href=\"http://hoba.us/automotive-services/\" name=\"cat_3\" style=\"\">Automotive Services</a>',';0;'),(4,'Business Services','<a href=\"http://hoba.us/business-services/\" name=\"cat_4\" style=\"\">Business Services</a>',';0;'),(5,'Jobs & Careers','<a href=\"http://hoba.us/jobs-careers/\" name=\"cat_5\" style=\"\">Jobs & Careers</a>',';0;'),(6,'Clothing & Style','<a href=\"http://hoba.us/clothing-style/\" name=\"cat_6\" style=\"\">Clothing & Style</a>',';0;'),(7,'Communication & Technology','<a href=\"http://hoba.us/communication-technology/\" name=\"cat_7\" style=\"\">Communication & Technology</a>',';0;'),(8,'Internet & computer Services','<a href=\"http://hoba.us/internet-computer-services/\" name=\"cat_8\" style=\"\">Internet & computer Services</a>',';0;'),(9,'Construction and Contractors','<a href=\"http://hoba.us/construction-and-contractors/\" name=\"cat_9\" style=\"\">Construction and Contractors</a>',';0;'),(10,'Dental Care','<a href=\"http://hoba.us/dental-care/\" name=\"cat_10\" style=\"\">Dental Care</a>',';0;'),(11,'Education & Research','<a href=\"http://hoba.us/education-research/\" name=\"cat_11\" style=\"\">Education & Research</a>',';0;'),(12,'Employment Services','<a href=\"http://hoba.us/employment-services/\" name=\"cat_12\" style=\"\">Employment Services</a>',';0;'),(13,'Gift Baskets','<a href=\"http://hoba.us/gift-baskets/\" name=\"cat_13\" style=\"\">Gift Baskets</a>',';0;'),(14,'Hardware & Software Services','<a href=\"http://hoba.us/hardware-software-services/\" name=\"cat_14\" style=\"\">Hardware & Software Services</a>',';0;'),(15,'Health & Medical','<a href=\"http://hoba.us/health-medical/\" name=\"cat_15\" style=\"\">Health & Medical</a>',';0;'),(16,'Healthcare Related','<a href=\"http://hoba.us/healthcare-related/\" name=\"cat_16\" style=\"\">Healthcare Related</a>',';0;'),(17,'Air Conditioning & Heating','<a href=\"http://hoba.us/air-conditioning-heating/\" name=\"cat_17\" style=\"\">Air Conditioning & Heating</a>',';0;'),(18,'Home Decor & Garden','<a href=\"http://hoba.us/home-decor-garden/\" name=\"cat_18\" style=\"\">Home Decor & Garden</a>',';0;'),(19,'Home Improvement & Decor','<a href=\"http://hoba.us/home-improvement-decor/\" name=\"cat_19\" style=\"\">Home Improvement & Decor</a>',';0;'),(20,'Hotels & Accomadation','<a href=\"http://hoba.us/hotels-accomadation/\" name=\"cat_20\" style=\"\">Hotels & Accomadation</a>',';0;'),(21,'Insurance Companies','<a href=\"http://hoba.us/insurance-companies/\" name=\"cat_21\" style=\"\">Insurance Companies</a>',';0;'),(22,'Law','<a href=\"http://hoba.us/law/\" name=\"cat_22\" style=\"\">Law</a>',';0;'),(23,'Lawyers & Judges','<a href=\"http://hoba.us/lawyers-judges/\" name=\"cat_23\" style=\"\">Lawyers & Judges</a>',';0;'),(24,'Dating & Relationships','<a href=\"http://hoba.us/dating-relationships/\" name=\"cat_24\" style=\"\">Dating & Relationships</a>',';0;'),(25,'Medicine & Hospitals','<a href=\"http://hoba.us/medicine-hospitals/\" name=\"cat_25\" style=\"\">Medicine & Hospitals</a>',';0;'),(26,'Finance & Investment Services','<a href=\"http://hoba.us/finance-investment-services/\" name=\"cat_26\" style=\"\">Finance & Investment Services</a>',';0;'),(27,'News & Magazines','<a href=\"http://hoba.us/news-magazines/\" name=\"cat_27\" style=\"\">News & Magazines</a>',';0;'),(28,'Plumbing Services','<a href=\"http://hoba.us/plumbing-services/\" name=\"cat_28\" style=\"\">Plumbing Services</a>',';0;'),(29,'Real Estate Development','<a href=\"http://hoba.us/real-estate-development/\" name=\"cat_29\" style=\"\">Real Estate Development</a>',';0;'),(30,'Energy & Science','<a href=\"http://hoba.us/energy-science/\" name=\"cat_30\" style=\"\">Energy & Science</a>',';0;'),(31,'SEO ,SMO & PPC','<a href=\"http://hoba.us/seo-smo-ppc/\" name=\"cat_31\" style=\"\">SEO ,SMO & PPC</a>',';0;'),(32,'Shopping and Retail','<a href=\"http://hoba.us/shopping-and-retail/\" name=\"cat_32\" style=\"\">Shopping and Retail</a>',';0;'),(33,'Recreation & Sports','<a href=\"http://hoba.us/recreation-sports/\" name=\"cat_33\" style=\"\">Recreation & Sports</a>',';0;'),(34,'Transport & Moving Services','<a href=\"http://hoba.us/transport-moving-services/\" name=\"cat_34\" style=\"\">Transport & Moving Services</a>',';0;'),(35,'Travel Industry','<a href=\"http://hoba.us/travel-industry/\" name=\"cat_35\" style=\"\">Travel Industry</a>',';0;'),(36,'Wedding & Events','<a href=\"http://hoba.us/wedding-events/\" name=\"cat_36\" style=\"\">Wedding & Events</a>',';0;');

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

CREATE TABLE `idx_category_suggession` (
  `id_cat_suggession` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `category_description` text,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id_cat_suggession`)
) ENGINE=MyISAM 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=3 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_favorites` VALUES (1,'dewayneelviso15s36','2011-10-19','My Favorites',NULL),(2,'duncanbrandov23h79','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 (1,'g',4,'2011-09-12'),(4,'g',3,'2011-09-16'),(8,'g',2,'2011-09-24'),(2,'g',6,'2011-09-24'),(6,'g',2,'2011-09-24'),(3,'g',3,'2011-09-24'),(7,'g',2,'2011-09-24'),(5,'g',3,'2011-09-25'),(10,'g',2,'2011-09-25'),(9,'g',0,'2011-09-25'),(30,'g',0,'2012-02-13'),(38,'g',0,'2012-01-05'),(58,'g',6,'2011-10-04'),(60,'g',0,'2012-02-12'),(59,'g',0,'2011-10-05'),(240,'g',0,'2012-01-23'),(309,'g',0,'2011-10-10'),(310,'g',0,'2012-01-19'),(315,'g',0,'2012-01-25'),(180,'g',0,'2012-01-25'),(441,'g',0,'2012-01-24'),(21,'g',0,'2011-10-15'),(29,'g',0,'2011-10-15'),(28,'g',0,'2011-10-15'),(22,'g',0,'2011-10-15'),(23,'g',0,'2011-10-15'),(25,'g',0,'2011-10-15'),(24,'g',0,'2011-10-15'),(26,'g',0,'2011-10-15'),(27,'g',0,'2011-10-15'),(57,'g',0,'2011-10-15'),(443,'g',0,'2011-10-20'),(452,'g',0,'2012-01-07'),(408,'g',0,'2012-01-07'),(66,'g',0,'2011-10-25'),(98,'g',0,'2011-10-25'),(126,'g',0,'2011-10-25'),(209,'g',0,'2011-10-25'),(113,'g',0,'2011-10-25'),(133,'g',0,'2011-10-25'),(355,'g',0,'2011-10-25'),(353,'g',0,'2012-02-09'),(130,'g',0,'2011-10-25'),(86,'g',0,'2011-10-25'),(72,'g',0,'2011-10-25'),(94,'g',0,'2011-10-25'),(435,'g',0,'2011-10-25'),(442,'g',0,'2011-10-25'),(134,'g',0,'2011-10-25'),(101,'g',0,'2011-10-25'),(139,'g',0,'2011-10-25'),(119,'g',0,'2011-10-25'),(41,'g',0,'2012-01-20'),(45,'g',0,'2012-01-20'),(39,'g',0,'2012-02-25'),(48,'g',0,'2012-02-16'),(43,'g',0,'2012-01-20'),(40,'g',0,'2012-01-20'),(46,'g',0,'2012-01-20'),(470,'g',0,'2011-12-26'),(444,'g',0,'2011-12-26'),(389,'g',0,'2011-12-26'),(382,'g',0,'2011-12-26'),(88,'g',0,'2012-02-06'),(55,'g',0,'2012-02-06'),(362,'g',0,'2012-02-06'),(367,'g',0,'2012-02-06'),(84,'g',0,'2012-02-12'),(76,'g',0,'2012-02-12'),(90,'g',0,'2012-02-13'),(79,'g',0,'2012-02-12'),(77,'g',0,'2012-02-12'),(96,'g',0,'2012-02-12'),(100,'g',0,'2012-02-13'),(35,'g',0,'2012-01-05'),(63,'g',0,'2012-01-05'),(127,'g',0,'2012-01-05'),(193,'g',0,'2012-02-19'),(105,'g',0,'2012-01-05'),(190,'g',0,'2012-01-05'),(135,'g',0,'2012-01-05'),(188,'g',0,'2012-01-05'),(102,'g',0,'2012-01-05'),(476,'g',0,'2011-10-26'),(214,'g',0,'2011-10-26'),(366,'g',0,'2011-10-26'),(354,'g',0,'2011-10-26'),(401,'g',0,'2011-10-26'),(387,'g',0,'2011-10-26'),(364,'g',0,'2011-10-26'),(356,'g',0,'2011-10-26'),(78,'g',0,'2011-12-02'),(469,'g',0,'2011-12-02'),(462,'g',0,'2011-12-02'),(391,'g',0,'2011-12-02'),(457,'g',0,'2012-01-09'),(465,'g',0,'2012-01-09'),(371,'g',0,'2012-01-09'),(471,'g',0,'2012-01-09'),(200,'g',0,'2011-10-26'),(83,'g',0,'2011-10-26'),(36,'g',0,'2011-10-26'),(70,'g',0,'2012-03-01'),(71,'g',0,'2011-10-26'),(64,'g',0,'2011-10-26'),(65,'g',0,'2011-10-26'),(85,'g',0,'2011-10-26'),(80,'g',0,'2011-10-26'),(61,'g',0,'2011-10-26'),(87,'g',0,'2011-10-26'),(369,'g',0,'2011-10-26'),(108,'g',0,'2011-10-26'),(412,'g',0,'2011-10-26'),(396,'g',0,'2011-10-26'),(67,'g',0,'2011-10-26'),(406,'g',0,'2011-10-26'),(348,'g',0,'2011-10-26'),(92,'g',0,'2012-01-24'),(56,'g',0,'2012-01-24'),(69,'g',0,'2012-03-03'),(73,'g',0,'2012-01-24'),(74,'g',0,'2012-01-24'),(122,'g',0,'2012-02-16'),(138,'g',0,'2012-01-24'),(120,'g',0,'2012-02-16'),(123,'g',0,'2012-01-24'),(103,'g',0,'2012-02-16'),(380,'g',0,'2012-01-09'),(453,'g',0,'2012-01-09'),(445,'g',0,'2012-01-09'),(393,'g',0,'2012-01-09'),(385,'g',0,'2012-01-01'),(437,'g',0,'2011-10-27'),(434,'g',0,'2011-10-27'),(216,'g',0,'2011-10-27'),(151,'g',0,'2011-10-27'),(347,'g',0,'2011-10-27'),(345,'g',0,'2011-10-27'),(378,'g',0,'2011-10-27'),(153,'g',0,'2012-02-10'),(394,'g',0,'2011-10-27'),(104,'g',0,'2011-10-27'),(373,'g',0,'2011-10-27'),(109,'g',0,'2011-10-27'),(121,'g',0,'2012-03-01'),(374,'g',0,'2011-10-27'),(472,'g',0,'2011-10-27'),(89,'g',0,'2011-10-27'),(410,'g',0,'2012-02-23'),(343,'g',0,'2011-10-27'),(480,'g',0,'2011-10-27'),(44,'g',0,'2012-02-19'),(110,'g',0,'2012-03-04'),(478,'g',0,'2011-10-27'),(97,'g',0,'2011-12-26'),(54,'g',0,'2011-12-02'),(106,'g',0,'2012-02-12'),(363,'g',0,'2012-02-18'),(211,'g',0,'2012-02-18'),(370,'g',0,'2012-02-18'),(47,'g',0,'2012-01-20'),(82,'g',0,'2012-02-12'),(202,'g',0,'2011-10-27'),(204,'g',0,'2012-02-18'),(205,'g',0,'2012-02-18'),(68,'g',0,'2012-02-13'),(164,'g',0,'2011-10-27'),(42,'g',0,'2012-01-20'),(162,'g',0,'2012-02-18'),(461,'g',0,'2011-12-26'),(424,'g',0,'2012-02-18'),(430,'g',0,'2012-02-18'),(439,'g',0,'2011-10-27'),(447,'g',0,'2011-12-15'),(433,'g',0,'2011-10-27'),(398,'g',0,'2012-01-06'),(379,'g',0,'2012-02-12'),(407,'g',0,'2012-02-13'),(132,'g',0,'2012-02-13'),(375,'g',0,'2012-01-03'),(386,'g',0,'2012-01-03'),(163,'g',0,'2012-01-03'),(350,'g',0,'2012-01-03'),(390,'g',0,'2012-01-03'),(351,'g',0,'2012-02-09'),(388,'g',0,'2012-01-03'),(357,'g',0,'2011-10-27'),(32,'g',0,'2012-02-05'),(81,'g',0,'2012-02-05'),(33,'g',0,'2012-02-05'),(99,'g',0,'2012-02-05'),(125,'g',0,'2012-02-05'),(128,'g',0,'2012-02-05'),(124,'g',0,'2012-02-05'),(131,'g',0,'2012-02-05'),(107,'g',0,'2012-02-05'),(115,'g',0,'2012-02-05'),(93,'g',0,'2012-02-12'),(34,'g',0,'2012-02-13'),(75,'g',0,'2012-02-12'),(37,'g',0,'2012-02-12'),(137,'g',0,'2012-02-13'),(451,'g',0,'2012-02-13'),(31,'g',0,'2011-10-28'),(473,'g',0,'2011-10-28'),(213,'g',0,'2011-10-28'),(409,'g',0,'2011-10-28'),(450,'g',0,'2011-10-28'),(428,'g',0,'2011-10-28'),(206,'g',0,'2011-10-28'),(458,'g',0,'2011-10-28'),(397,'g',0,'2011-10-28'),(349,'g',0,'2012-02-20'),(485,'g',0,'2011-11-07'),(960,'g',0,'2011-11-25'),(718,'g',0,'2011-11-25'),(1075,'g',0,'2011-11-25'),(703,'g',0,'2011-11-25'),(1865,'g',0,'2011-11-25'),(1597,'g',0,'2011-11-25'),(504,'g',0,'2011-11-25'),(545,'g',0,'2011-11-25'),(1462,'g',0,'2011-11-25'),(761,'g',0,'2011-11-25'),(871,'g',0,'2011-11-25'),(1158,'g',0,'2011-11-25'),(765,'g',0,'2011-11-25'),(550,'g',0,'2011-11-25'),(863,'g',0,'2011-11-25'),(610,'g',0,'2011-11-25'),(749,'g',0,'2011-11-25'),(1109,'g',0,'2011-11-25'),(1189,'g',0,'2011-11-25'),(1152,'g',0,'2011-11-25'),(884,'g',0,'2011-11-25'),(636,'g',0,'2011-11-25'),(1223,'g',0,'2011-11-29'),(2583,'g',0,'2011-11-29'),(2310,'g',0,'2011-11-29'),(510,'g',0,'2011-11-29'),(2709,'g',0,'2011-11-30'),(3428,'g',0,'2011-11-30'),(2654,'g',0,'2011-12-01'),(1936,'g',0,'2011-12-01'),(501,'g',0,'2011-12-02'),(664,'g',0,'2011-12-02'),(685,'g',0,'2011-12-02'),(649,'g',0,'2011-12-02'),(668,'g',0,'2011-12-02'),(650,'g',0,'2011-12-02'),(3422,'g',0,'2011-12-03'),(2648,'g',0,'2011-12-03'),(1875,'g',0,'2011-12-05'),(1165,'g',0,'2011-12-05'),(1162,'g',0,'2011-12-05'),(1772,'g',0,'2011-12-05'),(1059,'g',0,'2011-12-05'),(1878,'g',0,'2011-12-05'),(3488,'g',0,'2011-12-07'),(4302,'g',0,'2011-12-07'),(4221,'g',0,'2011-12-07'),(5038,'g',0,'2011-12-07'),(517,'g',0,'2011-12-10'),(880,'g',0,'2011-12-10'),(591,'g',0,'2011-12-10'),(561,'g',0,'2011-12-10'),(1593,'g',0,'2011-12-10'),(1274,'g',0,'2011-12-10'),(1230,'g',0,'2011-12-10'),(1304,'g',0,'2011-12-10'),(5993,'g',0,'2011-12-12'),(6067,'g',0,'2011-12-12'),(6037,'g',0,'2011-12-12'),(6722,'g',0,'2011-12-13'),(5986,'g',0,'2011-12-13'),(6355,'g',0,'2011-12-13'),(6629,'g',0,'2011-12-13'),(6002,'g',0,'2011-12-14'),(6819,'g',0,'2011-12-14'),(5971,'g',0,'2011-12-14'),(6840,'g',0,'2011-12-14'),(5989,'g',0,'2011-12-14'),(6826,'g',0,'2011-12-14'),(6847,'g',0,'2011-12-14'),(6831,'g',0,'2011-12-14'),(5996,'g',0,'2011-12-14'),(6860,'g',0,'2011-12-14'),(6436,'g',0,'2011-12-14'),(6508,'g',0,'2011-12-14'),(6506,'g',0,'2011-12-14'),(6507,'g',0,'2011-12-14'),(6446,'g',0,'2011-12-14'),(6155,'g',0,'2011-12-14'),(417,'g',0,'2011-12-14'),(6845,'g',0,'2011-12-14'),(6034,'g',0,'2011-12-14'),(6881,'g',0,'2011-12-14'),(5990,'g',0,'2011-12-15'),(6010,'g',0,'2011-12-15'),(6011,'g',0,'2011-12-15'),(6009,'g',0,'2011-12-15'),(6872,'g',0,'2011-12-15'),(6876,'g',0,'2011-12-15'),(6864,'g',0,'2011-12-15'),(6866,'g',0,'2011-12-15'),(6883,'g',0,'2011-12-15'),(6896,'g',0,'2011-12-15'),(6602,'g',0,'2012-02-06'),(6714,'g',0,'2011-12-16'),(6234,'g',0,'2012-02-06'),(6716,'g',0,'2011-12-16'),(6905,'g',0,'2011-12-16'),(6891,'g',0,'2011-12-16'),(6855,'g',0,'2011-12-16'),(6007,'g',0,'2011-12-16'),(5970,'g',0,'2011-12-16'),(6737,'g',0,'2011-12-17'),(6330,'g',0,'2011-12-17'),(6908,'g',0,'2011-12-17'),(6906,'g',0,'2011-12-17'),(5980,'g',0,'2011-12-18'),(6026,'g',0,'2011-12-18'),(6021,'g',0,'2011-12-18'),(6008,'g',0,'2011-12-19'),(5978,'g',0,'2011-12-19'),(6920,'g',0,'2012-02-06'),(6949,'g',0,'2011-12-20'),(6953,'g',0,'2011-12-20'),(6940,'g',0,'2011-12-21'),(6898,'g',0,'2011-12-21'),(6904,'g',0,'2011-12-21'),(6894,'g',0,'2011-12-21'),(6900,'g',0,'2011-12-21'),(6890,'g',0,'2011-12-21'),(6886,'g',0,'2011-12-21'),(6884,'g',0,'2011-12-21'),(6888,'g',0,'2011-12-21'),(6895,'g',0,'2011-12-21'),(6966,'g',0,'2011-12-21'),(6919,'g',0,'2011-12-21'),(6917,'g',0,'2011-12-21'),(6971,'g',0,'2011-12-22'),(6969,'g',0,'2011-12-23'),(6973,'g',0,'2011-12-23'),(6964,'g',0,'2012-02-12'),(6335,'g',0,'2011-12-24'),(6545,'g',0,'2011-12-24'),(6343,'g',0,'2011-12-24'),(6636,'g',0,'2011-12-24'),(6681,'g',0,'2011-12-24'),(6579,'g',0,'2011-12-24'),(6431,'g',0,'2011-12-24'),(6221,'g',0,'2011-12-24'),(6961,'g',0,'2011-12-24'),(484,'g',0,'2011-12-25'),(483,'g',0,'2011-12-25'),(6092,'g',0,'2011-12-25'),(6094,'g',0,'2011-12-25'),(6079,'g',0,'2011-12-25'),(6093,'g',0,'2011-12-25'),(6880,'g',0,'2011-12-25'),(6095,'g',0,'2011-12-25'),(6091,'g',0,'2011-12-25'),(6090,'g',0,'2011-12-25'),(6125,'g',0,'2012-02-12'),(6871,'g',0,'2012-02-15'),(6137,'g',0,'2012-02-13'),(6126,'g',0,'2012-02-12'),(6962,'g',0,'2012-02-13'),(6974,'g',0,'2011-12-25'),(6675,'g',0,'2011-12-26'),(6769,'g',0,'2011-12-26'),(6767,'g',0,'2011-12-26'),(6712,'g',0,'2011-12-26'),(6795,'g',0,'2011-12-26'),(6721,'g',0,'2011-12-26'),(6807,'g',0,'2011-12-26'),(6901,'g',0,'2011-12-26'),(6774,'g',0,'2011-12-26'),(6677,'g',0,'2011-12-26'),(6687,'g',0,'2011-12-26'),(6720,'g',0,'2011-12-26'),(6172,'g',0,'2011-12-26'),(6533,'g',0,'2011-12-27'),(6000,'g',0,'2011-12-27'),(6329,'g',0,'2011-12-27'),(6984,'g',0,'2011-12-27'),(6785,'g',0,'2011-12-27'),(6694,'g',0,'2011-12-27'),(6736,'g',0,'2011-12-27'),(6612,'g',0,'2011-12-27'),(6553,'g',0,'2011-12-27'),(6648,'g',0,'2011-12-27'),(6715,'g',0,'2011-12-27'),(6348,'g',0,'2011-12-27'),(6356,'g',0,'2011-12-27'),(6887,'g',0,'2011-12-27'),(6959,'g',0,'2011-12-27'),(6805,'g',0,'2011-12-27'),(6773,'g',0,'2011-12-27'),(6965,'g',0,'2011-12-27'),(6575,'g',0,'2011-12-27'),(6076,'g',0,'2011-12-27'),(6689,'g',0,'2011-12-27'),(6945,'g',0,'2011-12-27'),(6611,'g',0,'2011-12-27'),(6127,'g',0,'2011-12-27'),(6051,'g',0,'2011-12-27'),(6796,'g',0,'2011-12-27'),(6909,'g',0,'2011-12-27'),(6918,'g',0,'2011-12-27'),(6539,'g',0,'2011-12-27'),(6646,'g',0,'2011-12-27'),(6551,'g',0,'2011-12-27'),(6269,'g',0,'2011-12-27'),(6238,'g',0,'2011-12-27'),(6963,'g',0,'2011-12-27'),(6220,'g',0,'2011-12-27'),(6162,'g',0,'2011-12-27'),(6347,'g',0,'2011-12-27'),(6286,'g',0,'2011-12-27'),(6178,'g',0,'2011-12-27'),(6479,'g',0,'2011-12-27'),(6752,'g',0,'2011-12-27'),(6682,'g',0,'2011-12-27'),(6717,'g',0,'2011-12-27'),(6779,'g',0,'2011-12-27'),(6719,'g',0,'2011-12-27'),(6771,'g',0,'2011-12-27'),(6783,'g',0,'2011-12-27'),(6333,'g',0,'2011-12-27'),(6526,'g',0,'2011-12-27'),(6493,'g',0,'2011-12-27'),(6315,'g',0,'2011-12-27'),(6338,'g',0,'2011-12-27'),(6543,'g',0,'2011-12-27'),(6558,'g',0,'2011-12-27'),(6316,'g',0,'2011-12-27'),(6500,'g',0,'2011-12-27'),(6776,'g',0,'2011-12-27'),(6332,'g',0,'2011-12-27'),(6336,'g',0,'2011-12-27'),(6512,'g',0,'2011-12-27'),(6701,'g',0,'2011-12-27'),(6735,'g',0,'2011-12-27'),(6775,'g',0,'2011-12-27'),(6534,'g',0,'2011-12-27'),(6517,'g',0,'2011-12-27'),(6317,'g',0,'2011-12-27'),(6496,'g',0,'2011-12-27'),(6297,'g',0,'2011-12-27'),(6718,'g',0,'2011-12-27'),(6313,'g',0,'2011-12-27'),(6320,'g',0,'2011-12-27'),(6353,'g',0,'2011-12-27'),(6408,'g',0,'2011-12-27'),(6402,'g',0,'2011-12-27'),(6350,'g',0,'2011-12-27'),(6412,'g',0,'2011-12-27'),(6357,'g',0,'2011-12-27'),(6351,'g',0,'2011-12-27'),(6404,'g',0,'2011-12-27'),(6369,'g',0,'2011-12-27'),(6418,'g',0,'2011-12-27'),(6960,'g',0,'2012-02-18'),(6868,'g',0,'2011-12-28'),(6869,'g',0,'2011-12-28'),(5975,'g',0,'2011-12-28'),(6138,'g',0,'2011-12-28'),(6140,'g',0,'2011-12-28'),(6088,'g',0,'2011-12-28'),(6069,'g',0,'2011-12-28'),(6040,'g',0,'2011-12-28'),(6117,'g',0,'2011-12-28'),(6066,'g',0,'2011-12-28'),(6142,'g',0,'2011-12-28'),(6062,'g',0,'2011-12-28'),(6128,'g',0,'2011-12-28'),(6045,'g',0,'2011-12-28'),(6053,'g',0,'2011-12-28'),(6054,'g',0,'2011-12-28'),(6932,'g',0,'2011-12-28'),(5994,'g',0,'2011-12-28'),(5967,'g',0,'2011-12-28'),(6933,'g',0,'2011-12-28'),(5987,'g',0,'2011-12-28'),(6038,'g',0,'2011-12-28'),(6024,'g',0,'2011-12-28'),(5983,'g',0,'2011-12-28'),(6927,'g',0,'2011-12-28'),(6028,'g',0,'2011-12-28'),(6789,'g',0,'2011-12-29'),(6788,'g',0,'2011-12-29'),(6782,'g',0,'2011-12-29'),(6302,'g',0,'2011-12-29'),(6268,'g',0,'2011-12-29'),(6281,'g',0,'2011-12-29'),(6327,'g',0,'2011-12-29'),(6149,'g',0,'2011-12-29'),(6295,'g',0,'2011-12-29'),(6325,'g',0,'2011-12-29'),(6340,'g',0,'2011-12-29'),(6277,'g',0,'2011-12-29'),(6228,'g',0,'2011-12-29'),(6618,'g',0,'2011-12-29'),(6709,'g',0,'2011-12-29'),(6520,'g',0,'2011-12-29'),(6434,'g',0,'2011-12-29'),(6405,'g',0,'2011-12-29'),(6705,'g',0,'2011-12-29'),(6586,'g',0,'2011-12-29'),(6454,'g',0,'2011-12-29'),(6482,'g',0,'2011-12-29'),(6654,'g',0,'2011-12-29'),(6659,'g',0,'2011-12-29'),(6975,'g',0,'2012-02-12'),(6652,'g',0,'2011-12-29'),(6668,'g',0,'2011-12-29'),(6685,'g',0,'2011-12-29'),(6657,'g',0,'2011-12-29'),(6684,'g',0,'2011-12-29'),(6588,'g',0,'2011-12-29'),(6603,'g',0,'2011-12-29'),(6589,'g',0,'2011-12-29'),(6577,'g',0,'2011-12-29'),(6605,'g',0,'2011-12-29'),(6592,'g',0,'2011-12-29'),(6585,'g',0,'2011-12-29'),(6665,'g',0,'2011-12-29'),(6591,'g',0,'2011-12-29'),(6590,'g',0,'2011-12-29'),(6600,'g',0,'2011-12-29'),(6664,'g',0,'2011-12-29'),(6604,'g',0,'2011-12-29'),(114,'g',0,'2012-02-02'),(7012,'g',0,'2011-12-29'),(6190,'g',0,'2011-12-29'),(6233,'g',0,'2011-12-29'),(6899,'g',0,'2011-12-29'),(6175,'g',0,'2011-12-30'),(6086,'g',0,'2011-12-30'),(6112,'g',0,'2011-12-30'),(6786,'g',0,'2011-12-30'),(6797,'g',0,'2011-12-30'),(6798,'g',0,'2011-12-30'),(6461,'g',0,'2011-12-30'),(6915,'g',0,'2011-12-30'),(6458,'g',0,'2011-12-30'),(6432,'g',0,'2011-12-30'),(6459,'g',0,'2011-12-30'),(6477,'g',0,'2011-12-30'),(6429,'g',0,'2011-12-30'),(6457,'g',0,'2011-12-30'),(6460,'g',0,'2011-12-30'),(6421,'g',0,'2011-12-30'),(6809,'g',0,'2011-12-30'),(6704,'g',0,'2011-12-30'),(6770,'g',0,'2011-12-30'),(6754,'g',0,'2011-12-30'),(6698,'g',0,'2011-12-30'),(6753,'g',0,'2011-12-30'),(6696,'g',0,'2011-12-30'),(6695,'g',0,'2011-12-30'),(6703,'g',0,'2011-12-30'),(6702,'g',0,'2011-12-30'),(6711,'g',0,'2011-12-30'),(6991,'g',0,'2011-12-31'),(6989,'g',0,'2012-02-13'),(6977,'g',0,'2012-01-02'),(6980,'g',0,'2012-01-02'),(7008,'g',0,'2012-01-02'),(6561,'g',0,'2012-01-02'),(6615,'g',0,'2012-01-02'),(6651,'g',0,'2012-01-02'),(6670,'g',0,'2012-01-02'),(6562,'g',0,'2012-01-02'),(6627,'g',0,'2012-01-02'),(6645,'g',0,'2012-01-02'),(7027,'g',0,'2012-01-02'),(7037,'g',0,'2012-01-02'),(7031,'g',0,'2012-01-02'),(7028,'g',0,'2012-01-02'),(7036,'g',0,'2012-01-02'),(6967,'g',0,'2012-01-02'),(6630,'g',0,'2012-01-02'),(6567,'g',0,'2012-01-02'),(6594,'g',0,'2012-01-02'),(6642,'g',0,'2012-01-02'),(6570,'g',0,'2012-01-02'),(6569,'g',0,'2012-01-02'),(6619,'g',0,'2012-01-02'),(6633,'g',0,'2012-01-02'),(6631,'g',0,'2012-01-02'),(6552,'g',0,'2012-01-02'),(7025,'g',0,'2012-01-02'),(6986,'g',0,'2012-01-02'),(7032,'g',0,'2012-01-02'),(7002,'g',0,'2012-01-02'),(7007,'g',0,'2012-01-02'),(6956,'g',0,'2012-01-03'),(7017,'g',0,'2012-01-03'),(7029,'g',0,'2012-01-03'),(7005,'g',0,'2012-01-03'),(6978,'g',0,'2012-01-03'),(6865,'g',0,'2012-01-03'),(7045,'g',0,'2012-01-03'),(6968,'g',0,'2012-01-03'),(6256,'g',0,'2012-01-03'),(6275,'g',0,'2012-01-03'),(6255,'g',0,'2012-01-03'),(7004,'g',0,'2012-01-03'),(6257,'g',0,'2012-01-03'),(6292,'g',0,'2012-01-03'),(6267,'g',0,'2012-01-03'),(6270,'g',0,'2012-01-03'),(6282,'g',0,'2012-01-03'),(6921,'g',0,'2012-01-03'),(6970,'g',0,'2012-01-03'),(7014,'g',0,'2012-01-03'),(6907,'g',0,'2012-01-03'),(6995,'g',0,'2012-01-03'),(7021,'g',0,'2012-01-04'),(7034,'g',0,'2012-01-06'),(6981,'g',0,'2012-01-07'),(6676,'g',0,'2012-01-09'),(7072,'g',0,'2012-01-10'),(7051,'g',0,'2012-01-11'),(7050,'g',0,'2012-01-11'),(7074,'g',0,'2012-01-13'),(7095,'g',0,'2012-01-13'),(7049,'g',0,'2012-01-13'),(7009,'g',0,'2012-01-15'),(7056,'g',0,'2012-01-16'),(6599,'g',0,'2012-01-16'),(6529,'g',0,'2012-01-16'),(6597,'g',0,'2012-01-16'),(6637,'g',0,'2012-01-16'),(6598,'g',0,'2012-01-16'),(7082,'g',0,'2012-01-16'),(7046,'g',0,'2012-01-19'),(7023,'g',0,'2012-01-19'),(432,'g',0,'2012-01-20'),(116,'g',0,'2012-01-20'),(169,'g',0,'2012-01-20'),(420,'g',0,'2012-01-20'),(195,'g',0,'2012-01-20'),(368,'g',0,'2012-01-20'),(376,'g',0,'2012-01-20'),(111,'g',0,'2012-01-20'),(463,'g',0,'2012-01-20'),(185,'g',0,'2012-01-20'),(7093,'g',0,'2012-01-21'),(7068,'g',0,'2012-01-22'),(7145,'g',0,'2012-01-23'),(7160,'g',0,'2012-01-24'),(7176,'g',0,'2012-01-25'),(7149,'g',0,'2012-01-26'),(7162,'g',0,'2012-01-27'),(7158,'g',0,'2012-01-30'),(7203,'g',0,'2012-01-31'),(7230,'g',0,'2012-02-01'),(7233,'g',0,'2012-02-08'),(454,'g',0,'2012-02-11'),(6565,'g',0,'2012-02-12'),(6625,'g',0,'2012-02-12'),(7274,'g',0,'2012-02-12'),(6555,'g',0,'2012-02-12'),(6237,'g',0,'2012-02-12'),(6522,'g',0,'2012-02-12'),(6515,'g',0,'2012-02-12'),(7016,'g',0,'2012-02-13'),(6738,'g',0,'2012-02-13'),(6707,'g',0,'2012-02-13'),(6787,'g',0,'2012-02-13'),(6817,'g',0,'2012-02-13'),(6751,'g',0,'2012-02-13'),(6435,'g',0,'2012-02-13'),(6375,'g',0,'2012-02-13'),(6319,'g',0,'2012-02-13'),(6312,'g',0,'2012-02-13'),(6366,'g',0,'2012-02-13'),(6400,'g',0,'2012-02-13'),(6437,'g',0,'2012-02-13'),(6438,'g',0,'2012-02-13'),(6399,'g',0,'2012-02-13'),(6439,'g',0,'2012-02-13'),(6456,'g',0,'2012-02-13'),(6472,'g',0,'2012-02-13'),(6462,'g',0,'2012-02-13'),(6616,'g',0,'2012-02-13'),(6440,'g',0,'2012-02-13'),(6443,'g',0,'2012-02-13'),(6596,'g',0,'2012-02-13'),(6672,'g',0,'2012-02-13'),(6536,'g',0,'2012-02-13'),(6706,'g',0,'2012-02-13'),(6135,'g',0,'2012-02-14'),(6019,'g',0,'2012-02-14'),(7156,'g',0,'2012-02-14'),(7266,'g',0,'2012-02-15'),(7250,'g',0,'2012-02-15'),(6954,'g',0,'2012-02-15'),(7216,'g',0,'2012-02-15'),(6050,'g',0,'2012-02-15'),(5963,'g',0,'2012-02-15'),(6290,'g',0,'2012-02-15'),(6361,'g',0,'2012-02-15'),(6935,'g',0,'2012-02-15'),(6150,'g',0,'2012-02-15'),(6911,'g',0,'2012-02-15'),(6119,'g',0,'2012-02-15'),(6254,'g',0,'2012-02-15'),(6102,'g',0,'2012-02-15'),(7261,'g',0,'2012-02-15'),(6108,'g',0,'2012-02-15'),(6100,'g',0,'2012-02-15'),(7128,'g',0,'2012-02-15'),(7246,'g',0,'2012-02-15'),(6910,'g',0,'2012-02-15'),(7075,'g',0,'2012-02-15'),(6148,'g',0,'2012-02-15'),(7244,'g',0,'2012-02-15'),(7218,'g',0,'2012-02-15'),(6278,'g',0,'2012-02-15'),(7242,'g',0,'2012-02-15'),(6345,'g',0,'2012-02-15'),(7249,'g',0,'2012-02-15'),(7001,'g',0,'2012-02-15'),(6231,'g',0,'2012-02-15'),(6381,'g',0,'2012-02-15'),(6229,'g',0,'2012-02-15'),(6359,'g',0,'2012-02-15'),(7090,'g',0,'2012-02-15'),(6930,'g',0,'2012-02-15'),(6307,'g',0,'2012-02-15'),(6084,'g',0,'2012-02-15'),(6367,'g',0,'2012-02-15'),(6104,'g',0,'2012-02-15'),(7153,'g',0,'2012-02-15'),(7099,'g',0,'2012-02-15'),(6176,'g',0,'2012-02-15'),(6122,'g',0,'2012-02-15'),(6349,'g',0,'2012-02-15'),(7228,'g',0,'2012-02-15'),(6391,'g',0,'2012-02-15'),(7251,'g',0,'2012-02-15'),(6392,'g',0,'2012-02-15'),(6121,'g',0,'2012-02-15'),(6156,'g',0,'2012-02-15'),(91,'g',0,'2012-02-15'),(6938,'g',0,'2012-02-15'),(7253,'g',0,'2012-02-15'),(7271,'g',0,'2012-02-15'),(6197,'g',0,'2012-02-15'),(6311,'g',0,'2012-02-15'),(7226,'g',0,'2012-02-15'),(6547,'g',0,'2012-02-15'),(446,'g',0,'2012-02-15'),(6394,'g',0,'2012-02-15'),(6425,'g',0,'2012-02-15'),(381,'g',0,'2012-02-15'),(6957,'g',0,'2012-02-15'),(6499,'g',0,'2012-02-15'),(365,'g',0,'2012-02-15'),(448,'g',0,'2012-02-15'),(6406,'g',0,'2012-02-15'),(372,'g',0,'2012-02-15'),(6538,'g',0,'2012-02-15'),(6972,'g',0,'2012-02-15'),(358,'g',0,'2012-02-15'),(6397,'g',0,'2012-02-15'),(359,'g',0,'2012-02-15'),(427,'g',0,'2012-02-15'),(6396,'g',0,'2012-02-15'),(377,'g',0,'2012-02-15'),(456,'g',0,'2012-02-15'),(6467,'g',0,'2012-02-15'),(383,'g',0,'2012-02-15'),(6514,'g',0,'2012-02-15'),(6987,'g',0,'2012-02-15'),(6403,'g',0,'2012-02-15'),(6544,'g',0,'2012-02-15'),(479,'g',0,'2012-02-15'),(481,'g',0,'2012-02-15'),(6395,'g',0,'2012-02-15'),(6979,'g',0,'2012-02-15'),(6424,'g',0,'2012-02-15'),(6393,'g',0,'2012-02-15'),(392,'g',0,'2012-02-15'),(482,'g',0,'2012-02-15'),(7248,'g',0,'2012-02-15'),(6239,'g',0,'2012-02-16'),(6463,'g',0,'2012-02-16'),(6484,'g',0,'2012-02-16'),(6360,'g',0,'2012-02-16'),(6473,'g',0,'2012-02-16'),(6476,'g',0,'2012-02-16'),(6470,'g',0,'2012-02-16'),(6478,'g',0,'2012-02-16'),(6481,'g',0,'2012-02-16'),(6483,'g',0,'2012-02-16'),(6474,'g',0,'2012-02-16'),(6466,'g',0,'2012-02-16'),(6468,'g',0,'2012-02-16'),(6475,'g',0,'2012-02-16'),(6471,'g',0,'2012-02-16'),(311,'g',0,'2012-02-16'),(262,'g',0,'2012-02-16'),(165,'g',0,'2012-02-16'),(224,'g',0,'2012-02-16'),(168,'g',0,'2012-02-16'),(298,'g',0,'2012-02-16'),(196,'g',0,'2012-02-16'),(316,'g',0,'2012-02-16'),(342,'g',0,'2012-02-16'),(191,'g',0,'2012-02-16'),(318,'g',0,'2012-02-16'),(222,'g',0,'2012-02-16'),(235,'g',0,'2012-02-16'),(148,'g',0,'2012-02-16'),(197,'g',0,'2012-02-16'),(256,'g',0,'2012-02-16'),(283,'g',0,'2012-02-16'),(276,'g',0,'2012-02-16'),(117,'g',0,'2012-02-16'),(286,'g',0,'2012-02-16'),(301,'g',0,'2012-02-16'),(218,'g',0,'2012-02-16'),(265,'g',0,'2012-02-16'),(257,'g',0,'2012-02-16'),(212,'g',0,'2012-02-16'),(335,'g',0,'2012-02-16'),(142,'g',0,'2012-02-16'),(248,'g',0,'2012-02-16'),(320,'g',0,'2012-02-16'),(340,'g',0,'2012-02-16'),(280,'g',0,'2012-02-16'),(136,'g',0,'2012-02-16'),(144,'g',0,'2012-02-16'),(231,'g',0,'2012-02-16'),(305,'g',0,'2012-02-16'),(210,'g',0,'2012-02-16'),(233,'g',0,'2012-02-16'),(334,'g',0,'2012-02-16'),(277,'g',0,'2012-02-16'),(146,'g',0,'2012-02-16'),(189,'g',0,'2012-02-16'),(338,'g',0,'2012-02-16'),(192,'g',0,'2012-02-16'),(274,'g',0,'2012-02-16'),(296,'g',0,'2012-02-16'),(295,'g',0,'2012-02-16'),(181,'g',0,'2012-02-16'),(187,'g',0,'2012-02-16'),(112,'g',0,'2012-02-16'),(293,'g',0,'2012-02-16'),(449,'g',0,'2012-02-16'),(247,'g',0,'2012-02-16'),(402,'g',0,'2012-02-16'),(194,'g',0,'2012-02-16'),(147,'g',0,'2012-02-16'),(254,'g',0,'2012-02-16'),(149,'g',0,'2012-02-16'),(249,'g',0,'2012-02-16'),(275,'g',0,'2012-02-16'),(260,'g',0,'2012-02-16'),(281,'g',0,'2012-02-16'),(474,'g',0,'2012-02-16'),(267,'g',0,'2012-02-16'),(253,'g',0,'2012-02-16'),(285,'g',0,'2012-02-16'),(268,'g',0,'2012-02-16'),(178,'g',0,'2012-02-16'),(141,'g',0,'2012-02-16'),(341,'g',0,'2012-02-16'),(319,'g',0,'2012-02-16'),(245,'g',0,'2012-02-16'),(475,'g',0,'2012-02-16'),(203,'g',0,'2012-02-16'),(186,'g',0,'2012-02-16'),(336,'g',0,'2012-02-16'),(299,'g',0,'2012-02-16'),(308,'g',0,'2012-02-16'),(468,'g',0,'2012-02-16'),(259,'g',0,'2012-02-16'),(395,'g',0,'2012-02-16'),(219,'g',0,'2012-02-16'),(175,'g',0,'2012-02-16'),(404,'g',0,'2012-02-16'),(244,'g',0,'2012-02-16'),(332,'g',0,'2012-02-16'),(270,'g',0,'2012-02-16'),(321,'g',0,'2012-02-16'),(266,'g',0,'2012-02-16'),(297,'g',0,'2012-02-16'),(243,'g',0,'2012-02-16'),(227,'g',0,'2012-02-16'),(155,'g',0,'2012-02-16'),(236,'g',0,'2012-02-16'),(264,'g',0,'2012-02-16'),(232,'g',0,'2012-02-16'),(230,'g',0,'2012-02-16'),(246,'g',0,'2012-02-16'),(272,'g',0,'2012-02-16'),(237,'g',0,'2012-02-16'),(312,'g',0,'2012-02-16'),(95,'g',0,'2012-02-16'),(279,'g',0,'2012-02-16'),(290,'g',0,'2012-02-16'),(228,'g',0,'2012-02-16'),(300,'g',0,'2012-02-16'),(411,'g',0,'2012-02-16'),(294,'g',0,'2012-02-16'),(282,'g',0,'2012-02-16'),(225,'g',0,'2012-02-16'),(251,'g',0,'2012-02-16'),(429,'g',0,'2012-02-16'),(182,'g',0,'2012-02-16'),(304,'g',0,'2012-02-16'),(403,'g',0,'2012-02-16'),(273,'g',0,'2012-02-16'),(184,'g',0,'2012-02-16'),(174,'g',0,'2012-02-16'),(215,'g',0,'2012-02-16'),(6678,'g',0,'2012-02-16'),(6358,'g',0,'2012-02-16'),(288,'g',0,'2012-02-16'),(6354,'g',0,'2012-02-16'),(269,'g',0,'2012-02-16'),(226,'g',0,'2012-02-16'),(261,'g',0,'2012-02-16'),(255,'g',0,'2012-02-16'),(313,'g',0,'2012-02-16'),(271,'g',0,'2012-02-16'),(258,'g',0,'2012-02-16'),(306,'g',0,'2012-02-16'),(183,'g',0,'2012-02-16'),(287,'g',0,'2012-02-16'),(198,'g',0,'2012-02-16'),(346,'g',0,'2012-02-16'),(337,'g',0,'2012-02-16'),(419,'g',0,'2012-02-16'),(241,'g',0,'2012-02-16'),(150,'g',0,'2012-02-16'),(284,'g',0,'2012-02-16'),(303,'g',0,'2012-02-16'),(250,'g',0,'2012-02-16'),(307,'g',0,'2012-02-16'),(291,'g',0,'2012-02-16'),(207,'g',0,'2012-02-16'),(201,'g',0,'2012-02-16'),(234,'g',0,'2012-02-16'),(154,'g',0,'2012-02-16'),(466,'g',0,'2012-02-16'),(217,'g',0,'2012-02-16'),(145,'g',0,'2012-02-16'),(140,'g',0,'2012-02-16'),(263,'g',0,'2012-02-16'),(221,'g',0,'2012-02-16'),(292,'g',0,'2012-02-16'),(177,'g',0,'2012-02-16'),(302,'g',0,'2012-02-16'),(208,'g',0,'2012-02-17'),(229,'g',0,'2012-02-17'),(220,'g',0,'2012-02-17'),(238,'g',0,'2012-02-17'),(278,'g',0,'2012-02-17'),(333,'g',0,'2012-02-17'),(464,'g',0,'2012-02-17'),(173,'g',0,'2012-02-17'),(223,'g',0,'2012-02-17'),(421,'g',0,'2012-02-17'),(242,'g',0,'2012-02-17'),(339,'g',0,'2012-02-17'),(176,'g',0,'2012-02-17'),(152,'g',0,'2012-02-17'),(289,'g',0,'2012-02-17'),(384,'g',0,'2012-02-17'),(143,'g',0,'2012-02-17'),(317,'g',0,'2012-02-17'),(118,'g',0,'2012-02-17'),(467,'g',0,'2012-02-17'),(314,'g',0,'2012-02-17'),(400,'g',0,'2012-02-17'),(252,'g',0,'2012-02-17'),(6146,'g',0,'2012-02-17'),(5966,'g',0,'2012-02-17'),(7047,'g',0,'2012-02-17'),(6195,'g',0,'2012-02-17'),(7129,'g',0,'2012-02-17'),(6144,'g',0,'2012-02-17'),(6941,'g',0,'2012-02-17'),(7202,'g',0,'2012-02-17'),(5974,'g',0,'2012-02-17'),(6944,'g',0,'2012-02-17'),(6200,'g',0,'2012-02-17'),(7123,'g',0,'2012-02-17'),(6165,'g',0,'2012-02-17'),(6065,'g',0,'2012-02-17'),(6036,'g',0,'2012-02-17'),(5968,'g',0,'2012-02-17'),(7087,'g',0,'2012-02-17'),(5992,'g',0,'2012-02-17'),(7170,'g',0,'2012-02-17'),(6110,'g',0,'2012-02-17'),(7044,'g',0,'2012-02-17'),(7245,'g',0,'2012-02-17'),(5965,'g',0,'2012-02-17'),(6212,'g',0,'2012-02-17'),(6107,'g',0,'2012-02-17'),(6120,'g',0,'2012-02-17'),(6031,'g',0,'2012-02-17'),(6013,'g',0,'2012-02-17'),(7174,'g',0,'2012-02-17'),(6194,'g',0,'2012-02-17'),(5969,'g',0,'2012-02-17'),(7219,'g',0,'2012-02-17'),(7115,'g',0,'2012-02-17'),(6071,'g',0,'2012-02-17'),(7168,'g',0,'2012-02-17'),(6169,'g',0,'2012-02-17'),(6147,'g',0,'2012-02-17'),(7134,'g',0,'2012-02-17'),(7080,'g',0,'2012-02-17'),(6206,'g',0,'2012-02-17'),(6143,'g',0,'2012-02-17'),(5981,'g',0,'2012-02-17'),(7096,'g',0,'2012-02-17'),(7173,'g',0,'2012-02-17'),(6222,'g',0,'2012-02-17'),(6109,'g',0,'2012-02-17'),(6240,'g',0,'2012-02-17'),(6168,'g',0,'2012-02-17'),(6952,'g',0,'2012-02-17'),(6078,'g',0,'2012-02-17'),(7094,'g',0,'2012-02-17'),(6159,'g',0,'2012-02-17'),(6003,'g',0,'2012-02-17'),(7224,'g',0,'2012-02-17'),(7232,'g',0,'2012-02-17'),(6937,'g',0,'2012-02-17'),(6867,'g',0,'2012-02-17'),(6032,'g',0,'2012-02-17'),(6057,'g',0,'2012-02-17'),(6870,'g',0,'2012-02-17'),(7061,'g',0,'2012-02-17'),(6873,'g',0,'2012-02-17'),(7114,'g',0,'2012-02-17'),(6893,'g',0,'2012-02-17'),(7136,'g',0,'2012-02-17'),(5999,'g',0,'2012-02-17'),(7101,'g',0,'2012-02-17'),(6874,'g',0,'2012-02-17'),(6892,'g',0,'2012-02-17'),(6077,'g',0,'2012-02-17'),(6249,'g',0,'2012-02-17'),(6252,'g',0,'2012-02-17'),(7283,'g',0,'2012-02-17'),(6251,'g',0,'2012-02-17'),(6241,'g',0,'2012-02-17'),(6253,'g',0,'2012-02-17'),(431,'g',0,'2012-02-17'),(7278,'g',0,'2012-02-17'),(438,'g',0,'2012-02-17'),(7033,'g',0,'2012-02-17'),(405,'g',0,'2012-02-17'),(199,'g',0,'2012-02-17'),(6955,'g',0,'2012-02-17'),(440,'g',0,'2012-02-17'),(7030,'g',0,'2012-02-17'),(6976,'g',0,'2012-02-17'),(423,'g',0,'2012-02-17'),(459,'g',0,'2012-02-17'),(6990,'g',0,'2012-02-17'),(477,'g',0,'2012-02-17'),(7003,'g',0,'2012-02-17'),(360,'g',0,'2012-02-17'),(422,'g',0,'2012-02-17'),(6982,'g',0,'2012-02-17'),(413,'g',0,'2012-02-17'),(7058,'g',0,'2012-02-18'),(7084,'g',0,'2012-02-18'),(7088,'g',0,'2012-02-18'),(7284,'g',0,'2012-02-18'),(6992,'g',0,'2012-02-19'),(7267,'g',0,'2012-02-20'),(7147,'g',0,'2012-02-20'),(6035,'g',0,'2012-02-20'),(6207,'g',0,'2012-02-20'),(6183,'g',0,'2012-02-21'),(6042,'g',0,'2012-02-21'),(6186,'g',0,'2012-02-21'),(7241,'g',0,'2012-02-21'),(6167,'g',0,'2012-02-21'),(6877,'g',0,'2012-02-21'),(7078,'g',0,'2012-02-21'),(7011,'g',0,'2012-02-21'),(6191,'g',0,'2012-02-21'),(7237,'g',0,'2012-02-21'),(7097,'g',0,'2012-02-21'),(7131,'g',0,'2012-02-21'),(7239,'g',0,'2012-02-21'),(7210,'g',0,'2012-02-21'),(6182,'g',0,'2012-02-21'),(7026,'g',0,'2012-02-21'),(6889,'g',0,'2012-02-21'),(6098,'g',0,'2012-02-21'),(7211,'g',0,'2012-02-21'),(6101,'g',0,'2012-02-21'),(6368,'g',0,'2012-02-21'),(7287,'g',0,'2012-02-21'),(7254,'g',0,'2012-02-21'),(6187,'g',0,'2012-02-21'),(7116,'g',0,'2012-02-21'),(7290,'g',0,'2012-02-21'),(7024,'g',0,'2012-02-21'),(6131,'g',0,'2012-02-21'),(6185,'g',0,'2012-02-21'),(6365,'g',0,'2012-02-21'),(6012,'g',0,'2012-02-21'),(7119,'g',0,'2012-02-21'),(6306,'g',0,'2012-02-21'),(7089,'g',0,'2012-02-21'),(7038,'g',0,'2012-02-21'),(7042,'g',0,'2012-02-21'),(6879,'g',0,'2012-02-21'),(6314,'g',0,'2012-02-21'),(6279,'g',0,'2012-02-21'),(7048,'g',0,'2012-02-21'),(6352,'g',0,'2012-02-21'),(6184,'g',0,'2012-02-21'),(6258,'g',0,'2012-02-21'),(6318,'g',0,'2012-02-21'),(7234,'g',0,'2012-02-21'),(6999,'g',0,'2012-02-21'),(6376,'g',0,'2012-02-21'),(6996,'g',0,'2012-02-21'),(7010,'g',0,'2012-02-21'),(6105,'g',0,'2012-02-21'),(7223,'g',0,'2012-02-21'),(7243,'g',0,'2012-02-21'),(7086,'g',0,'2012-02-21'),(7212,'g',0,'2012-02-21'),(6950,'g',0,'2012-02-21'),(7054,'g',0,'2012-02-21'),(7130,'g',0,'2012-02-21'),(7120,'g',0,'2012-02-21'),(6188,'g',0,'2012-02-21'),(7143,'g',0,'2012-02-21'),(7092,'g',0,'2012-02-21'),(5972,'g',0,'2012-02-21'),(7118,'g',0,'2012-02-21'),(7117,'g',0,'2012-02-21'),(6082,'g',0,'2012-02-21'),(7059,'g',0,'2012-02-21'),(6998,'g',0,'2012-02-21'),(7062,'g',0,'2012-02-21'),(7041,'g',0,'2012-02-21'),(7019,'g',0,'2012-02-21'),(7070,'g',0,'2012-02-21'),(7071,'g',0,'2012-02-21'),(7040,'g',0,'2012-02-21'),(6885,'g',0,'2012-02-21'),(6247,'g',0,'2012-02-21'),(7259,'g',0,'2012-02-21'),(7121,'g',0,'2012-02-21'),(7148,'g',0,'2012-02-21'),(6946,'g',0,'2012-02-21'),(6016,'g',0,'2012-02-21'),(7035,'g',0,'2012-02-21'),(7235,'g',0,'2012-02-21'),(7018,'g',0,'2012-02-21'),(6027,'g',0,'2012-02-21'),(6242,'g',0,'2012-02-21'),(7122,'g',0,'2012-02-21'),(7000,'g',0,'2012-02-21'),(7076,'g',0,'2012-02-21'),(6145,'g',0,'2012-02-21'),(7268,'g',0,'2012-02-21'),(7083,'g',0,'2012-02-21'),(6374,'g',0,'2012-02-21'),(6114,'g',0,'2012-02-21'),(7166,'g',0,'2012-02-21'),(7282,'g',0,'2012-02-21'),(7302,'g',0,'2012-02-21'),(7238,'g',0,'2012-02-21'),(7022,'g',0,'2012-02-21'),(6337,'g',0,'2012-02-22'),(6450,'g',0,'2012-02-22'),(7273,'g',0,'2012-02-22'),(6410,'g',0,'2012-02-22'),(6442,'g',0,'2012-02-22'),(6422,'g',0,'2012-02-22'),(6380,'g',0,'2012-02-22'),(6161,'g',0,'2012-02-22'),(6164,'g',0,'2012-02-22'),(6388,'g',0,'2012-02-22'),(6452,'g',0,'2012-02-22'),(6549,'g',0,'2012-02-22'),(6550,'g',0,'2012-02-22'),(6513,'g',0,'2012-02-22'),(6383,'g',0,'2012-02-22'),(6504,'g',0,'2012-02-22'),(6444,'g',0,'2012-02-22'),(6548,'g',0,'2012-02-22'),(6417,'g',0,'2012-02-22'),(6377,'g',0,'2012-02-22'),(7175,'g',0,'2012-02-22'),(6389,'g',0,'2012-02-22'),(6378,'g',0,'2012-02-22'),(6415,'g',0,'2012-02-22'),(6382,'g',0,'2012-02-22'),(6505,'g',0,'2012-02-22'),(6390,'g',0,'2012-02-22'),(6385,'g',0,'2012-02-22'),(6413,'g',0,'2012-02-22'),(6441,'g',0,'2012-02-22'),(6386,'g',0,'2012-02-23'),(6428,'g',0,'2012-02-23'),(6414,'g',0,'2012-02-23'),(6451,'g',0,'2012-02-23'),(6416,'g',0,'2012-02-23'),(6387,'g',0,'2012-02-23'),(6535,'g',0,'2012-02-23'),(6384,'g',0,'2012-02-23'),(6449,'g',0,'2012-02-23'),(7297,'g',0,'2012-02-23'),(7292,'g',0,'2012-02-24'),(7303,'g',0,'2012-02-24'),(5997,'g',0,'2012-02-25'),(6213,'g',0,'2012-02-25'),(6563,'g',0,'2012-02-25'),(6280,'g',0,'2012-02-25'),(6882,'g',0,'2012-02-25'),(6298,'g',0,'2012-02-25'),(6133,'g',0,'2012-02-25'),(5998,'g',0,'2012-02-25'),(6465,'g',0,'2012-02-25'),(6111,'g',0,'2012-02-25'),(6710,'g',0,'2012-02-25'),(6289,'g',0,'2012-02-25'),(6801,'g',0,'2012-02-25'),(6294,'g',0,'2012-02-25'),(6494,'g',0,'2012-02-25'),(6291,'g',0,'2012-02-25'),(5976,'g',0,'2012-02-25'),(6304,'g',0,'2012-02-25'),(6160,'g',0,'2012-02-25'),(6020,'g',0,'2012-02-25'),(6372,'g',0,'2012-02-25'),(6287,'g',0,'2012-02-25'),(6059,'g',0,'2012-02-25'),(6875,'g',0,'2012-02-25'),(6942,'g',0,'2012-02-26'),(6236,'g',0,'2012-02-26'),(5985,'g',0,'2012-02-26'),(6564,'g',0,'2012-02-26'),(6448,'g',0,'2012-02-26'),(6299,'g',0,'2012-02-26'),(6017,'g',0,'2012-02-26'),(6897,'g',0,'2012-02-26'),(6005,'g',0,'2012-02-26'),(7255,'g',0,'2012-02-26'),(6296,'g',0,'2012-02-26'),(6224,'g',0,'2012-02-26'),(6606,'g',0,'2012-02-26'),(6490,'g',0,'2012-02-26'),(7304,'g',0,'2012-02-26'),(6189,'g',0,'2012-02-26'),(6697,'g',0,'2012-02-26'),(7240,'g',0,'2012-02-26'),(7006,'g',0,'2012-02-26'),(6993,'g',0,'2012-02-26'),(6994,'g',0,'2012-02-26'),(6673,'g',0,'2012-02-26'),(6803,'g',0,'2012-02-26'),(6328,'g',0,'2012-02-26'),(7281,'g',0,'2012-02-26'),(6303,'g',0,'2012-02-26'),(6171,'g',0,'2012-02-26'),(5984,'g',0,'2012-02-26'),(7247,'g',0,'2012-02-26'),(6430,'g',0,'2012-02-27'),(6301,'g',0,'2012-02-27'),(7064,'g',0,'2012-02-27'),(7126,'g',0,'2012-02-27'),(6792,'g',0,'2012-02-27'),(7055,'g',0,'2012-02-27'),(7291,'g',0,'2012-02-27'),(7300,'g',0,'2012-02-27'),(7105,'g',0,'2012-02-28'),(7106,'g',0,'2012-02-29'),(7313,'g',0,'2012-03-01'),(7314,'g',0,'2012-03-01'),(6724,'g',0,'2012-03-01'),(6106,'g',0,'2012-03-01'),(7015,'g',0,'2012-03-02'),(455,'g',0,'2012-03-02'),(6958,'g',0,'2012-03-02'),(7298,'g',0,'2012-03-02'),(6132,'g',0,'2012-03-02'),(6497,'g',0,'2012-03-02'),(6074,'g',0,'2012-03-02'),(6692,'g',0,'2012-03-02'),(6802,'g',0,'2012-03-02'),(7215,'g',0,'2012-03-02'),(7258,'g',0,'2012-03-02'),(6903,'g',0,'2012-03-02'),(7073,'g',0,'2012-03-02'),(6934,'g',0,'2012-03-02'),(6943,'g',0,'2012-03-03'),(7272,'g',0,'2012-03-03'),(6284,'g',0,'2012-03-03'),(6947,'g',0,'2012-03-03'),(6464,'g',0,'2012-03-03'),(6225,'g',0,'2012-03-03'),(6916,'g',0,'2012-03-03'),(6666,'g',0,'2012-03-03'),(6469,'g',0,'2012-03-03'),(6951,'g',0,'2012-03-03'),(6230,'g',0,'2012-03-03'),(6001,'g',0,'2012-03-03'),(6528,'g',0,'2012-03-03'),(7169,'g',0,'2012-03-03'),(7263,'g',0,'2012-03-03'),(6902,'g',0,'2012-03-03'),(7067,'g',0,'2012-03-03'),(7151,'g',0,'2012-03-03'),(7065,'g',0,'2012-03-03'),(6427,'g',0,'2012-03-03'),(7323,'g',0,'2012-03-03'),(7324,'g',0,'2012-03-05'),(7327,'g',0,'2012-03-05'),(7326,'g',0,'2012-03-05'),(7167,'g',0,'2012-03-05'),(6576,'g',0,'2012-03-06'),(6309,'g',0,'2012-03-06'),(6667,'g',0,'2012-03-06'),(6800,'g',0,'2012-03-06'),(6518,'g',0,'2012-03-06'),(6323,'g',0,'2012-03-06'),(6370,'g',0,'2012-03-06'),(6816,'g',0,'2012-03-06'),(6587,'g',0,'2012-03-06'),(6674,'g',0,'2012-03-06'),(6686,'g',0,'2012-03-06'),(7343,'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 ('','','','');

--
-- 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','hoba.us'),(5,'site_url','http://hoba.us'),(6,'email_address','brielles.awadallah@gmail.com'),(7,'language_code','en_US'),(8,'theme_path','/home/hoba/public_html/themes/'),(9,'admin_template_path','/home/hoba/public_html/admin_tpl/'),(10,'plugin_path','/home/hoba/public_html/plugin/'),(12,'active_theme','_hoba'),(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 (56,'203.92.47.195',5);


