[dbo].[Forum_TemplateTypes]

(local) > DotNetNuke_Community > Tables > dbo.Forum_TemplateTypes

Properties
Columns
Indexes
SQL Script
Uses
Used By

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	11
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	Default
ForumTemplateTypeID	int	4	1 - 1
TemplateTypeName	nvarchar(50)	100
IsActive	bit	1		((1))

Indexes

	Name	Columns	Unique
	PK_Forum_TemplateTypes	ForumTemplateTypeID

SQL Script

CREATE TABLE [dbo].[Forum_TemplateTypes]
(
[ForumTemplateTypeID] [int] NOT NULL IDENTITY(1, 1),
[TemplateTypeName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsActive] [bit] NOT NULL CONSTRAINT [DF__Forum_Tem__IsAct__255C790F] DEFAULT ((1))
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Forum_TemplateTypes] ADD CONSTRAINT [PK_Forum_TemplateTypes] PRIMARY KEY CLUSTERED ([ForumTemplateTypeID]) ON [PRIMARY]
GO

Uses

Used By

[dbo].[Forum_EmailTemplatesByModuleIDGet]