WebSVN – Applications.gtt – Diff – /trunk/documentation/gtt_v4.sql

 -- phpMyAdmin SQL Dump
--- version 2.7.0-pl2
+-- version 2.6.4-pl3
 -- http://www.phpmyadmin.net
 --
 -- Serveur: localhost
--- Généré le : Lundi 24 Juillet 2006 à 15:12
+-- Généré le : Mercredi 26 Juillet 2006 à 20:26
--- Version du serveur: 5.0.18
+-- Version du serveur: 5.0.15
--- Version de PHP: 5.1.1
+-- Version de PHP: 5.0.5
 --
 -- Base de données: `gestion_v4`
 --
 -- --------------------------------------------------------
 --
 -- Structure de la table `gestion_absence`
 --
 CREATE TABLE `gestion_absence` (
   `ga_id_utilisateur` int(11) unsigned NOT NULL,
   `ga_id_absence_motif` tinyint(3) unsigned NOT NULL,
   `ga_id_date_absence` date NOT NULL default '0000-00-00',
   `ga_duree` float NOT NULL default '0',
-  PRIMARY KEY  (`ga_id_utilisateur`)
+  PRIMARY KEY  (`ga_id_utilisateur`,`ga_id_absence_motif`,`ga_id_date_absence`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+--
+-- Contenu de la table `gestion_absence`
+--
---
+INSERT INTO `gestion_absence` VALUES (3, 1, '2006-07-25', 3);
--- Contenu de la table `gestion_absence`
+INSERT INTO `gestion_absence` VALUES (3, 2, '2006-07-25', 2);
---
+INSERT INTO `gestion_absence` VALUES (3, 3, '2006-07-26', 3);
 INSERT INTO `gestion_absence` VALUES (3, 4, '2006-07-26', 3);
 -- --------------------------------------------------------
 --
 -- Structure de la table `gestion_absence_motif`
 --
 CREATE TABLE `gestion_absence_motif` (
   `gam_id_absence_motif` tinyint(3) unsigned NOT NULL,
   `gam_libelle` varchar(255) collate utf8_unicode_ci NOT NULL,
   PRIMARY KEY  (`gam_id_absence_motif`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+--
+-- Contenu de la table `gestion_absence_motif`
 --
--- Contenu de la table `gestion_absence_motif`
---
+INSERT INTO `gestion_absence_motif` VALUES (1, 'Congés payés');
 INSERT INTO `gestion_absence_motif` VALUES (2, 'Récupération');
-INSERT INTO `gestion_absence_motif` VALUES (1, 'Congés payés');
+INSERT INTO `gestion_absence_motif` VALUES (3, 'Grêve');
-INSERT INTO `gestion_absence_motif` VALUES (2, 'Récupération');
+INSERT INTO `gestion_absence_motif` VALUES (4, 'Maladie');
   `gfk_trajet` varchar(255) collate utf8_unicode_ci default NULL,
   `gfk_montant_total` float NOT NULL,
   PRIMARY KEY  (`gfk_id_frais_km`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 --
 -- Contenu de la table `gestion_frais_km`
 --
 -- --------------------------------------------------------
 --
 -- Structure de la table `gestion_frais_km_taux`
 --
 CREATE TABLE `gestion_frais_km_taux` (
   `gfkt_id_frais_km_taux` int(11) unsigned NOT NULL,
   `gfkt_taux` float NOT NULL,
   PRIMARY KEY  (`gfkt_id_frais_km_taux`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 --
 -- Contenu de la table `gestion_frais_km_taux`
 --
 -- --------------------------------------------------------
 --
 -- Structure de la table `gestion_note_frais`
 --
 CREATE TABLE `gestion_note_frais` (
   `gnf_id_note_frais` int(11) unsigned NOT NULL,
   `gnf_ce_utilisateur` int(11) unsigned NOT NULL,
   `gnf_libelle` varchar(255) collate utf8_unicode_ci NOT NULL,
   PRIMARY KEY  (`gnf_id_note_frais`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
   `gnfl_taux_tva` float default NULL,
   `gnfl_montant_ttc` float NOT NULL,
   PRIMARY KEY  (`gnfl_id_note_frais_ligne`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 --
 -- Contenu de la table `gestion_note_frais_ligne`
 --
 -- --------------------------------------------------------
 --
 -- Structure de la table `gestion_projet`
 --
   `gp_duree_prevue` float default NULL,
   `gp_avancement` int(11) default NULL,
   PRIMARY KEY  (`gp_id_projet`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 --
 -- Contenu de la table `gestion_projet`
 --
 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 (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_projet_categorie`
 --
 CREATE TABLE `gestion_projet_categorie` (
   `gpc_id_categorie` int(11) unsigned NOT NULL,
   `gpc_libelle` varchar(255) collate utf8_unicode_ci NOT NULL,
   PRIMARY KEY  (`gpc_id_categorie`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 --
 -- Contenu de la table `gestion_projet_categorie`
 --
 INSERT INTO `gestion_projet_categorie` VALUES (2, 'Fonctionnement interne');
 INSERT INTO `gestion_projet_categorie` VALUES (3, 'Site internet et outils coopératif');
 INSERT INTO `gestion_projet_categorie` VALUES (4, 'Animation');
 INSERT INTO `gestion_projet_categorie` VALUES (5, 'Projets inclus convention MEDT');
 INSERT INTO `gestion_projet_categorie` VALUES (6, 'Projet hors convention');
 INSERT INTO `gestion_projet_categorie` VALUES (7, 'Services pour des tiers');
 -- --------------------------------------------------------
   `gpt_duree_prevue` int(11) unsigned default NULL,
   `gpt_avancement` int(11) default NULL,
   PRIMARY KEY  (`gpt_id_tache`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 --
 -- Contenu de la table `gestion_projet_tache`
 --
 INSERT INTO `gestion_projet_tache` VALUES (1, 0, 10, 'gnral', '', NULL, NULL, NULL);
 INSERT INTO `gestion_projet_tache` VALUES (2, 0, 15, 'gnral', '', NULL, NULL, NULL);
+INSERT INTO `gestion_projet_tache` VALUES (3, 0, 9, 'gnral', '', NULL, NULL, NULL);
+INSERT INTO `gestion_projet_tache` VALUES (4, 0, 11, 'gnral', '', NULL, NULL, NULL);
+INSERT INTO `gestion_projet_tache` VALUES (5, 0, 12, 'gnral', '', NULL, NULL, NULL);
-INSERT INTO `gestion_projet_tache` VALUES (3, 0, 9, 'gnral', '', NULL, NULL, NULL);
+INSERT INTO `gestion_projet_tache` VALUES (6, 0, 13, 'gnral', '', NULL, NULL, NULL);
-INSERT INTO `gestion_projet_tache` VALUES (4, 0, 11, 'gnral', '', NULL, NULL, NULL);
+INSERT INTO `gestion_projet_tache` VALUES (7, 0, 14, 'gnral', '', NULL, NULL, NULL);
 -- --------------------------------------------------------
 --
 -- Structure de la table `gestion_travail_projet`
 --
 CREATE TABLE `gestion_travail_projet` (
   `gtp_id_utilisateur` int(11) unsigned NOT NULL,
   `gtp_id_projet` int(11) unsigned NOT NULL,
   `gtp_id_date_travail` date NOT NULL default '0000-00-00',
   `gtp_duree` float NOT NULL default '0',
   PRIMARY KEY  (`gtp_id_utilisateur`,`gtp_id_projet`,`gtp_id_date_travail`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 --
 -- Contenu de la table `gestion_travail_projet`
 --
 INSERT INTO `gestion_travail_projet` VALUES (3, 14, '2003-04-23', 3);
 INSERT INTO `gestion_travail_projet` VALUES (3, 18, '2003-04-23', 3.75);
+INSERT INTO `gestion_travail_projet` VALUES (3, 22, '2003-04-23', 1);
+INSERT INTO `gestion_travail_projet` VALUES (3, 18, '2003-04-24', 7);
+INSERT INTO `gestion_travail_projet` VALUES (3, 22, '2003-04-24', 1);
+INSERT INTO `gestion_travail_projet` VALUES (3, 18, '2003-04-25', 3.75);
+INSERT INTO `gestion_travail_projet` VALUES (3, 22, '2003-04-25', 0.75);
-INSERT INTO `gestion_travail_projet` VALUES (3, 22, '2003-04-23', 1);
+INSERT INTO `gestion_travail_projet` VALUES (3, 11, '2006-07-18', 2.75);
-INSERT INTO `gestion_travail_projet` VALUES (3, 18, '2003-04-24', 7);
+INSERT INTO `gestion_travail_projet` VALUES (3, 12, '2006-07-22', 6.5);
-INSERT INTO `gestion_travail_projet` VALUES (3, 22, '2003-04-24', 1);
+INSERT INTO `gestion_travail_projet` VALUES (3, 24, '2006-07-26', 3);
-INSERT INTO `gestion_travail_projet` VALUES (3, 18, '2003-04-25', 3.75);
+INSERT INTO `gestion_travail_projet` VALUES (3, 3, '2006-07-23', 2);
-INSERT INTO `gestion_travail_projet` VALUES (3, 22, '2003-04-25', 0.75);
+INSERT INTO `gestion_travail_projet` VALUES (3, 6, '2006-07-23', 3);
-INSERT INTO `gestion_travail_projet` VALUES (3, 25, '2003-04-25', 2.75);
+INSERT INTO `gestion_travail_projet` VALUES (3, 10, '2006-07-23', 2);
-INSERT INTO `gestion_travail_projet` VALUES (3, 18, '2003-04-28', 6.5);
+INSERT INTO `gestion_travail_projet` VALUES (3, 9, '2006-07-23', 5);
 -- --------------------------------------------------------
 --
 -- Structure de la table `gestion_travail_tache`
 --
 CREATE TABLE `gestion_travail_tache` (
   `gtt_id_utilisateur` int(11) unsigned NOT NULL,
   `gtt_id_tache` int(11) unsigned NOT NULL,
   `gtt_id_date_travail` date NOT NULL,
   `gtt_duree` float NOT NULL default '0',
   PRIMARY KEY  (`gtt_id_utilisateur`,`gtt_id_tache`,`gtt_id_date_travail`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 --
 -- Contenu de la table `gestion_travail_tache`
 --
   `gu_mark_recapitulatif` tinyint(1) default NULL,
   `gu_notes` text collate utf8_unicode_ci,
   PRIMARY KEY  (`gu_id_utilisateur`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 --
 -- Contenu de la table `gestion_utilisateur`
 --
 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 (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 (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', 19.75, 22, 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 (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 (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 (7, 0, 'Abdool Raheem', 'Shaheen', '6142a777667a67d568f674931389f0d9', 'shaheen@tela-botanica.org', 0, '--', 0, 'montpellier', 44, 3, 0, 0, 0, NULL);
 -- --------------------------------------------------------
 --
 -- Structure de la table `gestion_utilisateur_a_projet`
 --
 CREATE TABLE `gestion_utilisateur_a_projet` (
   `guap_id_utilisateur` int(11) unsigned NOT NULL,
   `guap_id_projet` int(11) unsigned NOT NULL,
+  PRIMARY KEY  (`guap_id_utilisateur`,`guap_id_projet`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-  PRIMARY KEY  (`guap_id_utilisateur`,`guap_id_projet`)
+--
+-- Contenu de la table `gestion_utilisateur_a_projet`
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+--
+INSERT INTO `gestion_utilisateur_a_projet` VALUES (3, 3);
+INSERT INTO `gestion_utilisateur_a_projet` VALUES (3, 6);
+INSERT INTO `gestion_utilisateur_a_projet` VALUES (3, 8);
+INSERT INTO `gestion_utilisateur_a_projet` VALUES (3, 9);
+INSERT INTO `gestion_utilisateur_a_projet` VALUES (3, 10);
+INSERT INTO `gestion_utilisateur_a_projet` VALUES (3, 11);
+INSERT INTO `gestion_utilisateur_a_projet` VALUES (3, 12);
+INSERT INTO `gestion_utilisateur_a_projet` VALUES (3, 13);
 INSERT INTO `gestion_utilisateur_a_projet` VALUES (3, 14);
---
+INSERT INTO `gestion_utilisateur_a_projet` VALUES (3, 17);
--- Contenu de la table `gestion_utilisateur_a_projet`
+INSERT INTO `gestion_utilisateur_a_projet` VALUES (3, 18);
---
+INSERT INTO `gestion_utilisateur_a_projet` VALUES (3, 19);
 INSERT INTO `gestion_utilisateur_a_projet` VALUES (3, 20);
-INSERT INTO `gestion_utilisateur_a_projet` VALUES (3, 9);
+INSERT INTO `gestion_utilisateur_a_projet` VALUES (3, 23);
-INSERT INTO `gestion_utilisateur_a_projet` VALUES (3, 11);
+INSERT INTO `gestion_utilisateur_a_projet` VALUES (3, 24);
 INSERT INTO `gestion_utilisateur_a_projet` VALUES (7, 10);
 INSERT INTO `gestion_utilisateur_a_projet` VALUES (7, 15);
 -- --------------------------------------------------------
 --
 -- Structure de la table `gestion_utilisateur_statut`
 --
 CREATE TABLE `gestion_utilisateur_statut` (

Subversion Repositories Applications.gtt

(root)/trunk/documentation/gtt_v4.sql @ 41 – Rev 24 → 41