Subversion Repositories eFlore/Applications.coel

Rev

Rev 1505 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1505 Rev 1514
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.'