IF NOT EXISTS (SELECT 1 FROM pal_SurfaceField 
WHERE surfaceFieldName = 'PromotionItems_PromotionItem_NonVATItem')
BEGIN

SET IDENTITY_INSERT [dbo].[pal_SurfaceField] ON 
INSERT [dbo].[pal_SurfaceField] ([recId], [surfaceId], [surfaceFieldName], [surfaceFieldDisplay], [surfaceFieldTypeId], [length], [required], [lookupCategory], [relationalFields], [relationalValues], [relationalOrderBy], [relationalSurface], [relationalObject], [parentId], [sequence], [isActive], [isGrid], [isFilter], [colSequence], [contentId], [defaultToCurrent], [isControlled], [controlledValue], [controlText], [isAutoPostback], [isHidden], [isReadOnly], [placeholder], [isUnique], [actionType], [action], [actionSource], [isComparable], [alternateView], [isHiddenFromWizzard], [surfaceDateTypeId], [isHiddenFromView], [actionValue], [surfaceFieldSize], [isLabelHidden], [isOnNewLine], [labelSize], [isHiddenFromForm], [accessLevel], [hasBottomBorder], [hasFullBorder], [defaultValue], [validationType], [enableBulkUpdate], [isCurrency], [isVerticalHeader], [gridSequence], [isGrouped], [isCloneable], [isCustomSource], [relationalWhere], [groupedDisplayCount])
VALUES (3218, 3043, N'PromotionItems_PromotionItem_NonVATItem', N'Non-VAT Item', 29, 0, 0, 0, N'', N'', N'', N'', N'', 21, 14, 1, 0, 0, 0, 0, 0, 0, N'', N'', 0, 0, 0, N'', 0, 0, 0, 0, 0, 0, 0, 0, 0, N'', 6, 0, 0, 12, 0, 1, 0, 0, N'', 0, 0, 0, 0, 0, 0, 0, 0, N'', 0)
SET IDENTITY_INSERT [dbo].[pal_SurfaceField] OFF

UPDATE [dbo].[pal_SurfaceField]
SET surfaceFieldTypeId = 29, actionType = 1 ,action = 19, actionSource = 1754,  actionValue = 3217
WHERE [surfaceFieldName] = 'PromotionItems_PromotionItem_NonVATItem';

END;

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE
	TABLE_NAME = 'publ_PromotionItems' AND
	COLUMN_NAME = 'PromotionItems_PromotionItem_NonVATItem')
BEGIN

ALTER TABLE [dbo].[publ_PromotionItems]
ADD PromotionItems_PromotionItem_NonVATItem nvarchar(10) NULL;

UPDATE publ_PromotionItems
SET PromotionItems_PromotionItem_NonVATItem = ''
where PromotionItems_PromotionItem_NonVATItem is null;
END;