/*==============================================================*/
/* Upgrade struktury z wersji 55 do 56                          */
/* Do nowego pola wpisywany jest '', jeśli stare pole jest      */
/* zerowe, lub wartośc starego pola, jeśli jest niezerowe.      */
/*==============================================================*/

ALTER TABLE Product ADD COLUMN KitchenPrinterNumbers text(40) null 
GO

UPDATE Product SET KitchenPrinterNumbers = (CASE WHEN KitchenPrinterNumber > 0 THEN KitchenPrinterNumber ELSE '' END)
GO

UPDATE StructureVersion SET Version = 56
GO
