Line 1... |
Line -... |
1 |
DROP DATABASE IF EXISTS `gestion_v4`;
|
- |
|
2 |
CREATE DATABASE `gestion_v4` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
|
- |
|
3 |
|
- |
|
4 |
CREATE TABLE `gestion_v4`.gestion_absence (
|
- |
|
5 |
ga_id_abscence INTEGER(11) UNSIGNED NOT NULL,
|
- |
|
6 |
ga_ce_absence_motif TINYINT(3) UNSIGNED NOT NULL,
|
- |
|
7 |
ga_ce_utilisateur INTEGER(11) UNSIGNED NOT NULL,
|
- |
|
8 |
ga_date_debut DATE NOT NULL DEFAULT "0000-00-00",
|
- |
|
9 |
ga_date_fin DATE NOT NULL DEFAULT "0000-00-00",
|
- |
|
10 |
ga_date_envoi_lettre DATE NOT NULL DEFAULT "0000-00-00",
|
- |
|
11 |
PRIMARY KEY(ga_id_abscence)
|
- |
|
12 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
|
- |
|
13 |
|
- |
|
14 |
CREATE TABLE `gestion_v4`.gestion_absence_motif (
|
- |
|
15 |
gam_id_absence_motif TINYINT(3) UNSIGNED NOT NULL,
|
- |
|
16 |
gam_libelle VARCHAR(255) NOT NULL,
|
- |
|
17 |
gam_mark_rtt BOOL NOT NULL,
|
- |
|
18 |
gam_nbre_heure INT(11) NULL,
|
- |
|
19 |
PRIMARY KEY(gam_id_absence_motif)
|
- |
|
20 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
|
- |
|
21 |
|
- |
|
22 |
CREATE TABLE `gestion_v4`.gestion_frais_km (
|
- |
|
23 |
gfk_id_frais_km INTEGER(11) UNSIGNED NOT NULL,
|
- |
|
24 |
gfkt_id_frais_km_taux INTEGER(11) UNSIGNED NOT NULL,
|
- |
|
25 |
gfk_ce_utilisateur INTEGER(11) UNSIGNED NOT NULL,
|
- |
|
26 |
gfk_date DATE NOT NULL DEFAULT "0000-00-00",
|
- |
|
27 |
gfk_nbre_km FLOAT NULL,
|
- |
|
28 |
gfk_objet VARCHAR(255) NULL,
|
- |
|
29 |
gfk_trajet VARCHAR(255) NULL,
|
- |
|
30 |
gfk_montant_total FLOAT NOT NULL,
|
- |
|
31 |
PRIMARY KEY(gfk_id_frais_km)
|
- |
|
32 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
|
- |
|
33 |
|
- |
|
34 |
CREATE TABLE `gestion_v4`.gestion_frais_km_taux (
|
- |
|
35 |
gfkt_id_frais_km_taux INTEGER(11) UNSIGNED NOT NULL,
|
- |
|
36 |
gfkt_taux FLOAT NOT NULL,
|
- |
|
37 |
PRIMARY KEY(gfkt_id_frais_km_taux)
|
- |
|
38 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
|
- |
|
39 |
|
- |
|
40 |
CREATE TABLE `gestion_v4`.gestion_note_frais (
|
- |
|
41 |
gnf_id_note_frais INTEGER(11) UNSIGNED NOT NULL,
|
- |
|
42 |
gnf_ce_utilisateur INTEGER(11) UNSIGNED NOT NULL,
|
- |
|
43 |
gnf_libelle VARCHAR(255) NOT NULL,
|
- |
|
44 |
PRIMARY KEY(gnf_id_note_frais)
|
- |
|
45 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
|
- |
|
46 |
|
- |
|
47 |
CREATE TABLE `gestion_v4`.gestion_note_frais_ligne (
|
- |
|
48 |
gnfl_id_note_frais_ligne INTEGER(11) UNSIGNED NOT NULL,
|
- |
|
49 |
gnfl_ce_note_frais INTEGER(11) UNSIGNED NOT NULL,
|
- |
|
50 |
gnfl_date DATE NOT NULL DEFAULT "0000-00-00",
|
- |
|
51 |
gnfl_montant_ht FLOAT NULL,
|
- |
|
52 |
gnfl_taux_tva FLOAT NULL,
|
- |
|
53 |
gnfl_montant_ttc FLOAT NOT NULL,
|
- |
|
54 |
PRIMARY KEY(gnfl_id_note_frais_ligne)
|
- |
|
55 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
|
- |
|
56 |
|
- |
|
57 |
CREATE TABLE `gestion_v4`.gestion_projet (
|
- |
|
58 |
gp_id_projet INTEGER(11) UNSIGNED NOT NULL,
|
- |
|
59 |
gp_ce_categorie INTEGER(11) UNSIGNED NOT NULL,
|
- |
|
60 |
gp_nom_projet VARCHAR(255) NOT NULL,
|
- |
|
61 |
gp_description TEXT NULL,
|
- |
|
62 |
gp_date_debut DATE NULL,
|
- |
|
63 |
gp_duree_prevue FLOAT NULL,
|
- |
|
64 |
gp_avancement INTEGER(11) NULL,
|
- |
|
65 |
PRIMARY KEY(gp_id_projet)
|
- |
|
66 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
|
- |
|
67 |
|
- |
|
68 |
CREATE TABLE `gestion_v4`.gestion_projet_categorie (
|
- |
|
69 |
gpc_id_categorie INTEGER(11) UNSIGNED NOT NULL,
|
- |
|
70 |
gpc_libelle VARCHAR(255) NOT NULL,
|
- |
|
71 |
PRIMARY KEY(gpc_id_categorie)
|
- |
|
72 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
|
- |
|
73 |
|
- |
|
74 |
CREATE TABLE `gestion_v4`.gestion_projet_tache (
|
- |
|
75 |
gpt_id_tache INTEGER(11) UNSIGNED NOT NULL,
|
- |
|
76 |
gpt_ce_tache_precedente INTEGER(11) UNSIGNED NOT NULL,
|
- |
|
77 |
gpt_ce_projet INTEGER(11) UNSIGNED NOT NULL,
|
- |
|
78 |
gpt_libelle VARCHAR(255) NOT NULL,
|
- |
|
79 |
gpt_description TEXT NULL,
|
- |
|
80 |
gpt_date_debut DATE NULL,
|
- |
|
81 |
gpt_duree_prevue INTEGER(11) UNSIGNED NULL,
|
- |
|
82 |
gpt_avancement INTEGER(11) NULL,
|
- |
|
83 |
PRIMARY KEY(gpt_id_tache)
|
- |
|
84 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
|
- |
|
85 |
|
- |
|
86 |
CREATE TABLE `gestion_v4`.gestion_travail_projet (
|
- |
|
87 |
gtp_id_utilisateur INTEGER(11) UNSIGNED NOT NULL,
|
- |
|
88 |
gtp_id_projet INTEGER(11) UNSIGNED NOT NULL,
|
- |
|
89 |
gtp_id_date_travail DATE NOT NULL DEFAULT "0000-00-00",
|
- |
|
90 |
gtp_duree FLOAT NOT NULL DEFAULT 0,
|
- |
|
91 |
PRIMARY KEY(gtp_id_utilisateur, gtp_id_projet, gtp_id_date_travail)
|
- |
|
92 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
|
- |
|
93 |
|
- |
|
94 |
CREATE TABLE `gestion_v4`.gestion_travail_tache (
|
- |
|
95 |
gtt_id_utilisateur INTEGER(11) UNSIGNED NOT NULL,
|
- |
|
96 |
gtt_id_tache INTEGER(11) UNSIGNED NOT NULL,
|
- |
|
97 |
gtt_id_date_travail DATE NOT NULL,
|
- |
|
98 |
gtt_duree FLOAT NOT NULL DEFAULT 0,
|
- |
|
99 |
PRIMARY KEY(gtt_id_utilisateur, gtt_id_tache, gtt_id_date_travail)
|
- |
|
100 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
|
- |
|
101 |
|
- |
|
102 |
CREATE TABLE `gestion_v4`.gestion_utilisateur (
|
- |
|
103 |
gu_id_utilisateur INTEGER(11) UNSIGNED NOT NULL,
|
- |
|
104 |
gus_id_utilisateur_statut TINYINT(3) UNSIGNED NOT NULL,
|
- |
|
105 |
gu_nom VARCHAR(100) NOT NULL,
|
- |
|
106 |
gu_prenom VARCHAR(100) NOT NULL,
|
- |
|
107 |
gu_password VARCHAR(32) NOT NULL,
|
- |
|
108 |
gu_email VARCHAR(255) NOT NULL,
|
- |
|
109 |
gu_telephone INTEGER(11) UNSIGNED NULL,
|
- |
|
110 |
gu_adresse VARCHAR(255) NULL,
|
- |
|
111 |
gu_code_postal INTEGER(11) UNSIGNED NULL,
|
- |
|
112 |
gu_ville VARCHAR(50) NULL,
|
- |
|
113 |
gu_quota_heures_supp FLOAT NULL,
|
- |
|
114 |
gu_conges_payes FLOAT NULL,
|
- |
|
115 |
gu_temps_de_travail FLOAT NULL,
|
- |
|
116 |
gu_mark_admin BOOL NULL,
|
- |
|
117 |
gu_mark_recapitulatif BOOL NULL,
|
- |
|
118 |
gu_notes TEXT NULL,
|
- |
|
119 |
PRIMARY KEY(gu_id_utilisateur)
|
- |
|
120 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
|
- |
|
121 |
|
- |
|
122 |
CREATE TABLE `gestion_v4`.gestion_utilisateur_a_projet (
|
- |
|
123 |
guap_id_utilisateur INTEGER(11) UNSIGNED NOT NULL,
|
- |
|
124 |
guap_id_projet INTEGER(11) UNSIGNED NOT NULL,
|
- |
|
125 |
PRIMARY KEY(guap_id_utilisateur, guap_id_projet)
|
- |
|
126 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
|
- |
|
127 |
|
- |
|
128 |
CREATE TABLE `gestion_v4`.gestion_utilisateur_statut (
|
- |
|
129 |
gus_id_utilisateur_statut TINYINT(3) UNSIGNED NOT NULL,
|
- |
|
130 |
gus_libelle VARCHAR(255) NOT NULL,
|
- |
|
131 |
PRIMARY KEY(gus_id_utilisateur_statut)
|
- |
|
132 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
|
- |
|
133 |
|
1 |
-- phpMyAdmin SQL Dump
|
- |
|
2 |
-- version 2.7.0-pl2
|
- |
|
3 |
-- http://www.phpmyadmin.net
|
- |
|
4 |
--
|
- |
|
5 |
-- Serveur: localhost
|
- |
|
6 |
-- Généré le : Lundi 24 Juillet 2006 à 15:12
|
- |
|
7 |
-- Version du serveur: 5.0.18
|
- |
|
8 |
-- Version de PHP: 5.1.1
|
- |
|
9 |
--
|
- |
|
10 |
-- Base de données: `gestion_v4`
|
- |
|
11 |
--
|
- |
|
12 |
|
- |
|
13 |
-- --------------------------------------------------------
|
- |
|
14 |
|
- |
|
15 |
--
|
- |
|
16 |
-- Structure de la table `gestion_absence`
|
- |
|
17 |
--
|
- |
|
18 |
|
- |
|
19 |
CREATE TABLE `gestion_absence` (
|
- |
|
20 |
`ga_id_utilisateur` int(11) unsigned NOT NULL,
|
- |
|
21 |
`ga_id_absence_motif` tinyint(3) unsigned NOT NULL,
|
- |
|
22 |
`ga_id_date_absence` date NOT NULL default '0000-00-00',
|
- |
|
23 |
`ga_duree` float NOT NULL default '0',
|
- |
|
24 |
PRIMARY KEY (`ga_id_utilisateur`)
|
- |
|
25 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
- |
|
26 |
|
- |
|
27 |
--
|
- |
|
28 |
-- Contenu de la table `gestion_absence`
|
- |
|
29 |
--
|
- |
|
30 |
|
- |
|
31 |
|
- |
|
32 |
-- --------------------------------------------------------
|
- |
|
33 |
|
- |
|
34 |
--
|
- |
|
35 |
-- Structure de la table `gestion_absence_motif`
|
- |
|
36 |
--
|
- |
|
37 |
|
- |
|
38 |
CREATE TABLE `gestion_absence_motif` (
|
- |
|
39 |
`gam_id_absence_motif` tinyint(3) unsigned NOT NULL,
|
- |
|
40 |
`gam_libelle` varchar(255) collate utf8_unicode_ci NOT NULL,
|
- |
|
41 |
PRIMARY KEY (`gam_id_absence_motif`)
|
- |
|
42 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
- |
|
43 |
|
- |
|
44 |
--
|
- |
|
45 |
-- Contenu de la table `gestion_absence_motif`
|
- |
|
46 |
--
|
- |
|
47 |
|
- |
|
48 |
INSERT INTO `gestion_absence_motif` VALUES (1, 'Congés payés');
|
- |
|
49 |
INSERT INTO `gestion_absence_motif` VALUES (2, 'Récupération');
|
- |
|
50 |
INSERT INTO `gestion_absence_motif` VALUES (4, 'Grêve');
|
- |
|
51 |
INSERT INTO `gestion_absence_motif` VALUES (3, 'Maladie');
|
- |
|
52 |
|
- |
|
53 |
-- --------------------------------------------------------
|
- |
|
54 |
|
- |
|
55 |
--
|
- |
|
56 |
-- Structure de la table `gestion_frais_km`
|
- |
|
57 |
--
|
- |
|
58 |
|
- |
|
59 |
CREATE TABLE `gestion_frais_km` (
|
- |
|
60 |
`gfk_id_frais_km` int(11) unsigned NOT NULL,
|
- |
|
61 |
`gfkt_id_frais_km_taux` int(11) unsigned NOT NULL,
|
- |
|
62 |
`gfk_ce_utilisateur` int(11) unsigned NOT NULL,
|
- |
|
63 |
`gfk_date` date NOT NULL default '0000-00-00',
|
- |
|
64 |
`gfk_nbre_km` float default NULL,
|
- |
|
65 |
`gfk_objet` varchar(255) collate utf8_unicode_ci default NULL,
|
- |
|
66 |
`gfk_trajet` varchar(255) collate utf8_unicode_ci default NULL,
|
- |
|
67 |
`gfk_montant_total` float NOT NULL,
|
- |
|
68 |
PRIMARY KEY (`gfk_id_frais_km`)
|
- |
|
69 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
- |
|
70 |
|
- |
|
71 |
--
|
- |
|
72 |
-- Contenu de la table `gestion_frais_km`
|
- |
|
73 |
--
|
- |
|
74 |
|
- |
|
75 |
|
- |
|
76 |
-- --------------------------------------------------------
|
- |
|
77 |
|
- |
|
78 |
--
|
- |
|
79 |
-- Structure de la table `gestion_frais_km_taux`
|
- |
|
80 |
--
|
- |
|
81 |
|
- |
|
82 |
CREATE TABLE `gestion_frais_km_taux` (
|
- |
|
83 |
`gfkt_id_frais_km_taux` int(11) unsigned NOT NULL,
|
- |
|
84 |
`gfkt_taux` float NOT NULL,
|
- |
|
85 |
PRIMARY KEY (`gfkt_id_frais_km_taux`)
|
- |
|
86 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
- |
|
87 |
|
- |
|
88 |
--
|
- |
|
89 |
-- Contenu de la table `gestion_frais_km_taux`
|
- |
|
90 |
--
|
- |
|
91 |
|
- |
|
92 |
|
- |
|
93 |
-- --------------------------------------------------------
|
- |
|
94 |
|
- |
|
95 |
--
|
- |
|
96 |
-- Structure de la table `gestion_note_frais`
|
- |
|
97 |
--
|
- |
|
98 |
|
- |
|
99 |
CREATE TABLE `gestion_note_frais` (
|
- |
|
100 |
`gnf_id_note_frais` int(11) unsigned NOT NULL,
|
- |
|
101 |
`gnf_ce_utilisateur` int(11) unsigned NOT NULL,
|
- |
|
102 |
`gnf_libelle` varchar(255) collate utf8_unicode_ci NOT NULL,
|
- |
|
103 |
PRIMARY KEY (`gnf_id_note_frais`)
|
- |
|
104 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
- |
|
105 |
|
- |
|
106 |
--
|
- |
|
107 |
-- Contenu de la table `gestion_note_frais`
|
- |
|
108 |
--
|
- |
|
109 |
|
- |
|
110 |
|
- |
|
111 |
-- --------------------------------------------------------
|
- |
|
112 |
|
- |
|
113 |
--
|
- |
|
114 |
-- Structure de la table `gestion_note_frais_ligne`
|
- |
|
115 |
--
|
- |
|
116 |
|
- |
|
117 |
CREATE TABLE `gestion_note_frais_ligne` (
|
- |
|
118 |
`gnfl_id_note_frais_ligne` int(11) unsigned NOT NULL,
|
- |
|
119 |
`gnfl_ce_note_frais` int(11) unsigned NOT NULL,
|
- |
|
120 |
`gnfl_date` date NOT NULL default '0000-00-00',
|
- |
|
121 |
`gnfl_montant_ht` float default NULL,
|
- |
|
122 |
`gnfl_taux_tva` float default NULL,
|
- |
|
123 |
`gnfl_montant_ttc` float NOT NULL,
|
- |
|
124 |
PRIMARY KEY (`gnfl_id_note_frais_ligne`)
|
- |
|
125 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
- |
|
126 |
|
- |
|
127 |
--
|
- |
|
128 |
-- Contenu de la table `gestion_note_frais_ligne`
|
- |
|
129 |
--
|
- |
|
130 |
|
- |
|
131 |
|
- |
|
132 |
-- --------------------------------------------------------
|
- |
|
133 |
|
- |
|
134 |
--
|
- |
|
135 |
-- Structure de la table `gestion_projet`
|
- |
|
136 |
--
|
- |
|
137 |
|
- |
|
138 |
CREATE TABLE `gestion_projet` (
|
- |
|
139 |
`gp_id_projet` int(11) unsigned NOT NULL,
|
- |
|
140 |
`gp_ce_categorie` int(11) unsigned NOT NULL,
|
- |
|
141 |
`gp_nom_projet` varchar(255) collate utf8_unicode_ci NOT NULL,
|
- |
|
142 |
`gp_description` text collate utf8_unicode_ci,
|
- |
|
143 |
`gp_date_debut` date default NULL,
|
- |
|
144 |
`gp_duree_prevue` float default NULL,
|
- |
|
145 |
`gp_avancement` int(11) default NULL,
|
- |
|
146 |
PRIMARY KEY (`gp_id_projet`)
|
- |
|
147 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
- |
|
148 |
|
- |
|
149 |
--
|
- |
|
150 |
-- Contenu de la table `gestion_projet`
|
- |
|
151 |
--
|
- |
|
152 |
|
- |
|
153 |
INSERT INTO `gestion_projet` VALUES (3, 6, 'Base de données nomenclaturale', '', NULL, NULL, NULL);
|
- |
|
154 |
INSERT INTO `gestion_projet` VALUES (4, 6, 'Index des bryophytes', '', NULL, NULL, NULL);
|
- |
|
155 |
INSERT INTO `gestion_projet` VALUES (5, 6, 'Index des plantes de la Réunion', '', NULL, NULL, NULL);
|
- |
|
156 |
INSERT INTO `gestion_projet` VALUES (6, 6, 'Plantes envahissantes', '', NULL, NULL, NULL);
|
- |
|
157 |
INSERT INTO `gestion_projet` VALUES (7, 7, 'Projet FEEE planetere', '', NULL, NULL, NULL);
|
- |
|
158 |
INSERT INTO `gestion_projet` VALUES (8, 7, 'projet FEEE - YRE', '', NULL, NULL, NULL);
|
- |
|
159 |
INSERT INTO `gestion_projet` VALUES (9, 2, 'Formation stagiaire', '', NULL, NULL, NULL);
|
- |
|
160 |
INSERT INTO `gestion_projet` VALUES (10, 2, 'Gestion interne', '', NULL, NULL, NULL);
|
- |
|
161 |
INSERT INTO `gestion_projet` VALUES (11, 2, 'Comptablilité', '', NULL, NULL, NULL);
|
- |
|
162 |
INSERT INTO `gestion_projet` VALUES (12, 2, 'Déplacement', '', NULL, NULL, NULL);
|
- |
|
163 |
INSERT INTO `gestion_projet` VALUES (13, 2, 'Formation', '', NULL, NULL, NULL);
|
- |
|
164 |
INSERT INTO `gestion_projet` VALUES (14, 2, 'Autres', '', NULL, NULL, NULL);
|
- |
|
165 |
INSERT INTO `gestion_projet` VALUES (15, 3, 'Développement', '', NULL, NULL, NULL);
|
- |
|
166 |
INSERT INTO `gestion_projet` VALUES (16, 3, 'Contenu du site', '', NULL, NULL, NULL);
|
- |
|
167 |
INSERT INTO `gestion_projet` VALUES (17, 3, 'Autre', '', NULL, NULL, NULL);
|
- |
|
168 |
INSERT INTO `gestion_projet` VALUES (18, 5, 'Flore éléctronique', '', NULL, NULL, NULL);
|
- |
|
169 |
INSERT INTO `gestion_projet` VALUES (19, 5, 'Apprendre la botanique sur internet', '', NULL, NULL, NULL);
|
- |
|
170 |
INSERT INTO `gestion_projet` VALUES (20, 6, 'Inventaire des herbiers de France', '', NULL, NULL, NULL);
|
- |
|
171 |
INSERT INTO `gestion_projet` VALUES (21, 3, 'Maintenance informatique', '', NULL, NULL, NULL);
|
- |
|
172 |
INSERT INTO `gestion_projet` VALUES (22, 4, 'Animation adhérent', '', NULL, NULL, NULL);
|
- |
|
173 |
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);
|
- |
|
174 |
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);
|
- |
|
175 |
|
- |
|
176 |
-- --------------------------------------------------------
|
- |
|
177 |
|
- |
|
178 |
--
|
- |
|
179 |
-- Structure de la table `gestion_projet_categorie`
|
- |
|
180 |
--
|
- |
|
181 |
|
- |
|
182 |
CREATE TABLE `gestion_projet_categorie` (
|
- |
|
183 |
`gpc_id_categorie` int(11) unsigned NOT NULL,
|
- |
|
184 |
`gpc_libelle` varchar(255) collate utf8_unicode_ci NOT NULL,
|
- |
|
185 |
PRIMARY KEY (`gpc_id_categorie`)
|
- |
|
186 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
- |
|
187 |
|
- |
|
188 |
--
|
- |
|
189 |
-- Contenu de la table `gestion_projet_categorie`
|
- |
|
190 |
--
|
- |
|
191 |
|
- |
|
192 |
INSERT INTO `gestion_projet_categorie` VALUES (2, 'Fonctionnement interne');
|
- |
|
193 |
INSERT INTO `gestion_projet_categorie` VALUES (3, 'Site internet et outils coopératif');
|
- |
|
194 |
INSERT INTO `gestion_projet_categorie` VALUES (4, 'Animation');
|
- |
|
195 |
INSERT INTO `gestion_projet_categorie` VALUES (5, 'Projets inclus convention MEDT');
|
- |
|
196 |
INSERT INTO `gestion_projet_categorie` VALUES (6, 'Projet hors convention');
|
- |
|
197 |
INSERT INTO `gestion_projet_categorie` VALUES (7, 'Services pour des tiers');
|
- |
|
198 |
|
- |
|
199 |
-- --------------------------------------------------------
|
- |
|
200 |
|
- |
|
201 |
--
|
- |
|
202 |
-- Structure de la table `gestion_projet_tache`
|
- |
|
203 |
--
|
- |
|
204 |
|
- |
|
205 |
CREATE TABLE `gestion_projet_tache` (
|
- |
|
206 |
`gpt_id_tache` int(11) unsigned NOT NULL,
|
- |
|
207 |
`gpt_ce_tache_precedente` int(11) unsigned NOT NULL,
|
- |
|
208 |
`gpt_ce_projet` int(11) unsigned NOT NULL,
|
- |
|
209 |
`gpt_libelle` varchar(255) collate utf8_unicode_ci NOT NULL,
|
- |
|
210 |
`gpt_description` text collate utf8_unicode_ci,
|
- |
|
211 |
`gpt_date_debut` date default NULL,
|
- |
|
212 |
`gpt_duree_prevue` int(11) unsigned default NULL,
|
- |
|
213 |
`gpt_avancement` int(11) default NULL,
|
- |
|
214 |
PRIMARY KEY (`gpt_id_tache`)
|
- |
|
215 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
- |
|
216 |
|
- |
|
217 |
--
|
- |
|
218 |
-- Contenu de la table `gestion_projet_tache`
|
- |
|
219 |
--
|
- |
|
220 |
|
- |
|
221 |
INSERT INTO `gestion_projet_tache` VALUES (1, 0, 10, 'gnral', '', NULL, NULL, NULL);
|
- |
|
222 |
INSERT INTO `gestion_projet_tache` VALUES (2, 0, 15, 'gnral', '', NULL, NULL, NULL);
|
- |
|
223 |
INSERT INTO `gestion_projet_tache` VALUES (3, 0, 9, 'gnral', '', NULL, NULL, NULL);
|
- |
|
224 |
INSERT INTO `gestion_projet_tache` VALUES (4, 0, 11, 'gnral', '', NULL, NULL, NULL);
|
- |
|
225 |
|
- |
|
226 |
-- --------------------------------------------------------
|
- |
|
227 |
|
- |
|
228 |
--
|
- |
|
229 |
-- Structure de la table `gestion_travail_projet`
|
- |
|
230 |
--
|
- |
|
231 |
|
- |
|
232 |
CREATE TABLE `gestion_travail_projet` (
|
- |
|
233 |
`gtp_id_utilisateur` int(11) unsigned NOT NULL,
|
- |
|
234 |
`gtp_id_projet` int(11) unsigned NOT NULL,
|
- |
|
235 |
`gtp_id_date_travail` date NOT NULL default '0000-00-00',
|
- |
|
236 |
`gtp_duree` float NOT NULL default '0',
|
- |
|
237 |
PRIMARY KEY (`gtp_id_utilisateur`,`gtp_id_projet`,`gtp_id_date_travail`)
|
- |
|
238 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
- |
|
239 |
|
- |
|
240 |
--
|
- |
|
241 |
-- Contenu de la table `gestion_travail_projet`
|
- |
|
242 |
--
|
- |
|
243 |
|
- |
|
244 |
INSERT INTO `gestion_travail_projet` VALUES (3, 14, '2003-04-23', 3);
|
- |
|
245 |
INSERT INTO `gestion_travail_projet` VALUES (3, 18, '2003-04-23', 3.75);
|
- |
|
246 |
INSERT INTO `gestion_travail_projet` VALUES (3, 22, '2003-04-23', 1);
|
- |
|
247 |
INSERT INTO `gestion_travail_projet` VALUES (3, 18, '2003-04-24', 7);
|
- |
|
248 |
INSERT INTO `gestion_travail_projet` VALUES (3, 22, '2003-04-24', 1);
|
- |
|
249 |
INSERT INTO `gestion_travail_projet` VALUES (3, 18, '2003-04-25', 3.75);
|
- |
|
250 |
INSERT INTO `gestion_travail_projet` VALUES (3, 22, '2003-04-25', 0.75);
|
- |
|
251 |
INSERT INTO `gestion_travail_projet` VALUES (3, 25, '2003-04-25', 2.75);
|
- |
|
252 |
INSERT INTO `gestion_travail_projet` VALUES (3, 18, '2003-04-28', 6.5);
|
- |
|
253 |
|
- |
|
254 |
-- --------------------------------------------------------
|
- |
|
255 |
|
- |
|
256 |
--
|
- |
|
257 |
-- Structure de la table `gestion_travail_tache`
|
- |
|
258 |
--
|
- |
|
259 |
|
- |
|
260 |
CREATE TABLE `gestion_travail_tache` (
|
- |
|
261 |
`gtt_id_utilisateur` int(11) unsigned NOT NULL,
|
- |
|
262 |
`gtt_id_tache` int(11) unsigned NOT NULL,
|
- |
|
263 |
`gtt_id_date_travail` date NOT NULL,
|
- |
|
264 |
`gtt_duree` float NOT NULL default '0',
|
- |
|
265 |
PRIMARY KEY (`gtt_id_utilisateur`,`gtt_id_tache`,`gtt_id_date_travail`)
|
- |
|
266 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
- |
|
267 |
|
- |
|
268 |
--
|
- |
|
269 |
-- Contenu de la table `gestion_travail_tache`
|
- |
|
270 |
--
|
- |
|
271 |
|
- |
|
272 |
|
- |
|
273 |
-- --------------------------------------------------------
|
- |
|
274 |
|
- |
|
275 |
--
|
- |
|
276 |
-- Structure de la table `gestion_utilisateur`
|
- |
|
277 |
--
|
- |
|
278 |
|
- |
|
279 |
CREATE TABLE `gestion_utilisateur` (
|
- |
|
280 |
`gu_id_utilisateur` int(11) unsigned NOT NULL,
|
- |
|
281 |
`gus_id_utilisateur_statut` tinyint(3) unsigned NOT NULL,
|
- |
|
282 |
`gu_nom` varchar(100) collate utf8_unicode_ci NOT NULL,
|
- |
|
283 |
`gu_prenom` varchar(100) collate utf8_unicode_ci NOT NULL,
|
- |
|
284 |
`gu_password` varchar(32) collate utf8_unicode_ci NOT NULL,
|
- |
|
285 |
`gu_email` varchar(255) collate utf8_unicode_ci NOT NULL,
|
- |
|
286 |
`gu_telephone` int(11) unsigned default NULL,
|
- |
|
287 |
`gu_adresse` varchar(255) collate utf8_unicode_ci default NULL,
|
- |
|
288 |
`gu_code_postal` int(11) unsigned default NULL,
|
- |
|
289 |
`gu_ville` varchar(50) collate utf8_unicode_ci default NULL,
|
- |
|
290 |
`gu_quota_heures_supp` float default NULL,
|
- |
|
291 |
`gu_conges_payes` float default NULL,
|
- |
|
292 |
`gu_temps_de_travail` float default NULL,
|
- |
|
293 |
`gu_mark_admin` tinyint(1) default NULL,
|
- |
|
294 |
`gu_mark_recapitulatif` tinyint(1) default NULL,
|
- |
|
295 |
`gu_notes` text collate utf8_unicode_ci,
|
- |
|
296 |
PRIMARY KEY (`gu_id_utilisateur`)
|
- |
|
297 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
- |
|
298 |
|
- |
|
299 |
--
|
- |
|
300 |
-- Contenu de la table `gestion_utilisateur`
|
- |
|
301 |
--
|
- |
|
302 |
|
- |
|
303 |
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);
|
- |
|
304 |
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');
|
- |
|
305 |
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, '');
|
- |
|
306 |
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, '');
|
- |
|
307 |
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);
|
- |
|
308 |
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.');
|
- |
|
309 |
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);
|
- |
|
310 |
INSERT INTO `gestion_utilisateur` VALUES (7, 0, 'Abdool Raheem', 'Shaheen', '6142a777667a67d568f674931389f0d9', 'shaheen@tela-botanica.org', 0, '--', 0, 'montpellier', 44, 3, 0, 0, 0, NULL);
|
- |
|
311 |
|
- |
|
312 |
-- --------------------------------------------------------
|
- |
|
313 |
|
- |
|
314 |
--
|
- |
|
315 |
-- Structure de la table `gestion_utilisateur_a_projet`
|
- |
|
316 |
--
|
- |
|
317 |
|
- |
|
318 |
CREATE TABLE `gestion_utilisateur_a_projet` (
|
- |
|
319 |
`guap_id_utilisateur` int(11) unsigned NOT NULL,
|
- |
|
320 |
`guap_id_projet` int(11) unsigned NOT NULL,
|
- |
|
321 |
PRIMARY KEY (`guap_id_utilisateur`,`guap_id_projet`)
|
- |
|
322 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
- |
|
323 |
|
- |
|
324 |
--
|
- |
|
325 |
-- Contenu de la table `gestion_utilisateur_a_projet`
|
- |
|
326 |
--
|
- |
|
327 |
|
- |
|
328 |
INSERT INTO `gestion_utilisateur_a_projet` VALUES (3, 9);
|
- |
|
329 |
INSERT INTO `gestion_utilisateur_a_projet` VALUES (3, 11);
|
- |
|
330 |
INSERT INTO `gestion_utilisateur_a_projet` VALUES (7, 10);
|
- |
|
331 |
INSERT INTO `gestion_utilisateur_a_projet` VALUES (7, 15);
|
- |
|
332 |
|
- |
|
333 |
-- --------------------------------------------------------
|
- |
|
334 |
|
- |
|
335 |
--
|
- |
|
336 |
-- Structure de la table `gestion_utilisateur_statut`
|
- |
|
337 |
--
|
- |
|
338 |
|
- |
|
339 |
CREATE TABLE `gestion_utilisateur_statut` (
|
- |
|
340 |
`gus_id_utilisateur_statut` tinyint(3) unsigned NOT NULL,
|
- |
|
341 |
`gus_libelle` varchar(255) collate utf8_unicode_ci NOT NULL,
|
- |
|
342 |
PRIMARY KEY (`gus_id_utilisateur_statut`)
|
- |
|
343 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
- |
|
344 |
|
- |
|
345 |
--
|
- |
|
346 |
-- Contenu de la table `gestion_utilisateur_statut`
|
- |
|
347 |
--
|
- |
|
348 |
|
- |
|
349 |
INSERT INTO `gestion_utilisateur_statut` VALUES (0, 'Stagiaire');
|
- |
|
350 |
INSERT INTO `gestion_utilisateur_statut` VALUES (1, 'Salarié');
|
- |
|
351 |
INSERT INTO `gestion_utilisateur_statut` VALUES (2, 'Président');
|
- |
|
352 |
|