-- MySQL dump 10.16  Distrib 10.1.26-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: db
-- ------------------------------------------------------
-- Server version	10.1.26-MariaDB-0+deb9u1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `tbFP`
--

DROP TABLE IF EXISTS `tbFP`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbFP` (
  `id` smallint(6) DEFAULT NULL,
  `code` varchar(7) DEFAULT NULL,
  `codep` varchar(6) DEFAULT NULL,
  `nom` varchar(31) DEFAULT NULL,
  `idFPparent` varchar(3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbFP`
--

LOCK TABLES `tbFP` WRITE;
/*!40000 ALTER TABLE `tbFP` DISABLE KEYS */;
INSERT INTO `tbFP` VALUES (1,'FP0','','DIVERS',''),(2,'FP1','','ELECTRONIQUE',''),(3,'FP11','FP1','DIVERS','2'),(4,'FP12','FP1','CAPTEUR','2'),(5,'FP120','FP12','DIVERS','4'),(6,'FP121','FP12','ANGLE','4'),(7,'FP122','FP12','CONTRAINTE','4'),(8,'FP123','FP12','CHAMP MAGNETIQUE','4'),(9,'FP124','FP12','DEBIT','4'),(10,'FP125','FP12','DEPLACEMENT','4'),(11,'FP126','FP12','DISTANCE','4'),(12,'FP127','FP12','FORCE','4'),(13,'FP128','FP12','INERTIELS','4'),(14,'FP129','FP12','LUMIERE','4'),(15,'FP12A','FP12','NIVEAU','4'),(16,'FP12B','FP12','POSITION','4'),(17,'FP12C','FP12','PRESSION','4'),(18,'FP12D','FP12','SON','4'),(19,'FP12E','FP12','TEMPERATURE','4'),(20,'FP12F','FP12','PRESENCE','4'),(21,'FP13','FP1','CONNECTIQUE','2'),(22,'FP14','FP1','ELEC. DE PUISSANCE','2'),(23,'FP141','FP14','FERRITE','22'),(24,'FP142','FP14','FUSIBLE','22'),(25,'FP143','FP14','POLYSWTICH','22'),(26,'FP144','FP14','RELAIS','22'),(27,'FP145','FP14','TELERUPTEUR','22'),(28,'FP146','FP14','THYRISTORS','22'),(29,'FP147','FP14','TRANSFORMATEURS','22'),(30,'FP148','FP14','TRIACS','22'),(31,'FP149','FP14','DIACS','22'),(32,'FP14A','FP14','VARISTANCES','22'),(33,'FP14B','FP14','MOTEURS','22'),(34,'FP14B1','FP14B','COURANT CONTINU','33'),(35,'FP14B2','FP14B','PAS A PAS','33'),(36,'FP14B3','FP14B','BRUSHLESS','33'),(37,'FP15','FP1','ANALOGIQUE','2'),(38,'FP151','FP15','CONDENSATEUR','37'),(39,'FP152','FP15','RESISTANCE','37'),(40,'FP153','FP15','DIODE','37'),(41,'FP154','FP15','INDUCTANCE','37'),(42,'FP155','FP15','TRANSISTOR','37'),(43,'FP156','FP15','PHOTOCOUPLEUR','37'),(44,'FP157','FP15','MEMRISTOR','37'),(45,'FP158','FP15','REGULATEUR TENSION','37'),(46,'FP16','FP1','INTERFACES','2'),(47,'FP161','FP16','AFFICHEUR','46'),(48,'FP162','FP16','BUZZER','46'),(49,'FP163','FP16','COMMUTATEUR','46'),(50,'FP164','FP16','HAUT-PARLEUR','46'),(51,'FP165','FP16','INTERRUPTEUR','46'),(52,'FP166','FP16','LED','46'),(53,'FP167','FP16','POTENTIOMETRE','46'),(54,'FP168','FP16','ROUE CODEUSE','46'),(55,'FP169','FP16','JOYSTICK','46'),(56,'FP16A','FP16','CLAVIER','46'),(57,'FP17','FP1','CARTE MICRO-CONTROLEURS','2'),(58,'FP171','FP17','RASPBERRY','57'),(59,'FP172','FP17','ARDUINO','57'),(60,'FP173','FP17','CHIPKIT','57'),(61,'FP18','FP1','BOUCLIERS','2'),(62,'FP181','FP18','INTERFACES - RESEAUX','61'),(63,'FP182','FP18','PILOTAGE MOTEURS','61'),(64,'FP183','FP18','PROTOTYPES - DEVELOPPEMENT','61'),(65,'FP184','FP18','ROBOTIQUE','61'),(66,'FP19','FP1','MODULES CONDITIONNES','2'),(67,'FP191','FP19','COMMUTATEUR-ENTREES','66'),(68,'FP192','FP19','AFFICHEUR-LED','66'),(69,'FP193','FP19','ENVIRONNEMENT','66'),(70,'FP194','FP19','MOUVEMENT-DISTANCE','66'),(71,'FP195','FP19','MAGNETIQUE','66'),(72,'FP196','FP19','SON','66'),(73,'FP197','FP19','COMMUNICATION','66'),(74,'FP198','FP19','PILOTES DRIVERS','66'),(75,'FP199','FP19','INTERFACES','66'),(76,'FP2','','MECANIQUE OUTILLAGE',''),(77,'FP20','FP2','DIVERS','76'),(78,'FP21','FP2','STOCKAGE MANUTENTION','76'),(79,'FP22','FP2','ADHESIFS ETANCHEITE','76'),(80,'FP23','FP2','MATERIAUX CONSTRUCTION','76'),(81,'FP231','FP23','BOUTONS LEVIERS POIGNEES','80'),(82,'FP232','FP23','ELEMENTS DE STRUCTURE','80'),(83,'FP2321','FP232','PROFILE-TIGE-BARRE','82'),(84,'FP23211','FP2321','RAINURE','83'),(85,'FP23212','FP2321','BARRE FILETEE','83'),(86,'FP23213','FP2321','BARRE LISSE','83'),(87,'FP24','FP2','OUTILS MANUELS','76'),(88,'FP25','FP2','OUTILS ELECTRIQUES','76'),(89,'FP26','FP2','PLOMBERIE ET CANALISATIONS','76'),(90,'FP27','FP2','PNEUMATIQUE HYDRAULIQUE','76'),(91,'FP28','FP2','VISSERIE','76'),(92,'FP29','FP2','TRANSMISSION','76'),(93,'FP3','','ELECTRICITE',''),(94,'FP31','FP3','AUTOMATISMES ET PROCESS','93'),(95,'FP32','FP3','BOITIERS COFFRES ARMOIRES','93'),(96,'FP33','FP3','CHAUFFAGE VENTILATION AIR COND.','93'),(97,'FP34','FP3','CABLES CORDONS FILS','93'),(98,'FP35','FP3','ECLAIRAGE','93'),(99,'FP36','FP3','DISJONCTION PROTECTION','93'),(100,'FP37','FP3','INTERUPPTEURS','93');
/*!40000 ALTER TABLE `tbFP` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbMG`
--

DROP TABLE IF EXISTS `tbMG`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbMG` (
  `id` tinyint(4) DEFAULT NULL,
  `code` varchar(9) DEFAULT NULL,
  `nom` varchar(16) DEFAULT NULL,
  `codeMG` varchar(0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbMG`
--

LOCK TABLES `tbMG` WRITE;
/*!40000 ALTER TABLE `tbMG` DISABLE KEYS */;
INSERT INTO `tbMG` VALUES (1,'GIM-FO','BUREAU F.OURION',''),(2,'GIM-XB','BUREAU X.BEAUD',''),(3,'LORI-FO','PERSO F.OURION',''),(4,'GIM-ATEL','GIM ATELIER',''),(5,'GIM-INFOR','IUT INFORMATIQUE','');
/*!40000 ALTER TABLE `tbMG` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbMGL`
--

DROP TABLE IF EXISTS `tbMGL`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbMGL` (
  `id` tinyint(4) DEFAULT NULL,
  `codeMGL` varchar(4) DEFAULT NULL,
  `nomMGL` varchar(12) DEFAULT NULL,
  `idMG` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbMGL`
--

LOCK TABLES `tbMGL` WRITE;
/*!40000 ALTER TABLE `tbMGL` DISABLE KEYS */;
INSERT INTO `tbMGL` VALUES (1,'C-01','C-01-LORI-FO',3),(2,'C-02','C-02-LORI-FO',3),(3,'C-03','C-03-LORI-FO',3),(4,'C-04','C-04-LORI-FO',3),(5,'C-05','C-05-LORI-FO',3),(6,'C-06','C-06-LORI-FO',3),(7,'C-07','C-07-LORI-FO',3),(8,'C-08','C-08-LORI-FO',3),(9,'C-09','C-09-LORI-FO',3),(10,'C-10','C-10-LORI-FO',3),(11,'C-11','C-11-LORI-FO',3),(12,'C-12','C-12-LORI-FO',3),(13,'D-01','D-01-LORI-FO',3),(14,'D-02','D-02-LORI-FO',3),(15,'D-03','D-03-LORI-FO',3),(16,'D-04','D-04-LORI-FO',3),(17,'D-05','D-05-LORI-FO',3),(18,'D-06','D-06-LORI-FO',3),(19,'D-07','D-07-LORI-FO',3),(20,'D-08','D-08-LORI-FO',3),(21,'D-09','D-09-LORI-FO',3),(22,'D-10','D-10-LORI-FO',3),(23,'D-11','D-11-LORI-FO',3),(24,'D-12','D-12-LORI-FO',3);
/*!40000 ALTER TABLE `tbMGL` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbPA`
--

DROP TABLE IF EXISTS `tbPA`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbPA` (
  `id` tinyint(4) DEFAULT NULL,
  `categorie` varchar(8) DEFAULT NULL,
  `codePA` varchar(6) DEFAULT NULL,
  `comm` varchar(16) DEFAULT NULL,
  `constructeur` varchar(5) DEFAULT NULL,
  `devise` varchar(0) DEFAULT NULL,
  `email` varchar(0) DEFAULT NULL,
  `fournisseur` varchar(5) DEFAULT NULL,
  `nomPA` varchar(19) DEFAULT NULL,
  `siteweb` varchar(23) DEFAULT NULL,
  `soustraitant` varchar(5) DEFAULT NULL,
  `lettre` varchar(2) DEFAULT NULL,
  `numdebut` varchar(4) DEFAULT NULL,
  `lettrePI` varchar(1) DEFAULT NULL,
  `lettreEQ` varchar(0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbPA`
--

LOCK TABLES `tbPA` WRITE;
/*!40000 ALTER TABLE `tbPA` DISABLE KEYS */;
INSERT INTO `tbPA` VALUES (1,'','PA0000','Interne à Access','true','','','true','GENERIQUE','','true','PA','','',''),(2,'','PA0001','','true','','','true','ARDUINO','','false','PA','','',''),(3,'','PA0002','','true','','','true','FONDATION RASPBERRY','','false','PA','','',''),(4,'','PA0003','','true','','','true','AMAZON','','false','PA','','',''),(5,'','PA0004','','false','','','true','ALIEXPRESS','','false','PA','','',''),(6,'','PA0005','','true','','','true','MOTEDIS','https://www.motedis.fr/','false','PA','','',''),(7,'','PA0006','','true','','','true','VISEXPRESS','','false','PA','','',''),(8,'','PA0007','','true','','','true','GOTRONIC','','false','PA','','',''),(9,'','PA0008','','true','','','true','LEXTRONIC','','false','PA','','',''),(10,'UL-FOURN','PA0009','','true','','','true','RS COMPONENTS','','false','PA','','',''),(11,'','PA0010','','true','','','true','MONFABLAB','','false','PA','','',''),(12,'UL-FOURN','PA0011','','true','','','true','DELL','','false','PA','','',''),(13,'','PA0012','','true','','','false','SAMSUNG','','false','PA','','',''),(14,'','PA0013','','true','','','false','EIZO','','false','PA','','',''),(15,'','PA0014','','true','','','true','HP','','false','PA','','',''),(16,'','PA0015','','true','','','true','ASUS','','false','PA','','',''),(17,'','PA0016','','true','','','true','LENOVO','','false','PA','','',''),(18,'','PA0017','','true','','','false','DENON','','false','PA','','',''),(19,'UL-FOURN','PA0018','','true','','','true','MICROSOFT','','false','PA','','',''),(20,'GIM-ENS','PR01','','false','','','false','OURION-PR','','true','PE','1','F',''),(21,'GIM-ETU','LP01','','false','','','true','ANDJEMBE','','true','PE','1000','A',''),(22,'GIM-ETU','LP02','','false','','','true','AUBERT','','true','PE','1100','A',''),(23,'GIM-ETU','LP03','','false','','','true','BERG','','true','PE','1200','A',''),(24,'GIM-ETU','LP04','','false','','','true','BERTRAND','','true','PE','1300','A',''),(25,'GIM-ETU','LP05','','false','','','false','BISSENG','','true','PE','1400','A',''),(26,'GIM-ETU','LP06','','false','','','false','BOUTEAUD','','true','PE','1500','A',''),(27,'GIM-ETU','LP07','','false','','','false','CORMORECHE','','true','PE','1600','A',''),(28,'GIM-ETU','LP08','','false','','','false','DIASIO','','true','PE','1700','A',''),(29,'GIM-ETU','LP09','','false','','','false','DUPUY','','true','PE','1600','A',''),(30,'GIM-ETU','LP10','','false','','','false','RICHER','','true','PE','1700','A',''),(31,'GIM-ETU','LP11','','false','','','false','SPADI','','true','PE','1800','A',''),(32,'GIM-ETU','LP12','','false','','','false','TISSERANT','','true','PE','1900','A',''),(33,'GIM-ETU','LP13','','false','','','false','TOUSSAINT','','true','PE','2000','A',''),(34,'GIM-ETU','LP14','','false','','','false','VINCENT','','true','PE','2100','A',''),(35,'GIM-ETU','LP15','','false','','','false','VOSGIEN','','true','PE','2200','A','');
/*!40000 ALTER TABLE `tbPA` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbPAcat`
--

DROP TABLE IF EXISTS `tbPAcat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbPAcat` (
  `id` tinyint(4) DEFAULT NULL,
  `codePAcat` varchar(8) DEFAULT NULL,
  `nomPAcat` varchar(27) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbPAcat`
--

LOCK TABLES `tbPAcat` WRITE;
/*!40000 ALTER TABLE `tbPAcat` DISABLE KEYS */;
INSERT INTO `tbPAcat` VALUES (1,'GIM-ETU','ETUDIANTS DEPARTEMENT GIM'),(2,'GIM-ENS','ENSEIGNANTS DEPARTEMENT GIM'),(3,'UL-FOURN','FOURNISSEUR UL');
/*!40000 ALTER TABLE `tbPAcat` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbPI`
--

DROP TABLE IF EXISTS `tbPI`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbPI` (
  `id` tinyint(4) DEFAULT NULL,
  `idSUP` smallint(6) DEFAULT NULL,
  `prefixe` varchar(1) DEFAULT NULL,
  `numero` smallint(6) DEFAULT NULL,
  `codePI` varchar(5) DEFAULT NULL,
  `nomPI` varchar(9) DEFAULT NULL,
  `idFP` smallint(6) DEFAULT NULL,
  `idPAconst` tinyint(4) DEFAULT NULL,
  `refconst` varchar(4) DEFAULT NULL,
  `idUN` tinyint(4) DEFAULT NULL,
  `idPE` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbPI`
--

LOCK TABLES `tbPI` WRITE;
/*!40000 ALTER TABLE `tbPI` DISABLE KEYS */;
INSERT INTO `tbPI` VALUES (1,1303,'A',1303,'A1303','kkkkk',104,8,'eeee',1,24),(2,1,'F',1,'F0001','Nom pièce',94,7,'aaa',1,20),(3,1301,'A',1301,'A1301','R0002',93,7,'bbb',1,24),(4,1302,'A',1302,'A1302','R1302',93,7,'ccc',1,24);
/*!40000 ALTER TABLE `tbPI` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbPIMGL`
--

DROP TABLE IF EXISTS `tbPIMGL`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbPIMGL` (
  `id` varchar(0) DEFAULT NULL,
  `idPI` varchar(0) DEFAULT NULL,
  `idMGL` varchar(0) DEFAULT NULL,
  `idUN` varchar(0) DEFAULT NULL,
  `PUMP` varchar(0) DEFAULT NULL,
  `Qte` varchar(0) DEFAULT NULL,
  `Qs` varchar(0) DEFAULT NULL,
  `Qp` varchar(0) DEFAULT NULL,
  `Qmax` varchar(0) DEFAULT NULL,
  `Qmin` varchar(0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbPIMGL`
--

LOCK TABLES `tbPIMGL` WRITE;
/*!40000 ALTER TABLE `tbPIMGL` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbPIMGL` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbUN`
--

DROP TABLE IF EXISTS `tbUN`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbUN` (
  `id` tinyint(4) DEFAULT NULL,
  `code` varchar(2) DEFAULT NULL,
  `nom` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbUN`
--

LOCK TABLES `tbUN` WRITE;
/*!40000 ALTER TABLE `tbUN` DISABLE KEYS */;
INSERT INTO `tbUN` VALUES (1,'UN','Unité'),(2,'m','Mètre'),(3,'cm','Centimètre'),(4,'mm','Millimètre'),(5,'m3','Mètre cube'),(6,'l','Litre'),(7,'ml','Millilitre');
/*!40000 ALTER TABLE `tbUN` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbUTIL`
--

DROP TABLE IF EXISTS `tbUTIL`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbUTIL` (
  `idUTILMX` varchar(5) DEFAULT NULL,
  `nom` varchar(17) DEFAULT NULL,
  `prenom` varchar(14) DEFAULT NULL,
  `codePROFIL` varchar(11) DEFAULT NULL,
  `typecompte` varchar(2) DEFAULT NULL,
  `accApp` varchar(5) DEFAULT NULL,
  `accMX` varchar(4) DEFAULT NULL,
  `emailUTIL` varchar(52) DEFAULT NULL,
  `langue` varchar(5) DEFAULT NULL,
  `langue2` varchar(5) DEFAULT NULL,
  `nomPA` varchar(0) DEFAULT NULL,
  `telephone` varchar(0) DEFAULT NULL,
  `entite` varchar(10) DEFAULT NULL,
  `idPROFIL` tinyint(4) DEFAULT NULL,
  `idPA` varchar(0) DEFAULT NULL,
  `id` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbUTIL`
--

LOCK TABLES `tbUTIL` WRITE;
/*!40000 ALTER TABLE `tbUTIL` DISABLE KEYS */;
INSERT INTO `tbUTIL` VALUES ('admin','OURION','Franck','PR-ADMIN','in','false','true','franck.ourion@univ-lorraine.fr','fr-fr','fr-fr','','','IUT EPINAL',1,'',1),('gim01','GIM01','GIM01','PR-AGENT','in','false','true','','fr-fr','fr-fr','','','IUT EPINAL',3,'',2),('gim02','GIM02','GIM02','PR-AGENT','in','false','true','','fr-fr','fr-fr','','','IUT EPINAL',3,'',3),('gim03','GIM03','GIM03','PR-AGENT','in','false','true','','fr-fr','fr-fr','','','IUT EPINAL',3,'',4),('gim04','GIM04','GIM04','PR-AGENT','in','false','true','','fr-fr','fr-fr','','','IUT EPINAL',3,'',5),('gim05','GIM05','GIM05','PR-AGENT','in','false','true','','fr-fr','fr-fr','','','IUT EPINAL',3,'',6),('gim06','GIM06','GIM06','PR-AGENT','in','false','true','','fr-fr','fr-fr','','','IUT EPINAL',3,'',7),('gim07','GIM07','GIM07','PR-AGENT','in','false','true','','fr-fr','fr-fr','','','IUT EPINAL',3,'',8),('gim08','GIM08','GIM08','PR-AGENT','in','false','true','','fr-fr','fr-fr','','','IUT EPINAL',3,'',9),('gim09','GIM09','GIM09','PR-AGENT','in','false','true','','fr-fr','fr-fr','','','IUT EPINAL',3,'',10),('gim10','GIM10','GIM10','PR-AGENT','in','false','true','','fr-fr','fr-fr','','','IUT EPINAL',3,'',11),('gim11','GIM11','GIM11','PR-AGENT','in','false','true','','fr-fr','fr-fr','','','IUT EPINAL',3,'',12),('gim12','GIM12','GIM12','PR-AGENT','in','false','true','','fr-fr','fr-fr','','','IUT EPINAL',3,'',13),('lp01','ANDJEMBE NDJAMBOU','ADRIAN LEONARD','PR-DEMA-ETU','ex','false','true','','fr-fr','fr-fr','','','IUT EPINAL',2,'',14),('lp02','AUBERT','DORIAN','PR-DEMA-ETU','ex','false','true','','fr-fr','fr-fr','','','IUT EPINAL',2,'',15),('lp03','BERG','THEO','PR-DEMA-ETU','ex','false','true','','fr-fr','fr-fr','','','IUT EPINAL',2,'',16),('lp04','BERTRAND','MAXIME','PR-DEMA-ETU','ex','false','true','','fr-fr','fr-fr','','','IUT EPINAL',2,'',17),('lp05','BISSENG MOULOPOU','PIERRE RODNEY','PR-DEMA-ETU','ex','false','true','pierre-rodney.bisseng-moulopou3@etu.univ-lorraine.fr','fr-fr','fr-fr','','','IUT EPINAL',2,'',18),('lp06','BOUTEAUD','VIVIEN','PR-DEMA-ETU','ex','false','true','','fr-fr','fr-fr','','','IUT EPINAL',2,'',19),('lp07','CORMORECHE','THOMAS','PR-DEMA-ETU','ex','false','true','','fr-fr','fr-fr','','','IUT EPINAL',2,'',20),('lp08','DIASIO','LUCAS','PR-DEMA-ETU','ex','false','true','','fr-fr','fr-fr','','','IUT EPINAL',2,'',21),('lp09','DUPUY','GABRIEL','PR-DEMA-ETU','ex','false','true','gabriel.dupuy2@etu.univ-lorraine.fr','fr-fr','fr-fr','','','IUT EPINAL',2,'',22),('lp10','RICHER','DAMIEN','PR-DEMA-ETU','ex','false','true','','fr-fr','fr-fr','','','IUT EPINAL',2,'',23),('lp11','SPADI','LUDOVIC','PR-DEMA-ETU','ex','false','true','','fr-fr','fr-fr','','','IUT EPINAL',2,'',24),('lp13','TOUSSAINT','ANTOINE','PR-DEMA-ETU','ex','false','true','','fr-fr','fr-fr','','','IUT EPINAL',2,'',26),('lp14','VINCENT','REMY','PR-DEMA-ETU','ex','false','true','','fr-fr','fr-fr','','','IUT EPINAL',2,'',27),('lp15','VOSGIEN','THOMAS','PR-DEMA-ETU','ex','false','true','','fr-fr','fr-fr','','','IUT EPINAL',2,'',28),('lp12','TISSERANT','ROBIN','PR-DEMA-ETU','ex','false','true','','fr-fr','fr-fr','','','IUT EPINAL',2,'',35);
/*!40000 ALTER TABLE `tbUTIL` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbUTILPROFIL`
--

DROP TABLE IF EXISTS `tbUTILPROFIL`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbUTILPROFIL` (
  `code` varchar(13) DEFAULT NULL,
  `nomprofil` varchar(29) DEFAULT NULL,
  `nomprofilparent` varchar(24) DEFAULT NULL,
  `typecompte` varchar(11) DEFAULT NULL,
  `id` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbUTILPROFIL`
--

LOCK TABLES `tbUTILPROFIL` WRITE;
/*!40000 ALTER TABLE `tbUTILPROFIL` DISABLE KEYS */;
INSERT INTO `tbUTILPROFIL` VALUES ('﻿PR-DEMA-ETU','PROFIL DEMANDEUR  ETUDIANT','PROFIL AGENT UTILISATEUR','Demandeur',2),('PR-ADMIN','PROFIL ADMINISTRATEUR','','Superviseur',1),('PR-AGENT','PROFIL AGENT MAINTENANCE','PROFIL GIM UTILISATEUR','Utilisateur',3),('PR-TECHNICIEN','PROFIL TECHNICIEN MAINTENANCE','PROFIL GIM UTILISATEUR','Utilisateur',4),('PR-UTIL','PROFIL GIM UTILISATEUR','PROFIL ADMINISTRATEUR','Utilisateur',5);
/*!40000 ALTER TABLE `tbUTILPROFIL` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2019-08-22 15:20:27
