Pasted

-- EVENT: ILC_RegenerateViewsToMasterSite
IF NOT EXISTS (SELECT TOP 1 1 FROM Event WHERE EventName = 'ILC_RegenerateViewsToMasterSite') 
    INSERT INTO Event ([EventName], [AccessAs], [NoteExistsFlag], [RowPointer], [InWorkflow], [IsFrameworkEvent], [IsFrameworkIDOEvent], [IsFrameworkIDOSuspendableEvent], [Description], [EventHasChanged])
    VALUES ('ILC_RegenerateViewsToMasterSite', NULL, 0, '42168ef3-93cf-4895-91be-7fcd7e200c55', 0, 0, 0, 0, NULL, 0)
    
IF NOT EXISTS (SELECT TOP 1 1 FROM EventHandler WHERE EventName = 'ILC_RegenerateViewsToMasterSite' AND RowPointer = 'FEBD40B5-B98F-4C6F-8B5E-F2A048BAEE94') 
    INSERT INTO EventHandler (EventName, Sequence, AppliesToObjects, Synchronous, Transactional, IgnoreFailure, Overridable, Active, Obsolete, Suspend, Description, RowPointer)
    VALUES (
    --EventName
     'ILC_RegenerateViewsToMasterSite'
    --Sequence
    ,1
    --AppliesToObjects
    ,NULL
    --Synchronous
    ,0
    --Transactional
    ,0
    --IgnoreFailure
    ,0
    --Overridable
    ,1
    --Active
    ,1
    --Obsolete
    ,0
    --Suspend
    ,0
    --Description
    ,NULL
    --RowPointer
    ,'FEBD40B5-B98F-4C6F-8B5E-F2A048BAEE94')
 
IF NOT EXISTS (SELECT TOP 1 1 FROM EventAction WHERE RowPointer = 'BA915745-0699-4887-9A79-EAEEA84A4B64')
    INSERT INTO EventAction (EventHandlerRowPointer, Sequence, ActionType, Parameters, Description, RowPointer)
    VALUES (
    --EventHandlerRowPointer
     'FEBD40B5-B98F-4C6F-8B5E-F2A048BAEE94'
    --Sequence
    ,10
    --ActionType
    ,21
    --Parameters
    ,'IDO("SLReplicationTriggers")
METHOD("ReCreateUsingSiteViewSp")
PARMS(E(IntraNet_Name), RE(Infobar))
RESULT(E(Infobar))'
    --Description
    ,NULL
    --RowPointer
    ,'BA915745-0699-4887-9A79-EAEEA84A4B64')
 
GO