
--
-- 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 (2,'g',0,'2012-01-30'),(9,'g',0,'2012-01-10'),(21,'g',0,'2012-02-01'),(28,'g',0,'2012-01-14'),(23,'g',0,'2011-11-20'),(35,'g',0,'2012-01-10'),(26,'g',0,'2011-11-20'),(34,'g',0,'2012-01-10'),(42,'g',0,'2012-01-10'),(13,'g',0,'2011-11-20'),(27,'g',0,'2011-10-20'),(31,'g',0,'2011-10-26'),(37,'g',0,'2012-02-22'),(7,'g',0,'2012-03-06'),(38,'g',0,'2012-03-06'),(44,'g',0,'2012-02-22'),(12,'g',0,'2012-03-06'),(32,'g',0,'2012-01-17'),(15,'g',0,'2012-03-06'),(10,'g',0,'2012-03-06'),(40,'g',0,'2012-03-06'),(43,'g',0,'2012-03-06'),(22,'g',0,'2011-11-30'),(20,'g',0,'2011-12-02'),(29,'g',0,'2011-12-02'),(41,'g',0,'2012-02-24'),(5,'g',0,'2012-02-22'),(6,'g',0,'2012-02-22'),(19,'g',0,'2012-01-02'),(18,'g',0,'2012-02-22'),(39,'g',0,'2012-02-22'),(8,'g',0,'2012-01-10'),(11,'g',0,'2011-11-01'),(30,'g',0,'2012-02-23'),(3,'g',0,'2012-01-26'),(1,'g',0,'2012-01-26'),(16,'g',0,'2012-02-23'),(24,'g',0,'2011-12-22'),(4,'g',0,'2011-12-27'),(45,'g',0,'2012-03-02'),(17,'g',0,'2012-03-02'),(46,'g',0,'2012-03-02'),(36,'g',0,'2012-01-30'),(14,'g',0,'2012-02-22'),(33,'g',0,'2012-03-02'),(47,'g',0,'2011-11-04'),(25,'g',0,'2012-01-10'),(77,'g',0,'2011-11-14'),(225,'g',0,'2011-11-14'),(251,'g',0,'2012-03-03'),(179,'g',0,'2011-12-20'),(121,'g',0,'2011-11-14'),(255,'g',0,'2011-12-16'),(75,'g',0,'2012-01-30'),(83,'g',0,'2012-01-30'),(52,'g',0,'2012-01-30'),(48,'g',0,'2012-01-30'),(124,'g',0,'2012-01-30'),(155,'g',0,'2012-01-30'),(104,'g',0,'2012-01-30'),(114,'g',0,'2012-01-30'),(101,'g',0,'2012-01-30'),(130,'g',0,'2012-01-30'),(465,'g',0,'2011-11-14'),(84,'g',0,'2011-11-14'),(162,'g',0,'2011-11-14'),(449,'g',0,'2011-11-15'),(243,'g',0,'2011-11-16'),(252,'g',0,'2012-02-23'),(398,'g',0,'2012-02-23'),(133,'g',0,'2011-11-16'),(253,'g',0,'2012-02-17'),(244,'g',0,'2012-02-17'),(206,'g',0,'2012-02-29'),(89,'g',0,'2012-01-30'),(71,'g',0,'2012-01-30'),(217,'g',0,'2011-11-20'),(73,'g',0,'2012-01-30'),(248,'g',0,'2011-11-20'),(231,'g',0,'2011-12-23'),(125,'g',0,'2012-02-22'),(239,'g',0,'2011-12-22'),(331,'g',0,'2011-12-23'),(128,'g',0,'2012-02-22'),(483,'g',0,'2011-12-22'),(326,'g',0,'2012-02-22'),(404,'g',0,'2012-02-22'),(446,'g',0,'2012-02-22'),(460,'g',0,'2012-02-22'),(167,'g',0,'2012-01-30'),(226,'g',0,'2011-11-20'),(213,'g',0,'2012-01-30'),(263,'g',0,'2012-01-30'),(54,'g',0,'2012-01-10'),(68,'g',0,'2012-01-10'),(126,'g',0,'2011-11-20'),(90,'g',0,'2012-01-10'),(49,'g',0,'2012-03-06'),(82,'g',0,'2011-11-20'),(53,'g',0,'2012-02-01'),(153,'g',0,'2011-11-20'),(161,'g',0,'2011-11-20'),(129,'g',0,'2012-02-01'),(174,'g',0,'2011-11-20'),(374,'g',0,'2012-02-01'),(384,'g',0,'2011-11-20'),(425,'g',0,'2012-01-27'),(447,'g',0,'2012-02-01'),(475,'g',0,'2011-11-20'),(134,'g',0,'2012-01-26'),(360,'g',0,'2012-01-26'),(362,'g',0,'2012-01-26'),(268,'g',0,'2012-01-06'),(364,'g',0,'2012-01-26'),(276,'g',0,'2012-01-06'),(389,'g',0,'2012-01-06'),(365,'g',0,'2012-01-26'),(131,'g',0,'2011-11-20'),(170,'g',0,'2011-11-20'),(437,'g',0,'2012-03-06'),(368,'g',0,'2012-01-26'),(132,'g',0,'2012-02-01'),(242,'g',0,'2011-11-20'),(63,'g',0,'2012-01-24'),(55,'g',0,'2012-01-24'),(64,'g',0,'2012-01-24'),(80,'g',0,'2012-01-24'),(97,'g',0,'2012-01-24'),(141,'g',0,'2012-02-24'),(108,'g',0,'2012-02-24'),(479,'g',0,'2012-01-14'),(478,'g',0,'2011-12-23'),(67,'g',0,'2011-12-27'),(76,'g',0,'2011-12-26'),(94,'g',0,'2011-12-27'),(257,'g',0,'2012-01-26'),(136,'g',0,'2011-12-26'),(103,'g',0,'2011-12-27'),(199,'g',0,'2011-12-26'),(293,'g',0,'2011-12-27'),(203,'g',0,'2011-12-26'),(218,'g',0,'2011-12-26'),(79,'g',0,'2012-01-02'),(366,'g',0,'2012-01-26'),(442,'g',0,'2011-12-27'),(86,'g',0,'2012-01-02'),(99,'g',0,'2012-01-02'),(112,'g',0,'2012-01-02'),(107,'g',0,'2012-02-24'),(441,'g',0,'2011-12-26'),(51,'g',0,'2011-12-27'),(115,'g',0,'2012-01-30'),(118,'g',0,'2012-01-02'),(123,'g',0,'2012-01-30'),(154,'g',0,'2012-01-30'),(58,'g',0,'2011-12-27'),(394,'g',0,'2011-11-20'),(428,'g',0,'2011-11-20'),(461,'g',0,'2011-11-20'),(486,'g',0,'2011-11-20'),(488,'g',0,'2011-11-20'),(487,'g',0,'2011-11-20'),(93,'g',0,'2012-02-22'),(95,'g',0,'2012-02-22'),(98,'g',0,'2011-12-20'),(57,'g',0,'2012-02-22'),(59,'g',0,'2012-02-22'),(100,'g',0,'2011-12-20'),(105,'g',0,'2012-02-22'),(69,'g',0,'2012-02-22'),(195,'g',0,'2012-02-22'),(270,'g',0,'2012-02-22'),(321,'g',0,'2012-01-10'),(156,'g',0,'2011-12-27'),(158,'g',0,'2012-01-16'),(181,'g',0,'2012-01-16'),(202,'g',0,'2012-01-16'),(354,'g',0,'2012-01-16'),(65,'g',0,'2011-11-20'),(385,'g',0,'2012-01-16'),(109,'g',0,'2012-03-02'),(325,'g',0,'2012-02-26'),(56,'g',0,'2012-02-22'),(66,'g',0,'2012-01-05'),(337,'g',0,'2012-03-03'),(391,'g',0,'2012-01-05'),(346,'g',0,'2012-01-05'),(417,'g',0,'2012-01-05'),(176,'g',0,'2012-01-16'),(418,'g',0,'2012-01-05'),(60,'g',0,'2012-03-06'),(61,'g',0,'2012-01-14'),(397,'g',0,'2012-03-04'),(87,'g',0,'2012-03-02'),(413,'g',0,'2012-01-16'),(116,'g',0,'2012-01-14'),(50,'g',0,'2012-01-11'),(142,'g',0,'2012-03-02'),(445,'g',0,'2012-01-16'),(433,'g',0,'2012-03-04'),(117,'g',0,'2012-01-14'),(91,'g',0,'2012-01-11'),(110,'g',0,'2012-01-11'),(261,'g',0,'2012-01-14'),(111,'g',0,'2012-01-11'),(412,'g',0,'2012-01-14'),(301,'g',0,'2012-03-02'),(427,'g',0,'2012-01-14'),(138,'g',0,'2012-01-11'),(120,'g',0,'2012-01-11'),(140,'g',0,'2012-01-11'),(462,'g',0,'2012-01-14'),(152,'g',0,'2012-01-11'),(164,'g',0,'2012-01-11'),(318,'g',0,'2012-01-05'),(405,'g',0,'2012-01-05'),(272,'g',0,'2012-01-19'),(416,'g',0,'2012-01-05'),(300,'g',0,'2012-02-18'),(332,'g',0,'2011-11-20'),(419,'g',0,'2011-11-20'),(338,'g',0,'2011-11-20'),(339,'g',0,'2011-11-20'),(340,'g',0,'2011-11-20'),(344,'g',0,'2011-11-20'),(390,'g',0,'2011-11-20'),(407,'g',0,'2011-11-20'),(448,'g',0,'2011-11-20'),(468,'g',0,'2011-11-20'),(62,'g',0,'2012-02-22'),(85,'g',0,'2011-11-20'),(92,'g',0,'2012-02-15'),(137,'g',0,'2011-11-20'),(88,'g',0,'2012-02-15'),(183,'g',0,'2012-02-15'),(201,'g',0,'2012-02-15'),(205,'g',0,'2012-02-16'),(456,'g',0,'2012-02-16'),(221,'g',0,'2012-02-16'),(470,'g',0,'2012-02-16'),(245,'g',0,'2012-02-16'),(256,'g',0,'2012-02-15'),(291,'g',0,'2012-02-16'),(292,'g',0,'2012-02-16'),(264,'g',0,'2012-02-15'),(278,'g',0,'2012-02-15'),(289,'g',0,'2012-02-15'),(294,'g',0,'2012-02-16'),(297,'g',0,'2012-02-15'),(127,'g',0,'2012-02-15'),(303,'g',0,'2012-02-15'),(169,'g',0,'2011-11-20'),(306,'g',0,'2012-02-15'),(324,'g',0,'2012-02-15'),(171,'g',0,'2012-02-15'),(353,'g',0,'2012-02-16'),(363,'g',0,'2012-02-16'),(452,'g',0,'2012-02-16'),(386,'g',0,'2012-02-16'),(377,'g',0,'2012-02-16'),(392,'g',0,'2012-02-16'),(406,'g',0,'2012-02-15'),(408,'g',0,'2012-02-15'),(435,'g',0,'2012-02-15'),(424,'g',0,'2012-02-15'),(241,'g',0,'2012-02-16'),(444,'g',0,'2012-03-05'),(189,'g',0,'2012-02-11'),(197,'g',0,'2012-02-11'),(258,'g',0,'2012-02-15'),(220,'g',0,'2012-02-11'),(260,'g',0,'2011-11-20'),(236,'g',0,'2012-03-05'),(290,'g',0,'2012-03-05'),(295,'g',0,'2012-02-16'),(296,'g',0,'2012-02-16'),(327,'g',0,'2012-02-15'),(369,'g',0,'2012-02-10'),(400,'g',0,'2012-02-15'),(371,'g',0,'2012-02-10'),(375,'g',0,'2012-02-10'),(372,'g',0,'2012-02-10'),(379,'g',0,'2012-02-10'),(381,'g',0,'2012-02-10'),(383,'g',0,'2012-02-10'),(430,'g',0,'2012-03-05'),(283,'g',0,'2012-02-07'),(282,'g',0,'2012-02-07'),(471,'g',0,'2012-02-10'),(431,'g',0,'2012-02-10'),(172,'g',0,'2012-02-07'),(151,'g',0,'2012-02-07'),(285,'g',0,'2012-02-07'),(286,'g',0,'2012-02-07'),(287,'g',0,'2012-02-07'),(188,'g',0,'2012-02-07'),(222,'g',0,'2012-03-05'),(200,'g',0,'2012-02-07'),(310,'g',0,'2012-02-07'),(271,'g',0,'2012-02-07'),(313,'g',0,'2012-02-07'),(208,'g',0,'2012-01-24'),(273,'g',0,'2012-02-07'),(314,'g',0,'2012-02-07'),(219,'g',0,'2011-11-20'),(315,'g',0,'2012-02-07'),(230,'g',0,'2012-02-07'),(275,'g',0,'2012-02-07'),(233,'g',0,'2012-02-07'),(277,'g',0,'2012-02-07'),(249,'g',0,'2012-02-07'),(281,'g',0,'2012-02-07'),(280,'g',0,'2012-02-07'),(316,'g',0,'2012-02-07'),(317,'g',0,'2012-02-07'),(343,'g',0,'2012-02-07'),(319,'g',0,'2012-02-07'),(348,'g',0,'2012-02-07'),(350,'g',0,'2012-02-07'),(351,'g',0,'2012-02-07'),(382,'g',0,'2012-02-07'),(262,'g',0,'2012-02-07'),(265,'g',0,'2012-01-24'),(212,'g',0,'2012-02-07'),(415,'g',0,'2012-02-07'),(423,'g',0,'2012-02-07'),(274,'g',0,'2012-02-07'),(436,'g',0,'2012-02-07'),(469,'g',0,'2012-02-07'),(473,'g',0,'2012-02-07'),(474,'g',0,'2012-02-07'),(298,'g',0,'2012-02-09'),(309,'g',0,'2012-02-09'),(311,'g',0,'2012-02-09'),(347,'g',0,'2012-02-09'),(157,'g',0,'2011-11-20'),(387,'g',0,'2012-02-09'),(279,'g',0,'2012-02-07'),(388,'g',0,'2012-02-09'),(166,'g',0,'2011-11-20'),(342,'g',0,'2012-02-07'),(345,'g',0,'2012-02-07'),(402,'g',0,'2012-02-09'),(178,'g',0,'2011-11-20'),(349,'g',0,'2012-01-24'),(403,'g',0,'2012-02-09'),(204,'g',0,'2011-11-20'),(411,'g',0,'2012-02-09'),(238,'g',0,'2011-11-20'),(410,'g',0,'2011-11-20'),(439,'g',0,'2012-02-09'),(414,'g',0,'2012-02-07'),(451,'g',0,'2012-02-09'),(453,'g',0,'2012-02-09'),(467,'g',0,'2012-02-07'),(482,'g',0,'2012-02-09'),(484,'g',0,'2012-02-09'),(378,'g',0,'2012-02-09'),(196,'g',0,'2011-11-20'),(159,'g',0,'2011-11-20'),(198,'g',0,'2011-11-20'),(165,'g',0,'2011-11-20'),(223,'g',0,'2011-11-20'),(216,'g',0,'2011-11-20'),(269,'g',0,'2011-11-20'),(288,'g',0,'2011-11-20'),(307,'g',0,'2011-11-20'),(329,'g',0,'2011-11-20'),(399,'g',0,'2011-11-20'),(180,'g',0,'2012-03-01'),(184,'g',0,'2011-11-20'),(185,'g',0,'2011-11-20'),(224,'g',0,'2011-11-20'),(215,'g',0,'2011-11-20'),(187,'g',0,'2011-11-20'),(190,'g',0,'2011-11-20'),(191,'g',0,'2011-11-20'),(193,'g',0,'2011-11-20'),(472,'g',0,'2011-11-20'),(481,'g',0,'2012-02-15'),(234,'g',0,'2012-02-16'),(254,'g',0,'2012-02-16'),(266,'g',0,'2012-02-14'),(302,'g',0,'2012-02-14'),(304,'g',0,'2011-11-20'),(308,'g',0,'2012-02-14'),(320,'g',0,'2011-11-20'),(322,'g',0,'2011-11-20'),(328,'g',0,'2012-02-14'),(333,'g',0,'2012-02-14'),(194,'g',0,'2011-11-20'),(466,'g',0,'2012-02-15'),(477,'g',0,'2012-02-15'),(246,'g',0,'2012-02-15'),(247,'g',0,'2011-11-20'),(358,'g',0,'2012-02-15'),(359,'g',0,'2012-02-15'),(70,'g',0,'2011-11-20'),(145,'g',0,'2012-02-16'),(72,'g',0,'2012-02-15'),(146,'g',0,'2012-02-16'),(147,'g',0,'2012-02-16'),(370,'g',0,'2012-02-15'),(81,'g',0,'2012-02-15'),(186,'g',0,'2012-02-16'),(250,'g',0,'2012-02-16'),(323,'g',0,'2012-02-14'),(312,'g',0,'2012-02-14'),(106,'g',0,'2012-02-15'),(356,'g',0,'2012-02-14'),(150,'g',0,'2012-02-16'),(355,'g',0,'2012-02-14'),(192,'g',0,'2011-11-20'),(376,'g',0,'2011-11-20'),(160,'g',0,'2012-02-16'),(207,'g',0,'2012-02-16'),(395,'g',0,'2012-02-15'),(163,'g',0,'2012-02-16'),(113,'g',0,'2012-02-15'),(122,'g',0,'2012-02-15'),(357,'g',0,'2012-02-14'),(168,'g',0,'2012-02-16'),(139,'g',0,'2011-11-20'),(210,'g',0,'2012-02-15'),(409,'g',0,'2012-02-15'),(175,'g',0,'2012-02-16'),(211,'g',0,'2012-02-15'),(422,'g',0,'2011-11-20'),(143,'g',0,'2012-02-15'),(74,'g',0,'2012-02-15'),(148,'g',0,'2012-02-16'),(96,'g',0,'2012-02-15'),(149,'g',0,'2012-02-16'),(373,'g',0,'2012-02-15'),(457,'g',0,'2012-02-15'),(458,'g',0,'2012-02-15'),(232,'g',0,'2011-11-20'),(330,'g',0,'2011-11-20'),(334,'g',0,'2012-02-07'),(420,'g',0,'2011-11-20'),(352,'g',0,'2012-02-07'),(421,'g',0,'2011-11-20'),(432,'g',0,'2011-11-20'),(464,'g',0,'2012-02-21'),(235,'g',0,'2011-11-20'),(237,'g',0,'2011-11-20'),(434,'g',0,'2011-11-20'),(443,'g',0,'2011-11-20'),(455,'g',0,'2011-11-20'),(227,'g',0,'2011-11-20'),(259,'g',0,'2011-11-20'),(401,'g',0,'2011-11-20'),(393,'g',0,'2011-11-20'),(480,'g',0,'2011-11-20'),(102,'g',0,'2012-01-30'),(182,'g',0,'2011-11-22'),(507,'g',0,'2012-02-17'),(557,'g',0,'2011-11-30'),(560,'g',0,'2011-11-30'),(559,'g',0,'2011-11-30'),(601,'g',0,'2011-11-30'),(702,'g',0,'2011-11-30'),(500,'g',0,'2012-01-10'),(450,'g',0,'2012-01-14'),(578,'g',0,'2011-11-30'),(651,'g',0,'2011-11-30'),(701,'g',0,'2011-11-30'),(541,'g',0,'2011-11-30'),(463,'g',0,'2012-01-14'),(732,'g',0,'2011-12-01'),(632,'g',0,'2011-12-01'),(518,'g',0,'2011-12-02'),(498,'g',0,'2011-12-02'),(505,'g',0,'2012-01-17'),(511,'g',0,'2012-01-17'),(496,'g',0,'2012-01-17'),(522,'g',0,'2012-01-17'),(599,'g',0,'2011-12-02'),(490,'g',0,'2012-03-06'),(581,'g',0,'2011-12-03'),(703,'g',0,'2011-12-03'),(361,'g',0,'2012-02-22'),(426,'g',0,'2011-12-03'),(489,'g',0,'2012-01-16'),(497,'g',0,'2011-12-03'),(177,'g',0,'2012-02-22'),(119,'g',0,'2012-01-30'),(78,'g',0,'2012-01-30'),(135,'g',0,'2012-01-30'),(144,'g',0,'2012-01-11'),(493,'g',0,'2012-01-12'),(1327,'g',0,'2012-01-12'),(1678,'g',0,'2011-12-12'),(501,'g',0,'2012-01-16'),(1712,'g',0,'2011-12-12'),(1315,'g',0,'2011-12-13'),(1711,'g',0,'2011-12-16'),(1872,'g',0,'2012-01-30'),(1814,'g',0,'2011-12-16'),(1760,'g',0,'2011-12-16'),(1727,'g',0,'2011-12-16'),(1839,'g',0,'2011-12-16'),(1273,'g',0,'2011-12-16'),(1781,'g',0,'2011-12-16'),(1270,'g',0,'2011-12-16'),(1347,'g',0,'2011-12-16'),(173,'g',0,'2011-12-17'),(508,'g',0,'2012-02-01'),(1404,'g',0,'2011-12-17'),(1849,'g',0,'2012-03-03'),(1239,'g',0,'2012-03-03'),(1241,'g',0,'2012-02-25'),(1403,'g',0,'2012-03-03'),(1415,'g',0,'2012-01-24'),(1283,'g',0,'2012-03-03'),(1242,'g',0,'2012-03-03'),(1875,'g',0,'2012-02-22'),(1260,'g',0,'2012-02-23'),(1642,'g',0,'2012-02-23'),(1896,'g',0,'2012-02-22'),(1281,'g',0,'2011-12-22'),(1269,'g',0,'2011-12-22'),(1879,'g',0,'2011-12-22'),(1319,'g',0,'2011-12-22'),(1900,'g',0,'2012-03-04'),(1402,'g',0,'2011-12-23'),(1338,'g',0,'2012-03-04'),(1436,'g',0,'2011-12-23'),(1919,'g',0,'2011-12-23'),(267,'g',0,'2011-12-26'),(523,'g',0,'2011-12-26'),(512,'g',0,'2011-12-26'),(1948,'g',0,'2011-12-28'),(1969,'g',0,'2012-03-02'),(1935,'g',0,'2011-12-28'),(1928,'g',0,'2011-12-29'),(1912,'g',0,'2011-12-29'),(1920,'g',0,'2011-12-29'),(1263,'g',0,'2012-01-30'),(513,'g',0,'2011-12-31'),(1641,'g',0,'2011-12-31'),(1268,'g',0,'2011-12-31'),(1907,'g',0,'2011-12-31'),(1637,'g',0,'2011-12-31'),(1903,'g',0,'2011-12-31'),(1843,'g',0,'2011-12-31'),(1346,'g',0,'2011-12-31'),(1309,'g',0,'2011-12-31'),(1636,'g',0,'2011-12-31'),(1945,'g',0,'2012-01-01'),(1223,'g',0,'2012-02-19'),(1987,'g',0,'2012-02-23'),(1947,'g',0,'2012-02-23'),(1968,'g',0,'2012-01-04'),(2008,'g',0,'2012-02-23'),(1902,'g',0,'2012-01-05'),(2035,'g',0,'2012-01-07'),(2006,'g',0,'2012-01-12'),(1940,'g',0,'2012-01-14'),(1406,'g',0,'2012-01-14'),(2020,'g',0,'2012-01-15'),(2116,'g',0,'2012-01-21'),(1408,'g',0,'2012-01-24'),(2113,'g',0,'2012-01-24'),(1834,'g',0,'2012-01-24'),(1971,'g',0,'2012-01-24'),(2072,'g',0,'2012-01-24'),(2014,'g',0,'2012-01-24'),(1984,'g',0,'2012-01-24'),(1295,'g',0,'2012-01-26'),(1282,'g',0,'2012-01-26'),(1515,'g',0,'2012-01-26'),(1489,'g',0,'2012-01-26'),(1278,'g',0,'2012-01-26'),(2101,'g',0,'2012-01-26'),(1293,'g',0,'2012-01-26'),(1294,'g',0,'2012-01-26'),(1297,'g',0,'2012-01-26'),(1296,'g',0,'2012-01-26'),(1453,'g',0,'2012-01-26'),(1457,'g',0,'2012-01-26'),(1458,'g',0,'2012-01-26'),(1455,'g',0,'2012-01-26'),(1452,'g',0,'2012-01-26'),(1459,'g',0,'2012-01-26'),(1454,'g',0,'2012-01-26'),(1461,'g',0,'2012-01-26'),(1456,'g',0,'2012-01-26'),(1460,'g',0,'2012-01-26'),(1341,'g',0,'2012-01-26'),(1227,'g',0,'2012-01-26'),(1219,'g',0,'2012-01-26'),(1351,'g',0,'2012-01-26'),(1320,'g',0,'2012-01-26'),(1292,'g',0,'2012-01-26'),(1334,'g',0,'2012-01-26'),(1240,'g',0,'2012-01-26'),(1336,'g',0,'2012-01-26'),(1867,'g',0,'2012-01-26'),(1345,'g',0,'2012-01-26'),(2012,'g',0,'2012-01-26'),(1226,'g',0,'2012-01-26'),(1829,'g',0,'2012-01-26'),(1899,'g',0,'2012-01-26'),(1890,'g',0,'2012-01-26'),(1301,'g',0,'2012-01-26'),(1342,'g',0,'2012-01-26'),(1895,'g',0,'2012-01-26'),(1859,'g',0,'2012-01-26'),(1827,'g',0,'2012-01-26'),(1871,'g',0,'2012-01-26'),(1836,'g',0,'2012-01-26'),(1207,'g',0,'2012-01-26'),(1824,'g',0,'2012-01-26'),(1845,'g',0,'2012-01-26'),(1869,'g',0,'2012-01-26'),(1840,'g',0,'2012-01-26'),(1208,'g',0,'2012-01-26'),(2283,'g',0,'2012-01-31'),(2258,'g',0,'2012-02-06'),(1554,'g',0,'2012-02-06'),(1474,'g',0,'2012-02-06'),(1600,'g',0,'2012-02-06'),(1634,'g',0,'2012-02-06'),(1518,'g',0,'2012-02-06'),(1635,'g',0,'2012-02-06'),(1599,'g',0,'2012-02-06'),(1504,'g',0,'2012-02-06'),(1498,'g',0,'2012-02-06'),(1507,'g',0,'2012-02-06'),(1306,'g',0,'2012-02-06'),(1250,'g',0,'2012-02-06'),(1305,'g',0,'2012-02-06'),(1340,'g',0,'2012-02-06'),(1231,'g',0,'2012-02-06'),(1265,'g',0,'2012-02-06'),(1261,'g',0,'2012-02-06'),(1405,'g',0,'2012-02-06'),(1411,'g',0,'2012-02-06'),(1275,'g',0,'2012-02-06'),(1321,'g',0,'2012-02-06'),(1322,'g',0,'2012-02-06'),(1433,'g',0,'2012-02-06'),(1337,'g',0,'2012-02-06'),(1431,'g',0,'2012-02-06'),(1359,'g',0,'2012-02-06'),(1885,'g',0,'2012-02-06'),(1904,'g',0,'2012-02-06'),(2010,'g',0,'2012-02-06'),(1926,'g',0,'2012-02-06'),(1876,'g',0,'2012-02-06'),(1220,'g',0,'2012-02-06'),(1908,'g',0,'2012-02-06'),(1906,'g',0,'2012-02-06'),(1362,'g',0,'2012-02-06'),(1882,'g',0,'2012-02-06'),(1262,'g',0,'2012-02-06'),(2015,'g',0,'2012-02-06'),(1313,'g',0,'2012-02-06'),(1307,'g',0,'2012-02-06'),(1335,'g',0,'2012-02-06'),(1316,'g',0,'2012-02-06'),(2259,'g',0,'2012-02-06'),(1376,'g',0,'2012-02-06'),(1238,'g',0,'2012-02-06'),(1832,'g',0,'2012-02-06'),(1330,'g',0,'2012-02-06'),(1206,'g',0,'2012-02-06'),(2021,'g',0,'2012-02-06'),(1243,'g',0,'2012-02-06'),(2224,'g',0,'2012-02-06'),(1234,'g',0,'2012-02-06'),(1878,'g',0,'2012-02-06'),(1256,'g',0,'2012-02-06'),(1228,'g',0,'2012-02-06'),(1349,'g',0,'2012-02-06'),(1858,'g',0,'2012-02-06'),(1377,'g',0,'2012-02-06'),(1838,'g',0,'2012-02-06'),(2257,'g',0,'2012-02-06'),(1235,'g',0,'2012-02-06'),(1850,'g',0,'2012-02-06'),(1857,'g',0,'2012-02-06'),(1846,'g',0,'2012-02-06'),(1874,'g',0,'2012-02-06'),(1848,'g',0,'2012-02-06'),(1852,'g',0,'2012-02-06'),(1864,'g',0,'2012-02-06'),(1863,'g',0,'2012-02-06'),(1521,'g',0,'2012-02-06'),(1389,'g',0,'2012-02-06'),(1506,'g',0,'2012-02-06'),(1931,'g',0,'2012-02-06'),(1413,'g',0,'2012-02-06'),(1962,'g',0,'2012-02-06'),(1392,'g',0,'2012-02-06'),(1509,'g',0,'2012-02-06'),(1558,'g',0,'2012-02-06'),(2070,'g',0,'2012-02-06'),(284,'g',0,'2012-02-07'),(503,'g',0,'2012-02-07'),(2086,'g',0,'2012-02-07'),(1401,'g',0,'2012-02-07'),(1329,'g',0,'2012-02-07'),(1328,'g',0,'2012-02-07'),(1252,'g',0,'2012-02-07'),(1842,'g',0,'2012-02-07'),(1274,'g',0,'2012-02-07'),(1298,'g',0,'2012-02-08'),(476,'g',0,'2012-02-09'),(485,'g',0,'2012-02-09'),(509,'g',0,'2012-02-09'),(454,'g',0,'2012-02-09'),(459,'g',0,'2012-02-09'),(438,'g',0,'2012-02-10'),(1397,'g',0,'2012-02-11'),(1972,'g',0,'2012-02-11'),(1555,'g',0,'2012-02-11'),(1964,'g',0,'2012-02-11'),(1311,'g',0,'2012-02-11'),(1932,'g',0,'2012-02-11'),(1391,'g',0,'2012-02-11'),(1960,'g',0,'2012-02-11'),(1517,'g',0,'2012-02-11'),(1556,'g',0,'2012-02-11'),(1512,'g',0,'2012-02-11'),(1364,'g',0,'2012-02-11'),(2267,'g',0,'2012-02-11'),(2266,'g',0,'2012-02-11'),(2181,'g',0,'2012-02-11'),(1511,'g',0,'2012-02-11'),(2198,'g',0,'2012-02-11'),(2247,'g',0,'2012-02-11'),(2203,'g',0,'2012-02-11'),(2120,'g',0,'2012-02-11'),(1358,'g',0,'2012-02-11'),(1982,'g',0,'2012-02-11'),(1889,'g',0,'2012-02-11'),(1954,'g',0,'2012-02-11'),(1997,'g',0,'2012-02-11'),(1557,'g',0,'2012-02-11'),(1961,'g',0,'2012-02-11'),(1632,'g',0,'2012-02-11'),(1865,'g',0,'2012-02-14'),(2005,'g',0,'2012-02-14'),(2131,'g',0,'2012-02-14'),(2133,'g',0,'2012-02-14'),(2134,'g',0,'2012-02-14'),(2161,'g',0,'2012-02-14'),(2163,'g',0,'2012-02-14'),(2141,'g',0,'2012-02-14'),(2132,'g',0,'2012-02-14'),(2140,'g',0,'2012-02-14'),(2162,'g',0,'2012-02-14'),(2136,'g',0,'2012-02-14'),(2129,'g',0,'2012-02-14'),(2080,'g',0,'2012-02-14'),(2130,'g',0,'2012-02-14'),(2029,'g',0,'2012-02-14'),(2128,'g',0,'2012-02-14'),(2059,'g',0,'2012-02-14'),(2064,'g',0,'2012-02-14'),(2060,'g',0,'2012-02-14'),(2365,'g',0,'2012-02-14'),(1230,'g',0,'2012-02-14'),(1218,'g',0,'2012-02-14'),(1215,'g',0,'2012-02-14'),(1222,'g',0,'2012-02-14'),(1225,'g',0,'2012-02-14'),(1229,'g',0,'2012-02-14'),(1224,'g',0,'2012-02-14'),(1217,'g',0,'2012-02-15'),(1214,'g',0,'2012-02-15'),(1216,'g',0,'2012-02-15'),(1855,'g',0,'2012-02-15'),(1854,'g',0,'2012-02-15'),(1861,'g',0,'2012-02-15'),(1211,'g',0,'2012-02-15'),(1894,'g',0,'2012-02-15'),(1825,'g',0,'2012-02-15'),(1862,'g',0,'2012-02-15'),(440,'g',0,'2012-02-15'),(396,'g',0,'2012-02-15'),(2250,'g',0,'2012-02-15'),(517,'g',0,'2012-02-15'),(514,'g',0,'2012-02-15'),(506,'g',0,'2012-02-15'),(502,'g',0,'2012-02-15'),(516,'g',0,'2012-02-15'),(214,'g',0,'2012-02-15'),(228,'g',0,'2012-02-15'),(209,'g',0,'2012-02-15'),(1944,'g',0,'2012-02-15'),(2268,'g',0,'2012-02-15'),(2210,'g',0,'2012-02-15'),(2209,'g',0,'2012-02-15'),(2045,'g',0,'2012-02-15'),(2366,'g',0,'2012-02-16'),(2089,'g',0,'2012-02-16'),(499,'g',0,'2012-02-16'),(2187,'g',0,'2012-02-16'),(491,'g',0,'2012-02-16'),(492,'g',0,'2012-02-16'),(1289,'g',0,'2012-02-16'),(2376,'g',0,'2012-02-17'),(2355,'g',0,'2012-02-17'),(1302,'g',0,'2012-02-17'),(1434,'g',0,'2012-02-17'),(1826,'g',0,'2012-02-17'),(1633,'g',0,'2012-02-17'),(1638,'g',0,'2012-02-17'),(1853,'g',0,'2012-02-17'),(1213,'g',0,'2012-02-17'),(1429,'g',0,'2012-02-17'),(1303,'g',0,'2012-02-17'),(1929,'g',0,'2012-02-17'),(1473,'g',0,'2012-02-17'),(1510,'g',0,'2012-02-17'),(1462,'g',0,'2012-02-17'),(299,'g',0,'2012-02-18'),(1323,'g',0,'2012-02-18'),(1236,'g',0,'2012-02-18'),(1299,'g',0,'2012-02-18'),(1360,'g',0,'2012-02-18'),(1356,'g',0,'2012-02-18'),(1291,'g',0,'2012-02-18'),(1304,'g',0,'2012-02-18'),(1300,'g',0,'2012-02-18'),(1287,'g',0,'2012-02-18'),(1375,'g',0,'2012-02-18'),(1367,'g',0,'2012-02-18'),(1398,'g',0,'2012-02-18'),(1373,'g',0,'2012-02-18'),(1382,'g',0,'2012-02-18'),(1363,'g',0,'2012-02-18'),(1424,'g',0,'2012-02-18'),(1412,'g',0,'2012-02-18'),(1399,'g',0,'2012-02-18'),(1380,'g',0,'2012-02-18'),(2255,'g',0,'2012-02-19'),(2126,'g',0,'2012-02-19'),(2085,'g',0,'2012-02-19'),(1378,'g',0,'2012-02-19'),(1394,'g',0,'2012-02-19'),(1372,'g',0,'2012-02-19'),(1384,'g',0,'2012-02-19'),(1388,'g',0,'2012-02-19'),(1410,'g',0,'2012-02-19'),(1414,'g',0,'2012-02-19'),(2108,'g',0,'2012-02-19'),(2088,'g',0,'2012-02-19'),(2265,'g',0,'2012-02-19'),(2380,'g',0,'2012-02-20'),(2190,'g',0,'2012-02-20'),(2153,'g',0,'2012-02-20'),(2125,'g',0,'2012-02-20'),(2188,'g',0,'2012-02-20'),(2139,'g',0,'2012-02-20'),(2226,'g',0,'2012-02-20'),(2256,'g',0,'2012-02-20'),(2156,'g',0,'2012-02-20'),(2359,'g',0,'2012-02-20'),(2194,'g',0,'2012-02-20'),(2385,'g',0,'2012-02-20'),(2377,'g',0,'2012-02-20'),(2374,'g',0,'2012-02-20'),(2270,'g',0,'2012-02-20'),(2196,'g',0,'2012-02-20'),(2222,'g',0,'2012-02-20'),(2119,'g',0,'2012-02-20'),(2251,'g',0,'2012-02-20'),(2164,'g',0,'2012-02-21'),(2277,'g',0,'2012-02-21'),(2097,'g',0,'2012-02-21'),(2296,'g',0,'2012-02-21'),(2017,'g',0,'2012-02-21'),(1898,'g',0,'2012-02-21'),(2364,'g',0,'2012-02-22'),(2375,'g',0,'2012-02-22'),(2340,'g',0,'2012-02-22'),(2395,'g',0,'2012-02-22'),(2379,'g',0,'2012-02-23'),(1271,'g',0,'2012-02-23'),(1272,'g',0,'2012-02-23'),(2367,'g',0,'2012-02-23'),(1209,'g',0,'2012-02-23'),(2392,'g',0,'2012-02-25'),(2394,'g',0,'2012-02-25'),(2381,'g',0,'2012-02-26'),(2378,'g',0,'2012-02-29'),(2193,'g',0,'2012-03-01'),(2214,'g',0,'2012-03-01'),(2191,'g',0,'2012-03-01'),(2417,'g',0,'2012-03-03'),(2386,'g',0,'2012-03-05'),(2373,'g',0,'2012-03-05'),(335,'g',0,'2012-03-05'),(380,'g',0,'2012-03-05'),(2369,'g',0,'2012-03-05'),(429,'g',0,'2012-03-05'),(1331,'g',0,'2012-03-05'),(1354,'g',0,'2012-03-05'),(1333,'g',0,'2012-03-05'),(1344,'g',0,'2012-03-05'),(1249,'g',0,'2012-03-05'),(1833,'g',0,'2012-03-05'),(1352,'g',0,'2012-03-05'),(1212,'g',0,'2012-03-05'),(1355,'g',0,'2012-03-05'),(1343,'g',0,'2012-03-05'),(1481,'g',0,'2012-03-05'),(1444,'g',0,'2012-03-05'),(1443,'g',0,'2012-03-05'),(1486,'g',0,'2012-03-05'),(1946,'g',0,'2012-03-05'),(1480,'g',0,'2012-03-05'),(1488,'g',0,'2012-03-05'),(1479,'g',0,'2012-03-05'),(1487,'g',0,'2012-03-05'),(1483,'g',0,'2012-03-05'),(2416,'g',0,'2012-03-06'),(2280,'g',0,'2012-03-06'),(2117,'g',0,'2012-03-06'),(2308,'g',0,'2012-03-06'),(2071,'g',0,'2012-03-06'),(2106,'g',0,'2012-03-06'),(2441,'g',0,'2012-03-06'),(2076,'g',0,'2012-03-06'),(2213,'g',0,'2012-03-06'),(2291,'g',0,'2012-03-06'),(2372,'g',0,'2012-03-06'),(2426,'g',0,'2012-03-07'),(2411,'g',0,'2012-03-07'),(2195,'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`
--

INSERT INTO `idx_searchlog` VALUES ('chaseandchase.com','2011-11-23 05:32:56',0,'203.92.47.195'),('http://www.ableheatingandcooling.com','2011-11-30 01:24:12',1,'203.92.47.195');

--
-- 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 ('b1fd1a25ecd481ea48825ac0dd3ddb21',1331147254,NULL,'zWDXzYwv2mdxkSz0FtxA82m_t0U5LMtE83U3CYcLDGZs9ichQ8pyqwX6-dIQlZiHvp8PaariMoJ-kDdPTFigei5NPRuiE-tizgDI3pLLgoJjwfKnqRgRsyfq3NDwaiCR1aK3_CH2jWQQZU1NMWSFOsw8OXtL_QtRnpK367H1CPoeeC-zjFLywKHn66PcukOTPtRD3myxtjEeUkqbnUeCDA..'),('562cd1f444d51f3921148a335c8bb37c',1331147640,NULL,'ReHcGZCHe3DbwxqlXA0Jv5R3SxLyB2mUeadteCe-iHY3xfaDoxdTihrCOoKwiVIjxKmU414v5MD1IH1zWVyQ5KiQoxhhCK4jSQXgu4DkAKvaQxu0Up9VPNzMdGK3awSObveQy6lvRFqiwmWLkgfku7nIftrEgExlKQR5DgIv32F8LZcmz7OZNSbQrFEMzse2ASdvp0VJTLX8pPjhDkW19A..'),('ee7fbeda84d56caaac3ca4e536243477',1331147641,NULL,'BRrCpenH7b0esFL4tTWsDsCNBTUTBlwKS9ZZBV3-uVitAmYQ9uC9zudgsXlzJPCX27hMDpJX6CPKg6VV4vd_h8PWKaDo2r1zvTSyGfO4CRzAWD09Q6r1_u7KpOFZKzFZwWcjxZHI4dwEQ6E4-ZqMFsqf7gxnO_vwtolXOARJ0NHnr8l7bAK-wiPA4k9hAwJE'),('c56455ac548b771862ab21d89288455f',1331147644,NULL,'lZRU7NgIqlXB3jGUyf4R5MA6RvMQ7G-AR7Zzs5-Ewg64LTQUh-yjdqWEdzObmQ53uBUpLJ47mzcxjQA9a314rbzT6oWwSPG1yauIx_FyTKiZryGWyAzxBU-uP57rDQlqWcS34WFSMc-VSlZbkgk57fYlBT0j4iwHtfVst-BWHW_2x3awYeW5VBBySFKyFTNU1FZIwc5hubYozcKwqwau2w..'),('191ad6605280921f189c4875239a3d6d',1331147646,NULL,'LGZCkz1v1Ga4Pu7NdzP5vinm4RsuopAfKS9Ec0Dkof91LIpcq8sD3G9sKwpLB7s4VOLf_xUuhIYqhcR8NJMedckj26MubzH38bGyM9DOkX24qn-CiWDwC81tJWdqQSy_f9mXi967wF1ypTzmoqXjn8DF5rnCkc9acal5Hwb3raUUfICinlL1aLAtYhlvg9Ddl_mDqTLEXjAUihQqoWbmGQ..'),('913f497299edb55b9361d916c23dee67',1331147651,NULL,'EZC244T6j0otxrZE0SJ18s_SPd_f2Pl3RuRZQVwZK9dhjcYH1SLKSJIelOyovRGi17IBE2ndZPpfTHrcbY0sNRxwyPq7z2jnO-_Oinka8plclk2I49vKAtBNiX1LiVl2RF3JFI_gcKl2iQtFEbMnscDBr9NZfw9Dy3WdnZkwtDmt0AxzE0CaK-JKm9br5ZyV'),('dfe73d9a8198c851e6202a4b5d09cee1',1331147875,NULL,'LpGs12akH3QEojGseTaaAv6DmH1Er4KLRszTi4FxDqyMMoc3kqOORsl8X-7wzBAWycwlHjyVRDDJ-i6bNS_fKkc7yE3bhx1IRRODQJbTSYB2MFLWiXFqGQgYNt1mmdUxwWqusRTsvvqYcuH2NBvim_LjL4D6KepJGtESzGEHrPk.'),('c371dce315b0c0da915b195c3131f6eb',1331148465,NULL,'niw1Mx_ch6XA7kO9U9tUmJO3FF-aZ4DHhz3GI3E2eQta7k6Q9XrSMsbe9vA-XMs944or_NMy31ijBlGTegbLcseshnZmOYQa0j0OVyxd4Hdm_8NDgpmKzUMTkc0PVwOxk2SzQUQFTV_lYF8K26VMPYlLAq5jFZNq5M53wxUaGvvLDdm7a_zdK89WpTdvmfGzHznVYWW-Um6nhi0ZR05QUA..');

--
-- 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','referential.biz'),(5,'site_url','http://referential.biz'),(6,'email_address','toye.rosecrans@gmail.com	\r\n'),(7,'language_code','en_US'),(8,'theme_path','/home/referent/public_html/themes/'),(9,'admin_template_path','/home/referent/public_html/admin_tpl/'),(10,'plugin_path','/home/referent/public_html/plugin/'),(12,'active_theme','_referential'),(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','toye.rosecrans@gmail.com','2011-09-22','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`
--



