Rename {profile_fields} table to {profile_field} and {profile_values} to {profile_value}.
function profile_update_7001() { db_rename_table('profile_fields', 'profile_field'); db_rename_table('profile_values', 'profile_value'); }