Subversion Repositories eFlore/Applications.coel

Compare Revisions

Ignore whitespace Rev 1470 → Rev 1471

/trunk/doc/bdd/maj_v1.1.3.sql
New file
0,0 → 1,88
 
 
/****************************************************
COLLECTION BOTANIQUE
*****************************************************/
 
 
/* Champ ccb_truk_degradation_specimen */
 
SET @valeur = '%Très important [1]%';
UPDATE coel_collection_botanique
SET ccb_truk_degradation_specimen=REPLACE(ccb_truk_degradation_specimen,'Très important [1]','30748')
WHERE ccb_truk_degradation_specimen LIKE '%Très important [1]%';
 
SET @valeur = '%Important [2]%';
UPDATE coel_collection_botanique
SET ccb_truk_degradation_specimen=REPLACE(ccb_truk_degradation_specimen,'Important [2]','30749')
WHERE ccb_truk_degradation_specimen LIKE '%Important [2]%';
 
SET @valeur = '%Moyen [3]%';
UPDATE coel_collection_botanique
SET ccb_truk_degradation_specimen=REPLACE(ccb_truk_degradation_specimen,'Moyen [3]','30750')
WHERE ccb_truk_degradation_specimen LIKE '%Moyen [3]%';
 
SET @valeur = '%Faible [4]%';
UPDATE coel_collection_botanique
SET ccb_truk_degradation_specimen=REPLACE(ccb_truk_degradation_specimen,'Faible [4]','30751')
WHERE ccb_truk_degradation_specimen LIKE '%Faible [4]%';
 
SET @valeur = '%Très faible [5]%';
UPDATE coel_collection_botanique
SET ccb_truk_degradation_specimen=REPLACE(ccb_truk_degradation_specimen,'Très faible [5]','30752')
WHERE ccb_truk_degradation_specimen LIKE '%Très faible [5]%';
 
 
/* Champccb_truk_degradation_presentation */
 
UPDATE coel_collection_botanique
SET ccb_truk_degradation_presentation=REPLACE(ccb_truk_degradation_presentation,'Très important [1]','30748')
WHERE ccb_truk_degradation_presentation LIKE '%Très important [1]%';
 
 
UPDATE coel_collection_botanique
SET ccb_truk_degradation_presentation=REPLACE(ccb_truk_degradation_presentation,'Important [2]','30749')
WHERE ccb_truk_degradation_presentation LIKE '%Important [2]%';
 
 
UPDATE coel_collection_botanique
SET ccb_truk_degradation_presentation=REPLACE(ccb_truk_degradation_presentation,'Moyen [3]','30750')
WHERE ccb_truk_degradation_presentation LIKE '%Moyen [3]%';
 
 
UPDATE coel_collection_botanique
SET ccb_truk_degradation_presentation=REPLACE(ccb_truk_degradation_presentation,'Faible [4]','30751')
WHERE ccb_truk_degradation_presentation LIKE '%Faible [4]%';
 
 
UPDATE coel_collection_botanique
SET ccb_truk_degradation_presentation=REPLACE(ccb_truk_degradation_presentation,'Très faible [5]','30752')
WHERE ccb_truk_degradation_presentation LIKE '%Très faible [5]%';
 
 
/****************************************************
PERSONNE
*****************************************************/
 
UPDATE coel_personne
SET cp_truk_telephone=REPLACE(cp_truk_telephone,'FAX','30747')
WHERE cp_truk_telephone LIKE '%FAX%';
 
UPDATE coel_personne
SET cp_truk_telephone=REPLACE(cp_truk_telephone,'GSM','2014')
WHERE cp_truk_telephone LIKE '%GSM%';
 
UPDATE coel_personne
SET cp_truk_telephone=REPLACE(cp_truk_telephone,'FIX','2015')
WHERE cp_truk_telephone LIKE '%FIX%';
 
UPDATE coel_personne
SET cp_truk_telephone=REPLACE(cp_truk_telephone,'PAG','2016')
WHERE cp_truk_telephone LIKE '%PAG%';