INSERT INTO `ordonnances_lignes` VALUES (12890,6659,'maladies_intercurrentes','EXACYL 1 g/10 ml, solution buvable','1amp X3/j si recidive saignement',0),(12891,6659,'maladies_intercurrentes','Symbicort rapihaler 2B m et s avec rinçage','',0),(12892,6659,'maladies_intercurrentes','Spiolto 2 B le m ','',0),(12893,6660,'maladies_intercurrentes','SINGULAIR 10 mg, comprimé pelliculé','1 cp le s ',0),(12894,6660,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(12895,6660,'maladies_intercurrentes','Permanganate de potassium 1 bte sachets à dissoudre dans de l','2 btes',0),(12896,6660,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(12897,6660,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1mg/2ml  m et s ','pdt 10 jrs avec rinçage',0),(12898,6661,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie','',0),(12899,6662,'affection_exonorante','Radiographie thoracique','pour Cs de décembre 2017',0),(12900,6663,'affection_exonorante','EXACYL 1 g/10 ml, solution buvable','1amp X4 /j  2 btes',0),(12901,6663,'affection_exonorante','Foradil 2 gel/j','',0),(12902,6663,'affection_exonorante','ZITHROMAX 250 mg, comprimé pelliculé 1 X 3 / semaine','',0),(12903,6663,'affection_exonorante','Tardiferon B9 80 mg X2 /J ','',0),(12904,6663,'affection_exonorante','Ventoline 2B en cas de besoin','',0),(12905,6664,'maladies_intercurrentes','TDM des sinus','',0),(12906,6664,'maladies_intercurrentes','Echographie abdominale','',0),(12907,6665,'maladies_intercurrentes','NFS-Plaquettes','',0),(12908,6665,'maladies_intercurrentes','CRP','',0),(12909,6665,'maladies_intercurrentes','IgE Totales','',0),(12910,6666,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule','2 gelX2 /j',0),(12911,6666,'maladies_intercurrentes','SMECTA, poudre pour suspension buvable en sachet','1 sachet X 2/j',0),(12912,6666,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','1 cp  m et s ',0),(12913,6666,'maladies_intercurrentes','Gaviscon 1 sachet X 3/J','',0),(12914,6667,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie','',0),(12915,6668,'affection_exonorante','Location d\'un appareil d\'aérosolthérapie','',0),(12916,6669,'affection_exonorante','Aérsosolthérapie BRICANYL (TERBUTALINE) ATROVENT (IPRATROPIUM) X 2/j','',0),(12917,6669,'affection_exonorante','BUDESONIDE 1mg/2ml m et s avec rinçage','',0),(12918,6669,'affection_exonorante','Seretide 250 2 B m et s avec rinçage','',0),(12919,6669,'affection_exonorante','SINGULAIR 10 mg, comprimé pelliculé','1 cp le s ',0),(12920,6669,'affection_exonorante','SPIRIVA RESPIMAT 2,5 microgrammes/dose, solution pour inhalation','1 B /j',0),(12921,6669,'affection_exonorante','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(12922,6670,'maladies_intercurrentes','Location d\'un appareil d\'aérsolthérapie pdt 15 jrs','',0),(12923,6671,'maladies_intercurrentes','Aérsolthérapie BUDESONIDE 1 mg/ 2ml m et s avec rinçage','',0),(12924,6672,'maladies_intercurrentes','Symbicort Rapihaler 2 B m et s avec rinçage','',0),(12925,6672,'maladies_intercurrentes','Avec chambre d','',0),(12926,6672,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(12927,6672,'maladies_intercurrentes','SURBRONC EXPECTORANT AMBROXOL 30 mg, comprimé sécable','& cp /j',0),(12928,6673,'maladies_intercurrentes','Vaccin AntigrIppal','',0),(12929,6674,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s  2 btes',0),(12930,6675,'affection_exonorante','Examen cytobacteriologique des crachats ','',0),(12931,6675,'affection_exonorante','Recherche BK et germes banaux Ex Direct,Culture,Antibiogramme','',0),(12932,6675,'affection_exonorante','Hemoglobine glyqué','',0),(12933,6675,'affection_exonorante','Glycémie à jeun ','',0),(12934,6675,'affection_exonorante','NFS-Plaquettes/CRP','',0),(12935,6676,'maladies_intercurrentes','Location d\'un appareil d\'aérsolthérapie ','',0),(12936,6677,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1mg/2mg m et s avec rinçage','',0),(12937,6678,'maladies_intercurrentes','NFS-Plaquttes','',0),(12938,6678,'maladies_intercurrentes','VS/CRP','',0),(12939,6679,'maladies_intercurrentes','Kinésithérapie respiratoire centrée sur les deux coupoles diaphragmatiques','3 séances/semaine',0),(12940,6680,'maladies_intercurrentes','PNEUMO 23, solution injectable en seringue pré-remplie. vaccin pneumococcique polyosidique','',0),(12943,6682,'maladies_intercurrentes','TDM thoracique sans injection','',0),(12944,6683,'maladies_intercurrentes','NFS - plaquettes','',0),(12945,6683,'maladies_intercurrentes','VS/ CRP','',0),(12946,6684,'maladies_intercurrentes','Augmentin 1GX3 /j','',0),(12947,6684,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule','2 gel m et s ',0),(12948,6685,'maladies_intercurrentes','Aérosolthérapie BRICANYL-ATROVENT X 2 /J','',0),(12949,6685,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1mg/2ml X2/j avec rinçage','',0),(12950,6686,'maladies_intercurrentes','Aérosolthérapie location d','',0),(12951,2824,'affection_exonorante','SPAGULAX MUCILAGE PUR, granulés en sachet dose','1 sachet/j',0),(12952,2824,'affection_exonorante','PAROEX 0,12 POUR CENT, solution pour bain de bouche','Gargarisme m et s ',0),(12953,2824,'affection_exonorante','Ventoline 2B en cas de besoin','',0),(12954,6687,'affection_exonorante','Kinésiethérapie Respiratoire TVD à domicile ','3 séances/ semaine',0),(12955,6688,'maladies_intercurrentes','Mag 2  2 amp buv midi ','',0),(12956,6688,'maladies_intercurrentes','FORADIL 12 microgrammes, poudre pour inhalation en gélule','1 gel inh m et s',0),(12957,6689,'maladies_intercurrentes','Radiographie thoracique','',0),(12958,6689,'maladies_intercurrentes','TDM des sinus','',0),(12959,6690,'maladies_intercurrentes','NFS-Plaquettes','',0),(12960,6690,'maladies_intercurrentes','IgE totales','',0),(12961,6691,'maladies_intercurrentes','SINGULAIR 10 mg, comprimé pelliculé','1 cp le s ',0),(12962,6692,'affection_exonorante','Spioloto 2 B consécutives','2 btes',0),(12964,6693,'affection_exonorante','Spiolto 2 B consécutives','',0),(12965,6693,'affection_exonorante','DOLIPRANE 1000 mg, comprimé','en cas de besoin',0),(12966,6694,'affection_exonorante','SYMBICORT TURBUHALER 400/12 microgrammes/dose, poudre pour inhalation','1B m et s',0),(12967,6694,'affection_exonorante','Aérosolthérapie BRICANYL m et s ','',0),(12968,6694,'affection_exonorante','Aérosolthérapie PULMICORT 1mg/éml m et s avec rinçage','',0),(12969,5898,'affection_exonorante','MIFLONIL 400 microgrammes, poudre pour inhalation en gélule','1  B m et s avec rinçage',0),(12970,5898,'affection_exonorante','SINGULAIR 10 mg, comprimé pelliculé','1 cp le s ',0),(12971,6695,'maladies_intercurrentes','BIOCIDAN 0,1 mg/0,4 ml, collyre en récipient unidose','1 gte 3 à 4 fois /J',0),(12972,6696,'maladies_intercurrentes','Radiographie thoracique','',0),(12973,6697,'affection_exonorante','DAIVONEX 50 microgrammes/gramme, crème','3 tubes',0),(12974,6697,'affection_exonorante','CYTEAL, solution moussante','2 btes',0),(12975,6697,'affection_exonorante','EFFERALGAN 1 g, comprimé effervescent','2btes',0),(12976,6697,'affection_exonorante','POLYDEXA, solution auriculaire, gouttes','1 bte',0),(12977,6697,'affection_exonorante','BISEPTINE, solution pour application locale','2 btes',0),(12978,6697,'affection_exonorante','Bande velpeau','1 bte',0),(12979,6697,'affection_exonorante','SURBRONC EXPECTORANT AMBROXOL SANS SUCRE, solution buvable édulcorée à l\'acésulfame potassique et au sorbitol','1 cuil mesure m et s 1 bte',0),(12980,6697,'affection_exonorante','ACICLOVIR ZENTIVA 5 %, crème','1 bte',0),(12981,6698,'maladies_intercurrentes','PNEUMOVAX en flacon. Vaccin pneumococcique polyosidique','1 bte',0),(12983,6699,'affection_exonorante','PNEUMOVAX en flacon. Vaccin pneumococcique polyosidique','1 bte',0),(12984,6700,'maladies_intercurrentes','NFS-Plaquettes','',0),(12985,6700,'maladies_intercurrentes','IgE Totales','',0),(12986,6701,'maladies_intercurrentes','Radiographie thoracique','',0),(12987,6701,'maladies_intercurrentes','TDM des sinus','',0),(12988,6702,'maladies_intercurrentes','SERETIDE 50 microgrammes/25 microgrammes/dose, suspension pour inhalation en flacon pressurisé','m et s avec rinçage',0),(12989,6703,'maladies_intercurrentes','NFS-Plaquettes','',0),(12990,6703,'maladies_intercurrentes','IgE totales','',0),(12991,6704,'maladies_intercurrentes','Radiographie thoracique','',0),(12992,6704,'maladies_intercurrentes','TDM des sinus','',0),(12993,6705,'maladies_intercurrentes','FORADIL 12 microgrammes, poudre pour inhalation en gélule','1 gel inh m et s ',0),(12994,6705,'maladies_intercurrentes','MIFLONIL 400 microgrammes, poudre pour inhalation en gélule','1 gel inh m et s avec rinçage',0),(12995,6705,'maladies_intercurrentes','SINGULAIR 10 mg, comprimé pelliculé','1cp le s',0),(12996,6705,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s',0),(12997,6705,'maladies_intercurrentes','RINOCLENIL 100 microgrammes/dose, suspension pour pulvérisation nasale','1 pulv ds chq narine m et s',0),(12998,6706,'maladies_intercurrentes','AUGMENTIN 1 g/125 mg ADULTES, poudre pour suspension buvable en sachet-dose (Rapport amoxicilline/acide clavulanique : 8/1)','1gX3/j pdt 7 jrs',0),(12999,6706,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule','2X2 pdt 7 jrs',0),(13000,6706,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1g/2ml m et s avec rinçage','10 jrs de traitement',0),(13001,6707,'maladies_intercurrentes','Location d','',0),(13002,6708,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','garagarisme m et s',0),(13003,6708,'maladies_intercurrentes','RINOCLENIL 100 microgrammes/dose, suspension pour pulvérisation nasale','1 pulv ds chq narine m et s',0),(13004,6709,'maladies_intercurrentes','Augmentin 1gX3/j pdt 7 jrs','',0),(13005,6709,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule','2 cp m et s pdt 7jrs',0),(13006,6709,'maladies_intercurrentes','ZITHROMAX 250 mg, comprimé pelliculé','1 cp X 3 / semaine',0),(13007,3217,'affection_exonorante','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','1 bte',0),(13008,6710,'affection_exonorante','Fortimel 1bteX3/j','',0),(13009,6711,'maladies_intercurrentes','NFS-Plaquettes','',0),(13010,6711,'maladies_intercurrentes','IgE Totales','',0),(13011,6712,'maladies_intercurrentes','Radiographie thoracique','',0),(13012,6712,'maladies_intercurrentes','TDM des sinus','',0),(13013,6713,'maladies_intercurrentes','Solupred 40 mg le m en diminuant de 5 mg tous les 2 jours en vue arret','',0),(13014,6713,'maladies_intercurrentes','Calci D3 m et s pdt la durée du Solupred','',0),(13015,6713,'maladies_intercurrentes','Inexium 20 mg le s pdt la durée du solupred','',0),(13016,6713,'maladies_intercurrentes','Symbicort Rapihaler 2 B m et s avec rinçage','',0),(13017,6714,'maladies_intercurrentes','NFS-Plaquettes','',0),(13018,6714,'maladies_intercurrentes','IgE Totales','',0),(13019,6715,'maladies_intercurrentes','Radiographie thoracique','',0),(13020,6715,'maladies_intercurrentes','TDM des sinus','',0),(13021,6717,'maladies_intercurrentes','Vaccin antigrippal','1 bte',0),(13022,6717,'maladies_intercurrentes','Symbicort Rapihaler 2 B m et s avec rinçage','',0),(13023,6717,'maladies_intercurrentes','Chambre d\'inhalation','',0),(13024,6718,'maladies_intercurrentes','ZITHROMAX 250 mg, comprimé pelliculé','1 cp X 3 /semaine',0),(13025,6718,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','1 bte',0),(13027,6719,'affection_exonorante','Location d\'un appareil d\'aérosolthérapie du 19 au 28/09/2017','',0),(13028,6720,'maladies_intercurrentes','TDM thoracique ','',0),(13030,6721,'maladies_intercurrentes','FORLAX 10 g, poudre pour solution buvable en sachet-dose','2btes',0),(13031,6721,'maladies_intercurrentes','Tube baume à lèvre AROMA','1 tube',0),(13032,6721,'maladies_intercurrentes','EFFERALGAN 500 mg, comprimé','2X2:j 3 btes ',0),(13033,6723,'maladies_intercurrentes','RINOCLENIL 100 microgrammes/dose, suspension pour pulvérisation nasale','1 pulv ds chq narine m et s ',0),(13034,6723,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(13035,6724,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule','2X2 /j pendant 7 jrs',0),(13036,6724,'maladies_intercurrentes','Augmentin 1gX3/j','2 X2 pdt 7 jrs',0),(13037,6724,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1g/2ml m et s avec rinçage','',0),(13038,6724,'maladies_intercurrentes','ROVAMYCINE 1 500 000 UI, comprimé pelliculé','3M UnitésX3/j pendant 5 jrs',0),(13039,6725,'affection_exonorante','Radiographie thoracique','',0),(13040,6726,'affection_exonorante','Location d\'un appareil d\'aérosolthérapie ','',0),(13041,6727,'maladies_intercurrentes','NFS-plaquettes','',0),(13042,6727,'maladies_intercurrentes','IgE Totales','',0),(13043,6728,'maladies_intercurrentes','Radiographie thoracique','',0),(13044,6728,'maladies_intercurrentes','TDM des sinus','',0),(13045,6729,'maladies_intercurrentes','Symbicort rapihaler 2 B  m et s avec rinçage','',0),(13046,6729,'maladies_intercurrentes','SINGULAIR 5 mg, comprimé à croquer','1 cp le s ',0),(13047,6729,'maladies_intercurrentes','Chambre d\'inhalation','',0),(13048,6730,'maladies_intercurrentes','Augmentin 1 GX3/j pdt 7 jrs','',0),(13049,6730,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule','2X2 /j pendant 7 jrs',0),(13050,6730,'maladies_intercurrentes','EFFERALGAN 1 g, comprimé effervescent 1X3/j','',0),(13051,6731,'maladies_intercurrentes','Augmentin 1gX3 /j','7 jrs de traitement',0),(13052,6731,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule 2X2 ','7 jrs de traitement',0),(13053,6731,'maladies_intercurrentes','Symbicort rapihaler 2 B X2/j','10 jrs de ttt',0),(13054,6731,'maladies_intercurrentes','EFFERALGAN 1 g, comprimé effervescent 1 X3 /j','10 jrs de ttt',0),(13055,6732,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','1cp m et s ',0),(13056,6732,'maladies_intercurrentes','GAVISCON, suspension buvable en sachet','1X3/j',0),(13057,6733,'maladies_intercurrentes','Augmentin 1g X3/j pendant 7 jrs','',0),(13058,6733,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule','2 X 2 pdt 7 jrs',0),(13059,6733,'maladies_intercurrentes','EFFERALGAN 500 mg, comprimé X2/j ','',0),(13060,6733,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s 10 jrs de ttt ',0),(13061,6733,'maladies_intercurrentes','MOTILIUM 1 mg/ml, suspension buvable','2 prises/j av les repas ',0),(13062,6734,'maladies_intercurrentes','Radiographie thoracique','',0),(13063,6735,'maladies_intercurrentes','Thyroide 7 Ch 10 granulés m et s ','',0),(13064,6735,'maladies_intercurrentes','Iodum 7 CH 5 granulés m et s ','',0),(13066,6736,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','1 bte',0),(13067,6737,'maladies_intercurrentes','TDM des sinus','',0),(13068,6738,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(13069,6738,'maladies_intercurrentes','RINOCLENIL 100 microgrammes/dose, suspension pour pulvérisation nasale','1 pulv ds chq narine m et s ',0),(13071,6739,'affection_exonorante','ZITHROMAX 250 mg, comprimé pelliculé','1cp X3/semaine',0),(13072,6740,'affection_exonorante','Location d\'un appareil d\'aérosolthérapie','',0),(13073,6741,'affection_exonorante','BUDESONIDE aérosolthérapie 1mg/2ml','m et s pdt 15 jrs avec rinçage',0),(13074,6741,'affection_exonorante','RULID 150 mg, comprimé enrobé m et s pdt 1Ojrs','',0),(13075,6742,'maladies_intercurrentes','Symbicort rapihaler 2B m et s ','rinçage',0),(13076,6742,'maladies_intercurrentes','Chambre d','',0),(13077,6742,'maladies_intercurrentes','SINGULAIR 10 mg, comprimé pelliculé','& cp le s ',0),(13078,6743,'maladies_intercurrentes','Radiographie thoracique','',0),(13079,6744,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie','',0),(13080,6745,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1mg/2ml','m et s ',0),(13081,6745,'maladies_intercurrentes','RULID 150 mg, comprimé enrobé','1cp m et s pdt è jrs',0),(13082,6745,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule 2 X2 pdt le trt par RULID','',0),(13083,6746,'affection_exonorante','Kinésiethérapie respiratoire TVD','23 séances/semaine',0),(13084,6747,'maladies_intercurrentes','IgE totales','',0),(13085,6747,'maladies_intercurrentes','NFS-Plaquettes','',0),(13086,6748,'maladies_intercurrentes','Radiographie thoracique','',0),(13087,6748,'maladies_intercurrentes','TDM des sinus','',0),(13088,6750,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(13089,6750,'maladies_intercurrentes','RINOCLENIL 100 microgrammes/dose, suspension pour pulvérisation nasale','1pulv ds chq narine m et s ',0),(13090,6724,'maladies_intercurrentes','Boire 2L d\'eau/j','',0),(13091,6751,'maladies_intercurrentes','Kinésiethérapie respiratoire centré sur l\'hemicoupole diphragmatique gauche','',0),(13092,6752,'maladies_intercurrentes','Champix 0,5 mg 1 fois/j de J1 à J3 puis 0?5 mg X2/j de J3 à J8 ','',0),(13093,6752,'maladies_intercurrentes','Champix 1g X2/j de J8 à J14.','',0),(13094,6752,'maladies_intercurrentes','Puis 1mg X2/J ','',0),(13096,6753,'maladies_intercurrentes','Relvar 1 B /j avec rinçage','',0),(13097,6753,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(13098,6754,'maladies_intercurrentes','TDM thoracique sans injection','',0),(13099,6755,'affection_exonorante','Augmentin 1 g X3 /j','',0),(13100,6755,'affection_exonorante','RULID 150 mg, comprimé enrobé 1 cp m et s ','',0),(13101,6755,'affection_exonorante','ULTRALEVURE 200 mg, gélule 2X2 ','',0),(13102,6756,'affection_exonorante','Location d\'un appareil d\'aérosolthérapie','',0),(13103,6757,'affection_exonorante','Location d\'un appareil d\'aerosolthérapie ','',0),(13104,6758,'affection_exonorante','Aérosolthérapie BRICANYL X2/j ','15 jrs de traitement',0),(13105,6758,'affection_exonorante','Aérosolthérapie BUDESONIDE 1mg/2ml m et s avec rinçage','15 jrs de traitement',0),(13106,6758,'affection_exonorante','Solupred 30 mg le m en diminuant de 5mg ts les 2 jrs en vue arret','',0),(13107,6758,'affection_exonorante','Calci D3 m et s pendant la durée de la Corticottt orale','',0),(13108,6758,'affection_exonorante','Augmentin 1gX3/j pdt 7 jrs','',0),(13109,6758,'affection_exonorante','RULID 150 mg, comprimé enrobé m et s pdt 7 jrs','',0),(13110,6758,'affection_exonorante','ULTRALEVURE 200 mg, gélule 2 X2 pdt 7 jrs','',0),(13111,6759,'maladies_intercurrentes','Relvar Ellipta 1B /j avec rinçage','3 mois de traitement',0),(13112,6759,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','1 cp le s pdt 1 mois ',0),(13113,6760,'affection_exonorante','Vaccin antigrippal 1 bte','',0),(13114,6761,'affection_exonorante','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','1 bte',0),(13115,6762,'maladies_intercurrentes','Polykaraya ','2 btes',0),(13116,6762,'maladies_intercurrentes','SPAGULAX MUCILAGE PUR, granulés en sachet dose','2 btes',0),(13117,6762,'maladies_intercurrentes','Efferalganmed eff ','1 bte',0),(13118,6763,'maladies_intercurrentes','RINOCLENIL 100 microgrammes/dose, suspension pour pulvérisation nasale','1 pulv ds chq narine m et s',0),(13120,6681,'maladies_intercurrentes','EFFERALGAN 1 g, comprimé effervescent','1X3/j',0),(13121,6681,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(13122,6765,'maladies_intercurrentes','Relvar ellipta 1 B /J ','',0),(13123,6766,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','1 bte',0),(13125,6767,'affection_exonorante','Relvar ellipta 1 B/j','',0),(13126,6768,'maladies_intercurrentes','IgE totales','',0),(13127,6769,'maladies_intercurrentes','TDM du Thorax sans injection','',0),(13128,6769,'maladies_intercurrentes','TDM des sinus','',0),(13129,6770,'maladies_intercurrentes','RINOCLENIL 100 microgrammes/dose, suspension pour pulvérisation nasale','1 pulv ds chq narine m et s ',0),(13130,6770,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(13131,6771,'maladies_intercurrentes','TDM des sinus','',0),(13132,6772,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(13133,6772,'maladies_intercurrentes','Chambre d\'inhalation ','',0),(13134,6773,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(13135,6773,'maladies_intercurrentes','Chambre d\'inhalation ','',0),(13136,6774,'affection_exonorante','Fortimel 1bteX2','',0),(13137,6775,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s pdt 15jrs',0),(13138,6775,'maladies_intercurrentes','RINOCLENIL 100 microgrammes/dose, suspension pour pulvérisation nasale','1 pulv ds chq narine m et s ',0),(13139,6775,'maladies_intercurrentes','Symbicort rapihaler 2B m et s avec rinçage','',0),(13140,6775,'maladies_intercurrentes','Chambre d','',0),(13141,6775,'maladies_intercurrentes','Surbronc sirop 1 cuil mesure m et s ','',0),(13142,6776,'maladies_intercurrentes','Radiographie thoracique','',0),(13143,6777,'maladies_intercurrentes','ECBUExamen cytobacteriologique des urines','',0),(13144,6777,'maladies_intercurrentes','Recherche de calculs','',0),(13145,6777,'maladies_intercurrentes','Cholesterol LDL,HDL','',0),(13146,6777,'maladies_intercurrentes','Ac urique uricémie','',0),(13147,6778,'maladies_intercurrentes','TDM thoracique sans injection','',0),(13148,1407,'affection_exonorante','SPIRIVA RESPIMAT 2,5 microgrammes/dose, solution pour inhalation','1 B/J',0),(13149,1407,'affection_exonorante','Solupred 40 mg le m en diminuant de 5 mg ts les 2 jrs en vue arret','',0),(13150,1407,'affection_exonorante','Calci D3 m et s pdt la durée du traitement par Solupred.','',0),(13151,1407,'affection_exonorante','Esomeprazole 20 mg le s pdt la durée du trt par SOLUPRED ','',0),(13152,6780,'maladies_intercurrentes','Symbicort Rapihaler 2B m et s avec rinçage','',0),(13153,6780,'maladies_intercurrentes','SINGULAIR 10 mg, comprimé pelliculé','1 cp le s ',0),(13154,6780,'maladies_intercurrentes','Chambre d','',0),(13155,6780,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','1 gel le s ',0),(13156,6782,'maladies_intercurrentes','Vaccin anti grippal','1bte',0),(13157,6685,'maladies_intercurrentes','Arret du BRICANYL si tachycardie et de l','',0),(13158,6685,'maladies_intercurrentes','Boire au moins 2L d','',0),(13159,6685,'maladies_intercurrentes','Symbicort Rapihaler 2B m et s à l\'aide d\'une chambre d\'inhalation','',0),(13161,6783,'affection_exonorante','Kinésiethérapie respiratoire TVD ety drainage','',0),(13162,6783,'affection_exonorante','5 séances /semaine ','',0),(13163,6784,'maladies_intercurrentes','TDM thoracique sans injection','',0),(13164,6785,'maladies_intercurrentes','Champix  1ere semaine J1 à J3 ','0,5 mg 1 fois/J',0),(13165,6785,'maladies_intercurrentes','J3 à J8 0,5 mg X2/j','',0),(13166,6785,'maladies_intercurrentes','2ème semaine J8 à J14 1 mg X2/j','',0),(13167,6785,'maladies_intercurrentes','3ème semaine à 12ème semaine:','',0),(13168,6785,'maladies_intercurrentes','1 mg X2/j ','',0),(13169,6786,'maladies_intercurrentes','ZITHROMAX 250 mg, comprimé pelliculé','1 cp X3 / semaine',0),(13170,6786,'maladies_intercurrentes','LAROSCORBINE 1 g, comprimé effervescent','1 cp le m',0),(13171,6787,'maladies_intercurrentes','Kinésiethérapie de l\'épaule gauche avec electrostimulation ','3 séances / semaine',0),(13172,6788,'maladies_intercurrentes','Relvar ellipta 1 B/j','',0),(13173,6788,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(13174,6789,'maladies_intercurrentes','FORADIL 12 microgrammes, poudre pour inhalation en gélule','1 gel inh m et s ',0),(13175,6789,'maladies_intercurrentes','MIFLONIL 400 microgrammes, poudre pour inhalation en gélule','1 gel inh m et s avec rinçage',0),(13176,6790,'maladies_intercurrentes','Bas de contention non allergisant','',0),(13177,6791,'maladies_intercurrentes','Location d\'aérosolthérapie ','',0),(13178,6792,'maladies_intercurrentes','Spiolto 2 b consécutives','',0),(13179,6792,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(13180,6792,'maladies_intercurrentes','Pulmicort  aérosolthérapie 1 mg/2ml','m et s avec rinçage',0),(13181,6793,'maladies_intercurrentes','','',0),(13182,6794,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(13183,6794,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(13184,6794,'maladies_intercurrentes','Chambre d\'inhalation','',0),(13185,6795,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS FRANCE 40 mg, comprimé gastro-résistant','m et s ',0),(13186,6795,'maladies_intercurrentes','Gaviscon 1 sachet X3 j ','',0),(13187,6796,'maladies_intercurrentes','Boire au moins 1L 500 d','',0),(13188,6796,'maladies_intercurrentes','Paroex gargarisme m et s pdt 10jrs','',0),(13189,6796,'maladies_intercurrentes','RINOCLENIL 100 microgrammes/dose, suspension pour pulvérisation nasale','& pulv ds chq narine m et S pdt 10jrs',0),(13190,6796,'maladies_intercurrentes','Si fièvre reprenait Ou persistance d\'une toux avec expactoration sales ','augmentin 1gX3:j pdt 7 jrs.',0),(13191,6797,'maladies_intercurrentes','Aérosolthérapie BICARBONATE 14p Mille m et s ','',0),(13192,6797,'maladies_intercurrentes','AUGMENTIN 1 g/125 mg ADULTES, poudre pour suspension buvable en sachet-dose (Rapport amoxicilline/acide clavulanique : 8/1)','1 g X3 pdt 7 jrs',0),(13193,6797,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule 2 X2 pdt 7 jrs','',0),(13194,6797,'maladies_intercurrentes','Symbicort Rapihaler 2 B m et s avec rinçage ','2 semaines de traitement',0),(13195,6797,'maladies_intercurrentes','Chambre d\'inhalation','',0),(13196,6799,'maladies_intercurrentes','Kinésiethérapie respiratoire TVD et drainage','3 séances/ semaine',0),(13197,6800,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','m et s',0),(13198,6800,'maladies_intercurrentes','GAVISCON, suspension buvable en sachet','1X\"/j',0),(13199,6801,'maladies_intercurrentes','Radiographie de l','',0),(13200,6801,'maladies_intercurrentes','Echographie de l\'épaule gauche','',0),(13201,6802,'affection_exonorante','Location d\'une appareil d\'aérosolthérapie','',0),(13202,6803,'maladies_intercurrentes','TDM des sinus','',0),(13203,6804,'maladies_intercurrentes','NFS- Plaquettes','',0),(13204,6804,'maladies_intercurrentes','IgE Totales','',0),(13205,6804,'maladies_intercurrentes','ANCA','',0),(13206,6804,'maladies_intercurrentes','Anticorps anti nucléaires','',0),(13207,6805,'maladies_intercurrentes','Symbicort Rapihaler 2 B m et s avec  rinçage','',0),(13208,6792,'maladies_intercurrentes','Inexium 40 mg m et s ','',0),(13209,6792,'maladies_intercurrentes','Gaviscon 1 sachet m et s ','',0),(13210,6807,'maladies_intercurrentes','SPIOLTO 2B CONSÉCUTIVES','',0),(13211,6807,'maladies_intercurrentes','Relvar 1 B /j avec rinçage','',0),(13212,6808,'maladies_intercurrentes','Symbicort Rapihaler 2B m et s avec rinçage','pihaler',0),(13213,6808,'maladies_intercurrentes','Chambre d\'inhalation','',0),(13214,6808,'maladies_intercurrentes','QSP 2 mois de traitement','',0),(13215,6808,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1mg/2ml m et s avec rinçage','',0),(13221,6809,'affection_exonorante','Location d\'un appareil d\'aérsolthérapie ','',0),(13222,6810,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie','',0),(13223,6811,'maladies_intercurrentes','Aérosolthérapie BRICANYL-ATROVENT X2/j','',0),(13224,6811,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1mg/2ml m et s avec rinçage','',0),(13226,6812,'maladies_intercurrentes','Augmentin 1g X3/j pdt 7 jrs','',0),(13227,6812,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule','2X2 /j pdt 7 jrs',0),(13228,6812,'maladies_intercurrentes','Aérosolthérpapie BRICANYL X 2  /j ','arret si tachycardie',0),(13229,6812,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1mg/2ml m et s avec rinçage','',0),(13230,6813,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie','',0),(13231,6814,'affection_exonorante','Radiographie thoracique','',0),(13232,6815,'affection_exonorante','SOTALOL ZENTIVA 80 mg, comprimé sécable','1cp le m ',0),(13233,6815,'affection_exonorante','EFFERALGAN 500 mg, comprimé','3 btes',0),(13234,6815,'affection_exonorante','SPAGULAX MUCILAGE PUR, granulés en sachet dose','',0),(13235,6816,'affection_exonorante','Location d\'un appareil d\'aérosolthérapie','',0),(13236,6817,'affection_exonorante','Aérosolthérapie BUDESONIDE 1mg/2ml m et s avec rinçage','',0),(13237,6818,'maladies_intercurrentes','TDM thoracique sans injection','',0),(13238,6819,'maladies_intercurrentes','Kinésiethérapie des M.I. ','\" séances/ semaine',0),(13239,6820,'maladies_intercurrentes','NIFLUGEL 2,5 %, gel','1 bte',0),(13240,6821,'maladies_intercurrentes','NFS -Plaquettes','',0),(13241,6821,'maladies_intercurrentes','Reticulocytes','',0),(13242,6821,'maladies_intercurrentes','Ferritinémie','',0),(13243,6822,'maladies_intercurrentes','INEXIUM 40 mg, poudre pour solution injectable ou pour perfusion','injection IV lente sur 3 à 4 minutes ou en perfusion IV sur 10 à 30 minutes 1 fois/jour',0),(13244,6822,'maladies_intercurrentes','Nécessaire pour perfusion IV lente','',0),(13245,6823,'maladies_intercurrentes','INEXIUM 40 mg, comprimé gastro-résistant','1cp/ j ',1),(13246,6824,'maladies_intercurrentes','TDM thoracique avec injection ','',0),(13247,6825,'maladies_intercurrentes','TRAMADOL ZENTIVA LP 50 mg, comprimé à libération prolongée','2 btes',0),(13248,6825,'maladies_intercurrentes','DOLIPRANE 1000 mg, gélule','4 btes',0),(13249,6825,'maladies_intercurrentes','THIOCOLCHICOSIDE ZENTIVA 4 mg, comprimé','2 btes',0),(13250,6826,'maladies_intercurrentes','Radiographie thoracique','',0),(13251,6826,'maladies_intercurrentes','TDM des sinus','',0),(13252,6827,'maladies_intercurrentes','NFS-Plaquettes','',0),(13253,6827,'maladies_intercurrentes','IgE totales','',0),(13254,6828,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(13255,6828,'maladies_intercurrentes','Chambre d','',0),(13256,6828,'maladies_intercurrentes','Budesonide 1mg/2ml aérosolthérapie m et s avec rinçage','',0),(13257,6829,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie','',0),(13258,6830,'maladies_intercurrentes','GDS à AA','',0),(13259,6831,'maladies_intercurrentes','TDM des sinus','',0),(13260,6832,'affection_exonorante','Kinésiethérapie respiratoire TVD 1 fois /j sauf Week ends.','',0),(13261,6833,'maladies_intercurrentes','RINOCLENIL 100 microgrammes/dose, suspension pour pulvérisation nasale','1pulv ds chq narine m et s ',0),(13262,6833,'maladies_intercurrentes','SINGULAIR 10 mg, comprimé pelliculé','1 cp le s ',0),(13263,6834,'maladies_intercurrentes','Radiographie thoracique','',0),(13264,6834,'maladies_intercurrentes','TDM des sinus','',0),(13265,6835,'maladies_intercurrentes','NFS - Plaquettes','',0),(13266,6835,'maladies_intercurrentes','IgE totales','',0),(13267,6836,'maladies_intercurrentes','Relvar 1 B/j','3 btes',0),(13268,6837,'maladies_intercurrentes','Bains de pied m et s pdt 15 mns de Permanganate de potassium :KMnO4 ','',0),(13269,6837,'maladies_intercurrentes','Après lavage du pied à l\'eau chaude ','',0),(13270,6838,'maladies_intercurrentes','Augmentin 1gX/j pdt 7jrs','',0),(13271,6838,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule','2X2 pdt 7 jrs',0),(13272,6838,'maladies_intercurrentes','Ultibro 1 B/j','',0),(13273,6839,'maladies_intercurrentes','Jet dentaire appareil','appareil',0),(13274,6839,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','3 btes',0),(13275,6840,'maladies_intercurrentes','SPAGULAX MUCILAGE PUR, granulés en sachet dose','1 sachet/j 1 bte',0),(13276,6841,'maladies_intercurrentes','Spiolto 2 b consécutives','',0),(13277,6841,'maladies_intercurrentes','Symbicort Rapihaler 2 B m et s abvec rinçage','',0),(13278,6841,'maladies_intercurrentes','Chambre d\'inhalation','',0),(13279,5108,'maladies_intercurrentes','Ventoline 2 B en cas de besoin','',0),(13280,6842,'maladies_intercurrentes','SERETIDE DISKUS 500 microgrammes/50 microgrammes/dose, poudre pour inhalation en récipient unidose','1 bte',0),(13281,6842,'maladies_intercurrentes','SERETIDE 250 microgrammes/25 microgrammes/dose, suspension pour inhalation en flacon pressurisé','1 bte',0),(13282,6842,'maladies_intercurrentes','Chambre d','',0),(13283,6842,'maladies_intercurrentes','DOLIPRANE 1000 mg, comprimé','3 btes',0),(13285,6843,'affection_exonorante','Hemoglobine glyqué HBA1C','',0),(13286,6843,'affection_exonorante','Glycémie à jeun ','',0),(13287,6249,'affection_exonorante','Aérosolthérapie bicarbonate 14 p .mille m et s avant kinésiethérapie','',0),(13288,6844,'affection_exonorante','Kinésiethérapie respiratoire m et s pdt 10 jrs y compris W.ends et jrs feriés','',0),(13289,6845,'maladies_intercurrentes','Echographie des voies urinnaires (vesico-rénale).','',0),(13290,6846,'maladies_intercurrentes','Creatinine/urée','',0),(13291,6846,'maladies_intercurrentes','NFS-Plaquettes','',0),(13292,6846,'maladies_intercurrentes','Bilan d','',0),(13293,6846,'maladies_intercurrentes','Taux de prothrombine','',0),(13295,6847,'maladies_intercurrentes','EFFERALGAN 1 g, comprimé effervescent','2 btes 1gX3 /j',0),(13296,6847,'maladies_intercurrentes','VENTOLINE 100 microgrammes/dose, suspension pour inhalation en flacon pressurisé','3 btes 2 B   et s',0);

--
-- 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'),('email','bmtanguy@gmail.com',''),('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',''),('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'),('lieu_cv_1','49, allée des Topazes','Lieu'),('lieu_cv_2','97400 Saint-Denis','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','Ligne 1'),('qualite_ligne_2','Ancien chef de Service au CHU de BellePierre','Ligne 2'),('qualite_ligne_3','Médecin Honoraire des Hôpitaux','Ligne 3'),('qualite_ligne_cv_1','Pneumologue','Ligne 1 Carte Visite'),('qualite_ligne_cv_2','Médaille d\'Argent de l\'Académie Nationale de Médecine','Ligne 2 Carte Visite'),('qualite_ligne_cv_3','Ancien chef de Service au CHU de BellePierre','Ligne 3 Carte Visite'),('qualite_ligne_cv_4','Médecin Honoraire des Hôpitaux','Ligne 4 Carte Visite'),('qualite_ligne_cv_5','Membre de la Société de Pneumologie de Langue Française','Ligne 5 Carte Visite'),('qualite_ligne_cv_6','Membre de l\'European Respiratory Society','Ligne 6 Carte Visite'),('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_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=215 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'),(209,1,'','2017-11-16 08:00:00','2017-08-17 17:30:00'),(210,1,'congrès Bordeaux','2017-11-16 08:00:00','2017-08-17 17:30: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');

--
-- 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 mercredi matin','2017-04-07','2012-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_agenda`
--

CREATE TABLE `personnel_services_agenda` (
  `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_agenda_ibfk_2` FOREIGN KEY (`id_personnel`) REFERENCES `personnel` (`id_personnel`) ON UPDATE CASCADE,
  CONSTRAINT `personnel_services_agenda_ibfk_3` FOREIGN KEY (`id_service`) REFERENCES `services` (`id_service`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `personnel_services_agenda`
--

INSERT INTO `personnel_services_agenda` 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,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=21 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'),(13,5,'Parametres','/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,'Services / Menus','/cabinet/admin/menus/index.php'),(20,7,'Base de données','/cabinet/admin/base_de_donnee/index.php');

--
-- 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=11 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,18,'Info sur le système','/cabinet/admin/monitoring/info_systeme/index.php','display_all_config_value=0',''),(4,18,'Log erreurs','/cabinet/admin/monitoring/error_log/index.php','',''),(5,18,'Erreurs SQL','/cabinet/admin/monitoring/sql_error_log/index.php','',''),(6,18,'Erreur num lignes SQL','/cabinet/admin/monitoring/sql_numrows_log/index.php','',''),(7,18,'Log PHP','/cabinet/admin/monitoring/php_errors/index.php','',''),(8,18,'Log apache','/cabinet/admin/monitoring/apache_errors/index.php','',''),(9,18,'Log authentification','/cabinet/admin/monitoring/authentification_log/index.php','',''),(10,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');


