added auto increment to id column in hop_records table