[dbo].[Forum_Moderate

[dbo].[Forum_Moderate_AddHistory]

(local) > DotNetNuke_Community > Stored Procedures > dbo.Forum_Moderate_AddHistory

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@ObjectID	int	4
@PortalID	int	4
@ModeratorID	int	4
@Notes	nvarchar(1024)	2048
@ActionID	int	4

CREATE PROCEDURE dbo.Forum_Moderate_AddHistory
    (
      @ObjectID INT,
      @PortalID INT,
      @ModeratorID INT,
      @Notes NVARCHAR(1024),
      @ActionID INT
    )
AS
    INSERT  dbo.Forum_Moderate_History
            (
              ModeratorID,
              PortalID,
              Notes,
              CreatedDate,
              PostID,
              ModerateActionID
        )
    VALUES  (
              @ModeratorID,
              @PortalID,
              @Notes,
              GETDATE(),
              @ObjectID,
              @ActionID
        )

GO