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


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

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

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

INSERT INTO `tassets` VALUES (1,'1','','','172.16.2.201','','','',1,1,1,7,2,'','',1,'2016-10-20','2013-06-03','0000-00-00','0000-00-00','',7,0,0);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `tevents` VALUES (2,7,2,'2016-10-21 08:00:00','2016-10-21 10:00:00',2,0);

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

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

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


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

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

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


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

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

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

INSERT INTO `tincidents` VALUES (14,1,0,0,'Baisse de connexion','\r\n												\r\n												','2',0,0,'2016-10-20 16:45:01','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',3,6,4,'','','','','',0,5,2,4,0,0,0,1,1,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(15,1,0,0,'Test Ticket','Test\r\n												\r\n												','2',0,0,'2016-10-20 16:47:06','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',3,6,4,'','','','','',0,5,2,4,0,0,0,1,1,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(16,1,7,0,'Euh ??','<br>Euh ??<br><br>\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												\r\n												','7',0,0,'2016-10-20 16:49:40','2016-10-26','2016-10-21 08:50:16','0000-00-00 00:00:00',3,6,4,'','','','','',10,300,2,2,14,1,0,1,1,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(17,3,7,0,'Essai mail','<br>Essai mail<br><br>\r\n												\r\n												\r\n												\r\n												\r\n												','7',0,0,'2016-10-21 08:25:06','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',1,5,7,5,0,1,0,1,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(18,1,7,0,'Essai mail','Essai mail\r\n												\r\n												\r\n												','7',0,0,'2016-10-21 08:28:14','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',1,5,7,5,0,1,0,1,0,100000,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(19,3,7,0,'Essai mail','Essai mail\r\n												\r\n												\r\n												\r\n												\r\n												','7',0,0,'2016-10-21 08:29:29','2016-10-22','0000-00-00 00:00:00','0000-00-00 00:00:00',3,6,4,'','','','','',1,5,7,1,0,1,0,1,0,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(20,1,0,0,'Test mail','<br>sdfsdfdsf<br><br>\r\n												\r\n												\r\n												','2',0,0,'2016-10-21 08:58:36','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',0,5,2,1,7,0,0,1,1,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(21,1,0,0,'qsdqsd','<br>sqdqsdqsd<br><br>\r\n												\r\n												\r\n												','2',0,0,'2016-10-21 08:58:58','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',0,5,2,2,4,0,0,1,1,100002,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(22,1,0,0,'qsdqsd','qsdqsd\r\n												\r\n												\r\n												\r\n												','2',0,0,'2016-10-21 08:59:11','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',0,5,2,1,7,0,0,1,0,100001,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(23,1,0,0,'dsfsdf','<br>dsfdsf<br><br>\r\n												\r\n												','2',0,0,'2016-10-21 09:10:21','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',0,5,2,1,0,0,0,1,1,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(24,3,7,0,'zeezr','<br><br>zerzer\r\n												\r\n												\r\n												\r\n												','2',0,0,'2016-10-21 09:21:53','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',1,6,4,'','','','','',0,5,2,1,8,0,0,1,0,100003,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(25,3,7,0,'sdfsd','<br>fdsfsdf<br>dsfsdf\r\n												\r\n												\r\n												\r\n												','2',0,0,'2016-10-21 09:24:24','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00',3,6,2,'','','','','',1,5,2,4,0,1,0,0,0,100001,'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=4 DEFAULT CHARSET=latin1;

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

INSERT INTO `tmails` VALUES (1,19,1,1),(2,16,1,1),(3,25,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,'Tous');

--
-- 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=2 DEFAULT CHARSET=latin1;

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

INSERT INTO `tprocedures` VALUES (1,2,2,'Procédure 1','Redémarrer le poste','',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,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,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,0,0,0,0,2,2,0,0,0,2,2,2,2,0,2,2,0,0,2,0,0,0,0,2,0,0,2,2,0,0,0,2,0,0,0,2,0,0,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,0,0,0,0,2,2,0,2,0),(3,2,0,0,0,2,0,0,0,2,0,0,0,0,2,2,0,2,0,2,2,0,0,2,0,2,0,0,0,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,0,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,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,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=5 DEFAULT CHARSET=latin1;

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

INSERT INTO `tservices` VALUES (1,'Informatique',0),(2,'Administratif',0),(3,'Formation',0),(4,'Prestataire',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=7 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');

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

--
-- 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 AUTO_INCREMENT=2 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=35 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,[BLOB]\">',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);

--
-- 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 `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_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`
--



