added in the foreign key index to the migrations
updated schema
pulled from github