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;
|