--
-- Host: outhits.org    Database: outhits_indexu
-- ------------------------------------------------------


--
-- 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) DEFAULT NULL,
  `menu_url` varchar(255) DEFAULT NULL,
  `order_number` int(11) DEFAULT NULL,
  PRIMARY KEY (`menu_id`)
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=latin1;

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



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

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

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


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

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

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


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

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

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

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

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

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

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

INSERT INTO `idx_category` VALUES (1,0,'Arts Gallery & Entertainment','','folder.gif','','1',14,'','','0','0','','',0,'',0,0,0,0,0),(2,0,'Automobiles','','folder.gif','','1',40,'','','0','0','','',0,'',0,0,0,0,0),(3,0,'Business & Investment','','folder.gif','','1',147,'','','0','0','','',0,'',0,0,0,0,0),(4,0,'Careers & Recruitment','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(5,0,'Clothing & Designers','','folder.gif','','1',11,'','','0','0','','',0,'',0,0,0,0,0),(6,0,'Communication','','folder.gif','','1',25,'','','0','0','','',0,'',0,0,0,0,0),(7,0,'Computers','','folder.gif','','1',22,'','','0','0','','',0,'',0,0,0,0,0),(8,0,'Construction and Remodeling','','folder.gif','','1',73,'','','0','0','','',0,'',0,0,0,0,0),(9,0,'Dental','','folder.gif','','1',38,'','','0','0','','',0,'',0,0,0,0,0),(10,0,'Education & Colleges','','folder.gif','','1',23,'','','0','0','','',0,'',0,0,0,0,0),(11,0,'Employment & Staffing','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(12,0,'Gifts & Stationery','','folder.gif','','1',24,'','','0','0','','',0,'',0,0,0,0,0),(13,0,'Hardware & Software Systems','','folder.gif','','1',10,'','','0','0','','',0,'',0,0,0,0,0),(14,0,'Health Resources','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(15,0,'Healthcare Services & Products','','folder.gif','','1',168,'','','0','0','','',0,'',0,0,0,0,0),(16,0,'Air Conditioning, Heating & Ventilating','','folder.gif','','1',57,'','','0','0','','',0,'',0,0,0,0,0),(17,0,'Family ,Home & Garden','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(18,0,'Home Improvement','','folder.gif','','1',305,'','','0','0','','',0,'',0,0,0,0,0),(19,0,'Hotels & Motels','','folder.gif','','1',68,'','','0','0','','',0,'',0,0,0,0,0),(20,0,'Insurance','','folder.gif','','1',32,'','','0','0','','',0,'',0,0,0,0,0),(21,0,'Law & Politics','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(22,0,'Lawyers','','folder.gif','','1',163,'','','0','0','','',0,'',0,0,0,0,0),(23,0,'Lifestyle & Relationships','','folder.gif','','1',3,'','','0','0','','',0,'',0,0,0,0,0),(24,0,'Medicine','','folder.gif','','1',12,'','','0','0','','',0,'',0,0,0,0,0),(25,0,'Money & Finance','','folder.gif','','1',15,'','','0','0','','',0,'',0,0,0,0,0),(26,0,'News & Issues','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(27,0,'Plumbing','','folder.gif','','1',46,'','','0','0','','',0,'',0,0,0,0,0),(28,0,'Real Estate','','folder.gif','','1',32,'','','0','0','','',0,'',0,0,0,0,0),(29,0,'Science & Technology','','folder.gif','','1',13,'','','0','0','','',0,'',0,0,0,0,0),(30,0,'SEO & SMO','','folder.gif','','1',24,'','','0','0','','',0,'',0,0,0,0,0),(31,0,'Shopping','','folder.gif','','1',52,'','','0','0','','',0,'',0,0,0,0,0),(32,0,'Sports & Games','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(33,0,'Transportation and Logistics','','folder.gif','','1',40,'','','0','0','','',0,'',0,0,0,0,0),(34,0,'Travel','','folder.gif','','1',18,'','','0','0','','',0,'',0,0,0,0,0),(35,0,'Wedding','','folder.gif','','1',7,'','','0','0','','',0,'',0,0,0,0,0);

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

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

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

INSERT INTO `idx_category_path` VALUES (1,'Arts Gallery & Entertainment','<a href=\"http://outhits.org/arts-gallery-entertainment/\" name=\"cat_1\" style=\"\">Arts Gallery & Entertainment</a>',';0;'),(2,'Automobiles','<a href=\"http://outhits.org/automobiles/\" name=\"cat_2\" style=\"\">Automobiles</a>',';0;'),(3,'Business & Investment','<a href=\"http://outhits.org/business-investment/\" name=\"cat_3\" style=\"\">Business & Investment</a>',';0;'),(4,'Careers & Recruitment','<a href=\"http://outhits.org/careers-recruitment/\" name=\"cat_4\" style=\"\">Careers & Recruitment</a>',';0;'),(5,'Clothing & Designers','<a href=\"http://outhits.org/clothing-designers/\" name=\"cat_5\" style=\"\">Clothing & Designers</a>',';0;'),(6,'Communication','<a href=\"http://outhits.org/communication/\" name=\"cat_6\" style=\"\">Communication</a>',';0;'),(7,'Computers','<a href=\"http://outhits.org/computers/\" name=\"cat_7\" style=\"\">Computers</a>',';0;'),(8,'Construction and Remodeling','<a href=\"http://outhits.org/construction-and-remodeling/\" name=\"cat_8\" style=\"\">Construction and Remodeling</a>',';0;'),(9,'Dental','<a href=\"http://outhits.org/dental/\" name=\"cat_9\" style=\"\">Dental</a>',';0;'),(10,'Education & Colleges','<a href=\"http://outhits.org/education-colleges/\" name=\"cat_10\" style=\"\">Education & Colleges</a>',';0;'),(11,'Employment & Staffing','<a href=\"http://outhits.org/employment-staffing/\" name=\"cat_11\" style=\"\">Employment & Staffing</a>',';0;'),(12,'Gifts & Stationery','<a href=\"http://outhits.org/gifts-stationery/\" name=\"cat_12\" style=\"\">Gifts & Stationery</a>',';0;'),(13,'Hardware & Software Systems','<a href=\"http://outhits.org/hardware-software-systems/\" name=\"cat_13\" style=\"\">Hardware & Software Systems</a>',';0;'),(14,'Health Resources','<a href=\"http://outhits.org/health-resources/\" name=\"cat_14\" style=\"\">Health Resources</a>',';0;'),(15,'Healthcare Services & Products','<a href=\"http://outhits.org/healthcare-services-products/\" name=\"cat_15\" style=\"\">Healthcare Services & Products</a>',';0;'),(16,'Air Conditioning, Heating & Ventilating','<a href=\"http://outhits.org/air-conditioning-heating-ventilating/\" name=\"cat_16\" style=\"\">Air Conditioning, Heating & Ventilating</a>',';0;'),(17,'Family ,Home & Garden','<a href=\"http://outhits.org/family-home-garden/\" name=\"cat_17\" style=\"\">Family ,Home & Garden</a>',';0;'),(18,'Home Improvement','<a href=\"http://outhits.org/home-improvement/\" name=\"cat_18\" style=\"\">Home Improvement</a>',';0;'),(19,'Hotels & Motels','<a href=\"http://outhits.org/hotels-motels/\" name=\"cat_19\" style=\"\">Hotels & Motels</a>',';0;'),(20,'Insurance','<a href=\"http://outhits.org/insurance/\" name=\"cat_20\" style=\"\">Insurance</a>',';0;'),(21,'Law & Politics','<a href=\"http://outhits.org/law-politics/\" name=\"cat_21\" style=\"\">Law & Politics</a>',';0;'),(22,'Lawyers','<a href=\"http://outhits.org/lawyers/\" name=\"cat_22\" style=\"\">Lawyers</a>',';0;'),(23,'Lifestyle & Relationships','<a href=\"http://outhits.org/lifestyle-relationships/\" name=\"cat_23\" style=\"\">Lifestyle & Relationships</a>',';0;'),(24,'Medicine','<a href=\"http://outhits.org/medicine/\" name=\"cat_24\" style=\"\">Medicine</a>',';0;'),(25,'Money & Finance','<a href=\"http://outhits.org/money-finance/\" name=\"cat_25\" style=\"\">Money & Finance</a>',';0;'),(26,'News & Issues','<a href=\"http://outhits.org/news-issues/\" name=\"cat_26\" style=\"\">News & Issues</a>',';0;'),(27,'Plumbing','<a href=\"http://outhits.org/plumbing/\" name=\"cat_27\" style=\"\">Plumbing</a>',';0;'),(28,'Real Estate','<a href=\"http://outhits.org/real-estate/\" name=\"cat_28\" style=\"\">Real Estate</a>',';0;'),(29,'Science & Technology','<a href=\"http://outhits.org/science-technology/\" name=\"cat_29\" style=\"\">Science & Technology</a>',';0;'),(30,'SEO & SMO','<a href=\"http://outhits.org/seo-smo/\" name=\"cat_30\" style=\"\">SEO & SMO</a>',';0;'),(31,'Shopping','<a href=\"http://outhits.org/shopping/\" name=\"cat_31\" style=\"\">Shopping</a>',';0;'),(32,'Sports & Games','<a href=\"http://outhits.org/sports-games/\" name=\"cat_32\" style=\"\">Sports & Games</a>',';0;'),(33,'Transportation and Logistics','<a href=\"http://outhits.org/transportation-and-logistics/\" name=\"cat_33\" style=\"\">Transportation and Logistics</a>',';0;'),(34,'Travel','<a href=\"http://outhits.org/travel/\" name=\"cat_34\" style=\"\">Travel</a>',';0;'),(35,'Wedding','<a href=\"http://outhits.org/wedding/\" name=\"cat_35\" style=\"\">Wedding</a>',';0;');

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

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

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

INSERT INTO `idx_category_suggession` VALUES (1,9,'Dentist Lansdowne VA','LCI Dentistry provides dental care for the entire family and is located in Lansdowne VA. Dr Nik sees all types of patients and performs a wide range of services including Crowns, Bridges, General dental health, porcelain veneers and much more. For information on our practice view our website at www.lcidentist.com','2012-01-05 12:45:16');

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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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



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

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

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

INSERT INTO `idx_favorites` VALUES (1,'mickeyernestb30u11','2011-10-18','My Favorites',NULL),(2,'cesarmelvinr60w53','2011-10-19','My Favorites',NULL),(3,'kraigjasperc70e72','2011-10-31','My Favorites',NULL),(4,'omerdwainf26d61','2011-11-01','My Favorites',NULL);

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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `idx_pagerank` VALUES (10,'g',0,'2011-12-30'),(4,'g',0,'2012-01-08'),(1,'g',0,'2012-02-13'),(11,'g',0,'2012-02-05'),(7,'g',0,'2012-02-13'),(6,'g',0,'2012-01-05'),(9,'g',0,'2012-01-10'),(3,'g',0,'2012-01-10'),(5,'g',0,'2012-01-10'),(8,'g',0,'2012-01-07'),(2,'g',0,'2012-01-06'),(12,'g',0,'2011-11-08'),(41,'g',0,'2011-11-14'),(405,'g',0,'2011-11-14'),(164,'g',0,'2011-11-14'),(189,'g',0,'2011-11-14'),(438,'g',0,'2011-11-14'),(351,'g',0,'2011-11-14'),(381,'g',0,'2011-11-14'),(184,'g',0,'2011-11-14'),(166,'g',0,'2011-11-14'),(208,'g',0,'2011-11-14'),(25,'g',0,'2011-11-14'),(463,'g',0,'2011-11-14'),(238,'g',0,'2011-11-14'),(246,'g',0,'2011-11-14'),(488,'g',0,'2011-11-14'),(338,'g',0,'2011-11-14'),(17,'g',0,'2011-11-14'),(40,'g',0,'2011-11-14'),(36,'g',0,'2011-11-14'),(85,'g',0,'2011-11-14'),(47,'g',0,'2011-11-14'),(80,'g',0,'2011-11-14'),(26,'g',0,'2011-11-14'),(255,'g',0,'2011-11-15'),(16,'g',0,'2011-11-16'),(275,'g',0,'2011-11-16'),(430,'g',0,'2011-11-16'),(283,'g',0,'2011-11-16'),(385,'g',0,'2011-11-16'),(442,'g',0,'2011-11-16'),(84,'g',0,'2011-11-16'),(13,'g',0,'2011-11-16'),(72,'g',0,'2011-11-16'),(15,'g',0,'2011-11-16'),(111,'g',0,'2011-11-16'),(163,'g',0,'2011-11-16'),(121,'g',0,'2011-11-16'),(137,'g',0,'2011-11-16'),(107,'g',0,'2011-11-16'),(131,'g',0,'2011-11-16'),(78,'g',0,'2011-11-17'),(81,'g',0,'2011-11-17'),(20,'g',0,'2011-11-17'),(27,'g',0,'2011-11-17'),(37,'g',0,'2011-11-17'),(14,'g',0,'2011-11-17'),(159,'g',0,'2011-11-17'),(147,'g',0,'2011-11-17'),(103,'g',0,'2011-11-17'),(115,'g',0,'2011-11-17'),(420,'g',0,'2011-11-17'),(390,'g',0,'2011-11-17'),(454,'g',0,'2011-11-17'),(54,'g',0,'2011-11-17'),(24,'g',0,'2011-11-17'),(65,'g',0,'2011-11-17'),(96,'g',0,'2011-11-17'),(38,'g',0,'2011-11-17'),(169,'g',0,'2011-11-17'),(178,'g',0,'2011-11-17'),(182,'g',0,'2011-11-17'),(138,'g',0,'2011-11-17'),(133,'g',0,'2011-11-17'),(21,'g',0,'2011-11-18'),(19,'g',0,'2011-11-18'),(264,'g',0,'2011-11-18'),(361,'g',0,'2011-11-18'),(364,'g',0,'2011-11-18'),(363,'g',0,'2011-11-18'),(366,'g',0,'2011-11-18'),(365,'g',0,'2011-11-18'),(360,'g',0,'2011-11-18'),(367,'g',0,'2011-11-18'),(99,'g',0,'2011-11-18'),(277,'g',0,'2011-11-18'),(101,'g',0,'2011-11-18'),(44,'g',0,'2011-11-18'),(74,'g',0,'2011-11-18'),(45,'g',0,'2011-11-18'),(88,'g',0,'2011-11-18'),(49,'g',0,'2011-11-18'),(89,'g',0,'2011-11-18'),(93,'g',0,'2011-11-18'),(332,'g',0,'2011-11-18'),(148,'g',0,'2011-11-18'),(116,'g',0,'2011-11-18'),(308,'g',0,'2011-11-18'),(52,'g',0,'2011-11-18'),(249,'g',0,'2011-11-18'),(472,'g',0,'2011-11-18'),(391,'g',0,'2011-11-18'),(417,'g',0,'2011-11-18'),(48,'g',0,'2011-11-19'),(485,'g',0,'2011-11-19'),(396,'g',0,'2011-11-19'),(92,'g',0,'2011-11-19'),(64,'g',0,'2011-11-19'),(62,'g',0,'2011-11-19'),(259,'g',0,'2011-11-19'),(372,'g',0,'2011-11-19'),(328,'g',0,'2011-11-19'),(53,'g',0,'2011-11-19'),(43,'g',0,'2011-11-19'),(100,'g',0,'2011-11-19'),(300,'g',0,'2011-11-19'),(22,'g',0,'2011-11-19'),(233,'g',0,'2011-11-19'),(30,'g',0,'2011-11-19'),(105,'g',0,'2011-11-19'),(108,'g',0,'2011-11-19'),(200,'g',0,'2011-11-19'),(113,'g',0,'2011-11-19'),(106,'g',0,'2011-11-19'),(161,'g',0,'2011-11-19'),(440,'g',0,'2011-11-19'),(58,'g',0,'2011-11-19'),(104,'g',0,'2011-11-19'),(455,'g',0,'2011-11-19'),(380,'g',0,'2011-11-19'),(136,'g',0,'2011-11-19'),(110,'g',0,'2011-11-19'),(83,'g',0,'2011-11-19'),(139,'g',0,'2011-11-19'),(63,'g',0,'2011-11-19'),(59,'g',0,'2011-11-19'),(75,'g',0,'2011-11-19'),(61,'g',0,'2011-11-19'),(23,'g',0,'2011-11-19'),(39,'g',0,'2011-11-19'),(42,'g',0,'2011-11-19'),(56,'g',0,'2011-11-19'),(76,'g',0,'2011-11-19'),(60,'g',0,'2011-11-19'),(57,'g',0,'2011-11-19'),(97,'g',0,'2011-11-20'),(18,'g',0,'2011-11-20'),(160,'g',0,'2011-11-20'),(127,'g',0,'2011-11-20'),(146,'g',0,'2011-11-20'),(144,'g',0,'2011-11-20'),(118,'g',0,'2011-11-20'),(172,'g',0,'2011-11-20'),(150,'g',0,'2011-11-20'),(117,'g',0,'2011-11-20'),(46,'g',0,'2011-11-20'),(333,'g',0,'2011-11-20'),(135,'g',0,'2011-11-20'),(185,'g',0,'2011-11-20'),(439,'g',0,'2011-11-20'),(347,'g',0,'2011-11-20'),(453,'g',0,'2011-11-20'),(132,'g',0,'2011-11-20'),(469,'g',0,'2011-11-21'),(87,'g',0,'2011-11-21'),(170,'g',0,'2011-11-21'),(409,'g',0,'2011-11-21'),(325,'g',0,'2011-11-22'),(408,'g',0,'2011-11-22'),(387,'g',0,'2011-11-22'),(412,'g',0,'2011-11-22'),(411,'g',0,'2011-11-22'),(55,'g',0,'2011-11-22'),(410,'g',0,'2011-11-22'),(413,'g',0,'2011-11-22'),(50,'g',0,'2011-11-22'),(123,'g',0,'2011-11-22'),(28,'g',0,'2011-11-22'),(251,'g',0,'2011-11-22'),(112,'g',0,'2011-11-22'),(419,'g',0,'2011-11-22'),(404,'g',0,'2011-11-22'),(426,'g',0,'2011-11-22'),(395,'g',0,'2011-11-22'),(124,'g',0,'2011-11-22'),(95,'g',0,'2011-11-22'),(70,'g',0,'2011-11-22'),(68,'g',0,'2011-11-22'),(212,'g',0,'2011-11-22'),(223,'g',0,'2011-11-22'),(175,'g',0,'2011-11-22'),(34,'g',0,'2011-11-22'),(227,'g',0,'2011-11-22'),(109,'g',0,'2011-11-22'),(219,'g',0,'2011-11-22'),(270,'g',0,'2011-11-22'),(456,'g',0,'2011-11-22'),(29,'g',0,'2011-11-22'),(260,'g',0,'2011-11-22'),(268,'g',0,'2011-11-22'),(471,'g',0,'2011-11-22'),(67,'g',0,'2011-11-23'),(32,'g',0,'2011-11-23'),(443,'g',0,'2011-11-23'),(457,'g',0,'2011-11-23'),(35,'g',0,'2011-11-23'),(66,'g',0,'2011-11-23'),(33,'g',0,'2011-11-23'),(51,'g',0,'2011-11-23'),(31,'g',0,'2011-11-23'),(258,'g',0,'2011-11-23'),(262,'g',0,'2011-11-23'),(140,'g',0,'2011-11-23'),(232,'g',0,'2011-11-23'),(250,'g',0,'2011-11-23'),(434,'g',0,'2011-11-24'),(142,'g',0,'2011-11-24'),(209,'g',0,'2011-11-24'),(224,'g',0,'2011-11-24'),(274,'g',0,'2011-11-24'),(337,'g',0,'2011-11-24'),(205,'g',0,'2011-11-24'),(73,'g',0,'2011-11-24'),(187,'g',0,'2011-11-24'),(128,'g',0,'2011-11-24'),(732,'g',0,'2011-11-28'),(741,'g',0,'2011-11-28'),(987,'g',0,'2011-11-28'),(593,'g',0,'2011-11-28'),(609,'g',0,'2011-11-29'),(621,'g',0,'2011-11-29'),(1059,'g',0,'2011-11-29'),(1217,'g',0,'2011-11-29'),(651,'g',0,'2011-11-29'),(974,'g',0,'2011-11-29'),(965,'g',0,'2011-11-29'),(1014,'g',0,'2011-11-29'),(1098,'g',0,'2011-11-29'),(568,'g',0,'2011-11-29'),(985,'g',0,'2011-11-30'),(719,'g',0,'2011-12-01'),(727,'g',0,'2011-12-01'),(819,'g',0,'2011-12-01'),(1512,'g',0,'2011-12-01'),(736,'g',0,'2011-12-01'),(506,'g',0,'2011-12-01'),(527,'g',0,'2011-12-02'),(613,'g',0,'2011-12-02'),(891,'g',0,'2011-12-02'),(925,'g',0,'2011-12-02'),(960,'g',0,'2011-12-02'),(1041,'g',0,'2011-12-02'),(1042,'g',0,'2011-12-02'),(1087,'g',0,'2011-12-02'),(1040,'g',0,'2011-12-02'),(1820,'g',0,'2011-12-02'),(1672,'g',0,'2011-12-02'),(1044,'g',0,'2011-12-02'),(896,'g',0,'2011-12-02'),(1192,'g',0,'2011-12-02'),(1707,'g',0,'2011-12-02'),(1226,'g',0,'2011-12-02'),(931,'g',0,'2011-12-02'),(885,'g',0,'2011-12-03'),(497,'g',0,'2011-12-03'),(756,'g',0,'2011-12-03'),(764,'g',0,'2011-12-03'),(935,'g',0,'2011-12-03'),(580,'g',0,'2011-12-03'),(582,'g',0,'2011-12-03'),(897,'g',0,'2011-12-03'),(529,'g',0,'2011-12-03'),(539,'g',0,'2011-12-03'),(554,'g',0,'2011-12-04'),(545,'g',0,'2011-12-04'),(740,'g',0,'2011-12-04'),(534,'g',0,'2011-12-04'),(948,'g',0,'2011-12-04'),(1194,'g',0,'2011-12-04'),(1724,'g',0,'2011-12-04'),(1972,'g',0,'2011-12-04'),(1490,'g',0,'2011-12-04'),(714,'g',0,'2011-12-04'),(2307,'g',0,'2012-01-10'),(2982,'g',0,'2011-12-05'),(2329,'g',0,'2011-12-06'),(2941,'g',0,'2012-01-06'),(3085,'g',0,'2011-12-08'),(2748,'g',0,'2011-12-09'),(2925,'g',0,'2011-12-09'),(1995,'g',0,'2011-12-10'),(2818,'g',0,'2012-01-10'),(248,'g',0,'2011-12-10'),(265,'g',0,'2011-12-10'),(252,'g',0,'2011-12-10'),(211,'g',0,'2011-12-10'),(267,'g',0,'2011-12-10'),(207,'g',0,'2011-12-10'),(271,'g',0,'2011-12-10'),(228,'g',0,'2011-12-10'),(263,'g',0,'2011-12-10'),(191,'g',0,'2011-12-10'),(90,'g',0,'2011-12-11'),(86,'g',0,'2011-12-11'),(94,'g',0,'2011-12-11'),(98,'g',0,'2011-12-11'),(143,'g',0,'2011-12-11'),(154,'g',0,'2011-12-11'),(177,'g',0,'2011-12-11'),(134,'g',0,'2011-12-11'),(155,'g',0,'2011-12-11'),(179,'g',0,'2011-12-11'),(285,'g',0,'2011-12-11'),(301,'g',0,'2011-12-11'),(297,'g',0,'2011-12-11'),(313,'g',0,'2011-12-11'),(303,'g',0,'2011-12-11'),(302,'g',0,'2011-12-11'),(304,'g',0,'2011-12-11'),(310,'g',0,'2011-12-11'),(299,'g',0,'2011-12-11'),(298,'g',0,'2011-12-11'),(397,'g',0,'2011-12-11'),(362,'g',0,'2011-12-11'),(382,'g',0,'2011-12-11'),(331,'g',0,'2011-12-11'),(388,'g',0,'2011-12-11'),(416,'g',0,'2011-12-11'),(374,'g',0,'2011-12-11'),(402,'g',0,'2011-12-11'),(348,'g',0,'2011-12-11'),(334,'g',0,'2011-12-11'),(465,'g',0,'2011-12-11'),(474,'g',0,'2011-12-11'),(449,'g',0,'2011-12-11'),(489,'g',0,'2011-12-11'),(445,'g',0,'2011-12-11'),(462,'g',0,'2011-12-11'),(470,'g',0,'2011-12-11'),(498,'g',0,'2011-12-11'),(428,'g',0,'2011-12-11'),(460,'g',0,'2011-12-11'),(881,'g',0,'2011-12-11'),(645,'g',0,'2011-12-11'),(910,'g',0,'2011-12-11'),(689,'g',0,'2011-12-11'),(522,'g',0,'2011-12-11'),(464,'g',0,'2011-12-11'),(849,'g',0,'2011-12-11'),(665,'g',0,'2011-12-11'),(647,'g',0,'2011-12-11'),(670,'g',0,'2011-12-11'),(242,'g',0,'2011-12-11'),(499,'g',0,'2011-12-11'),(244,'g',0,'2011-12-11'),(436,'g',0,'2011-12-11'),(427,'g',0,'2011-12-11'),(448,'g',0,'2011-12-11'),(234,'g',0,'2011-12-11'),(389,'g',0,'2011-12-11'),(398,'g',0,'2011-12-11'),(266,'g',0,'2011-12-11'),(2503,'g',0,'2012-02-13'),(2106,'g',0,'2012-02-15'),(2107,'g',0,'2012-02-15'),(2518,'g',0,'2012-02-15'),(2197,'g',0,'2012-02-16'),(2198,'g',0,'2012-02-13'),(2556,'g',0,'2011-12-12'),(2536,'g',0,'2012-02-13'),(2342,'g',0,'2011-12-12'),(2543,'g',0,'2011-12-12'),(2466,'g',0,'2012-01-24'),(2540,'g',0,'2012-01-24'),(2565,'g',0,'2011-12-12'),(2516,'g',0,'2012-01-24'),(2210,'g',0,'2012-01-24'),(2136,'g',0,'2012-01-24'),(2213,'g',0,'2012-01-24'),(2127,'g',0,'2012-01-24'),(2583,'g',0,'2011-12-12'),(2166,'g',0,'2012-01-24'),(3069,'g',0,'2011-12-12'),(2243,'g',0,'2011-12-13'),(2212,'g',0,'2011-12-13'),(3138,'g',0,'2011-12-13'),(3139,'g',0,'2011-12-13'),(2139,'g',0,'2011-12-13'),(2170,'g',0,'2011-12-13'),(2098,'g',0,'2011-12-13'),(2112,'g',0,'2011-12-13'),(2128,'g',0,'2011-12-13'),(2207,'g',0,'2011-12-13'),(2296,'g',0,'2011-12-13'),(2278,'g',0,'2011-12-13'),(2430,'g',0,'2011-12-13'),(2410,'g',0,'2011-12-13'),(2369,'g',0,'2011-12-13'),(2304,'g',0,'2011-12-13'),(2277,'g',0,'2011-12-13'),(2350,'g',0,'2011-12-13'),(2481,'g',0,'2011-12-13'),(2388,'g',0,'2011-12-13'),(2264,'g',0,'2011-12-13'),(2255,'g',0,'2011-12-13'),(2270,'g',0,'2011-12-13'),(2237,'g',0,'2011-12-13'),(2262,'g',0,'2011-12-13'),(2272,'g',0,'2011-12-13'),(2275,'g',0,'2011-12-13'),(2267,'g',0,'2011-12-13'),(2266,'g',0,'2011-12-13'),(2211,'g',0,'2011-12-13'),(2634,'g',0,'2011-12-13'),(2554,'g',0,'2011-12-13'),(2685,'g',0,'2011-12-13'),(2485,'g',0,'2011-12-13'),(2635,'g',0,'2011-12-14'),(2374,'g',0,'2011-12-14'),(2104,'g',0,'2012-02-13'),(2174,'g',0,'2012-02-13'),(2096,'g',0,'2012-02-15'),(2117,'g',0,'2011-12-14'),(2180,'g',0,'2012-02-15'),(2182,'g',0,'2012-02-15'),(2184,'g',0,'2011-12-14'),(2559,'g',0,'2011-12-14'),(2568,'g',0,'2011-12-14'),(2579,'g',0,'2011-12-14'),(2608,'g',0,'2011-12-14'),(2161,'g',0,'2011-12-14'),(2244,'g',0,'2011-12-14'),(2693,'g',0,'2011-12-14'),(3080,'g',0,'2011-12-14'),(2684,'g',0,'2011-12-14'),(2682,'g',0,'2011-12-14'),(2683,'g',0,'2011-12-14'),(2519,'g',0,'2011-12-14'),(2636,'g',0,'2011-12-14'),(2261,'g',0,'2012-02-15'),(2332,'g',0,'2012-02-16'),(2759,'g',0,'2011-12-14'),(2214,'g',0,'2012-02-15'),(2739,'g',0,'2012-02-15'),(2202,'g',0,'2012-02-15'),(2324,'g',0,'2012-02-13'),(2306,'g',0,'2012-02-15'),(2336,'g',0,'2012-02-15'),(2298,'g',0,'2011-12-15'),(2598,'g',0,'2011-12-15'),(2348,'g',0,'2011-12-15'),(2279,'g',0,'2011-12-15'),(2216,'g',0,'2011-12-15'),(2411,'g',0,'2011-12-15'),(2283,'g',0,'2011-12-15'),(2533,'g',0,'2011-12-15'),(2147,'g',0,'2011-12-15'),(2312,'g',0,'2011-12-15'),(2681,'g',0,'2011-12-15'),(2612,'g',0,'2011-12-15'),(2412,'g',0,'2011-12-15'),(2099,'g',0,'2011-12-15'),(3147,'g',0,'2011-12-15'),(2572,'g',0,'2011-12-15'),(2867,'g',0,'2011-12-15'),(2320,'g',0,'2011-12-15'),(2235,'g',0,'2011-12-16'),(2126,'g',0,'2011-12-16'),(2137,'g',0,'2011-12-16'),(2486,'g',0,'2011-12-16'),(2555,'g',0,'2011-12-16'),(2118,'g',0,'2011-12-16'),(2474,'g',0,'2011-12-16'),(3141,'g',0,'2011-12-16'),(2157,'g',0,'2011-12-16'),(2323,'g',0,'2011-12-16'),(2190,'g',0,'2012-02-13'),(2163,'g',0,'2012-02-15'),(2148,'g',0,'2012-02-13'),(2222,'g',0,'2012-02-15'),(2167,'g',0,'2012-02-15'),(2123,'g',0,'2012-02-15'),(2382,'g',0,'2011-12-16'),(2162,'g',0,'2012-02-13'),(2406,'g',0,'2011-12-16'),(2414,'g',0,'2011-12-16'),(3156,'g',0,'2012-02-14'),(2341,'g',0,'2011-12-17'),(2326,'g',0,'2011-12-17'),(2285,'g',0,'2011-12-17'),(2265,'g',0,'2011-12-17'),(2165,'g',0,'2011-12-17'),(2196,'g',0,'2011-12-17'),(2339,'g',0,'2011-12-17'),(2796,'g',0,'2011-12-17'),(2529,'g',0,'2011-12-17'),(2800,'g',0,'2011-12-17'),(2357,'g',0,'2011-12-17'),(2349,'g',0,'2011-12-17'),(2677,'g',0,'2011-12-17'),(2090,'g',0,'2011-12-17'),(2479,'g',0,'2011-12-17'),(2468,'g',0,'2011-12-17'),(2723,'g',0,'2011-12-17'),(2454,'g',0,'2011-12-17'),(2500,'g',0,'2011-12-17'),(2492,'g',0,'2011-12-17'),(2281,'g',0,'2011-12-17'),(2322,'g',0,'2011-12-18'),(2337,'g',0,'2011-12-18'),(2408,'g',0,'2011-12-18'),(2253,'g',0,'2011-12-18'),(2302,'g',0,'2011-12-18'),(2156,'g',0,'2011-12-18'),(2520,'g',0,'2011-12-18'),(2476,'g',0,'2011-12-18'),(2387,'g',0,'2011-12-18'),(2483,'g',0,'2011-12-18'),(2545,'g',0,'2011-12-18'),(2405,'g',0,'2011-12-18'),(2236,'g',0,'2011-12-18'),(2521,'g',0,'2011-12-18'),(2664,'g',0,'2011-12-18'),(2623,'g',0,'2011-12-18'),(2537,'g',0,'2011-12-18'),(2199,'g',0,'2011-12-18'),(2745,'g',0,'2011-12-18'),(2436,'g',0,'2011-12-18'),(2193,'g',0,'2011-12-18'),(2239,'g',0,'2011-12-18'),(2204,'g',0,'2011-12-18'),(2702,'g',0,'2011-12-18'),(2427,'g',0,'2011-12-18'),(2471,'g',0,'2011-12-18'),(2151,'g',0,'2011-12-18'),(2200,'g',0,'2011-12-18'),(3132,'g',0,'2012-02-16'),(2087,'g',0,'2012-01-17'),(2195,'g',0,'2011-12-18'),(2181,'g',0,'2011-12-18'),(3127,'g',0,'2011-12-18'),(2146,'g',0,'2012-02-13'),(3165,'g',0,'2011-12-18'),(2158,'g',0,'2012-02-13'),(2185,'g',0,'2011-12-18'),(2089,'g',0,'2012-02-15'),(2370,'g',0,'2011-12-18'),(2229,'g',0,'2011-12-18'),(2580,'g',0,'2011-12-18'),(2159,'g',0,'2011-12-18'),(2164,'g',0,'2011-12-18'),(2228,'g',0,'2011-12-18'),(2160,'g',0,'2011-12-18'),(2574,'g',0,'2011-12-18'),(2571,'g',0,'2011-12-18'),(2515,'g',0,'2011-12-18'),(2251,'g',0,'2011-12-18'),(2549,'g',0,'2011-12-18'),(2217,'g',0,'2011-12-18'),(2501,'g',0,'2011-12-18'),(2439,'g',0,'2011-12-18'),(2527,'g',0,'2011-12-18'),(2567,'g',0,'2011-12-18'),(2168,'g',0,'2011-12-18'),(2600,'g',0,'2011-12-18'),(2386,'g',0,'2011-12-18'),(2252,'g',0,'2011-12-18'),(2300,'g',0,'2011-12-18'),(2303,'g',0,'2011-12-18'),(2271,'g',0,'2011-12-18'),(2256,'g',0,'2011-12-18'),(2276,'g',0,'2011-12-18'),(2353,'g',0,'2011-12-18'),(2416,'g',0,'2011-12-18'),(2440,'g',0,'2011-12-18'),(2380,'g',0,'2011-12-18'),(2381,'g',0,'2011-12-18'),(2418,'g',0,'2011-12-18'),(2420,'g',0,'2011-12-18'),(2425,'g',0,'2011-12-18'),(2421,'g',0,'2011-12-18'),(2179,'g',0,'2011-12-18'),(2173,'g',0,'2012-02-17'),(2175,'g',0,'2012-02-15'),(3136,'g',0,'2012-02-15'),(2402,'g',0,'2011-12-18'),(2187,'g',0,'2011-12-18'),(2178,'g',0,'2011-12-18'),(3151,'g',0,'2012-02-15'),(2351,'g',0,'2011-12-18'),(2274,'g',0,'2011-12-18'),(2172,'g',0,'2011-12-18'),(2208,'g',0,'2011-12-18'),(2415,'g',0,'2011-12-18'),(2317,'g',0,'2011-12-18'),(2419,'g',0,'2011-12-18'),(2205,'g',0,'2011-12-19'),(3131,'g',0,'2011-12-19'),(2192,'g',0,'2011-12-19'),(2191,'g',0,'2011-12-19'),(2220,'g',0,'2011-12-20'),(2201,'g',0,'2011-12-20'),(2234,'g',0,'2011-12-20'),(2171,'g',0,'2011-12-20'),(2092,'g',0,'2011-12-20'),(2218,'g',0,'2011-12-20'),(3166,'g',0,'2012-02-14'),(2372,'g',0,'2011-12-22'),(2373,'g',0,'2011-12-22'),(2375,'g',0,'2011-12-22'),(2384,'g',0,'2011-12-22'),(3169,'g',0,'2012-01-24'),(2378,'g',0,'2011-12-22'),(3168,'g',0,'2012-02-13'),(2371,'g',0,'2011-12-22'),(2359,'g',0,'2011-12-23'),(2345,'g',0,'2011-12-23'),(2377,'g',0,'2011-12-23'),(2376,'g',0,'2011-12-23'),(2453,'g',0,'2012-02-13'),(2460,'g',0,'2012-02-15'),(2458,'g',0,'2012-02-15'),(2338,'g',0,'2012-02-15'),(2095,'g',0,'2012-02-13'),(2455,'g',0,'2012-02-13'),(2457,'g',0,'2012-02-15'),(3199,'g',0,'2011-12-23'),(3193,'g',0,'2011-12-23'),(3157,'g',0,'2011-12-23'),(3182,'g',0,'2011-12-23'),(3195,'g',0,'2011-12-23'),(3170,'g',0,'2011-12-23'),(3200,'g',0,'2011-12-23'),(2093,'g',0,'2012-02-13'),(2452,'g',0,'2012-02-15'),(2138,'g',0,'2011-12-23'),(2491,'g',0,'2011-12-24'),(2132,'g',0,'2011-12-24'),(2122,'g',0,'2011-12-24'),(2333,'g',0,'2011-12-24'),(2945,'g',0,'2011-12-24'),(2674,'g',0,'2011-12-24'),(2461,'g',0,'2012-02-13'),(2827,'g',0,'2011-12-24'),(2152,'g',0,'2011-12-24'),(2101,'g',0,'2011-12-24'),(2177,'g',0,'2011-12-24'),(2155,'g',0,'2011-12-24'),(2638,'g',0,'2012-03-04'),(3143,'g',0,'2012-03-04'),(2525,'g',0,'2011-12-24'),(2490,'g',0,'2012-03-04'),(2793,'g',0,'2011-12-24'),(3172,'g',0,'2011-12-24'),(2111,'g',0,'2011-12-24'),(3159,'g',0,'2011-12-24'),(2189,'g',0,'2011-12-24'),(2094,'g',0,'2011-12-24'),(2088,'g',0,'2011-12-24'),(3206,'g',0,'2011-12-25'),(3158,'g',0,'2011-12-25'),(2688,'g',0,'2011-12-26'),(2589,'g',0,'2011-12-26'),(2764,'g',0,'2011-12-26'),(2604,'g',0,'2011-12-26'),(2833,'g',0,'2011-12-26'),(3184,'g',0,'2011-12-26'),(2116,'g',0,'2011-12-27'),(3177,'g',0,'2011-12-27'),(2113,'g',0,'2011-12-27'),(2097,'g',0,'2011-12-27'),(2130,'g',0,'2011-12-27'),(3142,'g',0,'2011-12-27'),(3180,'g',0,'2011-12-27'),(2542,'g',0,'2011-12-27'),(2795,'g',0,'2011-12-27'),(3194,'g',0,'2011-12-27'),(3140,'g',0,'2011-12-27'),(3191,'g',0,'2011-12-27'),(3181,'g',0,'2011-12-27'),(3185,'g',0,'2012-02-13'),(3183,'g',0,'2012-02-13'),(2740,'g',0,'2011-12-27'),(2263,'g',0,'2011-12-27'),(2240,'g',0,'2011-12-27'),(3218,'g',0,'2012-02-13'),(3188,'g',0,'2012-02-13'),(3231,'g',0,'2012-02-15'),(3146,'g',0,'2012-02-15'),(2238,'g',0,'2011-12-27'),(2115,'g',0,'2012-02-15'),(2258,'g',0,'2011-12-27'),(3187,'g',0,'2012-02-13'),(2407,'g',0,'2011-12-28'),(2209,'g',0,'2011-12-28'),(2206,'g',0,'2011-12-28'),(2442,'g',0,'2011-12-28'),(2120,'g',0,'2011-12-28'),(2259,'g',0,'2011-12-28'),(2437,'g',0,'2011-12-28'),(3150,'g',0,'2011-12-28'),(3149,'g',0,'2011-12-28'),(3179,'g',0,'2011-12-28'),(3186,'g',0,'2012-02-16'),(2508,'g',0,'2011-12-28'),(3174,'g',0,'2011-12-28'),(3153,'g',0,'2011-12-28'),(2482,'g',0,'2011-12-28'),(2428,'g',0,'2011-12-28'),(2417,'g',0,'2011-12-28'),(2507,'g',0,'2011-12-28'),(2399,'g',0,'2011-12-28'),(2129,'g',0,'2011-12-28'),(3217,'g',0,'2011-12-29'),(3227,'g',0,'2011-12-29'),(3213,'g',0,'2011-12-29'),(3214,'g',0,'2011-12-29'),(3215,'g',0,'2011-12-29'),(3233,'g',0,'2011-12-29'),(3242,'g',0,'2012-02-14'),(2102,'g',0,'2011-12-29'),(2103,'g',0,'2011-12-30'),(3220,'g',0,'2011-12-30'),(3237,'g',0,'2011-12-30'),(3155,'g',0,'2011-12-30'),(3176,'g',0,'2011-12-30'),(3135,'g',0,'2011-12-30'),(2105,'g',0,'2011-12-30'),(3144,'g',0,'2011-12-30'),(3154,'g',0,'2011-12-30'),(3248,'g',0,'2011-12-30'),(3171,'g',0,'2011-12-31'),(3222,'g',0,'2012-02-13'),(3212,'g',0,'2012-02-16'),(3189,'g',0,'2012-02-15'),(3249,'g',0,'2012-01-01'),(3245,'g',0,'2012-01-01'),(3228,'g',0,'2012-01-02'),(3253,'g',0,'2012-01-02'),(3241,'g',0,'2012-01-02'),(3240,'g',0,'2012-01-02'),(3244,'g',0,'2012-01-02'),(3235,'g',0,'2012-02-13'),(3196,'g',0,'2012-01-02'),(3246,'g',0,'2012-01-02'),(3234,'g',0,'2012-01-02'),(3257,'g',0,'2012-01-02'),(3224,'g',0,'2012-02-15'),(3209,'g',0,'2012-01-02'),(3230,'g',0,'2012-01-02'),(3229,'g',0,'2012-02-15'),(3260,'g',0,'2012-01-03'),(3279,'g',0,'2012-02-13'),(3175,'g',0,'2012-02-15'),(3223,'g',0,'2012-02-16'),(3226,'g',0,'2012-01-03'),(3284,'g',0,'2012-01-04'),(3265,'g',0,'2012-01-04'),(3208,'g',0,'2012-01-04'),(3207,'g',0,'2012-01-04'),(3232,'g',0,'2012-01-04'),(3277,'g',0,'2012-01-04'),(3247,'g',0,'2012-01-04'),(3269,'g',0,'2012-01-04'),(3271,'g',0,'2012-01-04'),(3268,'g',0,'2012-01-04'),(3263,'g',0,'2012-01-05'),(3286,'g',0,'2012-01-05'),(3264,'g',0,'2012-01-05'),(3270,'g',0,'2012-02-15'),(3262,'g',0,'2012-02-15'),(3225,'g',0,'2012-01-05'),(3287,'g',0,'2012-01-05'),(3211,'g',0,'2012-01-05'),(3266,'g',0,'2012-02-15'),(3294,'g',0,'2012-02-15'),(3293,'g',0,'2012-02-13'),(3296,'g',0,'2012-02-15'),(3252,'g',0,'2012-01-06'),(3283,'g',0,'2012-01-06'),(3137,'g',0,'2012-01-06'),(2747,'g',0,'2012-01-06'),(3243,'g',0,'2012-01-06'),(3281,'g',0,'2012-01-06'),(3133,'g',0,'2012-01-06'),(3288,'g',0,'2012-01-06'),(3251,'g',0,'2012-01-06'),(3239,'g',0,'2012-01-06'),(3236,'g',0,'2012-01-06'),(3272,'g',0,'2012-01-06'),(3285,'g',0,'2012-01-07'),(3216,'g',0,'2012-01-07'),(3219,'g',0,'2012-01-07'),(3274,'g',0,'2012-01-07'),(3276,'g',0,'2012-01-07'),(3300,'g',0,'2012-01-07'),(3307,'g',0,'2012-01-07'),(3290,'g',0,'2012-01-07'),(3255,'g',0,'2012-01-07'),(3311,'g',0,'2012-01-07'),(2297,'g',0,'2012-01-07'),(2794,'g',0,'2012-02-15'),(2654,'g',0,'2012-02-13'),(2169,'g',0,'2012-01-07'),(2695,'g',0,'2012-02-16'),(3289,'g',0,'2012-01-07'),(2325,'g',0,'2012-02-13'),(2186,'g',0,'2012-02-13'),(2183,'g',0,'2012-01-07'),(2581,'g',0,'2012-02-13'),(2653,'g',0,'2012-02-15'),(3092,'g',0,'2012-02-15'),(3259,'g',0,'2012-01-07'),(2249,'g',0,'2012-01-07'),(2142,'g',0,'2012-01-07'),(2844,'g',0,'2012-02-15'),(2286,'g',0,'2012-01-07'),(2144,'g',0,'2012-01-07'),(3250,'g',0,'2012-01-07'),(2293,'g',0,'2012-01-07'),(3238,'g',0,'2012-01-07'),(2334,'g',0,'2012-02-15'),(3282,'g',0,'2012-01-07'),(3275,'g',0,'2012-01-08'),(3261,'g',0,'2012-01-08'),(3280,'g',0,'2012-01-09'),(3267,'g',0,'2012-01-09'),(2282,'g',0,'2012-01-09'),(2538,'g',0,'2012-01-09'),(2443,'g',0,'2012-01-09'),(2573,'g',0,'2012-01-09'),(2504,'g',0,'2012-01-09'),(2475,'g',0,'2012-01-09'),(3295,'g',0,'2012-01-09'),(3256,'g',0,'2012-01-09'),(3278,'g',0,'2012-01-09'),(3273,'g',0,'2012-01-09'),(3254,'g',0,'2012-01-09'),(3298,'g',0,'2012-02-15'),(3323,'g',0,'2012-01-09'),(3342,'g',0,'2012-02-16'),(3314,'g',0,'2012-02-16'),(2494,'g',0,'2012-01-10'),(2562,'g',0,'2012-01-10'),(2459,'g',0,'2012-02-21'),(2633,'g',0,'2012-01-10'),(2487,'g',0,'2012-01-10'),(2499,'g',0,'2012-01-10'),(2480,'g',0,'2012-01-10'),(2450,'g',0,'2012-01-10'),(3297,'g',0,'2012-02-13'),(3308,'g',0,'2012-01-11'),(3302,'g',0,'2012-01-11'),(3365,'g',0,'2012-01-11'),(3291,'g',0,'2012-02-15'),(3301,'g',0,'2012-02-15'),(3319,'g',0,'2012-03-04'),(3310,'g',0,'2012-02-13'),(2512,'g',0,'2012-01-12'),(2523,'g',0,'2012-01-12'),(2511,'g',0,'2012-01-12'),(2510,'g',0,'2012-01-12'),(2509,'g',0,'2012-01-12'),(3371,'g',0,'2012-01-13'),(3348,'g',0,'2012-01-14'),(3315,'g',0,'2012-01-15'),(3355,'g',0,'2012-01-15'),(3292,'g',0,'2012-01-15'),(3309,'g',0,'2012-01-15'),(3318,'g',0,'2012-01-15'),(3299,'g',0,'2012-01-15'),(3354,'g',0,'2012-01-15'),(3333,'g',0,'2012-01-15'),(3337,'g',0,'2012-01-15'),(3356,'g',0,'2012-01-15'),(3346,'g',0,'2012-01-15'),(3372,'g',0,'2012-01-15'),(3332,'g',0,'2012-01-15'),(3377,'g',0,'2012-01-15'),(3378,'g',0,'2012-01-15'),(3343,'g',0,'2012-01-15'),(3317,'g',0,'2012-01-16'),(3345,'g',0,'2012-01-16'),(3331,'g',0,'2012-01-16'),(3303,'g',0,'2012-01-16'),(2582,'g',0,'2012-01-16'),(2154,'g',0,'2012-01-16'),(2379,'g',0,'2012-01-16'),(3258,'g',0,'2012-01-16'),(2110,'g',0,'2012-01-16'),(2100,'g',0,'2012-01-16'),(2114,'g',0,'2012-01-16'),(2469,'g',0,'2012-01-16'),(2390,'g',0,'2012-01-16'),(3167,'g',0,'2012-01-16'),(2444,'g',0,'2012-01-16'),(2392,'g',0,'2012-01-16'),(2319,'g',0,'2012-01-16'),(2429,'g',0,'2012-01-16'),(2149,'g',0,'2012-01-17'),(3341,'g',0,'2012-01-17'),(3353,'g',0,'2012-01-17'),(3385,'g',0,'2012-02-16'),(3324,'g',0,'2012-01-17'),(3350,'g',0,'2012-01-17'),(3347,'g',0,'2012-02-16'),(3336,'g',0,'2012-01-17'),(2321,'g',0,'2012-01-17'),(2135,'g',0,'2012-01-17'),(2424,'g',0,'2012-01-17'),(3364,'g',0,'2012-01-17'),(2150,'g',0,'2012-01-17'),(2134,'g',0,'2012-01-17'),(2241,'g',0,'2012-01-17'),(2131,'g',0,'2012-01-17'),(2247,'g',0,'2012-01-17'),(2260,'g',0,'2012-01-17'),(2145,'g',0,'2012-01-20'),(2295,'g',0,'2012-01-20'),(2248,'g',0,'2012-01-20'),(2435,'g',0,'2012-01-21'),(2720,'g',0,'2012-01-21'),(2667,'g',0,'2012-01-21'),(2686,'g',0,'2012-01-21'),(2749,'g',0,'2012-01-21'),(2284,'g',0,'2012-01-21'),(2305,'g',0,'2012-01-21'),(3386,'g',0,'2012-01-21'),(3388,'g',0,'2012-01-21'),(3406,'g',0,'2012-01-21'),(3312,'g',0,'2012-01-21'),(3349,'g',0,'2012-01-21'),(3398,'g',0,'2012-01-21'),(3396,'g',0,'2012-01-21'),(3408,'g',0,'2012-01-21'),(3416,'g',0,'2012-01-21'),(3401,'g',0,'2012-01-21'),(3397,'g',0,'2012-01-21'),(3399,'g',0,'2012-01-21'),(3400,'g',0,'2012-01-21'),(3402,'g',0,'2012-01-21'),(3403,'g',0,'2012-01-21'),(3358,'g',0,'2012-01-21'),(3375,'g',0,'2012-01-21'),(3327,'g',0,'2012-01-21'),(3321,'g',0,'2012-01-21'),(3340,'g',0,'2012-01-21'),(3344,'g',0,'2012-01-21'),(3339,'g',0,'2012-01-21'),(3322,'g',0,'2012-01-21'),(3362,'g',0,'2012-01-21'),(3320,'g',0,'2012-01-21'),(3417,'g',0,'2012-01-21'),(3360,'g',0,'2012-01-22'),(3420,'g',0,'2012-01-22'),(3418,'g',0,'2012-01-22'),(3328,'g',0,'2012-01-22'),(3325,'g',0,'2012-01-22'),(3335,'g',0,'2012-01-22'),(3366,'g',0,'2012-01-22'),(3404,'g',0,'2012-01-22'),(3415,'g',0,'2012-01-22'),(2301,'g',0,'2012-01-22'),(2472,'g',0,'2012-01-22'),(2464,'g',0,'2012-01-22'),(2530,'g',0,'2012-01-22'),(2524,'g',0,'2012-01-22'),(2470,'g',0,'2012-01-22'),(2522,'g',0,'2012-01-22'),(2463,'g',0,'2012-01-22'),(2473,'g',0,'2012-01-22'),(2467,'g',0,'2012-01-22'),(3352,'g',0,'2012-01-22'),(3338,'g',0,'2012-01-22'),(3410,'g',0,'2012-01-22'),(3412,'g',0,'2012-01-22'),(3326,'g',0,'2012-01-22'),(3379,'g',0,'2012-01-22'),(3369,'g',0,'2012-01-22'),(3411,'g',0,'2012-01-22'),(3413,'g',0,'2012-01-22'),(3387,'g',0,'2012-01-22'),(3409,'g',0,'2012-01-22'),(3305,'g',0,'2012-01-22'),(3361,'g',0,'2012-01-22'),(3306,'g',0,'2012-01-22'),(3329,'g',0,'2012-01-22'),(3390,'g',0,'2012-01-22'),(3407,'g',0,'2012-01-22'),(3414,'g',0,'2012-01-22'),(3389,'g',0,'2012-01-23'),(3334,'g',0,'2012-01-23'),(3330,'g',0,'2012-01-24'),(3405,'g',0,'2012-01-25'),(3370,'g',0,'2012-01-28'),(3351,'g',0,'2012-01-29'),(3357,'g',0,'2012-01-29'),(3457,'g',0,'2012-01-30'),(3438,'g',0,'2012-01-31'),(3490,'g',0,'2012-02-04'),(3534,'g',0,'2012-02-05'),(3519,'g',0,'2012-02-07'),(2318,'g',0,'2012-02-07'),(2246,'g',0,'2012-02-07'),(2316,'g',0,'2012-02-07'),(2308,'g',0,'2012-02-07'),(3622,'g',0,'2012-02-13'),(3621,'g',0,'2012-02-13'),(2409,'g',0,'2012-02-13'),(2404,'g',0,'2012-02-13'),(2393,'g',0,'2012-02-13'),(2335,'g',0,'2012-02-14'),(3609,'g',0,'2012-02-14'),(3192,'g',0,'2012-02-14'),(3363,'g',0,'2012-02-14'),(3616,'g',0,'2012-02-14'),(3433,'g',0,'2012-02-14'),(3190,'g',0,'2012-02-14'),(3178,'g',0,'2012-02-14'),(3432,'g',0,'2012-02-14'),(3470,'g',0,'2012-02-14'),(3626,'g',0,'2012-02-14'),(3618,'g',0,'2012-02-14'),(2327,'g',0,'2012-02-14'),(3610,'g',0,'2012-02-14'),(2315,'g',0,'2012-02-14'),(3221,'g',0,'2012-02-14'),(3173,'g',0,'2012-02-14'),(2383,'g',0,'2012-02-14'),(2347,'g',0,'2012-02-14'),(2331,'g',0,'2012-02-14'),(2389,'g',0,'2012-02-14'),(3619,'g',0,'2012-02-16'),(3614,'g',0,'2012-02-17'),(3617,'g',0,'2012-02-17'),(2714,'g',0,'2012-02-17'),(2716,'g',0,'2012-02-17'),(2717,'g',0,'2012-02-17'),(2713,'g',0,'2012-02-17'),(2718,'g',0,'2012-02-17'),(2694,'g',0,'2012-02-17'),(2690,'g',0,'2012-02-17'),(2993,'g',0,'2012-02-17'),(3429,'g',0,'2012-02-17'),(3503,'g',0,'2012-02-17'),(2906,'g',0,'2012-02-17'),(3638,'g',0,'2012-02-19'),(3620,'g',0,'2012-02-19'),(3613,'g',0,'2012-02-20'),(3648,'g',0,'2012-02-20'),(3628,'g',0,'2012-02-21'),(3647,'g',0,'2012-02-23'),(3649,'g',0,'2012-02-23'),(3643,'g',0,'2012-02-23'),(3422,'g',0,'2012-02-23'),(2431,'g',0,'2012-02-24'),(2506,'g',0,'2012-02-24'),(2432,'g',0,'2012-02-24'),(2505,'g',0,'2012-02-24'),(2423,'g',0,'2012-02-24'),(2514,'g',0,'2012-02-24'),(2434,'g',0,'2012-02-24'),(3625,'g',0,'2012-02-24'),(2433,'g',0,'2012-02-24'),(2426,'g',0,'2012-02-24'),(2729,'g',0,'2012-02-24'),(2438,'g',0,'2012-02-24'),(2642,'g',0,'2012-02-24'),(2751,'g',0,'2012-02-24'),(2752,'g',0,'2012-02-24'),(2784,'g',0,'2012-02-24'),(2648,'g',0,'2012-02-24'),(2816,'g',0,'2012-02-24'),(2973,'g',0,'2012-02-24'),(2830,'g',0,'2012-02-24'),(2754,'g',0,'2012-02-24'),(2967,'g',0,'2012-02-24'),(2836,'g',0,'2012-02-24'),(2807,'g',0,'2012-02-24'),(2968,'g',0,'2012-02-24'),(2753,'g',0,'2012-02-25'),(3474,'g',0,'2012-02-25'),(3491,'g',0,'2012-02-25'),(3525,'g',0,'2012-02-25'),(2992,'g',0,'2012-02-25'),(3113,'g',0,'2012-02-25'),(3076,'g',0,'2012-02-25'),(2812,'g',0,'2012-02-25'),(3444,'g',0,'2012-02-25'),(2978,'g',0,'2012-02-25'),(2813,'g',0,'2012-02-25'),(3109,'g',0,'2012-02-25'),(3110,'g',0,'2012-02-25'),(2965,'g',0,'2012-02-25'),(2810,'g',0,'2012-02-25'),(2834,'g',0,'2012-02-25'),(2966,'g',0,'2012-02-25'),(2804,'g',0,'2012-02-25'),(2649,'g',0,'2012-02-25'),(2658,'g',0,'2012-02-25'),(2787,'g',0,'2012-02-25'),(2656,'g',0,'2012-02-25'),(3496,'g',0,'2012-02-26'),(3509,'g',0,'2012-02-26'),(3506,'g',0,'2012-02-26'),(3079,'g',0,'2012-02-26'),(3078,'g',0,'2012-02-26'),(3093,'g',0,'2012-02-26'),(3653,'g',0,'2012-02-26'),(3660,'g',0,'2012-02-26'),(3612,'g',0,'2012-02-26'),(2553,'g',0,'2012-02-26'),(3536,'g',0,'2012-02-26'),(3096,'g',0,'2012-02-26'),(2980,'g',0,'2012-02-26'),(3077,'g',0,'2012-02-26'),(2808,'g',0,'2012-02-26'),(3421,'g',0,'2012-02-26'),(3583,'g',0,'2012-02-26'),(3531,'g',0,'2012-02-26'),(3500,'g',0,'2012-02-26'),(2815,'g',0,'2012-02-26'),(2821,'g',0,'2012-02-26'),(3632,'g',0,'2012-02-26'),(3593,'g',0,'2012-02-26'),(3607,'g',0,'2012-02-26'),(3611,'g',0,'2012-02-26'),(3492,'g',0,'2012-02-26'),(2971,'g',0,'2012-02-26'),(2820,'g',0,'2012-02-26'),(2972,'g',0,'2012-02-26'),(2731,'g',0,'2012-02-26'),(2823,'g',0,'2012-02-26'),(2456,'g',0,'2012-02-26'),(2724,'g',0,'2012-02-26'),(2755,'g',0,'2012-02-26'),(3458,'g',0,'2012-02-26'),(3068,'g',0,'2012-02-26'),(2368,'g',0,'2012-02-26'),(2367,'g',0,'2012-02-26'),(2831,'g',0,'2012-02-26'),(2829,'g',0,'2012-02-26'),(2825,'g',0,'2012-02-26'),(2837,'g',0,'2012-02-26'),(2839,'g',0,'2012-02-26'),(2531,'g',0,'2012-02-26'),(2362,'g',0,'2012-02-26'),(2422,'g',0,'2012-02-26'),(2552,'g',0,'2012-02-26'),(2360,'g',0,'2012-02-26'),(3123,'g',0,'2012-02-26'),(2979,'g',0,'2012-02-26'),(3434,'g',0,'2012-02-26'),(2706,'g',0,'2012-02-26'),(2856,'g',0,'2012-02-26'),(3570,'g',0,'2012-02-26'),(3532,'g',0,'2012-02-26'),(3586,'g',0,'2012-02-26'),(2987,'g',0,'2012-02-26'),(3627,'g',0,'2012-02-26'),(3087,'g',0,'2012-02-26'),(2655,'g',0,'2012-02-26'),(2539,'g',0,'2012-02-26'),(2975,'g',0,'2012-02-26'),(3468,'g',0,'2012-02-26'),(2544,'g',0,'2012-02-26'),(2355,'g',0,'2012-02-26'),(2742,'g',0,'2012-02-26'),(2611,'g',0,'2012-02-26'),(2365,'g',0,'2012-02-26'),(2398,'g',0,'2012-02-26'),(2314,'g',0,'2012-02-26'),(2632,'g',0,'2012-02-26'),(2477,'g',0,'2012-02-26'),(2652,'g',0,'2012-02-26'),(2361,'g',0,'2012-02-26'),(2391,'g',0,'2012-02-26'),(2364,'g',0,'2012-02-26'),(2803,'g',0,'2012-02-26'),(2397,'g',0,'2012-02-26'),(2584,'g',0,'2012-02-26'),(2814,'g',0,'2012-02-26'),(2586,'g',0,'2012-02-26'),(2394,'g',0,'2012-02-26'),(2495,'g',0,'2012-02-26'),(2546,'g',0,'2012-02-26'),(2630,'g',0,'2012-02-26'),(2587,'g',0,'2012-02-26'),(2832,'g',0,'2012-02-26'),(2596,'g',0,'2012-02-26'),(2775,'g',0,'2012-02-26'),(3456,'g',0,'2012-02-26'),(2922,'g',0,'2012-02-26'),(3071,'g',0,'2012-02-26'),(2737,'g',0,'2012-02-26'),(2733,'g',0,'2012-02-26'),(2732,'g',0,'2012-02-26'),(3439,'g',0,'2012-02-26'),(3060,'g',0,'2012-02-26'),(2835,'g',0,'2012-02-26'),(3631,'g',0,'2012-02-26'),(3650,'g',0,'2012-02-26'),(3635,'g',0,'2012-02-26'),(2356,'g',0,'2012-02-26'),(2767,'g',0,'2012-02-26'),(2618,'g',0,'2012-02-26'),(2756,'g',0,'2012-02-26'),(2824,'g',0,'2012-02-26'),(2768,'g',0,'2012-02-26'),(2352,'g',0,'2012-02-26'),(2620,'g',0,'2012-02-26'),(2770,'g',0,'2012-02-26'),(2330,'g',0,'2012-02-26'),(2354,'g',0,'2012-02-26'),(2478,'g',0,'2012-02-26'),(2395,'g',0,'2012-02-26'),(2366,'g',0,'2012-02-26'),(2363,'g',0,'2012-02-26'),(2593,'g',0,'2012-02-26'),(2780,'g',0,'2012-02-26'),(2358,'g',0,'2012-02-26'),(2657,'g',0,'2012-02-26'),(3446,'g',0,'2012-02-26'),(2792,'g',0,'2012-02-26'),(3122,'g',0,'2012-02-26'),(3124,'g',0,'2012-02-26'),(2762,'g',0,'2012-02-26'),(3112,'g',0,'2012-02-26'),(2591,'g',0,'2012-02-26'),(2809,'g',0,'2012-02-27'),(3029,'g',0,'2012-02-27'),(2710,'g',0,'2012-02-27'),(2621,'g',0,'2012-02-27'),(2585,'g',0,'2012-02-27'),(2919,'g',0,'2012-02-27'),(2913,'g',0,'2012-02-27'),(2601,'g',0,'2012-02-27'),(3035,'g',0,'2012-02-27'),(2845,'g',0,'2012-02-27'),(2874,'g',0,'2012-02-27'),(2564,'g',0,'2012-02-27'),(2605,'g',0,'2012-02-27'),(2566,'g',0,'2012-02-27'),(2869,'g',0,'2012-02-27'),(2873,'g',0,'2012-02-27'),(2923,'g',0,'2012-02-27'),(3423,'g',0,'2012-02-27'),(2870,'g',0,'2012-02-27'),(2931,'g',0,'2012-02-27'),(2711,'g',0,'2012-02-27'),(2932,'g',0,'2012-02-27'),(2914,'g',0,'2012-02-27'),(2493,'g',0,'2012-02-27'),(2660,'g',0,'2012-02-27'),(2535,'g',0,'2012-02-27'),(2920,'g',0,'2012-02-27'),(2548,'g',0,'2012-02-27'),(2866,'g',0,'2012-02-27'),(2912,'g',0,'2012-02-27'),(2848,'g',0,'2012-02-27'),(2708,'g',0,'2012-02-27'),(2663,'g',0,'2012-02-27'),(2853,'g',0,'2012-02-27'),(2875,'g',0,'2012-02-27'),(2819,'g',0,'2012-02-27'),(3493,'g',0,'2012-02-27'),(3526,'g',0,'2012-02-27'),(3642,'g',0,'2012-02-27'),(2647,'g',0,'2012-02-27'),(3051,'g',0,'2012-02-27'),(2918,'g',0,'2012-02-27'),(3523,'g',0,'2012-02-27'),(2849,'g',0,'2012-02-27'),(2933,'g',0,'2012-02-27'),(3117,'g',0,'2012-02-27'),(2917,'g',0,'2012-02-27'),(2607,'g',0,'2012-02-27'),(3472,'g',0,'2012-02-27'),(2822,'g',0,'2012-02-27'),(2986,'g',0,'2012-02-27'),(3067,'g',0,'2012-02-27'),(3073,'g',0,'2012-02-27'),(2741,'g',0,'2012-02-27'),(2498,'g',0,'2012-02-27'),(2746,'g',0,'2012-02-27'),(3048,'g',0,'2012-02-27'),(2599,'g',0,'2012-02-27'),(2343,'g',0,'2012-02-27'),(2496,'g',0,'2012-02-27'),(3469,'g',0,'2012-02-27'),(2400,'g',0,'2012-02-27'),(2771,'g',0,'2012-02-27'),(3044,'g',0,'2012-02-27'),(2777,'g',0,'2012-02-27'),(2750,'g',0,'2012-02-27'),(2788,'g',0,'2012-02-27'),(3083,'g',0,'2012-02-27'),(2592,'g',0,'2012-02-27'),(3512,'g',0,'2012-02-27'),(2929,'g',0,'2012-02-27'),(3088,'g',0,'2012-02-27'),(2847,'g',0,'2012-02-27'),(2868,'g',0,'2012-02-27'),(3465,'g',0,'2012-02-27'),(2696,'g',0,'2012-02-27'),(2673,'g',0,'2012-02-27'),(2671,'g',0,'2012-02-27'),(2712,'g',0,'2012-02-27'),(3445,'g',0,'2012-02-27'),(3466,'g',0,'2012-02-27'),(2606,'g',0,'2012-02-27'),(2916,'g',0,'2012-02-27'),(2871,'g',0,'2012-02-27'),(2872,'g',0,'2012-02-27'),(3585,'g',0,'2012-02-27'),(2976,'g',0,'2012-02-27'),(2689,'g',0,'2012-02-27'),(2528,'g',0,'2012-02-27'),(3656,'g',0,'2012-02-27'),(2840,'g',0,'2012-02-27'),(3659,'g',0,'2012-02-27'),(3533,'g',0,'2012-02-27'),(3042,'g',0,'2012-02-27'),(2989,'g',0,'2012-02-27'),(2692,'g',0,'2012-02-27'),(3070,'g',0,'2012-02-27'),(2561,'g',0,'2012-02-27'),(2887,'g',0,'2012-02-27'),(2879,'g',0,'2012-02-27'),(2888,'g',0,'2012-02-27'),(2885,'g',0,'2012-02-27'),(2876,'g',0,'2012-02-27'),(2863,'g',0,'2012-02-27'),(2889,'g',0,'2012-02-27'),(2886,'g',0,'2012-02-27'),(2878,'g',0,'2012-02-27'),(2865,'g',0,'2012-02-27'),(3447,'g',0,'2012-02-27'),(2884,'g',0,'2012-02-27'),(3449,'g',0,'2012-02-27'),(3437,'g',0,'2012-02-27'),(2661,'g',0,'2012-02-27'),(2590,'g',0,'2012-02-27'),(2705,'g',0,'2012-02-27'),(2575,'g',0,'2012-02-27'),(3448,'g',0,'2012-02-27'),(2940,'g',0,'2012-02-27'),(2858,'g',0,'2012-02-27'),(2577,'g',0,'2012-02-27'),(2939,'g',0,'2012-02-27'),(2802,'g',0,'2012-02-27'),(2882,'g',0,'2012-02-27'),(2902,'g',0,'2012-02-27'),(2791,'g',0,'2012-02-27'),(2578,'g',0,'2012-02-27'),(3089,'g',0,'2012-02-27'),(2698,'g',0,'2012-02-27'),(2911,'g',0,'2012-02-27'),(2903,'g',0,'2012-02-27'),(2901,'g',0,'2012-02-27'),(2892,'g',0,'2012-02-27'),(2890,'g',0,'2012-02-27'),(3436,'g',0,'2012-02-27'),(2576,'g',0,'2012-02-27'),(2860,'g',0,'2012-02-27'),(2893,'g',0,'2012-02-27'),(2843,'g',0,'2012-02-27'),(2680,'g',0,'2012-02-27'),(3125,'g',0,'2012-02-27'),(3630,'g',0,'2012-02-27'),(2766,'g',0,'2012-02-27'),(3094,'g',0,'2012-02-27'),(2946,'g',0,'2012-02-27'),(2659,'g',0,'2012-02-27'),(2547,'g',0,'2012-02-27'),(2850,'g',0,'2012-02-27'),(2697,'g',0,'2012-02-27'),(3442,'g',0,'2012-02-27'),(2891,'g',0,'2012-02-27'),(2900,'g',0,'2012-02-27'),(2851,'g',0,'2012-02-27'),(2817,'g',0,'2012-02-27'),(2894,'g',0,'2012-02-27'),(2899,'g',0,'2012-02-27'),(2898,'g',0,'2012-02-27'),(3435,'g',0,'2012-02-27'),(3654,'g',0,'2012-02-27'),(2897,'g',0,'2012-02-27'),(2896,'g',0,'2012-02-27'),(2927,'g',0,'2012-02-27'),(2895,'g',0,'2012-02-27'),(2928,'g',0,'2012-02-27'),(2908,'g',0,'2012-02-27'),(3471,'g',0,'2012-02-27'),(2909,'g',0,'2012-02-27'),(3462,'g',0,'2012-02-27'),(3507,'g',0,'2012-02-27'),(3508,'g',0,'2012-02-27'),(3463,'g',0,'2012-02-27'),(3461,'g',0,'2012-02-27'),(3515,'g',0,'2012-02-27'),(3459,'g',0,'2012-02-27'),(3510,'g',0,'2012-02-27'),(3451,'g',0,'2012-02-27'),(3511,'g',0,'2012-02-27'),(3513,'g',0,'2012-02-27'),(3521,'g',0,'2012-02-27'),(3535,'g',0,'2012-02-27'),(3605,'g',0,'2012-02-27'),(2915,'g',0,'2012-02-27'),(2855,'g',0,'2012-02-27'),(2960,'g',0,'2012-02-27'),(2346,'g',0,'2012-02-27'),(3440,'g',0,'2012-02-27'),(2921,'g',0,'2012-02-27'),(3084,'g',0,'2012-02-27'),(2854,'g',0,'2012-02-27'),(2526,'g',0,'2012-02-27'),(2734,'g',0,'2012-02-27'),(3530,'g',0,'2012-02-27'),(3454,'g',0,'2012-02-27'),(2826,'g',0,'2012-02-27'),(2691,'g',0,'2012-02-27'),(2735,'g',0,'2012-02-27'),(2846,'g',0,'2012-02-27'),(2396,'g',0,'2012-02-27'),(2773,'g',0,'2012-02-27'),(3658,'g',0,'2012-02-27'),(2877,'g',0,'2012-02-27'),(2883,'g',0,'2012-02-27'),(2880,'g',0,'2012-02-27'),(2881,'g',0,'2012-02-27'),(3464,'g',0,'2012-02-27'),(3460,'g',0,'2012-02-27'),(3662,'g',0,'2012-02-28'),(3676,'g',0,'2012-03-05'),(3145,'g',0,'2012-03-05'),(3673,'g',0,'2012-03-06'),(3672,'g',0,'2012-03-06');

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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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



