INSERT INTO `wp_wpforms_tasks_meta` (`id`, `action`, `data`, `date`) VALUES
(66, 'wpforms_process_entry_emails', '[encoded data, 18244 characters]', '2022-01-06 17:44:48'),
(67, 'wpforms_process_entry_emails', '[encoded data, 18224 characters]', '2022-01-06 17:48:39');
INSERT INTO `wp_wpforms_tasks_meta` (`id`, `action`, `data`, `date`) VALUES
(68, 'wpforms_process_entry_emails', '[encoded data, 18228 characters]', '2022-01-06 17:48:39'),
(69, 'wpforms_process_entry_emails', '[encoded data, 18228 characters]', '2022-01-07 10:29:18');
INSERT INTO `wp_wpforms_tasks_meta` (`id`, `action`, `data`, `date`) VALUES
(70, 'wpforms_process_entry_emails', '[encoded data, 18232 characters]', '2022-01-07 10:29:18');

-- --------------------------------------------------------

--
-- Structure de la table `wp_wpmailsmtp_debug_events`
--

CREATE TABLE `wp_wpmailsmtp_debug_events` (
  `id` int(10) UNSIGNED NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `initiator` text COLLATE utf8mb4_unicode_ci,
  `event_type` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `wp_wpmailsmtp_debug_events`
--

INSERT INTO `wp_wpmailsmtp_debug_events` (`id`, `content`, `initiator`, `event_type`, `created_at`) VALUES
(1, 'Mailer: Sendinblue\r\n[unauthorized]: Key not found', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\SetupWizard.php\",\"line\":1111}', 0, '2021-11-19 11:51:22'),
(2, 'Mailer: Sendinblue\r\n[unauthorized]: Key not found', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-19 11:53:31'),
(3, 'Mailer: Sendinblue\r\n[unauthorized]: Key not found', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-19 11:54:47'),
(4, 'Mailer: Sendinblue\r\n[unauthorized]: Key not found', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-19 11:55:03'),
(5, 'Mailer: Sendinblue\r\n[unauthorized]: Key not found', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-19 11:57:35'),
(6, 'Mailer: Sendinblue\r\n[permission_denied]: Unable to send email. Your SMTP account is not yet activated. Please contact us at contact@sendinblue.com to request activation', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-19 12:01:08'),
(7, 'Mailer: Sendinblue\r\n[permission_denied]: Unable to send email. Your SMTP account is not yet activated. Please contact us at contact@sendinblue.com to request activation', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-19 12:01:53'),
(8, 'Mailer: Sendinblue\r\n[permission_denied]: Unable to send email. Your SMTP account is not yet activated. Please contact us at contact@sendinblue.com to request activation', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-19 12:05:29'),
(9, 'Mailer: Sendinblue\r\n[permission_denied]: Unable to send email. Your SMTP account is not yet activated. Please contact us at contact@sendinblue.com to request activation', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-19 12:09:03'),
(10, 'Mailer: Sendinblue\r\n[permission_denied]: Unable to send email. Your SMTP account is not yet activated. Please contact us at contact@sendinblue.com to request activation', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-19 12:09:49'),
(11, 'Mailer: Sendinblue\r\n[permission_denied]: Unable to send email. Your SMTP account is not yet activated. Please contact us at contact@sendinblue.com to request activation', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-19 12:10:12'),
(12, 'Mailer: Sendinblue\r\n[permission_denied]: Unable to send email. Your SMTP account is not yet activated. Please contact us at contact@sendinblue.com to request activation', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-19 12:10:25'),
(13, 'Mailer: Sendinblue\r\n[permission_denied]: Unable to send email. Your SMTP account is not yet activated. Please contact us at contact@sendinblue.com to request activation', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-19 12:39:19'),
(14, 'Mailer: Sendinblue\r\n[permission_denied]: Unable to send email. Your SMTP account is not yet activated. Please contact us at contact@sendinblue.com to request activation', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-19 13:44:19'),
(15, 'Mailer: Sendinblue\r\n[permission_denied]: Unable to send email. Your SMTP account is not yet activated. Please contact us at contact@sendinblue.com to request activation', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-19 13:47:24'),
(16, 'Mailer: Sendinblue\r\n[permission_denied]: Unable to send email. Your SMTP account is not yet activated. Please contact us at contact@sendinblue.com to request activation', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-19 13:47:48'),
(17, 'Mailer: Sendinblue\r\n[permission_denied]: Unable to send email. Your SMTP account is not yet activated. Please contact us at contact@sendinblue.com to request activation', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-19 13:48:22'),
(18, 'Mailer: Sendinblue\r\n[permission_denied]: Unable to send email. Your SMTP account is not yet activated. Please contact us at contact@sendinblue.com to request activation', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-19 13:57:44'),
(19, 'Mailer: Sendinblue\r\n[unauthorized]: Key not found', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-19 13:58:32'),
(20, 'Mailer: Sendinblue\r\n[unauthorized]: Key not found', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-22 11:54:58'),
(21, 'Mailer: Sendinblue\r\n[unauthorized]: Key not found', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-22 11:56:05'),
(22, 'Mailer: Sendinblue\r\n[unauthorized]: Key not found', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-22 11:56:50'),
(23, 'An error occurred when trying to get Gmail aliases: {\n  &quot;error&quot;: {\n    &quot;code&quot;: 401,\n    &quot;message&quot;: &quot;Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.&quot;,\n    &quot;errors&quot;: [\n      {\n        &quot;message&quot;: &quot;Login Required.&quot;,\n        &quot;domain&quot;: &quot;global&quot;,\n        &quot;reason&quot;: &quot;required&quot;,\n        &quot;location&quot;: &quot;Authorization&quot;,\n        &quot;locationType&quot;: &quot;header&quot;\n      }\n    ],\n    &quot;status&quot;: &quot;UNAUTHENTICATED&quot;,\n    &quot;details&quot;: [\n      {\n        &quot;@type&quot;: &quot;type.googleapis.com/google.rpc.ErrorInfo&quot;,\n        &quot;reason&quot;: &quot;CREDENTIALS_MISSING&quot;,\n        &quot;domain&quot;: &quot;googleapis.com&quot;,\n        &quot;metadata&quot;: {\n          &quot;service&quot;: &quot;gmail.googleapis.com&quot;,\n          &quot;method&quot;: &quot;caribou.api.proto.MailboxService.ListSendAs&quot;\n        }\n      }\n    ]\n  }\n}', '', 1, '2021-11-22 12:22:12'),
(24, 'An error occurred when trying to get Gmail aliases: {\n  &quot;error&quot;: {\n    &quot;code&quot;: 401,\n    &quot;message&quot;: &quot;Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.&quot;,\n    &quot;errors&quot;: [\n      {\n        &quot;message&quot;: &quot;Login Required.&quot;,\n        &quot;domain&quot;: &quot;global&quot;,\n        &quot;reason&quot;: &quot;required&quot;,\n        &quot;location&quot;: &quot;Authorization&quot;,\n        &quot;locationType&quot;: &quot;header&quot;\n      }\n    ],\n    &quot;status&quot;: &quot;UNAUTHENTICATED&quot;,\n    &quot;details&quot;: [\n      {\n        &quot;@type&quot;: &quot;type.googleapis.com/google.rpc.ErrorInfo&quot;,\n        &quot;reason&quot;: &quot;CREDENTIALS_MISSING&quot;,\n        &quot;domain&quot;: &quot;googleapis.com&quot;,\n        &quot;metadata&quot;: {\n          &quot;method&quot;: &quot;caribou.api.proto.MailboxService.ListSendAs&quot;,\n          &quot;service&quot;: &quot;gmail.googleapis.com&quot;\n        }\n      }\n    ]\n  }\n}', '', 1, '2021-11-22 12:23:09'),
(25, 'Mailer: Sendinblue\r\n[unauthorized]: Key not found', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-22 12:29:48'),
(26, 'Mailer: Sendinblue\r\n[permission_denied]: Unable to send email. Your SMTP account is not yet activated. Please contact us at contact@sendinblue.com to request activation', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-22 12:34:04'),
(27, 'Mailer: Sendinblue\r\n[permission_denied]: Unable to send email. Your SMTP account is not yet activated. Please contact us at contact@sendinblue.com to request activation', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-22 12:44:37'),
(28, 'Mailer: Sendinblue\r\n[permission_denied]: Unable to send email. Your SMTP account is not yet activated. Please contact us at contact@sendinblue.com to request activation', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-22 12:47:26'),
(29, 'Mailer: Sendinblue\r\n[permission_denied]: Unable to send email. Your SMTP account is not yet activated. Please contact us at contact@sendinblue.com to request activation', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-22 12:47:59'),
(30, 'Mailer: Sendinblue\r\n[permission_denied]: Unable to send email. Your SMTP account is not yet activated. Please contact us at contact@sendinblue.com to request activation', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Reports\\\\Emails\\\\Summary.php\",\"line\":112}', 0, '2021-11-22 13:01:07'),
(31, 'Mailer: Sendinblue\r\n[permission_denied]: Unable to send email. Your SMTP account is not yet activated. Please contact us at contact@sendinblue.com to request activation', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wpforms-lite\\\\src\\\\Emails\\\\Mailer.php\",\"line\":509}', 0, '2021-11-22 13:01:08'),
(32, 'Mailer: Sendinblue\r\n[permission_denied]: Unable to send email. Your SMTP account is not yet activated. Please contact us at contact@sendinblue.com to request activation', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-22 15:54:28'),
(33, 'Mailer: Sendinblue\r\n[permission_denied]: Unable to send email. Your SMTP account is not yet activated. Please contact us at contact@sendinblue.com to request activation', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-22 16:07:33'),
(34, 'Mailer: Sendinblue\r\n[permission_denied]: Unable to send email. Your SMTP account is not yet activated. Please contact us at contact@sendinblue.com to request activation', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-includes\\\\class-wp-recovery-mode-email-service.php\",\"line\":229}', 0, '2021-11-25 17:06:58'),
(35, 'Mailer: Sendinblue\r\n[0] cURL error 6: Could not resolve host: api.sendinblue.com (see https://curl.haxx.se/libcurl/c/libcurl-errors.html)', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 0, '2021-11-27 10:27:40'),
(36, 'An error occurred when trying to get Gmail aliases: {\n  &quot;error&quot;: {\n    &quot;code&quot;: 401,\n    &quot;message&quot;: &quot;Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.&quot;,\n    &quot;errors&quot;: [\n      {\n        &quot;message&quot;: &quot;Login Required.&quot;,\n        &quot;domain&quot;: &quot;global&quot;,\n        &quot;reason&quot;: &quot;required&quot;,\n        &quot;location&quot;: &quot;Authorization&quot;,\n        &quot;locationType&quot;: &quot;header&quot;\n      }\n    ],\n    &quot;status&quot;: &quot;UNAUTHENTICATED&quot;,\n    &quot;details&quot;: [\n      {\n        &quot;@type&quot;: &quot;type.googleapis.com/google.rpc.ErrorInfo&quot;,\n        &quot;reason&quot;: &quot;CREDENTIALS_MISSING&quot;,\n        &quot;domain&quot;: &quot;googleapis.com&quot;,\n        &quot;metadata&quot;: {\n          &quot;method&quot;: &quot;caribou.api.proto.MailboxService.ListSendAs&quot;,\n          &quot;service&quot;: &quot;gmail.googleapis.com&quot;\n        }\n      }\n    ]\n  }\n}', '', 1, '2022-01-05 13:11:49'),
(37, 'An error occurred when trying to get Gmail aliases: {\n  &quot;error&quot;: {\n    &quot;code&quot;: 401,\n    &quot;message&quot;: &quot;Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.&quot;,\n    &quot;errors&quot;: [\n      {\n        &quot;message&quot;: &quot;Login Required.&quot;,\n        &quot;domain&quot;: &quot;global&quot;,\n        &quot;reason&quot;: &quot;required&quot;,\n        &quot;location&quot;: &quot;Authorization&quot;,\n        &quot;locationType&quot;: &quot;header&quot;\n      }\n    ],\n    &quot;status&quot;: &quot;UNAUTHENTICATED&quot;,\n    &quot;details&quot;: [\n      {\n        &quot;@type&quot;: &quot;type.googleapis.com/google.rpc.ErrorInfo&quot;,\n        &quot;reason&quot;: &quot;CREDENTIALS_MISSING&quot;,\n        &quot;domain&quot;: &quot;googleapis.com&quot;,\n        &quot;metadata&quot;: {\n          &quot;service&quot;: &quot;gmail.googleapis.com&quot;,\n          &quot;method&quot;: &quot;caribou.api.proto.MailboxService.ListSendAs&quot;\n        }\n      }\n    ]\n  }\n}', '', 1, '2022-01-05 13:12:51'),
(38, 'An error occurred when trying to get Gmail aliases: {\n  &quot;error&quot;: {\n    &quot;code&quot;: 401,\n    &quot;message&quot;: &quot;Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.&quot;,\n    &quot;errors&quot;: [\n      {\n        &quot;message&quot;: &quot;Login Required.&quot;,\n        &quot;domain&quot;: &quot;global&quot;,\n        &quot;reason&quot;: &quot;required&quot;,\n        &quot;location&quot;: &quot;Authorization&quot;,\n        &quot;locationType&quot;: &quot;header&quot;\n      }\n    ],\n    &quot;status&quot;: &quot;UNAUTHENTICATED&quot;,\n    &quot;details&quot;: [\n      {\n        &quot;@type&quot;: &quot;type.googleapis.com/google.rpc.ErrorInfo&quot;,\n        &quot;reason&quot;: &quot;CREDENTIALS_MISSING&quot;,\n        &quot;domain&quot;: &quot;googleapis.com&quot;,\n        &quot;metadata&quot;: {\n          &quot;method&quot;: &quot;caribou.api.proto.MailboxService.ListSendAs&quot;,\n          &quot;service&quot;: &quot;gmail.googleapis.com&quot;\n        }\n      }\n    ]\n  }\n}', '', 1, '2022-01-05 13:31:43'),
(39, 'An email request was sent to the Gmail API.', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 1, '2022-01-05 13:32:25'),
(40, 'An email request was sent to the Gmail API.', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 1, '2022-01-05 14:00:53'),
(41, 'An error occurred when trying to get Gmail aliases: {\n  &quot;error&quot;: {\n    &quot;code&quot;: 401,\n    &quot;message&quot;: &quot;Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.&quot;,\n    &quot;errors&quot;: [\n      {\n        &quot;message&quot;: &quot;Login Required.&quot;,\n        &quot;domain&quot;: &quot;global&quot;,\n        &quot;reason&quot;: &quot;required&quot;,\n        &quot;location&quot;: &quot;Authorization&quot;,\n        &quot;locationType&quot;: &quot;header&quot;\n      }\n    ],\n    &quot;status&quot;: &quot;UNAUTHENTICATED&quot;,\n    &quot;details&quot;: [\n      {\n        &quot;@type&quot;: &quot;type.googleapis.com/google.rpc.ErrorInfo&quot;,\n        &quot;reason&quot;: &quot;CREDENTIALS_MISSING&quot;,\n        &quot;domain&quot;: &quot;googleapis.com&quot;,\n        &quot;metadata&quot;: {\n          &quot;method&quot;: &quot;caribou.api.proto.MailboxService.ListSendAs&quot;,\n          &quot;service&quot;: &quot;gmail.googleapis.com&quot;\n        }\n      }\n    ]\n  }\n}', '', 1, '2022-01-06 14:31:38'),
(42, 'An email request was sent to the Gmail API.', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 1, '2022-01-06 14:38:20'),
(43, 'An email request was sent to the Gmail API.', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 1, '2022-01-06 14:39:14'),
(44, 'An email request was sent to the Gmail API.', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 1, '2022-01-06 15:32:10'),
(45, 'An error occurred when trying to get Gmail aliases: {\n  &quot;error&quot;: {\n    &quot;code&quot;: 401,\n    &quot;message&quot;: &quot;Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.&quot;,\n    &quot;errors&quot;: [\n      {\n        &quot;message&quot;: &quot;Login Required.&quot;,\n        &quot;domain&quot;: &quot;global&quot;,\n        &quot;reason&quot;: &quot;required&quot;,\n        &quot;location&quot;: &quot;Authorization&quot;,\n        &quot;locationType&quot;: &quot;header&quot;\n      }\n    ],\n    &quot;status&quot;: &quot;UNAUTHENTICATED&quot;,\n    &quot;details&quot;: [\n      {\n        &quot;@type&quot;: &quot;type.googleapis.com/google.rpc.ErrorInfo&quot;,\n        &quot;reason&quot;: &quot;CREDENTIALS_MISSING&quot;,\n        &quot;domain&quot;: &quot;googleapis.com&quot;,\n        &quot;metadata&quot;: {\n          &quot;method&quot;: &quot;caribou.api.proto.MailboxService.ListSendAs&quot;,\n          &quot;service&quot;: &quot;gmail.googleapis.com&quot;\n        }\n      }\n    ]\n  }\n}', '', 1, '2022-01-06 15:49:58'),
(46, 'An email request was sent to the Gmail API.', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 1, '2022-01-06 15:51:30'),
(47, 'An error occurred when trying to get Gmail aliases: {\n  &quot;error&quot;: {\n    &quot;code&quot;: 401,\n    &quot;message&quot;: &quot;Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.&quot;,\n    &quot;errors&quot;: [\n      {\n        &quot;message&quot;: &quot;Login Required.&quot;,\n        &quot;domain&quot;: &quot;global&quot;,\n        &quot;reason&quot;: &quot;required&quot;,\n        &quot;location&quot;: &quot;Authorization&quot;,\n        &quot;locationType&quot;: &quot;header&quot;\n      }\n    ],\n    &quot;status&quot;: &quot;UNAUTHENTICATED&quot;,\n    &quot;details&quot;: [\n      {\n        &quot;@type&quot;: &quot;type.googleapis.com/google.rpc.ErrorInfo&quot;,\n        &quot;reason&quot;: &quot;CREDENTIALS_MISSING&quot;,\n        &quot;domain&quot;: &quot;googleapis.com&quot;,\n        &quot;metadata&quot;: {\n          &quot;method&quot;: &quot;caribou.api.proto.MailboxService.ListSendAs&quot;,\n          &quot;service&quot;: &quot;gmail.googleapis.com&quot;\n        }\n      }\n    ]\n  }\n}', '', 1, '2022-01-06 16:00:25'),
(48, 'An email request was sent to the Gmail API.', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 1, '2022-01-06 16:01:28'),
(49, 'An email request was sent to the Gmail API.', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 1, '2022-01-06 16:03:40'),
(50, 'An email request was sent to the Gmail API.', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-admin\\\\includes\\\\class-wp-automatic-updater.php\",\"line\":908}', 1, '2022-01-07 10:27:12'),
(51, 'An email request was sent to the Gmail API.', '{\"file\":\"C:\\\\xampp\\\\htdocs\\\\ersenportail\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Admin\\\\Pages\\\\TestTab.php\",\"line\":314}', 1, '2022-01-07 11:52:47');

-- --------------------------------------------------------

--
-- Structure de la table `wp_wpmailsmtp_tasks_meta`
--

CREATE TABLE `wp_wpmailsmtp_tasks_meta` (
  `id` bigint(20) NOT NULL,
  `action` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `data` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `wp_wpmailsmtp_tasks_meta`
--

INSERT INTO `wp_wpmailsmtp_tasks_meta` (`id`, `action`, `data`, `date`) VALUES
(1, 'wp_mail_smtp_summary_report_email', 'W10=', '2021-11-19 11:40:38'),
(2, 'wp_mail_smtp_send_usage_data', 'W10=', '2021-11-19 11:51:21'),
(3, 'wp_mail_smtp_admin_notifications_update', 'W10=', '2021-11-19 11:51:30'),
(4, 'wp_mail_smtp_admin_notifications_update', 'W10=', '2021-11-22 11:49:38'),
(5, 'wp_mail_smtp_admin_notifications_update', 'W10=', '2021-11-23 16:40:22'),
(6, 'wp_mail_smtp_admin_notifications_update', 'W10=', '2021-11-24 23:22:43'),
(7, 'wp_mail_smtp_admin_notifications_update', 'W10=', '2021-11-27 10:24:34'),
(8, 'wp_mail_smtp_admin_notifications_update', 'W10=', '2022-01-05 13:11:28'),
(9, 'wp_mail_smtp_admin_notifications_update', 'W10=', '2022-01-05 13:12:50'),
(10, 'wp_mail_smtp_admin_notifications_update', 'W10=', '2022-01-06 14:30:03'),
(11, 'wp_mail_smtp_admin_notifications_update', 'W10=', '2022-01-06 14:31:00');

-- --------------------------------------------------------

--
-- Structure de la table `wp_xyz_ips_short_code`
--

CREATE TABLE `wp_xyz_ips_short_code` (
  `id` int(11) NOT NULL,
  `title` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_code` varchar(2000) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `wp_xyz_ips_short_code`
--

INSERT INTO `wp_xyz_ips_short_code` (`id`, `title`, `content`, `short_code`, `status`) VALUES
(2, 'nbreSHS', '<!DOCTYPE html>\r\n<html>\r\n    <head>\r\n        <title>MCH</title>\r\n        <meta charset=\"utf-8\">\r\n        <link rel=\"stylesheet\" href=\"mch.css\">\r\n    </head>\r\n    <body>\r\n        <?php\r\n            $servername = \'mysql:host=94.23.252.168;dbname=ersendb\';\r\n            $username = \'root\';\r\n            $password = \'prose@111\';\r\n\r\n            $conn = new PDO($servername, $username, $password);\r\n\r\n            if ($conn) {\r\n                $req=\"select count(*) as nbr from ersen_centrale where typecentrale like \'SHS\'\";\r\n                $res=$conn->query($req);\r\n                if ($res) {\r\n\r\n                    while ($ligne=$res->fetch()) {\r\n                    ?>\r\n\r\n                    <h1><?php echo $ligne[\'nbr\'];?></h1>\r\n\r\n                    <?php\r\n                    }      \r\n                    }else{\r\n\r\n                        echo \"requete echoué !\";\r\n                    }               \r\n                }else{\r\n                echo \"Erreur de connexion !\";\r\n            }\r\n         ?>\r\n    </body>\r\n</html>', '[xyz-ips snippet=\"nbreSHS\"]', 1),
(3, 'nbreMCH', '<!DOCTYPE html>\r\n<html>\r\n    <head>\r\n        <title>MCH</title>\r\n        <meta charset=\"utf-8\">\r\n        <link rel=\"stylesheet\" href=\"mch.css\">\r\n    </head>\r\n    <body>\r\n        <?php\r\n            $servername = \'mysql:host=94.23.252.168;dbname=ersendb\';\r\n            $username = \'root\';\r\n            $password = \'prose@111\';\r\n            $conn = new PDO($servername, $username, $password);\r\n            if ($conn) {\r\n                $req=\"select count(*) as nbr from ersen_centrale where typecentrale like \'MCH\'\";\r\n                $res=$conn->query($req);\r\n                if ($res) {\r\n\r\n                    while ($ligne=$res->fetch()) {\r\n                    ?>\r\n                        <h1><?php echo $ligne[\'nbr\'];?></h1>\r\n                    <?php\r\n                    }      \r\n                    }else{\r\n                        echo \"requete echoué !\";\r\n                    }               \r\n                }else{\r\n                echo \"Erreur de connexion !\";\r\n            }\r\n        ?>\r\n    </body>\r\n</html>', '[xyz-ips snippet=\"nbreMCH\"]', 1),
(4, 'footerpage', '<?php\r\n    $servername=\"mysql:host=94.23.252.168;dbname=ersendb\";\r\n    $username=\"root\";\r\n    $password=\"prose@111\";\r\n    $connexion=new PDO($servername,$username,$password);\r\n    if(!$connexion){\r\n      echo\"Erreur de connexion !\";\r\n    }\r\n    $req=\"SELECT COUNT(*) AS nbrAbonneDeTypeMenage FROM ersen_abonne,ersen_centrale,ersen_typecategorie,ersen_categorie\r\n    WHERE ersen_abonne.centrale=ersen_centrale.id\r\n    AND ersen_abonne.typecategorie=ersen_typecategorie.id\r\n    AND ersen_typecategorie.categorie=ersen_categorie.id\r\n    AND ersen_centrale.nom =\'Mini-centrale de KERRE\'\r\n    AND ersen_categorie.libelle = \'Ménages\'\";\r\n    $resultat1=$connexion->query($req);\r\n\r\n    $req2=\"SELECT COUNT(*) AS nbrAbonneDeTypeMenage1 FROM ersen_abonne,ersen_centrale,ersen_typecategorie,ersen_categorie\r\n    WHERE ersen_abonne.centrale=ersen_centrale.id\r\n    AND ersen_abonne.typecategorie=ersen_typecategorie.id\r\n    AND ersen_typecategorie.categorie=ersen_categorie.id\r\n    AND ersen_centrale.nom =\'Mini-centrale de NDOMBIL\'\r\n    AND ersen_categorie.libelle = \'Ménages\'\";\r\n    $resultat2=$connexion->query($req2);\r\n?>\r\n\r\n\r\n\r\n\r\n<!DOCTYPE html>\r\n<html lang=\"en\">\r\n<head>\r\n  <title>footerpageWorpresse</title>\r\n  <meta charset=\"utf-8\">\r\n  <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\r\n  <link rel=\"stylesheet\" href=\"https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css\">\r\n  <script src=\"https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js\"></script>\r\n  <script src=\"https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js\"></script>\r\n</head>\r\n<body>\r\n\r\n<div class=\"container\" style=\"background-color:blue\">\r\n    <br><br>\r\n    <div class=\"col-md-3\">\r\n      <div class=\"thumbnail\">\r\n          <img src=\"photos/nbr_de_localite.PNG\" alt=\"Fjords\" style=\"width:90%\">\r\n          <div class=\"caption\">\r\n            <p>\r\n                <?php\r\n                echo\"le nombre d\'abonne de type Ménage pour chaque centrale : \\n\";\r\n                    if($ligne=$resultat1->fetch()){\r\n                      echo \"Mini-centrale de KERRE: \".$ligne[\"nbrAbonneDeTypeMenage\"];\r\n                    }\r\n                    if($ligne2=$resultat2->fetch()){\r\n                      echo \"Mini-centrale de KERRE: \".$ligne2[\"nbrAbonneDeTypeMenage1\"];\r\n                    }\r\n                ?>\r\n            </p>\r\n        </div>\r\n      </div>\r\n    </div>\r\n\r\n    <div class=\"col-md-3\">\r\n      <div class=\"thumbnail\">\r\n          <img src=\"photos/nbr_de_menages.PNG\" alt=\"Nature\" style=\"width:90%\">\r\n          <div class=\"caption\">\r\n            <p>\r\n                <?php\r\n                    echo\"le nombre d\'abonne de type infrastructure socio-communitaires pour chaque centrale : \\n\";\r\n                    \r\n                ?>\r\n            </p>\r\n          </div>\r\n      </div>\r\n    </div>\r\n  <div class=\"row\">\r\n    <div class=\"col-md-3\">\r\n      <div class=\"thumbnail\">\r\n          <img src=\"photos/nbr_de_infrastructures.PNG\" alt=\"Nature\" style=\"width:90%\">\r\n          <div class=\"caption\">\r\n            <p>\r\n                <?php\r\n                    echo \"nombre de d\'abonne par centrale de type infrastructures socio-communitaires ?\";\r\n                ?>\r\n            </p>\r\n            \r\n          </div>\r\n      </div>\r\n    </div>\r\n\r\n    \r\n    <div class=\"col-md-3\">\r\n      <div class=\"thumbnail\">\r\n          <img src=\"photos/nbre_PMes.PNG\" alt=\"Nature\" style=\"width:90%\">\r\n          <div class=\"caption\">\r\n            <p>\r\n                <?php\r\n                    echo \"nombre de d\'abonne par centrale de type AGR\";\r\n                ?>\r\n            </p>\r\n          </div>\r\n      </div>\r\n    </div>\r\n  </div>\r\n</div>\r\n</body>\r\n</html>', '[xyz-ips snippet=\"footerpage\"]', 1),
(5, 'dynamicTable', '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n<head>\r\n    <meta charset=\"UTF-8\">\r\n    <title>Document</title>\r\n</head>\r\n<body>\r\n<?php \r\n\r\n    function nombreAbonne($nomcentrale,$typeabonne){\r\n        $servername=\"mysql:host=94.23.252.168;dbname=ersendb\";\r\n        $username=\"root\";\r\n        $password=\"prose@111\";\r\n        $connexion=new PDO($servername,$username,$password);\r\n        \r\n        if($connexion){\r\n            $query=\"SELECT count(*) as nbreTypeAbonne FROM ersen_abonne,ersen_centrale,ersen_typecategorie,ersen_categorie\r\n            WHERE ersen_abonne.centrale=ersen_centrale.id\r\n            AND ersen_abonne.typecategorie=ersen_typecategorie.id\r\n            AND ersen_typecategorie.categorie=ersen_categorie.id\r\n            AND ersen_centrale.nom = \'$nomcentrale\'\r\n            AND ersen_categorie.libelle = \'$typeabonne\'\";\r\n\r\n            $result=$connexion->query($query); \r\n                     \r\n            $pdo=$result->fetch();\r\n            if($pdo){\r\n                $resultat=$pdo[\'nbreTypeAbonne\'];\r\n            }else{\r\n                $resultat=null;\r\n            }\r\n        }\r\n        return $resultat;\r\n    }\r\n?>\r\n<?php \r\n    function nombreAbonneDynamic(){\r\n        $servername=\"mysql:host=94.23.252.168;dbname=ersendb\";\r\n        $username=\"root\";\r\n        $password=\"prose@111\";\r\n        $connexion=new PDO($servername,$username,$password);\r\n        if($connexion){\r\n            $query=\"SELECT DISTINCT ersen_centrale.nom AS nom,ersen_categorie.libelle AS libelle \r\n                        FROM ersen_abonne,ersen_centrale,ersen_typecategorie,ersen_categorie\r\n                        WHERE ersen_abonne.centrale=ersen_centrale.id\r\n                        AND ersen_abonne.typecategorie=ersen_typecategorie.id\r\n                        AND ersen_typecategorie.categorie=ersen_categorie.id\";\r\n            $pdo=$connexion->query($query);\r\n            ?>\r\n            <table class=\"table table-hover\">\r\n                <thead style=\"background-color: #1E88E5; color: white;\">\r\n                    <tr>\r\n                        <th style=\"border: 2px solid blue\">Nom</th>\r\n                        <th style=\"border: 2px solid blue\">Nombre</th>\r\n                        <th style=\"border: 2px solid blue\">Type</th>\r\n                    </tr>\r\n                </thead>\r\n                \r\n                <tbody style=\"background-color: #8C9EFF;color:black;\">\r\n                    <?php while($row=$pdo->fetch()){?>\r\n                    <tr>\r\n                        <?php $appel=nombreAbonne($row[\'nom\'],$row[\'libelle\']); ?>\r\n                        <td style=\"border: 2px solid blue\"><?php echo $row[\'nom\'];?></td>\r\n                        <td style=\"border: 2px solid blue\"><?php echo $appel.\' abonnes\';?></td>\r\n                        <td style=\"border: 2px solid blue\"><?php echo $row[\'libelle\'];?></td>\r\n                    </tr>\r\n                    <?php } ?>\r\n                </tbody>\r\n            </table>\r\n\r\n            <?php\r\n        }\r\n    }\r\n?>\r\n<h4 style=\"margin-left: 450px;\">Les abonnes pour chaque centrale </h4>\r\n<?php echo nombreAbonneDynamic(); ?>\r\n</body>\r\n</html>', '[xyz-ips snippet=\"dynamicTable\"]', 1),
(6, 'recherche', '<style>\r\n    #div1{\r\n        margin-left:950px;\r\n    }\r\n</style>\r\n<?php\r\n define(\'PAR_PAGE\',3);\r\n    $servername=\"mysql:host=94.23.252.168;dbname=ersendb\";\r\n    $username=\"root\";\r\n    $password=\"prose@111\";\r\n    $connexion = new pdo($servername,$username,$password);\r\n?>\r\n\r\n<!DOCTYPE html>\r\n<html lang=\"fr\">\r\n<head>\r\n     <meta charset=\"UTF-8\">\r\n     <script src=\"https://code.jquery.com/jquery-3.6.0.js\" integrity=\"sha256-H+K7U5CnXl1h5ywQfKtSj8PCmoN9aaq30gDh27Xc0jk=\"crossorigin=\"anonymous\"></script> \r\n    <link rel=\"stylesheet\" href=\"https://cdn.datatables.net/1.11.3/css/jquery.dataTables.min.css\">\r\n     <script src=\"https://cdn.datatables.net/1.11.3/js/jquery.dataTables.min.js\"></script>\r\n     <script src=\"https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js\" integrity=\"sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM\" crossorigin=\"anonymous\"></script>\r\n    <title>Autre tableau</title>\r\n    </head>\r\n<body>\r\n    <br><br>\r\n    <div class=\"container\">\r\n        <div class=\"row\">\r\n            <div class=\"col-6\">\r\n                <form action=\"\" method=\"POST\">\r\n                    <select name=\"selctMenu\" id=\"\">\r\n                        <option value=\"\">----Selectionnez pour voir ses details----</option>\r\n                        <option value=\"1\">Centrales</option>\r\n                        <option value=\"2\">Projets</option>\r\n                        <option value=\"3\">villages polarisés</option>\r\n                        <option value=\"4\">Opérateurs</option>\r\n                    </select>\r\n                    <input type=\"submit\" name=\"submit\" id=\"\" value=\"Afficher\">\r\n                </form>\r\n\r\n            </div>\r\n        </div>\r\n\r\n    </div>\r\n    <?php\r\n        if(isset($_POST[\"submit\"])){\r\n            if(isset($_POST[\"selctMenu\"])){\r\n                $selctMenu= $_POST[\"selctMenu\"];\r\n                    switch($selctMenu){\r\n                        case \'1\':?>\r\n                            <div class=\"container\">\r\n                                <div class=\"row\">\r\n                                    <div class=\"col-md-8 col-md-offset-2\"><br/>\r\n                                        <h4 style=\"margin-left:200px;\">les centrales disponible</h4>\r\n                                            <table class=\"table table-bordred table-hover\" id=\'mytable\'style=\"width:900px;height:100px;\">\r\n                                                <thead style=\"background-color: #1E88E5; color: white;\">\r\n                                                        <td style=\"height: 50px; width: 100px;\">Nom</td>\r\n                                                        <td style=\"height: 50px; width: 100px;\">Adresse</td>\r\n                                                        <td style=\"height: 50px; width: 100px;\">Type</td>\r\n                                                        <td style=\"height: 50px; width: 100px;\">Date demarrage</td>\r\n                                                        <td style=\"height: 50px; width: 100px;\">Village</td>\r\n                                                </thead>\r\n                                                <tbody>\r\n                                                <?php\r\n                                                    $query=\"SELECT c.nom AS nom,c.adresse AS adresse,t.libelle AS libelletype,c.datedemarrage datedemarrage,v.libelle AS village \r\n                                                    FROM ersen_centrale c,ersen_typecentrale t,ersen_villagequartier v\r\n                                                    WHERE c.typecentrale=t.id\r\n                                                    AND c.village=v.id\";\r\n                                                    $sql=$connexion->query($query);\r\n                                                    while($data=$sql->fetch()){?>\r\n                                                        <tr style=\"background-color: #8C9EFF;color:black;height: 50px; width: 100px;\">\r\n                                                            <td style=\"background-color: #8C9EFF;color:black;height: 50px; width: 100px;\"><?php echo $data[\'nom\']?></td>\r\n                                                            <td style=\"background-color: #8C9EFF;color:black;height: 50px; width: 100px;\"><?php echo $data[\'adresse\']?></td>\r\n                                                            <td style=\"background-color: #8C9EFF;color:black;height: 50px; width: 100px;\"><?php echo $data[\'libelletype\']?></td>\r\n                                                            <td style=\"background-color: #8C9EFF;color:black;height: 50px; width: 100px;\"><?php echo $data[\'datedemarrage\']?></td>\r\n                                                            <td style=\"background-color: #8C9EFF;color:black;height: 50px; width: 100px;\"><?php echo $data[\'village\']?></td>\r\n                                                            </tr>\r\n                                                            \r\n                                                            <?php\r\n                                                        }\r\n                                                    ?> \r\n                                                    </tbody>\r\n                                                </table>\r\n                                            </div>\r\n                                        </div>\r\n\r\n                                    </div>\r\n                                <script>\r\n                                    $(document).ready(function(){\r\n                                        $(\'#mytable\').DataTable();\r\n                                    });\r\n                                </script>\r\n                                <?php\r\n                            break;\r\n                        case \'2\':?>\r\n                            <div class=\"container\">\r\n                                <div class=\"row\">\r\n                                    <div class=\"col-md-8 col-md-offset-2\"><br/>\r\n                                        <h4 style=\"margin-left:200px\">les projets</h4>\r\n                                        <table class=\"table table-bordred table-hover\" id=\'mytable\' style=\"width:900px;height:100px;\">\r\n                                            <thead style=\"background-color: #1E88E5; color: white;\">\r\n                                            <td>nom</td>\r\n                                            </thead>\r\n                                            <tbody>\r\n                                                <?php\r\n                                                    $query=\"SELECT * FROM ersen_projet\";\r\n                                                    $sql=$connexion->query($query);\r\n                                                    while($data=$sql->fetch()){?>\r\n                                                    <tr style=\"background-color: #8C9EFF;color:black;\">\r\n                                                    <td style=\"background-color: #8C9EFF;color:black;\"><?php echo $data[\'nom\']?></td>\r\n                                                    </tr>\r\n                                                            \r\n                                                        <?php\r\n                                                        }\r\n                                                    ?> \r\n                                            </tbody>\r\n                                            </table>\r\n                                        </div>\r\n                                    </div>\r\n                                </div>\r\n                            <script>\r\n                                $(document).ready(function(){\r\n                                    $(\'#mytable\').DataTable();\r\n                                });\r\n                            </script>\r\n                            <?php\r\n                            break;\r\n                        case \'3\':\r\n                            ?>\r\n                            \r\n                             <div class=\"container\">\r\n                                <div class=\"row\">\r\n                                    <div class=\"col-md-8 col-md-offset-2\"><br/>\r\n                                        <h4 style=\"margin-left:200px\">les villages</h4>\r\n                                        <table class=\"table table-bordred table-hover\" id=\'mytable\' style=\"width:900px;height:100px;\">\r\n                                        <thead style=\"background-color: #1E88E5; color: white;\">\r\n                                        <td>Village</code></td>\r\n                                        <td>Etat</td>\r\n                                        <td>Centrale</td>\r\n                                        </thead>\r\n                                        <tbody>\r\n                                            <?php\r\n                                            $query=\"SELECT vq.libelle AS libelle,vp.etat AS etat,c.nom AS nom\r\n                                            FROM ersen_village_polarise vp,ersen_villagequartier vq,ersen_centrale c\r\n                                            WHERE vp.villagequartier=vq.id\r\n                                            AND vp.centrale=c.id\";\r\n                                                    $sql=$connexion->query($query);\r\n                                            while($data=$sql->fetch()){?>\r\n                                                <tr style=\"background-color: #8C9EFF;color:black;\">\r\n                                                    <td style=\"background-color: #8C9EFF;color:black;\"><?php echo $data[\'libelle\']?></td>\r\n                                                    <td style=\"background-color: #8C9EFF;color:black;\"><?php echo $data[\'etat\']?></td>\r\n                                                    <td style=\"background-color: #8C9EFF;color:black;\"><?php echo $data[\'nom\']?></td>\r\n                                                </tr>\r\n                                                        \r\n                                                        <?php\r\n                                                    }\r\n                                                ?> \r\n                                                </tbody>\r\n                                            </table>\r\n                                        </div>\r\n                                    </div>\r\n\r\n                                </div>\r\n                            <script>\r\n                                $(document).ready(function(){\r\n                                    $(\'#mytable\').DataTable();\r\n                                });\r\n                            </script>\r\n                            <?php\r\n                            break;\r\n\r\n                        case \'4\':?>\r\n                            <div class=\"container\">\r\n                                <div class=\"row\">\r\n                                    <div class=\"col-md-8 col-md-offset-2\"><br/>\r\n                                        <h4 style=\"margin-left:200px\">les operateurs</h4>\r\n                                            <table class=\"table table-bordred table-hover\" id=\'mytable\' style=\"width:900px;height:100px;\">\r\n                                                <thead style=\"background-color: #1E88E5; color: white;\">\r\n                                                    <td>nom</td>\r\n                                                    <td>adresse</td>\r\n                                                    <td>Responsable</td>\r\n                                                </thead>\r\n                                                <tbody>\r\n                                                <?php\r\n                                                    $query=\"SELECT * FROM ersen_operateur\";\r\n                                                    $sql=$connexion->query($query);\r\n                                                    while($data=$sql->fetch()){?>\r\n                                                        <tr style=\"background-color: #8C9EFF;color:black;\">\r\n                                                            <td style=\"background-color: #8C9EFF;color:black;\"><?php echo $data[\'nom\']?></td>\r\n                                                            <td style=\"background-color: #8C9EFF;color:black;\"><?php echo $data[\'adresse\']?></td>\r\n                                                            <td style=\"background-color: #8C9EFF;color:black;\"><?php echo $data[\'responsable\']?></td>\r\n                                                        </tr>\r\n                                                        \r\n                                                        <?php\r\n                                                    }\r\n                                                ?> \r\n                                                </tbody>\r\n                                            </table>\r\n                                        </div>\r\n                                    </div>\r\n\r\n                                </div>\r\n                            <script>\r\n                                $(document).ready(function(){\r\n                                    $(\'#mytable\').DataTable();\r\n                                });\r\n                            </script>\r\n                            <?php\r\n                            break;\r\n                        default:\r\n                            echo \"Aucun objet n\'est selectionné !\";\r\n                            break;\r\n                            \r\n    \r\n                    }\r\n            }\r\n        }\r\n    ?>\r\n</body>\r\n</html>', '[xyz-ips snippet=\"recherche\"]', 1),
(7, 'listeProjets', '<!DOCTYPE html>\r\n<html>\r\n    <head>\r\n        <title>MCH</title>\r\n        <meta charset=\"utf-8\">\r\n        <link rel=\"stylesheet\" href=\"mch.css\">\r\n    </head>\r\n    <body>\r\n        <?php\r\n            $servername = \'mysql:host=94.23.252.168;dbname=ersendb\';\r\n            $username = \'root\';\r\n            $password = \'prose@111\';\r\n\r\n            $conn = new PDO($servername, $username, $password);\r\n\r\n            if ($conn) {\r\n                $req=\"select *  from ersen_projet\";\r\n                $res=$conn->query($req);\r\n                if ($res) {\r\n\r\n                    while ($ligne=$res->fetch()) {\r\n                    ?>\r\n\r\n                    <h7 style=\"color:green;font-style:italic\"><?php echo $ligne[\"nom\"];echo \",\";?></h7>\r\n\r\n                    <?php\r\n                    }      \r\n                    }else{\r\n\r\n                        echo \"requete echoué !\";\r\n                    }               \r\n                }else{\r\n                echo \"Erreur de connexion !\";\r\n            }\r\n         ?>\r\n    </body>\r\n</html>', '[xyz-ips snippet=\"listeProjets\"]', 1),
(8, 'nombreBT', '<!DOCTYPE html>\r\n<html>\r\n    <head>\r\n        <title>MT</title>\r\n        <meta charset=\"utf-8\">\r\n        <link rel=\"stylesheet\" href=\"mch.css\">\r\n    </head>\r\n    <body>\r\n        <?php\r\n            $servername = \'mysql:host=94.23.252.168;dbname=ersendb\';\r\n            $username = \'root\';\r\n            $password = \'prose@111\';\r\n            $conn = new PDO($servername, $username, $password);\r\n\r\n            if ($conn) {\r\n                $req=\"select count(*) as nbr from ersen_centrale where typecentrale like \'de977c2879fb4f4f0179fbc6e77e0000\'\";\r\n                $res=$conn->query($req);\r\n                if ($res) {\r\n                    while ($ligne=$res->fetch()) {\r\n                     echo \"<strong style=\'color:white;font-weight: bold;font-size:30px;\'>\".$ligne[\'nbr\'].\"</strong>\";\r\n                    }      \r\n                    }else{\r\n\r\n                        echo \"requete echoué !\";\r\n                    }               \r\n                }else{\r\n\r\n                echo \"Erreur de connexion !\";\r\n            }\r\n         ?>\r\n    </body>\r\n</html>', '[xyz-ips snippet=\"nombreBT\"]', 1),
(9, 'nombreSHS', '<!DOCTYPE html>\r\n<html>\r\n    <head>\r\n        <title>SHS</title>\r\n        <meta charset=\"utf-8\">\r\n        <link rel=\"stylesheet\" href=\"mch.css\">\r\n    </head>\r\n    <body>\r\n        <?php\r\n            $servername = \'mysql:host=94.23.252.168;dbname=ersendb\';\r\n            $username = \'root\';\r\n            $password = \'prose@111\';\r\n            $conn = new PDO($servername, $username, $password);\r\n\r\n            if ($conn) {\r\n                $req=\"select count(*) as nbr from ersen_centrale where typecentrale like \'SHS\'\";\r\n                $res=$conn->query($req);\r\n                if ($res) {\r\n                    while ($ligne=$res->fetch()) {\r\n                     echo \"<strong style=\'color:white;font-weight: bold;font-size:30px;\'>\".$ligne[\'nbr\'].\"</strong>\";\r\n                    }      \r\n                    }else{\r\n\r\n                        echo \"requete echoué !\";\r\n                    }               \r\n                }else{\r\n\r\n                echo \"Erreur de connexion !\";\r\n            }\r\n         ?>\r\n    </body>\r\n</html>', '[xyz-ips snippet=\"nombreSHS\"]', 1),
(10, 'nombreMCH', '<!DOCTYPE html>\r\n<html>\r\n    <head>\r\n        <title>MCH</title>\r\n        <meta charset=\"utf-8\">\r\n        <link rel=\"stylesheet\" href=\"mch.css\">\r\n    </head>\r\n    <body>\r\n        <?php\r\n            $servername = \'mysql:host=94.23.252.168;dbname=ersendb\';\r\n            $username = \'root\';\r\n            $password = \'prose@111\';\r\n            $conn = new PDO($servername, $username, $password);\r\n\r\n            if ($conn) {\r\n                $req=\"select count(*) as nbr from ersen_centrale where typecentrale like \'MCH\'\";\r\n                $res=$conn->query($req);\r\n                if ($res) {\r\n                    while ($ligne=$res->fetch()) {\r\n                     echo \"<strong style=\'color:white;font-weight: bold;font-size:30px;\'>\".$ligne[\'nbr\'].\"</strong>\";\r\n                    }      \r\n                    }else{\r\n\r\n                        echo \"requete echoué !\";\r\n                    }               \r\n                }else{\r\n\r\n                echo \"Erreur de connexion !\";\r\n            }\r\n         ?>\r\n    </body>\r\n</html>', '[xyz-ips snippet=\"nombreMCH\"]', 1);

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `wp_actionscheduler_actions`
--
ALTER TABLE `wp_actionscheduler_actions`
  ADD PRIMARY KEY (`action_id`),
  ADD KEY `hook` (`hook`),
  ADD KEY `status` (`status`),
  ADD KEY `scheduled_date_gmt` (`scheduled_date_gmt`),
  ADD KEY `args` (`args`),
  ADD KEY `group_id` (`group_id`),
  ADD KEY `last_attempt_gmt` (`last_attempt_gmt`),
  ADD KEY `claim_id` (`claim_id`),
  ADD KEY `claim_id_status_scheduled_date_gmt` (`claim_id`,`status`,`scheduled_date_gmt`);

--
-- Index pour la table `wp_actionscheduler_claims`
--
ALTER TABLE `wp_actionscheduler_claims`
  ADD PRIMARY KEY (`claim_id`),
  ADD KEY `date_created_gmt` (`date_created_gmt`);

--
-- Index pour la table `wp_actionscheduler_groups`
--
ALTER TABLE `wp_actionscheduler_groups`
  ADD PRIMARY KEY (`group_id`),
  ADD KEY `slug` (`slug`(191));

--
-- Index pour la table `wp_actionscheduler_logs`
--
ALTER TABLE `wp_actionscheduler_logs`
  ADD PRIMARY KEY (`log_id`),
  ADD KEY `action_id` (`action_id`),
  ADD KEY `log_date_gmt` (`log_date_gmt`);

--
-- Index pour la table `wp_commentmeta`
--
ALTER TABLE `wp_commentmeta`
  ADD PRIMARY KEY (`meta_id`),
  ADD KEY `comment_id` (`comment_id`),
  ADD KEY `meta_key` (`meta_key`(191));

--
-- Index pour la table `wp_comments`
--
ALTER TABLE `wp_comments`
  ADD PRIMARY KEY (`comment_ID`),
  ADD KEY `comment_post_ID` (`comment_post_ID`),
  ADD KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
  ADD KEY `comment_date_gmt` (`comment_date_gmt`),
  ADD KEY `comment_parent` (`comment_parent`),
  ADD KEY `comment_author_email` (`comment_author_email`(10));

--
-- Index pour la table `wp_links`
--
ALTER TABLE `wp_links`
  ADD PRIMARY KEY (`link_id`),
  ADD KEY `link_visible` (`link_visible`);

--
-- Index pour la table `wp_options`
--
ALTER TABLE `wp_options`
  ADD PRIMARY KEY (`option_id`),
  ADD UNIQUE KEY `option_name` (`option_name`),
  ADD KEY `autoload` (`autoload`);

--
-- Index pour la table `wp_postmeta`
--
ALTER TABLE `wp_postmeta`
  ADD PRIMARY KEY (`meta_id`),
  ADD KEY `post_id` (`post_id`),
  ADD KEY `meta_key` (`meta_key`(191));

--
-- Index pour la table `wp_posts`
--
ALTER TABLE `wp_posts`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `post_name` (`post_name`(191)),
  ADD KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
  ADD KEY `post_parent` (`post_parent`),
  ADD KEY `post_author` (`post_author`);

--
-- Index pour la table `wp_termmeta`
--
ALTER TABLE `wp_termmeta`
  ADD PRIMARY KEY (`meta_id`),
  ADD KEY `term_id` (`term_id`),
  ADD KEY `meta_key` (`meta_key`(191));

--
-- Index pour la table `wp_terms`
--
ALTER TABLE `wp_terms`
  ADD PRIMARY KEY (`term_id`),
  ADD KEY `slug` (`slug`(191)),
  ADD KEY `name` (`name`(191));

--
-- Index pour la table `wp_term_relationships`
--
ALTER TABLE `wp_term_relationships`
  ADD PRIMARY KEY (`object_id`,`term_taxonomy_id`),
  ADD KEY `term_taxonomy_id` (`term_taxonomy_id`);

--
-- Index pour la table `wp_term_taxonomy`
--
ALTER TABLE `wp_term_taxonomy`
  ADD PRIMARY KEY (`term_taxonomy_id`),
  ADD UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
  ADD KEY `taxonomy` (`taxonomy`);

--
-- Index pour la table `wp_ums_icons`
--
ALTER TABLE `wp_ums_icons`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `wp_ums_maps`
--
ALTER TABLE `wp_ums_maps`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id` (`id`);

--
-- Index pour la table `wp_ums_markers`
--
ALTER TABLE `wp_ums_markers`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `wp_ums_marker_groups`
--
ALTER TABLE `wp_ums_marker_groups`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `wp_ums_marker_groups_relation`
--
ALTER TABLE `wp_ums_marker_groups_relation`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `wp_ums_modules`
--
ALTER TABLE `wp_ums_modules`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`);

--
-- Index pour la table `wp_ums_modules_type`
--
ALTER TABLE `wp_ums_modules_type`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `wp_ums_options`
--
ALTER TABLE `wp_ums_options`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`),
  ADD KEY `id` (`id`);

--
-- Index pour la table `wp_ums_options_categories`
--
ALTER TABLE `wp_ums_options_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id` (`id`);

--
-- Index pour la table `wp_ums_usage_stat`
--
ALTER TABLE `wp_ums_usage_stat`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`);

--
-- Index pour la table `wp_usermeta`
--
ALTER TABLE `wp_usermeta`
  ADD PRIMARY KEY (`umeta_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `meta_key` (`meta_key`(191));

--
-- Index pour la table `wp_users`
--
ALTER TABLE `wp_users`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `user_login_key` (`user_login`),
  ADD KEY `user_nicename` (`user_nicename`),
  ADD KEY `user_email` (`user_email`);

--
-- Index pour la table `wp_wpforms_tasks_meta`
--
ALTER TABLE `wp_wpforms_tasks_meta`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `wp_wpmailsmtp_debug_events`
--
ALTER TABLE `wp_wpmailsmtp_debug_events`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `wp_wpmailsmtp_tasks_meta`
--
ALTER TABLE `wp_wpmailsmtp_tasks_meta`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `wp_xyz_ips_short_code`
--
ALTER TABLE `wp_xyz_ips_short_code`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT pour les tables déchargées
--

--
-- AUTO_INCREMENT pour la table `wp_actionscheduler_actions`
--
ALTER TABLE `wp_actionscheduler_actions`
  MODIFY `action_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=604;

--
-- AUTO_INCREMENT pour la table `wp_actionscheduler_claims`
--
ALTER TABLE `wp_actionscheduler_claims`
  MODIFY `claim_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT pour la table `wp_actionscheduler_groups`
--
ALTER TABLE `wp_actionscheduler_groups`
  MODIFY `group_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT pour la table `wp_actionscheduler_logs`
--
ALTER TABLE `wp_actionscheduler_logs`
  MODIFY `log_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=371;

--
-- AUTO_INCREMENT pour la table `wp_commentmeta`
--
ALTER TABLE `wp_commentmeta`
  MODIFY `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `wp_comments`
--
ALTER TABLE `wp_comments`
  MODIFY `comment_ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `wp_links`
--
ALTER TABLE `wp_links`
  MODIFY `link_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `wp_options`
--
ALTER TABLE `wp_options`
  MODIFY `option_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3725;

--
-- AUTO_INCREMENT pour la table `wp_postmeta`
--
ALTER TABLE `wp_postmeta`
  MODIFY `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7123;

--
-- AUTO_INCREMENT pour la table `wp_posts`
--
ALTER TABLE `wp_posts`
  MODIFY `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1037;

--
-- AUTO_INCREMENT pour la table `wp_termmeta`
--
ALTER TABLE `wp_termmeta`
  MODIFY `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `wp_terms`
--
ALTER TABLE `wp_terms`
  MODIFY `term_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT pour la table `wp_term_taxonomy`
--
ALTER TABLE `wp_term_taxonomy`
  MODIFY `term_taxonomy_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT pour la table `wp_ums_icons`
--
ALTER TABLE `wp_ums_icons`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT pour la table `wp_ums_maps`
--
ALTER TABLE `wp_ums_maps`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `wp_ums_markers`
--
ALTER TABLE `wp_ums_markers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `wp_ums_marker_groups`
--
ALTER TABLE `wp_ums_marker_groups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `wp_ums_marker_groups_relation`
--
ALTER TABLE `wp_ums_marker_groups_relation`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `wp_ums_modules`
--
ALTER TABLE `wp_ums_modules`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT pour la table `wp_ums_modules_type`
--
ALTER TABLE `wp_ums_modules_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT pour la table `wp_ums_options`
--
ALTER TABLE `wp_ums_options`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT pour la table `wp_ums_options_categories`
--
ALTER TABLE `wp_ums_options_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT pour la table `wp_ums_usage_stat`
--
ALTER TABLE `wp_ums_usage_stat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `wp_usermeta`
--
ALTER TABLE `wp_usermeta`
  MODIFY `umeta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT pour la table `wp_users`
--
ALTER TABLE `wp_users`
  MODIFY `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `wp_wpforms_tasks_meta`
--
ALTER TABLE `wp_wpforms_tasks_meta`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;

--
-- AUTO_INCREMENT pour la table `wp_wpmailsmtp_debug_events`
--
ALTER TABLE `wp_wpmailsmtp_debug_events`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;

--
-- AUTO_INCREMENT pour la table `wp_wpmailsmtp_tasks_meta`
--
ALTER TABLE `wp_wpmailsmtp_tasks_meta`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT pour la table `wp_xyz_ips_short_code`
--
ALTER TABLE `wp_xyz_ips_short_code`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
COMMIT;

