
--
-- Table structure for table `papeterie_contact`
--

CREATE TABLE `papeterie_contact` (
  `id_papeterie_contact` int(11) NOT NULL AUTO_INCREMENT,
  `titre` varchar(20) NOT NULL,
  `nom` varchar(100) NOT NULL,
  `prenom` varchar(100) NOT NULL,
  `telephone` varchar(30) NOT NULL,
  `fax` varchar(30) NOT NULL,
  `email` varchar(100) NOT NULL,
  `qualite_ligne_1` varchar(100) NOT NULL,
  `qualite_ligne_2` varchar(100) NOT NULL,
  `qualite_ligne_3` varchar(100) NOT NULL,
  `qualite_ligne_cv_1` varchar(100) NOT NULL,
  `qualite_ligne_cv_2` varchar(100) NOT NULL,
  `qualite_ligne_cv_3` varchar(100) NOT NULL,
  `qualite_ligne_cv_4` varchar(100) NOT NULL,
  `qualite_ligne_cv_5` varchar(100) NOT NULL,
  `qualite_ligne_cv_6` varchar(100) NOT NULL,
  `lieu_cv_1` varchar(100) NOT NULL,
  `lieu_cv_2` varchar(100) NOT NULL,
  `QRCode` enum('recto','verso') NOT NULL,
  PRIMARY KEY (`id_papeterie_contact`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `papeterie_contact`
--

INSERT INTO `papeterie_contact` VALUES (1,'Docteur','TANGUY','Bernard','02 62 41 77 53','0 970 630 637','bmtanguy@gmail.com','Médaille d\'Argent de l\'Académie Nationale de Médecine','Ancien chef de Service au CHU de BellePierre','Médecin Honoraire des Hôpitaux','Pneumologue','Médaille d\'Argent de l\'Académie Nationale de Médecine','Ancien chef de Service au CHU de BellePierre','Médecin Honoraire des Hôpitaux','Membre de la Société de Pneumologie de Langue Française','Membre de l\'European Respiratory Society','49, allée des Topazes','97400 Saint-Denis','verso'),(2,'','IMBOLA','Patrick','0692 27 51 37','','','','','','patrickijp2018@outlook.fr','','','','','','','','recto');

--
-- Table structure for table `params`
--

CREATE TABLE `params` (
  `id_param` varchar(40) NOT NULL DEFAULT '',
  `texte` text NOT NULL,
  `commentaire` text NOT NULL,
  PRIMARY KEY (`id_param`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `params`
--

INSERT INTO `params` VALUES ('AM','971404397',''),('commentaire','Vous êtes prié d’apporter vos attestations de prise en charge\r\n(Carte vitale, mutuelle, CMU, attestation ALD).\r\nEn cas d’empêchement, veuillez nous contacter 48h avant le rendez-vous','Commentaire ligne 2'),('delai_mois_entre_2_efr','4','Délai en mois entre 2 EFR'),('entete','Ancien chef de service au CHU de Bellepierre\r\nAncien Médecin des Hôpitaux\r\n49 Allée des Topazes 97400 SAINT DENIS\r\nTéléphone : 02 62 41 77 53 - Fax : 0 970 630 637',''),('lettre_debut','Cher confrère','Début de la lettre'),('lettre_fin','Confraternellement,','Fin de lettre'),('lieu','49, allée des Topazes 97400 Saint-Denis (en face du CHU)','Lieu'),('nom_docteur','Bernard TANGUY','Nom du docteur'),('pantone_enveloppe','363','Couleur 1'),('qualite_ligne_1','Médaille d\'Argent de l\'Académie Nationale de Médecine',''),('qualite_ligne_2','Ancien chef de Service au CHU de BellePierre',''),('qualite_ligne_3','Médecin Honoraire des Hôpitaux',''),('RPPS','10002317096',''),('specialite','Pneumologue','Spécialité'),('telephone_1','02 62 41 77 53','Téléphone 1'),('telephone_2','','Téléphone 2');

--
-- Table structure for table `paris_metro`
--

CREATE TABLE `paris_metro` (
  `numero` int(11) NOT NULL,
  `text_color` char(7) NOT NULL,
  `background_color` char(7) NOT NULL,
  PRIMARY KEY (`numero`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `paris_metro`
--

INSERT INTO `paris_metro` VALUES (1,'#000000','#F2C931'),(2,'#FFFFFF','#216EB4'),(3,'#FFFFFF','#9A9940'),(4,'#FFFFFF','#BB4D98'),(5,'#000000','#FF8B53'),(6,'#000000','#79BB92'),(7,'#000000','#DF9AB1'),(8,'#000000','#C5A3CA'),(9,'#000000','#CDC83F'),(10,'#000000','#DFB039'),(11,'#FFFFFF','#8E6538'),(12,'#FFFFFF','#328E5B'),(13,'#000000','#89C7D6'),(14,'#FFFFFF','#67328E'),(15,'#FFFFFF','#A90F32'),(16,'#FFFFFF','#EC7CAE'),(17,'#FFFFFF','#95BF32');

--
-- Table structure for table `personnel`
--

CREATE TABLE `personnel` (
  `id_personnel` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(50) NOT NULL DEFAULT '',
  `prenom` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(50) NOT NULL,
  `password_hash` char(60) NOT NULL,
  `id_docteur` int(11) NOT NULL,
  `code_authentification` int(4) DEFAULT NULL,
  `date_authentification_limit` datetime DEFAULT NULL,
  `pagesize` int(50) NOT NULL,
  `time_debut` int(2) NOT NULL,
  `time_fin` int(2) NOT NULL,
  `agenda_defaultview` enum('agendaDay','agendaWeek','month') NOT NULL,
  `agenda_version` enum('1','4') NOT NULL,
  `agenda_deces` enum('all','vivant','deces') NOT NULL,
  `nav_bar` enum('text','icon','icon_text') NOT NULL,
  `agenda_width` int(11) NOT NULL,
  `agenda_height` int(11) NOT NULL,
  `quadrichromie` tinyint(1) NOT NULL,
  PRIMARY KEY (`id_personnel`),
  UNIQUE KEY `email` (`email`),
  KEY `nom` (`nom`),
  KEY `prenom` (`prenom`),
  KEY `password_hash` (`password_hash`),
  KEY `id_docteur` (`id_docteur`),
  CONSTRAINT `personnel_ibfk_1` FOREIGN KEY (`id_docteur`) REFERENCES `docteurs` (`id_docteur`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `personnel`
--

INSERT INTO `personnel` VALUES (1,'TANGUY','Bernard','bmtanguy@gmail.com','$2y$10$TONqI20bktTb8emgJ54w2eQyBZCa/g7LdMvPec1GSFM11kRM3QCRG',1,NULL,NULL,20,8,21,'agendaWeek','4','vivant','icon_text',1250,800,1),(2,'T.','Dominique','domtanguy@gmail.com','$2y$10$E6uNUc2rk.L9arHFjgnCk.dcUwuJE9SPh/MV2nL1R91g214vCMNBu',1,NULL,NULL,20,8,21,'agendaWeek','4','vivant','icon_text',1500,780,1),(3,'TANGUY','Maurice','mtanguy@gmail.com','',2,NULL,NULL,40,8,21,'agendaWeek','4','vivant','icon_text',1550,900,1),(4,'TANGUY','David','datanguy@yahoo.fr','$2y$10$PLN1F7/3n/RFX.PYwF79NOTlr2WDs0ZaYPk7sTSoLtnLFnkvQNpEq',1,9311,'2019-09-16 07:32:10',40,8,21,'agendaWeek','4','all','icon_text',1240,700,0),(5,'Tanguy','Pierre','tanpays@gmail.com','$2y$10$eZ.qw6Rzr5luK.QCKtJCFeutunlA2BgB/4uVr2/zxF6rQJ1uLMzEy',1,NULL,NULL,20,8,21,'agendaWeek','4','vivant','icon_text',1500,780,1),(6,'TANGUY','B. J.','btanguy@gmail.com','$2y$10$VqduAb7pwURsc6E7SjM4nuhteJQ2SCf67baN.8nsIXuOJMXfl2./2',1,NULL,NULL,40,8,21,'agendaWeek','4','vivant','icon_text',1450,900,1),(7,'TAMADOUM','Kemnda','kemnda@kt-expert.com','$2y$10$By25SjvguWbRiz0.ZSSnvOPq.2ozSlwzKChuuy9ax.jUVPfzXUzUy',1,NULL,NULL,20,8,21,'agendaWeek','4','vivant','icon_text',1120,700,1);

--
-- Table structure for table `personnel_conges`
--

CREATE TABLE `personnel_conges` (
  `id_personnel_conge` int(11) NOT NULL AUTO_INCREMENT,
  `id_personnel` int(11) NOT NULL,
  `nom` varchar(255) NOT NULL,
  `datetime_debut` datetime NOT NULL,
  `datetime_fin` datetime NOT NULL,
  PRIMARY KEY (`id_personnel_conge`),
  KEY `id_personnel` (`id_personnel`),
  CONSTRAINT `personnel_conges_ibfk_1` FOREIGN KEY (`id_personnel`) REFERENCES `personnel` (`id_personnel`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=318 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `personnel_conges`
--

INSERT INTO `personnel_conges` VALUES (1,1,'Congrès','2014-03-10 00:00:00','2014-03-16 23:59:00'),(2,4,'Congés - Paris','2014-03-17 00:00:00','2014-03-23 23:59:00'),(3,1,'Congrès','2014-04-16 00:00:00','2014-04-20 23:59:00'),(4,2,'Congés','2014-04-23 00:00:00','2014-05-05 23:59:00'),(5,1,'Congrès SAV','2014-06-10 00:00:00','2014-06-16 23:59:00'),(6,6,'Assemblée Régionale','2014-07-18 00:00:00','2014-07-20 23:59:00'),(7,1,'Assemblée Régionale','2014-07-18 00:00:00','2014-07-20 23:59:00'),(8,2,'Assemblée Régionale','2014-07-18 00:00:00','2014-07-20 23:59:00'),(9,3,'Assemblée Régionale','2014-07-18 00:00:00','2014-07-20 23:59:00'),(10,3,'Permis de Conduire ;)','2014-08-07 00:00:00','2014-08-07 23:59:00'),(11,1,'Voyage MRU','2014-09-05 00:00:00','2014-09-07 23:59:00'),(12,6,'Dec2014 - Jan2015','2014-12-13 00:00:00','2015-01-11 23:59:00'),(13,3,'COGOHR','2014-09-15 00:00:00','2014-09-16 23:59:00'),(14,6,'Dentiste','2014-11-10 13:00:00','2014-11-10 18:00:00'),(15,6,'COGOHR','2014-09-15 00:00:00','2014-09-16 23:59:00'),(16,4,'Dec2014 - Jan2015 ','2014-12-13 00:00:00','2015-01-11 23:59:00'),(17,1,'La Rochelle / Paris / Nancy','2014-10-17 00:00:00','2014-10-22 23:59:00'),(18,1,'congrès spoi','2014-11-25 00:00:00','2014-11-28 23:59:00'),(19,1,'Congrès SPLF','2015-01-29 00:00:00','2015-02-04 23:59:00'),(20,2,'Voyage Nancy','2015-02-07 00:00:00','2015-02-26 23:59:00'),(21,2,'cs Dr Desgane niveau 4piece d\'identité, justificatif d\'adresse','2015-03-04 10:20:00','2015-03-04 11:20:00'),(22,6,'Formation sommeil','2015-06-13 00:00:00','2015-06-20 23:59:00'),(23,2,'Dentiste Akoon','2015-04-10 15:45:00','2015-04-10 16:45:00'),(24,6,'Formation AFGSU1','2015-08-27 00:00:00','2015-08-28 23:59:00'),(25,1,'Assemblée Régionale 2015','2015-07-24 00:00:00','2015-07-26 23:59:00'),(27,6,'Assemblée Régionale 2015','2015-07-24 00:00:00','2015-07-26 23:59:00'),(28,2,'Assemblée Régionale 2015','2015-07-24 00:00:00','2015-07-26 23:59:00'),(29,1,'congés pré-assemblée 2015','2015-07-23 00:00:00','2015-07-23 23:59:00'),(30,2,'congés pré-assemblée 2015','2015-07-23 00:00:00','2015-07-23 23:59:00'),(31,6,'congés pré-assemblée 2015','2015-07-23 00:00:00','2015-07-23 23:59:00'),(32,1,'congés post-assemblée 2015','2015-07-27 00:00:00','2015-07-27 23:59:00'),(33,2,'congés post-assemblée 2015','2015-07-27 00:00:00','2015-07-27 23:59:00'),(34,6,'congés post-assemblée 2015','2015-07-27 00:00:00','2015-07-27 23:59:00'),(35,2,'Formation AFGSU2','2015-09-16 00:00:00','2015-09-18 23:59:00'),(36,1,'Voyage Ile Maurice','2015-05-07 00:00:00','2015-05-10 23:59:00'),(37,3,'été 2015','2015-07-13 00:00:00','2015-07-26 23:59:00'),(38,6,'Dentiste','2015-05-18 14:30:00','2015-05-18 16:30:00'),(39,2,'Kiné','2015-05-26 15:00:00','2015-05-26 16:00:00'),(40,6,'Dentiste','2015-05-29 09:45:00','2015-05-29 11:45:00'),(41,6,'Semaine spéciale','2015-06-23 00:00:00','2015-06-28 23:59:00'),(42,2,'Dentiste','2015-06-25 14:45:00','2015-06-11 16:30:00'),(43,1,'Centre de Reeducation Fonctionnel - Bohringer','2015-06-25 13:00:00','2015-06-25 23:59:00'),(44,1,'RV Anesthésiste','2015-07-03 09:00:00','2015-07-03 10:30:00'),(47,2,'Rdv savs indispensable','2015-07-31 08:00:00','2015-07-31 13:05:00'),(48,2,'kiné','2015-07-17 10:30:00','2015-07-17 12:00:00'),(49,2,'kiné','2015-07-20 16:00:00','2015-07-20 16:30:00'),(50,6,'pas de rdv le jeudi matin','2015-09-24 00:00:00','2015-09-24 13:00:00'),(51,1,'ERS','2015-09-25 00:00:00','2015-10-04 23:59:00'),(53,1,'Congrès SPOI Tana','2015-12-09 00:00:00','2015-12-11 23:59:00'),(54,1,'AztraZeneca - Diabete et SAS','2015-10-08 16:30:00','2015-10-08 23:59:00'),(55,1,'Rdv Dr. Fremont','2015-08-28 09:00:00','2015-08-28 12:00:00'),(56,2,'Congrès SPOI Tana','2015-12-09 00:00:00','2015-12-11 23:59:00'),(57,2,'kine','2015-08-17 15:00:00','2015-08-17 15:30:00'),(58,2,'kiné','2015-08-24 15:00:00','2015-08-24 15:30:00'),(59,2,'kiné','2015-08-31 15:00:00','2015-08-31 15:30:00'),(60,1,'Arpentage terrain Jean Claude','2015-08-27 13:00:00','2015-08-27 14:00:00'),(61,1,'Rendez vous préparation de la Réunion du 8 octobre Dr. SOUYRIS 0262 94 12 88','2015-09-17 14:00:00','2015-09-17 15:00:00'),(62,6,'Congrès Sommeil Nantes','2015-11-16 00:00:00','2015-11-22 23:59:00'),(63,6,'Semaine spéciale, juin 2016','2016-05-31 00:00:00','2016-06-03 23:59:00'),(64,2,'dentiste','2015-08-27 14:00:00','2015-08-27 15:00:00'),(65,1,'kiné guéselin','2015-08-24 17:30:00','2015-08-24 18:00:00'),(66,1,'Kiné La Source','2015-09-08 17:00:00','2015-09-08 18:00:00'),(67,2,'Entretien infirmier','2015-09-15 13:40:00','2015-09-15 14:15:00'),(68,1,'kiné','2015-10-08 17:00:00','2015-10-08 18:00:00'),(69,1,'kiné','2015-10-09 17:00:00','2015-10-09 18:00:00'),(70,6,'Convocation : entretien infirmier','2015-10-22 13:00:00','2015-10-22 14:00:00'),(71,1,'CS Vaccination Madagascar','2015-10-26 11:50:00','2015-10-26 12:20:00'),(72,2,'CS Vaccin Madagas...','2015-10-26 11:30:00','2015-10-26 12:00:00'),(73,1,'semaine spéciale','2015-11-17 08:00:00','2015-10-25 18:59:00'),(74,1,'Dentiste','2015-11-06 12:45:00','2015-11-06 14:15:00'),(75,3,'Marche','2015-12-14 00:00:00','2015-12-14 23:59:00'),(76,1,'prédication salle','2015-11-20 16:00:00','2015-11-20 16:00:00'),(78,1,'kine','2015-10-30 10:00:00','2015-10-30 11:00:00'),(82,1,'kine','2015-11-05 17:00:00','2015-11-05 18:00:00'),(84,1,'kiné','2015-11-06 17:00:00','2015-11-06 18:00:00'),(86,2,'kiné','2015-10-27 15:00:00','2015-10-27 16:00:00'),(88,1,'kine','2015-11-03 17:00:00','2015-11-03 18:00:00'),(89,1,'kine','2015-11-10 17:00:00','2015-11-10 17:00:00'),(90,1,'kine','2015-11-12 17:30:00','2015-11-12 18:00:00'),(91,1,'kine','2015-11-13 17:00:00','2015-11-13 18:00:00'),(92,2,'WAI HOI','2015-12-18 00:00:00','2015-12-18 10:30:00'),(93,1,'CLH','2016-01-20 14:00:00','2016-01-20 23:59:00'),(94,1,'CPLH','2016-01-28 00:00:00','2016-02-02 23:59:00'),(95,6,'Congrès SFRMS, Strasbourg','2016-11-11 11:00:00','2016-11-20 20:20:00'),(96,1,'ERS, London','2016-09-03 00:00:00','2016-09-09 23:59:00'),(97,1,'Congrès SAV, La Rochelle - Quelle machine, quel réglage et accessoires','2016-06-16 00:00:00','2016-06-18 23:59:00'),(98,6,'La pratique de polygraphie et de la polysomnographie, Briancon','2016-02-29 00:00:00','2016-03-07 12:00:00'),(100,1,'soins dentaires','2016-01-11 16:40:00','2016-01-11 17:30:00'),(101,6,'apprentissage CIDELEC - SOS Oxy','2016-02-03 00:00:00','2016-02-03 23:59:00'),(102,1,'Assemblée District','2016-07-07 08:00:00','2016-07-10 23:00:00'),(103,2,'coiffeur','2016-01-15 16:00:00','2016-01-15 23:59:00'),(104,1,'Drentiste','2016-02-26 12:00:00','2016-02-26 15:00:00'),(105,2,'Rhumatholoque 23 J AUBERT F 21 65 34','2016-02-12 10:15:00','2016-02-12 12:00:00'),(106,6,'Dentiste','2016-03-18 00:00:00','2016-03-18 13:00:00'),(108,2,'Congés en métro Pierre','2016-04-30 06:45:00','2016-05-13 19:30:00'),(109,2,'prédication','2016-03-10 13:10:00','2016-03-10 15:15:00'),(110,2,'Prédication','2016-03-17 13:30:00','2016-03-17 15:15:00'),(112,1,'Cs O^phtalmo Dr villeroy','2016-04-06 11:00:00','2016-04-06 11:29:00'),(113,1,'Cs stomato Dr Vives','2016-04-15 11:31:00','2016-04-15 12:00:00'),(114,6,'Dentiste','2016-04-07 11:00:00','2016-04-07 14:30:00'),(115,6,'code','2016-05-25 14:00:00','2016-05-26 14:30:00'),(117,1,'Férié','2016-07-14 08:00:00','2016-07-14 18:00:00'),(118,1,'nouvellle locataire','2016-04-29 11:00:00','2016-04-29 12:00:00'),(119,6,'Dentiste','2016-09-02 08:00:00','2016-09-02 12:00:00'),(121,1,'vacances à Maurice','2016-07-14 08:00:00','2016-07-17 20:00:00'),(122,6,'prédication','2016-06-23 08:00:00','2016-06-23 23:59:00'),(123,1,'ass cir  ','2016-11-04 00:00:00','2016-11-05 23:59:00'),(126,2,'TPS','2016-08-01 14:15:00','2016-08-01 16:30:00'),(127,2,'TPS','2016-08-08 14:15:00','2016-08-08 17:00:00'),(128,1,'LONDRES','2016-09-02 08:00:00','2016-09-02 23:59:00'),(129,1,'congrès SPOI','2016-11-30 08:00:00','2016-12-03 20:20:00'),(130,1,'Fête Cafre','2016-12-20 08:00:00','2016-12-20 18:00:00'),(131,1,'RV Avocat','2016-09-15 16:35:00','2016-09-15 18:00:00'),(132,1,'TAMADOUM','2016-10-06 17:00:00','2016-10-06 18:30:00'),(133,2,'TPS','2016-09-25 16:00:00','2016-09-25 17:00:00'),(134,2,'TPS','2016-10-01 10:00:00','2016-10-01 11:00:00'),(135,1,'Kiné','2016-09-23 07:00:00','2016-09-23 07:30:00'),(136,5,'Congés','2016-12-19 08:30:00','2016-12-19 16:30:00'),(137,2,'dr Le Goc','2016-09-30 10:30:00','2016-09-30 23:59:00'),(138,2,'Dentiste','2016-10-24 15:45:00','2016-10-24 23:01:00'),(140,1,'SEMAINE SPÉCIALE','2017-02-02 00:00:00','2017-02-05 23:59:00'),(141,1,'Dominyc0262 204 402','2016-10-14 10:30:00','2016-10-14 11:45:00'),(142,2,'TPS','2016-10-26 15:00:00','2016-10-26 16:00:00'),(143,2,'séjour métropole','2017-02-06 00:00:00','2017-02-16 23:59:00'),(144,1,'congrès Strasbourg','2016-11-11 11:00:00','2016-11-19 20:20:00'),(146,5,'Congé réunion pour formation','2017-01-30 09:05:00','2017-01-30 15:30:00'),(147,6,'SAA - Semaine d\'Activité Acrue','2017-01-18 08:00:00','2017-01-22 17:00:00'),(148,1,'Congres CPLF Marseille','2017-01-26 08:00:00','2017-01-29 17:00:00'),(149,2,'mammographie : Mascarel','2017-01-23 07:45:00','2017-01-23 08:45:00'),(150,1,'Mémorial','2017-04-11 08:05:00','2017-04-11 17:00:00'),(151,6,'Rdv ophtalmo','2017-03-15 10:00:00','2017-03-15 13:00:00'),(152,6,'SAA','2017-05-24 00:00:00','2017-05-28 23:59:00'),(154,2,'Assemblée Régionale','2017-08-03 00:00:00','2017-08-07 23:59:00'),(155,6,'Assemblée Régionale','2017-08-03 00:00:00','2017-08-07 23:59:00'),(157,1,'Allergo Nancy NATA Florence','2017-04-17 00:00:00','2017-04-23 23:59:00'),(158,1,'jour férié','2017-06-05 00:00:00','2017-06-05 23:59:00'),(159,1,'Victoire 1945','2017-05-08 00:00:00','2017-05-08 23:30:00'),(160,5,'Rv médical important','2017-03-23 08:28:00','2017-03-23 16:30:00'),(161,1,'14 Juillet','2017-07-14 14:00:00','2017-07-14 17:15:00'),(163,1,'départ en métropole','2017-06-14 08:00:00','2017-06-16 23:59:00'),(164,1,'A Maurice et Eléonore','2017-05-05 10:15:00','2017-05-05 11:00:00'),(165,2,'dentiste','2017-05-10 15:00:00','2017-05-10 17:00:00'),(166,2,'dentiste','2017-05-17 15:00:00','2017-05-17 17:00:00'),(167,2,'dentiste','2017-05-24 15:00:00','2017-05-24 17:00:00'),(168,2,'dentiste','2017-05-31 15:00:00','2017-05-31 17:00:00'),(169,1,'congès métropole','2017-04-24 08:30:00','2017-04-24 12:00:00'),(170,2,'dentiste','2017-06-07 15:00:00','2017-06-07 17:00:00'),(171,2,'ORL','2017-04-27 14:30:00','2017-04-27 17:00:00'),(172,5,'Congés du à l\'absence  du Dr Tanguy','2017-04-19 09:00:00','2017-04-21 16:30:00'),(174,1,'départ maurice , éléonore','2017-05-25 22:30:00','2017-05-25 23:59:00'),(176,2,'kine','2017-05-11 10:00:00','2017-05-11 10:30:00'),(177,2,'Radio Masc','2017-05-10 09:30:00','2017-05-10 10:30:00'),(189,2,'Scanner Rocher ','2017-06-01 16:00:00','2017-06-01 17:00:00'),(193,2,'KINE','2017-06-15 17:00:00','2017-06-15 17:30:00'),(194,1,'SEPRODOM','2017-06-28 15:30:00','2017-06-28 16:00:00'),(195,1,'SEPRODOM','2017-06-28 15:30:00','2017-06-28 16:00:00'),(197,1,'ERS Milan','2017-09-11 08:30:00','2017-09-15 23:59:00'),(198,6,'Code','2017-07-20 00:00:00','2017-07-20 13:00:00'),(199,1,'Consultation','2017-08-11 15:45:00','2017-08-11 16:15:00'),(202,6,'Congés Août 2017','2017-08-29 12:30:00','2017-08-31 20:00:00'),(204,5,'Acte dentaire','2017-08-09 10:30:00','2017-08-09 16:00:00'),(205,1,'Congrès Quebec','2017-10-10 00:00:00','2017-10-20 23:59:00'),(206,6,'Congrès Quebec','2017-10-10 00:00:00','2017-10-20 23:59:00'),(207,1,'','2017-08-16 08:00:00','2017-08-17 18:00:00'),(208,1,'Congrès Bordeaux','2017-08-16 08:00:00','2017-08-17 18:00:00'),(211,1,'Spoi Inde','2017-11-27 00:00:00','2017-12-03 23:59:00'),(213,2,'SPOI Inde','2017-11-28 00:00:00','2017-12-05 23:59:00'),(214,1,'Cours Sommeil','2017-11-16 00:00:00','2017-11-17 23:59:00'),(216,2,'Visite médicale','2017-11-13 10:30:00','2017-11-13 12:00:00'),(217,2,'ORTHO','2017-11-16 14:00:00','2017-11-16 15:00:00'),(218,1,'jour férié','2017-12-20 07:00:00','2017-12-20 23:59:00'),(219,1,'jour férié','2017-12-20 07:00:00','2017-12-20 23:59:00'),(220,1,'entretien mr Boyer sur l\'asthme','2017-12-18 10:30:00','2017-12-18 11:15:00'),(221,1,'cgss','2017-12-14 08:00:00','2017-11-14 14:00:00'),(222,6,'Vacances à Mayotte','2018-05-06 00:00:00','2018-05-15 23:59:00'),(223,1,'Formation Acachon','2018-01-18 00:00:00','2018-01-19 23:59:00'),(224,1,'féte du travail','2018-05-01 00:00:00','2018-05-01 23:59:00'),(225,1,'Lundi de Pâques','2018-04-02 00:00:00','2018-04-02 23:59:00'),(226,1,'VICTOIRE 45','2018-05-08 00:00:00','2018-05-08 23:59:00'),(227,1,'VICTOIRE 45','2018-05-08 00:00:00','2018-05-08 23:59:00'),(228,1,'Pont du 1er mai.','2018-04-30 00:00:00','2018-04-30 23:59:00'),(229,1,'Pont du 1er mai.','2018-04-30 00:00:00','2018-04-30 23:59:00'),(230,6,'Réunion spécial pionniers','2018-03-30 00:00:00','2018-03-30 23:59:00'),(231,2,'Congés Février 2018','2018-02-21 18:00:00','2018-03-07 07:00:00'),(233,1,'St Francois','2018-03-15 14:00:00','2018-03-15 16:00:00'),(235,1,'Voyage','2018-03-19 00:00:00','2018-03-20 23:59:00'),(236,1,'Congé Arcachon','2018-03-22 00:00:00','2018-03-23 23:59:00'),(237,6,'Ecole des pionniers','2018-08-13 12:00:00','2018-08-26 23:59:00'),(238,6,'Assemblée Régionale','2018-07-26 00:00:00','2018-07-30 23:59:00'),(239,1,'Assemblée Régionale','2018-07-26 00:00:00','2018-07-30 23:59:00'),(240,2,'Assemblée Régionale','2018-07-26 00:00:00','2018-07-30 23:59:00'),(241,5,'Assemblée Régionale','2018-07-26 00:00:00','2018-07-30 23:59:00'),(242,1,'','2018-03-29 16:15:00','2018-03-29 23:59:00'),(243,1,'Départ de Maurice','2018-03-29 16:15:00','2018-03-29 23:59:00'),(244,1,'Formation PERIMETRE','2018-06-19 13:00:00','2018-06-23 18:00:00'),(245,6,'Formation PERIMETRE','2018-06-19 13:00:00','2018-06-25 23:59:00'),(246,1,'ASCENSION','2018-05-10 00:00:00','2018-05-10 23:59:00'),(247,1,'lundi de Pentecôte','2018-05-21 00:00:00','2018-05-21 23:59:00'),(248,6,'vacances à Mayotte','2018-05-14 00:00:00','2018-05-14 23:59:00'),(249,1,'Séjour à Maurice','2018-05-17 00:00:00','2018-05-20 23:59:00'),(250,6,'Séjour à Maurice','2018-05-17 00:00:00','2018-05-20 23:59:00'),(251,5,'Séjour à Maurice','2018-05-17 00:00:00','2018-05-20 23:59:00'),(252,1,'Rdv Kemnda','2018-05-22 16:00:00','2018-05-22 23:59:00'),(253,1,'Rdv Dr. BESNARD','2018-05-03 10:30:00','2018-05-03 14:00:00'),(254,1,'Rdv Dr. LEMBA','2018-05-16 11:00:00','2018-05-16 14:00:00'),(255,1,'15/05/2018','2018-05-15 11:30:00','2018-05-15 12:00:00'),(256,1,'15/05/2018','2018-05-15 11:30:00','2018-05-15 12:00:00'),(257,6,'Réunion de préparation à l’AR','2018-06-01 17:30:00','2018-06-01 23:59:00'),(258,1,'Atelier Arcachon','2018-05-31 08:00:00','2018-06-05 18:00:00'),(259,1,'Arcachon','2018-06-04 08:00:00','2018-06-05 14:00:00'),(260,1,'RV dr Veerapen','2018-05-24 13:00:00','2018-05-24 13:30:00'),(261,1,'RV dr Veerapen','2018-05-24 13:00:00','2018-05-24 13:30:00'),(262,1,'RV dr Veerapen','2018-05-24 13:00:00','2018-05-24 13:30:00'),(263,6,'Rdv Ophtamo','2018-07-02 13:00:00','2018-07-02 15:59:00'),(264,1,'Me Cauchepin','2018-07-16 11:00:00','2018-07-16 12:00:00'),(265,1,'Me Cauchepin','2018-07-16 11:00:00','2018-07-16 12:00:00'),(266,1,'Semaine Spéciale','2018-07-19 08:00:00','2018-07-20 23:59:00'),(267,1,'Dr Deganne','2018-07-09 09:00:00','2018-07-09 10:00:00'),(269,2,'Dr DEGANNE','2018-07-09 09:30:00','2018-07-09 10:00:00'),(270,2,'Cs Chd Rhumatologie','2018-11-05 11:30:00','2018-11-05 13:30:00'),(271,1,'Congés Paris ','2018-09-15 08:00:00','2018-09-20 18:00:00'),(272,1,'CPLF','2019-01-23 12:00:00','2019-02-02 23:59:00'),(273,6,'CPLF','2019-01-23 12:00:00','2019-02-02 23:59:00'),(275,1,'SPOI 2018 ','2018-12-04 00:00:00','2018-12-09 20:35:00'),(277,1,'CPLF (suite)','2019-01-28 00:00:00','2019-01-31 23:59:00'),(278,1,'Mémorial','2019-04-19 14:00:00','2019-04-19 20:00:00'),(279,1,'EAA','2019-06-24 00:00:00','2019-06-28 23:59:00'),(280,1,'Consultation anesthésique','2019-03-12 12:00:00','2019-03-12 23:59:00'),(281,1,'Coloscopie - Clinique Ste Clotilde. Dr. Blais','2019-04-01 11:00:00','2019-04-01 23:59:00'),(283,1,'Semaine Spéciale','2019-06-12 00:00:00','2019-06-14 23:59:00'),(284,1,'Crédit Agricole','2019-04-03 15:00:00','2019-04-03 23:59:00'),(285,6,'Crédit Agricole','2019-04-03 15:00:00','2019-04-03 23:59:00'),(286,3,'','2019-04-08 08:00:00','2019-04-04 18:00:00'),(287,3,'Voyage à Maurice.','2019-04-08 08:00:00','2019-04-04 18:00:00'),(288,1,'lundi de Pâques','2019-04-22 00:00:00','2019-04-22 23:59:00'),(289,1,'Anniversaire victoire 1945','2019-05-08 00:00:00','2019-05-08 23:59:00'),(294,1,'ASCENSION','2019-05-30 00:00:00','2019-05-30 23:59:00'),(295,1,'Lundi de Pentecôte','2019-06-10 00:00:00','2019-06-10 23:59:00'),(296,1,'Rdv M. Cauchepin & M. Gaillard','2019-06-03 15:00:00','2019-06-03 23:59:00'),(297,2,'Séjour en France','2019-06-17 08:00:00','2019-07-03 23:00:00'),(299,1,'RV Me MICHEL avec les enfants','2019-07-18 08:30:00','2019-07-18 09:30:00'),(300,1,'Soirée SEPRODOM Hotel Bellepierre','2019-07-18 19:30:00','2019-07-18 20:30:00'),(301,6,'Randonnée','2019-07-29 00:00:00','2019-08-01 00:00:00'),(303,4,'Congrès','2019-07-25 00:00:00','2019-07-29 23:59:00'),(304,1,'vacances avec Maurice','2019-07-09 00:00:00','2019-07-09 23:59:00'),(305,1,'vacance de Maurice à la Réunion','2019-07-09 00:00:00','2019-07-09 23:59:00'),(306,1,'vacance de Maurice à la Réunion','2019-07-19 08:30:00','2019-07-19 23:59:00'),(307,1,'CA','2019-08-12 15:00:00','2019-08-12 18:00:00'),(308,2,'TPS','2019-09-17 09:00:00','2019-09-17 10:00:00'),(309,2,'TPS','2019-09-30 10:00:00','2019-09-30 11:00:00'),(310,1,'RV Me Michel','2019-09-10 15:00:00','2019-08-14 18:59:00'),(311,1,'ERS Madrid','2019-09-28 08:00:00','2019-10-07 12:00:00'),(316,1,'Implant stomato CHU F.Guyon','2019-12-12 08:30:00','2019-12-12 10:00:00'),(317,1,'Congres SPOI','2019-12-05 14:00:00','2019-12-06 23:59:00');

--
-- Table structure for table `personnel_conges_cyclique`
--

CREATE TABLE `personnel_conges_cyclique` (
  `id_personnel_conge_cyclique` int(11) NOT NULL AUTO_INCREMENT,
  `id_personnel` int(11) NOT NULL,
  `nom` varchar(255) NOT NULL,
  `date_debut` date NOT NULL,
  `date_fin` date DEFAULT NULL,
  `periodicite` enum('day','week','month') NOT NULL,
  `time_debut` time NOT NULL,
  `time_fin` time NOT NULL,
  PRIMARY KEY (`id_personnel_conge_cyclique`),
  KEY `id_personnel` (`id_personnel`),
  CONSTRAINT `personnel_conges_cyclique_ibfk_1` FOREIGN KEY (`id_personnel`) REFERENCES `personnel` (`id_personnel`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `personnel_conges_cyclique`
--

INSERT INTO `personnel_conges_cyclique` VALUES (1,6,'Matinée du vendredi matin','2017-04-07','2030-06-07','week','08:00:00','12:00:00');

--
-- Table structure for table `personnel_obligatoire_services`
--

CREATE TABLE `personnel_obligatoire_services` (
  `id_personnel` int(11) NOT NULL,
  `id_type_rendez_vous` int(11) NOT NULL,
  PRIMARY KEY (`id_personnel`,`id_type_rendez_vous`),
  KEY `id_service` (`id_type_rendez_vous`),
  CONSTRAINT `personnel_obligatoire_services_ibfk_1` FOREIGN KEY (`id_personnel`) REFERENCES `personnel` (`id_personnel`) ON UPDATE CASCADE,
  CONSTRAINT `personnel_obligatoire_services_ibfk_2` FOREIGN KEY (`id_type_rendez_vous`) REFERENCES `type_rendez_vous` (`id_type_rendez_vous`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `personnel_obligatoire_services`
--

INSERT INTO `personnel_obligatoire_services` VALUES (1,1),(6,3),(6,4),(6,5);

--
-- Table structure for table `personnel_services`
--

CREATE TABLE `personnel_services` (
  `id_personnel` int(11) NOT NULL,
  `id_service` int(11) NOT NULL,
  PRIMARY KEY (`id_personnel`,`id_service`),
  KEY `id_service` (`id_service`),
  CONSTRAINT `personnel_services_ibfk_2` FOREIGN KEY (`id_personnel`) REFERENCES `personnel` (`id_personnel`) ON UPDATE CASCADE,
  CONSTRAINT `personnel_services_ibfk_3` FOREIGN KEY (`id_service`) REFERENCES `services` (`id_service`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `personnel_services`
--

INSERT INTO `personnel_services` VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(1,2),(2,2),(3,2),(4,2),(5,2),(6,2),(1,3),(2,3),(3,3),(4,3),(5,3),(6,3),(1,4),(2,4),(3,4),(4,4),(5,4),(6,4),(1,5),(2,5),(3,5),(4,5),(5,5),(6,5),(1,6),(4,6),(7,6),(4,7);

--
-- Table structure for table `personnel_type_rendez_vous`
--

CREATE TABLE `personnel_type_rendez_vous` (
  `id_personnel` int(11) NOT NULL,
  `id_type_rendez_vous` int(11) NOT NULL,
  PRIMARY KEY (`id_personnel`,`id_type_rendez_vous`),
  KEY `id_type_rendez_vous` (`id_type_rendez_vous`),
  CONSTRAINT `personnel_type_rendez_vous_ibfk_1` FOREIGN KEY (`id_personnel`) REFERENCES `personnel` (`id_personnel`) ON UPDATE CASCADE,
  CONSTRAINT `personnel_type_rendez_vous_ibfk_2` FOREIGN KEY (`id_type_rendez_vous`) REFERENCES `type_rendez_vous` (`id_type_rendez_vous`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `personnel_type_rendez_vous`
--

INSERT INTO `personnel_type_rendez_vous` VALUES (1,3),(1,4),(2,4),(3,4),(4,4),(6,4),(1,5),(2,5),(3,5),(4,5),(6,5);

--
-- Table structure for table `personnel_type_rendez_vous_groupe`
--

CREATE TABLE `personnel_type_rendez_vous_groupe` (
  `id_personnel` int(11) NOT NULL,
  `id_type_rendez_vous_groupe` int(11) NOT NULL,
  PRIMARY KEY (`id_personnel`,`id_type_rendez_vous_groupe`),
  KEY `id_type_rendez_vous_groupe` (`id_type_rendez_vous_groupe`),
  CONSTRAINT `personnel_type_rendez_vous_groupe_ibfk_1` FOREIGN KEY (`id_personnel`) REFERENCES `personnel` (`id_personnel`) ON UPDATE CASCADE,
  CONSTRAINT `personnel_type_rendez_vous_groupe_ibfk_2` FOREIGN KEY (`id_type_rendez_vous_groupe`) REFERENCES `type_rendez_vous_groupe` (`id_type_rendez_vous_groupe`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `personnel_type_rendez_vous_groupe`
--

INSERT INTO `personnel_type_rendez_vous_groupe` VALUES (1,1),(2,1),(4,1),(6,1),(1,2),(2,2),(4,2),(6,2),(1,3),(2,3),(4,3),(6,3),(1,4),(2,4),(4,4),(6,4);

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id_service` int(11) NOT NULL AUTO_INCREMENT,
  `service` varchar(40) NOT NULL,
  `icon` varchar(100) NOT NULL,
  `icon_color` char(6) NOT NULL,
  PRIMARY KEY (`id_service`),
  KEY `service` (`service`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `services`
--

INSERT INTO `services` VALUES (1,'home','fa-home','50CBEF'),(2,'recherche','fa-user','5982CF'),(3,'agenda','fa-calendar','E6564E'),(4,'courrier','fa-envelope-o','53B15B'),(5,'gestion','fa-wrench','50CBEF'),(6,'banque','fa-money','598D67'),(7,'admin','fa-cog','CFCFCF');

--
-- Table structure for table `services_menus`
--

CREATE TABLE `services_menus` (
  `id_menu` int(11) NOT NULL AUTO_INCREMENT,
  `id_service` int(11) NOT NULL,
  `menu` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  PRIMARY KEY (`id_menu`),
  KEY `id_service` (`id_service`),
  CONSTRAINT `services_menus_ibfk_1` FOREIGN KEY (`id_service`) REFERENCES `services` (`id_service`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `services_menus`
--

INSERT INTO `services_menus` VALUES (1,1,'Home','/cabinet/home/index.php'),(4,2,'Recherche','/cabinet/consultations/index.php'),(5,3,'Agenda','/cabinet/agenda/index.php'),(7,4,'Courrier medecin','/cabinet/medecins/courrier/index.php'),(8,5,'Statistiques','/cabinet/gestion/statistiques/index.php'),(9,5,'Actes','/cabinet/gestion/actes/index.php'),(10,5,'Médicaments','/cabinet/gestion/medicaments/index.php'),(11,5,'Alertes EFR','/cabinet/gestion/alertes/alertes_EFR.php'),(12,5,'Vos feuillets','/cabinet/gestion/vos_feuillets/index.php?id_papeterie_contact=1'),(13,5,'Paramètres','/cabinet/gestion/parametres/parametres/index.php'),(14,5,'Mutelles','/cabinet/gestion/mutuelles/index.php'),(15,5,'Congés','/cabinet/gestion/conges/index.php'),(16,5,'Doublons / Intellio','/cabinet/gestion/intellio/index.php?date_consultation%5B0%5D=1'),(17,6,'Comptes bancaires','/cabinet/comptes_bancaires/index.php'),(18,7,'Monitoring',''),(19,7,'Bibliothèques','/cabinet/admin/libraries/index.php'),(20,7,'Documentation','/cabinet/documentation/index.php'),(21,7,'Services / Menus','/cabinet/admin/menus/index.php'),(22,7,'Base de données','/cabinet/admin/base_de_donnee/index.php'),(23,7,'Sauvergarde','/cabinet/admin/file_cabinet/index.php?id_usage=backup');

--
-- Table structure for table `services_ss_menus`
--

CREATE TABLE `services_ss_menus` (
  `id_ss_menu` int(11) NOT NULL AUTO_INCREMENT,
  `id_menu` int(11) NOT NULL,
  `ss_menu` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `query_string` varchar(255) NOT NULL,
  `icon` varchar(255) NOT NULL,
  PRIMARY KEY (`id_ss_menu`),
  KEY `id_menu` (`id_menu`),
  CONSTRAINT `services_ss_menus_ibfk_1` FOREIGN KEY (`id_menu`) REFERENCES `services_menus` (`id_menu`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `services_ss_menus`
--

INSERT INTO `services_ss_menus` VALUES (1,13,'Parametres','/cabinet/gestion/parametres/parametres/index.php','',''),(2,13,'Couleurs','/cabinet/gestion/parametres/couleurs/index.php','',''),(3,13,'Docteurs','/cabinet/gestion/parametres/docteurs/index.php','',''),(4,18,'Info sur le système','/cabinet/admin/monitoring/info_systeme/index.php','display_all_config_value=0',''),(5,18,'Log erreurs','/cabinet/admin/monitoring/error_log/index.php','',''),(6,18,'Erreurs SQL','/cabinet/admin/monitoring/sql_error_log/index.php','',''),(7,18,'Erreur num lignes SQL','/cabinet/admin/monitoring/sql_numrows_log/index.php','',''),(8,18,'Log PHP','/cabinet/admin/monitoring/php_errors/index.php','',''),(9,18,'Log apache','/cabinet/admin/monitoring/apache_errors/index.php','',''),(10,18,'Log authentification','/cabinet/admin/monitoring/authentification_log/index.php','',''),(11,18,'SNMP','/cabinet/admin/monitoring/snmp/index.php','ip=192.168.2.68','');

--
-- Table structure for table `type_rendez_vous`
--

CREATE TABLE `type_rendez_vous` (
  `id_type_rendez_vous` int(11) NOT NULL,
  `id_type_rendez_vous_groupe` int(11) NOT NULL,
  `intitule` varchar(50) NOT NULL,
  `abrege` varchar(5) NOT NULL,
  `duree_minutes` int(11) NOT NULL,
  `previsionnel` decimal(6,2) NOT NULL,
  `background_color` char(6) NOT NULL,
  `border_color` char(6) NOT NULL,
  PRIMARY KEY (`id_type_rendez_vous`),
  KEY `id_type_rendez_vous_groupe` (`id_type_rendez_vous_groupe`),
  CONSTRAINT `type_rendez_vous_ibfk_1` FOREIGN KEY (`id_type_rendez_vous_groupe`) REFERENCES `type_rendez_vous_groupe` (`id_type_rendez_vous_groupe`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `type_rendez_vous`
--

INSERT INTO `type_rendez_vous` VALUES (1,1,'Consultation','Cs',30,32.60,'9CC773','73C61F'),(2,1,'Dépression','Depr',30,69.12,'339900','336633'),(3,2,'EFR','EFR',30,76.80,'FFF7DE','FFC10A'),(4,2,'Polygraphie Ventilatoire','PV',60,145.92,'CECBE7','8277E5'),(5,2,'Polysomnographie','PSG',60,214.27,'CE80E7','8277E5'),(6,3,'PPC','PPC',60,32.60,'33CCFF','8277E5'),(7,3,'TM6','TM6',60,32.60,'66FFFF','8277E5'),(8,4,'Autre','Autr',60,32.60,'0094FF','004A7F');

--
-- Table structure for table `type_rendez_vous_groupe`
--

CREATE TABLE `type_rendez_vous_groupe` (
  `id_type_rendez_vous_groupe` int(11) NOT NULL,
  `intitule` varchar(50) CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`id_type_rendez_vous_groupe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `type_rendez_vous_groupe`
--

INSERT INTO `type_rendez_vous_groupe` VALUES (1,'Cs'),(2,'EFR Som'),(3,'PPC TM6'),(4,'Autre');


