added notes and time fields to log table; fixed syntax errors