adjust actual eventlog insertion to be upsert

the relevant columns are already indexed
still remove entries that were duplicates in upsert
change further reindexes to upsert
include new upserts in upgrade scripts
include new upserts in schema