if not exists (select * from sys.syscolumns where name = 'InventoryType' AND id = object_id(N'dbo.Inventory'))
    alter table dbo.Inventory
    add InventoryType varchar(64) null
        ,IsCurrent bit not null constraint DF_Inventory_IsCurrent DEFAULT(0)