188,6 → 188,7 |
CREATE TABLE `gestion_projet_categorie` ( |
`gpc_id_categorie` int(11) unsigned NOT NULL, |
`gpc_libelle` varchar(255) collate utf8_unicode_ci NOT NULL, |
`gpc_abreviation` varchar(25) collate utf8_unicode_ci default NULL, |
PRIMARY KEY (`gpc_id_categorie`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
195,12 → 196,12 |
-- Contenu de la table `gestion_projet_categorie` |
-- |
|
INSERT INTO `gestion_projet_categorie` VALUES (2, 'Fonctionnement interne'); |
INSERT INTO `gestion_projet_categorie` VALUES (3, 'Site internet et outils coopératif'); |
INSERT INTO `gestion_projet_categorie` VALUES (4, 'Animation'); |
INSERT INTO `gestion_projet_categorie` VALUES (5, 'Projets inclus convention MEDT'); |
INSERT INTO `gestion_projet_categorie` VALUES (6, 'Projet hors convention'); |
INSERT INTO `gestion_projet_categorie` VALUES (7, 'Services pour des tiers'); |
INSERT INTO `gestion_projet_categorie` VALUES (2, 'Fonctionnement interne', NULL); |
INSERT INTO `gestion_projet_categorie` VALUES (3, 'Site internet et outils coopératif', NULL); |
INSERT INTO `gestion_projet_categorie` VALUES (4, 'Animation', NULL); |
INSERT INTO `gestion_projet_categorie` VALUES (5, 'Projets inclus convention MEDT', NULL); |
INSERT INTO `gestion_projet_categorie` VALUES (6, 'Projet hors convention', NULL); |
INSERT INTO `gestion_projet_categorie` VALUES (7, 'Services pour des tiers', NULL); |
|
-- -------------------------------------------------------- |
|
297,13 → 298,14 |
`gu_prenom` varchar(100) collate utf8_unicode_ci NOT NULL, |
`gu_password` varchar(32) collate utf8_unicode_ci NOT NULL, |
`gu_email` varchar(255) collate utf8_unicode_ci NOT NULL, |
`gu_telephone` varchar(20) collate utf8_unicode_ci NULL, |
`gu_telephone` varchar(25) collate utf8_unicode_ci default NULL, |
`gu_adresse` varchar(255) collate utf8_unicode_ci default NULL, |
`gu_code_postal` varchar(6) collate utf8_unicode_ci NULL, |
`gu_code_postal` varchar(6) collate utf8_unicode_ci default NULL, |
`gu_ville` varchar(50) collate utf8_unicode_ci default NULL, |
`gu_quota_heures_supp` float default NULL, |
`gu_conges_payes` float default NULL, |
`gu_temps_de_travail` float default NULL, |
`gu_temps_de_travail_jour` float default NULL, |
`gu_temps_de_travail_mois` float default NULL, |
`gu_mark_admin` tinyint(1) default NULL, |
`gu_mark_recapitulatif` tinyint(1) default NULL, |
`gu_notes` text collate utf8_unicode_ci, |