[dbo].[UserSecurityInformation]

Property	Value
Row Count	0
Created	12:44:46 PM Thursday, October 04, 2007
Last Modified	12:44:46 PM Thursday, October 04, 2007

Property

Value

Row Count

Created

12:44:46 PM Thursday, October 04, 2007

Last Modified

12:44:46 PM Thursday, October 04, 2007

Name	Data Type	Max Length (Bytes)	Default
userID	int	4
folderAccessBit	int	4
securityLevelID	int	4
hasCustom	int	4	((0))

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

userID

int

folderAccessBit

int

securityLevelID

int

hasCustom

int

((0))

	Name	Columns	Unique
	pk_usersecurityinfo	userID

Name

Columns

Unique

pk_usersecurityinfo

userID

Name	Columns
fk_usersecurityinfo_level	securityLevelID->[dbo].[SecurityGroups].[groupID]
fk_usersecurityinfo_user	userID->[dbo].[Users].[userID]

Name

Columns

fk_usersecurityinfo_level

securityLevelID->[dbo].[SecurityGroups].[groupID]

fk_usersecurityinfo_user

userID->[dbo].[Users].[userID]

SQL Script

CREATE TABLE [dbo].[UserSecurityInformation]
(
[userID] [int] NOT NULL,
[folderAccessBit] [int] NULL,
[securityLevelID] [int] NULL,
[hasCustom] [int] NULL CONSTRAINT [DF__UserSecur__hasCu__477199F1] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UserSecurityInformation] ADD CONSTRAINT [pk_usersecurityinfo] PRIMARY KEY CLUSTERED ([userID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UserSecurityInformation] ADD CONSTRAINT [fk_usersecurityinfo_level] FOREIGN KEY ([securityLevelID]) REFERENCES [dbo].[SecurityGroups] ([groupID])
GO
ALTER TABLE [dbo].[UserSecurityInformation] ADD CONSTRAINT [fk_usersecurityinfo_user] FOREIGN KEY ([userID]) REFERENCES [dbo].[Users] ([userID])
GO