--
-- Host: localhost    Database: sifopsas_bsup
-- ------------------------------------------------------


--
-- Table structure for table `tassets`
--

CREATE TABLE `tassets` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `sn_internal` varchar(20) NOT NULL,
  `sn_manufacturer` varchar(40) NOT NULL,
  `sn_indent` varchar(40) NOT NULL,
  `ip` varchar(20) NOT NULL,
  `ip2` varchar(20) NOT NULL,
  `netbios` varchar(30) NOT NULL,
  `description` varchar(500) NOT NULL,
  `type` int(5) NOT NULL,
  `manufacturer` int(5) NOT NULL,
  `model` int(5) NOT NULL,
  `user` int(5) NOT NULL,
  `state` int(5) NOT NULL,
  `mac_lan` varchar(20) NOT NULL,
  `mac_wlan` varchar(20) NOT NULL,
  `department` int(5) NOT NULL,
  `date_install` date NOT NULL,
  `date_stock` date NOT NULL,
  `date_standbye` date NOT NULL,
  `date_recycle` date NOT NULL,
  `socket` varchar(10) NOT NULL,
  `technician` int(5) NOT NULL,
  `maintenance` int(10) NOT NULL,
  `disable` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tassets`
--

INSERT INTO `tassets` VALUES (1,'1','','','172.16.2.201','','','',1,1,1,7,2,'','',1,'2016-10-20','2013-06-03','0000-00-00','0000-00-00','',7,0,1),(2,'2','','','','','Optiplex 2020','',1,1,1,7,2,'','',2,'2017-12-27','0000-00-00','0000-00-00','0000-00-00','',7,0,0),(3,'3','12sdf65sd','122132','','','test pc','Aucun comm',1,1,1,7,2,'','',1,'2017-12-27','2017-12-13','0000-00-00','0000-00-00','Aucune',7,0,0),(4,'4','Aucun','Aucune','','','Elite 7500','',1,2,3,7,2,'','',1,'2017-12-27','2012-04-05','0000-00-00','0000-00-00','',7,0,0);

--
-- Table structure for table `tassets_manufacturer`
--

CREATE TABLE `tassets_manufacturer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tassets_manufacturer`
--

INSERT INTO `tassets_manufacturer` VALUES (1,'Dell'),(2,'HP'),(3,'Apple'),(4,'Lenovo');

--
-- Table structure for table `tassets_model`
--

CREATE TABLE `tassets_model` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `type` int(5) NOT NULL,
  `manufacturer` int(5) NOT NULL,
  `image` varchar(30) NOT NULL,
  `name` varchar(50) NOT NULL,
  `ip` int(1) NOT NULL,
  `wifi` int(1) NOT NULL,
  `warranty` int(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tassets_model`
--

INSERT INTO `tassets_model` VALUES (3,1,2,'','Elite 7500',0,0,0);

--
-- Table structure for table `tassets_network`
--

CREATE TABLE `tassets_network` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `network` varchar(15) NOT NULL,
  `netmask` varchar(15) NOT NULL,
  `disable` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tassets_network`
--

INSERT INTO `tassets_network` VALUES (1,'Dun ADM','172.16.3.0','/24',0),(2,'Dun SFT','172.16.3.0','/24',0),(3,'DHCP','','',0);

--
-- Table structure for table `tassets_state`
--

CREATE TABLE `tassets_state` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `order` int(3) NOT NULL,
  `name` varchar(20) NOT NULL,
  `description` varchar(50) NOT NULL,
  `disable` int(1) NOT NULL,
  `display` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tassets_state`
--

INSERT INTO `tassets_state` VALUES (1,1,'Stock','Equipement en stock',0,'label label-sm label-info arrowed-in'),(2,2,'En production','Equipement installé en production',0,'label label-sm label-success arrowed arrowed-right arrowed-left'),(3,3,'Standbye','Equipement de coté',0,'label label-sm label-warning arrowed-in arrowed-right arrowed-in arrowed-left'),(5,5,'Equipement HS','Equipement hors service',0,''),(6,4,'En attente ...','En attente de réparation / reinstallation',0,''),(7,0,'Plus d\'utilité','Equipement obsolète ou non endommagé et non rempla',0,'');

--
-- Table structure for table `tassets_thread`
--

CREATE TABLE `tassets_thread` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `asset` int(10) NOT NULL,
  `text` varchar(5000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tassets_thread`
--


--
-- Table structure for table `tassets_type`
--

CREATE TABLE `tassets_type` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tassets_type`
--

INSERT INTO `tassets_type` VALUES (1,'PC'),(2,'Mac'),(3,'Téléphone fixe'),(4,'Imprimante'),(5,'Téléphone portable'),(6,'Box (accès internet)'),(7,'Ecran / Moniteur'),(8,'Vidéo projecteur');

--
-- Table structure for table `tavailability`
--

CREATE TABLE `tavailability` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `category` int(5) NOT NULL,
  `subcat` int(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tavailability`
--


--
-- Table structure for table `tavailability_dep`
--

CREATE TABLE `tavailability_dep` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `category` int(5) NOT NULL,
  `subcat` int(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tavailability_dep`
--


--
-- Table structure for table `tavailability_target`
--

CREATE TABLE `tavailability_target` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `subcat` int(5) NOT NULL,
  `target` float NOT NULL,
  `year` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tavailability_target`
--


--
-- Table structure for table `tcategory`
--

CREATE TABLE `tcategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tcategory`
--

INSERT INTO `tcategory` VALUES (1,'Logiciel'),(2,'Materiel'),(3,'Achat'),(4,'Internet'),(5,'Pour info'),(6,'Dropbox');

--
-- Table structure for table `tcompany`
--

CREATE TABLE `tcompany` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `address` varchar(50) NOT NULL,
  `zip` varchar(10) NOT NULL,
  `city` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tcompany`
--

INSERT INTO `tcompany` VALUES (1,'SFN Dunkerque','Avenue de la Gironde, ZI de Petite Synthe','59944','Dunkerque'),(2,'SFN Dieppe','Zone Industrielle Louis Delaporte, Zone marron (vo','76370','Rouxmesnil-Bouteilles'),(3,'SFN Bollène','Site du Sactar D243','84500','Bollène'),(4,'SFN Lagnieu','Rue de la gare','01150','Lagnieu'),(5,'SFN Blyes','Parc Industrielle de la Plaine de l\'Ain','01150','Blyes'),(6,'SOCO Construction','','',''),(7,'SOCO Institut','Avenue de la Gironde, ZI de Petite Synthe','59944','Dunkerque'),(8,'Orange','','',''),(9,'Canon','','',''),(10,'DSI grp SOCO','','','');

--
-- Table structure for table `tcriticality`
--

CREATE TABLE `tcriticality` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `number` int(2) NOT NULL,
  `name` varchar(50) NOT NULL,
  `color` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tcriticality`
--

INSERT INTO `tcriticality` VALUES (1,0,'Critique','#d15b47'),(2,1,'Grave','#f89406'),(3,2,'Moyenne','#f8c806'),(4,3,'Basse','#82af6f');

--
-- Table structure for table `tevents`
--

CREATE TABLE `tevents` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `technician` int(10) NOT NULL,
  `incident` int(10) NOT NULL,
  `date_start` datetime NOT NULL,
  `date_end` datetime NOT NULL,
  `type` int(1) NOT NULL,
  `disable` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tevents`
--

INSERT INTO `tevents` VALUES (2,7,2,'2016-10-21 08:00:00','2016-10-21 10:00:00',2,0),(3,7,38,'2016-11-17 08:00:00','0000-00-00 00:00:00',1,1);

--
-- Table structure for table `tgroups`
--

CREATE TABLE `tgroups` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `type` int(1) NOT NULL,
  `disable` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tgroups`
--


--
-- Table structure for table `tgroups_assoc`
--

CREATE TABLE `tgroups_assoc` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `group` int(5) NOT NULL,
  `user` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tgroups_assoc`
--


--
-- Table structure for table `tincidents`
--

CREATE TABLE `tincidents` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `type` int(1) NOT NULL DEFAULT '0',
  `technician` int(5) NOT NULL,
  `t_group` int(5) NOT NULL,
  `title` varchar(100) NOT NULL,
  `description` mediumtext NOT NULL,
  `user` varchar(20) NOT NULL,
  `u_group` int(5) NOT NULL,
  `u_service` int(5) NOT NULL,
  `date_create` datetime NOT NULL,
  `date_hope` date NOT NULL,
  `date_res` datetime NOT NULL,
  `date_modif` datetime NOT NULL,
  `state` int(1) NOT NULL,
  `priority` int(2) NOT NULL,
  `criticality` int(2) NOT NULL,
  `img1` varchar(500) NOT NULL,
  `img2` varchar(500) NOT NULL,
  `img3` varchar(500) NOT NULL,
  `img4` varchar(500) NOT NULL,
  `img5` varchar(500) NOT NULL,
  `time` int(10) NOT NULL,
  `time_hope` int(10) NOT NULL,
  `creator` int(3) NOT NULL,
  `category` int(3) NOT NULL,
  `subcat` int(3) NOT NULL,
  `techread` int(1) NOT NULL DEFAULT '1',
  `template` int(1) NOT NULL,
  `disable` int(1) NOT NULL,
  `notify` int(1) NOT NULL,
  `place` int(5) NOT NULL DEFAULT '99999',
  `start_availability` datetime NOT NULL,
  `end_availability` datetime NOT NULL,
  `availability_planned` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=153 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tincidents`
--

INSERT INTO `tincidents` VALUES (14,1,0,0,'Baisse de connexion','\r\n												\r\n												','2',0,0,'2016-10-20 16:45:01','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',3,6,4,'','','','','',0,5,2,4,0,0,0,1,1,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(15,1,0,0,'Test Ticket','Test\r\n												\r\n												','2',0,0,'2016-10-20 16:47:06','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',3,6,4,'','','','','',0,5,2,4,0,0,0,1,1,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(16,1,7,0,'Euh ??','<br>Euh ??<br><br>\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												','7',0,0,'2016-10-20 16:49:40','2016-10-26','2016-10-21 08:50:16','0000-00-00 00:00:00',3,6,4,'','','','','',10,300,2,2,14,1,0,1,1,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(17,3,7,0,'Essai mail','<br>Essai mail<br><br>\r\n												\r\n												\r\n												\r\n												\r\n												','7',0,0,'2016-10-21 08:25:06','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',1,5,7,5,0,1,0,1,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(18,1,7,0,'Essai mail','Essai mail\r\n												\r\n												\r\n												','7',0,0,'2016-10-21 08:28:14','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',1,5,7,5,0,1,0,1,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(19,3,7,0,'Essai mail','Essai mail\r\n												\r\n												\r\n												\r\n												\r\n												','7',0,0,'2016-10-21 08:29:29','2016-10-22','0000-00-00 00:00:00','0000-00-00 00:00:00',3,6,4,'','','','','',1,5,7,1,0,1,0,1,0,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(20,1,0,0,'Test mail','<br>sdfsdfdsf<br><br>\r\n												\r\n												\r\n												','2',0,0,'2016-10-21 08:58:36','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',0,5,2,1,7,0,0,1,1,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(21,1,0,0,'qsdqsd','<br>sqdqsdqsd<br><br>\r\n												\r\n												\r\n												','2',0,0,'2016-10-21 08:58:58','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',0,5,2,2,4,0,0,1,1,100002,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(22,1,0,0,'qsdqsd','qsdqsd\r\n												\r\n												\r\n												\r\n												','2',0,0,'2016-10-21 08:59:11','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',0,5,2,1,7,0,0,1,0,100001,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(23,1,0,0,'dsfsdf','<br>dsfdsf<br><br>\r\n												\r\n												','2',0,0,'2016-10-21 09:10:21','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',0,5,2,1,0,0,0,1,1,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(24,3,7,0,'zeezr','<br><br>zerzer\r\n												\r\n												\r\n												\r\n												','2',0,0,'2016-10-21 09:21:53','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',0,5,2,1,8,0,0,1,0,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(25,3,7,0,'sdfsd','<br>fdsfsdf<br>dsfsdf\r\n												\r\n												\r\n												\r\n												','2',0,0,'2016-10-21 09:24:24','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',3,6,2,'','','','','',1,5,2,4,0,1,0,1,0,100001,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(26,2,7,0,'fsdsfdsdf','\r\n												dsqdsds<br>\r\n												\r\n												\r\n												','8',0,0,'2016-10-21 14:10:58','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',1,5,8,2,0,0,0,1,0,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(27,3,8,0,'Echange ticket','\r\n												Echange ticket<br>\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												','7',0,0,'2016-10-21 14:12:26','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',2,6,4,'','','','','',1,5,8,1,8,0,0,1,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(28,1,7,0,'Installation d\'un éditeur de PDF','Besoin d\'installer un éditeur de PDF','0',0,0,'2016-10-25 08:36:51','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',1,5,7,1,12,1,0,1,0,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(29,2,7,0,'sdfsdf','sdfsdf\r\n												','8',0,0,'2016-10-25 08:56:59','0000-00-00','2016-10-25 08:57:49','0000-00-00 00:00:00',3,6,4,'','','','','',1,5,7,1,7,1,0,1,0,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(30,2,7,0,'fghfg','hfghfgh','2',0,0,'2016-10-25 08:59:17','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',3,6,4,'','','','','',1,5,7,4,0,1,0,1,0,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(31,1,7,0,'Chargeur téléphone exemple','J\'ai besoin d\'un chargeur de téléphone\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												','2',0,0,'2016-10-25 11:33:57','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',3,6,4,'','','','','',1,5,2,3,10,1,0,1,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(32,2,8,0,'Exemple d\'incident','Mon planning n\'est plus à jour<br>','7',0,0,'2016-10-26 08:24:35','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',1,5,8,1,8,1,0,1,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(33,1,8,0,'','\r\n												','0',0,0,'2016-10-26 08:54:58','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',1,5,8,0,0,1,0,1,0,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(34,2,7,0,'Pas de connexion internet sur navigateur','Suite à un soucis de tablette DELL Pro venue HS, c\'est fait prêter un vieux ordi. Le ping sur 8.8.8.8 fonctionne mais pas d\'accès internet via les navigateurs\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												','13',0,0,'2016-11-14 15:05:17','2016-11-14','2016-11-14 15:07:34','0000-00-00 00:00:00',3,4,3,'','','','','',60,60,7,1,16,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(35,1,7,0,'Demande de câblage de deux prises RJ45','Câblage de deux prises\r\n												\r\n												\r\n												','13',0,0,'2016-11-09 10:00:00','2016-11-09','2016-11-09 10:30:00','0000-00-00 00:00:00',3,6,4,'','','','','',30,30,7,2,17,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(36,2,7,0,'Lecteur PDF ne s\'ouvre pas','Acrobat reader ne s\'ouvre pas et l\'icone de chargement tourne en boucle.<div><br></div><div>Tablette DELL pro venue</div>','13',0,0,'2016-11-15 16:00:09','2016-11-15','2016-11-15 16:36:15','0000-00-00 00:00:00',3,6,4,'','','','','',5,5,7,1,16,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(37,1,7,0,'Renouvellement ordis Emmanuelle / Martine','Achat d\'un nouvel ordi.\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												','16',0,0,'2016-11-16 11:50:57','2016-12-12','2016-12-12 08:55:25','0000-00-00 00:00:00',3,3,2,'','','','','',300,300,7,3,10,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(38,2,7,0,'Présence de virus suspecté / OP impossible sur fichiers','&nbsp; Laurent Deldreve n\'arrive plus à faire des opérations simples sur des fichiers (copié, collé) ni même les ouvrir. Il a contacté la DSi qui lui propose de récupérer son ordi mais n\'a pas réussi à sauvegarder ses fichiers. Il à donc fait appel à mes services pour essayer de récupérer ses fichiers\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												','14',0,0,'2016-11-16 16:12:14','2016-11-16','2016-11-16 17:13:14','0000-00-00 00:00:00',3,3,2,'','','','','',60,60,7,1,16,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(39,2,7,0,'Bourrage papier bac 2 imprimante Dieppe','Le bac 2 de l\'imprimante de Dieppe est inutilisable (bourrage papier).\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												','18',0,0,'2016-11-17 18:21:27','2016-11-25','2016-11-25 09:59:11','0000-00-00 00:00:00',3,6,3,'FactureF1500730_hp_sofranext.pdf','HP_TPMFRCSS.61021_HPTPMFRCSS_SignOff.pdf','','','',30,30,18,2,14,1,0,0,0,100002,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(40,2,7,0,'Pas d\'internet sur un poste','(Bureau du fond) Pas d\'internet sur son poste et triangle que l’icône de connexion réseau.\r\n												','13',0,0,'2016-11-18 09:42:03','2016-11-18','2016-11-18 09:43:47','0000-00-00 00:00:00',3,4,3,'','','','','',10,10,7,4,0,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(41,1,7,0,'','\r\n												','0',0,0,'2016-11-18 16:42:39','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',1,5,7,0,0,1,0,1,0,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(42,2,7,0,'Message d\'erreur raporté par le SAV de canon','Message d\'erreur signalé sur le copieur du SFT par le SAV de Canon\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												','19',0,0,'2016-11-18 15:00:00','2016-11-21','2016-11-21 11:32:32','0000-00-00 00:00:00',3,1,2,'','','','','',10,10,7,2,14,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(43,2,7,0,'Micro coupure','Laurent Deldrève et son équipe rencontre depuis ce matin des micros coupure de leurs connexion internet\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												','14',0,0,'2016-11-21 10:47:19','2016-11-21','2016-11-22 08:49:48','0000-00-00 00:00:00',3,4,3,'','','','','',30,30,7,4,0,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(44,1,16,0,'Problème modification des indisponibilités','En connexion de type \"Manager\", lorsque qu\'une indisponibilité est crée dans Facett, il est impossible de la modifier,<br><br>Il faut la supprimer pour pouvoir la ressaisir.<br>\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												','20',0,0,'2016-11-22 09:13:38','2016-11-29','2017-01-05 11:02:32','0000-00-00 00:00:00',3,4,4,'','','','','',10,10,16,1,8,1,0,0,0,100006,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(45,3,16,0,'Message d\'erreur Facett','Un message d\'erreur de la page Web apparait et gêne les utilisateurs.<br><br>\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												','21',0,0,'2016-11-22 09:26:44','2016-11-29','2017-01-05 10:58:54','0000-00-00 00:00:00',3,4,4,'pastedImage.png','','','','',10,10,16,1,8,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(46,1,7,0,'','\r\n												\r\n												\r\n												','22',0,3,'2016-11-22 10:34:17','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',1,5,7,0,0,1,0,1,0,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(47,1,7,0,'Demande de vérification de renvoi d\'appel','Demande de vérification de renvoi d\'appel','22',0,0,'2016-11-22 10:38:11','2016-11-22','2016-11-22 10:49:07','0000-00-00 00:00:00',3,6,4,'','','','','',5,5,7,2,19,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(48,1,7,0,'sdfsdf','sdfsdf','23',0,2,'2016-11-22 11:01:47','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',0,5,23,1,7,0,0,1,0,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(49,1,7,0,'sdrfr','ertert\r\n												','23',0,2,'2016-11-22 11:07:46','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',2,6,4,'','','','','',1,5,23,2,0,1,0,1,0,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(50,2,7,0,'PC salle 22 fonctionne par intermitence','PC salle 22 fonctionne par intermitence<br>\r\n												\r\n												\r\n												\r\n												','20',0,0,'2016-11-23 11:22:59','2016-11-23','2016-11-23 11:25:35','0000-00-00 00:00:00',3,4,3,'','','','','',60,60,7,2,2,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(51,2,7,0,'Micro coupure internet','Xavier Cremers est venu me voir pour des coupures internet\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												','13',0,0,'2016-11-24 09:31:17','2016-11-24','2016-11-29 09:28:29','0000-00-00 00:00:00',3,4,3,'','','','','',30,30,7,4,0,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(52,3,16,0,'Affichage planning','&nbsp; Le lien que nous avons reçu de la part de Défi Informatique pour l\'affichage des salles, nous positionne automatiquement sur la page d\'authentification de FACETT, il nous faut impérativement une intervention \"humaine\" qui valide les identifiants qui sont mis par défaut. <br><br>&nbsp; L’institut qui à le même système, lui, n\'a pas besoin de validation.<br><br>Aprés deux relances je n\'ai toujours pas de nouvelles de la part de Mr Cazenave<br>\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												','7',0,0,'2016-11-24 10:14:18','0000-00-00','2017-10-06 09:09:29','0000-00-00 00:00:00',3,4,4,'','','','','',5,5,7,1,8,0,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(53,1,7,0,'','\r\n												','0',0,0,'2016-11-25 08:33:15','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',1,5,7,0,0,1,0,1,0,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(54,1,7,0,'Extinction serveurs Grp SOCO','Suite aux travaux ce Samedi dans le bâtiment B une coupure générale de courant sera réalisé, les équipement de SOCO doivent être arrêtes&nbsp;\r\n												\r\n												\r\n												','24',0,0,'2016-11-23 16:00:00','2016-11-26','2016-11-26 08:45:43','0000-00-00 00:00:00',3,1,2,'','','','','',240,240,7,2,0,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(55,2,7,0,'Deux tablettes s\'éteignent toutes seules','Deux des 13 tablettes s\'éteignent toutes seules\r\n												','18',0,0,'2016-11-25 14:39:38','0000-00-00','2016-12-22 11:18:34','0000-00-00 00:00:00',3,4,3,'','','','','',30,30,7,2,22,1,0,0,0,100002,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(56,3,7,0,'PC salle 22 demande mot de passe à la sortie de mise en veille','PC salle 22 demande mot de passe à la sortie de mise en veille\r\n												\r\n												\r\n												\r\n												\r\n												','25',0,0,'2016-11-25 15:20:35','2016-11-25','2016-11-25 15:19:34','0000-00-00 00:00:00',3,6,4,'','','','','',10,10,7,5,0,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(57,2,7,0,'Plus d\'internet pour SFN','Plus d\'internet pour SFN\r\n												\r\n												\r\n												','7',0,0,'2016-11-28 10:02:10','2016-11-28','2016-11-28 10:00:37','0000-00-00 00:00:00',3,1,1,'','','','','',30,30,7,4,0,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(58,1,7,0,'','\r\n												','0',0,0,'2016-11-28 15:54:30','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',1,5,7,0,0,1,0,1,0,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(59,3,7,0,'Éclaircissement sur les microcoupures','Orange essaie de connaître l\'origine des problèmes de coupures internet\r\n												\r\n												\r\n												','26',0,0,'2016-11-28 14:15:00','0000-00-00','2016-11-29 16:18:47','0000-00-00 00:00:00',3,4,3,'','','','','',60,60,7,4,0,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(60,3,7,0,'Code erreur imprimante','Canon viens de me contacter pour me signaler un code erreur sur l\'imprimante du bâtiment administratif (c5250), la personne que j\'ai eu m\'a demandé d\'effectuer un redémarrage.','19',0,0,'2016-11-29 08:53:50','2016-11-29','2016-11-29 08:53:37','0000-00-00 00:00:00',3,4,3,'','','','','',5,5,7,2,14,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(61,2,7,0,'Tablette PC Dell aucun réseau disponible','Plus aucun réseau n\'est visible dans la liste, hormis la connexion 3g/4g\r\n												\r\n												','27',0,0,'2016-11-29 14:11:09','2016-11-29','2016-11-29 14:21:54','0000-00-00 00:00:00',3,3,3,'','','','','',10,10,7,2,22,1,0,0,0,100001,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(62,3,7,0,'Plus de connexion en RJ45','La connexion avec un câble RJ45 ne fonctionne plus','22',0,0,'2016-11-30 11:02:23','2016-11-30','2016-11-30 11:01:19','0000-00-00 00:00:00',3,4,3,'','','','','',5,5,7,4,0,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(63,1,7,0,'Arrivée de Chloé','<ul><li>Téléphone portable avec ligne</li><li>Téléphone fixe avec ligne</li><li>Ordinateur portable</li><li>Ecran supplémentaire</li><li>Adresse mail</li></ul>\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												','21',0,3,'2016-12-01 17:08:34','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',3,1,4,'','','','','',10,10,7,3,0,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(64,2,7,0,'problème d\'impression','<ul><li>Après avoir redémarrer 2 fois, mon PC, je n\'arrive pas imprimer quelconque document.\r\n												</li></ul>','15',0,0,'2016-12-02 10:09:55','2016-12-02','2016-12-02 10:19:17','0000-00-00 00:00:00',3,4,4,'','','','','',5,5,15,2,14,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(65,1,7,0,'Adaptateur HDMI -> VGA','Demande d\'achat d\'un adaptateur HDMI -&gt; VGA pour les formations chez les clients\r\n												\r\n												\r\n												','22',0,0,'2016-12-06 09:03:30','0000-00-00','2016-12-06 14:52:47','0000-00-00 00:00:00',3,4,3,'','','','','',45,45,7,3,10,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(66,1,7,0,'Adaptateur DisplayPort -> VGA','Le nouvel ordinateur à besoin d\'un adaptateur DisplayPort vers VGA pour faire fonctionner plusieurs écrans simultanément.','28',0,0,'2016-12-05 00:00:00','2016-12-02','2016-12-02 09:12:41','0000-00-00 00:00:00',3,4,3,'','','','','',45,45,7,3,10,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(67,2,7,0,'Multiples problèmes','<ul><li>Wifi se coupe tout seul</li><li>La tablette refuse de démarrer si le chargeur n\'est pas connecté (batterie pourtant à plus de 65%)</li></ul>\r\n												','27',0,0,'2016-12-08 09:12:35','2016-12-08','2016-12-08 10:40:31','0000-00-00 00:00:00',3,1,1,'','','','','',60,60,7,2,22,1,0,0,0,100004,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(68,2,7,0,'','\r\n												\r\n												\r\n												','30',0,2,'2016-12-09 08:54:32','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',1,5,7,1,0,1,0,1,0,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0);
INSERT INTO `tincidents` VALUES (69,2,7,0,'Application \"Messages\" ne répond pas','L\'application \"Messages\" sur MacOs ne répond pas<img src=\"data:image/png;base64,[BLOB]