| Line 2... |
Line 2... |
| 2 |
SET @id_admin = '1';
|
2 |
SET @id_admin = '1';
|
| 3 |
SET @ip_admin = '162.38.234.1';
|
3 |
SET @ip_admin = '162.38.234.1';
|
| 4 |
SET @id_meta = '';
|
4 |
SET @id_meta = '';
|
| 5 |
SET @enrg = '';
|
5 |
SET @enrg = '';
|
| 6 |
#+--------------------------------------------------------------------------------------------------------------------+#
|
6 |
#+--------------------------------------------------------------------------------------------------------------------+#
|
| 7 |
# MODIFICATION
|
7 |
# MODIFICATION ONTOLOGIE
|
| 8 |
SET @id_etat_modif = '2';
|
8 |
SET @id_etat_modif = '2';
|
| Line 9... |
Line 9... |
| 9 |
|
9 |
|
| 10 |
# Mise à jour des abréviations de la liste 40 id 1043
|
10 |
# Mise à jour des abréviations de la liste 40 id 1043
|
| Line 232... |
Line 232... |
| 232 |
FROM tb_coel.coel_meta_liste_valeur
|
232 |
FROM tb_coel.coel_meta_liste_valeur
|
| 233 |
WHERE cmlv_id_valeur = @id_valeur;
|
233 |
WHERE cmlv_id_valeur = @id_valeur;
|
| 234 |
UPDATE tb_coel.coel_meta_historique_ligne SET
|
234 |
UPDATE tb_coel.coel_meta_historique_ligne SET
|
| 235 |
cmhl_enregistrement = @enrg
|
235 |
cmhl_enregistrement = @enrg
|
| 236 |
WHERE cmhl_id_historique_ligne = @id_meta;
|
236 |
WHERE cmhl_id_historique_ligne = @id_meta;
|
| - |
|
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.'
|