CREATE TABLE IF NOT EXISTS `ld_backlinks` (
  `id` bigint(24) NOT NULL AUTO_INCREMENT,
  `indexed_id` bigint(24) unsigned DEFAULT NULL,
  `report_id` int(11) NOT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url_found` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `link_title` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `google_pagerank` int(8) NOT NULL DEFAULT '0',
  `outbound_links` int(8) NOT NULL DEFAULT '0',
  `nofollow` tinyint(1) NOT NULL DEFAULT '0',
  `crawled` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `report_id_2` (`report_id`,`url`),
  KEY `report_id` (`indexed_id`),
  KEY `indexed_id_2` (`indexed_id`,`report_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `ld_indexed` (
  `id` bigint(24) NOT NULL AUTO_INCREMENT,
  `report_id` int(11) unsigned DEFAULT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `crawling_page` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-1',
  `crawled` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `report_id_2` (`report_id`,`url`),
  KEY `report_id` (`report_id`),
  KEY `report_id_3` (`report_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `ld_projects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `ld_reports` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `max_links` int(11) NOT NULL DEFAULT '500',
  `project_id` int(11) NOT NULL,
  `searchengine_id` int(11) NOT NULL DEFAULT '1',
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` smallint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `project_id` (`project_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `ld_seconfig` (
  `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,
  `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,
  `next_link_regex` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;

INSERT INTO `ld_seconfig` (`id`, `domain`, `url`, `cookie_send`, `no_of_results_page`, `start`, `start_offset`, `max_results`, `regex`, `url_index`, `title_index`, `description_index`, `encoding`, `next_link_regex`, `status`) VALUES
(2, 'yahoo.com', 'http://siteexplorer.search.yahoo.com/search?p=[--keyword--]&b=[--start--]&bwm=i&bwmo=d&bwmf=s', '', 100, 1, 100, 100, '<span class="result">.*?<a.*?title="(.*?)".*?>', 1, 1, 1, NULL, '', 0),
(1, 'www.google.com', 'http://www.google.com/search?hl=[--lang--]&num=[--num--]&q=link%3A[--keyword--]&start=[--start--]&cr=country[--country--]&as_qdr=all', '', 100, 0, 100, 100, '<li.*?class="?g.*?<a.*?href="\\/url\\?q=(.*?)&amp;sa=U.*?>(.*?)<\\/a>.*?<div.*?>(.*?)<cite>', 1, 2, 3, NULL, '', 1),
(3, 'www.bing.com', 'http://www.bing.com/search?q=link%3A[--keyword--]&scope=web&first=[--start--]&setmkt=[--lang--]-[--country--]', 'SRCHHPGUSR=NEWWND=0&NRSLT=50&SRCHLANG=[--lang--]', 50, 1, 50, 50, '<li.*?<h3><a.*?href="(.*?)".*?>(.*?)<\\/a><\\/h3>.*?<p.*?>(.*?)<\\/p>', 1, 2, 3, NULL, '', 1),
(4, 'exalead.com', 'http://www.exalead.com/search/web/results/?q=link%3A[--keyword--]&elements_per_page=[--num--]&start_index=[--start--]', 'cookies_supported=True; Domain=.exalead.com; Path=/;', 90, 0, 90, 90, '<li.*?<h3.*?<a.*?href="(.*?)".*?<\\/li>', 1, 1, 1, NULL, '', 1),
(5, 'alexa.com', 'http://www.alexa.com/site/linksin;[--start--]/[--keyword--]', '', 20, 0, 1, 20, '<p>(.*?)<br\\/>', 1, 2, 3, '', '', 0),
(6, 'opensiteexplorer.org', 'http://www.opensiteexplorer.org/links.html?group=0&page=[--start--]&site=[--keyword--]&sort=page_authority', '', NULL, 1, 1, 50, '<td>.*?<div class="url">.*?<a href="(http.*?)".*?<\\/div>', 1, 2, 3, NULL, '', 1),
(7, 'siteexplorer.info', 'http://siteexplorer.info/[--keyword--]', NULL, 100, 0, 1, 100, '<tr.*?><td.*?<a.*?>(http[^ ]*?)<\\/a>.*?<td.*?>(.*?)<\\/td>.*?<td class=''follow''>(.*?)<\\/td><\\/tr>', 1, 2, 3, NULL, 'class=''nextup''.*href=''(.*?)''>Next Page<\\/a>', 1);

CREATE TABLE IF NOT EXISTS `ld_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_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  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

INSERT INTO `ld_settings` (`id`, `set_label`, `set_name`, `set_val`, `set_type`, `display`) VALUES
(1, 'Backlinks Search Engine', 'LD_SEARCH_ENGINE', '7', 'small', 1),
(2, 'Allow user to access reports manager', 'LD_ALLOW_USER_REPORTS', '0', 'bool', 1),
(3, 'Allow user to generate reports', 'LD_ALLOW_USER_GENREPORTS', '0', 'bool', 1),
(4, 'Maximum links in report', 'LD_MAX_LINKS_REPORT', '250', 'medium', 1),
(5, 'Maximum number of indexed pages to be checked ', 'LD_MAX_INDEXED_PAGES', '1', 'small', 0);

CREATE TABLE IF NOT EXISTS `ld_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 'ldplugin',
  `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  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=219 ;

INSERT INTO `ld_texts` (`id`, `lang_code`, `category`, `label`, `content`, `changed`) VALUES
(1, 'en', 'ldplugin', 'New Project', 'New Project', '2010-10-12 19:35:25'),
(2, 'en', 'ldplugin', 'Projects Manager', 'Projects Manager', '2010-10-12 19:45:13'),
(3, 'en', 'ldplugin', 'Project already exist', 'Project already exist', '2010-10-12 20:56:49'),
(4, 'en', 'ldplugin', 'Edit Project', 'Edit Project', '2010-10-20 06:54:44'),
(19, 'en', 'ldplugin', 'Links Report Summary', 'Links Report Summary', '2010-11-05 20:16:21'),
(7, 'en', 'ldplugin', 'Project', 'Project', '2010-10-26 17:34:23'),
(8, 'en', 'ldplugin', 'New Report', 'New Report', '2010-10-26 17:44:35'),
(9, 'en', 'ldplugin', 'Updated', 'Updated', '2010-10-26 17:56:41'),
(10, 'en', 'ldplugin', 'Report already exist', 'Report already exist', '2010-10-26 19:08:10'),
(11, 'en', 'ldplugin', 'Edit Report', 'Edit Report', '2010-10-26 19:25:41'),
(12, 'en', 'ldplugin', 'Maximum Links', 'Maximum Links', '2010-10-26 19:57:04'),
(13, 'en', 'ldplugin', 'Run', 'Run', '2010-10-28 18:12:48'),
(14, 'en', 'ldplugin', 'Generate Report', 'Generate Report', '2010-11-03 20:47:05'),
(15, 'en', 'ldplugin', 'Links report generated successfully', 'Links report generated successfully!', '2010-11-03 21:21:46'),
(16, 'en', 'ldplugin', 'View', 'View', '2010-11-05 17:46:49'),
(17, 'en', 'ldplugin', 'View Reports', 'View Reports', '2010-11-05 18:53:10'),
(18, 'en', 'ldplugin', 'Report Type', 'Report Type', '2010-11-05 18:59:50'),
(20, 'en', 'ldplugin', 'Backlinks Reports', 'Backlinks Reports', '2010-11-09 18:41:57'),
(21, 'en', 'ldplugin', 'Indexed Page Reports', 'Indexed Page Reports', '2010-11-09 20:02:53'),
(22, 'en', 'ldplugin', 'Most Popular Anchors', 'Most Popular Anchors', '2010-11-09 20:32:06'),
(23, 'en', 'ldplugin', 'Report', 'Report', '2010-11-10 21:00:54'),
(24, 'en', 'ldplugin', 'Plugin Settings', 'Plugin Settings', '2010-11-12 20:08:22'),
(25, 'en', 'ldplugin', 'LD_SEARCH_ENGINE', 'Backlinks Search Engine', '2010-11-12 20:15:30'),
(26, 'en', 'ldplugin', 'LD_ALLOW_USER_REPORTS', 'Allow user to access reports manager', '2010-11-12 20:15:30'),
(27, 'en', 'ldplugin', 'LD_ALLOW_USER_GENREPORTS', 'Allow user to generate reports', '2010-11-12 20:15:52'),
(28, 'en', 'ldplugin', 'ldsettingssaved', 'Plugin settings saved successfully!', '2010-11-12 20:31:48'),
(29, 'en', 'ldplugin', 'LD_MAX_LINKS_REPORT', 'Maximum links in report', '2010-11-16 19:42:41'),
(30, 'en', 'ldplugin', 'Number of links is greater than maximun links', 'Number of links is greater than maximun links', '2010-11-16 19:59:59'),
(31, 'en', 'ldplugin', 'Maximum links allowed', 'Maximum links allowed', '2010-11-16 20:06:14'),
(32, 'en', 'ldplugin', 'LD_MAX_INDEXED_PAGES', 'Maximum number of indexed pages to be checked', '2010-11-24 20:10:28'),
(34, 'en', 'ldplugin', 'Completed', 'Completed', '2010-11-25 18:17:26'),
(35, 'en', 'ldplugin', 'In Complete', 'In Complete', '2010-11-25 18:17:39'),
(36, 'en', 'ldplugin', 'Not Started', 'Not Started', '2010-11-25 18:17:51'),
(37, 'en', 'ldplugin', 'savedindexpageswaiting', 'Saved indexed Pages..Waiting for crawling backlinks', '2010-11-25 18:29:32'),
(38, 'en', 'ldplugin', 'waitcrawlbacklinks', 'Waiting for crawling details of next set of backlinks', '2010-11-25 18:34:05'),
(39, 'en', 'ldplugin', 'to view the reports', 'to view the reports', '2010-11-25 18:35:58'),
(40, 'en', 'ldplugin', 'escapetostop', 'Press <b>escape</b> key to stop execution of script', '2010-11-25 19:04:23'),
(41, 'en', 'ldplugin', 'tostartreportgeneration', 'to start report generation again if you stopped execution', '2010-11-25 19:05:48'),
(42, 'en', 'ldplugin', 'Paged Indexed', 'Paged Indexed', '2010-11-25 19:13:31'),
(43, 'en', 'ldplugin', 'Total Backlinks', 'Total Backlinks', '2010-11-25 19:13:31'),
(44, 'en', 'ldplugin', 'Crawled Backlinks', 'Crawled Backlinks', '2010-11-25 19:13:43'),
(45, 'en', 'ldplugin', 'Unique Anchors', 'Unique Anchors', '2010-11-25 19:14:02'),
(46, 'en', 'ldplugin', 'Excellent Links', 'Excellent Links', '2010-11-25 19:14:02'),
(47, 'en', 'ldplugin', 'Good Links', 'Good Links', '2010-11-25 19:14:13'),
(48, 'en', 'ldplugin', 'Nofollow Links', 'Nofollow Links', '2010-11-25 19:14:23'),
(49, 'en', 'ldplugin', 'Missing Title', 'Missing Title', '2010-11-25 19:14:33'),
(50, 'en', 'ldplugin', 'Anchor', 'Anchor', '2010-11-25 19:27:00'),
(51, 'en', 'ldplugin', 'Link Type', 'Link Type', '2010-11-25 19:27:19'),
(52, 'en', 'ldplugin', 'Missing', 'Missing', '2010-11-25 19:28:25'),
(53, 'en', 'ldplugin', 'Nofollow', 'Nofollow', '2010-11-25 19:28:48'),
(54, 'en', 'ldplugin', 'Good', 'Good', '2010-11-25 19:29:12'),
(55, 'en', 'ldplugin', 'Excellent', 'Excellent', '2010-11-25 19:29:29'),
(56, 'en', 'ldplugin', 'Report Summary', 'Report Summary', '2010-11-25 19:31:49'),
(57, 'en', 'ldplugin', 'Pages Indexed', 'Pages Indexed', '2010-11-25 19:32:48'),
(58, 'en', 'ldplugin', 'Popular Anchors', 'Popular Anchors', '2010-11-25 19:32:58'),
(59, 'en', 'ldplugin', 'Report Url', 'Report Url', '2010-11-25 19:37:16'),
(60, 'en', 'ldplugin', 'Last Updated', 'Last Updated', '2010-11-25 19:38:36'),
(61, 'en', 'ldplugin', 'Link Summary', 'Link Summary', '2010-11-25 19:44:42'),
(62, 'en', 'ldplugin', 'Page Rank Summary', 'Page Rank Summary', '2010-11-25 19:44:59'),
(63, 'en', 'ldplugin', 'Total Results', 'Total Results', '2010-11-25 19:46:44'),
(64, 'en', 'ldplugin', 'Backlink Url', 'Backlink Url', '2010-11-25 19:52:51'),
(65, 'en', 'ldplugin', 'Link Found', 'Link Found', '2010-11-25 19:53:03'),
(66, 'en', 'ldplugin', 'Outbound Links', 'Outbound Links', '2010-11-25 19:54:43'),
(67, 'en', 'ldplugin', 'Popular Title', 'Popular Title', '2010-11-25 20:34:09'),
(68, 'en', 'ldplugin', 'Count', 'Count', '2010-11-25 20:39:45'),
(69, 'en', 'ldplugin', 'No Projects Found', 'No Projects Found!', '2010-11-25 21:01:43'),
(70, 'fr', 'ldplugin', 'New Project', 'Nouveau projet', '2010-10-12 19:35:25'),
(71, 'fr', 'ldplugin', 'Projects Manager', 'Gestion des projets', '2010-10-12 19:45:13'),
(72, 'fr', 'ldplugin', 'Project already exist', 'Le projet existe déjà', '2010-10-12 20:56:49'),
(73, 'fr', 'ldplugin', 'Edit Project', 'Modifier le projet', '2010-10-20 06:54:44'),
(74, 'fr', 'ldplugin', 'Links Report Summary', 'Rapport rapide sur les Liens', '2010-11-05 20:16:21'),
(75, 'fr', 'ldplugin', 'Project', 'Projet', '2010-10-26 17:34:23'),
(76, 'fr', 'ldplugin', 'New Report', 'Nouveau rapport', '2010-10-26 17:44:35'),
(77, 'fr', 'ldplugin', 'Updated', 'Mis-à-jour', '2010-10-26 17:56:41'),
(78, 'fr', 'ldplugin', 'Report already exist', 'Le rapport existe déjà', '2010-10-26 19:08:10'),
(79, 'fr', 'ldplugin', 'Edit Report', 'Modifier le rapport', '2010-10-26 19:25:41'),
(80, 'fr', 'ldplugin', 'Maximum Links', 'Liens maximum', '2010-10-26 19:57:04'),
(81, 'fr', 'ldplugin', 'Run', 'Execute', '2010-10-28 18:12:48'),
(82, 'fr', 'ldplugin', 'Generate Report', 'Génerer un rapport', '2010-11-03 20:47:05'),
(83, 'fr', 'ldplugin', 'Links report generated successfully', 'Rapport des liens généré avec succés!', '2010-11-03 21:21:46'),
(84, 'fr', 'ldplugin', 'View', 'Voir', '2010-11-05 17:46:49'),
(85, 'fr', 'ldplugin', 'View Reports', 'Voir les rapports', '2010-11-05 18:53:10'),
(86, 'fr', 'ldplugin', 'Report Type', 'Type de rapport', '2010-11-05 18:59:50'),
(87, 'fr', 'ldplugin', 'Backlinks Reports', 'Rapport des liens retour', '2010-11-09 18:41:57'),
(88, 'fr', 'ldplugin', 'Indexed Page Reports', 'Rapport des pages indexées', '2010-11-09 20:02:53'),
(89, 'fr', 'ldplugin', 'Most Popular Anchors', 'Ancres les plus populaires', '2010-11-09 20:32:06'),
(90, 'fr', 'ldplugin', 'Report', 'Rapport', '2010-11-10 21:00:54'),
(91, 'fr', 'ldplugin', 'Plugin Settings', 'Paramètres', '2010-11-12 20:08:22'),
(92, 'fr', 'ldplugin', 'LD_SEARCH_ENGINE', 'Moteur de recherche pour les liens retour', '2010-11-12 20:15:30'),
(93, 'fr', 'ldplugin', 'LD_ALLOW_USER_REPORTS', 'Autoriser les utilisateurs à accéder à la gestion des rapports', '2010-11-12 20:15:30'),
(94, 'fr', 'ldplugin', 'LD_ALLOW_USER_GENREPORTS', 'Autoriser les utilisateurs à générer des rapports', '2010-11-12 20:15:52'),
(95, 'fr', 'ldplugin', 'ldsettingssaved', 'Les paramètres ont été enregistré avec succés !', '2010-11-12 20:31:48'),
(96, 'fr', 'ldplugin', 'LD_MAX_LINKS_REPORT', 'Maximum de liens dans le rapport', '2010-11-16 19:42:41'),
(97, 'fr', 'ldplugin', 'Number of links is greater than maximun links', 'Le nombre des liens est supérieur au maximum possible', '2010-11-16 19:59:59'),
(98, 'fr', 'ldplugin', 'Maximum links allowed', 'Nombre de liens maximum autorisés', '2010-11-16 20:06:14'),
(99, 'fr', 'ldplugin', 'LD_MAX_INDEXED_PAGES', 'Le nombre maximum de pages indexées à contrôler', '2010-11-24 20:10:28'),
(100, 'fr', 'ldplugin', 'Completed', 'terminé', '2010-11-25 18:17:26'),
(101, 'fr', 'ldplugin', 'In Complete', 'En cours', '2010-11-25 18:17:39'),
(102, 'fr', 'ldplugin', 'Not Started', 'En attente', '2010-11-25 18:17:51'),
(103, 'fr', 'ldplugin', 'savedindexpageswaiting', 'Enregistrement des pages indexées .. Veuillez patienter pendant l''analyse des liens retour ....', '2010-11-25 18:29:32'),
(104, 'fr', 'ldplugin', 'waitcrawlbacklinks', 'Veuillez patienter pendant l''analyse des détails de la prochaine série de liens retour....', '2010-11-25 18:34:05'),
(105, 'fr', 'ldplugin', 'to view the reports', 'pour voir les rapports', '2010-11-25 18:35:58'),
(106, 'fr', 'ldplugin', 'escapetostop', 'Appuyer sur la touche <b>escape</b> pour stopper le script', '2010-11-25 19:04:23'),
(107, 'fr', 'ldplugin', 'tostartreportgeneration', 'pour relancer l''execution du script si vous l''avez suspendu', '2010-11-25 19:05:48'),
(108, 'fr', 'ldplugin', 'Paged Indexed', 'Pages dans l''index', '2010-11-25 19:13:31'),
(109, 'fr', 'ldplugin', 'Total Backlinks', 'Total des liens retour', '2010-11-25 19:13:31'),
(110, 'fr', 'ldplugin', 'Crawled Backlinks', 'Liens retour explorés', '2010-11-25 19:13:43'),
(111, 'fr', 'ldplugin', 'Unique Anchors', 'Ancre unique', '2010-11-25 19:14:02'),
(112, 'fr', 'ldplugin', 'Excellent Links', 'Excellents', '2010-11-25 19:14:02'),
(113, 'fr', 'ldplugin', 'Good Links', 'Bons', '2010-11-25 19:14:13'),
(114, 'fr', 'ldplugin', 'Nofollow Links', 'Inutiles', '2010-11-25 19:14:23'),
(115, 'fr', 'ldplugin', 'Missing Title', 'Titres manquant', '2010-11-25 19:14:33'),
(116, 'fr', 'ldplugin', 'Anchor', 'Ancre', '2010-11-25 19:27:00'),
(117, 'fr', 'ldplugin', 'Link Type', 'Type de lien', '2010-11-25 19:27:19'),
(118, 'fr', 'ldplugin', 'Missing', 'Manquants', '2010-11-25 19:28:25'),
(119, 'fr', 'ldplugin', 'Nofollow', 'Inutiles', '2010-11-25 19:28:48'),
(120, 'fr', 'ldplugin', 'Good', 'Bons', '2010-11-25 19:29:12'),
(121, 'fr', 'ldplugin', 'Excellent', 'Excellents', '2010-11-25 19:29:29'),
(122, 'fr', 'ldplugin', 'Report Summary', 'Rapport rapide', '2010-11-25 19:31:49'),
(123, 'fr', 'ldplugin', 'Pages Indexed', 'Pages indexées', '2010-11-25 19:32:48'),
(124, 'fr', 'ldplugin', 'Popular Anchors', 'Ancre populaire', '2010-11-25 19:32:58'),
(125, 'fr', 'ldplugin', 'Report Url', 'Rapport des Url', '2010-11-25 19:37:16'),
(126, 'fr', 'ldplugin', 'Last Updated', 'Dernière mise-à-jour', '2010-11-25 19:38:36'),
(127, 'fr', 'ldplugin', 'Link Summary', 'Lien sommaire', '2010-11-25 19:44:42'),
(128, 'fr', 'ldplugin', 'Page Rank Summary', 'Page-Rank rapide', '2010-11-25 19:44:59'),
(129, 'fr', 'ldplugin', 'Total Results', 'Total des résultas', '2010-11-25 19:46:44'),
(130, 'fr', 'ldplugin', 'Backlink Url', 'Url du lien retour', '2010-11-25 19:52:51'),
(131, 'fr', 'ldplugin', 'Link Found', 'Lien trouvé', '2010-11-25 19:53:03'),
(132, 'fr', 'ldplugin', 'Outbound Links', 'Lien sortant', '2010-11-25 19:54:43'),
(133, 'fr', 'ldplugin', 'Popular Title', 'Titre populaire', '2010-11-25 20:34:09'),
(134, 'fr', 'ldplugin', 'Count', 'Compte', '2010-11-25 20:39:45'),
(135, 'fr', 'ldplugin', 'No Projects Found', 'Pas de projet !', '2010-11-25 21:01:43'),
(136, 'de', 'ldplugin', 'New Project', 'Neues Projekt', '2010-10-12 19:35:25'),
(137, 'de', 'ldplugin', 'Projects Manager', 'Projekt Manager', '2010-10-12 19:45:13'),
(138, 'de', 'ldplugin', 'Project already exist', 'Projekt existiert bereits', '2010-10-12 20:56:49'),
(139, 'de', 'ldplugin', 'Edit Project', 'Projekt bearbeiten', '2010-10-20 06:54:44'),
(140, 'de', 'ldplugin', 'Links Report Summary', 'Links Gesamtbericht', '2010-11-05 20:16:21'),
(150, 'de', 'ldplugin', 'Project', 'Projekt', '2010-10-26 17:34:23'),
(151, 'de', 'ldplugin', 'New Report', 'Neuer Bericht', '2010-10-26 17:44:35'),
(152, 'de', 'ldplugin', 'Updated', 'Aktualisiert', '2010-10-26 17:56:41'),
(153, 'de', 'ldplugin', 'Report already exist', 'Bericht existiert bereits', '2010-10-26 19:08:10'),
(154, 'de', 'ldplugin', 'Edit Report', 'Bericht bearbeiten', '2010-10-26 19:25:41'),
(155, 'de', 'ldplugin', 'Maximum Links', 'Maximale Links', '2010-10-26 19:57:04'),
(156, 'de', 'ldplugin', 'Run', 'Starten', '2010-10-28 18:12:48'),
(157, 'de', 'ldplugin', 'Generate Report', 'Bericht erstellen', '2010-11-03 20:47:05'),
(158, 'de', 'ldplugin', 'Links report generated successfully', 'Linkbericht erfolgreich erstellt!', '2010-11-03 21:21:46'),
(159, 'de', 'ldplugin', 'View', 'Anschauen', '2010-11-05 17:46:49'),
(160, 'de', 'ldplugin', 'View Reports', 'Berichte anschauen', '2010-11-05 18:53:10'),
(161, 'de', 'ldplugin', 'Report Type', 'Berichtart', '2010-11-05 18:59:50'),
(162, 'de', 'ldplugin', 'Backlinks Reports', 'Backlink Berichte', '2010-11-09 18:41:57'),
(163, 'de', 'ldplugin', 'Indexed Page Reports', 'Indizierte Seiten Berichte', '2010-11-09 20:02:53'),
(164, 'de', 'ldplugin', 'Most Popular Anchors', 'Meist verwendete Linktexte', '2010-11-09 20:32:06'),
(165, 'de', 'ldplugin', 'Report', 'Bericht', '2010-11-10 21:00:54'),
(166, 'de', 'ldplugin', 'Plugin Settings', 'Plugin Einstellungen', '2010-11-12 20:08:22'),
(167, 'de', 'ldplugin', 'LD_SEARCH_ENGINE', 'Backlink Suchmaschine', '2010-11-12 20:15:30'),
(168, 'de', 'ldplugin', 'LD_ALLOW_USER_REPORTS', 'Erlaube Benutzern Zugriff auf Berichte Manager', '2010-11-12 20:15:30'),
(169, 'de', 'ldplugin', 'LD_ALLOW_USER_GENREPORTS', 'Erlaube Benutzern Berichte zu erstellen', '2010-11-12 20:15:52'),
(170, 'de', 'ldplugin', 'ldsettingssaved', 'Plugin-Einstellungen erfolgreich gespeichert!', '2010-11-12 20:31:48'),
(171, 'de', 'ldplugin', 'LD_MAX_LINKS_REPORT', 'Maximale Links im Bericht', '2010-11-16 19:42:41'),
(172, 'de', 'ldplugin', 'Number of links is greater than maximun links', 'Anzahl liegt ueber erlaubtem Maximalwert', '2010-11-16 19:59:59'),
(173, 'de', 'ldplugin', 'Maximum links allowed', 'Maximale Links erlaubt', '2010-11-16 20:06:14'),
(174, 'de', 'ldplugin', 'LD_MAX_INDEXED_PAGES', 'Maximale Anzahl an zu indizierenden Seiten', '2010-11-24 20:10:28'),
(175, 'de', 'ldplugin', 'Completed', 'Komplett', '2010-11-25 18:17:26'),
(176, 'de', 'ldplugin', 'In Complete', 'Unvollständig', '2010-11-25 18:17:39'),
(177, 'de', 'ldplugin', 'Not Started', 'Nicht gestartet', '2010-11-25 18:17:51'),
(178, 'de', 'ldplugin', 'savedindexpageswaiting', 'Indizierende Seiten werden gespeichert..Warten auf Analyse von Backlinks....', '2010-11-25 18:29:32'),
(179, 'de', 'ldplugin', 'waitcrawlbacklinks', 'Warten auf Anaylseergebnisse der nächsten Backlinks....', '2010-11-25 18:34:05'),
(180, 'de', 'ldplugin', 'to view the reports', 'um Berichte zu sehen', '2010-11-25 18:35:58'),
(181, 'de', 'ldplugin', 'escapetostop', 'Drücke <b>escape</b> um die Analyse zu stoppen', '2010-11-25 19:04:23'),
(182, 'de', 'ldplugin', 'tostartreportgeneration', 'um nach einem Stopp weiter zu machen', '2010-11-25 19:05:48'),
(183, 'de', 'ldplugin', 'Paged Indexed', 'Indizierte Seiten', '2010-11-25 19:13:31'),
(184, 'de', 'ldplugin', 'Total Backlinks', 'Gesamte Backlinks', '2010-11-25 19:13:31'),
(185, 'de', 'ldplugin', 'Crawled Backlinks', 'Analysierte Backlinks', '2010-11-25 19:13:43'),
(186, 'de', 'ldplugin', 'Unique Anchors', 'Identischer Linktext', '2010-11-25 19:14:02'),
(187, 'de', 'ldplugin', 'Excellent Links', 'Exzellente Links', '2010-11-25 19:14:02'),
(188, 'de', 'ldplugin', 'Good Links', 'Gute Links', '2010-11-25 19:14:13'),
(189, 'de', 'ldplugin', 'Nofollow Links', 'Nofollow Links', '2010-11-25 19:14:23'),
(190, 'de', 'ldplugin', 'Missing Title', 'Fehlender Titel', '2010-11-25 19:14:33'),
(191, 'de', 'ldplugin', 'Anchor', 'Linktext', '2010-11-25 19:27:00'),
(192, 'de', 'ldplugin', 'Link Type', 'Linktyp', '2010-11-25 19:27:19'),
(193, 'de', 'ldplugin', 'Missing', 'Fehlend', '2010-11-25 19:28:25'),
(194, 'de', 'ldplugin', 'Nofollow', 'Nofollow', '2010-11-25 19:28:48'),
(195, 'de', 'ldplugin', 'Good', 'Gut', '2010-11-25 19:29:12'),
(196, 'de', 'ldplugin', 'Excellent', 'Exzellent', '2010-11-25 19:29:29'),
(197, 'de', 'ldplugin', 'Report Summary', 'Gesamtbericht', '2010-11-25 19:31:49'),
(198, 'de', 'ldplugin', 'Pages Indexed', 'Indizierte Seiten', '2010-11-25 19:32:48'),
(199, 'de', 'ldplugin', 'Popular Anchors', 'Häufige Linktexte', '2010-11-25 19:32:58'),
(200, 'de', 'ldplugin', 'Report Url', 'Bericht Url', '2010-11-25 19:37:16'),
(201, 'de', 'ldplugin', 'Last Updated', 'Letzte Aktualisierung', '2010-11-25 19:38:36'),
(203, 'de', 'ldplugin', 'Link Summary', 'Links Gesamt', '2010-11-25 19:44:42'),
(204, 'de', 'ldplugin', 'Page Rank Summary', 'Gesamtbericht', '2010-11-25 19:44:59'),
(205, 'de', 'ldplugin', 'Total Results', 'Gesamtergebnisse', '2010-11-25 19:46:44'),
(206, 'de', 'ldplugin', 'Backlink Url', 'Backlink Url', '2010-11-25 19:52:51'),
(207, 'de', 'ldplugin', 'Link Found', 'Links gefunden', '2010-11-25 19:53:03'),
(208, 'de', 'ldplugin', 'Outbound Links', 'Externe Links', '2010-11-25 19:54:43'),
(209, 'de', 'ldplugin', 'Popular Title', 'Beliebte Titel', '2010-11-25 20:34:09'),
(210, 'de', 'ldplugin', 'Count', 'Anzahl', '2010-11-25 20:39:45'),
(211, 'de', 'ldplugin', 'No Projects Found', 'Keine Pojekte gefunden!', '2010-11-25 21:01:43'),
(212, 'en', 'ldplugin', 'Waiting for crawling next set of backlinks', 'Waiting for crawling next set of backlinks', '2011-12-07 20:36:04'),
(213, 'en', 'ldplugin', 'crawlcompletedwaitmsg', 'Crawling Backlinks completed. Waiting for crawling details of backlinks', '2011-12-07 21:14:15'),
(216, 'en', 'ldplugin', 'Recheck Reports', 'Recheck Reports', '2011-12-09 19:38:12'),
(217, 'en', 'ldplugin', 'Reverify Backlinks', 'Reverify Backlinks', '2011-12-09 19:38:12'),
(218, 'en', 'ldplugin', 'Not Crawled', 'Not Crawled', '2014-03-12 21:10:34');

INSERT INTO ld_texts(`lang_code`, `category`, `label`, `content`) VALUES 
('en', 'ldplugin', 'Import Backlinks', 'Import Backlinks');

INSERT INTO ld_texts(`lang_code`, `category`, `label`, `content`) VALUES 
('en', 'ldplugin', 'Import Summary', 'Import Summary');

INSERT INTO ld_texts(`lang_code`, `category`, `label`, `content`) VALUES 
('en', 'ldplugin', 'Valid Links', 'Valid Links');

INSERT INTO ld_texts(`lang_code`, `category`, `label`, `content`) VALUES 
('en', 'ldplugin', 'Invalid Links', 'Invalid Links');

INSERT INTO ld_texts(`lang_code`, `category`, `label`, `content`) VALUES 
('en', 'ldplugin', 'Duplicate Links', 'Duplicate Links');

ALTER TABLE `ld_backlinks` CHANGE `google_pagerank` `google_pagerank` FLOAT NOT NULL DEFAULT '0';
ALTER TABLE `ld_backlinks`  ADD `domain_authority` FLOAT NOT NULL;
ALTER TABLE `ld_backlinks`  ADD `page_authority` FLOAT NOT NULL;

INSERT INTO `ld_seconfig` (`domain`, `url`, `cookie_send`, `no_of_results_page`, `start`, `start_offset`, `max_results`, `regex`, `url_index`, `title_index`, `description_index`, `encoding`, `next_link_regex`, `status`) VALUES
('moz', 'http://moz.com', '', 50, 0, 50, 100, '', 0, 2, 3, NULL, '', 1);

UPDATE `ld_settings` SET `set_val` = '8' WHERE `ld_settings`.`id` = 1;

ALTER TABLE `ld_backlinks` ADD `link_score` INT(6) NOT NULL DEFAULT '0' ;

INSERT INTO ld_texts(`lang_code`, `category`, `label`, `content`) VALUES 
('en', 'ldplugin', 'The number of outbound links', 'The number of outbound links');

INSERT INTO ld_texts(`lang_code`, `category`, `label`, `content`) VALUES 
('en', 'ldplugin', 'The page is having excellent domain authority value', 'The page is having excellent domain authority value');

INSERT INTO ld_texts(`lang_code`, `category`, `label`, `content`) VALUES 
('en', 'ldplugin', 'The page is having very good domain authority value', 'The page is having very good domain authority value');

INSERT INTO ld_texts(`lang_code`, `category`, `label`, `content`) VALUES 
('en', 'ldplugin', 'The page is having good domain authority value', 'The page is having good domain authority value');

INSERT INTO ld_texts(`lang_code`, `category`, `label`, `content`) VALUES 
('en', 'ldplugin', 'The page is having poor domain authority value', 'The page is having poor domain authority value');

INSERT INTO ld_texts(`lang_code`, `category`, `label`, `content`) VALUES 
('en', 'ldplugin', 'Poor', 'Poor');
INSERT INTO ld_texts(`lang_code`, `category`, `label`, `content`) VALUES 
('en', 'ldplugin', 'Great', 'Great');

--
-- version 3.0.0 changes
--

ALTER TABLE `ld_backlinks` CHANGE `domain_authority` `domain_authority` FLOAT NOT NULL DEFAULT '0';
ALTER TABLE `ld_backlinks` CHANGE `page_authority` `page_authority` FLOAT NOT NULL DEFAULT '0';


INSERT INTO `ld_texts` (`lang_code`, `category`, `label`, `content`) VALUES
('en', 'ldplugin', 'ld_backlink_count', 'Backlink Count');

INSERT INTO `ld_texts` (`lang_code`, `category`, `label`, `content`) VALUES
('en', 'ldplugin', 'Backlink count is greater than maximum links allowed', 'Backlink count is greater than maximum links allowed');

INSERT INTO `ld_texts` (`lang_code`, `category`, `label`, `content`) VALUES
('en', 'ldplugin', 'Backlink count is greater than plugin settings', 'Backlink count is greater than plugin settings');

INSERT INTO `ld_texts` (`lang_code`, `category`, `label`, `content`) VALUES
('en', 'ldplugin', 'total_link_max_link_error', "Total backlinks of report: [TOTAL_LINKS] is greater than maximum allowed links: [MAX_LINKS]");