-- Table structure for table `glpi_plugin_ocsinventoryng_ocsservers_profiles`
--

CREATE TABLE `glpi_plugin_ocsinventoryng_ocsservers_profiles` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `plugin_ocsinventoryng_ocsservers_id` int unsigned NOT NULL DEFAULT '0',
  `profiles_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `plugin_ocsinventoryng_ocsservers_id` (`plugin_ocsinventoryng_ocsservers_id`),
  KEY `profiles_id` (`profiles_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_ocsinventoryng_ocsservers_profiles`
--

INSERT INTO `glpi_plugin_ocsinventoryng_ocsservers_profiles` VALUES (1,1,4),(2,2,4),(3,1,9);

--
-- Table structure for table `glpi_plugin_ocsinventoryng_osinstalls`
--

CREATE TABLE `glpi_plugin_ocsinventoryng_osinstalls` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `computers_id` int unsigned NOT NULL DEFAULT '0',
  `build_version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `install_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `codeset` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `countrycode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `oslanguage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `curtimezone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `computers_id` (`computers_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_ocsinventoryng_osinstalls`
--


--
-- Table structure for table `glpi_plugin_ocsinventoryng_proxysettings`
--

CREATE TABLE `glpi_plugin_ocsinventoryng_proxysettings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `computers_id` int unsigned NOT NULL DEFAULT '0',
  `user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enabled` int NOT NULL DEFAULT '0',
  `autoconfigurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `override` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `computers_id` (`computers_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_ocsinventoryng_proxysettings`
--


--
-- Table structure for table `glpi_plugin_ocsinventoryng_registrykeys`
--

CREATE TABLE `glpi_plugin_ocsinventoryng_registrykeys` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `computers_id` int unsigned NOT NULL DEFAULT '0',
  `hive` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ocs_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `computers_id` (`computers_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_ocsinventoryng_registrykeys`
--


--
-- Table structure for table `glpi_plugin_ocsinventoryng_ruleimportentities`
--

CREATE TABLE `glpi_plugin_ocsinventoryng_ruleimportentities` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_ocsinventoryng_ruleimportentities`
--


--
-- Table structure for table `glpi_plugin_ocsinventoryng_runningprocesses`
--

CREATE TABLE `glpi_plugin_ocsinventoryng_runningprocesses` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `computers_id` int unsigned NOT NULL DEFAULT '0',
  `cpuusage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tty` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `started` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `virtualmemory` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `processname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `processid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `processmemory` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `commandline` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `computers_id` (`computers_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_ocsinventoryng_runningprocesses`
--


--
-- Table structure for table `glpi_plugin_ocsinventoryng_servers`
--

CREATE TABLE `glpi_plugin_ocsinventoryng_servers` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `plugin_ocsinventoryng_ocsservers_id` int unsigned NOT NULL DEFAULT '0',
  `max_ocsid` int DEFAULT NULL,
  `max_glpidate` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `plugin_ocsinventoryng_ocsservers_id` (`plugin_ocsinventoryng_ocsservers_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_ocsinventoryng_servers`
--


--
-- Table structure for table `glpi_plugin_ocsinventoryng_services`
--

CREATE TABLE `glpi_plugin_ocsinventoryng_services` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `computers_id` int unsigned NOT NULL DEFAULT '0',
  `svcname` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `svcdn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `svcstate` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `svcdesc` varchar(1536) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `svcstartmode` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `svcpath` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `svcstartname` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `svcexitcode` int DEFAULT NULL,
  `svcspecexitcode` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `computers_id` (`computers_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_ocsinventoryng_services`
--


--
-- Table structure for table `glpi_plugin_ocsinventoryng_snmpocslinks`
--

CREATE TABLE `glpi_plugin_ocsinventoryng_snmpocslinks` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `items_id` int unsigned NOT NULL DEFAULT '0',
  `ocs_id` int unsigned NOT NULL DEFAULT '0',
  `itemtype` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_update` timestamp NULL DEFAULT NULL,
  `plugin_ocsinventoryng_ocsservers_id` int unsigned NOT NULL DEFAULT '0',
  `linked` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `plugin_ocsinventoryng_ocsservers_id` (`plugin_ocsinventoryng_ocsservers_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_ocsinventoryng_snmpocslinks`
--


--
-- Table structure for table `glpi_plugin_ocsinventoryng_teamviewers`
--

CREATE TABLE `glpi_plugin_ocsinventoryng_teamviewers` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `computers_id` int unsigned NOT NULL DEFAULT '0',
  `twid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `computers_id` (`computers_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_ocsinventoryng_teamviewers`
--


--
-- Table structure for table `glpi_plugin_ocsinventoryng_threads`
--

CREATE TABLE `glpi_plugin_ocsinventoryng_threads` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `threadid` int NOT NULL DEFAULT '0',
  `start_time` timestamp NULL DEFAULT NULL,
  `end_time` timestamp NULL DEFAULT NULL,
  `status` int NOT NULL DEFAULT '0',
  `error_msg` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `imported_machines_number` int NOT NULL DEFAULT '0',
  `synchronized_machines_number` int NOT NULL DEFAULT '0',
  `failed_rules_machines_number` int NOT NULL DEFAULT '0',
  `linked_machines_number` int NOT NULL DEFAULT '0',
  `notupdated_machines_number` int NOT NULL DEFAULT '0',
  `not_unique_machines_number` int NOT NULL DEFAULT '0',
  `link_refused_machines_number` int NOT NULL DEFAULT '0',
  `total_number_machines` int NOT NULL DEFAULT '0',
  `plugin_ocsinventoryng_ocsservers_id` int unsigned NOT NULL DEFAULT '1',
  `processid` int NOT NULL DEFAULT '0',
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `rules_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `end_time` (`end_time`),
  KEY `process_thread` (`processid`,`threadid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_ocsinventoryng_threads`
--


--
-- Table structure for table `glpi_plugin_ocsinventoryng_winupdates`
--

CREATE TABLE `glpi_plugin_ocsinventoryng_winupdates` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `computers_id` int unsigned NOT NULL DEFAULT '0',
  `auoptions` int NOT NULL DEFAULT '0',
  `scheduleinstalldate` timestamp NULL DEFAULT NULL,
  `lastsuccesstime` timestamp NULL DEFAULT NULL,
  `detectsuccesstime` timestamp NULL DEFAULT NULL,
  `downloadsuccesstime` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `computers_id` (`computers_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_ocsinventoryng_winupdates`
--


--
-- Table structure for table `glpi_plugin_ocsinventoryng_winusers`
--

CREATE TABLE `glpi_plugin_ocsinventoryng_winusers` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `computers_id` int unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `disabled` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `computers_id` (`computers_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_ocsinventoryng_winusers`
--


--
-- Table structure for table `glpi_plugin_pdf_configs`
--

CREATE TABLE `glpi_plugin_pdf_configs` (
  `id` int unsigned NOT NULL,
  `currency` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_pdf_configs`
--

INSERT INTO `glpi_plugin_pdf_configs` VALUES (1,'COP','2020-03-09 20:46:38');

--
-- Table structure for table `glpi_plugin_pdf_preferences`
--

CREATE TABLE `glpi_plugin_pdf_preferences` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `users_id` int unsigned NOT NULL,
  `itemtype` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'see define.php *_TYPE constant',
  `tabref` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'ref of tab to display, or plugname_#, or option name',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_pdf_preferences`
--


--
-- Table structure for table `glpi_plugin_resources_budgets`
--

CREATE TABLE `glpi_plugin_resources_budgets` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plugin_resources_professions_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_ranks_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_budgettypes_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_budgetvolumes_id` int unsigned NOT NULL DEFAULT '0',
  `begin_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `volume` int NOT NULL DEFAULT '0',
  `date_mod` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `plugin_resources_professions_id` (`plugin_resources_professions_id`),
  KEY `plugin_resources_ranks_id` (`plugin_resources_ranks_id`),
  KEY `plugin_resources_budgettypes_id` (`plugin_resources_budgettypes_id`),
  KEY `plugin_resources_budgetvolumes_id` (`plugin_resources_budgetvolumes_id`),
  KEY `date_mod` (`date_mod`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_budgets`
--


--
-- Table structure for table `glpi_plugin_resources_budgettypes`
--

CREATE TABLE `glpi_plugin_resources_budgettypes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_budgettypes`
--


--
-- Table structure for table `glpi_plugin_resources_budgetvolumes`
--

CREATE TABLE `glpi_plugin_resources_budgetvolumes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_budgetvolumes`
--


--
-- Table structure for table `glpi_plugin_resources_checklistconfigs`
--

CREATE TABLE `glpi_plugin_resources_checklistconfigs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `tag` tinyint(1) NOT NULL DEFAULT '0',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_deleted` (`is_deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_checklistconfigs`
--


--
-- Table structure for table `glpi_plugin_resources_checklists`
--

CREATE TABLE `glpi_plugin_resources_checklists` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_resources_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_tasks_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_contracttypes_id` int unsigned NOT NULL DEFAULT '0',
  `checklist_type` int NOT NULL DEFAULT '0',
  `tag` tinyint(1) NOT NULL DEFAULT '0',
  `is_checked` tinyint(1) NOT NULL DEFAULT '0',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rank` smallint NOT NULL DEFAULT '0',
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `plugin_resources_resources_id` (`plugin_resources_resources_id`),
  KEY `plugin_resources_tasks_id` (`plugin_resources_tasks_id`),
  KEY `plugin_resources_contracttypes_id` (`plugin_resources_contracttypes_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_checklists`
--


--
-- Table structure for table `glpi_plugin_resources_choiceitems`
--

CREATE TABLE `glpi_plugin_resources_choiceitems` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `plugin_resources_choiceitems_id` int unsigned NOT NULL DEFAULT '0',
  `completename` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `level` int NOT NULL DEFAULT '0',
  `ancestors_cache` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `sons_cache` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_helpdesk_visible` int NOT NULL DEFAULT '1',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`entities_id`,`plugin_resources_choiceitems_id`,`name`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `plugin_resources_choiceitems_id` (`plugin_resources_choiceitems_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_choiceitems`
--


--
-- Table structure for table `glpi_plugin_resources_choices`
--

CREATE TABLE `glpi_plugin_resources_choices` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `plugin_resources_resources_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_choiceitems_id` int unsigned NOT NULL DEFAULT '0',
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `plugin_resources_resources_id` (`plugin_resources_resources_id`),
  KEY `plugin_resources_choiceitems_id` (`plugin_resources_choiceitems_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_choices`
--


--
-- Table structure for table `glpi_plugin_resources_clients`
--

CREATE TABLE `glpi_plugin_resources_clients` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `security_compliance` tinyint(1) NOT NULL DEFAULT '0',
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `security_and` tinyint(1) NOT NULL DEFAULT '0',
  `security_fifour` tinyint(1) NOT NULL DEFAULT '0',
  `security_gisf` tinyint(1) NOT NULL DEFAULT '0',
  `security_cfi` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_clients`
--


--
-- Table structure for table `glpi_plugin_resources_confighabilitations`
--

CREATE TABLE `glpi_plugin_resources_confighabilitations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `action` tinyint(1) NOT NULL DEFAULT '0',
  `plugin_metademands_metademands_id` tinyint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `entities_id` (`entities_id`),
  KEY `plugin_metademands_metademands_id` (`plugin_metademands_metademands_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_confighabilitations`
--


--
-- Table structure for table `glpi_plugin_resources_configs`
--

CREATE TABLE `glpi_plugin_resources_configs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `security_display` tinyint(1) NOT NULL DEFAULT '0',
  `security_compliance` tinyint(1) NOT NULL DEFAULT '0',
  `import_external_datas` tinyint(1) NOT NULL DEFAULT '0',
  `resource_manager` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `sales_manager` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_configs`
--


--
-- Table structure for table `glpi_plugin_resources_contractnatures`
--

CREATE TABLE `glpi_plugin_resources_contractnatures` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_contractnatures`
--


--
-- Table structure for table `glpi_plugin_resources_contracttypes`
--

CREATE TABLE `glpi_plugin_resources_contracttypes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `use_employee_wizard` tinyint(1) NOT NULL DEFAULT '1',
  `use_need_wizard` tinyint(1) NOT NULL DEFAULT '1',
  `use_picture_wizard` tinyint(1) NOT NULL DEFAULT '1',
  `use_habilitation_wizard` tinyint(1) NOT NULL DEFAULT '0',
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_contracttypes`
--

INSERT INTO `glpi_plugin_resources_contracttypes` VALUES (1,0,1,'Long term contract',NULL,1,1,1,0,NULL),(2,0,1,'Fixed term contract',NULL,1,1,1,0,NULL),(3,0,1,'Trainee',NULL,1,1,1,0,NULL);

--
-- Table structure for table `glpi_plugin_resources_costs`
--

CREATE TABLE `glpi_plugin_resources_costs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plugin_resources_professions_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_ranks_id` int unsigned NOT NULL DEFAULT '0',
  `begin_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `cost` decimal(10,2) NOT NULL DEFAULT '0.00',
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `plugin_resources_professions_id` (`plugin_resources_professions_id`),
  KEY `plugin_resources_ranks_id` (`plugin_resources_ranks_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_costs`
--


--
-- Table structure for table `glpi_plugin_resources_departments`
--

CREATE TABLE `glpi_plugin_resources_departments` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_departments`
--


--
-- Table structure for table `glpi_plugin_resources_employees`
--

CREATE TABLE `glpi_plugin_resources_employees` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `plugin_resources_resources_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_employers_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_clients_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `plugin_resources_resources_id` (`plugin_resources_resources_id`),
  KEY `plugin_resources_employers_id` (`plugin_resources_employers_id`),
  KEY `plugin_resources_clients_id` (`plugin_resources_clients_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_employees`
--


--
-- Table structure for table `glpi_plugin_resources_employers`
--

CREATE TABLE `glpi_plugin_resources_employers` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `locations_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_employers_id` int unsigned NOT NULL DEFAULT '0',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `completename` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `level` int NOT NULL DEFAULT '0',
  `ancestors_cache` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `sons_cache` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `locations_id` (`locations_id`),
  KEY `plugin_resources_employers_id` (`plugin_resources_employers_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_employers`
--


--
-- Table structure for table `glpi_plugin_resources_employments`
--

CREATE TABLE `glpi_plugin_resources_employments` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `plugin_resources_resources_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_professions_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_ranks_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_employmentstates_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_employers_id` int unsigned NOT NULL DEFAULT '0',
  `ratio_employment_budget` decimal(10,2) NOT NULL DEFAULT '0.00',
  `begin_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `plugin_resources_resources_id` (`plugin_resources_resources_id`),
  KEY `plugin_resources_professions_id` (`plugin_resources_professions_id`),
  KEY `plugin_resources_ranks_id` (`plugin_resources_ranks_id`),
  KEY `plugin_resources_employmentstates_id` (`plugin_resources_employmentstates_id`),
  KEY `plugin_resources_employers_id` (`plugin_resources_employers_id`),
  KEY `entities_id` (`entities_id`),
  KEY `date_mod` (`date_mod`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_employments`
--


--
-- Table structure for table `glpi_plugin_resources_employmentstates`
--

CREATE TABLE `glpi_plugin_resources_employmentstates` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `is_leaving_state` tinyint(1) NOT NULL DEFAULT '0',
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `is_active` (`is_active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_employmentstates`
--


--
-- Table structure for table `glpi_plugin_resources_habilitationlevels`
--

CREATE TABLE `glpi_plugin_resources_habilitationlevels` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `number` tinyint(1) NOT NULL DEFAULT '0',
  `is_mandatory_creating_resource` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_habilitationlevels`
--


--
-- Table structure for table `glpi_plugin_resources_habilitations`
--

CREATE TABLE `glpi_plugin_resources_habilitations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plugin_resources_habilitations_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_habilitationlevels_id` int unsigned NOT NULL DEFAULT '0',
  `completename` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `level` int NOT NULL DEFAULT '0',
  `ancestors_cache` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `sons_cache` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `plugin_resources_habilitations_id` (`plugin_resources_habilitations_id`),
  KEY `plugin_resources_habilitationlevels_id` (`plugin_resources_habilitationlevels_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_habilitations`
--


--
-- Table structure for table `glpi_plugin_resources_importcolumns`
--

CREATE TABLE `glpi_plugin_resources_importcolumns` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `resource_column` int NOT NULL,
  `is_identifier` tinyint(1) NOT NULL DEFAULT '0',
  `plugin_resources_imports_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_importcolumns`
--


--
-- Table structure for table `glpi_plugin_resources_importresourcedatas`
--

CREATE TABLE `glpi_plugin_resources_importresourcedatas` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plugin_resources_importresources_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_importcolumns_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_importresourcedatas`
--


--
-- Table structure for table `glpi_plugin_resources_importresources`
--

CREATE TABLE `glpi_plugin_resources_importresources` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `date_creation` timestamp NULL DEFAULT NULL,
  `plugin_resources_imports_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_importresources`
--


--
-- Table structure for table `glpi_plugin_resources_imports`
--

CREATE TABLE `glpi_plugin_resources_imports` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `date_creation` timestamp NULL DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_imports`
--


--
-- Table structure for table `glpi_plugin_resources_leavingreasons`
--

CREATE TABLE `glpi_plugin_resources_leavingreasons` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_leavingreasons`
--


--
-- Table structure for table `glpi_plugin_resources_notifications`
--

CREATE TABLE `glpi_plugin_resources_notifications` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `plugin_resources_resources_id` int unsigned NOT NULL DEFAULT '0',
  `date_mod` timestamp NULL DEFAULT NULL,
  `users_id` int unsigned NOT NULL DEFAULT '0',
  `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `users_id` (`users_id`),
  KEY `date_mod` (`date_mod`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_notifications`
--


--
-- Table structure for table `glpi_plugin_resources_professioncategories`
--

CREATE TABLE `glpi_plugin_resources_professioncategories` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_professioncategories`
--


--
-- Table structure for table `glpi_plugin_resources_professionlines`
--

CREATE TABLE `glpi_plugin_resources_professionlines` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_professionlines`
--


--
-- Table structure for table `glpi_plugin_resources_professions`
--

CREATE TABLE `glpi_plugin_resources_professions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plugin_resources_professionlines_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_professioncategories_id` int unsigned NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `begin_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `plugin_resources_professionlines_id` (`plugin_resources_professionlines_id`),
  KEY `plugin_resources_professioncategories_id` (`plugin_resources_professioncategories_id`),
  KEY `is_active` (`is_active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_professions`
--


--
-- Table structure for table `glpi_plugin_resources_ranks`
--

CREATE TABLE `glpi_plugin_resources_ranks` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plugin_resources_professions_id` int unsigned NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `begin_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `plugin_resources_professions_id` (`plugin_resources_professions_id`),
  KEY `is_active` (`is_active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_ranks`
--


--
-- Table structure for table `glpi_plugin_resources_reportconfigs`
--

CREATE TABLE `glpi_plugin_resources_reportconfigs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `plugin_resources_resources_id` int unsigned NOT NULL DEFAULT '0',
  `send_report_notif` tinyint(1) NOT NULL DEFAULT '1',
  `send_other_notif` tinyint(1) NOT NULL DEFAULT '0',
  `send_transfer_notif` tinyint(1) NOT NULL DEFAULT '0',
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `information` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `plugin_resources_resources_id` (`plugin_resources_resources_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_reportconfigs`
--


--
-- Table structure for table `glpi_plugin_resources_resourcebadges`
--

CREATE TABLE `glpi_plugin_resources_resourcebadges` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_metademands_metademands_id` tinyint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `entities_id` (`entities_id`),
  KEY `plugin_metademands_metademands_id` (`plugin_metademands_metademands_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_resourcebadges`
--


--
-- Table structure for table `glpi_plugin_resources_resourcehabilitations`
--

CREATE TABLE `glpi_plugin_resources_resourcehabilitations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `plugin_resources_resources_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_habilitations_id` tinyint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `plugin_resources_resources_id` (`plugin_resources_resources_id`),
  KEY `glpi_plugin_resources_habilitations_id` (`plugin_resources_habilitations_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_resourcehabilitations`
--


--
-- Table structure for table `glpi_plugin_resources_resourceholidays`
--

CREATE TABLE `glpi_plugin_resources_resourceholidays` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `plugin_resources_resources_id` int unsigned NOT NULL DEFAULT '0',
  `date_begin` date DEFAULT NULL,
  `date_end` date DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `plugin_resources_resources_id` (`plugin_resources_resources_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_resourceholidays`
--


--
-- Table structure for table `glpi_plugin_resources_resourceimports`
--

CREATE TABLE `glpi_plugin_resources_resourceimports` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plugin_resources_resources_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_resourceimports`
--


--
-- Table structure for table `glpi_plugin_resources_resourcerestings`
--

CREATE TABLE `glpi_plugin_resources_resourcerestings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `plugin_resources_resources_id` int unsigned NOT NULL DEFAULT '0',
  `date_begin` date DEFAULT NULL,
  `date_end` date DEFAULT NULL,
  `locations_id` int unsigned NOT NULL DEFAULT '0',
  `at_home` tinyint(1) NOT NULL DEFAULT '0',
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `plugin_resources_resources_id` (`plugin_resources_resources_id`),
  KEY `locations_id` (`locations_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_resourcerestings`
--


--
-- Table structure for table `glpi_plugin_resources_resources`
--

CREATE TABLE `glpi_plugin_resources_resources` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `firstname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plugin_resources_contracttypes_id` int unsigned NOT NULL DEFAULT '0',
  `users_id` int unsigned NOT NULL DEFAULT '0',
  `users_id_sales` int unsigned NOT NULL DEFAULT '0',
  `users_id_recipient` int unsigned NOT NULL DEFAULT '0',
  `date_declaration` date DEFAULT NULL,
  `date_begin` date DEFAULT NULL,
  `date_end` date DEFAULT NULL,
  `quota` decimal(10,4) NOT NULL DEFAULT '1.0000',
  `plugin_resources_departments_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_resourcestates_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_resourcesituations_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_contractnatures_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_ranks_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_resourcespecialities_id` int unsigned NOT NULL DEFAULT '0',
  `locations_id` int unsigned NOT NULL DEFAULT '0',
  `is_leaving` int NOT NULL DEFAULT '0',
  `plugin_resources_leavingreasons_id` int unsigned NOT NULL DEFAULT '0',
  `date_declaration_leaving` timestamp NULL DEFAULT NULL,
  `users_id_recipient_leaving` int unsigned NOT NULL DEFAULT '0',
  `picture` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_helpdesk_visible` int NOT NULL DEFAULT '1',
  `date_mod` timestamp NULL DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_template` tinyint(1) NOT NULL DEFAULT '0',
  `template_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `sensitize_security` tinyint(1) NOT NULL DEFAULT '0',
  `read_chart` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `users_id` (`users_id`),
  KEY `users_id_sales` (`users_id_sales`),
  KEY `users_id_recipient` (`users_id_recipient`),
  KEY `locations_id` (`locations_id`),
  KEY `is_leaving` (`is_leaving`),
  KEY `users_id_recipient_leaving` (`users_id_recipient_leaving`),
  KEY `date_mod` (`date_mod`),
  KEY `is_helpdesk_visible` (`is_helpdesk_visible`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_template` (`is_template`),
  KEY `plugin_resources_contracttypes_id` (`plugin_resources_contracttypes_id`),
  KEY `plugin_resources_departments_id` (`plugin_resources_departments_id`),
  KEY `plugin_resources_resourcestates_id` (`plugin_resources_resourcestates_id`),
  KEY `plugin_resources_resourcesituations_id` (`plugin_resources_resourcesituations_id`),
  KEY `plugin_resources_contractnatures_id` (`plugin_resources_contractnatures_id`),
  KEY `plugin_resources_ranks_id` (`plugin_resources_ranks_id`),
  KEY `plugin_resources_resourcespecialities_id` (`plugin_resources_resourcespecialities_id`),
  KEY `plugin_resources_leavingreasons_id` (`plugin_resources_leavingreasons_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_resources`
--


--
-- Table structure for table `glpi_plugin_resources_resources_changes`
--

CREATE TABLE `glpi_plugin_resources_resources_changes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `actions_id` tinyint unsigned NOT NULL DEFAULT '0',
  `itilcategories_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `entities_id` (`entities_id`),
  KEY `itilcategories_id` (`itilcategories_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_resources_changes`
--


--
-- Table structure for table `glpi_plugin_resources_resources_items`
--

CREATE TABLE `glpi_plugin_resources_resources_items` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `plugin_resources_resources_id` int unsigned NOT NULL DEFAULT '0',
  `items_id` int unsigned NOT NULL DEFAULT '0',
  `itemtype` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'see .class.php file',
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`plugin_resources_resources_id`,`itemtype`,`items_id`),
  KEY `FK_device` (`items_id`,`itemtype`),
  KEY `item` (`itemtype`,`items_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_resources_items`
--


--
-- Table structure for table `glpi_plugin_resources_resourcesituations`
--

CREATE TABLE `glpi_plugin_resources_resourcesituations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_contract_linked` tinyint(1) NOT NULL DEFAULT '0',
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `is_contract_linked` (`is_contract_linked`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_resourcesituations`
--


--
-- Table structure for table `glpi_plugin_resources_resourcespecialities`
--

CREATE TABLE `glpi_plugin_resources_resourcespecialities` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plugin_resources_ranks_id` int unsigned NOT NULL DEFAULT '0',
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `plugin_resources_ranks_id` (`plugin_resources_ranks_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_resourcespecialities`
--


--
-- Table structure for table `glpi_plugin_resources_resourcestates`
--

CREATE TABLE `glpi_plugin_resources_resourcestates` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_resourcestates`
--


--
-- Table structure for table `glpi_plugin_resources_taskplannings`
--

CREATE TABLE `glpi_plugin_resources_taskplannings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `plugin_resources_tasks_id` int unsigned NOT NULL DEFAULT '0',
  `begin` timestamp NULL DEFAULT NULL,
  `end` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `begin` (`begin`),
  KEY `end` (`end`),
  KEY `plugin_resources_tasks_id` (`plugin_resources_tasks_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_taskplannings`
--


--
-- Table structure for table `glpi_plugin_resources_tasks`
--

CREATE TABLE `glpi_plugin_resources_tasks` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `plugin_resources_resources_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_resources_tasktypes_id` int unsigned NOT NULL DEFAULT '0',
  `users_id` int unsigned NOT NULL DEFAULT '0',
  `groups_id` int unsigned NOT NULL DEFAULT '0',
  `actiontime` int NOT NULL DEFAULT '0',
  `is_finished` tinyint(1) NOT NULL DEFAULT '0',
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `plugin_resources_resources_id` (`plugin_resources_resources_id`),
  KEY `plugin_resources_tasktypes_id` (`plugin_resources_tasktypes_id`),
  KEY `users_id` (`users_id`),
  KEY `groups_id` (`groups_id`),
  KEY `is_finished` (`is_finished`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_tasks`
--


--
-- Table structure for table `glpi_plugin_resources_tasks_items`
--

CREATE TABLE `glpi_plugin_resources_tasks_items` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `plugin_resources_tasks_id` int unsigned NOT NULL DEFAULT '0',
  `items_id` int unsigned NOT NULL DEFAULT '0',
  `itemtype` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'see .class.php file',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`plugin_resources_tasks_id`,`itemtype`,`items_id`),
  KEY `FK_device` (`items_id`,`itemtype`),
  KEY `item` (`itemtype`,`items_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_tasks_items`
--


--
-- Table structure for table `glpi_plugin_resources_tasktypes`
--

CREATE TABLE `glpi_plugin_resources_tasktypes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_tasktypes`
--


--
-- Table structure for table `glpi_plugin_resources_ticketcategories`
--

CREATE TABLE `glpi_plugin_resources_ticketcategories` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `ticketcategories_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_ticketcategories`
--


--
-- Table structure for table `glpi_plugin_resources_transferentities`
--

CREATE TABLE `glpi_plugin_resources_transferentities` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `groups_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `entities_id` (`entities_id`),
  KEY `groups_id` (`groups_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_resources_transferentities`
--


--
-- Table structure for table `glpi_plugin_webapplications_webapplications`
--

CREATE TABLE `glpi_plugin_webapplications_webapplications` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `backoffice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plugin_webapplications_webapplicationtypes_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_webapplications_webapplicationservertypes_id` int unsigned NOT NULL DEFAULT '0',
  `plugin_webapplications_webapplicationtechnics_id` int unsigned NOT NULL DEFAULT '0',
  `version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `users_id_tech` int unsigned NOT NULL DEFAULT '0',
  `groups_id_tech` int unsigned NOT NULL DEFAULT '0',
  `suppliers_id` int unsigned NOT NULL DEFAULT '0',
  `manufacturers_id` int unsigned NOT NULL DEFAULT '0',
  `locations_id` int unsigned NOT NULL DEFAULT '0',
  `date_mod` timestamp NULL DEFAULT NULL,
  `is_helpdesk_visible` int NOT NULL DEFAULT '1',
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `plugin_webapplications_webapplicationtypes_id` (`plugin_webapplications_webapplicationtypes_id`),
  KEY `plugin_webapplications_webapplicationservertypes_id` (`plugin_webapplications_webapplicationservertypes_id`),
  KEY `plugin_webapplications_webapplicationtechnics_id` (`plugin_webapplications_webapplicationtechnics_id`),
  KEY `users_id_tech` (`users_id_tech`),
  KEY `groups_id_tech` (`groups_id_tech`),
  KEY `suppliers_id` (`suppliers_id`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `locations_id` (`locations_id`),
  KEY `date_mod` (`date_mod`),
  KEY `is_helpdesk_visible` (`is_helpdesk_visible`),
  KEY `is_deleted` (`is_deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_webapplications_webapplications`
--


--
-- Table structure for table `glpi_plugin_webapplications_webapplications_items`
--

CREATE TABLE `glpi_plugin_webapplications_webapplications_items` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `plugin_webapplications_webapplications_id` int unsigned NOT NULL DEFAULT '0',
  `items_id` int unsigned NOT NULL DEFAULT '0',
  `itemtype` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'see .class.php file',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`plugin_webapplications_webapplications_id`,`items_id`,`itemtype`),
  KEY `FK_device` (`items_id`,`itemtype`),
  KEY `item` (`itemtype`,`items_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_webapplications_webapplications_items`
--


--
-- Table structure for table `glpi_plugin_webapplications_webapplicationservertypes`
--

CREATE TABLE `glpi_plugin_webapplications_webapplicationservertypes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_webapplications_webapplicationservertypes`
--

INSERT INTO `glpi_plugin_webapplications_webapplicationservertypes` VALUES (1,'Apache',''),(2,'IIS',''),(3,'Tomcat','');

--
-- Table structure for table `glpi_plugin_webapplications_webapplicationtechnics`
--

CREATE TABLE `glpi_plugin_webapplications_webapplicationtechnics` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_webapplications_webapplicationtechnics`
--

INSERT INTO `glpi_plugin_webapplications_webapplicationtechnics` VALUES (1,'Asp',''),(2,'Cgi',''),(3,'Java',''),(4,'Perl',''),(5,'Php',''),(6,'.Net','');

--
-- Table structure for table `glpi_plugin_webapplications_webapplicationtypes`
--

CREATE TABLE `glpi_plugin_webapplications_webapplicationtypes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_webapplications_webapplicationtypes`
--

INSERT INTO `glpi_plugin_webapplications_webapplicationtypes` VALUES (1,0,'Correo_365','',1);

--
-- Table structure for table `glpi_plugin_yagp_configs`
--

CREATE TABLE `glpi_plugin_yagp_configs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `ticketsolveddate` tinyint(1) NOT NULL DEFAULT '0',
  `contractrenew` tinyint(1) NOT NULL DEFAULT '0',
  `fixedmenu` tinyint(1) NOT NULL DEFAULT '0',
  `gototicket` tinyint(1) NOT NULL DEFAULT '0',
  `blockdate` tinyint(1) NOT NULL DEFAULT '0',
  `findrequest` tinyint(1) NOT NULL DEFAULT '0',
  `requestlabel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `change_df_min_val` tinyint(1) NOT NULL DEFAULT '0',
  `df_min_validation` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugin_yagp_configs`
--

INSERT INTO `glpi_plugin_yagp_configs` VALUES (1,0,0,0,0,0,0,NULL,0,0);

--
-- Table structure for table `glpi_plugins`
--

CREATE TABLE `glpi_plugins` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `directory` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` int NOT NULL DEFAULT '0' COMMENT 'see define.php PLUGIN_* constant',
  `author` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `homepage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`directory`),
  KEY `state` (`state`),
  KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugins`
--

INSERT INTO `glpi_plugins` VALUES (14,'ocsinventoryng','OCS Inventory NG','2.0.4',4,'Gilles Dubois, Remi Collet, Nelly Mahu-Lasson, David Durieux, Xavier Caillaud, Walid Nouh, Arthur Jaouen','https://github.com/pluginsGLPI/ocsinventoryng','GPLv2+');

--
-- Table structure for table `glpi_plugs`
--

CREATE TABLE `glpi_plugs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_plugs`
--


--
-- Table structure for table `glpi_printerlogs`
--

CREATE TABLE `glpi_printerlogs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `printers_id` int unsigned NOT NULL,
  `total_pages` int NOT NULL DEFAULT '0',
  `bw_pages` int NOT NULL DEFAULT '0',
  `color_pages` int NOT NULL DEFAULT '0',
  `rv_pages` int NOT NULL DEFAULT '0',
  `prints` int NOT NULL DEFAULT '0',
  `bw_prints` int NOT NULL DEFAULT '0',
  `color_prints` int NOT NULL DEFAULT '0',
  `copies` int NOT NULL DEFAULT '0',
  `bw_copies` int NOT NULL DEFAULT '0',
  `color_copies` int NOT NULL DEFAULT '0',
  `scanned` int NOT NULL DEFAULT '0',
  `date` date DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `faxed` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`printers_id`,`date`),
  KEY `date` (`date`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_printerlogs`
--


--
-- Table structure for table `glpi_printermodels`
--

CREATE TABLE `glpi_printermodels` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `product_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `picture_front` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `picture_rear` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `pictures` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  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=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_printermodels`
--

INSERT INTO `glpi_printermodels` VALUES (1,'L3110','','','2020-05-19 19:31:16','2020-05-19 19:31:16',NULL,NULL,NULL),(2,'L210','','','2020-11-30 13:43:28','2020-11-30 13:43:28',NULL,NULL,NULL),(3,'L555','','','2020-12-11 19:44:04','2020-12-11 19:44:04',NULL,NULL,NULL),(4,'ECOSYS M3145idn','','','2021-05-26 16:45:56','2021-05-26 16:45:56',NULL,NULL,NULL),(5,'Canon MF4770N','','','2022-02-21 19:40:35','2022-02-21 19:40:35',NULL,NULL,NULL),(6,'FS-2100DN','','','2022-04-01 22:18:02','2022-04-01 22:18:02',NULL,NULL,NULL),(7,'MP 501SPF','','','2022-06-16 14:48:21','2022-06-16 14:48:21',NULL,NULL,NULL),(8,'HP DeskJet Ink Advantage 2775','','','2022-06-16 15:26:42','2022-06-16 15:26:42',NULL,NULL,NULL),(9,'HP Smart Tank 500','','','2022-06-16 15:39:18','2022-06-16 15:39:18',NULL,NULL,NULL),(10,'LaserJet Pro MFP M426dw','','','2022-06-30 23:15:11','2022-06-30 23:15:11',NULL,NULL,NULL),(11,'HP Designjet T520 36in','','','2022-07-07 21:37:28','2022-07-07 21:37:28',NULL,NULL,NULL),(12,'KM45F438','','','2022-08-19 16:52:59','2022-08-19 16:52:59',NULL,NULL,NULL),(13,'ECOSYS M3040idn','','','2022-08-22 22:04:39','2022-08-22 22:04:39',NULL,NULL,NULL),(14,'LaserJet MFP M426fdw','','','2022-08-22 22:05:13','2022-08-22 22:05:13',NULL,NULL,NULL),(15,'HP LaserJet Pro MFP M127fw','','','2022-08-22 23:05:18','2022-08-22 23:05:18',NULL,NULL,NULL),(16,'M249A','','','2022-10-03 18:11:16','2022-10-03 18:11:16',NULL,NULL,NULL);

--
-- Table structure for table `glpi_printers`
--

CREATE TABLE `glpi_printers` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `contact` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `users_id_tech` int unsigned NOT NULL DEFAULT '0',
  `groups_id_tech` int unsigned NOT NULL DEFAULT '0',
  `serial` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otherserial` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `have_serial` tinyint(1) NOT NULL DEFAULT '0',
  `have_parallel` tinyint(1) NOT NULL DEFAULT '0',
  `have_usb` tinyint(1) NOT NULL DEFAULT '0',
  `have_wifi` tinyint(1) NOT NULL DEFAULT '0',
  `have_ethernet` tinyint(1) NOT NULL DEFAULT '0',
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `memory_size` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `locations_id` int unsigned NOT NULL DEFAULT '0',
  `networks_id` int unsigned NOT NULL DEFAULT '0',
  `printertypes_id` int unsigned NOT NULL DEFAULT '0',
  `printermodels_id` int unsigned NOT NULL DEFAULT '0',
  `manufacturers_id` int unsigned NOT NULL DEFAULT '0',
  `is_global` tinyint(1) NOT NULL DEFAULT '0',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `is_template` tinyint(1) NOT NULL DEFAULT '0',
  `template_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `init_pages_counter` int NOT NULL DEFAULT '0',
  `last_pages_counter` int NOT NULL DEFAULT '0',
  `users_id` int unsigned NOT NULL DEFAULT '0',
  `groups_id` int unsigned NOT NULL DEFAULT '0',
  `states_id` int unsigned NOT NULL DEFAULT '0',
  `ticket_tco` decimal(20,4) DEFAULT '0.0000',
  `is_dynamic` tinyint(1) NOT NULL DEFAULT '0',
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `sysdescr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `last_inventory_update` timestamp NULL DEFAULT NULL,
  `snmpcredentials_id` int unsigned NOT NULL DEFAULT '0',
  `autoupdatesystems_id` int unsigned NOT NULL DEFAULT '0',
  `Precio` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `is_template` (`is_template`),
  KEY `is_global` (`is_global`),
  KEY `entities_id` (`entities_id`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `groups_id` (`groups_id`),
  KEY `users_id` (`users_id`),
  KEY `locations_id` (`locations_id`),
  KEY `printermodels_id` (`printermodels_id`),
  KEY `networks_id` (`networks_id`),
  KEY `states_id` (`states_id`),
  KEY `users_id_tech` (`users_id_tech`),
  KEY `printertypes_id` (`printertypes_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `date_mod` (`date_mod`),
  KEY `groups_id_tech` (`groups_id_tech`),
  KEY `last_pages_counter` (`last_pages_counter`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `serial` (`serial`),
  KEY `otherserial` (`otherserial`),
  KEY `date_creation` (`date_creation`),
  KEY `snmpcredentials_id` (`snmpcredentials_id`),
  KEY `autoupdatesystems_id` (`autoupdatesystems_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `uuid` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_printers`
--

INSERT INTO `glpi_printers` VALUES (1,18,0,'DSLI112-BC','2023-11-09 17:03:47','','',0,0,'','',0,0,0,0,0,'192.168.21.15 \r\nInicio de Sesión \r\nUSER: admin\r\n ----------------- \r\nSCANNER \r\ncorreo: mrsplash@mrsplash.com \r\ncontraseña: @dm1nTI2019+ \r\nSERVER: smtp.gmail.com \r\nPORT: 587 SSL: SI \r\nSMTP AUTENTIFICACION: SI\r\n -----------------\r\n','',162,0,0,0,0,0,0,0,NULL,0,0,0,0,2,0.0000,0,NULL,'2020-03-11 21:03:46',NULL,NULL,0,0,NULL),(2,18,0,'DSLI130-BG','2023-11-09 17:03:47','','',0,0,'G986X710130','',0,0,0,0,0,'IP: 192.168.12.141\r\n-----------------\r\nInicio de Sesión\r\nUSER: admin\r\n-----------------\r\nSCANNER\r\ncorreo: administrador@arintia.com\r\ncontraseña: @dm1nTI2020**\r\nSERVER: smtp.office365.com\r\nPORT: 587\r\nSSL: SI\r\nSMTP AUTENTIFICACION: SI\r\n-----------------\r\n','',163,0,0,0,0,0,0,0,NULL,0,0,0,0,2,0.0000,0,NULL,'2020-03-11 21:06:40',NULL,NULL,0,0,NULL),(3,2,0,'DSLI139-BG','2023-04-24 09:52:17','','',0,0,'W524L600139','',0,0,0,0,0,'IP: 192.168.1.235 \r\n----------------- \r\nInicio de Sesión \r\nUSER: admin\r\n ----------------- \r\nSCANNER \r\ncorreo: mrsplash@mrsplash.com \r\ncontraseña: @dm1nTI2019+ \r\nSERVER: smtp.gmail.com \r\nPORT: 587 \r\nSSL: SI \r\nSMTP AUTENTIFICACION: SI \r\n-----------------\r\n','',37,0,0,0,0,0,0,0,NULL,0,0,0,0,2,0.0000,0,NULL,'2020-03-11 21:09:05',NULL,NULL,0,0,NULL),(4,2,0,'DSLI352-BG','2023-04-24 09:52:17','','',0,0,'S9228600352','',0,0,0,0,0,'IP: 192.168.1.234\r\n ----------------- \r\nInicio de Sesión \r\nUSER: admin\r\n ----------------- \r\nSCANNER \r\ncorreo: mrsplash@mrsplash.com \r\ncontraseña: @dm1nTI2019+ \r\nSERVER: smtp.gmail.com \r\nPORT: 587 SSL: SI \r\nSMTP AUTENTIFICACION: SI \r\n-----------------\r\n','',37,0,0,0,0,0,0,0,NULL,0,0,0,0,2,0.0000,0,NULL,'2020-03-11 21:11:58',NULL,NULL,0,0,NULL),(5,1,0,'DSLI452-MQ','2023-04-24 09:52:17','','',0,0,'W914P402452','',0,0,0,0,0,'Desimplementada, por fallas,\r\n\r\n\r\nIP: 192.168.10.234 \r\n-----------------\r\nInicio de Sesión \r\nUSER: admin\r\n ----------------- \r\nSCANNER \r\ncorreo: mrsplash@mrsplash.com \r\ncontraseña: @dm1nTI2019+ \r\nSERVER: smtp.gmail.com PORT: 587 \r\nSSL: SI \r\nSMTP AUTENTIFICACION: SI\r\n -----------------','',0,0,0,0,0,0,1,0,NULL,0,0,0,0,2,0.0000,0,NULL,'2020-03-11 21:13:54',NULL,NULL,0,0,NULL),(6,1,0,'DSLI459-BG','2023-04-24 09:52:17','','',0,0,'W432L401459','',0,0,0,0,0,'IP: 192.168.11.90\r\n----------------- \r\nInicio de Sesión\r\nUSER: admin \r\n----------------- \r\nSCANNER \r\ncorreo: mrsplash@mrsplash.com \r\ncontraseña: @dm1nTI2019+ \r\nSERVER: smtp.gmail.com \r\nPORT: 587\r\n SSL: SI \r\nSMTP AUTENTIFICACION: SI\r\n -----------------\r\n','',5,0,0,0,0,0,0,0,NULL,0,0,0,0,2,0.0000,0,NULL,'2020-03-11 21:16:25',NULL,NULL,0,0,NULL),(7,21,0,'IM-0698-MQ','2023-09-12 21:32:06','jeferson.cubides','',0,28,'X5E8000698','',0,0,0,0,0,'192.168.10.137\r\n','',41,0,1,1,39,0,0,0,NULL,0,0,0,12,1,0.0000,0,NULL,'2020-03-11 21:22:11',NULL,NULL,0,0,NULL),(8,1,0,'IM-5672-BG','2023-04-24 09:52:17','paola.garzon','',0,0,'','',0,0,0,0,0,'','',5,0,1,0,39,0,0,0,NULL,0,0,0,0,2,0.0000,0,NULL,'2020-03-11 21:23:52',NULL,NULL,0,0,NULL),(9,15,0,'RPC996090-BG','2023-09-12 21:32:30','','',0,0,'','',0,0,0,0,0,'IP: 192.168.12.139\r\n-----------------\r\nInicio de Sesión\r\nUSER: admin\r\n-----------------\r\nSCANNER\r\ncorreo: gestionhumana@arintia.com\r\ncontraseña: G3st10nH21+\r\nSERVER: smtp.office365.com\r\nPORT: 587\r\nSSL: SI\r\nSMTP AUTENTIFICACION: SI\r\n-----------------\r\n','',38,0,0,0,0,0,0,0,NULL,0,0,0,0,2,0.0000,0,NULL,'2020-03-11 21:29:15',NULL,NULL,0,0,NULL),(10,1,0,'RPC996092-BC','2023-04-24 09:40:33','','',0,0,'','',0,0,0,0,0,'','',9,0,0,0,0,0,0,0,NULL,0,0,0,0,2,0.0000,0,NULL,'2020-03-11 21:29:52',NULL,NULL,0,0,NULL),(11,21,0,'IM-0826-BQ','2023-09-12 21:32:06','','',0,0,'','',0,0,0,0,0,'','',15,0,1,1,39,0,0,0,NULL,0,0,0,12,1,0.0000,0,NULL,'2020-05-19 19:31:56',NULL,NULL,0,0,NULL),(12,18,0,'DSLI129-MQ','2023-11-09 17:03:47','','',0,12,'T596H302129','',0,0,1,0,1,'IP: 192.168.10.234 \r\n-----------------\r\nInicio de Sesión \r\nUSER: admin\r\n ----------------- \r\nSCANNER \r\ncorreo: gestionhumana@arintia.com\r\ncontraseña: G3st10nH21+\r\nSERVER: smtp.office365.com\r\nPORT: 587\r\nSSL: SI\r\nSMTP AUTENTIFICACION: SI\r\n -----------------','',164,0,0,0,0,0,0,0,NULL,0,0,0,12,2,0.0000,0,NULL,'2020-07-01 14:55:02',NULL,NULL,0,0,NULL),(13,1,0,'ARTI826-BQ','2023-04-24 09:40:33','','',0,28,'X644210826','',0,0,1,0,0,'Dirección Ubicación:  Avenida Circunvalar \r\n                                   Calle 110 # 4-76. Barranquilla','N/A',15,0,1,1,39,0,0,0,NULL,0,0,372,12,1,0.0000,0,NULL,'2020-07-16 15:42:53',NULL,NULL,0,0,NULL),(14,1,0,'DSLI327-MD','2023-04-27 22:19:30','','',0,0,'','',0,0,0,0,0,'IP: 192.168.30.200  segundo piso.\r\n-----------------\r\nInicio de Sesión\r\nUSER: admin\r\n-----------------\r\nSCANNER\r\ncorreo: gestionhumana@arintia.com\r\ncontraseña: G3st10nH21+\r\nSERVER: smtp.office365.com\r\nPORT: 587\r\nSSL: SI\r\nSMTP AUTENTIFICACION: SI\r\n-----------------','',0,0,0,0,0,0,0,0,NULL,0,0,0,0,2,0.0000,0,NULL,'2020-08-11 14:36:18',NULL,NULL,0,0,NULL),(15,1,0,'DEVA3FCC0 ','2023-11-01 13:33:02','jeremy.pedraza','',1117,28,'CNB8J3Y62C','DEVA3FCC0 ',0,0,0,0,0,'Impresora HP LaserJet Pro MFP M127fw   DEVA3FCC0   192.168.1.128 - entrada bodega TECHOS -DIEGO PUENTES\r\n\r\nsin scanner, no es posible envió de notificaciones.','',9,2,3,15,9,0,0,0,NULL,0,0,1117,0,1,0.0000,0,NULL,'2020-08-14 15:45:32',NULL,NULL,0,0,NULL),(16,1,0,'DSLI579-MD','2023-04-24 08:21:23','','',0,28,'','',0,0,0,0,0,'IP: 192.168.30.250  primer piso.\r\n-----------------\r\nInicio de Sesión\r\nUSER: admin\r\n-----------------\r\nSCANNER\r\ncorreo: gestionhumana@arintia.com\r\ncontraseña: G3st10nH21+\r\nSERVER: smtp.office365.com\r\nPORT: 587\r\nSSL: SI\r\nSMTP AUTENTIFICACION: SI\r\n-----------------','',0,0,0,0,0,0,0,0,NULL,0,0,0,0,2,0.0000,0,NULL,'2020-08-31 17:37:33',NULL,NULL,0,0,NULL),(17,1,0,' DSLI668-BC','2023-04-27 22:19:30','','',0,0,'','',0,0,0,0,0,'IP: 192.168.21.250\r\n-----------------\r\nInicio de Sesión\r\nUSER: admin\r\n-----------------\r\nSCANNER\r\ncorreo: gestionhumana@arintia.com\r\ncontraseña: G3st10nH21+\r\nSERVER: smtp.office365.com\r\nPORT: 587\r\nSSL: SI\r\nSMTP AUTENTIFICACION: SI','',48,0,0,0,0,0,0,0,NULL,0,0,0,0,2,0.0000,0,NULL,'2020-10-19 21:38:30',NULL,NULL,0,0,NULL),(18,1,0,'ARTI365-BC','2023-11-01 14:43:00','Jeremy. pedraza','',1117,13,'S25K092365','',0,0,0,0,0,'BUCARAMANGA CLL 2 CVL 36 BOD 2A y 2B CHIMITA PARQUE INDUSTRIAL II.laboratorio\r\n\r\nconectada con el practicante joan - en amsa','N/A',48,0,1,2,39,0,0,0,NULL,0,0,1117,0,1,0.0000,0,NULL,'2020-11-30 13:49:12',NULL,NULL,0,0,NULL),(19,1,0,'ARTI977-BC','2023-11-01 13:49:05','jeremy.pedraza','',1117,13,'S25K433977','',0,0,0,0,0,'LABORATORIO MINEROIL ,\r\nusuarios, usb -&gt;karen y jhon guerrero \r\nKM 4 VIA ZONA INDUSTRIAL,CHIMITA GIRON','',48,0,1,2,39,0,0,0,NULL,0,0,1117,62,1,0.0000,0,NULL,'2020-12-11 19:25:14',NULL,NULL,0,0,NULL),(20,1,0,'ARTI564-BC','2023-11-01 13:36:17','jeremy.pedraza','',1117,13,'S4VY149564','',0,0,0,0,0,'Presente en contabilidad\r\n\r\nKM 4 VIA ZONA INDUSTRIAL CHIMITA GIRON,SANTANDER','',9,0,1,3,39,0,0,0,NULL,0,0,1117,22,1,0.0000,0,NULL,'2020-12-11 19:45:29',NULL,NULL,0,0,NULL),(21,1,0,'PTRF957-BG','2023-04-27 22:19:30','','',0,13,'KMA4F957','',0,0,0,0,0,'IP: 192.168.11.90\r\n-------------------------\r\nusuario: Admin\r\npass: Admin\r\n-------------------------\r\nSCANNER\r\ncorreo: gestionhumana@arintia.com\r\ncontraseña: G3st10nH21+\r\nSERVER: smtp.office365.com\r\nPORT: 587\r\nSSL: SI\r\nSMTP AUTENTIFICACION: SI\r\n','',5,1,4,4,79,0,0,0,NULL,0,0,752,28,1,0.0000,0,NULL,'2021-05-26 17:11:29',NULL,NULL,0,0,NULL),(22,2,0,'PTR0C47-BG','2023-08-30 23:52:50','','',368,13,'KM2F0C47','',0,0,0,0,0,'IP: 192.168.1.235\r\n-------------------------\r\nusuario: Admin\r\npass: Admin\r\n-------------------------\r\nSCANNER\r\ncorreo: gestionhumana@arintia.com\r\ncontraseña: G3st10nH21+\r\nSERVER: smtp.office365.com\r\nPORT: 587\r\nSSL: SI\r\nSMTP AUTENTIFICACION: SI','',37,1,4,4,79,0,0,0,NULL,0,106832,368,13,1,0.0000,0,NULL,'2021-05-27 16:40:47',NULL,NULL,0,0,NULL),(23,1,0,'PTRF81C-ME','2023-04-27 22:19:30','','',0,28,'KMA4F81C','',0,0,0,0,0,'IP: 192.168.31.8\r\n-------------------------\r\nusuario: Admin\r\npass: Admin\r\n-------------------------\r\nSCANNER\r\ncorreo: gestionhumana@arintia.com\r\ncontraseña: G3st10nH21+\r\nSERVER: smtp.office365.com\r\nPORT: 587\r\nSSL: SI\r\nSMTP AUTENTIFICACION: SI\r\n','',2,6,4,4,79,0,0,0,NULL,0,0,678,62,1,0.0000,0,NULL,'2021-06-23 14:45:58',NULL,NULL,0,0,NULL),(24,22,0,'PTRF939-BC','2023-11-01 13:33:57','JEREMY.PEDRAZA','',1117,62,'KMA4F939','',0,0,0,0,0,'IP: 192.168.21.15\r\n-------------------------\r\nusuario: Admin\r\npass: Admin\r\n-------------------------\r\nSCANNER\r\ncorreo: gestionhumana@arintia.com\r\ncontraseña: G3st10nH21+\r\nSERVER: smtp.office365.com\r\nPORT: 587\r\nSSL: SI\r\nSMTP AUTENTIFICACION: SI\r\n','',10,4,4,4,79,0,0,0,NULL,0,0,1117,62,1,0.0000,0,NULL,'2021-06-25 14:22:19',NULL,NULL,0,0,NULL),(25,1,0,'PTRF8EC-BC','2023-11-01 13:28:48','jeremy.pedraza','',1117,62,'KMA4F8EC','',0,0,0,0,0,'IP: 192.168.22.9\r\n-------------------------\r\nusuario: Admin\r\npass: Admin\r\n-------------------------\r\nSCANNER\r\ncorreo: gestionhumana@arintia.com\r\ncontraseña: G3st10nH21+\r\nSERVER: smtp.office365.com\r\nPORT: 587\r\nSSL: SI\r\nSMTP AUTENTIFICACION: SI','',48,6,4,4,79,0,0,0,NULL,0,0,1117,62,1,0.0000,0,NULL,'2021-06-25 14:26:39',NULL,NULL,0,0,NULL),(26,21,0,'PTRF8F5-MQ','2023-09-04 14:52:56','','',0,28,'KMA4F8F5','',0,0,0,0,0,'IP: 192.168.10.234\r\n-------------------------\r\nusuario: Admin\r\npass: Admin\r\n-------------------------\r\nSCANNER\r\ncorreo: gestionhumana@arintia.com\r\ncontraseña: G3st10nH21+\r\nSERVER: smtp.office365.com\r\nPORT: 587\r\nSSL: SI\r\nSMTP AUTENTIFICACION: SI','',41,1,4,4,79,0,0,0,NULL,0,0,368,12,1,0.0000,0,NULL,'2021-06-25 14:29:33',NULL,NULL,0,0,NULL),(27,1,0,'PTRF7CB-ME','2023-04-27 22:19:30','','',0,28,'KMA4F7CB','',0,0,0,0,0,'IP: 192.168.31.9   PRIMER PISO\r\n-------------------------\r\nusuario: Admin\r\npass: Admin\r\n-------------------------\r\nSCANNER\r\ncorreo: gestionhumana@arintia.com\r\ncontraseña: G3st10nH21+\r\nSERVER: smtp.office365.com\r\nPORT: 587\r\nSSL: SI\r\nSMTP AUTENTIFICACION: SI','',2,4,4,4,79,0,0,0,NULL,0,0,678,62,1,0.0000,0,NULL,'2021-06-25 14:33:04',NULL,NULL,0,0,NULL),(28,21,0,'PTRF811-MQ','2023-09-04 14:52:56','','',368,28,'KMA4F811','',0,0,0,0,0,'IP: 192.168.10.232\r\n-------------------------\r\nusuario: Admin\r\npass: Admin\r\n-------------------------\r\nSCANNER\r\ncorreo: gestionhumana@arintia.com\r\ncontraseña: G3st10nH21+\r\nSERVER: smtp.office365.com\r\nPORT: 587\r\nSSL: SI\r\nSMTP AUTENTIFICACION: SI','',41,4,4,4,79,0,0,0,NULL,0,0,368,12,1,0.0000,0,NULL,'2021-06-25 14:34:29',NULL,NULL,0,0,NULL),(29,15,0,'PTRFD60-BG','2023-09-12 21:32:30','','',0,13,'R4V9909945','',0,0,0,0,0,'IP: 192.168.12.139\r\n-------------------------\r\nusuario: Admin\r\npass: Admin\r\n-------------------------\r\nSCANNER\r\ncorreo: gestionhumana@arintia.com\r\ncontraseña: G3st10nH21+\r\nSERVER: smtp.office365.com\r\nPORT: 587\r\nSSL: SI\r\nSMTP AUTENTIFICACION: SI','',38,5,4,4,79,0,0,0,NULL,0,0,0,0,1,0.0000,0,NULL,'2021-08-24 17:40:13',NULL,NULL,0,0,NULL),(30,1,0,'RPC996082-SIN','2023-04-24 12:16:42','Marcela Romero','',0,28,'PHBLL7R4L1','996082',0,0,0,0,0,'LaserJet MFP M426fdw','',51,7,2,14,9,0,0,0,NULL,0,0,0,13,1,0.0000,0,NULL,'2022-01-25 15:14:18',NULL,NULL,0,0,NULL),(31,21,1,'PTR770N-BQ','2023-09-04 14:53:26','','',0,28,'','',0,0,0,0,0,'','',15,0,4,5,84,0,0,0,NULL,0,0,372,12,1,0.0000,0,NULL,'2022-02-21 19:42:45',NULL,NULL,0,0,NULL),(32,21,1,'PTRF052-MQ','2023-09-04 15:02:12','','',368,28,'KM985052','',0,0,0,0,0,'IP: 192.168.10.233\r\n-------------------------\r\nusuario: Admin\r\npass: Admin\r\n-------------------------\r\nSCANNER\r\ncorreo: gestionhumana@arintia.com\r\ncontraseña: G3st10nH21+\r\nSERVER: smtp.office365.com\r\nPORT: 587\r\nSSL: SI\r\nSMTP AUTENTIFICACION: SI','',41,1,4,6,79,0,0,0,NULL,0,0,368,12,2,0.0000,0,NULL,'2022-04-01 22:18:27',NULL,NULL,0,0,NULL),(33,22,0,'PTR7DF5-BC','2023-11-27 21:16:05','jeremy.pedraza','',1117,28,'LSD7624176','PTR7DF5-BC',0,0,1,0,1,'IP: 192.168.22.11\r\n-------------------------\r\nusuario: Admin\r\npass: Admin\r\n-------------------------\r\nSCANNER\r\ncorreo: gestionhumana@arintia.com\r\ncontraseña: G3st10nH21+\r\nSERVER: smtp.office365.com\r\nPORT: 587\r\nSSL: SI\r\nSMTP AUTENTIFICACION: SI','',48,6,4,13,79,0,0,0,NULL,0,0,1117,62,1,0.0000,0,NULL,'2022-04-27 20:46:40',NULL,NULL,0,0,NULL),(34,19,0,'ELCMUR6798-BG','2023-05-16 14:34:58','','',508,64,'G989X316798','',0,0,0,0,1,'IP: 10.0.0.9\r\n______________________\r\nusuario: admin\r\ncontraseña:\r\n______________________\r\nSCANNER\r\ncorreo: secretaria@muraglia.com.co','',56,0,4,7,106,0,0,0,NULL,0,0,0,64,1,0.0000,0,NULL,'2022-06-16 14:49:08',NULL,NULL,0,0,NULL),(35,19,0,'ELCMURE3V4-BG','2023-05-16 14:34:58','','',508,64,'CN07N3E3V4','',0,0,0,1,0,'IP: 10.0.0.118\r\n___________________\r\nPIN: 04908021\r\n___________________\r\n','',56,0,4,8,74,0,0,0,NULL,0,0,0,64,3,0.0000,0,NULL,'2022-06-16 15:27:17',NULL,NULL,0,0,NULL),(36,19,0,'ELCMUR42GD-BG','2023-05-16 14:34:58','','',508,64,'CN1CT442GD','',0,0,0,0,0,'Acceso desde WOSERVER','',56,0,4,9,74,0,0,0,NULL,0,0,0,64,1,0.0000,0,NULL,'2022-06-16 15:40:25',NULL,NULL,0,0,NULL),(37,2,0,'RPC996087-BG','2023-08-30 23:53:10','marisol.garzon','',752,28,'PHBLLB64KS','',0,0,1,1,1,'IP: 192.168.170.76\r\nusser: admin\r\npass: Adm1nPC44$','',37,0,2,10,9,0,0,0,NULL,0,0,958,34,1,0.0000,0,NULL,'2022-06-30 23:15:46',NULL,NULL,0,0,NULL),(38,19,0,'ELCMURM02W-BG','2023-05-16 14:34:58','','',0,28,'CN3372M02W','',0,0,1,1,1,'IP: http://10.0.0.183/','',56,0,5,11,9,0,0,0,NULL,0,0,0,64,1,0.0000,0,NULL,'2022-07-07 21:38:14',NULL,NULL,0,0,NULL),(39,15,0,'PTRDF438-BG','2023-04-28 17:48:31','','',0,28,'','',0,0,0,0,0,'IP: P: 192.168.20.200\r\n-------------------------\r\nusuario: Admin\r\npass: Admin\r\n-------------------------\r\nSCANNER\r\ncorreo: scanerarintia@scanerimpresora.com\r\ncontraseña: G3st10nH21+\r\nSERVER: mail.scanerimpresora.com\r\nPORT: 26\r\nSSL: SI\r\nSMTP AUTENTIFICACION: SI\r\n-------------------------\r\nusuario: Admin\r\npass: Admin','',38,1,4,12,79,0,0,0,NULL,0,0,0,69,1,0.0000,0,NULL,'2022-08-19 16:55:47',NULL,NULL,0,0,NULL),(40,1,0,'ART8818-BG','2023-03-13 20:48:57','kevin.cruz','',0,28,'MUNF1128818','',0,0,0,0,0,'Epson TM-T20','',5,0,6,16,39,0,0,0,NULL,0,0,0,28,1,0.0000,0,NULL,'2022-10-03 18:12:47',NULL,NULL,0,0,NULL),(41,2,0,'RPC996082-SC','2023-08-30 23:55:23','monica.herazo','',0,59,'','',0,0,0,0,0,'Cable USB, Cable de poder','',51,0,2,10,9,0,0,0,NULL,0,0,1064,34,1,0.0000,0,NULL,'2023-08-30 23:55:23',NULL,NULL,0,0,NULL),(42,20,0,'ART0090-BG','2023-10-03 16:55:03','Administrador.','',752,59,' V1W4200090 ','BG - Laboratorio',0,0,0,0,0,'User: Admin\r\nContraseña: Admin\r\n\r\nModelo: FS-1040\r\n\r\n\r\n','',71,0,3,0,79,0,0,0,NULL,0,0,950,22,3,0.0000,0,NULL,'2023-10-03 16:54:06',NULL,NULL,0,0,NULL),(43,20,0,'ART7002-BG','2023-10-07 18:26:52','Bancos','',752,59,' XVC9X07002 ','',0,0,0,0,0,'\r\nModelos: FS-1100\r\n\r\nUser: Admin\r\nContraseña: Admin','',71,0,3,0,79,0,0,0,NULL,0,0,950,22,3,0.0000,0,NULL,'2023-10-07 18:26:52',NULL,NULL,0,0,NULL),(44,20,0,'ART4586-BG','2023-10-07 18:30:10','esteffany.sanabria','',752,59,' Q620604586 ','',0,0,0,0,0,'Modelo: FS-1320D\r\n\r\nUser: Admin\r\nContraseña: Admin\r\n\r\nIP: 10.3.128.117','',71,0,3,0,79,0,0,0,NULL,0,0,329,22,1,0.0000,0,NULL,'2023-10-07 18:29:40',NULL,NULL,0,0,NULL),(45,20,0,'ART5094-MQ','2023-10-09 17:12:31','jeferson.cubides','',368,59,' R4V0415 094 ','',0,0,0,0,0,'Modelo: FS-M3145IDN\r\n\r\nUser: Admin\r\nContraseña: Admin\r\n','',142,0,4,4,79,0,0,0,NULL,0,0,368,22,1,0.0000,0,NULL,'2023-10-07 18:33:49',NULL,NULL,0,0,NULL),(46,20,0,'ART9875-BQ','2023-10-09 17:13:26','Administrador.','',752,59,' R4P1579875 ','',0,0,0,0,0,'Modelo: FS-M3655IDN\r\n\r\nUser: Admin\r\nContraseña: 1mpr3s0r4B4rr4nq91ll4\r\n\r\nIP: 181.52.121.11','',80,0,4,0,79,0,0,0,NULL,0,0,804,22,3,0.0000,0,NULL,'2023-10-07 18:37:51',NULL,NULL,0,0,NULL),(47,20,0,'ART4913 -BC','2023-10-09 17:12:43','andres.consuegra','',1117,59,' LZK4714913 ','',0,0,0,0,0,'Modelo:M2035DN\r\n\r\nUser: Admin\r\nContraseña: Admin\r\n\r\nIP:190.147.210.72\r\n','',9,0,4,0,79,0,0,0,NULL,0,0,1117,22,1,0.0000,0,NULL,'2023-10-07 18:40:37',NULL,NULL,0,0,NULL),(48,20,0,'ART5277 -CA','2023-10-09 17:12:19','jonathan.cardona','',752,59,' LZK4715277 ','Ventas',0,0,0,0,0,'\r\nModelo: M2035DN\r\n\r\nUser: Admin\r\nContraseña:1mpr3s0r4C4l1\r\n\r\nIP: 181.48.73.134\r\n','',88,0,4,0,79,0,0,0,NULL,0,0,1067,22,1,0.0000,0,NULL,'2023-10-09 17:05:20',NULL,NULL,0,0,NULL),(49,20,0,'ART1974 -BG','2023-10-09 17:12:53','Facturación','',752,59,'LSD4601974 ','',0,0,0,0,0,'Modelo: M3040IDN\r\n\r\nUser: Admin\r\nContraseña: Admin\r\n\r\nIP:10.3.128.66\r\n','',71,0,4,13,79,0,0,0,NULL,0,0,860,22,1,0.0000,0,NULL,'2023-10-09 17:11:43',NULL,NULL,0,0,NULL),(50,20,0,'ART0140-BG','2023-10-09 17:24:26','Contabilidad','',752,59,'LW33X00140 ','',0,0,0,0,0,'Modelo: FS-P6021CDN\r\n\r\nUser: N/A\r\nContraseña: N/A\r\n\r\nIP:10.3.128.69\r\n\r\n','',71,0,4,0,79,0,0,0,NULL,0,0,798,22,1,0.0000,0,NULL,'2023-10-09 17:19:45',NULL,NULL,0,0,NULL),(51,20,0,'ART0823-BG','2023-10-09 17:27:42','PRODUCCION','',752,59,'ALLY120823','',0,0,0,0,0,'\r\nModelo: FX-880\r\n','',71,0,0,0,39,0,0,0,NULL,0,0,1056,22,1,0.0000,0,NULL,'2023-10-09 17:27:42',NULL,NULL,0,0,NULL),(52,20,0,'ART9129-BG','2023-10-09 17:28:39','FACTURACION','',752,59,'E8BY429129','',0,0,0,0,0,'\r\nModelo: FX-890\r\n','',71,0,0,0,39,0,0,0,NULL,0,0,786,22,1,0.0000,0,NULL,'2023-10-09 17:28:39',NULL,NULL,0,0,NULL),(53,20,0,'ART2880-BG','2023-10-09 17:29:38','Laboratorio','',752,59,'0A50352880','',0,0,0,0,0,'\r\nModelo: LX-810\r\n','',71,0,0,0,39,0,0,0,NULL,0,0,894,22,1,0.0000,0,NULL,'2023-10-09 17:29:38',NULL,NULL,0,0,NULL),(54,20,0,'ART3781-BG','2023-10-09 17:40:38','Contabilidad','',752,59,'6211003781','',0,0,0,0,0,'Modelo: FX-1170\r\n','',71,0,0,0,39,0,0,0,NULL,0,0,950,22,3,0.0000,0,NULL,'2023-10-09 17:38:52',NULL,NULL,0,0,NULL),(55,20,0,'ART5898-BG','2023-10-09 17:41:23','Contabilidad','',752,59,'6211075898','',0,0,0,0,0,'\r\nModelo: FX-1170\r\n','',71,0,0,0,39,0,0,0,NULL,0,0,950,22,3,0.0000,0,NULL,'2023-10-09 17:41:23',NULL,NULL,0,0,NULL),(56,20,0,'ART4138-BG','2023-10-09 17:49:05','Contabilidad','',752,59,'A2SY054138','',0,0,0,0,0,'\r\nModelo: FX-1180\r\n','',71,0,0,0,39,0,0,0,NULL,0,0,950,22,3,0.0000,0,NULL,'2023-10-09 17:49:05',NULL,NULL,0,0,NULL),(57,20,0,'ART1895-BG','2023-10-09 17:50:55','Compras','',752,59,'A2SY031895','',0,0,0,0,0,'\r\nModelo: FX-1180\r\n','',71,0,0,0,39,0,0,0,NULL,0,0,950,22,3,0.0000,0,NULL,'2023-10-09 17:50:55',NULL,NULL,0,0,NULL),(58,20,0,'ART2282-BG','2023-10-09 17:52:07','Servicio al Cliente','',752,59,'1YMY262282','',0,0,0,0,0,'\r\nModelo: LX-300\r\n','',71,0,0,0,39,0,0,0,NULL,0,0,950,22,3,0.0000,0,NULL,'2023-10-09 17:52:07',NULL,NULL,0,0,NULL),(59,20,0,'ART2285-BG','2023-10-09 17:53:46','Almacén','',752,59,'1YMY262285','',0,0,0,0,0,'Modelo: LX-300\r\n','',71,0,0,0,39,0,0,0,NULL,0,0,950,22,3,0.0000,0,NULL,'2023-10-09 17:53:05',NULL,NULL,0,0,NULL),(60,20,0,'ART5958-BG','2023-10-09 17:54:43','Almacén','',752,59,'6211075958','',0,0,0,0,0,'\r\nModelo: FX-1170\r\n','',71,0,0,0,39,0,0,0,NULL,0,0,950,22,3,0.0000,0,NULL,'2023-10-09 17:54:43',NULL,NULL,0,0,NULL),(61,20,0,'ART6860-BG','2023-10-09 17:55:38','Almacén','',752,59,'E8BY326860','',0,0,0,0,0,'\r\nModelo: FX-890\r\n','',36,0,0,0,39,0,0,0,NULL,0,0,950,22,3,0.0000,0,NULL,'2023-10-09 17:55:38',NULL,NULL,0,0,NULL);

--
-- Table structure for table `glpi_printers_cartridgeinfos`
--

CREATE TABLE `glpi_printers_cartridgeinfos` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `printers_id` int unsigned NOT NULL,
  `property` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `printers_id` (`printers_id`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_printers_cartridgeinfos`
--


--
-- Table structure for table `glpi_printertypes`
--

CREATE TABLE `glpi_printertypes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_printertypes`
--

INSERT INTO `glpi_printertypes` VALUES (1,'Inyección','','2020-07-16 15:39:51','2020-07-16 15:39:51'),(2,'Laser - Multifuncional','','2021-01-04 16:21:42','2021-01-04 16:21:42'),(3,'Laser Sencilla','','2021-01-04 16:21:49','2021-01-04 16:21:49'),(4,'Multifuncional','','2021-05-26 16:42:36','2021-05-26 16:42:36'),(5,'Plotter','','2022-07-07 21:36:25','2022-07-07 21:36:25'),(6,'Térmica','','2022-10-03 18:12:15','2022-10-03 18:12:15');

--
-- Table structure for table `glpi_problemcosts`
--

CREATE TABLE `glpi_problemcosts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `problems_id` int unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `begin_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `actiontime` int 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 unsigned NOT NULL DEFAULT '0',
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `problems_id` (`problems_id`),
  KEY `begin_date` (`begin_date`),
  KEY `end_date` (`end_date`),
  KEY `entities_id` (`entities_id`),
  KEY `budgets_id` (`budgets_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_problemcosts`
--


--
-- Table structure for table `glpi_problems`
--

CREATE TABLE `glpi_problems` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '1',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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 unsigned NOT NULL DEFAULT '0',
  `users_id_lastupdater` int unsigned NOT NULL DEFAULT '0',
  `urgency` int NOT NULL DEFAULT '1',
  `impact` int NOT NULL DEFAULT '1',
  `priority` int NOT NULL DEFAULT '1',
  `itilcategories_id` int unsigned NOT NULL DEFAULT '0',
  `impactcontent` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `causecontent` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `symptomcontent` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `actiontime` int NOT NULL DEFAULT '0',
  `begin_waiting_date` timestamp NULL DEFAULT NULL,
  `waiting_duration` int NOT NULL DEFAULT '0',
  `close_delay_stat` int NOT NULL DEFAULT '0',
  `solve_delay_stat` int NOT NULL DEFAULT '0',
  `date_creation` timestamp NULL DEFAULT NULL,
  `locations_id` int unsigned NOT NULL DEFAULT '0',
  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 `users_id_lastupdater` (`users_id_lastupdater`),
  KEY `date_creation` (`date_creation`),
  KEY `locations_id` (`locations_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_problems`
--


--
-- Table structure for table `glpi_problems_suppliers`
--

CREATE TABLE `glpi_problems_suppliers` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `problems_id` int unsigned NOT NULL DEFAULT '0',
  `suppliers_id` int unsigned NOT NULL DEFAULT '0',
  `type` int NOT NULL DEFAULT '1',
  `use_notification` tinyint(1) NOT NULL DEFAULT '0',
  `alternative_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`problems_id`,`type`,`suppliers_id`),
  KEY `group` (`suppliers_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_problems_suppliers`
--


--
-- Table structure for table `glpi_problems_tickets`
--

CREATE TABLE `glpi_problems_tickets` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `problems_id` int unsigned NOT NULL DEFAULT '0',
  `tickets_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`problems_id`,`tickets_id`),
  KEY `tickets_id` (`tickets_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_problems_tickets`
--


--
-- Table structure for table `glpi_problems_users`
--

CREATE TABLE `glpi_problems_users` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `problems_id` int unsigned NOT NULL DEFAULT '0',
  `users_id` int unsigned NOT NULL DEFAULT '0',
  `type` int NOT NULL DEFAULT '1',
  `use_notification` tinyint(1) NOT NULL DEFAULT '0',
  `alternative_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`problems_id`,`type`,`users_id`,`alternative_email`),
  KEY `user` (`users_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_problems_users`
--


--
-- Table structure for table `glpi_problemtasks`
--

CREATE TABLE `glpi_problemtasks` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `problems_id` int unsigned NOT NULL DEFAULT '0',
  `taskcategories_id` int unsigned NOT NULL DEFAULT '0',
  `date` timestamp NULL DEFAULT NULL,
  `begin` timestamp NULL DEFAULT NULL,
  `end` timestamp NULL DEFAULT NULL,
  `users_id` int unsigned NOT NULL DEFAULT '0',
  `users_id_editor` int unsigned NOT NULL DEFAULT '0',
  `users_id_tech` int unsigned NOT NULL DEFAULT '0',
  `groups_id_tech` int unsigned NOT NULL DEFAULT '0',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `actiontime` int NOT NULL DEFAULT '0',
  `state` int NOT NULL DEFAULT '0',
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `tasktemplates_id` int unsigned 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 `problems_id` (`problems_id`),
  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 `state` (`state`),
  KEY `taskcategories_id` (`taskcategories_id`),
  KEY `tasktemplates_id` (`tasktemplates_id`),
  KEY `is_private` (`is_private`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_problemtasks`
--


--
-- Table structure for table `glpi_problemtemplatehiddenfields`
--

CREATE TABLE `glpi_problemtemplatehiddenfields` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `problemtemplates_id` int unsigned NOT NULL DEFAULT '0',
  `num` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`problemtemplates_id`,`num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_problemtemplatehiddenfields`
--


--
-- Table structure for table `glpi_problemtemplatemandatoryfields`
--

CREATE TABLE `glpi_problemtemplatemandatoryfields` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `problemtemplates_id` int unsigned NOT NULL DEFAULT '0',
  `num` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`problemtemplates_id`,`num`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_problemtemplatemandatoryfields`
--

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

--
-- Table structure for table `glpi_problemtemplatepredefinedfields`
--

CREATE TABLE `glpi_problemtemplatepredefinedfields` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `problemtemplates_id` int unsigned NOT NULL DEFAULT '0',
  `num` int NOT NULL DEFAULT '0',
  `value` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `problemtemplates_id` (`problemtemplates_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_problemtemplatepredefinedfields`
--


--
-- Table structure for table `glpi_problemtemplates`
--

CREATE TABLE `glpi_problemtemplates` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_problemtemplates`
--

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

--
-- Table structure for table `glpi_profilerights`
--

CREATE TABLE `glpi_profilerights` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `profiles_id` int unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rights` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`profiles_id`,`name`),
  KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=1602 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_profilerights`
--

INSERT INTO `glpi_profilerights` VALUES (1,1,'computer',0),(2,1,'monitor',0),(3,1,'software',0),(4,1,'networking',0),(5,1,'internet',0),(6,1,'printer',0),(7,1,'peripheral',0),(8,1,'cartridge',0),(9,1,'consumable',0),(10,1,'phone',0),(12,1,'contact_enterprise',0),(13,1,'document',0),(14,1,'contract',0),(15,1,'infocom',0),(16,1,'knowbase',2048),(20,1,'reservation',1024),(21,1,'reports',0),(22,1,'dropdown',0),(24,1,'device',0),(25,1,'typedoc',0),(26,1,'link',0),(27,1,'config',0),(29,1,'rule_ticket',0),(30,1,'rule_import',0),(31,1,'rule_ldap',0),(32,1,'rule_softwarecategories',0),(33,1,'search_config',0),(36,1,'profile',0),(37,1,'user',0),(39,1,'group',0),(40,1,'entity',0),(41,1,'transfer',0),(42,1,'logs',0),(43,1,'reminder_public',1),(44,1,'rssfeed_public',1),(45,1,'bookmark_public',0),(47,1,'ticket',5),(51,1,'followup',5),(52,1,'task',1),(64,1,'planning',0),(67,1,'statistic',0),(68,1,'password_update',1),(70,1,'show_group_hardware',0),(71,1,'rule_dictionnary_software',0),(72,1,'rule_dictionnary_dropdown',0),(73,1,'budget',0),(75,1,'notification',0),(76,1,'rule_mailcollector',0),(79,1,'calendar',0),(80,1,'slm',0),(81,1,'rule_dictionnary_printer',0),(85,1,'problem',0),(89,1,'itiltemplate',0),(90,1,'ticketrecurrent',0),(91,1,'ticketcost',0),(94,1,'ticketvalidation',0),(95,2,'computer',33),(96,2,'monitor',33),(97,2,'software',33),(98,2,'networking',33),(99,2,'internet',1),(100,2,'printer',33),(101,2,'peripheral',33),(102,2,'cartridge',33),(103,2,'consumable',33),(104,2,'phone',33),(106,2,'contact_enterprise',33),(107,2,'document',33),(108,2,'contract',33),(109,2,'infocom',1),(110,2,'knowbase',10241),(114,2,'reservation',1025),(115,2,'reports',1),(116,2,'dropdown',0),(118,2,'device',0),(119,2,'typedoc',1),(120,2,'link',1),(121,2,'config',0),(123,2,'rule_ticket',0),(124,2,'rule_import',0),(125,2,'rule_ldap',0),(126,2,'rule_softwarecategories',0),(127,2,'search_config',1024),(130,2,'profile',0),(131,2,'user',2049),(133,2,'group',33),(134,2,'entity',0),(135,2,'transfer',0),(136,2,'logs',0),(137,2,'reminder_public',129),(138,2,'rssfeed_public',129),(139,2,'bookmark_public',0),(141,2,'ticket',168989),(145,2,'followup',5),(146,2,'task',1),(158,2,'planning',1),(161,2,'statistic',1),(162,2,'password_update',1),(164,2,'show_group_hardware',0),(165,2,'rule_dictionnary_software',0),(166,2,'rule_dictionnary_dropdown',0),(167,2,'budget',33),(169,2,'notification',0),(170,2,'rule_mailcollector',0),(173,2,'calendar',0),(174,2,'slm',0),(175,2,'rule_dictionnary_printer',0),(179,2,'problem',1057),(183,2,'itiltemplate',0),(184,2,'ticketrecurrent',0),(185,2,'ticketcost',1),(188,2,'ticketvalidation',15376),(189,3,'computer',127),(190,3,'monitor',127),(191,3,'software',127),(192,3,'networking',127),(193,3,'internet',31),(194,3,'printer',127),(195,3,'peripheral',127),(196,3,'cartridge',127),(197,3,'consumable',127),(198,3,'phone',127),(200,3,'contact_enterprise',127),(201,3,'document',127),(202,3,'contract',127),(203,3,'infocom',23),(204,3,'knowbase',14359),(208,3,'reservation',1055),(209,3,'reports',1),(210,3,'dropdown',23),(212,3,'device',23),(213,3,'typedoc',23),(214,3,'link',23),(215,3,'config',0),(217,3,'rule_ticket',1047),(218,3,'rule_import',0),(219,3,'rule_ldap',0),(220,3,'rule_softwarecategories',0),(221,3,'search_config',3072),(224,3,'profile',1),(225,3,'user',7199),(227,3,'group',119),(228,3,'entity',33),(229,3,'transfer',1),(230,3,'logs',1),(231,3,'reminder_public',151),(232,3,'rssfeed_public',151),(233,3,'bookmark_public',23),(235,3,'ticket',261151),(239,3,'followup',15383),(240,3,'task',13329),(252,3,'planning',3073),(255,3,'statistic',1),(256,3,'password_update',1),(258,3,'show_group_hardware',0),(259,3,'rule_dictionnary_software',0),(260,3,'rule_dictionnary_dropdown',0),(261,3,'budget',127),(263,3,'notification',0),(264,3,'rule_mailcollector',23),(267,3,'calendar',23),(268,3,'slm',23),(269,3,'rule_dictionnary_printer',0),(273,3,'problem',1151),(277,3,'itiltemplate',23),(278,3,'ticketrecurrent',1),(279,3,'ticketcost',23),(282,3,'ticketvalidation',15376),(283,4,'computer',255),(284,4,'monitor',255),(285,4,'software',255),(286,4,'networking',255),(287,4,'internet',159),(288,4,'printer',255),(289,4,'peripheral',255),(290,4,'cartridge',255),(291,4,'consumable',255),(292,4,'phone',255),(294,4,'contact_enterprise',255),(295,4,'document',255),(296,4,'contract',255),(297,4,'infocom',23),(298,4,'knowbase',15383),(302,4,'reservation',1055),(303,4,'reports',1),(304,4,'dropdown',23),(306,4,'device',23),(307,4,'typedoc',23),(308,4,'link',159),(309,4,'config',3),(311,4,'rule_ticket',1047),(312,4,'rule_import',23),(313,4,'rule_ldap',23),(314,4,'rule_softwarecategories',23),(315,4,'search_config',3072),(318,4,'profile',23),(319,4,'user',7327),(321,4,'group',119),(322,4,'entity',3327),(323,4,'transfer',23),(324,4,'logs',1),(325,4,'reminder_public',159),(326,4,'rssfeed_public',159),(327,4,'bookmark_public',23),(329,4,'ticket',261151),(333,4,'followup',15383),(334,4,'task',13329),(346,4,'planning',3073),(349,4,'statistic',1),(350,4,'password_update',1),(352,4,'show_group_hardware',1),(353,4,'rule_dictionnary_software',23),(354,4,'rule_dictionnary_dropdown',23),(355,4,'budget',127),(357,4,'notification',23),(358,4,'rule_mailcollector',23),(361,4,'calendar',23),(362,4,'slm',23),(363,4,'rule_dictionnary_printer',23),(367,4,'problem',1151),(371,4,'itiltemplate',23),(372,4,'ticketrecurrent',23),(373,4,'ticketcost',23),(376,4,'ticketvalidation',15376),(377,5,'computer',0),(378,5,'monitor',0),(379,5,'software',0),(380,5,'networking',0),(381,5,'internet',0),(382,5,'printer',0),(383,5,'peripheral',0),(384,5,'cartridge',0),(385,5,'consumable',0),(386,5,'phone',0),(388,5,'contact_enterprise',0),(389,5,'document',0),(390,5,'contract',0),(391,5,'infocom',0),(392,5,'knowbase',10240),(396,5,'reservation',0),(397,5,'reports',0),(398,5,'dropdown',0),(400,5,'device',0),(401,5,'typedoc',0),(402,5,'link',0),(403,5,'config',0),(405,5,'rule_ticket',0),(406,5,'rule_import',0),(407,5,'rule_ldap',0),(408,5,'rule_softwarecategories',0),(409,5,'search_config',0),(412,5,'profile',0),(413,5,'user',1025),(415,5,'group',0),(416,5,'entity',0),(417,5,'transfer',0),(418,5,'logs',0),(419,5,'reminder_public',128),(420,5,'rssfeed_public',128),(421,5,'bookmark_public',0),(423,5,'ticket',140295),(427,5,'followup',12295),(428,5,'task',8193),(440,5,'planning',1),(443,5,'statistic',1),(444,5,'password_update',1),(446,5,'show_group_hardware',0),(447,5,'rule_dictionnary_software',0),(448,5,'rule_dictionnary_dropdown',0),(449,5,'budget',0),(451,5,'notification',0),(452,5,'rule_mailcollector',0),(455,5,'calendar',0),(456,5,'slm',0),(457,5,'rule_dictionnary_printer',0),(461,5,'problem',1024),(465,5,'itiltemplate',0),(466,5,'ticketrecurrent',0),(467,5,'ticketcost',23),(470,5,'ticketvalidation',3088),(471,6,'computer',127),(472,6,'monitor',127),(473,6,'software',127),(474,6,'networking',127),(475,6,'internet',31),(476,6,'printer',127),(477,6,'peripheral',127),(478,6,'cartridge',127),(479,6,'consumable',127),(480,6,'phone',127),(482,6,'contact_enterprise',127),(483,6,'document',127),(484,6,'contract',96),(485,6,'infocom',0),(486,6,'knowbase',14359),(490,6,'reservation',1055),(491,6,'reports',1),(492,6,'dropdown',0),(494,6,'device',0),(495,6,'typedoc',0),(496,6,'link',0),(497,6,'config',0),(499,6,'rule_ticket',0),(500,6,'rule_import',0),(501,6,'rule_ldap',0),(502,6,'rule_softwarecategories',0),(503,6,'search_config',0),(506,6,'profile',0),(507,6,'user',1055),(509,6,'group',1),(510,6,'entity',33),(511,6,'transfer',1),(512,6,'logs',0),(513,6,'reminder_public',151),(514,6,'rssfeed_public',151),(515,6,'bookmark_public',0),(517,6,'ticket',166919),(521,6,'followup',13319),(522,6,'task',13329),(534,6,'planning',1),(537,6,'statistic',1),(538,6,'password_update',1),(540,6,'show_group_hardware',0),(541,6,'rule_dictionnary_software',0),(542,6,'rule_dictionnary_dropdown',0),(543,6,'budget',96),(545,6,'notification',0),(546,6,'rule_mailcollector',0),(549,6,'calendar',0),(550,6,'slm',1),(551,6,'rule_dictionnary_printer',0),(555,6,'problem',1121),(559,6,'itiltemplate',1),(560,6,'ticketrecurrent',1),(561,6,'ticketcost',23),(564,6,'ticketvalidation',3088),(565,7,'computer',127),(566,7,'monitor',127),(567,7,'software',127),(568,7,'networking',127),(569,7,'internet',31),(570,7,'printer',127),(571,7,'peripheral',127),(572,7,'cartridge',127),(573,7,'consumable',127),(574,7,'phone',127),(576,7,'contact_enterprise',96),(577,7,'document',127),(578,7,'contract',96),(579,7,'infocom',0),(580,7,'knowbase',14359),(584,7,'reservation',1055),(585,7,'reports',1),(586,7,'dropdown',0),(588,7,'device',0),(589,7,'typedoc',0),(590,7,'link',0),(591,7,'config',0),(593,7,'rule_ticket',1047),(594,7,'rule_import',0),(595,7,'rule_ldap',0),(596,7,'rule_softwarecategories',0),(597,7,'search_config',0),(600,7,'profile',0),(601,7,'user',1055),(603,7,'group',119),(604,7,'entity',3191),(605,7,'transfer',1),(606,7,'logs',1),(607,7,'reminder_public',151),(608,7,'rssfeed_public',151),(609,7,'bookmark_public',0),(611,7,'ticket',261151),(615,7,'followup',15383),(616,7,'task',13329),(628,7,'planning',3073),(631,7,'statistic',1),(632,7,'password_update',1),(634,7,'show_group_hardware',0),(635,7,'rule_dictionnary_software',0),(636,7,'rule_dictionnary_dropdown',0),(637,7,'budget',96),(639,7,'notification',0),(640,7,'rule_mailcollector',23),(643,7,'calendar',23),(644,7,'slm',23),(645,7,'rule_dictionnary_printer',0),(649,7,'problem',1151),(653,7,'itiltemplate',23),(654,7,'ticketrecurrent',1),(655,7,'ticketcost',23),(658,7,'ticketvalidation',15376),(659,1,'change',0),(660,2,'change',1057),(661,3,'change',1151),(662,4,'change',1151),(663,5,'change',1054),(664,6,'change',1151),(665,7,'change',1151),(666,1,'changevalidation',0),(667,2,'changevalidation',1044),(668,3,'changevalidation',1044),(669,4,'changevalidation',1044),(670,5,'changevalidation',20),(671,6,'changevalidation',20),(672,7,'changevalidation',1044),(673,1,'domain',0),(674,2,'domain',0),(675,3,'domain',23),(676,4,'domain',23),(677,5,'domain',0),(678,6,'domain',0),(679,7,'domain',23),(680,1,'location',0),(681,2,'location',0),(682,3,'location',23),(683,4,'location',23),(684,5,'location',0),(685,6,'location',0),(686,7,'location',23),(687,1,'itilcategory',0),(688,2,'itilcategory',0),(689,3,'itilcategory',23),(690,4,'itilcategory',23),(691,5,'itilcategory',0),(692,6,'itilcategory',0),(693,7,'itilcategory',23),(694,1,'knowbasecategory',0),(695,2,'knowbasecategory',0),(696,3,'knowbasecategory',23),(697,4,'knowbasecategory',23),(698,5,'knowbasecategory',0),(699,6,'knowbasecategory',0),(700,7,'knowbasecategory',23),(701,1,'cable_management',0),(702,2,'cable_management',0),(703,3,'cable_management',31),(704,4,'cable_management',31),(705,5,'cable_management',0),(706,6,'cable_management',0),(707,7,'cable_management',31),(708,1,'taskcategory',0),(709,2,'taskcategory',0),(710,3,'taskcategory',23),(711,4,'taskcategory',23),(712,5,'taskcategory',0),(713,6,'taskcategory',0),(714,7,'taskcategory',23),(715,1,'state',0),(716,2,'state',0),(717,3,'state',23),(718,4,'state',23),(719,5,'state',0),(720,6,'state',0),(721,7,'state',23),(722,1,'solutiontemplate',0),(723,2,'solutiontemplate',0),(724,3,'solutiontemplate',23),(725,4,'solutiontemplate',23),(726,5,'solutiontemplate',0),(727,6,'solutiontemplate',0),(728,7,'solutiontemplate',23),(729,1,'queuednotification',0),(730,2,'queuednotification',0),(731,3,'queuednotification',0),(732,4,'queuednotification',31),(733,5,'queuednotification',0),(734,6,'queuednotification',0),(735,7,'queuednotification',0),(736,1,'project',0),(737,2,'project',1025),(738,3,'project',1151),(739,4,'project',1151),(740,5,'project',1151),(741,6,'project',1151),(742,7,'project',1151),(743,1,'projecttask',0),(744,2,'projecttask',1025),(745,3,'projecttask',1121),(746,4,'projecttask',1121),(747,5,'projecttask',0),(748,6,'projecttask',1025),(749,7,'projecttask',1025),(751,8,'bookmark_public',1),(752,8,'budget',33),(753,8,'calendar',1),(754,8,'cartridge',33),(755,8,'change',1057),(756,8,'changevalidation',0),(757,8,'computer',33),(758,8,'config',1),(759,8,'consumable',33),(760,8,'contact_enterprise',33),(761,8,'contract',33),(762,8,'device',1),(763,8,'document',33),(764,8,'domain',1),(765,8,'dropdown',1),(766,8,'entity',33),(767,8,'followup',8193),(768,8,'global_validation',0),(769,8,'group',33),(770,8,'infocom',1),(771,8,'internet',1),(772,8,'itilcategory',1),(773,8,'knowbase',10241),(774,8,'knowbasecategory',1),(775,8,'link',1),(776,8,'location',1),(777,8,'logs',1),(778,8,'monitor',33),(779,8,'cable_management',1),(780,8,'networking',33),(781,8,'notification',1),(782,8,'password_update',0),(783,8,'peripheral',33),(784,8,'phone',33),(785,8,'planning',3073),(786,8,'printer',33),(787,8,'problem',1057),(788,8,'profile',1),(789,8,'project',1057),(790,8,'projecttask',33),(791,8,'queuednotification',1),(792,8,'reminder_public',129),(793,8,'reports',1),(794,8,'reservation',1),(795,8,'rssfeed_public',129),(796,8,'rule_dictionnary_dropdown',1),(797,8,'rule_dictionnary_printer',1),(798,8,'rule_dictionnary_software',1),(799,8,'rule_import',1),(800,8,'rule_ldap',1),(801,8,'rule_mailcollector',1),(802,8,'rule_softwarecategories',1),(803,8,'rule_ticket',1),(804,8,'search_config',0),(805,8,'show_group_hardware',1),(806,8,'slm',1),(807,8,'software',33),(808,8,'solutiontemplate',1),(809,8,'state',1),(810,8,'statistic',1),(811,8,'task',8193),(812,8,'taskcategory',1),(813,8,'ticket',138241),(814,8,'ticketcost',1),(815,8,'ticketrecurrent',1),(816,8,'itiltemplate',1),(817,8,'ticketvalidation',0),(818,8,'transfer',1),(819,8,'typedoc',1),(820,8,'user',1),(821,1,'license',0),(822,2,'license',33),(823,3,'license',127),(824,4,'license',255),(825,5,'license',0),(826,6,'license',127),(827,7,'license',127),(828,8,'license',33),(829,1,'line',0),(830,2,'line',33),(831,3,'line',127),(832,4,'line',255),(833,5,'line',0),(834,6,'line',127),(835,7,'line',127),(836,8,'line',33),(837,1,'lineoperator',0),(838,2,'lineoperator',33),(839,3,'lineoperator',23),(840,4,'lineoperator',23),(841,5,'lineoperator',0),(842,6,'lineoperator',0),(843,7,'lineoperator',23),(844,8,'lineoperator',1),(845,1,'devicesimcard_pinpuk',0),(846,2,'devicesimcard_pinpuk',1),(847,3,'devicesimcard_pinpuk',3),(848,4,'devicesimcard_pinpuk',3),(849,5,'devicesimcard_pinpuk',0),(850,6,'devicesimcard_pinpuk',3),(851,7,'devicesimcard_pinpuk',3),(852,8,'devicesimcard_pinpuk',1),(853,1,'certificate',0),(854,2,'certificate',33),(855,3,'certificate',127),(856,4,'certificate',255),(857,5,'certificate',0),(858,6,'certificate',127),(859,7,'certificate',127),(860,8,'certificate',33),(861,1,'datacenter',0),(862,2,'datacenter',1),(863,3,'datacenter',31),(864,4,'datacenter',31),(865,5,'datacenter',0),(866,6,'datacenter',31),(867,7,'datacenter',31),(868,8,'datacenter',1),(870,4,'rule_asset',1047),(871,1,'personalization',3),(872,2,'personalization',3),(873,3,'personalization',3),(874,4,'personalization',3),(875,5,'personalization',3),(876,6,'personalization',3),(877,7,'personalization',3),(878,8,'personalization',3),(879,1,'rule_asset',0),(880,2,'rule_asset',0),(881,3,'rule_asset',0),(882,5,'rule_asset',0),(883,6,'rule_asset',0),(884,7,'rule_asset',0),(885,8,'rule_asset',0),(886,1,'global_validation',0),(887,2,'global_validation',0),(888,3,'global_validation',0),(889,4,'global_validation',0),(890,5,'global_validation',0),(891,6,'global_validation',0),(892,7,'global_validation',0),(893,4,'plugin_archires',31),(894,2,'plugin_pdf',0),(895,3,'plugin_pdf',0),(897,5,'plugin_pdf',0),(898,6,'plugin_pdf',0),(899,7,'plugin_pdf',0),(900,8,'plugin_pdf',0),(901,1,'plugin_pdf',0),(902,4,'plugin_pdf',1),(903,2,'plugin_ocsinventoryng',0),(904,3,'plugin_ocsinventoryng',0),(906,5,'plugin_ocsinventoryng',0),(907,6,'plugin_ocsinventoryng',0),(908,7,'plugin_ocsinventoryng',0),(909,8,'plugin_ocsinventoryng',0),(910,1,'plugin_ocsinventoryng',0),(911,2,'plugin_ocsinventoryng_sync',0),(912,3,'plugin_ocsinventoryng_sync',0),(914,5,'plugin_ocsinventoryng_sync',0),(915,6,'plugin_ocsinventoryng_sync',0),(916,7,'plugin_ocsinventoryng_sync',0),(917,8,'plugin_ocsinventoryng_sync',0),(918,1,'plugin_ocsinventoryng_sync',0),(919,2,'plugin_ocsinventoryng_view',0),(920,3,'plugin_ocsinventoryng_view',0),(922,5,'plugin_ocsinventoryng_view',0),(923,6,'plugin_ocsinventoryng_view',0),(924,7,'plugin_ocsinventoryng_view',0),(925,8,'plugin_ocsinventoryng_view',0),(926,1,'plugin_ocsinventoryng_view',0),(927,2,'plugin_ocsinventoryng_clean',0),(928,3,'plugin_ocsinventoryng_clean',0),(930,5,'plugin_ocsinventoryng_clean',0),(931,6,'plugin_ocsinventoryng_clean',0),(932,7,'plugin_ocsinventoryng_clean',0),(933,8,'plugin_ocsinventoryng_clean',0),(934,1,'plugin_ocsinventoryng_clean',0),(935,2,'plugin_ocsinventoryng_import',0),(936,3,'plugin_ocsinventoryng_import',0),(938,5,'plugin_ocsinventoryng_import',0),(939,6,'plugin_ocsinventoryng_import',0),(940,7,'plugin_ocsinventoryng_import',0),(941,8,'plugin_ocsinventoryng_import',0),(942,1,'plugin_ocsinventoryng_import',0),(943,2,'plugin_ocsinventoryng_link',0),(944,3,'plugin_ocsinventoryng_link',0),(946,5,'plugin_ocsinventoryng_link',0),(947,6,'plugin_ocsinventoryng_link',0),(948,7,'plugin_ocsinventoryng_link',0),(949,8,'plugin_ocsinventoryng_link',0),(950,1,'plugin_ocsinventoryng_link',0),(951,2,'plugin_ocsinventoryng_rule',0),(952,3,'plugin_ocsinventoryng_rule',0),(954,5,'plugin_ocsinventoryng_rule',0),(955,6,'plugin_ocsinventoryng_rule',0),(956,7,'plugin_ocsinventoryng_rule',0),(957,8,'plugin_ocsinventoryng_rule',0),(958,1,'plugin_ocsinventoryng_rule',0),(966,2,'plugin_webapplications',0),(967,3,'plugin_webapplications',0),(969,5,'plugin_webapplications',0),(970,6,'plugin_webapplications',0),(971,7,'plugin_webapplications',0),(972,8,'plugin_webapplications',0),(973,1,'plugin_webapplications',0),(974,2,'plugin_webapplications_open_ticket',0),(975,3,'plugin_webapplications_open_ticket',0),(977,5,'plugin_webapplications_open_ticket',0),(978,6,'plugin_webapplications_open_ticket',0),(979,7,'plugin_webapplications_open_ticket',0),(980,8,'plugin_webapplications_open_ticket',0),(981,1,'plugin_webapplications_open_ticket',0),(982,4,'plugin_webapplications',127),(983,4,'plugin_webapplications_open_ticket',1),(984,2,'plugin_resources',0),(985,3,'plugin_resources',0),(987,5,'plugin_resources',0),(988,6,'plugin_resources',0),(989,7,'plugin_resources',0),(990,8,'plugin_resources',0),(991,1,'plugin_resources',0),(992,2,'plugin_resources_task',0),(993,3,'plugin_resources_task',0),(995,5,'plugin_resources_task',0),(996,6,'plugin_resources_task',0),(997,7,'plugin_resources_task',0),(998,8,'plugin_resources_task',0),(999,1,'plugin_resources_task',0),(1000,2,'plugin_resources_budget',0),(1001,3,'plugin_resources_budget',0),(1003,5,'plugin_resources_budget',0),(1004,6,'plugin_resources_budget',0),(1005,7,'plugin_resources_budget',0),(1006,8,'plugin_resources_budget',0),(1007,1,'plugin_resources_budget',0),(1008,2,'plugin_resources_checklist',0),(1009,3,'plugin_resources_checklist',0),(1011,5,'plugin_resources_checklist',0),(1012,6,'plugin_resources_checklist',0),(1013,7,'plugin_resources_checklist',0),(1014,8,'plugin_resources_checklist',0),(1015,1,'plugin_resources_checklist',0),(1016,2,'plugin_resources_employee',0),(1017,3,'plugin_resources_employee',0),(1019,5,'plugin_resources_employee',0),(1020,6,'plugin_resources_employee',0),(1021,7,'plugin_resources_employee',0),(1022,8,'plugin_resources_employee',0),(1023,1,'plugin_resources_employee',0),(1024,2,'plugin_resources_resting',0),(1025,3,'plugin_resources_resting',0),(1027,5,'plugin_resources_resting',0),(1028,6,'plugin_resources_resting',0),(1029,7,'plugin_resources_resting',0),(1030,8,'plugin_resources_resting',0),(1031,1,'plugin_resources_resting',0),(1032,2,'plugin_resources_holiday',0),(1033,3,'plugin_resources_holiday',0),(1035,5,'plugin_resources_holiday',0),(1036,6,'plugin_resources_holiday',0),(1037,7,'plugin_resources_holiday',0),(1038,8,'plugin_resources_holiday',0),(1039,1,'plugin_resources_holiday',0),(1040,2,'plugin_resources_habilitation',0),(1041,3,'plugin_resources_habilitation',0),(1043,5,'plugin_resources_habilitation',0),(1044,6,'plugin_resources_habilitation',0),(1045,7,'plugin_resources_habilitation',0),(1046,8,'plugin_resources_habilitation',0),(1047,1,'plugin_resources_habilitation',0),(1048,2,'plugin_resources_employment',0),(1049,3,'plugin_resources_employment',0),(1051,5,'plugin_resources_employment',0),(1052,6,'plugin_resources_employment',0),(1053,7,'plugin_resources_employment',0),(1054,8,'plugin_resources_employment',0),(1055,1,'plugin_resources_employment',0),(1056,2,'plugin_resources_dropdown_public',0),(1057,3,'plugin_resources_dropdown_public',0),(1059,5,'plugin_resources_dropdown_public',0),(1060,6,'plugin_resources_dropdown_public',0),(1061,7,'plugin_resources_dropdown_public',0),(1062,8,'plugin_resources_dropdown_public',0),(1063,1,'plugin_resources_dropdown_public',0),(1064,2,'plugin_resources_import',0),(1065,3,'plugin_resources_import',0),(1067,5,'plugin_resources_import',0),(1068,6,'plugin_resources_import',0),(1069,7,'plugin_resources_import',0),(1070,8,'plugin_resources_import',0),(1071,1,'plugin_resources_import',0),(1072,2,'plugin_resources_all',0),(1073,3,'plugin_resources_all',0),(1075,5,'plugin_resources_all',0),(1076,6,'plugin_resources_all',0),(1077,7,'plugin_resources_all',0),(1078,8,'plugin_resources_all',0),(1079,1,'plugin_resources_all',0),(1080,2,'plugin_resources_open_ticket',0),(1081,3,'plugin_resources_open_ticket',0),(1083,5,'plugin_resources_open_ticket',0),(1084,6,'plugin_resources_open_ticket',0),(1085,7,'plugin_resources_open_ticket',0),(1086,8,'plugin_resources_open_ticket',0),(1087,1,'plugin_resources_open_ticket',0),(1088,4,'plugin_resources',127),(1089,4,'plugin_resources_task',31),(1090,4,'plugin_resources_checklist',31),(1091,4,'plugin_resources_employee',31),(1092,4,'plugin_resources_resting',31),(1093,4,'plugin_resources_holiday',31),(1094,4,'plugin_resources_habilitation',31),(1095,4,'plugin_resources_employment',31),(1096,4,'plugin_resources_budget',31),(1097,4,'plugin_resources_dropdown_public',31),(1098,4,'plugin_resources_import',0),(1099,4,'plugin_resources_open_ticket',1),(1100,4,'plugin_resources_all',1),(1101,6,'plugin_archires',0),(1102,2,'cluster',0),(1103,3,'cluster',0),(1104,4,'cluster',31),(1105,5,'cluster',0),(1106,6,'cluster',0),(1107,7,'cluster',0),(1108,8,'cluster',0),(1109,1,'cluster',0),(1110,2,'externalevent',1055),(1111,3,'externalevent',1055),(1112,4,'externalevent',1055),(1113,5,'externalevent',1055),(1114,6,'externalevent',1055),(1115,7,'externalevent',1055),(1116,8,'externalevent',1055),(1117,1,'externalevent',0),(1118,2,'dashboard',0),(1119,3,'dashboard',0),(1120,4,'dashboard',23),(1121,5,'dashboard',0),(1122,6,'dashboard',0),(1123,7,'dashboard',0),(1124,8,'dashboard',0),(1125,1,'dashboard',0),(1126,2,'appliance',0),(1127,3,'appliance',0),(1128,4,'appliance',31),(1129,5,'appliance',0),(1130,6,'appliance',0),(1131,7,'appliance',0),(1132,8,'appliance',0),(1133,1,'appliance',0),(1155,9,'appliance',1),(1156,9,'bookmark_public',3),(1157,9,'budget',1),(1158,9,'calendar',0),(1159,9,'cartridge',111),(1160,9,'certificate',1),(1161,9,'change',1135),(1162,9,'changevalidation',1028),(1163,9,'cluster',1),(1164,9,'computer',111),(1165,9,'config',0),(1166,9,'consumable',111),(1167,9,'contact_enterprise',1),(1168,9,'contract',1),(1169,9,'dashboard',0),(1170,9,'datacenter',1),(1171,9,'device',0),(1172,9,'devicesimcard_pinpuk',3),(1173,9,'document',103),(1174,9,'domain',1),(1175,9,'dropdown',0),(1176,9,'entity',1),(1177,9,'externalevent',1031),(1178,9,'followup',15383),(1179,9,'global_validation',0),(1180,9,'group',1),(1181,9,'infocom',1),(1182,9,'internet',15),(1183,9,'itilcategory',0),(1184,9,'itiltemplate',1),(1185,9,'knowbase',3),(1186,9,'knowbasecategory',0),(1187,9,'license',3),(1188,9,'line',7),(1189,9,'lineoperator',0),(1190,9,'link',0),(1191,9,'location',0),(1192,9,'logs',1),(1193,9,'monitor',111),(1194,9,'cable_management',0),(1195,9,'networking',111),(1196,9,'notification',0),(1197,9,'password_update',1),(1198,9,'peripheral',111),(1199,9,'personalization',0),(1200,9,'phone',111),(1201,9,'planning',1025),(1202,9,'plugin_ocsinventoryng',23),(1203,9,'plugin_ocsinventoryng_clean',3),(1204,9,'plugin_ocsinventoryng_import',3),(1205,9,'plugin_ocsinventoryng_link',3),(1206,9,'plugin_ocsinventoryng_rule',3),(1207,9,'plugin_ocsinventoryng_sync',3),(1208,9,'plugin_ocsinventoryng_view',1),(1209,9,'plugin_pdf',0),(1210,9,'plugin_resources',0),(1211,9,'plugin_resources_all',0),(1212,9,'plugin_resources_budget',0),(1213,9,'plugin_resources_checklist',0),(1214,9,'plugin_resources_dropdown_public',0),(1215,9,'plugin_resources_employee',0),(1216,9,'plugin_resources_employment',0),(1217,9,'plugin_resources_habilitation',0),(1218,9,'plugin_resources_holiday',0),(1219,9,'plugin_resources_import',0),(1220,9,'plugin_resources_open_ticket',0),(1221,9,'plugin_resources_resting',0),(1222,9,'plugin_resources_task',0),(1223,9,'plugin_webapplications',0),(1224,9,'plugin_webapplications_open_ticket',0),(1225,9,'printer',111),(1226,9,'problem',1135),(1227,9,'profile',1),(1228,9,'project',3),(1229,9,'projecttask',1),(1230,9,'queuednotification',1),(1231,9,'reminder_public',131),(1232,9,'reports',1),(1233,9,'reservation',7),(1234,9,'rssfeed_public',131),(1235,9,'rule_asset',1),(1236,9,'rule_dictionnary_dropdown',1),(1237,9,'rule_dictionnary_printer',7),(1238,9,'rule_dictionnary_software',1),(1239,9,'rule_import',1),(1240,9,'rule_ldap',1),(1241,9,'rule_mailcollector',1),(1242,9,'rule_softwarecategories',1),(1243,9,'rule_ticket',1),(1244,9,'search_config',0),(1245,9,'show_group_hardware',1),(1246,9,'slm',0),(1247,9,'software',111),(1248,9,'solutiontemplate',0),(1249,9,'state',0),(1250,9,'statistic',1),(1251,9,'task',13329),(1252,9,'taskcategory',0),(1253,9,'ticket',64527),(1254,9,'ticketcost',7),(1255,9,'ticketrecurrent',7),(1256,9,'ticketvalidation',15360),(1257,9,'transfer',7),(1258,9,'typedoc',0),(1259,9,'user',6147),(1260,9,'plugin_archires',0),(1261,10,'appliance',111),(1262,10,'bookmark_public',7),(1263,10,'budget',111),(1264,10,'calendar',0),(1265,10,'cartridge',103),(1266,10,'certificate',111),(1267,10,'change',1127),(1268,10,'changevalidation',1028),(1269,10,'cluster',15),(1270,10,'computer',103),(1271,10,'config',0),(1272,10,'consumable',103),(1273,10,'contact_enterprise',111),(1274,10,'contract',111),(1275,10,'dashboard',0),(1276,10,'datacenter',15),(1277,10,'device',0),(1278,10,'devicesimcard_pinpuk',3),(1279,10,'document',111),(1280,10,'domain',111),(1281,10,'dropdown',0),(1282,10,'entity',97),(1283,10,'externalevent',1047),(1284,10,'followup',15361),(1285,10,'global_validation',0),(1286,10,'group',97),(1287,10,'infocom',7),(1288,10,'internet',7),(1289,10,'itilcategory',0),(1290,10,'itiltemplate',3),(1291,10,'knowbase',14343),(1292,10,'knowbasecategory',0),(1293,10,'license',111),(1294,10,'line',111),(1295,10,'lineoperator',0),(1296,10,'link',0),(1297,10,'location',0),(1298,10,'logs',1),(1299,10,'monitor',103),(1300,10,'cable_management',0),(1301,10,'networking',103),(1302,10,'notification',0),(1303,10,'password_update',0),(1304,10,'peripheral',103),(1305,10,'personalization',0),(1306,10,'phone',103),(1307,10,'planning',3073),(1308,10,'plugin_ocsinventoryng',23),(1309,10,'plugin_ocsinventoryng_clean',3),(1310,10,'plugin_ocsinventoryng_import',3),(1311,10,'plugin_ocsinventoryng_link',3),(1312,10,'plugin_ocsinventoryng_rule',3),(1313,10,'plugin_ocsinventoryng_sync',3),(1314,10,'plugin_ocsinventoryng_view',1),(1315,10,'plugin_pdf',0),(1316,10,'plugin_resources',0),(1317,10,'plugin_resources_all',0),(1318,10,'plugin_resources_budget',0),(1319,10,'plugin_resources_checklist',0),(1320,10,'plugin_resources_dropdown_public',0),(1321,10,'plugin_resources_employee',0),(1322,10,'plugin_resources_employment',0),(1323,10,'plugin_resources_habilitation',0),(1324,10,'plugin_resources_holiday',0),(1325,10,'plugin_resources_import',0),(1326,10,'plugin_resources_open_ticket',0),(1327,10,'plugin_resources_resting',0),(1328,10,'plugin_resources_task',0),(1329,10,'plugin_webapplications',0),(1330,10,'plugin_webapplications_open_ticket',0),(1331,10,'printer',103),(1332,10,'problem',1151),(1333,10,'profile',1),(1334,10,'project',1127),(1335,10,'projecttask',1121),(1336,10,'queuednotification',0),(1337,10,'reminder_public',135),(1338,10,'reports',1),(1339,10,'reservation',1031),(1340,10,'rssfeed_public',135),(1341,10,'rule_asset',0),(1342,10,'rule_dictionnary_dropdown',0),(1343,10,'rule_dictionnary_printer',0),(1344,10,'rule_dictionnary_software',0),(1345,10,'rule_import',0),(1346,10,'rule_ldap',0),(1347,10,'rule_mailcollector',0),(1348,10,'rule_softwarecategories',0),(1349,10,'rule_ticket',0),(1350,10,'search_config',0),(1351,10,'show_group_hardware',1),(1352,10,'slm',0),(1353,10,'software',103),(1354,10,'solutiontemplate',0),(1355,10,'state',0),(1356,10,'statistic',1),(1357,10,'task',13313),(1358,10,'taskcategory',0),(1359,10,'ticket',261135),(1360,10,'ticketcost',7),(1361,10,'ticketrecurrent',7),(1362,10,'ticketvalidation',15360),(1363,10,'transfer',7),(1364,10,'typedoc',0),(1365,10,'user',1),(1366,10,'plugin_archires',0),(1367,11,'appliance',1),(1368,11,'bookmark_public',0),(1369,11,'budget',1),(1370,11,'calendar',0),(1371,11,'cartridge',0),(1372,11,'certificate',1),(1373,11,'change',1135),(1374,11,'changevalidation',1028),(1375,11,'cluster',1),(1376,11,'computer',0),(1377,11,'config',0),(1378,11,'consumable',0),(1379,11,'contact_enterprise',1),(1380,11,'contract',1),(1381,11,'dashboard',0),(1382,11,'datacenter',1),(1383,11,'device',0),(1384,11,'devicesimcard_pinpuk',0),(1385,11,'document',1),(1386,11,'domain',1),(1387,11,'dropdown',0),(1388,11,'entity',1),(1389,11,'externalevent',1031),(1390,11,'followup',15367),(1391,11,'global_validation',0),(1392,11,'group',1),(1393,11,'infocom',1),(1394,11,'internet',0),(1395,11,'itilcategory',0),(1396,11,'itiltemplate',1),(1397,11,'knowbase',15367),(1398,11,'knowbasecategory',0),(1399,11,'license',1),(1400,11,'line',1),(1401,11,'lineoperator',0),(1402,11,'link',0),(1403,11,'location',0),(1404,11,'logs',1),(1405,11,'monitor',0),(1406,11,'cable_management',0),(1407,11,'networking',0),(1408,11,'notification',0),(1409,11,'password_update',1),(1410,11,'peripheral',0),(1411,11,'personalization',0),(1412,11,'phone',0),(1413,11,'planning',3073),(1414,11,'plugin_ocsinventoryng',0),(1415,11,'plugin_ocsinventoryng_clean',0),(1416,11,'plugin_ocsinventoryng_import',0),(1417,11,'plugin_ocsinventoryng_link',0),(1418,11,'plugin_ocsinventoryng_rule',0),(1419,11,'plugin_ocsinventoryng_sync',0),(1420,11,'plugin_ocsinventoryng_view',0),(1421,11,'plugin_pdf',0),(1422,11,'plugin_resources',0),(1423,11,'plugin_resources_all',0),(1424,11,'plugin_resources_budget',0),(1425,11,'plugin_resources_checklist',0),(1426,11,'plugin_resources_dropdown_public',0),(1427,11,'plugin_resources_employee',0),(1428,11,'plugin_resources_employment',0),(1429,11,'plugin_resources_habilitation',0),(1430,11,'plugin_resources_holiday',0),(1431,11,'plugin_resources_import',0),(1432,11,'plugin_resources_open_ticket',0),(1433,11,'plugin_resources_resting',0),(1434,11,'plugin_resources_task',0),(1435,11,'plugin_webapplications',0),(1436,11,'plugin_webapplications_open_ticket',0),(1437,11,'printer',0),(1438,11,'problem',1135),(1439,11,'profile',1),(1440,11,'project',1127),(1441,11,'projecttask',1121),(1442,11,'queuednotification',1),(1443,11,'reminder_public',135),(1444,11,'reports',1),(1445,11,'reservation',7),(1446,11,'rssfeed_public',128),(1447,11,'rule_asset',0),(1448,11,'rule_dictionnary_dropdown',0),(1449,11,'rule_dictionnary_printer',0),(1450,11,'rule_dictionnary_software',0),(1451,11,'rule_import',0),(1452,11,'rule_ldap',0),(1453,11,'rule_mailcollector',0),(1454,11,'rule_softwarecategories',0),(1455,11,'rule_ticket',0),(1456,11,'search_config',0),(1457,11,'show_group_hardware',1),(1458,11,'slm',0),(1459,11,'software',0),(1460,11,'solutiontemplate',0),(1461,11,'state',0),(1462,11,'statistic',1),(1463,11,'task',13313),(1464,11,'taskcategory',0),(1465,11,'ticket',261135),(1466,11,'ticketcost',1),(1467,11,'ticketrecurrent',7),(1468,11,'ticketvalidation',15360),(1469,11,'transfer',7),(1470,11,'typedoc',0),(1471,11,'user',1),(1472,11,'plugin_archires',0),(1473,7,'plugin_archires',0),(1474,2,'database',0),(1475,3,'database',0),(1476,4,'database',31),(1477,5,'database',0),(1478,6,'database',0),(1479,7,'database',0),(1480,8,'database',0),(1481,9,'database',0),(1482,10,'database',0),(1483,11,'database',0),(1484,1,'database',0),(1485,2,'inventory',0),(1486,3,'inventory',0),(1487,4,'inventory',3073),(1488,5,'inventory',0),(1489,6,'inventory',0),(1490,7,'inventory',0),(1491,8,'inventory',0),(1492,9,'inventory',0),(1493,10,'inventory',0),(1494,11,'inventory',0),(1495,1,'inventory',0),(1496,2,'pendingreason',0),(1497,3,'pendingreason',31),(1498,4,'pendingreason',31),(1499,5,'pendingreason',0),(1500,6,'pendingreason',0),(1501,7,'pendingreason',31),(1502,8,'pendingreason',0),(1503,9,'pendingreason',0),(1504,10,'pendingreason',31),(1505,11,'pendingreason',0),(1506,1,'pendingreason',0),(1507,2,'recurrentchange',0),(1508,3,'recurrentchange',0),(1509,4,'recurrentchange',31),(1510,5,'recurrentchange',0),(1511,6,'recurrentchange',0),(1512,7,'recurrentchange',0),(1513,8,'recurrentchange',0),(1514,9,'recurrentchange',31),(1515,10,'recurrentchange',31),(1516,11,'recurrentchange',31),(1517,1,'recurrentchange',0),(1518,2,'itilfollowuptemplate',0),(1519,3,'itilfollowuptemplate',31),(1520,4,'itilfollowuptemplate',31),(1521,5,'itilfollowuptemplate',0),(1522,6,'itilfollowuptemplate',0),(1523,7,'itilfollowuptemplate',0),(1524,8,'itilfollowuptemplate',0),(1525,9,'itilfollowuptemplate',0),(1526,10,'itilfollowuptemplate',0),(1527,11,'itilfollowuptemplate',0),(1528,1,'itilfollowuptemplate',0),(1529,2,'rule_location',0),(1530,3,'rule_location',0),(1531,4,'rule_location',31),(1532,5,'rule_location',0),(1533,6,'rule_location',0),(1534,7,'rule_location',0),(1535,8,'rule_location',0),(1536,9,'rule_location',0),(1537,10,'rule_location',0),(1538,11,'rule_location',0),(1539,1,'rule_location',0),(1540,2,'locked_field',0),(1541,3,'locked_field',0),(1542,4,'locked_field',6),(1543,5,'locked_field',0),(1544,6,'locked_field',0),(1545,7,'locked_field',0),(1546,8,'locked_field',0),(1547,9,'locked_field',0),(1548,10,'locked_field',0),(1549,11,'locked_field',0),(1550,1,'locked_field',0),(1551,2,'snmpcredential',0),(1552,3,'snmpcredential',0),(1553,4,'snmpcredential',31),(1554,5,'snmpcredential',0),(1555,6,'snmpcredential',0),(1556,7,'snmpcredential',0),(1557,8,'snmpcredential',0),(1558,9,'snmpcredential',0),(1559,10,'snmpcredential',0),(1560,11,'snmpcredential',0),(1561,1,'snmpcredential',0),(1562,2,'refusedequipment',0),(1563,3,'refusedequipment',0),(1564,4,'refusedequipment',19),(1565,5,'refusedequipment',0),(1566,6,'refusedequipment',0),(1567,7,'refusedequipment',0),(1568,8,'refusedequipment',0),(1569,9,'refusedequipment',0),(1570,10,'refusedequipment',0),(1571,11,'refusedequipment',0),(1572,1,'refusedequipment',0),(1573,2,'agent',0),(1574,3,'agent',0),(1575,4,'agent',19),(1576,5,'agent',0),(1577,6,'agent',0),(1578,7,'agent',0),(1579,8,'agent',0),(1580,9,'agent',0),(1581,10,'agent',0),(1582,11,'agent',0),(1583,1,'agent',0),(1584,2,'unmanaged',0),(1585,3,'unmanaged',0),(1586,4,'unmanaged',27),(1587,5,'unmanaged',0),(1588,6,'unmanaged',0),(1589,7,'unmanaged',0),(1590,8,'unmanaged',0),(1591,9,'unmanaged',0),(1592,10,'unmanaged',0),(1593,11,'unmanaged',0),(1594,1,'unmanaged',0),(1595,4,'plugin_ocsinventoryng',23),(1596,4,'plugin_ocsinventoryng_sync',3),(1597,4,'plugin_ocsinventoryng_view',1),(1598,4,'plugin_ocsinventoryng_import',3),(1599,4,'plugin_ocsinventoryng_link',3),(1600,4,'plugin_ocsinventoryng_clean',3),(1601,4,'plugin_ocsinventoryng_rule',3);

--
-- Table structure for table `glpi_profiles`
--

CREATE TABLE `glpi_profiles` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `interface` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'helpdesk',
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `helpdesk_hardware` int NOT NULL DEFAULT '0',
  `helpdesk_item_type` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ticket_status` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'json encoded array of from/dest allowed status change',
  `date_mod` timestamp NULL DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `problem_status` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'json encoded array of from/dest allowed status change',
  `create_ticket_on_login` tinyint(1) NOT NULL DEFAULT '0',
  `tickettemplates_id` int unsigned NOT NULL DEFAULT '0',
  `changetemplates_id` int unsigned NOT NULL DEFAULT '0',
  `problemtemplates_id` int unsigned NOT NULL DEFAULT '0',
  `change_status` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'json encoded array of from/dest allowed status change',
  `managed_domainrecordtypes` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `interface` (`interface`),
  KEY `is_default` (`is_default`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `tickettemplates_id` (`tickettemplates_id`),
  KEY `changetemplates_id` (`changetemplates_id`),
  KEY `problemtemplates_id` (`problemtemplates_id`),
  KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_profiles`
--

INSERT INTO `glpi_profiles` VALUES (1,'Self-Service','helpdesk',1,1,'[\"Computer\",\"Monitor\",\"NetworkEquipment\",\"Peripheral\",\"Phone\",\"Printer\",\"Software\", \"DCRoom\", \"Rack\", \"Enclosure\"]','{\"1\":{\"2\":0,\"3\":0,\"4\":0,\"5\":0,\"6\":0},\"2\":{\"1\":0,\"3\":0,\"4\":0,\"5\":0,\"6\":0},\"3\":{\"1\":0,\"2\":0,\"4\":0,\"5\":0,\"6\":0},\"4\":{\"1\":0,\"2\":0,\"3\":0,\"5\":0,\"6\":0},\"5\":{\"1\":0,\"2\":0,\"3\":0,\"4\":0},\"6\":{\"1\":0,\"2\":0,\"3\":0,\"4\":0,\"5\":0}}',NULL,NULL,'[]',0,0,0,0,NULL,NULL,NULL),(2,'Observer','central',0,1,'[\"Computer\",\"Monitor\",\"NetworkEquipment\",\"Peripheral\",\"Phone\",\"Printer\",\"Software\", \"DCRoom\", \"Rack\", \"Enclosure\"]','[]',NULL,NULL,'[]',0,0,0,0,NULL,NULL,NULL),(3,'Admin','central',0,3,'[\"Computer\",\"Monitor\",\"NetworkEquipment\",\"Peripheral\",\"Phone\",\"Printer\",\"Software\", \"DCRoom\", \"Rack\", \"Enclosure\"]','[]',NULL,NULL,'[]',0,0,0,0,NULL,NULL,NULL),(4,'Super-Admin','central',0,3,'[\"Computer\",\"Monitor\",\"NetworkEquipment\",\"Peripheral\",\"Phone\",\"Printer\",\"Software\", \"DCRoom\", \"Rack\", \"Enclosure\"]','[]',NULL,NULL,'[]',0,0,0,0,NULL,NULL,NULL),(5,'Hotliner','central',0,3,'[\"Computer\",\"Monitor\",\"NetworkEquipment\",\"Peripheral\",\"Phone\",\"Printer\",\"Software\", \"DCRoom\", \"Rack\", \"Enclosure\"]','[]',NULL,NULL,'[]',1,0,0,0,NULL,NULL,NULL),(6,'Technician','central',0,3,'[\"Computer\",\"Monitor\",\"NetworkEquipment\",\"Peripheral\",\"Phone\",\"Printer\",\"Software\", \"DCRoom\", \"Rack\", \"Enclosure\"]','[]',NULL,NULL,'[]',0,0,0,0,NULL,NULL,NULL),(7,'Supervisor','central',0,3,'[\"Computer\",\"Monitor\",\"NetworkEquipment\",\"Peripheral\",\"Phone\",\"Printer\",\"Software\", \"DCRoom\", \"Rack\", \"Enclosure\"]','[]',NULL,NULL,'[]',0,0,0,0,NULL,NULL,NULL),(8,'Read-Only','central',0,0,'[]','{\"1\":{\"2\":0,\"3\":0,\"4\":0,\"5\":0,\"6\":0},\n                       \"2\":{\"1\":0,\"3\":0,\"4\":0,\"5\":0,\"6\":0},\n                       \"3\":{\"1\":0,\"2\":0,\"4\":0,\"5\":0,\"6\":0},\n                       \"4\":{\"1\":0,\"2\":0,\"3\":0,\"5\":0,\"6\":0},\n                       \"5\":{\"1\":0,\"2\":0,\"3\":0,\"4\":0,\"6\":0},\n                       \"6\":{\"1\":0,\"2\":0,\"3\":0,\"4\":0,\"5\":0}}',NULL,'This profile defines read-only access. It is used when objects are locked. It can also be used to give to users rights to unlock objects.','{\"1\":{\"7\":0,\"2\":0,\"3\":0,\"4\":0,\"5\":0,\"8\":0,\"6\":0},\n                      \"7\":{\"1\":0,\"2\":0,\"3\":0,\"4\":0,\"5\":0,\"8\":0,\"6\":0},\n                      \"2\":{\"1\":0,\"7\":0,\"3\":0,\"4\":0,\"5\":0,\"8\":0,\"6\":0},\n                      \"3\":{\"1\":0,\"7\":0,\"2\":0,\"4\":0,\"5\":0,\"8\":0,\"6\":0},\n                      \"4\":{\"1\":0,\"7\":0,\"2\":0,\"3\":0,\"5\":0,\"8\":0,\"6\":0},\n                      \"5\":{\"1\":0,\"7\":0,\"2\":0,\"3\":0,\"4\":0,\"8\":0,\"6\":0},\n                      \"8\":{\"1\":0,\"7\":0,\"2\":0,\"3\":0,\"4\":0,\"5\":0,\"6\":0},\n                      \"6\":{\"1\":0,\"7\":0,\"2\":0,\"3\":0,\"4\":0,\"5\":0,\"8\":0}}',0,0,0,0,'{\"1\":{\"9\":0,\"10\":0,\"7\":0,\"4\":0,\"11\":0,\"12\":0,\"5\":0,\"8\":0,\"6\":0},\n                       \"9\":{\"1\":0,\"10\":0,\"7\":0,\"4\":0,\"11\":0,\"12\":0,\"5\":0,\"8\":0,\"6\":0},\n                       \"10\":{\"1\":0,\"9\":0,\"7\":0,\"4\":0,\"11\":0,\"12\":0,\"5\":0,\"8\":0,\"6\":0},\n                       \"7\":{\"1\":0,\"9\":0,\"10\":0,\"4\":0,\"11\":0,\"12\":0,\"5\":0,\"8\":0,\"6\":0},\n                       \"4\":{\"1\":0,\"9\":0,\"10\":0,\"7\":0,\"11\":0,\"12\":0,\"5\":0,\"8\":0,\"6\":0},\n                       \"11\":{\"1\":0,\"9\":0,\"10\":0,\"7\":0,\"4\":0,\"12\":0,\"5\":0,\"8\":0,\"6\":0},\n                       \"12\":{\"1\":0,\"9\":0,\"10\":0,\"7\":0,\"4\":0,\"11\":0,\"5\":0,\"8\":0,\"6\":0},\n                       \"5\":{\"1\":0,\"9\":0,\"10\":0,\"7\":0,\"4\":0,\"11\":0,\"12\":0,\"8\":0,\"6\":0},\n                       \"8\":{\"1\":0,\"9\":0,\"10\":0,\"7\":0,\"4\":0,\"11\":0,\"12\":0,\"5\":0,\"6\":0},\n                       \"6\":{\"1\":0,\"9\":0,\"10\":0,\"7\":0,\"4\":0,\"11\":0,\"12\":0,\"5\":0,\"8\":0}}',NULL,'2016-02-08 21:57:46'),(9,'Tecnico N1','central',0,3,'[\"Computer\",\"Monitor\",\"NetworkEquipment\",\"Peripheral\",\"Phone\",\"Printer\",\"Software\",\"SoftwareLicense\",\"Certificate\",\"Line\",\"DCRoom\",\"Rack\",\"Enclosure\",\"Cluster\",\"PDU\",\"Domain\",\"DomainRecord\",\"Appliance\",\"Item_DeviceSimcard\",\"PassiveDCEquipment\"]',NULL,'2023-05-24 17:54:00','Tecnicos de nivel 1 ',NULL,0,0,0,0,NULL,'[]','2023-05-02 13:17:50'),(10,'Tecnico N2','central',0,3,'[\"Computer\",\"Monitor\",\"NetworkEquipment\",\"Peripheral\",\"Phone\",\"Printer\",\"Software\",\"SoftwareLicense\",\"Line\",\"Domain\",\"Item_DeviceSimcard\",\"PassiveDCEquipment\"]','[]','2023-05-03 00:06:13','','[]',0,0,0,0,'[]','[]','2023-05-02 18:21:50'),(11,'Tecnico SAP','central',0,3,'[\"Computer\",\"Monitor\",\"NetworkEquipment\",\"Peripheral\",\"Phone\",\"Printer\",\"Software\",\"SoftwareLicense\",\"Certificate\",\"Line\",\"DCRoom\",\"Rack\",\"Enclosure\",\"Cluster\",\"PDU\",\"Domain\",\"DomainRecord\",\"Appliance\",\"Item_DeviceSimcard\",\"PassiveDCEquipment\"]','[]','2023-05-05 17:25:14','Tecnicos Nivel 2 de SAP','[]',0,1,1,1,'[]','[]','2023-05-02 18:57:50');

--
-- Table structure for table `glpi_profiles_reminders`
--

CREATE TABLE `glpi_profiles_reminders` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `reminders_id` int unsigned NOT NULL DEFAULT '0',
  `profiles_id` int unsigned NOT NULL DEFAULT '0',
  `entities_id` int unsigned DEFAULT NULL,
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `no_entity_restriction` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `reminders_id` (`reminders_id`),
  KEY `profiles_id` (`profiles_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_profiles_reminders`
--


--
-- Table structure for table `glpi_profiles_rssfeeds`
--

CREATE TABLE `glpi_profiles_rssfeeds` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `rssfeeds_id` int unsigned NOT NULL DEFAULT '0',
  `profiles_id` int unsigned NOT NULL DEFAULT '0',
  `entities_id` int unsigned DEFAULT NULL,
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `no_entity_restriction` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `rssfeeds_id` (`rssfeeds_id`),
  KEY `profiles_id` (`profiles_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_profiles_rssfeeds`
--


--
-- Table structure for table `glpi_profiles_users`
--

CREATE TABLE `glpi_profiles_users` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `users_id` int unsigned NOT NULL DEFAULT '0',
  `profiles_id` int unsigned NOT NULL DEFAULT '0',
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '1',
  `is_dynamic` tinyint(1) NOT NULL DEFAULT '0',
  `is_default_profile` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `entities_id` (`entities_id`),
  KEY `profiles_id` (`profiles_id`),
  KEY `users_id` (`users_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `is_dynamic` (`is_dynamic`)
) ENGINE=InnoDB AUTO_INCREMENT=3254 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_profiles_users`
--

INSERT INTO `glpi_profiles_users` VALUES (660,133,1,2,0,1,0),(925,323,1,2,0,1,0),(932,329,1,1,0,1,0),(945,338,1,1,0,1,0),(946,339,1,1,0,1,0),(973,365,1,1,0,1,0),(989,0,6,2,0,0,0),(991,0,1,2,1,0,0),(1014,0,1,2,1,0,0),(1030,398,1,2,0,1,0),(1035,400,1,2,0,1,0),(1040,0,1,1,1,0,0),(1063,424,1,1,0,1,0),(1072,432,1,1,0,1,0),(1073,433,1,1,0,1,0),(1123,479,1,1,0,1,0),(1127,481,1,1,0,1,0),(1135,488,1,1,0,1,0),(1192,534,1,1,0,1,0),(1194,536,1,1,0,1,0),(1224,547,1,2,0,1,0),(1239,562,1,1,0,1,0),(1261,574,1,1,0,1,0),(1297,594,1,2,0,1,0),(1305,600,1,1,0,1,0),(1307,602,1,1,0,1,0),(1311,605,1,1,0,1,0),(1312,606,1,1,0,1,0),(1318,526,1,15,0,0,0),(1319,524,1,15,0,0,0),(1322,510,1,15,0,0,0),(1325,498,1,15,0,0,0),(1326,491,1,15,0,0,0),(1353,621,1,2,0,1,0),(1374,632,1,2,0,1,0),(1386,639,1,1,0,1,0),(1387,640,1,1,0,1,0),(1392,642,1,2,0,1,0),(1432,669,1,1,0,1,0),(1445,456,1,0,1,0,0),(1446,456,1,1,1,0,0),(1453,680,1,2,0,1,0),(1465,689,1,17,1,0,0),(1467,690,1,17,1,0,0),(1477,673,1,17,1,0,0),(1483,699,1,2,0,1,0),(1487,702,1,1,0,1,0),(1498,709,1,1,0,1,0),(1503,712,1,17,1,0,0),(1506,549,1,17,0,0,0),(1520,723,1,2,1,0,0),(1527,329,1,0,1,0,0),(1528,726,1,1,0,1,0),(1560,745,1,2,0,1,0),(1569,178,4,0,1,0,0),(1571,178,4,14,1,0,0),(1572,178,4,15,1,0,0),(1573,178,4,2,1,0,0),(1574,178,4,17,1,0,0),(1576,178,4,1,1,0,0),(1577,178,1,1,0,1,0),(1593,757,1,15,1,0,0),(1619,329,1,1,0,1,0),(1639,770,1,1,0,1,0),(1642,771,1,1,0,1,0),(1692,780,1,2,0,1,0),(1714,783,1,15,0,1,0),(1715,720,1,17,1,0,0),(1741,785,1,15,0,1,0),(1776,797,1,17,0,1,0),(1782,799,1,17,0,1,0),(1785,800,1,1,0,1,0),(1795,803,1,17,0,1,0),(1822,498,1,15,0,1,0),(1838,757,1,15,0,1,0),(1844,518,1,15,0,1,0),(1860,524,1,15,0,1,0),(1864,530,1,15,0,1,0),(1866,779,1,17,0,1,0),(1871,763,1,15,0,1,0),(1940,828,1,1,0,1,0),(1950,831,1,1,0,1,0),(1963,835,1,2,0,1,0),(1966,836,1,1,0,1,0),(1969,837,1,1,0,1,0),(1972,838,1,1,0,1,0),(1985,842,1,1,0,1,0),(1988,843,1,1,0,1,0),(1993,844,1,15,0,1,0),(1994,845,1,1,0,1,0),(2002,847,1,15,0,1,0),(2004,848,1,2,0,1,0),(2009,849,1,15,0,1,0),(2010,850,1,1,0,1,0),(2019,853,1,1,0,1,0),(2026,855,1,17,0,1,0),(2030,856,1,15,0,1,0),(2031,857,1,1,0,1,0),(2035,858,1,2,0,1,0),(2045,861,1,2,0,1,0),(2048,862,1,1,0,1,0),(2051,863,1,1,0,1,0),(2065,867,1,1,0,1,0),(2070,868,1,15,0,1,0),(2073,869,1,15,0,1,0),(2077,871,1,1,0,1,0),(2085,873,1,15,0,1,0),(2086,874,1,1,0,1,0),(2094,876,1,15,0,1,0),(2097,877,1,15,0,1,0),(2128,825,4,22,1,0,0),(2132,882,1,1,0,1,0),(2138,884,1,1,0,1,0),(2141,885,1,1,0,1,0),(2147,886,1,1,0,1,0),(2150,887,1,1,0,1,0),(2153,888,1,1,0,1,0),(2156,889,1,1,0,1,0),(2159,890,1,1,0,1,0),(2162,891,1,1,0,1,0),(2166,878,1,22,0,0,0),(2172,860,4,1,1,0,0),(2173,860,4,1,1,0,0),(2174,860,4,20,1,0,0),(2175,860,4,2,1,0,0),(2176,860,4,19,1,0,0),(2178,860,4,18,1,0,0),(2179,860,4,22,1,0,0),(2180,860,4,17,1,0,0),(2181,860,4,14,1,0,0),(2182,860,4,15,1,0,0),(2183,860,4,21,1,0,0),(2188,860,4,0,1,0,0),(2209,786,1,20,0,1,0),(2215,788,1,20,0,1,0),(2223,892,1,1,0,1,0),(2227,892,1,19,0,0,0),(2231,852,1,20,0,0,0),(2232,852,1,22,0,0,0),(2238,843,1,20,0,0,0),(2239,843,1,22,0,0,0),(2240,843,1,21,0,0,0),(2245,771,1,20,0,0,0),(2246,771,1,22,0,0,0),(2247,771,1,15,0,0,0),(2248,771,1,21,0,0,0),(2252,893,1,1,0,1,0),(2257,894,1,20,0,1,0),(2265,526,1,15,0,1,0),(2266,790,1,20,0,1,0),(2267,791,1,20,0,1,0),(2268,792,1,20,0,1,0),(2269,793,1,20,0,1,0),(2271,795,1,20,0,1,0),(2272,798,1,20,0,1,0),(2273,804,1,20,0,1,0),(2283,902,1,17,0,1,0),(2307,922,1,17,0,1,0),(2308,923,1,17,0,1,0),(2309,924,1,15,0,1,0),(2310,925,1,1,0,1,0),(2313,928,1,15,0,1,0),(2314,929,1,17,0,1,0),(2315,930,1,17,0,1,0),(2316,931,1,15,0,1,0),(2318,933,1,15,0,1,0),(2324,939,1,15,0,1,0),(2325,940,1,15,0,1,0),(2326,941,1,15,0,1,0),(2327,942,1,15,0,1,0),(2330,945,1,15,0,1,0),(2331,946,1,15,0,1,0),(2332,947,1,15,0,1,0),(2333,948,1,15,0,1,0),(2335,950,1,0,0,0,0),(2336,950,1,1,0,0,0),(2337,950,1,20,0,0,0),(2338,950,1,2,0,0,0),(2339,950,1,19,0,0,0),(2340,950,1,22,0,0,0),(2341,950,1,17,0,0,0),(2342,950,1,15,0,0,0),(2343,950,1,21,0,0,0),(2345,728,1,17,0,0,0),(2346,738,1,17,0,0,0),(2347,733,1,17,0,0,0),(2355,806,1,19,0,1,0),(2356,807,1,19,0,1,0),(2357,808,1,19,0,1,0),(2358,809,1,19,0,1,0),(2359,491,1,15,0,1,0),(2362,810,1,19,0,1,0),(2368,813,1,19,0,1,0),(2370,815,1,19,0,1,0),(2371,816,1,19,0,1,0),(2373,510,1,15,0,1,0),(2380,821,1,19,0,1,0),(2382,823,1,19,0,1,0),(2385,475,1,15,0,0,0),(2386,491,1,15,0,0,0),(2388,498,1,15,0,0,0),(2389,499,1,15,0,0,0),(2390,507,1,15,0,0,0),(2391,510,1,15,0,0,0),(2394,524,1,15,0,0,0),(2395,526,1,15,0,0,0),(2396,627,1,15,0,0,0),(2397,703,1,15,0,0,0),(2399,713,1,15,0,0,0),(2401,729,1,15,0,0,0),(2402,739,1,15,0,0,0),(2403,757,1,15,0,0,0),(2452,508,1,19,0,0,0),(2453,521,1,19,0,0,0),(2454,567,1,19,0,0,0),(2455,568,1,19,0,0,0),(2456,580,1,19,0,0,0),(2460,586,1,19,0,0,0),(2462,588,1,19,0,0,0),(2463,633,1,19,0,0,0),(2465,641,1,19,0,0,0),(2466,646,1,19,0,0,0),(2467,651,1,19,0,0,0),(2468,661,1,19,0,0,0),(2470,674,1,19,0,0,0),(2472,711,1,19,0,0,0),(2473,717,1,19,0,0,0),(2474,719,1,19,0,0,0),(2476,761,1,19,0,0,0),(2477,784,1,19,0,0,0),(2478,805,1,19,0,0,0),(2479,811,1,19,0,0,0),(2480,812,1,19,0,0,0),(2481,814,1,19,0,0,0),(2482,817,1,19,0,0,0),(2483,818,1,19,0,0,0),(2484,819,1,19,0,0,0),(2485,820,1,19,0,0,0),(2486,824,1,19,0,0,0),(2487,918,1,19,0,0,0),(2488,926,1,19,0,0,0),(2489,927,1,19,0,0,0),(2490,932,1,19,0,0,0),(2491,935,1,19,0,0,0),(2492,936,1,19,0,0,0),(2493,937,1,19,0,0,0),(2494,938,1,19,0,0,0),(2496,825,4,0,0,0,0),(2497,825,4,20,0,0,0),(2498,825,4,2,0,0,0),(2499,825,4,19,0,0,0),(2500,825,4,18,0,0,0),(2501,825,4,1,1,0,0),(2502,825,4,17,1,0,0),(2503,825,4,14,1,0,0),(2504,825,4,15,1,0,0),(2505,825,4,21,1,0,0),(2506,472,1,1,0,0,0),(2507,908,1,22,0,0,0),(2508,96,1,22,0,0,0),(2509,352,1,21,0,0,0),(2510,697,1,21,0,0,0),(2511,952,1,15,0,1,0),(2512,953,1,2,0,1,0),(2515,956,1,17,0,1,0),(2516,957,1,1,0,1,0),(2517,958,1,2,0,1,0),(2518,959,1,2,0,1,0),(2519,960,1,15,0,1,0),(2520,961,1,1,0,1,0),(2521,962,1,17,0,1,0),(2523,964,1,2,0,1,0),(2524,965,1,15,0,1,0),(2525,966,1,2,0,1,0),(2526,967,1,2,0,1,0),(2527,968,1,2,0,1,0),(2528,969,1,2,0,1,0),(2579,337,1,22,0,0,0),(2582,427,1,22,0,0,0),(2583,440,1,22,0,0,0),(2584,442,1,22,0,0,0),(2585,445,1,22,0,0,0),(2588,467,1,22,0,0,0),(2590,560,1,22,0,0,0),(2591,563,1,22,0,0,0),(2592,618,1,22,0,0,0),(2593,638,1,22,0,0,0),(2594,658,1,22,0,0,0),(2595,662,1,22,0,0,0),(2596,671,1,22,0,0,0),(2597,681,1,22,0,0,0),(2598,685,1,22,0,0,0),(2599,710,1,22,0,0,0),(2600,716,1,22,0,0,0),(2601,724,1,22,0,0,0),(2602,727,1,22,0,0,0),(2603,731,1,22,0,0,0),(2604,732,1,22,0,0,0),(2605,736,1,22,0,0,0),(2606,755,1,22,0,0,0),(2607,756,1,22,0,0,0),(2608,775,1,22,0,0,0),(2609,778,1,22,0,0,0),(2610,781,1,22,0,0,0),(2611,794,1,22,0,0,0),(2613,846,1,22,0,0,0),(2614,909,1,22,0,0,0),(2615,910,1,22,0,0,0),(2617,912,1,22,0,0,0),(2618,913,1,22,0,0,0),(2619,914,1,22,0,0,0),(2620,915,1,22,0,0,0),(2621,916,1,22,0,0,0),(2622,917,1,22,0,0,0),(2623,919,1,22,0,0,0),(2624,920,1,22,0,0,0),(2625,921,1,22,0,0,0),(2626,954,1,22,0,0,0),(2627,955,1,22,0,0,0),(2629,407,1,20,0,0,0),(2630,610,1,20,0,0,0),(2631,760,1,20,0,0,0),(2632,758,1,20,0,0,0),(2633,643,1,22,0,0,0),(2634,452,1,20,0,0,0),(2635,412,1,20,0,0,0),(2636,840,1,20,0,0,0),(2637,459,1,20,0,0,0),(2639,330,1,15,0,0,0),(2640,971,1,1,0,1,0),(2641,972,1,15,0,1,0),(2643,974,1,19,0,1,0),(2646,976,1,15,0,0,0),(2647,973,1,15,0,0,0),(2649,943,1,15,0,0,0),(2650,557,1,20,0,0,0),(2651,702,1,20,0,0,0),(2662,715,1,22,0,0,0),(2663,636,1,22,0,0,0),(2664,655,1,22,0,0,0),(2665,789,1,20,0,0,0),(2705,328,1,21,0,0,0),(2706,355,1,21,0,0,0),(2707,360,1,21,0,0,0),(2708,372,1,21,0,0,0),(2709,413,1,21,0,0,0),(2710,420,1,21,0,0,0),(2711,428,1,21,0,0,0),(2712,436,1,21,0,0,0),(2713,441,1,21,0,0,0),(2714,450,1,21,0,0,0),(2715,464,1,21,0,0,0),(2716,538,1,21,0,0,0),(2717,546,1,21,0,0,0),(2718,608,1,21,0,0,0),(2720,620,1,21,0,0,0),(2721,649,1,21,0,0,0),(2722,657,1,21,0,0,0),(2723,683,1,21,0,0,0),(2724,684,1,21,0,0,0),(2725,691,1,21,0,0,0),(2726,707,1,21,0,0,0),(2727,730,1,21,0,0,0),(2728,734,1,21,0,0,0),(2729,776,1,21,0,0,0),(2730,826,1,21,0,0,0),(2731,870,1,21,0,0,0),(2732,880,1,21,0,0,0),(2733,881,1,21,0,0,0),(2734,895,1,21,0,0,0),(2735,896,1,21,0,0,0),(2736,897,1,21,0,0,0),(2737,898,1,21,0,0,0),(2738,899,1,21,0,0,0),(2739,900,1,21,0,0,0),(2740,903,1,21,0,0,0),(2741,904,1,21,0,0,0),(2742,905,1,21,0,0,0),(2743,906,1,21,0,0,0),(2744,977,1,15,0,1,0),(2745,978,1,17,0,1,0),(2746,979,1,15,0,1,0),(2747,980,1,15,0,1,0),(2748,981,1,15,0,1,0),(2749,982,1,15,0,1,0),(2750,983,1,15,0,1,0),(2751,984,1,15,0,1,0),(2752,985,1,15,0,1,0),(2753,986,1,15,0,1,0),(2754,987,1,15,0,1,0),(2755,988,1,15,0,1,0),(2756,989,1,15,0,1,0),(2758,970,1,21,0,0,0),(2759,975,1,15,0,0,0),(2760,963,1,21,0,0,0),(2761,860,1,1,0,1,0),(2763,800,1,15,0,0,0),(2766,991,1,20,0,0,0),(2767,565,11,20,1,0,0),(2768,565,11,15,1,0,0),(2769,565,11,1,1,0,0),(2770,565,11,22,1,0,0),(2777,752,9,20,1,0,0),(2778,752,9,2,1,0,0),(2779,752,9,1,1,0,0),(2780,752,9,18,1,0,0),(2781,752,9,22,1,0,0),(2782,752,9,17,1,0,0),(2783,752,9,15,1,0,0),(2784,752,9,21,1,0,0),(2785,565,1,1,0,1,0),(2787,565,11,21,1,0,0),(2815,749,4,1,1,0,0),(2816,749,4,20,1,0,0),(2817,749,4,0,1,0,0),(2818,749,4,2,1,0,0),(2819,749,4,19,1,0,0),(2820,749,4,22,1,0,0),(2821,749,4,18,1,0,0),(2822,749,4,17,1,0,0),(2823,749,4,14,1,0,0),(2824,749,4,15,1,0,0),(2825,749,4,21,1,0,0),(2834,950,1,18,0,0,0),(2835,368,10,0,1,0,0),(2836,368,10,1,1,0,0),(2837,368,10,20,1,0,0),(2838,368,10,2,1,0,0),(2839,368,10,19,1,0,0),(2840,368,10,18,1,0,0),(2841,368,10,22,1,0,0),(2842,368,10,17,1,0,0),(2844,678,1,1,0,1,0),(2845,368,10,15,1,0,0),(2846,368,10,21,1,0,0),(2847,753,1,0,0,0,0),(2848,752,1,1,0,1,0),(2849,992,1,17,0,1,0),(2850,993,1,19,0,1,0),(2851,994,1,17,0,1,0),(2852,995,1,17,0,1,0),(2853,996,1,17,0,1,0),(2854,997,1,19,0,1,0),(2856,999,1,0,0,1,1),(2857,1000,1,19,0,1,0),(2858,1001,1,19,0,1,0),(2859,1002,1,19,0,1,0),(2860,1003,1,19,0,1,0),(2861,1004,1,19,0,1,0),(2862,1005,1,19,0,1,0),(2863,1006,1,19,0,1,0),(2865,1008,1,17,0,1,0),(2866,1009,1,17,0,1,0),(2867,1010,1,19,0,1,0),(2869,1012,1,19,0,1,0),(2870,1013,1,17,0,1,0),(2871,1014,1,19,0,1,0),(2872,1015,1,19,0,1,0),(2873,1016,1,1,0,1,0),(2874,1017,1,17,0,1,0),(2875,1018,1,19,0,1,0),(2876,1019,1,17,0,1,0),(2877,1020,1,19,0,1,0),(2878,1021,1,19,0,1,0),(2879,752,9,0,0,0,0),(2880,860,2,1,1,0,0),(2881,860,2,20,1,0,0),(2882,860,2,0,1,0,0),(2883,860,2,2,1,0,0),(2884,860,2,19,1,0,0),(2885,860,2,18,0,0,0),(2886,860,2,22,0,0,0),(2887,860,2,17,1,0,0),(2889,860,2,15,1,0,0),(2890,860,2,21,1,0,0),(2891,716,1,20,0,0,0),(2893,353,1,1,0,1,0),(2894,875,1,1,0,1,0),(2896,692,1,1,0,1,0),(2897,752,9,19,1,0,0),(2899,911,1,15,0,0,0),(2900,978,1,19,1,0,0),(2902,881,1,1,0,1,0),(2903,895,1,1,0,1,0),(2904,896,1,1,0,1,0),(2905,781,1,1,0,1,0),(2906,954,1,1,0,1,0),(2907,1022,1,22,0,0,0),(2908,1007,1,21,0,0,0),(2909,998,1,20,0,0,0),(2911,760,1,1,1,0,0),(2913,1025,1,15,0,1,0),(2918,1027,1,15,0,0,0),(2919,1011,1,19,0,0,0),(2929,1023,1,15,0,0,0),(2930,1024,1,19,0,0,0),(2934,1030,1,1,0,0,0),(2935,1031,1,1,0,0,0),(2936,1032,1,1,0,0,0),(2937,1033,1,1,0,0,0),(2939,1035,1,1,0,0,0),(2940,1036,1,15,0,1,0),(2943,1034,1,22,0,0,0),(2944,1037,1,2,0,0,0),(2946,1038,1,22,0,0,0),(2947,1039,1,1,0,1,0),(2949,368,7,2,0,0,0),(2950,368,7,18,0,0,0),(2951,368,7,1,0,0,0),(2952,368,7,20,0,0,0),(2953,368,7,19,0,0,0),(2954,368,7,22,0,0,0),(2955,368,7,17,0,0,0),(2956,368,7,15,0,0,0),(2957,368,7,21,0,0,0),(2959,1039,1,22,0,0,0),(2960,1040,1,1,0,1,0),(2961,1040,1,22,0,0,0),(2962,600,1,19,0,0,0),(2963,1041,1,1,0,1,0),(2964,1041,1,22,0,0,0),(2965,1042,1,1,0,1,1),(2966,1042,1,21,1,0,0),(2967,1043,1,1,0,1,1),(2968,1043,1,21,1,0,0),(2969,1044,1,1,0,1,0),(2970,1045,1,1,0,1,0),(2971,1046,1,1,0,1,0),(2972,1046,1,21,1,0,0),(2973,1047,1,1,0,1,0),(2974,1048,1,1,0,1,0),(2975,1048,1,22,1,0,0),(2976,1049,1,17,0,1,0),(2977,1049,1,17,1,0,0),(2978,1050,1,1,0,1,0),(2980,1051,1,22,1,0,0),(2982,1052,1,21,1,0,0),(2983,839,1,1,1,0,0),(2984,730,1,21,1,0,0),(2985,1023,1,1,1,0,0),(2986,1027,1,1,1,0,0),(2990,1053,1,1,0,1,1),(2991,1054,1,1,0,1,0),(2992,1055,1,1,0,1,0),(2993,1056,1,20,0,1,0),(2995,1057,1,20,1,0,0),(2996,1058,1,15,0,1,0),(2997,1059,1,1,0,1,0),(2998,1060,1,1,0,1,0),(2999,1060,1,20,1,0,0),(3000,1061,1,15,0,1,0),(3001,330,1,15,1,0,0),(3002,1062,1,17,0,1,0),(3003,1063,1,1,0,1,0),(3004,1064,1,2,0,1,0),(3005,1065,1,15,0,1,0),(3006,1066,1,15,0,1,0),(3007,1029,1,18,0,0,0),(3009,1067,1,20,1,0,0),(3010,1068,1,1,0,1,0),(3011,1068,1,21,1,0,0),(3017,1070,1,19,0,1,0),(3018,1071,1,1,0,1,0),(3019,1071,1,20,1,0,0),(3020,1072,1,15,0,1,0),(3021,1073,1,1,0,1,0),(3022,1073,1,22,1,0,0),(3023,1074,1,1,0,1,0),(3024,1075,1,15,0,1,0),(3025,972,1,1,1,0,0),(3026,972,1,22,1,0,0),(3027,1076,1,1,0,1,0),(3028,1070,1,17,1,0,0),(3029,1070,1,1,1,0,0),(3030,1069,11,1,0,0,0),(3031,1069,11,20,0,0,0),(3032,1069,11,22,0,0,0),(3033,1069,11,15,0,0,0),(3034,1069,11,21,0,0,0),(3037,1077,1,15,0,1,0),(3038,897,1,1,0,1,0),(3039,926,1,19,0,1,0),(3040,758,1,1,0,1,0),(3041,927,1,19,0,1,0),(3042,955,1,1,0,1,0),(3043,908,1,1,0,1,0),(3044,898,1,1,0,1,0),(3045,899,1,1,0,1,0),(3046,932,1,19,0,1,0),(3047,880,1,1,0,1,0),(3048,839,1,1,0,1,0),(3049,998,1,1,0,1,0),(3050,909,1,1,0,1,0),(3051,840,1,1,0,1,0),(3052,935,1,19,0,1,0),(3054,936,1,19,0,1,0),(3055,937,1,19,0,1,0),(3056,846,1,1,0,1,0),(3057,499,1,15,0,1,0),(3058,910,1,1,0,1,0),(3059,1034,1,1,0,1,0),(3060,938,1,19,0,1,0),(3061,811,1,19,0,1,0),(3062,911,1,1,0,1,0),(3063,812,1,19,0,1,0),(3064,756,1,1,0,1,0),(3065,1023,1,1,0,1,0),(3066,912,1,1,0,1,0),(3067,794,1,1,0,1,0),(3068,852,1,20,0,1,0),(3069,814,1,19,0,1,0),(3070,900,1,1,0,1,0),(3071,760,1,1,0,1,0),(3072,913,1,1,0,1,0),(3073,901,1,19,0,1,0),(3074,817,1,19,0,1,0),(3075,914,1,1,0,1,0),(3076,761,1,19,0,1,0),(3077,903,1,1,0,1,0),(3078,1007,1,1,0,1,0),(3079,805,1,19,0,1,0),(3080,904,1,1,0,1,0),(3081,943,1,1,0,1,0),(3082,963,1,1,0,1,0),(3083,818,1,19,0,1,0),(3084,819,1,19,0,1,0),(3085,915,1,1,0,1,0),(3086,1069,1,1,0,1,0),(3087,820,1,19,0,1,0),(3088,784,1,19,0,1,0),(3089,916,1,1,0,1,0),(3090,778,1,1,0,1,0),(3091,905,1,1,0,1,0),(3092,826,1,1,0,1,0),(3093,917,1,1,0,1,0),(3094,775,1,1,0,1,0),(3095,906,1,1,0,1,0),(3096,918,1,19,0,1,0),(3097,973,1,15,0,1,0),(3098,1022,1,1,0,1,0),(3099,919,1,1,0,1,0),(3100,920,1,1,0,1,0),(3101,866,1,2,0,1,0),(3102,921,1,1,0,1,0),(3103,1052,1,1,0,1,0),(3104,870,1,1,0,1,0),(3106,975,1,1,0,1,0),(3107,755,1,1,0,1,0),(3108,970,1,1,0,1,0),(3109,824,1,19,0,1,0),(3110,878,1,1,0,1,0),(3111,1078,1,15,0,1,0),(3112,1079,1,1,0,1,0),(3113,1080,1,1,0,1,0),(3114,802,9,1,0,0,0),(3115,802,9,20,0,0,0),(3116,802,9,2,0,0,0),(3117,802,9,0,0,0,0),(3118,802,9,18,0,0,0),(3119,802,9,22,0,0,0),(3120,802,9,17,0,0,0),(3121,802,9,15,0,0,0),(3123,802,9,21,0,0,0),(3124,565,11,0,0,0,0),(3125,802,1,1,0,1,0),(3126,802,1,19,1,0,0),(3127,1081,1,2,0,0,0),(3128,1082,1,2,0,0,0),(3129,1083,1,2,0,1,0),(3130,1084,1,2,0,1,0),(3131,1085,1,2,0,1,0),(3132,1086,1,2,0,1,0),(3133,1087,1,2,1,0,0),(3134,1088,1,2,1,0,0),(3135,1089,1,2,1,0,0),(3139,883,1,15,0,1,0),(3141,883,1,1,1,0,0),(3143,883,1,15,1,0,0),(3144,1092,1,1,0,1,0),(3145,1092,1,21,1,0,0),(3146,1080,1,21,1,0,0),(3147,1093,1,2,0,1,0),(3148,1094,1,1,0,1,0),(3149,1094,1,22,1,0,0),(3151,1095,1,1,0,1,0),(3152,1095,1,15,1,0,0),(3154,1097,1,2,0,1,0),(3155,1069,11,0,1,0,0),(3156,1098,1,1,0,1,0),(3157,1098,1,21,1,0,0),(3158,671,1,20,0,0,0),(3160,1099,1,17,0,1,0),(3161,1100,1,17,0,1,0),(3162,1101,1,1,0,1,0),(3163,1101,1,21,1,0,0),(3164,1102,1,1,0,1,0),(3165,1102,1,22,1,0,0),(3166,1103,1,1,0,1,0),(3167,1103,1,22,1,0,0),(3168,1104,1,15,0,1,0),(3169,1105,1,1,0,1,0),(3170,1106,1,15,0,1,0),(3171,1107,1,15,0,1,0),(3172,1108,1,1,0,1,0),(3173,1108,1,22,1,0,0),(3174,1109,1,1,0,1,0),(3175,1109,1,22,1,0,0),(3176,1110,1,1,0,1,0),(3177,1110,1,21,1,0,0),(3178,1111,1,1,0,1,0),(3179,1111,1,21,1,0,0),(3180,1112,1,20,0,1,0),(3181,1113,1,1,0,1,0),(3182,1113,1,22,1,0,0),(3183,1114,1,17,0,1,0),(3184,1115,1,15,0,1,0),(3185,1116,1,15,0,1,0),(3187,1117,10,1,0,0,0),(3188,1117,10,20,0,0,0),(3189,1117,10,2,0,0,0),(3190,1117,10,19,0,0,0),(3191,1117,10,18,0,0,0),(3192,1117,10,22,0,0,0),(3193,1117,10,17,0,0,0),(3194,1117,10,15,0,0,0),(3195,1117,10,21,0,0,0),(3198,1067,1,20,0,1,0),(3199,1119,1,19,0,1,1),(3200,1120,1,19,0,1,1),(3201,1121,1,19,0,1,1),(3202,802,9,19,0,0,0),(3203,1122,1,15,0,1,0),(3204,1123,1,1,0,1,0),(3205,1123,1,21,1,0,0),(3206,1124,1,1,0,1,0),(3207,1124,1,21,1,0,0),(3208,1125,1,15,0,1,0),(3209,1126,1,15,0,1,0),(3210,1127,1,1,0,1,0),(3211,1127,1,22,1,0,0),(3212,1128,1,17,0,1,0),(3213,1117,7,0,1,0,0),(3214,1129,1,20,0,1,0),(3215,1130,1,20,0,1,0),(3216,1131,1,20,0,1,0),(3217,1132,1,20,0,1,0),(3218,1133,1,20,0,1,0),(3219,1134,1,1,0,1,0),(3220,1134,1,21,1,0,0),(3221,1135,1,17,0,1,0),(3222,825,4,18,1,0,0),(3223,1136,1,17,0,1,0),(3224,1137,1,17,0,1,0),(3225,1117,4,0,1,0,0),(3226,615,1,21,1,0,0),(3227,1138,1,15,0,1,0),(3228,1139,1,1,0,1,1),(3229,1139,1,20,1,0,0),(3230,1140,1,1,0,1,1),(3231,1140,1,2,1,0,0),(3232,1141,1,20,0,1,0),(3233,1142,1,20,0,1,0),(3234,1143,1,20,0,1,0),(3235,1144,1,20,0,1,0),(3236,1145,1,20,0,1,0),(3237,1118,1,1,0,0,0),(3238,991,1,20,0,1,0),(3239,368,1,1,0,1,0),(3240,825,1,1,0,1,0),(3241,2001,4,0,1,0,0),(3242,2001,3,0,0,0,0),(3243,2001,3,1,1,0,0),(3244,2002,1,2,0,0,0),(3245,2003,1,15,0,0,0),(3246,2004,1,1,0,0,0),(3247,2005,1,1,0,1,1),(3248,2005,1,22,1,0,0),(3249,1117,1,1,0,1,0),(3250,2006,1,1,0,1,0),(3251,2007,1,15,0,1,0),(3252,2008,1,1,0,1,0),(3253,2008,1,21,1,0,0);

--
-- Table structure for table `glpi_projectcosts`
--

CREATE TABLE `glpi_projectcosts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `projects_id` int unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `begin_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `cost` decimal(20,4) NOT NULL DEFAULT '0.0000',
  `budgets_id` int unsigned NOT NULL DEFAULT '0',
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `projects_id` (`projects_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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_projectcosts`
--


--
-- Table structure for table `glpi_projects`
--

CREATE TABLE `glpi_projects` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `priority` int NOT NULL DEFAULT '1',
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `projects_id` int unsigned NOT NULL DEFAULT '0',
  `projectstates_id` int unsigned NOT NULL DEFAULT '0',
  `projecttypes_id` int unsigned NOT NULL DEFAULT '0',
  `date` timestamp NULL DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `users_id` int unsigned NOT NULL DEFAULT '0',
  `groups_id` int unsigned NOT NULL DEFAULT '0',
  `plan_start_date` timestamp NULL DEFAULT NULL,
  `plan_end_date` timestamp NULL DEFAULT NULL,
  `real_start_date` timestamp NULL DEFAULT NULL,
  `real_end_date` timestamp NULL DEFAULT NULL,
  `percent_done` int NOT NULL DEFAULT '0',
  `auto_percent_done` tinyint(1) NOT NULL DEFAULT '0',
  `show_on_global_gantt` tinyint(1) NOT NULL DEFAULT '0',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `comment` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `date_creation` timestamp NULL DEFAULT NULL,
  `projecttemplates_id` int unsigned NOT NULL DEFAULT '0',
  `is_template` tinyint(1) NOT NULL DEFAULT '0',
  `template_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `code` (`code`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `projects_id` (`projects_id`),
  KEY `projectstates_id` (`projectstates_id`),
  KEY `projecttypes_id` (`projecttypes_id`),
  KEY `priority` (`priority`),
  KEY `date` (`date`),
  KEY `date_mod` (`date_mod`),
  KEY `users_id` (`users_id`),
  KEY `groups_id` (`groups_id`),
  KEY `plan_start_date` (`plan_start_date`),
  KEY `plan_end_date` (`plan_end_date`),
  KEY `real_start_date` (`real_start_date`),
  KEY `real_end_date` (`real_end_date`),
  KEY `percent_done` (`percent_done`),
  KEY `show_on_global_gantt` (`show_on_global_gantt`),
  KEY `date_creation` (`date_creation`),
  KEY `projecttemplates_id` (`projecttemplates_id`),
  KEY `is_template` (`is_template`),
  KEY `is_deleted` (`is_deleted`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_projects`
--

INSERT INTO `glpi_projects` VALUES (1,'OFICINAS_FAW','PRTI-0001',4,0,0,0,3,1,'2020-07-16 12:59:05','2023-04-24 10:55:31',0,0,'2020-07-21 12:00:00','2020-07-31 04:00:00','2021-02-12 17:00:00','2021-02-12 17:00:00',100,0,1,'Teniendo en cuenta el movimiento en el taller y el crecimiento de nuestra bodega de repuestos FAW, tomamos la decisión de cambiar de bodega nuestra operación en Mosquera por una con mayor espacio, mejor ubicación y mas facilidades.\r\n','',0,'2020-07-16 13:08:19',0,0,NULL),(2,'Nueva sede Ibagué-Distrivalles','PRTI-0002',4,0,0,0,3,2,'2020-07-16 12:59:05','2023-04-24 10:55:31',0,0,'2021-03-25 17:00:00','2021-03-27 17:00:00',NULL,NULL,98,1,1,'Adecuación de nueva sede Distrivallés en la ciudad de Ibagué. \r\nDirección: Carrera 5  89 – 95 Barrio Jardín - Autocentro del Tolima\r\nArrendador: Karina Roncancio\r\nCel. 3104800466\r\n\r\n','',0,'2021-03-23 15:56:11',0,0,NULL),(3,'Gestión de impresión','PRTI-0003',4,0,0,0,3,3,'2021-03-24 14:08:38','2023-04-24 10:14:15',0,28,'2021-03-22 17:00:00','2021-04-30 17:00:00',NULL,NULL,96,1,1,'Cambio de Proveedor de impresoras para todas las sedes','',0,'2021-03-24 14:28:53',0,0,NULL),(4,'OFICINAS_LAFLOTA','PRTI-0004',3,0,0,0,3,1,'2021-03-25 13:29:20','2023-04-24 10:55:31',0,0,'2021-04-06 17:00:00','2021-04-09 17:00:00','2021-05-03 17:00:00','2021-05-12 17:00:00',89,1,1,'Realizar las adecuaciones de cableado estructurado y de energía en la sede la flota, de acuerdo a lo evidenciado en el informe adjunto. estas adecuaciones solo serán para el piso 1 y los puestos de trabajo que se identifican en el informe. \r\n\r\n','',0,'2021-03-25 13:32:25',0,0,NULL),(6,'Nueva sede Medellín-MCP ','PRTI-0005',3,0,0,0,1,2,'2021-03-25 15:17:39','2023-04-24 10:14:15',0,0,NULL,NULL,NULL,NULL,0,0,0,'Adecuación de nueva sede de Mineroil, Distrivallés y Ecology en la ciudad de Medellín \r\n','',0,'2021-03-25 15:19:24',0,0,NULL),(7,'CRM EDS San Rafael','PRTI-0006',3,0,0,0,2,4,'2021-04-12 14:20:59','2023-04-24 10:14:15',0,0,'2021-03-10 17:00:00','2021-05-24 17:00:00',NULL,NULL,57,1,1,'1.	Implementar un sistema que permita la captura de información mínima requerida para fidelizar clientes, con el objetivo de realizar campañas de mercadeo, basadas en el consumo y frecuencia de visitas. \r\n2.	Actualmente se tiene implementado la venta de combustible con sistema de Chip que se les ha asignado a algunos clientes y que para validar la asignación de los dispositivos se hace mediante un control manual, hoja impresa que se le suministro a los Isleros.\r\n3.	No se cuenta con un presupuesto definido, pero se cuenta con el VB por pared de la alta gerencia para realizar una inversión moderada. \r\n','',0,'2021-04-12 14:24:49',0,0,NULL),(8,'INFRAESTRUCTURA SAP','PRTI-0007',3,0,0,0,2,5,'2021-04-13 16:31:49','2023-04-24 10:55:31',0,28,'2021-04-15 17:00:00','2021-05-21 17:00:00',NULL,NULL,88,1,1,'Implementación, puesta a punto y despliegue de la infraestructura para el sistema de información SAP BO.','',0,'2021-04-13 16:43:05',0,0,NULL),(9,'Intranet FAW','PRTI-0008',3,0,0,0,2,4,'2021-04-21 00:34:29','2023-04-24 10:14:15',0,0,NULL,NULL,NULL,NULL,50,1,0,'Implementación de Intranet FAW','',0,'2021-04-21 00:34:55',0,0,NULL),(10,'Intranet Arintia','PRTI-0009',3,0,0,0,2,4,'2021-04-21 00:35:27','2023-04-24 10:14:15',0,0,NULL,NULL,NULL,NULL,64,1,0,'Implementación de Intranet Arintia','',0,'2021-04-21 00:37:07',0,0,NULL),(11,'Nueva sede Bucaramanga','PRTI-0010',4,0,0,0,2,2,'2021-04-22 19:52:44','2023-04-24 10:55:31',0,0,'2021-05-03 17:00:00',NULL,'2021-06-15 17:00:00',NULL,80,1,1,'Apertura de nueva sede en la ciudad de Bucaramanga para la UdN MCP, en esta sede estar ubicada la planta de Lubricantes.','',0,'2021-04-22 19:56:02',0,0,NULL),(12,'Nueva sede Medellín-Distrivallés','PRTI-00011',3,0,0,0,1,2,'2021-03-25 15:17:39','2023-04-24 10:14:15',0,0,NULL,NULL,NULL,NULL,0,0,0,'Adecuación de nueva sede de Mineroil, Distrivallés y Ecology en la ciudad de Medellín \r\n','',0,'2021-04-23 21:25:09',0,0,NULL),(13,'Nueva sede Ibague-MCP ','PRTI-00012',1,0,0,0,1,2,'2021-03-25 15:17:39','2023-04-24 10:14:15',0,0,NULL,NULL,NULL,NULL,0,0,0,'Adecuación de nueva sede de Mineroil, Distrivallés y Ecology en la ciudad de Medellín \r\n\r\nEl proyecto queda suspendido hasta nueva orden ','',0,'2021-04-23 21:58:00',0,0,NULL),(14,'Puntos de red Sede barranquilla','PRTI-00013',4,0,0,0,3,5,'2021-05-11 14:26:15','2023-04-24 10:14:15',0,0,'2021-05-13 17:00:00',NULL,NULL,NULL,100,1,0,'Instalación de cableado de red para 6 puntos ','',0,'2021-05-11 14:29:44',0,0,NULL),(15,'Traslado de la sede de Ecology','PRTI-00014',4,0,0,0,2,2,'2021-05-11 14:42:33','2023-04-24 10:14:15',0,0,'2021-05-11 16:00:00','2021-05-18 17:00:00','2021-05-25 17:00:00',NULL,48,1,0,'Traslado de la sede de ecology en Bogotá, dirección es calle70a n 17-27','',0,'2021-05-11 14:43:36',0,0,NULL),(16,'Inclusión Empresa Hunimar a Arintia','PRTI-00015',3,0,0,0,2,2,'2021-05-25 14:01:00','2023-04-24 10:14:15',0,0,'2021-05-13 16:00:00',NULL,NULL,NULL,58,1,0,'Se agrega al grupo de inversiones la nueva empresa Hunimar a la cual le vamos brindar acompañamiento en mejoras tecnológicas.\r\n\r\nFase 1: inicia el 3 de Junio con Infraestructura (Redes, Telefonía fija, cámaras de seguridad, Equipos de cómputo y gestión de impresión, Sistema de información)\r\nFase 2: comunicaciones: (Páginas Web y redes sociales, Correo, Hosting y Dominio)\r\nFase 3: Canal de internet, telefonía móvil,  Licenciamiento de Ofimática, Windows y antivirus, Pasarela de Pagos.','',0,'2021-05-25 14:03:06',0,0,NULL);

--
-- Table structure for table `glpi_projectstates`
--

CREATE TABLE `glpi_projectstates` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_finished` tinyint(1) NOT NULL DEFAULT '0',
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `is_finished` (`is_finished`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_projectstates`
--

INSERT INTO `glpi_projectstates` VALUES (1,'New',NULL,'#06ff00',0,NULL,NULL),(2,'Processing',NULL,'#ffb800',0,NULL,NULL),(3,'Closed',NULL,'#ff0000',1,NULL,NULL);

--
-- Table structure for table `glpi_projecttasklinks`
--

CREATE TABLE `glpi_projecttasklinks` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `projecttasks_id_source` int unsigned NOT NULL,
  `source_uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `projecttasks_id_target` int unsigned NOT NULL,
  `target_uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` tinyint NOT NULL DEFAULT '0',
  `lag` smallint DEFAULT '0',
  `lead` smallint DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `projecttasks_id_source` (`projecttasks_id_source`),
  KEY `projecttasks_id_target` (`projecttasks_id_target`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `glpi_projecttasklinks`
--


--
-- Table structure for table `glpi_projecttasks`
--

CREATE TABLE `glpi_projecttasks` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `comment` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `projects_id` int unsigned NOT NULL DEFAULT '0',
  `projecttasks_id` int unsigned NOT NULL DEFAULT '0',
  `date_creation` timestamp NULL DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `plan_start_date` timestamp NULL DEFAULT NULL,
  `plan_end_date` timestamp NULL DEFAULT NULL,
  `real_start_date` timestamp NULL DEFAULT NULL,
  `real_end_date` timestamp NULL DEFAULT NULL,
  `planned_duration` int NOT NULL DEFAULT '0',
  `effective_duration` int NOT NULL DEFAULT '0',
  `projectstates_id` int unsigned NOT NULL DEFAULT '0',
  `projecttasktypes_id` int unsigned NOT NULL DEFAULT '0',
  `users_id` int unsigned NOT NULL DEFAULT '0',
  `percent_done` int NOT NULL DEFAULT '0',
  `auto_percent_done` tinyint(1) NOT NULL DEFAULT '0',
  `is_milestone` tinyint(1) NOT NULL DEFAULT '0',
  `projecttasktemplates_id` int unsigned NOT NULL DEFAULT '0',
  `is_template` tinyint(1) NOT NULL DEFAULT '0',
  `template_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uuid` (`uuid`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `projects_id` (`projects_id`),
  KEY `projecttasks_id` (`projecttasks_id`),
  KEY `date_mod` (`date_mod`),
  KEY `users_id` (`users_id`),
  KEY `plan_start_date` (`plan_start_date`),
  KEY `plan_end_date` (`plan_end_date`),
  KEY `real_start_date` (`real_start_date`),
  KEY `real_end_date` (`real_end_date`),
  KEY `percent_done` (`percent_done`),
  KEY `projectstates_id` (`projectstates_id`),
  KEY `projecttasktypes_id` (`projecttasktypes_id`),
  KEY `projecttasktemplates_id` (`projecttasktemplates_id`),
  KEY `is_template` (`is_template`),
  KEY `is_milestone` (`is_milestone`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_projecttasks`
--

INSERT INTO `glpi_projecttasks` VALUES (1,'b46fb770-0f41-11eb-b98a-94de80ad7dc2','T1_Desmote de Red','Desmonte de cableado estructurado y equipos red Actual','',0,0,1,0,'2020-07-16 13:37:42','2023-04-24 10:55:31','2020-07-21 04:00:00','2020-07-23 04:00:00',NULL,NULL,86400,0,1,0,113,0,0,0,0,0,NULL),(2,'b47bfc7c-0f41-11eb-b98a-94de80ad7dc2','T2_Traslado Canal de Internet','&lt;p&gt;Realizar solicitud de traslado de canal o cotizar uno nuevo.&lt;/p&gt;','',0,0,1,0,'2020-07-16 13:39:32','2023-04-24 10:55:31','2020-07-16 04:00:00','2020-07-22 04:00:00','2020-07-16 04:00:00',NULL,115200,0,1,0,113,100,0,0,0,0,NULL),(3,'b47c040e-0f41-11eb-b98a-94de80ad7dc2','T3_Montaje de Red','Montaje de red para la nueva Bodega','solo se puedo realizar acompañamiento al proveedor a toma de medidas bodega actual.',0,0,1,0,'2020-07-16 14:05:12','2023-04-24 10:55:31','2020-07-24 04:00:00','2020-07-24 04:00:00',NULL,NULL,115200,0,1,0,113,5,0,0,0,0,NULL),(4,'b47c0aac-0f41-11eb-b98a-94de80ad7dc2','ST3_Visita nueva Bodega','&lt;p&gt;Se programa visita a la nueva Bodega (37) con el proveedor Serviredes a las 2:00 pm&lt;/p&gt;','',0,0,1,3,'2020-07-16 15:33:57','2023-04-24 10:55:31',NULL,'2020-07-21 19:00:00','2020-07-21 18:00:00',NULL,3600,0,3,0,113,100,0,0,0,0,NULL),(5,'6c11580e-69db-4d5d-9bf9-5bf1dd9fa391','T1_Internet','&lt;p&gt;Se valida la viabilidad con el proveedor de de servicios de comunicaciones Claro, con quien se realiza el proceso de Instalación.&lt;/p&gt;&lt;p&gt;A la fecha se ha realizado a visita técnica.  &lt;/p&gt;','',0,0,2,0,'2020-07-16 13:37:42','2023-04-24 10:55:31','2021-03-09 17:00:00',NULL,NULL,NULL,0,0,3,0,113,100,0,0,0,0,NULL),(7,'78bd0a04-53f7-4f2f-a361-b9077856f3d4','T3_Montaje de Red','&lt;p&gt;Montaje de red para la nueva Bodega con el proveedor Serviredes. &lt;/p&gt;','solo se puedo realizar acompañamiento al proveedor a toma de medidas bodega actual.',0,0,2,0,'2020-07-16 14:05:12','2023-04-24 10:55:31','2021-03-25 17:00:00','2021-03-27 17:00:00',NULL,NULL,115200,0,2,0,113,95,0,0,0,0,NULL),(8,'453ab25e-2525-44f0-96d1-ef5fb55da23b','T2_Visita nueva Bodega','&lt;p&gt;Se realizo visita a la nueva bodega y se realiza levantamiento de necesidades. &lt;/p&gt;','',0,0,2,3,'2020-07-16 15:33:57','2023-04-24 10:55:31','2021-03-16 17:00:00','2021-03-18 17:00:00','2020-07-16 17:00:00',NULL,28800,0,3,0,113,100,0,0,0,0,NULL),(9,'0b6ac44f-245f-41ee-a88b-59e65e5a3c26','Búsqueda de proveedores','&lt;p&gt;Búsqueda de proveedores con impresoras nuevas,  7 impresoras para Arintia y 2 para Ecology, aproximado de impresión 35000, validar tiempos de soporte, arriendo de equipos y valor de clic&lt;/p&gt;','Se realiza cotiuzación de 3 proveedores escogiendo a Puntear como proveedor final',0,0,3,0,'2021-03-24 14:35:41','2023-04-24 10:14:15','2021-03-19 17:00:00','2021-03-26 17:00:00',NULL,'2021-03-29 17:00:00',0,0,3,0,113,100,0,0,0,0,NULL),(10,'dd380547-c348-4c2e-abe0-56ca91d58726','Comparativo de impresoras ','&lt;p&gt;Se realiza comparativo de 3 proveedores de impresión, dejando como proveedor final a Puntear &lt;/p&gt;','',0,0,3,0,'2021-03-24 16:22:08','2023-04-24 10:14:15','2021-03-29 17:00:00','2021-03-31 17:00:00',NULL,NULL,0,0,3,0,113,100,0,0,0,0,NULL),(11,'577aa3db-d10b-4806-85d6-eed6f7b1c923','T1_Rack de Comunicaciones','&lt;p&gt;Organizar cableado y fibra óptica que llegan al Rack para que se pueda administrar fácilmente. &lt;/p&gt;','',0,0,4,0,'2021-03-25 13:38:33','2023-04-24 10:55:31',NULL,NULL,NULL,NULL,0,0,2,0,113,85,0,0,0,0,NULL),(12,'df98490c-6daa-41ff-b95f-1278944752a3','T2_Puntos de Red','&lt;p&gt;Realizar validación de puestos de Trabajo para cotizar las adecuaciones de red y energía.&lt;/p&gt;','',0,0,4,0,'2021-03-25 14:22:00','2023-04-24 10:55:31',NULL,NULL,NULL,NULL,57600,0,3,0,113,100,0,0,0,0,NULL),(13,'8824a1b4-9793-473f-acad-826b82c0ba80','T4_Red Inalambrica','&lt;p&gt;Para la red inalámbrica se requiere ubicar un AP que de cobertura al primer piso, esta es la necesidad principal. si se habilitan puestos de trabajo en el segundo piso se debe contemplar un AP para el segundo piso.  &lt;/p&gt;','',0,0,4,12,'2021-03-25 14:32:41','2023-04-24 10:55:31',NULL,NULL,NULL,NULL,28800,0,2,0,113,90,0,0,0,0,NULL),(14,'dfa14491-8e44-48bf-8c76-29cba67c1c8b','Contrato proveedor ','&lt;p&gt;se envía contrato a Jurídica (Maria Juliana) para revisión de contrato el día 31 de Marzo, el día 8 de Abril lo contesta con observaciones y se procede a enviar el contrato al proveedor para las correcciones, pendiente recepción del nuevo contrato&lt;/p&gt;','',0,0,3,10,'2021-03-25 15:12:48','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,2,0,113,80,0,0,0,0,NULL),(15,'41a701a4-e4f9-4467-9560-9abd2a9e5cae','Cotizar Tablet y / o Smartphone  ','','',0,0,7,0,'2021-04-12 14:26:26','2023-04-24 10:14:15','2021-04-14 17:00:00',NULL,NULL,NULL,0,0,2,0,113,15,0,0,0,0,NULL),(16,'cba22eb6-841f-45f9-8f0b-ff5a9d922a98','Adquirir licencia de Zoho Estándar ','&lt;p&gt;Pendiente realizar el pago de la plataforma&lt;/p&gt;','',0,0,7,0,'2021-04-12 14:27:13','2023-04-24 10:14:15','2021-04-12 17:00:00',NULL,NULL,NULL,0,0,2,0,113,80,0,0,0,0,NULL),(17,'634e0745-9509-4224-be88-55c85338c822','Archivo con la información básica requerida para iniciar pruebas piloto ','','',0,0,7,0,'2021-04-12 14:28:08','2023-04-24 10:14:15','2021-03-17 17:00:00',NULL,NULL,NULL,0,0,3,0,113,100,0,0,0,0,NULL),(18,'879daf5f-1d3a-46a7-97af-4422edbcdade','Piloto CRM','','',0,0,7,0,'2021-04-12 14:28:38','2023-04-24 10:14:15','2021-04-19 17:00:00',NULL,NULL,NULL,0,0,1,0,113,0,0,0,0,0,NULL),(19,'bb975e85-802e-4283-acb6-1ece07d18104','T0_Cotizacion Adecuaciones','&lt;p&gt;Definir las adecuaciones a realizar.&lt;/p&gt;','Se realiza solicitud de cotización de la obra a Gilberto Salazar. Una vez se tenga, se procederá a informar a Jairo Ochoa. ',0,0,4,0,'2021-04-12 23:39:34','2023-04-24 10:55:31','2021-04-13 17:00:00','2021-04-15 17:00:00',NULL,NULL,14400,0,3,0,113,100,0,0,0,0,NULL),(20,'f8331ed9-b25e-4814-b396-06fb8dfd95ee','T4_Instalacion Equipos','&lt;p&gt;Envió e instalación de equipos de impresión a cada sede. &lt;/p&gt;&lt;p&gt;Se realiza la instalación de los equipos en las sedes de Mineroil Medellín, FAW Truck Mosquera, Bucaramanga, Distrivalles Medellín,  y Ecology 116  &lt;/p&gt;','',0,0,3,14,'2021-04-13 16:27:44','2023-04-24 10:55:31','2021-04-22 17:00:00',NULL,NULL,NULL,0,0,3,0,113,100,0,0,0,0,NULL),(21,'8a8be8c7-7e72-460d-80f3-e997c293e798','T5_Configuracion Usuario','&lt;p&gt;Configuración de impresoras  y Gestion de escáner a usuarios finales en cada sede. &lt;/p&gt;','',0,0,3,20,'2021-04-13 16:29:53','2023-04-24 10:55:31','2021-04-23 17:00:00',NULL,NULL,NULL,57600,0,3,0,113,100,0,0,0,0,NULL),(22,'2f3992a1-39c0-49fe-a007-82a4e17ae4b2','Crear usuarios de AD','&lt;p&gt;Creación de usuarios de AC en el servidor Zential Arintia&lt;/p&gt;','',0,0,8,0,'2021-04-14 14:39:31','2023-04-24 10:14:15','2021-04-19 17:00:00',NULL,NULL,NULL,0,0,2,0,113,75,0,0,0,0,NULL),(23,'08323ba0-f9b6-4e9b-8f7f-2d34be8f003d','Instalación de Antivirus y Creación De políticas de Antivirus','&lt;p&gt;Instalación de Antivirus Bitfdefender y Creación De políticas de Antivirus&lt;/p&gt;','',0,0,8,0,'2021-04-14 14:42:58','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,3,0,113,100,0,0,0,0,NULL),(24,'3e23c912-80e8-43a3-a5ff-185de50a6ba0','Politicas de Navegación','&lt;p&gt;Políticas de Navegación&lt;/p&gt;','Se configura política de navegación sobre los equipos RPD de acuerdo al perfil de AD y solos los usuarios con perfil de Admis Domain tiene acceso a internet.',0,0,8,0,'2021-04-14 15:07:22','2023-04-24 10:14:15','2021-05-05 17:00:00','2021-05-07 17:00:00',NULL,NULL,0,0,2,0,113,90,0,0,0,0,NULL),(25,'aa647f8e-6fca-4a36-9bc2-79036756a048','Compra de TS plus - Licencianciento terminal server 1 licencia','&lt;p&gt;Compra de TS plus - Licenciamiento terminal server 1 licencia&lt;/p&gt;','',0,0,8,0,'2021-04-14 15:08:00','2023-04-24 10:14:15','2021-04-28 17:00:00','2021-05-15 17:00:00',NULL,NULL,0,0,3,0,113,100,0,0,0,0,NULL),(26,'ae69448e-e56f-4d45-9e86-e4fa1df1124d','Instalación y configuración TSPlus','&lt;p&gt;Instalación y configuración TSPlus&lt;/p&gt;','',0,0,8,0,'2021-04-14 15:19:28','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,2,0,113,80,0,0,0,0,NULL),(27,'f06e4c83-b061-4e99-a7dc-a5449cbdc3bc','Pruebas de conectividad por Balanceo','&lt;p&gt;Pruebas de conectividad por Balanceo de usuarios&lt;/p&gt;&lt;p&gt;Se realizan pruebas de BAlanceo con 4 usuario y permite distribuir entre los dos servidores&lt;/p&gt;&lt;p&gt;pendiente realizar con mas usuarios&lt;/p&gt;','',0,0,8,0,'2021-04-14 15:19:55','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,2,0,113,90,0,0,0,0,NULL),(28,'0e8c4af2-563d-4589-89a8-a0c1bcf92017','Creación de usuarios de servicio','&lt;p&gt;Creación de usuarios de servicio &lt;/p&gt;','',0,0,8,0,'2021-04-14 15:20:09','2023-04-24 10:14:15','2021-05-08 17:00:00',NULL,NULL,NULL,0,0,2,0,113,85,0,0,0,0,NULL),(29,'a377940a-726e-4948-889d-c77f56590956','Credenciales Consultores Heisohn','&lt;p&gt;1.Solicitar usuarios de Consultores Heissohn&lt;/p&gt;&lt;p&gt;2. Configuración de usuarios Heissohn en DA&lt;/p&gt;&lt;p&gt;3. Envío de Credenciales a usuarios Heissohn&lt;/p&gt;','',0,0,8,0,'2021-04-14 15:20:21','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,3,0,113,100,0,0,0,0,NULL),(30,'b6809a47-e06f-448d-bc34-b9a46714cce2','Creación de Usuarios consultores','&lt;p&gt;Creación de Usuarios consultores de Heissohn&lt;/p&gt;','',0,0,8,0,'2021-04-14 15:20:42','2023-04-24 10:14:15','2021-04-27 17:00:00','2021-05-08 17:00:00',NULL,NULL,0,0,3,0,113,100,0,0,0,0,NULL),(31,'efbc92dc-120c-4a80-b724-854aa2407643','Validación aprovisionamiento del Storage de almacenamiento','&lt;p&gt;Validación aprovisionamiento del Storage de almacenamiento&lt;/p&gt;&lt;p&gt;Aprovisionamiento Storage Sap&lt;/p&gt;&lt;p&gt;Aprovisionamiento Storage Nomina&lt;/p&gt;','',0,0,8,0,'2021-04-14 15:20:55','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,3,0,113,100,0,0,0,0,NULL),(32,'5138693b-b4f8-4ab9-95d9-45f737db5c3e','migración equipos de computo','&lt;p&gt;migración equipos de computo (Se requiere realizar plan de trabajo de configuración)&lt;/p&gt;&lt;ol&gt;&lt;li&gt;Realizar listado de equipos a migrar a SAP (Solicitar listado de usuarios). organizar por Unidad de negocios y por Área.&lt;/li&gt;&lt;li&gt;Agendar reunión para validar el plan de Trabajo de migración de equipos.&lt;/li&gt;&lt;/ol&gt;','',0,0,8,0,'2021-04-14 15:21:47','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,2,0,113,70,0,0,0,0,NULL),(33,'98deeaa7-bcb1-4117-9d0c-58087f434252','Configuración política de backuyp','&lt;p&gt;Configuración política de backup&lt;/p&gt;','',0,0,8,0,'2021-04-14 15:22:04','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,2,0,113,65,0,0,0,0,NULL),(34,'5d0b93ec-1898-466e-aa5a-b838412ac60b','Cancelación proveedor anterior','&lt;p&gt;apenas se cuente con el contrato firmado se debe comunicar al proveedor actual de la terminación del servicio &lt;/p&gt;&lt;p&gt;Ya se encuentran retirando los equipos del  proveedor anterior&lt;/p&gt;&lt;p&gt; &lt;/p&gt;','',0,0,3,0,'2021-04-16 22:33:15','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,2,0,113,95,0,0,0,0,NULL),(35,'0385518f-3e02-4ffe-967a-9873f38cee5f','T3_Ejecución Adecuaciones','&lt;p&gt;Se aprueba la cotización, por lo cual se le informa al proveedor que ya puede iniciar la instalación de los diferentes puntos de red.&lt;/p&gt;','',0,0,4,0,'2021-04-19 17:22:17','2023-04-24 11:22:24','2021-04-20 17:00:00','2021-04-22 17:00:00','2021-04-20 17:00:00','2021-05-04 17:00:00',28800,0,2,0,113,70,0,0,0,0,NULL),(36,'08472dd0-e696-4049-ba93-f20adc505c9a','configuraqción de AD','','',0,0,8,0,'2021-04-21 00:31:00','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,2,0,113,85,0,0,0,0,NULL),(37,'f3bb4671-2dcc-4733-ac72-467b1fb1b449','Configuración CRM Zoho','&lt;p&gt;queda pendiente los cambios solicitados según presentación&lt;/p&gt;','',0,0,7,0,'2021-04-21 00:32:16','2023-04-24 10:14:15','2021-04-29 17:00:00','2021-05-13 17:00:00',NULL,NULL,0,0,2,0,113,90,0,0,0,0,NULL),(38,'cdc8c57d-a322-45c7-be91-f51f00ba98e0','Implementación de la landing de COMPRAS','&lt;p&gt;Implementación de la landing de COMPRAS&lt;/p&gt;','',0,0,9,0,'2021-04-21 00:35:22','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,2,0,113,50,0,0,0,0,NULL),(39,'e44961f6-e701-464b-995b-8cc9ba00979d','Revisión de necesidades','','',0,0,10,0,'2021-04-21 00:37:32','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,3,0,113,100,0,0,0,0,NULL),(40,'9749039c-f03b-433a-a1f3-1da41b48a71d','Instalación y configuracion de plantillas','','',0,0,10,0,'2021-04-21 00:39:21','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,3,0,113,100,0,0,0,0,NULL),(41,'74b8abb9-faab-4836-9d0a-7550ffc559e0','Presentación de propuesta 1 ','','',0,0,10,0,'2021-04-21 00:41:08','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,3,0,113,100,0,0,0,0,NULL),(42,'5127e2bc-a1aa-4ca7-b63d-5f63285f3258','Realización de cambios y cargue de información','','',0,0,10,0,'2021-04-21 00:41:56','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,2,0,113,80,0,0,0,0,NULL),(43,'4a8d75bc-99b3-448a-a01a-cdb5202ea57d','Presentación de intranet 2','','',0,0,10,0,'2021-04-21 00:42:19','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,1,0,113,5,0,0,0,0,NULL),(44,'5c423ee4-3c8b-4c39-8d39-c7cd35efc4ad','T1-Contratacion canal Internet','&lt;p&gt;Realizar la validación cual des los proveedores tienen cobertura de internet por fibra en la zona, hay que contemplar un canal adicional como contingencia. &lt;/p&gt;','El canal principal se adquirió con Claro. ',0,0,11,0,'2021-04-22 20:01:45','2023-04-24 10:55:31','2021-04-26 17:00:00','2021-04-30 17:00:00',NULL,NULL,0,0,3,0,113,100,0,0,0,0,NULL),(45,'817d7df9-416d-49c2-837f-7833e1142fc2','Revisión Bodega y necesidades','&lt;p&gt;Coordina r visita con Luis para definir  a la nueva bodega de MCP Ibagué, donde se evalúen las necesidades de tecnología :&lt;/p&gt;&lt;ol&gt;&lt;li&gt;Canal de Internet:&lt;/li&gt;&lt;li&gt;# de cámaras de seguridad y Ubicación &lt;/li&gt;&lt;li&gt;Red Wifi&lt;/li&gt;&lt;li&gt;Red cableado estructurado y puntos de energía para un puesto de trabajo&lt;/li&gt;&lt;li&gt;Una vez finalizada la vista realizar acta de Levantamiento de Información.&lt;/li&gt;&lt;/ol&gt;','',0,0,13,0,'2021-04-23 22:00:41','2023-04-24 10:14:15','2021-04-26 17:00:00','2021-04-30 17:00:00',NULL,NULL,0,0,1,0,113,0,0,0,0,0,NULL),(46,'6d5658e4-3e07-4d3d-a479-059c7deeb21e','Gestión nuevo Canal de internet','&lt;p&gt;Gestión de Nuevo Canal de Internet, (Internet banda ancha en fibra de 100 MB) &lt;/p&gt;&lt;ol&gt;&lt;li&gt;Cotización canal de internet: validar con Claro y ETB&lt;/li&gt;&lt;li&gt;Comparativos de canales de internet&lt;/li&gt;&lt;li&gt;Solicitud y contratación del nuevo canal &lt;/li&gt;&lt;li&gt;Seguimiento a Obra Civil, empalme y entrega&lt;/li&gt;&lt;li&gt;Revisión de funcionamiento y puesta en Marcha&lt;/li&gt;&lt;/ol&gt;&lt;p&gt; &lt;/p&gt;','Se procede a solicitar canal de internet con Claro, Se solicita canal de 100mb estamos pendientes de que se envie el contrato para firmarlo',0,0,13,0,'2021-04-23 22:03:43','2023-04-24 10:14:15','2021-04-23 17:00:00','2021-04-30 17:00:00',NULL,NULL,0,0,1,0,113,50,0,0,0,0,NULL),(47,'8022740d-1809-478c-8016-b455430a8c50','cámaras de seguridad: ','&lt;p&gt;Cotizar DVR de 2 TB de almacenamiento si la cantidad de cámaras a instalar son menos de 8&lt;/p&gt;&lt;ol&gt;&lt;li&gt;Cotizar con serviredes la cantidad de cámaras según acta de revisión &lt;/li&gt;&lt;li&gt;Instalación de DVR y camaras&lt;/li&gt;&lt;li&gt;configuración de accesos&lt;/li&gt;&lt;li&gt;Creación en GLPI&lt;/li&gt;&lt;/ol&gt;','Buen Día, Serviredes se dirige hasta la sede para tomar medidas y pasar cotización de las camaras',0,0,13,46,'2021-04-23 22:05:26','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,1,0,113,20,0,0,0,0,NULL),(48,'a57c4eb8-feb7-4626-9d78-39d52a55e2db','Adecuaciones de red Bodega','','',0,0,13,0,'2021-05-06 15:23:33','2023-04-24 10:14:15','2021-05-10 17:00:00','2021-05-31 17:00:00',NULL,NULL,0,0,1,0,113,0,0,0,0,0,NULL),(49,'c1fe693f-8fd0-4a44-be1b-490378e23bca','Solicitud de personal por app','','',0,0,10,0,'2021-05-06 16:16:23','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,1,0,113,0,0,0,0,0,NULL),(50,'a3aff14f-a3d3-429d-a473-d73f02fa32bd','Revisión de bodega y necesidades','&lt;p&gt;Coordinar visita con Luis para definir  a la nueva bodega Bucaramanga, donde se evalúen las necesidades de tecnología :&lt;/p&gt;&lt;ol&gt;&lt;li&gt;Canal de Internet:&lt;/li&gt;&lt;li&gt;# de cámaras de seguridad y Ubicación &lt;/li&gt;&lt;li&gt;Red Wifi&lt;/li&gt;&lt;li&gt;Red cableado estructurado y puntos de energía para un puesto de trabajo&lt;/li&gt;&lt;li&gt;Una vez finalizada la vista realizar acta de Levantamiento de Información.&lt;/li&gt;&lt;/ol&gt;','Se configura la red para el edificio Principal ya que las demás oficinas no se han definido. ',0,0,11,0,'2021-05-11 14:16:06','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,3,0,113,100,0,0,0,0,NULL),(51,'978eb07f-6fc6-4241-93c1-903cc95ec0a7','cámaras de seguridad','&lt;p&gt;Revisar las cámaras de seguridad,  cuales están funcionales y cuales no así como el NVR&lt;/p&gt;','Se están revisando los equipos actuales y cotizando la puesta en marcha del sistema. ',0,0,11,0,'2021-05-11 14:18:53','2023-04-24 10:14:15','2021-06-01 17:00:00','2021-06-22 17:00:00',NULL,NULL,0,0,2,0,113,50,0,0,0,0,NULL),(52,'eb3d1c45-6ce9-4fe7-9fa3-f7d12a2e14d0','Necesidades de equipos de red','&lt;p&gt;Revisar que equipos de red se requieren para la nueva sede&lt;/p&gt;','',0,0,11,0,'2021-05-11 14:20:52','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,2,0,113,80,0,0,0,0,NULL),(53,'3820e77c-0a0f-44d9-96b4-dafc162ffdff','Instalación y configuración de equipos de red','&lt;p&gt;Instalación y configuración de los equipos adquiridos, puesta en marcha de los puntos de red asignados&lt;/p&gt;','Se realizo instalación de equipos de red y configuración de los mismo.',0,0,11,0,'2021-05-11 14:25:11','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,2,0,113,70,0,0,0,0,NULL),(54,'867545a8-3659-4fc9-890b-f18cba5bf1db','Revisión de necesidad','&lt;p&gt;Revisar las necesidades de la bodega según manifiesta el usuario  &lt;/p&gt;','',0,0,14,0,'2021-05-11 14:30:27','2023-04-24 10:14:15',NULL,NULL,'2021-05-06 17:00:00','2021-05-12 17:00:00',0,16200,3,0,113,100,0,0,0,0,NULL),(55,'4012f5e0-a4c2-4453-8a29-70af95cbcb01','Cotizar puntos de red','&lt;p&gt;Cotizar el cableado estructurado &lt;/p&gt;','',0,0,14,54,'2021-05-11 14:31:01','2023-04-24 10:14:15',NULL,NULL,'2021-05-12 17:00:00',NULL,0,0,3,0,113,100,0,0,0,0,NULL),(56,'ee85302b-b5a1-44c2-90f9-411abf70effe','Cotizar equipos de red necesarios','&lt;p&gt;Cotizar que equipos son necesarios para el funcionamiento de la red&lt;/p&gt;','',0,0,14,0,'2021-05-11 14:31:43','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,3,0,113,100,0,0,0,0,NULL),(57,'6a84d8a1-1404-44f7-a612-e1dabd146924','Instalación y configuración','&lt;p&gt;Realizar la instalación y configuración de los equipos para dejar puesta en marcha los puntos de red&lt;/p&gt;','',0,0,14,56,'2021-05-11 14:33:10','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,3,0,113,100,0,0,0,0,NULL),(58,'e55696ea-12ff-4aa5-8196-953dbd08279a','Revisión de bodega y necesidades','&lt;p&gt;Visita a la nueva sede y validar necesidades de cableado estructurado y energía&lt;/p&gt;','Buen Día.\r\nSe procede a realizar la visita técnica el día de hoy 28 de mayo de 2021 .\r\nSe pudo evidenciar que la sede no cuenta actualmente con un cableado estructurado. serviredes toma medidas para realizar el plano y así podamos ubicar la cantidad de puestos de trabajo que se requieran, por otra parte, serviredes tomara las canaletas y demás materiales que se quiten de la sede antigua de la 116 para usarlos en la nueva  sede. Adjunto fotos de la sede nueva.\r\n\r\nPor otra parte ya se solicitó con claro cotización de fibra óptica y estamos a la espera de  respuesta.\r\nQuedo atento a cualquier inquietud.\r\n\r\nCordial Saludo\r\n',0,0,15,0,'2021-05-11 15:28:06','2023-04-24 10:14:15','2021-05-11 16:00:00','2021-05-11 17:00:00','2021-05-11 16:00:00',NULL,0,0,2,0,113,80,0,0,0,0,NULL),(59,'7fe0968c-251f-4646-ba31-7f59e99b5674','Servicio de Internet','&lt;ol&gt;&lt;li&gt;Solicitar cancelación del servicio  de la sede actual&lt;/li&gt;&lt;li&gt;Solicitud de canal de internet con Tigo UNE para la nueva sede de 60 MB&lt;/li&gt;&lt;li&gt;Dirección de la nueva sede Calle 70a n 17-27&lt;/li&gt;&lt;/ol&gt;','Buen Día .Se procede a solicitar cotización de canal de internet de Claro y tigo.\r\n',0,0,15,58,'2021-05-11 15:37:59','2023-04-24 10:14:15','2021-05-25 17:00:00','2021-06-23 17:00:00',NULL,NULL,0,0,2,0,113,50,0,0,0,0,NULL),(60,'f6c071bc-e653-42ba-9575-e13fbc0807ac','Desmonte de infraestructura sede actual.','&lt;ol&gt;&lt;li&gt;Desmonte de infraestructura sede actual.&lt;/li&gt;&lt;/ol&gt;','',0,0,15,58,'2021-05-11 15:38:34','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,1,0,113,0,0,0,0,0,NULL),(61,'d1d75884-ff91-4d80-8c5f-de2eca1b3236','Montaje nueva sede ','&lt;p&gt;Instalacion y configuración de la nueva sede de ecology &lt;/p&gt;','Buen Día.\r\nServiredes se encientra desde el día 10/06/2021 realizando las respectivas aecuaciones',0,0,15,0,'2021-05-11 15:39:19','2023-04-24 10:14:15',NULL,NULL,NULL,NULL,0,0,1,0,113,60,0,0,0,0,NULL),(62,'482a51ae-ca22-46ed-a310-081b24f50c3e','Conocimiento Operacion Hunimar','&lt;p&gt;Reunión con el personal de Hunimar para revisar las diferentes necesidades tecnológicas de la operación de Hunimar, se genera acta de reunión donde se les indica el catálogo de Servicios de Tecnología &lt;/p&gt;','',0,0,16,0,'2021-05-25 14:09:16','2023-04-24 10:14:15','2021-05-12 15:00:00','2021-05-12 16:00:00',NULL,NULL,0,0,3,0,113,100,0,0,0,0,NULL),(63,'a75354f8-60bf-4a62-83d3-6e0bb692bd4e','Visita Sede ','&lt;p&gt;Visita a Sede teniendo base el acta de la primera reunión&lt;/p&gt;&lt;p&gt;*Se realiza visita, tomando como base el acta de la primera reunión, se realiza recorrido en la sede y se recopila información de las diferentes necesidades, como correo,  Infraestructura, &lt;/p&gt;&lt;p&gt; &lt;/p&gt;&lt;p&gt;En base a la visita se genera Plan de trabajo para inicio el día  3 de Junio con la visita a la sede de parte del personal de Tecnología y nuestro proveedor Serviredes para revisión de la infraestructura que abarca Redes,  Sistema de Cámaras y Planta telefónica&lt;/p&gt;','La fase 1: corresponderá revisión de redes, telefonía fija, cámaras de seguridad, equipos de cómputo y sistema de información.\r\n\r\nProponemos iniciar el día 3 de junio con la visita de nuestro proveedor de infraestructura donde se revisará y cotizara el mejoras del cableado de red, fallas de telefonía fija y sistema de cámaras de seguridad.\r\nAsí mismo mantenimiento lógico y físico de los equipos de cómputo de la compañía y revisión del sistema de información World Office, este último con el fin de revisar la configuración y estado del sistema y backup del mismo. \r\n\r\nPara esta labor adicional a nuestro proveedor de infraestructura irían dos miembros del departamento de Tecnología, para ello es necesario disponer de los equipos de computo y sistema de información en el momento que lo requiera alguno de los miembros.\r\n\r\nFase 2:  Corresponde Pagina Web, Hosting y dominio y Correo electrónico.\r\n\r\nProponemos revisión y optimización de la pagina web, uso de Hosting y dominio, con los correos unificación de correos en plataforma 365 la cual brinda diferentes Herramientas de comunicación y almacenamiento seguro.\r\n\r\nPara el inicio de esta fase dependemos del acceso al hosting y administración de domino actual y anterior esto con el fin de generar los traslados y nueva configuración de correo\r\n\r\nFase 3:  Corresponde a Canal de internet, telefonía Móvil, Licenciamiento de Windows, ofimática y antivirus, y mejoras en la pasarela de pagos\r\n\r\nProponemos revisar, mejorar y optimizar los costos y servicios mediante los convenios que cuenta Arintia Group con nuestros proveedores.\r\n\r\nPara realizar estas fases se requiere contar con: \r\n\r\n•	Administración (envió de enlace de acceso, usuarios y claves) de los administradores de todas las plataformas, servicios y equipos que tiene Hunimar.\r\n•	Para optimización de los costos, incluyéndolos en los contratos actuales de nuestro proveedor se requiere cámara y comercio donde indique que Arintia Group es accionista de Hunimar. \r\n•	Para las visitas propuestas se requiere disponibilidad de una persona por parte de Hunimar que brinde las Ubicaciones y estatus de los equipos, así misma disponibilidad de los equipos cuando sean requeridos por el miembro de tecnología \r\n\r\nDe igual forma mientras se culminan las fases se brindara acompañamiento y soporte por parte del departamento de Tecnología, las cuales se deben canalizar a través del correo Catherine.hernandez@arintia.com, y al finalizar estas fases se incluirán en la mesa de ayuda de Tecnología para todos los requerimientos.\r\n',0,0,16,62,'2021-05-25 14:31:26','2023-04-24 10:14:15','2021-05-19 16:20:00','2021-05-19 22:00:00','2021-05-19 16:20:00','2021-05-19 22:00:00',0,0,3,0,113,0,0,0,0,0,NULL),(64,'6ab9ba47-63dc-46a6-8e1c-bc11a2ced1cb','Revisión infraestructura','&lt;p&gt;Revisión y cotización de:&lt;/p&gt;&lt;ul&gt;&lt;li&gt;&lt;strong&gt;Redes, Telefonía fija, cámaras de seguridad: &lt;/strong&gt;Visita de proveedor para revisión de la infraestructura actual y su funcionamiento, generando así la cotización de mantenimiento, mejoras y adecuaciones.&lt;/li&gt;&lt;/ul&gt;','',0,0,16,63,'2021-05-25 14:34:06','2023-04-24 10:14:15','2021-06-03 17:00:00',NULL,NULL,NULL,0,0,3,0,113,100,0,0,0,0,NULL),(65,'0a2c573b-094a-48e1-a8c6-9ec3d74494fc','mantenimiento y revisión de Equipos de computo','&lt;p&gt;Mantenimiento preventivo y correctivo de equipos de computo e impresoras &lt;/p&gt;&lt;ul&gt;&lt;li&gt;&lt;strong&gt;Equipos de cómputo y gestión de impresión: &lt;/strong&gt;Visita por miembro del equipo de tecnología para realizar el mantenimiento preventivo y correctivo, revisión de fallas y elementos dañados de los equipos de cómputo, generar el inventario de equipos de equipos de cómputo.&lt;/li&gt;&lt;/ul&gt;','',0,0,16,63,'2021-05-25 14:35:33','2023-04-24 10:14:15','2021-06-03 17:00:00',NULL,NULL,NULL,0,0,1,0,113,0,0,0,0,0,NULL),(66,'0db3953a-8656-414b-8c4f-8e310af6febf','Revisión sistema de información','&lt;ul&gt;&lt;li&gt;&lt;strong&gt;Sistema de información: &lt;/strong&gt;revisión del sistema completo de información, generación de respaldo (se enseñaría al responsable del sistema como realizarlo y frecuencia de este), generando recomendaciones de mejores prácticas de uso del sistema.&lt;/li&gt;&lt;/ul&gt;&lt;p&gt;Se recomienda adquirir el soporte anual para tener acceso a las actualizaciones del sistema y posibles fallas generadas&lt;/p&gt;','',0,0,16,63,'2021-05-25 14:37:09','2023-04-24 10:14:15','2021-06-03 17:00:00',NULL,NULL,NULL,0,0,2,0,113,90,0,0,0,0,NULL);

--
-- Table structure for table `glpi_projecttasks_tickets`
--

CREATE TABLE `glpi_projecttasks_tickets` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `tickets_id` int unsigned NOT NULL DEFAULT '0',
  `projecttasks_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`tickets_id`,`projecttasks_id`),
  KEY `projects_id` (`projecttasks_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_projecttasks_tickets`
--


--
-- Table structure for table `glpi_projecttaskteams`
--

CREATE TABLE `glpi_projecttaskteams` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `projecttasks_id` int unsigned NOT NULL DEFAULT '0',
  `itemtype` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `items_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`projecttasks_id`,`itemtype`,`items_id`),
  KEY `item` (`itemtype`,`items_id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_projecttaskteams`
--

INSERT INTO `glpi_projecttaskteams` VALUES (3,2,'Supplier',8),(1,3,'Supplier',8),(5,4,'Supplier',8),(8,5,'Supplier',10),(9,7,'Supplier',8);

--
-- Table structure for table `glpi_projecttasktemplates`
--

CREATE TABLE `glpi_projecttasktemplates` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `comment` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `projects_id` int unsigned NOT NULL DEFAULT '0',
  `projecttasks_id` int unsigned NOT NULL DEFAULT '0',
  `plan_start_date` timestamp NULL DEFAULT NULL,
  `plan_end_date` timestamp NULL DEFAULT NULL,
  `real_start_date` timestamp NULL DEFAULT NULL,
  `real_end_date` timestamp NULL DEFAULT NULL,
  `planned_duration` int NOT NULL DEFAULT '0',
  `effective_duration` int NOT NULL DEFAULT '0',
  `projectstates_id` int unsigned NOT NULL DEFAULT '0',
  `projecttasktypes_id` int unsigned NOT NULL DEFAULT '0',
  `users_id` int unsigned NOT NULL DEFAULT '0',
  `percent_done` int NOT NULL DEFAULT '0',
  `is_milestone` tinyint(1) NOT NULL DEFAULT '0',
  `comments` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `projects_id` (`projects_id`),
  KEY `projecttasks_id` (`projecttasks_id`),
  KEY `date_creation` (`date_creation`),
  KEY `date_mod` (`date_mod`),
  KEY `users_id` (`users_id`),
  KEY `plan_start_date` (`plan_start_date`),
  KEY `plan_end_date` (`plan_end_date`),
  KEY `real_start_date` (`real_start_date`),
  KEY `real_end_date` (`real_end_date`),
  KEY `percent_done` (`percent_done`),
  KEY `projectstates_id` (`projectstates_id`),
  KEY `projecttasktypes_id` (`projecttasktypes_id`),
  KEY `is_milestone` (`is_milestone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_projecttasktemplates`
--


--
-- Table structure for table `glpi_projecttasktypes`
--

CREATE TABLE `glpi_projecttasktypes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_projecttasktypes`
--


--
-- Table structure for table `glpi_projectteams`
--

CREATE TABLE `glpi_projectteams` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `projects_id` int unsigned NOT NULL DEFAULT '0',
  `itemtype` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `items_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`projects_id`,`itemtype`,`items_id`),
  KEY `item` (`itemtype`,`items_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_projectteams`
--


--
-- Table structure for table `glpi_projecttypes`
--

CREATE TABLE `glpi_projecttypes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_projecttypes`
--

INSERT INTO `glpi_projecttypes` VALUES (1,'Redes','','2020-07-16 13:05:05','2020-07-16 13:05:05'),(2,'Nueva Sede','Apertura de nuevas sedes','2021-03-23 15:57:19','2021-03-23 15:57:19'),(3,'Impresoras','','2021-03-24 14:09:14','2021-03-24 14:09:14'),(4,'Software','','2021-04-12 14:21:33','2021-04-12 14:21:33'),(5,'Infraestructura','Proyectos de sistemas de Información e Infraestructura.','2021-04-13 16:40:20','2021-04-13 16:40:20');

--
-- Table structure for table `glpi_queuednotifications`
--

CREATE TABLE `glpi_queuednotifications` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `itemtype` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `items_id` int unsigned NOT NULL DEFAULT '0',
  `notificationtemplates_id` int unsigned NOT NULL DEFAULT '0',
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `sent_try` int NOT NULL DEFAULT '0',
  `create_time` timestamp NULL DEFAULT NULL,
  `send_time` timestamp NULL DEFAULT NULL,
  `sent_time` timestamp NULL DEFAULT NULL,
  `name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `sender` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `sendername` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `recipient` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `recipientname` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `replyto` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `replytoname` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `headers` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `body_html` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `body_text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `messageid` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `documents` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `mode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'See Notification_NotificationTemplate::MODE_* constants',
  `event` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `item` (`itemtype`,`items_id`,`notificationtemplates_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `entities_id` (`entities_id`),
  KEY `sent_try` (`sent_try`),
  KEY `create_time` (`create_time`),
  KEY `send_time` (`send_time`),
  KEY `sent_time` (`sent_time`),
  KEY `mode` (`mode`),
  KEY `notificationtemplates_id` (`notificationtemplates_id`)
) ENGINE=InnoDB AUTO_INCREMENT=107283 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_queuednotifications`
--

INSERT INTO `glpi_queuednotifications` VALUES (107282,'NotificationAjax',1,0,0,1,0,'2023-11-24 12:55:39','2023-11-24 12:56:39',NULL,'Test notification',NULL,'TEST','2001',NULL,NULL,NULL,'',NULL,'Hello, this is a test notification.',NULL,'','ajax','test_notification');

--
-- Table structure for table `glpi_rackmodels`
--

CREATE TABLE `glpi_rackmodels` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `product_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  `pictures` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `product_number` (`product_number`),
  KEY `date_creation` (`date_creation`),
  KEY `date_mod` (`date_mod`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_rackmodels`
--


--
-- Table structure for table `glpi_racks`
--

CREATE TABLE `glpi_racks` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `locations_id` int unsigned NOT NULL DEFAULT '0',
  `serial` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otherserial` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rackmodels_id` int unsigned DEFAULT NULL,
  `manufacturers_id` int unsigned NOT NULL DEFAULT '0',
  `racktypes_id` int unsigned NOT NULL DEFAULT '0',
  `states_id` int unsigned NOT NULL DEFAULT '0',
  `users_id_tech` int unsigned NOT NULL DEFAULT '0',
  `groups_id_tech` int unsigned NOT NULL DEFAULT '0',
  `width` int DEFAULT NULL,
  `height` int DEFAULT NULL,
  `depth` int DEFAULT NULL,
  `number_units` int DEFAULT '0',
  `is_template` tinyint(1) NOT NULL DEFAULT '0',
  `template_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `dcrooms_id` int unsigned NOT NULL DEFAULT '0',
  `room_orientation` int NOT NULL DEFAULT '0',
  `position` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bgcolor` varchar(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `max_power` int NOT NULL DEFAULT '0',
  `mesured_power` int NOT NULL DEFAULT '0',
  `max_weight` int 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 `rackmodels_id` (`rackmodels_id`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `racktypes_id` (`racktypes_id`),
  KEY `states_id` (`states_id`),
  KEY `users_id_tech` (`users_id_tech`),
  KEY `group_id_tech` (`groups_id_tech`),
  KEY `is_template` (`is_template`),
  KEY `is_deleted` (`is_deleted`),
  KEY `dcrooms_id` (`dcrooms_id`),
  KEY `date_creation` (`date_creation`),
  KEY `date_mod` (`date_mod`),
  KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `glpi_racks`
--

INSERT INTO `glpi_racks` VALUES (1,'GAIT-BUC','Gabinete cuenta con\r\n1 monitor compaq\r\n1 switch ubiquiti USD24-g2 24 puertos\r\n1 switch cisco catalyst 48 puertos\r\n1 NVR 32 CH',0,0,159,'n/a','GAIT-BUC',0,0,0,1,1117,71,55,3,1,42,0,NULL,0,0,0,NULL,'#1d2aed',0,0,0,'2023-10-18 14:10:28','2023-10-18 14:10:28');

--
-- Table structure for table `glpi_racktypes`
--

CREATE TABLE `glpi_racktypes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entities_id` int unsigned NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
