changes made for client db
completed client db and all for compilation