
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE
	TABLE_NAME = 'publ_Quotes' AND
	COLUMN_NAME = 'QuoteDetails_QuoteOrigin')
BEGIN
ALTER TABLE [dbo].[publ_Quotes]
ADD [QuoteDetails_QuoteOrigin] [nvarchar](max) NULL
END;

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE
	TABLE_NAME = 'publ_Quotes' AND
	COLUMN_NAME = 'QuoteDetails_AttendeeEmail')
BEGIN
ALTER TABLE [dbo].[publ_Quotes]
ADD [QuoteDetails_AttendeeEmail] [nvarchar](max) NULL,
[QuoteDetails_AttendeeName] [nvarchar](max) NULL,
[QuoteDetails_AttendeeNumber] [nvarchar](max) NULL,
[QuoteDetails_AttendeeRole] [nvarchar](max) NULL,
[QuoteDetails_AttendeeSchoolName] [nvarchar](max) NULL,
[QuoteDetails_GeneralNotes] [nvarchar](max) NULL
END;