Revert "add foreign key constraints to open_events"

The last migration was causing the whole server to lock up maxxing
out the io. So, let's revert this for the time being and find another
way

This reverts commit e76906dc71227874fa4c3f48e04bdfc502b2fc01.