| 31,13 → 31,13 |
|---|
| #---------------------------------------------------------------------------------------------------------------------# |
| # EFLORE_PROJET vers coel_projet |
| # Insertion du projet Inventaire des Herbiers de France - Version 1 |
| INSERT INTO tb_coel.coel_projet (cpr_id_projet, cpr_nom, cpr_abreviation, cpr_description, cpr_url, cpr_autorisation, cpr_ce_meta) |
| INSERT INTO tb_coel.coel_projet (cpr_id_projet, cpr_nom, cpr_abreviation, cpr_description, cpr_url, cpr_mark_autorisation, cpr_ce_meta) |
| SELECT 2, CONVERT(EPR_INTITULE_PROJET USING utf8), CONVERT(EPR_ABREVIATION_PROJET USING utf8), CONVERT(EPR_DESCRIPTION_PROJET USING utf8), EPR_LIEN_WEB, 1, @idm |
| FROM tb_herbiers.EFLORE_PROJET; |
| INSERT INTO tb_coel.coel_meta_historique_ligne (cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement, cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip) |
| VALUES (@idm := @idm+1, '115', '2', NULL , NOW( ) , 'Ajout du projet IHF', '1', '1', '162.38.234.1'); |
| # Insertion du projet Utilisateur de l''application COEL - Version 1 |
| INSERT INTO tb_coel.coel_projet (cpr_id_projet, cpr_nom, cpr_abreviation, cpr_description, cpr_url, cpr_autorisation, cpr_ce_meta) |
| INSERT INTO tb_coel.coel_projet (cpr_id_projet, cpr_nom, cpr_abreviation, cpr_description, cpr_url, cpr_mark_autorisation, cpr_ce_meta) |
| VALUES (3, 'Utilisateurs', 'COEL-U', 'Les utilisateurs de l''application COEL.', NULL, 0, @idm); |
| INSERT INTO tb_coel.coel_meta_historique_ligne (cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement, cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip) |
| VALUES (@idm := @idm+1, '115', '2', NULL , NOW( ) , 'Ajout du projet U', '1', '1', '162.38.234.1'); |
| 252,7 → 252,7 |
|---|
| #HERBIER_COLLECTION vers coel_collection |
| INSERT INTO tb_coel.coel_collection |
| (cc_id_collection, cc_ce_projet, cc_ce_structure, cc_guid, cc_truk_code, cc_nom, cc_description, |
| cc_truk_type_depot, |
| cc_ce_type_depot, |
| cc_ce_specimen_type, |
| cc_description_specialiste, cc_truk_url, |
| cc_specimen_type_nbre, |
| 269,6 → 269,16 |
|---|
| WHERE hc.ID != 4 |
| GROUP BY hc.ID |
| ORDER BY hc.ID ASC; |
| INSERT INTO tb_coel.coel_meta_historique_ligne |
| (cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement, |
| cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat, cmhl_ip) |
| SELECT @idm_tmp := @idm_tmp+1, '101', ID, NULL, |
| IF(DATE_DERNIERE_MODIF != '0000-00-00 00:00:00', DATE_DERNIERE_MODIF, NOW()) , CONCAT('Ajout de la collection #',ID,' de la table HERBIER_COLLECTION.'), IF(CE_MODIFIER_PAR != '0', CE_MODIFIER_PAR, '1'), '1', IF(CE_MODIFIER_PAR != '0', NULL, '162.38.234.1') |
| FROM tb_herbiers.HERBIERS_COLLECTION |
| WHERE ID != 4 |
| ORDER BY ID ASC; |
| #------------------------------------------------------------------------------------------------------------------------ |
| #HERBIER_COLLECTION vers coel_collection_botanique |
| INSERT INTO tb_coel.coel_collection_botanique |
| (ccb_id_collection, ccb_truk_unite_base, |
| ccb_recolte_date_debut, ccb_ce_recolte_date_debut_type, ccb_recolte_date_fin, ccb_ce_recolte_date_fin_type, |
| 275,7 → 285,8 |
|---|
| ccb_inventaire_digital_pourcent, ccb_ce_classement_etat, |
| ccb_truk_degradation_specimen, |
| ccb_truk_degradation_presentation, |
| ccb_annotation_classement) |
| ccb_annotation_classement, |
| ccb_ce_meta) |
| SELECT ID, CONCAT('TOTAL#0|NULL|NULL|',NUM_SPECIMENS,'|', IF(PREC_SPECIMENS = '1', '0', IF(PREC_SPECIMENS = '2', '1', IF(PREC_SPECIMENS = '3', '?', 'NULL'))), '|', NUM_SPECIES, '|', IF(PREC_SPECIES = '1', '0', IF(PREC_SPECIES = '2', '1', IF(PREC_SPECIES = '3', '?', 'NULL')))), |
| DATE_DEBUT, IF(DATE_DEBUT_CARAC = '1', '2316', IF (DATE_DEBUT_CARAC = '2', '2317', IF (DATE_DEBUT_CARAC = '3', '2318', IF(DATE_DEBUT_CARAC = '4', '2319', IF (DATE_DEBUT_CARAC = '5', '2320', NULL))))), |
| DATE_FIN, IF( DATE_FIN_CARAC = '1', '2321', IF (DATE_FIN_CARAC = '2', '2322', IF(DATE_FIN_CARAC = '3', '2323', IF (DATE_FIN_CARAC = '4', '2325', IF(DATE_FIN_CARAC = '5', '2324', IF (DATE_FIN_CARAC = '6', '2326', NULL)))))), |
| 282,7 → 293,8 |
|---|
| PERCENT_DATABASED, IF(ETAT_CLASSEMENT = 1, '2328', IF(ETAT_CLASSEMENT = 2, '2329', IF(ETAT_CLASSEMENT = 3, '2330', IF(ETAT_CLASSEMENT = 4, '2331', NULL)))), |
| CONCAT('TOTAL#',IF(ETAT_SPECIMENS = 1, '2328', IF(ETAT_SPECIMENS = 2, '2329', IF(ETAT_SPECIMENS = 3, '2330', IF(ETAT_SPECIMENS = 4, '2331', NULL))))), |
| CONCAT('TOTAL#',IF(ETAT_PRESENTATION = 1, '2328', IF(ETAT_PRESENTATION = 2, '2329', IF(ETAT_PRESENTATION = 3, '2330', IF(ETAT_PRESENTATION = 4, '2331', NULL))))), |
| IF(MODE_CLASSEMENT IS NOT NULL, IF(MODE_CLASSEMENT != '', CONVERT(MODE_CLASSEMENT USING utf8), NULL), NULL) |
| IF(MODE_CLASSEMENT IS NOT NULL, IF(MODE_CLASSEMENT != '', CONVERT(MODE_CLASSEMENT USING utf8), NULL), NULL), |
| @idm := @idm+1 |
| FROM tb_herbiers.HERBIERS_COLLECTION |
| WHERE ID != 4 |
| ORDER BY ID ASC; |
| 289,7 → 301,7 |
|---|
| INSERT INTO tb_coel.coel_meta_historique_ligne |
| (cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement, |
| cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat, cmhl_ip) |
| SELECT @idm_tmp := @idm_tmp+1, '101', ID, NULL, |
| SELECT @idm_tmp := @idm_tmp+1, '106', ID, NULL, |
| IF(DATE_DERNIERE_MODIF != '0000-00-00 00:00:00', DATE_DERNIERE_MODIF, NOW()) , CONCAT('Ajout de la collection #',ID,' de la table HERBIER_COLLECTION.'), IF(CE_MODIFIER_PAR != '0', CE_MODIFIER_PAR, '1'), '1', IF(CE_MODIFIER_PAR != '0', NULL, '162.38.234.1') |
| FROM tb_herbiers.HERBIERS_COLLECTION |
| WHERE ID != 4 |