--
-- Host: localhost    Database: glpidb
-- ------------------------------------------------------


--
-- 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(),
  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,
  `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,
  `is_helpdesk_visible` tinyint(1) NOT NULL DEFAULT 1,
  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`),
  KEY `is_helpdesk_visible` (`is_helpdesk_visible`)
) 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_appliances_items_relations`
--

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

--
-- Dumping data for table `glpi_appliances_items_relations`
--


--
-- 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 AUTO_INCREMENT=2 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=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- 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=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `glpi_computers` VALUES (1,1,'ET-01-014','','','dario.demenech','',6,0,'Dario Roberto Demenech','2021-07-15 13:33:01',0,4,0,0,2,0,NULL,4,0,0,6,0,1,0.0000,'','2021-07-14 18:16:47',0),(2,1,'ET-01-010','','','vinicius.serena','',6,0,'Recepção','2022-09-05 18:53:43',0,3,0,0,3,0,NULL,3,0,0,0,0,1,0.0000,'','2021-07-14 19:03:45',0),(3,1,'ET-01-018','','','luciane.sperling','',6,0,'Luciane Sperling','2021-07-15 13:33:08',0,3,0,0,2,0,NULL,4,0,0,0,0,1,0.0000,'','2021-07-14 19:04:37',0),(4,1,'ET-01-102','','','franciele.muler','',6,0,'Franciele Muller','2021-07-15 14:03:57',0,5,0,0,2,0,NULL,4,0,0,0,0,1,0.0000,'','2021-07-15 13:58:22',0),(5,1,'ET-01-100','','','camila.lima','',6,0,'Camila Lima','2021-07-15 14:03:44',0,6,0,0,2,0,NULL,4,0,0,0,0,1,0.0000,'','2021-07-15 14:03:44',0),(6,1,'ET-01-104','','','euclides.dalloglio','',6,0,'Euclides Dall\' Oglio\r\n','2021-07-20 18:30:43',0,3,0,0,2,0,NULL,4,0,0,0,0,1,0.0000,'','2021-07-20 17:59:53',0),(7,1,'ET-01-101','','','contabil.02','',6,0,'Sonia Truculo','2021-07-20 18:30:23',0,6,0,0,2,0,NULL,4,0,0,0,0,1,0.0000,'','2021-07-20 18:30:23',0),(8,1,'ET-01-060','','','dorildo.lopes','',6,0,'Dorildo Lopes','2021-07-20 18:32:38',0,6,0,0,2,0,NULL,4,0,0,0,0,1,0.0000,'','2021-07-20 18:32:38',0),(9,1,'ET-01-047','','','ezequiel.amorim','',6,0,'Ezequiel Gomes de Amorim','2021-07-20 18:59:14',0,7,0,0,2,0,NULL,4,0,0,0,0,1,0.0000,'','2021-07-20 18:42:15',0),(10,1,'ET-01-032','','','andreia.poltronieri','',6,0,'Andreia Poltronieri','2021-07-20 18:54:52',0,7,0,0,2,0,NULL,4,0,0,0,0,1,0.0000,'','2021-07-20 18:54:52',0),(11,1,'ET-01-110','','','milaine.pereira','',6,0,'Milaine Pereira','2021-07-20 19:01:24',0,7,0,0,2,0,NULL,4,0,0,0,0,1,0.0000,'','2021-07-20 19:00:27',0),(12,1,'ET-01-137','','','marcia.seguer','',6,0,'Marcia Seguer','2021-07-20 19:51:16',0,5,0,0,2,0,NULL,4,0,0,0,0,1,0.0000,'','2021-07-20 19:11:02',0),(13,1,'ET-01-086','','','elizangela.brunetto','',6,0,'Elizangela Brunetto','2021-07-20 19:11:38',0,5,0,0,2,0,NULL,4,0,0,0,0,1,0.0000,'','2021-07-20 19:11:38',0),(14,1,'ET-01-088','','','luciane.melo','',6,0,'Luciane Melo','2021-07-20 19:14:04',0,5,0,0,2,0,NULL,4,0,0,0,0,1,0.0000,'','2021-07-20 19:14:04',0),(15,1,'ET-01-031','','','gilvania.marcon','',6,0,'Gilvania Marcon','2021-07-20 19:14:38',0,5,0,0,2,0,NULL,4,0,0,0,0,1,0.0000,'','2021-07-20 19:14:38',0),(16,1,'ET-01-036','','','contabil.01','',6,0,'Cleber Mercio Mora','2021-07-20 19:31:43',0,8,0,0,2,0,NULL,4,0,0,0,0,1,0.0000,'','2021-07-20 19:31:43',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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- 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 (2,'Gabinete','Computador montado','2021-07-14 18:13:16','2021-07-14 18:13:16'),(3,'Notebook','','2021-07-14 19:02:57','2021-07-14 19:02:57');

--
-- 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=253 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `glpi_configs` VALUES (1,'core','version','9.5.5'),(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','1'),(9,'core','admin_email','seti@cnsystem.com.br'),(10,'core','admin_email_name','CN System Informática LTDA'),(11,'core','admin_reply','seti@cnsystem.com.br'),(12,'core','admin_reply_name','CN System Informática LTDA'),(13,'core','mailing_signature','Sistema de Chamados GLPI\r\nCN System Informática LTDA'),(14,'core','use_anonymous_helpdesk','0'),(15,'core','use_anonymous_followups','0'),(16,'core','language','pt_BR'),(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'),(30,'core','planning_end','18:00'),(31,'core','utf8_conv','1'),(32,'core','use_public_faq','1'),(33,'core','url_base','http://ftpcn.cnsystem.com.br/glpi'),(34,'core','show_link_in_mail','0'),(35,'core','text_login','Sistema de Suporte e HelpDesk a Usuários CN System Informática LTDA'),(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','3'),(47,'core','smtp_host','smtps.uhserver.com'),(48,'core','smtp_port','587'),(49,'core','smtp_username','seti@cnsystem.com.br'),(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','1'),(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','0'),(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','7340032'),(84,'core','followup_private','0'),(85,'core','task_private','0'),(86,'core','default_software_helpdesk_visible','1'),(87,'core','names_format','1'),(88,'core','default_requesttypes_id','1'),(89,'core','use_noright_users_add','0'),(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','60'),(93,'core','impact_mask','60'),(94,'core','user_deleted_ldap','1'),(95,'core','auto_create_infocoms','0'),(96,'core','use_slave_for_search','0'),(97,'core','proxy_passwd',''),(98,'core','smtp_passwd','jvvu8cVgN7wfmH8QYv8lHrj/oIFiAMHM4cD4E+NTFlIbuFTlHiOTj9obg4YowbFBIGLG'),(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','0'),(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://ftpcn.cnsystem.com.br/glpi/apirest.php/'),(163,'core','login_remember_time','604800'),(164,'core','login_remember_default','1'),(165,'core','use_notifications','1'),(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.5'),(171,'core','smtp_max_retries','5'),(172,'core','smtp_sender',''),(173,'core','from_email','seti@cnsystem.com.br'),(174,'core','from_email_name','CN System Informática LTDA'),(175,'core','instance_uuid','iiDnoUZLczhr0mpX8ak1teMSO9pltT3XIVaHuuib'),(176,'core','registration_uuid','LLlIjj3uxu2PJ8DRbF4QCKfiUD53eiYGHIiMsH0X'),(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','assistance'),(210,'core','admin_email_noreply','seti@cnsystem.com.br'),(211,'core','admin_email_noreply_name','Seti - |GLPICN| Notificações de acompanhamentos dos chamados'),(212,'core','impact_enabled_itemtypes','[\"Appliance\",\"Cluster\",\"Computer\",\"Datacenter\",\"DCRoom\",\"Domain\",\"Enclosure\",\"Monitor\",\"NetworkEquipment\",\"PDU\",\"Peripheral\",\"Phone\",\"Printer\",\"Rack\",\"Software\"]'),(213,'core','use_timezones','1'),(214,'core','update_auth','Salvar'),(215,'core','timezone','0'),(216,'core','_matrix','1'),(217,'core','_impact_5','1'),(218,'core','_impact_4','1'),(219,'core','_impact_3','1'),(220,'core','_impact_2','1'),(221,'core','_impact_1','0'),(222,'core','_urgency_5','1'),(223,'core','_matrix_5_5','5'),(224,'core','_matrix_5_4','5'),(225,'core','_matrix_5_3','4'),(226,'core','_matrix_5_2','3'),(227,'core','_matrix_5_1','2'),(228,'core','_urgency_4','1'),(229,'core','_matrix_4_5','5'),(230,'core','_matrix_4_4','4'),(231,'core','_matrix_4_3','4'),(232,'core','_matrix_4_2','3'),(233,'core','_matrix_4_1','2'),(234,'core','_urgency_3','1'),(235,'core','_matrix_3_5','4'),(236,'core','_matrix_3_4','4'),(237,'core','_matrix_3_3','3'),(238,'core','_matrix_3_2','2'),(239,'core','_matrix_3_1','2'),(240,'core','_urgency_2','1'),(241,'core','_matrix_2_5','3'),(242,'core','_matrix_2_4','3'),(243,'core','_matrix_2_3','2'),(244,'core','_matrix_2_2','2'),(245,'core','_matrix_2_1','1'),(246,'core','_urgency_1','0'),(247,'core','_matrix_1_5','2'),(248,'core','_matrix_1_4','2'),(249,'core','_matrix_1_3','2'),(250,'core','_matrix_1_2','1'),(251,'core','_matrix_1_1','1'),(252,'core','marketplace_replace_plugins','3');

--
-- 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(),
  `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=862 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `glpi_crontasklogs` VALUES (1,18,0,'2021-07-13 12:02:25',0,0,0,'Run mode: GLPI'),(2,18,1,'2021-07-13 12:02:25',2,0.317243,0,'Action completed, no processing required'),(3,19,0,'2021-07-13 12:24:58',0,0,0,'Run mode: GLPI'),(4,19,3,'2021-07-13 12:24:58',2,0.0836151,0,'Action completed, fully processed'),(5,20,0,'2021-07-13 12:34:26',0,0,0,'Run mode: GLPI'),(6,20,5,'2021-07-13 12:34:26',2,0.0669942,0,'Action completed, no processing required'),(7,21,0,'2021-07-13 12:39:34',0,0,0,'Run mode: GLPI'),(8,21,7,'2021-07-13 12:39:34',2,0.0670691,0,'Action completed, no processing required'),(9,22,0,'2021-07-13 12:42:03',0,0,0,'Run mode: GLPI'),(10,22,9,'2021-07-13 12:42:03',2,0.108418,0,'Action completed, no processing required'),(11,23,0,'2021-07-13 12:42:20',0,0,0,'Run mode: GLPI'),(12,23,11,'2021-07-13 12:42:20',2,0.125487,0,'Action completed, no processing required'),(13,24,0,'2021-07-13 12:44:51',0,0,0,'Run mode: GLPI'),(14,24,13,'2021-07-13 12:44:51',1,0.0472929,1,'Apagar 1 arquivo temporário criado a mais de 3600 segundos\n'),(15,24,13,'2021-07-13 12:44:51',2,0.158996,1,'Action completed, fully processed'),(16,25,0,'2021-07-13 12:53:16',0,0,0,'Run mode: GLPI'),(17,25,16,'2021-07-13 12:53:16',2,0.141915,0,'Action completed, no processing required'),(18,5,0,'2021-07-13 12:53:25',0,0,0,'Run mode: GLPI'),(19,5,18,'2021-07-13 12:53:25',2,0.0669231,0,'Action completed, no processing required'),(20,6,0,'2021-07-13 13:16:16',0,0,0,'Run mode: GLPI'),(21,6,20,'2021-07-13 13:16:16',2,0.066978,0,'Action completed, no processing required'),(22,9,0,'2021-07-13 17:56:49',0,0,0,'Run mode: GLPI'),(23,9,22,'2021-07-13 17:56:49',2,0.659833,0,'Action completed, no processing required'),(24,12,0,'2021-07-14 18:06:31',0,0,0,'Run mode: GLPI'),(25,12,24,'2021-07-14 18:06:31',1,0.471577,10,'Limpar 10 arquivos de sessão criados a mais de 1440 segundos\n'),(26,12,24,'2021-07-14 18:06:31',2,0.691669,10,'Action completed, fully processed'),(27,13,0,'2021-07-14 18:11:36',0,0,0,'Run mode: GLPI'),(28,13,27,'2021-07-14 18:11:36',1,0.0792458,1,'Limpar 1 arquivo de gráfico criado a mais de 3600 segundos\n'),(29,13,27,'2021-07-14 18:11:36',2,0.234034,1,'Action completed, fully processed'),(30,14,0,'2021-07-14 18:16:48',0,0,0,'Run mode: GLPI'),(31,14,30,'2021-07-14 18:16:48',2,0.0670779,0,'Action completed, no processing required'),(32,15,0,'2021-07-14 18:24:11',0,0,0,'Run mode: GLPI'),(33,15,32,'2021-07-14 18:24:11',2,0.150296,0,'Action completed, no processing required'),(34,16,0,'2021-07-14 18:31:59',0,0,0,'Run mode: GLPI'),(35,16,34,'2021-07-14 18:31:59',2,0.243298,0,'Action completed, no processing required'),(36,17,0,'2021-07-14 18:43:17',0,0,0,'Run mode: GLPI'),(37,17,36,'2021-07-14 18:43:17',2,0.158539,0,'Action completed, no processing required'),(38,32,0,'2021-07-14 18:51:33',0,0,0,'Run mode: GLPI'),(39,32,38,'2021-07-14 18:51:33',2,0.100299,0,'Action completed, no processing required'),(40,22,0,'2021-07-14 19:01:50',0,0,0,'Run mode: GLPI'),(41,22,40,'2021-07-14 19:01:50',2,0.0836761,0,'Action completed, no processing required'),(42,21,0,'2021-07-14 19:06:51',0,0,0,'Run mode: GLPI'),(43,21,42,'2021-07-14 19:06:51',2,0.0503199,0,'Action completed, no processing required'),(44,20,0,'2021-07-14 19:12:07',0,0,0,'Run mode: GLPI'),(45,20,44,'2021-07-14 19:12:07',2,0.125164,0,'Action completed, no processing required'),(46,24,0,'2021-07-15 13:24:16',0,0,0,'Run mode: GLPI'),(47,24,46,'2021-07-15 13:24:16',2,0.366801,0,'Action completed, no processing required'),(48,9,0,'2021-07-15 13:29:57',0,0,0,'Run mode: GLPI'),(49,9,48,'2021-07-15 13:29:57',2,2.24197,0,'Action completed, no processing required'),(50,18,0,'2021-07-15 13:35:19',0,0,0,'Run mode: GLPI'),(51,18,50,'2021-07-15 13:35:19',2,0.150294,0,'Action completed, no processing required'),(52,19,0,'2021-07-15 13:40:20',0,0,0,'Run mode: GLPI'),(53,19,52,'2021-07-15 13:40:20',2,0.242018,0,'Action completed, fully processed'),(54,23,0,'2021-07-15 13:45:45',0,0,0,'Run mode: GLPI'),(55,23,54,'2021-07-15 13:45:45',2,0.141761,0,'Action completed, no processing required'),(56,5,0,'2021-07-15 13:50:55',0,0,0,'Run mode: GLPI'),(57,5,56,'2021-07-15 13:50:55',2,0.091975,0,'Action completed, no processing required'),(58,25,0,'2021-07-15 13:57:18',0,0,0,'Run mode: GLPI'),(59,25,58,'2021-07-15 13:57:18',2,0.0649078,0,'Action completed, no processing required'),(60,6,0,'2021-07-15 14:02:37',0,0,0,'Run mode: GLPI'),(61,6,60,'2021-07-15 14:02:37',2,0.0836139,0,'Action completed, no processing required'),(62,17,0,'2021-07-15 14:09:56',0,0,0,'Run mode: GLPI'),(63,17,62,'2021-07-15 14:09:56',2,0.109936,0,'Action completed, no processing required'),(64,32,0,'2021-07-15 14:15:11',0,0,0,'Run mode: GLPI'),(65,32,64,'2021-07-15 14:15:11',2,0.333443,0,'Action completed, no processing required'),(66,22,0,'2021-07-15 14:20:38',0,0,0,'Run mode: GLPI'),(67,22,66,'2021-07-15 14:20:38',2,0.141909,0,'Action completed, no processing required'),(68,13,0,'2021-07-15 16:37:07',0,0,0,'Run mode: GLPI'),(69,13,68,'2021-07-15 16:37:07',2,0.083703,0,'Action completed, no processing required'),(70,21,0,'2021-07-15 16:43:19',0,0,0,'Run mode: GLPI'),(71,21,70,'2021-07-15 16:43:19',2,0.100162,0,'Action completed, no processing required'),(72,14,0,'2021-07-15 16:46:58',0,0,0,'Run mode: GLPI'),(73,14,72,'2021-07-15 16:46:58',2,0.058708,0,'Action completed, no processing required'),(74,20,0,'2021-07-15 16:47:56',0,0,0,'Run mode: GLPI'),(75,20,74,'2021-07-15 16:47:56',2,0.150257,0,'Action completed, no processing required'),(76,15,0,'2021-07-15 16:48:59',0,0,0,'Run mode: GLPI'),(77,15,76,'2021-07-15 16:48:59',2,0.133786,0,'Action completed, no processing required'),(78,16,0,'2021-07-15 16:49:37',0,0,0,'Run mode: GLPI'),(79,16,78,'2021-07-15 16:49:37',2,0.0503199,0,'Action completed, no processing required'),(80,9,0,'2021-07-15 16:52:06',0,0,0,'Run mode: GLPI'),(81,9,80,'2021-07-15 16:52:06',2,0.560084,0,'Action completed, no processing required'),(82,17,0,'2021-07-15 16:52:39',0,0,0,'Run mode: GLPI'),(83,17,82,'2021-07-15 16:52:39',2,0.067136,0,'Action completed, no processing required'),(84,32,0,'2021-07-15 16:56:18',0,0,0,'Run mode: GLPI'),(85,32,84,'2021-07-15 16:56:18',2,0.108544,0,'Action completed, no processing required'),(86,22,0,'2021-07-15 16:58:05',0,0,0,'Run mode: GLPI'),(87,22,86,'2021-07-15 16:58:05',2,0.117071,0,'Action completed, no processing required'),(88,24,0,'2021-07-15 16:59:13',0,0,0,'Run mode: GLPI'),(89,24,88,'2021-07-15 16:59:13',2,0.066957,0,'Action completed, no processing required'),(90,21,0,'2021-07-15 17:00:40',0,0,0,'Run mode: GLPI'),(91,21,90,'2021-07-15 17:00:40',2,0.092006,0,'Action completed, no processing required'),(92,17,0,'2021-07-15 17:13:07',0,0,0,'Run mode: GLPI'),(93,17,92,'2021-07-15 17:13:07',2,0.066879,0,'Action completed, no processing required'),(94,22,0,'2021-07-15 19:21:07',0,0,0,'Run mode: GLPI'),(95,22,94,'2021-07-15 19:21:07',2,0.091876,0,'Action completed, no processing required'),(96,32,0,'2021-07-15 20:03:24',0,0,0,'Run mode: GLPI'),(97,32,96,'2021-07-15 20:03:24',2,0.0669808,0,'Action completed, no processing required'),(98,9,0,'2021-07-16 13:59:31',0,0,0,'Run mode: GLPI'),(99,9,98,'2021-07-16 13:59:31',2,2.16102,0,'Action completed, no processing required'),(100,21,0,'2021-07-16 14:04:42',0,0,0,'Run mode: GLPI'),(101,21,100,'2021-07-16 14:04:42',2,0.0670609,0,'Action completed, no processing required'),(102,17,0,'2021-07-16 14:10:47',0,0,0,'Run mode: GLPI'),(103,17,102,'2021-07-16 14:10:47',2,0.0503531,0,'Action completed, no processing required'),(104,13,0,'2021-07-16 20:18:08',0,0,0,'Run mode: GLPI'),(105,13,104,'2021-07-16 20:18:08',2,0.0920599,0,'Action completed, no processing required'),(106,14,0,'2021-07-19 13:22:39',0,0,0,'Run mode: GLPI'),(107,14,106,'2021-07-19 13:22:39',2,0.783383,0,'Action completed, no processing required'),(108,20,0,'2021-07-19 13:23:03',0,0,0,'Run mode: GLPI'),(109,20,108,'2021-07-19 13:23:03',2,0.343182,0,'Action completed, no processing required'),(110,24,0,'2021-07-19 13:23:07',0,0,0,'Run mode: GLPI'),(111,24,110,'2021-07-19 13:23:07',2,0.200403,0,'Action completed, no processing required'),(112,12,0,'2021-07-19 13:23:09',0,0,0,'Run mode: GLPI'),(113,12,112,'2021-07-19 13:23:09',1,0.143379,20,'Limpar 20 arquivos de sessão criados a mais de 1440 segundos\n'),(114,12,112,'2021-07-19 13:23:09',2,0.267597,20,'Action completed, fully processed'),(115,22,0,'2021-07-19 13:41:30',0,0,0,'Run mode: GLPI'),(116,22,115,'2021-07-19 13:41:30',2,0.108502,0,'Action completed, no processing required'),(117,32,0,'2021-07-19 20:25:37',0,0,0,'Run mode: GLPI'),(118,32,117,'2021-07-19 20:25:37',2,0.749696,0,'Action completed, no processing required'),(119,15,0,'2021-07-20 16:40:16',0,0,0,'Run mode: GLPI'),(120,15,119,'2021-07-20 16:40:16',2,0.325164,0,'Action completed, no processing required'),(121,16,0,'2021-07-20 17:56:37',0,0,0,'Run mode: GLPI'),(122,16,121,'2021-07-20 17:56:37',2,0.126561,0,'Action completed, no processing required'),(123,18,0,'2021-07-20 18:01:49',0,0,0,'Run mode: GLPI'),(124,18,123,'2021-07-20 18:01:49',2,0.350261,0,'Action completed, no processing required'),(125,19,0,'2021-07-20 18:04:59',0,0,0,'Run mode: GLPI'),(126,19,125,'2021-07-20 18:04:59',2,0.116856,0,'Action completed, fully processed'),(127,23,0,'2021-07-20 18:05:35',0,0,0,'Run mode: GLPI'),(128,23,127,'2021-07-20 18:05:35',2,0.175165,0,'Action completed, no processing required'),(129,5,0,'2021-07-20 18:05:46',0,0,0,'Run mode: GLPI'),(130,5,129,'2021-07-20 18:05:46',2,0.167242,0,'Action completed, no processing required'),(131,25,0,'2021-07-20 18:09:07',0,0,0,'Run mode: GLPI'),(132,25,131,'2021-07-20 18:09:07',2,0.066988,0,'Action completed, no processing required'),(133,6,0,'2021-07-20 18:09:48',0,0,0,'Run mode: GLPI'),(134,6,133,'2021-07-20 18:09:48',2,0.0669088,0,'Action completed, no processing required'),(135,9,0,'2021-07-20 18:29:02',0,0,0,'Run mode: GLPI'),(136,9,135,'2021-07-20 18:29:02',2,1.00126,0,'Action completed, no processing required'),(137,21,0,'2021-07-20 18:34:10',0,0,0,'Run mode: GLPI'),(138,21,137,'2021-07-20 18:34:10',2,0.216637,0,'Action completed, no processing required'),(139,17,0,'2021-07-20 18:41:16',0,0,0,'Run mode: GLPI'),(140,17,139,'2021-07-20 18:41:16',2,0.0836189,0,'Action completed, no processing required'),(141,13,0,'2021-07-20 18:52:07',0,0,0,'Run mode: GLPI'),(142,13,141,'2021-07-20 18:52:07',2,0.0753679,0,'Action completed, no processing required'),(143,22,0,'2021-07-20 18:57:12',0,0,0,'Run mode: GLPI'),(144,22,143,'2021-07-20 18:57:12',2,0.0669298,0,'Action completed, no processing required'),(145,14,0,'2021-07-20 19:10:05',0,0,0,'Run mode: GLPI'),(146,14,145,'2021-07-20 19:10:05',2,0.0504451,0,'Action completed, no processing required'),(147,20,0,'2021-07-20 19:15:13',0,0,0,'Run mode: GLPI'),(148,20,147,'2021-07-20 19:15:13',2,0.116893,0,'Action completed, no processing required'),(149,24,0,'2021-07-20 19:23:01',0,0,0,'Run mode: GLPI'),(150,24,149,'2021-07-20 19:23:01',2,0.150219,0,'Action completed, no processing required'),(151,32,0,'2021-07-20 19:31:43',0,0,0,'Run mode: GLPI'),(152,32,151,'2021-07-20 19:31:43',2,0.100336,0,'Action completed, no processing required'),(153,12,0,'2021-07-20 19:39:07',0,0,0,'Run mode: GLPI'),(154,12,153,'2021-07-20 19:39:07',1,0.027097,8,'Limpar 8 arquivos de sessão criados a mais de 1440 segundos\n'),(155,12,153,'2021-07-20 19:39:07',2,0.125656,8,'Action completed, fully processed'),(156,9,0,'2021-07-20 19:44:09',0,0,0,'Run mode: GLPI'),(157,9,156,'2021-07-20 19:44:09',2,0.828037,0,'Action completed, no processing required'),(158,21,0,'2021-07-20 19:49:20',0,0,0,'Run mode: GLPI'),(159,21,158,'2021-07-20 19:49:20',2,0.0503221,0,'Action completed, no processing required'),(160,17,0,'2021-07-20 19:54:28',0,0,0,'Run mode: GLPI'),(161,17,160,'2021-07-20 19:54:28',2,0.066958,0,'Action completed, no processing required'),(162,22,0,'2021-07-20 19:59:38',0,0,0,'Run mode: GLPI'),(163,22,162,'2021-07-20 19:59:38',2,0.0502641,0,'Action completed, no processing required'),(164,32,0,'2021-07-20 20:07:17',0,0,0,'Run mode: GLPI'),(165,32,164,'2021-07-20 20:07:17',2,0.05035,0,'Action completed, no processing required'),(166,13,0,'2021-07-20 20:12:48',0,0,0,'Run mode: GLPI'),(167,13,166,'2021-07-20 20:12:48',2,0.050607,0,'Action completed, no processing required'),(168,9,0,'2021-07-20 20:18:42',0,0,0,'Run mode: GLPI'),(169,9,168,'2021-07-20 20:18:42',2,0.659684,0,'Action completed, no processing required'),(170,21,0,'2021-07-21 11:40:44',0,0,0,'Run mode: GLPI'),(171,21,170,'2021-07-21 11:40:44',2,0.366743,0,'Action completed, no processing required'),(172,17,0,'2021-07-21 11:46:28',0,0,0,'Run mode: GLPI'),(173,17,172,'2021-07-21 11:46:28',2,0.200069,0,'Action completed, no processing required'),(174,22,0,'2021-07-21 12:08:19',0,0,0,'Run mode: GLPI'),(175,22,174,'2021-07-21 12:08:19',2,0.200412,0,'Action completed, no processing required'),(176,14,0,'2021-07-21 16:28:26',0,0,0,'Run mode: GLPI'),(177,14,176,'2021-07-21 16:28:26',2,0.108711,0,'Action completed, no processing required'),(178,32,0,'2021-07-21 16:28:34',0,0,0,'Run mode: GLPI'),(179,32,178,'2021-07-21 16:28:34',2,0.158371,0,'Action completed, no processing required'),(180,20,0,'2021-07-21 16:28:41',0,0,0,'Run mode: GLPI'),(181,20,180,'2021-07-21 16:28:41',2,0.150109,0,'Action completed, no processing required'),(182,24,0,'2021-07-21 16:28:53',0,0,0,'Run mode: GLPI'),(183,24,182,'2021-07-21 16:28:53',2,0.100265,0,'Action completed, no processing required'),(184,9,0,'2021-07-21 16:29:09',0,0,0,'Run mode: GLPI'),(185,9,184,'2021-07-21 16:29:09',2,1.5942,0,'Action completed, no processing required'),(186,13,0,'2021-07-21 16:29:26',0,0,0,'Run mode: GLPI'),(187,13,186,'2021-07-21 16:29:26',2,0.0836,0,'Action completed, no processing required'),(188,15,0,'2021-07-23 12:32:56',0,0,0,'Run mode: GLPI'),(189,15,188,'2021-07-23 12:32:56',2,0.383445,0,'Action completed, no processing required'),(190,16,0,'2021-07-28 19:48:49',0,0,0,'Run mode: GLPI'),(191,16,190,'2021-07-28 19:48:49',2,0.566575,0,'Action completed, no processing required'),(192,21,0,'2021-07-28 19:48:58',0,0,0,'Run mode: GLPI'),(193,21,192,'2021-07-28 19:48:58',2,0.150277,0,'Action completed, no processing required'),(194,17,0,'2021-07-28 19:49:19',0,0,0,'Run mode: GLPI'),(195,17,194,'2021-07-28 19:49:19',2,0.275147,0,'Action completed, no processing required'),(196,22,0,'2021-07-29 13:02:44',0,0,0,'Run mode: GLPI'),(197,22,196,'2021-07-29 13:02:44',2,0.308583,0,'Action completed, no processing required'),(198,32,0,'2021-07-29 14:02:49',0,0,0,'Run mode: GLPI'),(199,32,198,'2021-07-29 14:02:49',2,0.20034,0,'Action completed, no processing required'),(200,9,0,'2021-08-03 18:21:11',0,0,0,'Run mode: GLPI'),(201,9,200,'2021-08-03 18:21:11',2,4.15103,0,'Action completed, no processing required'),(202,14,0,'2021-08-20 23:48:35',0,0,0,'Run mode: GLPI'),(203,14,202,'2021-08-20 23:48:35',2,1.34937,0,'Action completed, no processing required'),(204,20,0,'2021-08-20 23:48:46',0,0,0,'Run mode: GLPI'),(205,20,204,'2021-08-20 23:48:46',2,0.400013,0,'Action completed, no processing required'),(206,24,0,'2021-08-20 23:48:53',0,0,0,'Run mode: GLPI'),(207,24,206,'2021-08-20 23:48:53',2,0.217006,0,'Action completed, no processing required'),(208,13,0,'2021-08-20 23:49:08',0,0,0,'Run mode: GLPI'),(209,13,208,'2021-08-20 23:49:08',2,0.158654,0,'Action completed, no processing required'),(210,18,0,'2021-08-20 23:49:25',0,0,0,'Run mode: GLPI'),(211,18,210,'2021-08-20 23:49:25',2,0.233449,0,'Action completed, no processing required'),(212,19,0,'2021-08-20 23:49:38',0,0,0,'Run mode: GLPI'),(213,19,212,'2021-08-20 23:49:38',2,0.20026,0,'Action completed, fully processed'),(214,5,0,'2021-08-20 23:49:49',0,0,0,'Run mode: GLPI'),(215,5,214,'2021-08-20 23:49:49',2,0.0919859,0,'Action completed, no processing required'),(216,23,0,'2021-08-20 23:50:01',0,0,0,'Run mode: GLPI'),(217,23,216,'2021-08-20 23:50:01',2,0.475228,0,'Action completed, no processing required'),(218,6,0,'2021-08-20 23:50:49',0,0,0,'Run mode: GLPI'),(219,6,218,'2021-08-20 23:50:49',2,0.55832,0,'Action completed, no processing required'),(220,25,0,'2021-08-20 23:51:13',0,0,0,'Run mode: GLPI'),(221,25,220,'2021-08-20 23:51:13',2,0.150113,0,'Action completed, no processing required'),(222,12,0,'2021-08-20 23:51:22',0,0,0,'Run mode: GLPI'),(223,12,222,'2021-08-20 23:51:22',1,0.146136,28,'Limpar 28 arquivos de sessão criados a mais de 1440 segundos\n'),(224,12,222,'2021-08-20 23:51:22',2,0.25194,28,'Action completed, fully processed'),(225,15,0,'2021-08-21 00:01:01',0,0,0,'Run mode: GLPI'),(226,15,225,'2021-08-21 00:01:01',2,0.150263,0,'Action completed, no processing required'),(227,21,0,'2021-08-21 14:27:10',0,0,0,'Run mode: GLPI'),(228,21,227,'2021-08-21 14:27:10',2,0.366728,0,'Action completed, no processing required'),(229,17,0,'2021-08-21 19:58:54',0,0,0,'Run mode: GLPI'),(230,17,229,'2021-08-21 19:58:54',2,0.408416,0,'Action completed, no processing required'),(231,16,0,'2021-08-22 15:11:52',0,0,0,'Run mode: GLPI'),(232,16,231,'2021-08-22 15:11:52',2,0.391748,0,'Action completed, no processing required'),(233,22,0,'2021-08-23 02:58:33',0,0,0,'Run mode: GLPI'),(234,22,233,'2021-08-23 02:58:33',2,0.383552,0,'Action completed, no processing required'),(235,32,0,'2021-08-30 15:45:54',0,0,0,'Run mode: GLPI'),(236,32,235,'2021-08-30 15:45:54',2,1.00818,0,'Action completed, no processing required'),(237,9,0,'2021-09-20 20:58:16',0,0,0,'Run mode: GLPI'),(238,9,237,'2021-09-20 20:58:16',2,3.49295,0,'Action completed, no processing required'),(239,14,0,'2021-09-21 11:50:25',0,0,0,'Run mode: GLPI'),(240,14,239,'2021-09-21 11:50:25',2,0.533277,0,'Action completed, no processing required'),(241,20,0,'2021-09-21 19:45:38',0,0,0,'Run mode: GLPI'),(242,20,241,'2021-09-21 19:45:38',2,0.158404,0,'Action completed, no processing required'),(243,24,0,'2021-09-27 13:48:24',0,0,0,'Run mode: GLPI'),(244,24,243,'2021-09-27 13:48:24',2,0.974843,0,'Action completed, no processing required'),(245,13,0,'2021-09-27 13:48:57',0,0,0,'Run mode: GLPI'),(246,13,245,'2021-09-27 13:48:57',2,0.291955,0,'Action completed, no processing required'),(247,15,0,'2021-09-27 13:54:37',0,0,0,'Run mode: GLPI'),(248,15,247,'2021-09-27 13:54:37',2,0.10859,0,'Action completed, no processing required'),(249,21,0,'2021-09-27 13:54:54',0,0,0,'Run mode: GLPI'),(250,21,249,'2021-09-27 13:54:54',2,0.0503771,0,'Action completed, no processing required'),(251,17,0,'2021-09-27 13:54:57',0,0,0,'Run mode: GLPI'),(252,17,251,'2021-09-27 13:54:57',2,0.341781,0,'Action completed, no processing required'),(253,5,0,'2021-09-27 13:55:20',0,0,0,'Run mode: GLPI'),(254,5,253,'2021-09-27 13:55:20',2,0.067081,0,'Action completed, no processing required'),(255,18,0,'2021-09-27 13:55:23',0,0,0,'Run mode: GLPI'),(256,18,255,'2021-09-27 13:55:23',2,0.0753629,0,'Action completed, no processing required'),(257,19,0,'2021-09-27 13:55:26',0,0,0,'Run mode: GLPI'),(258,19,257,'2021-09-27 13:55:26',2,0.0502448,0,'Action completed, fully processed'),(259,6,0,'2021-09-27 13:55:29',0,0,0,'Run mode: GLPI'),(260,6,259,'2021-09-27 13:55:29',2,0.0919521,0,'Action completed, no processing required'),(261,23,0,'2021-09-27 13:55:32',0,0,0,'Run mode: GLPI'),(262,23,261,'2021-09-27 13:55:32',2,0.208556,0,'Action completed, no processing required'),(263,12,0,'2021-09-27 13:55:35',0,0,0,'Run mode: GLPI'),(264,12,263,'2021-09-27 13:55:35',1,0.0967312,21,'Limpar 21 arquivos de sessão criados a mais de 1440 segundos\n'),(265,12,263,'2021-09-27 13:55:35',2,0.233825,21,'Action completed, fully processed'),(266,25,0,'2021-09-27 13:55:39',0,0,0,'Run mode: GLPI'),(267,25,266,'2021-09-27 13:55:39',2,0.050209,0,'Action completed, no processing required'),(268,22,0,'2021-09-27 13:55:42',0,0,0,'Run mode: GLPI'),(269,22,268,'2021-09-27 13:55:42',2,0.0586491,0,'Action completed, no processing required'),(270,16,0,'2021-09-27 13:55:44',0,0,0,'Run mode: GLPI'),(271,16,270,'2021-09-27 13:55:44',2,0.0586479,0,'Action completed, no processing required'),(272,32,0,'2021-09-27 13:55:45',0,0,0,'Run mode: GLPI'),(273,32,272,'2021-09-27 13:55:45',2,0.283502,0,'Action completed, no processing required'),(274,9,0,'2021-09-27 13:55:48',0,0,0,'Run mode: GLPI'),(275,9,274,'2021-09-27 13:55:48',1,1.06248,0,'Collect mails from Seti - Setor TI ({pop3.cnsysten.com.br:110/pop}Inbox)\n'),(276,9,274,'2021-09-27 13:55:48',1,1.73535,0,'\n'),(277,9,274,'2021-09-27 13:55:48',2,1.89471,0,'Action completed, no processing required'),(278,14,0,'2021-09-27 13:56:01',0,0,0,'Run mode: GLPI'),(279,14,278,'2021-09-27 13:56:01',2,0.0671089,0,'Action completed, no processing required'),(280,20,0,'2021-09-27 13:56:03',0,0,0,'Run mode: GLPI'),(281,20,280,'2021-09-27 13:56:03',2,0.217088,0,'Action completed, no processing required'),(282,22,0,'2021-09-27 13:56:06',0,0,0,'Run mode: GLPI'),(283,22,282,'2021-09-27 13:56:06',2,0.091933,0,'Action completed, no processing required'),(284,9,0,'2021-09-27 13:57:04',0,0,0,'Run mode: GLPI'),(285,9,284,'2021-09-27 13:57:04',1,0.386262,0,'Collect mails from Seti - Setor TI ({pop3.cnsysten.com.br/pop})\n'),(286,9,284,'2021-09-27 13:57:04',1,0.544414,0,'\n'),(287,9,284,'2021-09-27 13:57:04',2,0.595038,0,'Action completed, no processing required'),(288,9,0,'2021-09-27 14:00:02',0,0,0,'Run mode: GLPI'),(289,9,288,'2021-09-27 14:00:02',1,0.387088,0,'Collect mails from Seti - Setor TI ({pop3.cnsysten.com.br})\n'),(290,9,288,'2021-09-27 14:00:02',1,0.511634,0,'\n'),(291,9,288,'2021-09-27 14:00:02',2,0.560656,0,'Action completed, no processing required'),(292,22,0,'2021-09-27 14:00:03',0,0,0,'Run mode: GLPI'),(293,22,292,'2021-09-27 14:00:03',2,0.0503738,0,'Action completed, no processing required'),(294,9,0,'2021-09-27 14:00:38',0,0,0,'Run mode: GLPI'),(295,9,294,'2021-09-27 14:00:38',1,0.345108,0,'Collect mails from Seti - Setor TI ({pop3.cnsysten.com.br/imap})\n'),(296,9,294,'2021-09-27 14:00:38',1,0.578376,0,'\n'),(297,9,294,'2021-09-27 14:00:38',2,0.627222,0,'Action completed, no processing required'),(298,17,0,'2021-09-27 14:00:41',0,0,0,'Run mode: GLPI'),(299,17,298,'2021-09-27 14:00:41',2,0.067019,0,'Action completed, no processing required'),(300,21,0,'2021-09-27 14:00:42',0,0,0,'Run mode: GLPI'),(301,21,300,'2021-09-27 14:00:42',2,0.151926,0,'Action completed, no processing required'),(302,32,0,'2021-09-27 14:00:44',0,0,0,'Run mode: GLPI'),(303,32,302,'2021-09-27 14:00:44',2,0.050308,0,'Action completed, no processing required'),(304,22,0,'2021-09-27 14:09:17',0,0,0,'Run mode: GLPI'),(305,22,304,'2021-09-27 14:09:17',2,0.133613,0,'Action completed, no processing required'),(306,17,0,'2021-09-27 14:15:13',0,0,0,'Run mode: GLPI'),(307,17,306,'2021-09-27 14:15:13',2,0.091949,0,'Action completed, no processing required'),(308,21,0,'2021-09-27 14:20:18',0,0,0,'Run mode: GLPI'),(309,21,308,'2021-09-27 14:20:18',2,0.0669389,0,'Action completed, no processing required'),(310,21,0,'2021-09-27 14:20:20',0,0,0,'Run mode: GLPI'),(311,21,310,'2021-09-27 14:20:20',2,0.0751939,0,'Action completed, no processing required'),(312,32,0,'2021-09-27 14:20:21',0,0,0,'Run mode: GLPI'),(313,32,312,'2021-09-27 14:20:21',2,0.0671909,0,'Action completed, no processing required'),(314,9,0,'2021-09-27 14:20:23',0,0,0,'Run mode: GLPI'),(315,9,314,'2021-09-27 14:20:23',1,0.386475,0,'Collect mails from Abertura de Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(316,9,314,'2021-09-27 14:20:23',1,2.5662,0,'Número de mensagens: disponível= 0 ,atualmente importado= 0 ,recuperado= 0,recusado= 0, erros=0,lista negra= 0\n'),(317,9,314,'2021-09-27 14:20:23',2,2.79222,0,'Action completed, no processing required'),(318,22,0,'2021-09-27 14:20:28',0,0,0,'Run mode: GLPI'),(319,22,318,'2021-09-27 14:20:28',2,0.066952,0,'Action completed, no processing required'),(320,17,0,'2021-09-27 14:20:29',0,0,0,'Run mode: GLPI'),(321,17,320,'2021-09-27 14:20:29',2,0.0586929,0,'Action completed, no processing required'),(322,22,0,'2021-09-27 14:25:44',0,0,0,'Run mode: GLPI'),(323,22,322,'2021-09-27 14:25:44',2,0.116725,0,'Action completed, no processing required'),(324,17,0,'2021-09-27 14:30:45',0,0,0,'Run mode: GLPI'),(325,17,324,'2021-09-27 14:30:45',2,0.0669549,0,'Action completed, no processing required'),(326,21,0,'2021-09-27 14:31:35',0,0,0,'Run mode: GLPI'),(327,21,326,'2021-09-27 14:31:35',2,0.050349,0,'Action completed, no processing required'),(328,32,0,'2021-09-27 14:31:37',0,0,0,'Run mode: GLPI'),(329,32,328,'2021-09-27 14:31:37',2,0.0670249,0,'Action completed, no processing required'),(330,22,0,'2021-09-27 14:31:38',0,0,0,'Run mode: GLPI'),(331,22,330,'2021-09-27 14:31:38',2,0.100327,0,'Action completed, no processing required'),(332,9,0,'2021-09-27 14:31:40',0,0,0,'Run mode: GLPI'),(333,9,332,'2021-09-27 14:31:40',1,0.345709,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert}GLPI)\n'),(334,9,332,'2021-09-27 14:31:40',1,2.45967,0,'Número de mensagens: disponível= 0 ,atualmente importado= 0 ,recuperado= 0,recusado= 0, erros=0,lista negra= 0\n'),(335,9,332,'2021-09-27 14:31:40',2,2.66827,0,'Action completed, no processing required'),(336,22,0,'2021-09-27 14:35:59',0,0,0,'Run mode: GLPI'),(337,22,336,'2021-09-27 14:35:59',2,0.0502679,0,'Action completed, no processing required'),(338,17,0,'2021-09-27 16:06:45',0,0,0,'Run mode: GLPI'),(339,17,338,'2021-09-27 16:06:45',2,0.0501981,0,'Action completed, no processing required'),(340,21,0,'2021-09-27 16:11:03',0,0,0,'Run mode: GLPI'),(341,21,340,'2021-09-27 16:11:03',2,0.066963,0,'Action completed, no processing required'),(342,22,0,'2021-09-27 16:11:04',0,0,0,'Run mode: GLPI'),(343,22,342,'2021-09-27 16:11:04',2,0.0503569,0,'Action completed, no processing required'),(344,32,0,'2021-09-27 16:11:06',0,0,0,'Run mode: GLPI'),(345,32,344,'2021-09-27 16:11:06',2,0.0503638,0,'Action completed, no processing required'),(346,9,0,'2021-09-27 16:11:07',0,0,0,'Run mode: GLPI'),(347,9,346,'2021-09-27 16:11:07',1,0.361001,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(348,9,346,'2021-09-27 16:11:07',1,1.69763,0,'Número de mensagens: disponível= 0 ,atualmente importado= 0 ,recuperado= 0,recusado= 0, erros=0,lista negra= 0\n'),(349,9,346,'2021-09-27 16:11:07',2,1.92577,0,'Action completed, no processing required'),(350,13,0,'2021-09-27 16:11:11',0,0,0,'Run mode: GLPI'),(351,13,350,'2021-09-27 16:11:11',2,0.0836329,0,'Action completed, no processing required'),(352,24,0,'2021-09-27 16:11:12',0,0,0,'Run mode: GLPI'),(353,24,352,'2021-09-27 16:11:12',2,0.0503099,0,'Action completed, no processing required'),(354,14,0,'2021-09-27 16:11:14',0,0,0,'Run mode: GLPI'),(355,14,354,'2021-09-27 16:11:14',2,0.058696,0,'Action completed, no processing required'),(356,20,0,'2021-09-27 16:11:15',0,0,0,'Run mode: GLPI'),(357,20,356,'2021-09-27 16:11:15',2,0.068398,0,'Action completed, no processing required'),(358,17,0,'2021-09-27 16:11:16',0,0,0,'Run mode: GLPI'),(359,17,358,'2021-09-27 16:11:16',2,0.066998,0,'Action completed, no processing required'),(360,22,0,'2021-09-27 16:12:01',0,0,0,'Run mode: GLPI'),(361,22,360,'2021-09-27 16:12:01',2,0.051718,0,'Action completed, no processing required'),(362,22,0,'2021-09-27 16:26:41',0,0,0,'Run mode: GLPI'),(363,22,362,'2021-09-27 16:26:41',2,0.0669229,0,'Action completed, no processing required'),(364,17,0,'2021-09-27 16:31:47',0,0,0,'Run mode: GLPI'),(365,17,364,'2021-09-27 16:31:47',2,0.050364,0,'Action completed, no processing required'),(366,21,0,'2021-09-27 16:37:01',0,0,0,'Run mode: GLPI'),(367,21,366,'2021-09-27 16:37:01',2,0.141917,0,'Action completed, no processing required'),(368,32,0,'2021-09-27 16:43:37',0,0,0,'Run mode: GLPI'),(369,32,368,'2021-09-27 16:43:37',2,0.100587,0,'Action completed, no processing required'),(370,9,0,'2021-09-27 16:48:35',0,0,0,'Run mode: GLPI'),(371,9,370,'2021-09-27 16:48:35',1,0.30252,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(372,9,370,'2021-09-27 16:48:35',1,2.56,0,'Número de mensagens: disponível= 0 ,atualmente importado= 0 ,recuperado= 0,recusado= 0, erros=0,lista negra= 0\n'),(373,9,370,'2021-09-27 16:48:35',2,2.77536,0,'Action completed, no processing required'),(374,22,0,'2021-09-27 16:48:48',0,0,0,'Run mode: GLPI'),(375,22,374,'2021-09-27 16:48:48',2,0.192197,0,'Action completed, fully processed'),(376,17,0,'2021-09-27 16:48:58',0,0,0,'Run mode: GLPI'),(377,17,376,'2021-09-27 16:48:58',2,0.085856,0,'Action completed, no processing required'),(378,21,0,'2021-09-27 16:49:04',0,0,0,'Run mode: GLPI'),(379,21,378,'2021-09-27 16:49:04',2,0.0669689,0,'Action completed, no processing required'),(380,32,0,'2021-09-27 16:49:11',0,0,0,'Run mode: GLPI'),(381,32,380,'2021-09-27 16:49:11',2,0.0670102,0,'Action completed, no processing required'),(382,22,0,'2021-09-27 16:49:19',0,0,0,'Run mode: GLPI'),(383,22,382,'2021-09-27 16:49:19',2,0.050426,0,'Action completed, no processing required'),(384,22,0,'2021-09-27 16:50:03',0,0,0,'Run mode: GLPI'),(385,22,384,'2021-09-27 16:50:03',2,0.192182,0,'Action completed, fully processed'),(386,22,0,'2021-09-27 16:55:17',0,0,0,'Run mode: GLPI'),(387,22,386,'2021-09-27 16:55:17',2,0.25074,0,'Action completed, fully processed'),(388,17,0,'2021-09-27 16:57:19',0,0,0,'Run mode: GLPI'),(389,17,388,'2021-09-27 16:57:19',2,0.066957,0,'Action completed, no processing required'),(390,21,0,'2021-09-27 20:33:50',0,0,0,'Run mode: GLPI'),(391,21,390,'2021-09-27 20:33:50',2,0.0751889,0,'Action completed, no processing required'),(392,32,0,'2021-09-27 20:40:14',0,0,0,'Run mode: GLPI'),(393,32,392,'2021-09-27 20:40:14',2,0.0670071,0,'Action completed, no processing required'),(394,22,0,'2021-09-27 20:54:05',0,0,0,'Run mode: GLPI'),(395,22,394,'2021-09-27 20:54:05',2,0.267483,0,'Action completed, fully processed'),(396,9,0,'2021-09-27 20:59:05',0,0,0,'Run mode: GLPI'),(397,9,396,'2021-09-27 20:59:05',1,0.418843,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(398,9,396,'2021-09-27 20:59:05',1,1.84428,0,'Número de mensagens: disponível= 0 ,atualmente importado= 0 ,recuperado= 0,recusado= 0, erros=0,lista negra= 0\n'),(399,9,396,'2021-09-27 20:59:05',2,2.05237,0,'Action completed, no processing required'),(400,17,0,'2021-09-27 21:04:33',0,0,0,'Run mode: GLPI'),(401,17,400,'2021-09-27 21:04:33',2,0.0586522,0,'Action completed, no processing required'),(402,13,0,'2021-09-27 21:08:39',0,0,0,'Run mode: GLPI'),(403,13,402,'2021-09-27 21:08:39',2,0.142292,0,'Action completed, no processing required'),(404,14,0,'2021-09-27 21:08:40',0,0,0,'Run mode: GLPI'),(405,14,404,'2021-09-27 21:08:40',2,0.116918,0,'Action completed, no processing required'),(406,20,0,'2021-09-27 21:08:41',0,0,0,'Run mode: GLPI'),(407,20,406,'2021-09-27 21:08:41',2,0.050318,0,'Action completed, no processing required'),(408,24,0,'2021-09-27 21:08:42',0,0,0,'Run mode: GLPI'),(409,24,408,'2021-09-27 21:08:42',2,0.0684202,0,'Action completed, no processing required'),(410,21,0,'2021-09-27 21:08:43',0,0,0,'Run mode: GLPI'),(411,21,410,'2021-09-27 21:08:43',2,0.0671339,0,'Action completed, no processing required'),(412,32,0,'2021-09-27 21:08:45',0,0,0,'Run mode: GLPI'),(413,32,412,'2021-09-27 21:08:45',2,0.050319,0,'Action completed, no processing required'),(414,22,0,'2021-09-27 21:08:46',0,0,0,'Run mode: GLPI'),(415,22,414,'2021-09-27 21:08:46',2,0.289812,0,'Action completed, fully processed'),(416,9,0,'2021-09-27 21:09:34',0,0,0,'Run mode: GLPI'),(417,9,416,'2021-09-27 21:09:34',1,0.33722,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(418,9,416,'2021-09-27 21:09:34',1,2.64623,0,'Número de mensagens: disponível= 0 ,atualmente importado= 0 ,recuperado= 0,recusado= 0, erros=0,lista negra= 0\n'),(419,9,416,'2021-09-27 21:09:34',2,2.86913,0,'Action completed, no processing required'),(420,17,0,'2021-09-27 21:14:46',0,0,0,'Run mode: GLPI'),(421,17,420,'2021-09-27 21:14:46',2,0.0669582,0,'Action completed, no processing required'),(422,22,0,'2021-09-27 21:19:49',0,0,0,'Run mode: GLPI'),(423,22,422,'2021-09-27 21:19:49',2,6.39025,7,'Action completed, fully processed'),(424,21,0,'2021-09-27 21:25:10',0,0,0,'Run mode: GLPI'),(425,21,424,'2021-09-27 21:25:10',2,0.0502651,0,'Action completed, no processing required'),(426,32,0,'2021-09-28 11:39:11',0,0,0,'Run mode: GLPI'),(427,32,426,'2021-09-28 11:39:11',2,1.04975,0,'Action completed, no processing required'),(428,9,0,'2021-09-28 11:58:01',0,0,0,'Run mode: GLPI'),(429,9,428,'2021-09-28 11:58:01',1,1.68179,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(430,9,428,'2021-09-28 11:58:01',1,3.68828,0,'Número de mensagens: disponível= 0 ,atualmente importado= 0 ,recuperado= 0,recusado= 0, erros=0,lista negra= 0\n'),(431,9,428,'2021-09-28 11:58:01',2,3.97498,0,'Action completed, no processing required'),(432,9,0,'2021-09-28 11:58:05',0,0,0,'Run mode: GLPI'),(433,9,432,'2021-09-28 11:58:05',1,0.729205,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(434,9,432,'2021-09-28 11:58:05',1,2.71982,0,'Número de mensagens: disponível= 0 ,atualmente importado= 0 ,recuperado= 0,recusado= 0, erros=0,lista negra= 0\n'),(435,9,432,'2021-09-28 11:58:05',2,3.05213,0,'Action completed, no processing required'),(436,17,0,'2021-09-28 11:58:10',0,0,0,'Run mode: GLPI'),(437,17,436,'2021-09-28 11:58:10',2,0.27514,0,'Action completed, no processing required'),(438,22,0,'2021-09-28 11:58:12',0,0,0,'Run mode: GLPI'),(439,22,438,'2021-09-28 11:58:12',2,1.83286,1,'Action completed, fully processed'),(440,21,0,'2021-09-28 11:58:16',0,0,0,'Run mode: GLPI'),(441,21,440,'2021-09-28 11:58:16',2,0.301463,0,'Action completed, no processing required'),(442,13,0,'2021-09-28 11:58:18',0,0,0,'Run mode: GLPI'),(443,13,442,'2021-09-28 11:58:18',2,0.15034,0,'Action completed, no processing required'),(444,14,0,'2021-09-28 11:58:20',0,0,0,'Run mode: GLPI'),(445,14,444,'2021-09-28 11:58:20',2,0.125333,0,'Action completed, no processing required'),(446,20,0,'2021-09-28 11:58:22',0,0,0,'Run mode: GLPI'),(447,20,446,'2021-09-28 11:58:22',2,0.183467,0,'Action completed, no processing required'),(448,24,0,'2021-09-28 11:58:23',0,0,0,'Run mode: GLPI'),(449,24,448,'2021-09-28 11:58:23',2,0.15032,0,'Action completed, no processing required'),(450,15,0,'2021-09-28 11:58:25',0,0,0,'Run mode: GLPI'),(451,15,450,'2021-09-28 11:58:25',2,0.151518,0,'Action completed, no processing required'),(452,16,0,'2021-09-28 11:58:29',0,0,0,'Run mode: GLPI'),(453,16,452,'2021-09-28 11:58:29',2,0.158554,0,'Action completed, no processing required'),(454,32,0,'2021-09-28 11:58:32',0,0,0,'Run mode: GLPI'),(455,32,454,'2021-09-28 11:58:32',2,0.158825,0,'Action completed, no processing required'),(456,22,0,'2021-09-28 12:09:34',0,0,0,'Run mode: GLPI'),(457,22,456,'2021-09-28 12:09:34',2,0.183764,0,'Action completed, no processing required'),(458,22,0,'2021-09-28 12:09:36',0,0,0,'Run mode: GLPI'),(459,22,458,'2021-09-28 12:09:36',2,0.100355,0,'Action completed, no processing required'),(460,17,0,'2021-09-28 12:09:37',0,0,0,'Run mode: GLPI'),(461,17,460,'2021-09-28 12:09:37',2,0.0836279,0,'Action completed, no processing required'),(462,21,0,'2021-09-28 12:09:39',0,0,0,'Run mode: GLPI'),(463,21,462,'2021-09-28 12:09:39',2,0.0919881,0,'Action completed, no processing required'),(464,32,0,'2021-09-28 12:09:41',0,0,0,'Run mode: GLPI'),(465,32,464,'2021-09-28 12:09:41',2,0.108712,0,'Action completed, no processing required'),(466,9,0,'2021-09-28 12:09:42',0,0,0,'Run mode: GLPI'),(467,9,466,'2021-09-28 12:09:42',1,0.636534,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(468,9,466,'2021-09-28 12:09:42',1,3.98063,0,'Número de mensagens: disponível= 0 ,atualmente importado= 0 ,recuperado= 0,recusado= 0, erros=0,lista negra= 0\n'),(469,9,466,'2021-09-28 12:09:42',2,4.23283,0,'Action completed, no processing required'),(470,22,0,'2021-09-28 12:50:13',0,0,0,'Run mode: GLPI'),(471,22,470,'2021-09-28 12:50:13',2,0.133529,0,'Action completed, no processing required'),(472,17,0,'2021-09-28 12:52:02',0,0,0,'Run mode: GLPI'),(473,17,472,'2021-09-28 12:52:02',2,0.0837409,0,'Action completed, no processing required'),(474,21,0,'2021-09-28 12:52:04',0,0,0,'Run mode: GLPI'),(475,21,474,'2021-09-28 12:52:04',2,0.118077,0,'Action completed, no processing required'),(476,32,0,'2021-09-28 12:52:05',0,0,0,'Run mode: GLPI'),(477,32,476,'2021-09-28 12:52:05',2,0.125231,0,'Action completed, no processing required'),(478,9,0,'2021-09-28 12:52:07',0,0,0,'Run mode: GLPI'),(479,9,478,'2021-09-28 12:52:07',1,0.438446,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(480,9,478,'2021-09-28 12:52:07',1,8.27782,1,'Número de mensagens: disponível= 1 ,atualmente importado= 0 ,recuperado= 1,recusado= 0, erros=0,lista negra= 0\n'),(481,9,478,'2021-09-28 12:52:07',2,8.75205,1,'Action completed, fully processed'),(482,22,0,'2021-09-28 12:52:20',0,0,0,'Run mode: GLPI'),(483,22,482,'2021-09-28 12:52:20',2,1.40798,1,'Action completed, fully processed'),(484,22,0,'2021-09-28 13:18:08',0,0,0,'Run mode: GLPI'),(485,22,484,'2021-09-28 13:18:08',2,0.100325,0,'Action completed, no processing required'),(486,17,0,'2021-09-28 16:13:52',0,0,0,'Run mode: GLPI'),(487,17,486,'2021-09-28 16:13:52',2,0.075223,0,'Action completed, no processing required'),(488,21,0,'2021-09-28 16:18:59',0,0,0,'Run mode: GLPI'),(489,21,488,'2021-09-28 16:18:59',2,0.0515192,0,'Action completed, no processing required'),(490,21,0,'2021-09-28 16:19:01',0,0,0,'Run mode: GLPI'),(491,21,490,'2021-09-28 16:19:01',2,0.083569,0,'Action completed, no processing required'),(492,32,0,'2021-09-28 16:19:02',0,0,0,'Run mode: GLPI'),(493,32,492,'2021-09-28 16:19:02',2,0.0503809,0,'Action completed, no processing required'),(494,13,0,'2021-09-28 16:19:03',0,0,0,'Run mode: GLPI'),(495,13,494,'2021-09-28 16:19:03',2,0.0586162,0,'Action completed, no processing required'),(496,14,0,'2021-09-28 16:19:05',0,0,0,'Run mode: GLPI'),(497,14,496,'2021-09-28 16:19:05',2,0.0837851,0,'Action completed, no processing required'),(498,20,0,'2021-09-28 16:19:06',0,0,0,'Run mode: GLPI'),(499,20,498,'2021-09-28 16:19:06',2,0.133622,0,'Action completed, no processing required'),(500,24,0,'2021-09-28 16:19:07',0,0,0,'Run mode: GLPI'),(501,24,500,'2021-09-28 16:19:07',2,0.05035,0,'Action completed, no processing required'),(502,9,0,'2021-09-28 16:19:08',0,0,0,'Run mode: GLPI'),(503,9,502,'2021-09-28 16:19:08',1,0.468914,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(504,9,502,'2021-09-28 16:19:08',1,61.2183,0,'\n'),(505,9,502,'2021-09-28 16:19:08',2,61.2967,0,'Action completed, no processing required'),(506,22,0,'2021-09-28 16:21:13',0,0,0,'Run mode: GLPI'),(507,22,506,'2021-09-28 16:21:13',2,10.925,0,'Action completed, fully processed'),(508,5,0,'2021-09-28 16:21:29',0,0,0,'Run mode: GLPI'),(509,5,508,'2021-09-28 16:21:29',2,0.075315,0,'Action completed, no processing required'),(510,6,0,'2021-09-28 16:21:31',0,0,0,'Run mode: GLPI'),(511,6,510,'2021-09-28 16:21:31',2,0.05019,0,'Action completed, no processing required'),(512,12,0,'2021-09-28 16:21:33',0,0,0,'Run mode: GLPI'),(513,12,512,'2021-09-28 16:21:33',1,0.110891,9,'Limpar 9 arquivos de sessão criados a mais de 1440 segundos\n'),(514,12,512,'2021-09-28 16:21:33',2,0.177108,9,'Action completed, fully processed'),(515,18,0,'2021-09-28 16:21:34',0,0,0,'Run mode: GLPI'),(516,18,515,'2021-09-28 16:21:34',2,0.067039,0,'Action completed, no processing required'),(517,19,0,'2021-09-28 16:21:35',0,0,0,'Run mode: GLPI'),(518,19,517,'2021-09-28 16:21:35',2,0.0670419,0,'Action completed, fully processed'),(519,23,0,'2021-09-28 16:21:37',0,0,0,'Run mode: GLPI'),(520,23,519,'2021-09-28 16:21:37',2,0.0835869,0,'Action completed, no processing required'),(521,25,0,'2021-09-28 16:21:39',0,0,0,'Run mode: GLPI'),(522,25,521,'2021-09-28 16:21:39',2,0.309255,1,'Action completed, fully processed'),(523,17,0,'2021-09-28 16:21:41',0,0,0,'Run mode: GLPI'),(524,17,523,'2021-09-28 16:21:41',2,0.0670431,0,'Action completed, no processing required'),(525,22,0,'2021-09-29 18:41:49',0,0,0,'Run mode: GLPI'),(526,22,525,'2021-09-29 18:41:49',2,4.95781,1,'Action completed, fully processed'),(527,21,0,'2021-10-02 13:22:59',0,0,0,'Run mode: GLPI'),(528,21,527,'2021-10-02 13:22:59',2,2.12554,0,'Action completed, no processing required'),(529,32,0,'2021-10-04 20:01:09',0,0,0,'Run mode: GLPI'),(530,32,529,'2021-10-04 20:01:09',2,0.79998,0,'Action completed, no processing required'),(531,17,0,'2021-10-05 20:04:46',0,0,0,'Run mode: GLPI'),(532,17,531,'2021-10-05 20:04:46',2,0.499908,0,'Action completed, no processing required'),(533,9,0,'2021-10-05 20:05:10',0,0,0,'Run mode: GLPI'),(534,9,533,'2021-10-05 20:05:10',1,2.19837,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(535,9,533,'2021-10-05 20:05:10',1,11.0189,5,'Número de mensagens: disponível= 5 ,atualmente importado= 0 ,recuperado= 5,recusado= 3, erros=0,lista negra= 2\n'),(536,9,533,'2021-10-05 20:05:10',2,12.2358,5,'Action completed, fully processed'),(537,13,0,'2021-10-06 12:27:46',0,0,0,'Run mode: GLPI'),(538,13,537,'2021-10-06 12:27:46',2,0.733216,0,'Action completed, no processing required'),(539,14,0,'2021-10-13 12:40:06',0,0,0,'Run mode: GLPI'),(540,14,539,'2021-10-13 12:40:06',2,0.683157,0,'Action completed, no processing required'),(541,20,0,'2021-10-18 13:44:18',0,0,0,'Run mode: GLPI'),(542,20,541,'2021-10-18 13:44:18',2,2.29897,0,'Action completed, no processing required'),(543,24,0,'2021-10-19 16:27:23',0,0,0,'Run mode: GLPI'),(544,24,543,'2021-10-19 16:27:23',2,0.983283,0,'Action completed, no processing required'),(545,15,0,'2021-10-21 13:47:10',0,0,0,'Run mode: GLPI'),(546,15,545,'2021-10-21 13:47:10',2,0.525035,0,'Action completed, no processing required'),(547,16,0,'2021-10-25 12:05:37',0,0,0,'Run mode: GLPI'),(548,16,547,'2021-10-25 12:05:37',2,0.241751,0,'Action completed, no processing required'),(549,5,0,'2021-10-27 18:57:09',0,0,0,'Run mode: GLPI'),(550,5,549,'2021-10-27 18:57:09',2,0.708413,0,'Action completed, no processing required'),(551,6,0,'2021-11-26 22:00:36',0,0,0,'Run mode: GLPI'),(552,6,551,'2021-11-26 22:00:36',2,2.16706,0,'Action completed, no processing required'),(553,12,0,'2021-11-26 22:05:31',0,0,0,'Run mode: GLPI'),(554,12,553,'2021-11-26 22:05:31',1,4.00084,49,'Limpar 49 arquivos de sessão criados a mais de 1440 segundos\n'),(555,12,553,'2021-11-26 22:05:31',2,5.99574,49,'Action completed, fully processed'),(556,18,0,'2021-11-30 12:15:03',0,0,0,'Run mode: GLPI'),(557,18,556,'2021-11-30 12:15:03',2,1.37436,0,'Action completed, no processing required'),(558,19,0,'2021-12-17 17:02:26',0,0,0,'Run mode: GLPI'),(559,19,558,'2021-12-17 17:02:26',2,1.05106,0,'Action completed, fully processed'),(560,23,0,'2022-02-01 11:50:11',0,0,0,'Run mode: GLPI'),(561,23,560,'2022-02-01 11:50:11',2,2.74038,31,'Action completed, fully processed'),(562,25,0,'2022-05-26 17:18:10',0,0,0,'Run mode: GLPI'),(563,25,562,'2022-05-26 17:18:10',2,0.900151,0,'Action completed, no processing required'),(564,22,0,'2022-09-01 16:45:09',0,0,0,'Run mode: GLPI'),(565,22,564,'2022-09-01 16:45:09',2,6.49686,1,'Action completed, fully processed'),(566,21,0,'2022-09-01 16:45:21',0,0,0,'Run mode: GLPI'),(567,21,566,'2022-09-01 16:45:21',2,0.300007,0,'Action completed, no processing required'),(568,32,0,'2022-09-01 16:47:19',0,0,0,'Run mode: GLPI'),(569,32,568,'2022-09-01 16:47:19',2,0.183589,0,'Action completed, no processing required'),(570,17,0,'2022-09-01 16:47:27',0,0,0,'Run mode: GLPI'),(571,17,570,'2022-09-01 16:47:27',2,0.15016,0,'Action completed, no processing required'),(572,9,0,'2022-09-01 16:47:53',0,0,0,'Run mode: GLPI'),(573,9,572,'2022-09-01 16:47:53',1,1.02557,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(574,9,572,'2022-09-01 16:47:53',1,3.98033,1,'Número de mensagens: disponível= 1 ,atualmente importado= 0 ,recuperado= 1,recusado= 0, erros=0,lista negra= 1\n'),(575,9,572,'2022-09-01 16:47:53',2,4.94108,1,'Action completed, fully processed'),(576,13,0,'2022-09-01 18:08:54',0,0,0,'Run mode: GLPI'),(577,13,576,'2022-09-01 18:08:54',2,0.0752909,0,'Action completed, no processing required'),(578,14,0,'2022-09-01 18:50:58',0,0,0,'Run mode: GLPI'),(579,14,578,'2022-09-01 18:50:58',2,0.0837052,0,'Action completed, no processing required'),(580,20,0,'2022-09-05 17:18:07',0,0,0,'Run mode: GLPI'),(581,20,580,'2022-09-05 17:18:07',2,1.17455,0,'Action completed, no processing required'),(582,24,0,'2022-09-05 17:23:38',0,0,0,'Run mode: GLPI'),(583,24,582,'2022-09-05 17:23:38',2,0.116777,0,'Action completed, no processing required'),(584,15,0,'2022-09-05 17:28:05',0,0,0,'Run mode: GLPI'),(585,15,584,'2022-09-05 17:28:05',2,0.200241,0,'Action completed, no processing required'),(586,16,0,'2022-09-05 17:28:18',0,0,0,'Run mode: GLPI'),(587,16,586,'2022-09-05 17:28:18',2,0.12529,0,'Action completed, no processing required'),(588,5,0,'2022-09-05 17:28:50',0,0,0,'Run mode: GLPI'),(589,5,588,'2022-09-05 17:28:50',2,0.425241,0,'Action completed, no processing required'),(590,6,0,'2022-09-05 17:28:52',0,0,0,'Run mode: GLPI'),(591,6,590,'2022-09-05 17:28:52',2,0.108647,0,'Action completed, no processing required'),(592,12,0,'2022-09-05 17:29:01',0,0,0,'Run mode: GLPI'),(593,12,592,'2022-09-05 17:29:01',1,0.0676391,129,'Limpar 129 arquivos de sessão criados a mais de 1440 segundos\n'),(594,12,592,'2022-09-05 17:29:01',2,0.117587,129,'Action completed, fully processed'),(595,18,0,'2022-09-05 17:29:21',0,0,0,'Run mode: GLPI'),(596,18,595,'2022-09-05 17:29:21',2,0.141955,0,'Action completed, no processing required'),(597,19,0,'2022-09-05 17:30:27',0,0,0,'Run mode: GLPI'),(598,19,597,'2022-09-05 17:30:27',2,0.091882,0,'Action completed, fully processed'),(599,23,0,'2022-09-05 17:31:13',0,0,0,'Run mode: GLPI'),(600,23,599,'2022-09-05 17:31:13',2,0.441924,1,'Action completed, fully processed'),(601,25,0,'2022-09-05 17:32:04',0,0,0,'Run mode: GLPI'),(602,25,601,'2022-09-05 17:32:04',2,0.200096,0,'Action completed, no processing required'),(603,22,0,'2022-09-05 17:32:40',0,0,0,'Run mode: GLPI'),(604,22,603,'2022-09-05 17:32:40',2,1.52483,0,'Action completed, fully processed'),(605,21,0,'2022-09-05 17:36:11',0,0,0,'Run mode: GLPI'),(606,21,605,'2022-09-05 17:36:11',2,0.116892,0,'Action completed, no processing required'),(607,17,0,'2022-09-05 17:43:57',0,0,0,'Run mode: GLPI'),(608,17,607,'2022-09-05 17:43:57',2,0.158561,0,'Action completed, no processing required'),(609,32,0,'2022-09-05 17:44:00',0,0,0,'Run mode: GLPI'),(610,32,609,'2022-09-05 17:44:00',2,0.108654,0,'Action completed, no processing required'),(611,9,0,'2022-09-05 17:56:30',0,0,0,'Run mode: GLPI'),(612,9,611,'2022-09-05 17:56:30',1,0.82734,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(613,9,611,'2022-09-05 17:56:30',1,2.5028,0,'Número de mensagens: disponível= 0 ,atualmente importado= 0 ,recuperado= 0,recusado= 0, erros=0,lista negra= 0\n'),(614,9,611,'2022-09-05 17:56:30',2,2.73421,0,'Action completed, no processing required'),(615,13,0,'2022-09-05 18:01:55',0,0,0,'Run mode: GLPI'),(616,13,615,'2022-09-05 18:01:55',2,0.093245,0,'Action completed, no processing required'),(617,14,0,'2022-09-05 18:09:42',0,0,0,'Run mode: GLPI'),(618,14,617,'2022-09-05 18:09:42',2,0.084898,0,'Action completed, no processing required'),(619,22,0,'2022-09-05 18:11:42',0,0,0,'Run mode: GLPI'),(620,22,619,'2022-09-05 18:11:42',2,2.14091,0,'Action completed, fully processed'),(621,21,0,'2022-09-05 18:17:46',0,0,0,'Run mode: GLPI'),(622,21,621,'2022-09-05 18:17:46',2,0.383622,0,'Action completed, no processing required'),(623,17,0,'2022-09-05 18:21:08',0,0,0,'Run mode: GLPI'),(624,17,623,'2022-09-05 18:21:08',2,0.050302,0,'Action completed, no processing required'),(625,32,0,'2022-09-05 18:22:40',0,0,0,'Run mode: GLPI'),(626,32,625,'2022-09-05 18:22:40',2,0.0504198,0,'Action completed, no processing required'),(627,9,0,'2022-09-05 18:23:45',0,0,0,'Run mode: GLPI'),(628,9,627,'2022-09-05 18:23:45',1,0.303952,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(629,9,627,'2022-09-05 18:23:45',1,1.77861,0,'Número de mensagens: disponível= 0 ,atualmente importado= 0 ,recuperado= 0,recusado= 0, erros=0,lista negra= 0\n'),(630,9,627,'2022-09-05 18:23:45',2,2.01943,0,'Action completed, no processing required'),(631,22,0,'2022-09-05 18:30:43',0,0,0,'Run mode: GLPI'),(632,22,631,'2022-09-05 18:30:43',2,1.08306,0,'Action completed, fully processed'),(633,20,0,'2022-09-05 18:31:57',0,0,0,'Run mode: GLPI'),(634,20,633,'2022-09-05 18:31:57',2,0.100591,0,'Action completed, no processing required'),(635,21,0,'2022-09-05 18:41:51',0,0,0,'Run mode: GLPI'),(636,21,635,'2022-09-05 18:41:51',2,0.0669401,0,'Action completed, no processing required'),(637,24,0,'2022-09-05 18:44:00',0,0,0,'Run mode: GLPI'),(638,24,637,'2022-09-05 18:44:00',2,0.05883,0,'Action completed, no processing required'),(639,17,0,'2022-09-05 18:46:57',0,0,0,'Run mode: GLPI'),(640,17,639,'2022-09-05 18:46:57',2,0.0585639,0,'Action completed, no processing required'),(641,32,0,'2022-09-05 18:52:13',0,0,0,'Run mode: GLPI'),(642,32,641,'2022-09-05 18:52:13',2,0.0516741,0,'Action completed, no processing required'),(643,22,0,'2022-09-05 18:58:12',0,0,0,'Run mode: GLPI'),(644,22,643,'2022-09-05 18:58:12',2,0.0585952,0,'Action completed, no processing required'),(645,9,0,'2022-09-05 19:00:29',0,0,0,'Run mode: GLPI'),(646,9,645,'2022-09-05 19:00:29',1,0.352344,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(647,9,645,'2022-09-05 19:00:29',1,1.96555,0,'Número de mensagens: disponível= 0 ,atualmente importado= 0 ,recuperado= 0,recusado= 0, erros=0,lista negra= 0\n'),(648,9,645,'2022-09-05 19:00:29',2,2.19266,0,'Action completed, no processing required'),(649,21,0,'2022-09-05 19:08:16',0,0,0,'Run mode: GLPI'),(650,21,649,'2022-09-05 19:08:16',2,0.066915,0,'Action completed, no processing required'),(651,17,0,'2022-09-05 19:09:29',0,0,0,'Run mode: GLPI'),(652,17,651,'2022-09-05 19:09:29',2,0.0669479,0,'Action completed, no processing required'),(653,32,0,'2022-09-05 19:13:54',0,0,0,'Run mode: GLPI'),(654,32,653,'2022-09-05 19:13:54',2,0.0669529,0,'Action completed, no processing required'),(655,22,0,'2022-09-05 19:15:58',0,0,0,'Run mode: GLPI'),(656,22,655,'2022-09-05 19:15:58',2,0.066972,0,'Action completed, no processing required'),(657,13,0,'2022-09-05 19:19:38',0,0,0,'Run mode: GLPI'),(658,13,657,'2022-09-05 19:19:38',2,0.141818,0,'Action completed, no processing required'),(659,14,0,'2022-09-05 19:22:23',0,0,0,'Run mode: GLPI'),(660,14,659,'2022-09-05 19:22:23',2,0.067044,0,'Action completed, no processing required'),(661,9,0,'2022-09-05 19:24:52',0,0,0,'Run mode: GLPI'),(662,9,661,'2022-09-05 19:24:52',1,0.30216,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(663,9,661,'2022-09-05 19:24:52',1,1.87006,0,'Número de mensagens: disponível= 0 ,atualmente importado= 0 ,recuperado= 0,recusado= 0, erros=0,lista negra= 0\n'),(664,9,661,'2022-09-05 19:24:52',2,2.10248,0,'Action completed, no processing required'),(665,21,0,'2022-09-05 19:30:10',0,0,0,'Run mode: GLPI'),(666,21,665,'2022-09-05 19:30:10',2,0.0502501,0,'Action completed, no processing required'),(667,17,0,'2022-09-05 19:35:48',0,0,0,'Run mode: GLPI'),(668,17,667,'2022-09-05 19:35:48',2,0.425424,0,'Action completed, no processing required'),(669,22,0,'2022-09-05 19:35:55',0,0,0,'Run mode: GLPI'),(670,22,669,'2022-09-05 19:35:55',2,0.0502331,0,'Action completed, no processing required'),(671,32,0,'2022-09-05 19:37:40',0,0,0,'Run mode: GLPI'),(672,32,671,'2022-09-05 19:37:40',2,0.141974,0,'Action completed, no processing required'),(673,20,0,'2022-09-05 19:40:49',0,0,0,'Run mode: GLPI'),(674,20,673,'2022-09-05 19:40:49',2,0.0670781,0,'Action completed, no processing required'),(675,9,0,'2022-09-05 19:43:56',0,0,0,'Run mode: GLPI'),(676,9,675,'2022-09-05 19:43:56',1,0.387114,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(677,9,675,'2022-09-05 19:43:56',1,1.76903,0,'Número de mensagens: disponível= 0 ,atualmente importado= 0 ,recuperado= 0,recusado= 0, erros=0,lista negra= 0\n'),(678,9,675,'2022-09-05 19:43:56',2,1.99415,0,'Action completed, no processing required'),(679,21,0,'2022-09-05 19:47:03',0,0,0,'Run mode: GLPI'),(680,21,679,'2022-09-05 19:47:03',2,0.0669661,0,'Action completed, no processing required'),(681,22,0,'2022-09-05 19:47:12',0,0,0,'Run mode: GLPI'),(682,22,681,'2022-09-05 19:47:12',2,0.0668859,0,'Action completed, no processing required'),(683,17,0,'2022-09-05 19:47:43',0,0,0,'Run mode: GLPI'),(684,17,683,'2022-09-05 19:47:43',2,0.066992,0,'Action completed, no processing required'),(685,32,0,'2022-09-05 19:52:20',0,0,0,'Run mode: GLPI'),(686,32,685,'2022-09-05 19:52:20',2,0.0599098,0,'Action completed, no processing required'),(687,24,0,'2022-09-05 19:52:41',0,0,0,'Run mode: GLPI'),(688,24,687,'2022-09-05 19:52:41',2,0.108564,0,'Action completed, no processing required'),(689,22,0,'2022-09-05 20:34:54',0,0,0,'Run mode: GLPI'),(690,22,689,'2022-09-05 20:34:54',2,0.118331,0,'Action completed, no processing required'),(691,17,0,'2022-09-06 12:20:51',0,0,0,'Run mode: GLPI'),(692,17,691,'2022-09-06 12:20:51',2,0.224992,0,'Action completed, no processing required'),(693,21,0,'2022-09-06 12:21:29',0,0,0,'Run mode: GLPI'),(694,21,693,'2022-09-06 12:21:29',2,0.133796,0,'Action completed, no processing required'),(695,9,0,'2022-09-06 12:26:33',0,0,0,'Run mode: GLPI'),(696,9,695,'2022-09-06 12:26:33',1,1.45431,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(697,9,695,'2022-09-06 12:26:33',1,3.18785,0,'Número de mensagens: disponível= 0 ,atualmente importado= 0 ,recuperado= 0,recusado= 0, erros=0,lista negra= 0\n'),(698,9,695,'2022-09-06 12:26:33',2,3.76014,0,'Action completed, no processing required'),(699,32,0,'2022-09-06 12:35:35',0,0,0,'Run mode: GLPI'),(700,32,699,'2022-09-06 12:35:35',2,0.150209,0,'Action completed, no processing required'),(701,13,0,'2022-09-06 12:40:15',0,0,0,'Run mode: GLPI'),(702,13,701,'2022-09-06 12:40:15',2,0.145362,0,'Action completed, no processing required'),(703,14,0,'2022-09-06 12:40:20',0,0,0,'Run mode: GLPI'),(704,14,703,'2022-09-06 12:40:20',2,0.100212,0,'Action completed, no processing required'),(705,22,0,'2022-09-06 12:48:29',0,0,0,'Run mode: GLPI'),(706,22,705,'2022-09-06 12:48:29',2,1.13332,1,'Action completed, fully processed'),(707,20,0,'2022-09-06 12:49:35',0,0,0,'Run mode: GLPI'),(708,20,707,'2022-09-06 12:49:35',2,0.150186,0,'Action completed, no processing required'),(709,24,0,'2022-09-06 12:54:30',0,0,0,'Run mode: GLPI'),(710,24,709,'2022-09-06 12:54:30',2,0.0918632,0,'Action completed, no processing required'),(711,15,0,'2022-09-06 12:55:04',0,0,0,'Run mode: GLPI'),(712,15,711,'2022-09-06 12:55:04',2,0.108529,0,'Action completed, no processing required'),(713,16,0,'2022-09-06 12:58:54',0,0,0,'Run mode: GLPI'),(714,16,713,'2022-09-06 12:58:54',2,0.050246,0,'Action completed, no processing required'),(715,17,0,'2022-09-06 13:04:41',0,0,0,'Run mode: GLPI'),(716,17,715,'2022-09-06 13:04:41',2,0.066936,0,'Action completed, no processing required'),(717,21,0,'2022-09-06 13:05:55',0,0,0,'Run mode: GLPI'),(718,21,717,'2022-09-06 13:05:55',2,0.0835311,0,'Action completed, no processing required'),(719,9,0,'2022-09-06 13:06:58',0,0,0,'Run mode: GLPI'),(720,9,719,'2022-09-06 13:06:58',1,0.32853,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(721,9,719,'2022-09-06 13:06:58',1,4.71861,3,'Número de mensagens: disponível= 3 ,atualmente importado= 0 ,recuperado= 3,recusado= 0, erros=0,lista negra= 3\n'),(722,9,719,'2022-09-06 13:06:58',2,5.30752,3,'Action completed, fully processed'),(723,32,0,'2022-09-06 13:14:57',0,0,0,'Run mode: GLPI'),(724,32,723,'2022-09-06 13:14:57',2,0.066947,0,'Action completed, no processing required'),(725,22,0,'2022-09-06 13:15:30',0,0,0,'Run mode: GLPI'),(726,22,725,'2022-09-06 13:15:30',2,3.36682,3,'Action completed, fully processed'),(727,17,0,'2022-09-06 13:15:56',0,0,0,'Run mode: GLPI'),(728,17,727,'2022-09-06 13:15:56',2,0.0669949,0,'Action completed, no processing required'),(729,21,0,'2022-09-06 13:21:02',0,0,0,'Run mode: GLPI'),(730,21,729,'2022-09-06 13:21:02',2,0.050246,0,'Action completed, no processing required'),(731,9,0,'2022-09-06 13:22:45',0,0,0,'Run mode: GLPI'),(732,9,731,'2022-09-06 13:22:45',1,0.294834,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(733,9,731,'2022-09-06 13:22:45',1,2.54894,1,'Número de mensagens: disponível= 1 ,atualmente importado= 0 ,recuperado= 1,recusado= 0, erros=0,lista negra= 1\n'),(734,9,731,'2022-09-06 13:22:45',2,3.04199,1,'Action completed, fully processed'),(735,22,0,'2022-09-06 13:22:58',0,0,0,'Run mode: GLPI'),(736,22,735,'2022-09-06 13:22:58',2,0.0765309,0,'Action completed, no processing required'),(737,32,0,'2022-09-06 13:27:31',0,0,0,'Run mode: GLPI'),(738,32,737,'2022-09-06 13:27:31',2,0.058568,0,'Action completed, no processing required'),(739,17,0,'2022-09-06 13:29:39',0,0,0,'Run mode: GLPI'),(740,17,739,'2022-09-06 13:29:39',2,0.0587151,0,'Action completed, no processing required'),(741,22,0,'2022-09-06 13:30:28',0,0,0,'Run mode: GLPI'),(742,22,741,'2022-09-06 13:30:28',2,0.0670471,0,'Action completed, no processing required'),(743,21,0,'2022-09-06 13:31:19',0,0,0,'Run mode: GLPI'),(744,21,743,'2022-09-06 13:31:19',2,0.066972,0,'Action completed, no processing required'),(745,22,0,'2022-09-06 13:32:38',0,0,0,'Run mode: GLPI'),(746,22,745,'2022-09-06 13:32:38',2,0.0669549,0,'Action completed, no processing required'),(747,9,0,'2022-09-06 13:37:45',0,0,0,'Run mode: GLPI'),(748,9,747,'2022-09-06 13:37:45',1,0.376909,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(749,9,747,'2022-09-06 13:37:45',1,2.2026,0,'Número de mensagens: disponível= 0 ,atualmente importado= 0 ,recuperado= 0,recusado= 0, erros=0,lista negra= 0\n'),(750,9,747,'2022-09-06 13:37:45',2,2.4188,0,'Action completed, no processing required'),(751,32,0,'2022-09-06 13:38:20',0,0,0,'Run mode: GLPI'),(752,32,751,'2022-09-06 13:38:20',2,0.0502388,0,'Action completed, no processing required'),(753,22,0,'2022-09-06 13:43:07',0,0,0,'Run mode: GLPI'),(754,22,753,'2022-09-06 13:43:07',2,0.958423,1,'Action completed, fully processed'),(755,17,0,'2022-09-06 13:43:26',0,0,0,'Run mode: GLPI'),(756,17,755,'2022-09-06 13:43:26',2,0.0669272,0,'Action completed, no processing required'),(757,21,0,'2022-09-06 13:43:34',0,0,0,'Run mode: GLPI'),(758,21,757,'2022-09-06 13:43:34',2,0.0502729,0,'Action completed, no processing required'),(759,13,0,'2022-09-06 13:52:10',0,0,0,'Run mode: GLPI'),(760,13,759,'2022-09-06 13:52:10',2,0.058691,0,'Action completed, no processing required'),(761,14,0,'2022-09-06 13:53:05',0,0,0,'Run mode: GLPI'),(762,14,761,'2022-09-06 13:53:05',2,0.066843,0,'Action completed, no processing required'),(763,32,0,'2022-09-06 13:53:33',0,0,0,'Run mode: GLPI'),(764,32,763,'2022-09-06 13:53:33',2,0.0585041,0,'Action completed, no processing required'),(765,22,0,'2022-09-06 13:58:35',0,0,0,'Run mode: GLPI'),(766,22,765,'2022-09-06 13:58:35',2,1.98271,2,'Action completed, fully processed'),(767,9,0,'2022-09-06 13:58:54',0,0,0,'Run mode: GLPI'),(768,9,767,'2022-09-06 13:58:54',1,0.378317,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(769,9,767,'2022-09-06 13:58:54',1,4.13398,3,'Número de mensagens: disponível= 3 ,atualmente importado= 0 ,recuperado= 3,recusado= 0, erros=0,lista negra= 3\n'),(770,9,767,'2022-09-06 13:58:54',2,4.68237,3,'Action completed, fully processed'),(771,17,0,'2022-09-06 14:02:01',0,0,0,'Run mode: GLPI'),(772,17,771,'2022-09-06 14:02:01',2,0.0670359,0,'Action completed, no processing required'),(773,21,0,'2022-09-06 14:03:48',0,0,0,'Run mode: GLPI'),(774,21,773,'2022-09-06 14:03:48',2,0.142128,0,'Action completed, no processing required'),(775,20,0,'2022-09-06 14:05:44',0,0,0,'Run mode: GLPI'),(776,20,775,'2022-09-06 14:05:44',2,0.050302,0,'Action completed, no processing required'),(777,24,0,'2022-09-06 16:04:59',0,0,0,'Run mode: GLPI'),(778,24,777,'2022-09-06 16:04:59',2,0.108382,0,'Action completed, no processing required'),(779,32,0,'2022-09-06 16:09:27',0,0,0,'Run mode: GLPI'),(780,32,779,'2022-09-06 16:09:27',2,0.051595,0,'Action completed, no processing required'),(781,22,0,'2022-09-06 16:10:12',0,0,0,'Run mode: GLPI'),(782,22,781,'2022-09-06 16:10:12',2,0.0504129,0,'Action completed, no processing required'),(783,17,0,'2022-09-06 16:16:17',0,0,0,'Run mode: GLPI'),(784,17,783,'2022-09-06 16:16:17',2,0.0669692,0,'Action completed, no processing required'),(785,9,0,'2022-09-06 16:17:04',0,0,0,'Run mode: GLPI'),(786,9,785,'2022-09-06 16:17:04',1,0.478387,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(787,9,785,'2022-09-06 16:17:04',1,2.07678,0,'Número de mensagens: disponível= 0 ,atualmente importado= 0 ,recuperado= 0,recusado= 0, erros=0,lista negra= 0\n'),(788,9,785,'2022-09-06 16:17:04',2,2.29387,0,'Action completed, no processing required'),(789,21,0,'2022-09-06 16:21:05',0,0,0,'Run mode: GLPI'),(790,21,789,'2022-09-06 16:21:05',2,0.0502529,0,'Action completed, no processing required'),(791,13,0,'2022-09-06 16:29:27',0,0,0,'Run mode: GLPI'),(792,13,791,'2022-09-06 16:29:27',2,0.0502501,0,'Action completed, no processing required'),(793,14,0,'2022-09-06 16:29:39',0,0,0,'Run mode: GLPI'),(794,14,793,'2022-09-06 16:29:39',2,0.066987,0,'Action completed, no processing required'),(795,20,0,'2022-09-06 16:31:07',0,0,0,'Run mode: GLPI'),(796,20,795,'2022-09-06 16:31:07',2,0.0501699,0,'Action completed, no processing required'),(797,22,0,'2022-09-06 16:31:58',0,0,0,'Run mode: GLPI'),(798,22,797,'2022-09-06 16:31:58',2,0.050288,0,'Action completed, no processing required'),(799,32,0,'2022-09-06 16:32:13',0,0,0,'Run mode: GLPI'),(800,32,799,'2022-09-06 16:32:13',2,0.0585611,0,'Action completed, no processing required'),(801,17,0,'2022-09-06 16:34:32',0,0,0,'Run mode: GLPI'),(802,17,801,'2022-09-06 16:34:32',2,0.0584929,0,'Action completed, no processing required'),(803,21,0,'2022-09-06 16:36:16',0,0,0,'Run mode: GLPI'),(804,21,803,'2022-09-06 16:36:16',2,0.0502079,0,'Action completed, no processing required'),(805,9,0,'2022-09-06 16:38:50',0,0,0,'Run mode: GLPI'),(806,9,805,'2022-09-06 16:38:50',1,0.329467,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(807,9,805,'2022-09-06 16:38:50',1,2.65218,1,'Número de mensagens: disponível= 1 ,atualmente importado= 0 ,recuperado= 1,recusado= 0, erros=0,lista negra= 1\n'),(808,9,805,'2022-09-06 16:38:50',2,3.24307,1,'Action completed, fully processed'),(809,22,0,'2022-09-06 16:41:45',0,0,0,'Run mode: GLPI'),(810,22,809,'2022-09-06 16:41:45',2,5.51504,3,'Action completed, fully processed'),(811,32,0,'2022-09-06 17:43:32',0,0,0,'Run mode: GLPI'),(812,32,811,'2022-09-06 17:43:32',2,0.0753961,0,'Action completed, no processing required'),(813,17,0,'2022-09-06 18:28:56',0,0,0,'Run mode: GLPI'),(814,17,813,'2022-09-06 18:28:56',2,0.0502689,0,'Action completed, no processing required'),(815,21,0,'2022-09-06 19:54:42',0,0,0,'Run mode: GLPI'),(816,21,815,'2022-09-06 19:54:42',2,0.0502169,0,'Action completed, no processing required'),(817,22,0,'2022-09-06 20:25:45',0,0,0,'Run mode: GLPI'),(818,22,817,'2022-09-06 20:25:45',2,0.066987,0,'Action completed, no processing required'),(819,9,0,'2022-09-06 20:26:31',0,0,0,'Run mode: GLPI'),(820,9,819,'2022-09-06 20:26:31',1,0.327459,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(821,9,819,'2022-09-06 20:26:31',1,3.1488,1,'Número de mensagens: disponível= 1 ,atualmente importado= 0 ,recuperado= 1,recusado= 0, erros=0,lista negra= 1\n'),(822,9,819,'2022-09-06 20:26:31',2,3.61632,1,'Action completed, fully processed'),(823,24,0,'2022-09-06 20:32:09',0,0,0,'Run mode: GLPI'),(824,24,823,'2022-09-06 20:32:09',2,0.232968,0,'Action completed, no processing required'),(825,5,0,'2022-09-06 20:32:16',0,0,0,'Run mode: GLPI'),(826,5,825,'2022-09-06 20:32:16',2,0.0669031,0,'Action completed, no processing required'),(827,6,0,'2022-09-06 20:32:23',0,0,0,'Run mode: GLPI'),(828,6,827,'2022-09-06 20:32:23',2,0.0502818,0,'Action completed, no processing required'),(829,12,0,'2022-09-06 20:33:02',0,0,0,'Run mode: GLPI'),(830,12,829,'2022-09-06 20:33:02',1,0.0777202,46,'Limpar 46 arquivos de sessão criados a mais de 1440 segundos\n'),(831,12,829,'2022-09-06 20:33:02',2,0.134089,46,'Action completed, fully processed'),(832,13,0,'2022-09-06 20:36:17',0,0,0,'Run mode: GLPI'),(833,13,832,'2022-09-06 20:36:17',2,0.150115,0,'Action completed, no processing required'),(834,14,0,'2022-09-06 20:40:13',0,0,0,'Run mode: GLPI'),(835,14,834,'2022-09-06 20:40:13',2,0.058634,0,'Action completed, no processing required'),(836,18,0,'2022-09-06 20:42:13',0,0,0,'Run mode: GLPI'),(837,18,836,'2022-09-06 20:42:13',2,0.0668719,0,'Action completed, no processing required'),(838,19,0,'2022-09-06 20:45:29',0,0,0,'Run mode: GLPI'),(839,19,838,'2022-09-06 20:45:29',2,0.050329,0,'Action completed, fully processed'),(840,20,0,'2022-09-06 20:47:15',0,0,0,'Run mode: GLPI'),(841,20,840,'2022-09-06 20:47:15',2,0.0670311,0,'Action completed, no processing required'),(842,23,0,'2022-09-06 23:10:57',0,0,0,'Run mode: GLPI'),(843,23,842,'2022-09-06 23:10:57',2,0.0919931,0,'Action completed, no processing required'),(844,25,0,'2022-09-06 23:39:58',0,0,0,'Run mode: GLPI'),(845,25,844,'2022-09-06 23:39:58',2,0.0588031,0,'Action completed, no processing required'),(846,32,0,'2022-09-06 23:40:11',0,0,0,'Run mode: GLPI'),(847,32,846,'2022-09-06 23:40:11',2,0.0504441,0,'Action completed, no processing required'),(848,17,0,'2022-09-06 23:40:18',0,0,0,'Run mode: GLPI'),(849,17,848,'2022-09-06 23:40:18',2,0.0680499,0,'Action completed, no processing required'),(850,21,0,'2022-09-06 23:40:29',0,0,0,'Run mode: GLPI'),(851,21,850,'2022-09-06 23:40:29',2,0.0503759,0,'Action completed, no processing required'),(852,22,0,'2022-09-06 23:40:38',0,0,0,'Run mode: GLPI'),(853,22,852,'2022-09-06 23:40:38',2,4.03211,3,'Action completed, fully processed'),(854,9,0,'2022-09-06 23:48:56',0,0,0,'Run mode: GLPI'),(855,9,854,'2022-09-06 23:48:56',1,0.51037,0,'Collect mails from Seti - Abertura Chamados ({pop3.cnsystem.com.br/pop/ssl/novalidate-cert})\n'),(856,9,854,'2022-09-06 23:48:56',1,5.6277,4,'Número de mensagens: disponível= 4 ,atualmente importado= 0 ,recuperado= 4,recusado= 0, erros=0,lista negra= 4\n'),(857,9,854,'2022-09-06 23:48:56',2,6.34108,4,'Action completed, fully processed'),(858,24,0,'2022-09-07 00:01:53',0,0,0,'Run mode: GLPI'),(859,24,858,'2022-09-07 00:01:53',2,0.0834942,0,'Action completed, no processing required'),(860,13,0,'2022-09-07 16:09:36',0,0,0,'Run mode: GLPI'),(861,13,860,'2022-09-07 16:09:36',2,0.208516,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=39 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,'2022-09-06 20:32:00',NULL,NULL,NULL,NULL),(6,'Infocom','infocom',86400,NULL,1,1,3,0,24,30,'2022-09-06 20:32: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,'2022-09-06 23:48:00',NULL,NULL,'2021-09-27 14:00:35',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,'2022-09-06 20:33:00',NULL,NULL,NULL,NULL),(13,'CronTask','graph',3600,NULL,1,1,3,0,24,30,'2022-09-07 16:09:00',NULL,NULL,NULL,NULL),(14,'ReservationItem','reservation',3600,NULL,1,1,3,0,24,30,'2022-09-06 20:40:00',NULL,NULL,NULL,NULL),(15,'Ticket','closeticket',43200,NULL,1,1,3,0,24,30,'2022-09-06 12:55:00',NULL,NULL,NULL,NULL),(16,'Ticket','alertnotclosed',43200,NULL,1,1,3,0,24,30,'2022-09-06 12:58:00',NULL,NULL,NULL,NULL),(17,'SlaLevel_Ticket','slaticket',300,NULL,1,1,3,0,24,30,'2022-09-06 23:40:00',NULL,NULL,NULL,NULL),(18,'Ticket','createinquest',86400,NULL,1,1,3,0,24,30,'2022-09-06 20:42:00',NULL,NULL,NULL,NULL),(19,'CronTask','watcher',86400,NULL,1,1,3,0,24,30,'2022-09-06 20:45:00',NULL,NULL,NULL,NULL),(20,'TicketRecurrent','ticketrecurrent',3600,NULL,1,1,3,0,24,30,'2022-09-06 20:47:00',NULL,NULL,NULL,NULL),(21,'PlanningRecall','planningrecall',300,NULL,1,1,3,0,24,30,'2022-09-06 23:40:00',NULL,NULL,NULL,NULL),(22,'QueuedNotification','queuednotification',60,50,1,1,3,0,24,30,'2022-09-06 23:40:00',NULL,NULL,NULL,NULL),(23,'QueuedNotification','queuednotificationclean',86400,30,1,1,3,0,24,30,'2022-09-06 23:10:00',NULL,NULL,NULL,NULL),(24,'CronTask','temp',3600,NULL,1,1,3,0,24,30,'2022-09-07 00:01:00',NULL,NULL,NULL,NULL),(25,'MailCollector','mailgateerror',86400,NULL,1,1,3,0,24,30,'2022-09-06 23:39: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,'2022-09-06 23:40: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,'Domain','DomainsAlert',86400,NULL,1,2,3,0,24,30,NULL,NULL,NULL,NULL,NULL);

--
-- 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=4113 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `glpi_dashboards_items` VALUES (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\"}'),(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\"}'),(3496,1,'bn_count_Computer_4a315743-151c-40cb-a20b-762250668dac','bn_count_Computer',1,0,3,2,'{\"color\":\"#e69393\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_aa80d342f99a888146b582c5631dad71e0e4369c\"}'),(3497,1,'bn_count_Software_0690f524-e826-47a9-b50a-906451196b83','bn_count_Software',10,0,3,2,'{\"color\":\"#aaddac\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_4f55b4436b77914882b3de535950f53cb53c2c4b\"}'),(3498,1,'bn_count_Rack_c6502e0a-5991-46b4-a771-7f355137306b','bn_count_Rack',10,2,3,2,'{\"color\":\"#0e87a0\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_7a84144299bc4e28b4d10de1d42047f9ae7b945f\"}'),(3499,1,'bn_count_SoftwareLicense_e755fd06-283e-4479-ba35-2d548f8f8a90','bn_count_SoftwareLicense',4,2,3,2,'{\"color\":\"#27ab3c\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_f58cedf35f551f11b866d0113b5032320839bf71\"}'),(3500,1,'bn_count_Monitor_7059b94c-583c-4ba7-b100-d40461165318','bn_count_Monitor',4,0,3,2,'{\"color\":\"#b52d30\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_57d3ff67878bece20ab4f1a6b821ae2af6ae85bd\"}'),(3501,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\",\"cache_key\":\"dashboard_card_central_de038470ba7062e93c9141df0fd87bcef96aee12\"}'),(3502,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\",\"cache_key\":\"dashboard_card_central_c71131f636c81236f0c59d4578be4d179f8bedab\"}'),(3503,1,'count_Computer_Manufacturer_6129c451-42b5-489d-b693-c362adf32d49','count_Computer_Manufacturer',2,10,4,4,'{\"color\":\"#f8faf9\",\"widgettype\":\"donut\",\"use_gradient\":\"1\",\"limit\":\"5\",\"cache_key\":\"dashboard_card_central_69f3ca3e6a6732f7a74d6afdc8d2985f75e47eaa\"}'),(3504,1,'top_ticket_user_requester_c74f52a8-046a-4077-b1a6-c9f840d34b82','top_ticket_user_requester',14,10,5,4,'{\"color\":\"#f9fafb\",\"widgettype\":\"hbar\",\"use_gradient\":\"1\",\"limit\":\"5\",\"cache_key\":\"dashboard_card_central_df1743190170126b9ec297b185a326141e8d72f8\"}'),(3505,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\",\"cache_key\":\"dashboard_card_central_fd22ac94a3055ae1f79f1ab1a0504037ffba5d2c\"}'),(3506,1,'ticket_status_2e4e968b-d4e6-4e33-9ce9-a1aaff53dfde','ticket_status',14,0,12,6,'{\"color\":\"#fafafa\",\"widgettype\":\"stackedbars\",\"use_gradient\":\"0\",\"limit\":\"12\",\"cache_key\":\"dashboard_card_central_ddee1dd76d636002e69ce81108a226864512217f\"}'),(3507,1,'top_ticket_ITILCategory_37736ba9-d429-4cb3-9058-ef4d111d9269','top_ticket_ITILCategory',20,10,5,4,'{\"color\":\"#fbf9f9\",\"widgettype\":\"hbar\",\"use_gradient\":\"1\",\"limit\":\"5\",\"cache_key\":\"dashboard_card_central_161d8b0029d7721b994c5c1ceef4626975d57004\"}'),(3508,1,'bn_count_Printer_517684b0-b064-49dd-943e-fcb6f915e453','bn_count_Printer',7,0,3,2,'{\"color\":\"#365a8f\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_fd7324979d12fd46e3a01a8a0e0f5f97642500ca\"}'),(3509,1,'bn_count_Phone_f70c489f-02c1-46e5-978b-94a95b5038ee','bn_count_Phone',1,2,3,2,'{\"color\":\"#d5e1ec\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_556b76dba06243af144d7d14267d16e9cac23415\"}'),(3510,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\",\"cache_key\":\"dashboard_card_central_f2557c64c48855d423400e86757b77517bdbdbc3\"}'),(3511,1,'bn_count_Group_b84a93f2-a26c-49d7-82a4-5446697cc5b0','bn_count_Group',7,5,3,2,'{\"color\":\"#e0e0e0\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_974d7ad4d60e0cc00e1207d5aaa364a337460333\"}'),(3512,1,'bn_count_Profile_770b35e8-68e9-4b4f-9e09-5a11058f069f','bn_count_Profile',10,5,3,2,'{\"color\":\"#e0e0e0\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_f0d032fc32932657c8ec01718193095bab5bfb75\"}'),(3513,1,'bn_count_Supplier_36ff9011-e4cf-4d89-b9ab-346b9857d734','bn_count_Supplier',1,7,3,2,'{\"color\":\"#c9c9c9\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_cc4b7f059f37be766a4028d4396c6a5d62e14c69\"}'),(3514,1,'bn_count_KnowbaseItem_a3785a56-bed4-4a30-8387-f251f5365b3b','bn_count_KnowbaseItem',10,7,3,2,'{\"color\":\"#c9c9c9\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_4b69e9bde22f47b093baadf114103c0341496726\"}'),(3515,1,'bn_count_Entity_9b82951a-ba52-45cc-a2d3-1d238ec37adf','bn_count_Entity',1,5,3,2,'{\"color\":\"#f9f9f9\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_b3f0c4f96a0c04913986a7f7cf8c00d18548c962\"}'),(3516,1,'bn_count_Document_7dc7f4b8-61ff-4147-b994-5541bddd7b66','bn_count_Document',4,7,3,2,'{\"color\":\"#b4b4b4\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_fd791f163e422651b36379812a6d2a3c031b87d4\"}'),(3517,1,'bn_count_Project_4d412ee2-8b79-469b-995f-4c0a05ab849d','bn_count_Project',7,7,3,2,'{\"color\":\"#b3b3b3\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_feb6b00ce5e7006d6df7925726084f64a219235a\"}'),(3518,1,'bn_count_NetworkEquipment_c537e334-d584-43bc-b6de-b4a939143e89','bn_count_NetworkEquipment',7,2,3,2,'{\"color\":\"#bfe7ea\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_c3f289161fb18c8831b529119c1dbf7242c5ea28\"}'),(3519,1,'bn_count_User_ac0cbe52-3593-43c1-8ecc-0eb115de494d','bn_count_User',4,5,3,2,'{\"color\":\"#fafafa\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_821d5a3c0be640a5b665cafecc8f9e92a1a3097e\"}'),(3520,1,'count_Printer_Manufacturer_88ec7374-493e-4613-ba02-a40b9b76b969','count_Printer_Manufacturer',8,10,4,4,'{\"color\":\"#fafafa\",\"widgettype\":\"donut\",\"use_gradient\":\"0\",\"point_labels\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_9ba1cace77baa71dc2790ee2762bdaaa5ebfcf8c\"}'),(3521,5,'bn_count_Computerf1ca8f2d-890d-4dce-855a-90d99b651171','bn_count_Computer',1,0,3,2,'{\"color\":\"#e69393\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_aa80d342f99a888146b582c5631dad71e0e4369c\"}'),(3522,5,'bn_count_Softwareaf62ce56-2d8a-4696-9825-c261a8f39492','bn_count_Software',10,0,3,2,'{\"color\":\"#aaddac\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_4f55b4436b77914882b3de535950f53cb53c2c4b\"}'),(3523,5,'bn_count_Rack1288b5c1-c004-42fc-a441-d459ff39e355','bn_count_Rack',10,2,3,2,'{\"color\":\"#0e87a0\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_7a84144299bc4e28b4d10de1d42047f9ae7b945f\"}'),(3524,5,'bn_count_SoftwareLicense60704e97-c52d-4e7b-a1b8-83b0927fb910','bn_count_SoftwareLicense',4,2,3,2,'{\"color\":\"#27ab3c\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_f58cedf35f551f11b866d0113b5032320839bf71\"}'),(3525,5,'bn_count_Monitora9d65c29-9d88-4cb0-9414-909dec5a6b92','bn_count_Monitor',4,0,3,2,'{\"color\":\"#b52d30\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_57d3ff67878bece20ab4f1a6b821ae2af6ae85bd\"}'),(3526,5,'bn_count_Ticket8cc13e0b-3336-4476-90a3-5cd5a4c516f2','bn_count_Ticket',14,7,3,2,'{\"color\":\"#ffdc64\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_de038470ba7062e93c9141df0fd87bcef96aee12\"}'),(3527,5,'bn_count_Problem6afee180-cb06-43e9-ab50-f78eb15c274d','bn_count_Problem',20,7,3,2,'{\"color\":\"#f08d7b\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_c71131f636c81236f0c59d4578be4d179f8bedab\"}'),(3528,5,'count_Computer_Manufacturerd0fd70aa-6789-408c-8023-7b73bbdde8f8','count_Computer_Manufacturer',2,10,4,4,'{\"color\":\"#f8faf9\",\"widgettype\":\"donut\",\"use_gradient\":\"1\",\"limit\":\"5\",\"cache_key\":\"dashboard_card_central_69f3ca3e6a6732f7a74d6afdc8d2985f75e47eaa\"}'),(3529,5,'top_ticket_user_requester821f8301-3a0b-4488-9a87-bf1fc9631f44','top_ticket_user_requester',14,10,5,4,'{\"color\":\"#f9fafb\",\"widgettype\":\"hbar\",\"use_gradient\":\"1\",\"limit\":\"5\",\"cache_key\":\"dashboard_card_central_df1743190170126b9ec297b185a326141e8d72f8\"}'),(3530,5,'bn_count_tickets_lateeff1baa8-95da-453e-a9f6-d4d8c291d527','bn_count_tickets_late',17,7,3,2,'{\"color\":\"#f8911f\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_fd22ac94a3055ae1f79f1ab1a0504037ffba5d2c\"}'),(3531,5,'ticket_status84264ae7-c30e-43ad-baf2-3c48126a6cb3','ticket_status',14,0,12,6,'{\"color\":\"#fafafa\",\"widgettype\":\"stackedbars\",\"use_gradient\":\"0\",\"limit\":\"12\",\"cache_key\":\"dashboard_card_central_ddee1dd76d636002e69ce81108a226864512217f\"}'),(3532,5,'top_ticket_ITILCategory5e269dc2-4dd8-433b-bff9-d3685120b7fa','top_ticket_ITILCategory',20,10,5,4,'{\"color\":\"#fbf9f9\",\"widgettype\":\"hbar\",\"use_gradient\":\"1\",\"limit\":\"5\",\"cache_key\":\"dashboard_card_central_161d8b0029d7721b994c5c1ceef4626975d57004\"}'),(3533,5,'bn_count_Printerf86d086e-39c6-485e-9387-209adf055d18','bn_count_Printer',7,0,3,2,'{\"color\":\"#365a8f\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_fd7324979d12fd46e3a01a8a0e0f5f97642500ca\"}'),(3534,5,'bn_count_Phone7c860f5a-883a-4f43-ab63-da715d599bb8','bn_count_Phone',1,2,3,2,'{\"color\":\"#d5e1ec\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_556b76dba06243af144d7d14267d16e9cac23415\"}'),(3535,5,'bn_count_Changef428e55f-e61b-479d-841d-248b76d506d4','bn_count_Change',23,7,3,2,'{\"color\":\"#cae3c4\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_f2557c64c48855d423400e86757b77517bdbdbc3\"}'),(3536,5,'bn_count_Group1361bfd6-5850-4064-bc30-284243304137','bn_count_Group',7,5,3,2,'{\"color\":\"#e0e0e0\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_974d7ad4d60e0cc00e1207d5aaa364a337460333\"}'),(3537,5,'bn_count_Profile5f062a74-30d5-48f3-8cc9-b4a50302800e','bn_count_Profile',10,5,3,2,'{\"color\":\"#e0e0e0\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_f0d032fc32932657c8ec01718193095bab5bfb75\"}'),(3538,5,'bn_count_Supplier4ddec281-0420-46e7-adfa-7e46621a8b58','bn_count_Supplier',1,7,3,2,'{\"color\":\"#c9c9c9\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_cc4b7f059f37be766a4028d4396c6a5d62e14c69\"}'),(3539,5,'bn_count_KnowbaseItem02e48a15-d21b-4b48-b31d-a19f6d85d738','bn_count_KnowbaseItem',10,7,3,2,'{\"color\":\"#c9c9c9\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_4b69e9bde22f47b093baadf114103c0341496726\"}'),(3540,5,'bn_count_Entitye76d736b-d1b0-4c04-bbd5-26d1a8d4ae41','bn_count_Entity',1,5,3,2,'{\"color\":\"#f9f9f9\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_b3f0c4f96a0c04913986a7f7cf8c00d18548c962\"}'),(3541,5,'bn_count_Documentbe0a5853-00f8-4327-a278-ccf45417c670','bn_count_Document',4,7,3,2,'{\"color\":\"#b4b4b4\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_fd791f163e422651b36379812a6d2a3c031b87d4\"}'),(3542,5,'bn_count_Projectab46a8c1-54f8-410c-bd5d-8f28a1354d0c','bn_count_Project',7,7,3,2,'{\"color\":\"#b3b3b3\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_feb6b00ce5e7006d6df7925726084f64a219235a\"}'),(3543,5,'bn_count_NetworkEquipment24052c18-ddfb-46bd-9384-fd1f9c875285','bn_count_NetworkEquipment',7,2,3,2,'{\"color\":\"#bfe7ea\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_c3f289161fb18c8831b529119c1dbf7242c5ea28\"}'),(3544,5,'bn_count_Userc9d731e3-e427-420c-a142-28f5ba0a8570','bn_count_User',4,5,3,2,'{\"color\":\"#fafafa\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_821d5a3c0be640a5b665cafecc8f9e92a1a3097e\"}'),(3545,5,'count_Printer_Manufactureread50768-1f82-4c86-b9c8-38ae29380193','count_Printer_Manufacturer',8,10,4,4,'{\"color\":\"#fafafa\",\"widgettype\":\"donut\",\"use_gradient\":\"0\",\"point_labels\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_central_9ba1cace77baa71dc2790ee2762bdaaa5ebfcf8c\"}'),(4101,3,'bn_count_Ticket_344e761b-f7e8-4617-8c90-154b266b4d67','bn_count_Ticket',0,0,4,3,'{\"color\":\"#ffdc64\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_assistance_6e8d7d134878913efb52d0855669ffd4dcb6aa74\"}'),(4102,3,'bn_count_Problem_bdb4002b-a674-4493-820f-af85bed44d2a','bn_count_Problem',0,3,3,2,'{\"color\":\"#f0967b\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_assistance_8982628720fb5e0b9d4db4f098fbe1334130c782\"}'),(4103,3,'bn_count_Change_b9b87513-4f40-41e6-8621-f51f9a30fb19','bn_count_Change',0,5,3,2,'{\"color\":\"#cae3c4\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_assistance_ded33bace5488b3e72e9dad869f6f616cacdd894\"}'),(4104,3,'bn_count_tickets_late_1e9ae481-21b4-4463-a830-dec1b68ec5e7','bn_count_tickets_late',3,3,3,2,'{\"color\":\"#f8911f\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_assistance_fff6f1fb4472351aed9fefca3e537fb4e3537646\"}'),(4105,3,'bn_count_tickets_closed_e004bab5-f2b6-4060-a401-a2a8b9885245','bn_count_tickets_closed',6,3,3,2,'{\"color\":\"#515151\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_assistance_78241a71e0b2ae2583d494a024f69f821119484c\"}'),(4106,3,'bn_count_tickets_solved_5e9759b3-ee7e-4a14-b68f-1ac024ef55ee','bn_count_tickets_solved',8,0,4,3,'{\"color\":\"#d8d8d8\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_assistance_d5a52d16c178e8fa82592059d8d516efea51d8fa\"}'),(4107,3,'bn_count_tickets_waiting_102b2c2a-6ac6-4d73-ba47-8b09382fe00e','bn_count_tickets_waiting',3,5,3,2,'{\"color\":\"#ffcb7d\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_assistance_52f1fe68c204baaefcb5e445d9d6348fa0834671\"}'),(4108,3,'bn_count_TicketRecurrent_13f79539-61f6-45f7-8dde-045706e652f2','bn_count_TicketRecurrent',9,3,3,2,'{\"color\":\"#fafafa\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_assistance_044d5257959472497a1bfcaaee9cd5f44f44e92d\"}'),(4109,3,'bn_count_tickets_planned_267bf627-9d5e-4b6c-b53d-b8623d793ccf','bn_count_tickets_planned',6,5,3,2,'{\"color\":\"#6298d5\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_assistance_ce0cf57723122690ed98666445e46744adaf95e9\"}'),(4110,3,'top_ticket_ITILCategory_0cba0c84-6c62-4cd8-8564-18614498d8e4','top_ticket_ITILCategory',9,5,3,2,'{\"color\":\"#f1f5ef\",\"widgettype\":\"donut\",\"use_gradient\":\"1\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_assistance_872437deb923fdc4f4566addc5c21f5624e90078\"}'),(4111,3,'ticket_evolution_76fd4926-ee5e-48db-b6d6-e2947c190c5e','ticket_evolution',12,0,14,6,'{\"color\":\"#f3f7f8\",\"widgettype\":\"areas\",\"use_gradient\":\"0\",\"limit\":\"12\",\"cache_key\":\"dashboard_card_assistance_7e46236a881ad2adefc4b42d37432ea2f46ad061\"}'),(4112,3,'bn_count_tickets_incoming_f04821d6-a442-47ff-9ffa-4381152ac9cc','bn_count_tickets_incoming',4,0,4,3,'{\"color\":\"#a0e19d\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\",\"cache_key\":\"dashboard_card_assistance_5c83c18f8756f127c6d8240d62be3af1b42d6202\",\"point_labels\":\"0\"}');

--
-- 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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `glpi_dashboards_rights` VALUES (2,3,'Profile',6);

--
-- 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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- 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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- 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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- 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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- 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=4 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);

--
-- 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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- 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=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `glpi_deviceharddrives` VALUES (1,'SSD 240GB','',0,'','',0,0,1,0,0,'2021-07-15 13:37:13','2021-07-15 13:37:13'),(2,'SSD 120GB','',0,'','',0,0,1,0,0,'2021-07-15 13:37:20','2021-07-15 13:37:20'),(3,'HD 1TB','',0,'','',0,0,1,0,0,'2021-07-15 13:37:33','2021-07-15 13:37:33'),(4,'HD 500GB','',0,'','',0,0,1,0,0,'2021-07-15 13:37:46','2021-07-15 13:37:46'),(5,'HD 250GB','',0,'','',0,0,1,0,0,'2021-07-20 18:34:09','2021-07-20 18:34:09');

--
-- 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=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `glpi_devicememories` VALUES (1,'4 GB','','',0,4000,2,1,0,0,'2021-07-15 13:48:28','2021-07-15 13:36:42'),(2,'8 GB','','',0,8000,2,1,0,0,'2021-07-15 13:48:07','2021-07-15 13:36:46'),(3,'3 GB','','',0,3000,0,1,0,0,'2021-07-20 18:57:11','2021-07-20 18:56:59');

--
-- 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=5 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);

--
-- 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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- 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=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `glpi_deviceprocessors` VALUES (1,'Ryzen 5 3400G',0,'',5,0,0,0,1,0,0,'2021-07-15 13:35:19','2021-07-15 13:35:19'),(2,'Intel Core i5 8250',0,'',6,0,0,0,1,0,0,'2021-07-15 13:35:53','2021-07-15 13:35:53'),(3,'Intel Core i5 10400',0,'',6,0,0,0,1,0,0,'2021-07-15 13:36:20','2021-07-15 13:36:20'),(4,'Intel Core i5 3330',0,'',6,0,0,0,1,0,0,'2021-07-20 18:34:56','2021-07-20 18:34:45'),(5,'Intel Pentium 2140',0,'',6,0,0,0,1,0,0,'2021-07-20 18:56:46','2021-07-20 18:56:46');

--
-- 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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- 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=260 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,5,0),(5,'Computer',23,3,0),(6,'DocumentType',3,1,0),(7,'Monitor',31,2,0),(8,'Monitor',23,3,0),(9,'Monitor',3,7,0),(10,'Monitor',4,6,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),(18,'Software',23,1,0),(19,'CartridgeItem',4,2,0),(20,'CartridgeItem',34,1,0),(21,'Peripheral',3,3,0),(22,'Peripheral',23,2,0),(23,'Peripheral',31,1,0),(24,'Computer',31,2,0),(25,'Computer',3,7,0),(26,'Computer',19,8,0),(27,'Computer',17,9,0),(28,'NetworkEquipment',3,3,0),(29,'NetworkEquipment',4,4,0),(30,'NetworkEquipment',11,6,0),(31,'NetworkEquipment',19,7,0),(32,'Printer',4,4,0),(33,'Printer',19,6,0),(34,'Monitor',19,8,0),(35,'Monitor',7,1,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),(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),(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),(251,'Computer',7,1,0),(254,'Printer',7,7,0),(255,'User',9,1,0),(256,'Computer',46,6,0),(257,'Software',3,3,0),(258,'Software',60,4,0),(259,'Monitor',11,4,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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

