add type to item and manger and sql statements