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:

SQL Query
alter table ubbt_USER_PROFILE 
change USER_SHOW_AVATARS USER_SHOW_AVATARS tinyint(1) not null default '1'