CREATE TABLE [dbo].[Forum_Groups]
(
[GroupID] [int] NOT NULL IDENTITY(1, 1),
[Name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PortalID] [int] NULL,
[ModuleID] [int] NOT NULL,
[SortOrder] [int] NOT NULL CONSTRAINT [DF_Forum_Groups_SortOrder] DEFAULT ((0)),
[CreatedDate] [datetime] NOT NULL CONSTRAINT [DF_Forum_Groups_CreatedDate] DEFAULT (getdate()),
[CreatedByUser] [int] NOT NULL,
[UpdatedByUser] [int] NULL,
[UpdatedDate] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Forum_Groups] ADD CONSTRAINT [PK_Forum_Groups] PRIMARY KEY CLUSTERED ([GroupID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Forum_Groups] ADD CONSTRAINT [IX_Forum_Groups] UNIQUE NONCLUSTERED ([GroupID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Forum_Groups_ModuleID] ON [dbo].[Forum_Groups] ([ModuleID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Forum_Groups] ADD CONSTRAINT [FK_Forum_Groups_Modules] FOREIGN KEY ([ModuleID]) REFERENCES [dbo].[Modules] ([ModuleID]) ON DELETE CASCADE
GO