added user sorcery to database and updated views for user