--
-- Host: webamplified.net    Database: webampli_db
-- ------------------------------------------------------


--
-- 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',42,'','','0','0','','',0,'',0,0,0,0,0),(3,0,'Business & Investment','','folder.gif','','1',146,'','','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',10,'','','0','0','','',0,'',0,0,0,0,0),(6,0,'Communication','','folder.gif','','1',24,'','','0','0','','',0,'',0,0,0,0,0),(7,0,'Computers','','folder.gif','','1',17,'','','0','0','','',0,'',0,0,0,0,0),(8,0,'Construction and Remodeling','','folder.gif','','1',77,'','','0','0','','',0,'',0,0,0,0,0),(9,0,'Dental','','folder.gif','','1',36,'','','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',26,'','','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',170,'','','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',0,'','','0','0','','',0,'',0,0,0,0,0),(18,0,'Home Improvement & Appliances','','folder.gif','','1',298,'','','0','0','','',0,'',0,0,0,0,0),(19,0,'Hotels','','folder.gif','','1',75,'','','0','0','','',0,'',0,0,0,0,0),(20,0,'Insurance Providers','','folder.gif','','1',34,'','','0','0','','',0,'',0,0,0,0,0),(21,0,'Law & Legal','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(22,0,'Lawyers & Attorneys','','folder.gif','','1',162,'','','0','0','','',0,'',0,0,0,0,0),(23,0,'Lifestyle & Society','','folder.gif','','1',4,'','','0','0','','',0,'',0,0,0,0,0),(24,0,'Medicine & Surgery','','folder.gif','','1',12,'','','0','0','','',0,'',0,0,0,0,0),(25,0,'Finance & Investment','','folder.gif','','1',17,'','','0','0','','',0,'',0,0,0,0,0),(26,0,'News & Media','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(27,0,'Plumbing Contractors','','folder.gif','','1',46,'','','0','0','','',0,'',0,0,0,0,0),(28,0,'Real Estate & Property','','folder.gif','','1',31,'','','0','0','','',0,'',0,0,0,0,0),(29,0,'Science','','folder.gif','','1',13,'','','0','0','','',0,'',0,0,0,0,0),(30,0,'SEO ,SMO & PPC','','folder.gif','','1',24,'','','0','0','','',0,'',0,0,0,0,0),(31,0,'Shopping and Sales','','folder.gif','','1',53,'','','0','0','','',0,'',0,0,0,0,0),(32,0,'Sports & Recreation','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(33,0,'Transportation Services','','folder.gif','','1',38,'','','0','0','','',0,'',0,0,0,0,0),(34,0,'Travel & Tour','','folder.gif','','1',18,'','','0','0','','',0,'',0,0,0,0,0),(35,0,'Weddings','','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://www.webamplified.net/arts-gallery-entertainment/\" name=\"cat_1\" style=\"\">Arts Gallery & Entertainment</a>',';0;'),(2,'Automobiles','<a href=\"http://www.webamplified.net/automobiles/\" name=\"cat_2\" style=\"\">Automobiles</a>',';0;'),(3,'Business & Investment','<a href=\"http://www.webamplified.net/business-investment/\" name=\"cat_3\" style=\"\">Business & Investment</a>',';0;'),(4,'Careers & Recruitment','<a href=\"http://www.webamplified.net/careers-recruitment/\" name=\"cat_4\" style=\"\">Careers & Recruitment</a>',';0;'),(5,'Clothing & Designers','<a href=\"http://www.webamplified.net/clothing-designers/\" name=\"cat_5\" style=\"\">Clothing & Designers</a>',';0;'),(6,'Communication','<a href=\"http://www.webamplified.net/communication/\" name=\"cat_6\" style=\"\">Communication</a>',';0;'),(7,'Computers','<a href=\"http://www.webamplified.net/computers/\" name=\"cat_7\" style=\"\">Computers</a>',';0;'),(8,'Construction and Remodeling','<a href=\"http://www.webamplified.net/construction-and-remodeling/\" name=\"cat_8\" style=\"\">Construction and Remodeling</a>',';0;'),(9,'Dental','<a href=\"http://www.webamplified.net/dental/\" name=\"cat_9\" style=\"\">Dental</a>',';0;'),(10,'Education & Colleges','<a href=\"http://www.webamplified.net/education-colleges/\" name=\"cat_10\" style=\"\">Education & Colleges</a>',';0;'),(11,'Employment & Staffing','<a href=\"http://www.webamplified.net/employment-staffing/\" name=\"cat_11\" style=\"\">Employment & Staffing</a>',';0;'),(12,'Gifts & Stationery','<a href=\"http://www.webamplified.net/gifts-stationery/\" name=\"cat_12\" style=\"\">Gifts & Stationery</a>',';0;'),(13,'Hardware & Software Systems','<a href=\"http://www.webamplified.net/hardware-software-systems/\" name=\"cat_13\" style=\"\">Hardware & Software Systems</a>',';0;'),(14,'Health Resources','<a href=\"http://www.webamplified.net/health-resources/\" name=\"cat_14\" style=\"\">Health Resources</a>',';0;'),(15,'Healthcare Services & Products','<a href=\"http://www.webamplified.net/healthcare-services-products/\" name=\"cat_15\" style=\"\">Healthcare Services & Products</a>',';0;'),(16,'Air Conditioning, Heating & Ventilating','<a href=\"http://www.webamplified.net/air-conditioning-heating-ventilating/\" name=\"cat_16\" style=\"\">Air Conditioning, Heating & Ventilating</a>',';0;'),(17,'Family ,Home & Garden','<a href=\"http://www.webamplified.net/family-home-garden/\" name=\"cat_17\" style=\"\">Family ,Home & Garden</a>',';0;'),(18,'Home Improvement & Appliances','<a href=\"http://www.webamplified.net/home-improvement-appliances/\" name=\"cat_18\" style=\"\">Home Improvement & Appliances</a>',';0;'),(19,'Hotels','<a href=\"http://www.webamplified.net/hotels/\" name=\"cat_19\" style=\"\">Hotels</a>',';0;'),(20,'Insurance Providers','<a href=\"http://www.webamplified.net/insurance-providers/\" name=\"cat_20\" style=\"\">Insurance Providers</a>',';0;'),(21,'Law & Legal','<a href=\"http://www.webamplified.net/law-legal/\" name=\"cat_21\" style=\"\">Law & Legal</a>',';0;'),(22,'Lawyers & Attorneys','<a href=\"http://www.webamplified.net/lawyers-attorneys/\" name=\"cat_22\" style=\"\">Lawyers & Attorneys</a>',';0;'),(23,'Lifestyle & Society','<a href=\"http://www.webamplified.net/lifestyle-society/\" name=\"cat_23\" style=\"\">Lifestyle & Society</a>',';0;'),(24,'Medicine & Surgery','<a href=\"http://www.webamplified.net/medicine-surgery/\" name=\"cat_24\" style=\"\">Medicine & Surgery</a>',';0;'),(25,'Finance & Investment','<a href=\"http://www.webamplified.net/finance-investment/\" name=\"cat_25\" style=\"\">Finance & Investment</a>',';0;'),(26,'News & Media','<a href=\"http://www.webamplified.net/news-media/\" name=\"cat_26\" style=\"\">News & Media</a>',';0;'),(27,'Plumbing Contractors','<a href=\"http://www.webamplified.net/plumbing-contractors/\" name=\"cat_27\" style=\"\">Plumbing Contractors</a>',';0;'),(28,'Real Estate & Property','<a href=\"http://www.webamplified.net/real-estate-property/\" name=\"cat_28\" style=\"\">Real Estate & Property</a>',';0;'),(29,'Science','<a href=\"http://www.webamplified.net/science/\" name=\"cat_29\" style=\"\">Science</a>',';0;'),(30,'SEO ,SMO & PPC','<a href=\"http://www.webamplified.net/seo-smo-ppc/\" name=\"cat_30\" style=\"\">SEO ,SMO & PPC</a>',';0;'),(31,'Shopping and Sales','<a href=\"http://www.webamplified.net/shopping-and-sales/\" name=\"cat_31\" style=\"\">Shopping and Sales</a>',';0;'),(32,'Sports & Recreation','<a href=\"http://www.webamplified.net/sports-recreation/\" name=\"cat_32\" style=\"\">Sports & Recreation</a>',';0;'),(33,'Transportation Services','<a href=\"http://www.webamplified.net/transportation-services/\" name=\"cat_33\" style=\"\">Transportation Services</a>',';0;'),(34,'Travel & Tour','<a href=\"http://www.webamplified.net/travel-tour/\" name=\"cat_34\" style=\"\">Travel & Tour</a>',';0;'),(35,'Weddings','<a href=\"http://www.webamplified.net/weddings/\" name=\"cat_35\" style=\"\">Weddings</a>',';0;');

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

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

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

INSERT INTO `idx_category_suggession` VALUES (1,20,'Gina','Suerpbly illuminating data here, thanks!','2011-11-16 14:00:29');

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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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



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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `idx_pagerank` VALUES (4,'g',0,'2012-01-02'),(8,'g',0,'2012-02-27'),(7,'g',0,'2012-02-27'),(5,'g',0,'2011-12-05'),(6,'g',0,'2011-10-27'),(3,'g',0,'2012-02-27'),(2,'g',0,'2011-12-27'),(1,'g',0,'2012-02-27'),(10,'g',0,'2011-11-14'),(121,'g',0,'2011-11-14'),(138,'g',0,'2011-11-14'),(36,'g',0,'2011-11-14'),(393,'g',0,'2012-02-27'),(110,'g',0,'2011-11-14'),(9,'g',0,'2011-11-14'),(521,'g',0,'2012-02-27'),(255,'g',0,'2011-11-15'),(238,'g',0,'2011-11-15'),(538,'g',0,'2012-02-27'),(31,'g',0,'2011-11-17'),(533,'g',0,'2012-02-27'),(313,'g',0,'2012-02-27'),(267,'g',0,'2011-11-17'),(314,'g',0,'2012-02-27'),(43,'g',0,'2011-11-18'),(30,'g',0,'2011-11-18'),(69,'g',0,'2011-11-18'),(352,'g',0,'2012-02-27'),(116,'g',0,'2011-11-18'),(399,'g',0,'2012-02-27'),(266,'g',0,'2011-11-18'),(549,'g',0,'2012-02-27'),(326,'g',0,'2011-12-20'),(550,'g',0,'2012-02-27'),(250,'g',0,'2011-11-18'),(322,'g',0,'2012-02-27'),(353,'g',0,'2012-02-27'),(180,'g',0,'2011-11-18'),(70,'g',0,'2011-11-18'),(143,'g',0,'2011-11-18'),(156,'g',0,'2011-11-18'),(68,'g',0,'2011-11-18'),(289,'g',0,'2011-11-18'),(463,'g',0,'2012-02-27'),(439,'g',0,'2012-02-27'),(244,'g',0,'2011-11-18'),(426,'g',0,'2011-12-18'),(351,'g',0,'2012-02-27'),(221,'g',0,'2011-11-19'),(176,'g',0,'2011-11-19'),(141,'g',0,'2011-11-19'),(229,'g',0,'2011-11-19'),(39,'g',0,'2011-11-19'),(108,'g',0,'2011-11-19'),(119,'g',0,'2011-11-19'),(67,'g',0,'2011-11-19'),(16,'g',0,'2011-11-19'),(424,'g',0,'2012-02-27'),(75,'g',0,'2011-11-19'),(13,'g',0,'2011-11-19'),(25,'g',0,'2011-11-19'),(54,'g',0,'2011-11-19'),(34,'g',0,'2011-11-19'),(38,'g',0,'2011-11-19'),(46,'g',0,'2011-11-19'),(80,'g',0,'2011-11-19'),(24,'g',0,'2011-11-20'),(53,'g',0,'2011-11-20'),(94,'g',0,'2011-11-20'),(172,'g',0,'2011-11-20'),(140,'g',0,'2011-11-20'),(126,'g',0,'2011-11-20'),(23,'g',0,'2011-11-20'),(306,'g',0,'2012-02-27'),(277,'g',0,'2011-11-20'),(560,'g',0,'2012-01-02'),(83,'g',0,'2011-11-20'),(105,'g',0,'2011-11-20'),(144,'g',0,'2011-11-20'),(145,'g',0,'2011-11-20'),(51,'g',0,'2011-11-20'),(61,'g',0,'2011-11-20'),(135,'g',0,'2011-11-20'),(236,'g',0,'2011-11-20'),(281,'g',0,'2011-11-20'),(275,'g',0,'2011-11-20'),(324,'g',0,'2012-02-27'),(334,'g',0,'2012-02-27'),(344,'g',0,'2012-02-27'),(15,'g',0,'2011-11-20'),(128,'g',0,'2011-11-20'),(173,'g',0,'2011-11-20'),(254,'g',0,'2011-11-20'),(260,'g',0,'2011-11-20'),(125,'g',0,'2011-11-20'),(302,'g',0,'2012-02-27'),(298,'g',0,'2012-02-27'),(41,'g',0,'2011-11-20'),(411,'g',0,'2012-02-27'),(456,'g',0,'2012-02-27'),(22,'g',0,'2011-11-20'),(181,'g',0,'2011-11-20'),(185,'g',0,'2011-11-20'),(259,'g',0,'2011-11-20'),(295,'g',0,'2012-02-27'),(305,'g',0,'2012-02-27'),(464,'g',0,'2012-02-27'),(11,'g',0,'2011-11-20'),(19,'g',0,'2011-11-20'),(18,'g',0,'2011-11-20'),(37,'g',0,'2011-11-20'),(40,'g',0,'2011-11-20'),(44,'g',0,'2011-11-20'),(55,'g',0,'2011-11-20'),(12,'g',0,'2011-11-20'),(77,'g',0,'2011-11-20'),(57,'g',0,'2011-11-20'),(292,'g',0,'2011-11-20'),(58,'g',0,'2011-11-20'),(102,'g',0,'2011-11-20'),(468,'g',0,'2012-02-27'),(59,'g',0,'2011-11-20'),(71,'g',0,'2011-11-20'),(111,'g',0,'2011-11-20'),(112,'g',0,'2011-11-20'),(73,'g',0,'2011-11-20'),(139,'g',0,'2011-11-20'),(76,'g',0,'2011-11-20'),(35,'g',0,'2011-11-20'),(81,'g',0,'2011-11-20'),(28,'g',0,'2011-11-20'),(99,'g',0,'2011-11-20'),(107,'g',0,'2011-11-20'),(74,'g',0,'2011-11-20'),(189,'g',0,'2011-11-20'),(249,'g',0,'2011-11-20'),(262,'g',0,'2011-11-20'),(100,'g',0,'2011-11-20'),(103,'g',0,'2011-11-20'),(20,'g',0,'2011-11-20'),(104,'g',0,'2011-11-20'),(42,'g',0,'2011-11-20'),(109,'g',0,'2011-11-20'),(152,'g',0,'2011-11-20'),(183,'g',0,'2011-11-20'),(208,'g',0,'2011-11-20'),(131,'g',0,'2011-11-20'),(369,'g',0,'2012-02-27'),(557,'g',0,'2012-01-09'),(98,'g',0,'2011-11-20'),(48,'g',0,'2011-11-20'),(72,'g',0,'2011-11-20'),(88,'g',0,'2011-11-20'),(87,'g',0,'2011-11-20'),(91,'g',0,'2011-11-20'),(113,'g',0,'2011-11-20'),(132,'g',0,'2011-11-20'),(224,'g',0,'2011-11-20'),(195,'g',0,'2011-11-20'),(212,'g',0,'2011-11-20'),(274,'g',0,'2011-11-20'),(235,'g',0,'2011-11-20'),(251,'g',0,'2011-11-20'),(534,'g',0,'2011-12-28'),(52,'g',0,'2011-11-20'),(60,'g',0,'2011-11-20'),(114,'g',0,'2011-11-20'),(124,'g',0,'2011-11-20'),(127,'g',0,'2011-11-20'),(227,'g',0,'2011-11-20'),(264,'g',0,'2011-11-20'),(248,'g',0,'2011-11-20'),(282,'g',0,'2011-11-20'),(335,'g',0,'2012-02-27'),(63,'g',0,'2011-11-20'),(65,'g',0,'2011-11-20'),(106,'g',0,'2011-11-20'),(93,'g',0,'2011-11-20'),(136,'g',0,'2011-11-20'),(158,'g',0,'2011-11-20'),(165,'g',0,'2011-11-20'),(169,'g',0,'2011-11-20'),(177,'g',0,'2011-11-20'),(518,'g',0,'2012-02-27'),(47,'g',0,'2011-11-20'),(62,'g',0,'2011-11-20'),(330,'g',0,'2012-02-27'),(339,'g',0,'2011-12-22'),(522,'g',0,'2012-02-27'),(537,'g',0,'2012-02-27'),(171,'g',0,'2011-11-20'),(543,'g',0,'2012-02-27'),(56,'g',0,'2011-11-20'),(239,'g',0,'2011-11-20'),(345,'g',0,'2012-02-27'),(430,'g',0,'2011-12-22'),(443,'g',0,'2011-12-22'),(447,'g',0,'2011-12-22'),(453,'g',0,'2011-12-22'),(486,'g',0,'2011-12-22'),(395,'g',0,'2011-12-22'),(154,'g',0,'2011-11-20'),(147,'g',0,'2011-11-20'),(489,'g',0,'2011-12-22'),(422,'g',0,'2011-12-22'),(160,'g',0,'2011-11-20'),(164,'g',0,'2011-11-20'),(170,'g',0,'2011-11-20'),(203,'g',0,'2011-11-20'),(206,'g',0,'2011-11-20'),(246,'g',0,'2011-11-20'),(437,'g',0,'2011-12-22'),(287,'g',0,'2011-11-20'),(258,'g',0,'2011-11-20'),(279,'g',0,'2011-11-20'),(283,'g',0,'2011-11-20'),(278,'g',0,'2011-11-20'),(301,'g',0,'2012-01-22'),(318,'g',0,'2011-12-22'),(327,'g',0,'2011-12-22'),(294,'g',0,'2012-01-22'),(341,'g',0,'2011-12-22'),(342,'g',0,'2011-12-22'),(354,'g',0,'2011-12-22'),(356,'g',0,'2011-12-22'),(357,'g',0,'2011-12-22'),(365,'g',0,'2011-12-22'),(360,'g',0,'2011-12-22'),(364,'g',0,'2011-12-22'),(385,'g',0,'2011-12-22'),(401,'g',0,'2011-11-20'),(359,'g',0,'2011-12-22'),(373,'g',0,'2011-11-20'),(412,'g',0,'2011-11-20'),(86,'g',0,'2011-11-20'),(95,'g',0,'2011-11-21'),(14,'g',0,'2011-11-21'),(96,'g',0,'2011-11-21'),(241,'g',0,'2011-11-21'),(269,'g',0,'2011-11-21'),(115,'g',0,'2011-11-21'),(234,'g',0,'2011-11-21'),(285,'g',0,'2011-11-21'),(256,'g',0,'2011-11-21'),(174,'g',0,'2011-11-21'),(403,'g',0,'2012-02-27'),(406,'g',0,'2012-02-27'),(328,'g',0,'2012-02-27'),(222,'g',0,'2011-11-23'),(123,'g',0,'2011-11-23'),(263,'g',0,'2011-11-23'),(213,'g',0,'2011-11-23'),(120,'g',0,'2011-11-23'),(218,'g',0,'2011-11-24'),(45,'g',0,'2011-11-24'),(381,'g',0,'2011-11-26'),(29,'g',0,'2011-11-27'),(26,'g',0,'2011-11-27'),(33,'g',0,'2011-11-27'),(27,'g',0,'2011-11-27'),(49,'g',0,'2011-11-27'),(21,'g',0,'2011-11-27'),(32,'g',0,'2011-11-27'),(17,'g',0,'2011-11-27'),(898,'g',0,'2012-02-27'),(743,'g',0,'2012-02-27'),(656,'g',0,'2012-03-06'),(949,'g',0,'2012-02-27'),(826,'g',0,'2012-02-27'),(790,'g',0,'2012-02-27'),(665,'g',0,'2012-02-27'),(667,'g',0,'2012-02-27'),(613,'g',0,'2012-01-09'),(638,'g',0,'2012-02-27'),(588,'g',0,'2012-03-05'),(637,'g',0,'2012-02-27'),(663,'g',0,'2012-02-27'),(655,'g',0,'2012-02-27'),(623,'g',0,'2012-02-27'),(824,'g',0,'2012-01-09'),(725,'g',0,'2012-02-27'),(753,'g',0,'2012-02-27'),(742,'g',0,'2012-02-27'),(631,'g',0,'2011-12-01'),(512,'g',0,'2012-02-27'),(609,'g',0,'2011-12-01'),(723,'g',0,'2011-12-01'),(459,'g',0,'2012-02-27'),(607,'g',0,'2011-12-01'),(504,'g',0,'2012-02-27'),(736,'g',0,'2011-12-01'),(709,'g',0,'2011-12-01'),(572,'g',0,'2011-12-01'),(745,'g',0,'2011-12-01'),(852,'g',0,'2012-02-27'),(965,'g',0,'2012-02-27'),(754,'g',0,'2012-02-27'),(630,'g',0,'2011-12-01'),(589,'g',0,'2012-02-27'),(527,'g',0,'2012-02-27'),(633,'g',0,'2012-02-27'),(762,'g',0,'2012-02-27'),(847,'g',0,'2012-02-27'),(933,'g',0,'2012-02-27'),(810,'g',0,'2011-12-08'),(812,'g',0,'2011-12-08'),(818,'g',0,'2011-12-08'),(841,'g',0,'2011-12-08'),(798,'g',0,'2011-12-08'),(867,'g',0,'2011-12-08'),(875,'g',0,'2011-12-08'),(861,'g',0,'2011-12-08'),(868,'g',0,'2011-12-08'),(809,'g',0,'2011-12-08'),(1210,'g',0,'2012-02-27'),(897,'g',0,'2011-12-08'),(1088,'g',0,'2012-02-27'),(773,'g',0,'2012-02-27'),(808,'g',0,'2012-02-27'),(664,'g',0,'2012-02-27'),(899,'g',0,'2012-02-27'),(178,'g',0,'2011-12-10'),(191,'g',0,'2011-12-10'),(175,'g',0,'2011-12-10'),(157,'g',0,'2011-12-10'),(190,'g',0,'2011-12-10'),(197,'g',0,'2011-12-10'),(211,'g',0,'2011-12-10'),(220,'g',0,'2011-12-10'),(186,'g',0,'2011-12-10'),(214,'g',0,'2011-12-10'),(438,'g',0,'2011-12-10'),(372,'g',0,'2011-12-10'),(367,'g',0,'2011-12-10'),(380,'g',0,'2011-12-10'),(417,'g',0,'2011-12-10'),(368,'g',0,'2011-12-10'),(416,'g',0,'2011-12-10'),(405,'g',0,'2011-12-10'),(420,'g',0,'2011-12-10'),(358,'g',0,'2011-12-10'),(308,'g',0,'2011-12-10'),(296,'g',0,'2011-12-10'),(247,'g',0,'2011-12-10'),(317,'g',0,'2011-12-10'),(363,'g',0,'2011-12-10'),(280,'g',0,'2011-12-10'),(329,'g',0,'2011-12-10'),(223,'g',0,'2011-12-10'),(228,'g',0,'2011-12-10'),(233,'g',0,'2011-12-10'),(240,'g',0,'2011-12-10'),(276,'g',0,'2011-12-10'),(268,'g',0,'2011-12-10'),(321,'g',0,'2011-12-10'),(257,'g',0,'2011-12-10'),(243,'g',0,'2011-12-10'),(270,'g',0,'2011-12-10'),(307,'g',0,'2011-12-10'),(337,'g',0,'2011-12-10'),(97,'g',0,'2011-12-10'),(84,'g',0,'2011-12-10'),(85,'g',0,'2011-12-10'),(89,'g',0,'2011-12-10'),(92,'g',0,'2011-12-10'),(134,'g',0,'2011-12-10'),(137,'g',0,'2011-12-10'),(133,'g',0,'2011-12-10'),(155,'g',0,'2011-12-10'),(122,'g',0,'2011-12-10'),(821,'g',0,'2011-12-11'),(1272,'g',0,'2011-12-11'),(1271,'g',0,'2011-12-11'),(1273,'g',0,'2011-12-11'),(1079,'g',0,'2011-12-11'),(689,'g',0,'2011-12-11'),(692,'g',0,'2011-12-11'),(746,'g',0,'2011-12-11'),(770,'g',0,'2011-12-11'),(690,'g',0,'2011-12-11'),(691,'g',0,'2011-12-11'),(747,'g',0,'2011-12-11'),(737,'g',0,'2011-12-11'),(781,'g',0,'2011-12-11'),(748,'g',0,'2011-12-11'),(669,'g',0,'2011-12-12'),(688,'g',0,'2011-12-12'),(619,'g',0,'2011-12-12'),(653,'g',0,'2011-12-12'),(657,'g',0,'2011-12-12'),(668,'g',0,'2011-12-12'),(625,'g',0,'2011-12-12'),(563,'g',0,'2011-12-12'),(687,'g',0,'2011-12-12'),(590,'g',0,'2011-12-12'),(1298,'g',0,'2012-02-27'),(1336,'g',0,'2011-12-12'),(1337,'g',0,'2011-12-12'),(1338,'g',0,'2011-12-12'),(1353,'g',0,'2011-12-12'),(1339,'g',0,'2011-12-12'),(825,'g',0,'2011-12-12'),(924,'g',0,'2012-02-27'),(734,'g',0,'2011-12-12'),(1062,'g',0,'2011-12-12'),(1000,'g',0,'2011-12-12'),(1061,'g',0,'2011-12-12'),(304,'g',0,'2012-02-03'),(1150,'g',0,'2012-02-03'),(1130,'g',0,'2012-02-03'),(1285,'g',0,'2012-02-03'),(397,'g',0,'2011-12-13'),(407,'g',0,'2012-02-27'),(343,'g',0,'2012-02-27'),(531,'g',0,'2012-02-27'),(565,'g',0,'2012-02-27'),(410,'g',0,'2012-02-27'),(731,'g',0,'2012-02-27'),(547,'g',0,'2011-12-13'),(911,'g',0,'2011-12-13'),(934,'g',0,'2011-12-13'),(903,'g',0,'2011-12-13'),(904,'g',0,'2011-12-13'),(886,'g',0,'2011-12-13'),(905,'g',0,'2011-12-13'),(881,'g',0,'2011-12-13'),(942,'g',0,'2011-12-13'),(1145,'g',0,'2011-12-13'),(1005,'g',0,'2011-12-13'),(1116,'g',0,'2011-12-13'),(1135,'g',0,'2011-12-13'),(1209,'g',0,'2011-12-13'),(1107,'g',0,'2011-12-13'),(1168,'g',0,'2011-12-13'),(1149,'g',0,'2011-12-13'),(1354,'g',0,'2011-12-13'),(1343,'g',0,'2011-12-13'),(1142,'g',0,'2011-12-13'),(1355,'g',0,'2011-12-13'),(791,'g',0,'2012-02-27'),(784,'g',0,'2012-02-27'),(804,'g',0,'2011-12-13'),(744,'g',0,'2012-02-27'),(1104,'g',0,'2012-02-27'),(1366,'g',0,'2012-02-27'),(1368,'g',0,'2012-02-27'),(1385,'g',0,'2012-02-27'),(1365,'g',0,'2012-02-27'),(1364,'g',0,'2012-02-27'),(1367,'g',0,'2012-02-27'),(1363,'g',0,'2012-02-27'),(519,'g',0,'2011-12-14'),(561,'g',0,'2011-12-14'),(555,'g',0,'2012-02-27'),(1388,'g',0,'2012-02-27'),(435,'g',0,'2012-02-14'),(386,'g',0,'2011-12-14'),(387,'g',0,'2011-12-14'),(392,'g',0,'2012-02-14'),(1380,'g',0,'2012-02-27'),(466,'g',0,'2012-02-14'),(383,'g',0,'2011-12-14'),(1369,'g',0,'2012-02-27'),(1391,'g',0,'2012-02-03'),(1225,'g',0,'2012-02-27'),(648,'g',0,'2011-12-14'),(889,'g',0,'2012-02-27'),(797,'g',0,'2012-02-27'),(910,'g',0,'2012-02-27'),(722,'g',0,'2012-02-27'),(884,'g',0,'2012-02-27'),(704,'g',0,'2012-02-27'),(832,'g',0,'2012-02-27'),(761,'g',0,'2011-12-14'),(700,'g',0,'2012-02-27'),(558,'g',0,'2011-12-14'),(575,'g',0,'2011-12-14'),(564,'g',0,'2012-02-27'),(418,'g',0,'2012-02-27'),(566,'g',0,'2011-12-14'),(541,'g',0,'2011-12-15'),(520,'g',0,'2012-02-27'),(816,'g',0,'2012-02-27'),(643,'g',0,'2011-12-15'),(651,'g',0,'2012-02-27'),(1399,'g',0,'2011-12-15'),(1109,'g',0,'2012-02-27'),(528,'g',0,'2011-12-15'),(542,'g',0,'2012-02-27'),(562,'g',0,'2011-12-15'),(529,'g',0,'2011-12-15'),(517,'g',0,'2012-02-27'),(379,'g',0,'2012-02-27'),(378,'g',0,'2012-02-27'),(554,'g',0,'2011-12-15'),(297,'g',0,'2012-02-27'),(457,'g',0,'2012-02-27'),(539,'g',0,'2012-02-27'),(398,'g',0,'2012-02-27'),(524,'g',0,'2012-02-27'),(1390,'g',0,'2012-02-27'),(1373,'g',0,'2011-12-15'),(570,'g',0,'2011-12-15'),(574,'g',0,'2012-02-27'),(1389,'g',0,'2012-02-27'),(1411,'g',0,'2012-02-27'),(1408,'g',0,'2012-02-27'),(1372,'g',0,'2011-12-16'),(1412,'g',0,'2012-02-27'),(1374,'g',0,'2011-12-16'),(1379,'g',0,'2012-02-27'),(1405,'g',0,'2012-02-27'),(1324,'g',0,'2011-12-16'),(569,'g',0,'2012-02-27'),(552,'g',0,'2012-02-27'),(573,'g',0,'2012-02-27'),(568,'g',0,'2012-02-27'),(863,'g',0,'2012-02-27'),(1091,'g',0,'2012-02-27'),(1413,'g',0,'2012-02-27'),(1409,'g',0,'2012-02-27'),(293,'g',0,'2012-02-27'),(1401,'g',0,'2012-03-03'),(350,'g',0,'2011-12-19'),(299,'g',0,'2011-12-19'),(388,'g',0,'2012-01-21'),(391,'g',0,'2012-01-21'),(366,'g',0,'2012-01-21'),(402,'g',0,'2012-01-21'),(1074,'g',0,'2011-12-19'),(938,'g',0,'2012-02-27'),(864,'g',0,'2012-02-27'),(819,'g',0,'2012-02-27'),(1093,'g',0,'2012-02-27'),(1269,'g',0,'2012-02-27'),(777,'g',0,'2011-12-19'),(866,'g',0,'2011-12-19'),(892,'g',0,'2011-12-19'),(880,'g',0,'2011-12-19'),(789,'g',0,'2011-12-19'),(909,'g',0,'2011-12-19'),(869,'g',0,'2011-12-19'),(769,'g',0,'2011-12-19'),(838,'g',0,'2011-12-19'),(679,'g',0,'2011-12-19'),(693,'g',0,'2011-12-19'),(682,'g',0,'2011-12-19'),(684,'g',0,'2011-12-19'),(681,'g',0,'2011-12-19'),(680,'g',0,'2011-12-19'),(686,'g',0,'2011-12-19'),(685,'g',0,'2011-12-19'),(683,'g',0,'2011-12-19'),(694,'g',0,'2011-12-19'),(1067,'g',0,'2011-12-19'),(1063,'g',0,'2011-12-19'),(1064,'g',0,'2011-12-19'),(1068,'g',0,'2011-12-19'),(1069,'g',0,'2011-12-19'),(1070,'g',0,'2011-12-19'),(1066,'g',0,'2011-12-19'),(1065,'g',0,'2011-12-19'),(955,'g',0,'2011-12-19'),(956,'g',0,'2012-02-27'),(835,'g',0,'2012-02-27'),(954,'g',0,'2011-12-19'),(885,'g',0,'2012-02-27'),(952,'g',0,'2012-02-27'),(839,'g',0,'2012-02-27'),(953,'g',0,'2012-02-27'),(950,'g',0,'2012-02-27'),(951,'g',0,'2012-02-27'),(1376,'g',0,'2012-02-27'),(1415,'g',0,'2012-02-27'),(1377,'g',0,'2012-02-27'),(505,'g',0,'2012-02-27'),(546,'g',0,'2012-02-27'),(501,'g',0,'2012-02-27'),(1426,'g',0,'2012-02-27'),(677,'g',0,'2011-12-20'),(678,'g',0,'2011-12-20'),(676,'g',0,'2011-12-20'),(670,'g',0,'2011-12-20'),(585,'g',0,'2012-02-27'),(720,'g',0,'2012-02-27'),(708,'g',0,'2012-02-27'),(584,'g',0,'2012-02-27'),(338,'g',0,'2011-12-22'),(323,'g',0,'2011-12-22'),(340,'g',0,'2011-12-22'),(645,'g',0,'2011-12-22'),(674,'g',0,'2011-12-22'),(394,'g',0,'2011-12-22'),(642,'g',0,'2011-12-22'),(603,'g',0,'2011-12-22'),(673,'g',0,'2011-12-22'),(671,'g',0,'2011-12-22'),(594,'g',0,'2011-12-22'),(672,'g',0,'2011-12-22'),(661,'g',0,'2011-12-22'),(1449,'g',0,'2012-02-27'),(429,'g',0,'2011-12-23'),(408,'g',0,'2011-12-23'),(433,'g',0,'2011-12-23'),(427,'g',0,'2011-12-23'),(451,'g',0,'2011-12-23'),(431,'g',0,'2011-12-23'),(436,'g',0,'2011-12-23'),(465,'g',0,'2011-12-23'),(434,'g',0,'2011-12-23'),(428,'g',0,'2011-12-23'),(620,'g',0,'2011-12-23'),(499,'g',0,'2011-12-23'),(606,'g',0,'2011-12-23'),(470,'g',0,'2011-12-23'),(783,'g',0,'2011-12-23'),(624,'g',0,'2011-12-23'),(635,'g',0,'2011-12-23'),(582,'g',0,'2011-12-23'),(628,'g',0,'2011-12-23'),(483,'g',0,'2011-12-23'),(879,'g',0,'2011-12-23'),(854,'g',0,'2011-12-23'),(858,'g',0,'2011-12-23'),(855,'g',0,'2011-12-23'),(940,'g',0,'2011-12-23'),(893,'g',0,'2011-12-23'),(891,'g',0,'2011-12-23'),(915,'g',0,'2011-12-23'),(1099,'g',0,'2011-12-23'),(1437,'g',0,'2011-12-23'),(1464,'g',0,'2011-12-23'),(415,'g',0,'2012-02-27'),(374,'g',0,'2012-02-27'),(331,'g',0,'2012-02-27'),(495,'g',0,'2011-12-23'),(355,'g',0,'2012-02-27'),(371,'g',0,'2012-02-27'),(478,'g',0,'2011-12-23'),(396,'g',0,'2012-02-27'),(370,'g',0,'2012-02-27'),(496,'g',0,'2012-02-27'),(1447,'g',0,'2012-02-27'),(1462,'g',0,'2012-02-27'),(1428,'g',0,'2012-02-27'),(376,'g',0,'2011-12-24'),(419,'g',0,'2011-12-24'),(348,'g',0,'2012-02-27'),(448,'g',0,'2012-02-27'),(441,'g',0,'2012-02-27'),(346,'g',0,'2012-02-27'),(389,'g',0,'2012-02-27'),(1370,'g',0,'2011-12-24'),(1381,'g',0,'2012-02-27'),(1378,'g',0,'2012-02-27'),(500,'g',0,'2011-12-24'),(1453,'g',0,'2012-02-27'),(300,'g',0,'2012-02-27'),(309,'g',0,'2012-02-27'),(1371,'g',0,'2012-02-27'),(498,'g',0,'2012-02-27'),(484,'g',0,'2012-02-27'),(332,'g',0,'2012-02-27'),(310,'g',0,'2012-02-27'),(312,'g',0,'2012-02-27'),(509,'g',0,'2012-02-27'),(481,'g',0,'2011-12-24'),(493,'g',0,'2012-02-27'),(333,'g',0,'2011-12-24'),(362,'g',0,'2012-02-27'),(361,'g',0,'2012-02-27'),(347,'g',0,'2012-02-27'),(315,'g',0,'2012-02-27'),(490,'g',0,'2011-12-24'),(316,'g',0,'2012-02-27'),(349,'g',0,'2012-02-27'),(479,'g',0,'2012-02-27'),(488,'g',0,'2012-02-27'),(384,'g',0,'2012-02-27'),(445,'g',0,'2012-02-27'),(599,'g',0,'2012-02-27'),(600,'g',0,'2012-02-27'),(577,'g',0,'2012-02-27'),(449,'g',0,'2012-02-27'),(462,'g',0,'2012-02-27'),(446,'g',0,'2012-02-27'),(598,'g',0,'2012-02-27'),(597,'g',0,'2012-02-27'),(581,'g',0,'2012-02-27'),(592,'g',0,'2011-12-25'),(432,'g',0,'2011-12-25'),(413,'g',0,'2012-02-27'),(595,'g',0,'2012-02-27'),(444,'g',0,'2012-02-27'),(400,'g',0,'2012-02-27'),(442,'g',0,'2012-02-27'),(621,'g',0,'2012-02-27'),(618,'g',0,'2012-02-27'),(611,'g',0,'2012-02-27'),(601,'g',0,'2012-02-27'),(602,'g',0,'2012-02-27'),(614,'g',0,'2012-02-27'),(640,'g',0,'2012-02-27'),(644,'g',0,'2011-12-25'),(641,'g',0,'2011-12-25'),(626,'g',0,'2012-02-27'),(1358,'g',0,'2012-02-27'),(1441,'g',0,'2012-02-27'),(662,'g',0,'2012-02-27'),(646,'g',0,'2012-02-27'),(658,'g',0,'2012-02-27'),(755,'g',0,'2012-02-27'),(719,'g',0,'2012-02-27'),(735,'g',0,'2011-12-25'),(659,'g',0,'2011-12-25'),(666,'g',0,'2012-02-27'),(760,'g',0,'2012-02-27'),(726,'g',0,'2012-02-27'),(1407,'g',0,'2012-01-26'),(1406,'g',0,'2012-02-27'),(1444,'g',0,'2012-02-27'),(1322,'g',0,'2012-02-27'),(763,'g',0,'2012-02-27'),(1398,'g',0,'2012-02-27'),(1394,'g',0,'2011-12-26'),(1491,'g',0,'2012-02-27'),(698,'g',0,'2012-02-27'),(576,'g',0,'2012-02-27'),(1482,'g',0,'2012-02-27'),(712,'g',0,'2012-02-27'),(713,'g',0,'2012-02-27'),(715,'g',0,'2012-02-21'),(706,'g',0,'2012-02-27'),(707,'g',0,'2011-12-27'),(714,'g',0,'2012-02-27'),(1505,'g',0,'2011-12-27'),(1461,'g',0,'2011-12-27'),(1450,'g',0,'2011-12-27'),(1445,'g',0,'2011-12-27'),(1504,'g',0,'2011-12-27'),(1501,'g',0,'2011-12-27'),(1446,'g',0,'2011-12-27'),(510,'g',0,'2012-02-27'),(1410,'g',0,'2012-02-27'),(1425,'g',0,'2012-02-27'),(1393,'g',0,'2011-12-27'),(1480,'g',0,'2011-12-27'),(1440,'g',0,'2011-12-27'),(1489,'g',0,'2012-02-27'),(1448,'g',0,'2011-12-27'),(1451,'g',0,'2011-12-27'),(1465,'g',0,'2011-12-27'),(1507,'g',0,'2012-02-27'),(1479,'g',0,'2011-12-27'),(1458,'g',0,'2011-12-27'),(1460,'g',0,'2011-12-27'),(311,'g',0,'2012-02-27'),(1454,'g',0,'2012-02-27'),(414,'g',0,'2012-02-27'),(382,'g',0,'2012-02-27'),(303,'g',0,'2012-02-27'),(390,'g',0,'2012-02-27'),(325,'g',0,'2012-02-27'),(472,'g',0,'2012-02-27'),(532,'g',0,'2012-02-27'),(1483,'g',0,'2012-02-27'),(1497,'g',0,'2011-12-27'),(1488,'g',0,'2012-02-27'),(1442,'g',0,'2012-02-27'),(1486,'g',0,'2012-02-27'),(1492,'g',0,'2012-02-27'),(1443,'g',0,'2012-02-27'),(1477,'g',0,'2012-02-27'),(1509,'g',0,'2012-02-03'),(1400,'g',0,'2012-02-03'),(1430,'g',0,'2012-02-03'),(1455,'g',0,'2012-02-27'),(1498,'g',0,'2011-12-28'),(1494,'g',0,'2011-12-28'),(1466,'g',0,'2011-12-28'),(1463,'g',0,'2011-12-28'),(1502,'g',0,'2012-02-27'),(1476,'g',0,'2011-12-28'),(1478,'g',0,'2011-12-28'),(1500,'g',0,'2012-02-27'),(1459,'g',0,'2011-12-28'),(1513,'g',0,'2012-02-27'),(1457,'g',0,'2011-12-29'),(1416,'g',0,'2011-12-29'),(1495,'g',0,'2011-12-29'),(901,'g',0,'2012-02-27'),(941,'g',0,'2011-12-30'),(845,'g',0,'2012-02-27'),(906,'g',0,'2011-12-30'),(1452,'g',0,'2012-02-27'),(1514,'g',0,'2011-12-30'),(1487,'g',0,'2012-02-27'),(1206,'g',0,'2012-02-27'),(1484,'g',0,'2012-02-27'),(1481,'g',0,'2012-01-01'),(1506,'g',0,'2012-02-27'),(1359,'g',0,'2012-01-01'),(1433,'g',0,'2012-02-27'),(1511,'g',0,'2012-02-27'),(1467,'g',0,'2012-02-27'),(1456,'g',0,'2012-02-27'),(1522,'g',0,'2012-02-27'),(1075,'g',0,'2012-02-27'),(1493,'g',0,'2012-02-27'),(1490,'g',0,'2012-02-27'),(654,'g',0,'2012-01-02'),(1503,'g',0,'2012-02-27'),(1148,'g',0,'2012-02-27'),(1231,'g',0,'2012-02-27'),(1158,'g',0,'2012-02-27'),(1275,'g',0,'2012-02-27'),(1218,'g',0,'2012-02-27'),(1230,'g',0,'2012-02-27'),(1265,'g',0,'2012-02-27'),(1159,'g',0,'2012-02-27'),(1496,'g',0,'2012-02-27'),(1439,'g',0,'2012-02-27'),(927,'g',0,'2012-02-27'),(919,'g',0,'2012-01-02'),(937,'g',0,'2012-02-27'),(928,'g',0,'2012-02-27'),(939,'g',0,'2012-02-27'),(921,'g',0,'2012-02-27'),(1147,'g',0,'2012-02-27'),(1146,'g',0,'2012-02-27'),(1103,'g',0,'2012-02-27'),(1101,'g',0,'2012-02-27'),(918,'g',0,'2012-02-27'),(914,'g',0,'2012-02-27'),(916,'g',0,'2012-02-27'),(925,'g',0,'2012-01-02'),(1499,'g',0,'2012-01-02'),(1519,'g',0,'2012-02-27'),(1528,'g',0,'2012-02-27'),(1523,'g',0,'2012-02-27'),(1518,'g',0,'2012-02-27'),(857,'g',0,'2012-01-02'),(1290,'g',0,'2012-01-02'),(1485,'g',0,'2012-02-27'),(1524,'g',0,'2012-02-27'),(1564,'g',0,'2012-01-03'),(1556,'g',0,'2012-02-27'),(1551,'g',0,'2012-02-27'),(1541,'g',0,'2012-02-27'),(1553,'g',0,'2012-02-27'),(1529,'g',0,'2012-02-27'),(1548,'g',0,'2012-02-27'),(1562,'g',0,'2012-02-27'),(1561,'g',0,'2012-02-27'),(1582,'g',0,'2012-02-27'),(1538,'g',0,'2012-02-27'),(1539,'g',0,'2012-02-27'),(1578,'g',0,'2012-02-27'),(1566,'g',0,'2012-01-07'),(1536,'g',0,'2012-02-27'),(1585,'g',0,'2012-02-27'),(1537,'g',0,'2012-02-27'),(1526,'g',0,'2012-02-27'),(1545,'g',0,'2012-02-27'),(1572,'g',0,'2012-02-27'),(1568,'g',0,'2012-02-27'),(1547,'g',0,'2012-02-27'),(1567,'g',0,'2012-02-27'),(1510,'g',0,'2012-02-27'),(1575,'g',0,'2012-02-27'),(1540,'g',0,'2012-02-27'),(1544,'g',0,'2012-02-27'),(1549,'g',0,'2012-01-09'),(1517,'g',0,'2012-02-27'),(1579,'g',0,'2012-02-27'),(1573,'g',0,'2012-01-09'),(1574,'g',0,'2012-02-27'),(1515,'g',0,'2012-01-09'),(1527,'g',0,'2012-02-27'),(1525,'g',0,'2012-01-09'),(1555,'g',0,'2012-02-27'),(1563,'g',0,'2012-02-27'),(553,'g',0,'2012-01-09'),(551,'g',0,'2012-01-09'),(530,'g',0,'2012-01-09'),(523,'g',0,'2012-01-09'),(516,'g',0,'2012-01-09'),(506,'g',0,'2012-01-09'),(511,'g',0,'2012-01-09'),(526,'g',0,'2012-01-09'),(503,'g',0,'2012-01-09'),(540,'g',0,'2012-01-09'),(497,'g',0,'2012-01-09'),(461,'g',0,'2012-01-09'),(480,'g',0,'2012-01-09'),(494,'g',0,'2012-01-09'),(473,'g',0,'2012-01-09'),(469,'g',0,'2012-01-09'),(440,'g',0,'2012-01-09'),(458,'g',0,'2012-01-09'),(474,'g',0,'2012-01-09'),(1581,'g',0,'2012-02-16'),(1520,'g',0,'2012-02-16'),(1552,'g',0,'2012-02-16'),(1580,'g',0,'2012-02-16'),(1512,'g',0,'2012-02-27'),(1531,'g',0,'2012-01-09'),(1387,'g',0,'2012-01-09'),(1414,'g',0,'2012-01-09'),(1427,'g',0,'2012-01-09'),(1583,'g',0,'2012-02-27'),(1577,'g',0,'2012-01-09'),(1532,'g',0,'2012-02-27'),(1535,'g',0,'2012-02-27'),(604,'g',0,'2012-01-10'),(596,'g',0,'2012-02-27'),(615,'g',0,'2012-02-27'),(639,'g',0,'2012-01-10'),(593,'g',0,'2012-01-10'),(579,'g',0,'2012-02-27'),(647,'g',0,'2012-02-27'),(649,'g',0,'2012-02-27'),(578,'g',0,'2012-02-27'),(591,'g',0,'2012-02-27'),(1375,'g',0,'2012-01-10'),(1386,'g',0,'2012-01-10'),(559,'g',0,'2012-01-10'),(1571,'g',0,'2012-02-27'),(1644,'g',0,'2012-02-27'),(1584,'g',0,'2012-02-27'),(1565,'g',0,'2012-02-27'),(1530,'g',0,'2012-02-27'),(1554,'g',0,'2012-02-27'),(1576,'g',0,'2012-02-27'),(1558,'g',0,'2012-02-27'),(1643,'g',0,'2012-02-27'),(1557,'g',0,'2012-02-27'),(1560,'g',0,'2012-02-27'),(1546,'g',0,'2012-01-12'),(1586,'g',0,'2012-01-13'),(1221,'g',0,'2012-01-13'),(1222,'g',0,'2012-01-13'),(1274,'g',0,'2012-01-13'),(1436,'g',0,'2012-01-13'),(1224,'g',0,'2012-01-13'),(1215,'g',0,'2012-01-13'),(1232,'g',0,'2012-01-13'),(1141,'g',0,'2012-01-13'),(482,'g',0,'2012-01-13'),(471,'g',0,'2012-02-27'),(455,'g',0,'2012-02-27'),(377,'g',0,'2012-01-13'),(336,'g',0,'2012-02-27'),(612,'g',0,'2012-02-27'),(319,'g',0,'2012-01-13'),(627,'g',0,'2012-02-27'),(1403,'g',0,'2012-02-27'),(423,'g',0,'2012-02-27'),(421,'g',0,'2012-01-13'),(404,'g',0,'2012-02-27'),(535,'g',0,'2012-02-27'),(536,'g',0,'2012-02-27'),(409,'g',0,'2012-02-27'),(1383,'g',0,'2012-02-27'),(1382,'g',0,'2012-02-27'),(1423,'g',0,'2012-02-27'),(1223,'g',0,'2012-01-13'),(1534,'g',0,'2012-02-27'),(1542,'g',0,'2012-02-27'),(1570,'g',0,'2012-02-27'),(1569,'g',0,'2012-02-27'),(622,'g',0,'2012-02-27'),(702,'g',0,'2012-02-27'),(776,'g',0,'2012-01-16'),(741,'g',0,'2012-02-27'),(1648,'g',0,'2012-02-27'),(1543,'g',0,'2012-02-27'),(1559,'g',0,'2012-02-27'),(815,'g',0,'2012-02-27'),(814,'g',0,'2012-01-21'),(556,'g',0,'2012-01-21'),(567,'g',0,'2012-01-21'),(571,'g',0,'2012-01-21'),(514,'g',0,'2012-01-21'),(487,'g',0,'2012-01-21'),(485,'g',0,'2012-01-21'),(525,'g',0,'2012-01-21'),(513,'g',0,'2012-01-21'),(580,'g',0,'2012-01-21'),(544,'g',0,'2012-01-21'),(1604,'g',0,'2012-02-27'),(1612,'g',0,'2012-02-27'),(705,'g',0,'2012-02-27'),(749,'g',0,'2012-02-27'),(1424,'g',0,'2012-02-27'),(1632,'g',0,'2012-01-22'),(1620,'g',0,'2012-01-22'),(610,'g',0,'2012-01-22'),(632,'g',0,'2012-01-22'),(605,'g',0,'2012-01-22'),(1646,'g',0,'2012-01-22'),(587,'g',0,'2012-01-22'),(583,'g',0,'2012-01-22'),(617,'g',0,'2012-01-22'),(1402,'g',0,'2012-01-22'),(1392,'g',0,'2012-01-22'),(1397,'g',0,'2012-01-22'),(608,'g',0,'2012-01-22'),(1550,'g',0,'2012-02-27'),(1404,'g',0,'2012-01-22'),(616,'g',0,'2012-01-22'),(636,'g',0,'2012-01-22'),(586,'g',0,'2012-01-22'),(1714,'g',0,'2012-02-27'),(848,'g',0,'2012-01-27'),(843,'g',0,'2012-02-27'),(779,'g',0,'2012-02-27'),(836,'g',0,'2012-02-27'),(785,'g',0,'2012-02-27'),(837,'g',0,'2012-02-27'),(859,'g',0,'2012-01-27'),(844,'g',0,'2012-01-27'),(830,'g',0,'2012-02-27'),(780,'g',0,'2012-02-27'),(960,'g',0,'2012-01-27'),(947,'g',0,'2012-01-27'),(1059,'g',0,'2012-01-27'),(963,'g',0,'2012-01-27'),(1057,'g',0,'2012-01-27'),(1058,'g',0,'2012-01-27'),(1434,'g',0,'2012-01-27'),(1060,'g',0,'2012-01-27'),(1056,'g',0,'2012-01-27'),(1084,'g',0,'2012-01-27'),(1100,'g',0,'2012-01-27'),(1155,'g',0,'2012-01-27'),(1092,'g',0,'2012-01-27'),(1204,'g',0,'2012-01-27'),(1117,'g',0,'2012-01-27'),(1304,'g',0,'2012-01-27'),(1094,'g',0,'2012-01-27'),(1085,'g',0,'2012-01-27'),(1303,'g',0,'2012-01-27'),(1267,'g',0,'2012-01-27'),(876,'g',0,'2012-01-27'),(883,'g',0,'2012-01-27'),(878,'g',0,'2012-01-27'),(917,'g',0,'2012-01-27'),(894,'g',0,'2012-01-27'),(890,'g',0,'2012-01-27'),(882,'g',0,'2012-01-27'),(887,'g',0,'2012-01-27'),(912,'g',0,'2012-01-27'),(946,'g',0,'2012-01-27'),(833,'g',0,'2012-02-27'),(1080,'g',0,'2012-01-27'),(1282,'g',0,'2012-01-27'),(1081,'g',0,'2012-01-27'),(1082,'g',0,'2012-01-27'),(1690,'g',0,'2012-01-27'),(1207,'g',0,'2012-01-31'),(1228,'g',0,'2012-01-31'),(1296,'g',0,'2012-01-31'),(1281,'g',0,'2012-01-31'),(929,'g',0,'2012-01-31'),(853,'g',0,'2012-01-31'),(877,'g',0,'2012-01-31'),(926,'g',0,'2012-01-31'),(846,'g',0,'2012-01-31'),(1087,'g',0,'2012-01-31'),(1089,'g',0,'2012-01-31'),(907,'g',0,'2012-01-31'),(1144,'g',0,'2012-01-31'),(1143,'g',0,'2012-01-31'),(634,'g',0,'2012-02-01'),(629,'g',0,'2012-02-01'),(969,'g',0,'2012-02-02'),(967,'g',0,'2012-02-02'),(957,'g',0,'2012-02-02'),(970,'g',0,'2012-02-02'),(961,'g',0,'2012-02-02'),(964,'g',0,'2012-02-02'),(968,'g',0,'2012-02-02'),(958,'g',0,'2012-02-02'),(1134,'g',0,'2012-02-02'),(1128,'g',0,'2012-02-02'),(1132,'g',0,'2012-02-02'),(1129,'g',0,'2012-02-02'),(1131,'g',0,'2012-02-02'),(1770,'g',0,'2012-02-02'),(1112,'g',0,'2012-02-02'),(1120,'g',0,'2012-02-02'),(1127,'g',0,'2012-02-02'),(1121,'g',0,'2012-02-02'),(1113,'g',0,'2012-02-02'),(1122,'g',0,'2012-02-02'),(1123,'g',0,'2012-02-02'),(1133,'g',0,'2012-02-02'),(1738,'g',0,'2012-02-02'),(1125,'g',0,'2012-02-02'),(1126,'g',0,'2012-02-02'),(971,'g',0,'2012-02-02'),(972,'g',0,'2012-02-02'),(1004,'g',0,'2012-02-02'),(1003,'g',0,'2012-02-02'),(1001,'g',0,'2012-02-02'),(1110,'g',0,'2012-02-02'),(1002,'g',0,'2012-02-02'),(1106,'g',0,'2012-02-02'),(1108,'g',0,'2012-02-02'),(1111,'g',0,'2012-02-02'),(1327,'g',0,'2012-02-04'),(1315,'g',0,'2012-02-04'),(1302,'g',0,'2012-02-04'),(1268,'g',0,'2012-02-04'),(1229,'g',0,'2012-02-04'),(1266,'g',0,'2012-02-04'),(1688,'g',0,'2012-02-04'),(1650,'g',0,'2012-02-04'),(1824,'g',0,'2012-02-04'),(1756,'g',0,'2012-02-04'),(1694,'g',0,'2012-02-04'),(1362,'g',0,'2012-02-05'),(1360,'g',0,'2012-02-05'),(1361,'g',0,'2012-02-05'),(1277,'g',0,'2012-02-05'),(1700,'g',0,'2012-02-07'),(1848,'g',0,'2012-02-07'),(721,'g',0,'2012-02-07'),(1305,'g',0,'2012-02-08'),(1876,'g',0,'2012-02-08'),(1306,'g',0,'2012-02-08'),(1628,'g',0,'2012-02-08'),(1297,'g',0,'2012-02-08'),(1295,'g',0,'2012-02-08'),(1309,'g',0,'2012-02-08'),(1301,'g',0,'2012-02-08'),(1299,'g',0,'2012-02-08'),(1617,'g',0,'2012-02-08'),(1877,'g',0,'2012-02-11'),(1728,'g',0,'2012-02-13'),(1729,'g',0,'2012-02-14'),(1725,'g',0,'2012-02-14'),(1086,'g',0,'2012-02-14'),(1115,'g',0,'2012-02-14'),(1102,'g',0,'2012-02-14'),(507,'g',0,'2012-02-14'),(851,'g',0,'2012-02-14'),(787,'g',0,'2012-02-14'),(872,'g',0,'2012-02-14'),(778,'g',0,'2012-02-14'),(1895,'g',0,'2012-02-14'),(1852,'g',0,'2012-02-14'),(515,'g',0,'2012-02-14'),(795,'g',0,'2012-02-14'),(771,'g',0,'2012-02-14'),(782,'g',0,'2012-02-14'),(476,'g',0,'2012-02-14'),(508,'g',0,'2012-02-14'),(477,'g',0,'2012-02-14'),(701,'g',0,'2012-02-14'),(502,'g',0,'2012-02-14'),(728,'g',0,'2012-02-14'),(1891,'g',0,'2012-02-14'),(849,'g',0,'2012-02-14'),(850,'g',0,'2012-02-14'),(840,'g',0,'2012-02-14'),(888,'g',0,'2012-02-14'),(1041,'g',0,'2012-02-14'),(862,'g',0,'2012-02-14'),(1048,'g',0,'2012-02-14'),(1043,'g',0,'2012-02-14'),(1044,'g',0,'2012-02-14'),(1045,'g',0,'2012-02-14'),(1313,'g',0,'2012-02-15'),(870,'g',0,'2012-02-15'),(817,'g',0,'2012-02-15'),(800,'g',0,'2012-02-15'),(699,'g',0,'2012-02-15'),(896,'g',0,'2012-02-15'),(842,'g',0,'2012-02-15'),(871,'g',0,'2012-02-15'),(1289,'g',0,'2012-02-15'),(1654,'g',0,'2012-02-15'),(1638,'g',0,'2012-02-15'),(1216,'g',0,'2012-02-15'),(1124,'g',0,'2012-02-16'),(1902,'g',0,'2012-02-16'),(1758,'g',0,'2012-02-16'),(1878,'g',0,'2012-02-16'),(1851,'g',0,'2012-02-16'),(1910,'g',0,'2012-02-16'),(1906,'g',0,'2012-02-16'),(1901,'g',0,'2012-02-17'),(1926,'g',0,'2012-02-17'),(750,'g',0,'2012-02-17'),(732,'g',0,'2012-02-17'),(807,'g',0,'2012-02-17'),(752,'g',0,'2012-02-17'),(827,'g',0,'2012-02-17'),(796,'g',0,'2012-02-17'),(792,'g',0,'2012-02-17'),(751,'g',0,'2012-02-17'),(793,'g',0,'2012-02-17'),(805,'g',0,'2012-02-17'),(1847,'g',0,'2012-02-18'),(1907,'g',0,'2012-02-18'),(467,'g',0,'2012-02-20'),(460,'g',0,'2012-02-20'),(1911,'g',0,'2012-02-20'),(1905,'g',0,'2012-02-21'),(1333,'g',0,'2012-02-21'),(1042,'g',0,'2012-02-21'),(716,'g',0,'2012-02-21'),(718,'g',0,'2012-02-21'),(1435,'g',0,'2012-02-21'),(717,'g',0,'2012-02-21'),(1217,'g',0,'2012-02-21'),(1050,'g',0,'2012-02-21'),(1787,'g',0,'2012-02-21'),(1785,'g',0,'2012-02-21'),(1831,'g',0,'2012-02-21'),(1615,'g',0,'2012-02-21'),(1912,'g',0,'2012-02-21'),(1930,'g',0,'2012-02-23'),(1927,'g',0,'2012-02-25'),(1892,'g',0,'2012-02-27'),(1908,'g',0,'2012-02-27'),(1292,'g',0,'2012-02-27'),(1656,'g',0,'2012-02-27'),(1780,'g',0,'2012-02-27'),(828,'g',0,'2012-02-27'),(1431,'g',0,'2012-02-27'),(1701,'g',0,'2012-02-27'),(1826,'g',0,'2012-02-27'),(856,'g',0,'2012-02-27'),(1705,'g',0,'2012-02-27'),(865,'g',0,'2012-02-27'),(774,'g',0,'2012-02-27'),(767,'g',0,'2012-02-27'),(768,'g',0,'2012-02-27'),(765,'g',0,'2012-02-27'),(772,'g',0,'2012-02-27'),(766,'g',0,'2012-02-27'),(764,'g',0,'2012-02-27'),(775,'g',0,'2012-02-27'),(1730,'g',0,'2012-02-27'),(1769,'g',0,'2012-02-27'),(1849,'g',0,'2012-02-27'),(1909,'g',0,'2012-02-27'),(1634,'g',0,'2012-02-27'),(1781,'g',0,'2012-02-27'),(1287,'g',0,'2012-02-27'),(1692,'g',0,'2012-02-27'),(1751,'g',0,'2012-02-27'),(1882,'g',0,'2012-02-27'),(1276,'g',0,'2012-02-27'),(724,'g',0,'2012-02-27'),(1627,'g',0,'2012-02-27'),(1934,'g',0,'2012-02-27'),(1521,'g',0,'2012-02-27'),(730,'g',0,'2012-02-27'),(1592,'g',0,'2012-02-27'),(1853,'g',0,'2012-02-27'),(1791,'g',0,'2012-02-27'),(1772,'g',0,'2012-02-27'),(1788,'g',0,'2012-02-27'),(1846,'g',0,'2012-02-27'),(1613,'g',0,'2012-02-27'),(1860,'g',0,'2012-02-27'),(1919,'g',0,'2012-02-27'),(1750,'g',0,'2012-02-27'),(1880,'g',0,'2012-02-27'),(1886,'g',0,'2012-02-27'),(1626,'g',0,'2012-02-27'),(1629,'g',0,'2012-02-27'),(1710,'g',0,'2012-02-27'),(1825,'g',0,'2012-02-27'),(1936,'g',0,'2012-02-27'),(1888,'g',0,'2012-02-27'),(1594,'g',0,'2012-02-27'),(1702,'g',0,'2012-02-27'),(1759,'g',0,'2012-02-27'),(1733,'g',0,'2012-02-27'),(545,'g',0,'2012-02-27'),(799,'g',0,'2012-02-27'),(801,'g',0,'2012-02-27'),(803,'g',0,'2012-02-27'),(811,'g',0,'2012-02-27'),(802,'g',0,'2012-02-27'),(733,'g',0,'2012-02-27'),(813,'g',0,'2012-02-27'),(1955,'g',0,'2012-02-28'),(1959,'g',0,'2012-02-28'),(1956,'g',0,'2012-02-28'),(1971,'g',0,'2012-03-03'),(1972,'g',0,'2012-03-06'),(1967,'g',0,'2012-03-06'),(1981,'g',0,'2012-03-06'),(1964,'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','webamplified.net'),(5,'site_url','http://www.webamplified.net'),(6,'email_address','breonnas.egleston@gmail.com'),(7,'language_code','en_US'),(8,'theme_path','/home/webampli/public_html/themes/'),(9,'admin_template_path','/home/webampli/public_html/admin_tpl/'),(10,'plugin_path','/home/webampli/public_html/plugin/'),(12,'active_theme','_webamplified'),(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`
--



