[BLOB]\">\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												','33',0,0,'2017-01-31 08:31:07','0000-00-00','2017-02-20 08:57:52','0000-00-00 00:00:00',3,3,2,'','','','','',10,10,7,1,16,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0);
INSERT INTO `tincidents` VALUES (104,2,7,0,'L\'imprimante du SFT n\'imprime plus','\"Vérifier l\'imprimante, Contacter le SAV\"\r\n												','20',0,0,'2017-02-02 15:50:59','2017-02-03','2017-02-03 09:50:52','0000-00-00 00:00:00',3,3,2,'','','','','',10,10,7,2,14,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(105,2,16,0,'problème de transfert des dossiers dans facett','depuis 15 jours je n\'arrive plus a envoyer les fdp et dossiers de sessions dans facett, la boite de dialogue qui doit permettre de sélectionner le fichier ne fonctionne plus. Je passe par safari et j\'ai l\'impression que la dernière mise à jour (qui a résolu un bug avec dropbox) a créé ce soucis.<div>En passant par firefox celà semble marcher mieux.</div>','37',0,0,'2017-02-15 08:16:38','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',3,6,4,'bug-facett-1402.tiff','','','','',0,5,37,1,8,0,0,0,0,100001,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(106,2,7,0,'Plus d\'internet / téléphone','Plus d\'internet / téléphone\r\n												\r\n												\r\n												','14',0,0,'2017-02-20 08:50:55','2017-02-20','2017-02-20 08:47:01','0000-00-00 00:00:00',3,1,1,'','','','','',30,30,7,5,0,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(107,2,7,0,'La connexion à l\'ordinateur distant ne fonctionne plus','La connexion à l\'ordinateur distant ne fonctionne plus\r\n												\r\n												\r\n												\r\n												\r\n												','14',0,0,'2017-02-20 08:52:19','2017-02-20','2017-02-20 08:48:44','0000-00-00 00:00:00',3,4,3,'','','','','',10,10,7,1,25,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(108,1,7,0,'Câblage de la salle 5','Câblage de la salle 5\r\n												\r\n												\r\n												\r\n												','14',0,0,'2017-03-09 13:45:00','2017-03-09','2017-03-09 09:59:50','0000-00-00 00:00:00',3,6,4,'','','','','',10,10,7,2,17,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(109,1,7,0,'Mis en place d\'un nouveau PC','La tablette étant HS pour la troisième fois, on à reesayer de mettre un ancien PC mais ce dernier est également HS','13',0,0,'2017-03-14 15:40:05','2017-03-14','2017-03-14 15:35:58','0000-00-00 00:00:00',3,3,2,'','','','','',10,10,7,2,2,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(110,1,7,0,'Achat d\'un sac à dos pour Tanguy','Achat d\'un sac à dos pour Tanguy\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												','20',0,0,'2017-03-20 09:23:00','2017-03-24','2017-03-24 11:35:51','0000-00-00 00:00:00',3,5,4,'','','','','',30,30,7,3,10,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(111,1,7,0,'Nouvelle carte SIM pour le 06.10.54.63.15 ','Nouvelle carte SIM pour le 06.10.54.63.15 \r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												','7',0,0,'2017-03-20 09:43:49','2017-03-20','2017-03-23 14:46:03','0000-00-00 00:00:00',3,4,3,'','','','','',30,30,7,2,20,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(112,2,7,0,'Ordi s\'allume mais n\'affiche plus rien','Ordi s\'allume mais n\'affiche plus rien','14',0,0,'2017-03-28 14:30:00','2017-03-28','2017-03-28 14:45:02','0000-00-00 00:00:00',3,1,1,'','','','','',30,30,7,2,2,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(113,2,7,0,'Poste ne s\'allume plus','\"Yann a chan gé le tél mais l’ordi de Séverine ne s’allume\r\nplus<p class=\"MsoNormal\"><o:p></o:p></p>\r\n\r\n<p class=\"MsoNormal\">Tu peux passer stp\"<o:p></o:p></p>\r\n												\r\n												\r\n												\r\n												','14',0,0,'2017-03-30 09:15:11','0000-00-00','2017-03-30 09:28:44','0000-00-00 00:00:00',3,6,4,'','','','','',10,10,7,2,19,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(114,2,7,0,'Pas de réseau suite au passage de la TOIP Orange','Le technicien Orange à pris le câble du collègue pour brancher sur le téléphone','13',0,0,'2017-03-30 10:04:33','0000-00-00','2017-03-30 10:06:28','0000-00-00 00:00:00',3,2,2,'','','','','',30,30,7,2,22,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(115,1,7,0,'Ajout d\'une imprimante','Ajouter une imprimante dans les bungalows, car il se font amené le copieur que demain','14',0,0,'2017-04-06 10:00:00','2017-04-06','2017-04-06 10:36:45','0000-00-00 00:00:00',3,3,2,'','','','','',45,45,7,2,14,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(116,2,7,0,'problème d\'impression','Bonjour Eddy,<div><br></div><div>Je n\'arrive pas à imprimer sur les 2 imprimantes depuis hier. Je suis en wifi salle 12.</div><div>j\'ai essayé ta technique en redémarrant le PC mais tjrs pas.... J\'ai une fenêtre sur un problème de configuration d\'imprimante.</div><div>Peux-tu m\'aider ?</div>\r\n												','15',0,0,'2017-05-16 16:36:58','2017-05-16','2017-05-16 16:45:00','0000-00-00 00:00:00',3,6,3,'','','','','',5,5,15,2,14,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(117,2,7,0,'Changement d\'ordi','Multiples soucis de lenteur, de plantage&nbsp;\r\n												','20',0,3,'2017-10-06 09:18:03','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',2,1,3,'','','','','',5,5,7,2,2,1,0,0,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0);

--
-- Table structure for table `tmails`
--

CREATE TABLE `tmails` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `incident` int(10) NOT NULL,
  `open` int(1) NOT NULL,
  `close` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tmails`
--

INSERT INTO `tmails` VALUES (1,19,1,1),(2,16,1,1),(3,25,1,0),(4,26,1,0),(5,27,1,0),(6,28,1,0),(7,29,1,1),(8,30,1,0),(9,32,1,0),(10,33,1,0),(11,31,1,0),(12,34,1,1),(13,35,1,1),(14,36,1,0),(15,37,1,1),(16,38,1,1),(17,40,1,1),(18,39,1,1),(19,42,1,1),(20,43,1,1),(21,44,1,1),(22,45,1,0),(23,47,1,0),(24,49,1,0),(25,50,1,0),(26,51,1,1),(27,52,1,1),(28,54,1,1),(29,55,1,1),(30,56,1,1),(31,57,1,0),(32,59,1,1),(33,60,1,0),(34,61,1,1),(35,62,1,0),(36,63,1,0),(37,64,1,0),(38,65,1,1),(39,66,1,0),(40,67,1,1),(41,69,1,1),(42,70,1,1),(43,71,1,1),(44,72,1,0),(45,73,1,1),(46,74,1,0),(47,75,1,0),(48,76,1,0),(49,77,1,0),(50,78,1,0),(51,79,1,0),(52,80,1,0),(53,81,1,0),(54,82,1,1),(55,83,1,0),(56,84,1,0),(57,85,1,1),(58,86,1,0),(59,87,1,0),(60,88,1,0),(61,89,1,0),(62,90,1,1),(63,91,1,1),(64,92,1,0),(65,93,1,0),(66,94,1,1),(67,95,1,1),(68,96,1,0),(69,97,1,0),(70,98,1,1),(71,99,1,1),(72,100,1,0),(73,101,1,0),(74,102,1,1),(75,103,1,1),(76,104,1,1),(77,105,1,0),(78,106,1,0),(79,107,1,0),(80,108,1,0),(81,109,1,0),(82,110,1,1),(83,111,1,1),(84,112,1,0),(85,113,1,1),(86,114,1,0),(87,115,1,0),(88,116,1,0),(89,117,1,0);

--
-- Table structure for table `tplaces`
--

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

--
-- Dumping data for table `tplaces`
--

INSERT INTO `tplaces` VALUES (100000,'Dunkerque'),(100001,'Bollène'),(100002,'Dieppe'),(100003,'Blyes'),(100004,'Lagnieu'),(100005,'Variable'),(100006,'L\'ensemble des sites');

--
-- Table structure for table `tpriority`
--

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

--
-- Dumping data for table `tpriority`
--

INSERT INTO `tpriority` VALUES (1,0,'Urgent','#d15b47'),(2,1,'Très haute','#f89406'),(3,2,'Haute','#f8c806'),(4,3,'Moyenne','#e7ef20'),(5,4,'Basse','#c2c921'),(6,5,'Très basse','#82af6f');

--
-- Table structure for table `tprocedures`
--

CREATE TABLE `tprocedures` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `category` int(5) NOT NULL,
  `subcat` int(5) NOT NULL,
  `name` varchar(100) NOT NULL,
  `text` mediumtext NOT NULL,
  `file1` varchar(30) NOT NULL,
  `disable` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tprocedures`
--

INSERT INTO `tprocedures` VALUES (1,2,2,'Procédure 1 test (exemple de disfonctionnement)','Procédure test n°1 avec insertion d\'image<div><img src=\"data:image/png;base64,[BLOB]