-- 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;

--
-- Dumping data for table `glpi_items_deviceharddrives`
--


--
-- Table structure for table `glpi_items_devicememories`
--

CREATE TABLE `glpi_items_devicememories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(255) DEFAULT NULL,
  `devicememories_id` int(10) unsigned NOT NULL DEFAULT 0,
  `size` 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 `devicememories_id` (`devicememories_id`),
  KEY `specificity` (`size`),
  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;

--
-- Dumping data for table `glpi_items_devicememories`
--


--
-- Table structure for table `glpi_items_devicemotherboards`
--

CREATE TABLE `glpi_items_devicemotherboards` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(255) DEFAULT NULL,
  `devicemotherboards_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 `devicemotherboards_id` (`devicemotherboards_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_devicemotherboards`
--


--
-- Table structure for table `glpi_items_devicenetworkcards`
--

CREATE TABLE `glpi_items_devicenetworkcards` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(255) DEFAULT NULL,
  `devicenetworkcards_id` int(10) unsigned NOT NULL DEFAULT 0,
  `mac` 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,
  `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 `devicenetworkcards_id` (`devicenetworkcards_id`),
  KEY `specificity` (`mac`),
  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_devicenetworkcards`
--


--
-- Table structure for table `glpi_items_devicepcis`
--

CREATE TABLE `glpi_items_devicepcis` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(255) DEFAULT NULL,
  `devicepcis_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 `devicepcis_id` (`devicepcis_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_devicepcis`
--


--
-- Table structure for table `glpi_items_devicepowersupplies`
--

CREATE TABLE `glpi_items_devicepowersupplies` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(255) DEFAULT NULL,
  `devicepowersupplies_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 `devicepowersupplies_id` (`devicepowersupplies_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_devicepowersupplies`
--


--
-- Table structure for table `glpi_items_deviceprocessors`
--

CREATE TABLE `glpi_items_deviceprocessors` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(255) DEFAULT NULL,
  `deviceprocessors_id` int(10) unsigned NOT NULL DEFAULT 0,
  `frequency` 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,
  `nbcores` int(11) DEFAULT NULL,
  `nbthreads` int(11) DEFAULT NULL,
  `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 `deviceprocessors_id` (`deviceprocessors_id`),
  KEY `specificity` (`frequency`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `serial` (`serial`),
  KEY `nbcores` (`nbcores`),
  KEY `nbthreads` (`nbthreads`),
  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;

--
-- Dumping data for table `glpi_items_deviceprocessors`
--


--
-- Table structure for table `glpi_items_devicesensors`
--

CREATE TABLE `glpi_items_devicesensors` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(255) DEFAULT NULL,
  `devicesensors_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 `devicesensors_id` (`devicesensors_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_devicesensors`
--


--
-- Table structure for table `glpi_items_devicesoundcards`
--

CREATE TABLE `glpi_items_devicesoundcards` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(255) DEFAULT NULL,
  `devicesoundcards_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 `devicesoundcards_id` (`devicesoundcards_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_devicesoundcards`
--


--
-- Table structure for table `glpi_items_disks`
--

CREATE TABLE `glpi_items_disks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(255) DEFAULT NULL,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `name` varchar(255) DEFAULT NULL,
  `device` varchar(255) DEFAULT NULL,
  `mountpoint` varchar(255) DEFAULT NULL,
  `filesystems_id` int(10) unsigned NOT NULL DEFAULT 0,
  `totalsize` bigint(20) NOT NULL DEFAULT 0,
  `freesize` bigint(20) NOT NULL DEFAULT 0,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `is_dynamic` tinyint(4) NOT NULL DEFAULT 0,
  `encryption_status` int(11) NOT NULL DEFAULT 0,
  `encryption_tool` varchar(255) DEFAULT NULL,
  `encryption_algorithm` varchar(255) DEFAULT NULL,
  `encryption_type` varchar(255) DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `device` (`device`),
  KEY `mountpoint` (`mountpoint`),
  KEY `totalsize` (`totalsize`),
  KEY `freesize` (`freesize`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `filesystems_id` (`filesystems_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  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_items_disks`
--


--
-- Table structure for table `glpi_items_enclosures`
--

CREATE TABLE `glpi_items_enclosures` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `enclosures_id` int(10) unsigned NOT NULL,
  `itemtype` varchar(255) NOT NULL,
  `items_id` int(10) unsigned NOT NULL,
  `position` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `item` (`itemtype`,`items_id`),
  KEY `relation` (`enclosures_id`,`itemtype`,`items_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_items_enclosures`
--


--
-- Table structure for table `glpi_items_kanbans`
--

CREATE TABLE `glpi_items_kanbans` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `itemtype` varchar(100) NOT NULL,
  `items_id` int(10) unsigned DEFAULT NULL,
  `users_id` int(10) unsigned NOT NULL,
  `state` text DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`itemtype`,`items_id`,`users_id`),
  KEY `users_id` (`users_id`),
  KEY `date_creation` (`date_creation`),
  KEY `date_mod` (`date_mod`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_items_kanbans`
--


--
-- Table structure for table `glpi_items_operatingsystems`
--

CREATE TABLE `glpi_items_operatingsystems` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(255) DEFAULT NULL,
  `operatingsystems_id` int(10) unsigned NOT NULL DEFAULT 0,
  `operatingsystemversions_id` int(10) unsigned NOT NULL DEFAULT 0,
  `operatingsystemservicepacks_id` int(10) unsigned NOT NULL DEFAULT 0,
  `operatingsystemarchitectures_id` int(10) unsigned NOT NULL DEFAULT 0,
  `operatingsystemkernelversions_id` int(10) unsigned NOT NULL DEFAULT 0,
  `license_number` varchar(255) DEFAULT NULL,
  `licenseid` varchar(255) DEFAULT NULL,
  `company` varchar(255) DEFAULT NULL,
  `owner` varchar(255) DEFAULT NULL,
  `hostid` varchar(255) DEFAULT NULL,
  `operatingsystemeditions_id` int(10) unsigned NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL 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,
  `install_date` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`items_id`,`itemtype`,`operatingsystems_id`,`operatingsystemarchitectures_id`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `operatingsystems_id` (`operatingsystems_id`),
  KEY `operatingsystemservicepacks_id` (`operatingsystemservicepacks_id`),
  KEY `operatingsystemversions_id` (`operatingsystemversions_id`),
  KEY `operatingsystemarchitectures_id` (`operatingsystemarchitectures_id`),
  KEY `operatingsystemkernelversions_id` (`operatingsystemkernelversions_id`),
  KEY `operatingsystemeditions_id` (`operatingsystemeditions_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_creation` (`date_creation`),
  KEY `date_mod` (`date_mod`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_items_operatingsystems`
--


--
-- Table structure for table `glpi_items_problems`
--

CREATE TABLE `glpi_items_problems` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `problems_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` (`problems_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_problems`
--


--
-- Table structure for table `glpi_items_projects`
--

CREATE TABLE `glpi_items_projects` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `projects_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` (`projects_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_projects`
--


--
-- Table structure for table `glpi_items_racks`
--

CREATE TABLE `glpi_items_racks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `racks_id` int(10) unsigned NOT NULL,
  `itemtype` varchar(255) NOT NULL,
  `items_id` int(10) unsigned NOT NULL,
  `position` int(11) NOT NULL,
  `orientation` tinyint(4) DEFAULT NULL,
  `bgcolor` varchar(7) DEFAULT NULL,
  `hpos` tinyint(4) NOT NULL DEFAULT 0,
  `is_reserved` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `item` (`itemtype`,`items_id`,`is_reserved`),
  KEY `relation` (`racks_id`,`itemtype`,`items_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_items_racks`
--


--
-- Table structure for table `glpi_items_remotemanagements`
--

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

--
-- Dumping data for table `glpi_items_remotemanagements`
--


--
-- Table structure for table `glpi_items_softwarelicenses`
--

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

--
-- Dumping data for table `glpi_items_softwarelicenses`
--


--
-- Table structure for table `glpi_items_softwareversions`
--

CREATE TABLE `glpi_items_softwareversions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(100) NOT NULL,
  `softwareversions_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_deleted_item` tinyint(4) NOT NULL DEFAULT 0,
  `is_template_item` tinyint(4) NOT NULL DEFAULT 0,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `is_dynamic` tinyint(4) NOT NULL DEFAULT 0,
  `date_install` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`itemtype`,`items_id`,`softwareversions_id`),
  KEY `softwareversions_id` (`softwareversions_id`),
  KEY `computers_info` (`entities_id`,`is_template_item`,`is_deleted_item`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `is_deleted_item` (`is_deleted_item`),
  KEY `is_template_item` (`is_template_item`),
  KEY `date_install` (`date_install`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_items_softwareversions`
--


--
-- Table structure for table `glpi_items_tickets`
--

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

--
-- Dumping data for table `glpi_items_tickets`
--


--
-- Table structure for table `glpi_itilcategories`
--

CREATE TABLE `glpi_itilcategories` (
  `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,
  `itilcategories_id` int(10) unsigned NOT NULL DEFAULT 0,
  `name` varchar(255) DEFAULT NULL,
  `completename` text DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `level` int(11) NOT NULL DEFAULT 0,
  `knowbaseitemcategories_id` int(10) unsigned NOT NULL DEFAULT 0,
  `users_id` int(10) unsigned NOT NULL DEFAULT 0,
  `groups_id` int(10) unsigned NOT NULL DEFAULT 0,
  `code` varchar(255) DEFAULT NULL,
  `ancestors_cache` longtext DEFAULT NULL,
  `sons_cache` longtext DEFAULT NULL,
  `is_helpdeskvisible` tinyint(4) NOT NULL DEFAULT 1,
  `tickettemplates_id_incident` int(10) unsigned NOT NULL DEFAULT 0,
  `tickettemplates_id_demand` int(10) unsigned NOT NULL DEFAULT 0,
  `changetemplates_id` int(10) unsigned NOT NULL DEFAULT 0,
  `problemtemplates_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_incident` int(11) NOT NULL DEFAULT 1,
  `is_request` int(11) NOT NULL DEFAULT 1,
  `is_problem` int(11) NOT NULL DEFAULT 1,
  `is_change` tinyint(4) NOT NULL DEFAULT 1,
  `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 `knowbaseitemcategories_id` (`knowbaseitemcategories_id`),
  KEY `users_id` (`users_id`),
  KEY `groups_id` (`groups_id`),
  KEY `is_helpdeskvisible` (`is_helpdeskvisible`),
  KEY `itilcategories_id` (`itilcategories_id`),
  KEY `tickettemplates_id_incident` (`tickettemplates_id_incident`),
  KEY `tickettemplates_id_demand` (`tickettemplates_id_demand`),
  KEY `changetemplates_id` (`changetemplates_id`),
  KEY `problemtemplates_id` (`problemtemplates_id`),
  KEY `is_incident` (`is_incident`),
  KEY `is_request` (`is_request`),
  KEY `is_problem` (`is_problem`),
  KEY `is_change` (`is_change`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `level` (`level`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_itilcategories`
--

INSERT INTO `glpi_itilcategories` VALUES
(6,0,0,0,'Incident','Incident','Traiter les interruptions ou dysfonctionnements signalés.',1,0,0,0,'','[]',NULL,1,0,0,0,0,1,1,1,1,'2024-12-06 10:24:26','2024-12-06 10:24:26'),
(7,0,0,0,'Demande de service','Demande de service','Répondre aux demandes courantes des utilisateurs.',1,0,0,0,'','[]',NULL,1,0,0,0,0,1,1,1,1,'2024-12-06 10:24:38','2024-12-06 10:24:38'),
(15,0,0,7,'Logiciel','Demande de service > Logiciel',NULL,2,0,0,0,'','{\"7\":7}',NULL,1,0,0,0,0,1,1,1,1,'2024-12-06 10:31:44','2024-12-06 10:31:44'),
(16,0,0,15,'Comptabilité','Demande de service > Logiciel > Comptabilité',NULL,3,0,0,0,'','{\"7\":7,\"15\":15}',NULL,1,0,0,0,0,1,1,1,1,'2024-12-06 10:31:56','2024-12-06 10:31:56'),
(17,0,0,7,'Réseau','Demande de service > Réseau',NULL,2,0,0,0,'','{\"7\":7}',NULL,1,0,0,0,0,1,1,1,1,'2024-12-06 10:32:13','2024-12-06 10:32:13'),
(18,0,0,7,'Matériel','Demande de service > Matériel',NULL,2,0,0,0,'','{\"7\":7}',NULL,1,0,0,0,0,1,1,1,1,'2024-12-06 10:32:18','2024-12-06 10:32:18'),
(19,0,0,17,'VPN','Demande de service > Réseau > VPN',NULL,3,0,0,0,'','{\"7\":7,\"17\":17}',NULL,1,0,0,0,0,1,1,1,1,'2024-12-06 10:32:28','2024-12-06 10:32:28'),
(20,0,0,18,'Stock','Demande de service > Matériel > Stock',NULL,3,0,0,0,'','{\"7\":7,\"18\":18}',NULL,1,0,0,0,0,1,1,1,1,'2024-12-06 10:32:48','2024-12-06 10:32:48'),
(21,0,0,6,'Comptes utilisateurs','Incident > Comptes utilisateurs',NULL,2,0,0,0,'','{\"6\":6}',NULL,1,0,0,0,0,1,1,1,1,'2024-12-06 10:33:03','2024-12-06 10:33:03'),
(22,0,0,6,'Climatisation','Incident > Climatisation',NULL,2,0,0,0,'','{\"6\":6}',NULL,1,0,0,0,0,1,1,1,1,'2024-12-06 10:33:07','2024-12-06 10:33:07'),
(23,0,0,6,'Sécurité','Incident > Sécurité',NULL,2,0,0,0,'','{\"6\":6}',NULL,1,0,0,0,0,1,1,1,1,'2024-12-06 10:33:29','2024-12-06 10:33:29'),
(24,0,0,21,'Active Directory','Incident > Comptes utilisateurs > Active Directory',NULL,3,0,0,0,'','{\"6\":6,\"21\":21}',NULL,1,0,0,0,0,1,1,1,1,'2024-12-06 10:33:41','2024-12-06 10:33:41'),
(25,0,0,22,'Salle serveur','Incident > Climatisation > Salle serveur',NULL,3,0,0,0,'','{\"6\":6,\"22\":22}',NULL,1,0,0,0,0,1,1,1,1,'2024-12-06 10:33:52','2024-12-06 10:33:52'),
(26,0,0,23,'Infection présumée','Incident > Sécurité > Infection présumée',NULL,3,0,0,0,'','{\"6\":6,\"23\":23}',NULL,1,0,0,0,0,1,1,1,1,'2024-12-06 10:34:05','2024-12-06 10:34:05'),
(29,0,0,0,'Demande d\'accès','Demande d\'accès','',1,0,0,0,'','[]',NULL,1,0,0,0,0,1,1,1,1,'2024-12-06 10:40:18','2024-12-06 10:40:18'),
(30,0,0,29,'Serveur','Demande d\'accès > Serveur',NULL,2,0,0,0,'','{\"29\":29}',NULL,1,0,0,0,0,1,1,1,1,'2024-12-06 10:40:33','2024-12-06 10:40:33'),
(31,0,0,30,'Logs d\'application','Demande d\'accès > Serveur > Logs d\'application',NULL,3,0,0,0,'','{\"29\":29,\"30\":30}',NULL,1,0,0,0,0,1,1,1,1,'2024-12-06 10:40:40','2024-12-06 10:40:40'),
(32,0,0,0,'Support matériel','Support matériel','',1,0,0,0,'','[]',NULL,1,0,0,0,0,1,1,1,1,'2024-12-06 10:40:49','2024-12-06 10:40:49'),
(33,0,0,32,'Téléphones','Support matériel > Téléphones',NULL,2,0,0,0,'','{\"32\":32}',NULL,1,0,0,0,0,1,1,1,1,'2024-12-06 10:41:08','2024-12-06 10:41:08'),
(34,0,0,32,'Logiciel non autorisé','Support matériel > Logiciel non autorisé',NULL,2,0,0,0,'','{\"32\":32}',NULL,1,0,0,0,0,1,1,1,1,'2024-12-06 10:41:15','2024-12-06 10:41:15'),
(35,0,0,33,'Distribution','Support matériel > Téléphones > Distribution',NULL,3,0,0,0,'','{\"32\":32,\"33\":33}',NULL,1,0,0,0,0,1,1,1,1,'2024-12-06 10:41:24','2024-12-06 10:41:24'),
(36,0,0,0,'Serveur','Serveur','',1,0,0,0,'','[]',NULL,1,0,0,0,0,1,1,1,1,'2024-12-06 10:43:43','2024-12-06 10:43:43'),
(37,0,0,36,'Libération','Serveur > Libération',NULL,2,0,0,0,'','{\"36\":36}',NULL,1,0,0,0,0,1,1,1,1,'2024-12-06 10:44:01','2024-12-06 10:44:01'),
(38,0,0,29,'Application métier','Demande d\'accès > Application métier',NULL,2,0,0,0,'','{\"29\":29}',NULL,1,0,0,0,0,1,1,1,1,'2024-12-07 14:51:09','2024-12-07 14:51:09');

--
-- Table structure for table `glpi_itilfollowups`
--

CREATE TABLE `glpi_itilfollowups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `itemtype` varchar(100) NOT NULL,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `date` timestamp NULL DEFAULT NULL,
  `users_id` int(10) unsigned NOT NULL DEFAULT 0,
  `users_id_editor` int(10) unsigned NOT NULL DEFAULT 0,
  `content` longtext DEFAULT NULL,
  `is_private` tinyint(4) NOT NULL DEFAULT 0,
  `requesttypes_id` int(10) unsigned NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `timeline_position` tinyint(4) NOT NULL DEFAULT 0,
  `sourceitems_id` int(10) unsigned NOT NULL DEFAULT 0,
  `sourceof_items_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `date` (`date`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `users_id` (`users_id`),
  KEY `users_id_editor` (`users_id_editor`),
  KEY `is_private` (`is_private`),
  KEY `requesttypes_id` (`requesttypes_id`),
  KEY `sourceitems_id` (`sourceitems_id`),
  KEY `sourceof_items_id` (`sourceof_items_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_itilfollowups`
--

INSERT INTO `glpi_itilfollowups` VALUES
(1,'Ticket',3,'2024-12-06 10:57:52',2,0,'&#60;table style=\"border-collapse: collapse; width: 251pt;\" border=\"0\" width=\"335\" cellspacing=\"0\" cellpadding=\"0\"&#62;&#60;colgroup&#62;&#60;col style=\"mso-width-source: userset; mso-width-alt: 11918; width: 251pt;\" width=\"335\"&#62; &#60;/colgroup&#62;\r\n&#60;tbody&#62;\r\n&#60;tr style=\"height: 82.8pt;\"&#62;\r\n&#60;td class=\"xl65\" style=\"height: 82.8pt; width: 251pt;\" width=\"335\" height=\"110\"&#62;La politique de sécurité de l\'entreprise veut que seuls les administrateurs disposent des droits d\'administration.&#60;br&#62;Un accès aux logs de l\'application est suffisant.&#60;/td&#62;\r\n&#60;/tr&#62;\r\n&#60;/tbody&#62;\r\n&#60;/table&#62;',0,1,'2024-12-06 10:57:52','2024-12-06 10:57:52',1,0,0),
(2,'Ticket',5,'2024-12-06 11:02:52',2,0,'&#60;p&#62;Les machines du réseau 10.0.1.0/24 ont besoin d\'accéder à un service web hébergé chez le partenaire Ocito&#60;/p&#62;',0,1,'2024-12-06 11:02:52','2024-12-06 11:02:52',1,0,0);

--
-- Table structure for table `glpi_itilfollowuptemplates`
--

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

--
-- Dumping data for table `glpi_itilfollowuptemplates`
--


--
-- Table structure for table `glpi_itils_projects`
--

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

--
-- Dumping data for table `glpi_itils_projects`
--


--
-- Table structure for table `glpi_itilsolutions`
--

CREATE TABLE `glpi_itilsolutions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `itemtype` varchar(100) NOT NULL,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `solutiontypes_id` int(10) unsigned NOT NULL DEFAULT 0,
  `solutiontype_name` varchar(255) DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_approval` timestamp NULL DEFAULT NULL,
  `users_id` int(10) unsigned NOT NULL DEFAULT 0,
  `user_name` varchar(255) DEFAULT NULL,
  `users_id_editor` int(10) unsigned NOT NULL DEFAULT 0,
  `users_id_approval` int(10) unsigned NOT NULL DEFAULT 0,
  `user_name_approval` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `itilfollowups_id` int(10) unsigned DEFAULT NULL COMMENT 'Followup reference on reject or approve a solution',
  PRIMARY KEY (`id`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `solutiontypes_id` (`solutiontypes_id`),
  KEY `users_id` (`users_id`),
  KEY `users_id_editor` (`users_id_editor`),
  KEY `users_id_approval` (`users_id_approval`),
  KEY `status` (`status`),
  KEY `itilfollowups_id` (`itilfollowups_id`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_itilsolutions`
--

INSERT INTO `glpi_itilsolutions` VALUES
(1,'Ticket',7,0,NULL,'&#60;p&#62;J\'ai transmis au service Achats une commande pour 10 disques de 4 To Toshiba MG08ADA400A et 5 disques de 8To Toshiba MG08ADA800A.&#60;/p&#62;','2024-12-07 15:03:27','2024-12-07 15:10:48',NULL,16,NULL,16,0,NULL,2,NULL),
(2,'Ticket',2,0,NULL,'&#60;p&#62;Bonjour, votre mot de passe a été réinitialisé. Pour des raisons de sécurité, le nouveau mot de passe est disponible au pôle infrastructure. Nous vous invitons à venir le récupérer en personne munie d\'une pièce d\'identité ou de votre badge d\'accès professionnel.&#60;/p&#62;','2024-12-07 15:13:57','2024-12-07 15:13:57',NULL,16,NULL,0,0,NULL,2,NULL),
(3,'Ticket',10,0,NULL,'&#60;p&#62;Bonjour Steeve, les accès à l\'application Zefyr ont été rétablis.&#60;/p&#62;','2024-12-07 15:26:21','2024-12-07 15:26:21',NULL,16,NULL,0,0,NULL,2,NULL),
(4,'Ticket',5,0,NULL,'&#60;p&#62;Bonjour,&#60;/p&#62;\r\n&#60;p&#62;Un mail a été envoyé, je te tiens au courant.&#60;/p&#62;','2024-12-07 15:56:11','2024-12-07 15:56:11',NULL,16,NULL,0,0,NULL,2,NULL),
(5,'Ticket',1,0,NULL,'&#60;p&#62;Bonjour,&#60;/p&#62;\r\n&#60;p&#62;J\'ai redonné l\'accès à Zefyr à Steeve afin qu\'il puisse terminer ses exports d\'écrits comptables. Des solutions vous ont été proposée par mail.&#60;/p&#62;','2024-12-07 16:09:08','2024-12-07 16:09:08',NULL,16,NULL,0,0,NULL,2,NULL);

--
-- Table structure for table `glpi_knowbaseitemcategories`
--

CREATE TABLE `glpi_knowbaseitemcategories` (
  `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,
  `knowbaseitemcategories_id` int(10) unsigned NOT NULL DEFAULT 0,
  `name` varchar(255) DEFAULT NULL,
  `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,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`entities_id`,`knowbaseitemcategories_id`,`name`),
  KEY `name` (`name`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `knowbaseitemcategories_id` (`knowbaseitemcategories_id`),
  KEY `level` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_knowbaseitemcategories`
--


--
-- Table structure for table `glpi_knowbaseitems`
--

CREATE TABLE `glpi_knowbaseitems` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` text DEFAULT NULL,
  `answer` longtext DEFAULT NULL,
  `is_faq` tinyint(4) NOT NULL DEFAULT 0,
  `users_id` int(10) unsigned NOT NULL DEFAULT 0,
  `view` int(11) NOT NULL DEFAULT 0,
  `date_creation` timestamp NULL DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `begin_date` timestamp NULL DEFAULT NULL,
  `end_date` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `users_id` (`users_id`),
  KEY `is_faq` (`is_faq`),
  KEY `date_creation` (`date_creation`),
  KEY `date_mod` (`date_mod`),
  KEY `begin_date` (`begin_date`),
  KEY `end_date` (`end_date`),
  FULLTEXT KEY `fulltext` (`name`,`answer`),
  FULLTEXT KEY `name` (`name`),
  FULLTEXT KEY `answer` (`answer`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_knowbaseitems`
--


--
-- Table structure for table `glpi_knowbaseitems_comments`
--

CREATE TABLE `glpi_knowbaseitems_comments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `knowbaseitems_id` int(10) unsigned NOT NULL,
  `users_id` int(10) unsigned NOT NULL DEFAULT 0,
  `language` varchar(10) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `parent_comment_id` int(10) unsigned DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `knowbaseitems_id` (`knowbaseitems_id`),
  KEY `parent_comment_id` (`parent_comment_id`),
  KEY `users_id` (`users_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_knowbaseitems_comments`
--


--
-- Table structure for table `glpi_knowbaseitems_items`
--

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

--
-- Dumping data for table `glpi_knowbaseitems_items`
--


--
-- Table structure for table `glpi_knowbaseitems_knowbaseitemcategories`
--

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

--
-- Dumping data for table `glpi_knowbaseitems_knowbaseitemcategories`
--


--
-- Table structure for table `glpi_knowbaseitems_profiles`
--

CREATE TABLE `glpi_knowbaseitems_profiles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `knowbaseitems_id` int(10) unsigned NOT NULL DEFAULT 0,
  `profiles_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 `profiles_id` (`profiles_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_knowbaseitems_profiles`
--


--
-- Table structure for table `glpi_knowbaseitems_revisions`
--

CREATE TABLE `glpi_knowbaseitems_revisions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `knowbaseitems_id` int(10) unsigned NOT NULL,
  `revision` int(11) NOT NULL,
  `name` text DEFAULT NULL,
  `answer` longtext DEFAULT NULL,
  `language` varchar(10) DEFAULT NULL,
  `users_id` int(10) unsigned NOT NULL DEFAULT 0,
  `date` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`knowbaseitems_id`,`revision`,`language`),
  KEY `revision` (`revision`),
  KEY `users_id` (`users_id`),
  KEY `date` (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_knowbaseitems_revisions`
--


--
-- Table structure for table `glpi_knowbaseitems_users`
--

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

--
-- Dumping data for table `glpi_knowbaseitems_users`
--


--
-- Table structure for table `glpi_knowbaseitemtranslations`
--

CREATE TABLE `glpi_knowbaseitemtranslations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `knowbaseitems_id` int(10) unsigned NOT NULL DEFAULT 0,
  `language` varchar(10) DEFAULT NULL,
  `name` text DEFAULT NULL,
  `answer` longtext DEFAULT NULL,
  `users_id` int(10) unsigned NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `item` (`knowbaseitems_id`,`language`),
  KEY `users_id` (`users_id`),
  KEY `date_creation` (`date_creation`),
  KEY `date_mod` (`date_mod`),
  FULLTEXT KEY `fulltext` (`name`,`answer`),
  FULLTEXT KEY `name` (`name`),
  FULLTEXT KEY `answer` (`answer`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_knowbaseitemtranslations`
--


--
-- Table structure for table `glpi_lineoperators`
--

CREATE TABLE `glpi_lineoperators` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `comment` text DEFAULT NULL,
  `mcc` int(11) DEFAULT NULL,
  `mnc` int(11) DEFAULT NULL,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`mcc`,`mnc`),
  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_lineoperators`
--


--
-- Table structure for table `glpi_lines`
--

CREATE TABLE `glpi_lines` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `caller_num` varchar(255) NOT NULL DEFAULT '',
  `caller_name` varchar(255) NOT NULL DEFAULT '',
  `users_id` int(10) unsigned NOT NULL DEFAULT 0,
  `groups_id` int(10) unsigned NOT NULL DEFAULT 0,
  `lineoperators_id` int(10) unsigned NOT NULL DEFAULT 0,
  `locations_id` int(10) unsigned NOT NULL DEFAULT 0,
  `states_id` int(10) unsigned NOT NULL DEFAULT 0,
  `linetypes_id` int(10) unsigned NOT NULL DEFAULT 0,
  `date_creation` timestamp NULL DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `comment` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `is_deleted` (`is_deleted`),
  KEY `users_id` (`users_id`),
  KEY `lineoperators_id` (`lineoperators_id`),
  KEY `groups_id` (`groups_id`),
  KEY `linetypes_id` (`linetypes_id`),
  KEY `locations_id` (`locations_id`),
  KEY `states_id` (`states_id`),
  KEY `date_creation` (`date_creation`),
  KEY `date_mod` (`date_mod`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_lines`
--


--
-- Table structure for table `glpi_linetypes`
--

CREATE TABLE `glpi_linetypes` (
  `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_linetypes`
--


--
-- Table structure for table `glpi_links`
--

CREATE TABLE `glpi_links` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 1,
  `name` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `data` text DEFAULT NULL,
  `open_window` tinyint(4) NOT NULL DEFAULT 1,
  `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_links`
--


--
-- Table structure for table `glpi_links_itemtypes`
--

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

--
-- Dumping data for table `glpi_links_itemtypes`
--


--
-- Table structure for table `glpi_locations`
--

CREATE TABLE `glpi_locations` (
  `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,
  `locations_id` int(10) unsigned NOT NULL DEFAULT 0,
  `completename` text DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `level` int(11) NOT NULL DEFAULT 0,
  `ancestors_cache` longtext DEFAULT NULL,
  `sons_cache` longtext 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,
  `building` varchar(255) DEFAULT NULL,
  `room` varchar(255) DEFAULT NULL,
  `latitude` varchar(255) DEFAULT NULL,
  `longitude` varchar(255) DEFAULT NULL,
  `altitude` varchar(255) DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`entities_id`,`locations_id`,`name`),
  KEY `locations_id` (`locations_id`),
  KEY `name` (`name`),
  KEY `is_recursive` (`is_recursive`),
  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_locations`
--


--
-- Table structure for table `glpi_lockedfields`
--

CREATE TABLE `glpi_lockedfields` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `itemtype` varchar(100) DEFAULT NULL,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `field` varchar(50) NOT NULL,
  `value` varchar(255) DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `is_global` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`itemtype`,`items_id`,`field`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `is_global` (`is_global`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_lockedfields`
--


--
-- Table structure for table `glpi_logs`
--

CREATE TABLE `glpi_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `itemtype` varchar(100) NOT NULL DEFAULT '',
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype_link` varchar(100) NOT NULL DEFAULT '',
  `linked_action` int(11) NOT NULL DEFAULT 0 COMMENT 'see define.php HISTORY_* constant',
  `user_name` varchar(255) DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `id_search_option` int(11) NOT NULL DEFAULT 0 COMMENT 'see search.constant.php for value',
  `old_value` varchar(255) DEFAULT NULL,
  `new_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `date_mod` (`date_mod`),
  KEY `itemtype_link` (`itemtype_link`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `id_search_option` (`id_search_option`)
) ENGINE=InnoDB AUTO_INCREMENT=966 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_logs`
--

INSERT INTO `glpi_logs` VALUES
(1,'RuleImportAsset',1,'0',20,'','2024-12-01 14:42:31',0,'',''),
(2,'RuleImportAsset',1,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Est partiel est Oui (1)'),
(3,'RuleCriteria',1,'0',20,'','2024-12-01 14:42:31',0,'',''),
(4,'RuleImportAsset',1,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément n\'existe pas Oui (2)'),
(5,'RuleCriteria',2,'0',20,'','2024-12-01 14:42:31',0,'',''),
(6,'RuleImportAsset',1,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Refuser l\'import Assigner Oui (1)'),
(7,'RuleAction',1,'0',20,'','2024-12-01 14:42:31',0,'',''),
(8,'RuleImportAsset',2,'0',20,'','2024-12-01 14:42:31',0,'',''),
(9,'RuleImportAsset',2,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément n\'existe pas Oui (3)'),
(10,'RuleCriteria',3,'0',20,'','2024-12-01 14:42:31',0,'',''),
(11,'RuleImportAsset',2,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; MAC est déjà présent Oui (4)'),
(12,'RuleCriteria',4,'0',20,'','2024-12-01 14:42:31',0,'',''),
(13,'RuleImportAsset',2,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; MAC existe Oui (5)'),
(14,'RuleCriteria',5,'0',20,'','2024-12-01 14:42:31',0,'',''),
(15,'RuleImportAsset',2,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; Numéro de port est déjà présent Oui (6)'),
(16,'RuleCriteria',6,'0',20,'','2024-12-01 14:42:31',0,'',''),
(17,'RuleImportAsset',2,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; Numéro de port existe Oui (7)'),
(18,'RuleCriteria',7,'0',20,'','2024-12-01 14:42:31',0,'',''),
(19,'RuleImportAsset',2,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Général &#62; Restreindre les critères au même port réseau Oui Oui (8)'),
(20,'RuleCriteria',8,'0',20,'','2024-12-01 14:42:31',0,'',''),
(21,'RuleImportAsset',2,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (2)'),
(22,'RuleAction',2,'0',20,'','2024-12-01 14:42:31',0,'',''),
(23,'RuleImportAsset',3,'0',20,'','2024-12-01 14:42:31',0,'',''),
(24,'RuleImportAsset',3,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément n\'existe pas Oui (9)'),
(25,'RuleCriteria',9,'0',20,'','2024-12-01 14:42:31',0,'',''),
(26,'RuleImportAsset',3,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; MAC est déjà présent Oui (10)'),
(27,'RuleCriteria',10,'0',20,'','2024-12-01 14:42:31',0,'',''),
(28,'RuleImportAsset',3,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; MAC existe Oui (11)'),
(29,'RuleCriteria',11,'0',20,'','2024-12-01 14:42:31',0,'',''),
(30,'RuleImportAsset',3,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; Numéro de port est déjà présent Oui (12)'),
(31,'RuleCriteria',12,'0',20,'','2024-12-01 14:42:31',0,'',''),
(32,'RuleImportAsset',3,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; Numéro de port existe Oui (13)'),
(33,'RuleCriteria',13,'0',20,'','2024-12-01 14:42:31',0,'',''),
(34,'RuleImportAsset',3,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (3)'),
(35,'RuleAction',3,'0',20,'','2024-12-01 14:42:31',0,'',''),
(36,'RuleImportAsset',4,'0',20,'','2024-12-01 14:42:31',0,'',''),
(37,'RuleImportAsset',4,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément n\'existe pas Oui (14)'),
(38,'RuleCriteria',14,'0',20,'','2024-12-01 14:42:31',0,'',''),
(39,'RuleImportAsset',4,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; MAC existe Oui (15)'),
(40,'RuleCriteria',15,'0',20,'','2024-12-01 14:42:31',0,'',''),
(41,'RuleImportAsset',4,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; Numéro de port existe Oui (16)'),
(42,'RuleCriteria',16,'0',20,'','2024-12-01 14:42:31',0,'',''),
(43,'RuleImportAsset',4,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (4)'),
(44,'RuleAction',4,'0',20,'','2024-12-01 14:42:31',0,'',''),
(45,'RuleImportAsset',5,'0',20,'','2024-12-01 14:42:31',0,'',''),
(46,'RuleImportAsset',5,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément n\'existe pas Oui (17)'),
(47,'RuleCriteria',17,'0',20,'','2024-12-01 14:42:31',0,'',''),
(48,'RuleImportAsset',5,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; IP est déjà présent Oui (18)'),
(49,'RuleCriteria',18,'0',20,'','2024-12-01 14:42:31',0,'',''),
(50,'RuleImportAsset',5,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; IP existe Oui (19)'),
(51,'RuleCriteria',19,'0',20,'','2024-12-01 14:42:31',0,'',''),
(52,'RuleImportAsset',5,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; Description du port est déjà présent Oui (20)'),
(53,'RuleCriteria',20,'0',20,'','2024-12-01 14:42:31',0,'',''),
(54,'RuleImportAsset',5,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; Description du port existe Oui (21)'),
(55,'RuleCriteria',21,'0',20,'','2024-12-01 14:42:31',0,'',''),
(56,'RuleImportAsset',5,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Général &#62; Restreindre les critères au même port réseau Oui Oui (22)'),
(57,'RuleCriteria',22,'0',20,'','2024-12-01 14:42:31',0,'',''),
(58,'RuleImportAsset',5,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (5)'),
(59,'RuleAction',5,'0',20,'','2024-12-01 14:42:31',0,'',''),
(60,'RuleImportAsset',6,'0',20,'','2024-12-01 14:42:31',0,'',''),
(61,'RuleImportAsset',6,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément n\'existe pas Oui (23)'),
(62,'RuleCriteria',23,'0',20,'','2024-12-01 14:42:31',0,'',''),
(63,'RuleImportAsset',6,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; IP est déjà présent Oui (24)'),
(64,'RuleCriteria',24,'0',20,'','2024-12-01 14:42:31',0,'',''),
(65,'RuleImportAsset',6,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; IP existe Oui (25)'),
(66,'RuleCriteria',25,'0',20,'','2024-12-01 14:42:31',0,'',''),
(67,'RuleImportAsset',6,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; Description du port est déjà présent Oui (26)'),
(68,'RuleCriteria',26,'0',20,'','2024-12-01 14:42:31',0,'',''),
(69,'RuleImportAsset',6,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; Description du port existe Oui (27)'),
(70,'RuleCriteria',27,'0',20,'','2024-12-01 14:42:31',0,'',''),
(71,'RuleImportAsset',6,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (6)'),
(72,'RuleAction',6,'0',20,'','2024-12-01 14:42:31',0,'',''),
(73,'RuleImportAsset',7,'0',20,'','2024-12-01 14:42:31',0,'',''),
(74,'RuleImportAsset',7,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément n\'existe pas Oui (28)'),
(75,'RuleCriteria',28,'0',20,'','2024-12-01 14:42:31',0,'',''),
(76,'RuleImportAsset',7,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; IP existe Oui (29)'),
(77,'RuleCriteria',29,'0',20,'','2024-12-01 14:42:31',0,'',''),
(78,'RuleImportAsset',7,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; Description du port existe Oui (30)'),
(79,'RuleCriteria',30,'0',20,'','2024-12-01 14:42:31',0,'',''),
(80,'RuleImportAsset',7,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (7)'),
(81,'RuleAction',7,'0',20,'','2024-12-01 14:42:31',0,'',''),
(82,'RuleImportAsset',8,'0',20,'','2024-12-01 14:42:31',0,'',''),
(83,'RuleImportAsset',8,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément n\'existe pas Oui (31)'),
(84,'RuleCriteria',31,'0',20,'','2024-12-01 14:42:31',0,'',''),
(85,'RuleImportAsset',8,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; MAC est déjà présent Oui (32)'),
(86,'RuleCriteria',32,'0',20,'','2024-12-01 14:42:31',0,'',''),
(87,'RuleImportAsset',8,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; MAC existe Oui (33)'),
(88,'RuleCriteria',33,'0',20,'','2024-12-01 14:42:31',0,'',''),
(89,'RuleImportAsset',8,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Général &#62; Uniquement les critères de cette règle dans les données Oui Oui (34)'),
(90,'RuleCriteria',34,'0',20,'','2024-12-01 14:42:31',0,'',''),
(91,'RuleImportAsset',8,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (8)'),
(92,'RuleAction',8,'0',20,'','2024-12-01 14:42:31',0,'',''),
(93,'RuleImportAsset',9,'0',20,'','2024-12-01 14:42:31',0,'',''),
(94,'RuleImportAsset',9,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément n\'existe pas Oui (35)'),
(95,'RuleCriteria',35,'0',20,'','2024-12-01 14:42:31',0,'',''),
(96,'RuleImportAsset',9,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; MAC existe Oui (36)'),
(97,'RuleCriteria',36,'0',20,'','2024-12-01 14:42:31',0,'',''),
(98,'RuleImportAsset',9,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Général &#62; Uniquement les critères de cette règle dans les données Oui Oui (37)'),
(99,'RuleCriteria',37,'0',20,'','2024-12-01 14:42:31',0,'',''),
(100,'RuleImportAsset',9,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (9)'),
(101,'RuleAction',9,'0',20,'','2024-12-01 14:42:31',0,'',''),
(102,'RuleImportAsset',10,'0',20,'','2024-12-01 14:42:31',0,'',''),
(103,'RuleImportAsset',10,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Ordinateur (38)'),
(104,'RuleCriteria',38,'0',20,'','2024-12-01 14:42:31',0,'',''),
(105,'RuleImportAsset',10,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Nom n\'existe pas Oui (39)'),
(106,'RuleCriteria',39,'0',20,'','2024-12-01 14:42:31',0,'',''),
(107,'RuleImportAsset',10,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Refuser l\'import Assigner Oui (10)'),
(108,'RuleAction',10,'0',20,'','2024-12-01 14:42:31',0,'',''),
(109,'RuleImportAsset',11,'0',20,'','2024-12-01 14:42:31',0,'',''),
(110,'RuleImportAsset',11,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Ordinateur (40)'),
(111,'RuleCriteria',40,'0',20,'','2024-12-01 14:42:31',0,'',''),
(112,'RuleImportAsset',11,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série est déjà présent Oui (41)'),
(113,'RuleCriteria',41,'0',20,'','2024-12-01 14:42:31',0,'',''),
(114,'RuleImportAsset',11,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série existe Oui (42)'),
(115,'RuleCriteria',42,'0',20,'','2024-12-01 14:42:31',0,'',''),
(116,'RuleImportAsset',11,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; UUID est déjà présent Oui (43)'),
(117,'RuleCriteria',43,'0',20,'','2024-12-01 14:42:31',0,'',''),
(118,'RuleImportAsset',11,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; UUID existe Oui (44)'),
(119,'RuleCriteria',44,'0',20,'','2024-12-01 14:42:31',0,'',''),
(120,'RuleImportAsset',11,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (11)'),
(121,'RuleAction',11,'0',20,'','2024-12-01 14:42:31',0,'',''),
(122,'RuleImportAsset',12,'0',20,'','2024-12-01 14:42:31',0,'',''),
(123,'RuleImportAsset',12,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Ordinateur (45)'),
(124,'RuleCriteria',45,'0',20,'','2024-12-01 14:42:31',0,'',''),
(125,'RuleImportAsset',12,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série est déjà présent Oui (46)'),
(126,'RuleCriteria',46,'0',20,'','2024-12-01 14:42:31',0,'',''),
(127,'RuleImportAsset',12,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série existe Oui (47)'),
(128,'RuleCriteria',47,'0',20,'','2024-12-01 14:42:31',0,'',''),
(129,'RuleImportAsset',12,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; UUID est vide Oui (48)'),
(130,'RuleCriteria',48,'0',20,'','2024-12-01 14:42:31',0,'',''),
(131,'RuleImportAsset',12,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (12)'),
(132,'RuleAction',12,'0',20,'','2024-12-01 14:42:31',0,'',''),
(133,'RuleImportAsset',13,'0',20,'','2024-12-01 14:42:31',0,'',''),
(134,'RuleImportAsset',13,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Ordinateur (49)'),
(135,'RuleCriteria',49,'0',20,'','2024-12-01 14:42:31',0,'',''),
(136,'RuleImportAsset',13,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; UUID existe Oui (50)'),
(137,'RuleCriteria',50,'0',20,'','2024-12-01 14:42:31',0,'',''),
(138,'RuleImportAsset',13,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série existe Oui (51)'),
(139,'RuleCriteria',51,'0',20,'','2024-12-01 14:42:31',0,'',''),
(140,'RuleImportAsset',13,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (13)'),
(141,'RuleAction',13,'0',20,'','2024-12-01 14:42:31',0,'',''),
(142,'RuleImportAsset',14,'0',20,'','2024-12-01 14:42:31',0,'',''),
(143,'RuleImportAsset',14,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Ordinateur (52)'),
(144,'RuleCriteria',52,'0',20,'','2024-12-01 14:42:31',0,'',''),
(145,'RuleImportAsset',14,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série est déjà présent Oui (53)'),
(146,'RuleCriteria',53,'0',20,'','2024-12-01 14:42:31',0,'',''),
(147,'RuleImportAsset',14,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série existe Oui (54)'),
(148,'RuleCriteria',54,'0',20,'','2024-12-01 14:42:31',0,'',''),
(149,'RuleImportAsset',14,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (14)'),
(150,'RuleAction',14,'0',20,'','2024-12-01 14:42:31',0,'',''),
(151,'RuleImportAsset',15,'0',20,'','2024-12-01 14:42:31',0,'',''),
(152,'RuleImportAsset',15,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Ordinateur (55)'),
(153,'RuleCriteria',55,'0',20,'','2024-12-01 14:42:31',0,'',''),
(154,'RuleImportAsset',15,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; UUID est déjà présent Oui (56)'),
(155,'RuleCriteria',56,'0',20,'','2024-12-01 14:42:31',0,'',''),
(156,'RuleImportAsset',15,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; UUID existe Oui (57)'),
(157,'RuleCriteria',57,'0',20,'','2024-12-01 14:42:31',0,'',''),
(158,'RuleImportAsset',15,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (15)'),
(159,'RuleAction',15,'0',20,'','2024-12-01 14:42:31',0,'',''),
(160,'RuleImportAsset',16,'0',20,'','2024-12-01 14:42:31',0,'',''),
(161,'RuleImportAsset',16,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Ordinateur (58)'),
(162,'RuleCriteria',58,'0',20,'','2024-12-01 14:42:31',0,'',''),
(163,'RuleImportAsset',16,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; MAC est déjà présent Oui (59)'),
(164,'RuleCriteria',59,'0',20,'','2024-12-01 14:42:31',0,'',''),
(165,'RuleImportAsset',16,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; MAC existe Oui (60)'),
(166,'RuleCriteria',60,'0',20,'','2024-12-01 14:42:31',0,'',''),
(167,'RuleImportAsset',16,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (16)'),
(168,'RuleAction',16,'0',20,'','2024-12-01 14:42:31',0,'',''),
(169,'RuleImportAsset',17,'0',20,'','2024-12-01 14:42:31',0,'',''),
(170,'RuleImportAsset',17,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Ordinateur (61)'),
(171,'RuleCriteria',61,'0',20,'','2024-12-01 14:42:31',0,'',''),
(172,'RuleImportAsset',17,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Nom est déjà présent Oui (62)'),
(173,'RuleCriteria',62,'0',20,'','2024-12-01 14:42:31',0,'',''),
(174,'RuleImportAsset',17,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Nom existe Oui (63)'),
(175,'RuleCriteria',63,'0',20,'','2024-12-01 14:42:31',0,'',''),
(176,'RuleImportAsset',17,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (17)'),
(177,'RuleAction',17,'0',20,'','2024-12-01 14:42:31',0,'',''),
(178,'RuleImportAsset',18,'0',20,'','2024-12-01 14:42:31',0,'',''),
(179,'RuleImportAsset',18,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Ordinateur (64)'),
(180,'RuleCriteria',64,'0',20,'','2024-12-01 14:42:31',0,'',''),
(181,'RuleImportAsset',18,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série existe Oui (65)'),
(182,'RuleCriteria',65,'0',20,'','2024-12-01 14:42:31',0,'',''),
(183,'RuleImportAsset',18,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (18)'),
(184,'RuleAction',18,'0',20,'','2024-12-01 14:42:31',0,'',''),
(185,'RuleImportAsset',19,'0',20,'','2024-12-01 14:42:31',0,'',''),
(186,'RuleImportAsset',19,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Ordinateur (66)'),
(187,'RuleCriteria',66,'0',20,'','2024-12-01 14:42:31',0,'',''),
(188,'RuleImportAsset',19,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; UUID existe Oui (67)'),
(189,'RuleCriteria',67,'0',20,'','2024-12-01 14:42:31',0,'',''),
(190,'RuleImportAsset',19,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (19)'),
(191,'RuleAction',19,'0',20,'','2024-12-01 14:42:31',0,'',''),
(192,'RuleImportAsset',20,'0',20,'','2024-12-01 14:42:31',0,'',''),
(193,'RuleImportAsset',20,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Ordinateur (68)'),
(194,'RuleCriteria',68,'0',20,'','2024-12-01 14:42:31',0,'',''),
(195,'RuleImportAsset',20,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; MAC existe Oui (69)'),
(196,'RuleCriteria',69,'0',20,'','2024-12-01 14:42:31',0,'',''),
(197,'RuleImportAsset',20,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (20)'),
(198,'RuleAction',20,'0',20,'','2024-12-01 14:42:31',0,'',''),
(199,'RuleImportAsset',21,'0',20,'','2024-12-01 14:42:31',0,'',''),
(200,'RuleImportAsset',21,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Ordinateur (70)'),
(201,'RuleCriteria',70,'0',20,'','2024-12-01 14:42:31',0,'',''),
(202,'RuleImportAsset',21,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Nom existe Oui (71)'),
(203,'RuleCriteria',71,'0',20,'','2024-12-01 14:42:31',0,'',''),
(204,'RuleImportAsset',21,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (21)'),
(205,'RuleAction',21,'0',20,'','2024-12-01 14:42:31',0,'',''),
(206,'RuleImportAsset',22,'0',20,'','2024-12-01 14:42:31',0,'',''),
(207,'RuleImportAsset',22,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Ordinateur (72)'),
(208,'RuleCriteria',72,'0',20,'','2024-12-01 14:42:31',0,'',''),
(209,'RuleImportAsset',22,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Refuser l\'import Assigner Oui (22)'),
(210,'RuleAction',22,'0',20,'','2024-12-01 14:42:31',0,'',''),
(211,'RuleImportAsset',23,'0',20,'','2024-12-01 14:42:31',0,'',''),
(212,'RuleImportAsset',23,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Imprimante (73)'),
(213,'RuleCriteria',73,'0',20,'','2024-12-01 14:42:31',0,'',''),
(214,'RuleImportAsset',23,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Nom n\'existe pas Oui (74)'),
(215,'RuleCriteria',74,'0',20,'','2024-12-01 14:42:31',0,'',''),
(216,'RuleImportAsset',23,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Refuser l\'import Assigner Oui (23)'),
(217,'RuleAction',23,'0',20,'','2024-12-01 14:42:31',0,'',''),
(218,'RuleImportAsset',24,'0',20,'','2024-12-01 14:42:31',0,'',''),
(219,'RuleImportAsset',24,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Imprimante (75)'),
(220,'RuleCriteria',75,'0',20,'','2024-12-01 14:42:31',0,'',''),
(221,'RuleImportAsset',24,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série existe Oui (76)'),
(222,'RuleCriteria',76,'0',20,'','2024-12-01 14:42:31',0,'',''),
(223,'RuleImportAsset',24,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série est déjà présent Oui (77)'),
(224,'RuleCriteria',77,'0',20,'','2024-12-01 14:42:31',0,'',''),
(225,'RuleImportAsset',24,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (24)'),
(226,'RuleAction',24,'0',20,'','2024-12-01 14:42:31',0,'',''),
(227,'RuleImportAsset',25,'0',20,'','2024-12-01 14:42:31',0,'',''),
(228,'RuleImportAsset',25,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Imprimante (78)'),
(229,'RuleCriteria',78,'0',20,'','2024-12-01 14:42:31',0,'',''),
(230,'RuleImportAsset',25,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; MAC existe Oui (79)'),
(231,'RuleCriteria',79,'0',20,'','2024-12-01 14:42:31',0,'',''),
(232,'RuleImportAsset',25,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; MAC est déjà présent Oui (80)'),
(233,'RuleCriteria',80,'0',20,'','2024-12-01 14:42:31',0,'',''),
(234,'RuleImportAsset',25,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (25)'),
(235,'RuleAction',25,'0',20,'','2024-12-01 14:42:31',0,'',''),
(236,'RuleImportAsset',26,'0',20,'','2024-12-01 14:42:31',0,'',''),
(237,'RuleImportAsset',26,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Imprimante (81)'),
(238,'RuleCriteria',81,'0',20,'','2024-12-01 14:42:31',0,'',''),
(239,'RuleImportAsset',26,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série existe Oui (82)'),
(240,'RuleCriteria',82,'0',20,'','2024-12-01 14:42:31',0,'',''),
(241,'RuleImportAsset',26,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (26)'),
(242,'RuleAction',26,'0',20,'','2024-12-01 14:42:31',0,'',''),
(243,'RuleImportAsset',27,'0',20,'','2024-12-01 14:42:31',0,'',''),
(244,'RuleImportAsset',27,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Imprimante (83)'),
(245,'RuleCriteria',83,'0',20,'','2024-12-01 14:42:31',0,'',''),
(246,'RuleImportAsset',27,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; MAC existe Oui (84)'),
(247,'RuleCriteria',84,'0',20,'','2024-12-01 14:42:31',0,'',''),
(248,'RuleImportAsset',27,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (27)'),
(249,'RuleAction',27,'0',20,'','2024-12-01 14:42:31',0,'',''),
(250,'RuleImportAsset',28,'0',20,'','2024-12-01 14:42:31',0,'',''),
(251,'RuleImportAsset',28,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Imprimante (85)'),
(252,'RuleCriteria',85,'0',20,'','2024-12-01 14:42:31',0,'',''),
(253,'RuleImportAsset',28,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Refuser l\'import Assigner Oui (28)'),
(254,'RuleAction',28,'0',20,'','2024-12-01 14:42:31',0,'',''),
(255,'RuleImportAsset',29,'0',20,'','2024-12-01 14:42:31',0,'',''),
(256,'RuleImportAsset',29,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Matériel réseau (86)'),
(257,'RuleCriteria',86,'0',20,'','2024-12-01 14:42:31',0,'',''),
(258,'RuleImportAsset',29,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Nom n\'existe pas Oui (87)'),
(259,'RuleCriteria',87,'0',20,'','2024-12-01 14:42:31',0,'',''),
(260,'RuleImportAsset',29,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Refuser l\'import Assigner Oui (29)'),
(261,'RuleAction',29,'0',20,'','2024-12-01 14:42:31',0,'',''),
(262,'RuleImportAsset',30,'0',20,'','2024-12-01 14:42:31',0,'',''),
(263,'RuleImportAsset',30,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Matériel réseau (88)'),
(264,'RuleCriteria',88,'0',20,'','2024-12-01 14:42:31',0,'',''),
(265,'RuleImportAsset',30,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série existe Oui (89)'),
(266,'RuleCriteria',89,'0',20,'','2024-12-01 14:42:31',0,'',''),
(267,'RuleImportAsset',30,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série est déjà présent Oui (90)'),
(268,'RuleCriteria',90,'0',20,'','2024-12-01 14:42:31',0,'',''),
(269,'RuleImportAsset',30,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (30)'),
(270,'RuleAction',30,'0',20,'','2024-12-01 14:42:31',0,'',''),
(271,'RuleImportAsset',31,'0',20,'','2024-12-01 14:42:31',0,'',''),
(272,'RuleImportAsset',31,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Matériel réseau (91)'),
(273,'RuleCriteria',91,'0',20,'','2024-12-01 14:42:31',0,'',''),
(274,'RuleImportAsset',31,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; MAC existe Oui (92)'),
(275,'RuleCriteria',92,'0',20,'','2024-12-01 14:42:31',0,'',''),
(276,'RuleImportAsset',31,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; MAC est déjà présent Oui (93)'),
(277,'RuleCriteria',93,'0',20,'','2024-12-01 14:42:31',0,'',''),
(278,'RuleImportAsset',31,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (31)'),
(279,'RuleAction',31,'0',20,'','2024-12-01 14:42:31',0,'',''),
(280,'RuleImportAsset',32,'0',20,'','2024-12-01 14:42:31',0,'',''),
(281,'RuleImportAsset',32,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Matériel réseau (94)'),
(282,'RuleCriteria',94,'0',20,'','2024-12-01 14:42:31',0,'',''),
(283,'RuleImportAsset',32,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série existe Oui (95)'),
(284,'RuleCriteria',95,'0',20,'','2024-12-01 14:42:31',0,'',''),
(285,'RuleImportAsset',32,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (32)'),
(286,'RuleAction',32,'0',20,'','2024-12-01 14:42:31',0,'',''),
(287,'RuleImportAsset',33,'0',20,'','2024-12-01 14:42:31',0,'',''),
(288,'RuleImportAsset',33,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Matériel réseau (96)'),
(289,'RuleCriteria',96,'0',20,'','2024-12-01 14:42:31',0,'',''),
(290,'RuleImportAsset',33,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; MAC existe Oui (97)'),
(291,'RuleCriteria',97,'0',20,'','2024-12-01 14:42:31',0,'',''),
(292,'RuleImportAsset',33,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (33)'),
(293,'RuleAction',33,'0',20,'','2024-12-01 14:42:31',0,'',''),
(294,'RuleImportAsset',34,'0',20,'','2024-12-01 14:42:31',0,'',''),
(295,'RuleImportAsset',34,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Matériel réseau (98)'),
(296,'RuleCriteria',98,'0',20,'','2024-12-01 14:42:31',0,'',''),
(297,'RuleImportAsset',34,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Refuser l\'import Assigner Oui (34)'),
(298,'RuleAction',34,'0',20,'','2024-12-01 14:42:31',0,'',''),
(299,'RuleImportAsset',35,'0',20,'','2024-12-01 14:42:31',0,'',''),
(300,'RuleImportAsset',35,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Peripheral (99)'),
(301,'RuleCriteria',99,'0',20,'','2024-12-01 14:42:31',0,'',''),
(302,'RuleImportAsset',35,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série existe Oui (100)'),
(303,'RuleCriteria',100,'0',20,'','2024-12-01 14:42:31',0,'',''),
(304,'RuleImportAsset',35,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série est déjà présent Oui (101)'),
(305,'RuleCriteria',101,'0',20,'','2024-12-01 14:42:31',0,'',''),
(306,'RuleImportAsset',35,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (35)'),
(307,'RuleAction',35,'0',20,'','2024-12-01 14:42:31',0,'',''),
(308,'RuleImportAsset',36,'0',20,'','2024-12-01 14:42:31',0,'',''),
(309,'RuleImportAsset',36,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Peripheral (102)'),
(310,'RuleCriteria',102,'0',20,'','2024-12-01 14:42:31',0,'',''),
(311,'RuleImportAsset',36,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série existe Oui (103)'),
(312,'RuleCriteria',103,'0',20,'','2024-12-01 14:42:31',0,'',''),
(313,'RuleImportAsset',36,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (36)'),
(314,'RuleAction',36,'0',20,'','2024-12-01 14:42:31',0,'',''),
(315,'RuleImportAsset',37,'0',20,'','2024-12-01 14:42:31',0,'',''),
(316,'RuleImportAsset',37,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Peripheral (104)'),
(317,'RuleCriteria',104,'0',20,'','2024-12-01 14:42:31',0,'',''),
(318,'RuleImportAsset',37,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Refuser l\'import Assigner Oui (37)'),
(319,'RuleAction',37,'0',20,'','2024-12-01 14:42:31',0,'',''),
(320,'RuleImportAsset',38,'0',20,'','2024-12-01 14:42:31',0,'',''),
(321,'RuleImportAsset',38,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Moniteur (105)'),
(322,'RuleCriteria',105,'0',20,'','2024-12-01 14:42:31',0,'',''),
(323,'RuleImportAsset',38,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série existe Oui (106)'),
(324,'RuleCriteria',106,'0',20,'','2024-12-01 14:42:31',0,'',''),
(325,'RuleImportAsset',38,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série est déjà présent Oui (107)'),
(326,'RuleCriteria',107,'0',20,'','2024-12-01 14:42:31',0,'',''),
(327,'RuleImportAsset',38,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (38)'),
(328,'RuleAction',38,'0',20,'','2024-12-01 14:42:31',0,'',''),
(329,'RuleImportAsset',39,'0',20,'','2024-12-01 14:42:31',0,'',''),
(330,'RuleImportAsset',39,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Moniteur (108)'),
(331,'RuleCriteria',108,'0',20,'','2024-12-01 14:42:31',0,'',''),
(332,'RuleImportAsset',39,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série existe Oui (109)'),
(333,'RuleCriteria',109,'0',20,'','2024-12-01 14:42:31',0,'',''),
(334,'RuleImportAsset',39,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (39)'),
(335,'RuleAction',39,'0',20,'','2024-12-01 14:42:31',0,'',''),
(336,'RuleImportAsset',40,'0',20,'','2024-12-01 14:42:31',0,'',''),
(337,'RuleImportAsset',40,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Moniteur (110)'),
(338,'RuleCriteria',110,'0',20,'','2024-12-01 14:42:31',0,'',''),
(339,'RuleImportAsset',40,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Refuser l\'import Assigner Oui (40)'),
(340,'RuleAction',40,'0',20,'','2024-12-01 14:42:31',0,'',''),
(341,'RuleImportAsset',41,'0',20,'','2024-12-01 14:42:31',0,'',''),
(342,'RuleImportAsset',41,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Téléphone (111)'),
(343,'RuleCriteria',111,'0',20,'','2024-12-01 14:42:31',0,'',''),
(344,'RuleImportAsset',41,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Nom n\'existe pas Oui (112)'),
(345,'RuleCriteria',112,'0',20,'','2024-12-01 14:42:31',0,'',''),
(346,'RuleImportAsset',41,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Refuser l\'import Assigner Oui (41)'),
(347,'RuleAction',41,'0',20,'','2024-12-01 14:42:31',0,'',''),
(348,'RuleImportAsset',42,'0',20,'','2024-12-01 14:42:31',0,'',''),
(349,'RuleImportAsset',42,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Téléphone (113)'),
(350,'RuleCriteria',113,'0',20,'','2024-12-01 14:42:31',0,'',''),
(351,'RuleImportAsset',42,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série est déjà présent Oui (114)'),
(352,'RuleCriteria',114,'0',20,'','2024-12-01 14:42:31',0,'',''),
(353,'RuleImportAsset',42,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série existe Oui (115)'),
(354,'RuleCriteria',115,'0',20,'','2024-12-01 14:42:31',0,'',''),
(355,'RuleImportAsset',42,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; UUID est déjà présent Oui (116)'),
(356,'RuleCriteria',116,'0',20,'','2024-12-01 14:42:31',0,'',''),
(357,'RuleImportAsset',42,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; UUID existe Oui (117)'),
(358,'RuleCriteria',117,'0',20,'','2024-12-01 14:42:31',0,'',''),
(359,'RuleImportAsset',42,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (42)'),
(360,'RuleAction',42,'0',20,'','2024-12-01 14:42:31',0,'',''),
(361,'RuleImportAsset',43,'0',20,'','2024-12-01 14:42:31',0,'',''),
(362,'RuleImportAsset',43,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Téléphone (118)'),
(363,'RuleCriteria',118,'0',20,'','2024-12-01 14:42:31',0,'',''),
(364,'RuleImportAsset',43,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série est déjà présent Oui (119)'),
(365,'RuleCriteria',119,'0',20,'','2024-12-01 14:42:31',0,'',''),
(366,'RuleImportAsset',43,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série existe Oui (120)'),
(367,'RuleCriteria',120,'0',20,'','2024-12-01 14:42:31',0,'',''),
(368,'RuleImportAsset',43,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; UUID est vide Oui (121)'),
(369,'RuleCriteria',121,'0',20,'','2024-12-01 14:42:31',0,'',''),
(370,'RuleImportAsset',43,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (43)'),
(371,'RuleAction',43,'0',20,'','2024-12-01 14:42:31',0,'',''),
(372,'RuleImportAsset',44,'0',20,'','2024-12-01 14:42:31',0,'',''),
(373,'RuleImportAsset',44,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Téléphone (122)'),
(374,'RuleCriteria',122,'0',20,'','2024-12-01 14:42:31',0,'',''),
(375,'RuleImportAsset',44,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; UUID existe Oui (123)'),
(376,'RuleCriteria',123,'0',20,'','2024-12-01 14:42:31',0,'',''),
(377,'RuleImportAsset',44,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série existe Oui (124)'),
(378,'RuleCriteria',124,'0',20,'','2024-12-01 14:42:31',0,'',''),
(379,'RuleImportAsset',44,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (44)'),
(380,'RuleAction',44,'0',20,'','2024-12-01 14:42:31',0,'',''),
(381,'RuleImportAsset',45,'0',20,'','2024-12-01 14:42:31',0,'',''),
(382,'RuleImportAsset',45,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Téléphone (125)'),
(383,'RuleCriteria',125,'0',20,'','2024-12-01 14:42:31',0,'',''),
(384,'RuleImportAsset',45,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série est déjà présent Oui (126)'),
(385,'RuleCriteria',126,'0',20,'','2024-12-01 14:42:31',0,'',''),
(386,'RuleImportAsset',45,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série existe Oui (127)'),
(387,'RuleCriteria',127,'0',20,'','2024-12-01 14:42:31',0,'',''),
(388,'RuleImportAsset',45,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (45)'),
(389,'RuleAction',45,'0',20,'','2024-12-01 14:42:31',0,'',''),
(390,'RuleImportAsset',46,'0',20,'','2024-12-01 14:42:31',0,'',''),
(391,'RuleImportAsset',46,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Téléphone (128)'),
(392,'RuleCriteria',128,'0',20,'','2024-12-01 14:42:31',0,'',''),
(393,'RuleImportAsset',46,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; UUID est déjà présent Oui (129)'),
(394,'RuleCriteria',129,'0',20,'','2024-12-01 14:42:31',0,'',''),
(395,'RuleImportAsset',46,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; UUID existe Oui (130)'),
(396,'RuleCriteria',130,'0',20,'','2024-12-01 14:42:31',0,'',''),
(397,'RuleImportAsset',46,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (46)'),
(398,'RuleAction',46,'0',20,'','2024-12-01 14:42:31',0,'',''),
(399,'RuleImportAsset',47,'0',20,'','2024-12-01 14:42:31',0,'',''),
(400,'RuleImportAsset',47,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Téléphone (131)'),
(401,'RuleCriteria',131,'0',20,'','2024-12-01 14:42:31',0,'',''),
(402,'RuleImportAsset',47,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; MAC est déjà présent Oui (132)'),
(403,'RuleCriteria',132,'0',20,'','2024-12-01 14:42:31',0,'',''),
(404,'RuleImportAsset',47,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; MAC existe Oui (133)'),
(405,'RuleCriteria',133,'0',20,'','2024-12-01 14:42:31',0,'',''),
(406,'RuleImportAsset',47,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (47)'),
(407,'RuleAction',47,'0',20,'','2024-12-01 14:42:31',0,'',''),
(408,'RuleImportAsset',48,'0',20,'','2024-12-01 14:42:31',0,'',''),
(409,'RuleImportAsset',48,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Téléphone (134)'),
(410,'RuleCriteria',134,'0',20,'','2024-12-01 14:42:31',0,'',''),
(411,'RuleImportAsset',48,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Nom est déjà présent Oui (135)'),
(412,'RuleCriteria',135,'0',20,'','2024-12-01 14:42:31',0,'',''),
(413,'RuleImportAsset',48,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Nom existe Oui (136)'),
(414,'RuleCriteria',136,'0',20,'','2024-12-01 14:42:31',0,'',''),
(415,'RuleImportAsset',48,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (48)'),
(416,'RuleAction',48,'0',20,'','2024-12-01 14:42:31',0,'',''),
(417,'RuleImportAsset',49,'0',20,'','2024-12-01 14:42:31',0,'',''),
(418,'RuleImportAsset',49,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Téléphone (137)'),
(419,'RuleCriteria',137,'0',20,'','2024-12-01 14:42:31',0,'',''),
(420,'RuleImportAsset',49,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série existe Oui (138)'),
(421,'RuleCriteria',138,'0',20,'','2024-12-01 14:42:31',0,'',''),
(422,'RuleImportAsset',49,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (49)'),
(423,'RuleAction',49,'0',20,'','2024-12-01 14:42:31',0,'',''),
(424,'RuleImportAsset',50,'0',20,'','2024-12-01 14:42:31',0,'',''),
(425,'RuleImportAsset',50,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Téléphone (139)'),
(426,'RuleCriteria',139,'0',20,'','2024-12-01 14:42:31',0,'',''),
(427,'RuleImportAsset',50,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; UUID existe Oui (140)'),
(428,'RuleCriteria',140,'0',20,'','2024-12-01 14:42:31',0,'',''),
(429,'RuleImportAsset',50,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (50)'),
(430,'RuleAction',50,'0',20,'','2024-12-01 14:42:31',0,'',''),
(431,'RuleImportAsset',51,'0',20,'','2024-12-01 14:42:31',0,'',''),
(432,'RuleImportAsset',51,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Téléphone (141)'),
(433,'RuleCriteria',141,'0',20,'','2024-12-01 14:42:31',0,'',''),
(434,'RuleImportAsset',51,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; MAC existe Oui (142)'),
(435,'RuleCriteria',142,'0',20,'','2024-12-01 14:42:31',0,'',''),
(436,'RuleImportAsset',51,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (51)'),
(437,'RuleAction',51,'0',20,'','2024-12-01 14:42:31',0,'',''),
(438,'RuleImportAsset',52,'0',20,'','2024-12-01 14:42:31',0,'',''),
(439,'RuleImportAsset',52,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Téléphone (143)'),
(440,'RuleCriteria',143,'0',20,'','2024-12-01 14:42:31',0,'',''),
(441,'RuleImportAsset',52,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Nom existe Oui (144)'),
(442,'RuleCriteria',144,'0',20,'','2024-12-01 14:42:31',0,'',''),
(443,'RuleImportAsset',52,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (52)'),
(444,'RuleAction',52,'0',20,'','2024-12-01 14:42:31',0,'',''),
(445,'RuleImportAsset',53,'0',20,'','2024-12-01 14:42:31',0,'',''),
(446,'RuleImportAsset',53,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Téléphone (145)'),
(447,'RuleCriteria',145,'0',20,'','2024-12-01 14:42:31',0,'',''),
(448,'RuleImportAsset',53,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Refuser l\'import Assigner Oui (53)'),
(449,'RuleAction',53,'0',20,'','2024-12-01 14:42:31',0,'',''),
(450,'RuleImportAsset',54,'0',20,'','2024-12-01 14:42:31',0,'',''),
(451,'RuleImportAsset',54,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Cluster (146)'),
(452,'RuleCriteria',146,'0',20,'','2024-12-01 14:42:31',0,'',''),
(453,'RuleImportAsset',54,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; UUID existe Oui (147)'),
(454,'RuleCriteria',147,'0',20,'','2024-12-01 14:42:31',0,'',''),
(455,'RuleImportAsset',54,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; UUID est déjà présent Oui (148)'),
(456,'RuleCriteria',148,'0',20,'','2024-12-01 14:42:31',0,'',''),
(457,'RuleImportAsset',54,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (54)'),
(458,'RuleAction',54,'0',20,'','2024-12-01 14:42:31',0,'',''),
(459,'RuleImportAsset',55,'0',20,'','2024-12-01 14:42:31',0,'',''),
(460,'RuleImportAsset',55,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Cluster (149)'),
(461,'RuleCriteria',149,'0',20,'','2024-12-01 14:42:31',0,'',''),
(462,'RuleImportAsset',55,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; UUID existe Oui (150)'),
(463,'RuleCriteria',150,'0',20,'','2024-12-01 14:42:31',0,'',''),
(464,'RuleImportAsset',55,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (55)'),
(465,'RuleAction',55,'0',20,'','2024-12-01 14:42:31',0,'',''),
(466,'RuleImportAsset',56,'0',20,'','2024-12-01 14:42:31',0,'',''),
(467,'RuleImportAsset',56,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Cluster (151)'),
(468,'RuleCriteria',151,'0',20,'','2024-12-01 14:42:31',0,'',''),
(469,'RuleImportAsset',56,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Refuser l\'import Assigner Oui (56)'),
(470,'RuleAction',56,'0',20,'','2024-12-01 14:42:31',0,'',''),
(471,'RuleImportAsset',57,'0',20,'','2024-12-01 14:42:31',0,'',''),
(472,'RuleImportAsset',57,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Châssis (152)'),
(473,'RuleCriteria',152,'0',20,'','2024-12-01 14:42:31',0,'',''),
(474,'RuleImportAsset',57,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série existe Oui (153)'),
(475,'RuleCriteria',153,'0',20,'','2024-12-01 14:42:31',0,'',''),
(476,'RuleImportAsset',57,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série est déjà présent Oui (154)'),
(477,'RuleCriteria',154,'0',20,'','2024-12-01 14:42:31',0,'',''),
(478,'RuleImportAsset',57,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (57)'),
(479,'RuleAction',57,'0',20,'','2024-12-01 14:42:31',0,'',''),
(480,'RuleImportAsset',58,'0',20,'','2024-12-01 14:42:31',0,'',''),
(481,'RuleImportAsset',58,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Châssis (155)'),
(482,'RuleCriteria',155,'0',20,'','2024-12-01 14:42:31',0,'',''),
(483,'RuleImportAsset',58,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série existe Oui (156)'),
(484,'RuleCriteria',156,'0',20,'','2024-12-01 14:42:31',0,'',''),
(485,'RuleImportAsset',58,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (58)'),
(486,'RuleAction',58,'0',20,'','2024-12-01 14:42:31',0,'',''),
(487,'RuleImportAsset',59,'0',20,'','2024-12-01 14:42:31',0,'',''),
(488,'RuleImportAsset',59,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Châssis (157)'),
(489,'RuleCriteria',157,'0',20,'','2024-12-01 14:42:31',0,'',''),
(490,'RuleImportAsset',59,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Refuser l\'import Assigner Oui (59)'),
(491,'RuleAction',59,'0',20,'','2024-12-01 14:42:31',0,'',''),
(492,'RuleImportAsset',60,'0',20,'','2024-12-01 14:42:31',0,'',''),
(493,'RuleImportAsset',60,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Nom n\'existe pas Oui (158)'),
(494,'RuleCriteria',158,'0',20,'','2024-12-01 14:42:31',0,'',''),
(495,'RuleImportAsset',60,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Refuser l\'import Assigner Oui (60)'),
(496,'RuleAction',60,'0',20,'','2024-12-01 14:42:31',0,'',''),
(497,'RuleImportAsset',61,'0',20,'','2024-12-01 14:42:31',0,'',''),
(498,'RuleImportAsset',61,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série existe Oui (159)'),
(499,'RuleCriteria',159,'0',20,'','2024-12-01 14:42:31',0,'',''),
(500,'RuleImportAsset',61,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série est déjà présent Oui (160)'),
(501,'RuleCriteria',160,'0',20,'','2024-12-01 14:42:31',0,'',''),
(502,'RuleImportAsset',61,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (61)'),
(503,'RuleAction',61,'0',20,'','2024-12-01 14:42:31',0,'',''),
(504,'RuleImportAsset',62,'0',20,'','2024-12-01 14:42:31',0,'',''),
(505,'RuleImportAsset',62,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; MAC existe Oui (161)'),
(506,'RuleCriteria',161,'0',20,'','2024-12-01 14:42:31',0,'',''),
(507,'RuleImportAsset',62,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; MAC est déjà présent Oui (162)'),
(508,'RuleCriteria',162,'0',20,'','2024-12-01 14:42:31',0,'',''),
(509,'RuleImportAsset',62,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (62)'),
(510,'RuleAction',62,'0',20,'','2024-12-01 14:42:31',0,'',''),
(511,'RuleImportAsset',63,'0',20,'','2024-12-01 14:42:31',0,'',''),
(512,'RuleImportAsset',63,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Numéro de série existe Oui (163)'),
(513,'RuleCriteria',163,'0',20,'','2024-12-01 14:42:31',0,'',''),
(514,'RuleImportAsset',63,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (63)'),
(515,'RuleAction',63,'0',20,'','2024-12-01 14:42:31',0,'',''),
(516,'RuleImportAsset',64,'0',20,'','2024-12-01 14:42:31',0,'',''),
(517,'RuleImportAsset',64,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Port réseau &#62; MAC existe Oui (164)'),
(518,'RuleCriteria',164,'0',20,'','2024-12-01 14:42:31',0,'',''),
(519,'RuleImportAsset',64,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (64)'),
(520,'RuleAction',64,'0',20,'','2024-12-01 14:42:31',0,'',''),
(521,'RuleImportAsset',65,'0',20,'','2024-12-01 14:42:31',0,'',''),
(522,'RuleImportAsset',65,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Aucun itemtype défini (165)'),
(523,'RuleCriteria',165,'0',20,'','2024-12-01 14:42:31',0,'',''),
(524,'RuleImportAsset',65,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Refuser l\'import Assigner Oui (65)'),
(525,'RuleAction',65,'0',20,'','2024-12-01 14:42:31',0,'',''),
(526,'RuleImportAsset',66,'0',20,'','2024-12-01 14:42:31',0,'',''),
(527,'RuleImportAsset',66,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Instance de base de données (166)'),
(528,'RuleCriteria',166,'0',20,'','2024-12-01 14:42:31',0,'',''),
(529,'RuleImportAsset',66,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Nom existe Oui (167)'),
(530,'RuleCriteria',167,'0',20,'','2024-12-01 14:42:31',0,'',''),
(531,'RuleImportAsset',66,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Nom est déjà présent Oui (168)'),
(532,'RuleCriteria',168,'0',20,'','2024-12-01 14:42:31',0,'',''),
(533,'RuleImportAsset',66,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Élément lié est déjà présent Oui (169)'),
(534,'RuleCriteria',169,'0',20,'','2024-12-01 14:42:31',0,'',''),
(535,'RuleImportAsset',66,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (66)'),
(536,'RuleAction',66,'0',20,'','2024-12-01 14:42:31',0,'',''),
(537,'RuleImportAsset',67,'0',20,'','2024-12-01 14:42:31',0,'',''),
(538,'RuleImportAsset',67,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Instance de base de données (170)'),
(539,'RuleCriteria',170,'0',20,'','2024-12-01 14:42:31',0,'',''),
(540,'RuleImportAsset',67,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Nom existe Oui (171)'),
(541,'RuleCriteria',171,'0',20,'','2024-12-01 14:42:31',0,'',''),
(542,'RuleImportAsset',67,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (67)'),
(543,'RuleAction',67,'0',20,'','2024-12-01 14:42:31',0,'',''),
(544,'RuleImportAsset',68,'0',20,'','2024-12-01 14:42:31',0,'',''),
(545,'RuleImportAsset',68,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Instance de base de données (172)'),
(546,'RuleCriteria',172,'0',20,'','2024-12-01 14:42:31',0,'',''),
(547,'RuleImportAsset',68,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Refuser l\'import Assigner Oui (68)'),
(548,'RuleAction',68,'0',20,'','2024-12-01 14:42:31',0,'',''),
(549,'RuleImportAsset',69,'0',20,'','2024-12-01 14:42:31',0,'',''),
(550,'RuleImportAsset',69,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Unmanaged asset (173)'),
(551,'RuleCriteria',173,'0',20,'','2024-12-01 14:42:31',0,'',''),
(552,'RuleImportAsset',69,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Nom existe Oui (174)'),
(553,'RuleCriteria',174,'0',20,'','2024-12-01 14:42:31',0,'',''),
(554,'RuleImportAsset',69,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Nom est déjà présent Oui (175)'),
(555,'RuleCriteria',175,'0',20,'','2024-12-01 14:42:31',0,'',''),
(556,'RuleImportAsset',69,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (69)'),
(557,'RuleAction',69,'0',20,'','2024-12-01 14:42:31',0,'',''),
(558,'RuleImportAsset',70,'0',20,'','2024-12-01 14:42:31',0,'',''),
(559,'RuleImportAsset',70,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Unmanaged asset (176)'),
(560,'RuleCriteria',176,'0',20,'','2024-12-01 14:42:31',0,'',''),
(561,'RuleImportAsset',70,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Nom existe Oui (177)'),
(562,'RuleCriteria',177,'0',20,'','2024-12-01 14:42:31',0,'',''),
(563,'RuleImportAsset',70,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lien vers l\'inventaire Assigner Liaison si possible (70)'),
(564,'RuleAction',70,'0',20,'','2024-12-01 14:42:31',0,'',''),
(565,'RuleImportAsset',71,'0',20,'','2024-12-01 14:42:31',0,'',''),
(566,'RuleImportAsset',71,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Parc &#62; Type d\'élément est Unmanaged asset (178)'),
(567,'RuleCriteria',178,'0',20,'','2024-12-01 14:42:31',0,'',''),
(568,'RuleImportAsset',71,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Refuser l\'import Assigner Oui (71)'),
(569,'RuleAction',71,'0',20,'','2024-12-01 14:42:31',0,'',''),
(570,'Config',1,'',0,'','2024-12-01 14:42:31',1,'initialized_rules_collections []','[\"RuleImportAssetCollection\"]'),
(571,'RuleMailCollector',72,'0',20,'','2024-12-01 14:42:31',0,'',''),
(572,'RuleMailCollector',72,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Entête Subject du courriel expression rationnelle vérifie /.*/ (179)'),
(573,'RuleCriteria',179,'0',20,'','2024-12-01 14:42:31',0,'',''),
(574,'RuleMailCollector',72,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Entité Assigner Entité racine (72)'),
(575,'RuleAction',72,'0',20,'','2024-12-01 14:42:31',0,'',''),
(576,'RuleMailCollector',73,'0',20,'','2024-12-01 14:42:31',0,'',''),
(577,'RuleMailCollector',73,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Entête X-Auto-Response-Suppress du courriel expression rationnelle vérifie /S+/ (180)'),
(578,'RuleCriteria',180,'0',20,'','2024-12-01 14:42:31',0,'',''),
(579,'RuleMailCollector',73,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Refuser le courriel (sans adresse de réponse) Assigner Oui (73)'),
(580,'RuleAction',73,'0',20,'','2024-12-01 14:42:31',0,'',''),
(581,'RuleMailCollector',74,'0',20,'','2024-12-01 14:42:31',0,'',''),
(582,'RuleMailCollector',74,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Entête Auto-Submitted du courriel expression rationnelle vérifie /^(?!.*no).+$/i (181)'),
(583,'RuleCriteria',181,'0',20,'','2024-12-01 14:42:31',0,'',''),
(584,'RuleMailCollector',74,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Refuser le courriel (sans adresse de réponse) Assigner Oui (74)'),
(585,'RuleAction',74,'0',20,'','2024-12-01 14:42:31',0,'',''),
(586,'Config',1,'',0,'','2024-12-01 14:42:31',1,'initialized_rules_collections [\"RuleImportAssetCollection\"]','[\"RuleImportAssetCollection\",\"RuleMailCollectorCollection\"]'),
(587,'RuleRight',75,'0',20,'','2024-12-01 14:42:31',0,'',''),
(588,'RuleRight',75,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Type d\'authentification est Annuaire LDAP : (182)'),
(589,'RuleCriteria',182,'0',20,'','2024-12-01 14:42:31',0,'',''),
(590,'RuleRight',75,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Type d\'authentification est Serveur de messagerie : (183)'),
(591,'RuleCriteria',183,'0',20,'','2024-12-01 14:42:31',0,'',''),
(592,'RuleRight',75,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Entité Assigner Entité racine (75)'),
(593,'RuleAction',75,'0',20,'','2024-12-01 14:42:31',0,'',''),
(594,'Config',1,'',0,'','2024-12-01 14:42:31',1,'initialized_rules_collections [\"RuleImportAssetCollection\",\"RuleMailCollectorCollection\"]','[\"RuleImportAssetCollection\",\"RuleMailCollectorCollection\",\"RuleRightCollection\"]'),
(595,'RuleSoftwareCategory',76,'0',20,'','2024-12-01 14:42:31',0,'',''),
(596,'RuleSoftwareCategory',76,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Logiciels est * (184)'),
(597,'RuleCriteria',184,'0',20,'','2024-12-01 14:42:31',0,'',''),
(598,'RuleSoftwareCategory',76,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Importer les catégories depuis l\'outil d\'inventaire Assigner Oui (76)'),
(599,'RuleAction',76,'0',20,'','2024-12-01 14:42:31',0,'',''),
(600,'Config',1,'',0,'','2024-12-01 14:42:31',1,'initialized_rules_collections [\"RuleImportAssetCollection\",\"RuleMailCollectorCollection\",\"RuleRightCollection\"]','[\"RuleImportAssetCollection\",\"RuleMailCollectorCollection\",\"RuleRightCollection\",\"RuleSoftwareCategoryCollection\"]'),
(601,'RuleTicket',77,'0',20,'','2024-12-01 14:42:31',0,'',''),
(602,'RuleTicket',77,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Lieu du ticket n\'existe pas Oui (185)'),
(603,'RuleCriteria',185,'0',20,'','2024-12-01 14:42:31',0,'',''),
(604,'RuleTicket',77,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Lieu de l\'élément existe Oui (186)'),
(605,'RuleCriteria',186,'0',20,'','2024-12-01 14:42:31',0,'',''),
(606,'RuleTicket',77,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lieu Copier depuis l\'élément Oui (77)'),
(607,'RuleAction',77,'0',20,'','2024-12-01 14:42:31',0,'',''),
(608,'RuleTicket',78,'0',20,'','2024-12-01 14:42:31',0,'',''),
(609,'RuleTicket',78,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Lieu du ticket n\'existe pas Oui (187)'),
(610,'RuleCriteria',187,'0',20,'','2024-12-01 14:42:31',0,'',''),
(611,'RuleTicket',78,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Lieu du demandeur existe Oui (188)'),
(612,'RuleCriteria',188,'0',20,'','2024-12-01 14:42:31',0,'',''),
(613,'RuleTicket',78,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Lieu Copier depuis l\'utilisateur Oui (78)'),
(614,'RuleAction',78,'0',20,'','2024-12-01 14:42:31',0,'',''),
(615,'Config',1,'',0,'','2024-12-01 14:42:31',1,'initialized_rules_collections [\"RuleImportAssetCollection\",\"RuleMailCollectorCollection\",\"RuleRightCollection\",\"RuleSoftwareCategoryCollection\"]','[\"RuleImportAssetCollection\",\"RuleMailCollectorCollection\",\"RuleRightCollection\",\"RuleSoftwareCategoryCollection\",\"RuleTicketCollection\"]'),
(616,'RuleAsset',79,'0',20,'','2024-12-01 14:42:31',0,'',''),
(617,'RuleAsset',79,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Type d\'élément est Ordinateur (189)'),
(618,'RuleCriteria',189,'0',20,'','2024-12-01 14:42:31',0,'',''),
(619,'RuleAsset',79,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Inventaire automatique est Oui (190)'),
(620,'RuleCriteria',190,'0',20,'','2024-12-01 14:42:31',0,'',''),
(621,'RuleAsset',79,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Usager expression rationnelle vérifie /(.*)@/ (191)'),
(622,'RuleCriteria',191,'0',20,'','2024-12-01 14:42:31',0,'',''),
(623,'RuleAsset',79,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Informations de contact basées sur l\'utilisateur Assigner valeur depuis l\'expression régulière #0 (79)'),
(624,'RuleAction',79,'0',20,'','2024-12-01 14:42:31',0,'',''),
(625,'RuleAsset',80,'0',20,'','2024-12-01 14:42:31',0,'',''),
(626,'RuleAsset',80,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Type d\'élément est Ordinateur (192)'),
(627,'RuleCriteria',192,'0',20,'','2024-12-01 14:42:31',0,'',''),
(628,'RuleAsset',80,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Inventaire automatique est Oui (193)'),
(629,'RuleCriteria',193,'0',20,'','2024-12-01 14:42:31',0,'',''),
(630,'RuleAsset',80,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Usager expression rationnelle vérifie /(.*)[,|/]/ (194)'),
(631,'RuleCriteria',194,'0',20,'','2024-12-01 14:42:31',0,'',''),
(632,'RuleAsset',80,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Informations de contact basées sur l\'utilisateur Assigner valeur depuis l\'expression régulière #0 (80)'),
(633,'RuleAction',80,'0',20,'','2024-12-01 14:42:31',0,'',''),
(634,'RuleAsset',81,'0',20,'','2024-12-01 14:42:31',0,'',''),
(635,'RuleAsset',81,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Type d\'élément est Ordinateur (195)'),
(636,'RuleCriteria',195,'0',20,'','2024-12-01 14:42:31',0,'',''),
(637,'RuleAsset',81,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Inventaire automatique est Oui (196)'),
(638,'RuleCriteria',196,'0',20,'','2024-12-01 14:42:31',0,'',''),
(639,'RuleAsset',81,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Usager expression rationnelle vérifie /(.*)/ (197)'),
(640,'RuleCriteria',197,'0',20,'','2024-12-01 14:42:31',0,'',''),
(641,'RuleAsset',81,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Informations de contact basées sur l\'utilisateur Assigner valeur depuis l\'expression régulière #0 (81)'),
(642,'RuleAction',81,'0',20,'','2024-12-01 14:42:31',0,'',''),
(643,'Config',1,'',0,'','2024-12-01 14:42:31',1,'initialized_rules_collections [\"RuleImportAssetCollection\",\"RuleMailCollectorCollection\",\"RuleRightCollection\",\"RuleSoftwareCategoryCollection\",\"RuleTicketCollection\"]','[\"RuleImportAssetCollection\",\"RuleMailCollectorCollection\",\"RuleRightCollection\",\"RuleSoftwareCategoryCollection\",\"RuleTicketCollection\",\"RuleAssetCollection\"]'),
(644,'RuleDictionnaryOperatingSystem',82,'0',20,'','2024-12-01 14:42:31',0,'',''),
(645,'RuleDictionnaryOperatingSystem',82,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Indisponible expression rationnelle vérifie /(SUSE|SunOS|Red Hat|CentOS|Ubuntu|Debian|Fedora|AlmaLinux|Oracle|Amazon Linux)(?:D+|)([d.]*) ?(?:(?([w ]+))?)?/ (198)'),
(646,'RuleCriteria',198,'0',20,'','2024-12-01 14:42:31',0,'',''),
(647,'RuleDictionnaryOperatingSystem',82,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Système d\'exploitation Ajouter le résultat de l\'expression régulière #0 (82)'),
(648,'RuleAction',82,'0',20,'','2024-12-01 14:42:31',0,'',''),
(649,'RuleDictionnaryOperatingSystem',83,'0',20,'','2024-12-01 14:42:31',0,'',''),
(650,'RuleDictionnaryOperatingSystem',83,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Indisponible expression rationnelle vérifie /(Microsoft)(?&#62;(R)|®)? (Windows) (XP|d.d|d{1,4}|Vista)(™)? ?(.*)/ (199)'),
(651,'RuleCriteria',199,'0',20,'','2024-12-01 14:42:31',0,'',''),
(652,'RuleDictionnaryOperatingSystem',83,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Système d\'exploitation Ajouter le résultat de l\'expression régulière #1 (83)'),
(653,'RuleAction',83,'0',20,'','2024-12-01 14:42:31',0,'',''),
(654,'RuleDictionnaryOperatingSystem',84,'0',20,'','2024-12-01 14:42:31',0,'',''),
(655,'RuleDictionnaryOperatingSystem',84,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Indisponible expression rationnelle vérifie /(Microsoft)(?&#62;(R)|®)? (?:(Hyper-V|Windows)(?:(R))?) ((?:Server|))(?:(R)|®)? (d{4}(?: R2)?)(?:[,s]++)?([^s]*)(?: Edition(?: x64)?)?$'),
(656,'RuleCriteria',200,'0',20,'','2024-12-01 14:42:31',0,'',''),
(657,'RuleDictionnaryOperatingSystem',84,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Système d\'exploitation Ajouter le résultat de l\'expression régulière #1 #2 (84)'),
(658,'RuleAction',84,'0',20,'','2024-12-01 14:42:31',0,'',''),
(659,'Config',1,'',0,'','2024-12-01 14:42:31',1,'initialized_rules_collections [\"RuleImportAssetCollection\",\"RuleMailCollectorCollection\",\"RuleRightCollection\",\"RuleSoftwareCategoryCollection\",\"RuleTicketCollection\",\"RuleAssetCol','[\"RuleImportAssetCollection\",\"RuleMailCollectorCollection\",\"RuleRightCollection\",\"RuleSoftwareCategoryCollection\",\"RuleTicketCollection\",\"RuleAssetCollection\",\"RuleDictionnaryOpera'),
(660,'RuleDictionnaryOperatingSystemVersion',85,'0',20,'','2024-12-01 14:42:31',0,'',''),
(661,'RuleDictionnaryOperatingSystemVersion',85,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Système d\'exploitation expression rationnelle vérifie /(SUSE|SunOS|Red Hat|CentOS|Ubuntu|Debian|Fedora|AlmaLinux|Oracle)(?:D+|)([d.]+) ?(?:(?([w ]+))?)?/ (201)'),
(662,'RuleCriteria',201,'0',20,'','2024-12-01 14:42:31',0,'',''),
(663,'RuleDictionnaryOperatingSystemVersion',85,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Version Ajouter le résultat de l\'expression régulière #1 (85)'),
(664,'RuleAction',85,'0',20,'','2024-12-01 14:42:31',0,'',''),
(665,'RuleDictionnaryOperatingSystemVersion',86,'0',20,'','2024-12-01 14:42:31',0,'',''),
(666,'RuleDictionnaryOperatingSystemVersion',86,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Système d\'exploitation expression rationnelle vérifie /(Microsoft)(?&#62;(R)|®)? (Windows) (XP|d.d|d{1,4}|Vista)(™)? ?(.*)/ (202)'),
(667,'RuleCriteria',202,'0',20,'','2024-12-01 14:42:31',0,'',''),
(668,'RuleDictionnaryOperatingSystemVersion',86,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Version Ajouter le résultat de l\'expression régulière #2 (86)'),
(669,'RuleAction',86,'0',20,'','2024-12-01 14:42:31',0,'',''),
(670,'RuleDictionnaryOperatingSystemVersion',87,'0',20,'','2024-12-01 14:42:31',0,'',''),
(671,'RuleDictionnaryOperatingSystemVersion',87,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Système d\'exploitation expression rationnelle vérifie /(Microsoft)(?&#62;(R)|®)? (?:(Hyper-V|Windows)(?:(R))?) ((?:Server|))(?:(R)|®)? (d{4}(?: R2)?)(?:[,s]++)?([^s]*)(?: Edition(?'),
(672,'RuleCriteria',203,'0',20,'','2024-12-01 14:42:31',0,'',''),
(673,'RuleDictionnaryOperatingSystemVersion',87,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Version Ajouter le résultat de l\'expression régulière #3 (87)'),
(674,'RuleAction',87,'0',20,'','2024-12-01 14:42:31',0,'',''),
(675,'Config',1,'',0,'','2024-12-01 14:42:31',1,'initialized_rules_collections [\"RuleImportAssetCollection\",\"RuleMailCollectorCollection\",\"RuleRightCollection\",\"RuleSoftwareCategoryCollection\",\"RuleTicketCollection\",\"RuleAssetCol','[\"RuleImportAssetCollection\",\"RuleMailCollectorCollection\",\"RuleRightCollection\",\"RuleSoftwareCategoryCollection\",\"RuleTicketCollection\",\"RuleAssetCollection\",\"RuleDictionnaryOpera'),
(676,'RuleDictionnaryOperatingSystemEdition',88,'0',20,'','2024-12-01 14:42:31',0,'',''),
(677,'RuleDictionnaryOperatingSystemEdition',88,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Système d\'exploitation expression rationnelle vérifie /(SUSE|SunOS|Red Hat|CentOS|Ubuntu|Debian|Fedora|AlmaLinux|Oracle)(?:D+|)([d.]+) ?(?:(?([w ]+))?)?/ (204)'),
(678,'RuleCriteria',204,'0',20,'','2024-12-01 14:42:31',0,'',''),
(679,'RuleDictionnaryOperatingSystemEdition',88,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Édition Ajouter le résultat de l\'expression régulière #2 (88)'),
(680,'RuleAction',88,'0',20,'','2024-12-01 14:42:31',0,'',''),
(681,'RuleDictionnaryOperatingSystemEdition',89,'0',20,'','2024-12-01 14:42:31',0,'',''),
(682,'RuleDictionnaryOperatingSystemEdition',89,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Système d\'exploitation expression rationnelle vérifie /(Microsoft)(?&#62;(R)|®)? (Windows) (XP|d.d|d{1,4}|Vista)(™)? ?(.*)/ (205)'),
(683,'RuleCriteria',205,'0',20,'','2024-12-01 14:42:31',0,'',''),
(684,'RuleDictionnaryOperatingSystemEdition',89,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Édition Ajouter le résultat de l\'expression régulière #4 (89)'),
(685,'RuleAction',89,'0',20,'','2024-12-01 14:42:31',0,'',''),
(686,'RuleDictionnaryOperatingSystemEdition',90,'0',20,'','2024-12-01 14:42:31',0,'',''),
(687,'RuleDictionnaryOperatingSystemEdition',90,'RuleCriteria',17,'','2024-12-01 14:42:31',0,'','Système d\'exploitation expression rationnelle vérifie /(Microsoft)(?&#62;(R)|®)? (?:(Hyper-V|Windows)(?:(R))?) ((?:Server|))(?:(R)|®)? (d{4}(?: R2)?)(?:[,s]++)?([^s]*)(?: Edition(?'),
(688,'RuleCriteria',206,'0',20,'','2024-12-01 14:42:31',0,'',''),
(689,'RuleDictionnaryOperatingSystemEdition',90,'RuleAction',17,'','2024-12-01 14:42:31',0,'','Édition Ajouter le résultat de l\'expression régulière #4 (90)'),
(690,'RuleAction',90,'0',20,'','2024-12-01 14:42:31',0,'',''),
(691,'Config',1,'',0,'','2024-12-01 14:42:31',1,'initialized_rules_collections [\"RuleImportAssetCollection\",\"RuleMailCollectorCollection\",\"RuleRightCollection\",\"RuleSoftwareCategoryCollection\",\"RuleTicketCollection\",\"RuleAssetCol','{...}'),
(692,'Config',1,'',0,'','2024-12-01 14:42:31',1,'language en_GB','fr_FR'),
(693,'Config',1,'',0,'','2024-12-01 14:42:31',1,'version FILLED AT INSTALL','10.0.17'),
(694,'Config',1,'',0,'','2024-12-01 14:42:31',1,'dbversion FILLED AT INSTALL','10.0.17@bde16719fbd4112f59a9a7d34c66c959bce73434'),
(695,'Config',1,'',0,'','2024-12-01 14:42:36',1,'registration_uuid ','g2JZfgYrt8ZKlVYZlEyRWPH3plDkKizV519yjvWm'),
(696,'Group',1,'0',20,'glpi (2)','2024-12-02 11:48:12',0,'',''),
(697,'Group',2,'0',20,'glpi (2)','2024-12-02 11:48:32',0,'',''),
(698,'Group',3,'0',20,'glpi (2)','2024-12-02 11:48:41',0,'',''),
(699,'Group',4,'0',20,'glpi (2)','2024-12-02 11:48:49',0,'',''),
(700,'Group',5,'0',20,'glpi (2)','2024-12-02 11:49:12',0,'',''),
(701,'Group',6,'0',20,'glpi (2)','2024-12-02 11:49:47',0,'',''),
(702,'User',7,'Profile',17,'glpi (2)','2024-12-02 11:51:40',0,'','Entité racine (0), Self-Service (1)'),
(703,'Profile',1,'User',17,'glpi (2)','2024-12-02 11:51:40',0,'','raphael (7), Entité racine (0)'),
(704,'Entity',0,'User',17,'glpi (2)','2024-12-02 11:51:40',0,'','raphael (7), Self-Service (1)'),
(705,'User',7,'0',20,'glpi (2)','2024-12-02 11:51:40',0,'',''),
(706,'User',7,'Group',15,'glpi (2)','2024-12-02 11:51:52',0,'','Comptabilité (1)'),
(707,'Group',1,'User',15,'glpi (2)','2024-12-02 11:51:52',0,'','raphael (7)'),
(708,'User',7,'Group',16,'glpi (2)','2024-12-02 11:52:04',0,'Comptabilité (1)',''),
(709,'Group',1,'User',16,'glpi (2)','2024-12-02 11:52:04',0,'raphael (7)',''),
(710,'User',7,'Group',15,'glpi (2)','2024-12-02 11:52:10',0,'','Comptabilité (1)'),
(711,'Group',1,'User',15,'glpi (2)','2024-12-02 11:52:10',0,'','raphael (7)'),
(712,'User',8,'Profile',17,'glpi (2)','2024-12-02 11:52:26',0,'','Entité racine (0), Self-Service (1)'),
(713,'Profile',1,'User',17,'glpi (2)','2024-12-02 11:52:26',0,'','charly (8), Entité racine (0)'),
(714,'Entity',0,'User',17,'glpi (2)','2024-12-02 11:52:26',0,'','charly (8), Self-Service (1)'),
(715,'User',8,'0',20,'glpi (2)','2024-12-02 11:52:26',0,'',''),
(716,'User',9,'Profile',17,'glpi (2)','2024-12-02 11:52:33',0,'','Entité racine (0), Self-Service (1)'),
(717,'Profile',1,'User',17,'glpi (2)','2024-12-02 11:52:33',0,'','edouard (9), Entité racine (0)'),
(718,'Entity',0,'User',17,'glpi (2)','2024-12-02 11:52:33',0,'','edouard (9), Self-Service (1)'),
(719,'User',9,'0',20,'glpi (2)','2024-12-02 11:52:33',0,'',''),
(720,'User',10,'Profile',17,'glpi (2)','2024-12-02 11:52:42',0,'','Entité racine (0), Self-Service (1)'),
(721,'Profile',1,'User',17,'glpi (2)','2024-12-02 11:52:42',0,'','philippe (10), Entité racine (0)'),
(722,'Entity',0,'User',17,'glpi (2)','2024-12-02 11:52:42',0,'','philippe (10), Self-Service (1)'),
(723,'User',10,'0',20,'glpi (2)','2024-12-02 11:52:42',0,'',''),
(724,'User',11,'Profile',17,'glpi (2)','2024-12-02 11:52:47',0,'','Entité racine (0), Self-Service (1)'),
(725,'Profile',1,'User',17,'glpi (2)','2024-12-02 11:52:47',0,'','elise (11), Entité racine (0)'),
(726,'Entity',0,'User',17,'glpi (2)','2024-12-02 11:52:47',0,'','elise (11), Self-Service (1)'),
(727,'User',11,'0',20,'glpi (2)','2024-12-02 11:52:47',0,'',''),
(728,'User',12,'Profile',17,'glpi (2)','2024-12-02 11:52:54',0,'','Entité racine (0), Self-Service (1)'),
(729,'Profile',1,'User',17,'glpi (2)','2024-12-02 11:52:54',0,'','marina (12), Entité racine (0)'),
(730,'Entity',0,'User',17,'glpi (2)','2024-12-02 11:52:54',0,'','marina (12), Self-Service (1)'),
(731,'User',12,'0',20,'glpi (2)','2024-12-02 11:52:54',0,'',''),
(732,'User',13,'Profile',17,'glpi (2)','2024-12-02 11:53:01',0,'','Entité racine (0), Self-Service (1)'),
(733,'Profile',1,'User',17,'glpi (2)','2024-12-02 11:53:01',0,'','karim (13), Entité racine (0)'),
(734,'Entity',0,'User',17,'glpi (2)','2024-12-02 11:53:01',0,'','karim (13), Self-Service (1)'),
(735,'User',13,'0',20,'glpi (2)','2024-12-02 11:53:01',0,'',''),
(736,'User',14,'Profile',17,'glpi (2)','2024-12-02 11:53:09',0,'','Entité racine (0), Self-Service (1)'),
(737,'Profile',1,'User',17,'glpi (2)','2024-12-02 11:53:09',0,'','guillaume (14), Entité racine (0)'),
(738,'Entity',0,'User',17,'glpi (2)','2024-12-02 11:53:09',0,'','guillaume (14), Self-Service (1)'),
(739,'User',14,'0',20,'glpi (2)','2024-12-02 11:53:09',0,'',''),
(740,'User',15,'Profile',17,'glpi (2)','2024-12-02 11:53:42',0,'','Entité racine (0), Self-Service (1)'),
(741,'Profile',1,'User',17,'glpi (2)','2024-12-02 11:53:42',0,'','samuel (15), Entité racine (0)'),
(742,'Entity',0,'User',17,'glpi (2)','2024-12-02 11:53:42',0,'','samuel (15), Self-Service (1)'),
(743,'User',15,'0',20,'glpi (2)','2024-12-02 11:53:42',0,'',''),
(744,'User',8,'Group',15,'glpi (2)','2024-12-02 11:55:28',0,'','Comptabilité (1)'),
(745,'Group',1,'User',15,'glpi (2)','2024-12-02 11:55:28',0,'','charly (8)'),
(746,'User',9,'Group',15,'glpi (2)','2024-12-02 11:55:51',0,'','Développement (2)'),
(747,'Group',2,'User',15,'glpi (2)','2024-12-02 11:55:51',0,'','edouard (9)'),
(748,'User',10,'Group',15,'glpi (2)','2024-12-02 11:56:06',0,'','Commercial (3)'),
(749,'Group',3,'User',15,'glpi (2)','2024-12-02 11:56:06',0,'','philippe (10)'),
(750,'User',11,'Group',15,'glpi (2)','2024-12-02 11:56:16',0,'','Commercial (3)'),
(751,'Group',3,'User',15,'glpi (2)','2024-12-02 11:56:16',0,'','elise (11)'),
(752,'User',12,'Group',15,'glpi (2)','2024-12-02 11:56:27',0,'','Sysadmin (6)'),
(753,'Group',6,'User',15,'glpi (2)','2024-12-02 11:56:27',0,'','marina (12)'),
(754,'User',13,'Group',15,'glpi (2)','2024-12-02 11:56:39',0,'','Hardware (5)'),
(755,'Group',5,'User',15,'glpi (2)','2024-12-02 11:56:39',0,'','karim (13)'),
(756,'Group',7,'0',20,'glpi (2)','2024-12-02 11:57:03',0,'',''),
(757,'User',14,'Group',15,'glpi (2)','2024-12-02 11:57:19',0,'','Direction (7)'),
(758,'Group',7,'User',15,'glpi (2)','2024-12-02 11:57:19',0,'','guillaume (14)'),
(759,'User',14,'Profile',17,'glpi (2)','2024-12-02 11:57:30',0,'','Entité racine (0), Super-Admin (4)'),
(760,'Profile',4,'User',17,'glpi (2)','2024-12-02 11:57:30',0,'','guillaume (14), Entité racine (0)'),
(761,'Entity',0,'User',17,'glpi (2)','2024-12-02 11:57:30',0,'','guillaume (14), Super-Admin (4)'),
(762,'User',14,'Profile',19,'glpi (2)','2024-12-02 11:57:42',0,'Entité racine (0), Super-Admin (4)',''),
(763,'Profile',4,'User',19,'glpi (2)','2024-12-02 11:57:42',0,'guillaume (14), Entité racine (0)',''),
(764,'Entity',0,'User',19,'glpi (2)','2024-12-02 11:57:42',0,'guillaume (14), Super-Admin (4)',''),
(765,'User',14,'Profile',17,'glpi (2)','2024-12-02 11:57:53',0,'','Entité racine (0), Super-Admin (4)'),
(766,'Profile',4,'User',17,'glpi (2)','2024-12-02 11:57:53',0,'','guillaume (14), Entité racine (0)'),
(767,'Entity',0,'User',17,'glpi (2)','2024-12-02 11:57:53',0,'','guillaume (14), Super-Admin (4)'),
(768,'User',14,'Profile',19,'glpi (2)','2024-12-02 11:57:59',0,'Entité racine (0), Self-Service (1)',''),
(769,'Profile',1,'User',19,'glpi (2)','2024-12-02 11:57:59',0,'guillaume (14), Entité racine (0)',''),
(770,'Entity',0,'User',19,'glpi (2)','2024-12-02 11:57:59',0,'guillaume (14), Self-Service (1)',''),
(771,'User',15,'Group',15,'glpi (2)','2024-12-02 11:58:14',0,'','Marketing (4)'),
(772,'Group',4,'User',15,'glpi (2)','2024-12-02 11:58:14',0,'','samuel (15)'),
(773,'Config',1,'',0,'glpi (2)','2024-12-02 17:57:02',1,'marketplace_replace_plugins ','2'),
(774,'User',14,'Group',16,'glpi (2)','2024-12-02 18:27:01',0,'Direction (7)',''),
(775,'Group',7,'User',16,'glpi (2)','2024-12-02 18:27:01',0,'guillaume (14)',''),
(776,'User',14,'Group',15,'glpi (2)','2024-12-02 18:27:11',0,'','Direction (7)'),
(777,'Group',7,'User',15,'glpi (2)','2024-12-02 18:27:11',0,'','guillaume (14)'),
(778,'User',14,'Profile',19,'glpi (2)','2024-12-02 18:28:05',0,'Entité racine (0), Super-Admin (4)',''),
(779,'Profile',4,'User',19,'glpi (2)','2024-12-02 18:28:05',0,'guillaume (14), Entité racine (0)',''),
(780,'Entity',0,'User',19,'glpi (2)','2024-12-02 18:28:05',0,'guillaume (14), Super-Admin (4)',''),
(781,'User',14,'Profile',17,'glpi (2)','2024-12-02 18:28:18',0,'','Entité racine (0), Self-Service (1)'),
(782,'Profile',1,'User',17,'glpi (2)','2024-12-02 18:28:18',0,'','guillaume (14), Entité racine (0)'),
(783,'Entity',0,'User',17,'glpi (2)','2024-12-02 18:28:18',0,'','guillaume (14), Self-Service (1)'),
(784,'User',12,'Profile',19,'glpi (2)','2024-12-02 18:40:22',0,'Entité racine (0), Self-Service (1)',''),
(785,'Profile',1,'User',19,'glpi (2)','2024-12-02 18:40:22',0,'marina (12), Entité racine (0)',''),
(786,'Entity',0,'User',19,'glpi (2)','2024-12-02 18:40:22',0,'marina (12), Self-Service (1)',''),
(787,'User',12,'Profile',17,'glpi (2)','2024-12-02 18:40:29',0,'','Entité racine (0), Admin (3)'),
(788,'Profile',3,'User',17,'glpi (2)','2024-12-02 18:40:29',0,'','marina (12), Entité racine (0)'),
(789,'Entity',0,'User',17,'glpi (2)','2024-12-02 18:40:29',0,'','marina (12), Admin (3)'),
(790,'User',16,'Profile',17,'glpi (2)','2024-12-02 18:40:46',0,'','Entité racine (0), Admin (3)'),
(791,'Profile',3,'User',17,'glpi (2)','2024-12-02 18:40:46',0,'','mael (16), Entité racine (0)'),
(792,'Entity',0,'User',17,'glpi (2)','2024-12-02 18:40:46',0,'','mael (16), Admin (3)'),
(793,'User',16,'0',20,'glpi (2)','2024-12-02 18:40:46',0,'',''),
(794,'User',16,'Group',15,'glpi (2)','2024-12-02 18:41:01',0,'','Sysadmin (6)'),
(795,'Group',6,'User',15,'glpi (2)','2024-12-02 18:41:01',0,'','mael (16)'),
(806,'ITILCategory',6,'0',20,'glpi (2)','2024-12-06 10:24:26',0,'',''),
(807,'ITILCategory',7,'0',20,'glpi (2)','2024-12-06 10:24:38',0,'',''),
(812,'ITILCategory',6,'ITILCategory',17,'glpi (2)','2024-12-06 10:26:54',0,'','Problème d\'accès utilisateur (12)'),
(814,'ITILCategory',6,'ITILCategory',17,'glpi (2)','2024-12-06 10:27:00',0,'','Défaillance matérielle ou infrastructure (13)'),
(816,'ITILCategory',6,'ITILCategory',17,'glpi (2)','2024-12-06 10:27:08',0,'','Défaillance d’application ou logiciel (14)'),
(818,'ITILCategory',6,'ITILCategory',19,'glpi (2)','2024-12-06 10:31:19',0,'Problème d\'accès utilisateur (12)',''),
(819,'ITILCategory',6,'ITILCategory',19,'glpi (2)','2024-12-06 10:31:19',0,'Défaillance matérielle ou infrastructure (13)',''),
(820,'ITILCategory',6,'ITILCategory',19,'glpi (2)','2024-12-06 10:31:19',0,'Défaillance d’application ou logiciel (14)',''),
(821,'ITILCategory',7,'ITILCategory',17,'glpi (2)','2024-12-06 10:31:44',0,'','Logiciel (15)'),
(822,'ITILCategory',15,'0',20,'glpi (2)','2024-12-06 10:31:44',0,'',''),
(823,'ITILCategory',15,'ITILCategory',17,'glpi (2)','2024-12-06 10:31:56',0,'','Comptabilité (16)'),
(824,'ITILCategory',16,'0',20,'glpi (2)','2024-12-06 10:31:56',0,'',''),
(825,'ITILCategory',7,'ITILCategory',17,'glpi (2)','2024-12-06 10:32:13',0,'','Réseau (17)'),
(826,'ITILCategory',17,'0',20,'glpi (2)','2024-12-06 10:32:13',0,'',''),
(827,'ITILCategory',7,'ITILCategory',17,'glpi (2)','2024-12-06 10:32:18',0,'','Matériel (18)'),
(828,'ITILCategory',18,'0',20,'glpi (2)','2024-12-06 10:32:18',0,'',''),
(829,'ITILCategory',17,'ITILCategory',17,'glpi (2)','2024-12-06 10:32:28',0,'','VPN (19)'),
(830,'ITILCategory',19,'0',20,'glpi (2)','2024-12-06 10:32:28',0,'',''),
(831,'ITILCategory',18,'ITILCategory',17,'glpi (2)','2024-12-06 10:32:48',0,'','Stock (20)'),
(832,'ITILCategory',20,'0',20,'glpi (2)','2024-12-06 10:32:48',0,'',''),
(833,'ITILCategory',6,'ITILCategory',17,'glpi (2)','2024-12-06 10:33:03',0,'','Comptes utilisateurs (21)'),
(834,'ITILCategory',21,'0',20,'glpi (2)','2024-12-06 10:33:03',0,'',''),
(835,'ITILCategory',6,'ITILCategory',17,'glpi (2)','2024-12-06 10:33:07',0,'','Climatisation (22)'),
(836,'ITILCategory',22,'0',20,'glpi (2)','2024-12-06 10:33:07',0,'',''),
(837,'ITILCategory',6,'ITILCategory',17,'glpi (2)','2024-12-06 10:33:29',0,'','Sécurité (23)'),
(838,'ITILCategory',23,'0',20,'glpi (2)','2024-12-06 10:33:29',0,'',''),
(839,'ITILCategory',21,'ITILCategory',17,'glpi (2)','2024-12-06 10:33:41',0,'','Active Directory (24)'),
(840,'ITILCategory',24,'0',20,'glpi (2)','2024-12-06 10:33:41',0,'',''),
(841,'ITILCategory',22,'ITILCategory',17,'glpi (2)','2024-12-06 10:33:52',0,'','Salle serveur (25)'),
(842,'ITILCategory',25,'0',20,'glpi (2)','2024-12-06 10:33:52',0,'',''),
(843,'ITILCategory',23,'ITILCategory',17,'glpi (2)','2024-12-06 10:34:05',0,'','Infection présumée (26)'),
(844,'ITILCategory',26,'0',20,'glpi (2)','2024-12-06 10:34:05',0,'',''),
(845,'ITILCategory',17,'ITILCategory',17,'glpi (2)','2024-12-06 10:37:00',0,'','Accès (27)'),
(850,'ITILCategory',17,'ITILCategory',19,'glpi (2)','2024-12-06 10:40:08',0,'Accès (27)',''),
(851,'ITILCategory',29,'0',20,'glpi (2)','2024-12-06 10:40:18',0,'',''),
(852,'ITILCategory',29,'ITILCategory',17,'glpi (2)','2024-12-06 10:40:33',0,'','Serveur (30)'),
(853,'ITILCategory',30,'0',20,'glpi (2)','2024-12-06 10:40:33',0,'',''),
(854,'ITILCategory',30,'ITILCategory',17,'glpi (2)','2024-12-06 10:40:40',0,'','Logs d\'application (31)'),
(855,'ITILCategory',31,'0',20,'glpi (2)','2024-12-06 10:40:40',0,'',''),
(856,'ITILCategory',32,'0',20,'glpi (2)','2024-12-06 10:40:49',0,'',''),
(857,'ITILCategory',32,'ITILCategory',17,'glpi (2)','2024-12-06 10:41:08',0,'','Téléphones (33)'),
(858,'ITILCategory',33,'0',20,'glpi (2)','2024-12-06 10:41:08',0,'',''),
(859,'ITILCategory',32,'ITILCategory',17,'glpi (2)','2024-12-06 10:41:15',0,'','Logiciel non autorisé (34)'),
(860,'ITILCategory',34,'0',20,'glpi (2)','2024-12-06 10:41:15',0,'',''),
(861,'ITILCategory',33,'ITILCategory',17,'glpi (2)','2024-12-06 10:41:24',0,'','Distribution (35)'),
(862,'ITILCategory',35,'0',20,'glpi (2)','2024-12-06 10:41:24',0,'',''),
(863,'ITILCategory',36,'0',20,'glpi (2)','2024-12-06 10:43:43',0,'',''),
(864,'ITILCategory',36,'ITILCategory',17,'glpi (2)','2024-12-06 10:44:01',0,'','Libération (37)'),
(865,'ITILCategory',37,'0',20,'glpi (2)','2024-12-06 10:44:01',0,'',''),
(866,'Ticket',1,'User',15,'glpi (2)','2024-12-06 10:46:41',4,'','raphael (7)'),
(867,'Ticket',1,'',0,'glpi (2)','2024-12-06 10:46:41',150,'0','2801'),
(868,'Ticket',1,'Group',15,'glpi (2)','2024-12-06 10:46:41',8,'','Sysadmin (6)'),
(869,'Ticket',1,'0',20,'glpi (2)','2024-12-06 10:46:41',0,'',''),
(870,'Ticket',2,'User',15,'glpi (2)','2024-12-06 10:51:47',4,'','charly (8)'),
(871,'Ticket',2,'',0,'glpi (2)','2024-12-06 10:51:47',150,'0','1307'),
(872,'Ticket',2,'Group',15,'glpi (2)','2024-12-06 10:51:47',8,'','Sysadmin (6)'),
(873,'Ticket',2,'0',20,'glpi (2)','2024-12-06 10:51:47',0,'',''),
(874,'Ticket',1,'User',15,'glpi (2)','2024-12-06 10:52:14',5,'','mael (16)'),
(875,'Ticket',2,'User',15,'glpi (2)','2024-12-06 10:52:23',5,'','mael (16)'),
(876,'Group',8,'0',20,'glpi (2)','2024-12-06 10:53:47',0,'',''),
(877,'Ticket',3,'User',15,'glpi (2)','2024-12-06 10:57:10',4,'','edouard (9)'),
(878,'Ticket',3,'',0,'glpi (2)','2024-12-06 10:57:10',150,'0','1'),
(879,'Ticket',3,'Group',15,'glpi (2)','2024-12-06 10:57:10',8,'','Techniciens (8)'),
(880,'Ticket',3,'0',20,'glpi (2)','2024-12-06 10:57:10',0,'',''),
(881,'Ticket',3,'ITILFollowup',17,'glpi (2)','2024-12-06 10:57:52',0,'','1'),
(882,'Ticket',3,'ITILFollowup',12,'glpi (2)','2024-12-06 10:57:52',0,'','Helpdesk (1)'),
(883,'Ticket',4,'User',15,'glpi (2)','2024-12-06 11:00:13',4,'','philippe (10)'),
(884,'Ticket',4,'',0,'glpi (2)','2024-12-06 11:00:13',150,'0','1'),
(885,'Ticket',4,'Group',15,'glpi (2)','2024-12-06 11:00:13',8,'','Techniciens (8)'),
(886,'Ticket',4,'0',20,'glpi (2)','2024-12-06 11:00:13',0,'',''),
(887,'Ticket',5,'User',15,'glpi (2)','2024-12-06 11:02:45',4,'','elise (11)'),
(888,'Ticket',5,'',0,'glpi (2)','2024-12-06 11:02:45',150,'0','1'),
(889,'Ticket',5,'User',15,'glpi (2)','2024-12-06 11:02:45',5,'','mael (16)'),
(890,'Ticket',5,'Group',15,'glpi (2)','2024-12-06 11:02:45',8,'','Sysadmin (6)'),
(891,'Ticket',5,'0',20,'glpi (2)','2024-12-06 11:02:45',0,'',''),
(892,'Ticket',5,'ITILFollowup',17,'glpi (2)','2024-12-06 11:02:52',0,'','2'),
(893,'Ticket',5,'ITILFollowup',12,'glpi (2)','2024-12-06 11:02:52',0,'','Helpdesk (2)'),
(894,'Ticket',6,'User',15,'glpi (2)','2024-12-06 11:06:25',4,'','marina (12)'),
(895,'Ticket',6,'',0,'glpi (2)','2024-12-06 11:06:25',150,'0','1'),
(896,'Ticket',6,'Group',15,'glpi (2)','2024-12-06 11:06:25',8,'','Techniciens (8)'),
(897,'Ticket',6,'0',20,'glpi (2)','2024-12-06 11:06:25',0,'',''),
(898,'Ticket',6,'ITILFollowup',17,'glpi (2)','2024-12-06 11:06:48',0,'','3'),
(899,'Ticket',6,'ITILFollowup',12,'glpi (2)','2024-12-06 11:06:48',0,'','Helpdesk (3)'),
(900,'Ticket',6,'ITILFollowup',19,'glpi (2)','2024-12-06 11:07:15',0,'','3'),
(901,'Ticket',7,'User',15,'glpi (2)','2024-12-06 11:13:12',4,'','karim (13)'),
(902,'Ticket',7,'',0,'glpi (2)','2024-12-06 11:13:12',150,'0','1'),
(903,'Ticket',7,'User',15,'glpi (2)','2024-12-06 11:13:12',5,'','mael (16)'),
(904,'Ticket',7,'Group',15,'glpi (2)','2024-12-06 11:13:12',8,'','Sysadmin (6)'),
(905,'Ticket',7,'0',20,'glpi (2)','2024-12-06 11:13:12',0,'',''),
(906,'Ticket',8,'User',15,'glpi (2)','2024-12-06 11:15:04',4,'','guillaume (14)'),
(907,'Ticket',8,'',0,'glpi (2)','2024-12-06 11:15:04',150,'0','1'),
(908,'Ticket',8,'Group',15,'glpi (2)','2024-12-06 11:15:04',8,'','Techniciens (8)'),
(909,'Ticket',8,'0',20,'glpi (2)','2024-12-06 11:15:04',0,'',''),
(910,'Ticket',9,'User',15,'glpi (2)','2024-12-06 11:21:00',4,'','samuel (15)'),
(911,'Ticket',9,'',0,'glpi (2)','2024-12-06 11:21:00',150,'0','1'),
(912,'Ticket',9,'Group',15,'glpi (2)','2024-12-06 11:21:00',8,'','Techniciens (8)'),
(913,'Ticket',9,'0',20,'glpi (2)','2024-12-06 11:21:00',0,'',''),
(914,'User',17,'Profile',17,'glpi (2)','2024-12-07 14:44:47',0,'','Entité racine (0), Self-Service (1)'),
(915,'Profile',1,'User',17,'glpi (2)','2024-12-07 14:44:47',0,'','steeve (17), Entité racine (0)'),
(916,'Entity',0,'User',17,'glpi (2)','2024-12-07 14:44:47',0,'','steeve (17), Self-Service (1)'),
(917,'User',17,'0',20,'glpi (2)','2024-12-07 14:44:47',0,'',''),
(918,'User',17,'Group',15,'glpi (2)','2024-12-07 14:44:57',0,'','Comptabilité (1)'),
(919,'Group',1,'User',15,'glpi (2)','2024-12-07 14:44:57',0,'','steeve (17)'),
(920,'ITILCategory',29,'ITILCategory',17,'glpi (2)','2024-12-07 14:51:09',0,'','Application métier (38)'),
(921,'ITILCategory',38,'0',20,'glpi (2)','2024-12-07 14:51:09',0,'',''),
(922,'Ticket',10,'User',15,'glpi (2)','2024-12-07 14:52:39',4,'','steeve (17)'),
(923,'Ticket',10,'',0,'glpi (2)','2024-12-07 14:52:39',150,'0','180699'),
(924,'Ticket',10,'User',15,'glpi (2)','2024-12-07 14:52:39',5,'','mael (16)'),
(925,'Ticket',10,'Group',15,'glpi (2)','2024-12-07 14:52:39',8,'','Sysadmin (6)'),
(926,'Ticket',10,'0',20,'glpi (2)','2024-12-07 14:52:39',0,'',''),
(927,'Ticket',10,'',0,'glpi (2)','2024-12-07 14:54:51',15,'2024-12-05 13:41:00','2024-12-06 13:41:00'),
(928,'Ticket',7,'',0,'mael (16)','2024-12-07 15:03:27',12,'2','5'),
(929,'Ticket',7,'',0,'mael (16)','2024-12-07 15:03:27',64,'glpi (2)','mael (16)'),
(930,'Ticket',7,'',0,'mael (16)','2024-12-07 15:03:27',17,'','2024-12-07 16:03:27'),
(931,'Ticket',7,'ITILSolution',17,'mael (16)','2024-12-07 15:03:27',0,'','1 (1)'),
(932,'ITILSolution',1,'0',20,'mael (16)','2024-12-07 15:03:27',0,'',''),
(933,'Document',1,'0',20,'mael (16)','2024-12-07 15:10:48',0,'',''),
(934,'Document',1,'ITILSolution',15,'mael (16)','2024-12-07 15:10:48',0,'','1 (1)'),
(935,'ITILSolution',1,'Document',15,'mael (16)','2024-12-07 15:10:48',0,'','bene_mael_demande_equipement_122024.pdf (1)'),
(936,'Ticket',7,'ITILSolution',18,'mael (16)','2024-12-07 15:10:48',0,'0','16'),
(937,'Ticket',2,'',0,'mael (16)','2024-12-07 15:13:57',12,'2','5'),
(938,'Ticket',2,'',0,'mael (16)','2024-12-07 15:13:57',64,'glpi (2)','mael (16)'),
(939,'Ticket',2,'',0,'mael (16)','2024-12-07 15:13:57',17,'','2024-12-07 16:13:57'),
(940,'Ticket',2,'ITILSolution',17,'mael (16)','2024-12-07 15:13:57',0,'','2 (2)'),
(941,'ITILSolution',2,'0',20,'mael (16)','2024-12-07 15:13:57',0,'',''),
(942,'Document',2,'0',20,'mael (16)','2024-12-07 15:26:21',0,'',''),
(943,'Document',2,'ITILSolution',15,'mael (16)','2024-12-07 15:26:21',0,'','3 (3)'),
(944,'ITILSolution',3,'Document',15,'mael (16)','2024-12-07 15:26:21',0,'','bene_mael_reponse_steeve_122024.pdf (2)'),
(945,'Ticket',10,'',0,'mael (16)','2024-12-07 15:26:21',12,'2','5'),
(946,'Ticket',10,'',0,'mael (16)','2024-12-07 15:26:21',64,'glpi (2)','mael (16)'),
(947,'Ticket',10,'',0,'mael (16)','2024-12-07 15:26:21',17,'','2024-12-07 16:26:21'),
(948,'Ticket',10,'ITILSolution',17,'mael (16)','2024-12-07 15:26:21',0,'','3 (3)'),
(949,'ITILSolution',3,'0',20,'mael (16)','2024-12-07 15:26:21',0,'',''),
(950,'Document',3,'0',20,'mael (16)','2024-12-07 15:56:11',0,'',''),
(951,'Document',3,'ITILSolution',15,'mael (16)','2024-12-07 15:56:11',0,'','4 (4)'),
(952,'ITILSolution',4,'Document',15,'mael (16)','2024-12-07 15:56:11',0,'','bene_mael_vpn_ocito_122024.pdf (3)'),
(953,'Ticket',5,'',0,'mael (16)','2024-12-07 15:56:11',12,'2','5'),
(954,'Ticket',5,'',0,'mael (16)','2024-12-07 15:56:11',64,'glpi (2)','mael (16)'),
(955,'Ticket',5,'',0,'mael (16)','2024-12-07 15:56:11',17,'','2024-12-07 16:56:11'),
(956,'Ticket',5,'ITILSolution',17,'mael (16)','2024-12-07 15:56:11',0,'','4 (4)'),
(957,'ITILSolution',4,'0',20,'mael (16)','2024-12-07 15:56:11',0,'',''),
(958,'Document',4,'0',20,'mael (16)','2024-12-07 16:09:08',0,'',''),
(959,'Document',4,'ITILSolution',15,'mael (16)','2024-12-07 16:09:08',0,'','5 (5)'),
(960,'ITILSolution',5,'Document',15,'mael (16)','2024-12-07 16:09:08',0,'','bene_mael_mediation_122024.pdf (4)'),
(961,'Ticket',1,'',0,'mael (16)','2024-12-07 16:09:08',12,'2','5'),
(962,'Ticket',1,'',0,'mael (16)','2024-12-07 16:09:08',64,'glpi (2)','mael (16)'),
(963,'Ticket',1,'',0,'mael (16)','2024-12-07 16:09:08',17,'','2024-12-07 17:09:08'),
(964,'Ticket',1,'ITILSolution',17,'mael (16)','2024-12-07 16:09:08',0,'','5 (5)'),
(965,'ITILSolution',5,'0',20,'mael (16)','2024-12-07 16:09:08',0,'','');

--
-- Table structure for table `glpi_manuallinks`
--

CREATE TABLE `glpi_manuallinks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `url` varchar(8096) NOT NULL,
  `open_window` tinyint(4) NOT NULL DEFAULT 1,
  `icon` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(255) DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `items_id` (`items_id`),
  KEY `date_creation` (`date_creation`),
  KEY `date_mod` (`date_mod`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_manuallinks`
--


--
-- Table structure for table `glpi_manufacturers`
--

CREATE TABLE `glpi_manufacturers` (
  `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_manufacturers`
--


--
-- Table structure for table `glpi_monitormodels`
--

CREATE TABLE `glpi_monitormodels` (
  `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_monitormodels`
--


--
-- Table structure for table `glpi_monitors`
--

CREATE TABLE `glpi_monitors` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `name` varchar(255) DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `contact_num` varchar(255) DEFAULT NULL,
  `users_id_tech` int(10) unsigned NOT NULL DEFAULT 0,
  `groups_id_tech` int(10) unsigned NOT NULL DEFAULT 0,
  `comment` text DEFAULT NULL,
  `serial` varchar(255) DEFAULT NULL,
  `otherserial` varchar(255) DEFAULT NULL,
  `size` decimal(5,2) NOT NULL DEFAULT 0.00,
  `have_micro` tinyint(4) NOT NULL DEFAULT 0,
  `have_speaker` tinyint(4) NOT NULL DEFAULT 0,
  `have_subd` tinyint(4) NOT NULL DEFAULT 0,
  `have_bnc` tinyint(4) NOT NULL DEFAULT 0,
  `have_dvi` tinyint(4) NOT NULL DEFAULT 0,
  `have_pivot` tinyint(4) NOT NULL DEFAULT 0,
  `have_hdmi` tinyint(4) NOT NULL DEFAULT 0,
  `have_displayport` tinyint(4) NOT NULL DEFAULT 0,
  `locations_id` int(10) unsigned NOT NULL DEFAULT 0,
  `monitortypes_id` int(10) unsigned NOT NULL DEFAULT 0,
  `monitormodels_id` int(10) unsigned NOT NULL DEFAULT 0,
  `manufacturers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_global` tinyint(4) NOT NULL DEFAULT 0,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `is_template` tinyint(4) NOT NULL DEFAULT 0,
  `template_name` varchar(255) DEFAULT NULL,
  `users_id` int(10) unsigned NOT NULL DEFAULT 0,
  `groups_id` int(10) unsigned NOT NULL DEFAULT 0,
  `states_id` int(10) unsigned NOT NULL DEFAULT 0,
  `ticket_tco` decimal(20,4) DEFAULT 0.0000,
  `is_dynamic` tinyint(4) NOT NULL DEFAULT 0,
  `autoupdatesystems_id` int(10) unsigned NOT NULL DEFAULT 0,
  `uuid` varchar(255) DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `is_template` (`is_template`),
  KEY `is_global` (`is_global`),
  KEY `entities_id` (`entities_id`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `groups_id` (`groups_id`),
  KEY `users_id` (`users_id`),
  KEY `locations_id` (`locations_id`),
  KEY `monitormodels_id` (`monitormodels_id`),
  KEY `states_id` (`states_id`),
  KEY `users_id_tech` (`users_id_tech`),
  KEY `monitortypes_id` (`monitortypes_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `groups_id_tech` (`groups_id_tech`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `autoupdatesystems_id` (`autoupdatesystems_id`),
  KEY `serial` (`serial`),
  KEY `otherserial` (`otherserial`),
  KEY `uuid` (`uuid`),
  KEY `date_creation` (`date_creation`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_monitors`
--


--
-- Table structure for table `glpi_monitortypes`
--

CREATE TABLE `glpi_monitortypes` (
  `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_monitortypes`
--


--
-- Table structure for table `glpi_networkaliases`
--

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

--
-- Dumping data for table `glpi_networkaliases`
--


--
-- Table structure for table `glpi_networkequipmentmodels`
--

CREATE TABLE `glpi_networkequipmentmodels` (
  `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_networkequipmentmodels`
--


--
-- Table structure for table `glpi_networkequipments`
--

CREATE TABLE `glpi_networkequipments` (
  `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,
  `ram` int(10) unsigned DEFAULT NULL,
  `serial` varchar(255) DEFAULT NULL,
  `otherserial` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `contact_num` varchar(255) DEFAULT NULL,
  `users_id_tech` int(10) unsigned NOT NULL DEFAULT 0,
  `groups_id_tech` int(10) unsigned NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `locations_id` int(10) unsigned NOT NULL DEFAULT 0,
  `networks_id` int(10) unsigned NOT NULL DEFAULT 0,
  `networkequipmenttypes_id` int(10) unsigned NOT NULL DEFAULT 0,
  `networkequipmentmodels_id` int(10) unsigned NOT NULL DEFAULT 0,
  `manufacturers_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `is_template` tinyint(4) NOT NULL DEFAULT 0,
  `template_name` varchar(255) DEFAULT NULL,
  `users_id` int(10) unsigned NOT NULL DEFAULT 0,
  `groups_id` int(10) unsigned NOT NULL DEFAULT 0,
  `states_id` int(10) unsigned NOT NULL DEFAULT 0,
  `ticket_tco` decimal(20,4) DEFAULT 0.0000,
  `is_dynamic` tinyint(4) NOT NULL DEFAULT 0,
  `uuid` varchar(255) DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `autoupdatesystems_id` int(10) unsigned NOT NULL DEFAULT 0,
  `sysdescr` text DEFAULT NULL,
  `cpu` int(11) NOT NULL DEFAULT 0,
  `uptime` varchar(255) NOT NULL DEFAULT '0',
  `last_inventory_update` timestamp NULL DEFAULT NULL,
  `snmpcredentials_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `is_template` (`is_template`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `groups_id` (`groups_id`),
  KEY `users_id` (`users_id`),
  KEY `locations_id` (`locations_id`),
  KEY `networkequipmentmodels_id` (`networkequipmentmodels_id`),
  KEY `networks_id` (`networks_id`),
  KEY `states_id` (`states_id`),
  KEY `users_id_tech` (`users_id_tech`),
  KEY `networkequipmenttypes_id` (`networkequipmenttypes_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `date_mod` (`date_mod`),
  KEY `groups_id_tech` (`groups_id_tech`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `serial` (`serial`),
  KEY `otherserial` (`otherserial`),
  KEY `uuid` (`uuid`),
  KEY `date_creation` (`date_creation`),
  KEY `autoupdatesystems_id` (`autoupdatesystems_id`),
  KEY `snmpcredentials_id` (`snmpcredentials_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_networkequipments`
--


--
-- Table structure for table `glpi_networkequipmenttypes`
--

CREATE TABLE `glpi_networkequipmenttypes` (
  `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_networkequipmenttypes`
--


--
-- Table structure for table `glpi_networkinterfaces`
--

CREATE TABLE `glpi_networkinterfaces` (
  `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_networkinterfaces`
--


--
-- Table structure for table `glpi_networknames`
--

CREATE TABLE `glpi_networknames` (
  `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,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `fqdns_id` int(10) unsigned NOT NULL DEFAULT 0,
  `ipnetworks_id` int(10) unsigned NOT NULL DEFAULT 0,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `is_dynamic` tinyint(4) NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `entities_id` (`entities_id`),
  KEY `FQDN` (`name`,`fqdns_id`),
  KEY `fqdns_id` (`fqdns_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `item` (`itemtype`,`items_id`,`is_deleted`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `ipnetworks_id` (`ipnetworks_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_networknames`
--


--
-- Table structure for table `glpi_networkportaggregates`
--

CREATE TABLE `glpi_networkportaggregates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `networkports_id` int(10) unsigned NOT NULL DEFAULT 0,
  `networkports_id_list` text DEFAULT NULL COMMENT 'array of associated networkports_id',
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `networkports_id` (`networkports_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_networkportaggregates`
--


--
-- Table structure for table `glpi_networkportaliases`
--

CREATE TABLE `glpi_networkportaliases` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `networkports_id` int(10) unsigned NOT NULL DEFAULT 0,
  `networkports_id_alias` int(10) unsigned NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `networkports_id` (`networkports_id`),
  KEY `networkports_id_alias` (`networkports_id_alias`),
  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_networkportaliases`
--


--
-- Table structure for table `glpi_networkportconnectionlogs`
--

CREATE TABLE `glpi_networkportconnectionlogs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date` timestamp NULL DEFAULT NULL,
  `connected` tinyint(4) NOT NULL DEFAULT 0,
  `networkports_id_source` int(10) unsigned NOT NULL DEFAULT 0,
  `networkports_id_destination` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `date` (`date`),
  KEY `networkports_id_source` (`networkports_id_source`),
  KEY `networkports_id_destination` (`networkports_id_destination`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_networkportconnectionlogs`
--


--
-- Table structure for table `glpi_networkportdialups`
--

CREATE TABLE `glpi_networkportdialups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `networkports_id` int(10) unsigned NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `networkports_id` (`networkports_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_networkportdialups`
--


--
-- Table structure for table `glpi_networkportethernets`
--

CREATE TABLE `glpi_networkportethernets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `networkports_id` int(10) unsigned NOT NULL DEFAULT 0,
  `items_devicenetworkcards_id` int(10) unsigned NOT NULL DEFAULT 0,
  `type` varchar(10) DEFAULT '' COMMENT 'T, LX, SX',
  `speed` int(11) NOT NULL DEFAULT 10 COMMENT 'Mbit/s: 10, 100, 1000, 10000',
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `networkports_id` (`networkports_id`),
  KEY `card` (`items_devicenetworkcards_id`),
  KEY `type` (`type`),
  KEY `speed` (`speed`),
  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_networkportethernets`
--


--
-- Table structure for table `glpi_networkportfiberchannels`
--

CREATE TABLE `glpi_networkportfiberchannels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `networkports_id` int(10) unsigned NOT NULL DEFAULT 0,
  `items_devicenetworkcards_id` int(10) unsigned NOT NULL DEFAULT 0,
  `networkportfiberchanneltypes_id` int(10) unsigned NOT NULL DEFAULT 0,
  `wwn` varchar(50) DEFAULT '',
  `speed` int(11) NOT NULL DEFAULT 10 COMMENT 'Mbit/s: 10, 100, 1000, 10000',
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `networkports_id` (`networkports_id`),
  KEY `card` (`items_devicenetworkcards_id`),
  KEY `type` (`networkportfiberchanneltypes_id`),
  KEY `wwn` (`wwn`),
  KEY `speed` (`speed`),
  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_networkportfiberchannels`
--


--
-- Table structure for table `glpi_networkportfiberchanneltypes`
--

CREATE TABLE `glpi_networkportfiberchanneltypes` (
  `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_networkportfiberchanneltypes`
--


--
-- Table structure for table `glpi_networkportlocals`
--

CREATE TABLE `glpi_networkportlocals` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `networkports_id` int(10) unsigned NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `networkports_id` (`networkports_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_networkportlocals`
--


--
-- Table structure for table `glpi_networkportmetrics`
--

CREATE TABLE `glpi_networkportmetrics` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `ifinbytes` bigint(20) NOT NULL DEFAULT 0,
  `ifinerrors` bigint(20) NOT NULL DEFAULT 0,
  `ifoutbytes` bigint(20) NOT NULL DEFAULT 0,
  `ifouterrors` bigint(20) NOT NULL DEFAULT 0,
  `networkports_id` int(10) unsigned NOT NULL DEFAULT 0,
  `date_creation` timestamp NULL DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`networkports_id`,`date`),
  KEY `date` (`date`),
  KEY `date_creation` (`date_creation`),
  KEY `date_mod` (`date_mod`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_networkportmetrics`
--


--
-- Table structure for table `glpi_networkports`
--

CREATE TABLE `glpi_networkports` (
  `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,
  `logical_number` int(11) NOT NULL DEFAULT 0,
  `name` varchar(255) DEFAULT NULL,
  `instantiation_type` varchar(255) DEFAULT NULL,
  `mac` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `is_dynamic` tinyint(4) NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `ifmtu` int(11) NOT NULL DEFAULT 0,
  `ifspeed` bigint(20) NOT NULL DEFAULT 0,
  `ifinternalstatus` varchar(255) DEFAULT NULL,
  `ifconnectionstatus` int(11) NOT NULL DEFAULT 0,
  `iflastchange` varchar(255) DEFAULT NULL,
  `ifinbytes` bigint(20) NOT NULL DEFAULT 0,
  `ifinerrors` bigint(20) NOT NULL DEFAULT 0,
  `ifoutbytes` bigint(20) NOT NULL DEFAULT 0,
  `ifouterrors` bigint(20) NOT NULL DEFAULT 0,
  `ifstatus` varchar(255) DEFAULT NULL,
  `ifdescr` varchar(255) DEFAULT NULL,
  `ifalias` varchar(255) DEFAULT NULL,
  `portduplex` varchar(255) DEFAULT NULL,
  `trunk` tinyint(4) NOT NULL DEFAULT 0,
  `lastup` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `mac` (`mac`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  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_networkports`
--


--
-- Table structure for table `glpi_networkports_networkports`
--

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

--
-- Dumping data for table `glpi_networkports_networkports`
--


--
-- Table structure for table `glpi_networkports_vlans`
--

CREATE TABLE `glpi_networkports_vlans` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `networkports_id` int(10) unsigned NOT NULL DEFAULT 0,
  `vlans_id` int(10) unsigned NOT NULL DEFAULT 0,
  `tagged` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`networkports_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_networkports_vlans`
--


--
-- Table structure for table `glpi_networkporttypes`
--

CREATE TABLE `glpi_networkporttypes` (
  `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,
  `value_decimal` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `is_importable` tinyint(4) NOT NULL DEFAULT 0,
  `instantiation_type` varchar(255) DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `value_decimal` (`value_decimal`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `is_importable` (`is_importable`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB AUTO_INCREMENT=305 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_networkporttypes`
--

INSERT INTO `glpi_networkporttypes` VALUES
(1,0,0,0,'Name','Description References',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(2,0,0,1,'other','none of the following [RFC1213]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(3,0,0,2,'regular1822','BBN Report 1822 [RFC1213]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(4,0,0,3,'hdh1822','BBN Report 1822 [RFC1213]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(5,0,0,4,'ddn-x25','BBN Report 1822 [RFC1213]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(6,0,0,5,'x25','X.25 [RFC1382]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(7,0,0,6,'ethernet-csmacd','[RFC1213]',1,'NetworkPortEthernet','2024-12-01 14:42:31','2024-12-01 14:42:31'),
(8,0,0,7,'IEEE802.3','DEPRECATED [RFC3635]',1,'NetworkPortEthernet','2024-12-01 14:42:31','2024-12-01 14:42:31'),
(9,0,0,8,'IEEE802.4','Token Bus-like Objects [RFC1239]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(10,0,0,9,'IEEE802.5','Token Ring-like Objects [RFC1748]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(11,0,0,10,'iso88026-man','[RFC1213]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(12,0,0,11,'starLan','DEPRECATED [RFC3635]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(13,0,0,12,'proteon-10Mbit','[RFC1213]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(14,0,0,13,'proteon-80Mbit','[RFC1213]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(15,0,0,14,'hyperchannel','[RFC1213]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(16,0,0,15,'FDDI','FDDI Objects [RFC1512]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(17,0,0,16,'lapb','LAP B [RFC1381]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(18,0,0,17,'sdlc','[RFC1213]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(19,0,0,18,'ds1','T1/E1 Carrier Objects [RFC4805]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(20,0,0,19,'e1','obsolete [RFC4805]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(21,0,0,20,'basicISDN','[RFC1213]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(22,0,0,21,'primaryISDN','[RFC1213]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(23,0,0,22,'propPointToPointSerial','[RFC1213]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(24,0,0,23,'ppp','Point-to-Point Protocol [RFC1213][RFC1471]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(25,0,0,24,'softwareLoopback','[RFC1213]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(26,0,0,25,'eon','[RFC1213]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(27,0,0,26,'ethernet-3Mbit','[RFC1213]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(28,0,0,27,'nsip','[RFC1213]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(29,0,0,28,'slip','[RFC1213]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(30,0,0,29,'ultra','[RFC1213]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(31,0,0,30,'ds3','DS3/E3 Interface Objects [RFC3896]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(32,0,0,31,'sip','SMDS Interface Objects [RFC1694]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(33,0,0,32,'frame-relay','Frame Relay Objects for DTE [RFC2115]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(34,0,0,33,'RS-232','RS-232 Objects [RFC1659]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(35,0,0,34,'Parallel','Parallel Printer Objects [RFC1660]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(36,0,0,35,'arcnet','ARC network',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(37,0,0,36,'arcnet-plus','ARC network plus',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(38,0,0,37,'atm','ATM',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(39,0,0,38,'MIOX25','MIOX25 [RFC1461]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(40,0,0,39,'SONET','SONET or SDH',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(41,0,0,40,'x25ple','X.25 packet level [RFC2127]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(42,0,0,41,'iso88022llc','802.2 LLC',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(43,0,0,42,'localTalk','',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(44,0,0,43,'smds-dxi','SMDS DXI',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(45,0,0,44,'frameRelayService','Frame Relay DCE [RFC2954]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(46,0,0,45,'v35','V.35',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(47,0,0,46,'hssi','HSSI',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(48,0,0,47,'hippi','HIPPI',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(49,0,0,48,'modem','generic modem',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(50,0,0,49,'aal5','AAL5 over ATM',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(51,0,0,50,'sonetPath','',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(52,0,0,51,'sonetVT','',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(53,0,0,52,'smds-icip','SMDS Inter-Carrier Interface Protocol',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(54,0,0,53,'propVirtual','proprietary vitural/internal interface [RFC2863]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(55,0,0,54,'propMultiLink','proprietary multi-link multiplexing [RFC2863]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(56,0,0,55,'ieee80212','100BaseVG',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(57,0,0,56,'fibre-channel','Fibre Channel',1,'NetworkPortFiberchannel','2024-12-01 14:42:31','2024-12-01 14:42:31'),
(58,0,0,57,'hippiInterfaces','HIPPI interfaces [Philip_Cameron]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(59,0,0,58,'FrameRelayInterconnect','Interconnet over FR [Unknown]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(60,0,0,59,'aflane8023','ATM Emulated LAN for 802.3 [Keith_McCloghrie]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(61,0,0,60,'aflane8025','ATM Emulated LAN for 802.5 [Keith_McCloghrie]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(62,0,0,61,'cctEmul','ATM Emulated circuit [Guy_Fedorkow]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(63,0,0,62,'fastEther','DEPRECATED [RFC3635]',1,'NetworkPortEthernet','2024-12-01 14:42:31','2024-12-01 14:42:31'),
(64,0,0,63,'isdn','ISDN and X.25 [RFC1356]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(65,0,0,64,'v11','CCITT V.11/X.21 [Satish_Popat]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(66,0,0,65,'v36','CCITT V.36 [Satish_Popat]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(67,0,0,66,'g703-64k','CCITT G703 at 64Kbps [Satish_Popat]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(68,0,0,67,'g703-2mb','CCITT G703 at 2Mbps [Satish_Popat]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(69,0,0,68,'qllc','SNA QLLC [Satish_Popat]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(70,0,0,69,'fastEtherFX','DEPRECATED [RFC3635]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(71,0,0,70,'channel','channel [Steven_Schwell]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(72,0,0,71,'IEEE802.11','radio spread spectrum [Dawkoon_Paul_Lee]',1,'NetworkPortWifi','2024-12-01 14:42:31','2024-12-01 14:42:31'),
(73,0,0,72,'ibm370parChan','IBM System 360/370 OEMI Channel [Bill_Kwan]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(74,0,0,73,'ESCON','IBM Enterprise Systems Connection [Bill_Kwan]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(75,0,0,74,'DLSw','Data Link Switching [Bill_Kwan]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(76,0,0,75,'ISDNs','ISDN S/T interface [Ed_Alcoff]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(77,0,0,76,'ISDNu','ISDN U interface [Ed_Alcoff]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(78,0,0,77,'lapd','Link Access Protocol D [Ed_Alcoff]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(79,0,0,78,'ip-switch','IP Switching Objects [Joe_Wei]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(80,0,0,79,'rsrb','Remote Source Route Bridging [Bob_Clouston]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(81,0,0,80,'atm-logical','ATM Logical Port [RFC3606]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(82,0,0,81,'ds0','Digital Signal Level 0 [RFC2494]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(83,0,0,82,'ds0Bundle','group of ds0s on the same ds1 [RFC2494]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(84,0,0,83,'bsc','Bisynchronous Protocol [Bill_Kwan]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(85,0,0,84,'async','Asynchronous Protocol [Bill_Kwan]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(86,0,0,85,'cnr','Combat Net Radio [Herb_Jensen]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(87,0,0,86,'iso88025Dtr','ISO 802.5r DTR [Trevor_Warwick]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(88,0,0,87,'eplrs','Enhanced  Pos Loc Report Sys [Herb_Jensen]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(89,0,0,88,'arap','Appletalk Remote Access Protocol [Jim_Halpin]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(90,0,0,89,'propCnls','Proprietary Connectionless Proto. [Robert_Neill]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(91,0,0,90,'hostPad','CCITT-ITU X.29 PAD Protocol [Robert_Neill]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(92,0,0,91,'termPad','CCITT-ITU X.3 PAD Facility [Robert_Neill]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(93,0,0,92,'frameRelayMPI','Multiproto Interconnect over FR [Robert_Neill]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(94,0,0,93,'x213','CCITT-ITU X213 [Robert_Neill]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(95,0,0,94,'adsl','Asymmetric Digital Subscriber Loop [Gregory_Bathrick]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(96,0,0,95,'radsl','Rate-Adapt. Digital Subscriber Loop [Gregory_Bathrick]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(97,0,0,96,'sdsl','Symmetric Digital Subscriber Loop [Gregory_Bathrick]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(98,0,0,97,'vdsl','Very H-Speed Digital Subscrib. Loop [Gregory_Bathrick]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(99,0,0,98,'iso88025CRFPInt','ISO 802.5 CRFP [Trevor_Warwick]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(100,0,0,99,'myrinet','Myricom Myrinet [Bob_Felderman]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(101,0,0,100,'voiceEM','Voice recEive and transMit (E&#38;M) [Bob_Stewart]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(102,0,0,101,'voiceFXO','Voice Foreign Exchange Office [Bob_Stewart]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(103,0,0,102,'voiceFXS','Voice Foreign Exchange Station [Bob_Stewart]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(104,0,0,103,'voiceEncap','Voice encapsulation [Bob_Stewart]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(105,0,0,104,'voiceOverIp','Voice over IP encapsulation [Bob_Stewart]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(106,0,0,105,'atmDxi','ATM DXI [Gary_Hanson]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(107,0,0,106,'atmFuni','ATM FUNI [Gary_Hanson]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(108,0,0,107,'atmIma','ATM IMA [Chris_Martin]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(109,0,0,108,'pppMultilinkBundle','PPP Multilink Bundle [John_Shriver]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(110,0,0,109,'ipOverCdlc','IBM ipOverCdlc [Ken_White]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(111,0,0,110,'ipOverClaw','IBM Common Link Access to Workstn [Ken_White]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(112,0,0,111,'stackToStack','IBM stackToStack [Ken_White]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(113,0,0,112,'virtualIpAddress','IBM VIPA [Ken_White]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(114,0,0,113,'mpc','IBM multi-protocol channel support [Ken_White]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(115,0,0,114,'ipOverAtm','IBM ipOverAtm [RFC2320]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(116,0,0,115,'iso88025Fiber','ISO 802.5j Fiber Token Ring [Kevin_Lingle]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(117,0,0,116,'tdlc','IBM twinaxial data link control [John_Pechacek]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(118,0,0,117,'gigabitEthernet','DEPRECATED [RFC3635]',1,'NetworkPortEthernet','2024-12-01 14:42:31','2024-12-01 14:42:31'),
(119,0,0,118,'hdlc','HDLC [Sebastien_Rosset]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(120,0,0,119,'lapf','LAP F [Sebastien_Rosset]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(121,0,0,120,'v37','V.37 [Sebastien_Rosset]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(122,0,0,121,'x25mlp','Multi-Link Protocol [Sebastien_Rosset]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(123,0,0,122,'x25huntGroup','X25 Hunt Group [Sebastien_Rosset]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(124,0,0,123,'transpHdlc','Transp HDLC [Sebastien_Rosset]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(125,0,0,124,'interleave','Interleave channel [Karmous_Edwards]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(126,0,0,125,'fast','Fast channel [Karmous_Edwards]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(127,0,0,126,'ip','IP (for APPN HPR in IP networks) [Robert_Moore]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(128,0,0,127,'docsCableMaclayer','CATV Mac Layer [Azlina_Palmer]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(129,0,0,128,'docsCableDownstream','CATV Downstream interface [Azlina_Palmer]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(130,0,0,129,'docsCableUpstream','CATV Upstream interface [Azlina_Palmer]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(131,0,0,130,'a12MppSwitch','Avalon Parallel Processor [Ross_Harvey]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(132,0,0,131,'tunnel','Encapsulation interface [Dave_Thaler]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(133,0,0,132,'coffee','coffee pot [RFC2325]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(134,0,0,133,'ces','Circiut Emulation Service [Ron_Carmona]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(135,0,0,134,'atmSubInterface','(x)  ATM Sub Interface [Keith_McCloghrie]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(136,0,0,135,'l2vlan','Layer 2 Virtual LAN using 802.1Q [Mike_MacFaden]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(137,0,0,136,'l3ipvlan','Layer 3 Virtual LAN - IP Protocol [Mike_MacFaden]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(138,0,0,137,'l3ipxvlan','Layer 3 Virtual LAN - IPX Prot. [Mike_MacFaden]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(139,0,0,138,'digitalPowerLine','IP over Power Lines [Hans_Scholtes]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(140,0,0,139,'mediaMailOverIp','(xxx)  Multimedia Mail over IP [Hongchi_Shih]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(141,0,0,140,'dtm','Dynamic synchronous Transfer Mode [Jakob_Ellerstedt]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(142,0,0,141,'dcn','Data Communications Network [James_Card]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(143,0,0,142,'ipForward','IP Forwarding Interface [James_Card]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(144,0,0,143,'msdsl','Multi-rate Symmetric DSL [Gopinath_Durairaj]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(145,0,0,144,'ieee1394     IEEE1394','High Performance Serial Bus [Kenji_Fujisawa]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(146,0,0,145,'if-gsn','HIPPI-6400 [Jean_Michel_Pittet]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(147,0,0,146,'dvbRccMacLayer','DVB-RCC MAC Layer [Maarten_Oelering]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(148,0,0,147,'dvbRccDownstream','DVB-RCC Downstream Channel [Maarten_Oelering]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(149,0,0,148,'dvbRccUpstream','DVB-RCC Upstream Channel [Maarten_Oelering]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(150,0,0,149,'atmVirtual','ATM Virtual Interface [Subrahmanya_Hegde]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(151,0,0,150,'mplsTunnel','MPLS Tunnel Virtual Interface [Cheenu_Srinivasan]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(152,0,0,151,'srp','Spatial Reuse Protocol [Bill_Shetti]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(153,0,0,152,'voiceOverAtm','Voice over ATM [Chris_White]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(154,0,0,153,'voiceOverFrameRelay','Voice Over Frame Relay [Chris_White]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(155,0,0,154,'idsl','Digital Subscriber Loop over ISDN [Patrick_Gili]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(156,0,0,155,'compositeLink','Avici Composite Link Interface [Joseph_Dube]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(157,0,0,156,'ss7SigLink','SS7 Signaling Link [Cheenu_Srinivasan]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(158,0,0,157,'propWirelessP2P','Prop. P2P wireless interface [Joseph_Raja]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(159,0,0,158,'frForward','Frame forward Interface [Subrahmanya_Hegde]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(160,0,0,159,'rfc1483','Multiprotocol over ATM AAL5 [RFC1483]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(161,0,0,160,'USB','USB Interface [Bejamin_Dolnik]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(162,0,0,161,'ieee8023adLag','IEEE 802.3ad Link Aggregate [Les_Bell]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(163,0,0,162,'bgpPolicyAccounting','BGP Policy Accounting [Vinod_B_C]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(164,0,0,163,'frf16MfrBundle','FRF.16 Multilik Frame Relay [Pate_Prayson]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(165,0,0,164,'h323Gatekeeper','H323 Gatekeeper [Chris_White]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(166,0,0,165,'h323Proxy','H323 Voice and Video Proxy [Chris_White]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(167,0,0,166,'mpls','MPLS [Cheenu_Srinivasan]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(168,0,0,167,'mfSigLink','Multi-frequency signaling link [Cheenu_Srinivasan]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(169,0,0,168,'hdsl2','High Bit-Rate DSL, 2nd gen. [Bob_Ray]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(170,0,0,169,'shdsl','Multirate HDSL2 [Bob_Ray]',1,'NetworkPortEthernet','2024-12-01 14:42:31','2024-12-01 14:42:31'),
(171,0,0,170,'ds1FDL','Facility Data Link (4Kbps) on a DS1 [Bill_Kwan]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(172,0,0,171,'POS','Packet over SONET/SDH Interface [Ewart_Tempest]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(173,0,0,172,'dvbAsiIn','DVB-ASI Input [Hezi_Oved]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(174,0,0,173,'dvbAsiOut','DVB-ASI Output [Hezi_Oved]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(175,0,0,174,'plc','Power Line Communications [Andrew_Lunn]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(176,0,0,175,'NFAS','Non-Facility Associated Signaling [Sidney_Antommarchi]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(177,0,0,176,'TR008','TROO8 [Sidney_Antommarchi]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(178,0,0,177,'GR303RDT','Remote Digital Terminal [Sidney_Antommarchi]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(179,0,0,178,'GR303IDT','Integrated Digital Terminal [Sidney_Antommarchi]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(180,0,0,179,'ISUP','ISUP [Sidney_Antommarchi]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(181,0,0,180,'propDocsWirelessMaclayer','Cisco proprietary Maclayer [Joseph_Raja]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(182,0,0,181,'propDocsWirelessDownstream','Cisco proprietary Downstream [Joseph_Raja]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(183,0,0,182,'propDocsWirelessUpstream','Cisco proprietary Upstream [Joseph_Raja]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(184,0,0,183,'hiperlan2','HIPERLAN Type 2 Radio Interface [Jamshid_Khun_Jush]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(185,0,0,184,'propBWAp2Mp','PropBroadbandWirelessAccesspt2Multipt\n(use of this type for IEEE 802.16\nWMAN, interfaces as per IEEE 802.16\nis deprecated and iftype 237 should\nbe used instead) [Zvika_Zilberman]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(186,0,0,185,'sonetOverheadChannel','SONET Overhead Channel [ODSI_Coalition_K_Arv]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(187,0,0,186,'digitalWrapperOverheadChannel','Digital Wrapper\nOverhead [ODSI_Coalition_K_Arv]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(188,0,0,187,'aal2','ATM adaptation layer 2 [K_Ashoka]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(189,0,0,188,'radioMAC','MAC layer over radio links [Daniele_Behar]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(190,0,0,189,'atmRadio','ATM over radio links [Daniele_Behar]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(191,0,0,190,'IMT','Inter-Machine Trunks [Sidney_Antommarchi]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(192,0,0,191,'mvl','Multiple Virtual Lines DSL [Kevin_Baughman]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(193,0,0,192,'reachDSL','Long Reach DSL [Kevin_Baughman]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(194,0,0,193,'frDlciEndPt','Frame Relay DLCI End Point [Robert_Steinberger]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(195,0,0,194,'atmVciEndPt','ATM VCI End Point [Robert_Steinberger]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(196,0,0,195,'opticalChannel','Optical Channel [Mark_Stewart]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(197,0,0,196,'opticalTransport','Optical Transport [Mark_Stewart]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(198,0,0,197,'propAtm','Proprietary ATM [Subrahmanya_Hegde]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(199,0,0,198,'voiceOverCable','Voice Over Cable Interface [Eugene_Nechamkin]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(200,0,0,199,'infiniband','Infiniband [Bill_Strahm]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(201,0,0,200,'teLink','TE Link [Martin_Dubuc]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(202,0,0,201,'q2931','Q.2931 [Sidney_Antommarchi_2]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(203,0,0,202,'virtualTg','Virtual Trunk Group [Sidney_Antommarchi_2]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(204,0,0,203,'sipTg','SIP Trunk Group [Sidney_Antommarchi_2]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(205,0,0,204,'sipSig','SIP Signaling [Sidney_Antommarchi_2]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(206,0,0,205,'docsCableUpstreamChannel','CATV Upstream Channel [Greg_Nakanishi]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(207,0,0,206,'econet','Acorn Econet [Ben_Harris]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(208,0,0,207,'pon155','FSAN 155Mb Symetrical PON interface [Graham_Higgins]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(209,0,0,208,'pon622','FSAN 622Mb Symetrical PON interface [Graham_Higgins]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(210,0,0,209,'bridge','Transparent bridge interface [Yuzo_Watanabe]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(211,0,0,210,'linegroup','Interface common to multiple lines [Yuzo_Watanabe]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(212,0,0,211,'voiceEMFGD','voice E&#38;M Feature Group D [Taher_Shaikh]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(213,0,0,212,'voiceFGDEANA','voice FGD Exchange Access North American [Taher_Shaikh]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(214,0,0,213,'voiceDID','voice Direct Inward Dialing [Taher_Shaikh]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(215,0,0,214,'mpegTransport','MPEG transport interface [Gaurav_Aggarwal]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(216,0,0,215,'sixToFour','6to4 interface  (DEPRECATED) [RFC4087]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(217,0,0,216,'gtp','GTP (GPRS Tunneling Protocol) [Rajesh_M_L]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(218,0,0,217,'pdnEtherLoop1','Paradyne EtherLoop 1 [Shu_Dong]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(219,0,0,218,'pdnEtherLoop2','Paradyne EtherLoop 2 [Shu_Dong]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(220,0,0,219,'opticalChannelGroup','Optical Channel Group [Hing_Kam_Lam]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(221,0,0,220,'homepna','HomePNA ITU-T G.989 [Stephen_Palm]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(222,0,0,221,'gfp','Generic Framing Procedure (GFP) [Italo_Busi]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(223,0,0,222,'ciscoISLvlan','Layer 2 Virtual LAN using Cisco ISL [Sandeep_Raghavendra]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(224,0,0,223,'actelisMetaLOOP','Acteleis proprietary MetaLOOP\nHigh Speed Link [Edward_Beili]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(225,0,0,224,'fcipLink','FCIP Link [Anil_Rijhsinghani]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(226,0,0,225,'rpr','Resilient Packet Ring Interface Type [IEEE 802.17]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(227,0,0,226,'qam','RF Qam Interface [Jeyachitra_Alagar]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(228,0,0,227,'lmp','Link Management Protocol [RFC4327]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(229,0,0,228,'cblVectaStar','Cambridge Broadband Networks Limited\nVectaStar [John_Naylon]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(230,0,0,229,'docsCableMCmtsDownstream','CATV Modular CMTS Downstream\nInterface [Eduardo_Cardona][\"Data-Over-Cable Service Interface Specifications:\nM-CMTS Operations Support System Interface Specification,\nCM-SP-M-OSSI-I01-050805\", DOCSIS, August 2005.][http://www.cablemodem.com/specifications][https://www.cablelabs.com/specifications/archives/docsis.html]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(231,0,0,230,'adsl2','Asymmetric Digital Subscriber Loop\nVersion 2 (DEPRECATED - REPLACED\nBY 238) [RFC4706]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(232,0,0,231,'macSecControlledIF','MACSecControlled [Paul_Congdon]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(233,0,0,232,'macSecUncontrolledIF','MACSecUncontrolled [Paul_Congdon]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(234,0,0,233,'aviciOpticalEther','Avici Optical Ethernet Aggregate [Somen_Bhattacharya]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(235,0,0,234,'atmbond','atmbond [https://www.itu.int/rec/T-REC-G.998.1-200501-I/en]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(236,0,0,235,'voiceFGDOS','voice FGD Operator Services [Lizzie_Cheung]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(237,0,0,236,'mocaVersion1','MultiMedia over Coax Alliance [Ladd_Wardani]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(238,0,0,237,'ieee80216WMAN','IEEE 802.16 WMAN interface [http://standards.ieee.org/getieee802/802.16.html]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(239,0,0,238,'adsl2plus','Asymmetric Digital Subscriber Loop\nVersion 2 -- Version 2 Plus and all\nvariants [RFC4706]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(240,0,0,239,'dvbRcsMacLayer','DVB-RCS MAC Layer [RFC5728][ETSI EN 301 790][https://web.archive.org/web/20181229131835/http://satlabs.org/pdf/SatLabs_System_Recommendations_v2.0_M&#38;C.pdf]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(241,0,0,240,'dvbTdm','DVB Satellite TDM [RFC5728][ETSI EN 300 421][ETSI EN 302 307][https://web.archive.org/web/20181229131835/http://satlabs.org/pdf/SatLabs_System_Recommendations_v2.0_M&#38;C.pdf]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(242,0,0,241,'dvbRcsTdma','DVB-RCS TDMA [RFC5728][ETSI EN 301 790][ETSI EN 300 421][https://web.archive.org/web/20181229131835/http://satlabs.org/pdf/SatLabs_System_Recommendations_v2.0_M&#38;C.pdf]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(243,0,0,242,'x86Laps','LAPS based on ITU-T X.86/Y.1323 [Orly_Nicklass][http://grouper.ieee.org/groups/802/3/ad_hoc/etholaps/public/docs/opening_report_0301.pdf]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(244,0,0,243,'wwanPP','3GPP WWAN [Gabriel_Montenegro][https://www.3gpp.org/ftp/specs/archive/23_series/23.060/23060-740.zip]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(245,0,0,244,'wwanPP2','3GPP2 WWAN [Gabriel_Montenegro][http://www.3gpp2.org/Public_html/Specs/C.S0017-005-A_v1.0_040617.pdf]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(246,0,0,245,'voiceEBS','voice P-phone EBS physical interface [Tom_Chou]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(247,0,0,246,'ifPwType','Pseudowire interface type [RFC5601]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(248,0,0,247,'ILAN','Internal LAN on a bridge per IEEE\n802.1ap [Glenn_Parsons][http://www.ieee802.org/1/files/private/ap-drafts/d3/802-1ap-D3-4.pdf]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(249,0,0,248,'PIP','Provider Instance Port on a bridge\nper IEEE 802.1ah PBB [Glenn_Parsons][http://www.ieee802.org/1/files/private/ah-drafts/d4/802-1ah-d4-2.pdf]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(250,0,0,249,'aluELP','Alcatel-Lucent Ethernet Link Protection [Xiaohua_Ma]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(251,0,0,250,'gpon','Gigabit-capable passive optical networks\n(G-PON)  as per ITU-T G.984 [Hyeri_Koh]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(252,0,0,251,'vdsl2','Very high speed digital subscriber\nline Version 2 (as per ITU-T Recommendation\nG.993.2) [Markus_Freudenberger][RFC5650]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(253,0,0,252,'capwapDot11Profile','WLAN Profile Interface [RFC5834]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(254,0,0,253,'capwapDot11Bss','WLAN BSS Interface [RFC5834]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(255,0,0,254,'capwapWtpVirtualRadio','WTP Virtual Radio Interface [RFC5833]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(256,0,0,255,'bits','bitsport [Du_Feng]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(257,0,0,256,'docsCableUpstreamRfPort','DOCSIS CATV Upstream RF\nPort [Michael_Patrick][https://www.cablelabs.com/specifications/CM-SP-EQAM-PMI-I01-081209.pdf]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(258,0,0,257,'cableDownstreamRfPort','CATV downstream RF port [Michael_Patrick]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(259,0,0,258,'vmwareVirtualNic','VMware Virtual Network Interface [Mike_MacFaden]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(260,0,0,259,'ieee802154','IEEE 802.15.4 WPAN interface [Juergen_Schoenwaelde][\"IEEE Std. 802.15.4-2006\", October 2006.]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(261,0,0,260,'otnOdu','OTN Optical Data Unit [Jim_Vance][https://www.itu.int/ITU-T/studygroups/com15/otn/OTNtutorial.pdf]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(262,0,0,261,'otnOtu','OTN Optical channel Transport Unit [Jim_Vance][https://www.itu.int/ITU-T/studygroups/com15/otn/OTNtutorial.pdf]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(263,0,0,262,'ifVfiType','VPLS Forwarding Instance Interface\nType [Manas_Pati]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(264,0,0,263,'g9981','G.998.1 bonded interface [RFC6768][RFC Errata 3591]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(265,0,0,264,'g9982','G.998.2 bonded interface [RFC6767][RFC Errata 3589]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(266,0,0,265,'g9983','G.998.3 bonded interface [RFC6766][RFC Errata 3588]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(267,0,0,266,'aluEpon (E-PON)','Ethernet Passive Optical Networks [Karel_Meijfroidt]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(268,0,0,267,'aluEponOnu','EPON Optical Network Unit [Karel_Meijfroidt]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(269,0,0,268,'aluEponPhysicalUni','EPON physical User to Network\ninterface [Karel_Meijfroidt]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(270,0,0,269,'aluEponLogicalLink','The emulation of a point-to-point\nlink over the EPON layer [Karel_Meijfroidt]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(271,0,0,270,'aluGponOnu','GPON Optical Network Unit [Karel_Meijfroidt][https://www.itu.int/rec/T-REC-G.984.2/en]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(272,0,0,271,'aluGponPhysicalUni','GPON physical User to Network\ninterface [Karel_Meijfroidt][https://www.itu.int/rec/T-REC-G.984.2/en]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(273,0,0,272,'vmwareNicTeam','VMware NIC Team [Michael_MacFaden][https://www.vmware.com/pdf/esx2_NIC_Teaming.pdf]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(274,0,0,273,'Reserved','The corresponding transmission value\nis allocated according to the following\nreference. [RFC6825]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(275,0,0,274,'Reserved','The corresponding transmission value\nis allocated according to the following reference. [RFC7257]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(276,0,0,275,'Reserved','The corresponding transmission value\nis allocated according to the following reference. [RFC7257]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(277,0,0,276,'Reserved','The corresponding transmission value\nis allocated according to the following reference. [RFC7257]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(278,0,0,277,'docsOfdmDownstream','CATV Downstream OFDM interface [https://www.cablelabs.com/specification/cable-modem-operations-support-system-interface-specification][Miguel_O_Alvarez]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(279,0,0,278,'docsOfdmaUpstream','CATV Upstream OFDMA interface [https://www.cablelabs.com/specification/cable-modem-operations-support-system-interface-specification][Miguel_O_Alvarez]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(280,0,0,279,'gfast','G.fast port [ITU-T G.9701]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(281,0,0,280,'sdci','SDCI (IO-Link) [IEC 61131-9 Edition 1.0 2013-09][Markus_Rentschler]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(282,0,0,281,'xboxWireless','Xbox wireless [Brandon_Jiang]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(283,0,0,282,'fastdsl','FastDSL [BBF TR-355][Broadband_Forum]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(284,0,0,283,'docsCableScte55d1FwdOob','Cable SCTE 55-1 OOB Forward Channel [https://www.scte.org/documents/pdf/Standards/ANSI_SCTE-55-1-2009.pdf][Brian_Hedstrom]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(285,0,0,284,'docsCableScte55d1RetOob','Cable SCTE 55-1 OOB Return Channel [https://www.scte.org/documents/pdf/Standards/ANSI_SCTE-55-1-2009.pdf][Brian_Hedstrom]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(286,0,0,285,'docsCableScte55d2DsOob','Cable SCTE 55-2 OOB Downstream Channel [https://web.archive.org/web/20190822104256/http://www.scte.org/documents/pdf/Standards/ANSI_SCTE%2055-2%202008.pdf][Brian_Hedstrom]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(287,0,0,286,'docsCableScte55d2UsOob','Cable SCTE 55-2 OOB Upstream Channel [https://web.archive.org/web/20190822104256/http://www.scte.org/documents/pdf/Standards/ANSI_SCTE%2055-2%202008.pdf][Brian_Hedstrom]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(288,0,0,287,'docsCableNdf','Cable Narrowband Digital Forward [http://www.cablelabs.com/wp-content/uploads/specdocs/CM-SP-R-OOB-I04-160923.pdf][Brian_Hedstrom]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(289,0,0,288,'docsCableNdr','Cable Narrowband Digital Return [http://www.cablelabs.com/wp-content/uploads/specdocs/CM-SP-R-OOB-I04-160923.pdf][Brian_Hedstrom]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(290,0,0,289,'ptm','Packet Transfer Mode [ITU-T G.993.1, Annex H][ITU-T G.993.2][ITU-T G.9701][Broadband_Forum]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(291,0,0,290,'ghn','G.hn port [ITU-T G.9961][Broadband_Forum]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(292,0,0,291,'otnOtsi','Optical Tributary Signal [ITU-T G.959.1][Koteswara_Boyapati]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(293,0,0,292,'otnOtuc','OTN OTUCn [ITU-T G.709/Y.1331][Koteswara_Boyapati]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(294,0,0,293,'otnOduc','OTN ODUC [ITU-T G.709][Koteswara_Boyapati]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(295,0,0,294,'otnOtsig','OTN OTUC Signal [ITU-T G.709][Koteswara_Boyapati]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(296,0,0,295,'microwaveCarrierTermination','air interface of a single microwave carrier [RFC8561]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(297,0,0,296,'microwaveRadioLinkTerminal','radio link interface for one or several aggregated microwave carriers [RFC8561]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(298,0,0,297,'ieee8021axDrni','IEEE 802.1AX Distributed Resilient Network Interface [IEEE 802.1AX-Rev-d2-0][John_Messenger]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(299,0,0,298,'ax25','AX.25 network interfaces [AX.25 Link Access Protocol for Amateur Packet Radio version 2.2][Iain_Learmonth]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(300,0,0,299,'ieee19061nanocom','Nanoscale and Molecular Communication [IEEE 1906.1-2015][Stephen_F_Bush]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(301,0,0,300,'cpri','Common Public Radio Interface [CPRI v7.0][Renwang_Liu]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(302,0,0,301,'omni','Overlay Multilink Network Interface (OMNI) [draft-templin-6man-omni-00][Fred_L_Templin]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(303,0,0,302,'roe','Radio over Ethernet Interface [1914.3-2018 - IEEE Standard for Radio over Ethernet Encapsulations and Mappings][Renwang_Liu]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31'),
(304,0,0,303,'p2pOverLan','Point to Point over LAN interface [RFC9296]',0,NULL,'2024-12-01 14:42:31','2024-12-01 14:42:31');

--
-- Table structure for table `glpi_networkportwifis`
--

CREATE TABLE `glpi_networkportwifis` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `networkports_id` int(10) unsigned NOT NULL DEFAULT 0,
  `items_devicenetworkcards_id` int(10) unsigned NOT NULL DEFAULT 0,
  `wifinetworks_id` int(10) unsigned NOT NULL DEFAULT 0,
  `networkportwifis_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'only useful in case of Managed node',
  `version` varchar(20) DEFAULT NULL COMMENT 'a, a/b, a/b/g, a/b/g/n, a/b/g/n/y',
  `mode` varchar(20) DEFAULT NULL COMMENT 'ad-hoc, managed, master, repeater, secondary, monitor, auto',
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `networkports_id` (`networkports_id`),
  KEY `card` (`items_devicenetworkcards_id`),
  KEY `essid` (`wifinetworks_id`),
  KEY `version` (`version`),
  KEY `mode` (`mode`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `networkportwifis_id` (`networkportwifis_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_networkportwifis`
--


--
-- Table structure for table `glpi_networks`
--

CREATE TABLE `glpi_networks` (
  `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_networks`
--


--
-- Table structure for table `glpi_notepads`
--

CREATE TABLE `glpi_notepads` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `itemtype` varchar(100) DEFAULT NULL,
  `items_id` int(10) unsigned NOT NULL DEFAULT 0,
  `date_creation` timestamp NULL DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `users_id` int(10) unsigned NOT NULL DEFAULT 0,
  `users_id_lastupdater` int(10) unsigned NOT NULL DEFAULT 0,
  `content` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `users_id_lastupdater` (`users_id_lastupdater`),
  KEY `users_id` (`users_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_notepads`
--


--
-- Table structure for table `glpi_notifications`
--

CREATE TABLE `glpi_notifications` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `entities_id` int(10) unsigned NOT NULL DEFAULT 0,
  `itemtype` varchar(100) NOT NULL,
  `event` varchar(255) NOT NULL,
  `comment` text DEFAULT NULL,
  `is_recursive` tinyint(4) NOT NULL DEFAULT 0,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `allow_response` tinyint(4) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `itemtype` (`itemtype`),
  KEY `entities_id` (`entities_id`),
  KEY `is_active` (`is_active`),
  KEY `date_mod` (`date_mod`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
