added type columns to db