--
-- Host: localhost    Database: glpi
-- ------------------------------------------------------


--
-- Table structure for table `glpi_alerts`
--

CREATE TABLE `glpi_alerts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `itemtype` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `items_id` int(11) NOT NULL DEFAULT 0,
  `type` int(11) NOT NULL DEFAULT 0 COMMENT 'see define.php ALERT_* constant',
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`itemtype`,`items_id`,`type`),
  KEY `type` (`type`),
  KEY `date` (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_alerts`
--


--
-- Table structure for table `glpi_applianceenvironments`
--

CREATE TABLE `glpi_applianceenvironments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_applianceenvironments`
--


--
-- Table structure for table `glpi_appliancerelations`
--

CREATE TABLE `glpi_appliancerelations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appliances_items_id` int(11) NOT NULL DEFAULT 0,
  `relations_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `appliances_items_id` (`appliances_items_id`),
  KEY `relations_id` (`relations_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_appliancerelations`
--


--
-- Table structure for table `glpi_appliances`
--

CREATE TABLE `glpi_appliances` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `appliancetypes_id` int(11) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `locations_id` int(11) NOT NULL DEFAULT 0,
  `manufacturers_id` int(11) NOT NULL DEFAULT 0,
  `applianceenvironments_id` int(11) NOT NULL DEFAULT 0,
  `users_id` int(11) NOT NULL DEFAULT 0,
  `users_id_tech` int(11) NOT NULL DEFAULT 0,
  `groups_id` int(11) NOT NULL DEFAULT 0,
  `groups_id_tech` int(11) NOT NULL DEFAULT 0,
  `relationtype` int(11) NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `states_id` int(11) NOT NULL DEFAULT 0,
  `externalidentifier` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `serial` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `otherserial` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`externalidentifier`),
  KEY `entities_id` (`entities_id`),
  KEY `name` (`name`),
  KEY `is_deleted` (`is_deleted`),
  KEY `appliancetypes_id` (`appliancetypes_id`),
  KEY `locations_id` (`locations_id`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `applianceenvironments_id` (`applianceenvironments_id`),
  KEY `users_id` (`users_id`),
  KEY `users_id_tech` (`users_id_tech`),
  KEY `groups_id` (`groups_id`),
  KEY `groups_id_tech` (`groups_id_tech`),
  KEY `states_id` (`states_id`),
  KEY `serial` (`serial`),
  KEY `otherserial` (`otherserial`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_appliances`
--


--
-- Table structure for table `glpi_appliances_items`
--

CREATE TABLE `glpi_appliances_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appliances_id` int(11) NOT NULL DEFAULT 0,
  `items_id` int(11) NOT NULL DEFAULT 0,
  `itemtype` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`appliances_id`,`items_id`,`itemtype`),
  KEY `appliances_id` (`appliances_id`),
  KEY `item` (`itemtype`,`items_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_appliances_items`
--


--
-- Table structure for table `glpi_appliancetypes`
--

CREATE TABLE `glpi_appliancetypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `externalidentifier` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `externalidentifier` (`externalidentifier`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_appliancetypes`
--


--
-- Table structure for table `glpi_authldapreplicates`
--

CREATE TABLE `glpi_authldapreplicates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `authldaps_id` int(11) NOT NULL DEFAULT 0,
  `host` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `port` int(11) NOT NULL DEFAULT 389,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `authldaps_id` (`authldaps_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_authldapreplicates`
--


--
-- Table structure for table `glpi_authmails`
--

CREATE TABLE `glpi_authmails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `connect_string` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `host` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `date_mod` (`date_mod`),
  KEY `is_active` (`is_active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_authmails`
--


--
-- Table structure for table `glpi_autoupdatesystems`
--

CREATE TABLE `glpi_autoupdatesystems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_autoupdatesystems`
--


--
-- Table structure for table `glpi_blacklistedmailcontents`
--

CREATE TABLE `glpi_blacklistedmailcontents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_blacklistedmailcontents`
--


--
-- Table structure for table `glpi_blacklists`
--

CREATE TABLE `glpi_blacklists` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(11) NOT NULL DEFAULT 0,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `type` (`type`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_blacklists`
--

INSERT INTO `glpi_blacklists` VALUES (1,1,'empty IP','',NULL,NULL,NULL),(2,1,'localhost','127.0.0.1',NULL,NULL,NULL),(3,1,'zero IP','0.0.0.0',NULL,NULL,NULL),(4,2,'empty MAC','',NULL,NULL,NULL);

--
-- Table structure for table `glpi_budgets`
--

CREATE TABLE `glpi_budgets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `begin_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `value` decimal(20,4) NOT NULL DEFAULT 0.0000,
  `is_template` tinyint(1) NOT NULL DEFAULT 0,
  `template_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `locations_id` int(11) NOT NULL DEFAULT 0,
  `budgettypes_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `is_recursive` (`is_recursive`),
  KEY `entities_id` (`entities_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `begin_date` (`begin_date`),
  KEY `end_date` (`end_date`),
  KEY `is_template` (`is_template`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `locations_id` (`locations_id`),
  KEY `budgettypes_id` (`budgettypes_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_budgets`
--


--
-- Table structure for table `glpi_budgettypes`
--

CREATE TABLE `glpi_budgettypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_budgettypes`
--


--
-- Table structure for table `glpi_businesscriticities`
--

CREATE TABLE `glpi_businesscriticities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `businesscriticities_id` int(11) NOT NULL DEFAULT 0,
  `completename` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `level` int(11) NOT NULL DEFAULT 0,
  `ancestors_cache` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `sons_cache` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`businesscriticities_id`,`name`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_businesscriticities`
--


--
-- Table structure for table `glpi_calendars`
--

CREATE TABLE `glpi_calendars` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `cache_duration` text COLLATE utf8_unicode_ci 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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_calendars`
--

INSERT INTO `glpi_calendars` VALUES (1,'Default',0,1,'Default calendar',NULL,'[0,43200,43200,43200,43200,43200,0]',NULL);

--
-- Table structure for table `glpi_calendars_holidays`
--

CREATE TABLE `glpi_calendars_holidays` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `calendars_id` int(11) NOT NULL DEFAULT 0,
  `holidays_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`calendars_id`,`holidays_id`),
  KEY `holidays_id` (`holidays_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_calendars_holidays`
--


--
-- Table structure for table `glpi_calendarsegments`
--

CREATE TABLE `glpi_calendarsegments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `calendars_id` int(11) NOT NULL DEFAULT 0,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `day` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'numer of the day based on date(w)',
  `begin` time DEFAULT NULL,
  `end` time DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `calendars_id` (`calendars_id`),
  KEY `day` (`day`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_calendarsegments`
--

INSERT INTO `glpi_calendarsegments` VALUES (1,1,0,0,1,'08:00:00','20:00:00'),(2,1,0,0,2,'08:00:00','20:00:00'),(3,1,0,0,3,'08:00:00','20:00:00'),(4,1,0,0,4,'08:00:00','20:00:00'),(5,1,0,0,5,'08:00:00','20:00:00');

--
-- Table structure for table `glpi_cartridgeitems`
--

CREATE TABLE `glpi_cartridgeitems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `locations_id` int(11) NOT NULL DEFAULT 0,
  `cartridgeitemtypes_id` int(11) NOT NULL DEFAULT 0,
  `manufacturers_id` int(11) NOT NULL DEFAULT 0,
  `users_id_tech` int(11) NOT NULL DEFAULT 0,
  `groups_id_tech` int(11) NOT NULL DEFAULT 0,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `alarm_threshold` int(11) NOT NULL DEFAULT 10,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `locations_id` (`locations_id`),
  KEY `users_id_tech` (`users_id_tech`),
  KEY `cartridgeitemtypes_id` (`cartridgeitemtypes_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `alarm_threshold` (`alarm_threshold`),
  KEY `groups_id_tech` (`groups_id_tech`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_cartridgeitems`
--


--
-- Table structure for table `glpi_cartridgeitems_printermodels`
--

CREATE TABLE `glpi_cartridgeitems_printermodels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cartridgeitems_id` int(11) NOT NULL DEFAULT 0,
  `printermodels_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`printermodels_id`,`cartridgeitems_id`),
  KEY `cartridgeitems_id` (`cartridgeitems_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_cartridgeitems_printermodels`
--


--
-- Table structure for table `glpi_cartridgeitemtypes`
--

CREATE TABLE `glpi_cartridgeitemtypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_cartridgeitemtypes`
--


--
-- Table structure for table `glpi_cartridges`
--

CREATE TABLE `glpi_cartridges` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `cartridgeitems_id` int(11) NOT NULL DEFAULT 0,
  `printers_id` int(11) NOT NULL DEFAULT 0,
  `date_in` date DEFAULT NULL,
  `date_use` date DEFAULT NULL,
  `date_out` date DEFAULT NULL,
  `pages` int(11) NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cartridgeitems_id` (`cartridgeitems_id`),
  KEY `printers_id` (`printers_id`),
  KEY `entities_id` (`entities_id`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_cartridges`
--


--
-- Table structure for table `glpi_certificates`
--

CREATE TABLE `glpi_certificates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `serial` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `otherserial` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `is_template` tinyint(1) NOT NULL DEFAULT 0,
  `template_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `certificatetypes_id` int(11) NOT NULL DEFAULT 0 COMMENT 'RELATION to glpi_certificatetypes (id)',
  `dns_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dns_suffix` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `users_id_tech` int(11) NOT NULL DEFAULT 0 COMMENT 'RELATION to glpi_users (id)',
  `groups_id_tech` int(11) NOT NULL DEFAULT 0 COMMENT 'RELATION to glpi_groups (id)',
  `locations_id` int(11) NOT NULL DEFAULT 0 COMMENT 'RELATION to glpi_locations (id)',
  `manufacturers_id` int(11) NOT NULL DEFAULT 0 COMMENT 'RELATION to glpi_manufacturers (id)',
  `contact` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contact_num` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `users_id` int(11) NOT NULL DEFAULT 0,
  `groups_id` int(11) NOT NULL DEFAULT 0,
  `is_autosign` tinyint(1) NOT NULL DEFAULT 0,
  `date_expiration` date DEFAULT NULL,
  `states_id` int(11) NOT NULL DEFAULT 0 COMMENT 'RELATION to states (id)',
  `command` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `certificate_request` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `certificate_item` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_template` (`is_template`),
  KEY `is_deleted` (`is_deleted`),
  KEY `certificatetypes_id` (`certificatetypes_id`),
  KEY `users_id_tech` (`users_id_tech`),
  KEY `groups_id_tech` (`groups_id_tech`),
  KEY `groups_id` (`groups_id`),
  KEY `users_id` (`users_id`),
  KEY `locations_id` (`locations_id`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `states_id` (`states_id`),
  KEY `date_creation` (`date_creation`),
  KEY `date_mod` (`date_mod`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_certificates`
--


--
-- Table structure for table `glpi_certificates_items`
--

CREATE TABLE `glpi_certificates_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `certificates_id` int(11) NOT NULL DEFAULT 0,
  `items_id` int(11) NOT NULL DEFAULT 0 COMMENT 'RELATION to various tables, according to itemtype (id)',
  `itemtype` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT 'see .class.php file',
  `date_creation` timestamp NULL DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`certificates_id`,`itemtype`,`items_id`),
  KEY `device` (`items_id`,`itemtype`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `date_creation` (`date_creation`),
  KEY `date_mod` (`date_mod`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_certificates_items`
--


--
-- Table structure for table `glpi_certificatetypes`
--

CREATE TABLE `glpi_certificatetypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `name` (`name`),
  KEY `date_creation` (`date_creation`),
  KEY `date_mod` (`date_mod`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_certificatetypes`
--


--
-- Table structure for table `glpi_changecosts`
--

CREATE TABLE `glpi_changecosts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `changes_id` int(11) NOT NULL DEFAULT 0,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `begin_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `actiontime` int(11) NOT NULL DEFAULT 0,
  `cost_time` decimal(20,4) NOT NULL DEFAULT 0.0000,
  `cost_fixed` decimal(20,4) NOT NULL DEFAULT 0.0000,
  `cost_material` decimal(20,4) NOT NULL DEFAULT 0.0000,
  `budgets_id` int(11) NOT NULL DEFAULT 0,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `changes_id` (`changes_id`),
  KEY `begin_date` (`begin_date`),
  KEY `end_date` (`end_date`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `budgets_id` (`budgets_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_changecosts`
--


--
-- Table structure for table `glpi_changes`
--

CREATE TABLE `glpi_changes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 1,
  `content` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date` timestamp NULL DEFAULT NULL,
  `solvedate` timestamp NULL DEFAULT NULL,
  `closedate` timestamp NULL DEFAULT NULL,
  `time_to_resolve` timestamp NULL DEFAULT NULL,
  `users_id_recipient` int(11) NOT NULL DEFAULT 0,
  `users_id_lastupdater` int(11) NOT NULL DEFAULT 0,
  `urgency` int(11) NOT NULL DEFAULT 1,
  `impact` int(11) NOT NULL DEFAULT 1,
  `priority` int(11) NOT NULL DEFAULT 1,
  `itilcategories_id` int(11) NOT NULL DEFAULT 0,
  `impactcontent` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `controlistcontent` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `rolloutplancontent` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `backoutplancontent` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `checklistcontent` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `global_validation` int(11) NOT NULL DEFAULT 1,
  `validation_percent` int(11) NOT NULL DEFAULT 0,
  `actiontime` int(11) NOT NULL DEFAULT 0,
  `begin_waiting_date` timestamp NULL DEFAULT NULL,
  `waiting_duration` int(11) NOT NULL DEFAULT 0,
  `close_delay_stat` int(11) NOT NULL DEFAULT 0,
  `solve_delay_stat` int(11) NOT NULL DEFAULT 0,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `is_deleted` (`is_deleted`),
  KEY `date` (`date`),
  KEY `closedate` (`closedate`),
  KEY `status` (`status`),
  KEY `priority` (`priority`),
  KEY `date_mod` (`date_mod`),
  KEY `itilcategories_id` (`itilcategories_id`),
  KEY `users_id_recipient` (`users_id_recipient`),
  KEY `solvedate` (`solvedate`),
  KEY `urgency` (`urgency`),
  KEY `impact` (`impact`),
  KEY `time_to_resolve` (`time_to_resolve`),
  KEY `global_validation` (`global_validation`),
  KEY `users_id_lastupdater` (`users_id_lastupdater`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_changes`
--


--
-- Table structure for table `glpi_changes_groups`
--

CREATE TABLE `glpi_changes_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `changes_id` int(11) NOT NULL DEFAULT 0,
  `groups_id` int(11) NOT NULL DEFAULT 0,
  `type` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`changes_id`,`type`,`groups_id`),
  KEY `group` (`groups_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_changes_groups`
--


--
-- Table structure for table `glpi_changes_items`
--

CREATE TABLE `glpi_changes_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `changes_id` int(11) NOT NULL DEFAULT 0,
  `itemtype` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `items_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`changes_id`,`itemtype`,`items_id`),
  KEY `item` (`itemtype`,`items_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_changes_items`
--


--
-- Table structure for table `glpi_changes_problems`
--

CREATE TABLE `glpi_changes_problems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `changes_id` int(11) NOT NULL DEFAULT 0,
  `problems_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`changes_id`,`problems_id`),
  KEY `problems_id` (`problems_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_changes_problems`
--


--
-- Table structure for table `glpi_changes_suppliers`
--

CREATE TABLE `glpi_changes_suppliers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `changes_id` int(11) NOT NULL DEFAULT 0,
  `suppliers_id` int(11) NOT NULL DEFAULT 0,
  `type` int(11) NOT NULL DEFAULT 1,
  `use_notification` tinyint(1) NOT NULL DEFAULT 0,
  `alternative_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`changes_id`,`type`,`suppliers_id`),
  KEY `group` (`suppliers_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_changes_suppliers`
--


--
-- Table structure for table `glpi_changes_tickets`
--

CREATE TABLE `glpi_changes_tickets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `changes_id` int(11) NOT NULL DEFAULT 0,
  `tickets_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`changes_id`,`tickets_id`),
  KEY `tickets_id` (`tickets_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_changes_tickets`
--


--
-- Table structure for table `glpi_changes_users`
--

CREATE TABLE `glpi_changes_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `changes_id` int(11) NOT NULL DEFAULT 0,
  `users_id` int(11) NOT NULL DEFAULT 0,
  `type` int(11) NOT NULL DEFAULT 1,
  `use_notification` tinyint(1) NOT NULL DEFAULT 0,
  `alternative_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`changes_id`,`type`,`users_id`,`alternative_email`),
  KEY `user` (`users_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_changes_users`
--


--
-- Table structure for table `glpi_changetasks`
--

CREATE TABLE `glpi_changetasks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `changes_id` int(11) NOT NULL DEFAULT 0,
  `taskcategories_id` int(11) NOT NULL DEFAULT 0,
  `state` int(11) NOT NULL DEFAULT 0,
  `date` timestamp NULL DEFAULT NULL,
  `begin` timestamp NULL DEFAULT NULL,
  `end` timestamp NULL DEFAULT NULL,
  `users_id` int(11) NOT NULL DEFAULT 0,
  `users_id_editor` int(11) NOT NULL DEFAULT 0,
  `users_id_tech` int(11) NOT NULL DEFAULT 0,
  `groups_id_tech` int(11) NOT NULL DEFAULT 0,
  `content` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `actiontime` int(11) NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `tasktemplates_id` int(11) NOT NULL DEFAULT 0,
  `timeline_position` tinyint(1) NOT NULL DEFAULT 0,
  `is_private` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uuid` (`uuid`),
  KEY `changes_id` (`changes_id`),
  KEY `state` (`state`),
  KEY `users_id` (`users_id`),
  KEY `users_id_editor` (`users_id_editor`),
  KEY `users_id_tech` (`users_id_tech`),
  KEY `groups_id_tech` (`groups_id_tech`),
  KEY `date` (`date`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `begin` (`begin`),
  KEY `end` (`end`),
  KEY `taskcategories_id` (`taskcategories_id`),
  KEY `tasktemplates_id` (`tasktemplates_id`),
  KEY `is_private` (`is_private`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_changetasks`
--


--
-- Table structure for table `glpi_changetemplatehiddenfields`
--

CREATE TABLE `glpi_changetemplatehiddenfields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `changetemplates_id` int(11) NOT NULL DEFAULT 0,
  `num` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`changetemplates_id`,`num`),
  KEY `changetemplates_id` (`changetemplates_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_changetemplatehiddenfields`
--


--
-- Table structure for table `glpi_changetemplatemandatoryfields`
--

CREATE TABLE `glpi_changetemplatemandatoryfields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `changetemplates_id` int(11) NOT NULL DEFAULT 0,
  `num` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`changetemplates_id`,`num`),
  KEY `changetemplates_id` (`changetemplates_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_changetemplatemandatoryfields`
--

INSERT INTO `glpi_changetemplatemandatoryfields` VALUES (1,1,21);

--
-- Table structure for table `glpi_changetemplatepredefinedfields`
--

CREATE TABLE `glpi_changetemplatepredefinedfields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `changetemplates_id` int(11) NOT NULL DEFAULT 0,
  `num` int(11) NOT NULL DEFAULT 0,
  `value` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `changetemplates_id` (`changetemplates_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_changetemplatepredefinedfields`
--


--
-- Table structure for table `glpi_changetemplates`
--

CREATE TABLE `glpi_changetemplates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_changetemplates`
--

INSERT INTO `glpi_changetemplates` VALUES (1,'Default',0,1,NULL);

--
-- Table structure for table `glpi_changevalidations`
--

CREATE TABLE `glpi_changevalidations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `users_id` int(11) NOT NULL DEFAULT 0,
  `changes_id` int(11) NOT NULL DEFAULT 0,
  `users_id_validate` int(11) NOT NULL DEFAULT 0,
  `comment_submission` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment_validation` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 2,
  `submission_date` timestamp NULL DEFAULT NULL,
  `validation_date` timestamp NULL DEFAULT NULL,
  `timeline_position` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `users_id` (`users_id`),
  KEY `users_id_validate` (`users_id_validate`),
  KEY `changes_id` (`changes_id`),
  KEY `submission_date` (`submission_date`),
  KEY `validation_date` (`validation_date`),
  KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_changevalidations`
--


--
-- Table structure for table `glpi_clusters`
--

CREATE TABLE `glpi_clusters` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `uuid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `version` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `users_id_tech` int(11) NOT NULL DEFAULT 0,
  `groups_id_tech` int(11) NOT NULL DEFAULT 0,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `states_id` int(11) NOT NULL DEFAULT 0 COMMENT 'RELATION to states (id)',
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `clustertypes_id` int(11) NOT NULL DEFAULT 0,
  `autoupdatesystems_id` int(11) NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `users_id_tech` (`users_id_tech`),
  KEY `group_id_tech` (`groups_id_tech`),
  KEY `is_deleted` (`is_deleted`),
  KEY `states_id` (`states_id`),
  KEY `clustertypes_id` (`clustertypes_id`),
  KEY `autoupdatesystems_id` (`autoupdatesystems_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_clusters`
--


--
-- Table structure for table `glpi_clustertypes`
--

CREATE TABLE `glpi_clustertypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_creation` (`date_creation`),
  KEY `date_mod` (`date_mod`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_clustertypes`
--


--
-- Table structure for table `glpi_computerantiviruses`
--

CREATE TABLE `glpi_computerantiviruses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `computers_id` int(11) NOT NULL DEFAULT 0,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `manufacturers_id` int(11) NOT NULL DEFAULT 0,
  `antivirus_version` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `signature_version` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 0,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `is_uptodate` tinyint(1) NOT NULL DEFAULT 0,
  `is_dynamic` tinyint(1) NOT NULL DEFAULT 0,
  `date_expiration` timestamp NULL DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `antivirus_version` (`antivirus_version`),
  KEY `signature_version` (`signature_version`),
  KEY `is_active` (`is_active`),
  KEY `is_uptodate` (`is_uptodate`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `is_deleted` (`is_deleted`),
  KEY `computers_id` (`computers_id`),
  KEY `date_expiration` (`date_expiration`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_computerantiviruses`
--


--
-- Table structure for table `glpi_computermodels`
--

CREATE TABLE `glpi_computermodels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_number` varchar(255) COLLATE utf8_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(1) NOT NULL DEFAULT 0,
  `picture_front` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `picture_rear` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_computermodels`
--

INSERT INTO `glpi_computermodels` VALUES (1,'81D6','',NULL,0,1,1,0,0,0,NULL,NULL,'2021-10-19 20:59:24','2021-10-19 20:59:24'),(2,'HP Laptop 15-db1xxx','',NULL,0,1,1,0,0,0,NULL,NULL,'2021-10-20 15:19:29','2021-10-20 15:19:29'),(3,'AGS-W09','',NULL,0,1,1,0,0,0,NULL,NULL,'2021-10-20 15:25:19','2021-10-20 15:25:19'),(4,'SM-N950F','',NULL,0,1,1,0,0,0,NULL,NULL,'2021-10-20 15:27:49','2021-10-20 15:27:49'),(5,'Latitude E5530 non-vPro','',NULL,0,1,1,0,0,0,NULL,NULL,'2021-10-21 09:31:32','2021-10-21 09:31:32'),(6,'HP Laptop 15-bw0xx','',NULL,0,1,1,0,0,0,NULL,NULL,'2021-11-01 18:30:04','2021-11-01 18:30:04'),(7,'HP 255 G6 Notebook PC','',NULL,0,1,1,0,0,0,NULL,NULL,'2021-12-13 19:00:21','2021-12-13 19:00:21'),(8,'HP Laptop 15-dw2xxx','',NULL,0,1,1,0,0,0,NULL,NULL,'2021-12-13 20:33:14','2021-12-13 20:33:14');

--
-- Table structure for table `glpi_computers`
--

CREATE TABLE `glpi_computers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `serial` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `otherserial` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contact` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contact_num` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `users_id_tech` int(11) NOT NULL DEFAULT 0,
  `groups_id_tech` int(11) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `autoupdatesystems_id` int(11) NOT NULL DEFAULT 0,
  `locations_id` int(11) NOT NULL DEFAULT 0,
  `networks_id` int(11) NOT NULL DEFAULT 0,
  `computermodels_id` int(11) NOT NULL DEFAULT 0,
  `computertypes_id` int(11) NOT NULL DEFAULT 0,
  `is_template` tinyint(1) NOT NULL DEFAULT 0,
  `template_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `manufacturers_id` int(11) NOT NULL DEFAULT 0,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `is_dynamic` tinyint(1) NOT NULL DEFAULT 0,
  `users_id` int(11) NOT NULL DEFAULT 0,
  `groups_id` int(11) NOT NULL DEFAULT 0,
  `states_id` int(11) NOT NULL DEFAULT 0,
  `ticket_tco` decimal(20,4) DEFAULT 0.0000,
  `uuid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `date_mod` (`date_mod`),
  KEY `name` (`name`),
  KEY `is_template` (`is_template`),
  KEY `autoupdatesystems_id` (`autoupdatesystems_id`),
  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 `computermodels_id` (`computermodels_id`),
  KEY `networks_id` (`networks_id`),
  KEY `states_id` (`states_id`),
  KEY `users_id_tech` (`users_id_tech`),
  KEY `computertypes_id` (`computertypes_id`),
  KEY `is_deleted` (`is_deleted`),
  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 `is_recursive` (`is_recursive`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_computers`
--

INSERT INTO `glpi_computers` VALUES (5,0,'Fragakis','JPVTXY1',NULL,'a.fragkakis',NULL,0,0,'Swap: 12673','2021-10-27 18:25:42',0,0,0,5,3,0,NULL,11,0,1,14,0,0,0.0000,'4C4C4544-0050-5610-8054-CAC04F585931','2021-10-21 09:31:32',0),(6,0,'DESKTOP-UELJJMN','CND9451WV5',NULL,'n.asiminakis',NULL,0,0,'Swap: 12362','2021-11-29 16:59:09',0,0,0,2,1,0,NULL,7,0,1,6,0,0,0.0000,'7DFB0501-F4F9-E911-8102-0068EB77642A','2021-10-21 09:34:56',0),(7,0,'SM-N950F-bbd6be98d908be1b','988a5c31354844305030',NULL,'dpi',NULL,0,0,'Swap: 2047','2021-10-21 09:38:51',0,0,0,4,2,0,NULL,10,0,1,0,0,0,0.0000,NULL,'2021-10-21 09:34:56',0),(8,0,'LAPTOP-028','PF1HP8P1','11','AegeoSpas',NULL,0,0,'Swap: 4527','2021-10-29 16:46:26',0,5,0,1,1,0,NULL,1,0,1,9,0,0,0.0000,'23068E89-DCE2-11E8-BB88-E86A644C08F2','2021-10-21 15:39:59',0),(9,0,'LAPTOP-077','PF1HN3PR','13','AegeoSpas',NULL,0,0,'Swap: 4527','2021-10-29 16:46:26',0,6,0,1,1,0,NULL,1,0,1,8,0,0,0.0000,'23068F4E-DCE2-11E8-BB88-E86A644C09B7','2021-10-21 17:31:58',0),(10,0,'AGS-W09-a84821f738b63035','4LCNU20C22100436','12','test',NULL,0,0,'Swap: 1023','2021-10-29 16:46:27',0,8,0,3,2,0,NULL,9,0,1,0,0,0,0.0000,NULL,'2021-10-21 17:31:59',0),(11,0,'LAPTOP-099','PF1HPAU7','18','AegeoSpas',NULL,0,0,'Swap: 4527','2021-10-29 16:46:27',0,7,0,1,1,0,NULL,1,0,1,7,0,0,0.0000,'3031BBEB-E7B7-11E8-BB88-E86A6459B757','2021-10-26 16:48:44',0),(12,0,'LAPTOP-080','PF1HP6JL','20','AegeoSpas',NULL,0,0,'Swap: 4527','2021-10-29 16:46:25',0,4,0,1,1,0,NULL,1,0,1,10,0,0,0.0000,'23068E6A-DCE2-11E8-BB88-E86A644C08D3','2021-10-26 18:46:31',0),(13,0,'LAPTOP-073','PF1HP2BS','21','AegeoSpas',NULL,0,0,'Swap: 4527','2021-10-29 16:46:24',0,3,0,1,1,0,NULL,1,0,1,11,0,0,0.0000,'23068E8E-DCE2-11E8-BB88-E86A644C08F7','2021-10-26 20:37:47',0),(14,0,'LAPTOP-123','PF1HQGQL','22','AegeoSpas',NULL,0,0,'Swap: 4527','2021-10-29 16:46:24',0,2,0,1,1,0,NULL,1,0,1,12,0,0,0.0000,'3031BAEB-E7B7-11E8-BB88-E86A6459B657','2021-10-26 21:47:28',0),(15,0,'LAPTOP-052','PF1HN7KZ','23','AegeoSpas',NULL,0,0,'Swap: 4527','2021-10-29 16:46:23',0,1,0,1,1,0,NULL,1,0,1,13,0,0,0.0000,'23068E15-DCE2-11E8-BB88-E86A644C087E','2021-10-27 17:57:34',0),(16,0,'LAPTOP-168','PF1HQLZ7',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-10-29 17:44:26',0,0,0,1,1,0,NULL,1,0,1,15,0,0,0.0000,'C47B88CD-E3C3-11E8-BB88-E86A6454F977','2021-10-29 17:42:16',0),(17,0,'LAPTOP-149','PF1HP6M2','26','AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-01 18:32:33',0,9,0,1,1,0,NULL,1,0,1,16,0,0,0.0000,'23068C2E-DCE2-11E8-BB88-E86A644C0697','2021-10-30 13:37:39',0),(18,0,'LAPTOP-213','CND74747CH',NULL,'AegeoSpas',NULL,0,0,'Swap: 9502','2021-11-08 20:07:35',0,0,0,6,1,0,NULL,7,1,1,17,0,0,0.0000,'3DE3FD44-73CA-E711-BBB6-ACE2D3D380D0','2021-11-01 18:30:04',0),(19,0,'LAPTOP-115','PF1HMW82',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-02 15:56:13',0,0,0,1,1,0,NULL,1,0,1,18,0,0,0.0000,'23068EB4-DCE2-11E8-BB88-E86A644C091D','2021-11-02 15:53:59',0),(20,0,'LAPTOP-100','PF1HPR1Q',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-02 17:12:11',0,0,0,1,1,0,NULL,1,0,1,19,0,0,0.0000,'23068A5C-DCE2-11E8-BB88-E86A644C04C5','2021-11-02 17:11:10',0),(21,0,'LAPTOP-101','PF1HPP9Y',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-03 15:41:00',0,0,0,1,1,0,NULL,1,0,1,20,0,0,0.0000,'23068FC9-DCE2-11E8-BB88-E86A644C0A32','2021-11-03 15:40:42',0),(22,0,'LAPTOP-112','PF1HQJUK',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-03 17:19:31',0,0,0,1,1,0,NULL,1,1,1,21,0,0,0.0000,'C47B78C9-E3C3-11E8-BB88-E86A6454E973','2021-11-03 16:28:01',0),(23,0,'LAPTOP-111','PF1HN3N9',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-03 17:20:15',0,0,0,1,1,0,NULL,1,0,1,22,0,0,0.0000,'23068D45-DCE2-11E8-BB88-E86A644C07AE','2021-11-03 17:19:43',0),(24,0,'LAPTOP-159','PF1HP8QR',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-05 17:27:49',0,0,0,1,1,0,NULL,1,0,1,23,0,0,0.0000,'3031BBD7-E7B7-11E8-BB88-E86A6459B743','2021-11-05 17:27:01',0),(25,0,'LAPTOP-093','PF1HQEK7',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-05 18:49:00',0,0,0,1,1,0,NULL,1,0,1,24,0,0,0.0000,'23068D39-DCE2-11E8-BB88-E86A644C07A2','2021-11-05 18:38:52',0),(26,0,'LAPTOP-030','PF1HPR22',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-08 20:07:35',0,0,0,1,1,0,NULL,1,1,1,25,0,0,0.0000,'23068EAA-DCE2-11E8-BB88-E86A644C0913','2021-11-08 17:18:04',0),(27,0,'LAPTOP-079','PF1HPAV1',NULL,'AegeoSpas',NULL,0,0,'Swap: 4595','2021-11-08 19:13:43',0,0,0,1,1,0,NULL,1,0,1,26,0,0,0.0000,'230689EB-DCE2-11E8-BB88-E86A644C0454','2021-11-08 19:13:23',0),(28,0,'LAPTOP-113','PF1HN72G',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-08 20:08:15',0,0,0,1,1,0,NULL,1,0,1,27,0,0,0.0000,'23068F4D-DCE2-11E8-BB88-E86A644C09B6','2021-11-08 20:07:45',0),(29,0,'LAPTOP-004','PF1HQEHQ',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-09 16:44:53',0,0,0,1,1,0,NULL,1,1,1,28,0,0,0.0000,'3031C0A4-E7B7-11E8-BB88-E86A6459BC10','2021-11-08 20:56:05',0),(30,0,'LAPTOP-131','PF1HPSX1',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-09 17:01:48',0,0,0,1,1,0,NULL,1,0,1,31,0,0,0.0000,'3031B5BC-E7B7-11E8-BB88-E86A6459B128','2021-11-09 16:44:41',0),(31,0,'LAPTOP-040','PF1HP2BZ',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-09 18:02:52',0,0,0,1,1,0,NULL,1,0,1,30,0,0,0.0000,'3031B13E-E7B7-11E8-BB88-E86A6459ACAA','2021-11-09 17:58:24',0),(32,0,'LAPTOP-089','PF1HQAEC',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-09 18:49:21',0,0,0,1,1,0,NULL,1,0,1,32,0,0,0.0000,'C47B77A3-E3C3-11E8-BB88-E86A6454E84D','2021-11-09 18:48:49',0),(33,0,'LAPTOP-027','PF1HPSXE',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-09 21:58:46',0,0,0,1,1,0,NULL,1,0,1,33,0,0,0.0000,'3031C51D-E7B7-11E8-BB88-E86A6459C089','2021-11-09 21:58:12',0),(34,0,'LAPTOP-041','PF1HQLXW',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-18 17:03:10',0,0,0,1,1,0,NULL,1,0,1,34,0,0,0.0000,'C47B88AC-E3C3-11E8-BB88-E86A6454F956','2021-11-18 17:01:06',0),(35,0,'LAPTOP-082','PF1HN3NL',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-18 18:19:41',0,0,0,1,1,0,NULL,1,0,1,35,0,0,0.0000,'23068F02-DCE2-11E8-BB88-E86A644C096B','2021-11-18 18:19:00',0),(36,0,'LAPTOP-138','PF1HQCDK',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-19 16:20:55',0,0,0,1,1,0,NULL,1,0,1,36,0,0,0.0000,'C47B83D0-E3C3-11E8-BB88-E86A6454F47A','2021-11-19 16:20:09',0),(37,0,'LAPTOP-095','PF1HNY0A',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-22 18:13:22',0,0,0,1,1,0,NULL,1,0,1,37,0,0,0.0000,'23068E91-DCE2-11E8-BB88-E86A644C08FA','2021-11-22 18:12:36',0),(38,0,'LAPTOP-137','PF1HNRYA',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-23 16:08:01',0,0,0,1,1,0,NULL,1,0,1,24,0,0,0.0000,'23068F12-DCE2-11E8-BB88-E86A644C097B','2021-11-23 16:07:42',0),(39,0,'LAPTOP-294','PF1HP6KK',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-27 12:55:37',0,0,0,1,1,0,NULL,1,0,1,39,0,0,0.0000,'23068E81-DCE2-11E8-BB88-E86A644C08EA','2021-11-27 12:54:59',0),(40,0,'LAPTOP-110','PF1HPATL',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-27 13:53:20',0,0,0,1,1,0,NULL,1,0,1,40,0,0,0.0000,'3031B33C-E7B7-11E8-BB88-E86A6459AEA8','2021-11-27 13:52:40',0),(41,0,'LAPTOP-096','PF1HN082',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-27 14:37:30',0,0,0,1,1,0,NULL,1,0,1,41,0,0,0.0000,'23068E86-DCE2-11E8-BB88-E86A644C08EF','2021-11-27 14:36:38',0),(42,0,'LAPTOP-092','PF1HNVYF',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-27 15:16:32',0,0,0,1,1,0,NULL,1,0,1,42,0,0,0.0000,'23068D20-DCE2-11E8-BB88-E86A644C0789','2021-11-27 15:16:01',0),(43,0,'LAPTOP-022','PF1HQJTJ',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-27 16:02:58',0,0,0,1,1,0,NULL,1,0,1,16,0,0,0.0000,'C47B7B87-E3C3-11E8-BB88-E86A6454EC31','2021-11-27 16:02:14',0),(44,0,'LAPTOP-153','PF1HP2AJ',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-27 16:53:58',0,0,0,1,1,0,NULL,1,0,1,43,0,0,0.0000,'23068EF4-DCE2-11E8-BB88-E86A644C095D','2021-11-27 16:53:31',0),(45,0,'LAPTOP-009','PF1HQ6VJ',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527\r\n\r\nNATURA PARK VILLAGE','2021-12-14 15:40:08',0,0,0,1,1,0,NULL,1,0,1,45,0,0,0.0000,'3031B8F6-E7B7-11E8-BB88-E86A6459B462','2021-11-29 15:41:56',0),(46,0,'LAPTOP-109','PF1HP8RH',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527\r\n0168 BLUE SEA ZEUS','2021-11-29 16:48:50',0,0,0,1,1,0,NULL,1,0,1,0,0,0,0.0000,'3031B153-E7B7-11E8-BB88-E86A6459ACBF','2021-11-29 16:46:32',0),(47,0,'LAPTOP-098','PF1HP4F1',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-29 17:27:43',0,0,0,1,1,0,NULL,1,0,1,0,0,0,0.0000,'3031B33D-E7B7-11E8-BB88-E86A6459AEA9','2021-11-29 17:27:43',0),(48,0,'LAPTOP-097','PF1HP6KY',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-29 18:07:32',0,0,0,1,1,0,NULL,1,0,1,48,0,0,0.0000,'23068A5E-DCE2-11E8-BB88-E86A644C04C7','2021-11-29 18:07:06',0),(49,0,'LAPTOP-055','PF1HPAUJ',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-29 18:44:43',0,0,0,1,1,0,NULL,1,0,1,49,0,0,0.0000,'3031BBED-E7B7-11E8-BB88-E86A6459B759','2021-11-29 18:44:16',0),(50,0,'LAPTOP-049','PF1HQJR6','85','m.varouxaki',NULL,0,0,'Swap: 6127','2021-12-06 16:47:17',0,10,0,1,1,0,NULL,1,0,1,50,0,0,0.0000,'C47B7B88-E3C3-11E8-BB88-E86A6454EC32','2021-11-29 19:28:39',0),(51,0,'LAPTOP-058','PF1HP4DQ',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-30 16:18:57',0,0,0,1,1,0,NULL,1,0,1,51,0,0,0.0000,'3031B8FF-E7B7-11E8-BB88-E86A6459B46B','2021-11-30 16:17:49',0),(52,0,'LAPTOP-178','PF1HN3MV',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-30 17:05:49',0,0,0,1,1,0,NULL,1,0,1,0,0,0,0.0000,'23068D42-DCE2-11E8-BB88-E86A644C07AB','2021-11-30 17:05:49',0),(53,0,'LAPTOP-035','PF1HN3KK',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-30 18:04:46',0,0,0,1,1,0,NULL,1,0,1,52,0,0,0.0000,'23068C96-DCE2-11E8-BB88-E86A644C06FF','2021-11-30 18:04:27',0),(54,0,'LAPTOP-063','PF1HNVY6',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-30 18:56:18',0,0,0,1,1,0,NULL,1,0,1,0,0,0,0.0000,'23068EF6-DCE2-11E8-BB88-E86A644C095F','2021-11-30 18:56:18',0),(55,0,'LAPTOP-102','PF1HQP2P',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-30 19:49:23',0,0,0,1,1,0,NULL,1,0,1,54,0,0,0.0000,'C47B7EEF-E3C3-11E8-BB88-E86A6454EF99','2021-11-30 19:48:59',0),(56,0,'LAPTOP-160','PF1HP6LA',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-11-30 20:57:20',0,0,0,1,1,0,NULL,1,0,1,0,0,0,0.0000,'23068B82-DCE2-11E8-BB88-E86A644C05EB','2021-11-30 20:57:20',0),(57,0,'LAPTOP-050','PF1HP064',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-12-01 15:58:34',0,0,0,1,1,0,NULL,1,0,1,56,0,0,0.0000,'23068A36-DCE2-11E8-BB88-E86A644C049F','2021-12-01 15:57:57',0),(58,0,'LAPTOP-094','PF1HP4ED',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-12-01 18:02:51',0,0,0,1,1,0,NULL,1,0,1,0,0,0,0.0000,'3031BBD1-E7B7-11E8-BB88-E86A6459B73D','2021-12-01 18:02:51',0),(59,0,'LAPTOP-006','PF1HN09U',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-12-01 21:06:29',0,0,0,1,1,0,NULL,1,0,1,59,0,0,0.0000,'23068ED9-DCE2-11E8-BB88-E86A644C0942','2021-12-01 21:05:25',0),(60,0,'LAPTOP-103','PF1HQGQB',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-12-01 21:12:50',0,0,0,1,1,0,NULL,1,0,1,58,0,0,0.0000,'3031C28B-E7B7-11E8-BB88-E86A6459BDF7','2021-12-01 21:05:27',0),(61,0,'LAPTOP-187','PF1HQJRV',NULL,'AegeoSpas',NULL,0,0,'Swap: 3823','2021-12-04 16:03:10',0,0,0,1,1,0,NULL,1,0,1,0,0,0,0.0000,'C47B7E40-E3C3-11E8-BB88-E86A6454EEEA','2021-12-04 16:03:10',0),(62,0,'LAPTOP-086','PF1HPSXR',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-12-04 16:27:42',0,0,0,1,1,0,NULL,1,0,1,61,0,0,0.0000,'3031C6EA-E7B7-11E8-BB88-E86A6459C256','2021-12-04 16:27:11',0),(63,0,'LAPTOP-179','PF1HP2AS',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-12-04 17:19:56',0,0,0,1,1,0,NULL,1,0,1,0,0,0,0.0000,'23068D5D-DCE2-11E8-BB88-E86A644C07C6','2021-12-04 17:19:56',0),(64,0,'LAPTOP-test','','','','',0,0,'','2021-12-06 16:43:09',0,0,0,0,3,0,NULL,0,0,0,0,0,0,0.0000,'','2021-12-06 16:43:09',0),(65,0,'LAPTOP-010','CND73463ZV',NULL,'AegeoSPAS',NULL,0,0,'Swap: 9502','2021-12-09 18:26:47',0,0,0,6,1,0,NULL,7,0,1,0,0,0,0.0000,'39285A0A-6688-E711-BE82-48BA4E26E71F','2021-12-09 18:26:47',0),(66,0,'LAPTOP-020','CND7447G89',NULL,'AegeoSPAS',NULL,0,0,'Swap: 9502','2021-12-13 18:15:19',0,0,0,6,1,0,NULL,7,0,1,0,0,0,0.0000,'D9743D37-6FBF-E711-BBB6-ACE2D37C6C47','2021-12-13 18:15:19',0),(67,0,'LAPTOP-003','CND74747CG',NULL,'AegeoSPAS',NULL,0,0,'Swap: 8862','2021-12-13 18:21:12',0,0,0,6,1,0,NULL,7,0,1,0,0,0,0.0000,'F1E3FD44-73CA-E711-BBB6-ACE2D3D38184','2021-12-13 18:21:12',0),(68,0,'LAPTOP-002','CND84650CD',NULL,'AegeoSPAS',NULL,0,0,'Swap: 6798','2021-12-13 19:00:21',0,0,0,7,1,0,NULL,7,0,1,0,0,0,0.0000,'BC3E9840-FEE2-E811-A4C3-E4E74909980B','2021-12-13 19:00:21',0),(69,0,'LAPTOP-170','PF1HMT79',NULL,'AegeoSpas',NULL,0,0,'Swap: 4527','2021-12-13 19:40:13',0,0,0,1,1,0,NULL,1,0,1,0,0,0,0.0000,'23068EAE-DCE2-11E8-BB88-E86A644C0917','2021-12-13 19:40:13',0),(70,0,'LAPTOP-136','CND8464ZXZ',NULL,'AegeoSPAS',NULL,0,0,'Swap: 4686','2021-12-13 20:11:50',0,0,0,7,1,0,NULL,7,0,1,0,0,0,0.0000,'BE409840-FEE2-E811-A4C3-E4E749099A0D','2021-12-13 20:11:50',0),(71,0,'LAPTOP-224','CND0507SGH',NULL,'l.lakka',NULL,0,0,'Swap: 12070','2021-12-13 20:33:14',0,0,0,8,1,0,NULL,7,0,1,69,0,0,0.0000,'14CF7E8B-063E-EB11-8108-6C02E015CF5A','2021-12-13 20:33:14',0),(72,0,'LAPTOP-239','CND0507R1C',NULL,'f.krokidi',NULL,0,0,'Swap: 9254','2021-12-13 21:19:25',0,0,0,8,1,0,NULL,7,0,1,70,0,0,0.0000,'45D47E8B-063E-EB11-8108-6C02E015DC2F','2021-12-13 21:19:25',0);

--
-- Table structure for table `glpi_computers_items`
--

CREATE TABLE `glpi_computers_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `items_id` int(11) NOT NULL DEFAULT 0 COMMENT 'RELATION to various table, according to itemtype (ID)',
  `computers_id` int(11) NOT NULL DEFAULT 0,
  `itemtype` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `is_dynamic` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `computers_id` (`computers_id`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`)
) ENGINE=InnoDB AUTO_INCREMENT=343 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_computers_items`
--

INSERT INTO `glpi_computers_items` VALUES (1,1,15,'Monitor',0,1),(2,1,15,'Printer',0,1),(3,2,15,'Printer',0,1),(4,3,15,'Printer',0,1),(5,4,15,'Printer',0,1),(6,2,14,'Monitor',0,1),(7,5,14,'Printer',0,1),(8,6,14,'Printer',0,1),(9,7,14,'Printer',0,1),(10,8,14,'Printer',0,1),(11,3,13,'Monitor',0,1),(12,9,13,'Printer',0,1),(13,10,13,'Printer',0,1),(14,11,13,'Printer',0,1),(15,12,13,'Printer',0,1),(16,4,12,'Monitor',0,1),(17,13,12,'Printer',0,1),(18,14,12,'Printer',0,1),(19,15,12,'Printer',0,1),(20,16,12,'Printer',0,1),(21,5,8,'Monitor',0,1),(22,17,8,'Printer',0,1),(23,18,8,'Printer',0,1),(24,19,8,'Printer',0,1),(25,20,8,'Printer',0,1),(26,6,9,'Monitor',0,1),(27,21,9,'Printer',0,1),(28,22,9,'Printer',0,1),(29,23,9,'Printer',0,1),(30,24,9,'Printer',0,1),(31,7,11,'Monitor',0,1),(32,25,11,'Printer',0,1),(33,26,11,'Printer',0,1),(34,27,11,'Printer',0,1),(35,28,11,'Printer',0,1),(36,8,16,'Monitor',0,1),(37,29,16,'Printer',0,1),(38,30,16,'Printer',0,1),(39,31,16,'Printer',0,1),(40,32,16,'Printer',0,1),(41,9,17,'Monitor',0,1),(42,33,17,'Printer',0,1),(43,34,17,'Printer',0,1),(44,35,17,'Printer',0,1),(45,36,17,'Printer',0,1),(46,10,18,'Monitor',0,1),(47,37,18,'Printer',0,1),(48,38,18,'Printer',0,1),(49,39,18,'Printer',0,1),(50,11,6,'Monitor',0,1),(51,12,6,'Monitor',0,1),(52,40,6,'Printer',0,1),(53,41,6,'Printer',0,1),(54,42,6,'Printer',0,1),(55,43,6,'Printer',0,1),(56,44,6,'Printer',0,1),(57,45,6,'Printer',0,1),(58,46,6,'Printer',0,1),(59,47,6,'Printer',0,1),(60,48,6,'Printer',0,1),(61,49,6,'Printer',0,1),(62,50,6,'Printer',0,1),(63,13,19,'Monitor',0,1),(64,51,19,'Printer',0,1),(65,52,19,'Printer',0,1),(66,53,19,'Printer',0,1),(67,54,19,'Printer',0,1),(68,14,20,'Monitor',0,1),(69,55,20,'Printer',0,1),(70,56,20,'Printer',0,1),(71,57,20,'Printer',0,1),(72,58,20,'Printer',0,1),(73,15,21,'Monitor',0,1),(74,59,21,'Printer',0,1),(75,60,21,'Printer',0,1),(76,61,21,'Printer',0,1),(77,62,21,'Printer',0,1),(78,16,22,'Monitor',0,1),(79,63,22,'Printer',0,1),(80,64,22,'Printer',0,1),(81,65,22,'Printer',0,1),(82,66,22,'Printer',0,1),(83,17,23,'Monitor',0,1),(84,67,23,'Printer',0,1),(85,68,23,'Printer',0,1),(86,69,23,'Printer',0,1),(87,70,23,'Printer',0,1),(88,18,24,'Monitor',0,1),(89,71,24,'Printer',0,1),(90,72,24,'Printer',0,1),(91,73,24,'Printer',0,1),(92,74,24,'Printer',0,1),(93,19,25,'Monitor',0,1),(94,75,25,'Printer',0,1),(95,76,25,'Printer',0,1),(96,77,25,'Printer',0,1),(97,78,25,'Printer',0,1),(98,20,26,'Monitor',0,1),(99,79,26,'Printer',0,1),(100,80,26,'Printer',0,1),(101,81,26,'Printer',0,1),(102,82,26,'Printer',0,1),(103,21,27,'Monitor',0,1),(104,83,27,'Printer',0,1),(105,84,27,'Printer',0,1),(106,85,27,'Printer',0,1),(107,86,27,'Printer',0,1),(108,22,28,'Monitor',0,1),(109,87,28,'Printer',0,1),(110,88,28,'Printer',0,1),(111,89,28,'Printer',0,1),(112,90,28,'Printer',0,1),(113,23,29,'Monitor',0,1),(114,91,29,'Printer',0,1),(115,92,29,'Printer',0,1),(116,93,29,'Printer',0,1),(117,94,29,'Printer',0,1),(118,24,30,'Monitor',0,1),(119,95,30,'Printer',0,1),(120,96,30,'Printer',0,1),(121,97,30,'Printer',0,1),(122,98,30,'Printer',0,1),(123,25,31,'Monitor',0,1),(124,99,31,'Printer',0,1),(125,100,31,'Printer',0,1),(126,101,31,'Printer',0,1),(127,102,31,'Printer',0,1),(128,26,32,'Monitor',0,1),(129,103,32,'Printer',0,1),(130,104,32,'Printer',0,1),(131,105,32,'Printer',0,1),(132,106,32,'Printer',0,1),(133,27,33,'Monitor',0,1),(134,107,33,'Printer',0,1),(135,108,33,'Printer',0,1),(136,109,33,'Printer',0,1),(137,110,33,'Printer',0,1),(138,28,34,'Monitor',0,1),(139,111,34,'Printer',0,1),(140,112,34,'Printer',0,1),(141,113,34,'Printer',0,1),(142,114,34,'Printer',0,1),(143,115,6,'Printer',0,1),(144,29,35,'Monitor',0,1),(145,116,35,'Printer',0,1),(146,117,35,'Printer',0,1),(147,118,35,'Printer',0,1),(148,119,35,'Printer',0,1),(149,30,36,'Monitor',0,1),(150,120,36,'Printer',0,1),(151,121,36,'Printer',0,1),(152,122,36,'Printer',0,1),(153,123,36,'Printer',0,1),(154,31,37,'Monitor',0,1),(155,124,37,'Printer',0,1),(156,125,37,'Printer',0,1),(157,126,37,'Printer',0,1),(158,127,37,'Printer',0,1),(159,32,38,'Monitor',0,1),(160,128,38,'Printer',0,1),(161,129,38,'Printer',0,1),(162,130,38,'Printer',0,1),(163,131,38,'Printer',0,1),(164,33,39,'Monitor',0,1),(165,132,39,'Printer',0,1),(166,133,39,'Printer',0,1),(167,134,39,'Printer',0,1),(168,135,39,'Printer',0,1),(169,34,40,'Monitor',0,1),(170,136,40,'Printer',0,1),(171,137,40,'Printer',0,1),(172,138,40,'Printer',0,1),(173,139,40,'Printer',0,1),(174,35,41,'Monitor',0,1),(175,140,41,'Printer',0,1),(176,141,41,'Printer',0,1),(177,142,41,'Printer',0,1),(178,143,41,'Printer',0,1),(179,36,42,'Monitor',0,1),(180,144,42,'Printer',0,1),(181,145,42,'Printer',0,1),(182,146,42,'Printer',0,1),(183,147,42,'Printer',0,1),(184,37,43,'Monitor',0,1),(185,148,43,'Printer',0,1),(186,149,43,'Printer',0,1),(187,150,43,'Printer',0,1),(188,151,43,'Printer',0,1),(189,38,44,'Monitor',0,1),(190,152,44,'Printer',0,1),(191,153,44,'Printer',0,1),(192,154,44,'Printer',0,1),(193,155,44,'Printer',0,1),(194,39,45,'Monitor',0,1),(195,156,45,'Printer',0,1),(196,157,45,'Printer',0,1),(197,158,45,'Printer',0,1),(198,159,45,'Printer',0,1),(199,40,46,'Monitor',0,1),(200,160,46,'Printer',0,1),(201,161,46,'Printer',0,1),(202,162,46,'Printer',0,1),(203,163,46,'Printer',0,1),(204,41,47,'Monitor',0,1),(205,164,47,'Printer',0,1),(206,165,47,'Printer',0,1),(207,166,47,'Printer',0,1),(208,167,47,'Printer',0,1),(209,42,48,'Monitor',0,1),(210,168,48,'Printer',0,1),(211,169,48,'Printer',0,1),(212,170,48,'Printer',0,1),(213,171,48,'Printer',0,1),(214,43,49,'Monitor',0,1),(215,172,49,'Printer',0,1),(216,173,49,'Printer',0,1),(217,174,49,'Printer',0,1),(218,175,49,'Printer',0,1),(219,44,50,'Monitor',0,1),(220,176,50,'Printer',0,1),(221,177,50,'Printer',0,1),(222,178,50,'Printer',0,1),(223,179,50,'Printer',0,1),(224,180,50,'Printer',0,1),(225,181,50,'Printer',0,1),(226,182,50,'Printer',0,1),(227,183,50,'Printer',0,1),(228,184,50,'Printer',0,1),(229,185,50,'Printer',0,1),(230,186,50,'Printer',0,1),(231,45,51,'Monitor',0,1),(232,187,51,'Printer',0,1),(233,188,51,'Printer',0,1),(234,189,51,'Printer',0,1),(235,190,51,'Printer',0,1),(236,46,52,'Monitor',0,1),(237,191,52,'Printer',0,1),(238,192,52,'Printer',0,1),(239,193,52,'Printer',0,1),(240,194,52,'Printer',0,1),(241,47,53,'Monitor',0,1),(242,195,53,'Printer',0,1),(243,196,53,'Printer',0,1),(244,197,53,'Printer',0,1),(245,198,53,'Printer',0,1),(246,48,54,'Monitor',0,1),(247,199,54,'Printer',0,1),(248,200,54,'Printer',0,1),(249,201,54,'Printer',0,1),(250,202,54,'Printer',0,1),(251,49,55,'Monitor',0,1),(252,203,55,'Printer',0,1),(253,204,55,'Printer',0,1),(254,205,55,'Printer',0,1),(255,206,55,'Printer',0,1),(256,50,56,'Monitor',0,1),(257,207,56,'Printer',0,1),(258,208,56,'Printer',0,1),(259,209,56,'Printer',0,1),(260,210,56,'Printer',0,1),(261,51,57,'Monitor',0,1),(262,211,57,'Printer',0,1),(263,212,57,'Printer',0,1),(264,213,57,'Printer',0,1),(265,214,57,'Printer',0,1),(266,52,58,'Monitor',0,1),(267,215,58,'Printer',0,1),(268,216,58,'Printer',0,1),(269,217,58,'Printer',0,1),(270,218,58,'Printer',0,1),(271,53,59,'Monitor',0,1),(272,219,59,'Printer',0,1),(273,220,59,'Printer',0,1),(274,221,59,'Printer',0,1),(275,222,59,'Printer',0,1),(276,54,60,'Monitor',0,1),(277,223,60,'Printer',0,1),(278,224,60,'Printer',0,1),(279,225,60,'Printer',0,1),(280,226,60,'Printer',0,1),(281,55,61,'Monitor',0,1),(282,227,61,'Printer',0,1),(283,228,61,'Printer',0,1),(284,229,61,'Printer',0,1),(285,230,61,'Printer',0,1),(286,56,62,'Monitor',0,1),(287,231,62,'Printer',0,1),(288,232,62,'Printer',0,1),(289,233,62,'Printer',0,1),(290,234,62,'Printer',0,1),(291,57,63,'Monitor',0,1),(292,235,63,'Printer',0,1),(293,236,63,'Printer',0,1),(294,237,63,'Printer',0,1),(295,238,63,'Printer',0,1),(296,58,65,'Monitor',0,1),(297,239,65,'Printer',0,1),(298,240,65,'Printer',0,1),(299,241,65,'Printer',0,1),(300,242,65,'Printer',0,1),(301,59,66,'Monitor',0,1),(302,243,66,'Printer',0,1),(303,244,66,'Printer',0,1),(304,245,66,'Printer',0,1),(305,246,66,'Printer',0,1),(306,60,67,'Monitor',0,1),(307,247,67,'Printer',0,1),(308,248,67,'Printer',0,1),(309,249,67,'Printer',0,1),(310,250,67,'Printer',0,1),(311,251,67,'Printer',0,1),(312,61,68,'Monitor',0,1),(313,252,68,'Printer',0,1),(314,253,68,'Printer',0,1),(315,254,68,'Printer',0,1),(316,255,68,'Printer',0,1),(317,256,68,'Printer',0,1),(318,62,69,'Monitor',0,1),(319,257,69,'Printer',0,1),(320,258,69,'Printer',0,1),(321,259,69,'Printer',0,1),(322,260,69,'Printer',0,1),(323,63,70,'Monitor',0,1),(324,261,70,'Printer',0,1),(325,262,70,'Printer',0,1),(326,263,70,'Printer',0,1),(327,264,70,'Printer',0,1),(328,265,70,'Printer',0,1),(329,64,71,'Monitor',0,1),(330,266,71,'Printer',0,1),(331,267,71,'Printer',0,1),(332,268,71,'Printer',0,1),(333,269,71,'Printer',0,1),(334,270,71,'Printer',0,1),(335,271,71,'Printer',0,1),(336,65,72,'Monitor',0,1),(337,272,72,'Printer',0,1),(338,273,72,'Printer',0,1),(339,274,72,'Printer',0,1),(340,275,72,'Printer',0,1),(341,276,72,'Printer',0,1),(342,277,72,'Printer',0,1);

--
-- Table structure for table `glpi_computertypes`
--

CREATE TABLE `glpi_computertypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_computertypes`
--

INSERT INTO `glpi_computertypes` VALUES (1,'Notebook','','2021-10-19 20:59:24','2021-10-19 20:59:24'),(2,'Mobile','','2021-10-20 15:25:19','2021-10-20 15:25:19'),(3,'LapTop','','2021-10-21 09:31:32','2021-10-21 09:31:32');

--
-- Table structure for table `glpi_computervirtualmachines`
--

CREATE TABLE `glpi_computervirtualmachines` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `computers_id` int(11) NOT NULL DEFAULT 0,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `virtualmachinestates_id` int(11) NOT NULL DEFAULT 0,
  `virtualmachinesystems_id` int(11) NOT NULL DEFAULT 0,
  `virtualmachinetypes_id` int(11) NOT NULL DEFAULT 0,
  `uuid` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `vcpu` int(11) NOT NULL DEFAULT 0,
  `ram` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `is_dynamic` tinyint(1) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `computers_id` (`computers_id`),
  KEY `entities_id` (`entities_id`),
  KEY `name` (`name`),
  KEY `virtualmachinestates_id` (`virtualmachinestates_id`),
  KEY `virtualmachinesystems_id` (`virtualmachinesystems_id`),
  KEY `vcpu` (`vcpu`),
  KEY `ram` (`ram`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `uuid` (`uuid`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_computervirtualmachines`
--


--
-- Table structure for table `glpi_configs`
--

CREATE TABLE `glpi_configs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `context` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`context`,`name`)
) ENGINE=InnoDB AUTO_INCREMENT=218 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_configs`
--

INSERT INTO `glpi_configs` VALUES (1,'core','version','9.5.1'),(2,'core','show_jobs_at_login','0'),(3,'core','cut','250'),(4,'core','list_limit','15'),(5,'core','list_limit_max','50'),(6,'core','url_maxlength','30'),(7,'core','event_loglevel','5'),(8,'core','notifications_mailing','0'),(9,'core','admin_email','admsys@localhost'),(10,'core','admin_email_name',''),(11,'core','admin_reply',''),(12,'core','admin_reply_name',''),(13,'core','mailing_signature','SIGNATURE'),(14,'core','use_anonymous_helpdesk','0'),(15,'core','use_anonymous_followups','0'),(16,'core','language','en_GB'),(17,'core','priority_1','#fff2f2'),(18,'core','priority_2','#ffe0e0'),(19,'core','priority_3','#ffcece'),(20,'core','priority_4','#ffbfbf'),(21,'core','priority_5','#ffadad'),(22,'core','priority_6','#ff5555'),(23,'core','date_tax','2005-12-31'),(24,'core','cas_host',''),(25,'core','cas_port','443'),(26,'core','cas_uri',''),(27,'core','cas_logout',''),(28,'core','existing_auth_server_field_clean_domain','0'),(29,'core','planning_begin','08:00:00'),(30,'core','planning_end','20:00:00'),(31,'core','utf8_conv','1'),(32,'core','use_public_faq','0'),(33,'core','url_base','http://157.90.12.13/glpi'),(34,'core','show_link_in_mail','0'),(35,'core','text_login',''),(36,'core','founded_new_version','9.5.6'),(37,'core','dropdown_max','100'),(38,'core','ajax_wildcard','*'),(39,'core','ajax_limit_count','10'),(40,'core','use_ajax_autocompletion','1'),(41,'core','is_users_auto_add','1'),(42,'core','date_format','1'),(43,'core','number_format','0'),(44,'core','csv_delimiter',';'),(45,'core','is_ids_visible','0'),(46,'core','smtp_mode','0'),(47,'core','smtp_host',''),(48,'core','smtp_port','25'),(49,'core','smtp_username',''),(50,'core','proxy_name',''),(51,'core','proxy_port','8080'),(52,'core','proxy_user',''),(53,'core','add_followup_on_update_ticket','1'),(54,'core','keep_tickets_on_delete','0'),(55,'core','time_step','5'),(56,'core','decimal_number','2'),(57,'core','helpdesk_doc_url',''),(58,'core','central_doc_url',''),(59,'core','documentcategories_id_forticket','0'),(60,'core','monitors_management_restrict','2'),(61,'core','phones_management_restrict','2'),(62,'core','peripherals_management_restrict','2'),(63,'core','printers_management_restrict','2'),(64,'core','use_log_in_files','1'),(65,'core','time_offset','10800'),(66,'core','is_contact_autoupdate','1'),(67,'core','is_user_autoupdate','1'),(68,'core','is_group_autoupdate','1'),(69,'core','is_location_autoupdate','1'),(70,'core','state_autoupdate_mode','0'),(71,'core','is_contact_autoclean','0'),(72,'core','is_user_autoclean','0'),(73,'core','is_group_autoclean','0'),(74,'core','is_location_autoclean','0'),(75,'core','state_autoclean_mode','0'),(76,'core','use_flat_dropdowntree','0'),(77,'core','use_autoname_by_entity','1'),(78,'core','softwarecategories_id_ondelete','1'),(79,'core','x509_email_field',''),(80,'core','x509_cn_restrict',''),(81,'core','x509_o_restrict',''),(82,'core','x509_ou_restrict',''),(83,'core','default_mailcollector_filesize_max','2097152'),(84,'core','followup_private','0'),(85,'core','task_private','0'),(86,'core','default_software_helpdesk_visible','1'),(87,'core','names_format','0'),(88,'core','default_requesttypes_id','1'),(89,'core','use_noright_users_add','1'),(90,'core','cron_limit','5'),(91,'core','priority_matrix','{\"1\":{\"1\":1,\"2\":1,\"3\":2,\"4\":2,\"5\":2},\"2\":{\"1\":1,\"2\":2,\"3\":2,\"4\":3,\"5\":3},\"3\":{\"1\":2,\"2\":2,\"3\":3,\"4\":4,\"5\":4},\"4\":{\"1\":2,\"2\":3,\"3\":4,\"4\":4,\"5\":5},\"5\":{\"1\":2,\"2\":3,\"3\":4,\"4\":5,\"5\":5}}'),(92,'core','urgency_mask','62'),(93,'core','impact_mask','62'),(94,'core','user_deleted_ldap','0'),(95,'core','auto_create_infocoms','0'),(96,'core','use_slave_for_search','0'),(97,'core','proxy_passwd',''),(98,'core','smtp_passwd',''),(99,'core','transfers_id_auto','0'),(100,'core','show_count_on_tabs','1'),(101,'core','refresh_views','0'),(102,'core','set_default_tech','1'),(103,'core','allow_search_view','2'),(104,'core','allow_search_all','0'),(105,'core','allow_search_global','1'),(106,'core','display_count_on_home','5'),(107,'core','use_password_security','0'),(108,'core','password_min_length','8'),(109,'core','password_need_number','1'),(110,'core','password_need_letter','1'),(111,'core','password_need_caps','1'),(112,'core','password_need_symbol','1'),(113,'core','use_check_pref','0'),(114,'core','notification_to_myself','1'),(115,'core','duedateok_color','#06ff00'),(116,'core','duedatewarning_color','#ffb800'),(117,'core','duedatecritical_color','#ff0000'),(118,'core','duedatewarning_less','20'),(119,'core','duedatecritical_less','5'),(120,'core','duedatewarning_unit','%'),(121,'core','duedatecritical_unit','%'),(122,'core','realname_ssofield',''),(123,'core','firstname_ssofield',''),(124,'core','email1_ssofield',''),(125,'core','email2_ssofield',''),(126,'core','email3_ssofield',''),(127,'core','email4_ssofield',''),(128,'core','phone_ssofield',''),(129,'core','phone2_ssofield',''),(130,'core','mobile_ssofield',''),(131,'core','comment_ssofield',''),(132,'core','title_ssofield',''),(133,'core','category_ssofield',''),(134,'core','language_ssofield',''),(135,'core','entity_ssofield',''),(136,'core','registration_number_ssofield',''),(137,'core','ssovariables_id','0'),(138,'core','ssologout_url',''),(139,'core','translate_kb','0'),(140,'core','translate_dropdowns','0'),(141,'core','translate_reminders','0'),(142,'core','pdffont','helvetica'),(143,'core','keep_devices_when_purging_item','0'),(144,'core','maintenance_mode','0'),(145,'core','maintenance_text',''),(146,'core','attach_ticket_documents_to_mail','0'),(147,'core','backcreated','0'),(148,'core','task_state','1'),(149,'core','layout','lefttab'),(150,'core','palette','auror'),(151,'core','lock_use_lock_item','0'),(152,'core','lock_autolock_mode','1'),(153,'core','lock_directunlock_notification','0'),(154,'core','lock_item_list','[]'),(155,'core','lock_lockprofile_id','8'),(156,'core','set_default_requester','1'),(157,'core','highcontrast_css','0'),(158,'core','smtp_check_certificate','1'),(159,'core','enable_api','0'),(160,'core','enable_api_login_credentials','0'),(161,'core','enable_api_login_external_token','1'),(162,'core','url_base_api','http://157.90.12.13/glpi/apirest.php/'),(163,'core','login_remember_time','604800'),(164,'core','login_remember_default','1'),(165,'core','use_notifications','0'),(166,'core','notifications_ajax','0'),(167,'core','notifications_ajax_check_interval','5'),(168,'core','notifications_ajax_sound',NULL),(169,'core','notifications_ajax_icon_url','/pics/glpi.png'),(170,'core','dbversion','9.5.0'),(171,'core','smtp_max_retries','5'),(172,'core','smtp_sender',NULL),(173,'core','from_email',NULL),(174,'core','from_email_name',NULL),(175,'core','instance_uuid',NULL),(176,'core','registration_uuid','LAbLcs1nfi2LHlSBA99sKbc8bE7HrKKus3DAcY0Z'),(177,'core','smtp_retry_time','5'),(178,'core','purge_addrelation','0'),(179,'core','purge_deleterelation','0'),(180,'core','purge_createitem','0'),(181,'core','purge_deleteitem','0'),(182,'core','purge_restoreitem','0'),(183,'core','purge_updateitem','0'),(184,'core','purge_item_software_install','0'),(185,'core','purge_software_item_install','0'),(186,'core','purge_software_version_install','0'),(187,'core','purge_infocom_creation','0'),(188,'core','purge_profile_user','0'),(189,'core','purge_group_user','0'),(190,'core','purge_adddevice','0'),(191,'core','purge_updatedevice','0'),(192,'core','purge_deletedevice','0'),(193,'core','purge_connectdevice','0'),(194,'core','purge_disconnectdevice','0'),(195,'core','purge_userdeletedfromldap','0'),(196,'core','purge_comments','0'),(197,'core','purge_datemod','0'),(198,'core','purge_all','0'),(199,'core','purge_user_auth_changes','0'),(200,'core','purge_plugins','0'),(201,'core','display_login_source','1'),(202,'core','devices_in_menu','[\"Item_DeviceSimcard\"]'),(203,'core','password_expiration_delay','-1'),(204,'core','password_expiration_notice','-1'),(205,'core','password_expiration_lock_delay','-1'),(206,'core','default_dashboard_central','central'),(207,'core','default_dashboard_assets','assets'),(208,'core','default_dashboard_helpdesk','assistance'),(209,'core','default_dashboard_mini_ticket','mini_tickets'),(210,'core','admin_email_noreply',''),(211,'core','admin_email_noreply_name',''),(212,'core','impact_enabled_itemtypes','[\"Appliance\",\"Cluster\",\"Computer\",\"Datacenter\",\"DCRoom\",\"Domain\",\"Enclosure\",\"Monitor\",\"NetworkEquipment\",\"PDU\",\"Peripheral\",\"Phone\",\"Printer\",\"Rack\",\"Software\"]'),(213,'core','use_timezones',''),(214,'core','marketplace_replace_plugins','2'),(215,'core','glpinetwork_registration_key','qbqPTzhsQksgluLWETGbVGZaJ1M8H2LkZtrmOEcZOvcOZgnc1J6yozkH9+BnMp4oGA4nWSPm9O1myTDZCc2JU1Zb/LL3Aiw1vRmSlV04h2WYejTtEkr3U15fY6iNUDZ07wd6KIQUWQOrJO4yKBDsT8UfbI07qd3o9nm/zEHd3uhcnBWmU7qkIttSCuWmt/BIMMOvPVSkOsBjruG7S+fsYXRLf/nU9OZA05klTGTN+7YMO6NLhfvcpwG7RCG837ZwJAS6SFuw8Rwuj01ZNs8TWT/T1exsB1SaGPms7fPDxDikyx/P+zFnVURKeI2sarGbl+MQl3zC8HYHH6BSXs2sHHKk/cie4frtez2r50TgO7TI7zFwiW8hSsK3WegvA5WZzTkSeiBTMoaAnngkDgxTfiJQiCGDXnAm/OffPYh9YPilBFvYT3J5uo6L7dOvQif1dBzsCP0CgeQU13P8TFbJ0W0UZovQ2lnkWRbDXVHn5sKRT4O870fw72w500f25Zxi2qa4xt9LGDlvGy8c+Gf7FcMfk/gsgbVQaHTaqWnNVbjBeNCJRiuVCbOPPHe7Lw6GR4Q+M0MyoJaTc5wL2Y44ienYtNzsmmVbgxLyJAP3smOjrxgHUyGTCRuV9o9zm50rGeH2WohTkE/gVmpY8W/eddUUgRqvUZTM8+OnJC7OqLmCHseq0vg4b6PUvM9/RkL1C7YRKOmMSGZPg5LrWT4DU+BC361P4miiGyo+D55XLzTxOjPCy5StNJeswu44RLApTH7aGQ=='),(216,'core','glpi_network_uuid','E67u5FnrMNblqWBsUS4zHZRgFWjTGGYdc18SSLcD'),(217,'core','update_auth','Save');

--
-- Table structure for table `glpi_consumableitems`
--

CREATE TABLE `glpi_consumableitems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `locations_id` int(11) NOT NULL DEFAULT 0,
  `consumableitemtypes_id` int(11) NOT NULL DEFAULT 0,
  `manufacturers_id` int(11) NOT NULL DEFAULT 0,
  `users_id_tech` int(11) NOT NULL DEFAULT 0,
  `groups_id_tech` int(11) NOT NULL DEFAULT 0,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `alarm_threshold` int(11) NOT NULL DEFAULT 10,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `otherserial` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `locations_id` (`locations_id`),
  KEY `users_id_tech` (`users_id_tech`),
  KEY `consumableitemtypes_id` (`consumableitemtypes_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `alarm_threshold` (`alarm_threshold`),
  KEY `groups_id_tech` (`groups_id_tech`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `otherserial` (`otherserial`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_consumableitems`
--


--
-- Table structure for table `glpi_consumableitemtypes`
--

CREATE TABLE `glpi_consumableitemtypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_consumableitemtypes`
--


--
-- Table structure for table `glpi_consumables`
--

CREATE TABLE `glpi_consumables` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `consumableitems_id` int(11) NOT NULL DEFAULT 0,
  `date_in` date DEFAULT NULL,
  `date_out` date DEFAULT NULL,
  `itemtype` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `items_id` int(11) NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `date_in` (`date_in`),
  KEY `date_out` (`date_out`),
  KEY `consumableitems_id` (`consumableitems_id`),
  KEY `entities_id` (`entities_id`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_consumables`
--


--
-- Table structure for table `glpi_contacts`
--

CREATE TABLE `glpi_contacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `firstname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mobile` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fax` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contacttypes_id` int(11) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `usertitles_id` int(11) NOT NULL DEFAULT 0,
  `address` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `postcode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `town` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `contacttypes_id` (`contacttypes_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `usertitles_id` (`usertitles_id`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_contacts`
--


--
-- Table structure for table `glpi_contacts_suppliers`
--

CREATE TABLE `glpi_contacts_suppliers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `suppliers_id` int(11) NOT NULL DEFAULT 0,
  `contacts_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`suppliers_id`,`contacts_id`),
  KEY `contacts_id` (`contacts_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_contacts_suppliers`
--


--
-- Table structure for table `glpi_contacttypes`
--

CREATE TABLE `glpi_contacttypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_contacttypes`
--


--
-- Table structure for table `glpi_contractcosts`
--

CREATE TABLE `glpi_contractcosts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contracts_id` int(11) NOT NULL DEFAULT 0,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `begin_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `cost` decimal(20,4) NOT NULL DEFAULT 0.0000,
  `budgets_id` int(11) NOT NULL DEFAULT 0,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `contracts_id` (`contracts_id`),
  KEY `begin_date` (`begin_date`),
  KEY `end_date` (`end_date`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `budgets_id` (`budgets_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_contractcosts`
--


--
-- Table structure for table `glpi_contracts`
--

CREATE TABLE `glpi_contracts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `num` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contracttypes_id` int(11) NOT NULL DEFAULT 0,
  `begin_date` date DEFAULT NULL,
  `duration` int(11) NOT NULL DEFAULT 0,
  `notice` int(11) NOT NULL DEFAULT 0,
  `periodicity` int(11) NOT NULL DEFAULT 0,
  `billing` int(11) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `accounting_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `week_begin_hour` time NOT NULL DEFAULT '00:00:00',
  `week_end_hour` time NOT NULL DEFAULT '00:00:00',
  `saturday_begin_hour` time NOT NULL DEFAULT '00:00:00',
  `saturday_end_hour` time NOT NULL DEFAULT '00:00:00',
  `use_saturday` tinyint(1) NOT NULL DEFAULT 0,
  `monday_begin_hour` time NOT NULL DEFAULT '00:00:00',
  `monday_end_hour` time NOT NULL DEFAULT '00:00:00',
  `use_monday` tinyint(1) NOT NULL DEFAULT 0,
  `max_links_allowed` int(11) NOT NULL DEFAULT 0,
  `alert` int(11) NOT NULL DEFAULT 0,
  `renewal` int(11) NOT NULL DEFAULT 0,
  `template_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_template` tinyint(1) NOT NULL DEFAULT 0,
  `states_id` int(11) NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `begin_date` (`begin_date`),
  KEY `name` (`name`),
  KEY `contracttypes_id` (`contracttypes_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `use_monday` (`use_monday`),
  KEY `use_saturday` (`use_saturday`),
  KEY `alert` (`alert`),
  KEY `states_id` (`states_id`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_contracts`
--


--
-- Table structure for table `glpi_contracts_items`
--

CREATE TABLE `glpi_contracts_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contracts_id` int(11) NOT NULL DEFAULT 0,
  `items_id` int(11) NOT NULL DEFAULT 0,
  `itemtype` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`contracts_id`,`itemtype`,`items_id`),
  KEY `FK_device` (`items_id`,`itemtype`),
  KEY `item` (`itemtype`,`items_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_contracts_items`
--


--
-- Table structure for table `glpi_contracts_suppliers`
--

CREATE TABLE `glpi_contracts_suppliers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `suppliers_id` int(11) NOT NULL DEFAULT 0,
  `contracts_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`suppliers_id`,`contracts_id`),
  KEY `contracts_id` (`contracts_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_contracts_suppliers`
--


--
-- Table structure for table `glpi_contracttypes`
--

CREATE TABLE `glpi_contracttypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_contracttypes`
--


--
-- Table structure for table `glpi_crontasklogs`
--

CREATE TABLE `glpi_crontasklogs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `crontasks_id` int(11) NOT NULL,
  `crontasklogs_id` int(11) NOT NULL COMMENT 'id of ''start'' event',
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `state` int(11) NOT NULL COMMENT '0:start, 1:run, 2:stop',
  `elapsed` float NOT NULL COMMENT 'time elapsed since start',
  `volume` int(11) NOT NULL COMMENT 'for statistics',
  `content` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'message',
  PRIMARY KEY (`id`),
  KEY `date` (`date`),
  KEY `crontasks_id` (`crontasks_id`),
  KEY `crontasklogs_id_state` (`crontasklogs_id`,`state`)
) ENGINE=InnoDB AUTO_INCREMENT=509 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `glpi_crontasklogs`
--

INSERT INTO `glpi_crontasklogs` VALUES (1,18,0,'2021-10-19 16:09:50',0,0,0,'Run mode: GLPI'),(2,18,1,'2021-10-19 16:09:50',2,0.0112581,0,'Action completed, no processing required'),(3,19,0,'2021-10-19 16:12:01',0,0,0,'Run mode: GLPI'),(4,19,3,'2021-10-19 16:12:01',2,0.00618505,0,'Action completed, fully processed'),(5,20,0,'2021-10-19 16:17:55',0,0,0,'Run mode: GLPI'),(6,20,5,'2021-10-19 16:17:55',2,0.00445199,0,'Action completed, no processing required'),(7,21,0,'2021-10-19 16:18:27',0,0,0,'Run mode: GLPI'),(8,21,7,'2021-10-19 16:18:27',2,0.00537515,0,'Action completed, no processing required'),(9,22,0,'2021-10-19 16:18:33',0,0,0,'Run mode: GLPI'),(10,22,9,'2021-10-19 16:18:33',2,0.00833893,0,'Action completed, no processing required'),(11,23,0,'2021-10-19 16:23:11',0,0,0,'Run mode: GLPI'),(12,23,11,'2021-10-19 16:23:11',2,0.00861096,0,'Action completed, no processing required'),(13,24,0,'2021-10-19 16:30:11',0,0,0,'Run mode: GLPI'),(14,24,13,'2021-10-19 16:30:11',1,0.0044589,1,'Clean 1 temporary file created since more than 3600 seconds\n'),(15,24,13,'2021-10-19 16:30:11',2,0.011313,1,'Action completed, fully processed'),(16,25,0,'2021-10-19 16:30:20',0,0,0,'Run mode: GLPI'),(17,25,16,'2021-10-19 16:30:20',2,0.00455904,0,'Action completed, no processing required'),(18,5,0,'2021-10-19 16:31:10',0,0,0,'Run mode: GLPI'),(19,5,18,'2021-10-19 16:31:10',2,0.00577307,0,'Action completed, no processing required'),(20,6,0,'2021-10-19 16:45:41',0,0,0,'Run mode: GLPI'),(21,6,20,'2021-10-19 16:45:41',2,0.00489092,0,'Action completed, no processing required'),(22,9,0,'2021-10-19 20:41:32',0,0,0,'Run mode: GLPI'),(23,9,22,'2021-10-19 20:41:32',2,0.043885,0,'Action completed, no processing required'),(24,12,0,'2021-10-19 20:48:18',0,0,0,'Run mode: GLPI'),(25,12,24,'2021-10-19 20:48:18',1,0.00378084,11,'Clean 11 session files created since more than 1440 seconds\n'),(26,12,24,'2021-10-19 20:48:18',2,0.0109699,11,'Action completed, fully processed'),(27,13,0,'2021-10-19 20:58:45',0,0,0,'Run mode: GLPI'),(28,13,27,'2021-10-19 20:58:45',1,0.00354791,1,'Clean 1 graph file created since more than 3600 seconds\n'),(29,13,27,'2021-10-19 20:58:45',2,0.008075,1,'Action completed, fully processed'),(30,14,0,'2021-10-19 21:04:40',0,0,0,'Run mode: GLPI'),(31,14,30,'2021-10-19 21:04:40',2,0.00515008,0,'Action completed, no processing required'),(32,15,0,'2021-10-19 21:13:30',0,0,0,'Run mode: GLPI'),(33,15,32,'2021-10-19 21:13:30',2,0.00454402,0,'Action completed, no processing required'),(34,16,0,'2021-10-19 21:16:24',0,0,0,'Run mode: GLPI'),(35,16,34,'2021-10-19 21:16:24',2,0.00817704,0,'Action completed, no processing required'),(36,17,0,'2021-10-19 21:45:13',0,0,0,'Run mode: GLPI'),(37,17,36,'2021-10-19 21:45:13',2,0.00665498,0,'Action completed, no processing required'),(38,32,0,'2021-10-19 21:50:15',0,0,0,'Run mode: GLPI'),(39,32,38,'2021-10-19 21:50:15',2,0.00640106,0,'Action completed, no processing required'),(40,22,0,'2021-10-20 15:14:30',0,0,0,'Run mode: GLPI'),(41,22,40,'2021-10-20 15:14:30',2,0.00876594,0,'Action completed, no processing required'),(42,21,0,'2021-10-20 15:19:50',0,0,0,'Run mode: GLPI'),(43,21,42,'2021-10-20 15:19:50',2,0.00468087,0,'Action completed, no processing required'),(44,20,0,'2021-10-20 15:20:34',0,0,0,'Run mode: GLPI'),(45,20,44,'2021-10-20 15:20:34',2,0.00431299,0,'Action completed, no processing required'),(46,24,0,'2021-10-20 15:25:12',0,0,0,'Run mode: GLPI'),(47,24,46,'2021-10-20 15:25:12',1,0.00356817,1,'Clean 1 temporary file created since more than 3600 seconds\n'),(48,24,46,'2021-10-20 15:25:12',2,0.00802302,1,'Action completed, fully processed'),(49,9,0,'2021-10-20 15:30:48',0,0,0,'Run mode: GLPI'),(50,9,49,'2021-10-20 15:30:48',2,0.0266221,0,'Action completed, no processing required'),(51,17,0,'2021-10-20 15:32:30',0,0,0,'Run mode: GLPI'),(52,17,51,'2021-10-20 15:32:30',2,0.00508595,0,'Action completed, no processing required'),(53,32,0,'2021-10-20 15:34:04',0,0,0,'Run mode: GLPI'),(54,32,53,'2021-10-20 15:34:04',2,0.0058291,0,'Action completed, no processing required'),(55,13,0,'2021-10-20 15:34:10',0,0,0,'Run mode: GLPI'),(56,13,55,'2021-10-20 15:34:10',2,0.00444102,0,'Action completed, no processing required'),(57,14,0,'2021-10-20 15:35:48',0,0,0,'Run mode: GLPI'),(58,14,57,'2021-10-20 15:35:48',2,0.00413299,0,'Action completed, no processing required'),(59,15,0,'2021-10-20 15:37:18',0,0,0,'Run mode: GLPI'),(60,15,59,'2021-10-20 15:37:18',2,0.010572,0,'Action completed, no processing required'),(61,16,0,'2021-10-20 15:44:00',0,0,0,'Run mode: GLPI'),(62,16,61,'2021-10-20 15:44:00',2,0.00510406,0,'Action completed, no processing required'),(63,22,0,'2021-10-20 16:43:49',0,0,0,'Run mode: GLPI'),(64,22,63,'2021-10-20 16:43:49',2,0.035763,0,'Action completed, no processing required'),(65,21,0,'2021-10-20 21:23:41',0,0,0,'Run mode: GLPI'),(66,21,65,'2021-10-20 21:23:41',2,0.00494814,0,'Action completed, no processing required'),(67,17,0,'2021-10-20 21:26:03',0,0,0,'Run mode: GLPI'),(68,17,67,'2021-10-20 21:26:03',2,0.00988007,0,'Action completed, no processing required'),(69,32,0,'2021-10-20 21:50:54',0,0,0,'Run mode: GLPI'),(70,32,69,'2021-10-20 21:50:54',2,0.00577211,0,'Action completed, no processing required'),(71,9,0,'2021-10-21 09:30:53',0,0,0,'Run mode: GLPI'),(72,9,71,'2021-10-21 09:30:53',2,0.0454628,0,'Action completed, no processing required'),(73,20,0,'2021-10-21 09:37:21',0,0,0,'Run mode: GLPI'),(74,20,73,'2021-10-21 09:37:21',2,0.00402689,0,'Action completed, no processing required'),(75,24,0,'2021-10-21 15:27:48',0,0,0,'Run mode: GLPI'),(76,24,75,'2021-10-21 15:27:48',1,0.00470018,6,'Clean 6 temporary files created since more than 3600 seconds\n'),(77,24,75,'2021-10-21 15:27:48',2,0.0134671,6,'Action completed, fully processed'),(78,13,0,'2021-10-21 15:37:58',0,0,0,'Run mode: GLPI'),(79,13,78,'2021-10-21 15:37:58',2,0.00464296,0,'Action completed, no processing required'),(80,14,0,'2021-10-21 15:37:59',0,0,0,'Run mode: GLPI'),(81,14,80,'2021-10-21 15:37:59',2,0.00399613,0,'Action completed, no processing required'),(82,22,0,'2021-10-21 15:43:11',0,0,0,'Run mode: GLPI'),(83,22,82,'2021-10-21 15:43:11',2,0.0077219,0,'Action completed, no processing required'),(84,18,0,'2021-10-21 16:17:24',0,0,0,'Run mode: GLPI'),(85,18,84,'2021-10-21 16:17:24',2,0.007761,0,'Action completed, no processing required'),(86,19,0,'2021-10-21 17:27:55',0,0,0,'Run mode: GLPI'),(87,19,86,'2021-10-21 17:27:55',2,0.00650215,0,'Action completed, fully processed'),(88,23,0,'2021-10-25 18:27:30',0,0,0,'Run mode: GLPI'),(89,23,88,'2021-10-25 18:27:30',2,0.0273919,0,'Action completed, no processing required'),(90,25,0,'2021-10-26 09:11:13',0,0,0,'Run mode: GLPI'),(91,25,90,'2021-10-26 09:11:13',2,0.00666714,0,'Action completed, no processing required'),(92,5,0,'2021-10-26 16:48:26',0,0,0,'Run mode: GLPI'),(93,5,92,'2021-10-26 16:48:26',2,0.00458503,0,'Action completed, no processing required'),(94,6,0,'2021-10-26 16:54:33',0,0,0,'Run mode: GLPI'),(95,6,94,'2021-10-26 16:54:33',2,0.00490093,0,'Action completed, no processing required'),(96,12,0,'2021-10-26 17:02:17',0,0,0,'Run mode: GLPI'),(97,12,96,'2021-10-26 17:02:17',1,0.00437617,14,'Clean 14 session files created since more than 1440 seconds\n'),(98,12,96,'2021-10-26 17:02:17',2,0.0112941,14,'Action completed, fully processed'),(99,21,0,'2021-10-26 17:12:57',0,0,0,'Run mode: GLPI'),(100,21,99,'2021-10-26 17:12:57',2,0.00609398,0,'Action completed, no processing required'),(101,17,0,'2021-10-26 17:18:12',0,0,0,'Run mode: GLPI'),(102,17,101,'2021-10-26 17:18:12',2,0.00625801,0,'Action completed, no processing required'),(103,32,0,'2021-10-26 17:29:20',0,0,0,'Run mode: GLPI'),(104,32,103,'2021-10-26 17:29:20',2,0.00465393,0,'Action completed, no processing required'),(105,15,0,'2021-10-26 17:37:22',0,0,0,'Run mode: GLPI'),(106,15,105,'2021-10-26 17:37:22',2,0.00602007,0,'Action completed, no processing required'),(107,16,0,'2021-10-26 18:46:24',0,0,0,'Run mode: GLPI'),(108,16,107,'2021-10-26 18:46:24',2,0.00563407,0,'Action completed, no processing required'),(109,9,0,'2021-10-26 18:52:45',0,0,0,'Run mode: GLPI'),(110,9,109,'2021-10-26 18:52:45',2,0.0265348,0,'Action completed, no processing required'),(111,20,0,'2021-10-26 18:57:46',0,0,0,'Run mode: GLPI'),(112,20,111,'2021-10-26 18:57:46',2,0.00642776,0,'Action completed, no processing required'),(113,22,0,'2021-10-26 19:02:51',0,0,0,'Run mode: GLPI'),(114,22,113,'2021-10-26 19:02:51',2,0.00735283,0,'Action completed, no processing required'),(115,24,0,'2021-10-26 19:10:48',0,0,0,'Run mode: GLPI'),(116,24,115,'2021-10-26 19:10:48',2,0.00557494,0,'Action completed, no processing required'),(117,13,0,'2021-10-26 20:36:42',0,0,0,'Run mode: GLPI'),(118,13,117,'2021-10-26 20:36:42',2,0.00611305,0,'Action completed, no processing required'),(119,14,0,'2021-10-26 21:47:19',0,0,0,'Run mode: GLPI'),(120,14,119,'2021-10-26 21:47:19',2,0.00495696,0,'Action completed, no processing required'),(121,18,0,'2021-10-27 15:48:19',0,0,0,'Run mode: GLPI'),(122,18,121,'2021-10-27 15:48:19',2,0.031872,0,'Action completed, no processing required'),(123,19,0,'2021-10-27 15:49:27',0,0,0,'Run mode: GLPI'),(124,19,123,'2021-10-27 15:49:27',2,0.010637,0,'Action completed, fully processed'),(125,21,0,'2021-10-27 16:01:04',0,0,0,'Run mode: GLPI'),(126,21,125,'2021-10-27 16:01:04',2,0.00559616,0,'Action completed, no processing required'),(127,17,0,'2021-10-27 17:02:56',0,0,0,'Run mode: GLPI'),(128,17,127,'2021-10-27 17:02:56',2,0.00694799,0,'Action completed, no processing required'),(129,32,0,'2021-10-27 17:08:03',0,0,0,'Run mode: GLPI'),(130,32,129,'2021-10-27 17:08:03',2,0.00609422,0,'Action completed, no processing required'),(131,23,0,'2021-10-27 17:57:25',0,0,0,'Run mode: GLPI'),(132,23,131,'2021-10-27 17:57:25',2,0.0057919,0,'Action completed, no processing required'),(133,9,0,'2021-10-27 18:22:41',0,0,0,'Run mode: GLPI'),(134,9,133,'2021-10-27 18:22:41',2,0.021827,0,'Action completed, no processing required'),(135,22,0,'2021-10-27 18:46:48',0,0,0,'Run mode: GLPI'),(136,22,135,'2021-10-27 18:46:48',2,0.00694203,0,'Action completed, no processing required'),(137,20,0,'2021-10-27 18:53:43',0,0,0,'Run mode: GLPI'),(138,20,137,'2021-10-27 18:53:43',2,0.00433397,0,'Action completed, no processing required'),(139,24,0,'2021-10-29 09:13:59',0,0,0,'Run mode: GLPI'),(140,24,139,'2021-10-29 09:13:59',1,0.0300589,1,'Clean 1 temporary file created since more than 3600 seconds\n'),(141,24,139,'2021-10-29 09:13:59',2,0.033597,1,'Action completed, fully processed'),(142,13,0,'2021-10-29 09:19:41',0,0,0,'Run mode: GLPI'),(143,13,142,'2021-10-29 09:19:41',2,0.00531316,0,'Action completed, no processing required'),(144,14,0,'2021-10-29 11:14:40',0,0,0,'Run mode: GLPI'),(145,14,144,'2021-10-29 11:14:40',2,0.027498,0,'Action completed, no processing required'),(146,15,0,'2021-10-29 12:01:45',0,0,0,'Run mode: GLPI'),(147,15,146,'2021-10-29 12:01:45',2,0.00574899,0,'Action completed, no processing required'),(148,16,0,'2021-10-29 12:06:45',0,0,0,'Run mode: GLPI'),(149,16,148,'2021-10-29 12:06:45',2,0.00462008,0,'Action completed, no processing required'),(150,25,0,'2021-10-29 15:35:23',0,0,0,'Run mode: GLPI'),(151,25,150,'2021-10-29 15:35:23',2,0.00985408,0,'Action completed, no processing required'),(152,21,0,'2021-10-29 15:40:31',0,0,0,'Run mode: GLPI'),(153,21,152,'2021-10-29 15:40:31',2,0.00443411,0,'Action completed, no processing required'),(154,5,0,'2021-10-29 15:45:39',0,0,0,'Run mode: GLPI'),(155,5,154,'2021-10-29 15:45:39',2,0.00456119,0,'Action completed, no processing required'),(156,6,0,'2021-10-29 16:16:46',0,0,0,'Run mode: GLPI'),(157,6,156,'2021-10-29 16:16:46',2,0.018235,0,'Action completed, no processing required'),(158,12,0,'2021-10-29 16:17:05',0,0,0,'Run mode: GLPI'),(159,12,158,'2021-10-29 16:17:05',1,0.00433302,16,'Clean 16 session files created since more than 1440 seconds\n'),(160,12,158,'2021-10-29 16:17:05',2,0.00883603,16,'Action completed, fully processed'),(161,17,0,'2021-10-29 16:31:18',0,0,0,'Run mode: GLPI'),(162,17,161,'2021-10-29 16:31:18',2,0.02105,0,'Action completed, no processing required'),(163,32,0,'2021-10-29 16:39:37',0,0,0,'Run mode: GLPI'),(164,32,163,'2021-10-29 16:39:37',2,0.00608087,0,'Action completed, no processing required'),(165,9,0,'2021-10-29 16:43:56',0,0,0,'Run mode: GLPI'),(166,9,165,'2021-10-29 16:43:56',2,0.0434711,0,'Action completed, no processing required'),(167,22,0,'2021-10-29 16:52:23',0,0,0,'Run mode: GLPI'),(168,22,167,'2021-10-29 16:52:23',2,0.00764298,0,'Action completed, no processing required'),(169,20,0,'2021-10-29 17:27:02',0,0,0,'Run mode: GLPI'),(170,20,169,'2021-10-29 17:27:02',2,0.00450492,0,'Action completed, no processing required'),(171,18,0,'2021-10-29 17:42:01',0,0,0,'Run mode: GLPI'),(172,18,171,'2021-10-29 17:42:01',2,0.00821209,0,'Action completed, no processing required'),(173,19,0,'2021-10-29 17:47:43',0,0,0,'Run mode: GLPI'),(174,19,173,'2021-10-29 17:47:43',2,0.00473499,0,'Action completed, fully processed'),(175,23,0,'2021-10-29 18:26:17',0,0,0,'Run mode: GLPI'),(176,23,175,'2021-10-29 18:26:17',2,0.00555301,0,'Action completed, no processing required'),(177,24,0,'2021-10-30 09:11:33',0,0,0,'Run mode: GLPI'),(178,24,177,'2021-10-30 09:11:33',1,0.019345,3,'Clean 3 temporary files created since more than 3600 seconds\n'),(179,24,177,'2021-10-30 09:11:33',2,0.022706,3,'Action completed, fully processed'),(180,13,0,'2021-10-30 13:36:53',0,0,0,'Run mode: GLPI'),(181,13,180,'2021-10-30 13:36:53',2,0.005584,0,'Action completed, no processing required'),(182,14,0,'2021-11-01 09:06:34',0,0,0,'Run mode: GLPI'),(183,14,182,'2021-11-01 09:06:34',2,0.0202808,0,'Action completed, no processing required'),(184,21,0,'2021-11-01 18:26:38',0,0,0,'Run mode: GLPI'),(185,21,184,'2021-11-01 18:26:38',2,0.00532198,0,'Action completed, no processing required'),(186,17,0,'2021-11-01 18:31:48',0,0,0,'Run mode: GLPI'),(187,17,186,'2021-11-01 18:31:48',2,0.0107911,0,'Action completed, no processing required'),(188,32,0,'2021-11-02 15:50:22',0,0,0,'Run mode: GLPI'),(189,32,188,'2021-11-02 15:50:22',2,0.0203719,0,'Action completed, no processing required'),(190,9,0,'2021-11-02 15:55:25',0,0,0,'Run mode: GLPI'),(191,9,190,'2021-11-02 15:55:25',2,0.0258658,0,'Action completed, no processing required'),(192,22,0,'2021-11-02 16:07:31',0,0,0,'Run mode: GLPI'),(193,22,192,'2021-11-02 16:07:31',2,0.00798821,0,'Action completed, no processing required'),(194,20,0,'2021-11-02 16:31:44',0,0,0,'Run mode: GLPI'),(195,20,194,'2021-11-02 16:31:44',2,0.00507903,0,'Action completed, no processing required'),(196,15,0,'2021-11-02 16:36:48',0,0,0,'Run mode: GLPI'),(197,15,196,'2021-11-02 16:36:48',2,0.00586009,0,'Action completed, no processing required'),(198,16,0,'2021-11-02 17:08:00',0,0,0,'Run mode: GLPI'),(199,16,198,'2021-11-02 17:08:00',2,0.00587797,0,'Action completed, no processing required'),(200,24,0,'2021-11-02 17:44:20',0,0,0,'Run mode: GLPI'),(201,24,200,'2021-11-02 17:44:20',2,0.00456405,0,'Action completed, no processing required'),(202,13,0,'2021-11-03 15:34:41',0,0,0,'Run mode: GLPI'),(203,13,202,'2021-11-03 15:34:41',2,0.0194359,0,'Action completed, no processing required'),(204,25,0,'2021-11-03 15:40:36',0,0,0,'Run mode: GLPI'),(205,25,204,'2021-11-03 15:40:36',2,0.00528502,0,'Action completed, no processing required'),(206,5,0,'2021-11-03 15:45:38',0,0,0,'Run mode: GLPI'),(207,5,206,'2021-11-03 15:45:38',2,0.00594187,0,'Action completed, no processing required'),(208,6,0,'2021-11-03 16:27:56',0,0,0,'Run mode: GLPI'),(209,6,208,'2021-11-03 16:27:56',2,0.00890493,0,'Action completed, no processing required'),(210,12,0,'2021-11-03 16:34:29',0,0,0,'Run mode: GLPI'),(211,12,210,'2021-11-03 16:34:29',1,0.00351214,7,'Clean 7 session files created since more than 1440 seconds\n'),(212,12,210,'2021-11-03 16:34:29',2,0.00686002,7,'Action completed, fully processed'),(213,18,0,'2021-11-03 16:45:42',0,0,0,'Run mode: GLPI'),(214,18,213,'2021-11-03 16:45:42',2,0.00704718,0,'Action completed, no processing required'),(215,19,0,'2021-11-03 17:19:14',0,0,0,'Run mode: GLPI'),(216,19,215,'2021-11-03 17:19:14',2,0.00499201,0,'Action completed, fully processed'),(217,23,0,'2021-11-05 16:56:25',0,0,0,'Run mode: GLPI'),(218,23,217,'2021-11-05 16:56:25',2,0.0201001,0,'Action completed, no processing required'),(219,14,0,'2021-11-05 17:26:56',0,0,0,'Run mode: GLPI'),(220,14,219,'2021-11-05 17:26:56',2,0.00564599,0,'Action completed, no processing required'),(221,21,0,'2021-11-05 18:38:46',0,0,0,'Run mode: GLPI'),(222,21,221,'2021-11-05 18:38:46',2,0.00597692,0,'Action completed, no processing required'),(223,17,0,'2021-11-05 18:44:16',0,0,0,'Run mode: GLPI'),(224,17,223,'2021-11-05 18:44:16',2,0.00575709,0,'Action completed, no processing required'),(225,32,0,'2021-11-08 16:48:59',0,0,0,'Run mode: GLPI'),(226,32,225,'2021-11-08 16:48:59',2,0.02033,0,'Action completed, no processing required'),(227,9,0,'2021-11-08 17:07:58',0,0,0,'Run mode: GLPI'),(228,9,227,'2021-11-08 17:07:58',2,0.0266669,0,'Action completed, no processing required'),(229,22,0,'2021-11-08 17:15:12',0,0,0,'Run mode: GLPI'),(230,22,229,'2021-11-08 17:15:12',2,0.00784492,0,'Action completed, no processing required'),(231,20,0,'2021-11-08 17:24:13',0,0,0,'Run mode: GLPI'),(232,20,231,'2021-11-08 17:24:13',2,0.00470805,0,'Action completed, no processing required'),(233,24,0,'2021-11-08 17:31:54',0,0,0,'Run mode: GLPI'),(234,24,233,'2021-11-08 17:31:54',2,0.00617886,0,'Action completed, no processing required'),(235,15,0,'2021-11-08 17:48:03',0,0,0,'Run mode: GLPI'),(236,15,235,'2021-11-08 17:48:03',2,0.00801682,0,'Action completed, no processing required'),(237,16,0,'2021-11-08 19:13:19',0,0,0,'Run mode: GLPI'),(238,16,237,'2021-11-08 19:13:19',2,0.00532985,0,'Action completed, no processing required'),(239,13,0,'2021-11-08 20:07:29',0,0,0,'Run mode: GLPI'),(240,13,239,'2021-11-08 20:07:29',2,0.00573683,0,'Action completed, no processing required'),(241,25,0,'2021-11-08 20:26:08',0,0,0,'Run mode: GLPI'),(242,25,241,'2021-11-08 20:26:08',2,0.00564003,0,'Action completed, no processing required'),(243,5,0,'2021-11-08 20:53:29',0,0,0,'Run mode: GLPI'),(244,5,243,'2021-11-08 20:53:29',2,0.00635314,0,'Action completed, no processing required'),(245,6,0,'2021-11-08 21:01:35',0,0,0,'Run mode: GLPI'),(246,6,245,'2021-11-08 21:01:35',2,0.00483298,0,'Action completed, no processing required'),(247,12,0,'2021-11-08 21:08:45',0,0,0,'Run mode: GLPI'),(248,12,247,'2021-11-08 21:08:45',2,0.00450778,0,'Action completed, no processing required'),(249,18,0,'2021-11-09 16:21:44',0,0,0,'Run mode: GLPI'),(250,18,249,'2021-11-09 16:21:44',2,0.021956,0,'Action completed, no processing required'),(251,19,0,'2021-11-09 16:33:14',0,0,0,'Run mode: GLPI'),(252,19,251,'2021-11-09 16:33:14',2,0.00451708,0,'Action completed, fully processed'),(253,14,0,'2021-11-09 16:44:24',0,0,0,'Run mode: GLPI'),(254,14,253,'2021-11-09 16:44:24',2,0.00511289,0,'Action completed, no processing required'),(255,21,0,'2021-11-09 16:49:43',0,0,0,'Run mode: GLPI'),(256,21,255,'2021-11-09 16:49:43',2,0.00485301,0,'Action completed, no processing required'),(257,17,0,'2021-11-09 16:56:17',0,0,0,'Run mode: GLPI'),(258,17,257,'2021-11-09 16:56:17',2,0.00606203,0,'Action completed, no processing required'),(259,23,0,'2021-11-09 17:01:32',0,0,0,'Run mode: GLPI'),(260,23,259,'2021-11-09 17:01:32',2,0.00637507,0,'Action completed, no processing required'),(261,32,0,'2021-11-09 17:57:41',0,0,0,'Run mode: GLPI'),(262,32,261,'2021-11-09 17:57:41',2,0.00472903,0,'Action completed, no processing required'),(263,22,0,'2021-11-09 18:02:53',0,0,0,'Run mode: GLPI'),(264,22,263,'2021-11-09 18:02:53',2,0.00782108,0,'Action completed, no processing required'),(265,9,0,'2021-11-09 18:08:15',0,0,0,'Run mode: GLPI'),(266,9,265,'2021-11-09 18:08:15',2,0.0241051,0,'Action completed, no processing required'),(267,20,0,'2021-11-09 18:26:32',0,0,0,'Run mode: GLPI'),(268,20,267,'2021-11-09 18:26:32',2,0.00594282,0,'Action completed, no processing required'),(269,24,0,'2021-11-09 18:48:38',0,0,0,'Run mode: GLPI'),(270,24,269,'2021-11-09 18:48:38',2,0.00479889,0,'Action completed, no processing required'),(271,13,0,'2021-11-09 21:10:24',0,0,0,'Run mode: GLPI'),(272,13,271,'2021-11-09 21:10:24',2,0.00597095,0,'Action completed, no processing required'),(273,15,0,'2021-11-09 21:23:51',0,0,0,'Run mode: GLPI'),(274,15,273,'2021-11-09 21:23:51',2,0.00480103,0,'Action completed, no processing required'),(275,16,0,'2021-11-09 21:58:07',0,0,0,'Run mode: GLPI'),(276,16,275,'2021-11-09 21:58:07',2,0.00453711,0,'Action completed, no processing required'),(277,21,0,'2021-11-10 15:23:09',0,0,0,'Run mode: GLPI'),(278,21,277,'2021-11-10 15:23:09',2,0.019798,0,'Action completed, no processing required'),(279,17,0,'2021-11-11 18:26:05',0,0,0,'Run mode: GLPI'),(280,17,279,'2021-11-11 18:26:05',2,0.0296099,0,'Action completed, no processing required'),(281,14,0,'2021-11-12 15:14:12',0,0,0,'Run mode: GLPI'),(282,14,281,'2021-11-12 15:14:12',2,0.028589,0,'Action completed, no processing required'),(283,32,0,'2021-11-12 15:30:50',0,0,0,'Run mode: GLPI'),(284,32,283,'2021-11-12 15:30:50',2,0.00510311,0,'Action completed, no processing required'),(285,22,0,'2021-11-15 16:11:00',0,0,0,'Run mode: GLPI'),(286,22,285,'2021-11-15 16:11:00',2,0.0371542,0,'Action completed, no processing required'),(287,9,0,'2021-11-18 16:27:07',0,0,0,'Run mode: GLPI'),(288,9,287,'2021-11-18 16:27:07',2,0.047539,0,'Action completed, no processing required'),(289,20,0,'2021-11-18 16:33:31',0,0,0,'Run mode: GLPI'),(290,20,289,'2021-11-18 16:33:31',2,0.00598192,0,'Action completed, no processing required'),(291,24,0,'2021-11-18 16:58:38',0,0,0,'Run mode: GLPI'),(292,24,291,'2021-11-18 16:58:38',2,0.00461102,0,'Action completed, no processing required'),(293,25,0,'2021-11-18 17:09:53',0,0,0,'Run mode: GLPI'),(294,25,293,'2021-11-18 17:09:53',2,0.00720406,0,'Action completed, no processing required'),(295,5,0,'2021-11-18 18:14:11',0,0,0,'Run mode: GLPI'),(296,5,295,'2021-11-18 18:14:11',2,0.00489593,0,'Action completed, no processing required'),(297,6,0,'2021-11-18 18:19:12',0,0,0,'Run mode: GLPI'),(298,6,297,'2021-11-18 18:19:12',2,0.00430489,0,'Action completed, no processing required'),(299,12,0,'2021-11-18 18:29:54',0,0,0,'Run mode: GLPI'),(300,12,299,'2021-11-18 18:29:54',1,0.00376296,4,'Clean 4 session files created since more than 1440 seconds\n'),(301,12,299,'2021-11-18 18:29:54',2,0.0100091,4,'Action completed, fully processed'),(302,13,0,'2021-11-19 15:36:06',0,0,0,'Run mode: GLPI'),(303,13,302,'2021-11-19 15:36:06',2,0.026912,0,'Action completed, no processing required'),(304,15,0,'2021-11-19 16:20:03',0,0,0,'Run mode: GLPI'),(305,15,304,'2021-11-19 16:20:03',2,0.00607491,0,'Action completed, no processing required'),(306,16,0,'2021-11-19 16:27:52',0,0,0,'Run mode: GLPI'),(307,16,306,'2021-11-19 16:27:52',2,0.0061512,0,'Action completed, no processing required'),(308,21,0,'2021-11-19 16:46:37',0,0,0,'Run mode: GLPI'),(309,21,308,'2021-11-19 16:46:37',2,0.00524282,0,'Action completed, no processing required'),(310,18,0,'2021-11-19 16:56:13',0,0,0,'Run mode: GLPI'),(311,18,310,'2021-11-19 16:56:13',2,0.0089848,0,'Action completed, no processing required'),(312,19,0,'2021-11-22 17:55:58',0,0,0,'Run mode: GLPI'),(313,19,312,'2021-11-22 17:55:58',2,0.029633,0,'Action completed, fully processed'),(314,23,0,'2021-11-22 18:02:52',0,0,0,'Run mode: GLPI'),(315,23,314,'2021-11-22 18:02:52',2,0.00598907,0,'Action completed, no processing required'),(316,17,0,'2021-11-22 18:12:30',0,0,0,'Run mode: GLPI'),(317,17,316,'2021-11-22 18:12:30',2,0.00486207,0,'Action completed, no processing required'),(318,32,0,'2021-11-22 18:38:17',0,0,0,'Run mode: GLPI'),(319,32,318,'2021-11-22 18:38:17',2,0.00609803,0,'Action completed, no processing required'),(320,14,0,'2021-11-23 15:48:22',0,0,0,'Run mode: GLPI'),(321,14,320,'2021-11-23 15:48:22',2,0.0199618,0,'Action completed, no processing required'),(322,22,0,'2021-11-23 16:07:37',0,0,0,'Run mode: GLPI'),(323,22,322,'2021-11-23 16:07:37',2,0.00809979,0,'Action completed, no processing required'),(324,9,0,'2021-11-23 16:14:35',0,0,0,'Run mode: GLPI'),(325,9,324,'2021-11-23 16:14:35',2,0.023473,0,'Action completed, no processing required'),(326,20,0,'2021-11-27 10:18:08',0,0,0,'Run mode: GLPI'),(327,20,326,'2021-11-27 10:18:08',2,0.019094,0,'Action completed, no processing required'),(328,24,0,'2021-11-27 12:54:41',0,0,0,'Run mode: GLPI'),(329,24,328,'2021-11-27 12:54:41',2,0.00572896,0,'Action completed, no processing required'),(330,13,0,'2021-11-27 13:11:36',0,0,0,'Run mode: GLPI'),(331,13,330,'2021-11-27 13:11:36',2,0.00423694,0,'Action completed, no processing required'),(332,21,0,'2021-11-27 13:52:34',0,0,0,'Run mode: GLPI'),(333,21,332,'2021-11-27 13:52:34',2,0.00574803,0,'Action completed, no processing required'),(334,25,0,'2021-11-27 14:01:00',0,0,0,'Run mode: GLPI'),(335,25,334,'2021-11-27 14:01:00',2,0.00447679,0,'Action completed, no processing required'),(336,5,0,'2021-11-27 14:36:33',0,0,0,'Run mode: GLPI'),(337,5,336,'2021-11-27 14:36:33',2,0.00430822,0,'Action completed, no processing required'),(338,6,0,'2021-11-27 14:43:11',0,0,0,'Run mode: GLPI'),(339,6,338,'2021-11-27 14:43:11',2,0.0041461,0,'Action completed, no processing required'),(340,12,0,'2021-11-27 15:13:29',0,0,0,'Run mode: GLPI'),(341,12,340,'2021-11-27 15:13:29',1,0.00370193,2,'Clean 2 session files created since more than 1440 seconds\n'),(342,12,340,'2021-11-27 15:13:29',2,0.00731802,2,'Action completed, fully processed'),(343,15,0,'2021-11-27 15:19:01',0,0,0,'Run mode: GLPI'),(344,15,343,'2021-11-27 15:19:01',2,0.00518298,0,'Action completed, no processing required'),(345,16,0,'2021-11-27 15:43:23',0,0,0,'Run mode: GLPI'),(346,16,345,'2021-11-27 15:43:23',2,0.00422192,0,'Action completed, no processing required'),(347,18,0,'2021-11-27 16:02:09',0,0,0,'Run mode: GLPI'),(348,18,347,'2021-11-27 16:02:09',2,0.00822806,0,'Action completed, no processing required'),(349,17,0,'2021-11-27 16:15:41',0,0,0,'Run mode: GLPI'),(350,17,349,'2021-11-27 16:15:41',2,0.00495386,0,'Action completed, no processing required'),(351,32,0,'2021-11-27 16:53:22',0,0,0,'Run mode: GLPI'),(352,32,351,'2021-11-27 16:53:22',2,0.006001,0,'Action completed, no processing required'),(353,22,0,'2021-11-29 15:12:41',0,0,0,'Run mode: GLPI'),(354,22,353,'2021-11-29 15:12:41',2,0.0220518,0,'Action completed, no processing required'),(355,9,0,'2021-11-29 15:18:16',0,0,0,'Run mode: GLPI'),(356,9,355,'2021-11-29 15:18:16',2,0.029532,0,'Action completed, no processing required'),(357,14,0,'2021-11-29 15:41:50',0,0,0,'Run mode: GLPI'),(358,14,357,'2021-11-29 15:41:50',2,0.00621486,0,'Action completed, no processing required'),(359,19,0,'2021-11-29 15:46:51',0,0,0,'Run mode: GLPI'),(360,19,359,'2021-11-29 15:46:51',2,0.00602698,0,'Action completed, fully processed'),(361,23,0,'2021-11-29 16:06:45',0,0,0,'Run mode: GLPI'),(362,23,361,'2021-11-29 16:06:45',2,0.0060389,0,'Action completed, no processing required'),(363,20,0,'2021-11-29 16:14:26',0,0,0,'Run mode: GLPI'),(364,20,363,'2021-11-29 16:14:26',2,0.00480103,0,'Action completed, no processing required'),(365,24,0,'2021-11-29 16:19:51',0,0,0,'Run mode: GLPI'),(366,24,365,'2021-11-29 16:19:51',2,0.00786901,0,'Action completed, no processing required'),(367,21,0,'2021-11-29 16:46:27',0,0,0,'Run mode: GLPI'),(368,21,367,'2021-11-29 16:46:27',2,0.00602102,0,'Action completed, no processing required'),(369,13,0,'2021-11-29 16:53:05',0,0,0,'Run mode: GLPI'),(370,13,369,'2021-11-29 16:53:05',2,0.00576496,0,'Action completed, no processing required'),(371,17,0,'2021-11-29 16:58:07',0,0,0,'Run mode: GLPI'),(372,17,371,'2021-11-29 16:58:07',2,0.004498,0,'Action completed, no processing required'),(373,32,0,'2021-11-29 17:10:10',0,0,0,'Run mode: GLPI'),(374,32,373,'2021-11-29 17:10:10',2,0.00532889,0,'Action completed, no processing required'),(375,15,0,'2021-11-29 17:32:23',0,0,0,'Run mode: GLPI'),(376,15,375,'2021-11-29 17:32:23',2,0.00486398,0,'Action completed, no processing required'),(377,16,0,'2021-11-29 18:06:52',0,0,0,'Run mode: GLPI'),(378,16,377,'2021-11-29 18:06:52',2,0.00590801,0,'Action completed, no processing required'),(379,25,0,'2021-11-29 18:13:10',0,0,0,'Run mode: GLPI'),(380,25,379,'2021-11-29 18:13:10',2,0.00451112,0,'Action completed, no processing required'),(381,5,0,'2021-11-29 18:44:11',0,0,0,'Run mode: GLPI'),(382,5,381,'2021-11-29 18:44:11',2,0.00589681,0,'Action completed, no processing required'),(383,6,0,'2021-11-29 19:08:58',0,0,0,'Run mode: GLPI'),(384,6,383,'2021-11-29 19:08:58',2,0.00600505,0,'Action completed, no processing required'),(385,12,0,'2021-11-29 19:28:34',0,0,0,'Run mode: GLPI'),(386,12,385,'2021-11-29 19:28:34',1,0.00389385,1,'Clean 1 session file created since more than 1440 seconds\n'),(387,12,385,'2021-11-29 19:28:34',2,0.00868297,1,'Action completed, fully processed'),(388,18,0,'2021-11-29 21:25:56',0,0,0,'Run mode: GLPI'),(389,18,388,'2021-11-29 21:25:56',2,0.00799084,0,'Action completed, no processing required'),(390,22,0,'2021-11-30 15:49:05',0,0,0,'Run mode: GLPI'),(391,22,390,'2021-11-30 15:49:05',2,0.0218599,0,'Action completed, no processing required'),(392,9,0,'2021-11-30 16:01:44',0,0,0,'Run mode: GLPI'),(393,9,392,'2021-11-30 16:01:44',2,0.028681,0,'Action completed, no processing required'),(394,14,0,'2021-11-30 16:17:38',0,0,0,'Run mode: GLPI'),(395,14,394,'2021-11-30 16:17:38',2,0.00578594,0,'Action completed, no processing required'),(396,21,0,'2021-11-30 17:00:24',0,0,0,'Run mode: GLPI'),(397,21,396,'2021-11-30 17:00:24',2,0.00546408,0,'Action completed, no processing required'),(398,17,0,'2021-11-30 17:05:43',0,0,0,'Run mode: GLPI'),(399,17,398,'2021-11-30 17:05:43',2,0.00473523,0,'Action completed, no processing required'),(400,20,0,'2021-11-30 17:12:00',0,0,0,'Run mode: GLPI'),(401,20,400,'2021-11-30 17:12:00',2,0.0057199,0,'Action completed, no processing required'),(402,32,0,'2021-11-30 17:37:12',0,0,0,'Run mode: GLPI'),(403,32,402,'2021-11-30 17:37:12',2,0.0049789,0,'Action completed, no processing required'),(404,24,0,'2021-11-30 18:04:22',0,0,0,'Run mode: GLPI'),(405,24,404,'2021-11-30 18:04:22',2,0.0058279,0,'Action completed, no processing required'),(406,13,0,'2021-11-30 18:09:37',0,0,0,'Run mode: GLPI'),(407,13,406,'2021-11-30 18:09:37',2,0.00475883,0,'Action completed, no processing required'),(408,15,0,'2021-11-30 18:56:13',0,0,0,'Run mode: GLPI'),(409,15,408,'2021-11-30 18:56:13',2,0.00585508,0,'Action completed, no processing required'),(410,16,0,'2021-11-30 19:04:13',0,0,0,'Run mode: GLPI'),(411,16,410,'2021-11-30 19:04:13',2,0.00499511,0,'Action completed, no processing required'),(412,19,0,'2021-11-30 19:48:47',0,0,0,'Run mode: GLPI'),(413,19,412,'2021-11-30 19:48:47',2,0.00592208,0,'Action completed, fully processed'),(414,22,0,'2021-11-30 20:41:29',0,0,0,'Run mode: GLPI'),(415,22,414,'2021-11-30 20:41:29',2,0.00622892,0,'Action completed, no processing required'),(416,23,0,'2021-11-30 20:57:10',0,0,0,'Run mode: GLPI'),(417,23,416,'2021-11-30 20:57:10',2,0.00617886,0,'Action completed, no processing required'),(418,9,0,'2021-12-01 15:28:31',0,0,0,'Run mode: GLPI'),(419,9,418,'2021-12-01 15:28:31',2,0.0367858,0,'Action completed, no processing required'),(420,21,0,'2021-12-01 15:57:39',0,0,0,'Run mode: GLPI'),(421,21,420,'2021-12-01 15:57:39',2,0.00531888,0,'Action completed, no processing required'),(422,17,0,'2021-12-01 16:03:20',0,0,0,'Run mode: GLPI'),(423,17,422,'2021-12-01 16:03:20',2,0.00638509,0,'Action completed, no processing required'),(424,14,0,'2021-12-01 16:08:25',0,0,0,'Run mode: GLPI'),(425,14,424,'2021-12-01 16:08:25',2,0.00557089,0,'Action completed, no processing required'),(426,32,0,'2021-12-01 18:02:40',0,0,0,'Run mode: GLPI'),(427,32,426,'2021-12-01 18:02:40',2,0.00644493,0,'Action completed, no processing required'),(428,20,0,'2021-12-01 18:13:32',0,0,0,'Run mode: GLPI'),(429,20,428,'2021-12-01 18:13:32',2,0.00669003,0,'Action completed, no processing required'),(430,25,0,'2021-12-01 18:33:31',0,0,0,'Run mode: GLPI'),(431,25,430,'2021-12-01 18:33:31',2,0.00590086,0,'Action completed, no processing required'),(432,5,0,'2021-12-01 19:01:17',0,0,0,'Run mode: GLPI'),(433,5,432,'2021-12-01 19:01:17',2,0.00552702,0,'Action completed, no processing required'),(434,24,0,'2021-12-01 20:27:25',0,0,0,'Run mode: GLPI'),(435,24,434,'2021-12-01 20:27:25',2,0.00455403,0,'Action completed, no processing required'),(436,6,0,'2021-12-01 21:05:19',0,0,0,'Run mode: GLPI'),(437,6,436,'2021-12-01 21:05:19',2,0.00563002,0,'Action completed, no processing required'),(438,13,0,'2021-12-01 21:12:42',0,0,0,'Run mode: GLPI'),(439,13,438,'2021-12-01 21:12:42',2,0.00573802,0,'Action completed, no processing required'),(440,12,0,'2021-12-02 15:56:36',0,0,0,'Run mode: GLPI'),(441,12,440,'2021-12-02 15:56:36',2,0.0185039,0,'Action completed, no processing required'),(442,22,0,'2021-12-04 12:33:24',0,0,0,'Run mode: GLPI'),(443,22,442,'2021-12-04 12:33:24',2,0.0366812,0,'Action completed, no processing required'),(444,18,0,'2021-12-04 13:29:34',0,0,0,'Run mode: GLPI'),(445,18,444,'2021-12-04 13:29:34',2,0.00763798,0,'Action completed, no processing required'),(446,15,0,'2021-12-04 14:29:09',0,0,0,'Run mode: GLPI'),(447,15,446,'2021-12-04 14:29:09',2,0.00519395,0,'Action completed, no processing required'),(448,16,0,'2021-12-04 14:35:05',0,0,0,'Run mode: GLPI'),(449,16,448,'2021-12-04 14:35:05',2,0.00419188,0,'Action completed, no processing required'),(450,9,0,'2021-12-04 16:02:55',0,0,0,'Run mode: GLPI'),(451,9,450,'2021-12-04 16:02:55',2,0.026427,0,'Action completed, no processing required'),(452,21,0,'2021-12-04 16:10:10',0,0,0,'Run mode: GLPI'),(453,21,452,'2021-12-04 16:10:10',2,0.00427198,0,'Action completed, no processing required'),(454,17,0,'2021-12-04 16:26:59',0,0,0,'Run mode: GLPI'),(455,17,454,'2021-12-04 16:26:59',2,0.00988793,0,'Action completed, no processing required'),(456,14,0,'2021-12-04 16:38:50',0,0,0,'Run mode: GLPI'),(457,14,456,'2021-12-04 16:38:50',2,0.00604081,0,'Action completed, no processing required'),(458,32,0,'2021-12-04 17:15:08',0,0,0,'Run mode: GLPI'),(459,32,458,'2021-12-04 17:15:08',2,0.00589585,0,'Action completed, no processing required'),(460,20,0,'2021-12-04 17:20:09',0,0,0,'Run mode: GLPI'),(461,20,460,'2021-12-04 17:20:09',2,0.00588799,0,'Action completed, no processing required'),(462,19,0,'2021-12-06 16:38:23',0,0,0,'Run mode: GLPI'),(463,19,462,'2021-12-06 16:38:23',2,0.0210979,0,'Action completed, fully processed'),(464,23,0,'2021-12-06 16:43:55',0,0,0,'Run mode: GLPI'),(465,23,464,'2021-12-06 16:43:55',2,0.00586104,0,'Action completed, no processing required'),(466,24,0,'2021-12-06 16:49:36',0,0,0,'Run mode: GLPI'),(467,24,466,'2021-12-06 16:49:36',2,0.00460315,0,'Action completed, no processing required'),(468,13,0,'2021-12-06 21:05:53',0,0,0,'Run mode: GLPI'),(469,13,468,'2021-12-06 21:05:53',2,0.00459814,0,'Action completed, no processing required'),(470,25,0,'2021-12-07 16:44:31',0,0,0,'Run mode: GLPI'),(471,25,470,'2021-12-07 16:44:31',2,0.0189362,0,'Action completed, no processing required'),(472,5,0,'2021-12-09 17:57:39',0,0,0,'Run mode: GLPI'),(473,5,472,'2021-12-09 17:57:39',2,0.0298421,0,'Action completed, no processing required'),(474,6,0,'2021-12-09 18:25:05',0,0,0,'Run mode: GLPI'),(475,6,474,'2021-12-09 18:25:05',2,0.00515103,0,'Action completed, no processing required'),(476,12,0,'2021-12-13 17:26:42',0,0,0,'Run mode: GLPI'),(477,12,476,'2021-12-13 17:26:42',1,0.02705,5,'Clean 5 session files created since more than 1440 seconds\n'),(478,12,476,'2021-12-13 17:26:42',2,0.03176,5,'Action completed, fully processed'),(479,22,0,'2021-12-13 18:13:43',0,0,0,'Run mode: GLPI'),(480,22,479,'2021-12-13 18:13:43',2,0.00666904,0,'Action completed, no processing required'),(481,9,0,'2021-12-13 18:21:07',0,0,0,'Run mode: GLPI'),(482,9,481,'2021-12-13 18:21:07',2,0.022999,0,'Action completed, no processing required'),(483,21,0,'2021-12-13 18:38:44',0,0,0,'Run mode: GLPI'),(484,21,483,'2021-12-13 18:38:44',2,0.00455308,0,'Action completed, no processing required'),(485,17,0,'2021-12-13 19:00:16',0,0,0,'Run mode: GLPI'),(486,17,485,'2021-12-13 19:00:16',2,0.00582409,0,'Action completed, no processing required'),(487,32,0,'2021-12-13 19:38:11',0,0,0,'Run mode: GLPI'),(488,32,487,'2021-12-13 19:38:11',2,0.00611591,0,'Action completed, no processing required'),(489,14,0,'2021-12-13 19:49:26',0,0,0,'Run mode: GLPI'),(490,14,489,'2021-12-13 19:49:26',2,0.00591111,0,'Action completed, no processing required'),(491,20,0,'2021-12-13 19:55:18',0,0,0,'Run mode: GLPI'),(492,20,491,'2021-12-13 19:55:18',2,0.00528502,0,'Action completed, no processing required'),(493,15,0,'2021-12-13 20:11:43',0,0,0,'Run mode: GLPI'),(494,15,493,'2021-12-13 20:11:43',2,0.00525999,0,'Action completed, no processing required'),(495,16,0,'2021-12-13 20:19:34',0,0,0,'Run mode: GLPI'),(496,16,495,'2021-12-13 20:19:34',2,0.00618315,0,'Action completed, no processing required'),(497,18,0,'2021-12-13 20:27:55',0,0,0,'Run mode: GLPI'),(498,18,497,'2021-12-13 20:27:55',2,0.00739408,0,'Action completed, no processing required'),(499,24,0,'2021-12-13 20:33:08',0,0,0,'Run mode: GLPI'),(500,24,499,'2021-12-13 20:33:08',2,0.00440311,0,'Action completed, no processing required'),(501,13,0,'2021-12-13 20:58:23',0,0,0,'Run mode: GLPI'),(502,13,501,'2021-12-13 20:58:23',2,0.00581098,0,'Action completed, no processing required'),(503,19,0,'2021-12-13 21:19:20',0,0,0,'Run mode: GLPI'),(504,19,503,'2021-12-13 21:19:20',2,0.00677919,0,'Action completed, fully processed'),(505,23,0,'2021-12-13 21:40:08',0,0,0,'Run mode: GLPI'),(506,23,505,'2021-12-13 21:40:08',2,0.00639701,0,'Action completed, no processing required'),(507,25,0,'2021-12-14 15:37:45',0,0,0,'Run mode: GLPI'),(508,25,507,'2021-12-14 15:37:45',2,0.0297439,0,'Action completed, no processing required');

--
-- Table structure for table `glpi_crontasks`
--

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

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

INSERT INTO `glpi_crontasks` VALUES (2,'CartridgeItem','cartridge',86400,10,0,1,3,0,24,30,NULL,NULL,NULL,NULL,NULL),(3,'ConsumableItem','consumable',86400,10,0,1,3,0,24,30,NULL,NULL,NULL,NULL,NULL),(4,'SoftwareLicense','software',86400,NULL,0,1,3,0,24,30,NULL,NULL,NULL,NULL,NULL),(5,'Contract','contract',86400,NULL,1,1,3,0,24,30,'2021-12-09 15:57:00',NULL,NULL,NULL,NULL),(6,'Infocom','infocom',86400,NULL,1,1,3,0,24,30,'2021-12-09 16:25:00',NULL,NULL,NULL,NULL),(7,'CronTask','logs',86400,30,0,1,3,0,24,30,NULL,NULL,NULL,NULL,NULL),(9,'MailCollector','mailgate',600,10,1,1,3,0,24,30,'2021-12-13 16:21:00',NULL,NULL,NULL,NULL),(10,'DBconnection','checkdbreplicate',300,NULL,0,1,3,0,24,30,NULL,NULL,NULL,NULL,NULL),(11,'CronTask','checkupdate',604800,NULL,0,1,3,0,24,30,NULL,NULL,NULL,NULL,NULL),(12,'CronTask','session',86400,NULL,1,1,3,0,24,30,'2021-12-13 15:26:00',NULL,NULL,NULL,NULL),(13,'CronTask','graph',3600,NULL,1,1,3,0,24,30,'2021-12-13 18:58:00',NULL,NULL,NULL,NULL),(14,'ReservationItem','reservation',3600,NULL,1,1,3,0,24,30,'2021-12-13 17:49:00',NULL,NULL,NULL,NULL),(15,'Ticket','closeticket',43200,NULL,1,1,3,0,24,30,'2021-12-13 18:11:00',NULL,NULL,NULL,NULL),(16,'Ticket','alertnotclosed',43200,NULL,1,1,3,0,24,30,'2021-12-13 18:19:00',NULL,NULL,NULL,NULL),(17,'SlaLevel_Ticket','slaticket',300,NULL,1,1,3,0,24,30,'2021-12-13 17:00:00',NULL,NULL,NULL,NULL),(18,'Ticket','createinquest',86400,NULL,1,1,3,0,24,30,'2021-12-13 18:27:00',NULL,NULL,NULL,NULL),(19,'CronTask','watcher',86400,NULL,1,1,3,0,24,30,'2021-12-13 19:19:00',NULL,NULL,NULL,NULL),(20,'TicketRecurrent','ticketrecurrent',3600,NULL,1,1,3,0,24,30,'2021-12-13 17:55:00',NULL,NULL,NULL,NULL),(21,'PlanningRecall','planningrecall',300,NULL,1,1,3,0,24,30,'2021-12-13 16:38:00',NULL,NULL,NULL,NULL),(22,'QueuedNotification','queuednotification',60,50,1,1,3,0,24,30,'2021-12-13 16:13:00',NULL,NULL,NULL,NULL),(23,'QueuedNotification','queuednotificationclean',86400,30,1,1,3,0,24,30,'2021-12-13 19:40:00',NULL,NULL,NULL,NULL),(24,'CronTask','temp',3600,NULL,1,1,3,0,24,30,'2021-12-13 18:33:00',NULL,NULL,NULL,NULL),(25,'MailCollector','mailgateerror',86400,NULL,1,1,3,0,24,30,'2021-12-14 13:37:00',NULL,NULL,NULL,NULL),(26,'CronTask','circularlogs',86400,4,0,1,3,0,24,30,NULL,NULL,NULL,NULL,NULL),(27,'ObjectLock','unlockobject',86400,4,0,1,3,0,24,30,NULL,NULL,NULL,NULL,NULL),(28,'SavedSearch','countAll',604800,NULL,0,1,3,0,24,10,NULL,NULL,NULL,NULL,NULL),(29,'SavedSearch_Alert','savedsearchesalerts',86400,NULL,0,1,3,0,24,10,NULL,NULL,NULL,NULL,NULL),(30,'Telemetry','telemetry',2592000,NULL,0,1,3,0,24,10,NULL,NULL,NULL,NULL,NULL),(31,'Certificate','certificate',86400,NULL,0,1,3,0,24,10,NULL,NULL,NULL,NULL,NULL),(32,'OlaLevel_Ticket','olaticket',300,NULL,1,1,3,0,24,30,'2021-12-13 17:38:00',NULL,NULL,NULL,NULL),(33,'PurgeLogs','PurgeLogs',604800,24,1,2,3,0,24,30,NULL,NULL,NULL,NULL,NULL),(34,'Ticket','purgeticket',43200,NULL,0,1,3,0,24,30,NULL,NULL,NULL,NULL,NULL),(35,'Document','cleanorphans',43200,NULL,0,1,3,0,24,30,NULL,NULL,NULL,NULL,NULL),(36,'User','passwordexpiration',86400,100,0,2,3,0,24,30,NULL,NULL,NULL,NULL,NULL),(37,'Glpi\\Marketplace\\Controller','checkAllUpdates',86400,NULL,1,2,3,0,24,30,NULL,NULL,NULL,NULL,NULL),(38,'PluginOcsinventoryngThread','CleanOldThreads',3600,24,1,1,3,0,24,30,NULL,NULL,NULL,'2021-10-19 16:46:04','2021-10-19 16:46:04'),(39,'PluginOcsinventoryngOcsServer','ocsng',300,NULL,1,1,3,0,24,30,NULL,NULL,NULL,'2021-10-19 16:46:04','2021-10-19 16:46:04'),(40,'PluginOcsinventoryngNotimportedcomputer','SendAlerts',600,24,1,1,3,0,24,30,NULL,NULL,NULL,'2021-10-19 16:46:04','2021-10-19 16:46:04'),(41,'PluginOcsinventoryngOcsServer','CleanOldAgents',86400,NULL,0,1,3,0,24,30,NULL,NULL,NULL,'2021-10-19 16:46:04','2021-10-19 16:46:04'),(42,'PluginOcsinventoryngOcsServer','RestoreOldAgents',86400,NULL,0,1,3,0,24,30,NULL,NULL,NULL,'2021-10-19 16:46:04','2021-10-19 16:46:04'),(43,'PluginOcsinventoryngRuleImportEntity','CheckRuleImportEntity',86400,NULL,0,1,3,0,24,30,NULL,NULL,NULL,'2021-10-19 16:46:04','2021-10-19 16:46:04'),(44,'PluginOcsinventoryngOcsAlert','SynchroAlert',86400,NULL,0,1,3,0,24,30,NULL,NULL,NULL,'2021-10-19 16:46:04','2021-10-19 16:46:04'),(45,'PluginOcsinventoryngOcsAlert','AlertNewComputers',3600,NULL,0,1,3,0,24,30,NULL,NULL,NULL,'2021-10-19 16:46:04','2021-10-19 16:46:04'),(46,'PluginTypologyTypology','UpdateTypology',86400,NULL,1,1,3,0,24,30,NULL,NULL,NULL,'2021-10-20 21:27:47','2021-10-20 21:27:47'),(47,'PluginTypologyTypology','NotValidated',86400,NULL,1,1,3,0,24,30,NULL,NULL,NULL,'2021-10-20 21:27:47','2021-10-20 21:27:47');

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

CREATE TABLE `glpi_dashboards_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dashboards_dashboards_id` int(11) NOT NULL,
  `gridstack_id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `card_id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `x` int(11) DEFAULT NULL,
  `y` int(11) DEFAULT NULL,
  `width` int(11) DEFAULT NULL,
  `height` int(11) DEFAULT NULL,
  `card_options` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dashboards_dashboards_id` (`dashboards_dashboards_id`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

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

CREATE TABLE `glpi_dashboards_rights` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dashboards_dashboards_id` int(11) NOT NULL,
  `itemtype` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `items_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`dashboards_dashboards_id`,`itemtype`,`items_id`),
  KEY `dashboards_dashboards_id` (`dashboards_dashboards_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_datacenters` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `locations_id` int(11) NOT NULL DEFAULT 0,
  `is_deleted` tinyint(1) 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 `is_recursive` (`is_recursive`),
  KEY `locations_id` (`locations_id`),
  KEY `is_deleted` (`is_deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_dcrooms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `locations_id` int(11) NOT NULL DEFAULT 0,
  `vis_cols` int(11) DEFAULT NULL,
  `vis_rows` int(11) DEFAULT NULL,
  `blueprint` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `datacenters_id` int(11) NOT NULL DEFAULT 0,
  `is_deleted` tinyint(1) 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 `is_recursive` (`is_recursive`),
  KEY `locations_id` (`locations_id`),
  KEY `datacenters_id` (`datacenters_id`),
  KEY `is_deleted` (`is_deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicebatteries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `manufacturers_id` int(11) NOT NULL DEFAULT 0,
  `voltage` int(11) DEFAULT NULL,
  `capacity` int(11) DEFAULT NULL,
  `devicebatterytypes_id` int(11) NOT NULL DEFAULT 0,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `devicebatterymodels_id` int(11) DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicebatterymodels_id` (`devicebatterymodels_id`),
  KEY `devicebatterytypes_id` (`devicebatterytypes_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicebatterymodels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicebatterytypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicecasemodels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicecases` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `devicecasetypes_id` int(11) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `manufacturers_id` int(11) NOT NULL DEFAULT 0,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `devicecasemodels_id` int(11) DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `devicecasetypes_id` (`devicecasetypes_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicecasemodels_id` (`devicecasemodels_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicecasetypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicecontrolmodels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicecontrols` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_raid` tinyint(1) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `manufacturers_id` int(11) NOT NULL DEFAULT 0,
  `interfacetypes_id` int(11) NOT NULL DEFAULT 0,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `devicecontrolmodels_id` int(11) DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `interfacetypes_id` (`interfacetypes_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicecontrolmodels_id` (`devicecontrolmodels_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `glpi_devicecontrols` VALUES (1,'Standard SATA AHCI Controller',0,'Standard SATA AHCI Controller',3,0,0,0,NULL,'2021-10-19 20:59:24','2021-10-19 20:59:24'),(2,'Microsoft Storage Spaces Controller',0,'Microsoft Storage Spaces Controller',4,0,0,0,NULL,'2021-10-19 20:59:24','2021-10-19 20:59:24'),(3,'AMD USB 3.0 eXtensible Host Controller - 1.0 (Microsoft)',0,'USB xHCI Compliant Host Controller',5,0,0,0,NULL,'2021-10-19 20:59:24','2021-10-19 20:59:24'),(4,'Standard Enhanced PCI to USB Host Controller',0,'Standard Enhanced PCI to USB Host Controller',6,0,0,0,NULL,'2021-10-19 20:59:24','2021-10-19 20:59:24'),(5,'Standard NVM Express Controller',0,'Standard NVM Express Controller',8,0,0,0,NULL,'2021-10-20 15:19:29','2021-10-20 15:19:29'),(6,'Microsoft VHD Loopback Controller',0,'Microsoft VHD Loopback Controller',4,0,0,0,NULL,'2021-10-20 15:19:29','2021-10-20 15:19:29'),(7,'AMD USB 3.10 eXtensible Host Controller - 1.10 (Microsoft)',0,'USB xHCI Compliant Host Controller',5,0,0,0,NULL,'2021-10-20 15:19:29','2021-10-20 15:19:29'),(8,'Intel(R) Chipset SATA/PCIe RST Premium Controller',0,'Intel(R) Chipset SATA/PCIe RST Premium Controller',13,0,0,0,NULL,'2021-10-21 09:31:32','2021-10-21 09:31:32'),(9,'Intel(R) USB 3.0 eXtensible Host Controller - 1.0 (Microsoft)',0,'USB xHCI Compliant Host Controller',5,0,0,0,NULL,'2021-10-21 09:31:32','2021-10-21 09:31:32'),(10,'Intel(R) 7 Series/C216 Chipset Family USB Enhanced Host Controller - 1E2D',0,'Intel(R) 7 Series/C216 Chipset Family USB Enhanced Host Controller - 1E2D',14,0,0,0,NULL,'2021-10-21 09:31:32','2021-10-21 09:31:32'),(11,'Intel(R) 7 Series/C216 Chipset Family USB Enhanced Host Controller - 1E26',0,'Intel(R) 7 Series/C216 Chipset Family USB Enhanced Host Controller - 1E26',14,0,0,0,NULL,'2021-10-21 09:31:32','2021-10-21 09:31:32'),(12,'AMD SATA Controller',0,'AMD SATA Controller',43,0,0,0,NULL,'2021-11-01 18:30:04','2021-11-01 18:30:04'),(13,'Intel(R) USB 3.10 eXtensible Host Controller - 1.10 (Microsoft)',0,'USB xHCI Compliant Host Controller',5,0,0,0,NULL,'2021-12-13 20:33:14','2021-12-13 20:33:14');

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

CREATE TABLE `glpi_devicedrivemodels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicedrives` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_writer` tinyint(1) NOT NULL DEFAULT 1,
  `speed` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `manufacturers_id` int(11) NOT NULL DEFAULT 0,
  `interfacetypes_id` int(11) NOT NULL DEFAULT 0,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `devicedrivemodels_id` int(11) DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `interfacetypes_id` (`interfacetypes_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicedrivemodels_id` (`devicedrivemodels_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `glpi_devicedrives` VALUES (1,'TOSHIBA TransMemory USB Device',1,NULL,NULL,0,0,0,0,NULL,'2021-10-19 20:59:24','2021-10-19 20:59:24'),(2,'hp DVDRW DA8AESH USB Device',1,NULL,NULL,0,0,0,0,NULL,'2021-10-20 15:19:29','2021-10-20 15:19:29'),(3,'NA',1,NULL,NULL,0,0,0,0,NULL,'2021-10-20 15:25:19','2021-10-20 15:25:19'),(4,'HL-DT-ST DVD+-RW GTA0N',1,NULL,NULL,0,0,0,0,NULL,'2021-10-21 09:31:32','2021-10-21 09:31:32'),(5,'Kingston DT Elite G2 USB Device',1,NULL,NULL,0,0,0,0,NULL,'2021-10-21 15:39:59','2021-10-21 15:39:59'),(6,'hp DVDRW DA8AESH',1,NULL,NULL,0,0,0,0,NULL,'2021-11-01 18:30:04','2021-11-01 18:30:04'),(7,'hp DVDRW GUE1N',1,NULL,NULL,0,0,0,0,NULL,'2021-12-13 19:00:21','2021-12-13 19:00:21');

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

CREATE TABLE `glpi_devicefirmwaremodels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `glpi_devicefirmwaremodels` VALUES (1,'81D6','',NULL),(2,'HP Laptop 15-db1xxx','',NULL),(3,'AGS-W09','',NULL),(4,'SM-N950F','',NULL),(5,'Latitude E5530 non-vPro','',NULL),(6,'HP Laptop 15-bw0xx','',NULL),(7,'HP 255 G6 Notebook PC','',NULL),(8,'HP Laptop 15-dw2xxx','',NULL);

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

CREATE TABLE `glpi_devicefirmwares` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `manufacturers_id` int(11) NOT NULL DEFAULT 0,
  `date` date DEFAULT NULL,
  `version` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `devicefirmwaretypes_id` int(11) NOT NULL DEFAULT 0,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `devicefirmwaremodels_id` int(11) DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicefirmwaremodels_id` (`devicefirmwaremodels_id`),
  KEY `devicefirmwaretypes_id` (`devicefirmwaretypes_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `glpi_devicefirmwares` VALUES (1,'8UCN09WW','27/07/2018 - No Asset Tag',1,NULL,NULL,4,0,0,1,'2021-10-19 20:59:24','2021-10-19 20:59:24'),(2,'F.14','07/10/2019 - Chassis Asset Tag',7,NULL,NULL,4,0,0,2,'2021-10-20 15:19:29','2021-10-20 15:19:29'),(3,'unknown','07/14/20 - HUAWEIAGS-W09-0123456789',9,NULL,NULL,5,0,0,3,'2021-10-20 15:25:19','2021-10-20 15:25:19'),(4,'N950FXXSGDUG6','07/15/21 - PPR1.180610.011-0123456789',10,NULL,NULL,5,0,0,4,'2021-10-20 15:27:49','2021-10-20 15:27:49'),(5,'A12','07/08/2013 - ',11,NULL,NULL,6,0,0,5,'2021-10-21 09:31:32','2021-10-21 09:31:32'),(6,'8UCN13WW','23/04/2019 - No Asset Tag',1,NULL,NULL,4,0,0,1,'2021-10-27 17:57:34','2021-10-27 17:57:34'),(7,'F.20','01/11/2017 - Chassis Asset Tag',7,NULL,NULL,4,0,0,6,'2021-11-01 18:30:04','2021-11-01 18:30:04'),(8,'F.11','05/07/2017 - Chassis Asset Tag',7,NULL,NULL,4,0,0,6,'2021-12-09 18:26:47','2021-12-09 18:26:47'),(9,'F.13','07/09/2017 - Chassis Asset Tag',7,NULL,NULL,4,0,0,6,'2021-12-13 18:15:19','2021-12-13 18:15:19'),(10,'F.31','25/07/2018 - Chassis Asset Tag',7,NULL,NULL,4,0,0,7,'2021-12-13 19:00:21','2021-12-13 19:00:21'),(11,'F.33','08/10/2020 - Chassis Asset Tag',7,NULL,NULL,4,0,0,8,'2021-12-13 20:33:14','2021-12-13 20:33:14');

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

CREATE TABLE `glpi_devicefirmwaretypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `glpi_devicefirmwaretypes` VALUES (1,'BIOS',NULL,NULL,NULL),(2,'UEFI',NULL,NULL,NULL),(3,'Firmware',NULL,NULL,NULL),(4,'Notebook','','2021-10-19 20:59:24','2021-10-19 20:59:24'),(5,'Mobile','','2021-10-20 15:25:19','2021-10-20 15:25:19'),(6,'LapTop','','2021-10-21 09:31:32','2021-10-21 09:31:32');

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

CREATE TABLE `glpi_devicegenericmodels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicegenerics` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `devicegenerictypes_id` int(11) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `manufacturers_id` int(11) NOT NULL DEFAULT 0,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `locations_id` int(11) NOT NULL DEFAULT 0,
  `states_id` int(11) NOT NULL DEFAULT 0,
  `devicegenericmodels_id` int(11) DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `devicegenerictypes_id` (`devicegenerictypes_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `locations_id` (`locations_id`),
  KEY `states_id` (`states_id`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicegenericmodels_id` (`devicegenericmodels_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicegenerictypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicegraphiccardmodels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicegraphiccards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `interfacetypes_id` int(11) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `manufacturers_id` int(11) NOT NULL DEFAULT 0,
  `memory_default` int(11) NOT NULL DEFAULT 0,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `devicegraphiccardmodels_id` int(11) DEFAULT NULL,
  `chipset` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `interfacetypes_id` (`interfacetypes_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `chipset` (`chipset`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicegraphiccardmodels_id` (`devicegraphiccardmodels_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `glpi_devicegraphiccards` VALUES (1,'AMD Radeon(TM) R3 Graphics',0,NULL,0,512,0,0,NULL,NULL,'2021-10-19 20:59:24','2021-10-19 20:59:24'),(2,'AMD Radeon(TM) Vega 3 Graphics',0,NULL,0,2048,0,0,NULL,NULL,'2021-10-20 15:19:29','2021-10-20 15:19:29'),(3,'Embedded display',0,NULL,0,0,0,0,NULL,NULL,'2021-10-20 15:25:19','2021-10-20 15:25:19'),(4,'Intel(R) HD Graphics 4000',0,NULL,0,2112,0,0,NULL,NULL,'2021-10-21 09:31:32','2021-10-21 09:31:32'),(5,'AMD Radeon(TM) R5 Graphics',0,NULL,0,512,0,0,NULL,NULL,'2021-12-13 18:15:19','2021-12-13 18:15:19'),(6,'AMD Radeon (TM) R5 M330',0,NULL,0,2048,0,0,NULL,NULL,'2021-12-13 18:15:19','2021-12-13 18:15:19'),(7,'AMD Radeon(TM) R4 Graphics',0,NULL,0,80,0,0,NULL,NULL,'2021-12-13 19:00:21','2021-12-13 19:00:21'),(8,'Intel(R) UHD Graphics',0,NULL,0,1024,0,0,NULL,NULL,'2021-12-13 20:33:14','2021-12-13 20:33:14');

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

CREATE TABLE `glpi_deviceharddrivemodels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_deviceharddrives` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `rpm` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `interfacetypes_id` int(11) NOT NULL DEFAULT 0,
  `cache` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `manufacturers_id` int(11) NOT NULL DEFAULT 0,
  `capacity_default` int(11) NOT NULL DEFAULT 0,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `deviceharddrivemodels_id` int(11) DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `interfacetypes_id` (`interfacetypes_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `deviceharddrivemodels_id` (`deviceharddrivemodels_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `glpi_deviceharddrives` VALUES (1,'HFS128G32TNF-N3A0A',NULL,0,NULL,NULL,0,122103,0,0,NULL,'2021-10-19 20:59:24','2021-10-19 20:59:24'),(2,'MTFDHBA256TCK-1AS1AABHA',NULL,0,NULL,NULL,0,244191,0,0,NULL,'2021-10-20 15:19:29','2021-10-20 15:19:29'),(3,'Samsung SSD 860 EVO 250GB',NULL,0,NULL,NULL,0,238472,0,0,NULL,'2021-10-21 09:31:32','2021-10-21 09:31:32'),(4,'WDC WDS240G2G0B-00EPW0',NULL,0,NULL,NULL,0,228934,0,0,NULL,'2021-11-01 18:30:04','2021-11-01 18:30:04'),(5,'SanDisk SD8SN8U-128G-1006',NULL,0,NULL,NULL,0,122103,0,0,NULL,'2021-12-09 18:26:47','2021-12-09 18:26:47'),(6,'SanDisk SD8SNAT-256G-1006',NULL,0,NULL,NULL,0,244191,0,0,NULL,'2021-12-13 18:15:19','2021-12-13 18:15:19'),(7,'SAMSUNG MZNLN256HAJQ-000H1',NULL,0,NULL,NULL,0,244191,0,0,NULL,'2021-12-13 19:00:21','2021-12-13 19:00:21'),(8,'SK hynix BC511 HFM256GDJTNI-82A0A',NULL,0,NULL,NULL,0,244191,0,0,NULL,'2021-12-13 20:33:14','2021-12-13 20:33:14');

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

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

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

INSERT INTO `glpi_devicememories` VALUES (1,'CHANNEL A (No ECC)','2133',NULL,0,4096,5,0,0,NULL,'2021-10-19 20:59:24','2021-10-19 20:59:24'),(2,'P0 CHANNEL A (No ECC)','2400',NULL,0,8192,5,0,0,NULL,'2021-10-20 15:19:29','2021-10-20 15:19:29'),(3,'P0 CHANNEL B (No ECC)','2400',NULL,0,4096,5,0,0,NULL,'2021-10-20 15:19:29','2021-10-20 15:19:29'),(4,'Top Slot (No ECC)','1600',NULL,0,4096,0,0,0,NULL,'2021-10-21 09:31:32','2021-10-21 09:31:32'),(5,'Bottom Slot (No ECC)','1600',NULL,0,4096,0,0,0,NULL,'2021-10-21 09:31:32','2021-10-21 09:31:32'),(6,'CHANNEL A (No ECC)','1866',NULL,0,4096,5,0,0,NULL,'2021-11-01 18:30:04','2021-11-01 18:30:04'),(7,'Empty slot - Πίνακας φυσικής μνήμης','1866',NULL,0,0,6,0,0,NULL,'2021-12-13 19:00:21','2021-12-13 19:00:21'),(8,'BANK 0 (No ECC)','3200',NULL,0,8192,5,0,0,NULL,'2021-12-13 20:33:14','2021-12-13 20:33:14'),(9,'Empty slot - Πίνακας φυσικής μνήμης','3200',NULL,0,0,6,0,0,NULL,'2021-12-13 20:33:14','2021-12-13 20:33:14');

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

CREATE TABLE `glpi_devicememorymodels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicememorytypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `glpi_devicememorytypes` VALUES (1,'EDO',NULL,NULL,NULL),(2,'DDR',NULL,NULL,NULL),(3,'SDRAM',NULL,NULL,NULL),(4,'SDRAM-2',NULL,NULL,NULL),(5,'Unknown','','2021-10-19 20:59:24','2021-10-19 20:59:24'),(6,'Empty slot','','2021-12-13 19:00:21','2021-12-13 19:00:21');

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

CREATE TABLE `glpi_devicemotherboardmodels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicemotherboards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `chipset` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `manufacturers_id` int(11) NOT NULL DEFAULT 0,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `devicemotherboardmodels_id` int(11) DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicemotherboardmodels_id` (`devicemotherboardmodels_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicenetworkcardmodels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicenetworkcards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bandwidth` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `manufacturers_id` int(11) NOT NULL DEFAULT 0,
  `mac_default` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `devicenetworkcardmodels_id` int(11) DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicenetworkcardmodels_id` (`devicenetworkcardmodels_id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `glpi_devicenetworkcards` VALUES (1,'Realtek PCIe FE Family Controller','100',NULL,0,NULL,0,0,NULL,'2021-10-19 20:59:24','2021-10-19 20:59:24'),(2,'Bluetooth Device (Personal Area Network)','3',NULL,0,NULL,0,0,NULL,'2021-10-19 20:59:24','2021-10-19 20:59:24'),(3,'WAN Miniport (PPPOE)',NULL,NULL,0,NULL,0,0,NULL,'2021-10-19 20:59:24','2021-10-19 20:59:24'),(4,'Microsoft Wi-Fi Direct Virtual Adapter-WFP Native MAC Layer LightWeight Filter-0000',NULL,NULL,0,NULL,0,0,NULL,'2021-10-19 20:59:24','2021-10-19 20:59:24'),(5,'Microsoft Wi-Fi Direct Virtual Adapter #2-WFP Native MAC Layer LightWeight Filter-0000',NULL,NULL,0,NULL,0,0,NULL,'2021-10-19 20:59:24','2021-10-19 20:59:24'),(6,'Realtek 8821CE Wireless LAN 802.11ac PCI-E NIC','150',NULL,0,NULL,0,0,NULL,'2021-10-19 20:59:24','2021-10-19 20:59:24'),(7,'TAP-Windows Adapter V9-WFP Native MAC Layer LightWeight Filter-0000','100',NULL,0,NULL,0,0,NULL,'2021-10-20 15:19:29','2021-10-20 15:19:29'),(8,'Realtek PCIe GbE Family Controller','100',NULL,0,NULL,0,0,NULL,'2021-10-20 15:19:29','2021-10-20 15:19:29'),(9,'Hyper-V Virtual Ethernet Adapter','1000',NULL,0,NULL,0,0,NULL,'2021-10-20 15:19:29','2021-10-20 15:19:29'),(10,'Hyper-V Virtual Ethernet Adapter #2','1000',NULL,0,NULL,0,0,NULL,'2021-10-20 15:19:29','2021-10-20 15:19:29'),(11,'Hyper-V Virtual Ethernet Adapter #3','1000',NULL,0,NULL,0,0,NULL,'2021-10-20 15:19:29','2021-10-20 15:19:29'),(12,'Hyper-V Virtual Ethernet Adapter #4','1000',NULL,0,NULL,0,0,NULL,'2021-10-20 15:19:29','2021-10-20 15:19:29'),(13,'Hyper-V Virtual Ethernet Adapter #5','1000',NULL,0,NULL,0,0,NULL,'2021-10-20 15:19:29','2021-10-20 15:19:29'),(14,'Realtek RTL8821CE 802.11ac PCIe Adapter-WFP Native MAC Layer LightWeight Filter-0000',NULL,NULL,0,NULL,0,0,NULL,'2021-10-20 15:19:29','2021-10-20 15:19:29'),(15,'Wifi/3G interface','150',NULL,0,NULL,0,0,NULL,'2021-10-20 15:25:19','2021-10-20 15:25:19'),(16,'Wifi/3G interface','115',NULL,0,NULL,0,0,NULL,'2021-10-20 15:27:49','2021-10-20 15:27:49'),(17,'Broadcom NetXtreme 57xx Gigabit Controller','100',NULL,0,NULL,0,0,NULL,'2021-10-21 09:31:32','2021-10-21 09:31:32'),(18,'Intel(R) Centrino(R) Advanced-N 6205-WFP Native MAC Layer LightWeight Filter-0000','130',NULL,0,NULL,0,0,NULL,'2021-10-21 09:31:32','2021-10-21 09:31:32'),(19,'Wifi/3G interface','144',NULL,0,NULL,0,0,NULL,'2021-10-21 09:34:56','2021-10-21 09:34:56'),(20,'Realtek PCIe FE Family Controller-WFP Native MAC Layer LightWeight Filter-0000','10',NULL,0,NULL,0,0,NULL,'2021-10-21 17:31:58','2021-10-21 17:31:58'),(21,'Realtek PCIe GbE Family Controller-WFP Native MAC Layer LightWeight Filter-0000','10',NULL,0,NULL,0,0,NULL,'2021-11-01 18:30:04','2021-11-01 18:30:04'),(22,'Bluetooth Device (Personal Area Network) #2','3',NULL,0,NULL,0,0,NULL,'2021-11-29 19:28:39','2021-11-29 19:28:39'),(23,'Microsoft Wi-Fi Direct Virtual Adapter #3-WFP Native MAC Layer LightWeight Filter-0000',NULL,NULL,0,NULL,0,0,NULL,'2021-11-29 19:28:39','2021-11-29 19:28:39'),(24,'Microsoft Wi-Fi Direct Virtual Adapter #4-WFP Native MAC Layer LightWeight Filter-0000',NULL,NULL,0,NULL,0,0,NULL,'2021-11-29 19:28:39','2021-11-29 19:28:39'),(25,'Realtek PCIe GbE Family Controller #2-WFP Native MAC Layer LightWeight Filter-0000','10',NULL,0,NULL,0,0,NULL,'2021-12-13 18:15:19','2021-12-13 18:15:19'),(26,'Bluetooth Device (Personal Area Network) #3','3',NULL,0,NULL,0,0,NULL,'2021-12-13 19:00:21','2021-12-13 19:00:21'),(27,'Microsoft Wi-Fi Direct Virtual Adapter #5-WFP Native MAC Layer LightWeight Filter-0000',NULL,NULL,0,NULL,0,0,NULL,'2021-12-13 19:00:21','2021-12-13 19:00:21'),(28,'Microsoft Wi-Fi Direct Virtual Adapter #6-WFP Native MAC Layer LightWeight Filter-0000',NULL,NULL,0,NULL,0,0,NULL,'2021-12-13 19:00:21','2021-12-13 19:00:21'),(29,'Intel(R) Dual Band Wireless-AC 3168','150',NULL,0,NULL,0,0,NULL,'2021-12-13 19:00:21','2021-12-13 19:00:21'),(30,'Realtek RTL8821CE 802.11ac PCIe Adapter','150',NULL,0,NULL,0,0,NULL,'2021-12-13 20:33:14','2021-12-13 20:33:14');

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

CREATE TABLE `glpi_devicepcimodels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicepcis` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `manufacturers_id` int(11) NOT NULL DEFAULT 0,
  `devicenetworkcardmodels_id` int(11) NOT NULL DEFAULT 0,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `devicepcimodels_id` int(11) DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `devicenetworkcardmodels_id` (`devicenetworkcardmodels_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicepcimodels_id` (`devicepcimodels_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicepowersupplies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `power` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_atx` tinyint(1) NOT NULL DEFAULT 1,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `manufacturers_id` int(11) NOT NULL DEFAULT 0,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `devicepowersupplymodels_id` int(11) DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicepowersupplymodels_id` (`devicepowersupplymodels_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicepowersupplymodels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_deviceprocessormodels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_deviceprocessors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `frequence` int(11) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `manufacturers_id` int(11) NOT NULL DEFAULT 0,
  `frequency_default` int(11) NOT NULL DEFAULT 0,
  `nbcores_default` int(11) DEFAULT NULL,
  `nbthreads_default` int(11) DEFAULT NULL,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `deviceprocessormodels_id` int(11) DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `deviceprocessormodels_id` (`deviceprocessormodels_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `glpi_deviceprocessors` VALUES (1,'AMD A4-9125 RADEON R3, 4 COMPUTE CORES 2C+2G',2300,NULL,2,2300,2,2,0,0,NULL,'2021-10-19 20:59:24','2021-10-19 20:59:24'),(2,'AMD Ryzen 3 3200U with Radeon Vega Mobile Gfx',2600,NULL,2,2600,2,4,0,0,NULL,'2021-10-20 15:19:29','2021-10-20 15:19:29'),(3,'Intel(R) Core(TM) i3-3120M CPU @ 2.50GHz',2000,NULL,12,2500,2,4,0,0,NULL,'2021-10-21 09:31:32','2021-10-21 09:31:32'),(4,'AMD A4-9120 RADEON R3, 4 COMPUTE CORES 2C+2G',2200,NULL,2,2200,2,2,0,0,NULL,'2021-11-01 18:30:04','2021-11-01 18:30:04'),(5,'AMD A9-9420 RADEON R5, 5 COMPUTE CORES 2C+3G',3000,NULL,2,3000,2,2,0,0,NULL,'2021-12-13 18:15:19','2021-12-13 18:15:19'),(6,'AMD A6-9225 RADEON R4, 5 COMPUTE CORES 2C+3G',2600,NULL,2,2600,2,2,0,0,NULL,'2021-12-13 19:00:21','2021-12-13 19:00:21'),(7,'Intel(R) Core(TM) i3-1005G1 CPU @ 1.20GHz',1190,NULL,12,1190,2,4,0,0,NULL,'2021-12-13 20:33:14','2021-12-13 20:33:14');

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

CREATE TABLE `glpi_devicesensormodels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicesensors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `devicesensortypes_id` int(11) NOT NULL DEFAULT 0,
  `devicesensormodels_id` int(11) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `manufacturers_id` int(11) NOT NULL DEFAULT 0,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `locations_id` int(11) NOT NULL DEFAULT 0,
  `states_id` int(11) NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `devicesensortypes_id` (`devicesensortypes_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `locations_id` (`locations_id`),
  KEY `states_id` (`states_id`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicesensortypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicesimcards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `manufacturers_id` int(11) NOT NULL DEFAULT 0,
  `voltage` int(11) DEFAULT NULL,
  `devicesimcardtypes_id` int(11) NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `allow_voip` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `devicesimcardtypes_id` (`devicesimcardtypes_id`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `manufacturers_id` (`manufacturers_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicesimcardtypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

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

CREATE TABLE `glpi_devicesoundcardmodels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_devicesoundcards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `designation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `manufacturers_id` int(11) NOT NULL DEFAULT 0,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `devicesoundcardmodels_id` int(11) DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designation` (`designation`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `devicesoundcardmodels_id` (`devicesoundcardmodels_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `glpi_devicesoundcards` VALUES (1,'AMD High Definition Audio Device',NULL,'AMD High Definition Audio Device',0,0,0,NULL,'2021-10-19 20:59:24','2021-10-19 20:59:24'),(2,'Realtek High Definition Audio',NULL,'Realtek High Definition Audio',0,0,0,NULL,'2021-10-19 20:59:24','2021-10-19 20:59:24'),(3,'AMD Streaming Audio Device',NULL,'AMD Streaming Audio Device',0,0,0,NULL,'2021-10-20 15:19:29','2021-10-20 15:19:29'),(4,'High Definition Audio Device',NULL,'High Definition Audio Device',0,0,0,NULL,'2021-10-21 09:31:32','2021-10-21 09:31:32'),(5,'Intel(R) Display Audio',NULL,'Intel(R) Display Audio',0,0,0,NULL,'2021-10-21 09:31:32','2021-10-21 09:31:32'),(6,'Τεχνολογία Intel® Smart Sound',NULL,'Τεχνολογία Intel® Smart Sound',0,0,0,NULL,'2021-12-13 20:33:14','2021-12-13 20:33:14'),(7,'Ήχος οθόνης Intel(R)',NULL,'Ήχος οθόνης Intel(R)',0,0,0,NULL,'2021-12-13 20:33:14','2021-12-13 20:33:14');

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

CREATE TABLE `glpi_displaypreferences` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `itemtype` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `num` int(11) NOT NULL DEFAULT 0,
  `rank` int(11) NOT NULL DEFAULT 0,
  `users_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`users_id`,`itemtype`,`num`),
  KEY `rank` (`rank`),
  KEY `num` (`num`),
  KEY `itemtype` (`itemtype`)
) ENGINE=InnoDB AUTO_INCREMENT=283 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

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

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

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


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

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

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


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

CREATE TABLE `glpi_documents_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `documents_id` int(11) NOT NULL DEFAULT 0,
  `items_id` int(11) NOT NULL DEFAULT 0,
  `itemtype` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `date_mod` timestamp NULL DEFAULT NULL,
  `users_id` int(11) DEFAULT 0,
  `timeline_position` tinyint(1) NOT NULL DEFAULT 0,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`documents_id`,`itemtype`,`items_id`,`timeline_position`),
  KEY `item` (`itemtype`,`items_id`,`entities_id`,`is_recursive`),
  KEY `users_id` (`users_id`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_documenttypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ext` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mime` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_uploadable` tinyint(1) NOT NULL DEFAULT 1,
  `date_mod` timestamp NULL DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`ext`),
  KEY `name` (`name`),
  KEY `is_uploadable` (`is_uploadable`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

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

CREATE TABLE `glpi_domainrecords` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `data` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `domains_id` int(11) NOT NULL DEFAULT 0,
  `domainrecordtypes_id` int(11) NOT NULL DEFAULT 0,
  `ttl` int(11) NOT NULL,
  `users_id_tech` int(11) NOT NULL DEFAULT 0,
  `groups_id_tech` int(11) NOT NULL DEFAULT 0,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `domains_id` (`domains_id`),
  KEY `domainrecordtypes_id` (`domainrecordtypes_id`),
  KEY `users_id_tech` (`users_id_tech`),
  KEY `groups_id_tech` (`groups_id_tech`),
  KEY `date_mod` (`date_mod`),
  KEY `is_deleted` (`is_deleted`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_domainrecordtypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `glpi_domainrecordtypes` VALUES (1,'A',0,1,'Host address'),(2,'AAAA',0,1,'IPv6 host address'),(3,'ALIAS',0,1,'Auto resolved alias'),(4,'CNAME',0,1,'Canonical name for an alias'),(5,'MX',0,1,'Mail eXchange'),(6,'NS',0,1,'Name Server'),(7,'PTR',0,1,'Pointer'),(8,'SOA',0,1,'Start Of Authority'),(9,'SRV',0,1,'Location of service'),(10,'TXT',0,1,'Descriptive text');

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

CREATE TABLE `glpi_domainrelations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

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

CREATE TABLE `glpi_domains` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `domaintypes_id` int(11) NOT NULL DEFAULT 0,
  `date_expiration` timestamp NULL DEFAULT NULL,
  `users_id_tech` int(11) NOT NULL DEFAULT 0,
  `groups_id_tech` int(11) NOT NULL DEFAULT 0,
  `others` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `domaintypes_id` (`domaintypes_id`),
  KEY `users_id_tech` (`users_id_tech`),
  KEY `groups_id_tech` (`groups_id_tech`),
  KEY `date_mod` (`date_mod`),
  KEY `is_deleted` (`is_deleted`),
  KEY `date_expiration` (`date_expiration`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `glpi_domains` VALUES (1,'WORKGROUP',0,0,0,NULL,0,0,NULL,0,'','2021-10-19 20:59:24','2021-10-19 20:59:24'),(2,'aegeospas.local',0,0,0,NULL,0,0,NULL,0,'','2021-10-21 09:31:32','2021-10-21 09:31:32');

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

CREATE TABLE `glpi_domains_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `domains_id` int(11) NOT NULL DEFAULT 0,
  `items_id` int(11) NOT NULL DEFAULT 0,
  `itemtype` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `domainrelations_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`domains_id`,`itemtype`,`items_id`),
  KEY `domains_id` (`domains_id`),
  KEY `domainrelations_id` (`domainrelations_id`),
  KEY `FK_device` (`items_id`,`itemtype`),
  KEY `item` (`itemtype`,`items_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_domaintypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_dropdowntranslations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `items_id` int(11) NOT NULL DEFAULT 0,
  `itemtype` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `language` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`itemtype`,`items_id`,`language`,`field`),
  KEY `typeid` (`itemtype`,`items_id`),
  KEY `language` (`language`),
  KEY `field` (`field`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_enclosuremodels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_number` varchar(255) COLLATE utf8_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(1) NOT NULL DEFAULT 0,
  `picture_front` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `picture_rear` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `glpi_enclosures` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entities_id` int(11) NOT NULL DEFAULT 0,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `locations_id` int(11) NOT NULL DEFAULT 0,
  `serial` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `otherserial` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `enclosuremodels_id` int(11) DEFAULT NULL,
  `users_id_tech` int(11) NOT NULL DEFAULT 0,
  `groups_id_tech` int(11) NOT NULL DEFAULT 0,
  `is_template` tinyint(1) NOT NULL DEFAULT 0,
  `template_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `orientation` tinyint(1) DEFAULT NULL,
  `power_supplies` tinyint(1) NOT NULL DEFAULT 0,
  `states_id` int(11) NOT NULL DEFAULT 0 COMMENT 'RELATION to states (id)',
  `comment` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `manufacturers_id` int(11) 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 `is_recursive` (`is_recursive`),
  KEY `locations_id` (`locations_id`),
  KEY `enclosuremodels_id` (`enclosuremodels_id`),
  KEY `users_id_tech` (`users_id_tech`),
  KEY `group_id_tech` (`groups_id_tech`),
  KEY `is_template` (`is_template`),
  KEY `is_deleted` (`is_deleted`),
  KEY `states_id` (`states_id`),
  KEY `manufacturers_id` (`manufacturers_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
