--
-- Host: replistingz.com    Database: replisti_rep
-- ------------------------------------------------------


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

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

INSERT INTO `idx_category` VALUES (1,0,'Arts & Music','','folder.gif','','1',15,'','','0','0','','',0,'',0,0,0,0,0),(2,0,'Auto Industry','','folder.gif','','1',40,'','','0','0','','',0,'',0,0,0,0,0),(3,0,'Economy & Business','','folder.gif','','1',148,'','','0','0','','',0,'',0,0,0,0,0),(4,0,'Careers & Job Search','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(5,0,'Clothing Accessories','','folder.gif','','1',10,'','','0','0','','',0,'',0,0,0,0,0),(6,0,'Communications Services','','folder.gif','','1',26,'','','0','0','','',0,'',0,0,0,0,0),(7,0,'Computer Services','','folder.gif','','1',18,'','','0','0','','',0,'',0,0,0,0,0),(8,0,'Building & Construction','','folder.gif','','1',74,'','','0','0','','',0,'',0,0,0,0,0),(9,0,'Dental','','folder.gif','','1',38,'','','0','0','','',0,'',0,0,0,0,0),(10,0,'Educational Resources','','folder.gif','','1',23,'','','0','0','','',0,'',0,0,0,0,0),(11,0,'Recruitment Services','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(12,0,'Gifts & Flowers','','folder.gif','','1',25,'','','0','0','','',0,'',0,0,0,0,0),(13,0,'Hardware & Software Resources','','folder.gif','','1',10,'','','0','0','','',0,'',0,0,0,0,0),(14,0,'Medical & Health','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(15,0,'Healthcare Management','','folder.gif','','1',162,'','','0','0','','',0,'',0,0,0,0,0),(16,0,'Air Conditioning, Heating & Ventilating','','folder.gif','','1',59,'','','0','0','','',0,'',0,0,0,0,0),(17,0,'Family ,Home & Garden','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(18,0,'Home Improvement & Interiors','','folder.gif','','1',316,'','','0','0','','',0,'',0,0,0,0,0),(19,0,'Hotels & Restaurants','','folder.gif','','1',66,'','','0','0','','',0,'',0,0,0,0,0),(20,0,'Insurance Agents and Companies','','folder.gif','','1',34,'','','0','0','','',0,'',0,0,0,0,0),(21,0,'Law & Legal Services','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(22,0,'Lawyers & Legal Consultants','','folder.gif','','1',165,'','','0','0','','',0,'',0,0,0,0,0),(24,0,'Lifestyle & People','','folder.gif','','1',3,'','','0','0','','',0,'',0,0,0,0,0),(25,0,'Medicine & Medical Services','','folder.gif','','1',11,'','','0','0','','',0,'',0,0,0,0,0),(26,0,'Finance','','folder.gif','','1',19,'','','0','0','','',0,'',0,0,0,0,0),(27,0,'News & Journals','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(28,0,'Plumbing & Fitting','','folder.gif','','1',45,'','','0','0','','',0,'',0,0,0,0,0),(29,0,'Real Estate & Agents','','folder.gif','','1',32,'','','0','0','','',0,'',0,0,0,0,0),(30,0,'Environment & Technology','','folder.gif','','1',13,'','','0','0','','',0,'',0,0,0,0,0),(31,0,'SEO & SMO Marketing','','folder.gif','','1',25,'','','0','0','','',0,'',0,0,0,0,0),(32,0,'Online Shopping','','folder.gif','','1',52,'','','0','0','','',0,'',0,0,0,0,0),(33,0,'Sports','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(34,0,'Transportation and Logistics Services','','folder.gif','','1',41,'','','0','0','','',0,'',0,0,0,0,0),(35,0,'Tours & Travel','','folder.gif','','1',20,'','','0','0','','',0,'',0,0,0,0,0),(36,0,'Wedding & Jewellery','','folder.gif','','1',7,'','','0','0','','',0,'',0,0,0,0,0);

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

CREATE TABLE `idx_category_path` (
  `category_id` mediumint(9) NOT NULL default '0',
  `path` text,
  `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 & Music','<a href=\"http://replistingz.com/arts-music/\" name=\"cat_1\" style=\"\">Arts & Music</a>',';0;'),(2,'Auto Industry','<a href=\"http://replistingz.com/auto-industry/\" name=\"cat_2\" style=\"\">Auto Industry</a>',';0;'),(3,'Economy & Business','<a href=\"http://replistingz.com/economy-business/\" name=\"cat_3\" style=\"\">Economy & Business</a>',';0;'),(4,'Careers & Job Search','<a href=\"http://replistingz.com/careers-job-search/\" name=\"cat_4\" style=\"\">Careers & Job Search</a>',';0;'),(5,'Clothing Accessories','<a href=\"http://replistingz.com/clothing-accessories/\" name=\"cat_5\" style=\"\">Clothing Accessories</a>',';0;'),(6,'Communications Services','<a href=\"http://replistingz.com/communications-services/\" name=\"cat_6\" style=\"\">Communications Services</a>',';0;'),(7,'Computer Services','<a href=\"http://replistingz.com/computer-services/\" name=\"cat_7\" style=\"\">Computer Services</a>',';0;'),(8,'Building & Construction','<a href=\"http://replistingz.com/building-construction/\" name=\"cat_8\" style=\"\">Building & Construction</a>',';0;'),(9,'Dental','<a href=\"http://replistingz.com/dental/\" name=\"cat_9\" style=\"\">Dental</a>',';0;'),(10,'Educational Resources','<a href=\"http://replistingz.com/educational-resources/\" name=\"cat_10\" style=\"\">Educational Resources</a>',';0;'),(11,'Recruitment Services','<a href=\"http://replistingz.com/recruitment-services/\" name=\"cat_11\" style=\"\">Recruitment Services</a>',';0;'),(12,'Gifts & Flowers','<a href=\"http://replistingz.com/gifts-flowers/\" name=\"cat_12\" style=\"\">Gifts & Flowers</a>',';0;'),(13,'Hardware & Software Resources','<a href=\"http://replistingz.com/hardware-software-resources/\" name=\"cat_13\" style=\"\">Hardware & Software Resources</a>',';0;'),(14,'Medical & Health','<a href=\"http://replistingz.com/medical-health/\" name=\"cat_14\" style=\"\">Medical & Health</a>',';0;'),(15,'Healthcare Management','<a href=\"http://replistingz.com/healthcare-management/\" name=\"cat_15\" style=\"\">Healthcare Management</a>',';0;'),(16,'Air Conditioning, Heating & Ventilating','<a href=\"http://replistingz.com/air-conditioning-heating-ventilating/\" name=\"cat_16\" style=\"\">Air Conditioning, Heating & Ventilating</a>',';0;'),(17,'Family ,Home & Garden','<a href=\"http://replistingz.com/family-home-garden/\" name=\"cat_17\" style=\"\">Family ,Home & Garden</a>',';0;'),(18,'Home Improvement & Interiors','<a href=\"http://replistingz.com/home-improvement-interiors/\" name=\"cat_18\" style=\"\">Home Improvement & Interiors</a>',';0;'),(19,'Hotels & Restaurants','<a href=\"http://replistingz.com/hotels-restaurants/\" name=\"cat_19\" style=\"\">Hotels & Restaurants</a>',';0;'),(20,'Insurance Agents and Companies','<a href=\"http://replistingz.com/insurance-agents-and-companies/\" name=\"cat_20\" style=\"\">Insurance Agents and Companies</a>',';0;'),(21,'Law & Legal Services','<a href=\"http://replistingz.com/law-legal-services/\" name=\"cat_21\" style=\"\">Law & Legal Services</a>',';0;'),(22,'Lawyers & Legal Consultants','<a href=\"http://replistingz.com/lawyers-legal-consultants/\" name=\"cat_22\" style=\"\">Lawyers & Legal Consultants</a>',';0;'),(24,'Lifestyle & People','<a href=\"http://replistingz.com/lifestyle-people/\" name=\"cat_24\" style=\"\">Lifestyle & People</a>',';0;'),(25,'Medicine & Medical Services','<a href=\"http://replistingz.com/medicine-medical-services/\" name=\"cat_25\" style=\"\">Medicine & Medical Services</a>',';0;'),(26,'Finance','<a href=\"http://replistingz.com/finance/\" name=\"cat_26\" style=\"\">Finance</a>',';0;'),(27,'News & Journals','<a href=\"http://replistingz.com/news-journals/\" name=\"cat_27\" style=\"\">News & Journals</a>',';0;'),(28,'Plumbing & Fitting','<a href=\"http://replistingz.com/plumbing-fitting/\" name=\"cat_28\" style=\"\">Plumbing & Fitting</a>',';0;'),(29,'Real Estate & Agents','<a href=\"http://replistingz.com/real-estate-agents/\" name=\"cat_29\" style=\"\">Real Estate & Agents</a>',';0;'),(30,'Environment & Technology','<a href=\"http://replistingz.com/environment-technology/\" name=\"cat_30\" style=\"\">Environment & Technology</a>',';0;'),(31,'SEO & SMO Marketing','<a href=\"http://replistingz.com/seo-smo-marketing/\" name=\"cat_31\" style=\"\">SEO & SMO Marketing</a>',';0;'),(32,'Online Shopping','<a href=\"http://replistingz.com/online-shopping/\" name=\"cat_32\" style=\"\">Online Shopping</a>',';0;'),(33,'Sports','<a href=\"http://replistingz.com/sports/\" name=\"cat_33\" style=\"\">Sports</a>',';0;'),(34,'Transportation and Logistics Services','<a href=\"http://replistingz.com/transportation-and-logistics-services/\" name=\"cat_34\" style=\"\">Transportation and Logistics Services</a>',';0;'),(35,'Tours & Travel','<a href=\"http://replistingz.com/tours-travel/\" name=\"cat_35\" style=\"\">Tours & Travel</a>',';0;'),(36,'Wedding & Jewellery','<a href=\"http://replistingz.com/wedding-jewellery/\" name=\"cat_36\" style=\"\">Wedding & Jewellery</a>',';0;');

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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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



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

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

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

INSERT INTO `idx_favorites` VALUES (1,'koryharriss71n68','2011-10-18','My Favorites',NULL),(2,'erikronnieg11v76','2011-10-19','My Favorites',NULL),(3,'danteharleyr70g12','2011-10-31','My Favorites',NULL),(4,'genaroisaacd45m61','2011-11-01','My Favorites',NULL);

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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `idx_pagerank` VALUES (1,'g',0,'2011-11-07'),(82,'g',0,'2012-02-09'),(36,'g',0,'2012-02-09'),(43,'g',0,'2012-02-09'),(9,'g',0,'2011-11-24'),(20,'g',0,'2012-02-09'),(40,'g',0,'2012-02-09'),(47,'g',0,'2012-02-09'),(6,'g',0,'2011-11-24'),(37,'g',0,'2012-02-09'),(17,'g',0,'2012-02-09'),(141,'g',0,'2011-11-25'),(190,'g',0,'2011-11-25'),(177,'g',0,'2011-11-25'),(54,'g',0,'2011-11-25'),(186,'g',0,'2011-11-25'),(4,'g',0,'2011-11-25'),(65,'g',0,'2011-11-25'),(22,'g',0,'2011-12-27'),(26,'g',0,'2012-02-23'),(146,'g',0,'2011-11-25'),(64,'g',0,'2012-02-23'),(41,'g',0,'2011-11-25'),(106,'g',0,'2012-02-23'),(115,'g',0,'2012-02-23'),(306,'g',0,'2012-02-23'),(103,'g',0,'2011-11-26'),(11,'g',0,'2011-11-26'),(449,'g',0,'2011-11-27'),(426,'g',0,'2012-01-12'),(383,'g',0,'2011-12-30'),(486,'g',0,'2011-12-30'),(572,'g',0,'2012-02-17'),(541,'g',0,'2012-02-17'),(117,'g',0,'2012-02-17'),(119,'g',0,'2012-02-17'),(258,'g',0,'2012-02-17'),(482,'g',0,'2012-02-17'),(539,'g',0,'2012-02-17'),(266,'g',0,'2012-02-17'),(571,'g',0,'2012-01-12'),(256,'g',0,'2011-11-27'),(458,'g',0,'2011-12-30'),(568,'g',0,'2012-01-12'),(62,'g',0,'2011-12-30'),(169,'g',0,'2011-12-30'),(393,'g',0,'2012-01-12'),(483,'g',0,'2011-12-30'),(90,'g',0,'2011-12-30'),(52,'g',0,'2011-12-30'),(492,'g',0,'2012-01-15'),(459,'g',0,'2012-01-15'),(570,'g',0,'2012-01-15'),(467,'g',0,'2011-11-28'),(480,'g',0,'2012-01-15'),(367,'g',0,'2012-01-10'),(23,'g',0,'2012-01-26'),(25,'g',0,'2012-01-26'),(12,'g',0,'2011-11-29'),(505,'g',0,'2012-01-15'),(681,'g',0,'2011-11-29'),(149,'g',0,'2012-01-26'),(270,'g',0,'2012-01-26'),(436,'g',0,'2012-01-26'),(682,'g',0,'2011-11-29'),(470,'g',0,'2012-01-26'),(429,'g',0,'2012-01-26'),(178,'g',0,'2012-01-15'),(738,'g',0,'2011-11-29'),(59,'g',0,'2011-11-29'),(76,'g',0,'2011-11-29'),(79,'g',0,'2011-11-30'),(56,'g',0,'2011-11-30'),(58,'g',0,'2011-11-30'),(14,'g',0,'2011-11-30'),(334,'g',0,'2012-01-17'),(118,'g',0,'2012-01-17'),(107,'g',0,'2012-01-02'),(105,'g',0,'2012-01-17'),(111,'g',0,'2012-01-02'),(283,'g',0,'2012-01-02'),(112,'g',0,'2012-01-02'),(530,'g',0,'2012-01-02'),(211,'g',0,'2012-01-17'),(594,'g',0,'2012-01-02'),(188,'g',0,'2012-01-03'),(88,'g',0,'2012-01-03'),(110,'g',0,'2012-01-03'),(84,'g',0,'2012-01-03'),(203,'g',0,'2012-01-03'),(60,'g',0,'2011-11-30'),(42,'g',0,'2011-11-30'),(78,'g',0,'2012-03-02'),(720,'g',0,'2011-11-30'),(257,'g',0,'2012-02-23'),(240,'g',0,'2012-02-23'),(268,'g',0,'2012-02-23'),(264,'g',0,'2012-02-23'),(604,'g',0,'2012-02-23'),(148,'g',0,'2012-02-23'),(136,'g',0,'2012-02-23'),(74,'g',0,'2012-02-23'),(195,'g',0,'2012-02-23'),(156,'g',0,'2012-01-03'),(817,'g',0,'2011-11-30'),(167,'g',0,'2012-01-03'),(33,'g',0,'2012-01-17'),(32,'g',0,'2012-01-17'),(131,'g',0,'2011-12-01'),(132,'g',0,'2011-12-01'),(274,'g',0,'2012-01-17'),(439,'g',0,'2012-01-17'),(410,'g',0,'2011-12-01'),(425,'g',0,'2011-12-01'),(121,'g',0,'2012-01-03'),(24,'g',0,'2012-01-03'),(113,'g',0,'2012-03-07'),(72,'g',0,'2012-02-21'),(77,'g',0,'2011-12-01'),(314,'g',0,'2011-12-01'),(5,'g',0,'2011-12-01'),(7,'g',0,'2011-12-01'),(338,'g',0,'2011-12-01'),(129,'g',0,'2012-02-21'),(139,'g',0,'2012-02-21'),(49,'g',0,'2011-12-01'),(91,'g',0,'2012-02-21'),(441,'g',0,'2012-01-17'),(50,'g',0,'2012-01-10'),(51,'g',0,'2012-01-10'),(31,'g',0,'2012-01-10'),(18,'g',0,'2012-02-21'),(109,'g',0,'2012-01-17'),(116,'g',0,'2012-02-21'),(100,'g',0,'2011-12-02'),(67,'g',0,'2012-01-10'),(35,'g',0,'2012-01-10'),(69,'g',0,'2011-12-02'),(45,'g',0,'2011-12-02'),(96,'g',0,'2011-12-02'),(29,'g',0,'2012-01-10'),(16,'g',0,'2012-02-21'),(234,'g',0,'2011-12-02'),(344,'g',0,'2011-12-02'),(215,'g',0,'2011-12-02'),(73,'g',0,'2012-03-07'),(280,'g',0,'2011-12-02'),(151,'g',0,'2011-12-02'),(405,'g',0,'2011-12-02'),(80,'g',0,'2011-12-02'),(219,'g',0,'2011-12-02'),(39,'g',0,'2012-01-04'),(55,'g',0,'2011-12-03'),(414,'g',0,'2011-12-03'),(415,'g',0,'2012-01-27'),(348,'g',0,'2011-12-03'),(416,'g',0,'2012-01-27'),(331,'g',0,'2011-12-03'),(197,'g',0,'2011-12-03'),(411,'g',0,'2011-12-03'),(174,'g',0,'2011-12-03'),(218,'g',0,'2011-12-03'),(445,'g',0,'2011-12-03'),(384,'g',0,'2011-12-03'),(172,'g',0,'2011-12-03'),(75,'g',0,'2012-03-07'),(758,'g',0,'2011-12-03'),(607,'g',0,'2012-02-28'),(563,'g',0,'2012-02-28'),(473,'g',0,'2012-02-28'),(253,'g',0,'2012-02-28'),(245,'g',0,'2011-12-03'),(526,'g',0,'2012-01-02'),(44,'g',0,'2011-12-03'),(13,'g',0,'2012-02-23'),(46,'g',0,'2012-02-23'),(632,'g',0,'2012-01-02'),(390,'g',0,'2011-12-03'),(657,'g',0,'2012-01-02'),(417,'g',0,'2012-01-27'),(143,'g',0,'2012-02-23'),(193,'g',0,'2012-02-23'),(634,'g',0,'2012-01-30'),(8,'g',0,'2011-12-04'),(19,'g',0,'2012-01-30'),(633,'g',0,'2012-01-30'),(281,'g',0,'2012-01-30'),(560,'g',0,'2012-01-30'),(289,'g',0,'2012-01-30'),(140,'g',0,'2012-02-23'),(664,'g',0,'2012-01-30'),(435,'g',0,'2012-01-30'),(588,'g',0,'2012-01-30'),(395,'g',0,'2012-01-09'),(364,'g',0,'2012-02-23'),(339,'g',0,'2012-02-23'),(431,'g',0,'2012-01-09'),(374,'g',0,'2012-02-23'),(125,'g',0,'2012-02-23'),(135,'g',0,'2012-02-23'),(153,'g',0,'2012-02-23'),(126,'g',0,'2012-02-23'),(180,'g',0,'2012-02-23'),(159,'g',0,'2012-02-23'),(168,'g',0,'2012-02-23'),(21,'g',0,'2012-02-23'),(155,'g',0,'2012-01-13'),(10,'g',0,'2011-12-04'),(144,'g',0,'2012-02-01'),(423,'g',0,'2012-02-01'),(61,'g',0,'2012-02-01'),(447,'g',0,'2012-02-01'),(99,'g',0,'2012-02-01'),(147,'g',0,'2012-02-01'),(123,'g',0,'2012-02-01'),(57,'g',0,'2012-01-10'),(63,'g',0,'2012-02-23'),(53,'g',0,'2012-02-01'),(396,'g',0,'2012-02-23'),(557,'g',0,'2012-02-23'),(265,'g',0,'2012-02-23'),(124,'g',0,'2012-02-01'),(378,'g',0,'2012-02-01'),(229,'g',0,'2012-02-17'),(222,'g',0,'2012-02-17'),(276,'g',0,'2012-02-17'),(92,'g',0,'2012-02-09'),(233,'g',0,'2011-12-12'),(941,'g',0,'2012-01-30'),(1109,'g',0,'2012-01-30'),(1191,'g',0,'2012-01-30'),(1322,'g',0,'2011-12-12'),(1289,'g',0,'2012-01-30'),(114,'g',0,'2012-02-17'),(102,'g',0,'2011-12-12'),(70,'g',0,'2012-02-17'),(183,'g',0,'2012-02-17'),(953,'g',0,'2012-02-17'),(176,'g',0,'2011-12-16'),(242,'g',0,'2011-12-16'),(164,'g',0,'2011-12-16'),(621,'g',0,'2011-12-16'),(591,'g',0,'2011-12-16'),(341,'g',0,'2011-12-16'),(160,'g',0,'2011-12-16'),(521,'g',0,'2011-12-16'),(120,'g',0,'2011-12-16'),(317,'g',0,'2011-12-16'),(128,'g',0,'2011-12-16'),(932,'g',0,'2011-12-16'),(528,'g',0,'2011-12-16'),(246,'g',0,'2011-12-16'),(279,'g',0,'2011-12-16'),(375,'g',0,'2011-12-16'),(315,'g',0,'2011-12-16'),(442,'g',0,'2011-12-16'),(321,'g',0,'2011-12-16'),(261,'g',0,'2011-12-16'),(532,'g',0,'2011-12-16'),(263,'g',0,'2011-12-16'),(379,'g',0,'2011-12-16'),(525,'g',0,'2011-12-16'),(165,'g',0,'2011-12-16'),(333,'g',0,'2011-12-16'),(94,'g',0,'2012-01-15'),(191,'g',0,'2011-12-16'),(223,'g',0,'2011-12-16'),(537,'g',0,'2011-12-16'),(587,'g',0,'2011-12-16'),(527,'g',0,'2011-12-16'),(460,'g',0,'2011-12-16'),(150,'g',0,'2011-12-16'),(420,'g',0,'2011-12-16'),(154,'g',0,'2011-12-16'),(71,'g',0,'2011-12-16'),(639,'g',0,'2011-12-16'),(366,'g',0,'2011-12-16'),(267,'g',0,'2011-12-16'),(137,'g',0,'2011-12-16'),(394,'g',0,'2011-12-16'),(377,'g',0,'2011-12-16'),(202,'g',0,'2011-12-16'),(335,'g',0,'2011-12-16'),(179,'g',0,'2011-12-16'),(226,'g',0,'2011-12-16'),(161,'g',0,'2011-12-16'),(260,'g',0,'2011-12-17'),(618,'g',0,'2011-12-17'),(507,'g',0,'2011-12-17'),(86,'g',0,'2011-12-17'),(1379,'g',0,'2011-12-17'),(1353,'g',0,'2011-12-17'),(1392,'g',0,'2011-12-17'),(450,'g',0,'2011-12-17'),(208,'g',0,'2011-12-17'),(370,'g',0,'2011-12-17'),(1335,'g',0,'2011-12-17'),(1359,'g',0,'2011-12-17'),(376,'g',0,'2011-12-17'),(248,'g',0,'2011-12-17'),(520,'g',0,'2011-12-17'),(629,'g',0,'2011-12-17'),(145,'g',0,'2012-03-05'),(171,'g',0,'2011-12-19'),(285,'g',0,'2012-02-17'),(225,'g',0,'2011-12-20'),(108,'g',0,'2011-12-20'),(616,'g',0,'2011-12-20'),(227,'g',0,'2011-12-20'),(83,'g',0,'2011-12-20'),(992,'g',0,'2011-12-20'),(577,'g',0,'2011-12-20'),(455,'g',0,'2011-12-20'),(454,'g',0,'2011-12-20'),(531,'g',0,'2011-12-20'),(162,'g',0,'2011-12-20'),(438,'g',0,'2011-12-20'),(230,'g',0,'2011-12-20'),(81,'g',0,'2011-12-20'),(641,'g',0,'2011-12-21'),(428,'g',0,'2011-12-21'),(645,'g',0,'2011-12-21'),(626,'g',0,'2011-12-21'),(444,'g',0,'2011-12-21'),(546,'g',0,'2011-12-21'),(643,'g',0,'2011-12-21'),(205,'g',0,'2011-12-21'),(357,'g',0,'2011-12-21'),(302,'g',0,'2011-12-21'),(237,'g',0,'2011-12-21'),(427,'g',0,'2011-12-21'),(318,'g',0,'2011-12-21'),(236,'g',0,'2011-12-21'),(382,'g',0,'2011-12-21'),(972,'g',0,'2011-12-21'),(663,'g',0,'2011-12-22'),(661,'g',0,'2011-12-22'),(959,'g',0,'2011-12-22'),(651,'g',0,'2011-12-22'),(983,'g',0,'2011-12-22'),(646,'g',0,'2011-12-22'),(909,'g',0,'2011-12-22'),(1428,'g',0,'2011-12-22'),(424,'g',0,'2012-02-23'),(440,'g',0,'2011-12-22'),(1019,'g',0,'2012-03-02'),(1399,'g',0,'2011-12-22'),(937,'g',0,'2011-12-22'),(1382,'g',0,'2011-12-23'),(1381,'g',0,'2011-12-23'),(1383,'g',0,'2011-12-23'),(1384,'g',0,'2011-12-23'),(1388,'g',0,'2012-01-26'),(1387,'g',0,'2011-12-23'),(27,'g',0,'2011-12-23'),(1380,'g',0,'2011-12-23'),(122,'g',0,'2011-12-26'),(987,'g',0,'2011-12-26'),(343,'g',0,'2011-12-26'),(1091,'g',0,'2011-12-27'),(1146,'g',0,'2011-12-27'),(30,'g',0,'2012-02-23'),(1415,'g',0,'2012-02-23'),(15,'g',0,'2012-02-23'),(210,'g',0,'2011-12-28'),(628,'g',0,'2011-12-28'),(598,'g',0,'2011-12-28'),(490,'g',0,'2011-12-28'),(196,'g',0,'2011-12-28'),(200,'g',0,'2011-12-28'),(535,'g',0,'2011-12-28'),(342,'g',0,'2011-12-28'),(209,'g',0,'2011-12-28'),(372,'g',0,'2011-12-28'),(282,'g',0,'2011-12-28'),(204,'g',0,'2011-12-28'),(597,'g',0,'2011-12-28'),(238,'g',0,'2011-12-28'),(627,'g',0,'2011-12-28'),(214,'g',0,'2011-12-28'),(389,'g',0,'2011-12-28'),(198,'g',0,'2011-12-28'),(201,'g',0,'2011-12-28'),(600,'g',0,'2011-12-28'),(207,'g',0,'2011-12-28'),(301,'g',0,'2011-12-28'),(232,'g',0,'2011-12-28'),(206,'g',0,'2011-12-28'),(974,'g',0,'2011-12-28'),(642,'g',0,'2011-12-28'),(189,'g',0,'2011-12-28'),(212,'g',0,'2011-12-28'),(489,'g',0,'2011-12-28'),(1446,'g',0,'2011-12-28'),(320,'g',0,'2011-12-28'),(1189,'g',0,'2011-12-28'),(1314,'g',0,'2011-12-28'),(1212,'g',0,'2011-12-28'),(1246,'g',0,'2011-12-28'),(1190,'g',0,'2011-12-28'),(1180,'g',0,'2012-03-07'),(358,'g',0,'2012-02-13'),(95,'g',0,'2012-02-18'),(157,'g',0,'2012-02-18'),(313,'g',0,'2012-02-17'),(524,'g',0,'2011-12-28'),(462,'g',0,'2011-12-28'),(534,'g',0,'2011-12-28'),(312,'g',0,'2012-02-17'),(448,'g',0,'2011-12-28'),(399,'g',0,'2011-12-28'),(349,'g',0,'2011-12-28'),(369,'g',0,'2011-12-28'),(538,'g',0,'2011-12-28'),(388,'g',0,'2011-12-28'),(406,'g',0,'2011-12-28'),(347,'g',0,'2011-12-28'),(351,'g',0,'2011-12-28'),(350,'g',0,'2011-12-28'),(354,'g',0,'2011-12-28'),(403,'g',0,'2011-12-28'),(346,'g',0,'2011-12-28'),(371,'g',0,'2011-12-28'),(387,'g',0,'2011-12-28'),(1475,'g',0,'2012-01-31'),(34,'g',0,'2012-02-23'),(28,'g',0,'2012-02-26'),(66,'g',0,'2012-02-23'),(469,'g',0,'2011-12-30'),(1465,'g',0,'2011-12-30'),(644,'g',0,'2011-12-30'),(1459,'g',0,'2011-12-30'),(1400,'g',0,'2011-12-30'),(667,'g',0,'2011-12-30'),(1397,'g',0,'2011-12-30'),(1450,'g',0,'2011-12-30'),(669,'g',0,'2011-12-30'),(580,'g',0,'2011-12-30'),(1442,'g',0,'2011-12-30'),(1391,'g',0,'2011-12-30'),(1481,'g',0,'2011-12-30'),(940,'g',0,'2011-12-30'),(938,'g',0,'2011-12-30'),(1188,'g',0,'2011-12-30'),(939,'g',0,'2011-12-30'),(1506,'g',0,'2012-01-30'),(1386,'g',0,'2011-12-30'),(915,'g',0,'2011-12-30'),(996,'g',0,'2011-12-30'),(1301,'g',0,'2011-12-30'),(1288,'g',0,'2011-12-30'),(1181,'g',0,'2011-12-30'),(1296,'g',0,'2011-12-30'),(1186,'g',0,'2011-12-30'),(1058,'g',0,'2011-12-30'),(1224,'g',0,'2011-12-30'),(1315,'g',0,'2011-12-30'),(918,'g',0,'2011-12-30'),(1458,'g',0,'2011-12-30'),(914,'g',0,'2011-12-31'),(1002,'g',0,'2011-12-31'),(631,'g',0,'2011-12-31'),(1453,'g',0,'2011-12-31'),(586,'g',0,'2011-12-31'),(1394,'g',0,'2011-12-31'),(649,'g',0,'2011-12-31'),(1389,'g',0,'2011-12-31'),(957,'g',0,'2011-12-31'),(943,'g',0,'2011-12-31'),(946,'g',0,'2011-12-31'),(913,'g',0,'2011-12-31'),(1061,'g',0,'2011-12-31'),(640,'g',0,'2012-01-01'),(659,'g',0,'2012-01-01'),(1443,'g',0,'2012-01-01'),(614,'g',0,'2012-01-01'),(615,'g',0,'2012-01-01'),(1423,'g',0,'2012-01-01'),(1478,'g',0,'2012-01-01'),(1071,'g',0,'2012-01-01'),(611,'g',0,'2012-01-01'),(549,'g',0,'2012-01-01'),(1248,'g',0,'2012-01-01'),(1433,'g',0,'2012-01-01'),(964,'g',0,'2012-01-01'),(1236,'g',0,'2012-01-01'),(956,'g',0,'2012-01-01'),(945,'g',0,'2012-01-01'),(977,'g',0,'2012-01-01'),(1114,'g',0,'2012-01-01'),(1390,'g',0,'2012-01-01'),(612,'g',0,'2012-01-01'),(564,'g',0,'2012-01-01'),(1251,'g',0,'2012-01-01'),(1438,'g',0,'2012-01-01'),(962,'g',0,'2012-01-01'),(917,'g',0,'2012-01-01'),(68,'g',0,'2012-02-17'),(916,'g',0,'2012-01-01'),(1088,'g',0,'2012-01-01'),(613,'g',0,'2012-01-02'),(1001,'g',0,'2012-01-02'),(1441,'g',0,'2012-01-02'),(1205,'g',0,'2012-01-02'),(1098,'g',0,'2012-01-02'),(1085,'g',0,'2012-01-02'),(1496,'g',0,'2012-03-02'),(1466,'g',0,'2012-02-23'),(1135,'g',0,'2012-01-03'),(1070,'g',0,'2012-01-03'),(363,'g',0,'2012-01-03'),(38,'g',0,'2012-01-03'),(1498,'g',0,'2012-02-02'),(1460,'g',0,'2012-02-23'),(908,'g',0,'2012-01-03'),(975,'g',0,'2012-01-03'),(1238,'g',0,'2012-01-03'),(963,'g',0,'2012-01-03'),(1463,'g',0,'2012-02-06'),(1457,'g',0,'2012-02-06'),(1077,'g',0,'2012-02-06'),(1385,'g',0,'2012-03-07'),(1487,'g',0,'2012-01-04'),(87,'g',0,'2012-02-09'),(1529,'g',0,'2012-01-08'),(1538,'g',0,'2012-01-08'),(1512,'g',0,'2012-02-17'),(1526,'g',0,'2012-01-09'),(1308,'g',0,'2012-02-15'),(402,'g',0,'2012-02-23'),(345,'g',0,'2012-02-23'),(1536,'g',0,'2012-02-23'),(48,'g',0,'2012-02-23'),(1095,'g',0,'2012-01-10'),(1524,'g',0,'2012-01-11'),(1515,'g',0,'2012-01-11'),(1508,'g',0,'2012-01-12'),(1532,'g',0,'2012-01-12'),(1534,'g',0,'2012-02-21'),(1539,'g',0,'2012-01-16'),(184,'g',0,'2012-01-16'),(1530,'g',0,'2012-01-16'),(1505,'g',0,'2012-01-17'),(1491,'g',0,'2012-01-17'),(1531,'g',0,'2012-01-17'),(1516,'g',0,'2012-03-06'),(1666,'g',0,'2012-01-22'),(562,'g',0,'2012-01-24'),(548,'g',0,'2012-01-24'),(468,'g',0,'2012-01-24'),(551,'g',0,'2012-01-24'),(519,'g',0,'2012-01-24'),(552,'g',0,'2012-01-24'),(514,'g',0,'2012-01-24'),(550,'g',0,'2012-01-24'),(493,'g',0,'2012-01-24'),(1467,'g',0,'2012-01-24'),(1462,'g',0,'2012-01-24'),(1447,'g',0,'2012-01-24'),(582,'g',0,'2012-01-24'),(584,'g',0,'2012-01-24'),(665,'g',0,'2012-01-24'),(579,'g',0,'2012-01-24'),(581,'g',0,'2012-01-24'),(585,'g',0,'2012-01-24'),(1007,'g',0,'2012-01-24'),(1006,'g',0,'2012-01-24'),(1497,'g',0,'2012-01-24'),(1005,'g',0,'2012-01-24'),(986,'g',0,'2012-01-26'),(1226,'g',0,'2012-01-26'),(1648,'g',0,'2012-01-26'),(1004,'g',0,'2012-01-26'),(1477,'g',0,'2012-01-26'),(1494,'g',0,'2012-01-26'),(1402,'g',0,'2012-01-26'),(1513,'g',0,'2012-01-26'),(1424,'g',0,'2012-01-26'),(1514,'g',0,'2012-01-26'),(1483,'g',0,'2012-01-26'),(1395,'g',0,'2012-01-26'),(1492,'g',0,'2012-01-26'),(1504,'g',0,'2012-01-26'),(1533,'g',0,'2012-01-26'),(504,'g',0,'2012-01-26'),(542,'g',0,'2012-01-26'),(498,'g',0,'2012-01-26'),(465,'g',0,'2012-01-26'),(503,'g',0,'2012-01-26'),(457,'g',0,'2012-01-26'),(515,'g',0,'2012-01-26'),(545,'g',0,'2012-01-26'),(596,'g',0,'2012-01-26'),(635,'g',0,'2012-01-26'),(589,'g',0,'2012-01-26'),(543,'g',0,'2012-01-26'),(446,'g',0,'2012-01-26'),(599,'g',0,'2012-01-26'),(529,'g',0,'2012-01-26'),(443,'g',0,'2012-01-26'),(606,'g',0,'2012-01-26'),(398,'g',0,'2012-01-26'),(392,'g',0,'2012-01-26'),(464,'g',0,'2012-01-26'),(554,'g',0,'2012-01-26'),(653,'g',0,'2012-01-26'),(249,'g',0,'2012-01-26'),(556,'g',0,'2012-01-26'),(272,'g',0,'2012-01-26'),(573,'g',0,'2012-01-26'),(452,'g',0,'2012-01-26'),(432,'g',0,'2012-01-26'),(502,'g',0,'2012-01-26'),(241,'g',0,'2012-01-26'),(251,'g',0,'2012-01-26'),(574,'g',0,'2012-01-26'),(1456,'g',0,'2012-01-26'),(1214,'g',0,'2012-01-26'),(1473,'g',0,'2012-01-26'),(1405,'g',0,'2012-01-26'),(1519,'g',0,'2012-01-26'),(1406,'g',0,'2012-01-26'),(1393,'g',0,'2012-01-26'),(1404,'g',0,'2012-01-26'),(969,'g',0,'2012-01-26'),(993,'g',0,'2012-01-26'),(982,'g',0,'2012-01-26'),(1430,'g',0,'2012-01-26'),(1422,'g',0,'2012-01-26'),(967,'g',0,'2012-01-26'),(1101,'g',0,'2012-01-26'),(1103,'g',0,'2012-01-26'),(1525,'g',0,'2012-01-26'),(1195,'g',0,'2012-01-26'),(985,'g',0,'2012-01-26'),(536,'g',0,'2012-01-26'),(494,'g',0,'2012-01-26'),(553,'g',0,'2012-01-26'),(484,'g',0,'2012-01-26'),(1398,'g',0,'2012-01-26'),(1690,'g',0,'2012-01-26'),(1282,'g',0,'2012-01-26'),(1476,'g',0,'2012-01-26'),(1537,'g',0,'2012-01-27'),(269,'g',0,'2012-01-27'),(255,'g',0,'2012-01-27'),(303,'g',0,'2012-01-27'),(221,'g',0,'2012-01-27'),(273,'g',0,'2012-01-27'),(291,'g',0,'2012-01-27'),(217,'g',0,'2012-01-27'),(259,'g',0,'2012-01-27'),(271,'g',0,'2012-01-27'),(277,'g',0,'2012-01-27'),(93,'g',0,'2012-03-05'),(97,'g',0,'2012-01-27'),(163,'g',0,'2012-01-27'),(185,'g',0,'2012-01-27'),(187,'g',0,'2012-01-27'),(101,'g',0,'2012-01-27'),(152,'g',0,'2012-01-27'),(104,'g',0,'2012-01-27'),(199,'g',0,'2012-01-27'),(142,'g',0,'2012-01-27'),(1535,'g',0,'2012-01-27'),(419,'g',0,'2012-01-27'),(430,'g',0,'2012-01-27'),(1434,'g',0,'2012-01-27'),(1136,'g',0,'2012-01-27'),(418,'g',0,'2012-01-27'),(1407,'g',0,'2012-01-27'),(1396,'g',0,'2012-01-27'),(332,'g',0,'2012-01-31'),(421,'g',0,'2012-01-31'),(360,'g',0,'2012-01-31'),(361,'g',0,'2012-01-31'),(330,'g',0,'2012-01-31'),(413,'g',0,'2012-01-31'),(352,'g',0,'2012-01-31'),(412,'g',0,'2012-01-31'),(355,'g',0,'2012-01-31'),(362,'g',0,'2012-01-31'),(262,'g',0,'2012-01-31'),(224,'g',0,'2012-01-31'),(244,'g',0,'2012-01-31'),(926,'g',0,'2012-01-31'),(922,'g',0,'2012-01-31'),(247,'g',0,'2012-01-31'),(925,'g',0,'2012-01-31'),(216,'g',0,'2012-01-31'),(924,'g',0,'2012-01-31'),(921,'g',0,'2012-01-31'),(919,'g',0,'2012-01-31'),(927,'g',0,'2012-01-31'),(228,'g',0,'2012-01-31'),(920,'g',0,'2012-01-31'),(275,'g',0,'2012-01-31'),(1553,'g',0,'2012-01-31'),(297,'g',0,'2012-01-31'),(298,'g',0,'2012-01-31'),(299,'g',0,'2012-01-31'),(326,'g',0,'2012-01-31'),(323,'g',0,'2012-01-31'),(327,'g',0,'2012-01-31'),(300,'g',0,'2012-01-31'),(328,'g',0,'2012-01-31'),(329,'g',0,'2012-01-31'),(296,'g',0,'2012-01-31'),(294,'g',0,'2012-01-31'),(293,'g',0,'2012-01-31'),(292,'g',0,'2012-01-31'),(284,'g',0,'2012-01-31'),(288,'g',0,'2012-01-31'),(290,'g',0,'2012-01-31'),(295,'g',0,'2012-01-31'),(287,'g',0,'2012-01-31'),(286,'g',0,'2012-01-31'),(278,'g',0,'2012-01-31'),(1486,'g',0,'2012-02-01'),(1510,'g',0,'2012-02-01'),(1542,'g',0,'2012-02-01'),(85,'g',0,'2012-02-01'),(158,'g',0,'2012-02-02'),(166,'g',0,'2012-02-02'),(1698,'g',0,'2012-02-04'),(1782,'g',0,'2012-02-04'),(1555,'g',0,'2012-02-04'),(1752,'g',0,'2012-02-05'),(1068,'g',0,'2012-02-05'),(1074,'g',0,'2012-02-05'),(1080,'g',0,'2012-02-05'),(1076,'g',0,'2012-02-05'),(1069,'g',0,'2012-02-05'),(1082,'g',0,'2012-02-05'),(1072,'g',0,'2012-02-05'),(1083,'g',0,'2012-02-05'),(1073,'g',0,'2012-02-05'),(1075,'g',0,'2012-02-05'),(1846,'g',0,'2012-02-07'),(1518,'g',0,'2012-02-09'),(1523,'g',0,'2012-02-09'),(1482,'g',0,'2012-02-09'),(1522,'g',0,'2012-02-09'),(1671,'g',0,'2012-02-09'),(1577,'g',0,'2012-02-09'),(1659,'g',0,'2012-02-09'),(1634,'g',0,'2012-02-09'),(506,'g',0,'2012-02-09'),(595,'g',0,'2012-02-09'),(495,'g',0,'2012-02-09'),(518,'g',0,'2012-02-09'),(590,'g',0,'2012-02-09'),(933,'g',0,'2012-02-09'),(1480,'g',0,'2012-02-09'),(1417,'g',0,'2012-02-09'),(1461,'g',0,'2012-02-09'),(1521,'g',0,'2012-02-09'),(1753,'g',0,'2012-02-09'),(1677,'g',0,'2012-02-09'),(1561,'g',0,'2012-02-09'),(1811,'g',0,'2012-02-09'),(1803,'g',0,'2012-02-09'),(1847,'g',0,'2012-02-09'),(1425,'g',0,'2012-02-09'),(947,'g',0,'2012-02-09'),(961,'g',0,'2012-02-09'),(971,'g',0,'2012-02-09'),(973,'g',0,'2012-02-09'),(988,'g',0,'2012-02-09'),(989,'g',0,'2012-02-09'),(995,'g',0,'2012-02-09'),(1552,'g',0,'2012-02-09'),(1429,'g',0,'2012-02-09'),(496,'g',0,'2012-02-10'),(650,'g',0,'2012-02-10'),(474,'g',0,'2012-02-10'),(1499,'g',0,'2012-02-10'),(1651,'g',0,'2012-02-10'),(1503,'g',0,'2012-02-10'),(1449,'g',0,'2012-02-10'),(1421,'g',0,'2012-02-10'),(1654,'g',0,'2012-02-10'),(1448,'g',0,'2012-02-10'),(1872,'g',0,'2012-02-11'),(1860,'g',0,'2012-02-11'),(1767,'g',0,'2012-02-11'),(1622,'g',0,'2012-02-11'),(1621,'g',0,'2012-02-11'),(1540,'g',0,'2012-02-11'),(1572,'g',0,'2012-02-11'),(1233,'g',0,'2012-02-11'),(1871,'g',0,'2012-02-11'),(1431,'g',0,'2012-02-11'),(1293,'g',0,'2012-02-11'),(1805,'g',0,'2012-02-11'),(1182,'g',0,'2012-02-11'),(1573,'g',0,'2012-02-11'),(1556,'g',0,'2012-02-11'),(1230,'g',0,'2012-02-11'),(1227,'g',0,'2012-02-11'),(1142,'g',0,'2012-02-11'),(1145,'g',0,'2012-02-11'),(1244,'g',0,'2012-02-11'),(1134,'g',0,'2012-02-11'),(1247,'g',0,'2012-02-11'),(1243,'g',0,'2012-02-11'),(1612,'g',0,'2012-02-11'),(1144,'g',0,'2012-02-11'),(1143,'g',0,'2012-02-11'),(952,'g',0,'2012-02-11'),(968,'g',0,'2012-02-11'),(1571,'g',0,'2012-02-11'),(984,'g',0,'2012-02-11'),(1187,'g',0,'2012-02-11'),(1223,'g',0,'2012-02-11'),(1295,'g',0,'2012-02-11'),(1099,'g',0,'2012-02-11'),(1629,'g',0,'2012-02-11'),(1565,'g',0,'2012-02-11'),(1689,'g',0,'2012-02-11'),(1560,'g',0,'2012-02-11'),(1754,'g',0,'2012-02-11'),(1580,'g',0,'2012-02-11'),(1770,'g',0,'2012-02-11'),(1774,'g',0,'2012-02-11'),(1414,'g',0,'2012-02-11'),(1624,'g',0,'2012-02-11'),(1874,'g',0,'2012-02-13'),(1813,'g',0,'2012-02-13'),(1838,'g',0,'2012-02-14'),(1748,'g',0,'2012-02-14'),(1614,'g',0,'2012-02-14'),(1772,'g',0,'2012-02-14'),(1283,'g',0,'2012-02-15'),(1290,'g',0,'2012-02-15'),(1209,'g',0,'2012-02-15'),(566,'g',0,'2012-02-15'),(976,'g',0,'2012-02-15'),(662,'g',0,'2012-02-15'),(605,'g',0,'2012-02-15'),(1432,'g',0,'2012-02-15'),(1582,'g',0,'2012-02-15'),(1576,'g',0,'2012-02-15'),(1554,'g',0,'2012-02-15'),(1566,'g',0,'2012-02-15'),(1800,'g',0,'2012-02-16'),(954,'g',0,'2012-02-18'),(960,'g',0,'2012-02-18'),(1883,'g',0,'2012-02-18'),(501,'g',0,'2012-02-19'),(1884,'g',0,'2012-02-19'),(239,'g',0,'2012-02-19'),(194,'g',0,'2012-02-19'),(170,'g',0,'2012-02-19'),(181,'g',0,'2012-02-19'),(182,'g',0,'2012-02-19'),(173,'g',0,'2012-02-19'),(231,'g',0,'2012-02-19'),(252,'g',0,'2012-02-19'),(175,'g',0,'2012-02-19'),(220,'g',0,'2012-02-19'),(133,'g',0,'2012-02-19'),(98,'g',0,'2012-02-19'),(138,'g',0,'2012-02-19'),(127,'g',0,'2012-02-19'),(130,'g',0,'2012-02-19'),(1031,'g',0,'2012-02-19'),(134,'g',0,'2012-02-19'),(1879,'g',0,'2012-02-19'),(1038,'g',0,'2012-02-19'),(1030,'g',0,'2012-02-19'),(1888,'g',0,'2012-02-19'),(1033,'g',0,'2012-02-19'),(1036,'g',0,'2012-02-19'),(1016,'g',0,'2012-02-19'),(353,'g',0,'2012-02-19'),(1035,'g',0,'2012-02-19'),(356,'g',0,'2012-02-19'),(324,'g',0,'2012-02-19'),(385,'g',0,'2012-02-19'),(311,'g',0,'2012-02-19'),(254,'g',0,'2012-02-19'),(322,'g',0,'2012-02-19'),(400,'g',0,'2012-02-19'),(386,'g',0,'2012-02-19'),(381,'g',0,'2012-02-19'),(1037,'g',0,'2012-02-19'),(1032,'g',0,'2012-02-19'),(513,'g',0,'2012-02-19'),(1034,'g',0,'2012-02-19'),(409,'g',0,'2012-02-19'),(540,'g',0,'2012-02-19'),(523,'g',0,'2012-02-19'),(491,'g',0,'2012-02-19'),(485,'g',0,'2012-02-19'),(401,'g',0,'2012-02-19'),(508,'g',0,'2012-02-19'),(437,'g',0,'2012-02-19'),(456,'g',0,'2012-02-19'),(929,'g',0,'2012-02-20'),(930,'g',0,'2012-02-20'),(981,'g',0,'2012-02-20'),(931,'g',0,'2012-02-20'),(603,'g',0,'2012-02-20'),(923,'g',0,'2012-02-20'),(625,'g',0,'2012-02-20'),(593,'g',0,'2012-02-20'),(592,'g',0,'2012-02-20'),(910,'g',0,'2012-02-20'),(966,'g',0,'2012-02-20'),(978,'g',0,'2012-02-20'),(999,'g',0,'2012-02-20'),(994,'g',0,'2012-02-20'),(970,'g',0,'2012-02-20'),(980,'g',0,'2012-02-20'),(979,'g',0,'2012-02-20'),(997,'g',0,'2012-02-20'),(1873,'g',0,'2012-02-20'),(1012,'g',0,'2012-02-20'),(1468,'g',0,'2012-02-20'),(1502,'g',0,'2012-02-20'),(636,'g',0,'2012-02-21'),(1444,'g',0,'2012-02-21'),(655,'g',0,'2012-02-21'),(647,'g',0,'2012-02-21'),(936,'g',0,'2012-02-21'),(1440,'g',0,'2012-02-21'),(1451,'g',0,'2012-02-21'),(1485,'g',0,'2012-02-21'),(619,'g',0,'2012-02-21'),(654,'g',0,'2012-02-21'),(668,'g',0,'2012-02-21'),(935,'g',0,'2012-02-21'),(948,'g',0,'2012-02-21'),(1427,'g',0,'2012-02-21'),(666,'g',0,'2012-02-21'),(368,'g',0,'2012-02-21'),(192,'g',0,'2012-02-21'),(1893,'g',0,'2012-02-21'),(660,'g',0,'2012-02-21'),(608,'g',0,'2012-02-21'),(934,'g',0,'2012-02-21'),(944,'g',0,'2012-02-21'),(1418,'g',0,'2012-02-21'),(1426,'g',0,'2012-02-21'),(1501,'g',0,'2012-02-21'),(1517,'g',0,'2012-02-21'),(1489,'g',0,'2012-02-21'),(1507,'g',0,'2012-02-21'),(1520,'g',0,'2012-02-21'),(670,'g',0,'2012-02-21'),(1419,'g',0,'2012-02-21'),(1511,'g',0,'2012-02-21'),(1880,'g',0,'2012-02-21'),(1897,'g',0,'2012-02-21'),(1024,'g',0,'2012-02-23'),(1025,'g',0,'2012-02-23'),(1027,'g',0,'2012-02-23'),(1029,'g',0,'2012-02-23'),(1066,'g',0,'2012-02-23'),(1067,'g',0,'2012-02-23'),(1065,'g',0,'2012-02-23'),(1028,'g',0,'2012-02-23'),(1026,'g',0,'2012-02-23'),(1495,'g',0,'2012-02-24'),(1768,'g',0,'2012-02-24'),(1579,'g',0,'2012-02-24'),(1769,'g',0,'2012-02-25'),(1878,'g',0,'2012-02-26'),(1837,'g',0,'2012-02-27'),(1926,'g',0,'2012-02-28'),(652,'g',0,'2012-02-29'),(1934,'g',0,'2012-02-29'),(1925,'g',0,'2012-02-29'),(1894,'g',0,'2012-02-29'),(1924,'g',0,'2012-03-01'),(1921,'g',0,'2012-03-01'),(1886,'g',0,'2012-03-02'),(1885,'g',0,'2012-03-02'),(1938,'g',0,'2012-03-02'),(1935,'g',0,'2012-03-02'),(1895,'g',0,'2012-03-02'),(1928,'g',0,'2012-03-02'),(1913,'g',0,'2012-03-03'),(1951,'g',0,'2012-03-05'),(1911,'g',0,'2012-03-06'),(1875,'g',0,'2012-03-06'),(1943,'g',0,'2012-03-06'),(575,'g',0,'2012-03-06'),(544,'g',0,'2012-03-06'),(487,'g',0,'2012-03-06'),(578,'g',0,'2012-03-06'),(567,'g',0,'2012-03-06'),(569,'g',0,'2012-03-06'),(478,'g',0,'2012-03-06'),(488,'g',0,'2012-03-06'),(479,'g',0,'2012-03-06'),(1906,'g',0,'2012-03-06'),(1147,'g',0,'2012-03-06'),(1141,'g',0,'2012-03-06'),(1124,'g',0,'2012-03-06'),(1139,'g',0,'2012-03-06'),(1127,'g',0,'2012-03-06'),(1123,'g',0,'2012-03-06'),(1140,'g',0,'2012-03-06'),(1128,'g',0,'2012-03-06'),(1138,'g',0,'2012-03-06'),(1125,'g',0,'2012-03-06'),(1148,'g',0,'2012-03-06'),(1156,'g',0,'2012-03-06'),(1150,'g',0,'2012-03-06'),(1151,'g',0,'2012-03-06'),(1154,'g',0,'2012-03-06'),(1157,'g',0,'2012-03-06'),(1155,'g',0,'2012-03-06'),(1153,'g',0,'2012-03-06'),(1149,'g',0,'2012-03-06'),(1152,'g',0,'2012-03-06'),(630,'g',0,'2012-03-06'),(656,'g',0,'2012-03-06'),(1437,'g',0,'2012-03-06'),(601,'g',0,'2012-03-06'),(1479,'g',0,'2012-03-06'),(1470,'g',0,'2012-03-06'),(1484,'g',0,'2012-03-06'),(1472,'g',0,'2012-03-06'),(1055,'g',0,'2012-03-06'),(1056,'g',0,'2012-03-06'),(1094,'g',0,'2012-03-06'),(1054,'g',0,'2012-03-06'),(1078,'g',0,'2012-03-06'),(1057,'g',0,'2012-03-06'),(1053,'g',0,'2012-03-06'),(1062,'g',0,'2012-03-06'),(1079,'g',0,'2012-03-06'),(1092,'g',0,'2012-03-06'),(1120,'g',0,'2012-03-06'),(1113,'g',0,'2012-03-06'),(1110,'g',0,'2012-03-06'),(1115,'g',0,'2012-03-06'),(1122,'g',0,'2012-03-06'),(1116,'g',0,'2012-03-06'),(1119,'g',0,'2012-03-06'),(1112,'g',0,'2012-03-06'),(1111,'g',0,'2012-03-06'),(1200,'g',0,'2012-03-06'),(1199,'g',0,'2012-03-06'),(1198,'g',0,'2012-03-06'),(1179,'g',0,'2012-03-06'),(1196,'g',0,'2012-03-06'),(1193,'g',0,'2012-03-06'),(1194,'g',0,'2012-03-06'),(1192,'g',0,'2012-03-06'),(1185,'g',0,'2012-03-06'),(1197,'g',0,'2012-03-06'),(965,'g',0,'2012-03-07'),(1919,'g',0,'2012-03-07'),(1877,'g',0,'2012-03-07'),(911,'g',0,'2012-03-07'),(912,'g',0,'2012-03-07'),(461,'g',0,'2012-03-07'),(434,'g',0,'2012-03-07'),(477,'g',0,'2012-03-07'),(476,'g',0,'2012-03-07'),(1914,'g',0,'2012-03-07'),(1862,'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','replistingz.com'),(5,'site_url','http://replistingz.com'),(6,'email_address','dorothy.proscia@gmail.com'),(7,'language_code','en_US'),(8,'theme_path','/home/replisti/public_html/themes/'),(9,'admin_template_path','/home/replisti/public_html/admin_tpl/'),(10,'plugin_path','/home/replisti/public_html/plugin/'),(12,'active_theme','_replistingz'),(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`
--



