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

IF EXISTS (SELECT 1 FROM [dbo].[pal_Setup] WHERE recId = 1 AND emailSubjectToSchoolContacts IS NULL)
UPDATE [dbo].[pal_Setup] SET emailSubjectToSchoolContacts = 'IEB Postbox - New Document Notice [{ParentFolder}]' where recId = 1;
GO