-- 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