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