With the newer versions it should have this already set to yes as the default for that field, however if you want to make sure you can run the following SQL command from within the control panel:
alter table ubbt_USER_PROFILE
change USER_SHOW_AVATARS USER_SHOW_AVATARS tinyint(1) not null default '1'