fixes #6126 - deleting a subnet that is associated with a host group throws foreign key error

I added `:hostgroups` and removed `:dependent => :destroy`