Subversion Repositories eFlore/Applications.coel

Rev

Rev 1504 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
1471 cyprien 1
 
2
 
3
/****************************************************
4
		COLLECTION BOTANIQUE
5
*****************************************************/
6
 
7
 
8
/* Champ ccb_truk_degradation_specimen */
9
 
10
SET @valeur = '%Très important [1]%';
11
UPDATE coel_collection_botanique
12
SET ccb_truk_degradation_specimen=REPLACE(ccb_truk_degradation_specimen,'Très important [1]','30748')
13
WHERE ccb_truk_degradation_specimen LIKE '%Très important [1]%';
14
 
15
SET @valeur = '%Important [2]%';
16
UPDATE coel_collection_botanique
17
SET ccb_truk_degradation_specimen=REPLACE(ccb_truk_degradation_specimen,'Important [2]','30749')
18
WHERE ccb_truk_degradation_specimen LIKE '%Important [2]%';
19
 
20
SET @valeur = '%Moyen [3]%';
21
UPDATE coel_collection_botanique
22
SET ccb_truk_degradation_specimen=REPLACE(ccb_truk_degradation_specimen,'Moyen [3]','30750')
23
WHERE ccb_truk_degradation_specimen LIKE '%Moyen [3]%';
24
 
25
SET @valeur = '%Faible [4]%';
26
UPDATE coel_collection_botanique
27
SET ccb_truk_degradation_specimen=REPLACE(ccb_truk_degradation_specimen,'Faible [4]','30751')
28
WHERE ccb_truk_degradation_specimen LIKE '%Faible [4]%';
29
 
30
SET @valeur = '%Très faible [5]%';
31
UPDATE coel_collection_botanique
32
SET ccb_truk_degradation_specimen=REPLACE(ccb_truk_degradation_specimen,'Très faible [5]','30752')
33
WHERE ccb_truk_degradation_specimen LIKE '%Très faible [5]%';
34
 
35
 
36
/* Champccb_truk_degradation_presentation */
37
 
38
UPDATE coel_collection_botanique
39
SET ccb_truk_degradation_presentation=REPLACE(ccb_truk_degradation_presentation,'Très important [1]','30748')
40
WHERE ccb_truk_degradation_presentation LIKE '%Très important [1]%';
41
 
42
 
43
UPDATE coel_collection_botanique
44
SET ccb_truk_degradation_presentation=REPLACE(ccb_truk_degradation_presentation,'Important [2]','30749')
45
WHERE ccb_truk_degradation_presentation LIKE '%Important [2]%';
46
 
47
 
48
UPDATE coel_collection_botanique
49
SET ccb_truk_degradation_presentation=REPLACE(ccb_truk_degradation_presentation,'Moyen [3]','30750')
50
WHERE ccb_truk_degradation_presentation LIKE '%Moyen [3]%';
51
 
52
 
53
UPDATE coel_collection_botanique
54
SET ccb_truk_degradation_presentation=REPLACE(ccb_truk_degradation_presentation,'Faible [4]','30751')
55
WHERE ccb_truk_degradation_presentation LIKE '%Faible [4]%';
56
 
57
 
58
UPDATE coel_collection_botanique
59
SET ccb_truk_degradation_presentation=REPLACE(ccb_truk_degradation_presentation,'Très faible [5]','30752')
60
WHERE ccb_truk_degradation_presentation LIKE '%Très faible [5]%';
61
 
62
 
63
/****************************************************
64
		PERSONNE
65
*****************************************************/
66
 
67
UPDATE coel_personne
68
SET cp_truk_telephone=REPLACE(cp_truk_telephone,'FAX','30747')
69
WHERE cp_truk_telephone LIKE '%FAX%';
70
 
71
UPDATE coel_personne
72
SET cp_truk_telephone=REPLACE(cp_truk_telephone,'GSM','2014')
73
WHERE cp_truk_telephone LIKE '%GSM%';
74
 
75
UPDATE coel_personne
76
SET cp_truk_telephone=REPLACE(cp_truk_telephone,'FIX','2015')
77
WHERE cp_truk_telephone LIKE '%FIX%';
78
 
79
UPDATE coel_personne
80
SET cp_truk_telephone=REPLACE(cp_truk_telephone,'PAG','2016')
81
WHERE cp_truk_telephone LIKE '%PAG%';
82
 
83
 
84
 
85
 
86
 
87
 
88