Go to most recent revision | Blame | Last modification | View Log | RSS feed
# phpMyAdmin SQL Dump# version 2.5.6# http://www.phpmyadmin.net## Serveur: localhost# Généré le : Mardi 22 Février 2005 à 10:37# Version du serveur: 4.1.9# Version de PHP: 4.3.10## Base de données: `gestion_test_v3`## --------------------------------------------------------## Structure de la table `gestion_absence`#CREATE TABLE `gestion_absence` (`gu_id_utilisateur` int(10) unsigned NOT NULL default '0',`gma_id_motif` tinyint(3) unsigned NOT NULL default '0',`ga_date_debut` date NOT NULL default '0000-00-00',`ga_date_fin` date NOT NULL default '0000-00-00',`ga_date_envoi_lettre` date NOT NULL default '0000-00-00',PRIMARY KEY (`gu_id_utilisateur`,`gma_id_motif`,`ga_date_debut`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;## Contenu de la table `gestion_absence`#INSERT INTO `gestion_absence` VALUES (2, 0, '2003-01-02', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 0, '2003-01-03', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 0, '2003-04-23', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 0, '2003-04-24', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-11', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-12', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-13', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-14', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-18', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-19', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-20', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-21', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-22', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-25', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-26', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-27', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-28', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-29', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 1, '2003-05-02', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 1, '2003-05-09', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 1, '2003-05-30', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 1, '2003-07-28', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 4, '2003-01-01', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 4, '2003-04-21', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 4, '2003-05-01', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 4, '2003-05-08', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 4, '2003-05-29', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 4, '2003-07-14', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (2, 4, '2003-08-15', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-01-01', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-01-02', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-01-03', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-04-11', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-04-12', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-04-13', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-04-14', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-04-15', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-04-16', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-04-17', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-04-18', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-16', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-17', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-18', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-21', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-22', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-23', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-24', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-25', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-27', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-28', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-29', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-30', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-31', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-08-01', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-08-04', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-08-05', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-08-06', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-08-07', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-08-08', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 0, '2003-08-11', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 1, '2003-05-02', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 1, '2003-05-09', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 1, '2003-06-06', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 1, '2003-08-12', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 1, '2003-08-13', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 1, '2003-08-14', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 4, '2003-04-21', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 4, '2003-05-01', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 4, '2003-05-08', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 4, '2003-05-29', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 4, '2003-06-09', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 4, '2003-07-14', '0000-00-00', '0000-00-00');INSERT INTO `gestion_absence` VALUES (3, 4, '2003-08-15', '0000-00-00', '0000-00-00');# --------------------------------------------------------## Structure de la table `gestion_categorie`#CREATE TABLE `gestion_categorie` (`gc_id_categorie` int(10) unsigned NOT NULL default '0',`gc_libelle_categorie` varchar(255) default NULL,PRIMARY KEY (`gc_id_categorie`),UNIQUE KEY `gc_libelle_categorie` (`gc_libelle_categorie`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;## Contenu de la table `gestion_categorie`#INSERT INTO `gestion_categorie` VALUES (5, 'Projets inclus convention MEDT');INSERT INTO `gestion_categorie` VALUES (2, 'Fonctionnement interne');INSERT INTO `gestion_categorie` VALUES (3, 'Site internet et outils coopératif');INSERT INTO `gestion_categorie` VALUES (4, 'Animation');INSERT INTO `gestion_categorie` VALUES (6, 'Projet hors convention');INSERT INTO `gestion_categorie` VALUES (7, 'Services pour des tiers');# --------------------------------------------------------## Structure de la table `gestion_composer_utilisateur_frais_kilometrique`#CREATE TABLE `gestion_composer_utilisateur_frais_kilometrique` (`gcufk_id_frais_kilometrique` int(10) unsigned NOT NULL default '0',`gcufk_id_utilisateur` int(10) unsigned NOT NULL default '0',`gcufk_date_frais` date NOT NULL default '0000-00-00',`gcufk_nb_kilometre` float default NULL,`gcufk_objet` varchar(255) default NULL,`gcufk_trajet` varchar(255) default NULL,`gcufk_montant_total` float NOT NULL default '0',PRIMARY KEY (`gcufk_id_frais_kilometrique`,`gcufk_id_utilisateur`,`gcufk_date_frais`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;## Contenu de la table `gestion_composer_utilisateur_frais_kilometrique`## --------------------------------------------------------## Structure de la table `gestion_depense`#CREATE TABLE `gestion_depense` (`gu_id_utilisateur` int(10) unsigned NOT NULL default '0',`gnf_id_frais` int(10) unsigned NOT NULL default '0',`gd_date_depense` date NOT NULL default '0000-00-00',`gd_montant_ht` float default NULL,`gd_montant_ttc` float NOT NULL default '0',PRIMARY KEY (`gu_id_utilisateur`,`gnf_id_frais`,`gd_date_depense`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;## Contenu de la table `gestion_depense`## --------------------------------------------------------## Structure de la table `gestion_frais_kilometrique`#CREATE TABLE `gestion_frais_kilometrique` (`gfk_id_frais_kilometrique` int(10) unsigned NOT NULL default '0',`gfk_taux_kilometre` float NOT NULL default '0',PRIMARY KEY (`gfk_id_frais_kilometrique`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;## Contenu de la table `gestion_frais_kilometrique`## --------------------------------------------------------## Structure de la table `gestion_motif_absence`#CREATE TABLE `gestion_motif_absence` (`gma_id_motif` tinyint(3) unsigned NOT NULL default '0',`gma_libelle_motif` varchar(255) NOT NULL default '',`gma_nb_heures_supprim` float default NULL,`gma_type_rtt` char(1) NOT NULL default '',PRIMARY KEY (`gma_id_motif`),UNIQUE KEY `gma_libelle_motif` (`gma_libelle_motif`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;## Contenu de la table `gestion_motif_absence`#INSERT INTO `gestion_motif_absence` VALUES (0, 'Congés Payés', '1', '0');INSERT INTO `gestion_motif_absence` VALUES (1, 'Récupération', '1', '1');INSERT INTO `gestion_motif_absence` VALUES (2, 'Maladie', '1', '0');INSERT INTO `gestion_motif_absence` VALUES (3, 'Grêve', '1', '1');INSERT INTO `gestion_motif_absence` VALUES (4, 'Ferié', '1', '0');INSERT INTO `gestion_motif_absence` VALUES (5, 'Récup part:1/2j', '0.5', '0');# --------------------------------------------------------## Structure de la table `gestion_note_frais`#CREATE TABLE `gestion_note_frais` (`gnf_id_frais` int(10) unsigned NOT NULL default '0',`gnf_libelle_frais` varchar(255) NOT NULL default '',PRIMARY KEY (`gnf_id_frais`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;## Contenu de la table `gestion_note_frais`## --------------------------------------------------------## Structure de la table `gestion_predecesseurs`#CREATE TABLE `gestion_predecesseurs` (`gt_id_tache` int(10) unsigned NOT NULL default '0',`gpred_id_pred` int(10) unsigned NOT NULL default '0',PRIMARY KEY (`gt_id_tache`,`gpred_id_pred`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;## Contenu de la table `gestion_predecesseurs`## --------------------------------------------------------## Structure de la table `gestion_preferences`#CREATE TABLE `gestion_preferences` (`gu_id_utilisateur` int(10) unsigned NOT NULL default '0',`gp_id_projet` int(10) unsigned NOT NULL default '0',PRIMARY KEY (`gu_id_utilisateur`,`gp_id_projet`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;## Contenu de la table `gestion_preferences`#INSERT INTO `gestion_preferences` VALUES (7, 10);INSERT INTO `gestion_preferences` VALUES (7, 15);# --------------------------------------------------------## Structure de la table `gestion_prevision_tache`#CREATE TABLE `gestion_prevision_tache` (`gu_id_utilisateur` int(10) unsigned NOT NULL default '0',`gt_id_tache` int(10) unsigned NOT NULL default '0',`gpt_date_prevision` date NOT NULL default '0000-00-00',`gpt_duree_prevision` float NOT NULL default '0',PRIMARY KEY (`gu_id_utilisateur`,`gt_id_tache`,`gpt_date_prevision`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;## Contenu de la table `gestion_prevision_tache`## --------------------------------------------------------## Structure de la table `gestion_projet`#CREATE TABLE `gestion_projet` (`gp_id_projet` int(10) unsigned NOT NULL default '0',`gc_id_categorie` int(10) unsigned NOT NULL default '0',`gp_nom_projet` varchar(255) NOT NULL default '',`gp_description` varchar(255) default NULL,`gp_date_debut` date default NULL,`gp_duree_prevue` float default NULL,`gp_avancement` int(11) default NULL,PRIMARY KEY (`gp_id_projet`),UNIQUE KEY `gp_nom_projet` (`gp_nom_projet`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;## Contenu de la table `gestion_projet`#INSERT INTO `gestion_projet` VALUES (11, 2, 'Comptablilité', '', NULL, NULL, NULL);INSERT INTO `gestion_projet` VALUES (9, 2, 'Formation stagiaire', '', NULL, NULL, NULL);INSERT INTO `gestion_projet` VALUES (10, 2, 'Gestion interne', '', NULL, NULL, NULL);INSERT INTO `gestion_projet` VALUES (3, 6, 'Base de données nomenclaturale', '', NULL, NULL, NULL);INSERT INTO `gestion_projet` VALUES (4, 6, 'Index des bryophytes', '', NULL, NULL, NULL);INSERT INTO `gestion_projet` VALUES (5, 6, 'Index des plantes de la Réunion', '', NULL, NULL, NULL);INSERT INTO `gestion_projet` VALUES (6, 6, 'Plantes envahissantes', '', NULL, NULL, NULL);INSERT INTO `gestion_projet` VALUES (7, 7, 'Projet FEEE planetere', '', NULL, NULL, NULL);INSERT INTO `gestion_projet` VALUES (8, 7, 'projet FEEE - YRE', '', NULL, NULL, NULL);INSERT INTO `gestion_projet` VALUES (12, 2, 'Déplacement', '', NULL, NULL, NULL);INSERT INTO `gestion_projet` VALUES (13, 2, 'Formation', '', NULL, NULL, NULL);INSERT INTO `gestion_projet` VALUES (14, 2, 'Autres', '', NULL, NULL, NULL);INSERT INTO `gestion_projet` VALUES (15, 3, 'Développement', '', NULL, NULL, NULL);INSERT INTO `gestion_projet` VALUES (16, 3, 'Contenu du site', '', NULL, NULL, NULL);INSERT INTO `gestion_projet` VALUES (17, 3, 'Autre', '', NULL, NULL, NULL);INSERT INTO `gestion_projet` VALUES (18, 5, 'Flore éléctronique', '', NULL, NULL, NULL);INSERT INTO `gestion_projet` VALUES (19, 5, 'Apprendre la botanique sur internet', '', NULL, NULL, NULL);INSERT INTO `gestion_projet` VALUES (20, 6, 'Inventaire des herbiers de France', '', NULL, NULL, NULL);INSERT INTO `gestion_projet` VALUES (21, 3, 'Maintenance informatique', '', NULL, NULL, NULL);INSERT INTO `gestion_projet` VALUES (22, 4, 'Animation adhérent', '', NULL, NULL, NULL);INSERT INTO `gestion_projet` VALUES (23, 5, 'Phytochorologie', 'Base de données sur la répartition départementale de la flore métropolitaine.', NULL, NULL, NULL);INSERT INTO `gestion_projet` VALUES (24, 5, 'Base de données biblio et annuaire', 'Biblio Libra et associations, index des taxons du monde des plantes.', NULL, NULL, NULL);# --------------------------------------------------------## Structure de la table `gestion_statut`#CREATE TABLE `gestion_statut` (`gs_id_statut` tinyint(3) unsigned NOT NULL default '0',`gs_libelle_statut` varchar(255) NOT NULL default '',PRIMARY KEY (`gs_id_statut`),UNIQUE KEY `gs_libelle_statut` (`gs_libelle_statut`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;## Contenu de la table `gestion_statut`#INSERT INTO `gestion_statut` VALUES (0, 'Stagiaire');INSERT INTO `gestion_statut` VALUES (1, 'Salarié');INSERT INTO `gestion_statut` VALUES (2, 'Président');# --------------------------------------------------------## Structure de la table `gestion_taches`#CREATE TABLE `gestion_taches` (`gt_id_tache` int(10) unsigned NOT NULL default '0',`gp_id_projet` int(10) unsigned NOT NULL default '0',`gt_nom_tache` varchar(255) NOT NULL default '',`gt_description_tache` varchar(255) default NULL,`gt_date_debut_tache` date default NULL,`gt_duree_prevue` int(10) unsigned default NULL,`gt_avancement` int(11) default NULL,`gt_duree_reelle_tache` int(11) default NULL,PRIMARY KEY (`gt_id_tache`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;## Contenu de la table `gestion_taches`#INSERT INTO `gestion_taches` VALUES (1, 10, 'général', NULL, NULL, NULL, NULL, NULL);INSERT INTO `gestion_taches` VALUES (2, 15, 'général', NULL, NULL, NULL, NULL, NULL);# --------------------------------------------------------## Structure de la table `gestion_travail`#CREATE TABLE `gestion_travail` (`gt_id_tache` int(10) unsigned NOT NULL default '0',`gu_id_utilisateur` int(10) unsigned NOT NULL default '0',`gt_date_travail` date NOT NULL default '0000-00-00',`gt_duree_travail` float NOT NULL default '0',PRIMARY KEY (`gt_id_tache`,`gu_id_utilisateur`,`gt_date_travail`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;## Contenu de la table `gestion_travail`#INSERT INTO `gestion_travail` VALUES (14, 3, '2003-04-23', '3');INSERT INTO `gestion_travail` VALUES (18, 3, '2003-04-23', '3.75');INSERT INTO `gestion_travail` VALUES (22, 3, '2003-04-23', '1');INSERT INTO `gestion_travail` VALUES (18, 3, '2003-04-24', '7');INSERT INTO `gestion_travail` VALUES (22, 3, '2003-04-24', '1');INSERT INTO `gestion_travail` VALUES (18, 3, '2003-04-25', '3.75');INSERT INTO `gestion_travail` VALUES (22, 3, '2003-04-25', '0.75');INSERT INTO `gestion_travail` VALUES (25, 3, '2003-04-25', '2.75');INSERT INTO `gestion_travail` VALUES (18, 3, '2003-04-28', '6.5');# --------------------------------------------------------## Structure de la table `gestion_utilisateur`#CREATE TABLE `gestion_utilisateur` (`gu_id_utilisateur` int(10) unsigned NOT NULL default '0',`gs_id_statut` tinyint(3) unsigned NOT NULL default '0',`gu_nom` varchar(255) NOT NULL default '',`gu_prenom` varchar(255) NOT NULL default '',`gu_password` varchar(255) NOT NULL default '',`gu_email` varchar(255) NOT NULL default '',`gu_telephone` int(10) unsigned default NULL,`gu_adresse` varchar(255) default NULL,`gu_code_postal` int(10) unsigned default NULL,`gu_ville` varchar(255) default NULL,`gu_quota_heures_supp` float default NULL,`gu_conges_payes` float default NULL,`gu_temps_de_travail` float default NULL,`gu_admin` tinyint(3) unsigned default NULL,`gu_admin2` tinyint(3) unsigned default NULL,`gu_notes` varchar(255) default NULL,PRIMARY KEY (`gu_id_utilisateur`),UNIQUE KEY `gu_email` (`gu_email`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;## Contenu de la table `gestion_utilisateur`#INSERT INTO `gestion_utilisateur` VALUES (1, 0, 'Bannier', 'Dorian', 'f49f9fa1fc5f1e549d4af6e9fb953922', 'dbannier@aol.com', 6, 'App 86C Résidence de Bissy, Route de Ganges', 34, 'MONTPELLIER', '13', '42', '7', 1, 1, 'A réalisée cette application');INSERT INTO `gestion_utilisateur` VALUES (0, 2, 'Mathieu', 'Daniel', '4aad7a31ef189458ce3f8d87ec973bfb', 'd.math@wanadoo.fr', 6, '26, avenue St Jean', 84, 'AVIGNON', '0', '15.5', '0', 1, 1, NULL);INSERT INTO `gestion_utilisateur` VALUES (2, 1, 'Granier', 'Alexandre', '4a7d1ed414474e4033ac29ccb8653d9b', 'alexandre@tela-botanica.org', 4, '300, rue Buffon', 34, 'MONTPELLIER', '13.74', '13.5', '7', 1, 0, '');INSERT INTO `gestion_utilisateur` VALUES (3, 1, 'Milcent', 'Jean-Pascal', 'bb3a0c91229a891187492444c5760e2b', 'jpm@tela-botanica.org', 6, '3, rue du Wineck', 68, 'COLMAR', '54.75', '22', '7', 1, 0, NULL);INSERT INTO `gestion_utilisateur` VALUES (6, 0, 'Guillot', 'Marie', '5d41402abc4b2a76b9719d911017c592', 'marie@tela-botanica.org', 467663248, '29 ter rue du plan de l\'Olivier', 0, 'montpellier', '-66', '6.5', '7', 0, 0, NULL);INSERT INTO `gestion_utilisateur` VALUES (4, 1, 'Le Bourg', 'Tamara', '202cb962ac59075b964b07152d234b70', 'tamara@tela-botanica.org', 4, '13, square Murillo', 34070, 'Montpellier', '15.02', '19.5', '7', 1, 0, NULL);INSERT INTO `gestion_utilisateur` VALUES (5, 1, 'BOURDEL', 'Stéphanie', '405aaff66082ffe7231d7c1f79926c17', 'stephanie@tela-botanica.org', 6, 'Marivaux bât A pte 13 / 42 av. Pic St Loup', 0, 'Montpellier', '-1288.5', '20.5', '7', 1, 0, 'Remplacement Tamara pendant son congé maternité + congé parental.');INSERT INTO `gestion_utilisateur` VALUES (7, 0, 'Abdool Raheem', 'Shaheen', '6142a777667a67d568f674931389f0d9', 'shaheen@tela-botanica.org', 0, '--', 0, 'montpellier', '44', '3', '0', 0, 0, NULL);