--
-- Host: editorssubmit.com    Database: editorss_db
-- ------------------------------------------------------


--
-- Not dumping tablespaces as no INFORMATION_SCHEMA.FILES table on this server
--

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

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

INSERT INTO `idx_category` VALUES (86,0,'Arts Gallery & Entertainment','','folder.gif','','1',11,'','','1','0','','',0,'',0,0,0,0,0),(87,0,'Automobiles','','folder.gif','','1',43,'','','1','0','','',0,'',0,0,0,0,0),(88,0,'Business & Investment','','folder.gif','','1',150,'','','1','0','','',0,'',0,0,0,0,0),(89,0,'Careers & Recruitment','','folder.gif','','1',2,'','','1','0','','',0,'',0,0,0,0,0),(90,0,'Clothing & Designers','','folder.gif','','1',9,'','','1','0','','',0,'',0,0,0,0,0),(91,0,'Communication ','','folder.gif','','1',18,'','','1','0','','',0,'',0,0,0,0,0),(92,0,'Computers','','folder.gif','','1',21,'','','1','0','','',0,'',0,0,0,0,0),(93,0,'Construction and Remodeling','','folder.gif','','1',83,'','','1','0','','',0,'',0,0,0,0,0),(94,0,'Dentist Directories','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(95,0,'Education & Colleges','','folder.gif','','1',30,'','','1','0','','',0,'',0,0,0,0,0),(96,0,'Employment & Staffing','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(97,0,'Gifts & Stationery','','folder.gif','','1',22,'','','1','0','','',0,'',0,0,0,0,0),(98,0,'Hardware & Software Systems','','folder.gif','','1',12,'','','1','0','','',0,'',0,0,0,0,0),(99,0,'Health Resources','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(100,0,'Healthcare ','','folder.gif','','1',236,'','','1','0','','',0,'',0,0,0,0,0),(101,0,'Heating and Air Conditioning','','folder.gif','','1',57,'','','1','0','','',0,'',0,0,0,0,0),(102,0,'Home & Garden','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(103,0,'Home Improvement ','','folder.gif','','1',311,'','','1','0','','',0,'',0,0,0,0,0),(104,0,'Hotels & Motels','','folder.gif','','1',46,'','','1','0','','',0,'',0,0,0,0,0),(105,0,'Insurance','','folder.gif','','1',29,'','','1','0','','',0,'',0,0,0,0,0),(106,0,'Law & Politics','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(107,0,'Lawyers & Legal Consultants','','folder.gif','','1',165,'','','1','0','','',0,'',0,0,0,0,0),(108,0,'Lifestyle & Society','','folder.gif','','1',9,'','','1','0','','',0,'',0,0,0,0,0),(109,0,'Medicine & Medical Services','','folder.gif','','1',7,'','','1','0','','',0,'',0,0,0,0,0),(110,0,'Finance','','folder.gif','','1',17,'','','1','0','','',0,'',0,0,0,0,0),(111,0,'News & Journals','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(112,0,'Plumbing & Fitting ','','folder.gif','','1',31,'','','1','0','','',0,'',0,0,0,0,0),(113,0,'Real Estate & Agents ','','folder.gif','','1',35,'','','1','0','','',0,'',0,0,0,0,0),(114,0,'Environment & Technology','','folder.gif','','1',12,'','','1','0','','',0,'',0,0,0,0,0),(115,0,'SEO & SMO Marketing','','folder.gif','','1',21,'','','1','0','','',0,'',0,0,0,0,0),(116,0,'Online Shopping','','folder.gif','','1',70,'','','1','0','','',0,'',0,0,0,0,0),(117,0,'Sports','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(118,0,'Transportation and Logistics Services','','folder.gif','','1',44,'','','1','0','','',0,'',0,0,0,0,0),(119,0,'Tours & Travel','','folder.gif','','1',25,'','','1','0','','',0,'',0,0,0,0,0),(120,0,'Wedding & Jewellery','','folder.gif','','1',11,'','','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,
  `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 (86,'Arts Gallery & Entertainment','<a href=\"http://editorssubmit.com/arts-gallery-entertainment/\" name=\"cat_86\" style=\"\">Arts Gallery & Entertainment</a>',';0;'),(87,'Automobiles','<a href=\"http://editorssubmit.com/automobiles/\" name=\"cat_87\" style=\"\">Automobiles</a>',';0;'),(88,'Business & Investment','<a href=\"http://editorssubmit.com/business-investment/\" name=\"cat_88\" style=\"\">Business & Investment</a>',';0;'),(89,'Careers & Recruitment','<a href=\"http://editorssubmit.com/careers-recruitment/\" name=\"cat_89\" style=\"\">Careers & Recruitment</a>',';0;'),(90,'Clothing & Designers','<a href=\"http://editorssubmit.com/clothing-designers/\" name=\"cat_90\" style=\"\">Clothing & Designers</a>',';0;'),(91,'Communication ','<a href=\"http://editorssubmit.com/communication/\" name=\"cat_91\" style=\"\">Communication </a>',';0;'),(92,'Computers','<a href=\"http://editorssubmit.com/computers/\" name=\"cat_92\" style=\"\">Computers</a>',';0;'),(93,'Construction and Remodeling','<a href=\"http://editorssubmit.com/construction-and-remodeling/\" name=\"cat_93\" style=\"\">Construction and Remodeling</a>',';0;'),(94,'Dentist Directories','<a href=\"http://editorssubmit.com/dentist-directories/\" name=\"cat_94\" style=\"\">Dentist Directories</a>',';0;'),(95,'Education & Colleges','<a href=\"http://editorssubmit.com/education-colleges/\" name=\"cat_95\" style=\"\">Education & Colleges</a>',';0;'),(96,'Employment & Staffing','<a href=\"http://editorssubmit.com/employment-staffing/\" name=\"cat_96\" style=\"\">Employment & Staffing</a>',';0;'),(97,'Gifts & Stationery','<a href=\"http://editorssubmit.com/gifts-stationery/\" name=\"cat_97\" style=\"\">Gifts & Stationery</a>',';0;'),(98,'Hardware & Software Systems','<a href=\"http://editorssubmit.com/hardware-software-systems/\" name=\"cat_98\" style=\"\">Hardware & Software Systems</a>',';0;'),(99,'Health Resources','<a href=\"http://editorssubmit.com/health-resources/\" name=\"cat_99\" style=\"\">Health Resources</a>',';0;'),(100,'Healthcare ','<a href=\"http://editorssubmit.com/healthcare/\" name=\"cat_100\" style=\"\">Healthcare </a>',';0;'),(101,'Heating and Air Conditioning','<a href=\"http://editorssubmit.com/heating-and-air-conditioning/\" name=\"cat_101\" style=\"\">Heating and Air Conditioning</a>',';0;'),(102,'Home & Garden','<a href=\"http://editorssubmit.com/home-garden/\" name=\"cat_102\" style=\"\">Home & Garden</a>',';0;'),(103,'Home Improvement ','<a href=\"http://editorssubmit.com/home-improvement/\" name=\"cat_103\" style=\"\">Home Improvement </a>',';0;'),(104,'Hotels & Motels','<a href=\"http://editorssubmit.com/hotels-motels/\" name=\"cat_104\" style=\"\">Hotels & Motels</a>',';0;'),(105,'Insurance','<a href=\"http://editorssubmit.com/insurance/\" name=\"cat_105\" style=\"\">Insurance</a>',';0;'),(106,'Law & Politics','<a href=\"http://editorssubmit.com/law-politics/\" name=\"cat_106\" style=\"\">Law & Politics</a>',';0;'),(107,'Lawyers & Legal Consultants','<a href=\"http://editorssubmit.com/lawyers-legal-consultants/\" name=\"cat_107\" style=\"\">Lawyers & Legal Consultants</a>',';0;'),(108,'Lifestyle & Society','<a href=\"http://editorssubmit.com/lifestyle-society/\" name=\"cat_108\" style=\"\">Lifestyle & Society</a>',';0;'),(109,'Medicine & Medical Services','<a href=\"http://editorssubmit.com/medicine-medical-services/\" name=\"cat_109\" style=\"\">Medicine & Medical Services</a>',';0;'),(110,'Finance','<a href=\"http://editorssubmit.com/finance/\" name=\"cat_110\" style=\"\">Finance</a>',';0;'),(111,'News & Journals','<a href=\"http://editorssubmit.com/news-journals/\" name=\"cat_111\" style=\"\">News & Journals</a>',';0;'),(112,'Plumbing & Fitting ','<a href=\"http://editorssubmit.com/plumbing-fitting/\" name=\"cat_112\" style=\"\">Plumbing & Fitting </a>',';0;'),(113,'Real Estate & Agents ','<a href=\"http://editorssubmit.com/real-estate-agents/\" name=\"cat_113\" style=\"\">Real Estate & Agents </a>',';0;'),(114,'Environment & Technology','<a href=\"http://editorssubmit.com/environment-technology/\" name=\"cat_114\" style=\"\">Environment & Technology</a>',';0;'),(115,'SEO & SMO Marketing','<a href=\"http://editorssubmit.com/seo-smo-marketing/\" name=\"cat_115\" style=\"\">SEO & SMO Marketing</a>',';0;'),(116,'Online Shopping','<a href=\"http://editorssubmit.com/online-shopping/\" name=\"cat_116\" style=\"\">Online Shopping</a>',';0;'),(117,'Sports','<a href=\"http://editorssubmit.com/sports/\" name=\"cat_117\" style=\"\">Sports</a>',';0;'),(118,'Transportation and Logistics Services','<a href=\"http://editorssubmit.com/transportation-and-logistics-services/\" name=\"cat_118\" style=\"\">Transportation and Logistics Services</a>',';0;'),(119,'Tours & Travel','<a href=\"http://editorssubmit.com/tours-travel/\" name=\"cat_119\" style=\"\">Tours & Travel</a>',';0;'),(120,'Wedding & Jewellery','<a href=\"http://editorssubmit.com/wedding-jewellery/\" name=\"cat_120\" style=\"\">Wedding & Jewellery</a>',';0;');

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

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

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


--
-- Table structure for table `idx_checkurl`
--

CREATE TABLE `idx_checkurl` (
  `link_id` mediumint(9) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `live` char(1) NOT NULL default '',
  `reciprocal_found` char(1) NOT NULL default '',
  PRIMARY KEY  (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_checkurl`
--


--
-- Table structure for table `idx_cronjobs`
--

CREATE TABLE `idx_cronjobs` (
  `cronjobs_id` int(11) NOT NULL auto_increment,
  `cronjobs_name` varchar(255) default NULL,
  `filename` varchar(255) NOT NULL,
  `schedule` varchar(255) NOT NULL,
  `time` datetime NOT NULL,
  `execution` varchar(1) NOT NULL,
  PRIMARY KEY  (`cronjobs_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_cronjobs`
--

INSERT INTO `idx_cronjobs` VALUES (1,NULL,'clear_templates_c.php','1,*,*,*,*','0000-00-00 00:00:00',''),(2,NULL,'update_tag_cloud.php','*,24,*,*,*','0000-00-00 00:00:00',''),(3,NULL,'clear_rss_cache.php','*,24,*,*,*','0000-00-00 00:00:00','');

--
-- Table structure for table `idx_custom_field`
--

CREATE TABLE `idx_custom_field` (
  `field_name` varchar(32) NOT NULL default '',
  `field_text` varchar(64) NOT NULL default '',
  `field_type` enum('TEXT','TEXTAREA','SELECT','MULTISELECT','CHECKBOX','RADIO','FILE','IMAGE','DATE','DATETIME','RICHEDITOR') NOT NULL default 'TEXT',
  `field_option` text NOT NULL,
  `field_img_width` int(10) unsigned NOT NULL default '0',
  `field_img_height` int(10) unsigned NOT NULL default '0',
  `field_file_size` int(10) unsigned NOT NULL default '0',
  `field_file_extension` varchar(64) NOT NULL default '',
  `required` char(1) NOT NULL default '0',
  `searchable` char(1) NOT NULL default '1',
  `permission` char(1) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_custom_field`
--

INSERT INTO `idx_custom_field` VALUES ('image','Image','IMAGE','',0,0,0,'','0','0','2'),('address','Address','TEXT','',0,0,0,'','0','0','0'),('city','City','TEXT','',0,0,0,'','0','0','0'),('state','State','TEXT','',0,0,0,'','0','0','0'),('country','Country','TEXT','',0,0,0,'','0','0','0'),('zip','Zip','TEXT','',0,0,0,'','0','0','0'),('phone','Phone','TEXT','',0,0,0,'','0','0','0'),('fax','Fax','TEXT','',0,0,0,'','0','0','0');

--
-- Table structure for table `idx_default_field`
--

CREATE TABLE `idx_default_field` (
  `field_name` varchar(64) NOT NULL,
  `required` char(1) NOT NULL,
  `visible` char(1) NOT NULL default '1',
  `searchable` char(1) NOT NULL default '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_default_field`
--

INSERT INTO `idx_default_field` VALUES ('title','1','1','1'),('url','1','1','1'),('description','1','1','1'),('keywords','1','1','0'),('contact_name','1','1','1'),('email','1','1','1'),('reciprocal_url','0','0','1');

--
-- Table structure for table `idx_discount_coupon`
--

CREATE TABLE `idx_discount_coupon` (
  `coupon_id` int(11) NOT NULL auto_increment,
  `coupon_code` varchar(255) default NULL,
  `coupon_value` varchar(50) default NULL,
  `link_type` varchar(255) default NULL,
  `start_date` date default NULL,
  `expired_date` date default NULL,
  `expired_usage` int(11) default NULL,
  `usage_count` int(11) default NULL,
  PRIMARY KEY  (`coupon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

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

--
-- Dumping data for table `idx_editor`
--


--
-- Table structure for table `idx_email_template`
--

CREATE TABLE `idx_email_template` (
  `email_template_id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `subject` varchar(255) default NULL,
  `body` text,
  `altbody` text,
  PRIMARY KEY  (`email_template_id`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_email_template`
--



--
-- Table structure for table `idx_favorites`
--

CREATE TABLE `idx_favorites` (
  `favorite_id` int(11) NOT NULL auto_increment,
  `username` varchar(20) default NULL,
  `date` date default NULL,
  `title` varchar(100) default NULL,
  `description` text,
  PRIMARY KEY  (`favorite_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_favorites` VALUES (1,'terranceanges10h29','2011-10-18','My Favorites',NULL),(2,'morrispatricv96g83','2011-10-19','My Favorites',NULL),(3,'mortonbrendop48i25','2011-10-31','My Favorites',NULL),(4,'bertkentone43d79','2011-11-01','My Favorites',NULL);

--
-- Table structure for table `idx_favorites_detail`
--

CREATE TABLE `idx_favorites_detail` (
  `favorite_id` int(11) default NULL,
  `link_id` mediumint(9) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_favorites_detail`
--


--
-- Table structure for table `idx_hook_place`
--

CREATE TABLE `idx_hook_place` (
  `hook_place_id` int(11) NOT NULL auto_increment,
  `filename` varchar(255) default NULL,
  `hookname` varchar(255) default NULL,
  PRIMARY KEY  (`hook_place_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

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

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


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

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

--
-- Dumping data for table `idx_invoice_config`
--

INSERT INTO `idx_invoice_config` VALUES ('Your website / Company','Billing Department','Your address','Your phone #','Billing<name@yourdomain.com>','$','USD');

--
-- Table structure for table `idx_link_temp`
--

CREATE TABLE `idx_link_temp` (
  `vid` mediumint(9) unsigned NOT NULL auto_increment,
  `spam` char(1) NOT NULL default '0',
  `link_id` mediumint(9) default NULL,
  `category_id` mediumint(9) unsigned NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `url` text NOT NULL,
  `description` text NOT NULL,
  `contact_name` varchar(100) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `hits` mediumint(9) default NULL,
  `votes` smallint(6) default NULL,
  `rating` float(4,2) default NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `bid` smallint(6) NOT NULL default '0',
  `new` char(1) default NULL,
  `hot` char(1) default NULL,
  `top_rated` char(1) default NULL,
  `pick` char(1) default NULL,
  `password` varchar(20) default NULL,
  `updated` char(1) default NULL,
  `reviews` smallint(6) default NULL,
  `avg_review` float(4,2) default NULL,
  `last_updated` datetime default NULL,
  `official_review` text,
  `keywords` varchar(255) default NULL,
  `cat1` mediumint(6) NOT NULL default '0',
  `cat2` mediumint(6) NOT NULL default '0',
  `suspended` char(1) NOT NULL default '0',
  `reciprocal_url` varchar(255) default NULL,
  `address` varchar(255) default NULL,
  `city` varchar(255) default NULL,
  `state` varchar(255) default NULL,
  `country` varchar(255) default NULL,
  `zip` varchar(255) default NULL,
  `image` varchar(255) default NULL,
  `phone` varchar(255) default NULL,
  `fax` varchar(255) default NULL,
  PRIMARY KEY  (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_link_temp`
--


--
-- Table structure for table `idx_link_temp_user`
--

CREATE TABLE `idx_link_temp_user` (
  `vid` mediumint(9) unsigned NOT NULL default '0',
  `username` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


--
-- Table structure for table `idx_link_user`
--

CREATE TABLE `idx_link_user` (
  `link_id` mediumint(9) unsigned NOT NULL default '0',
  `username` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

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

--
-- Dumping data for table `idx_mailing_list`
--


--
-- Table structure for table `idx_message`
--

CREATE TABLE `idx_message` (
  `message_id` smallint(6) NOT NULL auto_increment,
  `date` date default NULL,
  `body` text,
  `subject` varchar(100) default NULL,
  PRIMARY KEY  (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

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

--
-- Dumping data for table `idx_notification`
--


--
-- Table structure for table `idx_pagerank`
--

CREATE TABLE `idx_pagerank` (
  `link_id` mediumint(8) unsigned NOT NULL default '0',
  `engine` char(1) NOT NULL default '',
  `rank` tinyint(4) NOT NULL default '0',
  `last_update` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`link_id`,`engine`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_pagerank` VALUES (131,'g',0,'2012-02-25'),(132,'g',0,'2012-03-01'),(271,'g',0,'2011-11-23'),(578,'g',0,'2012-02-15'),(438,'g',0,'2011-11-23'),(439,'g',0,'2012-03-02'),(91,'g',0,'2012-02-27'),(255,'g',0,'2012-03-01'),(220,'g',0,'2011-11-23'),(270,'g',0,'2011-11-23'),(262,'g',0,'2011-11-23'),(254,'g',0,'2012-03-01'),(90,'g',0,'2012-03-01'),(266,'g',0,'2011-11-23'),(108,'g',0,'2011-11-23'),(215,'g',0,'2012-01-06'),(1,'g',0,'2011-11-23'),(10,'g',0,'2011-11-23'),(102,'g',0,'2012-03-01'),(103,'g',0,'2011-11-23'),(105,'g',0,'2012-01-06'),(106,'g',0,'2011-11-23'),(11,'g',0,'2012-02-06'),(110,'g',0,'2011-11-23'),(112,'g',0,'2012-03-02'),(113,'g',0,'2011-11-23'),(114,'g',0,'2012-01-04'),(115,'g',0,'2012-03-01'),(116,'g',0,'2012-03-01'),(117,'g',0,'2012-03-01'),(118,'g',0,'2012-01-04'),(119,'g',0,'2012-01-04'),(12,'g',0,'2012-03-01'),(120,'g',0,'2012-01-04'),(121,'g',0,'2012-03-01'),(122,'g',0,'2012-01-04'),(123,'g',0,'2011-11-23'),(125,'g',0,'2011-11-23'),(126,'g',0,'2012-01-05'),(127,'g',0,'2012-01-05'),(129,'g',0,'2012-03-01'),(13,'g',0,'2012-02-02'),(130,'g',0,'2012-01-05'),(138,'g',0,'2012-01-05'),(14,'g',0,'2012-03-01'),(146,'g',0,'2012-01-08'),(15,'g',0,'2012-03-01'),(152,'g',0,'2012-02-07'),(16,'g',0,'2012-03-01'),(164,'g',0,'2011-11-23'),(165,'g',0,'2012-03-06'),(167,'g',0,'2011-11-23'),(17,'g',0,'2012-03-01'),(172,'g',0,'2012-01-25'),(175,'g',0,'2012-03-02'),(18,'g',0,'2012-03-01'),(188,'g',0,'2011-11-23'),(19,'g',0,'2011-11-23'),(197,'g',0,'2012-03-01'),(2,'g',0,'2012-01-06'),(20,'g',0,'2012-02-09'),(203,'g',0,'2012-01-20'),(204,'g',0,'2012-01-20'),(205,'g',0,'2012-01-06'),(207,'g',0,'2012-01-23'),(21,'g',0,'2012-03-06'),(210,'g',0,'2012-01-21'),(214,'g',0,'2012-01-23'),(22,'g',0,'2012-03-01'),(225,'g',0,'2012-02-06'),(231,'g',0,'2012-02-07'),(232,'g',0,'2012-03-01'),(233,'g',0,'2011-11-23'),(24,'g',0,'2012-03-01'),(240,'g',0,'2012-03-07'),(245,'g',0,'2012-01-20'),(25,'g',0,'2012-03-04'),(252,'g',0,'2012-01-06'),(26,'g',0,'2012-03-01'),(260,'g',0,'2012-01-06'),(261,'g',0,'2011-12-24'),(263,'g',0,'2012-01-06'),(264,'g',0,'2011-11-23'),(277,'g',0,'2011-11-23'),(28,'g',0,'2012-02-02'),(282,'g',0,'2012-01-20'),(285,'g',0,'2012-03-01'),(299,'g',0,'2011-11-23'),(3,'g',0,'2012-03-01'),(30,'g',0,'2011-11-23'),(301,'g',0,'2011-11-23'),(303,'g',0,'2011-11-23'),(308,'g',0,'2011-11-23'),(325,'g',0,'2011-11-23'),(353,'g',0,'2011-11-23'),(356,'g',0,'2011-11-23'),(368,'g',0,'2011-12-23'),(38,'g',0,'2012-01-07'),(380,'g',0,'2012-02-06'),(389,'g',0,'2011-11-23'),(39,'g',0,'2012-03-01'),(40,'g',0,'2012-03-01'),(41,'g',0,'2012-03-01'),(417,'g',0,'2011-11-23'),(42,'g',0,'2012-02-02'),(426,'g',0,'2011-11-23'),(43,'g',0,'2012-01-07'),(434,'g',0,'2011-11-23'),(44,'g',0,'2012-02-02'),(445,'g',0,'2011-11-23'),(45,'g',0,'2012-01-07'),(46,'g',0,'2011-11-23'),(47,'g',0,'2012-03-01'),(482,'g',0,'2012-03-01'),(49,'g',0,'2011-11-23'),(50,'g',0,'2011-11-23'),(514,'g',0,'2011-11-23'),(54,'g',0,'2012-03-01'),(552,'g',0,'2011-11-23'),(56,'g',0,'2012-01-24'),(57,'g',0,'2012-03-01'),(59,'g',0,'2011-11-23'),(592,'g',0,'2012-01-20'),(60,'g',0,'2012-01-24'),(61,'g',0,'2012-02-27'),(610,'g',0,'2012-03-01'),(64,'g',0,'2012-02-17'),(68,'g',0,'2011-11-23'),(7,'g',0,'2011-11-23'),(71,'g',0,'2012-03-01'),(72,'g',0,'2012-03-01'),(73,'g',0,'2012-03-01'),(74,'g',0,'2011-11-23'),(75,'g',0,'2012-02-09'),(77,'g',0,'2012-03-01'),(78,'g',0,'2012-03-01'),(8,'g',0,'2012-02-06'),(81,'g',0,'2012-03-01'),(82,'g',0,'2012-03-07'),(83,'g',0,'2012-03-01'),(86,'g',0,'2012-01-06'),(87,'g',0,'2012-02-27'),(88,'g',0,'2012-03-01'),(89,'g',0,'2011-11-23'),(9,'g',0,'2011-11-23'),(92,'g',0,'2011-11-23'),(94,'g',0,'2012-03-01'),(95,'g',0,'2011-11-23'),(96,'g',0,'2011-11-23'),(98,'g',0,'2012-03-01'),(99,'g',0,'2012-03-01'),(768,'g',0,'2011-11-24'),(48,'g',0,'2011-11-25'),(725,'g',0,'2011-11-25'),(591,'g',0,'2012-03-01'),(284,'g',0,'2011-11-25'),(206,'g',0,'2012-01-23'),(55,'g',0,'2012-03-01'),(518,'g',0,'2012-03-01'),(211,'g',0,'2012-01-23'),(755,'g',0,'2012-03-04'),(355,'g',0,'2011-11-25'),(780,'g',0,'2012-01-06'),(435,'g',0,'2011-11-25'),(208,'g',0,'2011-11-25'),(69,'g',0,'2012-03-01'),(128,'g',0,'2012-01-05'),(376,'g',0,'2012-03-01'),(362,'g',0,'2011-11-25'),(4,'g',0,'2011-11-26'),(751,'g',0,'2011-11-26'),(758,'g',0,'2011-11-27'),(52,'g',0,'2011-11-27'),(51,'g',0,'2012-01-06'),(358,'g',0,'2011-11-27'),(761,'g',0,'2012-01-02'),(313,'g',0,'2011-11-27'),(359,'g',0,'2011-11-27'),(6,'g',0,'2012-03-01'),(709,'g',0,'2011-11-27'),(696,'g',0,'2012-03-01'),(760,'g',0,'2012-01-02'),(589,'g',0,'2012-03-01'),(300,'g',0,'2011-11-29'),(304,'g',0,'2011-11-29'),(305,'g',0,'2011-11-29'),(306,'g',0,'2012-03-04'),(309,'g',0,'2011-11-29'),(310,'g',0,'2011-11-29'),(390,'g',0,'2012-02-17'),(391,'g',0,'2011-11-29'),(393,'g',0,'2011-11-29'),(394,'g',0,'2012-03-01'),(395,'g',0,'2012-03-01'),(397,'g',0,'2012-02-06'),(398,'g',0,'2011-11-29'),(399,'g',0,'2011-11-29'),(404,'g',0,'2011-11-29'),(405,'g',0,'2012-01-06'),(406,'g',0,'2012-03-01'),(407,'g',0,'2011-11-29'),(412,'g',0,'2011-11-29'),(413,'g',0,'2012-02-20'),(414,'g',0,'2011-11-29'),(415,'g',0,'2011-11-29'),(416,'g',0,'2011-11-29'),(421,'g',0,'2012-02-06'),(422,'g',0,'2012-01-20'),(423,'g',0,'2012-01-04'),(424,'g',0,'2012-02-17'),(425,'g',0,'2011-11-29'),(427,'g',0,'2011-11-29'),(428,'g',0,'2011-11-29'),(429,'g',0,'2012-03-01'),(462,'g',0,'2012-03-01'),(463,'g',0,'2011-11-29'),(464,'g',0,'2011-11-29'),(465,'g',0,'2012-02-17'),(471,'g',0,'2012-03-01'),(472,'g',0,'2011-11-29'),(474,'g',0,'2011-11-29'),(475,'g',0,'2012-03-01'),(477,'g',0,'2012-02-06'),(479,'g',0,'2011-11-29'),(480,'g',0,'2012-02-17'),(481,'g',0,'2012-03-01'),(484,'g',0,'2012-02-20'),(486,'g',0,'2012-02-21'),(487,'g',0,'2012-02-20'),(488,'g',0,'2011-11-29'),(489,'g',0,'2011-11-29'),(490,'g',0,'2011-11-29'),(491,'g',0,'2012-03-05'),(492,'g',0,'2011-11-29'),(493,'g',0,'2011-11-29'),(494,'g',0,'2011-11-29'),(495,'g',0,'2011-11-29'),(496,'g',0,'2011-11-29'),(502,'g',0,'2011-11-29'),(504,'g',0,'2011-11-29'),(508,'g',0,'2011-11-29'),(509,'g',0,'2011-11-29'),(510,'g',0,'2011-11-29'),(511,'g',0,'2011-11-29'),(512,'g',0,'2012-01-05'),(516,'g',0,'2012-03-01'),(517,'g',0,'2011-11-29'),(520,'g',0,'2012-02-06'),(521,'g',0,'2011-11-29'),(522,'g',0,'2012-03-01'),(525,'g',0,'2012-03-01'),(526,'g',0,'2012-01-06'),(527,'g',0,'2011-11-29'),(528,'g',0,'2011-11-29'),(529,'g',0,'2011-11-29'),(532,'g',0,'2012-02-17'),(535,'g',0,'2012-02-17'),(536,'g',0,'2012-03-06'),(555,'g',0,'2011-11-29'),(557,'g',0,'2011-11-29'),(558,'g',0,'2011-11-29'),(559,'g',0,'2012-01-06'),(561,'g',0,'2012-03-01'),(562,'g',0,'2012-02-11'),(569,'g',0,'2011-11-29'),(572,'g',0,'2012-03-01'),(573,'g',0,'2011-11-29'),(576,'g',0,'2011-11-29'),(577,'g',0,'2011-11-29'),(58,'g',0,'2012-01-24'),(581,'g',0,'2012-03-01'),(582,'g',0,'2012-03-01'),(583,'g',0,'2012-02-16'),(584,'g',0,'2011-11-29'),(587,'g',0,'2012-03-01'),(588,'g',0,'2012-03-01'),(590,'g',0,'2011-11-29'),(593,'g',0,'2011-11-29'),(594,'g',0,'2011-11-29'),(595,'g',0,'2012-02-06'),(596,'g',0,'2011-11-29'),(597,'g',0,'2011-11-29'),(598,'g',0,'2011-11-29'),(599,'g',0,'2011-11-29'),(600,'g',0,'2011-11-29'),(603,'g',0,'2012-03-01'),(604,'g',0,'2012-03-01'),(605,'g',0,'2011-11-29'),(606,'g',0,'2012-02-11'),(607,'g',0,'2011-11-29'),(608,'g',0,'2011-11-29'),(611,'g',0,'2012-03-01'),(612,'g',0,'2011-11-29'),(613,'g',0,'2011-11-29'),(618,'g',0,'2012-03-01'),(62,'g',0,'2011-11-29'),(620,'g',0,'2012-02-11'),(621,'g',0,'2011-11-29'),(628,'g',0,'2011-11-29'),(63,'g',0,'2012-03-01'),(634,'g',0,'2011-11-29'),(635,'g',0,'2011-11-29'),(677,'g',0,'2012-03-01'),(693,'g',0,'2011-11-29'),(70,'g',0,'2012-03-01'),(702,'g',0,'2012-03-01'),(703,'g',0,'2011-11-29'),(712,'g',0,'2012-03-01'),(714,'g',0,'2011-11-29'),(726,'g',0,'2012-02-20'),(734,'g',0,'2011-11-29'),(739,'g',0,'2011-11-29'),(741,'g',0,'2011-11-29'),(753,'g',0,'2012-03-01'),(76,'g',0,'2012-03-01'),(767,'g',0,'2011-11-29'),(79,'g',0,'2011-11-29'),(84,'g',0,'2011-11-29'),(97,'g',0,'2011-11-29'),(32,'g',0,'2012-03-01'),(133,'g',0,'2012-03-01'),(37,'g',0,'2012-01-24'),(31,'g',0,'2012-01-24'),(111,'g',0,'2011-11-29'),(35,'g',0,'2012-01-04'),(36,'g',0,'2012-01-21'),(33,'g',0,'2012-02-06'),(53,'g',0,'2012-01-24'),(34,'g',0,'2012-02-06'),(411,'g',0,'2011-11-29'),(478,'g',0,'2011-11-29'),(224,'g',0,'2012-03-01'),(171,'g',0,'2011-11-29'),(104,'g',0,'2012-03-01'),(531,'g',0,'2011-11-29'),(27,'g',0,'2012-02-09'),(85,'g',0,'2011-11-29'),(80,'g',0,'2012-03-01'),(681,'g',0,'2012-03-02'),(690,'g',0,'2011-11-29'),(408,'g',0,'2012-01-20'),(627,'g',0,'2011-11-29'),(392,'g',0,'2011-11-29'),(387,'g',0,'2011-11-29'),(166,'g',0,'2011-11-29'),(101,'g',0,'2011-11-29'),(334,'g',0,'2011-11-29'),(686,'g',0,'2011-11-29'),(473,'g',0,'2011-11-29'),(687,'g',0,'2011-11-29'),(685,'g',0,'2012-03-01'),(684,'g',0,'2011-11-29'),(688,'g',0,'2011-11-29'),(689,'g',0,'2012-01-25'),(5,'g',0,'2011-12-01'),(93,'g',0,'2012-03-01'),(23,'g',0,'2012-03-01'),(29,'g',0,'2011-12-01'),(330,'g',0,'2012-02-07'),(200,'g',0,'2011-12-01'),(312,'g',0,'2011-12-01'),(279,'g',0,'2012-03-01'),(278,'g',0,'2012-01-06'),(336,'g',0,'2011-12-01'),(814,'g',0,'2011-12-03'),(622,'g',0,'2011-12-03'),(440,'g',0,'2012-02-06'),(740,'g',0,'2012-03-01'),(745,'g',0,'2011-12-03'),(381,'g',0,'2012-03-01'),(67,'g',0,'2012-01-06'),(1208,'g',0,'2012-03-01'),(560,'g',0,'2012-02-06'),(722,'g',0,'2012-02-16'),(932,'g',0,'2012-02-16'),(981,'g',0,'2012-02-16'),(720,'g',0,'2012-02-16'),(567,'g',0,'2012-02-06'),(642,'g',0,'2012-02-16'),(985,'g',0,'2012-02-16'),(776,'g',0,'2012-01-06'),(926,'g',0,'2012-01-18'),(373,'g',0,'2011-12-06'),(372,'g',0,'2011-12-06'),(650,'g',0,'2011-12-06'),(537,'g',0,'2011-12-06'),(524,'g',0,'2011-12-06'),(430,'g',0,'2011-12-06'),(672,'g',0,'2012-03-01'),(670,'g',0,'2011-12-06'),(669,'g',0,'2011-12-06'),(662,'g',0,'2012-03-01'),(668,'g',0,'2012-03-01'),(671,'g',0,'2011-12-06'),(682,'g',0,'2012-03-01'),(460,'g',0,'2011-12-06'),(961,'g',0,'2012-03-01'),(942,'g',0,'2011-12-06'),(950,'g',0,'2011-12-06'),(925,'g',0,'2011-12-06'),(948,'g',0,'2012-03-01'),(930,'g',0,'2012-03-01'),(920,'g',0,'2011-12-06'),(951,'g',0,'2012-03-01'),(915,'g',0,'2012-02-14'),(918,'g',0,'2011-12-06'),(1026,'g',0,'2011-12-06'),(666,'g',0,'2011-12-06'),(639,'g',0,'2012-01-06'),(629,'g',0,'2012-03-01'),(797,'g',0,'2011-12-07'),(888,'g',0,'2012-03-01'),(793,'g',0,'2011-12-07'),(850,'g',0,'2011-12-07'),(810,'g',0,'2011-12-07'),(796,'g',0,'2012-03-01'),(754,'g',0,'2012-03-01'),(811,'g',0,'2011-12-07'),(691,'g',0,'2011-12-07'),(746,'g',0,'2012-03-01'),(744,'g',0,'2012-02-22'),(773,'g',0,'2011-12-07'),(257,'g',0,'2012-03-01'),(238,'g',0,'2011-12-07'),(249,'g',0,'2012-03-01'),(221,'g',0,'2011-12-07'),(222,'g',0,'2011-12-07'),(213,'g',0,'2012-03-01'),(538,'g',0,'2011-12-07'),(545,'g',0,'2012-03-01'),(550,'g',0,'2011-12-07'),(554,'g',0,'2011-12-07'),(541,'g',0,'2012-03-01'),(229,'g',0,'2011-12-07'),(540,'g',0,'2011-12-07'),(1006,'g',0,'2011-12-07'),(283,'g',0,'2012-01-06'),(679,'g',0,'2012-01-06'),(794,'g',0,'2011-12-07'),(792,'g',0,'2011-12-07'),(795,'g',0,'2011-12-07'),(946,'g',0,'2012-03-01'),(889,'g',0,'2011-12-07'),(899,'g',0,'2011-12-07'),(934,'g',0,'2012-03-01'),(982,'g',0,'2011-12-07'),(912,'g',0,'2012-03-01'),(990,'g',0,'2011-12-07'),(173,'g',0,'2011-12-07'),(184,'g',0,'2011-12-07'),(180,'g',0,'2011-12-07'),(179,'g',0,'2012-03-01'),(187,'g',0,'2011-12-07'),(182,'g',0,'2011-12-07'),(170,'g',0,'2012-03-01'),(169,'g',0,'2011-12-07'),(189,'g',0,'2012-03-01'),(124,'g',0,'2011-12-07'),(139,'g',0,'2011-12-07'),(458,'g',0,'2011-12-08'),(539,'g',0,'2011-12-08'),(822,'g',0,'2012-03-01'),(921,'g',0,'2011-12-08'),(964,'g',0,'2012-03-01'),(944,'g',0,'2011-12-08'),(988,'g',0,'2011-12-08'),(945,'g',0,'2012-03-01'),(987,'g',0,'2011-12-08'),(989,'g',0,'2011-12-08'),(871,'g',0,'2011-12-08'),(860,'g',0,'2012-03-01'),(846,'g',0,'2011-12-08'),(844,'g',0,'2012-03-01'),(835,'g',0,'2011-12-08'),(842,'g',0,'2012-03-01'),(778,'g',0,'2011-12-08'),(782,'g',0,'2011-12-08'),(770,'g',0,'2011-12-08'),(783,'g',0,'2011-12-08'),(777,'g',0,'2011-12-08'),(781,'g',0,'2011-12-08'),(784,'g',0,'2012-03-01'),(779,'g',0,'2011-12-08'),(840,'g',0,'2012-03-01'),(841,'g',0,'2012-03-01'),(845,'g',0,'2012-03-01'),(832,'g',0,'2012-02-02'),(454,'g',0,'2011-12-08'),(420,'g',0,'2012-01-21'),(903,'g',0,'2012-03-01'),(836,'g',0,'2011-12-08'),(852,'g',0,'2012-03-01'),(848,'g',0,'2012-03-01'),(830,'g',0,'2011-12-08'),(873,'g',0,'2011-12-08'),(952,'g',0,'2011-12-08'),(933,'g',0,'2011-12-08'),(937,'g',0,'2011-12-08'),(762,'g',0,'2011-12-08'),(644,'g',0,'2011-12-08'),(750,'g',0,'2011-12-08'),(759,'g',0,'2011-12-08'),(730,'g',0,'2012-01-10'),(575,'g',0,'2012-03-01'),(1030,'g',0,'2011-12-08'),(1023,'g',0,'2012-03-01'),(1005,'g',0,'2011-12-08'),(1013,'g',0,'2011-12-08'),(1012,'g',0,'2011-12-08'),(1019,'g',0,'2012-03-01'),(817,'g',0,'2011-12-09'),(506,'g',0,'2011-12-09'),(967,'g',0,'2012-03-01'),(383,'g',0,'2012-02-06'),(968,'g',0,'2012-03-01'),(432,'g',0,'2012-03-01'),(65,'g',0,'2011-12-10'),(160,'g',0,'2012-02-09'),(162,'g',0,'2012-03-06'),(107,'g',0,'2012-02-09'),(276,'g',0,'2012-03-01'),(467,'g',0,'2012-03-01'),(135,'g',0,'2012-03-01'),(329,'g',0,'2012-01-19'),(335,'g',0,'2012-01-21'),(834,'g',0,'2011-12-10'),(805,'g',0,'2011-12-10'),(507,'g',0,'2012-03-01'),(364,'g',0,'2012-03-06'),(721,'g',0,'2011-12-10'),(833,'g',0,'2011-12-10'),(456,'g',0,'2012-03-06'),(543,'g',0,'2012-03-06'),(1055,'g',0,'2011-12-11'),(1053,'g',0,'2011-12-11'),(855,'g',0,'2012-03-01'),(838,'g',0,'2012-03-01'),(839,'g',0,'2011-12-11'),(965,'g',0,'2011-12-11'),(733,'g',0,'2011-12-12'),(732,'g',0,'2012-03-01'),(466,'g',0,'2011-12-12'),(876,'g',0,'2011-12-12'),(402,'g',0,'2011-12-12'),(894,'g',0,'2011-12-12'),(446,'g',0,'2011-12-12'),(660,'g',0,'2012-03-01'),(601,'g',0,'2011-12-12'),(585,'g',0,'2012-03-01'),(286,'g',0,'2012-03-01'),(641,'g',0,'2011-12-12'),(237,'g',0,'2011-12-12'),(624,'g',0,'2011-12-12'),(994,'g',0,'2011-12-12'),(633,'g',0,'2011-12-12'),(652,'g',0,'2011-12-12'),(199,'g',0,'2012-03-01'),(410,'g',0,'2011-12-12'),(400,'g',0,'2012-03-01'),(448,'g',0,'2012-03-01'),(468,'g',0,'2012-03-01'),(242,'g',0,'2012-03-07'),(281,'g',0,'2012-03-01'),(564,'g',0,'2011-12-13'),(449,'g',0,'2012-03-01'),(403,'g',0,'2011-12-13'),(563,'g',0,'2011-12-13'),(904,'g',0,'2011-12-13'),(1050,'g',0,'2012-03-01'),(1049,'g',0,'2011-12-13'),(1001,'g',0,'2011-12-13'),(451,'g',0,'2012-03-01'),(450,'g',0,'2012-03-01'),(1004,'g',0,'2011-12-13'),(157,'g',0,'2012-02-17'),(181,'g',0,'2012-03-01'),(626,'g',0,'2011-12-14'),(201,'g',0,'2011-12-14'),(501,'g',0,'2011-12-14'),(374,'g',0,'2011-12-14'),(178,'g',0,'2012-03-01'),(388,'g',0,'2012-03-01'),(185,'g',0,'2011-12-14'),(530,'g',0,'2012-03-01'),(251,'g',0,'2012-03-01'),(194,'g',0,'2012-03-01'),(149,'g',0,'2011-12-14'),(226,'g',0,'2012-02-06'),(227,'g',0,'2011-12-14'),(296,'g',0,'2011-12-14'),(331,'g',0,'2011-12-14'),(769,'g',0,'2011-12-14'),(713,'g',0,'2011-12-14'),(625,'g',0,'2011-12-14'),(675,'g',0,'2012-03-01'),(243,'g',0,'2011-12-14'),(542,'g',0,'2012-03-01'),(523,'g',0,'2011-12-14'),(193,'g',0,'2011-12-14'),(566,'g',0,'2011-12-14'),(256,'g',0,'2011-12-14'),(534,'g',0,'2011-12-14'),(623,'g',0,'2011-12-15'),(345,'g',0,'2011-12-15'),(273,'g',0,'2011-12-15'),(503,'g',0,'2011-12-15'),(297,'g',0,'2011-12-15'),(619,'g',0,'2011-12-15'),(401,'g',0,'2011-12-15'),(196,'g',0,'2011-12-15'),(183,'g',0,'2012-03-01'),(66,'g',0,'2011-12-15'),(109,'g',0,'2011-12-15'),(1058,'g',0,'2011-12-15'),(186,'g',0,'2012-01-21'),(704,'g',0,'2011-12-15'),(615,'g',0,'2012-03-01'),(265,'g',0,'2012-03-01'),(565,'g',0,'2011-12-15'),(288,'g',0,'2012-03-01'),(396,'g',0,'2011-12-15'),(645,'g',0,'2012-02-03'),(738,'g',0,'2011-12-15'),(775,'g',0,'2011-12-15'),(673,'g',0,'2011-12-15'),(244,'g',0,'2011-12-15'),(735,'g',0,'2011-12-15'),(551,'g',0,'2011-12-15'),(731,'g',0,'2011-12-15'),(351,'g',0,'2011-12-15'),(234,'g',0,'2011-12-15'),(580,'g',0,'2012-03-01'),(217,'g',0,'2012-01-23'),(216,'g',0,'2012-01-23'),(212,'g',0,'2012-01-23'),(144,'g',0,'2012-03-01'),(275,'g',0,'2011-12-15'),(291,'g',0,'2011-12-15'),(298,'g',0,'2011-12-15'),(499,'g',0,'2011-12-15'),(272,'g',0,'2011-12-15'),(150,'g',0,'2012-03-01'),(549,'g',0,'2011-12-15'),(419,'g',0,'2011-12-15'),(640,'g',0,'2011-12-15'),(348,'g',0,'2011-12-15'),(192,'g',0,'2011-12-15'),(209,'g',0,'2012-01-23'),(661,'g',0,'2011-12-15'),(319,'g',0,'2011-12-15'),(533,'g',0,'2012-03-01'),(247,'g',0,'2011-12-15'),(378,'g',0,'2012-03-01'),(515,'g',0,'2012-03-01'),(763,'g',0,'2012-03-01'),(710,'g',0,'2012-03-01'),(459,'g',0,'2012-03-01'),(711,'g',0,'2011-12-15'),(371,'g',0,'2011-12-15'),(667,'g',0,'2012-03-01'),(544,'g',0,'2012-03-01'),(191,'g',0,'2011-12-15'),(290,'g',0,'2011-12-15'),(728,'g',0,'2011-12-15'),(140,'g',0,'2012-03-05'),(365,'g',0,'2011-12-15'),(638,'g',0,'2011-12-15'),(447,'g',0,'2012-03-07'),(141,'g',0,'2011-12-15'),(274,'g',0,'2011-12-15'),(287,'g',0,'2011-12-15'),(386,'g',0,'2012-03-01'),(553,'g',0,'2011-12-15'),(497,'g',0,'2011-12-15'),(258,'g',0,'2012-03-01'),(498,'g',0,'2011-12-15'),(136,'g',0,'2012-03-01'),(453,'g',0,'2011-12-16'),(742,'g',0,'2011-12-16'),(695,'g',0,'2011-12-16'),(724,'g',0,'2011-12-16'),(665,'g',0,'2011-12-16'),(269,'g',0,'2012-02-06'),(137,'g',0,'2011-12-16'),(318,'g',0,'2011-12-16'),(321,'g',0,'2011-12-16'),(142,'g',0,'2012-02-27'),(370,'g',0,'2011-12-16'),(151,'g',0,'2012-03-01'),(235,'g',0,'2012-03-01'),(322,'g',0,'2011-12-16'),(574,'g',0,'2011-12-16'),(546,'g',0,'2011-12-16'),(147,'g',0,'2012-01-21'),(323,'g',0,'2011-12-16'),(239,'g',0,'2011-12-16'),(643,'g',0,'2011-12-16'),(176,'g',0,'2011-12-16'),(436,'g',0,'2012-03-01'),(289,'g',0,'2011-12-16'),(190,'g',0,'2011-12-16'),(636,'g',0,'2011-12-16'),(586,'g',0,'2011-12-16'),(253,'g',0,'2011-12-16'),(717,'g',0,'2011-12-16'),(719,'g',0,'2011-12-16'),(718,'g',0,'2011-12-16'),(680,'g',0,'2012-03-01'),(433,'g',0,'2011-12-16'),(664,'g',0,'2011-12-16'),(202,'g',0,'2011-12-16'),(311,'g',0,'2011-12-16'),(519,'g',0,'2012-03-01'),(259,'g',0,'2012-03-01'),(361,'g',0,'2011-12-16'),(637,'g',0,'2012-03-01'),(328,'g',0,'2011-12-16'),(483,'g',0,'2011-12-16'),(317,'g',0,'2011-12-16'),(579,'g',0,'2011-12-16'),(337,'g',0,'2011-12-16'),(236,'g',0,'2012-03-01'),(697,'g',0,'2012-03-01'),(316,'g',0,'2011-12-16'),(267,'g',0,'2011-12-16'),(153,'g',0,'2011-12-16'),(651,'g',0,'2011-12-16'),(248,'g',0,'2011-12-16'),(500,'g',0,'2011-12-16'),(246,'g',0,'2011-12-16'),(960,'g',0,'2011-12-17'),(736,'g',0,'2011-12-17'),(998,'g',0,'2012-03-01'),(913,'g',0,'2012-02-06'),(1020,'g',0,'2011-12-17'),(219,'g',0,'2011-12-18'),(931,'g',0,'2012-02-16'),(910,'g',0,'2012-03-01'),(914,'g',0,'2012-02-06'),(956,'g',0,'2011-12-18'),(228,'g',0,'2012-03-01'),(1003,'g',0,'2011-12-18'),(880,'g',0,'2012-03-01'),(882,'g',0,'2012-02-19'),(230,'g',0,'2012-01-21'),(883,'g',0,'2012-01-21'),(881,'g',0,'2012-03-01'),(749,'g',0,'2012-03-04'),(1144,'g',0,'2012-03-04'),(177,'g',0,'2011-12-21'),(997,'g',0,'2012-03-01'),(986,'g',0,'2011-12-21'),(995,'g',0,'2011-12-21'),(975,'g',0,'2011-12-21'),(1021,'g',0,'2011-12-21'),(1038,'g',0,'2011-12-21'),(1032,'g',0,'2011-12-21'),(1000,'g',0,'2011-12-21'),(1022,'g',0,'2011-12-21'),(1028,'g',0,'2011-12-21'),(158,'g',0,'2012-02-06'),(159,'g',0,'2012-03-01'),(163,'g',0,'2011-12-21'),(155,'g',0,'2011-12-21'),(614,'g',0,'2012-03-01'),(156,'g',0,'2011-12-21'),(161,'g',0,'2012-03-01'),(154,'g',0,'2012-03-01'),(148,'g',0,'2011-12-21'),(143,'g',0,'2012-03-01'),(1080,'g',0,'2012-03-01'),(1199,'g',0,'2011-12-21'),(1169,'g',0,'2011-12-21'),(1088,'g',0,'2011-12-21'),(1082,'g',0,'2011-12-21'),(1207,'g',0,'2011-12-21'),(1204,'g',0,'2011-12-21'),(1183,'g',0,'2011-12-21'),(1149,'g',0,'2011-12-21'),(1182,'g',0,'2011-12-21'),(1180,'g',0,'2011-12-21'),(1052,'g',0,'2011-12-21'),(168,'g',0,'2012-02-25'),(699,'g',0,'2011-12-22'),(716,'g',0,'2011-12-22'),(715,'g',0,'2011-12-22'),(940,'g',0,'2011-12-22'),(928,'g',0,'2011-12-22'),(698,'g',0,'2011-12-22'),(701,'g',0,'2012-03-01'),(747,'g',0,'2011-12-22'),(983,'g',0,'2011-12-22'),(992,'g',0,'2011-12-22'),(941,'g',0,'2011-12-22'),(100,'g',0,'2011-12-22'),(927,'g',0,'2011-12-22'),(929,'g',0,'2011-12-22'),(700,'g',0,'2011-12-22'),(1009,'g',0,'2011-12-22'),(1002,'g',0,'2011-12-22'),(658,'g',0,'2011-12-22'),(828,'g',0,'2011-12-22'),(653,'g',0,'2011-12-22'),(789,'g',0,'2011-12-22'),(804,'g',0,'2011-12-22'),(678,'g',0,'2011-12-22'),(570,'g',0,'2011-12-22'),(656,'g',0,'2011-12-22'),(756,'g',0,'2011-12-22'),(808,'g',0,'2011-12-22'),(906,'g',0,'2011-12-22'),(571,'g',0,'2011-12-22'),(878,'g',0,'2011-12-22'),(905,'g',0,'2011-12-22'),(887,'g',0,'2011-12-22'),(922,'g',0,'2011-12-22'),(787,'g',0,'2012-03-01'),(556,'g',0,'2011-12-22'),(916,'g',0,'2012-02-03'),(785,'g',0,'2012-03-01'),(801,'g',0,'2011-12-22'),(803,'g',0,'2011-12-22'),(659,'g',0,'2012-03-01'),(879,'g',0,'2011-12-22'),(655,'g',0,'2011-12-22'),(788,'g',0,'2012-03-01'),(790,'g',0,'2011-12-22'),(663,'g',0,'2011-12-22'),(654,'g',0,'2011-12-22'),(823,'g',0,'2011-12-22'),(791,'g',0,'2012-03-01'),(867,'g',0,'2011-12-22'),(800,'g',0,'2011-12-22'),(802,'g',0,'2011-12-22'),(1042,'g',0,'2011-12-22'),(1016,'g',0,'2011-12-22'),(1018,'g',0,'2011-12-22'),(1079,'g',0,'2011-12-22'),(1017,'g',0,'2011-12-22'),(1043,'g',0,'2011-12-22'),(1093,'g',0,'2011-12-22'),(1094,'g',0,'2011-12-22'),(1027,'g',0,'2011-12-22'),(1095,'g',0,'2011-12-22'),(363,'g',0,'2011-12-22'),(377,'g',0,'2012-03-01'),(174,'g',0,'2012-03-01'),(382,'g',0,'2011-12-22'),(369,'g',0,'2011-12-22'),(547,'g',0,'2012-03-01'),(609,'g',0,'2012-03-01'),(706,'g',0,'2011-12-22'),(707,'g',0,'2011-12-22'),(708,'g',0,'2011-12-22'),(705,'g',0,'2011-12-22'),(409,'g',0,'2012-03-06'),(442,'g',0,'2012-03-01'),(723,'g',0,'2011-12-22'),(431,'g',0,'2012-03-01'),(737,'g',0,'2011-12-22'),(457,'g',0,'2011-12-22'),(766,'g',0,'2012-03-01'),(455,'g',0,'2011-12-22'),(752,'g',0,'2011-12-22'),(829,'g',0,'2011-12-22'),(476,'g',0,'2012-03-01'),(819,'g',0,'2012-03-01'),(831,'g',0,'2012-03-01'),(815,'g',0,'2012-03-01'),(798,'g',0,'2011-12-23'),(818,'g',0,'2011-12-23'),(771,'g',0,'2012-03-01'),(807,'g',0,'2012-03-01'),(1096,'g',0,'2011-12-23'),(1103,'g',0,'2011-12-23'),(1097,'g',0,'2011-12-23'),(1104,'g',0,'2011-12-23'),(1101,'g',0,'2011-12-23'),(1105,'g',0,'2011-12-23'),(1098,'g',0,'2011-12-23'),(1100,'g',0,'2011-12-23'),(1099,'g',0,'2011-12-23'),(1102,'g',0,'2011-12-23'),(1074,'g',0,'2011-12-23'),(1051,'g',0,'2011-12-23'),(1076,'g',0,'2011-12-23'),(1073,'g',0,'2011-12-23'),(1075,'g',0,'2011-12-23'),(444,'g',0,'2012-03-01'),(437,'g',0,'2012-03-01'),(1195,'g',0,'2012-01-04'),(461,'g',0,'2012-03-01'),(548,'g',0,'2011-12-23'),(1225,'g',0,'2011-12-26'),(1229,'g',0,'2012-03-01'),(1212,'g',0,'2011-12-26'),(1156,'g',0,'2011-12-27'),(1224,'g',0,'2011-12-28'),(1257,'g',0,'2012-02-06'),(1300,'g',0,'2012-03-04'),(1293,'g',0,'2012-03-04'),(858,'g',0,'2012-01-03'),(849,'g',0,'2012-03-01'),(861,'g',0,'2012-01-03'),(853,'g',0,'2012-03-06'),(856,'g',0,'2012-01-03'),(857,'g',0,'2012-01-03'),(851,'g',0,'2012-03-01'),(854,'g',0,'2012-01-03'),(847,'g',0,'2012-03-01'),(859,'g',0,'2012-01-03'),(1194,'g',0,'2012-03-01'),(1193,'g',0,'2012-01-04'),(1348,'g',0,'2012-03-01'),(1358,'g',0,'2012-01-04'),(1288,'g',0,'2012-03-01'),(1299,'g',0,'2012-01-04'),(223,'g',0,'2012-02-06'),(241,'g',0,'2012-01-04'),(646,'g',0,'2012-01-05'),(996,'g',0,'2012-02-16'),(959,'g',0,'2012-01-06'),(250,'g',0,'2012-01-06'),(195,'g',0,'2012-01-06'),(198,'g',0,'2012-01-06'),(1222,'g',0,'2012-01-07'),(1289,'g',0,'2012-02-06'),(134,'g',0,'2012-01-07'),(1337,'g',0,'2012-01-08'),(1192,'g',0,'2012-01-08'),(1152,'g',0,'2012-03-01'),(1172,'g',0,'2012-01-08'),(1085,'g',0,'2012-03-01'),(1187,'g',0,'2012-03-01'),(1216,'g',0,'2012-03-01'),(1205,'g',0,'2012-01-09'),(1171,'g',0,'2012-03-01'),(1151,'g',0,'2012-03-01'),(980,'g',0,'2012-01-10'),(1310,'g',0,'2012-01-10'),(1292,'g',0,'2012-03-01'),(1298,'g',0,'2012-03-01'),(1302,'g',0,'2012-01-11'),(875,'g',0,'2012-01-11'),(1223,'g',0,'2012-03-01'),(1349,'g',0,'2012-01-15'),(1261,'g',0,'2012-03-01'),(1408,'g',0,'2012-03-01'),(1268,'g',0,'2012-01-15'),(1184,'g',0,'2012-01-16'),(1363,'g',0,'2012-03-01'),(1375,'g',0,'2012-01-16'),(1185,'g',0,'2012-03-01'),(1237,'g',0,'2012-03-04'),(1329,'g',0,'2012-01-20'),(1395,'g',0,'2012-01-20'),(1330,'g',0,'2012-01-20'),(1278,'g',0,'2012-03-01'),(1424,'g',0,'2012-01-20'),(1271,'g',0,'2012-03-01'),(1345,'g',0,'2012-03-01'),(1252,'g',0,'2012-03-01'),(898,'g',0,'2012-01-21'),(877,'g',0,'2012-01-21'),(924,'g',0,'2012-01-21'),(1057,'g',0,'2012-01-21'),(1072,'g',0,'2012-03-01'),(218,'g',0,'2012-01-23'),(1230,'g',0,'2012-03-01'),(1361,'g',0,'2012-01-23'),(1331,'g',0,'2012-01-24'),(1272,'g',0,'2012-03-01'),(891,'g',0,'2012-01-26'),(863,'g',0,'2012-01-26'),(947,'g',0,'2012-01-26'),(866,'g',0,'2012-01-26'),(865,'g',0,'2012-01-26'),(1351,'g',0,'2012-01-26'),(1415,'g',0,'2012-02-04'),(1451,'g',0,'2012-02-04'),(1540,'g',0,'2012-02-04'),(1515,'g',0,'2012-02-04'),(1372,'g',0,'2012-02-04'),(1512,'g',0,'2012-02-05'),(1529,'g',0,'2012-02-06'),(1462,'g',0,'2012-02-06'),(939,'g',0,'2012-02-07'),(938,'g',0,'2012-02-07'),(1087,'g',0,'2012-02-11'),(864,'g',0,'2012-02-11'),(821,'g',0,'2012-02-11'),(826,'g',0,'2012-02-11'),(943,'g',0,'2012-02-11'),(897,'g',0,'2012-02-11'),(743,'g',0,'2012-02-11'),(1555,'g',0,'2012-02-11'),(1452,'g',0,'2012-02-11'),(1576,'g',0,'2012-02-11'),(1433,'g',0,'2012-02-11'),(1446,'g',0,'2012-02-11'),(1533,'g',0,'2012-02-11'),(1242,'g',0,'2012-02-11'),(1241,'g',0,'2012-02-11'),(1448,'g',0,'2012-02-11'),(977,'g',0,'2012-02-11'),(1188,'g',0,'2012-02-11'),(1189,'g',0,'2012-02-11'),(1203,'g',0,'2012-02-11'),(657,'g',0,'2012-02-11'),(1236,'g',0,'2012-02-11'),(1201,'g',0,'2012-02-11'),(1202,'g',0,'2012-02-11'),(1010,'g',0,'2012-02-11'),(630,'g',0,'2012-02-11'),(984,'g',0,'2012-02-11'),(1196,'g',0,'2012-02-12'),(1274,'g',0,'2012-02-12'),(1385,'g',0,'2012-02-12'),(1314,'g',0,'2012-02-12'),(1344,'g',0,'2012-02-12'),(1327,'g',0,'2012-02-12'),(1316,'g',0,'2012-02-12'),(1210,'g',0,'2012-02-12'),(874,'g',0,'2012-02-12'),(893,'g',0,'2012-02-12'),(1402,'g',0,'2012-02-12'),(1633,'g',0,'2012-02-14'),(1333,'g',0,'2012-02-14'),(1153,'g',0,'2012-02-15'),(1178,'g',0,'2012-02-15'),(1146,'g',0,'2012-02-15'),(1147,'g',0,'2012-02-15'),(1309,'g',0,'2012-02-15'),(1177,'g',0,'2012-02-15'),(1328,'g',0,'2012-02-15'),(1173,'g',0,'2012-02-15'),(1249,'g',0,'2012-02-15'),(1258,'g',0,'2012-02-15'),(1313,'g',0,'2012-02-15'),(1324,'g',0,'2012-02-15'),(1296,'g',0,'2012-02-15'),(1170,'g',0,'2012-02-15'),(1238,'g',0,'2012-02-15'),(1226,'g',0,'2012-02-15'),(1217,'g',0,'2012-02-15'),(1317,'g',0,'2012-02-15'),(1279,'g',0,'2012-02-15'),(1334,'g',0,'2012-02-15'),(1275,'g',0,'2012-02-15'),(1154,'g',0,'2012-02-15'),(1322,'g',0,'2012-02-15'),(1321,'g',0,'2012-02-15'),(1174,'g',0,'2012-02-15'),(1175,'g',0,'2012-02-15'),(1176,'g',0,'2012-02-15'),(1281,'g',0,'2012-02-15'),(1336,'g',0,'2012-02-15'),(1599,'g',0,'2012-02-16'),(1220,'g',0,'2012-02-16'),(868,'g',0,'2012-02-16'),(1561,'g',0,'2012-02-16'),(1391,'g',0,'2012-02-16'),(1353,'g',0,'2012-02-16'),(1603,'g',0,'2012-02-16'),(1390,'g',0,'2012-02-16'),(1244,'g',0,'2012-02-16'),(1471,'g',0,'2012-02-16'),(1511,'g',0,'2012-02-16'),(764,'g',0,'2012-02-16'),(812,'g',0,'2012-02-16'),(1211,'g',0,'2012-02-16'),(843,'g',0,'2012-02-16'),(765,'g',0,'2012-02-16'),(772,'g',0,'2012-02-16'),(1025,'g',0,'2012-02-16'),(979,'g',0,'2012-02-16'),(816,'g',0,'2012-02-16'),(1332,'g',0,'2012-02-16'),(1405,'g',0,'2012-02-16'),(1379,'g',0,'2012-02-16'),(1396,'g',0,'2012-02-16'),(1450,'g',0,'2012-02-16'),(1526,'g',0,'2012-02-16'),(1606,'g',0,'2012-02-16'),(1467,'g',0,'2012-02-16'),(1584,'g',0,'2012-02-17'),(1447,'g',0,'2012-02-17'),(911,'g',0,'2012-02-17'),(1024,'g',0,'2012-02-17'),(972,'g',0,'2012-02-17'),(1362,'g',0,'2012-02-17'),(970,'g',0,'2012-02-17'),(892,'g',0,'2012-02-17'),(969,'g',0,'2012-02-17'),(973,'g',0,'2012-02-17'),(971,'g',0,'2012-02-17'),(1620,'g',0,'2012-02-17'),(976,'g',0,'2012-02-17'),(1610,'g',0,'2012-02-17'),(1231,'g',0,'2012-02-17'),(1034,'g',0,'2012-02-17'),(1631,'g',0,'2012-02-17'),(1110,'g',0,'2012-02-17'),(1114,'g',0,'2012-02-17'),(1113,'g',0,'2012-02-17'),(1124,'g',0,'2012-02-17'),(1134,'g',0,'2012-02-17'),(1122,'g',0,'2012-02-17'),(1121,'g',0,'2012-02-17'),(1118,'g',0,'2012-02-17'),(1119,'g',0,'2012-02-17'),(1109,'g',0,'2012-02-17'),(1125,'g',0,'2012-02-17'),(1116,'g',0,'2012-02-17'),(936,'g',0,'2012-02-17'),(1107,'g',0,'2012-02-17'),(935,'g',0,'2012-02-17'),(1132,'g',0,'2012-02-17'),(1106,'g',0,'2012-02-17'),(1128,'g',0,'2012-02-17'),(1127,'g',0,'2012-02-17'),(1131,'g',0,'2012-02-17'),(1123,'g',0,'2012-02-17'),(1129,'g',0,'2012-02-17'),(1133,'g',0,'2012-02-17'),(1108,'g',0,'2012-02-17'),(1130,'g',0,'2012-02-17'),(1115,'g',0,'2012-02-17'),(1126,'g',0,'2012-02-17'),(1239,'g',0,'2012-02-17'),(1136,'g',0,'2012-02-17'),(1355,'g',0,'2012-02-17'),(1326,'g',0,'2012-02-17'),(1290,'g',0,'2012-02-17'),(1626,'g',0,'2012-02-17'),(1318,'g',0,'2012-02-17'),(1138,'g',0,'2012-02-17'),(1401,'g',0,'2012-02-17'),(1378,'g',0,'2012-02-17'),(1142,'g',0,'2012-02-17'),(1356,'g',0,'2012-02-17'),(1335,'g',0,'2012-02-17'),(1384,'g',0,'2012-02-17'),(1368,'g',0,'2012-02-17'),(1386,'g',0,'2012-02-17'),(1350,'g',0,'2012-02-17'),(1304,'g',0,'2012-02-17'),(1383,'g',0,'2012-02-17'),(1135,'g',0,'2012-02-17'),(1137,'g',0,'2012-02-17'),(1400,'g',0,'2012-02-17'),(1303,'g',0,'2012-02-17'),(1377,'g',0,'2012-02-17'),(1240,'g',0,'2012-02-17'),(1294,'g',0,'2012-02-17'),(1248,'g',0,'2012-02-17'),(1139,'g',0,'2012-02-17'),(1623,'g',0,'2012-02-17'),(1140,'g',0,'2012-02-17'),(647,'g',0,'2012-02-17'),(870,'g',0,'2012-02-17'),(919,'g',0,'2012-02-17'),(1613,'g',0,'2012-02-17'),(949,'g',0,'2012-02-17'),(1089,'g',0,'2012-02-17'),(1056,'g',0,'2012-02-17'),(1323,'g',0,'2012-02-17'),(1255,'g',0,'2012-02-17'),(366,'g',0,'2012-02-17'),(993,'g',0,'2012-02-17'),(991,'g',0,'2012-02-17'),(1352,'g',0,'2012-02-17'),(953,'g',0,'2012-02-17'),(955,'g',0,'2012-02-17'),(1015,'g',0,'2012-02-17'),(954,'g',0,'2012-02-17'),(1315,'g',0,'2012-02-17'),(1305,'g',0,'2012-02-17'),(1284,'g',0,'2012-02-17'),(1259,'g',0,'2012-02-17'),(917,'g',0,'2012-02-17'),(958,'g',0,'2012-02-17'),(895,'g',0,'2012-02-17'),(505,'g',0,'2012-02-17'),(966,'g',0,'2012-02-17'),(1014,'g',0,'2012-02-17'),(869,'g',0,'2012-02-17'),(469,'g',0,'2012-02-17'),(1308,'g',0,'2012-02-17'),(1319,'g',0,'2012-02-17'),(1320,'g',0,'2012-02-17'),(1340,'g',0,'2012-02-17'),(1382,'g',0,'2012-02-17'),(1381,'g',0,'2012-02-17'),(1347,'g',0,'2012-02-17'),(1537,'g',0,'2012-02-17'),(1461,'g',0,'2012-02-17'),(1453,'g',0,'2012-02-17'),(1008,'g',0,'2012-02-17'),(1404,'g',0,'2012-02-17'),(1477,'g',0,'2012-02-17'),(1518,'g',0,'2012-02-17'),(1530,'g',0,'2012-02-17'),(1360,'g',0,'2012-02-17'),(1366,'g',0,'2012-02-17'),(1590,'g',0,'2012-02-18'),(1618,'g',0,'2012-02-18'),(1596,'g',0,'2012-02-18'),(957,'g',0,'2012-02-18'),(1513,'g',0,'2012-02-18'),(1039,'g',0,'2012-02-19'),(1604,'g',0,'2012-02-19'),(1588,'g',0,'2012-02-19'),(1587,'g',0,'2012-02-19'),(884,'g',0,'2012-02-19'),(820,'g',0,'2012-02-19'),(727,'g',0,'2012-02-19'),(1629,'g',0,'2012-02-19'),(418,'g',0,'2012-02-19'),(617,'g',0,'2012-02-19'),(1632,'g',0,'2012-02-19'),(885,'g',0,'2012-02-20'),(890,'g',0,'2012-02-20'),(1148,'g',0,'2012-02-20'),(1470,'g',0,'2012-02-20'),(1418,'g',0,'2012-02-20'),(1524,'g',0,'2012-02-20'),(1246,'g',0,'2012-02-20'),(1472,'g',0,'2012-02-20'),(1354,'g',0,'2012-02-20'),(1630,'g',0,'2012-02-20'),(813,'g',0,'2012-02-20'),(1307,'g',0,'2012-02-20'),(1369,'g',0,'2012-02-20'),(674,'g',0,'2012-02-20'),(1410,'g',0,'2012-02-20'),(1639,'g',0,'2012-02-20'),(1476,'g',0,'2012-02-20'),(1235,'g',0,'2012-02-20'),(676,'g',0,'2012-02-20'),(748,'g',0,'2012-02-20'),(1636,'g',0,'2012-02-20'),(1574,'g',0,'2012-02-20'),(1615,'g',0,'2012-02-20'),(1619,'g',0,'2012-02-20'),(1579,'g',0,'2012-02-20'),(692,'g',0,'2012-02-20'),(837,'g',0,'2012-02-20'),(1637,'g',0,'2012-02-20'),(1602,'g',0,'2012-02-20'),(1622,'g',0,'2012-02-20'),(1621,'g',0,'2012-02-20'),(999,'g',0,'2012-02-21'),(1617,'g',0,'2012-02-24'),(1387,'g',0,'2012-02-24'),(1535,'g',0,'2012-02-24'),(1628,'g',0,'2012-02-24'),(1221,'g',0,'2012-02-24'),(1474,'g',0,'2012-02-25'),(1475,'g',0,'2012-02-25'),(1704,'g',0,'2012-03-01'),(1648,'g',0,'2012-03-01'),(1466,'g',0,'2012-03-01'),(1548,'g',0,'2012-03-01'),(1638,'g',0,'2012-03-01'),(1580,'g',0,'2012-03-01'),(1264,'g',0,'2012-03-01'),(1682,'g',0,'2012-03-01'),(1660,'g',0,'2012-03-01'),(1672,'g',0,'2012-03-01'),(1616,'g',0,'2012-03-01'),(1245,'g',0,'2012-03-01'),(1594,'g',0,'2012-03-01'),(1528,'g',0,'2012-03-01'),(1701,'g',0,'2012-03-01'),(1516,'g',0,'2012-03-01'),(1519,'g',0,'2012-03-01'),(1551,'g',0,'2012-03-01'),(1676,'g',0,'2012-03-01'),(1473,'g',0,'2012-03-01'),(1567,'g',0,'2012-03-01'),(1657,'g',0,'2012-03-01'),(1542,'g',0,'2012-03-01'),(1656,'g',0,'2012-03-01'),(1647,'g',0,'2012-03-01'),(786,'g',0,'2012-03-01'),(1406,'g',0,'2012-03-01'),(145,'g',0,'2012-03-01'),(1544,'g',0,'2012-03-01'),(1260,'g',0,'2012-03-01'),(1659,'g',0,'2012-03-01'),(1690,'g',0,'2012-03-01'),(1646,'g',0,'2012-03-01'),(896,'g',0,'2012-03-01'),(1251,'g',0,'2012-03-01'),(1558,'g',0,'2012-03-01'),(1695,'g',0,'2012-03-01'),(1683,'g',0,'2012-03-01'),(1454,'g',0,'2012-03-01'),(1703,'g',0,'2012-03-03'),(1086,'g',0,'2012-03-03'),(1664,'g',0,'2012-03-03'),(1367,'g',0,'2012-03-03'),(1686,'g',0,'2012-03-03'),(1678,'g',0,'2012-03-03'),(1684,'g',0,'2012-03-03'),(1649,'g',0,'2012-03-03'),(1155,'g',0,'2012-03-03'),(1150,'g',0,'2012-03-03'),(1077,'g',0,'2012-03-03'),(1157,'g',0,'2012-03-03'),(1667,'g',0,'2012-03-03'),(1681,'g',0,'2012-03-03'),(1675,'g',0,'2012-03-03'),(1557,'g',0,'2012-03-03'),(1663,'g',0,'2012-03-03'),(1661,'g',0,'2012-03-03'),(1564,'g',0,'2012-03-04'),(1158,'g',0,'2012-03-04'),(1669,'g',0,'2012-03-04'),(1668,'g',0,'2012-03-04'),(1218,'g',0,'2012-03-04'),(1083,'g',0,'2012-03-04'),(1688,'g',0,'2012-03-04'),(1687,'g',0,'2012-03-04'),(1671,'g',0,'2012-03-04'),(1691,'g',0,'2012-03-04'),(1653,'g',0,'2012-03-04'),(1692,'g',0,'2012-03-04'),(1041,'g',0,'2012-03-04'),(1047,'g',0,'2012-03-04'),(1048,'g',0,'2012-03-04'),(1035,'g',0,'2012-03-04'),(1627,'g',0,'2012-03-04'),(1699,'g',0,'2012-03-04'),(1243,'g',0,'2012-03-04'),(1262,'g',0,'2012-03-04'),(1143,'g',0,'2012-03-04'),(1254,'g',0,'2012-03-04'),(307,'g',0,'2012-03-04'),(1253,'g',0,'2012-03-04'),(1342,'g',0,'2012-03-04'),(1677,'g',0,'2012-03-04'),(1458,'g',0,'2012-03-04'),(1206,'g',0,'2012-03-04'),(1645,'g',0,'2012-03-04'),(1634,'g',0,'2012-03-04'),(1265,'g',0,'2012-03-04'),(1209,'g',0,'2012-03-04'),(1670,'g',0,'2012-03-04'),(1643,'g',0,'2012-03-05'),(1651,'g',0,'2012-03-05'),(1641,'g',0,'2012-03-05'),(1214,'g',0,'2012-03-05'),(280,'g',0,'2012-03-05'),(1654,'g',0,'2012-03-05'),(1186,'g',0,'2012-03-05'),(1642,'g',0,'2012-03-05'),(1698,'g',0,'2012-03-06'),(908,'g',0,'2012-03-06'),(907,'g',0,'2012-03-07'),(909,'g',0,'2012-03-07'),(1697,'g',0,'2012-03-07'),(1635,'g',0,'2012-03-07'),(1718,'g',0,'2012-03-07');

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

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

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


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

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

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

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

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

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

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


--
-- Table structure for table `idx_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=3 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_review` VALUES (1,882,'eBrandz is a world class company. Their level of customer service is one of the highest I have ever received. Completely professional with all processes in order. ',5,'2012-01-03','Reviews','1','','shopers','renfred.morris@gmail.com'),(2,882,'EXCELLENT! I got a surprise discount!',4,'2012-01-03','reviews','1','','shoppers','gilroy.stevens@gmail.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 ('prepmunch','2011-11-29 00:16:51',2,'203.92.47.195'),('eyelidplasticsurgerylosangeles.com','2011-12-02 15:58:35',0,'203.92.47.195'),('sinussurgerylosangeles.com','2011-12-02 16:33:58',0,'203.92.47.195'),('Hernialosangeles.com','2011-12-02 17:04:16',0,'203.92.47.195'),('Podiatrists Texas','2011-12-05 23:44:56',1,'203.92.47.195'),('Laparoscopic Removal of Gallblader','2011-12-06 01:23:26',1,'203.92.47.195'),('http://www.topplacementseo.com','2011-12-06 21:49:05',1,'203.92.47.195'),('http://www.dissertationserviceuk.com','2011-12-06 22:54:52',1,'203.92.47.195'),('cheltenhamsurfacing.co.uk','2011-12-14 04:12:05',1,'203.92.47.195'),('socialsecuritydisabilityattorney.com','2011-12-19 09:14:50',1,'203.92.47.195'),('Newformkitchen.com','2011-12-21 03:22:09',1,'203.92.47.195'),('wilsons','2011-12-22 07:14:19',1,'203.92.47.195'),('http://www.alwaysthereinc.com','2011-12-23 02:18:16',1,'203.92.47.195'),('http://www.siriosvillage.gr','2011-12-28 23:50:16',2,'203.92.47.195'),('http://www.airconditioning-filter.com','2012-01-02 20:40:35',7,'203.92.47.195'),('http://www.footankle.com/dry-needling-plantar-fascia.htm','2012-01-02 21:16:38',1,'203.92.47.195'),('http://www.moneylife.in','2012-01-05 23:13:37',1,'203.92.47.195'),('grgb.co.uk','2012-01-06 03:35:19',1,'203.92.47.195'),('Gearboxes Bath','2012-01-06 03:35:52',1,'203.92.47.195'),('thomaslawoffice.net','2012-01-06 03:36:09',3,'203.92.47.195'),('thomaslawoffice','2012-01-06 03:36:26',3,'203.92.47.195'),('foota','2012-01-06 03:37:36',16,'203.92.47.195'),('footank','2012-01-06 03:37:52',16,'203.92.47.195'),('footan','2012-01-06 03:38:17',16,'203.92.47.195'),('rupcoe.com','2012-01-10 04:33:10',1,'203.92.47.195'),('prising policy','2012-01-10 13:16:08',0,'27.106.12.215'),('Lordandkobrin.com','2012-01-11 00:31:07',1,'203.92.47.195'),('burunsuzyanlaw.com','2012-01-11 23:29:09',1,'203.92.47.195'),('simonsandsimonslaw.com','2012-01-17 05:52:12',1,'203.92.47.195'),('http://www.drwilkenfeld.com','2012-01-18 03:08:24',2,'203.92.47.195'),('shawcoremodeling.com','2012-01-20 02:46:41',1,'203.92.47.195'),('Lutheranseniorlife.org','2012-02-03 02:35:08',1,'203.92.47.195'),('allwaysglazingworks.co.uk','2012-02-06 04:17:35',1,'203.92.47.195'),('Mazon.com','2012-02-06 06:18:28',1,'203.92.47.195'),('farnhaminsurance.com','2012-02-06 06:50:45',1,'203.92.47.195'),('Employee Criminal Background Check','2012-02-06 23:47:45',1,'203.92.47.195'),('http://www.ecoharmonystore.com','2012-02-07 00:00:52',2,'203.92.47.195'),('http://www.ecoharmonystore.com','2012-02-07 00:00:56',2,'203.92.47.195'),('http://www.armofficemovingdallas.com','2012-02-10 03:23:36',1,'203.92.47.195'),('http://www.technocnc.com','2012-02-14 05:03:40',1,'203.92.47.195'),('GrowingStars','2012-02-15 02:29:21',1,'203.92.47.195'),('http://www.hedenvironmentalsystems.com','2012-02-16 23:16:20',1,'203.92.47.195'),('http://www.goldenteak.com','2012-02-17 05:13:36',2,'203.92.47.195'),('http://www.wilsonrentalcenter.com','2012-02-25 00:28:59',1,'203.92.47.195'),('http://www.lawofficesofjosephmendoza.com','2012-02-25 03:08:50',1,'203.92.47.195'),('http://www.easysiders.net','2012-02-27 23:35:43',1,'203.92.47.195'),('http://www.priority-appliance-repair.com','2012-02-27 23:42:54',1,'203.92.47.195'),('http://www.bosenterprisesinc.com','2012-03-01 00:40:59',1,'203.92.47.195'),('http://www.chairsbazaar.com.','2012-03-01 23:37:26',0,'203.92.47.195'),('http://www.aactionpc.net','2012-03-06 05:23:24',1,'203.92.47.195'),('http://www.hassibicriminaldefense.com','2012-03-06 21:42:24',1,'203.92.47.195'),('http://www.playitagainsportsstmatthews.com','2012-03-06 23:46:20',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) 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','editorssubmit.com'),(5,'site_url','http://editorssubmit.com'),(6,'email_address','steve-dsouza@live.com'),(7,'language_code','en_US'),(8,'theme_path','/home/editorss/public_html/themes/'),(9,'admin_template_path','/home/editorss/public_html/admin_tpl/'),(10,'plugin_path','/home/editorss/public_html/plugin/'),(12,'active_theme','temper'),(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`
--



