[dbo].[Forum_FilterWords]

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

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

2:07:30 PM Saturday, November 06, 2010

Last Modified

2:07:30 PM Saturday, November 06, 2010

	Name	Data Type	Max Length (Bytes)	Identity
	ItemID	int	4	1 - 1
$Cluster Primary Key PK_Forum_FilterWords: PortalID\BadWord$	PortalID	int	4
$Cluster Primary Key PK_Forum_FilterWords: PortalID\BadWord$	BadWord	nvarchar(50)	100
	ReplacedWord	nvarchar(50)	100
	CreatedBy	int	4
	CreatedOn	datetime	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

ItemID

int

1 - 1

$Cluster Primary Key PK_Forum_FilterWords: PortalID\BadWord$

PortalID

int

$Cluster Primary Key PK_Forum_FilterWords: PortalID\BadWord$

BadWord

nvarchar(50)

100

ReplacedWord

nvarchar(50)

100

CreatedBy

int

CreatedOn

datetime

	Name	Columns	Unique
$Cluster Primary Key PK_Forum_FilterWords: PortalID\BadWord$	PK_Forum_FilterWords	PortalID, BadWord

Name

Columns

Unique

$Cluster Primary Key PK_Forum_FilterWords: PortalID\BadWord$

PK_Forum_FilterWords

PortalID, BadWord

Name	No Check	Replication	Update	Delete	Columns
FK_Forum_FilterWords_Portals			Cascade	Cascade	PortalID->[dbo].[Portals].[PortalID]

Name

No Check

Replication

Update

Delete

Columns

FK_Forum_FilterWords_Portals

Cascade

PortalID->[dbo].[Portals].[PortalID]

SQL Script

CREATE TABLE [dbo].[Forum_FilterWords]
(
[ItemID] [int] NOT NULL IDENTITY(1, 1),
[PortalID] [int] NOT NULL,
[BadWord] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ReplacedWord] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreatedBy] [int] NULL,
[CreatedOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Forum_FilterWords] ADD CONSTRAINT [PK_Forum_FilterWords] PRIMARY KEY CLUSTERED ([PortalID], [BadWord]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Forum_FilterWords] WITH NOCHECK ADD CONSTRAINT [FK_Forum_FilterWords_Portals] FOREIGN KEY ([PortalID]) REFERENCES [dbo].[Portals] ([PortalID]) ON DELETE CASCADE ON UPDATE CASCADE NOT FOR REPLICATION
GO