fixed queries in manager interface. modified columns in orders table