-- EVENT: ILC_RegenerateReplicationTriggers
IF NOT EXISTS (SELECT TOP 1 1 FROM Event WHERE EventName = 'ILC_RegenerateReplicationTriggers') 
	INSERT INTO Event ([EventName], [AccessAs], [NoteExistsFlag], [RowPointer], [InWorkflow], [IsFrameworkEvent], [IsFrameworkIDOEvent], [IsFrameworkIDOSuspendableEvent], [Description], [EventHasChanged])
	VALUES ('ILC_RegenerateReplicationTriggers', NULL, 0, '4a4c653c-31e8-4a8e-8905-ee9a5922b817', 0, 0, 0, 0, NULL, 0)
	
IF NOT EXISTS (SELECT TOP 1 1 FROM EventHandler WHERE EventName = 'ILC_RegenerateReplicationTriggers' AND RowPointer = '63420546-2D84-40DA-8063-29B46687CB6C') 
	INSERT INTO EventHandler (EventName, Sequence, AppliesToObjects, Synchronous, Transactional, IgnoreFailure, Overridable, Active, Obsolete, Suspend, Description, RowPointer)
	VALUES (
	--EventName
	 'ILC_RegenerateReplicationTriggers'
	--Sequence
	,1
	--AppliesToObjects
	,NULL
	--Synchronous
	,0
	--Transactional
	,0
	--IgnoreFailure
	,0
	--Overridable
	,1
	--Active
	,1
	--Obsolete
	,0
	--Suspend
	,0
	--Description
	,NULL
	--RowPointer
	,'63420546-2D84-40DA-8063-29B46687CB6C')

IF NOT EXISTS (SELECT TOP 1 1 FROM EventAction WHERE RowPointer = '6C5975EF-F985-4A32-9B74-9C6E0B912FDB')
	INSERT INTO EventAction (EventHandlerRowPointer, Sequence, ActionType, Parameters, Description, RowPointer)
	VALUES (
	--EventHandlerRowPointer
	 '63420546-2D84-40DA-8063-29B46687CB6C'
	--Sequence
	,10
	--ActionType
	,21
	--Parameters
	,'IDO("SLReplicationTriggers")
METHOD("RegenerateReplicationTriggers")
PARMS(E(TableNameVar), E(ServerNameVar), E(DatabaseNameVar), RE(Infobar))
RESULT(E(Infobar))'
	--Description
	,NULL
	--RowPointer
	,'6C5975EF-F985-4A32-9B74-9C6E0B912FDB')

GO