Fix foreign key constraints for AuthAssignment