Subversion Repositories Sites.gentiana.org

Compare Revisions

No changes between revisions

Ignore whitespace Rev 69 → Rev 120

/tags/2014-08-05_centre/base_de_donnees/infloris_export_sql.sh
New file
0,0 → 1,15
# Script d'export des données d'INFLORIS intégrées dans eFlore v1.1
# Auteurs : David DELON, Jean-Pascal MILCENT
# Date : 28 septembre 2007
VERSION_ID=40
BDD_NOM="gentiana_prod_eflore_v1_1_principale"
MDP=
FICHIER_EXPORT="infloris_v1_00_export.sql"
# Module PROJET
echo "DELETE FROM eflore_projet_version WHERE eprv_id_version = $VERSION_ID;" >> $FICHIER_EXPORT
/opt/lampp/bin/mysqldump -t -u root -p$MDP -w "eprv_id_version = $VERSION_ID" $BDD_NOM eflore_projet_version >> $FICHIER_EXPORT
# Module CHOROLOGIE
echo "DELETE FROM eflore_chorologie_donnee WHERE ecd_id_version_projet_donnee_choro = $VERSION_ID;" >> $FICHIER_EXPORT
/opt/lampp/bin/mysqldump -t -u root -p$MDP -w "ecd_id_version_projet_donnee_choro = $VERSION_ID" $BDD_NOM eflore_chorologie_donnee >> $FICHIER_EXPORT
echo "DELETE FROM eflore_chorologie_information WHERE eci_id_version_projet_info_choro = $VERSION_ID;" >> $FICHIER_EXPORT
/opt/lampp/bin/mysqldump -t -u root -p$MDP -w "eci_id_version_projet_info_choro = $VERSION_ID" $BDD_NOM eflore_chorologie_information >> $FICHIER_EXPORT
Property changes:
Added: svn:executable
+*
\ No newline at end of property
/tags/2014-08-05_centre/base_de_donnees/nettoyage.sql
New file
0,0 → 1,19
-- Nettoyage base eFlore pour Gentiana. Seules les données de la BDNFF et des projets liés sont gardées.
DELETE FROM `eflore_chorologie_donnee` WHERE `ecd_id_version_projet_donnee_choro` != 12;
DELETE FROM `eflore_chorologie_information` WHERE `eci_id_version_projet_info_choro` != 12;
DELETE FROM `eflore_info_txt` WHERE `eit_id_version_projet_txt` != 25;
DELETE FROM `eflore_nom` WHERE `en_id_version_projet_nom` != 25;
DELETE FROM `eflore_naturaliste_intitule_abreviation` WHERE enaia_id_intitule_naturaliste_abrege > 5516;
DELETE FROM `eflore_nom_a_txt` WHERE `enat_id_version_projet_nom` != 25;
DELETE FROM eflore_nom_citation WHERE enci_id_citation NOT IN (SELECT en_ce_citation_initiale FROM eflore_nom);
DELETE FROM `eflore_nom_intitule` WHERE `eni_id_version_projet_nom` != 25;
DELETE FROM eflore_nom_intitule_commentaire WHERE enic_id_intitule_cn NOT IN (SELECT en_ce_citation_initiale FROM eflore_nom);
DELETE FROM `eflore_nom_relation` WHERE `enr_id_version_projet_nom_1` != 25 AND `enr_id_version_projet_nom_2` != 25;
DELETE FROM `eflore_protection` WHERE `ept_id_version_projet_protection` != 36;
DELETE FROM `eflore_selection_nom` WHERE `esn_id_version_projet_nom` != 25;
DELETE FROM `eflore_taxon` WHERE `et_id_version_projet_taxon` != 25;
DELETE FROM `eflore_taxon_a_protection` WHERE `etap_id_version_projet_taxon` != 25;
DELETE FROM `eflore_taxon_a_txt` WHERE `etat_id_version_projet_taxon` != 25;
DELETE FROM `eflore_taxon_relation` WHERE `etr_id_version_projet_taxon_1` != 25;
DELETE FROM `eflore_vernaculaire` WHERE `ev_id_version_projet_nom_verna` != 24;
DELETE FROM `eflore_vernaculaire_attribution` WHERE `eva_id_version_projet_nom_verna` != 24;