(1810,15,'Best Sports Supplements','http://6degreenutrition.com','6 Degree Nutrition is the leading online source to buy nutritional supplements for athletes, sports energy drinks, drinks with electrolytes, sports energy drink, best sports supplements etc. Buy online now!','Joe Hupp','joehupp@huppmarketing.com',0,0,0.00,'2012-03-02 13:21:04',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'nutritional supplements for athletes, sports energy drinks, drinks with electrolytes, sports energy drink, best sports supplements, nutritional supplements for athlete,  best sports supplement',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1811,18,'lawn irrigation kalamazoo','http://www.watermygrass.com','Sanderson & Dehaan, a reputed lawn and underground\nsprinkler contractor in areas of Kalamazoo, Battle Creek, plainwell,\nand Portage. Contact us for free estimates.','Yellow Book','stuart@ebrandz.com',0,0,0.00,'2012-03-03 17:09:57',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'irrigation portage, lawn irrigation kalamazoo, irrigation kalamazoo',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1812,18,'Insurance Claims Specialists Alexandria MN','http://www.pdmidwest.com','Paul Davis Restoration & Remodeling offers complete residential and commercial construction, remodeling and repair services in Detroit Lakes MN. Call us at (218) 847-1800.','Ian Ulrich','ian.ulrich@onlineproz.com',0,0,0.00,'2012-03-04 17:28:14',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'home remodeling detroit lakes mn, construction and remodeling services detroit lakes mn, cabinetry detroit lakes mn, flooring detroit lakes mn, kitchen bathroom addition remodeling  alexandria mn, kitchen bathroom addition remodeling detroit lakes mn',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1813,22,'Austin DWI Lawyer','http://www.austincriminaldefenseattorney.com','Austin Criminal Defense Attorney Richard Jones represents clients against a wide variety of criminal charges, ranging from DWI charges to drug possession. He is an affordable and case winning criminal & DWI attorney that has helped Austin residents for almost two decades.','Richard Jones','info@austincriminaldefenseattorney.com',0,0,0.00,'2012-03-03 06:18:43',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'austin criminal attorney, austin dwi lawyer, austin defense attorney, austin texas criminal lawyer, austin criminal defense attorney, austin criminal defense lawyer, austin dui attorney, austin dui lawyer',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1814,13,'Property Management Accounting Software','http://www.tenantfile.com','Whether you manage single family homes, commercial property, or mobile home parks, the Tenant File is right for you. The Tenant File is the best property management software for the price, and is great for landlords, owners or managers of any type of rental property.','Paul Toller','sales@tenantfile.com',0,0,0.00,'2012-03-03 06:40:53',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'property management software, rental management software, property rental management software, property manager software, residential property software, landlord management software, commercial property management software, rental accounting software',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1815,22,'Tax Return Atlanta','http://www.pecklc.com/PracticeAreas/Unfiled-Returns.asp','The Peck Group, LC, is a tax and debt resolution law firm represents businesses and individuals who are involved in tax disputes and those who wish to avoid tax problems. Call us at 770-884-6914!','Yellow Book','stuart@ebrandz.com',0,0,0.00,'2012-03-03 16:26:09',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'pecklc, peck-lc, tax-lien-atlanta, tax-attorney-atlanta, tax-relief-atlanta, tax-services-atlanta, tax-problems-atlanta, tax-resolution-atlanta, tax-lawyer-atlanta, tax-return-atlanta, tax-audit-attorney-atlanta, tax-audit-lawyer-atlanta',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1816,22,'Tax Return Atlanta','http://www.pecklc.com/PracticeAreas/Unfiled-Returns.asp','The Peck Group, LC, is a tax and debt resolution law firm represents businesses and individuals who are involved in tax disputes and those who wish to avoid tax problems. Call us at 770-884-6914!','Yellow Book','stuart@ebrandz.com',0,0,0.00,'2012-03-03 16:26:56',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'pecklc, peck-lc, tax-lien-atlanta, tax-attorney-atlanta, tax-relief-atlanta, tax-services-atlanta, tax-problems-atlanta, tax-resolution-atlanta, tax-lawyer-atlanta, tax-return-atlanta, tax-audit-attorney-atlanta, tax-audit-lawyer-atlanta',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1817,8,'Pool Repair Arlington','http://www.hartsellpools.com','Hartsell Pool Renovations provide services from basic pool repair and pool resurfacing to pool redesign to full reconstruction that suits your taste and budget in Arlington, Bedford, Grapevine, TX .  Call us today at 817-485-7525 for your free consultation.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-03 17:18:29',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'hartsellpools.com, pool-repair-arlington,-tx, pool-renovations-arlington,-tx, pool-remodeling-arlington,-tx, pool-repair-grapevine,-tx, pool-renovations-grapevine,-tx, pool-remodeling-grapevine,-tx, ',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1818,6,'Business Internet Service Columbus','http://digital.smithville.net','Smithville® Digital Inc. provides digital services including video conferencing, business internet & telephone service, video conference room, business television system, data, networking with complete flexibility in Bloomington & Columbus, Indiana (IN). Call us at (812) 876-2211for more details.','Yellow Book','stuart@ebrandz.com',0,0,0.00,'2012-03-04 14:44:47',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'business internet service columbus, business telephone service columbus, video conference columbus, video conference room bloomington, video conference room columbus, video conferencing bloomington, video conferencing columbus',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1819,22,'Bankruptcy Lawyer Los Angeles','http://www.michaelpoolelaw.com','The Law Offices of Attorney Michael Poole is well known law firm in Los Angeles for providing legal solutions for chapter 7 and 13 bankruptcy cases to their clients. Contact to schedule an appointment with our experienced attorneys.','Yellow Book','stuart@ebrandz.com',0,0,0.00,'2012-03-04 18:26:20',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chapter 7 Los Angeles, Chapter 13 Los Angeles, Bankruptcy Attorney Los Angeles, Bankruptcy Lawyer Los Angeles, Los Angeles Bankruptcy Attorney',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1820,1,'Video Content Delivery Network','http://www.worldcastinc.com','Worldcast\'s video content delivery network supports full communication between you and your client throughout the entire event. You can also interact with patrons through social media outlets.','simon peterson','1simonpeterson1@gmail.com',0,0,0.00,'2012-03-03 11:55:05',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'video-content-delivery-network',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1821,22,'Pregnant and Need Help Oklahoma','http://www.robertborenlawoffice.com','Robert Boren Law Office in Oklahoma City offers mothers-to-be the option of placing their child up for adoption and parents seeking a child to adopt. Mr. Boren is dedicated to help each party with the adoption process or the surrogacy process. For unwanted pregnancy or if you are  pregnant and need help, Call 405-607-8304 today.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-05 14:08:06',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'adoption oklahoma, adoptions in oklahoma, adoption oklahoma city, oklahoma adopt, adoption agencies in oklahoma, adopting in oklahoma, oklahoma adoption agency, unwanted pregnancy oklahoma, pregnant and need help oklahoma, place child for adoption ok',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1822,2,'Used Truck Parts Minneapolis','http://www.jellisonsauto.com','Jellisons Auto Parts has been providing used cars and auto parts to the repair professional in Minneapolis, St. Paul and surrounding areas. Here you will always find the best car parts and great customer service. Call 763-434-6944 for immediate service.','Yellow Book','stuart@ebrandz.com',0,0,0.00,'2012-03-05 05:42:20',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'used auto parts st paul, cash for junk cars st paul, used truck parts st paul, used car parts st paul, auto parts minneapolis, used auto parts minneapolis, cash for junk cars minneapolis, used truck parts minneapolis',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1823,31,'CPVC Fittings','http://www.pvcfittingsdirect.com','PVC Fittings Direct - your ultimate shopping destination for PVC furniture fittings, PVC glue, schedule 40, pipe cutter, CPVC Fittings and other irrigation system supplies.','Audra Hajj','audra@flashecom.net',0,0,0.00,'2012-03-05 12:55:55',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'pvc-fittings, pvc-plumbing-fittings, pvc-furniture-fittings, pvc-schedule-40, pvc-schedule-80, pvc-nipples, pvc-caps, pvc-couplings, pvc-plugs, repair-pvc-pipe, cpvc-fittings, pvc-pipe-fittings, pvc-pipe-and-fittings, pvc-glue, pvc-elbows, pvc-pipe-cutter',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1824,6,'Sky Shoreham','http://www.grantsaerialserviceltd.co.uk','Since 1975, Grant\'s Aerial Service Ltd provides professional digital, TV aerial, sky and satellite installation services in Shoreham & Worthing, UK. Call us at 01273 594626 for more information.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-05 15:49:02',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'aerials shoreham, digital shoreham, sky shoreham, aerials worthing, digital worthing, sky worthing',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1825,18,'Windows Hertfordshire','http://www.bridgewaterglass.co.uk','Established in 1946, Bridgewater Glass offers window glazing, architectural glazing, custom mirrors and decorative glass in Hemel Hempstead, Hertfordshire, UK. Call us at 01923 608 976 for more details.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-05 16:13:48',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'glass hemel hempstead, glazing hemel hempstead, windows hemel hempstead, glass hertfordshire, glazing hertfordshire, windows hertfordshire, bridgewater glass',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1826,18,'Turf Doncaster','http://www.a1turfsupplies.co.uk','A1 Turf Supplies offers a vast range of high quality lawn turf, topsoil and land preparation services to the domestic gardens, public parks and football pitches at competitive prices in Sheffield & Doncaster, UK. Call us at 0114 243 2647 for more details.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-05 16:19:03',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'lawn turf sheffield, turf sheffield, turf supplies sheffield, lawn turf doncaster, turf doncaster, turf supplies doncaster',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1827,18,'Drains Middlesex','http://www.1stcalldrainsvcs.co.uk','1st Call Drain Clearance offers efficient and reliable drain cleaning services for blocked and flooded drains at competitive price in Middlesex, London. Call 0800 731 3236 for a free quote today.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-05 16:23:37',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'drains london, blocked drains london, drain cleaning london, drains middlesex, blocked drains middlesex, drain cleaning middlesex',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1828,18,'Septic Tanks Horsham','http://www.flowritedrainageltd.co.uk','Flowrite Drainage Services Ltd offers professional drainage systems, and are the authorised installers of septic tanks and Klargester across Horsham & Crawley, West Sussex, UK. Contact us on 01403 332 227 for a free quote.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-05 16:27:16',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'septic tanks horsham, drainage horsham, klargester horsham, septic tanks crawley, drainage crawley, klargester crawley',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1829,3,'Grab Hire Surrey','http://www.aj-marshall.co.uk','A. J. Marshall has been serving Surrey & Middlesex, UK with fast and reliable waste disposal services since 1956. For demolition services, grab hire or plant hire in Surrey, UK, call 01932 229 507 today.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-05 16:38:40',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'grab hire surrey, demolition surrey, plant hire surrey, grab hire middlesex, demolition middlesex, plant hire middlesex',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1830,33,'Valet','http://www.centraltexasvalet.com','Central Texas Valet provides highest level of professional parking solutions throughout Austin and San Antonio. We are committed to meeting the intense valet demands for Hotels, Hospitals, Commercial Buildings, Restaurants, Night Clubs, Studio’s and Special Events throughout Texas.','Corey Evers','info@centraltexasvalet.com',0,0,0.00,'2012-03-04 22:30:01',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'austin parking, austin texas parking, austin valet, parking austin, san antonio parking, valet austin, valet parking austin, valet san antonio',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1831,20,'Texas Group Health Insurance','http://www.texashealthandlife.com','At Texas Health & Life, we offer the most affordable life and health insurance for individual, family and group. Get free insurance quotes and apply online for health insurance and medical supplement plans at the best price.','Justin Lawhorn','info@texashealthandlife.com',0,0,0.00,'2012-03-05 00:10:38',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'austin health insurance, dallas health insurance, houston health insurance, life insurance texas, san antonio health insurance, texas group health insurance, texas health insurance quotes, texas medicare supplement',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1832,8,'Decorative Concrete Oklahoma City','http://www.billscustomconcrete.com','Bill?s Custom Concrete Inc. specializes in Home Improvement concrete services, concrete repair and yard drainage solutions for residential and commercial customers in Oklahoma City. Contact us @ 405-755-3975 for an experienced concrete, driveway and drainage contractor.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-05 01:33:18',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'concrete oklahoma city, concrete floor oklahoma city, concrete stain oklahoma city, concrete stamping oklahoma city, decorative concrete oklahoma city,  concrete wall oklahoma city, concrete repair oklahoma city, french drain oklahoma city',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1833,22,'Birth Injury Lawyer Pennsylvania','http://www.rosenbaumandassociates.com','The Philadelphia Injury Lawyers at Rosenbaum & Associates are dedicated to helping personal injury victims throughout Pennsylvania. Our skilled personal injury lawyers helps victim in wide variety of personal injury cases including auto/car accidents, construction accidents, birth injury, slip and fall and much more.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-05 02:58:56',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'accident lawyer philadelphia, personal injury lawyer philadelphia, car accident lawyer philadelphia, construction accident attorney philadelphia, birth injury lawyer philadelphia, slip and fall lawyer pennsylvania, birth injury lawyer pennsylvania',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1834,15,'Surrogate Mothers California','http://www.creatingfamilies.com','Center For Surrogate Parenting, Inc. is a world-renowned surrogate parenting program located in California and Maryland. Having a child with the help of a surrogate mother can be an exciting and fulfilling way to create your family. Find or become a surrogate mother the right way with CSP.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-05 03:23:37',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'surrogate mother california, surrogacy california, surrogate california,  become a surrogate california, find a surrogate california, surrogate mother cost california, be a surrogate california, surrogate mothers california',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1835,22,'Divorce Attorney DeKalb IL','http://attorneyamandatadams.com','From divorce and criminal law services to bankruptcy and collections issues, our aggressive attorney will listen to your needs, and provide legal representation and mediation solutions to help you through the difficult times. With two convenient offices in DeKalb and West Dundee, IL, we are just a phone call away from providing a FREE consultation to you.','Yellow Book','stuart@ebrandz.com',0,0,0.00,'2012-03-05 16:56:10',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bankruptcy lawyer west dundee il, divorce attorney west dundee il, criminal lawyer west dundee il, bankruptcy lawyer dekalb il, divorce attorney dekalb il, criminal lawyer dekalb il',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1836,22,'Foreclosure Attorney Chicago','http://www.chicagodebtsolutions.com','The Bankruptcy Law office of Chicago Debt Solutions in Chicago handle all cases involved with a Chapter 7 or Chapter 13 bankruptcy filing. We take a personalized approach to your bankruptcy case. For more information on our bankruptcy services call us @ 312-445-9106.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-05 03:50:24',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bankruptcy chicago, bankruptcy lawyer chicago, bankruptcy attorney chicago, chapter 13 bankruptcy chicago, chapter 7 bankruptcy chicago, file bankruptcy chicago, bankruptcy help chicago, foreclosure attorney chicago',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `idx_pagerank` VALUES (1,'g',0,'2011-11-12'),(2,'g',0,'2012-02-12'),(6,'g',0,'2012-02-12'),(22,'g',0,'2012-02-12'),(90,'g',0,'2012-02-12'),(34,'g',0,'2012-02-12'),(55,'g',0,'2012-02-12'),(33,'g',0,'2012-02-12'),(85,'g',0,'2012-02-12'),(47,'g',0,'2012-02-12'),(38,'g',0,'2012-02-12'),(385,'g',0,'2012-03-01'),(242,'g',0,'2011-11-15'),(97,'g',0,'2012-02-08'),(93,'g',0,'2012-02-08'),(77,'g',0,'2012-02-08'),(94,'g',0,'2012-02-08'),(49,'g',0,'2012-02-08'),(45,'g',0,'2011-11-17'),(291,'g',0,'2012-02-08'),(118,'g',0,'2012-02-08'),(142,'g',0,'2012-02-08'),(274,'g',0,'2012-02-08'),(114,'g',0,'2012-03-06'),(287,'g',0,'2012-02-02'),(262,'g',0,'2012-03-06'),(108,'g',0,'2012-02-08'),(106,'g',0,'2012-02-02'),(191,'g',0,'2012-02-08'),(102,'g',0,'2012-02-08'),(104,'g',0,'2012-03-06'),(88,'g',0,'2012-02-08'),(30,'g',0,'2012-02-08'),(62,'g',0,'2012-02-08'),(52,'g',0,'2012-02-08'),(236,'g',0,'2012-02-08'),(368,'g',0,'2012-02-08'),(153,'g',0,'2012-02-08'),(362,'g',0,'2012-02-08'),(375,'g',0,'2012-02-08'),(238,'g',0,'2012-03-01'),(247,'g',0,'2012-02-08'),(113,'g',0,'2012-02-08'),(367,'g',0,'2012-02-08'),(68,'g',0,'2012-02-08'),(70,'g',0,'2012-02-08'),(263,'g',0,'2012-02-08'),(164,'g',0,'2012-02-08'),(110,'g',0,'2012-02-08'),(213,'g',0,'2011-12-30'),(340,'g',0,'2012-02-08'),(324,'g',0,'2012-02-08'),(13,'g',0,'2012-02-08'),(268,'g',0,'2012-02-08'),(103,'g',0,'2012-02-08'),(41,'g',0,'2012-02-08'),(111,'g',0,'2012-02-08'),(140,'g',0,'2012-02-08'),(31,'g',0,'2012-02-08'),(32,'g',0,'2012-02-08'),(51,'g',0,'2012-02-08'),(50,'g',0,'2012-02-08'),(66,'g',0,'2012-02-08'),(14,'g',0,'2012-02-08'),(24,'g',0,'2012-02-08'),(26,'g',0,'2012-02-08'),(23,'g',0,'2012-02-08'),(44,'g',0,'2012-03-01'),(16,'g',0,'2012-02-08'),(8,'g',0,'2012-02-08'),(25,'g',0,'2012-02-08'),(64,'g',0,'2012-02-08'),(272,'g',0,'2012-02-08'),(209,'g',0,'2012-02-08'),(256,'g',0,'2012-02-08'),(9,'g',0,'2012-02-08'),(12,'g',0,'2012-02-08'),(251,'g',0,'2012-02-08'),(345,'g',0,'2012-02-08'),(339,'g',0,'2012-02-08'),(351,'g',0,'2012-02-08'),(226,'g',0,'2012-02-08'),(221,'g',0,'2012-02-08'),(195,'g',0,'2012-02-08'),(199,'g',0,'2012-02-08'),(20,'g',0,'2012-02-08'),(202,'g',0,'2012-02-08'),(21,'g',0,'2012-02-08'),(214,'g',0,'2012-02-08'),(234,'g',0,'2012-02-08'),(246,'g',0,'2012-02-08'),(48,'g',0,'2012-02-08'),(5,'g',0,'2012-03-01'),(53,'g',0,'2012-02-08'),(57,'g',0,'2012-02-08'),(61,'g',0,'2012-02-08'),(54,'g',0,'2012-02-08'),(63,'g',0,'2012-02-08'),(65,'g',0,'2012-02-08'),(72,'g',0,'2012-02-08'),(73,'g',0,'2012-02-08'),(75,'g',0,'2012-02-08'),(80,'g',0,'2012-02-08'),(89,'g',0,'2012-02-08'),(99,'g',0,'2012-02-08'),(298,'g',0,'2012-03-01'),(264,'g',0,'2012-03-01'),(292,'g',0,'2012-02-17'),(297,'g',0,'2012-02-08'),(3,'g',0,'2012-02-08'),(299,'g',0,'2012-02-17'),(315,'g',0,'2012-02-08'),(323,'g',0,'2012-02-08'),(325,'g',0,'2012-02-08'),(333,'g',0,'2012-02-08'),(336,'g',0,'2012-02-08'),(366,'g',0,'2012-02-08'),(380,'g',0,'2012-02-08'),(29,'g',0,'2012-02-08'),(28,'g',0,'2012-02-08'),(255,'g',0,'2012-02-08'),(352,'g',0,'2012-02-08'),(335,'g',0,'2012-02-08'),(43,'g',0,'2012-02-08'),(259,'g',0,'2012-02-08'),(135,'g',0,'2012-02-08'),(370,'g',0,'2012-02-08'),(46,'g',0,'2012-02-17'),(465,'g',0,'2012-03-01'),(175,'g',0,'2012-02-17'),(510,'g',0,'2011-11-28'),(125,'g',0,'2012-02-17'),(628,'g',0,'2012-02-08'),(558,'g',0,'2012-03-01'),(523,'g',0,'2012-03-01'),(522,'g',0,'2012-03-01'),(222,'g',0,'2012-01-19'),(139,'g',0,'2012-02-08'),(120,'g',0,'2012-02-08'),(119,'g',0,'2012-02-08'),(137,'g',0,'2012-02-08'),(162,'g',0,'2012-02-08'),(100,'g',0,'2012-02-08'),(144,'g',0,'2012-02-08'),(482,'g',0,'2012-03-01'),(348,'g',0,'2012-03-01'),(128,'g',0,'2012-02-17'),(121,'g',0,'2012-02-08'),(245,'g',0,'2012-02-08'),(557,'g',0,'2012-02-08'),(591,'g',0,'2012-02-08'),(74,'g',0,'2012-02-08'),(453,'g',0,'2012-02-08'),(133,'g',0,'2012-02-08'),(237,'g',0,'2012-02-08'),(220,'g',0,'2012-02-08'),(249,'g',0,'2012-02-08'),(177,'g',0,'2012-02-08'),(553,'g',0,'2012-02-08'),(10,'g',0,'2012-02-08'),(107,'g',0,'2011-11-30'),(109,'g',0,'2012-02-08'),(155,'g',0,'2012-02-08'),(86,'g',0,'2012-03-01'),(92,'g',0,'2012-02-08'),(260,'g',0,'2012-03-01'),(344,'g',0,'2012-03-01'),(572,'g',0,'2012-03-01'),(454,'g',0,'2012-03-01'),(82,'g',0,'2012-03-01'),(42,'g',0,'2011-11-30'),(116,'g',0,'2012-03-01'),(117,'g',0,'2012-03-01'),(17,'g',0,'2012-03-01'),(11,'g',0,'2011-12-01'),(27,'g',0,'2012-03-01'),(18,'g',0,'2012-02-08'),(36,'g',0,'2012-02-08'),(126,'g',0,'2012-02-08'),(168,'g',0,'2012-02-08'),(159,'g',0,'2012-02-08'),(172,'g',0,'2012-02-08'),(171,'g',0,'2012-02-08'),(130,'g',0,'2012-02-08'),(35,'g',0,'2011-12-01'),(56,'g',0,'2012-03-01'),(59,'g',0,'2012-03-01'),(76,'g',0,'2012-03-01'),(78,'g',0,'2012-03-01'),(79,'g',0,'2012-03-01'),(58,'g',0,'2012-03-01'),(81,'g',0,'2012-03-01'),(37,'g',0,'2012-03-01'),(15,'g',0,'2012-02-08'),(556,'g',0,'2012-02-08'),(160,'g',0,'2012-02-08'),(598,'g',0,'2012-02-08'),(511,'g',0,'2012-03-06'),(520,'g',0,'2012-03-06'),(396,'g',0,'2012-02-08'),(39,'g',0,'2012-02-08'),(198,'g',0,'2012-02-08'),(317,'g',0,'2012-02-08'),(363,'g',0,'2012-02-08'),(178,'g',0,'2012-02-08'),(156,'g',0,'2012-02-08'),(312,'g',0,'2012-02-08'),(371,'g',0,'2012-02-08'),(112,'g',0,'2012-02-08'),(124,'g',0,'2012-02-08'),(40,'g',0,'2012-01-11'),(726,'g',0,'2011-12-02'),(129,'g',0,'2012-02-08'),(486,'g',0,'2012-02-08'),(152,'g',0,'2012-02-08'),(472,'g',0,'2012-02-08'),(7,'g',0,'2012-02-08'),(540,'g',0,'2012-02-08'),(174,'g',0,'2012-02-08'),(507,'g',0,'2012-02-08'),(662,'g',0,'2012-02-08'),(627,'g',0,'2012-01-02'),(1011,'g',0,'2012-02-08'),(1059,'g',0,'2012-02-08'),(91,'g',0,'2011-12-12'),(95,'g',0,'2011-12-12'),(197,'g',0,'2011-12-12'),(136,'g',0,'2011-12-12'),(167,'g',0,'2011-12-12'),(127,'g',0,'2011-12-12'),(180,'g',0,'2011-12-12'),(101,'g',0,'2011-12-12'),(169,'g',0,'2011-12-12'),(321,'g',0,'2011-12-12'),(326,'g',0,'2011-12-12'),(270,'g',0,'2011-12-12'),(329,'g',0,'2011-12-12'),(316,'g',0,'2011-12-12'),(276,'g',0,'2011-12-12'),(290,'g',0,'2011-12-12'),(293,'g',0,'2011-12-12'),(313,'g',0,'2011-12-12'),(372,'g',0,'2011-12-12'),(355,'g',0,'2011-12-12'),(416,'g',0,'2011-12-12'),(364,'g',0,'2011-12-12'),(418,'g',0,'2011-12-12'),(417,'g',0,'2011-12-12'),(373,'g',0,'2011-12-12'),(342,'g',0,'2011-12-12'),(476,'g',0,'2012-03-01'),(821,'g',0,'2012-03-01'),(210,'g',0,'2011-12-16'),(207,'g',0,'2011-12-16'),(224,'g',0,'2011-12-16'),(223,'g',0,'2011-12-16'),(183,'g',0,'2011-12-16'),(206,'g',0,'2011-12-16'),(173,'g',0,'2011-12-16'),(653,'g',0,'2012-02-08'),(205,'g',0,'2011-12-16'),(818,'g',0,'2012-03-01'),(1020,'g',0,'2012-03-06'),(1061,'g',0,'2012-02-08'),(506,'g',0,'2011-12-20'),(190,'g',0,'2011-12-20'),(462,'g',0,'2011-12-20'),(377,'g',0,'2011-12-20'),(384,'g',0,'2011-12-20'),(487,'g',0,'2011-12-20'),(378,'g',0,'2011-12-20'),(383,'g',0,'2011-12-20'),(376,'g',0,'2011-12-20'),(386,'g',0,'2011-12-20'),(526,'g',0,'2011-12-20'),(382,'g',0,'2011-12-20'),(456,'g',0,'2012-02-08'),(391,'g',0,'2012-02-08'),(392,'g',0,'2012-02-08'),(631,'g',0,'2012-03-01'),(306,'g',0,'2012-02-08'),(350,'g',0,'2012-02-08'),(273,'g',0,'2012-02-08'),(301,'g',0,'2012-02-08'),(379,'g',0,'2012-02-08'),(303,'g',0,'2012-02-08'),(131,'g',0,'2012-02-08'),(820,'g',0,'2012-02-08'),(1219,'g',0,'2012-02-08'),(1111,'g',0,'2012-02-08'),(83,'g',0,'2012-03-01'),(84,'g',0,'2012-03-01'),(71,'g',0,'2012-03-01'),(69,'g',0,'2012-03-01'),(67,'g',0,'2012-03-01'),(115,'g',0,'2012-03-01'),(138,'g',0,'2011-12-23'),(122,'g',0,'2012-03-01'),(105,'g',0,'2012-03-01'),(134,'g',0,'2012-03-01'),(794,'g',0,'2012-02-08'),(629,'g',0,'2012-02-08'),(442,'g',0,'2011-12-23'),(439,'g',0,'2012-02-08'),(440,'g',0,'2012-02-08'),(438,'g',0,'2012-02-08'),(441,'g',0,'2012-02-08'),(1198,'g',0,'2012-02-08'),(1106,'g',0,'2012-02-08'),(776,'g',0,'2012-02-08'),(1087,'g',0,'2012-02-08'),(1088,'g',0,'2012-02-08'),(1090,'g',0,'2012-02-08'),(1089,'g',0,'2012-02-08'),(296,'g',0,'2012-02-08'),(1185,'g',0,'2012-02-08'),(1221,'g',0,'2012-02-08'),(60,'g',0,'2012-02-08'),(468,'g',0,'2012-02-08'),(884,'g',0,'2012-02-08'),(864,'g',0,'2012-02-08'),(1168,'g',0,'2012-02-08'),(1016,'g',0,'2012-02-08'),(1166,'g',0,'2012-02-08'),(1164,'g',0,'2012-02-08'),(1208,'g',0,'2012-02-08'),(427,'g',0,'2012-01-09'),(600,'g',0,'2012-01-09'),(549,'g',0,'2012-01-09'),(570,'g',0,'2012-01-09'),(534,'g',0,'2012-01-09'),(599,'g',0,'2012-01-09'),(311,'g',0,'2012-01-09'),(698,'g',0,'2012-01-09'),(626,'g',0,'2012-01-09'),(967,'g',0,'2012-01-09'),(548,'g',0,'2012-03-01'),(579,'g',0,'2012-01-10'),(772,'g',0,'2012-01-10'),(496,'g',0,'2012-02-22'),(574,'g',0,'2012-01-10'),(381,'g',0,'2012-02-22'),(992,'g',0,'2012-01-10'),(1027,'g',0,'2012-01-10'),(1012,'g',0,'2012-01-10'),(1091,'g',0,'2012-01-10'),(1097,'g',0,'2012-01-10'),(19,'g',0,'2012-02-22'),(1406,'g',0,'2012-02-17'),(404,'g',0,'2012-01-17'),(401,'g',0,'2012-01-17'),(400,'g',0,'2012-01-17'),(403,'g',0,'2012-01-17'),(402,'g',0,'2012-01-17'),(405,'g',0,'2012-01-17'),(407,'g',0,'2012-01-17'),(305,'g',0,'2012-01-17'),(310,'g',0,'2012-01-17'),(285,'g',0,'2012-01-17'),(343,'g',0,'2012-01-17'),(282,'g',0,'2012-01-17'),(307,'g',0,'2012-01-17'),(365,'g',0,'2012-01-17'),(331,'g',0,'2012-01-17'),(309,'g',0,'2012-01-17'),(409,'g',0,'2012-01-19'),(406,'g',0,'2012-01-19'),(408,'g',0,'2012-01-19'),(308,'g',0,'2012-01-19'),(1370,'g',0,'2012-03-01'),(1384,'g',0,'2012-03-01'),(580,'g',0,'2012-03-01'),(573,'g',0,'2012-03-01'),(791,'g',0,'2012-01-22'),(658,'g',0,'2012-03-01'),(636,'g',0,'2012-01-22'),(524,'g',0,'2012-03-01'),(655,'g',0,'2012-03-01'),(606,'g',0,'2012-03-01'),(1103,'g',0,'2012-01-22'),(1484,'g',0,'2012-03-01'),(1368,'g',0,'2012-02-22'),(423,'g',0,'2012-01-24'),(424,'g',0,'2012-01-24'),(426,'g',0,'2012-01-24'),(469,'g',0,'2012-01-24'),(477,'g',0,'2012-01-24'),(422,'g',0,'2012-01-24'),(431,'g',0,'2012-01-24'),(458,'g',0,'2012-01-24'),(665,'g',0,'2012-01-24'),(528,'g',0,'2012-01-24'),(552,'g',0,'2012-01-24'),(642,'g',0,'2012-01-24'),(413,'g',0,'2012-01-24'),(588,'g',0,'2012-01-24'),(625,'g',0,'2012-01-24'),(601,'g',0,'2012-03-01'),(555,'g',0,'2012-01-24'),(602,'g',0,'2012-03-01'),(554,'g',0,'2012-01-24'),(603,'g',0,'2012-01-24'),(578,'g',0,'2012-03-01'),(585,'g',0,'2012-01-24'),(630,'g',0,'2012-01-24'),(481,'g',0,'2012-01-24'),(561,'g',0,'2012-01-24'),(670,'g',0,'2012-01-24'),(651,'g',0,'2012-01-24'),(410,'g',0,'2012-01-24'),(459,'g',0,'2012-01-24'),(430,'g',0,'2012-01-24'),(415,'g',0,'2012-01-24'),(412,'g',0,'2012-01-24'),(411,'g',0,'2012-01-24'),(478,'g',0,'2012-01-24'),(425,'g',0,'2012-01-24'),(471,'g',0,'2012-01-24'),(414,'g',0,'2012-01-24'),(1105,'g',0,'2012-01-24'),(1101,'g',0,'2012-01-24'),(231,'g',0,'2012-01-25'),(216,'g',0,'2012-01-25'),(187,'g',0,'2012-02-28'),(267,'g',0,'2012-01-25'),(193,'g',0,'2012-01-25'),(428,'g',0,'2012-01-25'),(218,'g',0,'2012-01-25'),(338,'g',0,'2012-01-25'),(278,'g',0,'2012-01-25'),(337,'g',0,'2012-01-25'),(762,'g',0,'2012-03-06'),(768,'g',0,'2012-03-06'),(764,'g',0,'2012-01-26'),(763,'g',0,'2012-03-06'),(761,'g',0,'2012-03-06'),(767,'g',0,'2012-03-06'),(759,'g',0,'2012-03-06'),(760,'g',0,'2012-03-06'),(765,'g',0,'2012-03-06'),(766,'g',0,'2012-03-06'),(857,'g',0,'2012-01-28'),(700,'g',0,'2012-03-01'),(697,'g',0,'2012-03-01'),(823,'g',0,'2012-01-28'),(858,'g',0,'2012-01-28'),(696,'g',0,'2012-03-01'),(822,'g',0,'2012-01-28'),(695,'g',0,'2012-03-01'),(699,'g',0,'2012-03-01'),(694,'g',0,'2012-03-01'),(537,'g',0,'2012-01-28'),(517,'g',0,'2012-03-01'),(811,'g',0,'2012-01-28'),(525,'g',0,'2012-01-28'),(1550,'g',0,'2012-01-28'),(1160,'g',0,'2012-01-28'),(1387,'g',0,'2012-01-28'),(1557,'g',0,'2012-01-28'),(1109,'g',0,'2012-01-28'),(1555,'g',0,'2012-02-01'),(358,'g',0,'2012-02-05'),(283,'g',0,'2012-02-05'),(328,'g',0,'2012-02-05'),(319,'g',0,'2012-02-05'),(233,'g',0,'2012-02-05'),(387,'g',0,'2012-02-05'),(87,'g',0,'2012-02-05'),(96,'g',0,'2012-02-05'),(165,'g',0,'2012-02-05'),(154,'g',0,'2012-02-05'),(123,'g',0,'2012-02-05'),(200,'g',0,'2012-02-05'),(211,'g',0,'2012-02-05'),(176,'g',0,'2012-02-05'),(163,'g',0,'2012-02-06'),(157,'g',0,'2012-02-06'),(271,'g',0,'2012-02-06'),(281,'g',0,'2012-02-06'),(346,'g',0,'2012-02-06'),(318,'g',0,'2012-02-06'),(941,'g',0,'2012-02-07'),(976,'g',0,'2012-02-07'),(965,'g',0,'2012-02-07'),(1062,'g',0,'2012-02-07'),(1065,'g',0,'2012-02-07'),(1190,'g',0,'2012-02-07'),(1022,'g',0,'2012-02-07'),(1191,'g',0,'2012-02-07'),(1603,'g',0,'2012-02-08'),(461,'g',0,'2012-02-08'),(466,'g',0,'2012-02-08'),(1704,'g',0,'2012-02-08'),(860,'g',0,'2012-02-08'),(859,'g',0,'2012-02-08'),(861,'g',0,'2012-02-08'),(862,'g',0,'2012-02-08'),(480,'g',0,'2012-02-08'),(515,'g',0,'2012-02-08'),(865,'g',0,'2012-02-08'),(866,'g',0,'2012-02-08'),(529,'g',0,'2012-02-08'),(1220,'g',0,'2012-02-08'),(563,'g',0,'2012-02-08'),(867,'g',0,'2012-02-08'),(519,'g',0,'2012-02-08'),(576,'g',0,'2012-02-08'),(863,'g',0,'2012-02-08'),(577,'g',0,'2012-02-08'),(504,'g',0,'2012-02-08'),(495,'g',0,'2012-02-08'),(450,'g',0,'2012-02-08'),(463,'g',0,'2012-02-08'),(531,'g',0,'2012-02-08'),(564,'g',0,'2012-02-08'),(613,'g',0,'2012-02-08'),(639,'g',0,'2012-02-08'),(643,'g',0,'2012-02-08'),(645,'g',0,'2012-02-08'),(489,'g',0,'2012-02-08'),(132,'g',0,'2012-02-08'),(304,'g',0,'2012-02-08'),(302,'g',0,'2012-02-08'),(492,'g',0,'2012-02-08'),(521,'g',0,'2012-02-08'),(568,'g',0,'2012-02-08'),(320,'g',0,'2012-02-08'),(594,'g',0,'2012-02-08'),(622,'g',0,'2012-02-08'),(590,'g',0,'2012-02-08'),(619,'g',0,'2012-02-08'),(1104,'g',0,'2012-02-08'),(632,'g',0,'2012-02-08'),(1102,'g',0,'2012-02-08'),(1093,'g',0,'2012-02-08'),(784,'g',0,'2012-02-08'),(852,'g',0,'2012-02-08'),(470,'g',0,'2012-02-08'),(868,'g',0,'2012-02-08'),(618,'g',0,'2012-02-08'),(490,'g',0,'2012-02-08'),(300,'g',0,'2012-02-08'),(491,'g',0,'2012-02-08'),(502,'g',0,'2012-02-08'),(349,'g',0,'2012-02-08'),(429,'g',0,'2012-02-08'),(597,'g',0,'2012-02-08'),(609,'g',0,'2012-02-08'),(1098,'g',0,'2012-02-08'),(457,'g',0,'2012-02-11'),(984,'g',0,'2012-02-11'),(1007,'g',0,'2012-02-11'),(875,'g',0,'2012-02-11'),(996,'g',0,'2012-02-11'),(907,'g',0,'2012-02-11'),(909,'g',0,'2012-02-11'),(808,'g',0,'2012-02-11'),(955,'g',0,'2012-02-11'),(1009,'g',0,'2012-02-11'),(1008,'g',0,'2012-02-11'),(892,'g',0,'2012-02-11'),(1167,'g',0,'2012-02-11'),(912,'g',0,'2012-02-11'),(1428,'g',0,'2012-02-11'),(1417,'g',0,'2012-02-11'),(1429,'g',0,'2012-02-11'),(1322,'g',0,'2012-02-11'),(1405,'g',0,'2012-02-11'),(911,'g',0,'2012-02-11'),(951,'g',0,'2012-02-12'),(893,'g',0,'2012-02-12'),(1431,'g',0,'2012-02-12'),(882,'g',0,'2012-02-12'),(1158,'g',0,'2012-02-12'),(1334,'g',0,'2012-02-12'),(1004,'g',0,'2012-02-12'),(1388,'g',0,'2012-02-12'),(1394,'g',0,'2012-02-12'),(952,'g',0,'2012-02-12'),(1345,'g',0,'2012-02-12'),(1043,'g',0,'2012-02-12'),(1600,'g',0,'2012-02-12'),(1728,'g',0,'2012-02-12'),(1708,'g',0,'2012-02-13'),(1710,'g',0,'2012-02-13'),(1709,'g',0,'2012-02-13'),(1222,'g',0,'2012-02-15'),(551,'g',0,'2012-02-15'),(592,'g',0,'2012-02-15'),(1308,'g',0,'2012-02-15'),(1422,'g',0,'2012-02-15'),(1392,'g',0,'2012-02-15'),(1426,'g',0,'2012-02-15'),(1391,'g',0,'2012-02-15'),(1423,'g',0,'2012-02-15'),(1412,'g',0,'2012-02-15'),(1342,'g',0,'2012-02-15'),(1335,'g',0,'2012-02-15'),(1343,'g',0,'2012-02-15'),(769,'g',0,'2012-02-15'),(145,'g',0,'2012-02-15'),(146,'g',0,'2012-02-15'),(143,'g',0,'2012-02-15'),(1747,'g',0,'2012-02-17'),(334,'g',0,'2012-02-17'),(1741,'g',0,'2012-02-17'),(1750,'g',0,'2012-02-20'),(1626,'g',0,'2012-02-21'),(1760,'g',0,'2012-02-21'),(1751,'g',0,'2012-02-21'),(1744,'g',0,'2012-02-22'),(1736,'g',0,'2012-02-22'),(1759,'g',0,'2012-02-22'),(635,'g',0,'2012-02-22'),(141,'g',0,'2012-02-23'),(1762,'g',0,'2012-02-23'),(151,'g',0,'2012-02-23'),(1749,'g',0,'2012-02-24'),(1764,'g',0,'2012-02-24'),(170,'g',0,'2012-02-24'),(1758,'g',0,'2012-02-26'),(565,'g',0,'2012-02-26'),(777,'g',0,'2012-02-26'),(950,'g',0,'2012-02-27'),(817,'g',0,'2012-02-28'),(871,'g',0,'2012-02-28'),(814,'g',0,'2012-02-28'),(870,'g',0,'2012-02-28'),(1754,'g',0,'2012-02-28'),(902,'g',0,'2012-02-28'),(230,'g',0,'2012-02-29'),(1745,'g',0,'2012-02-29'),(1795,'g',0,'2012-03-01'),(1782,'g',0,'2012-03-01'),(1755,'g',0,'2012-03-01'),(1748,'g',0,'2012-03-01'),(1779,'g',0,'2012-03-01'),(1789,'g',0,'2012-03-01'),(1799,'g',0,'2012-03-01'),(1040,'g',0,'2012-03-01'),(1188,'g',0,'2012-03-01'),(1170,'g',0,'2012-03-01'),(1195,'g',0,'2012-03-01'),(1380,'g',0,'2012-03-01'),(1329,'g',0,'2012-03-01'),(1330,'g',0,'2012-03-01'),(1797,'g',0,'2012-03-01'),(1777,'g',0,'2012-03-01'),(1205,'g',0,'2012-03-01'),(1386,'g',0,'2012-03-01'),(1727,'g',0,'2012-03-01'),(654,'g',0,'2012-03-01'),(1725,'g',0,'2012-03-01'),(584,'g',0,'2012-03-01'),(1110,'g',0,'2012-03-01'),(1086,'g',0,'2012-03-01'),(971,'g',0,'2012-03-01'),(990,'g',0,'2012-03-01'),(1052,'g',0,'2012-03-01'),(690,'g',0,'2012-03-01'),(692,'g',0,'2012-03-01'),(691,'g',0,'2012-03-01'),(1633,'g',0,'2012-03-01'),(1798,'g',0,'2012-03-01'),(4,'g',0,'2012-03-01'),(1767,'g',0,'2012-03-01'),(1771,'g',0,'2012-03-01'),(1786,'g',0,'2012-03-01'),(989,'g',0,'2012-03-01'),(693,'g',0,'2012-03-01'),(1643,'g',0,'2012-03-01'),(1817,'g',0,'2012-03-06'),(1196,'g',0,'2012-03-07'),(1041,'g',0,'2012-03-07'),(1068,'g',0,'2012-03-07'),(1204,'g',0,'2012-03-07'),(943,'g',0,'2012-03-07'),(918,'g',0,'2012-03-07'),(899,'g',0,'2012-03-07'),(900,'g',0,'2012-03-07'),(916,'g',0,'2012-03-07'),(897,'g',0,'2012-03-07'),(901,'g',0,'2012-03-07');

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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


--
-- Table structure for table `idx_sessions`
--

CREATE TABLE `idx_sessions` (
  `SESSKEY` varchar(32) NOT NULL default '',
  `EXPIRY` int(11) unsigned NOT NULL default '0',
  `EXPIREREF` varchar(64) default NULL,
  `DATA` text NOT NULL,
  PRIMARY KEY  (`SESSKEY`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_sessions`
--

INSERT INTO `idx_sessions` VALUES ('4da026f01b6772306e943f2497c244ef',1331145753,NULL,'OqjIGKSzWbWPfhCdXFx8RgWow2WlSuaxp8mPqng4XElqfdQcIQtk3ZGa8iuT4qMAPM_gP8G8MRZzsLpYk0al7ZfqrNJIU4gjZQnIMZa4UvfiWHkRK-yOX9ErblsudigG39rgPNLfLp9X-SmFWw0rwl_a9JOzX6rp4Q4JOwlBhoq9_Qva1BlKTwDMtoW2FQuJUTWeaZfqOUTUw8lZ37k_Rw..'),('a18a222c26121fccf8adbc6b93fec241',1331144280,NULL,'Z7-r5cihmw26zBiZ7sPSkTNc8DnYerzpYbHnHZ0srrY1Kud1868EqfQ2PFkcOBZojowiSkVhJ9f0lkurXMP9X4nEs6GeRR3GtGb9O6RW0iZUPz_mSM_Ux-Q9BbNBiZcXrbdtyWqeo-ge7hj7pVz2eicr4UXvDTGRDWqvK8YSWBc.'),('f18d6bd7813905ad4630d745158e0946',1331144748,NULL,'4COfG0Qo6d8pHDO551qFmJDtj5BJMnOoDObD_wlf94Y0kTUKPFwbu7L_GTRmn2q75NnPqSQ8giATwfXZ_29oI7zzO5Uw8vKiET-shfOIEpPwk6GUKPCh1NoCtLTrbVDymgLnzB55z7cVqKMKO6oY4GXi5LQL4lzpiLj-ebpYPHw.'),('a9f5170c6c359d42940d9b4c42020e06',1331144800,NULL,'4COfG0Qo6d8pHDO551qFmJDtj5BJMnOoDObD_wlf94Y0kTUKPFwbu7L_GTRmn2q75NnPqSQ8giATwfXZ_29oI7zzO5Uw8vKiET-shfOIEpPwk6GUKPCh1NoCtLTrbVDymgLnzB55z7cVqKMKO6oY4GXi5LQL4lzpiLj-ebpYPHw.'),('0daaf25bd11b7332a2a8123fd43ae53d',1331145670,NULL,'8ifdtZfUSpBCSWpOqbJiYqLP_WbTVG5MPu-VjYnBo6mb_zxYBo6vuR-6jezcZJTJdpjUEM2fCGH26G5JKmrK80CmuTEQemEr-Pkp_z0Ms10aoDbm6SqUJ6ir27-GIOT11-RscP2a1d10RN2TYQuYqsQjQ4XShTHgWqfc0-Xmm90.'),('30d52d2f02efac0c114d72c94860c18f',1331145671,NULL,'a9s7BQIGHPKbym7-8JKySE15Fz7VtmquCtOL7JPPRJZ0IaNuplRUj27yzigOS5PBKyFi08NFn8V2rWAXBPYwfT_u5F0jHiRPJAR5CxqsbxRQK2Mc8Izpz3bOrzWDqBmZdgDF5tNuRmv1l-hFw3zbIdGNHl-HcI5Ns5iFQMRNVrg.'),('dae6347281fa6c6048b5fcb8f07fe9f6',1331145762,NULL,'uUEbixox_HOzmgHZ4_CJf2xp9-TglZ1IHBi1U5LJ00h_CyQqg5Y-HXVMPLH9x8W496YaWRsTFmr_VeqYDayz5YqHrKmnIQIHzIdiWIk0qcMc9kAR-BnbbehE2bpYwfW_nad4sAV7Qu_T_F0qebF_Dg..');

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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


--
-- Table structure for table `idx_users`
--

CREATE TABLE `idx_users` (
  `username` varchar(20) NOT NULL default '',
  `password` varchar(50) NOT NULL,
  `name` varchar(50) default NULL,
  `email` varchar(50) default NULL,
  `date` date default NULL,
  `status` char(1) default NULL,
  `vcode` varchar(4) default NULL,
  `group_id` tinyint(4) default NULL,
  `homepage` varchar(100) default NULL,
  `icq` varchar(20) default NULL,
  `aol` varchar(20) default NULL,
  `yahoo` varchar(20) default NULL,
  `biography` text,
  `location` varchar(50) default NULL,
  `interest` varchar(50) default NULL,
  `occupation` varchar(50) default NULL,
  PRIMARY KEY  (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_users`
--

INSERT INTO `idx_users` VALUES ('admin','b7c0a086fd7fb859c0a4977e9c2e16a2','Administrator','bradbury.galik@gmail.com','2011-09-15','1','',0,'','','','','','','','');

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

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

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



