--
-- Host: hotlisting.co.uk    Database: hotlisti_hotlisti
-- ------------------------------------------------------


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

--
-- Dumping data for table `directory_save_data`
--


--
-- Table structure for table `idx_admin_menu`
--

CREATE TABLE `idx_admin_menu` (
  `menu_id` int(11) NOT NULL auto_increment,
  `parent_id` int(11) default NULL,
  `menu_title` varchar(255) collate latin1_general_ci default NULL,
  `menu_url` varchar(255) collate latin1_general_ci default NULL,
  `order_number` int(11) default NULL,
  PRIMARY KEY  (`menu_id`)
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `idx_admin_menu`
--



--
-- Table structure for table `idx_bad_link`
--

CREATE TABLE `idx_bad_link` (
  `bad_link_id` mediumint(9) unsigned NOT NULL auto_increment,
  `link_id` mediumint(9) unsigned NOT NULL default '0',
  `name` varchar(50) collate latin1_general_ci NOT NULL default '',
  `email` varchar(50) collate latin1_general_ci NOT NULL default '',
  `type` tinyint(3) unsigned NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`bad_link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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


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

CREATE TABLE `idx_badwords` (
  `word` varchar(100) collate latin1_general_ci NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `idx_badwords`
--


--
-- Table structure for table `idx_blocked_domain`
--

CREATE TABLE `idx_blocked_domain` (
  `blocked_id` int(11) NOT NULL auto_increment,
  `blocked` varchar(255) collate latin1_general_ci default NULL,
  `type` enum('domain','ip') collate latin1_general_ci default NULL,
  PRIMARY KEY  (`blocked_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `idx_blocked_domain`
--

INSERT INTO `idx_blocked_domain` VALUES (1,'buydomains.com','domain'),(2,'this-domain-for-sale.com ','domain'),(3,'oversee.net','domain'),(4,'eNom','domain'),(5,'sedoparking.com','domain');

--
-- Table structure for table `idx_category`
--

CREATE TABLE `idx_category` (
  `category_id` mediumint(9) unsigned NOT NULL auto_increment,
  `parent_id` mediumint(9) unsigned NOT NULL default '0',
  `name` varchar(100) collate latin1_general_ci NOT NULL default '',
  `description` text collate latin1_general_ci NOT NULL,
  `image` varchar(100) collate latin1_general_ci default NULL,
  `content` text collate latin1_general_ci,
  `visible` char(1) collate latin1_general_ci default NULL,
  `links` mediumint(9) default NULL,
  `meta_keyword` text collate latin1_general_ci,
  `meta_description` text collate latin1_general_ci,
  `permission` char(2) collate latin1_general_ci default NULL,
  `registered_only` char(1) collate latin1_general_ci default NULL,
  `header` text collate latin1_general_ci NOT NULL,
  `footer` text collate latin1_general_ci NOT NULL,
  `related` mediumint(6) NOT NULL default '0',
  `page_title` varchar(200) collate latin1_general_ci NOT NULL default '',
  `hits` int(11) NOT NULL default '0',
  `order_num` smallint(6) NOT NULL default '0',
  `basic_price` double unsigned NOT NULL default '0',
  `premium_price` double unsigned NOT NULL default '0',
  `sponsored_price` double unsigned NOT NULL default '0',
  PRIMARY KEY  (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

INSERT INTO `idx_category` VALUES (2,0,'Careers & Jobs','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(3,0,'Automotive','','folder.gif','','1',30,'','','0','0','','',0,'',2,0,0,0,0),(4,0,'Clothing','','folder.gif','','1',6,'','','0','0','','',0,'',2,10,0,0,0),(5,0,'Arts & Entertainment','','folder.gif','','1',11,'','','0','0','','',0,'',8,0,0,0,0),(8,0,'Communications','','folder.gif','','1',13,'','','0','0','','',0,'',0,0,0,0,0),(7,0,'Business','','folder.gif','','1',121,'','','0','0','','',0,'',4,0,0,0,0),(9,0,'Computer & Internet','','folder.gif','','1',17,'','','0','0','','',0,'',0,0,0,0,0),(10,0,'Construction and Contractors','','folder.gif','','1',68,'','','0','0','','',0,'',0,0,0,0,0),(11,0,'Dental Care','','folder.gif','','1',36,'','','0','0','','',0,'',0,0,0,0,0),(12,0,'Education & Research','','folder.gif','','1',24,'','','0','0','','',0,'',0,0,0,0,0),(13,0,'Employment Services','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(14,0,'Gift Baskets','','folder.gif','','1',19,'','','0','0','','',0,'',0,0,0,0,0),(15,0,'Hardware & Software Services','','folder.gif','','1',9,'','','0','0','','',0,'',0,0,0,0,0),(16,0,'Health & Medical','','folder.gif','','1',23,'','','0','0','','',0,'',1,0,0,0,0),(17,0,'Healthcare ','','folder.gif','','1',120,'','','0','0','','',0,'',0,0,0,0,0),(18,0,'Heating and Air Conditioning','','folder.gif','','1',48,'','','0','0','','',0,'',0,0,0,0,0),(19,0,'Home & Garden','','folder.gif','','1',208,'','','0','0','','',0,'',0,0,0,0,0),(20,0,'Home Improvement ','','folder.gif','','1',72,'','','0','0','','',0,'',0,0,0,0,0),(21,0,'Hotels & Motels','','folder.gif','','1',20,'','','0','0','','',0,'',0,0,0,0,0),(22,0,'Insurance','','folder.gif','','1',22,'','','0','0','','',0,'',0,0,0,0,0),(23,0,'Law & Politics','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(24,0,'Lawyers','','folder.gif','','1',141,'','','0','0','','',0,'',0,0,0,0,0),(25,0,'Lifestyle & Relationships','','folder.gif','','1',8,'','','0','0','','',0,'',0,0,0,0,0),(26,0,'Medicine','','folder.gif','','1',5,'','','0','0','','',0,'',0,0,0,0,0),(27,0,'Money & Finance','','folder.gif','','1',14,'','','0','0','','',0,'',0,0,0,0,0),(28,0,'News & Issues','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(29,0,'Plumbing','','folder.gif','','1',28,'','','0','0','','',0,'',0,0,0,0,0),(30,0,'Real Estate','','folder.gif','','1',29,'','','0','0','','',0,'',0,0,0,0,0),(31,0,'Science & Technology','','folder.gif','','1',14,'','','0','0','','',0,'',1,0,0,0,0),(32,0,'SEO & SMO','','folder.gif','','1',17,'','','0','0','','',0,'',1,0,0,0,0),(33,0,'Shopping','','folder.gif','','1',55,'','','0','0','','',0,'',1,0,0,0,0),(34,0,'Sports & Games','','folder.gif','','1',7,'','','0','0','','',0,'',0,0,0,0,0),(35,0,'Transportation and Logistics','','folder.gif','','1',31,'','','0','0','','',0,'',0,0,0,0,0),(36,0,'Travel','','folder.gif','','1',23,'','','0','0','','',0,'',3,0,0,0,0),(37,0,'Wedding','','folder.gif','','1',10,'','','0','0','','',0,'',0,0,0,0,0);

--
-- Table structure for table `idx_category_path`
--

CREATE TABLE `idx_category_path` (
  `category_id` mediumint(9) NOT NULL default '0',
  `path` text collate latin1_general_ci,
  `path_with_url` text collate latin1_general_ci,
  `parents` text collate latin1_general_ci,
  PRIMARY KEY  (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

INSERT INTO `idx_category_path` VALUES (2,'Careers & Jobs','<a href=\"http://hotlisting.co.uk/careers-jobs/\" name=\"cat_2\" style=\"\">Careers & Jobs</a>',';0;'),(3,'Automotive','<a href=\"http://hotlisting.co.uk/automotive/\" name=\"cat_3\" style=\"\">Automotive</a>',';0;'),(4,'Clothing','<a href=\"http://hotlisting.co.uk/clothing/\" name=\"cat_4\" style=\"\">Clothing</a>',';0;'),(5,'Arts & Entertainment','<a href=\"http://hotlisting.co.uk/arts-entertainment/\" name=\"cat_5\" style=\"\">Arts & Entertainment</a>',';0;'),(7,'Business','<a href=\"http://hotlisting.co.uk/business/\" name=\"cat_7\" style=\"\">Business</a>',';0;'),(8,'Communications','<a href=\"http://hotlisting.co.uk/communications/\" name=\"cat_8\" style=\"\">Communications</a>',';0;'),(9,'Computer & Internet','<a href=\"http://hotlisting.co.uk/computer-internet/\" name=\"cat_9\" style=\"\">Computer & Internet</a>',';0;'),(10,'Construction and Contractors','<a href=\"http://hotlisting.co.uk/construction-and-contractors/\" name=\"cat_10\" style=\"\">Construction and Contractors</a>',';0;'),(11,'Dental Care','<a href=\"http://hotlisting.co.uk/dental-care/\" name=\"cat_11\" style=\"\">Dental Care</a>',';0;'),(12,'Education & Research','<a href=\"http://hotlisting.co.uk/education-research/\" name=\"cat_12\" style=\"\">Education & Research</a>',';0;'),(13,'Employment Services','<a href=\"http://hotlisting.co.uk/employment-services/\" name=\"cat_13\" style=\"\">Employment Services</a>',';0;'),(14,'Gift Baskets','<a href=\"http://hotlisting.co.uk/gift-baskets/\" name=\"cat_14\" style=\"\">Gift Baskets</a>',';0;'),(15,'Hardware & Software Services','<a href=\"http://hotlisting.co.uk/hardware-software-services/\" name=\"cat_15\" style=\"\">Hardware & Software Services</a>',';0;'),(16,'Health & Medical','<a href=\"http://hotlisting.co.uk/health-medical/\" name=\"cat_16\" style=\"\">Health & Medical</a>',';0;'),(17,'Healthcare ','<a href=\"http://hotlisting.co.uk/healthcare/\" name=\"cat_17\" style=\"\">Healthcare </a>',';0;'),(18,'Heating and Air Conditioning','<a href=\"http://hotlisting.co.uk/heating-and-air-conditioning/\" name=\"cat_18\" style=\"\">Heating and Air Conditioning</a>',';0;'),(19,'Home & Garden','<a href=\"http://hotlisting.co.uk/home-garden/\" name=\"cat_19\" style=\"\">Home & Garden</a>',';0;'),(20,'Home Improvement ','<a href=\"http://hotlisting.co.uk/home-improvement/\" name=\"cat_20\" style=\"\">Home Improvement </a>',';0;'),(21,'Hotels & Motels','<a href=\"http://hotlisting.co.uk/hotels-motels/\" name=\"cat_21\" style=\"\">Hotels & Motels</a>',';0;'),(22,'Insurance','<a href=\"http://hotlisting.co.uk/insurance/\" name=\"cat_22\" style=\"\">Insurance</a>',';0;'),(23,'Law & Politics','<a href=\"http://hotlisting.co.uk/law-politics/\" name=\"cat_23\" style=\"\">Law & Politics</a>',';0;'),(24,'Lawyers','<a href=\"http://hotlisting.co.uk/lawyers/\" name=\"cat_24\" style=\"\">Lawyers</a>',';0;'),(25,'Lifestyle & Relationships','<a href=\"http://hotlisting.co.uk/lifestyle-relationships/\" name=\"cat_25\" style=\"\">Lifestyle & Relationships</a>',';0;'),(26,'Medicine','<a href=\"http://hotlisting.co.uk/medicine/\" name=\"cat_26\" style=\"\">Medicine</a>',';0;'),(27,'Money & Finance','<a href=\"http://hotlisting.co.uk/money-finance/\" name=\"cat_27\" style=\"\">Money & Finance</a>',';0;'),(28,'News & Issues','<a href=\"http://hotlisting.co.uk/news-issues/\" name=\"cat_28\" style=\"\">News & Issues</a>',';0;'),(29,'Plumbing','<a href=\"http://hotlisting.co.uk/plumbing/\" name=\"cat_29\" style=\"\">Plumbing</a>',';0;'),(30,'Real Estate','<a href=\"http://hotlisting.co.uk/real-estate/\" name=\"cat_30\" style=\"\">Real Estate</a>',';0;'),(31,'Science & Technology','<a href=\"http://hotlisting.co.uk/science-technology/\" name=\"cat_31\" style=\"\">Science & Technology</a>',';0;'),(32,'SEO & SMO','<a href=\"http://hotlisting.co.uk/seo-smo/\" name=\"cat_32\" style=\"\">SEO & SMO</a>',';0;'),(33,'Shopping','<a href=\"http://hotlisting.co.uk/shopping/\" name=\"cat_33\" style=\"\">Shopping</a>',';0;'),(34,'Sports & Games','<a href=\"http://hotlisting.co.uk/sports-games/\" name=\"cat_34\" style=\"\">Sports & Games</a>',';0;'),(35,'Transportation and Logistics','<a href=\"http://hotlisting.co.uk/transportation-and-logistics/\" name=\"cat_35\" style=\"\">Transportation and Logistics</a>',';0;'),(36,'Travel','<a href=\"http://hotlisting.co.uk/travel/\" name=\"cat_36\" style=\"\">Travel</a>',';0;'),(37,'Wedding','<a href=\"http://hotlisting.co.uk/wedding/\" name=\"cat_37\" style=\"\">Wedding</a>',';0;');

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

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

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

INSERT INTO `idx_category_suggession` VALUES (1,7,'School Uniform','Buy school uniform online at DirectSchoolwear.co.uk. Choose from a wide range of girls and boys schoolwear including shirts, trousers skirts, blazers, pants and more. Avail free delivery to any address in England, Wales and Scotland.','2012-02-02 09:51:34');

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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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



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

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

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

INSERT INTO `idx_favorites` VALUES (1,'harlanisraely28s93','2011-10-18','My Favorites',NULL),(2,'lionelwilfreu42u73','2011-10-19','My Favorites',NULL),(3,'blairjefferee84x18','2011-10-31','My Favorites',NULL);

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

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

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


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

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

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


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

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

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


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

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

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

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

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

CREATE TABLE `idx_link_temp` (
  `vid` mediumint(9) unsigned NOT NULL auto_increment,
  `spam` char(1) collate latin1_general_ci NOT NULL default '0',
  `link_id` mediumint(9) default NULL,
  `category_id` mediumint(9) unsigned NOT NULL default '0',
  `title` varchar(100) collate latin1_general_ci NOT NULL default '',
  `url` text collate latin1_general_ci NOT NULL,
  `description` text collate latin1_general_ci NOT NULL,
  `contact_name` varchar(100) collate latin1_general_ci NOT NULL default '',
  `email` varchar(100) collate latin1_general_ci 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) collate latin1_general_ci default NULL,
  `hot` char(1) collate latin1_general_ci default NULL,
  `top_rated` char(1) collate latin1_general_ci default NULL,
  `pick` char(1) collate latin1_general_ci default NULL,
  `password` varchar(20) collate latin1_general_ci default NULL,
  `updated` char(1) collate latin1_general_ci default NULL,
  `reviews` smallint(6) default NULL,
  `avg_review` float(4,2) default NULL,
  `last_updated` datetime default NULL,
  `official_review` text collate latin1_general_ci,
  `keywords` varchar(255) collate latin1_general_ci default NULL,
  `cat1` mediumint(6) NOT NULL default '0',
  `cat2` mediumint(6) NOT NULL default '0',
  `suspended` char(1) collate latin1_general_ci NOT NULL default '0',
  `reciprocal_url` varchar(255) collate latin1_general_ci default NULL,
  `address` varchar(255) collate latin1_general_ci default NULL,
  `city` varchar(255) collate latin1_general_ci default NULL,
  `state` varchar(255) collate latin1_general_ci default NULL,
  `country` varchar(255) collate latin1_general_ci default NULL,
  `zip` varchar(255) collate latin1_general_ci default NULL,
  `image` varchar(255) collate latin1_general_ci default NULL,
  `phone` varchar(255) collate latin1_general_ci default NULL,
  `fax` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- 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) collate latin1_general_ci NOT NULL default '',
  PRIMARY KEY  (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `idx_pagerank` VALUES (4992,'g',6,'2011-08-03'),(4991,'g',0,'2011-09-02'),(4994,'g',5,'2011-08-03'),(4998,'g',1,'2011-08-03'),(4999,'g',0,'2011-08-03'),(4990,'g',0,'2011-08-03'),(4993,'g',0,'2011-10-01'),(4995,'g',0,'2011-08-03'),(4996,'g',0,'2011-08-03'),(4997,'g',0,'2011-08-03'),(5073,'g',2,'2011-09-30'),(40651,'g',1,'2011-08-07'),(1293,'g',6,'2011-08-07'),(5988,'g',0,'2011-08-07'),(1231,'g',1,'2011-08-07'),(1226,'g',0,'2011-08-07'),(35,'g',3,'2011-08-07'),(970,'g',0,'2011-08-07'),(37,'g',1,'2011-08-07'),(2663,'g',2,'2011-09-30'),(5033,'g',0,'2011-08-07'),(1016,'g',4,'2011-09-30'),(4976,'g',0,'2011-08-07'),(5,'g',7,'2011-08-07'),(1330,'g',3,'2011-08-07'),(58,'g',3,'2011-09-30'),(4918,'g',2,'2011-08-07'),(38864,'g',3,'2011-09-30'),(38853,'g',3,'2011-09-30'),(4961,'g',2,'2011-08-07'),(562,'g',4,'2011-08-07'),(4916,'g',4,'2011-08-07'),(1474,'g',0,'2011-09-30'),(1240,'g',1,'2011-08-07'),(876,'g',0,'2011-08-07'),(572,'g',2,'2011-08-07'),(987,'g',3,'2011-09-30'),(1024,'g',2,'2011-09-30'),(38753,'g',0,'2011-09-06'),(86,'g',0,'2011-08-07'),(5026,'g',6,'2011-08-07'),(38758,'g',2,'2011-09-06'),(4955,'g',0,'2011-09-30'),(5034,'g',0,'2011-09-30'),(976,'g',1,'2011-08-07'),(4960,'g',1,'2011-09-30'),(867,'g',3,'2011-08-07'),(5029,'g',0,'2011-08-07'),(5031,'g',0,'2011-08-07'),(1228,'g',3,'2011-08-07'),(1217,'g',3,'2011-08-07'),(569,'g',5,'2011-08-07'),(48,'g',0,'2011-08-07'),(38823,'g',0,'2011-09-30'),(4966,'g',1,'2011-09-30'),(38845,'g',0,'2011-09-30'),(5028,'g',0,'2011-08-07'),(30,'g',0,'2011-08-07'),(238,'g',0,'2011-09-30'),(40647,'g',0,'2011-08-07'),(1005,'g',3,'2011-09-30'),(878,'g',0,'2011-08-07'),(567,'g',0,'2011-08-07'),(5966,'g',0,'2011-08-07'),(5973,'g',2,'2011-08-07'),(40650,'g',0,'2011-08-07'),(571,'g',0,'2011-08-07'),(45,'g',1,'2011-08-07'),(1329,'g',3,'2011-08-07'),(4957,'g',7,'2011-09-30'),(4973,'g',2,'2011-09-30'),(39835,'g',3,'2011-09-30'),(870,'g',0,'2011-08-07'),(5955,'g',2,'2011-08-07'),(39354,'g',0,'2011-09-30'),(5086,'g',0,'2011-09-30'),(38757,'g',4,'2011-09-06'),(57,'g',8,'2011-08-07'),(38756,'g',3,'2011-09-06'),(5678,'g',3,'2011-09-30'),(79,'g',4,'2011-08-07'),(38755,'g',0,'2011-09-06'),(3270,'g',0,'2011-09-30'),(4982,'g',2,'2011-09-30'),(5025,'g',0,'2011-08-07'),(114,'g',0,'2011-08-07'),(868,'g',4,'2011-08-07'),(40646,'g',4,'2011-08-07'),(4965,'g',4,'2011-09-30'),(112,'g',3,'2011-08-07'),(38752,'g',3,'2011-09-06'),(40113,'g',2,'2011-09-30'),(5994,'g',0,'2011-08-07'),(879,'g',3,'2011-08-07'),(4919,'g',5,'2011-08-07'),(38754,'g',0,'2011-09-06'),(869,'g',7,'2011-08-07'),(5954,'g',2,'2011-08-07'),(989,'g',7,'2011-08-07'),(5990,'g',0,'2011-08-07'),(93,'g',0,'2011-10-01'),(1216,'g',1,'2011-08-07'),(568,'g',0,'2011-08-07'),(2,'g',0,'2011-08-07'),(33,'g',3,'2011-09-30'),(1706,'g',1,'2011-09-30'),(564,'g',2,'2011-08-07'),(1229,'g',0,'2011-08-07'),(96,'g',2,'2011-09-30'),(67,'g',0,'2011-09-30'),(110,'g',3,'2011-08-07'),(566,'g',3,'2011-08-07'),(5947,'g',0,'2011-08-07'),(88,'g',0,'2011-08-07'),(111,'g',2,'2011-08-07'),(1035,'g',0,'2011-09-30'),(5027,'g',4,'2011-08-07'),(1230,'g',2,'2011-08-07'),(990,'g',3,'2011-08-07'),(40072,'g',0,'2011-09-30'),(2981,'g',4,'2011-09-30'),(5946,'g',2,'2011-08-07'),(5070,'g',0,'2011-10-01'),(53,'g',0,'2011-08-07'),(39,'g',0,'2011-08-07'),(64,'g',1,'2011-08-07'),(5032,'g',0,'2011-08-07'),(1218,'g',2,'2011-08-07'),(5845,'g',2,'2011-09-30'),(861,'g',4,'2011-08-07'),(4954,'g',0,'2011-09-30'),(985,'g',4,'2011-08-07'),(38785,'g',3,'2011-09-30'),(1019,'g',0,'2011-09-30'),(5038,'g',4,'2011-09-30'),(103,'g',0,'2011-08-07'),(992,'g',0,'2011-09-30'),(81,'g',0,'2011-08-07'),(38762,'g',0,'2011-09-06'),(40332,'g',2,'2011-09-30'),(575,'g',1,'2011-08-07'),(108,'g',3,'2011-08-07'),(4963,'g',1,'2011-09-30'),(4967,'g',5,'2011-09-30'),(4962,'g',4,'2011-09-30'),(60,'g',0,'2011-08-07'),(877,'g',0,'2011-08-07'),(84,'g',2,'2011-08-07'),(38838,'g',0,'2011-08-07'),(4892,'g',3,'2011-09-30'),(5950,'g',0,'2011-08-07'),(1232,'g',2,'2011-08-07'),(563,'g',2,'2011-08-07'),(2082,'g',2,'2011-09-30'),(4958,'g',0,'2011-08-07'),(986,'g',1,'2011-08-07'),(38760,'g',0,'2011-09-06'),(881,'g',0,'2011-08-07'),(115,'g',0,'2011-08-07'),(3563,'g',0,'2011-09-30'),(573,'g',4,'2011-08-07'),(4928,'g',1,'2011-08-07'),(874,'g',0,'2011-08-07'),(5048,'g',4,'2011-09-30'),(574,'g',0,'2011-08-07'),(20,'g',0,'2011-09-30'),(882,'g',0,'2011-08-07'),(5300,'g',2,'2011-09-30'),(5618,'g',1,'2011-09-30'),(4971,'g',0,'2011-08-07'),(38969,'g',3,'2011-09-30'),(1594,'g',0,'2011-09-30'),(1047,'g',0,'2011-09-30'),(36,'g',0,'2011-08-07'),(80,'g',1,'2011-09-30'),(29,'g',0,'2011-08-07'),(40643,'g',2,'2011-08-07'),(4922,'g',5,'2011-08-07'),(32,'g',7,'2011-08-07'),(1317,'g',0,'2011-08-07'),(38788,'g',0,'2011-09-30'),(38784,'g',0,'2011-09-30'),(5996,'g',3,'2011-08-07'),(561,'g',3,'2011-08-07'),(4980,'g',3,'2011-08-07'),(5054,'g',3,'2011-09-30'),(875,'g',0,'2011-08-07'),(3027,'g',2,'2011-09-30'),(98,'g',1,'2011-08-07'),(39085,'g',2,'2011-09-30'),(1227,'g',5,'2011-08-07'),(972,'g',2,'2011-08-07'),(570,'g',0,'2011-08-07'),(38842,'g',1,'2011-10-01'),(109,'g',3,'2011-08-07'),(38839,'g',0,'2011-08-07'),(5951,'g',0,'2011-08-07'),(50,'g',3,'2011-08-07'),(3,'g',0,'2011-08-07'),(39827,'g',0,'2011-09-30'),(91,'g',0,'2011-08-07'),(4981,'g',3,'2011-08-07'),(1313,'g',3,'2011-08-07'),(1354,'g',0,'2011-08-07'),(56,'g',2,'2011-08-07'),(99,'g',2,'2011-08-07'),(1254,'g',3,'2011-08-07'),(38837,'g',0,'2011-08-07'),(1324,'g',3,'2011-08-07'),(1,'g',3,'2011-08-07'),(38841,'g',2,'2011-08-07'),(49,'g',0,'2011-08-07'),(4975,'g',0,'2011-08-07'),(38781,'g',0,'2011-09-06'),(5008,'g',4,'2011-09-30'),(1358,'g',3,'2011-08-07'),(1280,'g',7,'2011-08-07'),(1284,'g',0,'2011-08-07'),(31,'g',4,'2011-08-07'),(40649,'g',0,'2011-08-07'),(5952,'g',1,'2011-08-07'),(991,'g',5,'2011-08-07'),(993,'g',0,'2011-08-07'),(5983,'g',1,'2011-08-07'),(974,'g',0,'2011-08-07'),(984,'g',0,'2011-09-30'),(980,'g',0,'2011-08-07'),(40652,'g',0,'2011-08-07'),(1345,'g',3,'2011-08-07'),(1285,'g',2,'2011-08-07'),(1249,'g',0,'2011-08-07'),(5030,'g',6,'2011-08-07'),(5989,'g',2,'2011-08-07'),(15,'g',0,'2011-08-07'),(979,'g',5,'2011-08-07'),(13,'g',0,'2011-08-07'),(4959,'g',2,'2011-09-30'),(4882,'g',4,'2011-08-07'),(978,'g',6,'2011-08-07'),(1233,'g',1,'2011-08-07'),(4942,'g',0,'2011-08-08'),(5920,'g',4,'2011-08-08'),(5921,'g',0,'2011-08-08'),(102,'g',3,'2011-08-08'),(1299,'g',7,'2011-08-08'),(4880,'g',4,'2011-08-08'),(1360,'g',3,'2011-08-08'),(38780,'g',3,'2011-08-08'),(55,'g',0,'2011-08-08'),(47,'g',2,'2011-08-08'),(4934,'g',3,'2011-08-08'),(5671,'g',0,'2011-09-30'),(4925,'g',3,'2011-08-08'),(5310,'g',2,'2011-09-30'),(7,'g',0,'2011-08-08'),(5050,'g',0,'2011-10-01'),(983,'g',4,'2011-08-08'),(1253,'g',2,'2011-08-08'),(101,'g',4,'2011-09-30'),(87,'g',5,'2011-08-08'),(981,'g',0,'2011-08-08'),(1323,'g',0,'2011-08-08'),(38789,'g',3,'2011-08-08'),(1351,'g',0,'2011-08-08'),(27,'g',4,'2011-08-08'),(1357,'g',0,'2011-08-08'),(4964,'g',0,'2011-09-30'),(89,'g',0,'2011-08-08'),(16,'g',2,'2011-08-08'),(1356,'g',1,'2011-08-08'),(12,'g',4,'2011-08-08'),(38886,'g',2,'2011-08-08'),(5927,'g',0,'2011-08-08'),(90,'g',0,'2011-08-08'),(1353,'g',0,'2011-08-08'),(1298,'g',2,'2011-08-08'),(100,'g',5,'2011-08-08'),(5981,'g',2,'2011-08-08'),(61,'g',2,'2011-08-08'),(40731,'g',0,'2011-08-08'),(59,'g',0,'2011-08-08'),(4884,'g',0,'2011-08-08'),(46,'g',5,'2011-08-08'),(40,'g',0,'2011-08-08'),(4881,'g',4,'2011-08-08'),(1332,'g',3,'2011-08-08'),(4930,'g',5,'2011-08-08'),(1308,'g',0,'2011-08-08'),(4935,'g',3,'2011-08-08'),(5009,'g',0,'2011-08-08'),(5949,'g',2,'2011-08-08'),(38836,'g',0,'2011-08-08'),(4885,'g',2,'2011-08-08'),(1309,'g',5,'2011-08-08'),(4915,'g',0,'2011-08-08'),(883,'g',3,'2011-08-08'),(1300,'g',4,'2011-08-08'),(38761,'g',3,'2011-08-08'),(1359,'g',2,'2011-08-08'),(11,'g',3,'2011-08-08'),(40645,'g',0,'2011-08-08'),(38759,'g',0,'2011-08-08'),(1346,'g',0,'2011-08-08'),(5980,'g',2,'2011-08-08'),(988,'g',0,'2011-08-08'),(40696,'g',5,'2011-08-08'),(38881,'g',0,'2011-08-08'),(4929,'g',5,'2011-08-08'),(42,'g',0,'2011-09-30'),(5991,'g',0,'2011-08-08'),(1328,'g',3,'2011-08-08'),(4932,'g',3,'2011-08-08'),(4956,'g',2,'2011-08-08'),(105,'g',4,'2011-08-08'),(1248,'g',2,'2011-08-08'),(4923,'g',4,'2011-08-08'),(8,'g',0,'2011-08-08'),(62,'g',4,'2011-08-08'),(85,'g',0,'2011-08-08'),(977,'g',5,'2011-08-08'),(880,'g',0,'2011-08-08'),(5984,'g',0,'2011-08-08'),(107,'g',1,'2011-08-08'),(82,'g',0,'2011-08-08'),(866,'g',5,'2011-08-08'),(26,'g',1,'2011-08-08'),(94,'g',0,'2011-08-08'),(10,'g',0,'2011-08-08'),(1214,'g',1,'2011-08-08'),(4,'g',0,'2011-08-08'),(1316,'g',0,'2011-08-08'),(9,'g',0,'2011-08-08'),(38782,'g',4,'2011-08-08'),(38779,'g',2,'2011-08-08'),(4972,'g',0,'2011-08-08'),(113,'g',0,'2011-08-08'),(5953,'g',4,'2011-08-08'),(38764,'g',3,'2011-08-08'),(4974,'g',0,'2011-09-30'),(1315,'g',2,'2011-08-08'),(38844,'g',0,'2011-08-08'),(1851,'g',4,'2011-08-08'),(4883,'g',0,'2011-08-08'),(4938,'g',0,'2011-08-08'),(1252,'g',0,'2011-08-08'),(38786,'g',0,'2011-08-08'),(994,'g',0,'2011-08-08'),(1318,'g',0,'2011-08-08'),(1355,'g',0,'2011-08-08'),(1333,'g',0,'2011-08-08'),(38882,'g',0,'2011-08-08'),(1352,'g',0,'2011-08-08'),(1334,'g',2,'2011-08-08'),(815,'g',2,'2011-09-30'),(38835,'g',5,'2011-08-08'),(41,'g',5,'2011-08-08'),(1250,'g',7,'2011-08-08'),(1850,'g',4,'2011-08-08'),(14,'g',5,'2011-08-08'),(982,'g',5,'2011-08-08'),(1283,'g',4,'2011-08-08'),(4978,'g',2,'2011-08-08'),(38883,'g',5,'2011-08-08'),(1325,'g',3,'2011-08-08'),(1251,'g',7,'2011-08-08'),(38885,'g',0,'2011-08-08'),(4941,'g',3,'2011-08-08'),(1255,'g',0,'2011-08-08'),(38843,'g',5,'2011-08-08'),(1239,'g',0,'2011-08-08'),(38884,'g',1,'2011-08-08'),(40648,'g',0,'2011-08-08'),(54,'g',2,'2011-09-30'),(1344,'g',4,'2011-08-08'),(1347,'g',5,'2011-08-08'),(38783,'g',1,'2011-08-08'),(4977,'g',0,'2011-08-08'),(38840,'g',1,'2011-08-08'),(5982,'g',2,'2011-08-08'),(863,'g',0,'2011-08-08'),(38766,'g',3,'2011-09-30'),(5995,'g',0,'2011-08-08'),(5993,'g',0,'2011-08-08'),(472,'g',0,'2011-10-01'),(1030,'g',7,'2011-09-30'),(1314,'g',2,'2011-08-08'),(52,'g',0,'2011-08-08'),(38811,'g',6,'2011-10-01'),(106,'g',0,'2011-08-08'),(975,'g',5,'2011-08-08'),(40644,'g',3,'2011-08-08'),(4979,'g',1,'2011-08-08'),(95,'g',0,'2011-08-08'),(4917,'g',2,'2011-08-08'),(6,'g',0,'2011-08-08'),(5066,'g',0,'2011-09-30'),(40304,'g',0,'2011-09-30'),(5948,'g',0,'2011-08-08'),(5992,'g',0,'2011-08-08'),(5279,'g',0,'2011-09-30'),(5072,'g',0,'2011-09-30'),(4920,'g',0,'2011-08-08'),(757,'g',5,'2011-09-01'),(862,'g',0,'2011-09-01'),(676,'g',0,'2011-10-14'),(710,'g',3,'2011-09-01'),(276,'g',0,'2011-10-14'),(379,'g',0,'2011-10-14'),(367,'g',5,'2011-09-01'),(4983,'g',0,'2011-10-14'),(4985,'g',3,'2011-09-01'),(4970,'g',0,'2011-09-01'),(38763,'g',0,'2011-09-05'),(39855,'g',1,'2011-09-05'),(39808,'g',1,'2011-09-05'),(40207,'g',1,'2011-09-05'),(39356,'g',3,'2011-09-05'),(40466,'g',2,'2011-09-05'),(38902,'g',0,'2011-09-05'),(40296,'g',4,'2011-09-05'),(39770,'g',1,'2011-09-05'),(40448,'g',3,'2011-09-05'),(38869,'g',3,'2011-09-05'),(40720,'g',5,'2011-09-05'),(38896,'g',0,'2011-09-05'),(38991,'g',0,'2011-09-05'),(39276,'g',0,'2011-09-05'),(39008,'g',0,'2011-09-05'),(39640,'g',4,'2011-09-05'),(39817,'g',0,'2011-09-05'),(39991,'g',2,'2011-09-05'),(40600,'g',3,'2011-09-05'),(40592,'g',2,'2011-09-05'),(40176,'g',0,'2011-09-05'),(39563,'g',3,'2011-09-05'),(38802,'g',0,'2011-09-05'),(40014,'g',0,'2011-09-05'),(39171,'g',0,'2011-09-05'),(40543,'g',0,'2011-09-05'),(39536,'g',0,'2011-09-05'),(39023,'g',5,'2011-09-05'),(39496,'g',0,'2011-09-05'),(40183,'g',0,'2011-09-05'),(40500,'g',2,'2011-09-05'),(40137,'g',1,'2011-09-05'),(39167,'g',0,'2011-09-05'),(38939,'g',1,'2011-09-05'),(39875,'g',2,'2011-09-05'),(39214,'g',0,'2011-09-05'),(39173,'g',1,'2011-09-05'),(40000,'g',2,'2011-09-05'),(39011,'g',1,'2011-09-05'),(39039,'g',0,'2011-09-05'),(39550,'g',0,'2011-09-05'),(39997,'g',2,'2011-09-05'),(40563,'g',0,'2011-09-05'),(39031,'g',0,'2011-09-05'),(39015,'g',5,'2011-09-05'),(39079,'g',2,'2011-09-05'),(39870,'g',4,'2011-09-05'),(40179,'g',0,'2011-09-05'),(39571,'g',0,'2011-09-05'),(39451,'g',0,'2011-09-05'),(38765,'g',1,'2011-09-05'),(40290,'g',0,'2011-09-05'),(40013,'g',0,'2011-09-05'),(38967,'g',0,'2011-09-05'),(39604,'g',1,'2011-09-05'),(38854,'g',0,'2011-09-05'),(40604,'g',0,'2011-09-05'),(39330,'g',0,'2011-09-05'),(38831,'g',0,'2011-09-05'),(38936,'g',4,'2011-09-05'),(40054,'g',0,'2011-09-05'),(39773,'g',0,'2011-09-05'),(38798,'g',3,'2011-09-05'),(39059,'g',0,'2011-09-05'),(39323,'g',2,'2011-09-05'),(40284,'g',3,'2011-09-05'),(38935,'g',4,'2011-09-05'),(39904,'g',3,'2011-09-05'),(39520,'g',0,'2011-09-05'),(39682,'g',1,'2011-09-05'),(39871,'g',3,'2011-09-05'),(40341,'g',3,'2011-09-05'),(38768,'g',3,'2011-09-05'),(39381,'g',3,'2011-09-05'),(39241,'g',0,'2011-09-05'),(39319,'g',4,'2011-09-05'),(39561,'g',0,'2011-09-05'),(38968,'g',2,'2011-09-06'),(38775,'g',5,'2011-09-06'),(38771,'g',3,'2011-09-06'),(38773,'g',0,'2011-09-06'),(38774,'g',0,'2011-09-06'),(38776,'g',3,'2011-09-06'),(38772,'g',1,'2011-09-06'),(38767,'g',0,'2011-09-06'),(38769,'g',0,'2011-09-06'),(38778,'g',0,'2011-09-06'),(38795,'g',2,'2011-09-06'),(38787,'g',6,'2011-09-06'),(38770,'g',2,'2011-09-06'),(38790,'g',3,'2011-09-06'),(38793,'g',2,'2011-09-06'),(38792,'g',3,'2011-09-06'),(38808,'g',0,'2011-09-06'),(38791,'g',0,'2011-09-06'),(40340,'g',0,'2011-09-06'),(38850,'g',0,'2011-09-06'),(39925,'g',4,'2011-09-06'),(39329,'g',0,'2011-09-06'),(39151,'g',2,'2011-09-06'),(39193,'g',0,'2011-09-06'),(39148,'g',0,'2011-09-06'),(40702,'g',0,'2011-09-06'),(40278,'g',2,'2011-09-06'),(39738,'g',0,'2011-09-06'),(39300,'g',3,'2011-09-06'),(40489,'g',0,'2011-09-06'),(39505,'g',0,'2011-09-06'),(38911,'g',1,'2011-09-06'),(40683,'g',2,'2011-09-06'),(40492,'g',2,'2011-09-06'),(40071,'g',3,'2011-09-06'),(38927,'g',0,'2011-09-06'),(38921,'g',3,'2011-09-06'),(40672,'g',0,'2011-09-06'),(39661,'g',4,'2011-09-06'),(39977,'g',2,'2011-09-06'),(40325,'g',0,'2011-09-06'),(40177,'g',0,'2011-09-06'),(39840,'g',0,'2011-09-06'),(39725,'g',2,'2011-09-06'),(39577,'g',2,'2011-09-06'),(40568,'g',0,'2011-09-06'),(39614,'g',0,'2011-09-06'),(38983,'g',3,'2011-09-06'),(39622,'g',0,'2011-09-06'),(39063,'g',4,'2011-09-06'),(39621,'g',0,'2011-09-06'),(40243,'g',0,'2011-09-06'),(39057,'g',1,'2011-09-06'),(40307,'g',0,'2011-09-06'),(40518,'g',2,'2011-09-06'),(39896,'g',2,'2011-09-06'),(39960,'g',0,'2011-09-06'),(39070,'g',2,'2011-09-06'),(38800,'g',0,'2011-09-06'),(38941,'g',0,'2011-09-06'),(39941,'g',2,'2011-09-06'),(40618,'g',0,'2011-09-06'),(40214,'g',0,'2011-09-06'),(40583,'g',0,'2011-09-06'),(40727,'g',2,'2011-09-06'),(39893,'g',0,'2011-09-07'),(40462,'g',5,'2011-09-07'),(40211,'g',0,'2011-09-07'),(39771,'g',0,'2011-09-07'),(40567,'g',4,'2011-09-07'),(38819,'g',4,'2011-09-07'),(38966,'g',5,'2011-09-07'),(39169,'g',0,'2011-09-07'),(39427,'g',1,'2011-09-07'),(40216,'g',0,'2011-09-07'),(40429,'g',3,'2011-09-08'),(39480,'g',1,'2011-09-08'),(39933,'g',3,'2011-09-08'),(39060,'g',0,'2011-09-08'),(39249,'g',2,'2011-09-08'),(38946,'g',0,'2011-09-08'),(39376,'g',0,'2011-09-08'),(40128,'g',2,'2011-09-08'),(40201,'g',0,'2011-09-08'),(40692,'g',4,'2011-09-08'),(39572,'g',0,'2011-09-08'),(39750,'g',2,'2011-09-08'),(39453,'g',2,'2011-09-08'),(39129,'g',0,'2011-09-08'),(39212,'g',0,'2011-09-08'),(39457,'g',3,'2011-09-08'),(39189,'g',4,'2011-09-08'),(40613,'g',0,'2011-09-08'),(39083,'g',3,'2011-09-08'),(40619,'g',0,'2011-09-08'),(39042,'g',0,'2011-09-08'),(39477,'g',1,'2011-09-08'),(39162,'g',0,'2011-09-08'),(40367,'g',0,'2011-09-08'),(40330,'g',1,'2011-09-08'),(39676,'g',0,'2011-09-08'),(39552,'g',0,'2011-09-08'),(40047,'g',0,'2011-09-08'),(39113,'g',2,'2011-09-08'),(40248,'g',4,'2011-09-08'),(38846,'g',0,'2011-09-08'),(39353,'g',8,'2011-09-08'),(39880,'g',1,'2011-09-08'),(39199,'g',0,'2011-09-08'),(40662,'g',4,'2011-09-08'),(39905,'g',0,'2011-09-08'),(38970,'g',3,'2011-09-08'),(39019,'g',0,'2011-09-08'),(39754,'g',2,'2011-09-08'),(39017,'g',6,'2011-09-08'),(39677,'g',0,'2011-09-08'),(40490,'g',4,'2011-09-08'),(39759,'g',0,'2011-09-09'),(40134,'g',2,'2011-09-09'),(39761,'g',1,'2011-09-09'),(38899,'g',0,'2011-09-09'),(39274,'g',0,'2011-09-09'),(39110,'g',1,'2011-09-09'),(39788,'g',3,'2011-09-09'),(39936,'g',0,'2011-09-09'),(39028,'g',0,'2011-09-09'),(39512,'g',4,'2011-09-09'),(39524,'g',1,'2011-09-09'),(39403,'g',0,'2011-09-09'),(40549,'g',0,'2011-09-10'),(39471,'g',1,'2011-09-10'),(40041,'g',3,'2011-09-10'),(40120,'g',3,'2011-09-10'),(39261,'g',0,'2011-09-10'),(38834,'g',2,'2011-09-10'),(39816,'g',0,'2011-09-10'),(39984,'g',0,'2011-09-10'),(38805,'g',0,'2011-09-10'),(39685,'g',1,'2011-09-10'),(40356,'g',3,'2011-09-16'),(40572,'g',1,'2011-09-16'),(40147,'g',2,'2011-09-16'),(39160,'g',3,'2011-09-16'),(39497,'g',0,'2011-09-16'),(39980,'g',0,'2011-09-16'),(40673,'g',2,'2011-09-16'),(39786,'g',0,'2011-09-16'),(39154,'g',2,'2011-09-16'),(39267,'g',0,'2011-09-16'),(40035,'g',1,'2011-09-16'),(39360,'g',1,'2011-09-16'),(39232,'g',2,'2011-09-16'),(38985,'g',0,'2011-09-16'),(39265,'g',0,'2011-09-16'),(40235,'g',0,'2011-09-16'),(40090,'g',0,'2011-09-16'),(40011,'g',3,'2011-09-16'),(39322,'g',2,'2011-09-16'),(39352,'g',3,'2011-09-16'),(39284,'g',1,'2011-09-16'),(39068,'g',0,'2011-09-16'),(40141,'g',5,'2011-09-16'),(39638,'g',4,'2011-09-16'),(40593,'g',2,'2011-09-16'),(39053,'g',4,'2011-09-16'),(39363,'g',3,'2011-09-16'),(39396,'g',1,'2011-09-16'),(39758,'g',1,'2011-09-16'),(40166,'g',3,'2011-09-16'),(39932,'g',5,'2011-09-16'),(39032,'g',0,'2011-09-16'),(39235,'g',1,'2011-09-16'),(39474,'g',0,'2011-09-16'),(40053,'g',3,'2011-09-16'),(38963,'g',1,'2011-09-16'),(39459,'g',4,'2011-09-16'),(39784,'g',0,'2011-09-16'),(40080,'g',0,'2011-09-16'),(38818,'g',1,'2011-09-16'),(39891,'g',2,'2011-09-16'),(39051,'g',1,'2011-09-16'),(39136,'g',0,'2011-09-16'),(39625,'g',1,'2011-09-16'),(40581,'g',0,'2011-09-16'),(39105,'g',0,'2011-09-16'),(40226,'g',3,'2011-09-16'),(40349,'g',0,'2011-09-16'),(40682,'g',2,'2011-09-16'),(39554,'g',1,'2011-09-17'),(40449,'g',0,'2011-09-17'),(39206,'g',0,'2011-09-17'),(39627,'g',0,'2011-09-17'),(39900,'g',0,'2011-09-17'),(38954,'g',4,'2011-09-17'),(39558,'g',0,'2011-09-17'),(39745,'g',0,'2011-09-17'),(40203,'g',0,'2011-09-17'),(39522,'g',1,'2011-09-17'),(40274,'g',0,'2011-09-17'),(39794,'g',0,'2011-09-17'),(38950,'g',4,'2011-09-17'),(40124,'g',4,'2011-09-17'),(39411,'g',0,'2011-09-17'),(40043,'g',2,'2011-09-17'),(39423,'g',0,'2011-09-17'),(39317,'g',0,'2011-09-17'),(40608,'g',0,'2011-09-17'),(38998,'g',0,'2011-09-17'),(38926,'g',0,'2011-09-17'),(39201,'g',2,'2011-09-17'),(39454,'g',0,'2011-09-17'),(40522,'g',0,'2011-09-17'),(39860,'g',0,'2011-09-17'),(40256,'g',0,'2011-09-17'),(40503,'g',0,'2011-09-17'),(40109,'g',4,'2011-09-17'),(39765,'g',0,'2011-09-17'),(40725,'g',1,'2011-09-17'),(40379,'g',1,'2011-09-17'),(39289,'g',4,'2011-09-17'),(40263,'g',0,'2011-09-17'),(39814,'g',1,'2011-09-17'),(39370,'g',3,'2011-09-17'),(40590,'g',1,'2011-09-17'),(39859,'g',3,'2011-09-17'),(40380,'g',1,'2011-09-17'),(39539,'g',2,'2011-09-17'),(39130,'g',0,'2011-09-17'),(39553,'g',1,'2011-09-17'),(38821,'g',0,'2011-09-17'),(40532,'g',0,'2011-09-17'),(39301,'g',0,'2011-09-17'),(38955,'g',0,'2011-09-17'),(39422,'g',0,'2011-09-17'),(38906,'g',3,'2011-09-17'),(39709,'g',0,'2011-09-17'),(39203,'g',6,'2011-09-17'),(39502,'g',0,'2011-09-17'),(39118,'g',0,'2011-09-18'),(39869,'g',1,'2011-09-18'),(40196,'g',4,'2011-09-18'),(39659,'g',1,'2011-09-18'),(38952,'g',0,'2011-09-18'),(40127,'g',0,'2011-09-18'),(40277,'g',0,'2011-09-18'),(39689,'g',0,'2011-09-18'),(40612,'g',0,'2011-09-18'),(38957,'g',4,'2011-09-18'),(38933,'g',0,'2011-09-18'),(39812,'g',2,'2011-09-18'),(38984,'g',0,'2011-09-18'),(39412,'g',0,'2011-09-18'),(40455,'g',0,'2011-09-18'),(38813,'g',0,'2011-09-18'),(39331,'g',0,'2011-09-18'),(40345,'g',2,'2011-09-18'),(40195,'g',0,'2011-09-18'),(39372,'g',0,'2011-09-18'),(39849,'g',2,'2011-09-18'),(39598,'g',1,'2011-09-18'),(39603,'g',2,'2011-09-18'),(40425,'g',2,'2011-09-18'),(40245,'g',3,'2011-09-18'),(40716,'g',0,'2011-09-18'),(40542,'g',3,'2011-09-18'),(39697,'g',0,'2011-09-18'),(39143,'g',1,'2011-09-18'),(39147,'g',0,'2011-09-18'),(39469,'g',0,'2011-09-18'),(39336,'g',0,'2011-09-18'),(39628,'g',0,'2011-09-18'),(40319,'g',2,'2011-09-18'),(38809,'g',2,'2011-09-18'),(38951,'g',2,'2011-09-18'),(40337,'g',0,'2011-09-18'),(39712,'g',0,'2011-09-19'),(39724,'g',0,'2011-09-22'),(40185,'g',4,'2011-09-22'),(39328,'g',0,'2011-09-22'),(38898,'g',0,'2011-09-22'),(40446,'g',0,'2011-09-22'),(40324,'g',2,'2011-09-22'),(39705,'g',0,'2011-09-22'),(39072,'g',0,'2011-09-22'),(39222,'g',0,'2011-09-22'),(39468,'g',1,'2011-09-22'),(40536,'g',0,'2011-09-22'),(39850,'g',1,'2011-09-22'),(40598,'g',0,'2011-09-22'),(40155,'g',0,'2011-09-22'),(39674,'g',0,'2011-09-22'),(40621,'g',0,'2011-09-22'),(40616,'g',0,'2011-09-22'),(39158,'g',0,'2011-09-22'),(39318,'g',3,'2011-09-22'),(39666,'g',5,'2011-09-22'),(39038,'g',0,'2011-09-22'),(39914,'g',0,'2011-09-23'),(40100,'g',0,'2011-09-23'),(39164,'g',0,'2011-09-23'),(39045,'g',2,'2011-09-23'),(39315,'g',0,'2011-09-23'),(39605,'g',4,'2011-09-23'),(39990,'g',5,'2011-09-23'),(40668,'g',1,'2011-09-23'),(40083,'g',1,'2011-09-23'),(40346,'g',1,'2011-09-23'),(39024,'g',1,'2011-09-23'),(39972,'g',3,'2011-09-23'),(39888,'g',3,'2011-09-23'),(39071,'g',1,'2011-09-23'),(39993,'g',2,'2011-09-23'),(39513,'g',2,'2011-09-23'),(40587,'g',0,'2011-09-23'),(40420,'g',3,'2011-09-23'),(40114,'g',0,'2011-09-23'),(40521,'g',0,'2011-09-23'),(39799,'g',3,'2011-09-23'),(38978,'g',3,'2011-09-23'),(39380,'g',0,'2011-09-23'),(39121,'g',0,'2011-09-23'),(39416,'g',5,'2011-09-23'),(39876,'g',2,'2011-09-23'),(40385,'g',1,'2011-09-23'),(40227,'g',3,'2011-09-23'),(39921,'g',0,'2011-09-23'),(39176,'g',0,'2011-09-23'),(39444,'g',0,'2011-09-23'),(39678,'g',2,'2011-09-23'),(40339,'g',0,'2011-09-23'),(39285,'g',0,'2011-09-23'),(40477,'g',2,'2011-09-23'),(39542,'g',0,'2011-09-23'),(40055,'g',5,'2011-09-23'),(39335,'g',0,'2011-09-23'),(39348,'g',4,'2011-09-23'),(38938,'g',1,'2011-09-23'),(39041,'g',5,'2011-09-23'),(39365,'g',4,'2011-09-23'),(39109,'g',4,'2011-09-23'),(40408,'g',0,'2011-09-23'),(40573,'g',0,'2011-09-23'),(40361,'g',0,'2011-09-23'),(39518,'g',2,'2011-09-23'),(40301,'g',2,'2011-09-23'),(39760,'g',0,'2011-09-23'),(38875,'g',0,'2011-09-24'),(40709,'g',3,'2011-09-24'),(40252,'g',0,'2011-09-24'),(40386,'g',1,'2011-09-24'),(40297,'g',1,'2011-09-24'),(39140,'g',2,'2011-09-24'),(39961,'g',2,'2011-09-24'),(40605,'g',3,'2011-09-24'),(39127,'g',3,'2011-09-24'),(40387,'g',2,'2011-09-24'),(40249,'g',0,'2011-09-24'),(39016,'g',0,'2011-09-24'),(40162,'g',3,'2011-09-24'),(39359,'g',0,'2011-09-24'),(40079,'g',4,'2011-09-24'),(39175,'g',0,'2011-09-24'),(40565,'g',3,'2011-09-24'),(40659,'g',1,'2011-09-24'),(40531,'g',6,'2011-09-24'),(40558,'g',5,'2011-09-24'),(39606,'g',3,'2011-09-24'),(39195,'g',0,'2011-09-24'),(40464,'g',0,'2011-09-24'),(39341,'g',2,'2011-09-24'),(40437,'g',1,'2011-09-24'),(39489,'g',2,'2011-09-24'),(39184,'g',2,'2011-09-24'),(39112,'g',4,'2011-09-25'),(40528,'g',0,'2011-09-25'),(39623,'g',0,'2011-09-25'),(39022,'g',0,'2011-09-25'),(39527,'g',0,'2011-09-25'),(39382,'g',0,'2011-09-25'),(40445,'g',0,'2011-09-25'),(39046,'g',0,'2011-09-25'),(39747,'g',0,'2011-09-25'),(39729,'g',1,'2011-09-25'),(39243,'g',0,'2011-09-25'),(40005,'g',0,'2011-09-25'),(38870,'g',3,'2011-09-25'),(39076,'g',0,'2011-09-25'),(39717,'g',0,'2011-09-25'),(40091,'g',0,'2011-09-25'),(40551,'g',1,'2011-09-25'),(39544,'g',0,'2011-09-25'),(39506,'g',3,'2011-09-25'),(39924,'g',2,'2011-09-25'),(40102,'g',0,'2011-09-25'),(40363,'g',2,'2011-09-25'),(40126,'g',0,'2011-09-25'),(39588,'g',2,'2011-09-25'),(40637,'g',2,'2011-09-25'),(39996,'g',4,'2011-09-25'),(39209,'g',1,'2011-09-25'),(40191,'g',0,'2011-09-25'),(40151,'g',2,'2011-09-25'),(39851,'g',2,'2011-09-25'),(39204,'g',4,'2011-09-25'),(40475,'g',0,'2011-09-25'),(39401,'g',0,'2011-09-25'),(39075,'g',0,'2011-09-25'),(40033,'g',3,'2011-09-25'),(40594,'g',1,'2011-09-25'),(40269,'g',2,'2011-09-25'),(40051,'g',1,'2011-09-25'),(39648,'g',0,'2011-09-25'),(40697,'g',4,'2011-09-25'),(39548,'g',3,'2011-09-25'),(40042,'g',3,'2011-09-25'),(39309,'g',3,'2011-09-25'),(40299,'g',0,'2011-09-25'),(39988,'g',0,'2011-09-25'),(40556,'g',3,'2011-09-25'),(40417,'g',0,'2011-09-25'),(40562,'g',4,'2011-09-25'),(40146,'g',0,'2011-09-25'),(39743,'g',1,'2011-09-25'),(39964,'g',0,'2011-09-26'),(39509,'g',1,'2011-09-26'),(40266,'g',0,'2011-09-26'),(39643,'g',0,'2011-09-26'),(39587,'g',0,'2011-09-26'),(40670,'g',2,'2011-09-26'),(38981,'g',0,'2011-09-26'),(39653,'g',3,'2011-09-26'),(40459,'g',0,'2011-09-26'),(39295,'g',0,'2011-09-26'),(39823,'g',1,'2011-09-26'),(39448,'g',0,'2011-09-26'),(40547,'g',4,'2011-09-26'),(39000,'g',3,'2011-09-26'),(39719,'g',0,'2011-09-26'),(40527,'g',3,'2011-09-26'),(39168,'g',2,'2011-09-26'),(39047,'g',0,'2011-09-26'),(39054,'g',2,'2011-09-26'),(39467,'g',0,'2011-09-26'),(39355,'g',3,'2011-09-26'),(38858,'g',1,'2011-09-26'),(39935,'g',4,'2011-09-26'),(39707,'g',0,'2011-09-26'),(39142,'g',3,'2011-09-26'),(40294,'g',2,'2011-09-26'),(39692,'g',3,'2011-09-26'),(40068,'g',4,'2011-09-26'),(40219,'g',0,'2011-09-26'),(39290,'g',4,'2011-09-26'),(38848,'g',4,'2011-09-26'),(40244,'g',0,'2011-09-26'),(38903,'g',0,'2011-09-26'),(39100,'g',1,'2011-09-26'),(39080,'g',0,'2011-09-26'),(40285,'g',0,'2011-09-26'),(39757,'g',0,'2011-09-26'),(38833,'g',0,'2011-09-26'),(40338,'g',3,'2011-09-26'),(39844,'g',1,'2011-09-26'),(40440,'g',0,'2011-09-26'),(40411,'g',0,'2011-09-26'),(40433,'g',0,'2011-09-26'),(38804,'g',3,'2011-09-26'),(40724,'g',0,'2011-09-26'),(40388,'g',1,'2011-09-26'),(40677,'g',2,'2011-09-26'),(39426,'g',4,'2011-09-26'),(39132,'g',0,'2011-09-26'),(38919,'g',0,'2011-09-27'),(39456,'g',2,'2011-09-27'),(39636,'g',0,'2011-09-27'),(39843,'g',3,'2011-09-27'),(40726,'g',0,'2011-09-27'),(39293,'g',2,'2011-09-27'),(40655,'g',0,'2011-09-27'),(40209,'g',4,'2011-09-27'),(39908,'g',3,'2011-09-27'),(39283,'g',1,'2011-09-27'),(40218,'g',0,'2011-09-27'),(39373,'g',0,'2011-09-27'),(40303,'g',0,'2011-09-27'),(40142,'g',0,'2011-09-27'),(39889,'g',2,'2011-09-27'),(39656,'g',2,'2011-09-27'),(40640,'g',0,'2011-09-27'),(40479,'g',3,'2011-09-27'),(39321,'g',2,'2011-09-27'),(39062,'g',3,'2011-09-27'),(40524,'g',0,'2011-09-27'),(39463,'g',0,'2011-09-27'),(39969,'g',0,'2011-09-27'),(39944,'g',0,'2011-09-27'),(39084,'g',0,'2011-09-27'),(40553,'g',1,'2011-09-27'),(39407,'g',0,'2011-09-27'),(39099,'g',0,'2011-09-27'),(40473,'g',0,'2011-09-27'),(38887,'g',0,'2011-09-27'),(39251,'g',0,'2011-09-27'),(38880,'g',0,'2011-09-27'),(39126,'g',0,'2011-09-27'),(40351,'g',0,'2011-09-27'),(40370,'g',0,'2011-09-27'),(40705,'g',0,'2011-09-27'),(39557,'g',4,'2011-09-27'),(39751,'g',3,'2011-09-27'),(40471,'g',3,'2011-09-27'),(40458,'g',2,'2011-09-27'),(40352,'g',0,'2011-09-27'),(39564,'g',0,'2011-09-27'),(38826,'g',0,'2011-09-27'),(40267,'g',1,'2011-09-27'),(40555,'g',3,'2011-09-27'),(38976,'g',0,'2011-09-27'),(40099,'g',0,'2011-09-27'),(40393,'g',2,'2011-09-27'),(39828,'g',4,'2011-09-27'),(39546,'g',4,'2011-09-27'),(40399,'g',4,'2011-09-27'),(38905,'g',0,'2011-09-27'),(40539,'g',0,'2011-09-27'),(39998,'g',4,'2011-09-27'),(40714,'g',1,'2011-09-27'),(39357,'g',0,'2011-09-28'),(40224,'g',0,'2011-09-28'),(40020,'g',7,'2011-09-28'),(39190,'g',3,'2011-09-28'),(39832,'g',2,'2011-09-28'),(40695,'g',0,'2011-09-28'),(39618,'g',4,'2011-09-28'),(39699,'g',0,'2011-09-28'),(39297,'g',0,'2011-09-28'),(39018,'g',2,'2011-09-28'),(40577,'g',1,'2011-09-28'),(39485,'g',0,'2011-09-28'),(39779,'g',0,'2011-09-28'),(38878,'g',0,'2011-09-28'),(38980,'g',4,'2011-09-28'),(40348,'g',2,'2011-09-28'),(39732,'g',1,'2011-09-28'),(39927,'g',0,'2011-09-28'),(40660,'g',2,'2011-09-28'),(39755,'g',0,'2011-09-28'),(39013,'g',0,'2011-09-28'),(40119,'g',0,'2011-09-28'),(39029,'g',4,'2011-09-28'),(39951,'g',0,'2011-09-28'),(39186,'g',0,'2011-09-28'),(39696,'g',0,'2011-09-28'),(40376,'g',1,'2011-09-28'),(40546,'g',2,'2011-09-28'),(38994,'g',2,'2011-09-28'),(39583,'g',0,'2011-09-28'),(39408,'g',0,'2011-09-28'),(40208,'g',0,'2011-09-28'),(40642,'g',1,'2011-09-28'),(40064,'g',4,'2011-09-28'),(39273,'g',0,'2011-09-28'),(40578,'g',3,'2011-09-28'),(39498,'g',0,'2011-09-28'),(39965,'g',0,'2011-09-28'),(38820,'g',0,'2011-09-28'),(40372,'g',0,'2011-09-28'),(39983,'g',0,'2011-09-28'),(39654,'g',2,'2011-09-28'),(39087,'g',1,'2011-09-28'),(39181,'g',2,'2011-09-28'),(39447,'g',5,'2011-09-28'),(38929,'g',4,'2011-09-28'),(40403,'g',4,'2011-09-28'),(40322,'g',1,'2011-09-28'),(39667,'g',0,'2011-09-28'),(40472,'g',3,'2011-09-28'),(40431,'g',1,'2011-09-28'),(39630,'g',0,'2011-09-28'),(39202,'g',0,'2011-09-29'),(39165,'g',0,'2011-09-29'),(39565,'g',0,'2011-09-29'),(39207,'g',3,'2011-09-29'),(39378,'g',1,'2011-09-29'),(39882,'g',0,'2011-09-29'),(40465,'g',1,'2011-09-29'),(39611,'g',0,'2011-09-29'),(39404,'g',0,'2011-09-29'),(40571,'g',4,'2011-09-29'),(39078,'g',0,'2011-09-29'),(39392,'g',4,'2011-09-29'),(39929,'g',0,'2011-09-29'),(39680,'g',2,'2011-09-29'),(40516,'g',0,'2011-09-29'),(40483,'g',0,'2011-09-29'),(38863,'g',2,'2011-09-29'),(39090,'g',0,'2011-09-29'),(39437,'g',3,'2011-09-29'),(40519,'g',3,'2011-09-29'),(40291,'g',0,'2011-09-29'),(39525,'g',2,'2011-09-29'),(39785,'g',0,'2011-09-29'),(40422,'g',4,'2011-09-29'),(40032,'g',0,'2011-09-29'),(39120,'g',6,'2011-09-29'),(39769,'g',0,'2011-09-29'),(40316,'g',0,'2011-09-29'),(39052,'g',3,'2011-09-29'),(40139,'g',0,'2011-09-29'),(40343,'g',3,'2011-09-29'),(40529,'g',0,'2011-09-29'),(39367,'g',5,'2011-09-29'),(40231,'g',0,'2011-09-29'),(40560,'g',1,'2011-09-29'),(38959,'g',0,'2011-09-29'),(40488,'g',2,'2011-09-29'),(39141,'g',3,'2011-09-29'),(39499,'g',2,'2011-09-29'),(39526,'g',0,'2011-09-29'),(39533,'g',1,'2011-09-29'),(40404,'g',3,'2011-09-29'),(39726,'g',3,'2011-09-29'),(39706,'g',0,'2011-09-29'),(39490,'g',0,'2011-09-29'),(39254,'g',0,'2011-09-29'),(39752,'g',0,'2011-09-29'),(39556,'g',3,'2011-09-29'),(39842,'g',0,'2011-09-29'),(40576,'g',1,'2011-09-29'),(39807,'g',3,'2011-09-29'),(40467,'g',3,'2011-09-29'),(39282,'g',2,'2011-09-29'),(40300,'g',1,'2011-09-29'),(39326,'g',1,'2011-09-29'),(39225,'g',3,'2011-09-29'),(38900,'g',0,'2011-09-29'),(39124,'g',1,'2011-09-29'),(40049,'g',0,'2011-09-29'),(40001,'g',4,'2011-09-29'),(40718,'g',2,'2011-09-29'),(39139,'g',0,'2011-09-30'),(39879,'g',0,'2011-09-30'),(38989,'g',0,'2011-09-30'),(39710,'g',0,'2011-09-30'),(39388,'g',3,'2011-09-30'),(40533,'g',2,'2011-09-30'),(38910,'g',0,'2011-09-30'),(38943,'g',0,'2011-09-30'),(40198,'g',0,'2011-09-30'),(39892,'g',0,'2011-09-30'),(40161,'g',0,'2011-09-30'),(40389,'g',0,'2011-09-30'),(40073,'g',0,'2011-09-30'),(39358,'g',0,'2011-09-30'),(40255,'g',0,'2011-09-30'),(40657,'g',0,'2011-09-30'),(40250,'g',3,'2011-09-30'),(40441,'g',0,'2011-09-30'),(39890,'g',1,'2011-09-30'),(39547,'g',0,'2011-09-30'),(40537,'g',3,'2011-09-30'),(39591,'g',1,'2011-09-30'),(39551,'g',0,'2011-09-30'),(40246,'g',0,'2011-09-30'),(38928,'g',1,'2011-09-30'),(40629,'g',0,'2011-09-30'),(39658,'g',3,'2011-09-30'),(40435,'g',0,'2011-09-30'),(40451,'g',0,'2011-09-30'),(40523,'g',0,'2011-09-30'),(40690,'g',0,'2011-09-30'),(39369,'g',3,'2011-09-30'),(39584,'g',0,'2011-09-30'),(39549,'g',2,'2011-09-30'),(38987,'g',4,'2011-09-30'),(40342,'g',4,'2011-09-30'),(40499,'g',3,'2011-09-30'),(40675,'g',0,'2011-09-30'),(39114,'g',0,'2011-09-30'),(39671,'g',3,'2011-09-30'),(39153,'g',4,'2011-09-30'),(40589,'g',0,'2011-09-30'),(39223,'g',0,'2011-09-30'),(40122,'g',0,'2011-09-30'),(39632,'g',0,'2011-09-30'),(40009,'g',0,'2011-09-30'),(39400,'g',4,'2011-09-30'),(39429,'g',4,'2011-09-30'),(39104,'g',2,'2011-09-30'),(40318,'g',0,'2011-09-30'),(40022,'g',3,'2011-09-30'),(39568,'g',0,'2011-09-30'),(40229,'g',4,'2011-09-30'),(39877,'g',3,'2011-09-30'),(39532,'g',2,'2011-09-30'),(39952,'g',2,'2011-10-01'),(39508,'g',0,'2011-10-01'),(39081,'g',0,'2011-10-01'),(39428,'g',0,'2011-10-01'),(40626,'g',0,'2011-10-01'),(39157,'g',2,'2011-10-01'),(38909,'g',0,'2011-10-01'),(39438,'g',6,'2011-10-01'),(40228,'g',2,'2011-10-01'),(39626,'g',0,'2011-10-01'),(39138,'g',0,'2011-10-01'),(39503,'g',3,'2011-10-01'),(38960,'g',3,'2011-10-01'),(39764,'g',2,'2011-10-01'),(39660,'g',1,'2011-10-01'),(39967,'g',2,'2011-10-01'),(40463,'g',0,'2011-10-01'),(40295,'g',0,'2011-10-01'),(39923,'g',2,'2011-10-01'),(39159,'g',0,'2011-10-01'),(39610,'g',0,'2011-10-01'),(39582,'g',0,'2011-10-01'),(40180,'g',0,'2011-10-01'),(39863,'g',4,'2011-10-01'),(39291,'g',2,'2011-10-01'),(40609,'g',0,'2011-10-01'),(40730,'g',0,'2011-10-01'),(39257,'g',1,'2011-10-01'),(39307,'g',0,'2011-10-01'),(40164,'g',3,'2011-10-01'),(40606,'g',4,'2011-10-01'),(39529,'g',1,'2011-10-01'),(39107,'g',5,'2011-10-01'),(40257,'g',0,'2011-10-01'),(40663,'g',3,'2011-10-01'),(39472,'g',0,'2011-10-01'),(39637,'g',2,'2011-10-01'),(38931,'g',2,'2011-10-02'),(40509,'g',0,'2011-10-02'),(38855,'g',0,'2011-10-02'),(39281,'g',0,'2011-10-02'),(40260,'g',0,'2011-10-02'),(39652,'g',0,'2011-10-02'),(40026,'g',3,'2011-10-02'),(40453,'g',3,'2011-10-02'),(38812,'g',3,'2011-10-02'),(39386,'g',0,'2011-10-02'),(39585,'g',1,'2011-10-02'),(40190,'g',0,'2011-10-02'),(40159,'g',0,'2011-10-02'),(39406,'g',0,'2011-10-02'),(39475,'g',2,'2011-10-02'),(40200,'g',1,'2011-10-02'),(39540,'g',8,'2011-10-02'),(40496,'g',0,'2011-10-02'),(40167,'g',5,'2011-10-02'),(39346,'g',3,'2011-10-02'),(39180,'g',2,'2011-10-02'),(40238,'g',0,'2011-10-02'),(39012,'g',2,'2011-10-02'),(39384,'g',1,'2011-10-02'),(39645,'g',1,'2011-10-02'),(39559,'g',6,'2011-10-02'),(39479,'g',2,'2011-10-02'),(39103,'g',0,'2011-10-02'),(39820,'g',0,'2011-10-02'),(39037,'g',4,'2011-10-02'),(39027,'g',0,'2011-10-02'),(40711,'g',3,'2011-10-02'),(39895,'g',0,'2011-10-02'),(39390,'g',4,'2011-10-02'),(39683,'g',1,'2011-10-02'),(39033,'g',1,'2011-10-02'),(39728,'g',3,'2011-10-02'),(39144,'g',0,'2011-10-02'),(39430,'g',0,'2011-10-02'),(40392,'g',0,'2011-10-02'),(40313,'g',0,'2011-10-02'),(40281,'g',3,'2011-10-02'),(39179,'g',0,'2011-10-02'),(39909,'g',3,'2011-10-02'),(40282,'g',0,'2011-10-02'),(40486,'g',1,'2011-10-02'),(40188,'g',0,'2011-10-02'),(39252,'g',0,'2011-10-02'),(38916,'g',0,'2011-10-02'),(40365,'g',0,'2011-10-02'),(40684,'g',1,'2011-10-03'),(38865,'g',0,'2011-10-03'),(40061,'g',3,'2011-10-03'),(39647,'g',0,'2011-10-03'),(39312,'g',0,'2011-10-03'),(38937,'g',4,'2011-10-03'),(39700,'g',0,'2011-10-03'),(40423,'g',0,'2011-10-03'),(39701,'g',0,'2011-10-03'),(38872,'g',0,'2011-10-03'),(40262,'g',0,'2011-10-03'),(40148,'g',0,'2011-10-03'),(42559,'g',0,'2011-11-10'),(42347,'g',0,'2011-11-10'),(42345,'g',0,'2011-11-10'),(42297,'g',0,'2011-11-10'),(42333,'g',0,'2011-11-10'),(41997,'g',0,'2011-11-10'),(41927,'g',0,'2011-11-10'),(40817,'g',0,'2011-11-10'),(42556,'g',0,'2011-11-10'),(42558,'g',0,'2011-11-10'),(42552,'g',0,'2011-11-10'),(42551,'g',0,'2011-11-10'),(42557,'g',0,'2011-11-10'),(42555,'g',0,'2011-11-10'),(42554,'g',0,'2011-11-10'),(42553,'g',0,'2011-11-10'),(42550,'g',0,'2011-11-10'),(41598,'g',0,'2011-11-10'),(41524,'g',0,'2011-11-10'),(40822,'g',0,'2011-11-10'),(41359,'g',0,'2011-11-10'),(41307,'g',0,'2011-11-10'),(41609,'g',0,'2011-11-10'),(41588,'g',0,'2011-11-10'),(41370,'g',0,'2011-11-10'),(42495,'g',0,'2011-11-10'),(42497,'g',0,'2011-11-10'),(42475,'g',0,'2011-11-10'),(42474,'g',0,'2011-11-10'),(42455,'g',0,'2011-11-10'),(42448,'g',0,'2011-11-10'),(42462,'g',0,'2011-11-10'),(42493,'g',0,'2011-11-10'),(42457,'g',0,'2011-11-10'),(40803,'g',0,'2011-11-10'),(41550,'g',0,'2011-11-10'),(41490,'g',0,'2011-11-10'),(41281,'g',0,'2011-11-10'),(41239,'g',0,'2011-11-10'),(41343,'g',0,'2011-11-10'),(41354,'g',0,'2011-11-10'),(41570,'g',0,'2011-11-10'),(41548,'g',0,'2011-11-10'),(41291,'g',0,'2011-11-10'),(41170,'g',0,'2011-11-10'),(40802,'g',0,'2011-11-10'),(40801,'g',0,'2011-11-10'),(42481,'g',0,'2011-11-10'),(42470,'g',0,'2011-11-10'),(42539,'g',0,'2011-11-10'),(42450,'g',0,'2011-11-10'),(42480,'g',0,'2011-11-10'),(42441,'g',0,'2011-11-10'),(42463,'g',0,'2011-11-10'),(42461,'g',0,'2011-11-10'),(42516,'g',0,'2011-11-10'),(42508,'g',0,'2011-11-10'),(42256,'g',0,'2011-11-10'),(42244,'g',0,'2011-11-10'),(42200,'g',0,'2011-11-10'),(41856,'g',0,'2011-11-10'),(41790,'g',0,'2011-11-10'),(42246,'g',0,'2011-11-10'),(42517,'g',0,'2011-11-10'),(42549,'g',0,'2011-11-10'),(42570,'g',0,'2011-11-10'),(42469,'g',0,'2011-11-10'),(42421,'g',0,'2011-11-10'),(42113,'g',0,'2011-11-10'),(42126,'g',0,'2011-11-10'),(42456,'g',0,'2011-11-10'),(42177,'g',0,'2011-11-10'),(42093,'g',0,'2011-11-10'),(42089,'g',0,'2011-11-10'),(42468,'g',0,'2011-11-10'),(42588,'g',0,'2011-11-10'),(42439,'g',0,'2011-11-10'),(42452,'g',0,'2011-11-10'),(42599,'g',0,'2011-11-10'),(42252,'g',0,'2011-11-10'),(42401,'g',0,'2011-11-10'),(42593,'g',0,'2011-11-10'),(42454,'g',0,'2011-11-10'),(41602,'g',0,'2011-11-10'),(41594,'g',0,'2011-11-10'),(41530,'g',0,'2011-11-10'),(41372,'g',0,'2011-11-10'),(41614,'g',0,'2011-11-10'),(41361,'g',0,'2011-11-10'),(42598,'g',0,'2011-11-10'),(42597,'g',0,'2011-11-10'),(42545,'g',0,'2011-11-10'),(42596,'g',0,'2011-11-10'),(40800,'g',0,'2011-11-10'),(40809,'g',0,'2011-11-10'),(42595,'g',0,'2011-11-10'),(40818,'g',0,'2011-11-10'),(41160,'g',0,'2011-11-10'),(42591,'g',0,'2011-11-10'),(42594,'g',0,'2011-11-10'),(42240,'g',0,'2011-11-10'),(42242,'g',0,'2011-11-10'),(42592,'g',0,'2011-11-10'),(42590,'g',0,'2011-11-10'),(41797,'g',0,'2011-11-10'),(41759,'g',0,'2011-11-10'),(40821,'g',0,'2011-11-10'),(41430,'g',0,'2011-11-10'),(41784,'g',0,'2011-11-10'),(41698,'g',0,'2011-11-10'),(42567,'g',0,'2011-11-10'),(41288,'g',0,'2011-11-10'),(42575,'g',0,'2011-11-10'),(42565,'g',0,'2011-11-10'),(40813,'g',0,'2011-11-10'),(42587,'g',0,'2011-11-10'),(40805,'g',0,'2011-11-10'),(42569,'g',0,'2011-11-10'),(40806,'g',0,'2011-11-10'),(42586,'g',0,'2011-11-10'),(40857,'g',0,'2011-11-10'),(40816,'g',0,'2011-11-10'),(40904,'g',0,'2011-11-10'),(42584,'g',0,'2011-11-10'),(42578,'g',0,'2011-11-10'),(40811,'g',0,'2011-11-10'),(42585,'g',0,'2011-11-10'),(42600,'g',0,'2011-11-10'),(42589,'g',0,'2011-11-10'),(42583,'g',0,'2011-11-10'),(42582,'g',0,'2011-11-10'),(42579,'g',0,'2011-11-10'),(42577,'g',0,'2011-11-10'),(42580,'g',0,'2011-11-10'),(42576,'g',0,'2011-11-10'),(42574,'g',0,'2011-11-10'),(42573,'g',0,'2011-11-10'),(42572,'g',0,'2011-11-10'),(42571,'g',0,'2011-11-10'),(42568,'g',0,'2011-11-10'),(42566,'g',0,'2011-11-10'),(42581,'g',0,'2011-11-10'),(42563,'g',0,'2011-11-10'),(42562,'g',0,'2011-11-10'),(42561,'g',0,'2011-11-10'),(42560,'g',0,'2011-11-10'),(42601,'g',0,'2011-11-11'),(42602,'g',0,'2011-11-11'),(42564,'g',0,'2011-11-11'),(42511,'g',0,'2011-11-13'),(42698,'g',0,'2011-12-12'),(42675,'g',0,'2012-01-02'),(40884,'g',0,'2012-01-02'),(40850,'g',0,'2012-01-23'),(42498,'g',0,'2012-01-23'),(43253,'g',0,'2012-02-14'),(43128,'g',0,'2012-02-14'),(43199,'g',0,'2012-02-14'),(43242,'g',0,'2012-02-14'),(43204,'g',0,'2012-02-14'),(43112,'g',0,'2012-02-14'),(43099,'g',0,'2012-02-14'),(43215,'g',0,'2012-02-14'),(43252,'g',0,'2012-02-14'),(43234,'g',0,'2012-02-14'),(42357,'g',0,'2012-02-27'),(42343,'g',0,'2012-02-27'),(42308,'g',0,'2012-02-27'),(42359,'g',0,'2012-02-27'),(42534,'g',0,'2012-02-27'),(43089,'g',0,'2012-02-27'),(43084,'g',0,'2012-02-27'),(42303,'g',0,'2012-02-27'),(42939,'g',0,'2012-02-27'),(42296,'g',0,'2012-02-27');

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

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

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


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

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

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

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

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

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

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


--
-- Table structure for table `idx_pl_sociable`
--

CREATE TABLE `idx_pl_sociable` (
  `sb_id` int(11) NOT NULL auto_increment,
  `sb_name` varchar(255) character set utf8 default NULL,
  `sb_url` varchar(255) character set utf8 default NULL,
  `sb_icon` varchar(255) character set utf8 default NULL,
  `sb_enable` char(1) character set utf8 default '0',
  PRIMARY KEY  (`sb_id`)
) ENGINE=MyISAM AUTO_INCREMENT=90 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_pl_sociable`
--

INSERT INTO `idx_pl_sociable` VALUES (1,'BarraPunto','http://barrapunto.com/submit.pl?subj=TITLE&amp;story=PERMALINK','barrapunto.png','0'),(2,'Bitacoras.com','http://bitacoras.com/anotaciones/PERMALINK','bitacoras.png','0'),(3,'BlinkList','http://www.blinklist.com/index.php?Action=Blink/addblink.php&amp;Url=PERMALINK&amp;Title=TITLE','blinklist.png','0'),(4,'blogmarks','http://blogmarks.net/my/new.php?mini=1&amp;simple=1&amp;url=PERMALINK&amp;title=TITLE','blogmarks.png','0'),(5,'Blogosphere News','http://www.blogospherenews.com/submit.php?url=PERMALINK&amp;title=TITLE','blogospherenews.png','0'),(6,'blogtercimlap','http://cimlap.blogter.hu/index.php?action=suggest_link&amp;title=TITLE&amp;url=PERMALINK','blogter.png','0'),(7,'Faves','http://faves.com/Authoring.aspx?u=PERMALINK&amp;title=TITLE','bluedot.png','0'),(8,'connotea','http://www.connotea.org/addpopup?continue=confirm&amp;uri=PERMALINK&amp;title=TITLE&amp;description=EXCERPT','connotea.png','0'),(9,'Current','http://current.com/clipper.htm?url=PERMALINK&amp;title=TITLE','current.png','0'),(10,'del.icio.us','http://delicious.com/post?url=PERMALINK&amp;title=TITLE&amp;notes=EXCERPT','delicious.png','0'),(11,'Digg','http://digg.com/submit?phase=2&amp;url=PERMALINK&amp;title=TITLE&amp;bodytext=EXCERPT','digg.png','1'),(12,'Diigo','http://www.diigo.com/post?url=PERMALINK&amp;title=TITLE','diigo.png','0'),(13,'DotNetKicks','http://www.dotnetkicks.com/kick/?url=PERMALINK&amp;title=TITLE','dotnetkicks.png','0'),(14,'DZone','http://www.dzone.com/links/add.html?url=PERMALINK&amp;title=TITLE','dzone.png','0'),(15,'eKudos','http://www.ekudos.nl/artikel/nieuw?url=PERMALINK&amp;title=TITLE&amp;desc=EXCERPT','ekudos.png','0'),(16,'email','mailto:?subject=TITLE&amp;body=PERMALINK','email_link.png','0'),(17,'Facebook','http://www.facebook.com/share.php?u=PERMALINK&amp;t=TITLE','facebook.png','1'),(18,'Fark','http://cgi.fark.com/cgi/fark/farkit.pl?h=TITLE&amp;u=PERMALINK','fark.png','0'),(19,'Fleck','http://beta3.fleck.com/bookmarklet.php?url=PERMALINK&amp;title=TITLE','fleck.png','0'),(20,'FriendFeed','http://www.friendfeed.com/share?title=TITLE&amp;link=PERMALINK','friendfeed.png','0'),(21,'FSDaily','http://www.fsdaily.com/submit?url=PERMALINK&amp;title=TITLE','fsdaily.png','0'),(22,'Global Grind','http://globalgrind.com/submission/submit.aspx?url=PERMALINK&amp;type=Article&amp;title=TITLE','globalgrind.png','0'),(23,'Google','http://www.google.com/bookmarks/mark?op=edit&amp;bkmk=PERMALINK&amp;title=TITLE&amp;annotation=EXCERPT','googlebookmark.png','0'),(24,'Gwar','http://www.gwar.pl/DodajGwar.html?u=PERMALINK','gwar.png','0'),(25,'HackerNews','http://news.ycombinator.com/submitlink?u=PERMALINK&amp;t=TITLE','hackernews.png','0'),(26,'Haohao','http://www.haohaoreport.com/submit.php?url=PERMALINK&amp;title=TITLE','haohao.png','0'),(27,'HealthRanker','http://healthranker.com/submit.php?url=PERMALINK&amp;title=TITLE','healthranker.png','0'),(28,'HelloTxt','http://hellotxt.com/?status=TITLE+PERMALINK','hellotxt.png','0'),(29,'Hemidemi','http://www.hemidemi.com/user_bookmark/new?title=TITLE&amp;url=PERMALINK','hemidemi.png','0'),(30,'Hyves','http://www.hyves.nl/profilemanage/add/tips/?name=TITLE&amp;text=EXCERPT+PERMALINK&amp;rating=5','hyves.png','0'),(31,'Identi.ca','http://identi.ca/notice/new?status_textarea=PERMALINK','identica.png','0'),(32,'IndianPad','http://www.indianpad.com/submit.php?url=PERMALINK','indianpad.png','0'),(33,'Internetmedia','http://internetmedia.hu/submit.php?url=PERMALINK','im.png','0'),(34,'Kirtsy','http://www.kirtsy.com/submit.php?url=PERMALINK&amp;title=TITLE','kirtsy.png','0'),(35,'laaik.it','http://laaik.it/NewStoryCompact.aspx?uri=PERMALINK&amp;headline=TITLE&amp;cat=5e082fcc-8a3b-47e2-acec-fdf64ff19d12','laaikit.png','0'),(36,'LinkArena','http://linkarena.com/bookmarks/addlink/?url=PERMALINK&amp;title=TITLE','linkarena.png','0'),(37,'LinkaGoGo','http://www.linkagogo.com/go/AddNoPopup?url=PERMALINK&amp;title=TITLE','linkagogo.png','0'),(38,'LinkedIn','http://www.linkedin.com/shareArticle?mini=true&amp;url=PERMALINK&amp;title=TITLE&amp;source=BLOGNAME&amp;summary=EXCERPT','linkedin.png','0'),(39,'Linkter','http://www.linkter.hu/index.php?action=suggest_link&amp;url=PERMALINK&amp;title=TITLE','linkter.png','0'),(40,'Live','https://favorites.live.com/quickadd.aspx?marklet=1&amp;url=PERMALINK&amp;title=TITLE','live.png','0'),(41,'Meneame','http://meneame.net/submit.php?url=PERMALINK','meneame.png','0'),(42,'MisterWong','http://www.mister-wong.com/addurl/?bm_url=PERMALINK&amp;bm_description=TITLE&amp;plugin=soc','misterwong.png','0'),(43,'MisterWong.DE','http://www.mister-wong.de/addurl/?bm_url=PERMALINK&amp;bm_description=TITLE&amp;plugin=soc','misterwong.png','0'),(44,'Mixx','http://www.mixx.com/submit?page_url=PERMALINK&amp;title=TITLE','mixx.png','0'),(45,'muti','http://www.muti.co.za/submit?url=PERMALINK&amp;title=TITLE','muti.png','0'),(46,'MyShare','http://myshare.url.com.tw/index.php?func=newurl&amp;url=PERMALINK&amp;desc=TITLE','myshare.png','0'),(47,'MySpace','http://www.myspace.com/Modules/PostTo/Pages/?u=PERMALINK&amp;t=TITLE','myspace.png','0'),(48,'MSNReporter','http://reporter.nl.msn.com/?fn=contribute&amp;Title=TITLE&amp;URL=PERMALINK&amp;cat_id=6&amp;tag_id=31&amp;Remark=EXCERPT','msnreporter.png','0'),(49,'N4G','http://www.n4g.com/tips.aspx?url=PERMALINK&amp;title=TITLE','n4g.png','0'),(50,'Netvibes','http://www.netvibes.com/share?title=TITLE&amp;url=PERMALINK','netvibes.png','0'),(51,'NewsVine','http://www.newsvine.com/_tools/seed&amp;save?u=PERMALINK&amp;h=TITLE','newsvine.png','0'),(52,'Netvouz','http://www.netvouz.com/action/submitBookmark?url=PERMALINK&amp;title=TITLE&amp;popup=no','netvouz.png','0'),(53,'NuJIJ','http://nujij.nl/jij.lynkx?t=TITLE&amp;u=PERMALINK&amp;b=EXCERPT','nujij.png','0'),(54,'Ping.fm','http://ping.fm/ref/?link=PERMALINK&amp;title=TITLE&amp;body=EXCERPT','ping.png','0'),(55,'Posterous','http://posterous.com/share?linkto=PERMALINK&amp;title=TITLE&amp;selection=EXCERPT','posterous.png','0'),(56,'PDF','http://www.printfriendly.com/print?url=PERMALINK&amp;partner=sociable','pdf.png','0'),(57,'Print','http://www.printfriendly.com/print?url=PERMALINK&amp;partner=sociable','printfriendly.png','0'),(58,'Propeller','http://www.propeller.com/submit/?url=PERMALINK','propeller.png','0'),(59,'Ratimarks','http://ratimarks.org/bookmarks.php/?action=add&address=PERMALINK&amp;title=TITLE','ratimarks.png','0'),(60,'Rec6','http://rec6.via6.com/link.php?url=PERMALINK&amp;=TITLE','rec6.png','0'),(61,'Reddit','http://reddit.com/submit?url=PERMALINK&amp;title=TITLE','reddit.png','0'),(62,'RSS','FEEDLINK','rss.png','0'),(63,'Scoopeo','http://www.scoopeo.com/scoop/new?newurl=PERMALINK&amp;title=TITLE','scoopeo.png','0'),(64,'Segnalo','http://segnalo.alice.it/post.html.php?url=PERMALINK&amp;title=TITLE','segnalo.png','0'),(65,'Simpy','http://www.simpy.com/simpy/LinkAdd.do?href=PERMALINK&amp;title=TITLE','simpy.png','0'),(66,'Slashdot','http://slashdot.org/bookmark.pl?title=TITLE&amp;url=PERMALINK','slashdot.png','0'),(67,'Socialogs','http://socialogs.com/add_story.php?story_url=PERMALINK&amp;story_title=TITLE','socialogs.png','0'),(68,'SphereIt','http://www.sphere.com/search?q=sphereit:PERMALINK&amp;title=TITLE','sphere.png','0'),(69,'Sphinn','http://sphinn.com/index.php?c=post&amp;m=submit&amp;link=PERMALINK','sphinn.png','0'),(70,'StumbleUpon','http://www.stumbleupon.com/submit?url=PERMALINK&amp;title=TITLE','stumbleupon.png','0'),(71,'Techmeme','http://twitter.com/home/?status=tip%20@Techmeme%20PERMALINK%20TITLE','techmeme.png','0'),(72,'Technorati','http://technorati.com/faves?add=PERMALINK','technorati.png','1'),(73,'ThisNext','http://www.thisnext.com/pick/new/submit/sociable/?url=PERMALINK&amp;name=TITLE','thisnext.png','0'),(74,'Tipd','http://tipd.com/submit.php?url=PERMALINK','tipd.png','0'),(75,'Tumblr','http://www.tumblr.com/share?v=3&amp;u=PERMALINK&amp;t=TITLE&amp;s=EXCERPT','tumblr.png','0'),(76,'Twitter','http://twitter.com/home?status=TITLE%20-%20PERMALINK','twitter.png','1'),(77,'Upnews','http://www.upnews.it/submit?url=PERMALINK&amp;title=TITLE','upnews.png','0'),(78,'Webnews.de','http://www.webnews.de/einstellen?url=PERMALINK&amp;title=TITLE','webnews.png','0'),(79,'Webride','http://webride.org/discuss/split.php?uri=PERMALINK&amp;title=TITLE','webride.png','0'),(80,'Wikio','http://www.wikio.com/vote?url=PERMALINK','wikio.png','0'),(81,'Wikio FR','http://www.wikio.fr/vote?url=PERMALINK','wikio.png','0'),(82,'Wikio IT','http://www.wikio.it/vote?url=PERMALINK','wikio.png','0'),(83,'Wists','http://wists.com/s.php?c=&amp;r=PERMALINK&amp;title=TITLE','wists.png','0'),(84,'Wykop','http://www.wykop.pl/dodaj?url=PERMALINK','wykop.png','0'),(85,'Xerpi','http://www.xerpi.com/block/add_link_from_extension?url=PERMALINK&amp;title=TITLE','xerpi.png','0'),(86,'YahooBuzz','http://buzz.yahoo.com/submit/?submitUrl=PERMALINK&amp;submitHeadline=TITLE&amp;submitSummary=EXCERPT&amp;submitCategory=science&amp;submitAssetType=text','yahoobuzz.png','0'),(87,'Yahoo! Bookmarks','http://bookmarks.yahoo.com/toolbar/savebm?u=PERMALINK&amp;t=TITLE&opener=bm&amp;ei=UTF-8&amp;d=EXCERPT','yahoomyweb.png','0'),(88,'Yigg','http://yigg.de/neu?exturl=PERMALINK&amp;exttitle=TITLE','yiggit.png','0'),(89,'Blogplay','http://blogplay.com','blogplay.png','0');

--
-- Table structure for table `idx_pl_twitter_account`
--

CREATE TABLE `idx_pl_twitter_account` (
  `ck` varchar(255) character set utf8 default NULL,
  `cs` varchar(255) character set utf8 default NULL,
  `at` varchar(255) character set utf8 default NULL,
  `ats` varchar(255) character set utf8 default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_pl_twitter_account`
--

INSERT INTO `idx_pl_twitter_account` VALUES ('WVoc5Hr8sECXzU4aeGGTQ','RdlaYdK7JId9FxGG32ZYceIKcuB5nFLwHIEvJwQJXEI','https://api.twitter.com/oauth/authorize','https://api.twitter.com/oauth/access_token');

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

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

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

INSERT INTO `idx_plugin` VALUES (1,'AutoTweet','twitter_auto_tweet/twitter_auto_tweet.php','1',NULL),(2,'Sociable','sociable/sociable.php','1',NULL);

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

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

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


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

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

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


--
-- Table structure for table `idx_set_hook_place`
--

CREATE TABLE `idx_set_hook_place` (
  `set_hook_place_id` int(11) NOT NULL auto_increment,
  `plugin` varchar(255) collate latin1_general_ci default NULL,
  `set_hook_place` text collate latin1_general_ci,
  PRIMARY KEY  (`set_hook_place_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `idx_set_hook_place`
--


--
-- Table structure for table `idx_setting`
--

CREATE TABLE `idx_setting` (
  `setting_id` int(11) NOT NULL auto_increment,
  `setting_name` varchar(255) collate latin1_general_ci default NULL,
  `setting_value` text collate latin1_general_ci,
  PRIMARY KEY  (`setting_id`)
) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

INSERT INTO `idx_setting` VALUES (4,'site_name','hotlisting.co.uk'),(5,'site_url','http://hotlisting.co.uk'),(6,'email_address','averys.dimuro@gmail.com'),(7,'language_code','en_US'),(8,'theme_path','/home/hotlisti/public_html/themes/'),(9,'admin_template_path','/home/hotlisti/public_html/admin_tpl/'),(10,'plugin_path','/home/hotlisti/public_html/plugin/'),(12,'active_theme','hotlisting'),(14,'spam_proof','1'),(15,'enable_user_validation','1'),(16,'allowed_file_extension','gif,jpg,png,pdf,zip,doc'),(17,'yahoo_appid',''),(18,'whosonline','600'),(19,'reciprocal_check','0'),(20,'urlcheck_limit','1'),(21,'pagerank_cache','30'),(22,'max_image_width','1024'),(23,'max_image_height','756'),(24,'max_file_size','500'),(25,'only_registered_can_add_link','0'),(26,'only_registered_can_add_review','0'),(27,'db_use_persistent','0'),(28,'paid_link_day_period','30,60,90,180'),(29,'paid_link_price_factor','1,1.5,2,3'),(30,'enable_html_tag','1'),(31,'allowed_html_tag','<b>,<strong>,<i>,<em>,<u>,<pre>,<blockquote>,<ol>,<ul>,<li>,<p>,<span>,<div>,<table>,<tr>,<td>'),(32,'enable_page_compression','0'),(33,'enable_category_ajax','1'),(34,'require_visit_category','0'),(35,'additional_category_price','0.5'),(36,'enable_rating_ajax','1'),(37,'service_nicecoder_avail','1'),(38,'enable_recaptcha','0'),(39,'recaptcha_publickey',''),(40,'recaptcha_privatekey',''),(41,'enable_bidding','0'),(42,'minimum_bid','5'),(43,'bid_increament','1'),(44,'charset','utf-8'),(45,'mailer','mail'),(46,'smtp_auth','0'),(47,'smtp_host',''),(48,'smtp_username',''),(49,'smtp_password',''),(50,'smtp_port','25'),(51,'emailbody_as_html','0'),(52,'indexu_version','2.4'),(53,'tos',''),(54,'submission_guidelines','');

--
-- Table structure for table `idx_tags`
--

CREATE TABLE `idx_tags` (
  `tag` varchar(64) collate latin1_general_ci NOT NULL default '',
  `category_id` mediumint(8) unsigned NOT NULL default '0',
  `total` int(11) NOT NULL default '0',
  `tag_path` varchar(64) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`tag`,`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `idx_tags`
--

INSERT INTO `idx_tags` VALUES ('commercial',0,39,'commercial'),('commercial',2,27,'commercial'),('property',0,64,'property'),('property',2,16,'property'),('real',0,2868,'real'),('real',2,22,'real'),('estate',0,2850,'estate'),('estate',2,22,'estate'),('holding',0,3,'holding'),('holding',2,2,'holding'),('company',0,5,'company'),('company',2,2,'company'),('developer',0,103,'developer'),('developer',2,2,'developer'),('manager',0,942,'manager'),('manager',2,2,'manager'),('hotel',0,29,'hotel'),('hotel',2,8,'hotel'),('management',0,56,'management'),('management',2,4,'management'),('motel',0,24,'motel'),('motel',2,7,'motel'),('operation',0,25,'operation'),('operation',2,9,'operation'),('nonresdentl',0,3,'nonresdentl'),('nonresdentl',2,3,'nonresdentl'),('bldg',0,8,'bldg'),('bldg',2,4,'bldg'),('operatr',0,3,'operatr'),('operatr',2,3,'operatr'),('drinking',0,2,'drinking'),('drinking',2,1,'drinking'),('nonresidential',0,109,'nonresidential'),('nonresidential',2,102,'nonresidential'),('building',0,424,'building'),('building',2,106,'building'),('operator',0,437,'operator'),('operator',2,118,'operator'),('non',0,2,'non'),('non',2,2,'non'),('residential',0,18,'residential'),('residential',2,3,'residential'),('mfg',0,4,'mfg'),('mfg',2,4,'mfg'),('rope',0,1,'rope'),('rope',2,1,'rope'),('and',0,23,'and'),('and',2,7,'and'),('twine',0,1,'twine'),('twine',2,1,'twine'),('business',0,11,'business'),('business',2,1,'business'),('services',0,23,'services'),('services',2,4,'services'),('secr',0,1,'secr'),('secr',2,1,'secr'),('eating',0,4,'eating'),('eating',2,3,'eating'),('place',0,4,'place'),('place',2,3,'place'),('legal',0,4,'legal'),('legal',2,3,'legal'),('ser',0,1,'ser'),('ser',2,1,'ser'),('membership',0,4,'membership'),('membership',2,1,'membership'),('sport',0,3,'sport'),('sport',2,1,'sport'),('recre',0,2,'recre'),('recre',2,1,'recre'),('measuring',0,1,'measuring'),('measuring',2,1,'measuring'),('controll',0,1,'controll'),('controll',2,1,'controll'),('agent',0,969,'agent'),('agent',2,9,'agent'),('mana',0,8,'mana'),('mana',2,8,'mana'),('religious',0,1,'religious'),('religious',2,1,'religious'),('organization',0,2,'organization'),('organization',2,1,'organization'),('ret',0,15,'ret'),('ret',2,6,'ret'),('alcoholic',0,1,'alcoholic'),('alcoholic',2,1,'alcoholic'),('beverage',0,1,'beverage'),('beverage',2,1,'beverage'),('skilled',0,4,'skilled'),('skilled',2,1,'skilled'),('nursing',0,6,'nursing'),('nursing',2,1,'nursing'),('care',0,15,'care'),('care',2,1,'care'),('operators',0,25,'operators'),('operators',2,10,'operators'),('metal',0,1,'metal'),('metal',2,1,'metal'),('stampi',0,1,'stampi'),('stampi',2,1,'stampi'),('owner',0,16,'owner'),('owner',2,9,'owner'),('owner-operator',0,3,'owner-operator'),('owner-operator',2,2,'owner-operator'),('arena',0,1,'arena'),('arena',2,1,'arena'),('civic',0,1,'civic'),('civic',2,1,'civic'),('center',0,17,'center'),('center',2,11,'center'),('subdividers',0,3,'subdividers'),('subdividers',2,1,'subdividers'),('self',0,1,'self'),('self',2,1,'self'),('storage',0,1,'storage'),('storage',2,1,'storage'),('supplies',0,1,'supplies'),('supplies',2,1,'supplies'),('labor',0,1,'labor'),('labor',2,1,'labor'),('force',0,1,'force'),('force',2,1,'force'),('handcrafts',0,1,'handcrafts'),('handcrafts',2,1,'handcrafts'),('for',0,8,'for'),('for',2,2,'for'),('artists',0,1,'artists'),('artists',2,1,'artists'),('bank',0,1,'bank'),('bank',2,1,'bank'),('builder',0,4,'builder'),('builder',2,1,'builder'),('operates',0,17,'operates'),('operates',2,3,'operates'),('apartment',0,386,'apartment'),('apartment',2,3,'apartment'),('complex',0,42,'complex'),('complex',2,1,'complex'),('contractor',0,4,'contractor'),('contractor',2,2,'contractor'),('insurance',0,6,'insurance'),('insurance',2,1,'insurance'),('lessors',0,3,'lessors'),('lessors',2,1,'lessors'),('buildings',0,313,'buildings'),('buildings',2,305,'buildings'),('dwelling',0,2,'dwelling'),('dwelling',2,1,'dwelling'),('water',0,2,'water'),('water',2,1,'water'),('transp',0,1,'transp'),('transp',2,1,'transp'),('used',0,8,'used'),('used',2,4,'used'),('automobiles',0,5,'automobiles'),('automobiles',2,1,'automobiles'),('general',0,2,'general'),('general',2,2,'general'),('maintenance',0,1,'maintenance'),('maintenance',2,1,'maintenance'),('executive',0,91,'executive'),('executive',2,91,'executive'),('office',0,301,'office'),('office',2,300,'office'),('laminated',0,1,'laminated'),('laminated',2,1,'laminated'),('plastic',0,1,'plastic'),('plastic',2,1,'plastic'),('merchandise',0,5,'merchandise'),('merchandise',2,3,'merchandise'),('subdivider',0,70,'subdivider'),('subdivider',2,1,'subdivider'),('open-end',0,1,'open-end'),('open-end',2,1,'open-end'),('managment',0,2,'managment'),('managment',2,1,'managment'),('investment',0,3,'investment'),('investment',2,1,'investment'),('industrial',0,3,'industrial'),('industrial',2,1,'industrial'),('retai',0,1,'retai'),('retai',2,1,'retai'),('own',0,2,'own'),('own',2,1,'own'),('shopping',0,443,'shopping'),('shopping',2,443,'shopping'),('mall',0,3,'mall'),('mall',2,2,'mall'),('rental',0,8,'rental'),('rental',2,1,'rental'),('auto',0,1,'auto'),('auto',2,1,'auto'),('body',0,1,'body'),('body',2,1,'body'),('shops',0,1,'shops'),('shops',2,1,'shops'),('agenc',0,1,'agenc'),('agenc',2,1,'agenc'),('owners',0,4,'owners'),('owners',2,2,'owners'),('school',0,1,'school'),('school',2,1,'school'),('educational',0,1,'educational'),('educational',2,1,'educational'),('centers',0,434,'centers'),('centers',2,433,'centers'),('malls',0,432,'malls'),('malls',2,432,'malls'),('leases',0,1,'leases'),('leases',2,1,'leases'),('market',0,1,'market'),('market',2,1,'market'),('stands',0,1,'stands'),('stands',2,1,'stands'),('from',0,1,'from'),('from',2,1,'from'),('site',0,2,'site'),('site',2,1,'site'),('amusement',0,3,'amusement'),('amusement',2,1,'amusement'),('recreation',0,3,'recreation'),('recreation',2,1,'recreation'),('nrsdntl',0,1,'nrsdntl'),('nrsdntl',2,1,'nrsdntl'),('optrs',0,1,'optrs'),('optrs',2,1,'optrs'),('parks',0,296,'parks'),('parks',2,295,'parks'),('manger',0,1,'manger'),('manger',2,1,'manger'),('rents',0,1,'rents'),('rents',2,1,'rents'),('space',0,1,'space'),('space',2,1,'space'),('antique',0,1,'antique'),('antique',2,1,'antique'),('dealers',0,1,'dealers'),('dealers',2,1,'dealers'),('only',0,2,'only'),('only',2,2,'only'),('entertainment',0,1,'entertainment'),('entertainment',2,1,'entertainment'),('facility',0,9,'facility'),('facility',2,1,'facility'),('suites',0,90,'suites'),('suites',2,90,'suites'),('music',0,1,'music'),('music',2,1,'music'),('auditorium',0,1,'auditorium'),('auditorium',2,1,'auditorium'),('bowling',0,1,'bowling'),('bowling',2,1,'bowling'),('theatrical',0,1,'theatrical'),('theatrical',2,1,'theatrical'),('producers',0,1,'producers'),('producers',2,1,'producers'),('performing',0,1,'performing'),('performing',2,1,'performing'),('arts',0,1,'arts'),('arts',2,1,'arts'),('developers',0,1819,'developers'),('developers',2,2,'developers'),('adult',0,1,'adult'),('adult',3,1,'adult'),('congregate',0,2,'congregate'),('congregate',3,1,'congregate'),('living',0,11,'living'),('living',3,11,'living'),('facility',3,8,'facility'),('apartment',3,375,'apartment'),('building',3,310,'building'),('complex',3,38,'complex'),('management',3,13,'management'),('managers',0,5,'managers'),('managers',3,3,'managers'),('operation',3,11,'operation'),('operator',3,309,'operator'),('eating',3,1,'eating'),('place',3,1,'place'),('hotel',3,13,'hotel'),('motel',3,9,'motel'),('membership',3,1,'membership'),('organization',3,1,'organization'),('nonresidential',3,5,'nonresidential'),('ope',0,6,'ope'),('ope',3,6,'ope'),('real',3,19,'real'),('estate',3,19,'estate'),('agent',3,14,'agent'),('manager',3,16,'manager'),('skilled',3,3,'skilled'),('nursing',3,5,'nursing'),('care',3,13,'care'),('facili',0,3,'facili'),('facili',3,3,'facili'),('specialty',0,1,'specialty'),('specialty',3,1,'specialty'),('hospital',0,1,'hospital'),('hospital',3,1,'hospital'),('operators',3,15,'operators'),('nsk',0,1,'nsk'),('nsk',3,1,'nsk'),('buildings',3,8,'buildings'),('community',0,8,'community'),('community',3,7,'community'),('complexes',0,2,'complexes'),('complexes',3,2,'complexes'),('company',3,2,'company'),('owner',3,6,'owner'),('owners',3,2,'owners'),('rental',3,6,'rental'),('apartment-hotel',0,1,'apartment-hotel'),('apartment-hotel',3,1,'apartment-hotel'),('apartments',0,3042,'apartments'),('apartments',3,3042,'apartments'),('apartmetn',0,1,'apartmetn'),('apartmetn',3,1,'apartmetn'),('apmnt',0,3,'apmnt'),('apmnt',3,3,'apmnt'),('bldg',3,4,'bldg'),('oprtrs',0,3,'oprtrs'),('oprtrs',3,3,'oprtrs'),('apt',0,5,'apt'),('apt',3,4,'apt'),('automobile',0,1,'automobile'),('automobile',3,1,'automobile'),('parking',0,1,'parking'),('parking',3,1,'parking'),('physical',0,2,'physical'),('physical',3,1,'physical'),('fitness',0,2,'fitness'),('fitness',3,1,'fitness'),('faclty',0,2,'faclty'),('faclty',3,1,'faclty'),('mot',0,1,'mot'),('mot',3,1,'mot'),('assisted',0,9,'assisted'),('assisted',3,9,'assisted'),('for',3,4,'for'),('the',0,1,'the'),('the',3,1,'the'),('elderly',0,3,'elderly'),('elderly',3,3,'elderly'),('holding',3,1,'holding'),('operates',3,8,'operates'),('operative',0,1,'operative'),('operative',3,1,'operative'),('builder',3,1,'builder'),('and',3,5,'and'),('center',3,6,'center'),('commercial',3,3,'commercial'),('structures',0,1,'structures'),('structures',3,1,'structures'),('owned',0,1,'owned'),('owned',3,1,'owned'),('manage',0,2,'manage'),('manage',3,1,'manage'),('centers',3,1,'centers'),('owner-operator',3,1,'owner-operator'),('boat',0,1,'boat'),('boat',3,1,'boat'),('slip',0,1,'slip'),('slip',3,1,'slip'),('leasin',0,1,'leasin'),('leasin',3,1,'leasin'),('owns',0,4,'owns'),('owns',3,3,'owns'),('residential',3,8,'residential'),('commerc',0,1,'commerc'),('commerc',3,1,'commerc'),('property',3,6,'property'),('broker',0,8,'broker'),('broker',3,1,'broker'),('mortgage',0,4,'mortgage'),('mortgage',3,1,'mortgage'),('investor',0,4,'investor'),('investor',3,1,'investor'),('rent',0,1,'rent'),('rent',3,1,'rent'),('apts',0,1,'apts'),('apts',3,1,'apts'),('agents',0,14,'agents'),('agents',3,1,'agents'),('retirement',0,23,'retirement'),('retirement',3,22,'retirement'),('home',0,7,'home'),('home',3,5,'home'),('senior',0,3,'senior'),('senior',3,3,'senior'),('citizen',0,1,'citizen'),('citizen',3,1,'citizen'),('residence',0,2,'residence'),('residence',3,2,'residence'),('housing',0,4,'housing'),('housing',3,4,'housing'),('student',0,1,'student'),('student',3,1,'student'),('condominiums',0,489,'condominiums'),('condominiums',3,489,'condominiums'),('boarding',0,11,'boarding'),('boarding',3,10,'boarding'),('houses',0,10,'houses'),('houses',3,10,'houses'),('agencies',0,4,'agencies'),('agencies',3,4,'agencies'),('hotels',0,6,'hotels'),('hotels',3,6,'hotels'),('intermediate',0,5,'intermediate'),('intermediate',3,5,'intermediate'),('personal',0,2,'personal'),('personal',3,1,'personal'),('resid',0,1,'resid'),('resid',3,1,'resid'),('services',3,3,'services'),('subdivider',3,1,'subdivider'),('developer',3,2,'developer'),('construction',0,4,'construction'),('construction',3,1,'construction'),('ret',3,1,'ret'),('furn',0,1,'furn'),('furn',3,1,'furn'),('life',0,1,'life'),('life',3,1,'life'),('non-profit',0,2,'non-profit'),('non-profit',3,1,'non-profit'),('low',0,1,'low'),('low',3,1,'low'),('income',0,1,'income'),('income',3,1,'income'),('own',3,1,'own'),('account',0,1,'account'),('account',3,1,'account'),('except',0,1,'except'),('except',3,1,'except'),('ski',0,1,'ski'),('ski',3,1,'ski'),('independent',0,1,'independent'),('independent',3,1,'independent'),('commercial',4,1,'commercial'),('property',4,31,'property'),('lessor',0,18,'lessor'),('lessor',4,17,'lessor'),('lessors',4,2,'lessors'),('real',4,18,'real'),('management',4,11,'management'),('rental',4,1,'rental'),('estate',4,4,'estate'),('freight',0,1,'freight'),('freight',4,1,'freight'),('transportation',0,1,'transportation'),('transportation',4,1,'transportation'),('arrangement',0,1,'arrangement'),('arrangement',4,1,'arrangement'),('agent',4,3,'agent'),('manager',4,3,'manager'),('ret',4,2,'ret'),('new',0,2,'new'),('new',4,1,'new'),('used',4,2,'used'),('automobiles',4,2,'automobiles'),('passenger',0,1,'passenger'),('passenger',4,1,'passenger'),('oil',0,14,'oil'),('oil',4,14,'oil'),('properties',0,4,'properties'),('properties',4,4,'properties'),('managers',4,1,'managers'),('apartment',5,8,'apartment'),('building',5,6,'building'),('operator',5,7,'operator'),('complex',5,3,'complex'),('management',5,23,'management'),('apt',5,1,'apt'),('managment',5,1,'managment'),('commercial',5,2,'commercial'),('real',5,997,'real'),('estate',5,996,'estate'),('agent',5,931,'agent'),('manager',5,911,'manager'),('condominium',0,1,'condominium'),('condominium',5,1,'condominium'),('property',5,6,'property'),('dentist',0,1,'dentist'),('dentist',5,1,'dentist'),('ice',0,1,'ice'),('ice',5,1,'ice'),('rink',0,1,'rink'),('rink',5,1,'rink'),('investor',5,1,'investor'),('mail',0,1,'mail'),('mail',5,1,'mail'),('order',0,1,'order'),('order',5,1,'order'),('motel',5,5,'motel'),('operates',5,4,'operates'),('agency',0,38,'agency'),('agency',5,38,'agency'),('mortgage',5,3,'mortgage'),('broker',5,6,'broker'),('managemen',0,1,'managemen'),('managemen',5,1,'managemen'),('insurance',5,4,'insurance'),('managers',5,1,'managers'),('training',0,1,'training'),('training',5,1,'training'),('schoo',0,1,'schoo'),('schoo',5,1,'schoo'),('manage',5,1,'manage'),('accounting',0,1,'accounting'),('accounting',5,1,'accounting'),('auditing',0,1,'auditing'),('auditing',5,1,'auditing'),('bookkeepi',0,1,'bookkeepi'),('bookkeepi',5,1,'bookkeepi'),('amusement',5,1,'amusement'),('recreation',5,2,'recreation'),('services',5,14,'services'),('animal',0,1,'animal'),('animal',5,1,'animal'),('appraiser',0,1,'appraiser'),('appraiser',5,1,'appraiser'),('and',5,1,'and'),('liquidator',0,1,'liquidator'),('liquidator',5,1,'liquidator'),('business',5,10,'business'),('depository',0,1,'depository'),('depository',5,1,'depository'),('banking',0,1,'banking'),('banking',5,1,'banking'),('dwelling',5,1,'dwelling'),('hotel',5,4,'hotel'),('operation',5,4,'operation'),('legal',5,1,'legal'),('office',5,1,'office'),('managem',0,1,'managem'),('managem',5,1,'managem'),('loan',0,2,'loan'),('loan',5,2,'loan'),('consulting',0,19,'consulting'),('consulting',5,18,'consulting'),('service',0,18,'service'),('service',5,18,'service'),('membership',5,1,'membership'),('sport',5,1,'sport'),('misc',0,4,'misc'),('misc',5,4,'misc'),('personal',5,1,'personal'),('mobile',0,50,'mobile'),('mobile',5,1,'mobile'),('home',5,1,'home'),('site',5,1,'site'),('banker',0,1,'banker'),('banker',5,1,'banker'),('correspondent',0,1,'correspondent'),('correspondent',5,1,'correspondent'),('mortgages',0,1,'mortgages'),('mortgages',5,1,'mortgages'),('nonresidential',5,1,'nonresidential'),('opera',0,1,'opera'),('opera',5,1,'opera'),('investment',5,1,'investment'),('trust',0,1,'trust'),('trust',5,1,'trust'),('lessor',5,1,'lessor'),('ret',5,5,'ret'),('merchandise',5,2,'merchandise'),('new',5,1,'new'),('used',5,2,'used'),('automobiles',5,2,'automobiles'),('rooming',0,1,'rooming'),('rooming',5,1,'rooming'),('boarding',5,1,'boarding'),('house',0,3,'house'),('house',5,3,'house'),('single-family',0,2,'single-family'),('single-family',5,2,'single-family'),('construct',0,2,'construct'),('construct',5,2,'construct'),('subdivider',5,5,'subdivider'),('developer',5,5,'developer'),('whol',0,1,'whol'),('whol',5,1,'whol'),('furniture',0,1,'furniture'),('furniture',5,1,'furniture'),('mgr',0,5,'mgr'),('mgr',5,2,'mgr'),('mercha',0,1,'mercha'),('mercha',5,1,'mercha'),('drinking',5,1,'drinking'),('agents',5,13,'agents'),('commecial',0,1,'commecial'),('commecial',7,1,'commecial'),('building',7,2,'building'),('contractor',7,2,'contractor'),('for',7,2,'for'),('lease',0,1,'lease'),('lease',7,1,'lease'),('sale',0,1,'sale'),('sale',7,1,'sale'),('commercial',7,6,'commercial'),('real',7,1812,'real'),('estate',7,1809,'estate'),('operator',7,3,'operator'),('developer',7,94,'developer'),('homeowners',0,1,'homeowners'),('homeowners',7,1,'homeowners'),('association',0,1,'association'),('association',7,1,'association'),('land',0,55,'land'),('land',7,55,'land'),('developers',7,1817,'developers'),('mall',7,1,'mall'),('mechanical',0,1,'mechanical'),('mechanical',7,1,'mechanical'),('and',7,10,'and'),('fire',0,1,'fire'),('fire',7,1,'fire'),('protection',0,1,'protection'),('protection',7,1,'protection'),('contractors',0,1,'contractors'),('contractors',7,1,'contractors'),('operates',7,2,'operates'),('subdivider',7,63,'subdivider'),('owns',7,1,'owns'),('manages',0,1,'manages'),('manages',7,1,'manages'),('congregate',7,1,'congregate'),('care',7,1,'care'),('facilities',0,1,'facilities'),('facilities',7,1,'facilities'),('property',7,5,'property'),('development',0,12,'development'),('development',7,12,'development'),('developement',0,1,'developement'),('developement',7,1,'developement'),('management',7,5,'management'),('hotel',7,4,'hotel'),('brokerage',0,1,'brokerage'),('brokerage',7,1,'brokerage'),('firm',0,1,'firm'),('firm',7,1,'firm'),('broker',7,1,'broker'),('golf',0,4,'golf'),('golf',7,4,'golf'),('course',0,4,'course'),('course',7,4,'course'),('restaurant',0,1,'restaurant'),('restaurant',7,1,'restaurant'),('leasing',0,1,'leasing'),('leasing',7,1,'leasing'),('owner',7,1,'owner'),('company',7,1,'company'),('retirement',7,1,'retirement'),('also',0,1,'also'),('also',7,1,'also'),('low-income',0,1,'low-income'),('low-income',7,1,'low-income'),('hou',0,1,'hou'),('hou',7,1,'hou'),('self-administered',0,1,'self-administered'),('self-administered',7,1,'self-administered'),('self-managed',0,1,'self-managed'),('self-managed',7,1,'self-managed'),('investment',7,1,'investment'),('motel',7,3,'motel'),('operation',7,1,'operation'),('services',7,2,'services'),('membership',7,1,'membership'),('sports',0,1,'sports'),('sports',7,1,'sports'),('club',0,2,'club'),('club',7,2,'club'),('ret',7,1,'ret'),('sport',7,1,'sport'),('physical',7,1,'physical'),('fitness',7,1,'fitness'),('faclty',7,1,'faclty'),('estat',0,1,'estat'),('estat',7,1,'estat'),('public',0,3,'public'),('public',7,3,'public'),('amusement',7,1,'amusement'),('recre',7,1,'recre'),('trailer',0,1,'trailer'),('trailer',7,1,'trailer'),('park',0,1,'park'),('park',7,1,'park'),('agent',7,12,'agent'),('manager',7,10,'manager'),('surety',0,1,'surety'),('surety',7,1,'surety'),('insurance',7,1,'insurance'),('carrier',0,1,'carrier'),('carrier',7,1,'carrier'),('esta',0,1,'esta'),('esta',7,1,'esta'),('companies',0,46,'companies'),('companies',7,46,'companies'),('mobile',7,49,'mobile'),('homes-park',0,48,'homes-park'),('homes-park',7,48,'homes-park'),('management-commercial',0,1,'management-commercial'),('management-commercial',7,1,'management-commercial'),('residential',7,7,'residential'),('community',7,1,'community'),('industrial',7,2,'industrial'),('builder',7,2,'builder'),('sales',0,1,'sales'),('sales',7,1,'sales'),('homes',0,1,'homes'),('homes',7,1,'homes'),('home',7,1,'home'),('parks',7,1,'parks'),('subdividers',7,2,'subdividers'),('non-profit',7,1,'non-profit'),('lender',0,1,'lender'),('lender',7,1,'lender'),('operate',0,1,'operate'),('operate',7,1,'operate'),('comm',0,1,'comm'),('comm',7,1,'comm'),('mngr',0,1,'mngr'),('mngr',7,1,'mngr'),('construction',7,3,'construction'),('investor',7,2,'investor'),('mgr',7,3,'mgr'),('rea',0,1,'rea'),('rea',7,1,'rea'),('consulting',7,1,'consulting'),('nonresidential',7,1,'nonresidential'),('mgm',0,1,'mgm'),('mgm',7,1,'mgm'),('single-famil',0,1,'single-famil'),('single-famil',7,1,'single-famil'),('water',7,1,'water'),('sewer',0,1,'sewer'),('sewer',7,1,'sewer'),('utility',0,1,'utility'),('utility',7,1,'utility'),('yacht',0,1,'yacht'),('yacht',7,1,'yacht');

--
-- Table structure for table `idx_unavailable`
--

CREATE TABLE `idx_unavailable` (
  `idx_unavailable` int(11) NOT NULL auto_increment,
  `link_id` int(11) default NULL,
  `url` varchar(255) collate latin1_general_ci default NULL,
  `who_is` varchar(255) collate latin1_general_ci default NULL,
  `note` text collate latin1_general_ci,
  `date` datetime default NULL,
  PRIMARY KEY  (`idx_unavailable`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `idx_unavailable`
--


--
-- Table structure for table `idx_unavailable_latest`
--

CREATE TABLE `idx_unavailable_latest` (
  `idx_link` int(11) default NULL,
  `record_execution` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `idx_unavailable_latest`
--


--
-- Table structure for table `idx_votes`
--

CREATE TABLE `idx_votes` (
  `link_id` mediumint(9) NOT NULL default '0',
  `ip` varchar(100) collate latin1_general_ci default NULL,
  `value` tinyint(4) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

INSERT INTO `idx_votes` VALUES (42698,'203.92.47.195',1);


