1,11 → 1,11 |
-- 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` |
-- |
21,7 → 21,7 |
`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; |
|
-- |
28,6 → 28,10 |
-- 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); |
|
-- -------------------------------------------------------- |
|
47,8 → 51,10 |
|
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'); |
|
-- -------------------------------------------------------- |
|
222,6 → 228,9 |
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); |
|
-- -------------------------------------------------------- |
|
248,8 → 257,13 |
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); |
|
-- -------------------------------------------------------- |
|
278,7 → 292,7 |
|
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, |
303,7 → 317,7 |
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); |
325,8 → 339,21 |
-- 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); |
|