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

CREATE TABLE `idx_link_temp` (
  `vid` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `spam` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `link_id` mediumint(9) DEFAULT NULL,
  `category_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `url` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `contact_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email` varchar(100) COLLATE utf8_unicode_ci 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hot` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `top_rated` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pick` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `updated` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `reviews` smallint(6) DEFAULT NULL,
  `avg_review` float(4,2) DEFAULT NULL,
  `last_updated` datetime DEFAULT NULL,
  `official_review` text COLLATE utf8_unicode_ci,
  `keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cat1` mediumint(6) NOT NULL DEFAULT '0',
  `cat2` mediumint(6) NOT NULL DEFAULT '0',
  `suspended` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `reciprocal_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fax` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`vid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `idx_link_temp` VALUES (1,'0',NULL,47,'Hot Lingerie, Sexy Lingerie &amp; Silk Lingerie','http://www.hotsexylingerie.co.uk','Free shipping and fast delivery. Shop for lingerie, sexy lingerie and sexy lingerie sets at hotsexylingerie.co.uk. Find lingerie by style, size and color.','Wayne Qiu','wayne@hotsexylingerie.co.uk',0,0,0.00,'2011-06-18 04:38:39',0,'0','0','0','0','WDVG8S','0',0,0.00,'0000-00-00 00:00:00','','sexy lingerie,lingeries,silk pyjamas,babydoll,knickers,bustier,corset',0,0,'','','YongSheng District','YiWu','Zhejiang','China','322000','','+86 18059740992','');

--
-- 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`
--


--
-- 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,'sgjgems'),(2,'sgjgems'),(48,'winchoice');

--
-- 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`
--

INSERT INTO `idx_notification` VALUES ('admin',43);

--
-- 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 (35,'g',3,'2011-09-26'),(36,'g',3,'2011-09-26'),(40,'g',2,'2011-09-26'),(42,'g',2,'2011-09-26'),(41,'g',2,'2011-09-26'),(3,'g',4,'2011-09-28'),(32,'g',6,'2011-09-29'),(34,'g',3,'2011-09-29'),(4,'g',4,'2011-09-29'),(37,'g',3,'2011-09-29'),(31,'g',0,'2011-10-15'),(19,'g',0,'2011-10-15'),(27,'g',0,'2011-10-15'),(10,'g',0,'2011-12-01'),(17,'g',0,'2011-10-15'),(50,'g',0,'2011-10-15'),(44,'g',0,'2011-10-15'),(43,'g',0,'2011-10-15'),(45,'g',0,'2011-10-15'),(46,'g',0,'2011-10-15'),(47,'g',0,'2011-10-15'),(49,'g',0,'2011-10-15'),(15,'g',0,'2011-10-15'),(48,'g',0,'2011-10-15'),(33,'g',0,'2011-10-15'),(6,'g',0,'2011-12-01'),(16,'g',0,'2011-10-15'),(20,'g',0,'2011-10-15'),(21,'g',0,'2011-10-15'),(24,'g',0,'2011-10-15'),(25,'g',0,'2011-10-15'),(26,'g',0,'2011-10-15'),(13,'g',0,'2011-10-15'),(30,'g',0,'2011-10-15'),(18,'g',0,'2011-10-15'),(2,'g',0,'2011-10-15'),(1,'g',0,'2011-10-15'),(23,'g',0,'2011-10-15'),(22,'g',0,'2011-10-15'),(5,'g',0,'2011-10-15'),(7,'g',0,'2011-11-18'),(14,'g',0,'2011-10-15'),(8,'g',0,'2011-11-30'),(11,'g',0,'2011-10-15'),(9,'g',0,'2011-11-03'),(136,'g',0,'2011-11-17'),(142,'g',0,'2011-11-17'),(160,'g',0,'2011-11-17'),(175,'g',0,'2011-11-17'),(114,'g',0,'2011-11-17'),(451,'g',0,'2011-11-17'),(453,'g',0,'2011-11-17'),(473,'g',0,'2011-11-17'),(79,'g',0,'2011-11-17'),(89,'g',0,'2011-11-17'),(64,'g',0,'2011-11-17'),(91,'g',0,'2011-11-17'),(69,'g',0,'2011-11-17'),(94,'g',0,'2011-11-17'),(203,'g',0,'2011-11-17'),(108,'g',0,'2011-11-17'),(442,'g',0,'2011-11-17'),(244,'g',0,'2011-11-17'),(245,'g',0,'2011-11-17'),(306,'g',0,'2011-11-17'),(297,'g',0,'2011-11-17'),(448,'g',0,'2011-11-17'),(60,'g',0,'2011-11-19'),(844,'g',0,'2011-11-21'),(81,'g',0,'2011-11-23'),(145,'g',0,'2011-11-24'),(109,'g',0,'2011-11-24'),(1098,'g',0,'2011-11-24'),(592,'g',0,'2011-11-24'),(817,'g',0,'2011-11-25'),(128,'g',0,'2011-11-28'),(180,'g',0,'2011-11-28'),(154,'g',0,'2011-11-29'),(87,'g',0,'2011-11-29'),(167,'g',0,'2011-11-29'),(174,'g',0,'2011-11-29'),(171,'g',0,'2011-11-29'),(205,'g',0,'2011-11-29'),(57,'g',0,'2011-11-29'),(83,'g',0,'2011-11-29'),(246,'g',0,'2011-11-29'),(269,'g',0,'2011-11-29'),(446,'g',0,'2011-11-29'),(107,'g',0,'2011-11-30'),(55,'g',0,'2011-11-30'),(54,'g',0,'2011-11-30'),(194,'g',0,'2011-11-30'),(90,'g',0,'2011-12-01'),(93,'g',0,'2011-12-01'),(92,'g',0,'2011-12-01'),(95,'g',0,'2011-12-01'),(96,'g',0,'2011-12-01'),(97,'g',0,'2011-12-01'),(98,'g',0,'2011-12-01'),(99,'g',0,'2011-12-01'),(100,'g',0,'2011-12-01'),(103,'g',0,'2011-12-01'),(117,'g',0,'2011-12-01'),(262,'g',0,'2011-12-01'),(101,'g',0,'2011-12-01'),(102,'g',0,'2011-12-01'),(84,'g',0,'2011-12-01'),(74,'g',0,'2011-12-01'),(71,'g',0,'2011-12-01'),(67,'g',0,'2011-12-01'),(66,'g',0,'2011-12-01'),(123,'g',0,'2011-12-01'),(72,'g',0,'2011-12-01'),(70,'g',0,'2011-12-01'),(566,'g',0,'2011-12-01'),(640,'g',0,'2011-12-01'),(641,'g',0,'2011-12-01'),(649,'g',0,'2011-12-01'),(699,'g',0,'2011-12-01'),(835,'g',0,'2011-12-01'),(1366,'g',0,'2011-12-01'),(659,'g',0,'2011-12-01'),(803,'g',0,'2011-12-01'),(88,'g',0,'2011-12-01'),(249,'g',0,'2011-12-01'),(1440,'g',0,'2011-12-01'),(863,'g',0,'2011-12-01'),(1299,'g',0,'2011-12-01'),(52,'g',0,'2011-12-01'),(2520,'g',0,'2012-02-19'),(2956,'g',0,'2012-01-10'),(56,'g',0,'2011-12-01'),(63,'g',0,'2011-12-01'),(339,'g',0,'2011-12-01'),(769,'g',0,'2011-12-01'),(791,'g',0,'2011-12-01'),(819,'g',0,'2011-12-01'),(856,'g',0,'2011-12-01'),(499,'g',0,'2011-12-01'),(1569,'g',0,'2011-12-01'),(1591,'g',0,'2011-12-01'),(1663,'g',0,'2011-12-01'),(2099,'g',0,'2011-12-01'),(1139,'g',0,'2011-12-01'),(131,'g',0,'2011-12-01'),(268,'g',0,'2011-12-01'),(469,'g',0,'2011-12-01'),(477,'g',0,'2011-12-01'),(483,'g',0,'2011-12-01'),(61,'g',0,'2011-12-01'),(151,'g',0,'2011-12-01'),(462,'g',0,'2011-12-01'),(482,'g',0,'2011-12-01'),(484,'g',0,'2011-12-01'),(251,'g',0,'2011-12-01'),(470,'g',0,'2011-12-01'),(896,'g',0,'2011-12-01'),(897,'g',0,'2011-12-01'),(899,'g',0,'2011-12-01'),(900,'g',0,'2011-12-01'),(901,'g',0,'2011-12-01'),(902,'g',0,'2011-12-01'),(917,'g',0,'2011-12-01'),(898,'g',0,'2011-12-01'),(903,'g',0,'2011-12-01'),(1062,'g',0,'2011-12-01'),(240,'g',0,'2011-12-01'),(513,'g',0,'2011-12-01'),(739,'g',0,'2011-12-01'),(1539,'g',0,'2011-12-01'),(1840,'g',0,'2011-12-01'),(2113,'g',0,'2011-12-01'),(2339,'g',0,'2011-12-01'),(2697,'g',0,'2012-01-09'),(68,'g',0,'2011-12-01'),(118,'g',0,'2011-12-01'),(124,'g',0,'2011-12-01'),(126,'g',0,'2011-12-01'),(132,'g',0,'2011-12-01'),(138,'g',0,'2011-12-01'),(141,'g',0,'2011-12-01'),(1040,'g',0,'2011-12-01'),(1313,'g',0,'2011-12-01'),(121,'g',0,'2011-12-01'),(147,'g',0,'2011-12-01'),(53,'g',0,'2011-12-02'),(192,'g',0,'2011-12-02'),(452,'g',0,'2011-12-02'),(455,'g',0,'2011-12-02'),(506,'g',0,'2011-12-02'),(1252,'g',0,'2011-12-02'),(1255,'g',0,'2011-12-02'),(1306,'g',0,'2011-12-02'),(1352,'g',0,'2011-12-02'),(1382,'g',0,'2011-12-02'),(552,'g',0,'2011-12-02'),(582,'g',0,'2011-12-02'),(787,'g',0,'2011-12-02'),(749,'g',0,'2011-12-02'),(1549,'g',0,'2011-12-02'),(2349,'g',0,'2011-12-02'),(3206,'g',0,'2012-01-11'),(209,'g',0,'2011-12-06'),(2412,'g',0,'2011-12-06'),(511,'g',0,'2011-12-06'),(1691,'g',0,'2011-12-06'),(532,'g',0,'2011-12-07'),(2461,'g',0,'2011-12-07'),(518,'g',0,'2011-12-08'),(3691,'g',0,'2012-02-19'),(3652,'g',0,'2011-12-15'),(2526,'g',0,'2012-02-19'),(2536,'g',0,'2012-02-19'),(2548,'g',0,'2012-02-19'),(2521,'g',0,'2011-12-15'),(2547,'g',0,'2012-02-19'),(2546,'g',0,'2012-02-19'),(2550,'g',0,'2012-02-19'),(2549,'g',0,'2012-02-19'),(2660,'g',0,'2012-03-06'),(2905,'g',0,'2012-03-06'),(2708,'g',0,'2012-03-06'),(2754,'g',0,'2012-03-06'),(2701,'g',0,'2012-03-06'),(2927,'g',0,'2011-12-15'),(2702,'g',0,'2012-03-06'),(2899,'g',0,'2012-03-06'),(2763,'g',0,'2012-03-06'),(3650,'g',0,'2011-12-16'),(2524,'g',0,'2011-12-16'),(3689,'g',0,'2011-12-16'),(2527,'g',0,'2011-12-16'),(3023,'g',0,'2012-01-24'),(3379,'g',0,'2012-02-20'),(3338,'g',0,'2012-02-20'),(3106,'g',0,'2012-02-16'),(3156,'g',0,'2012-02-20'),(3098,'g',0,'2012-02-16'),(3293,'g',0,'2011-12-19'),(2532,'g',0,'2012-02-19'),(2567,'g',0,'2012-02-19'),(3722,'g',0,'2012-02-19'),(2601,'g',0,'2012-02-19'),(2573,'g',0,'2011-12-23'),(2591,'g',0,'2012-02-19'),(2572,'g',0,'2012-02-19'),(2618,'g',0,'2012-02-19'),(2620,'g',0,'2012-02-19'),(3680,'g',0,'2012-02-20'),(3478,'g',0,'2011-12-28'),(2712,'g',0,'2012-02-02'),(3725,'g',0,'2012-02-19'),(3711,'g',0,'2012-02-19'),(3710,'g',0,'2012-02-02'),(2585,'g',0,'2012-02-19'),(3793,'g',0,'2012-02-19'),(2571,'g',0,'2012-01-03'),(2593,'g',0,'2012-02-19'),(2599,'g',0,'2012-02-19'),(2617,'g',0,'2012-01-03'),(2632,'g',0,'2012-02-19'),(3116,'g',0,'2012-02-16'),(3816,'g',0,'2012-02-20'),(3394,'g',0,'2012-02-20'),(2764,'g',0,'2012-01-07'),(3165,'g',0,'2012-02-20'),(3551,'g',0,'2012-02-20'),(3485,'g',0,'2012-02-19'),(3712,'g',0,'2012-02-19'),(3704,'g',0,'2012-01-08'),(2551,'g',0,'2012-02-19'),(3798,'g',0,'2012-02-20'),(3799,'g',0,'2012-02-20'),(3795,'g',0,'2012-02-20'),(3808,'g',0,'2012-01-09'),(3807,'g',0,'2012-02-20'),(3802,'g',0,'2012-02-20'),(3776,'g',0,'2012-02-20'),(3777,'g',0,'2012-02-20'),(3773,'g',0,'2012-02-20'),(3817,'g',0,'2012-02-20'),(3097,'g',0,'2012-02-20'),(3061,'g',0,'2012-01-09'),(3307,'g',0,'2012-01-09'),(3792,'g',0,'2012-02-20'),(2782,'g',0,'2012-02-20'),(3070,'g',0,'2012-02-20'),(3173,'g',0,'2012-02-20'),(2813,'g',0,'2012-02-20'),(2923,'g',0,'2012-01-09'),(3350,'g',0,'2012-02-20'),(3131,'g',0,'2012-01-09'),(3550,'g',0,'2012-02-20'),(3554,'g',0,'2012-02-20'),(3544,'g',0,'2012-02-20'),(3533,'g',0,'2012-01-09'),(3196,'g',0,'2012-01-09'),(2970,'g',0,'2012-02-20'),(3782,'g',0,'2012-03-06'),(3723,'g',0,'2012-03-04'),(2752,'g',0,'2012-02-27'),(3552,'g',0,'2012-03-04'),(3147,'g',0,'2012-03-04'),(3246,'g',0,'2012-03-04'),(3545,'g',0,'2012-02-27'),(2587,'g',0,'2012-02-27'),(3679,'g',0,'2012-01-09'),(3192,'g',0,'2012-03-04'),(2759,'g',0,'2012-03-04'),(3319,'g',0,'2012-03-06'),(3399,'g',0,'2012-03-06'),(3281,'g',0,'2012-03-06'),(2796,'g',0,'2012-01-09'),(3361,'g',0,'2012-03-06'),(3439,'g',0,'2012-03-06'),(2513,'g',0,'2012-03-06'),(3542,'g',0,'2012-03-06'),(3233,'g',0,'2012-01-09'),(3565,'g',0,'2012-03-06'),(3775,'g',0,'2012-01-09'),(3769,'g',0,'2012-02-20'),(3781,'g',0,'2012-02-20'),(3785,'g',0,'2012-02-20'),(3779,'g',0,'2012-01-09'),(3790,'g',0,'2012-02-20'),(3787,'g',0,'2012-02-20'),(3789,'g',0,'2012-02-20'),(3822,'g',0,'2012-02-20'),(3821,'g',0,'2012-02-20'),(3753,'g',0,'2012-01-09'),(3761,'g',0,'2012-02-20'),(3763,'g',0,'2012-02-20'),(3757,'g',0,'2012-02-20'),(3820,'g',0,'2012-02-20'),(3813,'g',0,'2012-02-20'),(3814,'g',0,'2012-02-20'),(3811,'g',0,'2012-02-20'),(3812,'g',0,'2012-02-20'),(3770,'g',0,'2012-02-20'),(2565,'g',0,'2012-01-09'),(3742,'g',0,'2012-01-09'),(2540,'g',0,'2012-01-09'),(2713,'g',0,'2012-01-09'),(2710,'g',0,'2012-02-20'),(3744,'g',0,'2012-02-20'),(2514,'g',0,'2012-02-20'),(2726,'g',0,'2012-02-20'),(2703,'g',0,'2012-02-20'),(2903,'g',0,'2012-01-09'),(3806,'g',0,'2012-02-20'),(3317,'g',0,'2012-02-20'),(2755,'g',0,'2012-02-20'),(3119,'g',0,'2012-02-20'),(3320,'g',0,'2012-02-20'),(3743,'g',0,'2012-02-20'),(3359,'g',0,'2012-02-20'),(3337,'g',0,'2012-02-20'),(3405,'g',0,'2012-02-20'),(3692,'g',0,'2012-02-20'),(3049,'g',0,'2012-02-20'),(3700,'g',0,'2012-02-20'),(3720,'g',0,'2012-02-20'),(3713,'g',0,'2012-02-20'),(3796,'g',0,'2012-02-20'),(3760,'g',0,'2012-02-20'),(3758,'g',0,'2012-02-20'),(3756,'g',0,'2012-02-20'),(3755,'g',0,'2012-02-20'),(3699,'g',0,'2012-02-20'),(3732,'g',0,'2012-02-20'),(3467,'g',0,'2012-02-20'),(2745,'g',0,'2012-02-20'),(3762,'g',0,'2012-02-19'),(3752,'g',0,'2012-02-19'),(3797,'g',0,'2012-02-19'),(3788,'g',0,'2012-02-19'),(3823,'g',0,'2012-02-19'),(3819,'g',0,'2012-02-19'),(3715,'g',0,'2012-02-19'),(3805,'g',0,'2012-02-19'),(3709,'g',0,'2012-02-19'),(3039,'g',0,'2012-02-19'),(2912,'g',0,'2012-02-19'),(3009,'g',0,'2012-01-10'),(2909,'g',0,'2012-02-19'),(2963,'g',0,'2012-02-19'),(3075,'g',0,'2012-03-07'),(3086,'g',0,'2012-01-10'),(3085,'g',0,'2012-02-21'),(3210,'g',0,'2012-03-07'),(3158,'g',0,'2012-03-07'),(3222,'g',0,'2012-03-07'),(3161,'g',0,'2012-03-07'),(3130,'g',0,'2012-03-07'),(3132,'g',0,'2012-03-07'),(3035,'g',0,'2012-03-07'),(3694,'g',0,'2012-02-20'),(3693,'g',0,'2012-02-20'),(3749,'g',0,'2012-02-20'),(3818,'g',0,'2012-02-20'),(3810,'g',0,'2012-02-20'),(3778,'g',0,'2012-02-20'),(3701,'g',0,'2012-02-20'),(3706,'g',0,'2012-02-20'),(3708,'g',0,'2012-02-20'),(3707,'g',0,'2012-02-20'),(2552,'g',0,'2012-02-19'),(2553,'g',0,'2012-03-07'),(2574,'g',0,'2012-03-07'),(2554,'g',0,'2012-03-07'),(2560,'g',0,'2012-03-07'),(2556,'g',0,'2012-03-07'),(2555,'g',0,'2012-03-07'),(2558,'g',0,'2012-03-07'),(2557,'g',0,'2012-03-07'),(2559,'g',0,'2012-03-07'),(2596,'g',0,'2012-02-19'),(2535,'g',0,'2012-02-19'),(2534,'g',0,'2012-02-19'),(2808,'g',0,'2012-02-19'),(3809,'g',0,'2012-02-19'),(2953,'g',0,'2012-02-19'),(3815,'g',0,'2012-02-19'),(2960,'g',0,'2012-02-19'),(2788,'g',0,'2012-02-19'),(2979,'g',0,'2012-02-19'),(3628,'g',0,'2012-02-20'),(3731,'g',0,'2012-02-19'),(3786,'g',0,'2012-02-19'),(3487,'g',0,'2012-02-19'),(3486,'g',0,'2012-02-19'),(3488,'g',0,'2012-02-19'),(3483,'g',0,'2012-01-10'),(3484,'g',0,'2012-02-19'),(3794,'g',0,'2012-02-19'),(2510,'g',0,'2012-02-19'),(2651,'g',0,'2012-02-19'),(2649,'g',0,'2012-01-10'),(3716,'g',0,'2012-02-19'),(2602,'g',0,'2012-02-19'),(2511,'g',0,'2012-02-19'),(2512,'g',0,'2012-02-19'),(2517,'g',0,'2012-02-19'),(2720,'g',0,'2012-02-19'),(3001,'g',0,'2012-01-10'),(2901,'g',0,'2012-03-07'),(2990,'g',0,'2012-03-07'),(2958,'g',0,'2012-03-07'),(2938,'g',0,'2012-01-10'),(2733,'g',0,'2012-01-10'),(2751,'g',0,'2012-03-07'),(2892,'g',0,'2012-03-07'),(2719,'g',0,'2012-01-10'),(2920,'g',0,'2012-03-07'),(3783,'g',0,'2012-02-19'),(3800,'g',0,'2012-02-19'),(2563,'g',0,'2012-01-10'),(2619,'g',0,'2012-02-19'),(3163,'g',0,'2012-02-19'),(2999,'g',0,'2012-02-19'),(3046,'g',0,'2012-01-10'),(2607,'g',0,'2012-02-19'),(3767,'g',0,'2012-02-19'),(2769,'g',0,'2012-02-19'),(2767,'g',0,'2012-02-19'),(2978,'g',0,'2012-02-19'),(2977,'g',0,'2012-02-19'),(3791,'g',0,'2012-02-19'),(3804,'g',0,'2012-02-19'),(3780,'g',0,'2012-02-19'),(3735,'g',0,'2012-02-19'),(2539,'g',0,'2012-02-19'),(2537,'g',0,'2012-02-19'),(2561,'g',0,'2012-02-19'),(3746,'g',0,'2012-02-19'),(3748,'g',0,'2012-02-19'),(2519,'g',0,'2012-02-19'),(3322,'g',0,'2012-03-07'),(3605,'g',0,'2012-02-20'),(3580,'g',0,'2012-03-06'),(3583,'g',0,'2012-03-06'),(3451,'g',0,'2012-03-07'),(3589,'g',0,'2012-02-20'),(3463,'g',0,'2012-03-07'),(3376,'g',0,'2012-01-10'),(3296,'g',0,'2012-03-07'),(2543,'g',0,'2012-01-10'),(2541,'g',0,'2012-01-10'),(2531,'g',0,'2012-01-10'),(2523,'g',0,'2012-01-10'),(2528,'g',0,'2012-01-10'),(2529,'g',0,'2012-01-10'),(3774,'g',0,'2012-01-10'),(3682,'g',0,'2012-01-10'),(3008,'g',0,'2012-01-10'),(3015,'g',0,'2012-01-10'),(2995,'g',0,'2012-01-10'),(3029,'g',0,'2012-01-10'),(2969,'g',0,'2012-01-10'),(2985,'g',0,'2012-01-10'),(2987,'g',0,'2012-01-10'),(3003,'g',0,'2012-01-10'),(3004,'g',0,'2012-01-10'),(2973,'g',0,'2012-01-10'),(2913,'g',0,'2012-01-10'),(2921,'g',0,'2012-01-10'),(2925,'g',0,'2012-01-10'),(2936,'g',0,'2012-01-10'),(2937,'g',0,'2012-01-10'),(2949,'g',0,'2012-01-10'),(3765,'g',0,'2012-01-10'),(2965,'g',0,'2012-01-10'),(2962,'g',0,'2012-01-10'),(3624,'g',0,'2012-01-10'),(3218,'g',0,'2012-01-10'),(3215,'g',0,'2012-01-10'),(3214,'g',0,'2012-01-10'),(3239,'g',0,'2012-01-10'),(3238,'g',0,'2012-01-10'),(3247,'g',0,'2012-01-10'),(3227,'g',0,'2012-01-10'),(3234,'g',0,'2012-01-10'),(3284,'g',0,'2012-01-10'),(3282,'g',0,'2012-01-10'),(2696,'g',0,'2012-01-10'),(2911,'g',0,'2012-01-10'),(2693,'g',0,'2012-01-10'),(2896,'g',0,'2012-01-10'),(2897,'g',0,'2012-01-10'),(2890,'g',0,'2012-01-10'),(2750,'g',0,'2012-01-10'),(2699,'g',0,'2012-01-10'),(2666,'g',0,'2012-01-10'),(2906,'g',0,'2012-01-10'),(3714,'g',0,'2012-01-10'),(3772,'g',0,'2012-02-20'),(3771,'g',0,'2012-01-10'),(3721,'g',0,'2012-01-10'),(3736,'g',0,'2012-01-10'),(3747,'g',0,'2012-01-10'),(3745,'g',0,'2012-01-10'),(3750,'g',0,'2012-01-10'),(3751,'g',0,'2012-01-10'),(3175,'g',0,'2012-01-10'),(3197,'g',0,'2012-01-10'),(3140,'g',0,'2012-01-10'),(3160,'g',0,'2012-01-10'),(3212,'g',0,'2012-01-10'),(3211,'g',0,'2012-01-10'),(3155,'g',0,'2012-01-10'),(3213,'g',0,'2012-01-10'),(3159,'g',0,'2012-01-10'),(3157,'g',0,'2012-01-10'),(3082,'g',0,'2012-01-10'),(3081,'g',0,'2012-01-10'),(3079,'g',0,'2012-01-10'),(3051,'g',0,'2012-01-10'),(3050,'g',0,'2012-01-10'),(3044,'g',0,'2012-01-10'),(3037,'g',0,'2012-01-10'),(3033,'g',0,'2012-01-10'),(3134,'g',0,'2012-01-10'),(3090,'g',0,'2012-01-10'),(2663,'g',0,'2012-01-10'),(2623,'g',0,'2012-01-10'),(2622,'g',0,'2012-01-10'),(2626,'g',0,'2012-01-10'),(2629,'g',0,'2012-01-10'),(2580,'g',0,'2012-01-10'),(2613,'g',0,'2012-01-10'),(2597,'g',0,'2012-01-10'),(2605,'g',0,'2012-01-10'),(2564,'g',0,'2012-01-10'),(3561,'g',0,'2012-01-10'),(3409,'g',0,'2012-01-10'),(3466,'g',0,'2012-01-10'),(3385,'g',0,'2012-02-20'),(3523,'g',0,'2012-01-10'),(3524,'g',0,'2012-01-10'),(3525,'g',0,'2012-01-10'),(3526,'g',0,'2012-01-10'),(3522,'g',0,'2012-01-10'),(3521,'g',0,'2012-01-10'),(3520,'g',0,'2012-01-10'),(3518,'g',0,'2012-01-10'),(3519,'g',0,'2012-01-10'),(3516,'g',0,'2012-02-20'),(3517,'g',0,'2012-02-20'),(3514,'g',0,'2012-02-20'),(3515,'g',0,'2012-02-20'),(3497,'g',0,'2012-01-10'),(2758,'g',0,'2012-01-10'),(3703,'g',0,'2012-01-10'),(3759,'g',0,'2012-01-10'),(2522,'g',0,'2012-01-10'),(2677,'g',0,'2012-01-10'),(2569,'g',0,'2012-01-10'),(3766,'g',0,'2012-01-10'),(3740,'g',0,'2012-01-11'),(3741,'g',0,'2012-01-11'),(3737,'g',0,'2012-01-11'),(3739,'g',0,'2012-01-11'),(3738,'g',0,'2012-01-11'),(3734,'g',0,'2012-01-11'),(3304,'g',0,'2012-01-11'),(3392,'g',0,'2012-01-11'),(3314,'g',0,'2012-01-11'),(3302,'g',0,'2012-01-11'),(3383,'g',0,'2012-01-11'),(3335,'g',0,'2012-01-11'),(3334,'g',0,'2012-01-11'),(3333,'g',0,'2012-01-11'),(3402,'g',0,'2012-01-11'),(3404,'g',0,'2012-01-11'),(3201,'g',0,'2012-01-11'),(3203,'g',0,'2012-01-11'),(3202,'g',0,'2012-01-11'),(3174,'g',0,'2012-01-11'),(3171,'g',0,'2012-01-11'),(3172,'g',0,'2012-01-11'),(3166,'g',0,'2012-01-11'),(3169,'g',0,'2012-01-11'),(3168,'g',0,'2012-01-11'),(3167,'g',0,'2012-01-11'),(2984,'g',0,'2012-01-11'),(2988,'g',0,'2012-01-11'),(2976,'g',0,'2012-01-11'),(2940,'g',0,'2012-01-11'),(2941,'g',0,'2012-01-11'),(2944,'g',0,'2012-01-11'),(2945,'g',0,'2012-01-11'),(2950,'g',0,'2012-01-11'),(3007,'g',0,'2012-01-11'),(3014,'g',0,'2012-01-11'),(3224,'g',0,'2012-01-11'),(3205,'g',0,'2012-01-11'),(3204,'g',0,'2012-01-11'),(3207,'g',0,'2012-01-11'),(3209,'g',0,'2012-01-11'),(3244,'g',0,'2012-01-11'),(3250,'g',0,'2012-01-11'),(3253,'g',0,'2012-01-11'),(3251,'g',0,'2012-01-11'),(3254,'g',0,'2012-01-11'),(3257,'g',0,'2012-01-11'),(3258,'g',0,'2012-01-11'),(3255,'g',0,'2012-01-11'),(3256,'g',0,'2012-01-11'),(3259,'g',0,'2012-01-11'),(3262,'g',0,'2012-01-11'),(3263,'g',0,'2012-01-11'),(3260,'g',0,'2012-01-11'),(3261,'g',0,'2012-01-11'),(3265,'g',0,'2012-01-11'),(3264,'g',0,'2012-01-11'),(3266,'g',0,'2012-01-11'),(3272,'g',0,'2012-01-11'),(3277,'g',0,'2012-01-11'),(3276,'g',0,'2012-01-11'),(3275,'g',0,'2012-01-11'),(3274,'g',0,'2012-01-11'),(3273,'g',0,'2012-01-11'),(3301,'g',0,'2012-01-11'),(3733,'g',0,'2012-01-11'),(2939,'g',0,'2012-01-11'),(2934,'g',0,'2012-01-11'),(2608,'g',0,'2012-01-11'),(2588,'g',0,'2012-01-11'),(2919,'g',0,'2012-01-11'),(2518,'g',0,'2012-01-11'),(2725,'g',0,'2012-01-11'),(2926,'g',0,'2012-01-11'),(3686,'g',0,'2012-01-11'),(3127,'g',0,'2012-01-11'),(3041,'g',0,'2012-01-11'),(3151,'g',0,'2012-01-11'),(3093,'g',0,'2012-01-11'),(3625,'g',0,'2012-01-11'),(3073,'g',0,'2012-01-11'),(3077,'g',0,'2012-01-11'),(3110,'g',0,'2012-01-11'),(3055,'g',0,'2012-01-11'),(3122,'g',0,'2012-01-11'),(2653,'g',0,'2012-01-11'),(2652,'g',0,'2012-01-11'),(2650,'g',0,'2012-01-11'),(2658,'g',0,'2012-01-11'),(2659,'g',0,'2012-01-11'),(2654,'g',0,'2012-01-11'),(3690,'g',0,'2012-01-12'),(3124,'g',0,'2012-01-20'),(3825,'g',0,'2012-02-02'),(3113,'g',0,'2012-02-15'),(3964,'g',0,'2012-02-19'),(3873,'g',0,'2012-02-19'),(3908,'g',0,'2012-02-19'),(2910,'g',0,'2012-02-19'),(2908,'g',0,'2012-02-19'),(3942,'g',0,'2012-02-19'),(3935,'g',0,'2012-02-19'),(2914,'g',0,'2012-02-19'),(3052,'g',0,'2012-02-20'),(3973,'g',0,'2012-02-20'),(3970,'g',0,'2012-02-20'),(3951,'g',0,'2012-02-20'),(3895,'g',0,'2012-02-20'),(3827,'g',0,'2012-02-20'),(3936,'g',0,'2012-02-20'),(3828,'g',0,'2012-02-20'),(3824,'g',0,'2012-02-20'),(3826,'g',0,'2012-02-20'),(4034,'g',0,'2012-03-06'),(3054,'g',0,'2012-03-06'),(2997,'g',0,'2012-03-06'),(3903,'g',0,'2012-03-06'),(4031,'g',0,'2012-03-06'),(2967,'g',0,'2012-03-07'),(2968,'g',0,'2012-03-07'),(2955,'g',0,'2012-03-07'),(2904,'g',0,'2012-03-07'),(2636,'g',0,'2012-03-07'),(3960,'g',0,'2012-03-07'),(2924,'g',0,'2012-03-07'),(2621,'g',0,'2012-03-07'),(3954,'g',0,'2012-03-07'),(3999,'g',0,'2012-03-07'),(3991,'g',0,'2012-03-07'),(2989,'g',0,'2012-03-07'),(2992,'g',0,'2012-03-07'),(4026,'g',0,'2012-03-07'),(3083,'g',0,'2012-03-07'),(2975,'g',0,'2012-03-07'),(4000,'g',0,'2012-03-07'),(3031,'g',0,'2012-03-07'),(3135,'g',0,'2012-03-07'),(3377,'g',0,'2012-03-07'),(3280,'g',0,'2012-03-07'),(3249,'g',0,'2012-03-07'),(3236,'g',0,'2012-03-07'),(3345,'g',0,'2012-03-07'),(3344,'g',0,'2012-03-07'),(3208,'g',0,'2012-03-07'),(3295,'g',0,'2012-03-07'),(3162,'g',0,'2012-03-07'),(4017,'g',0,'2012-03-07'),(3495,'g',0,'2012-03-07'),(3493,'g',0,'2012-03-07'),(3419,'g',0,'2012-03-07'),(3398,'g',0,'2012-03-07'),(3587,'g',0,'2012-03-07'),(3449,'g',0,'2012-03-07'),(3979,'g',0,'2012-03-07'),(3043,'g',0,'2012-03-07'),(3144,'g',0,'2012-03-07'),(3128,'g',0,'2012-03-07'),(3024,'g',0,'2012-03-07'),(3021,'g',0,'2012-03-07'),(3626,'g',0,'2012-03-07'),(3627,'g',0,'2012-03-07'),(3988,'g',0,'2012-03-07'),(3125,'g',0,'2012-03-07'),(3058,'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) 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 ('G0mmEysTj6faSXo4t5tMXA','jTqwGZWl23dGm7ghVrOXfGVH6Dg4AZEObA4Dfry0yGg','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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- 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 ('automobiles','2011-06-10 00:18:44',0,'203.115.81.93'),('cutlery','2011-06-19 19:53:25',0,'125.115.36.211'),('music','2011-07-29 01:21:26',0,'203.92.47.195'),('search...clothes','2011-08-02 21:16:25',0,'121.29.132.113'),('clothes','2011-08-02 21:16:36',0,'121.29.132.113'),('gavinli80','2011-08-02 21:16:47',0,'121.29.132.113'),('3S Textile & Apparel Shijiazhuang Co., Ltd','2011-08-02 21:17:27',0,'121.29.132.113'),('corporate gifts','2011-08-07 09:37:33',0,'58.61.117.172'),('Paying for long term care','2011-10-28 03:45:07',0,'203.92.47.195'),('sinussurgerylosangeles.com','2011-12-02 16:35:15',4,'203.92.47.195'),('Hernialosangeles.com','2011-12-02 17:05:15',4,'203.92.47.195'),('Hernialosangeles.com','2011-12-02 17:05:22',4,'203.92.47.195'),('netkidswear.com','2011-12-28 06:56:56',2,'203.92.47.195'),('o ring...','2012-01-03 02:40:47',0,'218.17.145.134'),('shawcoremodeling.com','2012-01-20 02:43:25',1,'203.92.47.195'),('GrowingStars','2012-02-15 02:28:48',1,'203.92.47.195');

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

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

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

INSERT INTO `idx_sessions` VALUES ('e533543a2ab0159913de3c152b467bad',1331128179,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A27%3A%22%2Ftag%2Fgreen-cleaning-wichita%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.95%22%3B'),('5fe896bb67b97328737f69a72d7f991e',1331128327,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A28%3A%22%2Ftag%2Fgreen-cleaning-plymouth%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.139%22%3B'),('bb9ec8e44d8c6002f2d0abbe337bdbea',1331128476,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A32%3A%22%2Ftag%2Fgreen-cleaning-newport-news%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.140%22%3B'),('cbd23e5f827d7de9c3cedcd508c7f4cc',1331128624,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A31%3A%22%2Ftag%2Fgreen-cleaning-des-plaines%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.150%22%3B'),('31b5e7e324f8a0e7e48944dbca399165',1331128773,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A23%3A%22%2Ftag%2Ffurnace-pittsburgh%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.139%22%3B'),('19ee905b65577afe2c05a83304fbdf18',1331128922,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A114%3A%22%2Ftag%2Ffrac-water-disposal-frac-water-recovery-frac-water-treatment-produced-water-disposal-produced-water-treatment%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.6.232%22%3B'),('ffc1ae3e3abd46c7ef061b7dda19b3d9',1331129070,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A67%3A%22%2Ftag%2Ffire-pits-gas-logs-fire-tables-outdoor-fire-pits-gas-fire-logs%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.56%22%3B'),('1067c1be0141cb811b9f0a640c155bcf',1331129219,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A30%3A%22%2Ftag%2Ffence-contractor-portland%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.92%22%3B'),('04ea6bc6aad60f6f06ea13cab33bc794',1331129367,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A25%3A%22%2Ftag%2Fengineering-tyler-tx%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.55%22%3B'),('5c7f255d877fe1ca9547c2efd2b2ba34',1331129480,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A37%3A%22%2Ftag%2Fspecialty-chemical-manufacturing%22%3Bindexu_session_ip%7Cs%3A14%3A%22208.115.113.82%22%3B'),('e976b8070310a1ed87512a67019f79ed',1331129481,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A34%3A%22%2Ftag%2Fdumpster-rental-atlantic-city%22%3Bindexu_session_ip%7Cs%3A14%3A%22208.115.113.82%22%3B'),('9c2ddbb15e5a5fd2a5c6d99f0327e3f4',1331129483,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A46%3A%22%2Fdetail%2F3564%2Frenters-insurance-fort-worth.html%22%3Bindexu_session_ip%7Cs%3A14%3A%22208.115.113.82%22%3B'),('97dc9cb587eaa853b525f46c6d730ad6',1331129484,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A43%3A%22%2Fdetail%2F3391%2Funlocked-blackberry-phone.html%22%3Bindexu_session_ip%7Cs%3A14%3A%22208.115.113.82%22%3B'),('8d4e11464680c87c03a9924c7cb4f775',1331129485,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A49%3A%22%2Fdetail%2F3129%2Fbest-restaurants-in-westchester.html%22%3Bindexu_session_ip%7Cs%3A14%3A%22208.115.113.82%22%3B'),('ed0751ee0d8e6a1935913ac04a2baed6',1331129486,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A44%3A%22%2Fdetail%2F3001%2Forthodontists-frankfort-ky.html%22%3Bindexu_session_ip%7Cs%3A14%3A%22208.115.113.82%22%3B'),('8987142ef5026e31f549b1d156640c06',1331129487,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A41%3A%22%2Fdetail%2F2743%2Fmaid-services-henderson.html%22%3Bindexu_session_ip%7Cs%3A14%3A%22208.115.113.82%22%3B'),('2696e810907d6d7b17d2d11d3364c415',1331129489,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A45%3A%22%2Fdetail%2F2724%2Fcleaning-services-frederick.html%22%3Bindexu_session_ip%7Cs%3A14%3A%22208.115.113.82%22%3B'),('e199b4a9ca67a944ba5e3d5d59bf84f8',1331129517,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.101%22%3B'),('75b37db11d426eeb5275a5b275d2b531',1331129542,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A38%3A%22%2Fdetail%2F3791%2Fbasic-poker-strategy.html%22%3Bindexu_session_ip%7Cs%3A15%3A%22207.241.237.235%22%3B'),('ea990fed7deddbe51b5e986965782cf2',1331129666,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A30%3A%22%2Ftravel-vacation%2Fcharter-jets%2F%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.138%22%3B'),('360bf3729405d9814ffb64aea151aa10',1331129815,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A30%3A%22%2Ftag%2Fvinyl-windows-minneapolis%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.6.28%22%3B'),('c5b8f2b27bdcbcbb74c48a33a5f4c119',1331129959,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A11%3A%221.202.219.3%22%3B'),('a4e73eaff1b0699c348b6e3f62fde08e',1331129963,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A32%3A%22%2Ftag%2Fvinyl-siding-minneapolis-mn%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.155%22%3B'),('7f6799872bde06d824f06093972b3c6c',1331130130,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A22%3A%22%2Ftag%2Ffood-erp-software%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.98%22%3B'),('fd005854b773b37661367a0478e72df7',1331130281,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A40%3A%22%2Fdetail%2F2863%2Fcleaning-service-solon.html%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.6.225%22%3B'),('f8b9a2b43f97685da55c0faa3bb1557b',1331130420,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A34%3A%22%2Fdetail%2F3405%2Fweather-balloons.html%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.56%22%3B'),('e258b4e626adc0f62d7caf1cd981d5fd',1331130430,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A34%3A%22%2Ftag%2Fcharlotte-custom-home-builder%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.66%22%3B'),('e20c73db9aeaf86406df7fd2cc7ddcc4',1331130579,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A52%3A%22%2Fdetail%2F4020%2Fcolorado-criminal-defense-attorney.html%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.62%22%3B');

--
-- 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','YELLOWPAGELISTINGZ.COM'),(5,'site_url','http://www.yellowpagelistingz.com'),(6,'email_address','steve-taiylor@gmail.com'),(7,'language_code','en_US'),(8,'theme_path','/home/sanket/public_html/themes/'),(9,'admin_template_path','/home/sanket/public_html/admin_tpl/'),(10,'plugin_path','/home/sanket/public_html/plugin/'),(12,'active_theme','facing'),(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','1'),(26,'only_registered_can_add_review','1'),(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`
--


--
-- 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_users`
--

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

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

INSERT INTO `idx_users` VALUES ('admin','b7c0a086fd7fb859c0a4977e9c2e16a2','Administrator','steve-taiylor@gmail.com','2011-05-28','1','',0,'','','','','','','','');

--
-- 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`
--



