UpdateAuthorization
Managed
ObjectID:
106535513
CREATE TRIGGER UpdateAuthorization
ON authorizations
AFTER UPDATE
AS
BEGIN
SET NOCOUNT ON;
DECLARE @NOW DATE
SET @NOW = GETDATE()
INSERT INTO [000106IneoAudit].[dbo].[EventQueue](
EventSource,
EventID,
FireActivity,
FireActivityHeaders,
EventStatus,
UserName,
CreateDate,
UpdateDate )
SELECT
'authorizations.authorizationUpdate.1',
i.ID,
'update authorization',
'{"igm-username":"EventQueueTxUser", "igm-authid":"' + i.authorizationid + '", "igm-clientid":"' + ltrim(str(i.clientid)) + '"}',
1,
'EventQueueTxUser',
@NOW,
@NOW
FROM
INSERTED AS i
END
-- Trigger is managed by mdata
AuthorizationUpdate
Managed
ObjectID:
905158370
CREATE TRIGGER AuthorizationUpdate
ON authorizations
AFTER UPDATE
AS
BEGIN
SET NOCOUNT ON;
DECLARE @NOW DATE
SET @NOW = GETDATE()
INSERT INTO [000106IneoAudit].[dbo].[EventQueue](
EventSource,
EventID,
FireActivity,
FireActivityHeaders,
EventStatus,
UserName,
CreateDate,
UpdateDate )
SELECT
'authorizations.authorizationUpdate.1',
i.ID,
'update authorization',
'{"igm-username":"EventQueueTxUser", "igm-authid":"' + i.authorizationid + '", "igm-clientid":"' + ltrim(str(i.clientid)) + '"}',
1,
'EventQueueTxUser',
@NOW,
@NOW
FROM
INSERTED AS i
END
-- Trigger is managed by mdata