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

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