CREATE PROCEDURE dbo.[Forum_Tracking_ThreadCreateDelete]
    (
      @ForumID INT,
      @ThreadID INT,
      @UserID INT,
      @Add BIT,
      @ModuleID INT
    )
AS
    IF @Add = 1
        BEGIN
            INSERT  INTO dbo.Forum_TrackedThreads
                    (
                      [ForumID],
                      [ThreadID],
                      [UserID],
                      [CreatedDate],
                      [ModuleID]
                )
            VALUES  (
                      @ForumID,
                      @ThreadID,
                      @UserID,
                      GETDATE(),
                      @ModuleID
                )
        END
    IF @Add = 0
        BEGIN
            DELETE  dbo.Forum_TrackedThreads
            WHERE   ThreadID = @ThreadID
                    AND UserID = @UserID
        END

GO