-- ABHA consent purpose only applies to Indian hospitals (history in consent_records is untouched)
UPDATE consent_purposes p JOIN tenants t ON t.id = p.tenant_id SET p.is_active = 0 WHERE p.code = 'abha' AND t.country <> 'IN';