| Line 186... |
Line 186... |
| 186 |
--
|
186 |
--
|
| Line 187... |
Line 187... |
| 187 |
|
187 |
|
| 188 |
CREATE TABLE `gestion_projet_categorie` (
|
188 |
CREATE TABLE `gestion_projet_categorie` (
|
| 189 |
`gpc_id_categorie` int(11) unsigned NOT NULL,
|
189 |
`gpc_id_categorie` int(11) unsigned NOT NULL,
|
| - |
|
190 |
`gpc_libelle` varchar(255) collate utf8_unicode_ci NOT NULL,
|
| 190 |
`gpc_libelle` varchar(255) collate utf8_unicode_ci NOT NULL,
|
191 |
`gpc_abreviation` varchar(25) collate utf8_unicode_ci default NULL,
|
| 191 |
PRIMARY KEY (`gpc_id_categorie`)
|
192 |
PRIMARY KEY (`gpc_id_categorie`)
|
| Line 192... |
Line 193... |
| 192 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
193 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
| 193 |
|
194 |
|
| 194 |
--
|
195 |
--
|
| Line 195... |
Line 196... |
| 195 |
-- Contenu de la table `gestion_projet_categorie`
|
196 |
-- Contenu de la table `gestion_projet_categorie`
|
| 196 |
--
|
197 |
--
|
| 197 |
|
198 |
|
| 198 |
INSERT INTO `gestion_projet_categorie` VALUES (2, 'Fonctionnement interne');
|
199 |
INSERT INTO `gestion_projet_categorie` VALUES (2, 'Fonctionnement interne', NULL);
|
| 199 |
INSERT INTO `gestion_projet_categorie` VALUES (3, 'Site internet et outils coopératif');
|
200 |
INSERT INTO `gestion_projet_categorie` VALUES (3, 'Site internet et outils coopératif', NULL);
|
| 200 |
INSERT INTO `gestion_projet_categorie` VALUES (4, 'Animation');
|
201 |
INSERT INTO `gestion_projet_categorie` VALUES (4, 'Animation', NULL);
|
| Line 201... |
Line 202... |
| 201 |
INSERT INTO `gestion_projet_categorie` VALUES (5, 'Projets inclus convention MEDT');
|
202 |
INSERT INTO `gestion_projet_categorie` VALUES (5, 'Projets inclus convention MEDT', NULL);
|
| Line 202... |
Line 203... |
| 202 |
INSERT INTO `gestion_projet_categorie` VALUES (6, 'Projet hors convention');
|
203 |
INSERT INTO `gestion_projet_categorie` VALUES (6, 'Projet hors convention', NULL);
|
| 203 |
INSERT INTO `gestion_projet_categorie` VALUES (7, 'Services pour des tiers');
|
204 |
INSERT INTO `gestion_projet_categorie` VALUES (7, 'Services pour des tiers', NULL);
|
| Line 295... |
Line 296... |
| 295 |
`gu_ce_statut` tinyint(3) unsigned NOT NULL,
|
296 |
`gu_ce_statut` tinyint(3) unsigned NOT NULL,
|
| 296 |
`gu_nom` varchar(100) collate utf8_unicode_ci NOT NULL,
|
297 |
`gu_nom` varchar(100) collate utf8_unicode_ci NOT NULL,
|
| 297 |
`gu_prenom` varchar(100) collate utf8_unicode_ci NOT NULL,
|
298 |
`gu_prenom` varchar(100) collate utf8_unicode_ci NOT NULL,
|
| 298 |
`gu_password` varchar(32) collate utf8_unicode_ci NOT NULL,
|
299 |
`gu_password` varchar(32) collate utf8_unicode_ci NOT NULL,
|
| 299 |
`gu_email` varchar(255) collate utf8_unicode_ci NOT NULL,
|
300 |
`gu_email` varchar(255) collate utf8_unicode_ci NOT NULL,
|
| 300 |
`gu_telephone` varchar(20) collate utf8_unicode_ci NULL,
|
301 |
`gu_telephone` varchar(25) collate utf8_unicode_ci default NULL,
|
| 301 |
`gu_adresse` varchar(255) collate utf8_unicode_ci default NULL,
|
302 |
`gu_adresse` varchar(255) collate utf8_unicode_ci default NULL,
|
| 302 |
`gu_code_postal` varchar(6) collate utf8_unicode_ci NULL,
|
303 |
`gu_code_postal` varchar(6) collate utf8_unicode_ci default NULL,
|
| 303 |
`gu_ville` varchar(50) collate utf8_unicode_ci default NULL,
|
304 |
`gu_ville` varchar(50) collate utf8_unicode_ci default NULL,
|
| 304 |
`gu_quota_heures_supp` float default NULL,
|
305 |
`gu_quota_heures_supp` float default NULL,
|
| 305 |
`gu_conges_payes` float default NULL,
|
306 |
`gu_conges_payes` float default NULL,
|
| - |
|
307 |
`gu_temps_de_travail_jour` float default NULL,
|
| 306 |
`gu_temps_de_travail` float default NULL,
|
308 |
`gu_temps_de_travail_mois` float default NULL,
|
| 307 |
`gu_mark_admin` tinyint(1) default NULL,
|
309 |
`gu_mark_admin` tinyint(1) default NULL,
|
| 308 |
`gu_mark_recapitulatif` tinyint(1) default NULL,
|
310 |
`gu_mark_recapitulatif` tinyint(1) default NULL,
|
| 309 |
`gu_notes` text collate utf8_unicode_ci,
|
311 |
`gu_notes` text collate utf8_unicode_ci,
|
| 310 |
PRIMARY KEY (`gu_id_utilisateur`)
|
312 |
PRIMARY KEY (`gu_id_utilisateur`)
|
| 311 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
313 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|