Tables [dbo].[Forum_ForumPermission]
(local) > DotNetNuke_Community > Tables > dbo.Forum_ForumPermission
Properties
PropertyValue
Row Count0
Created2:07:31 PM Saturday, November 06, 2010
Last Modified2:07:31 PM Saturday, November 06, 2010
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_Forum_ForumPermission: ForumPermissionIDForumPermissionIDint4
No
1 - 1
ForumIDint4
No
PermissionIDint4
No
RoleIDint4
No
AllowAccessbit1
No
UserIDint4
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_Forum_ForumPermission: ForumPermissionIDPK_Forum_ForumPermissionForumPermissionID
Yes
SQL Script
CREATE TABLE [dbo].[Forum_ForumPermission]
(
[ForumPermissionID] [int] NOT NULL IDENTITY(1, 1),
[ForumID] [int] NOT NULL,
[PermissionID] [int] NOT NULL,
[RoleID] [int] NOT NULL,
[AllowAccess] [bit] NOT NULL,
[UserID] [int] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Forum_ForumPermission] ADD CONSTRAINT [PK_Forum_ForumPermission] PRIMARY KEY CLUSTERED ([ForumPermissionID]) ON [PRIMARY]
GO
Uses
Used By
Created 15 November 2010 15:40
Copyright Chris Paterra 2010 - All Rights Reserved