update tables to include ping response