--
-- Host: hahadirectory.com    Database: hahadire_indexu
-- ------------------------------------------------------


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

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

INSERT INTO `directory_save_data` VALUES (15,350401,807,1361,'http://hahadirectory.com/detail/1361/lawn-sprinklers-grand-rapids.html',17,'Home Improvement Services'),(16,350691,2867,1362,'http://hahadirectory.com/detail/1362/tile-flooring-dallas.html',17,'Home Improvement Services'),(17,350751,2626,1363,'http://hahadirectory.com/detail/1363/austin-criminal-defense-lawyer.html',21,'Lawyers'),(18,350801,2784,1364,'http://hahadirectory.com/detail/1364/floor-sweeper.html',17,'Home Improvement Services'),(19,350851,2789,1365,'http://hahadirectory.com/detail/1365/austin-pain-management-physicians.html',23,'Medicine'),(20,350901,2501,1366,'http://hahadirectory.com/detail/1366/auto-accident-lawyer-brooklyn.html',21,'Lawyers'),(21,351861,2790,1367,'http://hahadirectory.com/detail/1367/chronic-hyperventilation.html',14,'Healthcare Related'),(22,362482,2034,1368,'http://hahadirectory.com/detail/1368/auto-repair-nyc.html',1,'Automotive Services');

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

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

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



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

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

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


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

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

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


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

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

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

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

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

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

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

INSERT INTO `idx_category` VALUES (1,0,'Automotive Services','','folder.gif','','1',22,'','','1','0','','',0,'',0,0,0,0,0),(2,0,'Business Services','','folder.gif','','1',50,'','','1','0','','',0,'',0,0,0,0,0),(3,0,'Jobs & Careers','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(4,0,'Clothing & Style','','folder.gif','','1',5,'','','1','0','','',0,'',0,0,0,0,0),(5,0,'Communication & Technology','','folder.gif','','1',11,'','','1','0','','',0,'',0,0,0,0,0),(6,0,'Internet & Computer Services','','folder.gif','','1',10,'','','1','0','','',0,'',0,0,0,0,0),(7,0,'Construction and Contractors','','folder.gif','','1',47,'','','1','0','','',0,'',0,0,0,0,0),(8,0,'Dental Care','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(9,0,'Education & Research','','folder.gif','','1',10,'','','1','0','','',0,'',0,0,0,0,0),(10,0,'Employment Services','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(11,0,'Gift Baskets','','folder.gif','','1',7,'','','1','0','','',0,'',0,0,0,0,0),(12,0,'Hardware & Software Services','','folder.gif','','1',2,'','','1','0','','',0,'',0,0,0,0,0),(13,0,'Health & Medical','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(14,0,'Healthcare Related','','folder.gif','','1',100,'','','1','0','','',0,'',0,0,0,0,0),(15,0,'Air Conditioning & Heating','','folder.gif','','1',21,'','','1','0','','',0,'',0,0,0,0,0),(16,0,'Home & Garden Decor','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(17,0,'Home Improvement Services','','folder.gif','','1',263,'','','1','0','','',0,'',0,0,0,0,0),(18,0,'Hotels & Resorts','','folder.gif','','1',8,'','','1','0','','',0,'',0,0,0,0,0),(19,0,'Insurance Services','','folder.gif','','1',22,'','','1','0','','',0,'',0,0,0,0,0),(20,0,'Law & Politics','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(21,0,'Lawyers','','folder.gif','','1',104,'','','1','0','','',0,'',0,0,0,0,0),(22,0,'Lifestyle & Relationships','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(23,0,'Medicine','','folder.gif','','1',6,'','','1','0','','',0,'',0,0,0,0,0),(24,0,'Money & Finance','','folder.gif','','1',10,'','','1','0','','',0,'',0,0,0,0,0),(25,0,'News & Issues','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(26,0,'Plumbing','','folder.gif','','1',23,'','','1','0','','',0,'',0,0,0,0,0),(27,0,'Real Estate','','folder.gif','','1',15,'','','1','0','','',0,'',0,0,0,0,0),(28,0,'Science & Technology','','folder.gif','','1',6,'','','1','0','','',0,'',0,0,0,0,0),(29,0,'SEO & SMO','','folder.gif','','1',15,'','','1','0','','',0,'',0,0,0,0,0),(30,0,'Shopping and Fashion','','folder.gif','','1',27,'','','1','0','','',0,'',0,0,0,0,0),(31,0,'Games & Sports','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(32,0,'Transport & Freight Forwarding','','folder.gif','','1',30,'','','1','0','','',0,'',0,0,0,0,0),(33,0,'Travel & Vacations','','folder.gif','','1',8,'','','1','0','','',0,'',0,0,0,0,0),(34,0,'Wedding Accessories','','folder.gif','','1',5,'','','1','0','','',0,'',0,0,0,0,0),(35,0,'Arts ','','folder.gif','','1',8,'','','1','0','','',0,'',0,0,0,0,0);

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

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

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

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

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

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

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

INSERT INTO `idx_category_suggession` VALUES (1,29,'SEO India','If you are in need of the best backlinks for your website to bring in better results and more volume of visitors choose the best SEO services India.','2012-03-02 13:14:13');

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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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



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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `idx_pagerank` VALUES (117,'g',0,'2011-12-22'),(652,'g',0,'2011-12-22'),(1187,'g',0,'2011-12-22'),(1722,'g',0,'2011-12-22'),(20,'g',0,'2012-02-15'),(62,'g',0,'2012-02-06'),(68,'g',0,'2012-02-13'),(108,'g',0,'2012-02-06'),(100,'g',0,'2012-02-06'),(90,'g',0,'2012-02-13'),(164,'g',0,'2012-02-17'),(76,'g',0,'2012-02-15'),(178,'g',0,'2012-02-16'),(170,'g',0,'2012-02-15'),(181,'g',0,'2012-02-13'),(207,'g',0,'2012-02-15'),(11,'g',0,'2012-02-15'),(21,'g',0,'2012-02-16'),(28,'g',0,'2012-02-15'),(34,'g',0,'2012-02-16'),(51,'g',0,'2012-02-15'),(63,'g',0,'2012-02-15'),(65,'g',0,'2012-02-17'),(143,'g',0,'2012-02-17'),(193,'g',0,'2012-02-15'),(127,'g',0,'2012-02-06'),(1,'g',0,'2012-02-15'),(38,'g',0,'2012-02-17'),(61,'g',0,'2012-02-15'),(31,'g',0,'2012-02-13'),(40,'g',0,'2012-02-13'),(52,'g',0,'2012-02-17'),(42,'g',0,'2012-02-20'),(23,'g',0,'2012-02-15'),(64,'g',0,'2012-02-13'),(14,'g',0,'2012-02-18'),(106,'g',0,'2012-02-13'),(89,'g',0,'2012-02-13'),(80,'g',0,'2012-02-15'),(721,'g',0,'2012-02-16'),(43,'g',0,'2012-02-17'),(792,'g',0,'2012-02-15'),(814,'g',0,'2012-02-15'),(810,'g',0,'2012-02-15'),(578,'g',0,'2012-02-16'),(803,'g',0,'2012-02-16'),(279,'g',0,'2012-02-16'),(268,'g',0,'2012-02-13'),(257,'g',0,'2012-02-17'),(275,'g',0,'2012-02-13'),(653,'g',0,'2012-02-16'),(131,'g',0,'2012-02-16'),(534,'g',0,'2012-02-13'),(118,'g',0,'2012-02-15'),(104,'g',0,'2012-02-16'),(253,'g',0,'2012-02-20'),(91,'g',0,'2012-02-17'),(788,'g',0,'2012-02-18'),(83,'g',0,'2012-02-17'),(119,'g',0,'2012-02-15'),(137,'g',0,'2012-02-16'),(654,'g',0,'2012-02-16'),(186,'g',0,'2012-02-15'),(1069,'g',0,'2012-02-16'),(132,'g',0,'2012-02-15'),(86,'g',0,'2012-02-18'),(12,'g',0,'2012-02-16'),(138,'g',0,'2012-02-20'),(49,'g',0,'2012-02-16'),(833,'g',0,'2012-02-15'),(200,'g',0,'2012-02-13'),(160,'g',0,'2012-02-13'),(735,'g',0,'2012-02-15'),(187,'g',0,'2012-02-15'),(695,'g',0,'2012-02-13'),(406,'g',0,'2012-02-20'),(722,'g',0,'2012-02-15'),(398,'g',0,'2012-02-15'),(298,'g',0,'2012-02-16'),(3496,'g',0,'2012-01-08'),(4052,'g',0,'2012-01-08'),(2956,'g',0,'2012-01-08'),(5162,'g',0,'2012-01-08'),(1346,'g',0,'2012-01-08'),(811,'g',0,'2012-02-13'),(4607,'g',0,'2012-01-09'),(276,'g',0,'2012-02-18'),(2417,'g',0,'2012-01-09'),(123,'g',0,'2012-02-18'),(658,'g',0,'2012-01-09'),(2802,'g',0,'2012-01-09'),(1728,'g',0,'2012-01-09'),(2263,'g',0,'2012-01-09'),(1193,'g',0,'2012-01-09'),(4453,'g',0,'2012-01-09'),(3898,'g',0,'2012-01-09'),(3342,'g',0,'2012-01-09'),(5008,'g',0,'2012-01-09'),(1881,'g',0,'2012-01-09'),(204,'g',0,'2012-02-15'),(1676,'g',0,'2012-01-10'),(71,'g',0,'2012-02-15'),(2211,'g',0,'2012-01-10'),(1141,'g',0,'2012-01-10'),(3290,'g',0,'2012-01-10'),(2750,'g',0,'2012-01-10'),(3846,'g',0,'2012-01-10'),(4402,'g',0,'2012-01-10'),(4957,'g',0,'2012-01-10'),(70,'g',0,'2012-02-15'),(3845,'g',0,'2012-01-10'),(605,'g',0,'2012-02-15'),(1140,'g',0,'2012-01-10'),(2749,'g',0,'2012-01-10'),(2210,'g',0,'2012-01-10'),(3289,'g',0,'2012-01-10'),(4956,'g',0,'2012-01-10'),(4401,'g',0,'2012-01-10'),(393,'g',0,'2012-02-15'),(9,'g',0,'2012-02-15'),(10,'g',0,'2012-02-13'),(8,'g',0,'2012-02-18'),(6,'g',0,'2012-02-16'),(7,'g',0,'2012-02-15'),(397,'g',0,'2012-02-15'),(54,'g',0,'2012-02-18'),(13,'g',0,'2012-02-15'),(212,'g',0,'2012-02-15'),(290,'g',0,'2012-02-15'),(392,'g',0,'2012-02-16'),(15,'g',0,'2012-02-17'),(41,'g',0,'2012-02-13'),(541,'g',0,'2012-02-13'),(30,'g',0,'2012-02-13'),(1355,'g',0,'2012-01-11'),(502,'g',0,'2012-01-11'),(285,'g',0,'2012-01-11'),(152,'g',0,'2012-01-11'),(1222,'g',0,'2012-01-11'),(1757,'g',0,'2012-01-11'),(266,'g',0,'2012-02-15'),(46,'g',0,'2012-02-13'),(801,'g',0,'2012-02-18'),(203,'g',0,'2012-02-15'),(738,'g',0,'2012-02-15'),(581,'g',0,'2012-02-15'),(526,'g',0,'2012-02-18'),(292,'g',0,'2012-02-13'),(1061,'g',0,'2012-02-15'),(827,'g',0,'2012-02-15'),(281,'g',0,'2012-02-12'),(377,'g',0,'2012-02-15'),(912,'g',0,'2012-02-13'),(816,'g',0,'2012-02-16'),(1447,'g',0,'2012-01-11'),(1351,'g',0,'2012-01-11'),(2422,'g',0,'2012-01-11'),(2518,'g',0,'2012-01-11'),(1886,'g',0,'2012-01-11'),(196,'g',0,'2012-02-13'),(272,'g',0,'2012-02-16'),(327,'g',0,'2012-02-17'),(415,'g',0,'2012-02-13'),(109,'g',0,'2012-02-16'),(217,'g',0,'2012-02-22'),(53,'g',0,'2012-02-15'),(78,'g',0,'2012-02-15'),(17,'g',0,'2012-02-18'),(16,'g',0,'2012-02-13'),(81,'g',0,'2012-02-16'),(48,'g',0,'2012-02-15'),(18,'g',0,'2012-02-20'),(37,'g',0,'2012-02-16'),(101,'g',0,'2012-02-16'),(687,'g',0,'2012-01-11'),(1982,'g',0,'2012-01-11'),(1572,'g',0,'2012-01-11'),(820,'g',0,'2012-01-11'),(1037,'g',0,'2012-01-11'),(1049,'g',0,'2012-02-15'),(571,'g',0,'2012-02-15'),(1641,'g',0,'2012-01-11'),(514,'g',0,'2012-02-15'),(36,'g',0,'2012-02-15'),(1106,'g',0,'2012-02-15'),(592,'g',0,'2012-02-18'),(1584,'g',0,'2012-01-11'),(6276,'g',0,'2012-01-11'),(10235,'g',0,'2012-01-11'),(9099,'g',0,'2012-01-11'),(6837,'g',0,'2012-01-11'),(5717,'g',0,'2012-01-11'),(9666,'g',0,'2012-01-11'),(7402,'g',0,'2012-01-11'),(8532,'g',0,'2012-01-11'),(7967,'g',0,'2012-01-11'),(1127,'g',0,'2012-02-13'),(57,'g',0,'2012-02-13'),(1223,'g',0,'2012-01-12'),(4483,'g',0,'2012-01-12'),(1758,'g',0,'2012-01-12'),(688,'g',0,'2012-01-12'),(3928,'g',0,'2012-01-12'),(2832,'g',0,'2012-01-12'),(153,'g',0,'2012-01-12'),(2293,'g',0,'2012-01-12'),(3372,'g',0,'2012-01-12'),(5038,'g',0,'2012-01-12'),(189,'g',0,'2012-02-13'),(321,'g',0,'2012-02-13'),(1693,'g',0,'2012-01-13'),(4974,'g',0,'2012-01-13'),(3863,'g',0,'2012-01-13'),(2767,'g',0,'2012-01-13'),(3307,'g',0,'2012-01-13'),(1158,'g',0,'2012-01-13'),(4419,'g',0,'2012-01-13'),(623,'g',0,'2012-01-13'),(88,'g',0,'2012-01-13'),(2228,'g',0,'2012-01-13'),(10804,'g',0,'2012-01-14'),(296,'g',0,'2012-02-13'),(284,'g',0,'2012-02-15'),(507,'g',0,'2012-02-13'),(146,'g',0,'2012-02-15'),(172,'g',0,'2012-02-13'),(150,'g',0,'2012-02-15'),(375,'g',0,'2012-02-17'),(515,'g',0,'2012-02-16'),(1050,'g',0,'2012-01-15'),(73,'g',0,'2012-02-15'),(1070,'g',0,'2012-02-15'),(44,'g',0,'2012-02-15'),(22,'g',0,'2012-01-15'),(608,'g',0,'2012-02-17'),(579,'g',0,'2012-01-15'),(535,'g',0,'2012-02-18'),(60,'g',0,'2012-02-17'),(29,'g',0,'2012-02-15'),(35,'g',0,'2012-02-16'),(4,'g',0,'2012-02-15'),(55,'g',0,'2012-01-15'),(2,'g',0,'2012-02-15'),(69,'g',0,'2012-02-18'),(58,'g',0,'2012-02-15'),(33,'g',0,'2012-02-17'),(47,'g',0,'2012-02-17'),(277,'g',0,'2012-02-16'),(812,'g',0,'2012-02-16'),(614,'g',0,'2012-02-20'),(757,'g',0,'2012-02-15'),(804,'g',0,'2012-02-15'),(686,'g',0,'2012-02-15'),(79,'g',0,'2012-02-18'),(557,'g',0,'2012-01-15'),(269,'g',0,'2012-02-17'),(222,'g',0,'2012-02-15'),(151,'g',0,'2012-02-18'),(8408,'g',0,'2012-01-16'),(9542,'g',0,'2012-01-16'),(5593,'g',0,'2012-01-16'),(7278,'g',0,'2012-01-16'),(6152,'g',0,'2012-01-16'),(7843,'g',0,'2012-01-16'),(6713,'g',0,'2012-01-16'),(10111,'g',0,'2012-01-16'),(8975,'g',0,'2012-01-16'),(10680,'g',0,'2012-01-16'),(1755,'g',0,'2012-01-16'),(1220,'g',0,'2012-01-16'),(685,'g',0,'2012-01-16'),(2290,'g',0,'2012-01-16'),(2829,'g',0,'2012-01-16'),(3925,'g',0,'2012-01-16'),(12439,'g',0,'2012-01-16'),(11266,'g',0,'2012-01-16'),(14242,'g',0,'2012-01-16'),(11852,'g',0,'2012-01-16'),(15463,'g',0,'2012-01-16'),(16685,'g',0,'2012-01-16'),(13634,'g',0,'2012-01-16'),(16074,'g',0,'2012-01-16'),(14853,'g',0,'2012-01-16'),(13026,'g',0,'2012-01-16'),(87,'g',0,'2012-02-15'),(32,'g',0,'2012-01-16'),(27,'g',0,'2012-02-17'),(59,'g',0,'2012-02-15'),(199,'g',0,'2012-02-20'),(219,'g',0,'2012-02-15'),(197,'g',0,'2012-02-15'),(388,'g',0,'2012-01-16'),(255,'g',0,'2012-02-15'),(492,'g',0,'2012-02-15'),(1726,'g',0,'2012-01-17'),(121,'g',0,'2012-01-17'),(656,'g',0,'2012-01-17'),(1191,'g',0,'2012-01-17'),(2800,'g',0,'2012-01-17'),(3340,'g',0,'2012-01-17'),(2261,'g',0,'2012-01-17'),(3896,'g',0,'2012-01-17'),(4451,'g',0,'2012-01-17'),(5006,'g',0,'2012-01-17'),(1243,'g',0,'2012-01-17'),(696,'g',0,'2012-01-17'),(708,'g',0,'2012-01-17'),(161,'g',0,'2012-02-16'),(265,'g',0,'2012-01-17'),(800,'g',0,'2012-02-18'),(173,'g',0,'2012-02-18'),(174,'g',0,'2012-02-18'),(1231,'g',0,'2012-01-17'),(45,'g',0,'2012-01-17'),(297,'g',0,'2012-01-17'),(263,'g',0,'2012-01-17'),(282,'g',0,'2012-01-17'),(425,'g',0,'2012-01-17'),(26,'g',0,'2012-02-26'),(709,'g',0,'2012-02-16'),(3,'g',0,'2012-01-19'),(5,'g',0,'2012-01-19'),(509,'g',0,'2012-01-19'),(220,'g',0,'2012-01-19'),(136,'g',0,'2012-01-19'),(660,'g',0,'2012-01-19'),(125,'g',0,'2012-01-19'),(540,'g',0,'2012-01-19'),(533,'g',0,'2012-01-19'),(538,'g',0,'2012-01-19'),(85,'g',0,'2012-01-19'),(25,'g',0,'2012-01-19'),(24,'g',0,'2012-01-19'),(39,'g',0,'2012-01-19'),(72,'g',0,'2012-01-19'),(67,'g',0,'2012-01-19'),(93,'g',0,'2012-01-19'),(50,'g',0,'2012-02-23'),(315,'g',0,'2012-01-19'),(74,'g',0,'2012-02-20'),(56,'g',0,'2012-01-19'),(19,'g',0,'2012-02-23'),(84,'g',0,'2012-01-19'),(66,'g',0,'2012-01-19'),(142,'g',0,'2012-01-19'),(693,'g',0,'2012-01-19'),(158,'g',0,'2012-01-19'),(1065,'g',0,'2012-01-19'),(1441,'g',0,'2012-01-19'),(1058,'g',0,'2012-01-19'),(371,'g',0,'2012-01-19'),(530,'g',0,'2012-01-19'),(523,'g',0,'2012-01-19'),(1228,'g',0,'2012-01-19'),(906,'g',0,'2012-01-19'),(13482,'g',0,'2012-01-21'),(15923,'g',0,'2012-01-21'),(14701,'g',0,'2012-01-22'),(17786,'g',0,'2012-01-22'),(19044,'g',0,'2012-01-22'),(17160,'g',0,'2012-01-22'),(15312,'g',0,'2012-01-22'),(18415,'g',0,'2012-01-22'),(14090,'g',0,'2012-01-22'),(16534,'g',0,'2012-01-22'),(24924,'g',0,'2012-01-24'),(24241,'g',0,'2012-01-24'),(3926,'g',0,'2012-01-25'),(4045,'g',0,'2012-01-25'),(3370,'g',0,'2012-01-25'),(3442,'g',0,'2012-01-25'),(3998,'g',0,'2012-01-25'),(4053,'g',0,'2012-01-25'),(3298,'g',0,'2012-01-25'),(3489,'g',0,'2012-01-25'),(3854,'g',0,'2012-01-25'),(3497,'g',0,'2012-01-25'),(25610,'g',0,'2012-01-26'),(26302,'g',0,'2012-01-26'),(1976,'g',0,'2012-01-27'),(2673,'g',0,'2012-01-27'),(2664,'g',0,'2012-01-27'),(1763,'g',0,'2012-01-27'),(2128,'g',0,'2012-01-27'),(1593,'g',0,'2012-01-27'),(2135,'g',0,'2012-01-27'),(2298,'g',0,'2012-01-27'),(1600,'g',0,'2012-01-27'),(2512,'g',0,'2012-01-27'),(8810,'g',0,'2012-01-27'),(9008,'g',0,'2012-01-27'),(8441,'g',0,'2012-01-27'),(8509,'g',0,'2012-01-27'),(8941,'g',0,'2012-01-27'),(8795,'g',0,'2012-01-27'),(8373,'g',0,'2012-01-27'),(9076,'g',0,'2012-01-27'),(8940,'g',0,'2012-01-27'),(8374,'g',0,'2012-01-27'),(819,'g',0,'2012-01-27'),(4476,'g',0,'2012-01-27'),(5182,'g',0,'2012-01-27'),(5031,'g',0,'2012-01-27'),(4706,'g',0,'2012-01-27'),(5057,'g',0,'2012-01-27'),(4502,'g',0,'2012-01-27'),(707,'g',0,'2012-01-27'),(5393,'g',0,'2012-01-27'),(910,'g',0,'2012-01-27'),(4480,'g',0,'2012-01-27'),(5170,'g',0,'2012-01-27'),(4283,'g',0,'2012-01-27'),(1042,'g',0,'2012-01-27'),(681,'g',0,'2012-01-27'),(4615,'g',0,'2012-01-27'),(4627,'g',0,'2012-01-27'),(5261,'g',0,'2012-01-27'),(606,'g',0,'2012-01-27'),(5035,'g',0,'2012-01-27'),(831,'g',0,'2012-01-27'),(4838,'g',0,'2012-01-27'),(4151,'g',0,'2012-01-27'),(8249,'g',0,'2012-01-27'),(7299,'g',0,'2012-01-27'),(7863,'g',0,'2012-01-27'),(7864,'g',0,'2012-01-27'),(7684,'g',0,'2012-01-27'),(7851,'g',0,'2012-01-27'),(7298,'g',0,'2012-01-27'),(8416,'g',0,'2012-01-27'),(7956,'g',0,'2012-01-27'),(7391,'g',0,'2012-01-27'),(165,'g',0,'2012-01-27'),(105,'g',0,'2012-01-27'),(192,'g',0,'2012-01-27'),(169,'g',0,'2012-01-27'),(157,'g',0,'2012-01-27'),(102,'g',0,'2012-02-26'),(183,'g',0,'2012-01-27'),(103,'g',0,'2012-01-27'),(213,'g',0,'2012-01-27'),(26995,'g',0,'2012-01-27'),(12375,'g',0,'2012-01-27'),(11202,'g',0,'2012-01-27'),(11788,'g',0,'2012-01-27'),(9389,'g',0,'2012-01-27'),(9761,'g',0,'2012-01-27'),(9923,'g',0,'2012-01-27'),(9356,'g',0,'2012-01-28'),(9928,'g',0,'2012-01-28'),(9547,'g',0,'2012-01-28'),(9956,'g',0,'2012-01-28'),(9914,'g',0,'2012-01-28'),(9347,'g',0,'2012-01-28'),(9361,'g',0,'2012-01-28'),(6079,'g',0,'2012-01-28'),(4410,'g',0,'2012-01-28'),(5108,'g',0,'2012-01-28'),(5718,'g',0,'2012-01-28'),(5710,'g',0,'2012-01-28'),(5991,'g',0,'2012-01-28'),(4600,'g',0,'2012-01-28'),(5663,'g',0,'2012-01-28'),(6150,'g',0,'2012-01-28'),(6222,'g',0,'2012-01-28'),(5591,'g',0,'2012-01-28'),(5520,'g',0,'2012-01-28'),(6269,'g',0,'2012-01-28'),(5036,'g',0,'2012-01-28'),(5155,'g',0,'2012-01-28'),(4965,'g',0,'2012-01-28'),(5163,'g',0,'2012-01-28'),(4553,'g',0,'2012-01-28'),(4169,'g',0,'2012-01-28'),(4603,'g',0,'2012-01-28'),(4340,'g',0,'2012-01-28'),(4341,'g',0,'2012-01-28'),(4658,'g',0,'2012-01-28'),(4338,'g',0,'2012-01-28'),(4103,'g',0,'2012-01-28'),(4526,'g',0,'2012-01-28'),(4337,'g',0,'2012-01-28'),(4339,'g',0,'2012-01-28'),(1100,'g',0,'2012-01-28'),(917,'g',0,'2012-01-28'),(662,'g',0,'2012-01-28'),(678,'g',0,'2012-01-28'),(913,'g',0,'2012-01-28'),(1035,'g',0,'2012-01-28'),(1019,'g',0,'2012-01-28'),(728,'g',0,'2012-01-28'),(1090,'g',0,'2012-01-28'),(739,'g',0,'2012-01-28'),(4608,'g',0,'2012-01-28'),(807,'g',0,'2012-01-28'),(5834,'g',0,'2012-01-28'),(4481,'g',0,'2012-01-28'),(731,'g',0,'2012-01-28'),(928,'g',0,'2012-01-28'),(543,'g',0,'2012-01-28'),(1077,'g',0,'2012-01-28'),(545,'g',0,'2012-01-28'),(6006,'g',0,'2012-01-28'),(5449,'g',0,'2012-01-28'),(5448,'g',0,'2012-01-28'),(5768,'g',0,'2012-01-28'),(5636,'g',0,'2012-01-28'),(542,'g',0,'2012-01-28'),(1076,'g',0,'2012-01-28'),(544,'g',0,'2012-01-28'),(5447,'g',0,'2012-01-28'),(5450,'g',0,'2012-01-28'),(5451,'g',0,'2012-01-28'),(5713,'g',0,'2012-01-28'),(862,'g',0,'2012-01-28'),(673,'g',0,'2012-01-28'),(979,'g',0,'2012-01-28'),(666,'g',0,'2012-01-28'),(672,'g',0,'2012-01-28'),(639,'g',0,'2012-01-28'),(701,'g',0,'2012-01-28'),(27703,'g',0,'2012-01-28'),(2468,'g',0,'2012-01-28'),(2534,'g',0,'2012-01-28'),(2688,'g',0,'2012-01-28'),(2686,'g',0,'2012-01-28'),(2336,'g',0,'2012-01-28'),(2685,'g',0,'2012-01-28'),(2689,'g',0,'2012-01-28'),(2413,'g',0,'2012-01-28'),(2150,'g',0,'2012-01-28'),(2687,'g',0,'2012-01-28'),(1038,'g',0,'2012-01-28'),(626,'g',0,'2012-01-28'),(698,'g',0,'2012-01-28'),(667,'g',0,'2012-01-28'),(3819,'g',0,'2012-01-28'),(3241,'g',0,'2012-01-28'),(4319,'g',0,'2012-01-28'),(3292,'g',0,'2012-01-28'),(3263,'g',0,'2012-01-28'),(3735,'g',0,'2012-01-28'),(3763,'g',0,'2012-01-28'),(3797,'g',0,'2012-01-28'),(3848,'g',0,'2012-01-28'),(2149,'g',0,'2012-01-28'),(4291,'g',0,'2012-01-28'),(5737,'g',0,'2012-01-28'),(5612,'g',0,'2012-01-28'),(5590,'g',0,'2012-01-28'),(2148,'g',0,'2012-01-28'),(2147,'g',0,'2012-01-28'),(1998,'g',0,'2012-01-28'),(1877,'g',0,'2012-01-28'),(2146,'g',0,'2012-01-28'),(5512,'g',0,'2012-01-28'),(5511,'g',0,'2012-01-28'),(5725,'g',0,'2012-01-28'),(5816,'g',0,'2012-01-28'),(5948,'g',0,'2012-01-28'),(5586,'g',0,'2012-01-28'),(1614,'g',0,'2012-01-28'),(1932,'g',0,'2012-01-28'),(1615,'g',0,'2012-01-28'),(1801,'g',0,'2012-01-28'),(6070,'g',0,'2012-01-28'),(144,'g',0,'2012-01-28'),(120,'g',0,'2012-01-28'),(99,'g',0,'2012-01-28'),(124,'g',0,'2012-01-28'),(115,'g',0,'2012-01-28'),(145,'g',0,'2012-01-28'),(96,'g',0,'2012-01-28'),(280,'g',0,'2012-01-28'),(270,'g',0,'2012-01-28'),(95,'g',0,'2012-01-28'),(139,'g',0,'2012-01-28'),(9540,'g',0,'2012-01-28'),(9469,'g',0,'2012-01-28'),(9100,'g',0,'2012-01-28'),(9376,'g',0,'2012-01-28'),(10109,'g',0,'2012-01-28'),(9612,'g',0,'2012-01-28'),(9667,'g',0,'2012-01-28'),(9943,'g',0,'2012-01-28'),(10038,'g',0,'2012-01-28'),(1342,'g',0,'2012-01-28'),(1078,'g',0,'2012-01-28'),(9659,'g',0,'2012-01-28'),(1080,'g',0,'2012-01-28'),(1397,'g',0,'2012-01-28'),(1613,'g',0,'2012-01-28'),(1611,'g',0,'2012-01-28'),(1612,'g',0,'2012-01-28'),(1079,'g',0,'2012-01-28'),(1463,'g',0,'2012-01-28'),(1266,'g',0,'2012-01-29'),(3302,'g',0,'2012-01-29'),(267,'g',0,'2012-01-29'),(2845,'g',0,'2012-01-29'),(3251,'g',0,'2012-01-29'),(3278,'g',0,'2012-01-29'),(3268,'g',0,'2012-01-29'),(3174,'g',0,'2012-01-29'),(355,'g',0,'2012-01-29'),(2842,'g',0,'2012-01-29'),(251,'g',0,'2012-01-29'),(3305,'g',0,'2012-01-29'),(3231,'g',0,'2012-01-29'),(319,'g',0,'2012-01-29'),(3188,'g',0,'2012-01-29'),(3246,'g',0,'2012-01-29'),(3183,'g',0,'2012-01-29'),(3198,'g',0,'2012-01-29'),(3173,'g',0,'2012-01-29'),(3193,'g',0,'2012-01-29'),(329,'g',0,'2012-01-29'),(3192,'g',0,'2012-01-29'),(310,'g',0,'2012-01-29'),(370,'g',0,'2012-01-29'),(3175,'g',0,'2012-01-29'),(3124,'g',0,'2012-01-29'),(3306,'g',0,'2012-01-29'),(3191,'g',0,'2012-01-29'),(283,'g',0,'2012-01-29'),(114,'g',0,'2012-01-29'),(2184,'g',0,'2012-01-29'),(2162,'g',0,'2012-01-29'),(2656,'g',0,'2012-01-29'),(3218,'g',0,'2012-01-29'),(2723,'g',0,'2012-01-29'),(3195,'g',0,'2012-01-29'),(2701,'g',0,'2012-01-29'),(2213,'g',0,'2012-01-29'),(2752,'g',0,'2012-01-29'),(2679,'g',0,'2012-01-29'),(6524,'g',0,'2012-01-29'),(6533,'g',0,'2012-01-29'),(6538,'g',0,'2012-01-29'),(7126,'g',0,'2012-01-29'),(7094,'g',0,'2012-01-29'),(7099,'g',0,'2012-01-29'),(6371,'g',0,'2012-01-29'),(7085,'g',0,'2012-01-29'),(6932,'g',0,'2012-01-29'),(6718,'g',0,'2012-01-29'),(3473,'g',0,'2012-01-30'),(3405,'g',0,'2012-01-30'),(4315,'g',0,'2012-01-30'),(3759,'g',0,'2012-01-30'),(4029,'g',0,'2012-01-30'),(3337,'g',0,'2012-01-30'),(3894,'g',0,'2012-01-30'),(3893,'g',0,'2012-01-30'),(3338,'g',0,'2012-01-30'),(3961,'g',0,'2012-01-30'),(352,'g',0,'2012-01-30'),(358,'g',0,'2012-01-30'),(357,'g',0,'2012-01-30'),(359,'g',0,'2012-01-30'),(356,'g',0,'2012-01-30'),(353,'g',0,'2012-01-30'),(351,'g',0,'2012-01-30'),(354,'g',0,'2012-01-30'),(360,'g',0,'2012-01-30'),(350,'g',0,'2012-01-30'),(238,'g',0,'2012-01-30'),(239,'g',0,'2012-01-30'),(242,'g',0,'2012-01-30'),(237,'g',0,'2012-01-30'),(233,'g',0,'2012-01-30'),(235,'g',0,'2012-01-30'),(234,'g',0,'2012-01-30'),(241,'g',0,'2012-01-30'),(236,'g',0,'2012-01-30'),(240,'g',0,'2012-01-30'),(243,'g',0,'2012-01-31'),(246,'g',0,'2012-01-31'),(250,'g',0,'2012-01-31'),(252,'g',0,'2012-01-31'),(264,'g',0,'2012-01-31'),(248,'g',0,'2012-01-31'),(245,'g',0,'2012-01-31'),(249,'g',0,'2012-01-31'),(247,'g',0,'2012-01-31'),(244,'g',0,'2012-01-31'),(311,'g',0,'2012-01-31'),(317,'g',0,'2012-01-31'),(306,'g',0,'2012-01-31'),(313,'g',0,'2012-01-31'),(303,'g',0,'2012-01-31'),(316,'g',0,'2012-01-31'),(314,'g',0,'2012-01-31'),(302,'g',0,'2012-01-31'),(308,'g',0,'2012-01-31'),(300,'g',0,'2012-01-31'),(28420,'g',0,'2012-01-31'),(29148,'g',0,'2012-01-31'),(1588,'g',0,'2012-02-01'),(1564,'g',0,'2012-02-01'),(1582,'g',0,'2012-02-01'),(1583,'g',0,'2012-02-01'),(1458,'g',0,'2012-02-01'),(1637,'g',0,'2012-02-01'),(1573,'g',0,'2012-02-01'),(1236,'g',0,'2012-02-01'),(1233,'g',0,'2012-02-01'),(1578,'g',0,'2012-02-01'),(1514,'g',0,'2012-02-01'),(1563,'g',0,'2012-02-01'),(1208,'g',0,'2012-02-01'),(1617,'g',0,'2012-02-01'),(1562,'g',0,'2012-02-01'),(1632,'g',0,'2012-02-01'),(1654,'g',0,'2012-02-01'),(1207,'g',0,'2012-02-01'),(1565,'g',0,'2012-02-01'),(1581,'g',0,'2012-02-01'),(9955,'g',0,'2012-02-01'),(9541,'g',0,'2012-02-01'),(9390,'g',0,'2012-02-01'),(9594,'g',0,'2012-02-01'),(9957,'g',0,'2012-02-01'),(9027,'g',0,'2012-02-02'),(8823,'g',0,'2012-02-02'),(9388,'g',0,'2012-02-02'),(9893,'g',0,'2012-02-02'),(8974,'g',0,'2012-02-02'),(8759,'g',0,'2012-02-02'),(8460,'g',0,'2012-02-02'),(8541,'g',0,'2012-02-02'),(9108,'g',0,'2012-02-02'),(9326,'g',0,'2012-02-02'),(8407,'g',0,'2012-02-02'),(8821,'g',0,'2012-02-02'),(7330,'g',0,'2012-02-02'),(7842,'g',0,'2012-02-02'),(7629,'g',0,'2012-02-02'),(7411,'g',0,'2012-02-02'),(8194,'g',0,'2012-02-02'),(7690,'g',0,'2012-02-02'),(7976,'g',0,'2012-02-02'),(8255,'g',0,'2012-02-02'),(7895,'g',0,'2012-02-02'),(9379,'g',0,'2012-02-02'),(9386,'g',0,'2012-02-02'),(8254,'g',0,'2012-02-02'),(8819,'g',0,'2012-02-02'),(8537,'g',0,'2012-02-02'),(8812,'g',0,'2012-02-02'),(9104,'g',0,'2012-02-02'),(8247,'g',0,'2012-02-02'),(8633,'g',0,'2012-02-02'),(9675,'g',0,'2012-02-02'),(9200,'g',0,'2012-02-02'),(8216,'g',0,'2012-02-02'),(7651,'g',0,'2012-02-02'),(7641,'g',0,'2012-02-02'),(8206,'g',0,'2012-02-02'),(8292,'g',0,'2012-02-02'),(8781,'g',0,'2012-02-02'),(7727,'g',0,'2012-02-02'),(7748,'g',0,'2012-02-02'),(8771,'g',0,'2012-02-02'),(8313,'g',0,'2012-02-02'),(9671,'g',0,'2012-02-02'),(9767,'g',0,'2012-02-02'),(9946,'g',0,'2012-02-02'),(9953,'g',0,'2012-02-02'),(2130,'g',0,'2012-02-03'),(30621,'g',0,'2012-02-03'),(29880,'g',0,'2012-02-03'),(2164,'g',0,'2012-02-03'),(2185,'g',0,'2012-02-03'),(2179,'g',0,'2012-02-03'),(1920,'g',0,'2012-02-03'),(2206,'g',0,'2012-02-03'),(2404,'g',0,'2012-02-03'),(2166,'g',0,'2012-02-03'),(2030,'g',0,'2012-02-03'),(1902,'g',0,'2012-02-03'),(9447,'g',0,'2012-02-03'),(9915,'g',0,'2012-02-03'),(9905,'g',0,'2012-02-03'),(9995,'g',0,'2012-02-03'),(8880,'g',0,'2012-02-03'),(9348,'g',0,'2012-02-03'),(9426,'g',0,'2012-02-04'),(8859,'g',0,'2012-02-04'),(10244,'g',0,'2012-02-04'),(10110,'g',0,'2012-02-04'),(10163,'g',0,'2012-02-04'),(10564,'g',0,'2012-02-04'),(11171,'g',0,'2012-02-04'),(11629,'g',0,'2012-02-04'),(11150,'g',0,'2012-02-04'),(14789,'g',0,'2012-02-06'),(14178,'g',0,'2012-02-06'),(13570,'g',0,'2012-02-06'),(15400,'g',0,'2012-02-06'),(16011,'g',0,'2012-02-06'),(16622,'g',0,'2012-02-06'),(12962,'g',0,'2012-02-06'),(286,'g',0,'2012-02-11'),(430,'g',0,'2012-02-11'),(447,'g',0,'2012-02-11'),(446,'g',0,'2012-02-11'),(805,'g',0,'2012-02-11'),(431,'g',0,'2012-02-11'),(154,'g',0,'2012-02-11'),(309,'g',0,'2012-02-11'),(374,'g',0,'2012-02-11'),(168,'g',0,'2012-02-11'),(176,'g',0,'2012-02-11'),(195,'g',0,'2012-02-12'),(256,'g',0,'2012-02-12'),(133,'g',0,'2012-02-12'),(1004,'g',0,'2012-02-12'),(1005,'g',0,'2012-02-12'),(699,'g',0,'2012-02-12'),(724,'g',0,'2012-02-12'),(703,'g',0,'2012-02-12'),(650,'g',0,'2012-02-12'),(208,'g',0,'2012-02-12'),(651,'g',0,'2012-02-12'),(702,'g',0,'2012-02-12'),(116,'g',0,'2012-02-12'),(205,'g',0,'2012-02-13'),(278,'g',0,'2012-02-13'),(419,'g',0,'2012-02-13'),(418,'g',0,'2012-02-13'),(428,'g',0,'2012-02-13'),(780,'g',0,'2012-02-13'),(781,'g',0,'2012-02-13'),(978,'g',0,'2012-02-13'),(826,'g',0,'2012-02-14'),(743,'g',0,'2012-02-14'),(706,'g',0,'2012-02-14'),(110,'g',0,'2012-02-14'),(484,'g',0,'2012-02-14'),(742,'g',0,'2012-02-14'),(111,'g',0,'2012-02-14'),(697,'g',0,'2012-02-15'),(705,'g',0,'2012-02-15'),(736,'g',0,'2012-02-15'),(148,'g',0,'2012-02-15'),(679,'g',0,'2012-02-15'),(384,'g',0,'2012-02-15'),(385,'g',0,'2012-02-15'),(704,'g',0,'2012-02-15'),(82,'g',0,'2012-02-15'),(410,'g',0,'2012-02-15'),(411,'g',0,'2012-02-15'),(184,'g',0,'2012-02-15'),(180,'g',0,'2012-02-16'),(191,'g',0,'2012-02-16'),(134,'g',0,'2012-02-16'),(420,'g',0,'2012-02-17'),(421,'g',0,'2012-02-17'),(260,'g',0,'2012-02-17'),(720,'g',0,'2012-02-17'),(825,'g',0,'2012-02-17'),(636,'g',0,'2012-02-17'),(824,'g',0,'2012-02-17'),(791,'g',0,'2012-02-17'),(790,'g',0,'2012-02-17'),(924,'g',0,'2012-02-17'),(637,'g',0,'2012-02-17'),(273,'g',0,'2012-02-17'),(128,'g',0,'2012-02-18'),(122,'g',0,'2012-02-18'),(129,'g',0,'2012-02-18'),(396,'g',0,'2012-02-18'),(785,'g',0,'2012-02-18'),(784,'g',0,'2012-02-19'),(872,'g',0,'2012-02-20'),(778,'g',0,'2012-02-20'),(765,'g',0,'2012-02-20'),(717,'g',0,'2012-02-20'),(764,'g',0,'2012-02-20'),(663,'g',0,'2012-02-20'),(716,'g',0,'2012-02-20'),(190,'g',0,'2012-02-20'),(254,'g',0,'2012-02-20'),(873,'g',0,'2012-02-20'),(793,'g',0,'2012-02-20'),(661,'g',0,'2012-02-20'),(680,'g',0,'2012-02-20'),(748,'g',0,'2012-02-20'),(865,'g',0,'2012-02-21'),(864,'g',0,'2012-02-21'),(956,'g',0,'2012-02-21'),(749,'g',0,'2012-02-21'),(740,'g',0,'2012-02-21'),(741,'g',0,'2012-02-21'),(210,'g',0,'2012-02-21'),(949,'g',0,'2012-02-21'),(753,'g',0,'2012-02-21'),(948,'g',0,'2012-02-21'),(911,'g',0,'2012-02-21'),(752,'g',0,'2012-02-21'),(159,'g',0,'2012-02-22'),(141,'g',0,'2012-02-22'),(646,'g',0,'2012-02-22'),(829,'g',0,'2012-02-22'),(1123,'g',0,'2012-02-25'),(1086,'g',0,'2012-02-26'),(1087,'g',0,'2012-02-26'),(1128,'g',0,'2012-02-26'),(1129,'g',0,'2012-02-26'),(1259,'g',0,'2012-02-27'),(92,'g',0,'2012-02-27'),(399,'g',0,'2012-02-28'),(989,'g',0,'2012-03-01'),(1333,'g',0,'2012-03-01'),(963,'g',0,'2012-03-01'),(75,'g',0,'2012-03-01'),(126,'g',0,'2012-03-01'),(485,'g',0,'2012-03-02'),(957,'g',0,'2012-03-02'),(465,'g',0,'2012-03-02'),(725,'g',0,'2012-03-03'),(891,'g',0,'2012-03-03'),(925,'g',0,'2012-03-03'),(931,'g',0,'2012-03-03'),(933,'g',0,'2012-03-03'),(937,'g',0,'2012-03-03'),(737,'g',0,'2012-03-03'),(1301,'g',0,'2012-03-03'),(935,'g',0,'2012-03-03'),(1318,'g',0,'2012-03-03'),(1095,'g',0,'2012-03-03'),(1317,'g',0,'2012-03-03'),(823,'g',0,'2012-03-03'),(429,'g',0,'2012-03-03'),(907,'g',0,'2012-03-04'),(927,'g',0,'2012-03-04'),(869,'g',0,'2012-03-04'),(779,'g',0,'2012-03-04');

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

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

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


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

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

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

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

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

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

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


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

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

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

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

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

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

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

INSERT INTO `idx_plugin` VALUES (1,'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 NOT NULL,
  `rating` tinyint(3) unsigned NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `subject` varchar(100) default NULL,
  `status` char(1) default NULL,
  `username` varchar(20) default NULL,
  `name` varchar(20) default NULL,
  `email` varchar(100) default NULL,
  PRIMARY KEY  (`review_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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



