IF NOT EXISTS (SELECT 1 FROM pal_SurfaceField WHERE surfaceFieldName = 'RetailerData_RetailerData_AttachmentId')
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
(3235,
4107,
N'RetailerData_RetailerData_AttachmentId',
N'AttachmentId',
4,
0,
0,
0,
'',
'',
'',
'',
'',
3075,
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_RetailerData' AND
	COLUMN_NAME = 'RetailerData_RetailerData_AttachmentId')
BEGIN

ALTER TABLE [dbo].[publ_RetailerData]
ADD [RetailerData_RetailerData_AttachmentId] int NULL;

UPDATE [dbo].[publ_RetailerData]
SET [RetailerData_RetailerData_AttachmentId] = 0;

END;

