IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE
	TABLE_NAME = 'pal_Setup' AND
	COLUMN_NAME = 'submissionsEmail')
BEGIN
	ALTER TABLE	[dbo].[pal_Setup]
		ADD submissionsEmail NVARCHAR(200) NULL
END

IF EXISTS (SELECT 1 FROM [dbo].[pal_Setup] WHERE recId = 1 AND submissionsEmail IS NULL)
UPDATE [dbo].[pal_Setup] SET submissionsEmail = 'submissions@ieb.co.za' where recId = 1;
GO