--
-- Host: addsocial.org    Database: addsocia_social
-- ------------------------------------------------------


--
-- 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `menu_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `order_number` int(11) DEFAULT NULL,
  PRIMARY KEY (`menu_id`)
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email` varchar(50) COLLATE utf8_unicode_ci 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=utf8 COLLATE=utf8_unicode_ci;

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


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

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

--
-- 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` enum('domain','ip') COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`blocked_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `image` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8_unicode_ci,
  `visible` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `links` mediumint(9) DEFAULT NULL,
  `meta_keyword` text COLLATE utf8_unicode_ci,
  `meta_description` text COLLATE utf8_unicode_ci,
  `permission` char(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `registered_only` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `header` text COLLATE utf8_unicode_ci NOT NULL,
  `footer` text COLLATE utf8_unicode_ci NOT NULL,
  `related` mediumint(6) NOT NULL DEFAULT '0',
  `page_title` varchar(200) COLLATE utf8_unicode_ci 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=99 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `idx_category` VALUES (97,0,'Travel Industry','','folder.gif','','1',23,'','','1','0','','',0,'',0,0,0,0,0),(92,0,'Energy & Science ','','folder.gif','','1',16,'','','1','0','','',0,'',0,0,0,0,0),(93,0,'SEO ,SMO & PPC','','folder.gif','','1',17,'','','1','0','','',0,'',0,0,0,0,0),(94,0,'Shopping and Retail','','folder.gif','','1',60,'','','1','0','','',0,'',0,0,0,0,0),(95,0,'Recreation & Sports','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(96,0,'Transport & Moving Services ','','folder.gif','','1',41,'','','1','0','','',0,'',0,0,0,0,0),(98,0,'Wedding & Events','','folder.gif','','1',10,'','','1','0','','',0,'',0,0,0,0,0),(64,0,'Arts & Music','','folder.gif','','1',9,'','','1','0','','',0,'',0,0,0,0,0),(65,0,'Auto Industry','','folder.gif','','1',30,'','','1','0','','',0,'',0,0,0,0,0),(66,0,'Economy & Business','','folder.gif','','1',117,'','','1','0','','',0,'',0,0,0,0,0),(67,0,'Careers & Job Search','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(68,0,'Clothing Accessories','','folder.gif','','1',8,'','','1','0','','',0,'',0,0,0,0,0),(69,0,'Communications Services','','folder.gif','','1',15,'','','1','0','','',0,'',0,0,0,0,0),(70,0,'Computer Services','','folder.gif','','1',18,'','','1','0','','',0,'',0,0,0,0,0),(71,0,'Construction and Maintenance','','folder.gif','','1',68,'','','1','0','','',0,'',0,0,0,0,0),(72,0,'Dental Care','','folder.gif','','1',40,'','','0','0','','',0,'',0,0,0,0,0),(73,0,'Education','','folder.gif','','1',24,'','','1','0','','',0,'',0,0,0,0,0),(74,0,'Employment  ','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(75,0,'Gifts','','folder.gif','','1',19,'','','1','0','','',0,'',0,0,0,0,0),(76,0,'Hardware & Software','','folder.gif','','1',9,'','','1','0','','',0,'',0,0,0,0,0),(77,0,'Health & fitness','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(78,0,'Healthcare Management ','','folder.gif','','1',145,'','','1','0','','',0,'',0,0,0,0,0),(79,0,'Heating and Air Conditioning Contractors','','folder.gif','','1',47,'','','1','0','','',0,'',0,0,0,0,0),(80,0,'Home & Family','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(81,0,'Home Improvement & Decor','','folder.gif','','1',281,'','','1','0','','',0,'',0,0,0,0,0),(82,0,'Hotels & Accomadation','','folder.gif','','1',36,'','','1','0','','',0,'',0,0,0,0,0),(83,0,'Insurance Companies','','folder.gif','','1',23,'','','1','0','','',0,'',0,0,0,0,0),(84,0,'Law','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(85,0,'Lawyers & Judges','','folder.gif','','1',150,'','','1','0','','',0,'',0,0,0,0,0),(86,0,'Dating & Relationships ','','folder.gif','','1',7,'','','1','0','','',0,'',0,0,0,0,0),(87,0,'Medicine & Hospitals ','','folder.gif','','1',5,'','','1','0','','',0,'',0,0,0,0,0),(88,0,'Finance & Investment Services','','folder.gif','','1',14,'','','1','0','','',0,'',0,0,0,0,0),(89,0,'News & Magazines','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(90,0,'Plumbing Services','','folder.gif','','1',30,'','','1','0','','',0,'',0,0,0,0,0),(91,0,'Real Estate Development','','folder.gif','','1',31,'','','1','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 COLLATE utf8_unicode_ci,
  `path_with_url` text COLLATE utf8_unicode_ci,
  `parents` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `idx_category_path` VALUES (64,'Arts & Music','<a href=\"http://addsocial.org/arts-music/\" name=\"cat_64\" style=\"\">Arts & Music</a>',';0;'),(65,'Auto Industry','<a href=\"http://addsocial.org/auto-industry/\" name=\"cat_65\" style=\"\">Auto Industry</a>',';0;'),(66,'Economy & Business','<a href=\"http://addsocial.org/economy-business/\" name=\"cat_66\" style=\"\">Economy & Business</a>',';0;'),(67,'Careers & Job Search','<a href=\"http://addsocial.org/careers-job-search/\" name=\"cat_67\" style=\"\">Careers & Job Search</a>',';0;'),(68,'Clothing Accessories','<a href=\"http://addsocial.org/clothing-accessories/\" name=\"cat_68\" style=\"\">Clothing Accessories</a>',';0;'),(69,'Communications Services','<a href=\"http://addsocial.org/communications-services/\" name=\"cat_69\" style=\"\">Communications Services</a>',';0;'),(70,'Computer Services','<a href=\"http://addsocial.org/computer-services/\" name=\"cat_70\" style=\"\">Computer Services</a>',';0;'),(71,'Construction and Maintenance','<a href=\"http://addsocial.org/construction-and-maintenance/\" name=\"cat_71\" style=\"\">Construction and Maintenance</a>',';0;'),(72,'Dental Care','<a href=\"http://addsocial.org/dental-care/\" name=\"cat_72\" style=\"\">Dental Care</a>',';0;'),(73,'Education','<a href=\"http://addsocial.org/education/\" name=\"cat_73\" style=\"\">Education</a>',';0;'),(74,'Employment  ','<a href=\"http://addsocial.org/employment/\" name=\"cat_74\" style=\"\">Employment  </a>',';0;'),(75,'Gifts','<a href=\"http://addsocial.org/gifts/\" name=\"cat_75\" style=\"\">Gifts</a>',';0;'),(76,'Hardware & Software','<a href=\"http://addsocial.org/hardware-software/\" name=\"cat_76\" style=\"\">Hardware & Software</a>',';0;'),(77,'Health & fitness','<a href=\"http://addsocial.org/health-fitness/\" name=\"cat_77\" style=\"\">Health & fitness</a>',';0;'),(78,'Healthcare Management ','<a href=\"http://addsocial.org/healthcare-management/\" name=\"cat_78\" style=\"\">Healthcare Management </a>',';0;'),(79,'Heating and Air Conditioning Contractors','<a href=\"http://addsocial.org/heating-and-air-conditioning-contractors/\" name=\"cat_79\" style=\"\">Heating and Air Conditioning Contractors</a>',';0;'),(80,'Home & Family','<a href=\"http://addsocial.org/home-family/\" name=\"cat_80\" style=\"\">Home & Family</a>',';0;'),(81,'Home Improvement & Decor','<a href=\"http://addsocial.org/home-improvement-decor/\" name=\"cat_81\" style=\"\">Home Improvement & Decor</a>',';0;'),(82,'Hotels & Accomadation','<a href=\"http://addsocial.org/hotels-accomadation/\" name=\"cat_82\" style=\"\">Hotels & Accomadation</a>',';0;'),(83,'Insurance Companies','<a href=\"http://addsocial.org/insurance-companies/\" name=\"cat_83\" style=\"\">Insurance Companies</a>',';0;'),(84,'Law','<a href=\"http://addsocial.org/law/\" name=\"cat_84\" style=\"\">Law</a>',';0;'),(85,'Lawyers & Judges','<a href=\"http://addsocial.org/lawyers-judges/\" name=\"cat_85\" style=\"\">Lawyers & Judges</a>',';0;'),(86,'Dating & Relationships ','<a href=\"http://addsocial.org/dating-relationships/\" name=\"cat_86\" style=\"\">Dating & Relationships </a>',';0;'),(87,'Medicine & Hospitals ','<a href=\"http://addsocial.org/medicine-hospitals/\" name=\"cat_87\" style=\"\">Medicine & Hospitals </a>',';0;'),(88,'Finance & Investment Services','<a href=\"http://addsocial.org/finance-investment-services/\" name=\"cat_88\" style=\"\">Finance & Investment Services</a>',';0;'),(89,'News & Magazines','<a href=\"http://addsocial.org/news-magazines/\" name=\"cat_89\" style=\"\">News & Magazines</a>',';0;'),(90,'Plumbing Services','<a href=\"http://addsocial.org/plumbing-services/\" name=\"cat_90\" style=\"\">Plumbing Services</a>',';0;'),(91,'Real Estate Development','<a href=\"http://addsocial.org/real-estate-development/\" name=\"cat_91\" style=\"\">Real Estate Development</a>',';0;'),(92,'Energy & Science ','<a href=\"http://addsocial.org/energy-science/\" name=\"cat_92\" style=\"\">Energy & Science </a>',';0;'),(93,'SEO ,SMO & PPC','<a href=\"http://addsocial.org/seo-smo-ppc/\" name=\"cat_93\" style=\"\">SEO ,SMO & PPC</a>',';0;'),(94,'Shopping and Retail','<a href=\"http://addsocial.org/shopping-and-retail/\" name=\"cat_94\" style=\"\">Shopping and Retail</a>',';0;'),(95,'Recreation & Sports','<a href=\"http://addsocial.org/recreation-sports/\" name=\"cat_95\" style=\"\">Recreation & Sports</a>',';0;'),(96,'Transport & Moving Services ','<a href=\"http://addsocial.org/transport-moving-services/\" name=\"cat_96\" style=\"\">Transport & Moving Services </a>',';0;'),(97,'Travel Industry','<a href=\"http://addsocial.org/travel-industry/\" name=\"cat_97\" style=\"\">Travel Industry</a>',';0;'),(98,'Wedding & Events','<a href=\"http://addsocial.org/wedding-events/\" name=\"cat_98\" 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `category_description` text COLLATE utf8_unicode_ci,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id_cat_suggession`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `idx_category_suggession` VALUES (1,84,'Carli','That\'s what we\'ve all been waiting for! Great psoitng!','2012-01-16 13:26:07');

--
-- 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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `reciprocal_found` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `schedule` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `time` datetime NOT NULL,
  `execution` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`cronjobs_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `field_text` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `field_type` enum('TEXT','TEXTAREA','SELECT','MULTISELECT','CHECKBOX','RADIO','FILE','IMAGE','DATE','DATETIME','RICHEDITOR') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'TEXT',
  `field_option` text COLLATE utf8_unicode_ci 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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `required` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `searchable` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  `permission` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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) COLLATE utf8_unicode_ci NOT NULL,
  `required` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `visible` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  `searchable` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `coupon_value` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `link_type` varchar(255) COLLATE utf8_unicode_ci 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=utf8 COLLATE=utf8_unicode_ci;

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


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

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

--
-- 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `body` text COLLATE utf8_unicode_ci,
  `altbody` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`email_template_id`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `title` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`favorite_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `idx_favorites` VALUES (1,'aangeliascott','2011-07-25','My Favorites',NULL),(2,'jitender','2011-08-10','My Favorites',NULL),(3,'coreyirvingr23s59','2011-10-18','My Favorites',NULL),(4,'wilberedgarn34h72','2011-10-18','My Favorites',NULL),(5,'martinjosephn13g98','2011-10-19','My Favorites',NULL),(6,'peterquentine16y93','2011-10-19','My Favorites',NULL),(7,'jamiedennyt58l72','2011-10-31','My Favorites',NULL),(8,'salvatorejefw74u80','2011-10-31','My Favorites',NULL),(9,'rudolphsangl95e56','2011-11-01','My Favorites',NULL),(10,'adaptive84','2011-12-07','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=utf8 COLLATE=utf8_unicode_ci;

--
-- 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hookname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`hook_place_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

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

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


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

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

--
-- 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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `idx_link_temp_user` VALUES (10,'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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

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

--
-- 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 COLLATE utf8_unicode_ci,
  `subject` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

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

--
-- 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) COLLATE utf8_unicode_ci 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=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `idx_pagerank` VALUES (1,'g',4,'2011-09-13'),(26,'g',3,'2011-09-13'),(24,'g',6,'2011-09-13'),(7,'g',3,'2011-09-14'),(16,'g',0,'2011-09-14'),(3,'g',2,'2011-09-14'),(11,'g',2,'2011-09-14'),(9,'g',2,'2011-09-14'),(12,'g',3,'2011-09-14'),(25,'g',3,'2011-09-14'),(15,'g',1,'2011-09-14'),(19,'g',3,'2011-09-14'),(21,'g',2,'2011-09-14'),(14,'g',4,'2011-09-14'),(18,'g',3,'2011-09-14'),(17,'g',2,'2011-09-14'),(6,'g',3,'2011-09-14'),(5,'g',2,'2011-09-14'),(23,'g',2,'2011-09-14'),(13,'g',1,'2011-09-14'),(8,'g',3,'2011-09-14'),(2,'g',3,'2011-09-14'),(10,'g',0,'2011-09-14'),(4,'g',3,'2011-09-14'),(20,'g',2,'2011-09-14'),(47,'g',0,'2012-02-21'),(48,'g',0,'2012-02-19'),(31,'g',2,'2011-09-17'),(27,'g',3,'2011-09-17'),(29,'g',2,'2011-09-17'),(33,'g',0,'2011-09-17'),(30,'g',2,'2011-09-17'),(32,'g',2,'2011-09-17'),(28,'g',3,'2011-09-17'),(49,'g',0,'2012-02-21'),(43,'g',0,'2012-02-29'),(51,'g',0,'2012-02-20'),(60,'g',0,'2012-01-23'),(41,'g',0,'2012-02-29'),(54,'g',0,'2012-03-06'),(42,'g',0,'2012-02-28'),(55,'g',0,'2012-03-01'),(46,'g',0,'2012-01-23'),(52,'g',0,'2012-02-20'),(39,'g',3,'2011-09-18'),(45,'g',0,'2012-02-29'),(22,'g',1,'2011-09-21'),(59,'g',0,'2012-01-25'),(50,'g',0,'2012-01-07'),(57,'g',0,'2012-01-15'),(53,'g',0,'2012-02-21'),(58,'g',0,'2012-02-21'),(62,'g',6,'2011-09-26'),(36,'g',6,'2011-09-26'),(38,'g',1,'2011-09-26'),(34,'g',2,'2011-09-26'),(37,'g',2,'2011-09-26'),(35,'g',2,'2011-09-26'),(56,'g',0,'2012-02-06'),(63,'g',0,'2011-10-06'),(61,'g',0,'2012-02-20'),(40,'g',0,'2012-02-21'),(94,'g',0,'2012-02-21'),(73,'g',0,'2012-02-21'),(70,'g',0,'2011-11-13'),(584,'g',0,'2012-02-29'),(236,'g',0,'2012-02-21'),(574,'g',0,'2012-02-29'),(585,'g',0,'2012-02-28'),(246,'g',0,'2012-02-29'),(133,'g',0,'2012-02-28'),(180,'g',0,'2011-11-13'),(313,'g',0,'2012-02-20'),(451,'g',0,'2012-02-21'),(256,'g',0,'2012-02-28'),(253,'g',0,'2012-02-29'),(438,'g',0,'2011-11-13'),(259,'g',0,'2012-02-21'),(243,'g',0,'2012-02-21'),(638,'g',0,'2011-11-14'),(834,'g',0,'2011-11-14'),(827,'g',0,'2012-01-11'),(698,'g',0,'2011-11-14'),(571,'g',0,'2012-01-11'),(292,'g',0,'2012-02-21'),(289,'g',0,'2011-11-14'),(444,'g',0,'2012-02-21'),(487,'g',0,'2012-02-21'),(532,'g',0,'2011-11-14'),(447,'g',0,'2012-02-21'),(562,'g',0,'2012-02-21'),(192,'g',0,'2012-02-13'),(344,'g',0,'2012-02-13'),(263,'g',0,'2012-02-13'),(466,'g',0,'2012-02-15'),(521,'g',0,'2012-02-15'),(516,'g',0,'2012-02-13'),(262,'g',0,'2012-02-13'),(307,'g',0,'2011-11-14'),(338,'g',0,'2012-02-13'),(157,'g',0,'2011-11-14'),(136,'g',0,'2011-11-14'),(144,'g',0,'2012-02-25'),(111,'g',0,'2012-02-21'),(71,'g',0,'2012-02-08'),(635,'g',0,'2012-02-16'),(581,'g',0,'2012-01-23'),(820,'g',0,'2012-02-21'),(226,'g',0,'2011-11-14'),(106,'g',0,'2011-12-16'),(622,'g',0,'2012-02-16'),(753,'g',0,'2011-11-14'),(154,'g',0,'2011-11-14'),(114,'g',0,'2012-02-29'),(162,'g',0,'2012-01-10'),(194,'g',0,'2011-11-14'),(142,'g',0,'2011-11-14'),(155,'g',0,'2012-02-21'),(507,'g',0,'2012-02-21'),(129,'g',0,'2012-01-06'),(220,'g',0,'2012-02-20'),(139,'g',0,'2011-11-14'),(197,'g',0,'2011-11-14'),(131,'g',0,'2012-03-02'),(119,'g',0,'2012-02-21'),(68,'g',0,'2012-01-21'),(134,'g',0,'2012-02-19'),(112,'g',0,'2011-12-15'),(331,'g',0,'2011-12-15'),(835,'g',0,'2011-12-19'),(153,'g',0,'2011-11-14'),(546,'g',0,'2011-12-19'),(109,'g',0,'2011-12-14'),(511,'g',0,'2012-02-21'),(156,'g',0,'2012-02-19'),(258,'g',0,'2012-02-22'),(239,'g',0,'2011-11-14'),(160,'g',0,'2011-11-14'),(705,'g',0,'2012-01-23'),(128,'g',0,'2012-02-21'),(500,'g',0,'2011-11-14'),(268,'g',0,'2011-11-14'),(126,'g',0,'2012-01-06'),(107,'g',0,'2012-01-06'),(193,'g',0,'2011-11-14'),(625,'g',0,'2012-01-23'),(218,'g',0,'2011-11-14'),(159,'g',0,'2011-11-14'),(480,'g',0,'2012-01-10'),(182,'g',0,'2012-02-28'),(96,'g',0,'2011-12-16'),(471,'g',0,'2012-02-22'),(168,'g',0,'2011-12-16'),(75,'g',0,'2011-11-14'),(164,'g',0,'2012-01-21'),(108,'g',0,'2011-12-15'),(445,'g',0,'2011-11-14'),(345,'g',0,'2011-11-14'),(707,'g',0,'2012-01-23'),(148,'g',0,'2011-11-14'),(456,'g',0,'2012-02-21'),(674,'g',0,'2012-02-16'),(473,'g',0,'2011-11-14'),(804,'g',0,'2011-11-14'),(712,'g',0,'2012-02-21'),(223,'g',0,'2012-01-21'),(733,'g',0,'2012-03-05'),(732,'g',0,'2011-12-16'),(116,'g',0,'2012-02-21'),(120,'g',0,'2012-02-21'),(716,'g',0,'2011-11-14'),(737,'g',0,'2011-12-16'),(124,'g',0,'2012-02-21'),(693,'g',0,'2011-11-14'),(735,'g',0,'2011-11-14'),(730,'g',0,'2011-11-14'),(734,'g',0,'2012-03-05'),(731,'g',0,'2011-11-14'),(443,'g',0,'2012-02-21'),(130,'g',0,'2011-12-16'),(678,'g',0,'2011-11-14'),(101,'g',0,'2011-11-14'),(463,'g',0,'2011-11-14'),(341,'g',0,'2012-02-13'),(74,'g',0,'2012-01-10'),(163,'g',0,'2012-02-21'),(95,'g',0,'2011-11-15'),(234,'g',0,'2012-02-21'),(298,'g',0,'2012-02-21'),(462,'g',0,'2011-11-15'),(241,'g',0,'2012-02-21'),(288,'g',0,'2012-02-21'),(191,'g',0,'2012-02-21'),(235,'g',0,'2012-02-21'),(440,'g',0,'2012-02-21'),(434,'g',0,'2012-02-21'),(315,'g',0,'2012-02-13'),(470,'g',0,'2012-01-17'),(624,'g',0,'2012-02-14'),(304,'g',0,'2012-02-21'),(683,'g',0,'2012-02-21'),(522,'g',0,'2011-11-15'),(110,'g',0,'2012-02-20'),(72,'g',0,'2011-12-16'),(715,'g',0,'2012-01-12'),(706,'g',0,'2012-02-07'),(98,'g',0,'2012-03-06'),(299,'g',0,'2011-11-15'),(117,'g',0,'2012-02-19'),(448,'g',0,'2012-01-19'),(454,'g',0,'2011-12-16'),(568,'g',0,'2011-11-15'),(125,'g',0,'2012-02-20'),(275,'g',0,'2012-02-21'),(99,'g',0,'2012-02-13'),(494,'g',0,'2012-01-12'),(113,'g',0,'2012-02-21'),(121,'g',0,'2012-03-06'),(302,'g',0,'2012-02-21'),(161,'g',0,'2012-02-13'),(138,'g',0,'2011-11-15'),(830,'g',0,'2012-02-13'),(501,'g',0,'2012-02-21'),(681,'g',0,'2012-02-21'),(340,'g',0,'2012-01-17'),(115,'g',0,'2012-03-06'),(230,'g',0,'2012-01-12'),(150,'g',0,'2011-12-16'),(669,'g',0,'2012-02-07'),(502,'g',0,'2011-11-15'),(270,'g',0,'2012-02-07'),(741,'g',0,'2012-02-13'),(648,'g',0,'2012-02-13'),(92,'g',0,'2012-02-21'),(279,'g',0,'2012-02-21'),(801,'g',0,'2012-02-13'),(742,'g',0,'2012-02-13'),(244,'g',0,'2012-02-07'),(452,'g',0,'2012-02-08'),(100,'g',0,'2012-02-07'),(97,'g',0,'2012-02-21'),(93,'g',0,'2011-12-16'),(132,'g',0,'2011-11-16'),(152,'g',0,'2012-02-21'),(149,'g',0,'2011-11-16'),(102,'g',0,'2012-02-21'),(151,'g',0,'2011-11-16'),(122,'g',0,'2011-11-17'),(103,'g',0,'2012-01-21'),(127,'g',0,'2012-02-20'),(343,'g',0,'2012-02-20'),(323,'g',0,'2012-02-20'),(632,'g',0,'2012-02-20'),(504,'g',0,'2012-02-20'),(484,'g',0,'2012-02-20'),(118,'g',0,'2012-02-21'),(505,'g',0,'2012-02-20'),(503,'g',0,'2012-02-20'),(476,'g',0,'2012-02-20'),(766,'g',0,'2012-02-21'),(286,'g',0,'2012-02-27'),(294,'g',0,'2012-02-21'),(664,'g',0,'2012-02-27'),(199,'g',0,'2012-02-21'),(711,'g',0,'2012-02-21'),(67,'g',0,'2012-02-21'),(91,'g',0,'2012-02-29'),(69,'g',0,'2012-02-21'),(104,'g',0,'2012-02-21'),(166,'g',0,'2012-02-21'),(137,'g',0,'2012-03-06'),(123,'g',0,'2012-02-19'),(450,'g',0,'2012-02-19'),(297,'g',0,'2012-02-21'),(553,'g',0,'2012-02-28'),(823,'g',0,'2011-11-20'),(843,'g',0,'2011-11-20'),(771,'g',0,'2012-02-21'),(852,'g',0,'2011-11-21'),(657,'g',0,'2011-11-21'),(453,'g',0,'2011-11-21'),(467,'g',0,'2012-02-21'),(449,'g',0,'2012-02-21'),(458,'g',0,'2011-11-21'),(526,'g',0,'2011-11-21'),(612,'g',0,'2011-11-21'),(229,'g',0,'2011-11-21'),(573,'g',0,'2011-11-21'),(441,'g',0,'2011-11-21'),(704,'g',0,'2012-02-21'),(665,'g',0,'2012-02-21'),(826,'g',0,'2012-02-21'),(844,'g',0,'2012-02-21'),(560,'g',0,'2011-11-21'),(572,'g',0,'2011-11-21'),(800,'g',0,'2012-03-05'),(673,'g',0,'2011-11-21'),(531,'g',0,'2011-11-21'),(675,'g',0,'2011-11-21'),(510,'g',0,'2011-11-21'),(754,'g',0,'2012-03-05'),(489,'g',0,'2011-11-21'),(759,'g',0,'2011-11-21'),(556,'g',0,'2011-11-21'),(493,'g',0,'2011-11-21'),(850,'g',0,'2011-11-21'),(527,'g',0,'2011-11-21'),(651,'g',0,'2011-11-21'),(739,'g',0,'2012-03-05'),(552,'g',0,'2011-11-21'),(425,'g',0,'2012-02-21'),(497,'g',0,'2011-11-21'),(284,'g',0,'2011-11-21'),(431,'g',0,'2011-11-21'),(677,'g',0,'2011-11-21'),(446,'g',0,'2011-11-21'),(747,'g',0,'2012-03-05'),(817,'g',0,'2011-11-21'),(803,'g',0,'2011-11-21'),(600,'g',0,'2011-11-21'),(602,'g',0,'2011-11-21'),(461,'g',0,'2011-11-21'),(472,'g',0,'2011-11-21'),(807,'g',0,'2012-03-05'),(566,'g',0,'2011-11-21'),(806,'g',0,'2011-11-21'),(538,'g',0,'2011-11-21'),(432,'g',0,'2011-11-21'),(767,'g',0,'2011-11-21'),(518,'g',0,'2011-11-21'),(851,'g',0,'2012-03-03'),(508,'g',0,'2011-11-21'),(232,'g',0,'2011-11-21'),(486,'g',0,'2011-11-21'),(758,'g',0,'2011-11-21'),(825,'g',0,'2012-02-21'),(459,'g',0,'2012-01-17'),(650,'g',0,'2012-01-17'),(317,'g',0,'2012-01-17'),(839,'g',0,'2012-01-17'),(691,'g',0,'2012-01-17'),(348,'g',0,'2012-01-17'),(865,'g',0,'2011-11-22'),(821,'g',0,'2012-01-17'),(583,'g',0,'2011-11-22'),(623,'g',0,'2012-01-17'),(603,'g',0,'2011-11-22'),(563,'g',0,'2012-02-29'),(617,'g',0,'2011-11-22'),(808,'g',0,'2011-11-22'),(536,'g',0,'2012-02-29'),(719,'g',0,'2011-11-22'),(663,'g',0,'2011-11-22'),(718,'g',0,'2011-11-22'),(703,'g',0,'2011-11-22'),(702,'g',0,'2011-11-22'),(797,'g',0,'2011-11-22'),(847,'g',0,'2011-11-22'),(639,'g',0,'2011-11-22'),(765,'g',0,'2011-11-22'),(841,'g',0,'2011-11-22'),(578,'g',0,'2011-11-22'),(469,'g',0,'2011-11-22'),(701,'g',0,'2011-11-22'),(709,'g',0,'2011-11-22'),(662,'g',0,'2011-11-22'),(215,'g',0,'2011-11-22'),(225,'g',0,'2011-11-22'),(145,'g',0,'2011-11-22'),(533,'g',0,'2012-02-29'),(477,'g',0,'2011-11-22'),(671,'g',0,'2011-11-22'),(442,'g',0,'2011-11-22'),(609,'g',0,'2011-11-22'),(659,'g',0,'2011-11-22'),(519,'g',0,'2011-11-22'),(488,'g',0,'2011-11-22'),(540,'g',0,'2011-11-22'),(523,'g',0,'2011-11-22'),(429,'g',0,'2011-11-22'),(781,'g',0,'2011-11-22'),(684,'g',0,'2012-02-21'),(495,'g',0,'2011-11-22'),(655,'g',0,'2012-03-03'),(569,'g',0,'2011-11-22'),(654,'g',0,'2011-11-22'),(757,'g',0,'2011-11-22'),(784,'g',0,'2011-11-22'),(794,'g',0,'2011-11-22'),(762,'g',0,'2011-11-22'),(537,'g',0,'2012-02-21'),(687,'g',0,'2011-11-22'),(792,'g',0,'2011-11-22'),(723,'g',0,'2011-11-22'),(782,'g',0,'2011-11-22'),(745,'g',0,'2011-11-22'),(692,'g',0,'2011-11-22'),(728,'g',0,'2011-11-22'),(769,'g',0,'2011-11-22'),(653,'g',0,'2012-02-21'),(722,'g',0,'2011-11-22'),(577,'g',0,'2012-02-21'),(594,'g',0,'2012-02-21'),(785,'g',0,'2011-11-22'),(770,'g',0,'2011-11-22'),(641,'g',0,'2012-02-21'),(311,'g',0,'2011-11-22'),(601,'g',0,'2011-11-22'),(618,'g',0,'2011-11-22'),(326,'g',0,'2011-11-22'),(710,'g',0,'2011-11-22'),(611,'g',0,'2011-11-22'),(694,'g',0,'2011-11-22'),(631,'g',0,'2011-11-22'),(660,'g',0,'2011-11-22'),(481,'g',0,'2011-11-22'),(787,'g',0,'2011-11-22'),(810,'g',0,'2011-11-22'),(695,'g',0,'2011-11-22'),(599,'g',0,'2012-03-01'),(637,'g',0,'2011-11-22'),(846,'g',0,'2011-11-22'),(509,'g',0,'2012-02-29'),(829,'g',0,'2011-11-22'),(350,'g',0,'2012-02-28'),(672,'g',0,'2011-11-22'),(309,'g',0,'2011-11-22'),(140,'g',0,'2011-11-22'),(688,'g',0,'2011-11-22'),(296,'g',0,'2011-11-22'),(535,'g',0,'2011-11-22'),(760,'g',0,'2011-11-22'),(548,'g',0,'2011-11-22'),(824,'g',0,'2011-11-22'),(564,'g',0,'2011-11-22'),(686,'g',0,'2011-11-22'),(772,'g',0,'2011-11-22'),(725,'g',0,'2011-11-22'),(646,'g',0,'2012-02-21'),(848,'g',0,'2011-11-22'),(774,'g',0,'2011-11-22'),(795,'g',0,'2011-11-22'),(629,'g',0,'2011-11-22'),(833,'g',0,'2011-11-22'),(726,'g',0,'2011-11-22'),(598,'g',0,'2012-02-21'),(592,'g',0,'2011-11-22'),(837,'g',0,'2011-11-22'),(838,'g',0,'2011-11-22'),(615,'g',0,'2012-02-21'),(634,'g',0,'2011-11-22'),(628,'g',0,'2012-02-28'),(842,'g',0,'2011-11-22'),(528,'g',0,'2011-11-22'),(658,'g',0,'2011-11-22'),(736,'g',0,'2011-11-22'),(273,'g',0,'2011-11-22'),(630,'g',0,'2011-11-22'),(667,'g',0,'2011-11-22'),(819,'g',0,'2011-11-22'),(545,'g',0,'2011-11-22'),(697,'g',0,'2011-11-22'),(291,'g',0,'2011-11-22'),(437,'g',0,'2011-11-22'),(714,'g',0,'2011-11-22'),(281,'g',0,'2011-11-22'),(274,'g',0,'2011-11-22'),(231,'g',0,'2011-11-22'),(248,'g',0,'2011-11-22'),(146,'g',0,'2012-03-04'),(185,'g',0,'2012-02-21'),(269,'g',0,'2011-11-22'),(308,'g',0,'2011-11-22'),(310,'g',0,'2011-11-22'),(254,'g',0,'2011-11-22'),(290,'g',0,'2011-11-22'),(207,'g',0,'2011-11-22'),(276,'g',0,'2011-11-22'),(179,'g',0,'2012-02-21'),(213,'g',0,'2011-11-22'),(233,'g',0,'2011-11-22'),(141,'g',0,'2011-11-22'),(278,'g',0,'2011-11-22'),(277,'g',0,'2011-11-22'),(295,'g',0,'2011-11-22'),(158,'g',0,'2011-11-22'),(245,'g',0,'2012-02-24'),(224,'g',0,'2011-11-22'),(271,'g',0,'2011-11-22'),(250,'g',0,'2011-11-22'),(209,'g',0,'2011-11-22'),(287,'g',0,'2012-03-04'),(203,'g',0,'2011-11-22'),(208,'g',0,'2011-11-22'),(261,'g',0,'2011-11-22'),(265,'g',0,'2011-11-22'),(237,'g',0,'2011-11-22'),(222,'g',0,'2011-11-22'),(242,'g',0,'2011-11-22'),(181,'g',0,'2012-02-21'),(189,'g',0,'2011-11-22'),(205,'g',0,'2012-03-03'),(186,'g',0,'2011-11-22'),(143,'g',0,'2011-11-22'),(170,'g',0,'2011-11-22'),(206,'g',0,'2011-11-22'),(221,'g',0,'2011-11-22'),(169,'g',0,'2011-11-22'),(174,'g',0,'2012-02-21'),(283,'g',0,'2011-11-22'),(210,'g',0,'2012-02-21'),(184,'g',0,'2012-02-21'),(165,'g',0,'2011-11-22'),(183,'g',0,'2012-02-21'),(176,'g',0,'2012-02-21'),(280,'g',0,'2011-11-22'),(147,'g',0,'2011-11-22'),(216,'g',0,'2011-11-22'),(318,'g',0,'2011-11-22'),(365,'g',0,'2011-11-22'),(204,'g',0,'2011-11-22'),(339,'g',0,'2011-11-22'),(366,'g',0,'2012-02-25'),(322,'g',0,'2011-11-22'),(337,'g',0,'2011-11-22'),(359,'g',0,'2011-11-22'),(361,'g',0,'2011-11-22'),(321,'g',0,'2011-11-22'),(325,'g',0,'2011-11-22'),(367,'g',0,'2011-11-22'),(426,'g',0,'2012-02-28'),(363,'g',0,'2011-11-22'),(642,'g',0,'2011-11-22'),(640,'g',0,'2012-02-28'),(333,'g',0,'2011-11-22'),(349,'g',0,'2011-11-22'),(330,'g',0,'2011-11-22'),(353,'g',0,'2011-11-22'),(845,'g',0,'2011-11-22'),(557,'g',0,'2011-11-22'),(643,'g',0,'2011-11-22'),(549,'g',0,'2011-11-22'),(666,'g',0,'2011-11-22'),(135,'g',0,'2011-11-22'),(721,'g',0,'2012-03-06'),(793,'g',0,'2011-11-22'),(561,'g',0,'2011-11-22'),(685,'g',0,'2011-11-22'),(690,'g',0,'2011-11-22'),(720,'g',0,'2011-11-22'),(764,'g',0,'2011-11-22'),(689,'g',0,'2011-11-22'),(775,'g',0,'2011-11-22'),(779,'g',0,'2011-11-22'),(780,'g',0,'2011-11-22'),(724,'g',0,'2011-11-22'),(773,'g',0,'2011-11-22'),(319,'g',0,'2011-11-22'),(579,'g',0,'2011-11-22'),(768,'g',0,'2011-11-22'),(593,'g',0,'2011-11-22'),(575,'g',0,'2011-11-22'),(696,'g',0,'2011-11-22'),(435,'g',0,'2011-11-22'),(790,'g',0,'2011-11-22'),(798,'g',0,'2011-11-22'),(786,'g',0,'2011-11-22'),(717,'g',0,'2011-11-22'),(614,'g',0,'2011-11-22'),(613,'g',0,'2011-11-22'),(788,'g',0,'2011-11-22'),(832,'g',0,'2011-11-22'),(763,'g',0,'2011-11-22'),(282,'g',0,'2011-11-22'),(789,'g',0,'2011-11-22'),(300,'g',0,'2011-11-22'),(636,'g',0,'2012-02-24'),(595,'g',0,'2011-11-22'),(761,'g',0,'2011-11-22'),(217,'g',0,'2011-11-22'),(305,'g',0,'2011-11-22'),(240,'g',0,'2011-11-22'),(172,'g',0,'2011-11-22'),(514,'g',0,'2011-11-22'),(227,'g',0,'2011-11-22'),(219,'g',0,'2011-11-22'),(247,'g',0,'2011-11-22'),(257,'g',0,'2011-11-22'),(175,'g',0,'2012-02-21'),(238,'g',0,'2012-02-29'),(633,'g',0,'2011-11-22'),(840,'g',0,'2011-11-22'),(188,'g',0,'2011-11-22'),(202,'g',0,'2012-02-25'),(211,'g',0,'2011-11-22'),(171,'g',0,'2011-11-22'),(190,'g',0,'2011-11-22'),(272,'g',0,'2011-11-22'),(177,'g',0,'2012-02-21'),(264,'g',0,'2011-11-22'),(173,'g',0,'2011-11-22'),(201,'g',0,'2011-11-22'),(178,'g',0,'2012-02-21'),(187,'g',0,'2011-11-22'),(293,'g',0,'2012-02-21'),(196,'g',0,'2011-11-22'),(255,'g',0,'2011-11-22'),(200,'g',0,'2011-11-22'),(249,'g',0,'2011-11-22'),(214,'g',0,'2011-11-22'),(303,'g',0,'2011-11-22'),(267,'g',0,'2011-11-22'),(320,'g',0,'2011-11-22'),(352,'g',0,'2011-11-22'),(355,'g',0,'2011-11-22'),(314,'g',0,'2011-11-22'),(335,'g',0,'2011-11-22'),(354,'g',0,'2011-11-22'),(356,'g',0,'2012-03-06'),(336,'g',0,'2012-03-04'),(342,'g',0,'2011-11-22'),(351,'g',0,'2011-11-22'),(328,'g',0,'2011-11-22'),(316,'g',0,'2011-11-22'),(362,'g',0,'2011-11-22'),(364,'g',0,'2011-11-22'),(329,'g',0,'2011-11-22'),(332,'g',0,'2011-11-22'),(346,'g',0,'2011-11-22'),(357,'g',0,'2011-11-22'),(324,'g',0,'2011-11-22'),(360,'g',0,'2011-11-22'),(605,'g',0,'2011-11-22'),(590,'g',0,'2012-03-02'),(475,'g',0,'2012-02-21'),(626,'g',0,'2011-11-22'),(668,'g',0,'2011-11-22'),(530,'g',0,'2012-02-21'),(744,'g',0,'2011-11-23'),(815,'g',0,'2011-11-23'),(588,'g',0,'2011-11-23'),(809,'g',0,'2011-11-23'),(645,'g',0,'2011-11-23'),(198,'g',0,'2011-11-23'),(498,'g',0,'2011-11-23'),(783,'g',0,'2011-11-23'),(700,'g',0,'2011-11-23'),(776,'g',0,'2011-11-23'),(670,'g',0,'2011-11-23'),(791,'g',0,'2011-11-23'),(796,'g',0,'2011-11-23'),(777,'g',0,'2011-11-23'),(818,'g',0,'2011-11-23'),(485,'g',0,'2011-11-23'),(597,'g',0,'2011-11-23'),(347,'g',0,'2011-11-23'),(713,'g',0,'2011-11-23'),(828,'g',0,'2011-11-23'),(260,'g',0,'2011-11-23'),(251,'g',0,'2011-11-23'),(212,'g',0,'2011-11-23'),(306,'g',0,'2011-11-23'),(195,'g',0,'2012-02-28'),(228,'g',0,'2011-11-23'),(301,'g',0,'2011-11-23'),(312,'g',0,'2011-11-23'),(334,'g',0,'2011-11-23'),(327,'g',0,'2011-11-23'),(358,'g',0,'2011-11-23'),(589,'g',0,'2011-11-23'),(738,'g',0,'2011-11-23'),(582,'g',0,'2011-11-23'),(740,'g',0,'2011-11-23'),(587,'g',0,'2011-11-23'),(656,'g',0,'2011-11-23'),(822,'g',0,'2011-11-23'),(708,'g',0,'2011-11-23'),(591,'g',0,'2011-11-23'),(749,'g',0,'2011-11-23'),(586,'g',0,'2012-02-21'),(750,'g',0,'2011-11-23'),(699,'g',0,'2011-11-23'),(652,'g',0,'2011-11-23'),(520,'g',0,'2012-02-21'),(620,'g',0,'2011-11-23'),(576,'g',0,'2012-02-21'),(778,'g',0,'2011-11-23'),(474,'g',0,'2011-11-23'),(893,'g',0,'2011-11-23'),(898,'g',0,'2011-11-23'),(900,'g',0,'2011-11-23'),(887,'g',0,'2011-11-23'),(899,'g',0,'2011-11-23'),(923,'g',0,'2011-11-23'),(924,'g',0,'2011-11-23'),(888,'g',0,'2011-11-23'),(925,'g',0,'2011-11-23'),(902,'g',0,'2011-11-23'),(926,'g',0,'2011-11-23'),(82,'g',0,'2012-02-21'),(936,'g',0,'2011-11-24'),(918,'g',0,'2011-11-24'),(90,'g',0,'2012-02-21'),(86,'g',0,'2012-03-01'),(84,'g',0,'2012-02-21'),(85,'g',0,'2012-02-20'),(81,'g',0,'2012-02-21'),(87,'g',0,'2012-02-20'),(83,'g',0,'2011-11-24'),(88,'g',0,'2012-03-06'),(933,'g',0,'2011-11-24'),(915,'g',0,'2011-11-24'),(1023,'g',0,'2012-02-16'),(1007,'g',0,'2012-02-21'),(889,'g',0,'2011-11-24'),(903,'g',0,'2011-11-24'),(1040,'g',0,'2012-02-21'),(990,'g',0,'2012-02-21'),(927,'g',0,'2011-11-24'),(919,'g',0,'2011-11-24'),(892,'g',0,'2011-11-24'),(897,'g',0,'2011-11-24'),(976,'g',0,'2011-11-24'),(891,'g',0,'2011-11-24'),(904,'g',0,'2011-11-24'),(922,'g',0,'2011-11-24'),(929,'g',0,'2011-11-24'),(885,'g',0,'2011-11-24'),(89,'g',0,'2012-02-08'),(861,'g',0,'2011-11-25'),(859,'g',0,'2011-11-25'),(864,'g',0,'2011-11-25'),(862,'g',0,'2011-11-25'),(863,'g',0,'2011-11-25'),(860,'g',0,'2011-11-25'),(884,'g',0,'2011-11-26'),(975,'g',0,'2011-11-26'),(910,'g',0,'2011-11-26'),(971,'g',0,'2011-11-26'),(881,'g',0,'2011-11-26'),(1018,'g',0,'2011-11-26'),(940,'g',0,'2011-11-26'),(917,'g',0,'2011-11-26'),(983,'g',0,'2012-02-28'),(1019,'g',0,'2011-11-26'),(1053,'g',0,'2012-02-28'),(1026,'g',0,'2011-11-26'),(911,'g',0,'2011-11-26'),(879,'g',0,'2011-11-26'),(896,'g',0,'2011-11-26'),(856,'g',0,'2011-11-26'),(895,'g',0,'2011-11-26'),(886,'g',0,'2011-11-26'),(916,'g',0,'2011-11-26'),(857,'g',0,'2011-11-27'),(928,'g',0,'2011-11-27'),(1041,'g',0,'2011-11-27'),(890,'g',0,'2011-11-27'),(991,'g',0,'2012-03-04'),(853,'g',0,'2011-11-27'),(938,'g',0,'2011-11-27'),(942,'g',0,'2011-11-27'),(492,'g',0,'2011-11-29'),(479,'g',0,'2011-11-29'),(512,'g',0,'2011-11-29'),(439,'g',0,'2012-01-07'),(515,'g',0,'2011-11-29'),(460,'g',0,'2011-11-29'),(478,'g',0,'2011-11-29'),(491,'g',0,'2011-11-29'),(499,'g',0,'2011-11-29'),(167,'g',0,'2011-11-29'),(812,'g',0,'2011-11-29'),(756,'g',0,'2011-11-29'),(554,'g',0,'2011-11-29'),(913,'g',0,'2011-11-29'),(866,'g',0,'2011-11-29'),(680,'g',0,'2011-11-29'),(604,'g',0,'2011-11-29'),(799,'g',0,'2011-11-29'),(727,'g',0,'2011-11-29'),(855,'g',0,'2011-11-29'),(935,'g',0,'2011-12-01'),(931,'g',0,'2011-12-01'),(1069,'g',0,'2011-12-01'),(1071,'g',0,'2011-12-01'),(1070,'g',0,'2011-12-01'),(1044,'g',0,'2012-02-21'),(1047,'g',0,'2012-02-21'),(1049,'g',0,'2011-12-03'),(1027,'g',0,'2012-02-16'),(44,'g',0,'2012-02-21'),(1068,'g',0,'2011-12-03'),(989,'g',0,'2011-12-04'),(1000,'g',0,'2012-02-21'),(1034,'g',0,'2012-02-21'),(934,'g',0,'2011-12-05'),(1046,'g',0,'2011-12-05'),(1005,'g',0,'2011-12-05'),(988,'g',0,'2011-12-05'),(1079,'g',0,'2011-12-07'),(954,'g',0,'2012-01-17'),(375,'g',0,'2011-12-13'),(372,'g',0,'2011-12-13'),(378,'g',0,'2011-12-13'),(374,'g',0,'2011-12-13'),(373,'g',0,'2011-12-13'),(376,'g',0,'2011-12-13'),(371,'g',0,'2011-12-13'),(377,'g',0,'2011-12-13'),(369,'g',0,'2011-12-13'),(370,'g',0,'2011-12-13'),(383,'g',0,'2011-12-13'),(379,'g',0,'2011-12-13'),(380,'g',0,'2011-12-13'),(386,'g',0,'2011-12-13'),(387,'g',0,'2011-12-13'),(381,'g',0,'2011-12-13'),(430,'g',0,'2011-12-13'),(423,'g',0,'2011-12-13'),(419,'g',0,'2011-12-13'),(433,'g',0,'2011-12-13'),(422,'g',0,'2011-12-13'),(428,'g',0,'2011-12-13'),(424,'g',0,'2011-12-13'),(420,'g',0,'2011-12-13'),(421,'g',0,'2011-12-13'),(455,'g',0,'2011-12-13'),(384,'g',0,'2011-12-13'),(382,'g',0,'2011-12-13'),(388,'g',0,'2011-12-13'),(385,'g',0,'2011-12-14'),(943,'g',0,'2011-12-14'),(416,'g',0,'2011-12-14'),(414,'g',0,'2011-12-14'),(410,'g',0,'2011-12-14'),(411,'g',0,'2011-12-14'),(412,'g',0,'2011-12-14'),(413,'g',0,'2011-12-14'),(409,'g',0,'2011-12-14'),(418,'g',0,'2011-12-14'),(417,'g',0,'2011-12-14'),(415,'g',0,'2011-12-14'),(404,'g',0,'2011-12-14'),(401,'g',0,'2011-12-14'),(405,'g',0,'2011-12-14'),(407,'g',0,'2011-12-14'),(406,'g',0,'2011-12-14'),(402,'g',0,'2011-12-14'),(400,'g',0,'2011-12-14'),(403,'g',0,'2011-12-14'),(408,'g',0,'2011-12-14'),(399,'g',0,'2011-12-14'),(395,'g',0,'2011-12-14'),(389,'g',0,'2011-12-14'),(392,'g',0,'2011-12-14'),(396,'g',0,'2011-12-14'),(393,'g',0,'2011-12-14'),(397,'g',0,'2011-12-14'),(398,'g',0,'2011-12-14'),(390,'g',0,'2011-12-14'),(1020,'g',0,'2011-12-14'),(1073,'g',0,'2011-12-14'),(1022,'g',0,'2011-12-14'),(1010,'g',0,'2011-12-14'),(1016,'g',0,'2011-12-14'),(1009,'g',0,'2011-12-14'),(1050,'g',0,'2011-12-14'),(391,'g',0,'2012-02-21'),(1062,'g',0,'2011-12-14'),(1006,'g',0,'2011-12-14'),(394,'g',0,'2011-12-14'),(606,'g',0,'2012-02-21'),(252,'g',0,'2011-12-14'),(468,'g',0,'2011-12-14'),(1008,'g',0,'2011-12-14'),(661,'g',0,'2011-12-15'),(647,'g',0,'2011-12-15'),(565,'g',0,'2011-12-15'),(542,'g',0,'2011-12-15'),(547,'g',0,'2011-12-15'),(427,'g',0,'2011-12-15'),(805,'g',0,'2011-12-15'),(679,'g',0,'2011-12-15'),(831,'g',0,'2011-12-15'),(729,'g',0,'2011-12-15'),(978,'g',0,'2011-12-15'),(984,'g',0,'2011-12-15'),(644,'g',0,'2011-12-15'),(621,'g',0,'2011-12-15'),(580,'g',0,'2011-12-15'),(543,'g',0,'2011-12-15'),(529,'g',0,'2011-12-15'),(539,'g',0,'2011-12-15'),(541,'g',0,'2011-12-15'),(551,'g',0,'2011-12-15'),(544,'g',0,'2011-12-15'),(1114,'g',0,'2011-12-15'),(1004,'g',0,'2011-12-15'),(946,'g',0,'2011-12-15'),(607,'g',0,'2011-12-15'),(1017,'g',0,'2011-12-15'),(464,'g',0,'2011-12-15'),(77,'g',0,'2011-12-15'),(996,'g',0,'2011-12-15'),(1110,'g',0,'2011-12-15'),(558,'g',0,'2011-12-15'),(65,'g',0,'2012-02-21'),(105,'g',0,'2011-12-15'),(596,'g',0,'2011-12-15'),(457,'g',0,'2011-12-15'),(436,'g',0,'2011-12-15'),(1036,'g',0,'2011-12-15'),(947,'g',0,'2011-12-15'),(649,'g',0,'2011-12-15'),(997,'g',0,'2011-12-15'),(993,'g',0,'2011-12-15'),(1037,'g',0,'2011-12-16'),(76,'g',0,'2011-12-16'),(285,'g',0,'2011-12-16'),(266,'g',0,'2011-12-16'),(802,'g',0,'2011-12-16'),(1039,'g',0,'2011-12-16'),(1032,'g',0,'2011-12-16'),(482,'g',0,'2011-12-16'),(64,'g',0,'2011-12-16'),(78,'g',0,'2011-12-16'),(80,'g',0,'2011-12-16'),(513,'g',0,'2011-12-16'),(79,'g',0,'2011-12-16'),(66,'g',0,'2011-12-16'),(743,'g',0,'2011-12-16'),(961,'g',0,'2011-12-16'),(1035,'g',0,'2011-12-16'),(1038,'g',0,'2011-12-16'),(676,'g',0,'2011-12-16'),(974,'g',0,'2011-12-16'),(992,'g',0,'2011-12-16'),(998,'g',0,'2011-12-16'),(1066,'g',0,'2011-12-16'),(1028,'g',0,'2011-12-16'),(1042,'g',0,'2011-12-17'),(524,'g',0,'2011-12-17'),(999,'g',0,'2012-02-21'),(994,'g',0,'2011-12-19'),(1055,'g',0,'2011-12-19'),(1002,'g',0,'2012-02-21'),(1061,'g',0,'2012-02-21'),(1060,'g',0,'2011-12-20'),(980,'g',0,'2011-12-20'),(1012,'g',0,'2011-12-20'),(1175,'g',0,'2011-12-20'),(1133,'g',0,'2011-12-20'),(1136,'g',0,'2011-12-20'),(1190,'g',0,'2011-12-20'),(1174,'g',0,'2011-12-20'),(1177,'g',0,'2011-12-20'),(1065,'g',0,'2011-12-20'),(1025,'g',0,'2011-12-20'),(1033,'g',0,'2011-12-20'),(1052,'g',0,'2011-12-20'),(1045,'g',0,'2011-12-20'),(1059,'g',0,'2011-12-20'),(1058,'g',0,'2011-12-20'),(1043,'g',0,'2011-12-20'),(1092,'g',0,'2011-12-20'),(1106,'g',0,'2011-12-20'),(1111,'g',0,'2011-12-20'),(1122,'g',0,'2011-12-20'),(1076,'g',0,'2011-12-20'),(1176,'g',0,'2011-12-20'),(1098,'g',0,'2011-12-21'),(1082,'g',0,'2011-12-21'),(1102,'g',0,'2011-12-21'),(1072,'g',0,'2011-12-21'),(1103,'g',0,'2011-12-21'),(1121,'g',0,'2011-12-21'),(951,'g',0,'2011-12-22'),(948,'g',0,'2011-12-22'),(949,'g',0,'2011-12-22'),(950,'g',0,'2011-12-22'),(1105,'g',0,'2011-12-22'),(1191,'g',0,'2011-12-22'),(1124,'g',0,'2011-12-22'),(1196,'g',0,'2011-12-22'),(1117,'g',0,'2011-12-22'),(1064,'g',0,'2011-12-22'),(1198,'g',0,'2011-12-22'),(1081,'g',0,'2011-12-22'),(1067,'g',0,'2011-12-22'),(1118,'g',0,'2011-12-22'),(1167,'g',0,'2011-12-22'),(1134,'g',0,'2011-12-22'),(1112,'g',0,'2011-12-22'),(1095,'g',0,'2011-12-22'),(969,'g',0,'2011-12-22'),(945,'g',0,'2011-12-22'),(979,'g',0,'2011-12-22'),(1051,'g',0,'2011-12-22'),(1056,'g',0,'2011-12-22'),(1127,'g',0,'2011-12-22'),(1057,'g',0,'2011-12-22'),(1135,'g',0,'2011-12-22'),(1125,'g',0,'2011-12-22'),(1132,'g',0,'2011-12-22'),(1178,'g',0,'2011-12-22'),(1171,'g',0,'2011-12-22'),(1170,'g',0,'2011-12-22'),(1166,'g',0,'2011-12-22'),(1207,'g',0,'2011-12-22'),(973,'g',0,'2011-12-23'),(1024,'g',0,'2011-12-23'),(1080,'g',0,'2011-12-23'),(960,'g',0,'2011-12-24'),(966,'g',0,'2011-12-24'),(965,'g',0,'2011-12-24'),(967,'g',0,'2011-12-24'),(964,'g',0,'2011-12-24'),(958,'g',0,'2011-12-24'),(956,'g',0,'2011-12-24'),(963,'g',0,'2011-12-24'),(957,'g',0,'2011-12-24'),(962,'g',0,'2011-12-24'),(368,'g',0,'2011-12-24'),(982,'g',0,'2011-12-24'),(985,'g',0,'2011-12-24'),(1137,'g',0,'2011-12-24'),(1130,'g',0,'2011-12-24'),(1165,'g',0,'2011-12-24'),(955,'g',0,'2011-12-26'),(944,'g',0,'2011-12-26'),(1021,'g',0,'2011-12-26'),(1128,'g',0,'2012-02-07'),(1169,'g',0,'2011-12-29'),(1015,'g',0,'2011-12-29'),(1014,'g',0,'2011-12-29'),(972,'g',0,'2011-12-29'),(1063,'g',0,'2011-12-29'),(953,'g',0,'2011-12-29'),(1168,'g',0,'2012-02-21'),(981,'g',0,'2011-12-30'),(1217,'g',0,'2012-02-21'),(952,'g',0,'2011-12-30'),(995,'g',0,'2011-12-30'),(959,'g',0,'2011-12-30'),(1261,'g',0,'2012-02-21'),(1267,'g',0,'2012-02-21'),(1260,'g',0,'2012-01-03'),(1266,'g',0,'2012-01-03'),(1075,'g',0,'2012-01-03'),(1269,'g',0,'2012-01-03'),(1319,'g',0,'2012-01-05'),(1232,'g',0,'2012-02-21'),(1315,'g',0,'2012-02-21'),(1097,'g',0,'2012-01-06'),(1001,'g',0,'2012-01-06'),(1086,'g',0,'2012-01-06'),(1188,'g',0,'2012-01-06'),(1093,'g',0,'2012-01-06'),(1187,'g',0,'2012-01-06'),(1222,'g',0,'2012-01-06'),(1231,'g',0,'2012-01-06'),(1236,'g',0,'2012-01-08'),(1202,'g',0,'2012-01-09'),(1303,'g',0,'2012-01-09'),(1221,'g',0,'2012-01-09'),(1318,'g',0,'2012-01-09'),(1242,'g',0,'2012-01-09'),(619,'g',0,'2012-01-09'),(559,'g',0,'2012-01-09'),(496,'g',0,'2012-01-09'),(490,'g',0,'2012-01-09'),(525,'g',0,'2012-01-09'),(555,'g',0,'2012-01-09'),(550,'g',0,'2012-01-09'),(483,'g',0,'2012-01-09'),(506,'g',0,'2012-01-09'),(517,'g',0,'2012-01-09'),(616,'g',0,'2012-01-09'),(682,'g',0,'2012-01-09'),(610,'g',0,'2012-01-09'),(627,'g',0,'2012-01-09'),(608,'g',0,'2012-01-09'),(746,'g',0,'2012-01-09'),(570,'g',0,'2012-01-09'),(567,'g',0,'2012-01-09'),(813,'g',0,'2012-01-09'),(752,'g',0,'2012-01-09'),(748,'g',0,'2012-01-09'),(811,'g',0,'2012-01-09'),(849,'g',0,'2012-01-09'),(836,'g',0,'2012-01-09'),(751,'g',0,'2012-01-09'),(814,'g',0,'2012-01-09'),(534,'g',0,'2012-01-09'),(816,'g',0,'2012-01-09'),(755,'g',0,'2012-01-09'),(1179,'g',0,'2012-01-09'),(1289,'g',0,'2012-01-10'),(1258,'g',0,'2012-02-21'),(1100,'g',0,'2012-01-23'),(1317,'g',0,'2012-01-23'),(1245,'g',0,'2012-01-23'),(1109,'g',0,'2012-01-23'),(1227,'g',0,'2012-01-23'),(1074,'g',0,'2012-01-23'),(1096,'g',0,'2012-01-23'),(1301,'g',0,'2012-01-23'),(1250,'g',0,'2012-01-23'),(968,'g',0,'2012-01-28'),(970,'g',0,'2012-01-28'),(1397,'g',0,'2012-01-28'),(1365,'g',0,'2012-01-28'),(1404,'g',0,'2012-01-28'),(1334,'g',0,'2012-01-28'),(1003,'g',0,'2012-01-28'),(1011,'g',0,'2012-01-28'),(1030,'g',0,'2012-01-28'),(1316,'g',0,'2012-01-28'),(1013,'g',0,'2012-01-29'),(1031,'g',0,'2012-01-29'),(1029,'g',0,'2012-01-29'),(1048,'g',0,'2012-01-29'),(1116,'g',0,'2012-01-29'),(1054,'g',0,'2012-01-29'),(1368,'g',0,'2012-01-29'),(1403,'g',0,'2012-01-29'),(1224,'g',0,'2012-01-31'),(1323,'g',0,'2012-01-31'),(1436,'g',0,'2012-02-07'),(1426,'g',0,'2012-02-07'),(1393,'g',0,'2012-02-08'),(1484,'g',0,'2012-02-08'),(1367,'g',0,'2012-02-08'),(1435,'g',0,'2012-02-08'),(1195,'g',0,'2012-02-09'),(1497,'g',0,'2012-02-13'),(1502,'g',0,'2012-02-13'),(1493,'g',0,'2012-02-14'),(1513,'g',0,'2012-02-14'),(1496,'g',0,'2012-02-14'),(1419,'g',0,'2012-02-15'),(1445,'g',0,'2012-02-17'),(1333,'g',0,'2012-02-17'),(1491,'g',0,'2012-02-18'),(1279,'g',0,'2012-02-19'),(1206,'g',0,'2012-02-19'),(1264,'g',0,'2012-02-19'),(1219,'g',0,'2012-02-19'),(1253,'g',0,'2012-02-19'),(1233,'g',0,'2012-02-19'),(1251,'g',0,'2012-02-19'),(1276,'g',0,'2012-02-19'),(1275,'g',0,'2012-02-19'),(1205,'g',0,'2012-02-19'),(1314,'g',0,'2012-02-19'),(1361,'g',0,'2012-02-19'),(1506,'g',0,'2012-02-19'),(1369,'g',0,'2012-02-19'),(1209,'g',0,'2012-02-19'),(1194,'g',0,'2012-02-19'),(1514,'g',0,'2012-02-19'),(1201,'g',0,'2012-02-19'),(1442,'g',0,'2012-02-20'),(1481,'g',0,'2012-02-20'),(1390,'g',0,'2012-02-20'),(1448,'g',0,'2012-02-20'),(1452,'g',0,'2012-02-20'),(1478,'g',0,'2012-02-20'),(1482,'g',0,'2012-02-20'),(1431,'g',0,'2012-02-20'),(1459,'g',0,'2012-02-20'),(1453,'g',0,'2012-02-20'),(1470,'g',0,'2012-02-20'),(1499,'g',0,'2012-02-20'),(1522,'g',0,'2012-02-20'),(1379,'g',0,'2012-02-20'),(1391,'g',0,'2012-02-21'),(1427,'g',0,'2012-02-21'),(1376,'g',0,'2012-02-21'),(1498,'g',0,'2012-02-21'),(1467,'g',0,'2012-02-21'),(1392,'g',0,'2012-02-21'),(1380,'g',0,'2012-02-21'),(1308,'g',0,'2012-02-21'),(1377,'g',0,'2012-02-21'),(1378,'g',0,'2012-02-21'),(1375,'g',0,'2012-02-21'),(1490,'g',0,'2012-02-21'),(1512,'g',0,'2012-02-21'),(1523,'g',0,'2012-02-21'),(1520,'g',0,'2012-02-21'),(1348,'g',0,'2012-02-21'),(1277,'g',0,'2012-02-21'),(1340,'g',0,'2012-02-21'),(1247,'g',0,'2012-02-21'),(1360,'g',0,'2012-02-21'),(1385,'g',0,'2012-02-21'),(1458,'g',0,'2012-02-21'),(1468,'g',0,'2012-02-21'),(1486,'g',0,'2012-02-21'),(1099,'g',0,'2012-02-23'),(1234,'g',0,'2012-02-23'),(1230,'g',0,'2012-02-23'),(1256,'g',0,'2012-02-23'),(1278,'g',0,'2012-02-23'),(1108,'g',0,'2012-02-23'),(1274,'g',0,'2012-02-23'),(1457,'g',0,'2012-02-23'),(1215,'g',0,'2012-02-23'),(1272,'g',0,'2012-02-23'),(1479,'g',0,'2012-02-23'),(1094,'g',0,'2012-02-23'),(1336,'g',0,'2012-02-23'),(1528,'g',0,'2012-02-23'),(1480,'g',0,'2012-02-25'),(1472,'g',0,'2012-02-25'),(1296,'g',0,'2012-02-25'),(1293,'g',0,'2012-02-25'),(1507,'g',0,'2012-02-25'),(1320,'g',0,'2012-02-25'),(1284,'g',0,'2012-02-25'),(1290,'g',0,'2012-02-26'),(1294,'g',0,'2012-02-26'),(1339,'g',0,'2012-02-26'),(1295,'g',0,'2012-02-26'),(1285,'g',0,'2012-02-26'),(1283,'g',0,'2012-02-26'),(1292,'g',0,'2012-02-26'),(1342,'g',0,'2012-02-26'),(1281,'g',0,'2012-02-26'),(1287,'g',0,'2012-02-26'),(1388,'g',0,'2012-02-27'),(1437,'g',0,'2012-02-27'),(1517,'g',0,'2012-02-27'),(1494,'g',0,'2012-02-27'),(1495,'g',0,'2012-02-27'),(1577,'g',0,'2012-03-01'),(1465,'g',0,'2012-03-01'),(1584,'g',0,'2012-03-02'),(1562,'g',0,'2012-03-03'),(1570,'g',0,'2012-03-03'),(1571,'g',0,'2012-03-03'),(1575,'g',0,'2012-03-05'),(1594,'g',0,'2012-03-06'),(1544,'g',0,'2012-03-06'),(1588,'g',0,'2012-03-07'),(1595,'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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sponsored` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `expire` datetime DEFAULT NULL,
  `paid` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `enable` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `setting` text COLLATE utf8_unicode_ci,
  `invoice_html` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`payment_gateway_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `detail` text COLLATE utf8_unicode_ci,
  `amount` double DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `invoice_id` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`payment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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 ('4Hr18fMIu7hm8I4xy7Eq5w','xRaMPHS4rjgSJ8qMax1LSTt0U4DbDIdF7NNRyomNoQY','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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `plugin_file` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` enum('0','1') COLLATE utf8_unicode_ci DEFAULT NULL,
  `option_plugin` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`plugin_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `idx_plugin` VALUES (1,'AutoTweet','twitter_auto_tweet/twitter_auto_tweet.php','1',NULL),(2,'Sociable','sociable/sociable.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 COLLATE utf8_unicode_ci NOT NULL,
  `rating` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  `subject` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `username` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`review_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

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

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

INSERT INTO `idx_searchlog` VALUES ('www.bankruptcylawyer.com','2011-07-11 17:38:21',0,'203.92.47.195'),('www.bankruptcylawyer.com','2011-07-15 11:49:20',0,'203.92.47.195'),('www.thanh39.com','2011-07-21 11:42:29',0,'203.92.47.195'),('Personalized Graduation Gifts','2011-07-21 11:42:44',0,'203.92.47.195'),('Urgent Care Orange Park','2011-08-03 13:30:48',0,'203.92.47.195'),('realestateforprofit.com','2011-08-03 19:02:59',0,'203.92.47.195'),('RakeBackCodes.com','2011-10-21 00:46:14',0,'203.92.47.195'),('Poker Rakeback','2011-10-21 01:11:51',0,'203.92.47.195'),('digitpet','2011-11-23 02:29:31',1,'203.92.47.195'),('Medezen.com','2011-12-16 13:07:45',1,'203.92.47.195'),('GrowingStars.com','2012-02-21 04:50:11',1,'203.92.47.195'),('GrowingStars.com','2012-02-21 04:57:26',1,'203.92.47.195');

--
-- 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `set_hook_place` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`set_hook_place_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `setting_value` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`setting_id`)
) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `idx_setting` VALUES (4,'site_name','ADDSOCIAL.ORG'),(5,'site_url','http://addsocial.org'),(6,'email_address','mark15851@hotmail.com'),(7,'language_code','en_US'),(8,'theme_path','/home/addsocia/public_html/themes/'),(9,'admin_template_path','/home/addsocia/public_html/admin_tpl/'),(10,'plugin_path','/home/addsocia/public_html/plugin/'),(12,'active_theme','direktory_add'),(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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `category_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `total` int(11) NOT NULL DEFAULT '0',
  `tag_path` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`tag`,`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `who_is` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`idx_unavailable`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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=utf8 COLLATE=utf8_unicode_ci;

--
-- 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` tinyint(4) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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



