updating schema and fixing syntax errors