--
-- Host: localdirectori.com    Database: geteurop_direct
-- ------------------------------------------------------


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

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

INSERT INTO `idx_category` VALUES (105,0,'Arts & Humanities','','folder.gif','','1',11,'','','1','0','','',0,'',2,0,0,0,0),(106,0,'Automobile industry','','folder.gif','','1',38,'','','1','0','','',0,'',2,0,0,0,0),(107,0,'Business & Economy','','folder.gif','','1',142,'','','1','0','','',0,'',0,0,0,0,0),(108,0,'Careers','','folder.gif','','1',2,'','','1','0','','',0,'',1,0,0,0,0),(109,0,'Clothing & Fashion','','folder.gif','','1',8,'','','1','0','','',0,'',0,0,0,0,0),(110,0,'Mass Communications','','folder.gif','','1',17,'','','1','0','','',0,'',0,0,0,0,0),(111,0,'Computers & IT','','folder.gif','','1',20,'','','1','0','','',0,'',1,0,0,0,0),(112,0,'Construction Services','','folder.gif','','1',81,'','','1','0','','',0,'',0,0,0,0,0),(113,0,'Dental Health','','folder.gif','','1',73,'','','1','0','','',0,'',1,0,0,0,0),(114,0,'Education & Training','','folder.gif','','1',25,'','','1','0','','',0,'',0,0,0,0,0),(115,0,'Employment & Recruitment','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(116,0,'Gifts & Novelties','','folder.gif','','1',22,'','','1','0','','',0,'',0,0,0,0,0),(117,0,'Software & Hardware','','folder.gif','','1',11,'','','1','0','','',0,'',0,0,0,0,0),(118,0,'Health Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(119,0,'Healthcare ','','folder.gif','','1',139,'','','1','0','','',0,'',1,0,0,0,0),(120,0,'Heating and Air Conditioning','','folder.gif','','1',56,'','','1','0','','',0,'',0,0,0,0,0),(121,0,'Home & Garden','','folder.gif','','1',218,'','','1','0','','',0,'',0,0,0,0,0),(122,0,'Home Improvement ','','folder.gif','','1',82,'','','1','0','','',0,'',0,0,0,0,0),(123,0,'Hotels & Motels','','folder.gif','','1',44,'','','1','0','','',0,'',0,0,0,0,0),(124,0,'Insurance','','folder.gif','','1',28,'','','1','0','','',0,'',0,0,0,0,0),(125,0,'Law & Politics','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(126,0,'Lawyers & Attorneys','','folder.gif','','1',52,'','','1','0','','',0,'',0,0,0,0,0),(127,0,'Lifestyle & Society','','folder.gif','','1',8,'','','1','0','','',0,'',0,0,0,0,0),(128,0,'Medicine & Surgery','','folder.gif','','1',7,'','','1','0','','',0,'',0,0,0,0,0),(129,0,'Lawyers & Attorneys','','folder.gif','','1',95,'','','1','0','','',0,'',0,0,0,0,0),(130,0,'Finance & Investment','','folder.gif','','1',16,'','','1','0','','',0,'',0,0,0,0,0),(131,0,'News & Media','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(132,0,'Plumbing Contractors','','folder.gif','','1',32,'','','1','0','','',0,'',0,0,0,0,0),(133,0,'Real Estate & Property','','folder.gif','','1',33,'','','1','0','','',0,'',0,0,0,0,0),(134,0,'Science ','','folder.gif','','1',14,'','','1','0','','',0,'',0,0,0,0,0),(135,0,'SEO & SMO','','folder.gif','','1',20,'','','1','0','','',0,'',1,0,0,0,0),(136,0,'Shopping and Sales','','folder.gif','','1',68,'','','1','0','','',0,'',0,0,0,0,0),(137,0,'Sports & Recreation','','folder.gif','','1',7,'','','1','0','','',0,'',0,0,0,0,0),(138,0,'Transportation Services','','folder.gif','','1',35,'','','1','0','','',0,'',0,0,0,0,0),(139,0,'Travel & Tour','','folder.gif','','1',24,'','','1','0','','',0,'',2,0,0,0,0),(140,0,'Weddings','','folder.gif','','1',10,'','','1','0','','',0,'',1,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 (105,'Arts & Humanities','<a href=\"http://localdirectori.com/arts-humanities/\" name=\"cat_105\" style=\"\">Arts & Humanities</a>',';0;'),(106,'Automobile industry','<a href=\"http://localdirectori.com/automobile-industry/\" name=\"cat_106\" style=\"\">Automobile industry</a>',';0;'),(107,'Business & Economy','<a href=\"http://localdirectori.com/business-economy/\" name=\"cat_107\" style=\"\">Business & Economy</a>',';0;'),(108,'Careers','<a href=\"http://localdirectori.com/careers/\" name=\"cat_108\" style=\"\">Careers</a>',';0;'),(109,'Clothing & Fashion','<a href=\"http://localdirectori.com/clothing-fashion/\" name=\"cat_109\" style=\"\">Clothing & Fashion</a>',';0;'),(110,'Mass Communications','<a href=\"http://localdirectori.com/mass-communications/\" name=\"cat_110\" style=\"\">Mass Communications</a>',';0;'),(111,'Computers & IT','<a href=\"http://localdirectori.com/computers-it/\" name=\"cat_111\" style=\"\">Computers & IT</a>',';0;'),(112,'Construction Services','<a href=\"http://localdirectori.com/construction-services/\" name=\"cat_112\" style=\"\">Construction Services</a>',';0;'),(113,'Dental Health','<a href=\"http://localdirectori.com/dental-health/\" name=\"cat_113\" style=\"\">Dental Health</a>',';0;'),(114,'Education & Training','<a href=\"http://localdirectori.com/education-training/\" name=\"cat_114\" style=\"\">Education & Training</a>',';0;'),(115,'Employment & Recruitment','<a href=\"http://localdirectori.com/employment-recruitment/\" name=\"cat_115\" style=\"\">Employment & Recruitment</a>',';0;'),(116,'Gifts & Novelties','<a href=\"http://localdirectori.com/gifts-novelties/\" name=\"cat_116\" style=\"\">Gifts & Novelties</a>',';0;'),(117,'Software & Hardware','<a href=\"http://localdirectori.com/software-hardware/\" name=\"cat_117\" style=\"\">Software & Hardware</a>',';0;'),(118,'Health Services','<a href=\"http://localdirectori.com/health-services/\" name=\"cat_118\" style=\"\">Health Services</a>',';0;'),(119,'Healthcare ','<a href=\"http://localdirectori.com/healthcare/\" name=\"cat_119\" style=\"\">Healthcare </a>',';0;'),(120,'Heating and Air Conditioning','<a href=\"http://localdirectori.com/heating-and-air-conditioning/\" name=\"cat_120\" style=\"\">Heating and Air Conditioning</a>',';0;'),(121,'Home & Garden','<a href=\"http://localdirectori.com/home-garden/\" name=\"cat_121\" style=\"\">Home & Garden</a>',';0;'),(122,'Home Improvement ','<a href=\"http://localdirectori.com/home-improvement/\" name=\"cat_122\" style=\"\">Home Improvement </a>',';0;'),(123,'Hotels & Motels','<a href=\"http://localdirectori.com/hotels-motels/\" name=\"cat_123\" style=\"\">Hotels & Motels</a>',';0;'),(124,'Insurance','<a href=\"http://localdirectori.com/insurance/\" name=\"cat_124\" style=\"\">Insurance</a>',';0;'),(125,'Law & Politics','<a href=\"http://localdirectori.com/law-politics/\" name=\"cat_125\" style=\"\">Law & Politics</a>',';0;'),(126,'Lawyers & Attorneys','<a href=\"http://localdirectori.com/lawyers-attorneys/\" name=\"cat_126\" style=\"\">Lawyers & Attorneys</a>',';0;'),(127,'Lifestyle & Society','<a href=\"http://localdirectori.com/lifestyle-society/\" name=\"cat_127\" style=\"\">Lifestyle & Society</a>',';0;'),(128,'Medicine & Surgery','<a href=\"http://localdirectori.com/medicine-surgery/\" name=\"cat_128\" style=\"\">Medicine & Surgery</a>',';0;'),(129,'Lawyers & Attorneys','<a href=\"http://localdirectori.com/lawyers-attorneys/\" name=\"cat_129\" style=\"\">Lawyers & Attorneys</a>',';0;'),(130,'Finance & Investment','<a href=\"http://localdirectori.com/finance-investment/\" name=\"cat_130\" style=\"\">Finance & Investment</a>',';0;'),(131,'News & Media','<a href=\"http://localdirectori.com/news-media/\" name=\"cat_131\" style=\"\">News & Media</a>',';0;'),(132,'Plumbing Contractors','<a href=\"http://localdirectori.com/plumbing-contractors/\" name=\"cat_132\" style=\"\">Plumbing Contractors</a>',';0;'),(133,'Real Estate & Property','<a href=\"http://localdirectori.com/real-estate-property/\" name=\"cat_133\" style=\"\">Real Estate & Property</a>',';0;'),(134,'Science ','<a href=\"http://localdirectori.com/science/\" name=\"cat_134\" style=\"\">Science </a>',';0;'),(135,'SEO & SMO','<a href=\"http://localdirectori.com/seo-smo/\" name=\"cat_135\" style=\"\">SEO & SMO</a>',';0;'),(136,'Shopping and Sales','<a href=\"http://localdirectori.com/shopping-and-sales/\" name=\"cat_136\" style=\"\">Shopping and Sales</a>',';0;'),(137,'Sports & Recreation','<a href=\"http://localdirectori.com/sports-recreation/\" name=\"cat_137\" style=\"\">Sports & Recreation</a>',';0;'),(138,'Transportation Services','<a href=\"http://localdirectori.com/transportation-services/\" name=\"cat_138\" style=\"\">Transportation Services</a>',';0;'),(139,'Travel & Tour','<a href=\"http://localdirectori.com/travel-tour/\" name=\"cat_139\" style=\"\">Travel & Tour</a>',';0;'),(140,'Weddings','<a href=\"http://localdirectori.com/weddings/\" name=\"cat_140\" 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=4 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_category_suggession` VALUES (1,112,'Norm','You Sir/Madam are the enemy of cnofsuion everywhere!','2011-11-11 04:40:11'),(2,119,'Orthodontic treatment','Orthodontist Dr. Daniel German in Beavercreek OH offers quality orthodontic care, braces, and Invisalign in Dayton and Wright Patterson Air Force Base\r\nhttp://germanorthodontics.com/','2012-02-09 22:23:27'),(3,135,'SEO Kolkata','If you are in need of the best backlinks for your website to bring in better results and more volume of visitors choose the best SEO services India.','2012-03-03 13:01: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=8 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_favorites` VALUES (1,'aaroj9hqco','2011-10-19','My Favorites',NULL),(2,'brucvwoywi','2011-10-21','My Favorites',NULL),(3,'magikandreea','2011-11-03','My Favorites',NULL),(4,'ryanapfksc','2011-11-25','My Favorites',NULL),(5,'dougqetwza','2011-12-21','My Favorites',NULL),(6,'culuz4lmbe','2012-01-31','My Favorites',NULL),(7,'idsgroup','2012-02-25','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 (2,'magikandreea');

--
-- 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 (27,'g',4,'2011-10-03'),(28,'g',6,'2011-10-03'),(30,'g',3,'2011-10-03'),(31,'g',3,'2011-10-03'),(32,'g',3,'2011-10-03'),(33,'g',2,'2011-10-03'),(35,'g',2,'2011-10-03'),(34,'g',2,'2011-10-03'),(36,'g',2,'2011-10-03'),(37,'g',0,'2011-10-03'),(1,'g',6,'2011-10-03'),(71,'g',0,'2012-01-21'),(19,'g',0,'2012-01-24'),(73,'g',0,'2012-01-23'),(72,'g',0,'2012-03-06'),(67,'g',0,'2012-01-26'),(128,'g',0,'2012-01-21'),(140,'g',0,'2012-01-20'),(87,'g',0,'2012-02-15'),(98,'g',0,'2011-12-01'),(18,'g',3,'2011-10-05'),(95,'g',0,'2011-10-05'),(93,'g',0,'2012-01-25'),(106,'g',2,'2011-10-05'),(112,'g',0,'2012-02-15'),(124,'g',0,'2012-01-25'),(118,'g',0,'2012-02-15'),(100,'g',0,'2012-01-22'),(15,'g',0,'2012-01-21'),(65,'g',0,'2012-01-23'),(23,'g',0,'2012-01-23'),(153,'g',0,'2012-01-23'),(209,'g',0,'2012-01-23'),(123,'g',0,'2012-01-23'),(206,'g',0,'2012-01-23'),(204,'g',0,'2012-01-23'),(120,'g',0,'2012-01-23'),(145,'g',0,'2012-01-23'),(88,'g',0,'2011-11-29'),(156,'g',0,'2012-01-25'),(141,'g',0,'2011-12-01'),(25,'g',0,'2012-01-22'),(108,'g',0,'2011-11-15'),(139,'g',0,'2011-11-15'),(91,'g',0,'2011-11-29'),(92,'g',0,'2012-01-20'),(121,'g',0,'2011-11-15'),(90,'g',0,'2012-01-25'),(152,'g',0,'2012-01-27'),(119,'g',0,'2012-01-25'),(157,'g',0,'2012-01-27'),(110,'g',0,'2012-01-21'),(138,'g',0,'2012-01-21'),(102,'g',0,'2012-01-27'),(278,'g',0,'2011-10-09'),(418,'g',0,'2011-10-09'),(329,'g',0,'2011-10-09'),(135,'g',0,'2011-10-09'),(435,'g',0,'2011-10-09'),(465,'g',0,'2011-10-09'),(201,'g',0,'2011-10-09'),(319,'g',0,'2011-10-09'),(245,'g',0,'2011-10-09'),(387,'g',0,'2011-10-09'),(290,'g',0,'2011-10-09'),(362,'g',0,'2011-10-09'),(377,'g',0,'2011-10-09'),(445,'g',0,'2011-10-09'),(130,'g',0,'2012-01-25'),(260,'g',0,'2011-10-09'),(211,'g',0,'2011-10-09'),(186,'g',0,'2011-10-09'),(301,'g',0,'2011-10-10'),(14,'g',0,'2012-01-26'),(69,'g',0,'2012-01-26'),(316,'g',0,'2011-10-10'),(8,'g',0,'2012-02-28'),(61,'g',0,'2012-01-20'),(222,'g',0,'2011-12-01'),(2,'g',0,'2011-10-10'),(405,'g',0,'2011-10-10'),(229,'g',0,'2012-01-23'),(68,'g',0,'2012-01-22'),(70,'g',0,'2012-01-26'),(347,'g',0,'2011-10-10'),(13,'g',0,'2011-10-10'),(340,'g',0,'2011-10-10'),(1608,'g',0,'2012-01-24'),(85,'g',0,'2012-01-20'),(150,'g',0,'2012-01-22'),(1616,'g',0,'2012-01-21'),(9,'g',0,'2012-02-04'),(1628,'g',0,'2012-01-25'),(1670,'g',0,'2011-11-22'),(1669,'g',0,'2011-11-22'),(94,'g',0,'2012-03-05'),(524,'g',0,'2011-10-13'),(540,'g',0,'2011-10-13'),(12,'g',0,'2012-01-23'),(761,'g',0,'2012-03-04'),(392,'g',0,'2011-10-13'),(1600,'g',0,'2012-03-04'),(238,'g',0,'2011-10-13'),(507,'g',0,'2011-10-13'),(1594,'g',0,'2012-01-23'),(1604,'g',0,'2012-03-04'),(1624,'g',0,'2012-01-20'),(470,'g',0,'2011-10-13'),(312,'g',0,'2011-10-13'),(60,'g',0,'2012-02-08'),(289,'g',0,'2011-10-13'),(299,'g',0,'2011-10-13'),(334,'g',0,'2011-10-13'),(1619,'g',0,'2011-11-19'),(82,'g',0,'2011-11-17'),(297,'g',0,'2011-10-13'),(221,'g',0,'2012-01-24'),(64,'g',0,'2012-02-05'),(109,'g',0,'2011-10-13'),(179,'g',0,'2012-01-25'),(104,'g',0,'2012-03-04'),(227,'g',0,'2011-11-24'),(216,'g',0,'2012-01-24'),(277,'g',0,'2011-10-13'),(806,'g',0,'2011-10-13'),(489,'g',0,'2011-10-13'),(113,'g',0,'2012-01-23'),(807,'g',0,'2011-10-13'),(155,'g',0,'2011-10-13'),(220,'g',0,'2012-01-22'),(450,'g',0,'2011-10-13'),(760,'g',0,'2011-10-13'),(1626,'g',0,'2012-01-20'),(852,'g',0,'2011-10-13'),(1602,'g',0,'2012-03-03'),(274,'g',0,'2011-10-14'),(265,'g',0,'2011-10-14'),(269,'g',0,'2011-10-14'),(327,'g',0,'2011-10-14'),(438,'g',0,'2011-10-14'),(385,'g',0,'2011-10-14'),(322,'g',0,'2011-10-14'),(324,'g',0,'2011-10-14'),(380,'g',0,'2011-10-14'),(382,'g',0,'2011-10-14'),(440,'g',0,'2011-10-14'),(1640,'g',0,'2011-10-14'),(1734,'g',0,'2011-10-14'),(1761,'g',0,'2011-10-14'),(443,'g',0,'2011-10-14'),(1630,'g',0,'2012-01-25'),(122,'g',0,'2011-10-15'),(101,'g',0,'2012-01-22'),(132,'g',0,'2012-01-25'),(117,'g',0,'2012-02-28'),(6,'g',0,'2012-02-28'),(66,'g',0,'2012-01-23'),(84,'g',0,'2012-01-21'),(148,'g',0,'2012-01-23'),(1595,'g',0,'2011-10-15'),(225,'g',0,'2012-01-20'),(126,'g',0,'2012-01-31'),(1625,'g',0,'2012-03-04'),(1606,'g',0,'2012-01-20'),(1586,'g',0,'2011-10-15'),(63,'g',0,'2012-02-28'),(3,'g',0,'2012-02-07'),(1612,'g',0,'2011-11-23'),(4,'g',0,'2012-02-28'),(1622,'g',0,'2011-12-04'),(58,'g',0,'2012-02-02'),(105,'g',0,'2012-02-15'),(127,'g',0,'2012-01-23'),(181,'g',0,'2012-01-23'),(7,'g',0,'2012-02-05'),(99,'g',0,'2012-02-02'),(62,'g',0,'2011-12-09'),(5,'g',0,'2011-10-15'),(218,'g',0,'2012-02-16'),(86,'g',0,'2012-02-02'),(180,'g',0,'2011-11-18'),(17,'g',0,'2012-02-28'),(103,'g',0,'2012-01-22'),(1617,'g',0,'2012-03-05'),(44,'g',0,'2012-01-25'),(144,'g',0,'2012-02-07'),(97,'g',0,'2012-02-28'),(16,'g',0,'2012-03-03'),(1589,'g',0,'2012-01-20'),(96,'g',0,'2012-02-02'),(1623,'g',0,'2012-03-04'),(24,'g',0,'2012-02-08'),(1590,'g',0,'2012-01-21'),(21,'g',0,'2012-01-23'),(129,'g',0,'2012-02-15'),(11,'g',0,'2012-02-15'),(26,'g',0,'2012-02-02'),(83,'g',0,'2012-02-07'),(1584,'g',0,'2011-10-15'),(20,'g',0,'2012-02-28'),(654,'g',0,'2011-10-15'),(89,'g',0,'2012-02-02'),(10,'g',0,'2011-10-15'),(169,'g',0,'2011-10-15'),(151,'g',0,'2012-02-07'),(22,'g',0,'2011-12-09'),(1807,'g',0,'2011-10-17'),(1788,'g',0,'2011-10-17'),(1796,'g',0,'2012-01-20'),(1855,'g',0,'2011-11-23'),(1712,'g',0,'2011-11-24'),(1715,'g',0,'2011-11-24'),(1735,'g',0,'2011-11-24'),(1733,'g',0,'2011-11-24'),(1752,'g',0,'2011-10-20'),(1697,'g',0,'2011-11-24'),(1723,'g',0,'2011-11-24'),(1751,'g',0,'2011-10-20'),(1719,'g',0,'2011-11-24'),(1743,'g',0,'2011-10-20'),(805,'g',0,'2011-12-01'),(804,'g',0,'2011-12-01'),(1746,'g',0,'2011-11-23'),(1696,'g',0,'2011-11-23'),(1741,'g',0,'2011-11-23'),(1627,'g',0,'2011-11-23'),(1683,'g',0,'2011-12-15'),(1656,'g',0,'2011-11-24'),(1658,'g',0,'2011-11-24'),(1588,'g',0,'2011-10-20'),(1799,'g',0,'2012-02-28'),(1651,'g',0,'2011-10-20'),(1662,'g',0,'2011-10-20'),(1832,'g',0,'2011-11-22'),(1593,'g',0,'2012-01-22'),(1834,'g',0,'2012-02-01'),(1592,'g',0,'2011-10-20'),(1865,'g',0,'2012-02-01'),(1824,'g',0,'2012-02-01'),(1701,'g',0,'2012-02-01'),(1691,'g',0,'2012-01-25'),(1774,'g',0,'2011-10-21'),(1758,'g',0,'2011-10-21'),(1714,'g',0,'2011-10-21'),(1707,'g',0,'2011-10-21'),(1748,'g',0,'2011-10-21'),(1744,'g',0,'2012-02-06'),(1782,'g',0,'2011-10-21'),(1765,'g',0,'2011-10-21'),(1760,'g',0,'2011-10-21'),(1773,'g',0,'2011-10-21'),(679,'g',0,'2012-01-23'),(776,'g',0,'2012-02-08'),(770,'g',0,'2012-02-08'),(196,'g',0,'2012-02-08'),(771,'g',0,'2012-02-08'),(1652,'g',0,'2011-11-20'),(1726,'g',0,'2012-01-22'),(1666,'g',0,'2011-10-21'),(1817,'g',0,'2012-02-16'),(1790,'g',0,'2011-12-17'),(1772,'g',0,'2011-12-17'),(1665,'g',0,'2012-03-01'),(1732,'g',0,'2011-11-22'),(1771,'g',0,'2012-02-16'),(1852,'g',0,'2012-02-16'),(1831,'g',0,'2012-03-03'),(1822,'g',0,'2012-02-16'),(1704,'g',0,'2012-01-23'),(1688,'g',0,'2011-10-21'),(1682,'g',0,'2011-10-21'),(1736,'g',0,'2011-11-22'),(2050,'g',0,'2011-10-24'),(2075,'g',0,'2011-10-24'),(2067,'g',0,'2011-12-04'),(2034,'g',0,'2011-10-24'),(1944,'g',0,'2011-10-24'),(1876,'g',0,'2011-10-25'),(1895,'g',0,'2011-10-26'),(1685,'g',0,'2011-10-26'),(1921,'g',0,'2011-10-26'),(2028,'g',0,'2011-10-26'),(1729,'g',0,'2011-10-26'),(74,'g',0,'2012-01-26'),(1988,'g',0,'2011-10-26'),(1710,'g',0,'2011-10-26'),(1706,'g',0,'2011-10-26'),(2076,'g',0,'2012-01-26'),(2108,'g',0,'2011-10-26'),(2071,'g',0,'2011-10-26'),(2011,'g',0,'2012-01-25'),(1974,'g',0,'2011-12-06'),(1912,'g',0,'2011-10-26'),(2105,'g',0,'2011-12-17'),(1963,'g',0,'2011-12-01'),(2102,'g',0,'2012-02-16'),(1989,'g',0,'2012-02-16'),(1901,'g',0,'2011-12-01'),(1883,'g',0,'2011-10-27'),(2083,'g',0,'2011-10-27'),(1993,'g',0,'2011-10-27'),(2137,'g',0,'2012-02-04'),(2142,'g',0,'2012-01-26'),(2030,'g',0,'2011-10-27'),(2077,'g',0,'2011-10-27'),(1764,'g',0,'2011-10-27'),(2043,'g',0,'2012-02-04'),(2002,'g',0,'2011-10-27'),(1879,'g',0,'2011-10-27'),(2136,'g',0,'2011-10-27'),(1635,'g',0,'2011-10-27'),(2122,'g',0,'2012-02-17'),(2115,'g',0,'2012-02-04'),(1754,'g',0,'2011-10-27'),(2033,'g',0,'2012-02-04'),(1845,'g',0,'2011-10-28'),(2129,'g',0,'2011-10-28'),(2141,'g',0,'2011-10-28'),(2144,'g',0,'2011-10-28'),(2130,'g',0,'2011-10-28'),(1869,'g',0,'2011-10-28'),(1864,'g',0,'2012-02-06'),(1995,'g',0,'2011-10-28'),(1904,'g',0,'2011-10-28'),(1820,'g',0,'2011-10-28'),(2124,'g',0,'2011-10-28'),(1668,'g',0,'2011-10-28'),(2118,'g',0,'2011-10-28'),(2110,'g',0,'2011-10-28'),(1821,'g',0,'2011-10-28'),(1966,'g',0,'2011-10-28'),(2074,'g',0,'2011-12-08'),(2048,'g',0,'2011-12-08'),(2098,'g',0,'2011-12-08'),(2005,'g',0,'2011-12-08'),(2116,'g',0,'2011-12-08'),(2084,'g',0,'2011-10-28'),(2086,'g',0,'2011-10-28'),(1896,'g',0,'2011-10-29'),(1699,'g',0,'2011-10-29'),(1655,'g',0,'2011-10-29'),(1643,'g',0,'2011-10-29'),(1613,'g',0,'2011-10-29'),(1605,'g',0,'2011-10-29'),(2126,'g',0,'2012-02-16'),(2145,'g',0,'2011-10-29'),(1657,'g',0,'2012-02-27'),(1720,'g',0,'2011-12-16'),(2114,'g',0,'2011-10-29'),(2111,'g',0,'2011-10-29'),(1663,'g',0,'2011-10-29'),(1727,'g',0,'2011-10-29'),(1713,'g',0,'2011-10-29'),(2123,'g',0,'2011-10-29'),(2127,'g',0,'2012-02-20'),(759,'g',0,'2012-02-16'),(1653,'g',0,'2011-10-29'),(2146,'g',0,'2011-12-28'),(1667,'g',0,'2011-10-29'),(1787,'g',0,'2011-10-29'),(2078,'g',0,'2012-03-04'),(1660,'g',0,'2011-10-29'),(1894,'g',0,'2012-03-04'),(2041,'g',0,'2012-03-04'),(2000,'g',0,'2011-10-29'),(1647,'g',0,'2011-12-25'),(2100,'g',0,'2012-02-16'),(1610,'g',0,'2012-02-16'),(1728,'g',0,'2011-10-29'),(2082,'g',0,'2011-10-29'),(1607,'g',0,'2011-10-29'),(2056,'g',0,'2011-10-29'),(1757,'g',0,'2011-10-29'),(1927,'g',0,'2011-10-29'),(1611,'g',0,'2011-10-29'),(1955,'g',0,'2011-10-29'),(1601,'g',0,'2011-10-29'),(2163,'g',0,'2012-02-07'),(2155,'g',0,'2011-10-30'),(2176,'g',0,'2011-10-31'),(2013,'g',0,'2011-11-01'),(1973,'g',0,'2011-12-02'),(1975,'g',0,'2011-12-02'),(2009,'g',0,'2012-02-26'),(2012,'g',0,'2011-11-01'),(1999,'g',0,'2011-11-01'),(2007,'g',0,'2012-02-04'),(2001,'g',0,'2011-11-01'),(2003,'g',0,'2011-11-01'),(1997,'g',0,'2011-11-01'),(1826,'g',0,'2011-11-01'),(1843,'g',0,'2011-11-01'),(1851,'g',0,'2011-11-01'),(1850,'g',0,'2011-11-01'),(1848,'g',0,'2011-11-01'),(1847,'g',0,'2011-11-01'),(1841,'g',0,'2011-11-01'),(1853,'g',0,'2011-11-01'),(1830,'g',0,'2012-02-29'),(1842,'g',0,'2012-03-01'),(1856,'g',0,'2012-02-25'),(1724,'g',0,'2011-11-01'),(1857,'g',0,'2011-11-01'),(1680,'g',0,'2011-11-01'),(1859,'g',0,'2011-11-01'),(1687,'g',0,'2011-11-01'),(1829,'g',0,'2011-11-01'),(1854,'g',0,'2011-11-01'),(1725,'g',0,'2011-11-02'),(1779,'g',0,'2012-02-28'),(1740,'g',0,'2011-11-02'),(1718,'g',0,'2011-11-02'),(1737,'g',0,'2011-11-02'),(1812,'g',0,'2011-11-02'),(2150,'g',0,'2011-11-03'),(2165,'g',0,'2012-02-29'),(2166,'g',0,'2011-11-03'),(1882,'g',0,'2011-11-03'),(1615,'g',0,'2011-11-03'),(1893,'g',0,'2012-02-06'),(1679,'g',0,'2011-11-03'),(1631,'g',0,'2011-11-03'),(1675,'g',0,'2011-11-03'),(1919,'g',0,'2011-11-03'),(1892,'g',0,'2011-11-03'),(1694,'g',0,'2011-12-15'),(1745,'g',0,'2011-12-15'),(1833,'g',0,'2011-12-15'),(1827,'g',0,'2011-11-04'),(1867,'g',0,'2011-11-04'),(2065,'g',0,'2011-11-04'),(1942,'g',0,'2011-11-04'),(1875,'g',0,'2011-11-04'),(2031,'g',0,'2011-11-04'),(2174,'g',0,'2011-11-05'),(2170,'g',0,'2011-11-05'),(2159,'g',0,'2011-11-05'),(2158,'g',0,'2012-02-28'),(1778,'g',0,'2011-11-06'),(2109,'g',0,'2011-11-06'),(2135,'g',0,'2011-11-06'),(2140,'g',0,'2011-11-06'),(2138,'g',0,'2011-11-06'),(1813,'g',0,'2011-12-15'),(1835,'g',0,'2011-12-15'),(1836,'g',0,'2011-11-06'),(1872,'g',0,'2011-11-06'),(680,'g',0,'2011-12-16'),(685,'g',0,'2012-03-02'),(682,'g',0,'2011-11-06'),(686,'g',0,'2011-11-06'),(683,'g',0,'2011-12-14'),(677,'g',0,'2011-11-06'),(681,'g',0,'2011-11-06'),(684,'g',0,'2011-11-06'),(678,'g',0,'2011-11-06'),(224,'g',0,'2011-11-06'),(223,'g',0,'2011-11-06'),(655,'g',0,'2011-12-15'),(230,'g',0,'2011-11-06'),(217,'g',0,'2011-11-06'),(214,'g',0,'2011-11-06'),(226,'g',0,'2011-11-06'),(228,'g',0,'2011-11-06'),(213,'g',0,'2011-11-06'),(195,'g',0,'2011-12-14'),(219,'g',0,'2011-11-06'),(188,'g',0,'2011-12-14'),(192,'g',0,'2011-11-06'),(194,'g',0,'2011-11-06'),(191,'g',0,'2011-11-06'),(189,'g',0,'2011-12-15'),(193,'g',0,'2011-11-06'),(190,'g',0,'2011-11-06'),(187,'g',0,'2011-11-06'),(1664,'g',0,'2011-11-07'),(1870,'g',0,'2011-12-17'),(1722,'g',0,'2011-11-07'),(1634,'g',0,'2011-11-07'),(1644,'g',0,'2011-11-07'),(1742,'g',0,'2011-12-17'),(1642,'g',0,'2011-12-17'),(1709,'g',0,'2011-11-07'),(1750,'g',0,'2012-01-21'),(1716,'g',0,'2011-12-17'),(2177,'g',0,'2011-11-08'),(1792,'g',0,'2011-11-08'),(1780,'g',0,'2011-11-08'),(1844,'g',0,'2011-11-08'),(1775,'g',0,'2011-11-08'),(1759,'g',0,'2011-11-08'),(1784,'g',0,'2011-11-08'),(1795,'g',0,'2011-11-08'),(2042,'g',0,'2011-11-09'),(1889,'g',0,'2011-11-09'),(1948,'g',0,'2011-11-09'),(1887,'g',0,'2011-11-09'),(1888,'g',0,'2011-11-09'),(2052,'g',0,'2011-11-09'),(1886,'g',0,'2011-11-09'),(1953,'g',0,'2011-11-09'),(1861,'g',0,'2011-11-09'),(1766,'g',0,'2011-11-09'),(1769,'g',0,'2011-11-09'),(1768,'g',0,'2011-11-09'),(1776,'g',0,'2011-11-09'),(1767,'g',0,'2011-11-09'),(1951,'g',0,'2011-11-11'),(1961,'g',0,'2011-11-11'),(1971,'g',0,'2011-11-11'),(1900,'g',0,'2011-11-11'),(1909,'g',0,'2011-11-11'),(1985,'g',0,'2011-11-11'),(1962,'g',0,'2011-11-11'),(1958,'g',0,'2011-11-11'),(1987,'g',0,'2011-11-11'),(1899,'g',0,'2011-11-11'),(1860,'g',0,'2011-11-13'),(1862,'g',0,'2011-11-13'),(1721,'g',0,'2011-11-13'),(1684,'g',0,'2011-11-13'),(1794,'g',0,'2011-11-13'),(1695,'g',0,'2011-11-13'),(662,'g',0,'2011-12-15'),(656,'g',0,'2011-12-27'),(658,'g',0,'2011-12-15'),(664,'g',0,'2012-02-25'),(665,'g',0,'2011-12-27'),(660,'g',0,'2011-12-27'),(657,'g',0,'2011-12-27'),(666,'g',0,'2011-12-27'),(663,'g',0,'2011-12-15'),(661,'g',0,'2011-12-27'),(2131,'g',0,'2011-11-14'),(2139,'g',0,'2011-11-14'),(2162,'g',0,'2011-11-14'),(2172,'g',0,'2011-11-14'),(2154,'g',0,'2011-11-14'),(2168,'g',0,'2011-11-14'),(2164,'g',0,'2011-11-14'),(2104,'g',0,'2011-11-14'),(2112,'g',0,'2011-12-15'),(2161,'g',0,'2011-11-14'),(2151,'g',0,'2011-11-14'),(2175,'g',0,'2011-11-14'),(2157,'g',0,'2011-11-14'),(2134,'g',0,'2011-11-14'),(2167,'g',0,'2011-11-14'),(2153,'g',0,'2011-11-14'),(2152,'g',0,'2011-12-16'),(2171,'g',0,'2011-11-14'),(2088,'g',0,'2011-11-14'),(2169,'g',0,'2011-11-14'),(2107,'g',0,'2011-11-14'),(2106,'g',0,'2011-11-14'),(2103,'g',0,'2011-11-14'),(2143,'g',0,'2011-11-14'),(2160,'g',0,'2011-11-14'),(2113,'g',0,'2011-12-15'),(2147,'g',0,'2011-11-14'),(2097,'g',0,'2011-11-14'),(2149,'g',0,'2011-11-14'),(2148,'g',0,'2011-11-14'),(2265,'g',0,'2011-11-15'),(2249,'g',0,'2011-11-15'),(2252,'g',0,'2011-11-15'),(2246,'g',0,'2011-11-15'),(2266,'g',0,'2011-11-15'),(2215,'g',0,'2011-11-15'),(2233,'g',0,'2011-11-15'),(2187,'g',0,'2011-11-16'),(1789,'g',0,'2011-11-16'),(1786,'g',0,'2011-11-16'),(1815,'g',0,'2011-11-16'),(1819,'g',0,'2011-11-16'),(80,'g',0,'2011-11-16'),(75,'g',0,'2011-11-16'),(77,'g',0,'2011-11-16'),(143,'g',0,'2011-11-16'),(142,'g',0,'2011-11-16'),(182,'g',0,'2011-11-16'),(149,'g',0,'2011-11-16'),(2089,'g',0,'2011-11-16'),(2091,'g',0,'2011-11-16'),(79,'g',0,'2011-11-16'),(185,'g',0,'2011-11-16'),(125,'g',0,'2012-02-28'),(215,'g',0,'2011-11-16'),(2094,'g',0,'2011-11-16'),(2096,'g',0,'2011-11-16'),(2064,'g',0,'2011-11-16'),(2029,'g',0,'2011-11-16'),(2128,'g',0,'2011-11-16'),(2090,'g',0,'2011-11-16'),(2093,'g',0,'2011-11-16'),(668,'g',0,'2011-11-16'),(669,'g',0,'2011-11-16'),(672,'g',0,'2011-11-16'),(671,'g',0,'2011-12-16'),(673,'g',0,'2011-11-16'),(676,'g',0,'2011-11-16'),(207,'g',0,'2011-11-16'),(198,'g',0,'2011-11-16'),(161,'g',0,'2011-11-16'),(136,'g',0,'2011-11-16'),(164,'g',0,'2011-11-16'),(172,'g',0,'2011-12-27'),(174,'g',0,'2011-11-16'),(111,'g',0,'2011-11-16'),(171,'g',0,'2011-12-27'),(202,'g',0,'2011-12-16'),(197,'g',0,'2011-11-16'),(205,'g',0,'2011-11-16'),(163,'g',0,'2011-11-16'),(199,'g',0,'2011-11-16'),(674,'g',0,'2011-11-16'),(208,'g',0,'2011-11-16'),(158,'g',0,'2011-12-16'),(210,'g',0,'2011-11-16'),(133,'g',0,'2011-11-16'),(166,'g',0,'2011-11-16'),(176,'g',0,'2011-11-16'),(183,'g',0,'2011-11-16'),(184,'g',0,'2011-12-27'),(170,'g',0,'2011-11-16'),(137,'g',0,'2011-11-16'),(177,'g',0,'2011-12-27'),(154,'g',0,'2011-11-16'),(706,'g',0,'2011-11-16'),(691,'g',0,'2011-11-16'),(708,'g',0,'2011-11-16'),(716,'g',0,'2011-12-16'),(710,'g',0,'2011-11-16'),(711,'g',0,'2011-11-16'),(701,'g',0,'2011-11-16'),(689,'g',0,'2011-11-16'),(694,'g',0,'2012-03-03'),(688,'g',0,'2011-11-16'),(712,'g',0,'2011-11-16'),(695,'g',0,'2011-11-16'),(723,'g',0,'2011-11-16'),(700,'g',0,'2011-11-16'),(702,'g',0,'2011-11-16'),(724,'g',0,'2011-11-16'),(699,'g',0,'2012-02-29'),(705,'g',0,'2011-11-16'),(697,'g',0,'2011-11-16'),(718,'g',0,'2011-11-16'),(687,'g',0,'2011-11-16'),(715,'g',0,'2011-11-16'),(725,'g',0,'2011-11-16'),(720,'g',0,'2011-11-16'),(753,'g',0,'2011-11-16'),(754,'g',0,'2012-03-02'),(751,'g',0,'2011-11-16'),(755,'g',0,'2011-11-16'),(764,'g',0,'2011-11-16'),(768,'g',0,'2011-12-16'),(785,'g',0,'2011-12-16'),(786,'g',0,'2011-11-16'),(750,'g',0,'2011-11-16'),(762,'g',0,'2011-11-16'),(763,'g',0,'2012-03-06'),(765,'g',0,'2011-11-16'),(772,'g',0,'2011-11-16'),(757,'g',0,'2011-11-16'),(756,'g',0,'2011-11-16'),(784,'g',0,'2011-11-16'),(769,'g',0,'2011-12-16'),(780,'g',0,'2011-11-16'),(779,'g',0,'2012-02-25'),(777,'g',0,'2012-03-03'),(767,'g',0,'2011-11-16'),(728,'g',0,'2011-11-16'),(781,'g',0,'2011-11-16'),(729,'g',0,'2011-12-16'),(782,'g',0,'2011-11-16'),(76,'g',0,'2011-11-16'),(78,'g',0,'2011-11-16'),(212,'g',0,'2011-12-16'),(146,'g',0,'2011-11-16'),(134,'g',0,'2012-02-28'),(81,'g',0,'2011-11-16'),(2095,'g',0,'2011-11-16'),(2092,'g',0,'2011-11-16'),(2053,'g',0,'2011-11-16'),(2173,'g',0,'2012-03-05'),(667,'g',0,'2011-11-16'),(675,'g',0,'2012-03-05'),(670,'g',0,'2011-11-16'),(107,'g',0,'2011-11-16'),(162,'g',0,'2011-11-16'),(178,'g',0,'2011-11-16'),(165,'g',0,'2011-11-16'),(173,'g',0,'2011-11-16'),(175,'g',0,'2011-12-27'),(131,'g',0,'2011-11-16'),(147,'g',0,'2011-11-16'),(159,'g',0,'2012-03-02'),(200,'g',0,'2011-11-16'),(160,'g',0,'2011-12-25'),(168,'g',0,'2011-12-16'),(167,'g',0,'2011-11-16'),(203,'g',0,'2011-11-16'),(693,'g',0,'2011-11-16'),(717,'g',0,'2011-11-16'),(696,'g',0,'2011-11-16'),(704,'g',0,'2011-11-16'),(709,'g',0,'2011-11-16'),(703,'g',0,'2011-11-16'),(726,'g',0,'2011-11-16'),(714,'g',0,'2012-03-04'),(692,'g',0,'2011-11-16'),(690,'g',0,'2011-11-16'),(713,'g',0,'2011-11-16'),(719,'g',0,'2011-11-16'),(698,'g',0,'2011-11-16'),(722,'g',0,'2011-11-16'),(707,'g',0,'2011-11-16'),(721,'g',0,'2012-03-03'),(2235,'g',0,'2011-11-16'),(773,'g',0,'2011-11-16'),(730,'g',0,'2011-11-16'),(2217,'g',0,'2011-11-16'),(727,'g',0,'2011-11-16'),(778,'g',0,'2011-11-16'),(789,'g',0,'2011-11-16'),(783,'g',0,'2011-11-16'),(2216,'g',0,'2011-11-16'),(787,'g',0,'2011-11-16'),(774,'g',0,'2011-11-16'),(766,'g',0,'2011-11-16'),(752,'g',0,'2011-11-16'),(788,'g',0,'2011-11-16'),(758,'g',0,'2011-11-16'),(2271,'g',0,'2011-11-16'),(2260,'g',0,'2011-11-17'),(2264,'g',0,'2011-11-17'),(2241,'g',0,'2011-11-17'),(2244,'g',0,'2011-11-17'),(2250,'g',0,'2011-11-17'),(2258,'g',0,'2011-11-17'),(2230,'g',0,'2011-11-17'),(2253,'g',0,'2011-11-17'),(2263,'g',0,'2011-11-17'),(2259,'g',0,'2011-11-17'),(2248,'g',0,'2011-11-17'),(2269,'g',0,'2011-11-18'),(2195,'g',0,'2011-11-18'),(2262,'g',0,'2011-11-18'),(2242,'g',0,'2011-11-18'),(2270,'g',0,'2011-11-18'),(2208,'g',0,'2011-11-18'),(2224,'g',0,'2011-11-18'),(2186,'g',0,'2011-11-18'),(2184,'g',0,'2011-11-18'),(2247,'g',0,'2011-11-18'),(2185,'g',0,'2011-11-18'),(2201,'g',0,'2011-11-18'),(2204,'g',0,'2011-11-18'),(1954,'g',0,'2011-11-18'),(1986,'g',0,'2011-11-18'),(2027,'g',0,'2011-11-18'),(1982,'g',0,'2011-11-18'),(1943,'g',0,'2011-11-18'),(1984,'g',0,'2011-11-18'),(2022,'g',0,'2011-11-18'),(2024,'g',0,'2011-11-18'),(2026,'g',0,'2011-11-18'),(1996,'g',0,'2011-11-18'),(2199,'g',0,'2011-11-18'),(2214,'g',0,'2011-11-18'),(2179,'g',0,'2011-11-18'),(2196,'g',0,'2011-11-18'),(2180,'g',0,'2011-11-18'),(2181,'g',0,'2011-11-18'),(2183,'g',0,'2011-11-18'),(2198,'g',0,'2011-11-18'),(2182,'g',0,'2011-11-18'),(2197,'g',0,'2011-11-19'),(2251,'g',0,'2011-11-19'),(2255,'g',0,'2011-11-19'),(1947,'g',0,'2011-11-19'),(2040,'g',0,'2011-11-19'),(2101,'g',0,'2012-01-26'),(2070,'g',0,'2012-01-26'),(1692,'g',0,'2011-11-19'),(1700,'g',0,'2011-11-19'),(1717,'g',0,'2011-11-19'),(1880,'g',0,'2011-11-19'),(2125,'g',0,'2012-01-26'),(2268,'g',0,'2011-11-20'),(2267,'g',0,'2011-11-20'),(2018,'g',0,'2011-11-20'),(1998,'g',0,'2011-11-20'),(2006,'g',0,'2011-11-20'),(2004,'g',0,'2011-11-20'),(2010,'g',0,'2011-11-20'),(1991,'g',0,'2011-11-20'),(2016,'g',0,'2011-11-20'),(1980,'g',0,'2011-11-20'),(1994,'g',0,'2011-11-20'),(2256,'g',0,'2011-11-20'),(1981,'g',0,'2011-11-20'),(2213,'g',0,'2011-11-20'),(2190,'g',0,'2011-11-20'),(2257,'g',0,'2011-11-20'),(2245,'g',0,'2011-11-20'),(2239,'g',0,'2011-11-20'),(1840,'g',0,'2011-11-20'),(1839,'g',0,'2011-11-20'),(1838,'g',0,'2011-11-20'),(1837,'g',0,'2011-11-20'),(2063,'g',0,'2011-11-20'),(2032,'g',0,'2011-11-20'),(2066,'g',0,'2011-11-20'),(2037,'g',0,'2011-11-20'),(2192,'g',0,'2011-11-20'),(2054,'g',0,'2011-11-20'),(2254,'g',0,'2011-11-20'),(2261,'g',0,'2011-11-20'),(1916,'g',0,'2011-11-20'),(2227,'g',0,'2011-11-20'),(2035,'g',0,'2011-11-20'),(1977,'g',0,'2011-11-20'),(2020,'g',0,'2011-11-20'),(1926,'g',0,'2011-11-20'),(2038,'g',0,'2011-11-20'),(1952,'g',0,'2011-11-20'),(2044,'g',0,'2011-12-28'),(1930,'g',0,'2011-11-20'),(1932,'g',0,'2011-11-20'),(1964,'g',0,'2011-11-20'),(2047,'g',0,'2011-11-20'),(1924,'g',0,'2011-11-20'),(1929,'g',0,'2011-11-20'),(1917,'g',0,'2011-11-20'),(1978,'g',0,'2011-11-20'),(2051,'g',0,'2011-11-20'),(1959,'g',0,'2011-11-20'),(2212,'g',0,'2011-11-20'),(2232,'g',0,'2011-11-20'),(2237,'g',0,'2011-11-21'),(2205,'g',0,'2011-11-21'),(2221,'g',0,'2011-11-21'),(2193,'g',0,'2011-11-21'),(2231,'g',0,'2011-11-21'),(2228,'g',0,'2011-11-21'),(2218,'g',0,'2011-11-21'),(2236,'g',0,'2011-11-21'),(2234,'g',0,'2011-11-21'),(1950,'g',0,'2011-11-21'),(2238,'g',0,'2011-11-21'),(1979,'g',0,'2011-11-21'),(2019,'g',0,'2011-11-21'),(1957,'g',0,'2011-11-21'),(2008,'g',0,'2011-11-21'),(1949,'g',0,'2011-11-21'),(2017,'g',0,'2011-11-21'),(2015,'g',0,'2011-11-21'),(1976,'g',0,'2011-11-21'),(2014,'g',0,'2011-11-21'),(2085,'g',0,'2011-11-21'),(2080,'g',0,'2011-11-21'),(2072,'g',0,'2011-11-21'),(2060,'g',0,'2011-11-21'),(2061,'g',0,'2011-11-21'),(2062,'g',0,'2011-11-21'),(2087,'g',0,'2011-11-21'),(2068,'g',0,'2012-03-02'),(2073,'g',0,'2011-11-21'),(2081,'g',0,'2011-11-21'),(1650,'g',0,'2011-11-21'),(1603,'g',0,'2011-11-21'),(1597,'g',0,'2011-11-21'),(1629,'g',0,'2012-02-29'),(1676,'g',0,'2011-11-21'),(1648,'g',0,'2011-11-21'),(1614,'g',0,'2011-11-21'),(1620,'g',0,'2011-11-21'),(1618,'g',0,'2011-11-21'),(1609,'g',0,'2011-11-21'),(1935,'g',0,'2011-11-21'),(1890,'g',0,'2011-11-21'),(1936,'g',0,'2011-11-21'),(1934,'g',0,'2011-11-21'),(1931,'g',0,'2011-11-21'),(1937,'g',0,'2011-11-21'),(1939,'g',0,'2011-11-21'),(1914,'g',0,'2011-11-21'),(1945,'g',0,'2011-11-21'),(1938,'g',0,'2011-11-21'),(2023,'g',0,'2011-11-21'),(2057,'g',0,'2011-11-21'),(2025,'g',0,'2011-11-21'),(2059,'g',0,'2011-11-21'),(2021,'g',0,'2011-11-21'),(2036,'g',0,'2011-11-21'),(2046,'g',0,'2011-11-21'),(2055,'g',0,'2011-11-21'),(2049,'g',0,'2011-11-21'),(2045,'g',0,'2011-11-21'),(1915,'g',0,'2011-11-21'),(1596,'g',0,'2011-11-22'),(1897,'g',0,'2011-11-22'),(1878,'g',0,'2011-11-22'),(1881,'g',0,'2011-11-22'),(1902,'g',0,'2011-11-22'),(1816,'g',0,'2011-11-22'),(1802,'g',0,'2011-11-22'),(1846,'g',0,'2011-11-22'),(1828,'g',0,'2012-02-24'),(1806,'g',0,'2011-11-23'),(1804,'g',0,'2012-02-21'),(1755,'g',0,'2011-11-23'),(1783,'g',0,'2011-11-23'),(1762,'g',0,'2011-11-23'),(1814,'g',0,'2011-11-23'),(1708,'g',0,'2011-11-23'),(1823,'g',0,'2011-11-23'),(1738,'g',0,'2011-11-23'),(1749,'g',0,'2011-11-23'),(1908,'g',0,'2011-11-23'),(1910,'g',0,'2011-11-23'),(1969,'g',0,'2011-11-23'),(1911,'g',0,'2011-11-23'),(1967,'g',0,'2011-11-23'),(1933,'g',0,'2011-11-23'),(1970,'g',0,'2011-11-23'),(1968,'g',0,'2011-11-23'),(1941,'g',0,'2011-11-23'),(1913,'g',0,'2011-11-23'),(1990,'g',0,'2011-11-23'),(1928,'g',0,'2011-11-23'),(1923,'g',0,'2011-11-23'),(1922,'g',0,'2011-11-23'),(1920,'g',0,'2011-11-23'),(2281,'g',0,'2011-11-23'),(1940,'g',0,'2011-11-23'),(2438,'g',0,'2012-01-24'),(2420,'g',0,'2012-01-24'),(2415,'g',0,'2012-01-24'),(2459,'g',0,'2012-03-06'),(1925,'g',0,'2011-11-23'),(2503,'g',0,'2012-03-06'),(2280,'g',0,'2012-01-25'),(2278,'g',0,'2012-01-25'),(2405,'g',0,'2012-01-25'),(2450,'g',0,'2012-01-25'),(2498,'g',0,'2012-02-16'),(2519,'g',0,'2012-02-16'),(2418,'g',0,'2012-02-16'),(2445,'g',0,'2011-11-23'),(2518,'g',0,'2011-11-23'),(2429,'g',0,'2011-11-23'),(2455,'g',0,'2011-11-23'),(2440,'g',0,'2011-11-23'),(2414,'g',0,'2011-11-24'),(2301,'g',0,'2011-11-24'),(2502,'g',0,'2012-02-15'),(2486,'g',0,'2012-02-15'),(2494,'g',0,'2011-12-30'),(2508,'g',0,'2012-02-15'),(2515,'g',0,'2012-02-15'),(2516,'g',0,'2012-02-15'),(2517,'g',0,'2012-02-15'),(2397,'g',0,'2011-11-24'),(2297,'g',0,'2011-11-24'),(2296,'g',0,'2011-11-24'),(2407,'g',0,'2011-11-24'),(2381,'g',0,'2011-11-24'),(2481,'g',0,'2011-11-24'),(1681,'g',0,'2011-11-24'),(2509,'g',0,'2011-11-24'),(1690,'g',0,'2011-11-24'),(1693,'g',0,'2011-11-24'),(1654,'g',0,'2011-11-24'),(1874,'g',0,'2011-11-24'),(2412,'g',0,'2012-01-27'),(2522,'g',0,'2012-02-07'),(2520,'g',0,'2012-02-07'),(2391,'g',0,'2012-02-16'),(1871,'g',0,'2011-11-24'),(1646,'g',0,'2011-11-24'),(1659,'g',0,'2011-11-24'),(1885,'g',0,'2011-11-24'),(1661,'g',0,'2011-11-24'),(1636,'g',0,'2012-03-06'),(1598,'g',0,'2011-11-24'),(1645,'g',0,'2011-11-24'),(2417,'g',0,'2012-02-04'),(2484,'g',0,'2012-02-04'),(2404,'g',0,'2012-02-04'),(2441,'g',0,'2012-02-04'),(2449,'g',0,'2012-02-04'),(2499,'g',0,'2011-12-28'),(2411,'g',0,'2012-02-04'),(2493,'g',0,'2012-02-04'),(2512,'g',0,'2011-11-24'),(2492,'g',0,'2011-11-24'),(2511,'g',0,'2011-11-24'),(2490,'g',0,'2011-11-24'),(2428,'g',0,'2011-11-24'),(2510,'g',0,'2011-11-24'),(2467,'g',0,'2011-11-24'),(2491,'g',0,'2011-11-24'),(2359,'g',0,'2011-11-24'),(2478,'g',0,'2011-11-24'),(2409,'g',0,'2011-11-24'),(2362,'g',0,'2011-11-24'),(2379,'g',0,'2011-11-24'),(2487,'g',0,'2011-11-24'),(2500,'g',0,'2011-11-24'),(2447,'g',0,'2011-11-24'),(2454,'g',0,'2011-11-24'),(1747,'g',0,'2011-11-24'),(1793,'g',0,'2011-11-24'),(1868,'g',0,'2011-11-24'),(2334,'g',0,'2011-11-24'),(2286,'g',0,'2011-11-24'),(2335,'g',0,'2012-02-28'),(2332,'g',0,'2011-11-24'),(2333,'g',0,'2011-11-24'),(2284,'g',0,'2011-11-24'),(2497,'g',0,'2011-11-24'),(2437,'g',0,'2012-03-04'),(2474,'g',0,'2011-11-25'),(2432,'g',0,'2011-11-25'),(2453,'g',0,'2011-11-25'),(2489,'g',0,'2011-11-25'),(2451,'g',0,'2011-11-25'),(2374,'g',0,'2012-01-27'),(2388,'g',0,'2012-03-01'),(2496,'g',0,'2011-11-25'),(2477,'g',0,'2011-11-25'),(2513,'g',0,'2011-11-25'),(2514,'g',0,'2011-11-25'),(2504,'g',0,'2012-02-15'),(2501,'g',0,'2012-02-15'),(2463,'g',0,'2011-11-26'),(2462,'g',0,'2011-11-26'),(2431,'g',0,'2011-11-26'),(2410,'g',0,'2011-11-26'),(2398,'g',0,'2011-11-26'),(2303,'g',0,'2011-11-26'),(2482,'g',0,'2011-11-26'),(2506,'g',0,'2011-11-26'),(2461,'g',0,'2011-11-26'),(2473,'g',0,'2011-11-26'),(2466,'g',0,'2011-11-26'),(2479,'g',0,'2011-11-26'),(2465,'g',0,'2011-11-26'),(2464,'g',0,'2011-11-26'),(2495,'g',0,'2011-11-26'),(2488,'g',0,'2012-01-24'),(2439,'g',0,'2012-02-16'),(2483,'g',0,'2012-01-24'),(2505,'g',0,'2012-02-16'),(2344,'g',0,'2011-11-28'),(2331,'g',0,'2011-11-28'),(2380,'g',0,'2012-03-01'),(2342,'g',0,'2011-11-28'),(2330,'g',0,'2011-11-28'),(2341,'g',0,'2011-11-28'),(2395,'g',0,'2011-11-28'),(2329,'g',0,'2011-11-28'),(2343,'g',0,'2011-11-28'),(2340,'g',0,'2011-11-28'),(1703,'g',0,'2011-11-29'),(1705,'g',0,'2011-11-29'),(2534,'g',0,'2011-11-29'),(2532,'g',0,'2012-03-03'),(2528,'g',0,'2012-02-02'),(2535,'g',0,'2011-11-29'),(2530,'g',0,'2012-03-03'),(2531,'g',0,'2012-02-02'),(2533,'g',0,'2012-02-02'),(2529,'g',0,'2012-03-03'),(2527,'g',0,'2012-02-02'),(2526,'g',0,'2012-02-02'),(2351,'g',0,'2011-12-01'),(2352,'g',0,'2011-12-01'),(2363,'g',0,'2011-12-01'),(2355,'g',0,'2011-12-01'),(2434,'g',0,'2011-12-01'),(2436,'g',0,'2011-12-01'),(2433,'g',0,'2011-12-01'),(2446,'g',0,'2011-12-01'),(2274,'g',0,'2012-01-26'),(2276,'g',0,'2012-01-26'),(2275,'g',0,'2012-01-26'),(2294,'g',0,'2012-01-26'),(2273,'g',0,'2012-01-26'),(2277,'g',0,'2012-01-26'),(2402,'g',0,'2011-12-01'),(2422,'g',0,'2011-12-01'),(2413,'g',0,'2011-12-01'),(2400,'g',0,'2011-12-01'),(2435,'g',0,'2011-12-01'),(2399,'g',0,'2011-12-01'),(2300,'g',0,'2011-12-01'),(2307,'g',0,'2011-12-01'),(2304,'g',0,'2011-12-01'),(2354,'g',0,'2011-12-01'),(2306,'g',0,'2011-12-01'),(2373,'g',0,'2011-12-01'),(2383,'g',0,'2011-12-01'),(2305,'g',0,'2011-12-01'),(2386,'g',0,'2011-12-01'),(1918,'g',0,'2011-12-01'),(2385,'g',0,'2011-12-01'),(2348,'g',0,'2011-12-01'),(2291,'g',0,'2011-12-01'),(2384,'g',0,'2011-12-01'),(2369,'g',0,'2011-12-01'),(2460,'g',0,'2011-12-02'),(2452,'g',0,'2011-12-02'),(2485,'g',0,'2011-12-02'),(2468,'g',0,'2011-12-02'),(2370,'g',0,'2011-12-02'),(2345,'g',0,'2011-12-02'),(2223,'g',0,'2011-12-02'),(2225,'g',0,'2011-12-02'),(2226,'g',0,'2011-12-02'),(2371,'g',0,'2011-12-02'),(2209,'g',0,'2011-12-02'),(2367,'g',0,'2011-12-02'),(2507,'g',0,'2011-12-02'),(2458,'g',0,'2011-12-02'),(2448,'g',0,'2012-02-04'),(2456,'g',0,'2011-12-02'),(2424,'g',0,'2011-12-02'),(2426,'g',0,'2011-12-02'),(2408,'g',0,'2011-12-02'),(2457,'g',0,'2011-12-02'),(1972,'g',0,'2011-12-02'),(790,'g',0,'2011-12-04'),(792,'g',0,'2011-12-04'),(795,'g',0,'2011-12-04'),(798,'g',0,'2011-12-04'),(793,'g',0,'2011-12-04'),(797,'g',0,'2011-12-04'),(794,'g',0,'2011-12-04'),(796,'g',0,'2011-12-04'),(799,'g',0,'2011-12-04'),(791,'g',0,'2011-12-04'),(803,'g',0,'2011-12-04'),(801,'g',0,'2011-12-04'),(800,'g',0,'2011-12-04'),(802,'g',0,'2011-12-04'),(2156,'g',0,'2011-12-04'),(2133,'g',0,'2011-12-04'),(2132,'g',0,'2011-12-04'),(2121,'g',0,'2011-12-04'),(2120,'g',0,'2011-12-04'),(2119,'g',0,'2011-12-04'),(2099,'g',0,'2011-12-04'),(1965,'g',0,'2011-12-04'),(2079,'g',0,'2011-12-04'),(2117,'g',0,'2011-12-04'),(1960,'g',0,'2011-12-04'),(1992,'g',0,'2011-12-04'),(2039,'g',0,'2011-12-04'),(2069,'g',0,'2011-12-04'),(1983,'g',0,'2011-12-04'),(2058,'g',0,'2011-12-04'),(1903,'g',0,'2011-12-04'),(1632,'g',0,'2011-12-04'),(1946,'g',0,'2011-12-04'),(1898,'g',0,'2011-12-04'),(1956,'g',0,'2011-12-04'),(1877,'g',0,'2011-12-04'),(1621,'g',0,'2011-12-04'),(1585,'g',0,'2011-12-04'),(1633,'g',0,'2011-12-04'),(1891,'g',0,'2011-12-04'),(2469,'g',0,'2012-02-24'),(2549,'g',0,'2011-12-06'),(2584,'g',0,'2011-12-06'),(2324,'g',0,'2011-12-06'),(2328,'g',0,'2011-12-06'),(2321,'g',0,'2011-12-06'),(2320,'g',0,'2011-12-06'),(2326,'g',0,'2011-12-06'),(2325,'g',0,'2011-12-06'),(2319,'g',0,'2011-12-06'),(2327,'g',0,'2011-12-06'),(2323,'g',0,'2011-12-06'),(2322,'g',0,'2011-12-06'),(1849,'g',0,'2011-12-06'),(1730,'g',0,'2011-12-06'),(1731,'g',0,'2011-12-06'),(1818,'g',0,'2011-12-06'),(2316,'g',0,'2011-12-06'),(2317,'g',0,'2011-12-06'),(2318,'g',0,'2011-12-06'),(2309,'g',0,'2011-12-06'),(2312,'g',0,'2011-12-06'),(2279,'g',0,'2011-12-06'),(2539,'g',0,'2011-12-06'),(2576,'g',0,'2011-12-06'),(2543,'g',0,'2011-12-06'),(2361,'g',0,'2011-12-07'),(2191,'g',0,'2011-12-07'),(2285,'g',0,'2011-12-07'),(2302,'g',0,'2011-12-08'),(2585,'g',0,'2011-12-08'),(2292,'g',0,'2011-12-08'),(2390,'g',0,'2011-12-08'),(2372,'g',0,'2011-12-08'),(2378,'g',0,'2011-12-08'),(2578,'g',0,'2011-12-08'),(2577,'g',0,'2011-12-08'),(2548,'g',0,'2011-12-08'),(2545,'g',0,'2011-12-08'),(2587,'g',0,'2011-12-08'),(2579,'g',0,'2011-12-08'),(2555,'g',0,'2011-12-08'),(2442,'g',0,'2011-12-08'),(2443,'g',0,'2011-12-08'),(2444,'g',0,'2011-12-08'),(2315,'g',0,'2011-12-08'),(2396,'g',0,'2011-12-08'),(2339,'g',0,'2011-12-08'),(2368,'g',0,'2011-12-08'),(2298,'g',0,'2011-12-08'),(2299,'g',0,'2011-12-08'),(2295,'g',0,'2011-12-08'),(2289,'g',0,'2011-12-08'),(2580,'g',0,'2012-02-15'),(2615,'g',0,'2011-12-10'),(2616,'g',0,'2011-12-10'),(2564,'g',0,'2012-02-01'),(2562,'g',0,'2012-02-01'),(2542,'g',0,'2011-12-13'),(2593,'g',0,'2011-12-13'),(2552,'g',0,'2011-12-13'),(2583,'g',0,'2011-12-13'),(2641,'g',0,'2011-12-13'),(2419,'g',0,'2012-03-04'),(1698,'g',0,'2011-12-14'),(2337,'g',0,'2011-12-14'),(1809,'g',0,'2011-12-14'),(2349,'g',0,'2011-12-14'),(2336,'g',0,'2011-12-14'),(2393,'g',0,'2012-03-04'),(2421,'g',0,'2012-03-04'),(2425,'g',0,'2012-03-04'),(2375,'g',0,'2012-03-04'),(2427,'g',0,'2012-03-04'),(2403,'g',0,'2012-03-04'),(2633,'g',0,'2011-12-14'),(2621,'g',0,'2011-12-14'),(2639,'g',0,'2011-12-14'),(1677,'g',0,'2011-12-14'),(1671,'g',0,'2011-12-14'),(2541,'g',0,'2011-12-15'),(2586,'g',0,'2011-12-15'),(2547,'g',0,'2011-12-15'),(1863,'g',0,'2011-12-15'),(1805,'g',0,'2011-12-15'),(1599,'g',0,'2011-12-15'),(1641,'g',0,'2011-12-15'),(1674,'g',0,'2011-12-15'),(1689,'g',0,'2011-12-15'),(1649,'g',0,'2011-12-15'),(1702,'g',0,'2011-12-15'),(1810,'g',0,'2011-12-15'),(1672,'g',0,'2011-12-15'),(1686,'g',0,'2011-12-15'),(2423,'g',0,'2011-12-15'),(2480,'g',0,'2011-12-15'),(2475,'g',0,'2011-12-15'),(2574,'g',0,'2011-12-15'),(1866,'g',0,'2011-12-15'),(1858,'g',0,'2011-12-15'),(1811,'g',0,'2011-12-16'),(1678,'g',0,'2011-12-16'),(1808,'g',0,'2011-12-16'),(1673,'g',0,'2011-12-16'),(2649,'g',0,'2012-02-02'),(2628,'g',0,'2012-02-15'),(2629,'g',0,'2012-02-15'),(2627,'g',0,'2012-02-15'),(2630,'g',0,'2012-02-15'),(2642,'g',0,'2011-12-19'),(2662,'g',0,'2011-12-19'),(2680,'g',0,'2011-12-19'),(2632,'g',0,'2011-12-20'),(2643,'g',0,'2012-02-17'),(2679,'g',0,'2011-12-21'),(2687,'g',0,'2011-12-21'),(1873,'g',0,'2011-12-21'),(1711,'g',0,'2011-12-21'),(1800,'g',0,'2011-12-21'),(1770,'g',0,'2011-12-21'),(1753,'g',0,'2011-12-21'),(1739,'g',0,'2011-12-21'),(2631,'g',0,'2011-12-21'),(2553,'g',0,'2011-12-21'),(2525,'g',0,'2011-12-21'),(2692,'g',0,'2012-01-24'),(2609,'g',0,'2011-12-21'),(2524,'g',0,'2011-12-21'),(2313,'g',0,'2011-12-21'),(2376,'g',0,'2011-12-22'),(2287,'g',0,'2011-12-22'),(2382,'g',0,'2011-12-22'),(2360,'g',0,'2011-12-22'),(2723,'g',0,'2011-12-22'),(2665,'g',0,'2012-03-04'),(2605,'g',0,'2011-12-22'),(2610,'g',0,'2011-12-22'),(2708,'g',0,'2011-12-22'),(2392,'g',0,'2011-12-22'),(2366,'g',0,'2011-12-22'),(2387,'g',0,'2011-12-22'),(2356,'g',0,'2011-12-22'),(2389,'g',0,'2011-12-22'),(1591,'g',0,'2011-12-22'),(1884,'g',0,'2011-12-22'),(1583,'g',0,'2011-12-22'),(1587,'g',0,'2011-12-22'),(2719,'g',0,'2012-03-06'),(2683,'g',0,'2011-12-24'),(2728,'g',0,'2012-02-16'),(2551,'g',0,'2011-12-25'),(2607,'g',0,'2011-12-25'),(2711,'g',0,'2011-12-25'),(2672,'g',0,'2011-12-25'),(2721,'g',0,'2011-12-25'),(2710,'g',0,'2011-12-25'),(2761,'g',0,'2011-12-26'),(2565,'g',0,'2012-02-01'),(2567,'g',0,'2012-02-01'),(2568,'g',0,'2011-12-26'),(2563,'g',0,'2012-02-01'),(2566,'g',0,'2012-02-01'),(1801,'g',0,'2011-12-26'),(1803,'g',0,'2011-12-26'),(2694,'g',0,'2011-12-27'),(2758,'g',0,'2011-12-27'),(2739,'g',0,'2011-12-27'),(2756,'g',0,'2011-12-27'),(2748,'g',0,'2011-12-27'),(2749,'g',0,'2011-12-27'),(2724,'g',0,'2011-12-27'),(2740,'g',0,'2011-12-27'),(2743,'g',0,'2011-12-27'),(2707,'g',0,'2011-12-27'),(2701,'g',0,'2011-12-27'),(2706,'g',0,'2011-12-27'),(2715,'g',0,'2012-02-16'),(2734,'g',0,'2012-02-16'),(2730,'g',0,'2011-12-28'),(2590,'g',0,'2011-12-29'),(2540,'g',0,'2011-12-29'),(2625,'g',0,'2011-12-29'),(2636,'g',0,'2011-12-29'),(2667,'g',0,'2011-12-29'),(2669,'g',0,'2011-12-29'),(2648,'g',0,'2011-12-29'),(2645,'g',0,'2011-12-30'),(2780,'g',0,'2011-12-31'),(2785,'g',0,'2012-02-01'),(2784,'g',0,'2012-02-15'),(2747,'g',0,'2011-12-31'),(2768,'g',0,'2012-03-03'),(2742,'g',0,'2012-01-02'),(2731,'g',0,'2012-01-02'),(2626,'g',0,'2012-01-02'),(2805,'g',0,'2012-01-02'),(2777,'g',0,'2012-01-02'),(2717,'g',0,'2012-01-02'),(2821,'g',0,'2012-01-21'),(2814,'g',0,'2012-01-21'),(2870,'g',0,'2012-01-21'),(2729,'g',0,'2012-01-21'),(2594,'g',0,'2012-01-21'),(2589,'g',0,'2012-01-21'),(2588,'g',0,'2012-01-21'),(2872,'g',0,'2012-01-21'),(2873,'g',0,'2012-01-21'),(2846,'g',0,'2012-01-21'),(2736,'g',0,'2012-01-21'),(2847,'g',0,'2012-01-21'),(2833,'g',0,'2012-01-21'),(2837,'g',0,'2012-01-22'),(2693,'g',0,'2012-01-22'),(2727,'g',0,'2012-01-23'),(2690,'g',0,'2012-01-24'),(2809,'g',0,'2012-03-06'),(2644,'g',0,'2012-01-24'),(2827,'g',0,'2012-01-24'),(2848,'g',0,'2012-01-24'),(2851,'g',0,'2012-01-27'),(2570,'g',0,'2012-01-28'),(2572,'g',0,'2012-01-28'),(2573,'g',0,'2012-01-28'),(2571,'g',0,'2012-01-28'),(2569,'g',0,'2012-01-28'),(2843,'g',0,'2012-03-04'),(2836,'g',0,'2012-03-04'),(2769,'g',0,'2012-01-31'),(2783,'g',0,'2012-01-31'),(2737,'g',0,'2012-01-31'),(2762,'g',0,'2012-01-31'),(2746,'g',0,'2012-01-31'),(2599,'g',0,'2012-02-04'),(2600,'g',0,'2012-02-04'),(2617,'g',0,'2012-02-05'),(2881,'g',0,'2012-02-07'),(2416,'g',0,'2012-02-09'),(2523,'g',0,'2012-02-09'),(2521,'g',0,'2012-02-09'),(2476,'g',0,'2012-02-09'),(2470,'g',0,'2012-02-09'),(2471,'g',0,'2012-02-09'),(2472,'g',0,'2012-02-09'),(2406,'g',0,'2012-02-09'),(2430,'g',0,'2012-02-09'),(2987,'g',0,'2012-02-10'),(2995,'g',0,'2012-02-11'),(2944,'g',0,'2012-02-11'),(2997,'g',0,'2012-02-11'),(2994,'g',0,'2012-02-11'),(2974,'g',0,'2012-02-11'),(3026,'g',0,'2012-02-14'),(2988,'g',0,'2012-02-15'),(2977,'g',0,'2012-02-15'),(2948,'g',0,'2012-02-15'),(3018,'g',0,'2012-02-15'),(3006,'g',0,'2012-02-15'),(3010,'g',0,'2012-02-15'),(2788,'g',0,'2012-02-16'),(2832,'g',0,'2012-02-16'),(3033,'g',0,'2012-02-17'),(2812,'g',0,'2012-02-17'),(2614,'g',0,'2012-02-17'),(2613,'g',0,'2012-02-17'),(2828,'g',0,'2012-02-17'),(2595,'g',0,'2012-02-17'),(2855,'g',0,'2012-02-17'),(2829,'g',0,'2012-02-17'),(3027,'g',0,'2012-02-17'),(2612,'g',0,'2012-02-17'),(2602,'g',0,'2012-02-17'),(2818,'g',0,'2012-02-17'),(2830,'g',0,'2012-02-17'),(2597,'g',0,'2012-02-17'),(2849,'g',0,'2012-02-17'),(2924,'g',0,'2012-02-18'),(2989,'g',0,'2012-02-19'),(2969,'g',0,'2012-02-20'),(2981,'g',0,'2012-02-20'),(2961,'g',0,'2012-02-20'),(2963,'g',0,'2012-02-20'),(2954,'g',0,'2012-02-20'),(2971,'g',0,'2012-02-20'),(2970,'g',0,'2012-02-20'),(2967,'g',0,'2012-02-20'),(2956,'g',0,'2012-02-21'),(2958,'g',0,'2012-02-21'),(3014,'g',0,'2012-02-21'),(2959,'g',0,'2012-02-21'),(2976,'g',0,'2012-02-21'),(3030,'g',0,'2012-02-22'),(3009,'g',0,'2012-02-22'),(2900,'g',0,'2012-02-22'),(2538,'g',0,'2012-02-22'),(2537,'g',0,'2012-02-22'),(2916,'g',0,'2012-02-22'),(2895,'g',0,'2012-02-22'),(2536,'g',0,'2012-02-22'),(2960,'g',0,'2012-02-22'),(2854,'g',0,'2012-02-22'),(3057,'g',0,'2012-02-22'),(2726,'g',0,'2012-02-22'),(3036,'g',0,'2012-02-23'),(3038,'g',0,'2012-02-24'),(3046,'g',0,'2012-02-27'),(3034,'g',0,'2012-02-27'),(3054,'g',0,'2012-02-27'),(3081,'g',0,'2012-02-28'),(3024,'g',0,'2012-02-29'),(3076,'g',0,'2012-02-29'),(2906,'g',0,'2012-02-29'),(3074,'g',0,'2012-03-01'),(3070,'g',0,'2012-03-01'),(3075,'g',0,'2012-03-01'),(2952,'g',0,'2012-03-01'),(3078,'g',0,'2012-03-01'),(3092,'g',0,'2012-03-02'),(2931,'g',0,'2012-03-02'),(2949,'g',0,'2012-03-02'),(2905,'g',0,'2012-03-02'),(2946,'g',0,'2012-03-02'),(2888,'g',0,'2012-03-02'),(3073,'g',0,'2012-03-02'),(3093,'g',0,'2012-03-03'),(3069,'g',0,'2012-03-03'),(3091,'g',0,'2012-03-03'),(3061,'g',0,'2012-03-05'),(3001,'g',0,'2012-03-05'),(3118,'g',0,'2012-03-05'),(2998,'g',0,'2012-03-05'),(3003,'g',0,'2012-03-05'),(3109,'g',0,'2012-03-06'),(3112,'g',0,'2012-03-06'),(3108,'g',0,'2012-03-06'),(3094,'g',0,'2012-03-06'),(3115,'g',0,'2012-03-06'),(3114,'g',0,'2012-03-06'),(3098,'g',0,'2012-03-06');

--
-- Table structure for table `idx_paid_listing`
--

CREATE TABLE `idx_paid_listing` (
  `link_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `premium` char(1) DEFAULT NULL,
  `sponsored` char(1) DEFAULT NULL,
  `expire` datetime DEFAULT NULL,
  `paid` char(1) DEFAULT NULL,
  PRIMARY KEY (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_paid_listing`
--


--
-- Table structure for table `idx_payment_gateway`
--

CREATE TABLE `idx_payment_gateway` (
  `payment_gateway_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `enable` char(1) DEFAULT NULL,
  `setting` text,
  `invoice_html` text,
  PRIMARY KEY (`payment_gateway_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_payment_gateway`
--

INSERT INTO `idx_payment_gateway` VALUES (1,'paypal','1','a:2:{s:13:\"payment_email\";s:0:\"\";s:21:\"enable_paypal_sandbox\";s:1:\"0\";}','<p> \r\n	<a href=\'paynow.php?id={$invoice_id}&m=paypal\'><img src=\'http://www.paypal.com/images/x-click-but02.gif\' border=\'0\' alt=\'Make payments with PayPal - it is fast, free and secure!\' /></a> \r\n</p>\r\n'),(2,'2co','0','a:6:{s:6:\"co_sid\";s:5:\"84932\";s:9:\"co_secret\";s:5:\"tango\";s:12:\"co_recurring\";s:1:\"0\";s:9:\"co_prod_1\";s:6:\"100.00\";s:9:\"co_prod_2\";s:6:\"250.00\";s:9:\"co_prod_3\";s:6:\"400.00\";}','<p>\r\n<a href=\'paynow.php?id={$invoice_id}&m=2co\'><img src=\'http://www.2checkout.com/images/overview/btns/25.jpg\' alt=\'Pay Now with 2checkout...\' border=\'0\' /></a> \r\n</p>'),(3,'authorizenet','0','a:2:{s:21:\"authorizenet_login_id\";s:0:\"\";s:21:\"authorizenet_tran_key\";s:0:\"\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=authorizenet\'><img src=\'http://www.authorize.net/upload/images/Images/Header/authorizenet_logo.gif\' alt=\'Pay Now with Authorize.Net...\' width=\'99\' height=\'39\' style=\'{border : 1px solid #c0c0c0;}\' /></a>\r\n</p>'),(4,'egold','0','a:2:{s:19:\"egold_payee_account\";s:0:\"\";s:16:\"egold_payee_name\";s:0:\"\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=egold\'>\r\n<img src=\'http://www.e-gold.com/gif/paywith.gif\' border=\'0\' alt=\'Pay Now with e-gold...\' />\r\n</a>\r\n</p>'),(5,'moneybookers','0','a:1:{s:18:\"moneybookers_email\";s:0:\"\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=paypal\'><img src=\'http://www.moneybookers.com/images/banners/88_en_mb.gif\' border=\'0\' alt=\'Make payments with Moneybookers - it is fast, free and secure!\' /></a> \r\n</p>'),(6,'paypal-subscriptions','0','a:2:{s:13:\"payment_email\";s:0:\"\";s:21:\"enable_paypal_sandbox\";s:1:\"0\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=paypal\'><img src=\'https://www.paypal.com/en_US/i/btn/x-click-but20.gif\' border=\'0\' alt=\'Make payments with PayPal - it is fast, free and secure!\' /></a> \r\n</p>'),(7,'alertpay','0','a:2:{s:14:\"alertpay_email\";s:0:\"\";s:23:\"enable_alertpay_sandbox\";s:1:\"0\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=alertpay\'>\r\n<img src=\'https://www.alertpay.com/Images/BuyNow/pay_now_3.gif\' border=\'0\' alt=\'Make payments with PayPal - it is fast, free and secure!\' /></a> \r\n</p>'),(8,'alertpay-subcriptions','0','a:2:{s:14:\"alertpay_email\";s:0:\"\";s:23:\"enable_alertpay_sandbox\";s:1:\"0\";}','<p>\r\n<a href=\'paynow.php?id={$invoice_id}&m=alertpay-subcriptions\'>\r\n<img src=\'https://www.alertpay.com/Images/BuyNow/subscribe_now_15.gif\' border=\'0\' alt=\'Make payments with Alert Pay - it is fast, free and secure!\' /></a> \r\n</p>');

--
-- Table structure for table `idx_payment_history`
--

CREATE TABLE `idx_payment_history` (
  `payment_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `contact_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `detail` text,
  `amount` double DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `invoice_id` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`payment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_payment_history`
--


--
-- Table structure for table `idx_plugin`
--

CREATE TABLE `idx_plugin` (
  `plugin_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `plugin_file` varchar(255) DEFAULT NULL,
  `status` enum('0','1') DEFAULT NULL,
  `option_plugin` text,
  PRIMARY KEY (`plugin_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


--
-- Table structure for table `idx_review`
--

CREATE TABLE `idx_review` (
  `review_id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `link_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `review` text NOT NULL,
  `rating` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  `subject` varchar(100) DEFAULT NULL,
  `status` char(1) DEFAULT NULL,
  `username` varchar(20) DEFAULT NULL,
  `name` varchar(20) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`review_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_review` VALUES (1,1713,'I had a loved one pass away unexepectedly and it was a very dificult time. I had never purchased a headstone before and Gabe & Mary really took the time and patience to really help me with my decision. I didnt know what I was looking for, but after talking with them and going over my options, I was able to find the perfect stone.\r\nthank you so much for making a hard time more manageable!',5,'2011-12-10','Thank You','0','','Jon','jhs@aol.com');

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

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

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

INSERT INTO `idx_searchlog` VALUES ('deking','2011-11-07 07:02:39',0,'82.77.156.148'),('deking','2011-11-11 07:27:10',0,'82.77.156.148'),('deking','2011-11-18 03:29:13',0,'82.77.156.148'),('deking','2011-11-21 02:58:24',0,'82.77.156.148'),('sinussurgerylosangeles.com','2011-12-02 16:34:26',1,'203.92.47.195'),('deking','2011-12-05 02:25:50',0,'82.77.156.148'),('deking','2011-12-09 06:36:31',0,'82.77.156.148'),('deking','2011-12-12 03:03:44',0,'82.77.156.148'),('deking','2011-12-16 02:19:15',0,'82.77.156.148'),('deking.com.au','2011-12-16 02:43:20',0,'82.77.156.148'),('dana wharf sportfishing','2011-12-17 16:01:33',0,'98.189.157.202'),('vermont','2011-12-28 09:19:33',1,'68.114.61.172'),('Mittens Photography Inc.','2012-01-30 00:19:58',0,'121.243.231.90'),('martbuyglasses.com','2012-01-31 02:39:39',0,'203.92.47.195'),('smartbuyglasses.com','2012-01-31 02:39:45',0,'203.92.47.195'),('Designer Sunglasses','2012-01-31 02:39:56',1,'203.92.47.195'),('Sunglasses','2012-01-31 02:40:10',1,'203.92.47.195'),('deking','2012-02-07 05:20:01',0,'82.77.156.148'),('smartbuyglasses','2012-02-08 21:04:34',0,'64.120.99.10'),('smartbuyglasses','2012-02-08 21:36:46',0,'64.120.99.10'),('deking','2012-02-22 12:09:48',0,'79.114.25.89');

--
-- 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','localdirectori.com'),(5,'site_url','http://localdirectori.com'),(6,'email_address','francisca1@live.com'),(7,'language_code','en_US'),(8,'theme_path','/home/geteurop/public_html/themes/'),(9,'admin_template_path','/home/geteurop/public_html/admin_tpl/'),(10,'plugin_path','/home/geteurop/public_html/plugin/'),(12,'active_theme','BluePigment1-0'),(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`
--



