spAuditThis

Parameters

Parameter	Parameter Type	Mode
@ClientUsersID	int	IN
@AuditCodesID	int	IN
@ObjectGuid	uniqueidentifier	IN
@ObjectTypesID	int	IN

Definition

Copy



CREATE  PROCEDURE dbo.spAuditThis
    (
        @ClientUsersID int,
        @AuditCodesID int,
        @ObjectGuid uniqueidentifier,
        @ObjectTypesID int    
    )
AS

    /*
        auditcode: 1=create, 2=modify, 3=delete, 4=change owner
        see AuditCodes table

        objectType: 1=content, 2=page, 3=template, 4=image, 5=task, 6=user
        see ObjectTypes table
    */


    insert into Audits (
        ClientUsersID,
        AuditDate,
        AuditCodesID,
        ObjectGuid,
        ObjectTypesID
    )
    values(
        @ClientUsersID,
        getutcdate(),
        @AuditCodesID,
        @ObjectGuid,
        @ObjecttypesID
    )
    RETURN