Subversion Repositories Sites.gentiana.org

Rev

Rev 6 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6 Rev 67
Line 1... Line 1...
1 
-- Nettoyage base eFlore pour Gentiana. Seules les données de la BDNFF et des projets liés sont gardées.
 1 
-- Nettoyage base eFlore pour Gentiana. Seules les données de la BDNFF et des projets liés sont gardées.
2 
DELETE FROM `eflore_chorologie_donnee` WHERE `ecd_id_version_projet_donnee_choro` != 12;
 2 
DELETE FROM `eflore_chorologie_donnee` WHERE `ecd_id_version_projet_donnee_choro` != 12;
3 
DELETE FROM `eflore_chorologie_information` WHERE `eci_id_version_projet_info_choro` != 12;
 3 
DELETE FROM `eflore_chorologie_information` WHERE `eci_id_version_projet_info_choro` != 12;
4 
DELETE FROM `eflore_info_txt` WHERE `eit_id_version_projet_txt` != 25;
 4 
DELETE FROM `eflore_info_txt` WHERE `eit_id_version_projet_txt` != 25;
5 
DELETE FROM `eflore_nom` WHERE `en_id_version_projet_nom` != 25;
 5 
DELETE FROM `eflore_nom` WHERE `en_id_version_projet_nom` != 25;
6 
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)
6 
DELETE FROM `eflore_naturaliste_intitule_abreviation` WHERE enaia_id_intitule_naturaliste_abrege > 5516;
7 
	AND enaia_id_intitule_naturaliste_abrege NOT IN (SELECT `en_ce_auteur_basio`FROM eflore_nom WHERE `en_id_version_projet_nom` = 25)
- 
 
8 
	AND enaia_id_intitule_naturaliste_abrege NOT IN (SELECT `en_ce_auteur_modif_ex`FROM eflore_nom WHERE `en_id_version_projet_nom` = 25)
 - 
 
9 
	AND enaia_id_intitule_naturaliste_abrege NOT IN (SELECT `en_ce_auteur_modif`FROM eflore_nom WHERE `en_id_version_projet_nom` = 25);
 - 
 
10 
DELETE FROM `eflore_nom_a_txt` WHERE `enat_id_version_projet_nom` != 25;
 7 
DELETE FROM `eflore_nom_a_txt` WHERE `enat_id_version_projet_nom` != 25;
11 
DELETE FROM eflore_nom_citation WHERE enci_id_citation NOT IN (SELECT en_ce_citation_initiale FROM eflore_nom);
 8 
DELETE FROM eflore_nom_citation WHERE enci_id_citation NOT IN (SELECT en_ce_citation_initiale FROM eflore_nom);
12 
DELETE FROM `eflore_nom_intitule` WHERE `eni_id_version_projet_nom` != 25;
 9 
DELETE FROM `eflore_nom_intitule` WHERE `eni_id_version_projet_nom` != 25;
13 
DELETE FROM eflore_nom_intitule_commentaire WHERE enic_id_intitule_cn NOT IN (SELECT en_ce_citation_initiale FROM eflore_nom);
 10 
DELETE FROM eflore_nom_intitule_commentaire WHERE enic_id_intitule_cn NOT IN (SELECT en_ce_citation_initiale FROM eflore_nom);
14 
DELETE FROM `eflore_nom_relation` WHERE `enr_id_version_projet_nom_1` != 25 AND `enr_id_version_projet_nom_2` != 25;
 11 
DELETE FROM `eflore_nom_relation` WHERE `enr_id_version_projet_nom_1` != 25 AND `enr_id_version_projet_nom_2` != 25;