Subversion Repositories eFlore/Applications.coel

/****************************************************
                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%';