fixes events table to remove location column and add reference to location_id