[encoded data, 204969 characters]\" alt=\"\" width=\"966\" height=\"543\" /></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<p>&nbsp;</p>','',3,'A5','portrait',0,'2018-06-04 16:40:23',1);
INSERT INTO `documentation` VALUES (5,2,'Monitoring des erreurs OVH','<p>Le monitoring de l\'ensemble des travaux est disponible sur&nbsp;<a href=\"http://travaux.ovh.net/\">http://travaux.ovh.net/</a></p>\r\n<p>&nbsp;</p>','',3,'A5','portrait',0,'2018-06-04 16:43:39',1),(6,2,'Authentification','','',1,'A5','portrait',0,'2018-05-13 16:48:01',1),(7,1,'Login','<p>Le mot de passe est encrypt&eacute; par une fonction <strong>password_hash</strong>.<br />Verification du mot de passe par&nbsp;<strong>password_verify</strong>.</p>\r\n<table style=\"border-collapse: collapse; width: 100%; height: 160px;\" border=\"1\">\r\n<tbody>\r\n<tr>\r\n<td style=\"width: 50%;\"><strong>Fonction</strong></td>\r\n<td style=\"width: 50%;\"><strong>R&eacute;sultat</strong></td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 50%;\">password_hash(<span style=\"color: #ff00ff;\">\"motdepasse974\"</span>,&nbsp;PASSWORD_DEFAULT)</td>\r\n<td style=\"width: 50%;\">$2y$10$UEuspwE3.LOFQay29jxEW.7TAAiuxHmljdX2eis/wn4bfMvhUyopa</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 50%;\">password_verify(<span style=\"color: #ff00ff;\">\"motdepasse974\"</span>, <span style=\"color: #ff00ff;\">\'$2y$10$UEuspwE3.LOFQay29jxEW.7TAAiuxHmljdX2eis/wn4bfMvhUyopa\'</span>)</td>\r\n<td style=\"width: 50%;\">true</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<p><strong><code>PASSWORD_DEFAULT</code></strong>&nbsp;- Utilisation de l\'algorithme bcrypt (par d&eacute;faut depuis PHP 5.5.0).&nbsp;</p>\r\n<div id=\"example-984\" class=\"example\">&nbsp;</div>','',6,'A5','portrait',0,'2018-06-10 21:45:44',1),(8,2,'Récupération de mot de passe','','',6,'A5','portrait',0,'2018-05-13 20:31:16',1),(9,1,'Email','','',8,'A5','portrait',0,'2018-05-13 20:31:48',1),(10,2,'Code authentification','','',8,'A5','portrait',0,'2018-05-06 19:11:53',1),(11,3,'Réinitialise le mot de passe','','',8,'A5','portrait',0,'2018-05-06 19:12:30',1),(12,3,'Sécurité','','',1,'A5','portrait',0,'2018-05-25 20:18:33',1),(13,1,'Certificat TLS','','',12,'A5','portrait',0,'2018-05-25 21:42:30',1),(14,2,'Cookies','<p>3 cookies sont g&eacute;n&eacute;r&eacute;s</p>\r\n<table style=\"border-collapse: collapse; width: 60%; height: 72px;\" border=\"1\">\r\n<tbody>\r\n<tr style=\"height: 18px;\">\r\n<td style=\"width: 25.4977%; height: 18px;\"><strong>Cookie</strong></td>\r\n<td style=\"width: 28.2159%; height: 18px;\"><strong>G&eacute;n&eacute;r&eacute; par</strong></td>\r\n<td style=\"width: 80.8473%; height: 18px;\"><strong>Usage</strong></td>\r\n</tr>\r\n<tr style=\"height: 18px;\">\r\n<td style=\"width: 25.4977%; height: 18px;\">PHPSESSID</td>\r\n<td style=\"width: 28.2159%; height: 18px;\">script</td>\r\n<td style=\"width: 80.8473%; height: 18px;\">Cr&eacute;ation d\'une session</td>\r\n</tr>\r\n<tr style=\"height: 18px;\">\r\n<td style=\"width: 25.4977%; height: 18px;\">xxlplanBAK</td>\r\n<td style=\"width: 28.2159%; height: 18px;\">OVH</td>\r\n<td style=\"width: 80.8473%; height: 18px;\">Statistiques</td>\r\n</tr>\r\n<tr style=\"height: 18px;\">\r\n<td style=\"width: 25.4977%; height: 18px;\">xxlplanD</td>\r\n<td style=\"width: 28.2159%; height: 18px;\">OVH</td>\r\n<td style=\"width: 80.8473%; height: 18px;\">Statistiques</td>\r\n</tr>\r\n</tbody>\r\n</table>','',12,'A5','portrait',0,'2018-05-25 21:42:05',1),(15,4,'Bibliothèque de fonctions','','',1,'A5','portrait',0,'2018-06-03 14:16:15',1),(16,1,'Fonctions sur les fichiers','<p><span style=\"color: #ff0000;\"><strong>Fichier : lib.files.inc.php</strong></span></p>\r\n<p>Cette biblioth&egrave;que contient 4 fonctions</p>\r\n<ol>\r\n<li><span style=\"color: #008000;\">function <strong>formatBytes</strong>($size, $precision = 2)</span>\r\n<p>Exemple :&nbsp;formatBytes(1140338,2) renvoi&nbsp;1.09 Mo</p>\r\n<table style=\"border-collapse: collapse; width: 62.4198%; height: 108px;\" border=\"1\">\r\n<tbody>\r\n<tr style=\"height: 18px;\">\r\n<td style=\"width: 38.2941%; height: 18px;\"><strong>Taille des fichiers</strong></td>\r\n<td style=\"width: 17.3662%; height: 18px;\"><strong>Formatage</strong></td>\r\n</tr>\r\n<tr style=\"height: 18px;\">\r\n<td style=\"width: 38.2941%; height: 18px;\">1</td>\r\n<td style=\"width: 17.3662%; height: 18px;\">1 o</td>\r\n</tr>\r\n<tr style=\"height: 18px;\">\r\n<td style=\"width: 38.2941%; height: 18px;\">1.024</td>\r\n<td style=\"width: 17.3662%; height: 18px;\">1 Ko</td>\r\n</tr>\r\n<tr style=\"height: 18px;\">\r\n<td style=\"width: 38.2941%; height: 18px;\">1.084.576</td>\r\n<td style=\"width: 17.3662%; height: 18px;\">1 Mo</td>\r\n</tr>\r\n<tr style=\"height: 18px;\">\r\n<td style=\"width: 38.2941%; height: 18px;\">1.073.741.824</td>\r\n<td style=\"width: 17.3662%; height: 18px;\">1 Go</td>\r\n</tr>\r\n<tr style=\"height: 18px;\">\r\n<td style=\"width: 38.2941%; height: 18px;\">1.099.511.627.776</td>\r\n<td style=\"width: 17.3662%; height: 18px;\">1 To</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</li>\r\n<li><span style=\"color: #008000;\">function <strong>extension</strong>($file)</span><span style=\"color: #000000;\"><br>Exemple : <strong>extension</strong>(\'image.png\') renvoi&nbsp;png<br></span></li>\r\n<li><span style=\"color: #008000;\">function <strong>file_without_extension</strong>($file)</span><br><span style=\"color: #000000;\">Exemple : <strong>file_without_extension</strong>(\'image.png\') renvoi&nbsp;image<br></span></li>\r\n<li><span style=\"color: #008000;\">function <strong>imagesize</strong>($file)</span><br><br>Exemple : <strong>imagesize</strong>(<span style=\"color: #000000;\">\'image.png\'</span>)&nbsp; renvoi un tableau $array.<br>$array[\'width\'] et&nbsp;$array[\'height\']</li>\r\n</ol>','',15,'A5','portrait',0,'2024-07-25 06:03:15',1),(17,2,'Bibliothèque montant en littéral','<p><span style=\"color: #ff0000;\"><strong>Fichier lib.nuts.inc.php</strong></span></p>\r\n<pre>$obj = new nuts(\"12345.67\", \"EUR\");<br />$text = $obj-&gt;convert(\"fr-FR\");<br />$nb = $obj-&gt;getFormated(\" \", \",\")</pre>\r\n<p>&nbsp;</p>\r\n<p>$text renvoi&nbsp;douze mille trois cent quarante-cinq euros, soixante-sept centimes<br />$nb renvoi 12 345,67 EUR</p>\r\n<p>&nbsp;</p>','',15,'A5','portrait',0,'2018-06-03 14:18:48',1),(18,5,'CRUD : Create Update Delete','','',1,'A5','landscape',0,'2018-06-07 18:35:37',1),(19,6,'Schémas','','',1,'A5','landscape',0,'2018-06-03 14:50:26',1),(20,1,'Schema libraries','','',19,'A5','portrait',0,'2024-07-25 08:28:43',1),(21,2,'Schéma TCO','','',19,'A5','landscape',0,'2019-02-26 18:07:07',1),(139,1,'Interfaces de gestion des sympathisants','<p>La date d\'entr&eacute;e des symptahisants + alerte</p>','',2,'A5','',0,'2024-08-14 04:40:06',1),(140,1,'Sympathisants','<p><strong>A venir :</strong></p>\r\n<p>Paiments : Les paiement int&egrave;grent des dates</p>\r\n<p>Quartiers / Cartes &agrave; enlever</p>','',139,'A5','landscape',0,'2024-10-15 15:09:02',1),(141,2,'Villes','','',139,'A5','portrait',0,'2024-07-25 08:18:13',1),(142,4,'Cartes','','',139,'A5','landscape',0,'2024-08-13 12:18:31',1),(144,3,'Quartiers','','',139,'A5','',0,'2024-08-13 12:35:34',1),(145,2,'SMS','','',2,'A5','landscape',0,'2024-08-14 04:53:49',1),(146,1,'Envoi  des SMS','','',145,'A5','',0,'2024-08-14 04:41:49',1),(148,2,'Historique des SMS','','',145,'A5','',0,'2024-08-14 04:42:12',1),(149,3,'OVH','','',2,'A5','portrait',0,'2024-10-15 14:21:58',1),(150,1,'Hebergement Performance','<p><strong>Sur le site OVH.net</strong></p>\r\n<p>Le choix est&nbsp;</p>\r\n<p>H&eacute;bergement web<br>PERFORMANCE<br>Pour des projets multisites et des boutiques en ligne</p>\r\n<p>2 vCores , 4 Go RAM<br>2 vCores , 4 Go RAM<br><span style=\"background-color: #f1c40f;\"><strong>10,99 &euro;&nbsp;HT/mois&nbsp;soit13,19 &euro;TTC/mois</strong></span></p>\r\n<p><br>1 nom de domaine offert*<br>500 Go d\'espace disque<br>Jusqu\'&agrave; 1000 adresses e-mail<br>CMS en 1-clic<br>Acc&egrave;s SSH illimit&eacute;<br>Ressources haute performance<br>Web Cloud databases 512 Mo RAM<br>CDN basic</p>\r\n<p>&nbsp;</p>\r\n<div class=\"odss-section__title odss-section__custom_wrapper text-left mb-5\">\r\n<div class=\"otds-text\">\r\n<h2 class=\"text-left\">Fiche technique <span style=\"background-color: #f1c40f;\">H&eacute;bergement Performance</span></h2>\r\n</div>\r\n</div>\r\n<div>\r\n<div class=\"row\">\r\n<div class=\"col-12 col-md-6 py-3 py-lg-0 col-lg-6 1 text-left\">\r\n<div id=\"site_web_b376efbd-f773-4541-b8c8-4b61723890ec\" class=\"odss-text mb-4\">\r\n<div class=\"otds-text\">\r\n<h3 class=\"odss-text__heading mb-3\">Site web</h3>\r\n</div>\r\n<div class=\"otds-text\">\r\n<div class=\"ods-table-standard\">\r\n<table>\r\n<tbody>\r\n<tr>\r\n<td><strong>Nom de domaine&nbsp;</strong></td>\r\n<td>offert la premi&egrave;re ann&eacute;e*</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<p><strong>Multisites</strong></p>\r\n</td>\r\n<td>1000</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Espace disque&nbsp;</strong></td>\r\n<td><span class=\"spec-tech\">500&nbsp;Go</span></td>\r\n</tr>\r\n<tr>\r\n<td><strong>Technologie du disque&nbsp;</strong></td>\r\n<td>NAS SSD</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Trafic</strong></td>\r\n<td>illimit&eacute;</td>\r\n</tr>\r\n<tr>\r\n<td><strong>HTTP/2</strong></td>\r\n<td>inclus</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Trafic mensuel&nbsp;</strong></td>\r\n<td>illimit&eacute;</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Bande passante</strong></td>\r\n<td><span class=\"spec-tech\">mutualis&eacute;e</span></td>\r\n</tr>\r\n<tr>\r\n<td><strong>Ressources&nbsp;</strong></td>\r\n<td>\r\n<p><strong>Haute performance</strong><br><span style=\"background-color: #f1c40f;\">Performance 1 : 2 CPU vCore, 4 GB de RAM</span><br>Performance 2 : 4 CPU vCore, 8 GB de RAM<br>Performance 3 : 6 CPU vCore, 12&nbsp;GB de RAM<br>Performance 4 : 8 CPU vCore, 16&nbsp;GB de RAM</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Option Boost&nbsp;</strong></td>\r\n<td>activable &agrave; la demande</td>\r\n</tr>\r\n<tr>\r\n<td><strong>CMS 1 clic</strong></td>\r\n<td>WordPress, Joomla!, Drupal, PrestaShop</td>\r\n</tr>\r\n<tr>\r\n<td><strong>CDN&nbsp;</strong></td>\r\n<td>3&nbsp;PoP</td>\r\n</tr>\r\n<tr>\r\n<td><strong>HTTP/2</strong></td>\r\n<td>inclus</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Acc&egrave;s SSH, multi-SSH&nbsp;</strong></td>\r\n<td>inclus</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Datacenter</strong></td>\r\n<td>\r\n<p><span class=\"oui-token-common-data\">Gravelines (France)</span></p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Puissance</strong></td>\r\n<td>\r\n<p>●●●●●</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Acc&egrave;s FTP</strong></td>\r\n<td>\r\n<p>inclus</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Multi-FTP</strong></td>\r\n<td>\r\n<p>inclus</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Explorateur web/FTP</strong></td>\r\n<td>inclus</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Acc&egrave;s aux logs</strong></td>\r\n<td>\r\n<p>inclus</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Statistiques&nbsp;</strong></td>\r\n<td>\r\n<p>inclus</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Adresse IPv6</strong></td>\r\n<td>inclus</td>\r\n</tr>\r\n<tr>\r\n<td><strong>G&eacute;olocalisation IP</strong></td>\r\n<td>\r\n<p>inclus</p>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</div>\r\n</div>\r\n<div id=\"e-mails_ba2aa373-daeb-4c9b-af37-eef538493637\" class=\"odss-text mb-4\">\r\n<div class=\"otds-text\">\r\n<h3 class=\"odss-text__heading mb-3\">E-mails</h3>\r\n</div>\r\n<div class=\"otds-text\">\r\n<div class=\"ods-table-standard\">\r\n<table>\r\n<tbody>\r\n<tr>\r\n<td><strong>Nombre de comptes e-mail</strong></td>\r\n<td>\r\n<p>1000</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<p><strong>Stockage des comptes e-mail</strong></p>\r\n</td>\r\n<td><span class=\"oui-token-common-data\">5 Go par compte</span></td>\r\n</tr>\r\n<tr>\r\n<td><strong>Taille maximale par e-mail&nbsp;</strong></td>\r\n<td>100 Mo</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Redirections e-mail</strong></td>\r\n<td>1 000</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Listes de diffusion</strong></td>\r\n<td>100</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Alias e-mail</strong></td>\r\n<td>1 000</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Antivirus et antispam</strong></td>\r\n<td>inclus</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Webmail</strong></td>\r\n<td>inclus</td>\r\n</tr>\r\n<tr>\r\n<td><strong>SMTP</strong></td>\r\n<td>inclus</td>\r\n</tr>\r\n<tr>\r\n<td><strong>POP/IMAP</strong></td>\r\n<td>inclus</td>\r\n</tr>\r\n<tr>\r\n<td><strong>E-mails automatis&eacute;s</strong></td>\r\n<td>inclus</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Envoi d\'e-mails via votre site</strong></td>\r\n<td>inclus</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</div>\r\n</div>\r\n<div id=\"d&eacute;veloppement_9e3ad6fa-0d3d-433b-8148-9f7da590247f\" class=\"odss-text mb-4\">\r\n<div class=\"otds-text\">\r\n<h3 class=\"odss-text__heading mb-3\">D&eacute;veloppement</h3>\r\n</div>\r\n<div class=\"otds-text\">\r\n<div class=\"ods-table-standard\">\r\n<table>\r\n<tbody>\r\n<tr>\r\n<td><strong>HTML, CSS, Javascript</strong></td>\r\n<td>inclus</td>\r\n</tr>\r\n<tr>\r\n<td><strong>PHP</strong></td>\r\n<td>PHP 7.x, PHP 8.x</td>\r\n</tr>\r\n<tr>\r\n<td><strong>IonCube</strong></td>\r\n<td>inclus</td>\r\n</tr>\r\n<tr></tr>\r\n<tr>\r\n<td><strong>PHP/FPM&nbsp;</strong></td>\r\n<td>inclus</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<p><strong>T&acirc;ches planifi&eacute;es (cron)<br>(Planifier l\'ex&eacute;cution de vos scripts)&nbsp;</strong></p>\r\n</td>\r\n<td>inclus</td>\r\n</tr>\r\n<tr>\r\n<td><strong>CGI&nbsp;</strong>(Perl, C, Python)&nbsp;</td>\r\n<td>inclus</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Git&nbsp;</strong></td>\r\n<td>Oui</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<p>&nbsp;</p>\r\n<p><a href=\"https://webhosting-infos.hosting.ovh.net/\" target=\"_blank\" rel=\"nofollow noopener\" data-tc-clic=\"hosting::performance-offer::link-to-detailed-configuration-development\">Voir la configuration d&eacute;taill&eacute;e</a>&nbsp;</p>\r\n</div>\r\n</div>\r\n</div>\r\n<div id=\"bases_de_donn&eacute;es_ea816e35-456c-4082-b70b-02871418fe2b\" class=\"odss-text mb-4\">\r\n<div class=\"otds-text\">\r\n<h3 class=\"odss-text__heading mb-3\">Bases de donn&eacute;es</h3>\r\n</div>\r\n<div class=\"otds-text\">\r\n<div class=\"ods-table-standard\">\r\n<table>\r\n<tbody>\r\n<tr>\r\n<td><strong>Base de donn&eacute;es (Percona server for MySQL)</strong></td>\r\n<td>\r\n<p>4 bases de 1 Go</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Version MySQL</strong></td>\r\n<td>8.0</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Web Cloud Databases&nbsp;</strong></td>\r\n<td>1x 512 Mo de RAM / 8Go</td>\r\n</tr>\r\n<tr></tr>\r\n<tr>\r\n<td><strong>Sauvegarde&nbsp;</strong><strong>/restauration &agrave; la demande</strong></td>\r\n<td>inclus</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<p><strong>Connexions simultan&eacute;es&nbsp;</strong></p>\r\n</td>\r\n<td>30</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<p><strong>PHPMyAdmin&nbsp;</strong></p>\r\n</td>\r\n<td>inclus</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<p><a href=\"https://webhosting-infos.hosting.ovh.net/\" data-tc-clic=\"hosting::performance-offer::link-to-see-detailed-configuration-databases\">Voir la configuration d&eacute;taill&eacute;e&nbsp;</a></p>\r\n</div>\r\n</div>\r\n</div>\r\n<div id=\"s&eacute;curit&eacute;_9e7b40bb-6098-4eb5-9aec-4f8e694b1c01\" class=\"odss-text mb-4\">\r\n<div class=\"otds-text\">\r\n<h3 class=\"odss-text__heading mb-3\">S&eacute;curit&eacute;</h3>\r\n</div>\r\n<div class=\"otds-text\">\r\n<div class=\"ods-table-standard\">\r\n<table>\r\n<tbody>\r\n<tr>\r\n<td><strong>Sauvegarde</strong><strong>/restauration de vos fichiers</strong>&nbsp;&nbsp;</td>\r\n<td>J-1, J-2, J-3, J-7, J-14</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<p><strong>Protection Anti-DDoS&nbsp;</strong></p>\r\n</td>\r\n<td>inclus</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Certificat SSL Let\'s Encrypt&nbsp;</strong></td>\r\n<td>inclus</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Certificat SSL Sectigo DV/EV</strong></td>\r\n<td>en Option</td>\r\n</tr>\r\n<tr>\r\n<td><strong>.htaccess</strong></td>\r\n<td>inclus</td>\r\n</tr>\r\n<tr>\r\n<td><strong>ModSecurity</strong></td>\r\n<td>inclus</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<p>&nbsp;</p>\r\n<p>Lien : <a href=\"https://www.ovhcloud.com/fr/web-hosting/performance-offer/\">https://www.ovhcloud.com/fr/web-hosting/performance-offer/</a>&nbsp;</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>','',149,'A5','portrait',0,'2024-10-15 14:29:19',1),(151,2,'SMS','<h3>R&eacute;capitulatif de la commande de 10 000 SMS</h3>\r\n<table><colgroup><col><col><col></colgroup>\r\n<tbody class=\"configuration\">\r\n<tr class=\"first\">\r\n<td class=\"first\"><label>R&eacute;f&eacute;rence</label></td>\r\n<td class=\"last bold\" colspan=\"2\">Commande de&nbsp;<span class=\"ng-binding\" data-ng-bind=\"config.quantity | number\">10&nbsp;000</span>&nbsp;SMS</td>\r\n</tr>\r\n</tbody>\r\n<tbody class=\"resume-subsription-and-fee\">\r\n<tr class=\"ng-scope\" data-ng-if=\"cfg.service.subscription\">\r\n<td class=\"first\" translate=\"none\">&nbsp;</td>\r\n<td class=\"right\">Montant</td>\r\n<td class=\"last bold red nowrap ng-binding\" translate=\"none\" data-ng-bind=\"cfg.resume.subscriptionWithoutVat | currency\">600,00&nbsp;&euro;</td>\r\n</tr>\r\n<tr class=\"ng-scope\" data-ng-if=\"cfg.service.installation\">\r\n<td class=\"first\" translate=\"none\">&nbsp;</td>\r\n<td class=\"right\">Frais d\'installation</td>\r\n<td class=\"last bold red nowrap ng-binding\" translate=\"none\" data-ng-bind=\"cfg.resume.feeWithoutVat | currency\">0,00&nbsp;&euro;</td>\r\n</tr>\r\n<tr class=\"ng-scope\" data-ng-if=\"cfg.resume.promotionWithoutVat\">\r\n<td class=\"first\" translate=\"none\">&nbsp;</td>\r\n<td class=\"right\"><span class=\"ng-scope\" translate=\"none\" data-ng-if=\"cfg.service.promotion.designation &amp;&amp; !customPromoLogo.hideDesignation\"><span class=\"italic ng-binding\" translate=\"none\" data-ng-bind=\"cfg.service.promotion.designation | capitalize\">Offre promotionnelle</span></span></td>\r\n<td class=\"last bold red nowrap ng-binding\" translate=\"none\" data-ng-bind=\"cfg.resume.promotionWithoutVat | currency\">-60,00&nbsp;&euro;</td>\r\n</tr>\r\n</tbody>\r\n<tbody class=\"resume\">\r\n<tr>\r\n<td class=\"first\" translate=\"none\">&nbsp;</td>\r\n<td class=\"right\">Prix HT</td>\r\n<td class=\"last\">\r\n<div class=\"table\"><span class=\"table-cell bold red nowrap ng-binding\" translate=\"none\" data-ng-bind=\"(cfg.resume.feeWithoutVat + cfg.resume.subscriptionWithoutVat + cfg.resume.promotionWithoutVat) | currency\">540,00&nbsp;&euro;</span></div>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td class=\"first\" translate=\"none\">&nbsp;</td>\r\n<td class=\"right\">TVA (<span class=\"ng-binding\" translate=\"none\" data-ng-bind-template=\"20%\">20%</span>)</td>\r\n<td class=\"last bold red nowrap ng-binding\" translate=\"none\" data-ng-bind=\"((cfg.resume.feeWithoutVat + cfg.resume.subscriptionWithoutVat + cfg.resume.promotionWithoutVat) * ((vatInfos.vatRate + 100) / 100)) - (cfg.resume.feeWithoutVat + cfg.resume.subscriptionWithoutVat + cfg.resume.promotionWithoutVat) | currency\">108,00&nbsp;&euro;</td>\r\n</tr>\r\n<tr class=\"last\">\r\n<td class=\"first\" translate=\"none\">&nbsp;</td>\r\n<td class=\"bold right\"><span style=\"background-color: #f1c40f;\">Montant total TTC</span></td>\r\n<td class=\"last bold red nowrap ng-binding\" translate=\"none\" data-ng-bind=\"(cfg.resume.feeWithoutVat + cfg.resume.subscriptionWithoutVat + cfg.resume.promotionWithoutVat) * ((vatInfos.vatRate + 100) / 100) | currency\"><span style=\"background-color: #f1c40f;\">648,00&nbsp;&euro;</span></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<p>&nbsp;</p>\r\n<p>Lien : <a href=\"https://www.ovhtelecom.fr/commande/sms.xml?quantity=10000\">https://www.ovhtelecom.fr/commande/sms.xml?quantity=10000</a>&nbsp;</p>','',149,'A5','portrait',0,'2024-10-15 14:24:08',1);

--
-- Table structure for table `documentation_files`
--

CREATE TABLE `documentation_files` (
  `id_documentation_file` int NOT NULL AUTO_INCREMENT,
  `id_documentation` int NOT NULL,
  `nom` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `border` tinyint(1) NOT NULL,
  `width_percent` int NOT NULL,
  PRIMARY KEY (`id_documentation_file`),
  KEY `id_documentation` (`id_documentation`),
  CONSTRAINT `documentation_files_ibfk_1` FOREIGN KEY (`id_documentation`) REFERENCES `documentation` (`id_documentation`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `documentation_files`
--

INSERT INTO `documentation_files` VALUES (1,5,'Interface des travaux sur OVH','001_travaux_OVh.png',0,100),(2,5,'Incident sur un serveur SQL','002_incident_serveur_SQL.png',0,80),(3,6,'Formulaire','003_login_form.png',1,50),(4,6,'Schéma global','004_authentification_global.svg',0,95),(5,7,'Authentification (login.php)','005_login.svg',0,50),(6,7,'Hashage de mots de passe','006_crypt-text-rendered.svg',0,80),(7,9,'Oubli du mot de passe','007_access_account_fail.png',0,50),(8,9,'Formulaire email','008_email_form.png',1,50),(9,9,'Envoi d\'un code par email (email.php)','009_email.svg',0,50),(10,10,'Email reçu','010_email_received.png',1,80),(11,10,'Code auth','011_code_authentification.png',1,50),(12,10,'Vérifie code authentification (code_authentification.php)','012_code_authentification.svg',0,50),(13,11,'Formulaire Réinitialise le mot de passe ','013_reset_password.png',1,60),(14,11,'Réinitialise le mot de passe (reset_password.php)','014_reset_password.svg',0,50),(15,13,'Certificat TLS','015_certificat_TLS.png',0,55),(16,14,'Cookies','016_cookies.png',0,60),(17,14,'Localisation du fichier des sessions (sur le serveur)','017_session.png',0,100),(18,18,'CRUD','018_CRUD.svg',0,80),(19,20,'Schéma bibliothèques (JS + CSS)','019_schema_libraries.png',0,95),(20,21,'Schema TCO','020_schema_tco.png',0,60),(21,140,'Interface personnel','021_interface_personnel.png',0,100),(22,140,'Mise à jour','022_MAJ_personnel.png',0,70),(23,141,'Villes','023_villes.png',0,100),(24,144,'Quartiers','024_quartiers.png',0,100),(25,142,'Cartes avec coordonnées des sympathisants','025_cartes.png',0,100),(26,146,'Recherche  des symphatisants','026_recherche_sympathisants.png',0,100),(27,146,'Envoi du SMS','027_envoi_SMS.png',0,100),(28,148,'Historique d\'envoi des SMS','028_historique_envoi_SMS.png',0,90);

--
-- Table structure for table `documentation_index`
--

CREATE TABLE `documentation_index` (
  `id_documentation_index` int NOT NULL AUTO_INCREMENT,
  `nom` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id_documentation_index`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `documentation_index`
--

INSERT INTO `documentation_index` VALUES (1,'Base de donnée'),(2,'RGPD'),(3,'Sécurité');

--
-- Table structure for table `documentation_index_element`
--

CREATE TABLE `documentation_index_element` (
  `id_documentation_index_element` int NOT NULL AUTO_INCREMENT,
  `id_documentation_index` int NOT NULL,
  `nom` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id_documentation_index_element`),
  KEY `id_documentation_index` (`id_documentation_index`),
  CONSTRAINT `documentation_index_element_ibfk_1` FOREIGN KEY (`id_documentation_index`) REFERENCES `documentation_index` (`id_documentation_index`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `documentation_index_element`
--

INSERT INTO `documentation_index_element` VALUES (1,1,'Schéma relationnel	'),(2,2,'Conformité'),(3,3,'Authentification'),(4,3,'Stockage des données');

--
-- Table structure for table `documentation_index_element_documentation`
--

CREATE TABLE `documentation_index_element_documentation` (
  `id_documentation_index_element` int NOT NULL,
  `id_documentation` int unsigned NOT NULL,
  PRIMARY KEY (`id_documentation`,`id_documentation_index_element`),
  KEY `id_documentation_index_element` (`id_documentation_index_element`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `documentation_index_element_documentation`
--

INSERT INTO `documentation_index_element_documentation` VALUES (1,20),(1,21),(2,4),(3,7),(4,4);

--
-- Table structure for table `documentation_index_element_documentation_file`
--

CREATE TABLE `documentation_index_element_documentation_file` (
  `id_documentation_index_element` int NOT NULL,
  `id_documentation_file` int NOT NULL,
  PRIMARY KEY (`id_documentation_index_element`,`id_documentation_file`),
  KEY `documentation_index_element_documentation_file_ibfk_2` (`id_documentation_file`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `documentation_index_element_documentation_file`
--


--
-- Table structure for table `documentation_ss_menu`
--

CREATE TABLE `documentation_ss_menu` (
  `id_documentation` int NOT NULL,
  `id_ss_menu` int NOT NULL,
  PRIMARY KEY (`id_documentation`,`id_ss_menu`),
  KEY `id_ss_menu` (`id_ss_menu`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `documentation_ss_menu`
--


--
-- Table structure for table `file`
--

CREATE TABLE `file` (
  `file_extension` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `type_mime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `bootstrap_icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`file_extension`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `file`
--

INSERT INTO `file` VALUES ('csv','text/csv','Fichier CSV','green','bi bi-file-earmark-excel'),('doc','application/vnd.msword','Document Word','blue','bi bi-file-earmark-word'),('docx','application/vnd.openxmlformats-officedocument.wordprocessingml.document','Document Word','blue','bi bi-file-earmark-word'),('jpeg','image/jpeg','Fichier JPG','blue','bi bi-file-earmark-image'),('jpg','image/jpeg','Fichier JPG','blue','bi bi-file-earmark-image'),('json','application/json','Fichier JSON','green','bi bi-filetype-json'),('mp4','video/mp4','Ficher MP4','blue','bi bi-file-earmark-play'),('odp','application/vnd.oasis.opendocument.presentation','Presentation OpenDocument','orange','bi bi-file-earmark-ppt'),('ods','application/vnd.oasis.opendocument.spreadsheet','Feuille de calcul OpenDocument','green','bi bi-file-earmark-excel'),('odt','application/vnd.oasis.opendocument.text','Texte OpenDocument','blue','bi bi-file-earmark-word'),('pdf','application/pdf','Fichier PDF','red','bi bi-file-earmark-pdf'),('php','text/plain','Fichier PHP','black','bi bi-filetype-php'),('ppt','application/vnd.ms-powerpoint','Fichier PowerPoint','orange','bi bi-file-earmark-ppt'),('pptx','application/vnd.openxmlformats-officedocument.presentationml.presentation','Fichier PowerPoint','orange','bi bi-file-earmark-ppt'),('rar','application/x-rar-compressed','Archive compressé','orange','bi bi-file-earmark-zip'),('sql','text/plain','Fichier SQL','#0078D7','bi bi-filetype-sql'),('txt','text/plain','Fichier Texte','black','bi bi-file-earmark-text'),('xls','application/vnd.ms-excel','Feuille de calcul Excel','green','bi bi-file-earmark-excel'),('xlsx','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet','Feuille de calcul Excel','green','bi bi-file-earmark-excel'),('xml','text/plain','Fichier XML','black','bi bi-filetype-xml'),('zip','application/zip','Archive compressé','orange','bi bi-file-earmark-zip');

--
-- Table structure for table `files`
--

CREATE TABLE `files` (
  `id_file` int NOT NULL AUTO_INCREMENT,
  `file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `is_folder` tinyint(1) NOT NULL,
  `extension` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `size` bigint unsigned DEFAULT NULL,
  `date` datetime NOT NULL,
  `id_file_parent` int DEFAULT NULL,
  `id_usage` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id_file`),
  KEY `id_file_parent` (`id_file_parent`),
  KEY `id_usage` (`id_usage`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `files`
--


--
-- Table structure for table `files_usage`
--

CREATE TABLE `files_usage` (
  `id_usage` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `nom` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `base_dir` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `file_identification_mode` enum('id_file','path_file') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `view_mode_icons` enum('large','list','explorer') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date_last_modified` datetime NOT NULL,
  `interval_upd` int NOT NULL,
  PRIMARY KEY (`id_usage`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `files_usage`
--

INSERT INTO `files_usage` VALUES ('backup','Fichiers pour les sauvegardes','/backup/tco/','id_file','large','2025-08-22 10:35:00',300);

--
-- Table structure for table `jours_feries`
--

CREATE TABLE `jours_feries` (
  `mois_jour` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `annee` year NOT NULL DEFAULT '0000',
  `nom` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`mois_jour`,`annee`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `jours_feries`
--

INSERT INTO `jours_feries` VALUES ('01-01',0000,'Jour de l\'an'),('03-24',2008,'Lundi de Pâques'),('04-01',2013,'Lundi de Pâques'),('04-05',2010,'Lundi de Pâques'),('04-09',2007,'Lundi de Pâques'),('04-09',2012,'Lundi de Pâques'),('04-13',2009,'Lundi de Pâques'),('04-25',2011,'Lundi de Pâques'),('05-01',0000,'Fête du Travail'),('05-01',2008,'Jeudi de l\'Ascension'),('05-08',0000,'Victoire 1945'),('05-09',2013,'Jeudi de l\'Ascension'),('05-13',2010,'Jeudi de l\'Ascension'),('05-17',2007,'Jeudi de l\'Ascension'),('05-17',2012,'Jeudi de l\'Ascension'),('05-21',2009,'Jeudi de l\'Ascension'),('06-02',2011,'Jeudi de l\'Ascension'),('07-14',0000,'Fête nationale française'),('08-15',0000,'Assomption'),('11-01',0000,'La toussaint'),('11-11',0000,'Armistice 1918'),('12-20',0000,'Abolition esclavage'),('12-25',0000,'Noël');

--
-- Table structure for table `libraries`
--

CREATE TABLE `libraries` (
  `id_library` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `type` enum('JS+CSS','PHP') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id_library`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `libraries`
--

INSERT INTO `libraries` VALUES (1,'jquery','JS+CSS'),(2,'jqueryui','JS+CSS'),(3,'twitter-bootstrap','JS+CSS'),(4,'jquery-validate','JS+CSS'),(5,'bootstrap-icons','JS+CSS'),(6,'font-awesome','JS+CSS'),(7,'fancyapps-ui','JS+CSS'),(8,'jquery.tablesorter','JS+CSS'),(9,'jeditable.js','JS+CSS'),(10,'tinymce','JS+CSS'),(11,'dayjs','JS+CSS'),(12,'daterangepicker','JS+CSS'),(13,'leaflet','JS+CSS'),(14,'jquery.inputmask','JS+CSS'),(15,'fullcalendar','JS+CSS'),(16,'Chart.js','JS+CSS'),(18,'file_cabinet','JS+CSS'),(19,'FTP_client','JS+CSS'),(20,'phpColors','PHP'),(21,'PHPWord','PHP'),(22,'PHPExcel','PHP'),(23,'PhpSpreadsheet','PHP'),(24,'PHPMailer','PHP'),(25,'TCPDF','PHP'),(26,'PDFMerger','PHP');

--
-- Table structure for table `libraries_files`
--

CREATE TABLE `libraries_files` (
  `id_library_file` int NOT NULL AUTO_INCREMENT,
  `id_library` int NOT NULL,
  `description` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `type` enum('js','css') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id_library_file`),
  KEY `id_library` (`id_library`),
  CONSTRAINT `libraries_files_ibfk_1` FOREIGN KEY (`id_library`) REFERENCES `libraries` (`id_library`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `libraries_files`
--

INSERT INTO `libraries_files` VALUES (1,1,NULL,'js'),(2,2,NULL,'js'),(3,2,'french_date_picker','js'),(4,2,NULL,'css'),(5,3,NULL,'js'),(6,3,NULL,'css'),(7,4,NULL,'js'),(8,5,NULL,'css'),(9,6,NULL,'css'),(10,7,NULL,'js'),(11,7,NULL,'css'),(12,8,NULL,'js'),(13,8,'widget','js'),(14,8,NULL,'css'),(15,9,NULL,'js'),(16,10,NULL,'js'),(17,13,NULL,'js'),(18,13,NULL,'css'),(19,14,'','js'),(20,14,'','css'),(21,15,NULL,'css'),(22,15,NULL,'js'),(23,15,'local','js'),(24,18,NULL,'js'),(25,18,NULL,'css'),(26,19,NULL,'js'),(27,19,NULL,'css'),(30,20,'',NULL),(31,22,'',NULL),(32,24,NULL,NULL),(33,24,NULL,NULL),(34,24,NULL,NULL),(35,25,'',NULL),(38,12,'','js'),(39,12,'','css'),(40,26,'',NULL),(41,11,'','js'),(42,11,'fr','js'),(43,16,'','js'),(44,23,NULL,NULL),(45,21,'',NULL);

--
-- Table structure for table `libraries_version`
--

CREATE TABLE `libraries_version` (
  `id_library_version` int NOT NULL AUTO_INCREMENT,
  `id_library_file` int NOT NULL,
  `src` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `version` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `integrity` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id_library_version`),
  KEY `id_library` (`id_library_file`),
  CONSTRAINT `libraries_version_ibfk_1` FOREIGN KEY (`id_library_file`) REFERENCES `libraries_files` (`id_library_file`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `libraries_version`
--

INSERT INTO `libraries_version` VALUES (1,1,'https://cdnjs.cloudflare.com/ajax/libs/jquery/1.12.4/jquery.min.js','1.12.4','sha256-ZosEbRLbNQzLpnKIkEdrPv7lOy9C27hHQ+Xp8a4MxAQ=',0),(2,1,'https://cdnjs.cloudflare.com/ajax/libs/jquery/2.2.4/jquery.min.js','2.2.4','sha256-BbhdlvQf/xTY9gja0Dq3HiwQF8LaCRTXxZKRutelT44=',0),(3,1,'https://cdnjs.cloudflare.com/ajax/libs/jquery/3.7.1/jquery.min.js','3.7.1','sha512-v2CJ7UaYy4JwqLDIrZUI/4hqeoQieOmAZNXBeQyjo21dadnwR+8ZaIJVT8EE2iyI61OV8e6M8PP2/4hpQINQ/g==',1),(4,2,'https://cdnjs.cloudflare.com/ajax/libs/jqueryui/1.13.2/jquery-ui.min.js','1.13.2','',1),(5,3,'/lib/jqueryui/jquery.ui.datepicker-fr.js','','',1),(6,4,'https://cdnjs.cloudflare.com/ajax/libs/jqueryui/1.13.2/themes/base/jquery-ui.min.css','1.13.2','',1),(7,5,'https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/5.3.3/js/bootstrap.min.js','5.3.3','',1),(8,6,'https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/5.3.3/css/bootstrap.min.css','5.3.3','',1),(9,7,'https://cdnjs.cloudflare.com/ajax/libs/jquery-validate/1.19.3/jquery.validate.js','1.19.3','',1),(10,8,'https://cdnjs.cloudflare.com/ajax/libs/bootstrap-icons/1.10.5/font/bootstrap-icons.min.css','1.10.5','',1),(11,9,'https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css','4.7.0','sha256-eZrrJcwDc/3uDhsdt61sL2oOBY362qM3lon1gyExkL0=',1),(12,10,'https://cdnjs.cloudflare.com/ajax/libs/fancybox/3.5.7/jquery.fancybox.min.js','3.5.7','',0),(13,10,'/lib/fancyapps-ui/4.0.31/dist/fancybox.umd.js','4.0.31','',1),(14,11,'https://cdnjs.cloudflare.com/ajax/libs/fancybox/3.5.7/jquery.fancybox.min.css','3.5.7','',0),(15,11,'/lib/fancyapps-ui/4.0.31/dist/fancybox.css','4.0.31','',1),(16,12,'https://cdnjs.cloudflare.com/ajax/libs/jquery.tablesorter/2.31.3/js/jquery.tablesorter.min.js','2.31.3','',1),(17,13,'https://cdnjs.cloudflare.com/ajax/libs/jquery.tablesorter/2.31.3/js/jquery.tablesorter.widgets.min.js','2.31.3','',1),(18,14,'https://cdnjs.cloudflare.com/ajax/libs/jquery.tablesorter/2.31.3/css/theme.bootstrap.min.css','2.31.3','',1),(19,15,'https://cdnjs.cloudflare.com/ajax/libs/jeditable.js/1.7.3/jeditable.min.js','1.7.3','sha256-t24FNuWuYHqEU9wt16yNCHebqT6PhwARPuLBEG8x/Xk=',0),(20,15,'https://cdnjs.cloudflare.com/ajax/libs/jeditable.js/2.0.19/jquery.jeditable.min.js','2.0.19','',1),(21,16,'https://cdnjs.cloudflare.com/ajax/libs/tinymce/7.0.1/tinymce.min.js','7.0.1','',1),(22,17,'https://cdnjs.cloudflare.com/ajax/libs/leaflet/1.9.4/leaflet.js','1.9.4','',1),(23,18,'https://cdnjs.cloudflare.com/ajax/libs/leaflet/1.9.4/leaflet.css','1.9.4','',1),(24,19,'/lib/inputmask/3.3.11/dist/min/jquery.inputmask.bundle.min.js','3.3.11','',1),(25,20,'/lib/inputmask/3.3.11/css/inputmask.css','3.3.11','',1),(27,22,'https://cdnjs.cloudflare.com/ajax/libs/fullcalendar/7.0.0-beta.4/index.global.min.js','7.0.0-beta.4','',1),(28,23,'/lib/fullcalendar/7.0.0-beta.4/dist/fr.global.min.js','7.0.0-beta.4','',1),(29,24,'/lib/cabinex/file_cabinet/1.0/index.js','1.0','',1),(30,25,'/lib/cabinex/file_cabinet/1.0/style.css','1.0','',1),(31,26,'/lib/cabinex/FTP_client/1.0/index.js','1.0','',1),(32,27,'/lib/cabinex/file_cabinet/1.0/style.css','1.0','',1),(33,30,'/lib/phpColors/src/color.php','','',1),(34,31,'/lib/PHPExcel/1.8.1/Classes/PHPExcel.php','1.8.1','',1),(35,32,'/lib/PHPMailer/6.6.4/src/Exception.php','6.6.4','',1),(36,33,'/lib/PHPMailer/6.6.4/src/PHPMailer.php','6.6.4','',1),(37,34,'/lib/PHPMailer/6.6.4/src/SMTP.php','6.6.4','',1),(38,35,'/lib/tcpdf/6.7.5/tcpdf.php','6.7.5	','',1),(41,38,'/lib/daterangepicker/3.0.5/daterangepicker.js','3.0.5','',1),(42,39,'/lib/daterangepicker/3.0.5/daterangepicker.css','3.0.5','',1),(43,40,'/lib/PDFMerger/fork_by_DT/PDFMerger.php','fork_by_DT','',1),(44,41,'https://cdnjs.cloudflare.com/ajax/libs/dayjs/1.11.9/dayjs.min.js','1.11.9','',1),(45,42,'https://cdnjs.cloudflare.com/ajax/libs/dayjs/1.11.9/locale/fr.js','1.11.9','',1),(46,43,'https://cdnjs.cloudflare.com/ajax/libs/Chart.js/4.4.0/chart.umd.js','4.4.0','',1),(47,44,'/lib/PhpSpreadsheet/2.1.0/vendor/autoload.php','2.1.0','',1),(48,45,'/lib/PHPWord/1.0.0/autoload.php','1.0.0','',1);

--
-- Table structure for table `log_authentification`
--

CREATE TABLE `log_authentification` (
  `datetime` datetime NOT NULL,
  `id_personnel` int NOT NULL,
  `adresse_ip` char(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  KEY `datetime` (`datetime`),
  KEY `id_personnel` (`id_personnel`),
  KEY `adresse_ip` (`adresse_ip`),
  CONSTRAINT `log_authentification_ibfk_1` FOREIGN KEY (`id_personnel`) REFERENCES `personnel` (`id_personnel`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `log_authentification`
--

INSERT INTO `log_authentification` VALUES ('2024-07-19 06:32:18',1,'192.168.2.87'),('2024-07-19 07:21:52',1,'192.168.2.87'),('2024-07-19 07:39:11',1,'192.168.2.87'),('2024-07-19 08:52:11',1,'192.168.2.87'),('2024-07-19 09:02:13',1,'192.168.2.87'),('2024-07-19 16:51:51',1,'192.168.4.2'),('2024-07-20 09:37:23',1,'192.168.4.2'),('2024-07-20 12:32:48',1,'192.168.4.2'),('2024-07-21 09:31:57',1,'192.168.4.2'),('2024-07-21 14:51:06',1,'192.168.4.2'),('2024-07-22 08:58:48',1,'192.168.2.87'),('2024-07-22 13:49:11',1,'192.168.2.87'),('2024-07-22 13:49:28',1,'192.168.2.87'),('2024-07-23 10:30:31',1,'192.168.2.87'),('2024-07-23 12:15:31',1,'192.168.2.87'),('2024-07-23 12:21:28',1,'192.168.2.87'),('2024-07-23 14:08:44',1,'192.168.4.3'),('2024-07-24 04:54:01',1,'192.168.2.87'),('2024-07-25 05:03:44',1,'192.168.2.87'),('2024-07-25 05:24:40',1,'192.168.2.87'),('2024-07-25 05:37:31',1,'192.168.2.87'),('2024-07-25 06:20:24',1,'192.168.2.87'),('2024-07-25 08:04:00',1,'192.168.2.87'),('2024-07-25 09:06:00',1,'192.168.2.87'),('2024-07-25 11:22:55',1,'192.168.4.2'),('2024-07-26 08:48:48',1,'192.168.2.87'),('2024-07-26 08:52:12',1,'192.168.2.87'),('2024-07-30 10:45:16',1,'192.168.2.84'),('2024-07-30 11:15:38',1,'192.168.2.87'),('2024-08-13 06:43:23',1,'192.168.2.87'),('2024-08-13 07:37:06',1,'192.168.2.87'),('2024-08-13 12:45:02',1,'192.168.2.87'),('2024-08-13 14:47:30',1,'192.168.4.2'),('2024-08-14 04:30:01',1,'192.168.2.87'),('2024-08-16 14:51:37',1,'192.168.4.3'),('2024-08-29 13:02:19',1,'192.168.2.87'),('2024-08-29 15:32:57',1,'154.67.15.161'),('2024-08-29 15:36:20',1,'154.67.15.161'),('2024-08-29 15:44:03',1,'154.67.15.161'),('2024-08-29 15:55:25',2,'154.67.89.228'),('2024-08-29 15:55:34',2,'154.67.15.161'),('2024-08-30 11:18:00',1,'154.67.15.161'),('2024-08-30 11:29:22',2,'154.67.89.228'),('2024-08-30 11:31:14',2,'154.67.89.228'),('2024-08-30 13:57:07',2,'83.198.138.79'),('2024-08-30 13:58:58',2,'83.198.138.79'),('2024-09-03 09:48:04',2,'154.67.89.228'),('2024-09-06 09:31:22',2,'139.26.142.209'),('2024-09-06 09:35:03',2,'139.26.142.209'),('2024-09-07 13:48:44',2,'139.26.139.56'),('2024-09-07 13:50:11',2,'139.26.139.56'),('2024-09-08 08:55:03',2,'213.222.97.70'),('2024-09-12 08:25:52',2,'139.26.143.37'),('2024-09-15 17:41:46',2,'213.222.97.70'),('2024-09-18 15:04:07',2,'154.67.89.228'),('2024-09-18 15:53:46',1,'139.26.150.67'),('2024-09-18 16:28:21',2,'139.26.136.230'),('2024-09-20 11:16:03',2,'154.67.89.228'),('2024-09-21 17:28:20',2,'139.26.140.113'),('2024-09-24 07:10:30',2,'154.67.89.228'),('2024-09-24 07:39:12',2,'154.67.89.228'),('2024-09-25 09:07:22',2,'154.67.89.228'),('2024-09-25 10:36:12',1,'154.67.15.161'),('2024-09-25 12:01:52',2,'139.26.143.2'),('2024-09-25 12:01:52',2,'139.26.143.2'),('2024-09-30 18:26:22',2,'213.222.97.70'),('2024-09-30 18:28:02',2,'213.222.97.70'),('2024-10-01 09:10:02',2,'154.67.89.228'),('2024-10-01 11:00:33',2,'154.67.89.228'),('2024-10-01 11:40:36',2,'154.67.89.228'),('2024-10-08 07:39:46',2,'154.67.89.228'),('2024-10-08 09:24:12',2,'154.67.89.228'),('2024-10-09 05:00:44',2,'154.67.89.228'),('2024-10-09 08:10:19',2,'154.67.89.228'),('2024-10-09 17:37:36',2,'139.26.140.104'),('2024-10-09 17:45:20',2,'139.26.140.104'),('2024-10-10 02:30:24',2,'154.67.89.228'),('2024-10-10 02:31:24',2,'154.67.89.228'),('2024-10-11 06:18:26',2,'139.26.147.6'),('2024-10-11 06:20:26',1,'154.67.15.161'),('2024-10-11 09:25:09',1,'154.67.15.161'),('2024-10-11 09:30:02',1,'154.67.15.161'),('2024-10-11 10:33:50',2,'139.26.146.216'),('2024-10-11 10:59:07',1,'154.67.15.161'),('2024-10-11 11:15:34',2,'154.67.89.228'),('2024-10-11 11:21:27',2,'154.67.89.228'),('2024-10-11 12:32:54',2,'154.67.89.228'),('2024-10-11 16:44:11',2,'2a01:cb22:844:6e'),('2024-10-12 14:28:14',1,'139.26.150.240'),('2024-10-12 15:01:39',1,'139.26.150.240'),('2024-10-14 08:19:38',2,'154.67.89.228'),('2024-10-14 13:19:24',2,'139.26.150.210'),('2024-10-14 13:52:56',2,'139.26.150.210'),('2024-10-15 10:19:40',2,'154.67.89.228'),('2024-10-15 11:39:25',2,'139.26.151.188'),('2024-10-15 14:04:23',1,'154.67.15.161'),('2024-10-15 15:00:43',1,'154.67.15.161'),('2024-10-15 15:41:28',2,'154.67.89.228'),('2024-10-16 09:39:30',2,'139.26.147.237'),('2024-10-16 15:13:34',2,'154.67.89.228'),('2024-10-17 12:17:31',2,'139.26.136.194'),('2024-10-18 23:12:43',2,'154.67.89.228'),('2024-10-20 22:10:01',2,'154.67.89.228'),('2024-10-22 06:30:45',2,'154.67.89.228'),('2024-10-22 19:20:45',2,'154.67.89.228'),('2024-10-23 07:04:12',2,'154.67.89.228'),('2024-10-23 07:14:13',1,'154.67.15.161'),('2024-10-23 07:21:02',1,'154.67.15.161'),('2024-10-23 08:12:44',1,'154.67.15.161'),('2024-10-23 08:25:43',1,'154.67.15.161'),('2024-10-23 10:00:53',1,'154.67.15.161'),('2024-10-23 10:09:56',1,'154.67.15.161'),('2024-10-23 10:56:04',2,'154.67.89.228'),('2024-10-23 14:01:48',1,'139.26.142.180'),('2024-10-23 14:22:54',1,'139.26.142.180'),('2024-10-23 14:31:52',1,'139.26.142.180'),('2024-10-23 15:12:04',1,'139.26.142.180'),('2024-10-23 20:19:32',1,'139.26.137.180'),('2024-10-24 06:05:22',1,'154.67.15.161'),('2024-10-24 08:26:09',2,'154.67.89.228'),('2024-10-24 08:38:46',2,'154.67.89.228'),('2024-10-24 08:41:52',2,'154.67.89.228'),('2024-10-24 12:47:24',1,'154.67.15.161'),('2024-10-25 08:39:21',1,'154.67.15.161'),('2024-10-25 10:50:04',1,'154.67.15.161'),('2024-10-25 13:33:02',1,'139.26.140.252'),('2024-10-25 14:32:10',2,'154.67.89.228'),('2024-10-25 16:27:54',2,'154.67.89.228'),('2024-10-26 13:04:46',2,'213.222.97.70'),('2024-10-28 14:56:57',2,'139.26.143.128'),('2024-10-29 06:33:54',2,'139.26.146.163'),('2024-10-31 22:29:32',2,'154.67.89.228'),('2024-11-01 16:30:29',2,'139.26.151.78'),('2024-11-04 13:13:07',2,'139.26.142.13'),('2024-11-07 13:19:51',2,'139.26.137.18'),('2024-11-12 08:53:31',2,'213.222.97.70'),('2024-11-12 14:54:12',1,'154.67.15.161'),('2024-11-15 06:46:22',2,'154.67.89.228'),('2024-11-17 15:20:05',2,'139.26.136.131'),('2024-11-21 17:13:29',2,'139.26.139.12'),('2024-12-02 09:50:12',1,'154.67.15.161'),('2024-12-04 09:04:37',1,'154.67.15.161'),('2024-12-04 09:08:12',1,'154.67.15.161'),('2024-12-04 09:09:56',1,'154.67.15.161'),('2024-12-04 09:14:36',1,'154.67.15.161'),('2024-12-05 04:38:29',1,'139.26.143.79'),('2024-12-06 06:21:43',1,'154.67.15.161'),('2024-12-06 06:34:22',1,'154.67.15.161'),('2024-12-06 07:06:59',1,'154.67.15.161'),('2024-12-06 07:11:12',1,'154.67.15.161'),('2024-12-06 07:13:37',2,'139.26.151.68'),('2024-12-06 07:14:30',2,'139.26.151.68'),('2024-12-06 07:15:12',1,'154.67.15.161'),('2024-12-06 08:23:55',2,'139.26.145.185'),('2024-12-06 08:27:58',2,'139.26.145.185'),('2024-12-06 10:13:02',2,'139.26.138.117'),('2024-12-06 11:03:36',2,'139.26.138.117'),('2024-12-07 12:02:26',1,'139.26.151.213'),('2024-12-08 03:39:12',2,'139.26.151.237'),('2024-12-08 11:36:12',2,'139.26.151.237'),('2024-12-10 18:19:10',2,'154.67.89.228'),('2024-12-10 18:20:58',2,'154.67.89.228'),('2024-12-10 18:38:51',1,'139.26.142.2'),('2024-12-11 01:40:21',2,'154.67.89.228'),('2024-12-11 05:12:53',2,'154.67.89.228'),('2024-12-11 12:27:16',2,'154.67.89.228'),('2024-12-12 07:37:04',1,'139.26.139.205'),('2024-12-12 08:10:18',2,'154.67.89.228'),('2024-12-12 08:29:25',1,'139.26.139.205'),('2024-12-12 09:03:40',2,'139.26.150.106'),('2024-12-13 06:14:35',1,'154.67.15.161'),('2024-12-16 05:57:16',2,'154.67.89.228'),('2024-12-16 17:45:42',2,'154.67.89.228'),('2024-12-16 17:55:49',2,'154.67.89.228'),('2024-12-16 18:10:17',2,'154.67.89.228'),('2024-12-17 05:38:14',2,'139.26.151.212'),('2024-12-17 07:11:05',2,'139.26.151.212'),('2024-12-17 11:53:43',2,'139.26.151.212'),('2024-12-17 14:46:45',1,'154.67.15.161'),('2024-12-17 14:48:33',1,'154.67.15.161'),('2024-12-17 15:05:03',2,'139.26.143.175'),('2024-12-17 17:38:45',2,'139.26.143.175'),('2024-12-17 18:40:10',2,'154.67.89.228'),('2024-12-18 05:31:15',2,'154.67.89.228'),('2024-12-18 05:37:10',1,'154.67.15.161'),('2024-12-18 10:59:34',2,'139.26.145.185'),('2024-12-18 14:53:25',2,'139.26.144.146'),('2024-12-19 10:28:32',2,'154.67.89.228'),('2024-12-19 11:01:43',2,'154.67.89.228'),('2024-12-19 12:21:12',2,'139.26.140.227'),('2024-12-19 12:48:16',2,'154.67.89.228'),('2024-12-19 13:01:26',1,'154.67.15.161'),('2024-12-20 05:51:33',2,'154.67.89.228'),('2024-12-20 07:56:05',2,'139.26.138.123'),('2024-12-21 09:18:25',1,'102.35.53.200'),('2024-12-21 16:43:19',2,'213.222.97.70'),('2024-12-22 04:24:10',1,'102.35.53.200'),('2024-12-22 14:38:24',2,'154.67.89.228'),('2024-12-23 09:46:03',2,'154.67.89.228'),('2024-12-23 10:15:05',2,'154.67.89.228'),('2024-12-24 11:12:39',2,'154.67.89.228'),('2024-12-24 16:20:22',2,'154.67.89.228'),('2024-12-24 18:32:35',2,'213.222.97.70'),('2024-12-24 18:35:17',2,'213.222.97.70'),('2024-12-26 08:44:42',2,'139.26.151.84'),('2024-12-26 14:44:15',2,'139.26.151.84'),('2024-12-31 08:02:02',2,'139.26.136.219'),('2024-12-31 09:46:23',2,'154.67.89.228'),('2024-12-31 10:35:10',2,'139.26.148.190'),('2024-12-31 12:08:35',2,'139.26.148.190'),('2025-01-02 05:00:10',2,'154.67.89.228'),('2025-01-02 08:15:50',2,'139.26.137.136'),('2025-01-02 08:18:10',2,'139.26.137.136'),('2025-01-02 08:28:33',2,'139.26.137.136'),('2025-01-02 10:31:23',2,'154.67.89.228'),('2025-01-02 10:59:46',2,'154.67.89.228'),('2025-01-02 11:11:43',2,'154.67.89.228'),('2025-01-02 11:27:27',2,'154.67.89.228'),('2025-01-08 09:17:16',1,'154.67.15.161'),('2025-01-10 08:31:42',2,'139.26.137.112'),('2025-01-15 19:14:09',2,'154.67.89.228'),('2025-01-15 19:26:24',2,'154.67.89.228'),('2025-01-17 10:32:44',2,'139.26.145.89'),('2025-01-17 10:35:19',2,'139.26.145.89'),('2025-01-17 12:22:16',2,'139.26.147.19'),('2025-01-20 16:31:10',2,'139.26.139.153'),('2025-01-21 06:00:05',2,'154.67.89.228'),('2025-01-22 06:36:58',2,'154.67.89.228'),('2025-01-22 07:18:34',2,'154.67.89.228'),('2025-01-22 08:33:45',2,'154.67.89.228'),('2025-01-22 10:01:11',1,'154.67.15.161'),('2025-01-24 13:53:44',2,'139.26.143.174'),('2025-01-25 14:16:41',2,'139.26.140.124'),('2025-01-31 07:31:05',2,'154.67.89.228'),('2025-02-07 10:33:40',2,'139.26.141.32'),('2025-02-09 09:14:54',2,'139.26.137.175'),('2025-02-17 08:12:59',1,'154.67.15.161'),('2025-02-17 11:44:01',1,'139.26.145.29'),('2025-02-17 11:57:01',2,'154.67.89.228'),('2025-02-18 07:29:36',2,'139.26.137.175'),('2025-02-18 15:43:59',2,'139.26.147.142'),('2025-02-20 12:27:33',2,'139.26.143.141'),('2025-02-23 15:14:56',2,'154.67.89.228'),('2025-02-23 16:00:14',2,'154.67.89.228'),('2025-02-25 05:54:58',2,'154.67.89.228'),('2025-02-26 06:33:18',2,'154.67.89.228'),('2025-02-27 11:58:06',2,'154.67.89.228'),('2025-02-27 18:20:01',2,'139.26.139.83'),('2025-03-03 09:56:35',2,'139.26.150.122'),('2025-03-03 10:05:59',2,'139.26.150.122'),('2025-03-03 10:10:54',2,'139.26.150.122'),('2025-03-03 10:11:32',2,'139.26.150.122'),('2025-03-04 09:17:00',2,'154.67.89.228'),('2025-03-05 17:57:56',2,'213.222.97.70'),('2025-03-06 07:46:02',2,'154.67.89.228'),('2025-03-06 08:07:05',2,'154.67.89.228'),('2025-03-07 04:54:57',2,'139.26.149.244'),('2025-03-07 05:37:09',1,'154.67.15.161'),('2025-03-07 06:11:00',2,'154.67.89.228'),('2025-03-07 09:50:49',2,'154.67.89.228'),('2025-03-07 09:54:24',2,'139.26.151.246'),('2025-03-07 11:43:08',1,'139.26.137.17'),('2025-03-07 11:58:14',2,'154.67.89.228'),('2025-03-07 11:59:40',1,'139.26.137.17'),('2025-03-07 12:05:10',2,'154.67.89.228'),('2025-03-07 12:27:10',1,'139.26.137.17'),('2025-03-10 12:26:48',2,'139.26.145.191'),('2025-03-11 13:29:39',2,'139.26.151.231'),('2025-03-11 14:29:37',1,'154.67.15.161'),('2025-03-11 16:22:14',1,'139.26.140.226'),('2025-03-12 06:07:02',1,'154.67.15.161'),('2025-03-12 07:34:28',1,'154.67.15.161'),('2025-03-12 09:30:37',1,'154.67.15.161'),('2025-03-12 10:00:11',1,'154.67.15.161'),('2025-03-12 10:05:17',1,'154.67.15.161'),('2025-03-12 11:51:53',2,'139.26.138.5'),('2025-03-13 10:23:51',1,'154.67.15.161'),('2025-03-13 10:31:46',1,'154.67.15.161'),('2025-03-13 10:57:08',1,'154.67.15.161'),('2025-03-13 11:51:06',2,'139.26.151.203'),('2025-03-13 12:08:36',2,'139.26.140.219'),('2025-03-13 13:13:24',1,'154.67.15.161'),('2025-03-13 14:42:31',1,'154.67.15.161'),('2025-03-13 16:57:38',2,'139.26.141.224'),('2025-03-13 17:12:44',2,'154.67.89.228'),('2025-03-13 17:43:23',1,'98.97.145.179'),('2025-03-14 06:04:11',1,'154.67.15.161'),('2025-03-14 07:09:41',1,'154.67.15.161'),('2025-03-14 07:58:07',1,'154.67.15.161'),('2025-03-14 10:29:20',2,'139.26.138.159'),('2025-03-15 19:12:13',2,'213.222.97.70'),('2025-03-17 09:03:48',1,'154.67.15.161'),('2025-03-18 08:15:05',2,'139.26.141.71'),('2025-03-18 14:13:27',1,'154.67.15.161'),('2025-03-18 15:43:49',2,'213.222.97.70'),('2025-03-19 06:40:34',1,'154.67.15.161'),('2025-03-19 07:31:30',1,'154.67.15.161'),('2025-03-19 07:55:22',1,'154.67.15.161'),('2025-03-19 08:22:32',2,'154.67.89.228'),('2025-03-19 08:22:56',1,'154.67.15.161'),('2025-03-19 09:40:56',1,'154.67.15.161'),('2025-03-19 11:54:30',2,'139.26.144.72'),('2025-03-19 12:41:45',2,'139.26.146.131'),('2025-03-19 12:59:26',2,'139.26.146.131'),('2025-03-19 13:58:57',2,'154.67.89.228'),('2025-03-19 14:02:33',2,'154.67.89.228'),('2025-03-20 21:56:30',2,'154.67.89.228'),('2025-03-22 09:24:59',2,'213.222.97.70'),('2025-03-22 18:38:21',2,'213.222.97.70'),('2025-03-23 12:21:15',2,'154.67.89.228'),('2025-03-23 12:27:45',2,'154.67.89.228'),('2025-03-24 14:36:10',2,'139.26.146.162'),('2025-03-25 11:05:50',2,'154.67.89.228'),('2025-03-25 19:44:01',2,'213.222.97.70'),('2025-03-26 10:12:28',2,'154.67.89.228'),('2025-03-26 12:17:59',2,'139.26.146.109'),('2025-03-27 07:18:46',2,'154.67.89.228'),('2025-03-27 12:59:19',2,'154.67.89.228'),('2025-03-27 13:06:36',2,'154.67.89.228'),('2025-03-27 14:26:12',2,'154.67.89.228'),('2025-03-27 18:46:02',1,'83.198.136.203'),('2025-03-27 18:53:06',1,'83.198.136.203'),('2025-03-27 19:21:46',2,'154.67.89.228'),('2025-03-28 05:58:39',1,'154.67.15.161'),('2025-03-28 06:35:36',2,'139.26.137.79'),('2025-03-28 07:09:49',1,'154.67.15.161'),('2025-03-28 09:01:54',2,'139.26.137.79'),('2025-03-28 09:03:10',1,'154.67.15.161'),('2025-03-28 09:53:35',1,'154.67.15.161'),('2025-03-28 09:56:44',2,'139.26.139.185'),('2025-03-28 11:12:31',2,'154.67.89.228'),('2025-03-28 11:57:39',1,'83.198.136.203'),('2025-03-29 09:26:40',2,'139.26.146.111'),('2025-03-30 14:17:25',2,'154.67.89.228'),('2025-03-31 12:47:57',1,'83.198.136.203'),('2025-04-01 06:07:29',1,'83.198.136.203'),('2025-04-01 07:12:30',1,'83.198.136.203'),('2025-04-01 11:21:17',1,'154.67.15.161'),('2025-04-01 11:23:47',1,'154.67.15.161'),('2025-04-01 11:41:45',1,'154.67.15.161'),('2025-04-01 16:58:21',1,'192.168.2.98'),('2025-04-01 17:33:29',1,'192.168.2.98'),('2025-04-02 09:07:49',1,'192.168.2.98'),('2025-04-02 10:46:37',1,'192.168.2.98'),('2025-04-02 11:21:09',1,'192.168.2.98'),('2025-04-02 15:10:44',1,'192.168.4.14'),('2025-04-02 17:09:09',1,'192.168.4.14'),('2025-04-02 17:11:45',1,'192.168.4.14'),('2025-04-03 13:36:03',1,'192.168.2.98'),('2025-04-03 16:42:00',1,'192.168.2.98'),('2025-04-04 13:25:25',1,'192.168.2.98'),('2025-04-04 21:14:45',1,'192.168.4.14'),('2025-04-04 21:20:14',1,'192.168.4.14'),('2025-04-09 11:03:35',1,'192.168.2.98'),('2025-07-08 15:25:20',1,'192.168.2.98'),('2025-07-08 16:33:24',1,'192.168.2.98'),('2025-07-08 17:05:02',1,'192.168.2.98'),('2025-07-08 17:10:01',1,'192.168.2.98'),('2025-07-08 17:45:11',1,'192.168.2.98'),('2025-07-08 17:57:03',1,'192.168.2.98'),('2025-07-08 18:00:42',1,'192.168.2.98'),('2025-07-08 21:57:22',1,'192.168.4.6'),('2025-07-08 22:21:15',1,'192.168.4.6'),('2025-07-08 22:48:57',1,'192.168.4.6'),('2025-07-09 08:40:22',1,'192.168.2.98'),('2025-07-11 10:19:01',1,'192.168.4.14'),('2025-07-12 21:39:39',1,'192.168.4.14'),('2025-07-12 21:44:43',1,'192.168.4.14'),('2025-07-13 08:09:52',1,'192.168.4.14'),('2025-07-13 08:25:02',1,'192.168.4.14'),('2025-07-13 16:56:21',1,'192.168.4.14'),('2025-07-13 16:58:03',1,'192.168.4.14'),('2025-07-13 17:05:47',1,'192.168.4.14'),('2025-07-13 17:28:21',1,'192.168.4.14'),('2025-07-13 17:35:31',1,'192.168.4.14'),('2025-07-13 19:15:55',1,'192.168.4.14'),('2025-08-04 15:37:38',1,'192.168.4.14'),('2025-08-04 15:54:10',1,'192.168.4.14'),('2025-08-04 19:52:30',1,'192.168.4.14'),('2025-08-11 20:42:09',1,'192.168.4.14'),('2025-08-15 07:56:49',1,'192.168.4.14'),('2025-08-16 14:12:31',1,'192.168.4.14'),('2025-08-16 14:52:03',1,'192.168.4.14'),('2025-08-16 15:37:22',1,'192.168.4.14'),('2025-08-21 07:13:06',1,'192.168.4.14'),('2025-08-21 07:21:52',1,'192.168.4.14'),('2025-08-21 07:22:06',1,'192.168.4.14'),('2025-08-21 07:23:55',1,'192.168.4.14'),('2025-08-21 07:34:49',1,'192.168.4.14'),('2025-08-21 08:00:16',1,'192.168.4.14'),('2025-08-21 06:39:17',1,'139.26.143.108'),('2025-08-21 06:52:02',2,'139.26.142.76'),('2025-08-21 06:52:42',2,'139.26.142.76'),('2025-08-21 14:52:17',1,'154.67.15.161'),('2025-08-21 15:31:10',1,'154.67.15.161'),('2025-08-21 15:51:55',1,'154.67.15.161'),('2025-08-21 16:04:33',2,'154.67.89.228'),('2025-08-21 16:32:25',2,'154.67.89.228'),('2025-08-22 04:21:45',1,'139.26.143.178'),('2025-08-22 04:37:28',1,'139.26.143.178'),('2025-08-22 05:36:08',1,'139.26.143.178'),('2025-08-22 07:59:07',2,'139.26.142.162'),('2025-08-22 08:29:55',2,'165.169.241.139'),('2025-08-22 10:17:30',1,'154.67.15.161'),('2025-08-22 10:18:17',1,'154.67.15.161'),('2025-08-22 10:19:17',1,'154.67.15.161'),('2025-08-22 10:19:31',2,'154.67.89.228'),('2025-08-22 10:26:42',1,'154.67.15.161'),('2025-08-22 11:00:06',1,'154.67.15.161'),('2025-08-22 20:21:06',2,'154.67.89.228'),('2025-08-23 05:47:51',1,'139.26.144.75');

--
