Pasted

-- EVENT: ILC_ApplyLicense
IF NOT EXISTS (SELECT TOP 1 1 FROM Event WHERE EventName = 'ILC_ApplyLicense') 
    INSERT INTO Event ([EventName], [AccessAs], [NoteExistsFlag], [RowPointer], [InWorkflow], [IsFrameworkEvent], [IsFrameworkIDOEvent], [IsFrameworkIDOSuspendableEvent], [Description], [EventHasChanged])
    VALUES ('ILC_ApplyLicense', NULL, 0, '39c656b8-7f23-49f5-814c-caed3e655ee7', 0, 0, 0, 0, NULL, 0)
 
IF NOT EXISTS (SELECT TOP 1 1 FROM EventHandler WHERE EventName = 'ILC_ApplyLicense' AND RowPointer = '81107B57-FEFC-4798-9AB5-4CC4D01596F8') 
    INSERT INTO EventHandler (EventName, Sequence, AppliesToObjects, Synchronous, Transactional, IgnoreFailure, Overridable, Active, Obsolete, Suspend, Description, RowPointer)
    VALUES (
    --EventName
     'ILC_ApplyLicense'
    --Sequence
    ,1
    --AppliesToObjects
    ,NULL
    --Synchronous
    ,0
    --Transactional
    ,0
    --IgnoreFailure
    ,0
    --Overridable
    ,1
    --Active
    ,1
    --Obsolete
    ,0
    --Suspend
    ,0
    --Description
    ,NULL
    --RowPointer
    ,'81107B57-FEFC-4798-9AB5-4CC4D01596F8')
 
IF NOT EXISTS (SELECT TOP 1 1 FROM EventAction WHERE RowPointer = '47E1C255-E9CC-462D-9B57-83281589D55F')
    INSERT INTO EventAction (EventHandlerRowPointer, Sequence, ActionType, Parameters, Description, RowPointer)
    VALUES (
    --EventHandlerRowPointer
     '81107B57-FEFC-4798-9AB5-4CC4D01596F8'
    --Sequence
    ,10
    --ActionType
    ,21
    --Parameters
    ,'IDO("Licenses")
METHOD("ApplyLicense")
PARMS(E(LicenseDocument), RE(Infobar))
RESULT(E(Infobar))'
    --Description
    ,NULL
    --RowPointer
    ,'47E1C255-E9CC-462D-9B57-83281589D55F')
 
GO