UPDATE pal_SurfaceFieldType
SET isActive = 1 
WHERE surfaceFieldType = 'Grid' 


IF (ISNULL((SELECT COUNT(recId)
	FROM pal_SurfaceFieldType 
	WHERE surfaceFieldType = 'Composite' ),0) = 0)
BEGIN
	INSERT INTO pal_SurfaceFieldType (surfaceFieldType, isActive) VALUES ('Composite', 1);
END


IF (ISNULL((SELECT COUNT(recId)
	FROM pal_SurfaceFieldType 
	WHERE surfaceFieldType = 'Address' ),0) = 0)
BEGIN
	INSERT INTO pal_SurfaceFieldType (surfaceFieldType, isActive) VALUES ('Address', 1);
END




