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

INSERT INTO `glpi_devicememorytypes` VALUES ('1','EDO',NULL);
INSERT INTO `glpi_devicememorytypes` VALUES ('2','DDR',NULL);
INSERT INTO `glpi_devicememorytypes` VALUES ('3','SDRAM',NULL);
INSERT INTO `glpi_devicememorytypes` VALUES ('4','SDRAM-2',NULL);
INSERT INTO `glpi_devicememorytypes` VALUES ('5','DDR-2','');
INSERT INTO `glpi_devicememorytypes` VALUES ('6','DDR3','');
INSERT INTO `glpi_devicememorytypes` VALUES ('7','SODIMM','');
INSERT INTO `glpi_devicememorytypes` VALUES ('8','SSD','');
INSERT INTO `glpi_devicememorytypes` VALUES ('9','DDR3L','');
INSERT INTO `glpi_devicememorytypes` VALUES ('10','DDR4','');

### Dump table glpi_devicemotherboards

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

INSERT INTO `glpi_devicemotherboards` VALUES ('1','ASUSTEK A7A266 /socket 7 /vit 1400','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('2','QDI Apollo pro 133 /socket 370 /vit 150','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('3','GIGABYTE GA-6VXC764X /socket 370','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('4','DFI K6XV3+ /socket 7 /vit 300','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('5','PCPartner MB520NH /socket 7 /vit 200','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('6','GIGABYTE Tech.6VTXE','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('7','DFI P5BV3+ /socket 7 /vit 300','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('8','ELITGROUP P5SD-B /socket 7 /vit 100','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('9','QDI P61440BX /socket 7 /vit 500','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('10','OCTEK RHINO 15+ /socket 7','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('11','PCPartner TXB820DS /socket 7 /vit 233','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('12','FIC VA-503+ /socket 7 /vit 400','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('13','Leadtek 7350KDA lan/socket A','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('14','ASUSTEK A7V8X-SR/socket A /vit 2130','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('15','DFI AK74-EC - Audio /socket A','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('16','DFI AK75-EC - Audio /socket A','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('17','Intel D845pesv','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('18','Intel FX-41','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('19','Intel 440ZX /socket 370 /vit 400','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('20','Intel silver reef /socket 370','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('21','DFI K6BV3+/66 /socket 7 /vit 550','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('22','Leadtek K7N415 N lan /socket 7 /vit 2100','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('23','ELITGROUP K7S5AL son lan /socket A /vit 2130','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('24','ELITGROUP K7s5a pro lan /socket A /vit 240','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('25','MSI MS-6315 /socket 370 /vit 1000','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('26','QDI advance 10e /socket 370 /vit 400','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('27','QDI 5/133 E /socket 370 /vit 550','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('28','VIA S7-SB /socket 7','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('29','Intel /socket A','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('30','Intel SL 37A /socket A /vit 400','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('31','VIA 694X/686A/68','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('32','','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('33','Intel 865 GLC  video son','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('34','Intel D915glvg','intel 915gl','Intel
son, vidéo, carte graphique intégrées','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('35','Intel D915 GAV','intel d915i','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('36','Gigabyte Ltd. C41M','','Version du bios: FA','24','0','0');
INSERT INTO `glpi_devicemotherboards` VALUES ('37','Intel D946GZIS','intel d946','','1','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('38','HP 18E7','','','8','0','0');
INSERT INTO `glpi_devicemotherboards` VALUES ('39','Hewlett-Packard 2820h','Dual core CPU E5200 2.5ghz','Hewlett-Packard 2820h Hewlett-Packard','8','0','0');
INSERT INTO `glpi_devicemotherboards` VALUES ('40','P5SD2-VM   S775   Asus  ','','','0','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('42','SD30G2 K45 shuttle intel945gc  S775   ich7','Intel 945gc','DDR2  533 - 667 Mgz','7','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('43','intel GTL+','Intel(R) 945G/GZ/GC/P/PL','','1','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('44','Intel DG41RQ','intel 41','LGA 775
ddr2  800 /667
Lan realtek Rtl 8111D','1','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('45','K48 Intel 945GC Express','Intel 945GC Express','','1','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('46','SG41j1 plus','Intel G41 Express  + ICH7 (TDP: 24W + 3.3W)','DDR3
Socket 775 
Supports Intel Core 2 Quad, Core 2 Duo, Pentium Dual Core, Celeron Dual-Core, Celeron 4xx
Supports 800, 1066 or 1333 MHz front side bus (FSB)','7','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('47','Intel DG41RQ','Intel','socket LGA 775
UDMA 100
sata 300
giga ethernet','1','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('48','Intel D945 GCNL','intel 945GC express','Micro ATX
1066/800/533 MHZ system Bus
DDR2 667 /533 2*2 g max
Intel graphic med accelerator 950 pc1 graphic x16
','1','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('49','Hewlett-Packard 2820h','Dual core CPU E5200 2.5ghz','Hewlett-Packard 2820h Hewlett-Packard','8','0','0');
INSERT INTO `glpi_devicemotherboards` VALUES ('50','Intel DH61AGL','DH61AGL','Un connecteur d\'affichage HDMI','1','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('51','Gigabyte G41M-Combo','','','24','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('52','Intel DH61CR','LGA 1155','Connecteurs DVI-I et VGA','1','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('53','Asus H81M-C','','','23','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('54','LENOVO 2537KL6','Intel QM57 ','','26','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('55','Asus H81l-Plus','','','23','0','1');
INSERT INTO `glpi_devicemotherboards` VALUES ('56','Intel DH61BE','','','1','0','0');
INSERT INTO `glpi_devicemotherboards` VALUES ('57','ASUS H81M-K','intel H81 Express Chipset','CPU: LGA1150','23','0','0');
INSERT INTO `glpi_devicemotherboards` VALUES ('58','Intel DG31PR','','','1','0','0');
INSERT INTO `glpi_devicemotherboards` VALUES ('59','Fujitsu FJNB210','','','27','0','0');
INSERT INTO `glpi_devicemotherboards` VALUES ('60','H81M-K','','','23','0','0');
INSERT INTO `glpi_devicemotherboards` VALUES ('62','Dell 0WR7PY A01','','','31','0','0');
INSERT INTO `glpi_devicemotherboards` VALUES ('63','Dell 0WR7PY A02','','','31','0','0');
INSERT INTO `glpi_devicemotherboards` VALUES ('64','LENOVO SHARKBAY NOK','','','26','0','0');
INSERT INTO `glpi_devicemotherboards` VALUES ('65','Lenovo 3112','Intel Kaby Lake','','26','0','0');
INSERT INTO `glpi_devicemotherboards` VALUES ('66','MS-AEO11','Intel Tiger lake','','36','0','0');

### Dump table glpi_devicenetworkcards

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

INSERT INTO `glpi_devicenetworkcards` VALUES ('1','Intel Pro 100 s PCI /10/100MBps /RJ-45','','','0','','0','1');
INSERT INTO `glpi_devicenetworkcards` VALUES ('2','Intel Pro Intégrée/ 10/100 MBps / RJ-45','','','0','','0','1');
INSERT INTO `glpi_devicenetworkcards` VALUES ('3','BROADCOM Gigabite ethernet intégrée 10/100 MBps /RJ-45','','','0','','0','1');
INSERT INTO `glpi_devicenetworkcards` VALUES ('4','D link DFE-530 TX 10/100 MBps /RJ-45','','','0','','0','1');
INSERT INTO `glpi_devicenetworkcards` VALUES ('5','None','','','0','','0','1');
INSERT INTO `glpi_devicenetworkcards` VALUES ('6','Realtek RTL8168D/8111D Family','','','0','','0','1');
INSERT INTO `glpi_devicenetworkcards` VALUES ('7','KTI KF-310/L /10/100 MBps /RJ-45','','','0','','0','1');
INSERT INTO `glpi_devicenetworkcards` VALUES ('8','RTL8139C /10/100 MBps /RJ-45','','','16','','0','1');
INSERT INTO `glpi_devicenetworkcards` VALUES ('9','RTL8201 BL /10/100 MBps /RJ-45','','','16','','0','1');
INSERT INTO `glpi_devicenetworkcards` VALUES ('10','SIS 900 intégré fast ethernet /10/100 MBps /RJ-45','','','0','','0','1');
INSERT INTO `glpi_devicenetworkcards` VALUES ('11','Carte wifi G520 Dlink','','','0','','0','1');
INSERT INTO `glpi_devicenetworkcards` VALUES ('12','Rtl8139 c+','','','16','','0','1');
INSERT INTO `glpi_devicenetworkcards` VALUES ('13','intel pro wireless lan 2100','','','1','','0','1');
INSERT INTO `glpi_devicenetworkcards` VALUES ('14','intel pro wireless 2200BG','','','1','','0','1');
INSERT INTO `glpi_devicenetworkcards` VALUES ('15','Marvell Yukon 88E8057','100','','15','','0','0');
INSERT INTO `glpi_devicenetworkcards` VALUES ('16','Marvell Yukon 88E8057','1000','','15','','0','1');
INSERT INTO `glpi_devicenetworkcards` VALUES ('17','RTL8168/8111 PCI-E Gigabit Ethernet ','1 gbs','','16','','0','1');
INSERT INTO `glpi_devicenetworkcards` VALUES ('19','Realtek RTL8168B/8111B PCI E-Gigabit Ethernet (NDIS 6.20) ','10/100/1000','Realtek PCIe GBE Family controleur','16','','0','0');
INSERT INTO `glpi_devicenetworkcards` VALUES ('20','Dlink DWL 520 G+','10/100','','19','','0','1');
INSERT INTO `glpi_devicenetworkcards` VALUES ('21','INTEL Gigab 82566DM ','10/100/1000','','1','','0','1');
INSERT INTO `glpi_devicenetworkcards` VALUES ('22','Artheros AR8151 PCI-E Giga Ethernet Controller','','','0','','0','1');
INSERT INTO `glpi_devicenetworkcards` VALUES ('23','INTEL 82577LM Gigabyte Network Connection','','','1','5C:FF:35:0C:08:02','0','1');
INSERT INTO `glpi_devicenetworkcards` VALUES ('24','Wireless LAN Mini-PCI Express Adaptateur II 11 b/g/n','10/100','','1','','0','1');
INSERT INTO `glpi_devicenetworkcards` VALUES ('25','Intel 82579LM Gigabyte','','','1','','0','0');
INSERT INTO `glpi_devicenetworkcards` VALUES ('26','Intel Corporation Ethernet Connection I217-LM','','','1','','0','0');

### Dump table glpi_devicepcis

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


### Dump table glpi_devicepowersupplies

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


### Dump table glpi_deviceprocessors

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

INSERT INTO `glpi_deviceprocessors` VALUES ('1','INTEL Pentium 133 Mhz','0','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('2','INTEL Pentium III 1 GHz','0','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('3','INTEL Pentium 200 MHz','0','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('4','INTEL Celeron 400 MHz','0','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('5','INTEL Celeron 466 MHz','0','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('6','INTEL Celeron 600 MHz','0','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('7','AMD K6/2 550 MHz','0','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('8','AMD K6/2 450 MHz','0','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('9','AMD Duron 600 MHz','0','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('10','AMD Duron 800MHz','0','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('11','AMD Athlon XP 1600 1.4Ghz','0','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('12','INTEL Pentium 233 MHz','0','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('13','INTEL Pentium II 266 MHz','0','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('14','INTEL Pentium III 866 MHz','0','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('15','AMD Athlon 1600+ 1.39Ghz','0','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('16','AMD Athlon XP 2000+ 1.667Ghz','0','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('17','AMD Athlon XP 2100+ 1.73Ghz','0','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('18','AMD K6/2 400 Mhz','0','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('19','INTEL Celeron G3900','0','','0','0',NULL,NULL,'0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('20','Intel Celeron 2000 Mhz','0','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('21','AMD Duron 900 Mhz','0','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('22','INTEL Pentium III 533 Mhz','0','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('23','INTEL Pentium III 800 Mhz','0','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('24','Intel Celeron 2600 Mhz','0','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('25','Intel Celeron E1400','2800','','1','2','2',NULL,'0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('26','Intel celeron 2800 MHZ','2','','0','2800',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('27','Intel Core2duo E4400 s775','2','','0','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('28','mobile intel pentium M 1400Mhz','0','','1','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('29','intel pentuim M 1.60Ghz','0','','1','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('30','Intel(R) Core(TM) 2 Duo CPU E8400','3000','','1','3000','2',NULL,'0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('31','E8400  3.00GHz Intel(R) Core(TM)2 Duo CPU','0','','1','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('32','E8400  3.0GHz Intel(R) Core(TM)2 Duo CPU','3','','1','3',NULL,NULL,'0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('34','E7600 3.06GHz Intel(R) Core(TM)2 Duo CPU','0','','1','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('35','INTEL E5200 DUAL CORE','2530','','1','2530','2',NULL,'0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('36','I3 3230','0','','1','3',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('37','Intel(R) Core(TM)2 Duo CPU E7200 @ 2.53GHz','0','','1','3',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('38','INTEL Core i3','0','','1','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('39','i3-4150','0','','1','0',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('40','i3-3220','3300','','1','3300',NULL,NULL,'0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('41','ARM Cortex A7 Quad-Core 1,2 GHz','1200','','0','1200',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('42','i3 3320','0','','1','3300',NULL,NULL,'0','1');
INSERT INTO `glpi_deviceprocessors` VALUES ('43','i3-2100','0','','0','0','0','0','0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('44','i3-4150','0','','1','0','0','0','0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('45','intel i3-5010U','0','','1','2100','4','0','0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('46','Intel-Core i5 2520M','3200','','1','2500','2','4','0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('47','Intel Core i5 3320M','3300','','1','2600','2','4','0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('48','Intel Core i5 M540','2530','','1','2530','2','4','0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('49','Intel Core I5 M560','2670','','1','2670','4','0','0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('50','Intel core I5-2400','0','','1','0','4','0','0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('51','Intel Core i5-4250','0','','1','3','4','0','0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('52','Intel Core i5-4130U','2600','','1','2000','2','4','0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('54','Intel Core I5-3470T','2900','','1','2900','2','0','0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('55','Intel Core i7-3770','3400','','1','3400','0','0','0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('56','i5-4300','0','','0','0','0','0','0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('57','i5 4310','0','','0','0','0','0','0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('58','I5-4570T','0','','1','0','0','0','0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('59','i5-4570','3200','','1','3200','0','0','0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('60','i3-4160','0','','1','0','0','0','0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('61','i5-3470','0','','0','3200','0','0','0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('62','Intel Core i7 4770','0','','1','0','4','0','0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('63','I5-8250','2','','1','2','4','8','0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('64','Intel Core i5 7400','3000','3000=3GHZ','1','3000','4','4','0','0');
INSERT INTO `glpi_deviceprocessors` VALUES ('65','Intel Core i7 1165G7','3','MHz = GHz','1','1','4','8','0','0');

### Dump table glpi_devicesoundcards

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

INSERT INTO `glpi_devicesoundcards` VALUES ('1','INTEL / INTEL 82815 intégrée','','','0','0','1');
INSERT INTO `glpi_devicesoundcards` VALUES ('2','integrated','','','0','0','1');
INSERT INTO `glpi_devicesoundcards` VALUES ('3','Soundblaster /PC 64V intégrée','','','0','0','1');
INSERT INTO `glpi_devicesoundcards` VALUES ('4','VIA /AC 97 intégrée','','','0','0','1');
INSERT INTO `glpi_devicesoundcards` VALUES ('5','Real. alc 650  ac97','','','0','0','1');
INSERT INTO `glpi_devicesoundcards` VALUES ('6','SoundMax Intégré DA','','','0','0','1');

### Dump table glpi_displaypreferences

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

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

### Dump table glpi_documentcategories

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

INSERT INTO `glpi_documentcategories` VALUES ('1','Reseau','Doc réseau','0','Reseau','1',NULL,NULL);

### Dump table glpi_documents

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

INSERT INTO `glpi_documents` VALUES ('1','0','0','Document Intervention  103','BMP/wordechec.bmp','BMP/wordechec.bmp','0','image/bmp',NULL,'','0','','0','0',NULL,'0','1');
INSERT INTO `glpi_documents` VALUES ('2','0','0','Document Ticket 651','BMP/imprim_ecran_officescan.bmp','BMP/imprim_ecran_officescan.bmp','0','image/bmp','2009-10-01 09:22:27',NULL,'0',NULL,'212','651',NULL,'0','2');
INSERT INTO `glpi_documents` VALUES ('3','0','0','Document Ticket 810','JPG/i_love_europe_2010_fr.jpg','JPG/i_love_europe_2010_fr.jpg','0','image/jpeg','2010-04-28 12:50:09',NULL,'0',NULL,'271','810',NULL,'0','3');
INSERT INTO `glpi_documents` VALUES ('4','0','0','Document Ticket 810','JPG/semaine_de_l__europe_au_lyc&eacute;e_notre_dame_de_la_providence.jpg','JPG/semaine_de_l__europe_au_lyc&eacute;e_notre_dame_de_la_providence.jpg','0','image/jpeg','2010-04-28 13:04:59',NULL,'0',NULL,'271','810',NULL,'0','4');
INSERT INTO `glpi_documents` VALUES ('5','0','0','Document Ticket 825','JPG/license_crocodile.jpg','JPG/license_crocodile.jpg','0','image/jpeg','2010-05-10 17:23:39',NULL,'0',NULL,'271','825',NULL,'0','5');
INSERT INTO `glpi_documents` VALUES ('6','0','0','Document Ticket 965','BMP/pb_gestion_comm.bmp','BMP/pb_gestion_comm.bmp','0','image/bmp','2010-11-15 10:00:28',NULL,'0',NULL,'389','965',NULL,'0','6');
INSERT INTO `glpi_documents` VALUES ('7','0','0','Document Ticket 978','BMP/pb_gestion_commercial.bmp','BMP/pb_gestion_commercial.bmp','0','image/bmp','2010-11-22 10:49:11',NULL,'0',NULL,'389','978',NULL,'0','7');
INSERT INTO `glpi_documents` VALUES ('8','0','0','Document Ticket 1033','BMP/pb.bmp','BMP/pb.bmp','0','image/bmp','2011-01-28 11:36:22',NULL,'0',NULL,'467','1033',NULL,'0','8');
INSERT INTO `glpi_documents` VALUES ('9','0','0','Document Ticket 1190','PB techn.docx','DOCX/95/0a8c77b7bab8356ee208b8513673b23a61baa4.DOCX','0','application/vnd.openxmlformats-officedocument.wordprocessingml.document','2011-11-24 13:06:48',NULL,'0',NULL,'1032','1190','950a8c77b7bab8356ee208b8513673b23a61baa4','0','9');
INSERT INTO `glpi_documents` VALUES ('10','0','0','Document Ticket 1241','Sans titre.bmp','BMP/89/7010c2346d8c3fec3db410b477b6a480180184.BMP','0','image/bmp','2012-01-24 09:18:58',NULL,'0',NULL,'1054','1241','897010c2346d8c3fec3db410b477b6a480180184','0','10');
INSERT INTO `glpi_documents` VALUES ('11','0','0','Document Ticket 1291','1332829290652.jpg','JPG/6d/bfa838c5ccc098dad3e64e83ceee00fc2c5c96.JPG','0','image/jpeg','2012-03-27 08:29:22',NULL,'0',NULL,'1023','1291','6dbfa838c5ccc098dad3e64e83ceee00fc2c5c96','0','11');
INSERT INTO `glpi_documents` VALUES ('12','0','0','Document Ticket 1437','Pack office 2.bmp','BMP/bf/a300ce53c387210b1a1793655bfae80b8329bf.BMP','0','image/bmp','2012-10-24 11:22:11',NULL,'0',NULL,'1054','1437','bfa300ce53c387210b1a1793655bfae80b8329bf','0','12');
INSERT INTO `glpi_documents` VALUES ('13','0','0','docc','monitoring.class.php','PHP/4c/7b0659f0c2ca12a5c4be0b08afe5060d698a3b.PHP','0','application/octet-stream','2014-08-19 11:48:50','','1','','0','0','4c7b0659f0c2ca12a5c4be0b08afe5060d698a3b','0','13');
INSERT INTO `glpi_documents` VALUES ('14','0','0','Document ticket 1658','pilote.png','PNG/65/e224b8761864431dfcda6d845ff91d03adaedc.PNG','0','image/png','2013-10-16 09:37:54',NULL,'0',NULL,'1138','1658','65e224b8761864431dfcda6d845ff91d03adaedc','0','14');
INSERT INTO `glpi_documents` VALUES ('15','0','0','Document ticket 1986','liste eleve zimbra.odt','ODT/da/d256fdec5715bac61c7b3b467f237658211d1f.ODT','0','application/vnd.oasis.opendocument.text','2015-11-12 08:52:03',NULL,'0',NULL,'1149','1986','dad256fdec5715bac61c7b3b467f237658211d1f','0','15');
INSERT INTO `glpi_documents` VALUES ('16','0','0','Document ticket 1996','classe 1ere pro.odt','ODT/1b/8e54c01eb387d1cd95e9c488eb13718fc082a6.ODT','0','application/vnd.oasis.opendocument.text','2015-11-16 15:45:19',NULL,'0',NULL,'1149','1996','1b8e54c01eb387d1cd95e9c488eb13718fc082a6','0','16');
INSERT INTO `glpi_documents` VALUES ('17','0','0','Document ticket 2147','asset (2).jpg','JPG/0d/12d0dd08bc4bec10ed819d09c990c4e69090a5.JPG','0','image/jpeg','2016-09-07 09:48:26',NULL,'0',NULL,'90','2147','0d12d0dd08bc4bec10ed819d09c990c4e69090a5','0','c06ebe2a-fff1f0d7-57cfc6439e5272.75550207');
INSERT INTO `glpi_documents` VALUES ('18','0','0','Document ticket 2155','Capture.PNG','PNG/ff/845d245c3dfe74cb9ff51656f7a27e8c043a6b.PNG','0','image/jpeg','2016-09-07 16:22:03',NULL,'0',NULL,'1302','2155','ff845d245c3dfe74cb9ff51656f7a27e8c043a6b','0','c06ebe2a-fff1f0d7-57d0221f3e1e74.56221185');
INSERT INTO `glpi_documents` VALUES ('19','0','0','Document ticket 2205','Capture.PNG','PNG/c5/52859e5b3cd69713d7a0d259a96be6c250bd03.PNG','0','image/jpeg','2016-10-11 08:09:47',NULL,'0',NULL,'1217','2205','c552859e5b3cd69713d7a0d259a96be6c250bd03','0','c06ebe2a-fff1f0d7-57fc8228c86e66.01539906');
INSERT INTO `glpi_documents` VALUES ('20','0','0','Document ticket 2208','microsoftoffice.png','PNG/43/c9cd477089aae660d82806a70008ee75cf0e1c.PNG','0','image/jpeg','2016-10-11 16:15:50',NULL,'0',NULL,'1318','2208','43c9cd477089aae660d82806a70008ee75cf0e1c','0','c06ebe2a-fff1f0d7-57fcf4047cc2c9.29247585');
INSERT INTO `glpi_documents` VALUES ('21','0','0','Document ticket 2282','wamp serveur.png','PNG/2f/96480cd73be21a84bc2c2dccedf5fc2b13a6b5.PNG','0','image/jpeg','2017-01-27 08:31:54',NULL,'0',NULL,'1296','2282','2f96480cd73be21a84bc2c2dccedf5fc2b13a6b5','0','c06ebe2a-fff1f0d7-588af7656bdc75.27768459');
INSERT INTO `glpi_documents` VALUES ('22','0','0','Document ticket 2336','IMG_1952.JPG','JPG/d6/12552f3bf93e8a557bb64ef41ffe60345615cd.JPG','0','image/jpeg','2017-05-18 16:15:35',NULL,'0',NULL,'390','2336','d612552f3bf93e8a557bb64ef41ffe60345615cd','0','c06ebe2a-fff1f0d7-591dac748995b2.44543430');
INSERT INTO `glpi_documents` VALUES ('23','0','0','Document ticket 2379','Capture.PNG','PNG/3f/11f4175aa158cc5ecb250c8bb751ece521d419.PNG','0','image/jpeg','2017-09-21 11:43:20',NULL,'0',NULL,'1281','2379','3f11f4175aa158cc5ecb250c8bb751ece521d419','0','c06ebe2a-fff1f0d7-59c389af9f8294.65442093');
INSERT INTO `glpi_documents` VALUES ('24','0','0','Document ticket 2532','maxime.png','PNG/5e/5810a8b81397d92303d40356da3c655f8a9b8e.PNG','0','image/jpeg','2017-12-21 16:37:49',NULL,'0',NULL,'1377','2532','5e5810a8b81397d92303d40356da3c655f8a9b8e','0','c06ebe2a-fff1f0d7-5a3bd4e249f309.70499823');
INSERT INTO `glpi_documents` VALUES ('25','0','0','Document ticket 2867','IMG_20200128_172047.jpg','JPG/32/6c60701c5d8c132f16473504f0b578030172a7.JPG','0','image/jpeg','2020-01-28 17:25:27',NULL,'0',NULL,'1460','2867','326c60701c5d8c132f16473504f0b578030172a7','0','c06ebe2a-fff1f0d7-5e30603a1b1a25.91204742');
INSERT INTO `glpi_documents` VALUES ('26','0','0','Document ticket 2887','Capture.PNG','PNG/39/9de14bb8ba40ab9e339595bfdf7cbb4f515600.PNG','0','image/jpeg','2020-03-09 08:19:42',NULL,'0',NULL,'1467','2887','399de14bb8ba40ab9e339595bfdf7cbb4f515600','0','c06ebe2a-fff1f0d7-5e65edf0f42262.35951119');
INSERT INTO `glpi_documents` VALUES ('27','0','0','Document : Base de connaissances - Dmz à domicile avec une box coriolis (7)','Dmz sur box coriolis (2).pdf','PDF/Web4a447f0717ecb538c032b669b5ef9e63be8918.PDF','1','application/pdf','2020-05-07 11:22:57',NULL,'0',NULL,'2','0','5c4a447f0717ecb538c032b669b5ef9e63be8918','0','c06ebe2a-fff1f0d7-5eb3d32fd670e2.59637445');
INSERT INTO `glpi_documents` VALUES ('28','0','0','Document : Base de connaissances - Configuration d\'une Dmz à domicile avec Box SFR','doc_activer_port_80_server_web.odt','ODT/85/a9cd2769079df57381e59fd8111cd420073a81.ODT','0','application/vnd.oasis.opendocument.text','2020-05-11 14:34:07',NULL,'0',NULL,'1468','0','85a9cd2769079df57381e59fd8111cd420073a81','0','c06ebe2a-fff1f0d7-5eb9463537ce11.73066623');
INSERT INTO `glpi_documents` VALUES ('29','0','0','Document : Base de connaissances - Mise en place d’une DMZ en double NAT avec une Livebox 4 et un routeur wifi Tp-Link AC1200','Mise en place d’une DMZ en double NAT avec une Livebox 4 et un routeur wifi Tp-Link AC1200 (1).pdf','PDF/78/801e3b578f24fd2f3dc05ef8cefaf48afb308f.PDF','1','application/pdf','2020-05-11 15:42:49','','0','','1469','0','78801e3b578f24fd2f3dc05ef8cefaf48afb308f','0','c06ebe2a-fff1f0d7-5eb9564bcfa3f8.06541421');
INSERT INTO `glpi_documents` VALUES ('30','0','0','Document : Base de connaissances - Virtualhost apache2','PPE1_TP_virtualhost_Apache.pdf','PDF/f8/1cc3f8e7a02eac649f00388e128519211f942f.PDF','0','application/pdf','2020-05-12 11:56:55',NULL,'0',NULL,'1469','0','f81cc3f8e7a02eac649f00388e128519211f942f','0','c06ebe2a-fff1f0d7-5eba72e12c5ef2.13356288');
INSERT INTO `glpi_documents` VALUES ('31','0','0','Document : Base de connaissances - DMZ Box SFR','DMZ sur Box SFR.docx','DOCX/b7/2536741bf11d2a2c57ca2bf36ec38b15f49df5.DOCX','0','application/vnd.openxmlformats-officedocument.wordprocessingml.document','2020-05-14 10:56:27',NULL,'0',NULL,'1446','0','b72536741bf11d2a2c57ca2bf36ec38b15f49df5','0','c06ebe2a-fff1f0d7-5ebd07b5dc4693.63549212');
INSERT INTO `glpi_documents` VALUES ('32','0','0','Document : Base de connaissances - configuration d\'une dWebavec une livebox (orange)','doc.odt','ODT/Webed14af7b0a2f11a500441401f9ed0a87c019d7.ODT','0','application/vnd.oasis.opendocument.text','2020-05-14 14:47:06',NULL,'0',NULL,'1473','0','a1ed14af7b0a2f11a500441401f9ed0a87c019d7','0','c06ebe2a-fff1f0d7-5ebd3dc7c1e054.11881547');
INSERT INTO `glpi_documents` VALUES ('33','0','0','Document : Base de connaissances - Configuration serveur web bdd phpmyadmin linux (12)','Tuto serveur web bdd FAQ.pdf','PDF/6a/3bd99cfe82c94266f260db9fc353bf903722fc.PDF','0','application/pdf','2020-05-18 14:34:35',NULL,'0',NULL,'2','0','6a3bd99cfe82c94266f260db9fc353bf903722fc','0','c06ebe2a-fff1f0d7-5ec280c7b6a242.65289015');
INSERT INTO `glpi_documents` VALUES ('34','0','0','Document : Base de connaissances - FAQ apache2 mariadb ssh WinSCP','FAQ.pdf','PDF/90/31c4e7fde71ac1d9a364e0c16976ac42f776fd.PDF','0','application/pdf','2020-05-18 15:09:40',NULL,'0',NULL,'1470','0','9031c4e7fde71ac1d9a364e0c16976ac42f776fd','0','c06ebe2a-fff1f0d7-5ec288d0ad4ed0.49181022');
INSERT INTO `glpi_documents` VALUES ('35','0','0','Document ticket 3108','Capture d’écran 2021-11-18 162956.png','PNG/f1/ff2c9f82c93554ec3847e06b335f59878c95b2.PNG','0','image/jpeg','2021-11-18 16:30:18',NULL,'0',NULL,'46','3108','f1ff2c9f82c93554ec3847e06b335f59878c95b2','0','c06ebe2a-fff1f0d7-619671822e9c12.94940600');
INSERT INTO `glpi_documents` VALUES ('36','0','0','Document ticket 3241','capture erreur.png','PNG/a2/9096721a002c52067495d1c1c9819fae4a6bd0.PNG','0','image/jpeg','2022-10-19 08:44:28',NULL,'0',NULL,'1568','3241','a29096721a002c52067495d1c1c9819fae4a6bd0','0','c06ebe2a-fff1f0d7-634f9cc28f3884.17899803');
INSERT INTO `glpi_documents` VALUES ('37','0','0','Document ticket 3302','Capture_.PNG','PNG/24/3882f7756bfa683d1e3e5efe87739a437df65f.PNG','0','image/jpeg','2023-03-07 15:54:54',NULL,'0',NULL,'1546','3302','243882f7756bfa683d1e3e5efe87739a437df65f','0','0de1c195-fff1f0d7-64074fad60bee1.83567180');

### Dump table glpi_documents_items

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

INSERT INTO `glpi_documents_items` VALUES ('2','2','651','Ticket','0','0','2009-10-01 09:22:27');
INSERT INTO `glpi_documents_items` VALUES ('4','4','810','Ticket','0','0','2010-04-28 13:04:59');
INSERT INTO `glpi_documents_items` VALUES ('5','5','825','Ticket','0','0','2010-05-10 17:23:39');
INSERT INTO `glpi_documents_items` VALUES ('6','6','965','Ticket','0','0','2010-11-15 10:00:28');
INSERT INTO `glpi_documents_items` VALUES ('7','7','978','Ticket','0','0','2010-11-22 10:49:11');
INSERT INTO `glpi_documents_items` VALUES ('8','8','1033','Ticket','0','0','2011-01-28 11:36:22');
INSERT INTO `glpi_documents_items` VALUES ('9','9','1190','Ticket','0','0','2011-11-24 13:06:48');
INSERT INTO `glpi_documents_items` VALUES ('10','10','1241','Ticket','0','0','2012-01-24 09:18:58');
INSERT INTO `glpi_documents_items` VALUES ('11','10','1242','Ticket','0','0','2012-01-24 09:18:58');
INSERT INTO `glpi_documents_items` VALUES ('13','12','1437','Ticket','0','0','2012-10-24 11:22:11');
INSERT INTO `glpi_documents_items` VALUES ('14','14','1658','Ticket','0','0','2013-10-16 09:37:54');
INSERT INTO `glpi_documents_items` VALUES ('15','15','1986','Ticket','0','0','2015-11-12 08:52:03');
INSERT INTO `glpi_documents_items` VALUES ('16','16','1996','Ticket','0','0','2015-11-16 15:45:19');
INSERT INTO `glpi_documents_items` VALUES ('17','17','2147','Ticket','0','0','2016-09-07 09:48:26');
INSERT INTO `glpi_documents_items` VALUES ('18','18','2155','Ticket','0','0','2016-09-07 16:22:03');
INSERT INTO `glpi_documents_items` VALUES ('19','19','2205','Ticket','0','0','2016-10-11 08:09:47');
INSERT INTO `glpi_documents_items` VALUES ('20','20','2208','Ticket','0','0','2016-10-11 16:15:50');
INSERT INTO `glpi_documents_items` VALUES ('21','21','2282','Ticket','0','0','2017-01-27 08:31:54');
INSERT INTO `glpi_documents_items` VALUES ('22','22','2336','Ticket','0','0','2017-05-18 16:15:35');
INSERT INTO `glpi_documents_items` VALUES ('23','23','2379','Ticket','0','0','2017-09-21 11:43:20');
INSERT INTO `glpi_documents_items` VALUES ('24','24','2532','Ticket','0','0','2017-12-21 16:37:49');
INSERT INTO `glpi_documents_items` VALUES ('25','25','2867','Ticket','0','0','2020-01-28 17:25:27');
INSERT INTO `glpi_documents_items` VALUES ('26','26','2887','Ticket','0','0','2020-03-09 08:19:42');
INSERT INTO `glpi_documents_items` VALUES ('27','27','7','KnowbaseItem','0','0','2020-05-07 11:22:57');
INSERT INTO `glpi_documents_items` VALUES ('28','28','6','KnowbaseItem','0','0','2020-05-11 14:34:07');
INSERT INTO `glpi_documents_items` VALUES ('29','29','8','KnowbaseItem','0','0','2020-05-12 11:24:19');
INSERT INTO `glpi_documents_items` VALUES ('30','30','9','KnowbaseItem','0','0','2020-05-12 11:56:55');
INSERT INTO `glpi_documents_items` VALUES ('31','31','11','KnowbaseItem','0','0','2020-05-14 10:56:27');
INSERT INTO `glpi_documents_items` VALUES ('32','32','10','KnowbaseItem','0','0','2020-05-14 14:47:06');
INSERT INTO `glpi_documents_items` VALUES ('33','33','12','KnowbaseItem','0','0','2020-05-18 14:34:35');
INSERT INTO `glpi_documents_items` VALUES ('34','34','13','KnowbaseItem','0','0','2020-05-18 15:09:40');
INSERT INTO `glpi_documents_items` VALUES ('35','35','3108','Ticket','0','0','2021-11-18 16:30:18');
INSERT INTO `glpi_documents_items` VALUES ('36','36','3241','Ticket','0','0','2022-10-19 08:44:28');
INSERT INTO `glpi_documents_items` VALUES ('37','37','3302','Ticket','0','0','2023-03-07 15:54:54');

### Dump table glpi_documenttypes

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

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

### Dump table glpi_domains

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

INSERT INTO `glpi_domains` VALUES ('1','ndlp','0','0','');

### Dump table glpi_dropdowntranslations

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


### Dump table glpi_entities

CREATE TABLE `glpi_entities` (
  `id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entities_id` int(11) NOT NULL DEFAULT '0',
  `completename` text COLLATE utf8_unicode_ci,
  `comment` text COLLATE utf8_unicode_ci,
  `level` int(11) NOT NULL DEFAULT '0',
  `sons_cache` longtext COLLATE utf8_unicode_ci,
  `ancestors_cache` longtext COLLATE utf8_unicode_ci,
  `address` text COLLATE utf8_unicode_ci,
  `postcode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `town` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Webntry` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `website` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phonenumber` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fax` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `admin_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `admin_email_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `admin_reply` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `admin_reply_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `notification_subject_tag` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ldap_dn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tag` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `authldaps_id` int(11) NOT NULL DEFAULT '0',
  `mail_domain` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entity_ldapfilter` text COLLATE utf8_unicode_ci,
  `mailing_signature` text COLLATE utf8_unicode_ci,
  `cartridges_alert_repeat` int(11) NOT NULL DEFAULT '-2',
  `consumables_alert_repeat` int(11) NOT NULL DEFAULT '-2',
  `use_licenses_alert` int(11) NOT NULL DEFAULT '-2',
  `send_licenses_alert_before_delay` int(11) NOT NULL DEFAULT '-2',
  `use_contracts_alert` int(11) NOT NULL DEFAULT '-2',
  `send_contracts_alert_before_delay` int(11) NOT NULL DEFAULT '-2',
  `use_infocoms_alert` int(11) NOT NULL DEFAULT '-2',
  `send_infocoms_alert_before_delay` int(11) NOT NULL DEFAULT '-2',
  `use_reservations_alert` int(11) NOT NULL DEFAULT '-2',
  `autoclose_delay` int(11) NOT NULL DEFAULT '-2',
  `notclosed_delay` int(11) NOT NULL DEFAULT '-2',
  `calendars_id` int(11) NOT NULL DEFAULT '-2',
  `auto_assign_mode` int(11) NOT NULL DEFAULT '-2',
  `tickettype` int(11) NOT NULL DEFAULT '-2',
  `max_closedate` datetime DEFAULT NULL,
  `inquest_config` int(11) NOT NULL DEFAULT '-2',
  `inquest_rate` int(11) NOT NULL DEFAULT '0',
  `inquest_delay` int(11) NOT NULL DEFAULT '-10',
  `inquest_URL` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `autofill_warranty_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-2',
  `autofill_use_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-2',
  `autofill_buy_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-2',
  `autofill_delivery_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-2',
  `autofill_order_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-2',
  `tickettemplates_id` int(11) NOT NULL DEFAULT '-2',
  `entities_id_software` int(11) NOT NULL DEFAULT '-2',
  `default_contract_alert` int(11) NOT NULL DEFAULT '-2',
  `default_infocom_alert` int(11) NOT NULL DEFAULT '-2',
  `default_cartridges_alarm_threshold` int(11) NOT NULL DEFAULT '-2',
  `default_consumables_alarm_threshold` int(11) NOT NULL DEFAULT '-2',
  `delay_send_emails` int(11) NOT NULL DEFAULT '-2',
  `is_notif_enable_default` int(11) NOT NULL DEFAULT '-2',
  `inquest_duration` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`entities_id`,`name`),
  KEY `entities_id` (`entities_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `glpi_entities` VALUES ('0','Entité racine','-1','Entité racine',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','0','-10','1',NULL,'1','0','0',NULL,'0','0','0','0','0','1','-10','0','0','3','3','0','1','0');

### Dump table glpi_entities_knowbaseitems

CREATE TABLE `glpi_entities_knowbaseitems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `knowbaseitems_id` int(11) NOT NULL DEFAULT '0',
  `entities_id` int(11) NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `knowbaseitems_id` (`knowbaseitems_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `glpi_entities_knowbaseitems` VALUES ('1','4','0','0');
INSERT INTO `glpi_entities_knowbaseitems` VALUES ('2','5','0','0');
INSERT INTO `glpi_entities_knowbaseitems` VALUES ('3','7','0','0');
INSERT INTO `glpi_entities_knowbaseitems` VALUES ('4','6','0','0');
INSERT INTO `glpi_entities_knowbaseitems` VALUES ('5','3','0','0');
INSERT INTO `glpi_entities_knowbaseitems` VALUES ('6','8','0','0');
INSERT INTO `glpi_entities_knowbaseitems` VALUES ('7','9','0','0');
INSERT INTO `glpi_entities_knowbaseitems` VALUES ('8','10','0','0');
INSERT INTO `glpi_entities_knowbaseitems` VALUES ('9','11','0','0');
INSERT INTO `glpi_entities_knowbaseitems` VALUES ('10','12','0','0');
INSERT INTO `glpi_entities_knowbaseitems` VALUES ('11','13','0','0');

### Dump table glpi_entities_reminders

CREATE TABLE `glpi_entities_reminders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reminders_id` int(11) NOT NULL DEFAULT '0',
  `entities_id` int(11) NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `reminders_id` (`reminders_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


### Dump table glpi_entities_rssfeeds

CREATE TABLE `glpi_entities_rssfeeds` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rssfeeds_id` int(11) NOT NULL DEFAULT '0',
  `entities_id` int(11) NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `rssfeeds_id` (`rssfeeds_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


### Dump table glpi_entitydatas

CREATE TABLE `glpi_entitydatas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL DEFAULT '0',
  `address` text COLLATE utf8_unicode_ci,
  `postcode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `town` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Webntry` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `website` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phonenumber` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fax` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `admin_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `admin_email_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `admin_reply` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `admin_reply_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `notepad` longtext COLLATE utf8_unicode_ci,
  `ldap_dn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tag` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `authldaps_id` int(11) NOT NULL DEFAULT '0',
  `mail_domain` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entity_ldapfilter` text COLLATE utf8_unicode_ci,
  `mailing_signature` text COLLATE utf8_unicode_ci,
  `cartridges_alert_repeat` int(11) NOT NULL DEFAULT '-1',
  `consumables_alert_repeat` int(11) NOT NULL DEFAULT '-1',
  `use_licenses_alert` tinyint(1) NOT NULL DEFAULT '-1',
  `use_contracts_alert` tinyint(1) NOT NULL DEFAULT '-1',
  `use_infocoms_alert` tinyint(1) NOT NULL DEFAULT '-1',
  `use_reservations_alert` int(11) NOT NULL DEFAULT '-1',
  `autoclose_delay` int(11) NOT NULL DEFAULT '-1',
  `notclosed_delay` int(11) NOT NULL DEFAULT '-1',
  `calendars_id` int(11) NOT NULL DEFAULT '0',
  `auto_assign_mode` int(11) NOT NULL DEFAULT '-1',
  `tickettype` int(11) NOT NULL DEFAULT '0',
  `max_closedate` datetime DEFAULT NULL,
  `inquest_config` int(11) NOT NULL DEFAULT '0',
  `inquest_rate` int(11) NOT NULL DEFAULT '-1',
  `inquest_delay` int(11) NOT NULL DEFAULT '-1',
  `inquest_URL` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `autofill_warranty_date` varchar(255) COLLATE utf8_unicode_ci DEFAULT '-1',
  `autofill_use_date` varchar(255) COLLATE utf8_unicode_ci DEFAULT '-1',
  `autofill_buy_date` varchar(255) COLLATE utf8_unicode_ci DEFAULT '-1',
  `autofill_delivery_date` varchar(255) COLLATE utf8_unicode_ci DEFAULT '-1',
  `autofill_order_date` varchar(255) COLLATE utf8_unicode_ci DEFAULT '-1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`entities_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


### Dump table glpi_events

CREATE TABLE `glpi_events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `items_id` int(11) NOT NULL DEFAULT '0',
  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `service` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `level` int(11) NOT NULL DEFAULT '0',
  `message` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `date` (`date`),
  KEY `level` (`level`),
  KEY `item` (`type`,`items_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `glpi_events` VALUES ('28335','3289','ticket','2023-02-06 10:21:17','tracking','4','hebera ajoute l\'élément 3289');
INSERT INTO `glpi_events` VALUES ('28334','-1','system','2023-02-06 10:20:02','login','3','hebera se connecte depuis l\'IP 172.16.132.21');
INSERT INTO `glpi_events` VALUES ('28333','3288','ticket','2023-02-06 08:25:00','tracking','4','cailla ajoute l\'élément 3288');
INSERT INTO `glpi_events` VALUES ('28332','-1','system','2023-02-06 08:23:59','login','3','cailla se connecte depuis l\'IP 172.16.32.1');
INSERT INTO `glpi_events` VALUES ('28376','3295','ticket','2023-02-28 10:48:56','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28375','-1','system','2023-02-28 10:32:11','login','3','simojul se connecte depuis l\'IP 172.16.106.59');
INSERT INTO `glpi_events` VALUES ('28374','-1','system','2023-02-28 10:15:35','login','3','glpi se connecte depuis l\'IP 172.16.106.27');
INSERT INTO `glpi_events` VALUES ('28373','3295','ticket','2023-02-28 09:29:43','tracking','4','polflm ajoute l\'élément 3295');
INSERT INTO `glpi_events` VALUES ('28372','-1','system','2023-02-28 09:27:31','login','3','polflm se connecte depuis l\'IP 172.16.230.1');
INSERT INTO `glpi_events` VALUES ('28371','3294','ticket','2023-02-27 16:59:25','tracking','4','hebera ajoute l\'élément 3294');
INSERT INTO `glpi_events` VALUES ('28370','-1','system','2023-02-27 16:58:49','login','3','hebera se connecte depuis l\'IP 172.16.124.1');
INSERT INTO `glpi_events` VALUES ('28369','3293','ticket','2023-02-27 16:20:01','tracking','4','hebera ajoute l\'élément 3293');
INSERT INTO `glpi_events` VALUES ('28368','-1','system','2023-02-27 16:18:35','login','3','hebera se connecte depuis l\'IP 172.16.124.1');
INSERT INTO `glpi_events` VALUES ('28367','3292','ticket','2023-02-27 13:00:37','tracking','4','lemief ajoute l\'élément 3292');
INSERT INTO `glpi_events` VALUES ('28366','-1','system','2023-02-27 12:58:44','login','3','lemief se connecte depuis l\'IP 172.16.102.11');
INSERT INTO `glpi_events` VALUES ('28365','-1','system','2023-02-27 12:58:32','login','1','Connexion échouée de lemief depuis l\'IP 172.16.102.11');
INSERT INTO `glpi_events` VALUES ('28364','-1','system','2023-02-27 11:35:37','login','3','simojul se connecte depuis l\'IP 172.16.106.59');
INSERT INTO `glpi_events` VALUES ('28363','1634','users','2023-02-27 11:29:07','setup','4','najara ajoute un utilisateur à une entité');
INSERT INTO `glpi_events` VALUES ('28362','1634','users','2023-02-27 11:28:41','setup','4','najara ajoute un utilisateur à une entité');
INSERT INTO `glpi_events` VALUES ('28361','-1','system','2023-02-27 11:24:23','login','3','najara se connecte depuis l\'IP 172.16.106.59');
INSERT INTO `glpi_events` VALUES ('28449','-1','system','2023-03-06 08:26:45','login','3','simojul se connecte depuis l\'IP 172.16.129.146');
INSERT INTO `glpi_events` VALUES ('28448','-1','system','2023-03-06 08:23:38','login','3','simojul se connecte depuis l\'IP 172.16.129.146');
INSERT INTO `glpi_events` VALUES ('28447','-1','system','2023-03-03 19:10:37','login','3','simojul se connecte depuis l\'IP 90.22.74.14');
INSERT INTO `glpi_events` VALUES ('28446','3281','ticket','2023-03-03 16:18:50','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28445','3269','ticket','2023-03-03 16:18:07','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28444','3299','ticket','2023-03-03 16:17:30','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28443','3259','ticket','2023-03-03 16:09:06','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28442','3296','ticket','2023-03-03 16:03:20','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28441','3301','ticket','2023-03-03 16:03:10','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28440','3255','ticket','2023-03-03 16:02:59','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28439','3254','ticket','2023-03-03 15:23:20','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28438','3256','ticket','2023-03-03 15:23:08','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28437','3215','ticket','2023-03-03 15:22:55','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28436','-1','system','2023-03-03 15:20:55','login','3','simojul se connecte depuis l\'IP 172.16.129.146');
INSERT INTO `glpi_events` VALUES ('28435','-1','system','2023-03-03 12:22:12','login','3','simojul se connecte depuis l\'IP 192.168.1.214');
INSERT INTO `glpi_events` VALUES ('28465','-1','system','2023-03-07 17:17:28','login','3','glpi se connecte depuis l\'IP 172.16.106.27');
INSERT INTO `glpi_events` VALUES ('28464','-1','system','2023-03-07 16:34:13','login','3','galldyl se connecte depuis l\'IP 172.16.136.25');
INSERT INTO `glpi_events` VALUES ('28463','3302','ticket','2023-03-07 15:54:54','tracking','4','bacqpie ajoute l\'élément 3302');
INSERT INTO `glpi_events` VALUES ('28462','-1','system','2023-03-07 15:47:00','login','3','bacqpie se connecte depuis l\'IP 172.16.126.12');
INSERT INTO `glpi_events` VALUES ('28461','-1','system','2023-03-07 15:05:04','login','3','simojul se connecte depuis l\'IP 172.16.106.100');
INSERT INTO `glpi_events` VALUES ('28460','-1','system','2023-03-07 15:01:43','login','3','simojul se connecte depuis l\'IP 172.16.106.100');
INSERT INTO `glpi_events` VALUES ('28459','-1','system','2023-03-07 14:59:42','login','3','simojul se connecte depuis l\'IP 172.16.106.100');
INSERT INTO `glpi_events` VALUES ('28458','-1','system','2023-03-07 14:11:15','login','3','simojul se connecte depuis l\'IP 172.16.106.100');
INSERT INTO `glpi_events` VALUES ('28457','-1','system','2023-03-07 11:58:03','login','3','simojul se connecte depuis l\'IP 109.94.48.219');
INSERT INTO `glpi_events` VALUES ('28331','-1','system','2023-02-06 08:13:59','login','3','alexmat se connecte depuis l\'IP 172.16.106.59');
INSERT INTO `glpi_events` VALUES ('28336','-1','system','2023-02-06 10:21:43','login','3','glpi se connecte depuis l\'IP 172.16.106.27');
INSERT INTO `glpi_events` VALUES ('28337','-1','system','2023-02-06 13:29:22','login','3','alexmat se connecte depuis l\'IP 172.16.106.59');
INSERT INTO `glpi_events` VALUES ('28338','3289','ticket','2023-02-06 13:29:38','tracking','4','alexmat met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28339','3289','ticket','2023-02-06 13:30:12','tracking','4','alexmat met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28340','3285','ticket','2023-02-06 13:30:43','tracking','4','alexmat met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28341','3285','ticket','2023-02-06 13:30:45','tracking','4','alexmat supprime un élément');
INSERT INTO `glpi_events` VALUES ('28342','3283','ticket','2023-02-06 13:30:57','tracking','4','alexmat met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28343','3283','ticket','2023-02-06 13:31:02','tracking','4','alexmat supprime un élément');
INSERT INTO `glpi_events` VALUES ('28344','3284','ticket','2023-02-06 13:31:40','tracking','4','alexmat met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28345','3284','ticket','2023-02-06 13:31:42','tracking','4','alexmat supprime un élément');
INSERT INTO `glpi_events` VALUES ('28346','3289','ticket','2023-02-06 13:57:50','tracking','4','alexmat met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28347','3289','ticket','2023-02-06 13:57:52','tracking','4','alexmat supprime un élément');
INSERT INTO `glpi_events` VALUES ('28348','3286','ticket','2023-02-06 13:58:00','tracking','4','alexmat met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28349','3286','ticket','2023-02-06 13:58:02','tracking','4','alexmat supprime un élément');
INSERT INTO `glpi_events` VALUES ('28350','-1','system','2023-02-07 10:42:33','login','1','Connexion échouée de evanm depuis l\'IP 172.16.136.7');
INSERT INTO `glpi_events` VALUES ('28351','-1','system','2023-02-07 10:42:45','login','3','moreeva se connecte depuis l\'IP 172.16.136.7');
INSERT INTO `glpi_events` VALUES ('28352','3290','ticket','2023-02-07 10:43:45','tracking','4','moreeva ajoute l\'élément 3290');
INSERT INTO `glpi_events` VALUES ('28353','-1','system','2023-02-07 17:55:27','login','1','Connexion échouée de barirom depuis l\'IP 130.180.219.245');
INSERT INTO `glpi_events` VALUES ('28354','-1','system','2023-02-07 17:55:43','login','3','barirom se connecte depuis l\'IP 130.180.219.245');
INSERT INTO `glpi_events` VALUES ('28355','-1','system','2023-02-12 08:47:52','login','3','hommet se connecte depuis l\'IP 37.170.57.180');
INSERT INTO `glpi_events` VALUES ('28356','-1','system','2023-02-27 08:14:00','login','3','carnpau se connecte depuis l\'IP 172.16.34.25');
INSERT INTO `glpi_events` VALUES ('28357','3291','ticket','2023-02-27 08:15:51','tracking','4','carnpau ajoute l\'élément 3291');
INSERT INTO `glpi_events` VALUES ('28358','-1','system','2023-02-27 11:16:53','login','3','ldap se connecte depuis l\'IP 172.16.106.59');
INSERT INTO `glpi_events` VALUES ('28359','-1','system','2023-02-27 11:18:49','login','1','Connexion échouée de alfredo depuis l\'IP 172.16.106.59');
INSERT INTO `glpi_events` VALUES ('28360','-1','system','2023-02-27 11:19:24','login','3','najara se connecte depuis l\'IP 172.16.106.59');
INSERT INTO `glpi_events` VALUES ('28377','3280','ticket','2023-02-28 11:43:16','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28378','3293','ticket','2023-02-28 11:43:29','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28379','-1','system','2023-02-28 12:11:42','login','3','simojul se connecte depuis l\'IP 172.16.106.59');
INSERT INTO `glpi_events` VALUES ('28380','3294','ticket','2023-02-28 13:11:28','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28381','-1','system','2023-02-28 14:00:12','login','3','simojul se connecte depuis l\'IP 172.16.129.146');
INSERT INTO `glpi_events` VALUES ('28382','-1','system','2023-02-28 14:05:20','login','3','simojul se connecte depuis l\'IP 172.16.129.146');
INSERT INTO `glpi_events` VALUES ('28383','-1','system','2023-02-28 14:24:10','login','3','simojul se connecte depuis l\'IP 172.16.242.1');
INSERT INTO `glpi_events` VALUES ('28384','3287','ticket','2023-02-28 14:33:07','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28385','3282','ticket','2023-02-28 14:33:20','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28386','-1','system','2023-02-28 14:48:43','login','3','simojul se connecte depuis l\'IP 172.16.26.1');
INSERT INTO `glpi_events` VALUES ('28387','3263','ticket','2023-02-28 14:49:13','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28388','-1','system','2023-02-28 14:55:30','login','3','simojul se connecte depuis l\'IP 172.16.18.1');
INSERT INTO `glpi_events` VALUES ('28389','3274','ticket','2023-02-28 14:58:12','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28390','3290','ticket','2023-02-28 15:14:09','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28391','-1','system','2023-02-28 15:35:46','login','1','Connexion échouée de glp depuis l\'IP 172.16.138.22');
INSERT INTO `glpi_events` VALUES ('28392','-1','system','2023-02-28 15:35:56','login','3','glpi se connecte depuis l\'IP 172.16.138.22');
INSERT INTO `glpi_events` VALUES ('28393','-1','system','2023-02-28 15:38:59','login','3','simojul se connecte depuis l\'IP 172.16.129.146');
INSERT INTO `glpi_events` VALUES ('28394','-1','system','2023-02-28 15:39:47','login','3','glpi se connecte depuis l\'IP 172.16.138.22');
INSERT INTO `glpi_events` VALUES ('28395','3292','ticket','2023-02-28 16:16:57','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28396','3288','ticket','2023-02-28 16:18:50','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28397','3279','ticket','2023-02-28 16:19:38','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28398','-1','system','2023-02-28 16:29:04','login','3','simojul se connecte depuis l\'IP 172.16.224.25');
INSERT INTO `glpi_events` VALUES ('28399','-1','system','2023-02-28 16:31:47','login','3','simojul se connecte depuis l\'IP 172.16.224.14');
INSERT INTO `glpi_events` VALUES ('28400','3271','ticket','2023-02-28 16:37:24','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28401','3271','ticket','2023-02-28 16:55:36','tracking','4','simojul ajoute un acteur');
INSERT INTO `glpi_events` VALUES ('28402','-1','system','2023-02-28 19:22:04','login','1','Connexion échouée de glpi depuis l\'IP 193.56.169.173');
INSERT INTO `glpi_events` VALUES ('28403','-1','system','2023-02-28 19:22:22','login','1','Connexion échouée de glpi depuis l\'IP 193.56.169.173');
INSERT INTO `glpi_events` VALUES ('28404','-1','system','2023-02-28 19:22:38','login','3','glpi se connecte depuis l\'IP 193.56.169.173');
INSERT INTO `glpi_events` VALUES ('28405','-1','system','2023-03-01 07:57:22','login','3','simojul se connecte depuis l\'IP 172.16.129.146');
INSERT INTO `glpi_events` VALUES ('28406','1634','users','2023-03-01 07:58:09','setup','5','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28407','-1','system','2023-03-01 08:27:25','login','3','simojul se connecte depuis l\'IP 172.16.129.146');
INSERT INTO `glpi_events` VALUES ('28408','-1','system','2023-03-01 08:32:19','login','3','simojul se connecte depuis l\'IP 172.16.34.23');
INSERT INTO `glpi_events` VALUES ('28409','-1','system','2023-03-01 08:38:21','login','3','simojul se connecte depuis l\'IP 172.16.34.24');
INSERT INTO `glpi_events` VALUES ('28410','3291','ticket','2023-03-01 08:38:37','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28411','-1','system','2023-03-01 08:44:33','login','3','simojul se connecte depuis l\'IP 172.16.32.1');
INSERT INTO `glpi_events` VALUES ('28412','3288','ticket','2023-03-01 08:44:57','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28413','-1','system','2023-03-01 08:45:06','login','3','boutef se connecte depuis l\'IP 172.16.111.1');
INSERT INTO `glpi_events` VALUES ('28414','3296','ticket','2023-03-01 08:47:31','tracking','4','boutef ajoute l\'élément 3296');
INSERT INTO `glpi_events` VALUES ('28415','-1','system','2023-03-01 11:03:45','login','1','Connexion échouée de LMazure depuis l\'IP 172.16.112.4');
INSERT INTO `glpi_events` VALUES ('28416','-1','system','2023-03-01 11:03:59','login','3','Mazurl se connecte depuis l\'IP 172.16.112.4');
INSERT INTO `glpi_events` VALUES ('28417','3297','ticket','2023-03-01 11:04:54','tracking','4','mazurl ajoute l\'élément 3297');
INSERT INTO `glpi_events` VALUES ('28418','-1','system','2023-03-01 12:04:09','login','1','Connexion échouée de scolaire depuis l\'IP 10.50.104.41');
INSERT INTO `glpi_events` VALUES ('28419','-1','system','2023-03-01 12:04:19','login','1','Connexion échouée de scolaire depuis l\'IP 10.50.104.41');
INSERT INTO `glpi_events` VALUES ('28420','-1','system','2023-03-01 12:04:32','login','1','Connexion échouée de scolaire depuis l\'IP 10.50.104.41');
INSERT INTO `glpi_events` VALUES ('28421','-1','system','2023-03-01 13:37:08','login','3','thomad se connecte depuis l\'IP 172.16.112.7');
INSERT INTO `glpi_events` VALUES ('28422','3298','ticket','2023-03-01 13:41:09','tracking','4','thomad ajoute l\'élément 3298');
INSERT INTO `glpi_events` VALUES ('28423','-1','system','2023-03-01 15:25:17','login','3','simojul se connecte depuis l\'IP 172.16.11.3');
INSERT INTO `glpi_events` VALUES ('28424','-1','system','2023-03-01 16:47:09','login','3','Lebouf se connecte depuis l\'IP 86.241.7.213');
INSERT INTO `glpi_events` VALUES ('28425','3299','ticket','2023-03-01 16:51:19','tracking','4','lebouf ajoute l\'élément 3299');
INSERT INTO `glpi_events` VALUES ('28426','-1','system','2023-03-02 07:52:52','login','3','guyotm se connecte depuis l\'IP 172.16.10.4');
INSERT INTO `glpi_events` VALUES ('28427','3300','ticket','2023-03-02 07:55:29','tracking','4','guyotm ajoute l\'élément 3300');
INSERT INTO `glpi_events` VALUES ('28428','-1','system','2023-03-02 08:44:16','login','3','simojul se connecte depuis l\'IP 130.180.219.245');
INSERT INTO `glpi_events` VALUES ('28429','3298','ticket','2023-03-02 08:45:48','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28430','3298','ticket','2023-03-02 08:46:01','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28431','3296','ticket','2023-03-02 11:57:14','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28432','-1','system','2023-03-03 09:56:37','login','3','boutef se connecte depuis l\'IP 172.16.111.1');
INSERT INTO `glpi_events` VALUES ('28433','3301','ticket','2023-03-03 09:59:12','tracking','4','boutef ajoute l\'élément 3301');
INSERT INTO `glpi_events` VALUES ('28434','-1','system','2023-03-03 10:13:37','login','3','simojul se connecte depuis l\'IP 192.168.1.20');
INSERT INTO `glpi_events` VALUES ('28450','3265','ticket','2023-03-06 09:34:51','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28451','3262','ticket','2023-03-06 09:35:09','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28452','-1','system','2023-03-06 09:53:04','login','3','simojul se connecte depuis l\'IP 172.16.106.100');
INSERT INTO `glpi_events` VALUES ('28453','3261','ticket','2023-03-06 09:53:31','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28454','3297','ticket','2023-03-06 11:05:29','tracking','4','simojul met à jour un élément');
INSERT INTO `glpi_events` VALUES ('28455','-1','system','2023-03-06 11:05:38','login','3','scan se connecte depuis l\'IP 172.16.106.100');
INSERT INTO `glpi_events` VALUES ('28456','-1','system','2023-03-06 11:06:31','login','3','simojul se connecte depuis l\'IP 172.16.106.100');
INSERT INTO `glpi_events` VALUES ('28466','-1','system','2023-03-07 19:34:11','login','3','glpi se connecte depuis l\'IP 193.56.169.173');

### Dump table glpi_fieldblacklists

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


### Dump table glpi_fieldunicities

CREATE TABLE `glpi_fieldunicities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `itemtype` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `entities_id` int(11) NOT NULL DEFAULT '-1',
  `fields` text COLLATE utf8_unicode_ci,
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `action_refuse` tinyint(1) NOT NULL DEFAULT '0',
  `action_notify` tinyint(1) NOT NULL DEFAULT '0',
  `comment` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Stores field unicity criterias';


### Dump table glpi_filesystems

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

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

### Dump table glpi_fqdns

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


### Dump table glpi_groups

CREATE TABLE `glpi_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci,
  `ldap_field` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ldap_value` text COLLATE utf8_unicode_ci,
  `ldap_group_dn` text COLLATE utf8_unicode_ci,
  `date_mod` datetime DEFAULT NULL,
  `groups_id` int(11) NOT NULL DEFAULT '0',
  `completename` text COLLATE utf8_unicode_ci,
  `level` int(11) NOT NULL DEFAULT '0',
  `ancestors_cache` longtext COLLATE utf8_unicode_ci,
  `sons_cache` longtext COLLATE utf8_unicode_ci,
  `is_requester` tinyint(1) NOT NULL DEFAULT '1',
  `is_assign` tinyint(1) NOT NULL DEFAULT '1',
  `is_notify` tinyint(1) NOT NULL DEFAULT '1',
  `is_itemgroup` tinyint(1) NOT NULL DEFAULT '1',
  `is_usergroup` tinyint(1) NOT NULL DEFAULT '1',
  `is_manager` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `ldap_field` (`ldap_field`),
  KEY `entities_id` (`entities_id`),
  KEY `date_mod` (`date_mod`),
  KEY `ldap_value` (`ldap_value`(200)),
  KEY `ldap_group_dn` (`ldap_group_dn`(200)),
  KEY `groups_id` (`groups_id`),
  KEY `is_requester` (`is_requester`),
  KEY `is_assign` (`is_assign`),
  KEY `is_notify` (`is_notify`),
  KEY `is_itemgroup` (`is_itemgroup`),
  KEY `is_usergroup` (`is_usergroup`),
  KEY `is_manager` (`is_manager`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `glpi_groups` VALUES ('1','0','0','poste prof','',NULL,NULL,NULL,'2016-04-29 08:42:45','0','poste prof','1',NULL,'{\"1\":\"1\"}','1','1','1','1','1','1');

### Dump table glpi_groups_knowbaseitems

CREATE TABLE `glpi_groups_knowbaseitems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `knowbaseitems_id` int(11) NOT NULL DEFAULT '0',
  `groups_id` int(11) NOT NULL DEFAULT '0',
  `entities_id` int(11) NOT NULL DEFAULT '-1',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `knowbaseitems_id` (`knowbaseitems_id`),
  KEY `groups_id` (`groups_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


### Dump table glpi_groups_problems

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


### Dump table glpi_groups_reminders

CREATE TABLE `glpi_groups_reminders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reminders_id` int(11) NOT NULL DEFAULT '0',
  `groups_id` int(11) NOT NULL DEFAULT '0',
  `entities_id` int(11) NOT NULL DEFAULT '-1',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `reminders_id` (`reminders_id`),
  KEY `groups_id` (`groups_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


### Dump table glpi_groups_rssfeeds

CREATE TABLE `glpi_groups_rssfeeds` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rssfeeds_id` int(11) NOT NULL DEFAULT '0',
  `groups_id` int(11) NOT NULL DEFAULT '0',
  `entities_id` int(11) NOT NULL DEFAULT '-1',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `rssfeeds_id` (`rssfeeds_id`),
  KEY `groups_id` (`groups_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


### Dump table glpi_groups_tickets

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

INSERT INTO `glpi_groups_tickets` VALUES ('1','2891','1','1');
INSERT INTO `glpi_groups_tickets` VALUES ('2','2919','1','1');
INSERT INTO `glpi_groups_tickets` VALUES ('3','2929','1','1');
INSERT INTO `glpi_groups_tickets` VALUES ('4','2947','1','1');
INSERT INTO `glpi_groups_tickets` VALUES ('5','2990','1','1');
INSERT INTO `glpi_groups_tickets` VALUES ('6','3047','1','1');

### Dump table glpi_groups_users

CREATE TABLE `glpi_groups_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `users_id` int(11) NOT NULL DEFAULT '0',
  `groups_id` int(11) NOT NULL DEFAULT '0',
  `is_dynamic` tinyint(1) NOT NULL DEFAULT '0',
  `is_manager` tinyint(1) NOT NULL DEFAULT '0',
  `is_userdelegate` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`users_id`,`groups_id`),
  KEY `groups_id` (`groups_id`),
  KEY `is_manager` (`is_manager`),
  KEY `is_userdelegate` (`is_userdelegate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


### Dump table glpi_holidays

CREATE TABLE `glpi_holidays` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entities_id` int(11) NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `comment` text COLLATE utf8_unicode_ci,
  `begin_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `is_perpetual` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `begin_date` (`begin_date`),
  KEY `end_date` (`end_date`),
  KEY `is_perpetual` (`is_perpetual`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


### Dump table glpi_infocoms

CREATE TABLE `glpi_infocoms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `items_id` int(11) NOT NULL DEFAULT '0',
  `itemtype` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `entities_id` int(11) NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `buy_date` date DEFAULT NULL,
  `use_date` date DEFAULT NULL,
  `warranty_duration` int(11) NOT NULL DEFAULT '0',
  `warranty_info` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `suppliers_id` int(11) NOT NULL DEFAULT '0',
  `order_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `delivery_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `immo_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` decimal(20,4) NOT NULL DEFAULT '0.0000',
  `warranty_value` decimal(20,4) NOT NULL DEFAULT '0.0000',
  `sink_time` int(11) NOT NULL DEFAULT '0',
  `sink_type` int(11) NOT NULL DEFAULT '0',
  `sink_coeff` float NOT NULL DEFAULT '0',
  `comment` text COLLATE utf8_unicode_ci,
  `bill` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `budgets_id` int(11) NOT NULL DEFAULT '0',
  `alert` int(11) NOT NULL DEFAULT '0',
  `order_date` date DEFAULT NULL,
  `delivery_date` date DEFAULT NULL,
  `inventory_date` date DEFAULT NULL,
  `warranty_date` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`itemtype`,`items_id`),
  KEY `buy_date` (`buy_date`),
  KEY `alert` (`alert`),
  KEY `budgets_id` (`budgets_id`),
  KEY `suppliers_id` (`suppliers_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `glpi_infocoms` VALUES ('1','60','Computer','0','0','1999-09-02',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'1999-09-02');
INSERT INTO `glpi_infocoms` VALUES ('2','61','Computer','0','0','1999-09-02',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'1999-09-02');
INSERT INTO `glpi_infocoms` VALUES ('3','537','Computer','0','0','1999-09-02',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'1999-09-02');
INSERT INTO `glpi_infocoms` VALUES ('4','101','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('5','102','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('6','103','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('7','104','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('8','105','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('9','106','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('10','107','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('11','108','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('12','109','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('13','110','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('14','111','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('15','112','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('16','113','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('17','114','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('18','115','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('19','116','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('20','117','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('21','118','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('22','119','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('23','120','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('24','121','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('25','530','Computer','0','0','2005-09-01','2005-09-01','0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('26','534','Computer','0','0','2001-09-01','2005-09-01','0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('27','220','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('28','221','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('29','222','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('30','223','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('31','224','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('32','225','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('33','226','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('34','227','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('35','228','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('36','229','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('37','230','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('38','231','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('39','232','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('40','233','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('41','234','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('42','235','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('43','236','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('44','237','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('45','238','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('46','239','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('47','240','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('48','241','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('49','242','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('50','243','Computer','0','0','2002-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-03');
INSERT INTO `glpi_infocoms` VALUES ('52','15','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('53','16','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('54','17','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('55','18','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('56','19','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('57','20','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('58','21','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('59','22','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('60','23','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('61','24','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('62','246','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('63','247','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('64','248','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('65','249','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('66','250','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('67','251','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('68','252','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('69','253','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('71','255','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('72','256','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('73','257','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('74','258','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('75','259','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('76','262','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('77','263','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('78','264','Computer','0','0','2002-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-04');
INSERT INTO `glpi_infocoms` VALUES ('79','531','Computer','0','0','2005-09-01','2005-09-01','0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('80','301','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('81','302','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('82','303','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('83','304','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('84','305','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('85','306','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('86','307','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('87','308','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('88','309','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('89','310','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('90','311','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('91','312','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('92','313','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('93','314','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('94','315','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('95','316','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('96','317','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('97','318','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('98','319','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('99','320','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('100','321','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('101','322','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('102','323','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('103','324','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('104','325','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('105','326','Computer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('106','528','Computer','0','0','2005-09-01','2005-09-01','0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('107','529','Computer','0','0','2005-09-01','2005-09-01','0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('108','328','Computer','0','0','2003-09-02',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-02');
INSERT INTO `glpi_infocoms` VALUES ('109','329','Computer','0','0','2003-09-02',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-02');
INSERT INTO `glpi_infocoms` VALUES ('110','330','Computer','0','0','2003-09-02',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-02');
INSERT INTO `glpi_infocoms` VALUES ('111','331','Computer','0','0','2003-09-02',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-02');
INSERT INTO `glpi_infocoms` VALUES ('112','332','Computer','0','0','2003-09-02',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-02');
INSERT INTO `glpi_infocoms` VALUES ('113','536','Computer','0','0','2005-09-01','2005-09-01','0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('124','431','Computer','0','0','2004-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2004-09-01');
INSERT INTO `glpi_infocoms` VALUES ('126','433','Computer','0','0','2004-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2004-09-01');
INSERT INTO `glpi_infocoms` VALUES ('136','446','Computer','0','0','2004-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2004-09-01');
INSERT INTO `glpi_infocoms` VALUES ('137','447','Computer','0','0','2004-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2004-09-01');
INSERT INTO `glpi_infocoms` VALUES ('156','532','Computer','0','0','2005-09-01','2005-09-01','0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('157','533','Computer','0','0','2005-09-01','2005-09-01','0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('168','538','Computer','0','0','2004-12-15',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2004-12-15');
INSERT INTO `glpi_infocoms` VALUES ('169','117','Printer','0','0','1998-09-12',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'1998-09-12');
INSERT INTO `glpi_infocoms` VALUES ('170','12','Printer','0','0','1999-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'1999-09-03');
INSERT INTO `glpi_infocoms` VALUES ('171','74','Printer','0','0','2000-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2000-09-04');
INSERT INTO `glpi_infocoms` VALUES ('172','179','Printer','0','0','2000-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2000-09-04');
INSERT INTO `glpi_infocoms` VALUES ('173','178','Printer','0','0','2000-09-04',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2000-09-04');
INSERT INTO `glpi_infocoms` VALUES ('174','76','Printer','0','0','2000-12-15',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2000-12-15');
INSERT INTO `glpi_infocoms` VALUES ('175','123','Printer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('176','124','Printer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('177','150','Printer','0','0','2001-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-03');
INSERT INTO `glpi_infocoms` VALUES ('178','268','Printer','0','0','2001-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-03');
INSERT INTO `glpi_infocoms` VALUES ('179','141','Printer','0','0','2001-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-03');
INSERT INTO `glpi_infocoms` VALUES ('180','180','Printer','0','0','2001-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-03');
INSERT INTO `glpi_infocoms` VALUES ('181','210','Printer','0','0','2001-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-03');
INSERT INTO `glpi_infocoms` VALUES ('182','142','Printer','0','0','2001-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-03');
INSERT INTO `glpi_infocoms` VALUES ('183','334','Printer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('184','333','Printer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('185','342','Printer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('186','181','Printer','0','0','2003-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2003-09-01');
INSERT INTO `glpi_infocoms` VALUES ('187','435','Printer','0','0','2004-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2004-09-01');
INSERT INTO `glpi_infocoms` VALUES ('188','437','Printer','0','0','2004-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2004-09-01');
INSERT INTO `glpi_infocoms` VALUES ('190','439','Printer','0','0','2004-10-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2004-10-01');
INSERT INTO `glpi_infocoms` VALUES ('191','438','Printer','0','0','2004-10-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2004-10-01');
INSERT INTO `glpi_infocoms` VALUES ('192','28','NetworkEquipment','0','0','2001-09-03',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-03');
INSERT INTO `glpi_infocoms` VALUES ('193','1','Peripheral','0','0','1999-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'1999-09-01');
INSERT INTO `glpi_infocoms` VALUES ('194','554','Computer','0','0','1999-09-02',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'1999-09-02');
INSERT INTO `glpi_infocoms` VALUES ('195','591','Computer','0','0','2004-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2004-09-01');
INSERT INTO `glpi_infocoms` VALUES ('196','132','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('197','512','Computer','0','0',NULL,NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('198','62','Computer','0','0',NULL,NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('199','526','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('200','527','Computer','0','0','2005-09-01','2005-09-01','0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('201','525','Computer','0','0','2005-09-01','2005-09-01','0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('202','127','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('203','128','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('204','129','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('205','130','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('206','133','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('207','135','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('208','137','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('209','139','Computer','0','0','2001-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2001-09-01');
INSERT INTO `glpi_infocoms` VALUES ('210','592','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('211','593','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('212','245','Computer','0','0','2002-09-02',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,'2002-09-02');
INSERT INTO `glpi_infocoms` VALUES ('213','594','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('214','598','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('215','599','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('216','600','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('219','1','CartridgeItem','0','0',NULL,NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('220','2','Cartridge','0','0',NULL,NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0',NULL,NULL,NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('221','603','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('222','604','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('224','606','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('225','607','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('226','608','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('227','609','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('228','610','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('229','611','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('230','612','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('231','613','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('232','614','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('233','615','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('234','616','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('235','617','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('236','618','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('237','619','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('238','620','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('239','621','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('240','622','Computer','0','0','2006-09-01','2006-09-05','0','','0','','','','0.0000','0.0000','0','0','0','rdc + bechtle','','0','0',NULL,NULL,NULL,'2006-09-01');
INSERT INTO `glpi_infocoms` VALUES ('241','623','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('242','624','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('243','625','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('245','627','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('246','628','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('247','629','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('248','630','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('252','634','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('255','637','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('262','644','Computer','0','0','2005-09-05','2014-03-05','0','','0','045','045','045','1450.0000','0.0000','3','2','25','Charlie 12 + bechtle','045','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('265','647','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('267','649','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('268','650','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('269','651','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('270','652','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('271','918','Computer','0','0',NULL,NULL,'0',NULL,'0',NULL,NULL,NULL,'0.0000','0.0000','0','0','0',NULL,NULL,'0','0',NULL,NULL,NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('272','925','Computer','0','0',NULL,NULL,'0',NULL,'0',NULL,NULL,NULL,'0.0000','0.0000','0','0','0',NULL,NULL,'0','0',NULL,NULL,NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('273','911','Computer','0','0','2009-09-01','2010-01-01','0',NULL,'0',NULL,NULL,NULL,'800.0000','0.0000','4','2','0.25','
',NULL,'0','0',NULL,NULL,NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('274','1','Cartridge','0','0',NULL,NULL,'0','','0','','','','0.0000','0.0000','0','0','0','','','0','0','0000-00-00','0000-00-00','0000-00-00','0000-00-00');
INSERT INTO `glpi_infocoms` VALUES ('275','929','Computer','0','0','2010-01-01','2010-01-01','0',NULL,'0',NULL,NULL,NULL,'800.0000','0.0000','4','2','0.25',NULL,NULL,'0','0',NULL,NULL,NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('276','909','Computer','0','0','2009-09-01','2014-03-05','0',NULL,'0',NULL,NULL,NULL,'3000.0000','0.0000','6','2','0.5',NULL,NULL,'0','0',NULL,NULL,NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('277','921','Computer','0','0','2009-09-01','2010-01-01','0',NULL,'0',NULL,NULL,NULL,'800.0000','0.0000','4','2','0.25',NULL,NULL,'0','0',NULL,NULL,NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('280','1041','Computer','0','0',NULL,'2009-09-01','0',NULL,'0',NULL,NULL,NULL,'800.0000','0.0000','4','2','0.25',NULL,NULL,'0','0',NULL,NULL,NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('281','910','Computer','0','0','2009-09-01','2010-01-01','0',NULL,'0',NULL,NULL,NULL,'800.0000','0.0000','4','2','0.27',NULL,NULL,'0','0',NULL,NULL,NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('282','922','Computer','0','0','2009-09-01','2009-09-01','0',NULL,'0',NULL,NULL,NULL,'800.0000','0.0000','4','2','0.25',NULL,NULL,'0','0',NULL,NULL,NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('283','927','Computer','0','0','2014-01-01','2014-06-01','0',NULL,'0','123',NULL,NULL,'800.0000','0.0000','4','2','0.25',NULL,NULL,'0','0',NULL,NULL,NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('284','928','Computer','0','0','2009-09-01','2010-01-01','0',NULL,'0',NULL,NULL,NULL,'800.0000','0.0000','4','2','0.25',NULL,NULL,'0','0',NULL,NULL,NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('285','1028','Computer','0','0','2009-09-01','2010-01-01','0',NULL,'4',NULL,NULL,NULL,'800.0000','0.0000','4','2','0.25',NULL,NULL,'0','0',NULL,NULL,NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('286','930','Computer','0','0','2009-09-01','2010-01-01','0',NULL,'0',NULL,NULL,NULL,'800.0000','0.0000','4','2','0.25',NULL,NULL,'0','0',NULL,NULL,NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('287','915','Computer','0','0','2013-01-01','2013-01-01','0',NULL,'0',NULL,NULL,NULL,'850.0000','0.0000','4','2','0.25',NULL,NULL,'0','0','2013-01-01','2013-01-01','2017-01-01',NULL);
INSERT INTO `glpi_infocoms` VALUES ('288','916','Computer','0','0','2014-01-01','2014-03-01','0',NULL,'4',NULL,NULL,NULL,'2000.0000','0.0000','4','2','0.25',NULL,NULL,'0','0','2014-01-01','2014-03-05','2014-01-01',NULL);
INSERT INTO `glpi_infocoms` VALUES ('289','1045','Computer','0','0',NULL,NULL,'0',NULL,'0',NULL,NULL,NULL,'0.0000','0.0000','0','0','0',NULL,NULL,'0','0',NULL,NULL,NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('290','748','Computer','0','0','2014-12-01','2014-12-06','0',NULL,'6','999','999','999','1000.0000','0.0000','4','2','20',NULL,'999','0','0','2014-12-01','2014-12-04',NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('291','934','Computer','0','0',NULL,NULL,'0',NULL,'0',NULL,NULL,NULL,'0.0000','0.0000','0','0','0',NULL,NULL,'0','0',NULL,NULL,NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('292','749','Computer','0','0','2014-11-07',NULL,'0',NULL,'5','',NULL,'','1000.0000','0.0000','3','2','25',NULL,NULL,'0','0',NULL,NULL,NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('293','501','Computer','0','0','2014-03-05','2014-03-05','0',NULL,'6','458','14','6','600.0000','0.0000','4','2','25',NULL,'963258741','0','0','2014-03-05','2014-03-05',NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('294','1255','Computer','0','0',NULL,NULL,'0',NULL,'4','',NULL,NULL,'0.0000','0.0000','0','0','0',NULL,NULL,'0','0',NULL,NULL,NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('297','931','Computer','0','0','2014-03-03','2014-03-04','120',NULL,'5',NULL,NULL,NULL,'800.0000','0.0000','4','2','25',NULL,NULL,'0','4',NULL,NULL,NULL,'2014-03-03');
INSERT INTO `glpi_infocoms` VALUES ('296','939','Computer','0','0','2014-09-05','2014-09-06','0',NULL,'6',NULL,NULL,NULL,'2900.0000','300.0000','10','2','50',NULL,NULL,'0','0','2014-09-05',NULL,'2014-11-05',NULL);
INSERT INTO `glpi_infocoms` VALUES ('298','6555','Computer','0','0','2005-09-01',NULL,'0','','0','','','','0.0000','0.0000','0','0','0','Charlie 12 + bechtle','','0','0',NULL,NULL,NULL,'2005-09-01');
INSERT INTO `glpi_infocoms` VALUES ('300','2032','Computer','0','0',NULL,NULL,'0',NULL,'0',NULL,NULL,NULL,'2000.0000','0.0000','4','0','0',NULL,NULL,'0','0',NULL,NULL,NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('301','1882','Computer','0','0',NULL,NULL,'0',NULL,'0',NULL,NULL,NULL,'0.0000','0.0000','0','0','0',NULL,NULL,'0','0',NULL,NULL,NULL,NULL);
INSERT INTO `glpi_infocoms` VALUES ('302','1850','Computer','0','0',NULL,NULL,'0',NULL,'0',NULL,NULL,NULL,'1000.0000','0.0000','5','2','0.2',NULL,NULL,'0','0',NULL,NULL,NULL,NULL);

### Dump table glpi_interfacetypes

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

INSERT INTO `glpi_interfacetypes` VALUES ('1','IDE',NULL);
INSERT INTO `glpi_interfacetypes` VALUES ('2','SATA',NULL);
INSERT INTO `glpi_interfacetypes` VALUES ('3','SCSI',NULL);
INSERT INTO `glpi_interfacetypes` VALUES ('4','USB',NULL);
INSERT INTO `glpi_interfacetypes` VALUES ('5','AGP','');
INSERT INTO `glpi_interfacetypes` VALUES ('6','PCI','');
INSERT INTO `glpi_interfacetypes` VALUES ('7','PCIe','');
INSERT INTO `glpi_interfacetypes` VALUES ('8','PCI-X','');

### Dump table glpi_ipaddresses

CREATE TABLE `glpi_ipaddresses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL DEFAULT '0',
  `items_id` int(11) NOT NULL DEFAULT '0',
  `itemtype` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `version` tinyint(3) unsigned DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `binary_0` int(10) unsigned NOT NULL DEFAULT '0',
  `binary_1` int(10) unsigned NOT NULL DEFAULT '0',
  `binary_2` int(10) unsigned NOT NULL DEFAULT '0',
  `binary_3` int(10) unsigned NOT NULL DEFAULT '0',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `is_dynamic` tinyint(1) NOT NULL DEFAULT '0',
  `mainitems_id` int(11) NOT NULL DEFAULT '0',
  `mainitemtype` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `entities_id` (`entities_id`),
  KEY `textual` (`name`),
  KEY `binary` (`binary_0`,`binary_1`,`binary_2`,`binary_3`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `item` (`itemtype`,`items_id`,`is_deleted`),
  KEY `mainitem` (`mainitemtype`,`mainitems_id`,`is_deleted`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `glpi_ipaddresses` VALUES ('1','0','1','NetworkName','4','10.10.0.26','0','0','65535','168427546','0','0','8','Computer');
INSERT INTO `glpi_ipaddresses` VALUES ('2','0','2','NetworkName','4','10.10.0.27','0','0','65535','168427547','0','0','10','Computer');
INSERT INTO `glpi_ipaddresses` VALUES ('3','0','3','NetworkName','4','10.10.0.28','0','0','65535','168427548','0','0','15','Computer');
INSERT INTO `glpi_ipaddresses` VALUES ('4','0','4','NetworkName','4','10.10.0.29','0','0','65535','168427549','0','0','18','Computer');
INSERT INTO `glpi_ipaddresses` VALUES ('5','0','5','NetworkName','4','10.10.0.1','0','0','65535','168427521','0','0','9','NetworkEquipment');
INSERT INTO `glpi_ipaddresses` VALUES ('6','0','6','NetworkName','4','10.10.0.1','0','0','65535','168427521','0','0','9','NetworkEquipment');
INSERT INTO `glpi_ipaddresses` VALUES ('7','0','7','NetworkName','4','10.10.0.1','0','0','65535','168427521','0','0','9','NetworkEquipment');
INSERT INTO `glpi_ipaddresses` VALUES ('8','0','8','NetworkName','4','172.16.122.252','0','0','65535','2886761212','0','0','30','NetworkEquipment');

### Dump table glpi_ipaddresses_ipnetworks

CREATE TABLE `glpi_ipaddresses_ipnetworks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ipaddresses_id` int(11) NOT NULL DEFAULT '0',
  `ipnetworks_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`ipaddresses_id`,`ipnetworks_id`),
  KEY `ipnetworks_id` (`ipnetworks_id`),
  KEY `ipaddresses_id` (`ipaddresses_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


### Dump table glpi_ipnetworks

CREATE TABLE `glpi_ipnetworks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `ipnetworks_id` int(11) NOT NULL DEFAULT '0',
  `completename` text COLLATE utf8_unicode_ci,
  `level` int(11) NOT NULL DEFAULT '0',
  `ancestors_cache` longtext COLLATE utf8_unicode_ci,
  `sons_cache` longtext COLLATE utf8_unicode_ci,
  `addressable` tinyint(1) NOT NULL DEFAULT '0',
  `version` tinyint(3) unsigned DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address_0` int(10) unsigned NOT NULL DEFAULT '0',
  `address_1` int(10) unsigned NOT NULL DEFAULT '0',
  `address_2` int(10) unsigned NOT NULL DEFAULT '0',
  `address_3` int(10) unsigned NOT NULL DEFAULT '0',
  `netmask` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `netmask_0` int(10) unsigned NOT NULL DEFAULT '0',
  `netmask_1` int(10) unsigned NOT NULL DEFAULT '0',
  `netmask_2` int(10) unsigned NOT NULL DEFAULT '0',
  `netmask_3` int(10) unsigned NOT NULL DEFAULT '0',
  `gateway` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `gateway_0` int(10) unsigned NOT NULL DEFAULT '0',
  `gateway_1` int(10) unsigned NOT NULL DEFAULT '0',
  `gateway_2` int(10) unsigned NOT NULL DEFAULT '0',
  `gateway_3` int(10) unsigned NOT NULL DEFAULT '0',
  `comment` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `network_definition` (`entities_id`,`address`,`netmask`),
  KEY `address` (`address_0`,`address_1`,`address_2`,`address_3`),
  KEY `netmask` (`netmask_0`,`netmask_1`,`netmask_2`,`netmask_3`),
  KEY `gateway` (`gateway_0`,`gateway_1`,`gateway_2`,`gateway_3`),
  KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


### Dump table glpi_ipnetworks_vlans

CREATE TABLE `glpi_ipnetworks_vlans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ipnetworks_id` int(11) NOT NULL DEFAULT '0',
  `vlans_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `link` (`ipnetworks_id`,`vlans_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


### Dump table glpi_items_devicecases

CREATE TABLE `glpi_items_devicecases` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `items_id` int(11) NOT NULL DEFAULT '0',
  `itemtype` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `devicecases_id` int(11) NOT NULL DEFAULT '0',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `is_dynamic` tinyint(1) NOT NULL DEFAULT '0',
  `entities_id` int(11) NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `serial` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `computers_id` (`items_id`),
  KEY `devicecases_id` (`devicecases_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `serial` (`serial`),
  KEY `item` (`itemtype`,`items_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `glpi_items_devicecases` VALUES ('1801','653','Computer','1','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2001','737','Computer','1','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2007','738','Computer','1','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2013','739','Computer','1','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2019','740','Computer','1','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2025','741','Computer','1','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2031','742','Computer','1','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2037','743','Computer','1','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2043','744','Computer','1','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2049','745','Computer','1','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2055','746','Computer','1','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2197','900','Computer','1','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4048','703','Computer','2','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4051','704','Computer','2','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4057','706','Computer','2','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4060','707','Computer','2','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4054','708','Computer','2','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4043','830','Computer','2','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4068','701','Computer','2','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2089','802','Computer','3','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2094','803','Computer','3','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2099','804','Computer','3','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2104','805','Computer','3','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2109','806','Computer','3','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2114','807','Computer','3','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2119','808','Computer','3','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2124','809','Computer','3','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2129','810','Computer','3','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2134','811','Computer','3','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2139','812','Computer','3','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2144','813','Computer','3','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2149','814','Computer','3','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2154','815','Computer','3','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2159','816','Computer','3','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2164','817','Computer','3','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2625','801','Computer','3','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2630','968','Computer','3','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2635','842','Computer','3','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2706','839','Computer','4','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2701','838','Computer','4','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2696','837','Computer','4','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2691','836','Computer','4','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2686','835','Computer','4','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2681','841','Computer','4','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2676','976','Computer','4','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2671','975','Computer','4','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2666','974','Computer','4','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2661','973','Computer','4','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2656','972','Computer','4','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2651','971','Computer','4','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2646','970','Computer','4','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2640','969','Computer','4','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2711','840','Computer','4','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2729','985','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4223','1017','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4224','1018','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4226','1020','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3967','6181','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3975','6182','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3976','934','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3988','966','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3990','964','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3992','963','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3994','962','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3996','935','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3998','961','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4000','960','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4002','959','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4004','958','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4006','957','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4008','956','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4010','955','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4012','954','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4014','953','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4016','952','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4018','951','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4020','950','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4022','949','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4024','948','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4026','947','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4028','946','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4030','945','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4032','944','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4034','943','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4036','942','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4038','967','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4040','933','Computer','5','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2721','987','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2738','988','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2747','989','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2756','990','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2765','991','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2774','992','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2783','993','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2792','994','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2801','995','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('2810','996','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4080','914','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3233','6115','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3242','6116','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3363','6133','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3372','6134','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3445','912','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3447','913','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3899','911','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3904','916','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3909','917','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3914','920','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3919','921','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3924','922','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3928','927','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3933','928','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3939','929','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3945','930','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4225','1019','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3957','932','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3405','1000','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3376','1001','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3378','1002','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3254','6117','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3385','1004','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3387','1005','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3307','1006','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3411','6135','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3389','1007','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3391','1009','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3393','1010','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3395','1011','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3374','1012','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4228','1014','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3348','1015','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3402','1016','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3223','6113','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3260','6118','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3266','6119','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3272','6120','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3278','6121','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3284','6122','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3290','6123','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3296','6124','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3302','6125','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3313','6126','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3319','6127','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3325','6128','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3331','6129','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3337','6130','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3343','6131','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3354','6132','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3383','1003','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3417','6136','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3423','6137','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3429','6138','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3435','6139','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3441','6140','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3483','6143','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3488','6145','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3493','6146','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3498','6147','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3505','997','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3510','6148','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3515','6149','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3520','6150','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3525','6151','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3530','6152','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3535','6153','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3540','6154','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3545','6155','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3550','6156','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3555','6157','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3560','6158','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3565','6159','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3570','6160','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3575','6161','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3580','6162','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3585','6163','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3590','6164','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3595','6165','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3600','6166','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3605','6167','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3610','6168','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3615','6169','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3620','6170','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3625','6171','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3630','6172','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3635','6173','Computer','8','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3858','998','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3773','1035','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3841','1022','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3694','1025','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3645','6175','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3757','1033','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3761','1034','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3777','1036','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3782','1037','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3789','1038','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3795','1039','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3800','1040','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3805','1041','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3814','1042','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3817','1043','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3825','1044','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3829','1045','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3747','1032','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3739','1031','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3729','1030','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3722','1029','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3713','1028','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3704','1027','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3686','1024','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3677','1023','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3667','1026','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3835','1046','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3653','6176','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3852','6177','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3857','6178','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3867','6179','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('3877','6180','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4069','819','Computer','2','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4070','818','Computer','2','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4071','820','Computer','2','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4072','821','Computer','2','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4073','822','Computer','2','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4074','824','Computer','2','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4075','825','Computer','2','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4076','826','Computer','2','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4077','827','Computer','2','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4078','828','Computer','2','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4081','901','Computer','10','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4083','6282','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4084','6283','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4085','0','','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4086','0','','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4087','0','','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4088','0','','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4089','0','','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4090','0','','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4091','0','','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4092','0','','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4093','0','','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4094','0','','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4095','0','','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4096','6285','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4097','0','','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4098','6286','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4099','0','','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4100','0','','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4101','0','','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4102','0','','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4103','0','','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4104','0','','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4105','0','','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4106','0','','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4107','0','','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4108','1301','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4109','1302','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4110','1270','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4111','6289','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4112','6290','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4113','6291','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4114','6292','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4115','6293','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4116','6294','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4117','6295','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4118','6296','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4119','6297','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4120','6298','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4121','6299','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4122','6300','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4123','6301','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4124','6302','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4125','6303','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4126','6304','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4127','6305','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4128','6306','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4129','6307','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4130','6308','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4131','6310','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4132','1251','Computer','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4133','6311','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4134','6312','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4135','6313','Computer','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4136','6314','Computer','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4137','6315','Computer','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4138','6316','Computer','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4139','6317','Computer','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4140','6318','Computer','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4141','6319','Computer','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4142','6320','Computer','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4143','6321','Computer','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4144','6322','Computer','12','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4145','6323','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4146','6324','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4147','6325','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4148','6326','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4149','6327','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4150','6328','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4151','6329','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4152','6330','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4153','6331','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4154','6332','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4155','6333','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4156','6334','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4157','6335','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4158','6336','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4159','6337','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4160','6338','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4161','6339','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4162','6340','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4163','1303','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4164','1304','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4186','1326','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4166','1305','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4167','1306','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4168','1307','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4169','1308','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4170','1309','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4171','1310','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4172','1311','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4173','1312','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4174','1313','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4175','1314','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4176','1315','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4177','1316','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4178','1317','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4179','1318','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4180','1319','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4181','1321','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4182','1322','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4183','1323','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4184','1324','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4185','1325','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4187','1335','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4188','1336','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4189','1337','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4190','1338','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4191','1339','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4192','1340','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4193','1341','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4194','1342','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4195','1343','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4196','1327','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4197','1255','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4198','1328','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4199','1329','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4200','1330','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4201','1331','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4202','1332','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4203','1333','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4204','1334','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4205','1320','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4206','6408','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4207','6415','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4208','6431','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4209','6434','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4210','6442','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4211','6443','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4212','6420','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4213','1497','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4214','6448','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4215','6449','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4216','6450','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4217','6451','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4218','6454','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4219','6484','Computer','4','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4220','1344','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4221','1345','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4222','6486','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4227','1021','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4229','1346','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4230','6519','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4231','1608','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4232','6520','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4233','1610','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4234','1611','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4235','1612','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4236','6527','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4237','6532','Computer','14','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4239','6541','Computer','14','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4240','6544','Computer','14','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4241','6545','Computer','14','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4242','6547','Computer','14','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4243','1049','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4244','6554','Computer','12','0','0','0','1','');
INSERT INTO `glpi_items_devicecases` VALUES ('4245','6556','Computer','12','0','0','0','1','');
INSERT INTO `glpi_items_devicecases` VALUES ('4246','1013','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4247','1008','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4248','931','Computer','7','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4249','1629','Computer','14','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4250','1620','Computer','14','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4251','1630','Computer','14','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4252','1631','Computer','14','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4253','1632','Computer','14','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4254','1633','Computer','14','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4255','1634','Computer','14','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4256','926','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4257','1601','Computer','6','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4258','1621','Computer','14','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4259','1622','Computer','14','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4260','1623','Computer','14','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4261','1625','Computer','14','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4262','1626','Computer','14','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4263','1627','Computer','14','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4264','1639','Computer','14','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4265','1628','Computer','14','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4266','1638','Computer','14','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4267','1637','Computer','14','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4268','1636','Computer','14','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4269','1635','Computer','14','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4270','1712','Computer','15','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4271','1721','Computer','15','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4272','1722','Computer','15','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4273','1723','Computer','15','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4274','1724','Computer','15','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4275','1725','Computer','15','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4276','1713','Computer','15','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4277','1714','Computer','15','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4278','1715','Computer','15','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4279','1716','Computer','15','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4280','1717','Computer','15','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4281','1718','Computer','15','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4282','1719','Computer','15','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4283','1720','Computer','15','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4284','6658','Computer','9','0','0','0','1','');
INSERT INTO `glpi_items_devicecases` VALUES ('4285','6665','Computer','9','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4286','18804','Computer','16','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4287','1732','Computer','16','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4288','1706','Computer','16','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4289','1877','Computer','16','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4290','1613','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4291','1619','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4292','18807','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4293','1646','Computer','11','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4294','18809','Computer','11','0','0','0','1','');
INSERT INTO `glpi_items_devicecases` VALUES ('4295','18810','Computer','11','0','0','0','1','');
INSERT INTO `glpi_items_devicecases` VALUES ('4296','18811','Computer','11','0','0','0','1','');
INSERT INTO `glpi_items_devicecases` VALUES ('4297','18812','Computer','11','0','0','0','1','');
INSERT INTO `glpi_items_devicecases` VALUES ('4298','18814','Computer','11','0','0','0','1','');
INSERT INTO `glpi_items_devicecases` VALUES ('4299','18815','Computer','11','0','0','0','1','');
INSERT INTO `glpi_items_devicecases` VALUES ('4300','18816','Computer','11','0','0','0','1','');
INSERT INTO `glpi_items_devicecases` VALUES ('4301','18819','Computer','16','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4302','18820','Computer','16','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4303','18821','Computer','16','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4304','18822','Computer','16','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4305','18823','Computer','16','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4306','18824','Computer','16','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4307','18825','Computer','16','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4308','18826','Computer','16','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4309','18827','Computer','11','0','0','0','1','');
INSERT INTO `glpi_items_devicecases` VALUES ('4310','18828','Computer','16','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4311','2002','Computer','17','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4312','843','Computer','2','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4313','1922','Computer','2','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4314','2010','Computer','17','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4315','1923','Computer','2','0','0','0','1',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4316','2011','Computer','17','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4317','2013','Computer','17','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4318','2014','Computer','17','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4319','2015','Computer','17','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4320','2016','Computer','17','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4321','2017','Computer','17','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4322','2018','Computer','17','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4323','2019','Computer','17','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4324','2020','Computer','17','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4325','2021','Computer','17','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4326','2022','Computer','17','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4327','2023','Computer','17','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4328','2024','Computer','17','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4329','2028','Computer','17','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4330','1624','Computer','14','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4331','18898','Computer','18','0','0','0','0',NULL);
INSERT INTO `glpi_items_devicecases` VALUES ('4332','18900','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4333','18901','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4334','18902','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4335','18903','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4336','18904','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4337','18905','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4338','18906','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4339','18907','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4340','18908','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4341','18909','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4342','18910','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4343','18911','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4344','18912','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4345','18913','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4346','18914','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4347','18915','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4348','18916','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4349','18917','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4350','18918','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4351','18919','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4352','18920','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4353','18921','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4354','18922','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4355','18923','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4356','18924','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4357','18925','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4358','18926','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4359','18927','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4360','18928','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4361','18929','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4362','18930','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4363','18931','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4364','18932','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4365','18933','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4366','18934','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4367','18935','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4368','18936','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4369','18937','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4370','18938','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4371','18939','Computer','18','0','0','0','0','');
INSERT INTO `glpi_items_devicecases` VALUES ('4372','18940','Computer','18','0','0','0','0','');

### Dump table glpi_items_devicecontrols

CREATE TABLE `glpi_items_devicecontrols` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `items_id` int(11) NOT NULL DEFAULT '0',
  `itemtype` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `devicecontrols_id` int(11) NOT NULL DEFAULT '0',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `is_dynamic` tinyint(1) NOT NULL DEFAULT '0',
  `entities_id` int(11) NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `serial` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `busID` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `computers_id` (`items_id`),
  KEY `devicecontrols_id` (`devicecontrols_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `serial` (`serial`),
  KEY `busID` (`busID`),
  KEY `item` (`itemtype`,`items_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


### Dump table glpi_items_devicedrives

CREATE TABLE `glpi_items_devicedrives` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `items_id` int(11) NOT NULL DEFAULT '0',
  `itemtype` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `devicedrives_id` int(11) NOT NULL DEFAULT '0',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `is_dynamic` tinyint(1) NOT NULL DEFAULT '0',
  `entities_id` int(11) NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `serial` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `busID` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `computers_id` (`items_id`),
  KEY `devicedrives_id` (`devicedrives_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `serial` (`serial`),
  KEY `busID` (`busID`),
  KEY `item` (`itemtype`,`items_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `glpi_items_devicedrives` VALUES ('1293','593','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1288','592','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1346','501','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1359','595','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1366','502','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1373','503','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1380','504','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1387','505','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1398','506','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1412','507','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1420','508','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1428','509','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1435','510','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1444','598','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1451','599','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1456','600','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1482','600','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2624','6356','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1500','604','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1512','606','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1518','607','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2633','6365','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2631','6363','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1542','611','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1548','612','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1554','613','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2629','6361','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1566','615','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2639','6371','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2637','6369','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2635','6367','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2627','6359','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1596','620','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1602','621','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1608','622','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1614','623','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1620','624','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1626','625','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1638','627','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1644','628','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1650','629','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1656','630','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1680','634','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1699','637','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1741','644','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1759','647','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1771','649','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1777','650','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1783','651','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1789','652','Computer','1','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2079','750','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2073','749','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2066','748','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1297','593','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1343','501','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1358','595','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1365','502','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1372','503','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1379','504','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1386','505','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1396','506','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1410','507','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1419','508','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1427','509','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1434','510','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1439','597','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1477','598','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1483','600','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2625','6357','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1501','604','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1513','606','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1519','607','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2632','6364','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2630','6362','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1543','611','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1549','612','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1555','613','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2628','6360','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1567','615','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2638','6370','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2636','6368','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2634','6366','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2626','6358','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1597','620','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1603','621','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1795','653','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1800','654','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1806','655','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1826','705','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1846','709','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1851','710','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1856','711','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1896','719','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1911','722','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2000','737','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2054','746','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2058','650','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2181','431','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2196','900','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2318','928','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2186','447','Computer','3','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1474','599','Computer','4','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1609','622','Computer','4','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1615','623','Computer','4','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1621','624','Computer','4','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1627','625','Computer','4','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1639','627','Computer','4','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1645','628','Computer','4','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1651','629','Computer','4','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1657','630','Computer','4','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1681','634','Computer','4','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1700','637','Computer','4','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1742','644','Computer','4','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1760','647','Computer','4','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1772','649','Computer','4','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1778','650','Computer','4','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1784','651','Computer','4','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('1790','652','Computer','4','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2210','903','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2215','904','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2220','905','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2225','906','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2230','907','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2235','908','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2240','909','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2245','910','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2324','932','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2329','933','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2339','935','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2344','936','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2349','937','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2354','938','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2359','939','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2364','940','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2369','941','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2374','942','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2379','943','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2384','944','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2389','945','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2394','946','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2399','947','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2404','948','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2409','949','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2414','950','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2419','951','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2424','952','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2429','953','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2434','954','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2439','955','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2444','956','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2449','957','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2454','958','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2459','959','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2464','960','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2469','961','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2474','962','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2479','963','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2484','964','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2489','965','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2499','819','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2529','820','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2534','821','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2539','822','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2544','823','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2549','824','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2554','825','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2559','826','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2575','834','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2580','833','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2585','832','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2590','831','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2595','830','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2605','828','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2610','827','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2615','967','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2620','818','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2621','901','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2622','1047','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2640','6372','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2641','6373','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2642','6374','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2643','6375','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2644','6376','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2645','1349','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2646','1401','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2647','1402','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2648','1403','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2649','1404','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2650','1405','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2651','1406','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2652','1407','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2653','1408','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2654','1409','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2655','1410','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2656','1411','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2657','1412','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2658','1413','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2659','1414','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2660','1415','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2661','1416','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2662','1417','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2663','1418','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2664','1419','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2665','1420','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2667','6484','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2668','6555','Computer','1','0','0','0','1','','');
INSERT INTO `glpi_items_devicedrives` VALUES ('2670','1601','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2671','925','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2672','1606','Computer','6','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2673','6572','Computer','7','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2674','6576','Computer','8','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2675','6575','Computer','8','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2676','1801','Computer','8','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2677','6577','Computer','8','0','0','0','0','','');
INSERT INTO `glpi_items_devicedrives` VALUES ('2678','6578','Computer','8','0','0','0','0','','');
INSERT INTO `glpi_items_devicedrives` VALUES ('2679','6579','Computer','8','0','0','0','0','','');
INSERT INTO `glpi_items_devicedrives` VALUES ('2680','6580','Computer','8','0','0','0','0','','');
INSERT INTO `glpi_items_devicedrives` VALUES ('2681','6581','Computer','8','0','0','0','0','','');
INSERT INTO `glpi_items_devicedrives` VALUES ('2682','6582','Computer','8','0','0','0','0','','');
INSERT INTO `glpi_items_devicedrives` VALUES ('2683','6583','Computer','8','0','0','0','0','','');
INSERT INTO `glpi_items_devicedrives` VALUES ('2684','1802','Computer','7','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2685','1803','Computer','8','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2686','6584','Computer','8','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2687','6585','Computer','8','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2688','6586','Computer','8','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2689','6587','Computer','8','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2690','6588','Computer','7','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2691','6589','Computer','8','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2692','6591','Computer','8','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2693','6592','Computer','8','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2694','6593','Computer','8','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2695','6596','Computer','8','0','0','0','0','','');
INSERT INTO `glpi_items_devicedrives` VALUES ('2696','6597','Computer','8','0','0','0','0','','');
INSERT INTO `glpi_items_devicedrives` VALUES ('2697','6598','Computer','8','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2698','1809','Computer','8','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2699','1808','Computer','8','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2700','1807','Computer','8','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2701','1810','Computer','7','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2702','1806','Computer','8','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2703','1811','Computer','7','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2704','1805','Computer','8','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2705','1816','Computer','8','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2706','1812','Computer','7','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2707','1813','Computer','7','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2708','1815','Computer','7','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2709','6615','Computer','2','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2710','6616','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2711','6617','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2712','1614','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2713','923','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2714','1350','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2715','18804','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2716','1732','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2717','1708','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2718','1602','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2719','1605','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2720','1731','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2721','18806','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2722','1851','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2723','1850','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2724','1852','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2725','1853','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2726','1854','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2727','1855','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2728','1856','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2729','1857','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2730','1858','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2731','1859','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2732','1860','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2733','1861','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2734','1862','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2735','1863','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2736','1864','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2737','1865','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2738','1900','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2739','18817','Computer','2','0','0','0','0','','');
INSERT INTO `glpi_items_devicedrives` VALUES ('2740','18818','Computer','2','0','0','0','0','','');
INSERT INTO `glpi_items_devicedrives` VALUES ('2741','1867','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2742','1868','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2743','1869','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2744','1870','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2745','1871','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2746','1872','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2747','1873','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2748','1874','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2749','1875','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2750','1876','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2751','1922','Computer','5','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2752','18880','Computer','2','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicedrives` VALUES ('2753','1866','Computer','2','0','0','0','0',NULL,NULL);

### Dump table glpi_items_devicegraphiccards

CREATE TABLE `glpi_items_devicegraphiccards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `items_id` int(11) NOT NULL DEFAULT '0',
  `itemtype` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `devicegraphiccards_id` int(11) NOT NULL DEFAULT '0',
  `memory` int(11) NOT NULL DEFAULT '0',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `is_dynamic` tinyint(1) NOT NULL DEFAULT '0',
  `entities_id` int(11) NOT NULL DEFAULT '0',
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `serial` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `busID` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `computers_id` (`items_id`),
  KEY `devicegraphiccards_id` (`devicegraphiccards_id`),
  KEY `specificity` (`memory`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `serial` (`serial`),
  KEY `busID` (`busID`),
  KEY `item` (`itemtype`,`items_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1390','525','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1392','526','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1395','527','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1397','528','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1399','529','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1400','530','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1401','531','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1402','532','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1407','533','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1409','534','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1414','536','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('2719','987','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('2727','985','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('2736','988','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('2745','989','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('2754','990','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('2763','991','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('2772','992','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('2781','993','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('2790','994','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('2799','995','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('2808','996','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('2826','998','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3231','6115','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3240','6116','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3361','6133','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3370','6134','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3865','6179','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3875','6180','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3965','6181','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3973','6182','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1004','539','Computer','2','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1012','540','Computer','2','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1017','541','Computer','2','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1022','542','Computer','2','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1027','543','Computer','2','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1032','544','Computer','2','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1037','545','Computer','2','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1042','546','Computer','2','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1047','547','Computer','2','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1052','548','Computer','2','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1','60','Computer','7','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('2','537','Computer','7','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1065','554','Computer','7','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3','15','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4','16','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('5','17','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('6','18','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('7','19','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('8','20','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('9','21','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('10','22','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('11','23','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('12','24','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('13','246','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('14','247','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('15','248','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('16','249','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('17','250','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('18','251','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('19','252','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('20','253','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('22','255','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('23','256','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('24','257','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('25','258','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('26','259','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('27','262','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('28','263','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('29','264','Computer','8','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('31','301','Computer','9','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('32','302','Computer','9','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('33','303','Computer','9','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('34','304','Computer','9','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('35','305','Computer','9','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('36','306','Computer','9','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('37','307','Computer','9','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('38','308','Computer','9','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('39','309','Computer','9','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('40','310','Computer','9','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('41','311','Computer','9','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('42','312','Computer','9','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('1302','245','Computer','9','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('44','220','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('45','221','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('46','222','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('47','223','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('48','224','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('49','225','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('50','226','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('51','227','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('52','228','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('53','229','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('54','230','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('55','231','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('56','232','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('57','233','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('58','234','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('59','235','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('60','236','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('61','237','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('62','238','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('63','239','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('64','240','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('65','241','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('66','242','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('67','243','Computer','10','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('69','328','Computer','11','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('70','329','Computer','11','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('71','330','Computer','11','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('72','331','Computer','11','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('73','332','Computer','11','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('75','61','Computer','12','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('76','0','','13','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('86','538','Computer','13','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3974','6282','Computer','1','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3975','1250','Computer','14','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3976','6288','Computer','14','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3978','1629','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3979','1616','Computer','5','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3980','1620','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3981','1630','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3982','0','','14','0','0','0','0','1',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3983','1631','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3984','1632','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3985','1633','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3986','1634','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3987','1621','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3988','1622','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3989','1623','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3990','1625','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3991','1626','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3992','1627','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3993','1639','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3994','1628','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3995','1638','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3996','1637','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3997','1636','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3998','1635','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('3999','1712','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4000','1721','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4001','1722','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4002','1723','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4003','1724','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4004','1725','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4005','1713','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4006','1714','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4007','1715','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4008','1716','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4009','1717','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4010','1718','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4011','1719','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4012','1720','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4013','6658','Computer','1','0','0','0','0','1','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4014','1905','Computer','5','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4015','1904','Computer','5','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4016','1902','Computer','5','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4017','1903','Computer','5','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4018','18807','Computer','5','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4019','18809','Computer','5','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4020','18810','Computer','5','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4021','18811','Computer','5','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4022','18812','Computer','5','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4023','18814','Computer','5','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4024','18815','Computer','5','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4025','18816','Computer','5','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4026','18827','Computer','5','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4027','18872','Computer','5','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4028','18871','Computer','5','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4029','18870','Computer','5','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4030','18869','Computer','5','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4031','1624','Computer','15','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4032','18898','Computer','16','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4033','18900','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4034','18901','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4035','18902','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4036','18903','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4037','18904','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4038','18905','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4039','18906','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4040','18907','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4041','18908','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4042','18909','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4043','18910','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4044','18911','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4045','18912','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4046','18913','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4047','18914','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4048','18915','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4049','18916','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4050','18917','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4051','18918','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4052','18919','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4053','18920','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4054','18921','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4055','18922','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4056','18923','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4057','18924','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4058','18925','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4059','18926','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4060','18927','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4061','18928','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4062','18929','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4063','18930','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4064','18931','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4065','18932','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4066','18933','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4067','18934','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4068','18935','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4069','18936','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4070','18937','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4071','18938','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4072','18939','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4073','18940','Computer','16','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4086','18956','Computer','17','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4075','18946','Computer','5','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4076','18947','Computer','5','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4077','18948','Computer','5','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4078','18949','Computer','5','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4079','18950','Computer','5','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4080','18951','Computer','5','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4081','18952','Computer','5','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4082','18953','Computer','5','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4083','18945','Computer','17','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4084','18954','Computer','17','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4085','18955','Computer','17','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4087','18957','Computer','17','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4088','18958','Computer','17','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4089','18959','Computer','17','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4090','18960','Computer','16','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4091','18961','Computer','18','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4092','18962','Computer','18','0','0','0','0','0','','');
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4093','1924','Computer','16','0','0','0','0','0',NULL,NULL);
INSERT INTO `glpi_items_devicegraphiccards` VALUES ('4094','18963','Computer','17','0','0','0','0','0','','');

### Dump table glpi_items_deviceharddrives

