[dbo].[USERSEC]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	2
Created	3:44:42 PM Friday, June 13, 2003
Last Modified	3:44:42 PM Friday, June 13, 2003

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

3:44:42 PM Friday, June 13, 2003

Last Modified

3:44:42 PM Friday, June 13, 2003

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key USERSEC_PK: USERID\DOMAINID$	DOMAINID	int	4
$Cluster Primary Key USERSEC_PK: USERID\DOMAINID$	USERID	int	4
	SCNAME	varchar(32)	32
	SCPASS	varchar(32)	32
	SCDESC	varchar(127)	127
	SCTYPE	int	4
	SCDATE	int	4
	SCMAIL	varchar(64)	64
	SCOPTION1	varchar(64)	64
	SCRIGHTS	text	max
	SCMTYPE	int	4
	SCMSRV	varchar(127)	127
	SCSTATE	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key USERSEC_PK: USERID\DOMAINID$

DOMAINID

int

$Cluster Primary Key USERSEC_PK: USERID\DOMAINID$

USERID

int

SCNAME

varchar(32)

SCPASS

varchar(32)

SCDESC

varchar(127)

127

SCTYPE

int

SCDATE

int

SCMAIL

varchar(64)

SCOPTION1

varchar(64)

SCRIGHTS

text

max

SCMTYPE

int

SCMSRV

varchar(127)

127

SCSTATE

int

	Name	Columns	Unique
$Cluster Primary Key USERSEC_PK: USERID\DOMAINID$	USERSEC_PK	USERID, DOMAINID

Name

Columns

Unique

$Cluster Primary Key USERSEC_PK: USERID\DOMAINID$

USERSEC_PK

USERID, DOMAINID

SQL Script

CREATE TABLE [dbo].[USERSEC]
(
[DOMAINID] [int] NOT NULL,
[USERID] [int] NOT NULL,
[SCNAME] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SCPASS] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SCDESC] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SCTYPE] [int] NULL,
[SCDATE] [int] NULL,
[SCMAIL] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SCOPTION1] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SCRIGHTS] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SCMTYPE] [int] NULL,
[SCMSRV] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SCSTATE] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[USERSEC] ADD CONSTRAINT [USERSEC_PK] PRIMARY KEY CLUSTERED ([USERID], [DOMAINID]) ON [PRIMARY]
GO