mysqldump: [Warning] Using a password on the command line interface can be insecure. -- MySQL dump 10.13 Distrib 9.1.0, for Win64 (x86_64) -- -- Host: 127.0.0.1 Database: printmanager -- ------------------------------------------------------ -- Server version 9.1.0 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `printmanager` -- /*!40000 DROP DATABASE IF EXISTS `printmanager`*/; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `printmanager` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */; USE `printmanager`; -- -- Table structure for table `bons` -- DROP TABLE IF EXISTS `bons`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `bons` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `numero_livraison` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'livraison', `statut` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'actif', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `commande_id` bigint unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `bons_livraison_numero_livraison_unique` (`numero_livraison`), KEY `bons_commande_id_foreign` (`commande_id`) ) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `bons` -- LOCK TABLES `bons` WRITE; /*!40000 ALTER TABLE `bons` DISABLE KEYS */; INSERT INTO `bons` VALUES (1,'1333727030','livraison','actif','2026-03-10 23:00:00','2026-06-25 12:01:00',4),(2,'1333990232','livraison','actif','2026-04-28 22:00:00','2026-06-25 12:03:52',15),(3,'50126350','commande','stock','2026-03-08 23:00:00','2026-06-26 11:44:51',NULL),(4,'50147812','commande','actif','2026-03-10 23:00:00','2026-06-23 13:20:31',NULL),(5,'50270251','commande','actif','2026-03-30 22:00:00','2026-06-23 14:03:33',NULL),(6,'50336136','commande','stock','2026-04-13 22:00:00','2026-06-26 07:48:57',NULL),(7,'50379308','commande','stock','2026-04-20 22:00:00','2026-07-02 09:29:08',NULL),(8,'50340546','commande','stock','2026-04-13 22:00:00','2026-06-26 07:49:26',NULL),(9,'50240515','commande','stock','2026-03-25 23:00:00','2026-07-02 09:58:10',NULL),(10,'50387995','commande','actif','2026-04-21 22:00:00','2026-06-24 06:40:41',NULL),(11,'50287457','commande','stock','2026-04-01 22:00:00','2026-06-26 07:41:21',NULL),(12,'50399055','commande','actif','2026-04-22 22:00:00','2026-06-24 06:45:58',NULL),(13,'50412996','commande','actif','2026-04-26 22:00:00','2026-06-24 06:46:34',NULL),(14,'50415363','commande','actif','2026-04-26 22:00:00','2026-06-24 06:47:04',NULL),(15,'50432909','commande','actif','2026-04-28 22:00:00','2026-06-24 06:48:10',NULL),(16,'50435662','commande','actif','2026-04-28 22:00:00','2026-06-24 06:48:43',NULL),(17,'50439540','commande','stock','2026-04-29 22:00:00','2026-06-26 11:48:30',NULL),(18,'50469698','commande','actif','2026-05-05 22:00:00','2026-06-24 06:49:57',NULL),(19,'50488931','commande','actif','2026-05-10 22:00:00','2026-06-24 07:57:17',NULL),(20,'50492089','commande','actif','2026-05-10 22:00:00','2026-06-24 07:58:46',NULL),(21,'50493323','commande','actif','2026-05-10 22:00:00','2026-06-24 07:59:10',NULL),(22,'50495418','commande','actif','2026-05-11 22:00:00','2026-06-24 07:59:54',NULL),(23,'50501881','commande','stock','2026-05-11 22:00:00','2026-06-30 14:18:20',NULL),(24,'50539802','commande','actif','2026-05-18 22:00:00','2026-06-24 08:01:30',NULL),(25,'50573298','commande','actif','2026-05-25 22:00:00','2026-06-24 08:02:00',NULL),(26,'50636126','commande','actif','2026-06-04 22:00:00','2026-06-24 08:02:23',NULL),(27,'50720029','commande','actif','2026-06-18 22:00:00','2026-06-24 08:03:00',NULL),(28,'50743135','commande','actif','2026-06-22 22:00:00','2026-06-24 08:04:22',NULL),(29,'1334022924','livraison','actif','2026-05-05 22:00:00','2026-06-25 12:04:41',18),(30,'1333853997','livraison','actif','2026-04-01 22:00:00','2026-06-25 12:01:26',5),(31,'1334255792','livraison','actif','2026-06-18 22:00:00','2026-06-25 12:11:25',27),(32,'1333959465','livraison','actif','2026-04-22 22:00:00','2026-06-25 12:02:31',12),(33,'1333991797','livraison','actif','2026-04-28 22:00:00','2026-06-25 10:26:26',16),(34,'1333950617','livraison','actif','2026-04-21 22:00:00','2026-06-25 10:28:58',10),(35,'1333973124','livraison','actif','2026-04-26 22:00:00','2026-06-25 12:02:53',13),(36,'1334097796','livraison','actif','2026-05-18 22:00:00','2026-06-25 10:29:14',24),(37,'1334085743','livraison','actif','2026-05-18 22:00:00','2026-06-25 10:30:22',24),(38,'1334044590','livraison','actif','2026-05-10 22:00:00','2026-06-25 10:42:03',20),(39,'1333974354','livraison','actif','2026-04-26 22:00:00','2026-06-25 12:03:21',14),(40,'1334042850','livraison','actif','2026-05-10 22:00:00','2026-06-25 12:05:05',19),(41,'1334052992','livraison','sortie','2026-05-11 22:00:00','2026-06-29 08:41:08',23),(42,'1334045253','livraison','actif','2026-05-10 22:00:00','2026-06-25 11:07:14',21),(43,'1334049597','livraison','actif','2026-05-11 22:00:00','2026-06-25 12:06:14',22),(44,'1334118597','livraison','actif','2026-05-25 22:00:00','2026-06-25 12:09:18',25),(45,'1334201045','livraison','sortie','2026-06-09 22:00:00','2026-06-26 07:15:54',26),(46,'1333000001','livraison','actif','2026-04-05 22:00:00','2026-06-26 07:41:21',11),(47,'1333000002','livraison','actif','2026-04-15 22:00:00','2026-06-26 07:45:14',6),(48,'1333000003','livraison','actif','2026-04-15 22:00:00','2026-06-26 07:46:36',8),(49,'1334274742','livraison','actif','2026-06-22 22:00:00','2026-06-26 10:02:21',28),(50,'1333942690','livraison','actif','2026-04-23 22:00:00','2026-07-02 09:29:08',7),(51,'1333000005','livraison','actif','2026-05-03 22:00:00','2026-06-26 11:48:30',17),(52,'49982852','commande','stock','2026-02-12 23:00:00','2026-06-29 10:03:18',NULL),(53,'49991904','commande','stock','2026-02-15 23:00:00','2026-06-26 11:41:18',NULL),(54,'50012989','commande','stock','2026-02-17 23:00:00','2026-06-26 11:43:06',NULL),(55,'1332000001','livraison','actif','2026-02-16 23:00:00','2026-06-26 11:40:17',52),(56,'1332000002','livraison','actif','2026-02-18 23:00:00','2026-06-26 11:41:18',53),(57,'1332000003','livraison','actif','2026-02-22 23:00:00','2026-06-26 11:43:06',54),(58,'1332000004','livraison','actif','2026-03-12 23:00:00','2026-06-26 11:44:51',3),(59,'1333862243','livraison','actif','2026-03-30 22:00:00','2026-07-02 09:58:10',9),(60,'50791722','commande','stock','2026-06-30 22:00:00','2026-07-03 09:29:26',NULL),(61,'50785397','commande','actif','2026-06-29 22:00:00','2026-07-01 13:04:47',NULL),(62,'CAL0826DEV000053','livraison','actif','2026-04-29 22:00:00','2026-07-01 14:58:49',NULL),(63,'1334321192','livraison','actif','2026-07-02 22:00:00','2026-07-03 09:29:26',60),(64,'1334314743','livraison','actif','2026-07-02 22:00:00','2026-07-03 09:28:52',61),(65,'50827239','commande','stock','2026-07-06 22:00:00','2026-07-10 09:12:53',NULL),(66,'1334321193','livraison','actif','2026-07-09 22:00:00','2026-07-10 09:12:53',65); /*!40000 ALTER TABLE `bons` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache` -- DROP TABLE IF EXISTS `cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cache` ( `key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `value` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `expiration` bigint NOT NULL, PRIMARY KEY (`key`), KEY `cache_expiration_index` (`expiration`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cache` -- LOCK TABLES `cache` WRITE; /*!40000 ALTER TABLE `cache` DISABLE KEYS */; INSERT INTO `cache` VALUES ('printmanager-cache-kpas_unread_count','a:2:{s:5:\"count\";i:1;s:5:\"error\";N;}',1783494751),('printmanager-cache-kpax_unread_count','a:2:{s:5:\"count\";i:0;s:5:\"error\";N;}',1784274747); /*!40000 ALTER TABLE `cache` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache_locks` -- DROP TABLE IF EXISTS `cache_locks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cache_locks` ( `key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `owner` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `expiration` bigint NOT NULL, PRIMARY KEY (`key`), KEY `cache_locks_expiration_index` (`expiration`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cache_locks` -- LOCK TABLES `cache_locks` WRITE; /*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */; /*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `compteurs_historique` -- DROP TABLE IF EXISTS `compteurs_historique`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `compteurs_historique` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `materiel_id` bigint unsigned NOT NULL, `date_mois` date NOT NULL, `pages_nb` int DEFAULT NULL, `pages_couleur` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `compteurs_historique_materiel_id_date_mois_unique` (`materiel_id`,`date_mois`) ) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `compteurs_historique` -- LOCK TABLES `compteurs_historique` WRITE; /*!40000 ALTER TABLE `compteurs_historique` DISABLE KEYS */; INSERT INTO `compteurs_historique` VALUES (1,16,'2026-07-03',5845,5946,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(2,21,'2026-07-03',4906,7755,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(3,42,'2026-07-03',2729,NULL,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(4,1,'2026-07-03',14769,23207,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(5,2,'2026-07-03',26334,22738,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(6,3,'2026-07-03',10630,45045,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(7,4,'2026-07-03',329,1238,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(8,5,'2026-07-03',5270,18603,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(9,6,'2026-07-03',10790,26221,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(10,7,'2026-07-03',15593,15943,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(11,8,'2026-07-03',2848,12546,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(12,9,'2026-07-03',13431,12336,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(13,10,'2026-07-03',14172,4070,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(14,11,'2026-07-03',3512,3575,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(15,12,'2026-07-03',2325,9648,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(16,13,'2026-07-03',3538,13037,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(17,14,'2026-07-03',5329,26209,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(18,18,'2026-07-03',6939,16466,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(19,19,'2026-07-03',45176,27729,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(20,22,'2026-07-03',2635,12753,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(21,23,'2026-07-03',4369,17367,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(22,24,'2026-07-03',2375,7861,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(23,26,'2026-07-03',6300,5842,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(24,27,'2026-07-03',2193,2758,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(25,28,'2026-07-03',655,2080,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(26,29,'2026-07-03',1706,3968,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(27,31,'2026-07-03',146,442,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(28,32,'2026-07-03',539,4321,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(29,33,'2026-07-03',63,477,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(30,34,'2026-07-03',612,1686,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(31,35,'2026-07-03',548,466,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(32,40,'2026-07-03',147,1115,'2026-07-03 10:10:53','2026-07-03 10:10:53'),(33,41,'2026-07-03',1723,2947,'2026-07-03 10:10:53','2026-07-03 10:10:53'); /*!40000 ALTER TABLE `compteurs_historique` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `entree_stock_materiel` -- DROP TABLE IF EXISTS `entree_stock_materiel`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `entree_stock_materiel` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `entree_stock_id` bigint unsigned NOT NULL, `materiel_id` bigint unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `entree_stock_materiel_entree_stock_id_materiel_id_unique` (`entree_stock_id`,`materiel_id`), KEY `entree_stock_materiel_materiel_id_foreign` (`materiel_id`) ) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `entree_stock_materiel` -- LOCK TABLES `entree_stock_materiel` WRITE; /*!40000 ALTER TABLE `entree_stock_materiel` DISABLE KEYS */; INSERT INTO `entree_stock_materiel` VALUES (1,1,2),(2,1,19),(3,2,14),(4,2,17),(5,3,3),(6,4,2),(7,5,19),(8,6,27),(9,7,3),(10,8,26),(11,9,3),(12,10,26),(13,13,1),(14,14,32),(15,15,29),(16,16,14),(17,17,17),(18,18,3),(19,20,6),(20,21,27),(21,22,32),(22,23,29),(23,24,27),(24,25,32),(25,26,29),(26,27,7),(27,28,29),(28,29,32),(29,30,26),(30,31,19),(31,32,8),(32,33,6),(33,34,6),(34,35,27),(35,36,26),(36,37,1),(37,38,3),(38,39,27),(39,40,32),(40,41,7),(41,42,29),(42,43,32),(43,44,29),(44,45,27),(45,46,28),(46,47,29),(47,48,27),(48,49,29),(49,50,32),(50,51,2),(51,51,19),(52,52,27),(53,53,1),(54,54,32),(55,55,29),(56,56,14),(57,56,17),(58,57,6),(59,58,6),(60,59,27),(61,60,27),(62,61,29),(63,62,32),(64,63,26),(65,64,32),(66,65,35),(67,68,3),(68,69,3),(69,70,8),(70,70,19),(71,71,26),(72,72,26),(73,73,26),(74,74,26),(75,75,26),(76,76,26),(77,77,26),(78,78,26),(79,79,26),(80,80,26),(81,81,26),(82,116,3),(83,117,26),(84,118,26),(85,119,26),(86,120,26),(87,121,26),(88,122,26),(89,123,26),(90,124,35),(91,125,27),(92,126,26),(93,127,26),(94,128,26),(95,129,26),(96,130,32),(98,131,5),(97,131,9),(99,132,28),(100,133,28),(101,134,28),(102,135,28),(103,136,41),(104,137,41),(105,138,41),(106,139,41),(107,140,41),(108,141,41),(109,142,41),(110,143,41),(111,144,41),(112,145,41),(113,146,41),(114,147,41),(115,148,42),(116,149,42),(117,150,41),(118,151,41),(119,152,41),(120,153,41),(121,154,41),(122,155,41),(123,156,42),(124,157,42),(125,158,26),(126,159,26),(127,160,5),(128,161,9),(129,162,28),(130,163,28),(131,164,28),(132,165,28),(133,166,5),(134,166,9),(135,167,3),(136,168,3); /*!40000 ALTER TABLE `entree_stock_materiel` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `entrees_stock` -- DROP TABLE IF EXISTS `entrees_stock`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `entrees_stock` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `bon_livraison_id` bigint unsigned NOT NULL, `fourniture_id` bigint unsigned NOT NULL, `quantite` int NOT NULL, `prix_ht_unit` decimal(10,2) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `entrees_stock_fourniture_id_foreign` (`fourniture_id`), KEY `entrees_stock_bon_livraison_id_foreign` (`bon_livraison_id`) ) ENGINE=InnoDB AUTO_INCREMENT=169 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `entrees_stock` -- LOCK TABLES `entrees_stock` WRITE; /*!40000 ALTER TABLE `entrees_stock` DISABLE KEYS */; INSERT INTO `entrees_stock` VALUES (3,3,2,1,NULL,'2026-06-23 12:28:25','2026-06-23 12:28:25'),(4,4,1,1,NULL,'2026-06-23 13:20:31','2026-06-23 13:20:31'),(5,4,1,1,NULL,'2026-06-23 13:20:31','2026-06-23 13:20:31'),(6,5,3,1,NULL,'2026-06-23 14:03:33','2026-06-23 14:03:33'),(7,6,13,1,NULL,'2026-06-23 14:04:25','2026-06-23 14:04:25'),(8,7,5,1,NULL,'2026-06-23 14:04:44','2026-06-23 14:04:44'),(9,8,14,1,NULL,'2026-06-23 14:05:02','2026-06-23 14:05:02'),(10,9,6,1,NULL,'2026-06-23 14:28:59','2026-06-23 14:28:59'),(13,12,2,1,NULL,'2026-06-24 06:45:58','2026-06-24 06:45:58'),(14,13,3,1,NULL,'2026-06-24 06:46:34','2026-06-24 06:46:34'),(15,14,3,1,NULL,'2026-06-24 06:47:04','2026-06-24 06:47:04'),(16,15,1,1,NULL,'2026-06-24 06:48:10','2026-06-24 06:48:10'),(17,15,1,1,NULL,'2026-06-24 06:48:10','2026-06-24 06:48:10'),(18,16,15,1,NULL,'2026-06-24 06:48:43','2026-06-24 06:48:43'),(20,18,2,1,NULL,'2026-06-24 06:49:57','2026-06-24 06:49:57'),(21,19,4,1,NULL,'2026-06-24 07:57:17','2026-06-24 07:57:17'),(22,20,5,1,NULL,'2026-06-24 07:58:46','2026-06-24 07:58:46'),(23,21,4,1,NULL,'2026-06-24 07:59:10','2026-06-24 07:59:10'),(24,22,5,1,NULL,'2026-06-24 07:59:54','2026-06-24 07:59:54'),(25,23,4,1,NULL,'2026-06-24 08:00:33','2026-06-24 08:00:33'),(26,24,5,1,NULL,'2026-06-24 08:01:30','2026-06-24 08:01:30'),(27,24,2,1,NULL,'2026-06-24 08:01:30','2026-06-24 08:01:30'),(28,25,6,1,NULL,'2026-06-24 08:02:00','2026-06-24 08:02:00'),(30,27,3,1,NULL,'2026-06-24 08:03:00','2026-06-24 08:03:00'),(31,28,1,1,NULL,'2026-06-24 08:04:22','2026-06-24 08:04:22'),(32,28,1,1,NULL,'2026-06-24 08:04:22','2026-06-24 08:04:22'),(38,33,15,1,NULL,'2026-06-25 10:26:26','2026-06-25 10:26:26'),(39,34,6,1,NULL,'2026-06-25 10:28:58','2026-06-25 10:28:58'),(41,36,2,1,NULL,'2026-06-25 10:29:14','2026-06-25 10:29:14'),(42,37,5,1,NULL,'2026-06-25 10:30:22','2026-06-25 10:30:22'),(43,38,5,1,NULL,'2026-06-25 10:42:03','2026-06-25 10:42:03'),(47,42,4,1,NULL,'2026-06-25 11:07:14','2026-06-25 11:07:14'),(51,1,1,2,NULL,'2026-06-25 12:01:00','2026-06-25 12:01:00'),(52,30,3,1,NULL,'2026-06-25 12:01:26','2026-06-25 12:01:26'),(53,32,2,1,NULL,'2026-06-25 12:02:31','2026-06-25 12:02:31'),(54,35,3,1,NULL,'2026-06-25 12:02:53','2026-06-25 12:02:53'),(55,39,3,1,NULL,'2026-06-25 12:03:21','2026-06-25 12:03:21'),(56,2,1,2,NULL,'2026-06-25 12:03:52','2026-06-25 12:03:52'),(57,29,2,1,NULL,'2026-06-25 12:04:41','2026-06-25 12:04:41'),(58,29,13,1,NULL,'2026-06-25 12:04:41','2026-06-25 12:04:41'),(59,40,4,1,NULL,'2026-06-25 12:05:05','2026-06-25 12:05:05'),(60,43,5,1,NULL,'2026-06-25 12:06:14','2026-06-25 12:06:14'),(61,44,6,1,NULL,'2026-06-25 12:09:18','2026-06-25 12:09:18'),(62,45,6,1,NULL,'2026-06-25 12:11:03','2026-06-25 12:11:03'),(63,31,3,1,NULL,'2026-06-25 12:11:25','2026-06-25 12:11:25'),(64,26,6,1,NULL,'2026-06-25 15:43:57','2026-06-25 15:43:57'),(65,46,6,1,NULL,'2026-06-26 07:41:21','2026-06-26 07:41:21'),(68,47,13,1,NULL,'2026-06-26 07:48:57','2026-06-26 07:48:57'),(69,48,14,1,NULL,'2026-06-26 07:49:26','2026-06-26 07:49:26'),(70,49,1,2,NULL,'2026-06-26 10:02:21','2026-06-26 10:02:21'),(73,17,4,1,NULL,'2026-06-26 11:01:55','2026-06-26 11:01:55'),(78,52,4,1,NULL,'2026-06-26 11:18:30','2026-06-26 11:18:30'),(79,52,3,1,NULL,'2026-06-26 11:18:30','2026-06-26 11:18:30'),(80,52,5,1,NULL,'2026-06-26 11:18:30','2026-06-26 11:18:30'),(81,52,6,1,NULL,'2026-06-26 11:18:30','2026-06-26 11:18:30'),(82,53,12,3,NULL,'2026-06-26 11:29:21','2026-06-26 11:29:21'),(83,53,1,3,NULL,'2026-06-26 11:29:21','2026-06-26 11:29:21'),(84,53,11,3,NULL,'2026-06-26 11:29:21','2026-06-26 11:29:21'),(85,53,10,3,NULL,'2026-06-26 11:29:21','2026-06-26 11:29:21'),(86,53,13,1,NULL,'2026-06-26 11:29:21','2026-06-26 11:29:21'),(87,53,2,1,NULL,'2026-06-26 11:29:22','2026-06-26 11:29:22'),(88,53,15,1,NULL,'2026-06-26 11:29:22','2026-06-26 11:29:22'),(89,53,14,1,NULL,'2026-06-26 11:29:22','2026-06-26 11:29:22'),(90,53,9,3,NULL,'2026-06-26 11:29:22','2026-06-26 11:29:22'),(91,54,7,1,NULL,'2026-06-26 11:30:44','2026-06-26 11:30:44'),(92,54,8,1,NULL,'2026-06-26 11:30:44','2026-06-26 11:30:44'),(93,54,4,1,NULL,'2026-06-26 11:30:44','2026-06-26 11:30:44'),(94,54,3,1,NULL,'2026-06-26 11:30:44','2026-06-26 11:30:44'),(95,54,5,1,NULL,'2026-06-26 11:30:44','2026-06-26 11:30:44'),(96,54,6,1,NULL,'2026-06-26 11:30:44','2026-06-26 11:30:44'),(101,56,12,3,NULL,'2026-06-26 11:41:18','2026-06-26 11:41:18'),(102,56,1,3,NULL,'2026-06-26 11:41:18','2026-06-26 11:41:18'),(103,56,11,3,NULL,'2026-06-26 11:41:18','2026-06-26 11:41:18'),(104,56,10,3,NULL,'2026-06-26 11:41:18','2026-06-26 11:41:18'),(105,56,13,1,NULL,'2026-06-26 11:41:18','2026-06-26 11:41:18'),(106,56,2,1,NULL,'2026-06-26 11:41:18','2026-06-26 11:41:18'),(107,56,15,1,NULL,'2026-06-26 11:41:18','2026-06-26 11:41:18'),(108,56,14,1,NULL,'2026-06-26 11:41:18','2026-06-26 11:41:18'),(109,56,9,3,NULL,'2026-06-26 11:41:18','2026-06-26 11:41:18'),(110,57,7,1,NULL,'2026-06-26 11:43:06','2026-06-26 11:43:06'),(111,57,8,1,NULL,'2026-06-26 11:43:06','2026-06-26 11:43:06'),(112,57,4,1,NULL,'2026-06-26 11:43:06','2026-06-26 11:43:06'),(113,57,3,1,NULL,'2026-06-26 11:43:06','2026-06-26 11:43:06'),(114,57,5,1,NULL,'2026-06-26 11:43:06','2026-06-26 11:43:06'),(115,57,6,1,NULL,'2026-06-26 11:43:06','2026-06-26 11:43:06'),(116,58,2,1,NULL,'2026-06-26 11:44:51','2026-06-26 11:44:51'),(118,51,4,1,NULL,'2026-06-26 11:48:30','2026-06-26 11:48:30'),(124,11,6,1,NULL,'2026-06-29 09:49:01','2026-06-29 09:49:01'),(125,10,6,1,NULL,'2026-06-29 10:00:42','2026-06-29 10:00:42'),(126,55,4,1,NULL,'2026-06-29 10:03:18','2026-06-29 10:03:18'),(127,55,3,1,NULL,'2026-06-29 10:03:18','2026-06-29 10:03:18'),(128,55,5,1,NULL,'2026-06-29 10:03:18','2026-06-29 10:03:18'),(129,55,6,1,NULL,'2026-06-29 10:03:18','2026-06-29 10:03:18'),(130,41,4,1,NULL,'2026-06-30 14:18:20','2026-06-30 14:18:20'),(131,60,1,2,NULL,'2026-07-01 12:37:36','2026-07-01 12:37:36'),(132,61,4,1,NULL,'2026-07-01 13:04:47','2026-07-01 13:04:47'),(133,61,3,1,NULL,'2026-07-01 13:04:47','2026-07-01 13:04:47'),(134,61,5,1,NULL,'2026-07-01 13:04:47','2026-07-01 13:04:47'),(135,61,6,1,NULL,'2026-07-01 13:04:47','2026-07-01 13:04:47'),(150,62,21,1,75.24,'2026-07-02 06:34:07','2026-07-02 06:34:07'),(151,62,22,1,75.24,'2026-07-02 06:34:07','2026-07-02 06:34:07'),(152,62,24,1,80.85,'2026-07-02 06:34:07','2026-07-02 06:34:07'),(153,62,25,1,80.85,'2026-07-02 06:34:07','2026-07-02 06:34:07'),(154,62,23,1,80.85,'2026-07-02 06:34:07','2026-07-02 06:34:07'),(155,62,17,1,75.24,'2026-07-02 06:34:07','2026-07-02 06:34:07'),(156,62,26,1,133.72,'2026-07-02 06:34:07','2026-07-02 06:34:07'),(157,62,30,1,133.72,'2026-07-02 06:34:08','2026-07-02 06:34:08'),(158,50,5,1,NULL,'2026-07-02 09:29:08','2026-07-02 09:29:08'),(159,59,6,1,NULL,'2026-07-02 09:58:10','2026-07-02 09:58:10'),(162,64,3,1,NULL,'2026-07-03 09:28:52','2026-07-03 09:28:52'),(163,64,4,1,NULL,'2026-07-03 09:28:52','2026-07-03 09:28:52'),(164,64,5,1,NULL,'2026-07-03 09:28:52','2026-07-03 09:28:52'),(165,64,6,1,NULL,'2026-07-03 09:28:52','2026-07-03 09:28:52'),(166,63,1,1,NULL,'2026-07-03 09:29:27','2026-07-03 09:29:27'),(167,65,2,1,NULL,'2026-07-08 07:29:23','2026-07-08 07:29:23'),(168,66,2,1,NULL,'2026-07-10 09:12:53','2026-07-10 09:12:53'); /*!40000 ALTER TABLE `entrees_stock` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `failed_jobs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `connection` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `queue` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`), KEY `failed_jobs_connection_queue_failed_at_index` (`connection`,`queue`,`failed_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fourniture_materiel` -- DROP TABLE IF EXISTS `fourniture_materiel`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `fourniture_materiel` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `fourniture_id` bigint unsigned NOT NULL, `materiel_id` bigint unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `fourniture_materiel_fourniture_id_foreign` (`fourniture_id`), KEY `fourniture_materiel_materiel_id_foreign` (`materiel_id`) ) ENGINE=InnoDB AUTO_INCREMENT=245 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fourniture_materiel` -- LOCK TABLES `fourniture_materiel` WRITE; /*!40000 ALTER TABLE `fourniture_materiel` DISABLE KEYS */; INSERT INTO `fourniture_materiel` VALUES (1,1,2,NULL,NULL),(2,2,1,NULL,NULL),(3,2,3,NULL,NULL),(4,1,4,NULL,NULL),(5,1,5,NULL,NULL),(6,2,6,NULL,NULL),(7,2,7,NULL,NULL),(8,1,8,NULL,NULL),(9,1,9,NULL,NULL),(10,1,10,NULL,NULL),(11,1,11,NULL,NULL),(12,1,12,NULL,NULL),(13,1,13,NULL,NULL),(14,1,14,NULL,NULL),(15,1,15,NULL,NULL),(16,1,16,NULL,NULL),(17,1,17,NULL,NULL),(18,1,18,NULL,NULL),(19,1,19,NULL,NULL),(20,2,20,NULL,NULL),(21,1,21,NULL,NULL),(22,1,22,NULL,NULL),(23,2,23,NULL,NULL),(24,1,24,NULL,NULL),(25,3,26,NULL,NULL),(26,3,27,NULL,NULL),(27,3,28,NULL,NULL),(28,3,29,NULL,NULL),(29,3,30,NULL,NULL),(30,3,31,NULL,NULL),(31,3,32,NULL,NULL),(32,3,33,NULL,NULL),(33,3,34,NULL,NULL),(34,3,35,NULL,NULL),(35,3,36,NULL,NULL),(36,3,37,NULL,NULL),(37,3,38,NULL,NULL),(38,3,39,NULL,NULL),(39,3,40,NULL,NULL),(40,4,26,NULL,NULL),(41,4,27,NULL,NULL),(42,4,28,NULL,NULL),(43,4,29,NULL,NULL),(44,4,30,NULL,NULL),(45,4,31,NULL,NULL),(46,4,32,NULL,NULL),(47,4,33,NULL,NULL),(48,4,34,NULL,NULL),(49,4,35,NULL,NULL),(50,4,36,NULL,NULL),(51,4,37,NULL,NULL),(52,4,38,NULL,NULL),(53,4,39,NULL,NULL),(54,4,40,NULL,NULL),(55,5,26,NULL,NULL),(56,5,27,NULL,NULL),(57,5,28,NULL,NULL),(58,5,29,NULL,NULL),(59,5,30,NULL,NULL),(60,5,31,NULL,NULL),(61,5,32,NULL,NULL),(62,5,33,NULL,NULL),(63,5,34,NULL,NULL),(64,5,35,NULL,NULL),(65,5,36,NULL,NULL),(66,5,37,NULL,NULL),(67,5,38,NULL,NULL),(68,5,39,NULL,NULL),(69,5,40,NULL,NULL),(70,6,26,NULL,NULL),(71,6,27,NULL,NULL),(72,6,28,NULL,NULL),(73,6,29,NULL,NULL),(74,6,30,NULL,NULL),(75,6,31,NULL,NULL),(76,6,32,NULL,NULL),(77,6,33,NULL,NULL),(78,6,34,NULL,NULL),(79,6,35,NULL,NULL),(80,6,36,NULL,NULL),(81,6,37,NULL,NULL),(82,6,38,NULL,NULL),(83,6,39,NULL,NULL),(84,6,40,NULL,NULL),(85,7,26,NULL,NULL),(86,7,27,NULL,NULL),(87,7,28,NULL,NULL),(88,7,29,NULL,NULL),(89,7,30,NULL,NULL),(90,7,31,NULL,NULL),(91,7,32,NULL,NULL),(92,7,33,NULL,NULL),(93,7,34,NULL,NULL),(94,7,35,NULL,NULL),(95,7,36,NULL,NULL),(96,7,37,NULL,NULL),(97,7,38,NULL,NULL),(98,7,39,NULL,NULL),(99,7,40,NULL,NULL),(100,8,26,NULL,NULL),(101,8,27,NULL,NULL),(102,8,28,NULL,NULL),(103,8,29,NULL,NULL),(104,8,30,NULL,NULL),(105,8,31,NULL,NULL),(106,8,32,NULL,NULL),(107,8,33,NULL,NULL),(108,8,34,NULL,NULL),(109,8,35,NULL,NULL),(110,8,36,NULL,NULL),(111,8,37,NULL,NULL),(112,8,38,NULL,NULL),(113,8,39,NULL,NULL),(114,8,40,NULL,NULL),(115,9,1,NULL,NULL),(116,9,2,NULL,NULL),(117,9,3,NULL,NULL),(118,9,4,NULL,NULL),(119,9,5,NULL,NULL),(120,9,6,NULL,NULL),(121,9,7,NULL,NULL),(122,9,8,NULL,NULL),(123,9,9,NULL,NULL),(124,9,10,NULL,NULL),(125,9,11,NULL,NULL),(126,9,12,NULL,NULL),(127,9,13,NULL,NULL),(128,9,14,NULL,NULL),(129,9,15,NULL,NULL),(130,9,16,NULL,NULL),(131,9,17,NULL,NULL),(132,9,18,NULL,NULL),(133,9,19,NULL,NULL),(134,9,20,NULL,NULL),(135,9,21,NULL,NULL),(136,9,22,NULL,NULL),(137,9,23,NULL,NULL),(138,9,24,NULL,NULL),(139,10,2,NULL,NULL),(140,10,4,NULL,NULL),(141,10,5,NULL,NULL),(142,10,8,NULL,NULL),(143,10,9,NULL,NULL),(144,10,10,NULL,NULL),(145,10,11,NULL,NULL),(146,10,12,NULL,NULL),(147,10,13,NULL,NULL),(148,10,14,NULL,NULL),(149,10,15,NULL,NULL),(150,10,16,NULL,NULL),(151,10,17,NULL,NULL),(152,10,18,NULL,NULL),(153,10,19,NULL,NULL),(154,10,21,NULL,NULL),(155,10,22,NULL,NULL),(156,10,24,NULL,NULL),(157,11,2,NULL,NULL),(158,11,4,NULL,NULL),(159,11,5,NULL,NULL),(160,11,8,NULL,NULL),(161,11,9,NULL,NULL),(162,11,10,NULL,NULL),(163,11,11,NULL,NULL),(164,11,12,NULL,NULL),(165,11,13,NULL,NULL),(166,11,14,NULL,NULL),(167,11,15,NULL,NULL),(168,11,16,NULL,NULL),(169,11,17,NULL,NULL),(170,11,18,NULL,NULL),(171,11,19,NULL,NULL),(172,11,21,NULL,NULL),(173,11,22,NULL,NULL),(174,11,24,NULL,NULL),(175,12,2,NULL,NULL),(176,12,4,NULL,NULL),(177,12,5,NULL,NULL),(178,12,8,NULL,NULL),(179,12,9,NULL,NULL),(180,12,10,NULL,NULL),(181,12,11,NULL,NULL),(182,12,12,NULL,NULL),(183,12,13,NULL,NULL),(184,12,14,NULL,NULL),(185,12,15,NULL,NULL),(186,12,16,NULL,NULL),(187,12,17,NULL,NULL),(188,12,18,NULL,NULL),(189,12,19,NULL,NULL),(190,12,21,NULL,NULL),(191,12,22,NULL,NULL),(192,12,24,NULL,NULL),(193,13,1,NULL,NULL),(194,13,3,NULL,NULL),(195,13,6,NULL,NULL),(196,13,7,NULL,NULL),(197,13,20,NULL,NULL),(198,13,23,NULL,NULL),(199,14,1,NULL,NULL),(200,14,3,NULL,NULL),(201,14,6,NULL,NULL),(202,14,7,NULL,NULL),(203,14,20,NULL,NULL),(204,14,23,NULL,NULL),(205,15,1,NULL,NULL),(206,15,3,NULL,NULL),(207,15,6,NULL,NULL),(208,15,7,NULL,NULL),(209,15,20,NULL,NULL),(210,15,23,NULL,NULL),(211,17,41,NULL,NULL),(212,18,41,NULL,NULL),(213,19,41,NULL,NULL),(214,20,41,NULL,NULL),(215,21,41,NULL,NULL),(216,22,41,NULL,NULL),(217,23,41,NULL,NULL),(218,24,41,NULL,NULL),(219,25,41,NULL,NULL),(220,26,42,NULL,NULL),(221,27,42,NULL,NULL),(222,28,42,NULL,NULL),(223,29,42,NULL,NULL),(224,30,42,NULL,NULL),(225,31,45,NULL,NULL),(226,31,46,NULL,NULL),(227,31,47,NULL,NULL),(228,32,45,NULL,NULL),(229,32,46,NULL,NULL),(230,32,47,NULL,NULL),(231,33,45,NULL,NULL),(232,33,46,NULL,NULL),(233,33,47,NULL,NULL),(234,34,45,NULL,NULL),(235,34,46,NULL,NULL),(236,34,47,NULL,NULL),(237,35,43,NULL,NULL),(238,36,43,NULL,NULL),(239,37,43,NULL,NULL),(240,38,43,NULL,NULL),(241,39,44,NULL,NULL),(242,40,44,NULL,NULL),(243,41,44,NULL,NULL),(244,42,44,NULL,NULL); /*!40000 ALTER TABLE `fourniture_materiel` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fourniture_modele` -- DROP TABLE IF EXISTS `fourniture_modele`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `fourniture_modele` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `fourniture_id` bigint unsigned NOT NULL, `modele_id` bigint unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `fourniture_modele_fourniture_id_foreign` (`fourniture_id`), KEY `fourniture_modele_modele_id_foreign` (`modele_id`) ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fourniture_modele` -- LOCK TABLES `fourniture_modele` WRITE; /*!40000 ALTER TABLE `fourniture_modele` DISABLE KEYS */; INSERT INTO `fourniture_modele` VALUES (1,1,1,NULL,NULL),(2,2,2,NULL,NULL),(3,3,3,NULL,NULL),(4,4,3,NULL,NULL),(5,5,3,NULL,NULL),(6,6,3,NULL,NULL),(7,7,3,NULL,NULL),(8,8,3,NULL,NULL),(9,9,1,NULL,NULL),(10,9,2,NULL,NULL),(11,10,1,NULL,NULL),(12,11,1,NULL,NULL),(13,12,1,NULL,NULL),(14,13,2,NULL,NULL),(15,14,2,NULL,NULL),(16,15,2,NULL,NULL),(17,17,6,NULL,NULL),(18,18,6,NULL,NULL),(19,19,6,NULL,NULL),(20,20,6,NULL,NULL),(21,21,6,NULL,NULL),(22,22,6,NULL,NULL),(23,23,6,NULL,NULL),(24,24,6,NULL,NULL),(25,25,6,NULL,NULL),(26,26,4,NULL,NULL),(27,27,4,NULL,NULL),(28,28,4,NULL,NULL),(29,29,4,NULL,NULL),(30,30,4,NULL,NULL),(31,31,9,NULL,NULL),(32,31,10,NULL,NULL),(33,32,9,NULL,NULL),(34,32,10,NULL,NULL),(35,33,9,NULL,NULL),(36,33,10,NULL,NULL),(37,34,9,NULL,NULL),(38,34,10,NULL,NULL),(39,35,8,NULL,NULL),(40,36,8,NULL,NULL),(41,37,8,NULL,NULL),(42,38,8,NULL,NULL),(43,39,7,NULL,NULL),(44,40,7,NULL,NULL),(45,41,7,NULL,NULL),(46,42,7,NULL,NULL); /*!40000 ALTER TABLE `fourniture_modele` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fournitures` -- DROP TABLE IF EXISTS `fournitures`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `fournitures` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `nom` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `reference` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `numero` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `code_barre` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `stock` int NOT NULL DEFAULT '0', `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `statut` tinyint(1) NOT NULL DEFAULT '1', `marque_id` bigint unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `fournitures_reference_unique` (`reference`), UNIQUE KEY `fournitures_numero_unique` (`numero`), UNIQUE KEY `fournitures_code_barre_unique` (`code_barre`), KEY `fournitures_marque_id_foreign` (`marque_id`) ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fournitures` -- LOCK TABLES `fournitures` WRITE; /*!40000 ALTER TABLE `fournitures` DISABLE KEYS */; INSERT INTO `fournitures` VALUES (1,'Toner Black C300 série','TN328K','AAV8150',NULL,4,NULL,1,1,NULL,'2026-07-03 09:29:27'),(2,'Toner Black C450 série','TN626K','ACV1150',NULL,2,NULL,1,1,NULL,'2026-07-10 09:12:53'),(3,'Toner Black Lexmark CX53','9960YCLE75M2HK0','75M2HK0','734646741774',1,'Toner Black Lexmark pour CX532',1,2,'2026-06-18 11:38:48','2026-07-03 09:28:52'),(4,'Toner Cyan Lexmark CX53','9960YCLE75M2HC0','75M2HC0','734646741750',2,'Toner Cyan Lexmark pour CX532',1,2,'2026-06-18 11:41:14','2026-07-03 09:28:52'),(5,'Toner Magenta Lexmark CX53','9960YCLE75M2HM0','75M2HM0','734646741767',2,'Toner Magenta Lexmark pour CX532',1,2,'2026-06-18 11:42:45','2026-07-03 09:28:52'),(6,'Toner Yellow Lexmark CX53','9960YCLE75M2HY0','75M2HY0','73464674201',2,'Toner Yellow Lexmark pour CX532',1,2,'2026-06-18 11:44:10','2026-07-03 09:28:52'),(7,'Bouteille toner usager','75M0W00','75M0W00','734646741477',1,'Bouteille de récupération du toner usager pour CX532',1,2,'2026-06-18 11:46:54','2026-06-26 11:43:06'),(8,'Tête Impression CX532','75M0ZV0','75M0ZV0',NULL,1,'Kit de traitement d\'images noir et couleur',1,2,'2026-06-18 11:52:45','2026-06-26 11:43:06'),(9,'Box récupération toner','WX-107','AAVAWY2',NULL,3,'Box de récupération du toner usagé',1,1,'2026-06-18 11:54:14','2026-06-26 11:41:18'),(10,'Toner Yellow C300 série','TN328Y','AAV8250',NULL,3,NULL,1,1,'2026-06-18 12:00:21','2026-06-26 11:41:18'),(11,'Toner Magenta C300 série','TN328M','AAV8350',NULL,3,NULL,1,1,'2026-06-18 12:03:03','2026-06-26 11:41:18'),(12,'Toner Cyan C300 série','TN328C','AAV8450',NULL,3,NULL,1,1,'2026-06-18 12:03:46','2026-06-26 11:41:18'),(13,'Toner Cyan C450 série','TN626C','ACV1450',NULL,1,NULL,1,1,'2026-06-18 12:04:36','2026-06-29 09:17:29'),(14,'Toner Yellow C450 série','TN626Y','ACV1250',NULL,1,NULL,1,1,'2026-06-18 12:05:27','2026-06-29 09:17:29'),(15,'Toner Magenta C450 série','TN626M','ACV1350',NULL,1,NULL,1,1,'2026-06-18 12:06:03','2026-06-29 09:17:29'),(17,'72 Black','C9403A',NULL,NULL,1,'72 BK (C9403A)',1,3,'2026-06-19 12:22:28','2026-07-01 14:58:49'),(18,'72 Cyan','C9371A',NULL,NULL,0,'72 C (C9371A)',1,3,'2026-06-19 12:22:58','2026-06-19 12:22:58'),(19,'72 Grey','C9374A',NULL,NULL,0,'72 G (C9374A)',1,3,'2026-06-19 12:23:29','2026-07-01 14:11:37'),(20,'72 Magenta','C9372A',NULL,NULL,0,'72 M (C9372A)',1,3,'2026-06-19 12:23:48','2026-07-01 14:11:46'),(21,'72 Photo','C9370A',NULL,NULL,1,'72 Ph (C9370A)',1,3,'2026-06-19 12:24:08','2026-07-01 14:58:49'),(22,'72 Yellow','C9373A',NULL,NULL,1,'72 Y (C9373A)',1,3,'2026-06-19 12:24:30','2026-07-01 14:58:49'),(23,'72 Tête BK-Y','C9384A',NULL,NULL,1,'72 BK-Y (C9384A)',1,3,'2026-06-19 12:24:46','2026-07-01 14:58:49'),(24,'72 Tête G-Ph','C9380A',NULL,NULL,1,'72 G-Ph (C9380A)',1,3,'2026-06-19 12:25:07','2026-07-01 14:58:49'),(25,'72 Tête M-C','C9383A',NULL,NULL,1,'72 M-C (C9383A)',1,3,'2026-06-19 12:25:27','2026-07-01 14:58:49'),(26,'PFI-320 Black','PFI-320 BK',NULL,NULL,1,NULL,1,4,'2026-06-19 12:25:56','2026-07-02 06:26:35'),(27,'PFI-320 Cyan','PFI-320 C',NULL,NULL,0,NULL,1,4,'2026-06-19 12:26:13','2026-06-19 12:26:13'),(28,'PFI-320 Magenta','PFI-320 M',NULL,NULL,0,NULL,1,4,'2026-06-19 12:26:30','2026-06-19 12:26:30'),(29,'PFI-320 Yellow','PFI-320 Y',NULL,NULL,0,NULL,1,4,'2026-06-19 12:26:50','2026-06-19 12:26:50'),(30,'PFI-320 Matte Black','PFI-320 MBK',NULL,NULL,1,NULL,1,4,'2026-06-19 12:27:11','2026-07-02 06:26:35'),(31,'953XL Black','L0S70AE BGX',NULL,'725184104183',1,'953XL BK (L0S70AE)',1,3,'2026-07-03 08:32:04','2026-07-03 08:43:29'),(32,'953XL Cyan','F6U16AE BGX',NULL,NULL,0,'953XL C (F6U16AE)',1,3,'2026-07-03 08:32:27','2026-07-03 08:43:43'),(33,'953XL Magenta','F6U17AE BGX',NULL,'725184104121',2,'953XL M (F6U17AE)',1,3,'2026-07-03 08:32:49','2026-07-03 08:54:59'),(34,'953XL Yellow','F6U18A BGX',NULL,NULL,0,'953XL Y (F6U18A)',1,3,'2026-07-03 08:33:11','2026-07-03 08:55:09'),(35,'973X Black','L0S07AE',NULL,'889296544692',3,'973X BK (L0S07AE)',1,3,'2026-07-03 08:36:50','2026-07-03 08:36:50'),(36,'973X Cyan','F6T81AE',NULL,'889296544661',2,'973X C (F6T81AE)',1,3,'2026-07-03 08:37:34','2026-07-03 08:37:34'),(37,'973X Magenta','F6T82AE',NULL,'889296544678',2,'973X M (F6T82AE)',1,3,'2026-07-03 08:38:18','2026-07-03 08:38:18'),(38,'973X Yellow','F6T83AE',NULL,'889296544685',2,'973X Y (F6T83AE)',1,3,'2026-07-03 08:39:02','2026-07-03 08:39:02'),(39,'LC223 Black','LC223BK',NULL,NULL,2,NULL,1,5,'2026-07-03 08:58:30','2026-07-03 08:58:30'),(40,'LC223 Cyan','LC223C',NULL,NULL,2,NULL,1,5,'2026-07-03 08:59:15','2026-07-03 08:59:15'),(41,'LC223 Magenta','LC223M',NULL,NULL,2,NULL,1,5,'2026-07-03 08:59:37','2026-07-03 08:59:37'),(42,'LC223 Yellow','LC223Y',NULL,NULL,2,NULL,1,5,'2026-07-03 09:00:04','2026-07-03 09:00:04'); /*!40000 ALTER TABLE `fournitures` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `job_batches` -- DROP TABLE IF EXISTS `job_batches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `job_batches` ( `id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `total_jobs` int NOT NULL, `pending_jobs` int NOT NULL, `failed_jobs` int NOT NULL, `failed_job_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `options` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `cancelled_at` int DEFAULT NULL, `created_at` int NOT NULL, `finished_at` int DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `job_batches` -- LOCK TABLES `job_batches` WRITE; /*!40000 ALTER TABLE `job_batches` DISABLE KEYS */; /*!40000 ALTER TABLE `job_batches` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jobs` -- DROP TABLE IF EXISTS `jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `jobs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `attempts` smallint unsigned NOT NULL, `reserved_at` int unsigned DEFAULT NULL, `available_at` int unsigned NOT NULL, `created_at` int unsigned NOT NULL, PRIMARY KEY (`id`), KEY `jobs_queue_index` (`queue`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jobs` -- LOCK TABLES `jobs` WRITE; /*!40000 ALTER TABLE `jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `marques` -- DROP TABLE IF EXISTS `marques`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `marques` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `nom` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `statut` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `marques` -- LOCK TABLES `marques` WRITE; /*!40000 ALTER TABLE `marques` DISABLE KEYS */; INSERT INTO `marques` VALUES (1,'KONICA','Konica Minolta',1,NULL,'2026-06-18 12:55:09'),(2,'LEXMARK','Lexmark',1,NULL,NULL),(3,'HP','HP',1,NULL,NULL),(4,'CANON','Canon',1,'2026-06-18 09:51:06','2026-06-18 12:55:08'),(5,'BROTHER','Brother',1,'2026-07-02 10:17:01','2026-07-02 10:17:01'); /*!40000 ALTER TABLE `marques` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `materiel` -- DROP TABLE IF EXISTS `materiel`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `materiel` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `nom` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `statut` tinyint(1) NOT NULL DEFAULT '1', `adresse_ip` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `localisation` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `identifiant` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mot_de_passe` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `snmp_ok` tinyint(1) DEFAULT NULL, `snmp_releve_at` timestamp NULL DEFAULT NULL, `numeros_equipment` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `numero_serie` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `marque_id` bigint unsigned NOT NULL, `modele_id` bigint unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `materiel_numeros_equipment_unique` (`numeros_equipment`), UNIQUE KEY `materiel_numero_serie_unique` (`numero_serie`), KEY `materiel_marque_id_foreign` (`marque_id`), KEY `materiel_modele_id_foreign` (`modele_id`) ) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `materiel` -- LOCK TABLES `materiel` WRITE; /*!40000 ALTER TABLE `materiel` DISABLE KEYS */; INSERT INTO `materiel` VALUES (1,'Copieur Secrétariat',NULL,1,'192.168.1.99','Secrétariat Général',NULL,'123456712345678',1,'2026-07-17 05:00:05','1842980279','ADXG02A017000',1,2,NULL,'2026-07-17 05:00:05'),(2,'Copieur Finances',NULL,1,'192.168.1.100','Finances',NULL,'123456712345678',1,'2026-07-17 05:00:05','1842980394','ADXK021038508',1,1,NULL,'2026-07-17 05:00:05'),(3,'Copieur Urbanisme',NULL,1,'192.168.1.101','Urbanisme',NULL,'123456712345678',1,'2026-07-17 05:00:06','1842980407','ADXG02A015509',1,2,NULL,'2026-07-17 05:00:06'),(4,'Copieur Informatique',NULL,1,'192.168.1.102','DSI',NULL,'123456712345678',1,'2026-07-17 05:00:06','1842980372','ADXK021038503',1,1,NULL,'2026-07-17 05:00:06'),(5,'Copieur Cabinet Maire',NULL,1,'192.168.1.103','Cabinet du Maire',NULL,'123456712345678',1,'2026-07-17 05:00:06','1842980291','ADXK021038369',1,1,'2026-06-18 09:39:50','2026-07-17 05:00:06'),(6,'Copieur RH',NULL,1,'192.168.1.104','Ressources Humaines',NULL,'123456712345678',1,'2026-07-17 05:00:07','1842980462','ADXG02A015492',1,2,'2026-06-18 09:41:20','2026-07-17 05:00:07'),(7,'Copieur Jeunesse',NULL,1,'192.168.1.105','Pole enfance',NULL,'123456712345678',1,'2026-07-17 05:00:07','1842980377','ADXG02A015551',1,2,'2026-06-18 09:41:53','2026-07-17 05:00:07'),(8,'Copieur Patrimoine',NULL,1,'192.168.1.106','Culture & Patrimoine',NULL,'123456712345678',1,'2026-07-17 05:00:07','1842980391','ADXK021038545',1,1,'2026-06-18 09:42:36','2026-07-17 05:00:07'),(9,'Copieur Population',NULL,1,'192.168.1.107','Population',NULL,'123456712345678',1,'2026-07-17 05:00:08','1842980256','ADXK021038275',1,1,'2026-06-18 09:43:16','2026-07-17 05:00:08'),(10,'Copieur Marchés',NULL,1,'192.168.1.109','Marchés Publics',NULL,'123456712345678',1,'2026-07-17 05:00:08','1842980434','ADXK021038447',1,1,'2026-06-18 09:43:51','2026-07-17 05:00:08'),(11,'Copieur Juridique','C301i',1,'192.168.1.110','Juridique',NULL,'123456712345678',1,'2026-07-17 05:00:08','1842980342','ADXK021038563',1,1,'2026-06-18 09:44:19','2026-07-17 05:00:08'),(12,'Copieur SGR ERP',NULL,1,'192.168.1.111','SGR ERP',NULL,'123456712345678',1,'2026-07-17 05:00:08','1842980380','ADXK021038574',1,1,'2026-06-18 09:44:56','2026-07-17 05:00:09'),(13,'Copieur CTM',NULL,1,'192.168.19.116','CTM',NULL,'123456712345678',1,'2026-07-17 05:00:09','1842980389','ADXK021038599',1,1,'2026-06-18 09:45:31','2026-07-17 05:00:09'),(14,'Copieur PM',NULL,1,'192.168.200.102','PM',NULL,'123456712345678',1,'2026-07-17 05:00:10','1842980472','ADXK021038532',1,1,'2026-06-18 09:46:06','2026-07-17 05:00:10'),(15,'Copieur Sports',NULL,1,NULL,'Complexe Sportif',NULL,'123456712345678',NULL,NULL,'1842980470','ADXK021038588',1,1,'2026-06-18 09:46:37','2026-06-18 12:44:31'),(16,'Copieur Blaquieres Administration',NULL,1,'192.168.12.135','Ecole Blaquières',NULL,'123456712345678',1,'2026-07-17 05:00:10','1842980429','ADXK021038582',1,1,'2026-06-18 09:47:11','2026-07-17 05:00:10'),(17,'Copieur Blaquieres Info (élémentaire)',NULL,1,'192.168.12.136','Ecole Blaquières',NULL,'123456712345678',0,'2026-07-17 05:00:27','1842980317','ADXK021038547',1,1,'2026-06-18 09:47:48','2026-07-17 05:00:27'),(18,'Copieur Migranier Directrice Maternelle',NULL,1,'192.168.17.200','Ecole Migraniers',NULL,'123456712345678',0,'2026-07-17 05:00:43','1842980284','ADXK021038471',1,1,'2026-06-18 09:48:26','2026-07-17 05:00:43'),(19,'Copieur Migranier Info (primaire)',NULL,1,'192.168.17.199','Ecole Migraniers',NULL,'123456712345678',0,'2026-07-17 05:00:59','1842980410','ADXK021038601',1,1,'2026-06-18 09:49:05','2026-07-17 05:00:59'),(20,'Copieur Médiathèque',NULL,1,NULL,'Beausoleil',NULL,'123456712345678',NULL,NULL,'1842980382','ADXG02A015572',1,2,'2026-06-18 09:49:39','2026-06-18 12:44:54'),(21,'Copieur Animateurs Blaquières',NULL,1,'192.168.12.138','Ecole Blaquières',NULL,'123456712345678',1,'2026-07-17 05:01:00','1842980306','ADXK021038597',1,1,'2026-06-18 09:50:17','2026-07-17 05:01:00'),(22,'Copieur Capitainerie B2',NULL,1,'192.168.22.158','Capitainerie B2',NULL,'123456712345678',0,'2026-07-17 05:01:16','1842980454','ADXK021038517',1,1,'2026-06-18 09:50:51','2026-07-17 05:01:16'),(23,'Copieur Bureau des GU',NULL,1,'192.168.28.157','Bureau des GU',NULL,'123456712345678',1,'2026-07-17 05:01:17','1842980271','ADXG02A015528',1,2,'2026-06-18 09:52:45','2026-07-17 05:01:17'),(24,'Copieur Capitainerie B4',NULL,1,'192.168.22.157','Capitainerie B4',NULL,'123456712345678',1,'2026-07-17 05:01:18','1842980451','ADXK021038433',1,1,'2026-06-18 09:53:24','2026-07-17 05:01:18'),(25,'Copieur Capitainerie B6','Copieur géré en interne',0,'192.168.22.159','Capitainerie B6',NULL,NULL,NULL,NULL,NULL,'3PT00566',4,5,'2026-06-18 09:55:04','2026-07-15 13:02:56'),(26,'Lexmark RH',NULL,1,'192.168.1.113','Ressources Humaines',NULL,NULL,1,'2026-07-17 05:01:18','1826596067','7531526039Z8F',2,3,'2026-06-18 09:56:26','2026-07-17 05:01:18'),(27,'Lexmark Urbanisme',NULL,1,'192.168.1.116','Urbanisme',NULL,NULL,1,'2026-07-17 05:01:19','1826596068','7531526039ZD8',2,3,'2026-06-18 10:03:37','2026-07-17 05:01:19'),(28,'Lexmark Crèche Municipale',NULL,1,'192.168.1.117','Pole enfance',NULL,NULL,1,'2026-07-17 05:01:20','1826595807','753153303BWLF',2,3,'2026-06-18 10:04:21','2026-07-17 05:01:20'),(29,'Lexmark Finances',NULL,1,'192.168.1.118','Finances',NULL,NULL,1,'2026-07-17 05:01:20','1826595806','753153303BWF7',2,3,'2026-06-18 10:05:25','2026-07-17 05:01:20'),(30,'Lexmark Informatique','En stock bureau DSI',0,NULL,'DSI',NULL,NULL,NULL,NULL,'1826595798','753153303BWKH',2,3,'2026-06-18 10:06:21','2026-06-18 10:58:24'),(31,'Lexmark Musée du Patrimoine',NULL,1,'192.168.1.119','Musée',NULL,NULL,1,'2026-07-17 05:01:21','1826595799','7531526039ZD4',2,3,'2026-06-18 10:07:02','2026-07-17 05:01:21'),(32,'Lexmark CTM','Centre Technique Municipal (E.Brazillier)',1,'192.168.19.80','CTM',NULL,NULL,1,'2026-07-17 05:01:22','1826595808','753153303BWL3',2,3,'2026-06-18 10:07:45','2026-07-17 05:01:22'),(33,'Lexmark Ancien CTM',NULL,1,'192.168.20.205','Ancien CTM',NULL,NULL,1,'2026-07-17 05:01:25','1826595802','7531521039CGW',2,3,'2026-06-18 10:08:28','2026-07-17 05:01:25'),(34,'Lexmark Migraniers Directrice Primaire',NULL,1,'192.168.17.197','Ecole Migraniers',NULL,NULL,0,'2026-07-17 05:01:41','1826596066','7531526039Z4C',2,3,'2026-06-18 10:09:31','2026-07-17 05:01:41'),(35,'Lexmark Migraniers Primaire',NULL,1,'192.168.17.198','Ecole Migraniers',NULL,NULL,0,'2026-07-17 05:01:58','1826595797','753153303BWL0',2,3,'2026-06-18 10:12:10','2026-07-17 05:01:58'),(36,'Lexmark VAZQUEZ','Immeuble Beausoleil',1,NULL,'Beausoleil',NULL,NULL,NULL,NULL,'1826595804','753153303BWL5',2,3,'2026-06-18 10:13:20','2026-06-18 11:06:07'),(37,'Lexmark ANDRE','Immeuble Beausoleil',1,NULL,'Beausoleil',NULL,NULL,NULL,NULL,'1826595805','753153303BWKX',2,3,'2026-06-18 10:14:13','2026-06-18 11:04:35'),(38,'Lexmark Conciliateur','En stock au bureau DSI',0,NULL,'DSI',NULL,NULL,NULL,NULL,'1826595800','7531521039CGX',2,3,'2026-06-18 10:15:25','2026-06-18 10:57:54'),(39,'Lexmark LONGUET','En stock au bureau DSI',0,NULL,'DSI',NULL,NULL,NULL,NULL,'1826595801','7531521039CGZ',2,3,'2026-06-18 10:16:20','2026-06-18 11:05:04'),(40,'Lexmark Marina PG','Marina de Port Grimaud',1,'192.168.25.10','Capitainerie',NULL,NULL,1,'2026-07-17 05:01:59','1826595803','753153303BWKT',2,3,'2026-06-18 10:17:12','2026-07-17 05:01:59'),(41,'Traceur T795 CTM','Traceur HP DesignJet T795',1,'192.168.19.114','CTM',NULL,NULL,1,'2026-07-17 05:02:00','NPIA45D36B6767F',NULL,3,6,'2026-06-18 10:22:00','2026-07-17 05:02:00'),(42,'Traceur TM-350 Urbanisme',NULL,1,'192.168.1.115','Mairie',NULL,NULL,0,'2026-07-17 05:02:16',NULL,'BBAP04379',4,4,'2026-06-18 10:25:19','2026-07-17 05:02:16'),(43,'477dw Population','HP PageWide Pro 477dw MFP Population HP5BDE3E',1,'192.168.1.48','Population',NULL,NULL,0,'2026-07-17 05:02:24','HP5BDE3E','CN87KHX0RQ',3,8,'2026-07-02 10:25:16','2026-07-17 05:02:24'),(44,'DCP-J562DW Population','Brother DCP-J562DW POULATION',0,NULL,'DSI',NULL,NULL,NULL,NULL,'BRWB052162258CE','E74900M7H758672',5,7,'2026-07-02 10:28:58','2026-07-02 10:28:58'),(45,'OfficeJet Pro 8715 Sport','OfficeJet Pro 8715 au service des Sports',1,NULL,'Complexe Sportif',NULL,NULL,NULL,NULL,NULL,'CN88QBT013',3,9,'2026-07-02 14:55:29','2026-07-02 14:55:59'),(46,'OfficeJet Pro 8715 Technique','OfficeJet Pro 8715 Technique (Hielard)',1,NULL,'Service Technique',NULL,NULL,NULL,NULL,NULL,'CN88QBT017',3,9,'2026-07-02 14:57:01','2026-07-02 14:57:01'),(47,'OfficeJet Pro 8720 Conciliateur','OfficeJet Pro 8720 Conciliateur Mr Fournet pour sa permanence de conciliateur de justice',1,NULL,'Beausoleil',NULL,NULL,NULL,NULL,NULL,'CN67SDK0YQ',3,10,'2026-07-02 14:58:45','2026-07-02 14:58:45'); /*!40000 ALTER TABLE `materiel` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `migrations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` VALUES (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2024_01_01_000001_create_marques_table',1),(5,'2024_01_01_000002_create_materiel_table',1),(6,'2024_01_01_000003_create_fourniture_materiel_table',1),(7,'2024_01_01_000004_create_fournitures_table',1),(8,'2026_06_17_134614_remove_prix_from_materiel_and_fournitures_tables',1),(9,'2024_01_02_000001_create_modeles_table',2),(10,'2024_01_02_000002_modify_materiel_table',2),(11,'2024_01_02_000004_create_fourniture_modele_table',3),(12,'2026_06_17_170000_remove_reference_and_date_ajout_from_fournitures_table',3),(13,'2026_06_18_000001_remove_timestamps_from_tables',3),(14,'2026_06_18_000002_update_modeles_table',4),(16,'2026_06_18_000004_add_timestamps_to_modeles_table',6),(17,'2026_06_18_000005_add_timestamps_to_fourniture_modele_table',7),(18,'2026_06_18_000006_add_unique_to_materiel_fields',8),(19,'2026_06_18_000003_add_timestamps_back',9),(20,'2026_06_18_000007_add_reference_numero_code_barre_to_fournitures',10),(21,'2026_06_18_000008_add_localisation_identifiant_motdepasse_to_materiel',11),(22,'2026_06_18_000009_add_stock_to_fournitures',11),(23,'2026_06_18_000010_create_bons_livraison_table',12),(24,'2026_06_18_000011_create_entrees_stock_table',12),(25,'2026_06_18_000012_create_sorties_stock_table',12),(26,'2026_06_18_000013_create_entree_stock_materiel_table',12),(27,'2026_06_19_000001_create_snmp_releves_table',13),(28,'2026_06_19_000002_add_donnees_to_snmp_releves_table',14),(29,'2026_06_19_000003_create_snmp_marque_oids_table',15),(30,'2026_06_23_090000_create_oauth_tokens_table',16),(31,'2026_06_23_100000_add_snmp_status_to_materiel',17),(32,'2026_06_23_110000_add_type_to_bons_livraison',18),(33,'2026_06_23_120000_rename_bons_livraison_to_bons',19),(34,'2026_06_23_130000_create_sorties_manquantes_table',20),(35,'2026_06_25_000001_add_commande_id_to_bons',21),(37,'2026_06_26_000001_add_statut_to_bons',22),(38,'2026_06_26_000002_add_distribuee_le_to_snmp_releves',23),(39,'2026_06_26_000003_add_prix_ht_unit_to_entrees_stock',24),(40,'2026_06_26_000004_add_entree_stock_id_to_sorties_stock',24),(41,'2026_06_30_151412_make_materiel_id_nullable_in_sorties_stock',25),(42,'2026_07_01_000001_convert_all_tables_to_innodb',26),(43,'2026_07_03_000001_create_compteurs_historique_table',27); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `modeles` -- DROP TABLE IF EXISTS `modeles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `modeles` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `nom` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `marque_id` bigint unsigned NOT NULL, `statut` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `modeles_marque_id_foreign` (`marque_id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `modeles` -- LOCK TABLES `modeles` WRITE; /*!40000 ALTER TABLE `modeles` DISABLE KEYS */; INSERT INTO `modeles` VALUES (1,'C301i','C301i',1,1,'2026-06-18 08:23:09','2026-07-15 12:40:40'),(2,'C451i','C451i',1,1,'2026-06-18 08:23:54','2026-07-15 12:37:34'),(3,'CX532adwe','CX532adwe',2,1,'2026-06-18 08:30:29','2026-06-18 08:30:29'),(4,'TM-350','Traceur TM-350',4,1,'2026-06-18 09:51:42','2026-06-18 09:51:42'),(5,'IRADV C3822',NULL,4,0,'2026-06-18 09:54:14','2026-07-02 10:15:17'),(6,'DesignJet T795','Traceur HP DesignJet T795',3,1,'2026-06-18 10:17:58','2026-06-18 10:17:58'),(7,'DCP-J562DW',NULL,5,1,'2026-07-02 10:17:35','2026-07-02 10:17:35'),(8,'PageWide Pro 477dw MFP','PageWide Pro 477dw MFP',3,1,'2026-07-02 10:23:18','2026-07-02 10:23:18'),(9,'OfficeJet Pro 8710','OfficeJet Pro 8710 Series',3,1,'2026-07-02 14:54:13','2026-07-02 14:57:53'),(10,'OfficeJet Pro 8720','OfficeJet Pro 8720 Series',3,1,'2026-07-02 14:57:41','2026-07-02 14:57:41'); /*!40000 ALTER TABLE `modeles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `oauth_tokens` -- DROP TABLE IF EXISTS `oauth_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `oauth_tokens` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `provider` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `access_token` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `refresh_token` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `oauth_tokens_provider_unique` (`provider`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `oauth_tokens` -- LOCK TABLES `oauth_tokens` WRITE; /*!40000 ALTER TABLE `oauth_tokens` DISABLE KEYS */; INSERT INTO `oauth_tokens` VALUES (1,'microsoft','eyJ0eXAiOiJKV1QiLCJub25jZSI6InJONFJwd0p1WFFxeFJSczZ4R0ZnenVFWGx0M2ZTR1QwMTZEUm5jc3pGOHciLCJhbGciOiJSUzI1NiIsIng1dCI6ImFGa21LVkZjLTRXVjZzWENCdk5aa1hJNTA1WSIsImtpZCI6ImFGa21LVkZjLTRXVjZzWENCdk5aa1hJNTA1WSJ9.eyJhdWQiOiJodHRwczovL2dyYXBoLm1pY3Jvc29mdC5jb20iLCJpc3MiOiJodHRwczovL3N0cy53aW5kb3dzLm5ldC8wZjE5OWY3Ny1lMjRkLTRkMTAtODgzNC1hZDIyMzhjMzdhMjUvIiwiaWF0IjoxNzgyNzk1MjYxLCJuYmYiOjE3ODI3OTUyNjEsImV4cCI6MTc4MjgwMDE1MywiYWNjdCI6MCwiYWNyIjoiMSIsImFjcnMiOlsicDEiLCJwZmRyIl0sImFpbyI6IkFaUUFhLzhjQUFBQWR1bW9kWE5JNXQybUQ4dGFXWVQ4dkZuK2cweThXN3h0K2ZKSDdKL0UrbDY0VkF1bXhrTWQxRHZoTGhhWEtWNlZKcUl2eDRCbXpQTjViVWZwNkljK0lReXhzcVNlcmdWT0hVMUxpY1RSU1VvNVNuZFlqWVhHQXJmbXpSaUhpcEg3dSswUWdjM0NmbXl0Ky9JNFBMb0pYZjBxdGJ6cEw2SkFacmxRbmNsY0graXZjbFhyVXgxVGpXejZkL3FnSldGcCIsImFtciI6WyJwd2QiLCJtZmEiXSwiYXBwX2Rpc3BsYXluYW1lIjoiTEFSQVZFTC1QSFAiLCJhcHBpZCI6Ijg1MDQxMTAyLTk4NzktNDNiYi05ODI5LTUzZjU5MWZkYzk2YiIsImFwcGlkYWNyIjoiMSIsImZhbWlseV9uYW1lIjoiUEVMTEVHUklOTyIsImdpdmVuX25hbWUiOiJEYXZpZCIsImlkdHlwIjoidXNlciIsImlwYWRkciI6IjE5NS4xMzUuNDEuMTkzIiwibmFtZSI6IlBFTExFR1JJTk8gRGF2aWQgLSBEU0kgQWRqb2ludCIsIm9pZCI6IjIxMTg0NWQ5LThlOTgtNDI5MC1iZTM4LTUxMmQwNzVhODQ2YyIsInBsYXRmIjoiMyIsInB1aWQiOiIxMDAzMjAwNDFGNTFCMjNFIiwicmgiOiIxLkFWOEFkNThaRDAzaUVFMklOSzBpT01ONkpRTUFBQUFBQUFBQXdBQUFBQUFBQUFBQUFQTmZBQS4iLCJzY3AiOiJNYWlsLlJlYWQgTWFpbC5SZWFkV3JpdGUgTWFpbC5TZW5kIFVzZXIuUmVhZCBwcm9maWxlIG9wZW5pZCBlbWFpbCIsInNpZCI6IjAwNWYxN2RhLWNhNmUtZjIwZS1jYjA3LTZiZWRmYzFlYjYzZiIsInN1YiI6IlFOVVlIdU12WGE4UVllR0ZZRXE0ZFlZVDRDY3JHUU1iazRzYVNwR3JXaVEiLCJ0ZW5hbnRfcmVnaW9uX3Njb3BlIjoiRVUiLCJ0aWQiOiIwZjE5OWY3Ny1lMjRkLTRkMTAtODgzNC1hZDIyMzhjMzdhMjUiLCJ1bmlxdWVfbmFtZSI6ImQucGVsbGVncmlub0BtYWlyaWUtZ3JpbWF1ZC5mciIsInVwbiI6ImQucGVsbGVncmlub0BtYWlyaWUtZ3JpbWF1ZC5mciIsInV0aSI6IkZISGVDTVE5LUVhZC1iWEF6VWNlQUEiLCJ2ZXIiOiIxLjAiLCJ3aWRzIjpbImI3OWZiZjRkLTNlZjktNDY4OS04MTQzLTc2YjE5NGU4NTUwOSJdLCJ4bXNfYWNkIjoxNzgxODc4NDc5LCJ4bXNfYWN0X2ZjdCI6IjMgOSIsInhtc19mdGQiOiJoaUZzMG52LWZtWDVwb2s0U29ocWdUYW5hdHN6V2JVSHdLckVFWGNEbENBQlpYVnliM0JsZDJWemRDMWtjMjF6IiwieG1zX2lkcmVsIjoiMSAxNCIsInhtc19wZnRleHAiOjE3ODI4ODY1NTMsInhtc19zdCI6eyJzdWIiOiI1UGNDbHRNZkVHQzhmZjQ3VU5ESDAxb05JNFZEbDZOWlAxbEI0Rjl1Uy13In0sInhtc19zdWJfZmN0IjoiNiAzIiwieG1zX3RjZHQiOjE1OTM3NzkyNjIsInhtc190ZGJyIjoiRVUiLCJ4bXNfdG50X2ZjdCI6IjMgMTAifQ.O8MSZ5GPbrzHyt8EWpaa0n3PmD4gyngCOrnLn-KMwmCVaofPa843znqbGuaIQRyb0-rwSsxUmWkqBMxN9g1PXs9wDHPgXk1Hy7raF-7YspXa30Z9Q3YcSdWSiv5E0HC8cDTAVoon_1036uE1G-ggcWRWU9FGzMmVgdLgDP5T0Awpj5H9zs_5MpSzFi0iPR6hHXQKfzDujv_E0scrQkzlLPgr090jEHyf3kKSHUWPfCAvRLlvSWGIQb76vfKjPfRu0MrkNv6slUmpSJc2wVbUKQ_3QEF6gQWRh47IQ6f06FoUyN5ljx0B2Q3maeBIpyb0nosxjfP-WVy3EQwHmPIveg','1.AV8Ad58ZD03iEE2INK0iOMN6JQIRBIV5mLtDmClT9ZH9yWsAAPNfAA.BQABAwEAAAADAOz_BQD0_0V2b1N0c0FydGlmYWN0cwIAAAAAAKhiKfkl7tfJP9G3VRp0gFavPazKEp4MoJWYXxOdwHoOOe4pJIpuF80l2gj51ZgMWGouWcg7y-K3O5FTC92u6osKAttYZXF9LPtlxtqcV-7mIflanY1BlTK0c31AeHEYP8jQu6_l37rS1oetbXlbzqMsIo-CS-RNwz8BB1KDi7oPOQ-UmKLfNiVmO9iN11iPN2rZt8aGAUS4NfiebBljv7xRtMrQBhx8dgjD2YMUeZNxuNqlCnaFtgDiV3bEQGasBhd69G9rOiuwDHjdyIgg8rnqFhOZW4OyD9Xoq33CaJHyy06eVZqY65O8ekuWHjZOXALL6GAhXmXsJC1xuNgDi4VskQh3RssRAlZuihBXUxPTKV1fbZUCaasWiWkh2N3A9NQGUTPQV6ltIpYRl3F8LAteXC9Dbls4yQqYpcq0_Hurw8-57wRcpbrmtKpDaZDkB7m0Fu8l9Uqmav8MDmN0TAtjeV66ap0SXCyJWOgJqMzbgC-SVWN-4HNEEYxDbd5-1kBgm5pqDO8joY0vMucF8CbIf8knJO6t7DLFNyb6FLIvlz2WV03ybQGWbxoeuEO8q5dv3WypKduDlEbd0BmeK4pmCSlJicE7-wkzI7l4lKS3JSs3N4ZTYp2WKHDpvB3QGxzAnHcHQ8EyWNzLg9KFSaQoXdSvLBqv4QSxvzXDDRMcgFxzyYt9c7SmwTxjg-LbiwV-f0M4OPwSNNNUvWSjKg_HulJcNswwwJh3TfgvnVeI2NQjwDPcnGHrQqVwgDewaLuIi-8z1mXTlaby2bpXfmLG9uc7_hNgWyy4htZdd6tE0XWKlF2Q3SQkibAyRYf7Iyho1Wqh9Rm8IawJ71_KeaypThlb7rAubX7EKI7ayt-bUG3N9ne1ogN12GFnY-kxMi2xhgeM5V0uczoaHmFtUK1Tf-Vdhiy9uTaMvpa_RMqvARWeixy9_XS9YwmtyNc9OfwGdOSk5oQ8wYvMT3nBZGoc5YVk_XhF4k2xk1ZhsLf3cBUDafj56rxfImDvJJL1B10uIUhJF-N_Ctdf-bt4XTZlt_2gKo7qwWTxeRKlUxbarQHYfqcYUVa_TgLc5VLlSzeZhTuvuaKl-oMinjOZU1iJA1Y5jNY0Q_FDzkh8SKJsYi-ue7j7msjhuZf10NHF-xtS-a3vYBNfpuFF4VF2J0cbsTPvAk-FGgED-8HtKzWI6xMCCTXC23WiMeqeQRpWtLpA-I52rJbEMtthfnwfyyBrly6_-Xgn3ArD3JY1onFwUurGW9u7toiL_6U9wysOQKXBzAZN_7hNvnsP3YPPvnDiJoy059PHbgVq2Kmt0E3sgPw7VQOB04Wfuqg01i9n2L74uKI689cjPGqlzTsDA6x25lvTrtVIRPFm1Q9rHTdTpPUznBDgWliuRwLnpICzxFcaGuzifwzF9rlC_Nz4tkN1YJE','2026-06-30 06:17:41','2026-06-23 10:43:17','2026-06-30 05:01:10'); /*!40000 ALTER TABLE `oauth_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_reset_tokens` -- DROP TABLE IF EXISTS `password_reset_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `password_reset_tokens` ( `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_reset_tokens` -- LOCK TABLES `password_reset_tokens` WRITE; /*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sessions` -- DROP TABLE IF EXISTS `sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `sessions` ( `id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint unsigned DEFAULT NULL, `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `last_activity` int NOT NULL, PRIMARY KEY (`id`), KEY `sessions_user_id_index` (`user_id`), KEY `sessions_last_activity_index` (`last_activity`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sessions` -- LOCK TABLES `sessions` WRITE; /*!40000 ALTER TABLE `sessions` DISABLE KEYS */; INSERT INTO `sessions` VALUES ('SemSlqcqvcVMRKwnRVGgeTLY3CouT18MrA0STE6w',NULL,'192.168.1.2','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJWM2ZMZDJpRXpQYTg1ZkhqTmJ2UnRVb2NvS280OUdzRkNHbjZlUnBGIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzE5Mi4xNjguMS4yOjgwODhcL1ByaW50TWFuYWdlclwvcHVibGljIiwicm91dGUiOiJkYXNoYm9hcmQifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==',1784190961),('U6YgopsvcCXH2g3PCldyBu87bXqSpwnkcjSwsy2z',NULL,'192.168.1.2','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJlWjRaTzhqMkZYTEFPT2xIWDJpWEdxcHZVd0RQclYyVlBtM1RUS3lJIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzE5Mi4xNjguMS4yOjgwODhcL1ByaW50TWFuYWdlclwvcHVibGljXC9kYXRhYmFzZVwvYmFja3VwIiwicm91dGUiOiJkYXRhYmFzZS5iYWNrdXAifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==',1784274754),('v0AeJjmp7lzSnUgBXyHnq5PWhgwYRhhzimPmWJfj',NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJNWjVaMzI5czkzbk16bjFzZ2tvNFNJaEY3MUVJZVNGM0M1SjBtc1BJIiwidXJsIjp7ImludGVuZGVkIjoiaHR0cDpcL1wvbG9jYWxob3N0OjgwODhcL0lIVFNcL3B1YmxpY1wvZGFzaGJvYXJkIn0sIl9wcmV2aW91cyI6eyJ1cmwiOiJodHRwOlwvXC9sb2NhbGhvc3Q6ODA4OFwvSUhUU1wvcHVibGljXC9sb2dpbiIsInJvdXRlIjoibG9naW4ifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==',1784274454); /*!40000 ALTER TABLE `sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `snmp_marque_oids` -- DROP TABLE IF EXISTS `snmp_marque_oids`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `snmp_marque_oids` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `marque_id` bigint unsigned NOT NULL, `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `oid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `snmp_marque_oids_marque_id_type_unique` (`marque_id`,`type`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `snmp_marque_oids` -- LOCK TABLES `snmp_marque_oids` WRITE; /*!40000 ALTER TABLE `snmp_marque_oids` DISABLE KEYS */; INSERT INTO `snmp_marque_oids` VALUES (3,1,'nb_impressions','.1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.2','2026-06-19 11:09:24','2026-06-19 11:09:24'),(4,1,'nb_copies','.1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.1','2026-06-19 11:09:24','2026-06-19 11:09:24'),(5,1,'couleur_impressions','.1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.2','2026-06-19 11:09:24','2026-06-19 11:09:24'),(6,1,'couleur_copies','.1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.1','2026-06-19 11:09:24','2026-06-19 11:09:24'),(7,2,'nb_impressions','.1.3.6.1.4.1.641.6.4.2.1.1.4.1.11','2026-06-19 11:32:53','2026-06-19 11:32:53'),(8,2,'nb_copies','.1.3.6.1.4.1.641.6.4.2.1.1.4.1.14','2026-06-19 11:32:53','2026-06-19 11:32:53'),(9,2,'couleur_impressions','.1.3.6.1.4.1.641.6.4.2.1.1.4.1.12','2026-06-19 11:32:53','2026-06-19 11:32:53'),(10,2,'couleur_copies','.1.3.6.1.4.1.641.6.4.2.1.1.4.1.15','2026-06-19 11:32:53','2026-06-19 11:32:53'),(11,1,'waste','.1.3.6.1.2.1.43.11.1.1.7.1.13','2026-06-19 11:49:38','2026-06-19 12:01:29'),(12,3,'nb_total','.1.3.6.1.4.1.11.2.3.9.4.2.1.1.16.1.53.0','2026-06-19 12:19:36','2026-06-19 13:10:51'),(13,3,'couleur_total','.1.3.6.1.4.1.11.2.3.9.4.2.1.1.16.1.54.0','2026-06-19 12:19:36','2026-06-19 13:10:51'); /*!40000 ALTER TABLE `snmp_marque_oids` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `snmp_releves` -- DROP TABLE IF EXISTS `snmp_releves`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `snmp_releves` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `materiel_id` bigint unsigned NOT NULL, `index_entree` int NOT NULL, `type_consommable` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `niveau_actuel` int DEFAULT NULL, `niveau_max` int DEFAULT NULL, `pourcentage` decimal(5,2) DEFAULT NULL, `unite` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `releve_at` timestamp NOT NULL, `distribuee_le` timestamp NULL DEFAULT NULL, `donnees` json DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `snmp_releves_materiel_id_index_entree_releve_at_index` (`materiel_id`,`index_entree`,`releve_at`) ) ENGINE=InnoDB AUTO_INCREMENT=12242 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `snmp_releves` -- LOCK TABLES `snmp_releves` WRITE; /*!40000 ALTER TABLE `snmp_releves` DISABLE KEYS */; INSERT INTO `snmp_releves` VALUES (12014,1,1,'toner','Toner (Cyan)',39,100,39.00,NULL,'2026-07-17 05:00:05',NULL,NULL,'2026-07-17 05:00:05','2026-07-17 05:00:05'),(12015,1,2,'toner','Toner (Magenta)',43,100,43.00,NULL,'2026-07-17 05:00:05',NULL,NULL,'2026-07-17 05:00:05','2026-07-17 05:00:05'),(12016,1,3,'toner','Toner (Yellow)',45,100,45.00,NULL,'2026-07-17 05:00:05',NULL,NULL,'2026-07-17 05:00:05','2026-07-17 05:00:05'),(12017,1,4,'toner','Toner (Black)',68,100,68.00,NULL,'2026-07-17 05:00:05',NULL,NULL,'2026-07-17 05:00:05','2026-07-17 05:00:05'),(12018,1,18,'toner','Staple Cartridge',1,NULL,NULL,NULL,'2026-07-17 05:00:05',NULL,NULL,'2026-07-17 05:00:05','2026-07-17 05:00:05'),(12019,1,200,'compteur','Pages N&B',15358,NULL,NULL,'pages','2026-07-17 05:00:05',NULL,NULL,'2026-07-17 05:00:05','2026-07-17 05:00:05'),(12020,1,201,'compteur','Pages couleur',24255,NULL,NULL,'pages','2026-07-17 05:00:05',NULL,NULL,'2026-07-17 05:00:05','2026-07-17 05:00:05'),(12021,1,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-07-17 05:00:05',NULL,NULL,'2026-07-17 05:00:05','2026-07-17 05:00:05'),(12022,2,1,'toner','Toner (Cyan)',54,100,54.00,NULL,'2026-07-17 05:00:05',NULL,NULL,'2026-07-17 05:00:05','2026-07-17 05:00:05'),(12023,2,2,'toner','Toner (Magenta)',65,100,65.00,NULL,'2026-07-17 05:00:05',NULL,NULL,'2026-07-17 05:00:05','2026-07-17 05:00:05'),(12024,2,3,'toner','Toner (Yellow)',53,100,53.00,NULL,'2026-07-17 05:00:05',NULL,NULL,'2026-07-17 05:00:05','2026-07-17 05:00:05'),(12025,2,4,'toner','Toner (Black)',32,100,32.00,NULL,'2026-07-17 05:00:05',NULL,NULL,'2026-07-17 05:00:05','2026-07-17 05:00:05'),(12026,2,200,'compteur','Pages N&B',28106,NULL,NULL,'pages','2026-07-17 05:00:05',NULL,NULL,'2026-07-17 05:00:05','2026-07-17 05:00:05'),(12027,2,201,'compteur','Pages couleur',23638,NULL,NULL,'pages','2026-07-17 05:00:05',NULL,NULL,'2026-07-17 05:00:05','2026-07-17 05:00:05'),(12028,2,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-07-17 05:00:05',NULL,NULL,'2026-07-17 05:00:05','2026-07-17 05:00:05'),(12029,3,1,'toner','Toner (Cyan)',64,100,64.00,NULL,'2026-07-17 05:00:05',NULL,NULL,'2026-07-17 05:00:05','2026-07-17 05:00:05'),(12030,3,2,'toner','Toner (Magenta)',79,100,79.00,NULL,'2026-07-17 05:00:05',NULL,NULL,'2026-07-17 05:00:05','2026-07-17 05:00:05'),(12031,3,3,'toner','Toner (Yellow)',57,100,57.00,NULL,'2026-07-17 05:00:05',NULL,NULL,'2026-07-17 05:00:05','2026-07-17 05:00:05'),(12032,3,4,'toner','Toner (Black)',9,100,9.00,NULL,'2026-07-17 05:00:05',NULL,NULL,'2026-07-17 05:00:05','2026-07-17 05:00:05'),(12033,3,18,'toner','Staple Cartridge',1,NULL,NULL,NULL,'2026-07-17 05:00:05',NULL,NULL,'2026-07-17 05:00:05','2026-07-17 05:00:05'),(12034,3,200,'compteur','Pages N&B',11217,NULL,NULL,'pages','2026-07-17 05:00:05',NULL,NULL,'2026-07-17 05:00:05','2026-07-17 05:00:05'),(12035,3,201,'compteur','Pages couleur',47306,NULL,NULL,'pages','2026-07-17 05:00:05',NULL,NULL,'2026-07-17 05:00:05','2026-07-17 05:00:05'),(12036,3,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-07-17 05:00:05',NULL,NULL,'2026-07-17 05:00:05','2026-07-17 05:00:05'),(12037,4,1,'toner','Toner (Cyan)',92,100,92.00,NULL,'2026-07-17 05:00:06',NULL,NULL,'2026-07-17 05:00:06','2026-07-17 05:00:06'),(12038,4,2,'toner','Toner (Magenta)',93,100,93.00,NULL,'2026-07-17 05:00:06',NULL,NULL,'2026-07-17 05:00:06','2026-07-17 05:00:06'),(12039,4,3,'toner','Toner (Yellow)',92,100,92.00,NULL,'2026-07-17 05:00:06',NULL,NULL,'2026-07-17 05:00:06','2026-07-17 05:00:06'),(12040,4,4,'toner','Toner (Black)',84,100,84.00,NULL,'2026-07-17 05:00:06',NULL,NULL,'2026-07-17 05:00:06','2026-07-17 05:00:06'),(12041,4,200,'compteur','Pages N&B',342,NULL,NULL,'pages','2026-07-17 05:00:06',NULL,NULL,'2026-07-17 05:00:06','2026-07-17 05:00:06'),(12042,4,201,'compteur','Pages couleur',1424,NULL,NULL,'pages','2026-07-17 05:00:06',NULL,NULL,'2026-07-17 05:00:06','2026-07-17 05:00:06'),(12043,4,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-07-17 05:00:06',NULL,NULL,'2026-07-17 05:00:06','2026-07-17 05:00:06'),(12044,5,1,'toner','Toner (Cyan)',45,100,45.00,NULL,'2026-07-17 05:00:06',NULL,NULL,'2026-07-17 05:00:06','2026-07-17 05:00:06'),(12045,5,2,'toner','Toner (Magenta)',66,100,66.00,NULL,'2026-07-17 05:00:06',NULL,NULL,'2026-07-17 05:00:06','2026-07-17 05:00:06'),(12046,5,3,'toner','Toner (Yellow)',55,100,55.00,NULL,'2026-07-17 05:00:06',NULL,NULL,'2026-07-17 05:00:06','2026-07-17 05:00:06'),(12047,5,4,'toner','Toner (Black)',10,100,10.00,NULL,'2026-07-17 05:00:06',NULL,NULL,'2026-07-17 05:00:06','2026-07-17 05:00:06'),(12048,5,200,'compteur','Pages N&B',5658,NULL,NULL,'pages','2026-07-17 05:00:06',NULL,NULL,'2026-07-17 05:00:06','2026-07-17 05:00:06'),(12049,5,201,'compteur','Pages couleur',19181,NULL,NULL,'pages','2026-07-17 05:00:06',NULL,NULL,'2026-07-17 05:00:06','2026-07-17 05:00:06'),(12050,5,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-07-17 05:00:06',NULL,NULL,'2026-07-17 05:00:06','2026-07-17 05:00:06'),(12051,6,1,'toner','Toner (Cyan)',40,100,40.00,NULL,'2026-07-17 05:00:06',NULL,NULL,'2026-07-17 05:00:06','2026-07-17 05:00:06'),(12052,6,2,'toner','Toner (Magenta)',38,100,38.00,NULL,'2026-07-17 05:00:06',NULL,NULL,'2026-07-17 05:00:06','2026-07-17 05:00:06'),(12053,6,3,'toner','Toner (Yellow)',35,100,35.00,NULL,'2026-07-17 05:00:06',NULL,NULL,'2026-07-17 05:00:06','2026-07-17 05:00:06'),(12054,6,4,'toner','Toner (Black)',64,100,64.00,NULL,'2026-07-17 05:00:06',NULL,NULL,'2026-07-17 05:00:06','2026-07-17 05:00:06'),(12055,6,18,'toner','Staple Cartridge',1,NULL,NULL,NULL,'2026-07-17 05:00:06',NULL,NULL,'2026-07-17 05:00:06','2026-07-17 05:00:06'),(12056,6,200,'compteur','Pages N&B',11409,NULL,NULL,'pages','2026-07-17 05:00:06',NULL,NULL,'2026-07-17 05:00:06','2026-07-17 05:00:06'),(12057,6,201,'compteur','Pages couleur',27730,NULL,NULL,'pages','2026-07-17 05:00:06',NULL,NULL,'2026-07-17 05:00:06','2026-07-17 05:00:06'),(12058,6,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-07-17 05:00:06',NULL,NULL,'2026-07-17 05:00:06','2026-07-17 05:00:06'),(12059,7,1,'toner','Toner (Cyan)',47,100,47.00,NULL,'2026-07-17 05:00:07',NULL,NULL,'2026-07-17 05:00:07','2026-07-17 05:00:07'),(12060,7,2,'toner','Toner (Magenta)',56,100,56.00,NULL,'2026-07-17 05:00:07',NULL,NULL,'2026-07-17 05:00:07','2026-07-17 05:00:07'),(12061,7,3,'toner','Toner (Yellow)',47,100,47.00,NULL,'2026-07-17 05:00:07',NULL,NULL,'2026-07-17 05:00:07','2026-07-17 05:00:07'),(12062,7,4,'toner','Toner (Black)',84,100,84.00,NULL,'2026-07-17 05:00:07',NULL,NULL,'2026-07-17 05:00:07','2026-07-17 05:00:07'),(12063,7,18,'toner','Staple Cartridge',1,NULL,NULL,NULL,'2026-07-17 05:00:07',NULL,NULL,'2026-07-17 05:00:07','2026-07-17 05:00:07'),(12064,7,200,'compteur','Pages N&B',16118,NULL,NULL,'pages','2026-07-17 05:00:07',NULL,NULL,'2026-07-17 05:00:07','2026-07-17 05:00:07'),(12065,7,201,'compteur','Pages couleur',16893,NULL,NULL,'pages','2026-07-17 05:00:07',NULL,NULL,'2026-07-17 05:00:07','2026-07-17 05:00:07'),(12066,7,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-07-17 05:00:07',NULL,NULL,'2026-07-17 05:00:07','2026-07-17 05:00:07'),(12067,8,1,'toner','Toner (Cyan)',36,100,36.00,NULL,'2026-07-17 05:00:07',NULL,NULL,'2026-07-17 05:00:07','2026-07-17 05:00:07'),(12068,8,2,'toner','Toner (Magenta)',41,100,41.00,NULL,'2026-07-17 05:00:07',NULL,NULL,'2026-07-17 05:00:07','2026-07-17 05:00:07'),(12069,8,3,'toner','Toner (Yellow)',35,100,35.00,NULL,'2026-07-17 05:00:07',NULL,NULL,'2026-07-17 05:00:07','2026-07-17 05:00:07'),(12070,8,4,'toner','Toner (Black)',91,100,91.00,NULL,'2026-07-17 05:00:07',NULL,NULL,'2026-07-17 05:00:07','2026-07-17 05:00:07'),(12071,8,200,'compteur','Pages N&B',3102,NULL,NULL,'pages','2026-07-17 05:00:07',NULL,NULL,'2026-07-17 05:00:07','2026-07-17 05:00:07'),(12072,8,201,'compteur','Pages couleur',13206,NULL,NULL,'pages','2026-07-17 05:00:07',NULL,NULL,'2026-07-17 05:00:07','2026-07-17 05:00:07'),(12073,8,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-07-17 05:00:07',NULL,NULL,'2026-07-17 05:00:07','2026-07-17 05:00:07'),(12074,9,1,'toner','Toner (Cyan)',68,100,68.00,NULL,'2026-07-17 05:00:07',NULL,NULL,'2026-07-17 05:00:07','2026-07-17 05:00:07'),(12075,9,2,'toner','Toner (Magenta)',74,100,74.00,NULL,'2026-07-17 05:00:07',NULL,NULL,'2026-07-17 05:00:07','2026-07-17 05:00:07'),(12076,9,3,'toner','Toner (Yellow)',68,100,68.00,NULL,'2026-07-17 05:00:07',NULL,NULL,'2026-07-17 05:00:07','2026-07-17 05:00:07'),(12077,9,4,'toner','Toner (Black)',11,100,11.00,NULL,'2026-07-17 05:00:07',NULL,NULL,'2026-07-17 05:00:07','2026-07-17 05:00:07'),(12078,9,200,'compteur','Pages N&B',13855,NULL,NULL,'pages','2026-07-17 05:00:07',NULL,NULL,'2026-07-17 05:00:07','2026-07-17 05:00:07'),(12079,9,201,'compteur','Pages couleur',12918,NULL,NULL,'pages','2026-07-17 05:00:07',NULL,NULL,'2026-07-17 05:00:07','2026-07-17 05:00:07'),(12080,9,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-07-17 05:00:07',NULL,NULL,'2026-07-17 05:00:08','2026-07-17 05:00:08'),(12081,10,1,'toner','Toner (Cyan)',89,100,89.00,NULL,'2026-07-17 05:00:08',NULL,NULL,'2026-07-17 05:00:08','2026-07-17 05:00:08'),(12082,10,2,'toner','Toner (Magenta)',91,100,91.00,NULL,'2026-07-17 05:00:08',NULL,NULL,'2026-07-17 05:00:08','2026-07-17 05:00:08'),(12083,10,3,'toner','Toner (Yellow)',88,100,88.00,NULL,'2026-07-17 05:00:08',NULL,NULL,'2026-07-17 05:00:08','2026-07-17 05:00:08'),(12084,10,4,'toner','Toner (Black)',15,100,15.00,NULL,'2026-07-17 05:00:08',NULL,NULL,'2026-07-17 05:00:08','2026-07-17 05:00:08'),(12085,10,200,'compteur','Pages N&B',14798,NULL,NULL,'pages','2026-07-17 05:00:08',NULL,NULL,'2026-07-17 05:00:08','2026-07-17 05:00:08'),(12086,10,201,'compteur','Pages couleur',5109,NULL,NULL,'pages','2026-07-17 05:00:08',NULL,NULL,'2026-07-17 05:00:08','2026-07-17 05:00:08'),(12087,10,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-07-17 05:00:08',NULL,NULL,'2026-07-17 05:00:08','2026-07-17 05:00:08'),(12088,11,1,'toner','Toner (Cyan)',90,100,90.00,NULL,'2026-07-17 05:00:08',NULL,NULL,'2026-07-17 05:00:08','2026-07-17 05:00:08'),(12089,11,2,'toner','Toner (Magenta)',92,100,92.00,NULL,'2026-07-17 05:00:08',NULL,NULL,'2026-07-17 05:00:08','2026-07-17 05:00:08'),(12090,11,3,'toner','Toner (Yellow)',90,100,90.00,NULL,'2026-07-17 05:00:08',NULL,NULL,'2026-07-17 05:00:08','2026-07-17 05:00:08'),(12091,11,4,'toner','Toner (Black)',71,100,71.00,NULL,'2026-07-17 05:00:08',NULL,NULL,'2026-07-17 05:00:08','2026-07-17 05:00:08'),(12092,11,200,'compteur','Pages N&B',3665,NULL,NULL,'pages','2026-07-17 05:00:08',NULL,NULL,'2026-07-17 05:00:08','2026-07-17 05:00:08'),(12093,11,201,'compteur','Pages couleur',3738,NULL,NULL,'pages','2026-07-17 05:00:08',NULL,NULL,'2026-07-17 05:00:08','2026-07-17 05:00:08'),(12094,11,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-07-17 05:00:08',NULL,NULL,'2026-07-17 05:00:08','2026-07-17 05:00:08'),(12095,12,1,'toner','Toner (Cyan)',75,100,75.00,NULL,'2026-07-17 05:00:08',NULL,NULL,'2026-07-17 05:00:08','2026-07-17 05:00:08'),(12096,12,2,'toner','Toner (Magenta)',78,100,78.00,NULL,'2026-07-17 05:00:08',NULL,NULL,'2026-07-17 05:00:08','2026-07-17 05:00:08'),(12097,12,3,'toner','Toner (Yellow)',72,100,72.00,NULL,'2026-07-17 05:00:08',NULL,NULL,'2026-07-17 05:00:08','2026-07-17 05:00:08'),(12098,12,4,'toner','Toner (Black)',48,100,48.00,NULL,'2026-07-17 05:00:08',NULL,NULL,'2026-07-17 05:00:08','2026-07-17 05:00:08'),(12099,12,200,'compteur','Pages N&B',2676,NULL,NULL,'pages','2026-07-17 05:00:08',NULL,NULL,'2026-07-17 05:00:08','2026-07-17 05:00:08'),(12100,12,201,'compteur','Pages couleur',10622,NULL,NULL,'pages','2026-07-17 05:00:08',NULL,NULL,'2026-07-17 05:00:08','2026-07-17 05:00:08'),(12101,12,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-07-17 05:00:08',NULL,NULL,'2026-07-17 05:00:08','2026-07-17 05:00:08'),(12102,13,1,'toner','Toner (Cyan)',67,100,67.00,NULL,'2026-07-17 05:00:09',NULL,NULL,'2026-07-17 05:00:09','2026-07-17 05:00:09'),(12103,13,2,'toner','Toner (Magenta)',74,100,74.00,NULL,'2026-07-17 05:00:09',NULL,NULL,'2026-07-17 05:00:09','2026-07-17 05:00:09'),(12104,13,3,'toner','Toner (Yellow)',64,100,64.00,NULL,'2026-07-17 05:00:09',NULL,NULL,'2026-07-17 05:00:09','2026-07-17 05:00:09'),(12105,13,4,'toner','Toner (Black)',33,100,33.00,NULL,'2026-07-17 05:00:09',NULL,NULL,'2026-07-17 05:00:09','2026-07-17 05:00:09'),(12106,13,200,'compteur','Pages N&B',3744,NULL,NULL,'pages','2026-07-17 05:00:09',NULL,NULL,'2026-07-17 05:00:09','2026-07-17 05:00:09'),(12107,13,201,'compteur','Pages couleur',13903,NULL,NULL,'pages','2026-07-17 05:00:09',NULL,NULL,'2026-07-17 05:00:09','2026-07-17 05:00:09'),(12108,13,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-07-17 05:00:09',NULL,NULL,'2026-07-17 05:00:09','2026-07-17 05:00:09'),(12109,14,1,'toner','Toner (Cyan)',40,100,40.00,NULL,'2026-07-17 05:00:09',NULL,NULL,'2026-07-17 05:00:09','2026-07-17 05:00:09'),(12110,14,2,'toner','Toner (Magenta)',51,100,51.00,NULL,'2026-07-17 05:00:09',NULL,NULL,'2026-07-17 05:00:09','2026-07-17 05:00:09'),(12111,14,3,'toner','Toner (Yellow)',36,100,36.00,NULL,'2026-07-17 05:00:09',NULL,NULL,'2026-07-17 05:00:09','2026-07-17 05:00:09'),(12112,14,4,'toner','Toner (Black)',82,100,82.00,NULL,'2026-07-17 05:00:09',NULL,NULL,'2026-07-17 05:00:09','2026-07-17 05:00:09'),(12113,14,200,'compteur','Pages N&B',5837,NULL,NULL,'pages','2026-07-17 05:00:09',NULL,NULL,'2026-07-17 05:00:09','2026-07-17 05:00:09'),(12114,14,201,'compteur','Pages couleur',27792,NULL,NULL,'pages','2026-07-17 05:00:09',NULL,NULL,'2026-07-17 05:00:10','2026-07-17 05:00:10'),(12115,14,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-07-17 05:00:09',NULL,NULL,'2026-07-17 05:00:10','2026-07-17 05:00:10'),(12116,16,1,'toner','Toner (Cyan)',82,100,82.00,NULL,'2026-07-17 05:00:10',NULL,NULL,'2026-07-17 05:00:10','2026-07-17 05:00:10'),(12117,16,2,'toner','Toner (Magenta)',84,100,84.00,NULL,'2026-07-17 05:00:10',NULL,NULL,'2026-07-17 05:00:10','2026-07-17 05:00:10'),(12118,16,3,'toner','Toner (Yellow)',79,100,79.00,NULL,'2026-07-17 05:00:10',NULL,NULL,'2026-07-17 05:00:10','2026-07-17 05:00:10'),(12119,16,4,'toner','Toner (Black)',54,100,54.00,NULL,'2026-07-17 05:00:10',NULL,NULL,'2026-07-17 05:00:10','2026-07-17 05:00:10'),(12120,16,200,'compteur','Pages N&B',7521,NULL,NULL,'pages','2026-07-17 05:00:10',NULL,NULL,'2026-07-17 05:00:10','2026-07-17 05:00:10'),(12121,16,201,'compteur','Pages couleur',6513,NULL,NULL,'pages','2026-07-17 05:00:10',NULL,NULL,'2026-07-17 05:00:10','2026-07-17 05:00:10'),(12122,16,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-07-17 05:00:10',NULL,NULL,'2026-07-17 05:00:10','2026-07-17 05:00:10'),(12123,21,1,'toner','Toner (Cyan)',70,100,70.00,NULL,'2026-07-17 05:01:00',NULL,NULL,'2026-07-17 05:01:00','2026-07-17 05:01:00'),(12124,21,2,'toner','Toner (Magenta)',74,100,74.00,NULL,'2026-07-17 05:01:00',NULL,NULL,'2026-07-17 05:01:00','2026-07-17 05:01:00'),(12125,21,3,'toner','Toner (Yellow)',66,100,66.00,NULL,'2026-07-17 05:01:00',NULL,NULL,'2026-07-17 05:01:00','2026-07-17 05:01:00'),(12126,21,4,'toner','Toner (Black)',36,100,36.00,NULL,'2026-07-17 05:01:00',NULL,NULL,'2026-07-17 05:01:00','2026-07-17 05:01:00'),(12127,21,200,'compteur','Pages N&B',5743,NULL,NULL,'pages','2026-07-17 05:01:00',NULL,NULL,'2026-07-17 05:01:00','2026-07-17 05:01:00'),(12128,21,201,'compteur','Pages couleur',8981,NULL,NULL,'pages','2026-07-17 05:01:00',NULL,NULL,'2026-07-17 05:01:00','2026-07-17 05:01:00'),(12129,21,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-07-17 05:01:00',NULL,NULL,'2026-07-17 05:01:00','2026-07-17 05:01:00'),(12130,23,1,'toner','Toner (Cyan)',43,100,43.00,NULL,'2026-07-17 05:01:17',NULL,NULL,'2026-07-17 05:01:17','2026-07-17 05:01:17'),(12131,23,2,'toner','Toner (Magenta)',57,100,57.00,NULL,'2026-07-17 05:01:17',NULL,NULL,'2026-07-17 05:01:17','2026-07-17 05:01:17'),(12132,23,3,'toner','Toner (Yellow)',57,100,57.00,NULL,'2026-07-17 05:01:17',NULL,NULL,'2026-07-17 05:01:17','2026-07-17 05:01:17'),(12133,23,4,'toner','Toner (Black)',19,100,19.00,NULL,'2026-07-17 05:01:17',NULL,NULL,'2026-07-17 05:01:17','2026-07-17 05:01:17'),(12134,23,18,'toner','Staple Cartridge',1,NULL,NULL,NULL,'2026-07-17 05:01:17',NULL,NULL,'2026-07-17 05:01:17','2026-07-17 05:01:17'),(12135,23,200,'compteur','Pages N&B',4621,NULL,NULL,'pages','2026-07-17 05:01:17',NULL,NULL,'2026-07-17 05:01:17','2026-07-17 05:01:17'),(12136,23,201,'compteur','Pages couleur',18674,NULL,NULL,'pages','2026-07-17 05:01:17',NULL,NULL,'2026-07-17 05:01:17','2026-07-17 05:01:17'),(12137,23,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-07-17 05:01:17',NULL,NULL,'2026-07-17 05:01:17','2026-07-17 05:01:17'),(12138,24,1,'toner','Toner (Cyan)',79,100,79.00,NULL,'2026-07-17 05:01:17',NULL,NULL,'2026-07-17 05:01:17','2026-07-17 05:01:17'),(12139,24,2,'toner','Toner (Magenta)',85,100,85.00,NULL,'2026-07-17 05:01:17',NULL,NULL,'2026-07-17 05:01:17','2026-07-17 05:01:17'),(12140,24,3,'toner','Toner (Yellow)',81,100,81.00,NULL,'2026-07-17 05:01:17',NULL,NULL,'2026-07-17 05:01:17','2026-07-17 05:01:17'),(12141,24,4,'toner','Toner (Black)',61,100,61.00,NULL,'2026-07-17 05:01:17',NULL,NULL,'2026-07-17 05:01:17','2026-07-17 05:01:17'),(12142,24,200,'compteur','Pages N&B',2438,NULL,NULL,'pages','2026-07-17 05:01:17',NULL,NULL,'2026-07-17 05:01:17','2026-07-17 05:01:17'),(12143,24,201,'compteur','Pages couleur',8174,NULL,NULL,'pages','2026-07-17 05:01:17',NULL,NULL,'2026-07-17 05:01:17','2026-07-17 05:01:17'),(12144,24,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-07-17 05:01:17',NULL,NULL,'2026-07-17 05:01:18','2026-07-17 05:01:18'),(12145,26,1,'toner','ADF Kit',103400,110000,94.00,NULL,'2026-07-17 05:01:18',NULL,NULL,'2026-07-17 05:01:18','2026-07-17 05:01:18'),(12146,26,2,'toner','Black Cartridge',632,15800,4.00,NULL,'2026-07-17 05:01:18',NULL,NULL,'2026-07-17 05:01:18','2026-07-17 05:01:18'),(12147,26,3,'toner','Cyan Cartridge',7040,8800,80.00,NULL,'2026-07-17 05:01:18',NULL,NULL,'2026-07-17 05:01:18','2026-07-17 05:01:18'),(12148,26,4,'toner','Transfer Module',150000,150000,100.00,NULL,'2026-07-17 05:01:18',NULL,NULL,'2026-07-17 05:01:18','2026-07-17 05:01:18'),(12149,26,5,'toner','Imaging Kit',150000,150000,100.00,NULL,'2026-07-17 05:01:18',NULL,NULL,'2026-07-17 05:01:18','2026-07-17 05:01:18'),(12150,26,6,'toner','Magenta Cartridge',6512,8800,74.00,NULL,'2026-07-17 05:01:18',NULL,NULL,'2026-07-17 05:01:18','2026-07-17 05:01:18'),(12151,26,7,'toner','Maintenance Kit',135000,150000,90.00,NULL,'2026-07-17 05:01:18',NULL,NULL,'2026-07-17 05:01:18','2026-07-17 05:01:18'),(12152,26,8,'dechet_toner','Waste Toner Bottle',15899,30000,47.00,NULL,'2026-07-17 05:01:18',NULL,NULL,'2026-07-17 05:01:18','2026-07-17 05:01:18'),(12153,26,9,'toner','Yellow Cartridge',6160,8800,70.00,NULL,'2026-07-17 05:01:18',NULL,NULL,'2026-07-17 05:01:18','2026-07-17 05:01:18'),(12154,26,200,'compteur','Pages N&B',6959,NULL,NULL,'pages','2026-07-17 05:01:18',NULL,NULL,'2026-07-17 05:01:18','2026-07-17 05:01:18'),(12155,26,201,'compteur','Pages couleur',6080,NULL,NULL,'pages','2026-07-17 05:01:18',NULL,NULL,'2026-07-17 05:01:18','2026-07-17 05:01:18'),(12156,27,1,'toner','ADF Kit',108900,110000,99.00,NULL,'2026-07-17 05:01:19',NULL,NULL,'2026-07-17 05:01:19','2026-07-17 05:01:19'),(12157,27,2,'toner','Black Cartridge',11534,15800,73.00,NULL,'2026-07-17 05:01:19',NULL,NULL,'2026-07-17 05:01:19','2026-07-17 05:01:19'),(12158,27,3,'toner','Cyan Cartridge',7040,8800,80.00,NULL,'2026-07-17 05:01:19',NULL,NULL,'2026-07-17 05:01:19','2026-07-17 05:01:19'),(12159,27,4,'toner','Transfer Module',150000,150000,100.00,NULL,'2026-07-17 05:01:19',NULL,NULL,'2026-07-17 05:01:19','2026-07-17 05:01:19'),(12160,27,5,'toner','Imaging Kit',150000,150000,100.00,NULL,'2026-07-17 05:01:19',NULL,NULL,'2026-07-17 05:01:19','2026-07-17 05:01:19'),(12161,27,6,'toner','Magenta Cartridge',6864,8800,78.00,NULL,'2026-07-17 05:01:19',NULL,NULL,'2026-07-17 05:01:19','2026-07-17 05:01:19'),(12162,27,7,'toner','Maintenance Kit',150000,150000,100.00,NULL,'2026-07-17 05:01:19',NULL,NULL,'2026-07-17 05:01:19','2026-07-17 05:01:19'),(12163,27,8,'dechet_toner','Waste Toner Bottle',20400,30000,32.00,NULL,'2026-07-17 05:01:19',NULL,NULL,'2026-07-17 05:01:19','2026-07-17 05:01:19'),(12164,27,9,'toner','Yellow Cartridge',7832,8800,89.00,NULL,'2026-07-17 05:01:19',NULL,NULL,'2026-07-17 05:01:19','2026-07-17 05:01:19'),(12165,27,200,'compteur','Pages N&B',2301,NULL,NULL,'pages','2026-07-17 05:01:19',NULL,NULL,'2026-07-17 05:01:19','2026-07-17 05:01:19'),(12166,27,201,'compteur','Pages couleur',3026,NULL,NULL,'pages','2026-07-17 05:01:19',NULL,NULL,'2026-07-17 05:01:19','2026-07-17 05:01:19'),(12167,28,1,'toner','ADF Kit',108900,110000,99.00,NULL,'2026-07-17 05:01:19',NULL,NULL,'2026-07-17 05:01:19','2026-07-17 05:01:19'),(12168,28,2,'toner','Black Cartridge',15800,15800,100.00,NULL,'2026-07-17 05:01:19',NULL,NULL,'2026-07-17 05:01:19','2026-07-17 05:01:19'),(12169,28,3,'toner','Cyan Cartridge',8800,8800,100.00,NULL,'2026-07-17 05:01:20',NULL,NULL,'2026-07-17 05:01:20','2026-07-17 05:01:20'),(12170,28,4,'toner','Transfer Module',150000,150000,100.00,NULL,'2026-07-17 05:01:20',NULL,NULL,'2026-07-17 05:01:20','2026-07-17 05:01:20'),(12171,28,5,'toner','Imaging Kit',150000,150000,100.00,NULL,'2026-07-17 05:01:20',NULL,NULL,'2026-07-17 05:01:20','2026-07-17 05:01:20'),(12172,28,6,'toner','Magenta Cartridge',8800,8800,100.00,NULL,'2026-07-17 05:01:20',NULL,NULL,'2026-07-17 05:01:20','2026-07-17 05:01:20'),(12173,28,7,'toner','Maintenance Kit',150000,150000,100.00,NULL,'2026-07-17 05:01:20',NULL,NULL,'2026-07-17 05:01:20','2026-07-17 05:01:20'),(12174,28,8,'dechet_toner','Waste Toner Bottle',25500,30000,15.00,NULL,'2026-07-17 05:01:20',NULL,NULL,'2026-07-17 05:01:20','2026-07-17 05:01:20'),(12175,28,9,'toner','Yellow Cartridge',8800,8800,100.00,NULL,'2026-07-17 05:01:20',NULL,NULL,'2026-07-17 05:01:20','2026-07-17 05:01:20'),(12176,28,200,'compteur','Pages N&B',696,NULL,NULL,'pages','2026-07-17 05:01:20',NULL,NULL,'2026-07-17 05:01:20','2026-07-17 05:01:20'),(12177,28,201,'compteur','Pages couleur',2225,NULL,NULL,'pages','2026-07-17 05:01:20',NULL,NULL,'2026-07-17 05:01:20','2026-07-17 05:01:20'),(12178,29,1,'toner','ADF Kit',108900,110000,99.00,NULL,'2026-07-17 05:01:20',NULL,NULL,'2026-07-17 05:01:20','2026-07-17 05:01:20'),(12179,29,2,'toner','Black Cartridge',11060,15800,70.00,NULL,'2026-07-17 05:01:20',NULL,NULL,'2026-07-17 05:01:20','2026-07-17 05:01:20'),(12180,29,3,'toner','Cyan Cartridge',6952,8800,79.00,NULL,'2026-07-17 05:01:20',NULL,NULL,'2026-07-17 05:01:20','2026-07-17 05:01:20'),(12181,29,4,'toner','Transfer Module',150000,150000,100.00,NULL,'2026-07-17 05:01:20',NULL,NULL,'2026-07-17 05:01:20','2026-07-17 05:01:20'),(12182,29,5,'toner','Imaging Kit',150000,150000,100.00,NULL,'2026-07-17 05:01:20',NULL,NULL,'2026-07-17 05:01:20','2026-07-17 05:01:20'),(12183,29,6,'toner','Magenta Cartridge',7216,8800,82.00,NULL,'2026-07-17 05:01:20',NULL,NULL,'2026-07-17 05:01:20','2026-07-17 05:01:20'),(12184,29,7,'toner','Maintenance Kit',150000,150000,100.00,NULL,'2026-07-17 05:01:20',NULL,NULL,'2026-07-17 05:01:20','2026-07-17 05:01:20'),(12185,29,8,'dechet_toner','Waste Toner Bottle',21600,30000,28.00,NULL,'2026-07-17 05:01:20',NULL,NULL,'2026-07-17 05:01:20','2026-07-17 05:01:20'),(12186,29,9,'toner','Yellow Cartridge',8800,8800,100.00,NULL,'2026-07-17 05:01:20',NULL,NULL,'2026-07-17 05:01:20','2026-07-17 05:01:20'),(12187,29,200,'compteur','Pages N&B',1801,NULL,NULL,'pages','2026-07-17 05:01:20',NULL,NULL,'2026-07-17 05:01:20','2026-07-17 05:01:20'),(12188,29,201,'compteur','Pages couleur',4148,NULL,NULL,'pages','2026-07-17 05:01:20',NULL,NULL,'2026-07-17 05:01:20','2026-07-17 05:01:20'),(12189,31,1,'toner','ADF Kit',108900,110000,99.00,NULL,'2026-07-17 05:01:21',NULL,NULL,'2026-07-17 05:01:21','2026-07-17 05:01:21'),(12190,31,2,'toner','Black Cartridge',2010,3000,67.00,NULL,'2026-07-17 05:01:21',NULL,NULL,'2026-07-17 05:01:21','2026-07-17 05:01:21'),(12191,31,3,'toner','Cyan Cartridge',1440,2000,72.00,NULL,'2026-07-17 05:01:21',NULL,NULL,'2026-07-17 05:01:21','2026-07-17 05:01:21'),(12192,31,4,'toner','Transfer Module',150000,150000,100.00,NULL,'2026-07-17 05:01:21',NULL,NULL,'2026-07-17 05:01:21','2026-07-17 05:01:21'),(12193,31,5,'toner','Imaging Kit',150000,150000,100.00,NULL,'2026-07-17 05:01:21',NULL,NULL,'2026-07-17 05:01:21','2026-07-17 05:01:21'),(12194,31,6,'toner','Magenta Cartridge',1520,2000,76.00,NULL,'2026-07-17 05:01:21',NULL,NULL,'2026-07-17 05:01:21','2026-07-17 05:01:21'),(12195,31,7,'toner','Maintenance Kit',150000,150000,100.00,NULL,'2026-07-17 05:01:21',NULL,NULL,'2026-07-17 05:01:21','2026-07-17 05:01:21'),(12196,31,8,'dechet_toner','Waste Toner Bottle',25500,30000,15.00,NULL,'2026-07-17 05:01:21',NULL,NULL,'2026-07-17 05:01:21','2026-07-17 05:01:21'),(12197,31,9,'toner','Yellow Cartridge',1300,2000,65.00,NULL,'2026-07-17 05:01:21',NULL,NULL,'2026-07-17 05:01:21','2026-07-17 05:01:21'),(12198,31,200,'compteur','Pages N&B',154,NULL,NULL,'pages','2026-07-17 05:01:21',NULL,NULL,'2026-07-17 05:01:21','2026-07-17 05:01:21'),(12199,31,201,'compteur','Pages couleur',477,NULL,NULL,'pages','2026-07-17 05:01:21',NULL,NULL,'2026-07-17 05:01:21','2026-07-17 05:01:21'),(12200,32,1,'toner','ADF Kit',106700,110000,97.00,NULL,'2026-07-17 05:01:22',NULL,NULL,'2026-07-17 05:01:22','2026-07-17 05:01:22'),(12201,32,2,'toner','Black Cartridge',13272,15800,84.00,NULL,'2026-07-17 05:01:22',NULL,NULL,'2026-07-17 05:01:22','2026-07-17 05:01:22'),(12202,32,3,'toner','Cyan Cartridge',7392,8800,84.00,NULL,'2026-07-17 05:01:22',NULL,NULL,'2026-07-17 05:01:22','2026-07-17 05:01:22'),(12203,32,4,'toner','Transfer Module',150000,150000,100.00,NULL,'2026-07-17 05:01:22',NULL,NULL,'2026-07-17 05:01:22','2026-07-17 05:01:22'),(12204,32,5,'toner','Imaging Kit',150000,150000,100.00,NULL,'2026-07-17 05:01:22',NULL,NULL,'2026-07-17 05:01:22','2026-07-17 05:01:22'),(12205,32,6,'toner','Magenta Cartridge',7304,8800,83.00,NULL,'2026-07-17 05:01:22',NULL,NULL,'2026-07-17 05:01:22','2026-07-17 05:01:22'),(12206,32,7,'toner','Maintenance Kit',150000,150000,100.00,NULL,'2026-07-17 05:01:22',NULL,NULL,'2026-07-17 05:01:22','2026-07-17 05:01:22'),(12207,32,8,'dechet_toner','Waste Toner Bottle',20400,30000,32.00,NULL,'2026-07-17 05:01:22',NULL,NULL,'2026-07-17 05:01:22','2026-07-17 05:01:22'),(12208,32,9,'toner','Yellow Cartridge',7920,8800,90.00,NULL,'2026-07-17 05:01:22',NULL,NULL,'2026-07-17 05:01:22','2026-07-17 05:01:22'),(12209,32,200,'compteur','Pages N&B',674,NULL,NULL,'pages','2026-07-17 05:01:22',NULL,NULL,'2026-07-17 05:01:22','2026-07-17 05:01:22'),(12210,32,201,'compteur','Pages couleur',4687,NULL,NULL,'pages','2026-07-17 05:01:22',NULL,NULL,'2026-07-17 05:01:22','2026-07-17 05:01:22'),(12211,33,1,'toner','ADF Kit',108900,110000,99.00,NULL,'2026-07-17 05:01:24',NULL,NULL,'2026-07-17 05:01:24','2026-07-17 05:01:24'),(12212,33,2,'toner','Black Cartridge',2340,3000,78.00,NULL,'2026-07-17 05:01:24',NULL,NULL,'2026-07-17 05:01:24','2026-07-17 05:01:24'),(12213,33,3,'toner','Cyan Cartridge',1500,2000,75.00,NULL,'2026-07-17 05:01:24',NULL,NULL,'2026-07-17 05:01:24','2026-07-17 05:01:24'),(12214,33,4,'toner','Transfer Module',150000,150000,100.00,NULL,'2026-07-17 05:01:24',NULL,NULL,'2026-07-17 05:01:24','2026-07-17 05:01:24'),(12215,33,5,'toner','Imaging Kit',150000,150000,100.00,NULL,'2026-07-17 05:01:24',NULL,NULL,'2026-07-17 05:01:24','2026-07-17 05:01:24'),(12216,33,6,'toner','Magenta Cartridge',1500,2000,75.00,NULL,'2026-07-17 05:01:24',NULL,NULL,'2026-07-17 05:01:24','2026-07-17 05:01:24'),(12217,33,7,'toner','Maintenance Kit',150000,150000,100.00,NULL,'2026-07-17 05:01:24',NULL,NULL,'2026-07-17 05:01:24','2026-07-17 05:01:24'),(12218,33,8,'dechet_toner','Waste Toner Bottle',26700,30000,11.00,NULL,'2026-07-17 05:01:25',NULL,NULL,'2026-07-17 05:01:25','2026-07-17 05:01:25'),(12219,33,9,'toner','Yellow Cartridge',1420,2000,71.00,NULL,'2026-07-17 05:01:25',NULL,NULL,'2026-07-17 05:01:25','2026-07-17 05:01:25'),(12220,33,200,'compteur','Pages N&B',63,NULL,NULL,'pages','2026-07-17 05:01:25',NULL,NULL,'2026-07-17 05:01:25','2026-07-17 05:01:25'),(12221,33,201,'compteur','Pages couleur',479,NULL,NULL,'pages','2026-07-17 05:01:25',NULL,NULL,'2026-07-17 05:01:25','2026-07-17 05:01:25'),(12222,40,1,'toner','ADF Kit',108900,110000,99.00,NULL,'2026-07-17 05:01:58',NULL,NULL,'2026-07-17 05:01:58','2026-07-17 05:01:58'),(12223,40,2,'toner','Black Cartridge',1800,3000,60.00,NULL,'2026-07-17 05:01:58',NULL,NULL,'2026-07-17 05:01:58','2026-07-17 05:01:58'),(12224,40,3,'toner','Cyan Cartridge',760,2000,38.00,NULL,'2026-07-17 05:01:58',NULL,NULL,'2026-07-17 05:01:58','2026-07-17 05:01:58'),(12225,40,4,'toner','Transfer Module',150000,150000,100.00,NULL,'2026-07-17 05:01:58',NULL,NULL,'2026-07-17 05:01:58','2026-07-17 05:01:58'),(12226,40,5,'toner','Imaging Kit',150000,150000,100.00,NULL,'2026-07-17 05:01:58',NULL,NULL,'2026-07-17 05:01:58','2026-07-17 05:01:58'),(12227,40,6,'toner','Magenta Cartridge',920,2000,46.00,NULL,'2026-07-17 05:01:58',NULL,NULL,'2026-07-17 05:01:58','2026-07-17 05:01:58'),(12228,40,7,'toner','Maintenance Kit',150000,150000,100.00,NULL,'2026-07-17 05:01:58',NULL,NULL,'2026-07-17 05:01:58','2026-07-17 05:01:58'),(12229,40,8,'dechet_toner','Waste Toner Bottle',24600,30000,18.00,NULL,'2026-07-17 05:01:58',NULL,NULL,'2026-07-17 05:01:58','2026-07-17 05:01:58'),(12230,40,9,'toner','Yellow Cartridge',800,2000,40.00,NULL,'2026-07-17 05:01:58',NULL,NULL,'2026-07-17 05:01:58','2026-07-17 05:01:58'),(12231,40,200,'compteur','Pages N&B',158,NULL,NULL,'pages','2026-07-17 05:01:58',NULL,NULL,'2026-07-17 05:01:58','2026-07-17 05:01:58'),(12232,40,201,'compteur','Pages couleur',1221,NULL,NULL,'pages','2026-07-17 05:01:58',NULL,NULL,'2026-07-17 05:01:59','2026-07-17 05:01:59'),(12233,41,1,'toner','HP 72 ( C9374A )',37,100,37.00,'ml','2026-07-17 05:01:59',NULL,NULL,'2026-07-17 05:01:59','2026-07-17 05:01:59'),(12234,41,2,'toner','HP 72 ( C9370A )',15,130,11.54,'ml','2026-07-17 05:01:59',NULL,NULL,'2026-07-17 05:01:59','2026-07-17 05:01:59'),(12235,41,3,'toner','HP 72 ( C9403A )',71,100,71.00,'ml','2026-07-17 05:01:59',NULL,NULL,'2026-07-17 05:01:59','2026-07-17 05:01:59'),(12236,41,4,'toner','HP 72 ( C9373A )',79,100,79.00,'ml','2026-07-17 05:01:59',NULL,NULL,'2026-07-17 05:01:59','2026-07-17 05:01:59'),(12237,41,5,'toner','HP 72 ( C9372A )',44,100,44.00,'ml','2026-07-17 05:01:59',NULL,NULL,'2026-07-17 05:01:59','2026-07-17 05:01:59'),(12238,41,6,'toner','HP 72 ( C9371A )',40,100,40.00,'ml','2026-07-17 05:01:59',NULL,NULL,'2026-07-17 05:01:59','2026-07-17 05:01:59'),(12239,41,200,'compteur','Pages N&B',1723,NULL,NULL,'pages','2026-07-17 05:01:59',NULL,NULL,'2026-07-17 05:01:59','2026-07-17 05:01:59'),(12240,41,201,'compteur','Pages couleur',2947,NULL,NULL,'pages','2026-07-17 05:01:59',NULL,NULL,'2026-07-17 05:01:59','2026-07-17 05:01:59'),(12241,41,999,'tete_impression','Tête d\'impression',50,100,50.00,'pourcent','2026-07-17 05:01:59',NULL,'{\"canal_1\": 309579, \"canal_2\": 300842, \"canal_3\": 520677, \"canal_4\": 489597, \"canal_5\": 558747, \"canal_6\": 337020}','2026-07-17 05:02:00','2026-07-17 05:02:00'); /*!40000 ALTER TABLE `snmp_releves` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sorties_manquantes` -- DROP TABLE IF EXISTS `sorties_manquantes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `sorties_manquantes` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `materiel_id` bigint unsigned NOT NULL, `fourniture_id` bigint unsigned NOT NULL, `snmp_releve_id` bigint unsigned NOT NULL, `date_releve` date NOT NULL, `resolue` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `sortie_manquante_unique` (`materiel_id`,`fourniture_id`,`snmp_releve_id`), KEY `sorties_manquantes_fourniture_id_foreign` (`fourniture_id`), KEY `sorties_manquantes_snmp_releve_id_foreign` (`snmp_releve_id`) ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sorties_manquantes` -- LOCK TABLES `sorties_manquantes` WRITE; /*!40000 ALTER TABLE `sorties_manquantes` DISABLE KEYS */; INSERT INTO `sorties_manquantes` VALUES (1,7,2,7457,'2026-06-24',0,'2026-06-24 07:00:02','2026-06-24 07:00:02'),(2,27,6,7566,'2026-06-24',1,'2026-06-24 07:00:02','2026-06-29 12:30:26'),(3,28,4,7571,'2026-06-24',0,'2026-06-24 07:00:02','2026-06-24 07:00:02'),(4,32,6,7610,'2026-06-24',1,'2026-06-24 07:00:02','2026-06-29 14:23:39'),(5,27,6,7831,'2026-06-26',1,'2026-06-26 08:14:25','2026-06-29 12:30:26'),(6,28,4,7836,'2026-06-26',0,'2026-06-26 08:14:25','2026-06-26 08:14:25'),(7,32,6,7875,'2026-06-26',1,'2026-06-26 08:14:25','2026-06-29 14:23:39'),(8,27,6,8095,'2026-06-29',1,'2026-06-29 08:39:27','2026-06-29 12:30:26'),(9,28,4,8100,'2026-06-29',0,'2026-06-29 08:39:27','2026-06-29 08:39:27'),(10,32,6,8139,'2026-06-29',1,'2026-06-29 08:39:27','2026-06-29 14:23:39'),(11,27,6,8359,'2026-06-29',1,'2026-06-29 10:33:54','2026-06-29 12:30:26'),(12,28,4,8364,'2026-06-29',0,'2026-06-29 10:33:54','2026-06-29 10:33:54'),(13,32,6,8403,'2026-06-29',1,'2026-06-29 10:33:54','2026-06-29 14:23:39'),(14,28,3,10688,'2026-07-07',0,'2026-07-07 14:12:06','2026-07-07 14:12:06'),(15,28,5,10692,'2026-07-07',0,'2026-07-07 14:12:06','2026-07-07 14:12:06'),(16,28,6,10695,'2026-07-07',0,'2026-07-07 14:12:06','2026-07-07 14:12:06'),(17,29,6,10706,'2026-07-07',0,'2026-07-07 14:12:06','2026-07-07 14:12:06'); /*!40000 ALTER TABLE `sorties_manquantes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sorties_stock` -- DROP TABLE IF EXISTS `sorties_stock`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `sorties_stock` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `fourniture_id` bigint unsigned NOT NULL, `materiel_id` bigint unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `entree_stock_id` bigint unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `sorties_stock_fourniture_id_foreign` (`fourniture_id`), KEY `sorties_stock_materiel_id_foreign` (`materiel_id`), KEY `sorties_stock_entree_stock_id_foreign` (`entree_stock_id`) ) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sorties_stock` -- LOCK TABLES `sorties_stock` WRITE; /*!40000 ALTER TABLE `sorties_stock` DISABLE KEYS */; INSERT INTO `sorties_stock` VALUES (1,1,14,'2026-06-18 22:00:00','2026-06-19 08:33:40',NULL),(2,6,32,'2026-06-25 22:00:00','2026-06-29 14:23:15',NULL),(3,4,28,'2026-06-21 22:00:00','2026-06-29 08:41:08',46),(4,1,2,'2026-06-26 10:00:00','2026-06-29 09:17:28',51),(5,1,19,'2026-06-25 22:00:00','2026-06-30 12:10:16',51),(7,1,17,'2026-06-26 10:00:00','2026-06-29 09:17:28',56),(8,2,3,'2026-06-26 10:00:00','2026-06-29 09:17:29',116),(10,2,6,'2026-06-26 10:00:00','2026-06-29 09:17:29',57),(11,2,7,'2026-06-26 10:00:00','2026-06-29 09:17:29',41),(12,3,27,'2026-06-26 10:00:00','2026-06-29 09:17:29',52),(13,3,32,'2026-06-26 10:00:00','2026-06-29 09:17:29',54),(14,3,29,'2026-06-26 10:00:00','2026-06-29 09:17:29',55),(15,13,3,'2026-06-26 10:00:00','2026-06-29 09:17:29',68),(16,13,6,'2026-06-26 10:00:00','2026-06-29 09:17:29',58),(17,4,26,'2026-06-26 10:00:00','2026-06-29 09:17:29',123),(18,4,26,'2026-06-26 10:00:00','2026-06-29 09:17:29',118),(19,4,29,'2026-06-26 10:00:00','2026-06-29 09:17:29',47),(20,4,27,'2026-06-26 10:00:00','2026-06-29 09:17:29',59),(21,15,3,'2026-06-26 10:00:00','2026-06-29 09:17:29',38),(22,5,26,'2026-06-26 10:00:00','2026-06-29 09:17:29',71),(23,5,32,'2026-06-26 10:00:00','2026-06-29 09:17:29',43),(24,5,27,'2026-06-26 10:00:00','2026-06-29 09:17:29',60),(25,14,3,'2026-06-26 10:00:00','2026-06-29 09:17:29',69),(27,6,35,'2026-06-26 10:00:00','2026-06-29 09:17:29',65),(28,6,27,'2026-06-26 10:00:00','2026-06-29 09:17:29',39),(29,6,29,'2026-06-26 10:00:00','2026-06-29 09:17:29',61),(30,3,26,'2026-06-25 22:00:00','2026-06-29 12:23:26',63),(31,6,26,'2026-06-25 22:00:00','2026-06-29 12:23:47',129),(32,3,28,'2026-06-29 22:00:00','2026-06-30 12:02:10',113),(33,5,28,'2026-06-29 22:00:00','2026-06-30 12:02:36',42),(34,6,28,'2026-06-29 22:00:00','2026-06-30 12:02:49',62),(35,1,8,'2026-06-29 22:00:00','2026-06-30 12:03:17',70),(36,1,14,'2026-06-26 10:00:00','2026-06-30 12:28:22',56),(37,2,1,'2026-06-26 10:00:00','2026-06-30 12:28:22',53),(38,3,NULL,'2026-06-30 10:00:00','2026-06-30 13:21:03',NULL),(39,5,NULL,'2026-06-30 10:00:00','2026-06-30 13:21:03',NULL); /*!40000 ALTER TABLE `sorties_stock` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'Test User','test@example.com','2026-06-17 12:14:56','$2y$12$XQSTqg3ms8KtzQmkCG042eR5X9s6W2YQAHdQPhyGW30Kbf31Fbn86','60pGIQKz3J','2026-06-17 12:14:57','2026-06-17 12:14:57'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping routines for database 'printmanager' -- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-07-17 9:52:36