10 |
jpm |
1 |
# phpMyAdmin SQL Dump
|
|
|
2 |
# version 2.5.6
|
|
|
3 |
# http://www.phpmyadmin.net
|
|
|
4 |
#
|
|
|
5 |
# Serveur: localhost
|
|
|
6 |
# Généré le : Mardi 22 Février 2005 à 10:37
|
|
|
7 |
# Version du serveur: 4.1.9
|
|
|
8 |
# Version de PHP: 4.3.10
|
|
|
9 |
#
|
|
|
10 |
# Base de données: `gestion_test_v3`
|
|
|
11 |
#
|
|
|
12 |
|
|
|
13 |
# --------------------------------------------------------
|
|
|
14 |
|
|
|
15 |
#
|
|
|
16 |
# Structure de la table `gestion_absence`
|
|
|
17 |
#
|
|
|
18 |
|
|
|
19 |
CREATE TABLE `gestion_absence` (
|
|
|
20 |
`gu_id_utilisateur` int(10) unsigned NOT NULL default '0',
|
|
|
21 |
`gma_id_motif` tinyint(3) unsigned NOT NULL default '0',
|
|
|
22 |
`ga_date_debut` date NOT NULL default '0000-00-00',
|
|
|
23 |
`ga_date_fin` date NOT NULL default '0000-00-00',
|
|
|
24 |
`ga_date_envoi_lettre` date NOT NULL default '0000-00-00',
|
|
|
25 |
PRIMARY KEY (`gu_id_utilisateur`,`gma_id_motif`,`ga_date_debut`)
|
|
|
26 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
27 |
|
|
|
28 |
#
|
|
|
29 |
# Contenu de la table `gestion_absence`
|
|
|
30 |
#
|
|
|
31 |
|
|
|
32 |
INSERT INTO `gestion_absence` VALUES (2, 0, '2003-01-02', '0000-00-00', '0000-00-00');
|
|
|
33 |
INSERT INTO `gestion_absence` VALUES (2, 0, '2003-01-03', '0000-00-00', '0000-00-00');
|
|
|
34 |
INSERT INTO `gestion_absence` VALUES (2, 0, '2003-04-23', '0000-00-00', '0000-00-00');
|
|
|
35 |
INSERT INTO `gestion_absence` VALUES (2, 0, '2003-04-24', '0000-00-00', '0000-00-00');
|
|
|
36 |
INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-11', '0000-00-00', '0000-00-00');
|
|
|
37 |
INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-12', '0000-00-00', '0000-00-00');
|
|
|
38 |
INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-13', '0000-00-00', '0000-00-00');
|
|
|
39 |
INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-14', '0000-00-00', '0000-00-00');
|
|
|
40 |
INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-18', '0000-00-00', '0000-00-00');
|
|
|
41 |
INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-19', '0000-00-00', '0000-00-00');
|
|
|
42 |
INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-20', '0000-00-00', '0000-00-00');
|
|
|
43 |
INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-21', '0000-00-00', '0000-00-00');
|
|
|
44 |
INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-22', '0000-00-00', '0000-00-00');
|
|
|
45 |
INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-25', '0000-00-00', '0000-00-00');
|
|
|
46 |
INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-26', '0000-00-00', '0000-00-00');
|
|
|
47 |
INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-27', '0000-00-00', '0000-00-00');
|
|
|
48 |
INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-28', '0000-00-00', '0000-00-00');
|
|
|
49 |
INSERT INTO `gestion_absence` VALUES (2, 0, '2003-08-29', '0000-00-00', '0000-00-00');
|
|
|
50 |
INSERT INTO `gestion_absence` VALUES (2, 1, '2003-05-02', '0000-00-00', '0000-00-00');
|
|
|
51 |
INSERT INTO `gestion_absence` VALUES (2, 1, '2003-05-09', '0000-00-00', '0000-00-00');
|
|
|
52 |
INSERT INTO `gestion_absence` VALUES (2, 1, '2003-05-30', '0000-00-00', '0000-00-00');
|
|
|
53 |
INSERT INTO `gestion_absence` VALUES (2, 1, '2003-07-28', '0000-00-00', '0000-00-00');
|
|
|
54 |
INSERT INTO `gestion_absence` VALUES (2, 4, '2003-01-01', '0000-00-00', '0000-00-00');
|
|
|
55 |
INSERT INTO `gestion_absence` VALUES (2, 4, '2003-04-21', '0000-00-00', '0000-00-00');
|
|
|
56 |
INSERT INTO `gestion_absence` VALUES (2, 4, '2003-05-01', '0000-00-00', '0000-00-00');
|
|
|
57 |
INSERT INTO `gestion_absence` VALUES (2, 4, '2003-05-08', '0000-00-00', '0000-00-00');
|
|
|
58 |
INSERT INTO `gestion_absence` VALUES (2, 4, '2003-05-29', '0000-00-00', '0000-00-00');
|
|
|
59 |
INSERT INTO `gestion_absence` VALUES (2, 4, '2003-07-14', '0000-00-00', '0000-00-00');
|
|
|
60 |
INSERT INTO `gestion_absence` VALUES (2, 4, '2003-08-15', '0000-00-00', '0000-00-00');
|
|
|
61 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-01-01', '0000-00-00', '0000-00-00');
|
|
|
62 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-01-02', '0000-00-00', '0000-00-00');
|
|
|
63 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-01-03', '0000-00-00', '0000-00-00');
|
|
|
64 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-04-11', '0000-00-00', '0000-00-00');
|
|
|
65 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-04-12', '0000-00-00', '0000-00-00');
|
|
|
66 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-04-13', '0000-00-00', '0000-00-00');
|
|
|
67 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-04-14', '0000-00-00', '0000-00-00');
|
|
|
68 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-04-15', '0000-00-00', '0000-00-00');
|
|
|
69 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-04-16', '0000-00-00', '0000-00-00');
|
|
|
70 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-04-17', '0000-00-00', '0000-00-00');
|
|
|
71 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-04-18', '0000-00-00', '0000-00-00');
|
|
|
72 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-16', '0000-00-00', '0000-00-00');
|
|
|
73 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-17', '0000-00-00', '0000-00-00');
|
|
|
74 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-18', '0000-00-00', '0000-00-00');
|
|
|
75 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-21', '0000-00-00', '0000-00-00');
|
|
|
76 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-22', '0000-00-00', '0000-00-00');
|
|
|
77 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-23', '0000-00-00', '0000-00-00');
|
|
|
78 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-24', '0000-00-00', '0000-00-00');
|
|
|
79 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-25', '0000-00-00', '0000-00-00');
|
|
|
80 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-27', '0000-00-00', '0000-00-00');
|
|
|
81 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-28', '0000-00-00', '0000-00-00');
|
|
|
82 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-29', '0000-00-00', '0000-00-00');
|
|
|
83 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-30', '0000-00-00', '0000-00-00');
|
|
|
84 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-07-31', '0000-00-00', '0000-00-00');
|
|
|
85 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-08-01', '0000-00-00', '0000-00-00');
|
|
|
86 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-08-04', '0000-00-00', '0000-00-00');
|
|
|
87 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-08-05', '0000-00-00', '0000-00-00');
|
|
|
88 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-08-06', '0000-00-00', '0000-00-00');
|
|
|
89 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-08-07', '0000-00-00', '0000-00-00');
|
|
|
90 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-08-08', '0000-00-00', '0000-00-00');
|
|
|
91 |
INSERT INTO `gestion_absence` VALUES (3, 0, '2003-08-11', '0000-00-00', '0000-00-00');
|
|
|
92 |
INSERT INTO `gestion_absence` VALUES (3, 1, '2003-05-02', '0000-00-00', '0000-00-00');
|
|
|
93 |
INSERT INTO `gestion_absence` VALUES (3, 1, '2003-05-09', '0000-00-00', '0000-00-00');
|
|
|
94 |
INSERT INTO `gestion_absence` VALUES (3, 1, '2003-06-06', '0000-00-00', '0000-00-00');
|
|
|
95 |
INSERT INTO `gestion_absence` VALUES (3, 1, '2003-08-12', '0000-00-00', '0000-00-00');
|
|
|
96 |
INSERT INTO `gestion_absence` VALUES (3, 1, '2003-08-13', '0000-00-00', '0000-00-00');
|
|
|
97 |
INSERT INTO `gestion_absence` VALUES (3, 1, '2003-08-14', '0000-00-00', '0000-00-00');
|
|
|
98 |
INSERT INTO `gestion_absence` VALUES (3, 4, '2003-04-21', '0000-00-00', '0000-00-00');
|
|
|
99 |
INSERT INTO `gestion_absence` VALUES (3, 4, '2003-05-01', '0000-00-00', '0000-00-00');
|
|
|
100 |
INSERT INTO `gestion_absence` VALUES (3, 4, '2003-05-08', '0000-00-00', '0000-00-00');
|
|
|
101 |
INSERT INTO `gestion_absence` VALUES (3, 4, '2003-05-29', '0000-00-00', '0000-00-00');
|
|
|
102 |
INSERT INTO `gestion_absence` VALUES (3, 4, '2003-06-09', '0000-00-00', '0000-00-00');
|
|
|
103 |
INSERT INTO `gestion_absence` VALUES (3, 4, '2003-07-14', '0000-00-00', '0000-00-00');
|
|
|
104 |
INSERT INTO `gestion_absence` VALUES (3, 4, '2003-08-15', '0000-00-00', '0000-00-00');
|
|
|
105 |
|
|
|
106 |
# --------------------------------------------------------
|
|
|
107 |
|
|
|
108 |
#
|
|
|
109 |
# Structure de la table `gestion_categorie`
|
|
|
110 |
#
|
|
|
111 |
|
|
|
112 |
CREATE TABLE `gestion_categorie` (
|
|
|
113 |
`gc_id_categorie` int(10) unsigned NOT NULL default '0',
|
|
|
114 |
`gc_libelle_categorie` varchar(255) default NULL,
|
|
|
115 |
PRIMARY KEY (`gc_id_categorie`),
|
|
|
116 |
UNIQUE KEY `gc_libelle_categorie` (`gc_libelle_categorie`)
|
|
|
117 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
118 |
|
|
|
119 |
#
|
|
|
120 |
# Contenu de la table `gestion_categorie`
|
|
|
121 |
#
|
|
|
122 |
|
|
|
123 |
INSERT INTO `gestion_categorie` VALUES (5, 'Projets inclus convention MEDT');
|
|
|
124 |
INSERT INTO `gestion_categorie` VALUES (2, 'Fonctionnement interne');
|
|
|
125 |
INSERT INTO `gestion_categorie` VALUES (3, 'Site internet et outils coopératif');
|
|
|
126 |
INSERT INTO `gestion_categorie` VALUES (4, 'Animation');
|
|
|
127 |
INSERT INTO `gestion_categorie` VALUES (6, 'Projet hors convention');
|
|
|
128 |
INSERT INTO `gestion_categorie` VALUES (7, 'Services pour des tiers');
|
|
|
129 |
|
|
|
130 |
# --------------------------------------------------------
|
|
|
131 |
|
|
|
132 |
#
|
|
|
133 |
# Structure de la table `gestion_composer_utilisateur_frais_kilometrique`
|
|
|
134 |
#
|
|
|
135 |
|
|
|
136 |
CREATE TABLE `gestion_composer_utilisateur_frais_kilometrique` (
|
|
|
137 |
`gcufk_id_frais_kilometrique` int(10) unsigned NOT NULL default '0',
|
|
|
138 |
`gcufk_id_utilisateur` int(10) unsigned NOT NULL default '0',
|
|
|
139 |
`gcufk_date_frais` date NOT NULL default '0000-00-00',
|
|
|
140 |
`gcufk_nb_kilometre` float default NULL,
|
|
|
141 |
`gcufk_objet` varchar(255) default NULL,
|
|
|
142 |
`gcufk_trajet` varchar(255) default NULL,
|
|
|
143 |
`gcufk_montant_total` float NOT NULL default '0',
|
|
|
144 |
PRIMARY KEY (`gcufk_id_frais_kilometrique`,`gcufk_id_utilisateur`,`gcufk_date_frais`)
|
|
|
145 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
146 |
|
|
|
147 |
#
|
|
|
148 |
# Contenu de la table `gestion_composer_utilisateur_frais_kilometrique`
|
|
|
149 |
#
|
|
|
150 |
|
|
|
151 |
|
|
|
152 |
# --------------------------------------------------------
|
|
|
153 |
|
|
|
154 |
#
|
|
|
155 |
# Structure de la table `gestion_depense`
|
|
|
156 |
#
|
|
|
157 |
|
|
|
158 |
CREATE TABLE `gestion_depense` (
|
|
|
159 |
`gu_id_utilisateur` int(10) unsigned NOT NULL default '0',
|
|
|
160 |
`gnf_id_frais` int(10) unsigned NOT NULL default '0',
|
|
|
161 |
`gd_date_depense` date NOT NULL default '0000-00-00',
|
|
|
162 |
`gd_montant_ht` float default NULL,
|
|
|
163 |
`gd_montant_ttc` float NOT NULL default '0',
|
|
|
164 |
PRIMARY KEY (`gu_id_utilisateur`,`gnf_id_frais`,`gd_date_depense`)
|
|
|
165 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
166 |
|
|
|
167 |
#
|
|
|
168 |
# Contenu de la table `gestion_depense`
|
|
|
169 |
#
|
|
|
170 |
|
|
|
171 |
|
|
|
172 |
# --------------------------------------------------------
|
|
|
173 |
|
|
|
174 |
#
|
|
|
175 |
# Structure de la table `gestion_frais_kilometrique`
|
|
|
176 |
#
|
|
|
177 |
|
|
|
178 |
CREATE TABLE `gestion_frais_kilometrique` (
|
|
|
179 |
`gfk_id_frais_kilometrique` int(10) unsigned NOT NULL default '0',
|
|
|
180 |
`gfk_taux_kilometre` float NOT NULL default '0',
|
|
|
181 |
PRIMARY KEY (`gfk_id_frais_kilometrique`)
|
|
|
182 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
183 |
|
|
|
184 |
#
|
|
|
185 |
# Contenu de la table `gestion_frais_kilometrique`
|
|
|
186 |
#
|
|
|
187 |
|
|
|
188 |
|
|
|
189 |
# --------------------------------------------------------
|
|
|
190 |
|
|
|
191 |
#
|
|
|
192 |
# Structure de la table `gestion_motif_absence`
|
|
|
193 |
#
|
|
|
194 |
|
|
|
195 |
CREATE TABLE `gestion_motif_absence` (
|
|
|
196 |
`gma_id_motif` tinyint(3) unsigned NOT NULL default '0',
|
|
|
197 |
`gma_libelle_motif` varchar(255) NOT NULL default '',
|
|
|
198 |
`gma_nb_heures_supprim` float default NULL,
|
|
|
199 |
`gma_type_rtt` char(1) NOT NULL default '',
|
|
|
200 |
PRIMARY KEY (`gma_id_motif`),
|
|
|
201 |
UNIQUE KEY `gma_libelle_motif` (`gma_libelle_motif`)
|
|
|
202 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
203 |
|
|
|
204 |
#
|
|
|
205 |
# Contenu de la table `gestion_motif_absence`
|
|
|
206 |
#
|
|
|
207 |
|
|
|
208 |
INSERT INTO `gestion_motif_absence` VALUES (0, 'Congés Payés', '1', '0');
|
|
|
209 |
INSERT INTO `gestion_motif_absence` VALUES (1, 'Récupération', '1', '1');
|
|
|
210 |
INSERT INTO `gestion_motif_absence` VALUES (2, 'Maladie', '1', '0');
|
|
|
211 |
INSERT INTO `gestion_motif_absence` VALUES (3, 'Grêve', '1', '1');
|
|
|
212 |
INSERT INTO `gestion_motif_absence` VALUES (4, 'Ferié', '1', '0');
|
|
|
213 |
INSERT INTO `gestion_motif_absence` VALUES (5, 'Récup part:1/2j', '0.5', '0');
|
|
|
214 |
|
|
|
215 |
# --------------------------------------------------------
|
|
|
216 |
|
|
|
217 |
#
|
|
|
218 |
# Structure de la table `gestion_note_frais`
|
|
|
219 |
#
|
|
|
220 |
|
|
|
221 |
CREATE TABLE `gestion_note_frais` (
|
|
|
222 |
`gnf_id_frais` int(10) unsigned NOT NULL default '0',
|
|
|
223 |
`gnf_libelle_frais` varchar(255) NOT NULL default '',
|
|
|
224 |
PRIMARY KEY (`gnf_id_frais`)
|
|
|
225 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
226 |
|
|
|
227 |
#
|
|
|
228 |
# Contenu de la table `gestion_note_frais`
|
|
|
229 |
#
|
|
|
230 |
|
|
|
231 |
|
|
|
232 |
# --------------------------------------------------------
|
|
|
233 |
|
|
|
234 |
#
|
|
|
235 |
# Structure de la table `gestion_predecesseurs`
|
|
|
236 |
#
|
|
|
237 |
|
|
|
238 |
CREATE TABLE `gestion_predecesseurs` (
|
|
|
239 |
`gt_id_tache` int(10) unsigned NOT NULL default '0',
|
|
|
240 |
`gpred_id_pred` int(10) unsigned NOT NULL default '0',
|
|
|
241 |
PRIMARY KEY (`gt_id_tache`,`gpred_id_pred`)
|
|
|
242 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
243 |
|
|
|
244 |
#
|
|
|
245 |
# Contenu de la table `gestion_predecesseurs`
|
|
|
246 |
#
|
|
|
247 |
|
|
|
248 |
|
|
|
249 |
# --------------------------------------------------------
|
|
|
250 |
|
|
|
251 |
#
|
|
|
252 |
# Structure de la table `gestion_preferences`
|
|
|
253 |
#
|
|
|
254 |
|
|
|
255 |
CREATE TABLE `gestion_preferences` (
|
|
|
256 |
`gu_id_utilisateur` int(10) unsigned NOT NULL default '0',
|
|
|
257 |
`gp_id_projet` int(10) unsigned NOT NULL default '0',
|
|
|
258 |
PRIMARY KEY (`gu_id_utilisateur`,`gp_id_projet`)
|
|
|
259 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
260 |
|
|
|
261 |
#
|
|
|
262 |
# Contenu de la table `gestion_preferences`
|
|
|
263 |
#
|
|
|
264 |
|
|
|
265 |
INSERT INTO `gestion_preferences` VALUES (7, 10);
|
|
|
266 |
INSERT INTO `gestion_preferences` VALUES (7, 15);
|
|
|
267 |
|
|
|
268 |
# --------------------------------------------------------
|
|
|
269 |
|
|
|
270 |
#
|
|
|
271 |
# Structure de la table `gestion_prevision_tache`
|
|
|
272 |
#
|
|
|
273 |
|
|
|
274 |
CREATE TABLE `gestion_prevision_tache` (
|
|
|
275 |
`gu_id_utilisateur` int(10) unsigned NOT NULL default '0',
|
|
|
276 |
`gt_id_tache` int(10) unsigned NOT NULL default '0',
|
|
|
277 |
`gpt_date_prevision` date NOT NULL default '0000-00-00',
|
|
|
278 |
`gpt_duree_prevision` float NOT NULL default '0',
|
|
|
279 |
PRIMARY KEY (`gu_id_utilisateur`,`gt_id_tache`,`gpt_date_prevision`)
|
|
|
280 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
281 |
|
|
|
282 |
#
|
|
|
283 |
# Contenu de la table `gestion_prevision_tache`
|
|
|
284 |
#
|
|
|
285 |
|
|
|
286 |
|
|
|
287 |
# --------------------------------------------------------
|
|
|
288 |
|
|
|
289 |
#
|
|
|
290 |
# Structure de la table `gestion_projet`
|
|
|
291 |
#
|
|
|
292 |
|
|
|
293 |
CREATE TABLE `gestion_projet` (
|
|
|
294 |
`gp_id_projet` int(10) unsigned NOT NULL default '0',
|
|
|
295 |
`gc_id_categorie` int(10) unsigned NOT NULL default '0',
|
|
|
296 |
`gp_nom_projet` varchar(255) NOT NULL default '',
|
|
|
297 |
`gp_description` varchar(255) default NULL,
|
|
|
298 |
`gp_date_debut` date default NULL,
|
|
|
299 |
`gp_duree_prevue` float default NULL,
|
|
|
300 |
`gp_avancement` int(11) default NULL,
|
|
|
301 |
PRIMARY KEY (`gp_id_projet`),
|
|
|
302 |
UNIQUE KEY `gp_nom_projet` (`gp_nom_projet`)
|
|
|
303 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
304 |
|
|
|
305 |
#
|
|
|
306 |
# Contenu de la table `gestion_projet`
|
|
|
307 |
#
|
|
|
308 |
|
|
|
309 |
INSERT INTO `gestion_projet` VALUES (11, 2, 'Comptablilité', '', NULL, NULL, NULL);
|
|
|
310 |
INSERT INTO `gestion_projet` VALUES (9, 2, 'Formation stagiaire', '', NULL, NULL, NULL);
|
|
|
311 |
INSERT INTO `gestion_projet` VALUES (10, 2, 'Gestion interne', '', NULL, NULL, NULL);
|
|
|
312 |
INSERT INTO `gestion_projet` VALUES (3, 6, 'Base de données nomenclaturale', '', NULL, NULL, NULL);
|
|
|
313 |
INSERT INTO `gestion_projet` VALUES (4, 6, 'Index des bryophytes', '', NULL, NULL, NULL);
|
|
|
314 |
INSERT INTO `gestion_projet` VALUES (5, 6, 'Index des plantes de la Réunion', '', NULL, NULL, NULL);
|
|
|
315 |
INSERT INTO `gestion_projet` VALUES (6, 6, 'Plantes envahissantes', '', NULL, NULL, NULL);
|
|
|
316 |
INSERT INTO `gestion_projet` VALUES (7, 7, 'Projet FEEE planetere', '', NULL, NULL, NULL);
|
|
|
317 |
INSERT INTO `gestion_projet` VALUES (8, 7, 'projet FEEE - YRE', '', NULL, NULL, NULL);
|
|
|
318 |
INSERT INTO `gestion_projet` VALUES (12, 2, 'Déplacement', '', NULL, NULL, NULL);
|
|
|
319 |
INSERT INTO `gestion_projet` VALUES (13, 2, 'Formation', '', NULL, NULL, NULL);
|
|
|
320 |
INSERT INTO `gestion_projet` VALUES (14, 2, 'Autres', '', NULL, NULL, NULL);
|
|
|
321 |
INSERT INTO `gestion_projet` VALUES (15, 3, 'Développement', '', NULL, NULL, NULL);
|
|
|
322 |
INSERT INTO `gestion_projet` VALUES (16, 3, 'Contenu du site', '', NULL, NULL, NULL);
|
|
|
323 |
INSERT INTO `gestion_projet` VALUES (17, 3, 'Autre', '', NULL, NULL, NULL);
|
|
|
324 |
INSERT INTO `gestion_projet` VALUES (18, 5, 'Flore éléctronique', '', NULL, NULL, NULL);
|
|
|
325 |
INSERT INTO `gestion_projet` VALUES (19, 5, 'Apprendre la botanique sur internet', '', NULL, NULL, NULL);
|
|
|
326 |
INSERT INTO `gestion_projet` VALUES (20, 6, 'Inventaire des herbiers de France', '', NULL, NULL, NULL);
|
|
|
327 |
INSERT INTO `gestion_projet` VALUES (21, 3, 'Maintenance informatique', '', NULL, NULL, NULL);
|
|
|
328 |
INSERT INTO `gestion_projet` VALUES (22, 4, 'Animation adhérent', '', NULL, NULL, NULL);
|
|
|
329 |
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);
|
|
|
330 |
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);
|
|
|
331 |
|
|
|
332 |
# --------------------------------------------------------
|
|
|
333 |
|
|
|
334 |
#
|
|
|
335 |
# Structure de la table `gestion_statut`
|
|
|
336 |
#
|
|
|
337 |
|
|
|
338 |
CREATE TABLE `gestion_statut` (
|
|
|
339 |
`gs_id_statut` tinyint(3) unsigned NOT NULL default '0',
|
|
|
340 |
`gs_libelle_statut` varchar(255) NOT NULL default '',
|
|
|
341 |
PRIMARY KEY (`gs_id_statut`),
|
|
|
342 |
UNIQUE KEY `gs_libelle_statut` (`gs_libelle_statut`)
|
|
|
343 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
344 |
|
|
|
345 |
#
|
|
|
346 |
# Contenu de la table `gestion_statut`
|
|
|
347 |
#
|
|
|
348 |
|
|
|
349 |
INSERT INTO `gestion_statut` VALUES (0, 'Stagiaire');
|
|
|
350 |
INSERT INTO `gestion_statut` VALUES (1, 'Salarié');
|
|
|
351 |
INSERT INTO `gestion_statut` VALUES (2, 'Président');
|
|
|
352 |
|
|
|
353 |
# --------------------------------------------------------
|
|
|
354 |
|
|
|
355 |
#
|
|
|
356 |
# Structure de la table `gestion_taches`
|
|
|
357 |
#
|
|
|
358 |
|
|
|
359 |
CREATE TABLE `gestion_taches` (
|
|
|
360 |
`gt_id_tache` int(10) unsigned NOT NULL default '0',
|
|
|
361 |
`gp_id_projet` int(10) unsigned NOT NULL default '0',
|
|
|
362 |
`gt_nom_tache` varchar(255) NOT NULL default '',
|
|
|
363 |
`gt_description_tache` varchar(255) default NULL,
|
|
|
364 |
`gt_date_debut_tache` date default NULL,
|
|
|
365 |
`gt_duree_prevue` int(10) unsigned default NULL,
|
|
|
366 |
`gt_avancement` int(11) default NULL,
|
|
|
367 |
`gt_duree_reelle_tache` int(11) default NULL,
|
|
|
368 |
PRIMARY KEY (`gt_id_tache`)
|
|
|
369 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
370 |
|
|
|
371 |
#
|
|
|
372 |
# Contenu de la table `gestion_taches`
|
|
|
373 |
#
|
|
|
374 |
|
|
|
375 |
INSERT INTO `gestion_taches` VALUES (1, 10, 'général', NULL, NULL, NULL, NULL, NULL);
|
|
|
376 |
INSERT INTO `gestion_taches` VALUES (2, 15, 'général', NULL, NULL, NULL, NULL, NULL);
|
|
|
377 |
|
|
|
378 |
# --------------------------------------------------------
|
|
|
379 |
|
|
|
380 |
#
|
|
|
381 |
# Structure de la table `gestion_travail`
|
|
|
382 |
#
|
|
|
383 |
|
|
|
384 |
CREATE TABLE `gestion_travail` (
|
|
|
385 |
`gt_id_tache` int(10) unsigned NOT NULL default '0',
|
|
|
386 |
`gu_id_utilisateur` int(10) unsigned NOT NULL default '0',
|
|
|
387 |
`gt_date_travail` date NOT NULL default '0000-00-00',
|
|
|
388 |
`gt_duree_travail` float NOT NULL default '0',
|
|
|
389 |
PRIMARY KEY (`gt_id_tache`,`gu_id_utilisateur`,`gt_date_travail`)
|
|
|
390 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
391 |
|
|
|
392 |
#
|
|
|
393 |
# Contenu de la table `gestion_travail`
|
|
|
394 |
#
|
|
|
395 |
|
|
|
396 |
INSERT INTO `gestion_travail` VALUES (14, 3, '2003-04-23', '3');
|
|
|
397 |
INSERT INTO `gestion_travail` VALUES (18, 3, '2003-04-23', '3.75');
|
|
|
398 |
INSERT INTO `gestion_travail` VALUES (22, 3, '2003-04-23', '1');
|
|
|
399 |
INSERT INTO `gestion_travail` VALUES (18, 3, '2003-04-24', '7');
|
|
|
400 |
INSERT INTO `gestion_travail` VALUES (22, 3, '2003-04-24', '1');
|
|
|
401 |
INSERT INTO `gestion_travail` VALUES (18, 3, '2003-04-25', '3.75');
|
|
|
402 |
INSERT INTO `gestion_travail` VALUES (22, 3, '2003-04-25', '0.75');
|
|
|
403 |
INSERT INTO `gestion_travail` VALUES (25, 3, '2003-04-25', '2.75');
|
|
|
404 |
INSERT INTO `gestion_travail` VALUES (18, 3, '2003-04-28', '6.5');
|
|
|
405 |
|
|
|
406 |
# --------------------------------------------------------
|
|
|
407 |
|
|
|
408 |
#
|
|
|
409 |
# Structure de la table `gestion_utilisateur`
|
|
|
410 |
#
|
|
|
411 |
|
|
|
412 |
CREATE TABLE `gestion_utilisateur` (
|
|
|
413 |
`gu_id_utilisateur` int(10) unsigned NOT NULL default '0',
|
|
|
414 |
`gs_id_statut` tinyint(3) unsigned NOT NULL default '0',
|
|
|
415 |
`gu_nom` varchar(255) NOT NULL default '',
|
|
|
416 |
`gu_prenom` varchar(255) NOT NULL default '',
|
|
|
417 |
`gu_password` varchar(255) NOT NULL default '',
|
|
|
418 |
`gu_email` varchar(255) NOT NULL default '',
|
|
|
419 |
`gu_telephone` int(10) unsigned default NULL,
|
|
|
420 |
`gu_adresse` varchar(255) default NULL,
|
|
|
421 |
`gu_code_postal` int(10) unsigned default NULL,
|
|
|
422 |
`gu_ville` varchar(255) default NULL,
|
|
|
423 |
`gu_quota_heures_supp` float default NULL,
|
|
|
424 |
`gu_conges_payes` float default NULL,
|
|
|
425 |
`gu_temps_de_travail` float default NULL,
|
|
|
426 |
`gu_admin` tinyint(3) unsigned default NULL,
|
|
|
427 |
`gu_admin2` tinyint(3) unsigned default NULL,
|
|
|
428 |
`gu_notes` varchar(255) default NULL,
|
|
|
429 |
PRIMARY KEY (`gu_id_utilisateur`),
|
|
|
430 |
UNIQUE KEY `gu_email` (`gu_email`)
|
|
|
431 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
432 |
|
|
|
433 |
#
|
|
|
434 |
# Contenu de la table `gestion_utilisateur`
|
|
|
435 |
#
|
|
|
436 |
|
|
|
437 |
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');
|
|
|
438 |
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);
|
|
|
439 |
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, '');
|
|
|
440 |
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);
|
|
|
441 |
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);
|
|
|
442 |
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);
|
|
|
443 |
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.');
|
|
|
444 |
INSERT INTO `gestion_utilisateur` VALUES (7, 0, 'Abdool Raheem', 'Shaheen', '6142a777667a67d568f674931389f0d9', 'shaheen@tela-botanica.org', 0, '--', 0, 'montpellier', '44', '3', '0', 0, 0, NULL);
|