add index to id on the journals table

this takes our top consuming query from ~250ms to <1ms
Personally I prefer creating indices without names, not sure what the prevailing style is.

Also, how the hell do we have a tabl ewith no index on the pk?