fixes #6216 - foreign key errors such as deleting a subnet that is associated with a host group and others

I deleted the db migration that was added to remove the FK constraint on hosts.compute_profile_id and added `:dependent => :nullify`