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

SET IDENTITY_INSERT [dbo].[pal_SurfaceField] ON 
INSERT INTO [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
(3234,
3102,
N'ShoppingListSearchHistoryItems_ProductSearchHistoryItems_RetailerDataItemId',
N'RetailerDataItemId',
4,
0,
0,
0,
'',
'',
'',
'',
'',
1988,
1,
1,
0,
0,
0,
0,
0,
0,
'',
'',
0,
1,
0,
'',
0,
0,
0,
0,
0,	
0,
0,
0,
0,
'',
3,
1,
0,
12,
0,
1,
0,
0,
'',
0,
0,
0,
0,
11,
0,
0,
0,
'',
0);

SET IDENTITY_INSERT [dbo].[pal_SurfaceField] OFF 
END;

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

ALTER TABLE [dbo].[publ_ShoppingListSearchHistoryItems]
ADD [ShoppingListSearchHistoryItems_ProductSearchHistoryItems_RetailerDataItemId] int NULL;

UPDATE [dbo].[publ_ShoppingListSearchHistoryItems]
SET [ShoppingListSearchHistoryItems_ProductSearchHistoryItems_RetailerDataItemId] = 0;

END;

