update data for legacy tables