update  db_iemr.m_user set username='6002986661' where username='7399770982';



UPDATE db_identity.i_beneficiarydetails_rmnch 
SET CreatedBy = '6002986661',
    ModifiedBy = '6002986661'
WHERE beneficiaryDetails_RmnchId IN (
    SELECT beneficiaryDetails_RmnchId FROM (
        SELECT beneficiaryDetails_RmnchId FROM db_identity.i_beneficiarydetails_rmnch 
        WHERE CreatedBy = '7399770982'
        
    ) AS temp
);



UPDATE db_identity.i_beneficiaryfamilymapping              -- need to add index
SET CreatedBy = '6002986661',
    ModifiedBy = '6002986661'
WHERE BenFamilyMapId IN (
    SELECT BenFamilyMapId FROM (
        SELECT BenFamilyMapId FROM db_identity.i_beneficiaryfamilymapping 
        WHERE CreatedBy = '7399770982'
        
    ) AS temp
);



UPDATE db_identity.i_beneficiarydetails 
SET CreatedBy = '6002986661',
    ModifiedBy = '6002986661'
WHERE BeneficiaryDetailsId IN (
    SELECT BeneficiaryDetailsId FROM (
        SELECT BeneficiaryDetailsId FROM db_identity.i_beneficiarydetails 
        WHERE CreatedBy = '7399770982'
        ) AS temp
);



UPDATE db_identity.i_beneficiarymapping 
SET CreatedBy = '6002986661',
    ModifiedBy = '6002986661'
WHERE BenMapId IN (
    SELECT BenMapId FROM (
        SELECT BenMapId FROM db_identity.i_beneficiarymapping 
        WHERE CreatedBy = '7399770982'
        ) AS temp
);


UPDATE db_identity.i_beneficiaryidentity 
SET CreatedBy = '6002986661',
    ModifiedBy = '6002986661'
WHERE BenIdentityId IN (
    SELECT BenIdentityId FROM (
        SELECT BenIdentityId FROM db_identity.i_beneficiaryidentity 
        WHERE CreatedBy = '7399770982'
        ) AS temp
);


UPDATE db_identity.i_householddetails   
SET CreatedBy = '6002986661',
    ModifiedBy = '6002986661'
WHERE houseHoldDetailsId IN (
    SELECT houseHoldDetailsId FROM (
        SELECT houseHoldDetailsId FROM db_identity.i_householddetails   
        WHERE CreatedBy = '7399770982'
        ) AS temp
);


UPDATE db_identity.i_beneficiaryimage      -- create index  took 500+ sec but updated in 30 sec
SET CreatedBy = '6002986661',
    ModifiedBy = '6002986661'
WHERE BenImageId IN (
    SELECT BenImageId FROM (
        SELECT BenImageId FROM db_identity.i_beneficiaryimage   
        WHERE CreatedBy = '7399770982'
        ) AS temp
);


UPDATE db_identity.i_beneficiaryaddress   
SET CreatedBy = '6002986661',
    ModifiedBy = '6002986661'
WHERE BenAddressID IN (
    SELECT BenAddressID FROM (
        SELECT BenAddressID FROM db_identity.i_beneficiaryaddress   
        WHERE CreatedBy = '7399770982'
        ) AS temp
);



UPDATE db_identity.i_beneficiaryservicemapping     
SET CreatedBy = '6002986661',
    ModifiedBy = '6002986661'
WHERE BenServiceMapID IN (
    SELECT BenServiceMapID FROM (
        SELECT BenServiceMapID FROM db_identity.i_beneficiaryservicemapping   
        WHERE CreatedBy = '7399770982'
        ) AS temp
);





UPDATE db_identity.m_beneficiaryregidmapping     --no data
SET CreatedBy = '6002986661',
    ModifiedBy = '6002986661'
WHERE BenRegId IN (
    SELECT BenRegId FROM (
        SELECT BenRegId FROM db_identity.m_beneficiaryregidmapping   
        WHERE CreatedBy = '7399770982'
        ) AS temp
);



UPDATE db_identity.i_bornbirthdeatils        -- no data   
SET CreatedBy = '6002986661',
    ModifiedBy = '6002986661'
WHERE BornBirthDeatilsId IN (
    SELECT BornBirthDeatilsId FROM (
        SELECT BornBirthDeatilsId FROM db_identity.i_bornbirthdeatils   
        WHERE CreatedBy = '7399770982'
        ) AS temp
);


UPDATE db_identity.i_beneficiarycontacts     
SET CreatedBy = '6002986661',
    ModifiedBy = '6002986661'
WHERE BenContactsID IN (
    SELECT BenContactsID FROM (
        SELECT BenContactsID FROM db_identity.i_beneficiarycontacts   
        WHERE CreatedBy = '7399770982'
        ) AS temp
);


UPDATE db_identity.i_beneficiaryconsent     
SET CreatedBy = '6002986661',
    ModifiedBy = '6002986661'
WHERE BenConsentID IN (
    SELECT BenConsentID FROM (
        SELECT BenConsentID FROM db_identity.i_beneficiaryconsent   
        WHERE CreatedBy = '7399770982'
        ) AS temp
);




UPDATE db_identity.i_benfamilytag     
SET CreatedBy = '6002986661',
    ModifiedBy = '6002986661'
WHERE BenFamilyTagId IN (
    SELECT BenFamilyTagId FROM (
        SELECT BenFamilyTagId FROM db_identity.i_benfamilytag   
        WHERE CreatedBy = '7399770982'
        ) AS temp
);

  UPDATE db_identity.i_benfamilytag
SET CreatedBy = '6002986661'
WHERE BenFamilyTagId > 0
  AND CreatedBy = '7399770982';


UPDATE db_iemr.ELIGIBLE_COUPLE_TRACKING     
SET Created_By = '6002986661',
    updated_by = '6002986661'
WHERE id IN (
    SELECT id FROM (
        SELECT id FROM db_iemr.ELIGIBLE_COUPLE_TRACKING   
        WHERE Created_By = '7399770982'
        ) AS temp
);


UPDATE db_iemr.t_pregnant_woman_register     
SET Created_By = '6002986661',
    updated_by = '6002986661'
WHERE id IN (
    SELECT id FROM (
        SELECT id FROM db_iemr.t_pregnant_woman_register   
        WHERE Created_By = '7399770982'
        ) AS temp
);



UPDATE db_iemr.t_cbacdetails     
SET CreatedBy = '6002986661',
    ModifiedBy = '6002986661'
WHERE id IN (
    SELECT id FROM (
        SELECT id FROM db_iemr.t_cbacdetails   
        WHERE CreatedBy = '7399770982'
        ) AS temp
);






UPDATE db_iemr.t_eligible_couple_register     
SET created_by = '6002986661',
    updated_by = '6002986661'
WHERE id IN (
    SELECT id FROM (
        SELECT id FROM db_iemr.t_eligible_couple_register   
        WHERE created_by = '7399770982'
        ) AS temp
);



UPDATE db_iemr.t_delivery_outcome     
SET created_by = '6002986661',
    updated_by = '6002986661'
WHERE id IN (
    SELECT id FROM (
        SELECT id FROM db_iemr.t_delivery_outcome   
        WHERE created_by = '7399770982'
        ) AS temp
);


UPDATE db_iemr.t_pnccare     
SET CreatedBy = '6002986661',
    ModifiedBy = '6002986661'
WHERE id IN (
    SELECT id FROM (
        SELECT id FROM db_iemr.t_pnccare   
        WHERE CreatedBy = '7399770982'
        ) AS temp
);


UPDATE db_iemr.t_infant_register     
SET CreatedBy = '6002986661',
    ModifiedBy = '6002986661'
WHERE id IN (
    SELECT id FROM (
        SELECT id FROM db_iemr.t_infant_register   
        WHERE CreatedBy = '7399770982'
        ) AS temp
);



UPDATE db_iemr.t_infant_register     
SET created_by = '6002986661',
    updated_by = '6002986661'
WHERE id IN (
    SELECT id FROM (
        SELECT id FROM db_iemr.t_infant_register   
        WHERE created_by = '7399770982'
        ) AS temp
);



UPDATE db_iemr.t_anccare     
SET CreatedBy = '6002986661',
    ModifiedBy = '6002986661'
WHERE ID IN (
    SELECT ID FROM (
        SELECT ID FROM db_iemr.t_anccare   
        WHERE CreatedBy = '7399770982'
        ) AS temp
);



UPDATE db_iemr.t_benvisitdetail     
SET CreatedBy = '6002986661',
    ModifiedBy = '6002986661'
WHERE BenVisitID IN (
    SELECT BenVisitID FROM (
        SELECT BenVisitID FROM db_iemr.t_benvisitdetail   
        WHERE CreatedBy = '7399770982'
        ) AS temp
);


UPDATE db_iemr.t_pmsma     
SET Created_By = '6002986661',
    updated_by = '6002986661'
WHERE id IN (
    SELECT id FROM (
        SELECT id FROM db_iemr.t_pmsma   
        WHERE Created_By = '7399770982'
        ) AS temp
);