#STEP 1 
/*
·        Changer le code du site de PAP/HCRA  à PAP/HABB
·        Changer les codes patients PAP/HCRA/STXXXXX en PAP/HABB/STXXXXX
*/

UPDATE `caris_db`.`lookup_hospital` SET `hospital_code`='HABB'  WHERE `id`='153';
UPDATE `caris_db`.`patient` 
SET 
    `hospital_code` = 'HABB',
    `patient_code` = CONCAT('PAP/HABB/', `patient_number`)
WHERE
    `hospital_code` = 'HCRA'
        AND `city_code` = 'PAP';

#STEP 2
/*
·        Changer le code du site de GRA/HSPC  à JER/HSPC
·        Changer les codes patients GRA/HSPC/STXXXXX en JER/HSPC/STXXXXX
*/
UPDATE `caris_db`.`lookup_hospital` SET `city_code`='JER'  WHERE `id`='161';
UPDATE `caris_db`.`patient` 
SET 
    `city_code` = 'JER',
    `patient_code` = CONCAT('JER/HSPC/', `patient_number`)
WHERE
    `hospital_code` = 'HSPC'
        AND `city_code` = 'GRA';
        
#STEP 3

/*
STEP 3:
·        Changer le code du site de GRA/CSMN  à JER/CSMN
·        Changer les codes patients GRA/CSMN/STXXXXX en JER/CSMN/STXXXXX
*/
UPDATE `caris_db`.`lookup_hospital` SET `city_code`='JER'  WHERE `id`='160';
UPDATE `caris_db`.`patient` 
SET 
    `city_code` = 'JER',
    `patient_code` = CONCAT('JER/CSMN/', `patient_number`)
WHERE
    `hospital_code` = 'CSMN'
        AND `city_code` = 'GRA';