added TYPE to group_ip pivot table and appropriate elements to views