| New file |
|---|
| 0,0 → 1,41 |
|---|
| ALTER TABLE gestion_v4.`gestion_absence` CHANGE `ga_id_abscence` `ga_id_abscence` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT ; |
| INSERT INTO gestion_v4.gestion_absence |
| ( ga_ce_absence_motif, ga_ce_utilisateur, ga_date_debut, ga_date_fin, ga_date_envoi_lettre ) |
| SELECT gma_id_motif, gu_id_utilisateur, ga_date_debut, ga_date_fin, ga_date_envoi_lettre FROM gestion_v3.gestion_absence; |
| ALTER TABLE gestion_v4.`gestion_absence` CHANGE `ga_id_abscence` `ga_id_abscence` INT( 11 ) UNSIGNED NOT NULL ; |
| |
| INSERT INTO gestion_v4.gestion_absence_motif |
| SELECT gma_id_motif, gma_libelle_motif, gma_type_rtt, (gma_nb_heures_supprim * 7) FROM gestion_v3.gestion_motif_absence; |
| |
| INSERT INTO gestion_v4.gestion_projet |
| SELECT gp_id_projet, gc_id_categorie, gp_nom_projet, gp_description, gp_date_debut, gp_duree_prevue, gp_avancement FROM gestion_v3.gestion_projet; |
| ALTER TABLE gestion_v4.`gestion_projet` ORDER BY `gp_id_projet` ; |
| |
| INSERT INTO gestion_v4.gestion_projet_categorie |
| ( gpc_id_categorie, gpc_libelle ) |
| SELECT gc_id_categorie, gc_libelle_categorie FROM gestion_v3.gestion_categorie; |
| ALTER TABLE gestion_v4.`gestion_projet_categorie` ORDER BY `gpc_id_categorie` ; |
| |
| INSERT INTO gestion_v4.gestion_projet_tache |
| ( gpt_id_tache, gpt_ce_projet, gpt_libelle, gpt_description, gpt_date_debut, gpt_duree_prevue, gpt_avancement) |
| SELECT gt.gt_id_tache, gt.gp_id_projet, REPLACE(gt.gt_nom_tache,'é','é'), IFNULL(gt.gt_description_tache,''), gt.gt_date_debut_tache, gt.gt_duree_prevue, gt.gt_avancement |
| FROM gestion_v3.gestion_taches AS gt ; |
| REPLACE gestion_v4.gestion_projet_tache |
| ( gpt_id_tache, gpt_ce_tache_precedente, gpt_ce_projet, gpt_libelle, gpt_description, gpt_date_debut, gpt_duree_prevue, gpt_avancement) |
| SELECT gt.gt_id_tache, gp.gpred_id_pred, gt.gp_id_projet, REPLACE(gt.gt_nom_tache,'é','é'), IFNULL(gt.gt_description_tache,''), gt.gt_date_debut_tache, gt.gt_duree_prevue, gt.gt_avancement |
| FROM gestion_v3.gestion_taches AS gt, gestion_v3.gestion_predecesseurs AS gp |
| WHERE gt.gt_id_tache = gp.gt_id_tache; |
| |
| INSERT INTO gestion_v4.gestion_travail_projet |
| SELECT gu_id_utilisateur, gt_id_tache, gt_date_travail, gt_duree_travail FROM gestion_v3.gestion_travail; |
| |
| INSERT INTO gestion_v4.gestion_utilisateur |
| SELECT gu_id_utilisateur, gs_id_statut, gu_nom, gu_prenom, gu_password, gu_email, gu_telephone, gu_adresse, gu_code_postal, gu_ville, gu_quota_heures_supp, gu_conges_payes, gu_temps_de_travail, gu_admin, gu_admin2, gu_notes |
| FROM gestion_v3.gestion_utilisateur; |
| ALTER TABLE gestion_v4.`gestion_utilisateur` ORDER BY `gu_id_utilisateur` ; |
| |
| INSERT INTO gestion_v4.gestion_utilisateur_a_projet |
| SELECT gp_id_utilisateur, gp_id_projet FROM gestion_v3.gestion_preferences; |
| |
| INSERT INTO gestion_v4.gestion_utilisateur_statut |
| SELECT gs_id_statut, gs_libelle_statut FROM gestion_v3.gestion_statut; |