
IF NOT EXISTS (SELECT * from dbo.pal_SurfaceField 
where surfaceFieldName = 'GroupPostboxSchools_GroupPostboxSchools_SelectedSchoolsNumber' 
or surfaceFieldName = 'GroupPostbox_GroupPostboxDetails_SelectedSchoolsNumber')
BEGIN

INSERT [dbo].[pal_SurfaceField] ([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 (3084, N'GroupPostboxSchools_GroupPostboxSchools_SelectedSchoolsNumber', N'Selected Schools Number', 29, 0, 0, 0, N'0', N'', N'', N'0', N'', 548, 2, 1, 0, 0, 0, 0, 0, 0, N'', N'', 0, 0, 0, N'', 0, 0, 0, 0, 0, 0, 0, 0, 0, N'', 3, 1, 0, 12, 0, 1, 0, 0, N'', 0, 0, 0, 0, 2, 0, 0, 0, N'', 0)
INSERT [dbo].[pal_SurfaceField] ([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 (3083, N'GroupPostbox_GroupPostboxDetails_SelectedSchoolsNumber', N'Selected Schools Number', 29, 0, 0, 0, N'0', N'', N'', N'0', N'', 540, 9, 1, 0, 0, 0, 0, 0, 0, N'', N'', 0, 0, 0, N'', 0, 0, 0, 0, 0, 0, 0, 0, 0, N'', 3, 1, 0, 12, 0, 1, 0, 0, N'', 0, 0, 0, 0, 10, 0, 0, 0, N'', 0)

END;