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

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,
  `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;

--
-- Dumping data for table `tparameters`
--

INSERT INTO `tparameters` VALUES (1,'Socotec Formation Nucléaire','http://sfn-intranet.fr/gestup','3.1.8','stable',14,1,'smtp.office365.com','IsSMTP()',587,'1','0','eddy.mequignon@socotec.com','Hruqgcwk2','Bonjour, <br />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,'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);

--
-- 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,2,2,2,2,2,0,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,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,[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);

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

--
-- 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(50) 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

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

INSERT INTO `tusers` VALUES (1,'admin','1940922d9d0baf55c6720b32ed041b9f','77941','admin','',4,'admin@exemple.fr','06 09 56 89 45','0','',0,0,'','','0','','','',0,0,'2016-10-20 15:28:12','','',''),(2,'user','6f7dbd355718353c093ef5b13be84747','cb388','user','',2,'eddy.mequignon@socotec.com','','','',0,0,'','','','','','',0,0,'2016-10-21 08:56:47','','',''),(7,'mequigne','cc0842528b32b7ced7d83540460a000b','3efdc','Eddy','Méquignon',0,'eddy.mequignon@socotec.com','0651731519','','Admin réseau',0,1,'Avenue de la Gironde ','','59944','Dunkerque','','',0,0,'2016-10-20 16:24:35','skin-1','','');

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



