-- Table structure for table `glpi_fieldblacklists`
--

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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

INSERT INTO `glpi_groups` VALUES (3,0,0,'Evolve','',NULL,NULL,NULL,'2023-10-23 19:33:49',0,'Evolve',1,'[]','{\"3\":3}',1,1,1,1,0,1,1,1,'2023-06-20 12:55:08'),(4,0,0,'Viterra','',NULL,NULL,NULL,'2023-10-23 19:33:49',0,'Viterra',1,'[]','{\"4\":4}',1,1,1,1,0,1,1,0,'2023-06-20 16:10:57'),(5,0,0,'Hypermarcas','',NULL,NULL,NULL,'2023-10-23 19:33:49',0,'Hypermarcas',1,'[]','{\"5\":5}',1,1,1,1,0,1,1,0,'2023-06-20 16:12:14'),(6,0,0,'Petros','',NULL,NULL,NULL,'2023-10-23 19:33:49',0,'Petros',1,'[]','{\"6\":6}',1,1,1,1,0,1,1,0,'2023-06-20 16:13:30'),(7,0,0,'Hospital Albert Einstein','',NULL,NULL,NULL,'2023-10-23 19:33:49',0,'Hospital Albert Einstein',1,'[]','{\"7\":7}',1,1,1,1,0,1,1,0,'2023-06-20 16:14:36'),(8,0,0,'Orizon','',NULL,NULL,NULL,'2023-10-23 19:33:49',0,'Orizon',1,'[]','{\"8\":8}',1,1,1,1,0,1,1,0,'2023-06-20 16:19:57'),(9,0,0,'CNU - Unimed','',NULL,NULL,NULL,'2023-10-23 19:33:34',0,'CNU - Unimed',1,'[]','{\"9\":9}',1,1,1,1,0,0,1,1,'2023-10-19 12:13:26'),(10,0,0,'Stone','',NULL,NULL,NULL,'2024-01-19 13:29:53',0,'Stone',1,'[]',NULL,1,1,1,1,1,1,1,1,'2024-01-19 13:29:53');

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

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

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


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

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

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

INSERT INTO `glpi_groups_problems` VALUES (1,1,8,1);

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

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

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


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

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

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


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

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

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

INSERT INTO `glpi_groups_tickets` VALUES (47,27,3,1),(2,28,3,1),(105,28,7,1),(51,30,3,1),(106,30,7,1),(50,31,3,1),(48,32,3,1),(107,32,7,1),(7,2023092901,3,1),(108,2023092901,7,1),(8,2023092902,3,1),(109,2023092902,7,1),(9,2023092903,3,1),(110,2023092903,7,1),(10,2023092904,3,1),(111,2023092904,7,1),(11,2023092905,3,1),(112,2023092905,7,1),(12,2023092906,3,1),(113,2023092906,7,1),(13,2023092907,3,1),(114,2023092907,7,1),(14,2023092908,3,1),(15,2023092909,3,1),(115,2023092909,7,1),(16,2023092910,3,1),(116,2023092910,7,1),(17,2023092911,3,1),(117,2023092911,7,1),(18,2023092912,3,1),(118,2023092912,7,1),(19,2023092913,3,1),(119,2023092913,7,1),(20,2023092914,3,1),(120,2023092914,7,1),(21,2023092915,3,1),(121,2023092915,7,1),(22,2023092916,3,1),(23,2023092917,3,1),(122,2023092917,7,1),(24,2023092918,3,1),(25,2023092920,3,1),(26,2023092921,3,1),(27,2023092922,3,1),(28,2023092923,3,1),(29,2023092924,3,1),(30,2023092925,3,1),(31,2023092926,3,1),(32,2023092927,3,1),(33,2023092928,3,1),(34,2023092929,3,1),(35,2023092930,3,1),(36,2023092931,3,1),(37,2023092932,3,1),(38,2023092933,3,1),(39,2023092934,3,1),(40,2023092935,3,1),(41,2023092937,3,1),(42,2023092938,3,1),(43,2023092939,3,1),(44,2023092940,3,1),(45,2023092941,3,1),(46,2023092942,3,1),(52,2023100202,3,1),(53,2023100203,3,1),(123,2023100203,7,1),(54,2023100204,3,1),(55,2023100205,3,1),(124,2023100205,7,1),(56,2023100206,3,1),(57,2023100207,3,1),(125,2023100207,7,1),(58,2023100208,3,1),(59,2023100209,3,1),(126,2023100209,7,1),(60,2023100210,3,1),(61,2023100211,3,1),(127,2023100211,7,1),(62,2023100212,3,1),(128,2023100212,7,1),(63,2023100213,3,1),(129,2023100213,7,1),(64,2023100214,3,1),(65,2023100215,3,1),(130,2023100215,7,1),(66,2023100216,3,1),(131,2023100216,7,1),(67,2023100217,3,1),(132,2023100217,7,1),(68,2023100218,3,1),(133,2023100218,7,1),(69,2023100219,3,1),(70,2023100220,3,1),(134,2023100220,7,1),(71,2023100221,3,1),(135,2023100221,7,1),(72,2023100222,3,1),(136,2023100222,7,1),(73,2023100223,3,1),(137,2023100223,7,1),(74,2023100224,3,1),(75,2023100225,3,1),(138,2023100225,7,1),(76,2023100226,3,1),(139,2023100226,7,1),(77,2023100227,3,1),(140,2023100227,7,1),(78,2023100228,3,1),(141,2023100230,3,1),(80,2023100230,7,1),(142,2023100231,3,1),(81,2023100231,7,1),(143,2023100232,3,1),(82,2023100232,7,1),(144,2023100233,3,1),(83,2023100233,7,1),(145,2023100234,3,1),(84,2023100234,7,1),(146,2023100235,3,1),(85,2023100235,7,1),(147,2023100236,3,1),(86,2023100236,7,1),(148,2023100237,3,1),(87,2023100237,7,1),(149,2023100238,3,1),(88,2023100238,7,1),(150,2023100239,3,1),(89,2023100239,7,1),(151,2023100240,3,1),(90,2023100240,7,1),(152,2023100301,3,1),(91,2023100301,7,1),(153,2023100302,3,1),(92,2023100302,7,1),(154,2023100303,3,1),(93,2023100303,7,1),(155,2023100304,3,1),(94,2023100304,7,1),(156,2023100305,3,1),(95,2023100305,7,1),(157,2023100306,3,1),(96,2023100306,7,1),(158,2023100307,3,1),(97,2023100307,7,1),(159,2023100308,3,1),(98,2023100308,7,1),(160,2023100309,3,1),(99,2023100309,7,1),(161,2023100310,3,1),(100,2023100310,7,1),(162,2023100311,3,1),(101,2023100311,7,1),(163,2023100312,3,1),(102,2023100312,7,1),(164,2023100313,3,1),(103,2023100313,7,1),(165,2023100314,3,1),(104,2023100314,7,1),(167,2023100902,3,1),(175,2023100902,7,1),(169,2023100904,7,1),(170,2023100905,7,1),(174,2023100908,7,1),(173,2023100908,7,2),(182,2023101002,7,1),(183,2023101101,7,1),(184,2023101102,7,1),(185,2023101103,7,1),(186,2023101104,7,1),(187,2023101105,7,1),(188,2023101202,7,1),(189,2023101203,7,1),(190,2023101602,7,1),(176,2023101801,8,1),(177,2023101802,8,1),(178,2023101901,3,1),(181,2023102303,7,1),(194,2023102501,8,1),(195,2023102502,7,1),(196,2023110701,7,1),(197,2023111001,7,1),(199,2023111002,7,1),(198,2023111003,7,1),(201,2023111301,7,1),(200,2023111302,7,1),(203,2023112101,7,1),(202,2023112102,7,1),(204,2023112301,7,1),(205,2023113001,7,1),(208,2023113002,7,1),(206,2023113003,7,1),(207,2023113004,7,1),(209,2023121801,7,1),(210,2023121901,7,1),(211,2023122101,7,1),(213,2023122601,7,1),(212,2023122602,7,1),(215,2024010501,7,1),(214,2024010502,7,1),(216,2024011201,3,1),(217,2024013101,6,1),(218,2024013102,4,1),(219,2024020101,6,1),(220,2024020501,8,1),(221,2024020601,7,1),(223,2024031101,7,1),(224,2024031301,7,1),(230,2024031501,6,1),(229,2024031502,6,1),(228,2024031503,6,1),(227,2024031504,6,1),(226,2024031505,6,1),(225,2024031506,6,1),(231,2024031508,6,1),(236,2024032201,7,1),(237,2024032801,6,1),(238,2024040101,7,1),(239,2024040201,7,1),(240,2024040401,6,1),(242,2024041201,7,1),(243,2024041601,7,1),(245,2024042901,4,1),(247,2024051301,7,1),(246,2024051401,6,1),(248,2024060701,4,1),(249,2024061101,4,1),(250,2024061701,4,1),(251,2024061901,4,1),(252,2024062501,4,1),(253,2024062502,4,1);

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

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

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

INSERT INTO `glpi_groups_users` VALUES (3,10,3,0,1,1),(5,19,3,0,1,1),(7,13,4,0,0,0),(9,15,5,0,0,0),(10,8,6,0,0,0),(11,18,6,0,0,0),(13,16,5,0,0,0),(15,14,4,0,0,0),(16,12,8,0,0,0),(22,23,3,0,0,0),(23,29,7,0,1,0),(24,31,7,0,0,0),(25,24,7,0,0,0),(26,28,7,0,0,0),(27,30,7,0,0,0),(28,32,9,0,0,0),(29,33,9,0,0,0),(30,36,9,0,0,0),(31,35,9,0,0,0),(32,34,9,0,0,0),(33,37,9,0,0,0),(34,38,9,0,0,0),(35,39,9,0,0,0),(36,40,9,0,0,0),(37,42,10,0,1,1),(38,45,4,0,1,0),(39,44,4,0,0,0),(40,46,3,0,0,0);

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

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

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


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

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

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


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

CREATE TABLE `glpi_imageresolutions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_video` tinyint(4) NOT NULL DEFAULT '0',
  `date_mod` timestamp NULL DEFAULT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci,
  `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) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `color` varchar(255) COLLATE utf8mb4_unicode_ci 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 COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `depends_color` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `impact_and_depends_color` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `glpi_impactitems` VALUES (1,'Software',1,0,0,1),(2,'Computer',1,0,0,1);

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

CREATE TABLE `glpi_impactrelations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `itemtype_source` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `items_id_source` int(10) unsigned NOT NULL DEFAULT '0',
  `itemtype_impacted` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `suppliers_id` int(10) unsigned NOT NULL DEFAULT '0',
  `order_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delivery_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `immo_number` varchar(255) COLLATE utf8mb4_unicode_ci 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 COLLATE utf8mb4_unicode_ci,
  `bill` varchar(255) COLLATE utf8mb4_unicode_ci 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 AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `glpi_infocoms` VALUES (1,1,'Software',0,0,NULL,NULL,0,NULL,0,NULL,NULL,NULL,0.0000,0.0000,0,0,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,'2023-06-19 18:52:33','2023-06-19 18:52:33',NULL,0),(2,1,'SoftwareLicense',0,0,NULL,NULL,0,NULL,0,NULL,NULL,NULL,0.0000,0.0000,0,0,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,'2023-06-19 19:04:11','2023-06-19 19:04:11',NULL,0),(3,2,'SoftwareLicense',0,1,NULL,NULL,0,NULL,0,NULL,NULL,NULL,0.0000,0.0000,0,0,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,'2023-06-20 13:36:03','2023-06-20 13:36:03',NULL,0),(4,3,'SoftwareLicense',0,1,NULL,NULL,0,NULL,0,NULL,NULL,NULL,0.0000,0.0000,0,0,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,'2023-06-20 13:36:03','2023-06-20 13:36:03',NULL,0),(5,4,'SoftwareLicense',0,1,NULL,NULL,0,NULL,0,NULL,NULL,NULL,0.0000,0.0000,0,0,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,'2023-06-20 13:36:03','2023-06-20 13:36:03',NULL,0),(6,5,'SoftwareLicense',0,0,NULL,NULL,0,NULL,0,NULL,NULL,NULL,0.0000,0.0000,0,0,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,'2023-06-20 13:42:20','2023-06-20 13:42:20',NULL,0),(7,2,'Software',0,0,NULL,NULL,0,NULL,0,NULL,NULL,NULL,0.0000,0.0000,0,0,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,'2023-06-20 13:49:59','2023-06-20 13:49:59',NULL,0),(8,6,'SoftwareLicense',0,0,NULL,NULL,0,NULL,0,NULL,NULL,NULL,0.0000,0.0000,0,0,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,'2023-06-20 13:52:20','2023-06-20 13:52:20',NULL,0),(9,7,'SoftwareLicense',0,0,NULL,NULL,0,NULL,0,NULL,NULL,NULL,0.0000,0.0000,0,0,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,'2023-06-20 13:56:02','2023-06-20 13:56:02',NULL,0),(10,8,'SoftwareLicense',0,0,NULL,NULL,0,NULL,0,NULL,NULL,NULL,0.0000,0.0000,0,0,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,'2023-06-20 14:03:49','2023-06-20 14:03:49',NULL,0),(11,9,'SoftwareLicense',0,0,NULL,NULL,0,NULL,0,NULL,NULL,NULL,0.0000,0.0000,0,0,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,'2023-06-20 14:04:28','2023-06-20 14:04:28',NULL,0),(12,1,'Computer',0,0,NULL,NULL,0,NULL,0,NULL,NULL,NULL,0.0000,0.0000,0,0,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,'2023-10-04 13:30:42','2023-10-04 13:30:42',NULL,0),(13,2,'Computer',0,0,NULL,NULL,0,NULL,0,NULL,NULL,NULL,0.0000,0.0000,0,0,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,'2023-10-04 13:42:44','2023-10-04 13:42:44',NULL,0),(14,10,'SoftwareLicense',0,0,NULL,NULL,0,NULL,0,NULL,NULL,NULL,0.0000,0.0000,0,0,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,'2024-06-05 14:20:00','2024-06-05 14:20:00',NULL,0);

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

CREATE TABLE `glpi_interfacetypes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci,
  `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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `version` tinyint(3) unsigned DEFAULT '0',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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 COLLATE utf8mb4_unicode_ci,
  `level` int(11) NOT NULL DEFAULT '0',
  `ancestors_cache` longtext COLLATE utf8mb4_unicode_ci,
  `sons_cache` longtext COLLATE utf8mb4_unicode_ci,
  `addressable` tinyint(4) NOT NULL DEFAULT '0',
  `version` tinyint(3) unsigned DEFAULT '0',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(40) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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 COLLATE utf8mb4_unicode_ci,
  `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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otherserial` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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',
  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 `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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otherserial` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `busID` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otherserial` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `busID` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otherserial` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otherserial` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otherserial` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `busID` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otherserial` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deviceharddrives_id` int(10) unsigned NOT NULL DEFAULT '0',
  `capacity` int(11) NOT NULL DEFAULT '0',
  `serial` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otherserial` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `devicememories_id` int(10) unsigned NOT NULL DEFAULT '0',
  `size` int(11) NOT NULL DEFAULT '0',
  `serial` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otherserial` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otherserial` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `devicenetworkcards_id` int(10) unsigned NOT NULL DEFAULT '0',
  `mac` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `busID` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otherserial` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `busID` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otherserial` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otherserial` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deviceprocessors_id` int(10) unsigned NOT NULL DEFAULT '0',
  `frequency` int(11) NOT NULL DEFAULT '0',
  `serial` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otherserial` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otherserial` varchar(255) COLLATE utf8mb4_unicode_ci 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_devicesimcards`
--

CREATE TABLE `glpi_items_devicesimcards` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'RELATION to various table, according to itemtype (id)',
  `itemtype` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `devicesimcards_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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otherserial` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `states_id` int(10) unsigned NOT NULL DEFAULT '0',
  `locations_id` int(10) unsigned NOT NULL DEFAULT '0',
  `lines_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',
  `pin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `pin2` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `puk` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `puk2` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `msin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `comment` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `devicesimcards_id` (`devicesimcards_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 `otherserial` (`otherserial`),
  KEY `states_id` (`states_id`),
  KEY `locations_id` (`locations_id`),
  KEY `lines_id` (`lines_id`),
  KEY `users_id` (`users_id`),
  KEY `groups_id` (`groups_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_items_devicesimcards`
--


--
-- 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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `busID` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otherserial` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `items_id` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mountpoint` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `filesystems_id` int(10) unsigned NOT NULL DEFAULT '0',
  `totalsize` int(11) NOT NULL DEFAULT '0',
  `freesize` int(11) 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `encryption_algorithm` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `encryption_type` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `items_id` int(10) unsigned DEFAULT NULL,
  `users_id` int(10) unsigned NOT NULL,
  `state` text COLLATE utf8mb4_unicode_ci,
  `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 AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `glpi_items_kanbans` VALUES (1,'Project',0,19,'{\"0\":{\"column\":\"0\",\"folded\":\"false\",\"cards\":{\"0\":\"Project-1\"}}}','2023-09-27 14:25:47','2023-09-27 14:25:47'),(2,'Project',1,0,'{\"0\":{\"column\":\"0\",\"folded\":true},\"1\":{\"column\":\"1\",\"visible\":true,\"folded\":false,\"cards\":{}},\"2\":{\"column\":\"2\",\"visible\":true,\"folded\":false,\"cards\":{\"0\":\"ProjectTask-36\"}},\"3\":{\"column\":\"3\",\"visible\":true,\"folded\":false,\"cards\":{}}}','2024-01-18 17:18:29','2023-10-04 12:53:27'),(3,'Project',3,0,'{\"0\":{\"column\":\"0\",\"folded\":\"false\"},\"1\":{\"column\":\"1\",\"folded\":\"false\",\"cards\":{\"0\":\"ProjectTask-12\",\"1\":\"ProjectTask-17\",\"2\":\"ProjectTask-18\",\"3\":\"ProjectTask-19\"}},\"2\":{\"column\":\"2\",\"folded\":\"false\",\"cards\":{\"0\":\"ProjectTask-3\",\"1\":\"ProjectTask-4\",\"2\":\"ProjectTask-7\"}},\"3\":{\"column\":\"3\",\"folded\":\"false\",\"cards\":{\"0\":\"ProjectTask-2\",\"1\":\"ProjectTask-5\",\"2\":\"ProjectTask-6\",\"3\":\"ProjectTask-8\",\"4\":\"ProjectTask-9\",\"5\":\"ProjectTask-10\",\"6\":\"ProjectTask-11\",\"7\":\"ProjectTask-13\",\"8\":\"ProjectTask-14\",\"9\":\"ProjectTask-15\",\"10\":\"ProjectTask-16\"}}}','2023-10-05 18:13:42','2023-10-05 18:13:42'),(4,'Project',0,26,'{\"0\":{\"column\":\"0\",\"folded\":\"false\",\"cards\":{\"0\":\"Project-1\",\"1\":\"Project-3\"}},\"1\":{\"column\":\"1\",\"folded\":\"false\",\"cards\":{\"0\":\"ProjectTask-12\",\"1\":\"ProjectTask-17\",\"2\":\"ProjectTask-18\",\"3\":\"ProjectTask-19\"}},\"2\":{\"column\":\"2\",\"folded\":\"false\",\"cards\":{\"0\":\"Project-2\",\"1\":\"ProjectTask-3\",\"2\":\"ProjectTask-4\",\"3\":\"ProjectTask-7\",\"4\":\"ProjectTask-20\"}},\"3\":{\"column\":\"3\",\"folded\":\"false\",\"cards\":{\"0\":\"ProjectTask-2\",\"1\":\"ProjectTask-5\",\"2\":\"ProjectTask-6\",\"3\":\"ProjectTask-8\",\"4\":\"ProjectTask-9\",\"5\":\"ProjectTask-10\",\"6\":\"ProjectTask-11\",\"7\":\"ProjectTask-13\",\"8\":\"ProjectTask-14\",\"9\":\"ProjectTask-15\",\"10\":\"ProjectTask-16\"}}}','2023-10-05 18:24:24','2023-10-05 18:24:24'),(5,'Project',5,0,'{\"0\":{\"column\":\"0\",\"folded\":\"false\"}}','2023-10-19 12:18:44','2023-10-19 12:18:44'),(6,'Project',0,10,'{\"0\":{\"column\":\"0\",\"folded\":\"false\",\"cards\":{\"0\":\"ProjectTask-35\"}},\"1\":{\"column\":\"2\",\"folded\":\"false\",\"cards\":{\"0\":\"Project-1\",\"1\":\"Project-2\",\"2\":\"Project-3\",\"3\":\"Project-4\",\"4\":\"Project-5\"}},\"2\":{\"column\":\"3\",\"folded\":\"false\",\"cards\":{\"0\":\"ProjectTask-2\",\"1\":\"ProjectTask-3\",\"2\":\"ProjectTask-4\",\"3\":\"ProjectTask-5\",\"4\":\"ProjectTask-6\",\"5\":\"ProjectTask-7\",\"6\":\"ProjectTask-8\",\"7\":\"ProjectTask-9\",\"8\":\"ProjectTask-10\",\"9\":\"ProjectTask-11\",\"10\":\"ProjectTask-13\",\"11\":\"ProjectTask-14\",\"12\":\"ProjectTask-15\",\"13\":\"ProjectTask-16\",\"14\":\"ProjectTask-17\",\"15\":\"ProjectTask-18\",\"16\":\"ProjectTask-19\",\"17\":\"ProjectTask-20\",\"18\":\"ProjectTask-21\",\"19\":\"ProjectTask-22\",\"20\":\"ProjectTask-23\",\"21\":\"ProjectTask-24\",\"22\":\"ProjectTask-25\",\"23\":\"ProjectTask-26\",\"24\":\"ProjectTask-27\",\"25\":\"ProjectTask-28\",\"26\":\"ProjectTask-29\",\"27\":\"ProjectTask-30\",\"28\":\"ProjectTask-31\",\"29\":\"ProjectTask-32\",\"30\":\"ProjectTask-33\",\"31\":\"ProjectTask-34\"}},\"3\":{\"column\":\"1\",\"visible\":true,\"folded\":false,\"cards\":{}}}','2024-01-12 17:43:52','2024-01-08 19:42:16'),(7,'Project',2,0,'{\"0\":{\"column\":\"0\",\"folded\":false},\"1\":{\"column\":\"3\",\"folded\":false,\"cards\":{\"0\":\"ProjectTask-33\",\"1\":\"ProjectTask-34\"}}}','2024-01-12 17:22:51','2024-01-12 17:17:17');

--
-- 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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `licenseid` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `items_id` int(10) unsigned NOT NULL,
  `position` int(11) NOT NULL,
  `orientation` tinyint(4) DEFAULT NULL,
  `bgcolor` varchar(7) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `items_id` int(10) unsigned NOT NULL DEFAULT '0',
  `remoteid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `completename` text COLLATE utf8mb4_unicode_ci,
  `comment` text COLLATE utf8mb4_unicode_ci,
  `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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ancestors_cache` longtext COLLATE utf8mb4_unicode_ci,
  `sons_cache` longtext COLLATE utf8mb4_unicode_ci,
  `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=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `glpi_itilcategories` VALUES (1,0,0,0,'HOPEX - Dúvidas Gerais','HOPEX - Dúvidas Gerais','',1,0,0,0,'','[]','{\"1\":1}',1,0,0,0,0,1,1,1,1,'2023-08-28 12:45:20','2023-08-28 12:45:20'),(2,0,0,0,'HOPEX - Manutenção','HOPEX - Manutenção','',1,0,0,0,'','[]','{\"2\":2}',1,0,0,0,0,1,1,1,1,'2023-08-28 12:45:37','2023-08-28 12:45:37'),(3,0,0,0,'HOPEX - Bugs','HOPEX - Bugs','',1,0,0,0,'','[]','{\"3\":3}',1,0,0,0,0,1,1,1,1,'2023-08-28 12:45:45','2023-08-28 12:45:45'),(4,0,0,0,'HOPEX - Customização','HOPEX - Customização','',1,0,0,0,'','[]','{\"4\":4}',1,0,0,0,0,1,1,1,1,'2023-08-28 12:45:58','2023-08-28 12:45:58'),(5,0,0,0,'HOPEX - Atualização de Versão','HOPEX - Atualização de Versão','',1,0,0,0,'','[]','{\"5\":5}',1,0,0,0,0,1,1,1,1,'2023-08-28 12:46:11','2023-08-28 12:46:11'),(6,0,0,0,'HOPEX - Automação/Scripts','HOPEX - Automação/Scripts','',1,0,0,0,'','[]','{\"6\":6}',1,0,0,0,0,1,1,1,1,'2023-08-28 12:46:22','2023-08-28 12:46:22'),(7,0,0,0,'HOPEX - Aplicação','HOPEX - Aplicação','',1,0,0,0,'','[]','{\"7\":7}',1,0,0,0,0,1,1,1,1,'2023-08-28 12:46:34','2023-08-28 12:46:34'),(8,0,0,0,'HOPEX - Usuário','HOPEX - Usuário','',1,0,0,0,'','[]','{\"8\":8}',1,0,0,0,0,1,1,1,1,'2023-10-04 14:15:45','2023-10-04 14:15:45'),(9,0,0,0,'HOPEX - Desenvolvimento','HOPEX - Desenvolvimento','',1,0,0,0,'','[]','{\"9\":9}',0,0,0,0,0,1,1,1,1,'2023-10-24 18:11:34','2023-10-24 18:11:34'),(10,0,0,0,'HOPEX - Hopex360','HOPEX - Hopex360','',1,0,0,0,'','[]','{\"10\":10}',1,0,0,0,0,1,1,1,1,'2023-10-25 13:14:07','2023-10-25 13:14:07'),(11,0,0,0,'Qualiware - Assuntos Gerais','Qualiware - Assuntos Gerais','',1,0,0,0,'','[]','{\"11\":11}',1,0,0,0,0,1,1,1,1,'2024-02-07 14:49:39','2024-02-07 14:49:39');

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

CREATE TABLE `glpi_itilfollowups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `itemtype` varchar(100) COLLATE utf8mb4_unicode_ci 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 COLLATE utf8mb4_unicode_ci,
  `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=171 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `glpi_itilfollowups` VALUES (36,'Ticket',28,'2023-09-18 20:08:17',2,0,'&#60;p&#62;HI @PINEDA José Juan, this issue is present in the DEV Environment, so you can proceed with the repair at any time, as long as it is not Brazilian Business Hours (8AM – 6PM).&#60;/p&#62;\r\n&#60;p&#62;Aguardando posição da MEGA&#60;/p&#62;\r\n&#60;p&#62;Data 15/09/23&#60;br&#62;Resposta de Marcelo Takashi&#60;/p&#62;',0,1,'2023-09-18 20:08:17','2023-09-18 20:08:17',1,0,0),(37,'Ticket',125,'2023-09-27 20:44:06',12,0,'&#60;p&#62;oi&#60;/p&#62;',0,0,'2023-09-27 20:44:06','2023-09-27 20:44:06',1,0,0),(38,'Ticket',125,'2023-09-27 20:48:13',2,0,'&#60;p&#62;Olá Pedro,&#60;/p&#62;\r\n&#60;p&#62;Realizamos o desbloqueio&#60;/p&#62;',0,1,'2023-09-27 20:48:13','2023-09-27 20:48:13',1,0,0),(40,'Ticket',125,'2023-09-29 18:23:51',10,0,'&#60;p&#62;Usuário desbloqueado e senha redefinida!! Ajustamos também o perfil do usuário.&#60;/p&#62;',0,1,'2023-09-29 18:23:51','2023-09-29 18:23:51',4,0,0),(41,'Ticket',2023101002,'2023-10-14 15:10:21',24,0,'&#60;p&#62;Atualizada a planilha. Agora com 196 itens.&#60;br&#62;&#60;br&#62;Utilizar Link:&#60;/p&#62;\r\n&#60;p&#62;&#60;a href=\"https://sbibae.sharepoint.com/:x:/r/sites/TimedeArquitetura-TransformaoDigital/Documentos%20Compartilhados/General/2023%20-%20Projeto%20Implanta%C3%A7%C3%A3o%20Hopex/Portf%C3%B3lio%20de%20Tecnologias%20e%20Sistemas/Rela%C3%A7%C3%A3o%20de%20Sistemas%20Consolidado%20-%20Carga%20DePara%20Marcelo%2014102023.xlsx?d=w1b87b68a6f684785a16a2b06711a1676&#38;amp;csf=1&#38;amp;web=1&#38;amp;e=VT989x\"&#62;Relação de Sistemas Consolidado - Carga DePara Marcelo 14102023.xlsx&#60;/a&#62;&#60;/p&#62;',0,0,'2023-10-14 15:10:21','2023-10-14 15:10:21',1,0,0),(42,'Ticket',2023101601,'2023-10-21 00:18:21',21,0,'&#60;p&#62;O MCS realizou um reinício dos serviços do HOPEX, e o SSO voltou a funcionar&#60;/p&#62;',0,1,'2023-10-21 00:18:21','2023-10-21 00:18:21',4,0,0),(43,'Ticket',2023101201,'2023-10-21 00:43:31',21,0,'&#60;p&#62;Para a exclusão de uma aplicação no IT Architecture é necessário que ele não esteja presente em nenhum portfólio.&#60;/p&#62;\r\n&#60;p&#62;Mas, como solução de contorno você poderia realizar a exclusão com o perfil de \"IT Business Manager\" (Responsável da informática da função de trabalho)&#60;/p&#62;',0,1,'2023-10-21 00:43:31','2023-10-21 00:43:31',4,0,0),(44,'Ticket',2023101001,'2023-10-21 01:46:47',21,0,'&#60;p&#62;A geração automática no Enterprise Portal já está trazendo a as informações de Portifólio de Aplicações e Tecnologias.&#60;/p&#62;',0,1,'2023-10-21 01:46:47','2023-10-21 01:46:47',4,0,0),(45,'Ticket',2023101102,'2023-10-24 17:31:29',10,0,'&#60;p&#62;Olá Gustavo, boa tarde!&#60;/p&#62;\r\n&#60;p&#62;Ja realizamos a abertura do chamado para a MEGA, iremos te atualizar neste chamado com a resposta.&#60;/p&#62;',0,1,'2023-10-24 17:31:29','2023-10-24 17:31:29',1,0,0),(46,'Ticket',2023101202,'2023-10-24 18:17:54',10,0,'&#60;p&#62;Olá pessoal, enviamos essa solicitação para MEGA e tivemos a seguinte resposta:&#60;/p&#62;\r\n&#60;p class=\"x_MsoNormal\"&#62;I have a couple of points to discuss with you:&#60;/p&#62;\r\n&#60;ol start=\"1\" type=\"1\"&#62;\r\n&#60;li class=\"x_MsoNormal\"&#62;I would like to gain a better understanding of the necessity for downalignment. Is there something specific that you need to replicate in the lower environments?&#60;/li&#62;\r\n&#60;li class=\"x_MsoNormal\"&#62;It is crucial to note that it is NOT recommended to exclusively move Data repositories without also transferring the SystemDb. This is because there are interdependencies between them, and separating them in this manner could potentially lead to various issues in the target environments.&#60;/li&#62;\r\n&#60;/ol&#62;\r\n&#60;p class=\"x_MsoNormal\"&#62;&#60;br aria-hidden=\"true\"&#62;To assist you more effectively, please provide further details regarding your requirements.&#60;/p&#62;\r\n&#60;p class=\"x_MsoNormal\"&#62;Ou seja, não é recomendado mover exclusivamente repositórios de dados sem transferir também o SystemDb. Isso ocorre porque existem interdependências entre eles e separá-los dessa maneira poderia levar a vários problemas nos ambientes de destino.&#60;/p&#62;\r\n&#60;p class=\"x_MsoNormal\"&#62; &#60;/p&#62;\r\n&#60;p class=\"x_MsoNormal\"&#62; &#60;/p&#62;',0,1,'2023-10-24 18:17:54','2023-10-24 18:17:54',1,0,0),(47,'Ticket',2023101203,'2023-10-24 18:37:56',10,0,'&#60;p&#62;Olá Gustavo,&#60;/p&#62;\r\n&#60;p&#62;Estivemos em contato com a MEGA, foi realizado uma reunião ontem e disseram que vao finalizar alguns ajustes e testar com usuário novo. Iremos atualizar esse chamado com o andamento!!&#60;/p&#62;',0,1,'2023-10-24 18:37:56','2023-10-24 18:37:56',1,0,0),(48,'Ticket',2023101602,'2023-10-24 18:47:53',10,0,'&#60;p&#62;Olá Gustavo,&#60;/p&#62;\r\n&#60;p&#62;Isso se trata de uma melhoria na ferramenta, podemos informar isso para o pessoal da MEGA, mas não se trata de um chamado e sim uma customização na ferramenta por parte deles.&#60;/p&#62;',0,1,'2023-10-24 18:47:53','2023-10-24 18:47:53',1,0,0),(49,'Ticket',2023102303,'2023-10-25 14:17:57',28,0,'Solução aprovada',0,2023102303,'2023-10-25 14:17:57','2023-10-25 14:17:57',1,0,0),(50,'Ticket',2023101602,'2023-10-25 14:20:59',28,0,'&#60;p&#62;Sendo assim, solicitamos esta customização e um prazo de atendimento.&#60;/p&#62;',0,0,'2023-10-25 14:20:59','2023-10-25 14:20:59',1,0,0),(51,'Ticket',2023101203,'2023-10-25 14:21:40',28,0,'&#60;p&#62;Favor informar prazo de atendimento&#60;/p&#62;',0,0,'2023-10-25 14:21:40','2023-10-25 14:21:40',1,0,0),(52,'Ticket',2023101202,'2023-10-25 14:23:54',28,0,'&#60;p&#62;Preciso que os ambientes estejam equalizados a fim de garantir que as criações em DEV reflitam os mesmos resultados em prod&#60;/p&#62;',0,0,'2023-10-25 14:23:54','2023-10-25 14:23:54',1,0,0),(53,'Ticket',2023101101,'2023-10-25 14:24:56',28,0,'&#60;p&#62;Sim, fazer os ajustes nos 3 ambientes&#60;/p&#62;',0,0,'2023-10-25 14:24:56','2023-10-25 14:24:56',1,0,0),(54,'Ticket',2023101102,'2023-10-25 14:25:40',28,0,'&#60;p&#62;Alguma previsão de conclusão?&#60;/p&#62;',0,0,'2023-10-25 14:25:40','2023-10-25 14:25:40',1,0,0),(55,'Ticket',2023101102,'2023-10-25 19:09:54',10,0,'&#60;p&#62;Olá Roberta, &#60;/p&#62;\r\n&#60;p&#62;Recebemos a resposta da MEGA nos informando que ainda não é possivel e não há uma previsão de realizar a tradução para o idioma Português, atualmente só está disponivel para FR, EN e ES. &#60;/p&#62;',0,1,'2023-10-25 19:09:54','2023-10-25 19:09:54',1,0,0),(56,'Ticket',2023101202,'2023-10-25 19:39:46',10,0,'&#60;p&#62;Oi Roberta,&#60;/p&#62;\r\n&#60;p&#62;Para dar seguimento nesse chamado sugerimos agendar uma reunião para melhor entendimento!! Poderia nos informar algumas datas?&#60;/p&#62;',0,1,'2023-10-25 19:39:46','2023-10-25 19:39:46',1,0,0),(57,'Ticket',2023102502,'2023-10-26 11:51:44',10,0,'&#60;p&#62;Olá Roberta,&#60;/p&#62;\r\n&#60;p&#62;Irei fazer realizar o encaminhamento dessa solicitação para a MEGA.&#60;/p&#62;',0,1,'2023-10-26 11:51:44','2023-10-26 11:51:44',1,0,0),(58,'Ticket',2023101101,'2023-10-27 17:10:43',10,0,'&#60;p&#62;Olá Roberta,&#60;/p&#62;\r\n&#60;p&#62;Esse chamado foi atualizado e encaminhado para o Marcelo, ele tomará conta dessa customização, ok?&#60;/p&#62;',0,1,'2023-10-27 17:10:43','2023-10-27 17:10:43',1,0,0),(59,'Ticket',2023101103,'2023-10-27 17:11:06',10,0,'&#60;p&#62;Olá Gustavo,&#60;/p&#62;\r\n&#60;p&#62;Esse chamado foi atualizado e encaminhado para o Marcelo, ele tomará conta dessa customização, ok?&#60;/p&#62;',0,1,'2023-10-27 17:11:06','2023-10-27 17:11:06',1,0,0),(60,'Ticket',2023101104,'2023-10-27 17:11:18',10,0,'&#60;p&#62;Olá Gustavo,&#60;/p&#62;\r\n&#60;p&#62;Esse chamado foi atualizado e encaminhado para o Marcelo, ele tomará conta dessa customização, ok?&#60;/p&#62;',0,1,'2023-10-27 17:11:18','2023-10-27 17:11:18',1,0,0),(61,'Ticket',2023101105,'2023-10-27 17:11:30',10,0,'&#60;p&#62;Olá Gustavo,&#60;/p&#62;\r\n&#60;p&#62;Esse chamado foi atualizado e encaminhado para o Marcelo, ele tomará conta dessa customização, ok?&#60;/p&#62;',0,1,'2023-10-27 17:11:30','2023-10-27 17:11:30',1,0,0),(62,'Ticket',2023102502,'2023-10-27 17:31:06',28,0,'&#60;p&#62;Boa Tarde!&#60;/p&#62;\r\n&#60;p&#62;Se possível informar nos prazo para conclusão&#60;/p&#62;\r\n&#60;p&#62; &#60;/p&#62;',0,0,'2023-10-27 17:31:06','2023-10-27 17:31:06',1,0,0),(63,'Ticket',2023101101,'2023-10-27 17:33:18',28,0,'&#60;p&#62;OK&#60;/p&#62;\r\n&#60;p&#62; &#60;/p&#62;',0,0,'2023-10-27 17:33:18','2023-10-27 17:33:18',1,0,0),(64,'Ticket',2023101101,'2023-11-06 17:33:31',21,0,'&#60;p&#62;Olá Roberta, instalaram a correção em PreProd, poderia validar se está de acordo?&#60;/p&#62;\r\n&#60;p&#62; &#60;/p&#62;',0,1,'2023-11-06 17:33:31','2023-11-06 17:33:31',4,0,0),(65,'Ticket',2023110701,'2023-11-07 17:27:32',11,0,'&#60;p&#62;Olá Gustavo, &#60;span class=\"ui-provider ee bce bcf bcg bch bci bcj bck bcl bcm bcn bco bcp bcq bcr bcs bct bcu bcv bcw bcx bcy bcz bda bdb bdc bdd bde bdf bdg bdh bdi bdj bdk bdl\" dir=\"ltr\"&#62;iremos realizar a abertura do chamado para configurar esse novo ip.&#60;/span&#62;&#60;/p&#62;',0,1,'2023-11-07 17:27:32','2023-11-07 17:27:32',1,0,0),(66,'Ticket',2023110701,'2023-11-08 19:25:13',10,0,'&#60;p&#62;Olá!!&#60;/p&#62;\r\n&#60;p&#62;Chamado atualizado com o ticket number criado na MEGA&#60;/p&#62;',0,1,'2023-11-08 19:25:13','2023-11-08 19:25:13',4,0,0),(67,'Ticket',2023101203,'2023-11-09 16:53:31',10,0,'&#60;p&#62;Olá Gustavo,&#60;/p&#62;\r\n&#60;p&#62;Tivemos a resposta da MEGA nos informando que com o usuário é possivel gerar as paginas do 360. Poderia me informar opcões de agenda para realizarmos uma reunião com eles? &#60;/p&#62;',0,1,'2023-11-09 16:53:31','2023-11-09 16:53:31',1,0,0),(68,'Ticket',2023101202,'2023-11-09 17:18:11',10,0,'&#60;p&#62;Olá Roberta/Gustavo,&#60;/p&#62;\r\n&#60;p&#62;Tivemos a seguinte resposta da MEGA: \"Atualmente, ainda estamos aguardando a aprovação do seu cliente para instalar o pacote personalizado mais recente no PROD.\"&#60;/p&#62;\r\n&#60;p&#62;Estarei colocando você em cópia para aprovar a solicitação, okay?&#60;/p&#62;',0,1,'2023-11-09 17:18:11','2023-11-09 17:18:11',1,0,0),(69,'Ticket',2023100902,'2023-11-09 17:26:08',10,0,'&#60;p&#62;O chamado está com o laboratório da MEGA, aguardando a resposta da MEGA para atualização do status&#60;/p&#62;',0,1,'2023-11-09 17:26:08','2023-11-09 17:26:08',1,0,0),(70,'Ticket',2023111001,'2023-11-10 18:27:07',11,0,'&#60;p&#62;Olá Gustavo, o seu chamado está em analise.&#60;/p&#62;',0,1,'2023-11-10 18:27:07','2023-11-10 18:27:07',1,0,0),(71,'Ticket',2023102502,'2023-11-10 21:33:45',24,24,'&#60;p&#62;Boa tarde,&#60;br&#62;&#60;br&#62;Por favor, atualizar este pedido. Que o novo [Tipo de Aplicação] tenha a seguinte descrição: [&#60;span class=\"ui-provider ef bft bbu bws bwt bwu bwv bww bwx bwy bwz bxa bxb bxc bxd bxe bxf bxg bxh bxi bxj bxk bxl bxm bxn bxo bxp bxq bxr bxs bxt bxu bxv bxw bxx\" dir=\"ltr\"&#62;Módulos, Microserviços e Componentes]&#60;br&#62;&#60;br&#62;DESCONSIDERAR: [Componentes de Tecnologia]&#60;/span&#62;&#60;/p&#62;',0,0,'2023-11-10 22:02:02','2023-11-10 21:33:45',1,0,0),(72,'Ticket',2023110701,'2023-11-13 12:21:12',10,0,'&#60;p&#62;Olá Gustavo,&#60;/p&#62;\r\n&#60;p&#62;Em relação a este caso, o IP fornecido foi adicionado a whitelist, então agora você poderá acessar o HOPEX a partir dele.&#60;/p&#62;\r\n&#60;p&#62; &#60;/p&#62;\r\n&#60;p&#62;Poderia confirmar?&#60;/p&#62;',0,1,'2023-11-13 12:21:12','2023-11-13 12:21:12',4,0,0),(73,'Ticket',2023111003,'2023-11-13 12:23:10',10,0,'&#60;p&#62;Olá Gustavo,&#60;/p&#62;\r\n&#60;p&#62;Estarei atribuindo o Marcelo neste chamado para realizar as modificações.&#60;/p&#62;',0,1,'2023-11-13 12:23:10','2023-11-13 12:23:10',1,0,0),(74,'Ticket',2023111002,'2023-11-13 13:11:12',11,0,'&#60;p&#62;Olá Gustavo, estamos analisando o seu chamado e ele será encaminhado para a Mega! &#60;/p&#62;',0,1,'2023-11-13 13:11:12','2023-11-13 13:11:12',1,0,0),(75,'Ticket',2023111301,'2023-11-14 17:18:09',11,0,'&#60;p&#62;Olá Gustavo iremos analisar as informações e prosseguir com chamado&#60;/p&#62;',0,1,'2023-11-14 17:18:09','2023-11-14 17:18:09',1,0,0),(76,'Ticket',2023111302,'2023-11-14 17:20:42',11,0,'&#60;p&#62;Olá Gustavo iremos analisar o chamado e prosseguir com ele.&#60;/p&#62;\r\n&#60;p&#62;Caso haja mais alguma especificação ou se precisar de ajustes adicionais, por favor, não hesite em nos informar.&#60;/p&#62;\r\n&#60;p&#62;Agradecemos pela sua compreensão e colaboração.&#60;/p&#62;',0,1,'2023-11-14 17:20:42','2023-11-14 17:20:42',4,0,0),(77,'Ticket',2023101105,'2023-11-16 20:02:20',24,0,'&#60;p&#62;Adicionais:&#60;br&#62;1 - Responsabilidade&#60;br&#62;&#60;a href=\"/glpi/front/document.send.php?docid=35&#38;itemtype=Ticket&#38;items_id=2023101105\" target=\"_blank\" &#62;&#60;img alt=\"95755b8f-e509fb39-6556750f874f28.47056904\" width=\"882\" src=\"/glpi/front/document.send.php?docid=35&#38;itemtype=Ticket&#38;items_id=2023101105\" /&#62;&#60;/a&#62;&#60;/p&#62;\r\n&#60;p&#62;2 - Portifólio&#60;/p&#62;',0,0,'2023-11-16 20:02:20','2023-11-16 20:02:20',1,0,0),(78,'Ticket',2023112102,'2023-11-22 13:15:35',11,0,'&#60;p&#62;Olá Gustavo, estamos analisando o seu chamado vamos utilizar as informações fornecidas como referência para realizar essas customizações.&#60;/p&#62;',0,1,'2023-11-22 13:15:35','2023-11-22 13:15:35',1,0,0),(79,'Ticket',2023112101,'2023-11-22 13:20:49',11,0,'&#60;p&#62;Olá Gustavo iremos verificar o chamado.&#60;/p&#62;',0,1,'2023-11-22 13:20:49','2023-11-22 13:20:49',1,0,0),(80,'Ticket',2023112301,'2023-11-24 18:24:31',11,0,'&#60;p&#62;Olá Gustavo, estamos analisando o seu chamado para fazer a customização no hopex.&#60;/p&#62;',0,1,'2023-11-24 18:24:31','2023-11-24 18:24:31',1,0,0),(82,'Ticket',2023113001,'2023-12-01 17:35:36',11,0,'&#60;p&#62;Olá, estamos verificando o chamado e analisando as customizações.&#60;/p&#62;',0,1,'2023-12-01 17:35:36','2023-12-01 17:35:36',1,0,0),(83,'Ticket',2023113003,'2023-12-01 17:38:18',11,0,'&#60;p&#62;Olá Gustavo, o seu chamado está sendo analisado.&#60;/p&#62;',0,1,'2023-12-01 17:38:18','2023-12-01 17:38:18',1,0,0),(84,'Ticket',2023113004,'2023-12-01 17:40:16',11,0,'&#60;p&#62;Olá, estamos analisando esses requisitos&#60;/p&#62;',0,1,'2023-12-01 17:40:16','2023-12-01 17:40:16',1,0,0),(85,'Ticket',2023113002,'2023-12-01 17:42:56',11,0,'&#60;p&#62;Olá estamos analisando o seu chamado.&#60;/p&#62;',0,1,'2023-12-01 17:42:56','2023-12-01 17:42:56',1,0,0),(86,'Ticket',2023121801,'2023-12-19 18:52:55',11,0,'&#60;p&#62;O seu chamado esta sendo analisado e será encaminhado para o técnico responsável &#60;/p&#62;',0,1,'2023-12-19 18:52:55','2023-12-19 18:52:55',1,0,0),(87,'Ticket',2023121901,'2023-12-20 19:20:23',11,0,'&#60;p&#62;O chamado foi encaminhado.&#60;/p&#62;',0,1,'2023-12-20 19:20:23','2023-12-20 19:20:23',1,0,0),(88,'Ticket',2023122101,'2023-12-21 14:22:26',11,0,'&#60;p&#62;O chamado já foi atribuído para o técnico responsável.&#60;/p&#62;',0,1,'2023-12-21 14:22:26','2023-12-21 14:22:26',1,0,0),(89,'Ticket',2023122602,'2024-01-02 15:23:41',11,0,'&#60;p&#62;Olá, o seu chamado será atribuído para o nosso técnico Marcelo. &#60;/p&#62;',0,1,'2024-01-02 15:23:41','2024-01-02 15:23:41',1,0,0),(90,'Ticket',2023122601,'2024-01-02 15:24:41',11,0,'&#60;p&#62;Olá, o seu chamado será atribuído para o Marcelo. &#60;/p&#62;',0,1,'2024-01-02 15:24:41','2024-01-02 15:24:41',1,0,0),(91,'Ticket',2024010502,'2024-01-05 18:21:43',11,0,'&#60;p&#62;Olá Gustavo o chamado foi redirecionado para o Marcelo.&#60;/p&#62;',0,1,'2024-01-05 18:21:43','2024-01-05 18:21:43',1,0,0),(92,'Ticket',2024010501,'2024-01-05 18:23:07',11,0,'&#60;p&#62;Olá Gustavo o chamado foi redirecionado para o Marcelo, qualquer duvida ou algo a acrescentar estamos a disposição.&#60;/p&#62;',0,1,'2024-01-05 18:23:07','2024-01-05 18:23:07',1,0,0),(93,'Ticket',2024010502,'2024-01-10 12:37:33',21,0,'&#60;p&#62;Bom dia Gustavo,&#60;/p&#62;\r\n&#60;p&#62;Segue o passo a passo para a alteração de perfis para grupos de usuários.&#60;/p&#62;\r\n&#60;p&#62; &#60;/p&#62;\r\n&#60;p&#62;Att.&#60;/p&#62;',0,1,'2024-01-10 12:37:33','2024-01-10 12:37:33',4,0,0),(94,'Ticket',2024020501,'2024-02-06 16:50:22',11,0,'&#60;p&#62;Olá Pedro, Iremos realizar uma verificação na geração do Orizon360 para determinar o estado atual da versão em uso. Após a análise, entrarei em contato para fornecer informações atualizadas sobre a situação e os próximos passos a serem seguidos.&#60;/p&#62;',0,1,'2024-02-06 16:50:22','2024-02-06 16:50:22',1,0,0),(95,'Ticket',2024020601,'2024-02-06 16:54:05',11,0,'&#60;p&#62;Olá Gustavo, o técnico responsável  esta analisando o seu chamado.&#60;/p&#62;',0,1,'2024-02-06 16:54:05','2024-02-06 16:54:05',1,0,0),(96,'Ticket',2024013102,'2024-02-07 14:46:58',10,0,'&#60;p&#62;Feito! Persons inseridas no repositório&#60;/p&#62;',0,1,'2024-02-07 14:46:58','2024-02-07 14:46:58',1,0,0),(97,'Ticket',2024013101,'2024-02-07 15:14:42',10,0,'&#60;p&#62;Realizando atualização do objeto, campos já estão customizados restando somente o campo de software associados.&#60;/p&#62;',0,1,'2024-02-07 15:14:42','2024-02-07 15:14:42',1,0,0),(99,'Ticket',2024020501,'2024-03-05 17:25:36',10,0,'&#60;p&#62;Chamado solucionado.&#60;/p&#62;',0,1,'2024-03-05 17:25:36','2024-03-05 17:25:36',1,0,0),(100,'Ticket',2023113001,'2024-03-11 16:44:37',24,0,'&#60;p&#62;Por favor, CANCELAR esse ITEM VAMOS CRIAR 1 NOVO MAIS COMPLETO&#60;/p&#62;',0,0,'2024-03-11 16:44:37','2024-03-11 16:44:37',1,0,0),(101,'Ticket',2023113001,'2024-03-12 20:28:10',10,0,'&#60;p&#62;Conforme solicitado estamos encerrando a solicitação.&#60;/p&#62;',0,1,'2024-03-12 20:28:10','2024-03-12 20:28:10',1,0,0),(102,'Ticket',2024031501,'2024-03-18 12:24:54',10,10,'&#60;p&#62;Bug reportado a MEGA, aguardando posicionamento&#60;br&#62;Numero do chamado 00157155&#60;/p&#62;',0,1,'2024-03-21 16:47:50','2024-03-18 12:24:54',1,0,0),(103,'Ticket',2024031508,'2024-03-21 16:49:11',10,0,'&#60;p&#62;Data Models OK&#60;/p&#62;\r\n&#60;p&#62;Entidades OK&#60;/p&#62;\r\n&#60;p&#62;Relacionamento entre Data Model x Entidade OK&#60;/p&#62;\r\n&#60;p&#62;Atributos OK&#60;/p&#62;\r\n&#60;p&#62;Estamos na fase de ajustar os Identificadores.&#60;/p&#62;',0,1,'2024-03-21 16:49:11','2024-03-21 16:49:11',1,0,0),(104,'Ticket',2024031502,'2024-03-21 16:49:45',10,0,'&#60;p&#62;Instalação realizada, aguardando Josimar replicar as bases de PRD para o servidor de QAS&#60;/p&#62;',0,1,'2024-03-21 16:49:45','2024-03-21 16:49:45',1,0,0),(105,'Ticket',2024031505,'2024-03-21 16:50:14',10,0,'&#60;p&#62;Reunião agendada para 14h para tratar esse assunto.&#60;/p&#62;',0,1,'2024-03-21 16:50:14','2024-03-21 16:50:14',1,0,0),(106,'Ticket',2023122601,'2024-03-22 18:41:03',24,0,'&#60;p&#62;POR FAVOR, CANCELAR&#60;/p&#62;',0,0,'2024-03-22 18:41:03','2024-03-22 18:41:03',1,0,0),(107,'Ticket',2023121801,'2024-03-22 18:45:00',24,0,'&#60;p&#62;Quando será atendido?&#60;/p&#62;',0,0,'2024-03-22 18:45:00','2024-03-22 18:45:00',1,0,0),(108,'Ticket',2023121901,'2024-03-22 18:45:21',24,0,'&#60;p&#62;Quando será atendido?&#60;/p&#62;',0,0,'2024-03-22 18:45:21','2024-03-22 18:45:21',1,0,0),(109,'Ticket',2023122602,'2024-03-22 18:45:33',24,0,'&#60;p&#62;Quando será atendido?&#60;/p&#62;',0,0,'2024-03-22 18:45:33','2024-03-22 18:45:33',1,0,0),(110,'Ticket',2024020601,'2024-03-22 18:45:44',24,0,'&#60;p&#62;Quando será atendido?&#60;/p&#62;',0,0,'2024-03-22 18:45:44','2024-03-22 18:45:44',1,0,0),(112,'Ticket',2024031101,'2024-03-28 13:42:20',10,0,'&#60;p&#62;Ola Gustavo,&#60;/p&#62;\r\n&#60;p&#62;Abaixo compartilho o procedimento para editar o título do diagrama.&#60;/p&#62;\r\n&#60;p&#62;Depois de inserir o elemento Título do seu diagrama, você vai para as propriedades do diagrama no menu Propriedades do Diagrama, que coloco com uma caixa vermelha na captura de tela a seguir.&#60;/p&#62;\r\n&#60;p&#62;&#60;a href=\"/glpi/front/document.send.php?docid=63&#38;itemtype=Ticket&#38;items_id=2024031101\" target=\"_blank\" &#62;&#60;img alt=\"95755b8f-e509fb39-6605722724d794.45289908\" width=\"1570\" src=\"/glpi/front/document.send.php?docid=63&#38;itemtype=Ticket&#38;items_id=2024031101\" /&#62;&#60;/a&#62;&#60;/p&#62;\r\n&#60;p&#62;Você atribui o nome no atributo Nome local e clica em OK.&#60;/p&#62;\r\n&#60;p&#62;&#60;a href=\"/glpi/front/document.send.php?docid=62&#38;itemtype=Ticket&#38;items_id=2024031101\" target=\"_blank\" &#62;&#60;img alt=\"95755b8f-e509fb39-6605722707faa1.09740492\" width=\"1074\" src=\"/glpi/front/document.send.php?docid=62&#38;itemtype=Ticket&#38;items_id=2024031101\" /&#62;&#60;/a&#62;&#60;/p&#62;\r\n&#60;div id=\"translation\"&#62;\r\n&#60;div class=\"gtx-body\"&#62;Para ver a mudança refletida em seu diagrama, clique em Atualizar Diagrama.&#60;/div&#62;\r\n&#60;/div&#62;\r\n&#60;p&#62;&#60;a href=\"/glpi/front/document.send.php?docid=65&#38;itemtype=Ticket&#38;items_id=2024031101\" target=\"_blank\" &#62;&#60;img alt=\"95755b8f-e509fb39-6605722794a297.63351473\" width=\"1266\" src=\"/glpi/front/document.send.php?docid=65&#38;itemtype=Ticket&#38;items_id=2024031101\" /&#62;&#60;/a&#62;&#60;/p&#62;\r\n&#60;p&#62;E com isso você verá o cabeçalho do seu diagrama modificado.&#60;/p&#62;\r\n&#60;p&#62;&#60;a href=\"/glpi/front/document.send.php?docid=64&#38;itemtype=Ticket&#38;items_id=2024031101\" target=\"_blank\" &#62;&#60;img alt=\"95755b8f-e509fb39-660572278af571.68651804\" width=\"1184\" src=\"/glpi/front/document.send.php?docid=64&#38;itemtype=Ticket&#38;items_id=2024031101\" /&#62;&#60;/a&#62;&#60;/p&#62;\r\n&#60;p aria-hidden=\"true\"&#62; &#60;/p&#62;\r\n&#60;p&#62;É importante lembrar que o diagrama de um objeto é independente do próprio objeto, este elemento Title leva automaticamente o nome atribuído ao objeto Diagrama, portanto basta ir até suas propriedades para fazer esta modificação.&#60;/p&#62;',0,1,'2024-03-28 13:42:20','2024-03-28 13:42:20',1,0,0),(113,'Ticket',2024031502,'2024-03-28 16:08:14',10,0,'&#60;p&#62;Angela, ambiente pronto para ser utilizado. Acesse o link https://rj01hopexhom:5005 com as credencias do servidor de PRD&#60;/p&#62;',0,1,'2024-03-28 16:08:14','2024-03-28 16:08:14',1,0,0),(114,'Ticket',2024031501,'2024-03-28 16:08:45',10,0,'&#60;p&#62;Ajustado o campo TAG, aguardando a mega nos ajudar com o campo de aplicação&#60;/p&#62;',0,1,'2024-03-28 16:08:45','2024-03-28 16:08:45',1,0,0),(115,'Ticket',2024032801,'2024-03-28 16:36:24',10,0,'&#60;p&#62;Olá Angela,&#60;/p&#62;\r\n&#60;p&#62;Feito, você verá as atualizações na próxima publicação!!&#60;/p&#62;',0,1,'2024-03-28 16:36:24','2024-03-28 16:36:24',1,0,0),(116,'Ticket',2024031508,'2024-03-28 16:39:29',10,0,'&#60;p&#62;Identificadores ajustados!!&#60;/p&#62;',0,1,'2024-03-28 16:39:29','2024-03-28 16:39:29',1,0,0),(117,'Ticket',2024031505,'2024-03-28 16:40:02',10,0,'&#60;p&#62;Reunião realizada com Marcelo, aguardando posição para informar qual o melhor caminho&#60;/p&#62;',0,1,'2024-03-28 16:40:02','2024-03-28 16:40:02',1,0,0),(118,'Ticket',2024040101,'2024-04-02 14:08:34',21,0,'&#60;p&#62;BOm dia Gustavo, a minha visibilidade sobre os dados é igual a que o adelmo está tendo. Poderia verificar nos objetos que não estão sendo visíveis para o federado no seguinte caminho:&#60;/p&#62;\r\n&#60;p&#62;Propriedades -&#38;gt; General -&#38;gt; Administration&#60;/p&#62;\r\n&#60;p&#62;Verificar na tela o Reading Access Area configurado, se for Diretoria ou Gerência, alterar para Operacional. Assim os federados poderão visualizar&#60;/p&#62;',0,1,'2024-04-02 14:08:34','2024-04-02 14:08:34',4,0,0),(119,'Ticket',2024040401,'2024-04-08 12:18:31',10,0,'&#60;p&#62;Aterações realizadas, irá subir hoje após as 18:30!&#60;/p&#62;',0,1,'2024-04-08 12:18:31','2024-04-08 12:18:31',1,0,0),(120,'Ticket',2023121901,'2024-04-12 14:37:56',24,0,'&#60;p&#62;Pessoal, POR FAVOR CANCELAR, vamos utilizar essa catagoria.&#60;/p&#62;',0,0,'2024-04-12 14:37:56','2024-04-12 14:37:56',1,0,0),(122,'Ticket',2024041201,'2024-04-17 13:06:26',10,0,'&#60;p&#62;Olá Gustavo, poderia nos enviar uma print mostrando a aba Motivo?&#60;/p&#62;\r\n&#60;p&#62;&#60;a href=\"/glpi/front/document.send.php?docid=77&#38;itemtype=Ticket&#38;items_id=2024041201\" target=\"_blank\" &#62;&#60;img alt=\"95755b8f-e509fb39-661fc94edf78d6.00745620\" width=\"592\" src=\"/glpi/front/document.send.php?docid=77&#38;itemtype=Ticket&#38;items_id=2024041201\" /&#62;&#60;/a&#62; &#60;/p&#62;',0,1,'2024-04-17 13:06:26','2024-04-17 13:06:26',1,0,0),(123,'Ticket',2024042901,'2024-04-30 13:58:28',10,0,'&#60;p&#62;&#60;span style=\"background-color: rgb(224, 62, 45);\"&#62;Validar os logins que possui acesso ao ambiente de melhoria e base Configuration&#60;/span&#62;&#60;br&#62;&#60;span style=\"background-color: rgb(45, 194, 107);\"&#62;Validar o campo de justificativa de revisão&#60;/span&#62;&#60;br&#62;&#60;span style=\"background-color: rgb(45, 194, 107);\"&#62;Alterar Rasci para RACI&#60;/span&#62;&#60;br&#62;&#60;span style=\"background-color: rgb(45, 194, 107);\"&#62;Corrigir Status dos diagramas&#60;/span&#62;&#60;br&#62;&#60;span style=\"background-color: rgb(45, 194, 107);\"&#62;Colocar no portal historico de revisao&#60;/span&#62;&#60;br&#62;&#60;span style=\"background-color: rgb(45, 194, 107);\"&#62;numero da versao&#60;/span&#62;&#60;br&#62;&#60;span style=\"background-color: rgb(45, 194, 107);\"&#62;justificativa&#60;/span&#62;&#60;/p&#62;',0,1,'2024-04-30 13:58:28','2024-04-30 13:58:28',1,0,0),(124,'Ticket',2024042901,'2024-04-30 13:59:16',10,0,'&#60;p&#62;Atividades adicionais 30/04:&#60;/p&#62;\r\n&#60;p&#62; &#60;/p&#62;\r\n&#60;p&#62;&#60;span class=\"ui-provider a b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak\" dir=\"ltr\"&#62;Remover parcerias tela inicial&#60;br&#62;Remover favoritos&#60;br&#62;Business process diagram mostrar em processos&#60;br&#62;Competencias ver pra que serve &#60;br&#62;Ver se é possivel linkar position com RACI&#60;br&#62;Confirmar licença quantidade plus&#60;/span&#62;&#60;/p&#62;',0,1,'2024-04-30 13:59:16','2024-04-30 13:59:16',1,0,0),(125,'Ticket',2024042901,'2024-05-10 14:29:13',10,0,'&#60;p&#62;&#60;span style=\"color: rgb(0, 0, 0); background-color: rgb(45, 194, 107);\"&#62;Remover parcerias tela inicial&#60;/span&#62;&#60;br&#62;&#60;span style=\"color: rgb(0, 0, 0); background-color: rgb(45, 194, 107);\"&#62;Remover favoritos&#60;/span&#62;&#60;br&#62;&#60;span style=\"color: rgb(0, 0, 0); background-color: rgb(45, 194, 107);\"&#62;Business process diagram mostrar em processos&#60;/span&#62;&#60;br&#62;&#60;span style=\"color: rgb(0, 0, 0); background-color: rgb(45, 194, 107);\"&#62;Competencias ver pra que serve &#60;/span&#62;&#60;br&#62;&#60;span style=\"color: rgb(0, 0, 0); background-color: rgb(45, 194, 107);\"&#62;Ver se é possivel linkar position com RACI&#60;/span&#62;&#60;br&#62;&#60;span style=\"color: rgb(0, 0, 0); background-color: rgb(45, 194, 107);\"&#62;Confirmar licença quantidade plus&#60;/span&#62;&#60;/p&#62;',0,1,'2024-05-10 14:29:13','2024-05-10 14:29:13',1,0,0),(126,'Ticket',2024031301,'2024-05-13 19:39:49',21,0,'&#60;p&#62;Boa tarde Roberta, nesse caso há uma incompatibilidade entre os idiomas usados pelos usuários. Um vez que todos os usuários estejam com o mesmo idioma, eles verão a mesma informação.&#60;/p&#62;',0,1,'2024-05-13 19:39:49','2024-05-13 19:39:49',4,0,0),(127,'Ticket',2024031508,'2024-05-14 11:18:53',10,10,'&#60;p&#62;Importação dos modelos fisicos em andamento.&#60;/p&#62;',0,1,'2024-07-03 14:04:10','2024-05-14 11:18:53',1,0,0),(128,'Ticket',2024031506,'2024-05-14 11:19:39',10,0,'&#60;p&#62;Solicitação encaminhada ao desenvolvedor. Aguardando resposta para seguir com a customização&#60;/p&#62;',0,1,'2024-05-14 11:19:39','2024-05-14 11:19:39',1,0,0),(129,'Ticket',2024031506,'2024-05-14 12:28:51',10,10,'&#60;p&#62;Documento De Especificação&#60;/p&#62;',0,1,'2024-05-14 19:56:10','2024-05-14 12:28:51',1,0,0),(130,'Ticket',2024051401,'2024-05-14 12:30:41',10,10,'&#60;p&#62;Documento De Especificação&#60;/p&#62;',0,1,'2024-05-14 19:56:45','2024-05-14 12:30:41',1,0,0),(131,'Ticket',2024031503,'2024-05-14 13:03:00',10,0,'&#60;p&#62;Pendente configuração do servidor de SMTP para configuração&#60;/p&#62;',0,1,'2024-05-14 13:03:00','2024-05-14 13:03:00',1,0,0),(132,'Ticket',2024041601,'2024-05-14 18:38:40',10,0,'&#60;p&#62;Incluir &#60;strong&#62;Especificação Funcional&#60;/strong&#62;&#60;/p&#62;',0,1,'2024-05-14 18:38:40','2024-05-14 18:38:40',1,0,0),(133,'Ticket',2024031504,'2024-05-14 19:29:01',10,0,'&#60;p&#62;Incluir chamado de apoio para &#60;strong&#62;MEGA&#60;/strong&#62;&#60;/p&#62;',0,1,'2024-05-14 19:29:01','2024-05-14 19:29:01',1,0,0),(134,'Ticket',2023122601,'2024-05-15 15:00:29',10,10,'&#60;p&#62;Olá Gustavo,&#60;/p&#62;\r\n&#60;p&#62;Estaremos encerrando o chamado, qualquer dúvida estamos a disposição!&#60;/p&#62;',0,1,'2024-05-15 15:01:30','2024-05-15 15:00:29',1,0,0),(135,'Ticket',2023121901,'2024-05-15 15:01:11',10,0,'&#60;p&#62;Olá Gustavo,&#60;/p&#62;\r\n&#60;p&#62;Estaremos encerrando o chamado, qualquer dúvida estamos a disposição!&#60;/p&#62;',0,1,'2024-05-15 15:01:11','2024-05-15 15:01:11',1,0,0),(136,'Ticket',2024041201,'2024-05-15 15:02:43',10,0,'&#60;p&#62;Olá Gustavo,&#60;/p&#62;\r\n&#60;p&#62;O problema foi resolvido? Qualquer duvida estamos a disposição&#60;/p&#62;',0,1,'2024-05-15 15:02:43','2024-05-15 15:02:43',4,0,0),(137,'Ticket',2024051301,'2024-05-15 15:14:02',10,0,'&#60;p&#62;Olá Roberta,&#60;/p&#62;\r\n&#60;p&#62;Podemos agendar uma reunião para entender melhor o assunto?&#60;/p&#62;',0,1,'2024-05-15 15:14:02','2024-05-15 15:14:02',1,0,0),(138,'Ticket',2024031505,'2024-05-15 16:38:21',10,0,'&#60;p&#62;Aguardando calculo da quantidade de horas para realizar o trabalho.&#60;/p&#62;',0,1,'2024-05-15 16:38:21','2024-05-15 16:38:21',1,0,0),(139,'Ticket',2024051401,'2024-05-15 16:38:45',10,0,'&#60;p&#62;Aguardando calculo da quantidade de horas para realizar o trabalho.&#60;br&#62;&#60;br&#62;Desconsiderar documento acima&#60;/p&#62;',0,1,'2024-05-15 16:38:45','2024-05-15 16:38:45',1,0,0),(140,'Ticket',2024031506,'2024-05-15 16:38:55',10,0,'&#60;p&#62;Aguardando calculo da quantidade de horas para realizar o trabalho.&#60;/p&#62;',0,1,'2024-05-15 16:38:55','2024-05-15 16:38:55',1,0,0),(141,'Ticket',2023121801,'2024-05-16 13:43:14',10,10,'&#60;p&#62;Olá Gustavo,&#60;/p&#62;\r\n&#60;p&#62;Esse chamado será inserido no Pacote 2 de customizações. Responderemos em sequencia com a especificação técnica.&#60;/p&#62;',0,1,'2024-05-16 13:46:45','2024-05-16 13:43:14',1,0,0),(142,'Ticket',2023122602,'2024-05-16 13:44:50',10,10,'&#60;p&#62;Olá Gustavo,&#60;/p&#62;\r\n&#60;p&#62;Esse chamado será inserido no Pacote 2 de customizações. Responderemos em sequencia com a especificação técnica.&#60;/p&#62;',0,1,'2024-05-16 13:46:28','2024-05-16 13:44:50',1,0,0),(143,'Ticket',2024020601,'2024-05-16 13:45:35',10,0,'&#60;p&#62;Olá Gustavo,&#60;/p&#62;\r\n&#60;p&#62;Estamos inserido este chamado no pacote 2 e responderemos em sequencia criaremos uma especificação com quantidade de horas&#60;/p&#62;',0,1,'2024-05-16 13:45:35','2024-05-16 13:45:35',1,0,0),(144,'Ticket',2024032201,'2024-05-16 13:48:14',10,0,'&#60;p&#62;Olá Roberta, &#60;/p&#62;\r\n&#60;p&#62;Este pacote já está em fase de instalação em DEV, assim que estiver tudo em ordem informaremos a vocês!&#60;/p&#62;',0,1,'2024-05-16 13:48:14','2024-05-16 13:48:14',1,0,0),(145,'Ticket',2024032201,'2024-05-16 13:48:20',10,0,'&#60;p&#62;&#60;em&#62; Customizações Hopex (alinhar mudança pra entregar como mgr) importar no ambiente de dev (arquivo que recebemos no email)&#60;/em&#62;&#60;/p&#62;',1,1,'2024-05-16 13:48:20','2024-05-16 13:48:20',1,0,0),(146,'Ticket',2024051301,'2024-05-16 17:32:58',28,0,'&#60;p&#62;Sim, claro. À disposição&#60;/p&#62;',0,0,'2024-05-16 17:32:58','2024-05-16 17:32:58',1,0,0),(147,'Ticket',2024051301,'2024-05-17 14:27:16',10,0,'&#60;p&#62;Poderia nos enviar sua agenda de hoje 17/05 ou segunda 20/05?&#60;/p&#62;',0,1,'2024-05-17 14:27:16','2024-05-17 14:27:16',4,0,0),(148,'Ticket',2024051301,'2024-05-21 18:08:18',28,0,'&#60;p&#62;Podemos falar 22 /05 às 14?&#60;/p&#62;',0,0,'2024-05-21 18:08:18','2024-05-21 18:08:18',1,0,0),(149,'Ticket',2024051301,'2024-05-28 12:37:24',10,0,'&#60;p&#62;Olá Roberta, podemos amanha 29/05?&#60;/p&#62;',0,1,'2024-05-28 12:37:24','2024-05-28 12:37:24',4,0,0),(150,'Ticket',2024051301,'2024-05-28 12:59:55',28,0,'&#60;p&#62;Bom dia! Estou utilizando o caampo de tag. vou cancelar este chamado, Obrigada&#60;/p&#62;',0,0,'2024-05-28 12:59:55','2024-05-28 12:59:55',1,0,0),(151,'Ticket',2024051301,'2024-05-28 17:17:19',10,0,'&#60;p&#62;Oi Roberta, estarei encerrando o chamado&#60;/p&#62;\r\n&#60;p&#62;Qualquer novidade nos deixa saber, ok?&#60;/p&#62;',0,1,'2024-05-28 17:17:19','2024-05-28 17:17:19',4,0,0),(152,'Ticket',2024031504,'2024-06-05 21:14:19',10,0,'&#60;p&#62;Chamado encerrado.&#60;/p&#62;\r\n&#60;p&#62;Certificado ativo e URL com DNS funcionando!&#60;/p&#62;',0,1,'2024-06-05 21:14:19','2024-06-05 21:14:19',4,0,0),(153,'Ticket',2024060701,'2024-06-07 16:43:22',10,0,'&#60;p&#62;Olá!&#60;/p&#62;\r\n&#60;p&#62;Icone colocado novamente no portal.&#60;/p&#62;\r\n&#60;p&#62;Chamado encerrado.&#60;/p&#62;',0,1,'2024-06-07 16:43:22','2024-06-07 16:43:22',1,0,0),(154,'Ticket',2024032201,'2024-06-10 16:52:36',10,0,'&#60;p&#62;&#60;em&#62;Arquivos importados, realizando validação&#60;/em&#62;&#60;/p&#62;',1,1,'2024-06-10 16:52:36','2024-06-10 16:52:36',1,0,0),(155,'Ticket',2024061101,'2024-06-17 17:49:44',10,0,'&#60;p&#62;Treinamento Compliance realizado na sexta-feira 14/06&#60;br&#62;Treinamento Cadeia de Valor agendada para quarta-feira 19/06&#60;/p&#62;',0,1,'2024-06-17 17:49:44','2024-06-17 17:49:44',4,0,0),(156,'Ticket',2024061701,'2024-06-19 18:55:39',10,0,'&#60;p&#62;Olá Otavio, conforme combinamos esse chamado irá consumir as horas restantes do mes&#60;/p&#62;',0,1,'2024-06-19 18:55:39','2024-06-19 18:55:39',1,0,0),(157,'Ticket',2024061101,'2024-06-19 19:00:44',10,0,'&#60;p&#62;Treinamento realizado.&#60;/p&#62;\r\n&#60;p&#62;Chamado encerrado!&#60;/p&#62;',0,1,'2024-06-19 19:00:44','2024-06-19 19:00:44',4,0,0),(158,'Ticket',2024061901,'2024-06-21 12:17:20',46,0,'&#60;p&#62;Bom dia!&#60;/p&#62;\r\n&#60;p&#62;Query realizada. Você já pode vê-la dentro do repositório!!!&#60;/p&#62;',0,1,'2024-06-21 12:17:20','2024-06-21 12:17:20',4,0,0),(159,'Ticket',2024062501,'2024-06-25 14:15:50',10,0,'&#60;p&#62;Olá Otavio,&#60;/p&#62;\r\n&#60;p&#62;Objetos removidos com sucesso.&#60;/p&#62;\r\n&#60;p&#62;Qualquer duvida nos avise!&#60;/p&#62;',0,1,'2024-06-25 14:15:50','2024-06-25 14:15:50',4,0,0),(160,'Ticket',2024062502,'2024-06-25 14:20:35',10,0,'&#60;p&#62;Acknowledge ajustado, agora você pode visualizar os usuarios que deram de acordo no documento!&#60;/p&#62;\r\n&#60;p&#62;Qualquer dúvida nos avise!!&#60;/p&#62;',0,1,'2024-06-25 14:20:35','2024-06-25 14:20:35',4,0,0),(161,'Ticket',2024032201,'2024-07-01 17:34:34',10,10,'&#60;p&#62;Customização ja disponibilizada em QAS, aguardando validação para prosseguir em PRE PROD&#60;/p&#62;',0,1,'2024-07-01 17:45:08','2024-07-01 17:34:34',1,0,0),(162,'Ticket',2024051401,'2024-07-01 17:42:47',10,0,'&#60;p&#62;Olá Angela,&#60;/p&#62;\r\n&#60;p&#62;Em anexo segue o documento da customização com as horas e os valores.&#60;/p&#62;',0,1,'2024-07-01 17:42:47','2024-07-01 17:42:47',4,0,0),(163,'Ticket',2024031506,'2024-07-01 17:43:07',10,0,'&#60;p&#62;Olá Angela,&#60;/p&#62;\r\n&#60;p&#62;Em anexo segue o documento da customização com as horas e os valores.&#60;/p&#62;',0,1,'2024-07-01 17:43:07','2024-07-01 17:43:07',4,0,0),(164,'Ticket',2024031503,'2024-07-03 13:42:07',46,0,'&#60;p&#62;Olá Angela! &#60;/p&#62;\r\n&#60;p&#62;Estamos com esse chamado aberto a algum tempo, você conseguiu as informações do SMTP para que possamos configurar o disparo de e-mail?&#60;/p&#62;',0,1,'2024-07-03 13:42:07','2024-07-03 13:42:07',1,0,0),(165,'Ticket',2024041601,'2024-07-03 13:45:10',46,0,'&#60;p&#62;Olá Roberta!&#60;/p&#62;\r\n&#60;p&#62;Esse chamado ainda necessita de atendimento?&#60;/p&#62;\r\n&#60;p&#62;Qualquer dúvida ou novas informações poderia, por gentileza, nos avisar?&#60;/p&#62;',0,1,'2024-07-03 13:45:10','2024-07-03 13:45:10',1,0,0),(166,'Ticket',2024041201,'2024-07-03 13:47:12',46,0,'&#60;p&#62;Olá Gustavo!&#60;/p&#62;\r\n&#60;p&#62;O chamado está sendo encerrado por falta de comunicação.&#60;/p&#62;\r\n&#60;p&#62;Qualquer dúvida, por favor, entrar em contato.&#60;/p&#62;',0,1,'2024-07-03 13:47:12','2024-07-03 13:47:12',1,0,0),(167,'Ticket',2024020601,'2024-07-03 13:49:36',46,0,'&#60;p&#62;Olá Gustavo!&#60;/p&#62;\r\n&#60;p&#62;Esse chamado ainda necessita de atendimento?&#60;/p&#62;\r\n&#60;p&#62;Qualquer dúvida nos avise.&#60;/p&#62;',0,1,'2024-07-03 13:49:36','2024-07-03 13:49:36',1,0,0),(168,'Ticket',2023122602,'2024-07-03 13:50:33',46,0,'&#60;p&#62;Olá Gustavo!&#60;/p&#62;\r\n&#60;p&#62;Esse chamado ainda necessita de atendimento?&#60;/p&#62;\r\n&#60;p&#62;Qualquer dúvida nos avise.&#60;/p&#62;',0,1,'2024-07-03 13:50:33','2024-07-03 13:50:33',1,0,0),(169,'Ticket',2023121801,'2024-07-03 13:51:10',46,0,'&#60;p&#62;Olá Gustavo!&#60;/p&#62;\r\n&#60;p&#62;Esse chamado ainda necessita de atendimento?&#60;/p&#62;\r\n&#60;p&#62;Qualquer dúvida nos avise.&#60;/p&#62;',0,1,'2024-07-03 13:51:10','2024-07-03 13:51:10',1,0,0),(170,'Ticket',2024031508,'2024-07-03 14:04:51',10,0,'&#60;p&#62;Realizando importação de dados no ambiente de homologação, estou em contato com a Angela para mostrar o andamento.&#60;/p&#62;',0,1,'2024-07-03 14:04:51','2024-07-03 14:04:51',4,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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `requesttypes_id` int(10) unsigned NOT NULL DEFAULT '0',
  `is_private` tinyint(4) NOT NULL DEFAULT '0',
  `comment` text COLLATE utf8mb4_unicode_ci,
  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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `items_id` int(10) unsigned NOT NULL DEFAULT '0',
  `solutiontypes_id` int(10) unsigned NOT NULL DEFAULT '0',
  `solutiontype_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `glpi_itilsolutions` VALUES (3,'Ticket',2023100904,0,NULL,'&#60;p&#62;Chamado encerrado pela MEGA&#60;/p&#62;','2023-10-24 18:12:20','2023-10-24 18:12:20',NULL,10,NULL,0,0,NULL,2,NULL),(4,'Ticket',2023101602,0,NULL,'&#60;p&#62;Olá Roberta,&#60;/p&#62;\r\n&#60;p&#62;Por se tratar de uma melhoria, estaremos encerrando este ticket e endereçar pedido para a área Comercial. O Jimenez entrará em contato para te enviar uma proposta comercial para essa melhoria.&#60;/p&#62;\r\n&#60;p&#62;Qualquer dúvida estamos a disposição!!&#60;/p&#62;','2023-10-25 19:06:21','2023-10-25 19:06:21',NULL,10,NULL,0,0,NULL,2,NULL),(5,'Ticket',2023110701,0,NULL,'&#60;p&#62;Estarei encerrando este chamado, caso tenha alguma dúvida, por favor reabrir o mesmo!!&#60;/p&#62;\r\n&#60;p&#62; &#60;/p&#62;','2023-12-05 13:37:03','2023-12-05 13:37:03',NULL,10,NULL,0,0,NULL,2,NULL),(6,'Ticket',2023100902,0,NULL,'&#60;p&#62;Chamado solucionado.&#60;/p&#62;','2023-12-05 13:38:54','2023-12-05 13:38:54',NULL,10,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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `completename` text COLLATE utf8mb4_unicode_ci,
  `comment` text COLLATE utf8mb4_unicode_ci,
  `level` int(11) NOT NULL DEFAULT '0',
  `sons_cache` longtext COLLATE utf8mb4_unicode_ci,
  `ancestors_cache` longtext COLLATE utf8mb4_unicode_ci,
  `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 COLLATE utf8mb4_unicode_ci,
  `answer` longtext COLLATE utf8mb4_unicode_ci,
  `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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci,
  `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) COLLATE utf8mb4_unicode_ci 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 COLLATE utf8mb4_unicode_ci,
  `answer` longtext COLLATE utf8mb4_unicode_ci,
  `language` varchar(10) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `answer` longtext COLLATE utf8mb4_unicode_ci,
  `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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `comment` text COLLATE utf8mb4_unicode_ci,
  `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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `caller_name` varchar(255) COLLATE utf8mb4_unicode_ci 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 COLLATE utf8mb4_unicode_ci,
  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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci,
  `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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `data` text COLLATE utf8mb4_unicode_ci,
  `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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `locations_id` int(10) unsigned NOT NULL DEFAULT '0',
  `completename` text COLLATE utf8mb4_unicode_ci,
  `comment` text COLLATE utf8mb4_unicode_ci,
  `level` int(11) NOT NULL DEFAULT '0',
  `ancestors_cache` longtext COLLATE utf8mb4_unicode_ci,
  `sons_cache` longtext COLLATE utf8mb4_unicode_ci,
  `address` text COLLATE utf8mb4_unicode_ci,
  `postcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `town` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `building` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `room` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `altitude` varchar(255) COLLATE utf8mb4_unicode_ci 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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_locations`
--

INSERT INTO `glpi_locations` VALUES (1,0,0,'Remoto',0,'Remoto','',1,'[]',NULL,'','','','','','','','','','','2023-06-20 13:08:02','2023-06-20 13:08:02');

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

CREATE TABLE `glpi_lockedfields` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `itemtype` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `items_id` int(10) unsigned NOT NULL DEFAULT '0',
  `field` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `items_id` int(10) unsigned NOT NULL DEFAULT '0',
  `itemtype_link` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `linked_action` int(11) NOT NULL DEFAULT '0' COMMENT 'see define.php HISTORY_* constant',
  `user_name` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `new_value` varchar(255) COLLATE utf8mb4_unicode_ci 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=7287 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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



--
-- Table structure for table `glpi_mailcollectors`
--

CREATE TABLE `glpi_mailcollectors` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `host` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `login` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `filesize_max` int(11) NOT NULL DEFAULT '2097152',
  `is_active` tinyint(4) NOT NULL DEFAULT '1',
  `date_mod` timestamp NULL DEFAULT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci,
  `passwd` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `accepted` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `refused` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `errors` int(11) NOT NULL DEFAULT '0',
  `use_mail_date` tinyint(4) NOT NULL DEFAULT '0',
  `date_creation` timestamp NULL DEFAULT NULL,
  `requester_field` int(11) NOT NULL DEFAULT '0',
  `add_cc_to_observer` tinyint(4) NOT NULL DEFAULT '0',
  `collect_only_unread` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `is_active` (`is_active`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_mailcollectors`
--


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

CREATE TABLE `glpi_manuallinks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(8096) COLLATE utf8mb4_unicode_ci NOT NULL,
  `open_window` tinyint(4) NOT NULL DEFAULT '1',
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci,
  `items_id` int(10) unsigned NOT NULL DEFAULT '0',
  `itemtype` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci,
  `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=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_manufacturers`
--

INSERT INTO `glpi_manufacturers` VALUES (1,'Mega Platform hopex','https://www.mega.com/hopex-platform','2023-06-20 13:05:10','2023-06-20 13:05:10'),(2,'Qualiware','https://www.qualiware.com/','2023-06-20 13:49:08','2023-06-20 13:49:08');

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

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

--
-- 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'a, a/b, a/b/g, a/b/g/n, a/b/g/n/y',
  `mode` varchar(20) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci,
  `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) COLLATE utf8mb4_unicode_ci 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 COLLATE utf8mb4_unicode_ci,
  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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `glpi_notepads` VALUES (1,'Computer',1,'2023-10-04 13:31:32','2023-10-04 13:31:32',10,10,'');

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

CREATE TABLE `glpi_notifications` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `entities_id` int(10) unsigned NOT NULL DEFAULT '0',
  `itemtype` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci,
  `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=87 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_notifications`
--

INSERT INTO `glpi_notifications` VALUES (1,'Alert Tickets not closed',0,'Ticket','alertnotclosed',NULL,1,1,NULL,NULL,1),(2,'New Ticket',0,'Ticket','new',NULL,1,1,NULL,NULL,1),(3,'Update Ticket',0,'Ticket','update',NULL,1,0,NULL,NULL,1),(4,'Close Ticket',0,'Ticket','closed',NULL,1,1,NULL,NULL,1),(5,'Add Followup',0,'Ticket','add_followup',NULL,1,1,NULL,NULL,1),(6,'Add Task',0,'Ticket','add_task',NULL,1,1,NULL,NULL,1),(7,'Update Followup',0,'Ticket','update_followup',NULL,1,1,NULL,NULL,1),(8,'Update Task',0,'Ticket','update_task',NULL,1,1,NULL,NULL,1),(9,'Delete Followup',0,'Ticket','delete_followup',NULL,1,1,NULL,NULL,1),(10,'Delete Task',0,'Ticket','delete_task',NULL,1,1,NULL,NULL,1),(11,'Resolve ticket',0,'Ticket','solved',NULL,1,1,NULL,NULL,1),(12,'Ticket Validation',0,'Ticket','validation',NULL,1,1,NULL,NULL,1),(13,'New Reservation',0,'Reservation','new',NULL,1,1,NULL,NULL,1),(14,'Update Reservation',0,'Reservation','update',NULL,1,1,NULL,NULL,1),(15,'Delete Reservation',0,'Reservation','delete',NULL,1,1,NULL,NULL,1),(16,'Alert Reservation',0,'Reservation','alert',NULL,1,1,NULL,NULL,1),(17,'Contract Notice',0,'Contract','notice',NULL,1,1,NULL,NULL,1),(18,'Contract End',0,'Contract','end',NULL,1,1,NULL,NULL,1),(19,'MySQL Synchronization',0,'DBConnection','desynchronization',NULL,1,1,NULL,NULL,1),(20,'Cartridges',0,'CartridgeItem','alert',NULL,1,1,NULL,NULL,1),(21,'Consumables',0,'ConsumableItem','alert',NULL,1,1,NULL,NULL,1),(22,'Infocoms',0,'Infocom','alert',NULL,1,1,NULL,NULL,1),(23,'Software Licenses',0,'SoftwareLicense','alert',NULL,1,1,NULL,NULL,1),(24,'Ticket Recall',0,'Ticket','recall',NULL,1,1,NULL,NULL,1),(25,'Password Forget',0,'User','passwordforget',NULL,1,1,NULL,NULL,1),(26,'Ticket Satisfaction',0,'Ticket','satisfaction',NULL,1,1,NULL,NULL,1),(27,'Item not unique',0,'FieldUnicity','refuse',NULL,1,1,NULL,NULL,1),(28,'CronTask Watcher',0,'CronTask','alert',NULL,1,1,NULL,NULL,1),(29,'New Problem',0,'Problem','new',NULL,1,1,NULL,NULL,1),(30,'Update Problem',0,'Problem','update',NULL,1,1,NULL,NULL,1),(31,'Resolve Problem',0,'Problem','solved',NULL,1,1,NULL,NULL,1),(32,'Add Task',0,'Problem','add_task',NULL,1,1,NULL,NULL,1),(33,'Update Task',0,'Problem','update_task',NULL,1,1,NULL,NULL,1),(34,'Delete Task',0,'Problem','delete_task',NULL,1,1,NULL,NULL,1),(35,'Close Problem',0,'Problem','closed',NULL,1,1,NULL,NULL,1),(36,'Delete Problem',0,'Problem','delete',NULL,1,1,NULL,NULL,1),(37,'Ticket Validation Answer',0,'Ticket','validation_answer',NULL,1,1,NULL,NULL,1),(38,'Contract End Periodicity',0,'Contract','periodicity',NULL,1,1,NULL,NULL,1),(39,'Contract Notice Periodicity',0,'Contract','periodicitynotice',NULL,1,1,NULL,NULL,1),(40,'Planning recall',0,'PlanningRecall','planningrecall',NULL,1,1,NULL,NULL,1),(41,'Delete Ticket',0,'Ticket','delete',NULL,1,1,NULL,NULL,1),(42,'New Change',0,'Change','new',NULL,1,1,NULL,NULL,1),(43,'Update Change',0,'Change','update',NULL,1,1,NULL,NULL,1),(44,'Resolve Change',0,'Change','solved',NULL,1,1,NULL,NULL,1),(45,'Add Task',0,'Change','add_task',NULL,1,1,NULL,NULL,1),(46,'Update Task',0,'Change','update_task',NULL,1,1,NULL,NULL,1),(47,'Delete Task',0,'Change','delete_task',NULL,1,1,NULL,NULL,1),(48,'Close Change',0,'Change','closed',NULL,1,1,NULL,NULL,1),(49,'Delete Change',0,'Change','delete',NULL,1,1,NULL,NULL,1),(50,'Ticket Satisfaction Answer',0,'Ticket','replysatisfaction',NULL,1,1,NULL,NULL,1),(51,'Receiver errors',0,'MailCollector','error',NULL,1,1,NULL,NULL,1),(52,'New Project',0,'Project','new',NULL,1,1,NULL,NULL,1),(53,'Update Project',0,'Project','update',NULL,1,1,NULL,NULL,1),(54,'Delete Project',0,'Project','delete',NULL,1,1,NULL,NULL,1),(55,'New Project Task',0,'ProjectTask','new',NULL,1,1,NULL,NULL,1),(56,'Update Project Task',0,'ProjectTask','update',NULL,1,1,NULL,NULL,1),(57,'Delete Project Task',0,'ProjectTask','delete',NULL,1,1,NULL,NULL,1),(58,'Request Unlock Items',0,'ObjectLock','unlock',NULL,1,1,NULL,NULL,1),(59,'New user in requesters',0,'Ticket','requester_user',NULL,1,1,NULL,NULL,1),(60,'New group in requesters',0,'Ticket','requester_group',NULL,1,1,NULL,NULL,1),(61,'New user in observers',0,'Ticket','observer_user',NULL,1,1,NULL,NULL,1),(62,'New group in observers',0,'Ticket','observer_group',NULL,1,1,NULL,NULL,1),(63,'New user in assignees',0,'Ticket','assign_user',NULL,1,1,NULL,NULL,1),(64,'New group in assignees',0,'Ticket','assign_group',NULL,1,1,NULL,NULL,1),(65,'New supplier in assignees',0,'Ticket','assign_supplier',NULL,1,1,NULL,NULL,1),(66,'Saved searches',0,'SavedSearch_Alert','alert',NULL,1,1,NULL,NULL,1),(67,'Certificates',0,'Certificate','alert',NULL,1,1,NULL,NULL,1),(68,'Alert expired domains',0,'Domain','ExpiredDomains',NULL,1,1,NULL,NULL,1),(69,'Alert domains close expiries',0,'Domain','DomainsWhichExpire',NULL,1,1,NULL,NULL,1),(70,'Password expires alert',0,'User','passwordexpires',NULL,1,1,NULL,NULL,1),(71,'Check plugin updates',0,'Glpi\\Marketplace\\Controller','checkpluginsupdate',NULL,1,1,NULL,NULL,1),(72,'New user mentionned',0,'Ticket','user_mention',NULL,1,1,NULL,NULL,1),(78,'Formulário criado',0,'PluginFormcreatorFormAnswer','plugin_formcreator_form_created','',1,1,'2023-09-28 14:31:05','2023-09-28 14:31:05',1),(79,'Um formulário precisa de validação',0,'PluginFormcreatorFormAnswer','plugin_formcreator_need_validation','',1,1,'2023-09-28 14:31:05','2023-09-28 14:31:05',1),(80,'Formulário rejeitado',0,'PluginFormcreatorFormAnswer','plugin_formcreator_refused','',1,1,'2023-09-28 14:31:05','2023-09-28 14:31:05',1),(81,'Formulário aceito',0,'PluginFormcreatorFormAnswer','plugin_formcreator_accepted','',1,1,'2023-09-28 14:31:05','2023-09-28 14:31:05',1),(82,'Formulário deletado',0,'PluginFormcreatorFormAnswer','plugin_formcreator_deleted','',1,1,'2023-09-28 14:31:05','2023-09-28 14:31:05',1),(83,'Notificação por \"Mais Relatórios\"',0,'PluginMreportingNotification','sendReporting','',1,1,'2023-10-09 13:08:13','2023-10-09 13:08:13',1),(84,'New Task',0,'PluginTasklistsTask','newtask','',1,1,'2023-10-19 12:12:10','2023-10-19 12:12:10',1),(85,'Update Task',0,'PluginTasklistsTask','updatetask','',1,1,'2023-10-19 12:12:10','2023-10-19 12:12:10',1),(86,'Delete Task',0,'PluginTasklistsTask','deletetask','',1,1,'2023-10-19 12:12:10','2023-10-19 12:12:10',1);

--
-- Table structure for table `glpi_notifications_notificationtemplates`
--

CREATE TABLE `glpi_notifications_notificationtemplates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `notifications_id` int(10) unsigned NOT NULL DEFAULT '0',
  `mode` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'See Notification_NotificationTemplate::MODE_* constants',
  `notificationtemplates_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`notifications_id`,`mode`,`notificationtemplates_id`),
  KEY `notificationtemplates_id` (`notificationtemplates_id`),
  KEY `mode` (`mode`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_notifications_notificationtemplates`
--

INSERT INTO `glpi_notifications_notificationtemplates` VALUES (1,1,'mailing',6),(2,2,'mailing',4),(3,3,'mailing',4),(4,4,'mailing',4),(5,5,'mailing',4),(74,5,'mailing',29),(6,6,'mailing',4),(7,7,'mailing',4),(8,8,'mailing',4),(9,9,'mailing',4),(10,10,'mailing',4),(11,11,'mailing',4),(12,12,'mailing',7),(13,13,'mailing',2),(14,14,'mailing',2),(15,15,'mailing',2),(16,16,'mailing',3),(17,17,'mailing',12),(18,18,'mailing',12),(19,19,'mailing',1),(20,20,'mailing',8),(21,21,'mailing',9),(22,22,'mailing',10),(23,23,'mailing',11),(24,24,'mailing',4),(25,25,'mailing',13),(26,26,'mailing',14),(27,27,'mailing',15),(28,28,'mailing',16),(29,29,'mailing',17),(30,30,'mailing',17),(31,31,'mailing',17),(32,32,'mailing',17),(33,33,'mailing',17),(34,34,'mailing',17),(35,35,'mailing',17),(36,36,'mailing',17),(37,37,'mailing',7),(38,38,'mailing',12),(39,39,'mailing',12),(40,40,'mailing',18),(41,41,'mailing',4),(42,42,'mailing',19),(43,43,'mailing',19),(44,44,'mailing',19),(45,45,'mailing',19),(46,46,'mailing',19),(47,47,'mailing',19),(48,48,'mailing',19),(49,49,'mailing',19),(50,50,'mailing',14),(51,51,'mailing',20),(52,52,'mailing',21),(53,53,'mailing',21),(54,54,'mailing',21),(55,55,'mailing',22),(56,56,'mailing',22),(57,57,'mailing',22),(58,58,'mailing',23),(59,59,'mailing',4),(60,60,'mailing',4),(61,61,'mailing',4),(62,62,'mailing',4),(63,63,'mailing',4),(64,64,'mailing',4),(65,65,'mailing',4),(66,66,'mailing',24),(67,67,'mailing',25),(68,68,'mailing',26),(69,69,'mailing',26),(70,70,'mailing',27),(71,71,'mailing',28),(72,72,'mailing',4),(80,78,'mailing',35),(81,79,'mailing',36),(82,80,'mailing',37),(83,81,'mailing',38),(84,82,'mailing',39),(85,83,'mailing',40),(86,84,'mailing',41),(87,85,'mailing',41),(88,86,'mailing',41);

--
-- Table structure for table `glpi_notificationtargets`
--

CREATE TABLE `glpi_notificationtargets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int(10) unsigned NOT NULL DEFAULT '0',
  `type` int(11) NOT NULL DEFAULT '0',
  `notifications_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `items` (`type`,`items_id`),
  KEY `notifications_id` (`notifications_id`)
) ENGINE=InnoDB AUTO_INCREMENT=153 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_notificationtargets`
--

INSERT INTO `glpi_notificationtargets` VALUES (1,3,1,13),(2,1,1,13),(3,3,2,2),(4,1,1,2),(5,1,1,3),(6,1,1,5),(7,1,1,4),(8,2,1,3),(9,4,1,3),(10,3,1,2),(11,3,1,3),(12,3,1,5),(13,3,1,4),(14,1,1,19),(15,14,1,12),(16,3,1,14),(17,1,1,14),(18,3,1,15),(19,1,1,15),(20,1,1,6),(21,3,1,6),(22,1,1,7),(23,3,1,7),(24,1,1,8),(25,3,1,8),(26,1,1,9),(27,3,1,9),(28,1,1,10),(29,3,1,10),(30,1,1,11),(31,3,1,11),(32,19,1,25),(33,3,1,26),(34,21,1,2),(35,21,1,3),(36,21,1,5),(37,21,1,4),(38,21,1,6),(39,21,1,7),(40,21,1,8),(41,21,1,9),(42,21,1,10),(43,21,1,11),(46,1,1,28),(47,3,1,29),(48,1,1,29),(49,21,1,29),(50,2,1,30),(51,4,1,30),(52,3,1,30),(53,1,1,30),(54,21,1,30),(55,3,1,31),(56,1,1,31),(57,21,1,31),(58,3,1,32),(59,1,1,32),(60,21,1,32),(61,3,1,33),(62,1,1,33),(63,21,1,33),(64,3,1,34),(65,1,1,34),(66,21,1,34),(67,3,1,35),(68,1,1,35),(69,21,1,35),(70,3,1,36),(71,1,1,36),(72,21,1,36),(73,14,1,37),(74,3,1,40),(75,1,1,41),(76,3,1,42),(77,1,1,42),(78,21,1,42),(79,2,1,43),(80,4,1,43),(81,3,1,43),(82,1,1,43),(83,21,1,43),(84,3,1,44),(85,1,1,44),(86,21,1,44),(87,3,1,45),(88,1,1,45),(89,21,1,45),(90,3,1,46),(91,1,1,46),(92,21,1,46),(93,3,1,47),(94,1,1,47),(95,21,1,47),(96,3,1,48),(97,1,1,48),(98,21,1,48),(99,3,1,49),(100,1,1,49),(101,21,1,49),(102,3,1,50),(103,2,1,50),(104,1,1,51),(105,27,1,52),(106,1,1,52),(107,28,1,52),(108,27,1,53),(109,1,1,53),(110,28,1,53),(111,27,1,54),(112,1,1,54),(113,28,1,54),(114,31,1,55),(115,1,1,55),(116,32,1,55),(117,31,1,56),(118,1,1,56),(119,32,1,56),(120,31,1,57),(121,1,1,57),(122,32,1,57),(123,19,1,58),(124,3,1,59),(125,13,1,60),(126,21,1,61),(127,20,1,62),(128,2,1,63),(129,9,1,64),(130,8,1,65),(131,19,1,66),(132,5,1,67),(133,23,1,67),(134,5,1,68),(135,23,1,68),(136,5,1,69),(137,23,1,69),(138,19,1,70),(139,1,1,71),(140,39,1,72),(141,4,2,23),(147,101,1,78),(148,102,1,79),(149,101,1,80),(150,101,1,81),(151,101,1,82),(152,1,1,83);

--
-- Table structure for table `glpi_notificationtemplates`
--

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

--
-- Dumping data for table `glpi_notificationtemplates`
--

INSERT INTO `glpi_notificationtemplates` VALUES (1,'MySQL Synchronization','DBConnection',NULL,NULL,NULL,NULL),(2,'Reservations','Reservation',NULL,NULL,NULL,NULL),(3,'Alert Reservation','Reservation',NULL,NULL,NULL,NULL),(4,'Tickets','Ticket',NULL,NULL,NULL,NULL),(5,'Tickets (Simple)','Ticket',NULL,NULL,NULL,NULL),(6,'Alert Tickets not closed','Ticket',NULL,NULL,NULL,NULL),(7,'Tickets Validation','Ticket',NULL,NULL,NULL,NULL),(8,'Cartridges','CartridgeItem',NULL,NULL,NULL,NULL),(9,'Consumables','ConsumableItem',NULL,NULL,NULL,NULL),(10,'Infocoms','Infocom',NULL,NULL,NULL,NULL),(11,'Licenses','SoftwareLicense',NULL,NULL,NULL,NULL),(12,'Contracts','Contract',NULL,NULL,NULL,NULL),(13,'Password Forget','User',NULL,NULL,NULL,NULL),(14,'Ticket Satisfaction','Ticket',NULL,NULL,NULL,NULL),(15,'Item not unique','FieldUnicity',NULL,NULL,NULL,NULL),(16,'CronTask','CronTask',NULL,NULL,NULL,NULL),(17,'Problems','Problem',NULL,NULL,NULL,NULL),(18,'Planning recall','PlanningRecall',NULL,NULL,NULL,NULL),(19,'Changes','Change',NULL,NULL,NULL,NULL),(20,'Receiver errors','MailCollector',NULL,NULL,NULL,NULL),(21,'Projects','Project',NULL,NULL,NULL,NULL),(22,'Project Tasks','ProjectTask',NULL,NULL,NULL,NULL),(23,'Unlock Item request','ObjectLock',NULL,NULL,NULL,NULL),(24,'Saved searches alerts','SavedSearch_Alert',NULL,NULL,NULL,NULL),(25,'Certificates','Certificate',NULL,NULL,NULL,NULL),(26,'Alert domains','Domain',NULL,NULL,NULL,NULL),(27,'Password expires alert','User',NULL,NULL,NULL,NULL),(28,'Plugin updates','Glpi\\Marketplace\\Controller',NULL,NULL,NULL,NULL),(29,'Ticket Resposta','Ticket','2023-07-24 20:14:43','','','2023-07-24 20:14:43'),(35,'Formulário criado','PluginFormcreatorFormAnswer','2023-09-28 14:31:05','',NULL,'2023-09-28 14:31:05'),(36,'Um formulário precisa de validação','PluginFormcreatorFormAnswer','2023-09-28 14:31:05','',NULL,'2023-09-28 14:31:05'),(37,'Formulário rejeitado','PluginFormcreatorFormAnswer','2023-09-28 14:31:05','',NULL,'2023-09-28 14:31:05'),(38,'Formulário aceito','PluginFormcreatorFormAnswer','2023-09-28 14:31:05','',NULL,'2023-09-28 14:31:05'),(39,'Formulário deletado','PluginFormcreatorFormAnswer','2023-09-28 14:31:05','',NULL,'2023-09-28 14:31:05'),(40,'Notificação por \"Mais Relatórios\"','PluginMreportingNotification','2023-10-09 13:08:13','',NULL,'2023-10-09 13:08:13'),(41,'Tasks','PluginTasklistsTask','2023-10-19 12:12:10','','','2023-10-19 12:12:10');

--
