--
-- Host: dirbull.org    Database: dirbull_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 & Entertainment','','folder.gif','','1',21,'','','1','0','','',0,'',0,0,0,0,0),(2,0,'Automotive','','folder.gif','','1',58,'','','1','0','','',0,'',0,0,0,0,0),(3,0,'Business','','folder.gif','','1',200,'','','1','0','','',0,'',0,0,0,0,0),(4,0,'Careers & Jobs','','folder.gif','','1',2,'','','1','0','','',0,'',1,0,0,0,0),(5,0,'Clothing','','folder.gif','','1',16,'','','1','0','','',0,'',0,0,0,0,0),(6,0,'Communications','','folder.gif','','1',26,'','','1','0','','',0,'',0,0,0,0,0),(7,0,'Computer & Internet','','folder.gif','','1',37,'','','1','0','','',0,'',0,0,0,0,0),(8,0,'Construction and Maintenance','','folder.gif','','1',94,'','','1','0','','',0,'',0,0,0,0,0),(9,0,'Dental','','folder.gif','','1',71,'','','1','0','','',0,'',0,0,0,0,0),(10,0,'Education','','folder.gif','','1',33,'','','1','0','','',0,'',0,0,0,0,0),(11,0,'Employment','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(12,0,'Gifts','','folder.gif','','1',25,'','','1','0','','',0,'',0,0,0,0,0),(13,0,'Hardware & Software','','folder.gif','','1',11,'','','1','0','','',0,'',0,0,0,0,0),(14,0,'Health & fitness','','folder.gif','','1',63,'','','1','0','','',0,'',0,0,0,0,0),(15,0,'Healthcare Services & Products','','folder.gif','','1',168,'','','1','0','','',0,'',0,0,0,0,0),(16,0,'Air Conditioning, Heating & Ventilating','','folder.gif','','1',94,'','','1','0','','',0,'',0,0,0,0,0),(17,0,'Family ,Home & Garden','','folder.gif','','1',244,'','','1','0','','',0,'',1,0,0,0,0),(18,0,'Home Improvement & Interiors','','folder.gif','','1',110,'','','1','0','','',0,'',0,0,0,0,0),(19,0,'Hotels & Restaurants','','folder.gif','','1',91,'','','1','0','','',0,'',0,0,0,0,0),(20,0,'Insurance Agents and Companies','','folder.gif','','1',35,'','','1','0','','',0,'',0,0,0,0,0),(21,0,'Law & Politics','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(22,0,'Lawyers','','folder.gif','','1',217,'','','1','0','','',0,'',0,0,0,0,0),(23,0,'Lifestyle & Relationships','','folder.gif','','1',7,'','','1','0','','',0,'',0,0,0,0,0),(24,0,'Medicine','','folder.gif','','1',13,'','','1','0','','',0,'',0,0,0,0,0),(25,0,'Money & Finance','','folder.gif','','1',26,'','','1','0','','',0,'',0,0,0,0,0),(26,0,'News & Issues','','folder.gif','','1',2,'','','1','0','','',0,'',0,0,0,0,0),(27,0,'Plumbing','','folder.gif','','1',49,'','','1','0','','',0,'',0,0,0,0,0),(28,0,'Real Estate','','folder.gif','','1',46,'','','1','0','','',0,'',0,0,0,0,0),(29,0,'Science & Technology','','folder.gif','','1',16,'','','1','0','','',0,'',0,0,0,0,0),(30,0,'SEO & SMO','','folder.gif','','1',28,'','','1','0','','',0,'',0,0,0,0,0),(31,0,'Shopping','','folder.gif','','1',85,'','','1','0','','',0,'',0,0,0,0,0),(32,0,'Sports & Games','','folder.gif','','1',10,'','','1','0','','',0,'',0,0,0,0,0),(33,0,'Transportation and Logistics','','folder.gif','','1',64,'','','1','0','','',0,'',0,0,0,0,0),(34,0,'Travel','','folder.gif','','1',28,'','','1','0','','',0,'',0,0,0,0,0),(35,0,'Wedding','','folder.gif','','1',14,'','','1','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 & Entertainment','<a href=\"http://dirbull.org/arts-entertainment/\" name=\"cat_1\" style=\"\">Arts & Entertainment</a>',';0;'),(2,'Automotive','<a href=\"http://dirbull.org/automotive/\" name=\"cat_2\" style=\"\">Automotive</a>',';0;'),(3,'Business','<a href=\"http://dirbull.org/business/\" name=\"cat_3\" style=\"\">Business</a>',';0;'),(4,'Careers & Jobs','<a href=\"http://dirbull.org/careers-jobs/\" name=\"cat_4\" style=\"\">Careers & Jobs</a>',';0;'),(5,'Clothing','<a href=\"http://dirbull.org/clothing/\" name=\"cat_5\" style=\"\">Clothing</a>',';0;'),(6,'Communications','<a href=\"http://dirbull.org/communications/\" name=\"cat_6\" style=\"\">Communications</a>',';0;'),(7,'Computer & Internet','<a href=\"http://dirbull.org/computer-internet/\" name=\"cat_7\" style=\"\">Computer & Internet</a>',';0;'),(8,'Construction and Maintenance','<a href=\"http://dirbull.org/construction-and-maintenance/\" name=\"cat_8\" style=\"\">Construction and Maintenance</a>',';0;'),(9,'Dental','<a href=\"http://dirbull.org/dental/\" name=\"cat_9\" style=\"\">Dental</a>',';0;'),(10,'Education','<a href=\"http://dirbull.org/education/\" name=\"cat_10\" style=\"\">Education</a>',';0;'),(11,'Employment','<a href=\"http://dirbull.org/employment/\" name=\"cat_11\" style=\"\">Employment</a>',';0;'),(12,'Gifts','<a href=\"http://dirbull.org/gifts/\" name=\"cat_12\" style=\"\">Gifts</a>',';0;'),(13,'Hardware & Software','<a href=\"http://dirbull.org/hardware-software/\" name=\"cat_13\" style=\"\">Hardware & Software</a>',';0;'),(14,'Health & fitness','<a href=\"http://dirbull.org/health-fitness/\" name=\"cat_14\" style=\"\">Health & fitness</a>',';0;'),(15,'Healthcare Services & Products','<a href=\"http://dirbull.org/healthcare-services-products/\" name=\"cat_15\" style=\"\">Healthcare Services & Products</a>',';0;'),(16,'Air Conditioning, Heating & Ventilating','<a href=\"http://dirbull.org/air-conditioning-heating-ventilating/\" name=\"cat_16\" style=\"\">Air Conditioning, Heating & Ventilating</a>',';0;'),(17,'Family ,Home & Garden','<a href=\"http://dirbull.org/family-home-garden/\" name=\"cat_17\" style=\"\">Family ,Home & Garden</a>',';0;'),(18,'Home Improvement & Interiors','<a href=\"http://dirbull.org/home-improvement-interiors/\" name=\"cat_18\" style=\"\">Home Improvement & Interiors</a>',';0;'),(19,'Hotels & Restaurants','<a href=\"http://dirbull.org/hotels-restaurants/\" name=\"cat_19\" style=\"\">Hotels & Restaurants</a>',';0;'),(20,'Insurance Agents and Companies','<a href=\"http://dirbull.org/insurance-agents-and-companies/\" name=\"cat_20\" style=\"\">Insurance Agents and Companies</a>',';0;'),(21,'Law & Politics','<a href=\"http://dirbull.org/law-politics/\" name=\"cat_21\" style=\"\">Law & Politics</a>',';0;'),(22,'Lawyers','<a href=\"http://dirbull.org/lawyers/\" name=\"cat_22\" style=\"\">Lawyers</a>',';0;'),(23,'Lifestyle & Relationships','<a href=\"http://dirbull.org/lifestyle-relationships/\" name=\"cat_23\" style=\"\">Lifestyle & Relationships</a>',';0;'),(24,'Medicine','<a href=\"http://dirbull.org/medicine/\" name=\"cat_24\" style=\"\">Medicine</a>',';0;'),(25,'Money & Finance','<a href=\"http://dirbull.org/money-finance/\" name=\"cat_25\" style=\"\">Money & Finance</a>',';0;'),(26,'News & Issues','<a href=\"http://dirbull.org/news-issues/\" name=\"cat_26\" style=\"\">News & Issues</a>',';0;'),(27,'Plumbing','<a href=\"http://dirbull.org/plumbing/\" name=\"cat_27\" style=\"\">Plumbing</a>',';0;'),(28,'Real Estate','<a href=\"http://dirbull.org/real-estate/\" name=\"cat_28\" style=\"\">Real Estate</a>',';0;'),(29,'Science & Technology','<a href=\"http://dirbull.org/science-technology/\" name=\"cat_29\" style=\"\">Science & Technology</a>',';0;'),(30,'SEO & SMO','<a href=\"http://dirbull.org/seo-smo/\" name=\"cat_30\" style=\"\">SEO & SMO</a>',';0;'),(31,'Shopping','<a href=\"http://dirbull.org/shopping/\" name=\"cat_31\" style=\"\">Shopping</a>',';0;'),(32,'Sports & Games','<a href=\"http://dirbull.org/sports-games/\" name=\"cat_32\" style=\"\">Sports & Games</a>',';0;'),(33,'Transportation and Logistics','<a href=\"http://dirbull.org/transportation-and-logistics/\" name=\"cat_33\" style=\"\">Transportation and Logistics</a>',';0;'),(34,'Travel','<a href=\"http://dirbull.org/travel/\" name=\"cat_34\" style=\"\">Travel</a>',';0;'),(35,'Wedding','<a href=\"http://dirbull.org/wedding/\" name=\"cat_35\" style=\"\">Wedding</a>',';0;');

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

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

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

INSERT INTO `idx_category_suggession` VALUES (1,23,'Candid','I\'d venture that this atrcile has saved me more time than any other.','2011-11-15 13:34: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 AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_favorites` VALUES (1,'wilsonmorganb31e41','2011-10-18','My Favorites',NULL),(2,'dennisryanq90x48','2011-10-19','My Favorites',NULL),(3,'henryeduardou73r43','2011-10-19','My Favorites',NULL),(4,'billiealvan30p11','2011-10-31','My Favorites',NULL),(5,'erniejosephx87j28','2011-11-02','My Favorites',NULL),(6,'darronmonroeh65b27','2011-11-02','My Favorites',NULL),(7,'vanscilwj610','2011-11-03','My Favorites',NULL),(8,'shaleeft','2011-11-11','My Favorites',NULL),(9,'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_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',6,'2011-09-13'),(2,'g',0,'2011-09-13'),(3,'g',6,'2011-09-15'),(16,'g',0,'2012-03-06'),(5,'g',6,'2011-09-19'),(7,'g',1,'2011-09-19'),(9,'g',3,'2011-09-19'),(4,'g',2,'2011-09-19'),(8,'g',1,'2011-09-19'),(6,'g',0,'2011-09-19'),(10,'g',4,'2011-09-19'),(11,'g',0,'2012-01-09'),(20,'g',3,'2011-09-21'),(21,'g',0,'2011-09-21'),(116,'g',1,'2011-09-23'),(123,'g',1,'2011-09-23'),(93,'g',0,'2011-11-08'),(68,'g',0,'2011-11-08'),(91,'g',0,'2011-11-03'),(29,'g',3,'2011-09-24'),(119,'g',0,'2011-09-25'),(121,'g',0,'2011-09-25'),(35,'g',0,'2012-01-09'),(81,'g',0,'2012-01-09'),(117,'g',0,'2011-09-25'),(127,'g',0,'2011-09-25'),(122,'g',2,'2011-09-25'),(39,'g',0,'2011-11-03'),(58,'g',0,'2012-01-21'),(72,'g',0,'2011-11-08'),(89,'g',0,'2011-11-11'),(118,'g',5,'2011-09-25'),(103,'g',0,'2011-11-08'),(106,'g',0,'2012-01-15'),(57,'g',0,'2012-01-09'),(125,'g',0,'2011-09-25'),(135,'g',0,'2011-09-25'),(144,'g',0,'2011-09-25'),(146,'g',0,'2011-09-25'),(136,'g',2,'2011-09-25'),(147,'g',2,'2011-09-25'),(83,'g',0,'2012-02-05'),(78,'g',0,'2012-02-05'),(64,'g',0,'2012-02-05'),(82,'g',0,'2012-02-05'),(129,'g',0,'2011-09-26'),(120,'g',2,'2011-09-26'),(145,'g',2,'2011-09-26'),(132,'g',2,'2011-09-26'),(60,'g',0,'2012-01-16'),(87,'g',0,'2011-11-08'),(161,'g',0,'2011-11-08'),(88,'g',0,'2012-01-22'),(80,'g',0,'2012-02-10'),(99,'g',0,'2012-02-10'),(38,'g',0,'2012-02-10'),(77,'g',0,'2012-02-10'),(44,'g',0,'2012-02-10'),(94,'g',0,'2012-02-10'),(75,'g',0,'2011-11-03'),(95,'g',0,'2012-02-10'),(65,'g',0,'2012-02-10'),(124,'g',2,'2011-09-30'),(12,'g',0,'2011-12-25'),(100,'g',0,'2011-09-30'),(172,'g',0,'2012-02-22'),(30,'g',2,'2011-09-30'),(173,'g',0,'2012-01-21'),(149,'g',0,'2011-09-30'),(148,'g',0,'2011-09-30'),(137,'g',0,'2011-09-30'),(70,'g',3,'2011-09-30'),(98,'g',0,'2011-12-24'),(51,'g',0,'2012-02-29'),(152,'g',0,'2011-12-25'),(36,'g',3,'2011-09-30'),(26,'g',0,'2012-01-09'),(32,'g',0,'2011-11-12'),(104,'g',3,'2011-09-30'),(86,'g',2,'2011-09-30'),(52,'g',0,'2012-02-29'),(25,'g',0,'2012-01-09'),(14,'g',0,'2011-12-27'),(71,'g',3,'2011-09-30'),(66,'g',0,'2012-02-28'),(115,'g',2,'2011-09-30'),(42,'g',0,'2012-02-21'),(79,'g',0,'2012-02-21'),(50,'g',0,'2012-02-21'),(102,'g',0,'2012-02-21'),(101,'g',0,'2012-02-21'),(61,'g',0,'2012-02-21'),(85,'g',0,'2012-01-21'),(112,'g',0,'2012-02-21'),(114,'g',2,'2011-09-30'),(141,'g',3,'2011-09-30'),(55,'g',0,'2012-02-29'),(27,'g',0,'2012-02-29'),(56,'g',0,'2011-12-27'),(45,'g',0,'2012-02-29'),(126,'g',4,'2011-09-30'),(37,'g',0,'2011-09-30'),(67,'g',0,'2012-02-28'),(138,'g',4,'2011-09-30'),(31,'g',3,'2011-09-30'),(111,'g',0,'2011-09-30'),(43,'g',0,'2012-02-29'),(40,'g',0,'2012-02-29'),(13,'g',0,'2011-12-27'),(69,'g',0,'2012-02-29'),(131,'g',3,'2011-10-01'),(74,'g',0,'2012-01-09'),(46,'g',0,'2012-01-09'),(47,'g',0,'2012-01-09'),(96,'g',0,'2012-03-01'),(53,'g',0,'2012-01-09'),(140,'g',4,'2011-10-01'),(130,'g',4,'2011-10-01'),(151,'g',0,'2011-10-01'),(113,'g',0,'2012-01-07'),(24,'g',0,'2012-01-11'),(180,'g',0,'2012-01-21'),(218,'g',0,'2012-01-21'),(187,'g',0,'2012-01-21'),(181,'g',0,'2012-01-21'),(107,'g',0,'2012-01-21'),(110,'g',0,'2012-01-18'),(158,'g',0,'2011-11-08'),(108,'g',0,'2011-11-18'),(76,'g',0,'2012-01-21'),(178,'g',0,'2012-01-21'),(105,'g',0,'2012-03-06'),(160,'g',0,'2012-03-06'),(214,'g',0,'2012-03-06'),(153,'g',3,'2011-10-01'),(139,'g',3,'2011-10-01'),(142,'g',3,'2011-10-01'),(133,'g',3,'2011-10-01'),(23,'g',0,'2012-03-06'),(128,'g',3,'2011-10-01'),(134,'g',3,'2011-10-01'),(150,'g',3,'2011-10-01'),(143,'g',3,'2011-10-01'),(34,'g',6,'2011-10-01'),(22,'g',0,'2011-10-01'),(175,'g',5,'2011-10-01'),(33,'g',6,'2011-10-01'),(18,'g',3,'2011-10-01'),(186,'g',0,'2012-01-09'),(28,'g',0,'2012-02-27'),(157,'g',3,'2011-10-02'),(19,'g',3,'2011-10-02'),(154,'g',3,'2011-10-02'),(159,'g',2,'2011-10-02'),(17,'g',0,'2011-10-02'),(156,'g',3,'2011-10-02'),(155,'g',3,'2011-10-06'),(182,'g',0,'2012-03-03'),(63,'g',0,'2011-12-30'),(49,'g',0,'2012-01-23'),(339,'g',0,'2012-03-06'),(97,'g',0,'2012-02-22'),(176,'g',0,'2011-11-14'),(334,'g',0,'2011-10-06'),(185,'g',0,'2012-02-22'),(326,'g',0,'2011-10-07'),(15,'g',0,'2011-11-20'),(84,'g',0,'2011-11-12'),(250,'g',0,'2011-10-07'),(331,'g',0,'2011-10-07'),(270,'g',0,'2012-02-22'),(258,'g',0,'2012-01-23'),(242,'g',0,'2011-10-07'),(177,'g',0,'2012-02-18'),(363,'g',0,'2012-02-27'),(233,'g',0,'2011-10-07'),(235,'g',0,'2011-10-07'),(255,'g',0,'2011-10-07'),(228,'g',0,'2011-10-07'),(238,'g',0,'2011-10-07'),(286,'g',0,'2011-10-07'),(427,'g',0,'2011-10-07'),(385,'g',0,'2011-10-07'),(90,'g',0,'2012-01-27'),(337,'g',0,'2011-10-07'),(281,'g',0,'2012-03-01'),(174,'g',0,'2012-02-13'),(216,'g',0,'2011-11-11'),(73,'g',0,'2012-02-13'),(283,'g',0,'2011-11-20'),(253,'g',0,'2011-10-07'),(240,'g',0,'2011-10-07'),(272,'g',0,'2012-01-11'),(109,'g',0,'2012-01-11'),(386,'g',0,'2012-02-27'),(277,'g',0,'2012-02-13'),(406,'g',0,'2012-02-18'),(245,'g',0,'2011-10-07'),(439,'g',0,'2011-10-07'),(231,'g',0,'2011-10-07'),(54,'g',0,'2012-02-18'),(249,'g',0,'2011-10-07'),(244,'g',0,'2011-10-07'),(295,'g',0,'2011-10-07'),(223,'g',0,'2012-02-13'),(224,'g',0,'2011-11-12'),(450,'g',0,'2011-10-07'),(273,'g',0,'2011-11-14'),(62,'g',0,'2012-02-13'),(426,'g',0,'2011-10-08'),(227,'g',0,'2011-11-11'),(189,'g',0,'2012-02-27'),(59,'g',0,'2012-02-13'),(314,'g',0,'2011-10-08'),(48,'g',0,'2012-02-18'),(338,'g',0,'2011-10-08'),(92,'g',0,'2011-11-12'),(305,'g',0,'2011-10-08'),(184,'g',0,'2012-02-13'),(322,'g',0,'2011-10-08'),(41,'g',0,'2012-02-13'),(526,'g',0,'2012-01-11'),(504,'g',0,'2012-01-11'),(605,'g',0,'2012-02-13'),(608,'g',0,'2012-01-24'),(606,'g',0,'2012-02-13'),(487,'g',0,'2012-02-18'),(603,'g',0,'2012-02-13'),(541,'g',0,'2012-01-11'),(230,'g',0,'2011-10-09'),(215,'g',0,'2012-02-22'),(532,'g',0,'2012-01-24'),(531,'g',0,'2011-12-18'),(538,'g',0,'2011-12-25'),(486,'g',0,'2011-12-18'),(362,'g',0,'2011-10-14'),(720,'g',0,'2012-01-19'),(815,'g',0,'2012-01-27'),(723,'g',0,'2012-01-27'),(721,'g',0,'2012-01-27'),(361,'g',0,'2012-01-27'),(929,'g',0,'2011-12-03'),(797,'g',0,'2012-03-07'),(832,'g',0,'2011-11-22'),(981,'g',0,'2011-11-22'),(724,'g',0,'2011-11-19'),(875,'g',0,'2011-11-22'),(733,'g',0,'2011-11-18'),(774,'g',0,'2012-02-27'),(691,'g',0,'2012-02-17'),(716,'g',0,'2012-01-27'),(729,'g',0,'2011-11-27'),(870,'g',0,'2011-12-03'),(796,'g',0,'2012-01-21'),(715,'g',0,'2011-12-03'),(759,'g',0,'2011-11-27'),(780,'g',0,'2011-12-25'),(688,'g',0,'2012-01-11'),(866,'g',0,'2012-01-11'),(869,'g',0,'2012-01-11'),(867,'g',0,'2012-01-11'),(757,'g',0,'2012-01-11'),(943,'g',0,'2012-01-11'),(865,'g',0,'2012-01-11'),(861,'g',0,'2012-01-11'),(695,'g',0,'2011-11-17'),(702,'g',0,'2012-01-11'),(722,'g',0,'2012-01-11'),(760,'g',0,'2011-12-03'),(1039,'g',0,'2011-11-17'),(817,'g',0,'2011-11-17'),(763,'g',0,'2012-01-21'),(750,'g',0,'2012-01-21'),(740,'g',0,'2012-01-21'),(693,'g',0,'2012-01-21'),(704,'g',0,'2012-02-13'),(742,'g',0,'2012-02-18'),(844,'g',0,'2011-12-03'),(944,'g',0,'2011-12-04'),(745,'g',0,'2012-03-01'),(744,'g',0,'2012-03-01'),(717,'g',0,'2012-01-09'),(1035,'g',0,'2011-12-03'),(810,'g',0,'2011-12-03'),(834,'g',0,'2011-11-20'),(809,'g',0,'2011-12-25'),(816,'g',0,'2011-12-25'),(852,'g',0,'2011-11-20'),(802,'g',0,'2011-11-27'),(278,'g',0,'2012-02-22'),(382,'g',0,'2012-01-23'),(347,'g',0,'2012-02-22'),(771,'g',0,'2012-01-18'),(827,'g',0,'2012-02-29'),(731,'g',0,'2012-02-29'),(878,'g',0,'2012-01-18'),(840,'g',0,'2012-02-29'),(972,'g',0,'2012-01-18'),(988,'g',0,'2012-01-18'),(1048,'g',0,'2012-02-29'),(648,'g',0,'2012-02-05'),(649,'g',0,'2012-02-05'),(567,'g',0,'2012-02-05'),(169,'g',0,'2012-02-05'),(505,'g',0,'2012-02-05'),(800,'g',0,'2012-01-11'),(812,'g',0,'2012-01-11'),(755,'g',0,'2012-03-01'),(226,'g',0,'2012-02-13'),(749,'g',0,'2012-03-01'),(747,'g',0,'2012-03-01'),(712,'g',0,'2012-01-26'),(533,'g',0,'2012-02-13'),(714,'g',0,'2012-03-06'),(540,'g',0,'2012-02-13'),(803,'g',0,'2012-01-25'),(954,'g',0,'2012-03-01'),(694,'g',0,'2011-10-19'),(850,'g',0,'2011-12-18'),(903,'g',0,'2011-12-25'),(728,'g',0,'2012-03-06'),(698,'g',0,'2012-03-06'),(1002,'g',0,'2012-03-01'),(917,'g',0,'2012-01-11'),(282,'g',0,'2011-12-24'),(939,'g',0,'2012-01-11'),(868,'g',0,'2012-02-27'),(829,'g',0,'2011-12-15'),(848,'g',0,'2012-02-27'),(836,'g',0,'2012-02-27'),(808,'g',0,'2012-01-11'),(820,'g',0,'2012-02-27'),(819,'g',0,'2012-02-27'),(813,'g',0,'2012-01-11'),(746,'g',0,'2012-01-21'),(476,'g',0,'2011-12-27'),(914,'g',0,'2011-11-19'),(976,'g',0,'2012-01-11'),(353,'g',0,'2011-12-25'),(969,'g',0,'2012-01-25'),(945,'g',0,'2012-02-10'),(365,'g',0,'2011-10-20'),(274,'g',0,'2012-01-23'),(268,'g',0,'2011-12-25'),(261,'g',0,'2011-12-24'),(411,'g',0,'2011-10-20'),(263,'g',0,'2012-01-23'),(692,'g',0,'2011-12-17'),(266,'g',0,'2011-12-24'),(863,'g',0,'2012-01-09'),(858,'g',0,'2012-01-09'),(1034,'g',0,'2011-12-25'),(838,'g',0,'2012-01-09'),(1024,'g',0,'2012-03-03'),(262,'g',0,'2012-01-09'),(989,'g',0,'2011-10-21'),(188,'g',0,'2012-01-09'),(165,'g',0,'2012-02-22'),(164,'g',0,'2012-01-21'),(171,'g',0,'2012-02-22'),(170,'g',0,'2012-01-21'),(167,'g',0,'2012-01-21'),(166,'g',0,'2012-02-22'),(168,'g',0,'2012-02-22'),(401,'g',0,'2012-03-06'),(349,'g',0,'2012-03-06'),(355,'g',0,'2012-03-06'),(754,'g',0,'2011-10-24'),(762,'g',0,'2011-10-24'),(718,'g',0,'2011-10-24'),(719,'g',0,'2011-10-24'),(738,'g',0,'2011-10-24'),(761,'g',0,'2011-10-24'),(725,'g',0,'2011-10-24'),(683,'g',0,'2011-10-24'),(734,'g',0,'2011-10-24'),(758,'g',0,'2011-10-24'),(195,'g',0,'2011-10-24'),(198,'g',0,'2011-10-24'),(199,'g',0,'2012-01-25'),(200,'g',0,'2011-10-24'),(191,'g',0,'2012-02-22'),(192,'g',0,'2012-02-22'),(196,'g',0,'2012-03-03'),(194,'g',0,'2012-02-22'),(193,'g',0,'2012-02-22'),(197,'g',0,'2011-10-24'),(212,'g',0,'2011-10-24'),(343,'g',0,'2011-10-24'),(265,'g',0,'2011-10-24'),(390,'g',0,'2011-10-24'),(392,'g',0,'2011-10-24'),(359,'g',0,'2011-10-24'),(376,'g',0,'2011-10-24'),(1250,'g',0,'2011-11-27'),(1210,'g',0,'2011-11-27'),(1141,'g',0,'2011-10-26'),(1093,'g',0,'2011-10-26'),(1142,'g',0,'2011-10-26'),(1163,'g',0,'2011-11-27'),(1073,'g',0,'2012-02-13'),(1215,'g',0,'2011-10-26'),(1773,'g',0,'2011-10-26'),(1396,'g',0,'2011-10-26'),(1447,'g',0,'2011-10-26'),(1735,'g',0,'2011-10-26'),(1374,'g',0,'2011-10-26'),(1683,'g',0,'2011-10-26'),(1745,'g',0,'2011-10-26'),(1536,'g',0,'2011-10-26'),(1724,'g',0,'2011-10-26'),(1586,'g',0,'2011-10-26'),(1233,'g',0,'2011-11-27'),(1270,'g',0,'2011-10-26'),(1244,'g',0,'2011-11-27'),(1240,'g',0,'2011-11-27'),(1237,'g',0,'2011-10-26'),(1216,'g',0,'2011-10-26'),(1235,'g',0,'2011-10-26'),(1258,'g',0,'2011-10-26'),(1243,'g',0,'2011-10-26'),(1220,'g',0,'2011-10-26'),(1198,'g',0,'2011-10-27'),(1257,'g',0,'2011-11-27'),(1203,'g',0,'2011-10-27'),(1206,'g',0,'2011-10-27'),(1248,'g',0,'2011-11-27'),(1083,'g',0,'2011-10-27'),(1307,'g',0,'2011-10-27'),(1482,'g',0,'2012-01-11'),(1280,'g',0,'2011-10-27'),(1412,'g',0,'2011-10-27'),(1247,'g',0,'2011-11-27'),(1241,'g',0,'2011-11-27'),(1640,'g',0,'2011-10-27'),(1249,'g',0,'2011-11-27'),(1384,'g',0,'2011-10-27'),(1648,'g',0,'2011-10-27'),(1254,'g',0,'2011-11-27'),(1269,'g',0,'2011-10-27'),(1275,'g',0,'2011-10-27'),(1268,'g',0,'2011-10-27'),(1213,'g',0,'2011-11-27'),(1195,'g',0,'2011-11-30'),(256,'g',0,'2012-02-17'),(1211,'g',0,'2011-10-28'),(1218,'g',0,'2011-10-28'),(1192,'g',0,'2011-12-06'),(1255,'g',0,'2011-12-06'),(1263,'g',0,'2011-11-27'),(2394,'g',0,'2011-10-28'),(2391,'g',0,'2011-10-28'),(1245,'g',0,'2011-11-27'),(1123,'g',0,'2011-10-28'),(1145,'g',0,'2011-11-27'),(1144,'g',0,'2011-11-27'),(1143,'g',0,'2011-10-28'),(1365,'g',0,'2011-11-29'),(1271,'g',0,'2011-12-06'),(2475,'g',0,'2011-10-28'),(1266,'g',0,'2011-12-06'),(1339,'g',0,'2011-10-28'),(1261,'g',0,'2011-12-06'),(1340,'g',0,'2011-10-28'),(1222,'g',0,'2011-11-27'),(1276,'g',0,'2011-11-29'),(1739,'g',0,'2011-10-28'),(1272,'g',0,'2011-12-06'),(1267,'g',0,'2011-12-06'),(1738,'g',0,'2011-10-28'),(1229,'g',0,'2011-10-28'),(1226,'g',0,'2011-10-28'),(1946,'g',0,'2011-10-28'),(2291,'g',0,'2011-10-28'),(2642,'g',0,'2011-10-28'),(1260,'g',0,'2011-11-27'),(1246,'g',0,'2011-11-27'),(2562,'g',0,'2011-10-28'),(1225,'g',0,'2011-10-28'),(1119,'g',0,'2011-11-27'),(1587,'g',0,'2011-10-28'),(2782,'g',0,'2011-10-28'),(1221,'g',0,'2011-10-28'),(1227,'g',0,'2011-10-28'),(1228,'g',0,'2011-10-28'),(1898,'g',0,'2011-10-28'),(1207,'g',0,'2011-10-28'),(1230,'g',0,'2011-11-27'),(1518,'g',0,'2011-10-28'),(2724,'g',0,'2011-10-28'),(1188,'g',0,'2011-10-28'),(1327,'g',0,'2011-10-28'),(1346,'g',0,'2011-10-28'),(1325,'g',0,'2011-10-28'),(1137,'g',0,'2011-10-28'),(1336,'g',0,'2011-10-28'),(1187,'g',0,'2011-10-28'),(1284,'g',0,'2011-10-28'),(1102,'g',0,'2011-10-29'),(1224,'g',0,'2011-10-29'),(1264,'g',0,'2011-10-29'),(1069,'g',0,'2011-12-18'),(1252,'g',0,'2011-10-29'),(1274,'g',0,'2011-10-29'),(1105,'g',0,'2011-10-29'),(1273,'g',0,'2011-10-29'),(1262,'g',0,'2011-10-29'),(1133,'g',0,'2011-10-29'),(1075,'g',0,'2011-10-29'),(1253,'g',0,'2011-10-29'),(1161,'g',0,'2011-10-29'),(1217,'g',0,'2011-10-29'),(1265,'g',0,'2011-10-29'),(1223,'g',0,'2011-10-29'),(1278,'g',0,'2011-10-29'),(1112,'g',0,'2011-10-31'),(183,'g',0,'2012-03-02'),(219,'g',0,'2011-10-31'),(213,'g',0,'2012-03-02'),(225,'g',0,'2012-03-02'),(179,'g',0,'2011-10-31'),(1239,'g',0,'2011-10-31'),(1236,'g',0,'2011-10-31'),(1234,'g',0,'2011-10-31'),(1259,'g',0,'2011-10-31'),(1212,'g',0,'2011-10-31'),(1231,'g',0,'2011-11-01'),(1256,'g',0,'2011-11-01'),(1219,'g',0,'2011-11-01'),(1238,'g',0,'2011-11-01'),(1232,'g',0,'2011-11-01'),(1277,'g',0,'2011-11-01'),(1157,'g',0,'2011-11-03'),(1205,'g',0,'2011-11-03'),(1194,'g',0,'2011-11-03'),(1162,'g',0,'2011-11-03'),(1110,'g',0,'2011-11-03'),(1126,'g',0,'2011-11-03'),(1079,'g',0,'2011-11-03'),(1173,'g',0,'2011-11-03'),(1204,'g',0,'2011-11-03'),(1082,'g',0,'2011-11-03'),(1478,'g',0,'2011-12-17'),(1481,'g',0,'2012-03-07'),(1525,'g',0,'2011-11-03'),(2553,'g',0,'2012-01-18'),(3465,'g',0,'2011-11-05'),(2695,'g',0,'2011-11-05'),(2155,'g',0,'2011-11-05'),(2237,'g',0,'2011-11-05'),(2355,'g',0,'2011-11-05'),(741,'g',0,'2012-03-06'),(706,'g',0,'2012-03-06'),(937,'g',0,'2011-11-05'),(966,'g',0,'2011-11-05'),(855,'g',0,'2012-03-06'),(967,'g',0,'2011-11-05'),(956,'g',0,'2011-11-05'),(1074,'g',0,'2012-03-06'),(1021,'g',0,'2011-11-05'),(2494,'g',0,'2011-11-05'),(3165,'g',0,'2011-11-05'),(2435,'g',0,'2011-11-05'),(3491,'g',0,'2011-11-05'),(2716,'g',0,'2011-11-05'),(2526,'g',0,'2011-11-05'),(2760,'g',0,'2011-11-05'),(2469,'g',0,'2011-11-05'),(2723,'g',0,'2011-11-05'),(2582,'g',0,'2011-11-05'),(2677,'g',0,'2011-11-05'),(938,'g',0,'2011-11-05'),(942,'g',0,'2011-11-05'),(413,'g',0,'2011-11-05'),(697,'g',0,'2012-02-22'),(408,'g',0,'2012-02-22'),(707,'g',0,'2012-02-22'),(959,'g',0,'2011-11-05'),(860,'g',0,'2011-11-05'),(527,'g',0,'2012-03-06'),(518,'g',0,'2011-11-05'),(513,'g',0,'2011-11-05'),(515,'g',0,'2012-03-06'),(409,'g',0,'2012-03-06'),(1115,'g',0,'2011-11-05'),(1078,'g',0,'2011-11-05'),(1080,'g',0,'2011-11-05'),(1106,'g',0,'2011-11-05'),(1134,'g',0,'2011-11-05'),(1479,'g',0,'2011-11-05'),(1477,'g',0,'2011-11-05'),(1375,'g',0,'2011-11-05'),(1514,'g',0,'2011-11-05'),(1505,'g',0,'2011-11-06'),(1347,'g',0,'2011-11-06'),(2681,'g',0,'2011-11-06'),(2691,'g',0,'2011-11-06'),(2707,'g',0,'2011-11-06'),(1138,'g',0,'2011-11-06'),(1150,'g',0,'2011-11-06'),(1177,'g',0,'2011-11-06'),(473,'g',0,'2011-11-06'),(474,'g',0,'2011-11-06'),(471,'g',0,'2011-11-06'),(472,'g',0,'2011-11-06'),(466,'g',0,'2011-11-06'),(469,'g',0,'2011-11-06'),(470,'g',0,'2011-11-06'),(468,'g',0,'2011-11-06'),(467,'g',0,'2011-11-06'),(1064,'g',0,'2011-11-06'),(370,'g',0,'2011-11-06'),(374,'g',0,'2011-11-06'),(279,'g',0,'2011-11-06'),(378,'g',0,'2011-11-06'),(1166,'g',0,'2011-11-06'),(1175,'g',0,'2011-11-06'),(1122,'g',0,'2011-11-06'),(1135,'g',0,'2011-11-06'),(1158,'g',0,'2011-11-06'),(1129,'g',0,'2011-11-06'),(1795,'g',0,'2011-11-07'),(2231,'g',0,'2011-11-07'),(2302,'g',0,'2011-11-07'),(1981,'g',0,'2011-11-07'),(2038,'g',0,'2011-11-07'),(2352,'g',0,'2011-11-07'),(1846,'g',0,'2011-11-07'),(2081,'g',0,'2011-11-07'),(2344,'g',0,'2011-11-07'),(1934,'g',0,'2011-11-07'),(1474,'g',0,'2011-12-18'),(1473,'g',0,'2011-11-11'),(1343,'g',0,'2011-11-11'),(3394,'g',0,'2011-11-11'),(3364,'g',0,'2011-11-11'),(3517,'g',0,'2011-11-11'),(2899,'g',0,'2011-11-11'),(3515,'g',0,'2011-11-11'),(3054,'g',0,'2011-11-11'),(3507,'g',0,'2011-11-11'),(3497,'g',0,'2011-11-11'),(3421,'g',0,'2011-11-11'),(3087,'g',0,'2011-11-11'),(1631,'g',0,'2011-11-11'),(1637,'g',0,'2011-11-11'),(1549,'g',0,'2011-11-11'),(1719,'g',0,'2011-11-11'),(2008,'g',0,'2011-11-11'),(1576,'g',0,'2011-11-11'),(1676,'g',0,'2011-11-11'),(1604,'g',0,'2011-11-11'),(2018,'g',0,'2011-11-11'),(1963,'g',0,'2011-11-11'),(2290,'g',0,'2011-11-12'),(2245,'g',0,'2011-11-12'),(2269,'g',0,'2011-11-12'),(2238,'g',0,'2011-11-12'),(1463,'g',0,'2011-11-12'),(1407,'g',0,'2011-11-12'),(1983,'g',0,'2011-11-12'),(1537,'g',0,'2011-11-12'),(1806,'g',0,'2011-11-12'),(1423,'g',0,'2011-11-12'),(1822,'g',0,'2011-11-12'),(2127,'g',0,'2011-11-12'),(1862,'g',0,'2011-11-12'),(1414,'g',0,'2011-11-12'),(1401,'g',0,'2011-11-12'),(1845,'g',0,'2011-11-12'),(1936,'g',0,'2011-11-12'),(1446,'g',0,'2011-11-12'),(1406,'g',0,'2011-11-12'),(1808,'g',0,'2011-11-12'),(1409,'g',0,'2011-11-12'),(1332,'g',0,'2011-11-12'),(1813,'g',0,'2011-11-12'),(2103,'g',0,'2011-11-12'),(2272,'g',0,'2011-11-13'),(2246,'g',0,'2011-11-13'),(2218,'g',0,'2011-11-13'),(2284,'g',0,'2011-11-13'),(2286,'g',0,'2011-11-13'),(2265,'g',0,'2011-11-13'),(2811,'g',0,'2011-11-13'),(5645,'g',0,'2011-11-13'),(3648,'g',0,'2011-12-17'),(3668,'g',0,'2011-11-13'),(2816,'g',0,'2011-11-13'),(2895,'g',0,'2011-11-13'),(5614,'g',0,'2011-11-13'),(2094,'g',0,'2011-11-14'),(1561,'g',0,'2011-11-14'),(3045,'g',0,'2011-11-14'),(2021,'g',0,'2011-11-14'),(3404,'g',0,'2011-11-14'),(3179,'g',0,'2011-11-14'),(5635,'g',0,'2011-11-14'),(2417,'g',0,'2011-11-14'),(3509,'g',0,'2011-11-14'),(3605,'g',0,'2011-11-14'),(2416,'g',0,'2011-11-14'),(2116,'g',0,'2011-11-14'),(2061,'g',0,'2011-11-14'),(2430,'g',0,'2011-11-14'),(3461,'g',0,'2011-11-14'),(2074,'g',0,'2011-11-14'),(3734,'g',0,'2011-11-14'),(4636,'g',0,'2011-11-14'),(3656,'g',0,'2011-12-15'),(2849,'g',0,'2012-03-01'),(3013,'g',0,'2011-11-14'),(3353,'g',0,'2011-11-14'),(3324,'g',0,'2011-11-14'),(2560,'g',0,'2011-11-14'),(4997,'g',0,'2011-11-14'),(2945,'g',0,'2011-11-14'),(4863,'g',0,'2011-11-14'),(4674,'g',0,'2011-11-14'),(2813,'g',0,'2011-11-14'),(4730,'g',0,'2011-11-14'),(3046,'g',0,'2011-11-14'),(2461,'g',0,'2011-11-14'),(4095,'g',0,'2012-03-02'),(2466,'g',0,'2011-11-14'),(2402,'g',0,'2011-11-14'),(3526,'g',0,'2011-11-14'),(2651,'g',0,'2011-11-14'),(3115,'g',0,'2011-11-14'),(2592,'g',0,'2011-11-14'),(3092,'g',0,'2011-11-14'),(3282,'g',0,'2011-11-14'),(6134,'g',0,'2011-11-14'),(1978,'g',0,'2011-11-14'),(2031,'g',0,'2011-11-14'),(2834,'g',0,'2011-11-14'),(3250,'g',0,'2011-11-14'),(2052,'g',0,'2011-11-14'),(3122,'g',0,'2011-11-14'),(1931,'g',0,'2011-11-14'),(3453,'g',0,'2011-11-14'),(2525,'g',0,'2011-11-14'),(2873,'g',0,'2011-11-14'),(3443,'g',0,'2011-11-14'),(3178,'g',0,'2011-11-14'),(2903,'g',0,'2011-11-14'),(2381,'g',0,'2011-11-14'),(4167,'g',0,'2012-03-01'),(3750,'g',0,'2011-11-14'),(3852,'g',0,'2011-11-14'),(3671,'g',0,'2011-11-14'),(3376,'g',0,'2011-11-14'),(2595,'g',0,'2011-11-14'),(2977,'g',0,'2011-11-14'),(2382,'g',0,'2011-11-14'),(4939,'g',0,'2011-11-14'),(4853,'g',0,'2011-11-14'),(3629,'g',0,'2011-11-14'),(3168,'g',0,'2011-11-14'),(4579,'g',0,'2011-11-14'),(4499,'g',0,'2011-11-14'),(2217,'g',0,'2011-11-14'),(3915,'g',0,'2011-11-14'),(4281,'g',0,'2011-11-14'),(3619,'g',0,'2011-11-14'),(5039,'g',0,'2011-11-14'),(4924,'g',0,'2011-11-14'),(4312,'g',0,'2011-11-14'),(2979,'g',0,'2011-11-14'),(3881,'g',0,'2011-11-14'),(4116,'g',0,'2011-11-14'),(2771,'g',0,'2011-11-14'),(2281,'g',0,'2011-11-14'),(2337,'g',0,'2011-11-14'),(2495,'g',0,'2011-11-14'),(3580,'g',0,'2011-11-14'),(4290,'g',0,'2011-11-14'),(2129,'g',0,'2011-11-14'),(2660,'g',0,'2011-11-14'),(4233,'g',0,'2011-11-14'),(3396,'g',0,'2011-11-14'),(4448,'g',0,'2011-11-14'),(4166,'g',0,'2011-11-14'),(4669,'g',0,'2011-11-14'),(4666,'g',0,'2011-11-14'),(3169,'g',0,'2011-11-14'),(2727,'g',0,'2011-11-14'),(3473,'g',0,'2011-11-14'),(2263,'g',0,'2011-11-14'),(1556,'g',0,'2011-11-14'),(1593,'g',0,'2011-11-14'),(3586,'g',0,'2011-11-14'),(2516,'g',0,'2011-11-14'),(2818,'g',0,'2011-11-14'),(3231,'g',0,'2011-11-14'),(2731,'g',0,'2011-11-14'),(3532,'g',0,'2011-11-14'),(3229,'g',0,'2011-11-14'),(2139,'g',0,'2011-11-14'),(2412,'g',0,'2011-11-14'),(4590,'g',0,'2011-11-14'),(3055,'g',0,'2011-11-14'),(3218,'g',0,'2011-11-14'),(3398,'g',0,'2011-11-14'),(3314,'g',0,'2011-11-14'),(2490,'g',0,'2011-11-14'),(3283,'g',0,'2011-11-14'),(2846,'g',0,'2011-11-14'),(4592,'g',0,'2011-11-14'),(4744,'g',0,'2011-11-14'),(3845,'g',0,'2011-11-14'),(4366,'g',0,'2011-11-14'),(4509,'g',0,'2011-11-14'),(2183,'g',0,'2011-11-14'),(3765,'g',0,'2011-11-14'),(4545,'g',0,'2011-11-14'),(3936,'g',0,'2011-11-14'),(4248,'g',0,'2011-11-14'),(4746,'g',0,'2011-11-14'),(3867,'g',0,'2011-11-14'),(3796,'g',0,'2011-11-14'),(5022,'g',0,'2011-11-14'),(4628,'g',0,'2011-11-14'),(4214,'g',0,'2011-11-14'),(4661,'g',0,'2011-11-14'),(4213,'g',0,'2011-11-14'),(3822,'g',0,'2011-11-14'),(3056,'g',0,'2011-11-14'),(3117,'g',0,'2011-11-14'),(3350,'g',0,'2011-11-14'),(3023,'g',0,'2011-11-14'),(3510,'g',0,'2012-03-01'),(3775,'g',0,'2011-11-14'),(4645,'g',0,'2011-11-14'),(3828,'g',0,'2011-11-14'),(2500,'g',0,'2011-11-14'),(3316,'g',0,'2011-11-14'),(3925,'g',0,'2011-11-14'),(4813,'g',0,'2011-11-14'),(3235,'g',0,'2011-11-14'),(6137,'g',0,'2012-02-29'),(5665,'g',0,'2011-11-14'),(5767,'g',0,'2011-11-14'),(5982,'g',0,'2011-11-14'),(5900,'g',0,'2011-11-14'),(6135,'g',0,'2012-02-29'),(5572,'g',0,'2011-11-14'),(5560,'g',0,'2011-11-14'),(6115,'g',0,'2011-11-14'),(3958,'g',0,'2011-11-14'),(3763,'g',0,'2011-11-14'),(3733,'g',0,'2011-11-14'),(3735,'g',0,'2011-11-15'),(4036,'g',0,'2011-11-15'),(3810,'g',0,'2011-11-15'),(3725,'g',0,'2011-11-15'),(3292,'g',0,'2011-11-15'),(1988,'g',0,'2011-11-15'),(3951,'g',0,'2011-11-15'),(4028,'g',0,'2011-11-15'),(1889,'g',0,'2011-11-15'),(3577,'g',0,'2011-11-15'),(2706,'g',0,'2011-11-15'),(3180,'g',0,'2011-11-15'),(3212,'g',0,'2011-11-15'),(4831,'g',0,'2011-11-15'),(4284,'g',0,'2011-11-15'),(2633,'g',0,'2011-11-15'),(3141,'g',0,'2011-11-15'),(3557,'g',0,'2011-11-15'),(3545,'g',0,'2011-11-15'),(4163,'g',0,'2011-11-15'),(2758,'g',0,'2011-11-15'),(3659,'g',0,'2011-11-15'),(3058,'g',0,'2011-11-15'),(4885,'g',0,'2011-11-15'),(3910,'g',0,'2011-11-15'),(3979,'g',0,'2011-11-15'),(4225,'g',0,'2011-11-15'),(3411,'g',0,'2011-11-15'),(4711,'g',0,'2011-11-15'),(4045,'g',0,'2011-11-15'),(4652,'g',0,'2011-11-15'),(2171,'g',0,'2011-11-15'),(3782,'g',0,'2011-11-15'),(3887,'g',0,'2011-11-15'),(3809,'g',0,'2011-11-15'),(3716,'g',0,'2011-11-15'),(3930,'g',0,'2011-11-15'),(3895,'g',0,'2011-12-18'),(4040,'g',0,'2011-12-18'),(3937,'g',0,'2011-11-15'),(3702,'g',0,'2011-11-15'),(3794,'g',0,'2011-11-15'),(3754,'g',0,'2011-12-18'),(3907,'g',0,'2011-11-15'),(4760,'g',0,'2011-11-15'),(4034,'g',0,'2011-11-15'),(3928,'g',0,'2011-11-15'),(3869,'g',0,'2011-11-15'),(2205,'g',0,'2011-11-15'),(2162,'g',0,'2011-11-15'),(6170,'g',0,'2011-11-15'),(3862,'g',0,'2011-11-15'),(3903,'g',0,'2011-11-15'),(2215,'g',0,'2011-11-15'),(3800,'g',0,'2012-03-04'),(2145,'g',0,'2011-11-15'),(4068,'g',0,'2011-11-15'),(1783,'g',0,'2011-11-15'),(5690,'g',0,'2011-11-15'),(2730,'g',0,'2011-11-15'),(4135,'g',0,'2011-11-15'),(1653,'g',0,'2011-11-15'),(3940,'g',0,'2011-11-15'),(2999,'g',0,'2011-11-15'),(5695,'g',0,'2011-11-15'),(6040,'g',0,'2011-11-15'),(2839,'g',0,'2011-11-15'),(3844,'g',0,'2011-11-15'),(3690,'g',0,'2011-11-15'),(2172,'g',0,'2011-11-15'),(3963,'g',0,'2011-11-15'),(2930,'g',0,'2011-11-15'),(4014,'g',0,'2011-11-15'),(5000,'g',0,'2011-11-15'),(5629,'g',0,'2011-11-15'),(3731,'g',0,'2011-11-15'),(3626,'g',0,'2011-11-15'),(6148,'g',0,'2012-01-27'),(2189,'g',0,'2011-11-15'),(3945,'g',0,'2011-11-15'),(3935,'g',0,'2011-11-15'),(5106,'g',0,'2011-11-15'),(3969,'g',0,'2011-11-15'),(6155,'g',0,'2011-11-15'),(3797,'g',0,'2011-11-15'),(5021,'g',0,'2011-11-15'),(4002,'g',0,'2011-11-15'),(4945,'g',0,'2011-11-15'),(5682,'g',0,'2011-11-15'),(4059,'g',0,'2011-11-15'),(2537,'g',0,'2011-11-15'),(3779,'g',0,'2012-01-27'),(5648,'g',0,'2011-11-15'),(4959,'g',0,'2011-11-15'),(5073,'g',0,'2011-11-15'),(6164,'g',0,'2011-11-15'),(4044,'g',0,'2011-11-15'),(5825,'g',0,'2011-11-15'),(5662,'g',0,'2011-11-15'),(3011,'g',0,'2011-11-15'),(6018,'g',0,'2011-11-15'),(3077,'g',0,'2011-11-15'),(4952,'g',0,'2011-11-15'),(2459,'g',0,'2011-11-15'),(2567,'g',0,'2011-11-15'),(6076,'g',0,'2011-11-15'),(4922,'g',0,'2011-11-15'),(6182,'g',0,'2011-11-15'),(2978,'g',0,'2011-11-15'),(2933,'g',0,'2011-11-15'),(4568,'g',0,'2011-11-15'),(4401,'g',0,'2011-11-15'),(5016,'g',0,'2011-11-15'),(5254,'g',0,'2011-11-15'),(2779,'g',0,'2012-03-03'),(5355,'g',0,'2011-11-15'),(2780,'g',0,'2011-11-15'),(4837,'g',0,'2011-11-15'),(4781,'g',0,'2011-11-15'),(4798,'g',0,'2011-11-15'),(2908,'g',0,'2011-11-15'),(3962,'g',0,'2011-11-15'),(4870,'g',0,'2011-11-15'),(5275,'g',0,'2011-11-15'),(2860,'g',0,'2011-11-15'),(5211,'g',0,'2011-11-15'),(5861,'g',0,'2011-11-15'),(5334,'g',0,'2011-11-15'),(5188,'g',0,'2011-11-15'),(2634,'g',0,'2011-11-15'),(5803,'g',0,'2011-11-15'),(2636,'g',0,'2011-11-15'),(1765,'g',0,'2011-11-15'),(1859,'g',0,'2011-11-15'),(1733,'g',0,'2011-11-15'),(1782,'g',0,'2011-11-15'),(2605,'g',0,'2011-11-15'),(1790,'g',0,'2011-11-15'),(2551,'g',0,'2011-11-15'),(2378,'g',0,'2011-11-15'),(2734,'g',0,'2011-11-15'),(1803,'g',0,'2011-11-15'),(1758,'g',0,'2011-11-15'),(1386,'g',0,'2011-11-15'),(1387,'g',0,'2011-11-15'),(2380,'g',0,'2011-11-15'),(1385,'g',0,'2011-11-15'),(1399,'g',0,'2011-11-15'),(1402,'g',0,'2011-11-15'),(1791,'g',0,'2011-11-15'),(1732,'g',0,'2011-11-15'),(2554,'g',0,'2011-11-15'),(2569,'g',0,'2011-11-15'),(2644,'g',0,'2011-11-15'),(1797,'g',0,'2011-11-15'),(1789,'g',0,'2011-11-15'),(1392,'g',0,'2011-11-15'),(2541,'g',0,'2011-11-15'),(2609,'g',0,'2011-11-15'),(1804,'g',0,'2011-11-15'),(1798,'g',0,'2011-11-15'),(1786,'g',0,'2011-11-15'),(1802,'g',0,'2011-11-15'),(2628,'g',0,'2011-11-15'),(1734,'g',0,'2011-11-15'),(1793,'g',0,'2011-11-15'),(1391,'g',0,'2011-11-15'),(1405,'g',0,'2011-11-15'),(1398,'g',0,'2011-11-15'),(2460,'g',0,'2011-11-15'),(2574,'g',0,'2011-11-15'),(2715,'g',0,'2011-11-15'),(2564,'g',0,'2011-11-15'),(2471,'g',0,'2011-11-15'),(2545,'g',0,'2011-11-15'),(2463,'g',0,'2011-11-15'),(2583,'g',0,'2011-11-15'),(1801,'g',0,'2011-11-15'),(2534,'g',0,'2011-11-15'),(2376,'g',0,'2011-11-15'),(1460,'g',0,'2011-11-15'),(1785,'g',0,'2011-11-15'),(2452,'g',0,'2011-11-15'),(1784,'g',0,'2011-11-15'),(2631,'g',0,'2011-11-15'),(2590,'g',0,'2011-11-15'),(1404,'g',0,'2011-11-15'),(1394,'g',0,'2011-11-15'),(2458,'g',0,'2011-11-15'),(1390,'g',0,'2011-11-15'),(1403,'g',0,'2011-11-15'),(4921,'g',0,'2011-11-15'),(1377,'g',0,'2011-11-15'),(4943,'g',0,'2011-11-15'),(4756,'g',0,'2011-11-15'),(4372,'g',0,'2011-11-15'),(1429,'g',0,'2011-11-15'),(3120,'g',0,'2011-11-15'),(4586,'g',0,'2011-11-15'),(4327,'g',0,'2011-11-15'),(4639,'g',0,'2011-11-15'),(4597,'g',0,'2011-11-15'),(4737,'g',0,'2011-11-15'),(3086,'g',0,'2011-11-15'),(1434,'g',0,'2011-11-15'),(1436,'g',0,'2011-11-15'),(4683,'g',0,'2011-11-15'),(3130,'g',0,'2011-11-15'),(1432,'g',0,'2011-11-15'),(1428,'g',0,'2011-11-15'),(3365,'g',0,'2011-11-15'),(1427,'g',0,'2011-11-15'),(1431,'g',0,'2011-11-15'),(3106,'g',0,'2011-11-15'),(4951,'g',0,'2011-11-15'),(4637,'g',0,'2011-11-15'),(1433,'g',0,'2011-11-15'),(1430,'g',0,'2011-11-15'),(3759,'g',0,'2011-11-15'),(4114,'g',0,'2011-11-15'),(4735,'g',0,'2011-11-15'),(475,'g',0,'2011-11-18'),(407,'g',0,'2011-11-18'),(565,'g',0,'2011-11-18'),(404,'g',0,'2011-11-18'),(488,'g',0,'2011-11-18'),(536,'g',0,'2012-03-04'),(464,'g',0,'2011-11-18'),(465,'g',0,'2011-11-18'),(1070,'g',0,'2011-11-18'),(1072,'g',0,'2011-11-18'),(6335,'g',0,'2011-11-20'),(6341,'g',0,'2011-11-20'),(6299,'g',0,'2011-11-20'),(6236,'g',0,'2011-11-20'),(6256,'g',0,'2011-11-20'),(6272,'g',0,'2011-11-20'),(6296,'g',0,'2011-11-20'),(6232,'g',0,'2011-11-20'),(6237,'g',0,'2011-11-20'),(6229,'g',0,'2011-11-20'),(201,'g',0,'2011-11-23'),(206,'g',0,'2011-11-23'),(204,'g',0,'2011-11-23'),(202,'g',0,'2011-11-23'),(205,'g',0,'2011-11-23'),(203,'g',0,'2011-11-23'),(211,'g',0,'2011-11-23'),(208,'g',0,'2011-11-23'),(207,'g',0,'2011-11-23'),(209,'g',0,'2011-11-23'),(210,'g',0,'2011-11-23'),(1154,'g',0,'2011-11-23'),(1165,'g',0,'2011-11-23'),(1121,'g',0,'2011-11-23'),(1199,'g',0,'2011-11-23'),(1146,'g',0,'2011-11-23'),(597,'g',0,'2011-11-23'),(790,'g',0,'2011-11-23'),(778,'g',0,'2011-11-23'),(602,'g',0,'2011-11-23'),(703,'g',0,'2011-11-23'),(1071,'g',0,'2011-11-23'),(1098,'g',0,'2011-11-23'),(1063,'g',0,'2011-11-23'),(1107,'g',0,'2011-11-23'),(5045,'g',0,'2011-11-24'),(5002,'g',0,'2011-11-24'),(4929,'g',0,'2011-11-24'),(4948,'g',0,'2011-11-24'),(6031,'g',0,'2011-11-24'),(5652,'g',0,'2011-11-24'),(5788,'g',0,'2011-11-24'),(5816,'g',0,'2011-11-24'),(6153,'g',0,'2011-11-24'),(6003,'g',0,'2011-11-24'),(6576,'g',0,'2011-11-24'),(5094,'g',0,'2011-11-26'),(5048,'g',0,'2011-11-26'),(4992,'g',0,'2011-11-26'),(5111,'g',0,'2011-11-26'),(5029,'g',0,'2011-11-26'),(4975,'g',0,'2011-11-26'),(5031,'g',0,'2011-11-26'),(5109,'g',0,'2011-11-26'),(5138,'g',0,'2011-11-26'),(5047,'g',0,'2011-11-26'),(3186,'g',0,'2011-11-26'),(3184,'g',0,'2011-11-26'),(3126,'g',0,'2011-11-26'),(3299,'g',0,'2011-11-26'),(3102,'g',0,'2011-11-26'),(3242,'g',0,'2011-11-26'),(3290,'g',0,'2011-11-26'),(3053,'g',0,'2011-11-26'),(3103,'g',0,'2011-11-26'),(3088,'g',0,'2011-11-26'),(4955,'g',0,'2011-11-26'),(4896,'g',0,'2011-11-26'),(4876,'g',0,'2011-11-26'),(4963,'g',0,'2011-11-26'),(4920,'g',0,'2011-11-26'),(4842,'g',0,'2011-11-26'),(4860,'g',0,'2011-11-26'),(4932,'g',0,'2011-11-26'),(4908,'g',0,'2011-11-26'),(4838,'g',0,'2011-11-26'),(3911,'g',0,'2011-11-27'),(3005,'g',0,'2011-11-27'),(3512,'g',0,'2011-11-27'),(4961,'g',0,'2011-11-27'),(5748,'g',0,'2011-11-27'),(3946,'g',0,'2011-11-27'),(4339,'g',0,'2011-11-27'),(4492,'g',0,'2011-11-27'),(2699,'g',0,'2011-11-27'),(4417,'g',0,'2011-11-27'),(3243,'g',0,'2011-11-27'),(5688,'g',0,'2011-11-27'),(5721,'g',0,'2011-11-27'),(5273,'g',0,'2011-11-27'),(5215,'g',0,'2011-11-27'),(5936,'g',0,'2011-11-27'),(5853,'g',0,'2011-11-27'),(5198,'g',0,'2011-11-27'),(5963,'g',0,'2011-11-27'),(5299,'g',0,'2011-11-27'),(4486,'g',0,'2011-11-27'),(4351,'g',0,'2011-11-27'),(3851,'g',0,'2012-01-11'),(4356,'g',0,'2012-01-11'),(5134,'g',0,'2011-11-27'),(3890,'g',0,'2011-11-27'),(5150,'g',0,'2011-11-27'),(2914,'g',0,'2011-11-27'),(3675,'g',0,'2011-11-27'),(4452,'g',0,'2011-11-27'),(1706,'g',0,'2011-11-27'),(1679,'g',0,'2011-11-27'),(2372,'g',0,'2011-11-27'),(6333,'g',0,'2011-11-27'),(6498,'g',0,'2011-11-27'),(2158,'g',0,'2011-11-27'),(1811,'g',0,'2011-11-27'),(2289,'g',0,'2011-11-27'),(4184,'g',0,'2011-11-27'),(6504,'g',0,'2011-11-27'),(4123,'g',0,'2012-02-28'),(3982,'g',0,'2011-11-27'),(4279,'g',0,'2011-11-27'),(4237,'g',0,'2011-11-27'),(4138,'g',0,'2011-11-27'),(4018,'g',0,'2011-11-27'),(4150,'g',0,'2011-11-27'),(4258,'g',0,'2011-11-27'),(6068,'g',0,'2011-11-27'),(3996,'g',0,'2011-11-27'),(6500,'g',0,'2011-11-27'),(6332,'g',0,'2011-11-27'),(6501,'g',0,'2011-11-27'),(6497,'g',0,'2011-11-27'),(6499,'g',0,'2011-11-27'),(2201,'g',0,'2011-11-27'),(6502,'g',0,'2011-11-27'),(1646,'g',0,'2011-11-27'),(2221,'g',0,'2011-11-27'),(2298,'g',0,'2011-11-27'),(6643,'g',0,'2011-11-27'),(4657,'g',0,'2011-11-27'),(4550,'g',0,'2011-11-27'),(4725,'g',0,'2011-11-27'),(4648,'g',0,'2011-11-27'),(4602,'g',0,'2011-11-27'),(5285,'g',0,'2011-11-27'),(5444,'g',0,'2011-11-27'),(5507,'g',0,'2011-11-27'),(5464,'g',0,'2012-02-29'),(5537,'g',0,'2011-11-27'),(3666,'g',0,'2011-11-27'),(3669,'g',0,'2011-11-27'),(3708,'g',0,'2011-11-27'),(4291,'g',0,'2011-11-27'),(3743,'g',0,'2011-11-27'),(4517,'g',0,'2012-02-29'),(3793,'g',0,'2011-11-27'),(3805,'g',0,'2011-11-27'),(4506,'g',0,'2011-11-27'),(3818,'g',0,'2011-11-27'),(6214,'g',0,'2012-02-29'),(6339,'g',0,'2011-11-28'),(6553,'g',0,'2011-11-28'),(701,'g',0,'2011-11-29'),(748,'g',0,'2011-11-29'),(765,'g',0,'2011-11-29'),(786,'g',0,'2011-11-29'),(730,'g',0,'2011-11-29'),(752,'g',0,'2011-11-29'),(743,'g',0,'2011-11-29'),(756,'g',0,'2011-11-29'),(689,'g',0,'2011-11-29'),(751,'g',0,'2011-11-29'),(2668,'g',0,'2011-11-29'),(3467,'g',0,'2011-11-29'),(3356,'g',0,'2011-11-29'),(3471,'g',0,'2011-11-29'),(3527,'g',0,'2011-11-29'),(3175,'g',0,'2011-11-29'),(3409,'g',0,'2011-11-29'),(3525,'g',0,'2012-01-27'),(3338,'g',0,'2011-11-29'),(3402,'g',0,'2011-11-29'),(3646,'g',0,'2011-11-29'),(3691,'g',0,'2011-11-29'),(3767,'g',0,'2011-11-29'),(3687,'g',0,'2011-11-29'),(3558,'g',0,'2011-11-29'),(3596,'g',0,'2011-11-29'),(3719,'g',0,'2011-11-29'),(3537,'g',0,'2011-11-29'),(3672,'g',0,'2012-01-27'),(3650,'g',0,'2011-11-29'),(2570,'g',0,'2011-11-29'),(2149,'g',0,'2011-11-29'),(2493,'g',0,'2011-11-29'),(2107,'g',0,'2011-11-29'),(1620,'g',0,'2011-11-29'),(1606,'g',0,'2011-11-29'),(2078,'g',0,'2011-11-29'),(2083,'g',0,'2011-11-29'),(2120,'g',0,'2011-11-29'),(2040,'g',0,'2011-11-29'),(5527,'g',0,'2011-11-29'),(5544,'g',0,'2011-11-29'),(5573,'g',0,'2011-11-29'),(5601,'g',0,'2011-11-29'),(5592,'g',0,'2011-11-29'),(5605,'g',0,'2011-11-29'),(5664,'g',0,'2011-11-29'),(5382,'g',0,'2011-11-29'),(5658,'g',0,'2011-11-29'),(4834,'g',0,'2011-11-29'),(6491,'g',0,'2012-01-14'),(6322,'g',0,'2011-11-30'),(6606,'g',0,'2011-11-30'),(6490,'g',0,'2011-11-30'),(6565,'g',0,'2012-01-14'),(345,'g',0,'2011-11-30'),(990,'g',0,'2011-12-06'),(1381,'g',0,'2011-12-06'),(1337,'g',0,'2011-12-06'),(1448,'g',0,'2011-12-06'),(1410,'g',0,'2011-12-06'),(1522,'g',0,'2011-12-07'),(280,'g',0,'2011-12-09'),(1189,'g',0,'2011-12-09'),(1190,'g',0,'2011-12-09'),(1181,'g',0,'2011-12-09'),(1176,'g',0,'2011-12-09'),(884,'g',0,'2011-12-09'),(890,'g',0,'2011-12-09'),(894,'g',0,'2011-12-09'),(889,'g',0,'2011-12-09'),(882,'g',0,'2011-12-09'),(896,'g',0,'2011-12-09'),(887,'g',0,'2011-12-09'),(893,'g',0,'2011-12-09'),(881,'g',0,'2011-12-09'),(886,'g',0,'2011-12-09'),(885,'g',0,'2011-12-09'),(839,'g',0,'2011-12-09'),(911,'g',0,'2011-12-09'),(864,'g',0,'2011-12-09'),(845,'g',0,'2011-12-09'),(830,'g',0,'2011-12-09'),(857,'g',0,'2011-12-09'),(912,'g',0,'2011-12-09'),(871,'g',0,'2011-12-09'),(892,'g',0,'2011-12-09'),(1242,'g',0,'2011-12-10'),(1214,'g',0,'2011-12-10'),(1202,'g',0,'2011-12-10'),(1197,'g',0,'2011-12-10'),(1208,'g',0,'2011-12-10'),(1251,'g',0,'2011-12-10'),(1334,'g',0,'2011-12-10'),(1054,'g',0,'2011-12-10'),(1359,'g',0,'2011-12-10'),(1383,'g',0,'2011-12-10'),(1335,'g',0,'2011-12-10'),(1055,'g',0,'2011-12-10'),(1366,'g',0,'2011-12-10'),(1033,'g',0,'2011-12-10'),(1333,'g',0,'2011-12-10'),(1052,'g',0,'2011-12-10'),(1125,'g',0,'2011-12-10'),(1128,'g',0,'2011-12-10'),(1132,'g',0,'2011-12-10'),(1116,'g',0,'2011-12-10'),(1136,'g',0,'2011-12-11'),(402,'g',0,'2011-12-12'),(684,'g',0,'2011-12-12'),(604,'g',0,'2011-12-12'),(685,'g',0,'2011-12-12'),(711,'g',0,'2011-12-12'),(709,'g',0,'2011-12-12'),(739,'g',0,'2011-12-12'),(735,'g',0,'2011-12-12'),(686,'g',0,'2011-12-12'),(736,'g',0,'2011-12-12'),(1061,'g',0,'2011-12-12'),(4768,'g',0,'2011-12-12'),(4828,'g',0,'2011-12-12'),(4566,'g',0,'2011-12-12'),(4574,'g',0,'2011-12-12'),(4953,'g',0,'2011-12-12'),(4581,'g',0,'2011-12-12'),(5197,'g',0,'2011-12-12'),(4218,'g',0,'2011-12-12'),(3829,'g',0,'2011-12-12'),(5117,'g',0,'2011-12-12'),(5205,'g',0,'2011-12-12'),(5139,'g',0,'2011-12-12'),(5020,'g',0,'2011-12-12'),(3787,'g',0,'2011-12-12'),(923,'g',0,'2011-12-13'),(930,'g',0,'2011-12-13'),(909,'g',0,'2011-12-13'),(948,'g',0,'2011-12-13'),(994,'g',0,'2011-12-13'),(915,'g',0,'2011-12-13'),(993,'g',0,'2011-12-13'),(970,'g',0,'2011-12-13'),(1030,'g',0,'2011-12-13'),(1018,'g',0,'2011-12-13'),(971,'g',0,'2011-12-13'),(6358,'g',0,'2011-12-14'),(6484,'g',0,'2011-12-14'),(6366,'g',0,'2011-12-14'),(6361,'g',0,'2011-12-14'),(4849,'g',0,'2011-12-14'),(6385,'g',0,'2011-12-14'),(835,'g',0,'2011-12-14'),(821,'g',0,'2011-12-14'),(833,'g',0,'2011-12-14'),(837,'g',0,'2011-12-14'),(1050,'g',0,'2011-12-14'),(6401,'g',0,'2011-12-14'),(6511,'g',0,'2011-12-14'),(6365,'g',0,'2011-12-14'),(767,'g',0,'2011-12-14'),(928,'g',0,'2011-12-14'),(3469,'g',0,'2011-12-14'),(3494,'g',0,'2011-12-14'),(3559,'g',0,'2011-12-14'),(3444,'g',0,'2011-12-14'),(3460,'g',0,'2011-12-14'),(3484,'g',0,'2011-12-14'),(3360,'g',0,'2011-12-14'),(4081,'g',0,'2011-12-14'),(6425,'g',0,'2011-12-14'),(4820,'g',0,'2011-12-14'),(6428,'g',0,'2011-12-14'),(4524,'g',0,'2011-12-14'),(849,'g',0,'2011-12-14'),(872,'g',0,'2011-12-14'),(936,'g',0,'2011-12-14'),(987,'g',0,'2011-12-14'),(932,'g',0,'2011-12-14'),(847,'g',0,'2011-12-14'),(710,'g',0,'2011-12-14'),(737,'g',0,'2011-12-14'),(895,'g',0,'2011-12-14'),(958,'g',0,'2011-12-14'),(3978,'g',0,'2011-12-14'),(2964,'g',0,'2011-12-14'),(4753,'g',0,'2011-12-14'),(4364,'g',0,'2011-12-14'),(1905,'g',0,'2011-12-14'),(2998,'g',0,'2011-12-14'),(4346,'g',0,'2011-12-14'),(3762,'g',0,'2011-12-14'),(2880,'g',0,'2011-12-14'),(4748,'g',0,'2011-12-14'),(1057,'g',0,'2011-12-14'),(1484,'g',0,'2011-12-14'),(1487,'g',0,'2011-12-14'),(1486,'g',0,'2011-12-14'),(520,'g',0,'2011-12-14'),(341,'g',0,'2011-12-14'),(377,'g',0,'2011-12-14'),(357,'g',0,'2011-12-14'),(510,'g',0,'2011-12-14'),(368,'g',0,'2011-12-14'),(493,'g',0,'2011-12-14'),(1065,'g',0,'2011-12-14'),(6475,'g',0,'2011-12-17'),(6485,'g',0,'2011-12-17'),(6479,'g',0,'2011-12-17'),(6476,'g',0,'2011-12-17'),(6473,'g',0,'2011-12-17'),(6482,'g',0,'2011-12-17'),(6477,'g',0,'2011-12-17'),(6480,'g',0,'2011-12-17'),(6481,'g',0,'2011-12-17'),(6478,'g',0,'2011-12-17'),(6762,'g',0,'2011-12-17'),(6781,'g',0,'2011-12-17'),(6746,'g',0,'2011-12-17'),(6780,'g',0,'2011-12-17'),(6763,'g',0,'2011-12-17'),(6752,'g',0,'2011-12-17'),(6779,'g',0,'2011-12-17'),(6778,'g',0,'2011-12-17'),(6751,'g',0,'2011-12-17'),(6764,'g',0,'2011-12-17'),(6836,'g',0,'2011-12-18'),(2672,'g',0,'2011-12-18'),(4640,'g',0,'2011-12-18'),(6151,'g',0,'2011-12-18'),(6493,'g',0,'2011-12-18'),(6363,'g',0,'2011-12-18'),(6812,'g',0,'2011-12-18'),(3662,'g',0,'2011-12-18'),(3084,'g',0,'2012-02-27'),(6362,'g',0,'2011-12-18'),(6516,'g',0,'2011-12-18'),(6517,'g',0,'2011-12-18'),(6518,'g',0,'2011-12-18'),(6600,'g',0,'2011-12-18'),(2703,'g',0,'2011-12-18'),(6761,'g',0,'2011-12-18'),(3388,'g',0,'2011-12-18'),(4677,'g',0,'2011-12-18'),(804,'g',0,'2011-12-19'),(799,'g',0,'2011-12-19'),(789,'g',0,'2011-12-19'),(805,'g',0,'2011-12-19'),(811,'g',0,'2011-12-19'),(801,'g',0,'2011-12-19'),(259,'g',0,'2012-02-21'),(6857,'g',0,'2011-12-19'),(6595,'g',0,'2011-12-19'),(4609,'g',0,'2011-12-19'),(2620,'g',0,'2011-12-19'),(6456,'g',0,'2011-12-19'),(6515,'g',0,'2011-12-19'),(6798,'g',0,'2011-12-19'),(4619,'g',0,'2011-12-20'),(6743,'g',0,'2011-12-20'),(3705,'g',0,'2011-12-20'),(6597,'g',0,'2011-12-20'),(6693,'g',0,'2012-02-18'),(6679,'g',0,'2011-12-24'),(6678,'g',0,'2011-12-24'),(6677,'g',0,'2011-12-24'),(6674,'g',0,'2011-12-24'),(6739,'g',0,'2011-12-24'),(6555,'g',0,'2011-12-24'),(6554,'g',0,'2011-12-24'),(6748,'g',0,'2011-12-24'),(6589,'g',0,'2011-12-24'),(6740,'g',0,'2011-12-24'),(6585,'g',0,'2011-12-24'),(6588,'g',0,'2011-12-24'),(6587,'g',0,'2011-12-24'),(6586,'g',0,'2011-12-24'),(6676,'g',0,'2011-12-24'),(6675,'g',0,'2011-12-24'),(4972,'g',0,'2011-12-25'),(4966,'g',0,'2011-12-25'),(798,'g',0,'2011-12-25'),(807,'g',0,'2011-12-25'),(859,'g',0,'2011-12-25'),(913,'g',0,'2011-12-25'),(846,'g',0,'2011-12-25'),(1907,'g',0,'2011-12-25'),(2577,'g',0,'2011-12-25'),(1028,'g',0,'2011-12-25'),(1049,'g',0,'2011-12-25'),(1005,'g',0,'2011-12-25'),(1032,'g',0,'2011-12-25'),(2654,'g',0,'2011-12-25'),(5026,'g',0,'2011-12-25'),(5080,'g',0,'2011-12-25'),(4998,'g',0,'2011-12-25'),(5013,'g',0,'2011-12-25'),(5007,'g',0,'2011-12-25'),(4977,'g',0,'2011-12-25'),(6765,'g',0,'2011-12-25'),(5054,'g',0,'2011-12-25'),(5060,'g',0,'2011-12-25'),(5323,'g',0,'2011-12-25'),(5303,'g',0,'2011-12-25'),(5276,'g',0,'2011-12-25'),(5297,'g',0,'2011-12-26'),(5279,'g',0,'2011-12-26'),(5310,'g',0,'2011-12-26'),(4911,'g',0,'2011-12-26'),(6851,'g',0,'2011-12-26'),(6786,'g',0,'2011-12-26'),(6826,'g',0,'2011-12-26'),(5259,'g',0,'2011-12-26'),(5265,'g',0,'2011-12-26'),(6849,'g',0,'2011-12-26'),(6787,'g',0,'2011-12-26'),(6801,'g',0,'2011-12-26'),(5100,'g',0,'2011-12-26'),(6202,'g',0,'2011-12-26'),(4023,'g',0,'2011-12-26'),(4017,'g',0,'2011-12-26'),(6816,'g',0,'2011-12-26'),(3720,'g',0,'2011-12-26'),(5089,'g',0,'2011-12-26'),(6178,'g',0,'2011-12-26'),(6138,'g',0,'2011-12-26'),(5288,'g',0,'2011-12-26'),(6200,'g',0,'2011-12-27'),(6825,'g',0,'2011-12-27'),(6838,'g',0,'2011-12-27'),(6641,'g',0,'2011-12-27'),(6672,'g',0,'2011-12-27'),(6642,'g',0,'2011-12-27'),(5472,'g',0,'2011-12-27'),(6605,'g',0,'2011-12-27'),(6601,'g',0,'2011-12-27'),(6603,'g',0,'2011-12-27'),(6590,'g',0,'2011-12-27'),(4074,'g',0,'2011-12-27'),(6802,'g',0,'2011-12-27'),(5097,'g',0,'2011-12-27'),(6604,'g',0,'2011-12-27'),(6187,'g',0,'2011-12-27'),(6673,'g',0,'2011-12-27'),(6602,'g',0,'2011-12-27'),(985,'g',0,'2011-12-28'),(918,'g',0,'2011-12-28'),(919,'g',0,'2011-12-28'),(1046,'g',0,'2011-12-28'),(1041,'g',0,'2011-12-28'),(1042,'g',0,'2011-12-28'),(1043,'g',0,'2011-12-28'),(1040,'g',0,'2011-12-28'),(1045,'g',0,'2011-12-28'),(1047,'g',0,'2011-12-28'),(3625,'g',0,'2011-12-28'),(3971,'g',0,'2011-12-28'),(3423,'g',0,'2011-12-28'),(3991,'g',0,'2011-12-28'),(3367,'g',0,'2011-12-28'),(1903,'g',0,'2011-12-28'),(4057,'g',0,'2011-12-28'),(1490,'g',0,'2011-12-28'),(1053,'g',0,'2011-12-28'),(3987,'g',0,'2011-12-28'),(5490,'g',0,'2011-12-28'),(5107,'g',0,'2011-12-28'),(4558,'g',0,'2011-12-28'),(5389,'g',0,'2011-12-28'),(5166,'g',0,'2011-12-28'),(5232,'g',0,'2011-12-28'),(5124,'g',0,'2011-12-28'),(6910,'g',0,'2011-12-28'),(5110,'g',0,'2011-12-28'),(5074,'g',0,'2011-12-28'),(6864,'g',0,'2011-12-29'),(925,'g',0,'2011-12-29'),(949,'g',0,'2011-12-29'),(955,'g',0,'2011-12-29'),(951,'g',0,'2011-12-29'),(927,'g',0,'2011-12-29'),(922,'g',0,'2011-12-29'),(726,'g',0,'2011-12-29'),(727,'g',0,'2011-12-29'),(708,'g',0,'2011-12-29'),(1015,'g',0,'2011-12-29'),(1062,'g',0,'2011-12-29'),(1016,'g',0,'2011-12-29'),(2648,'g',0,'2011-12-29'),(3078,'g',0,'2011-12-29'),(3105,'g',0,'2011-12-29'),(2709,'g',0,'2011-12-29'),(3534,'g',0,'2011-12-29'),(3449,'g',0,'2011-12-29'),(3393,'g',0,'2011-12-29'),(2630,'g',0,'2011-12-29'),(2234,'g',0,'2011-12-29'),(3406,'g',0,'2011-12-29'),(384,'g',0,'2012-03-06'),(351,'g',0,'2012-03-06'),(388,'g',0,'2012-03-06'),(260,'g',0,'2011-12-29'),(276,'g',0,'2012-02-17'),(412,'g',0,'2012-03-06'),(6920,'g',0,'2011-12-29'),(1027,'g',0,'2011-12-29'),(1019,'g',0,'2011-12-29'),(1020,'g',0,'2011-12-29'),(986,'g',0,'2011-12-29'),(998,'g',0,'2011-12-29'),(962,'g',0,'2011-12-29'),(1029,'g',0,'2011-12-29'),(1059,'g',0,'2011-12-29'),(1060,'g',0,'2011-12-29'),(1051,'g',0,'2011-12-29'),(1058,'g',0,'2011-12-29'),(1026,'g',0,'2011-12-29'),(1031,'g',0,'2011-12-29'),(897,'g',0,'2011-12-29'),(900,'g',0,'2011-12-29'),(550,'g',0,'2011-12-29'),(559,'g',0,'2011-12-29'),(552,'g',0,'2011-12-29'),(555,'g',0,'2011-12-29'),(551,'g',0,'2011-12-29'),(557,'g',0,'2011-12-29'),(556,'g',0,'2011-12-29'),(553,'g',0,'2011-12-29'),(554,'g',0,'2011-12-29'),(558,'g',0,'2011-12-29'),(6884,'g',0,'2011-12-30'),(6523,'g',0,'2011-12-30'),(6598,'g',0,'2011-12-30'),(6614,'g',0,'2011-12-30'),(6591,'g',0,'2011-12-30'),(6578,'g',0,'2011-12-30'),(6508,'g',0,'2011-12-30'),(6582,'g',0,'2011-12-30'),(6492,'g',0,'2011-12-30'),(6584,'g',0,'2011-12-30'),(267,'g',0,'2011-12-30'),(264,'g',0,'2011-12-30'),(271,'g',0,'2011-12-30'),(257,'g',0,'2011-12-30'),(269,'g',0,'2011-12-30'),(539,'g',0,'2011-12-30'),(549,'g',0,'2011-12-30'),(537,'g',0,'2011-12-30'),(545,'g',0,'2011-12-30'),(543,'g',0,'2011-12-30'),(544,'g',0,'2011-12-30'),(542,'g',0,'2011-12-30'),(548,'g',0,'2011-12-30'),(546,'g',0,'2011-12-30'),(547,'g',0,'2011-12-30'),(965,'g',0,'2011-12-30'),(898,'g',0,'2011-12-30'),(996,'g',0,'2011-12-30'),(968,'g',0,'2011-12-30'),(963,'g',0,'2011-12-30'),(1001,'g',0,'2011-12-30'),(1000,'g',0,'2011-12-30'),(1476,'g',0,'2011-12-30'),(1008,'g',0,'2011-12-30'),(1044,'g',0,'2011-12-30'),(509,'g',0,'2011-12-30'),(512,'g',0,'2011-12-30'),(511,'g',0,'2011-12-30'),(507,'g',0,'2011-12-30'),(503,'g',0,'2011-12-30'),(501,'g',0,'2011-12-30'),(502,'g',0,'2011-12-30'),(506,'g',0,'2011-12-30'),(508,'g',0,'2011-12-30'),(490,'g',0,'2011-12-30'),(499,'g',0,'2011-12-30'),(485,'g',0,'2011-12-30'),(495,'g',0,'2011-12-30'),(500,'g',0,'2011-12-30'),(498,'g',0,'2011-12-30'),(496,'g',0,'2011-12-30'),(494,'g',0,'2011-12-30'),(491,'g',0,'2011-12-30'),(497,'g',0,'2011-12-30'),(514,'g',0,'2011-12-30'),(535,'g',0,'2011-12-30'),(534,'g',0,'2011-12-30'),(517,'g',0,'2011-12-30'),(524,'g',0,'2011-12-30'),(530,'g',0,'2011-12-30'),(528,'g',0,'2011-12-30'),(516,'g',0,'2011-12-30'),(519,'g',0,'2011-12-30'),(523,'g',0,'2011-12-30'),(6923,'g',0,'2011-12-30'),(6922,'g',0,'2011-12-30'),(481,'g',0,'2011-12-30'),(482,'g',0,'2011-12-30'),(483,'g',0,'2011-12-30'),(477,'g',0,'2011-12-30'),(478,'g',0,'2011-12-30'),(484,'g',0,'2011-12-30'),(480,'g',0,'2011-12-30'),(479,'g',0,'2011-12-30'),(853,'g',0,'2011-12-30'),(851,'g',0,'2011-12-30'),(766,'g',0,'2011-12-30'),(822,'g',0,'2011-12-30'),(705,'g',0,'2011-12-30'),(814,'g',0,'2011-12-30'),(779,'g',0,'2011-12-30'),(768,'g',0,'2011-12-30'),(700,'g',0,'2011-12-30'),(732,'g',0,'2011-12-30'),(6887,'g',0,'2012-01-01'),(6896,'g',0,'2012-01-01'),(6893,'g',0,'2012-01-01'),(6905,'g',0,'2012-01-01'),(6874,'g',0,'2012-02-13'),(6867,'g',0,'2012-02-14'),(6919,'g',0,'2012-02-18'),(6863,'g',0,'2012-02-13'),(6875,'g',0,'2012-01-03'),(6889,'g',0,'2012-01-03'),(6934,'g',0,'2012-01-03'),(6768,'g',0,'2012-01-04'),(6552,'g',0,'2012-01-04'),(275,'g',0,'2012-01-04'),(6470,'g',0,'2012-01-04'),(6467,'g',0,'2012-01-04'),(6795,'g',0,'2012-01-05'),(6540,'g',0,'2012-01-05'),(6550,'g',0,'2012-01-05'),(6460,'g',0,'2012-01-05'),(6462,'g',0,'2012-01-05'),(6533,'g',0,'2012-01-05'),(380,'g',0,'2012-01-05'),(325,'g',0,'2012-01-05'),(6941,'g',0,'2012-01-06'),(372,'g',0,'2012-01-06'),(1068,'g',0,'2012-01-06'),(1067,'g',0,'2012-01-06'),(1066,'g',0,'2012-01-06'),(414,'g',0,'2012-01-06'),(6848,'g',0,'2012-01-06'),(6803,'g',0,'2012-01-06'),(6804,'g',0,'2012-01-06'),(6805,'g',0,'2012-01-06'),(6844,'g',0,'2012-01-06'),(6924,'g',0,'2012-01-06'),(6806,'g',0,'2012-01-06'),(6815,'g',0,'2012-01-06'),(4464,'g',0,'2012-01-06'),(6213,'g',0,'2012-01-06'),(410,'g',0,'2012-01-06'),(6951,'g',0,'2012-02-14'),(6937,'g',0,'2012-02-13'),(6944,'g',0,'2012-02-18'),(6954,'g',0,'2012-02-18'),(6931,'g',0,'2012-02-18'),(6956,'g',0,'2012-02-13'),(6965,'g',0,'2012-01-11'),(6961,'g',0,'2012-01-11'),(6957,'g',0,'2012-01-12'),(6660,'g',0,'2012-01-14'),(6663,'g',0,'2012-01-14'),(6918,'g',0,'2012-02-17'),(7000,'g',0,'2012-01-19'),(6991,'g',0,'2012-01-19'),(6995,'g',0,'2012-01-19'),(6990,'g',0,'2012-01-19'),(7004,'g',0,'2012-01-20'),(6985,'g',0,'2012-01-20'),(776,'g',0,'2012-03-06'),(7039,'g',0,'2012-01-22'),(7080,'g',0,'2012-03-01'),(7043,'g',0,'2012-01-26'),(7062,'g',0,'2012-01-28'),(7038,'g',0,'2012-01-28'),(7073,'g',0,'2012-01-28'),(6915,'g',0,'2012-01-28'),(6888,'g',0,'2012-01-28'),(1007,'g',0,'2012-01-28'),(7084,'g',0,'2012-01-28'),(6632,'g',0,'2012-01-29'),(6650,'g',0,'2012-01-30'),(6609,'g',0,'2012-01-30'),(6580,'g',0,'2012-01-30'),(6959,'g',0,'2012-01-31'),(818,'g',0,'2012-02-06'),(828,'g',0,'2012-02-06'),(823,'g',0,'2012-02-06'),(824,'g',0,'2012-02-06'),(7136,'g',0,'2012-02-06'),(6698,'g',0,'2012-02-08'),(7168,'g',0,'2012-02-11'),(654,'g',0,'2012-02-11'),(961,'g',0,'2012-02-15'),(6890,'g',0,'2012-02-15'),(6487,'g',0,'2012-02-16'),(6488,'g',0,'2012-02-16'),(7003,'g',0,'2012-02-16'),(7189,'g',0,'2012-02-16'),(7192,'g',0,'2012-02-16'),(4650,'g',0,'2012-02-17'),(6912,'g',0,'2012-02-17'),(4186,'g',0,'2012-02-17'),(4262,'g',0,'2012-02-17'),(7162,'g',0,'2012-02-17'),(7196,'g',0,'2012-02-17'),(4633,'g',0,'2012-02-17'),(4176,'g',0,'2012-02-17'),(4429,'g',0,'2012-02-17'),(6900,'g',0,'2012-02-17'),(4659,'g',0,'2012-02-17'),(7208,'g',0,'2012-02-17'),(5420,'g',0,'2012-02-17'),(6939,'g',0,'2012-02-17'),(5225,'g',0,'2012-02-17'),(7219,'g',0,'2012-02-17'),(6943,'g',0,'2012-02-17'),(5485,'g',0,'2012-02-17'),(4937,'g',0,'2012-02-17'),(5368,'g',0,'2012-02-17'),(6876,'g',0,'2012-02-17'),(5410,'g',0,'2012-02-17'),(7118,'g',0,'2012-02-18'),(7199,'g',0,'2012-02-18'),(7213,'g',0,'2012-02-18'),(7214,'g',0,'2012-02-18'),(6538,'g',0,'2012-02-19'),(6464,'g',0,'2012-02-19'),(6468,'g',0,'2012-02-19'),(6560,'g',0,'2012-02-19'),(6463,'g',0,'2012-02-19'),(6466,'g',0,'2012-02-19'),(6559,'g',0,'2012-02-19'),(6520,'g',0,'2012-02-19'),(6593,'g',0,'2012-02-19'),(6575,'g',0,'2012-02-19'),(6551,'g',0,'2012-02-19'),(6706,'g',0,'2012-02-19'),(6564,'g',0,'2012-02-19'),(6659,'g',0,'2012-02-19'),(6669,'g',0,'2012-02-19'),(6469,'g',0,'2012-02-19'),(6668,'g',0,'2012-02-19'),(6531,'g',0,'2012-02-19'),(6505,'g',0,'2012-02-19'),(6544,'g',0,'2012-02-19'),(6410,'g',0,'2012-02-20'),(6140,'g',0,'2012-02-20'),(995,'g',0,'2012-02-20'),(6833,'g',0,'2012-02-20'),(6383,'g',0,'2012-02-20'),(6758,'g',0,'2012-02-20'),(6444,'g',0,'2012-02-20'),(6367,'g',0,'2012-02-20'),(6728,'g',0,'2012-02-21'),(6442,'g',0,'2012-02-21'),(6394,'g',0,'2012-02-21'),(6141,'g',0,'2012-02-21'),(6832,'g',0,'2012-02-21'),(6809,'g',0,'2012-02-21'),(6217,'g',0,'2012-02-21'),(6731,'g',0,'2012-02-21'),(6718,'g',0,'2012-02-21'),(6359,'g',0,'2012-02-21'),(6350,'g',0,'2012-02-21'),(6755,'g',0,'2012-02-21'),(6729,'g',0,'2012-02-21'),(7053,'g',0,'2012-02-21'),(6354,'g',0,'2012-02-21'),(6447,'g',0,'2012-02-21'),(6396,'g',0,'2012-02-21'),(6158,'g',0,'2012-02-21'),(6400,'g',0,'2012-02-21'),(6392,'g',0,'2012-02-21'),(6767,'g',0,'2012-02-21'),(6355,'g',0,'2012-02-21'),(6397,'g',0,'2012-02-21'),(6744,'g',0,'2012-02-21'),(6436,'g',0,'2012-02-21'),(6819,'g',0,'2012-02-21'),(6445,'g',0,'2012-02-21'),(6821,'g',0,'2012-02-21'),(6190,'g',0,'2012-02-21'),(6219,'g',0,'2012-02-21'),(6723,'g',0,'2012-02-21'),(6427,'g',0,'2012-02-21'),(6856,'g',0,'2012-02-21'),(3875,'g',0,'2012-02-21'),(4247,'g',0,'2012-02-22'),(7221,'g',0,'2012-02-22'),(7230,'g',0,'2012-02-26'),(795,'g',0,'2012-02-26'),(7145,'g',0,'2012-02-26'),(7203,'g',0,'2012-02-26'),(7193,'g',0,'2012-02-26'),(7002,'g',0,'2012-02-26'),(7066,'g',0,'2012-02-26'),(7164,'g',0,'2012-02-26'),(7157,'g',0,'2012-02-26'),(7079,'g',0,'2012-02-26'),(7042,'g',0,'2012-02-26'),(7176,'g',0,'2012-02-26'),(7036,'g',0,'2012-02-26'),(7072,'g',0,'2012-02-26'),(7171,'g',0,'2012-02-26'),(7105,'g',0,'2012-02-26'),(856,'g',0,'2012-02-27'),(7194,'g',0,'2012-02-27'),(7116,'g',0,'2012-02-27'),(7205,'g',0,'2012-02-27'),(7071,'g',0,'2012-02-27'),(7110,'g',0,'2012-02-27'),(7163,'g',0,'2012-02-27'),(7107,'g',0,'2012-02-27'),(7231,'g',0,'2012-02-27'),(6996,'g',0,'2012-02-27'),(753,'g',0,'2012-02-27'),(773,'g',0,'2012-02-27'),(7215,'g',0,'2012-02-27'),(7067,'g',0,'2012-02-27'),(7235,'g',0,'2012-02-27'),(7225,'g',0,'2012-02-27'),(7236,'g',0,'2012-02-27'),(7191,'g',0,'2012-02-27'),(7242,'g',0,'2012-02-27'),(7238,'g',0,'2012-02-28'),(7229,'g',0,'2012-02-28'),(7239,'g',0,'2012-02-28'),(4149,'g',0,'2012-02-28'),(7048,'g',0,'2012-02-29'),(7049,'g',0,'2012-02-29'),(7050,'g',0,'2012-02-29'),(6935,'g',0,'2012-02-29'),(7025,'g',0,'2012-02-29'),(6953,'g',0,'2012-02-29'),(4835,'g',0,'2012-02-29'),(6721,'g',0,'2012-02-29'),(6878,'g',0,'2012-02-29'),(7075,'g',0,'2012-02-29'),(190,'g',0,'2012-02-29'),(394,'g',0,'2012-02-29'),(862,'g',0,'2012-02-29'),(874,'g',0,'2012-02-29'),(908,'g',0,'2012-02-29'),(841,'g',0,'2012-02-29'),(901,'g',0,'2012-02-29'),(876,'g',0,'2012-02-29'),(825,'g',0,'2012-02-29'),(7216,'g',0,'2012-02-29'),(7262,'g',0,'2012-02-29'),(7183,'g',0,'2012-02-29'),(7261,'g',0,'2012-03-01'),(529,'g',0,'2012-03-01'),(525,'g',0,'2012-03-01'),(598,'g',0,'2012-03-01'),(522,'g',0,'2012-03-01'),(6988,'g',0,'2012-03-01'),(1485,'g',0,'2012-03-01'),(1491,'g',0,'2012-03-01'),(6936,'g',0,'2012-03-01'),(1483,'g',0,'2012-03-01'),(7001,'g',0,'2012-03-01'),(6938,'g',0,'2012-03-01'),(6869,'g',0,'2012-03-01'),(6870,'g',0,'2012-03-01'),(933,'g',0,'2012-03-01'),(920,'g',0,'2012-03-01'),(947,'g',0,'2012-03-01'),(924,'g',0,'2012-03-01'),(907,'g',0,'2012-03-01'),(910,'g',0,'2012-03-01'),(935,'g',0,'2012-03-01'),(934,'g',0,'2012-03-01'),(953,'g',0,'2012-03-01'),(941,'g',0,'2012-03-01'),(983,'g',0,'2012-03-01'),(984,'g',0,'2012-03-01'),(999,'g',0,'2012-03-01'),(1006,'g',0,'2012-03-01'),(1004,'g',0,'2012-03-01'),(1003,'g',0,'2012-03-01'),(991,'g',0,'2012-03-01'),(975,'g',0,'2012-03-01'),(974,'g',0,'2012-03-01'),(964,'g',0,'2012-03-01'),(960,'g',0,'2012-03-01'),(957,'g',0,'2012-03-01'),(1475,'g',0,'2012-03-01'),(1022,'g',0,'2012-03-01'),(7184,'g',0,'2012-03-01'),(1056,'g',0,'2012-03-01'),(902,'g',0,'2012-03-01'),(905,'g',0,'2012-03-01'),(6950,'g',0,'2012-03-01'),(6994,'g',0,'2012-03-01'),(521,'g',0,'2012-03-01'),(6975,'g',0,'2012-03-01'),(6868,'g',0,'2012-03-01'),(6970,'g',0,'2012-03-02'),(6977,'g',0,'2012-03-02'),(6873,'g',0,'2012-03-02'),(769,'g',0,'2012-03-02'),(794,'g',0,'2012-03-02'),(6823,'g',0,'2012-03-04'),(6822,'g',0,'2012-03-04'),(6144,'g',0,'2012-03-04'),(6143,'g',0,'2012-03-04'),(6147,'g',0,'2012-03-04'),(6152,'g',0,'2012-03-04'),(6154,'g',0,'2012-03-04'),(6180,'g',0,'2012-03-04'),(6830,'g',0,'2012-03-04'),(6188,'g',0,'2012-03-04'),(7291,'g',0,'2012-03-06'),(7312,'g',0,'2012-03-06'),(7289,'g',0,'2012-03-07');

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

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

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


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

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

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

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

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

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

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


--
-- Table structure for table `idx_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 ('uG0hk4hdBgL4gLorjkaYQ','D49EoOYDY79oRq2WyCZV8gvTBBIRB1L0FVhWEhV48','https://api.twitter.com/oauth/authorize','https://api.twitter.com/oauth/access_token');

--
-- 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,'AutoTweet','twitter_auto_tweet/twitter_auto_tweet.php','1',NULL),(2,'Sociable','sociable/sociable.php','1',NULL);

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

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

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

INSERT INTO `idx_review` VALUES (1,6884,'eBrandz is a great company to work with. Very professional, results driven and all processes are in place to make all business with eBrandz go smoothly.',3,'2012-01-03','Reviews','1','','Shopper','renfred.morris@gmail.com'),(2,6884,'Delivered as expected.',5,'2012-01-03','Reviews','1','','shopper','gilroy.stevens@gmail.com');

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



