update  db_iemr.m_user set username='0600194107' where userID=2719;



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



UPDATE db_identity.i_beneficiaryfamilymapping 
SET CreatedBy = '0600194107',
    ModifiedBy = '0600194107'
WHERE BenFamilyMapId IN (
    SELECT BenFamilyMapId FROM (
        SELECT BenFamilyMapId FROM db_identity.i_beneficiaryfamilymapping 
        WHERE CreatedBy = '600194107'
        
    ) AS temp
);



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



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


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


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


UPDATE db_identity.i_beneficiaryimage   
SET CreatedBy = '0600194107',
    ModifiedBy = '0600194107'
WHERE BenImageId IN (
    SELECT BenImageId FROM (
        SELECT BenImageId FROM db_identity.i_beneficiaryimage   
        WHERE CreatedBy = '600194107'
        ) AS temp
);


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



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





UPDATE db_identity.m_beneficiaryregidmapping     
SET CreatedBy = '0600194107',
    ModifiedBy = '0600194107'
WHERE BenRegId IN (
    SELECT BenRegId FROM (
        SELECT BenRegId FROM db_identity.m_beneficiaryregidmapping   
        WHERE CreatedBy = '600194107'
        ) AS temp
);



UPDATE db_identity.i_bornbirthdeatils     
SET CreatedBy = '0600194107',
    ModifiedBy = '0600194107'
WHERE BornBirthDeatilsId IN (
    SELECT BornBirthDeatilsId FROM (
        SELECT BornBirthDeatilsId FROM db_identity.i_bornbirthdeatils   
        WHERE CreatedBy = '600194107'
        ) AS temp
);


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


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




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

  UPDATE db_identity.i_benfamilytag
SET CreatedBy = '0600194107'
WHERE BenFamilyTagId > 0
  AND CreatedBy = '600194107';


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


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



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






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