--
-- Host: webmash.org    Database: webmash_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=37 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_category` VALUES (1,0,'Arts and Entertainment','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(2,0,'Arts Gallery & Entertainment','','folder.gif','','1',18,'','','0','0','','',0,'',0,0,0,0,0),(3,0,'Automobiles','','folder.gif','','1',44,'','','0','0','','',0,'',0,0,0,0,0),(4,0,'Business & Investment','','folder.gif','','1',156,'','','0','0','','',0,'',0,0,0,0,0),(5,0,'Careers & Recruitment','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(6,0,'Clothing & Designers','','folder.gif','','1',11,'','','0','0','','',0,'',0,0,0,0,0),(7,0,'Communication','','folder.gif','','1',22,'','','0','0','','',0,'',0,0,0,0,0),(8,0,'Computers','','folder.gif','','1',20,'','','0','0','','',0,'',0,0,0,0,0),(9,0,'Construction and Remodeling','','folder.gif','','1',77,'','','0','0','','',0,'',0,0,0,0,0),(10,0,'Dental','','folder.gif','','1',54,'','','0','0','','',0,'',0,0,0,0,0),(11,0,'Education & Colleges','','folder.gif','','1',27,'','','0','0','','',0,'',0,0,0,0,0),(12,0,'Employment & Staffing','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(13,0,'Gifts & Stationery','','folder.gif','','1',24,'','','0','0','','',0,'',0,0,0,0,0),(14,0,'Hardware & Software Systems','','folder.gif','','1',10,'','','0','0','','',0,'',0,0,0,0,0),(15,0,'Health Resources','','folder.gif','','1',4,'','','0','0','','',0,'',0,0,0,0,0),(16,0,'Healthcare Services & Products','','folder.gif','','1',165,'','','0','0','','',0,'',0,0,0,0,0),(17,0,'Air Conditioning, Heating & Ventilating','','folder.gif','','1',73,'','','0','0','','',0,'',0,0,0,0,0),(18,0,'Family ,Home & Garden','','folder.gif','','1',200,'','','0','0','','',0,'',0,0,0,0,0),(19,0,'Home Improvement Services','','folder.gif','','1',118,'','','0','0','','',0,'',0,0,0,0,0),(20,0,'Hotels & Resorts','','folder.gif','','1',63,'','','0','0','','',0,'',0,0,0,0,0),(21,0,'Insurance Services','','folder.gif','','1',32,'','','0','0','','',0,'',0,0,0,0,0),(22,0,'Law Services','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(23,0,'Lawyers and Law Firms','','folder.gif','','1',178,'','','0','0','','',0,'',0,0,0,0,0),(24,0,'Lifestyle & People','','folder.gif','','1',6,'','','0','0','','',0,'',0,0,0,0,0),(25,0,'Medicine  Facilities','','folder.gif','','1',14,'','','0','0','','',0,'',0,0,0,0,0),(26,0,'Financial Services','','folder.gif','','1',19,'','','0','0','','',0,'',0,0,0,0,0),(27,0,'News','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(28,0,'Plumbing & Plumbers','','folder.gif','','1',45,'','','0','0','','',0,'',0,0,0,0,0),(29,0,'Real Estate Services','','folder.gif','','1',41,'','','0','0','','',0,'',0,0,0,0,0),(30,0,'Technology & Science','','folder.gif','','1',13,'','','0','0','','',0,'',0,0,0,0,0),(31,0,'SEO Services','','folder.gif','','1',21,'','','0','0','','',0,'',0,0,0,0,0),(32,0,'Shopping and Fashion','','folder.gif','','1',63,'','','0','0','','',0,'',0,0,0,0,0),(33,0,'Games & Sports','','folder.gif','','1',3,'','','0','0','','',0,'',0,0,0,0,0),(34,0,'Transport & Freight Forwarding','','folder.gif','','1',40,'','','0','0','','',0,'',0,0,0,0,0),(35,0,'Travel & Vacations','','folder.gif','','1',23,'','','0','0','','',0,'',0,0,0,0,0),(36,0,'Wedding Accessories','','folder.gif','','1',8,'','','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 and Entertainment','<a href=\"http://webmash.org/arts-and-entertainment/\" name=\"cat_1\" style=\"\">Arts and Entertainment</a>',';0;'),(2,'Arts Gallery & Entertainment','<a href=\"http://webmash.org/arts-gallery-entertainment/\" name=\"cat_2\" style=\"\">Arts Gallery & Entertainment</a>',';0;'),(3,'Automobiles','<a href=\"http://webmash.org/automobiles/\" name=\"cat_3\" style=\"\">Automobiles</a>',';0;'),(4,'Business & Investment','<a href=\"http://webmash.org/business-investment/\" name=\"cat_4\" style=\"\">Business & Investment</a>',';0;'),(5,'Careers & Recruitment','<a href=\"http://webmash.org/careers-recruitment/\" name=\"cat_5\" style=\"\">Careers & Recruitment</a>',';0;'),(6,'Clothing & Designers','<a href=\"http://webmash.org/clothing-designers/\" name=\"cat_6\" style=\"\">Clothing & Designers</a>',';0;'),(7,'Communication','<a href=\"http://webmash.org/communication/\" name=\"cat_7\" style=\"\">Communication</a>',';0;'),(8,'Computers','<a href=\"http://webmash.org/computers/\" name=\"cat_8\" style=\"\">Computers</a>',';0;'),(9,'Construction and Remodeling','<a href=\"http://webmash.org/construction-and-remodeling/\" name=\"cat_9\" style=\"\">Construction and Remodeling</a>',';0;'),(10,'Dental','<a href=\"http://webmash.org/dental/\" name=\"cat_10\" style=\"\">Dental</a>',';0;'),(11,'Education & Colleges','<a href=\"http://webmash.org/education-colleges/\" name=\"cat_11\" style=\"\">Education & Colleges</a>',';0;'),(12,'Employment & Staffing','<a href=\"http://webmash.org/employment-staffing/\" name=\"cat_12\" style=\"\">Employment & Staffing</a>',';0;'),(13,'Gifts & Stationery','<a href=\"http://webmash.org/gifts-stationery/\" name=\"cat_13\" style=\"\">Gifts & Stationery</a>',';0;'),(14,'Hardware & Software Systems','<a href=\"http://webmash.org/hardware-software-systems/\" name=\"cat_14\" style=\"\">Hardware & Software Systems</a>',';0;'),(15,'Health Resources','<a href=\"http://webmash.org/health-resources/\" name=\"cat_15\" style=\"\">Health Resources</a>',';0;'),(16,'Healthcare Services & Products','<a href=\"http://webmash.org/healthcare-services-products/\" name=\"cat_16\" style=\"\">Healthcare Services & Products</a>',';0;'),(17,'Air Conditioning, Heating & Ventilating','<a href=\"http://webmash.org/air-conditioning-heating-ventilating/\" name=\"cat_17\" style=\"\">Air Conditioning, Heating & Ventilating</a>',';0;'),(18,'Family ,Home & Garden','<a href=\"http://webmash.org/family-home-garden/\" name=\"cat_18\" style=\"\">Family ,Home & Garden</a>',';0;'),(19,'Home Improvement Services','<a href=\"http://webmash.org/home-improvement-services/\" name=\"cat_19\" style=\"\">Home Improvement Services</a>',';0;'),(20,'Hotels & Resorts','<a href=\"http://webmash.org/hotels-resorts/\" name=\"cat_20\" style=\"\">Hotels & Resorts</a>',';0;'),(21,'Insurance Services','<a href=\"http://webmash.org/insurance-services/\" name=\"cat_21\" style=\"\">Insurance Services</a>',';0;'),(22,'Law Services','<a href=\"http://webmash.org/law-services/\" name=\"cat_22\" style=\"\">Law Services</a>',';0;'),(23,'Lawyers and Law Firms','<a href=\"http://webmash.org/lawyers-and-law-firms/\" name=\"cat_23\" style=\"\">Lawyers and Law Firms</a>',';0;'),(24,'Lifestyle & People','<a href=\"http://webmash.org/lifestyle-people/\" name=\"cat_24\" style=\"\">Lifestyle & People</a>',';0;'),(25,'Medicine  Facilities','<a href=\"http://webmash.org/medicine-facilities/\" name=\"cat_25\" style=\"\">Medicine  Facilities</a>',';0;'),(26,'Financial Services','<a href=\"http://webmash.org/financial-services/\" name=\"cat_26\" style=\"\">Financial Services</a>',';0;'),(27,'News','<a href=\"http://webmash.org/news/\" name=\"cat_27\" style=\"\">News</a>',';0;'),(28,'Plumbing & Plumbers','<a href=\"http://webmash.org/plumbing-plumbers/\" name=\"cat_28\" style=\"\">Plumbing & Plumbers</a>',';0;'),(29,'Real Estate Services','<a href=\"http://webmash.org/real-estate-services/\" name=\"cat_29\" style=\"\">Real Estate Services</a>',';0;'),(30,'Technology & Science','<a href=\"http://webmash.org/technology-science/\" name=\"cat_30\" style=\"\">Technology & Science</a>',';0;'),(31,'SEO Services','<a href=\"http://webmash.org/seo-services/\" name=\"cat_31\" style=\"\">SEO Services</a>',';0;'),(32,'Shopping and Fashion','<a href=\"http://webmash.org/shopping-and-fashion/\" name=\"cat_32\" style=\"\">Shopping and Fashion</a>',';0;'),(33,'Games & Sports','<a href=\"http://webmash.org/games-sports/\" name=\"cat_33\" style=\"\">Games & Sports</a>',';0;'),(34,'Transport & Freight Forwarding','<a href=\"http://webmash.org/transport-freight-forwarding/\" name=\"cat_34\" style=\"\">Transport & Freight Forwarding</a>',';0;'),(35,'Travel & Vacations','<a href=\"http://webmash.org/travel-vacations/\" name=\"cat_35\" style=\"\">Travel & Vacations</a>',';0;'),(36,'Wedding Accessories','<a href=\"http://webmash.org/wedding-accessories/\" name=\"cat_36\" style=\"\">Wedding Accessories</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=3 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_category_suggession` VALUES (1,1,'Movies','You update your latest links of movies website on this directory.\r\nSponsor - http://www.freemovietag.com','2011-11-29 14:19:58'),(2,18,'Appliance Repair','Refrigerator, washer, dryer, freezer, stove, oven repair','2012-02-22 12:02:10');

--
-- 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=6 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_favorites` VALUES (1,'zacharydelmel88t95','2011-10-18','My Favorites',NULL),(2,'olenhubertx93b61','2011-10-19','My Favorites',NULL),(3,'wallyharrya49s48','2011-10-31','My Favorites',NULL),(4,'shaunantionep50y96','2011-11-02','My Favorites',NULL),(5,'adaptive84','2011-12-07','My Favorites',NULL);

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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `idx_pagerank` VALUES (1,'g',4,'2011-09-12'),(3,'g',0,'2011-09-17'),(6,'g',0,'2011-09-17'),(2,'g',0,'2011-09-17'),(8,'g',2,'2011-09-17'),(9,'g',0,'2011-09-17'),(5,'g',3,'2011-09-17'),(10,'g',2,'2011-09-17'),(7,'g',0,'2011-09-17'),(4,'g',3,'2011-09-17'),(54,'g',0,'2012-02-16'),(31,'g',0,'2012-01-19'),(50,'g',0,'2012-01-19'),(259,'g',0,'2012-03-01'),(137,'g',0,'2012-01-23'),(178,'g',0,'2012-03-01'),(348,'g',0,'2012-03-01'),(353,'g',0,'2012-01-19'),(347,'g',0,'2012-03-01'),(425,'g',0,'2012-01-14'),(427,'g',0,'2012-01-22'),(245,'g',0,'2011-10-24'),(200,'g',0,'2011-10-24'),(296,'g',0,'2012-02-06'),(86,'g',0,'2011-12-13'),(87,'g',0,'2011-12-13'),(117,'g',0,'2011-12-13'),(239,'g',0,'2011-12-13'),(121,'g',0,'2011-12-13'),(234,'g',0,'2011-12-13'),(207,'g',0,'2011-12-13'),(105,'g',0,'2011-12-13'),(161,'g',0,'2011-12-13'),(385,'g',0,'2011-12-24'),(209,'g',0,'2012-01-10'),(203,'g',0,'2012-01-10'),(254,'g',0,'2012-01-10'),(475,'g',0,'2012-01-10'),(202,'g',0,'2012-01-10'),(408,'g',0,'2012-01-10'),(160,'g',0,'2012-01-10'),(402,'g',0,'2012-01-10'),(483,'g',0,'2012-01-09'),(59,'g',0,'2011-10-26'),(93,'g',0,'2011-10-26'),(82,'g',0,'2011-10-26'),(74,'g',0,'2011-10-26'),(111,'g',0,'2011-10-26'),(426,'g',0,'2011-10-26'),(130,'g',0,'2011-12-16'),(413,'g',0,'2012-01-26'),(125,'g',0,'2011-10-26'),(411,'g',0,'2011-10-26'),(472,'g',0,'2012-01-08'),(282,'g',0,'2012-01-08'),(387,'g',0,'2012-01-08'),(429,'g',0,'2012-01-08'),(76,'g',0,'2012-03-04'),(167,'g',0,'2012-03-04'),(252,'g',0,'2012-03-04'),(260,'g',0,'2012-03-04'),(255,'g',0,'2012-01-23'),(265,'g',0,'2011-10-26'),(504,'g',0,'2011-10-26'),(443,'g',0,'2011-10-26'),(270,'g',0,'2011-10-26'),(101,'g',0,'2011-10-26'),(113,'g',0,'2011-10-26'),(268,'g',0,'2011-10-26'),(505,'g',0,'2011-10-26'),(226,'g',0,'2012-02-22'),(453,'g',0,'2011-10-26'),(135,'g',0,'2012-02-22'),(430,'g',0,'2011-10-26'),(149,'g',0,'2011-12-02'),(96,'g',0,'2012-02-15'),(438,'g',0,'2012-01-09'),(422,'g',0,'2012-01-09'),(133,'g',0,'2012-02-15'),(224,'g',0,'2012-01-09'),(151,'g',0,'2012-02-15'),(278,'g',0,'2012-01-09'),(221,'g',0,'2012-02-15'),(388,'g',0,'2011-12-02'),(440,'g',0,'2011-12-16'),(439,'g',0,'2011-10-26'),(123,'g',0,'2011-10-26'),(280,'g',0,'2011-10-26'),(382,'g',0,'2011-10-26'),(412,'g',0,'2011-10-26'),(490,'g',0,'2011-10-26'),(415,'g',0,'2011-10-26'),(212,'g',0,'2011-12-13'),(236,'g',0,'2011-12-13'),(258,'g',0,'2011-12-13'),(416,'g',0,'2011-12-13'),(51,'g',0,'2011-10-27'),(100,'g',0,'2011-10-27'),(263,'g',0,'2011-10-27'),(66,'g',0,'2011-12-24'),(85,'g',0,'2012-01-12'),(288,'g',0,'2012-01-12'),(508,'g',0,'2012-01-12'),(487,'g',0,'2012-01-12'),(428,'g',0,'2012-01-12'),(506,'g',0,'2012-01-12'),(507,'g',0,'2012-01-12'),(384,'g',0,'2012-01-12'),(418,'g',0,'2011-10-27'),(124,'g',0,'2011-12-13'),(214,'g',0,'2011-10-27'),(211,'g',0,'2011-10-27'),(204,'g',0,'2011-10-27'),(227,'g',0,'2011-10-27'),(460,'g',0,'2011-10-27'),(419,'g',0,'2011-12-18'),(406,'g',0,'2011-10-27'),(99,'g',0,'2011-12-27'),(198,'g',0,'2011-12-07'),(497,'g',0,'2011-12-07'),(52,'g',0,'2011-12-27'),(98,'g',0,'2011-12-21'),(95,'g',0,'2012-02-16'),(58,'g',0,'2012-02-22'),(32,'g',0,'2011-12-17'),(49,'g',0,'2012-02-22'),(45,'g',0,'2011-10-27'),(136,'g',0,'2012-01-10'),(383,'g',0,'2011-10-27'),(241,'g',0,'2012-03-05'),(81,'g',0,'2011-10-27'),(62,'g',0,'2011-10-27'),(29,'g',0,'2011-10-27'),(48,'g',0,'2011-10-27'),(480,'g',0,'2011-10-27'),(128,'g',0,'2011-10-27'),(47,'g',0,'2011-10-27'),(43,'g',0,'2011-10-27'),(44,'g',0,'2011-10-27'),(46,'g',0,'2011-10-27'),(264,'g',0,'2012-01-10'),(71,'g',0,'2011-12-17'),(79,'g',0,'2011-12-17'),(83,'g',0,'2011-12-17'),(73,'g',0,'2011-12-17'),(57,'g',0,'2012-02-22'),(75,'g',0,'2011-12-17'),(68,'g',0,'2012-02-22'),(61,'g',0,'2011-12-19'),(80,'g',0,'2012-02-16'),(60,'g',0,'2012-02-16'),(56,'g',0,'2012-02-16'),(92,'g',0,'2011-12-21'),(64,'g',0,'2011-12-21'),(67,'g',0,'2011-12-21'),(63,'g',0,'2011-12-21'),(78,'g',0,'2011-12-21'),(84,'g',0,'2011-12-21'),(72,'g',0,'2011-12-21'),(70,'g',0,'2011-12-21'),(55,'g',0,'2011-12-21'),(69,'g',0,'2011-12-25'),(91,'g',0,'2011-12-27'),(53,'g',0,'2011-12-27'),(30,'g',0,'2012-01-19'),(97,'g',0,'2012-01-19'),(65,'g',0,'2012-01-19'),(94,'g',0,'2012-01-19'),(77,'g',0,'2012-01-14'),(34,'g',0,'2011-12-27'),(36,'g',0,'2011-12-16'),(37,'g',0,'2011-12-27'),(40,'g',0,'2011-12-27'),(116,'g',0,'2011-12-27'),(39,'g',0,'2011-12-27'),(41,'g',0,'2011-12-16'),(38,'g',0,'2011-12-27'),(33,'g',0,'2011-12-27'),(42,'g',0,'2011-12-27'),(35,'g',0,'2011-12-27'),(251,'g',0,'2011-10-28'),(139,'g',0,'2011-10-28'),(389,'g',0,'2011-10-28'),(220,'g',0,'2011-10-28'),(232,'g',0,'2011-10-28'),(114,'g',0,'2012-03-03'),(112,'g',0,'2012-02-16'),(140,'g',0,'2012-03-03'),(122,'g',0,'2011-12-27'),(129,'g',0,'2012-02-16'),(115,'g',0,'2011-12-27'),(107,'g',0,'2011-12-27'),(119,'g',0,'2011-12-27'),(191,'g',0,'2012-01-19'),(126,'g',0,'2012-01-19'),(118,'g',0,'2012-01-19'),(186,'g',0,'2012-01-19'),(188,'g',0,'2012-01-19'),(432,'g',0,'2012-01-14'),(423,'g',0,'2012-01-14'),(503,'g',0,'2012-01-14'),(390,'g',0,'2012-01-14'),(102,'g',0,'2012-01-14'),(449,'g',0,'2012-01-14'),(469,'g',0,'2012-01-14'),(434,'g',0,'2012-01-14'),(513,'g',0,'2011-11-06'),(514,'g',0,'2011-11-08'),(454,'g',0,'2012-02-23'),(481,'g',0,'2011-11-15'),(398,'g',0,'2011-11-17'),(410,'g',0,'2011-11-17'),(699,'g',0,'2011-11-24'),(880,'g',0,'2011-11-24'),(764,'g',0,'2011-11-24'),(672,'g',0,'2011-11-24'),(872,'g',0,'2011-11-24'),(854,'g',0,'2011-11-24'),(746,'g',0,'2011-11-24'),(812,'g',0,'2011-11-24'),(1129,'g',0,'2011-11-24'),(729,'g',0,'2011-11-24'),(873,'g',0,'2011-11-25'),(632,'g',0,'2011-11-25'),(868,'g',0,'2011-11-25'),(1065,'g',0,'2011-11-25'),(1127,'g',0,'2011-11-25'),(882,'g',0,'2011-11-25'),(727,'g',0,'2011-11-25'),(1073,'g',0,'2011-11-25'),(1154,'g',0,'2011-11-25'),(1096,'g',0,'2011-11-25'),(1186,'g',0,'2011-11-25'),(747,'g',0,'2011-11-25'),(612,'g',0,'2011-11-25'),(557,'g',0,'2011-11-25'),(540,'g',0,'2011-11-25'),(552,'g',0,'2011-11-25'),(553,'g',0,'2011-11-25'),(550,'g',0,'2011-11-25'),(1436,'g',0,'2011-11-25'),(1097,'g',0,'2011-11-25'),(860,'g',0,'2011-11-25'),(545,'g',0,'2011-11-25'),(529,'g',0,'2011-11-25'),(1146,'g',0,'2011-11-25'),(604,'g',0,'2011-11-25'),(1355,'g',0,'2011-11-25'),(561,'g',0,'2011-11-25'),(577,'g',0,'2011-11-25'),(666,'g',0,'2011-11-25'),(603,'g',0,'2011-11-25'),(660,'g',0,'2011-11-25'),(569,'g',0,'2011-11-25'),(1349,'g',0,'2011-11-25'),(1340,'g',0,'2011-11-25'),(1570,'g',0,'2011-11-25'),(580,'g',0,'2011-11-25'),(536,'g',0,'2011-11-25'),(565,'g',0,'2011-11-25'),(881,'g',0,'2011-11-25'),(651,'g',0,'2011-11-25'),(711,'g',0,'2011-11-26'),(631,'g',0,'2011-11-26'),(759,'g',0,'2011-11-26'),(591,'g',0,'2011-11-26'),(696,'g',0,'2011-11-26'),(656,'g',0,'2011-11-26'),(664,'g',0,'2011-11-26'),(734,'g',0,'2011-11-26'),(2578,'g',0,'2011-11-26'),(1889,'g',0,'2011-11-26'),(1200,'g',0,'2011-11-26'),(3276,'g',0,'2011-11-26'),(1117,'g',0,'2011-11-27'),(1736,'g',0,'2011-11-27'),(1161,'g',0,'2011-11-27'),(2233,'g',0,'2011-11-27'),(671,'g',0,'2011-11-27'),(578,'g',0,'2011-11-27'),(533,'g',0,'2011-11-27'),(1047,'g',0,'2011-11-27'),(1119,'g',0,'2011-11-27'),(1544,'g',0,'2011-11-27'),(1158,'g',0,'2011-11-28'),(2922,'g',0,'2011-11-28'),(855,'g',0,'2011-11-28'),(1118,'g',0,'2011-11-28'),(2580,'g',0,'2011-11-28'),(1202,'g',0,'2011-11-28'),(1891,'g',0,'2011-11-28'),(3279,'g',0,'2011-11-28'),(761,'g',0,'2011-11-29'),(1887,'g',0,'2011-11-29'),(1121,'g',0,'2011-11-29'),(1810,'g',0,'2011-11-29'),(1450,'g',0,'2011-11-29'),(1198,'g',0,'2011-11-29'),(4000,'g',0,'2011-11-29'),(4744,'g',0,'2011-11-29'),(593,'g',0,'2011-11-29'),(886,'g',0,'2011-11-29'),(613,'g',0,'2011-11-29'),(625,'g',0,'2011-11-29'),(628,'g',0,'2011-11-30'),(584,'g',0,'2011-11-30'),(1261,'g',0,'2011-11-30'),(1026,'g',0,'2011-11-30'),(1189,'g',0,'2011-11-30'),(629,'g',0,'2011-11-30'),(1160,'g',0,'2011-11-30'),(572,'g',0,'2011-11-30'),(960,'g',0,'2011-11-30'),(1232,'g',0,'2011-11-30'),(543,'g',0,'2011-11-30'),(647,'g',0,'2011-11-30'),(1025,'g',0,'2011-11-30'),(1059,'g',0,'2011-11-30'),(1566,'g',0,'2011-11-30'),(594,'g',0,'2011-11-30'),(667,'g',0,'2011-11-30'),(1921,'g',0,'2011-11-30'),(581,'g',0,'2011-11-30'),(624,'g',0,'2011-11-30'),(795,'g',0,'2011-11-30'),(1092,'g',0,'2011-11-30'),(1071,'g',0,'2011-11-30'),(1051,'g',0,'2011-11-30'),(691,'g',0,'2011-11-30'),(658,'g',0,'2011-11-30'),(971,'g',0,'2011-11-30'),(877,'g',0,'2011-11-30'),(1024,'g',0,'2011-11-30'),(4740,'g',0,'2011-12-01'),(3996,'g',0,'2011-12-01'),(665,'g',0,'2011-12-01'),(655,'g',0,'2011-12-01'),(4756,'g',0,'2011-12-02'),(4367,'g',0,'2011-12-02'),(3627,'g',0,'2011-12-02'),(706,'g',0,'2011-12-02'),(1395,'g',0,'2011-12-02'),(2773,'g',0,'2011-12-02'),(4218,'g',0,'2011-12-02'),(2084,'g',0,'2011-12-02'),(3478,'g',0,'2011-12-02'),(1635,'g',0,'2011-12-02'),(946,'g',0,'2011-12-02'),(2324,'g',0,'2011-12-02'),(4458,'g',0,'2011-12-02'),(3718,'g',0,'2011-12-02'),(3013,'g',0,'2011-12-02'),(708,'g',0,'2011-12-02'),(2086,'g',0,'2011-12-02'),(2775,'g',0,'2011-12-02'),(3480,'g',0,'2011-12-02'),(4220,'g',0,'2011-12-02'),(1397,'g',0,'2011-12-02'),(5494,'g',0,'2011-12-04'),(5498,'g',0,'2011-12-04'),(609,'g',0,'2011-12-05'),(1298,'g',0,'2011-12-05'),(3381,'g',0,'2011-12-05'),(1987,'g',0,'2011-12-05'),(4121,'g',0,'2011-12-05'),(4867,'g',0,'2011-12-05'),(2676,'g',0,'2011-12-05'),(5645,'g',0,'2011-12-05'),(5510,'g',0,'2011-12-07'),(5113,'g',0,'2011-12-07'),(5891,'g',0,'2011-12-07'),(685,'g',0,'2011-12-08'),(1374,'g',0,'2011-12-08'),(3457,'g',0,'2011-12-08'),(4943,'g',0,'2011-12-08'),(5721,'g',0,'2011-12-08'),(4197,'g',0,'2011-12-08'),(6522,'g',0,'2011-12-08'),(2063,'g',0,'2011-12-08'),(2752,'g',0,'2011-12-08'),(6275,'g',0,'2011-12-09'),(7077,'g',0,'2011-12-09'),(7607,'g',0,'2011-12-13'),(7295,'g',0,'2011-12-13'),(7659,'g',0,'2011-12-13'),(7660,'g',0,'2011-12-13'),(7596,'g',0,'2011-12-13'),(7661,'g',0,'2011-12-13'),(7492,'g',0,'2011-12-13'),(7893,'g',0,'2011-12-14'),(7518,'g',0,'2011-12-14'),(7253,'g',0,'2011-12-14'),(7765,'g',0,'2011-12-14'),(7198,'g',0,'2011-12-14'),(7366,'g',0,'2011-12-14'),(7510,'g',0,'2011-12-14'),(7767,'g',0,'2011-12-14'),(7270,'g',0,'2011-12-14'),(7364,'g',0,'2011-12-14'),(7708,'g',0,'2011-12-14'),(8046,'g',0,'2011-12-15'),(8043,'g',0,'2011-12-15'),(7997,'g',0,'2011-12-15'),(8004,'g',0,'2011-12-15'),(8035,'g',0,'2011-12-15'),(8034,'g',0,'2011-12-15'),(7981,'g',0,'2011-12-15'),(7987,'g',0,'2011-12-15'),(8007,'g',0,'2011-12-15'),(8056,'g',0,'2011-12-15'),(7686,'g',0,'2012-01-23'),(7694,'g',0,'2012-01-23'),(7432,'g',0,'2012-01-23'),(7728,'g',0,'2011-12-16'),(7328,'g',0,'2012-01-23'),(7803,'g',0,'2011-12-16'),(7843,'g',0,'2011-12-16'),(7706,'g',0,'2012-01-23'),(7222,'g',0,'2012-01-23'),(7262,'g',0,'2011-12-16'),(7982,'g',0,'2011-12-16'),(7998,'g',0,'2011-12-16'),(8036,'g',0,'2011-12-16'),(496,'g',0,'2011-12-17'),(448,'g',0,'2011-12-17'),(7336,'g',0,'2011-12-17'),(7309,'g',0,'2011-12-17'),(7219,'g',0,'2011-12-17'),(7308,'g',0,'2011-12-17'),(7174,'g',0,'2011-12-17'),(166,'g',0,'2011-12-17'),(7449,'g',0,'2011-12-17'),(7232,'g',0,'2011-12-17'),(7293,'g',0,'2011-12-17'),(8049,'g',0,'2011-12-17'),(7516,'g',0,'2011-12-17'),(7269,'g',0,'2011-12-17'),(7191,'g',0,'2011-12-17'),(7194,'g',0,'2011-12-17'),(7193,'g',0,'2011-12-17'),(7181,'g',0,'2011-12-17'),(8008,'g',0,'2011-12-17'),(7732,'g',0,'2012-02-06'),(7497,'g',0,'2012-02-06'),(7733,'g',0,'2012-02-06'),(7839,'g',0,'2011-12-17'),(7383,'g',0,'2011-12-17'),(7505,'g',0,'2012-02-06'),(7384,'g',0,'2012-02-06'),(7793,'g',0,'2012-02-06'),(7700,'g',0,'2012-02-06'),(7491,'g',0,'2011-12-17'),(7401,'g',0,'2011-12-17'),(7509,'g',0,'2011-12-17'),(7301,'g',0,'2011-12-17'),(7990,'g',0,'2011-12-17'),(489,'g',0,'2011-12-17'),(7333,'g',0,'2011-12-18'),(7225,'g',0,'2011-12-18'),(7235,'g',0,'2011-12-18'),(396,'g',0,'2011-12-18'),(465,'g',0,'2011-12-18'),(456,'g',0,'2011-12-18'),(464,'g',0,'2011-12-18'),(450,'g',0,'2011-12-18'),(447,'g',0,'2011-12-18'),(467,'g',0,'2011-12-18'),(463,'g',0,'2011-12-18'),(452,'g',0,'2011-12-18'),(431,'g',0,'2011-12-18'),(511,'g',0,'2011-12-18'),(488,'g',0,'2011-12-18'),(8079,'g',0,'2011-12-18'),(8077,'g',0,'2011-12-18'),(8040,'g',0,'2011-12-18'),(8082,'g',0,'2011-12-18'),(8072,'g',0,'2011-12-18'),(7156,'g',0,'2011-12-18'),(8080,'g',0,'2011-12-18'),(8047,'g',0,'2011-12-18'),(7184,'g',0,'2011-12-18'),(7213,'g',0,'2011-12-18'),(276,'g',0,'2011-12-19'),(257,'g',0,'2011-12-19'),(248,'g',0,'2011-12-19'),(266,'g',0,'2011-12-19'),(403,'g',0,'2011-12-19'),(284,'g',0,'2011-12-19'),(386,'g',0,'2011-12-19'),(291,'g',0,'2011-12-19'),(247,'g',0,'2011-12-19'),(405,'g',0,'2011-12-19'),(509,'g',0,'2011-12-19'),(7379,'g',0,'2011-12-19'),(7283,'g',0,'2011-12-19'),(7227,'g',0,'2011-12-19'),(7526,'g',0,'2011-12-19'),(7173,'g',0,'2011-12-19'),(7655,'g',0,'2011-12-19'),(7378,'g',0,'2011-12-19'),(7683,'g',0,'2011-12-19'),(7233,'g',0,'2011-12-19'),(512,'g',0,'2011-12-19'),(501,'g',0,'2011-12-19'),(7372,'g',0,'2011-12-19'),(7332,'g',0,'2011-12-19'),(7331,'g',0,'2011-12-19'),(7356,'g',0,'2011-12-19'),(7357,'g',0,'2011-12-19'),(8105,'g',0,'2011-12-19'),(7229,'g',0,'2011-12-19'),(7337,'g',0,'2011-12-19'),(7261,'g',0,'2011-12-19'),(498,'g',0,'2011-12-19'),(8103,'g',0,'2011-12-19'),(7220,'g',0,'2011-12-19'),(8058,'g',0,'2011-12-19'),(7286,'g',0,'2011-12-19'),(8076,'g',0,'2011-12-19'),(8061,'g',0,'2011-12-19'),(7388,'g',0,'2011-12-19'),(8102,'g',0,'2011-12-20'),(8097,'g',0,'2011-12-20'),(7805,'g',0,'2011-12-20'),(7875,'g',0,'2011-12-20'),(7881,'g',0,'2011-12-20'),(7968,'g',0,'2011-12-20'),(7768,'g',0,'2011-12-20'),(7775,'g',0,'2011-12-20'),(7811,'g',0,'2011-12-20'),(7864,'g',0,'2011-12-20'),(7212,'g',0,'2011-12-20'),(7444,'g',0,'2011-12-20'),(7937,'g',0,'2011-12-20'),(7294,'g',0,'2011-12-20'),(7215,'g',0,'2011-12-20'),(7936,'g',0,'2011-12-20'),(7931,'g',0,'2011-12-20'),(7277,'g',0,'2011-12-20'),(7431,'g',0,'2011-12-20'),(7741,'g',0,'2011-12-20'),(7391,'g',0,'2011-12-20'),(7201,'g',0,'2011-12-20'),(7208,'g',0,'2011-12-20'),(7440,'g',0,'2011-12-20'),(7716,'g',0,'2011-12-20'),(7869,'g',0,'2011-12-20'),(8107,'g',0,'2011-12-21'),(8063,'g',0,'2011-12-21'),(7175,'g',0,'2011-12-21'),(7172,'g',0,'2011-12-21'),(8037,'g',0,'2011-12-21'),(7200,'g',0,'2011-12-21'),(7187,'g',0,'2011-12-21'),(8069,'g',0,'2011-12-21'),(7192,'g',0,'2011-12-21'),(7185,'g',0,'2011-12-21'),(7565,'g',0,'2011-12-21'),(7673,'g',0,'2011-12-21'),(7466,'g',0,'2011-12-21'),(7614,'g',0,'2011-12-21'),(7594,'g',0,'2011-12-21'),(7488,'g',0,'2011-12-21'),(7502,'g',0,'2011-12-21'),(7489,'g',0,'2011-12-21'),(7458,'g',0,'2011-12-21'),(7637,'g',0,'2011-12-21'),(8029,'g',0,'2011-12-22'),(8031,'g',0,'2011-12-22'),(8028,'g',0,'2011-12-22'),(8032,'g',0,'2011-12-22'),(8030,'g',0,'2011-12-22'),(7876,'g',0,'2011-12-22'),(7685,'g',0,'2011-12-22'),(7684,'g',0,'2011-12-22'),(7812,'g',0,'2011-12-22'),(8081,'g',0,'2011-12-22'),(8065,'g',0,'2011-12-22'),(8117,'g',0,'2012-02-21'),(8048,'g',0,'2011-12-22'),(8070,'g',0,'2011-12-22'),(8073,'g',0,'2011-12-22'),(8094,'g',0,'2011-12-22'),(8071,'g',0,'2011-12-22'),(8064,'g',0,'2011-12-22'),(7757,'g',0,'2012-03-04'),(7398,'g',0,'2012-03-04'),(7874,'g',0,'2011-12-23'),(7770,'g',0,'2011-12-23'),(7829,'g',0,'2011-12-23'),(7806,'g',0,'2011-12-23'),(7807,'g',0,'2011-12-23'),(7727,'g',0,'2011-12-23'),(7771,'g',0,'2011-12-23'),(7782,'g',0,'2011-12-23'),(7783,'g',0,'2011-12-23'),(7739,'g',0,'2011-12-23'),(7774,'g',0,'2011-12-23'),(8027,'g',0,'2011-12-23'),(7422,'g',0,'2011-12-23'),(7373,'g',0,'2011-12-23'),(7501,'g',0,'2011-12-23'),(7202,'g',0,'2011-12-23'),(7408,'g',0,'2011-12-23'),(7177,'g',0,'2011-12-23'),(7397,'g',0,'2011-12-23'),(7210,'g',0,'2011-12-23'),(7382,'g',0,'2011-12-23'),(7186,'g',0,'2011-12-23'),(7434,'g',0,'2011-12-23'),(8106,'g',0,'2011-12-23'),(7206,'g',0,'2011-12-23'),(7170,'g',0,'2011-12-23'),(7412,'g',0,'2011-12-23'),(7406,'g',0,'2011-12-23'),(7493,'g',0,'2011-12-23'),(8023,'g',0,'2011-12-23'),(8022,'g',0,'2011-12-23'),(8020,'g',0,'2011-12-23'),(8019,'g',0,'2011-12-23'),(8025,'g',0,'2011-12-23'),(8039,'g',0,'2011-12-23'),(8021,'g',0,'2011-12-23'),(8024,'g',0,'2011-12-23'),(8026,'g',0,'2011-12-23'),(7520,'g',0,'2011-12-23'),(7836,'g',0,'2011-12-23'),(7503,'g',0,'2011-12-23'),(7645,'g',0,'2011-12-23'),(7324,'g',0,'2011-12-23'),(7672,'g',0,'2011-12-23'),(7314,'g',0,'2011-12-23'),(7506,'g',0,'2011-12-23'),(7381,'g',0,'2011-12-23'),(7738,'g',0,'2011-12-23'),(7868,'g',0,'2011-12-23'),(7583,'g',0,'2011-12-23'),(7853,'g',0,'2011-12-23'),(7721,'g',0,'2011-12-23'),(7380,'g',0,'2011-12-23'),(7374,'g',0,'2011-12-23'),(7725,'g',0,'2011-12-23'),(7606,'g',0,'2011-12-23'),(7749,'g',0,'2011-12-23'),(7766,'g',0,'2011-12-23'),(7603,'g',0,'2011-12-23'),(7608,'g',0,'2011-12-23'),(7751,'g',0,'2011-12-23'),(7642,'g',0,'2011-12-24'),(7692,'g',0,'2011-12-24'),(7571,'g',0,'2011-12-24'),(7315,'g',0,'2011-12-24'),(7558,'g',0,'2011-12-24'),(7643,'g',0,'2011-12-24'),(7690,'g',0,'2011-12-24'),(7312,'g',0,'2011-12-24'),(7569,'g',0,'2011-12-24'),(7524,'g',0,'2011-12-24'),(7377,'g',0,'2011-12-24'),(7847,'g',0,'2011-12-24'),(7726,'g',0,'2011-12-24'),(7735,'g',0,'2011-12-24'),(7854,'g',0,'2011-12-24'),(7339,'g',0,'2011-12-24'),(7318,'g',0,'2011-12-24'),(7635,'g',0,'2011-12-24'),(7736,'g',0,'2011-12-24'),(7371,'g',0,'2011-12-24'),(7348,'g',0,'2011-12-24'),(7303,'g',0,'2011-12-24'),(7784,'g',0,'2011-12-24'),(7297,'g',0,'2011-12-24'),(8119,'g',0,'2011-12-24'),(7517,'g',0,'2011-12-24'),(7288,'g',0,'2011-12-24'),(7955,'g',0,'2011-12-25'),(7958,'g',0,'2011-12-25'),(7920,'g',0,'2011-12-25'),(7964,'g',0,'2011-12-25'),(7923,'g',0,'2011-12-25'),(7953,'g',0,'2011-12-25'),(7951,'g',0,'2011-12-25'),(7890,'g',0,'2011-12-25'),(7285,'g',0,'2011-12-25'),(7267,'g',0,'2011-12-25'),(7712,'g',0,'2011-12-25'),(7677,'g',0,'2011-12-25'),(7654,'g',0,'2011-12-25'),(7939,'g',0,'2011-12-25'),(7734,'g',0,'2011-12-25'),(7896,'g',0,'2011-12-25'),(7678,'g',0,'2011-12-25'),(7838,'g',0,'2011-12-25'),(8114,'g',0,'2011-12-25'),(7448,'g',0,'2011-12-25'),(7680,'g',0,'2011-12-25'),(7504,'g',0,'2011-12-25'),(7842,'g',0,'2011-12-25'),(7436,'g',0,'2011-12-25'),(7435,'g',0,'2011-12-25'),(7650,'g',0,'2011-12-25'),(7473,'g',0,'2011-12-25'),(7484,'g',0,'2011-12-25'),(7940,'g',0,'2011-12-25'),(7386,'g',0,'2011-12-25'),(8109,'g',0,'2011-12-25'),(8054,'g',0,'2011-12-25'),(7676,'g',0,'2011-12-25'),(7941,'g',0,'2011-12-25'),(7429,'g',0,'2011-12-25'),(7647,'g',0,'2011-12-25'),(7427,'g',0,'2011-12-25'),(7731,'g',0,'2011-12-25'),(7424,'g',0,'2011-12-26'),(7360,'g',0,'2011-12-26'),(7343,'g',0,'2011-12-26'),(7345,'g',0,'2011-12-26'),(7346,'g',0,'2011-12-26'),(7344,'g',0,'2011-12-26'),(7361,'g',0,'2011-12-26'),(7369,'g',0,'2011-12-26'),(7342,'g',0,'2011-12-26'),(7349,'g',0,'2011-12-26'),(8132,'g',0,'2011-12-27'),(7368,'g',0,'2011-12-27'),(8055,'g',0,'2011-12-27'),(8099,'g',0,'2011-12-28'),(8168,'g',0,'2012-02-06'),(8174,'g',0,'2011-12-29'),(8164,'g',0,'2011-12-29'),(7541,'g',0,'2011-12-29'),(7652,'g',0,'2011-12-29'),(7585,'g',0,'2011-12-29'),(7197,'g',0,'2011-12-30'),(7334,'g',0,'2011-12-30'),(7623,'g',0,'2011-12-30'),(7525,'g',0,'2011-12-30'),(7470,'g',0,'2011-12-30'),(7563,'g',0,'2011-12-30'),(7275,'g',0,'2011-12-30'),(7511,'g',0,'2011-12-30'),(7338,'g',0,'2011-12-30'),(8111,'g',0,'2011-12-30'),(8104,'g',0,'2011-12-30'),(7566,'g',0,'2011-12-30'),(7699,'g',0,'2011-12-30'),(8152,'g',0,'2011-12-30'),(8130,'g',0,'2011-12-30'),(7322,'g',0,'2011-12-30'),(7279,'g',0,'2011-12-30'),(7394,'g',0,'2011-12-30'),(7327,'g',0,'2011-12-30'),(7453,'g',0,'2011-12-30'),(7556,'g',0,'2011-12-30'),(7474,'g',0,'2011-12-30'),(7441,'g',0,'2011-12-30'),(7249,'g',0,'2011-12-30'),(7693,'g',0,'2011-12-30'),(7667,'g',0,'2011-12-30'),(7551,'g',0,'2011-12-30'),(7230,'g',0,'2011-12-30'),(8140,'g',0,'2011-12-30'),(7287,'g',0,'2011-12-30'),(7521,'g',0,'2011-12-30'),(7554,'g',0,'2011-12-30'),(7226,'g',0,'2011-12-30'),(7405,'g',0,'2011-12-30'),(7552,'g',0,'2011-12-30'),(7557,'g',0,'2011-12-30'),(7355,'g',0,'2011-12-30'),(7417,'g',0,'2011-12-30'),(7180,'g',0,'2011-12-30'),(7507,'g',0,'2011-12-30'),(7311,'g',0,'2011-12-30'),(7584,'g',0,'2011-12-30'),(8125,'g',0,'2011-12-30'),(7276,'g',0,'2011-12-30'),(7392,'g',0,'2011-12-30'),(7168,'g',0,'2011-12-30'),(7245,'g',0,'2011-12-30'),(7218,'g',0,'2011-12-31'),(7221,'g',0,'2011-12-31'),(8149,'g',0,'2011-12-31'),(7682,'g',0,'2011-12-31'),(7753,'g',0,'2012-01-01'),(7278,'g',0,'2012-01-01'),(8128,'g',0,'2012-01-01'),(7439,'g',0,'2012-01-01'),(7416,'g',0,'2012-01-01'),(7523,'g',0,'2012-01-01'),(7326,'g',0,'2012-01-01'),(7250,'g',0,'2012-01-02'),(7298,'g',0,'2012-01-02'),(7296,'g',0,'2012-01-02'),(7555,'g',0,'2012-01-02'),(7300,'g',0,'2012-01-02'),(7299,'g',0,'2012-01-02'),(7529,'g',0,'2012-01-02'),(8170,'g',0,'2012-01-02'),(7553,'g',0,'2012-01-02'),(7317,'g',0,'2012-01-02'),(7244,'g',0,'2012-01-03'),(8155,'g',0,'2012-01-03'),(8162,'g',0,'2012-01-03'),(8169,'g',0,'2012-01-03'),(8120,'g',0,'2012-01-03'),(8115,'g',0,'2012-01-03'),(7335,'g',0,'2012-01-03'),(8173,'g',0,'2012-01-04'),(8158,'g',0,'2012-02-21'),(8151,'g',0,'2012-02-21'),(8166,'g',0,'2012-01-04'),(8161,'g',0,'2012-02-21'),(8136,'g',0,'2012-02-21'),(8157,'g',0,'2012-02-21'),(8180,'g',0,'2012-01-04'),(8189,'g',0,'2012-01-04'),(8050,'g',0,'2012-01-04'),(7182,'g',0,'2012-01-04'),(7165,'g',0,'2012-01-04'),(7228,'g',0,'2012-01-04'),(8131,'g',0,'2012-01-04'),(8110,'g',0,'2012-01-04'),(7189,'g',0,'2012-01-04'),(7247,'g',0,'2012-01-04'),(8033,'g',0,'2012-01-04'),(7161,'g',0,'2012-01-04'),(8188,'g',0,'2012-01-05'),(8196,'g',0,'2012-01-05'),(8153,'g',0,'2012-01-07'),(8154,'g',0,'2012-01-07'),(8186,'g',0,'2012-01-07'),(8171,'g',0,'2012-01-07'),(8203,'g',0,'2012-01-08'),(7263,'g',0,'2012-01-08'),(7234,'g',0,'2012-01-08'),(7254,'g',0,'2012-01-08'),(8159,'g',0,'2012-01-08'),(7880,'g',0,'2012-01-09'),(8228,'g',0,'2012-01-09'),(8194,'g',0,'2012-03-04'),(8259,'g',0,'2012-01-13'),(8221,'g',0,'2012-01-13'),(8232,'g',0,'2012-01-13'),(8225,'g',0,'2012-01-13'),(8239,'g',0,'2012-01-13'),(8252,'g',0,'2012-01-13'),(8262,'g',0,'2012-01-13'),(8238,'g',0,'2012-01-13'),(8219,'g',0,'2012-01-13'),(8241,'g',0,'2012-02-21'),(8240,'g',0,'2012-01-14'),(8216,'g',0,'2012-01-15'),(8212,'g',0,'2012-01-16'),(8224,'g',0,'2012-01-16'),(8217,'g',0,'2012-01-19'),(8192,'g',0,'2012-01-19'),(8276,'g',0,'2012-01-19'),(8200,'g',0,'2012-01-19'),(8281,'g',0,'2012-01-19'),(8223,'g',0,'2012-01-19'),(8231,'g',0,'2012-01-19'),(8222,'g',0,'2012-01-19'),(8227,'g',0,'2012-01-19'),(8284,'g',0,'2012-01-19'),(8214,'g',0,'2012-01-19'),(8275,'g',0,'2012-01-19'),(8269,'g',0,'2012-01-19'),(8244,'g',0,'2012-01-19'),(7544,'g',0,'2012-01-20'),(7543,'g',0,'2012-01-20'),(7538,'g',0,'2012-01-20'),(7539,'g',0,'2012-01-20'),(7545,'g',0,'2012-01-20'),(7535,'g',0,'2012-01-20'),(7537,'g',0,'2012-01-20'),(7542,'g',0,'2012-01-20'),(7546,'g',0,'2012-01-20'),(7540,'g',0,'2012-01-20'),(7260,'g',0,'2012-01-20'),(7265,'g',0,'2012-01-20'),(8290,'g',0,'2012-01-20'),(8270,'g',0,'2012-01-20'),(8289,'g',0,'2012-01-20'),(8051,'g',0,'2012-01-20'),(8287,'g',0,'2012-01-20'),(8285,'g',0,'2012-01-20'),(8286,'g',0,'2012-01-20'),(8288,'g',0,'2012-01-20'),(7340,'g',0,'2012-01-20'),(7281,'g',0,'2012-01-20'),(7319,'g',0,'2012-01-20'),(7282,'g',0,'2012-01-20'),(7341,'g',0,'2012-01-20'),(7323,'g',0,'2012-01-20'),(7284,'g',0,'2012-01-20'),(8181,'g',0,'2012-01-20'),(8198,'g',0,'2012-01-20'),(8175,'g',0,'2012-01-20'),(8215,'g',0,'2012-01-20'),(8172,'g',0,'2012-01-20'),(8208,'g',0,'2012-01-20'),(8204,'g',0,'2012-01-20'),(8205,'g',0,'2012-01-20'),(8202,'g',0,'2012-01-20'),(8184,'g',0,'2012-01-20'),(7395,'g',0,'2012-01-20'),(7409,'g',0,'2012-01-20'),(7514,'g',0,'2012-01-20'),(7527,'g',0,'2012-01-20'),(7421,'g',0,'2012-01-20'),(7496,'g',0,'2012-01-20'),(7481,'g',0,'2012-01-20'),(7499,'g',0,'2012-01-20'),(7469,'g',0,'2012-01-20'),(7456,'g',0,'2012-01-20'),(7442,'g',0,'2012-01-20'),(7477,'g',0,'2012-01-20'),(8280,'g',0,'2012-01-23'),(8325,'g',0,'2012-01-25'),(8294,'g',0,'2012-01-26'),(8324,'g',0,'2012-01-28'),(8317,'g',0,'2012-01-28'),(8199,'g',0,'2012-01-29'),(8310,'g',0,'2012-01-29'),(8320,'g',0,'2012-02-01'),(8326,'g',0,'2012-02-01'),(8367,'g',0,'2012-02-05'),(8415,'g',0,'2012-02-06'),(8388,'g',0,'2012-02-08'),(8348,'g',0,'2012-02-08'),(8387,'g',0,'2012-02-08'),(8346,'g',0,'2012-02-09'),(8385,'g',0,'2012-02-10'),(8118,'g',0,'2012-02-11'),(8421,'g',0,'2012-02-11'),(8380,'g',0,'2012-02-12'),(7628,'g',0,'2012-02-12'),(7752,'g',0,'2012-02-12'),(7598,'g',0,'2012-02-12'),(7620,'g',0,'2012-02-12'),(7600,'g',0,'2012-02-12'),(7604,'g',0,'2012-02-12'),(7763,'g',0,'2012-02-12'),(7599,'g',0,'2012-02-12'),(7597,'g',0,'2012-02-12'),(7689,'g',0,'2012-02-12'),(7773,'g',0,'2012-02-12'),(7904,'g',0,'2012-02-12'),(7866,'g',0,'2012-02-12'),(7935,'g',0,'2012-02-12'),(7865,'g',0,'2012-02-12'),(7966,'g',0,'2012-02-12'),(7857,'g',0,'2012-02-12'),(7959,'g',0,'2012-02-12'),(7528,'g',0,'2012-02-12'),(7475,'g',0,'2012-02-12'),(7595,'g',0,'2012-02-12'),(7536,'g',0,'2012-02-12'),(7362,'g',0,'2012-02-12'),(7559,'g',0,'2012-02-12'),(7482,'g',0,'2012-02-12'),(7560,'g',0,'2012-02-12'),(7437,'g',0,'2012-02-12'),(7305,'g',0,'2012-02-12'),(8304,'g',0,'2012-02-13'),(8371,'g',0,'2012-02-13'),(8253,'g',0,'2012-02-13'),(8372,'g',0,'2012-02-13'),(8412,'g',0,'2012-02-13'),(8316,'g',0,'2012-02-13'),(8411,'g',0,'2012-02-13'),(8309,'g',0,'2012-02-13'),(8426,'g',0,'2012-02-13'),(7280,'g',0,'2012-02-13'),(7199,'g',0,'2012-02-13'),(7426,'g',0,'2012-02-13'),(7894,'g',0,'2012-02-13'),(7656,'g',0,'2012-02-13'),(8124,'g',0,'2012-02-13'),(8122,'g',0,'2012-02-13'),(7252,'g',0,'2012-02-13'),(7710,'g',0,'2012-02-13'),(7691,'g',0,'2012-02-13'),(7769,'g',0,'2012-02-13'),(7400,'g',0,'2012-02-13'),(7668,'g',0,'2012-02-13'),(7718,'g',0,'2012-02-13'),(7396,'g',0,'2012-02-13'),(7834,'g',0,'2012-02-13'),(7799,'g',0,'2012-02-13'),(7840,'g',0,'2012-02-13'),(7892,'g',0,'2012-02-13'),(7905,'g',0,'2012-02-13'),(7863,'g',0,'2012-02-13'),(7848,'g',0,'2012-02-13'),(7877,'g',0,'2012-02-13'),(7922,'g',0,'2012-02-13'),(7891,'g',0,'2012-02-13'),(7446,'g',0,'2012-02-13'),(407,'g',0,'2012-02-14'),(8409,'g',0,'2012-02-14'),(8416,'g',0,'2012-02-14'),(8401,'g',0,'2012-02-14'),(8383,'g',0,'2012-02-14'),(8405,'g',0,'2012-02-14'),(8407,'g',0,'2012-02-14'),(8377,'g',0,'2012-02-14'),(8318,'g',0,'2012-02-14'),(8381,'g',0,'2012-02-14'),(8408,'g',0,'2012-02-14'),(8315,'g',0,'2012-02-14'),(8397,'g',0,'2012-02-14'),(8308,'g',0,'2012-02-14'),(8233,'g',0,'2012-02-14'),(8256,'g',0,'2012-02-14'),(8278,'g',0,'2012-02-14'),(8277,'g',0,'2012-02-14'),(8243,'g',0,'2012-02-14'),(8247,'g',0,'2012-02-14'),(8314,'g',0,'2012-02-14'),(8260,'g',0,'2012-02-14'),(8248,'g',0,'2012-02-14'),(7701,'g',0,'2012-02-14'),(7216,'g',0,'2012-02-14'),(7196,'g',0,'2012-02-14'),(8293,'g',0,'2012-02-14'),(7471,'g',0,'2012-02-14'),(8366,'g',0,'2012-02-14'),(7428,'g',0,'2012-02-14'),(7195,'g',0,'2012-02-14'),(7954,'g',0,'2012-02-14'),(7957,'g',0,'2012-02-14'),(7792,'g',0,'2012-02-14'),(7927,'g',0,'2012-02-14'),(7962,'g',0,'2012-02-14'),(7231,'g',0,'2012-02-14'),(8197,'g',0,'2012-02-14'),(8229,'g',0,'2012-02-14'),(8044,'g',0,'2012-02-14'),(8062,'g',0,'2012-02-14'),(8423,'g',0,'2012-02-14'),(8242,'g',0,'2012-02-14'),(7590,'g',0,'2012-02-14'),(7933,'g',0,'2012-02-14'),(7761,'g',0,'2012-02-14'),(7459,'g',0,'2012-02-14'),(7490,'g',0,'2012-02-14'),(7533,'g',0,'2012-02-14'),(7443,'g',0,'2012-02-14'),(7963,'g',0,'2012-02-14'),(7259,'g',0,'2012-02-14'),(7465,'g',0,'2012-02-14'),(7950,'g',0,'2012-02-14'),(7832,'g',0,'2012-02-14'),(104,'g',0,'2012-02-14'),(7166,'g',0,'2012-02-14'),(7455,'g',0,'2012-02-14'),(7264,'g',0,'2012-02-14'),(7633,'g',0,'2012-02-14'),(7744,'g',0,'2012-02-14'),(7619,'g',0,'2012-02-14'),(7653,'g',0,'2012-02-14'),(7687,'g',0,'2012-02-14'),(7670,'g',0,'2012-02-14'),(7679,'g',0,'2012-02-14'),(7740,'g',0,'2012-02-14'),(7713,'g',0,'2012-02-14'),(7730,'g',0,'2012-02-14'),(7462,'g',0,'2012-02-14'),(7870,'g',0,'2012-02-14'),(7646,'g',0,'2012-02-14'),(7325,'g',0,'2012-02-14'),(8437,'g',0,'2012-02-14'),(7205,'g',0,'2012-02-14'),(7450,'g',0,'2012-02-14'),(7948,'g',0,'2012-02-14'),(7463,'g',0,'2012-02-14'),(7483,'g',0,'2012-02-14'),(7531,'g',0,'2012-02-14'),(7519,'g',0,'2012-02-14'),(7515,'g',0,'2012-02-14'),(7512,'g',0,'2012-02-14'),(7480,'g',0,'2012-02-14'),(7500,'g',0,'2012-02-14'),(7494,'g',0,'2012-02-14'),(8439,'g',0,'2012-02-14'),(7452,'g',0,'2012-02-14'),(8146,'g',0,'2012-02-14'),(7438,'g',0,'2012-02-15'),(7420,'g',0,'2012-02-15'),(7433,'g',0,'2012-02-15'),(7430,'g',0,'2012-02-15'),(7467,'g',0,'2012-02-15'),(7445,'g',0,'2012-02-15'),(7479,'g',0,'2012-02-15'),(7476,'g',0,'2012-02-15'),(7478,'g',0,'2012-02-15'),(7419,'g',0,'2012-02-15'),(7454,'g',0,'2012-02-15'),(7849,'g',0,'2012-02-15'),(7858,'g',0,'2012-02-15'),(7255,'g',0,'2012-02-15'),(7856,'g',0,'2012-02-15'),(7828,'g',0,'2012-02-15'),(7820,'g',0,'2012-02-15'),(7824,'g',0,'2012-02-15'),(7825,'g',0,'2012-02-15'),(7850,'g',0,'2012-02-15'),(8292,'g',0,'2012-02-15'),(7831,'g',0,'2012-02-15'),(7617,'g',0,'2012-02-15'),(7589,'g',0,'2012-02-15'),(7616,'g',0,'2012-02-15'),(7581,'g',0,'2012-02-15'),(7568,'g',0,'2012-02-15'),(7592,'g',0,'2012-02-15'),(7562,'g',0,'2012-02-15'),(7860,'g',0,'2012-02-15'),(7618,'g',0,'2012-02-15'),(7572,'g',0,'2012-02-15'),(7615,'g',0,'2012-02-15'),(7851,'g',0,'2012-02-15'),(8436,'g',0,'2012-02-15'),(7460,'g',0,'2012-02-15'),(7258,'g',0,'2012-02-15'),(7399,'g',0,'2012-02-15'),(7307,'g',0,'2012-02-15'),(7457,'g',0,'2012-02-15'),(7387,'g',0,'2012-02-15'),(7257,'g',0,'2012-02-15'),(7160,'g',0,'2012-02-15'),(7376,'g',0,'2012-02-15'),(7256,'g',0,'2012-02-15'),(7169,'g',0,'2012-02-15'),(8410,'g',0,'2012-02-15'),(7347,'g',0,'2012-02-15'),(8190,'g',0,'2012-02-15'),(8402,'g',0,'2012-02-15'),(8395,'g',0,'2012-02-15'),(8295,'g',0,'2012-02-15'),(8096,'g',0,'2012-02-15'),(7723,'g',0,'2012-02-15'),(7702,'g',0,'2012-02-15'),(7707,'g',0,'2012-02-15'),(7776,'g',0,'2012-02-15'),(7786,'g',0,'2012-02-15'),(7722,'g',0,'2012-02-15'),(7785,'g',0,'2012-02-15'),(7788,'g',0,'2012-02-15'),(7750,'g',0,'2012-02-15'),(7634,'g',0,'2012-02-15'),(7624,'g',0,'2012-02-15'),(7965,'g',0,'2012-02-15'),(7764,'g',0,'2012-02-15'),(7464,'g',0,'2012-02-15'),(7248,'g',0,'2012-02-15'),(8045,'g',0,'2012-02-15'),(8041,'g',0,'2012-02-15'),(7534,'g',0,'2012-02-15'),(8067,'g',0,'2012-02-15'),(7762,'g',0,'2012-02-15'),(7932,'g',0,'2012-02-15'),(7627,'g',0,'2012-02-15'),(7929,'g',0,'2012-02-15'),(7163,'g',0,'2012-02-15'),(8059,'g',0,'2012-02-15'),(7867,'g',0,'2012-02-15'),(7365,'g',0,'2012-02-15'),(8066,'g',0,'2012-02-15'),(8042,'g',0,'2012-02-15'),(7188,'g',0,'2012-02-15'),(7971,'g',0,'2012-02-15'),(7946,'g',0,'2012-02-15'),(7938,'g',0,'2012-02-15'),(7969,'g',0,'2012-02-15'),(7214,'g',0,'2012-02-15'),(7821,'g',0,'2012-02-15'),(7897,'g',0,'2012-02-15'),(7815,'g',0,'2012-02-15'),(7363,'g',0,'2012-02-15'),(7915,'g',0,'2012-02-15'),(7819,'g',0,'2012-02-15'),(7822,'g',0,'2012-02-15'),(7304,'g',0,'2012-02-15'),(7912,'g',0,'2012-02-15'),(7908,'g',0,'2012-02-15'),(7787,'g',0,'2012-02-15'),(7918,'g',0,'2012-02-15'),(7779,'g',0,'2012-02-15'),(7882,'g',0,'2012-02-15'),(7886,'g',0,'2012-02-15'),(7791,'g',0,'2012-02-15'),(7903,'g',0,'2012-02-15'),(7717,'g',0,'2012-02-15'),(7916,'g',0,'2012-02-15'),(7640,'g',0,'2012-02-15'),(7695,'g',0,'2012-02-15'),(7630,'g',0,'2012-02-15'),(7638,'g',0,'2012-02-15'),(7621,'g',0,'2012-02-15'),(7625,'g',0,'2012-02-15'),(7622,'g',0,'2012-02-15'),(7631,'g',0,'2012-02-15'),(7629,'g',0,'2012-02-15'),(7636,'g',0,'2012-02-15'),(7632,'g',0,'2012-02-15'),(7626,'g',0,'2012-02-15'),(7901,'g',0,'2012-02-15'),(7900,'g',0,'2012-02-15'),(7790,'g',0,'2012-02-15'),(7888,'g',0,'2012-02-15'),(7902,'g',0,'2012-02-15'),(7780,'g',0,'2012-02-15'),(7899,'g',0,'2012-02-15'),(7898,'g',0,'2012-02-15'),(7817,'g',0,'2012-02-15'),(7917,'g',0,'2012-02-15'),(7887,'g',0,'2012-02-15'),(7884,'g',0,'2012-02-15'),(7816,'g',0,'2012-02-15'),(7909,'g',0,'2012-02-15'),(7910,'g',0,'2012-02-15'),(7814,'g',0,'2012-02-15'),(7358,'g',0,'2012-02-15'),(7737,'g',0,'2012-02-15'),(7777,'g',0,'2012-02-15'),(7885,'g',0,'2012-02-15'),(7743,'g',0,'2012-02-15'),(7889,'g',0,'2012-02-15'),(7789,'g',0,'2012-02-15'),(7883,'g',0,'2012-02-15'),(7385,'g',0,'2012-02-15'),(7402,'g',0,'2012-02-15'),(7411,'g',0,'2012-02-15'),(7367,'g',0,'2012-02-15'),(7375,'g',0,'2012-02-15'),(7418,'g',0,'2012-02-16'),(8430,'g',0,'2012-02-16'),(8361,'g',0,'2012-02-16'),(7211,'g',0,'2012-02-16'),(8347,'g',0,'2012-02-16'),(7274,'g',0,'2012-02-16'),(7162,'g',0,'2012-02-16'),(7321,'g',0,'2012-02-16'),(7223,'g',0,'2012-02-16'),(8362,'g',0,'2012-02-16'),(8201,'g',0,'2012-02-16'),(8282,'g',0,'2012-02-16'),(7159,'g',0,'2012-02-16'),(7224,'g',0,'2012-02-16'),(7246,'g',0,'2012-02-16'),(7320,'g',0,'2012-02-16'),(7217,'g',0,'2012-02-16'),(7290,'g',0,'2012-02-16'),(8274,'g',0,'2012-02-16'),(8386,'g',0,'2012-02-16'),(8311,'g',0,'2012-02-16'),(8364,'g',0,'2012-02-16'),(8053,'g',0,'2012-02-16'),(8399,'g',0,'2012-02-16'),(8060,'g',0,'2012-02-16'),(7359,'g',0,'2012-02-16'),(8301,'g',0,'2012-02-16'),(8057,'g',0,'2012-02-16'),(8370,'g',0,'2012-02-16'),(8254,'g',0,'2012-02-16'),(8272,'g',0,'2012-02-16'),(7273,'g',0,'2012-02-16'),(7271,'g',0,'2012-02-16'),(7413,'g',0,'2012-02-16'),(8038,'g',0,'2012-02-16'),(7268,'g',0,'2012-02-16'),(7272,'g',0,'2012-02-16'),(8268,'g',0,'2012-02-16'),(7183,'g',0,'2012-02-16'),(7179,'g',0,'2012-02-16'),(7158,'g',0,'2012-02-16'),(7415,'g',0,'2012-02-16'),(8279,'g',0,'2012-02-16'),(7204,'g',0,'2012-02-16'),(8375,'g',0,'2012-02-16'),(8393,'g',0,'2012-02-16'),(7403,'g',0,'2012-02-16'),(8098,'g',0,'2012-02-16'),(8261,'g',0,'2012-02-16'),(8257,'g',0,'2012-02-16'),(7352,'g',0,'2012-02-16'),(7178,'g',0,'2012-02-16'),(7306,'g',0,'2012-02-16'),(8112,'g',0,'2012-02-16'),(8236,'g',0,'2012-02-16'),(7353,'g',0,'2012-02-16'),(7414,'g',0,'2012-02-16'),(7746,'g',0,'2012-02-16'),(7759,'g',0,'2012-02-16'),(7809,'g',0,'2012-02-16'),(7974,'g',0,'2012-02-16'),(7945,'g',0,'2012-02-16'),(7973,'g',0,'2012-02-16'),(7745,'g',0,'2012-02-16'),(7760,'g',0,'2012-02-16'),(7758,'g',0,'2012-02-16'),(7944,'g',0,'2012-02-16'),(7756,'g',0,'2012-02-16'),(7747,'g',0,'2012-02-16'),(7975,'g',0,'2012-02-16'),(7934,'g',0,'2012-02-16'),(7871,'g',0,'2012-02-16'),(7921,'g',0,'2012-02-16'),(7906,'g',0,'2012-02-16'),(7907,'g',0,'2012-02-16'),(7748,'g',0,'2012-02-16'),(7818,'g',0,'2012-02-16'),(7862,'g',0,'2012-02-16'),(8419,'g',0,'2012-02-16'),(7846,'g',0,'2012-02-16'),(7949,'g',0,'2012-02-16'),(7587,'g',0,'2012-02-16'),(7648,'g',0,'2012-02-16'),(7681,'g',0,'2012-02-16'),(8406,'g',0,'2012-02-16'),(7826,'g',0,'2012-02-16'),(7591,'g',0,'2012-02-16'),(7393,'g',0,'2012-02-16'),(7447,'g',0,'2012-02-16'),(7720,'g',0,'2012-02-16'),(7310,'g',0,'2012-02-17'),(8273,'g',0,'2012-02-17'),(8246,'g',0,'2012-02-17'),(7316,'g',0,'2012-02-17'),(8349,'g',0,'2012-02-17'),(7404,'g',0,'2012-02-17'),(7472,'g',0,'2012-02-17'),(8413,'g',0,'2012-02-17'),(8440,'g',0,'2012-02-17'),(7742,'g',0,'2012-02-17'),(7486,'g',0,'2012-02-17'),(7651,'g',0,'2012-02-17'),(8093,'g',0,'2012-02-17'),(7729,'g',0,'2012-02-17'),(7947,'g',0,'2012-02-17'),(7532,'g',0,'2012-02-17'),(7671,'g',0,'2012-02-17'),(7827,'g',0,'2012-02-17'),(7313,'g',0,'2012-02-17'),(7329,'g',0,'2012-02-17'),(7330,'g',0,'2012-02-17'),(7561,'g',0,'2012-02-17'),(8434,'g',0,'2012-02-17'),(7410,'g',0,'2012-02-17'),(7370,'g',0,'2012-02-17'),(7972,'g',0,'2012-02-17'),(7251,'g',0,'2012-02-17'),(7586,'g',0,'2012-02-17'),(7289,'g',0,'2012-02-17'),(8424,'g',0,'2012-02-18'),(8431,'g',0,'2012-02-18'),(8432,'g',0,'2012-02-18'),(8435,'g',0,'2012-02-19'),(8354,'g',0,'2012-02-20'),(7641,'g',0,'2012-02-20'),(8218,'g',0,'2012-02-20'),(8271,'g',0,'2012-02-20'),(8303,'g',0,'2012-02-20'),(7800,'g',0,'2012-02-20'),(7302,'g',0,'2012-02-20'),(8127,'g',0,'2012-02-20'),(7709,'g',0,'2012-02-20'),(7724,'g',0,'2012-02-20'),(7714,'g',0,'2012-02-20'),(8305,'g',0,'2012-02-20'),(7837,'g',0,'2012-02-20'),(8226,'g',0,'2012-02-20'),(7292,'g',0,'2012-02-20'),(7423,'g',0,'2012-02-21'),(8443,'g',0,'2012-02-21'),(8427,'g',0,'2012-02-21'),(8428,'g',0,'2012-02-21'),(8235,'g',0,'2012-02-21'),(8167,'g',0,'2012-02-21'),(8438,'g',0,'2012-02-21'),(8357,'g',0,'2012-02-21'),(8298,'g',0,'2012-02-21'),(8344,'g',0,'2012-02-21'),(8358,'g',0,'2012-02-21'),(8345,'g',0,'2012-02-21'),(7530,'g',0,'2012-02-21'),(8433,'g',0,'2012-02-21'),(8307,'g',0,'2012-02-21'),(8422,'g',0,'2012-02-23'),(8360,'g',0,'2012-02-23'),(8389,'g',0,'2012-02-23'),(8374,'g',0,'2012-02-23'),(8379,'g',0,'2012-02-23'),(8448,'g',0,'2012-02-23'),(7715,'g',0,'2012-02-23'),(7705,'g',0,'2012-02-23'),(7657,'g',0,'2012-02-23'),(8359,'g',0,'2012-02-23'),(8420,'g',0,'2012-02-23'),(8398,'g',0,'2012-02-23'),(8453,'g',0,'2012-02-23'),(8378,'g',0,'2012-02-23'),(8404,'g',0,'2012-02-23'),(8396,'g',0,'2012-02-23'),(7704,'g',0,'2012-02-23'),(7711,'g',0,'2012-02-23'),(395,'g',0,'2012-02-23'),(7549,'g',0,'2012-02-23'),(8121,'g',0,'2012-02-23'),(7550,'g',0,'2012-02-23'),(7658,'g',0,'2012-02-24'),(7666,'g',0,'2012-02-24'),(8392,'g',0,'2012-02-24'),(8417,'g',0,'2012-02-24'),(7548,'g',0,'2012-02-24'),(7570,'g',0,'2012-02-24'),(7639,'g',0,'2012-02-24'),(7703,'g',0,'2012-02-24'),(7574,'g',0,'2012-02-24'),(7576,'g',0,'2012-02-24'),(7688,'g',0,'2012-02-24'),(7577,'g',0,'2012-02-24'),(7522,'g',0,'2012-02-24'),(8449,'g',0,'2012-02-24'),(7573,'g',0,'2012-02-24'),(7575,'g',0,'2012-02-24'),(8319,'g',0,'2012-02-25'),(8220,'g',0,'2012-02-25'),(8425,'g',0,'2012-02-25'),(7266,'g',0,'2012-02-25'),(7547,'g',0,'2012-02-25'),(8390,'g',0,'2012-02-25'),(165,'g',0,'2012-02-29'),(8457,'g',0,'2012-03-01'),(162,'g',0,'2012-03-01'),(194,'g',0,'2012-03-01'),(8459,'g',0,'2012-03-02'),(8482,'g',0,'2012-03-02'),(8490,'g',0,'2012-03-04'),(8485,'g',0,'2012-03-04'),(8473,'g',0,'2012-03-04'),(8474,'g',0,'2012-03-04'),(8510,'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_pl_sociable`
--

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

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

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

--
-- Table structure for table `idx_pl_twitter_account`
--

CREATE TABLE `idx_pl_twitter_account` (
  `ck` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `cs` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `at` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `ats` varchar(255) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_pl_twitter_account`
--

INSERT INTO `idx_pl_twitter_account` VALUES ('','','','');

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

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

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

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

CREATE TABLE `idx_review` (
  `review_id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `link_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `review` text 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`
--

INSERT INTO `idx_searchlog` VALUES ('eyelidplasticsurgerylosangeles.com','2011-12-02 16:00:22',6,'203.92.47.195'),('eyelidplasticsurgerylosangeles.com','2011-12-02 16:00:53',6,'203.92.47.195'),('sinussurgerylosangeles.com','2011-12-02 16:35:12',6,'203.92.47.195'),('sinussurgerylosangeles.com','2011-12-02 16:35:27',6,'203.92.47.195'),('Hernialosangeles.com','2011-12-02 17:05:06',6,'203.92.47.195'),('Hernialosangeles.com','2011-12-02 17:05:11',6,'203.92.47.195'),('lighting55.com','2011-12-05 14:53:58',8,'203.92.47.195'),('lighting55.com','2011-12-05 15:16:10',8,'203.92.47.195');

--
-- 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','webmash.org'),(5,'site_url','http://webmash.org'),(6,'email_address','briannes.tufo@gmail.com'),(7,'language_code','en_US'),(8,'theme_path','/home/webmash/public_html/themes/'),(9,'admin_template_path','/home/webmash/public_html/admin_tpl/'),(10,'plugin_path','/home/webmash/public_html/plugin/'),(12,'active_theme','_webmash'),(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`
--



