Subversion Repositories Sites.gentiana.org

Compare Revisions

Ignore whitespace Rev 66 → Rev 67

/trunk/base_de_donnees/nettoyage.sql
3,10 → 3,7
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 NOT IN (SELECT `en_ce_auteur_basio_ex`FROM eflore_nom WHERE `en_id_version_projet_nom` = 25)
AND enaia_id_intitule_naturaliste_abrege NOT IN (SELECT `en_ce_auteur_basio`FROM eflore_nom WHERE `en_id_version_projet_nom` = 25)
AND enaia_id_intitule_naturaliste_abrege NOT IN (SELECT `en_ce_auteur_modif_ex`FROM eflore_nom WHERE `en_id_version_projet_nom` = 25)
AND enaia_id_intitule_naturaliste_abrege NOT IN (SELECT `en_ce_auteur_modif`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;