Set up cascading delete for User=>UserProfile.