--
-- Host: elitehomerepair.net    Database: elitehom_indexu
-- ------------------------------------------------------


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

--
-- Table structure for table `directory_save_data`
--

CREATE TABLE `directory_save_data` (
  `id` bigint(100) NOT NULL auto_increment,
  `schedule_id` bigint(100) NOT NULL,
  `project_id` bigint(100) NOT NULL,
  `link_id` bigint(100) NOT NULL,
  `confirm_link` text NOT NULL,
  `category_id` int(10) NOT NULL,
  `category_name` varchar(150) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

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

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

INSERT INTO `idx_admin_menu` VALUES (1,0,'Dashboard','summary.php',0),(3,0,'Categories','cat_view.php',0),(4,3,'View/ Edit/ Delete','cat_view.php',1),(5,3,'Add New Category','cat_add.php',2),(2,1,'Summary','summary.php',1),(7,3,'Check Category Structure','cat_struc.php',4),(8,3,'Update Category Path','cat_path_update.php',5),(6,3,'Pending Category','cat_pending_suggestion.php',3),(9,3,'Set Default Price','cat_set_default_price.php',6),(10,3,'Hidden Category','cat_view_hidden.php',7),(11,3,'Registered Users Only','cat_view_registered_only.php',8),(12,3,'Search Category','cat_search.php',9),(13,0,'Links','link_search.php',0),(14,13,'Search/ Edit/ Delete','link_search.php',1),(15,13,'Add New Link','link_add.php',2),(16,13,'Validate Link','link_validate.php',3),(17,13,'Premium Listing','link_premium_listing.php',4),(18,13,'Sponsored Listing','link_sponsored_listing.php',5),(19,13,'Suspended Listing','link_suspended_listing.php',6),(20,13,'Spam Links','link_validate.php?spam=1',7),(22,13,'Update Number of Links','app_update_nol.php',9),(23,13,'Update Tag Clouds','tag_cloud_update.php',10),(21,13,'Editor Pick Links','link_editor_pick.php',8),(25,13,'Validate Reviews','review_validate.php',11),(26,13,'Discount Coupon','coupon.php',12),(27,13,'Default Field','link_default_field.php',13),(28,13,'Custom Field','link_custom_field.php',14),(29,0,'Users','user_active.php',0),(30,29,'View All','user_active.php',1),(31,29,'Add New User','user_add.php',2),(32,29,'View Suspend','user_suspend.php',3),(33,29,'View Unactive','user_active.php?pflag=Unactive',4),(34,29,'Search User','user_search.php',5),(35,0,'Editors','editor_add.php',0),(36,35,'Add New Editor','editor_add.php',1),(37,35,'Validate Editors','editor_validate.php',2),(38,0,'Invoices','inv_config.php',0),(39,38,'Configure','inv_config.php',1),(40,38,'Create An Invoice','inv_create.php',2),(41,38,'Paid Invoice','inv_paid.php',3),(42,38,'Unpaid Invoice','inv_unpaid.php',4),(43,38,'Overdue Invoice','inv_overdue.php',5),(44,38,'Payment History','pay_history.php',6),(45,0,'Mailling Systems','message_view.php',0),(46,45,'Send/ Edit/ Delete','message_view.php',1),(47,45,'Create Template','message_create.php',2),(48,45,'Mailing List Subscribers','message_subscriber.php',3),(49,0,'Templates','template_manager.php',0),(50,49,'Site Templates Manager','template_manager.php',1),(51,49,'Import Site Template','template_import.php',2),(52,49,'Export Site Template','template_export.php',3),(53,49,'Email Templates','email_template.php',4),(54,49,'Export Email Template','email_template_export.php',5),(55,49,'Import Email Template','email_template_import.php',6),(56,0,'Tools','link_duplicate.php',0),(57,56,'Find Duplicate Link','link_duplicate.php',1),(58,56,'Broken Link Report','link_bad.php',2),(59,56,'Spider Link CheckUrl','checkurl_web.php',3),(60,56,'Block Name server Domain','blocked_domain_list.php',4),(61,56,'Add Block Name server Domain','add_blocked_domain.php',5),(62,56,'Unavailable domain listing','unavailable_link_list.php',6),(63,56,'Clear Template Cache','clear_templates_c.php',7),(64,56,'PHP Configuration','phpinfo.php',8),(65,56,'Sitemap Generator','sitemap.php',9),(66,56,'Cronjobs','cronjobs.php',10),(67,56,'Fetch Meta','fetch_meta.php',11),(68,56,'Hook Place','hook_place.php',12),(69,56,'CheckUrl Result','link_checkurl.php',13),(70,56,'View Search Log','log_search.php',14),(71,56,'Bad Words Filter','badword_filter.php',15),(72,0,'Options','app_setup.php',0),(73,72,'Setup','app_setup.php',1),(74,72,'Page Caching','app_page_caching.php',2),(75,72,'Mod-rewrite','app_mod_rewrite.php',3),(76,72,'Change Password','app_change_pwd.php',4),(77,0,'Database','db_import.php',0),(78,77,'Import','db_import.php',1),(79,77,'Export','db_export.php',2),(80,77,'Backup','db_backup.php',3),(81,77,'Query','db_query.php',4),(82,77,'Find Replace','db_find_replace.php',5),(83,0,'Plugins','plugin_listing.php',0),(84,83,'View All','plugin_listing.php',1);

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

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

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


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

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

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


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

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

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

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

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

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

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

INSERT INTO `idx_category` VALUES (1,0,'Bathrooms Accessories','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(2,0,'Carpet Supplies','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(3,0,'Climate Related','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(4,0,'Constructions & Maintenance','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(5,0,'Decoration','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(6,0,'Domestic','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(7,0,'Electronics & Electrical','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(8,0,'Energy Solutions','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(9,0,'Exterior Construction ','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(10,0,'Floor Plans','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(11,0,'Home Accessories','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(12,0,'Home Automation services','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(13,0,'Home Business Supplies','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(14,0,'Home Conservatory Supplies','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(15,0,'Home Furniture','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(16,0,'Home Improvement','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(17,0,'Home Sales','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(18,0,'Interior Design','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(19,0,'Kitchen Collection','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(20,0,'Landscaping & Gardening','','folder.gif','','1',0,'','','0','0','','',0,'',1,0,0,0,0),(21,0,'Lighting Accessories','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(22,0,'Painting Services','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(23,0,'Plumbers','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(24,0,'Restoration Services','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(25,0,'Security','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(26,0,'Shopping & Services','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(27,0,'Storage Home Solutions','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(28,0,'Trading Services','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(29,0,'Wall Painting','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(30,0,'Welding and Soldering Contractors','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(31,0,'Windows and Doors Supplies','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0);

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

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

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

INSERT INTO `idx_category_path` VALUES (1,'Bathrooms Accessories','<a href=\"http://elitehomerepair.net/bathrooms-accessories/\" name=\"cat_1\" style=\"\">Bathrooms Accessories</a>',';0;'),(2,'Carpet Supplies','<a href=\"http://elitehomerepair.net/carpet-supplies/\" name=\"cat_2\" style=\"\">Carpet Supplies</a>',';0;'),(3,'Climate Related','<a href=\"http://elitehomerepair.net/climate-related/\" name=\"cat_3\" style=\"\">Climate Related</a>',';0;'),(4,'Constructions & Maintenance','<a href=\"http://elitehomerepair.net/constructions-maintenance/\" name=\"cat_4\" style=\"\">Constructions & Maintenance</a>',';0;'),(5,'Decoration','<a href=\"http://elitehomerepair.net/decoration/\" name=\"cat_5\" style=\"\">Decoration</a>',';0;'),(6,'Domestic','<a href=\"http://elitehomerepair.net/domestic/\" name=\"cat_6\" style=\"\">Domestic</a>',';0;'),(7,'Electronics & Electrical','<a href=\"http://elitehomerepair.net/electronics-electrical/\" name=\"cat_7\" style=\"\">Electronics & Electrical</a>',';0;'),(8,'Energy Solutions','<a href=\"http://elitehomerepair.net/energy-solutions/\" name=\"cat_8\" style=\"\">Energy Solutions</a>',';0;'),(9,'Exterior Construction ','<a href=\"http://elitehomerepair.net/exterior-construction/\" name=\"cat_9\" style=\"\">Exterior Construction </a>',';0;'),(10,'Floor Plans','<a href=\"http://elitehomerepair.net/floor-plans/\" name=\"cat_10\" style=\"\">Floor Plans</a>',';0;'),(11,'Home Accessories','<a href=\"http://elitehomerepair.net/home-accessories/\" name=\"cat_11\" style=\"\">Home Accessories</a>',';0;'),(12,'Home Automation services','<a href=\"http://elitehomerepair.net/home-automation-services/\" name=\"cat_12\" style=\"\">Home Automation services</a>',';0;'),(13,'Home Business Supplies','<a href=\"http://elitehomerepair.net/home-business-supplies/\" name=\"cat_13\" style=\"\">Home Business Supplies</a>',';0;'),(14,'Home Conservatory Supplies','<a href=\"http://elitehomerepair.net/home-conservatory-supplies/\" name=\"cat_14\" style=\"\">Home Conservatory Supplies</a>',';0;'),(15,'Home Furniture','<a href=\"http://elitehomerepair.net/home-furniture/\" name=\"cat_15\" style=\"\">Home Furniture</a>',';0;'),(16,'Home Improvement','<a href=\"http://elitehomerepair.net/home-improvement/\" name=\"cat_16\" style=\"\">Home Improvement</a>',';0;'),(17,'Home Sales','<a href=\"http://elitehomerepair.net/home-sales/\" name=\"cat_17\" style=\"\">Home Sales</a>',';0;'),(18,'Interior Design','<a href=\"http://elitehomerepair.net/interior-design/\" name=\"cat_18\" style=\"\">Interior Design</a>',';0;'),(19,'Kitchen Collection','<a href=\"http://elitehomerepair.net/kitchen-collection/\" name=\"cat_19\" style=\"\">Kitchen Collection</a>',';0;'),(20,'Landscaping & Gardening','<a href=\"http://elitehomerepair.net/landscaping-gardening/\" name=\"cat_20\" style=\"\">Landscaping & Gardening</a>',';0;'),(21,'Lighting Accessories','<a href=\"http://elitehomerepair.net/lighting-accessories/\" name=\"cat_21\" style=\"\">Lighting Accessories</a>',';0;'),(22,'Painting Services','<a href=\"http://elitehomerepair.net/painting-services/\" name=\"cat_22\" style=\"\">Painting Services</a>',';0;'),(23,'Plumbers','<a href=\"http://elitehomerepair.net/plumbers/\" name=\"cat_23\" style=\"\">Plumbers</a>',';0;'),(24,'Restoration Services','<a href=\"http://elitehomerepair.net/restoration-services/\" name=\"cat_24\" style=\"\">Restoration Services</a>',';0;'),(25,'Security','<a href=\"http://elitehomerepair.net/security/\" name=\"cat_25\" style=\"\">Security</a>',';0;'),(26,'Shopping & Services','<a href=\"http://elitehomerepair.net/shopping-services/\" name=\"cat_26\" style=\"\">Shopping & Services</a>',';0;'),(27,'Storage Home Solutions','<a href=\"http://elitehomerepair.net/storage-home-solutions/\" name=\"cat_27\" style=\"\">Storage Home Solutions</a>',';0;'),(28,'Trading Services','<a href=\"http://elitehomerepair.net/trading-services/\" name=\"cat_28\" style=\"\">Trading Services</a>',';0;'),(29,'Wall Painting','<a href=\"http://elitehomerepair.net/wall-painting/\" name=\"cat_29\" style=\"\">Wall Painting</a>',';0;'),(30,'Welding and Soldering Contractors','<a href=\"http://elitehomerepair.net/welding-and-soldering-contractors/\" name=\"cat_30\" style=\"\">Welding and Soldering Contractors</a>',';0;'),(31,'Windows and Doors Supplies','<a href=\"http://elitehomerepair.net/windows-and-doors-supplies/\" name=\"cat_31\" style=\"\">Windows and Doors Supplies</a>',';0;');

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

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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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

INSERT INTO `idx_email_template` VALUES (1,'add_ok','Resource Added','<div style=\"font-weight:bold;\">Thank you for your submission to <%$site_name%></div>\r\n<p>\r\n<div style=\"float:left;width:200px;\">Resource ID</div>\r\n<div style=\"float:left;width:10px;\"> : </div>\r\n<div style=\"float:left;width:200px;\"><%$link_id%></div>\r\n<div style=\"float:left;width:200px;\">Title</div>\r\n<div style=\"float:left;width:10px;\"> : </div>\r\n<div style=\"float:left;width:200px;\"><%$title%></div>\r\n<div style=\"float:left;width:200px;\">Url</div>\r\n<div style=\"float:left;width:10px;\">  : </div>\r\n<div style=\"float:left;width:200px;\"><%$url%></div>\r\n<div style=\"float:left;width:200px;\">Description </div>\r\n<div style=\"float:left;width:10px;\"> : </div>\r\n<div style=\"float:left;width:200px;\"><%$description%></div>\r\n<div style=\"float:left;width:200px;\">Category </div>\r\n<div style=\"float:left;width:10px;\"> : </div>\r\n<div style=\"float:left;width:200px;\"><%$category%></div>\r\n<div style=\"float:left;width:200px;\">Contact name</div>\r\n<div style=\"float:left;width:10px;\"> : </div>\r\n<div style=\"float:left;width:200px;\"><%$contact_name%></div>\r\n<div style=\"float:left;width:200px;\">Email</div>\r\n<div style=\"float:left;width:10px;\">  : </div>\r\n<div style=\"float:left;width:200px;\"><%$email%></div>\r\n<div style=\"float:left;width:200px;\">Password </div>\r\n<div style=\"float:left;width:10px;\"> : </div>\r\n<div style=\"float:left;width:200px;\"><%$password%></div>\r\n<p>\r\nYour link has been added.\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<%$site_name%> Team\r\n','Thank you for your submission to <%$site_name%>\r\nResource ID  : <%$link_id%>\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nPassword     : <%$password%>\r\nYour link has been added.\r\nRegards,\r\n<%$site_name%> Team'),(2,'add_ok_editor','Resource Added','<div style=\"font-family:arial;font-size:12px;\">\r\nThere\'s a new submission to <b><%$site_name%></b>.\r\n<p>\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Resource ID</td><td style=\"width:10px;\">:</td><td ><%$link_id%></td></tr>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email/td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n</table>\r\n<p>\r\nThe category permissions allow webmasters to add/modify links without needing approval.\r\nThe link has been added.\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<%$site_name%> Team\r\n</div>','There\'s a new submission to <%$site_name%>.\r\nResource ID  : <%$link_id%>\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nThe category permissions allow webmasters to add/modify links without needing approval.\r\nThe link has beed added.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(3,'add_ok_subscriber','Resource Added','<div style=\"font-family:arial;font-size:12px;\">\r\nYou are receiving this email because you have a subscription for update notifications in <b><%$category%></b> category.\r\n<p>\r\nThere\'s a new submission to <b><%$site_name%><b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Resource ID</td><td style=\"width:10px;\">:</td><td ><%$link_id%></td></tr>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','You are receiving this email because you have a subscription for update notifications in <%$category%> category.\r\nThere\'s a new submission to <%$site_name%>.\r\nResource ID  : <%$link_id%>\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(4,'add_pending','Pending Resource','<div style=\"font-family:arial;font-size:12px;\">\r\nThank you for your submission to <b><%$site_name%></b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nYour link will be reviewed by our team. We will contact you as soon <br>\r\nas we have reviewed your link.\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Thank you for your submission to <%$site_name%>.\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nYour link will be reviewed by our team. We will contact you as soon \r\nas we have reviewed your link.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(5,'add_pending_editor','Pending Resource','<div style=\"font-family:arial;font-size:12px;\">\r\nThere\'s a new submission to <b><%$site_name%></b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nYou need to review this link here:<br>\r\n<label style=\"margin-left:10px;\"><a href=\"<%$site_url%>/cp/editor_link_validate.php\"><%$site_url%>/cp/editor_link_validate.php</a></label><br>\r\nYou can approve this submission by clicking here:<br>\r\n<label style=\"margin-left:10px;\"><a href=\"<%$approve_notice%>\"><%$approve_notice%></a></label><br>\r\nYou can reject this submission by clicking here:<br>\r\n<label style=\"margin-left:10px;\"><a href=\"<%$reject_notice%>\"><%$reject_notice%></a></label><br>\r\nSilent reject here:<br>\r\n<label style=\"margin-left:10px;\"><a href=\"<%$reject_silent%>\"><%$reject_silent%></a></label><br>\r\n\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>\r\n','There\'s a new submission to <%$site_name%>.\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nYou need to review this link here:\r\n<%$site_url%>/cp/editor_link_validate.php\r\nYou can approve this submission by clicking here:\r\n<%$approve_notice%>\r\nYou can reject this submission by clicking here:\r\n<%$reject_notice%>\r\nSilent reject here:\r\n<%$reject_silent%>\r\n\r\nRegards,\r\n<%$site_name%> Team\r\n'),(6,'approved','Editor Approved.','<div style=\"font-family:arial;font-size:12px;\">\r\nYour submission at <b><%$site_name%></b> has been approved.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Resource ID</td><td style=\"width:10px;\">:</td><td ><%$link_id%></td></tr>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n<tr><td style=\"width:100px;\">Password </td><td style=\"width:10px;\">:</td><td ><%$password%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Your submission at <%$site_name%> has been approved.\r\nResource ID  : <%$link_id%>\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nPassword     : <%$password%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(7,'approved_editor','Link approved','<div style=\"font-family:arial;font-size:12px;\">\r\nThe following submission has been approved.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Resource ID</td><td style=\"width:10px;\">:</td><td ><%$link_id%></td></tr>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','The following submission has been approved.\r\nResource ID  : <%$link_id%>\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(8,'approved_subscriber','link_approved','<div style=\"font-family:arial;font-size:12px;\">\r\nYou are receiving this email because you have a subscription for update notifications in <b><%$category%></b> category.\r\n<p>\r\nThe following submission has been approved.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Resource ID</td><td style=\"width:10px;\">:</td><td ><%$link_id%></td></tr>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','You are receiving this email because you have a subscription for update notifications in <%$category%> category.\r\nThe following submission has been approved.\r\nResource ID  : <%$link_id%>\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(9,'bad_link_editor','Broken link report','<div style=\"font-family:arial;font-size:12px;\">\r\nThere\'s a new bad link report submission to <b><%$site_name%></b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Name</td><td style=\"width:10px;\">:</td><td ><%$r_name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n<tr><td style=\"width:100px;\">Error type</td><td style=\"width:10px;\">:</td><td ><%$type_val%></td></tr>\r\n</table>\r\n<p>\r\nThis report has been added in your administrator area.<br>\r\nPlease review this report here:<br>\r\n<a href=\"<%$site_url%>/admin/link_bad.php\"><%$site_url%>/admin/link_bad.php</a>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','There\'s a new bad link report submission to <%$site_name%>.\r\nTitle       : <%$title%>\r\nUrl         : <%$url%>\r\nDescription : <%$description%>\r\nCategory    : <%$category%>\r\nName        : <%$r_name%>\r\nEmail       : <%$r_email%>\r\nError type  : <%$type_val%>\r\nThis report has been added in your administrator area.\r\nPlease review this report here:\r\n<%$site_url%>/admin/link_bad.php\r\nRegards,\r\n<%$site_name%> Team\r\n'),(10,'become_editor_approved','Editor Approved.','<div style=\"font-family:arial;font-size:12px;\">\r\nYour request to become an editor at <b><%$site_name%></b> has been approved.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Username</td><td style=\"width:10px;\">:</td><td ><%$username%></td></tr>\r\n<tr><td style=\"width:100px;\">Name </td><td style=\"width:10px;\">:</td><td ><%$name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n<tr><td style=\"width:100px;\">Category </td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Your request to become an editor at <%$site_name%> has been approved.\r\nUsername  : <%$username%>\r\nName      : <%$name%>\r\nEmail     : <%$email%>\r\nCategory  : <%$category%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(11,'become_editor_pending','Request to become an editor','<div style=\"font-family:arial;font-size:12px;\">\r\nThank you for your request to become an editor at <b><%$site_name%></b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Username</td><td style=\"width:10px;\">:</td><td ><%$username%></td></tr>\r\n<tr><td style=\"width:100px;\">Name </td><td style=\"width:10px;\">:</td><td ><%$name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n<tr><td style=\"width:100px;\">Category </td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n</table>\r\n<p>\r\nYour request will be processed soon.\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Thank you for your request to become an editor at <%$site_name%>.\r\nUsername  : <%$username%>\r\nName      : <%$name%>\r\nEmail     : <%$email%>\r\nCategory  : <%$category%>\r\nYour request will be processed soon.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(12,'become_editor_pending_admin','Request to become an editor','<div style=\"font-family:arial;font-size:12px;\">\r\nThere\'s a new request to become an editor at <b><%$site_name%></b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Username</td><td style=\"width:10px;\">:</td><td ><%$username%></td></tr>\r\n<tr><td style=\"width:100px;\">Name </td><td style=\"width:10px;\">:</td><td ><%$name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n<tr><td style=\"width:100px;\">Category </td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n</table>\r\n<p>\r\nPlease review editor request here:\r\n  <label style=\"margin-left:10px;\"><a href=\"<%$site_url%>/admin/index.php\"><%$site_url%>/admin/index.php</a></label>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','There\'s a new request to become an editor at <%$site_name%>.\r\nUsername  : <%$username%>\r\nName      : <%$name%>\r\nEmail     : <%$email%>\r\nCategory  : <%$category%>\r\nPlease review editor requests here:\r\n<%$site_url%>/admin/index.php\r\nRegards,\r\n<%$site_name%> Team\r\n'),(13,'become_editor_rejected','Editor Rejected.','<div style=\"font-family:arial;font-size:12px;\">\r\nYour request to become an editor at <b><%$site_name%></b> has been rejected.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Username</td><td style=\"width:10px;\">:</td><td ><%$username%></td></tr>\r\n<tr><td style=\"width:100px;\">Name </td><td style=\"width:10px;\">:</td><td ><%$name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n<tr><td style=\"width:100px;\">Category </td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Your request to become an editor at <%$site_name%> has been rejected.\r\nUsername  : <%$username%>\r\nName      : <%$name%>\r\nEmail     : <%$email%>\r\nCategory  : <%$category%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(14,'inv_ask_payment','<%$company%>, Invoice #<%$invoice_id%>','<div style=\"font-family:arial;font-size:12px;\">\r\nAn invoice has been created, and is available for viewing at the following URL:<br>\r\n<label><a href=\"<%$site_url%>/invoice.php?id=<%$invoice_id%>\"><%$site_url%>/invoice.php?id=<%$invoice_id%></a></label>\r\n<p>\r\nIf you should have any questions, please do not hesitate to contact us.<br>\r\nThank you for your business.\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','An invoice has been created, and is available for viewing at the following URL:\r\n<%$site_url%>/invoice.php?id=<%$invoice_id%>\r\nIf you should have any questions, please do not hesitate to contact us.\r\nThank you for your business.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(15,'mailing_list_sub','Mailing list subscription','<div style=\"font-family:arial;font-size:12px;\">\r\nThank you. Your email address, <b><%$email%></b> has been added to our mailing list.\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<%$site_name%> Team\r\n</div>','Thank you. Your email address, <%$email%> has been added to our mailing list.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(16,'mailing_list_sub_confirm','Mailing list validation code','<div style=\"font-family:arial;font-size:12px;\">\r\nWe received your subscription request onto our mailing list.<br>\r\nPlease confirm your subscription here:<br>\r\n<label style=\"margin-left:50px;\"><a href=\"<%$confirm_url%>\"><%$confirm_url%></a></label>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','We received your subscription request onto our mailing list.\r\nPlease confirm your subscription here:\r\n<%$confirm_url%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(17,'modify_ok','Resource Modified','<div style=\"font-family:arial;font-size:12px;\">\r\nThank you for your submission to <b><%$site_name%></b>.\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email/td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n</table>\r\n<p>\r\nYour link has been changed.\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Thank you for your submission to <%$site_name%>.\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nYour link has been changed.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(18,'modify_ok_editor','Resource Modified','<div style=\"font-family:arial;font-size:12px;\">\r\nThere\'s a new submission to <%$site_name%>.\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nThe category permissions allow webmasters to add/modify links without approval.\r\nThe link has been modified.\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','There\'s a new submission to <%$site_name%>.\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nThe category permissions allow webmasters to add/modify links without approval.\r\nThe link has been modified.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(19,'modify_ok_subscriber','Resource Modified','<div style=\"font-family:arial;font-size:12px;\">\r\nYou are receiving this email because you have a subscription for update notifications in <b><%$category%></b> category.\r\n<p>\r\nThere\'s a new submission to <b><%$site_name%></b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','You are receiving this email because you have a subscription for update notifications in <%$category%> category.\r\nThere\'s a new submission to <%$site_name%>.\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(20,'modify_pending','Resource Modified','<div style=\"font-family:arial;font-size:12px;\">\r\nThank you for your submission to <b><%$site_name%><b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n</table>\r\n<p>\r\nYour link will be reviewed by our team. We will contact you as soon <br>\r\nas we have reviewed your link.\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Thank you for your submission to <%$site_name%>.\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nYour link will be reviewed by our team. We will contact you as soon \r\nas we have reviewed your link.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(21,'modify_pending_editor','Resource Modified','<div style=\"font-family:arial;font-size:12px;\">\r\nThere\'s a new submission to <b><%$site_name%></b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nYou need to review this link here:<br>\r\n<label style=\"margin-left:10px;\"><a href=\"<%$site_url%>/cp/editor_link_validate.php\"><%$site_url%>/cp/editor_link_validate.php</a></label>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>\r\n','There\'s a new submission to <%$site_name%>.\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nYou need to review this link here:\r\n<%$site_url%>/cp/editor_link_validate.php\r\nRegards,\r\n<%$site_name%> Team\r\n'),(22,'register_confirm','Registration','<div style=\"font-family:arial;font-size:12px;\">\r\nThanks for joining <b><%$site_name%><b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Username</td><td style=\"width:10px;\">:</td><td ><%$username%></td></tr>\r\n<tr><td style=\"width:100px;\">Password</td><td style=\"width:10px;\">:</td><td ><%$password%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nPlease confirm your registration here:<br>\r\n<label style=\"margin-left:10px;\"><A href=\"<%$site_url%>/register.php?u=<%$username%>&v=<%$vcode%>&pflag=cf\"><%$site_url%>/register.php?u=<%$username%>&v=<%$vcode%>&pflag=cf</a></label>\r\n<p>\r\n<p>\r\nSincerely,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Thanks for joining <%$site_name%>.\r\nUsername : <%$username%>\r\nPassword : <%$password%>\r\nPlease confirm your registration here:\r\n<%$site_url%>/register.php?u=<%$username%>&v=<%$vcode%>&pflag=cf\r\nSincerely,\r\n<%$site_name%> Team\r\n'),(23,'register_ok','Registration','<div style=\"font-family:arial;font-size:12px;\">\r\nThanks for joining <b><%$site_name%></b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Username</td><td style=\"width:10px;\">:</td><td ><%$username%></td></tr>\r\n<tr><td style=\"width:100px;\">Password</td><td style=\"width:10px;\">:</td><td ><%$password%></td></tr>\r\n</table>\r\n<p>\r\nSincerely,\r\n<p>\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Thanks for joining <%$site_name%>.\r\nUsername : <%$username%>\r\nPassword : <%$password%>\r\nSincerely,\r\n<%$site_name%> Team\r\n'),(24,'rejected','Your submission has been rejected','<div style=\"font-family:arial;font-size:12px;\">\r\nYour submission has been rejected.<br>\r\nThis may be caused by one of the following reason:\r\n<p>\r\n<ul>\r\n<li>adult material</li>\r\n<li>the site is under construction</li>\r\n<li>the topic is not related with our directory</li>\r\n</ul>\r\n</p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email/td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Your submission has been rejected.\r\nThis may caused by one of the following reasons:\r\n- adult material\r\n- the site is under construction\r\n- the topic is not related with our directory\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(25,'rejected_editor','Link rejected','<div style=\"font-family:arial;font-size:12px;\">\r\nThe following submission has been rejected.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>\r\n','The following submission has been rejected.\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(26,'review_pending_editor','Pending Review','<div style=\"font-family:arial;font-size:12px;\">\r\nThere\'s a new review to <b><%$site_name%></b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n</table>\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Username</td><td style=\"width:10px;\">:</td><td ><%$username%></td></tr>\r\n<tr><td style=\"width:100px;\">Subject</td><td style=\"width:10px;\">:</td><td ><%$rev_subject%></td></tr>\r\n<tr><td style=\"width:100px;\">Rating</td><td style=\"width:10px;\">:</td><td ><%$rev_rating%></td></tr>\r\n<tr><td style=\"width:100px;\">Review</td><td style=\"width:10px;\">:</td><td ><%$rev_review%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nPlease review it here:<br>\r\n<label style=\"margin-left:10px;\"><a href=\"<%$site_url%>/cp/\"><%$site_url%>/cp/</a></label>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>\r\n','There\'s new review to <%$site_name%>.\r\nTitle       : <%$title%>\r\nUrl         : <%$url%>\r\nDescription : <%$description%>\r\nCategory    : <%$category%>\r\nUsername    : <%$username%>\r\nSubject     : <%$rev_subject%>\r\nRating      : <%$rev_rating%>\r\nReview      : <%$rev_review%>\r\nPlease review it here:\r\n<%$site_url%>/cp/\r\nRegards,\r\n<%$site_name%> Team\r\n'),(27,'send_pwd_link','Your resource password','<div style=\"font-family:arial;font-size:12px;\">\r\nHere is your password for <b><%$title%></b> (<a href=\"<%$url%>\"><%$url%></a>)\r\n<p>\r\nPassword : <%$password%>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Here is your password for <%$title%> (<%$url%>)\r\nPassword : <%$password%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(28,'send_pwd_login','Your login password','<div style=\"font-family:arial;font-size:12px;\">\r\nHere is your username and password:\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Username</td><td style=\"width:10px;\">:</td><td ><%$username%></td></tr>\r\n<tr><td style=\"width:100px;\">Password</td><td style=\"width:10px;\">:</td><td ><%$password%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Here is your username and password:\r\nUsername : <%$username%>\r\nPassword : <%$password%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(29,'send_pwd_reset','Password reset request','<div style=\"font-family:arial;font-size:12px;\">\r\nWe received a request to reset your password.<br>\r\nPlease visit this URL to proceed:<br>\r\n<label style=\"margin-left:10px;\"><a href=\"<%$site_url%>/reset_pwd.php?u=<%$username%>&hash=<%$hash%>\"><%$site_url%>/reset_pwd.php?u=<%$username%>&hash=<%$hash%></a></label>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','We received a request to reset your password.\r\nPlease visit this URL to proceed:\r\n<%$site_url%>/reset_pwd.php?u=<%$username%>&hash=<%$hash%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(30,'suggest_category','Category suggestion','<div style=\"font-family:arial;font-size:12px;\">\r\nCategory suggestion for <b><%$site_name%></b>.\r\n<p>\r\nParent               : <%$parent%>\r\nCategory Name        : <%$cat_name%>\r\nCategory Description : <%$cat_desc%>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Category suggestion for <%$site_name%>.\r\nParent               : <%$parent%>\r\nCategory Name        : <%$cat_name%>\r\nCategory Description : <%$cat_desc%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(31,'tell_friend_favorite','Your friend has shared his/her favorite listing','<div style=\"font-family:arial;font-size:12px;\">\r\nHi <%$friend_name%>,\r\n<p>\r\nI\'d like to share my favorite listing at <b><%$site_name%></b> (<a href=\"<%$site_url%>\"><%$site_url%></a>).<br>\r\nI hope you like them and find them useful.\r\n<p>\r\n<p>\r\n<%$fav_item%>\r\n<p>\r\n<p>\r\nSincerely,\r\n<p>\r\n<p>\r\n<%$my_name%> <<%$my_email%>>\r\n</div>','Hi <%$friend_name%>,\r\nI\'d like to share my favorite listings at <%$site_name%> (<%$site_url%>).\r\nI hope you like them and find them useful.\r\n<%$fav_item%>\r\nSincerely,\r\n<%$my_name%> <<%$my_email%>>\r\n'),(32,'tell_friend_favorite_rows',NULL,'<div style=\"font-family:arial;font-size:12px;\">\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n</table>\r\n</div>\r\n','Title       : <%$title%>\r\nUrl         : <%$url%>\r\nDescription : <%$description%>\r\n'),(33,'tell_friend_link','Your friend recommended a link','<div style=\"font-family:arial;font-size:12px;\">\r\nHi <b><%$friend_name%></b>,\r\n<p>\r\nI found a good website that you may find interesting.\r\n<p>\r\n<div>\r\n<label style=\"float:left;width:100px;\">Website</label><label style=\"float:left;\"> : <b><%$title%></b></label>\r\n</div>\r\n<div style=\"clear:both;\">\r\n<label style=\"clear:both;float:left;width:100px;\">Url </label><label style=\"float:left;\"> : <a href=\"<%$url%>\"><%$url%></a></label>\r\n</div>\r\n<p style=\"clear:both;\">\r\nI found this website from <%$site_name%> (<a href=\"<%$site_url%>\"><%$site_url%></a>).\r\n<p>\r\n<p>\r\nSincerely,\r\n<p>\r\n<%$my_name%> <<%$my_email%>>\r\n</div>\r\n','Hi <%$friend_name%>,\r\nI found a good website that you may find interesting.\r\nWebsite : <%$title%>\r\nUrl     : <%$url%>\r\nI found this website from <%$site_name%> (<%$site_url%>).\r\nSincerely,\r\n<%$my_name%> <<%$my_email%>>\r\n'),(34,'tell_friend_website','hi <%$friend_name%>, I found a good website that you may find interesting','<div style=\"font-family:arial;font-size:12px;\">\r\nHi <b><%$friend_name%></b>,\r\n<p>\r\nI found good website that you may find interesting. The website is <b><%$site_name%></b> (<a href=\"<%$site_url%>\"><%$site_url%></a>).\r\n<p>\r\n<p>\r\nSincerely,\r\n<p>\r\n<%$my_name%> <<%$my_email%>>\r\n</div>','Hi <%$friend_name%>,\r\nI found a good website that you may find interesting. The website is <%$site_name%> (<%$site_url%>).\r\nSincerely,\r\n<%$my_name%> <<%$my_email%>>\r\n'),(35,'send_activation_link','Your activation link','<div style=\"font-family:arial;font-size:12px;\">\r\nHere is your activation link\r\n<p>\r\nActivation Link  : <A href=\"<%$activation_link%>\"><%$activation_link%></a>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Here is your activation link\r\nActivation Link  : <%$activation_link%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(36,'send_activated_account','Your account had been activated','<div style=\"font-family:arial;font-size:12px;\">\r\nYour account had been activated. Now you can login.\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Your account had been activated. Now you can login.\r\n\r\nRegards,\r\n<%$site_name%> Team\r\n');

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

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

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

INSERT INTO `idx_favorites` VALUES (1,'pjackygsv','2012-02-19','My Favorites',NULL),(4,'aangeliascott','2012-03-13','',NULL),(5,'1simonpeterson1','2012-03-13','',NULL);

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

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

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


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

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

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


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

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

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


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

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

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

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

--
-- Table structure for table `idx_link`
--

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

--
-- Dumping data for table `idx_link`
--


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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

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

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

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

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

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

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

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

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


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

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

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


--
-- Table structure for table `idx_sessions`
--

CREATE TABLE `idx_sessions` (
  `SESSKEY` varchar(32) collate latin1_general_ci NOT NULL default '',
  `EXPIRY` int(11) unsigned NOT NULL default '0',
  `EXPIREREF` varchar(64) collate latin1_general_ci default NULL,
  `DATA` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`SESSKEY`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `idx_sessions`
--

INSERT INTO `idx_sessions` VALUES ('7beccf800126e4926b8b26ab50850c90',1331880820,NULL,'OaLqQk4moFlzNktNkXTYri7v7TJZnRqqqRu9hHxj_yZvyNHgVLNhdfq3lgQJTKYdeFpJ9ttpGpLtuYLlQnsRKc9_0o2hBnAZXnvfAswuTkyPgiTh_ffoUEvTJxEc1xkBQOAeEtJT8ELzSQ_4ogO9OG4zCJ4MLYZ5venTAgGPnC4.'),('4e6f405a129f0dc2a702a8b1f8aaeeca',1331880825,NULL,'_Gm1BlRoo08e0C5MP1vGcO6O8nEEjtA1b_jLLg3r5NAw2Ovf3S2qm5cNL025UbK7A6_Ku-A3LL6nqM_ipw8awoTitUlmbgEhFhcMooKwWX7kg-Dzx1dlVPq06pmRgc6QVSgd9D1xiq_h5ZLE4qcucKzhe0mPAZN2EIiIcZPS3v4.'),('77dd5711f20d2af0b9371ccfde455f0d',1331880833,NULL,'4roGGDR85F3ZHsy6pOR0Qa525MmmDZsSaNBcOCOSsWT72Suvy1ZMmHIhdaqrmDhZnghKZ_h9nNk7aJzYZTn72t5czbCvJ0xqY8KWmvyq9bpJL5FqSTcNxrxQAX9hpyU989c2doz1CHMmk5KulOl99VuJSf1JPdiZS2EuMGJnvuk2-tgZzFiK38My96ZVfOuJ'),('4a29638d5083655f46a98d27b94c62ac',1331880834,NULL,'4roGGDR85F3ZHsy6pOR0Qa525MmmDZsSaNBcOCOSsWT72Suvy1ZMmHIhdaqrmDhZnghKZ_h9nNk7aJzYZTn72t5czbCvJ0xqY8KWmvyq9bpJL5FqSTcNxrxQAX9hpyU989c2doz1CHMmk5KulOl99VuJSf1JPdiZS2EuMGJnvuk2-tgZzFiK38My96ZVfOuJ'),('ebadaecd0523302e7fbfb72028210f70',1331880836,NULL,'h9j1WYcXNAZ-flYnztLooqPfHmjbzn2skeZqp8uXN8ocB6ab7lmtabRekHCUG_RrbWNbHus9TmA5Q4FQK1GT3sOI_x5hU763XcYNzGZl54ODjAXNCkSo5UKfjcmrVrefDKqU5yPYkkd3v4N6fMV-Ko1pdaZ37zM6tTCFBRBkuJE.'),('277b20a7843e3af1809ceca7504ba28a',1331880839,NULL,'EkQ7nxcPDruDdkhVvKvCkD56oixaEH2n0DRTC3ekjSr9sKQiO-jGEloUtkiiuchlUamHczrervptTykSmtrtMJpi-w_KAhxDFLqrk5JwUqtbuQttOQuTmF9i_2WGQK0ctoWmSgZOX0cfLcHM1zF6Vb5l7kOhBMchsui7B5Ztm0CIfNyWrAKKoaT_lBOC0BeS'),('460a2633cd862456a873733c31f2722a',1331880842,NULL,'byBgTBj-RV8g9luWjMke7FpuFU4o6I_fCTQA1GYER6Wj2uotQM3_CiATKElGlVnK-_XkgaQs6rwDfOWeDWckDrCUqJlm4RBnWhYf_4jAuj3hVLEiyz6opYJ1vajuMcW4gxLPu9zSTVCAlzgwbr4aRHmVYo9c6k6TtJ9e_u_BFs6lAawjCJ64cTuoNrPTVeUl'),('a4eb3d64f86d22a82aab51e1a910f873',1331880845,NULL,'ijc1Fimes6lGrPluKnwz6sI7fc1ZzG0Hc2gudLymn6p8CcJcnw0zWjYaZs3jtnKvB60_V5YkvOzyo0Zs6hzLGfaG-7RkK2NcYr531TMtMS7ychJwJGkGC6JXRMN-22CNFp6UDpgeDCloexzjbZBum3Lnz5fa4w47kbIBqpzT59Q.'),('86a02a95fe3f46b1441660e984dc4cd0',1331880848,NULL,'H8fhPue-O6_1xnF9dXVa0JPAAHGLBpavlIP9axnI9dlnNHGR0JDnehZzENZITW9tyT2p4tY6rDeqwZFgABh7Nx18n-sALdk7QPPIRn2RzhXnAD7r1Qf1XHCviPcs-qnSlrrJtXQRDWjGvfxqSXKDz4xVsyiXBJ4fTWb3sOlwYxZw0Ksw3PHFshp69cQYn0st'),('cd29ebd9b18136f62c70088a8bc53f37',1331880855,NULL,'ZigTTQCMHK5oEFlh7K5L_WOv4HStNuGfOq7s5Zv5er6xVBoVveeW0FP6FYdHwAQaH86hCmNCXM918wd4wJdmpUvFfJG_JlsAATUzehCx7CuPNv5QMpfzBw6CNhydTBWgA3IvliNs2pyeOAFwL43zKSvfFc3l3PFrHtRgbYQ8_QhQoBIgEdj8QWtQf0pS07yc'),('4d71ee6946f36c76483bffe198e06302',1331880858,NULL,'SCOTfxdZxznEwaywgQkGPvxij4UM9UcbxC_pT5WkdT0xliq3ONfPZc_K7owXtXPBjFi7zr0rLkcbW2TJyrIemHJWx01h-EyNfFmmwD2fRnJJu6yAT5w0XfdUbZBytOxekpXs59rU5tb4l-aRv-hhrMfyEL2GixGeJjDpAbc0fpjM21RyfK2aj79kDoBZOnUd'),('a47658b670267294175df7a744d9ead9',1331880865,NULL,'XwcjPZnFMwW7L5EeJmB5QWzUUm37kg0g2ml4POI4ZdaCDQeayoQiRGg0iN7L3_8B-a5zvy-L2JppkPIn-ZqEL6FS9GdkIHFWkFC1QwsDDOQl1RhBPb7xy_4MTZwxXRF4i3iajAVlnsOb--P370axB0d9eOyMrqk94jEGEpqNLK8n51XXBauyEPPA5dhHM4HX'),('c2fba36108cb251b8eee4c99bae0c1ce',1331880870,NULL,'RwgfjZx4mZBHBgqEF2r1DW7oQ-YFVtzJMFZGroYB7Dfsripi1J83ZWRzs9Ysg3eq_BO0o8aPXdlN7Riub2mCCB_HSQ8y77xvjvzGDXXlIQlbjzpsJ1-u3YnuQJ6X8s4ueGFukikZ2Y0IWcoJ_ERgNc27dSuTWFeKlepcAayPF23POcbe5It8QaFx_GEqT16b'),('47fea419bd3504b3db2090a5d20dcccf',1331880874,NULL,'MzX3kzhwgq19m_GzpeTmft617Bj7M9ii2XDHJDUl90LXWAfEWcRPK3S-b8-icOJPf_7t8s0hHMd9ItFxRYlhh4vJDmIGb83GiCZNpvhvB3LdH7hgBBiZMB5kh6y-suAbUDV2nAo7pFTsAg0Uo_T8-VsgakIkA-_YSLNkPGcfWgJJO4MbfRu2BotRCW7MVjaF'),('1d11f11aab53824a154baf9036500dad',1331880879,NULL,'t_rcvsP99R1JUSsVL_Or09D4ShFa3jV-9rYdkYlvQSTsVcocSYW6qI4NQa1xsRHheHu_jpvC7YV9Z-b9GgYKtudEsEGgoz6-9Bz7InmmGwY5bliE5wnqqipQuknASBPQi0d2vW5Jw6I2b7OHPTGtzvo_bEfeRePtZywxiJNoo4igvRpaWBF6518zdHcL3mK3'),('00abe3fd063095729b539732a507c10d',1331880885,NULL,'z8NkgDrEIyTCzMnBfZ7K6ECc5LY6jJApkIR7YL8DaMi7nuaIzgv7nTUYlIV3nqBiOl34KHQnNWUFIi0jeGv0VDQEr65s3mDHyydt_LS3AjF3nI_qVy97TIXRPd2rxM_gqOgDHN_q4RaHDI0o_CWPUzzvYib1xr1K5_B4yxNmKwI.'),('1a5e1ce9c752f90a4cd59acc06b15a66',1331880888,NULL,'S2mGwDcCF2axuGaTF7C1FHkds_ks5U5ZwHSdJ5c8leseIIyyXVnHccSPmmC8HcbtFFi0Hd9mbOlngChxN4jtxVH-Z_Wt8u9JGyUgrm3GD9VfW96ySXAnoCeVJlqIR907nxL_aciwsIDbQxEyDHRXjhk8c5wm_NjXFdyLY5MZU_reO51kS2BGUme-UFpv_dA8'),('3cab3366809c177d6cbf60bf7ca9095d',1331880894,NULL,'T2S0TyJ-LnWy2M4DXDjEc6Nnv5JMU5gevFF8HzbGVWQLbcT1ajiYMvRn89w7SDOXqkUQKFnLUEKljYsmGw_tM116S0bB-V6DbcEadpBMVcWwbZRf2A-9wr3jsY2JE2NJXhpuTlPG6axSf7uUaa2QzWFjZThuu4pOFi3ZNi-JOgmsw4bxADvl6cWog4DXVWXs'),('c69df93f0d2f99c746a866f7c88f1612',1331880902,NULL,'QkWzlCwyd2iIjwrIEKN_U4IqGJpMcs1lvEczYrkk3LYTDPBJvEqD4Zd10bG_-SM4TepUUesqXMTUw6w4QbTTV1jFkF5EUW83L2zB_3yxmtAJr5C3-0gHEpWswy5vxZVirU5ZKig2y13LZ5JI5jzZzl95zSJYAQJgf5jUWYxC_co.'),('068d2affa0b162fa208f9311f5d02e77',1331880905,NULL,'TWtdJzGvuNkMVlgV9G3ZJjAr2JmK-n9YQgQnQgcSJ0bkYoRldD-TrqHrsa-rdMwaq503YNdwIl3Nu8PfJujTE6LKiowcHMohUVdprOaJYmRVDTZVnIRpuFC-gBMPKM3jTg9nV1xnI8QWtpNAhEh4E-jNfABlX7fNfjJ54PLIIgWVz1Q9rx4cc9SxF0DuZ60n'),('dea18a78039a8537f7bd0a5d1a74fa75',1331880909,NULL,'ZH3fL-WXo6me1Nlm-iFrXxhPYs-Z66x8v77oWR35d5ByhIaoxIiDBIoXUIKDjn6e6t5BeBh1yokWtBbe5AnZdbaVBcLiOgWmKb2vIi_x_1_HtJ5fpv6l_ecWOSAOXNvfRvQ-GyOs_emEXYX-8NV47jiI3Siwl78SopovcBOmOpZOigLX5IqF4W3C7nd1ob2M'),('28a1838e5b626cb366bf1cbc0321617a',1331880915,NULL,'RwgfjZx4mZBHBgqEF2r1DW7oQ-YFVtzJMFZGroYB7Dfsripi1J83ZWRzs9Ysg3eq_BO0o8aPXdlN7Riub2mCCB_HSQ8y77xvjvzGDXXlIQlbjzpsJ1-u3YnuQJ6X8s4ueGFukikZ2Y0IWcoJ_ERgNc27dSuTWFeKlepcAayPF23POcbe5It8QaFx_GEqT16b'),('00795cb228f003af69dfa7a2ab8c462b',1331880918,NULL,'XwcjPZnFMwW7L5EeJmB5QWzUUm37kg0g2ml4POI4ZdaCDQeayoQiRGg0iN7L3_8B-a5zvy-L2JppkPIn-ZqEL6FS9GdkIHFWkFC1QwsDDOQl1RhBPb7xy_4MTZwxXRF4i3iajAVlnsOb--P370axB0d9eOyMrqk94jEGEpqNLK8n51XXBauyEPPA5dhHM4HX'),('5c893286b3e5b662c06b8128c6a70e1d',1331880920,NULL,'YVczOE3COGfbxqetlS3icO5Tl607LxJGFiZzeLCzPswmDJdzBaVjeGbyEOePLNZnSQxPyqXS3bayUISwKJgph7-TMifffZCisYkrYATbyi3ihp-z71_ojG3Xz2xJS6apssWfm_P0aJi988U21hmB3BnpX8jtIJAB782xms9q46HCanpENsb6Qsg3W8yFL5Dq'),('5d4fef9f274c50f364684df7dae51ad8',1331880923,NULL,'TWtdJzGvuNkMVlgV9G3ZJjAr2JmK-n9YQgQnQgcSJ0bkYoRldD-TrqHrsa-rdMwaq503YNdwIl3Nu8PfJujTE6LKiowcHMohUVdprOaJYmRVDTZVnIRpuFC-gBMPKM3jTg9nV1xnI8QWtpNAhEh4E-jNfABlX7fNfjJ54PLIIgWVz1Q9rx4cc9SxF0DuZ60n'),('073a54767642f933d81607a571553f27',1331880927,NULL,'JzaqW9Ar0alOhLiqrJPOSkc5ek0JYBKlpXa7Qm8Kbqfzhm9W_TohKhXN4FEXcSMTqiKoMFpUg5qn3BCEayOiAlEL4-8-kPmcHXD08kA96InzEhTM612VlJSxGYH9FaWO20k-clffNVOFOY4Tg9aIYm_HoGY0qYuxMu_7uYpRvOkwACUnFDTfqmPmsr_SyGBp'),('8adb9ee5e0d3137ec788aae3a001181c',1331880933,NULL,'T5OPRA5kUZIVD5wpuICI6-ntRPWrqG7v5JTQiCtiLleP86zkHcrmeXmWCawosKRVVvglr2-k7h4bS8_hIEwV2kL739Rxt4YUWAvaUhunRJbm5_WMtZfBmr-6pOLd5TM_bd8yboYd6uTxQxMQaoQlAijoghob1bY_fnDh2nCP8u2pWdRVHFDajLqAFpI0Jngl'),('49ac3c39b3c11da1c00c273d548f1b63',1331880938,NULL,'Rjf-tdHjPtbjgfzlRNfsHHrvI7FHhVj-QGZ6ojOK7dHoEjJ6mIDhBxfYI-zmQKtaGJVsgwC7slq6_m37Lh51MxCfAxkMOa86ANZmRVNSoX7TLqgDUnLqH0qb9Qs4LdfOtRW09sCnan3vGO-nRR4FpYD1oetsrcXNKxt59J0HuGdudBbULBq4aoIkIRvF6mAx'),('73d6498b37d169194fdfc576ff5502de',1331880943,NULL,'4SaMw1WB86UE_itCIabvbWP9h-EGYax4nhwkIT7WIgm_3Yhp1L8GKf46wLQe_WyXAI9lCsbWMWqLIrEQcO-bp5OTd-3s7r7TPuBJmkLhW0YAWHAwtGebD6ynl3lzk2S_xntakzCIvb_h3O-lgkQSIxdp3L-BpV5xEczuJTnbIDy611w1ZNxaNE05RIyDHCb5'),('ff07786b693f1a242a0d85e5e520e557',1331880949,NULL,'lg327m1YtgMQfjP2K9RF-Tq25HUh9Rc0-4CenEifm8feO1cNf0Idto6bAz-QR6cIlFUePGZYVVxUwQjD1NLski4CXLN3sQVntqLIXWNQWS1mJVYfa4wSrbvGEnQblBNRMxoN0qYVK8-sVhm4fq3r8OmWRFPi2Cr2so4xkjcUdVdH0Fl7UhbIYq2zoPXfEt8N'),('21d239bbfffe19a1de56f222845d8ca7',1331880955,NULL,'BWmVBl9tF_NCuZJBYL8WUXCfJFKCjEOFx9kfvfUYExj2xrgexx453fhVOPBJ5cUBN1Tw0YDWavx3dwgB4kB-URVU5ooLq_XBClgTRJgDmv6pS61CNoeIPQUkYLjg-6Nb0jBAasvOtckcWkfRD_GMGzputwrU7On7xuYeaiZw-VovEA5bKa0B3saPOdjSbKA7'),('476d895a374733250ae6bf6b77932b5c',1331880958,NULL,'PYpaPAZR9JkE3Q6dYrIOV7dfDyXGnz69CiNszRmIcX_wQsZcxrQ5o3vaksp1oIrzg1NPl31Nnv-OMJ_9YCvUhJ8kPK1270xSHXvsjQBARx8zvqKIaAgQl3D4SZORCCEYbsr10sRMHcojXx_gOLLHEmNExfiYqFXuqD34ewraYvjrDSnVyN4N26LWMvjEt-Lw'),('23bcf998e0051c4f2d50ee6497811bb9',1331880961,NULL,'-R2mbby8Wx9TP5AfW3scjwJ-Lz9nhytxiBVcJQM19SJOY6TbjJMSTfsjA0yfLyQ-aUnbljWw3Bx58qliiZT-cd5bwBk4izS9go_uXOnDTD68mJmp67Sm_K1NAS9Wbm9DsDqdj3xx1z3xfMNMrns49BQp-gFSDjwsCUpyMnTUoNT_k7MA_lU1aHpkTIUOKlVD'),('003ef8c8ea73b72cc46b2aa992db1261',1331880966,NULL,'OBUKrHaMy0v-i2QvmcYUcZpbDDPSkb8LCTbMVnarNuFLXfUt5PQETCwrXYHQEecLsbHs2sWJPDUpL3NpXnNDxD4IRk71_hmZH4cYyawJh2hm6jAf82lDfqbm1hQ2DfvYbDEGxRbEqNzPCLlQRA2y8MSsmR69SkDHVbsWTUdPjatfytluJ5kpKtQX9JTg2zqn'),('8300129e7cea74da97490ca193ca3e86',1331880972,NULL,'jCcUzzjIMxmCjGyhdUNszZMRXxGxwK5mLcbMDKNq5FJyZUq1JDvbsN2d5gd9tX3uo8UUbV_d0K_pH6Lm0Fa3I-tq9Od5O0pBIFdzCa9NfQlz5t9To_I0SCD6e-0MMLbekQPtiFi04GC9EM8fuY8817bll0gkTFkIe10S_YezSXWrEDpbuiaFOEREEcwy43Jg'),('6cc8173e969e7741d7e07bab0bb05576',1331880976,NULL,'UIThBmqD_O4fFE9MX_82emeUdPvDapIFC6QXi5XChIIy0JOHQ1gxUFP3_xTC1mXzDONeb8aNS56trKni0t10HcNqpELPRJ7LLnYYX4iPJQO9U3f47jwQzroVBYZ2PhuKvFy9291L3usFOazXdyvbXSE8judteiFp0HpiuVjsQIczUt7NQFoDaON8HDqSxBG8'),('fae0a8bc06b6dc50f4366115a4ea2cf4',1331880980,NULL,'KmIw8bW816UpJW4lm1kcpvoH-6bTpOqeHjpg99L0bWY3b_mTyguK3gOBiyf_O0yxJiF4736kr0cJ_gjPECXjotQhlyJGO0Y8JrwE6OkxFvBG213RhAd7kpdl6ZefFK3ZHqhjvBubZnKdK2udydDJ0ZP2ML2ycnucrHvhT1TB7x4l3e1Hlmh3tB5n6nBVL7SS'),('12d1f5e61f0f7b90c33abac8b8f3b8ca',1331880983,NULL,'YGGgHtkmmfp10pUwpXwM6zVnGJ1TJOlBFjzJjQsIDibn9PubbRryzkEsJybhtOMBI8A1_C3TPGxV9iMKlZp1EDdyNap8p-G71vWUR1qdvzh3azI8GEiVX71ZhlF16edsx-uWwxHnA8UQCtPp3KWro9dm2_71tSpm0FUHuE2HmYObHYno-5hqRVf4Ked1ILW1'),('5a72bf91074291d7809cafe03a3cb5c9',1331881874,NULL,'HdcoxR3QE3sy-4A-c5rIyTUH3lNknGCIvkGMF9jpQWr_m92MO4Jj7fq74aO8o55UzeuulWVvGj9nfzHj0q3DZq4r7j-lrfSRavuPAYIUvIiXDMCLZ6pU_IBvyd7_K3xpuEtT-p4FdlRIqJo61NOmbQ..'),('d24deb9f085f5b8426ab063014d2a223',1331887836,NULL,'MlsfIW7Ant6s8MP20guqTKZim9T1VhhEdOVItCpZ3uJV43o6IsehN8WOPsTgQI1r391DGnEWlQu6tuQcqV5xdks0JAHiEzC6mzV27CR6FXRJbW84MCcNQEdYnIypfUBmPxwQKaMAjKO0v983uScT6o0XIKo8s9bHPOjzti_8CP5iU1AQjkspqDtAdQtwmdkugeLkLrs-DVP4nsVSu51tHA..'),('bf32400f139c2c2ab313c1c53cf6f25c',1331887900,NULL,'P2YA5ljqtOc_7Z1mDyguFDLQjADlL4s66InpXPSR31ErnuTr_LSg5GCNXgIon9tr4qLzN5etcQgItgqedIPD5wHgm6PSy07ou3NieTMXXng-jy5XACVopsXAGXOzg79MRK2nHghbcXmlTAsBmMkgWAXWB_hiVQ57wi5n6cNY9Fs.'),('3cb76346f394ae7b7cbd12e82fd668cb',1331889077,NULL,'M7MyHF5bofzXzh8Ccd5UZbvEnrXvQSApcGrhzsNp0WebwlaaNdN1xrIqWznjD08QVhGcUq64PHLN_J0F6F-gTGM2heXilFNjCm7E9COvq2QciiXncS2heeYRwBOUL-mRMPAr6KxcNuXyNw0zTAVVyQ..'),('83166ae8e5cc97ac881175c958dc734c',1331895306,NULL,'RXOIzsJ0SLQLmSZNcTJGYvnB48MiuqHWe6w_QixXNILmgifJKJ--DSHhP5WySKvipFRfyU0QlNZ5Ukn9cmrAas68FDpIErIJTAlyAHalv6dz5Cdr1z3uy3iM6RFcEvocJM_vzb2MsuSCEtDzUrEZBsLqAzdREjGHuOUUsV8gIfxj6QP3EWMIkImPfpc734UtQj7xjmRM7j7Zj6aicxDz_w..'),('fd558fb85c80b8a3494451155da7410e',1331896283,NULL,'707GHbuDbzLcPV1ZiomKqa_e25G5VDYvgCDMPV9tNYD8niL0g_xCh_9JfRpvUc76tjUZ3Q7xk7L1Qn4n4MUrVX4kuPygSyH4JfYyNLaPzU69rVj31OO44-rg5BiCm5pIepGh5qRNEetE-S4gBs125Q..'),('fc461594c73b24ee2dc034675ef5db95',1331902205,NULL,'udLm3koi96TEOlOl5lHvPVqBE0u6oGJG1C2bkAvDOfqvpe37Xzrd_7OkkaZn9uWsgrx_oYEEPkRz46PVM77KZoVuDNBCr2Gqw4aNJPacl-2BZma7NkCWJRLSuHMpM5upAkZP3TvrUjpJpsQHhe94mgpbpyoAnlacpFhLPEi51b4.'),('566cefe66ed6c681d3907ab75b784b35',1331903552,NULL,'707GHbuDbzLcPV1ZiomKqa_e25G5VDYvgCDMPV9tNYD8niL0g_xCh_9JfRpvUc76tjUZ3Q7xk7L1Qn4n4MUrVX4kuPygSyH4JfYyNLaPzU69rVj31OO44-rg5BiCm5pIepGh5qRNEetE-S4gBs125Q..'),('2dd670c7001a8200c1214b8e72037aa5',1331904974,NULL,'VaVWF7aPs2aEylA7YqOKUQKajL2yhckeACMJdy2sSs33_-S78Y3yB_UjLiV9-XsoIF2oJP6rMbT55KaMlhny__JS74P2WVx91_G_JkGLxvS7UDKEOAzT6FOkqswk6qxdp18DVdqJ_-jgGN0nCCc68rw7ec4sq_DLiFptSH45TWo.'),('95d13c0815d6b2287d034369f11b8347',1331909355,NULL,'nypisPW0_3NiVcTRGznNn1Bz-2jREr5FDdNg0nN6HpXNlcW7qVzGEZEqdwKkPj5ZqK7LmI0H9bfY-zS7w4o6qFIN0AYa2V7lFuf22c1rYs5V41qK_JmI96-NHvaIQlvdRt5tnBNmIG4kyoACL9ab89YyWe4Q527Os0Bxca2YhnPRQ3xEedeUPjgURDt-Vme7l0ge3nBQ_PHYQVQ4L1lhoA..'),('0fffa1ad0def962dd5899395578ad5c8',1331910516,NULL,'N2cxGuyR0bc3oVBnCAZsHyWCqbs8JJ3kDT_dNFwErpWNhaeOAFHNr1DW-eO3MMLBBlmeNm0qT7Ln7Xf6okG8Kv7go-yyLSvQzt8dx9oZ-U8J-cziZknPRbfR43g9e1ngAzluxxz77XN6qq84JaqPjQ..'),('668092a4c684d70fbf90ed4118fd051c',1331910619,NULL,'-6rEGQrCYrFHdKLR1KRYAtcVyXK3aAdGBP3BLiWf1LYouTmv3iPdFCRwxPe7AMFPLL2yy79DGUArDxKOtrWf83SMaitvRDwA1TnGIVVJVDkuRJowsKwgBKIfr-YypGE7gTf9zsDLwoUOos8ffGl_S4AMUsCaf50p8w5n67S4oF7pGsygaUde2-AsdxCFnXmnINImL0Ky8Q8SPYkOxDl7zA..'),('8772e53e514124890fcbb02d73805f5c',1331910851,NULL,'rAveVsAh9qXy2KoyK2-w44GRT94AI5qa9kkPTYbKvMWatG0glcdjOGv4OaKeWcOIWOElAiyV5kEjMYU0m7VnGM7pYoPd_fPAiVZoRIxIuHESFHOH9OhihlgSmyCy2iYTfvMV75S-B3TGc4Xu0-Ddnj9-Wjbzeh1LSm7E8bCKnTA.'),('6b203c9d8b8b3757acd696a2a325182a',1331913365,NULL,'JlgQgqAZZwQMPy58A0LooLpT3M_zGpunqxZijRlaf_wighKaBuxiYHEUrTjNo8lm7sseDNLfiammaSdqZYO6f6sLPATs6djrIJ8WmN40Fbps2RdE06xzBkCAqprZ5Y3faU0gkRPOrtDf-LVA813u72bXwuVxGzT6DWh5pG_huUk.'),('2d0e5292968348a1e1eb3ef43d766c41',1331917959,NULL,'SlRQKy6OLukad9rbGSG6NNG_T0LXD9LzFIYoKxq_ThK8fqfoa2y9dQ16faIrzDb5Gp1Dap1I3JwSeSnwz-PMjupuYqjUkAROYLL5B_F3TST8iQ7e6OEImHf1e8YNo3yVyAFJRIkUiTRQrhtsy41Kcg..'),('e0d63cc2ecc97f24a4e43aa1e86eb25a',1331922225,NULL,'juXueB45ypfhUyZCASjVMtzqq0ovcaClOVeLuksrxxbM1zGUHL4s2O_-XMFTKgmh2ulQKlM0cHyPTosgVQJwcf9L4H90AMQreWXtDgS0VE4xkdfv_rbSkYd-gCJnnuZoW6ZuL8TG_rXTnSVwoAXwJzcJGhC8KyKkG8JIcv9lj5U.'),('cb399f36e24c176e64b7d73c4f150113',1331922576,NULL,'W5s8HJQHdtD72Vz3x9rMFiTDt39yxIQsAI6cmX-zDaIbtvDXELmoBwq_aHRDEjr0ZaRqkRCKubsZhA57XKaK3PHl6ot0hajCKE0M4353uWC4L7XHR6Z6ewraYi5roLF2c6UrM4cYELstL_p_ZMlRnWdRgBeVDXuYqOahsyamtSnN1w74ibIlwgnRfejARPmvwEThtZF-TjfHSAvxeofcsg..'),('880c3b5a69a375922156a95d037c1bc5',1331925057,NULL,'RsCwLJw5Lf1ZYeT37kv_gDo29KJsoShhIkITNYGmncGw_nVYoIYPp0wDtt9bBWpDS1FvOQ0ThGMEQlyUYzGVe1KGVilaHoaAsjTYIGZfKI5W44QlZFbxtISH4S6jxD6qgxKL8Fcjs9ELX1LkQXWRrQ..'),('f1afed9a8fd84db2752f1553d6fd0237',1331928692,NULL,'-c15Uf8aa2fcPafxvvdJw0tWVrAXOhBv6BLP9kyVpRcNovdchEKU_8H8CCky50ak5Q-5HkWfIST8QsxratEK398XohRydAV5At8FYD_C2g21WGi5DOW95O07vLZWutjBPp-f6lwheUmMenZIgrtC2q5aeTukrbC71Gm2FJWRk9Y.'),('dd5a4ba097fb49d86cc3c00749dd9056',1331931173,NULL,'GxLyB0rimWH6_2M-30FaOLrr1cX8_4I7q0G-DbO7ylm9yffkJ6gdm9IJ_RJSoFRFtPQ6mrK5GNveWoNjz1xOeWqOwV1TN0bSdCknAz2fTa5MvFtYYSnQEdSGQTwxvQcardlXbrfq0q8hXj-uqZa6UCHabTApNqnKGOocUZ76wjQ.'),('8867ca20aeed63074de7f50a1823c71f',1331932263,NULL,'nUNG5bwlZFWzt3rkvh_pjpfBifhwj-ohcfpzt4pIu-zmr-DZNyX5u1wFZVLXBrD1wrqr8EU1mnSAXcwLh2tyzniyr-7j0eWyoW2_QmQ4x3GeoazcYd7W7Pkrbi7u0U_vNJPHgy1g522G_AaMjHN0mA..'),('d1ee320d349070ae6ece5eaeab11fb53',1331935231,NULL,'ehEeItJEfgHAytbu68FBCPVJaQTAnnAUWudyZ0X700k_QAt_hvnP-diSDXqQapJdNf-Prq75GzYHmDY_dUKxWQQkb7IbVX4aJq8O6Jt2KNkvNSMu_A6yZTn3gt0XvCjQts7DAnmSewE-_CNn4sW9yrCvL-hB9mcmZP5vs5ydDyvEuWhf6Q2_8j9t9_wRY9vf'),('423c6ebe496f697c9e3213d18b729569',1331939438,NULL,'Nls95ZZwpLD7Q2cDGuMfxwM9eyHabeQLRYrf8gXLafMgI4jr_H7KeWVr5I--ZsR9kB13_t0K6h4KbDRe79K7wN-QEVpOndTuUoeurWarzFJW-quqXmi5kMokQlWeV-dWpM7TUMrn8qag9Zwp7hzAlA..'),('78f3f0e95a3dc0b678156ad34bc5d71e',1331939838,NULL,'t7tz1iC_w5up5djAEA-XtX7OXrIwOdRrLQWejEsE_sNv5uha5BoDV2Zjiuv_MWHIcvGqlwwYoQkvb33XdaT9f410Uux4nEBq4i1PfRTSPGSUObgY4ttGwg9t0JNik-HEwJLaUztoyYOUangluzLA38HjzTqQpxo0q3BAe5veIkUGWw3SVUfs0QIowC4r90XV'),('bdc262d982e681a85937029936f86a24',1331939901,NULL,'vk2SYWLg8kNiB7y6bD-LqgxGWY1Qc4YaFDvzOMTUVDsVroPKI0ZfitEyEOk0hK8thDH6Ps-mJGLilcDPuptR3CtgUYONUr67xh8XXlWAky0lpptt7tqy56B-ZHieUz-2h3BEaADPPIPmfUW-FXwvhSrMNJJKM1elivA5s9IXzSOYudKq6VgnqByCjGG6iNK0E4FBw5Ay9hraJM7kHijpEBC_zTbjg6UAURkiex0BJdHQtGKAyuPmBUSPi7exemuN'),('c200b5dc20280105697d983ff62b100f',1331941180,NULL,'NeYZjy3Htt7WlidGRtRF6TgfxDAEhmDaDDgM9kKNh7J6LmEIJ4aQauA2RA0VMjh-iiPVc9XAeV0KPCh0EfvOw0ipO-oZOg973GN5QzaaFyNXdmPu6kf2MGcXbdt32gZZ-5RBrOVmhDAryX08CaO5a6vXjiorEK4V48JToxwdN_0.'),('e0b93454b4dc1725aad1a6224ae15cac',1331941293,NULL,'19AWxi7hIPMqwRj5OJpexibCiWEXWgovEVPOdltcWr6Q1dNeIMoCz4cxJAEHBbTWYu8jzS5WIulPGjjjH2utv_SNeWd_XjmwbGkAmXZ9JuXQohZ5-p3C_2fPHMQ1H6We7vxrNReiRJylaOt43EKGMzwl8iT0SAhDT96mwOcZ_hE.'),('d2995eb816f4de42c98e46adf29d1cd1',1331945854,NULL,'8thXBr2p5jcwsupJqY8WTahx0ELdtLmlEfDcqasMoYvrtQ8CHSq0qpBnyi2mEAwU8xoXuDXTEuWidF2PZHDmnY79xJpMLKUB0MhpojYFnBtZ8swwaAQV2xC5jPj4-l5fChj_dzIjbjcqKrefq8Z4U4ULSv8GFfRITV24zvNYo2g.'),('e5ce98c2b730984f0d3b40d6ae59fa14',1331946720,NULL,'3Txge8ZV_ylLOYzOxU4BkLbbQGQefMXWe7Xx53CXQgrqSb6jzPIqSt4_LltNc5Bc9YbyuIpvA6K4OsSZQlwWYm_aIeaZzfmpm0DzSCWLsq_TDr3oA7kORBMUO-JT6Xcmm610caxlEdRpkcrCvBSIrQ..'),('67a0bae84a1820d3c375d6f98f7f358b',1331947307,NULL,'8z4MegtRZJieg2rd2_fWfVA1bA1TStyFLBk_B0qWpEMUVZ2bveCaaCfbN2-QJSIJxtSy2qQRj1x2OIv9jL8Rds78VneHv7TT1vY11PhEu5RHVZosaNdEvO1B19FWc2_B9CEySgCavLvuz_RIC4iJAVMp_c6FX8B6pb5pRn887fNPU0LAgX55A3ZRNE2Yab5e'),('30946bbb01a263f5d9a51279a5514056',1331950525,NULL,'UpjdGMNkYZMrDmzqbfzxE6sNxOGTkSy1QW9U81XeV30DEikRtT3X3hlA5GntdHVq2L3TeNYu9CUzt_qOapOgo1OlMyc99rLIDY9TltC6wQ6UPflm4QrveDKvUOjLkhsUuL9s1xNXHrGmgyIo6xhbSPd1kyIDQ97PaBXecsL0-4k.'),('85abff2e1156707a1a0d9b01825de50d',1331953537,NULL,'dHsFdZUn-zB3hdWTxFXDo-849_1_Rwaxgmc4u8a4MCS-ACnbhmzCBUxHwQhOOoDrqPsHSst75C5N_RzorxJ-CPMDlhL-KbTtrHmAwF8hLkHUuj36Btsrw-wt8TeGe7Df-o1Y6HxhcmUHO8K4fR77Yoi9IOCzVG8axjvIioxqdZQ.'),('0f3e138f9942995ecd7a88e094b80f37',1331953794,NULL,'WuEVeJ4a3dNxf9UPIt613XBYZjKQKb5kaTLQmxkcwHAhtn8hxtpE6_1gJyPEY2mTTAP2SV5NJ0obtob-Dq4SiJnDel9ELVUSj2sIKwU-cy8Lf4QiIqNpVNLa1XHpiqT8sG6gVQ8jV5brZa5A72sbpA..'),('09f8e4fe716b50063d686c92ef8c619f',1331955067,NULL,'iS5VyNUKPUkOg6NaK-4npJzZNe8COXgbUxYDtUEK2loskpByOPjDJ22_-t_7hrxmY1h6ZfCF7qX_p5xaq1TxoRnOCz0zM2jZMoB5cluDksw--x83r6CnUFt-Rs-L1OykDHyp7PGAG6FMEQH8-lOJCIkm5kI-VDNrgquGGfJBV8llvWeFkyuf8-r6mOueEeox'),('99819197d429d1c8e5e625689a5e82a8',1331955315,NULL,'_vcLNX-_X5mQtzPWJUsTU4-CFf9enPxK8zbE9XhCWLjsfS2hQ8iWLhxeubKSjNNKrvZ030U-qkS89sMXrtCRwpm5uHLJb66p0PL3kTkjTVrmhG5ZHQlNYd8Vo6z0mu9IDzL2_Anu1KsRDwMVdv73Uf5KD7Ql_C5W4xDxJVpw_Vk.'),('a92ca04f4dcd44fd74ac5661a2bae067',1331961112,NULL,'dTngTPxwmX_U2gsCx-W2ZjCAgukvcZe8xOwnfMEjb6Oc2FAsaKoAdN-BZuEisU6_jJ3y4irwbzTs0rGZzup67o8otSeuZ-xMQGsN5wslN9XfK4YpvSj9SNv0xnUUauyqpnY75IDalsWeZye8EST5rQ..'),('2711ad9340d595489e9238c46c3e63f2',1331967040,NULL,'T44b9hm-v9Z9f9UsZvaFDjvwc9RnRXeIm-kuukgmuk8leTn-Cg-EpbnfNqKzn_zeFYvvA97rYejmxXnivKF43vuJh3-v2r5DIHsXhwIJz6KIOXfYA-LExdlwJlRsi2xKxLqMCwjhGQTfxspCTnQ2s1MnP3WnVB_7Inxha4ahC6I.'),('f49f2a0e7f1bdbfdf79b9a3ef8ce137e',1331968280,NULL,'nPd4071THPSVPB7XB5DUFEaPsvkZtHbDo4aDohlLKVRJitfMcQ6OMfWF7KecHP4bY8ZeHV_14fhvwRScXGnxmR1hz6qLn3DFpT1J8OuSpFdSygmMJM4KKJbir5WQZaOTasLTxqI4WSQ08yfMzZ6-5A..'),('579377f8f696134a0c6e25d18498bfd2',1331971127,NULL,'LnTWTLvVHpfJImrgW-t4qypOWL3SJvyU6L9Ol3S-8WbxxBeERqOyBIpHh3SXZ1UEStAGOHp-hCxFOUrNzfGLv4LR0SlUhAeF-18T5CbcoVh63VB_XMhvGi2z1yl_SmR4tiOXW-KqXC6P3-7Y9mhCwTdFoZw0IPWZ_5AyB134bKw.'),('8b9dea2f0f4723ce535f56cfc9601114',1331971169,NULL,'pgGqagQWkW2wvywxLWQYTHI1IYbX1D8ORawb6VQ_3fHYcTT7zHLCjap6JjDXzTKxxkL8ChEqZsZGBJsn1png52yrbJ-YBW-UG4UpSSjmVRdT7qWbLZq02Z7u2qlT5x8Ygu6-PfpukB0d6q0yPkhBEdkWXS2EvRH-J2C2oGItY70.');

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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


--
-- Table structure for table `idx_users`
--

CREATE TABLE `idx_users` (
  `username` varchar(20) collate latin1_general_ci NOT NULL default '',
  `password` varchar(50) collate latin1_general_ci NOT NULL,
  `name` varchar(50) collate latin1_general_ci default NULL,
  `email` varchar(50) collate latin1_general_ci default NULL,
  `date` date default NULL,
  `status` char(1) collate latin1_general_ci default NULL,
  `vcode` varchar(4) collate latin1_general_ci default NULL,
  `group_id` tinyint(4) default NULL,
  `homepage` varchar(100) collate latin1_general_ci default NULL,
  `icq` varchar(20) collate latin1_general_ci default NULL,
  `aol` varchar(20) collate latin1_general_ci default NULL,
  `yahoo` varchar(20) collate latin1_general_ci default NULL,
  `biography` text collate latin1_general_ci,
  `location` varchar(50) collate latin1_general_ci default NULL,
  `interest` varchar(50) collate latin1_general_ci default NULL,
  `occupation` varchar(50) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `idx_users`
--

INSERT INTO `idx_users` VALUES ('admin','e42b1e838bd251cabe5d5c107b3ddbba','Administrator','kianna.dani@gmail.com','2012-01-18','1','',0,'','','','','','','',''),('pjackygsv','a7f371344ce6a5b299617a7219b82279',NULL,'donovanwalsh425@hotmail.com','2012-02-19','0','8812',2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('aangeliascott','ed65879477403baad10748a88a17326b','','aangeliascott@gmail.com','2012-03-13','1','3120',2,'http://','','','','','','',''),('1simonpeterson1','56fa861e6605dd8f0116fe66ac20705b','','1simonpeterson1@gmail.com','2012-03-13','1','7903',2,'http://','','','','','','','');

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

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

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



