if not exists (select column_name from INFORMATION_SCHEMA.columns where table_name = '{objectQualifier}tblNaDevEventSignUpQuestionOptions' and column_name = 'LinkedQuestionId')
 begin
   alter table {databaseOwner}[{objectQualifier}tblNaDevEventSignUpQuestionOptions] add LinkedQuestionId int null
 end
GO


alter procedure {databaseOwner}{objectQualifier}usp_insertEventSignUpQuestionOption
(
 @signUpQuestionId int,
 @name nvarchar(255),
 @sortOrder int,
 @priceAdjustment money,
 @capacity int,
 @LinkedQuestionId int
)

as

set nocount on
  
	insert into {databaseOwner}[{objectQualifier}tblNaDevEventSignUpQuestionOptions] (signUpQuestionId,name,sortOrder,priceAdjustment,capacity,LinkedQuestionId)

	values (@signUpQuestionId,@name,@sortOrder,@priceAdjustment,@capacity,@LinkedQuestionId)
			
	return

GO