Subversion Repositories eFlore/Applications.coel

Rev

Rev 1317 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
1317 jpm 1 
# Script de mise à jour de l''id d''une personne
2 
SET @id_ancien = '100213';
3 
SET @id_nouveau = '8589';
4 
UPDATE `coel_collection_a_personne` SET `ccap_id_personne` = @id_nouveau WHERE `ccap_id_personne` = @id_ancien;
5 
UPDATE `coel_publication_a_personne` SET `cpuap_id_personne` = @id_nouveau WHERE `cpuap_id_personne` = @id_ancien;
6 
UPDATE `coel_structure_a_personne` SET `csap_id_personne` = @id_nouveau WHERE `csap_id_personne` = @id_ancien;