--
-- Host: directoryplus.biz    Database: director_ctor
-- ------------------------------------------------------


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

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


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

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

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



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

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

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


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

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

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


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

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

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

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

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

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

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

INSERT INTO `idx_category` VALUES (1,0,'Arts & Humanities','','folder.gif','','1',4,'','','1','0','','',0,'',0,0,0,0,0),(2,0,'Automobile industry','','folder.gif','','1',7,'','','1','0','','',0,'',0,0,0,0,0),(3,0,'Business & Economy','','folder.gif','','1',29,'','','1','0','','',0,'',0,0,0,0,0),(4,0,'Careers','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(5,0,'Clothing & Fashion','','folder.gif','','1',2,'','','1','0','','',0,'',0,0,0,0,0),(6,0,'Mass Communications','','folder.gif','','1',3,'','','1','0','','',0,'',0,0,0,0,0),(7,0,'Computers & IT','','folder.gif','','1',4,'','','1','0','','',0,'',0,0,0,0,0),(8,0,'Construction Services','','folder.gif','','1',12,'','','1','0','','',0,'',0,0,0,0,0),(9,0,'Dental Health','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(10,0,'Education & Training','','folder.gif','','1',3,'','','1','0','','',0,'',0,0,0,0,0),(11,0,'Employment  ','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(12,0,'Gifts','','folder.gif','','1',2,'','','1','0','','',0,'',0,0,0,0,0),(13,0,'Hardware & Software','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(14,0,'Health & fitness','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(15,0,'Healthcare ','','folder.gif','','1',35,'','','1','0','','',0,'',0,0,0,0,0),(16,0,'Heating and Air Conditioning','','folder.gif','','1',11,'','','1','0','','',0,'',0,0,0,0,0),(17,0,'Home & Garden','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(18,0,'Home Improvement ','','folder.gif','','1',203,'','','1','0','','',0,'',0,0,0,0,0),(19,0,'Hotels & Motels','','folder.gif','','1',5,'','','1','0','','',0,'',0,0,0,0,0),(20,0,'Insurance','','folder.gif','','1',11,'','','1','0','','',0,'',0,0,0,0,0),(21,0,'Law & Legal','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(22,0,'Lawyers & Attorneys','','folder.gif','','1',40,'','','1','0','','',0,'',0,0,0,0,0),(23,0,'Lifestyle & Society','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(24,0,'Medicine & Surgery','','folder.gif','','1',2,'','','1','0','','',0,'',0,0,0,0,0),(25,0,'Finance & Investment','','folder.gif','','1',2,'','','1','0','','',0,'',0,0,0,0,0),(26,0,'News & Media','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(27,0,'Plumbing Contractors','','folder.gif','','1',5,'','','1','0','','',0,'',0,0,0,0,0),(28,0,'Real Estate & Property','','folder.gif','','1',5,'','','1','0','','',0,'',0,0,0,0,0),(29,0,'Science ','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(30,0,'SEO & SMO Services','','folder.gif','','1',13,'','','1','0','','',0,'',0,0,0,0,0),(31,0,'Shopping and Sales','','folder.gif','','1',13,'','','1','0','','',0,'',0,0,0,0,0),(32,0,'Sports & Recreation','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(33,0,'Transportation Services','','folder.gif','','1',9,'','','1','0','','',0,'',0,0,0,0,0),(34,0,'Travel & Tour','','folder.gif','','1',4,'','','1','0','','',0,'',0,0,0,0,0),(35,0,'Weddings','','folder.gif','','1',4,'','','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,'Arts & Humanities','<a href=\"http://directoryplus.biz/arts-humanities/\" name=\"cat_1\" style=\"\">Arts & Humanities</a>',';0;'),(2,'Automobile industry','<a href=\"http://directoryplus.biz/automobile-industry/\" name=\"cat_2\" style=\"\">Automobile industry</a>',';0;'),(3,'Business & Economy','<a href=\"http://directoryplus.biz/business-economy/\" name=\"cat_3\" style=\"\">Business & Economy</a>',';0;'),(4,'Careers','<a href=\"http://directoryplus.biz/careers/\" name=\"cat_4\" style=\"\">Careers</a>',';0;'),(5,'Clothing & Fashion','<a href=\"http://directoryplus.biz/clothing-fashion/\" name=\"cat_5\" style=\"\">Clothing & Fashion</a>',';0;'),(6,'Mass Communications','<a href=\"http://directoryplus.biz/mass-communications/\" name=\"cat_6\" style=\"\">Mass Communications</a>',';0;'),(7,'Computers & IT','<a href=\"http://directoryplus.biz/computers-it/\" name=\"cat_7\" style=\"\">Computers & IT</a>',';0;'),(8,'Construction Services','<a href=\"http://directoryplus.biz/construction-services/\" name=\"cat_8\" style=\"\">Construction Services</a>',';0;'),(9,'Dental Health','<a href=\"http://directoryplus.biz/dental-health/\" name=\"cat_9\" style=\"\">Dental Health</a>',';0;'),(10,'Education & Training','<a href=\"http://directoryplus.biz/education-training/\" name=\"cat_10\" style=\"\">Education & Training</a>',';0;'),(11,'Employment  ','<a href=\"http://directoryplus.biz/employment/\" name=\"cat_11\" style=\"\">Employment  </a>',';0;'),(12,'Gifts','<a href=\"http://directoryplus.biz/gifts/\" name=\"cat_12\" style=\"\">Gifts</a>',';0;'),(13,'Hardware & Software','<a href=\"http://directoryplus.biz/hardware-software/\" name=\"cat_13\" style=\"\">Hardware & Software</a>',';0;'),(14,'Health & fitness','<a href=\"http://directoryplus.biz/health-fitness/\" name=\"cat_14\" style=\"\">Health & fitness</a>',';0;'),(15,'Healthcare ','<a href=\"http://directoryplus.biz/healthcare/\" name=\"cat_15\" style=\"\">Healthcare </a>',';0;'),(16,'Heating and Air Conditioning','<a href=\"http://directoryplus.biz/heating-and-air-conditioning/\" name=\"cat_16\" style=\"\">Heating and Air Conditioning</a>',';0;'),(17,'Home & Garden','<a href=\"http://directoryplus.biz/home-garden/\" name=\"cat_17\" style=\"\">Home & Garden</a>',';0;'),(18,'Home Improvement ','<a href=\"http://directoryplus.biz/home-improvement/\" name=\"cat_18\" style=\"\">Home Improvement </a>',';0;'),(19,'Hotels & Motels','<a href=\"http://directoryplus.biz/hotels-motels/\" name=\"cat_19\" style=\"\">Hotels & Motels</a>',';0;'),(20,'Insurance','<a href=\"http://directoryplus.biz/insurance/\" name=\"cat_20\" style=\"\">Insurance</a>',';0;'),(21,'Law & Legal','<a href=\"http://directoryplus.biz/law-legal/\" name=\"cat_21\" style=\"\">Law & Legal</a>',';0;'),(22,'Lawyers & Attorneys','<a href=\"http://directoryplus.biz/lawyers-attorneys/\" name=\"cat_22\" style=\"\">Lawyers & Attorneys</a>',';0;'),(23,'Lifestyle & Society','<a href=\"http://directoryplus.biz/lifestyle-society/\" name=\"cat_23\" style=\"\">Lifestyle & Society</a>',';0;'),(24,'Medicine & Surgery','<a href=\"http://directoryplus.biz/medicine-surgery/\" name=\"cat_24\" style=\"\">Medicine & Surgery</a>',';0;'),(25,'Finance & Investment','<a href=\"http://directoryplus.biz/finance-investment/\" name=\"cat_25\" style=\"\">Finance & Investment</a>',';0;'),(26,'News & Media','<a href=\"http://directoryplus.biz/news-media/\" name=\"cat_26\" style=\"\">News & Media</a>',';0;'),(27,'Plumbing Contractors','<a href=\"http://directoryplus.biz/plumbing-contractors/\" name=\"cat_27\" style=\"\">Plumbing Contractors</a>',';0;'),(28,'Real Estate & Property','<a href=\"http://directoryplus.biz/real-estate-property/\" name=\"cat_28\" style=\"\">Real Estate & Property</a>',';0;'),(29,'Science ','<a href=\"http://directoryplus.biz/science/\" name=\"cat_29\" style=\"\">Science </a>',';0;'),(30,'SEO & SMO Services','<a href=\"http://directoryplus.biz/seo-smo-services/\" name=\"cat_30\" style=\"\">SEO & SMO Services</a>',';0;'),(31,'Shopping and Sales','<a href=\"http://directoryplus.biz/shopping-and-sales/\" name=\"cat_31\" style=\"\">Shopping and Sales</a>',';0;'),(32,'Sports & Recreation','<a href=\"http://directoryplus.biz/sports-recreation/\" name=\"cat_32\" style=\"\">Sports & Recreation</a>',';0;'),(33,'Transportation Services','<a href=\"http://directoryplus.biz/transportation-services/\" name=\"cat_33\" style=\"\">Transportation Services</a>',';0;'),(34,'Travel & Tour','<a href=\"http://directoryplus.biz/travel-tour/\" name=\"cat_34\" style=\"\">Travel & Tour</a>',';0;'),(35,'Weddings','<a href=\"http://directoryplus.biz/weddings/\" name=\"cat_35\" style=\"\">Weddings</a>',';0;');

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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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



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

CREATE TABLE `idx_favorites` (
  `favorite_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`favorite_id`)
) ENGINE=MyISAM 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 (208,'g',0,'2011-12-15'),(97,'g',0,'2011-12-15'),(104,'g',0,'2011-12-15'),(100,'g',0,'2011-12-15'),(95,'g',0,'2011-12-15'),(213,'g',0,'2011-12-15'),(210,'g',0,'2011-12-15'),(321,'g',0,'2011-12-15'),(323,'g',0,'2011-12-15'),(217,'g',0,'2011-12-15'),(38,'g',0,'2011-12-15'),(469,'g',0,'2011-12-15'),(467,'g',0,'2011-12-16'),(378,'g',0,'2011-12-16'),(264,'g',0,'2011-12-16'),(473,'g',0,'2011-12-16'),(151,'g',0,'2011-12-16'),(263,'g',0,'2011-12-16'),(54,'g',0,'2011-12-16'),(150,'g',0,'2011-12-16'),(280,'g',0,'2011-12-16'),(377,'g',0,'2011-12-16'),(394,'g',0,'2011-12-16'),(457,'g',0,'2011-12-16'),(459,'g',0,'2011-12-16'),(37,'g',0,'2011-12-16'),(167,'g',0,'2011-12-16'),(463,'g',0,'2011-12-18'),(468,'g',0,'2011-12-18'),(92,'g',0,'2011-12-20'),(108,'g',0,'2011-12-20'),(109,'g',0,'2011-12-20'),(214,'g',0,'2011-12-20'),(221,'g',0,'2011-12-20'),(223,'g',0,'2011-12-20'),(222,'g',0,'2011-12-20'),(101,'g',0,'2011-12-20'),(110,'g',0,'2011-12-20'),(205,'g',0,'2011-12-20'),(433,'g',0,'2011-12-20'),(474,'g',0,'2011-12-21'),(753,'g',0,'2012-02-04'),(574,'g',0,'2011-12-27'),(850,'g',0,'2012-02-04'),(752,'g',0,'2012-01-03'),(692,'g',0,'2012-01-03'),(750,'g',0,'2012-01-03'),(759,'g',0,'2012-01-03'),(764,'g',0,'2012-01-03'),(771,'g',0,'2012-01-03'),(772,'g',0,'2012-01-03'),(777,'g',0,'2012-01-03'),(768,'g',0,'2012-01-03'),(773,'g',0,'2012-01-03'),(657,'g',0,'2012-01-03'),(659,'g',0,'2012-01-03'),(660,'g',0,'2012-01-03'),(658,'g',0,'2012-01-03'),(661,'g',0,'2012-01-03'),(663,'g',0,'2012-01-03'),(662,'g',0,'2012-01-03'),(666,'g',0,'2012-02-13'),(664,'g',0,'2012-01-03'),(665,'g',0,'2012-01-03'),(690,'g',0,'2012-02-04'),(689,'g',0,'2012-02-04'),(694,'g',0,'2012-02-04'),(688,'g',0,'2012-02-04'),(712,'g',0,'2012-02-04'),(757,'g',0,'2012-02-04'),(748,'g',0,'2012-02-04'),(700,'g',0,'2012-02-04'),(769,'g',0,'2012-02-04'),(762,'g',0,'2012-02-04'),(786,'g',0,'2012-02-04'),(792,'g',0,'2012-02-04'),(697,'g',0,'2012-02-04'),(809,'g',0,'2012-02-04'),(810,'g',0,'2012-02-04'),(826,'g',0,'2012-01-03'),(827,'g',0,'2012-01-03'),(829,'g',0,'2012-01-03'),(788,'g',0,'2012-02-04'),(830,'g',0,'2012-01-03'),(758,'g',0,'2012-02-04'),(760,'g',0,'2012-02-04'),(763,'g',0,'2012-02-04'),(767,'g',0,'2012-02-04'),(782,'g',0,'2012-02-04'),(787,'g',0,'2012-02-04'),(859,'g',0,'2012-02-04'),(860,'g',0,'2012-01-05'),(864,'g',0,'2012-01-07'),(866,'g',0,'2012-01-07'),(862,'g',0,'2012-01-07'),(849,'g',0,'2012-01-07'),(846,'g',0,'2012-01-07'),(855,'g',0,'2012-03-01'),(711,'g',0,'2012-03-01'),(706,'g',0,'2012-02-09'),(698,'g',0,'2012-01-08'),(699,'g',0,'2012-03-01'),(751,'g',0,'2012-03-01'),(766,'g',0,'2012-03-01'),(776,'g',0,'2012-01-08'),(796,'g',0,'2012-02-08'),(814,'g',0,'2012-03-03'),(834,'g',0,'2012-03-03'),(807,'g',0,'2012-03-03'),(802,'g',0,'2012-02-08'),(695,'g',0,'2012-03-01'),(853,'g',0,'2012-03-01'),(701,'g',0,'2012-03-01'),(806,'g',0,'2012-01-09'),(867,'g',0,'2012-03-01'),(756,'g',0,'2012-01-09'),(724,'g',0,'2012-03-01'),(856,'g',0,'2012-03-01'),(836,'g',0,'2012-03-01'),(811,'g',0,'2012-03-01'),(770,'g',0,'2012-03-01'),(816,'g',0,'2012-01-11'),(761,'g',0,'2012-03-01'),(765,'g',0,'2012-03-01'),(714,'g',0,'2012-03-01'),(691,'g',0,'2012-03-01'),(781,'g',0,'2012-03-01'),(880,'g',0,'2012-03-01'),(790,'g',0,'2012-03-01'),(775,'g',0,'2012-03-01'),(879,'g',0,'2012-03-01'),(818,'g',0,'2012-03-01'),(795,'g',0,'2012-03-01'),(863,'g',0,'2012-01-17'),(844,'g',0,'2012-02-20'),(754,'g',0,'2012-02-20'),(755,'g',0,'2012-02-20'),(824,'g',0,'2012-02-20'),(868,'g',0,'2012-01-19'),(888,'g',0,'2012-01-19'),(885,'g',0,'2012-01-19'),(875,'g',0,'2012-01-19'),(693,'g',0,'2012-03-01'),(713,'g',0,'2012-03-01'),(865,'g',0,'2012-01-20'),(779,'g',0,'2012-03-01'),(861,'g',0,'2012-03-01'),(696,'g',0,'2012-03-01'),(874,'g',0,'2012-03-01'),(825,'g',0,'2012-03-01'),(778,'g',0,'2012-03-01'),(876,'g',0,'2012-03-01'),(815,'g',0,'2012-03-01'),(871,'g',0,'2012-03-01'),(902,'g',0,'2012-03-01'),(900,'g',0,'2012-03-01'),(903,'g',0,'2012-03-01'),(905,'g',0,'2012-03-01'),(899,'g',0,'2012-03-01'),(904,'g',0,'2012-03-01'),(901,'g',0,'2012-03-01'),(893,'g',0,'2012-02-21'),(877,'g',0,'2012-01-22'),(886,'g',0,'2012-01-22'),(895,'g',0,'2012-02-29'),(831,'g',0,'2012-03-01'),(774,'g',0,'2012-03-01'),(840,'g',0,'2012-03-01'),(873,'g',0,'2012-01-24'),(897,'g',0,'2012-01-24'),(898,'g',0,'2012-01-24'),(908,'g',0,'2012-01-25'),(881,'g',0,'2012-01-25'),(896,'g',0,'2012-01-25'),(884,'g',0,'2012-01-25'),(894,'g',0,'2012-01-25'),(922,'g',0,'2012-01-26'),(804,'g',0,'2012-01-27'),(858,'g',0,'2012-03-01'),(854,'g',0,'2012-03-01'),(820,'g',0,'2012-01-27'),(803,'g',0,'2012-01-27'),(891,'g',0,'2012-03-01'),(869,'g',0,'2012-03-01'),(870,'g',0,'2012-03-01'),(793,'g',0,'2012-03-01'),(919,'g',0,'2012-03-01'),(960,'g',0,'2012-01-28'),(911,'g',0,'2012-01-28'),(953,'g',0,'2012-01-28'),(920,'g',0,'2012-03-01'),(959,'g',0,'2012-01-28'),(913,'g',0,'2012-03-01'),(1006,'g',0,'2012-01-28'),(1005,'g',0,'2012-01-28'),(1007,'g',0,'2012-01-28'),(1004,'g',0,'2012-01-28'),(1002,'g',0,'2012-01-28'),(1003,'g',0,'2012-01-28'),(1009,'g',0,'2012-01-28'),(1008,'g',0,'2012-01-28'),(1000,'g',0,'2012-01-28'),(1001,'g',0,'2012-01-29'),(909,'g',0,'2012-03-01'),(907,'g',0,'2012-03-01'),(906,'g',0,'2012-03-01'),(887,'g',0,'2012-03-01'),(1029,'g',0,'2012-03-01'),(1018,'g',0,'2012-03-01'),(1017,'g',0,'2012-03-01'),(1025,'g',0,'2012-03-01'),(917,'g',0,'2012-03-01'),(1031,'g',0,'2012-03-01'),(912,'g',0,'2012-03-01'),(910,'g',0,'2012-03-01'),(889,'g',0,'2012-01-31'),(890,'g',0,'2012-01-31'),(1081,'g',0,'2012-02-01'),(1075,'g',0,'2012-02-01'),(1083,'g',0,'2012-02-01'),(1078,'g',0,'2012-02-01'),(1012,'g',0,'2012-02-01'),(1082,'g',0,'2012-02-01'),(1080,'g',0,'2012-02-01'),(1076,'g',0,'2012-02-01'),(1074,'g',0,'2012-02-01'),(1077,'g',0,'2012-02-01'),(1023,'g',0,'2012-02-01'),(1022,'g',0,'2012-02-01'),(1015,'g',0,'2012-02-01'),(1114,'g',0,'2012-02-04'),(1108,'g',0,'2012-02-04'),(1106,'g',0,'2012-02-04'),(1112,'g',0,'2012-02-04'),(1107,'g',0,'2012-02-04'),(1111,'g',0,'2012-02-04'),(1113,'g',0,'2012-02-04'),(1109,'g',0,'2012-02-04'),(1115,'g',0,'2012-02-04'),(1110,'g',0,'2012-02-04'),(835,'g',0,'2012-02-04'),(749,'g',0,'2012-02-04'),(892,'g',0,'2012-02-04'),(872,'g',0,'2012-02-04'),(1026,'g',0,'2012-02-04'),(1024,'g',0,'2012-02-04'),(916,'g',0,'2012-02-04'),(921,'g',0,'2012-02-04'),(1019,'g',0,'2012-03-06'),(822,'g',0,'2012-02-04'),(878,'g',0,'2012-02-04'),(1028,'g',0,'2012-02-04'),(1013,'g',0,'2012-02-04'),(1021,'g',0,'2012-02-04'),(1016,'g',0,'2012-02-04'),(838,'g',0,'2012-02-04'),(823,'g',0,'2012-02-04'),(821,'g',0,'2012-02-04'),(1011,'g',0,'2012-02-04'),(1079,'g',0,'2012-02-04'),(1032,'g',0,'2012-02-04'),(1033,'g',0,'2012-02-04'),(1030,'g',0,'2012-02-04'),(1027,'g',0,'2012-02-04'),(1034,'g',0,'2012-02-04'),(842,'g',0,'2012-02-04'),(852,'g',0,'2012-02-04'),(1084,'g',0,'2012-02-04'),(785,'g',0,'2012-02-04'),(797,'g',0,'2012-02-04'),(789,'g',0,'2012-02-04'),(798,'g',0,'2012-02-04'),(1123,'g',0,'2012-02-11'),(1130,'g',0,'2012-02-11'),(1129,'g',0,'2012-02-11'),(1127,'g',0,'2012-02-11'),(735,'g',0,'2012-02-13'),(728,'g',0,'2012-02-13'),(736,'g',0,'2012-02-13'),(737,'g',0,'2012-02-13'),(732,'g',0,'2012-02-13'),(729,'g',0,'2012-02-13'),(734,'g',0,'2012-02-13'),(731,'g',0,'2012-02-13'),(730,'g',0,'2012-02-13'),(733,'g',0,'2012-02-13'),(682,'g',0,'2012-02-13'),(684,'g',0,'2012-02-13'),(679,'g',0,'2012-02-13'),(683,'g',0,'2012-02-13'),(702,'g',0,'2012-02-13'),(686,'g',0,'2012-02-13'),(687,'g',0,'2012-02-13'),(685,'g',0,'2012-02-13'),(681,'g',0,'2012-02-13'),(680,'g',0,'2012-02-13'),(740,'g',0,'2012-02-13'),(744,'g',0,'2012-02-13'),(741,'g',0,'2012-02-13'),(747,'g',0,'2012-02-13'),(742,'g',0,'2012-02-13'),(739,'g',0,'2012-02-13'),(738,'g',0,'2012-02-13'),(743,'g',0,'2012-02-13'),(745,'g',0,'2012-02-13'),(746,'g',0,'2012-02-13'),(670,'g',0,'2012-02-13'),(678,'g',0,'2012-02-13'),(675,'g',0,'2012-02-13'),(671,'g',0,'2012-02-13'),(673,'g',0,'2012-02-13'),(674,'g',0,'2012-02-13'),(669,'g',0,'2012-02-13'),(672,'g',0,'2012-02-13'),(676,'g',0,'2012-02-13'),(677,'g',0,'2012-02-13'),(667,'g',0,'2012-02-13'),(924,'g',0,'2012-02-13'),(929,'g',0,'2012-02-13'),(928,'g',0,'2012-02-13'),(926,'g',0,'2012-02-13'),(931,'g',0,'2012-02-13'),(930,'g',0,'2012-02-13'),(932,'g',0,'2012-02-13'),(927,'g',0,'2012-02-13'),(933,'g',0,'2012-02-13'),(925,'g',0,'2012-02-13'),(783,'g',0,'2012-02-13'),(851,'g',0,'2012-02-13'),(794,'g',0,'2012-02-13'),(791,'g',0,'2012-02-13'),(832,'g',0,'2012-02-13'),(837,'g',0,'2012-02-13'),(847,'g',0,'2012-02-13'),(819,'g',0,'2012-02-13'),(817,'g',0,'2012-02-13'),(726,'g',0,'2012-02-13'),(717,'g',0,'2012-02-13'),(719,'g',0,'2012-02-13'),(718,'g',0,'2012-02-13'),(722,'g',0,'2012-02-13'),(727,'g',0,'2012-02-13'),(723,'g',0,'2012-02-13'),(721,'g',0,'2012-02-13'),(720,'g',0,'2012-02-13'),(725,'g',0,'2012-02-13'),(704,'g',0,'2012-02-13'),(710,'g',0,'2012-02-13'),(716,'g',0,'2012-02-13'),(705,'g',0,'2012-02-13'),(707,'g',0,'2012-02-13'),(715,'g',0,'2012-02-13'),(703,'g',0,'2012-02-13'),(709,'g',0,'2012-02-13'),(708,'g',0,'2012-02-13'),(914,'g',0,'2012-02-13'),(915,'g',0,'2012-02-13'),(923,'g',0,'2012-02-13'),(1121,'g',0,'2012-02-13'),(813,'g',0,'2012-02-13'),(841,'g',0,'2012-02-13'),(805,'g',0,'2012-02-13'),(801,'g',0,'2012-02-13'),(1117,'g',0,'2012-02-14'),(1126,'g',0,'2012-02-14'),(1125,'g',0,'2012-02-15'),(1131,'g',0,'2012-02-15'),(1133,'g',0,'2012-02-15'),(1118,'g',0,'2012-02-19'),(1142,'g',0,'2012-02-21'),(1140,'g',0,'2012-02-21'),(1141,'g',0,'2012-02-21'),(1139,'g',0,'2012-02-23'),(943,'g',0,'2012-02-25'),(944,'g',0,'2012-02-25'),(940,'g',0,'2012-02-25'),(939,'g',0,'2012-02-25'),(935,'g',0,'2012-02-25'),(936,'g',0,'2012-02-25'),(938,'g',0,'2012-02-25'),(942,'g',0,'2012-02-25'),(937,'g',0,'2012-02-25'),(941,'g',0,'2012-02-25'),(949,'g',0,'2012-02-25'),(946,'g',0,'2012-02-25'),(947,'g',0,'2012-02-25'),(945,'g',0,'2012-02-25'),(948,'g',0,'2012-02-25'),(1071,'g',0,'2012-02-25'),(1070,'g',0,'2012-02-25'),(1069,'g',0,'2012-02-25'),(1072,'g',0,'2012-02-25'),(1073,'g',0,'2012-02-25'),(1116,'g',0,'2012-02-27'),(1143,'g',0,'2012-02-29'),(1137,'g',0,'2012-02-29'),(1138,'g',0,'2012-02-29'),(1144,'g',0,'2012-02-29'),(857,'g',0,'2012-03-01'),(848,'g',0,'2012-03-01'),(1020,'g',0,'2012-03-01'),(1014,'g',0,'2012-03-01'),(1124,'g',0,'2012-03-01'),(1128,'g',0,'2012-03-01'),(1122,'g',0,'2012-03-01'),(1120,'g',0,'2012-03-01'),(1132,'g',0,'2012-03-01'),(1105,'g',0,'2012-03-01'),(1102,'g',0,'2012-03-01'),(1103,'g',0,'2012-03-01'),(1101,'g',0,'2012-03-01'),(1104,'g',0,'2012-03-01'),(1061,'g',0,'2012-03-01'),(1060,'g',0,'2012-03-01'),(1063,'g',0,'2012-03-01'),(1062,'g',0,'2012-03-01'),(1064,'g',0,'2012-03-01'),(1065,'g',0,'2012-03-01'),(1059,'g',0,'2012-03-01'),(1066,'g',0,'2012-03-01'),(1068,'g',0,'2012-03-01'),(1067,'g',0,'2012-03-01'),(1147,'g',0,'2012-03-01'),(1148,'g',0,'2012-03-01'),(1044,'g',0,'2012-03-01'),(1043,'g',0,'2012-03-01'),(1042,'g',0,'2012-03-01'),(1039,'g',0,'2012-03-01'),(1040,'g',0,'2012-03-01'),(1145,'g',0,'2012-03-01'),(1046,'g',0,'2012-03-01'),(1047,'g',0,'2012-03-01'),(1045,'g',0,'2012-03-01'),(1041,'g',0,'2012-03-01'),(1048,'g',0,'2012-03-01'),(1146,'g',0,'2012-03-01'),(918,'g',0,'2012-03-01'),(1149,'g',0,'2012-03-01'),(1150,'g',0,'2012-03-02'),(1058,'g',0,'2012-03-04'),(1057,'g',0,'2012-03-04'),(1051,'g',0,'2012-03-04'),(1056,'g',0,'2012-03-04'),(1050,'g',0,'2012-03-04'),(1049,'g',0,'2012-03-04'),(1052,'g',0,'2012-03-04'),(1053,'g',0,'2012-03-04'),(1054,'g',0,'2012-03-04'),(1055,'g',0,'2012-03-04'),(1036,'g',0,'2012-03-05'),(1035,'g',0,'2012-03-05'),(1037,'g',0,'2012-03-05'),(1093,'g',0,'2012-03-05'),(1094,'g',0,'2012-03-05'),(1092,'g',0,'2012-03-05'),(1095,'g',0,'2012-03-05'),(1099,'g',0,'2012-03-05'),(1098,'g',0,'2012-03-05'),(1097,'g',0,'2012-03-05'),(1096,'g',0,'2012-03-05'),(1100,'g',0,'2012-03-05'),(1038,'g',0,'2012-03-05'),(1151,'g',0,'2012-03-05'),(1153,'g',0,'2012-03-05'),(1152,'g',0,'2012-03-06'),(1155,'g',0,'2012-03-07');

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

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

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


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

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

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

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

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

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

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


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

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

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


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

CREATE TABLE `idx_review` (
  `review_id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `link_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `review` text NOT NULL,
  `rating` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  `subject` varchar(100) DEFAULT NULL,
  `status` char(1) DEFAULT NULL,
  `username` varchar(20) DEFAULT NULL,
  `name` varchar(20) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`review_id`)
) ENGINE=MyISAM 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','directoryplus.biz'),(5,'site_url','http://directoryplus.biz'),(6,'email_address','india.colvert@gmail.com'),(7,'language_code','en_US'),(8,'theme_path','/home/director/public_html/themes/'),(9,'admin_template_path','/home/director/public_html/admin_tpl/'),(10,'plugin_path','/home/director/public_html/plugin/'),(12,'active_theme','_directoryplus'),(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`
--

INSERT INTO `idx_votes` VALUES (912,'203.92.47.195',5),(910,'203.92.47.195',3);


