IF ((SELECT COUNT(recId) FROM pal_SurfaceAction WHERE [action] = 'Lookup Field') = 0)
	INSERT INTO pal_SurfaceAction (actionType, [action], isActive)
	VALUES (1, 'Lookup Field', 1)




IF EXISTS ( SELECT * 
            FROM   sysobjects 
            WHERE  id = object_id(N'[dbo].[sp_GetSurfaceActionLookupFieldValue]') 
                   and OBJECTPROPERTY(id, N'IsProcedure') = 1 )
BEGIN
    DROP PROCEDURE [dbo].[sp_GetSurfaceActionLookupFieldValue]
END