-- MySQL dump 10.15 Distrib 10.0.28-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: localhost -- ------------------------------------------------------ -- Server version 10.0.28-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `tassets` -- DROP TABLE IF EXISTS `tassets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tassets` -- LOCK TABLES `tassets` WRITE; /*!40000 ALTER TABLE `tassets` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `tassets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tassets_manufacturer` -- DROP TABLE IF EXISTS `tassets_manufacturer`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tassets_manufacturer` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tassets_manufacturer` -- LOCK TABLES `tassets_manufacturer` WRITE; /*!40000 ALTER TABLE `tassets_manufacturer` DISABLE KEYS */; INSERT INTO `tassets_manufacturer` VALUES (1,'Dell'),(2,'HP'),(3,'Apple'); /*!40000 ALTER TABLE `tassets_manufacturer` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tassets_model` -- DROP TABLE IF EXISTS `tassets_model`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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=3 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tassets_model` -- LOCK TABLES `tassets_model` WRITE; /*!40000 ALTER TABLE `tassets_model` DISABLE KEYS */; INSERT INTO `tassets_model` VALUES (1,1,1,'3020.jpg','Optiplex 3020',1,0,3),(2,2,1,'overview_wireless_hero_enhance','MacBookPro',1,1,3); /*!40000 ALTER TABLE `tassets_model` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tassets_network` -- DROP TABLE IF EXISTS `tassets_network`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tassets_network` -- LOCK TABLES `tassets_network` WRITE; /*!40000 ALTER TABLE `tassets_network` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `tassets_network` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tassets_state` -- DROP TABLE IF EXISTS `tassets_state`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tassets_state` -- LOCK TABLES `tassets_state` WRITE; /*!40000 ALTER TABLE `tassets_state` DISABLE KEYS */; 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,''); /*!40000 ALTER TABLE `tassets_state` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tassets_thread` -- DROP TABLE IF EXISTS `tassets_thread`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tassets_thread` -- LOCK TABLES `tassets_thread` WRITE; /*!40000 ALTER TABLE `tassets_thread` DISABLE KEYS */; /*!40000 ALTER TABLE `tassets_thread` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tassets_type` -- DROP TABLE IF EXISTS `tassets_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tassets_type` -- LOCK TABLES `tassets_type` WRITE; /*!40000 ALTER TABLE `tassets_type` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `tassets_type` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tavailability` -- DROP TABLE IF EXISTS `tavailability`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tavailability` -- LOCK TABLES `tavailability` WRITE; /*!40000 ALTER TABLE `tavailability` DISABLE KEYS */; /*!40000 ALTER TABLE `tavailability` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tavailability_dep` -- DROP TABLE IF EXISTS `tavailability_dep`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tavailability_dep` -- LOCK TABLES `tavailability_dep` WRITE; /*!40000 ALTER TABLE `tavailability_dep` DISABLE KEYS */; /*!40000 ALTER TABLE `tavailability_dep` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tavailability_target` -- DROP TABLE IF EXISTS `tavailability_target`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tavailability_target` -- LOCK TABLES `tavailability_target` WRITE; /*!40000 ALTER TABLE `tavailability_target` DISABLE KEYS */; /*!40000 ALTER TABLE `tavailability_target` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tcategory` -- DROP TABLE IF EXISTS `tcategory`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tcategory` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tcategory` -- LOCK TABLES `tcategory` WRITE; /*!40000 ALTER TABLE `tcategory` DISABLE KEYS */; INSERT INTO `tcategory` VALUES (1,'Logiciel'),(2,'Materiel'),(3,'Achat'),(4,'Internet'),(5,'Pour info'); /*!40000 ALTER TABLE `tcategory` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tcompany` -- DROP TABLE IF EXISTS `tcompany`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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=6 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tcompany` -- LOCK TABLES `tcompany` WRITE; /*!40000 ALTER TABLE `tcompany` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `tcompany` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tcriticality` -- DROP TABLE IF EXISTS `tcriticality`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tcriticality` -- LOCK TABLES `tcriticality` WRITE; /*!40000 ALTER TABLE `tcriticality` DISABLE KEYS */; INSERT INTO `tcriticality` VALUES (1,0,'Critique','#d15b47'),(2,1,'Grave','#f89406'),(3,2,'Moyenne','#f8c806'),(4,3,'Basse','#82af6f'); /*!40000 ALTER TABLE `tcriticality` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tevents` -- DROP TABLE IF EXISTS `tevents`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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=3 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tevents` -- LOCK TABLES `tevents` WRITE; /*!40000 ALTER TABLE `tevents` DISABLE KEYS */; INSERT INTO `tevents` VALUES (2,7,2,'2016-10-21 08:00:00','2016-10-21 10:00:00',2,0); /*!40000 ALTER TABLE `tevents` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tgroups` -- DROP TABLE IF EXISTS `tgroups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tgroups` -- LOCK TABLES `tgroups` WRITE; /*!40000 ALTER TABLE `tgroups` DISABLE KEYS */; /*!40000 ALTER TABLE `tgroups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tgroups_assoc` -- DROP TABLE IF EXISTS `tgroups_assoc`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tgroups_assoc` -- LOCK TABLES `tgroups_assoc` WRITE; /*!40000 ALTER TABLE `tgroups_assoc` DISABLE KEYS */; /*!40000 ALTER TABLE `tgroups_assoc` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tincidents` -- DROP TABLE IF EXISTS `tincidents`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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=34 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tincidents` -- LOCK TABLES `tincidents` WRITE; /*!40000 ALTER TABLE `tincidents` DISABLE KEYS */; 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 ??','
Euh ??

\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','
Essai mail

\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','
sdfsdfdsf

\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','
sqdqsdqsd

\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','
dsfdsf

\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','

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','
fdsfsdf
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
\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
\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 ','2',0,0,'2016-10-25 11:33:57','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',1,5,2,3,10,1,0,0,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
','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,0,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,0,0,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0); /*!40000 ALTER TABLE `tincidents` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tmails` -- DROP TABLE IF EXISTS `tmails`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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=12 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tmails` -- LOCK TABLES `tmails` WRITE; /*!40000 ALTER TABLE `tmails` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `tmails` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tparameters` -- DROP TABLE IF EXISTS `tparameters`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tparameters` ( `id` int(1) NOT NULL AUTO_INCREMENT, `company` varchar(50) DEFAULT NULL, `server_url` varchar(200) DEFAULT NULL, `version` varchar(8) NOT NULL, `update_channel` varchar(10) NOT NULL, `maxline` int(4) NOT NULL, `mail` int(1) NOT NULL, `mail_smtp` varchar(100) DEFAULT NULL, `mail_smtp_class` varchar(15) NOT NULL DEFAULT 'isSMTP()', `mail_port` int(4) NOT NULL, `mail_auth` varchar(10) DEFAULT NULL, `mail_secure` varchar(10) DEFAULT NULL, `mail_username` varchar(150) DEFAULT NULL, `mail_password` varchar(150) DEFAULT NULL, `mail_txt` varchar(300) NOT NULL, `mail_cc` varchar(50) NOT NULL, `mail_from_name` varchar(60) NOT NULL, `mail_from_adr` varchar(50) NOT NULL, `mail_auto` int(1) NOT NULL, `mail_auto_user_modify` int(1) NOT NULL DEFAULT '0', `mail_auto_tech_modify` int(1) NOT NULL DEFAULT '0', `mail_newticket` int(1) NOT NULL, `mail_newticket_address` varchar(200) NOT NULL, `mail_color_title` varchar(6) NOT NULL, `mail_color_bg` varchar(6) NOT NULL, `mail_color_text` varchar(6) NOT NULL, `mail_link` int(1) NOT NULL, `logo` varchar(50) NOT NULL, `user_advanced` int(1) NOT NULL, `user_register` int(1) NOT NULL, `user_limit_ticket` int(1) NOT NULL DEFAULT '0', `lign_yellow` varchar(50) NOT NULL, `lign_orange` varchar(50) NOT NULL, `time_display_msg` int(5) NOT NULL, `auto_refresh` int(5) NOT NULL, `notify` int(1) NOT NULL, `ldap` int(1) NOT NULL, `ldap_auth` int(1) NOT NULL, `ldap_type` int(1) NOT NULL, `ldap_server` varchar(100) NOT NULL, `ldap_port` int(5) NOT NULL, `ldap_domain` varchar(200) NOT NULL, `ldap_url` varchar(200) NOT NULL, `ldap_user` varchar(100) NOT NULL, `ldap_password` varchar(100) NOT NULL, `planning` int(1) NOT NULL, `debug` int(1) NOT NULL, `imap` int(1) NOT NULL, `imap_server` varchar(50) NOT NULL, `imap_port` varchar(50) NOT NULL, `imap_user` varchar(50) NOT NULL, `imap_password` varchar(50) NOT NULL, `imap_inbox` varchar(20) NOT NULL, `order` varchar(100) NOT NULL, `procedure` int(1) NOT NULL, `ticket_places` int(1) NOT NULL, `ticket_type` int(1) NOT NULL, `availability` int(1) NOT NULL, `availability_all_cat` int(1) NOT NULL, `availability_dep` int(1) NOT NULL, `availability_condition_type` varchar(20) NOT NULL, `availability_condition_value` int(4) NOT NULL, `asset` int(1) NOT NULL, `meta_state` int(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tparameters` -- LOCK TABLES `tparameters` WRITE; /*!40000 ALTER TABLE `tparameters` DISABLE KEYS */; INSERT INTO `tparameters` VALUES (1,'Socotec Formation Nucléaire','http://sfn-intranet.fr/gestup','3.1.9','stable',14,1,'smtp.office365.com','IsSMTP()',587,'1','0','eddy.mequignon@socotec.com','Hruqgcwk2','Bonjour,
Vous avez fait la demande suivante auprès du support:','support@exemple.fr','Support exemple','',1,1,1,1,'eddy.mequignon@socotec.com','438eb9','f5f5f5','438eb9',1,'',1,1,0,'30','45',500,0,1,0,0,0,'',0,'','','','',1,0,0,'','','','','','tstates.number, tincidents.priority, tincidents.criticality, tincidents.date_create',1,1,1,0,0,0,'criticality',0,1,0); /*!40000 ALTER TABLE `tparameters` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tplaces` -- DROP TABLE IF EXISTS `tplaces`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tplaces` -- LOCK TABLES `tplaces` WRITE; /*!40000 ALTER TABLE `tplaces` DISABLE KEYS */; INSERT INTO `tplaces` VALUES (100000,'Dunkerque'),(100001,'Bollène'),(100002,'Dieppe'),(100003,'Blyes'),(100004,'Lagnieu'),(100005,'Variable'),(100006,'L\'ensemble des sites'); /*!40000 ALTER TABLE `tplaces` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tpriority` -- DROP TABLE IF EXISTS `tpriority`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tpriority` -- LOCK TABLES `tpriority` WRITE; /*!40000 ALTER TABLE `tpriority` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `tpriority` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tprocedures` -- DROP TABLE IF EXISTS `tprocedures`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tprocedures` -- LOCK TABLES `tprocedures` WRITE; /*!40000 ALTER TABLE `tprocedures` DISABLE KEYS */; INSERT INTO `tprocedures` VALUES (1,2,2,'Procédure 1 test (exemple de disfonctionnement)','Procédure test n°1 avec insertion d\'image

','',0); /*!40000 ALTER TABLE `tprocedures` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tprofiles` -- DROP TABLE IF EXISTS `tprofiles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tprofiles` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `level` int(10) NOT NULL, `img` varchar(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tprofiles` -- LOCK TABLES `tprofiles` WRITE; /*!40000 ALTER TABLE `tprofiles` DISABLE KEYS */; INSERT INTO `tprofiles` VALUES (1,'technicien',0,'technician.png'),(2,'utilisateur avec pouvoir',1,'poweruser.png'),(3,'utilisateur',2,'user.png'),(4,'superviseur',3,'supervisor.png'),(5,'administrateur',4,'admin.png'); /*!40000 ALTER TABLE `tprofiles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `trights` -- DROP TABLE IF EXISTS `trights`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `trights` ( `id` int(5) NOT NULL AUTO_INCREMENT, `profile` int(5) NOT NULL, `search` int(1) NOT NULL COMMENT 'Affiche le champ de recherche', `task_checkbox` int(1) NOT NULL COMMENT 'Autorise les actions sur en selectionnant plusieurs tickets dans les tâches', `procedure` int(1) NOT NULL COMMENT 'Affiche le menu procédure', `stat` int(1) NOT NULL COMMENT 'Affiche le menu Statistiques', `planning` int(1) NOT NULL COMMENT 'Affiche le menu Planning', `availability` int(1) NOT NULL COMMENT 'Affiche le menu Disponibilité', `asset` int(1) NOT NULL COMMENT 'Affiche le menu matériel', `asset_list_department_only` int(1) NOT NULL COMMENT 'Affiche uniquement les matériels du serivce auquel est rattaché l''utilisateur.', `asset_list_view_only` int(1) NOT NULL COMMENT 'Affiche uniquement la liste des matériels, sans droit d''éditer une fiche.', `admin` int(1) NOT NULL COMMENT 'Affiche le menu Administration', `admin_user_profile` int(1) NOT NULL COMMENT 'Droit de modification de profile des utilisateurs', `admin_user_view` int(1) NOT NULL COMMENT 'Droit de modification des vues des utilisateurs', `dashboard_col_priority` int(1) NOT NULL COMMENT 'Affiche la colonne priorité dans la liste des tickets.', `dashboard_col_date_create` int(1) NOT NULL COMMENT 'Affiche la colonne date de création dans la liste des tickets.', `dashboard_col_date_hope` int(1) NOT NULL COMMENT 'Affiche la colonne date de résolution estimé dans la liste des tickets.', `dashboard_col_date_res` int(1) NOT NULL COMMENT 'Affiche la colonne date de résolution dans la liste des tickets.', `userbar` int(1) NOT NULL COMMENT 'Affiche les propriétés étendue de la barre utilisateur', `side` int(1) NOT NULL COMMENT 'Affiche la colonne de gauche', `side_open_ticket` int(1) NOT NULL COMMENT 'Affiche le bouton Ouvrir un nouveau ticket', `side_asset_create` int(1) NOT NULL COMMENT 'Affiche le bouton ajouter matériel', `side_asset_all_state` int(11) NOT NULL COMMENT 'Affiche tous les états des matériels dans le menu de gauche', `side_your` int(1) NOT NULL COMMENT 'Affiche la section vos demandes', `side_your_not_read` int(1) NOT NULL COMMENT 'Affiche vos demande non lu', `side_your_not_attribute` int(1) NOT NULL COMMENT 'Affiche vos demande non attribué', `side_your_meta` int(1) NOT NULL COMMENT 'Affiche le meta etat à traiter personnel', `side_all` int(1) NOT NULL COMMENT 'Affiche la section toutes les demandes', `side_all_wait` int(1) NOT NULL COMMENT 'Affiche la vue Nouvelles demandes dans toutes les demandes', `side_all_meta` int(1) NOT NULL COMMENT 'Affiche le meta etat à traiter pour tous les techniciens', `side_view` int(1) NOT NULL COMMENT 'Affiche les vues personelles', `ticket_next` int(1) NOT NULL COMMENT 'Affiche les flèches ticket suivant et prècedent', `ticket_print` int(1) NOT NULL COMMENT 'Impression des tickets', `ticket_template` int(1) NOT NULL COMMENT 'Affiche le bouton modèle de ticket', `ticket_calendar` int(1) NOT NULL COMMENT 'Planifier un ticket', `ticket_event` int(1) NOT NULL COMMENT 'Créer un rappel de ticket', `ticket_save` int(1) NOT NULL COMMENT 'Sauvegarde de ticket', `ticket_type` int(1) NOT NULL COMMENT 'Modification du type dans le ticket', `ticket_type_disp` int(1) NOT NULL COMMENT 'Affiche le champ type dans le ticket', `ticket_user` int(1) NOT NULL COMMENT 'Modfication du demandeur', `ticket_user_disp` int(1) NOT NULL COMMENT 'Affiche le champ utilisateur dans le ticket', `ticket_user_actions` int(1) NOT NULL COMMENT 'Affiche les boutons actions pour le demandeur', `ticket_tech` int(1) NOT NULL COMMENT 'Modification du technicien', `ticket_tech_disp` int(1) NOT NULL COMMENT 'Affiche le champ technicien dans le ticket', `ticket_cat` int(1) NOT NULL COMMENT 'Modification des catégories', `ticket_cat_disp` int(1) NOT NULL COMMENT 'Affiche le champ catégorie dans le ticket', `ticket_cat_actions` int(1) NOT NULL COMMENT 'Affiche les boutons actions pour les catégories', `ticket_title` int(1) NOT NULL COMMENT 'Modification du titre dans le ticket', `ticket_title_disp` int(1) NOT NULL COMMENT 'Affiche le champ titre dans le ticket', `ticket_description` int(1) NOT NULL COMMENT 'Modification de la description', `ticket_description_disp` int(1) NOT NULL COMMENT 'Affiche le champ description dans le ticket', `ticket_resolution_disp` int(1) NOT NULL COMMENT 'Affiche le champ resolution dans le ticket', `ticket_attachment` int(1) NOT NULL COMMENT 'Ajouter des pièces jointes', `ticket_date_create` int(1) NOT NULL COMMENT 'Modification de la date de création', `ticket_date_create_disp` int(1) NOT NULL COMMENT 'Affiche le champ date de création dans le ticket', `ticket_date_hope` int(1) NOT NULL COMMENT 'Modification de la date de résolution estimée', `ticket_date_hope_disp` int(1) NOT NULL COMMENT 'Affiche le champ date de de résolution estimé dans le ticket', `ticket_date_hope_mandatory` int(1) NOT NULL COMMENT 'Oblige la saisie du champ date de résolution estimé', `ticket_date_res` int(1) NOT NULL COMMENT 'Modification de la date de résolution dans le ticket', `ticket_date_res_disp` int(1) NOT NULL COMMENT 'Affiche le champ date de résolution dans le ticket', `ticket_time` int(1) NOT NULL COMMENT 'Modification du temps passé par ticket', `ticket_time_disp` int(1) NOT NULL COMMENT 'Affiche le champ temps passé dans le ticket', `ticket_time_hope` int(1) NOT NULL COMMENT 'Modification du temps estimé passé par ticket', `ticket_time_hope_disp` int(1) NOT NULL COMMENT 'Affiche le champ temps estimé dans le ticket', `ticket_priority` int(1) NOT NULL COMMENT 'Modification de la priorité dans le ticket', `ticket_priority_disp` int(1) NOT NULL COMMENT 'Affiche le champ priorité dans le ticket', `ticket_priority_mandatory` int(1) NOT NULL COMMENT 'Oblige la saisie du champ priorité', `ticket_criticality` int(1) NOT NULL COMMENT 'Modification de la criticité dans le ticket', `ticket_criticality_disp` int(1) NOT NULL COMMENT 'Affiche le champ criticité dans le ticket', `ticket_criticality_mandatory` int(1) NOT NULL COMMENT 'Oblige la saisie du champ criticité', `ticket_state` int(1) NOT NULL COMMENT 'Modification du champ etat dans le ticket', `ticket_state_disp` int(1) NOT NULL COMMENT 'Affiche le champ état dans le ticket', `ticket_availability` int(1) NOT NULL COMMENT 'Modifiction de la partie disponibilité', `ticket_availability_disp` int(1) NOT NULL COMMENT 'Affiche la partie disponibilité', `ticket_delete` int(1) NOT NULL COMMENT 'Droit de suppression de tickets', `ticket_close` int(1) NOT NULL COMMENT 'Affiche le bouton de cloture dans le ticket', `ticket_thread_add` int(1) NOT NULL COMMENT 'Ajouter des réponses', `ticket_thread_delete` int(1) NOT NULL COMMENT 'Suppression d''une résolution', `ticket_thread_edit` int(1) NOT NULL COMMENT 'Modification de ses résolutions', `ticket_thread_edit_all` int(1) NOT NULL COMMENT 'Modification de toutes les résolutions', `ticket_thread_post` int(1) NOT NULL COMMENT 'Droit de répondre dans les tickets', `ticket_save_close` int(1) NOT NULL COMMENT 'Affiche le bouton enregistrer et fermer dans le ticket', `ticket_send_mail` int(1) NOT NULL COMMENT 'Affiche le bouton envoyer un mail dans le ticket', `ticket_cancel` int(1) NOT NULL COMMENT 'Affiche le bouton annuler dans le ticket', `ticket_new_type` int(1) NOT NULL COMMENT 'Modification du type pour les nouveaux tickets', `ticket_new_type_disp` int(1) NOT NULL COMMENT 'Affiche le champ type pour les nouveaux tickets', `ticket_new_user` int(1) NOT NULL COMMENT 'Modification du demandeur pour les nouveaux tickets', `ticket_new_user_disp` int(1) NOT NULL COMMENT 'Affiche le champ demandeur pour les nouveaux tickets', `ticket_new_tech_disp` int(1) NOT NULL COMMENT 'Affiche le champ technicien pour les nouveaux tickets', `ticket_new_cat` int(1) NOT NULL COMMENT 'Modification de la catégorie pour les nouveaux tickets', `ticket_new_cat_disp` int(1) NOT NULL COMMENT 'Affiche le champ catégorie pour les nouveaux tickets', `ticket_new_resolution_disp` int(1) NOT NULL COMMENT 'Affiche le champ résolution pour les nouveaux tickets', `ticket_new_send` int(1) NOT NULL COMMENT 'Affiche le bouton envoyer pour les nouveaux tickets', `ticket_new_save` int(1) NOT NULL COMMENT 'Affiche le bouton sauvegarder sur les nouveaux tickets', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `trights` -- LOCK TABLES `trights` WRITE; /*!40000 ALTER TABLE `trights` DISABLE KEYS */; INSERT INTO `trights` VALUES (1,0,2,2,2,2,2,2,0,0,0,0,2,2,2,2,2,2,2,2,2,0,0,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,0,2,2,2,2,2,2,2,2,0,2,2,0,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2),(2,1,0,0,0,2,0,0,0,2,2,0,0,0,2,2,2,2,0,2,2,0,0,2,0,2,0,0,2,0,0,2,2,0,0,0,2,0,0,0,2,0,2,2,0,2,0,0,2,0,2,2,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,2,0,2,0,2,0,0,2,0,2,2,2,2,2,2,0,2,0),(3,2,0,0,0,2,0,0,0,2,2,0,0,0,2,2,0,2,0,2,2,0,0,2,0,2,0,0,2,2,0,2,2,0,0,0,2,0,0,0,2,0,2,2,0,2,0,0,2,0,2,2,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,2,0,0,0,0,0,0,2,2,0,2,0,2,0,0,2,0,2,2,2,2,2,2,0,2,0),(4,3,2,2,0,2,2,2,0,0,0,0,0,0,2,2,0,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,0,2,2,2,2,2,2,2,2,0,2,2,0,2,2,2,2,2,0,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2),(5,4,2,2,2,2,2,2,0,0,0,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,0,2,2,2,2,2,2,2,2,0,2,2,0,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2); /*!40000 ALTER TABLE `trights` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tservices` -- DROP TABLE IF EXISTS `tservices`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tservices` ( `id` int(5) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `disable` int(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tservices` -- LOCK TABLES `tservices` WRITE; /*!40000 ALTER TABLE `tservices` DISABLE KEYS */; INSERT INTO `tservices` VALUES (1,'Informatique',0),(2,'Administratif',0),(3,'Formation',0),(4,'Prestataire',0),(5,'Direction',0); /*!40000 ALTER TABLE `tservices` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tstates` -- DROP TABLE IF EXISTS `tstates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tstates` ( `id` int(11) NOT NULL AUTO_INCREMENT, `number` int(2) NOT NULL, `name` varchar(50) NOT NULL, `description` varchar(200) NOT NULL, `mail_object` varchar(200) NOT NULL, `display` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tstates` -- LOCK TABLES `tstates` WRITE; /*!40000 ALTER TABLE `tstates` DISABLE KEYS */; INSERT INTO `tstates` VALUES (1,2,'Attente PEC','tickets en attente de prise en charge','Notification d\'ouverture','label label-sm label-info arrowed-in'),(2,3,'En cours ','tickets en cours de traitement','Notification','label label-sm label-warning arrowed-in'),(3,5,'Résolu','tickets résolus','Notification de clôture','label label-sm label-success arrowed arrowed-right arrowed-left'),(4,6,'Rejeté','tickets rejetés','Notification de rejet','label label-sm label-inverse arrowed arrowed-right arrowed-left'),(5,1,'Non attribué','tickets pas encore associés à un technicien','Notification de déclaration','label label-sm label-important arrowed-in arrowed-right rrowed-left'),(6,4,'Attente Retour','tickets en attente d\'éléments de la part du demandeur','Notification d\'attente de retour ','label label-sm label-pink arrowed arrowed-right arrowed-left'),(7,7,'Commandé, en attente de livraison','Commandé en attente de livraison','Article commandé, en attente de livraison',''); /*!40000 ALTER TABLE `tstates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tsubcat` -- DROP TABLE IF EXISTS `tsubcat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tsubcat` ( `id` int(10) NOT NULL AUTO_INCREMENT, `cat` int(10) NOT NULL, `name` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tsubcat` -- LOCK TABLES `tsubcat` WRITE; /*!40000 ALTER TABLE `tsubcat` DISABLE KEYS */; INSERT INTO `tsubcat` VALUES (1,1,'Office'),(2,2,'PC'),(4,2,'Mac'),(5,2,'Vidéo projecteur'),(6,2,'Ecran/Moniteur'),(7,1,'GABS'),(8,1,'FACETT (Emmanuelle)'),(9,1,'Gescof (Emmanuelle)'),(10,3,'Matériel'),(11,3,'Logiciel'),(12,1,'Installation logiciel'),(13,2,'WiFi'),(14,2,'Imprimante'),(15,1,'Messagerie Outlook'),(16,1,'Autres logiciels'); /*!40000 ALTER TABLE `tsubcat` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ttemplates` -- DROP TABLE IF EXISTS `ttemplates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ttemplates` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `incident` int(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ttemplates` -- LOCK TABLES `ttemplates` WRITE; /*!40000 ALTER TABLE `ttemplates` DISABLE KEYS */; /*!40000 ALTER TABLE `ttemplates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tthreads` -- DROP TABLE IF EXISTS `tthreads`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tthreads` ( `id` int(10) NOT NULL AUTO_INCREMENT, `ticket` int(10) NOT NULL, `date` datetime NOT NULL, `author` int(10) NOT NULL, `text` mediumtext NOT NULL, `type` int(1) NOT NULL, `tech1` int(5) NOT NULL, `tech2` int(5) NOT NULL, `group1` int(5) NOT NULL, `group2` int(5) NOT NULL, `user` int(5) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tthreads` -- LOCK TABLES `tthreads` WRITE; /*!40000 ALTER TABLE `tthreads` DISABLE KEYS */; INSERT INTO `tthreads` VALUES (1,1,'2016-10-20 13:01:52',6,'',4,0,0,0,0,0),(2,2,'2016-10-20 15:14:58',7,'',1,7,0,0,0,0),(3,3,'2016-10-20 15:15:34',7,'',1,7,0,0,0,0),(4,3,'2016-10-20 15:16:09',7,'Test ticket ',0,0,0,0,0,0),(5,2,'2016-10-20 15:20:45',7,'
Ajout

',0,0,0,0,0,0),(6,4,'2016-10-20 15:28:37',1,'',1,7,0,0,0,0),(7,5,'2016-10-20 15:33:39',7,'',1,7,0,0,0,0),(8,8,'2016-10-20 16:23:20',7,'',1,7,0,0,0,0),(9,9,'2016-10-20 16:26:21',7,'',1,7,0,0,0,0),(10,10,'2016-10-20 16:32:18',7,'',1,7,0,0,0,0),(11,13,'2016-10-20 16:32:57',7,'',1,7,0,0,0,0),(12,12,'2016-10-20 16:33:09',7,'',1,7,0,0,0,0),(13,11,'2016-10-20 16:33:17',7,'',1,7,0,0,0,0),(14,14,'2016-10-20 16:46:10',2,'',4,0,0,0,0,0),(15,14,'2016-10-20 16:46:12',2,'',4,0,0,0,0,0),(16,15,'2016-10-20 16:49:06',7,'',4,0,0,0,0,0),(17,16,'2016-10-20 16:51:20',7,'',1,7,0,0,0,0),(18,17,'2016-10-21 08:25:38',7,'',1,7,0,0,0,0),(19,17,'2016-10-21 08:25:38',7,'Essai mail',0,0,0,0,0,0),(20,17,'2016-10-21 08:26:56',7,'',3,0,0,0,0,0),(21,17,'2016-10-21 08:27:45',7,'',3,0,0,0,0,0),(22,18,'2016-10-21 08:28:32',7,'',1,7,0,0,0,0),(23,18,'2016-10-21 08:28:32',7,'
Essai mail

',0,0,0,0,0,0),(24,19,'2016-10-21 08:29:44',7,'',1,7,0,0,0,0),(25,19,'2016-10-21 08:29:44',7,'
Essai mail

',0,0,0,0,0,0),(26,19,'2016-10-21 08:31:15',7,'',4,0,0,0,0,0),(27,19,'2016-10-21 08:31:49',7,'hhhh',0,0,0,0,0,0),(28,16,'2016-10-21 08:48:41',7,'- pas réussi',0,0,0,0,0,0),(29,16,'2016-10-21 08:50:16',7,'',4,0,0,0,0,0),(30,24,'2016-10-21 09:22:07',2,'',1,7,0,0,0,0),(31,25,'2016-10-21 09:24:38',2,'',1,7,0,0,0,0),(32,25,'2016-10-21 09:25:44',7,'
Réponse

',0,0,0,0,0,0),(33,25,'2016-10-21 09:26:35',2,'Réponse créateur',0,0,0,0,0,0),(34,25,'2016-10-21 09:41:58',7,'',4,0,0,0,0,0),(35,26,'2016-10-21 14:11:16',8,'',1,7,0,0,0,0),(36,26,'2016-10-21 14:11:16',8,'
',0,0,0,0,0,0),(37,27,'2016-10-21 14:12:51',8,'',1,7,0,0,0,0),(38,27,'2016-10-21 14:12:51',8,'
',0,0,0,0,0,0),(39,27,'2016-10-21 14:13:54',7,'',2,7,8,0,0,0),(40,27,'2016-10-21 14:13:54',7,'C\'est pour toi',0,0,0,0,0,0),(41,28,'2016-10-21 14:22:30',7,'',1,7,0,0,0,0),(42,28,'2016-10-21 14:22:54',7,'',1,7,0,0,0,0),(43,28,'2016-10-25 08:49:17',7,'',1,7,0,0,0,0),(44,29,'2016-10-25 08:57:12',7,'',1,7,0,0,0,0),(45,29,'2016-10-25 08:57:12',7,'sdfsdf',0,0,0,0,0,0),(46,29,'2016-10-25 08:57:49',7,'',4,0,0,0,0,0),(47,30,'2016-10-25 08:59:36',7,'',1,7,0,0,0,0),(48,30,'2016-10-25 08:59:36',7,'fghfgh',0,0,0,0,0,0),(49,31,'2016-10-25 11:34:31',2,'',1,7,0,0,0,0),(50,32,'2016-10-26 08:32:47',8,'',1,8,0,0,0,0),(51,33,'2016-10-26 09:15:15',8,'',1,8,0,0,0,0); /*!40000 ALTER TABLE `tthreads` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ttime` -- DROP TABLE IF EXISTS `ttime`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ttime` ( `id` int(2) NOT NULL AUTO_INCREMENT, `min` int(100) NOT NULL, `name` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ttime` -- LOCK TABLES `ttime` WRITE; /*!40000 ALTER TABLE `ttime` DISABLE KEYS */; INSERT INTO `ttime` VALUES (1,1,'1m'),(2,5,'5m'),(3,10,'10m'),(4,30,'30m'),(5,60,'1h'),(6,180,'3h'),(7,300,'5h'),(8,480,'1j'),(9,960,'2j'),(10,2400,'1s'); /*!40000 ALTER TABLE `ttime` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ttoken` -- DROP TABLE IF EXISTS `ttoken`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ttoken` ( `id` int(5) NOT NULL AUTO_INCREMENT, `token` varchar(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=465 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ttoken` -- LOCK TABLES `ttoken` WRITE; /*!40000 ALTER TABLE `ttoken` DISABLE KEYS */; INSERT INTO `ttoken` VALUES (1,'5808c76e01f69'),(2,'5808c7ab0c945'),(3,'5808c7ab139f4'),(4,'5808c7b3d347d'),(5,'5808c7c775a5a'),(6,'5808c7c94b613'),(7,'5808c7ca634c2'),(8,'5808c82f5c8e4'),(9,'5808c8313c74e'),(10,'5808c85d47871'),(11,'5808c86136af5'),(12,'5808c87a5b226'),(13,'5808c87c3b27e'),(14,'5808c8a67e1fb'),(15,'5808c8aaac866'),(16,'5808c8abf413b'),(17,'5808c8d0b015d'),(18,'5808c97b6dd43'),(19,'5808c9f1eea43'),(20,'5808c9f3bf2eb'),(21,'5808ca1398c5f'),(22,'5808ca1a333b9'),(23,'5808ca1d1044a'),(24,'5808ca1edbd85'),(25,'5808ca2277158'),(26,'5808ca350d14c'),(27,'5808ca374f54d'),(28,'5808ca43429de'),(29,'5808ca467cf51'),(30,'5808ca77b2f14'),(31,'5808ca7f0d76e'),(32,'5808ca8198482'),(33,'5808ca83d8f3a'),(34,'5808ca85695e2'),(35,'5808ca870012e'),(36,'5808cac76c940'),(37,'5808cac977eb3'),(38,'5808cad449a14'),(39,'5808cad5f303e'),(40,'5808cadad1787'),(41,'5808caf297af1'),(42,'5808caf51dfae'),(43,'5808caf65bd46'),(44,'5808caf802c57'),(45,'5808cb164f054'),(46,'5808cb1c00361'),(47,'5808cb208b22f'),(48,'5808cb4c4f1ee'),(49,'5808cb4e7f7c9'),(50,'5808cb514eeec'),(51,'5808cb9b57d47'),(52,'5808cb9ce97a9'),(53,'5808cb9eab131'),(54,'5808cbaf19d80'),(55,'5808ce1558f5c'),(56,'5808cf64ba01e'),(57,'5808cf64c087d'),(58,'5808d2ab18052'),(59,'5808d2ad34e3d'),(60,'5808d2b04236e'),(61,'5808d2b178e7c'),(62,'5808d2b6232a6'),(63,'5808d2c415ef2'),(64,'5808d2ce81256'),(65,'5808d2ee4a180'),(66,'5808d2f254e5a'),(67,'5808d311904b9'),(68,'5808d344106ca'),(69,'5808d34d23542'),(70,'5808d3516f7e6'),(71,'5808d352efdf2'),(72,'5808d356d59f7'),(73,'5808d358b3d5c'),(74,'5808d359613b1'),(75,'5808d35f2d99e'),(76,'5808d3632d27a'),(77,'5808d376b31f3'),(78,'5808d3cd1126b'),(79,'5808d3cf4a997'),(80,'5808d3d14c409'),(81,'5808d3e373a1e'),(82,'5808d3fa5d863'),(83,'5808d405f2619'),(84,'5808d40dd3c0d'),(85,'5808d40e94401'),(86,'5808d432554af'),(87,'5808d432f2c50'),(88,'5808d43dccad4'),(89,'5808d43e74a05'),(90,'5808d4485144e'),(91,'5808d4ce91d11'),(92,'5808d4d03b312'),(93,'5808d4d13b914'),(94,'5808d4d325361'),(95,'5808d4d4df9c0'),(96,'5808d4d635815'),(97,'5808d4d752306'),(98,'5808d4da88ba0'),(99,'5808d4dcf0a8e'),(100,'5808d4de414df'),(101,'5808d4df54ddd'),(102,'5808d4e335015'),(103,'5808d534e7f4f'),(104,'5808d536c5286'),(105,'5808d53a6aa46'),(106,'5808d56ea805b'),(107,'5808d56ead50f'),(108,'5808d5714e6d1'),(109,'5808d572d5f55'),(110,'5808d5737922a'),(111,'5808d58c72cda'),(112,'5808d58c76006'),(113,'5808d58ec4d36'),(114,'5808d59964af7'),(115,'5808d59a0833d'),(116,'5808d5a01b5a0'),(117,'5808d5a338aee'),(118,'5808d5a48d7c8'),(119,'5808d5a5dd24d'),(120,'5808d5a6820d2'),(121,'5808d5aa35022'),(122,'5808d5ac4e68d'),(123,'5808d5ad8d584'),(124,'5808d5ae3cc25'),(125,'5808d67490c3b'),(126,'5808d677b1da8'),(127,'5808d6f51ed3d'),(128,'5808d6f524c2b'),(129,'5808d76b60e37'),(130,'5808d76db9cdd'),(131,'5808d77cccb54'),(132,'5808d7802f0a3'),(133,'5808d7c8efda5'),(134,'5808d7ca4000d'),(135,'5808d7f67f987'),(136,'5808d86aa9e0f'),(137,'5808d86d46200'),(138,'5808d8718ab8b'),(139,'5808d87a55c89'),(140,'5808d883be4d3'),(141,'5808d88594907'),(142,'5808d888a48ba'),(143,'5808d88d68c0c'),(144,'5808d89da2ce3'),(145,'5808d8b02b7bc'),(146,'5808d8b23f078'),(147,'5808d8b427d04'),(148,'5808d8be8f647'),(149,'5808d8d2a8669'),(150,'5808d8d2b0287'),(151,'5808d8eae8497'),(152,'5808d8ef8f24d'),(153,'5808d8f9eb474'),(154,'5808d8fd2c009'),(155,'5808d904a0d02'),(156,'5808d90683298'),(157,'5808d9073b6ff'),(158,'5808d94ab57ed'),(159,'5808d94ea899e'),(160,'5808d9512d270'),(161,'5808d95351a57'),(162,'5808d954e66c5'),(163,'5808d962ec187'),(164,'5808d97e3bab7'),(165,'5808d984cf3b4'),(166,'5808d98727d33'),(167,'5808d98999bb0'),(168,'5808d9915137d'),(169,'5808d99e4b451'),(170,'5808d9c27c586'),(171,'5808d9d41fa56'),(172,'5808d9ddb683d'),(173,'5808d9e2d9dea'),(174,'5808d9e501259'),(175,'5808d9e834bd7'),(176,'5808d9e8d67e1'),(177,'5808d9f0a57af'),(178,'5808da23df218'),(179,'5808da261873a'),(180,'5808da27c6ff2'),(181,'5809b2b4db67d'),(182,'5809b4c20d332'),(183,'5809b4c218b39'),(184,'5809b4c455d87'),(185,'5809b4ca8d11e'),(186,'5809b4e2cea32'),(187,'5809b5212791f'),(188,'5809b5264fa86'),(189,'5809b55c43d64'),(190,'5809b55f663ce'),(191,'5809b57e29d63'),(192,'5809b57e31585'),(193,'5809b5807e663'),(194,'5809b5877d26f'),(195,'5809b59013277'),(196,'5809b590afc78'),(197,'5809b5c91e0e4'),(198,'5809b5c9243d1'),(199,'5809b5cb241e1'),(200,'5809b5d16f624'),(201,'5809b60872eb7'),(202,'5809b613eaff7'),(203,'5809b62bd846f'),(204,'5809b62bde584'),(205,'5809b6339d0ec'),(206,'5809b64c00ae9'),(207,'5809b64c06572'),(208,'5809b681e70fc'),(209,'5809b689c8d08'),(210,'5809b6a143cac'),(211,'5809b6a3225db'),(212,'5809ba1211bde'),(213,'5809ba12b1729'),(214,'5809ba12b6c36'),(215,'5809ba2e6e247'),(216,'5809ba5393a6b'),(217,'5809ba543df76'),(218,'5809ba86c6d63'),(219,'5809baa2f399b'),(220,'5809baa39a915'),(221,'5809baac346aa'),(222,'5809baacd41d9'),(223,'5809baacdaa8e'),(224,'5809bc9cbafcf'),(225,'5809bc9f2322f'),(226,'5809bca0d56f2'),(227,'5809bca9b6704'),(228,'5809bcb28a807'),(229,'5809bcb428dab'),(230,'5809bcb54651c'),(231,'5809bcb9e6730'),(232,'5809bcbfc8307'),(233,'5809bcc14e4b5'),(234,'5809bcc36ceb5'),(235,'5809bcc4567cc'),(236,'5809bcc8e176b'),(237,'5809bf5d5eba2'),(238,'5809bf636921c'),(239,'5809bf662fbba'),(240,'5809bff0b0ce7'),(241,'5809c00074066'),(242,'5809c006312ad'),(243,'5809c00917d62'),(244,'5809c04d4c811'),(245,'5809c05e8d020'),(246,'5809c0614b1de'),(247,'5809c0632ad1c'),(248,'5809c07beef9c'),(249,'5809c0b25144d'),(250,'5809c0c6c0373'),(251,'5809c0fb4a419'),(252,'5809c13583da0'),(253,'5809c18583fcf'),(254,'5809c2118fc97'),(255,'5809c21755c05'),(256,'5809c219918c8'),(257,'5809c21b19a38'),(258,'5809c21f328f4'),(259,'5809c2a8bdb95'),(260,'5809c2af099dd'),(261,'5809c2b012bdc'),(262,'5809c2b952301'),(263,'5809c2ef5bde2'),(264,'5809c2ef611d0'),(265,'5809c31a4d127'),(266,'5809c32e7b282'),(267,'5809c32f2d930'),(268,'5809c6bccad10'),(269,'5809c6bcd21eb'),(270,'5809c6c6b767d'),(271,'5809c6fb7e560'),(272,'5809c6fb83c52'),(273,'5809c7ad8b9a0'),(274,'5809dfb2987db'),(275,'5809dfb2ae57d'),(276,'5809dfba2212b'),(277,'5809dfbcb5aa8'),(278,'5809dfc6b568c'),(279,'5809dfc6be39a'),(280,'5809dfcab56ac'),(281,'5809dfcabd063'),(282,'5809dfcb73e12'),(283,'5809dfcb7a53a'),(284,'5809dfcbd43d7'),(285,'5809dfcbdb0ce'),(286,'5809dfcc404b1'),(287,'5809dfcc46581'),(288,'5809e005c1244'),(289,'5809e005c68a2'),(290,'5809e008bba40'),(291,'5809e0115c364'),(292,'580a03fa8916d'),(293,'580a03ff27a01'),(294,'580a04d1446d0'),(295,'580a04e017e3f'),(296,'580a04e01d282'),(297,'580a04fea696d'),(298,'580a04fea9cad'),(299,'580a053e3a051'),(300,'580a05828a4ae'),(301,'580a05a71df0d'),(302,'580a05d293d76'),(303,'580a05d299586'),(304,'580a05d6c6d8e'),(305,'580a05dac2ec4'),(306,'580a05dd0167a'),(307,'580a062ab1f8e'),(308,'580a062eebfd5'),(309,'580a06350f4f3'),(310,'580a06754b1b4'),(311,'580a067ab7992'),(312,'580a06852edf5'),(313,'580a0685e1760'),(314,'580a06adf1752'),(315,'580a06ae0258b'),(316,'580a078b4e6a7'),(317,'580a07d522632'),(318,'580a07df27d01'),(319,'580a07e0aee79'),(320,'580a081d3880c'),(321,'580a081eb0f74'),(322,'580a081f4c9a3'),(323,'580a082065174'),(324,'580a082214979'),(325,'580a087571eff'),(326,'580a087e645a6'),(327,'580a088f6bd46'),(328,'580a0890279ba'),(329,'580a089bb20fb'),(330,'580a089e5a493'),(331,'580a089f0ef4b'),(332,'580a08a4d5d1a'),(333,'580a08a7d8b28'),(334,'580a08b1762a2'),(335,'580a08b439bc6'),(336,'580a08c3d71db'),(337,'580a08c646564'),(338,'580a08ca19bc2'),(339,'580a08cc1748a'),(340,'580a08cd3058c'),(341,'580a08d082b2f'),(342,'580a08d2f213e'),(343,'580a08f568fd8'),(344,'580a08f8da4bf'),(345,'580a08fa8f1cb'),(346,'580a08fb432f4'),(347,'580a090644dcd'),(348,'580a0908a859c'),(349,'580a090a75409'),(350,'580a0910f3351'),(351,'580a0911af556'),(352,'580a0ef42cdeb'),(353,'580a0f0748c84'),(354,'580a0f09d0353'),(355,'580a0f0ef1408'),(356,'580efd1fd7385'),(357,'580efd25f36ea'),(358,'580efd2e61dd9'),(359,'580efd351da15'),(360,'580efd380e43f'),(361,'580efd3a69738'),(362,'580efd45c66f9'),(363,'580efd831441e'),(364,'580efd8a2d6a0'),(365,'580efdaea2125'),(366,'580f006db9000'),(367,'580f006e788d4'),(368,'580f0073749cd'),(369,'580f0073af080'),(370,'580f023bb09f0'),(371,'580f023e3a10d'),(372,'580f0241e014e'),(373,'580f0243213b9'),(374,'580f02681033d'),(375,'580f0271a86f0'),(376,'580f0272602f2'),(377,'580f029e0c0ad'),(378,'580f02c504d98'),(379,'580f02c827268'),(380,'580f02cbf0b1d'),(381,'580f02d00b474'),(382,'580f02d137a03'),(383,'580f02d2bc220'),(384,'580f02f323c09'),(385,'580f03043fde9'),(386,'580f0305316d7'),(387,'580f2705001de'),(388,'580f2705114f4'),(389,'580f270b267f3'),(390,'580f270dc00d5'),(391,'580f270fcde7d'),(392,'580f272a92de6'),(393,'580f2e1bd7a2a'),(394,'580f2e1be6cfa'),(395,'580f2eceb4ea7'),(396,'580f2ecebc1d2'),(397,'580f2edd313d7'),(398,'580f2ee340760'),(399,'580f2ee3470bc'),(400,'580f2ee8ee2b4'),(401,'580f2eeb3673c'),(402,'580f2ef9d309e'),(403,'580f46ca7e334'),(404,'580f46d4e1817'),(405,'580f48b896643'),(406,'580f48cb544f7'),(407,'580f4d3f08891'),(408,'580f4e031e2fb'),(409,'580f4e03267be'),(410,'580f5aee68006'),(411,'580f609d07eb0'),(412,'580f6d4cd16b5'),(413,'580f6d4f3bdf1'),(414,'580f6e262ff0b'),(415,'58104c23ee3c9'),(416,'58104c240333a'),(417,'58104c27f1f9e'),(418,'58104c61a608e'),(419,'58104cdcb38d1'),(420,'58104ce36aa31'),(421,'58104ceb700a7'),(422,'58104cee08b0d'),(423,'58104e1773d5f'),(424,'58104e18732b1'),(425,'58105342bd0ab'),(426,'58105342c4106'),(427,'5810580d6cfdc'),(428,'5810580e273a3'),(429,'58105812dcc9a'),(430,'58107b3dbe079'),(431,'58107b631d5cd'),(432,'58107f9fb26df'),(433,'5810a70164fa6'),(434,'5810adfa1298f'),(435,'5810c4de8e98a'),(436,'5810c4dfdd0b5'),(437,'58120fd457fce'),(438,'58121111aad1b'),(439,'58121111bbdfa'),(440,'5812113ae125b'),(441,'5812113f32582'),(442,'58121141519ab'),(443,'5812117ebb03c'),(444,'581211886a885'),(445,'581211887643f'),(446,'581211aabc907'),(447,'581211bcebfd8'),(448,'581211f1cd924'),(449,'581211f1d3de7'),(450,'5812125fa6ee5'),(451,'5812126786e68'),(452,'581216ac86324'),(453,'581216ac8d363'),(454,'581a0494de368'),(455,'581a06e266a76'),(456,'58219d4063050'),(457,'5822e5657a7c9'),(458,'5822e76a26f93'),(459,'5822e77eed23a'),(460,'5822e795b4c29'),(461,'5823269959de4'),(462,'5823269968b29'),(463,'582326a420435'),(464,'582326a54c67a'); /*!40000 ALTER TABLE `ttoken` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ttypes` -- DROP TABLE IF EXISTS `ttypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ttypes` ( `id` int(5) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ttypes` -- LOCK TABLES `ttypes` WRITE; /*!40000 ALTER TABLE `ttypes` DISABLE KEYS */; INSERT INTO `ttypes` VALUES (1,'Demande'),(2,'Incident'),(3,'Remarque'); /*!40000 ALTER TABLE `ttypes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tusers` -- DROP TABLE IF EXISTS `tusers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tusers` ( `id` int(4) NOT NULL AUTO_INCREMENT, `login` varchar(20) NOT NULL, `password` varchar(50) NOT NULL, `salt` varchar(50) NOT NULL, `firstname` varchar(40) NOT NULL, `lastname` varchar(40) NOT NULL, `profile` int(10) NOT NULL, `mail` varchar(100) NOT NULL, `phone` varchar(30) NOT NULL, `fax` varchar(20) NOT NULL, `function` varchar(50) NOT NULL, `service` int(5) NOT NULL, `company` int(5) NOT NULL, `address1` varchar(100) NOT NULL, `address2` varchar(100) NOT NULL, `zip` varchar(20) NOT NULL, `city` varchar(100) NOT NULL, `custom1` varchar(100) NOT NULL, `custom2` varchar(100) NOT NULL, `disable` int(1) NOT NULL, `chgpwd` int(1) NOT NULL, `last_login` datetime NOT NULL, `skin` varchar(10) NOT NULL, `default_ticket_state` varchar(5) NOT NULL, `dashboard_ticket_order` varchar(200) NOT NULL, `limit_ticket_number` int(5) NOT NULL, `limit_ticket_days` int(5) NOT NULL, `limit_ticket_date_start` date NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tusers` -- LOCK TABLES `tusers` WRITE; /*!40000 ALTER TABLE `tusers` DISABLE KEYS */; INSERT INTO `tusers` VALUES (2,'user','e3e35189b0491cf803d9de4f552072db','978f0','user','',2,'eddy.mequignon@socotec.com','','','',0,0,'','','','','','',0,0,'2016-11-09 10:08:04','skin-1','','',0,0,'0000-00-00'),(7,'mequigne','77c07cdd774bf957dba300d942d99f9e','13769','Eddy','Méquignon',4,'eddy.mequignon@socotec.com','0651731519','','Admin réseau',0,1,'Avenue de la Gironde ','','59944','Dunkerque','','',0,0,'2016-11-09 13:58:06','skin-1','','',0,0,'0000-00-00'),(8,'tailleze','021dede8ea0bcca26346d8c5ff64970f','c65d2','Emmanuelle','Taillez',0,'amm@socotec.com','','','',0,1,'','','','','','',0,0,'2016-10-26 08:23:12','','','',0,0,'0000-00-00'),(9,'superv','d42bc6bb2759cdad59d91f493880a9c9','59752','superv','',3,'','','','\'',0,0,'','','','','','',0,0,'2016-10-25 08:56:43','','','',0,0,'0000-00-00'),(11,'Guylene','71862eab1268aa325692742d1ed51e5e','4d1bb','Guylene','Vernet',3,'bob@bob.fr','','','',0,4,'','','','','','',0,0,'2016-11-09 09:58:34','','','',0,0,'0000-00-00'),(12,'bob','30e75fe456076ad7975a9143e609a25a','eedb8','bob','bob',1,'bob@bob.frt','','','',0,0,'','','','','','',0,0,'2016-10-27 16:40:46','','','',0,0,'0000-00-00'); /*!40000 ALTER TABLE `tusers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tusers_tech` -- DROP TABLE IF EXISTS `tusers_tech`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tusers_tech` ( `id` int(5) NOT NULL AUTO_INCREMENT, `user` int(10) NOT NULL, `tech` int(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tusers_tech` -- LOCK TABLES `tusers_tech` WRITE; /*!40000 ALTER TABLE `tusers_tech` DISABLE KEYS */; /*!40000 ALTER TABLE `tusers_tech` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tviews` -- DROP TABLE IF EXISTS `tviews`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tviews` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(10) NOT NULL, `name` varchar(100) NOT NULL, `category` int(5) NOT NULL, `subcat` int(5) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tviews` -- LOCK TABLES `tviews` WRITE; /*!40000 ALTER TABLE `tviews` DISABLE KEYS */; /*!40000 ALTER TABLE `tviews` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2016-11-09 16:26:29