--
-- Host: localhost    Database: stpims5_seo628
-- ------------------------------------------------------


--
-- Table structure for table `auditorpagelinks`
--

CREATE TABLE `auditorpagelinks` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `report_id` bigint(20) NOT NULL,
  `link_url` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `link_anchor` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `link_title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `nofollow` tinyint(1) NOT NULL DEFAULT '0',
  `extrenal` tinyint(1) NOT NULL DEFAULT '0',
  `brocken` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `report_id` (`report_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `auditorpagelinks`
--


--
-- Table structure for table `auditorprojects`
--

CREATE TABLE `auditorprojects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `website_id` int(11) NOT NULL,
  `max_links` int(11) NOT NULL DEFAULT '500',
  `exclude_links` text COLLATE utf8_unicode_ci NOT NULL,
  `check_pr` tinyint(1) NOT NULL DEFAULT '0',
  `check_backlinks` tinyint(1) NOT NULL DEFAULT '0',
  `check_indexed` tinyint(1) NOT NULL DEFAULT '0',
  `store_links_in_page` tinyint(1) NOT NULL DEFAULT '0',
  `check_brocken` tinyint(1) NOT NULL DEFAULT '0',
  `score` float NOT NULL DEFAULT '0',
  `cron` tinyint(1) NOT NULL DEFAULT '1',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `website_id` (`website_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `auditorprojects`
--

INSERT INTO `auditorprojects` (`id`, `website_id`, `max_links`, `exclude_links`, `check_pr`, `check_backlinks`, `check_indexed`, `store_links_in_page`, `check_brocken`, `score`, `cron`, `status`) VALUES (1,1,500,'',1,1,1,0,1,-4.6385,1,1);

--
-- Table structure for table `auditorreports`
--

CREATE TABLE `auditorreports` (
  `id` bigint(24) NOT NULL AUTO_INCREMENT,
  `project_id` int(11) NOT NULL,
  `page_url` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `page_title` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
  `page_description` text COLLATE utf8_unicode_ci NOT NULL,
  `page_keywords` text COLLATE utf8_unicode_ci NOT NULL,
  `pagerank` float NOT NULL DEFAULT '0',
  `google_backlinks` int(11) NOT NULL DEFAULT '0',
  `bing_backlinks` int(11) NOT NULL DEFAULT '0',
  `google_indexed` int(11) NOT NULL DEFAULT '0',
  `bing_indexed` int(11) NOT NULL DEFAULT '0',
  `total_links` int(11) NOT NULL DEFAULT '0',
  `external_links` int(11) NOT NULL DEFAULT '0',
  `brocken` tinyint(1) NOT NULL DEFAULT '0',
  `crawled` tinyint(1) NOT NULL DEFAULT '0',
  `score` smallint(6) NOT NULL DEFAULT '0',
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `page_authority` float NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `project_id_2` (`project_id`,`page_url`),
  KEY `project_id` (`project_id`)
) ENGINE=MyISAM AUTO_INCREMENT=131 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `auditorreports`
--

INSERT INTO `auditorreports` (`id`, `project_id`, `page_url`, `page_title`, `page_description`, `page_keywords`, `pagerank`, `google_backlinks`, `bing_backlinks`, `google_indexed`, `bing_indexed`, `total_links`, `external_links`, `brocken`, `crawled`, `score`, `updated`, `page_authority`) VALUES (1,1,'http://stpims.com','DSCSA Compliance Starts Here | Streamline Technology PIMS System','The Path to DSCSA compliance starts here. Streamline Technology’s PIMS system is a comprehensive DSCSA compliant business solution.','',0,0,0,25,0,55,4,0,1,0,'2016-12-28 18:11:02',0),(2,1,'http://stpims.com/contact','Contact - Streamline Technology','','',0,0,0,1,0,26,4,0,1,-3,'2016-12-28 18:11:03',0),(3,1,'http://stpims.com/resources','Resources - Streamline Technology','','',0,0,0,1,0,29,6,0,1,-3,'2016-12-28 18:11:03',0),(4,1,'http://stpims.com/pims-overview','Drug Supply Chain Security Act | Streamline Technology','Streamline’s PIMS supports all Drug Supply Chain Security Act (DSCSA) requirements from Raw Materials and production, to fulfilment and sales.','',0,0,0,0,0,27,4,0,1,-1,'2016-12-28 18:11:03',0),(5,1,'http://stpims.com/pims-overview/dscsa-compliance','DSCSA Compliance Starts Here | Streamline Technology','The Drug Supply Chain Security Act details requirements for DSCSA Compliance (steps to track and trace prescription drugs sold/distributed in the US).','',0,0,0,0,0,27,4,0,1,-1,'2016-12-28 18:11:03',0),(6,1,'http://stpims.com/pims-overview/pharmaceutical-track-and-trace-materials-mgmt','Pharmaceutical Track and Trace | Streamline Techology','Fully serialized pharmaceutical track and trace, PIMS Materials Management goes well beyond just a procurement and perpetual inventory management system.','',0,0,0,1,0,27,4,0,1,1,'2016-12-28 18:11:03',0),(7,1,'http://stpims.com/pims-overview/work-in-progress','Pharmaceutical Serialization - WIP Solution | Streamline PIMS','As an early adopter of track and trace, Streamline implemented pharmaceutical serialization - WIP production and packaging solutions in 2009.','',0,0,0,0,0,27,4,0,1,-1,'2016-12-28 18:11:03',0),(8,1,'http://stpims.com/pims-overview/pharma-track-and-trace-interoperability','Pharma Track and Trace - Interoperability | Streamline Technology','Today, manufacturers and distributors operate in a highly regulated/competitive environment that relies on interoperable Pharma Track and Trace data.','',0,0,0,1,0,27,4,0,1,1,'2016-12-28 18:11:03',0),(9,1,'http://stpims.com/pharmaceutical-inventory-management','Pharmaceutical Inventory Management | Streamline Technology PIMS','PIMS Logistics, Pharmaceutical Inventory Management and Supply Chain solution is instrumental in meeting the requirements of DSCSA.','',0,0,0,1,0,27,4,0,1,1,'2016-12-28 18:11:03',0),(10,1,'http://stpims.com/dqsa-crmsales','DSQA Compliance | Streamline Techology PIMS CRM/Sales','PIMS supports all DSQA compliance requirements from purchase orders, invoicing and advanced shipment notice, and chargeback processing and response.','',0,0,0,1,0,27,4,0,1,1,'2016-12-28 18:11:03',0),(11,1,'http://stpims.com/about','About - Streamline Technology','','',0,0,0,1,0,27,4,0,1,-3,'2016-12-28 18:11:03',0),(12,1,'http://stpims.com/pims-overview/interoperability','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:11:03',0),(13,1,'http://stpims.com/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:11:03',0),(14,1,'http://stpims.com/about/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:11:29',0),(15,1,'http://stpims.com/contact/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:11:51',0),(16,1,'http://stpims.com/pims-overview/pharmaceutical-track-and-trace-materials-mgmt/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:12:14',0),(17,1,'http://stpims.com/feed','Streamline Technology','','',0,0,0,0,0,0,0,0,1,-5,'2016-12-28 18:12:36',0),(18,1,'http://stpims.com/comments/feed','Comments for Streamline Technology','','',0,0,0,0,0,0,0,0,1,-5,'2016-12-28 18:12:36',0),(19,1,'http://stpims.com/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:12:36',0),(20,1,'http://stpims.com/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:12:58',0),(21,1,'http://stpims.com/about/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:13:24',0),(22,1,'http://stpims.com/contact/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:13:47',0),(23,1,'http://stpims.com/pims-overview/interoperability/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:14:09',0),(24,1,'http://stpims.com/pims-overview/interoperability/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:14:31',0),(25,1,'http://stpims.com/pims-overview/pharma-track-and-trace-interoperability/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:14:54',0),(26,1,'http://stpims.com/pims-overview/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:15:38',0),(27,1,'http://stpims.com/dqsa-crmsales/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:16:02',0),(28,1,'http://stpims.com/pims-overview/interoperability/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:16:25',0),(29,1,'http://stpims.com/about/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:16:47',0),(30,1,'http://stpims.com/dqsa-crmsales/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:17:15',0),(31,1,'http://stpims.com/contact/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:17:38',0),(32,1,'http://stpims.com/dqsa-crmsales/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:18:01',0),(33,1,'http://stpims.com/about/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:18:24',0),(34,1,'http://stpims.com/pims-overview/interoperability/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:18:47',0),(35,1,'http://stpims.com/pims-overview/work-in-progress/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:19:10',0),(36,1,'http://stpims.com/pims-overview/pharmaceutical-track-and-trace-materials-mgmt/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:19:32',0),(37,1,'http://stpims.com/about/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:19:55',0),(38,1,'http://stpims.com/pims-overview/dscsa-compliance/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:20:18',0),(39,1,'http://stpims.com/pims-overview/dscsa-compliance/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:20:41',0),(40,1,'http://stpims.com/pims-overview/interoperability/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:21:04',0),(41,1,'http://stpims.com/contact/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:21:27',0),(42,1,'http://stpims.com/pims-overview/pharma-track-and-trace-interoperability/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:21:50',0),(43,1,'http://stpims.com/dqsa-crmsales/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:22:13',0),(44,1,'http://stpims.com/dqsa-crmsales/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:22:36',0),(45,1,'http://stpims.com/resources/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:22:59',0),(46,1,'http://stpims.com/pims-overview/interoperability/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:23:24',0),(47,1,'http://stpims.com/pims-overview/dscsa-compliance/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:23:47',0),(48,1,'http://stpims.com/resources/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:24:09',0),(49,1,'http://stpims.com/pims-overview/pharmaceutical-track-and-trace-materials-mgmt/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:24:55',0),(50,1,'http://stpims.com/pims-overview/pharmaceutical-track-and-trace-materials-mgmt/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:25:17',0),(51,1,'http://stpims.com/pims-overview/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:25:39',0),(52,1,'http://stpims.com/pims-overview/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:26:02',0),(53,1,'http://stpims.com/pims-overview/dscsa-compliance/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:26:25',0),(54,1,'http://stpims.com/pims-overview/work-in-progress/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:26:47',0),(55,1,'http://stpims.com/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:27:12',0),(56,1,'http://stpims.com/resources/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:27:35',0),(57,1,'http://stpims.com/dqsa-crmsales/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:27:59',0),(58,1,'http://stpims.com/resources/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:28:22',0),(59,1,'http://stpims.com/pims-overview/pharmaceutical-track-and-trace-materials-mgmt/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:28:45',0),(60,1,'http://stpims.com/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:29:08',0),(61,1,'http://stpims.com/pims-overview/work-in-progress/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:29:31',0),(62,1,'http://stpims.com/pims-overview/interoperability/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:29:54',0),(63,1,'http://stpims.com/pims-overview/work-in-progress/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:30:17',0),(64,1,'http://stpims.com/pims-overview/pharma-track-and-trace-interoperability/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:30:39',0),(65,1,'http://stpims.com/resources/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:31:03',0),(66,1,'http://stpims.com/pims-overview/work-in-progress/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:31:25',0),(67,1,'http://stpims.com/pims-overview/work-in-progress/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:31:49',0),(68,1,'http://stpims.com/pims-overview/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:32:12',0),(69,1,'http://stpims.com/pims-overview/work-in-progress/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:32:35',0),(70,1,'http://stpims.com/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:33:00',0),(71,1,'http://stpims.com/pims-overview/work-in-progress/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:33:26',0),(72,1,'http://stpims.com/pharmaceutical-inventory-management/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:33:49',0),(73,1,'http://stpims.com/dqsa-crmsales/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:34:13',0),(74,1,'http://stpims.com/contact/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:34:36',0),(75,1,'http://stpims.com/dqsa-crmsales/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:35:01',0),(76,1,'http://stpims.com/pims-overview/dscsa-compliance/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:35:24',0),(77,1,'http://stpims.com/pims-overview/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:35:47',0),(78,1,'http://stpims.com/pims-overview/interoperability/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:36:10',0),(79,1,'http://stpims.com/pims-overview/interoperability/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-746','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:36:34',0),(80,1,'http://stpims.com/pims-overview/work-in-progress/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-746','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:36:56',0),(81,1,'http://stpims.com/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:37:43',0),(82,1,'http://stpims.com/contact/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:38:06',0),(83,1,'http://stpims.com/pims-overview/pharmaceutical-track-and-trace-materials-mgmt/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:38:29',0),(84,1,'http://stpims.com/about/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:38:52',0),(85,1,'http://stpims.com/about/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:39:16',0),(86,1,'http://stpims.com/pharmaceutical-inventory-management/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:39:40',0),(87,1,'http://stpims.com/about/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:40:03',0),(88,1,'http://stpims.com/pharmaceutical-inventory-management/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:40:25',0),(89,1,'http://stpims.com/dqsa-crmsales/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:40:47',0),(90,1,'http://stpims.com/pims-overview/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:41:10',0),(91,1,'http://stpims.com/pims-overview/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:41:33',0),(92,1,'http://stpims.com/about/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:41:56',0),(93,1,'http://stpims.com/pharmaceutical-inventory-management/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:42:20',0),(94,1,'http://stpims.com/about/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:42:42',0),(95,1,'http://stpims.com/contact/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:43:05',0),(96,1,'http://stpims.com/pims-overview/dscsa-compliance/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:43:28',0),(97,1,'http://stpims.com/pims-overview/dscsa-compliance/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:44:13',0),(98,1,'http://stpims.com/about/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:84','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:44:36',0),(99,1,'http://stpims.com/pharmaceutical-inventory-management/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:44:58',0),(100,1,'http://stpims.com/pims-overview/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:45:21',0),(101,1,'http://stpims.com/contact/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:45:44',0),(102,1,'http://stpims.com/pims-overview/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:46:07',0),(103,1,'http://stpims.com/pims-overview/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-746','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:46:30',0),(104,1,'http://stpims.com/pims-overview/dscsa-compliance/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:47:16',0),(105,1,'http://stpims.com/pims-overview/dscsa-compliance/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-746','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:47:38',0),(106,1,'http://stpims.com/pims-overview/pharmaceutical-track-and-trace-materials-mgmt/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:48:46',0),(107,1,'http://stpims.com/dqsa-crmsales/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-746','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:49:09',0),(108,1,'http://stpims.com/pims-overview/pharma-track-and-trace-interoperability/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:49:31',0),(109,1,'http://stpims.com/pims-overview/pharmaceutical-track-and-trace-materials-mgmt/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:49:54',0),(110,1,'http://stpims.com/pharmaceutical-inventory-management/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:50:16',0),(111,1,'http://stpims.com/contact/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:50:39',0),(112,1,'http://stpims.com/resources/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:51:01',0),(113,1,'http://stpims.com/contact/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:51:24',0),(114,1,'http://stpims.com/pims-overview/pharma-track-and-trace-interoperability/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:51:46',0),(115,1,'http://stpims.com/resources/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:52:09',0),(116,1,'http://stpims.com/contact/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:52:32',0),(117,1,'http://stpims.com/resources/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:53:17',0),(118,1,'http://stpims.com/resources/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:53:40',0),(119,1,'http://stpims.com/resources/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:54:03',0),(120,1,'http://stpims.com/resources/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/te','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:54:26',0),(121,1,'http://stpims.com/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:55:11',0),(122,1,'http://stpims.com/pharmaceutical-inventory-management/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:55:34',0),(123,1,'http://stpims.com/pharmaceutical-inventory-management/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:55:56',0),(124,1,'http://stpims.com/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:56:19',0),(125,1,'http://stpims.com/pharmaceutical-inventory-management/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-34','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:57:04',0),(126,1,'http://stpims.com/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:57:27',0),(127,1,'http://stpims.com/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:58:34',0),(128,1,'http://stpims.com/pims-overview/pharma-track-and-trace-interoperability/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:58:57',0),(129,1,'http://stpims.com/pims-overview/pharma-track-and-trace-interoperability/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 18:59:42',0),(130,1,'http://stpims.com/pims-overview/pharma-track-and-trace-interoperability/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-343-7467/tel:844-3','Page not found - Streamline Technology','','',0,0,0,0,0,29,5,0,1,-5,'2016-12-28 19:00:05',0);

--
-- Table structure for table `backlinkresults`
--

CREATE TABLE `backlinkresults` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `website_id` int(11) NOT NULL,
  `google` int(11) NOT NULL,
  `msn` int(11) NOT NULL,
  `alexa` int(11) NOT NULL,
  `result_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `backlinkresults`
--


--
-- Table structure for table `country`
--

CREATE TABLE `country` (
  `country_code` char(2) COLLATE utf8_unicode_ci NOT NULL,
  `country_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`country_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `country`
--

INSERT INTO `country` (`country_code`, `country_name`) VALUES ('AD','Andorra'),('AE','United Arab Emirates'),('AF','Afghanistan'),('AG','Antigua and Barbuda'),('AI','Anguilla'),('AL','Albania'),('AM','Armenia'),('AN','Netherlands Antilles'),('AO','Angola'),('AP','Asia/Pacific Region'),('AQ','Antarctica'),('AR','Argentina'),('AS','American Samoa'),('AT','Austria'),('AU','Australia'),('AW','Aruba'),('AX','Aland Islands'),('AZ','Azerbaijan'),('BA','Bosnia and Herzegovina'),('BB','Barbados'),('BD','Bangladesh'),('BE','Belgium'),('BF','Burkina Faso'),('BG','Bulgaria'),('BH','Bahrain'),('BI','Burundi'),('BJ','Benin'),('BM','Bermuda'),('BN','Brunei Darussalam'),('BO','Bolivia'),('BR','Brazil'),('BS','Bahamas'),('BT','Bhutan'),('BV','Bouvet Island'),('BW','Botswana'),('BY','Belarus'),('BZ','Belize'),('CA','Canada'),('CC','Cocos (Keeling) Islands'),('CD','Congo'),('CF','Central African Republic'),('CG','Congo'),('CH','Switzerland'),('CI','Cote d\'Ivoire'),('CK','Cook Islands'),('CL','Chile'),('CM','Cameroon'),('CN','China'),('CO','Colombia'),('CR','Costa Rica'),('CU','Cuba'),('CV','Cape Verde'),('CX','Christmas Island'),('CY','Cyprus'),('CZ','Czech Republic'),('DE','Germany'),('DJ','Djibouti'),('DK','Denmark'),('DM','Dominica'),('DO','Dominican Republic'),('DZ','Algeria'),('EC','Ecuador'),('EE','Estonia'),('EG','Egypt'),('EH','Western Sahara'),('ER','Eritrea'),('ES','Spain'),('ET','Ethiopia'),('EU','Europe'),('FI','Finland'),('FJ','Fiji'),('FK','Falkland Islands (Malvinas)'),('FM','Micronesia Federated States of'),('FO','Faroe Islands'),('FR','France'),('GA','Gabon'),('GB','United Kingdom'),('GD','Grenada'),('GE','Georgia'),('GF','French Guiana'),('GG','Guernsey'),('GH','Ghana'),('GI','Gibraltar'),('GL','Greenland'),('GM','Gambia'),('GN','Guinea'),('GP','Guadeloupe'),('GQ','Equatorial Guinea'),('GR','Greece'),('GS','South Georgia and the South Sandwich Islands'),('GT','Guatemala'),('GU','Guam'),('GW','Guinea-Bissau'),('GY','Guyana'),('HK','Hong Kong'),('HM','Heard Island and McDonald Islands'),('HN','Honduras'),('HR','Croatia'),('HT','Haiti'),('HU','Hungary'),('ID','Indonesia'),('IE','Ireland'),('IL','Israel'),('IM','Isle of Man'),('IN','India'),('IO','British Indian Ocean Territory'),('IQ','Iraq'),('IR','Iran Islamic Republic of'),('IS','Iceland'),('IT','Italy'),('JE','Jersey'),('JM','Jamaica'),('JO','Jordan'),('JP','Japan'),('KE','Kenya'),('KG','Kyrgyzstan'),('KH','Cambodia'),('KI','Kiribati'),('KM','Comoros'),('KN','Saint Kitts and Nevis'),('KP','Korea Democratic People\'s Republic of'),('KR','Korea Republic of'),('KW','Kuwait'),('KY','Cayman Islands'),('KZ','Kazakhstan'),('LA','Lao People\'s Democratic Republic'),('LB','Lebanon'),('LC','Saint Lucia'),('LI','Liechtenstein'),('LK','Sri Lanka'),('LR','Liberia'),('LS','Lesotho'),('LT','Lithuania'),('LU','Luxembourg'),('LV','Latvia'),('LY','Libyan Arab Jamahiriya'),('MA','Morocco'),('MC','Monaco'),('MD','Moldova Republic of'),('ME','Montenegro'),('MG','Madagascar'),('MH','Marshall Islands'),('MK','Macedonia'),('ML','Mali'),('MM','Myanmar'),('MN','Mongolia'),('MO','Macao'),('MP','Northern Mariana Islands'),('MQ','Martinique'),('MR','Mauritania'),('MS','Montserrat'),('MT','Malta'),('MU','Mauritius'),('MV','Maldives'),('MW','Malawi'),('MX','Mexico'),('MY','Malaysia'),('MZ','Mozambique'),('NA','Namibia'),('NC','New Caledonia'),('NE','Niger'),('NF','Norfolk Island'),('NG','Nigeria'),('NI','Nicaragua'),('NL','Netherlands'),('NO','Norway'),('NP','Nepal'),('NR','Nauru'),('NU','Niue'),('NZ','New Zealand'),('OM','Oman'),('PA','Panama'),('PE','Peru'),('PF','French Polynesia'),('PG','Papua New Guinea'),('PH','Philippines'),('PK','Pakistan'),('PL','Poland'),('PM','Saint Pierre and Miquelon'),('PN','Pitcairn'),('PR','Puerto Rico'),('PS','Palestinian Territory'),('PT','Portugal'),('PW','Palau'),('PY','Paraguay'),('QA','Qatar'),('RE','Reunion'),('RO','Romania'),('RS','Serbia'),('RU','Russian Federation'),('RW','Rwanda'),('SA','Saudi Arabia'),('SB','Solomon Islands'),('SC','Seychelles'),('SD','Sudan'),('SE','Sweden'),('SG','Singapore'),('SH','Saint Helena'),('SI','Slovenia'),('SJ','Svalbard and Jan Mayen'),('SK','Slovakia'),('SL','Sierra Leone'),('SM','San Marino'),('SN','Senegal'),('SO','Somalia'),('SR','Suriname'),('ST','Sao Tome and Principe'),('SV','El Salvador'),('SY','Syrian Arab Republic'),('SZ','Swaziland'),('TC','Turks and Caicos Islands'),('TD','Chad'),('TF','French Southern Territories'),('TG','Togo'),('TH','Thailand'),('TJ','Tajikistan'),('TK','Tokelau'),('TL','Timor-Leste'),('TM','Turkmenistan'),('TN','Tunisia'),('TO','Tonga'),('TR','Turkey'),('TT','Trinidad and Tobago'),('TV','Tuvalu'),('TW','Taiwan'),('TZ','Tanzania United Republic of'),('UA','Ukraine'),('UG','Uganda'),('UM','United States Minor Outlying Islands'),('US','United States'),('UY','Uruguay'),('UZ','Uzbekistan'),('VA','Holy See (Vatican City State)'),('VC','Saint Vincent and the Grenadines'),('VE','Venezuela'),('VG','Virgin Islands British'),('VI','Virgin Islands U.S.'),('VN','Vietnam'),('VU','Vanuatu'),('WF','Wallis and Futuna'),('WS','Samoa'),('YE','Yemen'),('YT','Mayotte'),('ZA','South Africa'),('ZM','Zambia'),('ZW','Zimbabwe');

--
-- Table structure for table `currency`
--

CREATE TABLE `currency` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(160) COLLATE utf8_unicode_ci NOT NULL,
  `iso_code` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `symbol` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `unicode` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
  `position` varchar(6) COLLATE utf8_unicode_ci NOT NULL,
  `paypal` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `iso_code` (`iso_code`)
) ENGINE=MyISAM AUTO_INCREMENT=68 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `currency`
--

INSERT INTO `currency` (`id`, `name`, `iso_code`, `symbol`, `unicode`, `position`, `paypal`, `status`) VALUES (1,'United Arab Emirates Dirham','AED','Ø¯.','','after',0,1),(2,'Netherlands Antillian Guilder','ANG','Æ’','&#x0192;','before',0,1),(3,'','AOA','AOA','AOA','before',0,1),(4,'Argentine Peso','ARS','$','&#36;','before',0,1),(5,'Australian Dollar','AUD','$','&#36;','before',1,1),(6,'','BAM','KM','KM','before',0,1),(7,'Barbados Dollar','BBD','$','&#36;','before',0,1),(8,'','BGL','Ð»Ð','&#1083;&','before',0,1),(9,'Bahraini Dinar','BHD','BD','BD','after',0,1),(10,'Brunei Dollar','BND','$','&#36;','before',0,1),(11,'Brazilian Real','BRL','R$','R&#36;','before',1,1),(12,'Canadian Dollar','CAD','$','&#36;','before',1,1),(13,'Swiss Franc','CHF','Fr','Fr','before',1,1),(14,'Chilean Unidades de Fomento','CLF','UF','UF','after',0,1),(15,'Chilean Peso','CLP','$','&#36;','before',0,1),(16,'Yuan (Chinese) Renminbi','CNY','Â¥','&#165;','before',0,1),(17,'Colombian Peso','COP','$','&#36;','before',0,1),(18,'Costa Rican Colon','CRC','â‚¡','&#x20A1;','before',0,1),(19,'Czech Republic Koruna','CZK','KÄ','K&#269;','after',1,1),(20,'Danish Krone','DKK','kr','kr','before',1,1),(21,'Estonian Kroon (EEK)','EEK','KR','KR','before',0,1),(22,'Egyptian Pound','EGP','EÂ£','E&#163;','before',0,1),(23,'Euro','EUR','â‚¬','&#128;','before',1,1),(24,'Fiji Dollar','FJD','FJ$','FJ&#36;','before',0,1),(25,'British Pound','GBP','Â£','&#163;','before',1,1),(26,'Guatemalan Quetzal','GTQ','Q','Q','before',0,1),(27,'Hong Kong Dollar','HKD','$','&#36;','before',1,1),(28,'','HRK','kn','kn','before',0,1),(29,'Hungarian Forint','HUF','Ft','Ft','before',1,1),(30,'Indonesian Rupiah','IDR','Rp','Rp','before',0,1),(31,'Israeli Shekel','ILS','â‚ª','&#x20AA;','before',1,1),(32,'Indian Rupee','INR','Rs','Rs','before',0,1),(33,'Jordanian Dinar','JOD','Ø¯.','','',0,1),(34,'Japanese Yen','JPY','Â¥','&#165;','before',1,1),(35,'Kenyan Schilling','KES','KSh','Ksh','before',0,1),(36,'(South) Korean Won','KRW','â‚©','&#x20A9;','before',0,1),(37,'Kuwaiti Dinar','KWD','KD','KD','after',0,1),(38,'Cayman Islands Dollar','KYD','$','&#36;','before',0,1),(39,'','LTL','Lt','Lt','before',0,1),(40,'','LVL','Ls','Ls','before',0,1),(41,'Moroccan Dirham','MAD','Ø¯.','','',0,1),(42,'Maldive Rufiyaa','MVR','Rf','Rf','before',0,1),(43,'','MXN','$','&#36;','before',1,1),(44,'Malaysian Ringgit','MYR','RM','RM','before',1,1),(45,'Nigerian Naira','NGN','â‚¦','&#x20A6;','before',0,1),(46,'Norwegian Kroner','NOK','kr','kr','before',1,1),(47,'New Zealand Dollar','NZD','$','&#36;','before',1,1),(48,'Omani Rial','OMR','OMR','&#65020;','after',0,1),(49,'Peruvian Nuevo Sol','PEN','S/.','S/.','before',0,1),(50,'Philippine Peso','PHP','â‚±','&#x20B1;','before',1,1),(51,'Polish Zloty','PLN','zÅ‚','Z&#322;','before',1,1),(52,'Qatari Rial','QAR','QAR','&#65020;','after',0,1),(53,'Romanian Leu','RON','lei','lei','before',0,1),(54,'Russian Ruble','RUB','Ñ€Ñ','&#1088;&','before',1,1),(55,'Saudi Arabian Riyal','SAR','SAR','&#65020;','after',0,1),(56,'Swedish Krona','SEK','kr','kr','before',1,1),(57,'Singapore Dollar','SGD','$','&#36;','before',1,1),(58,'Thai Baht','THB','à¸¿','&#322;','before',1,1),(59,'Turkish Lira','TRY','TL','TL','before',1,1),(60,'Trinidad and Tobago Dollar','TTD','$','&#36;','before',0,1),(61,'Taiwan Dollar','TWD','$','&#36;','before',0,1),(62,'','UAH','â‚´','&#8372;','before',0,1),(63,'US Dollar','USD','$','&#36;','before',1,1),(64,'Venezualan Bolivar','VEF','Bs ','Bs.','before',0,1),(65,'Vietnamese Dong','VND','â‚«','&#x20AB;','before',0,1),(66,'East Caribbean Dollar','XCD','$','&#36;','before',0,1),(67,'South African Rand','ZAR','R','R','before',0,1);

--
-- Table structure for table `di_directory_meta`
--

CREATE TABLE `di_directory_meta` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `captcha_script` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT 'captcha.php',
  `search_script` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT 'index.php?q=[--keyword--]',
  `title_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'TITLE',
  `url_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'URL',
  `description_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'DESCRIPTION',
  `name_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'OWNER_NAME',
  `email_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'OWNER_EMAIL',
  `category_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'CATEGORY_ID',
  `cptcha_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'CAPTCHA',
  `imagehash_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'IMAGEHASH',
  `imagehashurl_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'imagehash',
  `reciprocal_col` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'RECPR_URL',
  `extra_val` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT 'LINK_TYPE=normal&submit=Continue&AGREERULES=on',
  `link_type_col` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'LINK_TYPE',
  `normal` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'normal',
  `free` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'free',
  `reciprocal` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'reciprocal',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `di_directory_meta`
--

INSERT INTO `di_directory_meta` (`id`, `name`, `captcha_script`, `search_script`, `title_col`, `url_col`, `description_col`, `name_col`, `email_col`, `category_col`, `cptcha_col`, `imagehash_col`, `imagehashurl_col`, `reciprocal_col`, `extra_val`, `link_type_col`, `normal`, `free`, `reciprocal`, `status`) VALUES (1,'phpLD','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=[--type--]&submit=Continue&AGREERULES=on','LINK_TYPE','normal','free','reciprocal',1);

--
-- Table structure for table `directories`
--

CREATE TABLE `directories` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `domain` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `submit_url` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `captcha_script` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT 'captcha.php',
  `search_script` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT 'index.php?q=[--keyword--]',
  `title_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'TITLE',
  `url_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'URL',
  `description_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'DESCRIPTION',
  `name_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'OWNER_NAME',
  `email_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'OWNER_EMAIL',
  `category_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'CATEGORY_ID',
  `cptcha_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'CAPTCHA',
  `imagehash_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'IMAGEHASH',
  `imagehashurl_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'imagehash',
  `reciprocal_col` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'RECPR_URL',
  `extra_val` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT 'LINK_TYPE=normal&submit=Continue&AGREERULES=on',
  `is_captcha` tinyint(1) NOT NULL DEFAULT '0',
  `working` tinyint(1) NOT NULL DEFAULT '1',
  `google_pagerank` smallint(6) NOT NULL DEFAULT '0',
  `alexa_rank` int(11) NOT NULL DEFAULT '-1',
  `lang_code` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en',
  `checked` tinyint(1) NOT NULL DEFAULT '0',
  `script_type_id` int(11) NOT NULL DEFAULT '1',
  `rank` int(11) NOT NULL DEFAULT '0',
  `is_reciprocal` tinyint(1) NOT NULL DEFAULT '0',
  `pagerank` float NOT NULL DEFAULT '0',
  `domain_authority` float NOT NULL,
  `page_authority` float NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `submit_url` (`submit_url`)
) ENGINE=MyISAM AUTO_INCREMENT=160 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `directories`
--

INSERT INTO `directories` (`id`, `domain`, `submit_url`, `captcha_script`, `search_script`, `title_col`, `url_col`, `description_col`, `name_col`, `email_col`, `category_col`, `cptcha_col`, `imagehash_col`, `imagehashurl_col`, `reciprocal_col`, `extra_val`, `is_captcha`, `working`, `google_pagerank`, `alexa_rank`, `lang_code`, `checked`, `script_type_id`, `rank`, `is_reciprocal`, `pagerank`, `domain_authority`, `page_authority`) VALUES (145,'http://www.listasweb.info','http://www.listasweb.info/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(144,'http://www.oroop.com','http://www.oroop.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(143,'http://www.webdirectorybook.com','http://www.webdirectorybook.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(142,'http://www.westcelt.org','http://www.westcelt.org/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(141,'http://www.wishdc.org','http://www.wishdc.org/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',1,1,0,-1,'en',1,1,0,0,5.26,31.92,43.14),(140,'http://www.w3c-software.com','http://www.w3c-software.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(139,'http://www.interactive-directory.com','http://www.interactive-directory.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(138,'http://www.go2directory.info','http://www.go2directory.info/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(137,'http://www.firstfindengine.com','http://www.firstfindengine.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.firstfindengine.com',0,0,1,-1,'en',1,1,0,0,0,0,0),(136,'http://www.faceahead.com','http://www.faceahead.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(135,'http://www.extreme-directory.net','http://www.extreme-directory.net/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(134,'http://www.minidirectory.info','http://www.minidirectory.info/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(133,'http://www.lexormedia.com','http://www.lexormedia.com/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(132,'http://www.easyadsworld.com','http://www.easyadsworld.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(131,'http://www.corporategoof.com','http://www.corporategoof.com/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(130,'http://www.seodir.eu','http://www.seodir.eu/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(129,'http://www.directorydr.com','http://www.directorydr.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(128,'http://directorywind.com','http://directorywind.com/submit.php?LINK_TYPE=2','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=2&submit=Continue&AGREERULES=on',0,0,3,-1,'en',1,1,0,0,0,0,0),(127,'http://www.visuallinkdirectory.com','http://www.visuallinkdirectory.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(126,'http://www.thecommercialdirectory.com','http://www.thecommercialdirectory.com/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(125,'http://www.freeonlineregister.com','http://www.freeonlineregister.com/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.freeonlineregister.com',0,0,1,-1,'en',1,1,0,0,0,0,0),(124,'http://www.vccllc.com','http://www.vccllc.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(123,'http://www.findinfo.ws','http://www.findinfo.ws/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,3,-1,'en',1,1,0,0,0,0,0),(122,'http://www.devdir.biz','http://www.devdir.biz/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.devdir.biz',0,0,0,-1,'en',1,1,0,0,0,0,0),(121,'http://www.stepmind.com','http://www.stepmind.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(120,'http://www.edirectori.com','http://www.edirectori.com/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(119,'http://www.netnamesindex.com','http://www.netnamesindex.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.netnamesindex.com',0,0,0,-1,'en',1,1,0,0,0,0,0),(117,'http://www.worldurllink.com','http://www.worldurllink.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.worldurllink.com',0,0,2,-1,'en',1,1,0,0,0,0,0),(116,'http://www.websitelists.info','http://www.websitelists.info/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(115,'http://www.urlvault.info','http://www.urlvault.info/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.urlvault.info',0,0,2,-1,'en',1,1,0,0,0,0,0),(114,'http://www.seolistsite.com','http://www.seolistsite.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.seolistsite.com',0,0,1,-1,'en',1,1,0,0,0,0,0),(113,'http://www.searchpowertour.com','http://www.searchpowertour.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.searchpowertour.com',0,0,0,-1,'en',1,1,0,0,0,0,0),(112,'http://www.netdirectorylink.com','http://www.netdirectorylink.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(111,'http://www.monsterlinkdirectory.com','http://www.monsterlinkdirectory.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.monsterlinkdirectory.com',0,0,0,-1,'en',1,1,0,0,0,0,0),(110,'http://www.inlinkdirectory.com','http://www.inlinkdirectory.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.inlinkdirectory.com',0,0,0,-1,'en',1,1,0,0,0,0,0),(109,'http://www.heydirectory.com','http://www.heydirectory.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,3,-1,'en',1,1,0,0,0,0,0),(108,'http://www.generalnetdirectory.com','http://www.generalnetdirectory.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(107,'http://www.freeweblist.info','http://www.freeweblist.info/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(106,'http://www.freeonlineindex.com','http://www.freeonlineindex.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.freeonlineindex.com',0,0,0,-1,'en',1,1,0,0,0,0,0),(104,'http://www.directoryfreelink.com','http://www.directoryfreelink.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.directoryfreelink.com',0,0,0,-1,'en',1,1,0,0,0,0,0),(103,'http://www.cheapwebdir.com','http://www.cheapwebdir.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(102,'http://www.anyweblist.com','http://www.anyweblist.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.anyweblist.com',0,0,2,-1,'en',1,1,0,0,0,0,0),(101,'http://www.zerotres.com','http://www.zerotres.com/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(100,'http://www.thehdb.com','http://www.thehdb.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(99,'http://www.linkfly.info','http://www.linkfly.info/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=free&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(98,'http://www.jordangreen.info','http://www.jordangreen.info/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=free&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(97,'http://www.ggfb.org','http://www.ggfb.org/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(96,'http://www.etup.org','http://www.etup.org/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(94,'http://z0p.com','http://z0p.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(93,'http://www.yournetdirectory.com','http://www.yournetdirectory.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(92,'http://www.teacherslounge.info','http://www.teacherslounge.info/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(91,'http://www.homessearchengine.com','http://www.homessearchengine.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(90,'http://www.zzdirectory.com','http://www.zzdirectory.com/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(89,'http://www.liveurls.net','http://www.liveurls.net/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(88,'http://www.agrieducation.org','http://www.agrieducation.org/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,1,3,-1,'en',1,1,0,0,5.65,39.77,49.86),(87,'http://www.freewd.org','http://www.freewd.org/submit.php?LINK_TYPE=2','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=2&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(86,'http://www.coolwebsitelistings.com','http://www.coolwebsitelistings.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(85,'http://www.ns8.biz','http://www.ns8.biz/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(84,'http://www.gfxmedia.us','http://www.gfxmedia.us/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(83,'http://www.biowatchmed.net','http://www.biowatchmed.net/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(82,'http://www.lemurgene.com','http://www.lemurgene.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(80,'http://www.tuenschel.com','http://www.tuenschel.com/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.tuenschel.com',0,0,0,-1,'en',1,1,0,0,0,0,0),(79,'http://www.migliana.com','http://www.migliana.com/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.migliana.com',0,0,2,-1,'en',1,1,0,0,0,0,0),(78,'http://www.prolificpi.com','http://www.prolificpi.com/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.prolificpi.com',0,0,0,-1,'en',1,1,0,0,0,0,0),(77,'http://www.mymaxlinks.info','http://www.mymaxlinks.info/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(76,'http://www.counterdeal.com','http://www.counterdeal.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on',0,0,3,-1,'en',1,1,0,0,0,0,0),(73,'http://www.mytopdirectory.info','http://www.mytopdirectory.info/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(72,'http://www.thelivinglink.net','http://www.thelivinglink.net/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,4,-1,'en',1,1,0,0,0,0,0),(70,'http://www.towerpromote.com','http://www.towerpromote.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(68,'http://www.picna.com','http://www.picna.com/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.picna.com',0,0,0,-1,'en',1,1,0,0,0,0,0),(67,'http://www.owdirectory.com','http://www.owdirectory.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(66,'http://www.haqj.com','http://www.haqj.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(65,'http://www.gkiv.com','http://www.gkiv.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(64,'http://www.insectuniverse.com','http://www.insectuniverse.com/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.insectuniverse.com',0,0,0,-1,'en',1,1,0,0,0,0,0),(63,'http://www.greatdir.net','http://www.greatdir.net/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(62,'http://www.jambezi.com','http://www.jambezi.com/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.jambezi.com',0,0,0,-1,'en',1,1,0,0,0,0,0),(61,'http://www.tkdirectory.com','http://www.tkdirectory.com/submit.php?LINK_TYPE=1','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','reciprocal=1&LINK_TYPE=1&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(58,'http://www.directoryrank.net','http://www.directoryrank.net/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(57,'http://www.submitsitenow.info','http://www.submitsitenow.info/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(56,'http://www.addyourlnksnow.com','http://www.addyourlnksnow.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=free&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(54,'http://www.holidaydig.com','http://www.holidaydig.com/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=free&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(55,'http://www.yrkdirectory.com','http://www.yrkdirectory.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(53,'http://www.mymaxlinks.org','http://www.mymaxlinks.org/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(52,'http://www.sblinks.org','http://www.sblinks.org/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(51,'http://www.lutonengineering.com','http://www.lutonengineering.com/submit.php?LINK_TYPE=2','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=2&submit=Continue&AGREERULES=on',0,0,3,-1,'en',1,1,0,0,0,0,0),(50,'http://www.doubledirectory.com','http://www.doubledirectory.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(49,'http://www.boomdirectory.com','http://www.boomdirectory.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(47,'http://www.deblinley.com','http://www.deblinley.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(48,'http://www.jhucr.org','http://www.jhucr.org/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(46,'http://www.directorybin.com','http://www.directorybin.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,1,3,-1,'en',1,1,0,0,5.79,41.16,50.57),(45,'http://www.magdalyns.com','http://www.magdalyns.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(44,'http://www.goobz.biz','http://www.goobz.biz/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(43,'http://www.gainweb.org','http://www.gainweb.org/submit.php?LINK_TYPE=2','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=2&submit=Continue&AGREERULES=on',0,1,4,-1,'en',1,1,1,0,6.09,41.58,51),(42,'http://www.indiabusinessdirectory.info','http://www.indiabusinessdirectory.info/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(41,'http://www.omega-link.co.uk','http://www.omega-link.co.uk/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(40,'http://www.webslink.info','http://www.webslink.info/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(39,'http://www.nuclearland.com','http://www.nuclearland.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(37,'http://www.freelistingdirectory.info','http://www.freelistingdirectory.info/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.freelistingdirectory.info',0,0,1,-1,'en',1,1,0,0,0,0,0),(35,'http://www.crazyleafdesign.com/webdirectory','http://www.crazyleafdesign.com/webdirectory/submit?LINK_TYPE=1','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=1&submit=Continue&AGREERULES=on',1,0,0,-1,'en',1,1,2,0,6.12,51.88,52.77),(34,'http://www.linkspremium.com','http://www.linkspremium.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(33,'http://www.hitalyzer.com','http://www.hitalyzer.com/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,1,3,-1,'en',1,1,0,0,5.48,38.03,47.35),(32,'http://directory.seoexecutive.com','http://directory.seoexecutive.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=free&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(31,'http://directory.allaboutadtips.com','http://directory.allaboutadtips.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(30,'http://www.clickmybrick.com','http://www.clickmybrick.com/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(29,'http://www.placeyourlinks.com','http://www.placeyourlinks.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,3,-1,'en',1,1,0,0,0,0,0),(28,'http://www.seocourt.com','http://www.seocourt.com/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',1,1,0,-1,'en',1,1,0,0,5.8,46.71,53.19),(27,'http://www.linkedout.info','http://www.linkedout.info/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(26,'http://www.triplewdirectory.com','http://www.triplewdirectory.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,1,0,-1,'en',1,1,0,0,5.56,40.12,50.1),(25,'http://www.yvir.com','http://www.yvir.com/submit.php?LINK_TYPE=2','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','z=1&LINK_TYPE=2&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(23,'http://www.1abc.org','http://www.1abc.org/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=free&submit=Continue&AGREERULES=on',0,1,0,-1,'en',1,1,0,0,6.17,54.24,62.04),(22,'http://www.pblake.com','http://www.pblake.com/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,4,-1,'en',1,1,0,0,0,0,0),(21,'http://www.aaawebdirectory.com','http://www.aaawebdirectory.com/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=free&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(20,'http://www.sanory.com','http://www.sanory.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,3,-1,'en',1,1,0,0,0,0,0),(19,'http://www.domaining.in','http://www.domaining.in/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=free&submit=Continue&AGREERULES=on',0,0,4,-1,'en',1,1,0,0,0,0,0),(18,'http://www.miriblack.com','http://www.miriblack.com/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',1,1,0,-1,'en',1,1,0,0,5.67,47.02,54.01),(17,'http://www.alistsites.com','http://www.alistsites.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,1,0,-1,'en',1,1,0,0,5.88,41.57,51.35),(16,'http://www.cheapdirectory.net','http://www.cheapdirectory.net/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on',0,0,3,-1,'en',1,1,0,0,0,0,0),(15,'http://www.ewebdir.com','http://www.ewebdir.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=free&submit=Continue&AGREERULES=on',1,1,0,-1,'en',1,1,0,0,4.9,27.28,38.47),(14,'http://www.tfwd.org','http://www.tfwd.org/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=free&submit=Continue&AGREERULES=on',0,1,1,-1,'en',1,1,0,0,4.8,28.47,39.2),(13,'http://www.pr3plus.com','http://www.pr3plus.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',1,1,0,-1,'en',1,1,0,0,5.49,34.8,45.67),(12,'http://www.123hitlinks.info','http://www.123hitlinks.info/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=free&submit=Continue&AGREERULES=on',1,1,0,-1,'en',1,1,0,0,5.8,44.27,53.65),(10,'http://www.directoryvault.com','http://www.directoryvault.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,1,0,-1,'en',1,1,0,0,6.11,44.64,53.95),(9,'http://www.skypemedia.com','http://www.skypemedia.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(8,'http://www.webhotlink.com','http://www.webhotlink.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=free&submit=Continue&AGREERULES=on',0,1,0,-1,'en',1,1,0,0,5.3,34.91,45.7),(6,'http://www.freewebsitedirectory.com','http://www.freewebsitedirectory.com/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,6.34,53.58,61.49),(5,'http://www.777media.com','http://www.777media.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(3,'http://www.onpaco.com','http://www.onpaco.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,1,0,-1,'en',1,1,0,0,5.58,33.32,44.39),(2,'http://www.fat64.net','http://www.fat64.net/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',1,1,0,-1,'en',1,1,0,0,5.79,43.47,52.97),(1,'http://directory.seofreetools.net','http://directory.seofreetools.net/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on',1,1,0,-1,'en',1,1,1,0,6.65,47.24,51.26),(146,'http://www.sblinks.info','http://www.sblinks.info/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(147,'http://www.thehopedirectory.com','http://www.thehopedirectory.com/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(148,'http://www.clocktowerstudio.com','http://www.clocktowerstudio.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(149,'http://www.infotechwv.com','http://www.infotechwv.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(150,'http://www.dawsoneng.com','http://www.dawsoneng.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(151,'http://www.cafrid.com','http://www.cafrid.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',1,1,0,-1,'en',1,1,0,0,4.64,29.42,41.05),(152,'http://www.fusionsalcedo.com','http://www.fusionsalcedo.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,1,-1,'en',1,1,0,0,0,0,0),(153,'http://www.justaskluke.com','http://www.justaskluke.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(154,'http://www.logha.com','http://www.logha.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(155,'http://www.pacdec.org','http://www.pacdec.org/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(156,'http://www.sitechakra.com','http://www.sitechakra.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,2,-1,'en',1,1,0,0,0,0,0),(157,'http://www.webbacklinks.com','http://www.webbacklinks.com/submit.php','captcha.php','index.php?q=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,0,0,-1,'en',1,1,0,0,0,0,0),(158,'http://www.searchnsearch.com','http://www.searchnsearch.com/submit.php','captcha.php','index.php?search=[--keyword--]','TITLE','URL','DESCRIPTION','OWNER_NAME','OWNER_EMAIL','CATEGORY_ID','CAPTCHA','IMAGEHASH','imagehash','RECPR_URL','LINK_TYPE=normal&submit=Continue&AGREERULES=on',0,1,1,-1,'en',1,1,0,0,5.38,29.48,38.96);

--
-- Table structure for table `dirsubmitinfo`
--

CREATE TABLE `dirsubmitinfo` (
  `id` bigint(24) unsigned NOT NULL AUTO_INCREMENT,
  `website_id` int(11) unsigned NOT NULL,
  `directory_id` int(11) unsigned NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `submit_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dirsubmitinfo`
--


--
-- Table structure for table `featured_directories`
--

CREATE TABLE `featured_directories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `directory_name` varchar(120) COLLATE utf8_unicode_ci NOT NULL,
  `directory_link` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `google_pagerank` smallint(6) NOT NULL DEFAULT '0',
  `coupon_code` varchar(120) COLLATE utf8_unicode_ci NOT NULL,
  `coupon_offer` float NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `featured_directories`
--

INSERT INTO `featured_directories` (`id`, `directory_name`, `directory_link`, `google_pagerank`, `coupon_code`, `coupon_offer`, `status`) VALUES (1,'directory.seopanel.in','http://directory.seofreetools.net/submit.php?LINK_TYPE=featured',4,'',0,1),(4,'beta-i.org','http://beta-i.org/submit.php?LINK_TYPE=4',6,'',0,1);

--
-- Table structure for table `information_list`
--

CREATE TABLE `information_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `info_type` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'news',
  `content` text COLLATE utf8_unicode_ci NOT NULL,
  `update_date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `information_list`
--

INSERT INTO `information_list` (`id`, `info_type`, `content`, `update_date`) VALUES (2,'news','	<a style=\"text-decoration: none\" href=\"http://www.seopanel.in/plugin/l/3/link-diagnosis/\" target=\"_blank\" id=\'news_info\'>\n		<b>Download Link Diagnosis Plugin</b> and install it in your seo panel and <b>track complete details of all backlinks</b>\n		of your sites and also of your competitors!\n	</a>\n	','2016-12-28');

--
-- Table structure for table `keywordcrontracker`
--

CREATE TABLE `keywordcrontracker` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `keyword_id` int(16) DEFAULT NULL,
  `searchengine_id` int(11) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `keyword_id` (`keyword_id`),
  KEY `searchengine_id` (`searchengine_id`),
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `keywordcrontracker`
--


--
-- Table structure for table `keywords`
--

CREATE TABLE `keywords` (
  `id` bigint(24) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lang_code` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country_code` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
  `website_id` int(11) DEFAULT NULL,
  `searchengines` varchar(120) CHARACTER SET latin1 DEFAULT NULL,
  `status` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `keywords`
--


--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `lang_code` varchar(8) CHARACTER SET latin1 NOT NULL,
  `lang_name` varchar(24) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lang_show` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `RTL` tinyint(1) NOT NULL DEFAULT '0',
  `translated` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`lang_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` (`lang_code`, `lang_name`, `lang_show`, `RTL`, `translated`) VALUES ('en','English','English',0,1),('de','German','Deutsch',0,1),('fr','French','Français',0,1),('it','Italian','italiano',0,1),('es','Spanish','español',0,1),('pl','Polish','polski',0,1),('ru','Russian','Русский язык',0,1),('hi','Hindi','हिन्दी',0,0),('ar','Arabic','العربية',1,1),('pt','Portuguese','português',0,1),('sv','Swedish','Svenska',0,1),('no','Norwegian','Norsk',0,0),('da','Danish','dansk',0,1),('fi','Finnish','suomi',0,0),('hu','Hungarian','magyar',0,1),('nl','Dutch','Nederlands',0,1),('sr','Serbian','српски',0,0),('bg','Bulgarian','български',0,1),('uk','Ukrainian','Українська',0,0),('el','Greek','ελληνικά',0,1),('he','Hebrew','עברית / עִבְרִית',1,1),('ko','Korean','한국어 [韓國語]',0,0),('zh','Chinese (Simplified)','中文（简体）',0,1),('ja','Japanese','日本語 ',0,1),('tl','Tagalog','Tagalog',0,0),('id','Indonesian','Bahasa Indonesia',0,1),('fa','Farsi','پارسی',1,1),('th','Thai','ภาษาไทย',0,0),('ro','Romanian','română',0,1),('tr','Turkish','Türkçe',0,1),('hr','Croatian','Hrvatski',0,0),('mk','Macedonian','македонски',0,0),('bs','Bosnian','Bosanski',0,0),('sq','Albanian','shqip',0,0),('sw','Swahili','Kiswahili',0,0),('hy','Armenian','Հայերէն',0,0),('cs','Czech','čeština',0,1),('sk','Slovak','slovenčina',0,1),('cn','Chinese (Traditional)','中文（繁體）',0,1),('pt-br','Portuguese - Brazil','português brasileiro',0,1),('vn','Vietnamese','Việt',0,1),('es-ar','Spanish Argentina','español rioplatense',0,1),('sl','Slovenian','slovenščina',0,1),('lt','Lithuanian','lietuvių kalba',0,1),('ca','Catalan','Català',0,0);

--
-- Table structure for table `proxylist`
--

CREATE TABLE `proxylist` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `proxy` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `port` int(8) DEFAULT NULL,
  `proxy_auth` tinyint(1) NOT NULL DEFAULT '0',
  `proxy_username` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `proxy_password` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `checked` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `proxylist`
--


--
-- Table structure for table `rankresults`
--

CREATE TABLE `rankresults` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `website_id` int(11) NOT NULL,
  `google_pagerank` int(8) NOT NULL,
  `alexa_rank` int(11) NOT NULL,
  `moz_rank` float NOT NULL,
  `result_time` int(11) NOT NULL,
  `domain_authority` float NOT NULL,
  `page_authority` float NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rankresults`
--


--
-- Table structure for table `reports_settings`
--

CREATE TABLE `reports_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `report_interval` int(11) NOT NULL DEFAULT '1',
  `email_notification` tinyint(1) NOT NULL DEFAULT '0',
  `last_generated` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `reports_settings`
--

INSERT INTO `reports_settings` (`id`, `user_id`, `report_interval`, `email_notification`, `last_generated`) VALUES (1,1,1,1,1481760000);

--
-- Table structure for table `saturationresults`
--

CREATE TABLE `saturationresults` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `website_id` int(11) NOT NULL,
  `google` int(11) NOT NULL,
  `msn` int(11) NOT NULL,
  `result_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `saturationresults`
--


--
-- Table structure for table `searchengines`
--

CREATE TABLE `searchengines` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `domain` varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cookie_send` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_of_results_page` int(8) DEFAULT NULL,
  `start` int(11) NOT NULL DEFAULT '0',
  `start_offset` int(8) NOT NULL DEFAULT '0',
  `max_results` int(11) NOT NULL DEFAULT '100',
  `regex` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `from_pattern` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `to_pattern` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url_index` int(11) NOT NULL DEFAULT '1',
  `title_index` int(11) NOT NULL DEFAULT '2',
  `description_index` int(11) NOT NULL DEFAULT '3',
  `encoding` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `searchengines`
--

INSERT INTO `searchengines` (`id`, `domain`, `url`, `cookie_send`, `no_of_results_page`, `start`, `start_offset`, `max_results`, `regex`, `from_pattern`, `to_pattern`, `url_index`, `title_index`, `description_index`, `encoding`, `status`) VALUES (1,'www.google.com','http://www.google.com/search?hl=[--lang--]&num=[--num--]&q=[--keyword--]&start=[--start--]&cr=country[--country--]&as_qdr=all&gws_rd=cr&nfpr=1','',100,0,100,100,'<div.*?class=\"?g.*?><h3 class=\"r\"><a.*?href=\"\\/url\\?q=(.*?)&amp;sa=U.*?>(.*?)<\\/a>.*?<\\/div><span.*?>(.*?)<\\/span>','<div id=\"?ires\"?>','<\\/ol>',1,2,3,NULL,1),(2,'www.yahoo.com','http://search.yahoo.com/search?p=[--keyword--]&n=[--num--]&b=[--start--]&vl=lang_[--lang--]&fl=1&v=1&vc=[--country--]','sB=v=1&n=100&sh=1&rw=new',100,1,100,100,'<li.*?<h3.*?><a.*?RU=(.*?)\\/.*?>(.*?)<\\/a><\\/h3>.*?<p.*?>(.*?)<\\/p>',NULL,NULL,1,2,3,NULL,1),(3,'www.bing.com','http://www.bing.com/search?q=[--keyword--]&scope=web&first=[--start--]&setmkt=[--lang--]-[--country--]','SRCHHPGUSR=NEWWND=0&NRSLT=50&SRCHLANG=[--lang--]',50,1,50,50,'<li.*?<h2><a.*?href=\"(.*?)\".*?>(.*?)<\\/a><\\/h2>.*?<p.*?>(.*?)<\\/p>',NULL,NULL,1,2,3,NULL,1);

--
-- Table structure for table `searchresultdetails`
--

CREATE TABLE `searchresultdetails` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `searchresult_id` bigint(24) unsigned DEFAULT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(160) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `searchresultdetails`
--


--
-- Table structure for table `searchresults`
--

CREATE TABLE `searchresults` (
  `id` bigint(24) unsigned NOT NULL AUTO_INCREMENT,
  `keyword_id` int(16) DEFAULT NULL,
  `searchengine_id` int(11) DEFAULT NULL,
  `rank` int(8) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  `result_date` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `result_date` (`result_date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `searchresults`
--


--
-- Table structure for table `seoplugins`
--

CREATE TABLE `seoplugins` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `author` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `version` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
  `website` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `installed` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `seoplugins`
--

INSERT INTO `seoplugins` (`id`, `label`, `name`, `author`, `description`, `version`, `website`, `status`, `installed`) VALUES (1,'Meta Tag Generator','MetaTagGenerator','Geo Varghese','Meta Tag Generator','1.0.0','http://www.seopanel.in/plugins/',1,1),(2,'Test Plugin','TestPlugin','Geo Varghese','Seo Panel Test Plugin: Check the structure of test plugin and it will help you to create new Seo Panel Plugins.','1.0.0','http://www.seopanel.in/plugins/',1,1);

--
-- Table structure for table `seotools`
--

CREATE TABLE `seotools` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url_section` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_access` tinyint(1) NOT NULL DEFAULT '1',
  `reportgen` tinyint(1) NOT NULL DEFAULT '1',
  `cron` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `seotools`
--

INSERT INTO `seotools` (`id`, `name`, `url_section`, `user_access`, `reportgen`, `cron`, `status`) VALUES (1,'Keyword Position Checker','keyword-position-checker',1,1,1,1),(2,'Site Auditor','site-auditor',1,1,0,1),(3,'Rank Checker','rank-checker',1,1,1,1),(4,'Backlinks Checker','backlink-checker',1,1,1,1),(5,'Directory Submission','directory-submission',1,1,0,1),(6,'Search Engine Saturation','saturation-checker',1,1,1,1);

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `set_label` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `set_name` varchar(64) CHARACTER SET latin1 NOT NULL,
  `set_val` text COLLATE utf8_unicode_ci NOT NULL,
  `set_category` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'system',
  `set_type` enum('small','bool','medium','large','text') CHARACTER SET latin1 DEFAULT 'small',
  `display` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `set_name` (`set_name`)
) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `settings`
--



--
-- Table structure for table `skipdirectories`
--

CREATE TABLE `skipdirectories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `website_id` int(11) NOT NULL,
  `directory_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `website_id` (`website_id`,`directory_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `skipdirectories`
--


--
-- Table structure for table `testplugin`
--

CREATE TABLE `testplugin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(64) CHARACTER SET latin1 NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `testplugin`
--


--
-- Table structure for table `texts`
--

CREATE TABLE `texts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `lang_code` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en',
  `category` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'common',
  `label` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8_unicode_ci,
  `changed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `language_id` (`lang_code`,`category`,`label`)
) ENGINE=MyISAM AUTO_INCREMENT=13034 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `texts`
--




--
-- Table structure for table `themes`
--

CREATE TABLE `themes` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `folder` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `author` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `version` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
  `website` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `installed` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `themes`
--

INSERT INTO `themes` (`id`, `name`, `folder`, `author`, `description`, `version`, `website`, `status`, `installed`) VALUES (1,'Classic','classic','Geo Varghese','Classic theme of Seo Panel','1.0.0','http://www.seopanel.in/theme/l/1/classic/',1,1),(2,'Simple','simple','Geo Varghese','Simple theme of Seo Panel','1.0.0','http://www.seopanel.in/theme/l/2/simple/',0,1);

--
-- Table structure for table `timezone`
--

CREATE TABLE `timezone` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `timezone_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `timezone_label` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `gmt_diff` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '+00.00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=91 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `timezone`
--

INSERT INTO `timezone` (`id`, `timezone_name`, `timezone_label`, `gmt_diff`) VALUES (1,'Pacific/Midway','(GMT-11:00) Midway Island, Samoa','-11:00'),(2,'America/Adak','(GMT-10:00) Hawaii-Aleutian','-10:00'),(3,'Etc/GMT+10','(GMT-10:00) Hawaii','-10:00'),(4,'Pacific/Marquesas','(GMT-09:30) Marquesas Islands','-09:30'),(5,'Pacific/Gambier','(GMT-09:00) Gambier Islands','-09:00'),(6,'America/Anchorage','(GMT-09:00) Alaska','-09:00'),(7,'America/Ensenada','(GMT-08:00) Tijuana, Baja California','-08:00'),(8,'Etc/GMT+8','(GMT-08:00) Pitcairn Islands','-08:00'),(9,'America/Los_Angeles','(GMT-08:00) Pacific Time (US & Canada)','-08:00'),(10,'America/Denver','(GMT-07:00) Mountain Time (US & Canada)','-07:00'),(11,'America/Chihuahua','(GMT-07:00) Chihuahua, La Paz, Mazatlan','-07:00'),(12,'America/Dawson_Creek','(GMT-07:00) Arizona','-07:00'),(13,'America/Belize','(GMT-06:00) Saskatchewan, Central America','-06:00'),(14,'America/Cancun','(GMT-06:00) Guadalajara, Mexico City, Monterrey','-06:00'),(15,'Chile/EasterIsland','(GMT-06:00) Easter Island','-06:00'),(16,'America/Chicago','(GMT-06:00) Central Time (US & Canada)','-06:00'),(17,'America/New_York','(GMT-05:00) Eastern Time (US & Canada)','-05:00'),(18,'America/Havana','(GMT-05:00) Cuba','-05:00'),(19,'America/Bogota','(GMT-05:00) Bogota, Lima, Quito, Rio Branco','-05:00'),(20,'America/Caracas','(GMT-04:30) Caracas','-04:30'),(21,'America/Santiago','(GMT-04:00) Santiago','-04:00'),(22,'America/La_Paz','(GMT-04:00) La Paz','-04:00'),(23,'Atlantic/Stanley','(GMT-04:00) Faukland Islands','-04:00'),(24,'America/Campo_Grande','(GMT-04:00) Brazil','-04:00'),(25,'America/Goose_Bay','(GMT-04:00) Atlantic Time (Goose Bay)','-04:00'),(26,'America/Glace_Bay','(GMT-04:00) Atlantic Time (Canada)','-04:00'),(27,'America/St_Johns','(GMT-03:30) Newfoundland','-03:30'),(28,'America/Araguaina','(GMT-03:00) UTC-3','-03:00'),(29,'America/Montevideo','(GMT-03:00) Montevideo','-03:00'),(30,'America/Miquelon','(GMT-03:00) Miquelon, St. Pierre','-03:00'),(31,'America/Godthab','(GMT-03:00) Greenland','-03:00'),(32,'America/Argentina/Buenos_Aires','(GMT-03:00) Buenos Aires','-03:00'),(33,'America/Sao_Paulo','(GMT-03:00) Brasilia','-03:00'),(34,'America/Noronha','(GMT-02:00) Mid-Atlantic','-02:00'),(35,'Atlantic/Cape_Verde','(GMT-01:00) Cape Verde Is.','-01:00'),(36,'Atlantic/Azores','(GMT-01:00) Azores','-01:00'),(37,'Europe/Belfast','(GMT) Greenwich Mean Time : Belfast','+00:00'),(38,'Europe/Dublin','(GMT) Greenwich Mean Time : Dublin','+00:00'),(39,'Europe/Lisbon','(GMT) Greenwich Mean Time : Lisbon','+00:00'),(40,'Europe/London','(GMT) Greenwich Mean Time : London','+00:00'),(41,'Africa/Abidjan','(GMT) Monrovia, Reykjavik','+00:00'),(42,'Europe/Berlin','(GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna','+01:00'),(43,'Europe/Belgrade','(GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague','+01:00'),(44,'Europe/Brussels','(GMT+01:00) Brussels, Copenhagen, Madrid, Paris','+01:00'),(45,'Africa/Algiers','(GMT+01:00) West Central Africa','+01:00'),(46,'Africa/Windhoek','(GMT+01:00) Windhoek','+01:00'),(47,'Asia/Beirut','(GMT+02:00) Beirut','+02:00'),(48,'Africa/Cairo','(GMT+02:00) Cairo','+02:00'),(49,'Asia/Gaza','(GMT+02:00) Gaza','+02:00'),(50,'Africa/Blantyre','(GMT+02:00) Harare, Pretoria','+02:00'),(51,'Asia/Jerusalem','(GMT+02:00) Jerusalem','+02:00'),(52,'Europe/Minsk','(GMT+02:00) Minsk','+02:00'),(53,'Asia/Damascus','(GMT+02:00) Syria','+02:00'),(54,'Europe/Moscow','(GMT+03:00) Moscow, St. Petersburg, Volgograd','+03:00'),(55,'Africa/Addis_Ababa','(GMT+03:00) Nairobi','+03:00'),(56,'Asia/Tehran','(GMT+03:30) Tehran','+03:30'),(57,'Asia/Dubai','(GMT+04:00) Abu Dhabi, Muscat','+04:00'),(58,'Asia/Yerevan','(GMT+04:00) Yerevan','+04:00'),(59,'Asia/Kabul','(GMT+04:30) Kabul','+04:30'),(60,'Asia/Yekaterinburg','(GMT+05:00) Ekaterinburg','+05:00'),(61,'Asia/Tashkent','(GMT+05:00) Tashkent','+05:00'),(62,'Asia/Kolkata','(GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi','+05:30'),(63,'Asia/Katmandu','(GMT+05:45) Kathmandu','+05:45'),(64,'Asia/Dhaka','(GMT+06:00) Astana, Dhaka','+06:00'),(65,'Asia/Novosibirsk','(GMT+06:00) Novosibirsk','+06:00'),(66,'Asia/Rangoon','(GMT+06:30) Yangon (Rangoon)','+06:30'),(67,'Asia/Bangkok','(GMT+07:00) Bangkok, Hanoi, Jakarta','+07:00'),(68,'Asia/Krasnoyarsk','(GMT+07:00) Krasnoyarsk','+07:00'),(69,'Asia/Hong_Kong','(GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi','+08:00'),(70,'Asia/Irkutsk','(GMT+08:00) Irkutsk, Ulaan Bataar','+08:00'),(71,'Australia/Perth','(GMT+08:00) Perth','+08:00'),(72,'Australia/Eucla','(GMT+08:45) Eucla','+08:45'),(73,'Asia/Tokyo','(GMT+09:00) Osaka, Sapporo, Tokyo','+09:00'),(74,'Asia/Seoul','(GMT+09:00) Seoul','+09:00'),(75,'Asia/Yakutsk','(GMT+09:00) Yakutsk','+09:00'),(76,'Australia/Adelaide','(GMT+09:30) Adelaide','+09:30'),(77,'Australia/Darwin','(GMT+09:30) Darwin','+09:30'),(78,'Australia/Brisbane','(GMT+10:00) Brisbane','+10:00'),(79,'Australia/Hobart','(GMT+10:00) Hobart','+10:00'),(80,'Asia/Vladivostok','(GMT+10:00) Vladivostok','+10:00'),(81,'Australia/Lord_Howe','(GMT+10:30) Lord Howe Island','+10:30'),(82,'Etc/GMT-11','(GMT+11:00) Solomon Is., New Caledonia','+11:00'),(83,'Asia/Magadan','(GMT+11:00) Magadan','+11:00'),(84,'Pacific/Norfolk','(GMT+11:30) Norfolk Island','+11:30'),(85,'Asia/Anadyr','(GMT+12:00) Anadyr, Kamchatka','+12:00'),(86,'Pacific/Auckland','(GMT+12:00) Auckland, Wellington','+12:00'),(87,'Etc/GMT-12','(GMT+12:00) Fiji, Kamchatka, Marshall Is.','+12:00'),(88,'Pacific/Chatham','(GMT+12:45) Chatham Islands','+12:45'),(89,'Pacific/Tongatapu','(GMT+13:00) Nuku\'alofa','+13:00'),(90,'Pacific/Kiritimati','(GMT+14:00) Kiritimati','+14:00');

--
-- Table structure for table `translators`
--

CREATE TABLE `translators` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `lang_code` varchar(8) NOT NULL,
  `trans_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `trans_company` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `trans_website` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `translators`
--

INSERT INTO `translators` (`id`, `lang_code`, `trans_name`, `trans_company`, `trans_website`) VALUES (1,'de','Christopher Hüneke','Kinder PKV','http://www.kinder-pkv.org/'),(2,'es','AnunciosEnLinea.es','AnunciosEnLinea.es','http://www.anunciosenlinea.es/'),(3,'fr','Erik De Zeeuw','ez-solutions.fr','http://www.ez-solutions.fr/'),(4,'pl','Marek Cich','marekcich.co.uk','http://www.marekcich.co.uk/'),(5,'ru','Alexander Arapov','Arsko','http://seo-panel.ru/'),(6,'nl','Bas van Eijk','Bureau Creaties','http://www.bureaucreaties.nl'),(7,'nl','Manuel Schroyens','Webaholic','http://www.webaholic.be/'),(8,'it','Antonio Cionfs Confessore','Cionfs\'Forum CMS','http://www.cionfs.it/forum/'),(9,'zh','许腾飞',' 斐然小居','http://www.tengfei.biz/'),(10,'hu','Bocskói Botond','MSN Downloads','http://www.msnfan.hu/'),(11,'pt','pedro vaz','internet services','http://www.temnet.pt/'),(12,'ro','Sfetcu Paul','freelancer RO','http://www.servicewebit.ro/'),(13,'bg','Dimitar Kukov','Web Lab Bulgaria','http://www.weblab-bg.com/'),(14,'el','Vaggelis Tsagklis','BLB.gr','http://www.blb.gr/'),(15,'cn','周天伟','IT非正常人类','http://www.kaotama.com.cn'),(16,'es','Alex Rubio','miniz','http://www.technicalrp.com/'),(17,'tr','Buray Savas ANIL','Geliyoo Türkiye','http://www.geliyoo.com/'),(18,'fa','mohammad mohammadi','tirdadnova@yahoo.com','mailto:tirdadnova@yahoo.com'),(19,'he','Rea Maor','nekuda.co.il','http://nekuda.co.il'),(20,'sl','Andrej Arh','SEO spletni marketing','http://seomarketing.si/'),(21,'vn','Dung Dang Huy','www.huydung.net','http://www.huydung.net'),(22,'sk','Martin Babic','SEO služby','http://www.seo-sluzby.sk/'),(23,'ar','Bashiti','Oriental Security','http://www.orientalsecurity.com/'),(24,'pt-BR','Carlos Zamora','Agência SOFT','http://www.agenciasoft.com.br/'),(25,'id','Ikmal Syifai','ikmal.s.16@gmail.com','mailto:ikmal.s.16@gmail.com'),(26,'cs','Tomas','berniecz@gmail.com','mailto:berniecz@gmail.com'),(27,'da','Michael S. Clausen','dingojet@gmail.com','mailto:dingojet@gmail.com'),(28,'es-ar','Federico Franic','ffranic.com.ar','http://ffranic.com.ar/'),(29,'lt','Rokas Globys','Auksera','http://www.auksera.lt/'),(30,'ja','Sumitaka Kanno','XyXon','http://www.xyxon.co.jp/'),(32,'sv','','sökoptimering.se','http://sökoptimering.se/'),(33,'pt-BR','Edson Medeiros','We Marketing Digital','http://wemarketingdigital.com.br/');

--
-- Table structure for table `user_specs`
--

CREATE TABLE `user_specs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_type_id` int(11) NOT NULL,
  `spec_column` varchar(120) COLLATE utf8_unicode_ci NOT NULL,
  `spec_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_specs`
--

INSERT INTO `user_specs` (`id`, `user_type_id`, `spec_column`, `spec_value`) VALUES (1,2,'keywordcount','50'),(2,2,'websitecount','10'),(3,2,'price','0');

--
-- Table structure for table `usertypes`
--

CREATE TABLE `usertypes` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `user_type` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `usertypes`
--

INSERT INTO `usertypes` (`id`, `user_type`, `description`, `status`) VALUES (1,'admin','Super User',1),(2,'user','Normal User',1);

--
-- Table structure for table `websites`
--

CREATE TABLE `websites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `owner_name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `owner_email` varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL,
  `category` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `keywords` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title2` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title3` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title4` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title5` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description2` text COLLATE utf8_unicode_ci,
  `description3` text COLLATE utf8_unicode_ci,
  `description4` text COLLATE utf8_unicode_ci,
  `description5` text COLLATE utf8_unicode_ci,
  `reciprocal_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `websites`
--

INSERT INTO `websites` (`id`, `name`, `url`, `owner_name`, `owner_email`, `category`, `title`, `description`, `keywords`, `title2`, `title3`, `title4`, `title5`, `description2`, `description3`, `description4`, `description5`, `reciprocal_url`, `user_id`, `status`) VALUES (1,'stpims','http://stpims.com',NULL,NULL,NULL,'DSCSA Compliance Starts Here | Streamline Technology PIMS System','The Path to DSCSA compliance starts here. Streamline Technology’s PIMS system is a comprehensive DSCSA compliant business solution.','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1);

--
-- Dumping events for database 'stpims5_seo628'
--

--
-- Dumping routines for database 'stpims5_seo628'
--


