  
ALter table dbo.apiProdLines add ObjectElementId int;
GO 
update dbo.ApiProdLines set ObjectElementId =0 where ISNULL(ObjectElementId,-1)=-1;
GO


ALter table dbo.ApiProdOperations add ProductTechnLineId int;
GO 
update dbo.ApiProdOperations set ProductTechnLineId =0 where ISNULL(ProductTechnLineId,-1)=-1;
GO


  
ALter table dbo.ApiProdActivities add ReferenceOpeId int;
GO 
update dbo.ApiProdActivities set ReferenceOpeId =0 where ISNULL(ReferenceOpeId,-1)=-1;
GO



ALter table dbo.ApiProdActivities add ProductTechnLineId int;
GO 
update dbo.ApiProdActivities set ProductTechnLineId =0 where ISNULL(ProductTechnLineId,-1)=-1;
GO



ALter table dbo.apiProdLines add TechnLineId int;
GO 
update dbo.ApiProdLines set TechnLineId =0 where ISNULL(TechnLineId,-1)=-1;
GO

ALter table dbo.[ApiRoofSettelmentLines] add DimensionsCount int,
DimimensionMin decimal(16,3), DimimensionMax decimal(16,3)
GO 
update dbo.[ApiRoofSettelmentLines] set DimensionsCount =0, DimimensionMin=0  , DimimensionMax = 0 
where ISNULL(DimensionsCount,-1)=-1;
GO


