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

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

IF EXISTS (SELECT 1 FROM [dbo].[pal_Setup] WHERE recId = 1 AND [emailSubjectManagement] IS NULL)
UPDATE [dbo].[pal_Setup] SET [emailSubjectManagement] = 'Guest Contact Request - {GuestName}' where recId = 1;
GO

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