/*==============================================================*/
/* Upgrade struktury z wersji 44 do 45                          */
/*==============================================================*/

ALTER TABLE Product ADD COLUMN Precission smallint null
GO
ALTER TABLE Product ADD COLUMN SoldAmount decimal(14,3) null
GO
ALTER TABLE Product ADD COLUMN SoldValue decimal(14,2) null
GO

UPDATE Product SET Precission = -999
GO
UPDATE Product SET SoldAmount = 0
GO
UPDATE Product SET SoldValue = 0
GO

UPDATE StructureVersion SET Version = 45
GO
