Rev 1415 |
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;
|