--
-- Host: locallistingz.net    Database: locallis_index
-- ------------------------------------------------------


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

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

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


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

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

--
-- 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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`bad_link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

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

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


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

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

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

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

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

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

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

INSERT INTO `idx_category` VALUES (354,0,'Insurance Companies','','folder.gif','','1',36,'','','0','0','','',0,'',0,0,0,0,0),(355,0,'Law','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(356,0,'Lawyers & Judges','','folder.gif','','1',216,'','','0','0','','',0,'',0,0,0,0,0),(357,0,'Dating & Relationships ','','folder.gif','','1',7,'','','0','0','','',0,'',0,0,0,0,0),(358,0,'Medicine & Hospitals ','','folder.gif','','1',12,'','','0','0','','',0,'',0,0,0,0,0),(359,0,'Finance & Investment Services','','folder.gif','','1',29,'','','0','0','','',0,'',0,0,0,0,0),(360,0,'News & Magazines','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(361,0,'Plumbing Services','','folder.gif','','1',54,'','','0','0','','',0,'',0,0,0,0,0),(362,0,'Real Estate Development','','folder.gif','','1',46,'','','0','0','','',0,'',0,0,0,0,0),(363,0,'Energy & Science ','','folder.gif','','1',17,'','','0','0','','',0,'',0,0,0,0,0),(364,0,'Shopping and Retail','','folder.gif','','1',5,'','','1','0','','',0,'',0,0,0,0,0),(365,0,'Shopping and Retail','','folder.gif','','1',78,'','','1','0','','',0,'',0,0,0,0,0),(366,0,'Recreation & Sports','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(367,0,'Transport & Travel','','folder.gif','','1',99,'','','0','0','','',0,'',0,0,0,0,0),(368,0,'Wedding & Events','','folder.gif','','1',14,'','','0','0','','',0,'',0,0,0,0,0),(369,0,'SEO ,SMO & PPC','','folder.gif','','1',27,'','','0','0','','',0,'',0,0,0,0,0),(351,0,'Home & Family','','folder.gif','','1',7,'','','0','0','','',0,'',0,0,0,0,0),(350,0,'Heating and Air Conditioning Contractors','','folder.gif','','1',94,'','','0','0','','',0,'',0,0,0,0,0),(347,0,'Hardware & Software Resources','','folder.gif','','1',12,'','','0','0','','',0,'',0,0,0,0,0),(335,0,'Arts & Entertainment','','folder.gif','','1',22,'','','0','0','','',0,'',0,0,0,0,0),(336,0,'Automotive','','folder.gif','','1',58,'','','0','0','','',0,'',0,0,0,0,0),(337,0,'Business','','folder.gif','','1',196,'','','0','0','','',0,'',0,0,0,0,0),(338,0,'Careers & Jobs','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(339,0,'Clothing','','folder.gif','','1',15,'','','0','0','','',0,'',0,0,0,0,0),(340,0,'Communications','','folder.gif','','1',26,'','','0','0','','',0,'',0,0,0,0,0),(341,0,'Computer & Internet','','folder.gif','','1',37,'','','0','0','','',0,'',0,0,0,0,0),(342,0,'Building & Construction','','folder.gif','','1',93,'','','0','0','','',0,'',0,0,0,0,0),(353,0,'Hotels & Accomadation','','folder.gif','','1',101,'','','0','0','','',0,'',0,0,0,0,0),(343,0,'Dental Care','','folder.gif','','1',78,'','','0','0','','',0,'',0,0,0,0,0),(344,0,'Educational Resources','','folder.gif','','1',32,'','','0','0','','',0,'',0,0,0,0,0),(352,0,'Home Improvement & Decor','','folder.gif','','1',350,'','','0','0','','',0,'',0,0,0,0,0),(345,0,'Recruitment Services','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(346,0,'Gifts & Flowers','','folder.gif','','1',25,'','','0','0','','',0,'',0,0,0,0,0),(349,0,'Healthcare Management ','','folder.gif','','1',67,'','','0','0','','',0,'',0,0,0,0,0),(348,0,'Medical & Health','','folder.gif','','1',156,'','','0','0','','',0,'',0,0,0,0,0);

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

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

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

INSERT INTO `idx_category_path` VALUES (335,'Arts & Entertainment','<a href=\"http://locallistingz.net/arts-entertainment/\" name=\"cat_335\" style=\"\">Arts & Entertainment</a>',';0;'),(336,'Automotive','<a href=\"http://locallistingz.net/automotive/\" name=\"cat_336\" style=\"\">Automotive</a>',';0;'),(337,'Business','<a href=\"http://locallistingz.net/business/\" name=\"cat_337\" style=\"\">Business</a>',';0;'),(338,'Careers & Jobs','<a href=\"http://locallistingz.net/careers-jobs/\" name=\"cat_338\" style=\"\">Careers & Jobs</a>',';0;'),(339,'Clothing','<a href=\"http://locallistingz.net/clothing/\" name=\"cat_339\" style=\"\">Clothing</a>',';0;'),(340,'Communications','<a href=\"http://locallistingz.net/communications/\" name=\"cat_340\" style=\"\">Communications</a>',';0;'),(341,'Computer & Internet','<a href=\"http://locallistingz.net/computer-internet/\" name=\"cat_341\" style=\"\">Computer & Internet</a>',';0;'),(342,'Building & Construction','<a href=\"http://locallistingz.net/building-construction/\" name=\"cat_342\" style=\"\">Building & Construction</a>',';0;'),(343,'Dental Care','<a href=\"http://locallistingz.net/dental-care/\" name=\"cat_343\" style=\"\">Dental Care</a>',';0;'),(344,'Educational Resources','<a href=\"http://locallistingz.net/educational-resources/\" name=\"cat_344\" style=\"\">Educational Resources</a>',';0;'),(345,'Recruitment Services','<a href=\"http://locallistingz.net/recruitment-services/\" name=\"cat_345\" style=\"\">Recruitment Services</a>',';0;'),(346,'Gifts & Flowers','<a href=\"http://locallistingz.net/gifts-flowers/\" name=\"cat_346\" style=\"\">Gifts & Flowers</a>',';0;'),(347,'Hardware & Software Resources','<a href=\"http://locallistingz.net/hardware-software-resources/\" name=\"cat_347\" style=\"\">Hardware & Software Resources</a>',';0;'),(348,'Medical & Health','<a href=\"http://locallistingz.net/medical-health/\" name=\"cat_348\" style=\"\">Medical & Health</a>',';0;'),(349,'Healthcare Management ','<a href=\"http://locallistingz.net/healthcare-management/\" name=\"cat_349\" style=\"\">Healthcare Management </a>',';0;'),(350,'Heating and Air Conditioning Contractors','<a href=\"http://locallistingz.net/heating-and-air-conditioning-contractors/\" name=\"cat_350\" style=\"\">Heating and Air Conditioning Contractors</a>',';0;'),(351,'Home & Family','<a href=\"http://locallistingz.net/home-family/\" name=\"cat_351\" style=\"\">Home & Family</a>',';0;'),(352,'Home Improvement & Decor','<a href=\"http://locallistingz.net/home-improvement-decor/\" name=\"cat_352\" style=\"\">Home Improvement & Decor</a>',';0;'),(353,'Hotels & Accomadation','<a href=\"http://locallistingz.net/hotels-accomadation/\" name=\"cat_353\" style=\"\">Hotels & Accomadation</a>',';0;'),(354,'Insurance Companies','<a href=\"http://locallistingz.net/insurance-companies/\" name=\"cat_354\" style=\"\">Insurance Companies</a>',';0;'),(355,'Law','<a href=\"http://locallistingz.net/law/\" name=\"cat_355\" style=\"\">Law</a>',';0;'),(356,'Lawyers & Judges','<a href=\"http://locallistingz.net/lawyers-judges/\" name=\"cat_356\" style=\"\">Lawyers & Judges</a>',';0;'),(357,'Dating & Relationships ','<a href=\"http://locallistingz.net/dating-relationships/\" name=\"cat_357\" style=\"\">Dating & Relationships </a>',';0;'),(358,'Medicine & Hospitals ','<a href=\"http://locallistingz.net/medicine-hospitals/\" name=\"cat_358\" style=\"\">Medicine & Hospitals </a>',';0;'),(359,'Finance & Investment Services','<a href=\"http://locallistingz.net/finance-investment-services/\" name=\"cat_359\" style=\"\">Finance & Investment Services</a>',';0;'),(360,'News & Magazines','<a href=\"http://locallistingz.net/news-magazines/\" name=\"cat_360\" style=\"\">News & Magazines</a>',';0;'),(361,'Plumbing Services','<a href=\"http://locallistingz.net/plumbing-services/\" name=\"cat_361\" style=\"\">Plumbing Services</a>',';0;'),(362,'Real Estate Development','<a href=\"http://locallistingz.net/real-estate-development/\" name=\"cat_362\" style=\"\">Real Estate Development</a>',';0;'),(363,'Energy & Science ','<a href=\"http://locallistingz.net/energy-science/\" name=\"cat_363\" style=\"\">Energy & Science </a>',';0;'),(364,'Shopping and Retail','<a href=\"http://locallistingz.net/shopping-and-retail/\" name=\"cat_364\" style=\"\">Shopping and Retail</a>',';0;'),(365,'Shopping and Retail','<a href=\"http://locallistingz.net/shopping-and-retail/\" name=\"cat_365\" style=\"\">Shopping and Retail</a>',';0;'),(366,'Recreation & Sports','<a href=\"http://locallistingz.net/recreation-sports/\" name=\"cat_366\" style=\"\">Recreation & Sports</a>',';0;'),(367,'Transport & Travel','<a href=\"http://locallistingz.net/transport-travel/\" name=\"cat_367\" style=\"\">Transport & Travel</a>',';0;'),(368,'Wedding & Events','<a href=\"http://locallistingz.net/wedding-events/\" name=\"cat_368\" style=\"\">Wedding & Events</a>',';0;'),(369,'SEO ,SMO & PPC','<a href=\"http://locallistingz.net/seo-smo-ppc/\" name=\"cat_369\" style=\"\">SEO ,SMO & PPC</a>',';0;');

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

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

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

INSERT INTO `idx_category_suggession` VALUES (1,343,'ladentist',' Dr. Elyassi has gained recognition as one of LA’s finest and top-rated dentists throughout the region. Be it cosmetic, restorative, or simply general dentistry.','2011-11-23 07:39:01'),(2,337,'Catering Equipment','Top quality stainless steel fabrications and made to measure kitchen solutions for both domestic and commercial kitchens, including custom made stainless splashbacks, stainless steel worktops, catering tables, food preparation tables, Shelving, Microwave shelves, Door kick plates, and many more items. http://www.bespokecaterquip.co.uk/','2011-12-22 05:04:33'),(3,337,'Smoking Shelters','Leading Manufacturer Of Smoking Shelters & Cigarette Bins. http://www.shelters-r-us.co.uk/  \r\n','2011-12-22 05:28:59'),(4,361,'Plumbing, Heating and Maintenance','D.R.C. Bardwell is a professional plumbing and heating company based in Norwich, serving surrounding areas in Norfolk. http://www.plumbingandheatingnorwich.co.uk/','2011-12-22 05:51:12'),(5,357,'Online Dating','Lotsofloves.com is a completely free online dating site which allows you to meet your perfect partner. Providing a brilliant matching service which allows you to instant message, send instant winks, create your own dating profile, use web cam video chat, visit chat rooms, upload photos, create friends lists and enjoy safe dating with friends only facilities','2011-12-22 05:53:46'),(6,343,'Dentist Ashburn VA','Dental care for the whole family located in Lansdowne VA. Dr Nik provides comprehensive care and can perform a wide range of services from routine dental visits to full mouth restorations. Visit our website at www.LCIDentist.com','2012-01-05 12:06:52');

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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

--
-- 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `title` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`favorite_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `idx_favorites` VALUES (1,'aangeliascott','2011-06-22','My Favorites',NULL),(2,'chrismukuka','2011-08-08','My Favorites',NULL),(3,'b394347837','2011-08-14','My Favorites',NULL),(4,'emilychilesh','2011-08-16','My Favorites',NULL),(6,'lancebachmann477','2011-08-23','My Favorites',NULL),(7,'lancebachmann241','2011-08-23','My Favorites',NULL),(8,'kelvinc','2011-10-07','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=utf8 COLLATE=utf8_unicode_ci;

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


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

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

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


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

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

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


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

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

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

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

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

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

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

INSERT INTO `idx_link_temp_user` VALUES (2,'aangeliascott'),(3,'aangeliascott'),(4,'aangeliascott'),(5,'aangeliascott'),(6,'aangeliascott'),(7,'aangeliascott');

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

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

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

INSERT INTO `idx_link_user` VALUES (1,'aangeliascott'),(2,'lancebachmann47'),(3,'lancebachmann477'),(4,'lancebachmann241');

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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `idx_pagerank` VALUES (1,'g',2,'2011-09-24'),(2,'g',2,'2011-08-31'),(4,'g',3,'2011-09-12'),(82,'g',2,'2011-09-13'),(3,'g',1,'2011-09-13'),(77,'g',0,'2011-10-16'),(116,'g',2,'2011-09-13'),(125,'g',2,'2011-09-13'),(59,'g',1,'2011-09-13'),(73,'g',2,'2011-09-13'),(78,'g',2,'2011-09-13'),(135,'g',2,'2011-09-13'),(126,'g',2,'2011-09-13'),(115,'g',0,'2011-10-16'),(18,'g',3,'2011-09-15'),(25,'g',3,'2011-09-15'),(113,'g',2,'2011-09-15'),(133,'g',2,'2011-09-15'),(143,'g',2,'2011-09-15'),(153,'g',2,'2011-09-15'),(34,'g',2,'2011-09-15'),(15,'g',4,'2011-09-15'),(20,'g',2,'2011-09-15'),(69,'g',3,'2011-09-15'),(35,'g',2,'2011-09-15'),(92,'g',2,'2011-09-15'),(41,'g',3,'2011-09-15'),(119,'g',2,'2011-09-15'),(109,'g',2,'2011-09-15'),(112,'g',3,'2011-09-16'),(63,'g',3,'2011-09-19'),(33,'g',1,'2011-09-19'),(88,'g',3,'2011-09-19'),(421,'g',0,'2012-02-21'),(387,'g',0,'2012-01-16'),(449,'g',0,'2012-02-21'),(451,'g',0,'2012-02-08'),(43,'g',3,'2011-09-20'),(399,'g',0,'2012-02-08'),(7,'g',0,'2011-09-20'),(8,'g',5,'2011-09-20'),(10,'g',0,'2011-09-20'),(9,'g',0,'2011-09-20'),(26,'g',2,'2011-09-20'),(359,'g',0,'2011-09-20'),(360,'g',5,'2011-09-20'),(51,'g',4,'2011-09-20'),(11,'g',2,'2011-09-20'),(127,'g',0,'2011-09-20'),(14,'g',3,'2011-09-20'),(19,'g',3,'2011-09-20'),(42,'g',2,'2011-09-20'),(123,'g',2,'2011-09-20'),(274,'g',1,'2011-09-20'),(281,'g',2,'2011-09-20'),(259,'g',1,'2011-09-20'),(437,'g',0,'2011-12-15'),(357,'g',1,'2011-09-20'),(146,'g',2,'2011-09-20'),(24,'g',3,'2011-09-20'),(136,'g',2,'2011-09-20'),(463,'g',0,'2012-02-18'),(79,'g',0,'2011-09-20'),(117,'g',0,'2011-09-20'),(137,'g',0,'2011-09-20'),(17,'g',3,'2011-09-22'),(23,'g',3,'2011-09-22'),(27,'g',3,'2011-09-22'),(50,'g',0,'2011-09-22'),(94,'g',0,'2011-09-22'),(472,'g',0,'2012-01-23'),(107,'g',3,'2011-09-22'),(12,'g',2,'2011-09-22'),(21,'g',3,'2011-09-22'),(431,'g',0,'2012-02-07'),(102,'g',2,'2011-09-22'),(71,'g',2,'2011-09-22'),(417,'g',0,'2012-02-07'),(466,'g',0,'2012-02-07'),(47,'g',3,'2011-09-22'),(469,'g',0,'2011-11-03'),(105,'g',2,'2011-09-22'),(403,'g',0,'2011-11-04'),(85,'g',1,'2011-09-23'),(345,'g',3,'2011-09-23'),(5,'g',4,'2011-09-23'),(350,'g',2,'2011-09-23'),(349,'g',2,'2011-09-23'),(334,'g',3,'2011-09-23'),(346,'g',3,'2011-09-23'),(448,'g',0,'2011-11-09'),(351,'g',2,'2011-09-23'),(108,'g',6,'2011-09-23'),(348,'g',2,'2011-09-23'),(70,'g',3,'2011-09-23'),(347,'g',0,'2011-09-23'),(75,'g',2,'2011-09-23'),(83,'g',0,'2011-09-23'),(29,'g',3,'2011-09-23'),(91,'g',3,'2011-09-23'),(60,'g',2,'2011-09-23'),(72,'g',3,'2011-09-23'),(32,'g',0,'2011-09-23'),(96,'g',0,'2011-09-23'),(89,'g',0,'2011-09-23'),(86,'g',1,'2011-09-23'),(37,'g',2,'2011-09-23'),(392,'g',0,'2012-01-14'),(456,'g',0,'2012-02-16'),(90,'g',2,'2011-09-23'),(445,'g',0,'2012-01-22'),(453,'g',0,'2012-02-24'),(57,'g',2,'2011-09-23'),(16,'g',2,'2011-09-23'),(369,'g',2,'2011-09-23'),(414,'g',0,'2012-02-17'),(106,'g',1,'2011-09-23'),(471,'g',0,'2012-02-21'),(84,'g',2,'2011-09-23'),(53,'g',0,'2011-09-23'),(30,'g',3,'2011-09-24'),(67,'g',2,'2011-09-24'),(384,'g',0,'2012-01-23'),(22,'g',2,'2011-09-24'),(100,'g',2,'2011-09-24'),(103,'g',0,'2011-09-24'),(104,'g',4,'2011-09-24'),(410,'g',0,'2012-02-11'),(358,'g',1,'2011-09-24'),(6,'g',1,'2011-09-24'),(56,'g',1,'2011-10-01'),(99,'g',2,'2011-10-01'),(38,'g',2,'2011-10-01'),(98,'g',1,'2011-10-01'),(80,'g',2,'2011-10-01'),(74,'g',1,'2011-10-01'),(393,'g',0,'2011-12-29'),(441,'g',0,'2011-12-29'),(434,'g',0,'2012-03-04'),(413,'g',0,'2011-12-29'),(36,'g',2,'2011-10-02'),(54,'g',2,'2011-10-02'),(68,'g',1,'2011-10-02'),(87,'g',0,'2011-10-02'),(95,'g',2,'2011-10-02'),(52,'g',0,'2011-10-02'),(49,'g',0,'2011-10-02'),(13,'g',4,'2011-10-02'),(45,'g',3,'2011-10-02'),(44,'g',3,'2011-10-02'),(40,'g',1,'2011-10-02'),(28,'g',0,'2011-10-02'),(46,'g',2,'2011-10-02'),(39,'g',3,'2011-10-02'),(31,'g',0,'2011-10-02'),(55,'g',3,'2011-10-05'),(412,'g',0,'2012-02-07'),(76,'g',0,'2011-10-07'),(48,'g',0,'2011-10-11'),(130,'g',0,'2011-10-11'),(110,'g',0,'2011-10-11'),(120,'g',0,'2011-10-11'),(140,'g',0,'2011-10-11'),(273,'g',0,'2011-10-13'),(272,'g',0,'2011-10-13'),(267,'g',0,'2011-10-13'),(271,'g',0,'2011-10-13'),(278,'g',0,'2011-10-13'),(261,'g',0,'2011-10-13'),(262,'g',0,'2011-10-13'),(270,'g',0,'2011-10-13'),(428,'g',0,'2012-02-21'),(388,'g',0,'2012-03-05'),(373,'g',0,'2012-02-21'),(455,'g',0,'2012-03-05'),(377,'g',0,'2012-02-25'),(379,'g',0,'2012-02-21'),(426,'g',0,'2012-02-21'),(447,'g',0,'2011-11-23'),(464,'g',0,'2012-01-12'),(468,'g',0,'2012-02-11'),(461,'g',0,'2011-12-29'),(462,'g',0,'2011-12-29'),(458,'g',0,'2012-01-19'),(450,'g',0,'2012-01-19'),(411,'g',0,'2012-02-09'),(404,'g',0,'2012-01-19'),(394,'g',0,'2012-02-23'),(409,'g',0,'2012-02-28'),(423,'g',0,'2012-02-21'),(420,'g',0,'2012-02-21'),(416,'g',0,'2012-01-23'),(385,'g',0,'2012-02-21'),(406,'g',0,'2012-02-21'),(419,'g',0,'2012-02-23'),(400,'g',0,'2012-01-17'),(401,'g',0,'2012-01-17'),(427,'g',0,'2012-02-27'),(383,'g',0,'2012-02-25'),(435,'g',0,'2012-02-03'),(386,'g',0,'2012-01-17'),(454,'g',0,'2012-02-25'),(432,'g',0,'2012-02-25'),(459,'g',0,'2012-02-25'),(446,'g',0,'2012-01-17'),(452,'g',0,'2012-02-25'),(429,'g',0,'2012-01-17'),(418,'g',0,'2012-02-25'),(467,'g',0,'2012-02-11'),(422,'g',0,'2012-02-18'),(389,'g',0,'2011-12-15'),(405,'g',0,'2012-02-18'),(443,'g',0,'2012-02-18'),(430,'g',0,'2012-02-25'),(444,'g',0,'2012-02-18'),(415,'g',0,'2011-12-15'),(397,'g',0,'2012-02-18'),(374,'g',0,'2012-01-19'),(375,'g',0,'2012-01-19'),(407,'g',0,'2012-01-19'),(457,'g',0,'2012-01-19'),(370,'g',0,'2011-11-03'),(433,'g',0,'2012-02-21'),(613,'g',0,'2011-11-13'),(680,'g',0,'2011-11-13'),(606,'g',0,'2011-11-13'),(740,'g',0,'2011-11-13'),(646,'g',0,'2011-11-13'),(687,'g',0,'2011-11-13'),(679,'g',0,'2011-11-13'),(683,'g',0,'2011-11-13'),(610,'g',0,'2011-11-13'),(649,'g',0,'2011-11-13'),(726,'g',0,'2011-11-14'),(906,'g',0,'2011-11-14'),(1326,'g',0,'2011-11-14'),(1299,'g',0,'2011-11-14'),(1828,'g',0,'2011-11-14'),(749,'g',0,'2011-11-14'),(1263,'g',0,'2011-11-14'),(699,'g',0,'2011-11-14'),(1630,'g',0,'2011-11-14'),(380,'g',0,'2012-01-30'),(408,'g',0,'2012-01-30'),(803,'g',0,'2011-11-15'),(918,'g',0,'2011-11-15'),(979,'g',0,'2011-11-15'),(985,'g',0,'2011-11-15'),(1213,'g',0,'2011-11-15'),(1226,'g',0,'2011-11-15'),(802,'g',0,'2011-11-15'),(799,'g',0,'2011-11-15'),(763,'g',0,'2011-11-15'),(719,'g',0,'2011-11-15'),(718,'g',0,'2011-11-15'),(514,'g',0,'2011-11-16'),(856,'g',0,'2011-11-16'),(513,'g',0,'2011-11-16'),(863,'g',0,'2011-11-16'),(860,'g',0,'2011-11-16'),(859,'g',0,'2011-11-16'),(864,'g',0,'2011-11-16'),(512,'g',0,'2011-11-16'),(862,'g',0,'2011-11-16'),(515,'g',0,'2011-11-16'),(858,'g',0,'2011-11-16'),(517,'g',0,'2011-11-16'),(861,'g',0,'2011-11-16'),(1188,'g',0,'2011-11-16'),(516,'g',0,'2011-11-16'),(1190,'g',0,'2011-11-16'),(1186,'g',0,'2011-11-16'),(1199,'g',0,'2011-11-16'),(1191,'g',0,'2011-11-16'),(1189,'g',0,'2011-11-16'),(865,'g',0,'2011-11-16'),(1215,'g',0,'2011-11-16'),(1176,'g',0,'2011-11-16'),(1175,'g',0,'2011-11-16'),(1195,'g',0,'2011-11-16'),(857,'g',0,'2011-11-16'),(617,'g',0,'2011-11-16'),(671,'g',0,'2011-11-16'),(609,'g',0,'2011-11-16'),(587,'g',0,'2011-11-16'),(534,'g',0,'2011-11-16'),(497,'g',0,'2011-11-16'),(493,'g',0,'2011-11-16'),(572,'g',0,'2011-11-17'),(809,'g',0,'2011-11-17'),(741,'g',0,'2011-11-17'),(531,'g',0,'2011-11-17'),(532,'g',0,'2011-11-17'),(708,'g',0,'2011-11-17'),(538,'g',0,'2011-11-17'),(529,'g',0,'2011-11-17'),(528,'g',0,'2011-11-17'),(938,'g',0,'2011-11-17'),(954,'g',0,'2011-11-17'),(745,'g',0,'2011-11-17'),(1288,'g',0,'2011-11-17'),(1287,'g',0,'2011-11-17'),(1221,'g',0,'2011-11-17'),(1421,'g',0,'2011-11-17'),(616,'g',0,'2011-11-17'),(601,'g',0,'2011-11-17'),(583,'g',0,'2011-11-17'),(621,'g',0,'2011-11-17'),(555,'g',0,'2011-11-17'),(569,'g',0,'2011-11-17'),(535,'g',0,'2011-11-17'),(503,'g',0,'2011-11-17'),(494,'g',0,'2011-11-17'),(530,'g',0,'2011-11-17'),(722,'g',0,'2011-11-18'),(577,'g',0,'2011-11-18'),(993,'g',0,'2011-11-18'),(759,'g',0,'2011-11-18'),(761,'g',0,'2011-11-18'),(508,'g',0,'2011-11-18'),(966,'g',0,'2011-11-18'),(591,'g',0,'2011-11-18'),(948,'g',0,'2011-11-18'),(1108,'g',0,'2011-11-18'),(603,'g',0,'2011-11-18'),(1355,'g',0,'2011-11-18'),(1129,'g',0,'2011-11-18'),(1344,'g',0,'2011-11-18'),(1369,'g',0,'2011-11-18'),(1194,'g',0,'2011-11-18'),(1303,'g',0,'2011-11-18'),(1354,'g',0,'2011-11-18'),(1091,'g',0,'2011-11-18'),(1357,'g',0,'2011-11-18'),(1356,'g',0,'2011-11-18'),(668,'g',0,'2011-11-19'),(806,'g',0,'2011-11-19'),(593,'g',0,'2011-11-19'),(920,'g',0,'2011-11-19'),(1003,'g',0,'2011-11-19'),(775,'g',0,'2011-11-19'),(1431,'g',0,'2011-11-19'),(678,'g',0,'2011-11-19'),(1235,'g',0,'2011-11-19'),(588,'g',0,'2011-11-19'),(1420,'g',0,'2011-11-19'),(1345,'g',0,'2011-11-19'),(598,'g',0,'2011-11-19'),(579,'g',0,'2011-11-19'),(650,'g',0,'2011-11-19'),(582,'g',0,'2011-11-19'),(766,'g',0,'2011-11-19'),(753,'g',0,'2011-11-19'),(742,'g',0,'2011-11-19'),(961,'g',0,'2011-11-19'),(1554,'g',0,'2011-11-19'),(1446,'g',0,'2011-11-19'),(1311,'g',0,'2011-11-19'),(1562,'g',0,'2011-11-19'),(1517,'g',0,'2011-11-19'),(1279,'g',0,'2011-11-19'),(1261,'g',0,'2011-11-19'),(1362,'g',0,'2011-11-19'),(1342,'g',0,'2011-11-19'),(1330,'g',0,'2011-11-19'),(545,'g',0,'2011-11-19'),(756,'g',0,'2011-11-19'),(1419,'g',0,'2011-11-19'),(1527,'g',0,'2011-11-19'),(1255,'g',0,'2011-11-19'),(1271,'g',0,'2011-11-19'),(1515,'g',0,'2011-11-19'),(1265,'g',0,'2011-11-19'),(902,'g',0,'2011-11-19'),(995,'g',0,'2011-11-19'),(1066,'g',0,'2011-11-19'),(1179,'g',0,'2011-11-19'),(1211,'g',0,'2011-11-19'),(1488,'g',0,'2011-11-19'),(1537,'g',0,'2011-11-19'),(910,'g',0,'2011-11-19'),(1053,'g',0,'2011-11-19'),(651,'g',0,'2011-11-19'),(751,'g',0,'2011-11-20'),(571,'g',0,'2011-11-20'),(1076,'g',0,'2011-11-20'),(945,'g',0,'2011-11-20'),(1346,'g',0,'2011-11-20'),(1350,'g',0,'2011-11-20'),(1386,'g',0,'2011-11-20'),(770,'g',0,'2011-11-20'),(738,'g',0,'2011-11-20'),(1348,'g',0,'2011-11-20'),(805,'g',0,'2011-11-20'),(748,'g',0,'2011-11-20'),(777,'g',0,'2011-11-20'),(773,'g',0,'2011-11-20'),(614,'g',0,'2011-11-20'),(768,'g',0,'2011-11-20'),(974,'g',0,'2011-11-20'),(1388,'g',0,'2011-11-20'),(784,'g',0,'2011-11-20'),(746,'g',0,'2011-11-20'),(1192,'g',0,'2011-11-20'),(757,'g',0,'2011-11-20'),(737,'g',0,'2011-11-20'),(1349,'g',0,'2011-11-20'),(905,'g',0,'2011-11-21'),(1100,'g',0,'2011-11-21'),(931,'g',0,'2011-11-21'),(935,'g',0,'2011-11-21'),(662,'g',0,'2011-11-21'),(991,'g',0,'2011-11-21'),(990,'g',0,'2011-11-21'),(982,'g',0,'2011-11-21'),(1081,'g',0,'2011-11-21'),(684,'g',0,'2011-11-21'),(994,'g',0,'2011-11-21'),(1118,'g',0,'2011-11-21'),(592,'g',0,'2011-11-21'),(989,'g',0,'2011-11-21'),(909,'g',0,'2011-11-22'),(796,'g',0,'2011-11-22'),(644,'g',0,'2011-11-22'),(584,'g',0,'2011-11-22'),(673,'g',0,'2011-11-22'),(544,'g',0,'2011-11-22'),(504,'g',0,'2011-11-22'),(542,'g',0,'2011-11-22'),(676,'g',0,'2011-11-22'),(559,'g',0,'2011-11-22'),(1564,'g',0,'2011-11-22'),(1309,'g',0,'2011-11-22'),(1514,'g',0,'2011-11-22'),(1407,'g',0,'2011-11-22'),(1336,'g',0,'2011-11-22'),(1640,'g',0,'2011-11-22'),(1456,'g',0,'2011-11-22'),(1607,'g',0,'2011-11-22'),(1617,'g',0,'2011-11-22'),(1746,'g',0,'2011-11-22'),(1416,'g',0,'2011-11-22'),(1455,'g',0,'2011-11-22'),(1712,'g',0,'2011-11-22'),(1818,'g',0,'2011-11-22'),(1398,'g',0,'2011-11-22'),(1599,'g',0,'2011-11-22'),(1666,'g',0,'2011-11-22'),(1477,'g',0,'2011-11-22'),(1781,'g',0,'2011-11-22'),(1851,'g',0,'2011-11-22'),(1302,'g',0,'2011-11-22'),(1468,'g',0,'2011-11-22'),(1714,'g',0,'2011-11-22'),(1646,'g',0,'2011-11-22'),(1402,'g',0,'2011-11-22'),(696,'g',0,'2011-11-22'),(744,'g',0,'2011-11-22'),(619,'g',0,'2011-11-22'),(1778,'g',0,'2011-11-22'),(643,'g',0,'2011-11-22'),(755,'g',0,'2011-11-22'),(590,'g',0,'2011-11-22'),(690,'g',0,'2011-11-22'),(689,'g',0,'2011-11-22'),(754,'g',0,'2011-11-22'),(1276,'g',0,'2011-11-22'),(1633,'g',0,'2011-11-22'),(1605,'g',0,'2011-11-22'),(576,'g',0,'2011-11-22'),(1635,'g',0,'2011-11-22'),(1780,'g',0,'2011-11-22'),(1393,'g',0,'2011-11-22'),(1412,'g',0,'2011-11-22'),(1378,'g',0,'2011-11-22'),(1469,'g',0,'2011-11-22'),(1290,'g',0,'2011-11-22'),(1619,'g',0,'2011-11-22'),(1286,'g',0,'2011-11-22'),(1565,'g',0,'2011-11-22'),(1116,'g',0,'2011-11-22'),(1101,'g',0,'2011-11-22'),(1231,'g',0,'2011-11-22'),(1798,'g',0,'2011-11-22'),(1227,'g',0,'2011-11-22'),(1193,'g',0,'2011-11-22'),(1174,'g',0,'2011-11-22'),(1159,'g',0,'2011-11-22'),(1250,'g',0,'2011-11-22'),(1225,'g',0,'2011-11-22'),(1567,'g',0,'2011-11-22'),(1411,'g',0,'2011-11-22'),(934,'g',0,'2011-11-22'),(801,'g',0,'2011-11-22'),(489,'g',0,'2011-11-22'),(781,'g',0,'2011-11-22'),(580,'g',0,'2011-11-22'),(1083,'g',0,'2011-11-22'),(1049,'g',0,'2011-11-22'),(1115,'g',0,'2011-11-22'),(1648,'g',0,'2011-11-22'),(1692,'g',0,'2011-11-22'),(1137,'g',0,'2011-11-22'),(1618,'g',0,'2011-11-23'),(937,'g',0,'2011-11-23'),(702,'g',0,'2011-11-23'),(691,'g',0,'2011-11-23'),(916,'g',0,'2011-11-23'),(480,'g',0,'2011-11-23'),(896,'g',0,'2011-11-23'),(715,'g',0,'2011-11-23'),(492,'g',0,'2011-11-23'),(698,'g',0,'2011-11-23'),(1645,'g',0,'2011-11-23'),(1510,'g',0,'2011-11-23'),(1333,'g',0,'2011-11-23'),(1285,'g',0,'2011-11-23'),(1474,'g',0,'2011-11-23'),(1391,'g',0,'2011-11-23'),(1258,'g',0,'2011-11-23'),(1340,'g',0,'2011-11-23'),(1331,'g',0,'2011-11-23'),(1480,'g',0,'2011-11-23'),(1521,'g',0,'2011-11-23'),(1856,'g',0,'2011-11-23'),(1779,'g',0,'2011-11-23'),(1782,'g',0,'2011-11-23'),(1291,'g',0,'2011-11-23'),(1335,'g',0,'2011-11-23'),(1631,'g',0,'2011-11-23'),(1453,'g',0,'2011-11-23'),(1471,'g',0,'2011-11-23'),(1687,'g',0,'2011-11-23'),(1247,'g',0,'2011-11-23'),(1552,'g',0,'2011-11-23'),(1489,'g',0,'2011-11-23'),(1854,'g',0,'2011-11-23'),(1589,'g',0,'2011-11-23'),(1785,'g',0,'2011-11-23'),(1643,'g',0,'2011-11-23'),(1620,'g',0,'2011-11-23'),(1374,'g',0,'2011-11-23'),(1472,'g',0,'2011-11-23'),(1578,'g',0,'2011-11-23'),(1621,'g',0,'2011-11-23'),(1498,'g',0,'2011-11-23'),(1427,'g',0,'2011-11-23'),(1280,'g',0,'2011-11-23'),(1539,'g',0,'2011-11-23'),(1082,'g',0,'2011-11-23'),(1294,'g',0,'2011-11-23'),(3332,'g',0,'2011-11-24'),(1593,'g',0,'2011-11-25'),(1601,'g',0,'2011-11-25'),(1603,'g',0,'2011-11-25'),(1602,'g',0,'2011-11-25'),(1613,'g',0,'2011-11-25'),(1611,'g',0,'2011-11-25'),(1597,'g',0,'2011-11-25'),(1600,'g',0,'2011-11-25'),(1596,'g',0,'2011-11-25'),(1592,'g',0,'2011-11-25'),(735,'g',0,'2011-11-26'),(917,'g',0,'2011-11-26'),(2128,'g',0,'2012-03-06'),(2310,'g',0,'2012-03-06'),(557,'g',0,'2011-11-27'),(556,'g',0,'2011-11-27'),(585,'g',0,'2011-11-27'),(553,'g',0,'2011-11-27'),(685,'g',0,'2011-11-27'),(602,'g',0,'2011-11-27'),(575,'g',0,'2011-11-27'),(620,'g',0,'2011-11-27'),(604,'g',0,'2011-11-27'),(953,'g',0,'2011-11-27'),(714,'g',0,'2011-11-27'),(929,'g',0,'2011-11-27'),(1009,'g',0,'2011-11-28'),(731,'g',0,'2011-11-28'),(2124,'g',0,'2012-02-08'),(2364,'g',0,'2012-02-09'),(436,'g',0,'2011-12-31'),(547,'g',0,'2011-11-28'),(2191,'g',0,'2012-02-08'),(936,'g',0,'2011-11-28'),(2502,'g',0,'2012-01-13'),(798,'g',0,'2011-11-28'),(1109,'g',0,'2011-11-28'),(2753,'g',0,'2012-01-29'),(998,'g',0,'2011-11-28'),(500,'g',0,'2011-11-28'),(2754,'g',0,'2012-01-29'),(1360,'g',0,'2011-11-28'),(506,'g',0,'2011-11-28'),(499,'g',0,'2011-11-28'),(1361,'g',0,'2011-11-28'),(561,'g',0,'2011-11-28'),(971,'g',0,'2011-11-28'),(1371,'g',0,'2011-11-29'),(912,'g',0,'2011-11-29'),(927,'g',0,'2011-11-29'),(484,'g',0,'2011-11-29'),(789,'g',0,'2011-11-29'),(1000,'g',0,'2011-11-30'),(1395,'g',0,'2011-11-30'),(483,'g',0,'2011-11-30'),(1295,'g',0,'2011-11-30'),(1659,'g',0,'2011-12-02'),(1653,'g',0,'2011-12-02'),(1658,'g',0,'2011-12-02'),(1655,'g',0,'2011-12-02'),(1570,'g',0,'2011-12-04'),(1584,'g',0,'2011-12-04'),(1585,'g',0,'2011-12-04'),(1581,'g',0,'2011-12-04'),(1461,'g',0,'2011-12-04'),(1580,'g',0,'2011-12-04'),(1573,'g',0,'2011-12-04'),(1434,'g',0,'2011-12-04'),(1587,'g',0,'2011-12-04'),(1583,'g',0,'2011-12-04'),(1341,'g',0,'2011-12-05'),(2298,'g',0,'2012-02-28'),(496,'g',0,'2011-12-06'),(477,'g',0,'2011-12-06'),(892,'g',0,'2011-12-06'),(908,'g',0,'2011-12-06'),(911,'g',0,'2011-12-06'),(1035,'g',0,'2011-12-06'),(947,'g',0,'2011-12-06'),(1065,'g',0,'2011-12-06'),(1166,'g',0,'2011-12-06'),(1232,'g',0,'2011-12-06'),(1228,'g',0,'2011-12-06'),(1269,'g',0,'2011-12-06'),(1270,'g',0,'2011-12-06'),(1343,'g',0,'2011-12-06'),(1430,'g',0,'2011-12-06'),(1457,'g',0,'2011-12-06'),(2347,'g',0,'2012-02-18'),(1540,'g',0,'2011-12-06'),(1686,'g',0,'2011-12-06'),(2331,'g',0,'2012-02-18'),(2138,'g',0,'2012-02-18'),(1849,'g',0,'2011-12-06'),(1576,'g',0,'2011-12-06'),(1843,'g',0,'2011-12-06'),(2475,'g',0,'2011-12-06'),(1541,'g',0,'2011-12-06'),(2295,'g',0,'2012-02-28'),(3570,'g',0,'2012-02-18'),(1877,'g',0,'2012-02-25'),(2143,'g',0,'2012-01-17'),(1876,'g',0,'2012-01-17'),(2243,'g',0,'2011-12-09'),(1887,'g',0,'2012-03-02'),(2242,'g',0,'2012-02-23'),(2056,'g',0,'2012-01-17'),(2388,'g',0,'2012-01-27'),(1870,'g',0,'2012-02-09'),(2396,'g',0,'2012-01-23'),(2738,'g',0,'2012-01-23'),(2813,'g',0,'2012-01-23'),(2824,'g',0,'2012-01-23'),(2168,'g',0,'2012-01-23'),(2354,'g',0,'2012-01-23'),(2313,'g',0,'2012-01-23'),(2199,'g',0,'2012-01-23'),(2628,'g',0,'2012-01-23'),(2384,'g',0,'2012-02-18'),(2474,'g',0,'2012-02-18'),(2375,'g',0,'2012-01-16'),(2387,'g',0,'2012-02-18'),(2055,'g',0,'2012-02-18'),(2493,'g',0,'2012-02-18'),(2324,'g',0,'2012-02-18'),(2570,'g',0,'2011-12-12'),(2430,'g',0,'2011-12-12'),(2423,'g',0,'2011-12-12'),(2383,'g',0,'2011-12-12'),(2413,'g',0,'2011-12-12'),(2444,'g',0,'2011-12-12'),(2408,'g',0,'2011-12-12'),(2433,'g',0,'2011-12-12'),(2577,'g',0,'2011-12-12'),(2447,'g',0,'2011-12-12'),(2721,'g',0,'2011-12-12'),(2077,'g',0,'2012-01-16'),(1931,'g',0,'2012-03-05'),(2790,'g',0,'2011-12-12'),(2780,'g',0,'2011-12-12'),(3145,'g',0,'2011-12-12'),(2722,'g',0,'2011-12-12'),(3158,'g',0,'2011-12-12'),(3147,'g',0,'2011-12-12'),(3157,'g',0,'2011-12-12'),(2716,'g',0,'2011-12-12'),(3047,'g',0,'2011-12-12'),(3148,'g',0,'2011-12-12'),(3153,'g',0,'2011-12-12'),(2822,'g',0,'2011-12-12'),(2803,'g',0,'2011-12-12'),(3154,'g',0,'2011-12-12'),(3001,'g',0,'2011-12-12'),(3150,'g',0,'2011-12-12'),(3043,'g',0,'2011-12-12'),(2787,'g',0,'2011-12-12'),(3045,'g',0,'2011-12-12'),(3051,'g',0,'2011-12-12'),(2703,'g',0,'2011-12-12'),(3042,'g',0,'2011-12-12'),(2708,'g',0,'2011-12-12'),(3044,'g',0,'2011-12-12'),(2686,'g',0,'2011-12-12'),(2448,'g',0,'2011-12-12'),(2715,'g',0,'2011-12-12'),(2685,'g',0,'2011-12-12'),(3186,'g',0,'2011-12-12'),(2677,'g',0,'2011-12-12'),(2778,'g',0,'2011-12-12'),(2817,'g',0,'2011-12-12'),(3156,'g',0,'2011-12-12'),(3049,'g',0,'2011-12-12'),(2601,'g',0,'2011-12-12'),(3048,'g',0,'2011-12-12'),(3151,'g',0,'2011-12-12'),(3161,'g',0,'2011-12-12'),(2676,'g',0,'2011-12-12'),(3182,'g',0,'2011-12-12'),(3184,'g',0,'2011-12-12'),(2674,'g',0,'2011-12-12'),(3183,'g',0,'2011-12-12'),(2690,'g',0,'2011-12-12'),(3046,'g',0,'2011-12-12'),(3208,'g',0,'2011-12-12'),(2382,'g',0,'2012-02-18'),(3132,'g',0,'2011-12-12'),(3052,'g',0,'2011-12-12'),(3062,'g',0,'2011-12-12'),(3165,'g',0,'2011-12-12'),(3054,'g',0,'2011-12-12'),(3141,'g',0,'2011-12-12'),(3056,'g',0,'2011-12-12'),(3159,'g',0,'2011-12-12'),(3143,'g',0,'2011-12-12'),(3053,'g',0,'2011-12-12'),(3185,'g',0,'2011-12-12'),(3144,'g',0,'2011-12-12'),(3135,'g',0,'2011-12-12'),(3167,'g',0,'2011-12-12'),(2983,'g',0,'2011-12-12'),(2845,'g',0,'2011-12-12'),(2647,'g',0,'2011-12-12'),(3057,'g',0,'2012-03-05'),(2765,'g',0,'2011-12-12'),(2939,'g',0,'2012-03-05'),(3121,'g',0,'2012-03-05'),(2711,'g',0,'2011-12-12'),(2714,'g',0,'2011-12-12'),(2713,'g',0,'2011-12-12'),(2709,'g',0,'2012-03-05'),(2638,'g',0,'2012-03-05'),(2682,'g',0,'2011-12-12'),(2705,'g',0,'2012-02-21'),(2863,'g',0,'2011-12-12'),(2652,'g',0,'2011-12-12'),(2710,'g',0,'2012-03-05'),(2717,'g',0,'2011-12-12'),(3125,'g',0,'2012-03-06'),(2712,'g',0,'2012-03-05'),(2441,'g',0,'2011-12-12'),(2563,'g',0,'2011-12-12'),(3205,'g',0,'2012-03-05'),(3181,'g',0,'2011-12-12'),(3334,'g',0,'2012-03-06'),(3366,'g',0,'2012-03-05'),(3319,'g',0,'2012-03-05'),(2373,'g',0,'2012-03-05'),(3136,'g',0,'2012-03-05'),(3603,'g',0,'2011-12-12'),(3204,'g',0,'2011-12-12'),(3377,'g',0,'2011-12-12'),(2551,'g',0,'2012-03-05'),(2369,'g',0,'2011-12-12'),(2599,'g',0,'2011-12-12'),(3326,'g',0,'2011-12-12'),(2506,'g',0,'2011-12-12'),(2356,'g',0,'2011-12-12'),(2420,'g',0,'2011-12-12'),(3375,'g',0,'2012-03-05'),(2562,'g',0,'2011-12-13'),(2573,'g',0,'2011-12-13'),(2558,'g',0,'2012-03-05'),(2321,'g',0,'2012-03-05'),(1975,'g',0,'2011-12-13'),(3263,'g',0,'2011-12-13'),(2590,'g',0,'2011-12-13'),(2603,'g',0,'2011-12-13'),(2589,'g',0,'2011-12-13'),(2725,'g',0,'2012-02-29'),(3203,'g',0,'2011-12-13'),(2293,'g',0,'2012-03-05'),(2512,'g',0,'2012-03-05'),(2731,'g',0,'2011-12-13'),(1981,'g',0,'2011-12-13'),(2043,'g',0,'2012-03-05'),(2607,'g',0,'2012-03-05'),(1991,'g',0,'2011-12-13'),(2500,'g',0,'2012-03-05'),(2700,'g',0,'2011-12-13'),(2071,'g',0,'2011-12-13'),(3104,'g',0,'2011-12-13'),(3076,'g',0,'2012-03-05'),(2580,'g',0,'2011-12-13'),(2363,'g',0,'2012-03-05'),(2598,'g',0,'2011-12-13'),(2826,'g',0,'2011-12-13'),(3237,'g',0,'2011-12-13'),(2847,'g',0,'2011-12-13'),(1972,'g',0,'2012-03-05'),(2926,'g',0,'2011-12-13'),(2868,'g',0,'2011-12-13'),(2146,'g',0,'2012-03-05'),(2821,'g',0,'2011-12-13'),(2899,'g',0,'2011-12-13'),(2975,'g',0,'2011-12-13'),(2925,'g',0,'2011-12-13'),(2918,'g',0,'2011-12-13'),(2892,'g',0,'2011-12-13'),(1986,'g',0,'2011-12-13'),(1966,'g',0,'2011-12-13'),(2489,'g',0,'2011-12-13'),(2752,'g',0,'2011-12-13'),(2365,'g',0,'2012-03-05'),(2997,'g',0,'2011-12-13'),(3300,'g',0,'2011-12-13'),(3240,'g',0,'2011-12-13'),(2575,'g',0,'2012-03-05'),(2280,'g',0,'2011-12-13'),(2657,'g',0,'2012-03-05'),(2399,'g',0,'2011-12-13'),(2422,'g',0,'2011-12-13'),(2497,'g',0,'2011-12-13'),(2159,'g',0,'2012-03-05'),(2061,'g',0,'2011-12-13'),(2505,'g',0,'2011-12-13'),(2668,'g',0,'2012-03-05'),(2495,'g',0,'2011-12-13'),(2719,'g',0,'2011-12-13'),(3023,'g',0,'2012-01-19'),(2092,'g',0,'2012-02-03'),(1950,'g',0,'2011-12-13'),(2353,'g',0,'2012-03-05'),(2656,'g',0,'2012-02-03'),(2692,'g',0,'2012-01-19'),(1874,'g',0,'2012-02-21'),(2084,'g',0,'2012-02-21'),(2095,'g',0,'2012-01-21'),(2108,'g',0,'2012-02-21'),(2289,'g',0,'2012-02-06'),(2119,'g',0,'2012-03-06'),(1949,'g',0,'2011-12-13'),(1968,'g',0,'2011-12-13'),(3322,'g',0,'2012-03-05'),(1946,'g',0,'2011-12-13'),(2299,'g',0,'2012-02-21'),(2142,'g',0,'2012-03-06'),(3250,'g',0,'2011-12-14'),(2327,'g',0,'2011-12-14'),(1973,'g',0,'2011-12-14'),(2530,'g',0,'2011-12-14'),(1883,'g',0,'2011-12-14'),(2174,'g',0,'2011-12-14'),(2508,'g',0,'2011-12-14'),(2476,'g',0,'2011-12-14'),(2442,'g',0,'2011-12-14'),(2194,'g',0,'2011-12-14'),(2955,'g',0,'2011-12-14'),(2947,'g',0,'2011-12-14'),(3412,'g',0,'2011-12-14'),(3027,'g',0,'2011-12-14'),(3195,'g',0,'2011-12-14'),(2742,'g',0,'2012-01-14'),(2743,'g',0,'2011-12-14'),(2748,'g',0,'2012-01-24'),(3379,'g',0,'2011-12-14'),(2799,'g',0,'2011-12-14'),(2879,'g',0,'2011-12-14'),(2935,'g',0,'2011-12-14'),(2808,'g',0,'2011-12-14'),(2938,'g',0,'2011-12-14'),(1965,'g',0,'2011-12-14'),(3627,'g',0,'2011-12-14'),(1985,'g',0,'2011-12-14'),(2924,'g',0,'2011-12-14'),(3365,'g',0,'2011-12-14'),(2916,'g',0,'2012-01-17'),(3029,'g',0,'2012-01-17'),(3200,'g',0,'2011-12-14'),(2322,'g',0,'2011-12-14'),(3303,'g',0,'2011-12-14'),(2334,'g',0,'2012-02-06'),(2634,'g',0,'2011-12-14'),(2617,'g',0,'2012-02-06'),(2779,'g',0,'2011-12-14'),(2802,'g',0,'2011-12-14'),(2797,'g',0,'2011-12-14'),(3260,'g',0,'2011-12-14'),(2840,'g',0,'2012-01-17'),(3030,'g',0,'2012-01-17'),(3055,'g',0,'2012-01-17'),(2626,'g',0,'2012-01-17'),(1970,'g',0,'2012-01-19'),(1954,'g',0,'2012-02-21'),(2486,'g',0,'2011-12-14'),(2524,'g',0,'2011-12-14'),(2515,'g',0,'2011-12-14'),(2854,'g',0,'2011-12-14'),(2402,'g',0,'2011-12-15'),(3256,'g',0,'2011-12-15'),(3630,'g',0,'2011-12-15'),(3629,'g',0,'2011-12-15'),(1947,'g',0,'2011-12-15'),(1956,'g',0,'2011-12-15'),(1896,'g',0,'2011-12-15'),(1892,'g',0,'2011-12-15'),(1939,'g',0,'2011-12-15'),(1936,'g',0,'2011-12-15'),(1889,'g',0,'2011-12-15'),(1927,'g',0,'2011-12-15'),(3257,'g',0,'2011-12-15'),(2614,'g',0,'2012-02-18'),(2932,'g',0,'2011-12-15'),(2681,'g',0,'2012-02-18'),(3202,'g',0,'2011-12-15'),(2910,'g',0,'2011-12-15'),(2330,'g',0,'2011-12-15'),(2839,'g',0,'2012-03-02'),(1958,'g',0,'2011-12-15'),(1897,'g',0,'2012-01-14'),(1929,'g',0,'2012-01-14'),(1948,'g',0,'2012-01-14'),(1962,'g',0,'2011-12-15'),(1976,'g',0,'2011-12-15'),(1994,'g',0,'2011-12-15'),(2009,'g',0,'2011-12-15'),(1955,'g',0,'2011-12-15'),(3408,'g',0,'2012-02-08'),(2796,'g',0,'2011-12-15'),(2852,'g',0,'2011-12-15'),(3388,'g',0,'2012-03-05'),(2745,'g',0,'2012-01-17'),(2378,'g',0,'2012-02-20'),(2746,'g',0,'2012-01-17'),(2777,'g',0,'2011-12-15'),(3019,'g',0,'2012-01-17'),(3310,'g',0,'2011-12-15'),(3210,'g',0,'2011-12-15'),(3086,'g',0,'2012-01-17'),(2107,'g',0,'2011-12-15'),(2309,'g',0,'2012-02-06'),(2629,'g',0,'2012-02-06'),(2654,'g',0,'2011-12-15'),(3378,'g',0,'2011-12-15'),(470,'g',0,'2011-12-15'),(2469,'g',0,'2012-02-08'),(3437,'g',0,'2011-12-15'),(3495,'g',0,'2012-01-17'),(3422,'g',0,'2011-12-15'),(2841,'g',0,'2011-12-15'),(2782,'g',0,'2011-12-15'),(2886,'g',0,'2011-12-15'),(2762,'g',0,'2011-12-15'),(2196,'g',0,'2012-02-20'),(3090,'g',0,'2011-12-15'),(3100,'g',0,'2011-12-15'),(2490,'g',0,'2011-12-15'),(2374,'g',0,'2011-12-15'),(2468,'g',0,'2011-12-15'),(2333,'g',0,'2011-12-15'),(1894,'g',0,'2011-12-15'),(2499,'g',0,'2011-12-15'),(2319,'g',0,'2011-12-15'),(2550,'g',0,'2011-12-15'),(2368,'g',0,'2011-12-15'),(3518,'g',0,'2012-03-05'),(2467,'g',0,'2011-12-15'),(3420,'g',0,'2012-03-05'),(2966,'g',0,'2011-12-15'),(2391,'g',0,'2011-12-15'),(2346,'g',0,'2011-12-15'),(2827,'g',0,'2011-12-15'),(2793,'g',0,'2011-12-15'),(2595,'g',0,'2011-12-15'),(3095,'g',0,'2011-12-15'),(3335,'g',0,'2011-12-15'),(2632,'g',0,'2012-02-06'),(2704,'g',0,'2011-12-15'),(3015,'g',0,'2011-12-15'),(1960,'g',0,'2011-12-15'),(3534,'g',0,'2011-12-15'),(3354,'g',0,'2012-02-08'),(2825,'g',0,'2011-12-15'),(2831,'g',0,'2011-12-15'),(2898,'g',0,'2011-12-15'),(2897,'g',0,'2011-12-15'),(2828,'g',0,'2011-12-15'),(2792,'g',0,'2011-12-15'),(2737,'g',0,'2012-02-07'),(3022,'g',0,'2011-12-15'),(2619,'g',0,'2012-01-17'),(3281,'g',0,'2011-12-15'),(2432,'g',0,'2011-12-15'),(3089,'g',0,'2012-01-17'),(3088,'g',0,'2012-01-17'),(2311,'g',0,'2012-01-17'),(2329,'g',0,'2011-12-15'),(3091,'g',0,'2012-01-17'),(1900,'g',0,'2011-12-15'),(2410,'g',0,'2011-12-15'),(2976,'g',0,'2011-12-15'),(3251,'g',0,'2011-12-15'),(3254,'g',0,'2011-12-15'),(3252,'g',0,'2011-12-15'),(3102,'g',0,'2011-12-15'),(2723,'g',0,'2011-12-15'),(2631,'g',0,'2012-02-06'),(2755,'g',0,'2011-12-15'),(1953,'g',0,'2011-12-15'),(3126,'g',0,'2011-12-15'),(3594,'g',0,'2011-12-15'),(3352,'g',0,'2011-12-15'),(3407,'g',0,'2012-02-08'),(3415,'g',0,'2011-12-15'),(3411,'g',0,'2011-12-15'),(2835,'g',0,'2011-12-15'),(3414,'g',0,'2011-12-15'),(3093,'g',0,'2011-12-15'),(3535,'g',0,'2012-01-19'),(2901,'g',0,'2011-12-15'),(2806,'g',0,'2011-12-15'),(2794,'g',0,'2011-12-15'),(2872,'g',0,'2011-12-15'),(2750,'g',0,'2011-12-15'),(2906,'g',0,'2011-12-15'),(2744,'g',0,'2012-01-17'),(2519,'g',0,'2011-12-15'),(3087,'g',0,'2012-01-17'),(2372,'g',0,'2012-01-25'),(2473,'g',0,'2011-12-15'),(3092,'g',0,'2012-01-17'),(1940,'g',0,'2011-12-15'),(2355,'g',0,'2011-12-15'),(2516,'g',0,'2011-12-15'),(3517,'g',0,'2011-12-15'),(2587,'g',0,'2012-02-07'),(2522,'g',0,'2012-02-16'),(2484,'g',0,'2012-02-17'),(2749,'g',0,'2011-12-15'),(2696,'g',0,'2012-02-07'),(2747,'g',0,'2012-03-01'),(1895,'g',0,'2011-12-16'),(2843,'g',0,'2011-12-16'),(1901,'g',0,'2011-12-16'),(1873,'g',0,'2012-02-09'),(1898,'g',0,'2011-12-16'),(3634,'g',0,'2012-02-09'),(2941,'g',0,'2011-12-16'),(2370,'g',0,'2012-02-06'),(2735,'g',0,'2011-12-16'),(3193,'g',0,'2011-12-16'),(3255,'g',0,'2011-12-16'),(3304,'g',0,'2012-01-19'),(3567,'g',0,'2012-03-02'),(3502,'g',0,'2011-12-16'),(3409,'g',0,'2011-12-16'),(2866,'g',0,'2011-12-16'),(2885,'g',0,'2011-12-16'),(3284,'g',0,'2011-12-16'),(3633,'g',0,'2011-12-16'),(3628,'g',0,'2011-12-16'),(1893,'g',0,'2011-12-16'),(3082,'g',0,'2011-12-16'),(2844,'g',0,'2011-12-16'),(2612,'g',0,'2011-12-16'),(3032,'g',0,'2012-01-17'),(2296,'g',0,'2011-12-16'),(2435,'g',0,'2011-12-16'),(2928,'g',0,'2012-01-17'),(2653,'g',0,'2012-01-17'),(2672,'g',0,'2011-12-16'),(2606,'g',0,'2012-01-17'),(2543,'g',0,'2011-12-16'),(2498,'g',0,'2011-12-16'),(2974,'g',0,'2011-12-16'),(2973,'g',0,'2011-12-16'),(2963,'g',0,'2011-12-16'),(2769,'g',0,'2011-12-16'),(3124,'g',0,'2011-12-16'),(2789,'g',0,'2011-12-16'),(2770,'g',0,'2011-12-16'),(3225,'g',0,'2011-12-16'),(2768,'g',0,'2011-12-16'),(3127,'g',0,'2011-12-16'),(2553,'g',0,'2011-12-16'),(2630,'g',0,'2012-02-06'),(2633,'g',0,'2012-02-06'),(2739,'g',0,'2011-12-16'),(3253,'g',0,'2011-12-16'),(3016,'g',0,'2011-12-16'),(2741,'g',0,'2012-01-18'),(2900,'g',0,'2011-12-16'),(2763,'g',0,'2011-12-16'),(2923,'g',0,'2012-01-17'),(3268,'g',0,'2011-12-16'),(3369,'g',0,'2011-12-16'),(2014,'g',0,'2011-12-16'),(2781,'g',0,'2011-12-16'),(3197,'g',0,'2011-12-16'),(3212,'g',0,'2011-12-16'),(2314,'g',0,'2011-12-16'),(2290,'g',0,'2011-12-16'),(2318,'g',0,'2011-12-16'),(2774,'g',0,'2011-12-16'),(3123,'g',0,'2011-12-16'),(3128,'g',0,'2011-12-16'),(2766,'g',0,'2011-12-16'),(3084,'g',0,'2011-12-16'),(3192,'g',0,'2011-12-16'),(3327,'g',0,'2011-12-16'),(2871,'g',0,'2011-12-16'),(3370,'g',0,'2011-12-16'),(3295,'g',0,'2011-12-16'),(2773,'g',0,'2011-12-16'),(3371,'g',0,'2011-12-16'),(2699,'g',0,'2011-12-16'),(2701,'g',0,'2011-12-16'),(3078,'g',0,'2011-12-16'),(2635,'g',0,'2011-12-16'),(3269,'g',0,'2012-01-29'),(2855,'g',0,'2011-12-16'),(2857,'g',0,'2011-12-16'),(3213,'g',0,'2011-12-16'),(2294,'g',0,'2011-12-16'),(2492,'g',0,'2011-12-16'),(2316,'g',0,'2011-12-16'),(3516,'g',0,'2012-03-05'),(3524,'g',0,'2012-03-05'),(2377,'g',0,'2011-12-16'),(3067,'g',0,'2011-12-16'),(3050,'g',0,'2011-12-16'),(3389,'g',0,'2011-12-16'),(3122,'g',0,'2011-12-16'),(2819,'g',0,'2011-12-16'),(3119,'g',0,'2011-12-16'),(2317,'g',0,'2011-12-16'),(3641,'g',0,'2011-12-17'),(3009,'g',0,'2011-12-18'),(3120,'g',0,'2011-12-18'),(3118,'g',0,'2011-12-18'),(2772,'g',0,'2011-12-18'),(2783,'g',0,'2011-12-18'),(3643,'g',0,'2011-12-18'),(2788,'g',0,'2011-12-18'),(2764,'g',0,'2012-01-23'),(2320,'g',0,'2012-02-25'),(2393,'g',0,'2012-02-25'),(2688,'g',0,'2012-01-19'),(2842,'g',0,'2011-12-18'),(2305,'g',0,'2012-02-25'),(2182,'g',0,'2012-01-23'),(2091,'g',0,'2012-02-21'),(2031,'g',0,'2011-12-19'),(2030,'g',0,'2011-12-19'),(2033,'g',0,'2011-12-19'),(2025,'g',0,'2011-12-19'),(2023,'g',0,'2011-12-19'),(2032,'g',0,'2011-12-19'),(2029,'g',0,'2011-12-19'),(2027,'g',0,'2011-12-19'),(2024,'g',0,'2011-12-19'),(2028,'g',0,'2011-12-19'),(2007,'g',0,'2012-01-18'),(2367,'g',0,'2012-01-18'),(2585,'g',0,'2012-01-18'),(2166,'g',0,'2012-01-18'),(2303,'g',0,'2012-02-08'),(2446,'g',0,'2012-02-08'),(1964,'g',0,'2012-02-08'),(2144,'g',0,'2012-02-08'),(2135,'g',0,'2012-02-08'),(2338,'g',0,'2011-12-19'),(2044,'g',0,'2012-02-08'),(2154,'g',0,'2011-12-20'),(2501,'g',0,'2011-12-20'),(2152,'g',0,'2011-12-20'),(1996,'g',0,'2011-12-20'),(2359,'g',0,'2011-12-20'),(2341,'g',0,'2011-12-20'),(1902,'g',0,'2011-12-20'),(2386,'g',0,'2011-12-20'),(1984,'g',0,'2011-12-20'),(3650,'g',0,'2012-02-09'),(3647,'g',0,'2012-02-14'),(1928,'g',0,'2012-03-02'),(1977,'g',0,'2012-03-02'),(3648,'g',0,'2012-02-07'),(1891,'g',0,'2011-12-22'),(1884,'g',0,'2012-02-07'),(3632,'g',0,'2012-02-07'),(3655,'g',0,'2012-02-09'),(3673,'g',0,'2012-02-09'),(3676,'g',0,'2012-02-09'),(3669,'g',0,'2012-01-21'),(3675,'g',0,'2012-02-09'),(3636,'g',0,'2012-02-08'),(3689,'g',0,'2012-02-08'),(1930,'g',0,'2011-12-23'),(3678,'g',0,'2011-12-23'),(3656,'g',0,'2011-12-23'),(3666,'g',0,'2011-12-23'),(3683,'g',0,'2011-12-23'),(3646,'g',0,'2011-12-23'),(3649,'g',0,'2011-12-23'),(3637,'g',0,'2011-12-23'),(3664,'g',0,'2011-12-23'),(3674,'g',0,'2011-12-23'),(1945,'g',0,'2011-12-23'),(3677,'g',0,'2011-12-23'),(3679,'g',0,'2011-12-24'),(3640,'g',0,'2011-12-24'),(3660,'g',0,'2012-03-05'),(2812,'g',0,'2012-03-05'),(2648,'g',0,'2012-03-05'),(1938,'g',0,'2012-02-01'),(2908,'g',0,'2012-03-05'),(2658,'g',0,'2012-02-01'),(2149,'g',0,'2012-02-01'),(2920,'g',0,'2011-12-24'),(2664,'g',0,'2012-03-05'),(2881,'g',0,'2012-03-05'),(3622,'g',0,'2011-12-25'),(3662,'g',0,'2011-12-26'),(3657,'g',0,'2011-12-26'),(1871,'g',0,'2011-12-26'),(3667,'g',0,'2011-12-26'),(3463,'g',0,'2011-12-26'),(3681,'g',0,'2011-12-26'),(3665,'g',0,'2012-03-01'),(3639,'g',0,'2012-03-06'),(3686,'g',0,'2012-03-06'),(2985,'g',0,'2011-12-26'),(2990,'g',0,'2011-12-27'),(2984,'g',0,'2011-12-27'),(2989,'g',0,'2011-12-27'),(2995,'g',0,'2011-12-27'),(2994,'g',0,'2011-12-27'),(3004,'g',0,'2011-12-27'),(2993,'g',0,'2011-12-27'),(2996,'g',0,'2011-12-27'),(2986,'g',0,'2011-12-27'),(3688,'g',0,'2012-02-02'),(3680,'g',0,'2011-12-28'),(3693,'g',0,'2011-12-28'),(3663,'g',0,'2011-12-28'),(3652,'g',0,'2011-12-28'),(2004,'g',0,'2011-12-28'),(2015,'g',0,'2011-12-28'),(2017,'g',0,'2011-12-28'),(2020,'g',0,'2011-12-28'),(2011,'g',0,'2011-12-28'),(2022,'g',0,'2011-12-28'),(2018,'g',0,'2011-12-28'),(2021,'g',0,'2011-12-28'),(2094,'g',0,'2011-12-28'),(2016,'g',0,'2011-12-28'),(2019,'g',0,'2011-12-28'),(3394,'g',0,'2011-12-29'),(3397,'g',0,'2011-12-29'),(3393,'g',0,'2011-12-29'),(3436,'g',0,'2011-12-29'),(3617,'g',0,'2011-12-29'),(3328,'g',0,'2011-12-29'),(3395,'g',0,'2011-12-29'),(3399,'g',0,'2011-12-29'),(3398,'g',0,'2011-12-29'),(3324,'g',0,'2011-12-29'),(3699,'g',0,'2011-12-29'),(2528,'g',0,'2011-12-29'),(3692,'g',0,'2012-02-09'),(3685,'g',0,'2012-02-09'),(3697,'g',0,'2011-12-30'),(3715,'g',0,'2012-02-09'),(3704,'g',0,'2012-02-09'),(3698,'g',0,'2011-12-30'),(3714,'g',0,'2012-03-01'),(3710,'g',0,'2012-03-05'),(3705,'g',0,'2012-03-05'),(3709,'g',0,'2011-12-30'),(2037,'g',0,'2012-02-17'),(1935,'g',0,'2012-02-14'),(2111,'g',0,'2012-02-29'),(1952,'g',0,'2012-02-14'),(1934,'g',0,'2012-02-14'),(1932,'g',0,'2012-02-17'),(1937,'g',0,'2012-02-17'),(1885,'g',0,'2011-12-30'),(2466,'g',0,'2011-12-31'),(2687,'g',0,'2012-02-18'),(3659,'g',0,'2012-01-31'),(2390,'g',0,'2011-12-31'),(2349,'g',0,'2011-12-31'),(2462,'g',0,'2011-12-31'),(2357,'g',0,'2012-01-01'),(3722,'g',0,'2012-02-02'),(3586,'g',0,'2012-02-08'),(2572,'g',0,'2012-02-08'),(3604,'g',0,'2012-02-08'),(2511,'g',0,'2012-02-08'),(2604,'g',0,'2012-02-08'),(2418,'g',0,'2012-01-01'),(3695,'g',0,'2012-03-02'),(3682,'g',0,'2012-02-18'),(3721,'g',0,'2012-02-16'),(2970,'g',0,'2012-01-01'),(2814,'g',0,'2012-02-18'),(2471,'g',0,'2012-01-02'),(2680,'g',0,'2012-02-18'),(3302,'g',0,'2012-01-02'),(3279,'g',0,'2012-01-02'),(2934,'g',0,'2012-01-02'),(2933,'g',0,'2012-01-02'),(3079,'g',0,'2012-01-02'),(3747,'g',0,'2012-02-09'),(3734,'g',0,'2012-02-09'),(3739,'g',0,'2012-02-09'),(3717,'g',0,'2012-02-08'),(2969,'g',0,'2012-02-18'),(3273,'g',0,'2012-01-03'),(3543,'g',0,'2012-01-03'),(2328,'g',0,'2012-01-03'),(3729,'g',0,'2012-01-03'),(3745,'g',0,'2012-01-03'),(3728,'g',0,'2012-01-05'),(3731,'g',0,'2012-03-05'),(3755,'g',0,'2012-01-05'),(3752,'g',0,'2012-01-07'),(3748,'g',0,'2012-02-14'),(3758,'g',0,'2012-01-07'),(3751,'g',0,'2012-01-07'),(3740,'g',0,'2012-01-07'),(3742,'g',0,'2012-01-08'),(3744,'g',0,'2012-01-08'),(3737,'g',0,'2012-02-20'),(3736,'g',0,'2012-01-09'),(3743,'g',0,'2012-01-09'),(3724,'g',0,'2012-01-09'),(3730,'g',0,'2012-01-09'),(3718,'g',0,'2012-01-09'),(3783,'g',0,'2012-01-09'),(3778,'g',0,'2012-01-09'),(3769,'g',0,'2012-01-09'),(3770,'g',0,'2012-01-09'),(3762,'g',0,'2012-01-09'),(2950,'g',0,'2012-01-10'),(3767,'g',0,'2012-02-16'),(3738,'g',0,'2012-03-01'),(3741,'g',0,'2012-02-15'),(3293,'g',0,'2012-01-11'),(3209,'g',0,'2012-01-11'),(3753,'g',0,'2012-02-21'),(3299,'g',0,'2012-01-11'),(3282,'g',0,'2012-01-11'),(3289,'g',0,'2012-01-11'),(3288,'g',0,'2012-01-11'),(3766,'g',0,'2012-02-21'),(3795,'g',0,'2012-01-12'),(3786,'g',0,'2012-01-13'),(3763,'g',0,'2012-02-20'),(3776,'g',0,'2012-02-17'),(3716,'g',0,'2012-03-01'),(3784,'g',0,'2012-01-15'),(3782,'g',0,'2012-03-01'),(3802,'g',0,'2012-01-15'),(3764,'g',0,'2012-01-15'),(3785,'g',0,'2012-01-16'),(3800,'g',0,'2012-02-24'),(3775,'g',0,'2012-01-16'),(3759,'g',0,'2012-01-16'),(3765,'g',0,'2012-01-16'),(3788,'g',0,'2012-01-16'),(3777,'g',0,'2012-01-16'),(3733,'g',0,'2012-01-16'),(3757,'g',0,'2012-01-16'),(3760,'g',0,'2012-01-16'),(3750,'g',0,'2012-01-16'),(3720,'g',0,'2012-01-16'),(3661,'g',0,'2012-02-18'),(3821,'g',0,'2012-03-01'),(3819,'g',0,'2012-03-01'),(3822,'g',0,'2012-01-17'),(3820,'g',0,'2012-01-17'),(3810,'g',0,'2012-01-17'),(3813,'g',0,'2012-01-17'),(3732,'g',0,'2012-01-17'),(3702,'g',0,'2012-01-17'),(3703,'g',0,'2012-01-17'),(3713,'g',0,'2012-01-17'),(3780,'g',0,'2012-01-17'),(3824,'g',0,'2012-01-17'),(3774,'g',0,'2012-01-17'),(3844,'g',0,'2012-02-18'),(3828,'g',0,'2012-02-18'),(3658,'g',0,'2012-01-19'),(3841,'g',0,'2012-01-19'),(3794,'g',0,'2012-01-19'),(3804,'g',0,'2012-02-21'),(3833,'g',0,'2012-02-21'),(3793,'g',0,'2012-02-29'),(1963,'g',0,'2012-01-20'),(1967,'g',0,'2012-01-20'),(1961,'g',0,'2012-01-20'),(1959,'g',0,'2012-01-20'),(424,'g',0,'2012-02-21'),(425,'g',0,'2012-01-20'),(442,'g',0,'2012-02-21'),(1872,'g',0,'2012-01-20'),(1974,'g',0,'2012-01-20'),(2003,'g',0,'2012-01-20'),(3792,'g',0,'2012-01-20'),(3653,'g',0,'2012-01-20'),(2042,'g',0,'2012-01-20'),(1875,'g',0,'2012-01-20'),(3723,'g',0,'2012-01-20'),(2405,'g',0,'2012-01-20'),(465,'g',0,'2012-01-20'),(1990,'g',0,'2012-01-20'),(2409,'g',0,'2012-01-20'),(3843,'g',0,'2012-01-20'),(2417,'g',0,'2012-01-20'),(2006,'g',0,'2012-01-20'),(1998,'g',0,'2012-01-20'),(2401,'g',0,'2012-01-20'),(3823,'g',0,'2012-01-20'),(2072,'g',0,'2012-01-20'),(2419,'g',0,'2012-01-20'),(3711,'g',0,'2012-01-20'),(2406,'g',0,'2012-01-20'),(2039,'g',0,'2012-01-20'),(3712,'g',0,'2012-01-20'),(2411,'g',0,'2012-01-20'),(3825,'g',0,'2012-01-20'),(2403,'g',0,'2012-01-20'),(3781,'g',0,'2012-01-20'),(3805,'g',0,'2012-01-20'),(3836,'g',0,'2012-01-20'),(3754,'g',0,'2012-01-20'),(1999,'g',0,'2012-01-20'),(2416,'g',0,'2012-01-20'),(3726,'g',0,'2012-01-20'),(1982,'g',0,'2012-01-20'),(3799,'g',0,'2012-01-20'),(3725,'g',0,'2012-01-20'),(3812,'g',0,'2012-01-20'),(3694,'g',0,'2012-01-20'),(3749,'g',0,'2012-01-20'),(2415,'g',0,'2012-01-20'),(3651,'g',0,'2012-01-20'),(3635,'g',0,'2012-01-20'),(3670,'g',0,'2012-01-20'),(3638,'g',0,'2012-01-20'),(3829,'g',0,'2012-01-20'),(2339,'g',0,'2012-01-20'),(2344,'g',0,'2012-01-20'),(2395,'g',0,'2012-01-20'),(2400,'g',0,'2012-01-20'),(2337,'g',0,'2012-01-20'),(2315,'g',0,'2012-01-20'),(2351,'g',0,'2012-01-20'),(2300,'g',0,'2012-01-20'),(2397,'g',0,'2012-01-20'),(2133,'g',0,'2012-01-20'),(2073,'g',0,'2012-01-20'),(2292,'g',0,'2012-01-20'),(2352,'g',0,'2012-01-20'),(2080,'g',0,'2012-01-20'),(2282,'g',0,'2012-01-20'),(1880,'g',0,'2012-01-20'),(1933,'g',0,'2012-01-20'),(2297,'g',0,'2012-01-20'),(1957,'g',0,'2012-01-20'),(1944,'g',0,'2012-01-20'),(2283,'g',0,'2012-01-20'),(1943,'g',0,'2012-01-20'),(1942,'g',0,'2012-01-20'),(1899,'g',0,'2012-01-20'),(2427,'g',0,'2012-01-20'),(3849,'g',0,'2012-01-20'),(1879,'g',0,'2012-01-20'),(1881,'g',0,'2012-01-20'),(2358,'g',0,'2012-01-20'),(1882,'g',0,'2012-01-20'),(2449,'g',0,'2012-01-20'),(2431,'g',0,'2012-01-20'),(2454,'g',0,'2012-01-20'),(2456,'g',0,'2012-01-20'),(3787,'g',0,'2012-01-20'),(2076,'g',0,'2012-01-20'),(2453,'g',0,'2012-01-20'),(2276,'g',0,'2012-01-20'),(2424,'g',0,'2012-01-20'),(2438,'g',0,'2012-01-20'),(2421,'g',0,'2012-01-20'),(2434,'g',0,'2012-01-20'),(3607,'g',0,'2012-01-21'),(3845,'g',0,'2012-02-21'),(3357,'g',0,'2012-01-21'),(3339,'g',0,'2012-01-21'),(3249,'g',0,'2012-01-21'),(3278,'g',0,'2012-01-21'),(3374,'g',0,'2012-01-21'),(3276,'g',0,'2012-01-21'),(3830,'g',0,'2012-01-21'),(3290,'g',0,'2012-01-21'),(3277,'g',0,'2012-01-21'),(3353,'g',0,'2012-01-21'),(3329,'g',0,'2012-01-21'),(3817,'g',0,'2012-01-21'),(3814,'g',0,'2012-01-21'),(3560,'g',0,'2012-01-22'),(3542,'g',0,'2012-01-22'),(3540,'g',0,'2012-01-22'),(3541,'g',0,'2012-01-22'),(3599,'g',0,'2012-01-22'),(3533,'g',0,'2012-01-22'),(3511,'g',0,'2012-01-22'),(3539,'g',0,'2012-01-22'),(3410,'g',0,'2012-01-22'),(3336,'g',0,'2012-01-22'),(3383,'g',0,'2012-01-22'),(3492,'g',0,'2012-01-22'),(3380,'g',0,'2012-01-22'),(3367,'g',0,'2012-01-22'),(3381,'g',0,'2012-01-22'),(3309,'g',0,'2012-01-22'),(3384,'g',0,'2012-01-22'),(3382,'g',0,'2012-01-22'),(3806,'g',0,'2012-01-22'),(3556,'g',0,'2012-01-22'),(3596,'g',0,'2012-01-22'),(3591,'g',0,'2012-01-22'),(3419,'g',0,'2012-01-22'),(3550,'g',0,'2012-01-22'),(3791,'g',0,'2012-01-22'),(3424,'g',0,'2012-01-22'),(3803,'g',0,'2012-03-05'),(3848,'g',0,'2012-01-22'),(3835,'g',0,'2012-01-22'),(3842,'g',0,'2012-01-22'),(3834,'g',0,'2012-01-22'),(3797,'g',0,'2012-01-23'),(3798,'g',0,'2012-01-23'),(3858,'g',0,'2012-01-23'),(3773,'g',0,'2012-02-24'),(3869,'g',0,'2012-01-25'),(3870,'g',0,'2012-01-25'),(3862,'g',0,'2012-01-25'),(3876,'g',0,'2012-01-25'),(3818,'g',0,'2012-01-26'),(3816,'g',0,'2012-01-26'),(3831,'g',0,'2012-01-26'),(3875,'g',0,'2012-02-28'),(3856,'g',0,'2012-01-27'),(3872,'g',0,'2012-01-27'),(3867,'g',0,'2012-03-01'),(1924,'g',0,'2012-03-05'),(1916,'g',0,'2012-03-05'),(1921,'g',0,'2012-03-05'),(1922,'g',0,'2012-03-05'),(1918,'g',0,'2012-03-05'),(1923,'g',0,'2012-03-05'),(1915,'g',0,'2012-01-27'),(1920,'g',0,'2012-01-27'),(1917,'g',0,'2012-01-27'),(1919,'g',0,'2012-01-27'),(3832,'g',0,'2012-01-27'),(2302,'g',0,'2012-01-27'),(2285,'g',0,'2012-01-27'),(2301,'g',0,'2012-01-27'),(3859,'g',0,'2012-03-01'),(3840,'g',0,'2012-01-27'),(2147,'g',0,'2012-01-27'),(2148,'g',0,'2012-01-27'),(3850,'g',0,'2012-01-27'),(3863,'g',0,'2012-01-27'),(2137,'g',0,'2012-01-27'),(2117,'g',0,'2012-01-27'),(2131,'g',0,'2012-01-27'),(2340,'g',0,'2012-01-27'),(2141,'g',0,'2012-01-27'),(2139,'g',0,'2012-01-27'),(2087,'g',0,'2012-01-27'),(2161,'g',0,'2012-01-27'),(2304,'g',0,'2012-01-27'),(2150,'g',0,'2012-01-27'),(3851,'g',0,'2012-01-27'),(2130,'g',0,'2012-01-27'),(2163,'g',0,'2012-01-27'),(2122,'g',0,'2012-01-27'),(2291,'g',0,'2012-01-27'),(3885,'g',0,'2012-01-27'),(3880,'g',0,'2012-01-28'),(3882,'g',0,'2012-01-28'),(3879,'g',0,'2012-01-28'),(3827,'g',0,'2012-01-28'),(3878,'g',0,'2012-01-28'),(3883,'g',0,'2012-01-28'),(3884,'g',0,'2012-01-28'),(3873,'g',0,'2012-03-03'),(3864,'g',0,'2012-01-28'),(3847,'g',0,'2012-01-28'),(3623,'g',0,'2012-01-28'),(3881,'g',0,'2012-01-28'),(2278,'g',0,'2012-01-28'),(1926,'g',0,'2012-01-28'),(2134,'g',0,'2012-03-05'),(2115,'g',0,'2012-01-28'),(1925,'g',0,'2012-03-05'),(2287,'g',0,'2012-01-28'),(2101,'g',0,'2012-01-28'),(2202,'g',0,'2012-01-28'),(3796,'g',0,'2012-01-28'),(3768,'g',0,'2012-01-28'),(3887,'g',0,'2012-01-29'),(3779,'g',0,'2012-01-30'),(3771,'g',0,'2012-01-30'),(3913,'g',0,'2012-01-30'),(3903,'g',0,'2012-01-30'),(3900,'g',0,'2012-01-30'),(3898,'g',0,'2012-01-30'),(3888,'g',0,'2012-01-30'),(3772,'g',0,'2012-01-31'),(3846,'g',0,'2012-01-31'),(3839,'g',0,'2012-01-31'),(3815,'g',0,'2012-01-31'),(3877,'g',0,'2012-01-31'),(3811,'g',0,'2012-01-31'),(3826,'g',0,'2012-01-31'),(3911,'g',0,'2012-03-01'),(3904,'g',0,'2012-03-01'),(3893,'g',0,'2012-03-01'),(3897,'g',0,'2012-01-31'),(3909,'g',0,'2012-01-31'),(3914,'g',0,'2012-01-31'),(3906,'g',0,'2012-01-31'),(3895,'g',0,'2012-03-05'),(3890,'g',0,'2012-03-05'),(3910,'g',0,'2012-02-01'),(3891,'g',0,'2012-02-01'),(2532,'g',0,'2012-02-01'),(2913,'g',0,'2012-02-01'),(2531,'g',0,'2012-02-01'),(2856,'g',0,'2012-02-01'),(2751,'g',0,'2012-02-01'),(2878,'g',0,'2012-02-01'),(2887,'g',0,'2012-02-01'),(2798,'g',0,'2012-02-01'),(3083,'g',0,'2012-02-01'),(3243,'g',0,'2012-02-01'),(3003,'g',0,'2012-02-01'),(3111,'g',0,'2012-02-01'),(3021,'g',0,'2012-02-01'),(2883,'g',0,'2012-02-01'),(2929,'g',0,'2012-02-01'),(3905,'g',0,'2012-02-02'),(3915,'g',0,'2012-02-02'),(3855,'g',0,'2012-03-05'),(3595,'g',0,'2012-02-04'),(3536,'g',0,'2012-02-04'),(3525,'g',0,'2012-02-04'),(3908,'g',0,'2012-02-04'),(3916,'g',0,'2012-02-04'),(3907,'g',0,'2012-02-05'),(3918,'g',0,'2012-02-05'),(3902,'g',0,'2012-02-05'),(3919,'g',0,'2012-02-05'),(3928,'g',0,'2012-02-05'),(3923,'g',0,'2012-02-05'),(3912,'g',0,'2012-02-05'),(3892,'g',0,'2012-02-05'),(3472,'g',0,'2012-02-05'),(3489,'g',0,'2012-02-05'),(3513,'g',0,'2012-02-05'),(3514,'g',0,'2012-02-05'),(3562,'g',0,'2012-02-05'),(3574,'g',0,'2012-02-05'),(3687,'g',0,'2012-02-05'),(3573,'g',0,'2012-02-05'),(3488,'g',0,'2012-02-05'),(3487,'g',0,'2012-02-05'),(3497,'g',0,'2012-02-06'),(3442,'g',0,'2012-02-06'),(3344,'g',0,'2012-02-06'),(3501,'g',0,'2012-02-06'),(3440,'g',0,'2012-02-06'),(3924,'g',0,'2012-02-06'),(3927,'g',0,'2012-02-06'),(3403,'g',0,'2012-02-06'),(3346,'g',0,'2012-02-06'),(3446,'g',0,'2012-02-06'),(3359,'g',0,'2012-02-06'),(3438,'g',0,'2012-02-06'),(3362,'g',0,'2012-02-06'),(3449,'g',0,'2012-02-06'),(3337,'g',0,'2012-02-06'),(3391,'g',0,'2012-02-06'),(3361,'g',0,'2012-02-06'),(3451,'g',0,'2012-02-06'),(3404,'g',0,'2012-02-06'),(3504,'g',0,'2012-02-06'),(3363,'g',0,'2012-02-06'),(3345,'g',0,'2012-02-06'),(3439,'g',0,'2012-02-06'),(3441,'g',0,'2012-02-06'),(3450,'g',0,'2012-02-06'),(3347,'g',0,'2012-02-06'),(3402,'g',0,'2012-02-06'),(3342,'g',0,'2012-02-06'),(3444,'g',0,'2012-02-06'),(3401,'g',0,'2012-02-06'),(3360,'g',0,'2012-02-06'),(2439,'g',0,'2012-02-06'),(2640,'g',0,'2012-02-06'),(2170,'g',0,'2012-02-06'),(2325,'g',0,'2012-02-06'),(2552,'g',0,'2012-02-06'),(2286,'g',0,'2012-02-06'),(2479,'g',0,'2012-02-06'),(2414,'g',0,'2012-02-06'),(3207,'g',0,'2012-02-06'),(3206,'g',0,'2012-02-06'),(3248,'g',0,'2012-02-06'),(3507,'g',0,'2012-02-06'),(3215,'g',0,'2012-02-06'),(3428,'g',0,'2012-02-06'),(3433,'g',0,'2012-02-06'),(3075,'g',0,'2012-02-06'),(3671,'g',0,'2012-02-06'),(2389,'g',0,'2012-02-06'),(2651,'g',0,'2012-02-06'),(2312,'g',0,'2012-02-06'),(2485,'g',0,'2012-02-06'),(3368,'g',0,'2012-02-06'),(2288,'g',0,'2012-02-06'),(2404,'g',0,'2012-02-06'),(2624,'g',0,'2012-02-06'),(2455,'g',0,'2012-02-06'),(2451,'g',0,'2012-02-06'),(2371,'g',0,'2012-02-06'),(3343,'g',0,'2012-02-06'),(2586,'g',0,'2012-02-07'),(2618,'g',0,'2012-02-07'),(2457,'g',0,'2012-02-07'),(2829,'g',0,'2012-02-07'),(3226,'g',0,'2012-02-07'),(3112,'g',0,'2012-02-07'),(3229,'g',0,'2012-02-07'),(2833,'g',0,'2012-02-07'),(3230,'g',0,'2012-02-07'),(3227,'g',0,'2012-02-07'),(3146,'g',0,'2012-02-07'),(2494,'g',0,'2012-02-07'),(3231,'g',0,'2012-02-07'),(2620,'g',0,'2012-02-07'),(2509,'g',0,'2012-02-07'),(2440,'g',0,'2012-02-07'),(2198,'g',0,'2012-02-07'),(2481,'g',0,'2012-02-07'),(2379,'g',0,'2012-02-07'),(2643,'g',0,'2012-02-07'),(2177,'g',0,'2012-02-07'),(2882,'g',0,'2012-02-07'),(2567,'g',0,'2012-02-07'),(2724,'g',0,'2012-02-07'),(2861,'g',0,'2012-02-07'),(2907,'g',0,'2012-02-07'),(2784,'g',0,'2012-02-07'),(2914,'g',0,'2012-02-07'),(2873,'g',0,'2012-02-07'),(2348,'g',0,'2012-02-07'),(2673,'g',0,'2012-02-07'),(2864,'g',0,'2012-02-07'),(2791,'g',0,'2012-02-07'),(2679,'g',0,'2012-02-07'),(2862,'g',0,'2012-02-07'),(2684,'g',0,'2012-02-07'),(2767,'g',0,'2012-02-07'),(2891,'g',0,'2012-02-07'),(2848,'g',0,'2012-02-07'),(2867,'g',0,'2012-02-07'),(2695,'g',0,'2012-02-07'),(2846,'g',0,'2012-02-07'),(2683,'g',0,'2012-02-07'),(2809,'g',0,'2012-02-07'),(3621,'g',0,'2012-02-07'),(2678,'g',0,'2012-02-07'),(2805,'g',0,'2012-02-07'),(3063,'g',0,'2012-02-07'),(2903,'g',0,'2012-02-07'),(2870,'g',0,'2012-02-07'),(2945,'g',0,'2012-02-07'),(2800,'g',0,'2012-02-07'),(2865,'g',0,'2012-02-07'),(2804,'g',0,'2012-02-07'),(2733,'g',0,'2012-02-07'),(2702,'g',0,'2012-02-07'),(2849,'g',0,'2012-02-07'),(2728,'g',0,'2012-02-07'),(2820,'g',0,'2012-02-07'),(2771,'g',0,'2012-02-07'),(2979,'g',0,'2012-02-07'),(2669,'g',0,'2012-02-07'),(2795,'g',0,'2012-02-07'),(2786,'g',0,'2012-02-07'),(3294,'g',0,'2012-02-07'),(3307,'g',0,'2012-02-07'),(2729,'g',0,'2012-02-07'),(3943,'g',0,'2012-02-08'),(3940,'g',0,'2012-02-08'),(3922,'g',0,'2012-02-08'),(3917,'g',0,'2012-02-08'),(2038,'g',0,'2012-02-08'),(3949,'g',0,'2012-02-08'),(2665,'g',0,'2012-02-08'),(3069,'g',0,'2012-02-08'),(2736,'g',0,'2012-02-08'),(3270,'g',0,'2012-02-08'),(3170,'g',0,'2012-02-08'),(2823,'g',0,'2012-02-08'),(3247,'g',0,'2012-02-08'),(3264,'g',0,'2012-02-08'),(2889,'g',0,'2012-02-08'),(3271,'g',0,'2012-02-08'),(3246,'g',0,'2012-02-08'),(3169,'g',0,'2012-02-08'),(3272,'g',0,'2012-02-08'),(2757,'g',0,'2012-02-08'),(3176,'g',0,'2012-02-08'),(2850,'g',0,'2012-02-08'),(2662,'g',0,'2012-02-08'),(2876,'g',0,'2012-02-08'),(3077,'g',0,'2012-02-08'),(3162,'g',0,'2012-02-08'),(3168,'g',0,'2012-02-08'),(3261,'g',0,'2012-02-08'),(3166,'g',0,'2012-02-08'),(3160,'g',0,'2012-02-08'),(3155,'g',0,'2012-02-08'),(2663,'g',0,'2012-02-08'),(3163,'g',0,'2012-02-08'),(3117,'g',0,'2012-02-08'),(3164,'g',0,'2012-02-08'),(3070,'g',0,'2012-02-08'),(3950,'g',0,'2012-02-08'),(3955,'g',0,'2012-02-08'),(3938,'g',0,'2012-02-08'),(3930,'g',0,'2012-02-08'),(3951,'g',0,'2012-02-08'),(3929,'g',0,'2012-02-08'),(3789,'g',0,'2012-02-09'),(3946,'g',0,'2012-02-09'),(3937,'g',0,'2012-02-09'),(3936,'g',0,'2012-02-09'),(3935,'g',0,'2012-02-09'),(3690,'g',0,'2012-02-10'),(3559,'g',0,'2012-02-10'),(3668,'g',0,'2012-02-10'),(3569,'g',0,'2012-02-10'),(3426,'g',0,'2012-02-10'),(3700,'g',0,'2012-02-10'),(3486,'g',0,'2012-02-10'),(3691,'g',0,'2012-02-10'),(3618,'g',0,'2012-02-10'),(3672,'g',0,'2012-02-10'),(3684,'g',0,'2012-02-10'),(3558,'g',0,'2012-02-10'),(3620,'g',0,'2012-02-10'),(2977,'g',0,'2012-02-10'),(2980,'g',0,'2012-02-10'),(2978,'g',0,'2012-02-10'),(3948,'g',0,'2012-02-11'),(3954,'g',0,'2012-02-11'),(3933,'g',0,'2012-02-11'),(3934,'g',0,'2012-02-11'),(3966,'g',0,'2012-02-11'),(2058,'g',0,'2012-02-11'),(3707,'g',0,'2012-02-11'),(3645,'g',0,'2012-02-11'),(3654,'g',0,'2012-02-12'),(2350,'g',0,'2012-02-12'),(2053,'g',0,'2012-02-12'),(2052,'g',0,'2012-02-12'),(2057,'g',0,'2012-02-12'),(2054,'g',0,'2012-02-12'),(2937,'g',0,'2012-02-12'),(2917,'g',0,'2012-02-12'),(2915,'g',0,'2012-02-12'),(2904,'g',0,'2012-02-12'),(2948,'g',0,'2012-02-12'),(2943,'g',0,'2012-02-12'),(2902,'g',0,'2012-02-12'),(2936,'g',0,'2012-02-12'),(2931,'g',0,'2012-02-12'),(2946,'g',0,'2012-02-12'),(2905,'g',0,'2012-02-12'),(3947,'g',0,'2012-02-12'),(2962,'g',0,'2012-02-12'),(2930,'g',0,'2012-02-12'),(3588,'g',0,'2012-02-12'),(3852,'g',0,'2012-02-12'),(2785,'g',0,'2012-02-12'),(3952,'g',0,'2012-02-12'),(2810,'g',0,'2012-02-12'),(2964,'g',0,'2012-02-12'),(2518,'g',0,'2012-02-12'),(3474,'g',0,'2012-02-12'),(3031,'g',0,'2012-02-12'),(2775,'g',0,'2012-02-12'),(2967,'g',0,'2012-02-12'),(2776,'g',0,'2012-02-12'),(2884,'g',0,'2012-02-12'),(2880,'g',0,'2012-02-12'),(2987,'g',0,'2012-02-12'),(2720,'g',0,'2012-02-12'),(2046,'g',0,'2012-02-12'),(2045,'g',0,'2012-02-12'),(1993,'g',0,'2012-02-12'),(2049,'g',0,'2012-02-12'),(2001,'g',0,'2012-02-12'),(1992,'g',0,'2012-02-12'),(3956,'g',0,'2012-02-12'),(3967,'g',0,'2012-02-12'),(2059,'g',0,'2012-02-12'),(2034,'g',0,'2012-02-12'),(2035,'g',0,'2012-02-12'),(2050,'g',0,'2012-02-12'),(2051,'g',0,'2012-02-12'),(2047,'g',0,'2012-02-12'),(2040,'g',0,'2012-02-12'),(2048,'g',0,'2012-02-12'),(2545,'g',0,'2012-02-12'),(2488,'g',0,'2012-02-12'),(2675,'g',0,'2012-02-12'),(2622,'g',0,'2012-02-12'),(2549,'g',0,'2012-02-12'),(3318,'g',0,'2012-02-12'),(2718,'g',0,'2012-02-12'),(2649,'g',0,'2012-02-12'),(2554,'g',0,'2012-02-12'),(2063,'g',0,'2012-02-12'),(2070,'g',0,'2012-02-12'),(2060,'g',0,'2012-02-12'),(2075,'g',0,'2012-02-12'),(2068,'g',0,'2012-02-12'),(2065,'g',0,'2012-02-12'),(2067,'g',0,'2012-02-12'),(2079,'g',0,'2012-02-13'),(2062,'g',0,'2012-02-13'),(2074,'g',0,'2012-02-13'),(3961,'g',0,'2012-02-13'),(1978,'g',0,'2012-02-13'),(3960,'g',0,'2012-02-13'),(3008,'g',0,'2012-02-13'),(3099,'g',0,'2012-02-13'),(3006,'g',0,'2012-02-13'),(3115,'g',0,'2012-02-13'),(3114,'g',0,'2012-02-13'),(3007,'g',0,'2012-02-13'),(3113,'g',0,'2012-02-13'),(3963,'g',0,'2012-02-13'),(3969,'g',0,'2012-02-13'),(2487,'g',0,'2012-02-14'),(2510,'g',0,'2012-02-14'),(2521,'g',0,'2012-02-14'),(2517,'g',0,'2012-02-14'),(2496,'g',0,'2012-02-14'),(2491,'g',0,'2012-02-14'),(2477,'g',0,'2012-02-14'),(2483,'g',0,'2012-02-14'),(2544,'g',0,'2012-02-14'),(2546,'g',0,'2012-02-14'),(3964,'g',0,'2012-02-14'),(3965,'g',0,'2012-02-14'),(3974,'g',0,'2012-02-15'),(3970,'g',0,'2012-02-16'),(3983,'g',0,'2012-02-16'),(3953,'g',0,'2012-02-17'),(1907,'g',0,'2012-02-17'),(1906,'g',0,'2012-02-17'),(1908,'g',0,'2012-02-17'),(3942,'g',0,'2012-02-18'),(3926,'g',0,'2012-02-18'),(3896,'g',0,'2012-02-18'),(3982,'g',0,'2012-02-20'),(3528,'g',0,'2012-02-20'),(3470,'g',0,'2012-02-20'),(3579,'g',0,'2012-02-20'),(3592,'g',0,'2012-02-20'),(3973,'g',0,'2012-02-20'),(3476,'g',0,'2012-02-21'),(3576,'g',0,'2012-02-21'),(3997,'g',0,'2012-02-21'),(3466,'g',0,'2012-02-21'),(3606,'g',0,'2012-02-21'),(3464,'g',0,'2012-02-21'),(3467,'g',0,'2012-02-21'),(3577,'g',0,'2012-02-21'),(3465,'g',0,'2012-02-21'),(4001,'g',0,'2012-02-21'),(1988,'g',0,'2012-02-22'),(2005,'g',0,'2012-02-22'),(2000,'g',0,'2012-02-22'),(1903,'g',0,'2012-02-22'),(1904,'g',0,'2012-02-22'),(2008,'g',0,'2012-02-22'),(1905,'g',0,'2012-02-22'),(2012,'g',0,'2012-02-22'),(2036,'g',0,'2012-02-22'),(2082,'g',0,'2012-02-22'),(1951,'g',0,'2012-02-22'),(2083,'g',0,'2012-02-22'),(1890,'g',0,'2012-02-22'),(1969,'g',0,'2012-02-22'),(1983,'g',0,'2012-02-22'),(4002,'g',0,'2012-02-22'),(1911,'g',0,'2012-02-23'),(1910,'g',0,'2012-02-23'),(1913,'g',0,'2012-02-24'),(1909,'g',0,'2012-02-24'),(3894,'g',0,'2012-02-24'),(3899,'g',0,'2012-02-24'),(3901,'g',0,'2012-02-24'),(2949,'g',0,'2012-02-24'),(1912,'g',0,'2012-02-24'),(3701,'g',0,'2012-02-24'),(3932,'g',0,'2012-02-24'),(1914,'g',0,'2012-02-24'),(4000,'g',0,'2012-02-25'),(3988,'g',0,'2012-02-25'),(3990,'g',0,'2012-02-25'),(3999,'g',0,'2012-02-25'),(3998,'g',0,'2012-02-26'),(4022,'g',0,'2012-02-29'),(3984,'g',0,'2012-02-29'),(4021,'g',0,'2012-02-29'),(2112,'g',0,'2012-02-29'),(2189,'g',0,'2012-02-29'),(2192,'g',0,'2012-02-29'),(2195,'g',0,'2012-02-29'),(2412,'g',0,'2012-02-29'),(2560,'g',0,'2012-02-29'),(2594,'g',0,'2012-02-29'),(3994,'g',0,'2012-02-29'),(3957,'g',0,'2012-02-29'),(3995,'g',0,'2012-02-29'),(4026,'g',0,'2012-03-01'),(4019,'g',0,'2012-03-01'),(4018,'g',0,'2012-03-01'),(4015,'g',0,'2012-03-01'),(4008,'g',0,'2012-03-01'),(3987,'g',0,'2012-03-02'),(2089,'g',0,'2012-03-02'),(2555,'g',0,'2012-03-02'),(2621,'g',0,'2012-03-02'),(2625,'g',0,'2012-03-02'),(2608,'g',0,'2012-03-02'),(2627,'g',0,'2012-03-02'),(2579,'g',0,'2012-03-02'),(2559,'g',0,'2012-03-02'),(2588,'g',0,'2012-03-02'),(2568,'g',0,'2012-03-02'),(2583,'g',0,'2012-03-02'),(2582,'g',0,'2012-03-02'),(2581,'g',0,'2012-03-02'),(2584,'g',0,'2012-03-02'),(2504,'g',0,'2012-03-02'),(2458,'g',0,'2012-03-02'),(4012,'g',0,'2012-03-02'),(4017,'g',0,'2012-03-02'),(4016,'g',0,'2012-03-02'),(3448,'g',0,'2012-03-03'),(3491,'g',0,'2012-03-03'),(3601,'g',0,'2012-03-03'),(3469,'g',0,'2012-03-03'),(3571,'g',0,'2012-03-03'),(4029,'g',0,'2012-03-03'),(4028,'g',0,'2012-03-03'),(3490,'g',0,'2012-03-03'),(3544,'g',0,'2012-03-03'),(3413,'g',0,'2012-03-03'),(3386,'g',0,'2012-03-03'),(4023,'g',0,'2012-03-03'),(1971,'g',0,'2012-03-04'),(1989,'g',0,'2012-03-04'),(1987,'g',0,'2012-03-04'),(3624,'g',0,'2012-03-05'),(4030,'g',0,'2012-03-05'),(4039,'g',0,'2012-03-05'),(4042,'g',0,'2012-03-05'),(4036,'g',0,'2012-03-05'),(4034,'g',0,'2012-03-05'),(3976,'g',0,'2012-03-06'),(4061,'g',0,'2012-03-06');

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

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

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


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

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

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

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

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

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

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


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

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

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

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

--
-- Table structure for table `idx_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 ('Jefi5QwWiBs1mLnUuNMA6g','wcwqqKhvreM8jQErEWJIfZaBxDXv1gzsDxkLhQOs','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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `plugin_file` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` enum('0','1') COLLATE utf8_unicode_ci DEFAULT NULL,
  `option_plugin` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`plugin_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

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

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

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

INSERT INTO `idx_review` VALUES (1,3252,'This is an ongoing service (website SEO) but so far I have been very impressed. They have done everything that they said they would do. ',5,'2012-01-03','Review','1','','Shopper','roniethoma1@hotmail.com'),(2,3252,'Ebrandz gets results. They optimize your site and generate traffic. We have had better success with their deluxe plans. Minimal plans do not show the same results. Service reps are pretty responsive, but don\'t always full address our concerns. Language barrier exists. But for the money, they were the very best SEO we found. ',4,'2012-01-03','Review','1','','Shopper','gilroy.stevens@gmail.com');

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

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

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

INSERT INTO `idx_searchlog` VALUES ('Chrome Rims','2011-07-06 16:47:55',0,'203.92.47.195'),('www.bankruptcylawyer.com','2011-07-11 18:17:39',0,'203.92.47.195'),('compressor','2011-08-15 02:05:22',0,'41.193.82.154'),('hubcap-tire-wheel.com','2011-08-17 19:02:40',0,'203.92.47.195'),('J. Lorber Plumbing Supply','2011-08-23 06:25:42',0,'59.178.200.168'),('GADrugRehab.com','2011-11-08 00:35:16',0,'203.92.47.195'),('Star Chem-Dry','2011-11-17 06:11:01',0,'59.176.35.122'),('fhcevents.com','2011-11-22 05:55:23',1,'203.92.47.195'),('chaikinpowertools.com','2011-11-22 13:38:59',1,'120.60.6.237'),('24 hour emegency vet','2011-12-01 05:09:42',0,'203.92.47.195'),('skincancerlosangeles.com','2011-12-02 14:55:48',2,'203.92.47.195'),('eyelidplasticsurgerylosangeles.com','2011-12-02 15:59:22',2,'203.92.47.195'),('sinussurgerylosangeles.com','2011-12-02 16:34:28',2,'203.92.47.195'),('Hernialosangeles.com','2011-12-02 17:04:31',2,'203.92.47.195'),('netkidswear.com','2011-12-28 06:56:31',1,'203.92.47.195'),('GrowingStars.com','2012-02-21 04:50:10',1,'203.92.47.195');

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

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

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


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

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

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

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

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

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

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

INSERT INTO `idx_tags` VALUES ('commercial',0,39,'commercial'),('commercial',2,27,'commercial'),('property',0,64,'property'),('property',2,16,'property'),('real',0,2868,'real'),('real',2,22,'real'),('estate',0,2850,'estate'),('estate',2,22,'estate'),('holding',0,3,'holding'),('holding',2,2,'holding'),('company',0,5,'company'),('company',2,2,'company'),('developer',0,103,'developer'),('developer',2,2,'developer'),('manager',0,942,'manager'),('manager',2,2,'manager'),('hotel',0,29,'hotel'),('hotel',2,8,'hotel'),('management',0,56,'management'),('management',2,4,'management'),('motel',0,24,'motel'),('motel',2,7,'motel'),('operation',0,25,'operation'),('operation',2,9,'operation'),('nonresdentl',0,3,'nonresdentl'),('nonresdentl',2,3,'nonresdentl'),('bldg',0,8,'bldg'),('bldg',2,4,'bldg'),('operatr',0,3,'operatr'),('operatr',2,3,'operatr'),('drinking',0,2,'drinking'),('drinking',2,1,'drinking'),('nonresidential',0,109,'nonresidential'),('nonresidential',2,102,'nonresidential'),('building',0,424,'building'),('building',2,106,'building'),('operator',0,437,'operator'),('operator',2,118,'operator'),('non',0,2,'non'),('non',2,2,'non'),('residential',0,18,'residential'),('residential',2,3,'residential'),('mfg',0,4,'mfg'),('mfg',2,4,'mfg'),('rope',0,1,'rope'),('rope',2,1,'rope'),('and',0,23,'and'),('and',2,7,'and'),('twine',0,1,'twine'),('twine',2,1,'twine'),('business',0,11,'business'),('business',2,1,'business'),('services',0,23,'services'),('services',2,4,'services'),('secr',0,1,'secr'),('secr',2,1,'secr'),('eating',0,4,'eating'),('eating',2,3,'eating'),('place',0,4,'place'),('place',2,3,'place'),('legal',0,4,'legal'),('legal',2,3,'legal'),('ser',0,1,'ser'),('ser',2,1,'ser'),('membership',0,4,'membership'),('membership',2,1,'membership'),('sport',0,3,'sport'),('sport',2,1,'sport'),('recre',0,2,'recre'),('recre',2,1,'recre'),('measuring',0,1,'measuring'),('measuring',2,1,'measuring'),('controll',0,1,'controll'),('controll',2,1,'controll'),('agent',0,969,'agent'),('agent',2,9,'agent'),('mana',0,8,'mana'),('mana',2,8,'mana'),('religious',0,1,'religious'),('religious',2,1,'religious'),('organization',0,2,'organization'),('organization',2,1,'organization'),('ret',0,15,'ret'),('ret',2,6,'ret'),('alcoholic',0,1,'alcoholic'),('alcoholic',2,1,'alcoholic'),('beverage',0,1,'beverage'),('beverage',2,1,'beverage'),('skilled',0,4,'skilled'),('skilled',2,1,'skilled'),('nursing',0,6,'nursing'),('nursing',2,1,'nursing'),('care',0,15,'care'),('care',2,1,'care'),('operators',0,25,'operators'),('operators',2,10,'operators'),('metal',0,1,'metal'),('metal',2,1,'metal'),('stampi',0,1,'stampi'),('stampi',2,1,'stampi'),('owner',0,16,'owner'),('owner',2,9,'owner'),('owner-operator',0,3,'owner-operator'),('owner-operator',2,2,'owner-operator'),('arena',0,1,'arena'),('arena',2,1,'arena'),('civic',0,1,'civic'),('civic',2,1,'civic'),('center',0,17,'center'),('center',2,11,'center'),('subdividers',0,3,'subdividers'),('subdividers',2,1,'subdividers'),('self',0,1,'self'),('self',2,1,'self'),('storage',0,1,'storage'),('storage',2,1,'storage'),('supplies',0,1,'supplies'),('supplies',2,1,'supplies'),('labor',0,1,'labor'),('labor',2,1,'labor'),('force',0,1,'force'),('force',2,1,'force'),('handcrafts',0,1,'handcrafts'),('handcrafts',2,1,'handcrafts'),('for',0,8,'for'),('for',2,2,'for'),('artists',0,1,'artists'),('artists',2,1,'artists'),('bank',0,1,'bank'),('bank',2,1,'bank'),('builder',0,4,'builder'),('builder',2,1,'builder'),('operates',0,17,'operates'),('operates',2,3,'operates'),('apartment',0,386,'apartment'),('apartment',2,3,'apartment'),('complex',0,42,'complex'),('complex',2,1,'complex'),('contractor',0,4,'contractor'),('contractor',2,2,'contractor'),('insurance',0,6,'insurance'),('insurance',2,1,'insurance'),('lessors',0,3,'lessors'),('lessors',2,1,'lessors'),('buildings',0,313,'buildings'),('buildings',2,305,'buildings'),('dwelling',0,2,'dwelling'),('dwelling',2,1,'dwelling'),('water',0,2,'water'),('water',2,1,'water'),('transp',0,1,'transp'),('transp',2,1,'transp'),('used',0,8,'used'),('used',2,4,'used'),('automobiles',0,5,'automobiles'),('automobiles',2,1,'automobiles'),('general',0,2,'general'),('general',2,2,'general'),('maintenance',0,1,'maintenance'),('maintenance',2,1,'maintenance'),('executive',0,91,'executive'),('executive',2,91,'executive'),('office',0,301,'office'),('office',2,300,'office'),('laminated',0,1,'laminated'),('laminated',2,1,'laminated'),('plastic',0,1,'plastic'),('plastic',2,1,'plastic'),('merchandise',0,5,'merchandise'),('merchandise',2,3,'merchandise'),('subdivider',0,70,'subdivider'),('subdivider',2,1,'subdivider'),('open-end',0,1,'open-end'),('open-end',2,1,'open-end'),('managment',0,2,'managment'),('managment',2,1,'managment'),('investment',0,3,'investment'),('investment',2,1,'investment'),('industrial',0,3,'industrial'),('industrial',2,1,'industrial'),('retai',0,1,'retai'),('retai',2,1,'retai'),('own',0,2,'own'),('own',2,1,'own'),('shopping',0,443,'shopping'),('shopping',2,443,'shopping'),('mall',0,3,'mall'),('mall',2,2,'mall'),('rental',0,8,'rental'),('rental',2,1,'rental'),('auto',0,1,'auto'),('auto',2,1,'auto'),('body',0,1,'body'),('body',2,1,'body'),('shops',0,1,'shops'),('shops',2,1,'shops'),('agenc',0,1,'agenc'),('agenc',2,1,'agenc'),('owners',0,4,'owners'),('owners',2,2,'owners'),('school',0,1,'school'),('school',2,1,'school'),('educational',0,1,'educational'),('educational',2,1,'educational'),('centers',0,434,'centers'),('centers',2,433,'centers'),('malls',0,432,'malls'),('malls',2,432,'malls'),('leases',0,1,'leases'),('leases',2,1,'leases'),('market',0,1,'market'),('market',2,1,'market'),('stands',0,1,'stands'),('stands',2,1,'stands'),('from',0,1,'from'),('from',2,1,'from'),('site',0,2,'site'),('site',2,1,'site'),('amusement',0,3,'amusement'),('amusement',2,1,'amusement'),('recreation',0,3,'recreation'),('recreation',2,1,'recreation'),('nrsdntl',0,1,'nrsdntl'),('nrsdntl',2,1,'nrsdntl'),('optrs',0,1,'optrs'),('optrs',2,1,'optrs'),('parks',0,296,'parks'),('parks',2,295,'parks'),('manger',0,1,'manger'),('manger',2,1,'manger'),('rents',0,1,'rents'),('rents',2,1,'rents'),('space',0,1,'space'),('space',2,1,'space'),('antique',0,1,'antique'),('antique',2,1,'antique'),('dealers',0,1,'dealers'),('dealers',2,1,'dealers'),('only',0,2,'only'),('only',2,2,'only'),('entertainment',0,1,'entertainment'),('entertainment',2,1,'entertainment'),('facility',0,9,'facility'),('facility',2,1,'facility'),('suites',0,90,'suites'),('suites',2,90,'suites'),('music',0,1,'music'),('music',2,1,'music'),('auditorium',0,1,'auditorium'),('auditorium',2,1,'auditorium'),('bowling',0,1,'bowling'),('bowling',2,1,'bowling'),('theatrical',0,1,'theatrical'),('theatrical',2,1,'theatrical'),('producers',0,1,'producers'),('producers',2,1,'producers'),('performing',0,1,'performing'),('performing',2,1,'performing'),('arts',0,1,'arts'),('arts',2,1,'arts'),('developers',0,1819,'developers'),('developers',2,2,'developers'),('adult',0,1,'adult'),('adult',3,1,'adult'),('congregate',0,2,'congregate'),('congregate',3,1,'congregate'),('living',0,11,'living'),('living',3,11,'living'),('facility',3,8,'facility'),('apartment',3,375,'apartment'),('building',3,310,'building'),('complex',3,38,'complex'),('management',3,13,'management'),('managers',0,5,'managers'),('managers',3,3,'managers'),('operation',3,11,'operation'),('operator',3,309,'operator'),('eating',3,1,'eating'),('place',3,1,'place'),('hotel',3,13,'hotel'),('motel',3,9,'motel'),('membership',3,1,'membership'),('organization',3,1,'organization'),('nonresidential',3,5,'nonresidential'),('ope',0,6,'ope'),('ope',3,6,'ope'),('real',3,19,'real'),('estate',3,19,'estate'),('agent',3,14,'agent'),('manager',3,16,'manager'),('skilled',3,3,'skilled'),('nursing',3,5,'nursing'),('care',3,13,'care'),('facili',0,3,'facili'),('facili',3,3,'facili'),('specialty',0,1,'specialty'),('specialty',3,1,'specialty'),('hospital',0,1,'hospital'),('hospital',3,1,'hospital'),('operators',3,15,'operators'),('nsk',0,1,'nsk'),('nsk',3,1,'nsk'),('buildings',3,8,'buildings'),('community',0,8,'community'),('community',3,7,'community'),('complexes',0,2,'complexes'),('complexes',3,2,'complexes'),('company',3,2,'company'),('owner',3,6,'owner'),('owners',3,2,'owners'),('rental',3,6,'rental'),('apartment-hotel',0,1,'apartment-hotel'),('apartment-hotel',3,1,'apartment-hotel'),('apartments',0,3042,'apartments'),('apartments',3,3042,'apartments'),('apartmetn',0,1,'apartmetn'),('apartmetn',3,1,'apartmetn'),('apmnt',0,3,'apmnt'),('apmnt',3,3,'apmnt'),('bldg',3,4,'bldg'),('oprtrs',0,3,'oprtrs'),('oprtrs',3,3,'oprtrs'),('apt',0,5,'apt'),('apt',3,4,'apt'),('automobile',0,1,'automobile'),('automobile',3,1,'automobile'),('parking',0,1,'parking'),('parking',3,1,'parking'),('physical',0,2,'physical'),('physical',3,1,'physical'),('fitness',0,2,'fitness'),('fitness',3,1,'fitness'),('faclty',0,2,'faclty'),('faclty',3,1,'faclty'),('mot',0,1,'mot'),('mot',3,1,'mot'),('assisted',0,9,'assisted'),('assisted',3,9,'assisted'),('for',3,4,'for'),('the',0,1,'the'),('the',3,1,'the'),('elderly',0,3,'elderly'),('elderly',3,3,'elderly'),('holding',3,1,'holding'),('operates',3,8,'operates'),('operative',0,1,'operative'),('operative',3,1,'operative'),('builder',3,1,'builder'),('and',3,5,'and'),('center',3,6,'center'),('commercial',3,3,'commercial'),('structures',0,1,'structures'),('structures',3,1,'structures'),('owned',0,1,'owned'),('owned',3,1,'owned'),('manage',0,2,'manage'),('manage',3,1,'manage'),('centers',3,1,'centers'),('owner-operator',3,1,'owner-operator'),('boat',0,1,'boat'),('boat',3,1,'boat'),('slip',0,1,'slip'),('slip',3,1,'slip'),('leasin',0,1,'leasin'),('leasin',3,1,'leasin'),('owns',0,4,'owns'),('owns',3,3,'owns'),('residential',3,8,'residential'),('commerc',0,1,'commerc'),('commerc',3,1,'commerc'),('property',3,6,'property'),('broker',0,8,'broker'),('broker',3,1,'broker'),('mortgage',0,4,'mortgage'),('mortgage',3,1,'mortgage'),('investor',0,4,'investor'),('investor',3,1,'investor'),('rent',0,1,'rent'),('rent',3,1,'rent'),('apts',0,1,'apts'),('apts',3,1,'apts'),('agents',0,14,'agents'),('agents',3,1,'agents'),('retirement',0,23,'retirement'),('retirement',3,22,'retirement'),('home',0,7,'home'),('home',3,5,'home'),('senior',0,3,'senior'),('senior',3,3,'senior'),('citizen',0,1,'citizen'),('citizen',3,1,'citizen'),('residence',0,2,'residence'),('residence',3,2,'residence'),('housing',0,4,'housing'),('housing',3,4,'housing'),('student',0,1,'student'),('student',3,1,'student'),('condominiums',0,489,'condominiums'),('condominiums',3,489,'condominiums'),('boarding',0,11,'boarding'),('boarding',3,10,'boarding'),('houses',0,10,'houses'),('houses',3,10,'houses'),('agencies',0,4,'agencies'),('agencies',3,4,'agencies'),('hotels',0,6,'hotels'),('hotels',3,6,'hotels'),('intermediate',0,5,'intermediate'),('intermediate',3,5,'intermediate'),('personal',0,2,'personal'),('personal',3,1,'personal'),('resid',0,1,'resid'),('resid',3,1,'resid'),('services',3,3,'services'),('subdivider',3,1,'subdivider'),('developer',3,2,'developer'),('construction',0,4,'construction'),('construction',3,1,'construction'),('ret',3,1,'ret'),('furn',0,1,'furn'),('furn',3,1,'furn'),('life',0,1,'life'),('life',3,1,'life'),('non-profit',0,2,'non-profit'),('non-profit',3,1,'non-profit'),('low',0,1,'low'),('low',3,1,'low'),('income',0,1,'income'),('income',3,1,'income'),('own',3,1,'own'),('account',0,1,'account'),('account',3,1,'account'),('except',0,1,'except'),('except',3,1,'except'),('ski',0,1,'ski'),('ski',3,1,'ski'),('independent',0,1,'independent'),('independent',3,1,'independent'),('commercial',4,1,'commercial'),('property',4,31,'property'),('lessor',0,18,'lessor'),('lessor',4,17,'lessor'),('lessors',4,2,'lessors'),('real',4,18,'real'),('management',4,11,'management'),('rental',4,1,'rental'),('estate',4,4,'estate'),('freight',0,1,'freight'),('freight',4,1,'freight'),('transportation',0,1,'transportation'),('transportation',4,1,'transportation'),('arrangement',0,1,'arrangement'),('arrangement',4,1,'arrangement'),('agent',4,3,'agent'),('manager',4,3,'manager'),('ret',4,2,'ret'),('new',0,2,'new'),('new',4,1,'new'),('used',4,2,'used'),('automobiles',4,2,'automobiles'),('passenger',0,1,'passenger'),('passenger',4,1,'passenger'),('oil',0,14,'oil'),('oil',4,14,'oil'),('properties',0,4,'properties'),('properties',4,4,'properties'),('managers',4,1,'managers'),('apartment',5,8,'apartment'),('building',5,6,'building'),('operator',5,7,'operator'),('complex',5,3,'complex'),('management',5,23,'management'),('apt',5,1,'apt'),('managment',5,1,'managment'),('commercial',5,2,'commercial'),('real',5,997,'real'),('estate',5,996,'estate'),('agent',5,931,'agent'),('manager',5,911,'manager'),('condominium',0,1,'condominium'),('condominium',5,1,'condominium'),('property',5,6,'property'),('dentist',0,1,'dentist'),('dentist',5,1,'dentist'),('ice',0,1,'ice'),('ice',5,1,'ice'),('rink',0,1,'rink'),('rink',5,1,'rink'),('investor',5,1,'investor'),('mail',0,1,'mail'),('mail',5,1,'mail'),('order',0,1,'order'),('order',5,1,'order'),('motel',5,5,'motel'),('operates',5,4,'operates'),('agency',0,38,'agency'),('agency',5,38,'agency'),('mortgage',5,3,'mortgage'),('broker',5,6,'broker'),('managemen',0,1,'managemen'),('managemen',5,1,'managemen'),('insurance',5,4,'insurance'),('managers',5,1,'managers'),('training',0,1,'training'),('training',5,1,'training'),('schoo',0,1,'schoo'),('schoo',5,1,'schoo'),('manage',5,1,'manage'),('accounting',0,1,'accounting'),('accounting',5,1,'accounting'),('auditing',0,1,'auditing'),('auditing',5,1,'auditing'),('bookkeepi',0,1,'bookkeepi'),('bookkeepi',5,1,'bookkeepi'),('amusement',5,1,'amusement'),('recreation',5,2,'recreation'),('services',5,14,'services'),('animal',0,1,'animal'),('animal',5,1,'animal'),('appraiser',0,1,'appraiser'),('appraiser',5,1,'appraiser'),('and',5,1,'and'),('liquidator',0,1,'liquidator'),('liquidator',5,1,'liquidator'),('business',5,10,'business'),('depository',0,1,'depository'),('depository',5,1,'depository'),('banking',0,1,'banking'),('banking',5,1,'banking'),('dwelling',5,1,'dwelling'),('hotel',5,4,'hotel'),('operation',5,4,'operation'),('legal',5,1,'legal'),('office',5,1,'office'),('managem',0,1,'managem'),('managem',5,1,'managem'),('loan',0,2,'loan'),('loan',5,2,'loan'),('consulting',0,19,'consulting'),('consulting',5,18,'consulting'),('service',0,18,'service'),('service',5,18,'service'),('membership',5,1,'membership'),('sport',5,1,'sport'),('misc',0,4,'misc'),('misc',5,4,'misc'),('personal',5,1,'personal'),('mobile',0,50,'mobile'),('mobile',5,1,'mobile'),('home',5,1,'home'),('site',5,1,'site'),('banker',0,1,'banker'),('banker',5,1,'banker'),('correspondent',0,1,'correspondent'),('correspondent',5,1,'correspondent'),('mortgages',0,1,'mortgages'),('mortgages',5,1,'mortgages'),('nonresidential',5,1,'nonresidential'),('opera',0,1,'opera'),('opera',5,1,'opera'),('investment',5,1,'investment'),('trust',0,1,'trust'),('trust',5,1,'trust'),('lessor',5,1,'lessor'),('ret',5,5,'ret'),('merchandise',5,2,'merchandise'),('new',5,1,'new'),('used',5,2,'used'),('automobiles',5,2,'automobiles'),('rooming',0,1,'rooming'),('rooming',5,1,'rooming'),('boarding',5,1,'boarding'),('house',0,3,'house'),('house',5,3,'house'),('single-family',0,2,'single-family'),('single-family',5,2,'single-family'),('construct',0,2,'construct'),('construct',5,2,'construct'),('subdivider',5,5,'subdivider'),('developer',5,5,'developer'),('whol',0,1,'whol'),('whol',5,1,'whol'),('furniture',0,1,'furniture'),('furniture',5,1,'furniture'),('mgr',0,5,'mgr'),('mgr',5,2,'mgr'),('mercha',0,1,'mercha'),('mercha',5,1,'mercha'),('drinking',5,1,'drinking'),('agents',5,13,'agents'),('commecial',0,1,'commecial'),('commecial',7,1,'commecial'),('building',7,2,'building'),('contractor',7,2,'contractor'),('for',7,2,'for'),('lease',0,1,'lease'),('lease',7,1,'lease'),('sale',0,1,'sale'),('sale',7,1,'sale'),('commercial',7,6,'commercial'),('real',7,1812,'real'),('estate',7,1809,'estate'),('operator',7,3,'operator'),('developer',7,94,'developer'),('homeowners',0,1,'homeowners'),('homeowners',7,1,'homeowners'),('association',0,1,'association'),('association',7,1,'association'),('land',0,55,'land'),('land',7,55,'land'),('developers',7,1817,'developers'),('mall',7,1,'mall'),('mechanical',0,1,'mechanical'),('mechanical',7,1,'mechanical'),('and',7,10,'and'),('fire',0,1,'fire'),('fire',7,1,'fire'),('protection',0,1,'protection'),('protection',7,1,'protection'),('contractors',0,1,'contractors'),('contractors',7,1,'contractors'),('operates',7,2,'operates'),('subdivider',7,63,'subdivider'),('owns',7,1,'owns'),('manages',0,1,'manages'),('manages',7,1,'manages'),('congregate',7,1,'congregate'),('care',7,1,'care'),('facilities',0,1,'facilities'),('facilities',7,1,'facilities'),('property',7,5,'property'),('development',0,12,'development'),('development',7,12,'development'),('developement',0,1,'developement'),('developement',7,1,'developement'),('management',7,5,'management'),('hotel',7,4,'hotel'),('brokerage',0,1,'brokerage'),('brokerage',7,1,'brokerage'),('firm',0,1,'firm'),('firm',7,1,'firm'),('broker',7,1,'broker'),('golf',0,4,'golf'),('golf',7,4,'golf'),('course',0,4,'course'),('course',7,4,'course'),('restaurant',0,1,'restaurant'),('restaurant',7,1,'restaurant'),('leasing',0,1,'leasing'),('leasing',7,1,'leasing'),('owner',7,1,'owner'),('company',7,1,'company'),('retirement',7,1,'retirement'),('also',0,1,'also'),('also',7,1,'also'),('low-income',0,1,'low-income'),('low-income',7,1,'low-income'),('hou',0,1,'hou'),('hou',7,1,'hou'),('self-administered',0,1,'self-administered'),('self-administered',7,1,'self-administered'),('self-managed',0,1,'self-managed'),('self-managed',7,1,'self-managed'),('investment',7,1,'investment'),('motel',7,3,'motel'),('operation',7,1,'operation'),('services',7,2,'services'),('membership',7,1,'membership'),('sports',0,1,'sports'),('sports',7,1,'sports'),('club',0,2,'club'),('club',7,2,'club'),('ret',7,1,'ret'),('sport',7,1,'sport'),('physical',7,1,'physical'),('fitness',7,1,'fitness'),('faclty',7,1,'faclty'),('estat',0,1,'estat'),('estat',7,1,'estat'),('public',0,3,'public'),('public',7,3,'public'),('amusement',7,1,'amusement'),('recre',7,1,'recre'),('trailer',0,1,'trailer'),('trailer',7,1,'trailer'),('park',0,1,'park'),('park',7,1,'park'),('agent',7,12,'agent'),('manager',7,10,'manager'),('surety',0,1,'surety'),('surety',7,1,'surety'),('insurance',7,1,'insurance'),('carrier',0,1,'carrier'),('carrier',7,1,'carrier'),('esta',0,1,'esta'),('esta',7,1,'esta'),('companies',0,46,'companies'),('companies',7,46,'companies'),('mobile',7,49,'mobile'),('homes-park',0,48,'homes-park'),('homes-park',7,48,'homes-park'),('management-commercial',0,1,'management-commercial'),('management-commercial',7,1,'management-commercial'),('residential',7,7,'residential'),('community',7,1,'community'),('industrial',7,2,'industrial'),('builder',7,2,'builder'),('sales',0,1,'sales'),('sales',7,1,'sales'),('homes',0,1,'homes'),('homes',7,1,'homes'),('home',7,1,'home'),('parks',7,1,'parks'),('subdividers',7,2,'subdividers'),('non-profit',7,1,'non-profit'),('lender',0,1,'lender'),('lender',7,1,'lender'),('operate',0,1,'operate'),('operate',7,1,'operate'),('comm',0,1,'comm'),('comm',7,1,'comm'),('mngr',0,1,'mngr'),('mngr',7,1,'mngr'),('construction',7,3,'construction'),('investor',7,2,'investor'),('mgr',7,3,'mgr'),('rea',0,1,'rea'),('rea',7,1,'rea'),('consulting',7,1,'consulting'),('nonresidential',7,1,'nonresidential'),('mgm',0,1,'mgm'),('mgm',7,1,'mgm'),('single-famil',0,1,'single-famil'),('single-famil',7,1,'single-famil'),('water',7,1,'water'),('sewer',0,1,'sewer'),('sewer',7,1,'sewer'),('utility',0,1,'utility'),('utility',7,1,'utility'),('yacht',0,1,'yacht'),('yacht',7,1,'yacht');

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

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

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


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

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

--
-- 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` tinyint(4) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `idx_votes` VALUES (90,'203.92.47.195',5);


