[dbo].[Forum_ThreadsRead]

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:31 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:31 PM Saturday, November 06, 2010

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_Forum_ThreadsRead: ForumID\UserID$	ForumID	int	4
$Cluster Primary Key PK_Forum_ThreadsRead: ForumID\UserID$	UserID	int	4
	ReadThreads	nvarchar(4000)	8000
	LastPurseDate	datetime	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_Forum_ThreadsRead: ForumID\UserID$

ForumID

int

$Cluster Primary Key PK_Forum_ThreadsRead: ForumID\UserID$

UserID

int

ReadThreads

nvarchar(4000)

8000

LastPurseDate

datetime

	Name	Columns	Unique
$Cluster Primary Key PK_Forum_ThreadsRead: ForumID\UserID$	PK_Forum_ThreadsRead	ForumID, UserID

Name

Columns

Unique

$Cluster Primary Key PK_Forum_ThreadsRead: ForumID\UserID$

PK_Forum_ThreadsRead

ForumID, UserID

Name	No Check	Replication	Delete	Columns
FK_Forum_ThreadsRead_Forum_Forums			Cascade	ForumID->[dbo].[Forum_Forums].[ForumID]

Name

No Check

Replication

Delete

Columns

FK_Forum_ThreadsRead_Forum_Forums

Cascade

ForumID->[dbo].[Forum_Forums].[ForumID]

SQL Script

CREATE TABLE [dbo].[Forum_ThreadsRead]
(
[ForumID] [int] NOT NULL,
[UserID] [int] NOT NULL,
[ReadThreads] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LastPurseDate] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Forum_ThreadsRead] ADD CONSTRAINT [PK_Forum_ThreadsRead] PRIMARY KEY CLUSTERED ([ForumID], [UserID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Forum_ThreadsRead] WITH NOCHECK ADD CONSTRAINT [FK_Forum_ThreadsRead_Forum_Forums] FOREIGN KEY ([ForumID]) REFERENCES [dbo].[Forum_Forums] ([ForumID]) ON DELETE CASCADE NOT FOR REPLICATION
GO