Subversion Repositories Applications.gtt

Compare Revisions

Ignore whitespace Rev 40 → Rev 41

/trunk/documentation/gtt_v4.sql
1,20 → 1,20
-- 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
-- Version du serveur: 5.0.18
-- Version de PHP: 5.1.1
--
-- Généré le : Mercredi 26 Juillet 2006 à 20:26
-- Version du serveur: 5.0.15
-- 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,
21,19 → 21,23
`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);
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,
41,20 → 45,22
PRIMARY KEY (`gam_id_absence_motif`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
--
--
-- 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 (4, 'Grêve');
INSERT INTO `gestion_absence_motif` VALUES (3, 'Maladie');
INSERT INTO `gestion_absence_motif` VALUES (3, 'Grêve');
INSERT INTO `gestion_absence_motif` VALUES (4, 'Maladie');
INSERT INTO `gestion_absence_motif` VALUES (5, 'Congés exceptionnel');
INSERT INTO `gestion_absence_motif` VALUES (6, 'Formation professionnelle');
 
-- --------------------------------------------------------
 
--
--
-- Structure de la table `gestion_frais_km`
--
--
 
CREATE TABLE `gestion_frais_km` (
`gfk_id_frais_km` int(11) unsigned NOT NULL,
68,16 → 74,16
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,
85,16 → 91,16
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,
103,16 → 109,16
PRIMARY KEY (`gnf_id_note_frais`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
--
--
-- Contenu de la table `gestion_note_frais`
--
--
 
 
-- --------------------------------------------------------
 
--
--
-- Structure de la table `gestion_note_frais_ligne`
--
--
 
CREATE TABLE `gestion_note_frais_ligne` (
`gnfl_id_note_frais_ligne` int(11) unsigned NOT NULL,
124,16 → 130,16
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`
--
--
 
CREATE TABLE `gestion_projet` (
`gp_id_projet` int(11) unsigned NOT NULL,
146,9 → 152,9
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);
175,9 → 181,9
 
-- --------------------------------------------------------
 
--
--
-- Structure de la table `gestion_projet_categorie`
--
--
 
CREATE TABLE `gestion_projet_categorie` (
`gpc_id_categorie` int(11) unsigned NOT NULL,
185,9 → 191,9
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');
198,9 → 204,9
 
-- --------------------------------------------------------
 
--
--
-- Structure de la table `gestion_projet_tache`
--
--
 
CREATE TABLE `gestion_projet_tache` (
`gpt_id_tache` int(11) unsigned NOT NULL,
214,20 → 220,23
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 (6, 0, 13, '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,
237,9 → 246,9
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);
248,14 → 257,19
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, 25, '2003-04-25', 2.75);
INSERT INTO `gestion_travail_projet` VALUES (3, 18, '2003-04-28', 6.5);
INSERT INTO `gestion_travail_projet` VALUES (3, 11, '2006-07-18', 2.75);
INSERT INTO `gestion_travail_projet` VALUES (3, 12, '2006-07-22', 6.5);
INSERT INTO `gestion_travail_projet` VALUES (3, 24, '2006-07-26', 3);
INSERT INTO `gestion_travail_projet` VALUES (3, 3, '2006-07-23', 2);
INSERT INTO `gestion_travail_projet` VALUES (3, 6, '2006-07-23', 3);
INSERT INTO `gestion_travail_projet` VALUES (3, 10, '2006-07-23', 2);
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,
265,20 → 279,20
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`
--
--
 
 
-- --------------------------------------------------------
 
--
--
-- Structure de la table `gestion_utilisateur`
--
--
 
CREATE TABLE `gestion_utilisateur` (
`gu_id_utilisateur` int(11) unsigned NOT NULL,
`gus_id_utilisateur_statut` tinyint(3) unsigned NOT NULL,
`gu_ce_statut` tinyint(3) unsigned NOT NULL,
`gu_nom` varchar(100) collate utf8_unicode_ci NOT NULL,
`gu_prenom` varchar(100) collate utf8_unicode_ci NOT NULL,
`gu_password` varchar(32) collate utf8_unicode_ci NOT NULL,
296,14 → 310,14
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);
311,9 → 325,9
 
-- --------------------------------------------------------
 
--
--
-- Structure de la table `gestion_utilisateur_a_projet`
--
--
 
CREATE TABLE `gestion_utilisateur_a_projet` (
`guap_id_utilisateur` int(11) unsigned NOT NULL,
321,20 → 335,33
PRIMARY KEY (`guap_id_utilisateur`,`guap_id_projet`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
--
--
-- Contenu de la table `gestion_utilisateur_a_projet`
--
--
 
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);
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, 23);
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` (
`gus_id_utilisateur_statut` tinyint(3) unsigned NOT NULL,
342,9 → 369,9
PRIMARY KEY (`gus_id_utilisateur_statut`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
--
--
-- Contenu de la table `gestion_utilisateur_statut`
--
--
 
INSERT INTO `gestion_utilisateur_statut` VALUES (0, 'Stagiaire');
INSERT INTO `gestion_utilisateur_statut` VALUES (1, 'Salarié');
/trunk/documentation/gtt_v4.xml
691,7 → 691,7
<OPTIONSELECT Value="0" />
</OPTIONSELECTED>
</COLUMN>
<COLUMN ID="1735" ColName="gus_id_utilisateur_statut" PrevColName="" Pos="1" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
<COLUMN ID="1763" ColName="gu_ce_statut" PrevColName="" Pos="1" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
<OPTIONSELECTED>
<OPTIONSELECT Value="1" />
<OPTIONSELECT Value="0" />
870,7 → 870,7
<RELATION ID="1564" RelationName="fk_gpc_gp" Kind="5" SrcTable="1395" DestTable="1404" FKFields="gpc_id_categorie=gp_ce_categorie\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-47" CaptionOffsetY="-22" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" />
<RELATION ID="1583" RelationName="fk_gam_ga" Kind="1" SrcTable="1399" DestTable="1394" FKFields="gam_id_absence_motif=ga_id_absence_motif\n" FKFieldsComments="\n" relDirection="1" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-47" CaptionOffsetY="-22" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="31" />
<RELATION ID="1585" RelationName="fk_gu_ga" Kind="1" SrcTable="1408" DestTable="1394" FKFields="gu_id_utilisateur=ga_id_utilisateur\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-45" CaptionOffsetY="-22" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" />
<RELATION ID="1592" RelationName="fk_gs_gu" Kind="2" SrcTable="1405" DestTable="1408" FKFields="gus_id_utilisateur_statut=gus_id_utilisateur_statut\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-41" CaptionOffsetY="-24" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" />
<RELATION ID="1592" RelationName="fk_gs_gu" Kind="2" SrcTable="1405" DestTable="1408" FKFields="gus_id_utilisateur_statut=gu_ce_statut\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-41" CaptionOffsetY="-24" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" />
<RELATION ID="1500" RelationName="fk_gnf_gnfl" Kind="5" SrcTable="1400" DestTable="1397" FKFields="gnf_id_note_frais=gnfl_ce_note_frais\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-48" CaptionOffsetY="-25" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="20" />
<RELATION ID="1612" RelationName="fk_gu_gnf" Kind="2" SrcTable="1408" DestTable="1400" FKFields="gu_id_utilisateur=gnf_ce_utilisateur\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" />
<RELATION ID="1690" RelationName="fk_gpt_gpt_predecesseur" Kind="2" SrcTable="1406" DestTable="1406" FKFields="gpt_id_tache=gpt_ce_tache_precedente\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-84" CaptionOffsetY="-23" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="29" />