USP_DATAFORMTEMPLATE_ADD_FAF_SYSTEM_DEFAULT_LABEL

CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_FAF_SYSTEM_DEFAULT_LABEL    
(    
  --@ID uniqueidentifier = null output,    

  @CHANGEAGENTID uniqueidentifier = null   
  --@FAFSYSTEMDEFAULTNAME nvarchar(100) = '',    

  --@FAFSYSTEMDEFAULTVALUE nvarchar(100) = '',    

  --@FAFSYSTEMDEFAULTTEXT nvarchar(200) = ''    


)    
as    

set nocount on;    

--if @ID is null      set @ID = newid()    


if @CHANGEAGENTID is null      
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output    

declare @CURRENTDATE datetime    
set @CURRENTDATE = getdate()    

begin try    
 DELETE dbo.FAFSYSTEMDEFAULTLABEL

 -- handle inserting the data     

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Participant', 'Participant', 'Label for the participant of the event (Walker, Athlete, etc.)', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Donor', 'Donor', 'Label for a person making a donation in support of the event, a participant or team', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Individual', 'Individual', 'Label for a person', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Family', 'Household', 'Label for group of people registered in a single transaction who are doing combined fundraising.(Household, Family Team, etc).', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Head of Household', 'Household Leader', 'Label for the family leader (family leader, etc)', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Team', 'Team', 'Label for special groupings in events (team, party, etc.)', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Team Member', 'Team Member', 'Label for participants that are members of a grouping in the events (team, party, etc.)', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Team Captain', 'Team Leader', 'Label for the leader of the team or grouping in the event', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Team Co-Captain', 'Team Co-Leader', 'Label for any additional leader of the team or grouping in the event', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Company', 'Company', 'Label for a company', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Group Team', 'Company Team', 'Label for teams that are grouped together (company team, group teams, etc)', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Group Team Leader', 'Company Leader', 'Label for leader of the group teams (company team captain, group team captain, etc)', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Group Co-Captain', 'Company Co-Leader', 'Label for additional leaders of the group teams (company team captain, group team captain, etc)', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Sponsor', 'Sponsor', 'A company that may or may not fundraise but sponsors the event and receives logo placement, booths and other benefits.', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)       

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Volunteer', 'Volunteer', 'Label for the people that will be helping with the event (Event Support Staff, coordinator, etc)', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)         

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Fitness Coach', 'Fitness Coach', 'Label for the person that will be conducting physical fitness training for the event (trainer, instructor, teacher, etc)', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)        

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Fundraising Coach', 'Fundraising Coach', 'Label for the staff person that will be supporting company, teams and participants in their fundraising (coordinator, instructor, mentor , fundraising guru, consultant etc)', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)      

 insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Household Member', 'Household Member', 'Label for participants that are members of a grouping in the events (team, party, etc.)', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    



 -- Add plurals data label   

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Participants', 'Participants', 'Label for the participants of the event (Walker, Athlete, etc.)', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Donors', 'Donors', 'Label for persons making a donation in support of the event, a participant or team', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Individuals', 'Individuals', 'Label for persons', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Families', 'Households', 'Label for group of people registered in a single transaction who are doing combined fundraising.(Households, Families Team, etc).', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Heads of Households', 'Household Leaders', 'Label for the families leader (families leader, etc)', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Teams', 'Teams', 'Label for special groupings in events (teams, parties, etc.)', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Team Members', 'Team Members', 'Label for participants that are members of a grouping in the events (teams, parties, etc.)', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Team Captains', 'Team Leaders', 'Label for the leader of the teams or grouping in the event', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Team Co-Captains', 'Team Co-Leaders', 'Label for any additional leader of the teams or grouping in the event', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Companies', 'Companies', 'Label for a companies', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Group Teams', 'Company Teams', 'Label for teams that are grouped together (company teams, group teams, etc)', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Group Team Leaders', 'Company Leaders', 'Label for leader of the group teams (company team captains, group team captains, etc)', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Group Co-Captains', 'Company Co-Leaders', 'Label for additional leaders of the group teams (company team captains, group team captains, etc)', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Sponsors', 'Sponsors', 'A company that may or may not fundraise but sponsors the event and receives logo placement, booths and other benefits.', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)       

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Volunteers', 'Volunteers', 'Label for peoples that will be helping with the event (Event Support Staff, coordinator, etc)', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)         

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Fitness Coaches', 'Fitness Coaches', 'Label for persons that will be conducting physical fitness training for the event (trainer, instructor, teacher, etc)', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)        

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
   (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Fundraising Coaches', 'Fundraising Coaches', 'Label for staff persons that will be supporting company, teams and participants in their fundraising (coordinator, instructor, mentor , fundraising guru, consultant etc)', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)      

  insert into dbo.FAFSYSTEMDEFAULTLABEL    
    (ID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, FAFSYSTEMDEFAULTTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), 'Household Members', 'Household Members', 'Label for participants that are members of a grouping in the events (teams, parties, etc.)', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

end try    

begin catch    
    exec dbo.USP_RAISE_ERROR    
    return 1    
end catch    

return 0