--
-- Host: stumblesites.org    Database: stumbles_sites
-- ------------------------------------------------------


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

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

INSERT INTO `idx_category` VALUES (318,0,'Arts & Entertainment','','folder.gif','','1',9,'','','0','0','','',0,'',0,0,0,0,0),(319,0,'Automotive','','folder.gif','','1',29,'','','0','0','','',0,'',0,0,0,0,0),(320,0,'Business','','folder.gif','','1',110,'','','0','0','','',0,'',0,0,0,0,0),(321,0,'Careers & Jobs','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(322,0,'Clothing','','folder.gif','','1',8,'','','0','0','','',0,'',0,0,0,0,0),(323,0,'Communications','','folder.gif','','1',13,'','','0','0','','',0,'',0,0,0,0,0),(324,0,'Computer & Internet','','folder.gif','','1',15,'','','0','0','','',0,'',0,0,0,0,0),(325,0,'Construction Services','','folder.gif','','1',62,'','','0','0','','',0,'',0,0,0,0,0),(326,0,'Dental Health','','folder.gif','','1',64,'','','0','0','','',0,'',0,0,0,0,0),(327,0,'Education & Training','','folder.gif','','1',21,'','','0','0','','',0,'',0,0,0,0,0),(328,0,'Employment & Recruitment','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(329,0,'Gifts & Novelties','','folder.gif','','1',19,'','','0','0','','',0,'',0,0,0,0,0),(330,0,'Software & Hardware','','folder.gif','','1',6,'','','0','0','','',0,'',0,0,0,0,0),(331,0,'Health Services','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(332,0,'Healthcare Industry','','folder.gif','','1',115,'','','0','0','','',0,'',0,0,0,0,0),(333,0,'Heating, Ventilating and Air Conditioning','','folder.gif','','1',49,'','','0','0','','',0,'',0,0,0,0,0),(334,0,'Home & Garden Making','','folder.gif','','1',212,'','','0','0','','',0,'',0,0,0,0,0),(335,0,'Home Improvement & Appliances','','folder.gif','','1',58,'','','0','0','','',0,'',0,0,0,0,0),(336,0,'Hotels','','folder.gif','','1',24,'','','0','0','','',0,'',0,0,0,0,0),(337,0,'Insurance Providers','','folder.gif','','1',20,'','','0','0','','',0,'',0,0,0,0,0),(338,0,'Law & Legal','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(339,0,'Lawyers & Attorneys','','folder.gif','','1',137,'','','0','0','','',0,'',0,0,0,0,0),(340,0,'Lifestyle & Society','','folder.gif','','1',8,'','','0','0','','',0,'',0,0,0,0,0),(341,0,'Medicine & Surgery','','folder.gif','','1',5,'','','0','0','','',0,'',0,0,0,0,0),(342,0,'Finance & Investment','','folder.gif','','1',13,'','','0','0','','',0,'',0,0,0,0,0),(343,0,'News & Media','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(344,0,'Plumbing Contractors','','folder.gif','','1',27,'','','0','0','','',0,'',0,0,0,0,0),(345,0,'Real Estate & Property','','folder.gif','','1',28,'','','0','0','','',0,'',0,0,0,0,0),(346,0,'Science','','folder.gif','','1',14,'','','0','0','','',0,'',0,0,0,0,0),(347,0,'SEO & SMO Marketing','','folder.gif','','1',16,'','','0','0','','',0,'',0,0,0,0,0),(348,0,'Shopping and Sales','','folder.gif','','1',59,'','','0','0','','',0,'',0,0,0,0,0),(349,0,'Sports & Recreation','','folder.gif','','1',7,'','','0','0','','',0,'',0,0,0,0,0),(350,0,'Transportation Services','','folder.gif','','1',31,'','','0','0','','',0,'',0,0,0,0,0),(351,0,'Travel & Tour','','folder.gif','','1',23,'','','0','0','','',0,'',0,0,0,0,0),(352,0,'Weddings','','folder.gif','','1',9,'','','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 (318,'Arts & Entertainment','<a href=\"http://stumblesites.org/arts-entertainment/\" name=\"cat_318\" style=\"\">Arts & Entertainment</a>',';0;'),(319,'Automotive','<a href=\"http://stumblesites.org/automotive/\" name=\"cat_319\" style=\"\">Automotive</a>',';0;'),(320,'Business','<a href=\"http://stumblesites.org/business/\" name=\"cat_320\" style=\"\">Business</a>',';0;'),(321,'Careers & Jobs','<a href=\"http://stumblesites.org/careers-jobs/\" name=\"cat_321\" style=\"\">Careers & Jobs</a>',';0;'),(322,'Clothing','<a href=\"http://stumblesites.org/clothing/\" name=\"cat_322\" style=\"\">Clothing</a>',';0;'),(323,'Communications','<a href=\"http://stumblesites.org/communications/\" name=\"cat_323\" style=\"\">Communications</a>',';0;'),(324,'Computer & Internet','<a href=\"http://stumblesites.org/computer-internet/\" name=\"cat_324\" style=\"\">Computer & Internet</a>',';0;'),(325,'Construction Services','<a href=\"http://stumblesites.org/construction-services/\" name=\"cat_325\" style=\"\">Construction Services</a>',';0;'),(326,'Dental Health','<a href=\"http://stumblesites.org/dental-health/\" name=\"cat_326\" style=\"\">Dental Health</a>',';0;'),(327,'Education & Training','<a href=\"http://stumblesites.org/education-training/\" name=\"cat_327\" style=\"\">Education & Training</a>',';0;'),(328,'Employment & Recruitment','<a href=\"http://stumblesites.org/employment-recruitment/\" name=\"cat_328\" style=\"\">Employment & Recruitment</a>',';0;'),(329,'Gifts & Novelties','<a href=\"http://stumblesites.org/gifts-novelties/\" name=\"cat_329\" style=\"\">Gifts & Novelties</a>',';0;'),(330,'Software & Hardware','<a href=\"http://stumblesites.org/software-hardware/\" name=\"cat_330\" style=\"\">Software & Hardware</a>',';0;'),(331,'Health Services','<a href=\"http://stumblesites.org/health-services/\" name=\"cat_331\" style=\"\">Health Services</a>',';0;'),(332,'Healthcare Industry','<a href=\"http://stumblesites.org/healthcare-industry/\" name=\"cat_332\" style=\"\">Healthcare Industry</a>',';0;'),(333,'Heating, Ventilating and Air Conditioning','<a href=\"http://stumblesites.org/heating-ventilating-and-air-conditioning/\" name=\"cat_333\" style=\"\">Heating, Ventilating and Air Conditioning</a>',';0;'),(334,'Home & Garden Making','<a href=\"http://stumblesites.org/home-garden-making/\" name=\"cat_334\" style=\"\">Home & Garden Making</a>',';0;'),(335,'Home Improvement & Appliances','<a href=\"http://stumblesites.org/home-improvement-appliances/\" name=\"cat_335\" style=\"\">Home Improvement & Appliances</a>',';0;'),(336,'Hotels','<a href=\"http://stumblesites.org/hotels/\" name=\"cat_336\" style=\"\">Hotels</a>',';0;'),(337,'Insurance Providers','<a href=\"http://stumblesites.org/insurance-providers/\" name=\"cat_337\" style=\"\">Insurance Providers</a>',';0;'),(338,'Law & Legal','<a href=\"http://stumblesites.org/law-legal/\" name=\"cat_338\" style=\"\">Law & Legal</a>',';0;'),(339,'Lawyers & Attorneys','<a href=\"http://stumblesites.org/lawyers-attorneys/\" name=\"cat_339\" style=\"\">Lawyers & Attorneys</a>',';0;'),(340,'Lifestyle & Society','<a href=\"http://stumblesites.org/lifestyle-society/\" name=\"cat_340\" style=\"\">Lifestyle & Society</a>',';0;'),(341,'Medicine & Surgery','<a href=\"http://stumblesites.org/medicine-surgery/\" name=\"cat_341\" style=\"\">Medicine & Surgery</a>',';0;'),(342,'Finance & Investment','<a href=\"http://stumblesites.org/finance-investment/\" name=\"cat_342\" style=\"\">Finance & Investment</a>',';0;'),(343,'News & Media','<a href=\"http://stumblesites.org/news-media/\" name=\"cat_343\" style=\"\">News & Media</a>',';0;'),(344,'Plumbing Contractors','<a href=\"http://stumblesites.org/plumbing-contractors/\" name=\"cat_344\" style=\"\">Plumbing Contractors</a>',';0;'),(345,'Real Estate & Property','<a href=\"http://stumblesites.org/real-estate-property/\" name=\"cat_345\" style=\"\">Real Estate & Property</a>',';0;'),(346,'Science','<a href=\"http://stumblesites.org/science/\" name=\"cat_346\" style=\"\">Science</a>',';0;'),(347,'SEO & SMO Marketing','<a href=\"http://stumblesites.org/seo-smo-marketing/\" name=\"cat_347\" style=\"\">SEO & SMO Marketing</a>',';0;'),(348,'Shopping and Sales','<a href=\"http://stumblesites.org/shopping-and-sales/\" name=\"cat_348\" style=\"\">Shopping and Sales</a>',';0;'),(349,'Sports & Recreation','<a href=\"http://stumblesites.org/sports-recreation/\" name=\"cat_349\" style=\"\">Sports & Recreation</a>',';0;'),(350,'Transportation Services','<a href=\"http://stumblesites.org/transportation-services/\" name=\"cat_350\" style=\"\">Transportation Services</a>',';0;'),(351,'Travel & Tour','<a href=\"http://stumblesites.org/travel-tour/\" name=\"cat_351\" style=\"\">Travel & Tour</a>',';0;'),(352,'Weddings','<a href=\"http://stumblesites.org/weddings/\" name=\"cat_352\" style=\"\">Weddings</a>',';0;');

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

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

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

INSERT INTO `idx_category_suggession` VALUES (1,0,'Automotive','','2011-06-22 14:57:25'),(2,320,'Garden Grove cab','Garden Grove cab. The Yellow Cab Co. team can offer exceptional medical transportation in Fullerton.\r\n','2012-03-05 20:38:11');

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

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

INSERT INTO `idx_favorites` VALUES (1,'aangeliascott','2011-06-22','My Favorites',NULL),(2,'simonpeterson1','2011-07-04','My Favorites',NULL),(3,'1simonpeterson1','2011-07-04','My Favorites',NULL),(4,'1simonpeterson1','2011-07-04','My Favorites',NULL),(5,'sandesh','2011-07-04','My Favorites',NULL),(6,'rahul','2011-07-04','My Favorites',NULL),(7,'1simonpeterson1','2011-07-04','My Favorites',NULL),(8,'1simonpeterson1','2011-07-04','My Favorites',NULL),(9,'1simonpeterson1','2011-07-04','My Favorites',NULL),(10,'aangeliascott','2011-07-04','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_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`
--

INSERT INTO `idx_link_temp_user` VALUES (5,'aangeliascott');

--
-- 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 (9,'g',0,'2012-02-08'),(7,'g',0,'2011-10-14'),(26,'g',5,'2011-09-07'),(29,'g',3,'2011-09-08'),(4,'g',0,'2012-01-04'),(5,'g',0,'2012-02-23'),(24,'g',0,'2012-02-23'),(13,'g',0,'2012-02-25'),(36,'g',3,'2011-09-22'),(3,'g',0,'2012-02-23'),(20,'g',0,'2011-10-31'),(14,'g',0,'2011-10-30'),(6,'g',0,'2011-11-21'),(21,'g',0,'2011-11-05'),(25,'g',0,'2011-11-05'),(19,'g',0,'2011-12-25'),(15,'g',0,'2011-12-21'),(12,'g',0,'2012-02-23'),(28,'g',6,'2011-09-22'),(17,'g',0,'2011-12-22'),(10,'g',0,'2011-12-17'),(18,'g',0,'2011-12-21'),(31,'g',0,'2011-10-30'),(11,'g',0,'2012-02-23'),(16,'g',0,'2012-02-23'),(27,'g',4,'2011-09-22'),(23,'g',0,'2012-02-23'),(2,'g',3,'2011-09-22'),(33,'g',4,'2011-09-23'),(30,'g',4,'2011-09-23'),(37,'g',3,'2011-09-23'),(38,'g',3,'2011-09-23'),(40,'g',2,'2011-09-23'),(39,'g',0,'2011-09-23'),(35,'g',6,'2011-09-23'),(8,'g',6,'2011-09-23'),(42,'g',0,'2011-09-23'),(41,'g',2,'2011-09-23'),(72,'g',0,'2011-11-09'),(71,'g',0,'2011-11-04'),(75,'g',0,'2012-02-23'),(77,'g',0,'2011-12-17'),(76,'g',0,'2012-02-23'),(73,'g',0,'2012-03-07'),(79,'g',0,'2012-03-07'),(78,'g',0,'2011-12-17'),(74,'g',0,'2012-02-23'),(89,'g',0,'2012-03-03'),(68,'g',0,'2011-12-09'),(90,'g',0,'2011-11-20'),(65,'g',0,'2012-02-23'),(67,'g',0,'2011-11-20'),(70,'g',0,'2012-01-20'),(66,'g',0,'2012-02-23'),(69,'g',0,'2012-02-23'),(106,'g',0,'2011-12-19'),(123,'g',0,'2011-12-24'),(168,'g',3,'2011-10-04'),(159,'g',0,'2012-02-19'),(156,'g',0,'2012-02-19'),(175,'g',3,'2011-10-04'),(62,'g',3,'2011-10-04'),(61,'g',0,'2011-10-04'),(145,'g',0,'2012-02-01'),(172,'g',1,'2011-10-04'),(251,'g',0,'2011-11-20'),(137,'g',0,'2012-03-05'),(183,'g',3,'2011-10-05'),(133,'g',0,'2012-02-23'),(147,'g',0,'2012-02-27'),(148,'g',0,'2012-02-23'),(163,'g',0,'2011-10-06'),(284,'g',0,'2012-02-19'),(277,'g',0,'2012-02-19'),(178,'g',0,'2011-10-06'),(108,'g',0,'2012-02-23'),(98,'g',0,'2012-02-23'),(105,'g',0,'2012-03-07'),(110,'g',0,'2012-03-03'),(184,'g',0,'2011-10-07'),(126,'g',0,'2011-11-19'),(161,'g',0,'2011-12-03'),(169,'g',0,'2011-10-07'),(177,'g',0,'2011-10-07'),(129,'g',0,'2011-11-12'),(153,'g',0,'2011-11-14'),(189,'g',0,'2011-10-08'),(174,'g',0,'2011-10-08'),(158,'g',0,'2012-03-04'),(194,'g',0,'2012-02-25'),(121,'g',0,'2012-02-23'),(124,'g',0,'2012-02-23'),(107,'g',0,'2011-12-22'),(104,'g',0,'2012-02-23'),(102,'g',0,'2012-02-23'),(114,'g',0,'2012-01-21'),(199,'g',0,'2011-10-08'),(109,'g',0,'2012-02-23'),(130,'g',0,'2012-02-23'),(214,'g',0,'2012-02-25'),(115,'g',0,'2012-02-23'),(96,'g',0,'2012-02-23'),(113,'g',0,'2012-03-04'),(134,'g',0,'2012-01-21'),(271,'g',0,'2011-11-19'),(235,'g',0,'2012-03-03'),(179,'g',0,'2011-10-09'),(164,'g',0,'2011-10-09'),(117,'g',0,'2012-02-20'),(286,'g',0,'2011-11-12'),(97,'g',0,'2012-02-20'),(149,'g',0,'2012-02-23'),(103,'g',0,'2011-11-20'),(128,'g',0,'2012-03-07'),(165,'g',0,'2011-10-10'),(287,'g',0,'2011-11-12'),(88,'g',0,'2012-02-20'),(224,'g',0,'2012-01-04'),(127,'g',0,'2012-02-19'),(100,'g',0,'2012-02-20'),(101,'g',0,'2012-01-26'),(144,'g',0,'2012-02-20'),(773,'g',0,'2012-02-21'),(275,'g',0,'2012-02-23'),(95,'g',0,'2011-11-17'),(276,'g',0,'2012-02-23'),(282,'g',0,'2012-02-23'),(234,'g',0,'2012-02-23'),(762,'g',0,'2011-10-16'),(781,'g',0,'2011-10-16'),(764,'g',0,'2011-10-16'),(787,'g',0,'2011-10-16'),(783,'g',0,'2011-10-16'),(845,'g',0,'2011-12-04'),(777,'g',0,'2011-10-16'),(821,'g',0,'2011-12-20'),(772,'g',0,'2011-10-17'),(834,'g',0,'2011-10-19'),(766,'g',0,'2011-10-19'),(801,'g',0,'2012-02-19'),(776,'g',0,'2012-02-09'),(112,'g',0,'2012-03-07'),(261,'g',0,'2011-10-19'),(264,'g',0,'2011-10-19'),(259,'g',0,'2011-12-04'),(793,'g',0,'2012-02-23'),(823,'g',0,'2011-12-17'),(816,'g',0,'2011-11-21'),(775,'g',0,'2011-11-21'),(829,'g',0,'2011-12-22'),(22,'g',0,'2012-02-20'),(195,'g',0,'2012-02-23'),(729,'g',0,'2012-02-11'),(333,'g',0,'2011-12-01'),(724,'g',0,'2011-10-21'),(723,'g',0,'2011-10-21'),(758,'g',0,'2011-11-26'),(826,'g',0,'2011-10-22'),(788,'g',0,'2012-03-03'),(236,'g',0,'2012-03-05'),(803,'g',0,'2012-02-01'),(824,'g',0,'2012-02-23'),(770,'g',0,'2011-11-26'),(822,'g',0,'2012-02-23'),(789,'g',0,'2012-02-27'),(815,'g',0,'2012-03-04'),(761,'g',0,'2011-11-26'),(280,'g',0,'2012-01-22'),(831,'g',0,'2012-02-01'),(811,'g',0,'2012-01-21'),(774,'g',0,'2012-02-23'),(799,'g',0,'2012-03-04'),(827,'g',0,'2011-10-23'),(860,'g',0,'2011-10-23'),(1014,'g',0,'2012-02-23'),(1101,'g',0,'2012-02-23'),(1073,'g',0,'2011-10-23'),(1002,'g',0,'2011-10-23'),(1088,'g',0,'2011-10-23'),(1078,'g',0,'2012-02-23'),(1089,'g',0,'2011-11-28'),(972,'g',0,'2011-12-12'),(965,'g',0,'2011-12-12'),(1032,'g',0,'2012-02-25'),(1035,'g',0,'2012-02-25'),(1056,'g',0,'2012-02-10'),(1013,'g',0,'2011-10-25'),(932,'g',0,'2011-12-14'),(887,'g',0,'2011-10-25'),(807,'g',0,'2011-12-01'),(928,'g',0,'2011-10-25'),(998,'g',0,'2011-10-25'),(921,'g',0,'2011-10-25'),(923,'g',0,'2012-02-23'),(943,'g',0,'2012-02-20'),(809,'g',0,'2011-10-26'),(989,'g',0,'2012-01-21'),(885,'g',0,'2011-10-26'),(922,'g',0,'2012-02-27'),(1054,'g',0,'2012-02-23'),(273,'g',0,'2012-02-28'),(111,'g',0,'2012-02-19'),(80,'g',0,'2012-02-23'),(132,'g',0,'2012-02-23'),(757,'g',0,'2012-02-23'),(143,'g',0,'2012-01-20'),(99,'g',0,'2012-01-20'),(125,'g',0,'2012-02-19'),(119,'g',0,'2012-02-26'),(160,'g',0,'2012-02-24'),(1009,'g',0,'2011-10-26'),(1011,'g',0,'2012-02-19'),(1010,'g',0,'2012-02-19'),(1008,'g',0,'2011-10-26'),(1099,'g',0,'2011-12-22'),(1007,'g',0,'2011-10-26'),(1005,'g',0,'2011-10-26'),(1113,'g',0,'2011-10-26'),(1100,'g',0,'2011-10-26'),(1132,'g',0,'2012-02-19'),(1137,'g',0,'2011-10-26'),(1134,'g',0,'2011-10-26'),(1102,'g',0,'2011-10-26'),(901,'g',0,'2011-12-01'),(81,'g',0,'2012-02-16'),(94,'g',0,'2012-02-22'),(85,'g',0,'2012-02-22'),(86,'g',0,'2012-02-22'),(87,'g',0,'2012-02-22'),(83,'g',0,'2011-10-27'),(84,'g',0,'2012-02-22'),(82,'g',0,'2011-10-27'),(1148,'g',0,'2011-10-27'),(1142,'g',0,'2011-10-27'),(1077,'g',0,'2012-03-04'),(1045,'g',0,'2012-03-04'),(1104,'g',0,'2012-03-04'),(942,'g',0,'2012-02-27'),(937,'g',0,'2012-03-03'),(895,'g',0,'2012-02-27'),(974,'g',0,'2012-02-27'),(1139,'g',0,'2012-02-19'),(1138,'g',0,'2012-02-19'),(897,'g',0,'2011-10-30'),(967,'g',0,'2012-02-23'),(1051,'g',0,'2012-02-23'),(1023,'g',0,'2012-02-23'),(152,'g',0,'2012-02-19'),(1164,'g',0,'2011-11-01'),(1159,'g',0,'2011-11-01'),(915,'g',0,'2012-02-23'),(1112,'g',0,'2011-11-01'),(1040,'g',0,'2011-11-02'),(1001,'g',0,'2012-02-23'),(968,'g',0,'2012-02-23'),(805,'g',0,'2011-11-02'),(1026,'g',0,'2012-02-26'),(1107,'g',0,'2012-02-23'),(992,'g',0,'2012-02-19'),(1070,'g',0,'2012-02-26'),(1160,'g',0,'2012-02-19'),(1156,'g',0,'2012-02-19'),(986,'g',0,'2012-02-23'),(1114,'g',0,'2012-03-04'),(1115,'g',0,'2012-03-04'),(1036,'g',0,'2012-02-01'),(890,'g',0,'2011-11-02'),(1038,'g',0,'2011-11-02'),(1004,'g',0,'2011-11-03'),(1064,'g',0,'2011-11-03'),(196,'g',0,'2012-01-21'),(1133,'g',0,'2011-11-04'),(1003,'g',0,'2011-11-04'),(1042,'g',0,'2012-02-23'),(941,'g',0,'2012-02-23'),(997,'g',0,'2012-01-02'),(1167,'g',0,'2012-02-24'),(281,'g',0,'2011-11-05'),(283,'g',0,'2011-11-05'),(272,'g',0,'2011-11-05'),(274,'g',0,'2011-11-05'),(268,'g',0,'2011-11-05'),(285,'g',0,'2011-11-05'),(279,'g',0,'2011-11-05'),(265,'g',0,'2011-11-05'),(278,'g',0,'2011-11-05'),(269,'g',0,'2011-11-05'),(307,'g',0,'2011-11-05'),(302,'g',0,'2011-11-05'),(306,'g',0,'2011-11-05'),(305,'g',0,'2011-11-05'),(299,'g',0,'2011-11-05'),(303,'g',0,'2011-11-05'),(301,'g',0,'2011-11-05'),(304,'g',0,'2011-11-05'),(300,'g',0,'2011-11-05'),(298,'g',0,'2011-11-05'),(1174,'g',0,'2011-11-07'),(841,'g',0,'2011-11-09'),(849,'g',0,'2011-11-09'),(837,'g',0,'2012-01-25'),(848,'g',0,'2012-02-29'),(850,'g',0,'2012-02-21'),(853,'g',0,'2012-02-21'),(882,'g',0,'2012-02-23'),(983,'g',0,'2012-02-23'),(908,'g',0,'2012-02-23'),(953,'g',0,'2011-11-09'),(879,'g',0,'2012-02-23'),(118,'g',0,'2012-02-22'),(292,'g',0,'2011-11-11'),(288,'g',0,'2011-11-11'),(294,'g',0,'2011-11-11'),(296,'g',0,'2011-11-11'),(291,'g',0,'2011-11-11'),(293,'g',0,'2011-11-11'),(295,'g',0,'2011-11-11'),(297,'g',0,'2011-11-11'),(290,'g',0,'2011-11-11'),(289,'g',0,'2011-11-11'),(847,'g',0,'2011-11-11'),(855,'g',0,'2011-11-11'),(846,'g',0,'2012-02-22'),(1095,'g',0,'2011-11-12'),(1081,'g',0,'2011-11-12'),(1074,'g',0,'2011-11-12'),(1103,'g',0,'2011-11-12'),(1069,'g',0,'2011-11-12'),(1079,'g',0,'2011-11-12'),(1076,'g',0,'2011-11-12'),(1068,'g',0,'2011-11-12'),(1118,'g',0,'2011-11-13'),(862,'g',0,'2011-11-13'),(984,'g',0,'2011-11-13'),(957,'g',0,'2011-11-13'),(1171,'g',0,'2011-11-13'),(839,'g',0,'2011-11-13'),(930,'g',0,'2011-11-13'),(1305,'g',0,'2011-11-13'),(1281,'g',0,'2011-11-13'),(1252,'g',0,'2011-11-13'),(1250,'g',0,'2011-11-13'),(1287,'g',0,'2011-11-13'),(1267,'g',0,'2011-11-13'),(1288,'g',0,'2011-11-13'),(1309,'g',0,'2011-11-13'),(1289,'g',0,'2011-11-13'),(1310,'g',0,'2011-11-13'),(260,'g',0,'2011-11-13'),(336,'g',0,'2011-11-13'),(120,'g',0,'2011-11-13'),(253,'g',0,'2011-11-13'),(252,'g',0,'2011-11-13'),(197,'g',0,'2011-11-13'),(141,'g',0,'2011-11-13'),(893,'g',0,'2011-11-14'),(828,'g',0,'2011-11-14'),(833,'g',0,'2011-11-14'),(795,'g',0,'2011-11-14'),(806,'g',0,'2011-11-14'),(1230,'g',0,'2011-11-14'),(140,'g',0,'2011-11-14'),(266,'g',0,'2011-11-14'),(241,'g',0,'2011-11-14'),(256,'g',0,'2011-11-14'),(135,'g',0,'2011-11-14'),(844,'g',0,'2011-11-14'),(874,'g',0,'2011-12-18'),(899,'g',0,'2011-11-14'),(891,'g',0,'2011-11-14'),(956,'g',0,'2011-11-14'),(1033,'g',0,'2011-11-14'),(978,'g',0,'2011-11-14'),(970,'g',0,'2011-11-14'),(1031,'g',0,'2011-11-14'),(969,'g',0,'2011-11-14'),(961,'g',0,'2011-11-14'),(985,'g',0,'2011-11-14'),(954,'g',0,'2011-11-14'),(982,'g',0,'2011-11-14'),(1047,'g',0,'2011-11-14'),(1049,'g',0,'2011-11-14'),(1061,'g',0,'2011-11-14'),(1158,'g',0,'2011-11-14'),(1050,'g',0,'2011-11-14'),(228,'g',0,'2011-12-20'),(226,'g',0,'2011-12-20'),(245,'g',0,'2011-11-14'),(142,'g',0,'2011-11-14'),(244,'g',0,'2011-11-14'),(338,'g',0,'2011-11-14'),(242,'g',0,'2011-11-14'),(1314,'g',0,'2011-11-14'),(1301,'g',0,'2011-11-14'),(1234,'g',0,'2011-11-14'),(1218,'g',0,'2011-11-14'),(1298,'g',0,'2011-11-14'),(337,'g',0,'2011-11-14'),(1221,'g',0,'2011-11-14'),(238,'g',0,'2011-12-20'),(1282,'g',0,'2011-11-14'),(1284,'g',0,'2011-11-14'),(249,'g',0,'2011-11-14'),(146,'g',0,'2011-11-14'),(193,'g',0,'2011-11-14'),(250,'g',0,'2011-11-14'),(257,'g',0,'2011-11-14'),(222,'g',0,'2011-11-14'),(227,'g',0,'2011-12-20'),(255,'g',0,'2011-11-14'),(232,'g',0,'2011-12-20'),(136,'g',0,'2011-11-14'),(216,'g',0,'2011-11-14'),(229,'g',0,'2011-12-20'),(335,'g',0,'2011-11-14'),(308,'g',0,'2011-11-14'),(116,'g',0,'2012-02-23'),(198,'g',0,'2011-11-14'),(219,'g',0,'2011-11-14'),(215,'g',0,'2011-11-14'),(155,'g',0,'2011-11-14'),(332,'g',0,'2011-11-14'),(246,'g',0,'2011-11-14'),(233,'g',0,'2011-12-20'),(247,'g',0,'2011-11-14'),(239,'g',0,'2011-11-14'),(218,'g',0,'2011-11-14'),(223,'g',0,'2011-11-14'),(243,'g',0,'2011-11-14'),(221,'g',0,'2011-11-14'),(1315,'g',0,'2011-11-14'),(1235,'g',0,'2011-11-14'),(262,'g',0,'2011-11-14'),(254,'g',0,'2011-11-14'),(248,'g',0,'2011-11-14'),(220,'g',0,'2011-11-14'),(263,'g',0,'2011-11-14'),(230,'g',0,'2011-12-20'),(225,'g',0,'2011-12-20'),(231,'g',0,'2011-12-20'),(334,'g',0,'2011-11-14'),(339,'g',0,'2011-11-14'),(810,'g',0,'2011-11-14'),(835,'g',0,'2011-11-14'),(869,'g',0,'2011-11-14'),(935,'g',0,'2011-11-14'),(817,'g',0,'2011-11-14'),(870,'g',0,'2011-11-14'),(792,'g',0,'2011-11-14'),(813,'g',0,'2011-11-14'),(800,'g',0,'2011-11-14'),(796,'g',0,'2011-11-14'),(875,'g',0,'2011-11-14'),(802,'g',0,'2012-02-29'),(791,'g',0,'2011-11-14'),(808,'g',0,'2011-11-14'),(819,'g',0,'2012-01-24'),(906,'g',0,'2011-11-14'),(832,'g',0,'2011-11-14'),(872,'g',0,'2011-11-14'),(309,'g',0,'2011-11-15'),(138,'g',0,'2011-11-15'),(1220,'g',0,'2011-11-15'),(1300,'g',0,'2011-11-15'),(1245,'g',0,'2011-11-15'),(1293,'g',0,'2011-11-15'),(1213,'g',0,'2011-11-15'),(1266,'g',0,'2011-11-15'),(1239,'g',0,'2011-11-15'),(1290,'g',0,'2011-11-15'),(1295,'g',0,'2011-11-15'),(1253,'g',0,'2011-11-15'),(1313,'g',0,'2011-11-15'),(1312,'g',0,'2011-11-15'),(1303,'g',0,'2011-11-15'),(1304,'g',0,'2011-11-15'),(780,'g',0,'2011-11-15'),(894,'g',0,'2011-11-15'),(779,'g',0,'2011-11-15'),(990,'g',0,'2011-11-15'),(768,'g',0,'2011-11-15'),(878,'g',0,'2011-11-15'),(1268,'g',0,'2011-11-15'),(1306,'g',0,'2011-11-15'),(1311,'g',0,'2011-11-15'),(1291,'g',0,'2011-11-15'),(1302,'g',0,'2011-11-15'),(916,'g',0,'2011-11-15'),(863,'g',0,'2011-11-16'),(790,'g',0,'2011-11-16'),(786,'g',0,'2011-11-16'),(782,'g',0,'2011-11-16'),(778,'g',0,'2011-11-16'),(836,'g',0,'2011-11-16'),(798,'g',0,'2011-11-16'),(838,'g',0,'2011-11-16'),(892,'g',0,'2011-12-26'),(931,'g',0,'2011-11-16'),(929,'g',0,'2012-02-14'),(910,'g',0,'2011-12-30'),(907,'g',0,'2011-12-26'),(896,'g',0,'2011-11-16'),(939,'g',0,'2011-11-16'),(914,'g',0,'2011-11-16'),(918,'g',0,'2011-11-16'),(889,'g',0,'2012-02-14'),(1143,'g',0,'2012-02-27'),(1212,'g',0,'2011-11-18'),(1294,'g',0,'2011-11-18'),(1237,'g',0,'2011-11-18'),(1219,'g',0,'2011-11-18'),(1214,'g',0,'2011-11-18'),(1292,'g',0,'2011-11-18'),(1299,'g',0,'2011-11-18'),(1275,'g',0,'2011-11-18'),(1244,'g',0,'2011-11-18'),(1184,'g',0,'2011-11-19'),(1188,'g',0,'2011-11-19'),(1211,'g',0,'2011-11-19'),(1182,'g',0,'2011-11-19'),(258,'g',0,'2011-11-19'),(217,'g',0,'2011-11-19'),(1455,'g',0,'2011-11-19'),(1415,'g',0,'2011-11-19'),(1307,'g',0,'2011-11-20'),(1227,'g',0,'2011-11-20'),(1271,'g',0,'2011-11-20'),(1242,'g',0,'2011-11-20'),(1243,'g',0,'2011-11-20'),(1191,'g',0,'2011-11-20'),(1254,'g',0,'2011-11-20'),(1196,'g',0,'2011-11-20'),(1276,'g',0,'2011-11-20'),(1439,'g',0,'2011-11-21'),(1469,'g',0,'2011-11-21'),(1395,'g',0,'2011-11-21'),(1215,'g',0,'2011-11-21'),(1186,'g',0,'2011-11-21'),(1232,'g',0,'2011-11-21'),(1210,'g',0,'2011-11-21'),(1233,'g',0,'2011-11-21'),(950,'g',0,'2012-02-27'),(964,'g',0,'2011-11-22'),(960,'g',0,'2011-11-22'),(962,'g',0,'2012-02-21'),(963,'g',0,'2011-11-22'),(1388,'g',0,'2011-11-22'),(1377,'g',0,'2011-11-22'),(995,'g',0,'2011-11-23'),(859,'g',0,'2011-11-23'),(873,'g',0,'2011-11-23'),(1006,'g',0,'2011-11-23'),(1043,'g',0,'2011-11-23'),(1096,'g',0,'2011-11-23'),(1028,'g',0,'2011-11-23'),(1071,'g',0,'2011-11-23'),(1025,'g',0,'2011-11-23'),(1030,'g',0,'2011-11-23'),(1075,'g',0,'2011-11-23'),(1027,'g',0,'2011-11-23'),(1044,'g',0,'2011-11-23'),(979,'g',0,'2011-11-23'),(871,'g',0,'2011-11-23'),(958,'g',0,'2011-11-23'),(951,'g',0,'2011-11-23'),(934,'g',0,'2011-11-23'),(888,'g',0,'2011-11-23'),(945,'g',0,'2011-11-23'),(903,'g',0,'2011-11-23'),(1016,'g',0,'2011-11-23'),(1082,'g',0,'2011-11-23'),(1122,'g',0,'2011-11-23'),(1119,'g',0,'2011-11-23'),(1124,'g',0,'2011-11-23'),(1083,'g',0,'2011-11-23'),(1123,'g',0,'2011-11-23'),(1126,'g',0,'2011-11-23'),(1065,'g',0,'2011-11-23'),(1125,'g',0,'2011-11-23'),(1129,'g',0,'2011-11-23'),(1037,'g',0,'2012-02-23'),(1058,'g',0,'2011-11-23'),(1062,'g',0,'2011-11-23'),(1057,'g',0,'2011-11-23'),(1034,'g',0,'2011-11-23'),(1017,'g',0,'2011-11-23'),(1060,'g',0,'2011-11-23'),(1063,'g',0,'2012-02-22'),(1059,'g',0,'2011-11-23'),(1153,'g',0,'2011-11-23'),(1145,'g',0,'2011-11-24'),(1147,'g',0,'2011-11-24'),(1161,'g',0,'2011-11-24'),(1157,'g',0,'2011-11-24'),(1151,'g',0,'2011-11-24'),(1152,'g',0,'2011-11-24'),(1146,'g',0,'2011-11-24'),(1162,'g',0,'2011-11-24'),(1149,'g',0,'2011-11-24'),(1168,'g',0,'2011-11-24'),(1165,'g',0,'2011-11-24'),(1173,'g',0,'2011-11-24'),(1163,'g',0,'2011-11-24'),(1181,'g',0,'2011-11-24'),(1029,'g',0,'2011-11-24'),(1169,'g',0,'2011-11-24'),(1172,'g',0,'2011-11-24'),(1116,'g',0,'2011-11-24'),(1175,'g',0,'2011-11-24'),(1166,'g',0,'2011-11-24'),(1170,'g',0,'2011-11-24'),(1128,'g',0,'2011-11-24'),(1117,'g',0,'2011-11-24'),(1120,'g',0,'2011-11-24'),(1111,'g',0,'2011-11-24'),(1092,'g',0,'2011-11-24'),(1105,'g',0,'2011-11-24'),(1110,'g',0,'2011-11-24'),(1094,'g',0,'2011-11-24'),(1106,'g',0,'2011-11-24'),(1108,'g',0,'2011-11-24'),(1109,'g',0,'2011-11-24'),(1097,'g',0,'2011-11-24'),(1048,'g',0,'2011-11-24'),(1041,'g',0,'2011-11-24'),(1067,'g',0,'2011-11-24'),(966,'g',0,'2011-11-24'),(949,'g',0,'2011-11-24'),(1286,'g',0,'2011-11-24'),(996,'g',0,'2011-11-24'),(1093,'g',0,'2011-11-24'),(1000,'g',0,'2011-11-24'),(1019,'g',0,'2011-11-24'),(1352,'g',0,'2011-11-24'),(1018,'g',0,'2011-11-24'),(1021,'g',0,'2011-11-24'),(1024,'g',0,'2011-11-24'),(1022,'g',0,'2011-11-24'),(1192,'g',0,'2011-11-24'),(1141,'g',0,'2011-11-24'),(1121,'g',0,'2011-11-24'),(1285,'g',0,'2011-11-24'),(1136,'g',0,'2012-02-08'),(1200,'g',0,'2011-11-24'),(1135,'g',0,'2011-11-25'),(1140,'g',0,'2011-11-25'),(1144,'g',0,'2011-11-25'),(1206,'g',0,'2011-11-25'),(1080,'g',0,'2011-11-25'),(1066,'g',0,'2011-11-25'),(1084,'g',0,'2011-11-25'),(1052,'g',0,'2011-11-25'),(1091,'g',0,'2011-11-25'),(1346,'g',0,'2011-11-25'),(1090,'g',0,'2011-11-25'),(1039,'g',0,'2011-11-25'),(1085,'g',0,'2011-11-25'),(1086,'g',0,'2011-11-25'),(1582,'g',0,'2012-02-23'),(1087,'g',0,'2011-11-25'),(1280,'g',0,'2011-11-25'),(1272,'g',0,'2011-11-25'),(1351,'g',0,'2011-11-25'),(1348,'g',0,'2011-11-25'),(804,'g',0,'2011-11-26'),(812,'g',0,'2011-11-26'),(1554,'g',0,'2011-11-26'),(1450,'g',0,'2011-11-26'),(1343,'g',0,'2011-11-26'),(1483,'g',0,'2011-11-26'),(1458,'g',0,'2011-11-26'),(1387,'g',0,'2011-11-26'),(1677,'g',0,'2011-12-27'),(1680,'g',0,'2011-12-27'),(1678,'g',0,'2011-12-27'),(1675,'g',0,'2011-12-27'),(1676,'g',0,'2011-12-27'),(1679,'g',0,'2011-12-27'),(1449,'g',0,'2011-11-27'),(1645,'g',0,'2011-11-27'),(1649,'g',0,'2012-02-23'),(1618,'g',0,'2011-11-27'),(940,'g',0,'2011-11-27'),(944,'g',0,'2011-11-27'),(902,'g',0,'2011-11-27'),(877,'g',0,'2012-03-05'),(763,'g',0,'2011-11-27'),(909,'g',0,'2011-11-27'),(898,'g',0,'2011-11-27'),(865,'g',0,'2011-11-27'),(1247,'g',0,'2011-11-27'),(1246,'g',0,'2011-11-27'),(1222,'g',0,'2011-11-27'),(1264,'g',0,'2011-11-27'),(1248,'g',0,'2011-11-27'),(1231,'g',0,'2011-11-27'),(1262,'g',0,'2011-11-27'),(1226,'g',0,'2011-11-27'),(1608,'g',0,'2012-02-23'),(1562,'g',0,'2011-11-28'),(794,'g',0,'2012-03-07'),(1177,'g',0,'2011-11-29'),(1193,'g',0,'2011-11-29'),(1176,'g',0,'2011-11-29'),(1202,'g',0,'2011-11-29'),(1178,'g',0,'2011-11-29'),(1204,'g',0,'2011-11-29'),(1180,'g',0,'2011-11-29'),(1179,'g',0,'2011-11-29'),(1240,'g',0,'2011-11-29'),(1189,'g',0,'2011-11-29'),(1465,'g',0,'2011-11-30'),(1636,'g',0,'2012-02-23'),(880,'g',0,'2011-12-01'),(346,'g',0,'2011-12-01'),(357,'g',0,'2011-12-01'),(351,'g',0,'2011-12-01'),(354,'g',0,'2011-12-01'),(355,'g',0,'2011-12-01'),(356,'g',0,'2011-12-01'),(350,'g',0,'2011-12-01'),(352,'g',0,'2011-12-01'),(353,'g',0,'2011-12-01'),(767,'g',0,'2011-12-01'),(349,'g',0,'2011-12-01'),(1417,'g',0,'2011-12-03'),(1426,'g',0,'2011-12-03'),(1529,'g',0,'2011-12-03'),(1389,'g',0,'2011-12-03'),(1394,'g',0,'2011-12-03'),(1363,'g',0,'2011-12-03'),(1463,'g',0,'2011-12-03'),(1550,'g',0,'2011-12-03'),(1383,'g',0,'2011-12-03'),(1324,'g',0,'2011-12-03'),(1614,'g',0,'2011-12-03'),(1445,'g',0,'2011-12-03'),(1669,'g',0,'2011-12-03'),(1350,'g',0,'2011-12-04'),(1349,'g',0,'2011-12-04'),(1490,'g',0,'2011-12-04'),(1489,'g',0,'2011-12-04'),(1386,'g',0,'2011-12-04'),(1183,'g',0,'2011-12-08'),(1263,'g',0,'2011-12-08'),(1238,'g',0,'2011-12-09'),(1236,'g',0,'2011-12-09'),(32,'g',0,'2012-02-20'),(1249,'g',0,'2011-12-09'),(1297,'g',0,'2011-12-09'),(1308,'g',0,'2011-12-09'),(1228,'g',0,'2011-12-09'),(122,'g',0,'2012-02-19'),(1296,'g',0,'2011-12-10'),(55,'g',0,'2012-02-20'),(1638,'g',0,'2011-12-10'),(1466,'g',0,'2011-12-10'),(1720,'g',0,'2011-12-10'),(1456,'g',0,'2011-12-10'),(1748,'g',0,'2011-12-10'),(1470,'g',0,'2011-12-10'),(1626,'g',0,'2011-12-10'),(1642,'g',0,'2011-12-10'),(1020,'g',0,'2012-02-20'),(926,'g',0,'2012-02-20'),(358,'g',0,'2011-12-12'),(1771,'g',0,'2012-02-23'),(362,'g',0,'2011-12-13'),(360,'g',0,'2011-12-13'),(359,'g',0,'2011-12-13'),(361,'g',0,'2011-12-13'),(1098,'g',0,'2011-12-13'),(1127,'g',0,'2011-12-13'),(1055,'g',0,'2011-12-13'),(1154,'g',0,'2011-12-13'),(1012,'g',0,'2011-12-13'),(1015,'g',0,'2011-12-13'),(993,'g',0,'2011-12-14'),(1777,'g',0,'2011-12-14'),(1480,'g',0,'2011-12-14'),(1479,'g',0,'2011-12-14'),(1477,'g',0,'2011-12-14'),(1523,'g',0,'2011-12-14'),(1478,'g',0,'2011-12-14'),(1476,'g',0,'2011-12-14'),(1656,'g',0,'2011-12-14'),(267,'g',0,'2011-12-14'),(131,'g',0,'2011-12-14'),(157,'g',0,'2011-12-14'),(139,'g',0,'2011-12-14'),(987,'g',0,'2011-12-15'),(1594,'g',0,'2011-12-15'),(1551,'g',0,'2011-12-15'),(1713,'g',0,'2011-12-15'),(1718,'g',0,'2011-12-15'),(1714,'g',0,'2011-12-15'),(240,'g',0,'2011-12-15'),(154,'g',0,'2011-12-15'),(1717,'g',0,'2011-12-15'),(1712,'g',0,'2011-12-15'),(1710,'g',0,'2011-12-15'),(1641,'g',0,'2011-12-15'),(1665,'g',0,'2012-02-23'),(150,'g',0,'2011-12-15'),(973,'g',0,'2011-12-15'),(1772,'g',0,'2011-12-15'),(1792,'g',0,'2011-12-15'),(1786,'g',0,'2011-12-15'),(1785,'g',0,'2011-12-15'),(1805,'g',0,'2011-12-15'),(1774,'g',0,'2011-12-15'),(1795,'g',0,'2011-12-15'),(1806,'g',0,'2012-02-12'),(1764,'g',0,'2011-12-15'),(1793,'g',0,'2011-12-15'),(977,'g',0,'2011-12-15'),(948,'g',0,'2011-12-15'),(1719,'g',0,'2011-12-15'),(1715,'g',0,'2011-12-15'),(1553,'g',0,'2011-12-15'),(947,'g',0,'2011-12-15'),(1716,'g',0,'2011-12-16'),(151,'g',0,'2011-12-16'),(952,'g',0,'2011-12-16'),(981,'g',0,'2011-12-16'),(1724,'g',0,'2011-12-16'),(1723,'g',0,'2011-12-16'),(1721,'g',0,'2011-12-16'),(1722,'g',0,'2011-12-16'),(1711,'g',0,'2011-12-16'),(237,'g',0,'2011-12-16'),(1725,'g',0,'2011-12-16'),(1670,'g',0,'2011-12-16'),(959,'g',0,'2011-12-16'),(1767,'g',0,'2012-02-23'),(1754,'g',0,'2012-02-23'),(1760,'g',0,'2011-12-17'),(1756,'g',0,'2011-12-17'),(1755,'g',0,'2012-02-23'),(1525,'g',0,'2012-03-04'),(1590,'g',0,'2011-12-17'),(1572,'g',0,'2011-12-17'),(1651,'g',0,'2012-01-24'),(1629,'g',0,'2012-02-23'),(1624,'g',0,'2012-01-24'),(1801,'g',0,'2012-01-21'),(1822,'g',0,'2012-01-21'),(270,'g',0,'2011-12-20'),(1832,'g',0,'2012-02-23'),(1628,'g',0,'2011-12-23'),(1619,'g',0,'2011-12-23'),(1783,'g',0,'2011-12-23'),(1791,'g',0,'2011-12-23'),(1796,'g',0,'2011-12-23'),(1784,'g',0,'2011-12-23'),(1797,'g',0,'2011-12-23'),(1798,'g',0,'2011-12-23'),(1843,'g',0,'2011-12-23'),(1578,'g',0,'2011-12-25'),(1586,'g',0,'2011-12-25'),(1635,'g',0,'2011-12-25'),(1700,'g',0,'2011-12-25'),(1577,'g',0,'2011-12-25'),(1605,'g',0,'2011-12-25'),(1579,'g',0,'2011-12-25'),(1606,'g',0,'2011-12-25'),(1654,'g',0,'2011-12-25'),(1644,'g',0,'2011-12-26'),(1646,'g',0,'2011-12-26'),(1816,'g',0,'2012-02-01'),(1746,'g',0,'2011-12-26'),(1567,'g',0,'2011-12-26'),(1657,'g',0,'2011-12-26'),(1831,'g',0,'2012-02-26'),(1581,'g',0,'2012-02-24'),(1604,'g',0,'2011-12-26'),(1560,'g',0,'2012-02-26'),(1782,'g',0,'2012-02-26'),(1563,'g',0,'2012-02-24'),(1627,'g',0,'2011-12-26'),(1733,'g',0,'2011-12-26'),(1661,'g',0,'2011-12-26'),(1662,'g',0,'2011-12-26'),(868,'g',0,'2012-02-14'),(1759,'g',0,'2011-12-26'),(1737,'g',0,'2011-12-27'),(1818,'g',0,'2011-12-27'),(1808,'g',0,'2012-03-01'),(876,'g',0,'2012-02-14'),(1864,'g',0,'2011-12-29'),(1789,'g',0,'2011-12-29'),(1773,'g',0,'2011-12-29'),(1787,'g',0,'2011-12-30'),(1803,'g',0,'2011-12-30'),(1790,'g',0,'2011-12-30'),(1788,'g',0,'2011-12-30'),(1693,'g',0,'2011-12-30'),(1046,'g',0,'2012-03-01'),(1072,'g',0,'2012-03-05'),(1814,'g',0,'2012-02-01'),(1531,'g',0,'2012-01-01'),(1538,'g',0,'2012-01-02'),(924,'g',0,'2012-02-27'),(905,'g',0,'2012-01-02'),(917,'g',0,'2012-01-02'),(955,'g',0,'2012-01-02'),(976,'g',0,'2012-01-02'),(980,'g',0,'2012-01-02'),(991,'g',0,'2012-01-02'),(971,'g',0,'2012-01-02'),(927,'g',0,'2012-01-02'),(946,'g',0,'2012-01-02'),(988,'g',0,'2012-01-02'),(938,'g',0,'2012-01-02'),(904,'g',0,'2012-01-02'),(671,'g',0,'2012-01-02'),(673,'g',0,'2012-01-02'),(674,'g',0,'2012-01-02'),(911,'g',0,'2012-01-02'),(676,'g',0,'2012-01-02'),(866,'g',0,'2012-01-02'),(864,'g',0,'2012-01-02'),(672,'g',0,'2012-01-02'),(675,'g',0,'2012-01-02'),(925,'g',0,'2012-03-05'),(1528,'g',0,'2012-01-02'),(1532,'g',0,'2012-01-02'),(1493,'g',0,'2012-01-02'),(1481,'g',0,'2012-01-02'),(1543,'g',0,'2012-01-03'),(1547,'g',0,'2012-01-03'),(1847,'g',0,'2012-01-03'),(1807,'g',0,'2012-01-03'),(1819,'g',0,'2012-01-03'),(1487,'g',0,'2012-01-03'),(1923,'g',0,'2012-01-04'),(1926,'g',0,'2012-01-04'),(1933,'g',0,'2012-01-04'),(1937,'g',0,'2012-01-04'),(1941,'g',0,'2012-01-20'),(1921,'g',0,'2012-02-19'),(1929,'g',0,'2012-02-27'),(1852,'g',0,'2012-02-19'),(1668,'g',0,'2012-01-20'),(1695,'g',0,'2012-01-20'),(1688,'g',0,'2012-01-20'),(1685,'g',0,'2012-01-20'),(1729,'g',0,'2012-01-20'),(1736,'g',0,'2012-01-20'),(1652,'g',0,'2012-01-20'),(1672,'g',0,'2012-01-20'),(1738,'g',0,'2012-01-20'),(1623,'g',0,'2012-01-20'),(1934,'g',0,'2012-02-19'),(1892,'g',0,'2012-02-19'),(1726,'g',0,'2012-01-20'),(1898,'g',0,'2012-01-20'),(1850,'g',0,'2012-01-20'),(1925,'g',0,'2012-02-19'),(1932,'g',0,'2012-02-19'),(1930,'g',0,'2012-01-21'),(1530,'g',0,'2012-01-21'),(1691,'g',0,'2012-01-21'),(1673,'g',0,'2012-01-21'),(1800,'g',0,'2012-01-21'),(1741,'g',0,'2012-01-21'),(1707,'g',0,'2012-01-21'),(1863,'g',0,'2012-01-21'),(1935,'g',0,'2012-01-21'),(1936,'g',0,'2012-02-23'),(1928,'g',0,'2012-01-21'),(1931,'g',0,'2012-02-23'),(1927,'g',0,'2012-02-23'),(1924,'g',0,'2012-01-21'),(1942,'g',0,'2012-02-23'),(1922,'g',0,'2012-02-23'),(1882,'g',0,'2012-02-22'),(1944,'g',0,'2012-02-23'),(1938,'g',0,'2012-02-26'),(1891,'g',0,'2012-02-26'),(1894,'g',0,'2012-02-26'),(1908,'g',0,'2012-02-26'),(1896,'g',0,'2012-01-27'),(1877,'g',0,'2012-01-28'),(1901,'g',0,'2012-01-28'),(1866,'g',0,'2012-01-28'),(1840,'g',0,'2012-01-31'),(1834,'g',0,'2012-01-31'),(1835,'g',0,'2012-01-31'),(1853,'g',0,'2012-01-31'),(1844,'g',0,'2012-01-31'),(1838,'g',0,'2012-01-31'),(1841,'g',0,'2012-01-31'),(1836,'g',0,'2012-01-31'),(1845,'g',0,'2012-01-31'),(1833,'g',0,'2012-01-31'),(1918,'g',0,'2012-03-04'),(1912,'g',0,'2012-03-04'),(1867,'g',0,'2012-02-01'),(1956,'g',0,'2012-02-06'),(1561,'g',0,'2012-02-07'),(1593,'g',0,'2012-02-07'),(1984,'g',0,'2012-02-07'),(1556,'g',0,'2012-02-07'),(1584,'g',0,'2012-02-07'),(1634,'g',0,'2012-02-07'),(2001,'g',0,'2012-02-07'),(1830,'g',0,'2012-02-07'),(1815,'g',0,'2012-02-08'),(1998,'g',0,'2012-02-08'),(1976,'g',0,'2012-02-08'),(1960,'g',0,'2012-02-09'),(1653,'g',0,'2012-02-09'),(1660,'g',0,'2012-02-09'),(1501,'g',0,'2012-02-09'),(1498,'g',0,'2012-02-09'),(1999,'g',0,'2012-02-09'),(1667,'g',0,'2012-02-09'),(1495,'g',0,'2012-02-09'),(2036,'g',0,'2012-02-09'),(1502,'g',0,'2012-02-09'),(1504,'g',0,'2012-02-09'),(1988,'g',0,'2012-02-09'),(1499,'g',0,'2012-02-09'),(1503,'g',0,'2012-02-09'),(1497,'g',0,'2012-02-09'),(1500,'g',0,'2012-02-09'),(1496,'g',0,'2012-02-09'),(1687,'g',0,'2012-02-09'),(1750,'g',0,'2012-02-09'),(1987,'g',0,'2012-02-09'),(1959,'g',0,'2012-02-09'),(1953,'g',0,'2012-02-09'),(1958,'g',0,'2012-02-09'),(1966,'g',0,'2012-02-09'),(1973,'g',0,'2012-02-09'),(2038,'g',0,'2012-02-09'),(1986,'g',0,'2012-02-10'),(1494,'g',0,'2012-02-11'),(1821,'g',0,'2012-02-11'),(1820,'g',0,'2012-02-11'),(1881,'g',0,'2012-02-11'),(1739,'g',0,'2012-02-12'),(1544,'g',0,'2012-02-12'),(1575,'g',0,'2012-02-12'),(1874,'g',0,'2012-02-12'),(1727,'g',0,'2012-02-12'),(1752,'g',0,'2012-02-12'),(1848,'g',0,'2012-02-12'),(1888,'g',0,'2012-02-12'),(1839,'g',0,'2012-02-12'),(1817,'g',0,'2012-02-12'),(2056,'g',0,'2012-02-12'),(1974,'g',0,'2012-02-12'),(1647,'g',0,'2012-02-12'),(1753,'g',0,'2012-02-12'),(2008,'g',0,'2012-02-12'),(1823,'g',0,'2012-02-12'),(1842,'g',0,'2012-02-12'),(1961,'g',0,'2012-02-12'),(1946,'g',0,'2012-02-12'),(2037,'g',0,'2012-02-13'),(1996,'g',0,'2012-02-13'),(1962,'g',0,'2012-02-13'),(1778,'g',0,'2012-02-13'),(1740,'g',0,'2012-02-13'),(1541,'g',0,'2012-02-13'),(1620,'g',0,'2012-02-13'),(1607,'g',0,'2012-02-13'),(1491,'g',0,'2012-02-13'),(1492,'g',0,'2012-02-13'),(1488,'g',0,'2012-02-13'),(1486,'g',0,'2012-02-13'),(797,'g',0,'2012-02-13'),(840,'g',0,'2012-02-14'),(884,'g',0,'2012-02-14'),(852,'g',0,'2012-02-14'),(883,'g',0,'2012-02-14'),(857,'g',0,'2012-02-14'),(2059,'g',0,'2012-02-14'),(2058,'g',0,'2012-02-14'),(843,'g',0,'2012-02-14'),(856,'g',0,'2012-02-14'),(842,'g',0,'2012-02-14'),(765,'g',0,'2012-02-14'),(861,'g',0,'2012-02-14'),(867,'g',0,'2012-02-14'),(1914,'g',0,'2012-02-14'),(1997,'g',0,'2012-02-14'),(1979,'g',0,'2012-02-14'),(1990,'g',0,'2012-02-14'),(2009,'g',0,'2012-02-14'),(1989,'g',0,'2012-02-14'),(1545,'g',0,'2012-02-14'),(1546,'g',0,'2012-02-14'),(1548,'g',0,'2012-02-14'),(1519,'g',0,'2012-02-14'),(1520,'g',0,'2012-02-14'),(1557,'g',0,'2012-02-14'),(1515,'g',0,'2012-02-14'),(1507,'g',0,'2012-02-14'),(1516,'g',0,'2012-02-14'),(2015,'g',0,'2012-02-14'),(1506,'g',0,'2012-02-14'),(2042,'g',0,'2012-02-14'),(1505,'g',0,'2012-02-14'),(1517,'g',0,'2012-02-14'),(1509,'g',0,'2012-02-15'),(1508,'g',0,'2012-02-15'),(1518,'g',0,'2012-02-15'),(2032,'g',0,'2012-02-15'),(1809,'g',0,'2012-02-15'),(2031,'g',0,'2012-02-15'),(2035,'g',0,'2012-02-15'),(2041,'g',0,'2012-02-18'),(2055,'g',0,'2012-02-19'),(753,'g',0,'2012-02-19'),(784,'g',0,'2012-02-19'),(2029,'g',0,'2012-02-20'),(752,'g',0,'2012-02-20'),(2004,'g',0,'2012-02-20'),(854,'g',0,'2012-02-20'),(858,'g',0,'2012-02-20'),(785,'g',0,'2012-02-20'),(999,'g',0,'2012-02-20'),(814,'g',0,'2012-02-20'),(830,'g',0,'2012-02-20'),(2026,'g',0,'2012-02-20'),(751,'g',0,'2012-02-20'),(754,'g',0,'2012-02-20'),(820,'g',0,'2012-02-20'),(1985,'g',0,'2012-02-20'),(2030,'g',0,'2012-02-20'),(2057,'g',0,'2012-02-20'),(1878,'g',0,'2012-02-21'),(1879,'g',0,'2012-02-21'),(1886,'g',0,'2012-02-21'),(1887,'g',0,'2012-02-21'),(1858,'g',0,'2012-02-21'),(1854,'g',0,'2012-02-21'),(1873,'g',0,'2012-02-21'),(1890,'g',0,'2012-02-21'),(1856,'g',0,'2012-02-21'),(1855,'g',0,'2012-02-21'),(1893,'g',0,'2012-02-21'),(2054,'g',0,'2012-02-21'),(2044,'g',0,'2012-02-21'),(2048,'g',0,'2012-02-21'),(2063,'g',0,'2012-02-21'),(1857,'g',0,'2012-02-21'),(771,'g',0,'2012-02-21'),(760,'g',0,'2012-02-21'),(1859,'g',0,'2012-02-21'),(1802,'g',0,'2012-02-21'),(755,'g',0,'2012-02-21'),(756,'g',0,'2012-02-21'),(759,'g',0,'2012-02-21'),(1871,'g',0,'2012-02-21'),(1794,'g',0,'2012-02-21'),(975,'g',0,'2012-02-21'),(912,'g',0,'2012-02-21'),(936,'g',0,'2012-02-21'),(933,'g',0,'2012-02-21'),(2061,'g',0,'2012-02-21'),(913,'g',0,'2012-02-21'),(2043,'g',0,'2012-02-21'),(1131,'g',0,'2012-02-21'),(920,'g',0,'2012-02-21'),(1053,'g',0,'2012-02-21'),(1913,'g',0,'2012-02-21'),(1799,'g',0,'2012-02-22'),(1910,'g',0,'2012-02-22'),(1781,'g',0,'2012-02-22'),(1540,'g',0,'2012-02-22'),(1150,'g',0,'2012-02-22'),(1768,'g',0,'2012-02-22'),(1566,'g',0,'2012-02-22'),(1565,'g',0,'2012-02-22'),(1533,'g',0,'2012-02-22'),(1130,'g',0,'2012-02-22'),(681,'g',0,'2012-02-23'),(684,'g',0,'2012-02-23'),(677,'g',0,'2012-02-23'),(1965,'g',0,'2012-02-23'),(682,'g',0,'2012-02-23'),(2052,'g',0,'2012-02-23'),(2046,'g',0,'2012-02-23'),(680,'g',0,'2012-02-23'),(685,'g',0,'2012-02-23'),(679,'g',0,'2012-02-23'),(1909,'g',0,'2012-02-23'),(1155,'g',0,'2012-02-23'),(2053,'g',0,'2012-02-23'),(1920,'g',0,'2012-02-23'),(1911,'g',0,'2012-02-23'),(678,'g',0,'2012-02-24'),(683,'g',0,'2012-02-24'),(1708,'g',0,'2012-02-25'),(1709,'g',0,'2012-02-25'),(1706,'g',0,'2012-02-25'),(2065,'g',0,'2012-02-25'),(900,'g',0,'2012-02-25'),(2049,'g',0,'2012-02-26'),(2070,'g',0,'2012-02-27'),(1824,'g',0,'2012-02-28'),(1475,'g',0,'2012-02-28'),(1780,'g',0,'2012-02-28'),(2062,'g',0,'2012-02-28'),(2077,'g',0,'2012-02-29'),(1804,'g',0,'2012-02-29'),(1770,'g',0,'2012-02-29'),(2080,'g',0,'2012-02-29'),(2066,'g',0,'2012-03-01'),(1621,'g',0,'2012-03-02'),(1603,'g',0,'2012-03-02'),(1734,'g',0,'2012-03-02'),(1549,'g',0,'2012-03-02'),(1571,'g',0,'2012-03-02'),(1779,'g',0,'2012-03-02'),(1569,'g',0,'2012-03-02'),(1511,'g',0,'2012-03-02'),(1482,'g',0,'2012-03-02'),(1513,'g',0,'2012-03-02'),(1580,'g',0,'2012-03-02'),(1564,'g',0,'2012-03-02'),(1576,'g',0,'2012-03-02'),(1510,'g',0,'2012-03-02'),(1522,'g',0,'2012-03-02'),(1512,'g',0,'2012-03-02'),(1514,'g',0,'2012-03-03'),(1775,'g',0,'2012-03-03'),(1769,'g',0,'2012-03-03'),(1744,'g',0,'2012-03-03'),(1484,'g',0,'2012-03-03'),(2094,'g',0,'2012-03-04'),(2104,'g',0,'2012-03-05'),(2123,'g',0,'2012-03-05'),(2118,'g',0,'2012-03-05'),(2092,'g',0,'2012-03-06'),(2117,'g',0,'2012-03-07'),(2105,'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 ('uXZPWdCMFvrKWaUR9dY2ig','q6lxnFgzceeazufMkegsIIrizmW313fPaP2zmNhGSTY','https://api.twitter.com/oauth/authorize','https://api.twitter.com/oauth/access_token');

--
-- 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','STUMBLESITES.ORG'),(5,'site_url','http://stumblesites.org'),(6,'email_address','michael-white71@hotmail.com'),(7,'language_code','en_US'),(8,'theme_path','/home/stumbles/public_html/themes/'),(9,'admin_template_path','/home/stumbles/public_html/admin_tpl/'),(10,'plugin_path','/home/stumbles/public_html/plugin/'),(12,'active_theme','news_portal_new'),(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`
--



