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

GO