add some missing foreign key constraints to the database.