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=72 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','sortie','2026-06-22 22:00:00','2026-07-30 09:08:27',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-07-20 14:32:36',NULL),(54,'50012989','commande','stock','2026-02-17 23:00:00','2026-06-26 11:43:06',NULL),(55,'1332000001','livraison','sortie','2026-02-16 23:00:00','2026-08-17 09:40:13',52),(56,'1333586086','livraison','sortie','2026-02-18 23:00:00','2026-07-20 14:32:36',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-30 09:21:51',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','sortie','2026-07-02 22:00:00','2026-07-30 09:19:51',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','sortie','2026-07-09 22:00:00','2026-08-05 11:43:11',65),(67,'50923744','commande','actif','2026-07-26 22:00:00','2026-07-28 07:42:07',NULL),(68,'1334438816','livraison','actif','2026-07-26 22:00:00','2026-07-30 09:11:06',67),(69,'1334504814','livraison','actif','2026-08-16 22:00:00','2026-08-17 07:07:30',NULL),(70,'51008789','commande','stock','2026-08-16 22:00:00','2026-08-19 13:32:59',NULL),(71,'1334518717','livraison','actif','2026-08-18 22:00:00','2026-08-19 13:32:59',70); /*!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;}',1787657186),('usersmanager-cache-kpax_unread_count','a:2:{s:5:\"count\";i:0;s:5:\"error\";N;}',1786645049); /*!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=InnoDB 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=149 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),(137,178,3),(138,178,6),(139,179,23),(140,180,3),(141,180,6),(142,181,23),(144,182,5),(143,182,9),(145,183,2),(146,183,10),(147,184,36),(148,185,36); /*!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=186 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'),(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'),(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'),(169,56,12,3,NULL,'2026-07-20 14:32:36','2026-07-20 14:32:36'),(170,56,1,3,NULL,'2026-07-20 14:32:36','2026-07-20 14:32:36'),(171,56,11,3,NULL,'2026-07-20 14:32:36','2026-07-20 14:32:36'),(172,56,10,3,NULL,'2026-07-20 14:32:37','2026-07-20 14:32:37'),(173,56,13,1,NULL,'2026-07-20 14:32:37','2026-07-20 14:32:37'),(174,56,2,1,NULL,'2026-07-20 14:32:37','2026-07-20 14:32:37'),(175,56,15,1,NULL,'2026-07-20 14:32:37','2026-07-20 14:32:37'),(176,56,14,1,NULL,'2026-07-20 14:32:37','2026-07-20 14:32:37'),(177,56,9,3,NULL,'2026-07-20 14:32:37','2026-07-20 14:32:37'),(178,67,9,2,NULL,'2026-07-28 07:42:08','2026-07-28 07:42:08'),(179,67,2,1,NULL,'2026-07-28 07:42:08','2026-07-28 07:42:08'),(180,68,9,2,NULL,'2026-07-30 09:11:06','2026-07-30 09:11:06'),(181,68,2,1,NULL,'2026-07-30 09:11:06','2026-07-30 09:11:06'),(182,63,1,2,NULL,'2026-07-30 09:21:52','2026-07-30 09:21:52'),(183,69,1,2,NULL,'2026-08-17 07:07:30','2026-08-17 07:07:30'),(184,70,3,1,NULL,'2026-08-17 08:26:53','2026-08-17 08:26:53'),(185,71,3,1,NULL,'2026-08-19 13:32:59','2026-08-19 13:32:59'); /*!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', `capacite` int unsigned DEFAULT NULL, `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,100,NULL,1,1,NULL,'2026-08-17 09:41:02'),(2,'Toner Black C450 série','TN626K','ACV1150',NULL,2,100,NULL,1,1,NULL,'2026-08-05 11:43:11'),(3,'Toner Black Lexmark CX53','9960YCLE75M2HK0','75M2HK0','734646741774',1,15800,'Toner Black Lexmark pour CX532',1,2,'2026-06-18 11:38:48','2026-08-19 13:32:59'),(4,'Toner Cyan Lexmark CX53','9960YCLE75M2HC0','75M2HC0','734646741750',2,8800,'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,8800,'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,8800,'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,30000,'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,NULL,'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,100,'Box de récupération du toner usagé',1,1,'2026-06-18 11:54:14','2026-08-21 07:39:22'),(10,'Toner Yellow C300 série','TN328Y','AAV8250',NULL,3,100,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,100,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,100,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,100,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,100,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,100,NULL,1,1,'2026-06-18 12:06:03','2026-06-29 09:17:29'),(17,'72 Black','C9403A',NULL,NULL,1,NULL,'72 BK (C9403A)',1,3,'2026-06-19 12:22:28','2026-07-01 14:58:49'),(18,'72 Cyan','C9371A',NULL,NULL,0,NULL,'72 C (C9371A)',1,3,'2026-06-19 12:22:58','2026-06-19 12:22:58'),(19,'72 Grey','C9374A',NULL,NULL,0,NULL,'72 G (C9374A)',1,3,'2026-06-19 12:23:29','2026-07-01 14:11:37'),(20,'72 Magenta','C9372A',NULL,NULL,0,NULL,'72 M (C9372A)',1,3,'2026-06-19 12:23:48','2026-07-01 14:11:46'),(21,'72 Photo','C9370A',NULL,NULL,1,NULL,'72 Ph (C9370A)',1,3,'2026-06-19 12:24:08','2026-07-01 14:58:49'),(22,'72 Yellow','C9373A',NULL,NULL,1,NULL,'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,NULL,'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,NULL,'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,NULL,'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,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,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,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,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,NULL,1,4,'2026-06-19 12:27:11','2026-07-02 06:26:35'),(31,'953XL Black','L0S70AE BGX',NULL,'725184104183',1,NULL,'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,NULL,'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,NULL,'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,NULL,'953XL Y (F6U18A)',1,3,'2026-07-03 08:33:11','2026-07-03 08:55:09'),(35,'973X Black','L0S07AE',NULL,'889296544692',3,NULL,'973X BK (L0S07AE)',1,3,'2026-07-03 08:36:50','2026-07-03 08:36:50'),(36,'973X Cyan','F6T81AE',NULL,'889296544661',2,NULL,'973X C (F6T81AE)',1,3,'2026-07-03 08:37:34','2026-07-03 08:37:34'),(37,'973X Magenta','F6T82AE',NULL,'889296544678',2,NULL,'973X M (F6T82AE)',1,3,'2026-07-03 08:38:18','2026-07-03 08:38:18'),(38,'973X Yellow','F6T83AE',NULL,'889296544685',2,NULL,'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,NULL,1,5,'2026-07-03 08:58:30','2026-07-03 08:58:30'),(40,'LC223 Cyan','LC223C',NULL,NULL,2,NULL,NULL,1,5,'2026-07-03 08:59:15','2026-07-03 08:59:15'),(41,'LC223 Magenta','LC223M',NULL,NULL,2,NULL,NULL,1,5,'2026-07-03 08:59:37','2026-07-03 08:59:37'),(42,'LC223 Yellow','LC223Y',NULL,NULL,2,NULL,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-08-25 04:00:04','1842980279','ADXG02A017000',1,2,NULL,'2026-08-25 04:00:04'),(2,'Copieur Finances',NULL,1,'192.168.1.100','Finances',NULL,'123456712345678',1,'2026-08-25 04:00:04','1842980394','ADXK021038508',1,1,NULL,'2026-08-25 04:00:04'),(3,'Copieur Urbanisme',NULL,1,'192.168.1.101','Urbanisme',NULL,'123456712345678',1,'2026-08-25 04:00:05','1842980407','ADXG02A015509',1,2,NULL,'2026-08-25 04:00:05'),(4,'Copieur Informatique',NULL,1,'192.168.1.102','DSI',NULL,'123456712345678',1,'2026-08-25 04:00:05','1842980372','ADXK021038503',1,1,NULL,'2026-08-25 04:00:05'),(5,'Copieur Cabinet Maire',NULL,1,'192.168.1.103','Cabinet du Maire',NULL,'123456712345678',1,'2026-08-25 04:00:05','1842980291','ADXK021038369',1,1,'2026-06-18 09:39:50','2026-08-25 04:00:05'),(6,'Copieur RH',NULL,1,'192.168.1.104','Ressources Humaines',NULL,'123456712345678',1,'2026-08-25 04:00:06','1842980462','ADXG02A015492',1,2,'2026-06-18 09:41:20','2026-08-25 04:00:06'),(7,'Copieur Jeunesse',NULL,1,'192.168.1.105','Pole enfance',NULL,'123456712345678',1,'2026-08-25 04:00:06','1842980377','ADXG02A015551',1,2,'2026-06-18 09:41:53','2026-08-25 04:00:06'),(8,'Copieur Patrimoine',NULL,1,'192.168.1.106','Culture & Patrimoine',NULL,'123456712345678',1,'2026-08-25 04:00:06','1842980391','ADXK021038545',1,1,'2026-06-18 09:42:36','2026-08-25 04:00:06'),(9,'Copieur Population',NULL,1,'192.168.1.107','Population',NULL,'123456712345678',1,'2026-08-25 04:00:07','1842980256','ADXK021038275',1,1,'2026-06-18 09:43:16','2026-08-25 04:00:07'),(10,'Copieur Marchés',NULL,1,'192.168.1.109','Marchés Publics',NULL,'123456712345678',1,'2026-08-25 04:00:07','1842980434','ADXK021038447',1,1,'2026-06-18 09:43:51','2026-08-25 04:00:07'),(11,'Copieur Juridique','C301i',1,'192.168.1.110','Juridique',NULL,'123456712345678',1,'2026-08-25 04:00:07','1842980342','ADXK021038563',1,1,'2026-06-18 09:44:19','2026-08-25 04:00:07'),(12,'Copieur SGR ERP',NULL,1,'192.168.1.111','SGR ERP',NULL,'123456712345678',1,'2026-08-25 04:00:08','1842980380','ADXK021038574',1,1,'2026-06-18 09:44:56','2026-08-25 04:00:08'),(13,'Copieur CTM',NULL,1,'192.168.19.116','CTM',NULL,'123456712345678',1,'2026-08-25 04:00:08','1842980389','ADXK021038599',1,1,'2026-06-18 09:45:31','2026-08-25 04:00:08'),(14,'Copieur PM',NULL,1,'192.168.200.102','PM',NULL,'123456712345678',1,'2026-08-25 04:00:09','1842980472','ADXK021038532',1,1,'2026-06-18 09:46:06','2026-08-25 04:00:09'),(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-08-25 04:00:09','1842980429','ADXK021038582',1,1,'2026-06-18 09:47:11','2026-08-25 04:00:09'),(17,'Copieur Blaquieres Info (élémentaire)',NULL,1,'192.168.12.136','Ecole Blaquières',NULL,'123456712345678',0,'2026-08-25 04:00:14','1842980317','ADXK021038547',1,1,'2026-06-18 09:47:48','2026-08-25 04:00:14'),(18,'Copieur Migranier Directrice Maternelle',NULL,1,'192.168.17.200','Ecole Migraniers',NULL,'123456712345678',1,'2026-08-25 10:01:50','1842980284','ADXK021038471',1,1,'2026-06-18 09:48:26','2026-08-25 10:01:50'),(19,'Copieur Migranier Info (primaire)',NULL,1,'192.168.17.199','Ecole Migraniers',NULL,'123456712345678',1,'2026-08-25 04:00:18','1842980410','ADXK021038601',1,1,'2026-06-18 09:49:05','2026-08-25 04:00:18'),(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',0,'2026-08-25 04:00:22','1842980306','ADXK021038597',1,1,'2026-06-18 09:50:17','2026-08-25 04:00:22'),(22,'Copieur Capitainerie B2',NULL,1,'192.168.22.158','Capitainerie B2',NULL,'123456712345678',1,'2026-08-25 04:00:23','1842980454','ADXK021038517',1,1,'2026-06-18 09:50:51','2026-08-25 04:00:23'),(23,'Copieur Bureau des GU',NULL,1,'192.168.28.157','Bureau des GU',NULL,'123456712345678',1,'2026-08-25 04:00:24','1842980271','ADXG02A015528',1,2,'2026-06-18 09:52:45','2026-08-25 04:00:24'),(24,'Copieur Capitainerie B4',NULL,1,'192.168.22.157','Capitainerie B4',NULL,'123456712345678',1,'2026-08-25 04:00:24','1842980451','ADXK021038433',1,1,'2026-06-18 09:53:24','2026-08-25 04:00:24'),(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-08-25 04:00:25','1826596067','7531526039Z8F',2,3,'2026-06-18 09:56:26','2026-08-25 04:00:25'),(27,'Lexmark Urbanisme',NULL,1,'192.168.1.116','Urbanisme',NULL,NULL,1,'2026-08-25 04:00:25','1826596068','7531526039ZD8',2,3,'2026-06-18 10:03:37','2026-08-25 04:00:25'),(28,'Lexmark Crèche Municipale',NULL,1,'192.168.1.117','Pole enfance',NULL,NULL,1,'2026-08-25 04:00:26','1826595807','753153303BWLF',2,3,'2026-06-18 10:04:21','2026-08-25 04:00:26'),(29,'Lexmark Finances',NULL,1,'192.168.1.118','Finances',NULL,NULL,1,'2026-08-25 04:00:27','1826595806','753153303BWF7',2,3,'2026-06-18 10:05:25','2026-08-25 04:00:27'),(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-08-25 04:00:27','1826595799','7531526039ZD4',2,3,'2026-06-18 10:07:02','2026-08-25 04:00:27'),(32,'Lexmark CTM','Centre Technique Municipal (E.Brazillier)',1,'192.168.19.80','CTM',NULL,NULL,1,'2026-08-25 04:00:28','1826595808','753153303BWL3',2,3,'2026-06-18 10:07:45','2026-08-25 04:00:28'),(33,'Lexmark Ancien CTM',NULL,1,'192.168.20.205','Ancien CTM',NULL,NULL,1,'2026-08-25 06:55:12','1826595802','7531521039CGW',2,3,'2026-06-18 10:08:28','2026-08-25 06:55:12'),(34,'Lexmark Migraniers Directrice Primaire',NULL,1,'192.168.17.197','Ecole Migraniers',NULL,NULL,0,'2026-08-25 04:00:35','1826596066','7531526039Z4C',2,3,'2026-06-18 10:09:31','2026-08-25 04:00:35'),(35,'Lexmark Migraniers Primaire',NULL,1,'192.168.17.198','Ecole Migraniers',NULL,NULL,0,'2026-08-25 04:00:39','1826595797','753153303BWL0',2,3,'2026-06-18 10:12:10','2026-08-25 04:00:39'),(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-08-25 04:00:40','1826595803','753153303BWKT',2,3,'2026-06-18 10:17:12','2026-08-25 04:00:40'),(41,'Traceur T795 CTM','Traceur HP DesignJet T795',1,'192.168.19.114','CTM',NULL,NULL,1,'2026-08-25 04:00:42','NPIA45D36B6767F',NULL,3,6,'2026-06-18 10:22:00','2026-08-25 04:00:42'),(42,'Traceur TM-350 Urbanisme',NULL,1,'192.168.1.115','Mairie',NULL,NULL,0,'2026-08-25 04:00:46',NULL,'BBAP04379',4,4,'2026-06-18 10:25:19','2026-08-25 04:00:46'),(43,'477dw Population','HP PageWide Pro 477dw MFP Population HP5BDE3E',1,'192.168.1.48','Population',NULL,NULL,1,'2026-08-25 10:06:10','HP5BDE3E','CN87KHX0RQ',3,8,'2026-07-02 10:25:16','2026-08-25 10:06:10'),(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=46 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),(44,'2026_07_10_112821_convert_tables_to_innodb',28),(45,'2026_07_30_100000_add_capacite_to_fournitures',28); /*!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','eyJ0eXAiOiJKV1QiLCJub25jZSI6InRqQjFoY3NjZzY5SktieEFNelF1MTBYZzlhMXFRUTNzN3lYaGtMZXZRckkiLCJhbGciOiJSUzI1NiIsIng1dCI6ImZFdHFyaEtUMWJYQUdhZlNkUW9OMXZYVFJwSSIsImtpZCI6ImZFdHFyaEtUMWJYQUdhZlNkUW9OMXZYVFJwSSJ9.eyJhdWQiOiJodHRwczovL2dyYXBoLm1pY3Jvc29mdC5jb20iLCJpc3MiOiJodHRwczovL3N0cy53aW5kb3dzLm5ldC8wZjE5OWY3Ny1lMjRkLTRkMTAtODgzNC1hZDIyMzhjMzdhMjUvIiwiaWF0IjoxNzg3NjMwMDI1LCJuYmYiOjE3ODc2MzAwMjUsImV4cCI6MTc4NzYzNDE3MiwiYWNjdCI6MCwiYWNyIjoiMSIsImFjcnMiOlsicDEiLCJwZmRyIl0sImFpbyI6IkFaUUFhLzhjQUFBQVAyM0hybERkU0JPOERDanZMSnMzb0JYNkdRSkxYbXl5MCtlMGpkYjgzWG5EUXB2WWh3dlZORnByall1MGxoV0dPYUluemdoTWxWalhzV0FZd1Y1TTdiK1NVMmZ6QWt4MkVHak5MVFVBamREbzJjTzh3b0hHN2UxUTllYS8xMWJFeHAzVXd1d1FQWDhzbzNjR1YzUDdjOXJDdkRvTnh1YkthWk4zcWpLUDFNb0lNbkZQZW92aEcxZE4vY0RhUCtlaCIsImFtciI6WyJwd2QiLCJtZmEiXSwiYXBwX2Rpc3BsYXluYW1lIjoiTEFSQVZFTC1QSFAiLCJhcHBpZCI6Ijg1MDQxMTAyLTk4NzktNDNiYi05ODI5LTUzZjU5MWZkYzk2YiIsImFwcGlkYWNyIjoiMSIsImZhbWlseV9uYW1lIjoiUEVMTEVHUklOTyIsImdpdmVuX25hbWUiOiJEYXZpZCIsImlkdHlwIjoidXNlciIsImlwYWRkciI6IjE5NS4xMzUuNDEuMTkzIiwibmFtZSI6IlBFTExFR1JJTk8gRGF2aWQgLSBEU0kgQWRqb2ludCIsIm9pZCI6IjIxMTg0NWQ5LThlOTgtNDI5MC1iZTM4LTUxMmQwNzVhODQ2YyIsInBsYXRmIjoiMyIsInB1aWQiOiIxMDAzMjAwNDFGNTFCMjNFIiwicmgiOiIxLkFWOEFkNThaRDAzaUVFMklOSzBpT01ONkpRTUFBQUFBQUFBQXdBQUFBQUFBQUFBQUFQTmZBQS4iLCJzY3AiOiJNYWlsLlJlYWQgTWFpbC5SZWFkV3JpdGUgTWFpbC5TZW5kIFVzZXIuUmVhZCBwcm9maWxlIG9wZW5pZCBlbWFpbCIsInNpZCI6IjAwNWYxN2RhLWNhNmUtZjIwZS1jYjA3LTZiZWRmYzFlYjYzZiIsInN1YiI6IlFOVVlIdU12WGE4UVllR0ZZRXE0ZFlZVDRDY3JHUU1iazRzYVNwR3JXaVEiLCJ0ZW5hbnRfcmVnaW9uX3Njb3BlIjoiRVUiLCJ0aWQiOiIwZjE5OWY3Ny1lMjRkLTRkMTAtODgzNC1hZDIyMzhjMzdhMjUiLCJ1bmlxdWVfbmFtZSI6ImQucGVsbGVncmlub0BtYWlyaWUtZ3JpbWF1ZC5mciIsInVwbiI6ImQucGVsbGVncmlub0BtYWlyaWUtZ3JpbWF1ZC5mciIsInV0aSI6IlFlNnNtSUFkcjBHb1BLUHBVWlV4QVEiLCJ2ZXIiOiIxLjAiLCJ3aWRzIjpbImI3OWZiZjRkLTNlZjktNDY4OS04MTQzLTc2YjE5NGU4NTUwOSJdLCJ4bXNfYWNkIjoxNzgxODc4NDc5LCJ4bXNfYWN0X2ZjdCI6IjMgOSIsInhtc19mdGQiOiJrMjRTVkQyZlM4QnFBMGtLMjRiOWJyY1ZnUDRuRkJHejc2OWhaQzZtQzBVQlpuSmhibU5sWXkxa2MyMXoiLCJ4bXNfaWRyZWwiOiIxMCAxIiwieG1zX3BmdGV4cCI6MTc4NzcyMDU3MiwieG1zX3N0Ijp7InN1YiI6IjVQY0NsdE1mRUdDOGZmNDdVTkRIMDFvTkk0VkRsNk5aUDFsQjRGOXVTLXcifSwieG1zX3N1Yl9mY3QiOiIzIDYiLCJ4bXNfdGNkdCI6MTU5Mzc3OTI2MiwieG1zX3RkYnIiOiJFVSIsInhtc190bnRfZmN0IjoiMyA2In0.ZCqcigVOx9f5474gJgjFzMYfBMbeTBS9q6rvIqureTozRSv6El_NmS9f7qhhIJ8-Ho7q2qW82sgzOiNskdKLJyX7jvt1PHxU7GpW9Z2BmNbJ9X5xfbyR_sgZ_KJ586jeI9AC4BJxh2khbYOsvj4Lp_Ro2q48cCIg4gIK4y_ueIhN_9r7G6m3ohzTJSLpqA4WwBxImEBqcFaQSnJDwh-QcrmINmML3yuObsGUSalDc3EcilD0Fcvld7zFCQ04NiTdIGsFfmAAY9lKKa2eHqV8gCuh-rG60WK6D2LtALWQsytsgJZoV0pp9eXf7M82oDkK_ZWHJQg1175DJRxxB1UtFg','1.AV8Ad58ZD03iEE2INK0iOMN6JQIRBIV5mLtDmClT9ZH9yWsAAPNfAA.BQABAwEAAAADAOz_BQD0_0V2b1N0c0FydGlmYWN0cwIAAAAAAMhcK915j8DpGshFp2YIQyoIGcNo7I6ixqpVubNoX_xfhkxGdPQ5jVsU3OrxpV8RZjyZdDNZTXeikVzq2g1kzWfqKmwOHdc2Jl0-cuFm7j9EX8cgE3zedM8tJ3MJvHt1qgzn2PMy0ORYS1sZUjFpOWjZj5PespytFha-ESF80LQtQLyLFn-RC_Seuq_2jfMYtIfRocWMyxpZE262_mv_VQy6P1CH-KQgsZuNWcCfKrrb7PJHCixuvfZG6tzzUYBevyT7BovNNkAd0sWE8oS0XZBGi5dlzgEJYFHsRrPG9siabGLGqT5WyoxaPXa3YP3SH0SU5uA2OVoWlLLoeXdma-fRggjV1q1O0H8QTT7osTqxZzzP34XO8p3p1Vs3M4bGtkBuXCGd55IDsED8oZXfp_2IBt9SKYlEfuwv60N-wY_Rq9_HNg8swTdbe71oT7a8CVYBdXkJNZGiHwEE8pwu61OSdrvSf1xmKZt0XPowleuifmQEzNaTtl5V1ucnWoCeMiA5UDTWOG5tSscRehnPMOLlsgNkjM-wcMolqzYoDHwRh3fgdls-TtA-_AmRkXbB4ERfqI1i8PL3miwqfoMe8HroikNdx5cMr59J_jJOAKrZ4wvfN8lfkQI9iPe-OGEZ96RVICn-kz9gVcScubAqZiibUrs-R99EDwvL3aICcQWyIWqSU5VbTxWArD2hRzl-OuPliAFU3iFzTnjGwx36grbmMeVnTN886ksCchHij_krwDdVnLB3Mbf4IbZfF6SGmVyVZFEvXd_zcl5M6Mro4k3kWzq9ksoDJ3zgfr2e2JQsFLKLOm85sBhTzdIaAdoO4Qu8isOTICvn71q3cxTYe2rIuaEcWdmQFkzz8t5S4YeRYWRkvIGOVfCTwZLm8ePYkrcMyfe4qWGNiJDAwb2NiNx_Oprgh4Lwa_X94l3Xp0RRk3NCDHDS6Zke267kXqjT469f1--pIWgTvSjfIL4PicARqrtDXNaXwq5UCKQ0NVxtXc_sYT2qcTN1Fjmy5j99ddtGQsQU28M6-4nHdXd0r3FOyUefp06dmrXTH9AQ_CG1j6lru-ETzzTcw3RVIzJD7l8Zq6ZqAsjREQ0kgfJMrMgrNAk14_MuFuFD_4JwbF3bp12LXSmCE4PV9RYhFirWcVFQgRT97u9cuPdZLj8Wwt8W3vZa4g1olvZw5lCPWVPRPjuD1bDUHMf_mAo8038j6MxgwyN0wlaSdK5yI9Jk7lUbWP_7Rr7Ih9mZpcYN5JICl9bOfOdpb7rnMdt7zGgEJEpaYY8hYkKNCJ_UIUMA4uRasf_MBBF5w7OL6u1u0Cv27Xa4QQt-eS4wGAZH3NevZmHNlfrRrYK0UYx0IdAoxz1jQ12zF8948WkbJpbroCyH3d4zG-YIOQM2cu91KdTFiOy5Vo5VP_n6O6TvHv9SJSA65Z4','2026-08-25 05:04:56','2026-06-23 10:43:17','2026-08-25 04:00:50'); /*!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 ('YYQIHuPpSOcFa43kDfx3JErRldTKtdA60uhUOgZl',NULL,'192.168.1.2','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJyQXNNUmVmZUtoWU1VWUgyMGt5YlhQMUoyTUVRZWVTWFlOczJ3cXJDIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzE5Mi4xNjguMS4yOjgwODhcL1ByaW50TWFuYWdlclwvcHVibGljXC9kYXRhYmFzZVwvYmFja3VwIiwicm91dGUiOiJkYXRhYmFzZS5iYWNrdXAifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119LCJ1cmwiOnsiaW50ZW5kZWQiOiJodHRwOlwvXC8xOTIuMTY4LjEuMjo4MDg4XC9Vc2Vyc01hbmFnZXJcL3B1YmxpY1wvYWRtaW5cL3Blcm1pc3Npb25zIn19',1787656934); /*!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=20630 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 (20290,34,1,'toner','ADF Kit',108900,110000,99.00,NULL,'2026-08-24 04:00:37',NULL,NULL,'2026-08-24 04:00:37','2026-08-24 04:00:37'),(20291,34,2,'toner','Black Cartridge',840,3000,28.00,NULL,'2026-08-24 04:00:37',NULL,NULL,'2026-08-24 04:00:37','2026-08-24 04:00:37'),(20292,34,3,'toner','Cyan Cartridge',1080,2000,54.00,NULL,'2026-08-24 04:00:37',NULL,NULL,'2026-08-24 04:00:37','2026-08-24 04:00:37'),(20293,34,4,'toner','Transfer Module',150000,150000,100.00,NULL,'2026-08-24 04:00:37',NULL,NULL,'2026-08-24 04:00:37','2026-08-24 04:00:37'),(20294,34,5,'toner','Imaging Kit',150000,150000,100.00,NULL,'2026-08-24 04:00:37',NULL,NULL,'2026-08-24 04:00:37','2026-08-24 04:00:37'),(20295,34,6,'toner','Magenta Cartridge',820,2000,41.00,NULL,'2026-08-24 04:00:37',NULL,NULL,'2026-08-24 04:00:37','2026-08-24 04:00:37'),(20296,34,7,'toner','Maintenance Kit',150000,150000,100.00,NULL,'2026-08-24 04:00:37',NULL,NULL,'2026-08-24 04:00:37','2026-08-24 04:00:37'),(20297,34,8,'dechet_toner','Waste Toner Bottle',25500,30000,15.00,NULL,'2026-08-24 04:00:37',NULL,NULL,'2026-08-24 04:00:37','2026-08-24 04:00:37'),(20298,34,9,'toner','Yellow Cartridge',520,2000,26.00,NULL,'2026-08-24 04:00:37',NULL,NULL,'2026-08-24 04:00:37','2026-08-24 04:00:37'),(20299,34,200,'compteur','Pages N&B',619,NULL,NULL,'pages','2026-08-24 04:00:37',NULL,NULL,'2026-08-24 04:00:38','2026-08-24 04:00:38'),(20300,34,201,'compteur','Pages couleur',1746,NULL,NULL,'pages','2026-08-24 04:00:37',NULL,NULL,'2026-08-24 04:00:38','2026-08-24 04:00:38'),(20325,1,1,'toner','Toner (Cyan)',33,100,33.00,NULL,'2026-08-25 04:00:04',NULL,NULL,'2026-08-25 04:00:04','2026-08-25 04:00:04'),(20326,1,2,'toner','Toner (Magenta)',37,100,37.00,NULL,'2026-08-25 04:00:04',NULL,NULL,'2026-08-25 04:00:04','2026-08-25 04:00:04'),(20327,1,3,'toner','Toner (Yellow)',39,100,39.00,NULL,'2026-08-25 04:00:04',NULL,NULL,'2026-08-25 04:00:04','2026-08-25 04:00:04'),(20328,1,4,'toner','Toner (Black)',57,100,57.00,NULL,'2026-08-25 04:00:04',NULL,NULL,'2026-08-25 04:00:04','2026-08-25 04:00:04'),(20329,1,18,'toner','Staple Cartridge',1,NULL,NULL,NULL,'2026-08-25 04:00:04',NULL,NULL,'2026-08-25 04:00:04','2026-08-25 04:00:04'),(20330,1,200,'compteur','Pages N&B',16688,NULL,NULL,'pages','2026-08-25 04:00:04',NULL,NULL,'2026-08-25 04:00:04','2026-08-25 04:00:04'),(20331,1,201,'compteur','Pages couleur',26773,NULL,NULL,'pages','2026-08-25 04:00:04',NULL,NULL,'2026-08-25 04:00:04','2026-08-25 04:00:04'),(20332,1,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-08-25 04:00:04',NULL,NULL,'2026-08-25 04:00:04','2026-08-25 04:00:04'),(20333,2,1,'toner','Toner (Cyan)',47,100,47.00,NULL,'2026-08-25 04:00:04',NULL,NULL,'2026-08-25 04:00:04','2026-08-25 04:00:04'),(20334,2,2,'toner','Toner (Magenta)',61,100,61.00,NULL,'2026-08-25 04:00:04',NULL,NULL,'2026-08-25 04:00:04','2026-08-25 04:00:04'),(20335,2,3,'toner','Toner (Yellow)',47,100,47.00,NULL,'2026-08-25 04:00:04',NULL,NULL,'2026-08-25 04:00:04','2026-08-25 04:00:04'),(20336,2,4,'toner','Toner (Black)',6,100,6.00,NULL,'2026-08-25 04:00:04',NULL,NULL,'2026-08-25 04:00:04','2026-08-25 04:00:04'),(20337,2,200,'compteur','Pages N&B',33020,NULL,NULL,'pages','2026-08-25 04:00:04',NULL,NULL,'2026-08-25 04:00:04','2026-08-25 04:00:04'),(20338,2,201,'compteur','Pages couleur',25566,NULL,NULL,'pages','2026-08-25 04:00:04',NULL,NULL,'2026-08-25 04:00:04','2026-08-25 04:00:04'),(20339,2,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-08-25 04:00:04',NULL,NULL,'2026-08-25 04:00:04','2026-08-25 04:00:04'),(20340,3,1,'toner','Toner (Cyan)',40,100,40.00,NULL,'2026-08-25 04:00:04',NULL,NULL,'2026-08-25 04:00:04','2026-08-25 04:00:04'),(20341,3,2,'toner','Toner (Magenta)',56,100,56.00,NULL,'2026-08-25 04:00:04',NULL,NULL,'2026-08-25 04:00:04','2026-08-25 04:00:04'),(20342,3,3,'toner','Toner (Yellow)',34,100,34.00,NULL,'2026-08-25 04:00:04',NULL,NULL,'2026-08-25 04:00:04','2026-08-25 04:00:04'),(20343,3,4,'toner','Toner (Black)',73,100,73.00,NULL,'2026-08-25 04:00:04',NULL,NULL,'2026-08-25 04:00:04','2026-08-25 04:00:04'),(20344,3,18,'toner','Staple Cartridge',1,NULL,NULL,NULL,'2026-08-25 04:00:05',NULL,NULL,'2026-08-25 04:00:05','2026-08-25 04:00:05'),(20345,3,200,'compteur','Pages N&B',12853,NULL,NULL,'pages','2026-08-25 04:00:05',NULL,NULL,'2026-08-25 04:00:05','2026-08-25 04:00:05'),(20346,3,201,'compteur','Pages couleur',55988,NULL,NULL,'pages','2026-08-25 04:00:05',NULL,NULL,'2026-08-25 04:00:05','2026-08-25 04:00:05'),(20347,3,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-08-25 04:00:05',NULL,NULL,'2026-08-25 04:00:05','2026-08-25 04:00:05'),(20348,4,1,'toner','Toner (Cyan)',91,100,91.00,NULL,'2026-08-25 04:00:05',NULL,NULL,'2026-08-25 04:00:05','2026-08-25 04:00:05'),(20349,4,2,'toner','Toner (Magenta)',92,100,92.00,NULL,'2026-08-25 04:00:05',NULL,NULL,'2026-08-25 04:00:05','2026-08-25 04:00:05'),(20350,4,3,'toner','Toner (Yellow)',90,100,90.00,NULL,'2026-08-25 04:00:05',NULL,NULL,'2026-08-25 04:00:05','2026-08-25 04:00:05'),(20351,4,4,'toner','Toner (Black)',82,100,82.00,NULL,'2026-08-25 04:00:05',NULL,NULL,'2026-08-25 04:00:05','2026-08-25 04:00:05'),(20352,4,200,'compteur','Pages N&B',478,NULL,NULL,'pages','2026-08-25 04:00:05',NULL,NULL,'2026-08-25 04:00:05','2026-08-25 04:00:05'),(20353,4,201,'compteur','Pages couleur',1644,NULL,NULL,'pages','2026-08-25 04:00:05',NULL,NULL,'2026-08-25 04:00:05','2026-08-25 04:00:05'),(20354,4,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-08-25 04:00:05',NULL,NULL,'2026-08-25 04:00:05','2026-08-25 04:00:05'),(20355,5,1,'toner','Toner (Cyan)',40,100,40.00,NULL,'2026-08-25 04:00:05',NULL,NULL,'2026-08-25 04:00:05','2026-08-25 04:00:05'),(20356,5,2,'toner','Toner (Magenta)',60,100,60.00,NULL,'2026-08-25 04:00:05',NULL,NULL,'2026-08-25 04:00:05','2026-08-25 04:00:05'),(20357,5,3,'toner','Toner (Yellow)',49,100,49.00,NULL,'2026-08-25 04:00:05',NULL,NULL,'2026-08-25 04:00:05','2026-08-25 04:00:05'),(20358,5,4,'toner','Toner (Black)',3,100,3.00,NULL,'2026-08-25 04:00:05',NULL,NULL,'2026-08-25 04:00:05','2026-08-25 04:00:05'),(20359,5,200,'compteur','Pages N&B',6342,NULL,NULL,'pages','2026-08-25 04:00:05',NULL,NULL,'2026-08-25 04:00:05','2026-08-25 04:00:05'),(20360,5,201,'compteur','Pages couleur',21123,NULL,NULL,'pages','2026-08-25 04:00:05',NULL,NULL,'2026-08-25 04:00:05','2026-08-25 04:00:05'),(20361,5,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-08-25 04:00:05',NULL,NULL,'2026-08-25 04:00:05','2026-08-25 04:00:05'),(20362,6,1,'toner','Toner (Cyan)',32,100,32.00,NULL,'2026-08-25 04:00:05',NULL,NULL,'2026-08-25 04:00:05','2026-08-25 04:00:05'),(20363,6,2,'toner','Toner (Magenta)',29,100,29.00,NULL,'2026-08-25 04:00:05',NULL,NULL,'2026-08-25 04:00:05','2026-08-25 04:00:05'),(20364,6,3,'toner','Toner (Yellow)',26,100,26.00,NULL,'2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:06','2026-08-25 04:00:06'),(20365,6,4,'toner','Toner (Black)',46,100,46.00,NULL,'2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:06','2026-08-25 04:00:06'),(20366,6,18,'toner','Staple Cartridge',1,NULL,NULL,NULL,'2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:06','2026-08-25 04:00:06'),(20367,6,200,'compteur','Pages N&B',14040,NULL,NULL,'pages','2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:06','2026-08-25 04:00:06'),(20368,6,201,'compteur','Pages couleur',31022,NULL,NULL,'pages','2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:06','2026-08-25 04:00:06'),(20369,6,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:06','2026-08-25 04:00:06'),(20370,7,1,'toner','Toner (Cyan)',40,100,40.00,NULL,'2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:06','2026-08-25 04:00:06'),(20371,7,2,'toner','Toner (Magenta)',49,100,49.00,NULL,'2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:06','2026-08-25 04:00:06'),(20372,7,3,'toner','Toner (Yellow)',40,100,40.00,NULL,'2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:06','2026-08-25 04:00:06'),(20373,7,4,'toner','Toner (Black)',73,100,73.00,NULL,'2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:06','2026-08-25 04:00:06'),(20374,7,18,'toner','Staple Cartridge',1,NULL,NULL,NULL,'2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:06','2026-08-25 04:00:06'),(20375,7,200,'compteur','Pages N&B',17013,NULL,NULL,'pages','2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:06','2026-08-25 04:00:06'),(20376,7,201,'compteur','Pages couleur',19115,NULL,NULL,'pages','2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:06','2026-08-25 04:00:06'),(20377,7,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:06','2026-08-25 04:00:06'),(20378,8,1,'toner','Toner (Cyan)',19,100,19.00,NULL,'2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:06','2026-08-25 04:00:06'),(20379,8,2,'toner','Toner (Magenta)',25,100,25.00,NULL,'2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:06','2026-08-25 04:00:06'),(20380,8,3,'toner','Toner (Yellow)',13,100,13.00,NULL,'2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:06','2026-08-25 04:00:06'),(20381,8,4,'toner','Toner (Black)',68,100,68.00,NULL,'2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:06','2026-08-25 04:00:06'),(20382,8,200,'compteur','Pages N&B',3934,NULL,NULL,'pages','2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:06','2026-08-25 04:00:06'),(20383,8,201,'compteur','Pages couleur',16722,NULL,NULL,'pages','2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:06','2026-08-25 04:00:06'),(20384,8,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:06','2026-08-25 04:00:06'),(20385,9,1,'toner','Toner (Cyan)',65,100,65.00,NULL,'2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:06','2026-08-25 04:00:06'),(20386,9,2,'toner','Toner (Magenta)',72,100,72.00,NULL,'2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:06','2026-08-25 04:00:06'),(20387,9,3,'toner','Toner (Yellow)',65,100,65.00,NULL,'2026-08-25 04:00:06',NULL,NULL,'2026-08-25 04:00:07','2026-08-25 04:00:07'),(20388,9,4,'toner','Toner (Black)',3,100,3.00,NULL,'2026-08-25 04:00:07',NULL,NULL,'2026-08-25 04:00:07','2026-08-25 04:00:07'),(20389,9,200,'compteur','Pages N&B',14940,NULL,NULL,'pages','2026-08-25 04:00:07',NULL,NULL,'2026-08-25 04:00:07','2026-08-25 04:00:07'),(20390,9,201,'compteur','Pages couleur',14329,NULL,NULL,'pages','2026-08-25 04:00:07',NULL,NULL,'2026-08-25 04:00:07','2026-08-25 04:00:07'),(20391,9,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-08-25 04:00:07',NULL,NULL,'2026-08-25 04:00:07','2026-08-25 04:00:07'),(20392,10,1,'toner','Toner (Cyan)',88,100,88.00,NULL,'2026-08-25 04:00:07',NULL,NULL,'2026-08-25 04:00:07','2026-08-25 04:00:07'),(20393,10,2,'toner','Toner (Magenta)',91,100,91.00,NULL,'2026-08-25 04:00:07',NULL,NULL,'2026-08-25 04:00:07','2026-08-25 04:00:07'),(20394,10,3,'toner','Toner (Yellow)',87,100,87.00,NULL,'2026-08-25 04:00:07',NULL,NULL,'2026-08-25 04:00:07','2026-08-25 04:00:07'),(20395,10,4,'toner','Toner (Black)',3,100,3.00,NULL,'2026-08-25 04:00:07',NULL,NULL,'2026-08-25 04:00:07','2026-08-25 04:00:07'),(20396,10,200,'compteur','Pages N&B',16908,NULL,NULL,'pages','2026-08-25 04:00:07',NULL,NULL,'2026-08-25 04:00:07','2026-08-25 04:00:07'),(20397,10,201,'compteur','Pages couleur',5402,NULL,NULL,'pages','2026-08-25 04:00:07',NULL,NULL,'2026-08-25 04:00:07','2026-08-25 04:00:07'),(20398,10,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-08-25 04:00:07',NULL,NULL,'2026-08-25 04:00:07','2026-08-25 04:00:07'),(20399,11,1,'toner','Toner (Cyan)',89,100,89.00,NULL,'2026-08-25 04:00:07',NULL,NULL,'2026-08-25 04:00:07','2026-08-25 04:00:07'),(20400,11,2,'toner','Toner (Magenta)',91,100,91.00,NULL,'2026-08-25 04:00:07',NULL,NULL,'2026-08-25 04:00:07','2026-08-25 04:00:07'),(20401,11,3,'toner','Toner (Yellow)',88,100,88.00,NULL,'2026-08-25 04:00:07',NULL,NULL,'2026-08-25 04:00:07','2026-08-25 04:00:07'),(20402,11,4,'toner','Toner (Black)',68,100,68.00,NULL,'2026-08-25 04:00:07',NULL,NULL,'2026-08-25 04:00:07','2026-08-25 04:00:07'),(20403,11,200,'compteur','Pages N&B',3984,NULL,NULL,'pages','2026-08-25 04:00:07',NULL,NULL,'2026-08-25 04:00:07','2026-08-25 04:00:07'),(20404,11,201,'compteur','Pages couleur',4207,NULL,NULL,'pages','2026-08-25 04:00:07',NULL,NULL,'2026-08-25 04:00:07','2026-08-25 04:00:07'),(20405,11,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-08-25 04:00:07',NULL,NULL,'2026-08-25 04:00:07','2026-08-25 04:00:07'),(20406,12,1,'toner','Toner (Cyan)',69,100,69.00,NULL,'2026-08-25 04:00:08',NULL,NULL,'2026-08-25 04:00:08','2026-08-25 04:00:08'),(20407,12,2,'toner','Toner (Magenta)',72,100,72.00,NULL,'2026-08-25 04:00:08',NULL,NULL,'2026-08-25 04:00:08','2026-08-25 04:00:08'),(20408,12,3,'toner','Toner (Yellow)',65,100,65.00,NULL,'2026-08-25 04:00:08',NULL,NULL,'2026-08-25 04:00:08','2026-08-25 04:00:08'),(20409,12,4,'toner','Toner (Black)',37,100,37.00,NULL,'2026-08-25 04:00:08',NULL,NULL,'2026-08-25 04:00:08','2026-08-25 04:00:08'),(20410,12,200,'compteur','Pages N&B',3319,NULL,NULL,'pages','2026-08-25 04:00:08',NULL,NULL,'2026-08-25 04:00:08','2026-08-25 04:00:08'),(20411,12,201,'compteur','Pages couleur',13181,NULL,NULL,'pages','2026-08-25 04:00:08',NULL,NULL,'2026-08-25 04:00:08','2026-08-25 04:00:08'),(20412,12,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-08-25 04:00:08',NULL,NULL,'2026-08-25 04:00:08','2026-08-25 04:00:08'),(20413,13,1,'toner','Toner (Cyan)',64,100,64.00,NULL,'2026-08-25 04:00:08',NULL,NULL,'2026-08-25 04:00:08','2026-08-25 04:00:08'),(20414,13,2,'toner','Toner (Magenta)',72,100,72.00,NULL,'2026-08-25 04:00:08',NULL,NULL,'2026-08-25 04:00:08','2026-08-25 04:00:08'),(20415,13,3,'toner','Toner (Yellow)',61,100,61.00,NULL,'2026-08-25 04:00:08',NULL,NULL,'2026-08-25 04:00:08','2026-08-25 04:00:08'),(20416,13,4,'toner','Toner (Black)',23,100,23.00,NULL,'2026-08-25 04:00:08',NULL,NULL,'2026-08-25 04:00:08','2026-08-25 04:00:08'),(20417,13,200,'compteur','Pages N&B',4839,NULL,NULL,'pages','2026-08-25 04:00:08',NULL,NULL,'2026-08-25 04:00:08','2026-08-25 04:00:08'),(20418,13,201,'compteur','Pages couleur',15400,NULL,NULL,'pages','2026-08-25 04:00:08',NULL,NULL,'2026-08-25 04:00:08','2026-08-25 04:00:08'),(20419,13,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-08-25 04:00:08',NULL,NULL,'2026-08-25 04:00:08','2026-08-25 04:00:08'),(20420,14,1,'toner','Toner (Cyan)',31,100,31.00,NULL,'2026-08-25 04:00:08',NULL,NULL,'2026-08-25 04:00:08','2026-08-25 04:00:08'),(20421,14,2,'toner','Toner (Magenta)',42,100,42.00,NULL,'2026-08-25 04:00:09',NULL,NULL,'2026-08-25 04:00:09','2026-08-25 04:00:09'),(20422,14,3,'toner','Toner (Yellow)',25,100,25.00,NULL,'2026-08-25 04:00:09',NULL,NULL,'2026-08-25 04:00:09','2026-08-25 04:00:09'),(20423,14,4,'toner','Toner (Black)',60,100,60.00,NULL,'2026-08-25 04:00:09',NULL,NULL,'2026-08-25 04:00:09','2026-08-25 04:00:09'),(20424,14,200,'compteur','Pages N&B',7133,NULL,NULL,'pages','2026-08-25 04:00:09',NULL,NULL,'2026-08-25 04:00:09','2026-08-25 04:00:09'),(20425,14,201,'compteur','Pages couleur',32413,NULL,NULL,'pages','2026-08-25 04:00:09',NULL,NULL,'2026-08-25 04:00:09','2026-08-25 04:00:09'),(20426,14,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-08-25 04:00:09',NULL,NULL,'2026-08-25 04:00:09','2026-08-25 04:00:09'),(20427,16,1,'toner','Toner (Cyan)',81,100,81.00,NULL,'2026-08-25 04:00:09',NULL,NULL,'2026-08-25 04:00:09','2026-08-25 04:00:09'),(20428,16,2,'toner','Toner (Magenta)',83,100,83.00,NULL,'2026-08-25 04:00:09',NULL,NULL,'2026-08-25 04:00:09','2026-08-25 04:00:09'),(20429,16,3,'toner','Toner (Yellow)',77,100,77.00,NULL,'2026-08-25 04:00:09',NULL,NULL,'2026-08-25 04:00:09','2026-08-25 04:00:09'),(20430,16,4,'toner','Toner (Black)',48,100,48.00,NULL,'2026-08-25 04:00:09',NULL,NULL,'2026-08-25 04:00:09','2026-08-25 04:00:09'),(20431,16,200,'compteur','Pages N&B',8323,NULL,NULL,'pages','2026-08-25 04:00:09',NULL,NULL,'2026-08-25 04:00:09','2026-08-25 04:00:09'),(20432,16,201,'compteur','Pages couleur',6946,NULL,NULL,'pages','2026-08-25 04:00:09',NULL,NULL,'2026-08-25 04:00:09','2026-08-25 04:00:09'),(20433,16,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-08-25 04:00:09',NULL,NULL,'2026-08-25 04:00:09','2026-08-25 04:00:09'),(20434,19,1,'toner','Toner (Cyan)',33,100,33.00,NULL,'2026-08-25 04:00:18',NULL,NULL,'2026-08-25 04:00:18','2026-08-25 04:00:18'),(20435,19,2,'toner','Toner (Magenta)',49,100,49.00,NULL,'2026-08-25 04:00:18',NULL,NULL,'2026-08-25 04:00:18','2026-08-25 04:00:18'),(20436,19,3,'toner','Toner (Yellow)',27,100,27.00,NULL,'2026-08-25 04:00:18',NULL,NULL,'2026-08-25 04:00:18','2026-08-25 04:00:18'),(20437,19,4,'toner','Toner (Black)',0,100,0.00,NULL,'2026-08-25 04:00:18',NULL,NULL,'2026-08-25 04:00:18','2026-08-25 04:00:18'),(20438,19,200,'compteur','Pages N&B',45817,NULL,NULL,'pages','2026-08-25 04:00:18',NULL,NULL,'2026-08-25 04:00:18','2026-08-25 04:00:18'),(20439,19,201,'compteur','Pages couleur',29024,NULL,NULL,'pages','2026-08-25 04:00:18',NULL,NULL,'2026-08-25 04:00:18','2026-08-25 04:00:18'),(20440,19,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-08-25 04:00:18',NULL,NULL,'2026-08-25 04:00:18','2026-08-25 04:00:18'),(20441,22,1,'toner','Toner (Cyan)',34,100,34.00,NULL,'2026-08-25 04:00:23',NULL,NULL,'2026-08-25 04:00:23','2026-08-25 04:00:23'),(20442,22,2,'toner','Toner (Magenta)',70,100,70.00,NULL,'2026-08-25 04:00:23',NULL,NULL,'2026-08-25 04:00:23','2026-08-25 04:00:23'),(20443,22,3,'toner','Toner (Yellow)',60,100,60.00,NULL,'2026-08-25 04:00:23',NULL,NULL,'2026-08-25 04:00:23','2026-08-25 04:00:23'),(20444,22,4,'toner','Toner (Black)',24,100,24.00,NULL,'2026-08-25 04:00:23',NULL,NULL,'2026-08-25 04:00:23','2026-08-25 04:00:23'),(20445,22,200,'compteur','Pages N&B',3587,NULL,NULL,'pages','2026-08-25 04:00:23',NULL,NULL,'2026-08-25 04:00:23','2026-08-25 04:00:23'),(20446,22,201,'compteur','Pages couleur',17528,NULL,NULL,'pages','2026-08-25 04:00:23',NULL,NULL,'2026-08-25 04:00:23','2026-08-25 04:00:23'),(20447,22,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-08-25 04:00:23',NULL,NULL,'2026-08-25 04:00:23','2026-08-25 04:00:23'),(20448,23,1,'toner','Toner (Cyan)',28,100,28.00,NULL,'2026-08-25 04:00:23',NULL,NULL,'2026-08-25 04:00:23','2026-08-25 04:00:23'),(20449,23,2,'toner','Toner (Magenta)',44,100,44.00,NULL,'2026-08-25 04:00:23',NULL,NULL,'2026-08-25 04:00:23','2026-08-25 04:00:23'),(20450,23,3,'toner','Toner (Yellow)',47,100,47.00,NULL,'2026-08-25 04:00:23',NULL,NULL,'2026-08-25 04:00:23','2026-08-25 04:00:23'),(20451,23,4,'toner','Toner (Black)',95,100,95.00,NULL,'2026-08-25 04:00:23',NULL,NULL,'2026-08-25 04:00:23','2026-08-25 04:00:23'),(20452,23,18,'toner','Staple Cartridge',1,NULL,NULL,NULL,'2026-08-25 04:00:23',NULL,NULL,'2026-08-25 04:00:23','2026-08-25 04:00:23'),(20453,23,200,'compteur','Pages N&B',5497,NULL,NULL,'pages','2026-08-25 04:00:23',NULL,NULL,'2026-08-25 04:00:24','2026-08-25 04:00:24'),(20454,23,201,'compteur','Pages couleur',24433,NULL,NULL,'pages','2026-08-25 04:00:23',NULL,NULL,'2026-08-25 04:00:24','2026-08-25 04:00:24'),(20455,23,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-08-25 04:00:23',NULL,NULL,'2026-08-25 04:00:24','2026-08-25 04:00:24'),(20456,24,1,'toner','Toner (Cyan)',72,100,72.00,NULL,'2026-08-25 04:00:24',NULL,NULL,'2026-08-25 04:00:24','2026-08-25 04:00:24'),(20457,24,2,'toner','Toner (Magenta)',82,100,82.00,NULL,'2026-08-25 04:00:24',NULL,NULL,'2026-08-25 04:00:24','2026-08-25 04:00:24'),(20458,24,3,'toner','Toner (Yellow)',78,100,78.00,NULL,'2026-08-25 04:00:24',NULL,NULL,'2026-08-25 04:00:24','2026-08-25 04:00:24'),(20459,24,4,'toner','Toner (Black)',53,100,53.00,NULL,'2026-08-25 04:00:24',NULL,NULL,'2026-08-25 04:00:24','2026-08-25 04:00:24'),(20460,24,200,'compteur','Pages N&B',2707,NULL,NULL,'pages','2026-08-25 04:00:24',NULL,NULL,'2026-08-25 04:00:24','2026-08-25 04:00:24'),(20461,24,201,'compteur','Pages couleur',9593,NULL,NULL,'pages','2026-08-25 04:00:24',NULL,NULL,'2026-08-25 04:00:24','2026-08-25 04:00:24'),(20462,24,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-08-25 04:00:24',NULL,NULL,'2026-08-25 04:00:24','2026-08-25 04:00:24'),(20463,26,1,'toner','ADF Kit',101200,110000,92.00,NULL,'2026-08-25 04:00:24',NULL,NULL,'2026-08-25 04:00:24','2026-08-25 04:00:24'),(20464,26,2,'toner','Black Cartridge',14062,15800,89.00,NULL,'2026-08-25 04:00:25',NULL,NULL,'2026-08-25 04:00:25','2026-08-25 04:00:25'),(20465,26,3,'toner','Cyan Cartridge',6512,8800,74.00,NULL,'2026-08-25 04:00:25',NULL,NULL,'2026-08-25 04:00:25','2026-08-25 04:00:25'),(20466,26,4,'toner','Transfer Module',150000,150000,100.00,NULL,'2026-08-25 04:00:25',NULL,NULL,'2026-08-25 04:00:25','2026-08-25 04:00:25'),(20467,26,5,'toner','Imaging Kit',132000,150000,88.00,NULL,'2026-08-25 04:00:25',NULL,NULL,'2026-08-25 04:00:25','2026-08-25 04:00:25'),(20468,26,6,'toner','Magenta Cartridge',5896,8800,67.00,NULL,'2026-08-25 04:00:25',NULL,NULL,'2026-08-25 04:00:25','2026-08-25 04:00:25'),(20469,26,7,'toner','Maintenance Kit',133500,150000,89.00,NULL,'2026-08-25 04:00:25',NULL,NULL,'2026-08-25 04:00:25','2026-08-25 04:00:25'),(20470,26,8,'dechet_toner','Waste Toner Bottle',12900,30000,57.00,NULL,'2026-08-25 04:00:25',NULL,NULL,'2026-08-25 04:00:25','2026-08-25 04:00:25'),(20471,26,9,'toner','Yellow Cartridge',5544,8800,63.00,NULL,'2026-08-25 04:00:25',NULL,NULL,'2026-08-25 04:00:25','2026-08-25 04:00:25'),(20472,26,200,'compteur','Pages N&B',7786,NULL,NULL,'pages','2026-08-25 04:00:25',NULL,NULL,'2026-08-25 04:00:25','2026-08-25 04:00:25'),(20473,26,201,'compteur','Pages couleur',6728,NULL,NULL,'pages','2026-08-25 04:00:25',NULL,NULL,'2026-08-25 04:00:25','2026-08-25 04:00:25'),(20474,27,1,'toner','ADF Kit',108900,110000,99.00,NULL,'2026-08-25 04:00:25',NULL,NULL,'2026-08-25 04:00:25','2026-08-25 04:00:25'),(20475,27,2,'toner','Black Cartridge',10428,15800,66.00,NULL,'2026-08-25 04:00:25',NULL,NULL,'2026-08-25 04:00:25','2026-08-25 04:00:25'),(20476,27,3,'toner','Cyan Cartridge',6072,8800,69.00,NULL,'2026-08-25 04:00:25',NULL,NULL,'2026-08-25 04:00:25','2026-08-25 04:00:25'),(20477,27,4,'toner','Transfer Module',150000,150000,100.00,NULL,'2026-08-25 04:00:25',NULL,NULL,'2026-08-25 04:00:25','2026-08-25 04:00:25'),(20478,27,5,'toner','Imaging Kit',150000,150000,100.00,NULL,'2026-08-25 04:00:25',NULL,NULL,'2026-08-25 04:00:25','2026-08-25 04:00:25'),(20479,27,6,'toner','Magenta Cartridge',6072,8800,69.00,NULL,'2026-08-25 04:00:25',NULL,NULL,'2026-08-25 04:00:25','2026-08-25 04:00:25'),(20480,27,7,'toner','Maintenance Kit',150000,150000,100.00,NULL,'2026-08-25 04:00:25',NULL,NULL,'2026-08-25 04:00:25','2026-08-25 04:00:25'),(20481,27,8,'dechet_toner','Waste Toner Bottle',19200,30000,36.00,NULL,'2026-08-25 04:00:25',NULL,NULL,'2026-08-25 04:00:25','2026-08-25 04:00:25'),(20482,27,9,'toner','Yellow Cartridge',7480,8800,85.00,NULL,'2026-08-25 04:00:25',NULL,NULL,'2026-08-25 04:00:25','2026-08-25 04:00:25'),(20483,27,200,'compteur','Pages N&B',2559,NULL,NULL,'pages','2026-08-25 04:00:25',NULL,NULL,'2026-08-25 04:00:25','2026-08-25 04:00:25'),(20484,27,201,'compteur','Pages couleur',3473,NULL,NULL,'pages','2026-08-25 04:00:25',NULL,NULL,'2026-08-25 04:00:25','2026-08-25 04:00:25'),(20485,28,1,'toner','ADF Kit',108900,110000,99.00,NULL,'2026-08-25 04:00:26',NULL,NULL,'2026-08-25 04:00:26','2026-08-25 04:00:26'),(20486,28,2,'toner','Black Cartridge',15800,15800,100.00,NULL,'2026-08-25 04:00:26',NULL,NULL,'2026-08-25 04:00:26','2026-08-25 04:00:26'),(20487,28,3,'toner','Cyan Cartridge',7832,8800,89.00,NULL,'2026-08-25 04:00:26',NULL,NULL,'2026-08-25 04:00:26','2026-08-25 04:00:26'),(20488,28,4,'toner','Transfer Module',150000,150000,100.00,NULL,'2026-08-25 04:00:26',NULL,NULL,'2026-08-25 04:00:26','2026-08-25 04:00:26'),(20489,28,5,'toner','Imaging Kit',150000,150000,100.00,NULL,'2026-08-25 04:00:26',NULL,NULL,'2026-08-25 04:00:26','2026-08-25 04:00:26'),(20490,28,6,'toner','Magenta Cartridge',8800,8800,100.00,NULL,'2026-08-25 04:00:26',NULL,NULL,'2026-08-25 04:00:26','2026-08-25 04:00:26'),(20491,28,7,'toner','Maintenance Kit',150000,150000,100.00,NULL,'2026-08-25 04:00:26',NULL,NULL,'2026-08-25 04:00:26','2026-08-25 04:00:26'),(20492,28,8,'dechet_toner','Waste Toner Bottle',24600,30000,18.00,NULL,'2026-08-25 04:00:26',NULL,NULL,'2026-08-25 04:00:26','2026-08-25 04:00:26'),(20493,28,9,'toner','Yellow Cartridge',7832,8800,89.00,NULL,'2026-08-25 04:00:26',NULL,NULL,'2026-08-25 04:00:26','2026-08-25 04:00:26'),(20494,28,200,'compteur','Pages N&B',772,NULL,NULL,'pages','2026-08-25 04:00:26',NULL,NULL,'2026-08-25 04:00:26','2026-08-25 04:00:26'),(20495,28,201,'compteur','Pages couleur',2569,NULL,NULL,'pages','2026-08-25 04:00:26',NULL,NULL,'2026-08-25 04:00:26','2026-08-25 04:00:26'),(20496,29,1,'toner','ADF Kit',108900,110000,99.00,NULL,'2026-08-25 04:00:27',NULL,NULL,'2026-08-25 04:00:27','2026-08-25 04:00:27'),(20497,29,2,'toner','Black Cartridge',9638,15800,61.00,NULL,'2026-08-25 04:00:27',NULL,NULL,'2026-08-25 04:00:27','2026-08-25 04:00:27'),(20498,29,3,'toner','Cyan Cartridge',6072,8800,69.00,NULL,'2026-08-25 04:00:27',NULL,NULL,'2026-08-25 04:00:27','2026-08-25 04:00:27'),(20499,29,4,'toner','Transfer Module',150000,150000,100.00,NULL,'2026-08-25 04:00:27',NULL,NULL,'2026-08-25 04:00:27','2026-08-25 04:00:27'),(20500,29,5,'toner','Imaging Kit',150000,150000,100.00,NULL,'2026-08-25 04:00:27',NULL,NULL,'2026-08-25 04:00:27','2026-08-25 04:00:27'),(20501,29,6,'toner','Magenta Cartridge',6688,8800,76.00,NULL,'2026-08-25 04:00:27',NULL,NULL,'2026-08-25 04:00:27','2026-08-25 04:00:27'),(20502,29,7,'toner','Maintenance Kit',150000,150000,100.00,NULL,'2026-08-25 04:00:27',NULL,NULL,'2026-08-25 04:00:27','2026-08-25 04:00:27'),(20503,29,8,'dechet_toner','Waste Toner Bottle',20100,30000,33.00,NULL,'2026-08-25 04:00:27',NULL,NULL,'2026-08-25 04:00:27','2026-08-25 04:00:27'),(20504,29,9,'toner','Yellow Cartridge',7920,8800,90.00,NULL,'2026-08-25 04:00:27',NULL,NULL,'2026-08-25 04:00:27','2026-08-25 04:00:27'),(20505,29,200,'compteur','Pages N&B',2432,NULL,NULL,'pages','2026-08-25 04:00:27',NULL,NULL,'2026-08-25 04:00:27','2026-08-25 04:00:27'),(20506,29,201,'compteur','Pages couleur',4709,NULL,NULL,'pages','2026-08-25 04:00:27',NULL,NULL,'2026-08-25 04:00:27','2026-08-25 04:00:27'),(20507,31,1,'toner','ADF Kit',108900,110000,99.00,NULL,'2026-08-25 04:00:27',NULL,NULL,'2026-08-25 04:00:27','2026-08-25 04:00:27'),(20508,31,2,'toner','Black Cartridge',1769,3000,58.97,NULL,'2026-08-25 04:00:27',NULL,NULL,'2026-08-25 04:00:27','2026-08-25 04:00:27'),(20509,31,3,'toner','Cyan Cartridge',1320,2000,66.00,NULL,'2026-08-25 04:00:27',NULL,NULL,'2026-08-25 04:00:27','2026-08-25 04:00:27'),(20510,31,4,'toner','Transfer Module',150000,150000,100.00,NULL,'2026-08-25 04:00:27',NULL,NULL,'2026-08-25 04:00:27','2026-08-25 04:00:27'),(20511,31,5,'toner','Imaging Kit',150000,150000,100.00,NULL,'2026-08-25 04:00:27',NULL,NULL,'2026-08-25 04:00:27','2026-08-25 04:00:27'),(20512,31,6,'toner','Magenta Cartridge',1260,2000,63.00,NULL,'2026-08-25 04:00:27',NULL,NULL,'2026-08-25 04:00:27','2026-08-25 04:00:27'),(20513,31,7,'toner','Maintenance Kit',150000,150000,100.00,NULL,'2026-08-25 04:00:27',NULL,NULL,'2026-08-25 04:00:27','2026-08-25 04:00:27'),(20514,31,8,'dechet_toner','Waste Toner Bottle',25200,30000,16.00,NULL,'2026-08-25 04:00:27',NULL,NULL,'2026-08-25 04:00:27','2026-08-25 04:00:27'),(20515,31,9,'toner','Yellow Cartridge',1140,2000,57.00,NULL,'2026-08-25 04:00:27',NULL,NULL,'2026-08-25 04:00:27','2026-08-25 04:00:27'),(20516,31,200,'compteur','Pages N&B',203,NULL,NULL,'pages','2026-08-25 04:00:27',NULL,NULL,'2026-08-25 04:00:27','2026-08-25 04:00:27'),(20517,31,201,'compteur','Pages couleur',603,NULL,NULL,'pages','2026-08-25 04:00:27',NULL,NULL,'2026-08-25 04:00:27','2026-08-25 04:00:27'),(20518,32,1,'toner','ADF Kit',105600,110000,96.00,NULL,'2026-08-25 04:00:28',NULL,NULL,'2026-08-25 04:00:28','2026-08-25 04:00:28'),(20519,32,2,'toner','Black Cartridge',11850,15800,75.00,NULL,'2026-08-25 04:00:28',NULL,NULL,'2026-08-25 04:00:28','2026-08-25 04:00:28'),(20520,32,3,'toner','Cyan Cartridge',6864,8800,78.00,NULL,'2026-08-25 04:00:28',NULL,NULL,'2026-08-25 04:00:28','2026-08-25 04:00:28'),(20521,32,4,'toner','Transfer Module',150000,150000,100.00,NULL,'2026-08-25 04:00:28',NULL,NULL,'2026-08-25 04:00:28','2026-08-25 04:00:28'),(20522,32,5,'toner','Imaging Kit',150000,150000,100.00,NULL,'2026-08-25 04:00:28',NULL,NULL,'2026-08-25 04:00:28','2026-08-25 04:00:28'),(20523,32,6,'toner','Magenta Cartridge',6688,8800,76.00,NULL,'2026-08-25 04:00:28',NULL,NULL,'2026-08-25 04:00:28','2026-08-25 04:00:28'),(20524,32,7,'toner','Maintenance Kit',150000,150000,100.00,NULL,'2026-08-25 04:00:28',NULL,NULL,'2026-08-25 04:00:28','2026-08-25 04:00:28'),(20525,32,8,'dechet_toner','Waste Toner Bottle',19200,30000,36.00,NULL,'2026-08-25 04:00:28',NULL,NULL,'2026-08-25 04:00:28','2026-08-25 04:00:28'),(20526,32,9,'toner','Yellow Cartridge',7304,8800,83.00,NULL,'2026-08-25 04:00:28',NULL,NULL,'2026-08-25 04:00:28','2026-08-25 04:00:28'),(20527,32,200,'compteur','Pages N&B',1052,NULL,NULL,'pages','2026-08-25 04:00:28',NULL,NULL,'2026-08-25 04:00:28','2026-08-25 04:00:28'),(20528,32,201,'compteur','Pages couleur',5097,NULL,NULL,'pages','2026-08-25 04:00:28',NULL,NULL,'2026-08-25 04:00:28','2026-08-25 04:00:28'),(20540,40,1,'toner','ADF Kit',108900,110000,99.00,NULL,'2026-08-25 04:00:40',NULL,NULL,'2026-08-25 04:00:40','2026-08-25 04:00:40'),(20541,40,2,'toner','Black Cartridge',1500,3000,50.00,NULL,'2026-08-25 04:00:40',NULL,NULL,'2026-08-25 04:00:40','2026-08-25 04:00:40'),(20542,40,3,'toner','Cyan Cartridge',280,2000,14.00,NULL,'2026-08-25 04:00:40',NULL,NULL,'2026-08-25 04:00:40','2026-08-25 04:00:40'),(20543,40,4,'toner','Transfer Module',150000,150000,100.00,NULL,'2026-08-25 04:00:40',NULL,NULL,'2026-08-25 04:00:40','2026-08-25 04:00:40'),(20544,40,5,'toner','Imaging Kit',150000,150000,100.00,NULL,'2026-08-25 04:00:40',NULL,NULL,'2026-08-25 04:00:40','2026-08-25 04:00:40'),(20545,40,6,'toner','Magenta Cartridge',660,2000,33.00,NULL,'2026-08-25 04:00:40',NULL,NULL,'2026-08-25 04:00:40','2026-08-25 04:00:40'),(20546,40,7,'toner','Maintenance Kit',150000,150000,100.00,NULL,'2026-08-25 04:00:40',NULL,NULL,'2026-08-25 04:00:40','2026-08-25 04:00:40'),(20547,40,8,'dechet_toner','Waste Toner Bottle',24600,30000,18.00,NULL,'2026-08-25 04:00:40',NULL,NULL,'2026-08-25 04:00:40','2026-08-25 04:00:40'),(20548,40,9,'toner','Yellow Cartridge',500,2000,25.00,NULL,'2026-08-25 04:00:40',NULL,NULL,'2026-08-25 04:00:40','2026-08-25 04:00:40'),(20549,40,200,'compteur','Pages N&B',178,NULL,NULL,'pages','2026-08-25 04:00:40',NULL,NULL,'2026-08-25 04:00:40','2026-08-25 04:00:40'),(20550,40,201,'compteur','Pages couleur',1350,NULL,NULL,'pages','2026-08-25 04:00:40',NULL,NULL,'2026-08-25 04:00:40','2026-08-25 04:00:40'),(20551,41,1,'toner','HP 72 ( C9374A )',31,100,31.00,'ml','2026-08-25 04:00:41',NULL,NULL,'2026-08-25 04:00:41','2026-08-25 04:00:41'),(20552,41,2,'toner','HP 72 ( C9370A )',15,130,11.54,'ml','2026-08-25 04:00:41',NULL,NULL,'2026-08-25 04:00:41','2026-08-25 04:00:41'),(20553,41,3,'toner','HP 72 ( C9403A )',61,100,61.00,'ml','2026-08-25 04:00:41',NULL,NULL,'2026-08-25 04:00:41','2026-08-25 04:00:41'),(20554,41,4,'toner','HP 72 ( C9373A )',67,100,67.00,'ml','2026-08-25 04:00:41',NULL,NULL,'2026-08-25 04:00:41','2026-08-25 04:00:41'),(20555,41,5,'toner','HP 72 ( C9372A )',37,100,37.00,'ml','2026-08-25 04:00:41',NULL,NULL,'2026-08-25 04:00:41','2026-08-25 04:00:41'),(20556,41,6,'toner','HP 72 ( C9371A )',35,100,35.00,'ml','2026-08-25 04:00:41',NULL,NULL,'2026-08-25 04:00:41','2026-08-25 04:00:41'),(20557,41,200,'compteur','Pages N&B',1723,NULL,NULL,'pages','2026-08-25 04:00:41',NULL,NULL,'2026-08-25 04:00:42','2026-08-25 04:00:42'),(20558,41,201,'compteur','Pages couleur',2956,NULL,NULL,'pages','2026-08-25 04:00:41',NULL,NULL,'2026-08-25 04:00:42','2026-08-25 04:00:42'),(20559,41,999,'tete_impression','Tête d\'impression',50,100,50.00,'pourcent','2026-08-25 04:00:41',NULL,'{\"canal_1\": 315288, \"canal_2\": 306542, \"canal_3\": 529746, \"canal_4\": 496353, \"canal_5\": 568287, \"canal_6\": 343131}','2026-08-25 04:00:42','2026-08-25 04:00:42'),(20608,33,1,'toner','ADF Kit',108900,110000,99.00,NULL,'2026-08-25 06:55:11',NULL,NULL,'2026-08-25 06:55:11','2026-08-25 06:55:11'),(20609,33,2,'toner','Black Cartridge',2280,3000,76.00,NULL,'2026-08-25 06:55:11',NULL,NULL,'2026-08-25 06:55:11','2026-08-25 06:55:11'),(20610,33,3,'toner','Cyan Cartridge',1460,2000,73.00,NULL,'2026-08-25 06:55:11',NULL,NULL,'2026-08-25 06:55:11','2026-08-25 06:55:11'),(20611,33,4,'toner','Transfer Module',150000,150000,100.00,NULL,'2026-08-25 06:55:11',NULL,NULL,'2026-08-25 06:55:11','2026-08-25 06:55:11'),(20612,33,5,'toner','Imaging Kit',150000,150000,100.00,NULL,'2026-08-25 06:55:11',NULL,NULL,'2026-08-25 06:55:11','2026-08-25 06:55:11'),(20613,33,6,'toner','Magenta Cartridge',1460,2000,73.00,NULL,'2026-08-25 06:55:11',NULL,NULL,'2026-08-25 06:55:11','2026-08-25 06:55:11'),(20614,33,7,'toner','Maintenance Kit',150000,150000,100.00,NULL,'2026-08-25 06:55:11',NULL,NULL,'2026-08-25 06:55:11','2026-08-25 06:55:11'),(20615,33,8,'dechet_toner','Waste Toner Bottle',26700,30000,11.00,NULL,'2026-08-25 06:55:11',NULL,NULL,'2026-08-25 06:55:11','2026-08-25 06:55:11'),(20616,33,9,'toner','Yellow Cartridge',1360,2000,68.00,NULL,'2026-08-25 06:55:11',NULL,NULL,'2026-08-25 06:55:11','2026-08-25 06:55:11'),(20617,33,200,'compteur','Pages N&B',71,NULL,NULL,'pages','2026-08-25 06:55:11',NULL,NULL,'2026-08-25 06:55:12','2026-08-25 06:55:12'),(20618,33,201,'compteur','Pages couleur',505,NULL,NULL,'pages','2026-08-25 06:55:11',NULL,NULL,'2026-08-25 06:55:12','2026-08-25 06:55:12'),(20619,18,1,'toner','Toner (Cyan)',44,100,44.00,NULL,'2026-08-25 10:01:49',NULL,NULL,'2026-08-25 10:01:49','2026-08-25 10:01:49'),(20620,18,2,'toner','Toner (Magenta)',51,100,51.00,NULL,'2026-08-25 10:01:49',NULL,NULL,'2026-08-25 10:01:49','2026-08-25 10:01:49'),(20621,18,3,'toner','Toner (Yellow)',36,100,36.00,NULL,'2026-08-25 10:01:49',NULL,NULL,'2026-08-25 10:01:49','2026-08-25 10:01:49'),(20622,18,4,'toner','Toner (Black)',9,100,9.00,NULL,'2026-08-25 10:01:49',NULL,NULL,'2026-08-25 10:01:49','2026-08-25 10:01:49'),(20623,18,200,'compteur','Pages N&B',7774,NULL,NULL,'pages','2026-08-25 10:01:49',NULL,NULL,'2026-08-25 10:01:50','2026-08-25 10:01:50'),(20624,18,201,'compteur','Pages couleur',18348,NULL,NULL,'pages','2026-08-25 10:01:49',NULL,NULL,'2026-08-25 10:01:50','2026-08-25 10:01:50'),(20625,18,8,'dechet_toner','Waste Toner Bottle',1,100,0.00,'pourcent','2026-08-25 10:01:49',NULL,NULL,'2026-08-25 10:01:50','2026-08-25 10:01:50'),(20626,43,1,'toner','yellow ink HP F6T83A',75,100,75.00,NULL,'2026-08-25 10:06:10',NULL,NULL,'2026-08-25 10:06:10','2026-08-25 10:06:10'),(20627,43,2,'toner','magenta ink HP F6T82A',54,100,54.00,NULL,'2026-08-25 10:06:10',NULL,NULL,'2026-08-25 10:06:10','2026-08-25 10:06:10'),(20628,43,3,'toner','cyan ink HP F6T81A',74,100,74.00,NULL,'2026-08-25 10:06:10',NULL,NULL,'2026-08-25 10:06:10','2026-08-25 10:06:10'),(20629,43,4,'toner','black ink HP L0S07A',42,100,42.00,NULL,'2026-08-25 10:06:10',NULL,NULL,'2026-08-25 10:06:10','2026-08-25 10:06:10'); /*!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=20 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'),(18,26,3,16528,'2026-08-11',0,'2026-08-11 07:27:00','2026-08-11 07:27:00'),(19,23,2,19568,'2026-08-21',0,'2026-08-21 02:12:25','2026-08-21 02:12:25'); /*!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=47 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-07-19 22:00:00','2026-07-20 14:19:15',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),(40,9,3,'2026-07-19 22:00:00','2026-07-20 08:29:09',109),(41,1,9,'2026-07-29 22:00:00','2026-07-30 09:08:23',70),(42,1,10,'2026-07-29 22:00:00','2026-07-30 09:19:51',166),(43,2,23,'2026-08-04 22:00:00','2026-08-05 11:43:11',168),(44,3,36,'2026-08-16 22:00:00','2026-08-17 09:40:13',127),(45,1,5,'2026-08-16 22:00:00','2026-08-17 09:41:02',170),(46,9,6,'2026-08-19 22:00:00','2026-08-21 07:39:22',177); /*!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, `keycloak_sub` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `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, `keycloak_roles` json DEFAULT NULL, `keycloak_groupes` json DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`), UNIQUE KEY `users_keycloak_sub_unique` (`keycloak_sub`) ) 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,NULL,'Test User','test@example.com','2026-06-17 12:14:56','$2y$12$XQSTqg3ms8KtzQmkCG042eR5X9s6W2YQAHdQPhyGW30Kbf31Fbn86','60pGIQKz3J',NULL,NULL,'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-08-25 13:22:24