[dbo].[Forum_Permission]

(local) > DotNetNuke_Community > Tables > dbo.Forum_Permission

Properties
Columns
Indexes
SQL Script
Uses
Used By

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	9
Created	2:07:31 PM Saturday, November 06, 2010
Last Modified	2:07:31 PM Saturday, November 06, 2010

Columns

Name	Data Type	Max Length (Bytes)	Identity
PermissionID	int	4	1 - 1
PermissionCode	nvarchar(50)	100
PermissionKey	nvarchar(20)	40
PermissionName	nvarchar(50)	100

Indexes

	Name	Columns	Unique
	PK_Forum_Permission	PermissionID

SQL Script

CREATE TABLE [dbo].[Forum_Permission]
(
[PermissionID] [int] NOT NULL IDENTITY(1, 1),
[PermissionCode] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PermissionKey] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PermissionName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Forum_Permission] ADD CONSTRAINT [PK_Forum_Permission] PRIMARY KEY CLUSTERED ([PermissionID]) ON [PRIMARY]
GO

Uses

Used By