CREATE PROCEDURE dbo.[Forum_Forum_Add]
    (
      @GroupID INT,
      @IsActive BIT,
      @ParentID INT,
      @Name NVARCHAR(255),
      @Description NVARCHAR(2048),
      @IsModerated BIT,
      @ForumType INT,
      @PublicView BIT,
      @CreatedByUser INT,
      @PublicPosting BIT,
      @EnableForumsThreadStatus BIT,
      @EnableForumsRating BIT,
      @ForumLink NVARCHAR(255),
      @ForumBehavior INT,
      @AllowPolls BIT,
      @EnableRSS BIT,
      @EmailAddress NVARCHAR(100),
      @EmailFriendlyFrom NVARCHAR(50),
      @NotifyByDefault BIT,
      @EmailStatusChange BIT,
      @EmailServer NVARCHAR(150),
      @EmailUser NVARCHAR(100),
      @EmailPass NVARCHAR(50),
      @EmailEnableSSL BIT,
      @EmailAuth INT,
      @EmailPort INT,
      @EnableSitemap BIT,
      @SitemapPriority FLOAT
    )
AS
    DECLARE @SortOrder INT
    SET @SortOrder = ISNULL(( SELECT    MAX(SortOrder) + 1
                              FROM      dbo.Forum_Forums
                              WHERE     GroupID = @GroupID
                            ), 0)
    INSERT  INTO dbo.Forum_Forums
            (
              GroupID,
              IsActive,
              ParentID,
              Name,
              [Description],
              CreatedDate,
              CreatedByUser,
              UpdatedByUser,
              UpdatedDate,
              IsModerated,
              SortOrder,
              ForumType,
              PublicView,
              PublicPosting,
              EnableForumsThreadStatus,
              EnableForumsRating,
              ForumLink,
              ForumBehavior,
              AllowPolls,
              EnableRSS,
              EmailAddress,
              EmailFriendlyFrom,
              NotifyByDefault,
              EmailStatusChange,
              EmailServer,
              EmailUser,
              EmailPass,
              EmailEnableSSL,
              EmailAuth,
              EmailPort,
              EnableSitemap,
              SitemapPriority
          )
    VALUES  (
              @GroupID,
              @IsActive,
              @ParentID,
              @Name,
              @Description,
              GETDATE(),
              @CreatedByUser,
              @CreatedByUser,
              GETDATE(),
              @IsModerated,
              @SortOrder,
              @ForumType,
              @PublicView,
              @PublicPosting,
              @EnableForumsThreadStatus,
              @EnableForumsRating,
              @ForumLink,
              @ForumBehavior,
              @AllowPolls,
              @EnableRSS,
              @EmailAddress,
              @EmailFriendlyFrom,
              @NotifyByDefault,
              @EmailStatusChange,
              @EmailServer,
              @EmailUser,
              @EmailPass,
              @EmailEnableSSL,
              @EmailAuth,
              @EmailPort,
              @EnableSitemap,
              @SitemapPriority
          )        

    SELECT  SCOPE_IDENTITY()

GO