add indexes for event related tables
dry up specs