Table Properties

Name	Value
Owner	dbo
Created	2004-05-31
Located On	PRIMARY
Rows	1
Data Size KB	8
Index Size KB	64

Columns

	Name	Description	Data Type	Length	NULL	Default	RowGUIDCOL	Computed
	UserName		nvarchar	50
	UserId		int	4
	ScreenName		nvarchar	50
	Password		nvarchar	50
	Email		nvarchar	75
	ForumView		int	4
	ProfileApproved		bit	1
	Approved		bit	1
	Trusted		bit	1
	FakeEmail		nvarchar	75
	URL		nvarchar	100
	Signature		nvarchar	256
	DateCreated		datetime	8
	TrackYourPosts		bit	1
	LastLogin		datetime	8
	LastActivity		datetime	8
	TimeZone		int	4
	Location		nvarchar	100
	Occupation		nvarchar	100
	Interests		nvarchar	100
	MSN		nvarchar	50
	Yahoo		nvarchar	50
	AIM		nvarchar	50
	ICQ		nvarchar	50
	TotalPosts		int	4
	HasAvatar		bit	1
	ShowUnreadTopicsOnly		bit	1
	Style		nvarchar	20
	ShowAvatar		bit	1
	DateFormat		nvarchar	10
	PostViewOrder		bit	1
	FlatView		bit	1
	DisplayInMemberList		bit	1
	AvatarUrl		nvarchar	256
	AvatarType		int	4
	Attributes		binary	4

Total: 36 column(s)

Indentity Column

Name	Seed	Increment	Not for Replication
UserId	1	1

Check Constraints

No check constraints exists

Indexes

Index	Primary	Unique	Clustered
PK_Users
IX_Users_UniqueEmail
IX_Users
IX_Users_1

Permissions

No direct permissions defined (N.B. Permissions may be inherited from roles

SQL

CREATE TABLE [Users] (
	[UserName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[UserId] [int] IDENTITY (1, 1) NOT NULL ,
	[ScreenName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Password] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Email] [nvarchar] (75) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[ForumView] [int] NOT NULL CONSTRAINT [DF_Users_ForumView] DEFAULT (2),
	[ProfileApproved] [bit] NOT NULL CONSTRAINT [DF_Users_ProfileApproved] DEFAULT (1),
	[Approved] [bit] NOT NULL CONSTRAINT [DF_Users_Approved] DEFAULT (1),
	[Trusted] [bit] NOT NULL CONSTRAINT [DF_Users_Trusted] DEFAULT (0),
	[FakeEmail] [nvarchar] (75) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_FakeEmail] DEFAULT (''),
	[URL] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_URL] DEFAULT (''),
	[Signature] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_Users_Signature] DEFAULT (''),
	[DateCreated] [datetime] NOT NULL CONSTRAINT [DF_Users_DateCreated] DEFAULT (getdate()),
	[TrackYourPosts] [bit] NOT NULL CONSTRAINT [DF_Users_TrackYourPosts] DEFAULT (0),
	[LastLogin] [datetime] NOT NULL CONSTRAINT [DF_Users_LastLogin] DEFAULT (getdate()),
	[LastActivity] [datetime] NOT NULL CONSTRAINT [DF_Users_LastActivity] DEFAULT (getdate()),
	[TimeZone] [int] NOT NULL CONSTRAINT [DF_Users_TimeZone] DEFAULT ((-5)),
	[Location] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_Location] DEFAULT (''),
	[Occupation] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_Occupation] DEFAULT (''),
	[Interests] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_Interests] DEFAULT (''),
	[MSN] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_MSN] DEFAULT (''),
	[Yahoo] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_Yahoo] DEFAULT (''),
	[AIM] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_AIM] DEFAULT (''),
	[ICQ] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_ICQ] DEFAULT (''),
	[TotalPosts] [int] NOT NULL CONSTRAINT [DF_Users_TotalPosts] DEFAULT (0),
	[HasAvatar] [bit] NOT NULL CONSTRAINT [DF_Users_HasAvatar] DEFAULT (0),
	[ShowUnreadTopicsOnly] [bit] NOT NULL CONSTRAINT [DF_Users_ShowUnreadTopicsOnly] DEFAULT (0),
	[Style] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_Style_1] DEFAULT (N'default'),
	[ShowAvatar] [bit] NOT NULL CONSTRAINT [DF_Users_ShowAvatar] DEFAULT (0),
	[DateFormat] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_DateFormat] DEFAULT (N'MM-dd-yyyy'),
	[PostViewOrder] [bit] NOT NULL CONSTRAINT [DF_Users_PostViewOrder] DEFAULT (0),
	[FlatView] [bit] NOT NULL CONSTRAINT [DF_Users_FlatView] DEFAULT (1),
	[DisplayInMemberList] [bit] NOT NULL CONSTRAINT [DF_Users_DisplayInMemberList] DEFAULT (1),
	[AvatarUrl] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__Users__AvatarUrl__6D6238AF] DEFAULT (''),
	[AvatarType] [int] NOT NULL CONSTRAINT [DF__Users__AvatarTyp__6E565CE8] DEFAULT (1),
	[Attributes] [binary] (4) NOT NULL CONSTRAINT [DF_Users_Attributes] DEFAULT (0),
	CONSTRAINT [PK_Users] PRIMARY KEY  CLUSTERED 
	(
		[UserName]
	)  ON [PRIMARY] ,
	CONSTRAINT [IX_Users_UniqueEmail] UNIQUE  NONCLUSTERED 
	(
		[Email]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO