[encoded data, 146391 characters]\"><br></div>','',0);

--
-- Table structure for table `tprofiles`
--

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;

--
-- Dumping data for table `tprofiles`
--

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');

--
-- Table structure for table `trights`
--

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;

--
-- Dumping data for table `trights`
--

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);

--
-- Table structure for table `tservices`
--

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;

--
-- Dumping data for table `tservices`
--

INSERT INTO `tservices` VALUES (1,'Informatique',0),(2,'Administratif',0),(3,'Formation',0),(4,'Prestataire',0),(5,'Direction',0);

--
-- Table structure for table `tstates`
--

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;

--
-- Dumping data for table `tstates`
--

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','');

--
-- Table structure for table `tsubcat`
--

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;

--
-- Dumping data for table `tsubcat`
--

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');

--
-- Table structure for table `ttemplates`
--

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;

--
-- Dumping data for table `ttemplates`
--


--
-- Table structure for table `tthreads`
--

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;

--
-- Dumping data for table `tthreads`
--

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&nbsp;<img src=\"data:image/jpeg;base64,[encoded data, 73820 characters]\">',0,0,0,0,0,0),(5,2,'2016-10-20 15:20:45',7,'<br>Ajout<br><br>',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,'<br>Essai mail<br><br>',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,'<br>Essai mail<br><br>',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,'<br>Réponse<br><br>',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,'<br>',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,'<br>',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);

--
-- Table structure for table `ttime`
--

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;

--
-- Dumping data for table `ttime`
--

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');

--
-- Table structure for table `ttoken`
--

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;

--
-- Dumping data for table `ttoken`
--

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');

--
-- Table structure for table `ttypes`
--

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;

--
-- Dumping data for table `ttypes`
--

INSERT INTO `ttypes` VALUES (1,'Demande'),(2,'Incident'),(3,'Remarque');

--
-- Table structure for table `tusers`
--

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;

--
-- Dumping data for table `tusers`
--

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');

--
-- Table structure for table `tusers_tech`
--

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;

--
-- Dumping data for table `tusers_tech`
--


--
-- Table structure for table `tviews`
--

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;

--
-- Dumping data for table `tviews`
--



