added daily report, fixed schema