Subversion Repositories eFlore/Applications.coel

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
1505 jpm 1
SET @id_table_cmlv = '112';
2
SET @id_admin = '1';
3
SET @ip_admin = '162.38.234.1';
4
SET @id_meta = '';
5
SET @enrg = '';
6
#+--------------------------------------------------------------------------------------------------------------------+#
1514 jpm 7
# MODIFICATION ONTOLOGIE
1505 jpm 8
SET @id_etat_modif = '2';
9
 
10
# Mise à jour des abréviations de la liste 40 id 1043
11
SET @notes = 'Remplacement de l''abréviation numérique par un code.';
12
 
13
SET @id_valeur = '2246';
14
INSERT INTO tb_coel.coel_meta_historique_ligne (cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement, cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip)
15
	VALUES	(@id_table_cmlv, @id_valeur, NULL , NOW( ) , @notes, @id_admin, @id_etat_modif, @ip_admin);
16
SELECT @id_meta := cmhl_id_historique_ligne, cmhl_date_modification FROM tb_coel.coel_meta_historique_ligne WHERE cmhl_ce_table = CONVERT(@id_table_cmlv USING utf8) AND cmhl_cle_ligne = CONVERT(@id_valeur USING utf8) ORDER BY cmhl_date_modification DESC LIMIT 1;
17
UPDATE tb_coel.coel_meta_liste_valeur SET
18
	cmlv_abreviation = 'PH',
19
	cmlv_ce_meta = @id_meta
20
	WHERE cmlv_id_valeur = @id_valeur;
21
SELECT @enrg := CONCAT('<?xml version="1.0" encoding="UTF-8" ?>\n<resultset>\n',
22
	'<row>\n',
23
	'<cmlv_id_valeur>', cmlv_id_valeur, '</cmlv_id_valeur>\n',
24
	'<cmlv_ce_parent>', cmlv_ce_parent, '</cmlv_ce_parent>\n',
25
	'<cmlv_ce_projet>', cmlv_ce_projet, '</cmlv_ce_projet>\n',
26
	'<cmlv_nom>', cmlv_nom, '</cmlv_nom>\n',
27
	'<cmlv_abreviation>', cmlv_abreviation, '</cmlv_abreviation>\n',
28
	'<cmlv_description>', cmlv_description, '</cmlv_description>\n',
29
	'<cmlv_ce_meta>', cmlv_ce_meta, '</cmlv_ce_meta>\n',
30
	'</row>\n',
31
	'</resultset>') AS xmldoc
32
	FROM tb_coel.coel_meta_liste_valeur
33
	WHERE cmlv_id_valeur = @id_valeur;
34
UPDATE tb_coel.coel_meta_historique_ligne SET
35
	cmhl_enregistrement = @enrg
36
	WHERE cmhl_id_historique_ligne = @id_meta;
37
 
38
SET @id_valeur = '2247';
39
INSERT INTO tb_coel.coel_meta_historique_ligne (cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement, cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip)
40
	VALUES	(@id_table_cmlv, @id_valeur, NULL , NOW( ) , @notes, @id_admin, @id_etat_modif, @ip_admin);
41
SELECT @id_meta := cmhl_id_historique_ligne, cmhl_date_modification FROM tb_coel.coel_meta_historique_ligne WHERE cmhl_ce_table = CONVERT(@id_table_cmlv USING utf8) AND cmhl_cle_ligne = CONVERT(@id_valeur USING utf8) ORDER BY cmhl_date_modification DESC LIMIT 1;
42
UPDATE tb_coel.coel_meta_liste_valeur SET
43
	cmlv_abreviation = 'GY',
44
	cmlv_ce_meta = @id_meta
45
	WHERE cmlv_id_valeur = @id_valeur;
46
SELECT @enrg := CONCAT('<?xml version="1.0" encoding="UTF-8" ?>\n<resultset>\n',
47
	'<row>\n',
48
	'<cmlv_id_valeur>', cmlv_id_valeur, '</cmlv_id_valeur>\n',
49
	'<cmlv_ce_parent>', cmlv_ce_parent, '</cmlv_ce_parent>\n',
50
	'<cmlv_ce_projet>', cmlv_ce_projet, '</cmlv_ce_projet>\n',
51
	'<cmlv_nom>', cmlv_nom, '</cmlv_nom>\n',
52
	'<cmlv_abreviation>', cmlv_abreviation, '</cmlv_abreviation>\n',
53
	'<cmlv_description>', cmlv_description, '</cmlv_description>\n',
54
	'<cmlv_ce_meta>', cmlv_ce_meta, '</cmlv_ce_meta>\n',
55
	'</row>\n',
56
	'</resultset>') AS xmldoc
57
	FROM tb_coel.coel_meta_liste_valeur
58
	WHERE cmlv_id_valeur = @id_valeur;
59
UPDATE tb_coel.coel_meta_historique_ligne SET
60
	cmhl_enregistrement = @enrg
61
	WHERE cmhl_id_historique_ligne = @id_meta;
62
 
63
SET @id_valeur = '2248';
64
INSERT INTO tb_coel.coel_meta_historique_ligne (cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement, cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip)
65
	VALUES	(@id_table_cmlv, @id_valeur, NULL , NOW( ) , @notes, @id_admin, @id_etat_modif, @ip_admin);
66
SELECT @id_meta := cmhl_id_historique_ligne, cmhl_date_modification FROM tb_coel.coel_meta_historique_ligne WHERE cmhl_ce_table = CONVERT(@id_table_cmlv USING utf8) AND cmhl_cle_ligne = CONVERT(@id_valeur USING utf8) ORDER BY cmhl_date_modification DESC LIMIT 1;
67
UPDATE tb_coel.coel_meta_liste_valeur SET
68
	cmlv_abreviation = 'AN',
69
	cmlv_ce_meta = @id_meta
70
	WHERE cmlv_id_valeur = @id_valeur;
71
SELECT @enrg := CONCAT('<?xml version="1.0" encoding="UTF-8" ?>\n<resultset>\n',
72
	'<row>\n',
73
	'<cmlv_id_valeur>', cmlv_id_valeur, '</cmlv_id_valeur>\n',
74
	'<cmlv_ce_parent>', cmlv_ce_parent, '</cmlv_ce_parent>\n',
75
	'<cmlv_ce_projet>', cmlv_ce_projet, '</cmlv_ce_projet>\n',
76
	'<cmlv_nom>', cmlv_nom, '</cmlv_nom>\n',
77
	'<cmlv_abreviation>', cmlv_abreviation, '</cmlv_abreviation>\n',
78
	'<cmlv_description>', cmlv_description, '</cmlv_description>\n',
79
	'<cmlv_ce_meta>', cmlv_ce_meta, '</cmlv_ce_meta>\n',
80
	'</row>\n',
81
	'</resultset>') AS xmldoc
82
	FROM tb_coel.coel_meta_liste_valeur
83
	WHERE cmlv_id_valeur = @id_valeur;
84
UPDATE tb_coel.coel_meta_historique_ligne SET
85
	cmhl_enregistrement = @enrg
86
	WHERE cmhl_id_historique_ligne = @id_meta;
87
 
88
SET @id_valeur = '2249';
89
INSERT INTO tb_coel.coel_meta_historique_ligne (cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement, cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip)
90
	VALUES	(@id_table_cmlv, @id_valeur, NULL , NOW( ) , @notes, @id_admin, @id_etat_modif, @ip_admin);
91
SELECT @id_meta := cmhl_id_historique_ligne, cmhl_date_modification FROM tb_coel.coel_meta_historique_ligne WHERE cmhl_ce_table = CONVERT(@id_table_cmlv USING utf8) AND cmhl_cle_ligne = CONVERT(@id_valeur USING utf8) ORDER BY cmhl_date_modification DESC LIMIT 1;
92
UPDATE tb_coel.coel_meta_liste_valeur SET
93
	cmlv_abreviation = 'CR',
94
	cmlv_ce_meta = @id_meta
95
	WHERE cmlv_id_valeur = @id_valeur;
96
SELECT @enrg := CONCAT('<?xml version="1.0" encoding="UTF-8" ?>\n<resultset>\n',
97
	'<row>\n',
98
	'<cmlv_id_valeur>', cmlv_id_valeur, '</cmlv_id_valeur>\n',
99
	'<cmlv_ce_parent>', cmlv_ce_parent, '</cmlv_ce_parent>\n',
100
	'<cmlv_ce_projet>', cmlv_ce_projet, '</cmlv_ce_projet>\n',
101
	'<cmlv_nom>', cmlv_nom, '</cmlv_nom>\n',
102
	'<cmlv_abreviation>', cmlv_abreviation, '</cmlv_abreviation>\n',
103
	'<cmlv_description>', cmlv_description, '</cmlv_description>\n',
104
	'<cmlv_ce_meta>', cmlv_ce_meta, '</cmlv_ce_meta>\n',
105
	'</row>\n',
106
	'</resultset>') AS xmldoc
107
	FROM tb_coel.coel_meta_liste_valeur
108
	WHERE cmlv_id_valeur = @id_valeur;
109
UPDATE tb_coel.coel_meta_historique_ligne SET
110
	cmhl_enregistrement = @enrg
111
	WHERE cmhl_id_historique_ligne = @id_meta;
112
 
113
SET @id_valeur = '2250';
114
INSERT INTO tb_coel.coel_meta_historique_ligne (cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement, cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip)
115
	VALUES	(@id_table_cmlv, @id_valeur, NULL , NOW( ) , @notes, @id_admin, @id_etat_modif, @ip_admin);
116
SELECT @id_meta := cmhl_id_historique_ligne, cmhl_date_modification FROM tb_coel.coel_meta_historique_ligne WHERE cmhl_ce_table = CONVERT(@id_table_cmlv USING utf8) AND cmhl_cle_ligne = CONVERT(@id_valeur USING utf8) ORDER BY cmhl_date_modification DESC LIMIT 1;
117
UPDATE tb_coel.coel_meta_liste_valeur SET
118
	cmlv_abreviation = 'AL',
119
	cmlv_ce_meta = @id_meta
120
	WHERE cmlv_id_valeur = @id_valeur;
121
SELECT @enrg := CONCAT('<?xml version="1.0" encoding="UTF-8" ?>\n<resultset>\n',
122
	'<row>\n',
123
	'<cmlv_id_valeur>', cmlv_id_valeur, '</cmlv_id_valeur>\n',
124
	'<cmlv_ce_parent>', cmlv_ce_parent, '</cmlv_ce_parent>\n',
125
	'<cmlv_ce_projet>', cmlv_ce_projet, '</cmlv_ce_projet>\n',
126
	'<cmlv_nom>', cmlv_nom, '</cmlv_nom>\n',
127
	'<cmlv_abreviation>', cmlv_abreviation, '</cmlv_abreviation>\n',
128
	'<cmlv_description>', cmlv_description, '</cmlv_description>\n',
129
	'<cmlv_ce_meta>', cmlv_ce_meta, '</cmlv_ce_meta>\n',
130
	'</row>\n',
131
	'</resultset>') AS xmldoc
132
	FROM tb_coel.coel_meta_liste_valeur
133
	WHERE cmlv_id_valeur = @id_valeur;
134
UPDATE tb_coel.coel_meta_historique_ligne SET
135
	cmhl_enregistrement = @enrg
136
	WHERE cmhl_id_historique_ligne = @id_meta;
137
 
138
SET @id_valeur = '2251';
139
INSERT INTO tb_coel.coel_meta_historique_ligne (cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement, cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip)
140
	VALUES	(@id_table_cmlv, @id_valeur, NULL , NOW( ) , @notes, @id_admin, @id_etat_modif, @ip_admin);
141
SELECT @id_meta := cmhl_id_historique_ligne, cmhl_date_modification FROM tb_coel.coel_meta_historique_ligne WHERE cmhl_ce_table = CONVERT(@id_table_cmlv USING utf8) AND cmhl_cle_ligne = CONVERT(@id_valeur USING utf8) ORDER BY cmhl_date_modification DESC LIMIT 1;
142
UPDATE tb_coel.coel_meta_liste_valeur SET
143
	cmlv_abreviation = 'CH',
144
	cmlv_ce_meta = @id_meta
145
	WHERE cmlv_id_valeur = @id_valeur;
146
SELECT @enrg := CONCAT('<?xml version="1.0" encoding="UTF-8" ?>\n<resultset>\n',
147
	'<row>\n',
148
	'<cmlv_id_valeur>', cmlv_id_valeur, '</cmlv_id_valeur>\n',
149
	'<cmlv_ce_parent>', cmlv_ce_parent, '</cmlv_ce_parent>\n',
150
	'<cmlv_ce_projet>', cmlv_ce_projet, '</cmlv_ce_projet>\n',
151
	'<cmlv_nom>', cmlv_nom, '</cmlv_nom>\n',
152
	'<cmlv_abreviation>', cmlv_abreviation, '</cmlv_abreviation>\n',
153
	'<cmlv_description>', cmlv_description, '</cmlv_description>\n',
154
	'<cmlv_ce_meta>', cmlv_ce_meta, '</cmlv_ce_meta>\n',
155
	'</row>\n',
156
	'</resultset>') AS xmldoc
157
	FROM tb_coel.coel_meta_liste_valeur
158
	WHERE cmlv_id_valeur = @id_valeur;
159
UPDATE tb_coel.coel_meta_historique_ligne SET
160
	cmhl_enregistrement = @enrg
161
	WHERE cmhl_id_historique_ligne = @id_meta;
162
 
163
SET @id_valeur = '2252';
164
INSERT INTO tb_coel.coel_meta_historique_ligne (cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement, cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip)
165
	VALUES	(@id_table_cmlv, @id_valeur, NULL , NOW( ) , @notes, @id_admin, @id_etat_modif, @ip_admin);
166
SELECT @id_meta := cmhl_id_historique_ligne, cmhl_date_modification FROM tb_coel.coel_meta_historique_ligne WHERE cmhl_ce_table = CONVERT(@id_table_cmlv USING utf8) AND cmhl_cle_ligne = CONVERT(@id_valeur USING utf8) ORDER BY cmhl_date_modification DESC LIMIT 1;
167
UPDATE tb_coel.coel_meta_liste_valeur SET
168
	cmlv_abreviation = 'LI',
169
	cmlv_ce_meta = @id_meta
170
	WHERE cmlv_id_valeur = @id_valeur;
171
SELECT @enrg := CONCAT('<?xml version="1.0" encoding="UTF-8" ?>\n<resultset>\n',
172
	'<row>\n',
173
	'<cmlv_id_valeur>', cmlv_id_valeur, '</cmlv_id_valeur>\n',
174
	'<cmlv_ce_parent>', cmlv_ce_parent, '</cmlv_ce_parent>\n',
175
	'<cmlv_ce_projet>', cmlv_ce_projet, '</cmlv_ce_projet>\n',
176
	'<cmlv_nom>', cmlv_nom, '</cmlv_nom>\n',
177
	'<cmlv_abreviation>', cmlv_abreviation, '</cmlv_abreviation>\n',
178
	'<cmlv_description>', cmlv_description, '</cmlv_description>\n',
179
	'<cmlv_ce_meta>', cmlv_ce_meta, '</cmlv_ce_meta>\n',
180
	'</row>\n',
181
	'</resultset>') AS xmldoc
182
	FROM tb_coel.coel_meta_liste_valeur
183
	WHERE cmlv_id_valeur = @id_valeur;
184
UPDATE tb_coel.coel_meta_historique_ligne SET
185
	cmhl_enregistrement = @enrg
186
	WHERE cmhl_id_historique_ligne = @id_meta;
187
 
188
SET @id_valeur = '2253';
189
INSERT INTO tb_coel.coel_meta_historique_ligne (cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement, cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip)
190
	VALUES	(@id_table_cmlv, @id_valeur, NULL , NOW( ) , @notes, @id_admin, @id_etat_modif, @ip_admin);
191
SELECT @id_meta := cmhl_id_historique_ligne, cmhl_date_modification FROM tb_coel.coel_meta_historique_ligne WHERE cmhl_ce_table = CONVERT(@id_table_cmlv USING utf8) AND cmhl_cle_ligne = CONVERT(@id_valeur USING utf8) ORDER BY cmhl_date_modification DESC LIMIT 1;
192
UPDATE tb_coel.coel_meta_liste_valeur SET
193
	cmlv_abreviation = 'BR',
194
	cmlv_ce_meta = @id_meta
195
	WHERE cmlv_id_valeur = @id_valeur;
196
SELECT @enrg := CONCAT('<?xml version="1.0" encoding="UTF-8" ?>\n<resultset>\n',
197
	'<row>\n',
198
	'<cmlv_id_valeur>', cmlv_id_valeur, '</cmlv_id_valeur>\n',
199
	'<cmlv_ce_parent>', cmlv_ce_parent, '</cmlv_ce_parent>\n',
200
	'<cmlv_ce_projet>', cmlv_ce_projet, '</cmlv_ce_projet>\n',
201
	'<cmlv_nom>', cmlv_nom, '</cmlv_nom>\n',
202
	'<cmlv_abreviation>', cmlv_abreviation, '</cmlv_abreviation>\n',
203
	'<cmlv_description>', cmlv_description, '</cmlv_description>\n',
204
	'<cmlv_ce_meta>', cmlv_ce_meta, '</cmlv_ce_meta>\n',
205
	'</row>\n',
206
	'</resultset>') AS xmldoc
207
	FROM tb_coel.coel_meta_liste_valeur
208
	WHERE cmlv_id_valeur = @id_valeur;
209
UPDATE tb_coel.coel_meta_historique_ligne SET
210
	cmhl_enregistrement = @enrg
211
	WHERE cmhl_id_historique_ligne = @id_meta;
212
 
213
SET @id_valeur = '2254';
214
INSERT INTO tb_coel.coel_meta_historique_ligne (cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement, cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip)
215
	VALUES	(@id_table_cmlv, @id_valeur, NULL , NOW( ) , @notes, @id_admin, @id_etat_modif, @ip_admin);
216
SELECT @id_meta := cmhl_id_historique_ligne, cmhl_date_modification FROM tb_coel.coel_meta_historique_ligne WHERE cmhl_ce_table = CONVERT(@id_table_cmlv USING utf8) AND cmhl_cle_ligne = CONVERT(@id_valeur USING utf8) ORDER BY cmhl_date_modification DESC LIMIT 1;
217
UPDATE tb_coel.coel_meta_liste_valeur SET
218
	cmlv_abreviation = 'PT',
219
	cmlv_ce_meta = @id_meta
220
	WHERE cmlv_id_valeur = @id_valeur;
221
SELECT @enrg := CONCAT('<?xml version="1.0" encoding="UTF-8" ?>\n<resultset>\n',
222
	'<row>\n',
223
	'<cmlv_id_valeur>', cmlv_id_valeur, '</cmlv_id_valeur>\n',
224
	'<cmlv_ce_parent>', cmlv_ce_parent, '</cmlv_ce_parent>\n',
225
	'<cmlv_ce_projet>', cmlv_ce_projet, '</cmlv_ce_projet>\n',
226
	'<cmlv_nom>', cmlv_nom, '</cmlv_nom>\n',
227
	'<cmlv_abreviation>', cmlv_abreviation, '</cmlv_abreviation>\n',
228
	'<cmlv_description>', cmlv_description, '</cmlv_description>\n',
229
	'<cmlv_ce_meta>', cmlv_ce_meta, '</cmlv_ce_meta>\n',
230
	'</row>\n',
231
	'</resultset>') AS xmldoc
232
	FROM tb_coel.coel_meta_liste_valeur
233
	WHERE cmlv_id_valeur = @id_valeur;
234
UPDATE tb_coel.coel_meta_historique_ligne SET
235
	cmhl_enregistrement = @enrg
236
	WHERE cmhl_id_historique_ligne = @id_meta;
1514 jpm 237
 
238
#+--------------------------------------------------------------------------------------------------------------------+#
239
# MODIFICATION PUBLICATION
240
ALTER TABLE tb_coel.coel_publication CHANGE
241
	`cpu_date_parution` `cpu_date_parution` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
242
	COMMENT 'Année(s) de parution de la publication. Formats acceptés : AAAA-MM-JJ ou AAAA ou AAAA-AAAA.'