Subversion Repositories Applications.gtt

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;