-- Table structure for table `glpi_crontasks`
--

CREATE TABLE `glpi_crontasks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `itemtype` varchar(100) NOT NULL,
  `name` varchar(150) NOT NULL COMMENT 'task name',
  `frequency` int(11) NOT NULL COMMENT 'second between launch',
  `param` int(11) DEFAULT NULL COMMENT 'task specify parameter',
  `state` int(11) NOT NULL DEFAULT 1 COMMENT '0:disabled, 1:waiting, 2:running',
  `mode` int(11) NOT NULL DEFAULT 1 COMMENT '1:internal, 2:external',
  `allowmode` int(11) NOT NULL DEFAULT 3 COMMENT '1:internal, 2:external, 3:both',
  `hourmin` int(11) NOT NULL DEFAULT 0,
  `hourmax` int(11) NOT NULL DEFAULT 24,
  `logs_lifetime` int(11) NOT NULL DEFAULT 30 COMMENT 'number of days',
  `lastrun` timestamp NULL DEFAULT NULL COMMENT 'last run date',
  `lastcode` int(11) DEFAULT NULL COMMENT 'last run return code',
  `comment` text DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`itemtype`,`name`),
  KEY `name` (`name`),
  KEY `mode` (`mode`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Task run by internal / external cron.';

--
-- Dumping data for table `glpi_crontasks`
--

INSERT INTO `glpi_crontasks` VALUES
(2,'CartridgeItem','cartridge',86400,10,0,1,3,0,24,30,NULL,NULL,NULL,NULL,NULL),
(3,'ConsumableItem','consumable',86400,10,0,1,3,0,24,30,NULL,NULL,NULL,NULL,NULL),
(4,'SoftwareLicense','software',86400,NULL,0,1,3,0,24,30,NULL,NULL,NULL,NULL,NULL),
(5,'Contract','contract',86400,NULL,1,1,3,0,24,30,'2025-02-18 11:58:00',NULL,NULL,NULL,NULL),
(6,'Infocom','infocom',86400,NULL,1,1,3,0,24,30,'2025-02-18 17:48:00',NULL,NULL,NULL,NULL),
(7,'CronTask','logs',86400,30,0,1,3,0,24,30,NULL,NULL,NULL,NULL,NULL),
(9,'MailCollector','mailgate',600,10,1,1,3,0,24,30,'2025-02-18 18:48:00',NULL,NULL,NULL,NULL),
(10,'DBconnection','checkdbreplicate',300,NULL,0,1,3,0,24,30,NULL,NULL,NULL,NULL,NULL),
(11,'CronTask','checkupdate',604800,NULL,0,1,3,0,24,30,NULL,NULL,NULL,NULL,NULL),
(12,'CronTask','session',86400,NULL,1,1,3,0,24,30,'2025-02-18 18:31:00',NULL,NULL,NULL,NULL),
(13,'CronTask','graph',3600,NULL,1,1,3,0,24,30,'2025-02-18 18:14:00',NULL,NULL,NULL,NULL),
(14,'ReservationItem','reservation',3600,NULL,1,1,3,0,24,30,'2025-02-18 17:48:00',NULL,NULL,NULL,NULL),
(15,'Ticket','closeticket',43200,NULL,1,1,3,0,24,30,'2025-02-18 18:30:00',NULL,NULL,NULL,NULL),
(16,'Ticket','alertnotclosed',43200,NULL,1,1,3,0,24,30,'2025-02-18 18:46:00',NULL,NULL,NULL,NULL),
(17,'SlaLevel_Ticket','slaticket',300,NULL,1,1,3,0,24,30,'2025-02-18 18:28:00',NULL,NULL,NULL,NULL),
(18,'Ticket','createinquest',86400,NULL,1,1,3,0,24,30,'2025-02-18 18:36:00',NULL,NULL,NULL,NULL),
(19,'CronTask','watcher',86400,NULL,1,1,3,0,24,30,'2025-02-18 18:37:00',NULL,NULL,NULL,NULL),
(20,'CommonITILRecurrentCron','RecurrentItems',3600,NULL,1,1,3,0,24,30,'2025-02-18 17:56:00',NULL,NULL,NULL,NULL),
(21,'PlanningRecall','planningrecall',300,NULL,1,1,3,0,24,30,'2025-02-18 18:53:00',NULL,NULL,NULL,NULL),
(22,'QueuedNotification','queuednotification',60,50,1,1,3,0,24,30,'2025-02-18 18:48:00',NULL,NULL,NULL,NULL),
(23,'QueuedNotification','queuednotificationclean',86400,30,1,1,3,0,24,30,'2025-02-18 10:23:00',NULL,NULL,NULL,NULL),
(24,'CronTask','temp',3600,NULL,1,1,3,0,24,30,'2025-02-18 18:16:00',NULL,NULL,NULL,NULL),
(25,'MailCollector','mailgateerror',86400,NULL,1,1,3,0,24,30,'2025-02-18 16:30:00',NULL,NULL,NULL,NULL),
(26,'CronTask','circularlogs',86400,4,0,1,3,0,24,30,NULL,NULL,NULL,NULL,NULL),
(27,'ObjectLock','unlockobject',86400,4,0,1,3,0,24,30,NULL,NULL,NULL,NULL,NULL),
(28,'SavedSearch','countAll',604800,NULL,0,1,3,0,24,30,NULL,NULL,NULL,NULL,NULL),
(29,'SavedSearch_Alert','savedsearchesalerts',86400,NULL,0,1,3,0,24,30,NULL,NULL,NULL,NULL,NULL),
(30,'Telemetry','telemetry',2592000,NULL,0,1,3,0,24,30,NULL,NULL,NULL,NULL,NULL),
(31,'Certificate','certificate',86400,NULL,1,1,3,0,24,30,'2025-02-18 17:17:00',NULL,NULL,NULL,NULL),
(32,'OlaLevel_Ticket','olaticket',300,NULL,1,1,3,0,24,30,'2025-02-18 18:56:00',NULL,NULL,NULL,NULL),
(33,'PurgeLogs','PurgeLogs',604800,24,1,2,3,0,24,30,NULL,NULL,NULL,NULL,NULL),
(34,'Ticket','purgeticket',604800,NULL,0,2,3,0,24,30,NULL,NULL,NULL,NULL,NULL),
(35,'Document','cleanorphans',604800,NULL,0,2,3,0,24,30,NULL,NULL,NULL,NULL,NULL),
(36,'User','passwordexpiration',86400,100,0,2,3,0,24,30,NULL,NULL,NULL,NULL,NULL),
(37,'Glpi\\Marketplace\\Controller','checkAllUpdates',86400,NULL,1,2,3,0,24,30,NULL,NULL,NULL,NULL,NULL),
(38,'CleanSoftwareCron','cleansoftware',2592000,1000,0,2,3,0,24,300,NULL,NULL,NULL,NULL,NULL),
(39,'Domain','DomainsAlert',86400,NULL,1,2,3,0,24,30,NULL,NULL,NULL,NULL,NULL),
(40,'Glpi\\Inventory\\Inventory','cleantemp',86400,NULL,0,2,3,0,24,30,NULL,NULL,NULL,NULL,NULL),
(41,'Glpi\\Inventory\\Inventory','cleanorphans',604800,NULL,1,2,3,0,24,30,NULL,NULL,NULL,NULL,NULL),
(42,'PendingReasonCron','pendingreason_autobump_autosolve',1800,NULL,1,2,3,0,24,60,NULL,NULL,NULL,NULL,NULL),
(43,'Agent','Cleanoldagents',86400,NULL,1,2,3,0,24,30,NULL,NULL,NULL,NULL,NULL),
(44,'PluginFormcreatorIssue','SyncIssues',3600,NULL,0,2,3,0,24,30,NULL,NULL,'Formcreator - Sincronizar problemas do catálogo de serviços','2025-01-10 21:20:07','2025-01-10 21:20:07');

--
-- Table structure for table `glpi_dashboards_dashboards`
--

CREATE TABLE `glpi_dashboards_dashboards` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `context` varchar(100) NOT NULL DEFAULT 'core',
  `users_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `key` (`key`),
  KEY `name` (`name`),
  KEY `users_id` (`users_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_dashboards_dashboards`
--

INSERT INTO `glpi_dashboards_dashboards` VALUES
(1,'central','Central','core',0),
(2,'assets','Ativos','core',0),
(3,'assistance','Assistência','core',0),
(4,'mini_tickets','Painel de pequenos chamados','mini_core',0),
(5,'plugin_formcreator_issue_counters','Assistance requests counts','mini_core',0);

--
-- Table structure for table `glpi_dashboards_filters`
--

CREATE TABLE `glpi_dashboards_filters` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dashboards_dashboards_id` int(10) unsigned NOT NULL DEFAULT 0,
  `users_id` int(10) unsigned NOT NULL DEFAULT 0,
  `filter` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dashboards_dashboards_id` (`dashboards_dashboards_id`),
  KEY `users_id` (`users_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_dashboards_filters`
--


--
-- Table structure for table `glpi_dashboards_items`
--

CREATE TABLE `glpi_dashboards_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dashboards_dashboards_id` int(10) unsigned NOT NULL,
  `gridstack_id` varchar(255) NOT NULL,
  `card_id` varchar(255) NOT NULL,
  `x` int(11) DEFAULT NULL,
  `y` int(11) DEFAULT NULL,
  `width` int(11) DEFAULT NULL,
  `height` int(11) DEFAULT NULL,
  `card_options` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dashboards_dashboards_id` (`dashboards_dashboards_id`)
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_dashboards_items`
--

INSERT INTO `glpi_dashboards_items` VALUES
(1,1,'bn_count_Computer_4a315743-151c-40cb-a20b-762250668dac','bn_count_Computer',3,0,3,2,'{\"color\":\"#e69393\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(2,1,'bn_count_Software_0690f524-e826-47a9-b50a-906451196b83','bn_count_Software',0,0,3,2,'{\"color\":\"#aaddac\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(3,1,'bn_count_Rack_c6502e0a-5991-46b4-a771-7f355137306b','bn_count_Rack',6,2,3,2,'{\"color\":\"#0e87a0\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(4,1,'bn_count_SoftwareLicense_e755fd06-283e-4479-ba35-2d548f8f8a90','bn_count_SoftwareLicense',0,2,3,2,'{\"color\":\"#27ab3c\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(5,1,'bn_count_Monitor_7059b94c-583c-4ba7-b100-d40461165318','bn_count_Monitor',3,2,3,2,'{\"color\":\"#b52d30\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(6,1,'bn_count_Ticket_a74c0903-3387-4a07-9111-b0938af8f1e7','bn_count_Ticket',14,7,3,2,'{\"color\":\"#ffdc64\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(7,1,'bn_count_Problem_c1cf5cfb-f626-472e-82a1-49c3e200e746','bn_count_Problem',20,7,3,2,'{\"color\":\"#f08d7b\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(8,1,'count_Computer_Manufacturer_6129c451-42b5-489d-b693-c362adf32d49','count_Computer_Manufacturer',0,4,5,4,'{\"color\":\"#f8faf9\",\"widgettype\":\"donut\",\"use_gradient\":\"1\",\"limit\":\"5\"}'),
(9,1,'top_ticket_user_requester_c74f52a8-046a-4077-b1a6-c9f840d34b82','top_ticket_user_requester',14,9,6,5,'{\"color\":\"#f9fafb\",\"widgettype\":\"hbar\",\"use_gradient\":\"1\",\"limit\":\"5\"}'),
(10,1,'bn_count_tickets_late_04c47208-d7e5-4aca-9566-d46e68c45c67','bn_count_tickets_late',17,7,3,2,'{\"color\":\"#f8911f\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(11,1,'ticket_status_2e4e968b-d4e6-4e33-9ce9-a1aaff53dfde','ticket_status',14,0,12,7,'{\"color\":\"#fafafa\",\"widgettype\":\"stackedbars\",\"use_gradient\":\"0\",\"limit\":\"12\"}'),
(12,1,'top_ticket_ITILCategory_37736ba9-d429-4cb3-9058-ef4d111d9269','top_ticket_ITILCategory',20,9,6,5,'{\"color\":\"#fbf9f9\",\"widgettype\":\"hbar\",\"use_gradient\":\"1\",\"limit\":\"5\"}'),
(13,1,'bn_count_Printer_517684b0-b064-49dd-943e-fcb6f915e453','bn_count_Printer',9,2,3,2,'{\"color\":\"#365a8f\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(14,1,'bn_count_Phone_f70c489f-02c1-46e5-978b-94a95b5038ee','bn_count_Phone',9,0,3,2,'{\"color\":\"#d5e1ec\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(15,1,'bn_count_Change_ab950dbd-cd25-466d-8dff-7dcaca386564','bn_count_Change',23,7,3,2,'{\"color\":\"#cae3c4\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(16,1,'bn_count_Group_b84a93f2-a26c-49d7-82a4-5446697cc5b0','bn_count_Group',4,8,4,2,'{\"color\":\"#e0e0e0\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(17,1,'bn_count_Profile_770b35e8-68e9-4b4f-9e09-5a11058f069f','bn_count_Profile',4,10,4,2,'{\"color\":\"#e0e0e0\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(18,1,'bn_count_Supplier_36ff9011-e4cf-4d89-b9ab-346b9857d734','bn_count_Supplier',8,8,3,2,'{\"color\":\"#c9c9c9\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(19,1,'bn_count_KnowbaseItem_a3785a56-bed4-4a30-8387-f251f5365b3b','bn_count_KnowbaseItem',8,10,3,2,'{\"color\":\"#c9c9c9\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(20,1,'bn_count_Entity_9b82951a-ba52-45cc-a2d3-1d238ec37adf','bn_count_Entity',0,10,4,2,'{\"color\":\"#f9f9f9\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(21,1,'bn_count_Document_7dc7f4b8-61ff-4147-b994-5541bddd7b66','bn_count_Document',11,8,3,2,'{\"color\":\"#b4b4b4\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(22,1,'bn_count_Project_4d412ee2-8b79-469b-995f-4c0a05ab849d','bn_count_Project',11,10,3,2,'{\"color\":\"#b3b3b3\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(23,1,'bn_count_NetworkEquipment_c537e334-d584-43bc-b6de-b4a939143e89','bn_count_NetworkEquipment',6,0,3,2,'{\"color\":\"#bfe7ea\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(24,1,'bn_count_User_ac0cbe52-3593-43c1-8ecc-0eb115de494d','bn_count_User',0,8,4,2,'{\"color\":\"#fafafa\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(25,1,'count_Monitor_MonitorModel_5a476ff9-116e-4270-858b-c003c20841a9','count_Monitor_MonitorModel',5,4,5,4,'{\"color\":\"#f5fafa\",\"widgettype\":\"donut\",\"use_gradient\":\"1\",\"limit\":\"5\"}'),
(26,1,'count_NetworkEquipment_State_81f2ae35-b366-4065-ac26-02ea4e3704a6','count_NetworkEquipment_State',10,4,4,4,'{\"color\":\"#f5f3ef\",\"widgettype\":\"donut\",\"use_gradient\":\"1\",\"limit\":\"5\"}'),
(27,2,'bn_count_Computer_34cfbaf9-a471-4852-b48c-0dadea7644de','bn_count_Computer',0,0,4,3,'{\"color\":\"#f3d0d0\",\"widgettype\":\"bigNumber\"}'),
(28,2,'bn_count_Software_60091467-2137-49f4-8834-f6602a482079','bn_count_Software',4,0,4,3,'{\"color\":\"#d1f1a8\",\"widgettype\":\"bigNumber\"}'),
(29,2,'bn_count_Printer_c9a385d4-76a3-4971-ad0e-1470efeafacc','bn_count_Printer',8,3,4,3,'{\"color\":\"#5da8d6\",\"widgettype\":\"bigNumber\"}'),
(30,2,'bn_count_PDU_60053eb6-8dda-4416-9a4b-afd51889bd09','bn_count_PDU',12,3,4,3,'{\"color\":\"#ffb62f\",\"widgettype\":\"bigNumber\"}'),
(31,2,'bn_count_Rack_0fdc196f-20d2-4f63-9ddb-b75c165cc664','bn_count_Rack',12,0,4,3,'{\"color\":\"#f7d79a\",\"widgettype\":\"bigNumber\"}'),
(32,2,'bn_count_Phone_c31fde2d-510a-4482-b17d-2f65b61eae08','bn_count_Phone',16,3,4,3,'{\"color\":\"#a0cec2\",\"widgettype\":\"bigNumber\"}'),
(33,2,'bn_count_Enclosure_c21ce30a-58c3-456a-81ec-3c5f01527a8f','bn_count_Enclosure',16,0,4,3,'{\"color\":\"#d7e8e4\",\"widgettype\":\"bigNumber\"}'),
(34,2,'bn_count_NetworkEquipment_76f1e239-777b-4552-b053-ae5c64190347','bn_count_NetworkEquipment',8,0,4,3,'{\"color\":\"#c8dae4\",\"widgettype\":\"bigNumber\"}'),
(35,2,'bn_count_SoftwareLicense_576e58fe-a386-480f-b405-1c2315b8ab47','bn_count_SoftwareLicense',4,3,4,3,'{\"color\":\"#9bc06b\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(36,2,'bn_count_Monitor_890e16d3-b121-48c6-9713-d9c239d9a970','bn_count_Monitor',0,3,4,3,'{\"color\":\"#dc6f6f\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(37,2,'count_Computer_Manufacturer_986e92e8-32e8-4a6f-806f-6f5383acbb3f','count_Computer_Manufacturer',4,6,4,4,'{\"color\":\"#f3f5f1\",\"widgettype\":\"hbar\",\"use_gradient\":\"1\",\"limit\":\"5\"}'),
(38,2,'count_Computer_State_290c5920-9eab-4db8-8753-46108e60f1d8','count_Computer_State',0,6,4,4,'{\"color\":\"#fbf7f7\",\"widgettype\":\"donut\",\"use_gradient\":\"1\",\"limit\":\"5\"}'),
(39,2,'count_Computer_ComputerType_c58f9c7e-22d5-478b-8226-d2a752bcbb09','count_Computer_ComputerType',8,6,4,4,'{\"color\":\"#f5f9fa\",\"widgettype\":\"donut\",\"use_gradient\":\"1\",\"limit\":\"5\"}'),
(40,2,'count_NetworkEquipment_Manufacturer_8132b21c-6f7f-4dc1-af54-bea794cb96e9','count_NetworkEquipment_Manufacturer',12,6,4,4,'{\"color\":\"#fcf8ed\",\"widgettype\":\"hbar\",\"use_gradient\":\"0\",\"limit\":\"5\"}'),
(41,2,'count_Monitor_Manufacturer_43b0c16b-af82-418e-aac1-f32b39705c0d','count_Monitor_Manufacturer',16,6,4,4,'{\"color\":\"#f9fbfb\",\"widgettype\":\"donut\",\"use_gradient\":\"1\",\"limit\":\"5\"}'),
(42,3,'bn_count_Ticket_344e761b-f7e8-4617-8c90-154b266b4d67','bn_count_Ticket',0,0,3,2,'{\"color\":\"#ffdc64\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(43,3,'bn_count_Problem_bdb4002b-a674-4493-820f-af85bed44d2a','bn_count_Problem',0,4,3,2,'{\"color\":\"#f0967b\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(44,3,'bn_count_Change_b9b87513-4f40-41e6-8621-f51f9a30fb19','bn_count_Change',0,6,3,2,'{\"color\":\"#cae3c4\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(45,3,'bn_count_tickets_late_1e9ae481-21b4-4463-a830-dec1b68ec5e7','bn_count_tickets_late',0,2,3,2,'{\"color\":\"#f8911f\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(46,3,'bn_count_tickets_incoming_336a36d9-67fe-4475-880e-447bd766b8fe','bn_count_tickets_incoming',3,6,3,2,'{\"color\":\"#a0e19d\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(47,3,'bn_count_tickets_closed_e004bab5-f2b6-4060-a401-a2a8b9885245','bn_count_tickets_closed',9,8,3,2,'{\"color\":\"#515151\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(48,3,'bn_count_tickets_assigned_7455c855-6df8-4514-a3d9-8b0fce52bd63','bn_count_tickets_assigned',6,6,3,2,'{\"color\":\"#eaf5f7\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(49,3,'bn_count_tickets_solved_5e9759b3-ee7e-4a14-b68f-1ac024ef55ee','bn_count_tickets_solved',9,6,3,2,'{\"color\":\"#d8d8d8\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(50,3,'bn_count_tickets_waiting_102b2c2a-6ac6-4d73-ba47-8b09382fe00e','bn_count_tickets_waiting',3,8,3,2,'{\"color\":\"#ffcb7d\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(51,3,'bn_count_TicketRecurrent_13f79539-61f6-45f7-8dde-045706e652f2','bn_count_TicketRecurrent',0,8,3,2,'{\"color\":\"#fafafa\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(52,3,'bn_count_tickets_planned_267bf627-9d5e-4b6c-b53d-b8623d793ccf','bn_count_tickets_planned',6,8,3,2,'{\"color\":\"#6298d5\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(53,3,'top_ticket_ITILCategory_0cba0c84-6c62-4cd8-8564-18614498d8e4','top_ticket_ITILCategory',12,6,4,4,'{\"color\":\"#f1f5ef\",\"widgettype\":\"donut\",\"use_gradient\":\"1\",\"limit\":\"7\"}'),
(54,3,'top_ticket_RequestType_b9e43f34-8e94-4a6e-9023-c5d1e2ce7859','top_ticket_RequestType',16,6,4,4,'{\"color\":\"#f9fafb\",\"widgettype\":\"hbar\",\"use_gradient\":\"1\",\"limit\":\"4\"}'),
(55,3,'top_ticket_Entity_a8e65812-519c-488e-9892-9adbe22fbd5c','top_ticket_Entity',20,6,4,4,'{\"color\":\"#f7f1f0\",\"widgettype\":\"donut\",\"use_gradient\":\"1\",\"limit\":\"7\"}'),
(56,3,'ticket_evolution_76fd4926-ee5e-48db-b6d6-e2947c190c5e','ticket_evolution',3,0,12,6,'{\"color\":\"#f3f7f8\",\"widgettype\":\"areas\",\"use_gradient\":\"0\",\"limit\":\"12\"}'),
(57,3,'ticket_status_5b256a35-b36b-4db5-ba11-ea7c125f126e','ticket_status',15,0,11,6,'{\"color\":\"#f7f3f2\",\"widgettype\":\"stackedbars\",\"use_gradient\":\"0\",\"limit\":\"12\"}'),
(58,4,'bn_count_tickets_closed_ccf7246b-645a-40d2-8206-fa33c769e3f5','bn_count_tickets_closed',24,0,4,2,'{\"color\":\"#fafafa\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(59,4,'bn_count_Ticket_d5bf3576-5033-40fb-bbdb-292294a7698e','bn_count_Ticket',0,0,4,2,'{\"color\":\"#ffd957\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(60,4,'bn_count_tickets_incoming_055e813c-b0ce-4687-91ef-559249e8ddd8','bn_count_tickets_incoming',4,0,4,2,'{\"color\":\"#6fd169\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(61,4,'bn_count_tickets_waiting_793c665b-b620-4b3a-a5a8-cf502defc008','bn_count_tickets_waiting',8,0,4,2,'{\"color\":\"#ffcb7d\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(62,4,'bn_count_tickets_assigned_d3d2f697-52b4-435e-9030-a760dd649085','bn_count_tickets_assigned',12,0,4,2,'{\"color\":\"#eaf4f7\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(63,4,'bn_count_tickets_planned_0c7f3569-c23b-4ee3-8e85-279229b23e70','bn_count_tickets_planned',16,0,4,2,'{\"color\":\"#6298d5\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(64,4,'bn_count_tickets_solved_ae2406cf-e8e8-410b-b355-46e3f5705ee8','bn_count_tickets_solved',20,0,4,2,'{\"color\":\"#d7d7d7\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'),
(65,5,'plugin_formcreator_all_issues_5f5efad9-f068-48db-bbdc-42f207206f19','plugin_formcreator_all_issues',0,0,4,1,'{\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"point_labels\":\"0\",\"color\":\"#ffd957\"}'),
(66,5,'plugin_formcreator_incoming_issues_e94faa24-85f1-439d-86a3-8e7491b345e6','plugin_formcreator_incoming_issues',4,0,4,1,'{\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"point_labels\":\"0\",\"color\":\"#6fd169\"}'),
(67,5,'plugin_formcreator_assigned_issues_31c0e67c-29de-4f93-bccf-cdf84e3ac969','plugin_formcreator_assigned_issues',8,0,4,1,'{\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"point_labels\":\"0\",\"color\":\"#eaf4f7\"}'),
(68,5,'plugin_formcreator_waiting_issues_94bfd92a-7b4e-4db7-96af-beaa8338f793','plugin_formcreator_waiting_issues',12,0,4,1,'{\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"point_labels\":\"0\",\"color\":\"#ffcb7d\"}'),
(69,5,'plugin_formcreator_validate_issues_391e05c7-611f-4e1b-9b3a-4bc440576898','plugin_formcreator_validate_issues',16,0,4,1,'{\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"point_labels\":\"0\",\"color\":\"#6298d5\"}'),
(70,5,'plugin_formcreator_solved_issues_1a8a2eb7-5113-4609-b805-56198742b6da','plugin_formcreator_solved_issues',20,0,4,1,'{\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"point_labels\":\"0\",\"color\":\"#d7d7d7\"}'),
(71,5,'plugin_formcreator_closed_issues_2c5e0477-87a0-4387-85b0-4de6ff2e2040','plugin_formcreator_closed_issues',24,0,4,1,'{\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"point_labels\":\"0\",\"color\":\"#515151\"}');

--
-- Table structure for table `glpi_dashboards_rights`
--

CREATE TABLE `glpi_dashboards_rights` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dashboards_dashboards_id` int(10) unsigned NOT NULL,
  `itemtype` varchar(100) NOT NULL,
  `items_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`dashboards_dashboards_id`,`itemtype`,`items_id`),
  KEY `item` (`itemtype`,`items_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_dashboards_rights`
--

INSERT INTO `glpi_dashboards_rights` VALUES
(1,5,'Profile',1);

--
-- Table structure for table `glpi_databaseinstancecategories`
--

CREATE TABLE `glpi_databaseinstancecategories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_databaseinstancecategories`
--


--
-- Table structure for table `glpi_databaseinstances`
--

CREATE TABLE `glpi_databaseinstances` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL DEFAULT '',
  `version` varchar(255) NOT NULL DEFAULT '',
  `port` varchar(10) NOT NULL DEFAULT '',
  `path` varchar(255) NOT NULL DEFAULT '',
  `size` int(11) NOT NULL DEFAULT 0,
  `databaseinstancetypes_id` int(10) unsigned NOT NULL DEFAULT 0,
  `databaseinstancecategories_id` int(10) unsigned NOT NULL DEFAULT 0,
  `locations_id` int(10) unsigned NOT NULL DEFAULT 0,
  `manufacturers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `users_id_tech` int(10) unsigned NOT NULL DEFAULT 0,
  `groups_id_tech` int(10) unsigned NOT NULL DEFAULT 0,
  `states_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(100) NOT NULL DEFAULT '',
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_onbackup` tinyint(4) NOT NULL DEFAULT 0,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `is_helpdesk_visible` tinyint(4) NOT NULL DEFAULT 1,
  `is_dynamic` tinyint(4) NOT NULL DEFAULT 0,
  `autoupdatesystems_id` int(10) unsigned NOT NULL DEFAULT 0,
  `date_creation` timestamp NULL DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_lastboot` timestamp NULL DEFAULT NULL,
  `date_lastbackup` timestamp NULL DEFAULT NULL,
  `comment` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `name` (`name`),
  KEY `databaseinstancetypes_id` (`databaseinstancetypes_id`),
  KEY `databaseinstancecategories_id` (`databaseinstancecategories_id`),
  KEY `locations_id` (`locations_id`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `users_id_tech` (`users_id_tech`),
  KEY `groups_id_tech` (`groups_id_tech`),
  KEY `states_id` (`states_id`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `is_active` (`is_active`),
  KEY `is_deleted` (`is_deleted`),
  KEY `date_creation` (`date_creation`),
  KEY `date_mod` (`date_mod`),
  KEY `is_helpdesk_visible` (`is_helpdesk_visible`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `autoupdatesystems_id` (`autoupdatesystems_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_databaseinstances`
--


--
-- Table structure for table `glpi_databaseinstancetypes`
--

CREATE TABLE `glpi_databaseinstancetypes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_databaseinstancetypes`
--


--
-- Table structure for table `glpi_databases`
--

CREATE TABLE `glpi_databases` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL DEFAULT '',
  `size` int(11) NOT NULL DEFAULT 0,
  `databaseinstances_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_onbackup` tinyint(4) NOT NULL DEFAULT 0,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `is_dynamic` tinyint(4) NOT NULL DEFAULT 0,
  `date_creation` timestamp NULL DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_update` timestamp NULL DEFAULT NULL,
  `date_lastbackup` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `name` (`name`),
  KEY `is_active` (`is_active`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `date_creation` (`date_creation`),
  KEY `date_mod` (`date_mod`),
  KEY `databaseinstances_id` (`databaseinstances_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_databases`
--


--
-- Table structure for table `glpi_datacenters`
--

CREATE TABLE `glpi_datacenters` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `locations_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `pictures` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `locations_id` (`locations_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_datacenters`
--


--
-- Table structure for table `glpi_dcrooms`
--

CREATE TABLE `glpi_dcrooms` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `locations_id` int(10) unsigned NOT NULL DEFAULT 0,
  `vis_cols` int(11) DEFAULT NULL,
  `vis_rows` int(11) DEFAULT NULL,
  `blueprint` text DEFAULT NULL,
  `datacenters_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `locations_id` (`locations_id`),
  KEY `datacenters_id` (`datacenters_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_dcrooms`
--


--
-- Table structure for table `glpi_devicebatteries`
--

CREATE TABLE `glpi_devicebatteries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `manufacturers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `voltage` int(11) DEFAULT NULL,
  `capacity` int(11) DEFAULT NULL,
  `devicebatterytypes_id` int(10) unsigned NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `devicebatterymodels_id` int(10) unsigned DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicebatterymodels_id` (`devicebatterymodels_id`),
  KEY `devicebatterytypes_id` (`devicebatterytypes_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicebatteries`
--


--
-- Table structure for table `glpi_devicebatterymodels`
--

CREATE TABLE `glpi_devicebatterymodels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `product_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicebatterymodels`
--


--
-- Table structure for table `glpi_devicebatterytypes`
--

CREATE TABLE `glpi_devicebatterytypes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicebatterytypes`
--


--
-- Table structure for table `glpi_devicecameramodels`
--

CREATE TABLE `glpi_devicecameramodels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `product_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicecameramodels`
--


--
-- Table structure for table `glpi_devicecameras`
--

CREATE TABLE `glpi_devicecameras` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) DEFAULT NULL,
  `flashunit` tinyint(4) NOT NULL DEFAULT 0,
  `lensfacing` varchar(255) DEFAULT NULL,
  `orientation` varchar(255) DEFAULT NULL,
  `focallength` varchar(255) DEFAULT NULL,
  `sensorsize` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `manufacturers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `devicecameramodels_id` int(10) unsigned DEFAULT NULL,
  `support` varchar(255) DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `devicecameramodels_id` (`devicecameramodels_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicecameras`
--


--
-- Table structure for table `glpi_devicecasemodels`
--

CREATE TABLE `glpi_devicecasemodels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `product_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicecasemodels`
--


--
-- Table structure for table `glpi_devicecases`
--

CREATE TABLE `glpi_devicecases` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) DEFAULT NULL,
  `devicecasetypes_id` int(10) unsigned NOT NULL DEFAULT 0,
  `comment` text DEFAULT NULL,
  `manufacturers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `devicecasemodels_id` int(10) unsigned DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `devicecasetypes_id` (`devicecasetypes_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicecasemodels_id` (`devicecasemodels_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicecases`
--


--
-- Table structure for table `glpi_devicecasetypes`
--

CREATE TABLE `glpi_devicecasetypes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicecasetypes`
--


--
-- Table structure for table `glpi_devicecontrolmodels`
--

CREATE TABLE `glpi_devicecontrolmodels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `product_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicecontrolmodels`
--


--
-- Table structure for table `glpi_devicecontrols`
--

CREATE TABLE `glpi_devicecontrols` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) DEFAULT NULL,
  `is_raid` tinyint(4) NOT NULL DEFAULT 0,
  `comment` text DEFAULT NULL,
  `manufacturers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `interfacetypes_id` int(10) unsigned NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `devicecontrolmodels_id` int(10) unsigned DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `interfacetypes_id` (`interfacetypes_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicecontrolmodels_id` (`devicecontrolmodels_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicecontrols`
--


--
-- Table structure for table `glpi_devicedrivemodels`
--

CREATE TABLE `glpi_devicedrivemodels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `product_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicedrivemodels`
--


--
-- Table structure for table `glpi_devicedrives`
--

CREATE TABLE `glpi_devicedrives` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) DEFAULT NULL,
  `is_writer` tinyint(4) NOT NULL DEFAULT 1,
  `speed` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `manufacturers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `interfacetypes_id` int(10) unsigned NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `devicedrivemodels_id` int(10) unsigned DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `interfacetypes_id` (`interfacetypes_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicedrivemodels_id` (`devicedrivemodels_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicedrives`
--


--
-- Table structure for table `glpi_devicefirmwaremodels`
--

CREATE TABLE `glpi_devicefirmwaremodels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `product_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicefirmwaremodels`
--


--
-- Table structure for table `glpi_devicefirmwares`
--

CREATE TABLE `glpi_devicefirmwares` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `manufacturers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `date` date DEFAULT NULL,
  `version` varchar(255) DEFAULT NULL,
  `devicefirmwaretypes_id` int(10) unsigned NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `devicefirmwaremodels_id` int(10) unsigned DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicefirmwaremodels_id` (`devicefirmwaremodels_id`),
  KEY `devicefirmwaretypes_id` (`devicefirmwaretypes_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicefirmwares`
--


--
-- Table structure for table `glpi_devicefirmwaretypes`
--

CREATE TABLE `glpi_devicefirmwaretypes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicefirmwaretypes`
--

INSERT INTO `glpi_devicefirmwaretypes` VALUES
(1,'BIOS',NULL,NULL,NULL),
(2,'UEFI',NULL,NULL,NULL),
(3,'Firmware',NULL,NULL,NULL);

--
-- Table structure for table `glpi_devicegenericmodels`
--

CREATE TABLE `glpi_devicegenericmodels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `product_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicegenericmodels`
--


--
-- Table structure for table `glpi_devicegenerics`
--

CREATE TABLE `glpi_devicegenerics` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) DEFAULT NULL,
  `devicegenerictypes_id` int(10) unsigned NOT NULL DEFAULT 0,
  `comment` text DEFAULT NULL,
  `manufacturers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `locations_id` int(10) unsigned NOT NULL DEFAULT 0,
  `states_id` int(10) unsigned NOT NULL DEFAULT 0,
  `devicegenericmodels_id` int(10) unsigned DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `devicegenerictypes_id` (`devicegenerictypes_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `locations_id` (`locations_id`),
  KEY `states_id` (`states_id`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicegenericmodels_id` (`devicegenericmodels_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicegenerics`
--


--
-- Table structure for table `glpi_devicegenerictypes`
--

CREATE TABLE `glpi_devicegenerictypes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicegenerictypes`
--


--
-- Table structure for table `glpi_devicegraphiccardmodels`
--

CREATE TABLE `glpi_devicegraphiccardmodels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `product_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicegraphiccardmodels`
--


--
-- Table structure for table `glpi_devicegraphiccards`
--

CREATE TABLE `glpi_devicegraphiccards` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) DEFAULT NULL,
  `interfacetypes_id` int(10) unsigned NOT NULL DEFAULT 0,
  `comment` text DEFAULT NULL,
  `manufacturers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `memory_default` int(11) NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `devicegraphiccardmodels_id` int(10) unsigned DEFAULT NULL,
  `chipset` varchar(255) DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `interfacetypes_id` (`interfacetypes_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `chipset` (`chipset`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicegraphiccardmodels_id` (`devicegraphiccardmodels_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicegraphiccards`
--


--
-- Table structure for table `glpi_deviceharddrivemodels`
--

CREATE TABLE `glpi_deviceharddrivemodels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `product_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_deviceharddrivemodels`
--


--
-- Table structure for table `glpi_deviceharddrives`
--

CREATE TABLE `glpi_deviceharddrives` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) DEFAULT NULL,
  `rpm` varchar(255) DEFAULT NULL,
  `interfacetypes_id` int(10) unsigned NOT NULL DEFAULT 0,
  `cache` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `manufacturers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `capacity_default` int(11) NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `deviceharddrivemodels_id` int(10) unsigned DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `interfacetypes_id` (`interfacetypes_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `deviceharddrivemodels_id` (`deviceharddrivemodels_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_deviceharddrives`
--


--
-- Table structure for table `glpi_devicememories`
--

CREATE TABLE `glpi_devicememories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) DEFAULT NULL,
  `frequence` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `manufacturers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `size_default` int(11) NOT NULL DEFAULT 0,
  `devicememorytypes_id` int(10) unsigned NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `devicememorymodels_id` int(10) unsigned DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `devicememorytypes_id` (`devicememorytypes_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicememorymodels_id` (`devicememorymodels_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicememories`
--


--
-- Table structure for table `glpi_devicememorymodels`
--

CREATE TABLE `glpi_devicememorymodels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `product_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicememorymodels`
--


--
-- Table structure for table `glpi_devicememorytypes`
--

CREATE TABLE `glpi_devicememorytypes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicememorytypes`
--

INSERT INTO `glpi_devicememorytypes` VALUES
(1,'EDO',NULL,NULL,NULL),
(2,'DDR',NULL,NULL,NULL),
(3,'SDRAM',NULL,NULL,NULL),
(4,'SDRAM-2',NULL,NULL,NULL);

--
-- Table structure for table `glpi_devicemotherboardmodels`
--

CREATE TABLE `glpi_devicemotherboardmodels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `product_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicemotherboardmodels`
--


--
-- Table structure for table `glpi_devicemotherboards`
--

CREATE TABLE `glpi_devicemotherboards` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) DEFAULT NULL,
  `chipset` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `manufacturers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `devicemotherboardmodels_id` int(10) unsigned DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicemotherboardmodels_id` (`devicemotherboardmodels_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicemotherboards`
--


--
-- Table structure for table `glpi_devicenetworkcardmodels`
--

CREATE TABLE `glpi_devicenetworkcardmodels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `product_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicenetworkcardmodels`
--


--
-- Table structure for table `glpi_devicenetworkcards`
--

CREATE TABLE `glpi_devicenetworkcards` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) DEFAULT NULL,
  `bandwidth` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `manufacturers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `mac_default` varchar(255) DEFAULT NULL,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `devicenetworkcardmodels_id` int(10) unsigned DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicenetworkcardmodels_id` (`devicenetworkcardmodels_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicenetworkcards`
--


--
-- Table structure for table `glpi_devicepcimodels`
--

CREATE TABLE `glpi_devicepcimodels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `product_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicepcimodels`
--


--
-- Table structure for table `glpi_devicepcis`
--

CREATE TABLE `glpi_devicepcis` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `manufacturers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `devicenetworkcardmodels_id` int(10) unsigned NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `devicepcimodels_id` int(10) unsigned DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `devicenetworkcardmodels_id` (`devicenetworkcardmodels_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicepcimodels_id` (`devicepcimodels_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicepcis`
--


--
-- Table structure for table `glpi_devicepowersupplies`
--

CREATE TABLE `glpi_devicepowersupplies` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) DEFAULT NULL,
  `power` varchar(255) DEFAULT NULL,
  `is_atx` tinyint(4) NOT NULL DEFAULT 1,
  `comment` text DEFAULT NULL,
  `manufacturers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `devicepowersupplymodels_id` int(10) unsigned DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicepowersupplymodels_id` (`devicepowersupplymodels_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicepowersupplies`
--


--
-- Table structure for table `glpi_devicepowersupplymodels`
--

CREATE TABLE `glpi_devicepowersupplymodels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `product_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicepowersupplymodels`
--


--
-- Table structure for table `glpi_deviceprocessormodels`
--

CREATE TABLE `glpi_deviceprocessormodels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `product_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_deviceprocessormodels`
--


--
-- Table structure for table `glpi_deviceprocessors`
--

CREATE TABLE `glpi_deviceprocessors` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) DEFAULT NULL,
  `frequence` int(11) NOT NULL DEFAULT 0,
  `comment` text DEFAULT NULL,
  `manufacturers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `frequency_default` int(11) NOT NULL DEFAULT 0,
  `nbcores_default` int(11) DEFAULT NULL,
  `nbthreads_default` int(11) DEFAULT NULL,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `deviceprocessormodels_id` int(10) unsigned DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `deviceprocessormodels_id` (`deviceprocessormodels_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_deviceprocessors`
--


--
-- Table structure for table `glpi_devicesensormodels`
--

CREATE TABLE `glpi_devicesensormodels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `product_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicesensormodels`
--


--
-- Table structure for table `glpi_devicesensors`
--

CREATE TABLE `glpi_devicesensors` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) DEFAULT NULL,
  `devicesensortypes_id` int(10) unsigned NOT NULL DEFAULT 0,
  `devicesensormodels_id` int(10) unsigned NOT NULL DEFAULT 0,
  `comment` text DEFAULT NULL,
  `manufacturers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `locations_id` int(10) unsigned NOT NULL DEFAULT 0,
  `states_id` int(10) unsigned NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `devicesensortypes_id` (`devicesensortypes_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `locations_id` (`locations_id`),
  KEY `states_id` (`states_id`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicesensormodels_id` (`devicesensormodels_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicesensors`
--


--
-- Table structure for table `glpi_devicesensortypes`
--

CREATE TABLE `glpi_devicesensortypes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicesensortypes`
--


--
-- Table structure for table `glpi_devicesimcards`
--

CREATE TABLE `glpi_devicesimcards` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `manufacturers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `voltage` int(11) DEFAULT NULL,
  `devicesimcardtypes_id` int(10) unsigned NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `allow_voip` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `devicesimcardtypes_id` (`devicesimcardtypes_id`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `manufacturers_id` (`manufacturers_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicesimcards`
--


--
-- Table structure for table `glpi_devicesimcardtypes`
--

CREATE TABLE `glpi_devicesimcardtypes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `comment` text DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicesimcardtypes`
--

INSERT INTO `glpi_devicesimcardtypes` VALUES
(1,'Full SIM',NULL,NULL,NULL),
(2,'Mini SIM',NULL,NULL,NULL),
(3,'Micro SIM',NULL,NULL,NULL),
(4,'Nano SIM',NULL,NULL,NULL);

--
-- Table structure for table `glpi_devicesoundcardmodels`
--

CREATE TABLE `glpi_devicesoundcardmodels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `product_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicesoundcardmodels`
--


--
-- Table structure for table `glpi_devicesoundcards`
--

CREATE TABLE `glpi_devicesoundcards` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `manufacturers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `devicesoundcardmodels_id` int(10) unsigned DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicesoundcardmodels_id` (`devicesoundcardmodels_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_devicesoundcards`
--


--
-- Table structure for table `glpi_displaypreferences`
--

CREATE TABLE `glpi_displaypreferences` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `itemtype` varchar(100) NOT NULL,
  `num` int(11) NOT NULL DEFAULT 0,
  `rank` int(11) NOT NULL DEFAULT 0,
  `users_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`users_id`,`itemtype`,`num`),
  KEY `rank` (`rank`),
  KEY `num` (`num`),
  KEY `itemtype` (`itemtype`)
) ENGINE=InnoDB AUTO_INCREMENT=326 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_displaypreferences`
--

INSERT INTO `glpi_displaypreferences` VALUES
(1,'Computer',4,4,0),
(2,'Computer',45,6,0),
(3,'Computer',40,5,0),
(4,'Computer',5,3,0),
(5,'Computer',23,2,0),
(6,'DocumentType',3,1,0),
(7,'Monitor',31,1,0),
(8,'Monitor',23,2,0),
(9,'Monitor',3,3,0),
(10,'Monitor',4,4,0),
(11,'Printer',31,1,0),
(12,'NetworkEquipment',31,1,0),
(13,'NetworkEquipment',23,2,0),
(14,'Printer',23,2,0),
(15,'Printer',3,3,0),
(16,'Software',4,3,0),
(17,'Software',5,2,0),
(18,'Software',23,1,0),
(19,'CartridgeItem',4,2,0),
(20,'CartridgeItem',34,1,0),
(21,'Peripheral',3,3,0),
(22,'Peripheral',23,2,0),
(23,'Peripheral',31,1,0),
(24,'Computer',31,1,0),
(25,'Computer',3,7,0),
(26,'Computer',19,8,0),
(27,'Computer',17,9,0),
(28,'NetworkEquipment',3,3,0),
(29,'NetworkEquipment',4,4,0),
(30,'NetworkEquipment',11,6,0),
(31,'NetworkEquipment',19,7,0),
(32,'Printer',4,4,0),
(33,'Printer',19,6,0),
(34,'Monitor',19,6,0),
(35,'Monitor',7,7,0),
(36,'Peripheral',4,4,0),
(37,'Peripheral',19,6,0),
(38,'Peripheral',7,7,0),
(39,'Contact',3,1,0),
(40,'Contact',4,2,0),
(41,'Contact',5,3,0),
(42,'Contact',6,4,0),
(43,'Contact',9,5,0),
(44,'Supplier',9,1,0),
(45,'Supplier',3,2,0),
(46,'Supplier',4,3,0),
(47,'Supplier',5,4,0),
(48,'Supplier',10,5,0),
(49,'Supplier',6,6,0),
(50,'Contract',4,1,0),
(51,'Contract',3,2,0),
(52,'Contract',5,3,0),
(53,'Contract',6,4,0),
(54,'Contract',7,5,0),
(55,'Contract',11,6,0),
(56,'CartridgeItem',23,3,0),
(57,'CartridgeItem',3,4,0),
(58,'DocumentType',6,2,0),
(59,'DocumentType',4,3,0),
(60,'DocumentType',5,4,0),
(61,'Document',3,1,0),
(62,'Document',4,2,0),
(63,'Document',7,3,0),
(64,'Document',5,4,0),
(65,'Document',16,5,0),
(66,'User',34,1,0),
(67,'User',5,3,0),
(68,'User',6,4,0),
(69,'User',3,5,0),
(70,'ConsumableItem',34,1,0),
(71,'ConsumableItem',4,2,0),
(72,'ConsumableItem',23,3,0),
(73,'ConsumableItem',3,4,0),
(74,'NetworkEquipment',40,5,0),
(75,'Printer',40,5,0),
(76,'Monitor',40,5,0),
(77,'Peripheral',40,5,0),
(78,'User',8,6,0),
(79,'Phone',31,1,0),
(80,'Phone',23,2,0),
(81,'Phone',3,3,0),
(82,'Phone',4,4,0),
(83,'Phone',40,5,0),
(84,'Phone',19,6,0),
(85,'Phone',7,7,0),
(86,'Group',16,1,0),
(87,'AllAssets',31,1,0),
(88,'ReservationItem',4,1,0),
(89,'ReservationItem',3,2,0),
(90,'Budget',3,2,0),
(91,'Software',72,4,0),
(92,'Software',163,5,0),
(93,'Budget',5,1,0),
(94,'Budget',4,3,0),
(95,'Budget',19,4,0),
(96,'CronTask',8,1,0),
(97,'CronTask',3,2,0),
(98,'CronTask',4,3,0),
(99,'CronTask',7,4,0),
(100,'RequestType',14,1,0),
(101,'RequestType',15,2,0),
(102,'NotificationTemplate',4,1,0),
(103,'NotificationTemplate',16,2,0),
(104,'Notification',5,1,0),
(105,'Notification',6,2,0),
(106,'Notification',2,3,0),
(107,'Notification',4,4,0),
(108,'Notification',80,5,0),
(109,'Notification',86,6,0),
(110,'MailCollector',2,1,0),
(111,'MailCollector',19,2,0),
(112,'AuthLDAP',3,1,0),
(113,'AuthLDAP',19,2,0),
(114,'AuthMail',3,1,0),
(115,'AuthMail',19,2,0),
(116,'IPNetwork',18,1,0),
(117,'WifiNetwork',10,1,0),
(118,'Profile',2,1,0),
(119,'Profile',3,2,0),
(120,'Profile',19,3,0),
(121,'Transfer',19,1,0),
(122,'TicketValidation',3,1,0),
(123,'TicketValidation',2,2,0),
(124,'TicketValidation',8,3,0),
(125,'TicketValidation',4,4,0),
(126,'TicketValidation',9,5,0),
(127,'TicketValidation',7,6,0),
(128,'NotImportedEmail',2,1,0),
(129,'NotImportedEmail',5,2,0),
(130,'NotImportedEmail',4,3,0),
(131,'NotImportedEmail',6,4,0),
(132,'NotImportedEmail',16,5,0),
(133,'NotImportedEmail',19,6,0),
(134,'RuleRightParameter',11,1,0),
(135,'Ticket',12,1,0),
(136,'Ticket',19,2,0),
(137,'Ticket',15,3,0),
(138,'Ticket',3,4,0),
(139,'Ticket',4,5,0),
(140,'Ticket',5,6,0),
(141,'Ticket',7,7,0),
(142,'Calendar',19,1,0),
(143,'Holiday',11,1,0),
(144,'Holiday',12,2,0),
(145,'Holiday',13,3,0),
(146,'SLA',4,1,0),
(147,'Ticket',18,8,0),
(148,'AuthLDAP',30,3,0),
(149,'AuthMail',6,3,0),
(150,'FQDN',11,1,0),
(151,'FieldUnicity',1,1,0),
(152,'FieldUnicity',80,2,0),
(153,'FieldUnicity',4,3,0),
(154,'FieldUnicity',3,4,0),
(155,'FieldUnicity',86,5,0),
(156,'FieldUnicity',30,6,0),
(157,'Problem',21,1,0),
(158,'Problem',12,2,0),
(159,'Problem',19,3,0),
(160,'Problem',15,4,0),
(161,'Problem',3,5,0),
(162,'Problem',7,6,0),
(163,'Problem',18,7,0),
(164,'Vlan',11,1,0),
(165,'TicketRecurrent',11,1,0),
(166,'TicketRecurrent',12,2,0),
(167,'TicketRecurrent',13,3,0),
(168,'TicketRecurrent',15,4,0),
(169,'TicketRecurrent',14,5,0),
(170,'Reminder',2,1,0),
(171,'Reminder',3,2,0),
(172,'Reminder',4,3,0),
(173,'Reminder',5,4,0),
(174,'Reminder',6,5,0),
(175,'Reminder',7,6,0),
(176,'IPNetwork',10,2,0),
(177,'IPNetwork',11,3,0),
(178,'IPNetwork',12,4,0),
(179,'IPNetwork',17,5,0),
(180,'NetworkName',12,1,0),
(181,'NetworkName',13,2,0),
(182,'RSSFeed',2,1,0),
(183,'RSSFeed',4,2,0),
(184,'RSSFeed',5,3,0),
(185,'RSSFeed',19,4,0),
(186,'RSSFeed',6,5,0),
(187,'RSSFeed',7,6,0),
(188,'Blacklist',12,1,0),
(189,'Blacklist',11,2,0),
(190,'ReservationItem',5,3,0),
(191,'QueuedNotification',16,1,0),
(192,'QueuedNotification',7,2,0),
(193,'QueuedNotification',20,3,0),
(194,'QueuedNotification',21,4,0),
(195,'QueuedNotification',22,5,0),
(196,'QueuedNotification',15,6,0),
(197,'Change',12,1,0),
(198,'Change',19,2,0),
(199,'Change',15,3,0),
(200,'Change',7,4,0),
(201,'Change',18,5,0),
(202,'Project',3,1,0),
(203,'Project',4,2,0),
(204,'Project',12,3,0),
(205,'Project',5,4,0),
(206,'Project',15,5,0),
(207,'Project',21,6,0),
(208,'ProjectState',12,1,0),
(209,'ProjectState',11,2,0),
(210,'ProjectTask',2,1,0),
(211,'ProjectTask',12,2,0),
(212,'ProjectTask',14,3,0),
(213,'ProjectTask',5,4,0),
(214,'ProjectTask',7,5,0),
(215,'ProjectTask',8,6,0),
(216,'ProjectTask',13,7,0),
(217,'CartridgeItem',9,5,0),
(218,'ConsumableItem',9,5,0),
(219,'ReservationItem',9,4,0),
(220,'SoftwareLicense',1,1,0),
(221,'SoftwareLicense',3,2,0),
(222,'SoftwareLicense',10,3,0),
(223,'SoftwareLicense',162,4,0),
(224,'SoftwareLicense',5,5,0),
(225,'SavedSearch',8,1,0),
(226,'SavedSearch',9,1,0),
(227,'SavedSearch',3,1,0),
(228,'SavedSearch',10,1,0),
(229,'SavedSearch',11,1,0),
(230,'Plugin',2,1,0),
(231,'Plugin',3,2,0),
(232,'Plugin',4,3,0),
(233,'Plugin',5,4,0),
(234,'Plugin',6,5,0),
(235,'Plugin',7,6,0),
(236,'Plugin',8,7,0),
(237,'Cluster',31,1,0),
(238,'Cluster',19,2,0),
(239,'Domain',3,1,0),
(240,'Domain',4,2,0),
(241,'Domain',2,3,0),
(242,'Domain',6,4,0),
(243,'Domain',7,5,0),
(244,'DomainRecord',2,1,0),
(245,'DomainRecord',3,2,0),
(246,'Appliance',2,1,0),
(247,'Appliance',3,2,0),
(248,'Appliance',4,3,0),
(249,'Appliance',5,4,0),
(250,'Lockedfield',3,1,0),
(251,'Lockedfield',13,2,0),
(252,'Lockedfield',5,3,0),
(253,'Unmanaged',2,1,0),
(254,'Unmanaged',4,2,0),
(255,'Unmanaged',3,3,0),
(256,'Unmanaged',5,4,0),
(257,'Unmanaged',7,5,0),
(258,'Unmanaged',10,6,0),
(259,'Unmanaged',18,7,0),
(260,'Unmanaged',14,8,0),
(261,'Unmanaged',15,9,0),
(262,'Unmanaged',9,10,0),
(263,'NetworkPortType',10,1,0),
(264,'NetworkPortType',11,2,0),
(265,'NetworkPortType',12,3,0),
(266,'NetworkPort',3,1,0),
(267,'NetworkPort',30,2,0),
(268,'NetworkPort',31,3,0),
(269,'NetworkPort',32,4,0),
(270,'NetworkPort',33,5,0),
(271,'NetworkPort',34,6,0),
(272,'NetworkPort',35,7,0),
(273,'NetworkPort',36,8,0),
(274,'NetworkPort',38,9,0),
(275,'NetworkPort',39,10,0),
(276,'NetworkPort',40,11,0),
(277,'NetworkPort',6,12,0),
(278,'USBVendor',10,1,0),
(279,'USBVendor',11,2,0),
(280,'PCIVendor',10,1,0),
(281,'PCIVendor',11,2,0),
(282,'Agent',2,1,0),
(283,'Agent',4,2,0),
(284,'Agent',10,3,0),
(285,'Agent',8,4,0),
(286,'Agent',11,5,0),
(287,'Agent',6,6,0),
(288,'Agent',15,7,0),
(289,'Database',2,1,0),
(290,'Database',3,2,0),
(291,'Database',6,3,0),
(292,'Database',9,4,0),
(293,'Database',10,5,0),
(294,'Glpi\\Socket',5,1,0),
(295,'Glpi\\Socket',6,2,0),
(296,'Glpi\\Socket',9,3,0),
(297,'Glpi\\Socket',8,4,0),
(298,'Glpi\\Socket',7,5,0),
(299,'Cable',4,1,0),
(300,'Cable',31,2,0),
(301,'Cable',6,3,0),
(302,'Cable',15,4,0),
(303,'Cable',24,5,0),
(304,'Cable',8,6,0),
(305,'Cable',10,7,0),
(306,'Cable',13,8,0),
(307,'Cable',14,9,0),
(308,'PluginFormcreatorFormAnswer',2,1,0),
(309,'PluginFormcreatorFormAnswer',3,2,0),
(310,'PluginFormcreatorFormAnswer',4,3,0),
(311,'PluginFormcreatorFormAnswer',5,4,0),
(312,'PluginFormcreatorFormAnswer',6,5,0),
(313,'PluginFormcreatorForm',30,1,0),
(314,'PluginFormcreatorForm',3,2,0),
(315,'PluginFormcreatorForm',10,3,0),
(316,'PluginFormcreatorForm',7,4,0),
(317,'PluginFormcreatorForm',8,5,0),
(318,'PluginFormcreatorForm',9,6,0),
(319,'PluginFormcreatorIssue',1,1,0),
(320,'PluginFormcreatorIssue',2,2,0),
(321,'PluginFormcreatorIssue',4,3,0),
(322,'PluginFormcreatorIssue',5,4,0),
(323,'PluginFormcreatorIssue',6,5,0),
(324,'PluginFormcreatorIssue',7,6,0),
(325,'PluginFormcreatorIssue',8,7,0);

--
-- Table structure for table `glpi_documentcategories`
--

CREATE TABLE `glpi_documentcategories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `documentcategories_id` int(10) unsigned NOT NULL DEFAULT 0,
  `completename` text DEFAULT NULL,
  `level` int(11) NOT NULL DEFAULT 0,
  `ancestors_cache` longtext DEFAULT NULL,
  `sons_cache` longtext DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`documentcategories_id`,`name`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `level` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_documentcategories`
--


--
-- Table structure for table `glpi_documents`
--

CREATE TABLE `glpi_documents` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `name` varchar(255) DEFAULT NULL,
  `filename` varchar(255) DEFAULT NULL COMMENT 'for display and transfert',
  `filepath` varchar(255) DEFAULT NULL COMMENT 'file storage path',
  `documentcategories_id` int(10) unsigned NOT NULL DEFAULT 0,
  `mime` varchar(255) DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `link` varchar(255) DEFAULT NULL,
  `users_id` int(10) unsigned NOT NULL DEFAULT 0,
  `tickets_id` int(10) unsigned NOT NULL DEFAULT 0,
  `sha1sum` char(40) DEFAULT NULL,
  `is_blacklisted` tinyint(4) NOT NULL DEFAULT 0,
  `tag` varchar(255) DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `date_mod` (`date_mod`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `tickets_id` (`tickets_id`),
  KEY `users_id` (`users_id`),
  KEY `documentcategories_id` (`documentcategories_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `sha1sum` (`sha1sum`),
  KEY `tag` (`tag`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_documents`
--

INSERT INTO `glpi_documents` VALUES
(2,0,0,'Captura de tela 2024-10-12 135656.png','Captura de tela 2024-10-12 135656.png','PNG/98/80b6509f1ade45950305ac29dfe21689d0f82a.PNG',0,'image/png','2024-12-27 21:50:35',NULL,0,NULL,9,0,'9880b6509f1ade45950305ac29dfe21689d0f82a',0,'a90d2f74-b2d8e96f-676f212966e4e4.61149696','2024-12-27 21:50:35'),
(3,2,0,'image_paste385457.png','image_paste385457.png','PNG/65/4eb4ca3d8815ba8a26c42442eab13d30377058.PNG',0,'image/png','2025-01-08 12:22:46',NULL,0,NULL,8,0,'654eb4ca3d8815ba8a26c42442eab13d30377058',0,'a90d2f74-b2d8e96f-677e6e1328a539.57982140','2025-01-08 12:22:46'),
(4,2,0,'Documento do Chamado 20','c4beb9d1-fc2a-4c23-9f7d-ec4a685aa186.jpg','JPG/7b/d074fd4b5ae1b61bfb0f7f80b1d8cd3552d6a8.JPG',0,'image/jpeg','2025-01-08 13:21:24',NULL,0,NULL,9,20,'7bd074fd4b5ae1b61bfb0f7f80b1d8cd3552d6a8',0,'a90d2f74-b2d8e96f-677e7ba7547881.32930555','2025-01-08 13:21:24'),
(5,2,0,'image_paste3806864.png','image_paste3806864.png','PNG/6b/a9795f160a3b440c156cd572139a713ca3356d.PNG',0,'image/png','2025-01-08 20:42:42',NULL,0,NULL,8,0,'6ba9795f160a3b440c156cd572139a713ca3356d',0,'a90d2f74-b2d8e96f-677ee33eea06f3.33393595','2025-01-08 20:42:42'),
(6,2,0,'Documento do Chamado 23','Captura de tela 2025-01-09 150116.png','PNG/fa/40d0e14d4369846fe4fdec22396dcf37e9a9e6.PNG',0,'image/png','2025-01-09 18:02:47',NULL,0,NULL,9,23,'fa40d0e14d4369846fe4fdec22396dcf37e9a9e6',0,'796eb77d-b2d8e96f-67800f42ba6863.01754748','2025-01-09 18:02:47'),
(7,2,0,'Documento do Chamado 28','BARRA DE PESQUISA.png','PNG/46/b25fff75cb101fdbcd15e60158bd18d1327165.PNG',0,'image/png','2025-01-13 12:35:41',NULL,0,NULL,9,28,'46b25fff75cb101fdbcd15e60158bd18d1327165',0,'796eb77d-b2d8e96f-67850893880fb6.37189512','2025-01-13 12:35:41'),
(8,2,1,'62bc835aafc688.68301584image_paste1933703.png','image_paste.png','PNG/44/242ad020bd97bc5af24b4de962b5e9f9c82463.PNG',0,'image/png','2025-01-16 00:52:50',NULL,0,NULL,9,0,'44242ad020bd97bc5af24b4de962b5e9f9c82463',0,'796eb77d-b2d8e96f-67885852aec4f6.00664803','2025-01-16 00:52:50'),
(9,2,0,'image_paste1287054.png','image_paste1287054.png','PNG/9d/a677645e2a56605872cad133cbc3add0642e7a.PNG',0,'image/png','2025-01-16 13:14:20',NULL,0,NULL,8,0,'9da677645e2a56605872cad133cbc3add0642e7a',0,'796eb77d-b2d8e96f-67890626156559.26126155','2025-01-16 13:14:20'),
(10,2,1,'62c23c156bed8c.39372227image_paste6345625.png','image_paste.png','PNG/51/3f27413e944a9aecb2cf30115df7b6ff4baa77.PNG',0,'image/png','2025-01-20 14:05:41',NULL,0,NULL,9,0,'513f27413e944a9aecb2cf30115df7b6ff4baa77',0,'ec3ac8cc-b2d8e96f-678e5833761ee6.52395438','2025-01-20 14:05:41'),
(11,2,1,'62c2c5226dfa28.92593855image_paste688105.png','image_paste.png','PNG/96/d5ffa76df605b9f32fd2624653613db5c8bccb.PNG',0,'image/png','2025-01-21 00:18:58',NULL,0,NULL,9,0,'96d5ffa76df605b9f32fd2624653613db5c8bccb',0,'ec3ac8cc-b2d8e96f-678ee7e6eb9177.72480582','2025-01-21 00:18:58'),
(12,2,1,'62c35a052f90fc.14011958image_paste3781659.png','image_paste.png','PNG/ea/4c87076478bba1a45d2e75275bc403c0c43e01.PNG',0,'image/png','2025-01-21 11:27:28',NULL,0,NULL,9,0,'ea4c87076478bba1a45d2e75275bc403c0c43e01',0,'ec3ac8cc-b2d8e96f-678f840b8e9a32.37877242','2025-01-21 11:27:28'),
(13,2,1,'62c36fb07f530c.03703187image_paste1041686.png','image_paste.png','PNG/37/619d9738f0156aae29bb28848aae648739be8a.PNG',0,'image/png','2025-01-21 13:02:41',NULL,0,NULL,9,0,'37619d9738f0156aae29bb28848aae648739be8a',0,'ec3ac8cc-b2d8e96f-678f9ac07b0fe6.57690040','2025-01-21 13:02:41'),
(14,2,1,'62c49675e91ec0.86768743image_paste7866656.png','image_paste.png','PNG/a8/2a53ec8b584d9a338cb58ca92385a32a39c51a.PNG',0,'image/png','2025-01-22 11:00:46',NULL,0,NULL,9,0,'a82a53ec8b584d9a338cb58ca92385a32a39c51a',0,'ec3ac8cc-b2d8e96f-6790cfd5928179.61613302','2025-01-22 11:00:46'),
(15,2,0,'image_paste9316597.png','image_paste9316597.png','PNG/ba/5c43c153e5c991c5d72eeb698a8802be51c5d6.PNG',0,'image/png','2025-01-23 13:20:37',NULL,0,NULL,9,0,'ba5c43c153e5c991c5d72eeb698a8802be51c5d6',0,'ec3ac8cc-b2d8e96f-6792421b98dab2.18335093','2025-01-23 13:20:37'),
(16,2,1,'62cec9b0a6d018.94592529image_paste1600066.png','image_paste.png','PNG/da/c65e19ad6e7adc44b11e8679a86f19dc5125dd.PNG',0,'image/png','2025-01-30 13:44:22',NULL,0,NULL,9,0,'dac65e19ad6e7adc44b11e8679a86f19dc5125dd',0,'ec3ac8cc-b2d8e96f-679b81f077f908.68527211','2025-01-30 13:44:22'),
(17,2,1,'62e6e5a4ad31f4.64728719image_paste4652445.png','image_paste.png','PNG/33/2495afac3af752b94ab2454425ec0518bcae8d.PNG',0,'image/png','2025-02-18 17:56:01',NULL,0,NULL,9,0,'332495afac3af752b94ab2454425ec0518bcae8d',0,'47cb7c5c-b2d8e96f-67b4c9ad2804d1.68109059','2025-02-18 17:56:01');

--
-- Table structure for table `glpi_documents_items`
--

CREATE TABLE `glpi_documents_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `documents_id` int(10) unsigned NOT NULL DEFAULT 0,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(100) NOT NULL,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `users_id` int(10) unsigned DEFAULT 0,
  `timeline_position` tinyint(4) NOT NULL DEFAULT 0,
  `date_creation` timestamp NULL DEFAULT NULL,
  `date` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`documents_id`,`itemtype`,`items_id`,`timeline_position`),
  KEY `item` (`itemtype`,`items_id`,`entities_id`,`is_recursive`),
  KEY `users_id` (`users_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_creation` (`date_creation`),
  KEY `date_mod` (`date_mod`),
  KEY `date` (`date`),
  KEY `timeline_position` (`timeline_position`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_documents_items`
--

INSERT INTO `glpi_documents_items` VALUES
(3,3,11,'ITILFollowup',2,0,'2025-01-08 12:22:46',8,-1,'2025-01-08 12:22:46','2025-01-08 12:22:46'),
(4,4,20,'Ticket',2,0,'2025-01-08 13:21:24',9,1,'2025-01-08 13:21:24','2025-01-08 13:21:24'),
(5,5,15,'ITILFollowup',2,0,'2025-01-08 20:42:42',8,-1,'2025-01-08 20:42:42','2025-01-08 20:42:42'),
(6,6,23,'Ticket',2,0,'2025-01-09 18:02:47',9,1,'2025-01-09 18:02:47','2025-01-09 18:02:47'),
(7,7,28,'Ticket',2,0,'2025-01-13 12:35:41',9,1,'2025-01-13 12:35:41','2025-01-13 12:35:41'),
(10,9,43,'ITILFollowup',2,0,'2025-01-16 13:14:20',8,-1,'2025-01-16 13:14:20','2025-01-16 13:14:20'),
(11,10,12,'PluginFormcreatorFormAnswer',2,1,'2025-01-20 14:05:41',9,0,'2025-01-20 14:05:41','2025-01-20 14:05:41'),
(12,10,48,'Ticket',2,1,'2025-01-20 14:05:41',9,-1,'2025-01-20 14:05:41','2025-01-20 14:05:41'),
(13,11,13,'PluginFormcreatorFormAnswer',2,1,'2025-01-21 00:18:58',9,0,'2025-01-21 00:18:58','2025-01-21 00:18:58'),
(15,12,14,'PluginFormcreatorFormAnswer',2,1,'2025-01-21 11:27:28',9,0,'2025-01-21 11:27:28','2025-01-21 11:27:28'),
(16,12,50,'Ticket',2,1,'2025-01-21 11:27:28',9,-1,'2025-01-21 11:27:28','2025-01-21 11:27:28'),
(17,13,15,'PluginFormcreatorFormAnswer',2,1,'2025-01-21 13:02:41',9,0,'2025-01-21 13:02:41','2025-01-21 13:02:41'),
(18,13,51,'Ticket',2,1,'2025-01-21 13:02:41',9,-1,'2025-01-21 13:02:41','2025-01-21 13:02:41'),
(19,14,17,'PluginFormcreatorFormAnswer',2,1,'2025-01-22 11:00:46',9,0,'2025-01-22 11:00:46','2025-01-22 11:00:46'),
(20,14,53,'Ticket',2,1,'2025-01-22 11:00:46',9,-1,'2025-01-22 11:00:46','2025-01-22 11:00:46'),
(21,15,70,'ITILFollowup',2,0,'2025-01-23 13:20:37',9,-1,'2025-01-23 13:20:37','2025-01-23 13:20:37'),
(22,16,37,'PluginFormcreatorFormAnswer',2,1,'2025-01-30 13:44:22',9,0,'2025-01-30 13:44:22','2025-01-30 13:44:22'),
(23,16,73,'Ticket',2,1,'2025-01-30 13:44:22',9,-1,'2025-01-30 13:44:22','2025-01-30 13:44:22'),
(24,17,54,'PluginFormcreatorFormAnswer',2,1,'2025-02-18 17:56:01',9,0,'2025-02-18 17:56:01','2025-02-18 17:56:01'),
(25,17,90,'Ticket',2,1,'2025-02-18 17:56:01',9,-1,'2025-02-18 17:56:01','2025-02-18 17:56:01');

--
-- Table structure for table `glpi_documenttypes`
--

CREATE TABLE `glpi_documenttypes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `ext` varchar(255) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `mime` varchar(255) DEFAULT NULL,
  `is_uploadable` tinyint(4) NOT NULL DEFAULT 1,
  `date_mod` timestamp NULL DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`ext`),
  KEY `name` (`name`),
  KEY `is_uploadable` (`is_uploadable`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_documenttypes`
--

INSERT INTO `glpi_documenttypes` VALUES
(1,'JPEG','jpg','jpg-dist.png',NULL,1,NULL,NULL,NULL),
(2,'PNG','png','png-dist.png',NULL,1,NULL,NULL,NULL),
(3,'GIF','gif','gif-dist.png',NULL,1,NULL,NULL,NULL),
(4,'BMP','bmp','bmp-dist.png',NULL,1,NULL,NULL,NULL),
(5,'Photoshop','psd','psd-dist.png',NULL,1,NULL,NULL,NULL),
(6,'TIFF','tif','tif-dist.png',NULL,1,NULL,NULL,NULL),
(7,'AIFF','aiff','aiff-dist.png',NULL,1,NULL,NULL,NULL),
(8,'Windows Media','asf','asf-dist.png',NULL,1,NULL,NULL,NULL),
(9,'Windows Media','avi','avi-dist.png',NULL,1,NULL,NULL,NULL),
(10,'BZip','bz2','bz2-dist.png',NULL,1,NULL,NULL,NULL),
(11,'Word','doc','doc-dist.png',NULL,1,NULL,NULL,NULL),
(12,'DjVu','djvu','',NULL,1,NULL,NULL,NULL),
(13,'PostScript','eps','ps-dist.png',NULL,1,NULL,NULL,NULL),
(14,'GZ','gz','gz-dist.png',NULL,1,NULL,NULL,NULL),
(15,'HTML','html','html-dist.png',NULL,1,NULL,NULL,NULL),
(16,'Midi','mid','mid-dist.png',NULL,1,NULL,NULL,NULL),
(17,'QuickTime','mov','mov-dist.png',NULL,1,NULL,NULL,NULL),
(18,'MP3','mp3','mp3-dist.png',NULL,1,NULL,NULL,NULL),
(19,'MPEG','mpg','mpg-dist.png',NULL,1,NULL,NULL,NULL),
(20,'Ogg Vorbis','ogg','ogg-dist.png',NULL,1,NULL,NULL,NULL),
(21,'PDF','pdf','pdf-dist.png',NULL,1,NULL,NULL,NULL),
(22,'PowerPoint','ppt','ppt-dist.png',NULL,1,NULL,NULL,NULL),
(23,'PostScript','ps','ps-dist.png',NULL,1,NULL,NULL,NULL),
(24,'QuickTime','qt','qt-dist.png',NULL,1,NULL,NULL,NULL),
(25,'RealAudio','ra','ra-dist.png',NULL,1,NULL,NULL,NULL),
(26,'RealAudio','ram','ram-dist.png',NULL,1,NULL,NULL,NULL),
(27,'RealAudio','rm','rm-dist.png',NULL,1,NULL,NULL,NULL),
(28,'RTF','rtf','rtf-dist.png',NULL,1,NULL,NULL,NULL),
(29,'StarOffice','sdd','sdd-dist.png',NULL,1,NULL,NULL,NULL),
(30,'StarOffice','sdw','sdw-dist.png',NULL,1,NULL,NULL,NULL),
(31,'Stuffit','sit','sit-dist.png',NULL,1,NULL,NULL,NULL),
(32,'OpenOffice Impress','sxi','sxi-dist.png',NULL,1,NULL,NULL,NULL),
(33,'OpenOffice','sxw','sxw-dist.png',NULL,1,NULL,NULL,NULL),
(34,'Flash','swf','swf-dist.png',NULL,1,NULL,NULL,NULL),
(35,'TGZ','tgz','tgz-dist.png',NULL,1,NULL,NULL,NULL),
(36,'texte','txt','txt-dist.png',NULL,1,NULL,NULL,NULL),
(37,'WAV','wav','wav-dist.png',NULL,1,NULL,NULL,NULL),
(38,'Excel','xls','xls-dist.png',NULL,1,NULL,NULL,NULL),
(39,'XML','xml','xml-dist.png',NULL,1,NULL,NULL,NULL),
(40,'Windows Media','wmv','wmv-dist.png',NULL,1,NULL,NULL,NULL),
(41,'Zip','zip','zip-dist.png',NULL,1,NULL,NULL,NULL),
(42,'MNG','mng','',NULL,1,NULL,NULL,NULL),
(43,'Adobe Illustrator','ai','ai-dist.png',NULL,1,NULL,NULL,NULL),
(44,'C source','c','c-dist.png',NULL,1,NULL,NULL,NULL),
(45,'Debian','deb','deb-dist.png',NULL,1,NULL,NULL,NULL),
(46,'DVI','dvi','dvi-dist.png',NULL,1,NULL,NULL,NULL),
(47,'C header','h','h-dist.png',NULL,1,NULL,NULL,NULL),
(48,'Pascal','pas','pas-dist.png',NULL,1,NULL,NULL,NULL),
(49,'RedHat/Mandrake/SuSE','rpm','rpm-dist.png',NULL,1,NULL,NULL,NULL),
(50,'OpenOffice Calc','sxc','sxc-dist.png',NULL,1,NULL,NULL,NULL),
(51,'LaTeX','tex','tex-dist.png',NULL,1,NULL,NULL,NULL),
(52,'GIMP multi-layer','xcf','xcf-dist.png',NULL,1,NULL,NULL,NULL),
(53,'JPEG','jpeg','jpg-dist.png',NULL,1,NULL,NULL,NULL),
(54,'Oasis Open Office Writer','odt','odt-dist.png',NULL,1,NULL,NULL,NULL),
(55,'Oasis Open Office Calc','ods','ods-dist.png',NULL,1,NULL,NULL,NULL),
(56,'Oasis Open Office Impress','odp','odp-dist.png',NULL,1,NULL,NULL,NULL),
(57,'Oasis Open Office Impress Template','otp','odp-dist.png',NULL,1,NULL,NULL,NULL),
(58,'Oasis Open Office Writer Template','ott','odt-dist.png',NULL,1,NULL,NULL,NULL),
(59,'Oasis Open Office Calc Template','ots','ods-dist.png',NULL,1,NULL,NULL,NULL),
(60,'Oasis Open Office Math','odf','odf-dist.png',NULL,1,NULL,NULL,NULL),
(61,'Oasis Open Office Draw','odg','odg-dist.png',NULL,1,NULL,NULL,NULL),
(62,'Oasis Open Office Draw Template','otg','odg-dist.png',NULL,1,NULL,NULL,NULL),
(63,'Oasis Open Office Base','odb','odb-dist.png',NULL,1,NULL,NULL,NULL),
(64,'Oasis Open Office HTML','oth','oth-dist.png',NULL,1,NULL,NULL,NULL),
(65,'Oasis Open Office Writer Master','odm','odm-dist.png',NULL,1,NULL,NULL,NULL),
(66,'Oasis Open Office Chart','odc','',NULL,1,NULL,NULL,NULL),
(67,'Oasis Open Office Image','odi','',NULL,1,NULL,NULL,NULL),
(68,'Word XML','docx','doc-dist.png',NULL,1,NULL,NULL,NULL),
(69,'Excel XML','xlsx','xls-dist.png',NULL,1,NULL,NULL,NULL),
(70,'PowerPoint XML','pptx','ppt-dist.png',NULL,1,NULL,NULL,NULL),
(71,'Comma-Separated Values','csv','csv-dist.png',NULL,1,NULL,NULL,NULL),
(72,'Scalable Vector Graphics','svg','svg-dist.png',NULL,1,NULL,NULL,NULL);

--
-- Table structure for table `glpi_domainrecords`
--

CREATE TABLE `glpi_domainrecords` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `data` text DEFAULT NULL,
  `data_obj` text DEFAULT NULL,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `domains_id` int(10) unsigned NOT NULL DEFAULT 0,
  `domainrecordtypes_id` int(10) unsigned NOT NULL DEFAULT 0,
  `ttl` int(11) NOT NULL,
  `users_id_tech` int(10) unsigned NOT NULL DEFAULT 0,
  `groups_id_tech` int(10) unsigned NOT NULL DEFAULT 0,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `comment` text DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `domains_id` (`domains_id`),
  KEY `domainrecordtypes_id` (`domainrecordtypes_id`),
  KEY `users_id_tech` (`users_id_tech`),
  KEY `groups_id_tech` (`groups_id_tech`),
  KEY `date_mod` (`date_mod`),
  KEY `is_deleted` (`is_deleted`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_domainrecords`
--


--
-- Table structure for table `glpi_domainrecordtypes`
--

CREATE TABLE `glpi_domainrecordtypes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `fields` text DEFAULT NULL,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `comment` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_domainrecordtypes`
--

INSERT INTO `glpi_domainrecordtypes` VALUES
(1,'A','[]',0,1,'Host address'),
(2,'AAAA','[]',0,1,'IPv6 host address'),
(3,'ALIAS','[]',0,1,'Auto resolved alias'),
(4,'CNAME','[{\"key\":\"target\",\"label\":\"Target\",\"placeholder\":\"sip.example.com.\",\"is_fqdn\":true}]',0,1,'Canonical name for an alias'),
(5,'MX','[{\"key\":\"priority\",\"label\":\"Priority\",\"placeholder\":\"10\"},{\"key\":\"server\",\"label\":\"Server\",\"placeholder\":\"mail.example.com.\",\"is_fqdn\":true}]',0,1,'Mail eXchange'),
(6,'NS','[]',0,1,'Name Server'),
(7,'PTR','[]',0,1,'Pointer'),
(8,'SOA','[{\"key\":\"primary_name_server\",\"label\":\"Primary name server\",\"placeholder\":\"ns1.example.com.\",\"is_fqdn\":true},{\"key\":\"primary_contact\",\"label\":\"Primary contact\",\"placeholder\":\"admin.example.com.\",\"is_fqdn\":true},{\"key\":\"serial\",\"label\":\"Serial\",\"placeholder\":\"2020010101\"},{\"key\":\"zone_refresh_timer\",\"label\":\"Zone refresh timer\",\"placeholder\":\"86400\"},{\"key\":\"failed_refresh_retry_timer\",\"label\":\"Failed refresh retry timer\",\"placeholder\":\"7200\"},{\"key\":\"zone_expiry_timer\",\"label\":\"Zone expiry timer\",\"placeholder\":\"1209600\"},{\"key\":\"minimum_ttl\",\"label\":\"Minimum TTL\",\"placeholder\":\"300\"}]',0,1,'Start Of Authority'),
(9,'SRV','[{\"key\":\"priority\",\"label\":\"Priority\",\"placeholder\":\"0\"},{\"key\":\"weight\",\"label\":\"Weight\",\"placeholder\":\"10\"},{\"key\":\"port\",\"label\":\"Port\",\"placeholder\":\"5060\"},{\"key\":\"target\",\"label\":\"Target\",\"placeholder\":\"sip.example.com.\",\"is_fqdn\":true}]',0,1,'Location of service'),
(10,'TXT','[{\"key\":\"data\",\"label\":\"TXT record data\",\"placeholder\":\"Your TXT record data\",\"quote_value\":true}]',0,1,'Descriptive text'),
(11,'CAA','[{\"key\":\"flag\",\"label\":\"Flag\",\"placeholder\":\"0\"},{\"key\":\"tag\",\"label\":\"Tag\",\"placeholder\":\"issue\"},{\"key\":\"value\",\"label\":\"Value\",\"placeholder\":\"letsencrypt.org\",\"quote_value\":true}]',0,1,'Certification Authority Authorization');

--
-- Table structure for table `glpi_domainrelations`
--

CREATE TABLE `glpi_domainrelations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `comment` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_domainrelations`
--

INSERT INTO `glpi_domainrelations` VALUES
(1,'Belongs',0,1,'Item belongs to domain'),
(2,'Manage',0,1,'Item manages domain');

--
-- Table structure for table `glpi_domains`
--

CREATE TABLE `glpi_domains` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `domaintypes_id` int(10) unsigned NOT NULL DEFAULT 0,
  `date_expiration` timestamp NULL DEFAULT NULL,
  `date_domaincreation` timestamp NULL DEFAULT NULL,
  `users_id_tech` int(10) unsigned NOT NULL DEFAULT 0,
  `groups_id_tech` int(10) unsigned NOT NULL DEFAULT 0,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `comment` text DEFAULT NULL,
  `is_template` tinyint(4) NOT NULL DEFAULT 0,
  `template_name` varchar(255) DEFAULT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `domaintypes_id` (`domaintypes_id`),
  KEY `users_id_tech` (`users_id_tech`),
  KEY `groups_id_tech` (`groups_id_tech`),
  KEY `date_mod` (`date_mod`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_template` (`is_template`),
  KEY `is_active` (`is_active`),
  KEY `date_expiration` (`date_expiration`),
  KEY `date_domaincreation` (`date_domaincreation`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_domains`
--


--
-- Table structure for table `glpi_domains_items`
--

CREATE TABLE `glpi_domains_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `domains_id` int(10) unsigned NOT NULL DEFAULT 0,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(100) NOT NULL,
  `domainrelations_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_dynamic` tinyint(4) NOT NULL DEFAULT 0,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`domains_id`,`itemtype`,`items_id`),
  KEY `domainrelations_id` (`domainrelations_id`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `is_deleted` (`is_deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_domains_items`
--


--
-- Table structure for table `glpi_domaintypes`
--

CREATE TABLE `glpi_domaintypes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `comment` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_domaintypes`
--


--
-- Table structure for table `glpi_dropdowntranslations`
--

CREATE TABLE `glpi_dropdowntranslations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(100) DEFAULT NULL,
  `language` varchar(10) DEFAULT NULL,
  `field` varchar(100) DEFAULT NULL,
  `value` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`itemtype`,`items_id`,`language`,`field`),
  KEY `language` (`language`),
  KEY `field` (`field`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_dropdowntranslations`
--


--
-- Table structure for table `glpi_enclosuremodels`
--

CREATE TABLE `glpi_enclosuremodels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `product_number` varchar(255) DEFAULT NULL,
  `weight` int(11) NOT NULL DEFAULT 0,
  `required_units` int(11) NOT NULL DEFAULT 1,
  `depth` float NOT NULL DEFAULT 1,
  `power_connections` int(11) NOT NULL DEFAULT 0,
  `power_consumption` int(11) NOT NULL DEFAULT 0,
  `is_half_rack` tinyint(4) NOT NULL DEFAULT 0,
  `picture_front` text DEFAULT NULL,
  `picture_rear` text DEFAULT NULL,
  `pictures` text DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_enclosuremodels`
--


--
-- Table structure for table `glpi_enclosures`
--

CREATE TABLE `glpi_enclosures` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `locations_id` int(10) unsigned NOT NULL DEFAULT 0,
  `serial` varchar(255) DEFAULT NULL,
  `otherserial` varchar(255) DEFAULT NULL,
  `enclosuremodels_id` int(10) unsigned DEFAULT NULL,
  `users_id_tech` int(10) unsigned NOT NULL DEFAULT 0,
  `groups_id_tech` int(10) unsigned NOT NULL DEFAULT 0,
  `is_template` tinyint(4) NOT NULL DEFAULT 0,
  `template_name` varchar(255) DEFAULT NULL,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `orientation` tinyint(4) DEFAULT NULL,
  `power_supplies` tinyint(4) NOT NULL DEFAULT 0,
  `states_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'RELATION to states (id)',
  `comment` text DEFAULT NULL,
  `manufacturers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `locations_id` (`locations_id`),
  KEY `enclosuremodels_id` (`enclosuremodels_id`),
  KEY `users_id_tech` (`users_id_tech`),
  KEY `group_id_tech` (`groups_id_tech`),
  KEY `is_template` (`is_template`),
  KEY `is_deleted` (`is_deleted`),
  KEY `states_id` (`states_id`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_enclosures`
--


--
-- Table structure for table `glpi_entities`
--

CREATE TABLE `glpi_entities` (
  `id` int(10) unsigned NOT NULL DEFAULT 0,
  `name` varchar(255) DEFAULT NULL,
  `entities_id` int(10) unsigned DEFAULT 0,
  `completename` text DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `level` int(11) NOT NULL DEFAULT 0,
  `sons_cache` longtext DEFAULT NULL,
  `ancestors_cache` longtext DEFAULT NULL,
  `registration_number` varchar(255) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `postcode` varchar(255) DEFAULT NULL,
  `town` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `phonenumber` varchar(255) DEFAULT NULL,
  `fax` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `admin_email` varchar(255) DEFAULT NULL,
  `admin_email_name` varchar(255) DEFAULT NULL,
  `from_email` varchar(255) DEFAULT NULL,
  `from_email_name` varchar(255) DEFAULT NULL,
  `noreply_email` varchar(255) DEFAULT NULL,
  `noreply_email_name` varchar(255) DEFAULT NULL,
  `replyto_email` varchar(255) DEFAULT NULL,
  `replyto_email_name` varchar(255) DEFAULT NULL,
  `notification_subject_tag` varchar(255) DEFAULT NULL,
  `ldap_dn` varchar(255) DEFAULT NULL,
  `tag` varchar(255) DEFAULT NULL,
  `authldaps_id` int(10) unsigned NOT NULL DEFAULT 0,
  `mail_domain` varchar(255) DEFAULT NULL,
  `entity_ldapfilter` text DEFAULT NULL,
  `mailing_signature` text DEFAULT NULL,
  `cartridges_alert_repeat` int(11) NOT NULL DEFAULT -2,
  `consumables_alert_repeat` int(11) NOT NULL DEFAULT -2,
  `use_licenses_alert` int(11) NOT NULL DEFAULT -2,
  `send_licenses_alert_before_delay` int(11) NOT NULL DEFAULT -2,
  `use_certificates_alert` int(11) NOT NULL DEFAULT -2,
  `send_certificates_alert_before_delay` int(11) NOT NULL DEFAULT -2,
  `certificates_alert_repeat_interval` int(11) NOT NULL DEFAULT -2,
  `use_contracts_alert` int(11) NOT NULL DEFAULT -2,
  `send_contracts_alert_before_delay` int(11) NOT NULL DEFAULT -2,
  `use_infocoms_alert` int(11) NOT NULL DEFAULT -2,
  `send_infocoms_alert_before_delay` int(11) NOT NULL DEFAULT -2,
  `use_reservations_alert` int(11) NOT NULL DEFAULT -2,
  `use_domains_alert` int(11) NOT NULL DEFAULT -2,
  `send_domains_alert_close_expiries_delay` int(11) NOT NULL DEFAULT -2,
  `send_domains_alert_expired_delay` int(11) NOT NULL DEFAULT -2,
  `autoclose_delay` int(11) NOT NULL DEFAULT -2,
  `autopurge_delay` int(11) NOT NULL DEFAULT -2,
  `notclosed_delay` int(11) NOT NULL DEFAULT -2,
  `calendars_strategy` tinyint(4) NOT NULL DEFAULT -2,
  `calendars_id` int(10) unsigned NOT NULL DEFAULT 0,
  `auto_assign_mode` int(11) NOT NULL DEFAULT -2,
  `tickettype` int(11) NOT NULL DEFAULT -2,
  `max_closedate` timestamp NULL DEFAULT NULL,
  `inquest_config` int(11) NOT NULL DEFAULT -2,
  `inquest_rate` int(11) NOT NULL DEFAULT 0,
  `inquest_delay` int(11) NOT NULL DEFAULT -10,
  `inquest_URL` varchar(255) DEFAULT NULL,
  `autofill_warranty_date` varchar(255) NOT NULL DEFAULT '-2',
  `autofill_use_date` varchar(255) NOT NULL DEFAULT '-2',
  `autofill_buy_date` varchar(255) NOT NULL DEFAULT '-2',
  `autofill_delivery_date` varchar(255) NOT NULL DEFAULT '-2',
  `autofill_order_date` varchar(255) NOT NULL DEFAULT '-2',
  `tickettemplates_strategy` tinyint(4) NOT NULL DEFAULT -2,
  `tickettemplates_id` int(10) unsigned NOT NULL DEFAULT 0,
  `changetemplates_strategy` tinyint(4) NOT NULL DEFAULT -2,
  `changetemplates_id` int(10) unsigned NOT NULL DEFAULT 0,
  `problemtemplates_strategy` tinyint(4) NOT NULL DEFAULT -2,
  `problemtemplates_id` int(10) unsigned NOT NULL DEFAULT 0,
  `entities_strategy_software` tinyint(4) NOT NULL DEFAULT -2,
  `entities_id_software` int(10) unsigned NOT NULL DEFAULT 0,
  `default_contract_alert` int(11) NOT NULL DEFAULT -2,
  `default_infocom_alert` int(11) NOT NULL DEFAULT -2,
  `default_cartridges_alarm_threshold` int(11) NOT NULL DEFAULT -2,
  `default_consumables_alarm_threshold` int(11) NOT NULL DEFAULT -2,
  `delay_send_emails` int(11) NOT NULL DEFAULT -2,
  `is_notif_enable_default` int(11) NOT NULL DEFAULT -2,
  `inquest_duration` int(11) NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `autofill_decommission_date` varchar(255) NOT NULL DEFAULT '-2',
  `suppliers_as_private` int(11) NOT NULL DEFAULT -2,
  `anonymize_support_agents` int(11) NOT NULL DEFAULT -2,
  `display_users_initials` int(11) NOT NULL DEFAULT -2,
  `contracts_strategy_default` tinyint(4) NOT NULL DEFAULT -2,
  `contracts_id_default` int(10) unsigned NOT NULL DEFAULT 0,
  `enable_custom_css` int(11) NOT NULL DEFAULT -2,
  `custom_css_code` text DEFAULT NULL,
  `latitude` varchar(255) DEFAULT NULL,
  `longitude` varchar(255) DEFAULT NULL,
  `altitude` varchar(255) DEFAULT NULL,
  `transfers_strategy` tinyint(4) NOT NULL DEFAULT -2,
  `transfers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `agent_base_url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`entities_id`,`name`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `tickettemplates_id` (`tickettemplates_id`),
  KEY `changetemplates_id` (`changetemplates_id`),
  KEY `problemtemplates_id` (`problemtemplates_id`),
  KEY `transfers_id` (`transfers_id`),
  KEY `authldaps_id` (`authldaps_id`),
  KEY `calendars_id` (`calendars_id`),
  KEY `entities_id_software` (`entities_id_software`),
  KEY `contracts_id_default` (`contracts_id_default`),
  KEY `level` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_entities`
--

INSERT INTO `glpi_entities` VALUES
(0,'Entidade raiz',NULL,'Entidade raiz',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,0,0,0,0,0,0,0,0,0,0,0,0,0,30,1,-10,-10,0,0,0,-10,1,NULL,1,0,0,NULL,'0','0','0','0','0',0,1,0,1,0,1,-10,0,0,0,10,10,0,1,0,NULL,NULL,'0',0,0,1,0,0,0,'',NULL,NULL,NULL,0,0,NULL),
(2,'Tecnomulti',3,'Entidade raiz > Wintech > Tecnomulti','',3,'{\"2\":2}','{\"0\":0,\"3\":3}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,0,-2,-2,'2024-12-27 21:14:54',-2,0,-10,NULL,'-2','-2','-2','-2','-2',-2,0,-2,0,-2,0,-2,0,-2,-2,-2,-2,-2,-2,0,'2025-01-16 01:54:27','2024-12-27 21:14:54','-2',-2,-2,-2,-2,0,-2,'',NULL,NULL,NULL,-2,0,NULL),
(3,'Wintech',0,'Entidade raiz > Wintech','',2,'{\"3\":\"3\",\"2\":2}','[0]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,0,-2,-2,'2025-01-16 01:54:14',-2,0,-10,NULL,'-2','-2','-2','-2','-2',-2,0,-2,0,-2,0,-2,0,-2,-2,-2,-2,-2,-2,0,'2025-01-16 01:54:14','2025-01-16 01:54:14','-2',-2,-2,-2,-2,0,-2,'',NULL,NULL,NULL,-2,0,NULL);

--
-- Table structure for table `glpi_entities_knowbaseitems`
--

CREATE TABLE `glpi_entities_knowbaseitems` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `knowbaseitems_id` int(10) unsigned NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `knowbaseitems_id` (`knowbaseitems_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_entities_knowbaseitems`
--


--
-- Table structure for table `glpi_entities_reminders`
--

CREATE TABLE `glpi_entities_reminders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `reminders_id` int(10) unsigned NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `reminders_id` (`reminders_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_entities_reminders`
--


--
-- Table structure for table `glpi_entities_rssfeeds`
--

CREATE TABLE `glpi_entities_rssfeeds` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rssfeeds_id` int(10) unsigned NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `rssfeeds_id` (`rssfeeds_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_entities_rssfeeds`
--


--
-- Table structure for table `glpi_events`
--

CREATE TABLE `glpi_events` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `type` varchar(255) DEFAULT NULL,
  `date` timestamp NULL DEFAULT NULL,
  `service` varchar(255) DEFAULT NULL,
  `level` int(11) NOT NULL DEFAULT 0,
  `message` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `date` (`date`),
  KEY `level` (`level`),
  KEY `item` (`type`,`items_id`)
) ENGINE=InnoDB AUTO_INCREMENT=843 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_events`
--

INSERT INTO `glpi_events` VALUES
(1,0,'system','2024-12-27 05:24:22','login',3,'glpi fez login no IP 187.19.242.137'),
(2,7,'users','2024-12-27 05:47:33','setup',4,'glpi adicionou o item paulovictorfds'),
(3,0,'system','2024-12-27 05:53:07','login',3,'paulovictorfds fez login no IP 187.19.242.137'),
(4,8,'users','2024-12-27 13:18:42','setup',4,'paulovictorfds adicionou o item alexcruz'),
(5,0,'system','2024-12-27 13:53:55','login',3,'alexcruz fez login no IP 177.89.21.161'),
(6,1,'Manufacturer','2024-12-27 14:00:32','setup',4,'alexcruz adicionou o item DELL'),
(7,1,'ComputerType','2024-12-27 14:00:49','setup',4,'alexcruz adicionou o item DESKTOP'),
(8,2,'ComputerType','2024-12-27 14:00:55','setup',4,'alexcruz adicionou o item ALL IN ONE'),
(9,3,'ComputerType','2024-12-27 14:01:01','setup',4,'alexcruz adicionou o item NOTEBOOK'),
(10,0,'system','2024-12-27 19:40:42','login',3,'paulovictorfds fez login no IP 187.19.242.137'),
(11,0,'system','2024-12-27 19:41:47','login',3,'paulovictorfds fez login no IP 187.19.242.137'),
(12,1,'Entity','2024-12-27 19:43:22','setup',4,'paulovictorfds adicionou o item Tecnomulti'),
(13,9,'users','2024-12-27 19:44:47','setup',4,'paulovictorfds adicionou o item teste-cliente'),
(14,0,'system','2024-12-27 19:45:15','login',3,'Login falhou para cliente-teste no IP 187.19.242.137'),
(15,0,'system','2024-12-27 19:45:21','login',3,'teste-cliente fez login no IP 187.19.242.137'),
(16,0,'system','2024-12-27 19:45:32','login',3,'teste-cliente fez login no IP 187.61.153.218'),
(17,0,'system','2024-12-27 19:47:45','login',3,'paulovictorfds fez login no IP 187.19.242.137'),
(18,1,'ticket','2024-12-27 19:49:41','tracking',4,'teste-cliente adicionou o item 1'),
(19,0,'system','2024-12-27 19:49:49','login',3,'alexcruz fez login no IP 187.61.153.218'),
(20,1,'ticket','2024-12-27 19:53:52','tracking',4,'teste-cliente excluiu um item'),
(21,2,'ticket','2024-12-27 19:54:33','tracking',4,'teste-cliente adicionou o item 2'),
(22,2,'ticket','2024-12-27 19:55:01','tracking',4,'alexcruz atualizou um item'),
(23,2,'ticket','2024-12-27 19:56:56','tracking',4,'alexcruz adicionou um acompanhamento'),
(24,2,'ticket','2024-12-27 19:56:59','tracking',4,'alexcruz atualizou um item'),
(25,2,'ticket','2024-12-27 19:57:29','tracking',4,'alexcruz atualizou um item'),
(26,3,'ticket','2024-12-27 19:58:27','tracking',4,'teste-cliente adicionou o item 3'),
(27,3,'ticket','2024-12-27 20:00:04','tracking',4,'alexcruz adicionou um acompanhamento'),
(28,3,'ticket','2024-12-27 20:00:35','tracking',4,'alexcruz atualizou um item'),
(29,4,'ticket','2024-12-27 20:14:37','tracking',4,'alexcruz adicionou o item 4'),
(30,5,'ticket','2024-12-27 20:17:33','tracking',4,'teste-cliente adicionou o item 5'),
(31,5,'ticket','2024-12-27 20:18:04','tracking',4,'alexcruz atualizou um item'),
(32,5,'ticket','2024-12-27 20:18:38','tracking',4,'alexcruz adicionou um acompanhamento'),
(33,5,'ticket','2024-12-27 20:18:41','tracking',4,'alexcruz atualizou um item'),
(34,5,'ticket','2024-12-27 20:19:00','tracking',4,'alexcruz atualizou um item'),
(35,6,'ticket','2024-12-27 20:21:17','tracking',4,'teste-cliente adicionou o item 6'),
(36,0,'system','2024-12-27 20:22:57','setup',3,'paulovictorfds editou a configuração de notificações dos navegadores'),
(37,7,'ticket','2024-12-27 20:25:24','tracking',4,'teste-cliente adicionou o item 7'),
(38,8,'ticket','2024-12-27 20:25:51','tracking',4,'teste-cliente adicionou o item 8'),
(39,1,'tickettemplate','2024-12-27 20:33:38','maintain',4,'paulovictorfds adiciona escondido campo'),
(40,1,'tickettemplate','2024-12-27 20:34:03','maintain',4,'paulovictorfds adiciona escondido campo'),
(41,1,'tickettemplate','2024-12-27 20:34:28','maintain',4,'paulovictorfds adiciona escondido campo'),
(42,1,'ITILCategory','2024-12-27 20:36:12','setup',4,'paulovictorfds adicionou o item Equipamentos/Periféricos'),
(43,1,'ITILCategory','2024-12-27 20:36:33','setup',4,'paulovictorfds atualizou um item'),
(44,1,'ITILCategory','2024-12-27 20:36:44','setup',4,'paulovictorfds atualizou um item'),
(45,2,'ITILCategory','2024-12-27 20:38:40','setup',4,'paulovictorfds adicionou o item Rede'),
(46,2,'ITILCategory','2024-12-27 20:38:54','setup',4,'paulovictorfds atualizou um item'),
(47,3,'ITILCategory','2024-12-27 20:39:47','setup',4,'paulovictorfds adicionou o item E-mail'),
(48,3,'ITILCategory','2024-12-27 20:39:59','setup',4,'paulovictorfds atualizou um item'),
(49,2,'ITILCategory','2024-12-27 20:40:08','setup',4,'paulovictorfds atualizou um item'),
(50,9,'ticket','2024-12-27 20:43:16','tracking',4,'teste-cliente adicionou o item 9'),
(51,1,'tickettemplate','2024-12-27 20:46:00','maintain',4,'paulovictorfds adiciona obrigatório campo'),
(52,1,'tickettemplate','2024-12-27 20:49:20','maintain',4,'paulovictorfds adiciona predefinido campo'),
(53,1,'tickettemplate','2024-12-27 20:50:41','maintain',4,'paulovictorfds adiciona obrigatório campo'),
(54,10,'ticket','2024-12-27 20:53:59','tracking',4,'paulovictorfds adicionou o item 10'),
(55,11,'ticket','2024-12-27 21:17:40','tracking',4,'paulovictorfds adicionou o item 11'),
(56,2,'Entity','2024-12-27 21:19:14','setup',4,'paulovictorfds atualizou um item'),
(57,9,'users','2024-12-27 21:22:24','setup',5,'paulovictorfds atualizou um item'),
(58,9,'users','2024-12-27 21:22:45','setup',5,'paulovictorfds atualizou um item'),
(59,9,'users','2024-12-27 21:22:58','setup',4,'paulovictorfds adicionou um usuário a uma entidade'),
(60,9,'users','2024-12-27 21:24:14','setup',5,'paulovictorfds atualizou um item'),
(61,0,'system','2024-12-27 21:28:32','login',3,'tecnomulti fez login no IP 187.61.153.218'),
(62,0,'system','2024-12-27 21:47:28','login',3,'tecnomulti fez login no IP 187.61.153.218'),
(63,12,'ticket','2024-12-27 21:48:54','tracking',4,'tecnomulti adicionou o item 12'),
(64,12,'ticket','2024-12-27 21:49:27','tracking',4,'alexcruz adicionou um acompanhamento'),
(65,12,'ticket','2024-12-27 21:49:34','tracking',4,'alexcruz atualizou um item'),
(66,12,'ticket','2024-12-27 21:50:19','tracking',4,'tecnomulti adicionou um acompanhamento'),
(67,12,'ticket','2024-12-27 21:50:35','tracking',4,'tecnomulti adicionou um acompanhamento'),
(68,12,'ticket','2024-12-27 21:50:59','tracking',4,'alexcruz atualizou um item'),
(69,0,'system','2025-01-03 01:07:22','login',3,'paulovictorfds fez login no IP 187.19.242.137'),
(70,8,'users','2025-01-03 01:21:09','setup',4,'paulovictorfds adicionou um usuário a uma entidade'),
(71,0,'system','2025-01-03 01:22:39','login',3,'alexcruz fez login no IP 187.61.153.218'),
(72,5,'profiles','2025-01-03 01:33:28','setup',4,'paulovictorfds atualizou um item'),
(73,1,'contacts','2025-01-03 03:07:14','financial',4,'paulovictorfds adicionou o item Alex'),
(74,12,'ticket','2025-01-03 03:10:38','tracking',4,'alexcruz adicionou um acompanhamento'),
(75,12,'ticket','2025-01-03 03:11:02','tracking',4,'paulovictorfds atualizou um item'),
(76,12,'ticket','2025-01-03 03:11:27','tracking',4,'alexcruz atualizou um item'),
(77,0,'system','2025-01-03 03:15:04','login',3,'tecnomulti fez login no IP 187.61.153.218'),
(78,3,'ITILCategory','2025-01-03 03:15:09','setup',4,'paulovictorfds atualizou um item'),
(79,13,'ticket','2025-01-03 03:15:24','tracking',4,'tecnomulti adicionou o item 13'),
(80,13,'ticket','2025-01-03 03:16:55','tracking',4,'alexcruz adicionou um acompanhamento'),
(81,13,'ticket','2025-01-03 03:16:56','tracking',4,'alexcruz atualizou um item'),
(82,14,'ticket','2025-01-03 03:21:44','tracking',4,'tecnomulti adicionou o item 14'),
(83,9,'users','2025-01-03 03:21:44','setup',4,'paulovictorfds adicionou um usuário a uma entidade'),
(84,0,'system','2025-01-03 03:22:19','login',3,'tecnomulti fez login no IP 187.61.153.218'),
(85,7,'users','2025-01-03 03:22:34','setup',4,'paulovictorfds adicionou um usuário a uma entidade'),
(86,15,'ticket','2025-01-03 03:22:35','tracking',4,'tecnomulti adicionou o item 15'),
(87,13,'ticket','2025-01-03 03:24:27','tracking',4,'alexcruz atualizou um item'),
(88,1,'ITILCategory','2025-01-03 03:24:59','setup',4,'paulovictorfds atualizou um item'),
(89,1,'tickettemplate','2025-01-03 03:29:30','maintain',4,'paulovictorfds adiciona obrigatório campo'),
(90,1,'tickettemplate','2025-01-03 03:31:39','maintain',4,'paulovictorfds adiciona obrigatório campo'),
(91,1,'tickettemplate','2025-01-03 03:32:08','maintain',4,'paulovictorfds adiciona obrigatório campo'),
(92,0,'system','2025-01-03 03:32:45','login',3,'tecnomulti fez login no IP 187.19.242.137'),
(93,1,'ITILCategory','2025-01-03 04:07:09','setup',4,'paulovictorfds atualizou um item'),
(94,1,'tickettemplate','2025-01-03 04:15:07','maintain',4,'paulovictorfds adiciona predefinido campo'),
(95,7,'users','2025-01-03 04:16:34','setup',4,'paulovictorfds adicionou um usuário a uma entidade'),
(96,7,'users','2025-01-03 04:20:25','setup',4,'paulovictorfds adicionou um usuário a uma entidade'),
(97,0,'system','2025-01-03 04:21:28','login',3,'paulovictorfds fez login no IP 187.19.242.137'),
(98,0,'system','2025-01-03 04:23:30','login',3,'paulovictorfds fez login no IP 187.19.242.137'),
(99,0,'system','2025-01-03 04:24:04','login',3,'paulovictorfds fez login no IP 187.19.242.137'),
(100,0,'system','2025-01-03 16:15:51','login',3,'paulovictorfds fez login no IP 187.19.242.185'),
(101,0,'system','2025-01-03 16:18:06','login',3,'paulovictorfds fez login no IP 187.19.242.185'),
(102,0,'system','2025-01-06 21:23:45','login',3,'alexcruz fez login no IP 187.61.153.218'),
(103,8,'users','2025-01-06 21:24:24','setup',5,'alexcruz atualizou um item'),
(104,1,'budget','2025-01-06 21:36:49','financial',4,'alexcruz adicionou o item PV'),
(105,0,'system','2025-01-06 21:46:51','login',3,'tecnomulti fez login no IP 187.61.153.218'),
(106,0,'system','2025-01-06 21:50:16','login',3,'tecnomulti fez login no IP 187.19.242.209'),
(107,16,'ticket','2025-01-06 21:50:51','tracking',4,'tecnomulti adicionou o item 16'),
(108,16,'ticket','2025-01-06 21:54:28','tracking',4,'alexcruz adicionou um acompanhamento'),
(109,16,'ticket','2025-01-06 21:54:40','tracking',4,'alexcruz atualizou um item'),
(110,16,'ticket','2025-01-06 21:55:04','tracking',4,'alexcruz atualizou um item'),
(111,10,'users','2025-01-06 22:05:37','setup',4,'paulovictorfds adicionou o item luanmedeiros'),
(112,0,'system','2025-01-06 22:51:07','login',3,'paulovictorfds fez login no IP 187.19.242.209'),
(113,0,'system','2025-01-07 11:11:10','login',3,'tecnomulti fez login no IP 177.89.21.161'),
(114,0,'system','2025-01-07 11:12:52','login',3,'Login falhou para luanmedeiros no IP 177.89.21.161'),
(115,0,'system','2025-01-07 11:13:11','login',3,'Login falhou para luanmedeiros no IP 177.89.21.161'),
(116,0,'system','2025-01-07 11:13:44','login',3,'alexcruz fez login no IP 177.89.21.161'),
(117,10,'users','2025-01-07 11:16:17','setup',5,'alexcruz atualizou um item'),
(118,0,'system','2025-01-07 11:17:03','login',3,'Luanmedeiros fez login no IP 177.89.21.161'),
(119,0,'system','2025-01-07 11:20:11','login',3,'alexcruz fez login no IP 177.89.21.161'),
(120,0,'system','2025-01-07 13:30:09','login',3,'alexcruz fez login no IP 177.89.21.161'),
(121,0,'system','2025-01-07 13:37:00','login',3,'Login falhou para denilson.marques@tecnomulti.com no IP 168.196.199.10'),
(122,0,'system','2025-01-07 13:38:18','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(123,17,'ticket','2025-01-07 13:39:34','tracking',4,'tecnomulti adicionou o item 17'),
(124,0,'system','2025-01-07 13:41:27','login',3,'tecnomulti fez login no IP 177.89.21.161'),
(125,0,'system','2025-01-07 13:43:46','login',3,'Login falhou para Tecnomulti no IP 168.196.199.15'),
(126,0,'system','2025-01-07 13:44:19','login',3,'tecnomulti fez login no IP 168.196.199.15'),
(127,17,'ticket','2025-01-07 13:48:56','tracking',4,'alexcruz adicionou um acompanhamento'),
(128,17,'ticket','2025-01-07 13:49:01','tracking',4,'alexcruz atualizou um item'),
(129,17,'ticket','2025-01-07 13:49:27','tracking',4,'alexcruz atualizou um item'),
(130,0,'system','2025-01-07 13:52:37','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(131,18,'ticket','2025-01-07 13:56:33','tracking',4,'tecnomulti adicionou o item 18'),
(132,18,'ticket','2025-01-07 13:57:45','tracking',4,'alexcruz adicionou um acompanhamento'),
(133,18,'ticket','2025-01-07 13:57:50','tracking',4,'alexcruz atualizou um item'),
(134,18,'ticket','2025-01-07 13:58:07','tracking',4,'alexcruz atualizou um item'),
(135,0,'system','2025-01-07 14:05:38','login',3,'Login falhou para luanmedeiros no IP 177.89.21.161'),
(136,0,'system','2025-01-07 14:06:18','login',3,'Login falhou para luanmedeiros no IP 168.196.199.15'),
(137,0,'system','2025-01-07 14:07:19','login',3,'Login falhou para luanmedeiros no IP 168.196.199.15'),
(138,0,'system','2025-01-07 14:07:32','login',3,'Login falhou para luanmedeiros no IP 177.89.21.161'),
(139,10,'users','2025-01-07 14:08:04','setup',5,'alexcruz atualizou um item'),
(140,0,'system','2025-01-07 14:08:17','login',3,'luanmedeiros fez login no IP 177.89.21.161'),
(141,0,'system','2025-01-07 14:08:52','login',3,'Login falhou para luanmedeiros no IP 168.196.199.15'),
(142,0,'system','2025-01-07 14:09:10','login',3,'Login falhou para luanmedeiros no IP 168.196.199.15'),
(143,0,'system','2025-01-07 14:10:42','login',3,'luanmedeiros fez login no IP 168.196.199.15'),
(144,0,'system','2025-01-07 14:23:32','Impersonate',3,'alexcruz começa a personificar o usuário luanmedeiros'),
(145,0,'system','2025-01-07 14:25:17','login',3,'alexcruz fez login no IP 177.89.21.161'),
(146,0,'system','2025-01-07 15:02:51','login',3,'Login falhou para  no IP 187.19.242.209'),
(147,0,'system','2025-01-07 15:03:05','login',3,'paulovictorfds fez login no IP 187.19.242.209'),
(148,0,'system','2025-01-07 15:15:50','Impersonate',3,'paulovictorfds começa a personificar o usuário luanmedeiros'),
(149,0,'system','2025-01-07 15:16:23','Impersonate',3,'paulovictorfds pára de personificar o usuário luanmedeiros'),
(150,0,'system','2025-01-07 15:17:55','Impersonate',3,'paulovictorfds começa a personificar o usuário luanmedeiros'),
(151,0,'system','2025-01-07 15:19:00','Impersonate',3,'paulovictorfds pára de personificar o usuário luanmedeiros'),
(152,5,'profiles','2025-01-07 15:21:15','setup',4,'paulovictorfds atualizou um item'),
(153,0,'system','2025-01-07 15:25:13','Impersonate',3,'paulovictorfds começa a personificar o usuário luanmedeiros'),
(154,0,'system','2025-01-07 15:27:33','Impersonate',3,'paulovictorfds pára de personificar o usuário luanmedeiros'),
(155,0,'system','2025-01-07 15:27:57','login',3,'luanmedeiros fez login no IP 177.89.21.161'),
(156,0,'system','2025-01-07 18:03:26','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(157,0,'system','2025-01-07 19:28:34','login',3,'Login falhou para  no IP 177.173.228.200'),
(158,0,'system','2025-01-08 09:35:53','login',3,'tecnomulti fez login no IP 179.73.180.177'),
(159,19,'ticket','2025-01-08 09:38:38','tracking',4,'tecnomulti adicionou o item 19'),
(160,0,'system','2025-01-08 12:18:53','login',3,'alexcruz fez login no IP 187.61.153.218'),
(161,8,'users','2025-01-08 12:19:53','setup',5,'alexcruz atualizou um item'),
(162,0,'system','2025-01-08 12:20:04','login',3,'alexcruz fez login no IP 187.61.153.218'),
(163,19,'ticket','2025-01-08 12:22:46','tracking',4,'alexcruz adicionou um acompanhamento'),
(164,19,'ticket','2025-01-08 12:22:58','tracking',4,'alexcruz atualizou um item'),
(165,17,'ticket','2025-01-08 12:28:46','tracking',4,'alexcruz atualizou um item'),
(166,0,'system','2025-01-08 13:08:02','login',3,'tecnomulti fez login no IP 191.33.89.21'),
(167,20,'ticket','2025-01-08 13:21:24','tracking',4,'tecnomulti adicionou o item 20'),
(168,20,'ticket','2025-01-08 13:26:44','tracking',4,'alexcruz atualizou um item'),
(169,20,'ticket','2025-01-08 13:26:58','tracking',4,'alexcruz adicionou um acompanhamento'),
(170,20,'ticket','2025-01-08 13:36:33','tracking',4,'alexcruz adicionou um acompanhamento'),
(171,20,'ticket','2025-01-08 13:36:39','tracking',4,'alexcruz atualizou um item'),
(172,4,'ITILCategory','2025-01-08 13:47:21','setup',4,'alexcruz adicionou o item Sistemas VIVO/FIBRASIL'),
(173,0,'system','2025-01-08 14:31:26','login',3,'paulovictorfds fez login no IP 187.19.242.209'),
(174,0,'system','2025-01-08 16:34:41','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(175,21,'ticket','2025-01-08 16:36:37','tracking',4,'tecnomulti adicionou o item 21'),
(176,0,'system','2025-01-08 17:24:24','login',3,'luanmedeiros fez login no IP 177.89.21.161'),
(177,0,'system','2025-01-08 18:18:09','login',3,'tecnomulti fez login no IP 191.33.89.21'),
(178,0,'system','2025-01-08 20:02:28','login',3,'alexcruz fez login no IP 187.61.153.218'),
(179,21,'ticket','2025-01-08 20:03:48','tracking',4,'alexcruz atualizou um item'),
(180,21,'ticket','2025-01-08 20:04:08','tracking',4,'alexcruz adicionou um acompanhamento'),
(181,5,'ITILCategory','2025-01-08 20:05:13','setup',4,'alexcruz adicionou o item Sistema Operacional/Programas'),
(182,21,'ticket','2025-01-08 20:06:12','tracking',4,'alexcruz atualizou um item'),
(183,4,'ITILCategory','2025-01-08 20:06:44','setup',4,'alexcruz atualizou um item'),
(184,19,'ticket','2025-01-08 20:15:05','tracking',4,'alexcruz atualizou um item'),
(185,21,'ticket','2025-01-08 20:42:42','tracking',4,'alexcruz adicionou um acompanhamento'),
(186,21,'ticket','2025-01-08 20:42:44','tracking',4,'alexcruz atualizou um item'),
(187,21,'ticket','2025-01-08 20:42:50','tracking',4,'alexcruz atualizou um item'),
(188,0,'system','2025-01-08 23:41:21','login',3,'Login falhou para  no IP 187.19.242.209'),
(189,0,'system','2025-01-08 23:41:27','login',3,'paulovictorfds fez login no IP 187.19.242.209'),
(190,0,'system','2025-01-09 10:05:04','login',3,'Login falhou para Alexcruz no IP 177.51.13.51'),
(191,0,'system','2025-01-09 10:06:58','login',3,'Login falhou para alexcruz no IP 177.51.13.51'),
(192,0,'system','2025-01-09 10:07:43','login',3,'alexcruz fez login no IP 177.51.13.51'),
(193,0,'system','2025-01-09 17:51:26','login',3,'tecnomulti fez login no IP 168.196.198.177'),
(194,0,'system','2025-01-09 17:56:08','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(195,22,'ticket','2025-01-09 17:57:23','tracking',4,'tecnomulti adicionou o item 22'),
(196,0,'system','2025-01-09 17:58:24','login',3,'tecnomulti fez login no IP 177.121.123.16'),
(197,23,'ticket','2025-01-09 18:02:47','tracking',4,'tecnomulti adicionou o item 23'),
(198,0,'system','2025-01-09 18:09:34','login',3,'tecnomulti fez login no IP 200.215.224.210'),
(199,0,'system','2025-01-09 19:39:02','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(200,0,'system','2025-01-09 22:50:37','login',3,'Login falhou para  no IP 187.19.242.209'),
(201,0,'system','2025-01-09 22:50:42','login',3,'paulovictorfds fez login no IP 187.19.242.209'),
(202,0,'system','2025-01-09 23:58:12','login',3,'Login falhou para  no IP 187.61.153.218'),
(203,0,'system','2025-01-09 23:58:45','login',3,'Login falhou para alexcruz no IP 187.61.153.218'),
(204,0,'system','2025-01-09 23:59:08','login',3,'alexcruz fez login no IP 187.61.153.218'),
(205,22,'ticket','2025-01-09 23:59:55','tracking',4,'alexcruz atualizou um item'),
(206,22,'ticket','2025-01-10 00:00:28','tracking',4,'alexcruz adicionou um acompanhamento'),
(207,22,'ticket','2025-01-10 00:00:31','tracking',4,'alexcruz atualizou um item'),
(208,22,'ticket','2025-01-10 00:55:32','tracking',4,'alexcruz adicionou um acompanhamento'),
(209,22,'ticket','2025-01-10 00:55:36','tracking',4,'alexcruz atualizou um item'),
(210,19,'ticket','2025-01-10 00:56:50','tracking',4,'alexcruz atualizou um item'),
(211,23,'ticket','2025-01-10 01:00:23','tracking',4,'alexcruz adicionou um acompanhamento'),
(212,23,'ticket','2025-01-10 01:00:29','tracking',4,'alexcruz atualizou um item'),
(213,0,'system','2025-01-10 01:33:52','login',3,'tecnomulti fez login no IP 187.19.242.209'),
(214,23,'ticket','2025-01-10 11:35:30','tracking',4,'tecnomulti adicionou um acompanhamento'),
(215,0,'system','2025-01-10 16:40:09','login',3,'Login falhou para  no IP 168.196.199.10'),
(216,0,'system','2025-01-10 16:40:14','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(217,24,'ticket','2025-01-10 16:41:54','tracking',4,'tecnomulti adicionou o item 24'),
(218,0,'system','2025-01-10 16:43:58','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(219,0,'system','2025-01-10 16:44:13','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(220,0,'system','2025-01-10 16:44:17','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(221,25,'ticket','2025-01-10 16:45:39','tracking',4,'tecnomulti adicionou o item 25'),
(222,0,'system','2025-01-10 16:45:51','login',3,'luanmedeiros fez login no IP 177.89.21.161'),
(223,26,'ticket','2025-01-10 16:45:54','tracking',4,'tecnomulti adicionou o item 26'),
(224,27,'ticket','2025-01-10 16:46:13','tracking',4,'tecnomulti adicionou o item 27'),
(225,0,'system','2025-01-10 20:53:27','login',3,'alexcruz fez login no IP 187.61.153.218'),
(226,23,'ticket','2025-01-10 20:54:27','tracking',4,'alexcruz adicionou um acompanhamento'),
(227,23,'ticket','2025-01-10 20:54:29','tracking',4,'alexcruz atualizou um item'),
(228,23,'ticket','2025-01-10 20:54:39','tracking',4,'alexcruz atualizou um item'),
(229,0,'system','2025-01-10 21:15:16','login',3,'Login falhou para  no IP 187.19.242.209'),
(230,0,'system','2025-01-10 21:15:19','login',3,'paulovictorfds fez login no IP 187.19.242.209'),
(231,0,'Plugin','2025-01-10 21:20:07','setup',3,'Plugin Form Creator foi instalado por Souza Paulo Victor (7).'),
(232,0,'Plugin','2025-01-10 21:20:16','setup',3,'Plugin Form Creator foi ativado por Souza Paulo Victor (7).'),
(233,0,'system','2025-01-12 17:56:18','login',3,'paulovictorfds fez login no IP 187.19.242.209'),
(234,0,'system','2025-01-13 11:35:19','login',3,'Login falhou para alexcruz no IP 177.89.21.161'),
(235,0,'system','2025-01-13 11:35:45','login',3,'Login falhou para alexcruz no IP 177.89.21.161'),
(236,0,'system','2025-01-13 11:36:12','login',3,'alexcruz fez login no IP 177.89.21.161'),
(237,24,'ticket','2025-01-13 11:37:26','tracking',4,'alexcruz adicionou um acompanhamento'),
(238,24,'ticket','2025-01-13 11:37:37','tracking',4,'alexcruz atualizou um item'),
(239,25,'ticket','2025-01-13 11:38:17','tracking',4,'alexcruz adicionou um acompanhamento'),
(240,25,'ticket','2025-01-13 11:38:27','tracking',4,'alexcruz atualizou um item'),
(241,27,'ticket','2025-01-13 11:39:16','tracking',4,'alexcruz adicionou um acompanhamento'),
(242,26,'ticket','2025-01-13 11:39:55','tracking',4,'alexcruz adicionou um acompanhamento'),
(243,26,'ticket','2025-01-13 11:40:00','tracking',4,'alexcruz atualizou um item'),
(244,27,'ticket','2025-01-13 11:40:20','tracking',4,'alexcruz atualizou um item'),
(245,23,'ticket','2025-01-13 11:40:41','tracking',4,'alexcruz atualizou um item'),
(246,0,'system','2025-01-13 12:15:38','login',3,'tecnomulti fez login no IP 177.89.21.161'),
(247,0,'system','2025-01-13 12:29:32','login',3,'Login falhou para  no IP 168.196.199.10'),
(248,0,'system','2025-01-13 12:29:35','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(249,0,'system','2025-01-13 12:32:32','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(250,28,'ticket','2025-01-13 12:35:41','tracking',4,'tecnomulti adicionou o item 28'),
(251,28,'ticket','2025-01-13 12:37:33','tracking',4,'alexcruz adicionou um acompanhamento'),
(252,28,'ticket','2025-01-13 12:39:20','tracking',4,'tecnomulti adicionou um acompanhamento'),
(253,28,'ticket','2025-01-13 12:39:22','tracking',4,'alexcruz atualizou um item'),
(254,28,'ticket','2025-01-13 12:40:07','tracking',4,'alexcruz adicionou um acompanhamento'),
(255,28,'ticket','2025-01-13 12:41:55','tracking',4,'tecnomulti adicionou um acompanhamento'),
(256,0,'system','2025-01-13 12:47:54','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(257,29,'ticket','2025-01-13 12:51:07','tracking',4,'tecnomulti adicionou o item 29'),
(258,29,'ticket','2025-01-13 12:56:24','tracking',4,'alexcruz adicionou um acompanhamento'),
(259,29,'ticket','2025-01-13 12:56:29','tracking',4,'alexcruz atualizou um item'),
(260,0,'system','2025-01-13 13:19:41','login',3,'paulovictorfds fez login no IP 187.19.242.209'),
(261,29,'ticket','2025-01-13 13:29:54','tracking',4,'alexcruz adicionou um acompanhamento'),
(262,29,'ticket','2025-01-13 13:30:03','tracking',4,'alexcruz atualizou um item'),
(263,29,'ticket','2025-01-13 13:31:06','tracking',4,'alexcruz atualizou um item'),
(264,0,'system','2025-01-13 13:41:56','login',3,'tecnomulti fez login no IP 177.89.21.161'),
(265,28,'ticket','2025-01-13 13:42:54','tracking',4,'alexcruz adicionou um acompanhamento'),
(266,28,'ticket','2025-01-13 13:43:05','tracking',4,'alexcruz atualizou um item'),
(267,0,'system','2025-01-13 20:37:13','login',3,'Login falhou para  no IP 187.19.242.209'),
(268,0,'system','2025-01-13 20:37:19','login',3,'paulovictorfds fez login no IP 187.19.242.209'),
(269,0,'system','2025-01-13 23:58:47','login',3,'paulovictorfds fez login no IP 187.19.242.209'),
(270,0,'system','2025-01-14 03:08:33','login',3,'paulovictorfds fez login no IP 187.19.242.209'),
(271,0,'system','2025-01-14 08:04:26','login',3,'paulovictorfds fez login no IP 187.19.242.209'),
(272,0,'system','2025-01-14 14:07:20','login',3,'tecnomulti fez login no IP 45.224.114.167'),
(273,30,'ticket','2025-01-14 14:18:23','tracking',4,'tecnomulti adicionou o item 30'),
(274,0,'system','2025-01-14 15:30:46','login',3,'Login falhou para alexcruz no IP 177.89.21.161'),
(275,0,'system','2025-01-14 15:31:42','login',3,'alexcruz fez login no IP 177.89.21.161'),
(276,30,'ticket','2025-01-14 15:33:04','tracking',4,'alexcruz adicionou um acompanhamento'),
(277,30,'ticket','2025-01-14 15:33:14','tracking',4,'alexcruz atualizou um item'),
(278,24,'ticket','2025-01-14 15:38:20','tracking',4,'alexcruz adicionou um acompanhamento'),
(279,24,'ticket','2025-01-14 15:38:26','tracking',4,'alexcruz atualizou um item'),
(280,27,'ticket','2025-01-14 15:38:37','tracking',4,'alexcruz adicionou um acompanhamento'),
(281,27,'ticket','2025-01-14 15:38:44','tracking',4,'alexcruz atualizou um item'),
(282,25,'ticket','2025-01-14 15:38:55','tracking',4,'alexcruz adicionou um acompanhamento'),
(283,25,'ticket','2025-01-14 15:39:01','tracking',4,'alexcruz atualizou um item'),
(284,26,'ticket','2025-01-14 15:39:13','tracking',4,'alexcruz adicionou um acompanhamento'),
(285,26,'ticket','2025-01-14 15:39:17','tracking',4,'alexcruz atualizou um item'),
(286,0,'system','2025-01-14 16:36:00','login',3,'tecnomulti fez login no IP 45.224.114.167'),
(287,30,'ticket','2025-01-14 16:40:01','tracking',4,'tecnomulti adicionou um acompanhamento'),
(288,0,'system','2025-01-14 18:20:36','login',3,'tecnomulti fez login no IP 45.224.114.167'),
(289,0,'system','2025-01-14 18:25:12','login',3,'tecnomulti fez login no IP 45.224.114.167'),
(290,0,'system','2025-01-14 18:39:19','login',3,'luanmedeiros fez login no IP 177.89.21.161'),
(291,30,'ticket','2025-01-14 18:42:21','tracking',4,'luanmedeiros adicionou um acompanhamento'),
(292,0,'system','2025-01-14 18:53:35','login',3,'tecnomulti fez login no IP 179.55.108.86'),
(293,31,'ticket','2025-01-14 18:57:19','tracking',4,'tecnomulti adicionou o item 31'),
(294,0,'system','2025-01-14 19:34:03','login',3,'alexcruz fez login no IP 177.89.21.161'),
(295,30,'ticket','2025-01-14 19:35:18','tracking',4,'alexcruz adicionou um acompanhamento'),
(296,30,'ticket','2025-01-14 19:35:24','tracking',4,'alexcruz atualizou um item'),
(297,0,'system','2025-01-14 19:38:13','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(298,32,'ticket','2025-01-14 19:40:44','tracking',4,'tecnomulti adicionou o item 32'),
(299,31,'ticket','2025-01-14 19:58:44','tracking',4,'luanmedeiros adicionou um acompanhamento'),
(300,31,'ticket','2025-01-14 19:58:58','tracking',4,'luanmedeiros atualizou um encaminhamento'),
(301,31,'ticket','2025-01-14 20:01:17','tracking',4,'luanmedeiros atualizou um item'),
(302,32,'ticket','2025-01-14 20:07:08','tracking',4,'luanmedeiros adicionou um acompanhamento'),
(303,32,'ticket','2025-01-14 20:09:39','tracking',4,'alexcruz atualizou um item'),
(304,2,'notifications','2025-01-14 20:45:02','notification',4,'paulovictorfds atualizou um item'),
(305,34,'notificationtemplates','2025-01-14 20:47:39','notification',4,'paulovictorfds adicionou o item notificação sonora'),
(306,34,'notificationtemplatetranslations','2025-01-14 20:49:12','notification',4,'paulovictorfds adicionou o item '),
(307,78,'notifications','2025-01-14 20:50:51','notification',4,'paulovictorfds adicionou o item novo ticket alerta sonoro'),
(308,0,'system','2025-01-14 20:52:46','setup',3,'paulovictorfds editou a configuração de notificações dos navegadores'),
(309,0,'system','2025-01-14 20:53:30','login',3,'paulovictorfds fez login no IP 187.19.242.209'),
(310,0,'system','2025-01-14 20:54:11','setup',3,'paulovictorfds editou a configuração de notificações dos navegadores'),
(311,35,'notificationtemplates','2025-01-14 20:58:17','notification',4,'paulovictorfds adicionou o item teste'),
(312,0,'system','2025-01-14 21:23:49','login',3,'paulovictorfds fez login no IP 187.19.242.209'),
(313,0,'system','2025-01-14 21:27:13','login',3,'tecnomulti fez login no IP 187.19.242.209'),
(314,33,'ticket','2025-01-14 21:27:27','tracking',4,'tecnomulti adicionou o item 33'),
(315,0,'system','2025-01-14 21:32:52','setup',3,'paulovictorfds editou a configuração de notificações dos navegadores'),
(316,0,'system','2025-01-14 21:33:05','setup',3,'paulovictorfds editou a configuração de notificações dos navegadores'),
(317,0,'system','2025-01-14 21:33:17','setup',3,'paulovictorfds editou a configuração de notificações dos navegadores'),
(318,0,'system','2025-01-14 21:33:29','setup',3,'paulovictorfds editou a configuração de notificações dos navegadores'),
(319,36,'notificationtemplates','2025-01-14 21:36:25','notification',4,'paulovictorfds adicionou o item Chamados'),
(320,37,'notificationtemplates','2025-01-14 21:38:17','notification',4,'paulovictorfds adicionou o item Chamados'),
(321,35,'notificationtemplatetranslations','2025-01-14 21:39:22','notification',4,'paulovictorfds adicionou o item pt_BR'),
(322,36,'notificationtemplatetranslations','2025-01-14 21:40:17','notification',4,'paulovictorfds adicionou o item pt_BR'),
(323,34,'ticket','2025-01-14 21:41:20','tracking',4,'tecnomulti adicionou o item 34'),
(324,37,'notificationtemplatetranslations','2025-01-14 21:44:46','notification',4,'paulovictorfds adicionou o item '),
(325,35,'ticket','2025-01-14 21:49:45','tracking',4,'tecnomulti adicionou o item 35'),
(326,0,'system','2025-01-15 10:56:58','login',3,'alexcruz fez login no IP 177.89.21.161'),
(327,0,'system','2025-01-15 19:01:41','login',3,'tecnomulti fez login no IP 45.224.114.167'),
(328,36,'ticket','2025-01-15 19:02:56','tracking',4,'tecnomulti adicionou o item 36'),
(329,1,'PluginFormcreatorCategory','2025-01-15 23:53:23','setup',4,'paulovictorfds adicionou o item Chamado'),
(330,0,'system','2025-01-16 00:16:26','login',3,'tecnomulti fez login no IP 187.19.242.209'),
(331,37,'ticket','2025-01-16 00:34:24','tracking',4,'tecnomulti adicionou o item 37'),
(332,38,'ticket','2025-01-16 00:52:50','tracking',4,'tecnomulti adicionou o item 38'),
(333,7,'RequestType','2025-01-16 00:57:44','setup',4,'paulovictorfds atualizou um item'),
(334,39,'ticket','2025-01-16 01:10:05','tracking',4,'tecnomulti adicionou o item 39'),
(335,9,'users','2025-01-16 01:17:34','setup',5,'paulovictorfds atualizou um item'),
(336,1,'profiles','2025-01-16 01:21:16','setup',4,'paulovictorfds atualizou um item'),
(337,2,'TicketTemplate','2025-01-16 01:21:55','setup',4,'paulovictorfds adicionou o item FormCreator'),
(338,1,'profiles','2025-01-16 01:26:11','setup',4,'paulovictorfds atualizou um item'),
(339,1,'profiles','2025-01-16 01:48:54','setup',4,'paulovictorfds atualizou um item'),
(340,1,'profiles','2025-01-16 01:49:35','setup',4,'paulovictorfds atualizou um item'),
(341,0,'system','2025-01-16 01:51:37','login',3,'tecnomulti fez login no IP 187.19.242.209'),
(342,40,'ticket','2025-01-16 01:52:08','tracking',4,'tecnomulti adicionou o item 40'),
(343,41,'ticket','2025-01-16 01:53:32','tracking',4,'tecnomulti adicionou o item 41'),
(344,3,'Entity','2025-01-16 01:54:14','setup',4,'paulovictorfds adicionou o item Wintech'),
(345,2,'Entity','2025-01-16 01:54:27','setup',4,'paulovictorfds atualizou um item'),
(346,0,'system','2025-01-16 01:56:44','login',3,'paulovictorfds fez login no IP 187.19.242.209'),
(347,0,'system','2025-01-16 01:56:56','login',3,'tecnomulti fez login no IP 187.19.242.209'),
(348,42,'ticket','2025-01-16 01:57:47','tracking',4,'tecnomulti adicionou o item 42'),
(349,0,'system','2025-01-16 02:07:18','login',3,'tecnomulti fez login no IP 187.19.242.209'),
(350,9,'users','2025-01-16 02:20:44','setup',5,'paulovictorfds atualizou um item'),
(351,0,'system','2025-01-16 02:20:45','login',3,'tecnomulti fez login no IP 187.61.153.218'),
(352,0,'system','2025-01-16 02:21:56','Impersonate',3,'paulovictorfds começa a personificar o usuário tecnomulti'),
(353,0,'system','2025-01-16 02:22:00','Impersonate',3,'paulovictorfds pára de personificar o usuário tecnomulti'),
(354,1,'profiles','2025-01-16 03:05:46','setup',4,'paulovictorfds atualizou um item'),
(355,0,'system','2025-01-16 03:06:05','login',3,'tecnomulti fez login no IP 187.61.153.218'),
(356,1,'profiles','2025-01-16 03:06:29','setup',4,'paulovictorfds atualizou um item'),
(357,0,'system','2025-01-16 03:09:09','login',3,'tecnomulti fez login no IP 187.19.242.209'),
(358,0,'system','2025-01-16 10:55:57','login',3,'Login falhou para  no IP 45.224.114.167'),
(359,0,'system','2025-01-16 10:56:18','login',3,'tecnomulti fez login no IP 45.224.114.167'),
(360,0,'system','2025-01-16 10:58:08','login',3,'luanmedeiros fez login no IP 177.89.21.161'),
(361,43,'ticket','2025-01-16 10:59:30','tracking',4,'tecnomulti adicionou o item 43'),
(362,0,'system','2025-01-16 12:46:12','login',3,'alexcruz fez login no IP 187.61.153.218'),
(363,43,'ticket','2025-01-16 12:47:46','tracking',4,'alexcruz adicionou um acompanhamento'),
(364,43,'ticket','2025-01-16 12:47:58','tracking',4,'alexcruz atualizou um item'),
(365,43,'ticket','2025-01-16 13:14:20','tracking',4,'alexcruz adicionou um acompanhamento'),
(366,43,'ticket','2025-01-16 13:21:48','tracking',4,'alexcruz adicionou um acompanhamento'),
(367,43,'ticket','2025-01-16 13:21:59','tracking',4,'alexcruz atualizou um item'),
(368,0,'system','2025-01-16 19:42:51','login',3,'Login falhou para  no IP 179.73.198.53'),
(369,0,'system','2025-01-16 19:42:56','login',3,'tecnomulti fez login no IP 179.73.198.53'),
(370,0,'system','2025-01-17 12:01:52','login',3,'Login falhou para  no IP 177.89.21.161'),
(371,0,'system','2025-01-17 12:01:56','login',3,'alexcruz fez login no IP 177.89.21.161'),
(372,43,'ticket','2025-01-17 12:02:32','tracking',4,'alexcruz atualizou um item'),
(373,36,'ticket','2025-01-17 12:03:23','tracking',4,'alexcruz adicionou um acompanhamento'),
(374,36,'ticket','2025-01-17 12:03:35','tracking',4,'alexcruz atualizou um item'),
(375,0,'system','2025-01-17 12:16:00','login',3,'tecnomulti fez login no IP 177.89.21.161'),
(376,32,'ticket','2025-01-17 12:38:32','tracking',4,'alexcruz atualizou um item'),
(377,0,'system','2025-01-17 14:40:55','login',3,'tecnomulti fez login no IP 177.89.21.161'),
(378,0,'system','2025-01-17 14:44:17','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(379,44,'ticket','2025-01-17 14:47:06','tracking',4,'tecnomulti adicionou o item 44'),
(380,0,'system','2025-01-17 14:57:39','login',3,'tecnomulti fez login no IP 177.89.21.161'),
(381,0,'system','2025-01-17 17:38:23','login',3,'luanmedeiros fez login no IP 177.89.21.161'),
(382,44,'ticket','2025-01-17 17:57:43','tracking',4,'luanmedeiros adicionou um acompanhamento'),
(383,0,'system','2025-01-17 17:59:17','login',3,'tecnomulti fez login no IP 177.37.172.189'),
(384,44,'ticket','2025-01-17 18:00:59','tracking',4,'luanmedeiros atualizou um item'),
(385,45,'ticket','2025-01-17 18:01:10','tracking',4,'tecnomulti adicionou o item 45'),
(386,0,'system','2025-01-18 01:57:39','login',3,'tecnomulti fez login no IP 187.19.242.89'),
(387,0,'system','2025-01-18 03:01:34','login',3,'Login falhou para  no IP 187.19.242.89'),
(388,0,'system','2025-01-18 03:01:38','login',3,'paulovictorfds fez login no IP 187.19.242.89'),
(389,0,'system','2025-01-18 06:19:03','login',3,'Login falhou para  no IP 187.19.242.89'),
(390,0,'system','2025-01-18 06:19:06','login',3,'paulovictorfds fez login no IP 187.19.242.89'),
(391,0,'system','2025-01-18 06:19:15','login',3,'paulovictorfds fez login no IP 187.19.242.89'),
(392,4,'Entity','2025-01-19 04:48:46','setup',4,'paulovictorfds adicionou o item test'),
(393,1,'UserCategory','2025-01-19 04:55:51','setup',4,'paulovictorfds adicionou o item Cliente Loja'),
(394,1,'profiles','2025-01-19 04:59:02','setup',4,'paulovictorfds atualizou um item'),
(395,0,'system','2025-01-19 04:59:27','login',3,'tecnomulti fez login no IP 187.19.242.89'),
(396,1,'profiles','2025-01-19 04:59:41','setup',4,'paulovictorfds atualizou um item'),
(397,0,'system','2025-01-19 05:04:21','login',3,'tecnomulti fez login no IP 187.19.242.89'),
(398,1,'profiles','2025-01-19 05:04:37','setup',4,'paulovictorfds atualizou um item'),
(399,0,'system','2025-01-19 05:04:48','login',3,'tecnomulti fez login no IP 187.19.242.89'),
(400,7,'users','2025-01-19 05:23:25','setup',5,'paulovictorfds atualizou um item'),
(401,7,'users','2025-01-19 05:23:57','setup',4,'paulovictorfds adicionou um usuário a uma entidade'),
(402,0,'system','2025-01-19 05:26:02','login',3,'paulovictorfds fez login no IP 187.19.242.89'),
(403,7,'users','2025-01-19 05:28:34','setup',4,'paulovictorfds adicionou um usuário a uma entidade'),
(404,0,'system','2025-01-19 05:28:38','login',3,'paulovictorfds fez login no IP 187.19.242.89'),
(405,0,'system','2025-01-19 05:48:43','login',3,'tecnomulti fez login no IP 187.19.242.89'),
(406,0,'system','2025-01-20 11:06:12','login',3,'luanmedeiros fez login no IP 177.89.21.161'),
(407,45,'ticket','2025-01-20 11:08:13','tracking',4,'luanmedeiros adicionou um acompanhamento'),
(408,45,'ticket','2025-01-20 11:14:42','tracking',4,'luanmedeiros atualizou um item'),
(409,0,'system','2025-01-20 11:18:26','login',3,'tecnomulti fez login no IP 177.37.172.237'),
(410,46,'ticket','2025-01-20 11:22:02','tracking',4,'tecnomulti adicionou o item 46'),
(411,0,'system','2025-01-20 11:22:03','login',3,'Login falhou para  no IP 177.89.21.161'),
(412,0,'system','2025-01-20 11:22:09','login',3,'alexcruz fez login no IP 177.89.21.161'),
(413,46,'ticket','2025-01-20 11:23:38','tracking',4,'alexcruz adicionou um acompanhamento'),
(414,46,'ticket','2025-01-20 11:23:46','tracking',4,'alexcruz atualizou um item'),
(415,44,'ticket','2025-01-20 11:47:29','tracking',4,'alexcruz atualizou um item'),
(416,0,'system','2025-01-20 13:27:09','login',3,'Login falhou para Tecnomulti no IP 179.251.185.93'),
(417,0,'system','2025-01-20 13:28:17','login',3,'Login falhou para Tecnomulti no IP 179.251.185.93'),
(418,0,'system','2025-01-20 13:30:02','login',3,'Login falhou para Tecnomulti no IP 177.79.38.105'),
(419,32,'ticket','2025-01-20 13:30:58','tracking',4,'alexcruz adicionou um acompanhamento'),
(420,32,'ticket','2025-01-20 13:31:02','tracking',4,'alexcruz atualizou um item'),
(421,0,'system','2025-01-20 13:36:02','login',3,'tecnomulti fez login no IP 179.251.185.93'),
(422,47,'ticket','2025-01-20 13:39:01','tracking',4,'tecnomulti adicionou o item 47'),
(423,0,'system','2025-01-20 14:03:15','login',3,'tecnomulti fez login no IP 179.251.185.93'),
(424,48,'ticket','2025-01-20 14:05:41','tracking',4,'tecnomulti adicionou o item 48'),
(425,46,'ticket','2025-01-20 14:21:01','tracking',4,'alexcruz adicionou um acompanhamento'),
(426,46,'ticket','2025-01-20 14:21:10','tracking',4,'alexcruz atualizou um item'),
(427,45,'ticket','2025-01-20 14:21:50','tracking',4,'alexcruz adicionou um acompanhamento'),
(428,45,'ticket','2025-01-20 14:21:56','tracking',4,'alexcruz atualizou um item'),
(429,47,'ticket','2025-01-20 14:23:36','tracking',4,'alexcruz adicionou um acompanhamento'),
(430,47,'ticket','2025-01-20 14:23:41','tracking',4,'alexcruz atualizou um item'),
(431,47,'ticket','2025-01-20 14:32:58','tracking',4,'alexcruz adicionou um acompanhamento'),
(432,47,'ticket','2025-01-20 14:33:05','tracking',4,'alexcruz atualizou um item'),
(433,48,'ticket','2025-01-20 14:35:46','tracking',4,'alexcruz adicionou um acompanhamento'),
(434,48,'ticket','2025-01-20 14:35:54','tracking',4,'alexcruz atualizou um item'),
(435,0,'system','2025-01-21 00:17:02','login',3,'tecnomulti fez login no IP 187.61.153.218'),
(436,49,'ticket','2025-01-21 00:18:58','tracking',4,'tecnomulti adicionou o item 49'),
(437,0,'system','2025-01-21 00:21:51','login',3,'Login falhou para alexcruz no IP 187.61.153.218'),
(438,0,'system','2025-01-21 00:22:09','login',3,'Login falhou para alexcruz no IP 187.61.153.218'),
(439,0,'system','2025-01-21 00:22:29','login',3,'alexcruz fez login no IP 187.61.153.218'),
(440,49,'ticket','2025-01-21 00:23:57','tracking',4,'alexcruz adicionou um acompanhamento'),
(441,49,'ticket','2025-01-21 00:24:05','tracking',4,'alexcruz atualizou um item'),
(442,0,'system','2025-01-21 00:24:49','login',3,'tecnomulti fez login no IP 187.61.153.218'),
(443,0,'system','2025-01-21 00:31:46','login',3,'tecnomulti fez login no IP 187.61.153.218'),
(444,0,'system','2025-01-21 00:51:24','login',3,'tecnomulti fez login no IP 187.61.153.218'),
(445,0,'system','2025-01-21 00:54:30','login',3,'tecnomulti fez login no IP 187.61.153.218'),
(446,0,'system','2025-01-21 01:00:32','login',3,'tecnomulti fez login no IP 187.61.153.218'),
(447,0,'system','2025-01-21 02:39:14','login',3,'paulovictorfds fez login no IP 187.19.242.89'),
(448,0,'system','2025-01-21 11:12:08','login',3,'tecnomulti fez login no IP 179.83.138.239'),
(449,0,'system','2025-01-21 11:12:59','login',3,'Login falhou para  no IP 177.89.21.161'),
(450,0,'system','2025-01-21 11:13:11','login',3,'alexcruz fez login no IP 177.89.21.161'),
(451,49,'ticket','2025-01-21 11:13:32','tracking',4,'alexcruz excluiu um item'),
(452,50,'ticket','2025-01-21 11:27:28','tracking',4,'tecnomulti adicionou o item 50'),
(453,0,'system','2025-01-21 11:28:10','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(454,0,'system','2025-01-21 11:31:26','login',3,'luanmedeiros fez login no IP 177.89.21.161'),
(455,50,'ticket','2025-01-21 12:19:43','tracking',4,'alexcruz adicionou um acompanhamento'),
(456,50,'ticket','2025-01-21 12:19:45','tracking',4,'luanmedeiros adicionou um acompanhamento'),
(457,50,'ticket','2025-01-21 12:19:48','tracking',4,'alexcruz atualizou um item'),
(458,50,'ticket','2025-01-21 12:20:09','tracking',4,'alexcruz apagou o acompanhamento'),
(459,51,'ticket','2025-01-21 13:02:41','tracking',4,'tecnomulti adicionou o item 51'),
(460,0,'system','2025-01-21 13:46:52','login',3,'Login falhou para Tecnomulti no IP 179.105.130.242'),
(461,0,'system','2025-01-21 13:47:14','login',3,'tecnomulti fez login no IP 179.105.130.242'),
(462,52,'ticket','2025-01-21 13:50:24','tracking',4,'tecnomulti adicionou o item 52'),
(463,0,'system','2025-01-21 14:05:57','login',3,'tecnomulti ligou-se do IP 179.105.130.242'),
(464,52,'ticket','2025-01-21 14:27:29','tracking',4,'alexcruz adicionou um acompanhamento'),
(465,52,'ticket','2025-01-21 14:27:34','tracking',4,'alexcruz atualizou um item'),
(466,8,'users','2025-01-21 14:29:00','setup',5,'alexcruz atualizou um item'),
(467,52,'ticket','2025-01-21 14:31:24','tracking',4,'tecnomulti adicionou um acompanhamento'),
(468,52,'ticket','2025-01-21 14:33:36','tracking',4,'tecnomulti adicionou um acompanhamento'),
(469,52,'ticket','2025-01-21 14:40:49','tracking',4,'alexcruz adicionou um acompanhamento'),
(470,52,'ticket','2025-01-21 14:40:55','tracking',4,'alexcruz atualizou um item'),
(471,51,'ticket','2025-01-21 14:46:45','tracking',4,'luanmedeiros adicionou um acompanhamento'),
(472,52,'ticket','2025-01-21 15:05:39','tracking',4,'alexcruz adicionou um acompanhamento'),
(473,50,'ticket','2025-01-21 15:06:11','tracking',4,'alexcruz adicionou um acompanhamento'),
(474,50,'ticket','2025-01-21 15:06:20','tracking',4,'alexcruz atualizou um item'),
(475,52,'ticket','2025-01-21 15:27:09','tracking',4,'alexcruz adicionou um acompanhamento'),
(476,52,'ticket','2025-01-21 15:27:14','tracking',4,'alexcruz atualizou um item'),
(477,0,'system','2025-01-21 16:09:46','login',3,'Login falhou para  no IP 179.105.130.242'),
(478,0,'system','2025-01-21 18:27:56','login',3,'alexcruz fez login no IP 187.61.153.218'),
(479,0,'system','2025-01-21 19:02:04','login',3,'Login falhou para  no IP 187.61.153.218'),
(480,0,'system','2025-01-21 19:02:24','login',3,'Login falhou para alexcruz no IP 187.61.153.218'),
(481,0,'system','2025-01-21 19:02:42','login',3,'alexcruz fez login no IP 187.61.153.218'),
(482,0,'system','2025-01-22 10:57:40','login',3,'tecnomulti fez login no IP 179.251.185.93'),
(483,53,'ticket','2025-01-22 11:00:46','tracking',4,'tecnomulti adicionou o item 53'),
(484,0,'system','2025-01-22 11:09:55','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(485,54,'ticket','2025-01-22 11:12:01','tracking',4,'tecnomulti adicionou o item 54'),
(486,0,'system','2025-01-22 16:50:15','login',3,'Login falhou para  no IP 177.89.21.161'),
(487,0,'system','2025-01-22 16:50:19','login',3,'alexcruz fez login no IP 177.89.21.161'),
(488,54,'ticket','2025-01-22 16:52:44','tracking',4,'alexcruz adicionou um acompanhamento'),
(489,54,'ticket','2025-01-22 16:52:53','tracking',4,'alexcruz atualizou um item'),
(490,53,'ticket','2025-01-22 16:58:17','tracking',4,'alexcruz adicionou um acompanhamento'),
(491,53,'ticket','2025-01-22 16:58:28','tracking',4,'alexcruz atualizou um item'),
(492,51,'ticket','2025-01-22 16:59:24','tracking',4,'alexcruz adicionou um acompanhamento'),
(493,51,'ticket','2025-01-22 16:59:29','tracking',4,'alexcruz atualizou um item'),
(494,0,'system','2025-01-23 11:48:50','login',3,'alexcruz fez login no IP 177.89.21.161'),
(495,0,'system','2025-01-23 12:51:41','login',3,'tecnomulti fez login no IP 179.83.138.239'),
(496,55,'ticket','2025-01-23 13:02:02','tracking',4,'tecnomulti adicionou o item 55'),
(497,55,'ticket','2025-01-23 13:06:27','tracking',4,'alexcruz adicionou um acompanhamento'),
(498,55,'ticket','2025-01-23 13:06:31','tracking',4,'alexcruz atualizou um item'),
(499,55,'ticket','2025-01-23 13:12:21','tracking',4,'tecnomulti adicionou um acompanhamento'),
(500,55,'ticket','2025-01-23 13:12:25','tracking',4,'tecnomulti adicionou um acompanhamento'),
(501,55,'ticket','2025-01-23 13:16:12','tracking',4,'tecnomulti adicionou um acompanhamento'),
(502,55,'ticket','2025-01-23 13:20:37','tracking',4,'tecnomulti adicionou um acompanhamento'),
(503,55,'ticket','2025-01-23 13:39:21','tracking',4,'alexcruz adicionou um acompanhamento'),
(504,55,'ticket','2025-01-23 13:39:28','tracking',4,'alexcruz atualizou um item'),
(505,0,'system','2025-01-23 15:03:10','login',3,'Login falhou para  no IP 168.196.199.10'),
(506,0,'system','2025-01-23 18:27:29','login',3,'luanmedeiros fez login no IP 177.89.21.161'),
(507,48,'ticket','2025-01-24 11:59:34','tracking',4,'alexcruz adicionou um acompanhamento'),
(508,48,'ticket','2025-01-24 11:59:40','tracking',4,'alexcruz atualizou um item'),
(509,53,'ticket','2025-01-24 12:00:17','tracking',4,'alexcruz adicionou um acompanhamento'),
(510,53,'ticket','2025-01-24 12:00:22','tracking',4,'alexcruz atualizou um item'),
(511,0,'system','2025-01-27 11:10:49','login',3,'alexcruz fez login no IP 187.61.153.218'),
(512,0,'system','2025-01-27 12:28:20','login',3,'alexcruz fez login no IP 187.61.153.218'),
(513,0,'system','2025-01-27 12:53:34','login',3,'alexcruz fez login no IP 187.61.153.218'),
(514,0,'system','2025-01-27 15:01:48','login',3,'alexcruz fez login no IP 187.61.153.218'),
(515,0,'system','2025-01-27 17:23:54','login',3,'Login falhou para  no IP 187.61.250.172'),
(516,0,'system','2025-01-27 17:24:11','login',3,'alexcruz fez login no IP 187.61.250.172'),
(517,0,'system','2025-01-27 18:28:25','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(518,0,'system','2025-01-27 18:28:28','login',3,'alexcruz fez login no IP 187.61.250.172'),
(519,0,'system','2025-01-27 18:32:09','login',3,'tecnomulti fez login no IP 179.251.185.93'),
(520,0,'system','2025-01-27 18:35:25','login',3,'Login falhou para  no IP 179.251.185.93'),
(521,0,'system','2025-01-27 18:35:33','login',3,'tecnomulti fez login no IP 179.251.185.93'),
(522,56,'ticket','2025-01-27 18:40:14','tracking',4,'tecnomulti adicionou o item 56'),
(523,0,'system','2025-01-27 21:30:13','login',3,'paulovictorfds fez login no IP 187.19.242.185'),
(524,0,'system','2025-01-28 11:04:34','login',3,'Login falhou para  no IP 179.251.185.93'),
(525,0,'system','2025-01-28 11:04:45','login',3,'tecnomulti fez login no IP 179.251.185.93'),
(526,57,'ticket','2025-01-28 11:11:21','tracking',4,'tecnomulti adicionou o item 57'),
(527,0,'system','2025-01-28 11:16:18','login',3,'Login falhou para  no IP 177.89.21.161'),
(528,0,'system','2025-01-28 11:16:49','login',3,'alexcruz fez login no IP 177.89.21.161'),
(529,56,'ticket','2025-01-28 11:17:26','tracking',4,'alexcruz adicionou um acompanhamento'),
(530,56,'ticket','2025-01-28 11:17:31','tracking',4,'alexcruz atualizou um item'),
(531,56,'ticket','2025-01-28 11:19:49','tracking',4,'alexcruz adicionou um acompanhamento'),
(532,57,'ticket','2025-01-28 11:41:16','tracking',4,'alexcruz adicionou um acompanhamento'),
(533,57,'ticket','2025-01-28 11:41:20','tracking',4,'alexcruz atualizou um item'),
(534,0,'system','2025-01-28 11:49:45','login',3,'Login falhou para luanmedeiros no IP 177.89.21.161'),
(535,0,'system','2025-01-28 11:49:58','login',3,'luanmedeiros fez login no IP 177.89.21.161'),
(536,0,'system','2025-01-28 12:31:01','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(537,58,'ticket','2025-01-28 12:39:13','tracking',4,'tecnomulti adicionou o item 58'),
(538,56,'ticket','2025-01-28 12:51:31','tracking',4,'alexcruz adicionou um acompanhamento'),
(539,56,'ticket','2025-01-28 12:51:41','tracking',4,'alexcruz atualizou um item'),
(540,0,'system','2025-01-28 13:45:10','login',3,'Falhou login para  do IP 179.105.130.139'),
(541,0,'system','2025-01-28 13:45:17','login',3,'tecnomulti ligou-se do IP 179.105.130.139'),
(542,59,'ticket','2025-01-28 13:46:40','tracking',4,'tecnomulti adicionou o item 59'),
(543,0,'system','2025-01-28 13:50:57','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(544,60,'ticket','2025-01-28 13:53:54','tracking',4,'tecnomulti adicionou o item 60'),
(545,60,'ticket','2025-01-28 13:58:47','tracking',4,'alexcruz adicionou um acompanhamento'),
(546,60,'ticket','2025-01-28 13:58:52','tracking',4,'alexcruz atualizou um item'),
(547,61,'ticket','2025-01-28 13:59:04','tracking',4,'tecnomulti adicionou o item 61'),
(548,59,'ticket','2025-01-28 13:59:29','tracking',4,'alexcruz adicionou um acompanhamento'),
(549,59,'ticket','2025-01-28 13:59:33','tracking',4,'alexcruz atualizou um item'),
(550,0,'system','2025-01-28 14:00:47','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(551,61,'ticket','2025-01-28 14:01:08','tracking',4,'alexcruz atualizou um item'),
(552,61,'ticket','2025-01-28 14:02:01','tracking',4,'alexcruz adicionou um acompanhamento'),
(553,61,'ticket','2025-01-28 14:02:05','tracking',4,'alexcruz atualizou um item'),
(554,62,'ticket','2025-01-28 14:02:27','tracking',4,'tecnomulti adicionou o item 62'),
(555,63,'ticket','2025-01-28 14:04:55','tracking',4,'tecnomulti adicionou o item 63'),
(556,62,'ticket','2025-01-28 14:05:13','tracking',4,'alexcruz adicionou um acompanhamento'),
(557,62,'ticket','2025-01-28 14:05:20','tracking',4,'alexcruz atualizou um item'),
(558,64,'ticket','2025-01-28 14:06:03','tracking',4,'tecnomulti adicionou o item 64'),
(559,63,'ticket','2025-01-28 14:06:10','tracking',4,'alexcruz adicionou um acompanhamento'),
(560,59,'ticket','2025-01-28 14:06:51','tracking',4,'tecnomulti adicionou um acompanhamento'),
(561,63,'ticket','2025-01-28 14:11:39','tracking',4,'alexcruz atualizou um item'),
(562,64,'ticket','2025-01-28 14:13:32','tracking',4,'alexcruz adicionou um acompanhamento'),
(563,64,'ticket','2025-01-28 14:13:35','tracking',4,'alexcruz atualizou um item'),
(564,65,'ticket','2025-01-28 14:16:01','tracking',4,'tecnomulti adicionou o item 65'),
(565,0,'system','2025-01-28 14:28:38','login',3,'tecnomulti fez login no IP 179.251.185.93'),
(566,66,'ticket','2025-01-28 14:31:35','tracking',4,'tecnomulti adicionou o item 66'),
(567,31,'ticket','2025-01-28 14:40:22','tracking',4,'luanmedeiros adicionou um acompanhamento'),
(568,31,'ticket','2025-01-28 14:40:30','tracking',4,'luanmedeiros atualizou um item'),
(569,58,'ticket','2025-01-28 14:42:25','tracking',4,'luanmedeiros adicionou um acompanhamento'),
(570,58,'ticket','2025-01-28 14:44:09','tracking',4,'luanmedeiros atualizou um item'),
(571,59,'ticket','2025-01-28 14:46:04','tracking',4,'tecnomulti adicionou um acompanhamento'),
(572,65,'ticket','2025-01-28 14:49:25','tracking',4,'luanmedeiros adicionou um acompanhamento'),
(573,65,'ticket','2025-01-28 14:49:48','tracking',4,'luanmedeiros atualizou um item'),
(574,66,'ticket','2025-01-28 14:52:26','tracking',4,'luanmedeiros adicionou um acompanhamento'),
(575,66,'ticket','2025-01-28 14:52:57','tracking',4,'luanmedeiros atualizou um item'),
(576,59,'ticket','2025-01-28 14:53:00','tracking',4,'tecnomulti adicionou um acompanhamento'),
(577,0,'system','2025-01-28 15:11:20','login',3,'tecnomulti fez login no IP 191.35.89.13'),
(578,67,'ticket','2025-01-28 15:12:53','tracking',4,'tecnomulti adicionou o item 67'),
(579,67,'ticket','2025-01-28 15:22:05','tracking',4,'luanmedeiros adicionou um acompanhamento'),
(580,67,'ticket','2025-01-28 15:22:10','tracking',4,'luanmedeiros atualizou um item'),
(581,66,'ticket','2025-01-28 16:46:27','tracking',4,'tecnomulti adicionou um acompanhamento'),
(582,59,'ticket','2025-01-28 17:02:03','tracking',4,'tecnomulti adicionou um acompanhamento'),
(583,59,'ticket','2025-01-28 18:15:44','tracking',4,'luanmedeiros adicionou um acompanhamento'),
(584,59,'ticket','2025-01-28 18:17:02','tracking',4,'tecnomulti adicionou um acompanhamento'),
(585,59,'ticket','2025-01-28 18:18:38','tracking',4,'tecnomulti adicionou um acompanhamento'),
(586,68,'ticket','2025-01-28 18:47:27','tracking',4,'tecnomulti adicionou o item 68'),
(587,59,'ticket','2025-01-28 18:53:51','tracking',4,'luanmedeiros adicionou um acompanhamento'),
(588,59,'ticket','2025-01-28 18:56:08','tracking',4,'luanmedeiros adicionou um acompanhamento'),
(589,59,'ticket','2025-01-28 19:27:19','tracking',4,'luanmedeiros atualizou um item'),
(590,68,'ticket','2025-01-28 20:17:22','tracking',4,'alexcruz adicionou um acompanhamento'),
(591,68,'ticket','2025-01-28 20:17:28','tracking',4,'alexcruz atualizou um item'),
(592,67,'ticket','2025-01-28 20:18:35','tracking',4,'alexcruz adicionou um acompanhamento'),
(593,67,'ticket','2025-01-28 20:18:45','tracking',4,'alexcruz atualizou um item'),
(594,66,'ticket','2025-01-28 20:20:25','tracking',4,'alexcruz adicionou um acompanhamento'),
(595,66,'ticket','2025-01-28 20:20:30','tracking',4,'alexcruz atualizou um item'),
(596,3,'notifications','2025-01-29 02:50:37','notification',4,'paulovictorfds atualizou um item'),
(597,0,'system','2025-01-29 02:55:48','login',3,'tecnomulti fez login no IP 187.19.242.185'),
(598,0,'system','2025-01-29 02:55:50','login',3,'tecnomulti fez login no IP 187.61.153.218'),
(599,69,'ticket','2025-01-29 02:56:40','tracking',4,'tecnomulti adicionou o item 69'),
(600,0,'system','2025-01-29 02:56:46','login',3,'Login falhou para alexcruz no IP 187.61.153.218'),
(601,0,'system','2025-01-29 02:57:18','login',3,'alexcruz fez login no IP 187.61.153.218'),
(602,69,'ticket','2025-01-29 02:57:42','tracking',4,'alexcruz adicionou um acompanhamento'),
(603,69,'ticket','2025-01-29 02:58:00','tracking',4,'alexcruz atualizou um item'),
(604,69,'ticket','2025-01-29 02:58:26','tracking',4,'alexcruz adicionou um acompanhamento'),
(605,69,'ticket','2025-01-29 02:59:25','tracking',4,'alexcruz adicionou um acompanhamento'),
(606,69,'ticket','2025-01-29 03:01:00','tracking',4,'alexcruz atualizou um item'),
(607,0,'system','2025-01-29 03:01:51','login',3,'tecnomulti fez login no IP 187.19.242.185'),
(608,69,'ticket','2025-01-29 03:02:21','tracking',4,'alexcruz atualizou um item'),
(609,69,'ticket','2025-01-29 03:02:35','tracking',4,'alexcruz adicionou um acompanhamento'),
(610,69,'ticket','2025-01-29 03:04:17','tracking',4,'alexcruz apagou o acompanhamento'),
(611,69,'ticket','2025-01-29 03:04:26','tracking',4,'alexcruz apagou o acompanhamento'),
(612,69,'ticket','2025-01-29 03:04:34','tracking',4,'alexcruz apagou o acompanhamento'),
(613,69,'ticket','2025-01-29 03:05:33','tracking',4,'alexcruz adicionou um acompanhamento'),
(614,69,'ticket','2025-01-29 03:06:16','tracking',4,'alexcruz adicionou um acompanhamento'),
(615,69,'ticket','2025-01-29 03:06:49','tracking',4,'alexcruz apagou o acompanhamento'),
(616,69,'ticket','2025-01-29 03:06:58','tracking',4,'alexcruz apagou o acompanhamento'),
(617,69,'ticket','2025-01-29 03:07:04','tracking',4,'alexcruz adicionou um acompanhamento'),
(618,69,'ticket','2025-01-29 03:07:24','tracking',4,'alexcruz adicionou um acompanhamento'),
(619,69,'ticket','2025-01-29 03:07:34','tracking',4,'alexcruz apagou o acompanhamento'),
(620,69,'ticket','2025-01-29 03:08:25','tracking',4,'alexcruz apagou o acompanhamento'),
(621,69,'ticket','2025-01-29 03:08:33','tracking',4,'alexcruz adicionou um acompanhamento'),
(622,69,'ticket','2025-01-29 03:09:19','tracking',4,'alexcruz adicionou um acompanhamento'),
(623,69,'ticket','2025-01-29 03:09:29','tracking',4,'alexcruz adicionou um acompanhamento'),
(624,69,'ticket','2025-01-29 03:09:58','tracking',4,'alexcruz adicionou um acompanhamento'),
(625,69,'ticket','2025-01-29 03:10:11','tracking',4,'alexcruz adicionou um acompanhamento'),
(626,0,'system','2025-01-29 03:10:33','login',3,'tecnomulti fez login no IP 187.61.153.218'),
(627,69,'ticket','2025-01-29 03:10:45','tracking',4,'alexcruz adicionou um acompanhamento'),
(628,69,'ticket','2025-01-29 03:11:00','tracking',4,'alexcruz adicionou um acompanhamento'),
(629,69,'ticket','2025-01-29 03:11:54','tracking',4,'alexcruz apagou o acompanhamento'),
(630,69,'ticket','2025-01-29 03:12:02','tracking',4,'alexcruz apagou o acompanhamento'),
(631,69,'ticket','2025-01-29 03:12:11','tracking',4,'alexcruz apagou o acompanhamento'),
(632,69,'ticket','2025-01-29 03:12:16','tracking',4,'alexcruz apagou o acompanhamento'),
(633,69,'ticket','2025-01-29 03:12:21','tracking',4,'alexcruz apagou o acompanhamento'),
(634,69,'ticket','2025-01-29 03:12:27','tracking',4,'alexcruz apagou o acompanhamento'),
(635,69,'ticket','2025-01-29 03:12:43','tracking',4,'alexcruz apagou o acompanhamento'),
(636,69,'ticket','2025-01-29 03:12:48','tracking',4,'alexcruz adicionou um acompanhamento'),
(637,1,'profiles','2025-01-29 03:17:03','setup',4,'paulovictorfds atualizou um item'),
(638,0,'system','2025-01-29 03:17:28','login',3,'tecnomulti fez login no IP 187.19.242.185'),
(639,0,'system','2025-01-29 11:06:32','login',3,'luanmedeiros fez login no IP 177.89.21.161'),
(640,0,'system','2025-01-29 11:28:17','login',3,'Login falhou para  no IP 177.89.21.161'),
(641,0,'system','2025-01-29 11:28:21','login',3,'alexcruz fez login no IP 177.89.21.161'),
(642,0,'system','2025-01-29 11:50:18','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(643,70,'ticket','2025-01-29 11:52:14','tracking',4,'tecnomulti adicionou o item 70'),
(644,70,'ticket','2025-01-29 11:53:33','tracking',4,'alexcruz adicionou um acompanhamento'),
(645,70,'ticket','2025-01-29 11:53:46','tracking',4,'alexcruz atualizou um item'),
(646,70,'ticket','2025-01-29 11:55:13','tracking',4,'tecnomulti adicionou um acompanhamento'),
(647,0,'system','2025-01-29 11:57:20','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(648,71,'ticket','2025-01-29 11:59:27','tracking',4,'tecnomulti adicionou o item 71'),
(649,70,'ticket','2025-01-29 12:01:09','tracking',4,'alexcruz adicionou um acompanhamento'),
(650,70,'ticket','2025-01-29 12:01:16','tracking',4,'alexcruz atualizou um item'),
(651,71,'ticket','2025-01-29 12:06:20','tracking',4,'alexcruz adicionou um acompanhamento'),
(652,71,'ticket','2025-01-29 12:06:26','tracking',4,'alexcruz atualizou um item'),
(653,0,'system','2025-01-29 18:07:38','login',3,'Login falhou para  no IP 168.196.199.10'),
(654,0,'system','2025-01-30 00:52:11','login',3,'tecnomulti fez login no IP 201.216.90.48'),
(655,0,'system','2025-01-30 11:10:56','login',3,'alexcruz fez login no IP 177.89.21.161'),
(656,0,'system','2025-01-30 11:21:04','login',3,'tecnomulti fez login no IP 45.224.114.161'),
(657,72,'ticket','2025-01-30 11:24:45','tracking',4,'tecnomulti adicionou o item 72'),
(658,72,'ticket','2025-01-30 11:45:58','tracking',4,'alexcruz adicionou um acompanhamento'),
(659,72,'ticket','2025-01-30 11:46:08','tracking',4,'alexcruz atualizou um item'),
(660,72,'ticket','2025-01-30 11:51:01','tracking',4,'alexcruz adicionou um acompanhamento'),
(661,72,'ticket','2025-01-30 11:51:10','tracking',4,'alexcruz atualizou um item'),
(662,0,'system','2025-01-30 13:41:48','login',3,'tecnomulti fez login no IP 191.35.89.13'),
(663,73,'ticket','2025-01-30 13:44:22','tracking',4,'tecnomulti adicionou o item 73'),
(664,73,'ticket','2025-01-30 15:36:30','tracking',4,'alexcruz adicionou um acompanhamento'),
(665,73,'ticket','2025-01-30 15:37:07','tracking',4,'alexcruz atualizou um item'),
(666,58,'ticket','2025-01-30 15:41:34','tracking',4,'alexcruz atualizou um item'),
(667,0,'system','2025-01-30 16:45:44','login',3,'Login falhou para  no IP 168.196.199.10'),
(668,0,'system','2025-01-30 16:46:33','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(669,58,'ticket','2025-01-30 16:49:36','tracking',4,'tecnomulti adicionou um acompanhamento'),
(670,0,'system','2025-01-30 17:52:26','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(671,74,'ticket','2025-01-30 17:53:59','tracking',4,'tecnomulti adicionou o item 74'),
(672,0,'system','2025-01-30 17:55:54','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(673,74,'ticket','2025-01-30 18:05:36','tracking',4,'tecnomulti adicionou um acompanhamento'),
(674,0,'system','2025-01-30 18:37:54','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(675,75,'ticket','2025-01-30 18:41:10','tracking',4,'tecnomulti adicionou o item 75'),
(676,0,'system','2025-01-30 18:48:30','login',3,'Login falhou para  no IP 187.61.153.218'),
(677,0,'system','2025-01-30 18:48:51','login',3,'Login falhou para alexcruz no IP 187.61.153.218'),
(678,0,'system','2025-01-30 18:49:02','login',3,'Login falhou para alexcruz no IP 187.61.153.218'),
(679,0,'system','2025-01-30 18:49:39','login',3,'alexcruz fez login no IP 187.61.153.218'),
(680,74,'ticket','2025-01-30 18:50:29','tracking',4,'alexcruz adicionou um acompanhamento'),
(681,74,'ticket','2025-01-30 18:50:35','tracking',4,'alexcruz atualizou um item'),
(682,73,'ticket','2025-01-30 18:52:09','tracking',4,'alexcruz adicionou um acompanhamento'),
(683,73,'ticket','2025-01-30 18:52:14','tracking',4,'alexcruz atualizou um item'),
(684,74,'ticket','2025-01-30 18:58:24','tracking',4,'alexcruz adicionou um acompanhamento'),
(685,75,'ticket','2025-01-30 19:14:05','tracking',4,'alexcruz adicionou um acompanhamento'),
(686,75,'ticket','2025-01-30 19:14:11','tracking',4,'alexcruz atualizou um item'),
(687,74,'ticket','2025-01-30 19:23:54','tracking',4,'alexcruz adicionou um acompanhamento'),
(688,74,'ticket','2025-01-30 19:23:58','tracking',4,'alexcruz atualizou um item'),
(689,0,'system','2025-01-30 19:24:51','login',3,'Login falhou para  no IP 168.196.199.10'),
(690,0,'system','2025-01-30 20:25:56','login',3,'Login falhou para  no IP 168.196.199.10'),
(691,0,'system','2025-01-30 20:33:06','login',3,'paulovictorfds fez login no IP 187.19.242.185'),
(692,0,'system','2025-01-31 00:20:52','login',3,'Login falhou para  no IP 187.61.153.218'),
(693,0,'system','2025-01-31 11:34:55','login',3,'Login falhou para  no IP 186.212.118.99'),
(694,0,'system','2025-01-31 11:35:27','login',3,'tecnomulti fez login no IP 186.212.118.99'),
(695,0,'system','2025-01-31 12:51:09','login',3,'alexcruz fez login no IP 187.61.153.218'),
(696,0,'system','2025-01-31 13:32:37','login',3,'Login falhou para  no IP 187.61.153.218'),
(697,0,'system','2025-01-31 13:32:43','login',3,'alexcruz fez login no IP 187.61.153.218'),
(698,0,'system','2025-02-01 13:26:50','login',3,'Login falhou para  no IP 187.61.153.218'),
(699,0,'system','2025-02-01 13:26:55','login',3,'alexcruz fez login no IP 187.61.153.218'),
(700,0,'system','2025-02-01 14:00:34','login',3,'alexcruz fez login no IP 187.61.153.218'),
(701,0,'system','2025-02-03 01:42:46','login',3,'Login falhou para  no IP 179.156.60.185'),
(702,0,'system','2025-02-03 11:18:15','login',3,'Login falhou para luanmedeiros no IP 177.89.21.161'),
(703,0,'system','2025-02-03 11:18:26','login',3,'luanmedeiros fez login no IP 177.89.21.161'),
(704,0,'system','2025-02-03 13:16:06','login',3,'tecnomulti fez login no IP 45.4.242.230'),
(705,76,'ticket','2025-02-03 13:18:39','tracking',4,'tecnomulti adicionou o item 76'),
(706,0,'system','2025-02-03 13:25:31','login',3,'luanmedeiros fez login no IP 177.89.21.161'),
(707,0,'system','2025-02-03 13:26:50','login',3,'Login falhou para  no IP 186.212.118.99'),
(708,0,'system','2025-02-03 13:29:25','login',3,'tecnomulti fez login no IP 186.212.118.99'),
(709,76,'ticket','2025-02-03 13:49:47','tracking',4,'alexcruz adicionou um acompanhamento'),
(710,76,'ticket','2025-02-03 13:49:52','tracking',4,'alexcruz atualizou um item'),
(711,76,'ticket','2025-02-03 13:51:42','tracking',4,'tecnomulti adicionou um acompanhamento'),
(712,0,'system','2025-02-03 16:52:30','login',3,'Login falhou para  no IP 168.196.199.10'),
(713,0,'system','2025-02-03 17:19:18','login',3,'tecnomulti fez login no IP 152.241.69.246'),
(714,77,'ticket','2025-02-03 17:21:14','tracking',4,'tecnomulti adicionou o item 77'),
(715,0,'system','2025-02-03 17:41:17','login',3,'tecnomulti fez login no IP 191.58.92.15'),
(716,78,'ticket','2025-02-03 17:44:33','tracking',4,'tecnomulti adicionou o item 78'),
(717,78,'ticket','2025-02-03 19:50:51','tracking',4,'alexcruz adicionou um acompanhamento'),
(718,78,'ticket','2025-02-03 19:50:55','tracking',4,'alexcruz atualizou um item'),
(719,0,'system','2025-02-03 20:20:59','login',3,'tecnomulti fez login no IP 191.58.92.15'),
(720,79,'ticket','2025-02-03 20:21:54','tracking',4,'tecnomulti adicionou o item 79'),
(721,78,'ticket','2025-02-03 20:47:27','tracking',4,'alexcruz adicionou um acompanhamento'),
(722,78,'ticket','2025-02-03 20:47:33','tracking',4,'alexcruz atualizou um item'),
(723,79,'ticket','2025-02-03 21:01:14','tracking',4,'alexcruz adicionou um acompanhamento'),
(724,79,'ticket','2025-02-03 21:01:20','tracking',4,'alexcruz atualizou um item'),
(725,0,'system','2025-02-04 11:21:38','login',3,'Login falhou para  no IP 177.89.21.161'),
(726,0,'system','2025-02-04 11:21:43','login',3,'alexcruz fez login no IP 177.89.21.161'),
(727,77,'ticket','2025-02-04 11:22:32','tracking',4,'alexcruz adicionou um acompanhamento'),
(728,77,'ticket','2025-02-04 11:22:37','tracking',4,'alexcruz atualizou um item'),
(729,76,'ticket','2025-02-04 11:49:55','tracking',4,'alexcruz atualizou um item'),
(730,0,'system','2025-02-04 12:19:06','login',3,'Login falhou para  no IP 168.196.199.10'),
(731,0,'system','2025-02-04 16:37:40','login',3,'paulovictorfds fez login no IP 187.19.242.17'),
(732,0,'system','2025-02-04 18:36:33','login',3,'tecnomulti fez login no IP 201.216.90.48'),
(733,80,'ticket','2025-02-04 18:37:10','tracking',4,'tecnomulti adicionou o item 80'),
(734,0,'system','2025-02-04 18:40:33','login',3,'Login falhou para  no IP 187.61.153.218'),
(735,0,'system','2025-02-04 18:40:35','login',3,'alexcruz fez login no IP 187.61.153.218'),
(736,0,'system','2025-02-04 18:40:44','login',3,'Login falhou para  no IP 168.196.199.10'),
(737,80,'ticket','2025-02-04 18:41:05','tracking',4,'alexcruz adicionou um acompanhamento'),
(738,0,'system','2025-02-04 18:41:07','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(739,80,'ticket','2025-02-04 18:41:11','tracking',4,'alexcruz atualizou um item'),
(740,81,'ticket','2025-02-04 18:43:15','tracking',4,'tecnomulti adicionou o item 81'),
(741,80,'ticket','2025-02-04 19:15:51','tracking',4,'alexcruz adicionou um acompanhamento'),
(742,80,'ticket','2025-02-04 19:15:58','tracking',4,'alexcruz atualizou um item'),
(743,81,'ticket','2025-02-04 19:16:38','tracking',4,'alexcruz adicionou um acompanhamento'),
(744,81,'ticket','2025-02-04 19:16:42','tracking',4,'alexcruz atualizou um item'),
(745,0,'system','2025-02-05 12:37:06','login',3,'alexcruz fez login no IP 187.61.153.218'),
(746,0,'system','2025-02-05 12:48:10','login',3,'alexcruz fez login no IP 187.61.153.218'),
(747,0,'system','2025-02-06 14:37:21','login',3,'alexcruz fez login no IP 187.61.153.218'),
(748,81,'ticket','2025-02-06 14:39:43','tracking',4,'alexcruz adicionou um acompanhamento'),
(749,81,'ticket','2025-02-06 14:39:48','tracking',4,'alexcruz atualizou um item'),
(750,80,'ticket','2025-02-06 14:41:21','tracking',4,'alexcruz atualizou um item'),
(751,0,'system','2025-02-07 13:29:19','login',3,'luanmedeiros fez login no IP 177.89.21.161'),
(752,0,'system','2025-02-07 14:13:29','login',3,'tecnomulti fez login no IP 177.37.172.165'),
(753,82,'ticket','2025-02-07 14:16:50','tracking',4,'tecnomulti adicionou o item 82'),
(754,0,'system','2025-02-08 01:41:57','login',3,'paulovictorfds fez login no IP 187.19.242.209'),
(755,2,'APIClient','2025-02-09 04:00:28','setup',4,'paulovictorfds adicionou o item PV'),
(756,2,'APIClient','2025-02-09 04:08:01','setup',4,'paulovictorfds atualizou um item'),
(757,0,'system','2025-02-10 11:02:13','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(758,83,'ticket','2025-02-10 11:16:41','tracking',4,'tecnomulti adicionou o item 83'),
(759,0,'system','2025-02-10 11:18:39','login',3,'Login falhou para  no IP 177.89.21.161'),
(760,0,'system','2025-02-10 11:18:43','login',3,'alexcruz fez login no IP 177.89.21.161'),
(761,83,'ticket','2025-02-10 11:19:29','tracking',4,'alexcruz adicionou um acompanhamento'),
(762,83,'ticket','2025-02-10 11:19:35','tracking',4,'alexcruz atualizou um item'),
(763,83,'ticket','2025-02-10 11:41:39','tracking',4,'tecnomulti adicionou um acompanhamento'),
(764,83,'ticket','2025-02-10 11:46:47','tracking',4,'alexcruz adicionou um acompanhamento'),
(765,83,'ticket','2025-02-10 11:46:54','tracking',4,'alexcruz atualizou um item'),
(766,82,'ticket','2025-02-10 11:47:57','tracking',4,'alexcruz adicionou um acompanhamento'),
(767,82,'ticket','2025-02-10 11:48:02','tracking',4,'alexcruz atualizou um item'),
(768,0,'system','2025-02-10 13:31:13','login',3,'alexcruz fez login no IP 177.69.106.178'),
(769,0,'system','2025-02-10 15:22:21','login',3,'paulovictorfds fez login no IP 187.19.242.209'),
(770,0,'system','2025-02-10 19:12:20','login',3,'alexcruz fez login no IP 177.69.106.178'),
(771,0,'system','2025-02-10 19:12:20','login',3,'alexcruz fez login no IP 177.69.106.178'),
(772,0,'system','2025-02-11 12:00:36','login',3,'tecnomulti fez login no IP 45.224.114.166'),
(773,84,'ticket','2025-02-11 12:02:54','tracking',4,'tecnomulti adicionou o item 84'),
(774,82,'ticket','2025-02-11 12:21:28','tracking',4,'alexcruz adicionou um acompanhamento'),
(775,82,'ticket','2025-02-11 12:21:34','tracking',4,'alexcruz atualizou um item'),
(776,0,'system','2025-02-11 12:38:07','login',3,'Login falhou para  no IP 168.196.199.10'),
(777,0,'system','2025-02-11 12:39:05','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(778,85,'ticket','2025-02-11 12:41:34','tracking',4,'tecnomulti adicionou o item 85'),
(779,0,'system','2025-02-11 13:03:55','login',3,'tecnomulti fez login no IP 177.89.21.161'),
(780,85,'ticket','2025-02-11 13:07:04','tracking',4,'alexcruz adicionou um acompanhamento'),
(781,85,'ticket','2025-02-11 13:07:08','tracking',4,'alexcruz atualizou um item'),
(782,84,'ticket','2025-02-11 13:08:39','tracking',4,'alexcruz adicionou um acompanhamento'),
(783,84,'ticket','2025-02-11 13:08:44','tracking',4,'alexcruz atualizou um item'),
(784,85,'ticket','2025-02-11 13:14:01','tracking',4,'alexcruz adicionou um acompanhamento'),
(785,85,'ticket','2025-02-11 13:14:07','tracking',4,'alexcruz atualizou um item'),
(786,0,'system','2025-02-11 15:07:31','login',3,'Login falhou para tecnomulti no IP 168.196.199.10'),
(787,0,'system','2025-02-11 15:08:18','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(788,86,'ticket','2025-02-11 15:10:17','tracking',4,'tecnomulti adicionou o item 86'),
(789,0,'system','2025-02-11 22:06:23','login',3,'Login falhou para  no IP 187.61.153.218'),
(790,0,'system','2025-02-11 22:06:25','login',3,'alexcruz fez login no IP 187.61.153.218'),
(791,0,'system','2025-02-11 22:15:24','login',3,'tecnomulti fez login no IP 187.61.153.218'),
(792,0,'system','2025-02-11 22:17:40','login',3,'alexcruz fez login no IP 187.61.153.218'),
(793,86,'ticket','2025-02-11 22:20:27','tracking',4,'alexcruz adicionou um acompanhamento'),
(794,86,'ticket','2025-02-11 22:20:38','tracking',4,'alexcruz atualizou um item'),
(795,0,'system','2025-02-12 11:53:55','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(796,87,'ticket','2025-02-12 11:56:10','tracking',4,'tecnomulti adicionou o item 87'),
(797,87,'ticket','2025-02-12 12:07:07','tracking',4,'alexcruz adicionou um acompanhamento'),
(798,87,'ticket','2025-02-12 12:07:12','tracking',4,'alexcruz atualizou um item'),
(799,87,'ticket','2025-02-12 12:34:04','tracking',4,'alexcruz adicionou um acompanhamento'),
(800,87,'ticket','2025-02-12 12:34:09','tracking',4,'alexcruz atualizou um item'),
(801,0,'system','2025-02-13 11:18:40','login',3,'Login falhou para  no IP 177.89.21.161'),
(802,0,'system','2025-02-13 11:18:45','login',3,'alexcruz fez login no IP 177.89.21.161'),
(803,86,'ticket','2025-02-13 13:17:04','tracking',4,'alexcruz adicionou um acompanhamento'),
(804,86,'ticket','2025-02-13 13:17:14','tracking',4,'alexcruz atualizou um item'),
(805,58,'ticket','2025-02-13 14:01:04','tracking',4,'alexcruz adicionou um acompanhamento'),
(806,58,'ticket','2025-02-13 14:01:10','tracking',4,'alexcruz atualizou um item'),
(807,0,'system','2025-02-14 11:04:24','login',3,'alexcruz fez login no IP 177.89.21.161'),
(808,0,'system','2025-02-14 11:04:24','login',3,'alexcruz fez login no IP 177.89.21.161'),
(809,0,'system','2025-02-14 16:59:13','login',3,'Login falhou para  no IP 187.61.153.218'),
(810,0,'system','2025-02-14 16:59:15','login',3,'alexcruz fez login no IP 187.61.153.218'),
(811,0,'system','2025-02-17 11:33:50','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(812,88,'ticket','2025-02-17 11:36:06','tracking',4,'tecnomulti adicionou o item 88'),
(813,0,'system','2025-02-17 12:34:02','login',3,'tecnomulti fez login no IP 45.4.241.16'),
(814,89,'ticket','2025-02-17 12:35:59','tracking',4,'tecnomulti adicionou o item 89'),
(815,0,'system','2025-02-17 13:23:52','login',3,'Login falhou para luanmedeiros no IP 177.89.21.161'),
(816,0,'system','2025-02-17 13:24:07','login',3,'Login falhou para luanmedeiros no IP 177.89.21.161'),
(817,0,'system','2025-02-17 13:24:27','login',3,'Login falhou para luanmedeiros no IP 177.89.21.161'),
(818,0,'system','2025-02-17 13:24:42','login',3,'luanmedeiros fez login no IP 177.89.21.161'),
(819,88,'ticket','2025-02-17 13:52:33','tracking',4,'luanmedeiros adicionou um acompanhamento'),
(820,0,'system','2025-02-17 20:02:58','login',3,'alexcruz fez login no IP 179.190.228.254'),
(821,88,'ticket','2025-02-17 20:04:30','tracking',4,'alexcruz atualizou um encaminhamento'),
(822,88,'ticket','2025-02-17 20:31:30','tracking',4,'alexcruz atualizou um item'),
(823,0,'system','2025-02-18 02:16:04','login',3,'paulovictorfds fez login no IP 187.19.242.209'),
(824,0,'system','2025-02-18 10:23:30','login',3,'Login falhou para  no IP 168.196.199.10'),
(825,0,'system','2025-02-18 10:23:51','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(826,0,'system','2025-02-18 17:48:38','login',3,'tecnomulti fez login no IP 177.121.114.209'),
(827,0,'system','2025-02-18 17:52:52','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(828,90,'ticket','2025-02-18 17:56:01','tracking',4,'tecnomulti adicionou o item 90'),
(829,91,'ticket','2025-02-18 17:56:26','tracking',4,'tecnomulti adicionou o item 91'),
(830,0,'system','2025-02-18 18:10:39','login',3,'alexcruz fez login no IP 187.61.169.75'),
(831,91,'ticket','2025-02-18 18:14:21','tracking',4,'alexcruz adicionou um acompanhamento'),
(832,91,'ticket','2025-02-18 18:14:35','tracking',4,'alexcruz atualizou um item'),
(833,90,'ticket','2025-02-18 18:16:04','tracking',4,'alexcruz adicionou um acompanhamento'),
(834,90,'ticket','2025-02-18 18:16:39','tracking',4,'alexcruz atualizou um item'),
(835,90,'ticket','2025-02-18 18:17:50','tracking',4,'tecnomulti adicionou um acompanhamento'),
(836,91,'ticket','2025-02-18 18:22:40','tracking',4,'tecnomulti adicionou um acompanhamento'),
(837,89,'ticket','2025-02-18 18:30:33','tracking',4,'alexcruz adicionou um acompanhamento'),
(838,89,'ticket','2025-02-18 18:30:40','tracking',4,'alexcruz atualizou um item'),
(839,0,'system','2025-02-18 18:31:29','login',3,'tecnomulti fez login no IP 168.196.199.10'),
(840,92,'ticket','2025-02-18 18:48:25','tracking',4,'tecnomulti adicionou o item 92'),
(841,0,'system','2025-02-18 18:50:25','login',3,'Login falhou para  no IP 177.121.114.209'),
(842,0,'system','2025-02-18 18:53:16','login',3,'tecnomulti fez login no IP 177.121.114.209');

--
-- Table structure for table `glpi_fieldblacklists`
--

CREATE TABLE `glpi_fieldblacklists` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `field` varchar(255) NOT NULL DEFAULT '',
  `value` varchar(255) NOT NULL DEFAULT '',
  `itemtype` varchar(255) NOT NULL DEFAULT '',
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `comment` text DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_fieldblacklists`
--


--
-- Table structure for table `glpi_fieldunicities`
--

CREATE TABLE `glpi_fieldunicities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `itemtype` varchar(255) NOT NULL DEFAULT '',
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `fields` text DEFAULT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `action_refuse` tinyint(4) NOT NULL DEFAULT 0,
  `action_notify` tinyint(4) NOT NULL DEFAULT 0,
  `comment` text DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `is_active` (`is_active`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Stores field unicity criterias';

--
-- Dumping data for table `glpi_fieldunicities`
--


--
-- Table structure for table `glpi_filesystems`
--

CREATE TABLE `glpi_filesystems` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_filesystems`
--

INSERT INTO `glpi_filesystems` VALUES
(1,'ext',NULL,NULL,NULL),
(2,'ext2',NULL,NULL,NULL),
(3,'ext3',NULL,NULL,NULL),
(4,'ext4',NULL,NULL,NULL),
(5,'FAT',NULL,NULL,NULL),
(6,'FAT32',NULL,NULL,NULL),
(7,'VFAT',NULL,NULL,NULL),
(8,'HFS',NULL,NULL,NULL),
(9,'HPFS',NULL,NULL,NULL),
(10,'HTFS',NULL,NULL,NULL),
(11,'JFS',NULL,NULL,NULL),
(12,'JFS2',NULL,NULL,NULL),
(13,'NFS',NULL,NULL,NULL),
(14,'NTFS',NULL,NULL,NULL),
(15,'ReiserFS',NULL,NULL,NULL),
(16,'SMBFS',NULL,NULL,NULL),
(17,'UDF',NULL,NULL,NULL),
(18,'UFS',NULL,NULL,NULL),
(19,'XFS',NULL,NULL,NULL),
(20,'ZFS',NULL,NULL,NULL),
(21,'APFS',NULL,NULL,NULL);

--
-- Table structure for table `glpi_fqdns`
--

CREATE TABLE `glpi_fqdns` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `name` varchar(255) DEFAULT NULL,
  `fqdn` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `entities_id` (`entities_id`),
  KEY `name` (`name`),
  KEY `fqdn` (`fqdn`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_fqdns`
--


--
-- Table structure for table `glpi_groups`
--

CREATE TABLE `glpi_groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `ldap_field` varchar(255) DEFAULT NULL,
  `ldap_value` text DEFAULT NULL,
  `ldap_group_dn` text DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `groups_id` int(10) unsigned NOT NULL DEFAULT 0,
  `completename` text DEFAULT NULL,
  `level` int(11) NOT NULL DEFAULT 0,
  `ancestors_cache` longtext DEFAULT NULL,
  `sons_cache` longtext DEFAULT NULL,
  `is_requester` tinyint(4) NOT NULL DEFAULT 1,
  `is_watcher` tinyint(4) NOT NULL DEFAULT 1,
  `is_assign` tinyint(4) NOT NULL DEFAULT 1,
  `is_task` tinyint(4) NOT NULL DEFAULT 1,
  `is_notify` tinyint(4) NOT NULL DEFAULT 1,
  `is_itemgroup` tinyint(4) NOT NULL DEFAULT 1,
  `is_usergroup` tinyint(4) NOT NULL DEFAULT 1,
  `is_manager` tinyint(4) NOT NULL DEFAULT 1,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `ldap_field` (`ldap_field`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `ldap_value` (`ldap_value`(200)),
  KEY `ldap_group_dn` (`ldap_group_dn`(200)),
  KEY `groups_id` (`groups_id`),
  KEY `is_requester` (`is_requester`),
  KEY `is_watcher` (`is_watcher`),
  KEY `is_assign` (`is_assign`),
  KEY `is_notify` (`is_notify`),
  KEY `is_itemgroup` (`is_itemgroup`),
  KEY `is_usergroup` (`is_usergroup`),
  KEY `is_manager` (`is_manager`),
  KEY `date_creation` (`date_creation`),
  KEY `level` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_groups`
--


--
-- Table structure for table `glpi_groups_knowbaseitems`
--

CREATE TABLE `glpi_groups_knowbaseitems` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `knowbaseitems_id` int(10) unsigned NOT NULL DEFAULT 0,
  `groups_id` int(10) unsigned NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned DEFAULT NULL,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `no_entity_restriction` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `knowbaseitems_id` (`knowbaseitems_id`),
  KEY `groups_id` (`groups_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_groups_knowbaseitems`
--


--
-- Table structure for table `glpi_groups_problems`
--

CREATE TABLE `glpi_groups_problems` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `problems_id` int(10) unsigned NOT NULL DEFAULT 0,
  `groups_id` int(10) unsigned NOT NULL DEFAULT 0,
  `type` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`problems_id`,`type`,`groups_id`),
  KEY `group` (`groups_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_groups_problems`
--


--
-- Table structure for table `glpi_groups_reminders`
--

CREATE TABLE `glpi_groups_reminders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `reminders_id` int(10) unsigned NOT NULL DEFAULT 0,
  `groups_id` int(10) unsigned NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned DEFAULT NULL,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `no_entity_restriction` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `reminders_id` (`reminders_id`),
  KEY `groups_id` (`groups_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_groups_reminders`
--


--
-- Table structure for table `glpi_groups_rssfeeds`
--

CREATE TABLE `glpi_groups_rssfeeds` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rssfeeds_id` int(10) unsigned NOT NULL DEFAULT 0,
  `groups_id` int(10) unsigned NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned DEFAULT NULL,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `no_entity_restriction` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `rssfeeds_id` (`rssfeeds_id`),
  KEY `groups_id` (`groups_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_groups_rssfeeds`
--


--
-- Table structure for table `glpi_groups_tickets`
--

CREATE TABLE `glpi_groups_tickets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tickets_id` int(10) unsigned NOT NULL DEFAULT 0,
  `groups_id` int(10) unsigned NOT NULL DEFAULT 0,
  `type` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`tickets_id`,`type`,`groups_id`),
  KEY `group` (`groups_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_groups_tickets`
--


--
-- Table structure for table `glpi_groups_users`
--

CREATE TABLE `glpi_groups_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `users_id` int(10) unsigned NOT NULL DEFAULT 0,
  `groups_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_dynamic` tinyint(4) NOT NULL DEFAULT 0,
  `is_manager` tinyint(4) NOT NULL DEFAULT 0,
  `is_userdelegate` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`users_id`,`groups_id`),
  KEY `groups_id` (`groups_id`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `is_manager` (`is_manager`),
  KEY `is_userdelegate` (`is_userdelegate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_groups_users`
--


--
-- Table structure for table `glpi_holidays`
--

CREATE TABLE `glpi_holidays` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `comment` text DEFAULT NULL,
  `begin_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `is_perpetual` tinyint(4) NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `begin_date` (`begin_date`),
  KEY `end_date` (`end_date`),
  KEY `is_perpetual` (`is_perpetual`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_holidays`
--


--
-- Table structure for table `glpi_imageformats`
--

CREATE TABLE `glpi_imageformats` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_imageformats`
--


--
-- Table structure for table `glpi_imageresolutions`
--

CREATE TABLE `glpi_imageresolutions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `is_video` tinyint(4) NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `is_video` (`is_video`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_imageresolutions`
--


--
-- Table structure for table `glpi_impactcompounds`
--

CREATE TABLE `glpi_impactcompounds` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT '',
  `color` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_impactcompounds`
--


--
-- Table structure for table `glpi_impactcontexts`
--

CREATE TABLE `glpi_impactcontexts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `positions` mediumtext NOT NULL,
  `zoom` float NOT NULL DEFAULT 0,
  `pan_x` float NOT NULL DEFAULT 0,
  `pan_y` float NOT NULL DEFAULT 0,
  `impact_color` varchar(255) NOT NULL DEFAULT '',
  `depends_color` varchar(255) NOT NULL DEFAULT '',
  `impact_and_depends_color` varchar(255) NOT NULL DEFAULT '',
  `show_depends` tinyint(4) NOT NULL DEFAULT 1,
  `show_impact` tinyint(4) NOT NULL DEFAULT 1,
  `max_depth` int(11) NOT NULL DEFAULT 5,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_impactcontexts`
--


--
-- Table structure for table `glpi_impactitems`
--

CREATE TABLE `glpi_impactitems` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `itemtype` varchar(255) NOT NULL DEFAULT '',
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `parent_id` int(10) unsigned NOT NULL DEFAULT 0,
  `impactcontexts_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_slave` tinyint(4) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`itemtype`,`items_id`),
  KEY `source` (`itemtype`,`items_id`),
  KEY `parent_id` (`parent_id`),
  KEY `impactcontexts_id` (`impactcontexts_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_impactitems`
--


--
-- Table structure for table `glpi_impactrelations`
--

CREATE TABLE `glpi_impactrelations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `itemtype_source` varchar(255) NOT NULL DEFAULT '',
  `items_id_source` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype_impacted` varchar(255) NOT NULL DEFAULT '',
  `items_id_impacted` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`itemtype_source`,`items_id_source`,`itemtype_impacted`,`items_id_impacted`),
  KEY `impacted_asset` (`itemtype_impacted`,`items_id_impacted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_impactrelations`
--


--
-- Table structure for table `glpi_infocoms`
--

CREATE TABLE `glpi_infocoms` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(100) NOT NULL,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `buy_date` date DEFAULT NULL,
  `use_date` date DEFAULT NULL,
  `warranty_duration` int(11) NOT NULL DEFAULT 0,
  `warranty_info` varchar(255) DEFAULT NULL,
  `suppliers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `order_number` varchar(255) DEFAULT NULL,
  `delivery_number` varchar(255) DEFAULT NULL,
  `immo_number` varchar(255) DEFAULT NULL,
  `value` decimal(20,4) NOT NULL DEFAULT 0.0000,
  `warranty_value` decimal(20,4) NOT NULL DEFAULT 0.0000,
  `sink_time` int(11) NOT NULL DEFAULT 0,
  `sink_type` int(11) NOT NULL DEFAULT 0,
  `sink_coeff` float NOT NULL DEFAULT 0,
  `comment` text DEFAULT NULL,
  `bill` varchar(255) DEFAULT NULL,
  `budgets_id` int(10) unsigned NOT NULL DEFAULT 0,
  `alert` int(11) NOT NULL DEFAULT 0,
  `order_date` date DEFAULT NULL,
  `delivery_date` date DEFAULT NULL,
  `inventory_date` date DEFAULT NULL,
  `warranty_date` date DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `decommission_date` timestamp NULL DEFAULT NULL,
  `businesscriticities_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`itemtype`,`items_id`),
  KEY `buy_date` (`buy_date`),
  KEY `alert` (`alert`),
  KEY `budgets_id` (`budgets_id`),
  KEY `suppliers_id` (`suppliers_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `businesscriticities_id` (`businesscriticities_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_infocoms`
--


--
-- Table structure for table `glpi_interfacetypes`
--

CREATE TABLE `glpi_interfacetypes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_interfacetypes`
--

INSERT INTO `glpi_interfacetypes` VALUES
(1,'IDE',NULL,NULL,NULL),
(2,'SATA',NULL,NULL,NULL),
(3,'SCSI',NULL,NULL,NULL),
(4,'USB',NULL,NULL,NULL),
(5,'AGP',NULL,NULL,NULL),
(6,'PCI',NULL,NULL,NULL),
(7,'PCIe',NULL,NULL,NULL),
(8,'PCI-X',NULL,NULL,NULL);

--
-- Table structure for table `glpi_ipaddresses`
--

CREATE TABLE `glpi_ipaddresses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(100) NOT NULL,
  `version` tinyint(3) unsigned DEFAULT 0,
  `name` varchar(255) DEFAULT NULL,
  `binary_0` int(10) unsigned NOT NULL DEFAULT 0,
  `binary_1` int(10) unsigned NOT NULL DEFAULT 0,
  `binary_2` int(10) unsigned NOT NULL DEFAULT 0,
  `binary_3` int(10) unsigned NOT NULL DEFAULT 0,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `is_dynamic` tinyint(4) NOT NULL DEFAULT 0,
  `mainitems_id` int(10) unsigned NOT NULL DEFAULT 0,
  `mainitemtype` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `binary` (`binary_0`,`binary_1`,`binary_2`,`binary_3`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `item` (`itemtype`,`items_id`,`is_deleted`),
  KEY `mainitem` (`mainitemtype`,`mainitems_id`,`is_deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_ipaddresses`
--


--
-- Table structure for table `glpi_ipaddresses_ipnetworks`
--

CREATE TABLE `glpi_ipaddresses_ipnetworks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ipaddresses_id` int(10) unsigned NOT NULL DEFAULT 0,
  `ipnetworks_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`ipaddresses_id`,`ipnetworks_id`),
  KEY `ipnetworks_id` (`ipnetworks_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_ipaddresses_ipnetworks`
--


--
-- Table structure for table `glpi_ipnetworks`
--

CREATE TABLE `glpi_ipnetworks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `ipnetworks_id` int(10) unsigned NOT NULL DEFAULT 0,
  `completename` text DEFAULT NULL,
  `level` int(11) NOT NULL DEFAULT 0,
  `ancestors_cache` longtext DEFAULT NULL,
  `sons_cache` longtext DEFAULT NULL,
  `addressable` tinyint(4) NOT NULL DEFAULT 0,
  `version` tinyint(3) unsigned DEFAULT 0,
  `name` varchar(255) DEFAULT NULL,
  `address` varchar(40) DEFAULT NULL,
  `address_0` int(10) unsigned NOT NULL DEFAULT 0,
  `address_1` int(10) unsigned NOT NULL DEFAULT 0,
  `address_2` int(10) unsigned NOT NULL DEFAULT 0,
  `address_3` int(10) unsigned NOT NULL DEFAULT 0,
  `netmask` varchar(40) DEFAULT NULL,
  `netmask_0` int(10) unsigned NOT NULL DEFAULT 0,
  `netmask_1` int(10) unsigned NOT NULL DEFAULT 0,
  `netmask_2` int(10) unsigned NOT NULL DEFAULT 0,
  `netmask_3` int(10) unsigned NOT NULL DEFAULT 0,
  `gateway` varchar(40) DEFAULT NULL,
  `gateway_0` int(10) unsigned NOT NULL DEFAULT 0,
  `gateway_1` int(10) unsigned NOT NULL DEFAULT 0,
  `gateway_2` int(10) unsigned NOT NULL DEFAULT 0,
  `gateway_3` int(10) unsigned NOT NULL DEFAULT 0,
  `comment` text DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `network_definition` (`entities_id`,`address`,`netmask`),
  KEY `address` (`address_0`,`address_1`,`address_2`,`address_3`),
  KEY `netmask` (`netmask_0`,`netmask_1`,`netmask_2`,`netmask_3`),
  KEY `gateway` (`gateway_0`,`gateway_1`,`gateway_2`,`gateway_3`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `ipnetworks_id` (`ipnetworks_id`),
  KEY `level` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_ipnetworks`
--


--
-- Table structure for table `glpi_ipnetworks_vlans`
--

CREATE TABLE `glpi_ipnetworks_vlans` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ipnetworks_id` int(10) unsigned NOT NULL DEFAULT 0,
  `vlans_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `link` (`ipnetworks_id`,`vlans_id`),
  KEY `vlans_id` (`vlans_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_ipnetworks_vlans`
--


--
-- Table structure for table `glpi_items_clusters`
--

CREATE TABLE `glpi_items_clusters` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `clusters_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(100) DEFAULT NULL,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`clusters_id`,`itemtype`,`items_id`),
  KEY `item` (`itemtype`,`items_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_items_clusters`
--


--
-- Table structure for table `glpi_items_devicebatteries`
--

CREATE TABLE `glpi_items_devicebatteries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(255) DEFAULT NULL,
  `devicebatteries_id` int(10) unsigned NOT NULL DEFAULT 0,
  `manufacturing_date` date DEFAULT NULL,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `is_dynamic` tinyint(4) NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `serial` varchar(255) DEFAULT NULL,
  `otherserial` varchar(255) DEFAULT NULL,
  `locations_id` int(10) unsigned NOT NULL DEFAULT 0,
  `states_id` int(10) unsigned NOT NULL DEFAULT 0,
  `real_capacity` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `devicebatteries_id` (`devicebatteries_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `serial` (`serial`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `otherserial` (`otherserial`),
  KEY `locations_id` (`locations_id`),
  KEY `states_id` (`states_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_items_devicebatteries`
--


--
-- Table structure for table `glpi_items_devicecameras`
--

CREATE TABLE `glpi_items_devicecameras` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(255) DEFAULT NULL,
  `devicecameras_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `is_dynamic` tinyint(4) NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `locations_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `items_id` (`items_id`),
  KEY `devicecameras_id` (`devicecameras_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `locations_id` (`locations_id`),
  KEY `item` (`itemtype`,`items_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_items_devicecameras`
--


--
-- Table structure for table `glpi_items_devicecameras_imageformats`
--

CREATE TABLE `glpi_items_devicecameras_imageformats` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_devicecameras_id` int(10) unsigned NOT NULL DEFAULT 0,
  `imageformats_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_dynamic` tinyint(4) NOT NULL DEFAULT 0,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `items_devicecameras_id` (`items_devicecameras_id`),
  KEY `imageformats_id` (`imageformats_id`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `is_deleted` (`is_deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_items_devicecameras_imageformats`
--


--
-- Table structure for table `glpi_items_devicecameras_imageresolutions`
--

CREATE TABLE `glpi_items_devicecameras_imageresolutions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_devicecameras_id` int(10) unsigned NOT NULL DEFAULT 0,
  `imageresolutions_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_dynamic` tinyint(4) NOT NULL DEFAULT 0,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `items_devicecameras_id` (`items_devicecameras_id`),
  KEY `imageresolutions_id` (`imageresolutions_id`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `is_deleted` (`is_deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_items_devicecameras_imageresolutions`
--


--
-- Table structure for table `glpi_items_devicecases`
--

CREATE TABLE `glpi_items_devicecases` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(255) DEFAULT NULL,
  `devicecases_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `is_dynamic` tinyint(4) NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `serial` varchar(255) DEFAULT NULL,
  `otherserial` varchar(255) DEFAULT NULL,
  `locations_id` int(10) unsigned NOT NULL DEFAULT 0,
  `states_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `devicecases_id` (`devicecases_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `serial` (`serial`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `otherserial` (`otherserial`),
  KEY `locations_id` (`locations_id`),
  KEY `states_id` (`states_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_items_devicecases`
--


--
-- Table structure for table `glpi_items_devicecontrols`
--

CREATE TABLE `glpi_items_devicecontrols` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(255) DEFAULT NULL,
  `devicecontrols_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `is_dynamic` tinyint(4) NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `serial` varchar(255) DEFAULT NULL,
  `busID` varchar(255) DEFAULT NULL,
  `otherserial` varchar(255) DEFAULT NULL,
  `locations_id` int(10) unsigned NOT NULL DEFAULT 0,
  `states_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `devicecontrols_id` (`devicecontrols_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `serial` (`serial`),
  KEY `busID` (`busID`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `otherserial` (`otherserial`),
  KEY `locations_id` (`locations_id`),
  KEY `states_id` (`states_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_items_devicecontrols`
--


--
-- Table structure for table `glpi_items_devicedrives`
--

CREATE TABLE `glpi_items_devicedrives` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(255) DEFAULT NULL,
  `devicedrives_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `is_dynamic` tinyint(4) NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `serial` varchar(255) DEFAULT NULL,
  `busID` varchar(255) DEFAULT NULL,
  `otherserial` varchar(255) DEFAULT NULL,
  `locations_id` int(10) unsigned NOT NULL DEFAULT 0,
  `states_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `devicedrives_id` (`devicedrives_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `serial` (`serial`),
  KEY `busID` (`busID`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `otherserial` (`otherserial`),
  KEY `locations_id` (`locations_id`),
  KEY `states_id` (`states_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_items_devicedrives`
--


--
-- Table structure for table `glpi_items_devicefirmwares`
--

CREATE TABLE `glpi_items_devicefirmwares` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(255) DEFAULT NULL,
  `devicefirmwares_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `is_dynamic` tinyint(4) NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `serial` varchar(255) DEFAULT NULL,
  `otherserial` varchar(255) DEFAULT NULL,
  `locations_id` int(10) unsigned NOT NULL DEFAULT 0,
  `states_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `devicefirmwares_id` (`devicefirmwares_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `serial` (`serial`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `otherserial` (`otherserial`),
  KEY `locations_id` (`locations_id`),
  KEY `states_id` (`states_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_items_devicefirmwares`
--


--
-- Table structure for table `glpi_items_devicegenerics`
--

CREATE TABLE `glpi_items_devicegenerics` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(255) DEFAULT NULL,
  `devicegenerics_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `is_dynamic` tinyint(4) NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `serial` varchar(255) DEFAULT NULL,
  `otherserial` varchar(255) DEFAULT NULL,
  `locations_id` int(10) unsigned NOT NULL DEFAULT 0,
  `states_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `devicegenerics_id` (`devicegenerics_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `serial` (`serial`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `otherserial` (`otherserial`),
  KEY `locations_id` (`locations_id`),
  KEY `states_id` (`states_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_items_devicegenerics`
--


--
-- Table structure for table `glpi_items_devicegraphiccards`
--

CREATE TABLE `glpi_items_devicegraphiccards` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(255) DEFAULT NULL,
  `devicegraphiccards_id` int(10) unsigned NOT NULL DEFAULT 0,
  `memory` int(11) NOT NULL DEFAULT 0,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `is_dynamic` tinyint(4) NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `serial` varchar(255) DEFAULT NULL,
  `busID` varchar(255) DEFAULT NULL,
  `otherserial` varchar(255) DEFAULT NULL,
  `locations_id` int(10) unsigned NOT NULL DEFAULT 0,
  `states_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `devicegraphiccards_id` (`devicegraphiccards_id`),
  KEY `specificity` (`memory`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `serial` (`serial`),
  KEY `busID` (`busID`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `otherserial` (`otherserial`),
  KEY `locations_id` (`locations_id`),
  KEY `states_id` (`states_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_items_devicegraphiccards`
--


--
-- Table structure for table `glpi_items_deviceharddrives`
--

CREATE TABLE `glpi_items_deviceharddrives` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(255) DEFAULT NULL,
  `deviceharddrives_id` int(10) unsigned NOT NULL DEFAULT 0,
  `capacity` int(11) NOT NULL DEFAULT 0,
  `serial` varchar(255) DEFAULT NULL,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `is_dynamic` tinyint(4) NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `busID` varchar(255) DEFAULT NULL,
  `otherserial` varchar(255) DEFAULT NULL,
  `locations_id` int(10) unsigned NOT NULL DEFAULT 0,
  `states_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `deviceharddrives_id` (`deviceharddrives_id`),
  KEY `specificity` (`capacity`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `serial` (`serial`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `busID` (`busID`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `otherserial` (`otherserial`),
  KEY `locations_id` (`locations_id`),
  KEY `states_id` (`states_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
