USP_FAFEVENTCAMPAIGN_INITIALIZE_PARAMETER

create procedure dbo.USP_FAFEVENTCAMPAIGN_INITIALIZE_PARAMETER
as
begin
     -- add a relationshiptype

  IF NOT EXISTS (select 1 from dbo.RELATIONSHIPTYPECODE where DESCRIPTION = 'FAF National Fundraising Group') 
    EXEC USP_RELATIONSHIPTYPECODE_CREATEENTRY @DESCRIPTION  ='FAF National Fundraising Group', @ACTIVE =1;

  --2. create entries in FAFRELATIONSHIPTYPE

  DECLARE @CHANGEAGENTID uniqueidentifier;
  exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

  declare @CURRENTDATE datetime
  set @CURRENTDATE = getdate()

  IF NOT EXISTS(Select 1 from GROUPTYPE where NAME = 'FAF National Fundraising Group')
    INSERT INTO GROUPTYPE (ID,ISACTIVE,CANBEDONOR,INCLUDEMEMBERGIVING,NAME,DESCRIPTION,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED)
    VALUES(NEWID(),1,0,0,'FAF National Fundraising Group','',@CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)
end