-- -- --------------------------------------------------------------------- -- -- GLPI - Gestionnaire Libre de Parc Informatique -- -- http://glpi-project.org -- -- @copyright 2015-2025 Teclib' and contributors. -- @copyright 2003-2014 by the INDEPNET Development Team. -- @licence https://www.gnu.org/licenses/gpl-3.0.html -- -- --------------------------------------------------------------------- -- -- LICENSE -- -- This file is part of GLPI. -- -- This program is free software: you can redistribute it and/or modify -- it under the terms of the GNU General Public License as published by -- the Free Software Foundation, either version 3 of the License, or -- (at your option) any later version. -- -- This program is distributed in the hope that it will be useful, -- but WITHOUT ANY WARRANTY; without even the implied warranty of -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the -- GNU General Public License for more details. -- -- You should have received a copy of the GNU General Public License -- along with this program. If not, see . -- -- --------------------------------------------------------------------- -- SET NAMES utf8; SET time_zone = '+00:00'; SET foreign_key_checks = 0; SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'; INSERT INTO `glpi_apiclients` (`id`, `entities_id`, `is_recursive`, `name`, `date_mod`, `is_active`, `ipv4_range_start`, `ipv4_range_end`, `ipv6`, `app_token`, `app_token_date`, `dolog_method`, `comment`) VALUES (1, 0, 1, 'full access from localhost', NULL, 1, 2130706433, 2130706433, '::1', NULL, NULL, 0, NULL); INSERT INTO `glpi_blacklists` (`id`, `type`, `name`, `value`, `comment`, `date_mod`, `date_creation`) VALUES (1, 1, 'empty IP', '', NULL, NULL, NULL), (2, 1, 'localhost', '127.0.0.1', NULL, NULL, NULL), (3, 1, 'zero IP', '0.0.0.0', NULL, NULL, NULL), (4, 2, 'empty MAC', '', NULL, NULL, NULL); INSERT INTO `glpi_calendars` (`id`, `name`, `entities_id`, `is_recursive`, `comment`, `date_mod`, `cache_duration`, `date_creation`) VALUES (1, 'Default', 0, 1, 'Default calendar', NULL, '[0,43200,43200,43200,43200,43200,0]', NULL); INSERT INTO `glpi_calendarsegments` (`id`, `calendars_id`, `entities_id`, `is_recursive`, `day`, `begin`, `end`) VALUES (1, 1, 0, 0, 1, '08:00:00', '20:00:00'), (2, 1, 0, 0, 2, '08:00:00', '20:00:00'), (3, 1, 0, 0, 3, '08:00:00', '20:00:00'), (4, 1, 0, 0, 4, '08:00:00', '20:00:00'), (5, 1, 0, 0, 5, '08:00:00', '20:00:00'); INSERT INTO `glpi_changetemplatemandatoryfields` (`id`, `changetemplates_id`, `num`) VALUES (1, 1, 21); INSERT INTO `glpi_changetemplates` (`id`, `name`, `entities_id`, `is_recursive`, `comment`) VALUES (1, 'Default', 0, 1, NULL); INSERT INTO `glpi_configs` (`id`, `context`, `name`, `value`) VALUES (1, 'core', 'version', '9.5.13'), (2, 'core', 'show_jobs_at_login', '0'), (3, 'core', 'cut', '250'), (4, 'core', 'list_limit', '15'), (5, 'core', 'list_limit_max', '50'), (6, 'core', 'url_maxlength', '30'), (7, 'core', 'event_loglevel', '5'), (8, 'core', 'notifications_mailing', '0'), (9, 'core', 'admin_email', 'admsys@localhost'), (10, 'core', 'admin_email_name', ''), (11, 'core', 'admin_reply', ''), (12, 'core', 'admin_reply_name', ''), (13, 'core', 'mailing_signature', 'SIGNATURE'), (14, 'core', 'use_anonymous_helpdesk', '0'), (15, 'core', 'use_anonymous_followups', '0'), (16, 'core', 'language', 'en_GB'), (17, 'core', 'priority_1', '#fff2f2'), (18, 'core', 'priority_2', '#ffe0e0'), (19, 'core', 'priority_3', '#ffcece'), (20, 'core', 'priority_4', '#ffbfbf'), (21, 'core', 'priority_5', '#ffadad'), (22, 'core', 'priority_6', '#ff5555'), (23, 'core', 'date_tax', '2005-12-31'), (24, 'core', 'cas_host', ''), (25, 'core', 'cas_port', '443'), (26, 'core', 'cas_uri', ''), (27, 'core', 'cas_logout', ''), (28, 'core', 'existing_auth_server_field_clean_domain', '0'), (29, 'core', 'planning_begin', '08:00:00'), (30, 'core', 'planning_end', '20:00:00'), (31, 'core', 'utf8_conv', '1'), (32, 'core', 'use_public_faq', '0'), (33, 'core', 'url_base', 'http://localhost/glpi/'), (34, 'core', 'show_link_in_mail', '0'), (35, 'core', 'text_login', ''), (36, 'core', 'founded_new_version', ''), (37, 'core', 'dropdown_max', '100'), (38, 'core', 'ajax_wildcard', '*'), (39, 'core', 'ajax_limit_count', '10'), (40, 'core', 'use_ajax_autocompletion', '1'), (41, 'core', 'is_users_auto_add', '1'), (42, 'core', 'date_format', '0'), (43, 'core', 'number_format', '0'), (44, 'core', 'csv_delimiter', ';'), (45, 'core', 'is_ids_visible', '0'), (46, 'core', 'smtp_mode', '0'), (47, 'core', 'smtp_host', ''), (48, 'core', 'smtp_port', '25'), (49, 'core', 'smtp_username', ''), (50, 'core', 'proxy_name', ''), (51, 'core', 'proxy_port', '8080'), (52, 'core', 'proxy_user', ''), (53, 'core', 'add_followup_on_update_ticket', '1'), (54, 'core', 'keep_tickets_on_delete', '0'), (55, 'core', 'time_step', '5'), (56, 'core', 'decimal_number', '2'), (57, 'core', 'helpdesk_doc_url', ''), (58, 'core', 'central_doc_url', ''), (59, 'core', 'documentcategories_id_forticket', '0'), (60, 'core', 'monitors_management_restrict', '2'), (61, 'core', 'phones_management_restrict', '2'), (62, 'core', 'peripherals_management_restrict', '2'), (63, 'core', 'printers_management_restrict', '2'), (64, 'core', 'use_log_in_files', '1'), (65, 'core', 'time_offset', '0'), (66, 'core', 'is_contact_autoupdate', '1'), (67, 'core', 'is_user_autoupdate', '1'), (68, 'core', 'is_group_autoupdate', '1'), (69, 'core', 'is_location_autoupdate', '1'), (70, 'core', 'state_autoupdate_mode', '0'), (71, 'core', 'is_contact_autoclean', '0'), (72, 'core', 'is_user_autoclean', '0'), (73, 'core', 'is_group_autoclean', '0'), (74, 'core', 'is_location_autoclean', '0'), (75, 'core', 'state_autoclean_mode', '0'), (76, 'core', 'use_flat_dropdowntree', '0'), (77, 'core', 'use_autoname_by_entity', '1'), (78, 'core', 'softwarecategories_id_ondelete', '1'), (79, 'core', 'x509_email_field', ''), (80, 'core', 'x509_cn_restrict', ''), (81, 'core', 'x509_o_restrict', ''), (82, 'core', 'x509_ou_restrict', ''), (83, 'core', 'default_mailcollector_filesize_max', '2097152'), (84, 'core', 'followup_private', '0'), (85, 'core', 'task_private', '0'), (86, 'core', 'default_software_helpdesk_visible', '1'), (87, 'core', 'names_format', '0'), (88, 'core', 'default_requesttypes_id', '1'), (89, 'core', 'use_noright_users_add', '1'), (90, 'core', 'cron_limit', '5'), (91, 'core', 'priority_matrix', '{\"1\":{\"1\":1,\"2\":1,\"3\":2,\"4\":2,\"5\":2},\"2\":{\"1\":1,\"2\":2,\"3\":2,\"4\":3,\"5\":3},\"3\":{\"1\":2,\"2\":2,\"3\":3,\"4\":4,\"5\":4},\"4\":{\"1\":2,\"2\":3,\"3\":4,\"4\":4,\"5\":5},\"5\":{\"1\":2,\"2\":3,\"3\":4,\"4\":5,\"5\":5}}'), (92, 'core', 'urgency_mask', '62'), (93, 'core', 'impact_mask', '62'), (94, 'core', 'user_deleted_ldap', '0'), (95, 'core', 'auto_create_infocoms', '0'), (96, 'core', 'use_slave_for_search', '0'), (97, 'core', 'proxy_passwd', ''), (98, 'core', 'smtp_passwd', ''), (99, 'core', 'transfers_id_auto', '0'), (100, 'core', 'show_count_on_tabs', '1'), (101, 'core', 'refresh_views', '0'), (102, 'core', 'set_default_tech', '1'), (103, 'core', 'allow_search_view', '2'), (104, 'core', 'allow_search_all', '0'), (105, 'core', 'allow_search_global', '1'), (106, 'core', 'display_count_on_home', '5'), (107, 'core', 'use_password_security', '0'), (108, 'core', 'password_min_length', '8'), (109, 'core', 'password_need_number', '1'), (110, 'core', 'password_need_letter', '1'), (111, 'core', 'password_need_caps', '1'), (112, 'core', 'password_need_symbol', '1'), (113, 'core', 'use_check_pref', '0'), (114, 'core', 'notification_to_myself', '1'), (115, 'core', 'duedateok_color', '#06ff00'), (116, 'core', 'duedatewarning_color', '#ffb800'), (117, 'core', 'duedatecritical_color', '#ff0000'), (118, 'core', 'duedatewarning_less', '20'), (119, 'core', 'duedatecritical_less', '5'), (120, 'core', 'duedatewarning_unit', '%'), (121, 'core', 'duedatecritical_unit', '%'), (122, 'core', 'realname_ssofield', ''), (123, 'core', 'firstname_ssofield', ''), (124, 'core', 'email1_ssofield', ''), (125, 'core', 'email2_ssofield', ''), (126, 'core', 'email3_ssofield', ''), (127, 'core', 'email4_ssofield', ''), (128, 'core', 'phone_ssofield', ''), (129, 'core', 'phone2_ssofield', ''), (130, 'core', 'mobile_ssofield', ''), (131, 'core', 'comment_ssofield', ''), (132, 'core', 'title_ssofield', ''), (133, 'core', 'category_ssofield', ''), (134, 'core', 'language_ssofield', ''), (135, 'core', 'entity_ssofield', ''), (136, 'core', 'registration_number_ssofield', ''), (137, 'core', 'ssovariables_id', '0'), (138, 'core', 'ssologout_url', ''), (139, 'core', 'translate_kb', '0'), (140, 'core', 'translate_dropdowns', '0'), (141, 'core', 'translate_reminders', '0'), (142, 'core', 'pdffont', 'helvetica'), (143, 'core', 'keep_devices_when_purging_item', '0'), (144, 'core', 'maintenance_mode', '0'), (145, 'core', 'maintenance_text', ''), (146, 'core', 'attach_ticket_documents_to_mail', '0'), (147, 'core', 'backcreated', '0'), (148, 'core', 'task_state', '1'), (149, 'core', 'layout', 'lefttab'), (150, 'core', 'palette', 'auror'), (151, 'core', 'lock_use_lock_item', '0'), (152, 'core', 'lock_autolock_mode', '1'), (153, 'core', 'lock_directunlock_notification', '0'), (154, 'core', 'lock_item_list', '[]'), (155, 'core', 'lock_lockprofile_id', '8'), (156, 'core', 'set_default_requester', '1'), (157, 'core', 'highcontrast_css', '0'), (158, 'core', 'smtp_check_certificate', '1'), (159, 'core', 'enable_api', '0'), (160, 'core', 'enable_api_login_credentials', '0'), (161, 'core', 'enable_api_login_external_token', '1'), (162, 'core', 'url_base_api', 'http://localhost/glpi/api'), (163, 'core', 'login_remember_time', '604800'), (164, 'core', 'login_remember_default', '1'), (165, 'core', 'use_notifications', '0'), (166, 'core', 'notifications_ajax', '0'), (167, 'core', 'notifications_ajax_check_interval', '5'), (168, 'core', 'notifications_ajax_sound', NULL), (169, 'core', 'notifications_ajax_icon_url', '/pics/glpi.png'), (170, 'core', 'dbversion', '9.5.7'), (171, 'core', 'smtp_max_retries', '5'), (172, 'core', 'smtp_sender', NULL), (173, 'core', 'from_email', NULL), (174, 'core', 'from_email_name', NULL), (175, 'core', 'instance_uuid', NULL), (176, 'core', 'registration_uuid', NULL), (177, 'core', 'smtp_retry_time', '5'), (178, 'core', 'purge_addrelation', '0'), (179, 'core', 'purge_deleterelation', '0'), (180, 'core', 'purge_createitem', '0'), (181, 'core', 'purge_deleteitem', '0'), (182, 'core', 'purge_restoreitem', '0'), (183, 'core', 'purge_updateitem', '0'), (184, 'core', 'purge_item_software_install', '0'), (185, 'core', 'purge_software_item_install', '0'), (186, 'core', 'purge_software_version_install', '0'), (187, 'core', 'purge_infocom_creation', '0'), (188, 'core', 'purge_profile_user', '0'), (189, 'core', 'purge_group_user', '0'), (190, 'core', 'purge_adddevice', '0'), (191, 'core', 'purge_updatedevice', '0'), (192, 'core', 'purge_deletedevice', '0'), (193, 'core', 'purge_connectdevice', '0'), (194, 'core', 'purge_disconnectdevice', '0'), (195, 'core', 'purge_userdeletedfromldap', '0'), (196, 'core', 'purge_comments', '0'), (197, 'core', 'purge_datemod', '0'), (198, 'core', 'purge_all', '0'), (199, 'core', 'purge_user_auth_changes', '0'), (200, 'core', 'purge_plugins', '0'), (201, 'core', 'display_login_source', '1'), (202, 'core', 'devices_in_menu', '[\"Item_DeviceSimcard\"]'), (203, 'core', 'password_expiration_delay', '-1'), (204, 'core', 'password_expiration_notice', '-1'), (205, 'core', 'password_expiration_lock_delay', '-1'), (206, 'core', 'default_dashboard_central', 'central'), (207, 'core', 'default_dashboard_assets', 'assets'), (208, 'core', 'default_dashboard_helpdesk', 'assistance'), (209, 'core', 'default_dashboard_mini_ticket', 'mini_tickets'), (210, 'core', 'admin_email_noreply', ''), (211, 'core', 'admin_email_noreply_name', ''), (212, 'core', 'impact_enabled_itemtypes', '[\"Appliance\",\"Cluster\",\"Computer\",\"Datacenter\",\"DCRoom\",\"Domain\",\"Enclosure\",\"Monitor\",\"NetworkEquipment\",\"PDU\",\"Peripheral\",\"Phone\",\"Printer\",\"Rack\",\"Software\"]'), (213, 'core', 'use_timezones', '1'); INSERT INTO `glpi_crontasks` (`id`, `itemtype`, `name`, `frequency`, `param`, `state`, `mode`, `allowmode`, `hourmin`, `hourmax`, `logs_lifetime`, `lastrun`, `lastcode`, `comment`, `date_mod`, `date_creation`) VALUES (2, 'CartridgeItem', 'cartridge', 86400, 10, 0, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (3, 'ConsumableItem', 'consumable', 86400, 10, 0, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (4, 'SoftwareLicense', 'software', 86400, NULL, 0, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (5, 'Contract', 'contract', 86400, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (6, 'Infocom', 'infocom', 86400, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (7, 'CronTask', 'logs', 86400, 30, 0, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (9, 'MailCollector', 'mailgate', 600, 10, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (10, 'DBconnection', 'checkdbreplicate', 300, NULL, 0, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (11, 'CronTask', 'checkupdate', 604800, NULL, 0, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (12, 'CronTask', 'session', 86400, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (13, 'CronTask', 'graph', 3600, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (14, 'ReservationItem', 'reservation', 3600, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (15, 'Ticket', 'closeticket', 43200, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (16, 'Ticket', 'alertnotclosed', 43200, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (17, 'SlaLevel_Ticket', 'slaticket', 300, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (18, 'Ticket', 'createinquest', 86400, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (19, 'CronTask', 'watcher', 86400, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (20, 'TicketRecurrent', 'ticketrecurrent', 3600, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (21, 'PlanningRecall', 'planningrecall', 300, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (22, 'QueuedNotification', 'queuednotification', 60, 50, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (23, 'QueuedNotification', 'queuednotificationclean', 86400, 30, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (24, 'CronTask', 'temp', 3600, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (25, 'MailCollector', 'mailgateerror', 86400, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (26, 'CronTask', 'circularlogs', 86400, 4, 0, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (27, 'ObjectLock', 'unlockobject', 86400, 4, 0, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (28, 'SavedSearch', 'countAll', 604800, NULL, 0, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (29, 'SavedSearch_Alert', 'savedsearchesalerts', 86400, NULL, 0, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (30, 'Telemetry', 'telemetry', 2592000, NULL, 0, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (31, 'Certificate', 'certificate', 86400, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (32, 'OlaLevel_Ticket', 'olaticket', 300, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (33, 'PurgeLogs', 'PurgeLogs', 604800, 24, 1, 2, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (34, 'Ticket', 'purgeticket', 604800, NULL, 0, 2, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (35, 'Document', 'cleanorphans', 604800, NULL, 0, 2, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (36, 'User', 'passwordexpiration', 86400, 100, 0, 2, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (37, 'Glpi\\Marketplace\\Controller', 'checkAllUpdates', 86400, NULL, 1, 2, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL), (38, 'Domain', 'DomainsAlert', 86400, NULL, 1, 2, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL); INSERT INTO `glpi_dashboards_dashboards` (`id`, `key`, `name`, `context`) VALUES (1, 'central', 'Central', 'core'), (2, 'assets', 'Assets', 'core'), (3, 'assistance', 'Assistance', 'core'), (4, 'mini_tickets', 'Mini tickets dashboard', 'mini_core'); INSERT INTO `glpi_dashboards_items` (`id`, `dashboards_dashboards_id`, `gridstack_id`, `card_id`, `x`, `y`, `width`, `height`, `card_options`) VALUES (1, 1, 'bn_count_Computer_4a315743-151c-40cb-a20b-762250668dac', 'bn_count_Computer', 3, 0, 3, 2, '{\"color\":\"#e69393\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (2, 1, 'bn_count_Software_0690f524-e826-47a9-b50a-906451196b83', 'bn_count_Software', 0, 0, 3, 2, '{\"color\":\"#aaddac\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (3, 1, 'bn_count_Rack_c6502e0a-5991-46b4-a771-7f355137306b', 'bn_count_Rack', 6, 2, 3, 2, '{\"color\":\"#0e87a0\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (4, 1, 'bn_count_SoftwareLicense_e755fd06-283e-4479-ba35-2d548f8f8a90', 'bn_count_SoftwareLicense', 0, 2, 3, 2, '{\"color\":\"#27ab3c\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (5, 1, 'bn_count_Monitor_7059b94c-583c-4ba7-b100-d40461165318', 'bn_count_Monitor', 3, 2, 3, 2, '{\"color\":\"#b52d30\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (6, 1, 'bn_count_Ticket_a74c0903-3387-4a07-9111-b0938af8f1e7', 'bn_count_Ticket', 14, 7, 3, 2, '{\"color\":\"#ffdc64\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (7, 1, 'bn_count_Problem_c1cf5cfb-f626-472e-82a1-49c3e200e746', 'bn_count_Problem', 20, 7, 3, 2, '{\"color\":\"#f08d7b\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (8, 1, 'count_Computer_Manufacturer_6129c451-42b5-489d-b693-c362adf32d49', 'count_Computer_Manufacturer', 0, 4, 5, 4, '{\"color\":\"#f8faf9\",\"widgettype\":\"donut\",\"use_gradient\":\"1\",\"limit\":\"5\"}'), (9, 1, 'top_ticket_user_requester_c74f52a8-046a-4077-b1a6-c9f840d34b82', 'top_ticket_user_requester', 14, 9, 6, 5, '{\"color\":\"#f9fafb\",\"widgettype\":\"hbar\",\"use_gradient\":\"1\",\"limit\":\"5\"}'), (10, 1, 'bn_count_tickets_late_04c47208-d7e5-4aca-9566-d46e68c45c67', 'bn_count_tickets_late', 17, 7, 3, 2, '{\"color\":\"#f8911f\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (11, 1, 'ticket_status_2e4e968b-d4e6-4e33-9ce9-a1aaff53dfde', 'ticket_status', 14, 0, 12, 7, '{\"color\":\"#fafafa\",\"widgettype\":\"stackedbars\",\"use_gradient\":\"0\",\"limit\":\"12\"}'), (12, 1, 'top_ticket_ITILCategory_37736ba9-d429-4cb3-9058-ef4d111d9269', 'top_ticket_ITILCategory', 20, 9, 6, 5, '{\"color\":\"#fbf9f9\",\"widgettype\":\"hbar\",\"use_gradient\":\"1\",\"limit\":\"5\"}'), (13, 1, 'bn_count_Printer_517684b0-b064-49dd-943e-fcb6f915e453', 'bn_count_Printer', 9, 2, 3, 2, '{\"color\":\"#365a8f\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (14, 1, 'bn_count_Phone_f70c489f-02c1-46e5-978b-94a95b5038ee', 'bn_count_Phone', 9, 0, 3, 2, '{\"color\":\"#d5e1ec\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (15, 1, 'bn_count_Change_ab950dbd-cd25-466d-8dff-7dcaca386564', 'bn_count_Change', 23, 7, 3, 2, '{\"color\":\"#cae3c4\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (16, 1, 'bn_count_Group_b84a93f2-a26c-49d7-82a4-5446697cc5b0', 'bn_count_Group', 4, 8, 4, 2, '{\"color\":\"#e0e0e0\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (17, 1, 'bn_count_Profile_770b35e8-68e9-4b4f-9e09-5a11058f069f', 'bn_count_Profile', 4, 10, 4, 2, '{\"color\":\"#e0e0e0\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (18, 1, 'bn_count_Supplier_36ff9011-e4cf-4d89-b9ab-346b9857d734', 'bn_count_Supplier', 8, 8, 3, 2, '{\"color\":\"#c9c9c9\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (19, 1, 'bn_count_KnowbaseItem_a3785a56-bed4-4a30-8387-f251f5365b3b', 'bn_count_KnowbaseItem', 8, 10, 3, 2, '{\"color\":\"#c9c9c9\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (20, 1, 'bn_count_Entity_9b82951a-ba52-45cc-a2d3-1d238ec37adf', 'bn_count_Entity', 0, 10, 4, 2, '{\"color\":\"#f9f9f9\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (21, 1, 'bn_count_Document_7dc7f4b8-61ff-4147-b994-5541bddd7b66', 'bn_count_Document', 11, 8, 3, 2, '{\"color\":\"#b4b4b4\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (22, 1, 'bn_count_Project_4d412ee2-8b79-469b-995f-4c0a05ab849d', 'bn_count_Project', 11, 10, 3, 2, '{\"color\":\"#b3b3b3\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (23, 1, 'bn_count_NetworkEquipment_c537e334-d584-43bc-b6de-b4a939143e89', 'bn_count_NetworkEquipment', 6, 0, 3, 2, '{\"color\":\"#bfe7ea\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (24, 1, 'bn_count_User_ac0cbe52-3593-43c1-8ecc-0eb115de494d', 'bn_count_User', 0, 8, 4, 2, '{\"color\":\"#fafafa\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (25, 1, 'count_Monitor_MonitorModel_5a476ff9-116e-4270-858b-c003c20841a9', 'count_Monitor_MonitorModel', 5, 4, 5, 4, '{\"color\":\"#f5fafa\",\"widgettype\":\"donut\",\"use_gradient\":\"1\",\"limit\":\"5\"}'), (26, 1, 'count_NetworkEquipment_State_81f2ae35-b366-4065-ac26-02ea4e3704a6', 'count_NetworkEquipment_State', 10, 4, 4, 4, '{\"color\":\"#f5f3ef\",\"widgettype\":\"donut\",\"use_gradient\":\"1\",\"limit\":\"5\"}'), (27, 2, 'bn_count_Computer_34cfbaf9-a471-4852-b48c-0dadea7644de', 'bn_count_Computer', 0, 0, 4, 3, '{\"color\":\"#f3d0d0\",\"widgettype\":\"bigNumber\"}'), (28, 2, 'bn_count_Software_60091467-2137-49f4-8834-f6602a482079', 'bn_count_Software', 4, 0, 4, 3, '{\"color\":\"#d1f1a8\",\"widgettype\":\"bigNumber\"}'), (29, 2, 'bn_count_Printer_c9a385d4-76a3-4971-ad0e-1470efeafacc', 'bn_count_Printer', 8, 3, 4, 3, '{\"color\":\"#5da8d6\",\"widgettype\":\"bigNumber\"}'), (30, 2, 'bn_count_PDU_60053eb6-8dda-4416-9a4b-afd51889bd09', 'bn_count_PDU', 12, 3, 4, 3, '{\"color\":\"#ffb62f\",\"widgettype\":\"bigNumber\"}'), (31, 2, 'bn_count_Rack_0fdc196f-20d2-4f63-9ddb-b75c165cc664', 'bn_count_Rack', 12, 0, 4, 3, '{\"color\":\"#f7d79a\",\"widgettype\":\"bigNumber\"}'), (32, 2, 'bn_count_Phone_c31fde2d-510a-4482-b17d-2f65b61eae08', 'bn_count_Phone', 16, 3, 4, 3, '{\"color\":\"#a0cec2\",\"widgettype\":\"bigNumber\"}'), (33, 2, 'bn_count_Enclosure_c21ce30a-58c3-456a-81ec-3c5f01527a8f', 'bn_count_Enclosure', 16, 0, 4, 3, '{\"color\":\"#d7e8e4\",\"widgettype\":\"bigNumber\"}'), (34, 2, 'bn_count_NetworkEquipment_76f1e239-777b-4552-b053-ae5c64190347', 'bn_count_NetworkEquipment', 8, 0, 4, 3, '{\"color\":\"#c8dae4\",\"widgettype\":\"bigNumber\"}'), (35, 2, 'bn_count_SoftwareLicense_576e58fe-a386-480f-b405-1c2315b8ab47', 'bn_count_SoftwareLicense', 4, 3, 4, 3, '{\"color\":\"#9bc06b\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (36, 2, 'bn_count_Monitor_890e16d3-b121-48c6-9713-d9c239d9a970', 'bn_count_Monitor', 0, 3, 4, 3, '{\"color\":\"#dc6f6f\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (37, 2, 'count_Computer_Manufacturer_986e92e8-32e8-4a6f-806f-6f5383acbb3f', 'count_Computer_Manufacturer', 4, 6, 4, 4, '{\"color\":\"#f3f5f1\",\"widgettype\":\"hbar\",\"use_gradient\":\"1\",\"limit\":\"5\"}'), (38, 2, 'count_Computer_State_290c5920-9eab-4db8-8753-46108e60f1d8', 'count_Computer_State', 0, 6, 4, 4, '{\"color\":\"#fbf7f7\",\"widgettype\":\"donut\",\"use_gradient\":\"1\",\"limit\":\"5\"}'), (39, 2, 'count_Computer_ComputerType_c58f9c7e-22d5-478b-8226-d2a752bcbb09', 'count_Computer_ComputerType', 8, 6, 4, 4, '{\"color\":\"#f5f9fa\",\"widgettype\":\"donut\",\"use_gradient\":\"1\",\"limit\":\"5\"}'), (40, 2, 'count_NetworkEquipment_Manufacturer_8132b21c-6f7f-4dc1-af54-bea794cb96e9', 'count_NetworkEquipment_Manufacturer', 12, 6, 4, 4, '{\"color\":\"#fcf8ed\",\"widgettype\":\"hbar\",\"use_gradient\":\"0\",\"limit\":\"5\"}'), (41, 2, 'count_Monitor_Manufacturer_43b0c16b-af82-418e-aac1-f32b39705c0d', 'count_Monitor_Manufacturer', 16, 6, 4, 4, '{\"color\":\"#f9fbfb\",\"widgettype\":\"donut\",\"use_gradient\":\"1\",\"limit\":\"5\"}'), (42, 3, 'bn_count_Ticket_344e761b-f7e8-4617-8c90-154b266b4d67', 'bn_count_Ticket', 0, 0, 3, 2, '{\"color\":\"#ffdc64\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (43, 3, 'bn_count_Problem_bdb4002b-a674-4493-820f-af85bed44d2a', 'bn_count_Problem', 0, 4, 3, 2, '{\"color\":\"#f0967b\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (44, 3, 'bn_count_Change_b9b87513-4f40-41e6-8621-f51f9a30fb19', 'bn_count_Change', 0, 6, 3, 2, '{\"color\":\"#cae3c4\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (45, 3, 'bn_count_tickets_late_1e9ae481-21b4-4463-a830-dec1b68ec5e7', 'bn_count_tickets_late', 0, 2, 3, 2, '{\"color\":\"#f8911f\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (46, 3, 'bn_count_tickets_incoming_336a36d9-67fe-4475-880e-447bd766b8fe', 'bn_count_tickets_incoming', 3, 6, 3, 2, '{\"color\":\"#a0e19d\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (47, 3, 'bn_count_tickets_closed_e004bab5-f2b6-4060-a401-a2a8b9885245', 'bn_count_tickets_closed', 9, 8, 3, 2, '{\"color\":\"#515151\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (48, 3, 'bn_count_tickets_assigned_7455c855-6df8-4514-a3d9-8b0fce52bd63', 'bn_count_tickets_assigned', 6, 6, 3, 2, '{\"color\":\"#eaf5f7\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (49, 3, 'bn_count_tickets_solved_5e9759b3-ee7e-4a14-b68f-1ac024ef55ee', 'bn_count_tickets_solved', 9, 6, 3, 2, '{\"color\":\"#d8d8d8\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (50, 3, 'bn_count_tickets_waiting_102b2c2a-6ac6-4d73-ba47-8b09382fe00e', 'bn_count_tickets_waiting', 3, 8, 3, 2, '{\"color\":\"#ffcb7d\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (51, 3, 'bn_count_TicketRecurrent_13f79539-61f6-45f7-8dde-045706e652f2', 'bn_count_TicketRecurrent', 0, 8, 3, 2, '{\"color\":\"#fafafa\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (52, 3, 'bn_count_tickets_planned_267bf627-9d5e-4b6c-b53d-b8623d793ccf', 'bn_count_tickets_planned', 6, 8, 3, 2, '{\"color\":\"#6298d5\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (53, 3, 'top_ticket_ITILCategory_0cba0c84-6c62-4cd8-8564-18614498d8e4', 'top_ticket_ITILCategory', 12, 6, 4, 4, '{\"color\":\"#f1f5ef\",\"widgettype\":\"donut\",\"use_gradient\":\"1\",\"limit\":\"7\"}'), (54, 3, 'top_ticket_RequestType_b9e43f34-8e94-4a6e-9023-c5d1e2ce7859', 'top_ticket_RequestType', 16, 6, 4, 4, '{\"color\":\"#f9fafb\",\"widgettype\":\"hbar\",\"use_gradient\":\"1\",\"limit\":\"4\"}'), (55, 3, 'top_ticket_Entity_a8e65812-519c-488e-9892-9adbe22fbd5c', 'top_ticket_Entity', 20, 6, 4, 4, '{\"color\":\"#f7f1f0\",\"widgettype\":\"donut\",\"use_gradient\":\"1\",\"limit\":\"7\"}'), (56, 3, 'ticket_evolution_76fd4926-ee5e-48db-b6d6-e2947c190c5e', 'ticket_evolution', 3, 0, 12, 6, '{\"color\":\"#f3f7f8\",\"widgettype\":\"areas\",\"use_gradient\":\"0\",\"limit\":\"12\"}'), (57, 3, 'ticket_status_5b256a35-b36b-4db5-ba11-ea7c125f126e', 'ticket_status', 15, 0, 11, 6, '{\"color\":\"#f7f3f2\",\"widgettype\":\"stackedbars\",\"use_gradient\":\"0\",\"limit\":\"12\"}'), (58, 4, 'bn_count_tickets_closed_ccf7246b-645a-40d2-8206-fa33c769e3f5', 'bn_count_tickets_closed', 24, 0, 4, 2, '{\"color\":\"#fafafa\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (59, 4, 'bn_count_Ticket_d5bf3576-5033-40fb-bbdb-292294a7698e', 'bn_count_Ticket', 0, 0, 4, 2, '{\"color\":\"#ffd957\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (60, 4, 'bn_count_tickets_incoming_055e813c-b0ce-4687-91ef-559249e8ddd8', 'bn_count_tickets_incoming', 4, 0, 4, 2, '{\"color\":\"#6fd169\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (61, 4, 'bn_count_tickets_waiting_793c665b-b620-4b3a-a5a8-cf502defc008', 'bn_count_tickets_waiting', 8, 0, 4, 2, '{\"color\":\"#ffcb7d\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (62, 4, 'bn_count_tickets_assigned_d3d2f697-52b4-435e-9030-a760dd649085', 'bn_count_tickets_assigned', 12, 0, 4, 2, '{\"color\":\"#eaf4f7\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (63, 4, 'bn_count_tickets_planned_0c7f3569-c23b-4ee3-8e85-279229b23e70', 'bn_count_tickets_planned', 16, 0, 4, 2, '{\"color\":\"#6298d5\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'), (64, 4, 'bn_count_tickets_solved_ae2406cf-e8e8-410b-b355-46e3f5705ee8', 'bn_count_tickets_solved', 20, 0, 4, 2, '{\"color\":\"#d7d7d7\",\"widgettype\":\"bigNumber\",\"use_gradient\":\"0\",\"limit\":\"7\"}'); INSERT INTO `glpi_devicefirmwaretypes` (`id`, `name`, `comment`, `date_mod`, `date_creation`) VALUES (1, 'BIOS', NULL, NULL, NULL), (2, 'UEFI', NULL, NULL, NULL), (3, 'Firmware', NULL, NULL, NULL); INSERT INTO `glpi_devicememorytypes` (`id`, `name`, `comment`, `date_mod`, `date_creation`) VALUES (1, 'EDO', NULL, NULL, NULL), (2, 'DDR', NULL, NULL, NULL), (3, 'SDRAM', NULL, NULL, NULL), (4, 'SDRAM-2', NULL, NULL, NULL); INSERT INTO `glpi_devicesimcardtypes` (`id`, `name`, `comment`, `date_mod`, `date_creation`) VALUES (1, 'Full SIM', NULL, NULL, NULL), (2, 'Mini SIM', NULL, NULL, NULL), (3, 'Micro SIM', NULL, NULL, NULL), (4, 'Nano SIM', NULL, NULL, NULL); INSERT INTO `glpi_displaypreferences` (`id`, `itemtype`, `num`, `rank`, `users_id`) VALUES (1, 'Computer', 4, 4, 0), (2, 'Computer', 45, 6, 0), (3, 'Computer', 40, 5, 0), (4, 'Computer', 5, 3, 0), (5, 'Computer', 23, 2, 0), (6, 'DocumentType', 3, 1, 0), (7, 'Monitor', 31, 1, 0), (8, 'Monitor', 23, 2, 0), (9, 'Monitor', 3, 3, 0), (10, 'Monitor', 4, 4, 0), (11, 'Printer', 31, 1, 0), (12, 'NetworkEquipment', 31, 1, 0), (13, 'NetworkEquipment', 23, 2, 0), (14, 'Printer', 23, 2, 0), (15, 'Printer', 3, 3, 0), (16, 'Software', 4, 3, 0), (17, 'Software', 5, 2, 0), (18, 'Software', 23, 1, 0), (19, 'CartridgeItem', 4, 2, 0), (20, 'CartridgeItem', 34, 1, 0), (21, 'Peripheral', 3, 3, 0), (22, 'Peripheral', 23, 2, 0), (23, 'Peripheral', 31, 1, 0), (24, 'Computer', 31, 1, 0), (25, 'Computer', 3, 7, 0), (26, 'Computer', 19, 8, 0), (27, 'Computer', 17, 9, 0), (28, 'NetworkEquipment', 3, 3, 0), (29, 'NetworkEquipment', 4, 4, 0), (30, 'NetworkEquipment', 11, 6, 0), (31, 'NetworkEquipment', 19, 7, 0), (32, 'Printer', 4, 4, 0), (33, 'Printer', 19, 6, 0), (34, 'Monitor', 19, 6, 0), (35, 'Monitor', 7, 7, 0), (36, 'Peripheral', 4, 4, 0), (37, 'Peripheral', 19, 6, 0), (38, 'Peripheral', 7, 7, 0), (39, 'Contact', 3, 1, 0), (40, 'Contact', 4, 2, 0), (41, 'Contact', 5, 3, 0), (42, 'Contact', 6, 4, 0), (43, 'Contact', 9, 5, 0), (44, 'Supplier', 9, 1, 0), (45, 'Supplier', 3, 2, 0), (46, 'Supplier', 4, 3, 0), (47, 'Supplier', 5, 4, 0), (48, 'Supplier', 10, 5, 0), (49, 'Supplier', 6, 6, 0), (50, 'Contract', 4, 1, 0), (51, 'Contract', 3, 2, 0), (52, 'Contract', 5, 3, 0), (53, 'Contract', 6, 4, 0), (54, 'Contract', 7, 5, 0), (55, 'Contract', 11, 6, 0), (56, 'CartridgeItem', 23, 3, 0), (57, 'CartridgeItem', 3, 4, 0), (58, 'DocumentType', 6, 2, 0), (59, 'DocumentType', 4, 3, 0), (60, 'DocumentType', 5, 4, 0), (61, 'Document', 3, 1, 0), (62, 'Document', 4, 2, 0), (63, 'Document', 7, 3, 0), (64, 'Document', 5, 4, 0), (65, 'Document', 16, 5, 0), (66, 'User', 34, 1, 0), (67, 'User', 5, 3, 0), (68, 'User', 6, 4, 0), (69, 'User', 3, 5, 0), (70, 'ConsumableItem', 34, 1, 0), (71, 'ConsumableItem', 4, 2, 0), (72, 'ConsumableItem', 23, 3, 0), (73, 'ConsumableItem', 3, 4, 0), (74, 'NetworkEquipment', 40, 5, 0), (75, 'Printer', 40, 5, 0), (76, 'Monitor', 40, 5, 0), (77, 'Peripheral', 40, 5, 0), (78, 'User', 8, 6, 0), (79, 'Phone', 31, 1, 0), (80, 'Phone', 23, 2, 0), (81, 'Phone', 3, 3, 0), (82, 'Phone', 4, 4, 0), (83, 'Phone', 40, 5, 0), (84, 'Phone', 19, 6, 0), (85, 'Phone', 7, 7, 0), (86, 'Group', 16, 1, 0), (87, 'AllAssets', 31, 1, 0), (88, 'ReservationItem', 4, 1, 0), (89, 'ReservationItem', 3, 2, 0), (90, 'Budget', 3, 2, 0), (91, 'Software', 72, 4, 0), (92, 'Software', 163, 5, 0), (93, 'Budget', 5, 1, 0), (94, 'Budget', 4, 3, 0), (95, 'Budget', 19, 4, 0), (96, 'CronTask', 8, 1, 0), (97, 'CronTask', 3, 2, 0), (98, 'CronTask', 4, 3, 0), (99, 'CronTask', 7, 4, 0), (100, 'RequestType', 14, 1, 0), (101, 'RequestType', 15, 2, 0), (102, 'NotificationTemplate', 4, 1, 0), (103, 'NotificationTemplate', 16, 2, 0), (104, 'Notification', 5, 1, 0), (105, 'Notification', 6, 2, 0), (106, 'Notification', 2, 3, 0), (107, 'Notification', 4, 4, 0), (108, 'Notification', 80, 5, 0), (109, 'Notification', 86, 6, 0), (110, 'MailCollector', 2, 1, 0), (111, 'MailCollector', 19, 2, 0), (112, 'AuthLDAP', 3, 1, 0), (113, 'AuthLDAP', 19, 2, 0), (114, 'AuthMail', 3, 1, 0), (115, 'AuthMail', 19, 2, 0), (116, 'IPNetwork', 18, 1, 0), (117, 'WifiNetwork', 10, 1, 0), (118, 'Profile', 2, 1, 0), (119, 'Profile', 3, 2, 0), (120, 'Profile', 19, 3, 0), (121, 'Transfer', 19, 1, 0), (122, 'TicketValidation', 3, 1, 0), (123, 'TicketValidation', 2, 2, 0), (124, 'TicketValidation', 8, 3, 0), (125, 'TicketValidation', 4, 4, 0), (126, 'TicketValidation', 9, 5, 0), (127, 'TicketValidation', 7, 6, 0), (128, 'NotImportedEmail', 2, 1, 0), (129, 'NotImportedEmail', 5, 2, 0), (130, 'NotImportedEmail', 4, 3, 0), (131, 'NotImportedEmail', 6, 4, 0), (132, 'NotImportedEmail', 16, 5, 0), (133, 'NotImportedEmail', 19, 6, 0), (134, 'RuleRightParameter', 11, 1, 0), (135, 'Ticket', 12, 1, 0), (136, 'Ticket', 19, 2, 0), (137, 'Ticket', 15, 3, 0), (138, 'Ticket', 3, 4, 0), (139, 'Ticket', 4, 5, 0), (140, 'Ticket', 5, 6, 0), (141, 'Ticket', 7, 7, 0), (142, 'Calendar', 19, 1, 0), (143, 'Holiday', 11, 1, 0), (144, 'Holiday', 12, 2, 0), (145, 'Holiday', 13, 3, 0), (146, 'SLA', 4, 1, 0), (147, 'Ticket', 18, 8, 0), (148, 'AuthLDAP', 30, 3, 0), (149, 'AuthMail', 6, 3, 0), (150, 'FQDN', 11, 1, 0), (151, 'FieldUnicity', 1, 1, 0), (152, 'FieldUnicity', 80, 2, 0), (153, 'FieldUnicity', 4, 3, 0), (154, 'FieldUnicity', 3, 4, 0), (155, 'FieldUnicity', 86, 5, 0), (156, 'FieldUnicity', 30, 6, 0), (157, 'Problem', 21, 1, 0), (158, 'Problem', 12, 2, 0), (159, 'Problem', 19, 3, 0), (160, 'Problem', 15, 4, 0), (161, 'Problem', 3, 5, 0), (162, 'Problem', 7, 6, 0), (163, 'Problem', 18, 7, 0), (164, 'Vlan', 11, 1, 0), (165, 'TicketRecurrent', 11, 1, 0), (166, 'TicketRecurrent', 12, 2, 0), (167, 'TicketRecurrent', 13, 3, 0), (168, 'TicketRecurrent', 15, 4, 0), (169, 'TicketRecurrent', 14, 5, 0), (170, 'Reminder', 2, 1, 0), (171, 'Reminder', 3, 2, 0), (172, 'Reminder', 4, 3, 0), (173, 'Reminder', 5, 4, 0), (174, 'Reminder', 6, 5, 0), (175, 'Reminder', 7, 6, 0), (176, 'IPNetwork', 10, 2, 0), (177, 'IPNetwork', 11, 3, 0), (178, 'IPNetwork', 12, 4, 0), (179, 'IPNetwork', 17, 5, 0), (180, 'NetworkName', 12, 1, 0), (181, 'NetworkName', 13, 2, 0), (182, 'RSSFeed', 2, 1, 0), (183, 'RSSFeed', 4, 2, 0), (184, 'RSSFeed', 5, 3, 0), (185, 'RSSFeed', 19, 4, 0), (186, 'RSSFeed', 6, 5, 0), (187, 'RSSFeed', 7, 6, 0), (188, 'Blacklist', 12, 1, 0), (189, 'Blacklist', 11, 2, 0), (190, 'ReservationItem', 5, 3, 0), (191, 'QueueMail', 16, 1, 0), (192, 'QueueMail', 7, 2, 0), (193, 'QueueMail', 20, 3, 0), (194, 'QueueMail', 21, 4, 0), (195, 'QueueMail', 22, 5, 0), (196, 'QueueMail', 15, 6, 0), (197, 'Change', 12, 1, 0), (198, 'Change', 19, 2, 0), (199, 'Change', 15, 3, 0), (200, 'Change', 7, 4, 0), (201, 'Change', 18, 5, 0), (202, 'Project', 3, 1, 0), (203, 'Project', 4, 2, 0), (204, 'Project', 12, 3, 0), (205, 'Project', 5, 4, 0), (206, 'Project', 15, 5, 0), (207, 'Project', 21, 6, 0), (208, 'ProjectState', 12, 1, 0), (209, 'ProjectState', 11, 2, 0), (210, 'ProjectTask', 2, 1, 0), (211, 'ProjectTask', 12, 2, 0), (212, 'ProjectTask', 14, 3, 0), (213, 'ProjectTask', 5, 4, 0), (214, 'ProjectTask', 7, 5, 0), (215, 'ProjectTask', 8, 6, 0), (216, 'ProjectTask', 13, 7, 0), (217, 'CartridgeItem', 9, 5, 0), (218, 'ConsumableItem', 9, 5, 0), (219, 'ReservationItem', 9, 4, 0), (220, 'SoftwareLicense', 1, 1, 0), (221, 'SoftwareLicense', 3, 2, 0), (222, 'SoftwareLicense', 10, 3, 0), (223, 'SoftwareLicense', 162, 4, 0), (224, 'SoftwareLicense', 5, 5, 0), (225, 'SavedSearch', 8, 1, 0), (226, 'SavedSearch', 9, 1, 0), (227, 'SavedSearch', 3, 1, 0), (228, 'SavedSearch', 10, 1, 0), (229, 'SavedSearch', 11, 1, 0), (230, 'Plugin', 2, 1, 0), (231, 'Plugin', 3, 2, 0), (232, 'Plugin', 4, 3, 0), (233, 'Plugin', 5, 4, 0), (234, 'Plugin', 6, 5, 0), (235, 'Plugin', 7, 6, 0), (236, 'Plugin', 8, 7, 0), (237, 'Cluster', 31, 1, 0), (238, 'Cluster', 19, 2, 0), (239, 'Domain', 3, 1, 0), (240, 'Domain', 4, 2, 0), (241, 'Domain', 2, 3, 0), (242, 'Domain', 6, 4, 0), (243, 'Domain', 7, 5, 0), (244, 'DomainRecord', 2, 1, 0), (245, 'DomainRecord', 3, 2, 0), (246, 'Appliance', 2, 1, 0), (247, 'Appliance', 3, 2, 0), (248, 'Appliance', 4, 3, 0), (249, 'Appliance', 5, 4, 0); INSERT INTO `glpi_documenttypes` (`id`, `name`, `ext`, `icon`, `mime`, `is_uploadable`, `date_mod`, `comment`, `date_creation`) VALUES (1, 'JPEG', 'jpg', 'jpg-dist.png', NULL, 1, NULL, NULL, NULL), (2, 'PNG', 'png', 'png-dist.png', NULL, 1, NULL, NULL, NULL), (3, 'GIF', 'gif', 'gif-dist.png', NULL, 1, NULL, NULL, NULL), (4, 'BMP', 'bmp', 'bmp-dist.png', NULL, 1, NULL, NULL, NULL), (5, 'Photoshop', 'psd', 'psd-dist.png', NULL, 1, NULL, NULL, NULL), (6, 'TIFF', 'tif', 'tif-dist.png', NULL, 1, NULL, NULL, NULL), (7, 'AIFF', 'aiff', 'aiff-dist.png', NULL, 1, NULL, NULL, NULL), (8, 'Windows Media', 'asf', 'asf-dist.png', NULL, 1, NULL, NULL, NULL), (9, 'Windows Media', 'avi', 'avi-dist.png', NULL, 1, NULL, NULL, NULL), (10, 'BZip', 'bz2', 'bz2-dist.png', NULL, 1, NULL, NULL, NULL), (11, 'Word', 'doc', 'doc-dist.png', NULL, 1, NULL, NULL, NULL), (12, 'DjVu', 'djvu', '', NULL, 1, NULL, NULL, NULL), (13, 'PostScript', 'eps', 'ps-dist.png', NULL, 1, NULL, NULL, NULL), (14, 'GZ', 'gz', 'gz-dist.png', NULL, 1, NULL, NULL, NULL), (15, 'HTML', 'html', 'html-dist.png', NULL, 1, NULL, NULL, NULL), (16, 'Midi', 'mid', 'mid-dist.png', NULL, 1, NULL, NULL, NULL), (17, 'QuickTime', 'mov', 'mov-dist.png', NULL, 1, NULL, NULL, NULL), (18, 'MP3', 'mp3', 'mp3-dist.png', NULL, 1, NULL, NULL, NULL), (19, 'MPEG', 'mpg', 'mpg-dist.png', NULL, 1, NULL, NULL, NULL), (20, 'Ogg Vorbis', 'ogg', 'ogg-dist.png', NULL, 1, NULL, NULL, NULL), (21, 'PDF', 'pdf', 'pdf-dist.png', NULL, 1, NULL, NULL, NULL), (22, 'PowerPoint', 'ppt', 'ppt-dist.png', NULL, 1, NULL, NULL, NULL), (23, 'PostScript', 'ps', 'ps-dist.png', NULL, 1, NULL, NULL, NULL), (24, 'QuickTime', 'qt', 'qt-dist.png', NULL, 1, NULL, NULL, NULL), (25, 'RealAudio', 'ra', 'ra-dist.png', NULL, 1, NULL, NULL, NULL), (26, 'RealAudio', 'ram', 'ram-dist.png', NULL, 1, NULL, NULL, NULL), (27, 'RealAudio', 'rm', 'rm-dist.png', NULL, 1, NULL, NULL, NULL), (28, 'RTF', 'rtf', 'rtf-dist.png', NULL, 1, NULL, NULL, NULL), (29, 'StarOffice', 'sdd', 'sdd-dist.png', NULL, 1, NULL, NULL, NULL), (30, 'StarOffice', 'sdw', 'sdw-dist.png', NULL, 1, NULL, NULL, NULL), (31, 'Stuffit', 'sit', 'sit-dist.png', NULL, 1, NULL, NULL, NULL), (32, 'OpenOffice Impress', 'sxi', 'sxi-dist.png', NULL, 1, NULL, NULL, NULL), (33, 'OpenOffice', 'sxw', 'sxw-dist.png', NULL, 1, NULL, NULL, NULL), (34, 'Flash', 'swf', 'swf-dist.png', NULL, 1, NULL, NULL, NULL), (35, 'TGZ', 'tgz', 'tgz-dist.png', NULL, 1, NULL, NULL, NULL), (36, 'texte', 'txt', 'txt-dist.png', NULL, 1, NULL, NULL, NULL), (37, 'WAV', 'wav', 'wav-dist.png', NULL, 1, NULL, NULL, NULL), (38, 'Excel', 'xls', 'xls-dist.png', NULL, 1, NULL, NULL, NULL), (39, 'XML', 'xml', 'xml-dist.png', NULL, 1, NULL, NULL, NULL), (40, 'Windows Media', 'wmv', 'wmv-dist.png', NULL, 1, NULL, NULL, NULL), (41, 'Zip', 'zip', 'zip-dist.png', NULL, 1, NULL, NULL, NULL), (42, 'MNG', 'mng', '', NULL, 1, NULL, NULL, NULL), (43, 'Adobe Illustrator', 'ai', 'ai-dist.png', NULL, 1, NULL, NULL, NULL), (44, 'C source', 'c', 'c-dist.png', NULL, 1, NULL, NULL, NULL), (45, 'Debian', 'deb', 'deb-dist.png', NULL, 1, NULL, NULL, NULL), (46, 'DVI', 'dvi', 'dvi-dist.png', NULL, 1, NULL, NULL, NULL), (47, 'C header', 'h', 'h-dist.png', NULL, 1, NULL, NULL, NULL), (48, 'Pascal', 'pas', 'pas-dist.png', NULL, 1, NULL, NULL, NULL), (49, 'RedHat/Mandrake/SuSE', 'rpm', 'rpm-dist.png', NULL, 1, NULL, NULL, NULL), (50, 'OpenOffice Calc', 'sxc', 'sxc-dist.png', NULL, 1, NULL, NULL, NULL), (51, 'LaTeX', 'tex', 'tex-dist.png', NULL, 1, NULL, NULL, NULL), (52, 'GIMP multi-layer', 'xcf', 'xcf-dist.png', NULL, 1, NULL, NULL, NULL), (53, 'JPEG', 'jpeg', 'jpg-dist.png', NULL, 1, NULL, NULL, NULL), (54, 'Oasis Open Office Writer', 'odt', 'odt-dist.png', NULL, 1, NULL, NULL, NULL), (55, 'Oasis Open Office Calc', 'ods', 'ods-dist.png', NULL, 1, NULL, NULL, NULL), (56, 'Oasis Open Office Impress', 'odp', 'odp-dist.png', NULL, 1, NULL, NULL, NULL), (57, 'Oasis Open Office Impress Template', 'otp', 'odp-dist.png', NULL, 1, NULL, NULL, NULL), (58, 'Oasis Open Office Writer Template', 'ott', 'odt-dist.png', NULL, 1, NULL, NULL, NULL), (59, 'Oasis Open Office Calc Template', 'ots', 'ods-dist.png', NULL, 1, NULL, NULL, NULL), (60, 'Oasis Open Office Math', 'odf', 'odf-dist.png', NULL, 1, NULL, NULL, NULL), (61, 'Oasis Open Office Draw', 'odg', 'odg-dist.png', NULL, 1, NULL, NULL, NULL), (62, 'Oasis Open Office Draw Template', 'otg', 'odg-dist.png', NULL, 1, NULL, NULL, NULL), (63, 'Oasis Open Office Base', 'odb', 'odb-dist.png', NULL, 1, NULL, NULL, NULL), (64, 'Oasis Open Office HTML', 'oth', 'oth-dist.png', NULL, 1, NULL, NULL, NULL), (65, 'Oasis Open Office Writer Master', 'odm', 'odm-dist.png', NULL, 1, NULL, NULL, NULL), (66, 'Oasis Open Office Chart', 'odc', '', NULL, 1, NULL, NULL, NULL), (67, 'Oasis Open Office Image', 'odi', '', NULL, 1, NULL, NULL, NULL), (68, 'Word XML', 'docx', 'doc-dist.png', NULL, 1, NULL, NULL, NULL), (69, 'Excel XML', 'xlsx', 'xls-dist.png', NULL, 1, NULL, NULL, NULL), (70, 'PowerPoint XML', 'pptx', 'ppt-dist.png', NULL, 1, NULL, NULL, NULL), (71, 'Comma-Separated Values', 'csv', 'csv-dist.png', NULL, 1, NULL, NULL, NULL), (72, 'Scalable Vector Graphics', 'svg', 'svg-dist.png', NULL, 1, NULL, NULL, NULL); INSERT INTO `glpi_domainrecordtypes` (`id`, `name`, `entities_id`, `is_recursive`, `comment`) VALUES (1, 'A', 0, 1, 'Host address'), (2, 'AAAA', 0, 1, 'IPv6 host address'), (3, 'ALIAS', 0, 1, 'Auto resolved alias'), (4, 'CNAME', 0, 1, 'Canonical name for an alias'), (5, 'MX', 0, 1, 'Mail eXchange'), (6, 'NS', 0, 1, 'Name Server'), (7, 'PTR', 0, 1, 'Pointer'), (8, 'SOA', 0, 1, 'Start Of Authority'), (9, 'SRV', 0, 1, 'Location of service'), (10, 'TXT', 0, 1, 'Descriptive text'); INSERT INTO `glpi_domainrelations` (`id`, `name`, `entities_id`, `is_recursive`, `comment`) VALUES (1, 'Belongs', 0, 1, 'Item belongs to domain'), (2, 'Manage', 0, 1, 'Item manages domain'); INSERT INTO `glpi_entities` (`id`, `name`, `entities_id`, `completename`, `comment`, `level`, `sons_cache`, `ancestors_cache`, `address`, `postcode`, `town`, `state`, `country`, `website`, `phonenumber`, `fax`, `email`, `admin_email`, `admin_email_name`, `admin_reply`, `admin_reply_name`, `notification_subject_tag`, `ldap_dn`, `tag`, `authldaps_id`, `mail_domain`, `entity_ldapfilter`, `mailing_signature`, `cartridges_alert_repeat`, `consumables_alert_repeat`, `use_licenses_alert`, `send_licenses_alert_before_delay`, `use_certificates_alert`, `send_certificates_alert_before_delay`, `use_contracts_alert`, `send_contracts_alert_before_delay`, `use_infocoms_alert`, `send_infocoms_alert_before_delay`, `use_reservations_alert`, `use_domains_alert`, `send_domains_alert_close_expiries_delay`, `send_domains_alert_expired_delay`, `autoclose_delay`, `autopurge_delay`, `notclosed_delay`, `calendars_id`, `auto_assign_mode`, `tickettype`, `max_closedate`, `inquest_config`, `inquest_rate`, `inquest_delay`, `inquest_URL`, `autofill_warranty_date`, `autofill_use_date`, `autofill_buy_date`, `autofill_delivery_date`, `autofill_order_date`, `tickettemplates_id`, `changetemplates_id`, `problemtemplates_id`, `entities_id_software`, `default_contract_alert`, `default_infocom_alert`, `default_cartridges_alarm_threshold`, `default_consumables_alarm_threshold`, `delay_send_emails`, `is_notif_enable_default`, `inquest_duration`, `date_mod`, `date_creation`, `autofill_decommission_date`, `suppliers_as_private`, `anonymize_support_agents`, `enable_custom_css`, `custom_css_code`, `latitude`, `longitude`, `altitude`) VALUES (0, 'Root entity', -1, 'Root entity', NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -2, -2, -2, -10, -10, 0, 0, -10, 1, NULL, 1, 0, 0, NULL, '0', '0', '0', '0', '0', 1, 1, 1, -10, 0, 0, 10, 10, 0, 1, 0, NULL, NULL, '0', 0, 0, 0, NULL, NULL, NULL, NULL); INSERT INTO `glpi_filesystems` (`id`, `name`, `comment`, `date_mod`, `date_creation`) VALUES (1, 'ext', NULL, NULL, NULL), (2, 'ext2', NULL, NULL, NULL), (3, 'ext3', NULL, NULL, NULL), (4, 'ext4', NULL, NULL, NULL), (5, 'FAT', NULL, NULL, NULL), (6, 'FAT32', NULL, NULL, NULL), (7, 'VFAT', NULL, NULL, NULL), (8, 'HFS', NULL, NULL, NULL), (9, 'HPFS', NULL, NULL, NULL), (10, 'HTFS', NULL, NULL, NULL), (11, 'JFS', NULL, NULL, NULL), (12, 'JFS2', NULL, NULL, NULL), (13, 'NFS', NULL, NULL, NULL), (14, 'NTFS', NULL, NULL, NULL), (15, 'ReiserFS', NULL, NULL, NULL), (16, 'SMBFS', NULL, NULL, NULL), (17, 'UDF', NULL, NULL, NULL), (18, 'UFS', NULL, NULL, NULL), (19, 'XFS', NULL, NULL, NULL), (20, 'ZFS', NULL, NULL, NULL), (21, 'APFS', NULL, NULL, NULL); INSERT INTO `glpi_interfacetypes` (`id`, `name`, `comment`, `date_mod`, `date_creation`) VALUES (1, 'IDE', NULL, NULL, NULL), (2, 'SATA', NULL, NULL, NULL), (3, 'SCSI', NULL, NULL, NULL), (4, 'USB', NULL, NULL, NULL), (5, 'AGP', NULL, NULL, NULL), (6, 'PCI', NULL, NULL, NULL), (7, 'PCIe', NULL, NULL, NULL), (8, 'PCI-X', NULL, NULL, NULL); INSERT INTO `glpi_notifications` (`id`, `name`, `entities_id`, `itemtype`, `event`, `comment`, `is_recursive`, `is_active`, `date_mod`, `date_creation`, `allow_response`) VALUES (1, 'Alert Tickets not closed', 0, 'Ticket', 'alertnotclosed', NULL, 1, 1, NULL, NULL, 1), (2, 'New Ticket', 0, 'Ticket', 'new', NULL, 1, 1, NULL, NULL, 1), (3, 'Update Ticket', 0, 'Ticket', 'update', NULL, 1, 0, NULL, NULL, 1), (4, 'Close Ticket', 0, 'Ticket', 'closed', NULL, 1, 1, NULL, NULL, 1), (5, 'Add Followup', 0, 'Ticket', 'add_followup', NULL, 1, 1, NULL, NULL, 1), (6, 'Add Task', 0, 'Ticket', 'add_task', NULL, 1, 1, NULL, NULL, 1), (7, 'Update Followup', 0, 'Ticket', 'update_followup', NULL, 1, 1, NULL, NULL, 1), (8, 'Update Task', 0, 'Ticket', 'update_task', NULL, 1, 1, NULL, NULL, 1), (9, 'Delete Followup', 0, 'Ticket', 'delete_followup', NULL, 1, 1, NULL, NULL, 1), (10, 'Delete Task', 0, 'Ticket', 'delete_task', NULL, 1, 1, NULL, NULL, 1), (11, 'Resolve ticket', 0, 'Ticket', 'solved', NULL, 1, 1, NULL, NULL, 1), (12, 'Ticket Validation', 0, 'Ticket', 'validation', NULL, 1, 1, NULL, NULL, 1), (13, 'New Reservation', 0, 'Reservation', 'new', NULL, 1, 1, NULL, NULL, 1), (14, 'Update Reservation', 0, 'Reservation', 'update', NULL, 1, 1, NULL, NULL, 1), (15, 'Delete Reservation', 0, 'Reservation', 'delete', NULL, 1, 1, NULL, NULL, 1), (16, 'Alert Reservation', 0, 'Reservation', 'alert', NULL, 1, 1, NULL, NULL, 1), (17, 'Contract Notice', 0, 'Contract', 'notice', NULL, 1, 1, NULL, NULL, 1), (18, 'Contract End', 0, 'Contract', 'end', NULL, 1, 1, NULL, NULL, 1), (19, 'MySQL Synchronization', 0, 'DBConnection', 'desynchronization', NULL, 1, 1, NULL, NULL, 1), (20, 'Cartridges', 0, 'CartridgeItem', 'alert', NULL, 1, 1, NULL, NULL, 1), (21, 'Consumables', 0, 'ConsumableItem', 'alert', NULL, 1, 1, NULL, NULL, 1), (22, 'Infocoms', 0, 'Infocom', 'alert', NULL, 1, 1, NULL, NULL, 1), (23, 'Software Licenses', 0, 'SoftwareLicense', 'alert', NULL, 1, 1, NULL, NULL, 1), (24, 'Ticket Recall', 0, 'Ticket', 'recall', NULL, 1, 1, NULL, NULL, 1), (25, 'Password Forget', 0, 'User', 'passwordforget', NULL, 1, 1, NULL, NULL, 1), (26, 'Ticket Satisfaction', 0, 'Ticket', 'satisfaction', NULL, 1, 1, NULL, NULL, 1), (27, 'Item not unique', 0, 'FieldUnicity', 'refuse', NULL, 1, 1, NULL, NULL, 1), (28, 'CronTask Watcher', 0, 'CronTask', 'alert', NULL, 1, 1, NULL, NULL, 1), (29, 'New Problem', 0, 'Problem', 'new', NULL, 1, 1, NULL, NULL, 1), (30, 'Update Problem', 0, 'Problem', 'update', NULL, 1, 1, NULL, NULL, 1), (31, 'Resolve Problem', 0, 'Problem', 'solved', NULL, 1, 1, NULL, NULL, 1), (32, 'Add Task', 0, 'Problem', 'add_task', NULL, 1, 1, NULL, NULL, 1), (33, 'Update Task', 0, 'Problem', 'update_task', NULL, 1, 1, NULL, NULL, 1), (34, 'Delete Task', 0, 'Problem', 'delete_task', NULL, 1, 1, NULL, NULL, 1), (35, 'Close Problem', 0, 'Problem', 'closed', NULL, 1, 1, NULL, NULL, 1), (36, 'Delete Problem', 0, 'Problem', 'delete', NULL, 1, 1, NULL, NULL, 1), (37, 'Ticket Validation Answer', 0, 'Ticket', 'validation_answer', NULL, 1, 1, NULL, NULL, 1), (38, 'Contract End Periodicity', 0, 'Contract', 'periodicity', NULL, 1, 1, NULL, NULL, 1), (39, 'Contract Notice Periodicity', 0, 'Contract', 'periodicitynotice', NULL, 1, 1, NULL, NULL, 1), (40, 'Planning recall', 0, 'PlanningRecall', 'planningrecall', NULL, 1, 1, NULL, NULL, 1), (41, 'Delete Ticket', 0, 'Ticket', 'delete', NULL, 1, 1, NULL, NULL, 1), (42, 'New Change', 0, 'Change', 'new', NULL, 1, 1, NULL, NULL, 1), (43, 'Update Change', 0, 'Change', 'update', NULL, 1, 1, NULL, NULL, 1), (44, 'Resolve Change', 0, 'Change', 'solved', NULL, 1, 1, NULL, NULL, 1), (45, 'Add Task', 0, 'Change', 'add_task', NULL, 1, 1, NULL, NULL, 1), (46, 'Update Task', 0, 'Change', 'update_task', NULL, 1, 1, NULL, NULL, 1), (47, 'Delete Task', 0, 'Change', 'delete_task', NULL, 1, 1, NULL, NULL, 1), (48, 'Close Change', 0, 'Change', 'closed', NULL, 1, 1, NULL, NULL, 1), (49, 'Delete Change', 0, 'Change', 'delete', NULL, 1, 1, NULL, NULL, 1), (50, 'Ticket Satisfaction Answer', 0, 'Ticket', 'replysatisfaction', NULL, 1, 1, NULL, NULL, 1), (51, 'Receiver errors', 0, 'MailCollector', 'error', NULL, 1, 1, NULL, NULL, 1), (52, 'New Project', 0, 'Project', 'new', NULL, 1, 1, NULL, NULL, 1), (53, 'Update Project', 0, 'Project', 'update', NULL, 1, 1, NULL, NULL, 1), (54, 'Delete Project', 0, 'Project', 'delete', NULL, 1, 1, NULL, NULL, 1), (55, 'New Project Task', 0, 'ProjectTask', 'new', NULL, 1, 1, NULL, NULL, 1), (56, 'Update Project Task', 0, 'ProjectTask', 'update', NULL, 1, 1, NULL, NULL, 1), (57, 'Delete Project Task', 0, 'ProjectTask', 'delete', NULL, 1, 1, NULL, NULL, 1), (58, 'Request Unlock Items', 0, 'ObjectLock', 'unlock', NULL, 1, 1, NULL, NULL, 1), (59, 'New user in requesters', 0, 'Ticket', 'requester_user', NULL, 1, 1, NULL, NULL, 1), (60, 'New group in requesters', 0, 'Ticket', 'requester_group', NULL, 1, 1, NULL, NULL, 1), (61, 'New user in observers', 0, 'Ticket', 'observer_user', NULL, 1, 1, NULL, NULL, 1), (62, 'New group in observers', 0, 'Ticket', 'observer_group', NULL, 1, 1, NULL, NULL, 1), (63, 'New user in assignees', 0, 'Ticket', 'assign_user', NULL, 1, 1, NULL, NULL, 1), (64, 'New group in assignees', 0, 'Ticket', 'assign_group', NULL, 1, 1, NULL, NULL, 1), (65, 'New supplier in assignees', 0, 'Ticket', 'assign_supplier', NULL, 1, 1, NULL, NULL, 1), (66, 'Saved searches', 0, 'SavedSearch_Alert', 'alert', NULL, 1, 1, NULL, NULL, 1), (67, 'Certificates', 0, 'Certificate', 'alert', NULL, 1, 1, NULL, NULL, 1), (68, 'Alert expired domains', 0, 'Domain', 'ExpiredDomains', NULL, 1, 1, NULL, NULL, 1), (69, 'Alert domains close expiries', 0, 'Domain', 'DomainsWhichExpire', NULL, 1, 1, NULL, NULL, 1), (70, 'Password expires alert', 0, 'User', 'passwordexpires', NULL, 1, 1, NULL, NULL, 1), (71, 'Check plugin updates', 0, 'Glpi\\Marketplace\\Controller', 'checkpluginsupdate', NULL, 1, 1, NULL, NULL, 1); INSERT INTO `glpi_notifications_notificationtemplates` (`id`, `notifications_id`, `mode`, `notificationtemplates_id`) VALUES (1, 1, 'mailing', 6), (2, 2, 'mailing', 4), (3, 3, 'mailing', 4), (4, 4, 'mailing', 4), (5, 5, 'mailing', 4), (6, 6, 'mailing', 4), (7, 7, 'mailing', 4), (8, 8, 'mailing', 4), (9, 9, 'mailing', 4), (10, 10, 'mailing', 4), (11, 11, 'mailing', 4), (12, 12, 'mailing', 7), (13, 13, 'mailing', 2), (14, 14, 'mailing', 2), (15, 15, 'mailing', 2), (16, 16, 'mailing', 3), (17, 17, 'mailing', 12), (18, 18, 'mailing', 12), (19, 19, 'mailing', 1), (20, 20, 'mailing', 8), (21, 21, 'mailing', 9), (22, 22, 'mailing', 10), (23, 23, 'mailing', 11), (24, 24, 'mailing', 4), (25, 25, 'mailing', 13), (26, 26, 'mailing', 14), (27, 27, 'mailing', 15), (28, 28, 'mailing', 16), (29, 29, 'mailing', 17), (30, 30, 'mailing', 17), (31, 31, 'mailing', 17), (32, 32, 'mailing', 17), (33, 33, 'mailing', 17), (34, 34, 'mailing', 17), (35, 35, 'mailing', 17), (36, 36, 'mailing', 17), (37, 37, 'mailing', 7), (38, 38, 'mailing', 12), (39, 39, 'mailing', 12), (40, 40, 'mailing', 18), (41, 41, 'mailing', 4), (42, 42, 'mailing', 19), (43, 43, 'mailing', 19), (44, 44, 'mailing', 19), (45, 45, 'mailing', 19), (46, 46, 'mailing', 19), (47, 47, 'mailing', 19), (48, 48, 'mailing', 19), (49, 49, 'mailing', 19), (50, 50, 'mailing', 14), (51, 51, 'mailing', 20), (52, 52, 'mailing', 21), (53, 53, 'mailing', 21), (54, 54, 'mailing', 21), (55, 55, 'mailing', 22), (56, 56, 'mailing', 22), (57, 57, 'mailing', 22), (58, 58, 'mailing', 23), (59, 59, 'mailing', 4), (60, 60, 'mailing', 4), (61, 61, 'mailing', 4), (62, 62, 'mailing', 4), (63, 63, 'mailing', 4), (64, 64, 'mailing', 4), (65, 65, 'mailing', 4), (66, 66, 'mailing', 24), (67, 67, 'mailing', 25), (68, 68, 'mailing', 26), (69, 69, 'mailing', 26), (70, 70, 'mailing', 27), (71, 71, 'mailing', 28); INSERT INTO `glpi_notificationtargets` (`id`, `items_id`, `type`, `notifications_id`) VALUES (1, 3, 1, 13), (2, 1, 1, 13), (3, 3, 2, 2), (4, 1, 1, 2), (5, 1, 1, 3), (6, 1, 1, 5), (7, 1, 1, 4), (8, 2, 1, 3), (9, 4, 1, 3), (10, 3, 1, 2), (11, 3, 1, 3), (12, 3, 1, 5), (13, 3, 1, 4), (14, 1, 1, 19), (15, 14, 1, 12), (16, 3, 1, 14), (17, 1, 1, 14), (18, 3, 1, 15), (19, 1, 1, 15), (20, 1, 1, 6), (21, 3, 1, 6), (22, 1, 1, 7), (23, 3, 1, 7), (24, 1, 1, 8), (25, 3, 1, 8), (26, 1, 1, 9), (27, 3, 1, 9), (28, 1, 1, 10), (29, 3, 1, 10), (30, 1, 1, 11), (31, 3, 1, 11), (32, 19, 1, 25), (33, 3, 1, 26), (34, 21, 1, 2), (35, 21, 1, 3), (36, 21, 1, 5), (37, 21, 1, 4), (38, 21, 1, 6), (39, 21, 1, 7), (40, 21, 1, 8), (41, 21, 1, 9), (42, 21, 1, 10), (43, 21, 1, 11), (46, 1, 1, 28), (47, 3, 1, 29), (48, 1, 1, 29), (49, 21, 1, 29), (50, 2, 1, 30), (51, 4, 1, 30), (52, 3, 1, 30), (53, 1, 1, 30), (54, 21, 1, 30), (55, 3, 1, 31), (56, 1, 1, 31), (57, 21, 1, 31), (58, 3, 1, 32), (59, 1, 1, 32), (60, 21, 1, 32), (61, 3, 1, 33), (62, 1, 1, 33), (63, 21, 1, 33), (64, 3, 1, 34), (65, 1, 1, 34), (66, 21, 1, 34), (67, 3, 1, 35), (68, 1, 1, 35), (69, 21, 1, 35), (70, 3, 1, 36), (71, 1, 1, 36), (72, 21, 1, 36), (73, 14, 1, 37), (74, 3, 1, 40), (75, 1, 1, 41), (76, 3, 1, 42), (77, 1, 1, 42), (78, 21, 1, 42), (79, 2, 1, 43), (80, 4, 1, 43), (81, 3, 1, 43), (82, 1, 1, 43), (83, 21, 1, 43), (84, 3, 1, 44), (85, 1, 1, 44), (86, 21, 1, 44), (87, 3, 1, 45), (88, 1, 1, 45), (89, 21, 1, 45), (90, 3, 1, 46), (91, 1, 1, 46), (92, 21, 1, 46), (93, 3, 1, 47), (94, 1, 1, 47), (95, 21, 1, 47), (96, 3, 1, 48), (97, 1, 1, 48), (98, 21, 1, 48), (99, 3, 1, 49), (100, 1, 1, 49), (101, 21, 1, 49), (102, 3, 1, 50), (103, 2, 1, 50), (104, 1, 1, 51), (105, 27, 1, 52), (106, 1, 1, 52), (107, 28, 1, 52), (108, 27, 1, 53), (109, 1, 1, 53), (110, 28, 1, 53), (111, 27, 1, 54), (112, 1, 1, 54), (113, 28, 1, 54), (114, 31, 1, 55), (115, 1, 1, 55), (116, 32, 1, 55), (117, 31, 1, 56), (118, 1, 1, 56), (119, 32, 1, 56), (120, 31, 1, 57), (121, 1, 1, 57), (122, 32, 1, 57), (123, 19, 1, 58), (124, 3, 1, 59), (125, 13, 1, 60), (126, 21, 1, 61), (127, 20, 1, 62), (128, 2, 1, 63), (129, 23, 1, 64), (130, 8, 1, 65), (131, 19, 1, 66), (132, 5, 1, 67), (133, 23, 1, 67), (134, 5, 1, 68), (135, 23, 1, 68), (136, 5, 1, 69), (137, 23, 1, 69), (138, 19, 1, 70), (139, 1, 1, 71); INSERT INTO `glpi_notificationtemplates` (`id`, `name`, `itemtype`, `date_mod`, `comment`, `css`, `date_creation`) VALUES (1, 'MySQL Synchronization', 'DBConnection', NULL, NULL, NULL, NULL), (2, 'Reservations', 'Reservation', NULL, NULL, NULL, NULL), (3, 'Alert Reservation', 'Reservation', NULL, NULL, NULL, NULL), (4, 'Tickets', 'Ticket', NULL, NULL, NULL, NULL), (5, 'Tickets (Simple)', 'Ticket', NULL, NULL, NULL, NULL), (6, 'Alert Tickets not closed', 'Ticket', NULL, NULL, NULL, NULL), (7, 'Tickets Validation', 'Ticket', NULL, NULL, NULL, NULL), (8, 'Cartridges', 'CartridgeItem', NULL, NULL, NULL, NULL), (9, 'Consumables', 'ConsumableItem', NULL, NULL, NULL, NULL), (10, 'Infocoms', 'Infocom', NULL, NULL, NULL, NULL), (11, 'Licenses', 'SoftwareLicense', NULL, NULL, NULL, NULL), (12, 'Contracts', 'Contract', NULL, NULL, NULL, NULL), (13, 'Password Forget', 'User', NULL, NULL, NULL, NULL), (14, 'Ticket Satisfaction', 'Ticket', NULL, NULL, NULL, NULL), (15, 'Item not unique', 'FieldUnicity', NULL, NULL, NULL, NULL), (16, 'CronTask', 'CronTask', NULL, NULL, NULL, NULL), (17, 'Problems', 'Problem', NULL, NULL, NULL, NULL), (18, 'Planning recall', 'PlanningRecall', NULL, NULL, NULL, NULL), (19, 'Changes', 'Change', NULL, NULL, NULL, NULL), (20, 'Receiver errors', 'MailCollector', NULL, NULL, NULL, NULL), (21, 'Projects', 'Project', NULL, NULL, NULL, NULL), (22, 'Project Tasks', 'ProjectTask', NULL, NULL, NULL, NULL), (23, 'Unlock Item request', 'ObjectLock', NULL, NULL, NULL, NULL), (24, 'Saved searches alerts', 'SavedSearch_Alert', NULL, NULL, NULL, NULL), (25, 'Certificates', 'Certificate', NULL, NULL, NULL, NULL), (26, 'Alert domains', 'Domain', NULL, NULL, NULL, NULL), (27, 'Password expires alert', 'User', NULL, NULL, NULL, NULL), (28, 'Plugin updates', 'Glpi\\Marketplace\\Controller', NULL, NULL, NULL, NULL); INSERT INTO `glpi_notificationtemplatetranslations` (`id`, `notificationtemplates_id`, `language`, `subject`, `content_text`, `content_html`) VALUES (1, 1, '', '##lang.dbconnection.title##', '##lang.dbconnection.delay## : ##dbconnection.delay##', '<p>##lang.dbconnection.delay## : ##dbconnection.delay##</p>'), (2, 2, '', '##reservation.action##', '======================================================================\n##lang.reservation.user##: ##reservation.user##\n##lang.reservation.item.name##: ##reservation.itemtype## - ##reservation.item.name##\n##IFreservation.tech## ##lang.reservation.tech## ##reservation.tech## ##ENDIFreservation.tech##\n##lang.reservation.begin##: ##reservation.begin##\n##lang.reservation.end##: ##reservation.end##\n##lang.reservation.comment##: ##reservation.comment##\n======================================================================', '<!-- description{ color: inherit; background: #ebebeb;border-style: solid;border-color: #8d8d8d; border-width: 0px 1px 1px 0px; } -->\n<p><span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\">##lang.reservation.user##:</span>##reservation.user##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\">##lang.reservation.item.name##:</span>##reservation.itemtype## - ##reservation.item.name##<br />##IFreservation.tech## ##lang.reservation.tech## ##reservation.tech####ENDIFreservation.tech##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\">##lang.reservation.begin##:</span> ##reservation.begin##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\">##lang.reservation.end##:</span>##reservation.end##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\">##lang.reservation.comment##:</span> ##reservation.comment##</p>'), (3, 3, '', '##reservation.action## ##reservation.entity##', '##lang.reservation.entity## : ##reservation.entity##\n\n\n##FOREACHreservations##\n##lang.reservation.itemtype## : ##reservation.itemtype##\n\n ##lang.reservation.item## : ##reservation.item##\n\n ##reservation.url##\n\n ##ENDFOREACHreservations##', '<p>##lang.reservation.entity## : ##reservation.entity## <br /> <br />\n##FOREACHreservations## <br />##lang.reservation.itemtype## : ##reservation.itemtype##<br />\n ##lang.reservation.item## : ##reservation.item##<br /> <br />\n <a href=\"##reservation.url##\"> ##reservation.url##</a><br />\n ##ENDFOREACHreservations##</p>'), (4, 4, '', '##ticket.action## ##ticket.title##', ' ##IFticket.storestatus=5##\n ##lang.ticket.url## : ##ticket.urlapprove##\n ##lang.ticket.autoclosewarning##\n ##lang.ticket.solvedate## : ##ticket.solvedate##\n ##lang.ticket.solution.type## : ##ticket.solution.type##\n ##lang.ticket.solution.description## : ##ticket.solution.description## ##ENDIFticket.storestatus##\n ##ELSEticket.storestatus## ##lang.ticket.url## : ##ticket.url## ##ENDELSEticket.storestatus##\n\n ##lang.ticket.description##\n\n ##lang.ticket.title## : ##ticket.title##\n ##lang.ticket.authors## : ##IFticket.authors## ##ticket.authors## ##ENDIFticket.authors## ##ELSEticket.authors##--##ENDELSEticket.authors##\n ##lang.ticket.creationdate## : ##ticket.creationdate##\n ##lang.ticket.closedate## : ##ticket.closedate##\n ##lang.ticket.requesttype## : ##ticket.requesttype##\n##lang.ticket.item.name## :\n\n##FOREACHitems##\n\n ##IFticket.itemtype##\n ##ticket.itemtype## - ##ticket.item.name##\n ##IFticket.item.model## ##lang.ticket.item.model## : ##ticket.item.model## ##ENDIFticket.item.model##\n ##IFticket.item.serial## ##lang.ticket.item.serial## : ##ticket.item.serial## ##ENDIFticket.item.serial##\n ##IFticket.item.otherserial## ##lang.ticket.item.otherserial## : ##ticket.item.otherserial## ##ENDIFticket.item.otherserial##\n ##ENDIFticket.itemtype##\n\n##ENDFOREACHitems##\n##IFticket.assigntousers## ##lang.ticket.assigntousers## : ##ticket.assigntousers## ##ENDIFticket.assigntousers##\n ##lang.ticket.status## : ##ticket.status##\n##IFticket.assigntogroups## ##lang.ticket.assigntogroups## : ##ticket.assigntogroups## ##ENDIFticket.assigntogroups##\n ##lang.ticket.urgency## : ##ticket.urgency##\n ##lang.ticket.impact## : ##ticket.impact##\n ##lang.ticket.priority## : ##ticket.priority##\n##IFticket.user.email## ##lang.ticket.user.email## : ##ticket.user.email ##ENDIFticket.user.email##\n##IFticket.category## ##lang.ticket.category## : ##ticket.category## ##ENDIFticket.category## ##ELSEticket.category## ##lang.ticket.nocategoryassigned## ##ENDELSEticket.category##\n ##lang.ticket.content## : ##ticket.content##\n ##IFticket.storestatus=6##\n\n ##lang.ticket.solvedate## : ##ticket.solvedate##\n ##lang.ticket.solution.type## : ##ticket.solution.type##\n ##lang.ticket.solution.description## : ##ticket.solution.description##\n ##ENDIFticket.storestatus##\n ##lang.ticket.numberoffollowups## : ##ticket.numberoffollowups##\n\n##FOREACHfollowups##\n\n [##followup.date##] ##lang.followup.isprivate## : ##followup.isprivate##\n ##lang.followup.author## ##followup.author##\n ##lang.followup.description## ##followup.description##\n ##lang.followup.date## ##followup.date##\n ##lang.followup.requesttype## ##followup.requesttype##\n\n##ENDFOREACHfollowups##\n ##lang.ticket.numberoftasks## : ##ticket.numberoftasks##\n\n##FOREACHtasks##\n\n [##task.date##] ##lang.task.isprivate## : ##task.isprivate##\n ##lang.task.author## ##task.author##\n ##lang.task.description## ##task.description##\n ##lang.task.time## ##task.time##\n ##lang.task.category## ##task.category##\n\n##ENDFOREACHtasks##', '\n
##IFticket.storestatus=5##
\n
##lang.ticket.url## : ##ticket.urlapprove##  
\n
##lang.ticket.autoclosewarning##
\n
##lang.ticket.solvedate## : ##ticket.solvedate##
##lang.ticket.solution.type## : ##ticket.solution.type##
##lang.ticket.solution.description## : ##ticket.solution.description## ##ENDIFticket.storestatus##
\n
##ELSEticket.storestatus## ##lang.ticket.url## : ##ticket.url## ##ENDELSEticket.storestatus##
\n

##lang.ticket.description##

\n

##lang.ticket.title## :##ticket.title##
##lang.ticket.authors## :##IFticket.authors## ##ticket.authors## ##ENDIFticket.authors## ##ELSEticket.authors##--##ENDELSEticket.authors##
##lang.ticket.creationdate## :##ticket.creationdate##
##lang.ticket.closedate## :##ticket.closedate##
##lang.ticket.requesttype## :##ticket.requesttype##
\n
##lang.ticket.item.name## :\n

##FOREACHitems##

\n
##IFticket.itemtype## ##ticket.itemtype## - ##ticket.item.name## ##IFticket.item.model## ##lang.ticket.item.model## : ##ticket.item.model## ##ENDIFticket.item.model## ##IFticket.item.serial## ##lang.ticket.item.serial## : ##ticket.item.serial## ##ENDIFticket.item.serial## ##IFticket.item.otherserial## ##lang.ticket.item.otherserial## : ##ticket.item.otherserial## ##ENDIFticket.item.otherserial## ##ENDIFticket.itemtype##

\n

##ENDFOREACHitems##

\n##IFticket.assigntousers## ##lang.ticket.assigntousers## : ##ticket.assigntousers## ##ENDIFticket.assigntousers##
##lang.ticket.status##  : ##ticket.status##
##IFticket.assigntogroups## ##lang.ticket.assigntogroups## : ##ticket.assigntogroups## ##ENDIFticket.assigntogroups##
##lang.ticket.urgency## : ##ticket.urgency##
##lang.ticket.impact## : ##ticket.impact##
##lang.ticket.priority## : ##ticket.priority##
##IFticket.user.email## ##lang.ticket.user.email## : ##ticket.user.email ##ENDIFticket.user.email##
##IFticket.category####lang.ticket.category##  :##ticket.category## ##ENDIFticket.category## ##ELSEticket.category## ##lang.ticket.nocategoryassigned## ##ENDELSEticket.category##
##lang.ticket.content## : ##ticket.content##

\n
##IFticket.storestatus=6##
##lang.ticket.solvedate## : ##ticket.solvedate##
##lang.ticket.solution.type## : ##ticket.solution.type##
##lang.ticket.solution.description## : ##ticket.solution.description##
##ENDIFticket.storestatus##

\n
##lang.ticket.numberoffollowups## : ##ticket.numberoffollowups##
\n

##FOREACHfollowups##

\n

[##followup.date##] ##lang.followup.isprivate## : ##followup.isprivate##
##lang.followup.author## ##followup.author##
##lang.followup.description## ##followup.description##
##lang.followup.date## ##followup.date##
##lang.followup.requesttype## ##followup.requesttype##
\n

##ENDFOREACHfollowups##

\n
##lang.ticket.numberoftasks## : ##ticket.numberoftasks##
\n

##FOREACHtasks##

\n

[##task.date##] ##lang.task.isprivate## : ##task.isprivate##
##lang.task.author## ##task.author##
##lang.task.description## ##task.description##
##lang.task.time## ##task.time##
##lang.task.category## ##task.category##
\n

##ENDFOREACHtasks##

'), (5, 12, '', '##contract.action## ##contract.entity##', '##lang.contract.entity## : ##contract.entity##\n\n##FOREACHcontracts##\n##lang.contract.name## : ##contract.name##\n##lang.contract.number## : ##contract.number##\n##lang.contract.time## : ##contract.time##\n##IFcontract.type####lang.contract.type## : ##contract.type####ENDIFcontract.type##\n##contract.url##\n##ENDFOREACHcontracts##', '<p>##lang.contract.entity## : ##contract.entity##<br />\n<br />##FOREACHcontracts##<br />##lang.contract.name## :\n##contract.name##<br />\n##lang.contract.number## : ##contract.number##<br />\n##lang.contract.time## : ##contract.time##<br />\n##IFcontract.type####lang.contract.type## : ##contract.type##\n##ENDIFcontract.type##<br />\n<a href=\"##contract.url##\">\n##contract.url##</a><br />\n##ENDFOREACHcontracts##</p>'), (6, 5, '', '##ticket.action## ##ticket.title##', '##lang.ticket.url## : ##ticket.url##\n\n##lang.ticket.description##\n\n\n##lang.ticket.title## :##ticket.title##\n\n##lang.ticket.authors## :##IFticket.authors##\n##ticket.authors## ##ENDIFticket.authors##\n##ELSEticket.authors##--##ENDELSEticket.authors##\n\n##IFticket.category## ##lang.ticket.category## :##ticket.category##\n##ENDIFticket.category## ##ELSEticket.category##\n##lang.ticket.nocategoryassigned## ##ENDELSEticket.category##\n\n##lang.ticket.content## : ##ticket.content##\n##IFticket.itemtype##\n##lang.ticket.item.name## : ##ticket.itemtype## - ##ticket.item.name##\n##ENDIFticket.itemtype##', '<div>##lang.ticket.url## : <a href=\"##ticket.url##\">\n##ticket.url##</a></div>\n<div class=\"description b\">\n##lang.ticket.description##</div>\n<p><span\nstyle=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\">\n##lang.ticket.title##</span> :##ticket.title##\n<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\">\n##lang.ticket.authors##</span>\n##IFticket.authors## ##ticket.authors##\n##ENDIFticket.authors##\n##ELSEticket.authors##--##ENDELSEticket.authors##\n<span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> \n;</span><br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> </span>\n##IFticket.category##<span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\">\n##lang.ticket.category## </span> :##ticket.category##\n##ENDIFticket.category## ##ELSEticket.category##\n##lang.ticket.nocategoryassigned## ##ENDELSEticket.category##\n<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\">\n##lang.ticket.content##</span> :\n##ticket.content##<br />##IFticket.itemtype##\n<span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\">\n##lang.ticket.item.name##</span> :\n##ticket.itemtype## - ##ticket.item.name##\n##ENDIFticket.itemtype##</p>'), (7, 7, '', '##ticket.action## ##ticket.title##', '##FOREACHvalidations##\n\n##IFvalidation.storestatus=2##\n##validation.submission.title##\n##lang.validation.commentsubmission## : ##validation.commentsubmission##\n##ENDIFvalidation.storestatus##\n##ELSEvalidation.storestatus## ##validation.answer.title## ##ENDELSEvalidation.storestatus##\n\n##lang.ticket.url## : ##ticket.urlvalidation##\n\n##IFvalidation.status## ##lang.validation.status## : ##validation.status## ##ENDIFvalidation.status##\n##IFvalidation.commentvalidation##\n##lang.validation.commentvalidation## : ##validation.commentvalidation##\n##ENDIFvalidation.commentvalidation##\n##ENDFOREACHvalidations##', '<div>##FOREACHvalidations##</div>\n<p>##IFvalidation.storestatus=2##</p>\n<div>##validation.submission.title##</div>\n<div>##lang.validation.commentsubmission## : ##validation.commentsubmission##</div>\n<div>##ENDIFvalidation.storestatus##</div>\n<div>##ELSEvalidation.storestatus## ##validation.answer.title## ##ENDELSEvalidation.storestatus##</div>\n<div></div>\n<div>\n<div>##lang.ticket.url## : <a href=\"##ticket.urlvalidation##\"> ##ticket.urlvalidation## </a></div>\n</div>\n<p>##IFvalidation.status## ##lang.validation.status## : ##validation.status## ##ENDIFvalidation.status##\n<br /> ##IFvalidation.commentvalidation##<br /> ##lang.validation.commentvalidation## :\n  ##validation.commentvalidation##<br /> ##ENDIFvalidation.commentvalidation##\n<br />##ENDFOREACHvalidations##</p>'), (8, 6, '', '##ticket.action## ##ticket.entity##', '##lang.ticket.entity## : ##ticket.entity##\n\n##FOREACHtickets##\n\n##lang.ticket.title## : ##ticket.title##\n ##lang.ticket.status## : ##ticket.status##\n\n ##ticket.url##\n ##ENDFOREACHtickets##', '<table class=\"tab_cadre\" border=\"1\" cellspacing=\"2\" cellpadding=\"3\">\n<tbody>\n<tr>\n<td style=\"text-align: left;\" width=\"auto\" bgcolor=\"#cccccc\"><span style=\"font-size: 11px; text-align: left;\">##lang.ticket.authors##</span></td>\n<td style=\"text-align: left;\" width=\"auto\" bgcolor=\"#cccccc\"><span style=\"font-size: 11px; text-align: left;\">##lang.ticket.title##</span></td>\n<td style=\"text-align: left;\" width=\"auto\" bgcolor=\"#cccccc\"><span style=\"font-size: 11px; text-align: left;\">##lang.ticket.priority##</span></td>\n<td style=\"text-align: left;\" width=\"auto\" bgcolor=\"#cccccc\"><span style=\"font-size: 11px; text-align: left;\">##lang.ticket.status##</span></td>\n<td style=\"text-align: left;\" width=\"auto\" bgcolor=\"#cccccc\"><span style=\"font-size: 11px; text-align: left;\">##lang.ticket.attribution##</span></td>\n<td style=\"text-align: left;\" width=\"auto\" bgcolor=\"#cccccc\"><span style=\"font-size: 11px; text-align: left;\">##lang.ticket.creationdate##</span></td>\n<td style=\"text-align: left;\" width=\"auto\" bgcolor=\"#cccccc\"><span style=\"font-size: 11px; text-align: left;\">##lang.ticket.content##</span></td>\n</tr>\n##FOREACHtickets##\n<tr>\n<td width=\"auto\"><span style=\"font-size: 11px; text-align: left;\">##ticket.authors##</span></td>\n<td width=\"auto\"><span style=\"font-size: 11px; text-align: left;\"><a href=\"##ticket.url##\">##ticket.title##</a></span></td>\n<td width=\"auto\"><span style=\"font-size: 11px; text-align: left;\">##ticket.priority##</span></td>\n<td width=\"auto\"><span style=\"font-size: 11px; text-align: left;\">##ticket.status##</span></td>\n<td width=\"auto\"><span style=\"font-size: 11px; text-align: left;\">##IFticket.assigntousers####ticket.assigntousers##<br />##ENDIFticket.assigntousers####IFticket.assigntogroups##<br />##ticket.assigntogroups## ##ENDIFticket.assigntogroups####IFticket.assigntosupplier##<br />##ticket.assigntosupplier## ##ENDIFticket.assigntosupplier##</span></td>\n<td width=\"auto\"><span style=\"font-size: 11px; text-align: left;\">##ticket.creationdate##</span></td>\n<td width=\"auto\"><span style=\"font-size: 11px; text-align: left;\">##ticket.content##</span></td>\n</tr>\n##ENDFOREACHtickets##\n</tbody>\n</table>'), (9, 9, '', '##consumable.action## ##consumable.entity##', '##lang.consumable.entity## : ##consumable.entity##\n\n\n##FOREACHconsumables##\n##lang.consumable.item## : ##consumable.item##\n\n\n##lang.consumable.reference## : ##consumable.reference##\n\n##lang.consumable.remaining## : ##consumable.remaining##\n\n##consumable.url##\n\n##ENDFOREACHconsumables##', '<p>\n##lang.consumable.entity## : ##consumable.entity##\n<br /> <br />##FOREACHconsumables##\n<br />##lang.consumable.item## : ##consumable.item##<br />\n<br />##lang.consumable.reference## : ##consumable.reference##<br />\n##lang.consumable.remaining## : ##consumable.remaining##<br />\n<a href=\"##consumable.url##\"> ##consumable.url##</a><br />\n ##ENDFOREACHconsumables##</p>'), (10, 8, '', '##cartridge.action## ##cartridge.entity##', '##lang.cartridge.entity## : ##cartridge.entity##\n\n\n##FOREACHcartridges##\n##lang.cartridge.item## : ##cartridge.item##\n\n\n##lang.cartridge.reference## : ##cartridge.reference##\n\n##lang.cartridge.remaining## : ##cartridge.remaining##\n\n##cartridge.url##\n ##ENDFOREACHcartridges##', '<p>##lang.cartridge.entity## : ##cartridge.entity##\n<br /> <br />##FOREACHcartridges##\n<br />##lang.cartridge.item## :\n##cartridge.item##<br /> <br />\n##lang.cartridge.reference## :\n##cartridge.reference##<br />\n##lang.cartridge.remaining## :\n##cartridge.remaining##<br />\n<a href=\"##cartridge.url##\">\n##cartridge.url##</a><br />\n##ENDFOREACHcartridges##</p>'), (11, 10, '', '##infocom.action## ##infocom.entity##', '##lang.infocom.entity## : ##infocom.entity##\n\n\n##FOREACHinfocoms##\n\n##lang.infocom.itemtype## : ##infocom.itemtype##\n\n##lang.infocom.item## : ##infocom.item##\n\n\n##lang.infocom.expirationdate## : ##infocom.expirationdate##\n\n##infocom.url##\n ##ENDFOREACHinfocoms##', '<p>##lang.infocom.entity## : ##infocom.entity##\n<br /> <br />##FOREACHinfocoms##\n<br />##lang.infocom.itemtype## : ##infocom.itemtype##<br />\n##lang.infocom.item## : ##infocom.item##<br /> <br />\n##lang.infocom.expirationdate## : ##infocom.expirationdate##\n<br /> <a href=\"##infocom.url##\">\n##infocom.url##</a><br />\n##ENDFOREACHinfocoms##</p>'), (12, 11, '', '##license.action## ##license.entity##', '##lang.license.entity## : ##license.entity##\n\n##FOREACHlicenses##\n\n##lang.license.item## : ##license.item##\n\n##lang.license.serial## : ##license.serial##\n\n##lang.license.expirationdate## : ##license.expirationdate##\n\n##license.url##\n ##ENDFOREACHlicenses##', '<p>\n##lang.license.entity## : ##license.entity##<br />\n##FOREACHlicenses##\n<br />##lang.license.item## : ##license.item##<br />\n##lang.license.serial## : ##license.serial##<br />\n##lang.license.expirationdate## : ##license.expirationdate##\n<br /> <a href=\"##license.url##\"> ##license.url##\n</a><br /> ##ENDFOREACHlicenses##</p>'), (13, 13, '', '##user.action##', '##user.realname## ##user.firstname##\n\n##lang.passwordforget.information##\n\n##lang.passwordforget.link## ##user.passwordforgeturl##', '<p><strong>##user.realname## ##user.firstname##</strong></p>\n<p>##lang.passwordforget.information##</p>\n<p>##lang.passwordforget.link## <a title=\"##user.passwordforgeturl##\" href=\"##user.passwordforgeturl##\">##user.passwordforgeturl##</a></p>'), (14, 14, '', '##ticket.action## ##ticket.title##', '##lang.ticket.title## : ##ticket.title##\n\n##lang.ticket.closedate## : ##ticket.closedate##\n\n##lang.satisfaction.text## ##ticket.urlsatisfaction##', '<p>##lang.ticket.title## : ##ticket.title##</p>\n<p>##lang.ticket.closedate## : ##ticket.closedate##</p>\n<p>##lang.satisfaction.text## <a href=\"##ticket.urlsatisfaction##\">##ticket.urlsatisfaction##</a></p>'), (15, 15, '', '##lang.unicity.action##', '##lang.unicity.entity## : ##unicity.entity##\n\n##lang.unicity.itemtype## : ##unicity.itemtype##\n\n##lang.unicity.message## : ##unicity.message##\n\n##lang.unicity.action_user## : ##unicity.action_user##\n\n##lang.unicity.action_type## : ##unicity.action_type##\n\n##lang.unicity.date## : ##unicity.date##', '<p>##lang.unicity.entity## : ##unicity.entity##</p>\n<p>##lang.unicity.itemtype## : ##unicity.itemtype##</p>\n<p>##lang.unicity.message## : ##unicity.message##</p>\n<p>##lang.unicity.action_user## : ##unicity.action_user##</p>\n<p>##lang.unicity.action_type## : ##unicity.action_type##</p>\n<p>##lang.unicity.date## : ##unicity.date##</p>'), (16, 16, '', '##crontask.action##', '##lang.crontask.warning##\n\n##FOREACHcrontasks##\n ##crontask.name## : ##crontask.description##\n\n##ENDFOREACHcrontasks##', '<p>##lang.crontask.warning##</p>\n<p>##FOREACHcrontasks## <br /><a href=\"##crontask.url##\">##crontask.name##</a> : ##crontask.description##<br /> <br />##ENDFOREACHcrontasks##</p>'), (17, 17, '', '##problem.action## ##problem.title##', '##IFproblem.storestatus=5##\n ##lang.problem.url## : ##problem.urlapprove##\n ##lang.problem.solvedate## : ##problem.solvedate##\n ##lang.problem.solution.type## : ##problem.solution.type##\n ##lang.problem.solution.description## : ##problem.solution.description## ##ENDIFproblem.storestatus##\n ##ELSEproblem.storestatus## ##lang.problem.url## : ##problem.url## ##ENDELSEproblem.storestatus##\n\n ##lang.problem.description##\n\n ##lang.problem.title## :##problem.title##\n ##lang.problem.authors## :##IFproblem.authors## ##problem.authors## ##ENDIFproblem.authors## ##ELSEproblem.authors##--##ENDELSEproblem.authors##\n ##lang.problem.creationdate## :##problem.creationdate##\n ##IFproblem.assigntousers## ##lang.problem.assigntousers## : ##problem.assigntousers## ##ENDIFproblem.assigntousers##\n ##lang.problem.status## : ##problem.status##\n ##IFproblem.assigntogroups## ##lang.problem.assigntogroups## : ##problem.assigntogroups## ##ENDIFproblem.assigntogroups##\n ##lang.problem.urgency## : ##problem.urgency##\n ##lang.problem.impact## : ##problem.impact##\n ##lang.problem.priority## : ##problem.priority##\n##IFproblem.category## ##lang.problem.category## :##problem.category## ##ENDIFproblem.category## ##ELSEproblem.category## ##lang.problem.nocategoryassigned## ##ENDELSEproblem.category##\n ##lang.problem.content## : ##problem.content##\n\n##IFproblem.storestatus=6##\n ##lang.problem.solvedate## : ##problem.solvedate##\n ##lang.problem.solution.type## : ##problem.solution.type##\n ##lang.problem.solution.description## : ##problem.solution.description##\n##ENDIFproblem.storestatus##\n ##lang.problem.numberoffollowups## : ##problem.numberoffollowups##\n\n##FOREACHfollowups##\n\n [##followup.date##] ##lang.followup.isprivate## : ##followup.isprivate##\n ##lang.followup.author## ##followup.author##\n ##lang.followup.description## ##followup.description##\n ##lang.followup.date## ##followup.date##\n ##lang.followup.requesttype## ##followup.requesttype##\n\n##ENDFOREACHfollowups##\n ##lang.problem.numberoftickets## : ##problem.numberoftickets##\n\n##FOREACHtickets##\n [##ticket.date##] ##lang.problem.title## : ##ticket.title##\n ##lang.problem.content## ##ticket.content##\n\n##ENDFOREACHtickets##\n ##lang.problem.numberoftasks## : ##problem.numberoftasks##\n\n##FOREACHtasks##\n [##task.date##]\n ##lang.task.author## ##task.author##\n ##lang.task.description## ##task.description##\n ##lang.task.time## ##task.time##\n ##lang.task.category## ##task.category##\n\n##ENDFOREACHtasks##\n', '<p>##IFproblem.storestatus=5##</p>\n<div>##lang.problem.url## : <a href=\"##problem.urlapprove##\">##problem.urlapprove##</a></div>\n<div><span style=\"color: #888888;\"><strong><span style=\"text-decoration: underline;\">##lang.problem.solvedate##</span></strong></span> : ##problem.solvedate##<br /><span style=\"text-decoration: underline; color: #888888;\"><strong>##lang.problem.solution.type##</strong></span> : ##problem.solution.type##<br /><span style=\"text-decoration: underline; color: #888888;\"><strong>##lang.problem.solution.description##</strong></span> : ##problem.solution.description## ##ENDIFproblem.storestatus##</div>\n<div>##ELSEproblem.storestatus## ##lang.problem.url## : <a href=\"##problem.url##\">##problem.url##</a> ##ENDELSEproblem.storestatus##</div>\n<p class=\"description b\"><strong>##lang.problem.description##</strong></p>\n<p><span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.problem.title##</span> :##problem.title## <br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.problem.authors##</span> :##IFproblem.authors## ##problem.authors## ##ENDIFproblem.authors## ##ELSEproblem.authors##--##ENDELSEproblem.authors## <br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.problem.creationdate##</span> :##problem.creationdate## <br /> ##IFproblem.assigntousers## <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.problem.assigntousers##</span> : ##problem.assigntousers## ##ENDIFproblem.assigntousers##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\">##lang.problem.status## </span> : ##problem.status##<br /> ##IFproblem.assigntogroups## <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.problem.assigntogroups##</span> : ##problem.assigntogroups## ##ENDIFproblem.assigntogroups##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.problem.urgency##</span> : ##problem.urgency##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.problem.impact##</span> : ##problem.impact##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.problem.priority##</span> : ##problem.priority## <br />##IFproblem.category##<span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\">##lang.problem.category## </span> :##problem.category## ##ENDIFproblem.category## ##ELSEproblem.category## ##lang.problem.nocategoryassigned## ##ENDELSEproblem.category## <br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.problem.content##</span> : ##problem.content##</p>\n<p>##IFproblem.storestatus=6##<br /><span style=\"text-decoration: underline;\"><strong><span style=\"color: #888888;\">##lang.problem.solvedate##</span></strong></span> : ##problem.solvedate##<br /><span style=\"color: #888888;\"><strong><span style=\"text-decoration: underline;\">##lang.problem.solution.type##</span></strong></span> : ##problem.solution.type##<br /><span style=\"text-decoration: underline; color: #888888;\"><strong>##lang.problem.solution.description##</strong></span> : ##problem.solution.description##<br />##ENDIFproblem.storestatus##</p>\n
##lang.problem.numberoffollowups## : ##problem.numberoffollowups##
\n

##FOREACHfollowups##

\n

[##followup.date##] ##lang.followup.isprivate## : ##followup.isprivate##
##lang.followup.author## ##followup.author##
##lang.followup.description## ##followup.description##
##lang.followup.date## ##followup.date##
##lang.followup.requesttype## ##followup.requesttype##
\n

##ENDFOREACHfollowups##

\n<div class=\"description b\">##lang.problem.numberoftickets## : ##problem.numberoftickets##</div>\n<p>##FOREACHtickets##</p>\n<div><strong> [##ticket.date##] <em>##lang.problem.title## : <a href=\"##ticket.url##\">##ticket.title## </a></em></strong><br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> </span><span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\">##lang.problem.content## </span> ##ticket.content##\n<p>##ENDFOREACHtickets##</p>\n<div class=\"description b\">##lang.problem.numberoftasks## : ##problem.numberoftasks##</div>\n<p>##FOREACHtasks##</p>\n<div class=\"description b\"><strong>[##task.date##] </strong><br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.task.author##</span> ##task.author##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.task.description##</span> ##task.description##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.task.time##</span> ##task.time##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.task.category##</span> ##task.category##</div>\n<p>##ENDFOREACHtasks##</p>\n</div>'), (18, 18, '', '##recall.action##: ##recall.item.name##', '##recall.action##: ##recall.item.name##\n\n##recall.item.content##\n\n##lang.recall.planning.begin##: ##recall.planning.begin##\n##lang.recall.planning.end##: ##recall.planning.end##\n##lang.recall.planning.state##: ##recall.planning.state##\n##lang.recall.item.private##: ##recall.item.private##', '<p>##recall.action##: <a href=\"##recall.item.url##\">##recall.item.name##</a></p>\n<p>##recall.item.content##</p>\n<p>##lang.recall.planning.begin##: ##recall.planning.begin##<br />##lang.recall.planning.end##: ##recall.planning.end##<br />##lang.recall.planning.state##: ##recall.planning.state##<br />##lang.recall.item.private##: ##recall.item.private##<br /><br /></p>\n<p><br /><br /></p>'), (19, 19, '', '##change.action## ##change.title##', '##IFchange.storestatus=5##\n ##lang.change.url## : ##change.urlapprove##\n ##lang.change.solvedate## : ##change.solvedate##\n ##lang.change.solution.type## : ##change.solution.type##\n ##lang.change.solution.description## : ##change.solution.description## ##ENDIFchange.storestatus##\n ##ELSEchange.storestatus## ##lang.change.url## : ##change.url## ##ENDELSEchange.storestatus##\n\n ##lang.change.description##\n\n ##lang.change.title## :##change.title##\n ##lang.change.authors## :##IFchange.authors## ##change.authors## ##ENDIFchange.authors## ##ELSEchange.authors##--##ENDELSEchange.authors##\n ##lang.change.creationdate## :##change.creationdate##\n ##IFchange.assigntousers## ##lang.change.assigntousers## : ##change.assigntousers## ##ENDIFchange.assigntousers##\n ##lang.change.status## : ##change.status##\n ##IFchange.assigntogroups## ##lang.change.assigntogroups## : ##change.assigntogroups## ##ENDIFchange.assigntogroups##\n ##lang.change.urgency## : ##change.urgency##\n ##lang.change.impact## : ##change.impact##\n ##lang.change.priority## : ##change.priority##\n##IFchange.category## ##lang.change.category## :##change.category## ##ENDIFchange.category## ##ELSEchange.category## ##lang.change.nocategoryassigned## ##ENDELSEchange.category##\n ##lang.change.content## : ##change.content##\n\n##IFchange.storestatus=6##\n ##lang.change.solvedate## : ##change.solvedate##\n ##lang.change.solution.type## : ##change.solution.type##\n ##lang.change.solution.description## : ##change.solution.description##\n##ENDIFchange.storestatus##\n ##lang.change.numberoffollowups## : ##change.numberoffollowups##\n\n##FOREACHfollowups##\n\n [##followup.date##] ##lang.followup.isprivate## : ##followup.isprivate##\n ##lang.followup.author## ##followup.author##\n ##lang.followup.description## ##followup.description##\n ##lang.followup.date## ##followup.date##\n ##lang.followup.requesttype## ##followup.requesttype##\n\n##ENDFOREACHfollowups##\n ##lang.change.numberofproblems## : ##change.numberofproblems##\n\n##FOREACHproblems##\n [##problem.date##] ##lang.change.title## : ##problem.title##\n ##lang.change.content## ##problem.content##\n\n##ENDFOREACHproblems##\n ##lang.change.numberoftasks## : ##change.numberoftasks##\n\n##FOREACHtasks##\n [##task.date##]\n ##lang.task.author## ##task.author##\n ##lang.task.description## ##task.description##\n ##lang.task.time## ##task.time##\n ##lang.task.category## ##task.category##\n\n##ENDFOREACHtasks##\n', '<p>##IFchange.storestatus=5##</p>\n<div>##lang.change.url## : <a href=\"##change.urlapprove##\">##change.urlapprove##</a></div>\n<div><span style=\"color: #888888;\"><strong><span style=\"text-decoration: underline;\">##lang.change.solvedate##</span></strong></span> : ##change.solvedate##<br /><span style=\"text-decoration: underline; color: #888888;\"><strong>##lang.change.solution.type##</strong></span> : ##change.solution.type##<br /><span style=\"text-decoration: underline; color: #888888;\"><strong>##lang.change.solution.description##</strong></span> : ##change.solution.description## ##ENDIFchange.storestatus##</div>\n<div>##ELSEchange.storestatus## ##lang.change.url## : <a href=\"##change.url##\">##change.url##</a> ##ENDELSEchange.storestatus##</div>\n<p class=\"description b\"><strong>##lang.change.description##</strong></p>\n<p><span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.change.title##</span> :##change.title## <br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.change.authors##</span> :##IFchange.authors## ##change.authors## ##ENDIFchange.authors## ##ELSEchange.authors##--##ENDELSEchange.authors## <br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.change.creationdate##</span> :##change.creationdate## <br /> ##IFchange.assigntousers## <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.change.assigntousers##</span> : ##change.assigntousers## ##ENDIFchange.assigntousers##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\">##lang.change.status## </span> : ##change.status##<br /> ##IFchange.assigntogroups## <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.change.assigntogroups##</span> : ##change.assigntogroups## ##ENDIFchange.assigntogroups##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.change.urgency##</span> : ##change.urgency##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.change.impact##</span> : ##change.impact##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.change.priority##</span> : ##change.priority## <br />##IFchange.category##<span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\">##lang.change.category## </span> :##change.category## ##ENDIFchange.category## ##ELSEchange.category## ##lang.change.nocategoryassigned## ##ENDELSEchange.category## <br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.change.content##</span> : ##change.content##</p>\n<p>##IFchange.storestatus=6##<br /><span style=\"text-decoration: underline;\"><strong><span style=\"color: #888888;\">##lang.change.solvedate##</span></strong></span> : ##change.solvedate##<br /><span style=\"color: #888888;\"><strong><span style=\"text-decoration: underline;\">##lang.change.solution.type##</span></strong></span> : ##change.solution.type##<br /><span style=\"text-decoration: underline; color: #888888;\"><strong>##lang.change.solution.description##</strong></span> : ##change.solution.description##<br />##ENDIFchange.storestatus##</p>\n
##lang.change.numberoffollowups## : ##change.numberoffollowups##
\n

##FOREACHfollowups##

\n

[##followup.date##] ##lang.followup.isprivate## : ##followup.isprivate##
##lang.followup.author## ##followup.author##
##lang.followup.description## ##followup.description##
##lang.followup.date## ##followup.date##
##lang.followup.requesttype## ##followup.requesttype##
\n

##ENDFOREACHfollowups##

\n<div class=\"description b\">##lang.change.numberofproblems## : ##change.numberofproblems##</div>\n<p>##FOREACHproblems##</p>\n<div><strong> [##problem.date##] <em>##lang.change.title## : <a href=\"##problem.url##\">##problem.title## </a></em></strong><br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> </span><span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\">##lang.change.content## </span> ##problem.content##\n<p>##ENDFOREACHproblems##</p>\n<div class=\"description b\">##lang.change.numberoftasks## : ##change.numberoftasks##</div>\n<p>##FOREACHtasks##</p>\n<div class=\"description b\"><strong>[##task.date##] </strong><br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.task.author##</span> ##task.author##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.task.description##</span> ##task.description##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.task.time##</span> ##task.time##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.task.category##</span> ##task.category##</div>\n<p>##ENDFOREACHtasks##</p>\n</div>'), (20, 20, '', '##mailcollector.action##', '##FOREACHmailcollectors##\n##lang.mailcollector.name## : ##mailcollector.name##\n##lang.mailcollector.errors## : ##mailcollector.errors##\n##mailcollector.url##\n##ENDFOREACHmailcollectors##', '<p>##FOREACHmailcollectors##<br />##lang.mailcollector.name## : ##mailcollector.name##<br /> ##lang.mailcollector.errors## : ##mailcollector.errors##<br /><a href=\"##mailcollector.url##\">##mailcollector.url##</a><br /> ##ENDFOREACHmailcollectors##</p>\n<p></p>'), (21, 21, '', '##project.action## ##project.name## ##project.code##', '##lang.project.url## : ##project.url##\n\n##lang.project.description##\n\n##lang.project.name## : ##project.name##\n##lang.project.code## : ##project.code##\n##lang.project.manager## : ##project.manager##\n##lang.project.managergroup## : ##project.managergroup##\n##lang.project.creationdate## : ##project.creationdate##\n##lang.project.priority## : ##project.priority##\n##lang.project.state## : ##project.state##\n##lang.project.type## : ##project.type##\n##lang.project.description## : ##project.description##\n\n##lang.project.numberoftasks## : ##project.numberoftasks##\n\n\n\n##FOREACHtasks##\n\n[##task.creationdate##]\n##lang.task.name## : ##task.name##\n##lang.task.state## : ##task.state##\n##lang.task.type## : ##task.type##\n##lang.task.percent## : ##task.percent##\n##lang.task.description## : ##task.description##\n\n##ENDFOREACHtasks##', '<p>##lang.project.url## : <a href=\"##project.url##\">##project.url##</a></p>\n<p><strong>##lang.project.description##</strong></p>\n<p>##lang.project.name## : ##project.name##<br />##lang.project.code## : ##project.code##<br /> ##lang.project.manager## : ##project.manager##<br />##lang.project.managergroup## : ##project.managergroup##<br /> ##lang.project.creationdate## : ##project.creationdate##<br />##lang.project.priority## : ##project.priority## <br />##lang.project.state## : ##project.state##<br />##lang.project.type## : ##project.type##<br />##lang.project.description## : ##project.description##</p>\n<p>##lang.project.numberoftasks## : ##project.numberoftasks##</p>\n<div>\n<p>##FOREACHtasks##</p>\n<div><strong>[##task.creationdate##] </strong><br /> ##lang.task.name## : ##task.name##<br />##lang.task.state## : ##task.state##<br />##lang.task.type## : ##task.type##<br />##lang.task.percent## : ##task.percent##<br />##lang.task.description## : ##task.description##</div>\n<p>##ENDFOREACHtasks##</p>\n</div>'), (22, 22, '', '##projecttask.action## ##projecttask.name##', '##lang.projecttask.url## : ##projecttask.url##\n\n##lang.projecttask.description##\n\n##lang.projecttask.name## : ##projecttask.name##\n##lang.projecttask.project## : ##projecttask.project##\n##lang.projecttask.creationdate## : ##projecttask.creationdate##\n##lang.projecttask.state## : ##projecttask.state##\n##lang.projecttask.type## : ##projecttask.type##\n##lang.projecttask.description## : ##projecttask.description##\n\n##lang.projecttask.numberoftasks## : ##projecttask.numberoftasks##\n\n\n\n##FOREACHtasks##\n\n[##task.creationdate##]\n##lang.task.name## : ##task.name##\n##lang.task.state## : ##task.state##\n##lang.task.type## : ##task.type##\n##lang.task.percent## : ##task.percent##\n##lang.task.description## : ##task.description##\n\n##ENDFOREACHtasks##', '<p>##lang.projecttask.url## : <a href=\"##projecttask.url##\">##projecttask.url##</a></p>\n<p><strong>##lang.projecttask.description##</strong></p>\n<p>##lang.projecttask.name## : ##projecttask.name##<br />##lang.projecttask.project## : <a href=\"##projecttask.projecturl##\">##projecttask.project##</a><br />##lang.projecttask.creationdate## : ##projecttask.creationdate##<br />##lang.projecttask.state## : ##projecttask.state##<br />##lang.projecttask.type## : ##projecttask.type##<br />##lang.projecttask.description## : ##projecttask.description##</p>\n<p>##lang.projecttask.numberoftasks## : ##projecttask.numberoftasks##</p>\n<div>\n<p>##FOREACHtasks##</p>\n<div><strong>[##task.creationdate##] </strong><br />##lang.task.name## : ##task.name##<br />##lang.task.state## : ##task.state##<br />##lang.task.type## : ##task.type##<br />##lang.task.percent## : ##task.percent##<br />##lang.task.description## : ##task.description##</div>\n<p>##ENDFOREACHtasks##</p>\n</div>'), (23, 23, '', '##objectlock.action##', '##objectlock.type## ###objectlock.id## - ##objectlock.name##\n\n ##lang.objectlock.url##\n ##objectlock.url##\n\n ##lang.objectlock.date_mod##\n ##objectlock.date_mod##\n\n Hello ##objectlock.lockedby.firstname##,\n Could go to this item and unlock it for me?\n Thank you,\n Regards,\n ##objectlock.requester.firstname##', '<table>\n <tbody>\n <tr><th colspan=\"2\"><a href=\"##objectlock.url##\">##objectlock.type## ###objectlock.id## - ##objectlock.name##</a></th></tr>\n <tr>\n <td>##lang.objectlock.url##</td>\n <td>##objectlock.url##</td>\n </tr>\n <tr>\n <td>##lang.objectlock.date_mod##</td>\n <td>##objectlock.date_mod##</td>\n </tr>\n </tbody>\n </table>\n <p><span style=\"font-size: small;\">Hello ##objectlock.lockedby.firstname##,<br />Could go to this item and unlock it for me?<br />Thank you,<br />Regards,<br />##objectlock.requester.firstname## ##objectlock.requester.lastname##</span></p>'), (24, 24, '', '##savedsearch.action## ##savedsearch.name##', '##savedsearch.type## ###savedsearch.id## - ##savedsearch.name##\n\n ##savedsearch.message##\n\n ##lang.savedsearch.url##\n ##savedsearch.url##\n\n Regards,', '<table>\n <tbody>\n <tr><th colspan=\"2\"><a href=\"##savedsearch.url##\">##savedsearch.type## ###savedsearch.id## - ##savedsearch.name##</a></th></tr>\n <tr><td colspan=\"2\"><a href=\"##savedsearch.url##\">##savedsearch.message##</a></td></tr>\n <tr>\n <td>##lang.savedsearch.url##</td>\n <td>##savedsearch.url##</td>\n </tr>\n </tbody>\n </table>\n <p><span style=\"font-size: small;\">Hello <br />Regards,</span></p>'), (25, 25, '', '##certificate.action## ##certificate.entity##', '##lang.certificate.entity## : ##certificate.entity##\n\n##FOREACHcertificates##\n\n##lang.certificate.serial## : ##certificate.serial##\n\n##lang.certificate.expirationdate## : ##certificate.expirationdate##\n\n##certificate.url##\n ##ENDFOREACHcertificates##', '<p>\n##lang.certificate.entity## : ##certificate.entity##<br />\n##FOREACHcertificates##\n<br />##lang.certificate.name## : ##certificate.name##<br />\n##lang.certificate.serial## : ##certificate.serial##<br />\n##lang.certificate.expirationdate## : ##certificate.expirationdate##\n<br /> <a href=\"##certificate.url##\"> ##certificate.url##\n</a><br /> ##ENDFOREACHcertificates##</p>'), (26, 26, '', '##domain.action## : ##domain.entity##', '##lang.domain.entity## :##domain.entity##\n ##FOREACHdomains##\n ##lang.domain.name## : ##domain.name## - ##lang.domain.dateexpiration## : ##domain.dateexpiration##\n ##ENDFOREACHdomains##', '<p>##lang.domain.entity## :##domain.entity##<br /> <br />\n ##FOREACHdomains##<br />\n ##lang.domain.name## : ##domain.name## - ##lang.domain.dateexpiration## : ##domain.dateexpiration##<br />\n ##ENDFOREACHdomains##</p>'), (27, 27, '', '##user.action##', '##user.realname## ##user.firstname##,\n\n##IFuser.password.has_expired=1##\n##lang.password.has_expired.information##\n##ENDIFuser.password.has_expired##\n##ELSEuser.password.has_expired##\n##lang.password.expires_soon.information##\n##ENDELSEuser.password.has_expired##\n##lang.user.password.expiration.date##: ##user.password.expiration.date##\n##IFuser.account.lock.date##\n##lang.user.account.lock.date##: ##user.account.lock.date##\n##ENDIFuser.account.lock.date##\n\n##password.update.link## ##user.password.update.url##', '<p><strong>##user.realname## ##user.firstname##</strong></p>\n\n##IFuser.password.has_expired=1##\n<p>##lang.password.has_expired.information##</p>\n##ENDIFuser.password.has_expired##\n##ELSEuser.password.has_expired##\n<p>##lang.password.expires_soon.information##</p>\n##ENDELSEuser.password.has_expired##\n<p>##lang.user.password.expiration.date##: ##user.password.expiration.date##</p>\n##IFuser.account.lock.date##\n<p>##lang.user.account.lock.date##: ##user.account.lock.date##</p>\n##ENDIFuser.account.lock.date##\n\n<p>##lang.password.update.link## <a href=\"##user.password.update.url##\">##user.password.update.url##</a></p>'), (28, 28, '', '##lang.plugins_updates_available##', '##lang.plugins_updates_available##\n\n##FOREACHplugins##\n##plugin.name## :##plugin.old_version## -> ##plugin.version##\n##ENDFOREACHplugins##', '<p>##lang.plugins_updates_available##</p>\n<ul>##FOREACHplugins##\n<li>##plugin.name## :##plugin.old_version## -> ##plugin.version##</li>\n##ENDFOREACHplugins##</ul>'); INSERT INTO `glpi_problemtemplatemandatoryfields` (`id`, `problemtemplates_id`, `num`) VALUES (1, 1, 21); INSERT INTO `glpi_problemtemplates` (`id`, `name`, `entities_id`, `is_recursive`, `comment`) VALUES (1, 'Default', 0, 1, NULL); INSERT INTO `glpi_profilerights` (`id`, `profiles_id`, `name`, `rights`) 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), (11, 6, 'queuednotification', 0), (12, 1, 'contact_enterprise', 0), (13, 1, 'document', 0), (14, 1, 'contract', 0), (15, 1, 'infocom', 0), (16, 1, 'knowbase', 2048), (17, 1, 'reservation', 1024), (18, 1, 'reports', 0), (19, 1, 'dropdown', 0), (20, 1, 'device', 0), (21, 1, 'typedoc', 0), (22, 1, 'link', 0), (23, 1, 'config', 0), (24, 1, 'rule_ticket', 0), (25, 1, 'rule_import', 0), (26, 1, 'rule_ldap', 0), (27, 1, 'rule_softwarecategories', 0), (28, 1, 'search_config', 0), (29, 5, 'location', 0), (30, 7, 'domain', 23), (31, 1, 'profile', 0), (32, 1, 'user', 0), (33, 1, 'group', 0), (34, 1, 'entity', 0), (35, 1, 'transfer', 0), (36, 1, 'logs', 0), (37, 1, 'reminder_public', 1), (38, 1, 'rssfeed_public', 1), (39, 1, 'bookmark_public', 0), (40, 1, 'backup', 0), (41, 1, 'ticket', 5), (42, 1, 'followup', 5), (43, 1, 'task', 1), (44, 1, 'planning', 0), (45, 2, 'state', 0), (46, 2, 'taskcategory', 0), (47, 1, 'statistic', 0), (48, 1, 'password_update', 1), (49, 1, 'show_group_hardware', 0), (50, 1, 'rule_dictionnary_software', 0), (51, 1, 'rule_dictionnary_dropdown', 0), (52, 1, 'budget', 0), (53, 1, 'notification', 0), (54, 1, 'rule_mailcollector', 0), (55, 7, 'solutiontemplate', 23), (56, 1, 'calendar', 0), (57, 1, 'slm', 0), (58, 1, 'rule_dictionnary_printer', 0), (59, 1, 'problem', 0), (60, 2, 'netpoint', 0), (61, 4, 'knowbasecategory', 23), (62, 5, 'itilcategory', 0), (63, 1, 'itiltemplate', 0), (64, 1, 'ticketrecurrent', 0), (65, 1, 'ticketcost', 0), (66, 6, 'changevalidation', 20), (67, 1, 'ticketvalidation', 0), (68, 2, 'computer', 33), (69, 2, 'monitor', 33), (70, 2, 'software', 33), (71, 2, 'networking', 33), (72, 2, 'internet', 1), (73, 2, 'printer', 33), (74, 2, 'peripheral', 33), (75, 2, 'cartridge', 33), (76, 2, 'consumable', 33), (77, 2, 'phone', 33), (78, 5, 'queuednotification', 0), (79, 2, 'contact_enterprise', 33), (80, 2, 'document', 33), (81, 2, 'contract', 33), (82, 2, 'infocom', 1), (83, 2, 'knowbase', 10241), (84, 2, 'reservation', 1025), (85, 2, 'reports', 1), (86, 2, 'dropdown', 0), (87, 2, 'device', 0), (88, 2, 'typedoc', 1), (89, 2, 'link', 1), (90, 2, 'config', 0), (91, 2, 'rule_ticket', 0), (92, 2, 'rule_import', 0), (93, 2, 'rule_ldap', 0), (94, 2, 'rule_softwarecategories', 0), (95, 2, 'search_config', 1024), (96, 4, 'location', 23), (97, 6, 'domain', 0), (98, 2, 'profile', 0), (99, 2, 'user', 2049), (100, 2, 'group', 33), (101, 2, 'entity', 0), (102, 2, 'transfer', 0), (103, 2, 'logs', 0), (104, 2, 'reminder_public', 1), (105, 2, 'rssfeed_public', 1), (106, 2, 'bookmark_public', 0), (107, 2, 'backup', 0), (108, 2, 'ticket', 168989), (109, 2, 'followup', 5), (110, 2, 'task', 1), (111, 6, 'projecttask', 1025), (112, 7, 'projecttask', 1025), (113, 2, 'planning', 1), (114, 1, 'state', 0), (115, 1, 'taskcategory', 0), (116, 2, 'statistic', 1), (117, 2, 'password_update', 1), (118, 2, 'show_group_hardware', 0), (119, 2, 'rule_dictionnary_software', 0), (120, 2, 'rule_dictionnary_dropdown', 0), (121, 2, 'budget', 33), (122, 2, 'notification', 0), (123, 2, 'rule_mailcollector', 0), (124, 5, 'solutiontemplate', 0), (125, 6, 'solutiontemplate', 0), (126, 2, 'calendar', 0), (127, 2, 'slm', 0), (128, 2, 'rule_dictionnary_printer', 0), (129, 2, 'problem', 1057), (130, 1, 'netpoint', 0), (131, 3, 'knowbasecategory', 23), (132, 4, 'itilcategory', 23), (133, 2, 'itiltemplate', 0), (134, 2, 'ticketrecurrent', 0), (135, 2, 'ticketcost', 1), (136, 4, 'changevalidation', 1044), (137, 5, 'changevalidation', 20), (138, 2, 'ticketvalidation', 15376), (139, 3, 'computer', 127), (140, 3, 'monitor', 127), (141, 3, 'software', 127), (142, 3, 'networking', 127), (143, 3, 'internet', 31), (144, 3, 'printer', 127), (145, 3, 'peripheral', 127), (146, 3, 'cartridge', 127), (147, 3, 'consumable', 127), (148, 3, 'phone', 127), (149, 4, 'queuednotification', 31), (150, 3, 'contact_enterprise', 127), (151, 3, 'document', 127), (152, 3, 'contract', 127), (153, 3, 'infocom', 23), (154, 3, 'knowbase', 14359), (155, 3, 'reservation', 1055), (156, 3, 'reports', 1), (157, 3, 'dropdown', 23), (158, 3, 'device', 23), (159, 3, 'typedoc', 23), (160, 3, 'link', 23), (161, 3, 'config', 0), (162, 3, 'rule_ticket', 1047), (163, 3, 'rule_import', 0), (164, 3, 'rule_ldap', 0), (165, 3, 'rule_softwarecategories', 0), (166, 3, 'search_config', 3072), (167, 3, 'location', 23), (168, 5, 'domain', 0), (169, 3, 'profile', 1), (170, 3, 'user', 7199), (171, 3, 'group', 119), (172, 3, 'entity', 33), (173, 3, 'transfer', 1), (174, 3, 'logs', 1), (175, 3, 'reminder_public', 23), (176, 3, 'rssfeed_public', 23), (177, 3, 'bookmark_public', 23), (178, 3, 'backup', 1024), (179, 3, 'ticket', 261151), (180, 3, 'followup', 15383), (181, 3, 'task', 13329), (182, 3, 'projecttask', 1121), (183, 4, 'projecttask', 1121), (184, 5, 'projecttask', 0), (185, 3, 'planning', 3073), (186, 7, 'taskcategory', 23), (187, 7, 'netpoint', 23), (188, 3, 'statistic', 1), (189, 3, 'password_update', 1), (190, 3, 'show_group_hardware', 0), (191, 3, 'rule_dictionnary_software', 0), (192, 3, 'rule_dictionnary_dropdown', 0), (193, 3, 'budget', 127), (194, 3, 'notification', 0), (195, 3, 'rule_mailcollector', 23), (196, 3, 'solutiontemplate', 23), (197, 4, 'solutiontemplate', 23), (198, 3, 'calendar', 23), (199, 3, 'slm', 23), (200, 3, 'rule_dictionnary_printer', 0), (201, 3, 'problem', 1151), (202, 2, 'knowbasecategory', 0), (203, 3, 'itilcategory', 23), (204, 3, 'itiltemplate', 23), (205, 3, 'ticketrecurrent', 1), (206, 3, 'ticketcost', 23), (207, 2, 'changevalidation', 1044), (208, 3, 'changevalidation', 1044), (209, 3, 'ticketvalidation', 15376), (210, 4, 'computer', 255), (211, 4, 'monitor', 255), (212, 4, 'software', 255), (213, 4, 'networking', 255), (214, 4, 'internet', 159), (215, 4, 'printer', 255), (216, 4, 'peripheral', 255), (217, 4, 'cartridge', 255), (218, 4, 'consumable', 255), (219, 4, 'phone', 255), (220, 4, 'contact_enterprise', 255), (221, 4, 'document', 255), (222, 4, 'contract', 255), (223, 4, 'infocom', 23), (224, 4, 'knowbase', 15383), (225, 4, 'reservation', 1055), (226, 4, 'reports', 1), (227, 4, 'dropdown', 23), (228, 4, 'device', 23), (229, 4, 'typedoc', 23), (230, 4, 'link', 159), (231, 4, 'config', 3), (232, 4, 'rule_ticket', 1047), (233, 4, 'rule_import', 23), (234, 4, 'rule_ldap', 23), (235, 4, 'rule_softwarecategories', 23), (236, 4, 'search_config', 3072), (237, 2, 'location', 0), (238, 4, 'domain', 23), (239, 4, 'profile', 23), (240, 4, 'user', 7327), (241, 4, 'group', 119), (242, 4, 'entity', 3327), (243, 4, 'transfer', 23), (244, 4, 'logs', 1), (245, 4, 'reminder_public', 159), (246, 4, 'rssfeed_public', 159), (247, 4, 'bookmark_public', 23), (248, 4, 'backup', 1045), (249, 4, 'ticket', 261151), (250, 4, 'followup', 15383), (251, 4, 'task', 13329), (252, 7, 'project', 1151), (253, 1, 'projecttask', 0), (254, 2, 'projecttask', 1025), (255, 4, 'planning', 3073), (256, 6, 'taskcategory', 0), (257, 6, 'netpoint', 0), (258, 4, 'statistic', 1), (259, 4, 'password_update', 1), (260, 4, 'show_group_hardware', 1), (261, 4, 'rule_dictionnary_software', 23), (262, 4, 'rule_dictionnary_dropdown', 23), (263, 4, 'budget', 127), (264, 4, 'notification', 23), (265, 4, 'rule_mailcollector', 23), (266, 1, 'solutiontemplate', 0), (267, 2, 'solutiontemplate', 0), (268, 4, 'calendar', 23), (269, 4, 'slm', 23), (270, 4, 'rule_dictionnary_printer', 23), (271, 4, 'problem', 1151), (272, 1, 'knowbasecategory', 0), (273, 2, 'itilcategory', 0), (274, 4, 'itiltemplate', 23), (275, 4, 'ticketrecurrent', 23), (276, 4, 'ticketcost', 23), (277, 7, 'change', 1151), (278, 1, 'changevalidation', 0), (279, 4, 'ticketvalidation', 15376), (280, 5, 'computer', 0), (281, 5, 'monitor', 0), (282, 5, 'software', 0), (283, 5, 'networking', 0), (284, 5, 'internet', 0), (285, 5, 'printer', 0), (286, 5, 'peripheral', 0), (287, 5, 'cartridge', 0), (288, 5, 'consumable', 0), (289, 5, 'phone', 0), (290, 3, 'queuednotification', 0), (291, 5, 'contact_enterprise', 0), (292, 5, 'document', 0), (293, 5, 'contract', 0), (294, 5, 'infocom', 0), (295, 5, 'knowbase', 10240), (296, 5, 'reservation', 0), (297, 5, 'reports', 0), (298, 5, 'dropdown', 0), (299, 5, 'device', 0), (300, 5, 'typedoc', 0), (301, 5, 'link', 0), (302, 5, 'config', 0), (303, 5, 'rule_ticket', 0), (304, 5, 'rule_import', 0), (305, 5, 'rule_ldap', 0), (306, 5, 'rule_softwarecategories', 0), (307, 5, 'search_config', 0), (308, 1, 'location', 0), (309, 3, 'domain', 23), (310, 5, 'profile', 0), (311, 5, 'user', 1025), (312, 5, 'group', 0), (313, 5, 'entity', 0), (314, 5, 'transfer', 0), (315, 5, 'logs', 0), (316, 5, 'reminder_public', 0), (317, 5, 'rssfeed_public', 0), (318, 5, 'bookmark_public', 0), (319, 5, 'backup', 0), (320, 5, 'ticket', 140295), (321, 5, 'followup', 12295), (322, 5, 'task', 8193), (323, 4, 'project', 1151), (324, 5, 'project', 1151), (325, 6, 'project', 1151), (326, 5, 'planning', 1), (327, 5, 'taskcategory', 0), (328, 5, 'netpoint', 0), (329, 5, 'statistic', 1), (330, 5, 'password_update', 1), (331, 5, 'show_group_hardware', 0), (332, 5, 'rule_dictionnary_software', 0), (333, 5, 'rule_dictionnary_dropdown', 0), (334, 5, 'budget', 0), (335, 5, 'notification', 0), (336, 5, 'rule_mailcollector', 0), (337, 6, 'state', 0), (338, 7, 'state', 23), (339, 5, 'calendar', 0), (340, 5, 'slm', 0), (341, 5, 'rule_dictionnary_printer', 0), (342, 5, 'problem', 1024), (343, 7, 'knowbasecategory', 23), (344, 1, 'itilcategory', 0), (345, 5, 'itiltemplate', 0), (346, 5, 'ticketrecurrent', 0), (347, 5, 'ticketcost', 23), (348, 5, 'change', 1054), (349, 6, 'change', 1151), (350, 5, 'ticketvalidation', 3088), (351, 6, 'computer', 127), (352, 6, 'monitor', 127), (353, 6, 'software', 127), (354, 6, 'networking', 127), (355, 6, 'internet', 31), (356, 6, 'printer', 127), (357, 6, 'peripheral', 127), (358, 6, 'cartridge', 127), (359, 6, 'consumable', 127), (360, 6, 'phone', 127), (361, 2, 'queuednotification', 0), (362, 6, 'contact_enterprise', 96), (363, 6, 'document', 127), (364, 6, 'contract', 96), (365, 6, 'infocom', 0), (366, 6, 'knowbase', 14359), (367, 6, 'reservation', 1055), (368, 6, 'reports', 1), (369, 6, 'dropdown', 0), (370, 6, 'device', 0), (371, 6, 'typedoc', 0), (372, 6, 'link', 0), (373, 6, 'config', 0), (374, 6, 'rule_ticket', 0), (375, 6, 'rule_import', 0), (376, 6, 'rule_ldap', 0), (377, 6, 'rule_softwarecategories', 0), (378, 6, 'search_config', 0), (379, 2, 'domain', 0), (380, 6, 'profile', 0), (381, 6, 'user', 1055), (382, 6, 'group', 1), (383, 6, 'entity', 33), (384, 6, 'transfer', 1), (385, 6, 'logs', 0), (386, 6, 'reminder_public', 23), (387, 6, 'rssfeed_public', 23), (388, 6, 'bookmark_public', 0), (389, 6, 'backup', 0), (390, 6, 'ticket', 166919), (391, 6, 'followup', 13319), (392, 6, 'task', 13329), (393, 1, 'project', 0), (394, 2, 'project', 1025), (395, 3, 'project', 1151), (396, 6, 'planning', 1), (397, 4, 'taskcategory', 23), (398, 4, 'netpoint', 23), (399, 6, 'statistic', 1), (400, 6, 'password_update', 1), (401, 6, 'show_group_hardware', 0), (402, 6, 'rule_dictionnary_software', 0), (403, 6, 'rule_dictionnary_dropdown', 0), (404, 6, 'budget', 96), (405, 6, 'notification', 0), (406, 6, 'rule_mailcollector', 0), (407, 4, 'state', 23), (408, 5, 'state', 0), (409, 6, 'calendar', 0), (410, 6, 'slm', 1), (411, 6, 'rule_dictionnary_printer', 0), (412, 6, 'problem', 1121), (413, 6, 'knowbasecategory', 0), (414, 7, 'itilcategory', 23), (415, 7, 'location', 23), (416, 6, 'itiltemplate', 1), (417, 6, 'ticketrecurrent', 1), (418, 6, 'ticketcost', 23), (419, 3, 'change', 1151), (420, 4, 'change', 1151), (421, 6, 'ticketvalidation', 3088), (422, 7, 'computer', 127), (423, 7, 'monitor', 127), (424, 7, 'software', 127), (425, 7, 'networking', 127), (426, 7, 'internet', 31), (427, 7, 'printer', 127), (428, 7, 'peripheral', 127), (429, 7, 'cartridge', 127), (430, 7, 'consumable', 127), (431, 7, 'phone', 127), (432, 1, 'queuednotification', 0), (433, 7, 'contact_enterprise', 96), (434, 7, 'document', 127), (435, 7, 'contract', 96), (436, 7, 'infocom', 0), (437, 7, 'knowbase', 14359), (438, 7, 'reservation', 1055), (439, 7, 'reports', 1), (440, 7, 'dropdown', 0), (441, 7, 'device', 0), (442, 7, 'typedoc', 0), (443, 7, 'link', 0), (444, 7, 'config', 0), (445, 7, 'rule_ticket', 1047), (446, 7, 'rule_import', 0), (447, 7, 'rule_ldap', 0), (448, 7, 'rule_softwarecategories', 0), (449, 7, 'search_config', 0), (450, 1, 'domain', 0), (451, 7, 'profile', 0), (452, 7, 'user', 1055), (453, 7, 'group', 1), (454, 7, 'entity', 33), (455, 7, 'transfer', 1), (456, 7, 'logs', 1), (457, 7, 'reminder_public', 23), (458, 7, 'rssfeed_public', 23), (459, 7, 'bookmark_public', 0), (460, 7, 'backup', 0), (461, 7, 'ticket', 261151), (462, 7, 'followup', 15383), (463, 7, 'task', 13329), (464, 7, 'queuednotification', 0), (465, 7, 'planning', 3073), (466, 3, 'taskcategory', 23), (467, 3, 'netpoint', 23), (468, 7, 'statistic', 1), (469, 7, 'password_update', 1), (470, 7, 'show_group_hardware', 0), (471, 7, 'rule_dictionnary_software', 0), (472, 7, 'rule_dictionnary_dropdown', 0), (473, 7, 'budget', 96), (474, 7, 'notification', 0), (475, 7, 'rule_mailcollector', 23), (476, 7, 'changevalidation', 1044), (477, 3, 'state', 23), (478, 7, 'calendar', 23), (479, 7, 'slm', 23), (480, 7, 'rule_dictionnary_printer', 0), (481, 7, 'problem', 1151), (482, 5, 'knowbasecategory', 0), (483, 6, 'itilcategory', 0), (484, 6, 'location', 0), (485, 7, 'itiltemplate', 23), (486, 7, 'ticketrecurrent', 1), (487, 7, 'ticketcost', 23), (488, 1, 'change', 0), (489, 2, 'change', 1057), (490, 7, 'ticketvalidation', 15376), (491, 8, 'backup', 1), (492, 8, 'bookmark_public', 1), (493, 8, 'budget', 33), (494, 8, 'calendar', 1), (495, 8, 'cartridge', 33), (496, 8, 'change', 1057), (497, 8, 'changevalidation', 0), (498, 8, 'computer', 33), (499, 8, 'config', 1), (500, 8, 'consumable', 33), (501, 8, 'contact_enterprise', 33), (502, 8, 'contract', 33), (503, 8, 'device', 1), (504, 8, 'document', 33), (505, 8, 'domain', 1), (506, 8, 'dropdown', 1), (507, 8, 'entity', 33), (508, 8, 'followup', 8193), (509, 8, 'global_validation', 0), (510, 8, 'group', 33), (511, 8, 'infocom', 1), (512, 8, 'internet', 1), (513, 8, 'itilcategory', 1), (514, 8, 'knowbase', 10241), (515, 8, 'knowbasecategory', 1), (516, 8, 'link', 1), (517, 8, 'location', 1), (518, 8, 'logs', 1), (519, 8, 'monitor', 33), (520, 8, 'netpoint', 1), (521, 8, 'networking', 33), (522, 8, 'notification', 1), (523, 8, 'password_update', 0), (524, 8, 'peripheral', 33), (525, 8, 'phone', 33), (526, 8, 'planning', 3073), (527, 8, 'printer', 33), (528, 8, 'problem', 1057), (529, 8, 'profile', 1), (530, 8, 'project', 1057), (531, 8, 'projecttask', 33), (532, 8, 'queuednotification', 1), (533, 8, 'reminder_public', 1), (534, 8, 'reports', 1), (535, 8, 'reservation', 1), (536, 8, 'rssfeed_public', 1), (537, 8, 'rule_dictionnary_dropdown', 1), (538, 8, 'rule_dictionnary_printer', 1), (539, 8, 'rule_dictionnary_software', 1), (540, 8, 'rule_import', 1), (541, 8, 'rule_ldap', 1), (542, 8, 'rule_mailcollector', 1), (543, 8, 'rule_softwarecategories', 1), (544, 8, 'rule_ticket', 1), (545, 8, 'search_config', 0), (546, 8, 'show_group_hardware', 1), (547, 8, 'slm', 1), (548, 8, 'software', 33), (549, 8, 'solutiontemplate', 1), (550, 8, 'state', 1), (551, 8, 'statistic', 1), (552, 8, 'task', 8193), (553, 8, 'taskcategory', 1), (554, 8, 'ticket', 138241), (555, 8, 'ticketcost', 1), (556, 8, 'ticketrecurrent', 1), (557, 8, 'itiltemplate', 1), (558, 8, 'ticketvalidation', 0), (559, 8, 'transfer', 1), (560, 8, 'typedoc', 1), (561, 8, 'user', 1), (562, 1, 'license', 0), (563, 2, 'license', 33), (564, 3, 'license', 127), (565, 4, 'license', 255), (566, 5, 'license', 0), (567, 6, 'license', 127), (568, 7, 'license', 127), (569, 8, 'license', 33), (570, 1, 'line', 0), (571, 2, 'line', 33), (572, 3, 'line', 127), (573, 4, 'line', 255), (574, 5, 'line', 0), (575, 6, 'line', 127), (576, 7, 'line', 127), (577, 8, 'line', 33), (578, 1, 'lineoperator', 0), (579, 2, 'lineoperator', 33), (580, 3, 'lineoperator', 23), (581, 4, 'lineoperator', 23), (582, 5, 'lineoperator', 0), (583, 6, 'lineoperator', 0), (584, 7, 'lineoperator', 23), (585, 8, 'lineoperator', 1), (586, 1, 'devicesimcard_pinpuk', 0), (587, 2, 'devicesimcard_pinpuk', 1), (588, 3, 'devicesimcard_pinpuk', 3), (589, 4, 'devicesimcard_pinpuk', 3), (590, 5, 'devicesimcard_pinpuk', 0), (591, 6, 'devicesimcard_pinpuk', 3), (592, 7, 'devicesimcard_pinpuk', 3), (593, 8, 'devicesimcard_pinpuk', 1), (594, 1, 'certificate', 0), (595, 2, 'certificate', 33), (596, 3, 'certificate', 127), (597, 4, 'certificate', 255), (598, 5, 'certificate', 0), (599, 6, 'certificate', 127), (600, 7, 'certificate', 127), (601, 8, 'certificate', 33), (602, 1, 'datacenter', 0), (603, 2, 'datacenter', 1), (604, 3, 'datacenter', 31), (605, 4, 'datacenter', 31), (606, 5, 'datacenter', 0), (607, 6, 'datacenter', 31), (608, 7, 'datacenter', 31), (609, 8, 'datacenter', 1), (610, 4, 'rule_asset', 1047), (611, 1, 'personalization', 3), (612, 2, 'personalization', 3), (613, 3, 'personalization', 3), (614, 4, 'personalization', 3), (615, 5, 'personalization', 3), (616, 6, 'personalization', 3), (617, 7, 'personalization', 3), (618, 8, 'personalization', 3), (619, 1, 'rule_asset', 0), (620, 2, 'rule_asset', 0), (621, 3, 'rule_asset', 0), (622, 5, 'rule_asset', 0), (623, 6, 'rule_asset', 0), (624, 7, 'rule_asset', 0), (625, 8, 'rule_asset', 0), (626, 1, 'global_validation', 0), (627, 2, 'global_validation', 0), (628, 3, 'global_validation', 0), (629, 4, 'global_validation', 0), (630, 5, 'global_validation', 0), (631, 6, 'global_validation', 0), (632, 7, 'global_validation', 0), (633, 1, 'cluster', 0), (634, 2, 'cluster', 1), (635, 3, 'cluster', 31), (636, 4, 'cluster', 31), (637, 5, 'cluster', 0), (638, 6, 'cluster', 31), (639, 7, 'cluster', 31), (640, 8, 'cluster', 1), (641, 1, 'externalevent', 0), (642, 2, 'externalevent', 1), (643, 3, 'externalevent', 1055), (644, 4, 'externalevent', 1055), (645, 5, 'externalevent', 0), (646, 6, 'externalevent', 1), (647, 7, 'externalevent', 31), (648, 8, 'externalevent', 1), (649, 1, 'dashboard', 0), (650, 2, 'dashboard', 0), (651, 3, 'dashboard', 0), (652, 4, 'dashboard', 23), (653, 5, 'dashboard', 0), (654, 6, 'dashboard', 0), (655, 7, 'dashboard', 0), (656, 8, 'dashboard', 0), (657, 1, 'appliance', 0), (658, 2, 'appliance', 1), (659, 3, 'appliance', 31), (660, 4, 'appliance', 31), (661, 5, 'appliance', 0), (662, 6, 'appliance', 31), (663, 7, 'appliance', 31), (664, 8, 'appliance', 1); INSERT INTO `glpi_profiles` (`id`, `name`, `interface`, `is_default`, `helpdesk_hardware`, `helpdesk_item_type`, `ticket_status`, `date_mod`, `comment`, `problem_status`, `create_ticket_on_login`, `tickettemplates_id`, `changetemplates_id`, `problemtemplates_id`, `change_status`, `managed_domainrecordtypes`, `date_creation`) 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, '', '[]', 0, 0, 0, 0, NULL, '[]', NULL), (2, 'Observer', 'central', 0, 1, '[\"Computer\",\"Monitor\",\"NetworkEquipment\",\"Peripheral\",\"Phone\",\"Printer\",\"Software\", \"DCRoom\", \"Rack\", \"Enclosure\"]', '[]', NULL, '', '[]', 0, 0, 0, 0, NULL, '[]', NULL), (3, 'Admin', 'central', 0, 3, '[\"Computer\",\"Monitor\",\"NetworkEquipment\",\"Peripheral\",\"Phone\",\"Printer\",\"Software\", \"DCRoom\", \"Rack\", \"Enclosure\"]', '[]', NULL, '', '[]', 0, 0, 0, 0, NULL, '[-1]', NULL), (4, 'Super-Admin', 'central', 0, 3, '[\"Computer\",\"Monitor\",\"NetworkEquipment\",\"Peripheral\",\"Phone\",\"Printer\",\"Software\", \"DCRoom\", \"Rack\", \"Enclosure\"]', '[]', NULL, '', '[]', 0, 0, 0, 0, NULL, '[-1]', NULL), (5, 'Hotliner', 'central', 0, 3, '[\"Computer\",\"Monitor\",\"NetworkEquipment\",\"Peripheral\",\"Phone\",\"Printer\",\"Software\", \"DCRoom\", \"Rack\", \"Enclosure\"]', '[]', NULL, '', '[]', 1, 0, 0, 0, NULL, '[]', NULL), (6, 'Technician', 'central', 0, 3, '[\"Computer\",\"Monitor\",\"NetworkEquipment\",\"Peripheral\",\"Phone\",\"Printer\",\"Software\", \"DCRoom\", \"Rack\", \"Enclosure\"]', '[]', NULL, '', '[]', 0, 0, 0, 0, NULL, '[]', NULL), (7, 'Supervisor', 'central', 0, 3, '[\"Computer\",\"Monitor\",\"NetworkEquipment\",\"Peripheral\",\"Phone\",\"Printer\",\"Software\", \"DCRoom\", \"Rack\", \"Enclosure\"]', '[]', NULL, '', '[]', 0, 0, 0, 0, NULL, '[]', NULL), (8, 'Read-Only', 'central', 0, 0, '[]', '{\"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\":0},\"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},\"7\":{\"1\":0,\"2\":0,\"3\":0,\"4\":0,\"5\":0,\"8\":0,\"6\":0},\"2\":{\"1\":0,\"7\":0,\"3\":0,\"4\":0,\"5\":0,\"8\":0,\"6\":0},\"3\":{\"1\":0,\"7\":0,\"2\":0,\"4\":0,\"5\":0,\"8\":0,\"6\":0},\"4\":{\"1\":0,\"7\":0,\"2\":0,\"3\":0,\"5\":0,\"8\":0,\"6\":0},\"5\":{\"1\":0,\"7\":0,\"2\":0,\"3\":0,\"4\":0,\"8\":0,\"6\":0},\"8\":{\"1\":0,\"7\":0,\"2\":0,\"3\":0,\"4\":0,\"5\":0,\"6\":0},\"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},\"9\":{\"1\":0,\"10\":0,\"7\":0,\"4\":0,\"11\":0,\"12\":0,\"5\":0,\"8\":0,\"6\":0},\"10\":{\"1\":0,\"9\":0,\"7\":0,\"4\":0,\"11\":0,\"12\":0,\"5\":0,\"8\":0,\"6\":0},\"7\":{\"1\":0,\"9\":0,\"10\":0,\"4\":0,\"11\":0,\"12\":0,\"5\":0,\"8\":0,\"6\":0},\"4\":{\"1\":0,\"9\":0,\"10\":0,\"7\":0,\"11\":0,\"12\":0,\"5\":0,\"8\":0,\"6\":0},\"11\":{\"1\":0,\"9\":0,\"10\":0,\"7\":0,\"4\":0,\"12\":0,\"5\":0,\"8\":0,\"6\":0},\"12\":{\"1\":0,\"9\":0,\"10\":0,\"7\":0,\"4\":0,\"11\":0,\"5\":0,\"8\":0,\"6\":0},\"5\":{\"1\":0,\"9\":0,\"10\":0,\"7\":0,\"4\":0,\"11\":0,\"12\":0,\"8\":0,\"6\":0},\"8\":{\"1\":0,\"9\":0,\"10\":0,\"7\":0,\"4\":0,\"11\":0,\"12\":0,\"5\":0,\"6\":0},\"6\":{\"1\":0,\"9\":0,\"10\":0,\"7\":0,\"4\":0,\"11\":0,\"12\":0,\"5\":0,\"8\":0}}', '[]', NULL); INSERT INTO `glpi_profiles_users` (`id`, `users_id`, `profiles_id`, `entities_id`, `is_recursive`, `is_dynamic`, `is_default_profile`) VALUES (2, 2, 4, 0, 1, 0, 0), (3, 3, 1, 0, 1, 0, 0), (4, 4, 6, 0, 1, 0, 0), (5, 5, 2, 0, 1, 0, 0); INSERT INTO `glpi_projectstates` (`id`, `name`, `comment`, `color`, `is_finished`, `date_mod`, `date_creation`) VALUES (1, 'New', NULL, '#06ff00', 0, NULL, NULL), (2, 'Processing', NULL, '#ffb800', 0, NULL, NULL), (3, 'Closed', NULL, '#ff0000', 1, NULL, NULL); INSERT INTO `glpi_requesttypes` (`id`, `name`, `is_helpdesk_default`, `is_followup_default`, `is_mail_default`, `is_mailfollowup_default`, `is_active`, `is_ticketheader`, `is_itilfollowup`, `comment`, `date_mod`, `date_creation`) VALUES (1, 'Helpdesk', 1, 1, 0, 0, 1, 1, 1, NULL, NULL, NULL), (2, 'E-Mail', 0, 0, 1, 1, 1, 1, 1, NULL, NULL, NULL), (3, 'Phone', 0, 0, 0, 0, 1, 1, 1, NULL, NULL, NULL), (4, 'Direct', 0, 0, 0, 0, 1, 1, 1, NULL, NULL, NULL), (5, 'Written', 0, 0, 0, 0, 1, 1, 1, NULL, NULL, NULL), (6, 'Other', 0, 0, 0, 0, 1, 1, 1, NULL, NULL, NULL); INSERT INTO `glpi_ruleactions` (`id`, `rules_id`, `action_type`, `field`, `value`) VALUES (2, 2, 'assign', 'entities_id', '0'), (3, 3, 'assign', 'entities_id', '0'), (4, 4, 'assign', '_refuse_email_no_response', '1'), (5, 5, 'assign', '_refuse_email_no_response', '1'), (6, 6, 'fromitem', 'locations_id', '1'), (7, 7, 'fromuser', 'locations_id', '1'), (8, 8, 'assign', '_import_category', '1'), (9, 9, 'regex_result', '_affect_user_by_regex', '#0'), (10, 10, 'regex_result', '_affect_user_by_regex', '#0'), (11, 11, 'regex_result', '_affect_user_by_regex', '#0'); INSERT INTO `glpi_rulecriterias` (`id`, `rules_id`, `criteria`, `condition`, `pattern`) VALUES (2, 2, 'TYPE', 0, '3'), (3, 2, 'TYPE', 0, '2'), (5, 3, 'subject', 6, '/.*/'), (6, 4, 'x-auto-response-suppress', 6, '/\\S+/'), (7, 5, 'auto-submitted', 6, '/^(?!.*no).+$/i'), (9, 6, 'locations_id', 9, '1'), (10, 6, 'items_locations', 8, '1'), (11, 7, 'locations_id', 9, '1'), (12, 7, '_locations_id_of_requester', 8, '1'), (13, 8, 'name', 0, '*'), (14, 9, '_itemtype', 0, 'Computer'), (15, 9, '_auto', 0, '1'), (16, 9, 'contact', 6, '/(.*)@/'), (17, 10, '_itemtype', 0, 'Computer'), (18, 10, '_auto', 0, '1'), (19, 10, 'contact', 6, '/(.*),/'), (20, 11, '_itemtype', 0, 'Computer'), (21, 11, '_auto', 0, '1'), (22, 11, 'contact', 6, '/(.*)/'); INSERT INTO `glpi_rulerightparameters` (`id`, `name`, `value`, `comment`, `date_mod`, `date_creation`) VALUES (1, '(LDAP)Organization', 'o', '', NULL, NULL), (2, '(LDAP)Common Name', 'cn', '', NULL, NULL), (3, '(LDAP)Department Number', 'departmentnumber', '', NULL, NULL), (4, '(LDAP)Email', 'mail', '', NULL, NULL), (5, 'Object Class', 'objectclass', '', NULL, NULL), (6, '(LDAP)User ID', 'uid', '', NULL, NULL), (7, '(LDAP)Telephone Number', 'phone', '', NULL, NULL), (8, '(LDAP)Employee Number', 'employeenumber', '', NULL, NULL), (9, '(LDAP)Manager', 'manager', '', NULL, NULL), (10, '(LDAP)DistinguishedName', 'dn', '', NULL, NULL), (12, '(AD)User ID', 'samaccountname', '', NULL, NULL), (13, '(LDAP) Title', 'title', '', NULL, NULL), (14, '(LDAP) MemberOf', 'memberof', '', NULL, NULL); INSERT INTO `glpi_rules` (`id`, `entities_id`, `sub_type`, `ranking`, `name`, `description`, `match`, `is_active`, `comment`, `date_mod`, `is_recursive`, `uuid`, `condition`, `date_creation`) VALUES (2, 0, 'RuleRight', 1, 'Root', '', 'OR', 1, NULL, NULL, 0, '500717c8-2bd6e957-53a12b5fd35745.02608131', 0, NULL), (3, 0, 'RuleMailCollector', 3, 'Root', '', 'OR', 1, NULL, NULL, 0, '500717c8-2bd6e957-53a12b5fd36404.54713349', 0, NULL), (4, 0, 'RuleMailCollector', 1, 'X-Auto-Response-Suppress', 'Exclude Auto-Reply emails using X-Auto-Response-Suppress header', 'AND', 0, NULL, NULL, 1, '500717c8-2bd6e957-53a12b5fd36d97.94503423', 0, NULL), (5, 0, 'RuleMailCollector', 2, 'Auto-Reply Auto-Submitted', 'Exclude Auto-Reply emails using Auto-Submitted header', 'OR', 1, NULL, NULL, 1, '500717c8-2bd6e957-53a12b5fd376c2.87642651', 0, NULL), (6, 0, 'RuleTicket', 1, 'Ticket location from item', '', 'AND', 0, NULL, NULL, 1, '500717c8-2bd6e957-53a12b5fd37f94.10365341', 1, NULL), (7, 0, 'RuleTicket', 2, 'Ticket location from user', '', 'AND', 0, NULL, NULL, 1, '500717c8-2bd6e957-53a12b5fd38869.86002585', 1, NULL), (8, 0, 'RuleSoftwareCategory', 1, 'Import category from inventory tool', '', 'AND', 0, NULL, NULL, 1, '500717c8-2bd6e957-53a12b5fd38869.86003425', 1, NULL), (9, 0, 'RuleAsset', 1, 'Domain user assignation', '', 'AND', 1, NULL, NULL, 1, 'fbeb1115-7a37b143-5a3a6fc1afdc17.92779763', 3, NULL), (10, 0, 'RuleAsset', 2, 'Multiple users: assign to the first', '', 'AND', 1, NULL, NULL, 1, 'fbeb1115-7a37b143-5a3a6fc1b03762.88595154', 3, NULL), (11, 0, 'RuleAsset', 3, 'One user assignation', '', 'AND', 1, NULL, NULL, 1, 'fbeb1115-7a37b143-5a3a6fc1b073e1.16257440', 3, NULL); INSERT INTO `glpi_softwarecategories` (`id`, `name`, `comment`, `softwarecategories_id`, `completename`, `level`, `ancestors_cache`, `sons_cache`) VALUES (1, 'FUSION', NULL, 0, 'FUSION', 1, NULL, NULL); INSERT INTO `glpi_softwarelicensetypes` (`id`, `name`, `comment`, `date_mod`, `date_creation`, `softwarelicensetypes_id`, `level`, `ancestors_cache`, `sons_cache`, `entities_id`, `is_recursive`, `completename`) VALUES (1, 'OEM', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 1, 'OEM'); INSERT INTO `glpi_ssovariables` (`id`, `name`, `comment`, `date_mod`, `date_creation`) VALUES (1, 'HTTP_AUTH_USER', '', NULL, NULL), (2, 'REMOTE_USER', '', NULL, NULL), (3, 'PHP_AUTH_USER', '', NULL, NULL), (4, 'USERNAME', '', NULL, NULL), (5, 'REDIRECT_REMOTE_USER', '', NULL, NULL), (6, 'HTTP_REMOTE_USER', '', NULL, NULL); INSERT INTO `glpi_tickettemplatemandatoryfields` (`id`, `tickettemplates_id`, `num`) VALUES (1, 1, 21); INSERT INTO `glpi_tickettemplates` (`id`, `name`, `entities_id`, `is_recursive`, `comment`) VALUES (1, 'Default', 0, 1, NULL); INSERT INTO `glpi_transfers` (`id`, `name`, `keep_ticket`, `keep_networklink`, `keep_reservation`, `keep_history`, `keep_device`, `keep_infocom`, `keep_dc_monitor`, `clean_dc_monitor`, `keep_dc_phone`, `clean_dc_phone`, `keep_dc_peripheral`, `clean_dc_peripheral`, `keep_dc_printer`, `clean_dc_printer`, `keep_supplier`, `clean_supplier`, `keep_contact`, `clean_contact`, `keep_contract`, `clean_contract`, `keep_software`, `clean_software`, `keep_document`, `clean_document`, `keep_cartridgeitem`, `clean_cartridgeitem`, `keep_cartridge`, `keep_consumable`, `date_mod`, `comment`, `keep_disk`) VALUES (1, 'complete', 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, NULL, 1); INSERT INTO `glpi_users` (`id`, `name`, `password`, `password_last_update`, `phone`, `phone2`, `mobile`, `realname`, `firstname`, `locations_id`, `language`, `use_mode`, `list_limit`, `is_active`, `comment`, `auths_id`, `authtype`, `last_login`, `date_mod`, `date_sync`, `is_deleted`, `profiles_id`, `entities_id`, `usertitles_id`, `usercategories_id`, `date_format`, `number_format`, `names_format`, `csv_delimiter`, `is_ids_visible`, `use_flat_dropdowntree`, `show_jobs_at_login`, `priority_1`, `priority_2`, `priority_3`, `priority_4`, `priority_5`, `priority_6`, `followup_private`, `task_private`, `default_requesttypes_id`, `password_forget_token`, `password_forget_token_date`, `user_dn`, `registration_number`, `show_count_on_tabs`, `refresh_views`, `set_default_tech`, `personal_token`, `personal_token_date`, `api_token`, `api_token_date`, `cookie_token`, `cookie_token_date`, `display_count_on_home`, `notification_to_myself`, `duedateok_color`, `duedatewarning_color`, `duedatecritical_color`, `duedatewarning_less`, `duedatecritical_less`, `duedatewarning_unit`, `duedatecritical_unit`, `display_options`, `is_deleted_ldap`, `pdffont`, `picture`, `begin_date`, `end_date`, `keep_devices_when_purging_item`, `privatebookmarkorder`, `backcreated`, `task_state`, `layout`, `palette`, `set_default_requester`, `lock_autolock_mode`, `lock_directunlock_notification`, `date_creation`, `highcontrast_css`, `plannings`, `sync_field`, `groups_id`, `users_id_supervisor`, `timezone`, `default_dashboard_central`, `default_dashboard_assets`, `default_dashboard_helpdesk`, `default_dashboard_mini_ticket`) VALUES (2, 'glpi', '$2y$10$rXXzbc2ShaiCldwkw4AZL.n.9QSH7c0c9XJAyyjrbL9BwmWditAYm', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 20, 1, NULL, 0, 1, NULL, NULL, NULL, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL), (3, 'post-only', '$2y$10$dTMar1F3ef5X/H1IjX9gYOjQWBR1K4bERGf4/oTPxFtJE/c3vXILm', NULL, NULL, NULL, NULL, NULL, NULL, 0, 'en_GB', 0, 20, 1, NULL, 0, 1, NULL, NULL, NULL, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL), (4, 'tech', '$2y$10$.xEgErizkp6Az0z.DHyoeOoenuh0RcsX4JapBk2JMD6VI17KtB1lO', NULL, NULL, NULL, NULL, NULL, NULL, 0, 'en_GB', 0, 20, 1, NULL, 0, 1, NULL, NULL, NULL, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL), (5, 'normal', '$2y$10$Z6doq4zVHkSPZFbPeXTCluN1Q/r0ryZ3ZsSJncJqkN3.8cRiN0NV.', NULL, NULL, NULL, NULL, NULL, NULL, 0, 'en_GB', 0, 20, 1, NULL, 0, 1, NULL, NULL, NULL, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL);